Maybe someone can help me with this issue. My site has a slow query:
SELECT DISTINCT i.*, g.title AS groupname, c.name AS category, v.name AS author, w.name as moderator, u.name AS editor
FROM p38xt_k2_items as i
LEFT JOIN p38xt_k2_categories AS c ON c.id = i.catid
LEFT JOIN p38xt_viewlevels AS g ON g.id = i.access
LEFT JOIN p38xt_users AS u ON u.id = i.checked_out
LEFT JOIN p38xt_users AS v ON v.id = i.created_by
LEFT JOIN p38xt_users AS w ON w.id = i.modified_by
WHERE i.trash=0 ORDER BY i.id DESC LIMIT 0, 50;
I have checked every module that does k2 feeds, but was unable to find the 50 limit.
I also opened all .php of the /modules/* but even there I could not find: SELECT DISTINCT i.*, g.title
Does someone know were this query might be generated?! Is there any Joomla Extension that can track the queries executed from the modules?!
Solution: The issue of this problem was the K2 multicategory plugin that I was using on the site!