YAOC 青進野外定向會

標題	作者	點擊數
定向心理學 - 梁智恩	作者 Administrator	點擊數: 1061
定向技術進階	作者 Administrator	點擊數: 1017
定向七宗罪 - Bruce	作者 Administrator	點擊數: 998
定向無敵武器	作者 Administrator	點擊數: 985
簡化地圖技巧 - Bruce	作者 Administrator	點擊數: 1111
反敗為勝的關鍵 - 梁智恩	作者 Administrator	點擊數: 987

Joomla! 除錯主控台

連線階段 (Session)

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1653068247,
                "last": 1653068247,
                "now": 1653068247
            },
            "token": "YI7gxH2DEqWS67kkEyGU1MeMkbhsIYRg"
        },
        "registry": {},
        "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
        },
        "jsn_mobilize_profile": null
    }
}

側寫資訊

時間

記憶體

時間: 19.22 ms / 19.22 ms 記憶體: 2.134 MB / 2.51 MB Application: afterLoad

時間: 115.49 ms / 134.72 ms 記憶體: 5.781 MB / 8.29 MB Application: afterInitialise

時間: 29.13 ms / 163.85 ms 記憶體: 1.156 MB / 9.44 MB Application: afterRoute

時間: 2.34 ms / 166.19 ms 記憶體: 0.033 MB / 9.48 MB Application: beforeRenderComponent com_content

時間: 6.60 ms / 172.80 ms 記憶體: 0.566 MB / 10.04 MB Application: Before Access::preloadComponents (all components)

時間: 5.36 ms / 178.16 ms 記憶體: 0.057 MB / 10.10 MB Application: After Access::preloadComponents (all components)

時間: 0.05 ms / 178.21 ms 記憶體: -0.003 MB / 10.10 MB Application: Before Access::preloadPermissions (com_content)

時間: 2.16 ms / 180.37 ms 記憶體: 0.182 MB / 10.28 MB Application: After Access::preloadPermissions (com_content)

時間: 0.04 ms / 180.41 ms 記憶體: -0.011 MB / 10.27 MB Application: Before Access::getAssetRules (id:359 name:com_content.category.87)

時間: 0.56 ms / 180.96 ms 記憶體: 0.026 MB / 10.29 MB Application: After Access::getAssetRules (id:359 name:com_content.category.87)

時間: 10.09 ms / 191.05 ms 記憶體: 0.281 MB / 10.57 MB Application: Before Access::getAssetRules (id:8 name:com_content)

時間: 0.03 ms / 191.08 ms 記憶體: 0.002 MB / 10.58 MB Application: After Access::getAssetRules (id:8 name:com_content)

時間: 194.85 ms / 385.93 ms 記憶體: 3.421 MB / 14.00 MB Application: afterRenderComponent com_content

時間: 0.41 ms / 386.34 ms 記憶體: 0.005 MB / 14.00 MB Application: afterDispatch

時間: 34.63 ms / 420.97 ms 記憶體: 1.082 MB / 15.08 MB Application: beforeRenderModule mod_menu (Menu)

時間: 1.61 ms / 422.57 ms 記憶體: 0.065 MB / 15.15 MB Application: afterRenderModule mod_menu (Menu)

時間: 0.69 ms / 423.26 ms 記憶體: 0.010 MB / 15.16 MB Application: beforeRenderModule mod_menu (Color Variations)

時間: 0.21 ms / 423.48 ms 記憶體: 0.006 MB / 15.16 MB Application: afterRenderModule mod_menu (Color Variations)

時間: 54.45 ms / 477.93 ms 記憶體: 2.896 MB / 18.06 MB Application: beforeRenderModule mod_custom (JoomlaShine copyright)

時間: 3.74 ms / 481.67 ms 記憶體: 0.023 MB / 18.08 MB Application: afterRenderModule mod_custom (JoomlaShine copyright)

時間: 0.05 ms / 481.72 ms 記憶體: 0.000 MB / 18.08 MB Application: beforeRenderModule mod_login (YAOCer登入)

時間: 1.70 ms / 483.42 ms 記憶體: 0.034 MB / 18.12 MB Application: afterRenderModule mod_login (YAOCer登入)

時間: 0.05 ms / 483.47 ms 記憶體: 0.002 MB / 18.12 MB Application: beforeRenderModule mod_menu (Main Menu)

時間: 6.01 ms / 489.48 ms 記憶體: 0.063 MB / 18.18 MB Application: afterRenderModule mod_menu (Main Menu)

時間: 0.07 ms / 489.54 ms 記憶體: 0.001 MB / 18.18 MB Application: beforeRenderModule mod_menu (Top Menu)

時間: 0.77 ms / 490.31 ms 記憶體: 0.010 MB / 18.19 MB Application: afterRenderModule mod_menu (Top Menu)

時間: 11.63 ms / 501.94 ms 記憶體: 0.679 MB / 18.87 MB Application: afterRender

資料庫查詢總計: 203.98 ms

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

#	Caller	檔案與行號
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
14	JSessionStorageDatabase->read()	與下面行一樣的呼叫
13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:88
10	JSessionHandlerJoomla->start()	JROOT/libraries/src/Session/Session.php:661
9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:621
8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:499
7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:456
6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:826
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

#	Caller	檔案與行號
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:828
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

EXPLAIN 無法被使用於查詢: INSERT INTO `jos1s_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3865656633353137323638616165653062643433666634663431363965346336', 1, 1653068247, 0, '', 0)

側寫

Status	Duration
starting	0.08 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
update	1.03 ms
Waiting for query cache lock	0.01 ms
update	0.01 ms
end	0.01 ms
query end	0.02 ms
closing tables	0.01 ms
freeing items	0.05 ms
cleaning up	0.01 ms

呼叫堆疊

#	Caller	檔案與行號
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:828
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

查詢時間: 3.85 ms 最後的查詢: 2.39 ms 之後查詢記憶體: 0.030 MB 記憶體於查詢: 4.532 MB 前回傳的列: 40

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

  FROM `jos1s_extensions`

  WHERE `type` = 'component' 
  AND `state` = 0 
  AND `enabled` = 1

說明

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jos1s_extensions	NULL	ref	extension	extension	82	const	40	1.00	Using where

側寫

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

呼叫堆疊

#	Caller	檔案與行號
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Component/ComponentHelper.php:445
10	Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}()	與下面行一樣的呼叫
9	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
8	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Component/ComponentHelper.php:453
7	Joomla\CMS\Component\ComponentHelper::load()	JROOT/libraries/src/Component/ComponentHelper.php:519
6	Joomla\CMS\Component\ComponentHelper::getComponents()	JROOT/libraries/src/Component/ComponentHelper.php:44
5	Joomla\CMS\Component\ComponentHelper::getComponent()	JROOT/libraries/src/Component/ComponentHelper.php:103
4	Joomla\CMS\Component\ComponentHelper::getParams()	JROOT/libraries/src/Application/SiteApplication.php:594
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 1.52 ms 最後的查詢: 2.44 ms 之後查詢記憶體: 0.023 MB 記憶體於查詢: 4.728 MB 前回傳的列: 5

SELECT id, rules

  FROM `jos1s_viewlevels`

說明

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

側寫

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

呼叫堆疊

#	Caller	檔案與行號
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Access/Access.php:1063
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:318
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 1.53 ms 最後的查詢: 0.10 ms 之後查詢記憶體: 0.022 MB 記憶體於查詢: 4.740 MB 前回傳的列: 2

SELECT b.id

  FROM jos1s_usergroups AS a

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

  WHERE a.id = 9

說明

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	2	100.00	Using where; Using index

側寫

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

呼叫堆疊

#	Caller	檔案與行號
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
10	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
9	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/Access/Access.php:1095
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:318
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 2.26 ms 最後的查詢: 0.67 ms 之後查詢記憶體: 0.034 MB 記憶體於查詢: 4.806 MB 前回傳的列: 109

SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`

  FROM jos1s_extensions

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

  ORDER BY ordering

說明

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

側寫

Status	Duration
starting	0.11 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.02 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
Creating sort index	1.83 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.06 ms
cleaning up	0.01 ms

呼叫堆疊

#	Caller	檔案與行號
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:351
9	Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()	與下面行一樣的呼叫
8	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
7	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Plugin/PluginHelper.php:356
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 0.82 ms 最後的查詢: 12.35 ms 之後查詢記憶體: 0.028 MB 記憶體於查詢: 6.186 MB 前回傳的列: 123

重覆查詢: #11 #60 #71 #74 #87

SHOW TABLES

說明

EXPLAIN 無法被使用於查詢: SHOW TABLES

側寫

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

呼叫堆疊

#	Caller	檔案與行號
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
10	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/database/driver/mysqli.php:505
9	JDatabaseDriverMysqli->getTableList()	JROOT/plugins/system/jsnframework/libraries/joomlashine/config/helper.php:68
8	JSNConfigHelper::get()	JROOT/plugins/system/jsnpoweradmin/jsnpoweradmin.php:98
7	plgSystemJsnpoweradmin->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:667
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 0.41 ms 最後的查詢: 0.11 ms 之後查詢記憶體: 0.023 MB 記憶體於查詢: 6.208 MB 前回傳的列: 0

SELECT name,value

  FROM jos1s_jsn_poweradmin_config

  WHERE 1

說明

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table

側寫

Status	Duration
starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.16 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
executing	0.01 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.05 ms
cleaning up	0.01 ms

呼叫堆疊

#	Caller	檔案與行號
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
9	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/jsnframework/libraries/joomlashine/config/helper.php:81
8	JSNConfigHelper::get()	JROOT/plugins/system/jsnpoweradmin/jsnpoweradmin.php:98
7	plgSystemJsnpoweradmin->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:667
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 1.02 ms 最後的查詢: 0.92 ms 之後查詢記憶體: 0.022 MB 記憶體於查詢: 6.256 MB 前回傳的列: 1

SELECT COUNT(*)

  FROM jos1s_extensions

  WHERE element="jsnadminbar"

說明

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jos1s_extensions	NULL	ref	element_clientid,element_folder_clientid	element_clientid	402	const	1	100.00	Using index

側寫

Status	Duration
starting	0.08 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.66 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.05 ms
cleaning up	0.01 ms

呼叫堆疊

#	Caller	檔案與行號
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
9	JDatabaseDriver->loadResult()	JROOT/plugins/system/jsnpoweradmin/jsnpoweradmin.php:913
8	plgSystemJsnpoweradmin->_removeAdminBarPlugin()	JROOT/plugins/system/jsnpoweradmin/jsnpoweradmin.php:105
7	plgSystemJsnpoweradmin->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:667
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 1.11 ms 最後的查詢: 25.93 ms 之後查詢記憶體: 0.029 MB 記憶體於查詢: 7.525 MB 前回傳的列: 123

重覆查詢: #8 #60 #71 #74 #87

SHOW TABLES

說明

EXPLAIN 無法被使用於查詢: SHOW TABLES

側寫

Status	Duration
starting	0.15 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
Opening tables	0.06 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.01 ms
checking permissions	0.48 ms
Sending data	0.07 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
removing tmp table	0.01 ms
closing tables	0.01 ms
freeing items	0.07 ms
cleaning up	0.02 ms

呼叫堆疊

#	Caller	檔案與行號
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
11	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/database/driver/mysqli.php:505
10	JDatabaseDriverMysqli->getTableList()	JROOT/plugins/system/jsnframework/libraries/joomlashine/config/helper.php:68
9	JSNConfigHelper::get()	JROOT/plugins/system/jsnmobilize/jsnmobilize.php:114
8	PlgSystemJSNMobilize->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 2.97 ms 最後的查詢: 0.12 ms 之後查詢記憶體: 0.023 MB 記憶體於查詢: 7.546 MB 前回傳的列: 5

SELECT name,value

  FROM jos1s_jsn_mobilize_config

  WHERE 1

說明

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

側寫

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

呼叫堆疊

#	Caller	檔案與行號
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/jsnframework/libraries/joomlashine/config/helper.php:81
9	JSNConfigHelper::get()	JROOT/plugins/system/jsnmobilize/jsnmobilize.php:114
8	PlgSystemJSNMobilize->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 1.63 ms 最後的查詢: 1.47 ms 之後查詢記憶體: 0.024 MB 記憶體於查詢: 7.651 MB 前回傳的列: 1

重覆查詢: #19 #98

SELECT *

  FROM jos1s_jsn_mobilize_os

  WHERE os_type = 'other'

說明

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jos1s_jsn_mobilize_os	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	12	10.00	Using where

側寫

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

呼叫堆疊

#	Caller	檔案與行號
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/templates/jsn_mobilize/helpers/mobilize.php:445
10	JSNMobilizeTemplateHelper::getOSSupport()	JROOT/templates/jsn_mobilize/helpers/mobilize.php:85
9	JSNMobilizeTemplateHelper::getConfig()	JROOT/plugins/system/jsnmobilize/jsnmobilize.php:144
8	PlgSystemJSNMobilize->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 1.42 ms 最後的查詢: 0.24 ms 之後查詢記憶體: 0.026 MB 記憶體於查詢: 7.660 MB 前回傳的列: 0

重覆查詢: #20 #99

SELECT *

  FROM jos1s_jsn_mobilize_profiles AS p

  INNER JOIN jos1s_jsn_mobilize_os_support AS s 
  ON s.profile_id = p.profile_id

  WHERE s.os_id = '11' 
  AND p.profile_state = 1 
  AND p.profile_device = "jsn_mobile" 
  LIMIT 1

說明

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	4	25.00	Using where
1	SIMPLE	p	NULL	eq_ref	PRIMARY	PRIMARY	4	yaocorg_joom327.s.profile_id	1	100.00	Using where

側寫

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

呼叫堆疊

#	Caller	檔案與行號
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
11	JDatabaseDriver->loadObject()	JROOT/templates/jsn_mobilize/helpers/mobilize.php:512
10	JSNMobilizeTemplateHelper::getOSSupport()	JROOT/templates/jsn_mobilize/helpers/mobilize.php:85
9	JSNMobilizeTemplateHelper::getConfig()	JROOT/plugins/system/jsnmobilize/jsnmobilize.php:144
8	PlgSystemJSNMobilize->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 1.45 ms 最後的查詢: 0.07 ms 之後查詢記憶體: 0.024 MB 記憶體於查詢: 7.664 MB 前回傳的列: 0

重覆查詢: #21 #100

SELECT *

  FROM jos1s_jsn_mobilize_design

  WHERE profile_id = ''

說明

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jos1s_jsn_mobilize_design	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	22	10.00	Using where

側寫

Status	Duration
starting	0.06 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.01 ms
preparing	0.01 ms
executing	0.01 ms
Sending data	0.98 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.05 ms
cleaning up	0.01 ms

呼叫堆疊

#	Caller	檔案與行號
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/templates/jsn_mobilize/helpers/mobilize.php:519
10	JSNMobilizeTemplateHelper::getOSSupport()	JROOT/templates/jsn_mobilize/helpers/mobilize.php:85
9	JSNMobilizeTemplateHelper::getConfig()	JROOT/plugins/system/jsnmobilize/jsnmobilize.php:144
8	PlgSystemJSNMobilize->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 6.37 ms 最後的查詢: 2.38 ms 之後查詢記憶體: 0.054 MB 記憶體於查詢: 7.913 MB 前回傳的列: 36

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

  LEFT JOIN jos1s_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	140	10.00	Using index condition; Using where; 使用filesort
1	SIMPLE	e	NULL	eq_ref	PRIMARY	PRIMARY	4	yaocorg_joom327.m.component_id	1	100.00	Using where

側寫

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

呼叫堆疊

#	Caller	檔案與行號
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
21	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	與下面行一樣的呼叫
20	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
19	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
18	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:78
17	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
16	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:142
15	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:417
14	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
13	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:65
12	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
11	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:533
10	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
9	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/plugins/system/jsnmobilize/jsnmobilize.php:170
8	PlgSystemJSNMobilize->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 0.69 ms 最後的查詢: 13.95 ms 之後查詢記憶體: 0.027 MB 記憶體於查詢: 8.791 MB 前回傳的列: 1

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

  FROM `jos1s_extensions`

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

說明

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

側寫

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

呼叫堆疊

#	Caller	檔案與行號
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
18	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
17	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	與下面行一樣的呼叫
16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
14	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
13	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
12	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
11	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
10	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
9	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/jsnpoweradmin/jsnpoweradmin.php:390
8	plgSystemJsnpoweradmin->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 0.59 ms 最後的查詢: 0.24 ms 之後查詢記憶體: 0.006 MB 記憶體於查詢: 8.784 MB 前

UPDATE `jos1s_extensions`

  SET `params` = '{\"mediaversion\":\"76ae72dc6fc07819f9f47800fd952585\"}'

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

說明

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

側寫

Status	Duration
starting	0.11 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.02 ms
System lock	0.09 ms
updating	0.11 ms
end	0.02 ms
Waiting for query cache lock	0.01 ms
end	0.02 ms
query end	0.04 ms
closing tables	0.02 ms
freeing items	0.08 ms
cleaning up	0.01 ms

呼叫堆疊

#	Caller	檔案與行號
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
13	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
12	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
11	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
10	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
9	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/jsnpoweradmin/jsnpoweradmin.php:390
8	plgSystemJsnpoweradmin->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 0.55 ms 最後的查詢: 3.24 ms 之後查詢記憶體: 0.024 MB 記憶體於查詢: 8.958 MB 前回傳的列: 1

重覆查詢: #13 #98

SELECT *

  FROM jos1s_jsn_mobilize_os

  WHERE os_type = 'other'

說明

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jos1s_jsn_mobilize_os	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	12	10.00	Using where

側寫

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

呼叫堆疊

#	Caller	檔案與行號
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/templates/jsn_mobilize/helpers/mobilize.php:445
10	JSNMobilizeTemplateHelper::getOSSupport()	JROOT/templates/jsn_mobilize/helpers/mobilize.php:85
9	JSNMobilizeTemplateHelper::getConfig()	JROOT/plugins/system/jsnmobilize/jsnmobilize.php:282
8	PlgSystemJSNMobilize->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 0.56 ms 最後的查詢: 0.38 ms 之後查詢記憶體: 0.026 MB 記憶體於查詢: 8.966 MB 前回傳的列: 0

重覆查詢: #14 #99

SELECT *

  FROM jos1s_jsn_mobilize_profiles AS p

  INNER JOIN jos1s_jsn_mobilize_os_support AS s 
  ON s.profile_id = p.profile_id

  WHERE s.os_id = '11' 
  AND p.profile_state = 1 
  AND p.profile_device = "jsn_mobile" 
  LIMIT 1

說明

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	4	25.00	Using where
1	SIMPLE	p	NULL	eq_ref	PRIMARY	PRIMARY	4	yaocorg_joom327.s.profile_id	1	100.00	Using where

側寫

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

呼叫堆疊

#	Caller	檔案與行號
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
11	JDatabaseDriver->loadObject()	JROOT/templates/jsn_mobilize/helpers/mobilize.php:512
10	JSNMobilizeTemplateHelper::getOSSupport()	JROOT/templates/jsn_mobilize/helpers/mobilize.php:85
9	JSNMobilizeTemplateHelper::getConfig()	JROOT/plugins/system/jsnmobilize/jsnmobilize.php:282
8	PlgSystemJSNMobilize->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 0.47 ms 最後的查詢: 0.08 ms 之後查詢記憶體: 0.024 MB 記憶體於查詢: 8.971 MB 前回傳的列: 0

重覆查詢: #15 #100

SELECT *

  FROM jos1s_jsn_mobilize_design

  WHERE profile_id = ''

說明

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jos1s_jsn_mobilize_design	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	22	10.00	Using where

側寫

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

呼叫堆疊

#	Caller	檔案與行號
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/templates/jsn_mobilize/helpers/mobilize.php:519
10	JSNMobilizeTemplateHelper::getOSSupport()	JROOT/templates/jsn_mobilize/helpers/mobilize.php:85
9	JSNMobilizeTemplateHelper::getConfig()	JROOT/plugins/system/jsnmobilize/jsnmobilize.php:282
8	PlgSystemJSNMobilize->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 3.93 ms 最後的查詢: 0.44 ms 之後查詢記憶體: 0.029 MB 記憶體於查詢: 8.976 MB 前回傳的列: 4

SELECT id, home, template, s.params

  FROM jos1s_template_styles as s

  LEFT JOIN jos1s_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	e	NULL	ref	element_clientid,element_folder_clientid,extension	extension	82	const	7	1.00	Using index condition; Using where
1	SIMPLE	s	NULL	ref	idx_template,idx_client_id,idx_client_id_home	idx_template	202	yaocorg_joom327.e.element	1	71.43	Using index condition; Using where

側寫

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

呼叫堆疊

#	Caller	檔案與行號
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
11	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/loader.php:33
10	jsn_template_framework_class_loader()	與下面行一樣的呼叫
9	spl_autoload_call()	JROOT/plugins/system/jsntplframework/jsntplframework.php:187
8	PlgSystemJSNTPLFramework->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 0.54 ms 最後的查詢: 0.88 ms 之後查詢記憶體: 0.024 MB 記憶體於查詢: 9.042 MB 前回傳的列: 1

SELECT manifest_cache

  FROM jos1s_extensions

  WHERE element LIKE 'jsn_metro_pro'

說明

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jos1s_extensions	NULL	range	element_clientid,element_folder_clientid	element_clientid	402	NULL	12	100.00	Using index condition

側寫

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

呼叫堆疊

#	Caller	檔案與行號
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/helper.php:122
12	JSNTplHelper::getManifestCache()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/helper.php:217
11	JSNTplHelper::getTemplateVersion()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/loader.php:35
10	jsn_template_framework_class_loader()	與下面行一樣的呼叫
9	spl_autoload_call()	JROOT/plugins/system/jsntplframework/jsntplframework.php:187
8	PlgSystemJSNTPLFramework->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 0.57 ms 最後的查詢: 5.04 ms 之後查詢記憶體: 0.023 MB 記憶體於查詢: 9.376 MB 前回傳的列: 1

SELECT COUNT(*)

  FROM jos1s_extensions

  WHERE type = 'component' 
  AND element = 'com_sh404sef'

說明

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

側寫

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

呼叫堆疊

#	Caller	檔案與行號
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
11	JDatabaseDriver->loadResult()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:1183
10	JSNTplUtils->checkSH404SEF()	JROOT/plugins/system/jsntplframework/includes/core/jsntplframework.php:36
9	JSNTPLFramework::initial()	JROOT/plugins/system/jsntplframework/jsntplframework.php:191
8	PlgSystemJSNTPLFramework->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 1.60 ms 最後的查詢: 0.35 ms 之後查詢記憶體: 0.025 MB 記憶體於查詢: 9.458 MB 前回傳的列: 1

SELECT *

  FROM jos1s_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	jos1s_languages	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Using where; 使用filesort

側寫

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

呼叫堆疊

#	Caller	檔案與行號
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
6	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
5	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/libraries/src/Application/SiteApplication.php:330
4	Joomla\CMS\Application\SiteApplication->getParams()	JROOT/libraries/src/Application/SiteApplication.php:138
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 5.08 ms 最後的查詢: 7.31 ms 之後查詢記憶體: 0.031 MB 記憶體於查詢: 10.046 MB 前回傳的列: 40

SELECT `id`,`name`,`rules`,`parent_id`

  FROM `jos1s_assets`

  WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_easyslider','com_fields','com_finder','com_imageshow','com_installer','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_mobilize','com_modules','com_newsfeeds','com_pagebuilder','com_plugins','com_postinstall','com_poweradmin','com_privacy','com_redirect','com_search','com_tags','com_templates','com_uniform','com_users','com_wrapper')

說明

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

側寫

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

呼叫堆疊

#	Caller	檔案與行號
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
18	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
17	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
16	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
15	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
14	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/category.php:139
13	ContentModelCategory->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457
12	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/libraries/src/MVC/View/CategoryView.php:116
11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 1.70 ms 最後的查詢: 0.31 ms 之後查詢記憶體: 0.050 MB 記憶體於查詢: 10.097 MB 前回傳的列: 201

SELECT `id`,`name`,`rules`,`parent_id`

  FROM `jos1s_assets`

  WHERE `name` LIKE 'com_content.%' OR `name` = 'com_content' OR `parent_id` = 0

說明

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jos1s_assets	NULL	ALL	idx_asset_name,idx_parent_id	NO INDEX KEY COULD BE USED	NULL	NULL	371	21.78	Using where

側寫

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

呼叫堆疊

#	Caller	檔案與行號
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:359
18	Joomla\CMS\Access\Access::preloadPermissions()	JROOT/libraries/src/Access/Access.php:226
17	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:540
16	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
15	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
14	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/category.php:139
13	ContentModelCategory->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457
12	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/libraries/src/MVC/View/CategoryView.php:116
11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 6.77 ms 最後的查詢: 2.11 ms 之後查詢記憶體: 0.037 MB 記憶體於查詢: 10.406 MB 前回傳的列: 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,(
SELECT COUNT(i.`id`)

  FROM `jos1s_content` AS `i`

  WHERE i.`catid` = c.id 
  AND i.state = 1) AS numitems

  FROM `jos1s_categories` AS `s`

  INNER JOIN `jos1s_categories` AS `c` 
  ON (s.lft <= c.lft 
  AND c.lft < s.rgt) OR (c.lft < s.lft 
  AND s.rgt < c.rgt)

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.published = 1 
  AND s.id = 87

  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	使用filesort
1	PRIMARY	c	NULL	range	cat_idx,idx_left_right	cat_idx	203	NULL	12	89.02	Using index condition; Using where
2	DEPENDENT SUBQUERY	i	NULL	ref	idx_state,idx_catid	idx_catid	4	yaocorg_joom327.c.id	4	23.44	Using index condition; Using where

側寫

Status	Duration
starting	0.29 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	1.69 ms
init	0.11 ms
System lock	0.02 ms
optimizing	0.03 ms
statistics	1.50 ms
preparing	0.05 ms
Sorting result	0.01 ms
optimizing	0.01 ms
statistics	0.62 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.04 ms
Creating sort index	0.52 ms
executing	0.01 ms
Sending data	0.29 ms
executing	0.01 ms
Sending data	1.28 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.03 ms
freeing items	0.09 ms
cleaning up	0.01 ms

呼叫堆疊

#	Caller	檔案與行號
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
15	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
14	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/models/category.php:355
13	ContentModelCategory->getCategory()	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplviewlegacy.php:398
12	JViewLegacy->get()	JROOT/libraries/src/MVC/View/CategoryView.php:122
11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 5.78 ms 最後的查詢: 2.24 ms 之後查詢記憶體: 0.081 MB 記憶體於查詢: 10.572 MB 前回傳的列: 6

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 c.published = 2 
  AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
  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, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
  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

  FROM jos1s_content AS a

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

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

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

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

  WHERE a.access IN (1,1,5) 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND a.state = 1 
  AND (a.catid = 87 OR a.catid IN (
SELECT sub.id

  FROM jos1s_categories as sub

  INNER JOIN jos1s_categories as this 
  ON sub.lft > this.lft 
  AND sub.rgt < this.rgt

  WHERE this.id = 87)) 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2022-05-20 17:37:27') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2022-05-20 17:37:27')

  ORDER BY    
  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	a	NULL	ref	idx_access,idx_state,idx_catid	idx_state	1	const	30	16.00	Using index condition; Using where; 使用filesort
1	PRIMARY	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	yaocorg_joom327.a.created_by	1	100.00	Using where
1	PRIMARY	uam	NULL	eq_ref	PRIMARY	PRIMARY	4	yaocorg_joom327.a.modified_by	1	100.00	Using where
1	PRIMARY	c	NULL	eq_ref	PRIMARY,idx_access	PRIMARY	4	yaocorg_joom327.a.catid	1	10.00	Using where
1	PRIMARY	parent	NULL	eq_ref	PRIMARY	PRIMARY	4	yaocorg_joom327.c.parent_id	1	100.00	Using where
2	SUBQUERY	this	NULL	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	NULL
2	SUBQUERY	sub	NULL	range	PRIMARY,idx_left_right	idx_left_right	4	NULL	9	33.33	Using where; Using index

側寫

Status	Duration
starting	0.35 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.01 ms
checking permissions	0.01 ms
Opening tables	1.47 ms
init	0.15 ms
System lock	0.02 ms
optimizing	0.03 ms
statistics	0.72 ms
preparing	0.06 ms
Sorting result	0.02 ms
optimizing	0.02 ms
statistics	0.14 ms
preparing	0.04 ms
executing	0.01 ms
Sending data	0.04 ms
Creating sort index	0.35 ms
executing	0.01 ms
Sending data	2.10 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.03 ms
freeing items	0.02 ms
removing tmp table	0.01 ms
freeing items	0.07 ms
cleaning up	0.01 ms

呼叫堆疊

#	Caller	檔案與行號
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
16	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
15	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_content/models/articles.php:576
14	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
13	ContentModelCategory->getItems()	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplviewlegacy.php:398
12	JViewLegacy->get()	JROOT/libraries/src/MVC/View/CategoryView.php:144
11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 2.49 ms 最後的查詢: 1.79 ms 之後查詢記憶體: 0.036 MB 記憶體於查詢: 10.821 MB 前回傳的列: 0

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

  FROM `jos1s_contentitem_tag_map` AS m 

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

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

說明

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	1	100.00	Using where
1	SIMPLE	t	NULL	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	yaocorg_joom327.m.tag_id	1	100.00	Using where

側寫

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

呼叫堆疊

#	Caller	檔案與行號
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
15	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/models/articles.php:706
14	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
13	ContentModelCategory->getItems()	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplviewlegacy.php:398
12	JViewLegacy->get()	JROOT/libraries/src/MVC/View/CategoryView.php:144
11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 0.56 ms 最後的查詢: 0.17 ms 之後查詢記憶體: 0.036 MB 記憶體於查詢: 10.843 MB 前回傳的列: 0

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

  FROM `jos1s_contentitem_tag_map` AS m 

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

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

說明

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	1	100.00	Using where
1	SIMPLE	t	NULL	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	yaocorg_joom327.m.tag_id	1	100.00	Using where

側寫

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

呼叫堆疊

#	Caller	檔案與行號
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
15	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/models/articles.php:706
14	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
13	ContentModelCategory->getItems()	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplviewlegacy.php:398
12	JViewLegacy->get()	JROOT/libraries/src/MVC/View/CategoryView.php:144
11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 0.52 ms 最後的查詢: 0.17 ms 之後查詢記憶體: 0.036 MB 記憶體於查詢: 10.864 MB 前回傳的列: 0

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

  FROM `jos1s_contentitem_tag_map` AS m 

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

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

說明

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	1	100.00	Using where
1	SIMPLE	t	NULL	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	yaocorg_joom327.m.tag_id	1	100.00	Using where

側寫

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

呼叫堆疊

#	Caller	檔案與行號
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
15	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/models/articles.php:706
14	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
13	ContentModelCategory->getItems()	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplviewlegacy.php:398
12	JViewLegacy->get()	JROOT/libraries/src/MVC/View/CategoryView.php:144
11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 0.52 ms 最後的查詢: 0.16 ms 之後查詢記憶體: 0.038 MB 記憶體於查詢: 10.892 MB 前回傳的列: 0

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

  FROM `jos1s_contentitem_tag_map` AS m 

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

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

說明

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	1	100.00	Using where
1	SIMPLE	t	NULL	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	yaocorg_joom327.m.tag_id	1	100.00	Using where

側寫

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

呼叫堆疊

#	Caller	檔案與行號
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
15	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/models/articles.php:706
14	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
13	ContentModelCategory->getItems()	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplviewlegacy.php:398
12	JViewLegacy->get()	JROOT/libraries/src/MVC/View/CategoryView.php:144
11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 0.58 ms 最後的查詢: 0.18 ms 之後查詢記憶體: 0.036 MB 記憶體於查詢: 10.914 MB 前回傳的列: 0

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

  FROM `jos1s_contentitem_tag_map` AS m 

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

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

說明

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	1	100.00	Using where
1	SIMPLE	t	NULL	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	yaocorg_joom327.m.tag_id	1	100.00	Using where

側寫

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

呼叫堆疊

#	Caller	檔案與行號
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
15	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/models/articles.php:706
14	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
13	ContentModelCategory->getItems()	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplviewlegacy.php:398
12	JViewLegacy->get()	JROOT/libraries/src/MVC/View/CategoryView.php:144
11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 0.48 ms 最後的查詢: 0.18 ms 之後查詢記憶體: 0.036 MB 記憶體於查詢: 10.935 MB 前回傳的列: 0

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

  FROM `jos1s_contentitem_tag_map` AS m 

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

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

說明

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	1	100.00	Using where
1	SIMPLE	t	NULL	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	yaocorg_joom327.m.tag_id	1	100.00	Using where

側寫

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

呼叫堆疊

#	Caller	檔案與行號
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
15	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/models/articles.php:706
14	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
13	ContentModelCategory->getItems()	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplviewlegacy.php:398
12	JViewLegacy->get()	JROOT/libraries/src/MVC/View/CategoryView.php:144
11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 1.19 ms 最後的查詢: 1.08 ms 之後查詢記憶體: 0.026 MB 記憶體於查詢: 11.027 MB 前回傳的列: 1

SELECT COUNT(*)

  FROM jos1s_content AS a

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

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

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

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

  WHERE a.access IN (1,1,5) 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND a.state = 1 
  AND (a.catid = 87 OR a.catid IN (
SELECT sub.id

  FROM jos1s_categories as sub

  INNER JOIN jos1s_categories as this 
  ON sub.lft > this.lft 
  AND sub.rgt < this.rgt

  WHERE this.id = 87)) 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2022-05-20 17:37:27') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2022-05-20 17:37:27')

說明

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	a	NULL	ref	idx_access,idx_state,idx_catid	idx_state	1	const	30	16.00	Using where
1	PRIMARY	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	yaocorg_joom327.a.created_by	1	100.00	Using where; Using index
1	PRIMARY	uam	NULL	eq_ref	PRIMARY	PRIMARY	4	yaocorg_joom327.a.modified_by	1	100.00	Using where; Using index
1	PRIMARY	c	NULL	eq_ref	PRIMARY,idx_access	PRIMARY	4	yaocorg_joom327.a.catid	1	10.00	Using where
1	PRIMARY	parent	NULL	eq_ref	PRIMARY	PRIMARY	4	yaocorg_joom327.c.parent_id	1	100.00	Using where; Using index
2	SUBQUERY	this	NULL	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	NULL
2	SUBQUERY	sub	NULL	range	PRIMARY,idx_left_right	idx_left_right	4	NULL	9	33.33	Using where; Using index

側寫

Status	Duration
starting	0.18 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.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.07 ms
System lock	0.02 ms
optimizing	0.03 ms
statistics	0.16 ms
preparing	0.05 ms
optimizing	0.02 ms
statistics	0.13 ms
preparing	0.04 ms
executing	0.01 ms
Sending data	0.06 ms
executing	0.01 ms
Sending data	0.16 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
removing tmp table	0.01 ms
freeing items	0.05 ms
cleaning up	0.01 ms

呼叫堆疊

#	Caller	檔案與行號
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
17	JDatabaseDriver->loadResult()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:354
16	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount()	JROOT/libraries/src/MVC/Model/ListModel.php:289
15	Joomla\CMS\MVC\Model\ListModel->getTotal()	JROOT/libraries/src/MVC/Model/ListModel.php:239
14	Joomla\CMS\MVC\Model\ListModel->getPagination()	JROOT/components/com_content/models/category.php:265
13	ContentModelCategory->getItems()	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplviewlegacy.php:398
12	JViewLegacy->get()	JROOT/libraries/src/MVC/View/CategoryView.php:144
11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 0.50 ms 最後的查詢: 0.20 ms 之後查詢記憶體: 0.035 MB 記憶體於查詢: 11.034 MB 前回傳的列: 0

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

  FROM `jos1s_contentitem_tag_map` AS m 

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

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

說明

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	1	100.00	Using where
1	SIMPLE	t	NULL	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	yaocorg_joom327.m.tag_id	1	100.00	Using where

側寫

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

呼叫堆疊

#	Caller	檔案與行號
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
12	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/libraries/src/MVC/View/CategoryView.php:229
11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 1.22 ms 最後的查詢: 6.64 ms 之後查詢記憶體: 0.038 MB 記憶體於查詢: 11.527 MB 前回傳的列: 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 `jos1s_categories` AS `s`

  INNER JOIN `jos1s_categories` AS `c` 
  ON (s.lft <= c.lft 
  AND c.lft < s.rgt) OR (c.lft < s.lft 
  AND s.rgt < c.rgt)

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND s.id = 87

  ORDER BY c.lft

說明

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	NULL	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	使用filesort
1	SIMPLE	c	NULL	range	cat_idx,idx_access,idx_left_right	cat_idx	207	NULL	14	89.02	Using index condition; Using where

側寫

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

呼叫堆疊

#	Caller	檔案與行號
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
19	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
18	Joomla\CMS\Categories\Categories->get()	JROOT/administrator/components/com_fields/models/fields.php:203
17	FieldsModelFields->getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:140
16	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:194
15	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
14	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
13	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:113
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 4.89 ms 最後的查詢: 0.15 ms 之後查詢記憶體: 0.037 MB 記憶體於查詢: 11.543 MB 前回傳的列: 0

SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note

  FROM jos1s_fields AS a

  LEFT JOIN `jos1s_languages` AS l 
  ON l.lang_code = a.language

  LEFT JOIN jos1s_users AS uc 
  ON uc.id=a.checked_out

  LEFT JOIN jos1s_viewlevels AS ag 
  ON ag.id = a.access

  LEFT JOIN jos1s_users AS ua 
  ON ua.id = a.created_user_id

  LEFT JOIN jos1s_fields_groups AS g 
  ON g.id = a.group_id

  LEFT JOIN `jos1s_fields_categories` AS fc 
  ON fc.field_id = a.id

  WHERE a.context = 'com_content.article' 
  AND (fc.category_id IS NULL OR fc.category_id IN (87,0)) 
  AND a.access IN (1,1,5) 
  AND (a.group_id = 0 OR g.access IN (1,1,5)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

說明

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	100.00	Using index condition; Using where; Using temporary; 使用filesort
1	SIMPLE	l	NULL	eq_ref	idx_langcode	idx_langcode	28	yaocorg_joom327.a.language	1	100.00	Using where
1	SIMPLE	uc	NULL	eq_ref	PRIMARY	PRIMARY	4	yaocorg_joom327.a.checked_out	1	100.00	NULL
1	SIMPLE	ag	NULL	eq_ref	PRIMARY	PRIMARY	4	yaocorg_joom327.a.access	1	100.00	Using where
1	SIMPLE	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	yaocorg_joom327.a.created_user_id	1	100.00	Using where
1	SIMPLE	g	NULL	eq_ref	PRIMARY	PRIMARY	4	yaocorg_joom327.a.group_id	1	100.00	Using where
1	SIMPLE	fc	NULL	ref	PRIMARY	PRIMARY	4	yaocorg_joom327.a.id	1	100.00	Using where; Using index; Distinct

側寫

Status	Duration
starting	0.21 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.01 ms
checking permissions	0.01 ms
Opening tables	2.47 ms
init	0.07 ms
System lock	0.02 ms
optimizing	0.03 ms
statistics	1.28 ms
preparing	0.05 ms
Creating tmp table	0.07 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.24 ms
Creating sort index	0.06 ms
end	0.01 ms
query end	0.01 ms
removing tmp table	0.06 ms
query end	0.01 ms
closing tables	0.05 ms
freeing items	0.09 ms
cleaning up	0.01 ms

呼叫堆疊

#	Caller	檔案與行號
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
17	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
16	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
15	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
14	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
13	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:113
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 1.67 ms 最後的查詢: 4.09 ms 之後查詢記憶體: 0.027 MB 記憶體於查詢: 11.980 MB 前回傳的列: 0

SELECT `name`, `value`

  FROM `jos1s_jsn_imageshow_config`

  WHERE `name` IN ('show_quick_icons', 'enable_update_checking', 'number_of_images_on_loading')

說明

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jos1s_jsn_imageshow_config	NULL	range	name	name	767	NULL	3	100.00	Using where

側寫

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

呼叫堆疊

#	Caller	檔案與行號
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_imageshow/classes/jsn_is_parameter.php:81
16	JSNISParameter->getParameters()	JROOT/administrator/components/com_imageshow/imageshow.defines.php:27
15	require_once JROOT/administrator/components/com_imageshow/imageshow.defines.php	JROOT/administrator/components/com_imageshow/classes/jsn_is_factory.php:16
14	include_once JROOT/administrator/components/com_imageshow/classes/jsn_is_factory.php	JROOT/plugins/content/imageshow/imageshow.php:28
13	plgContentImageShow->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:113
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 0.64 ms 最後的查詢: 3.29 ms 之後查詢記憶體: 0.030 MB 記憶體於查詢: 12.241 MB 前回傳的列: 1

重覆查詢: #43 #44 #45 #46 #47 #49 #52 #91

SELECT *

  FROM jos1s_extensions

  WHERE element='com_imageshow' 
  AND type='component'

說明

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

側寫

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

呼叫堆疊

#	Caller	檔案與行號
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
15	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_imageshow/classes/jsn_is_utils.php:310
14	JSNISUtils->getComponentInfo()	JROOT/plugins/content/imageshow/imageshow.php:45
13	plgContentImageShow->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:113
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 1.85 ms 最後的查詢: 0.40 ms 之後查詢記憶體: 0.026 MB 記憶體於查詢: 12.244 MB 前回傳的列: 1

SELECT MAX(contact.id) AS contactid, contact.alias, contact.catid, contact.webpage, contact.email_to

  FROM `jos1s_contact_details` AS `contact`

  WHERE contact.published = 1 
  AND contact.user_id = 651

說明

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	contact	NULL	ALL	idx_state	NO INDEX KEY COULD BE USED	NULL	NULL	9	11.11	Using where

側寫

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

呼叫堆疊

#	Caller	檔案與行號
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
15	JDatabaseDriver->loadObject()	JROOT/plugins/content/contact/contact.php:125
14	PlgContentContact->getContactData()	JROOT/plugins/content/contact/contact.php:66
13	PlgContentContact->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:113
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 0.59 ms 最後的查詢: 2.87 ms 之後查詢記憶體: 0.030 MB 記憶體於查詢: 12.534 MB 前回傳的列: 1

重覆查詢: #41 #44 #45 #46 #47 #49 #52 #91

SELECT *

  FROM jos1s_extensions

  WHERE element='com_imageshow' 
  AND type='component'

說明

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

側寫

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

呼叫堆疊

#	Caller	檔案與行號
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
15	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_imageshow/classes/jsn_is_utils.php:310
14	JSNISUtils->getComponentInfo()	JROOT/plugins/content/imageshow/imageshow.php:45
13	plgContentImageShow->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:113
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 0.77 ms 最後的查詢: 0.73 ms 之後查詢記憶體: 0.030 MB 記憶體於查詢: 12.542 MB 前回傳的列: 1

重覆查詢: #41 #43 #45 #46 #47 #49 #52 #91

SELECT *

  FROM jos1s_extensions

  WHERE element='com_imageshow' 
  AND type='component'

說明

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

側寫

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

呼叫堆疊

#	Caller	檔案與行號
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
15	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_imageshow/classes/jsn_is_utils.php:310
14	JSNISUtils->getComponentInfo()	JROOT/plugins/content/imageshow/imageshow.php:45
13	plgContentImageShow->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:113
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 0.72 ms 最後的查詢: 0.72 ms 之後查詢記憶體: 0.030 MB 記憶體於查詢: 12.550 MB 前回傳的列: 1

重覆查詢: #41 #43 #44 #46 #47 #49 #52 #91

SELECT *

  FROM jos1s_extensions

  WHERE element='com_imageshow' 
  AND type='component'

說明

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

側寫

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

呼叫堆疊

#	Caller	檔案與行號
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
15	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_imageshow/classes/jsn_is_utils.php:310
14	JSNISUtils->getComponentInfo()	JROOT/plugins/content/imageshow/imageshow.php:45
13	plgContentImageShow->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:113
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 0.58 ms 最後的查詢: 0.74 ms 之後查詢記憶體: 0.030 MB 記憶體於查詢: 12.557 MB 前回傳的列: 1

Joomla! 除錯主控台

連線階段 (Session)

側寫資訊

時間

記憶體

記憶體使用量

資料庫查詢

101 查詢記錄 203.98 ms

38 重覆被找到!

技術

YAOCer登入

Joomla! 除錯主控台

連線階段 (Session)

側寫資訊

時間

記憶體

記憶體使用量

資料庫查詢

101 查詢記錄 203.98 ms

38 重覆被找到!