Profile Information
Application 0.001 seconds (+0.001); 0.33 MB (+0.33) - afterLoad
Application 0.035 seconds (+0.034); 2.90 MB (+2.57) - afterInitialise
Application 0.035 seconds (+0.000); 2.90 MB (+0.00) - afterRoute
Application 0.164 seconds (+0.129); 10.86 MB (+7.97) - afterDispatch
Application 0.206 seconds (+0.041); 11.64 MB (+0.77) - afterRender
Memory Usage
11.63 MB (12,197,444 Bytes)
32 Queries Logged

    SELECT `data`
      FROM `jos_test_session`
      WHERE `session_id` = 'f7cd41f019a061779cbeca219d53680c'
    DELETE
      FROM `jos_test_session`
      WHERE `time` < 1310051245
    SELECT extension_id AS "id", element AS "option", params, enabled
      FROM jos_test_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_languages'
    SELECT folder AS type, element AS name, params
      FROM jos_test_extensions
      WHERE enabled >= 1
      AND type ='plugin'
      AND state >= 0
      AND access IN (1,1,2,3)
      ORDER BY ordering
    SELECT template, params
      FROM jos_test_template_styles
      WHERE client_id = 1
      AND home = 1
    SELECT extension_id AS "id", element AS "option", params, enabled
      FROM jos_test_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_comprofiler'
    SELECT `id`
      FROM `jos_test_usergroups`
      WHERE `title` = 'Registered'
    SELECT `group_id`
      FROM `jos_test_user_usergroup_map`
      WHERE `user_id` = 42
    SELECT id, folder, element, published, type, params, CONCAT_WS('/',folder,element) AS lookup, name
      FROM jos_test_comprofiler_plugin
      WHERE published = 1
      AND access <= 8
      AND type = 'user'
      ORDER BY ordering
    SELECT extension_id AS "id", element AS "option", params, enabled
      FROM jos_test_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_users'
    SELECT `title`
      FROM `jos_test_usergroups`
      WHERE `id` = 2
    SELECT `id`
      FROM `jos_test_usergroups`
      WHERE `title` = 'Registered'
    SELECT g1.`id` AS group_id, g1.`title` AS name
      FROM `jos_test_usergroups` AS g1
      ORDER BY g1.`title`
    SELECT *
      FROM jos_test_comprofiler_tabs t
      WHERE t.enabled = 1
      AND t.useraccessgroupid IN (-2,-1,1,2,3,4,5,6,7,8,10,12)
      ORDER BY t.position, t.ordering
    SELECT f.*
      FROM jos_test_comprofiler_fields f
      INNER JOIN jos_test_comprofiler_tabs AS t
      ON (f.tabid = t.tabid)
      WHERE f.published = 1
      AND t.enabled = 1
      AND t.useraccessgroupid IN (-2,-1,1,2,3,4,5,6,7,8,10,12)
      ORDER BY t.position, t.ordering, f.ordering
    SELECT a.rules
      FROM jos_test_assets AS a
      WHERE a.id = 1
    SELECT b.rules
      FROM jos_test_assets AS a
      LEFT JOIN jos_test_assets AS b
      ON b.lft <= a.lft
      AND b.rgt >= a.rgt
      WHERE a.id = 1
      ORDER BY b.lft
    SELECT s.id, s.title, e.name as name, s.template
      FROM jos_test_template_styles as s
      LEFT JOIN jos_test_extensions as e
      on e.element=s.template
      WHERE s.client_id = 1
      ORDER BY template,title
    SELECT element
      FROM jos_test_extensions
      WHERE type='language'
      AND state=0
      AND enabled=1
      AND client_id=1
    SELECT element
      FROM jos_test_extensions
      WHERE type='language'
      AND state=0
      AND enabled=1
      AND client_id=0
    SELECT element AS value, name AS text
      FROM jos_test_extensions
      WHERE folder = 'editors'
      AND enabled = 1
      ORDER BY ordering, name
    SELECT `title`
      FROM `jos_test_usergroups`
      WHERE `id` = 2
    SELECT a.id
      FROM jos_test_user_usergroup_map AS map
      LEFT JOIN jos_test_usergroups AS a
      ON a.id = map.group_id
      WHERE map.user_id = 42
    SELECT g1.`id`
      FROM `jos_test_usergroups` AS g1
      LEFT JOIN `jos_test_usergroups` AS g2
      ON g2.`lft` < g1.`lft`
      AND g2.`rgt` > g1.`rgt`
      WHERE g2.`id` = 8
      ORDER BY g1.`title`
    SELECT a.`id` AS value, a.`title` AS text, COUNT( DISTINCT b.`id` ) AS level
      FROM `jos_test_usergroups` AS a
      LEFT JOIN `jos_test_usergroups` AS b
      ON a.`lft` > b.`lft`
      AND a.`rgt` < b.`rgt`
      GROUP BY a.`id`
      ORDER BY a.`lft` ASC
    SELECT id, title, module, position, content, showtitle, params, mm.menuid
      FROM jos_test_modules AS m
      LEFT JOIN jos_test_modules_menu AS mm
      ON mm.moduleid = m.id
      WHERE m.published = 1
      AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2011-07-07 15:22:25')
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2011-07-07 15:22:25')
      AND m.access IN (1,1,2,3)
      AND m.client_id = 1
      AND (mm.menuid = 0 OR mm.menuid <= 0)
      ORDER BY position, ordering
    SELECT COUNT(*)
      FROM jos_test_messages
      WHERE state = 0
      AND user_id_to = 42
    SELECT COUNT(session_id)
      FROM jos_test_session
      WHERE guest = 0
      AND client_id = 1
    SELECT COUNT(session_id)
      FROM jos_test_session
      WHERE guest = 0
      AND client_id = 0
    SELECT a.*, SUM(b.home) AS home
      FROM jos_test_menu_types AS a
      LEFT JOIN jos_test_menu AS b
      ON b.menutype = a.menutype
      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_test_menu AS m
      LEFT JOIN jos_test_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
    UPDATE `jos_test_session`
      SET `data` = '__default|a:8:{s:22:\"session.client.browser\";s:70:\"Mozilla/5.0 (Windows NT 6.1; WOW64; rv:5.0) Gecko/20100101 Firefox/5.0\";s:15:\"session.counter\";i:7;s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":4:{s:11:\"application\";O:8:\"stdClass\":1:{s:4:\"lang\";s:0:\"\";}s:21:\"searchcom_comprofiler\";s:0:\"\";s:29:\"viewcom_comprofilerlimitstart\";i:0;s:29:\"viewcom_comprofilerlastCBlist\";s:9:\"showusers\";}}s:4:\"user\";O:5:\"JUser\":23:{s:9:\"\0*\0isRoot\";b:1;s:2:\"id\";s:2:\"42\";s:4:\"name\";s:10:\"Super User\";s:8:\"username\";s:5:\"admin\";s:5:\"email\";s:13:\"paul@saary.de\";s:8:\"password\";s:65:\"dcb5540cece0aac026fe9ff508d68e20:hjVoBcjCkOGgca7uoPCSwhvmgJSodHoU\";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-07-06 15:40:44\";s:13:\"lastvisitDate\";s:19:\"2011-07-06 16:47:29\";s:10:\"activation\";s:0:\"\";s:6:\"params\";s:0:\"\";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\":0:{}}s:14:\"\0*\0_authGroups\";a:2:{i:0;i:1;i:1;i:8;}s:14:\"\0*\0_authLevels\";a:4:{i:0;i:1;i:1;i:1;i:2;i:2;i:3;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:13:\"session.token\";s:32:\"cc994b0369c38aa79637549c1d236da6\";s:19:\"session.timer.start\";i:1310052085;s:18:\"session.timer.last\";i:1310052108;s:17:\"session.timer.now\";i:1310052145;}', `time` = 1310052145
      WHERE `session_id` = 'f7cd41f019a061779cbeca219d53680c'

26 Query Types Logged, Sorted by Occurrences.
SELECT Tables:

    3 × SELECT extension_id AS "id", element AS "option", params, enabled FROM jos_test_extensions
    2 × SELECT element FROM jos_test_extensions
    2 × SELECT `title` FROM `jos_test_usergroups`
    2 × SELECT COUNT(session_id) FROM jos_test_session
    2 × SELECT `id` FROM `jos_test_usergroups`
    1 × SELECT g1.`id` FROM `jos_test_usergroups` AS g1 LEFT JOIN `jos_test_usergroups` AS g2 ON g2.`lft` < g1.`lft` AND g2.`rgt` > g1.`rgt`
    1 × SELECT element AS value, name AS text FROM jos_test_extensions
    1 × SELECT a.id FROM jos_test_user_usergroup_map AS map LEFT JOIN jos_test_usergroups AS a ON a.id = map.group_id
    1 × SELECT a.`id` AS value, a.`title` AS text, COUNT( DISTINCT b.`id` ) AS level FROM `jos_test_usergroups` AS a LEFT JOIN `jos_test_usergroups` AS b ON a.`lft` > b.`lft` AND a.`rgt` < b.`rgt` GROUP BY a.`id`
    1 × SELECT COUNT(*) FROM jos_test_messages
    1 × SELECT m.id, m.title, m.alias, m.link, m.parent_id, m.img, e.element FROM jos_test_menu AS m LEFT JOIN jos_test_extensions AS e ON m.component_id = e.extension_id
    1 × SELECT a.*, SUM(b.home) AS home FROM jos_test_menu_types AS a LEFT JOIN jos_test_menu AS b ON b.menutype = a.menutype
    1 × SELECT id, title, module, position, content, showtitle, params, mm.menuid FROM jos_test_modules AS m LEFT JOIN jos_test_modules_menu AS mm ON mm.moduleid = m.id
    1 × SELECT a.rules FROM jos_test_assets AS a
    1 × SELECT id, folder, element, published, type, params, CONCAT_WS('/',folder,element) AS lookup, name FROM jos_test_comprofiler_plugin
    1 × SELECT `group_id` FROM `jos_test_user_usergroup_map`
    1 × SELECT template, params FROM jos_test_template_styles
    1 × SELECT folder AS type, element AS name, params FROM jos_test_extensions
    1 × SELECT g1.`id` AS group_id, g1.`title` AS name FROM `jos_test_usergroups` AS g1
    1 × SELECT * FROM jos_test_comprofiler_tabs t
    1 × SELECT b.rules FROM jos_test_assets AS a LEFT JOIN jos_test_assets AS b ON b.lft <= a.lft AND b.rgt >= a.rgt
    1 × SELECT `data` FROM `jos_test_session`
    1 × SELECT f.* FROM jos_test_comprofiler_fields f INNER JOIN jos_test_comprofiler_tabs AS t ON (f.tabid = t.tabid)
    1 × SELECT s.id, s.title, e.name as name, s.template FROM jos_test_template_styles as s LEFT JOIN jos_test_extensions as e on e.element=s.template

OTHER Tables:

    1 × UPDATE `jos_test_session` SET `data` = '__default|a:8:{s:22:\"session.client.browser\";s:70:\"Mozilla/5.0 (Windows NT 6.1; WOW64; rv:5.0) Gecko/20100101 Firefox/5.0\";s:15:\"session.counter\";i:7;s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":4:{s:11:\"application\";O:8:\"stdClass\":1:{s:4:\"lang\";s:0:\"\";}s:21:\"searchcom_comprofiler\";s:0:\"\";s:29:\"viewcom_comprofilerlimitstart\";i:0;s:29:\"viewcom_comprofilerlastCBlist\";s:9:\"showusers\";}}s:4:\"user\";O:5:\"JUser\":23:{s:9:\"\0*\0isRoot\";b:1;s:2:\"id\";s:2:\"42\";s:4:\"name\";s:10:\"Super User\";s:8:\"username\";s:5:\"admin\";s:5:\"email\";s:13:\"paul@saary.de\";s:8:\"password\";s:65:\"dcb5540cece0aac026fe9ff508d68e20:hjVoBcjCkOGgca7uoPCSwhvmgJSodHoU\";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-07-06 15:40:44\";s:13:\"lastvisitDate\";s:19:\"2011-07-06 16:47:29\";s:10:\"activation\";s:0:\"\";s:6:\"params\";s:0:\"\";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\":0:{}}s:14:\"\0*\0_authGroups\";a:2:{i:0;i:1;i:1;i:8;}s:14:\"\0*\0_authLevels\";a:4:{i:0;i:1;i:1;i:1;i:2;i:2;i:3;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:13:\"session.token\";s:32:\"cc994b0369c38aa79637549c1d236da6\";s:19:\"session.timer.start\";i:1310052085;s:18:\"session.timer.last\";i:1310052108;s:17:\"session.timer.now\";i:1310052145;}', `time` = 1310052145
    1 × DELETE FROM `jos_test_session`