Денис спасибо за пояснения.
На сервере стоит 128
Application 0.000 seconds (+0.000); 1.33 MB (+1.328) - afterLoad
Application 0.096 seconds (+0.096); 11.50 MB (+10.176) - afterInitialise
Application 0.110 seconds (+0.014); 13.47 MB (+1.963) - afterRoute
Application 3.509 seconds (+3.399); 24.03 MB (+10.562) - afterDispatch
Application 3.522 seconds (+0.014); 25.27 MB (+1.243) - beforeRenderModule mod_jbzoo_basket (корзина)
Application 3.524 seconds (+0.002); 25.41 MB (+0.141) - afterRenderModule mod_jbzoo_basket (корзина)
Application 3.525 seconds (+0.001); 25.41 MB (-0.001) - beforeRenderModule mod_menu (Главное меню)
Application 3.533 seconds (+0.008); 25.61 MB (+0.199) - afterRenderModule mod_menu (Главное меню)
Application 3.539 seconds (+0.006); 26.06 MB (+0.446) - beforeRenderModule mod_breadcrumbs (Хлебные крошки)
Application 3.542 seconds (+0.003); 26.10 MB (+0.041) - afterRenderModule mod_breadcrumbs (Хлебные крошки)
Application 3.544 seconds (+0.002); 26.10 MB (+0.003) - beforeRenderModule mod_menu (Наши двери)
Application 3.554 seconds (+0.010); 26.18 MB (+0.076) - afterRenderModule mod_menu (Наши двери)
Application 3.554 seconds (+0.000); 26.12 MB (-0.052) - beforeRenderModule mod_jbzoo_search (Быстрый поиск)
Application 3.601 seconds (+0.047); 27.29 MB (+1.161) - afterRenderModule mod_jbzoo_search (Быстрый поиск)
Application 3.602 seconds (+0.001); 27.27 MB (-0.014) - beforeRenderModule mod_menu (Интересное о дверях || Советы, материалы)
Application 3.605 seconds (+0.003); 27.30 MB (+0.024) - afterRenderModule mod_menu (Интересное о дверях || Советы, материалы)
Application 3.618 seconds (+0.012); 27.59 MB (+0.298) - beforeRenderModule mod_menu (Нижнее меню)
Application 3.621 seconds (+0.003); 27.62 MB (+0.024) - afterRenderModule mod_menu (Нижнее меню)
Application 3.634 seconds (+0.013); 27.55 MB (-0.064) - afterRender
Исп. Памяти
27.59 MB (28,933,336 Bytes)
32 SQL-запросов зафиксировано
SELECT `data`
FROM `jbzoo_session`
WHERE `session_id` = 'e3593104dd11efba7f6daa1eb373df92'
DELETE
FROM `jbzoo_session`
WHERE `time` < '1380777895'
SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,m.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM jbzoo_menu AS m
LEFT JOIN jbzoo_extensions AS e
ON m.component_id = e.extension_id
WHERE m.published = 1
AND m.parent_id > 0
AND m.client_id = 0
ORDER BY m.lft
SELECT *
FROM jbzoo_zoo_application
WHERE id = 11
SELECT b.rules
FROM jbzoo_assets AS a
LEFT JOIN jbzoo_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE (a.name = 'root.1')
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lft
SELECT b.id
FROM jbzoo_usergroups AS a
LEFT JOIN jbzoo_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 1
SET SESSION group_concat_max_len = 1048576
SELECT c.*, GROUP_CONCAT(DISTINCT i.id) as item_ids
FROM jbzoo_zoo_category as c USE INDEX (APPLICATIONID_ID_INDEX)
LEFT JOIN jbzoo_zoo_category_item as ci
ON ci.category_id = c.id
LEFT JOIN jbzoo_zoo_item AS i USE INDEX (MULTI_INDEX2)
ON ci.item_id = i.id
AND i.access IN (1)
AND i.state = 1
AND (i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2013-10-04 05:24:55')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2013-10-04 05:24:55')
WHERE c.application_id = 11
AND c.published = 1
GROUP BY c.id
SELECT a.*
FROM jbzoo_zoo_item AS a
LEFT JOIN jbzoo_zoo_category_item AS b
ON a.id = b.item_id
WHERE a.application_id = 11
AND b.category_id = 202
AND access IN (1)
AND a.state = 1
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2013-10-04 05:24:55')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2013-10-04 05:24:55')
GROUP BY a.id
ORDER BY a.priority DESC, a.access+0<>0 DESC, a.access+0, a.access
LIMIT 0,20
SELECT b.id
FROM jbzoo_zoo_category_item AS a JOIN jbzoo_zoo_category AS b
ON a.category_id = b.id
WHERE a.item_id=31485
AND b.published = 1 UNION SELECT 0
FROM jbzoo_zoo_category_item AS a
WHERE a.item_id=31485
AND a.category_id = 0
SELECT b.id
FROM jbzoo_zoo_category_item AS a JOIN jbzoo_zoo_category AS b
ON a.category_id = b.id
WHERE a.item_id=31486
AND b.published = 1 UNION SELECT 0
FROM jbzoo_zoo_category_item AS a
WHERE a.item_id=31486
AND a.category_id = 0
SELECT b.id
FROM jbzoo_zoo_category_item AS a JOIN jbzoo_zoo_category AS b
ON a.category_id = b.id
WHERE a.item_id=31487
AND b.published = 1 UNION SELECT 0
FROM jbzoo_zoo_category_item AS a
WHERE a.item_id=31487
AND a.category_id = 0
SELECT b.id
FROM jbzoo_zoo_category_item AS a JOIN jbzoo_zoo_category AS b
ON a.category_id = b.id
WHERE a.item_id=31488
AND b.published = 1 UNION SELECT 0
FROM jbzoo_zoo_category_item AS a
WHERE a.item_id=31488
AND a.category_id = 0
SELECT b.id
FROM jbzoo_zoo_category_item AS a JOIN jbzoo_zoo_category AS b
ON a.category_id = b.id
WHERE a.item_id=31489
AND b.published = 1 UNION SELECT 0
FROM jbzoo_zoo_category_item AS a
WHERE a.item_id=31489
AND a.category_id = 0
SELECT b.id
FROM jbzoo_zoo_category_item AS a JOIN jbzoo_zoo_category AS b
ON a.category_id = b.id
WHERE a.item_id=31490
AND b.published = 1 UNION SELECT 0
FROM jbzoo_zoo_category_item AS a
WHERE a.item_id=31490
AND a.category_id = 0
SELECT b.id
FROM jbzoo_zoo_category_item AS a JOIN jbzoo_zoo_category AS b
ON a.category_id = b.id
WHERE a.item_id=31491
AND b.published = 1 UNION SELECT 0
FROM jbzoo_zoo_category_item AS a
WHERE a.item_id=31491
AND a.category_id = 0
SELECT b.id
FROM jbzoo_zoo_category_item AS a JOIN jbzoo_zoo_category AS b
ON a.category_id = b.id
WHERE a.item_id=31493
AND b.published = 1 UNION SELECT 0
FROM jbzoo_zoo_category_item AS a
WHERE a.item_id=31493
AND a.category_id = 0
SELECT b.id
FROM jbzoo_zoo_category_item AS a JOIN jbzoo_zoo_category AS b
ON a.category_id = b.id
WHERE a.item_id=31494
AND b.published = 1 UNION SELECT 0
FROM jbzoo_zoo_category_item AS a
WHERE a.item_id=31494
AND a.category_id = 0
SELECT b.id
FROM jbzoo_zoo_category_item AS a JOIN jbzoo_zoo_category AS b
ON a.category_id = b.id
WHERE a.item_id=31495
AND b.published = 1 UNION SELECT 0
FROM jbzoo_zoo_category_item AS a
WHERE a.item_id=31495
AND a.category_id = 0
SELECT b.id
FROM jbzoo_zoo_category_item AS a JOIN jbzoo_zoo_category AS b
ON a.category_id = b.id
WHERE a.item_id=31496
AND b.published = 1 UNION SELECT 0
FROM jbzoo_zoo_category_item AS a
WHERE a.item_id=31496
AND a.category_id = 0
SELECT b.id
FROM jbzoo_zoo_category_item AS a JOIN jbzoo_zoo_category AS b
ON a.category_id = b.id
WHERE a.item_id=31497
AND b.published = 1 UNION SELECT 0
FROM jbzoo_zoo_category_item AS a
WHERE a.item_id=31497
AND a.category_id = 0
SELECT b.id
FROM jbzoo_zoo_category_item AS a JOIN jbzoo_zoo_category AS b
ON a.category_id = b.id
WHERE a.item_id=31498
AND b.published = 1 UNION SELECT 0
FROM jbzoo_zoo_category_item AS a
WHERE a.item_id=31498
AND a.category_id = 0
SELECT b.id
FROM jbzoo_zoo_category_item AS a JOIN jbzoo_zoo_category AS b
ON a.category_id = b.id
WHERE a.item_id=31500
AND b.published = 1 UNION SELECT 0
FROM jbzoo_zoo_category_item AS a
WHERE a.item_id=31500
AND a.category_id = 0
SELECT b.id
FROM jbzoo_zoo_category_item AS a JOIN jbzoo_zoo_category AS b
ON a.category_id = b.id
WHERE a.item_id=31501
AND b.published = 1 UNION SELECT 0
FROM jbzoo_zoo_category_item AS a
WHERE a.item_id=31501
AND a.category_id = 0
SELECT b.id
FROM jbzoo_zoo_category_item AS a JOIN jbzoo_zoo_category AS b
ON a.category_id = b.id
WHERE a.item_id=31502
AND b.published = 1 UNION SELECT 0
FROM jbzoo_zoo_category_item AS a
WHERE a.item_id=31502
AND a.category_id = 0
SELECT b.id
FROM jbzoo_zoo_category_item AS a JOIN jbzoo_zoo_category AS b
ON a.category_id = b.id
WHERE a.item_id=31503
AND b.published = 1 UNION SELECT 0
FROM jbzoo_zoo_category_item AS a
WHERE a.item_id=31503
AND a.category_id = 0
SELECT b.id
FROM jbzoo_zoo_category_item AS a JOIN jbzoo_zoo_category AS b
ON a.category_id = b.id
WHERE a.item_id=31504
AND b.published = 1 UNION SELECT 0
FROM jbzoo_zoo_category_item AS a
WHERE a.item_id=31504
AND a.category_id = 0
SELECT b.id
FROM jbzoo_zoo_category_item AS a JOIN jbzoo_zoo_category AS b
ON a.category_id = b.id
WHERE a.item_id=31509
AND b.published = 1 UNION SELECT 0
FROM jbzoo_zoo_category_item AS a
WHERE a.item_id=31509
AND a.category_id = 0
SELECT b.id
FROM jbzoo_zoo_category_item AS a JOIN jbzoo_zoo_category AS b
ON a.category_id = b.id
WHERE a.item_id=31510
AND b.published = 1 UNION SELECT 0
FROM jbzoo_zoo_category_item AS a
WHERE a.item_id=31510
AND a.category_id = 0
SELECT params
FROM jbzoo_extensions AS e
WHERE e.element='com_widgetkit'
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM jbzoo_modules AS m
LEFT JOIN jbzoo_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN jbzoo_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
WHERE m.published = 1
AND e.enabled = 1
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2013-10-04 05:24:55')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2013-10-04 05:24:55')
AND m.access IN (1,1)
AND m.client_id = 0
AND (mm.menuid = 416 OR mm.menuid <= 0)
ORDER BY m.position, m.ordering
UPDATE `jbzoo_session`
SET `data` = '__default|a:9:{s:15:\"session.counter\";i:2;s:19:\"session.timer.start\";i:1380864285;s:18:\"session.timer.last\";i:1380864285;s:17:\"session.timer.now\";i:1380864295;s:24:\"session.client.forwarded\";s:14:\"195.91.133.194\";s:22:\"session.client.browser\";s:101:\"Mozilla/5.0 (Windows NT 6.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/29.0.1547.76 Safari/537.36\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":26:{s:9:\"\0*\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:0:{}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";a:1:{i:0;i:1;}s:14:\"\0*\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;s:10:\"superadmin\";N;}s:13:\"session.token\";s:32:\"5bb755b578e509d8a8201825770256c1\";}' , `time` = '1380864299'
WHERE `session_id` = 'e3593104dd11efba7f6daa1eb373df92'
13 типов SQL-запросов зафиксировано, отсортировано по вхождениям Запросы типа SELECT:
20 × SELECT b.id
FROM jbzoo_zoo_category_item AS a JOIN jbzoo_zoo_category AS b
ON a.category_id = b.id
1 × SELECT a.*
FROM jbzoo_zoo_item AS a
LEFT JOIN jbzoo_zoo_category_item AS b
ON a.id = b.item_id
1 × SELECT params
FROM jbzoo_extensions AS e
1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM jbzoo_modules AS m
LEFT JOIN jbzoo_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN jbzoo_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
1 × SELECT c.*, GROUP_CONCAT(DISTINCT i.id) as item_ids
FROM jbzoo_zoo_category as c USE INDEX (APPLICATIONID_ID_INDEX)
LEFT JOIN jbzoo_zoo_category_item as ci
ON ci.category_id = c.id
LEFT JOIN jbzoo_zoo_item AS i USE INDEX (MULTI_INDEX2)
ON ci.item_id = i.id
AND i.access IN (1)
AND i.state = 1
AND (i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2013-10-04 05:24:55')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2013-10-04 05:24:55')
1 × SELECT b.id
FROM jbzoo_usergroups AS a
LEFT JOIN jbzoo_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,m.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM jbzoo_menu AS m
LEFT JOIN jbzoo_extensions AS e
ON m.component_id = e.extension_id
1 × SELECT *
FROM jbzoo_zoo_application
1 × SELECT b.rules
FROM jbzoo_assets AS a
LEFT JOIN jbzoo_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
1 × SELECT `data`
FROM `jbzoo_session`
Прочие SQL-запросы:
1 × UPDATE `jbzoo_session`
SET `data` = '__default|a:9:{s:15:\"session.counter\";i:2;s:19:\"session.timer.start\";i:1380864285;s:18:\"session.timer.last\";i:1380864285;s:17:\"session.timer.now\";i:1380864295;s:24:\"session.client.forwarded\";s:14:\"195.91.133.194\";s:22:\"session.client.browser\";s:101:\"Mozilla/5.0 (Windows NT 6.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/29.0.1547.76 Safari/537.36\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":26:{s:9:\"\0*\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:0:{}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";a:1:{i:0;i:1;}s:14:\"\0*\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;s:10:\"superadmin\";N;}s:13:\"session.token\";s:32:\"5bb755b578e509d8a8201825770256c1\";}' , `time` = '1380864299'
1 ×
SET SESSION group_concat_max_len = 104857
1 × DELETE
FROM `jbzoo_session`
Еще другая категория
еще
This topic is locked
