Посмотрел вывод в режиме отладки - 27 запросов, большая часть из них принадлежит JoomFish. Это нормальная ситуация? Если нет, тот как количетво запросов можно оптимизировать?
1.
SELECT template
FROM jos_templates_menu
WHERE client_id = 0
AND (menuid = 0 OR menuid = 1)
ORDER BY menuid DESC
LIMIT 0, 1
2.
SELECT id, title, module, position, content, showtitle, control, params
FROM jos_modules AS m
LEFT JOIN jos_modules_menu AS mm
ON mm.moduleid = m.id
WHERE m.published = 1
AND m.access <= 0
AND m.client_id = 0
AND ( mm.menuid = 1 OR mm.menuid = 0 )
ORDER BY position, ordering
3.
SELECT jf_content.reference_field, jf_content.value, jf_content.reference_id, jf_content.original_value
FROM jos_jf_content AS jf_content
WHERE jf_content.language_id=2
AND jf_content.published=1
AND jf_content.reference_id IN(41,54,31,49,53,29,50,56,43,36,51,25,1,38)
AND jf_content.reference_table='modules'
4.
SELECT a.*
FROM jos_zoo_core_item AS a
LEFT JOIN jos_zoo_core_category_item AS b
ON a.id = b.item_id
WHERE b.catalog_id = 1
AND b.category_id = 1
AND a.state = 1
AND a.access <= 0
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2010-01-19 20:43:27')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2010-01-19 20:43:27')
GROUP BY a.id
ORDER BY a.created DESC
LIMIT 0, 8
5.
SELECT jf_content.reference_field, jf_content.value, jf_content.reference_id, jf_content.original_value
FROM jos_jf_content AS jf_content
WHERE jf_content.language_id=2
AND jf_content.published=1
AND jf_content.reference_id IN(85,158,165,127,167,96,156)
AND jf_content.reference_table='zoo_core_item'
6.
SELECT id
FROM jos_components
WHERE `option` = 'com_zoo'
7.
SELECT *
FROM jos_menu
WHERE componentid = 43
AND published = 1
8.
SELECT jf_content.reference_field, jf_content.value, jf_content.reference_id, jf_content.original_value
FROM jos_jf_content AS jf_content
WHERE jf_content.language_id=2
AND jf_content.published=1
AND jf_content.reference_id IN(56,53,65,16,17)
AND jf_content.reference_table='menu'
9.
SELECT *
FROM jos_zoo_core_type
WHERE id = '6'
10.
SELECT *
FROM jos_zoo_type_hworld
WHERE item_id = 85
11.
SELECT jf_content.reference_field, jf_content.value, jf_content.reference_id, jf_content.original_value
FROM jos_jf_content AS jf_content
WHERE jf_content.language_id=2
AND jf_content.published=1
AND jf_content.reference_id IN(85)
AND jf_content.reference_table='zoo_type_hworld'
12.
SELECT *
FROM jos_zoo_type_hworld
WHERE item_id = 158
13.
SELECT jf_content.reference_field, jf_content.value, jf_content.reference_id, jf_content.original_value
FROM jos_jf_content AS jf_content
WHERE jf_content.language_id=2
AND jf_content.published=1
AND jf_content.reference_id IN(158)
AND jf_content.reference_table='zoo_type_hworld'
14.
SELECT *
FROM jos_zoo_type_hworld
WHERE item_id = 165
15.
SELECT jf_content.reference_field, jf_content.value, jf_content.reference_id, jf_content.original_value
FROM jos_jf_content AS jf_content
WHERE jf_content.language_id=2
AND jf_content.published=1
AND jf_content.reference_id IN(165)
AND jf_content.reference_table='zoo_type_hworld'
16.
SELECT *
FROM jos_zoo_type_hworld
WHERE item_id = 127
17.
SELECT jf_content.reference_field, jf_content.value, jf_content.reference_id, jf_content.original_value
FROM jos_jf_content AS jf_content
WHERE jf_content.language_id=2
AND jf_content.published=1
AND jf_content.reference_id IN(127)
AND jf_content.reference_table='zoo_type_hworld'
18.
SELECT *
FROM jos_zoo_type_hworld
WHERE item_id = 167
19.
SELECT jf_content.reference_field, jf_content.value, jf_content.reference_id, jf_content.original_value
FROM jos_jf_content AS jf_content
WHERE jf_content.language_id=2
AND jf_content.published=1
AND jf_content.reference_id IN(167)
AND jf_content.reference_table='zoo_type_hworld'
20.
SELECT *
FROM jos_zoo_type_hworld
WHERE item_id = 96
21.
SELECT jf_content.reference_field, jf_content.value, jf_content.reference_id, jf_content.original_value
FROM jos_jf_content AS jf_content
WHERE jf_content.language_id=2
AND jf_content.published=1
AND jf_content.reference_id IN(96)
AND jf_content.reference_table='zoo_type_hworld'
22.
SELECT *
FROM jos_zoo_type_hworld
WHERE item_id = 156
23.
SELECT jf_content.reference_field, jf_content.value, jf_content.reference_id, jf_content.original_value
FROM jos_jf_content AS jf_content
WHERE jf_content.language_id=2
AND jf_content.published=1
AND jf_content.reference_id IN(156)
AND jf_content.reference_table='zoo_type_hworld'
24.
SELECT *
FROM jos_languages
WHERE active=1
ORDER BY ordering
25.
SELECT m.*, c.`option` AS component
FROM jos_menu AS m
LEFT JOIN jos_components AS c
ON m.componentid = c.id
WHERE m.published = 1
ORDER BY m.sublevel, m.parent, m.ordering
26.
SELECT jf_content.reference_field, jf_content.value, jf_content.reference_id, jf_content.original_value
FROM jos_jf_content AS jf_content
WHERE jf_content.language_id=2
AND jf_content.published=1
AND jf_content.reference_id IN(66,58,47,1,6,67,53,17,68,56,42,65,60,16,20,57,19,61,70,46,62,71,54,21,48,14,63,69,59,55)
AND jf_content.reference_table='menu'
27.
SELECT jf_content.reference_field, jf_content.value, jf_content.reference_id, jf_content.original_value
FROM jos_jf_content AS jf_content
WHERE jf_content.language_id=1
AND jf_content.published=1
AND jf_content.reference_id IN(1)
AND jf_content.reference_table='menu'
01.12.2018, 16:04:39