|
Tools you need are
Firebug with the net tab enabled.
http://getfirebug.com/
http://www.vertain.com/
http://www.webpagetest.org/
http://tools.pingdom.com/fpt/
Useful Links
http://www.joomlaperformance.com/articles/performance/so_you_want_to_speed_up_joomla_3_14.html
http://www.joomspot.net/how-to-speed-up-optimize-joomlas-performance.html
http://www.alledia.com/blog/seo/101-ways-to-speed-up-your-joomla-site/
http://webmasterformat.com/blog/speed-up-joomla
Before
Profile Information
Application 0.003 seconds (+0.003); 0.65 MB (+0.654) - afterLoad
Application 0.155 seconds (+0.152); 5.88 MB (+5.226) - afterInitialise
Application 3.253 seconds (+3.099); 76.71 MB (+70.828) - afterRoute
Application 3.303 seconds (+0.049); 77.25 MB (+0.541) - afterDispatch
Application 3.326 seconds (+0.024); 77.56 MB (+0.310) - afterRender
Memory Usage
77.57 MB (81,339,348 Bytes)
27 Queries Logged
SELECT `data`
FROM `k9n23_session`
WHERE `session_id` = 'rlm8it4vg1bjnfo63cm3shpot7'
SELECT params
FROM k9n23_extensions
WHERE element = "com_acesef"
AND type = "component"
SELECT m.id, m.menutype, m.title, m.alias, 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 k9n23_menu AS m
LEFT JOIN k9n23_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 id, url_sef, url_real, used, params
FROM k9n23_acesef_urls
WHERE params LIKE '%notfound=0%'
ORDER BY used DESC, cdate DESC, id ASC
SELECT *
FROM k9n23_acesef_metadata
WHERE published = '1'
SELECT *
FROM k9n23_acesef_metadata
WHERE url_sef = ''
AND published = '1'
SELECT `id`
FROM k9n23_menu
WHERE `link`='index.php?option=com_simanswers&view=frontpage'
AND `type`='component'
AND `published`=1
LIMIT 1
SELECT `id`
FROM k9n23_menu
WHERE `link`='index.php?option=com_simanswers&view=ask'
AND `type`='component'
AND `published`=1
LIMIT 1
SELECT `id`
FROM k9n23_menu
WHERE `link`='index.php?option=com_simanswers&view=dashboard'
AND `type`='component'
AND `published`=1
LIMIT 1
SHOW FULL COLUMNS
FROM `k9n23_simanswers_config`
SELECT *
FROM k9n23_simanswers_config
WHERE `id` = '1'
SELECT *
FROM k9n23_simanswers_questions AS q
WHERE q.resolved=0
AND q.expiration<1331766931
AND (SELECT COUNT(*)
FROM k9n23_simanswers_answers AS a
WHERE a.qid=q.qid)=0
UPDATE k9n23_simanswers_questions
SET `put_to_vote`=1
WHERE `expiration`<1331766931
AND `put_to_vote`=0
AND `resolved`=0
SELECT *
FROM k9n23_simanswers_questions
WHERE `resolved`=0
AND `put_to_vote`=1
AND `expiration`<1331766931
SELECT `created`
FROM k9n23_content a
ORDER BY `created` DESC
LIMIT 1
SELECT extension, params
FROM k9n23_acesef_extensions
SELECT *
FROM k9n23_kunena_config
SELECT id, url_sef, url_real, used, params
FROM k9n23_acesef_urls
WHERE url_real = 'index.php?option=com_easyblog&Itemid=949&
limit=-2&view=myblog'
AND params LIKE '%notfound=0%'
LIMIT 1
SHOW FULL COLUMNS
FROM `k9n23_easyblog_configs`
SELECT *
FROM k9n23_easyblog_configs
WHERE `name` = 'config'
SELECT id, url_sef, url_real, used, params
FROM k9n23_acesef_urls
WHERE url_real = 'index.php?option=com_easyblog&Itemid=950&
limit=-2&view=blogger'
AND params LIKE '%notfound=0%'
LIMIT 1
SELECT id, url_sef, url_real, used, params
FROM k9n23_acesef_urls
WHERE url_real = 'index.php?option=com_easyblog&Itemid=951&
limit=-2&view=categories'
AND params LIKE '%notfound=0%'
LIMIT 1
SELECT id, url_sef, url_real, used, params
FROM k9n23_acesef_urls
WHERE url_real = 'index.php?option=com_easyblog&Itemid=953&
limit=-2&view=teamblog'
AND params LIKE '%notfound=0%'
LIMIT 1
SELECT id, catid
FROM k9n23_content
SELECT b.rules
FROM k9n23_assets AS a
LEFT JOIN k9n23_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 1
ORDER BY b.lft
SELECT *
FROM k9n23_acesef_metadata
WHERE url_sef = ''
AND published = '1'
UPDATE `k9n23_session`
SET `data` = '__default|a:8:{s:15:\"session.counter\";i:4;s:19:\"session.timer.start\";i:1331766597;s:18:\"session.timer.last\";i:1331766781;s:17:\"session.timer.now\";i:1331766928;s:22:\"session.client.browser\";s:78:\"Mozilla/5.0 (X11; Ubuntu; Linux i686; rv:10.0.2) Gecko/20100101 Firefox/10.0.2\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":2:{s:12:\"mobilejoomla\";O:8:\"stdClass\":2:{s:5:\"cache\";s:1320:\"jVi7dtswDP2VHn5AYtF2kyhjO3Tq0KWjDyMiFhNRUiU6TtqTfy8fogQ+5GRqjXsB4kIAIYWVtPw3lrclGUEp0R5Hcs/KotgY601JXmAYRdeSe/uruNp8+fVtP/2qWFVrD3Ivyo22FEVJaqX6yKyJvJNMtKO3fC1JX/XsCCbOpiTmn2JbEgWyb5iCs+CqNuTbjY/71MPxz4k1Qr0Z4M7bOYzPqusPp6ExUSh1KZTX1zWc646zAcarqpPX9ox9SWT3IBo4jEJBy6TNQGslP+B33X03bJ/Ma61k4zPytMm75yyg1Z2ESM/dBB3/ih4XyBpdPWwIXXgd7SrMNgg+ABcDVGqOcjsBh4fT4yMMh7lc1B9yZv1K5hohCymT940FcNZ31hKmrA25lF3UJGH9vM+ZdG8nlUJ2HIJ86ZyvxQgm5mttobjW1rgkTjeTaaXaFstVu7pQ7Z3203VsQwHbRYAF/VNwv0TP+Bx/DpARtrh4acVUHmdF2gpvy4mbz0jU3Xkkkbfz6pXWdXANVwPTFSpmiU9mEiYrWaNTn0JAp6v8LQrPmmY9fM9UfWZvvixm9lPUVBU/S8SQgvMGYjXOmjnOAbEabM3xYzVLeLoL6PpZ9fo5tMpnXKQhH7tOpfV31kwGDogzxtYcP854NfyTR6b6FwE6Cv1/MA/Pl59uA4KO3Z3hVemWnPsxijGA7F5AseM4H7LLEMZqEL2a10sRcoS0q4im3ho5MM5H9dbAuJKlfiB653Co7D20TA2myAfg1bhECBux6lq9a5R6622AbVrIV71BUJ0ilHeV9zUazG0a+rZzdWZM38KZYV2sJE+m+O5J4QuTicnxXG5SLJhK7JvO5GJNDkKzl0v6wwGkiJwfPxwuHb7FmpyNhiyX2oeTtsOpsYG71xI6H7vYcNhoIuc+NVg6SwXWP01JMMjGHvd/UhbUnsGNZbdp0IR7mz22kzUH6qVFDnTV4xNbw9HXtkaAZreGY+AOxYoyewMDqaLc5sDIJzaHo1/eHI6DmxdnnbncMZBmndseGPnE9nD0te3h0Ey3hqLxrb4NkOyNHZ4d96yfk+lVCDftpB0DZNXFleUmdaHrPhcaN+Kjzg0WVQgHrRtFwL0bCEPNm3XJCMNA1udC/+5DfraBl8F0pExHRMfiHg/UoR7MumTUYSDrc6HPI358KUficSOnUPx+8m6/njm8iArMh/qN+Uw3YtnwfLKfdn7d6HkagOmyT8jD/FmkX5cA2vlF35qpN9cgjrXCdiH1R8ljN0hmXrF+3ts/FkghwY2Q/fxS+j3u2ryPmN9aRc8GJk1+m/Lf+/v7fw==\";s:6:\"markup\";s:0:\"\";}s:5:\"users\";O:8:\"stdClass\":1:{s:5:\"login\";O:8:\"stdClass\":1:{s:4:\"form\";O:8:\"stdClass\":1:{s:4:\"data\";a:1:{s:6:\"return\";s:22:\"http://hewhodares.com/\";}}}}}}s:4:\"user\";O:5:\"JUser\":24:{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: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;s:1:\"1\";}s:14:\"\0*\0_authLevels\";a:1:{i:0;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:9:\"group_ids\";s:0:\"\";}s:13:\"session.token\";s:32:\"2cf2298e9e2f9b265c83fc6f9c1f0edf\";}__findCount|a:1:{s:7:\"Listing\";a:1:{s:32:\"f4b0c950867b221a681de9d299ee900c\";s:1:\"0\";}}', `time` = 1331766931
WHERE `session_id` = 'rlm8it4vg1bjnfo63cm3shpot7'
19 Query Types Logged, Sorted by Occurrences.
SELECT Tables:
5 × SELECT id, url_sef, url_real, used, params FROM k9n23_acesef_urls
3 × SELECT `id` FROM k9n23_menu
3 × SELECT * FROM k9n23_acesef_metadata
1 × SELECT * FROM k9n23_kunena_confi
1 × SELECT extension, params FROM k9n23_acesef_extension
1 × SELECT * FROM k9n23_easyblog_configs
1 × SELECT b.rules FROM k9n23_assets AS a LEFT JOIN k9n23_assets AS b ON b.lft <= a.lft AND b.rgt >= a.rgt
1 × SELECT `created` FROM k9n23_content a
1 × SELECT id, catid FROM k9n23_conten
1 × SELECT * FROM k9n23_simanswers_questions AS q
1 × SELECT params FROM k9n23_extensions
1 × SELECT m.id, m.menutype, m.title, m.alias, 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 k9n23_menu AS m LEFT JOIN k9n23_extensions AS e ON m.component_id = e.extension_id
1 × SELECT * FROM k9n23_simanswers_config
1 × SELECT `data` FROM `k9n23_session`
1 × SELECT * FROM k9n23_simanswers_questions
OTHER Tables:
1 × UPDATE `k9n23_session` SET `data` = '__default|a:8:{s:15:\"session.counter\";i:4;s:19:\"session.timer.start\";i:1331766597;s:18:\"session.timer.last\";i:1331766781;s:17:\"session.timer.now\";i:1331766928;s:22:\"session.client.browser\";s:78:\"Mozilla/5.0 (X11; Ubuntu; Linux i686; rv:10.0.2) Gecko/20100101 Firefox/10.0.2\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":2:{s:12:\"mobilejoomla\";O:8:\"stdClass\":2:{s:5:\"cache\";s:1320:\"jVi7dtswDP2VHn5AYtF2kyhjO3Tq0KWjDyMiFhNRUiU6TtqTfy8fogQ+5GRqjXsB4kIAIYWVtPw3lrclGUEp0R5Hcs/KotgY601JXmAYRdeSe/uruNp8+fVtP/2qWFVrD3Ivyo22FEVJaqX6yKyJvJNMtKO3fC1JX/XsCCbOpiTmn2JbEgWyb5iCs+CqNuTbjY/71MPxz4k1Qr0Z4M7bOYzPqusPp6ExUSh1KZTX1zWc646zAcarqpPX9ox9SWT3IBo4jEJBy6TNQGslP+B33X03bJ/Ma61k4zPytMm75yyg1Z2ESM/dBB3/ih4XyBpdPWwIXXgd7SrMNgg+ABcDVGqOcjsBh4fT4yMMh7lc1B9yZv1K5hohCymT940FcNZ31hKmrA25lF3UJGH9vM+ZdG8nlUJ2HIJ86ZyvxQgm5mttobjW1rgkTjeTaaXaFstVu7pQ7Z3203VsQwHbRYAF/VNwv0TP+Bx/DpARtrh4acVUHmdF2gpvy4mbz0jU3Xkkkbfz6pXWdXANVwPTFSpmiU9mEiYrWaNTn0JAp6v8LQrPmmY9fM9UfWZvvixm9lPUVBU/S8SQgvMGYjXOmjnOAbEabM3xYzVLeLoL6PpZ9fo5tMpnXKQhH7tOpfV31kwGDogzxtYcP854NfyTR6b6FwE6Cv1/MA/Pl59uA4KO3Z3hVemWnPsxijGA7F5AseM4H7LLEMZqEL2a10sRcoS0q4im3ho5MM5H9dbAuJKlfiB653Co7D20TA2myAfg1bhECBux6lq9a5R6622AbVrIV71BUJ0ilHeV9zUazG0a+rZzdWZM38KZYV2sJE+m+O5J4QuTicnxXG5SLJhK7JvO5GJNDkKzl0v6wwGkiJwfPxwuHb7FmpyNhiyX2oeTtsOpsYG71xI6H7vYcNhoIuc+NVg6SwXWP01JMMjGHvd/UhbUnsGNZbdp0IR7mz22kzUH6qVFDnTV4xNbw9HXtkaAZreGY+AOxYoyewMDqaLc5sDIJzaHo1/eHI6DmxdnnbncMZBmndseGPnE9nD0te3h0Ey3hqLxrb4NkOyNHZ4d96yfk+lVCDftpB0DZNXFleUmdaHrPhcaN+Kjzg0WVQgHrRtFwL0bCEPNm3XJCMNA1udC/+5DfraBl8F0pExHRMfiHg/UoR7MumTUYSDrc6HPI358KUficSOnUPx+8m6/njm8iArMh/qN+Uw3YtnwfLKfdn7d6HkagOmyT8jD/FmkX5cA2vlF35qpN9cgjrXCdiH1R8ljN0hmXrF+3ts/FkghwY2Q/fxS+j3u2ryPmN9aRc8GJk1+m/Lf+/v7fw==\";s:6:\"markup\";s:0:\"\";}s:5:\"users\";O:8:\"stdClass\":1:{s:5:\"login\";O:8:\"stdClass\":1:{s:4:\"form\";O:8:\"stdClass\":1:{s:4:\"data\";a:1:{s:6:\"return\";s:22:\"http://hewhodares.com/\";}}}}}}s:4:\"user\";O:5:\"JUser\":24:{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: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;s:1:\"1\";}s:14:\"\0*\0_authLevels\";a:1:{i:0;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:9:\"group_ids\";s:0:\"\";}s:13:\"session.token\";s:32:\"2cf2298e9e2f9b265c83fc6f9c1f0edf\";}__findCount|a:1:{s:7:\"Listing\";a:1:{s:32:\"f4b0c950867b221a681de9d299ee900c\";s:1:\"0\";}}', `time` = 1331766931
1 × SHOW FULL COLUMNS FROM `k9n23_easyblog_configs
1 × UPDATE k9n23_simanswers_questions SET `put_to_vote`=1
1 × SHOW FULL COLUMNS FROM `k9n23_simanswers_config
After
Profile Information
Application 0.003 seconds (+0.003); 0.65 MB (+0.654) - afterLoad
Application 0.134 seconds (+0.132); 5.03 MB (+4.373) - afterInitialise
Application 0.742 seconds (+0.608); 15.10 MB (+10.069) - afterRoute
Application 0.781 seconds (+0.039); 15.52 MB (+0.423) - afterDispatch
Application 0.803 seconds (+0.022); 15.83 MB (+0.310) - afterRender
Memory Usage
15.84 MB (16,607,536 Bytes)
32 Queries Logged
SELECT `data`
FROM `k9n23_session`
WHERE `session_id` = 'rlm8it4vg1bjnfo63cm3shpot7'
SELECT m.id, m.menutype, m.title, m.alias, 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 k9n23_menu AS m
LEFT JOIN k9n23_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 `id`
FROM k9n23_menu
WHERE `link`='index.php?option=com_simanswers&view=frontpage'
AND `type`='component'
AND `published`=1
LIMIT 1
SELECT `id`
FROM k9n23_menu
WHERE `link`='index.php?option=com_simanswers&view=ask'
AND `type`='component'
AND `published`=1
LIMIT 1
SELECT `id`
FROM k9n23_menu
WHERE `link`='index.php?option=com_simanswers&view=dashboard'
AND `type`='component'
AND `published`=1
LIMIT 1
SHOW FULL COLUMNS
FROM `k9n23_simanswers_config`
SELECT *
FROM k9n23_simanswers_config
WHERE `id` = '1'
SELECT *
FROM k9n23_simanswers_questions AS q
WHERE q.resolved=0
AND q.expiration<1331767115
AND (SELECT COUNT(*)
FROM k9n23_simanswers_answers AS a
WHERE a.qid=q.qid)=0
UPDATE k9n23_simanswers_questions
SET `put_to_vote`=1
WHERE `expiration`<1331767115
AND `put_to_vote`=0
AND `resolved`=0
SELECT *
FROM k9n23_simanswers_questions
WHERE `resolved`=0
AND `put_to_vote`=1
AND `expiration`<1331767115
SELECT `created`
FROM k9n23_content a
ORDER BY `created` DESC
LIMIT 1
SHOW FULL COLUMNS
FROM `k9n23_community_config`
SELECT *
FROM k9n23_community_config
WHERE `name` = 'config'
SELECT a.`userid` as _userid , a.`status` as _status , a.`points` as _points, a.`posted_on` as _posted_on, a.`avatar` as _avatar , a.`thumb` as _thumb , a.`invite` as _invite, a.`params` as _cparams, a.`view` as _view, a.`friends` as _friends, a.`groups` as _groups, a.`events` as _events, a.`friendcount` as _friendcount, a.`alias` as _alias, a.`profile_id` as _profile_id, a.`storage` as _storage, a.`watermark_hash` as _watermark_hash, a.`search_email` as _search_email, s.`userid` as _isonline, u.*
FROM `k9n23_community_users` as a
LEFT JOIN `k9n23_users` u
ON u.`id`=a.`userid`
LEFT
OUTER JOIN `k9n23_session` s
ON s.`userid`=a.`userid`
AND s.`client_id` !='1'
WHERE a.`userid`='0'
SHOW FULL COLUMNS
FROM `k9n23_community_profiles`
show tables like '%_kunena_users'
SELECT a.`userid` as _userid , a.`status` as _status , a.`points` as _points, a.`posted_on` as _posted_on, a.`avatar` as _avatar , a.`thumb` as _thumb , a.`invite` as _invite, a.`params` as _cparams, a.`view` as _view, a.`friends` as _friends, a.`groups` as _groups, a.`events` as _events, a.`friendcount` as _friendcount, a.`alias` as _alias, a.`profile_id` as _profile_id, a.`storage` as _storage, a.`watermark_hash` as _watermark_hash, a.`search_email` as _search_email, s.`userid` as _isonline, u.*
FROM `k9n23_community_users` as a
LEFT JOIN `k9n23_users` u
ON u.`id`=a.`userid`
LEFT
OUTER JOIN `k9n23_session` s
ON s.`userid`=a.`userid`
AND s.`client_id` !='1'
WHERE a.`userid`='147'
SELECT *
FROM k9n23_kunena_config
SELECT optname, value
from k9n23_jvarcade_settings
WHERE optname LIKE '%alias%'
SELECT optname, value
from k9n23_jvarcade_settings
WHERE optname LIKE '%alias%'
SELECT optname, value
from k9n23_jvarcade_settings
WHERE optname LIKE '%alias%'
SELECT optname, value
from k9n23_jvarcade_settings
WHERE optname LIKE '%alias%'
SELECT optname, value
from k9n23_jvarcade_settings
WHERE optname LIKE '%alias%'
SELECT optname, value
from k9n23_jvarcade_settings
WHERE optname LIKE '%alias%'
SELECT optname, value
from k9n23_jvarcade_settings
WHERE optname LIKE '%alias%'
SELECT optname, value
from k9n23_jvarcade_settings
WHERE optname LIKE '%alias%'
SELECT optname, value
from k9n23_jvarcade_settings
WHERE optname LIKE '%alias%'
SELECT optname, value
from k9n23_jvarcade_settings
WHERE optname LIKE '%alias%'
SHOW FULL COLUMNS
FROM `k9n23_easyblog_configs`
SELECT *
FROM k9n23_easyblog_configs
WHERE `name` = 'config'
SELECT b.rules
FROM k9n23_assets AS a
LEFT JOIN k9n23_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 1
ORDER BY b.lft
UPDATE `k9n23_session`
SET `data` = '__default|a:8:{s:15:\"session.counter\";i:5;s:19:\"session.timer.start\";i:1331766597;s:18:\"session.timer.last\";i:1331766928;s:17:\"session.timer.now\";i:1331767114;s:22:\"session.client.browser\";s:78:\"Mozilla/5.0 (X11; Ubuntu; Linux i686; rv:10.0.2) Gecko/20100101 Firefox/10.0.2\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":2:{s:12:\"mobilejoomla\";O:8:\"stdClass\":2:{s:5:\"cache\";s:1320:\"jVi7dtswDP2VHn5AYtF2kyhjO3Tq0KWjDyMiFhNRUiU6TtqTfy8fogQ+5GRqjXsB4kIAIYWVtPw3lrclGUEp0R5Hcs/KotgY601JXmAYRdeSe/uruNp8+fVtP/2qWFVrD3Ivyo22FEVJaqX6yKyJvJNMtKO3fC1JX/XsCCbOpiTmn2JbEgWyb5iCs+CqNuTbjY/71MPxz4k1Qr0Z4M7bOYzPqusPp6ExUSh1KZTX1zWc646zAcarqpPX9ox9SWT3IBo4jEJBy6TNQGslP+B33X03bJ/Ma61k4zPytMm75yyg1Z2ESM/dBB3/ih4XyBpdPWwIXXgd7SrMNgg+ABcDVGqOcjsBh4fT4yMMh7lc1B9yZv1K5hohCymT940FcNZ31hKmrA25lF3UJGH9vM+ZdG8nlUJ2HIJ86ZyvxQgm5mttobjW1rgkTjeTaaXaFstVu7pQ7Z3203VsQwHbRYAF/VNwv0TP+Bx/DpARtrh4acVUHmdF2gpvy4mbz0jU3Xkkkbfz6pXWdXANVwPTFSpmiU9mEiYrWaNTn0JAp6v8LQrPmmY9fM9UfWZvvixm9lPUVBU/S8SQgvMGYjXOmjnOAbEabM3xYzVLeLoL6PpZ9fo5tMpnXKQhH7tOpfV31kwGDogzxtYcP854NfyTR6b6FwE6Cv1/MA/Pl59uA4KO3Z3hVemWnPsxijGA7F5AseM4H7LLEMZqEL2a10sRcoS0q4im3ho5MM5H9dbAuJKlfiB653Co7D20TA2myAfg1bhECBux6lq9a5R6622AbVrIV71BUJ0ilHeV9zUazG0a+rZzdWZM38KZYV2sJE+m+O5J4QuTicnxXG5SLJhK7JvO5GJNDkKzl0v6wwGkiJwfPxwuHb7FmpyNhiyX2oeTtsOpsYG71xI6H7vYcNhoIuc+NVg6SwXWP01JMMjGHvd/UhbUnsGNZbdp0IR7mz22kzUH6qVFDnTV4xNbw9HXtkaAZreGY+AOxYoyewMDqaLc5sDIJzaHo1/eHI6DmxdnnbncMZBmndseGPnE9nD0te3h0Ey3hqLxrb4NkOyNHZ4d96yfk+lVCDftpB0DZNXFleUmdaHrPhcaN+Kjzg0WVQgHrRtFwL0bCEPNm3XJCMNA1udC/+5DfraBl8F0pExHRMfiHg/UoR7MumTUYSDrc6HPI358KUficSOnUPx+8m6/njm8iArMh/qN+Uw3YtnwfLKfdn7d6HkagOmyT8jD/FmkX5cA2vlF35qpN9cgjrXCdiH1R8ljN0hmXrF+3ts/FkghwY2Q/fxS+j3u2ryPmN9aRc8GJk1+m/Lf+/v7fw==\";s:6:\"markup\";s:0:\"\";}s:5:\"users\";O:8:\"stdClass\":1:{s:5:\"login\";O:8:\"stdClass\":1:{s:4:\"form\";O:8:\"stdClass\":1:{s:4:\"data\";a:1:{s:6:\"return\";s:22:\"http://hewhodares.com/\";}}}}}}s:4:\"user\";O:5:\"JUser\":24:{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: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;s:1:\"1\";}s:14:\"\0*\0_authLevels\";a:1:{i:0;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:9:\"group_ids\";s:0:\"\";}s:13:\"session.token\";s:32:\"2cf2298e9e2f9b265c83fc6f9c1f0edf\";}__findCount|a:1:{s:7:\"Listing\";a:1:{s:32:\"f4b0c950867b221a681de9d299ee900c\";s:1:\"0\";}}', `time` = 1331767115
WHERE `session_id` = 'rlm8it4vg1bjnfo63cm3shpot7'
20 Query Types Logged, Sorted by Occurrences.
SELECT Tables:
10 × SELECT optname, value from k9n23_jvarcade_settings
3 × SELECT `id` FROM k9n23_menu
2 × SELECT a.`userid` as _userid , a.`status` as _status , a.`points` as _points, a.`posted_on` as _posted_on, a.`avatar` as _avatar , a.`thumb` as _thumb , a.`invite` as _invite, a.`params` as _cparams, a.`view` as _view, a.`friends` as _friends, a.`groups` as _groups, a.`events` as _events, a.`friendcount` as _friendcount, a.`alias` as _alias, a.`profile_id` as _profile_id, a.`storage` as _storage, a.`watermark_hash` as _watermark_hash, a.`search_email` as _search_email, s.`userid` as _isonline, u.* FROM `k9n23_community_users` as a LEFT JOIN `k9n23_users` u ON u.`id`=a.`userid` LEFT OUTER JOIN `k9n23_session` s ON s.`userid`=a.`userid` AND s.`client_id` !='1'
1 × SELECT * FROM k9n23_kunena_confi
1 × SELECT * FROM k9n23_easyblog_configs
1 × SELECT b.rules FROM k9n23_assets AS a LEFT JOIN k9n23_assets AS b ON b.lft <= a.lft AND b.rgt >= a.rgt
1 × SELECT * FROM k9n23_community_config
1 × SELECT `created` FROM k9n23_content a
1 × SELECT m.id, m.menutype, m.title, m.alias, 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 k9n23_menu AS m LEFT JOIN k9n23_extensions AS e ON m.component_id = e.extension_id
1 × SELECT * FROM k9n23_simanswers_config
1 × SELECT * FROM k9n23_simanswers_questions AS q
1 × SELECT * FROM k9n23_simanswers_questions
1 × SELECT `data` FROM `k9n23_session`
OTHER Tables:
1 × SHOW FULL COLUMNS FROM `k9n23_easyblog_configs
1 × UPDATE `k9n23_session` SET `data` = '__default|a:8:{s:15:\"session.counter\";i:5;s:19:\"session.timer.start\";i:1331766597;s:18:\"session.timer.last\";i:1331766928;s:17:\"session.timer.now\";i:1331767114;s:22:\"session.client.browser\";s:78:\"Mozilla/5.0 (X11; Ubuntu; Linux i686; rv:10.0.2) Gecko/20100101 Firefox/10.0.2\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":2:{s:12:\"mobilejoomla\";O:8:\"stdClass\":2:{s:5:\"cache\";s:1320:\"jVi7dtswDP2VHn5AYtF2kyhjO3Tq0KWjDyMiFhNRUiU6TtqTfy8fogQ+5GRqjXsB4kIAIYWVtPw3lrclGUEp0R5Hcs/KotgY601JXmAYRdeSe/uruNp8+fVtP/2qWFVrD3Ivyo22FEVJaqX6yKyJvJNMtKO3fC1JX/XsCCbOpiTmn2JbEgWyb5iCs+CqNuTbjY/71MPxz4k1Qr0Z4M7bOYzPqusPp6ExUSh1KZTX1zWc646zAcarqpPX9ox9SWT3IBo4jEJBy6TNQGslP+B33X03bJ/Ma61k4zPytMm75yyg1Z2ESM/dBB3/ih4XyBpdPWwIXXgd7SrMNgg+ABcDVGqOcjsBh4fT4yMMh7lc1B9yZv1K5hohCymT940FcNZ31hKmrA25lF3UJGH9vM+ZdG8nlUJ2HIJ86ZyvxQgm5mttobjW1rgkTjeTaaXaFstVu7pQ7Z3203VsQwHbRYAF/VNwv0TP+Bx/DpARtrh4acVUHmdF2gpvy4mbz0jU3Xkkkbfz6pXWdXANVwPTFSpmiU9mEiYrWaNTn0JAp6v8LQrPmmY9fM9UfWZvvixm9lPUVBU/S8SQgvMGYjXOmjnOAbEabM3xYzVLeLoL6PpZ9fo5tMpnXKQhH7tOpfV31kwGDogzxtYcP854NfyTR6b6FwE6Cv1/MA/Pl59uA4KO3Z3hVemWnPsxijGA7F5AseM4H7LLEMZqEL2a10sRcoS0q4im3ho5MM5H9dbAuJKlfiB653Co7D20TA2myAfg1bhECBux6lq9a5R6622AbVrIV71BUJ0ilHeV9zUazG0a+rZzdWZM38KZYV2sJE+m+O5J4QuTicnxXG5SLJhK7JvO5GJNDkKzl0v6wwGkiJwfPxwuHb7FmpyNhiyX2oeTtsOpsYG71xI6H7vYcNhoIuc+NVg6SwXWP01JMMjGHvd/UhbUnsGNZbdp0IR7mz22kzUH6qVFDnTV4xNbw9HXtkaAZreGY+AOxYoyewMDqaLc5sDIJzaHo1/eHI6DmxdnnbncMZBmndseGPnE9nD0te3h0Ey3hqLxrb4NkOyNHZ4d96yfk+lVCDftpB0DZNXFleUmdaHrPhcaN+Kjzg0WVQgHrRtFwL0bCEPNm3XJCMNA1udC/+5DfraBl8F0pExHRMfiHg/UoR7MumTUYSDrc6HPI358KUficSOnUPx+8m6/njm8iArMh/qN+Uw3YtnwfLKfdn7d6HkagOmyT8jD/FmkX5cA2vlF35qpN9cgjrXCdiH1R8ljN0hmXrF+3ts/FkghwY2Q/fxS+j3u2ryPmN9aRc8GJk1+m/Lf+/v7fw==\";s:6:\"markup\";s:0:\"\";}s:5:\"users\";O:8:\"stdClass\":1:{s:5:\"login\";O:8:\"stdClass\":1:{s:4:\"form\";O:8:\"stdClass\":1:{s:4:\"data\";a:1:{s:6:\"return\";s:22:\"http://hewhodares.com/\";}}}}}}s:4:\"user\";O:5:\"JUser\":24:{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: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;s:1:\"1\";}s:14:\"\0*\0_authLevels\";a:1:{i:0;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:9:\"group_ids\";s:0:\"\";}s:13:\"session.token\";s:32:\"2cf2298e9e2f9b265c83fc6f9c1f0edf\";}__findCount|a:1:{s:7:\"Listing\";a:1:{s:32:\"f4b0c950867b221a681de9d299ee900c\";s:1:\"0\";}}', `time` = 1331767115
1 × show tables like '%_kunena_users
1 × SHOW FULL COLUMNS FROM `k9n23_community_profiles
1 × UPDATE k9n23_simanswers_questions SET `put_to_vote`=1
1 × SHOW FULL COLUMNS FROM `k9n23_community_config
1 × SHOW FULL COLUMNS FROM `k9n23_simanswers_config
|
Speed