-- HikaShop version -- : 2.6.4
-- Joomla version -- : 3.6.2
-- PHP version -- : 5.5.38
-- Error-message(debug-mod must be tuned on) -- : none
hi gus
im getting complaints from my host telling me im having hi cpu usage. they said this is one of the culprits.
Code:
1. Executed 12h 7m 10s ago for 54.227097 sec on Database --> Unknown (NOT FOUND / DELETED)
Date: 2018-05-25 00:37:37 Query_time: 54.227097 Rows_examined: 32: Rows_sent 15 Lock_time: 26.725440
# Schema: mayari79_l15t6we Last_errno: 0 Killed: 0 SELECT * FROM s0671ast_hikashop_filter WHERE filter_published = 1 AND (filter_access = 'all' OR filter_access LIKE '%,14,%') ORDER BY filter_ordering;
----------------------------------------------------------------------------------------------------
2. Executed 12h 7m 10s ago for 40.320099 sec on Database --> mayari79_l15t6we
Date: 2018-05-25 00:37:37 Query_time: 40.320099 Rows_examined: 32: Rows_sent 15 Lock_time: 13.004399
# Schema: mayari79_l15t6we Last_errno: 0 Killed: 0 SELECT * FROM s0671ast_hikashop_filter WHERE filter_published = 1 AND (filter_access = 'all' OR filter_access LIKE '%,14,%') ORDER BY filter_ordering;
the queries above according to them are slow and causing the problems.
can you tell me where this query is being done? is this query running even do no one is accessing the site.? if this is indeed causing the issue can you tell me how to fix this
thanks in advance
