Joomla! 除错面板

时间

内存

20 查询记录 11.8 ms

1. Query Time: 0.28 ms

   SELECT `data`
   
     FROM `fj51l_session`
   
     WHERE `session_id` = 'c522339735f066260e0bac962497601c'

   解释

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

   方案

   No SHOW PROFILE (maybe because there are more than 100 queries)

   Call Stack

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

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

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

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

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

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

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

   JROOT/libraries/joomla/factory.php:124

   JROOT/index.php:39

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

   ---

2. Query Time: 0.42 ms After last query: 1.69 ms

   DELETE 
   
     FROM `fj51l_session`
   
     WHERE `time` < '1532241267'

   解释

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

   方案

   No SHOW PROFILE (maybe because there are more than 100 queries)

   Call Stack

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

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

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

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

   JROOT/libraries/joomla/factory.php:124

   JROOT/index.php:39

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

   ---

3. Query Time: 0.25 ms After last query: 0.19 ms

   SELECT `session_id`
   
     FROM `fj51l_session`
   
     WHERE `session_id` = 'c522339735f066260e0bac962497601c' 
     LIMIT 0, 1

   解释

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	fj51l_session	const	PRIMARY	PRIMARY	602	const	1	100.00	Using index

   方案

   No SHOW PROFILE (maybe because there are more than 100 queries)

   Call Stack

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

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

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

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

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

   JROOT/libraries/joomla/factory.php:124

   JROOT/index.php:39

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

   ---

4. Query Time: 1.14 ms After last query: 0.16 ms

   INSERT INTO `fj51l_session`
   (`session_id`, `client_id`, `time`) 
     VALUES 
   ('c522339735f066260e0bac962497601c', 0, '1532242167')

   解释

   EXPLAIN not possible on query: INSERT INTO `fj51l_session` (`session_id`, `client_id`, `time`) VALUES ('c522339735f066260e0bac962497601c', 0, '1532242167')

   方案

   No SHOW PROFILE (maybe because there are more than 100 queries)

   Call Stack

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

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

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

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

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

   JROOT/libraries/joomla/factory.php:124

   JROOT/index.php:39

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

   ---

5. Query Time: 0.54 ms After last query: 3.62 ms

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

   解释

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	fj51l_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	302	const	1	100.00	Using index condition; Using where

   方案

   No SHOW PROFILE (maybe because there are more than 100 queries)

   Call Stack

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

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

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

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

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

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

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

   JROOT/index.php:42

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

   ---

6. Query Time: 0.49 ms After last query: 1.39 ms

   SELECT b.id
   
     FROM fj51l_usergroups AS a
   
     LEFT JOIN fj51l_usergroups AS b 
     ON b.lft <= a.lft 
     AND b.rgt >= a.rgt
   
     WHERE a.id = 9

   解释

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	a	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
   1	SIMPLE	b	range	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	4	NULL	3	100.00	Using where; Using index

   方案

   No SHOW PROFILE (maybe because there are more than 100 queries)

   Call Stack

   JROOT/libraries/joomla/access/access.php:336

   JROOT/libraries/joomla/access/access.php:405

   JROOT/libraries/joomla/user/user.php:420

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

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

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

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

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

   JROOT/index.php:42

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

   ---

7. Query Time: 0.36 ms After last query: 0.69 ms

   SELECT id, rules
   
     FROM `fj51l_viewlevels`

   解释

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	fj51l_viewlevels	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	4	100.00	NULL

   方案

   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.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/access/access.php:422

   JROOT/libraries/joomla/user/user.php:420

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

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

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

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

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

   JROOT/index.php:42

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

   ---

8. Query Time: 0.58 ms After last query: 0.29 ms

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

   解释

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

   方案

   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.2 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:312

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

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

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

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

   JROOT/index.php:42

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

   ---

9. Query Time: 0.34 ms After last query: 0.47 ms

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

   解释

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	fj51l_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	302	const	1	100.00	Using index condition; Using where

   方案

   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.1 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/cache/controller/callback.php:158

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

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

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

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

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

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

   JROOT/index.php:42

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

   ---

10. Query Time: 0.49 ms After last query: 12.72 ms

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

    解释

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	fj51l_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	302	const	1	100.00	Using index condition; Using where

    方案

    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.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/cache/controller/callback.php:158

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

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

    JROOT/plugins/system/widgetkit_zoo/widgetkit_zoo.php:35

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

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

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

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

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

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

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

    JROOT/index.php:42

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

    ---

11. Query Time: 0.81 ms After last query: 7.17 ms

    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 fj51l_menu AS m
    
      LEFT JOIN fj51l_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

    解释

    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	23	100.00	Using index condition; Using where; Using filesort
    1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	zhoude.m.component_id	1	100.00	Using where

    方案

    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
    Sorting result	0.0 ms
    executing	0.0 ms
    Sending data	0.0 ms
    Creating sort index	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.0 ms

    Call Stack

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

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

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

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

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

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

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

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

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

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

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

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

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

    JROOT/index.php:42

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

    ---

12. Query Time: 0.57 ms After last query: 2.00 ms

    SELECT id, home, template, s.params
    
      FROM fj51l_template_styles as s
    
      LEFT JOIN fj51l_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

    解释

    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	6	100.00	Using where
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	303	zhoude.s.template,const	1	100.00	Using index condition; Using where

    方案

    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.0 ms

    Call Stack

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

    JROOT/plugins/system/t3/includes/core/t3.php:272

    JROOT/plugins/system/t3/t3.php:81

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

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

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

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

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

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

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

    JROOT/index.php:42

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

    ---

13. Query Time: 0.49 ms After last query: 6.87 ms

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

    解释

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

    方案

    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.0 ms

    Call Stack

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

    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:179

    JROOT/libraries/joomla/factory.php:734

    JROOT/libraries/joomla/factory.php:215

    JROOT/plugins/system/sef/sef.php:30

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

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

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

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

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

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

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

    JROOT/index.php:42

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

    ---

14. Query Time: 1.09 ms After last query: 0.37 ms

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

    解释

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

    方案

    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	0.7 ms
    closing tables	0.0 ms
    freeing items	0.1 ms
    cleaning up	0.0 ms

    Call Stack

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

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

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

    JROOT/libraries/joomla/factory.php:734

    JROOT/libraries/joomla/factory.php:215

    JROOT/plugins/system/sef/sef.php:30

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

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

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

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

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

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

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

    JROOT/index.php:42

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

    ---

15. Query Time: 0.56 ms After last query: 2.57 ms

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

    解释

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	fj51l_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	302	const	1	100.00	Using index condition; Using where

    方案

    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.0 ms

    Call Stack

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

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

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

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

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

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

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

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

    JROOT/index.php:42

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

    ---

16. Query Time: 0.43 ms After last query: 0.78 ms

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

    解释

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

    方案

    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.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:166

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

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

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

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

    JROOT/index.php:42

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

    ---

17. Query Time: 0.39 ms After last query: 0.29 ms

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

    解释

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	fj51l_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	302	const	1	100.00	Using index condition; Using where

    方案

    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.1 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/cache/controller/callback.php:158

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

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

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

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

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

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

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

    JROOT/index.php:42

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

    ---

18. Query Time: 0.51 ms After last query: 10.43 ms

    SELECT params 
      FROM fj51l_extensions AS e 
      WHERE e.element='com_widgetkit'

    解释

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

    方案

    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.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/administrator/components/com_widgetkit/helpers/system.php:254

    JROOT/administrator/components/com_widgetkit/helpers/system.php:54

    JROOT/administrator/components/com_widgetkit/classes/widgetkit.php:129

    JROOT/administrator/components/com_widgetkit/classes/widgetkit.php:76

    JROOT/administrator/components/com_widgetkit/classes/widgetkit.php:137

    JROOT/administrator/components/com_widgetkit/widgetkit.php:17

    JROOT/plugins/system/widgetkit_system/widgetkit_system.php:20

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

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

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

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

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

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

    JROOT/index.php:42

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

    ---

19. Query Time: 0.52 ms After last query: 1.30 ms

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

    解释

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	fj51l_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	302	const	1	100.00	Using index condition; Using where

    方案

    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.0 ms

    Call Stack

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

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

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

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

    JROOT/administrator/components/com_widgetkit/helpers/system.php:80

    JROOT/administrator/components/com_widgetkit/widgetkit.php:17

    JROOT/plugins/system/widgetkit_system/widgetkit_system.php:20

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

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

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

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

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

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

    JROOT/index.php:42

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

    ---

20. Query Time: 1.51 ms After last query: 17.40 ms

    UPDATE `fj51l_session`
    
      SET `data` = '__default|a:9:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1532242167;s:18:\"session.timer.last\";i:1532242167;s:17:\"session.timer.now\";i:1532242167;s:22:\"session.client.browser\";s:35:\"CCBot_2.0_http_commoncrawl.org_faq_\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":24:{s:9:\"\\0\\0\\0isRoot\";N;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:10:\"\\0\\0\\0_params\";O:9:\"JRegistry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:14:\"\\0\\0\\0_authGroups\";N;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:10:\"\\0\\0\\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:19:\"com_mailto.formtime\";i:1532242167;s:13:\"session.token\";s:32:\"d7dc4ff2b91528e45b62525e0af3812d\";}'
    	, `time` = '1532242167'
    
      WHERE `session_id` = 'c522339735f066260e0bac962497601c'

    解释

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

    方案

    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
    updating	0.2 ms
    end	0.0 ms
    query end	0.8 ms
    closing tables	0.0 ms
    freeing items	0.1 ms
    cleaning up	0.0 ms

    Call Stack

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

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

    ---

14 查询种类记录依照发现记录降序排序

选择表格:

1. 7 × SELECT extension_id AS id, element AS "option", params, enabled 
     FROM fj51l_extensions 

2. 1 × SELECT id, home, template, s.params 
     FROM fj51l_template_styles as s 
     LEFT JOIN fj51l_extensions as e 
     ON e.element=s.template 
     AND e.type='template' 
     AND e.client_id=s.client_id 

3. 1 × SELECT * 
     FROM fj51l_languages 

4. 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 fj51l_menu AS m 
     LEFT JOIN fj51l_extensions AS e 
     ON m.component_id = e.extension_id 

5. 1 × SELECT params 
     FROM fj51l_extensions AS e 

6. 1 × SELECT id, rules 
     FROM `fj51l_viewlevels 

7. 1 × SELECT `session_id` 
     FROM `fj51l_session` 

8. 1 × SELECT b.id 
     FROM fj51l_usergroups AS a 
     LEFT JOIN fj51l_usergroups AS b 
     ON b.lft <= a.lft 
     AND b.rgt >= a.rgt 

9. 1 × SELECT `data` 
     FROM `fj51l_session` 

10. 1 × SELECT folder AS type, element AS name, params 
      FROM fj51l_extensions 

其它表：

1. 1 × UPDATE `fj51l_session` 
     SET `data` = '__default|a:9:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1532242167;s:18:\"session.timer.last\";i:1532242167;s:17:\"session.timer.now\";i:1532242167;s:22:\"session.client.browser\";s:35:\"CCBot_2.0_http_commoncrawl.org_faq_\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":24:{s:9:\"\\0\\0\\0isRoot\";N;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:10:\"\\0\\0\\0_params\";O:9:\"JRegistry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:14:\"\\0\\0\\0_authGroups\";N;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:10:\"\\0\\0\\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:19:\"com_mailto.formtime\";i:1532242167;s:13:\"session.token\";s:32:\"d7dc4ff2b91528e45b62525e0af3812d\";}'  , `time` = '1532242167' 

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

3. 1 × INSERT INTO `fj51l_session` (`session_id`, `client_id`, `time`) 
     VALUES  ('c522339735f066260e0bac962497601c', 0, '1532242167' 

4. 1 × DELETE  
     FROM `fj51l_session`