Жил был один сайт, работал исправно на 1.3.0.4, обратил недавно внимание, что стали очень медленно грузится блоги, поглядел в отладку. Подскажите, нормально ли что для вывода одной статьи блога делается столько запросов?
#15 0.00034700 SELECT sectionid from jos_content WHERE id = 981
#16 0.00052800 SELECT COUNT( id ) FROM jos_menu WHERE type = 'content_item_link' AND published = 1
#17 0.00055100 SELECT id FROM jos_menu WHERE type = 'content_item_link' AND published = 1 AND link = 'index.php?option=com_content&task=view&id=981'
#18 0.00072100 SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub
FROM jos_content AS i
LEFT JOIN jos_sections AS s ON i.sectionid = s.id
LEFT JOIN jos_menu AS ms ON ms.componentid = s.id
LEFT JOIN jos_categories
#19 0.00088600 SELECT title_alias FROM jos_content WHERE id=981
#20 0.00030400 SELECT c.title AS category, a.title_alias AS title FROM jos_content as a LEFT JOIN jos_categories AS c ON a.catid=c.id WHERE a.id=981
#21 0.00010800 SELECT folder, element, published, params FROM jos_mambots WHERE published=1 AND folder = 'content' AND client_id=0 ORDER BY ordering ASC
#22 0.00034000 SELECT params FROM jos_mambots WHERE element = 'comment.content' AND folder = 'content'
#23 0.00011200 SELECT sectionid from jos_content WHERE id = 981
#24 0.00018700 SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub
FROM jos_content AS i
LEFT JOIN jos_sections AS s ON i.sectionid = s.id
LEFT JOIN jos_menu AS ms ON ms.componentid = s.id
LEFT JOIN jos_categories
#25 0.00012200 SELECT title_alias FROM jos_content WHERE id=981
#26 0.00031600 SELECT c.title AS category, a.title_alias AS title FROM jos_content as a LEFT JOIN jos_categories AS c ON a.catid=c.id WHERE a.id=981
#27 0.00015900 SELECT count(*)
FROM jos_comment
WHERE object_id = 981
AND object_group = 'com_content'
Ну и если статей 20-30 штук, умножаем это на 20-30....
установлен easysef, JComments (отключены ссылки в блогах) включен кеш (!) Каталог кеша доступен, но для com_content очень мало записей и они как-то быстро исчезают, хотя время кеша стоит 90000 в конфиге, и с кешированием всех других модулей и компонентов проблем нет
