Need help to identify what is causing the generation of this query so that we can eliminate it.
It is causing our site to timeout under times of heavy usage.
SELECT DISTINCT i . * , c.name AS categoryname, c.id AS categoryid, c.alias AS categoryalias, c.params AS categoryparams
FROM esqt7_k2_items AS i
LEFT JOIN esqt7_k2_categories AS c ON c.id = i.catid
WHERE i.published =1
AND i.access
IN ( 1, 1 )
AND i.trash =0
AND c.published =1
AND c.access
IN ( 1, 1 )
AND c.trash =0
AND (
i.publish_up = '0000-00-00 00:00:00'
OR i.publish_up <= '2013-08-13 13:04:12'
)
AND (
i.publish_down = '0000-00-00 00:00:00'
OR i.publish_down >= '2013-08-13 13:04:12'
)
AND i.catid
IN ( 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14 )
ORDER BY i.id DESC
LIMIT 0 , 10