Kod:
Informacje o wydajnościApplication 0.001 seconds (+0.001); 0.83 MB (+0.827) - afterLoad
Application 0.041 seconds (+0.040); 5.60 MB (+4.772) - afterInitialise
Application 0.042 seconds (+0.001); 5.60 MB (+0.002) - afterRoute
Application 0.060 seconds (+0.018); 7.52 MB (+1.919) - beforeRenderModule mod_logged (Logged-in Users)
Application 0.065 seconds (+0.005); 7.69 MB (+0.166) - afterRenderModule mod_logged (Logged-in Users)
Application 0.065 seconds (+0.000); 7.68 MB (-0.002) - beforeRenderModule mod_popular (Popular Articles)
Application 0.073 seconds (+0.008); 8.26 MB (+0.576) - afterRenderModule mod_popular (Popular Articles)
Application 0.073 seconds (+0.000); 8.25 MB (-0.016) - beforeRenderModule mod_latest (Recently Added Articles)
Application 0.079 seconds (+0.006); 8.48 MB (+0.233) - afterRenderModule mod_latest (Recently Added Articles)
Application 0.080 seconds (+0.001); 8.37 MB (-0.114) - afterDispatch
Application 0.083 seconds (+0.003); 8.56 MB (+0.199) - beforeRenderModule mod_quickicon (Quick Icons)
Application 0.088 seconds (+0.006); 8.64 MB (+0.073) - afterRenderModule mod_quickicon (Quick Icons)
Application 0.088 seconds (+0.000); 8.64 MB (+0.002) - beforeRenderModule mod_menu (Admin Menu)
Application 0.106 seconds (+0.017); 9.09 MB (+0.454) - afterRenderModule mod_menu (Admin Menu)
Application 0.106 seconds (+0.000); 9.05 MB (-0.040) - beforeRenderModule mod_status (User Status)
Application 0.109 seconds (+0.003); 9.06 MB (+0.009) - afterRenderModule mod_status (User Status)
Application 0.110 seconds (+0.001); 9.16 MB (+0.095) - afterRender
Użycie pamięci9.17 MB (9,618,512 Bytes)17 zapytań zarejestrowanych- SELECT `data`
FROM `jos_session`
WHERE `session_id` = '2c8f71a6e778ee229265fda5b015a6e3'
- DELETE
FROM `jos_session`
WHERE `time` < 1323360155
- SELECT folder AS type, element AS name, params
FROM jos_extensions
WHERE enabled >= 1
AND type ='plugin'
AND state >= 0
AND access IN (1,1,3)
ORDER BY ordering
- SELECT template, s.params
FROM jos_template_styles as s
LEFT JOIN jos_extensions as e
ON e.type='template'
AND e.element=s.template
AND e.client_id=s.client_id
WHERE s.client_id = 1
AND home = 1
ORDER BY home
- SELECT extension_id AS "id", element AS "option", params, enabled
FROM jos_extensions
WHERE `type` = 'component'
AND `element` = 'com_cpanel'
- SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM jos_modules AS m
LEFT JOIN jos_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN jos_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 <= '2011-12-08 16:17:35')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2011-12-08 16:17:35')
AND m.access IN (1,1,3)
AND m.client_id = 1
AND (mm.menuid = 0 OR mm.menuid <= 0)
ORDER BY m.position, m.ordering
- SELECT s.time, s.client_id, u.id, u.name, u.username
FROM jos_session AS s
LEFT JOIN jos_users AS u
ON s.userid = u.id
WHERE s.guest = 0
LIMIT 0, 5
- SELECT a.id, a.title, a.checked_out, a.checked_out_time, a.created, a.hits,l.title AS language_title,uc.name AS editor,ag.title AS access_level,c.title AS category_title,ua.name AS author_name
FROM jos_content AS a
LEFT JOIN `jos_languages` AS l
ON l.lang_code = a.language
LEFT JOIN jos_users AS uc
ON uc.id=a.checked_out
LEFT JOIN jos_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN jos_categories AS c
ON c.id = a.catid
LEFT JOIN jos_users AS ua
ON ua.id = a.created_by
ORDER BY a.hits DESC
- SELECT a.id, a.title, a.checked_out, a.checked_out_time, a.created, a.hits,l.title AS language_title,uc.name AS editor,ag.title AS access_level,c.title AS category_title,ua.name AS author_name
FROM jos_content AS a
LEFT JOIN `jos_languages` AS l
ON l.lang_code = a.language
LEFT JOIN jos_users AS uc
ON uc.id=a.checked_out
LEFT JOIN jos_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN jos_categories AS c
ON c.id = a.catid
LEFT JOIN jos_users AS ua
ON ua.id = a.created_by
ORDER BY a.hits DESC
LIMIT 0, 5
- SELECT a.id, a.title, a.checked_out, a.checked_out_time, a.access, a.created, a.created_by, a.created_by_alias, a.featured, a.state,l.title AS language_title,uc.name AS editor,ag.title AS access_level,c.title AS category_title,ua.name AS author_name
FROM jos_content AS a
LEFT JOIN `jos_languages` AS l
ON l.lang_code = a.language
LEFT JOIN jos_users AS uc
ON uc.id=a.checked_out
LEFT JOIN jos_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN jos_categories AS c
ON c.id = a.catid
LEFT JOIN jos_users AS ua
ON ua.id = a.created_by
ORDER BY created DESC
- SELECT a.id, a.title, a.checked_out, a.checked_out_time, a.access, a.created, a.created_by, a.created_by_alias, a.featured, a.state,l.title AS language_title,uc.name AS editor,ag.title AS access_level,c.title AS category_title,ua.name AS author_name
FROM jos_content AS a
LEFT JOIN `jos_languages` AS l
ON l.lang_code = a.language
LEFT JOIN jos_users AS uc
ON uc.id=a.checked_out
LEFT JOIN jos_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN jos_categories AS c
ON c.id = a.catid
LEFT JOIN jos_users AS ua
ON ua.id = a.created_by
ORDER BY created DESC
LIMIT 0, 5
- SELECT a.*, SUM(b.home) AS home,b.language,l.image,l.sef,l.title_native
FROM jos_menu_types AS a
LEFT JOIN jos_menu AS b
ON b.menutype = a.menutype
AND b.home != 0
LEFT JOIN jos_languages AS l
ON l.lang_code = language
WHERE (b.client_id = 0 OR b.client_id IS NULL)
GROUP BY a.id
- SELECT m.id, m.title, m.alias, m.link, m.parent_id, m.img, e.element
FROM jos_menu AS m
LEFT JOIN jos_extensions AS e
ON m.component_id = e.extension_id
WHERE m.client_id = 1
AND e.enabled = 1
AND m.id > 1
ORDER BY m.lft
- SELECT COUNT(*)
FROM jos_messages
WHERE state = 0
AND user_id_to = 42
- SELECT COUNT(session_id)
FROM jos_session
WHERE guest = 0
AND client_id = 1
- SELECT COUNT(session_id)
FROM jos_session
WHERE guest = 0
AND client_id = 0
- UPDATE `jos_session`
SET `data` = '__default|a:9:{s:15:\"session.counter\";i:57;s:19:\"session.timer.start\";i:1323359466;s:18:\"session.timer.last\";i:1323361052;s:17:\"session.timer.now\";i:1323361055;s:22:\"session.client.browser\";s:63:\"Mozilla/5.0 (Windows NT 5.1; rv:8.0) Gecko/20100101 Firefox/8.0\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":8:{s:11:\"application\";O:8:\"stdClass\":1:{s:4:\"lang\";s:0:\"\";}s:13:\"com_templates\";O:8:\"stdClass\":1:{s:6:\"styles\";O:8:\"stdClass\":1:{s:10:\"limitstart\";i:0;}}s:11:\"com_modules\";O:8:\"stdClass\":1:{s:7:\"modules\";O:8:\"stdClass\":1:{s:6:\"filter\";O:8:\"stdClass\":1:{s:18:\"client_id_previous\";i:0;}}}s:13:\"com_installer\";O:8:\"stdClass\":3:{s:7:\"message\";s:0:\"\";s:17:\"extension_message\";s:0:\"\";s:8:\"warnings\";O:8:\"stdClass\":1:{s:8:\"ordercol\";N;}}s:11:\"com_plugins\";O:8:\"stdClass\":2:{s:7:\"plugins\";O:8:\"stdClass\":4:{s:6:\"filter\";O:8:\"stdClass\":4:{s:6:\"search\";s:11:\"diagnostyka\";s:6:\"access\";i:0;s:5:\"state\";s:0:\"\";s:6:\"folder\";s:0:\"\";}s:10:\"limitstart\";i:0;s:8:\"ordercol\";s:6:\"folder\";s:9:\"orderdirn\";s:3:\"asc\";}s:4:\"edit\";O:8:\"stdClass\":1:{s:6:\"plugin\";O:8:\"stdClass\":2:{s:2:\"id\";a:0:{}s:4:\"data\";N;}}}s:6:\"global\";O:8:\"stdClass\":1:{s:4:\"list\";O:8:\"stdClass\":1:{s:5:\"
limit\";s:2:\"20\";}}s:9:\"com_menus\";O:8:\"stdClass\":2:{s:5:\"items\";O:8:\"stdClass\":2:{s:6:\"filter\";O:8:\"stdClass\":1:{s:8:\"menutype\";s:8:\"mainmenu\";}s:10:\"limitstart\";i:0;}s:4:\"edit\";O:8:\"stdClass\":1:{s:4:\"item\";O:8:\"stdClass\":3:{s:4:\"data\";N;s:4:\"type\";N;s:4:\"link\";N;}}}s:4:\"item\";O:8:\"stdClass\":1:{s:6:\"filter\";O:8:\"stdClass\":1:{s:8:\"menutype\";s:8:\"mainmenu\";}}}}s:4:\"user\";O:5:\"JUser\":23:{s:9:\"\0*\0isRoot\";b:1;s:2:\"id\";s:2:\"42\";s:4:\"name\";s:5:\"beRRo\";s:8:\"username\";s:5:\"beRRo\";s:5:\"email\";s:19:\"hubertuse15@tlen.pl\";s:8:\"password\";s:65:\"79462f977ebcd563cbf4f39711f0ff27:IZKQzqlf3F3l0C8nMBCkIoOafAA4M9up\";s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";s:10:\"deprecated\";s:5:\"block\";s:1:\"0\";s:9:\"sendEmail\";s:1:\"1\";s:12:\"registerDate\";s:19:\"2011-06-07 17:32:12\";s:13:\"lastvisitDate\";s:19:\"2011-12-08 14:55:24\";s:10:\"activation\";s:0:\"\";s:6:\"params\";s:102:\"{\"admin_style\":\"\",\"admin_language\":\"pl-PL\",\"language\":\"pl-PL\",\"editor\":\"\",\"helpsite\":\"\",\"timezone\":\"\"}\";s:6:\"groups\";a:1:{s:11:\"Super Users\";s:1:\"8\";}s:5:\"guest\";i:0;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":6:{s:11:\"admin_style\";s:0:\"\";s:14:\"admin_language\";s:5:\"pl-PL\";s:8:\"language\";s:5:\"pl-PL\";s:6:\"editor\";s:0:\"\";s:8:\"helpsite\";s:0:\"\";s:8:\"timezone\";s:0:\"\";}}s:14:\"\0*\0_authGroups\";a:2:{i:0;i:1;i:1;i:8;}s:14:\"\0*\0_authLevels\";a:3:{i:0;i:1;i:1;i:1;i:2;i:3;}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:19:\"osolAdminPassPhrase\";s:0:\"\";s:13:\"session.token\";s:32:\"f808b9804b8c418072f7ad39ae373518\";}', `time` = 1323361055
WHERE `session_id` = '2c8f71a6e778ee229265fda5b015a6e3'
14 typów zapytań zarejestrowanych, posortowanych wg częstotliwościZaznacz tabele:- 2 × SELECT a.id, a.title, a.checked_out, a.checked_out_time, a.access, a.created, a.created_by, a.created_by_alias, a.featured, a.state,l.title AS language_title,uc.name AS editor,ag.title AS access_level,c.title AS category_title,ua.name AS author_name FROM jos_content AS a LEFT JOIN `jos_languages` AS l ON l.lang_code = a.language LEFT JOIN jos_users AS uc ON uc.id=a.checked_out LEFT JOIN jos_viewlevels AS ag ON ag.id = a.access LEFT JOIN jos_categories AS c ON c.id = a.catid LEFT JOIN jos_users AS ua ON ua.id = a.created_by
- 2 × SELECT a.id, a.title, a.checked_out, a.checked_out_time, a.created, a.hits,l.title AS language_title,uc.name AS editor,ag.title AS access_level,c.title AS category_title,ua.name AS author_name FROM jos_content AS a LEFT JOIN `jos_languages` AS l ON l.lang_code = a.language LEFT JOIN jos_users AS uc ON uc.id=a.checked_out LEFT JOIN jos_viewlevels AS ag ON ag.id = a.access LEFT JOIN jos_categories AS c ON c.id = a.catid LEFT JOIN jos_users AS ua ON ua.id = a.created_by
- 2 × SELECT COUNT(session_id) FROM jos_session
- 1 × SELECT a.*, SUM(b.home) AS home,b.language,l.image,l.sef,l.title_native FROM jos_menu_types AS a LEFT JOIN jos_menu AS b ON b.menutype = a.menutype AND b.home != 0 LEFT JOIN jos_languages AS l ON l.lang_code = language
- 1 × SELECT COUNT(*) FROM jos_messages
- 1 × SELECT m.id, m.title, m.alias, m.link, m.parent_id, m.img, e.element FROM jos_menu AS m LEFT JOIN jos_extensions AS e ON m.component_id = e.extension_id
- 1 × SELECT s.time, s.client_id, u.id, u.name, u.username FROM jos_session AS s LEFT JOIN jos_users AS u ON s.userid = u.id
- 1 × SELECT folder AS type, element AS name, params FROM jos_extensions
- 1 × SELECT template, s.params FROM jos_template_styles as s LEFT JOIN jos_extensions as e ON e.type='template' AND e.element=s.template AND e.client_id=s.client_id
- 1 × SELECT extension_id AS "id", element AS "option", params, enabled FROM jos_extensions
- 1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid FROM jos_modules AS m LEFT JOIN jos_modules_menu AS mm ON mm.moduleid = m.id LEFT JOIN jos_extensions AS e ON e.element = m.module AND e.client_id = m.client_id
- 1 × SELECT `data` FROM `jos_session`
INNE tabele:- 1 × UPDATE `jos_session` SET `data` = '__default|a:9:{s:15:\"session.counter\";i:57;s:19:\"session.timer.start\";i:1323359466;s:18:\"session.timer.last\";i:1323361052;s:17:\"session.timer.now\";i:1323361055;s:22:\"session.client.browser\";s:63:\"Mozilla/5.0 (Windows NT 5.1; rv:8.0) Gecko/20100101 Firefox/8.0\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":8:{s:11:\"application\";O:8:\"stdClass\":1:{s:4:\"lang\";s:0:\"\";}s:13:\"com_templates\";O:8:\"stdClass\":1:{s:6:\"styles\";O:8:\"stdClass\":1:{s:10:\"limitstart\";i:0;}}s:11:\"com_modules\";O:8:\"stdClass\":1:{s:7:\"modules\";O:8:\"stdClass\":1:{s:6:\"filter\";O:8:\"stdClass\":1:{s:18:\"client_id_previous\";i:0;}}}s:13:\"com_installer\";O:8:\"stdClass\":3:{s:7:\"message\";s:0:\"\";s:17:\"extension_message\";s:0:\"\";s:8:\"warnings\";O:8:\"stdClass\":1:{s:8:\"ordercol\";N;}}s:11:\"com_plugins\";O:8:\"stdClass\":2:{s:7:\"plugins\";O:8:\"stdClass\":4:{s:6:\"filter\";O:8:\"stdClass\":4:{s:6:\"search\";s:11:\"diagnostyka\";s:6:\"access\";i:0;s:5:\"state\";s:0:\"\";s:6:\"folder\";s:0:\"\";}s:10:\"limitstart\";i:0;s:8:\"ordercol\";s:6:\"folder\";s:9:\"orderdirn\";s:3:\"asc\";}s:4:\"edit\";O:8:\"stdClass\":1:{s:6:\"plugin\";O:8:\"stdClass\":2:{s:2:\"id\";a:0:{}s:4:\"data\";N;}}}s:6:\"global\";O:8:\"stdClass\":1:{s:4:\"list\";O:8:\"stdClass\":1:{s:5:\"limit\";s:2:\"20\";}}s:9:\"com_menus\";O:8:\"stdClass\":2:{s:5:\"items\";O:8:\"stdClass\":2:{s:6:\"filter\";O:8:\"stdClass\":1:{s:8:\"menutype\";s:8:\"mainmenu\";}s:10:\"limitstart\";i:0;}s:4:\"edit\";O:8:\"stdClass\":1:{s:4:\"item\";O:8:\"stdClass\":3:{s:4:\"data\";N;s:4:\"type\";N;s:4:\"link\";N;}}}s:4:\"item\";O:8:\"stdClass\":1:{s:6:\"filter\";O:8:\"stdClass\":1:{s:8:\"menutype\";s:8:\"mainmenu\";}}}}s:4:\"user\";O:5:\"JUser\":23:{s:9:\"\0*\0isRoot\";b:1;s:2:\"id\";s:2:\"42\";s:4:\"name\";s:5:\"beRRo\";s:8:\"username\";s:5:\"beRRo\";s:5:\"email\";s:19:\"hubertuse15@tlen.pl\";s:8:\"password\";s:65:\"79462f977ebcd563cbf4f39711f0ff27:IZKQzqlf3F3l0C8nMBCkIoOafAA4M9up\";s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";s:10:\"deprecated\";s:5:\"block\";s:1:\"0\";s:9:\"sendEmail\";s:1:\"1\";s:12:\"registerDate\";s:19:\"2011-06-07 17:32:12\";s:13:\"lastvisitDate\";s:19:\"2011-12-08 14:55:24\";s:10:\"activation\";s:0:\"\";s:6:\"params\";s:102:\"{\"admin_style\":\"\",\"admin_language\":\"pl-PL\",\"language\":\"pl-PL\",\"editor\":\"\",\"helpsite\":\"\",\"timezone\":\"\"}\";s:6:\"groups\";a:1:{s:11:\"Super Users\";s:1:\"8\";}s:5:\"guest\";i:0;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":6:{s:11:\"admin_style\";s:0:\"\";s:14:\"admin_language\";s:5:\"pl-PL\";s:8:\"language\";s:5:\"pl-PL\";s:6:\"editor\";s:0:\"\";s:8:\"helpsite\";s:0:\"\";s:8:\"timezone\";s:0:\"\";}}s:14:\"\0*\0_authGroups\";a:2:{i:0;i:1;i:1;i:8;}s:14:\"\0*\0_authLevels\";a:3:{i:0;i:1;i:1;i:1;i:2;i:3;}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:19:\"osolAdminPassPhrase\";s:0:\"\";s:13:\"session.token\";s:32:\"f808b9804b8c418072f7ad39ae373518\";}', `time` = 1323361055
- 1 × DELETE FROM `jos_session`
W ogóle nie wiem gdzie może tkwić błąd....