Сообщений в теме: 11

[isay777]

Добрый день уважаемая тех поддержка. 

 

Сделал сайт на jbzoo еще на 1,6,1 потмо обновлял, в какой-то момент сайт стал очень долго грузиться, причем именно страницы jbzoo. 

Со страницами самой джумла все в порядке. 

 

Пробовал включать сильный КЭШ, в итоге плохо работала корзина и еще кучу проблем возникало. 

 

может посмотрите опытным взглядом. Что-то увидите 

 

dvery-pro  .ru

[SmetDenis]

Скиньте отчет системы jbzoo
Покажите данные профайлера Joomla (режим отладки в настройках Joomla + плагин)
Какой у вас хостинг, тариф параметры

[isay777]

Еще раз добрый вечер 

 

Отчет тут 

 

 

Про хостинг: 

ВПС - отличные показатели. На сервере лажат и другие проекты на jbzoo все летает. 

 

В режиме отладки куча ошибок, но не связанных с jbzoo 

Strict Standards: Non-static method Warp::getInstance() should not be called statically, assuming $this from incompatible context in /var/www/isay777/data/www/dvery-pro.ru/templates/yoo_vanilla/config.php on line 11

Strict Standards: Non-static method Warp::getInstance() should not be called statically, assuming $this from incompatible context in /var/www/isay777/data/www/dvery-pro.ru/templates/yoo_vanilla/warp/classes/helper.php on line 31

Strict Standards: Non-static method Warp::getInstance() should not be called statically, assuming $this from incompatible context in /var/www/isay777/data/www/dvery-pro.ru/templates/yoo_vanilla/warp/classes/helper.php on line 31

Strict Standards: Non-static method Warp::getInstance() should not be called statically, assuming $this from incompatible context in /var/www/isay777/data/www/dvery-pro.ru/templates/yoo_vanilla/warp/classes/helper.php on line 31

Strict Standards: Non-static method Warp::getInstance() should not be called statically, assuming $this from incompatible context in /var/www/isay777/data/www/dvery-pro.ru/templates/yoo_vanilla/warp/classes/helper.php on line 31

Strict Standards: Non-static method Warp::getInstance() should not be called statically, assuming $this from incompatible context in /var/www/isay777/data/www/dvery-pro.ru/templates/yoo_vanilla/warp/classes/helper.php on line 31

Strict Standards: Non-static method Warp::getInstance() should not be called statically, assuming $this from incompatible context in /var/www/isay777/data/www/dvery-pro.ru/templates/yoo_vanilla/warp/classes/helper.php on line 31

Strict Standards: Only variables should be passed by reference in /var/www/isay777/data/www/dvery-pro.ru/templates/yoo_vanilla/warp/warp.php on line 135

Strict Standards: Non-static method Warp::getInstance() should not be called statically, assuming $this from incompatible context in /var/www/isay777/data/www/dvery-pro.ru/templates/yoo_vanilla/warp/classes/helper.php on line 31

Strict Standards: Only variables should be assigned by reference in /var/www/isay777/data/www/dvery-pro.ru/templates/yoo_vanilla/warp/systems/joomla/helpers/modules.php on line 35

Strict Standards: Only variables should be assigned by reference in /var/www/isay777/data/www/dvery-pro.ru/templates/yoo_vanilla/warp/systems/joomla/helpers/modules.php on line 36

Strict Standards: Non-static method Warp::getInstance() should not be called statically, assuming $this from incompatible context in /var/www/isay777/data/www/dvery-pro.ru/templates/yoo_vanilla/warp/classes/helper.php on line 31

Strict Standards: Non-static method Warp::getInstance() should not be called statically, assuming $this from incompatible context in /var/www/isay777/data/www/dvery-pro.ru/templates/yoo_vanilla/warp/classes/helper.php on line 31

Strict Standards: Non-static method Warp::getInstance() should not be called statically, assuming $this from incompatible context in /var/www/isay777/data/www/dvery-pro.ru/templates/yoo_vanilla/warp/classes/helper.php on line 31

Strict Standards: Non-static method Warp::getInstance() should not be called statically, assuming $this from incompatible context in /var/www/isay777/data/www/dvery-pro.ru/templates/yoo_vanilla/warp/classes/helper.php on line 31

Strict Standards: Non-static method Warp::getInstance() should not be called statically, assuming $this from incompatible context in /var/www/isay777/data/www/dvery-pro.ru/templates/yoo_vanilla/warp/classes/helper.php on line 31

Strict Standards: Non-static method Warp::getInstance() should not be called statically, assuming $this from incompatible context in /var/www/isay777/data/www/dvery-pro.ru/templates/yoo_vanilla/html/config.php on line 13

[SmetDenis]

В режиме отладки куча ошибок, но не связанных с jbzoo

Я говорил про профайлер, который показывается в футере сайта.






Интересует
- кол-во запросов в базу, их общее время выполнения и память
- скриншот разворота профилирования
- общее кол-во памяти

[isay777]

Денис спасибо за пояснения. 

На сервере стоит 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` 

Еще другая категория 

 

 

еще 

 

[SmetDenis]

Кажется я знаю в чем дело
Покажите содержимое используемого шаблона subcategory ?

[isay777]

В сабкатегори нечего не менял, скорее  в категории 

 

Вот subcategory.php

<?php
/**
 * JBZoo App is universal Joomla CCK, application for YooTheme Zoo component
 *
 * @package     jbzoo
 * @version     2.x Pro
 * @author      JBZoo App http://jbzoo.com
 * @copyright   Copyright (C) JBZoo.com,  All rights reserved.
 * @license     http://jbzoo.com/license-pro.php JBZoo Licence
 * @coder       Denis Smetannikov <denis@jbzoo.com>
 */

// no direct access
defined('_JEXEC') or die('Restricted access');


$this->app->jbdebug->mark('layout::subcategory(' . $vars['object']->id . ')::start');

// set vars
$subcategory = $vars['object'];
$params = $subcategory->getParams('site');
$link = $this->app->route->category($subcategory);
$task = $this->app->jbrequest->get('task', 'category');

// teaser content
$text = $params->get('content.category_teaser_text', '');
$imageAlign = $params->get('template.subcategory_teaser_image_align', 'left');

// items
$itemsOrder = $vars['params']->get('config.item_order', 'none');
$maxItems = $vars['params']->get('template.subcategory_items_count', 5);
$showCount = $vars['params']->get('template.subcategory_items_count_show', 1);

$items = array();
$countItems = 0;
if ($showCount || $maxItems != "0" || $maxItems == "-1") {
    $items      = $this->app->table->item->getByCategory($subcategory->application_id, $subcategory->id, true, null, $itemsOrder, 0, $maxItems);
    $countItems = $subcategory->itemCount();
}

if ($maxItems != "-1" && $countItems > $maxItems) {
    $items = array_slice($items, 0, $maxItems);
}

$image = $this->app->jbimage->get('category_teaser_image', $params);

?>
    <div class="subcategory subcategory-<?php echo $subcategory->alias; ?>">

<?php if ($vars['params']->get('template.subcategory_teaser_image', 1) && $image['src']) : ?>
    <div class="subcategory-image align-<?php echo $imageAlign; ?>">
        <a href="<?php echo $link; ?>" title="<?php echo $subcategory->name; ?>"><img
                src="<?php echo $image['src']; ?>" <?php echo $image['width_height']; ?>
                alt="<?php echo $subcategory->name; ?>"
                title="<?php echo $subcategory->name; ?>"
                /></a>
    </div>
<?php endif; ?>


    <h2 class="subcategory-title">
        <a href="<?php echo $link; ?>" title="<?php echo $subcategory->name; ?>"><?php echo $subcategory->name; ?></a>
        <?php if ($showCount && $countItems != 0) : ?><span>(<?php echo $countItems; ?>)</span><?php endif; ?>
    </h2>


<?php if ($vars['params']->get('template.subcategory_teaser_text', 1) && strlen($text) > 0) : ?>
    <div class="subcategory-description"><?php echo $text; ?></div>
<?php endif; ?>


<?php if (in_array($task, array('category', 'frontpage'))) : ?>
    <?php if ($maxItems != 0 && count($items) > 0) : ?>
        <div class="clear clr"></div>
        <div class="subcategory-items">
            <?php
            foreach ($items as $item) {
                echo $this->app->jblayout->renderItem($item, 'subcategory_item');
            }
            ?>
        </div>
    <?php endif; ?>
<?php endif; ?>

    <div class="clear clr"></div>
</div>

<?php
$this->app->jbdebug->mark('layout::subcategory(' . $vars['object']->id . ')::finish');

А вот это категория

<?php
/**
 * JBZoo App is universal Joomla CCK, application for YooTheme Zoo component
 *
 * @package     jbzoo
 * @version     2.x Pro
 * @author      JBZoo App http://jbzoo.com
 * @copyright   Copyright (C) JBZoo.com,  All rights reserved.
 * @license     http://jbzoo.com/license-pro.php JBZoo Licence
 * @coder       Denis Smetannikov <denis@jbzoo.com>
 */

// no direct access
defined('_JEXEC') or die('Restricted access');

$this->app->jbdebug->mark('template::category::start');
$this->app->jblayout->setView($this);
$currentView = $this->app->jbrequest->get('view', 'category');
$currentTask = $this->app->jbrequest->get('task', 'category');


if (isset($this->category)) {
    if ($currentView == 'frontpage' || $currentTask == 'frontpage') {
        $category = $this->application;
    } else {
        $category = $this->category;
    }
}

if (!$this->app->jbcache->start($this->params->get('config.lastmodified'))) {
    $this->app->jbwrapper->start();

    // category render
    if (isset($category)) {
        echo $this->app->jblayout->render($currentView, $category);
    }

    // alphaindex render
    if ($this->params->get('template.show_alpha_index', 0)) {
        echo $this->app->jblayout->render('alphaindex', $this->alpha_index);
    }
// pagination render2
    if ($this->params->get('template.item_pagination', 1)) {
        echo $this->app->jblayout->render('pagination', $this->pagination, array('link' => $this->pagination_link));
    }

    // subcategories render
    if (isset($category)) {
        $categories = $this->category->getChildren();
        if ($this->params->get('template.subcategory_show', 1) && count($categories)) {
            echo $this->app->jblayout->render('subcategories', $categories);
        }
    }

    // category items render
    if ($this->params->get('config.items_show', 1) && count($this->items)) {

        if (isset($category) && $this->params->get('config.show_feed_link', 1) && $currentView == 'category') {
            $link = $this->params->get('config.alternate_feed_link');
            if (!$link && isset($category->application_id)) {
                $link = $this->app->route->feed($category, 'rss');
                $link = JRoute::_($link);

                echo '<a class="rsslink" target="_blank" href="' . $link . '" title="' . JText::_('RSS feed') . '">' .
                    JText::_('RSS feed') . '</a>';

                echo '<div class="clear clr"></div>';
            }
        }

        echo $this->app->jblayout->render('items', $this->items);

    } else {
        echo $this->app->jblayout->render('items_empty', $category);
    }

    // pagination render
    if ($this->params->get('template.item_pagination', 1)) {
        echo $this->app->jblayout->render('pagination', $this->pagination, array('link' => $this->pagination_link));
    }

    $this->app->jbwrapper->end();
    $this->app->jbcache->stop();
}

// desc
?>
    
<?php if ($this->params->get('template.category_text')): ?>
			<div class="description">
			<?php echo $category->getText($category->description); ?>
			</div>
			<?php endif; ?>
<?php
//end desc

$this->app->jbdebug->mark('template::category::finish');

[SmetDenis]

Попробуйте subcategory заменить на этот код

<?php
/**
 * JBZoo App is universal Joomla CCK, application for YooTheme Zoo component
 *
 * @package     jbzoo
 * @version     2.x Pro
 * @author      JBZoo App http://jbzoo.com
 * @copyright   Copyright (C) JBZoo.com,  All rights reserved.
 * @license     http://jbzoo.com/license-pro.php JBZoo Licence
 * @coder       Denis Smetannikov <denis@jbzoo.com>
 */
 
// no direct access
defined('_JEXEC') or die('Restricted access');
 

$this->app->jbdebug->mark('layout::subcategory(' . $vars['object']->id . ')::start');

// set vars
$subcategory = $vars['object'];
$params = $subcategory->getParams('site');
$link = $this->app->route->category($subcategory);
$task = $this->app->jbrequest->get('task', 'category');

// teaser content
$text = $params->get('content.category_teaser_text', '');
$imageAlign = $params->get('template.subcategory_teaser_image_align', 'left');

// items
$itemsOrder = $vars['params']->get('config.item_order', 'none');
$maxItems = $vars['params']->get('template.subcategory_items_count', 5);
$showCount = $vars['params']->get('template.subcategory_items_count_show', 1);

$items = array();
$countItems = 0;
if ($showCount || $maxItems != "0" || $maxItems == "-1") {
    $items      = JBModelCategory::model()->getItemsByCategory($subcategory->application_id, $subcategory->id, $itemsOrder, $maxItems);
    $countItems = $subcategory->itemCount();
}

$image = $this->app->jbimage->get('category_teaser_image', $params); 

?>
    <div class="subcategory subcategory-<?php echo $subcategory->alias; ?>">
 
<?php if ($vars['params']->get('template.subcategory_teaser_image', 1) && $image['src']) : ?>
    <div class="subcategory-image align-<?php echo $imageAlign; ?>">
        <a href="<?php echo $link; ?>" title="<?php echo $subcategory->name; ?>"><img
                src="<?php echo $image['src']; ?>" <?php echo $image['width_height']; ?>
                alt="<?php echo $subcategory->name; ?>"
                title="<?php echo $subcategory->name; ?>"
                /></a>
    </div>
<?php endif; ?>
 
 
    <h2 class="subcategory-title">
        <a href="<?php echo $link; ?>" title="<?php echo $subcategory->name; ?>"><?php echo $subcategory->name; ?></a>
        <?php if ($showCount && $countItems != 0) : ?><span>(<?php echo $countItems; ?>)</span><?php endif; ?>
    </h2>
 
 
<?php if ($vars['params']->get('template.subcategory_teaser_text', 1) && strlen($text) > 0) : ?>
    <div class="subcategory-description"><?php echo $text; ?></div>
<?php endif; ?>
 
 
<?php if (in_array($task, array('category', 'frontpage'))) : ?>
    <?php if ($maxItems != 0 && count($items) > 0) : ?>
        <div class="clear clr"></div>
        <div class="subcategory-items">
            <?php
            foreach ($items as $item) {
                echo $this->app->jblayout->renderItem($item, 'subcategory_item');
            }
            ?>
        </div>
    <?php endif; ?>
<?php endif; ?>
 
    <div class="clear clr"></div>
</div>
 
<?php
$this->app->jbdebug->mark('layout::subcategory(' . $vars['object']->id . ')::finish');

Должно помочь.

Объясню причину.
В одной из версий мы допустили промах в производительности вывода - была не корректная выборка из базы данных.
Потом это исправили, но при обновлении патчем изменится только дефолтный шаблон.
А если шаблон переопределен, то соответственно патч не изменит ничего.


Если проблема останется - пишите. Но тогда мне нужен временный ftp доступ.

[isay777]

После замены кода категори имеющие подкатегории перестали работать. 

 

Наверное проблема в файле category.php а не subcategory 

 

в личку все написал 

[SmetDenis]

Я посмотрел ваш сайт.

Нашел две основных причины тормозов.
- отсутствие APC. Поставьте - это уменьшит потребление памяти и частично оптимизирует загрузку всех сайтов сразу.

- элемент цены в тизере. Дело в их количестве на странице - используется 40 раз (20 дверей по 2 элемента в каждом).
По отдельности он загружается примерно 0.1 cек. (с APC будет быстрее)
Итого +3.5-4.0 сек к загрузке сайта.

Я сейчас затрудняюсь сказать как ускорить элемент (он довольно большой и сложный),
но обязательно с этим разберусь и постараюсь найти решение.

На данный момент могу посоветовать вам установить APC (отличная вещь) или XCache.
Уменьшить кол-во материалов на странице.
Пожертвовать выводом либо цены, либо артикулом.

+ Подождать следующего обновления, я постараюсь оптимизировать элемент на сколько смогу.