Joomla! Debug Console

Time

Memory

12 Queries Logged 11.2 ms

1. Query Time: 0.24 ms Query memory: 0.016 MB Memory before query: 2.447 MB Rows returned: 1

   SELECT `data`
   
     FROM `t0713_session`
   
     WHERE `session_id` = '8bca6f318458d377121c6db60e062203'

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	t0713_session	const	PRIMARY	PRIMARY	602	const	1	100.00	NULL

   Profile

   Status	Duration
   starting	0.0 ms
   checking permissions	0.0 ms
   Opening tables	0.0 ms
   init	0.0 ms
   System lock	0.0 ms
   optimizing	0.0 ms
   statistics	0.0 ms
   preparing	0.0 ms
   executing	0.0 ms
   Sending data	0.0 ms
   end	0.0 ms
   query end	0.0 ms
   closing tables	0.0 ms
   freeing items	0.0 ms
   cleaning up	0.0 ms

   Call Stack

   JROOT/libraries/joomla/session/storage/database.php:44

   JROOT/libraries/joomla/session/session.php:665

   JROOT/libraries/joomla/session/session.php:603

   JROOT/libraries/cms/application/cms.php:738

   JROOT/libraries/cms/application/cms.php:131

   JROOT/libraries/cms/application/site.php:63

   JROOT/libraries/cms/application/cms.php:398

   JROOT/libraries/joomla/factory.php:125

   JROOT/index.php:37

   [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

   ---

2. Query Time: 0.26 ms After last query: 3.41 ms Query memory: 0.008 MB Memory before query: 2.583 MB

   DELETE 
   
     FROM `t0713_session`
   
     WHERE `time` < '1429236469'

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	t0713_session	range	time	time	45	const	1	100.00	Using where

   Profile

   Status	Duration
   starting	0.0 ms
   checking permissions	0.0 ms
   Opening tables	0.0 ms
   init	0.0 ms
   System lock	0.1 ms
   updating	0.0 ms
   end	0.0 ms
   query end	0.0 ms
   closing tables	0.0 ms
   freeing items	0.0 ms
   cleaning up	0.0 ms

   Call Stack

   JROOT/libraries/cms/application/cms.php:755

   JROOT/libraries/cms/application/cms.php:131

   JROOT/libraries/cms/application/site.php:63

   JROOT/libraries/cms/application/cms.php:398

   JROOT/libraries/joomla/factory.php:125

   JROOT/index.php:37

   [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

   ---

3. Query Time: 0.91 ms After last query: 9.37 ms Query memory: 0.016 MB Memory before query: 2.947 MB Rows returned: 32

   SELECT extension_id AS id, element AS "option", params, enabled
   
     FROM t0713_extensions
   
     WHERE `type` = 'component'

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	t0713_extensions	ref	extension	extension	62	const	32	100.00	Using index condition

   Profile

   Status	Duration
   starting	0.1 ms
   checking permissions	0.0 ms
   Opening tables	0.0 ms
   init	0.0 ms
   System lock	0.0 ms
   optimizing	0.0 ms
   statistics	0.1 ms
   preparing	0.0 ms
   executing	0.0 ms
   Sending data	0.3 ms
   end	0.0 ms
   query end	0.0 ms
   closing tables	0.0 ms
   freeing items	0.0 ms
   cleaning up	0.1 ms

   Call Stack

   JROOT/libraries/joomla/cache/controller/callback.php:154

   JROOT/libraries/cms/component/helper.php:423

   JROOT/libraries/cms/component/helper.php:43

   JROOT/libraries/cms/component/helper.php:119

   JROOT/libraries/cms/application/site.php:568

   JROOT/libraries/cms/application/site.php:209

   JROOT/libraries/cms/application/cms.php:251

   JROOT/index.php:40

   [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

   ---

4. Query Time: 0.92 ms After last query: 3.26 ms Query memory: 0.012 MB Memory before query: 3.044 MB Rows returned: 40

   SELECT folder AS type, element AS name, params
   
     FROM t0713_extensions
   
     WHERE enabled = 1 
     AND type ='plugin' 
     AND state IN (0,1) 
     AND access IN (1,1,5)
   
     ORDER BY ordering

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	t0713_extensions	ref	extension	extension	62	const	61	100.00	Using index condition; Using where; Using filesort

   Profile

   Status	Duration
   starting	0.1 ms
   checking permissions	0.0 ms
   Opening tables	0.0 ms
   init	0.0 ms
   System lock	0.0 ms
   optimizing	0.0 ms
   statistics	0.1 ms
   preparing	0.0 ms
   Sorting result	0.0 ms
   executing	0.0 ms
   Sending data	0.0 ms
   Creating sort index	0.5 ms
   end	0.0 ms
   query end	0.0 ms
   closing tables	0.0 ms
   freeing items	0.0 ms
   cleaning up	0.0 ms

   Call Stack

   JROOT/libraries/cms/plugin/helper.php:310

   JROOT/libraries/cms/plugin/helper.php:163

   JROOT/libraries/cms/application/site.php:573

   JROOT/libraries/cms/application/site.php:209

   JROOT/libraries/cms/application/cms.php:251

   JROOT/index.php:40

   [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

   ---

5. Query Time: 0.95 ms After last query: 42.80 ms Query memory: 0.025 MB Memory before query: 4.483 MB Rows returned: 6

   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 t0713_menu AS m
   
     LEFT JOIN t0713_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

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	m	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	8	100.00	Using index condition; Using where; Using filesort
   1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	tranzfor_db.m.component_id	1	100.00	Using where

   Profile

   Status	Duration
   starting	0.2 ms
   checking permissions	0.0 ms
   checking permissions	0.0 ms
   Opening tables	0.0 ms
   init	0.1 ms
   System lock	0.0 ms
   optimizing	0.0 ms
   statistics	0.1 ms
   preparing	0.0 ms
   Sorting result	0.0 ms
   executing	0.0 ms
   Sending data	0.0 ms
   Creating sort index	0.2 ms
   end	0.0 ms
   query end	0.0 ms
   closing tables	0.0 ms
   freeing items	0.0 ms
   cleaning up	0.1 ms

   Call Stack

   JROOT/libraries/cms/menu/site.php:45

   JROOT/libraries/cms/menu/menu.php:64

   JROOT/libraries/cms/menu/menu.php:118

   JROOT/libraries/cms/application/cms.php:423

   JROOT/libraries/cms/application/site.php:272

   JROOT/libraries/cms/router/site.php:57

   JROOT/libraries/cms/router/router.php:196

   JROOT/libraries/cms/application/cms.php:519

   JROOT/libraries/cms/application/site.php:407

   JROOT/libraries/cms/application/cms.php:1087

   JROOT/libraries/cms/application/site.php:747

   JROOT/libraries/cms/application/site.php:215

   JROOT/libraries/cms/application/cms.php:251

   JROOT/index.php:40

   [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

   ---

6. Query Time: 0.47 ms After last query: 3.47 ms Query memory: 0.024 MB Memory before query: 4.622 MB Rows returned: 1

   SELECT extension_id AS id, element AS "option", params, enabled
   
     FROM t0713_extensions
   
     WHERE `type` = 'library' 
     AND `element` = 'joomla'

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	t0713_extensions	ref	element_clientid,element_folder_clientid,extension	extension	364	const,const	1	100.00	Using index condition

   Profile

   Status	Duration
   starting	0.1 ms
   checking permissions	0.0 ms
   Opening tables	0.0 ms
   init	0.0 ms
   System lock	0.0 ms
   optimizing	0.0 ms
   statistics	0.1 ms
   preparing	0.0 ms
   executing	0.0 ms
   Sending data	0.1 ms
   end	0.0 ms
   query end	0.0 ms
   closing tables	0.0 ms
   freeing items	0.0 ms
   cleaning up	0.1 ms

   Call Stack

   JROOT/libraries/joomla/cache/controller/callback.php:154

   JROOT/libraries/cms/library/helper.php:156

   JROOT/libraries/cms/library/helper.php:47

   JROOT/libraries/cms/library/helper.php:90

   JROOT/libraries/cms/version/version.php:177

   JROOT/libraries/joomla/factory.php:736

   JROOT/libraries/joomla/factory.php:216

   JROOT/plugins/system/jqueryeasy/jqueryeasy.php:55

   JROOT/libraries/joomla/event/event.php:69

   JROOT/libraries/joomla/event/dispatcher.php:160

   JROOT/libraries/joomla/application/base.php:83

   JROOT/libraries/cms/application/cms.php:1097

   JROOT/libraries/cms/application/site.php:747

   JROOT/libraries/cms/application/site.php:215

   JROOT/libraries/cms/application/cms.php:251

   JROOT/index.php:40

   [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

   ---

7. Query Time: 1.27 ms After last query: 3.94 ms Query memory: 0.017 MB Memory before query: 4.740 MB

   UPDATE `t0713_extensions`
   
     SET `params` = '{\"mediaversion\":\"cd9073f74fd8e09df62b98a44ffa91f9\"}'
   
     WHERE `type` = 'library' 
     AND `element` = 'joomla'

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	t0713_extensions	range	element_clientid,element_folder_clientid,extension	extension	364	const,const	1	100.00	Using where

   Profile

   Status	Duration
   starting	0.0 ms
   checking permissions	0.0 ms
   Opening tables	0.0 ms
   init	0.0 ms
   System lock	0.1 ms
   updating	0.1 ms
   end	0.0 ms
   query end	1.0 ms
   closing tables	0.0 ms
   freeing items	0.0 ms
   cleaning up	0.0 ms

   Call Stack

   JROOT/libraries/cms/library/helper.php:119

   JROOT/libraries/cms/version/version.php:228

   JROOT/libraries/cms/version/version.php:187

   JROOT/libraries/joomla/factory.php:736

   JROOT/libraries/joomla/factory.php:216

   JROOT/plugins/system/jqueryeasy/jqueryeasy.php:55

   JROOT/libraries/joomla/event/event.php:69

   JROOT/libraries/joomla/event/dispatcher.php:160

   JROOT/libraries/joomla/application/base.php:83

   JROOT/libraries/cms/application/cms.php:1097

   JROOT/libraries/cms/application/site.php:747

   JROOT/libraries/cms/application/site.php:215

   JROOT/libraries/cms/application/cms.php:251

   JROOT/index.php:40

   [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

   ---

8. Query Time: 0.50 ms After last query: 10.42 ms Query memory: 0.013 MB Memory before query: 5.094 MB Rows returned: 1

   SELECT *
   
     FROM t0713_languages
   
     WHERE published=1
   
     ORDER BY ordering ASC

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	t0713_languages	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Using where; Using filesort

   Profile

   Status	Duration
   starting	0.1 ms
   checking permissions	0.0 ms
   Opening tables	0.0 ms
   init	0.1 ms
   System lock	0.0 ms
   optimizing	0.0 ms
   statistics	0.0 ms
   preparing	0.0 ms
   Sorting result	0.0 ms
   executing	0.0 ms
   Sending data	0.0 ms
   Creating sort index	0.1 ms
   end	0.0 ms
   query end	0.0 ms
   closing tables	0.0 ms
   freeing items	0.0 ms
   cleaning up	0.0 ms

   Call Stack

   JROOT/libraries/joomla/language/helper.php:164

   JROOT/libraries/cms/application/site.php:329

   JROOT/libraries/cms/application/site.php:135

   JROOT/libraries/cms/application/site.php:230

   JROOT/libraries/cms/application/cms.php:251

   JROOT/index.php:40

   [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

   ---

9. Query Time: 0.45 ms After last query: 1.07 ms Query memory: 0.010 MB Memory before query: 5.115 MB Rows returned: 3

   SELECT id, home, template, s.params
   
     FROM t0713_template_styles as s
   
     LEFT JOIN t0713_extensions as e 
     ON e.element=s.template 
     AND e.type='template' 
     AND e.client_id=s.client_id
   
     WHERE s.client_id = 0 
     AND e.enabled = 1

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	s	ALL	idx_template	NO INDEX KEY COULD BE USED	NULL	NULL	5	100.00	Using where
   1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	303	tranzfor_db.s.template,const	1	100.00	Using index condition; Using where

   Profile

   Status	Duration
   starting	0.1 ms
   checking permissions	0.0 ms
   checking permissions	0.0 ms
   Opening tables	0.0 ms
   init	0.0 ms
   System lock	0.0 ms
   optimizing	0.0 ms
   statistics	0.1 ms
   preparing	0.0 ms
   executing	0.0 ms
   Sending data	0.1 ms
   end	0.0 ms
   query end	0.0 ms
   closing tables	0.0 ms
   freeing items	0.0 ms
   cleaning up	0.1 ms

   Call Stack

   JROOT/libraries/cms/application/site.php:484

   JROOT/libraries/cms/application/site.php:165

   JROOT/libraries/cms/application/site.php:230

   JROOT/libraries/cms/application/cms.php:251

   JROOT/index.php:40

   [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

   ---

10. Query Time: 2.79 ms After last query: 31.65 ms Query memory: 0.028 MB Memory before query: 6.005 MB Rows returned: 1

    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,COUNT(i.`id`) AS numitems
    
      FROM t0713_categories as c
    
      LEFT JOIN t0713_categories AS s 
      ON (s.lft <= c.lft 
      AND s.rgt >= c.rgt) OR (s.lft > c.lft 
      AND s.rgt < c.rgt)
    
      LEFT JOIN  (SELECT cat.id as id 
      FROM t0713_categories AS cat JOIN t0713_categories AS parent 
      ON cat.lft BETWEEN parent.lft 
      AND parent.rgt 
      WHERE parent.extension = 'com_content' 
      AND parent.published != 1 
      GROUP BY cat.id) AS badcats 
      ON badcats.id = c.id
    
      LEFT JOIN `t0713_content` AS i 
      ON i.`catid` = c.id 
      AND i.state = 1
    
      WHERE (c.extension='com_content' OR c.extension='system') 
      AND c.access IN (1,1,5) 
      AND c.published = 1 
      AND s.id=5 
      AND badcats.id is null
    
      GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    			 c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    			 c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    			 c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version
    
      ORDER BY c.lft

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	PRIMARY	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	Using temporary; Using filesort
    1	PRIMARY	c	ALL	cat_idx,idx_access,idx_left_right	NO INDEX KEY COULD BE USED	NULL	NULL	6	66.67	Using where
    1	PRIMARY	<derived2>	ref	<auto_key0>	<auto_key0>	4	tranzfor_db.c.id	2	100.00	Using where; Not exists; Using index
    1	PRIMARY	i	ALL	idx_state,idx_catid	NO INDEX KEY COULD BE USED	NULL	NULL	10	90.00	Using where; Using join buffer (Block Nested Loop)
    2	DERIVED	parent	ALL	cat_idx,idx_left_right	NO INDEX KEY COULD BE USED	NULL	NULL	6	33.33	Using where; Using temporary; Using filesort
    2	DERIVED	cat	index	PRIMARY,cat_idx,idx_access,idx_checkout,idx_path,idx_left_right,idx_alias,idx_language	idx_left_right	8	NULL	6	100.00	Using where; Using index; Using join buffer (Block Nested Loop)

    Profile

    Status	Duration
    starting	0.3 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    Opening tables	0.1 ms
    init	0.1 ms
    System lock	0.0 ms
    optimizing	0.0 ms
    optimizing	0.0 ms
    statistics	0.1 ms
    preparing	0.0 ms
    Creating tmp table	0.0 ms
    Sorting result	0.0 ms
    statistics	0.3 ms
    preparing	0.1 ms
    Creating tmp table	0.1 ms
    Sorting result	0.0 ms
    executing	0.0 ms
    Sending data	0.1 ms
    executing	0.0 ms
    Sending data	0.0 ms
    Creating sort index	0.0 ms
    removing tmp table	0.0 ms
    Creating sort index	0.9 ms
    Creating sort index	0.0 ms
    end	0.0 ms
    removing tmp table	0.2 ms
    end	0.0 ms
    query end	0.0 ms
    closing tables	0.0 ms
    removing tmp table	0.0 ms
    closing tables	0.0 ms
    freeing items	0.0 ms
    cleaning up	0.0 ms

    Call Stack

    JROOT/libraries/legacy/categories/categories.php:289

    JROOT/libraries/legacy/categories/categories.php:182

    JROOT/components/com_content/models/categories.php:115

    JROOT/libraries/legacy/view/legacy.php:401

    JROOT/libraries/legacy/view/categories.php:55

    JROOT/libraries/legacy/controller/legacy.php:690

    JROOT/components/com_content/controller.php:104

    JROOT/libraries/legacy/controller/legacy.php:728

    JROOT/components/com_content/content.php:16

    JROOT/libraries/cms/component/helper.php:380

    JROOT/libraries/cms/component/helper.php:360

    JROOT/libraries/cms/application/site.php:191

    JROOT/libraries/cms/application/site.php:230

    JROOT/libraries/cms/application/cms.php:251

    JROOT/index.php:40

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

11. Query Time: 1.13 ms After last query: 33.73 ms Query memory: 0.024 MB Memory before query: 7.041 MB Rows returned: 9

    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM t0713_modules AS m
    
      LEFT JOIN t0713_modules_menu AS mm 
      ON mm.moduleid = m.id
    
      LEFT JOIN t0713_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 <= '2015-04-17 03:37:49') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2015-04-17 03:37:49') 
      AND m.access IN (1,1,5) 
      AND m.client_id = 0 
      AND (mm.menuid = 111 OR mm.menuid <= 0)
    
      ORDER BY m.position, m.ordering

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	m	ref	PRIMARY,published,newsfeeds	published	1	const	12	100.00	Using index condition; Using where; Using filesort
    1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	tranzfor_db.m.id	1	100.00	Using where; Using index
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	303	tranzfor_db.m.module,const	1	100.00	Using index condition; Using where

    Profile

    Status	Duration
    starting	0.2 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    Opening tables	0.0 ms
    init	0.1 ms
    System lock	0.0 ms
    optimizing	0.0 ms
    statistics	0.2 ms
    preparing	0.1 ms
    Sorting result	0.0 ms
    executing	0.0 ms
    Sending data	0.0 ms
    Creating sort index	0.4 ms
    end	0.0 ms
    query end	0.0 ms
    closing tables	0.0 ms
    freeing items	0.0 ms
    cleaning up	0.0 ms

    Call Stack

    JROOT/libraries/cms/module/helper.php:376

    JROOT/libraries/cms/module/helper.php:84

    JROOT/libraries/joomla/document/html/html.php:501

    JROOT/templates/yoo_master2/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:54

    JROOT/templates/yoo_master2/layouts/theme.config.php:26

    JROOT/templates/yoo_master2/layouts/theme.php:10

    JROOT/templates/yoo_master2/warp/src/Warp/Helper/TemplateHelper.php:49

    JROOT/templates/yoo_master2/index.php:16

    JROOT/libraries/joomla/document/html/html.php:578

    JROOT/libraries/joomla/document/html/html.php:635

    JROOT/libraries/joomla/document/html/html.php:455

    JROOT/libraries/cms/application/cms.php:1044

    JROOT/libraries/cms/application/site.php:729

    JROOT/libraries/cms/application/cms.php:257

    JROOT/index.php:40

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

12. Query Time: 1.29 ms After last query: 110.59 ms Query memory: 0.003 MB Memory before query: 7.826 MB

    UPDATE `t0713_session`
    
      SET `data` = '__default|a:7:{s:15:\"session.counter\";i:4;s:19:\"session.timer.start\";i:1429241861;s:18:\"session.timer.last\";i:1429241865;s:17:\"session.timer.now\";i:1429241869;s:22:\"session.client.browser\";s:25:\"SiteSucker for OS X/2.6.5\";s:8:\"registry\";O:24:\"Joomla\\Registry\\Registry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":26:{s:9:\"\\0\\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: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:1:{i:0;s:1:\"9\";}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:12:\"requireReset\";N;s:10:\"\\0\\0\\0_params\";O:24:\"Joomla\\Registry\\Registry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:14:\"\\0\\0\\0_authGroups\";a:2:{i:0;i:1;i:1;i:9;}s:14:\"\\0\\0\\0_authLevels\";a:3:{i:0;i:1;i:1;i:1;i:2;i:5;}s:15:\"\\0\\0\\0_authActions\";N;s:12:\"\\0\\0\\0_errorMsg\";N;s:13:\"\\0\\0\\0userHelper\";O:18:\"JUserWrapperHelper\":0:{}s:10:\"\\0\\0\\0_errors\";a:0:{}s:3:\"aid\";i:0;}}'
    	, `time` = '1429241869'
    
      WHERE `session_id` = '8bca6f318458d377121c6db60e062203'

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	t0713_session	range	PRIMARY	PRIMARY	602	const	1	100.00	Using where

    Profile

    Status	Duration
    starting	0.1 ms
    checking permissions	0.0 ms
    Opening tables	0.0 ms
    init	0.0 ms
    System lock	0.1 ms
    updating	0.1 ms
    end	0.0 ms
    query end	0.8 ms
    closing tables	0.0 ms
    freeing items	0.0 ms
    cleaning up	0.0 ms

    Call Stack

    JROOT/libraries/joomla/session/storage/database.php:84

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

11 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

1. 2 × SELECT extension_id AS id, element AS "option", params, enabled 
     FROM t0713_extensions

2. 1 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,    c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,    c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,    c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
     CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,COUNT(i.`id`) AS numitems 
     FROM t0713_categories as c 
     LEFT JOIN t0713_categories AS s 
     ON (s.lft <= c.lft 
     AND s.rgt >= c.rgt) OR (s.lft > c.lft 
     AND s.rgt < c.rgt) 
     LEFT JOIN  (SELECT cat.id as id 
     FROM t0713_categories AS cat JOIN t0713_categories AS parent 
     ON cat.lft BETWEEN parent.lft 
     AND parent.rgt

3. 1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
     FROM t0713_modules AS m 
     LEFT JOIN t0713_modules_menu AS mm 
     ON mm.moduleid = m.id 
     LEFT JOIN t0713_extensions AS e 
     ON e.element = m.module 
     AND e.client_id = m.client_id

4. 1 × SELECT id, home, template, s.params 
     FROM t0713_template_styles as s 
     LEFT JOIN t0713_extensions as e 
     ON e.element=s.template 
     AND e.type='template' 
     AND e.client_id=s.client_id

5. 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 t0713_menu AS m 
     LEFT JOIN t0713_extensions AS e 
     ON m.component_id = e.extension_id

6. 1 × SELECT folder AS type, element AS name, params 
     FROM t0713_extensions

7. 1 × SELECT `data` 
     FROM `t0713_session`

8. 1 × SELECT * 
     FROM t0713_languages

OTHER Tables:

1. 1 × UPDATE `t0713_session` 
     SET `data` = '__default|a:7:{s:15:\"session.counter\";i:4;s:19:\"session.timer.start\";i:1429241861;s:18:\"session.timer.last\";i:1429241865;s:17:\"session.timer.now\";i:1429241869;s:22:\"session.client.browser\";s:25:\"SiteSucker for OS X/2.6.5\";s:8:\"registry\";O:24:\"Joomla\\Registry\\Registry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":26:{s:9:\"\\0\\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: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:1:{i:0;s:1:\"9\";}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:12:\"requireReset\";N;s:10:\"\\0\\0\\0_params\";O:24:\"Joomla\\Registry\\Registry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:14:\"\\0\\0\\0_authGroups\";a:2:{i:0;i:1;i:1;i:9;}s:14:\"\\0\\0\\0_authLevels\";a:3:{i:0;i:1;i:1;i:1;i:2;i:5;}s:15:\"\\0\\0\\0_authActions\";N;s:12:\"\\0\\0\\0_errorMsg\";N;s:13:\"\\0\\0\\0userHelper\";O:18:\"JUserWrapperHelper\":0:{}s:10:\"\\0\\0\\0_errors\";a:0:{}s:3:\"aid\";i:0;}}'  , `time` = '1429241869'

2. 1 × UPDATE `t0713_extensions` 
     SET `params` = '{\"mediaversion\":\"cd9073f74fd8e09df62b98a44ffa91f9\"}'

3. 1 × DELETE  
     FROM `t0713_session`