slow query log в MySQL заполнен вот такими записями. Наблюдаются большие задержки при загрузке страниц. Подскажите, какая функция K2 за это отвечает?
SELECT COUNT(*) FROM xxxx_k2_items WHERE YEAR(created)=2014 AND MONTH(created)=11 AND DAY(created)=30 AND published=1 AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2014-11-05 11:55:46' ) AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2014-11-05 11:55:46' ) AND trash=0 AND access IN(1,1) AND EXISTS(SELECT * FROM xxxx_k2_categories WHERE id= xxxxx_k2_items.catid AND published=1 AND trash=0 AND access IN(1,1) );
Query_time: 11 Lock_time: 0 Rows_sent: 1 Rows_examined: 33108
Joomla 3.3.6 и K2 2.6.8
