Тормоза - ZOO 2.х

   1.
      SELECT *
        FROM jos_session
        WHERE session_id = 'c14a77c269d9d660e804bf3bc75bc415'
   2.
      DELETE
        FROM jos_session
        WHERE ( time < '1274595878' )
   3.
      SELECT *
        FROM jos_session
        WHERE session_id = 'c14a77c269d9d660e804bf3bc75bc415'
   4.
      UPDATE `jos_session`
        SET `time`='1274597678',`userid`='0',`usertype`='',`username`='',`gid`='0',`guest`='1',`client_id`='0',`data`='__default|a:9:{s:15:\"session.counter\";i:4;s:19:\"session.timer.start\";i:1274597628;s:18:\"session.timer.last\";i:1274597658;s:17:\"session.timer.now\";i:1274597676;s:24:\"session.client.forwarded\";s:12:\"94.181.88.64\";s:22:\"session.client.browser\";s:85:\"Mozilla/5.0 (Windows; U; Windows NT 6.0; ru; rv:1.9.2.3) Gecko/20100401 Firefox/3.6.3\";s:8:\"registry\";O:9:\"JRegistry\":3:{s:17:\"_defaultNameSpace\";s:7:\"session\";s:9:\"_registry\";a:1:{s:7:\"session\";a:1:{s:4:\"data\";O:8:\"stdClass\":0:{}}}s:7:\"_errors\";a:0:{}}s:4:\"user\";O:5:\"JUser\":20:{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:3:\"gid\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:3:\"aid\";i:0;s:5:\"guest\";i:1;s:7:\"_params\";O:10:\"JParameter\":7:{s:4:\"_raw\";s:0:\"\";s:4:\"_xml\";N;s:9:\"_elements\";a:0:{}s:12:\"_elementPath\";a:1:{i:0;s:64:\"/var/www/izhclub.ru/docs/libraries/joomla/html/parameter/element\";}s:17:\"_defaultNameSpace\";s:8:\"_default\";s:9:\"_registry\";a:1:{s:8:\"_default\";a:1:{s:4:\"data\";O:8:\"stdClass\":0:{}}}s:7:\"_errors\";a:0:{}}s:9:\"_errorMsg\";N;s:7:\"_errors\";a:0:{}s:10:\"superadmin\";b:0;}s:13:\"session.token\";s:32:\"85a5b995479752acad862b2ceac1f562\";}'
        WHERE session_id='c14a77c269d9d660e804bf3bc75bc415'
   5.
      SELECT *
        FROM jos_components
        WHERE parent = 0
   6.
      SELECT folder AS type, element AS name, params
        FROM jos_plugins
        WHERE published >= 1
        AND access <= 0
        ORDER BY ordering
   7.
      SELECT template
        FROM jos_templates_menu
        WHERE client_id = 0
        AND (menuid = 0 OR menuid = 255)
        ORDER BY menuid DESC
        LIMIT 0, 1
   8.
      SELECT *
        FROM jos_zoo_application
        WHERE id = 1
   9.
      SELECT *
        FROM jos_zoo_category
        WHERE id = 0
  10.
      SELECT *
        FROM jos_zoo_category
        WHERE application_id = 1
        ORDER BY ordering
  11.
      SELECT a.category_id, count(b.id) AS item_count
        FROM jos_zoo_category_item AS a JOIN jos_zoo_item AS b
        ON b.id = a.item_id
        AND b.access <= 0
        AND (b.state = 1
        AND ('2010-05-23 06:54:38' BETWEEN b.publish_up
        AND b.publish_down OR '2010-05-23 06:54:38' >= b.publish_up
        AND b.publish_down = '0000-00-00 00:00:00'))
        GROUP BY a.category_id
  12.
      SELECT a.*
        FROM jos_zoo_item AS a
        LEFT JOIN jos_zoo_category_item AS b
        ON a.id = b.item_id
        WHERE a.application_id = 1
        AND b.category_id  = 0
        AND a.access <= 0
        AND a.state = 1
        AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2010-05-23 06:54:38')
        AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2010-05-23 06:54:38')
        GROUP BY a.id
        ORDER BY a.priority DESC , a.created DESC
  13.
      SELECT *
        FROM jos_zoo_category
        WHERE id = 0
  14.
      SELECT *
        FROM jos_zoo_category
        WHERE id = 0
  15.
      SELECT *
        FROM jos_zoo_item
        WHERE id = 1
  16.
      SELECT b.*
        FROM jos_zoo_category_item AS a JOIN jos_zoo_category AS b
        ON b.id = a.category_id
        WHERE a.item_id=1
        AND b.published = 1
  17.
      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 = 255 OR mm.menuid = 0 )
        ORDER BY position, ordering

   1.
      /libraries/joomla/DATABASE/TABLE.php:247
      /libraries/joomla/session/storage/DATABASE.php:70
      Execute time:0.000859 sec.
      SELECT *
        FROM jos_session
        WHERE session_id = 'helf4t0g7vosgk3u3smtrdnvc1'
   2.
      /libraries/joomla/application/application.php:772
      /libraries/joomla/application/application.php:99
      Execute time:0.000456 sec.
      DELETE
        FROM jos_session
        WHERE ( time < '1274613145' )
   3.
      /libraries/joomla/DATABASE/TABLE.php:247
      /libraries/joomla/application/application.php:775
      Execute time:0.000273 sec.
      SELECT *
        FROM jos_session
        WHERE session_id = 'helf4t0g7vosgk3u3smtrdnvc1'
   4.
      /libraries/joomla/DATABASE/TABLE/session.php:113
      /libraries/joomla/application/application.php:776
      Execute time:0.000473 sec.
      UPDATE `jos_session`
        SET `time`='1274614945',`userid`='0',`usertype`='',`username`='',`gid`='0',`guest`='1',`client_id`='0',`data`='__default|a:9:{s:15:\"session.counter\";i:24;s:19:\"session.timer.start\";i:1274614436;s:18:\"session.timer.last\";i:1274614930;s:17:\"session.timer.now\";i:1274614942;s:24:\"session.client.forwarded\";s:12:\"94.181.92.34\";s:22:\"session.client.browser\";s:85:\"Mozilla/5.0 (Windows; U; Windows NT 6.0; ru; rv:1.9.2.3) Gecko/20100401 Firefox/3.6.3\";s:8:\"registry\";O:9:\"JRegistry\":3:{s:17:\"_defaultNameSpace\";s:7:\"session\";s:9:\"_registry\";a:1:{s:7:\"session\";a:1:{s:4:\"data\";O:8:\"stdClass\":0:{}}}s:7:\"_errors\";a:0:{}}s:4:\"user\";O:5:\"JUser\":19:{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:3:\"gid\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:3:\"aid\";i:0;s:5:\"guest\";i:1;s:7:\"_params\";O:10:\"JParameter\":7:{s:4:\"_raw\";s:0:\"\";s:4:\"_xml\";N;s:9:\"_elements\";a:0:{}s:12:\"_elementPath\";a:1:{i:0;s:64:\"/var/www/izhclub.ru/docs/libraries/joomla/html/parameter/element\";}s:17:\"_defaultNameSpace\";s:8:\"_default\";s:9:\"_registry\";a:1:{s:8:\"_default\";a:1:{s:4:\"data\";O:8:\"stdClass\":0:{}}}s:7:\"_errors\";a:0:{}}s:9:\"_errorMsg\";N;s:7:\"_errors\";a:0:{}}s:13:\"session.token\";s:32:\"291c518944bc13f1e476d9fa36be7e77\";}'
        WHERE session_id='helf4t0g7vosgk3u3smtrdnvc1'
   5.
      /libraries/joomla/application/component/helper.php:203
      /libraries/joomla/application/component/helper.php:39
      Execute time:0.000895 sec.
      SELECT *
        FROM jos_components
        WHERE parent = 0
   6.
      /libraries/joomla/plugin/helper.php:215
      /libraries/joomla/plugin/helper.php:41
      Execute time:0.000778 sec.
      SELECT folder AS type, element AS name, params
        FROM jos_plugins
        WHERE published >= 1
        AND access <= 0
        ORDER BY ordering
   7.
      /includes/menu.php:49
      /libraries/joomla/application/menu.php:60
      Execute time:0.003269 sec.
      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
   8.
      /components/com_jcomments/jcomments.config.php:143
      Execute time:0.000719 sec.
      SELECT *
        FROM jos_jcomments_settings
   9.
      /includes/application.php:307
      /components/com_jcomments/helpers/system.php:86
      Execute time:0.000581 sec.
      SELECT template
        FROM jos_templates_menu
        WHERE client_id = 0
        AND (menuid = 0 OR menuid = 255)
        ORDER BY menuid DESC
        LIMIT 0, 1
  10.
      /administrator/components/com_zoo/framework/DATABASE.php:65
      /administrator/components/com_zoo/framework/TABLE.php:231
      Execute time:0.000819 sec.
      SELECT *
        FROM jos_zoo_application
        WHERE id = 1
  11.
      /administrator/components/com_zoo/framework/DATABASE.php:65
      /administrator/components/com_zoo/framework/TABLE.php:231
      Execute time:0.001002 sec.
      SELECT *
        FROM jos_zoo_category
        WHERE id = 0
  12.
      /administrator/components/com_zoo/framework/DATABASE.php:79
      /administrator/components/com_zoo/framework/TABLE.php:247
      Execute time:0.000502 sec.
      SELECT *
        FROM jos_zoo_category
        WHERE application_id = 1
        ORDER BY ordering
  13.
      /administrator/components/com_zoo/framework/DATABASE.php:79
      /administrator/components/com_zoo/helpers/category.php:164
      Execute time:0.001042 sec.
      SELECT a.category_id, count(b.id) AS item_count
        FROM jos_zoo_category_item AS a JOIN jos_zoo_item AS b
        ON b.id = a.item_id
        AND b.access <= 0
        AND (b.state = 1
        AND ('2010-05-23 11:42:25' BETWEEN b.publish_up
        AND b.publish_down OR '2010-05-23 11:42:25' >= b.publish_up
        AND b.publish_down = '0000-00-00 00:00:00'))
        GROUP BY a.category_id
  14.
      /administrator/components/com_zoo/framework/DATABASE.php:79
      /administrator/components/com_zoo/framework/TABLE.php:247
      Execute time:0.001325 sec.
      SELECT a.*
        FROM jos_zoo_item AS a
        LEFT JOIN jos_zoo_category_item AS b
        ON a.id = b.item_id
        WHERE a.application_id = 1
        AND b.category_id  = 0
        AND a.access <= 0
        AND a.state = 1
        AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2010-05-23 11:42:25')
        AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2010-05-23 11:42:25')
        GROUP BY a.id
        ORDER BY a.priority DESC , a.created DESC
  15.
      /administrator/components/com_zoo/framework/DATABASE.php:65
      /administrator/components/com_zoo/framework/TABLE.php:231
      Execute time:0.000996 sec.
      SELECT *
        FROM jos_zoo_category
        WHERE id = 0
  16.
      /administrator/components/com_zoo/framework/DATABASE.php:65
      /administrator/components/com_zoo/framework/TABLE.php:231
      Execute time:0.001065 sec.
      SELECT *
        FROM jos_zoo_category
        WHERE id = 0
  17.
      /administrator/components/com_zoo/framework/DATABASE.php:65
      /administrator/components/com_zoo/framework/TABLE.php:231
      Execute time:0.001413 sec.
      SELECT *
        FROM jos_zoo_item
        WHERE id = 1
  18.
      /administrator/components/com_zoo/framework/DATABASE.php:79
      /administrator/components/com_zoo/framework/TABLE.php:247
      Execute time:0.000494 sec.
      SELECT b.*
        FROM jos_zoo_category_item AS a JOIN jos_zoo_category AS b
        ON b.id = a.category_id
        WHERE a.item_id=1
        AND b.published = 1
  19.
      /libraries/joomla/application/module/helper.php:285
      /libraries/joomla/application/module/helper.php:88
      Execute time:0.001889 sec.
      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 = 255 OR mm.menuid = 0 )
        ORDER BY position, ordering
  20.
      /components/com_banners/models/banner.php:79
      /modules/mod_banners/helper.php:39
      Execute time:0.035027 sec.
      SELECT *, RAND() AS ordering
        FROM jos_banner
        WHERE showBanner = 1
        AND (imptotal = 0 OR impmade < imptotal)
        AND cid = 3
        AND catid = 141
        ORDER BY sticky DESC, ordering
        LIMIT 0, 1
  21.
      /modules/mod_banners/helper.php:40
      /modules/mod_banners/mod_banners.php:23
      Execute time:0.00031 sec.
      UPDATE jos_banner
        SET impmade = impmade + 1
        WHERE bid = 8