標題	作者	點擊數
博智專業講師- 唐道德先生	作者 Super User	點擊數: 2012
博智專業講師- 黃正頤老師	作者 Super User	點擊數: 2308
博智專業講師- 朱偉屏先生	作者 Super User	點擊數: 5258

Joomla! 除錯主控台

連線階段 (Session)

{"__default":{"session":{"counter":1,"timer":{"start":1621084429,"last":1621084429,"now":1621084429}},"registry":{"separator":"."},"user":{"id":0,"name":null,"username":null,"email":null,"password":null,"password_clear":"","block":null,"sendEmail":0,"registerDate":null,"lastvisitDate":null,"activation":null,"params":null,"groups":[],"guest":1,"lastResetTime":null,"resetCount":null,"requireReset":null,"aid":0}}}

側寫資訊

時間

記憶體

**時間**: 8.08 ms / 8.08 ms **記憶體**: 1.174 MB / 1.77 MB Application: afterLoad

**時間**: 73.09 ms / 81.18 ms **記憶體**: 9.215 MB / 10.98 MB Application: afterInitialise

**時間**: 30.24 ms / 111.42 ms **記憶體**: 4.359 MB / 15.34 MB Application: afterRoute

**時間**: 6.90 ms / 118.31 ms **記憶體**: 0.530 MB / 15.87 MB Application: beforeRenderComponent com_content

**時間**: 33.29 ms / 151.61 ms **記憶體**: 1.665 MB / 17.54 MB Application: Start JAccess::getAssetRules Old (1)

**時間**: 0.94 ms / 152.55 ms **記憶體**: 0.087 MB / 17.63 MB Application: Finish JAccess::getAssetRules Old (1)

**時間**: 0.06 ms / 152.61 ms **記憶體**: 0.000 MB / 17.62 MB Application: New JAccess Preloading Process(com_content.category)

**時間**: 1.17 ms / 153.77 ms **記憶體**: 0.171 MB / 17.79 MB Application: After preloadPermissionsParentIdMapping (com_content.category)

**時間**: 2.07 ms / 155.85 ms **記憶體**: 0.339 MB / 18.13 MB Application: After preloadPermissions (com_content.category)

**時間**: 0.02 ms / 155.87 ms **記憶體**: 0.002 MB / 18.13 MB Application: End New JAccess Preloading Process(com_content.category)

**時間**: 0.03 ms / 155.89 ms **記憶體**: 0.002 MB / 18.13 MB Application: Start JAccess::getAssetRules New (com_content.category.98)

**時間**: 0.16 ms / 156.05 ms **記憶體**: 0.013 MB / 18.14 MB Application: Finish JAccess::getAssetRules New (com_content.category.98)

**時間**: 5.99 ms / 162.03 ms **記憶體**: 0.523 MB / 18.67 MB Application: Start JAccess::preload(components)

**時間**: 3.67 ms / 165.70 ms **記憶體**: 0.367 MB / 19.03 MB Application: Finish JAccess::preload(components)

**時間**: 70.65 ms / 236.35 ms **記憶體**: 2.863 MB / 21.90 MB Application: afterRenderComponent com_content

**時間**: 0.51 ms / 236.86 ms **記憶體**: 0.006 MB / 21.90 MB Application: afterDispatch

**時間**: 13.09 ms / 249.95 ms **記憶體**: 0.796 MB / 22.70 MB Application: beforeRenderModule mod_custom (全站檢索)

**時間**: 1.72 ms / 251.68 ms **記憶體**: 0.123 MB / 22.82 MB Application: afterRenderModule mod_custom (全站檢索)

**時間**: 0.07 ms / 251.75 ms **記憶體**: 0.000 MB / 22.82 MB Application: beforeRenderModule mod_search (Search)

**時間**: 1.81 ms / 253.56 ms **記憶體**: 0.040 MB / 22.86 MB Application: afterRenderModule mod_search (Search)

**時間**: 0.13 ms / 253.68 ms **記憶體**: 0.000 MB / 22.85 MB Application: beforeRenderModule mod_languages (Language Switcher)

**時間**: 2.42 ms / 256.11 ms **記憶體**: 0.106 MB / 22.96 MB Application: afterRenderModule mod_languages (Language Switcher)

**時間**: 0.13 ms / 256.23 ms **記憶體**: 0.000 MB / 22.95 MB Application: beforeRenderModule mod_menu (Useful Links)

**時間**: 1.52 ms / 257.76 ms **記憶體**: 0.079 MB / 23.03 MB Application: afterRenderModule mod_menu (Useful Links)

**時間**: 0.12 ms / 257.87 ms **記憶體**: 0.000 MB / 23.03 MB Application: beforeRenderModule mod_menu (JA Fixel's Colors)

**時間**: 0.44 ms / 258.32 ms **記憶體**: 0.008 MB / 23.04 MB Application: afterRenderModule mod_menu (JA Fixel's Colors)

**時間**: 0.10 ms / 258.42 ms **記憶體**: 0.000 MB / 23.03 MB Application: beforeRenderModule mod_menu (Top)

**時間**: 0.40 ms / 258.81 ms **記憶體**: 0.008 MB / 23.04 MB Application: afterRenderModule mod_menu (Top)

**時間**: 0.10 ms / 258.91 ms **記憶體**: 0.000 MB / 23.04 MB Application: beforeRenderModule mod_custom (Social Link)

**時間**: 0.31 ms / 259.22 ms **記憶體**: 0.008 MB / 23.04 MB Application: afterRenderModule mod_custom (Social Link)

**時間**: 29.10 ms / 288.33 ms **記憶體**: 1.578 MB / 24.62 MB Application: afterRender

**資料庫查詢總計: 35.72 ms**

記憶體使用量

資料庫查詢

32 查詢記錄 35.72 ms

2 重覆被找到!

**2 重覆**: #20 #29

**查詢時間: 0.53 ms** **查詢記憶體: 0.019 MB 記憶體於查詢: 5.085 MB 前** **回傳的列: 0**

SELECT `data`

  FROM `yoj8h_session`

  WHERE `session_id` = 'glhqvos2nv71k2frlkfg7tpqn0'

**說明**

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	yoj8h_session	NULL	const	PRIMARY	PRIMARY	766	const	1	100.00	NULL

**側寫**

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.29 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.06 ms
executing	0.01 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

**呼叫堆疊**

#	Caller	檔案與行號
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
13	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:44
12	JSessionStorageDatabase->read()	*與下面行一樣的呼叫*
11	session_start()	JROOT/libraries/joomla/session/handler/native.php:259
10	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:49
9	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:81
8	JSessionHandlerJoomla->start()	JROOT/libraries/joomla/session/session.php:636
7	JSession->_start()	JROOT/libraries/joomla/session/session.php:596
6	JSession->start()	JROOT/libraries/cms/application/cms.php:773
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:408
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::getApplication()	JROOT/index.php:46

[**加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結**]

**查詢時間: 1.24 ms** **最後的查詢: 2.07 ms 之後** **查詢記憶體: 0.008 MB 記憶體於查詢: 5.411 MB 前**

DELETE 

  FROM `yoj8h_session`

  WHERE `time` < '1621083529'

**說明**

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	DELETE	yoj8h_session	NULL	range	time	time	59	const	1	100.00	Using where

**側寫**

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.05 ms
updating	0.14 ms
end	0.03 ms
query end	0.42 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

**呼叫堆疊**

#	Caller	檔案與行號
6	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:790
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:408
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::getApplication()	JROOT/index.php:46

[**加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結**]

**查詢時間: 0.18 ms** **最後的查詢: 0.26 ms 之後** **查詢記憶體: 0.012 MB 記憶體於查詢: 5.425 MB 前** **回傳的列: 0**

SELECT `session_id`

  FROM `yoj8h_session`

  WHERE `session_id` = 'glhqvos2nv71k2frlkfg7tpqn0' 
  LIMIT 1

**說明**

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	yoj8h_session	NULL	const	PRIMARY	PRIMARY	766	const	1	100.00	Using index

**側寫**

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
executing	0.01 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

**呼叫堆疊**

#	Caller	檔案與行號
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
7	JDatabaseDriver->loadResult()	JROOT/libraries/cms/application/cms.php:176
6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:799
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:408
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::getApplication()	JROOT/index.php:46

[**加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結**]

**查詢時間: 0.48 ms** **最後的查詢: 0.18 ms 之後** **查詢記憶體: 0.009 MB 記憶體於查詢: 5.440 MB 前**

INSERT INTO `yoj8h_session`
(`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) 
  VALUES 
('glhqvos2nv71k2frlkfg7tpqn0', 0, 1, '1621084429', 0, '')

**說明**

**EXPLAIN 無法被使用於查詢: INSERT INTO `yoj8h_session` (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) VALUES ('glhqvos2nv71k2frlkfg7tpqn0', 0, 1, '1621084429', 0, '')**

**側寫**

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
update	0.08 ms
end	0.00 ms
query end	0.29 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

**呼叫堆疊**

#	Caller	檔案與行號
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:212
6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:799
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:408
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::getApplication()	JROOT/index.php:46

[**加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結**]

**查詢時間: 9.28 ms** **最後的查詢: 2.49 ms 之後** **查詢記憶體: 0.018 MB 記憶體於查詢: 5.884 MB 前** **回傳的列: 35**

SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`

  FROM `yoj8h_extensions`

  WHERE `type` = 'component'

**說明**

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	yoj8h_extensions	NULL	ref	extension	extension	82	const	35	100.00	NULL

**側寫**

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.27 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.07 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.30 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

**呼叫堆疊**

#	Caller	檔案與行號
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
9	JDatabaseDriver->loadObjectList()	*與下面行一樣的呼叫*
8	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:152
7	JCacheControllerCallback->get()	JROOT/libraries/cms/component/helper.php:448
6	JComponentHelper::load()	JROOT/libraries/cms/component/helper.php:43
5	JComponentHelper::getComponent()	JROOT/libraries/cms/component/helper.php:120
4	JComponentHelper::getParams()	JROOT/libraries/cms/application/site.php:589
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

[**加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結**]

**查詢時間: 0.68 ms** **最後的查詢: 1.83 ms 之後** **查詢記憶體: 0.016 MB 記憶體於查詢: 6.176 MB 前** **回傳的列: 1**

SELECT b.id

  FROM yoj8h_usergroups AS a

  LEFT JOIN yoj8h_usergroups AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt

  WHERE a.id = 1

**說明**

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

**側寫**

Status	Duration
starting	0.07 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.30 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.09 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

**呼叫堆疊**

#	Caller	檔案與行號
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
10	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:835
9	JAccess::getGroupsByUser()	JROOT/libraries/joomla/access/access.php:904
8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:454
7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:296
6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:599
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

[**加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結**]

**查詢時間: 0.39 ms** **最後的查詢: 0.73 ms 之後** **查詢記憶體: 0.015 MB 記憶體於查詢: 6.310 MB 前** **回傳的列: 4**

SELECT id, rules

  FROM `yoj8h_viewlevels`

**說明**

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

**側寫**

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

**呼叫堆疊**

#	Caller	檔案與行號
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:921
8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:454
7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:296
6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:599
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

[**加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結**]

**查詢時間: 0.89 ms** **最後的查詢: 0.19 ms 之後** **查詢記憶體: 0.014 MB 記憶體於查詢: 6.328 MB 前** **回傳的列: 55**

SELECT folder AS type, element AS name, params

  FROM yoj8h_extensions

  WHERE enabled = 1 
  AND type ='plugin' 
  AND state IN (0,1) 
  AND access IN (1,1)

  ORDER BY ordering

**說明**

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	yoj8h_extensions	NULL	ref	extension	extension	82	const	75	0.52	Using index condition; Using where; 使用filesort

**側寫**

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

**呼叫堆疊**

#	Caller	檔案與行號
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
7	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/plugin/helper.php:310
6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:599
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

[**加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結**]

**查詢時間: 0.32 ms** **最後的查詢: 23.83 ms 之後** **查詢記憶體: 0.014 MB 記憶體於查詢: 9.546 MB 前** **回傳的列: 1**

SELECT `enabled`

  FROM `yoj8h_extensions`

  WHERE `element` = 'com_akeeba' 
  AND `type` = 'component'

**說明**

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	yoj8h_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	10.00	Using where

**側寫**

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.11 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.04 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

**呼叫堆疊**

#	Caller	檔案與行號
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
8	JDatabaseDriver->loadResult()	JROOT/plugins/system/backuponupdate/backuponupdate.php:50
7	require_once JROOT/plugins/system/backuponupdate/backuponupdate.php	JROOT/libraries/cms/plugin/helper.php:230
6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:669
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

[**加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結**]

**查詢時間: 2.74 ms** **最後的查詢: 11.03 ms 之後** **查詢記憶體: 0.045 MB 記憶體於查詢: 11.378 MB 前** **回傳的列: 130**

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 yoj8h_menu AS m

  LEFT JOIN yoj8h_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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	range	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	5	NULL	176	10.00	Using index condition; Using where; 使用filesort
1	SIMPLE	e	NULL	eq_ref	PRIMARY	PRIMARY	4	vhost13117-3.m.component_id	1	100.00	Using where

**側寫**

Status	Duration
starting	0.08 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.34 ms
init	0.04 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.08 ms
preparing	0.02 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	1.98 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

**呼叫堆疊**

#	Caller	檔案與行號
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/menu/site.php:86
14	JMenuSite->load()	JROOT/libraries/cms/menu/menu.php:74
13	JMenu->__construct()	JROOT/libraries/cms/menu/site.php:57
12	JMenuSite->__construct()	JROOT/libraries/cms/menu/menu.php:145
11	JMenu::getInstance()	JROOT/libraries/cms/application/cms.php:439
10	JApplicationCms->getMenu()	JROOT/libraries/cms/application/site.php:272
9	JApplicationSite->getMenu()	JROOT/libraries/cms/router/site.php:57
8	JRouterSite->__construct()	JROOT/libraries/cms/router/router.php:197
7	JRouter::getInstance()	JROOT/libraries/cms/application/cms.php:535
6	JApplicationCms::getRouter()	JROOT/libraries/cms/application/site.php:407
5	JApplicationSite::getRouter()	JROOT/libraries/cms/application/cms.php:1115
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

[**加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結**]

**查詢時間: 0.90 ms** **最後的查詢: 17.72 ms 之後** **查詢記憶體: 0.019 MB 記憶體於查詢: 15.038 MB 前** **回傳的列: 11**

SELECT id, home, template, s.params

  FROM yoj8h_template_styles as s

  LEFT JOIN yoj8h_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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	NULL	ALL	idx_template	NO INDEX KEY COULD BE USED	NULL	NULL	13	10.00	Using where
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	vhost13117-3.s.template,const	1	4.55	Using index condition; Using where

**側寫**

Status	Duration
starting	0.07 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.29 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.03 ms
executing	0.00 ms
Sending data	0.22 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

**呼叫堆疊**

#	Caller	檔案與行號
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
12	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/application/site.php:484
11	JApplicationSite->getTemplate()	JROOT/plugins/system/t3/includes/core/t3.php:307
10	T3::detect()	JROOT/plugins/system/t3/t3.php:81
9	plgSystemT3->onAfterRoute()	*與下面行一樣的呼叫*
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1125
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

[**加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結**]

**查詢時間: 0.36 ms** **最後的查詢: 7.29 ms 之後** **查詢記憶體: 0.020 MB 記憶體於查詢: 15.431 MB 前** **回傳的列: 1**

SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`

  FROM `yoj8h_extensions`

  WHERE `type` = 'library' 
  AND `element` = 'joomla'

**說明**

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	yoj8h_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	NULL

**側寫**

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.07 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.04 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

**呼叫堆疊**

#	Caller	檔案與行號
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
13	JDatabaseDriver->loadObject()	*與下面行一樣的呼叫*
12	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:152
11	JCacheControllerCallback->get()	JROOT/libraries/cms/library/helper.php:156
10	JLibraryHelper::_load()	JROOT/libraries/cms/library/helper.php:47
9	JLibraryHelper::getLibrary()	JROOT/libraries/cms/library/helper.php:90
8	JLibraryHelper::getParams()	JROOT/libraries/cms/version/version.php:274
7	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:755
6	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
5	JFactory::getDocument()	JROOT/libraries/joomla/application/web.php:977
4	JApplicationWeb->loadDocument()	JROOT/libraries/cms/application/site.php:130
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

[**加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結**]

**查詢時間: 0.64 ms** **最後的查詢: 0.30 ms 之後** **查詢記憶體: 0.012 MB 記憶體於查詢: 15.409 MB 前**

UPDATE `yoj8h_extensions`

  SET `params` = '{\"mediaversion\":\"8b4203d1ef8961b16be63a2f9c554f72\"}'

  WHERE `type` = 'library' 
  AND `element` = 'joomla'

**說明**

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	UPDATE	yoj8h_extensions	NULL	range	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	Using where

**側寫**

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.05 ms
updating	0.07 ms
end	0.02 ms
query end	0.39 ms
closing tables	0.02 ms
freeing items	0.02 ms
cleaning up	0.01 ms

**呼叫堆疊**

#	Caller	檔案與行號
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/library/helper.php:119
9	JLibraryHelper::saveParams()	JROOT/libraries/cms/version/version.php:325
8	JVersion->setMediaVersion()	JROOT/libraries/cms/version/version.php:284
7	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:755
6	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
5	JFactory::getDocument()	JROOT/libraries/joomla/application/web.php:977
4	JApplicationWeb->loadDocument()	JROOT/libraries/cms/application/site.php:130
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

[**加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結**]

**查詢時間: 0.63 ms** **最後的查詢: 2.28 ms 之後** **查詢記憶體: 0.014 MB 記憶體於查詢: 15.840 MB 前** **回傳的列: 1**

SELECT *

  FROM yoj8h_languages

  WHERE published=1

  ORDER BY ordering ASC

**說明**

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

**側寫**

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.30 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.08 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

**呼叫堆疊**

#	Caller	檔案與行號
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
6	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/language/helper.php:164
5	JLanguageHelper::getLanguages()	JROOT/libraries/cms/application/site.php:329
4	JApplicationSite->getParams()	JROOT/libraries/cms/application/site.php:135
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

[**加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結**]

**查詢時間: 0.79 ms** **最後的查詢: 33.55 ms 之後** **查詢記憶體: 0.034 MB 記憶體於查詢: 17.433 MB 前** **回傳的列: 8**

SHOW FULL COLUMNS 
  FROM `yoj8h_assets`

**說明**

**EXPLAIN 無法被使用於查詢: SHOW FULL COLUMNS FROM `yoj8h_assets`**

**側寫**

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.14 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.01 ms
Opening tables	0.28 ms
checking permissions	0.03 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
Sending data	0.04 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
removing tmp table	0.03 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

**呼叫堆疊**

#	Caller	檔案與行號
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
23	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
22	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
21	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
20	JTable->__construct()	JROOT/libraries/joomla/table/asset.php:60
19	JTableAsset->__construct()	JROOT/libraries/joomla/table/table.php:308
18	JTable::getInstance()	JROOT/libraries/joomla/access/access.php:696
17	JAccess::getExtensionNameFromAsset()	JROOT/libraries/joomla/access/access.php:555
16	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
15	JUser->authorise()	JROOT/components/com_content/models/category.php:142
14	ContentModelCategory->populateState()	JROOT/libraries/legacy/model/legacy.php:435
13	JModelLegacy->getState()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:394
12	JViewLegacy->get()	JROOT/libraries/legacy/view/category.php:114
11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

[**加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結**]

**查詢時間: 0.23 ms** **最後的查詢: 0.75 ms 之後** **查詢記憶體: 0.028 MB 記憶體於查詢: 17.520 MB 前** **回傳的列: 1**

SELECT *

  FROM yoj8h_assets

  WHERE `id` = '1'

**說明**

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	yoj8h_assets	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

**側寫**

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

**呼叫堆疊**

#	Caller	檔案與行號
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
19	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:719
18	JTable->load()	JROOT/libraries/joomla/access/access.php:697
17	JAccess::getExtensionNameFromAsset()	JROOT/libraries/joomla/access/access.php:555
16	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
15	JUser->authorise()	JROOT/components/com_content/models/category.php:142
14	ContentModelCategory->populateState()	JROOT/libraries/legacy/model/legacy.php:435
13	JModelLegacy->getState()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:394
12	JViewLegacy->get()	JROOT/libraries/legacy/view/category.php:114
11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

[**加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結**]

**查詢時間: 0.25 ms** **最後的查詢: 0.23 ms 之後** **查詢記憶體: 0.024 MB 記憶體於查詢: 17.542 MB 前** **回傳的列: 1**

SELECT a.rules

  FROM yoj8h_assets AS a

  WHERE (a.id = 1 OR a.name = 'root.1')

**說明**

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	index_merge	PRIMARY,idx_asset_name	PRIMARY,idx_asset_name	4,202	NULL	2	100.00	Using union(PRIMARY,idx_asset_name); Using where

**側寫**

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

**呼叫堆疊**

#	Caller	檔案與行號
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
17	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:652
16	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
15	JUser->authorise()	JROOT/components/com_content/models/category.php:142
14	ContentModelCategory->populateState()	JROOT/libraries/legacy/model/legacy.php:435
13	JModelLegacy->getState()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:394
12	JViewLegacy->get()	JROOT/libraries/legacy/view/category.php:114
11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

[**加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結**]

**查詢時間: 0.56 ms** **最後的查詢: 0.75 ms 之後** **查詢記憶體: 0.032 MB 記憶體於查詢: 17.621 MB 前** **回傳的列: 211**

SELECT a.id, a.parent_id

  FROM yoj8h_assets AS a

  WHERE (a.name LIKE 'com_content.%' OR a.name = 'com_content' OR a.id = 1)

**說明**

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ALL	PRIMARY,idx_asset_name	NO INDEX KEY COULD BE USED	NULL	NULL	307	20.26	Using where

**側寫**

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.32 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

**呼叫堆疊**

#	Caller	檔案與行號
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/access/access.php:332
18	JAccess::preloadPermissionsParentIdMapping()	JROOT/libraries/joomla/access/access.php:240
17	JAccess::preload()	JROOT/libraries/joomla/access/access.php:168
16	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
15	JUser->authorise()	JROOT/components/com_content/models/category.php:142
14	ContentModelCategory->populateState()	JROOT/libraries/legacy/model/legacy.php:435
13	JModelLegacy->getState()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:394
12	JViewLegacy->get()	JROOT/libraries/legacy/view/category.php:114
11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

[**加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結**]

**查詢時間: 0.53 ms** **最後的查詢: 0.95 ms 之後** **查詢記憶體: 0.033 MB 記憶體於查詢: 17.823 MB 前** **回傳的列: 211**

SELECT a.id, a.name, a.rules

  FROM yoj8h_assets AS a

  WHERE (a.name LIKE 'com_content.%' OR a.name = 'com_content' OR a.id = 1 )

**說明**

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ALL	PRIMARY,idx_asset_name	NO INDEX KEY COULD BE USED	NULL	NULL	307	20.26	Using where

**側寫**

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.33 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

**呼叫堆疊**

#	Caller	檔案與行號
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1255
19	JDatabaseDriver->getIterator()	JROOT/libraries/joomla/access/access.php:373
18	JAccess::preloadPermissions()	JROOT/libraries/joomla/access/access.php:243
17	JAccess::preload()	JROOT/libraries/joomla/access/access.php:168
16	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
15	JUser->authorise()	JROOT/components/com_content/models/category.php:142
14	ContentModelCategory->populateState()	JROOT/libraries/legacy/model/legacy.php:435
13	JModelLegacy->getState()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:394
12	JViewLegacy->get()	JROOT/libraries/legacy/view/category.php:114
11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

[**加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結**]

**查詢時間: 2.39 ms** **最後的查詢: 2.80 ms 之後** **查詢記憶體: 0.030 MB 記憶體於查詢: 18.341 MB 前** **回傳的列: 3**

**重覆查詢**: #29

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

  FROM yoj8h_categories as c

  LEFT JOIN  (SELECT cat.id as id 
  FROM yoj8h_categories AS cat JOIN yoj8h_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 yoj8h_categories AS s 
  ON (s.lft <= c.lft 
  AND s.rgt >= c.rgt) OR (s.lft > c.lft 
  AND s.rgt < c.rgt)

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1) 
  AND c.published = 1 
  AND badcats.id is null 
  AND s.id=98

  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

**說明**

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	s	NULL	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	Using temporary; 使用filesort
1	PRIMARY	c	NULL	range	cat_idx,idx_access,idx_left_right	cat_idx	207	NULL	12	55.55	Using index condition; Using where
1	PRIMARY	<derived2>	NULL	ref	<auto_key0>	<auto_key0>	4	vhost13117-3.c.id	10	100.00	Using where; Not exists; Using index
2	DERIVED	parent	NULL	range	cat_idx,idx_left_right	cat_idx	203	NULL	40	100.00	Using index condition; Using temporary; 使用filesort
2	DERIVED	cat	NULL	index	PRIMARY,cat_idx,idx_access,idx_checkout,idx_left_right,idx_language,idx_path,idx_alias	idx_left_right	8	NULL	96	11.11	Using where; Using index; Using join buffer (Block Nested Loop)

**側寫**

Status	Duration
starting	0.14 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.34 ms
init	0.10 ms
System lock	0.01 ms
optimizing	0.01 ms
optimizing	0.01 ms
statistics	0.11 ms
preparing	0.02 ms
Creating tmp table	0.02 ms
Sorting result	0.02 ms
statistics	0.17 ms
preparing	0.03 ms
Creating tmp table	0.04 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.05 ms
executing	0.00 ms
Sending data	0.73 ms
Creating sort index	0.34 ms
Creating sort index	0.05 ms
end	0.01 ms
query end	0.01 ms
removing tmp table	0.03 ms
query end	0.01 ms
removing tmp table	0.01 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

**呼叫堆疊**

#	Caller	檔案與行號
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:309
15	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
14	JCategories->get()	JROOT/components/com_content/models/category.php:354
13	ContentModelCategory->getCategory()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:394
12	JViewLegacy->get()	JROOT/libraries/legacy/view/category.php:115
11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

[**加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結**]

**查詢時間: 0.39 ms** **最後的查詢: 2.21 ms 之後** **查詢記憶體: 0.031 MB 記憶體於查詢: 18.663 MB 前** **回傳的列: 35**

SELECT element

  FROM yoj8h_extensions

  WHERE type = 'component' 
  AND enabled = '1'

**說明**

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	yoj8h_extensions	NULL	ref	extension	extension	82	const	35	10.00	Using where

**側寫**

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.19 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

**呼叫堆疊**

#	Caller	檔案與行號
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
22	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:413
21	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:213
20	JAccess::preload()	JROOT/libraries/joomla/access/access.php:168
19	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
18	JUser->authorise()	JROOT/components/com_content/models/articles.php:466
17	ContentModelArticles->getListQuery()	JROOT/libraries/legacy/model/list.php:129
16	JModelList->_getListQuery()	JROOT/libraries/legacy/model/list.php:183
15	JModelList->getItems()	JROOT/components/com_content/models/articles.php:565
14	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
13	ContentModelCategory->getItems()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:394
12	JViewLegacy->get()	JROOT/libraries/legacy/view/category.php:128
11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

[**加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結**]

**查詢時間: 0.94 ms** **最後的查詢: 0.26 ms 之後** **查詢記憶體: 0.031 MB 記憶體於查詢: 18.699 MB 前** **回傳的列: 35**

SELECT a.name, a.rules

  FROM yoj8h_assets AS a

  WHERE (a.name IN ('com_admin','com_ajax','com_akeeba','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_finder','com_installer','com_jaextmanager','com_joomlaupdate','com_jshopping','com_kunena','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_redirect','com_search','com_tags','com_templates','com_users','com_weblinks','com_wrapper') OR a.name = 'root.1')

**說明**

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ALL	idx_asset_name	NO INDEX KEY COULD BE USED	NULL	NULL	307	11.73	Using where

**側寫**

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

**呼叫堆疊**

#	Caller	檔案與行號
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
22	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:441
21	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:213
20	JAccess::preload()	JROOT/libraries/joomla/access/access.php:168
19	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
18	JUser->authorise()	JROOT/components/com_content/models/articles.php:466
17	ContentModelArticles->getListQuery()	JROOT/libraries/legacy/model/list.php:129
16	JModelList->_getListQuery()	JROOT/libraries/legacy/model/list.php:183
15	JModelList->getItems()	JROOT/components/com_content/models/articles.php:565
14	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
13	ContentModelCategory->getItems()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:394
12	JViewLegacy->get()	JROOT/libraries/legacy/view/category.php:128
11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

[**加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結**]

**查詢時間: 2.34 ms** **最後的查詢: 2.13 ms 之後** **查詢記憶體: 0.037 MB 記憶體於查詢: 19.025 MB 前** **回傳的列: 3**

SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language,  LENGTH(a.fulltext) AS readmore,
  CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
  CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published, 
  CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published

  FROM yoj8h_content AS a

  LEFT JOIN yoj8h_categories AS c 
  ON c.id = a.catid

  LEFT JOIN yoj8h_users AS ua 
  ON ua.id = a.created_by

  LEFT JOIN yoj8h_users AS uam 
  ON uam.id = a.modified_by

  LEFT JOIN yoj8h_categories as parent 
  ON parent.id = c.parent_id

  LEFT JOIN yoj8h_content_rating AS v 
  ON a.id = v.content_id

  LEFT 
  OUTER JOIN (SELECT cat.id as id 
  FROM yoj8h_categories AS cat JOIN yoj8h_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

  WHERE a.access IN (1,1) 
  AND c.access IN (1,1) 
  AND 
  CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 
  AND a.catid = 98 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2021-05-15 13:13:49') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-05-15 13:13:49')

  ORDER BY  c.lft,   
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END  DESC ,  a.created   
  LIMIT 10

**說明**

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	c	NULL	const	PRIMARY,idx_access	PRIMARY	4	const	1	100.00	使用filesort
1	PRIMARY	a	NULL	ref	idx_access,idx_catid	idx_catid	4	const	3	16.00	Using index condition; Using where
1	PRIMARY	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	vhost13117-3.a.created_by	1	100.00	Using where
1	PRIMARY	uam	NULL	eq_ref	PRIMARY	PRIMARY	4	vhost13117-3.a.modified_by	1	100.00	Using where
1	PRIMARY	parent	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	Using where
1	PRIMARY	v	NULL	eq_ref	PRIMARY	PRIMARY	4	vhost13117-3.a.id	1	100.00	Using where
1	PRIMARY	<derived2>	NULL	ref	<auto_key0>	<auto_key0>	4	const	10	100.00	Using where; Using index
2	DERIVED	parent	NULL	range	cat_idx,idx_left_right	cat_idx	203	NULL	40	100.00	Using index condition; Using temporary; 使用filesort
2	DERIVED	cat	NULL	index	PRIMARY,cat_idx,idx_access,idx_checkout,idx_left_right,idx_language,idx_path,idx_alias	idx_left_right	8	NULL	96	11.11	Using where; Using index; Using join buffer (Block Nested Loop)

**側寫**

Status	Duration
starting	0.17 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.55 ms
init	0.11 ms
System lock	0.01 ms
optimizing	0.01 ms
optimizing	0.01 ms
statistics	0.08 ms
preparing	0.02 ms
Creating tmp table	0.01 ms
Sorting result	0.02 ms
statistics	0.13 ms
preparing	0.03 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.19 ms
executing	0.01 ms
Sending data	0.68 ms
Creating sort index	0.13 ms
end	0.01 ms
query end	0.01 ms
removing tmp table	0.01 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	0.01 ms
closing tables	0.02 ms
freeing items	0.03 ms
cleaning up	0.01 ms

**呼叫堆疊**

#	Caller	檔案與行號
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:310
16	JModelLegacy->_getList()	JROOT/libraries/legacy/model/list.php:183
15	JModelList->getItems()	JROOT/components/com_content/models/articles.php:565
14	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
13	ContentModelCategory->getItems()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:394
12	JViewLegacy->get()	JROOT/libraries/legacy/view/category.php:128
11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

[**加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結**]

**查詢時間: 0.77 ms** **最後的查詢: 2.14 ms 之後** **查詢記憶體: 0.030 MB 記憶體於查詢: 19.409 MB 前** **回傳的列: 0**

SELECT `m`.`tag_id`,`t`.*

  FROM `yoj8h_contentitem_tag_map` AS m 

  INNER JOIN `yoj8h_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

  WHERE `m`.`type_alias` = 'com_content.article' 
  AND `m`.`content_item_id` = 156 
  AND `t`.`published` = 1 
  AND t.access IN (1,1)

**說明**

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ALL	idx_tag_type	NO INDEX KEY COULD BE USED	NULL	NULL	36	2.78	Using where
1	SIMPLE	t	NULL	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	vhost13117-3.m.tag_id	1	100.00	Using where

**側寫**

Status	Duration
starting	0.05 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.40 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.09 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.06 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

**呼叫堆疊**

#	Caller	檔案與行號
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:435
15	JHelperTags->getItemTags()	JROOT/components/com_content/models/articles.php:693
14	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
13	ContentModelCategory->getItems()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:394
12	JViewLegacy->get()	JROOT/libraries/legacy/view/category.php:128
11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

[**加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結**]

**查詢時間: 0.34 ms** **最後的查詢: 0.48 ms 之後** **查詢記憶體: 0.030 MB 記憶體於查詢: 19.449 MB 前** **回傳的列: 0**

SELECT `m`.`tag_id`,`t`.*

  FROM `yoj8h_contentitem_tag_map` AS m 

  INNER JOIN `yoj8h_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

  WHERE `m`.`type_alias` = 'com_content.article' 
  AND `m`.`content_item_id` = 149 
  AND `t`.`published` = 1 
  AND t.access IN (1,1)

**說明**

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ALL	idx_tag_type	NO INDEX KEY COULD BE USED	NULL	NULL	36	2.78	Using where
1	SIMPLE	t	NULL	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	vhost13117-3.m.tag_id	1	100.00	Using where

**側寫**

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

**呼叫堆疊**

#	Caller	檔案與行號
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:435
15	JHelperTags->getItemTags()	JROOT/components/com_content/models/articles.php:693
14	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
13	ContentModelCategory->getItems()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:394
12	JViewLegacy->get()	JROOT/libraries/legacy/view/category.php:128
11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

[**加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結**]

**查詢時間: 0.25 ms** **最後的查詢: 0.46 ms 之後** **查詢記憶體: 0.030 MB 記憶體於查詢: 19.488 MB 前** **回傳的列: 0**

SELECT `m`.`tag_id`,`t`.*

  FROM `yoj8h_contentitem_tag_map` AS m 

  INNER JOIN `yoj8h_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

  WHERE `m`.`type_alias` = 'com_content.article' 
  AND `m`.`content_item_id` = 145 
  AND `t`.`published` = 1 
  AND t.access IN (1,1)

**說明**

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ALL	idx_tag_type	NO INDEX KEY COULD BE USED	NULL	NULL	36	2.78	Using where
1	SIMPLE	t	NULL	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	vhost13117-3.m.tag_id	1	100.00	Using where

**側寫**

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

**呼叫堆疊**

#	Caller	檔案與行號
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:435
15	JHelperTags->getItemTags()	JROOT/components/com_content/models/articles.php:693
14	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
13	ContentModelCategory->getItems()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:394
12	JViewLegacy->get()	JROOT/libraries/legacy/view/category.php:128
11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

[**加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結**]

**查詢時間: 1.38 ms** **最後的查詢: 1.29 ms 之後** **查詢記憶體: 0.024 MB 記憶體於查詢: 19.713 MB 前** **回傳的列: 1**

SELECT COUNT(*)

  FROM yoj8h_content AS a

  LEFT JOIN yoj8h_categories AS c 
  ON c.id = a.catid

  LEFT JOIN yoj8h_users AS ua 
  ON ua.id = a.created_by

  LEFT JOIN yoj8h_users AS uam 
  ON uam.id = a.modified_by

  LEFT JOIN yoj8h_categories as parent 
  ON parent.id = c.parent_id

  LEFT JOIN yoj8h_content_rating AS v 
  ON a.id = v.content_id

  LEFT 
  OUTER JOIN (SELECT cat.id as id 
  FROM yoj8h_categories AS cat JOIN yoj8h_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

  WHERE a.access IN (1,1) 
  AND c.access IN (1,1) 
  AND 
  CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 
  AND a.catid = 98 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2021-05-15 13:13:49') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-05-15 13:13:49')

**說明**

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	c	NULL	const	PRIMARY,idx_access	PRIMARY	4	const	1	100.00	NULL
1	PRIMARY	a	NULL	ref	idx_access,idx_catid	idx_catid	4	const	3	16.00	Using where
1	PRIMARY	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	vhost13117-3.a.created_by	1	100.00	Using where; Using index
1	PRIMARY	uam	NULL	eq_ref	PRIMARY	PRIMARY	4	vhost13117-3.a.modified_by	1	100.00	Using where; Using index
1	PRIMARY	parent	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	Using where; Using index
1	PRIMARY	v	NULL	eq_ref	PRIMARY	PRIMARY	4	vhost13117-3.a.id	1	100.00	Using where; Using index
1	PRIMARY	<derived2>	NULL	ref	<auto_key0>	<auto_key0>	4	const	10	100.00	Using where; Using index
2	DERIVED	parent	NULL	range	cat_idx,idx_left_right	cat_idx	203	NULL	40	100.00	Using index condition; Using temporary; 使用filesort
2	DERIVED	cat	NULL	index	PRIMARY,cat_idx,idx_access,idx_checkout,idx_left_right,idx_language,idx_path,idx_alias	idx_left_right	8	NULL	96	11.11	Using where; Using index; Using join buffer (Block Nested Loop)

**側寫**

Status	Duration
starting	0.09 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.06 ms
System lock	0.01 ms
optimizing	0.01 ms
optimizing	0.01 ms
statistics	0.08 ms
preparing	0.02 ms
Creating tmp table	0.01 ms
Sorting result	0.02 ms
statistics	0.10 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.06 ms
executing	0.00 ms
Sending data	0.67 ms
Creating sort index	0.07 ms
end	0.01 ms
query end	0.01 ms
removing tmp table	0.01 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

**呼叫堆疊**

#	Caller	檔案與行號
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
17	JDatabaseDriver->loadResult()	JROOT/libraries/legacy/model/legacy.php:337
16	JModelLegacy->_getListCount()	JROOT/libraries/legacy/model/list.php:278
15	JModelList->getTotal()	JROOT/libraries/legacy/model/list.php:228
14	JModelList->getPagination()	JROOT/components/com_content/models/category.php:265
13	ContentModelCategory->getItems()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:394
12	JViewLegacy->get()	JROOT/libraries/legacy/view/category.php:128
11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

[**加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結**]

**查詢時間: 0.30 ms** **最後的查詢: 0.43 ms 之後** **查詢記憶體: 0.026 MB 記憶體於查詢: 19.719 MB 前** **回傳的列: 0**

SELECT `m`.`tag_id`,`t`.*

  FROM `yoj8h_contentitem_tag_map` AS m 

  INNER JOIN `yoj8h_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

  WHERE `m`.`type_alias` = 'com_content.category' 
  AND `m`.`content_item_id` = 98 
  AND `t`.`published` = 1 
  AND t.access IN (1,1)

**說明**

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ALL	idx_tag_type	NO INDEX KEY COULD BE USED	NULL	NULL	36	2.78	Using where
1	SIMPLE	t	NULL	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	vhost13117-3.m.tag_id	1	100.00	Using where

**側寫**

Status	Duration
starting	0.05 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.04 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

**呼叫堆疊**

#	Caller	檔案與行號
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
13	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:435
12	JHelperTags->getItemTags()	JROOT/libraries/legacy/view/category.php:217
11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

[**加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結**]

**查詢時間: 2.02 ms** **最後的查詢: 56.27 ms 之後** **查詢記憶體: 0.039 MB 記憶體於查詢: 22.114 MB 前** **回傳的列: 3**

**重覆查詢**: #20

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

  FROM yoj8h_categories as c

  LEFT JOIN  (SELECT cat.id as id 
  FROM yoj8h_categories AS cat JOIN yoj8h_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 yoj8h_categories AS s 
  ON (s.lft <= c.lft 
  AND s.rgt >= c.rgt) OR (s.lft > c.lft 
  AND s.rgt < c.rgt)

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1) 
  AND c.published = 1 
  AND badcats.id is null 
  AND s.id=98

  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

**說明**

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	s	NULL	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	Using temporary; 使用filesort
1	PRIMARY	c	NULL	range	cat_idx,idx_access,idx_left_right	cat_idx	207	NULL	12	55.55	Using index condition; Using where
1	PRIMARY	<derived2>	NULL	ref	<auto_key0>	<auto_key0>	4	vhost13117-3.c.id	10	100.00	Using where; Not exists; Using index
2	DERIVED	parent	NULL	range	cat_idx,idx_left_right	cat_idx	203	NULL	40	100.00	Using index condition; Using temporary; 使用filesort
2	DERIVED	cat	NULL	index	PRIMARY,cat_idx,idx_access,idx_checkout,idx_left_right,idx_language,idx_path,idx_alias	idx_left_right	8	NULL	96	11.11	Using where; Using index; Using join buffer (Block Nested Loop)

**側寫**

Status	Duration
starting	0.17 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.11 ms
System lock	0.01 ms
optimizing	0.01 ms
optimizing	0.01 ms
statistics	0.10 ms
preparing	0.02 ms
Creating tmp table	0.01 ms
Sorting result	0.02 ms
statistics	0.12 ms
preparing	0.03 ms
Creating tmp table	0.04 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.05 ms
executing	0.00 ms
Sending data	0.68 ms
Creating sort index	0.32 ms
Creating sort index	0.05 ms
end	0.01 ms
query end	0.01 ms
removing tmp table	0.03 ms
query end	0.01 ms
removing tmp table	0.01 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

**呼叫堆疊**

#	Caller	檔案與行號
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
23	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:309
22	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
21	JCategories->get()	JROOT/components/com_content/helpers/route.php:44
20	ContentHelperRoute::getArticleRoute()	JROOT/plugins/system/t3/base/html/com_content/category/default_articles.php:116
19	include JROOT/plugins/system/t3/base/html/com_content/category/default_articles.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
18	JViewLegacy->loadTemplate()	JROOT/plugins/system/t3/base/html/layouts/joomla/content/category_default.php:52
17	include JROOT/plugins/system/t3/base/html/layouts/joomla/content/category_default.php	JROOT/plugins/system/t3/includes/joomla25/layout/file.php:97
16	JLayoutFile->render()	JROOT/libraries/cms/layout/helper.php:72
15	JLayoutHelper::render()	JROOT/plugins/system/t3/base/html/com_content/category/default.php:20
14	include JROOT/plugins/system/t3/base/html/com_content/category/default.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
13	JViewLegacy->loadTemplate()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:207
12	JViewLegacy->display()	JROOT/libraries/legacy/view/category.php:233
11	JViewCategory->display()	JROOT/components/com_content/views/category/view.html.php:258
10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

[**加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結**]

**查詢時間: 2.20 ms** **最後的查詢: 10.07 ms 之後** **查詢記憶體: 0.028 MB 記憶體於查詢: 22.650 MB 前** **回傳的列: 43**

SELECT m.published, m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid

  FROM yoj8h_modules AS m

  LEFT JOIN yoj8h_modules_menu AS mm 
  ON mm.moduleid = m.id

  LEFT JOIN yoj8h_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 <= '2021-05-15 13:13:49') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2021-05-15 13:13:49') 
  AND m.access IN (1,1) 
  AND m.client_id = 0 
  AND (mm.menuid = 627 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

**說明**

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	range	PRIMARY,published,newsfeeds	published	5	NULL	49	1.60	Using index condition; Using where; 使用filesort
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid	element_clientid	403	vhost13117-3.m.module,const	1	10.00	Using index condition; Using where
1	SIMPLE	mm	NULL	ref	PRIMARY	PRIMARY	4	vhost13117-3.m.id	3	40.00	Using where; Using index

**側寫**

Status	Duration
starting	0.10 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.38 ms
init	0.05 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.11 ms
preparing	0.03 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	1.34 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

**呼叫堆疊**

#	Caller	檔案與行號
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
16	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:423
15	JModuleHelper::_load()	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:102
14	JModuleHelper::getModules()	JROOT/libraries/joomla/document/html.php:501
13	JDocumentHtml->countModules()	JROOT/plugins/system/t3/includes/core/template.php:608
12	T3Template->countModules()	JROOT/templates/ja_fixel/tpls/blocks/header.php:53
11	include JROOT/templates/ja_fixel/tpls/blocks/header.php	JROOT/plugins/system/t3/includes/core/template.php:176
10	T3Template->loadBlock()	JROOT/templates/ja_fixel/tpls/default.php:31
9	include JROOT/templates/ja_fixel/tpls/default.php	JROOT/plugins/system/t3/includes/core/template.php:200
8	T3Template->loadLayout()	JROOT/templates/ja_fixel/index.php:34
7	require JROOT/templates/ja_fixel/index.php	JROOT/libraries/joomla/document/html.php:578
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:640
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:455
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1072
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:49

[**加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結**]

**查詢時間: 0.31 ms** **最後的查詢: 8.50 ms 之後** **查詢記憶體: 0.020 MB 記憶體於查詢: 22.980 MB 前** **回傳的列: 2**

SELECT element

  FROM yoj8h_extensions

  WHERE type = 'language' 
  AND client_id = 0 
  AND enabled = 1

**說明**

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	yoj8h_extensions	NULL	ref	extension	extension	82	const	4	1.25	Using index condition; Using where

**側寫**

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

**呼叫堆疊**

#	Caller	檔案與行號
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
13	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/language/multilang.php:90
12	JLanguageMultilang::getSiteLangs()	JROOT/modules/mod_languages/helper.php:76
11	ModLanguagesHelper::getList()	JROOT/modules/mod_languages/mod_languages.php:17
10	include JROOT/modules/mod_languages/mod_languages.php	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:191
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:49

[**加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結**]

**查詢時間: 0.48 ms** **最後的查詢: 9.84 ms 之後** **查詢記憶體: 0.031 MB 記憶體於查詢: 23.907 MB 前** **回傳的列: 1**

SELECT * 
  FROM yoj8h_kunena_configuration 
  WHERE id=1

**說明**

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	yoj8h_kunena_configuration	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

**側寫**

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.23 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.00 ms

**呼叫堆疊**

#	Caller	檔案與行號
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
24	JDatabaseDriver->loadAssoc()	JROOT/libraries/kunena/config.php:1227
23	KunenaConfig->load()	JROOT/libraries/kunena/config.php:1174
22	KunenaConfig::getInstance()	JROOT/libraries/kunena/factory.php:28
21	KunenaFactory::getConfig()	JROOT/libraries/kunena/route/route.php:429
20	KunenaRoute::initialize()	JROOT/libraries/kunena/route/route.php:17
19	include JROOT/libraries/kunena/route/route.php	JROOT/libraries/loader.php:640
18	JLoader::_load()	JROOT/libraries/loader.php:595
17	JLoader::_autoload()	*與下面行一樣的呼叫*
16	spl_autoload_call()	JROOT/components/com_kunena/router.php:38
15	KunenaBuildRoute()	JROOT/libraries/cms/component/router/legacy.php:68
14	JComponentRouterLegacy->build()	JROOT/libraries/cms/router/site.php:496
13	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:465
12	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:281
11	JRouter->build()	JROOT/libraries/cms/router/site.php:147
10	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
9	JRoute::_()	JROOT/plugins/system/t3/includes/menu/megamenu.php:162
8	T3MenuMegamenu->__construct()	JROOT/plugins/system/t3/includes/renderer/megamenurender.php:87
7	JDocumentRendererMegamenuRender->render()	JROOT/libraries/joomla/document/html.php:411
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:49

[**加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結**]

26 查詢種類已記錄，由呈現記錄儲存。

選擇表格:

**4 × SELECT `m`.`tag_id`,`t`.* 
  FROM `yoj8h_contentitem_tag_map` AS m  
  INNER JOIN `yoj8h_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`**

**2 × SELECT element 
  FROM yoj8h_extensions**

**2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` 
  FROM `yoj8h_extensions`**

**2 × 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 
  FROM yoj8h_categories as c 
  LEFT JOIN  (SELECT cat.id as id 
  FROM yoj8h_categories AS cat JOIN yoj8h_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt**

**1 × SELECT a.id, a.name, a.rules 
  FROM yoj8h_assets AS a**

**1 × SELECT a.name, a.rules 
  FROM yoj8h_assets AS a**

**1 × SELECT a.id, a.parent_id 
  FROM yoj8h_assets AS a**

**1 × SELECT m.published, m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
  FROM yoj8h_modules AS m 
  LEFT JOIN yoj8h_modules_menu AS mm 
  ON mm.moduleid = m.id 
  LEFT JOIN yoj8h_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id**

**1 × SELECT COUNT(*) 
  FROM yoj8h_content AS a 
  LEFT JOIN yoj8h_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN yoj8h_users AS ua 
  ON ua.id = a.created_by 
  LEFT JOIN yoj8h_users AS uam 
  ON uam.id = a.modified_by 
  LEFT JOIN yoj8h_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN yoj8h_content_rating AS v 
  ON a.id = v.content_id 
  LEFT 
  OUTER JOIN (SELECT cat.id as id 
  FROM yoj8h_categories AS cat JOIN yoj8h_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt**

**1 × SELECT * 
  FROM yoj8h_kunena_configuration**

**1 × SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language,  LENGTH(a.fulltext) AS readmore,
  CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
  CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published, 
  CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published 
  FROM yoj8h_content AS a 
  LEFT JOIN yoj8h_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN yoj8h_users AS ua 
  ON ua.id = a.created_by 
  LEFT JOIN yoj8h_users AS uam 
  ON uam.id = a.modified_by 
  LEFT JOIN yoj8h_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN yoj8h_content_rating AS v 
  ON a.id = v.content_id 
  LEFT 
  OUTER JOIN (SELECT cat.id as id 
  FROM yoj8h_categories AS cat JOIN yoj8h_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt**

```
**1 × SELECT * 
  FROM yoj8h_assets**
```

**1 × SELECT folder AS type, element AS name, params 
  FROM yoj8h_extensions**

**1 × SELECT id, rules 
  FROM `yoj8h_viewlevels**

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

**1 × SELECT `session_id` 
  FROM `yoj8h_session`**

**1 × SELECT `enabled` 
  FROM `yoj8h_extensions`**

**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 yoj8h_menu AS m 
  LEFT JOIN yoj8h_extensions AS e 
  ON m.component_id = e.extension_id**

**1 × SELECT `data` 
  FROM `yoj8h_session`**

**1 × SELECT * 
  FROM yoj8h_languages**

**1 × SELECT id, home, template, s.params 
  FROM yoj8h_template_styles as s 
  LEFT JOIN yoj8h_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id**

**1 × SELECT a.rules 
  FROM yoj8h_assets AS a**

其他表格:

**1 × SHOW FULL COLUMNS 
  FROM `yoj8h_assets**

**1 × UPDATE `yoj8h_extensions` 
  SET `params` = '{\"mediaversion\":\"8b4203d1ef8961b16be63a2f9c554f72\"}'**

**1 × INSERT INTO `yoj8h_session` (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) 
  VALUES  ('glhqvos2nv71k2frlkfg7tpqn0', 0, 1, '1621084429', 0, ''**

**1 × DELETE  
  FROM `yoj8h_session`**

標題	作者	點擊數
博智專業講師- 唐道德先生	作者 Super User	點擊數: 2012
博智專業講師- 黃正頤老師	作者 Super User	點擊數: 2308
博智專業講師- 朱偉屏先生	作者 Super User	點擊數: 5258

全站檢索

Joomla! 除錯主控台

連線階段 (Session)

側寫資訊

時間

記憶體

記憶體使用量

資料庫查詢

32 查詢記錄 35.72 ms

2 重覆被找到!

26 查詢種類已記錄，由呈現記錄儲存。

選擇表格:

其他表格:

語言檔案解譯錯誤

語言檔案已載入

未翻譯字串

**Joomla! 除錯主控台**

**連線階段 (Session)**

**側寫資訊**

**時間**

**記憶體**

**記憶體使用量**

**資料庫查詢**

**32 查詢記錄** 35.72 ms

**2 重覆被找到!**

**26 查詢種類已記錄，由呈現記錄儲存。**

**選擇表格: **

**其他表格: **

**語言檔案解譯錯誤**

**語言檔案已載入**

**未翻譯字串**

Joomla! 除錯主控台

連線階段 (Session)

側寫資訊

時間

記憶體

記憶體使用量

資料庫查詢

32 查詢記錄 35.72 ms

2 重覆被找到!

26 查詢種類已記錄，由呈現記錄儲存。

選擇表格:

其他表格:

語言檔案解譯錯誤

語言檔案已載入

未翻譯字串