妞妞

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1778692106,
                "last": 1778692106,
                "now": 1778692106
            },
            "token": "ft74i9OInaRyWs2u8Cgpt1nlIbZVXFt8"
        },
        "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
        },
        "com_zoo": {
            "zootrack": {
                "items": {
                    "current": "3718"
                },
                "categories": {
                    "current": null
                }
            }
        }
    }
}

時間

記憶體

50 查詢記錄 93.12 ms

1. 查詢時間: 2.15 ms 查詢記憶體: 0.007 MB 記憶體於查詢: 0.979 MB 前 回傳的列: 0

   SELECT `data`
   
     FROM `ngzbl_session`
   
     WHERE `session_id` = X'3261373366633232353665366439633837336534306265383033303338373963'

   說明

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

   側寫

   Status	Duration
   starting	0.13 ms
   Executing hook on transaction	0.05 ms
   starting	0.03 ms
   checking permissions	0.02 ms
   Opening tables	1.56 ms
   init	0.03 ms
   System lock	0.02 ms
   optimizing	0.03 ms
   statistics	0.11 ms
   executing	0.03 ms
   end	0.02 ms
   query end	0.01 ms
   waiting for handler commit	0.02 ms
   closing tables	0.02 ms
   freeing items	0.03 ms
   cleaning up	0.02 ms

   呼叫堆疊

   #	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

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

   ---

2. 查詢時間: 0.43 ms 最後的查詢: 0.47 ms 之後 查詢記憶體: 0.004 MB 記憶體於查詢: 0.993 MB 前 回傳的列: 0

   SELECT `session_id`
   
     FROM `ngzbl_session`
   
     WHERE `session_id` = X'3261373366633232353665366439633837336534306265383033303338373963' 
     LIMIT 1

   說明

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

   側寫

   Status	Duration
   starting	0.06 ms
   Executing hook on transaction	0.03 ms
   starting	0.02 ms
   checking permissions	0.02 ms
   Opening tables	0.03 ms
   init	0.02 ms
   System lock	0.02 ms
   optimizing	0.03 ms
   statistics	0.05 ms
   executing	0.02 ms
   end	0.02 ms
   query end	0.02 ms
   waiting for handler commit	0.03 ms
   closing tables	0.02 ms
   freeing items	0.02 ms
   cleaning up	0.02 ms

   呼叫堆疊

   #	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

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

   ---

3. 查詢時間: 0.81 ms 最後的查詢: 0.10 ms 之後 查詢記憶體: 0.004 MB 記憶體於查詢: 0.998 MB 前

   INSERT INTO `ngzbl_session`
   (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES 
   (X'3261373366633232353665366439633837336534306265383033303338373963', 1, 1778692106, 0, '', 0)

   說明

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

   側寫

   Status	Duration
   starting	0.05 ms
   Executing hook on transaction	0.03 ms
   starting	0.03 ms
   checking permissions	0.02 ms
   Opening tables	0.04 ms
   init	0.02 ms
   System lock	0.03 ms
   update	0.47 ms
   end	0.03 ms
   query end	0.02 ms
   waiting for handler commit	0.03 ms
   closing tables	0.02 ms
   freeing items	0.02 ms
   cleaning up	0.02 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檔案中來建立檔案的連結]

   ---

4. 查詢時間: 0.96 ms 最後的查詢: 1.42 ms 之後 查詢記憶體: 0.005 MB 記憶體於查詢: 1.086 MB 前 回傳的列: 5

   SELECT id, rules
   
     FROM `ngzbl_viewlevels`

   說明

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

   側寫

   Status	Duration
   starting	0.06 ms
   Executing hook on transaction	0.02 ms
   starting	0.02 ms
   checking permissions	0.02 ms
   Opening tables	0.51 ms
   init	0.04 ms
   System lock	0.02 ms
   optimizing	0.01 ms
   statistics	0.02 ms
   preparing	0.02 ms
   executing	0.05 ms
   end	0.02 ms
   query end	0.02 ms
   waiting for handler commit	0.03 ms
   closing tables	0.05 ms
   freeing items	0.03 ms
   cleaning up	0.02 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檔案中來建立檔案的連結]

   ---

5. 查詢時間: 1.48 ms 最後的查詢: 0.12 ms 之後 查詢記憶體: 0.005 MB 記憶體於查詢: 1.098 MB 前 回傳的列: 2

   SELECT b.id
   
     FROM ngzbl_usergroups AS a
   
     LEFT JOIN ngzbl_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.06 ms
   Executing hook on transaction	0.02 ms
   starting	0.02 ms
   checking permissions	0.02 ms
   checking permissions	0.02 ms
   Opening tables	0.94 ms
   init	0.03 ms
   System lock	0.03 ms
   optimizing	0.03 ms
   statistics	0.08 ms
   preparing	0.03 ms
   executing	0.03 ms
   end	0.02 ms
   query end	0.02 ms
   waiting for handler commit	0.03 ms
   closing tables	0.02 ms
   freeing items	0.03 ms
   cleaning up	0.02 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檔案中來建立檔案的連結]

   ---

6. 查詢時間: 0.84 ms 最後的查詢: 23.00 ms 之後 查詢記憶體: 0.006 MB 記憶體於查詢: 4.623 MB 前 回傳的列: 1

   SELECT custom_data 
     FROM ngzbl_extensions 
     WHERE element='yooessentials' 
     AND folder='system'

   說明

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

   側寫

   Status	Duration
   starting	0.14 ms
   Executing hook on transaction	0.03 ms
   starting	0.02 ms
   checking permissions	0.02 ms
   Opening tables	0.17 ms
   init	0.02 ms
   System lock	0.02 ms
   optimizing	0.02 ms
   statistics	0.09 ms
   preparing	0.03 ms
   executing	0.12 ms
   end	0.02 ms
   query end	0.02 ms
   waiting for handler commit	0.02 ms
   closing tables	0.02 ms
   freeing items	0.03 ms
   cleaning up	0.02 ms

   呼叫堆疊

   #	Caller	檔案與行號
   12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
   11	JDatabaseDriver->loadAssoc()	JROOT/templates/yootheme/vendor/yootheme/platform-joomla/src/Database.php:48
   10	YOOtheme\Joomla\Database->fetchAssoc()	JROOT/templates/yootheme/vendor/yootheme/database/src/Database/AbstractDatabase.php:106
   9	YOOtheme\Database\AbstractDatabase->fetchObject()	JROOT/plugins/system/yooessentials/yooessentials.php:44
   8	plgSystemYooessentials->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檔案中來建立檔案的連結]

   ---

7. 查詢時間: 0.81 ms 最後的查詢: 12.17 ms 之後 查詢記憶體: 0.007 MB 記憶體於查詢: 5.526 MB 前 回傳的列: 1

   SELECT id 
     FROM ngzbl_zoo_item 
     WHERE alias = '妞妞-4' 
     LIMIT 1

   說明

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	ngzbl_zoo_item	NULL	const	ALIAS_INDEX	ALIAS_INDEX	767	const	1	100.00	Using index

   側寫

   Status	Duration
   starting	0.07 ms
   Executing hook on transaction	0.02 ms
   starting	0.02 ms
   checking permissions	0.02 ms
   Opening tables	0.23 ms
   init	0.02 ms
   System lock	0.02 ms
   optimizing	0.02 ms
   statistics	0.14 ms
   preparing	0.03 ms
   executing	0.03 ms
   end	0.03 ms
   query end	0.02 ms
   waiting for handler commit	0.03 ms
   closing tables	0.03 ms
   freeing items	0.03 ms
   cleaning up	0.03 ms

   呼叫堆疊

   #	Caller	檔案與行號
   16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
   15	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:89
   14	DatabaseHelper->queryResult()	JROOT/administrator/components/com_zoo/helpers/alias.php:121
   13	AppAlias->translateAliasToID()	JROOT/plugins/system/zooseo/zooseo.php:430
   12	plgSystemZooSeo->sefParseRoute()	JROOT/administrator/components/com_zoo/framework/classes/event.php:279
   11	AppEventDispatcher->notify()	JROOT/components/com_zoo/router.php:382
   10	ZooParseRoute()	JROOT/components/com_zoo/router.php:35
   9	ZooRouter->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
   8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
   7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
   6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
   5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
   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檔案中來建立檔案的連結]

   ---

8. 查詢時間: 0.45 ms 最後的查詢: 0.17 ms 之後 查詢記憶體: 0.007 MB 記憶體於查詢: 5.537 MB 前 回傳的列: 0

   SELECT id 
     FROM ngzbl_zoo_category 
     WHERE alias = '妞妞-4' 
     LIMIT 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.05 ms
   Executing hook on transaction	0.02 ms
   starting	0.02 ms
   checking permissions	0.02 ms
   Opening tables	0.12 ms
   init	0.02 ms
   System lock	0.02 ms
   optimizing	0.02 ms
   statistics	0.04 ms
   executing	0.02 ms
   end	0.01 ms
   query end	0.01 ms
   waiting for handler commit	0.02 ms
   closing tables	0.02 ms
   freeing items	0.03 ms
   cleaning up	0.02 ms

   呼叫堆疊

   #	Caller	檔案與行號
   16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
   15	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:89
   14	DatabaseHelper->queryResult()	JROOT/administrator/components/com_zoo/helpers/alias.php:121
   13	AppAlias->translateAliasToID()	JROOT/plugins/system/zooseo/zooseo.php:431
   12	plgSystemZooSeo->sefParseRoute()	JROOT/administrator/components/com_zoo/framework/classes/event.php:279
   11	AppEventDispatcher->notify()	JROOT/components/com_zoo/router.php:382
   10	ZooParseRoute()	JROOT/components/com_zoo/router.php:35
   9	ZooRouter->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
   8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
   7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
   6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
   5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
   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檔案中來建立檔案的連結]

   ---

9. 查詢時間: 0.41 ms 最後的查詢: 0.30 ms 之後 查詢記憶體: 0.006 MB 記憶體於查詢: 5.545 MB 前 回傳的列: 1
   重覆查詢: #45  #46

   SELECT MAX(`id`) 
     FROM `ngzbl_myshortlist_customblock_items`

   說明

   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 min/max row

   側寫

   Status	Duration
   starting	0.05 ms
   Executing hook on transaction	0.02 ms
   starting	0.02 ms
   checking permissions	0.02 ms
   Opening tables	0.11 ms
   init	0.02 ms
   System lock	0.02 ms
   optimizing	0.03 ms
   executing	0.02 ms
   end	0.01 ms
   query end	0.01 ms
   waiting for handler commit	0.02 ms
   closing tables	0.02 ms
   freeing items	0.02 ms
   cleaning up	0.01 ms

   呼叫堆疊

   #	Caller	檔案與行號
   12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
   11	JDatabaseDriver->loadResult()	JROOT/plugins/system/myshortlist_button/helper.php:44
   10	MyShortlistPluginHelper->loadLastID()	JROOT/plugins/system/myshortlist_button/helper.php:31
   9	MyShortlistPluginHelper->__construct()	JROOT/plugins/system/myshortlist_button/myshortlist_button.php:71
   8	plgSystemMyShortlist_Button->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檔案中來建立檔案的連結]

   ---

10. 查詢時間: 0.50 ms 最後的查詢: 1.61 ms 之後 查詢記憶體: 0.012 MB 記憶體於查詢: 5.678 MB 前 回傳的列: 1

    SELECT custom_data 
      FROM ngzbl_extensions 
      WHERE element = 'yooessentials' 
      AND folder = 'system' 
      LIMIT 1

    說明

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

    側寫

    Status	Duration
    starting	0.06 ms
    Executing hook on transaction	0.02 ms
    starting	0.02 ms
    checking permissions	0.02 ms
    Opening tables	0.03 ms
    init	0.02 ms
    System lock	0.02 ms
    optimizing	0.02 ms
    statistics	0.08 ms
    preparing	0.03 ms
    executing	0.06 ms
    end	0.02 ms
    query end	0.01 ms
    waiting for handler commit	0.02 ms
    closing tables	0.02 ms
    freeing items	0.02 ms
    cleaning up	0.03 ms

    呼叫堆疊

    #	Caller	檔案與行號
    29	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
    28	JDatabaseDriver->loadAssoc()	JROOT/templates/yootheme/vendor/yootheme/platform-joomla/src/Database.php:48
    27	YOOtheme\Joomla\Database->fetchAssoc()	JROOT/plugins/system/yooessentials/modules/core-joomla/src/ConfigRepository.php:53
    26	ZOOlanders\YOOessentials\Joomla\ConfigRepository->load()	JROOT/plugins/system/yooessentials/modules/core/src/Config.php:24
    25	ZOOlanders\YOOessentials\Config->__construct()	與下面行一樣的呼叫
    24	ReflectionClass->newInstanceArgs()	JROOT/templates/yootheme/vendor/yootheme/container/src/Container/Service.php:183
    23	YOOtheme\Container\Service->resolveClass()	JROOT/templates/yootheme/vendor/yootheme/container/src/Container/Service.php:156
    22	YOOtheme\Container\Service->resolveInstance()	JROOT/templates/yootheme/vendor/yootheme/container/src/Container.php:322
    21	YOOtheme\Container->resolve()	JROOT/templates/yootheme/vendor/yootheme/container/src/Container.php:91
    20	YOOtheme\Container->get()	JROOT/templates/yootheme/vendor/yootheme/container/src/Container.php:406
    19	YOOtheme\Container->resolveDependencies()	JROOT/templates/yootheme/vendor/yootheme/container/src/Container.php:355
    18	YOOtheme\Container->resolveArguments()	JROOT/templates/yootheme/vendor/yootheme/container/src/Container.php:265
    17	YOOtheme\Container->call()	JROOT/templates/yootheme/vendor/yootheme/application/src/Application/EventLoader.php:71
    16	YOOtheme\Application\EventLoader::YOOtheme\Application\{closure}()	JROOT/templates/yootheme/vendor/yootheme/utils/src/EventDispatcher.php:115
    15	YOOtheme\EventDispatcher->handleDefault()	JROOT/templates/yootheme/vendor/yootheme/utils/src/EventDispatcher.php:45
    14	YOOtheme\EventDispatcher->dispatch()	JROOT/templates/yootheme/vendor/yootheme/utils/src/Event.php:47
    13	YOOtheme\Event::emit()	JROOT/templates/yootheme/vendor/yootheme/theme-joomla/src/ThemeLoader.php:45
    12	YOOtheme\Theme\Joomla\ThemeLoader::initTheme()	JROOT/templates/yootheme/vendor/yootheme/container/src/Container.php:268
    11	YOOtheme\Container->call()	JROOT/templates/yootheme/vendor/yootheme/application/src/Application/EventLoader.php:71
    10	YOOtheme\Application\EventLoader::YOOtheme\Application\{closure}()	JROOT/templates/yootheme/vendor/yootheme/utils/src/EventDispatcher.php:115
    9	YOOtheme\EventDispatcher->handleDefault()	JROOT/templates/yootheme/vendor/yootheme/utils/src/EventDispatcher.php:45
    8	YOOtheme\EventDispatcher->dispatch()	JROOT/templates/yootheme/vendor/yootheme/platform-joomla/src/Dispatcher.php:44
    7	YOOtheme\Joomla\Dispatcher->YOOtheme\Joomla\{closure}()	JROOT/libraries/joomla/event/dispatcher.php:165
    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檔案中來建立檔案的連結]

    ---

11. 查詢時間: 0.76 ms 最後的查詢: 4.17 ms 之後 查詢記憶體: 0.006 MB 記憶體於查詢: 5.829 MB 前

    UPDATE `ngzbl_extensions`
    
      SET `params` = '{\"mediaversion\":\"0e986f2e9d83dfc0e95ecf51114e5839\"}'
    
      WHERE `type` = 'library' 
      AND `element` = 'joomla'

    說明

    EXPLAIN 無法被使用於查詢: UPDATE `ngzbl_extensions` SET `params` = '{\"mediaversion\":\"0e986f2e9d83dfc0e95ecf51114e5839\"}' WHERE `type` = 'library' AND `element` = 'joomla'

    側寫

    Status	Duration
    starting	0.08 ms
    Executing hook on transaction	0.02 ms
    starting	0.03 ms
    checking permissions	0.03 ms
    Opening tables	0.04 ms
    init	0.04 ms
    System lock	0.10 ms
    updating	0.27 ms
    end	0.02 ms
    query end	0.02 ms
    waiting for handler commit	0.03 ms
    closing tables	0.02 ms
    freeing items	0.03 ms
    cleaning up	0.02 ms

    呼叫堆疊

    #	Caller	檔案與行號
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
    14	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
    13	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
    12	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
    11	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
    10	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/zooseo/zooseo.php:545
    9	plgSystemZooSeo->addOpenGraphTags()	JROOT/plugins/system/zooseo/zooseo.php:96
    8	plgSystemZooSeo->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檔案中來建立檔案的連結]

    ---

12. 查詢時間: 2.34 ms 最後的查詢: 6.28 ms 之後 查詢記憶體: 0.009 MB 記憶體於查詢: 6.477 MB 前 回傳的列: 42

    SELECT `id`,`name`,`rules`,`parent_id`
    
      FROM `ngzbl_assets`
    
      WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_akeeba','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_dpcalendar','com_fields','com_finder','com_installer','com_jce','com_jch_optimize','com_jlsitemap','com_joomlaupdate','com_languages','com_localise','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_myshortlist','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_tags','com_templates','com_users','com_wrapper','com_zoo')

    說明

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	ngzbl_assets	NULL	range	idx_asset_name	idx_asset_name	202	NULL	43	100.00	Using index condition

    側寫

    Status	Duration
    starting	0.05 ms
    Executing hook on transaction	0.02 ms
    starting	0.03 ms
    checking permissions	0.02 ms
    Opening tables	0.05 ms
    init	0.02 ms
    System lock	0.02 ms
    optimizing	0.02 ms
    statistics	0.07 ms
    preparing	0.03 ms
    executing	0.04 ms
    end	0.02 ms
    query end	0.03 ms
    waiting for handler commit	0.03 ms
    closing tables	0.03 ms
    freeing items	0.03 ms
    cleaning up	0.02 ms

    呼叫堆疊

    #	Caller	檔案與行號
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
    19	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
    18	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
    17	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
    16	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
    15	Joomla\CMS\User\User->authorise()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:225
    14	UserAppHelper->isJoomlaSuperAdmin()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:57
    13	UserAppHelper->get()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:271
    12	UserAppHelper->canAccess()	JROOT/media/zoo/elements/element/element.php:498
    11	Element->canAccess()	JROOT/plugins/system/zooseo/renderer/zooseo.php:55
    10	ZooseoRenderer->renderPosition()	JROOT/plugins/system/zooseo/zooseo.php:586
    9	plgSystemZooSeo->addOpenGraphTags()	JROOT/plugins/system/zooseo/zooseo.php:96
    8	plgSystemZooSeo->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檔案中來建立檔案的連結]

    ---

13. 查詢時間: 0.80 ms 最後的查詢: 4.50 ms 之後 查詢記憶體: 0.009 MB 記憶體於查詢: 6.750 MB 前 回傳的列: 1

    SELECT b.id 
      FROM ngzbl_zoo_category_item AS a JOIN ngzbl_zoo_category AS b 
      ON a.category_id = b.id 
      WHERE a.item_id=3718 
      AND b.published = 1 UNION SELECT 0 
      FROM ngzbl_zoo_category_item AS a 
      WHERE a.item_id=3718 
      AND a.category_id = 0

    說明

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	PRIMARY	a	NULL	ref	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	ITEMID_INDEX	4	const	1	100.00	Using index
    1	PRIMARY	b	NULL	eq_ref	PRIMARY,PUBLISHED_INDEX	PRIMARY	4	cawiaorg_site.a.category_id	1	100.00	Using where
    2	UNION	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table
    3	UNION RESULT	<union1,2>	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	Using temporary

    側寫

    Status	Duration
    starting	0.05 ms
    Executing hook on transaction	0.02 ms
    starting	0.03 ms
    checking permissions	0.02 ms
    Opening tables	1.05 ms
    init	0.03 ms
    System lock	0.02 ms
    optimizing	0.03 ms
    statistics	0.04 ms
    preparing	0.02 ms
    executing	0.02 ms
    end	0.01 ms
    query end	0.01 ms
    waiting for handler commit	0.02 ms
    closing tables	0.02 ms
    freeing items	0.03 ms
    cleaning up	0.02 ms

    呼叫堆疊

    #	Caller	檔案與行號
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    19	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:159
    18	DatabaseHelper->queryResultArray()	JROOT/administrator/components/com_zoo/helpers/category.php:63
    17	CategoryHelper->getItemsRelatedCategoryIds()	JROOT/administrator/components/com_zoo/classes/item.php:567
    16	Item->getRelatedCategoryIds()	JROOT/administrator/components/com_zoo/helpers/route.php:315
    15	RouteHelper->item()	JROOT/media/zoo/elements/itemname/itemname.php:73
    14	ElementItemName->render()	JROOT/components/com_zoo/renderer/element/default.php:19
    13	include JROOT/components/com_zoo/renderer/element/default.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:157
    12	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:65
    11	ItemRenderer->render()	JROOT/plugins/system/zooseo/renderer/zooseo.php:120
    10	ZooseoRenderer->renderPosition()	JROOT/plugins/system/zooseo/zooseo.php:586
    9	plgSystemZooSeo->addOpenGraphTags()	JROOT/plugins/system/zooseo/zooseo.php:96
    8	plgSystemZooSeo->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檔案中來建立檔案的連結]

    ---

14. 查詢時間: 0.40 ms 最後的查詢: 4.37 ms 之後 查詢記憶體: 0.010 MB 記憶體於查詢: 6.805 MB 前 回傳的列: 0
    重覆查詢: #22  #23  #31  #32

    SELECT *
    
      FROM ngzbl_usergroups
    
      WHERE id = 0

    說明

    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.13 ms
    Executing hook on transaction	0.03 ms
    starting	0.03 ms
    checking permissions	0.02 ms
    Opening tables	1.15 ms
    init	0.03 ms
    System lock	0.02 ms
    optimizing	0.02 ms
    statistics	0.14 ms
    preparing	0.03 ms
    executing	0.55 ms
    end	0.03 ms
    query end	0.03 ms
    waiting for handler commit	0.02 ms
    closing tables	0.04 ms
    freeing items	0.03 ms
    cleaning up	0.02 ms

    呼叫堆疊

    #	Caller	檔案與行號
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    21	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/UserGroupsHelper.php:233
    20	Joomla\CMS\Helper\UserGroupsHelper->load()	JROOT/libraries/src/Helper/UserGroupsHelper.php:137
    19	Joomla\CMS\Helper\UserGroupsHelper->get()	JROOT/plugins/system/zlframework/zlframework/elements/filespro/filespro.php:493
    18	ElementFilesPro->replaceVars()	JROOT/plugins/system/zlframework/zlframework/elements/filespro/filespro.php:296
    17	ElementFilesPro->getDefaultSource()	JROOT/plugins/system/zlframework/zlframework/elements/filespro/filespro.php:272
    16	ElementFilesPro->getValidResources()	JROOT/plugins/system/zlframework/zlframework/elements/filespro/filespro.php:222
    15	ElementFilesPro->_hasValue()	JROOT/plugins/system/zlframework/zlframework/elements/repeatablepro/repeatablepro.php:221
    14	ElementRepeatablePro->getRenderedValues()	JROOT/plugins/system/zlframework/zlframework/elements/filespro/filespro.php:252
    13	ElementFilesPro->getRenderedValues()	JROOT/media/zoolanders/elements/imagepro/imagepro.php:84
    12	ElementImagePro->getRenderedValues()	JROOT/plugins/system/zlframework/zlframework/elements/repeatablepro/repeatablepro.php:85
    11	ElementRepeatablePro->hasValue()	JROOT/plugins/system/zooseo/renderer/zooseo.php:67
    10	ZooseoRenderer->renderPosition()	JROOT/plugins/system/zooseo/zooseo.php:586
    9	plgSystemZooSeo->addOpenGraphTags()	JROOT/plugins/system/zooseo/zooseo.php:96
    8	plgSystemZooSeo->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檔案中來建立檔案的連結]

    ---

15. 查詢時間: 1.67 ms 最後的查詢: 0.05 ms 之後 查詢記憶體: 0.010 MB 記憶體於查詢: 6.814 MB 前 回傳的列: 1

    SELECT id 
      FROM ngzbl_users 
      WHERE id = 281

    說明

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

    側寫

    Status	Duration
    starting	0.06 ms
    Executing hook on transaction	0.02 ms
    starting	0.02 ms
    checking permissions	0.02 ms
    Opening tables	0.04 ms
    init	0.02 ms
    System lock	0.03 ms
    optimizing	0.03 ms
    statistics	0.06 ms
    preparing	0.02 ms
    executing	0.03 ms
    end	0.02 ms
    query end	0.03 ms
    waiting for handler commit	0.02 ms
    closing tables	0.02 ms
    freeing items	0.03 ms
    cleaning up	0.02 ms

    呼叫堆疊

    #	Caller	檔案與行號
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    21	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:89
    20	DatabaseHelper->queryResult()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:47
    19	UserAppHelper->get()	JROOT/plugins/system/zlframework/zlframework/elements/filespro/filespro.php:496
    18	ElementFilesPro->replaceVars()	JROOT/plugins/system/zlframework/zlframework/elements/filespro/filespro.php:296
    17	ElementFilesPro->getDefaultSource()	JROOT/plugins/system/zlframework/zlframework/elements/filespro/filespro.php:272
    16	ElementFilesPro->getValidResources()	JROOT/plugins/system/zlframework/zlframework/elements/filespro/filespro.php:222
    15	ElementFilesPro->_hasValue()	JROOT/plugins/system/zlframework/zlframework/elements/repeatablepro/repeatablepro.php:221
    14	ElementRepeatablePro->getRenderedValues()	JROOT/plugins/system/zlframework/zlframework/elements/filespro/filespro.php:252
    13	ElementFilesPro->getRenderedValues()	JROOT/media/zoolanders/elements/imagepro/imagepro.php:84
    12	ElementImagePro->getRenderedValues()	JROOT/plugins/system/zlframework/zlframework/elements/repeatablepro/repeatablepro.php:85
    11	ElementRepeatablePro->hasValue()	JROOT/plugins/system/zooseo/renderer/zooseo.php:67
    10	ZooseoRenderer->renderPosition()	JROOT/plugins/system/zooseo/zooseo.php:586
    9	plgSystemZooSeo->addOpenGraphTags()	JROOT/plugins/system/zooseo/zooseo.php:96
    8	plgSystemZooSeo->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檔案中來建立檔案的連結]

    ---

16. 查詢時間: 2.17 ms 最後的查詢: 0.41 ms 之後 查詢記憶體: 0.013 MB 記憶體於查詢: 6.832 MB 前 回傳的列: 17

    SHOW FULL COLUMNS 
      FROM `ngzbl_users`

    說明

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

    側寫

    Status	Duration
    starting	0.06 ms
    Executing hook on transaction	0.03 ms
    starting	0.02 ms
    checking permissions	0.02 ms
    Opening tables	0.04 ms
    init	0.02 ms
    System lock	0.02 ms
    optimizing	0.02 ms
    statistics	0.08 ms
    preparing	0.03 ms
    executing	0.12 ms
    end	0.02 ms
    query end	0.02 ms
    waiting for handler commit	0.02 ms
    closing tables	0.02 ms
    freeing items	0.03 ms
    cleaning up	0.02 ms

    呼叫堆疊

    #	Caller	檔案與行號
    32	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    31	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
    30	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
    29	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
    28	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/User.php:41
    27	Joomla\CMS\Table\User->__construct()	JROOT/libraries/src/Table/Table.php:328
    26	Joomla\CMS\Table\Table::getInstance()	JROOT/libraries/src/User/User.php:603
    25	Joomla\CMS\User\User::getTable()	JROOT/libraries/src/User/User.php:877
    24	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
    23	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
    22	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
    21	Joomla\CMS\Factory::getUser()	JROOT/administrator/components/com_zoo/framework/classes/helper.php:69
    20	AppHelper->_call()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:54
    19	UserAppHelper->get()	JROOT/plugins/system/zlframework/zlframework/elements/filespro/filespro.php:496
    18	ElementFilesPro->replaceVars()	JROOT/plugins/system/zlframework/zlframework/elements/filespro/filespro.php:296
    17	ElementFilesPro->getDefaultSource()	JROOT/plugins/system/zlframework/zlframework/elements/filespro/filespro.php:272
    16	ElementFilesPro->getValidResources()	JROOT/plugins/system/zlframework/zlframework/elements/filespro/filespro.php:222
    15	ElementFilesPro->_hasValue()	JROOT/plugins/system/zlframework/zlframework/elements/repeatablepro/repeatablepro.php:221
    14	ElementRepeatablePro->getRenderedValues()	JROOT/plugins/system/zlframework/zlframework/elements/filespro/filespro.php:252
    13	ElementFilesPro->getRenderedValues()	JROOT/media/zoolanders/elements/imagepro/imagepro.php:84
    12	ElementImagePro->getRenderedValues()	JROOT/plugins/system/zlframework/zlframework/elements/repeatablepro/repeatablepro.php:85
    11	ElementRepeatablePro->hasValue()	JROOT/plugins/system/zooseo/renderer/zooseo.php:67
    10	ZooseoRenderer->renderPosition()	JROOT/plugins/system/zooseo/zooseo.php:586
    9	plgSystemZooSeo->addOpenGraphTags()	JROOT/plugins/system/zooseo/zooseo.php:96
    8	plgSystemZooSeo->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檔案中來建立檔案的連結]

    ---

17. 查詢時間: 0.36 ms 最後的查詢: 0.24 ms 之後 查詢記憶體: 0.012 MB 記憶體於查詢: 6.875 MB 前 回傳的列: 1

    SELECT *
    
      FROM `ngzbl_users`
    
      WHERE `id` = 281

    說明

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

    側寫

    Status	Duration
    starting	0.07 ms
    Executing hook on transaction	0.01 ms
    starting	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.17 ms
    init	0.02 ms
    System lock	0.03 ms
    optimizing	0.02 ms
    statistics	0.09 ms
    preparing	0.03 ms
    optimizing	0.02 ms
    statistics	0.04 ms
    optimizing	0.01 ms
    statistics	0.03 ms
    preparing	0.03 ms
    executing	0.03 ms
    end	0.02 ms
    query end	0.01 ms
    waiting for handler commit	0.02 ms
    closing tables	0.02 ms
    freeing items	0.03 ms
    cleaning up	0.01 ms

    呼叫堆疊

    #	Caller	檔案與行號
    27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
    26	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/User.php:87
    25	Joomla\CMS\Table\User->load()	JROOT/libraries/src/User/User.php:880
    24	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
    23	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
    22	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
    21	Joomla\CMS\Factory::getUser()	JROOT/administrator/components/com_zoo/framework/classes/helper.php:69
    20	AppHelper->_call()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:54
    19	UserAppHelper->get()	JROOT/plugins/system/zlframework/zlframework/elements/filespro/filespro.php:496
    18	ElementFilesPro->replaceVars()	JROOT/plugins/system/zlframework/zlframework/elements/filespro/filespro.php:296
    17	ElementFilesPro->getDefaultSource()	JROOT/plugins/system/zlframework/zlframework/elements/filespro/filespro.php:272
    16	ElementFilesPro->getValidResources()	JROOT/plugins/system/zlframework/zlframework/elements/filespro/filespro.php:222
    15	ElementFilesPro->_hasValue()	JROOT/plugins/system/zlframework/zlframework/elements/repeatablepro/repeatablepro.php:221
    14	ElementRepeatablePro->getRenderedValues()	JROOT/plugins/system/zlframework/zlframework/elements/filespro/filespro.php:252
    13	ElementFilesPro->getRenderedValues()	JROOT/media/zoolanders/elements/imagepro/imagepro.php:84
    12	ElementImagePro->getRenderedValues()	JROOT/plugins/system/zlframework/zlframework/elements/repeatablepro/repeatablepro.php:85
    11	ElementRepeatablePro->hasValue()	JROOT/plugins/system/zooseo/renderer/zooseo.php:67
    10	ZooseoRenderer->renderPosition()	JROOT/plugins/system/zooseo/zooseo.php:586
    9	plgSystemZooSeo->addOpenGraphTags()	JROOT/plugins/system/zooseo/zooseo.php:96
    8	plgSystemZooSeo->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檔案中來建立檔案的連結]

    ---

18. 查詢時間: 1.28 ms 最後的查詢: 0.28 ms 之後 查詢記憶體: 0.011 MB 記憶體於查詢: 6.891 MB 前 回傳的列: 2

    SELECT `g`.`id`,`g`.`title`
    
      FROM `ngzbl_usergroups` AS g
    
      INNER JOIN `ngzbl_user_usergroup_map` AS m 
      ON m.group_id = g.id
    
      WHERE `m`.`user_id` = 281

    說明

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	m	NULL	ref	PRIMARY	PRIMARY	4	const	2	100.00	Using index
    1	SIMPLE	g	NULL	eq_ref	PRIMARY	PRIMARY	4	cawiaorg_site.m.group_id	1	100.00	NULL

    側寫

    Status	Duration
    starting	0.07 ms
    Executing hook on transaction	0.03 ms
    starting	0.02 ms
    checking permissions	0.02 ms
    Opening tables	0.03 ms
    init	0.02 ms
    System lock	0.02 ms
    optimizing	0.02 ms
    statistics	0.04 ms
    executing	0.02 ms
    end	0.01 ms
    query end	0.01 ms
    waiting for handler commit	0.02 ms
    closing tables	0.02 ms
    freeing items	0.02 ms
    cleaning up	0.01 ms

    呼叫堆疊

    #	Caller	檔案與行號
    27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
    26	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Table/User.php:112
    25	Joomla\CMS\Table\User->load()	JROOT/libraries/src/User/User.php:880
    24	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
    23	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
    22	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
    21	Joomla\CMS\Factory::getUser()	JROOT/administrator/components/com_zoo/framework/classes/helper.php:69
    20	AppHelper->_call()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:54
    19	UserAppHelper->get()	JROOT/plugins/system/zlframework/zlframework/elements/filespro/filespro.php:496
    18	ElementFilesPro->replaceVars()	JROOT/plugins/system/zlframework/zlframework/elements/filespro/filespro.php:296
    17	ElementFilesPro->getDefaultSource()	JROOT/plugins/system/zlframework/zlframework/elements/filespro/filespro.php:272
    16	ElementFilesPro->getValidResources()	JROOT/plugins/system/zlframework/zlframework/elements/filespro/filespro.php:222
    15	ElementFilesPro->_hasValue()	JROOT/plugins/system/zlframework/zlframework/elements/repeatablepro/repeatablepro.php:221
    14	ElementRepeatablePro->getRenderedValues()	JROOT/plugins/system/zlframework/zlframework/elements/filespro/filespro.php:252
    13	ElementFilesPro->getRenderedValues()	JROOT/media/zoolanders/elements/imagepro/imagepro.php:84
    12	ElementImagePro->getRenderedValues()	JROOT/plugins/system/zlframework/zlframework/elements/repeatablepro/repeatablepro.php:85
    11	ElementRepeatablePro->hasValue()	JROOT/plugins/system/zooseo/renderer/zooseo.php:67
    10	ZooseoRenderer->renderPosition()	JROOT/plugins/system/zooseo/zooseo.php:586
    9	plgSystemZooSeo->addOpenGraphTags()	JROOT/plugins/system/zooseo/zooseo.php:96
    8	plgSystemZooSeo->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檔案中來建立檔案的連結]

    ---

19. 查詢時間: 0.45 ms 最後的查詢: 0.10 ms 之後 查詢記憶體: 0.011 MB 記憶體於查詢: 6.901 MB 前 回傳的列: 4

    SELECT b.id
    
      FROM ngzbl_user_usergroup_map AS map
    
      LEFT JOIN ngzbl_usergroups AS a 
      ON a.id = map.group_id
    
      LEFT JOIN ngzbl_usergroups AS b 
      ON b.lft <= a.lft 
      AND b.rgt >= a.rgt
    
      WHERE map.user_id = 281

    說明

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	map	NULL	ref	PRIMARY	PRIMARY	4	const	2	100.00	Using index
    1	SIMPLE	a	NULL	eq_ref	PRIMARY	PRIMARY	4	cawiaorg_site.map.group_id	1	100.00	NULL
    1	SIMPLE	b	NULL	ALL	idx_usergroup_nested_set_lookup	NO INDEX KEY COULD BE USED	NULL	NULL	9	100.00	Range checked for each record (index map: 0x10)

    側寫

    Status	Duration
    starting	0.03 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.01 ms
    Opening tables	1.17 ms
    init	0.05 ms
    System lock	0.02 ms
    optimizing	0.02 ms
    statistics	0.20 ms
    preparing	0.02 ms
    executing	0.02 ms
    end	0.02 ms
    query end	0.01 ms
    waiting for handler commit	0.02 ms
    closing tables	0.02 ms
    freeing items	0.03 ms
    cleaning up	0.01 ms

    呼叫堆疊

    #	Caller	檔案與行號
    25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    24	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
    23	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/User/User.php:480
    22	Joomla\CMS\User\User->getAuthorisedGroups()	JROOT/libraries/src/User/User.php:386
    21	Joomla\CMS\User\User->authorise()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:225
    20	UserAppHelper->isJoomlaSuperAdmin()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:57
    19	UserAppHelper->get()	JROOT/plugins/system/zlframework/zlframework/elements/filespro/filespro.php:496
    18	ElementFilesPro->replaceVars()	JROOT/plugins/system/zlframework/zlframework/elements/filespro/filespro.php:296
    17	ElementFilesPro->getDefaultSource()	JROOT/plugins/system/zlframework/zlframework/elements/filespro/filespro.php:272
    16	ElementFilesPro->getValidResources()	JROOT/plugins/system/zlframework/zlframework/elements/filespro/filespro.php:222
    15	ElementFilesPro->_hasValue()	JROOT/plugins/system/zlframework/zlframework/elements/repeatablepro/repeatablepro.php:221
    14	ElementRepeatablePro->getRenderedValues()	JROOT/plugins/system/zlframework/zlframework/elements/filespro/filespro.php:252
    13	ElementFilesPro->getRenderedValues()	JROOT/media/zoolanders/elements/imagepro/imagepro.php:84
    12	ElementImagePro->getRenderedValues()	JROOT/plugins/system/zlframework/zlframework/elements/repeatablepro/repeatablepro.php:85
    11	ElementRepeatablePro->hasValue()	JROOT/plugins/system/zooseo/renderer/zooseo.php:67
    10	ZooseoRenderer->renderPosition()	JROOT/plugins/system/zooseo/zooseo.php:586
    9	plgSystemZooSeo->addOpenGraphTags()	JROOT/plugins/system/zooseo/zooseo.php:96
    8	plgSystemZooSeo->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檔案中來建立檔案的連結]

    ---

20. 查詢時間: 0.33 ms 最後的查詢: 0.11 ms 之後 查詢記憶體: 0.010 MB 記憶體於查詢: 6.914 MB 前 回傳的列: 1

    SELECT *
    
      FROM ngzbl_usergroups
    
      WHERE id = 2

    說明

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

    側寫

    Status	Duration
    starting	0.06 ms
    Executing hook on transaction	0.01 ms
    starting	0.05 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.64 ms
    init	0.03 ms
    System lock	0.02 ms
    optimizing	0.03 ms
    statistics	0.10 ms
    preparing	0.03 ms
    Creating tmp table	0.06 ms
    executing	0.23 ms
    checking permissions	0.10 ms
    checking permissions	0.04 ms
    checking permissions	0.03 ms
    checking permissions	0.03 ms
    checking permissions	0.03 ms
    checking permissions	0.03 ms
    checking permissions	0.03 ms
    checking permissions	0.03 ms
    checking permissions	0.03 ms
    checking permissions	0.03 ms
    checking permissions	0.04 ms
    checking permissions	0.04 ms
    checking permissions	0.03 ms
    checking permissions	0.03 ms
    checking permissions	0.03 ms
    checking permissions	0.03 ms
    checking permissions	0.03 ms
    checking permissions	0.02 ms
    checking permissions	0.10 ms
    end	0.01 ms
    query end	0.01 ms
    waiting for handler commit	0.05 ms
    closing tables	0.02 ms
    freeing items	0.05 ms
    cleaning up	0.02 ms

    呼叫堆疊

    #	Caller	檔案與行號
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    21	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/UserGroupsHelper.php:233
    20	Joomla\CMS\Helper\UserGroupsHelper->load()	JROOT/libraries/src/Helper/UserGroupsHelper.php:137
    19	Joomla\CMS\Helper\UserGroupsHelper->get()	JROOT/plugins/system/zlframework/zlframework/elements/filespro/filespro.php:505
    18	ElementFilesPro->replaceVars()	JROOT/plugins/system/zlframework/zlframework/elements/filespro/filespro.php:296
    17	ElementFilesPro->getDefaultSource()	JROOT/plugins/system/zlframework/zlframework/elements/filespro/filespro.php:272
    16	ElementFilesPro->getValidResources()	JROOT/plugins/system/zlframework/zlframework/elements/filespro/filespro.php:222
    15	ElementFilesPro->_hasValue()	JROOT/plugins/system/zlframework/zlframework/elements/repeatablepro/repeatablepro.php:221
    14	ElementRepeatablePro->getRenderedValues()	JROOT/plugins/system/zlframework/zlframework/elements/filespro/filespro.php:252
    13	ElementFilesPro->getRenderedValues()	JROOT/media/zoolanders/elements/imagepro/imagepro.php:84
    12	ElementImagePro->getRenderedValues()	JROOT/plugins/system/zlframework/zlframework/elements/repeatablepro/repeatablepro.php:85
    11	ElementRepeatablePro->hasValue()	JROOT/plugins/system/zooseo/renderer/zooseo.php:67
    10	ZooseoRenderer->renderPosition()	JROOT/plugins/system/zooseo/zooseo.php:586
    9	plgSystemZooSeo->addOpenGraphTags()	JROOT/plugins/system/zooseo/zooseo.php:96
    8	plgSystemZooSeo->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檔案中來建立檔案的連結]

    ---

21. 查詢時間: 0.33 ms 最後的查詢: 0.04 ms 之後 查詢記憶體: 0.010 MB 記憶體於查詢: 6.926 MB 前 回傳的列: 1

    SELECT *
    
      FROM ngzbl_usergroups
    
      WHERE id = 1

    說明

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

    側寫

    Status	Duration
    starting	0.04 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    init	0.01 ms
    System lock	0.02 ms
    optimizing	0.02 ms
    statistics	0.04 ms
    preparing	0.02 ms
    executing	0.02 ms
    end	0.02 ms
    query end	0.01 ms
    waiting for handler commit	0.02 ms
    closing tables	0.02 ms
    freeing items	0.02 ms
    cleaning up	0.01 ms

    呼叫堆疊

    #	Caller	檔案與行號
    24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    23	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/UserGroupsHelper.php:233
    22	Joomla\CMS\Helper\UserGroupsHelper->load()	JROOT/libraries/src/Helper/UserGroupsHelper.php:314
    21	Joomla\CMS\Helper\UserGroupsHelper->populateGroupData()	JROOT/libraries/src/Helper/UserGroupsHelper.php:240
    20	Joomla\CMS\Helper\UserGroupsHelper->load()	JROOT/libraries/src/Helper/UserGroupsHelper.php:137
    19	Joomla\CMS\Helper\UserGroupsHelper->get()	JROOT/plugins/system/zlframework/zlframework/elements/filespro/filespro.php:505
    18	ElementFilesPro->replaceVars()	JROOT/plugins/system/zlframework/zlframework/elements/filespro/filespro.php:296
    17	ElementFilesPro->getDefaultSource()	JROOT/plugins/system/zlframework/zlframework/elements/filespro/filespro.php:272
    16	ElementFilesPro->getValidResources()	JROOT/plugins/system/zlframework/zlframework/elements/filespro/filespro.php:222
    15	ElementFilesPro->_hasValue()	JROOT/plugins/system/zlframework/zlframework/elements/repeatablepro/repeatablepro.php:221
    14	ElementRepeatablePro->getRenderedValues()	JROOT/plugins/system/zlframework/zlframework/elements/filespro/filespro.php:252
    13	ElementFilesPro->getRenderedValues()	JROOT/media/zoolanders/elements/imagepro/imagepro.php:84
    12	ElementImagePro->getRenderedValues()	JROOT/plugins/system/zlframework/zlframework/elements/repeatablepro/repeatablepro.php:85
    11	ElementRepeatablePro->hasValue()	JROOT/plugins/system/zooseo/renderer/zooseo.php:67
    10	ZooseoRenderer->renderPosition()	JROOT/plugins/system/zooseo/zooseo.php:586
    9	plgSystemZooSeo->addOpenGraphTags()	JROOT/plugins/system/zooseo/zooseo.php:96
    8	plgSystemZooSeo->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檔案中來建立檔案的連結]

    ---

22. 查詢時間: 0.33 ms 最後的查詢: 0.70 ms 之後 查詢記憶體: 0.010 MB 記憶體於查詢: 6.940 MB 前 回傳的列: 0
    重覆查詢: #14  #23  #31  #32

    SELECT *
    
      FROM ngzbl_usergroups
    
      WHERE id = 0

    說明

    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.04 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.71 ms
    init	0.04 ms
    System lock	0.02 ms
    optimizing	0.03 ms
    statistics	0.20 ms
    preparing	0.03 ms
    executing	0.04 ms
    end	0.01 ms
    query end	0.03 ms
    waiting for handler commit	0.02 ms
    closing tables	0.02 ms
    freeing items	0.02 ms
    cleaning up	0.01 ms

    呼叫堆疊

    #	Caller	檔案與行號
    23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    22	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/UserGroupsHelper.php:233
    21	Joomla\CMS\Helper\UserGroupsHelper->load()	JROOT/libraries/src/Helper/UserGroupsHelper.php:137
    20	Joomla\CMS\Helper\UserGroupsHelper->get()	JROOT/plugins/system/zlframework/zlframework/elements/filespro/filespro.php:493
    19	ElementFilesPro->replaceVars()	JROOT/plugins/system/zlframework/zlframework/elements/filespro/filespro.php:296
    18	ElementFilesPro->getDefaultSource()	JROOT/plugins/system/zlframework/zlframework/elements/filespro/filespro.php:272
    17	ElementFilesPro->getValidResources()	JROOT/plugins/system/zlframework/zlframework/elements/filespro/filespro.php:258
    16	ElementFilesPro->getFiles()	JROOT/media/zoolanders/elements/imagepro/imagepro.php:133
    15	ElementImagePro->_render()	JROOT/plugins/system/zlframework/zlframework/elements/repeatablepro/repeatablepro.php:221
    14	ElementRepeatablePro->getRenderedValues()	JROOT/plugins/system/zlframework/zlframework/elements/filespro/filespro.php:252
    13	ElementFilesPro->getRenderedValues()	JROOT/media/zoolanders/elements/imagepro/imagepro.php:84
    12	ElementImagePro->getRenderedValues()	JROOT/plugins/system/zlframework/zlframework/elements/repeatablepro/repeatablepro.php:85
    11	ElementRepeatablePro->hasValue()	JROOT/plugins/system/zooseo/renderer/zooseo.php:67
    10	ZooseoRenderer->renderPosition()	JROOT/plugins/system/zooseo/zooseo.php:586
    9	plgSystemZooSeo->addOpenGraphTags()	JROOT/plugins/system/zooseo/zooseo.php:96
    8	plgSystemZooSeo->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檔案中來建立檔案的連結]

    ---

23. 查詢時間: 0.27 ms 最後的查詢: 1.00 ms 之後 查詢記憶體: 0.008 MB 記憶體於查詢: 6.955 MB 前 回傳的列: 0
    重覆查詢: #14  #22  #31  #32

    SELECT *
    
      FROM ngzbl_usergroups
    
      WHERE id = 0

    說明

    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.06 ms
    Executing hook on transaction	0.01 ms
    starting	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.02 ms
    System lock	0.02 ms
    optimizing	0.02 ms
    statistics	0.06 ms
    preparing	0.03 ms
    executing	0.05 ms
    end	0.01 ms
    query end	0.01 ms
    waiting for handler commit	0.02 ms
    closing tables	0.02 ms
    freeing items	0.02 ms
    cleaning up	0.01 ms

    呼叫堆疊

    #	Caller	檔案與行號
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    16	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/UserGroupsHelper.php:233
    15	Joomla\CMS\Helper\UserGroupsHelper->load()	JROOT/libraries/src/Helper/UserGroupsHelper.php:137
    14	Joomla\CMS\Helper\UserGroupsHelper->get()	JROOT/plugins/system/zlframework/zlframework/elements/filespro/filespro.php:493
    13	ElementFilesPro->replaceVars()	JROOT/plugins/system/zlframework/zlframework/elements/filespro/filespro.php:296
    12	ElementFilesPro->getDefaultSource()	JROOT/plugins/system/zlframework/zlframework/elements/filespro/filespro.php:272
    11	ElementFilesPro->getValidResources()	JROOT/plugins/system/zooseo/renderer/zooseo.php:105
    10	ZooseoRenderer->renderPosition()	JROOT/plugins/system/zooseo/zooseo.php:586
    9	plgSystemZooSeo->addOpenGraphTags()	JROOT/plugins/system/zooseo/zooseo.php:96
    8	plgSystemZooSeo->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檔案中來建立檔案的連結]

    ---

24. 查詢時間: 0.48 ms 最後的查詢: 4.03 ms 之後 查詢記憶體: 0.006 MB 記憶體於查詢: 7.019 MB 前

    UPDATE ngzbl_zoo_item 
      SET hits = (hits + 1) 
      WHERE id = 3718

    說明

    EXPLAIN 無法被使用於查詢: UPDATE ngzbl_zoo_item SET hits = (hits + 1) WHERE id = 3718

    側寫

    Status	Duration
    starting	0.03 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    init	0.01 ms
    System lock	0.02 ms
    optimizing	0.02 ms
    statistics	0.03 ms
    preparing	0.02 ms
    executing	0.02 ms
    end	0.02 ms
    query end	0.01 ms
    waiting for handler commit	0.02 ms
    closing tables	0.02 ms
    freeing items	0.03 ms
    cleaning up	0.02 ms

    呼叫堆疊

    #	Caller	檔案與行號
    14	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:66
    13	DatabaseHelper->query()	JROOT/administrator/components/com_zoo/tables/item.php:178
    12	ItemTable->hit()	JROOT/administrator/components/com_zoo/classes/item.php:676
    11	Item->hit()	JROOT/components/com_zoo/controllers/default.php:177
    10	DefaultController->item()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:266
    8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:298
    7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:35
    6	require_once JROOT/components/com_zoo/zoo.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檔案中來建立檔案的連結]

    ---

25. 查詢時間: 1.00 ms 最後的查詢: 0.65 ms 之後 查詢記憶體: 0.016 MB 記憶體於查詢: 7.050 MB 前 回傳的列: 1

    SELECT custom_data 
      FROM ngzbl_extensions 
      WHERE element = 'yootheme' 
      AND folder = 'system' 
      LIMIT 1

    說明

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

    側寫

    Status	Duration
    starting	0.03 ms
    Executing hook on transaction	0.01 ms
    starting	0.03 ms
    checking permissions	0.02 ms
    Opening tables	0.02 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.03 ms
    statistics	0.03 ms
    preparing	0.02 ms
    executing	0.02 ms
    end	0.01 ms
    query end	0.01 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.03 ms
    cleaning up	0.01 ms

    呼叫堆疊

    #	Caller	檔案與行號
    35	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
    34	JDatabaseDriver->loadAssoc()	JROOT/templates/yootheme/vendor/yootheme/platform-joomla/src/Database.php:48
    33	YOOtheme\Joomla\Database->fetchAssoc()	JROOT/templates/yootheme/vendor/yootheme/platform-joomla/src/Storage.php:25
    32	YOOtheme\Joomla\Storage->__construct()	與下面行一樣的呼叫
    31	ReflectionClass->newInstanceArgs()	JROOT/templates/yootheme/vendor/yootheme/container/src/Container/Service.php:183
    30	YOOtheme\Container\Service->resolveClass()	JROOT/templates/yootheme/vendor/yootheme/container/src/Container/Service.php:156
    29	YOOtheme\Container\Service->resolveInstance()	JROOT/templates/yootheme/vendor/yootheme/container/src/Container.php:322
    28	YOOtheme\Container->resolve()	JROOT/templates/yootheme/vendor/yootheme/container/src/Container.php:91
    27	YOOtheme\Container->get()	JROOT/templates/yootheme/vendor/yootheme/container/src/Container.php:406
    26	YOOtheme\Container->resolveDependencies()	JROOT/templates/yootheme/vendor/yootheme/container/src/Container.php:355
    25	YOOtheme\Container->resolveArguments()	JROOT/templates/yootheme/vendor/yootheme/container/src/Container/Service.php:181
    24	YOOtheme\Container\Service->resolveClass()	JROOT/templates/yootheme/vendor/yootheme/container/src/Container/Service.php:156
    23	YOOtheme\Container\Service->resolveInstance()	JROOT/templates/yootheme/vendor/yootheme/container/src/Container.php:322
    22	YOOtheme\Container->resolve()	JROOT/templates/yootheme/vendor/yootheme/container/src/Container.php:91
    21	YOOtheme\Container->get()	JROOT/templates/yootheme/vendor/yootheme/container/src/Container.php:406
    20	YOOtheme\Container->resolveDependencies()	JROOT/templates/yootheme/vendor/yootheme/container/src/Container.php:355
    19	YOOtheme\Container->resolveArguments()	JROOT/templates/yootheme/vendor/yootheme/container/src/Container.php:265
    18	YOOtheme\Container->call()	JROOT/templates/yootheme/vendor/yootheme/application/src/Application/EventLoader.php:71
    17	YOOtheme\Application\EventLoader::YOOtheme\Application\{closure}()	JROOT/templates/yootheme/vendor/yootheme/utils/src/EventDispatcher.php:115
    16	YOOtheme\EventDispatcher->handleDefault()	JROOT/templates/yootheme/vendor/yootheme/utils/src/EventDispatcher.php:45
    15	YOOtheme\EventDispatcher->dispatch()	JROOT/templates/yootheme/vendor/yootheme/platform-joomla/src/Dispatcher.php:44
    14	YOOtheme\Joomla\Dispatcher->YOOtheme\Joomla\{closure}()	JROOT/libraries/joomla/event/dispatcher.php:165
    13	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    12	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/administrator/components/com_zoo/framework/classes/view.php:58
    11	AppView->display()	JROOT/components/com_zoo/controllers/default.php:211
    10	DefaultController->item()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:266
    8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:298
    7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:35
    6	require_once JROOT/components/com_zoo/zoo.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檔案中來建立檔案的連結]

    ---

26. 查詢時間: 0.64 ms 最後的查詢: 36.88 ms 之後 查詢記憶體: 0.013 MB 記憶體於查詢: 10.795 MB 前 回傳的列: 0

    SELECT name 
      FROM ngzbl_zoo_tag 
      WHERE item_id = 3718

    說明

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	ngzbl_zoo_tag	NULL	ref	PRIMARY,NAME_ITEMID_INDEX	PRIMARY	4	const	1	100.00	Using index

    側寫

    Status	Duration
    starting	0.03 ms
    Executing hook on transaction	0.02 ms
    starting	0.03 ms
    checking permissions	0.02 ms
    Opening tables	0.03 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.03 ms
    executing	0.02 ms
    end	0.01 ms
    query end	0.01 ms
    waiting for handler commit	0.02 ms
    closing tables	0.02 ms
    freeing items	0.02 ms
    cleaning up	0.01 ms

    呼叫堆疊

    #	Caller	檔案與行號
    30	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    29	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:159
    28	DatabaseHelper->queryResultArray()	JROOT/administrator/components/com_zoo/tables/tag.php:93
    27	TagTable->getItemTags()	JROOT/administrator/components/com_zoo/classes/item.php:633
    26	Item->getTags()	JROOT/plugins/system/zoopro/src/TemplateListener.php:28
    25	YOOtheme\Builder\Joomla\Zoo\TemplateListener::matchItemTemplate()	JROOT/templates/yootheme/vendor/yootheme/container/src/Container.php:268
    24	YOOtheme\Container->call()	JROOT/templates/yootheme/vendor/yootheme/application/src/Application/EventLoader.php:71
    23	YOOtheme\Application\EventLoader::YOOtheme\Application\{closure}()	JROOT/templates/yootheme/vendor/yootheme/utils/src/EventDispatcher.php:115
    22	YOOtheme\EventDispatcher->handleDefault()	JROOT/templates/yootheme/vendor/yootheme/utils/src/EventDispatcher.php:45
    21	YOOtheme\EventDispatcher->dispatch()	JROOT/templates/yootheme/vendor/yootheme/utils/src/Event.php:47
    20	YOOtheme\Event::emit()	JROOT/templates/yootheme/vendor/yootheme/builder-joomla-source/src/TemplateListener.php:29
    19	YOOtheme\Builder\Joomla\Source\TemplateListener::loadTemplate()	JROOT/templates/yootheme/vendor/yootheme/container/src/Container.php:268
    18	YOOtheme\Container->call()	JROOT/templates/yootheme/vendor/yootheme/application/src/Application/EventLoader.php:71
    17	YOOtheme\Application\EventLoader::YOOtheme\Application\{closure}()	JROOT/templates/yootheme/vendor/yootheme/utils/src/EventDispatcher.php:115
    16	YOOtheme\EventDispatcher->handleDefault()	JROOT/templates/yootheme/vendor/yootheme/utils/src/EventDispatcher.php:45
    15	YOOtheme\EventDispatcher->dispatch()	JROOT/templates/yootheme/vendor/yootheme/platform-joomla/src/Dispatcher.php:44
    14	YOOtheme\Joomla\Dispatcher->YOOtheme\Joomla\{closure}()	JROOT/libraries/joomla/event/dispatcher.php:165
    13	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    12	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/administrator/components/com_zoo/framework/classes/view.php:58
    11	AppView->display()	JROOT/components/com_zoo/controllers/default.php:211
    10	DefaultController->item()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:266
    8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:298
    7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:35
    6	require_once JROOT/components/com_zoo/zoo.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檔案中來建立檔案的連結]

    ---

27. 查詢時間: 1.13 ms 最後的查詢: 0.17 ms 之後 查詢記憶體: 0.016 MB 記憶體於查詢: 10.812 MB 前 回傳的列: 13

    SELECT `id`,`name`,`rules`,`parent_id`
    
      FROM `ngzbl_assets`
    
      WHERE `name` LIKE 'com_zoo.%' OR `name` = 'com_zoo' OR `parent_id` = 0

    說明

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

    側寫

    Status	Duration
    starting	0.03 ms
    Executing hook on transaction	0.01 ms
    starting	0.02 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.02 ms
    executing	0.02 ms
    end	0.01 ms
    query end	0.01 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.01 ms

    呼叫堆疊

    #	Caller	檔案與行號
    36	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    35	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:359
    34	Joomla\CMS\Access\Access::preloadPermissions()	JROOT/libraries/src/Access/Access.php:226
    33	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:540
    32	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
    31	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
    30	Joomla\CMS\User\User->authorise()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:461
    29	UserAppHelper->authorise()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:363
    28	UserAppHelper->isAdmin()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:293
    27	UserAppHelper->canEdit()	JROOT/administrator/components/com_zoo/classes/item.php:252
    26	Item->canEdit()	JROOT/plugins/system/zoopro/src/TemplateListener.php:43
    25	YOOtheme\Builder\Joomla\Zoo\TemplateListener::matchItemTemplate()	JROOT/templates/yootheme/vendor/yootheme/container/src/Container.php:268
    24	YOOtheme\Container->call()	JROOT/templates/yootheme/vendor/yootheme/application/src/Application/EventLoader.php:71
    23	YOOtheme\Application\EventLoader::YOOtheme\Application\{closure}()	JROOT/templates/yootheme/vendor/yootheme/utils/src/EventDispatcher.php:115
    22	YOOtheme\EventDispatcher->handleDefault()	JROOT/templates/yootheme/vendor/yootheme/utils/src/EventDispatcher.php:45
    21	YOOtheme\EventDispatcher->dispatch()	JROOT/templates/yootheme/vendor/yootheme/utils/src/Event.php:47
    20	YOOtheme\Event::emit()	JROOT/templates/yootheme/vendor/yootheme/builder-joomla-source/src/TemplateListener.php:29
    19	YOOtheme\Builder\Joomla\Source\TemplateListener::loadTemplate()	JROOT/templates/yootheme/vendor/yootheme/container/src/Container.php:268
    18	YOOtheme\Container->call()	JROOT/templates/yootheme/vendor/yootheme/application/src/Application/EventLoader.php:71
    17	YOOtheme\Application\EventLoader::YOOtheme\Application\{closure}()	JROOT/templates/yootheme/vendor/yootheme/utils/src/EventDispatcher.php:115
    16	YOOtheme\EventDispatcher->handleDefault()	JROOT/templates/yootheme/vendor/yootheme/utils/src/EventDispatcher.php:45
    15	YOOtheme\EventDispatcher->dispatch()	JROOT/templates/yootheme/vendor/yootheme/platform-joomla/src/Dispatcher.php:44
    14	YOOtheme\Joomla\Dispatcher->YOOtheme\Joomla\{closure}()	JROOT/libraries/joomla/event/dispatcher.php:165
    13	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    12	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/administrator/components/com_zoo/framework/classes/view.php:58
    11	AppView->display()	JROOT/components/com_zoo/controllers/default.php:211
    10	DefaultController->item()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:266
    8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:298
    7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:35
    6	require_once JROOT/components/com_zoo/zoo.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檔案中來建立檔案的連結]

    ---

28. 查詢時間: 1.81 ms 最後的查詢: 0.28 ms 之後 查詢記憶體: 0.017 MB 記憶體於查詢: 10.860 MB 前 回傳的列: 8

    SHOW FULL COLUMNS 
      FROM `ngzbl_assets`

    說明

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

    側寫

    Status	Duration
    starting	0.06 ms
    Executing hook on transaction	0.02 ms
    starting	0.02 ms
    checking permissions	0.02 ms
    Opening tables	0.04 ms
    init	0.02 ms
    System lock	0.12 ms
    updating	0.08 ms
    end	0.02 ms
    query end	0.01 ms
    waiting for handler commit	0.03 ms
    closing tables	0.02 ms
    freeing items	0.03 ms
    cleaning up	0.01 ms

    呼叫堆疊

    #	Caller	檔案與行號
    39	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    38	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
    37	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
    36	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
    35	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/Asset.php:61
    34	Joomla\CMS\Table\Asset->__construct()	JROOT/libraries/src/Access/Access.php:783
    33	Joomla\CMS\Access\Access::getAssetId()	JROOT/libraries/src/Access/Access.php:544
    32	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
    31	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
    30	Joomla\CMS\User\User->authorise()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:461
    29	UserAppHelper->authorise()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:363
    28	UserAppHelper->isAdmin()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:293
    27	UserAppHelper->canEdit()	JROOT/administrator/components/com_zoo/classes/item.php:252
    26	Item->canEdit()	JROOT/plugins/system/zoopro/src/TemplateListener.php:43
    25	YOOtheme\Builder\Joomla\Zoo\TemplateListener::matchItemTemplate()	JROOT/templates/yootheme/vendor/yootheme/container/src/Container.php:268
    24	YOOtheme\Container->call()	JROOT/templates/yootheme/vendor/yootheme/application/src/Application/EventLoader.php:71
    23	YOOtheme\Application\EventLoader::YOOtheme\Application\{closure}()	JROOT/templates/yootheme/vendor/yootheme/utils/src/EventDispatcher.php:115
    22	YOOtheme\EventDispatcher->handleDefault()	JROOT/templates/yootheme/vendor/yootheme/utils/src/EventDispatcher.php:45
    21	YOOtheme\EventDispatcher->dispatch()	JROOT/templates/yootheme/vendor/yootheme/utils/src/Event.php:47
    20	YOOtheme\Event::emit()	JROOT/templates/yootheme/vendor/yootheme/builder-joomla-source/src/TemplateListener.php:29
    19	YOOtheme\Builder\Joomla\Source\TemplateListener::loadTemplate()	JROOT/templates/yootheme/vendor/yootheme/container/src/Container.php:268
    18	YOOtheme\Container->call()	JROOT/templates/yootheme/vendor/yootheme/application/src/Application/EventLoader.php:71
    17	YOOtheme\Application\EventLoader::YOOtheme\Application\{closure}()	JROOT/templates/yootheme/vendor/yootheme/utils/src/EventDispatcher.php:115
    16	YOOtheme\EventDispatcher->handleDefault()	JROOT/templates/yootheme/vendor/yootheme/utils/src/EventDispatcher.php:45
    15	YOOtheme\EventDispatcher->dispatch()	JROOT/templates/yootheme/vendor/yootheme/platform-joomla/src/Dispatcher.php:44
    14	YOOtheme\Joomla\Dispatcher->YOOtheme\Joomla\{closure}()	JROOT/libraries/joomla/event/dispatcher.php:165
    13	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    12	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/administrator/components/com_zoo/framework/classes/view.php:58
    11	AppView->display()	JROOT/components/com_zoo/controllers/default.php:211
    10	DefaultController->item()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:266
    8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:298
    7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:35
    6	require_once JROOT/components/com_zoo/zoo.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檔案中來建立檔案的連結]

    ---

29. 查詢時間: 0.31 ms 最後的查詢: 0.13 ms 之後 查詢記憶體: 0.016 MB 記憶體於查詢: 10.892 MB 前 回傳的列: 0
    重覆查詢: #30

    SELECT *
    
      FROM ngzbl_assets
    
      WHERE `name` = 'com_zoo.application.1.profile'

    說明

    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.04 ms
    Executing hook on transaction	0.01 ms
    starting	0.02 ms
    checking permissions	0.02 ms
    Opening tables	0.03 ms
    init	0.01 ms
    System lock	0.02 ms
    optimizing	0.02 ms
    statistics	0.07 ms
    preparing	0.02 ms
    executing	0.29 ms
    end	0.03 ms
    query end	0.01 ms
    waiting for handler commit	0.02 ms
    closing tables	0.02 ms
    freeing items	0.02 ms
    cleaning up	0.01 ms

    呼叫堆疊

    #	Caller	檔案與行號
    36	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
    35	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
    34	Joomla\CMS\Table\Table->load()	JROOT/libraries/src/Access/Access.php:784
    33	Joomla\CMS\Access\Access::getAssetId()	JROOT/libraries/src/Access/Access.php:544
    32	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
    31	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
    30	Joomla\CMS\User\User->authorise()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:461
    29	UserAppHelper->authorise()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:363
    28	UserAppHelper->isAdmin()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:293
    27	UserAppHelper->canEdit()	JROOT/administrator/components/com_zoo/classes/item.php:252
    26	Item->canEdit()	JROOT/plugins/system/zoopro/src/TemplateListener.php:43
    25	YOOtheme\Builder\Joomla\Zoo\TemplateListener::matchItemTemplate()	JROOT/templates/yootheme/vendor/yootheme/container/src/Container.php:268
    24	YOOtheme\Container->call()	JROOT/templates/yootheme/vendor/yootheme/application/src/Application/EventLoader.php:71
    23	YOOtheme\Application\EventLoader::YOOtheme\Application\{closure}()	JROOT/templates/yootheme/vendor/yootheme/utils/src/EventDispatcher.php:115
    22	YOOtheme\EventDispatcher->handleDefault()	JROOT/templates/yootheme/vendor/yootheme/utils/src/EventDispatcher.php:45
    21	YOOtheme\EventDispatcher->dispatch()	JROOT/templates/yootheme/vendor/yootheme/utils/src/Event.php:47
    20	YOOtheme\Event::emit()	JROOT/templates/yootheme/vendor/yootheme/builder-joomla-source/src/TemplateListener.php:29
    19	YOOtheme\Builder\Joomla\Source\TemplateListener::loadTemplate()	JROOT/templates/yootheme/vendor/yootheme/container/src/Container.php:268
    18	YOOtheme\Container->call()	JROOT/templates/yootheme/vendor/yootheme/application/src/Application/EventLoader.php:71
    17	YOOtheme\Application\EventLoader::YOOtheme\Application\{closure}()	JROOT/templates/yootheme/vendor/yootheme/utils/src/EventDispatcher.php:115
    16	YOOtheme\EventDispatcher->handleDefault()	JROOT/templates/yootheme/vendor/yootheme/utils/src/EventDispatcher.php:45
    15	YOOtheme\EventDispatcher->dispatch()	JROOT/templates/yootheme/vendor/yootheme/platform-joomla/src/Dispatcher.php:44
    14	YOOtheme\Joomla\Dispatcher->YOOtheme\Joomla\{closure}()	JROOT/libraries/joomla/event/dispatcher.php:165
    13	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    12	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/administrator/components/com_zoo/framework/classes/view.php:58
    11	AppView->display()	JROOT/components/com_zoo/controllers/default.php:211
    10	DefaultController->item()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:266
    8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:298
    7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:35
    6	require_once JROOT/components/com_zoo/zoo.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檔案中來建立檔案的連結]

    ---

30. 查詢時間: 0.29 ms 最後的查詢: 0.17 ms 之後 查詢記憶體: 0.016 MB 記憶體於查詢: 10.910 MB 前 回傳的列: 0
    重覆查詢: #29

    SELECT *
    
      FROM ngzbl_assets
    
      WHERE `name` = 'com_zoo.application.1.profile'

    說明

    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.09 ms
    Executing hook on transaction	0.01 ms
    starting	0.02 ms
    checking permissions	0.01 ms
    Opening tables	0.13 ms
    init	0.02 ms
    System lock	0.02 ms
    optimizing	0.03 ms
    statistics	0.07 ms
    preparing	0.03 ms
    executing	0.03 ms
    end	0.01 ms
    query end	0.01 ms
    waiting for handler commit	0.03 ms
    closing tables	0.03 ms
    freeing items	0.05 ms
    cleaning up	0.02 ms

    呼叫堆疊

    #	Caller	檔案與行號
    35	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
    34	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
    33	Joomla\CMS\Table\Table->load()	JROOT/libraries/src/Access/Access.php:784
    32	Joomla\CMS\Access\Access::getAssetId()	JROOT/libraries/src/Access/Access.php:544
    31	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
    30	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
    29	Joomla\CMS\User\User->authorise()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:461
    28	UserAppHelper->authorise()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:293
    27	UserAppHelper->canEdit()	JROOT/administrator/components/com_zoo/classes/item.php:252
    26	Item->canEdit()	JROOT/plugins/system/zoopro/src/TemplateListener.php:43
    25	YOOtheme\Builder\Joomla\Zoo\TemplateListener::matchItemTemplate()	JROOT/templates/yootheme/vendor/yootheme/container/src/Container.php:268
    24	YOOtheme\Container->call()	JROOT/templates/yootheme/vendor/yootheme/application/src/Application/EventLoader.php:71
    23	YOOtheme\Application\EventLoader::YOOtheme\Application\{closure}()	JROOT/templates/yootheme/vendor/yootheme/utils/src/EventDispatcher.php:115
    22	YOOtheme\EventDispatcher->handleDefault()	JROOT/templates/yootheme/vendor/yootheme/utils/src/EventDispatcher.php:45
    21	YOOtheme\EventDispatcher->dispatch()	JROOT/templates/yootheme/vendor/yootheme/utils/src/Event.php:47
    20	YOOtheme\Event::emit()	JROOT/templates/yootheme/vendor/yootheme/builder-joomla-source/src/TemplateListener.php:29
    19	YOOtheme\Builder\Joomla\Source\TemplateListener::loadTemplate()	JROOT/templates/yootheme/vendor/yootheme/container/src/Container.php:268
    18	YOOtheme\Container->call()	JROOT/templates/yootheme/vendor/yootheme/application/src/Application/EventLoader.php:71
    17	YOOtheme\Application\EventLoader::YOOtheme\Application\{closure}()	JROOT/templates/yootheme/vendor/yootheme/utils/src/EventDispatcher.php:115
    16	YOOtheme\EventDispatcher->handleDefault()	JROOT/templates/yootheme/vendor/yootheme/utils/src/EventDispatcher.php:45
    15	YOOtheme\EventDispatcher->dispatch()	JROOT/templates/yootheme/vendor/yootheme/platform-joomla/src/Dispatcher.php:44
    14	YOOtheme\Joomla\Dispatcher->YOOtheme\Joomla\{closure}()	JROOT/libraries/joomla/event/dispatcher.php:165
    13	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    12	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/administrator/components/com_zoo/framework/classes/view.php:58
    11	AppView->display()	JROOT/components/com_zoo/controllers/default.php:211
    10	DefaultController->item()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:266
    8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:298
    7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:35
    6	require_once JROOT/components/com_zoo/zoo.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檔案中來建立檔案的連結]

    ---

31. 查詢時間: 0.65 ms 最後的查詢: 102.82 ms 之後 查詢記憶體: 0.033 MB 記憶體於查詢: 16.498 MB 前 回傳的列: 0
    重覆查詢: #14  #22  #23  #32

    SELECT *
    
      FROM ngzbl_usergroups
    
      WHERE id = 0

    說明

    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.05 ms
    Executing hook on transaction	0.01 ms
    starting	0.02 ms
    checking permissions	0.02 ms
    Opening tables	0.03 ms
    init	0.02 ms
    System lock	0.02 ms
    optimizing	0.02 ms
    statistics	0.07 ms
    preparing	0.02 ms
    executing	0.74 ms
    end	0.01 ms
    query end	0.01 ms
    waiting for handler commit	0.02 ms
    closing tables	0.02 ms
    freeing items	0.02 ms
    cleaning up	0.02 ms

    呼叫堆疊

    #	Caller	檔案與行號
    67	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    66	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/UserGroupsHelper.php:233
    65	Joomla\CMS\Helper\UserGroupsHelper->load()	JROOT/libraries/src/Helper/UserGroupsHelper.php:137
    64	Joomla\CMS\Helper\UserGroupsHelper->get()	JROOT/plugins/system/zlframework/zlframework/elements/filespro/filespro.php:493
    63	ElementFilesPro->replaceVars()	JROOT/plugins/system/zlframework/zlframework/elements/filespro/filespro.php:296
    62	ElementFilesPro->getDefaultSource()	JROOT/plugins/system/zlframework/zlframework/elements/filespro/filespro.php:272
    61	ElementFilesPro->getValidResources()	JROOT/plugins/system/zlframework/zlframework/elements/filespro/filespro.php:222
    60	ElementFilesPro->_hasValue()	JROOT/plugins/system/zlframework/zlframework/elements/repeatablepro/repeatablepro.php:221
    59	ElementRepeatablePro->getRenderedValues()	JROOT/plugins/system/zlframework/zlframework/elements/filespro/filespro.php:238
    58	ElementFilesPro->getRawRenderedValues()	JROOT/media/zoolanders/elements/imagepro/imagepro.php:432
    57	ElementImagePro->builderSourceValue()	JROOT/plugins/system/zooessentials_source/builder-source/src/ElementHelper.php:28
    56	ZOOlanders\ZOOessentials\BuilderSource\ElementHelper::resolve()	JROOT/templates/yootheme/vendor/yootheme/graphql/src/Utils/Middleware.php:42
    55	YOOtheme\GraphQL\Utils\Middleware->__invoke()	JROOT/templates/yootheme/vendor/yootheme/graphql/src/Directive/SliceDirective.php:45
    54	YOOtheme\GraphQL\Directive\SliceDirective->YOOtheme\GraphQL\Directive\{closure}()	JROOT/templates/yootheme/vendor/yootheme/graphql/src/Utils/Middleware.php:42
    53	YOOtheme\GraphQL\Utils\Middleware->__invoke()	JROOT/templates/yootheme/vendor/yootheme/graphql/src/SchemaBuilder.php:308
    52	YOOtheme\GraphQL\SchemaBuilder->resolveField()	JROOT/templates/yootheme/vendor/yootheme/graphql/lib/Executor/ReferenceExecutor.php:623
    51	YOOtheme\GraphQL\Executor\ReferenceExecutor->resolveFieldValueOrError()	JROOT/templates/yootheme/vendor/yootheme/graphql/lib/Executor/ReferenceExecutor.php:550
    50	YOOtheme\GraphQL\Executor\ReferenceExecutor->resolveField()	JROOT/templates/yootheme/vendor/yootheme/graphql/lib/Executor/ReferenceExecutor.php:1195
    49	YOOtheme\GraphQL\Executor\ReferenceExecutor->executeFields()	JROOT/templates/yootheme/vendor/yootheme/graphql/lib/Executor/ReferenceExecutor.php:1145
    48	YOOtheme\GraphQL\Executor\ReferenceExecutor->collectAndExecuteSubfields()	JROOT/templates/yootheme/vendor/yootheme/graphql/lib/Executor/ReferenceExecutor.php:1106
    47	YOOtheme\GraphQL\Executor\ReferenceExecutor->completeObjectValue()	JROOT/templates/yootheme/vendor/yootheme/graphql/lib/Executor/ReferenceExecutor.php:793
    46	YOOtheme\GraphQL\Executor\ReferenceExecutor->completeValue()	JROOT/templates/yootheme/vendor/yootheme/graphql/lib/Executor/ReferenceExecutor.php:654
    45	YOOtheme\GraphQL\Executor\ReferenceExecutor->completeValueCatchingError()	JROOT/templates/yootheme/vendor/yootheme/graphql/lib/Executor/ReferenceExecutor.php:557
    44	YOOtheme\GraphQL\Executor\ReferenceExecutor->resolveField()	JROOT/templates/yootheme/vendor/yootheme/graphql/lib/Executor/ReferenceExecutor.php:1195
    43	YOOtheme\GraphQL\Executor\ReferenceExecutor->executeFields()	JROOT/templates/yootheme/vendor/yootheme/graphql/lib/Executor/ReferenceExecutor.php:1145
    42	YOOtheme\GraphQL\Executor\ReferenceExecutor->collectAndExecuteSubfields()	JROOT/templates/yootheme/vendor/yootheme/graphql/lib/Executor/ReferenceExecutor.php:1106
    41	YOOtheme\GraphQL\Executor\ReferenceExecutor->completeObjectValue()	JROOT/templates/yootheme/vendor/yootheme/graphql/lib/Executor/ReferenceExecutor.php:793
    40	YOOtheme\GraphQL\Executor\ReferenceExecutor->completeValue()	JROOT/templates/yootheme/vendor/yootheme/graphql/lib/Executor/ReferenceExecutor.php:654
    39	YOOtheme\GraphQL\Executor\ReferenceExecutor->completeValueCatchingError()	JROOT/templates/yootheme/vendor/yootheme/graphql/lib/Executor/ReferenceExecutor.php:557
    38	YOOtheme\GraphQL\Executor\ReferenceExecutor->resolveField()	JROOT/templates/yootheme/vendor/yootheme/graphql/lib/Executor/ReferenceExecutor.php:1195
    37	YOOtheme\GraphQL\Executor\ReferenceExecutor->executeFields()	JROOT/templates/yootheme/vendor/yootheme/graphql/lib/Executor/ReferenceExecutor.php:264
    36	YOOtheme\GraphQL\Executor\ReferenceExecutor->executeOperation()	JROOT/templates/yootheme/vendor/yootheme/graphql/lib/Executor/ReferenceExecutor.php:215
    35	YOOtheme\GraphQL\Executor\ReferenceExecutor->doExecute()	JROOT/templates/yootheme/vendor/yootheme/graphql/lib/Executor/Executor.php:156
    34	YOOtheme\GraphQL\Executor\Executor::promiseToExecute()	JROOT/templates/yootheme/vendor/yootheme/graphql/lib/GraphQL.php:162
    33	YOOtheme\GraphQL\GraphQL::promiseToExecute()	JROOT/templates/yootheme/vendor/yootheme/graphql/lib/GraphQL.php:94
    32	YOOtheme\GraphQL\GraphQL::executeQuery()	JROOT/templates/yootheme/vendor/yootheme/builder-source/src/Source.php:69
    31	YOOtheme\Builder\Source->query()	JROOT/templates/yootheme/vendor/yootheme/builder-source/src/Source/SourceTransform.php:110
    30	YOOtheme\Builder\Source\SourceTransform->querySource()	JROOT/plugins/system/yooessentials/modules/dynamic/src/SourceTransform.php:38
    29	ZOOlanders\YOOessentials\Dynamic\SourceTransform->querySource()	JROOT/templates/yootheme/vendor/yootheme/builder-source/src/Source/SourceTransform.php:60
    28	YOOtheme\Builder\Source\SourceTransform->__invoke()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:248
    27	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:269
    26	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:269
    25	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:269
    24	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:269
    23	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:269
    22	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:94
    21	YOOtheme\Builder->load()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:111
    20	YOOtheme\Builder->render()	JROOT/templates/yootheme/vendor/yootheme/builder-joomla-source/src/TemplateListener.php:60
    19	YOOtheme\Builder\Joomla\Source\TemplateListener::loadTemplate()	JROOT/templates/yootheme/vendor/yootheme/container/src/Container.php:268
    18	YOOtheme\Container->call()	JROOT/templates/yootheme/vendor/yootheme/application/src/Application/EventLoader.php:71
    17	YOOtheme\Application\EventLoader::YOOtheme\Application\{closure}()	JROOT/templates/yootheme/vendor/yootheme/utils/src/EventDispatcher.php:115
    16	YOOtheme\EventDispatcher->handleDefault()	JROOT/templates/yootheme/vendor/yootheme/utils/src/EventDispatcher.php:45
    15	YOOtheme\EventDispatcher->dispatch()	JROOT/templates/yootheme/vendor/yootheme/platform-joomla/src/Dispatcher.php:44
    14	YOOtheme\Joomla\Dispatcher->YOOtheme\Joomla\{closure}()	JROOT/libraries/joomla/event/dispatcher.php:165
    13	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    12	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/administrator/components/com_zoo/framework/classes/view.php:58
    11	AppView->display()	JROOT/components/com_zoo/controllers/default.php:211
    10	DefaultController->item()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:266
    8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:298
    7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:35
    6	require_once JROOT/components/com_zoo/zoo.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檔案中來建立檔案的連結]

    ---

32. 查詢時間: 0.36 ms 最後的查詢: 0.21 ms 之後 查詢記憶體: 0.033 MB 記憶體於查詢: 16.531 MB 前 回傳的列: 0
    重覆查詢: #14  #22  #23  #31

    SELECT *
    
      FROM ngzbl_usergroups
    
      WHERE id = 0

    說明

    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.06 ms
    Executing hook on transaction	0.01 ms
    starting	0.04 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.65 ms
    init	0.03 ms
    System lock	0.02 ms
    optimizing	0.03 ms
    statistics	0.10 ms
    preparing	0.03 ms
    Creating tmp table	0.05 ms
    executing	0.19 ms
    checking permissions	0.08 ms
    checking permissions	0.03 ms
    checking permissions	0.03 ms
    checking permissions	0.04 ms
    checking permissions	0.03 ms
    checking permissions	0.03 ms
    checking permissions	0.03 ms
    checking permissions	0.03 ms
    checking permissions	0.02 ms
    checking permissions	0.06 ms
    end	0.01 ms
    query end	0.02 ms
    waiting for handler commit	0.06 ms
    closing tables	0.03 ms
    freeing items	0.05 ms
    cleaning up	0.02 ms

    呼叫堆疊

    #	Caller	檔案與行號
    68	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    67	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/UserGroupsHelper.php:233
    66	Joomla\CMS\Helper\UserGroupsHelper->load()	JROOT/libraries/src/Helper/UserGroupsHelper.php:137
    65	Joomla\CMS\Helper\UserGroupsHelper->get()	JROOT/plugins/system/zlframework/zlframework/elements/filespro/filespro.php:493
    64	ElementFilesPro->replaceVars()	JROOT/plugins/system/zlframework/zlframework/elements/filespro/filespro.php:296
    63	ElementFilesPro->getDefaultSource()	JROOT/plugins/system/zlframework/zlframework/elements/filespro/filespro.php:272
    62	ElementFilesPro->getValidResources()	JROOT/plugins/system/zlframework/zlframework/elements/filespro/filespro.php:258
    61	ElementFilesPro->getFiles()	JROOT/media/zoolanders/elements/imagepro/imagepro.php:133
    60	ElementImagePro->_render()	JROOT/plugins/system/zlframework/zlframework/elements/repeatablepro/repeatablepro.php:221
    59	ElementRepeatablePro->getRenderedValues()	JROOT/plugins/system/zlframework/zlframework/elements/filespro/filespro.php:238
    58	ElementFilesPro->getRawRenderedValues()	JROOT/media/zoolanders/elements/imagepro/imagepro.php:432
    57	ElementImagePro->builderSourceValue()	JROOT/plugins/system/zooessentials_source/builder-source/src/ElementHelper.php:28
    56	ZOOlanders\ZOOessentials\BuilderSource\ElementHelper::resolve()	JROOT/templates/yootheme/vendor/yootheme/graphql/src/Utils/Middleware.php:42
    55	YOOtheme\GraphQL\Utils\Middleware->__invoke()	JROOT/templates/yootheme/vendor/yootheme/graphql/src/Directive/SliceDirective.php:45
    54	YOOtheme\GraphQL\Directive\SliceDirective->YOOtheme\GraphQL\Directive\{closure}()	JROOT/templates/yootheme/vendor/yootheme/graphql/src/Utils/Middleware.php:42
    53	YOOtheme\GraphQL\Utils\Middleware->__invoke()	JROOT/templates/yootheme/vendor/yootheme/graphql/src/SchemaBuilder.php:308
    52	YOOtheme\GraphQL\SchemaBuilder->resolveField()	JROOT/templates/yootheme/vendor/yootheme/graphql/lib/Executor/ReferenceExecutor.php:623
    51	YOOtheme\GraphQL\Executor\ReferenceExecutor->resolveFieldValueOrError()	JROOT/templates/yootheme/vendor/yootheme/graphql/lib/Executor/ReferenceExecutor.php:550
    50	YOOtheme\GraphQL\Executor\ReferenceExecutor->resolveField()	JROOT/templates/yootheme/vendor/yootheme/graphql/lib/Executor/ReferenceExecutor.php:1195
    49	YOOtheme\GraphQL\Executor\ReferenceExecutor->executeFields()	JROOT/templates/yootheme/vendor/yootheme/graphql/lib/Executor/ReferenceExecutor.php:1145
    48	YOOtheme\GraphQL\Executor\ReferenceExecutor->collectAndExecuteSubfields()	JROOT/templates/yootheme/vendor/yootheme/graphql/lib/Executor/ReferenceExecutor.php:1106
    47	YOOtheme\GraphQL\Executor\ReferenceExecutor->completeObjectValue()	JROOT/templates/yootheme/vendor/yootheme/graphql/lib/Executor/ReferenceExecutor.php:793
    46	YOOtheme\GraphQL\Executor\ReferenceExecutor->completeValue()	JROOT/templates/yootheme/vendor/yootheme/graphql/lib/Executor/ReferenceExecutor.php:654
    45	YOOtheme\GraphQL\Executor\ReferenceExecutor->completeValueCatchingError()	JROOT/templates/yootheme/vendor/yootheme/graphql/lib/Executor/ReferenceExecutor.php:557
    44	YOOtheme\GraphQL\Executor\ReferenceExecutor->resolveField()	JROOT/templates/yootheme/vendor/yootheme/graphql/lib/Executor/ReferenceExecutor.php:1195
    43	YOOtheme\GraphQL\Executor\ReferenceExecutor->executeFields()	JROOT/templates/yootheme/vendor/yootheme/graphql/lib/Executor/ReferenceExecutor.php:1145
    42	YOOtheme\GraphQL\Executor\ReferenceExecutor->collectAndExecuteSubfields()	JROOT/templates/yootheme/vendor/yootheme/graphql/lib/Executor/ReferenceExecutor.php:1106
    41	YOOtheme\GraphQL\Executor\ReferenceExecutor->completeObjectValue()	JROOT/templates/yootheme/vendor/yootheme/graphql/lib/Executor/ReferenceExecutor.php:793
    40	YOOtheme\GraphQL\Executor\ReferenceExecutor->completeValue()	JROOT/templates/yootheme/vendor/yootheme/graphql/lib/Executor/ReferenceExecutor.php:654
    39	YOOtheme\GraphQL\Executor\ReferenceExecutor->completeValueCatchingError()	JROOT/templates/yootheme/vendor/yootheme/graphql/lib/Executor/ReferenceExecutor.php:557
    38	YOOtheme\GraphQL\Executor\ReferenceExecutor->resolveField()	JROOT/templates/yootheme/vendor/yootheme/graphql/lib/Executor/ReferenceExecutor.php:1195
    37	YOOtheme\GraphQL\Executor\ReferenceExecutor->executeFields()	JROOT/templates/yootheme/vendor/yootheme/graphql/lib/Executor/ReferenceExecutor.php:264
    36	YOOtheme\GraphQL\Executor\ReferenceExecutor->executeOperation()	JROOT/templates/yootheme/vendor/yootheme/graphql/lib/Executor/ReferenceExecutor.php:215
    35	YOOtheme\GraphQL\Executor\ReferenceExecutor->doExecute()	JROOT/templates/yootheme/vendor/yootheme/graphql/lib/Executor/Executor.php:156
    34	YOOtheme\GraphQL\Executor\Executor::promiseToExecute()	JROOT/templates/yootheme/vendor/yootheme/graphql/lib/GraphQL.php:162
    33	YOOtheme\GraphQL\GraphQL::promiseToExecute()	JROOT/templates/yootheme/vendor/yootheme/graphql/lib/GraphQL.php:94
    32	YOOtheme\GraphQL\GraphQL::executeQuery()	JROOT/templates/yootheme/vendor/yootheme/builder-source/src/Source.php:69
    31	YOOtheme\Builder\Source->query()	JROOT/templates/yootheme/vendor/yootheme/builder-source/src/Source/SourceTransform.php:110
    30	YOOtheme\Builder\Source\SourceTransform->querySource()	JROOT/plugins/system/yooessentials/modules/dynamic/src/SourceTransform.php:38
    29	ZOOlanders\YOOessentials\Dynamic\SourceTransform->querySource()	JROOT/templates/yootheme/vendor/yootheme/builder-source/src/Source/SourceTransform.php:60
    28	YOOtheme\Builder\Source\SourceTransform->__invoke()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:248
    27	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:269
    26	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:269
    25	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:269
    24	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:269
    23	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:269
    22	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:94
    21	YOOtheme\Builder->load()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:111
    20	YOOtheme\Builder->render()	JROOT/templates/yootheme/vendor/yootheme/builder-joomla-source/src/TemplateListener.php:60
    19	YOOtheme\Builder\Joomla\Source\TemplateListener::loadTemplate()	JROOT/templates/yootheme/vendor/yootheme/container/src/Container.php:268
    18	YOOtheme\Container->call()	JROOT/templates/yootheme/vendor/yootheme/application/src/Application/EventLoader.php:71
    17	YOOtheme\Application\EventLoader::YOOtheme\Application\{closure}()	JROOT/templates/yootheme/vendor/yootheme/utils/src/EventDispatcher.php:115
    16	YOOtheme\EventDispatcher->handleDefault()	JROOT/templates/yootheme/vendor/yootheme/utils/src/EventDispatcher.php:45
    15	YOOtheme\EventDispatcher->dispatch()	JROOT/templates/yootheme/vendor/yootheme/platform-joomla/src/Dispatcher.php:44
    14	YOOtheme\Joomla\Dispatcher->YOOtheme\Joomla\{closure}()	JROOT/libraries/joomla/event/dispatcher.php:165
    13	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    12	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/administrator/components/com_zoo/framework/classes/view.php:58
    11	AppView->display()	JROOT/components/com_zoo/controllers/default.php:211
    10	DefaultController->item()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:266
    8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:298
    7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:35
    6	require_once JROOT/components/com_zoo/zoo.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檔案中來建立檔案的連結]

    ---

33. 查詢時間: 0.59 ms 最後的查詢: 3.62 ms 之後 查詢記憶體: 0.018 MB 記憶體於查詢: 16.617 MB 前 回傳的列: 5

    SELECT a.id AS value, a.title AS text
                    
      FROM ngzbl_viewlevels AS a
                    
      GROUP BY a.id, a.title, a.ordering
                    
      ORDER BY a.ordering ASC

    說明

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

    側寫

    Status	Duration
    starting	0.04 ms
    Executing hook on transaction	0.01 ms
    starting	0.02 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    init	0.01 ms
    System lock	0.02 ms
    optimizing	0.02 ms
    statistics	0.04 ms
    executing	0.02 ms
    end	0.01 ms
    query end	0.01 ms
    waiting for handler commit	0.01 ms
    closing tables	0.02 ms
    freeing items	0.02 ms
    cleaning up	0.01 ms

    呼叫堆疊

    #	Caller	檔案與行號
    38	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
    37	JDatabaseDriver->loadAssocList()	JROOT/templates/yootheme/vendor/yootheme/platform-joomla/src/Database.php:40
    36	YOOtheme\Joomla\Database->fetchAll()	JROOT/templates/yootheme/vendor/yootheme/database/src/Database/AbstractDatabase.php:122
    35	YOOtheme\Database\AbstractDatabase->fetchAllObjects()	JROOT/plugins/system/yooessentials/modules/access-joomla/src/UserAccessRule.php:111
    34	ZOOlanders\YOOessentials\Access\Joomla\UserAccessRule->getUserAccessLevels()	JROOT/plugins/system/yooessentials/modules/access-joomla/src/UserAccessRule.php:90
    33	ZOOlanders\YOOessentials\Access\Joomla\UserAccessRule->fields()	JROOT/plugins/system/yooessentials/modules/access/src/AccessResolver.php:202
    32	ZOOlanders\YOOessentials\Access\AccessResolver->resolveArgsLabels()	JROOT/plugins/system/yooessentials/modules/access/src/AccessResolver.php:115
    31	ZOOlanders\YOOessentials\Access\AccessResolver->ZOOlanders\YOOessentials\Access\{closure}()	與下面行一樣的呼叫
    30	array_map()	JROOT/plugins/system/yooessentials/modules/access/src/AccessResolver.php:137
    29	ZOOlanders\YOOessentials\Access\AccessResolver->resolveConditions()	JROOT/plugins/system/yooessentials/modules/access/src/AccessResolver.php:79
    28	ZOOlanders\YOOessentials\Access\AccessResolver->resolve()	JROOT/plugins/system/yooessentials/modules/access/src/AccessTransform.php:57
    27	ZOOlanders\YOOessentials\Access\AccessTransform->__invoke()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:286
    26	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:269
    25	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:269
    24	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:269
    23	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:269
    22	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:94
    21	YOOtheme\Builder->load()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:111
    20	YOOtheme\Builder->render()	JROOT/templates/yootheme/vendor/yootheme/builder-joomla-source/src/TemplateListener.php:60
    19	YOOtheme\Builder\Joomla\Source\TemplateListener::loadTemplate()	JROOT/templates/yootheme/vendor/yootheme/container/src/Container.php:268
    18	YOOtheme\Container->call()	JROOT/templates/yootheme/vendor/yootheme/application/src/Application/EventLoader.php:71
    17	YOOtheme\Application\EventLoader::YOOtheme\Application\{closure}()	JROOT/templates/yootheme/vendor/yootheme/utils/src/EventDispatcher.php:115
    16	YOOtheme\EventDispatcher->handleDefault()	JROOT/templates/yootheme/vendor/yootheme/utils/src/EventDispatcher.php:45
    15	YOOtheme\EventDispatcher->dispatch()	JROOT/templates/yootheme/vendor/yootheme/platform-joomla/src/Dispatcher.php:44
    14	YOOtheme\Joomla\Dispatcher->YOOtheme\Joomla\{closure}()	JROOT/libraries/joomla/event/dispatcher.php:165
    13	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    12	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/administrator/components/com_zoo/framework/classes/view.php:58
    11	AppView->display()	JROOT/components/com_zoo/controllers/default.php:211
    10	DefaultController->item()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:266
    8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:298
    7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:35
    6	require_once JROOT/components/com_zoo/zoo.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檔案中來建立檔案的連結]

    ---

34. 查詢時間: 2.13 ms 最後的查詢: 8.58 ms 之後 查詢記憶體: 0.016 MB 記憶體於查詢: 16.842 MB 前 回傳的列: 1

    SELECT `language` 
      FROM `ngzbl_modules` 
      WHERE `id` = "106"

    說明

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

    側寫

    Status	Duration
    starting	0.03 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.03 ms
    executing	0.02 ms
    end	0.01 ms
    query end	0.01 ms
    waiting for handler commit	0.02 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.01 ms

    呼叫堆疊

    #	Caller	檔案與行號
    33	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    32	JDatabaseDriver->loadResult()	JROOT/modules/mod_myshortlist/helper.php:78
    31	ModMyShortlistHelper->getLanguageFromModuleID()	JROOT/modules/mod_myshortlist/helper.php:49
    30	ModMyShortlistHelper->initialize()	JROOT/modules/mod_myshortlist/mod_myshortlist.php:17
    29	include JROOT/modules/mod_myshortlist/mod_myshortlist.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    28	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/templates/yootheme/vendor/yootheme/builder-joomla/elements/module/element.php:34
    27	YOOtheme\Configuration\Resolver->YOOtheme\{closure}()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:286
    26	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:269
    25	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:269
    24	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:269
    23	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:269
    22	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:94
    21	YOOtheme\Builder->load()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:111
    20	YOOtheme\Builder->render()	JROOT/templates/yootheme/vendor/yootheme/builder-joomla-source/src/TemplateListener.php:60
    19	YOOtheme\Builder\Joomla\Source\TemplateListener::loadTemplate()	JROOT/templates/yootheme/vendor/yootheme/container/src/Container.php:268
    18	YOOtheme\Container->call()	JROOT/templates/yootheme/vendor/yootheme/application/src/Application/EventLoader.php:71
    17	YOOtheme\Application\EventLoader::YOOtheme\Application\{closure}()	JROOT/templates/yootheme/vendor/yootheme/utils/src/EventDispatcher.php:115
    16	YOOtheme\EventDispatcher->handleDefault()	JROOT/templates/yootheme/vendor/yootheme/utils/src/EventDispatcher.php:45
    15	YOOtheme\EventDispatcher->dispatch()	JROOT/templates/yootheme/vendor/yootheme/platform-joomla/src/Dispatcher.php:44
    14	YOOtheme\Joomla\Dispatcher->YOOtheme\Joomla\{closure}()	JROOT/libraries/joomla/event/dispatcher.php:165
    13	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    12	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/administrator/components/com_zoo/framework/classes/view.php:58
    11	AppView->display()	JROOT/components/com_zoo/controllers/default.php:211
    10	DefaultController->item()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:266
    8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:298
    7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:35
    6	require_once JROOT/components/com_zoo/zoo.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檔案中來建立檔案的連結]

    ---

35. 查詢時間: 0.42 ms 最後的查詢: 1.11 ms 之後 查詢記憶體: 0.016 MB 記憶體於查詢: 16.874 MB 前 回傳的列: 1

    SELECT `language` 
      FROM `ngzbl_modules` 
      WHERE `id` = "108"

    說明

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

    側寫

    Status	Duration
    starting	0.20 ms
    Executing hook on transaction	0.06 ms
    starting	0.03 ms
    checking permissions	0.02 ms
    Opening tables	0.04 ms
    init	0.02 ms
    System lock	0.02 ms
    optimizing	0.02 ms
    statistics	0.05 ms
    executing	0.02 ms
    end	0.02 ms
    query end	0.02 ms
    waiting for handler commit	0.02 ms
    closing tables	0.02 ms
    freeing items	0.03 ms
    cleaning up	0.02 ms

    呼叫堆疊

    #	Caller	檔案與行號
    33	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    32	JDatabaseDriver->loadResult()	JROOT/modules/mod_myshortlist/helper.php:78
    31	ModMyShortlistHelper->getLanguageFromModuleID()	JROOT/modules/mod_myshortlist/helper.php:49
    30	ModMyShortlistHelper->initialize()	JROOT/modules/mod_myshortlist/mod_myshortlist.php:17
    29	include JROOT/modules/mod_myshortlist/mod_myshortlist.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    28	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/templates/yootheme/vendor/yootheme/builder-joomla/elements/module/element.php:34
    27	YOOtheme\Configuration\Resolver->YOOtheme\{closure}()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:286
    26	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:269
    25	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:269
    24	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:269
    23	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:269
    22	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:94
    21	YOOtheme\Builder->load()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:111
    20	YOOtheme\Builder->render()	JROOT/templates/yootheme/vendor/yootheme/builder-joomla-source/src/TemplateListener.php:60
    19	YOOtheme\Builder\Joomla\Source\TemplateListener::loadTemplate()	JROOT/templates/yootheme/vendor/yootheme/container/src/Container.php:268
    18	YOOtheme\Container->call()	JROOT/templates/yootheme/vendor/yootheme/application/src/Application/EventLoader.php:71
    17	YOOtheme\Application\EventLoader::YOOtheme\Application\{closure}()	JROOT/templates/yootheme/vendor/yootheme/utils/src/EventDispatcher.php:115
    16	YOOtheme\EventDispatcher->handleDefault()	JROOT/templates/yootheme/vendor/yootheme/utils/src/EventDispatcher.php:45
    15	YOOtheme\EventDispatcher->dispatch()	JROOT/templates/yootheme/vendor/yootheme/platform-joomla/src/Dispatcher.php:44
    14	YOOtheme\Joomla\Dispatcher->YOOtheme\Joomla\{closure}()	JROOT/libraries/joomla/event/dispatcher.php:165
    13	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    12	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/administrator/components/com_zoo/framework/classes/view.php:58
    11	AppView->display()	JROOT/components/com_zoo/controllers/default.php:211
    10	DefaultController->item()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:266
    8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:298
    7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:35
    6	require_once JROOT/components/com_zoo/zoo.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檔案中來建立檔案的連結]

    ---

36. 查詢時間: 19.56 ms 最後的查詢: 7.52 ms 之後 查詢記憶體: 0.018 MB 記憶體於查詢: 16.916 MB 前 回傳的列: 0

    SELECT ritem_id, params 
      FROM ngzbl_zoo_relateditemsproxref 
      WHERE item_id = 3718 
      AND element_id='c4c04327-7828-49c7-8898-9ba410cf40b0' 
      ORDER BY id ASC

    說明

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	ngzbl_zoo_relateditemsproxref	NULL	index	NULL	PRIMARY	4	NULL	14348	100.00	Using where

    側寫

    Status	Duration
    starting	0.05 ms
    Executing hook on transaction	0.02 ms
    starting	0.02 ms
    checking permissions	0.02 ms
    Opening tables	0.03 ms
    init	0.02 ms
    System lock	0.02 ms
    optimizing	0.02 ms
    statistics	0.04 ms
    executing	0.02 ms
    end	0.02 ms
    query end	0.01 ms
    waiting for handler commit	0.02 ms
    closing tables	0.02 ms
    freeing items	0.02 ms
    cleaning up	0.02 ms

    呼叫堆疊

    #	Caller	檔案與行號
    39	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
    38	JDatabaseDriver->loadAssocList()	JROOT/media/zoo/applications/kingwomwom/templates/uikit3/elements/relateditemspro/relateditemspro.php:273
    37	ElementRelatedItemsPro->getRelatedItems()	JROOT/media/zoo/applications/kingwomwom/templates/uikit3/elements/relateditemspro/relateditemspro.php:142
    36	ElementRelatedItemsPro->getRenderedValues()	JROOT/media/zoo/applications/kingwomwom/templates/uikit3/elements/relateditemspro/relateditemspro.php:105
    35	ElementRelatedItemsPro->hasValue()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:95
    34	ItemRenderer->checkPosition()	JROOT/modules/mod_zooitempro/renderer/item/default.php:18
    33	include JROOT/modules/mod_zooitempro/renderer/item/default.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:157
    32	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:65
    31	ItemRenderer->render()	JROOT/modules/mod_zooitempro/tmpl/current_donor.php:21
    30	include JROOT/modules/mod_zooitempro/tmpl/current_donor.php	JROOT/modules/mod_zooitempro/mod_zooitempro.php:22
    29	include JROOT/modules/mod_zooitempro/mod_zooitempro.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    28	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/templates/yootheme/vendor/yootheme/builder-joomla/elements/module/element.php:34
    27	YOOtheme\Configuration\Resolver->YOOtheme\{closure}()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:286
    26	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:269
    25	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:269
    24	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:269
    23	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:269
    22	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:94
    21	YOOtheme\Builder->load()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:111
    20	YOOtheme\Builder->render()	JROOT/templates/yootheme/vendor/yootheme/builder-joomla-source/src/TemplateListener.php:60
    19	YOOtheme\Builder\Joomla\Source\TemplateListener::loadTemplate()	JROOT/templates/yootheme/vendor/yootheme/container/src/Container.php:268
    18	YOOtheme\Container->call()	JROOT/templates/yootheme/vendor/yootheme/application/src/Application/EventLoader.php:71
    17	YOOtheme\Application\EventLoader::YOOtheme\Application\{closure}()	JROOT/templates/yootheme/vendor/yootheme/utils/src/EventDispatcher.php:115
    16	YOOtheme\EventDispatcher->handleDefault()	JROOT/templates/yootheme/vendor/yootheme/utils/src/EventDispatcher.php:45
    15	YOOtheme\EventDispatcher->dispatch()	JROOT/templates/yootheme/vendor/yootheme/platform-joomla/src/Dispatcher.php:44
    14	YOOtheme\Joomla\Dispatcher->YOOtheme\Joomla\{closure}()	JROOT/libraries/joomla/event/dispatcher.php:165
    13	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    12	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/administrator/components/com_zoo/framework/classes/view.php:58
    11	AppView->display()	JROOT/components/com_zoo/controllers/default.php:211
    10	DefaultController->item()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:266
    8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:298
    7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:35
    6	require_once JROOT/components/com_zoo/zoo.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檔案中來建立檔案的連結]

    ---

37. 查詢時間: 24.88 ms 最後的查詢: 0.80 ms 之後 查詢記憶體: 0.016 MB 記憶體於查詢: 16.886 MB 前 回傳的列: 1

    SELECT ROWNUM 
      FROM (SELECT @rownum:= @rownum+1 ROWNUM, id 
      FROM (SELECT @rownum:=0) r, (SELECT id 
      FROM ngzbl_zoo_item AS a 
      LEFT JOIN ngzbl_zoo_category_item AS b 
      ON a.id = b.item_id 
      WHERE a.application_id = 1 
      AND b.category_id  = 5 
      AND a.access IN (1,5) 
      AND a.state = 1 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-05-13 17:08:26') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-05-13 17:08:26') 
      GROUP BY a.id 
      ORDER BY a.priority DESC, a.created+0<>0, a.created+0 DESC, a.created DESC) t1) t2 
      WHERE id = 3718

    說明

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	PRIMARY	<derived2>	NULL	ref	<auto_key0>	<auto_key0>	4	const	10	100.00	NULL
    2	DERIVED	<derived3>	NULL	system	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	NULL
    2	DERIVED	<derived4>	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1784	100.00	NULL
    4	DERIVED	b	NULL	ref	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	CATEGORYID_INDEX	4	const	1784	100.00	Using where; Using index; Using temporary; 使用filesort
    4	DERIVED	a	NULL	eq_ref	PRIMARY,ALIAS_INDEX,PUBLISH_INDEX,STATE_INDEX,ACCESS_INDEX,CREATED_BY_INDEX,NAME_INDEX,APPLICATIONID_INDEX,TYPE_INDEX,MULTI_INDEX,MULTI_INDEX2,ID_APPLICATION_INDEX,SEARCH_FULLTEXT	PRIMARY	4	cawiaorg_site.b.item_id	1	100.00	Using where
    3	DERIVED	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	No tables used

    側寫

    Status	Duration
    starting	0.15 ms
    Executing hook on transaction	0.03 ms
    starting	0.02 ms
    checking permissions	0.02 ms
    Opening tables	0.04 ms
    init	0.02 ms
    System lock	0.02 ms
    optimizing	0.02 ms
    statistics	0.02 ms
    preparing	0.03 ms
    executing	0.06 ms
    end	0.02 ms
    query end	0.02 ms
    waiting for handler commit	0.02 ms
    closing tables	0.02 ms
    freeing items	0.03 ms
    cleaning up	0.02 ms

    呼叫堆疊

    #	Caller	檔案與行號
    36	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    35	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:89
    34	DatabaseHelper->queryResult()	JROOT/administrator/components/com_zoo/framework/classes/table.php:382
    33	AppTable->_queryResult()	JROOT/administrator/components/com_zoo/tables/item.php:515
    32	ItemTable->getPrevNext()	JROOT/media/zoo/elements/itemprevnext/itemprevnext.php:76
    31	ElementItemPrevNext->_getAdjacentItems()	JROOT/media/zoo/elements/itemprevnext/itemprevnext.php:31
    30	ElementItemPrevNext->hasValue()	JROOT/media/zoo/elements/itemprevnext/itemprevnext.php:46
    29	ElementItemPrevNext->getValue()	JROOT/plugins/system/zoopro/src/TemplateListener.php:35
    28	YOOtheme\Builder\Joomla\Zoo\TemplateListener::YOOtheme\Builder\Joomla\Zoo\{closure}()	JROOT/templates/yootheme/vendor/yootheme/builder-joomla-source/elements/pagination/element.php:31
    27	YOOtheme\Configuration\Resolver->YOOtheme\{closure}()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:286
    26	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:269
    25	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:269
    24	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:269
    23	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:269
    22	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:94
    21	YOOtheme\Builder->load()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:111
    20	YOOtheme\Builder->render()	JROOT/templates/yootheme/vendor/yootheme/builder-joomla-source/src/TemplateListener.php:60
    19	YOOtheme\Builder\Joomla\Source\TemplateListener::loadTemplate()	JROOT/templates/yootheme/vendor/yootheme/container/src/Container.php:268
    18	YOOtheme\Container->call()	JROOT/templates/yootheme/vendor/yootheme/application/src/Application/EventLoader.php:71
    17	YOOtheme\Application\EventLoader::YOOtheme\Application\{closure}()	JROOT/templates/yootheme/vendor/yootheme/utils/src/EventDispatcher.php:115
    16	YOOtheme\EventDispatcher->handleDefault()	JROOT/templates/yootheme/vendor/yootheme/utils/src/EventDispatcher.php:45
    15	YOOtheme\EventDispatcher->dispatch()	JROOT/templates/yootheme/vendor/yootheme/platform-joomla/src/Dispatcher.php:44
    14	YOOtheme\Joomla\Dispatcher->YOOtheme\Joomla\{closure}()	JROOT/libraries/joomla/event/dispatcher.php:165
    13	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    12	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/administrator/components/com_zoo/framework/classes/view.php:58
    11	AppView->display()	JROOT/components/com_zoo/controllers/default.php:211
    10	DefaultController->item()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:266
    8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:298
    7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:35
    6	require_once JROOT/components/com_zoo/zoo.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檔案中來建立檔案的連結]

    ---

38. 查詢時間: 12.29 ms 最後的查詢: 0.18 ms 之後 查詢記憶體: 0.016 MB 記憶體於查詢: 16.902 MB 前 回傳的列: 2

    SELECT ROWNUM, id 
      FROM (SELECT @rownum:= @rownum+1 ROWNUM, id 
      FROM (SELECT @rownum:=0) r, (SELECT id 
      FROM ngzbl_zoo_item AS a 
      LEFT JOIN ngzbl_zoo_category_item AS b 
      ON a.id = b.item_id 
      WHERE a.application_id = 1 
      AND b.category_id  = 5 
      AND a.access IN (1,5) 
      AND a.state = 1 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-05-13 17:08:26') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-05-13 17:08:26') 
      GROUP BY a.id 
      ORDER BY a.priority DESC, a.created+0<>0, a.created+0 DESC, a.created DESC) t1) t2 
      WHERE ROWNUM = 1275 OR ROWNUM = 1277

    說明

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	PRIMARY	<derived2>	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1784	100.00	Using where
    2	DERIVED	<derived3>	NULL	system	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	NULL
    2	DERIVED	<derived4>	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1784	100.00	NULL
    4	DERIVED	b	NULL	ref	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	CATEGORYID_INDEX	4	const	1784	100.00	Using where; Using index; Using temporary; 使用filesort
    4	DERIVED	a	NULL	eq_ref	PRIMARY,ALIAS_INDEX,PUBLISH_INDEX,STATE_INDEX,ACCESS_INDEX,CREATED_BY_INDEX,NAME_INDEX,APPLICATIONID_INDEX,TYPE_INDEX,MULTI_INDEX,MULTI_INDEX2,ID_APPLICATION_INDEX,SEARCH_FULLTEXT	PRIMARY	4	cawiaorg_site.b.item_id	1	100.00	Using where
    3	DERIVED	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	No tables used

    側寫

    Status	Duration
    starting	0.16 ms
    Executing hook on transaction	0.05 ms
    starting	0.03 ms
    checking permissions	0.02 ms
    Opening tables	1.36 ms
    init	0.04 ms
    System lock	0.02 ms
    optimizing	0.03 ms
    statistics	0.21 ms
    preparing	0.03 ms
    executing	0.02 ms
    end	0.02 ms
    query end	0.02 ms
    waiting for handler commit	0.02 ms
    closing tables	0.02 ms
    freeing items	0.03 ms
    cleaning up	0.02 ms

    呼叫堆疊

    #	Caller	檔案與行號
    35	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    34	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:136
    33	DatabaseHelper->queryObjectList()	JROOT/administrator/components/com_zoo/tables/item.php:538
    32	ItemTable->getPrevNext()	JROOT/media/zoo/elements/itemprevnext/itemprevnext.php:76
    31	ElementItemPrevNext->_getAdjacentItems()	JROOT/media/zoo/elements/itemprevnext/itemprevnext.php:31
    30	ElementItemPrevNext->hasValue()	JROOT/media/zoo/elements/itemprevnext/itemprevnext.php:46
    29	ElementItemPrevNext->getValue()	JROOT/plugins/system/zoopro/src/TemplateListener.php:35
    28	YOOtheme\Builder\Joomla\Zoo\TemplateListener::YOOtheme\Builder\Joomla\Zoo\{closure}()	JROOT/templates/yootheme/vendor/yootheme/builder-joomla-source/elements/pagination/element.php:31
    27	YOOtheme\Configuration\Resolver->YOOtheme\{closure}()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:286
    26	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:269
    25	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:269
    24	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:269
    23	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:269
    22	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:94
    21	YOOtheme\Builder->load()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:111
    20	YOOtheme\Builder->render()	JROOT/templates/yootheme/vendor/yootheme/builder-joomla-source/src/TemplateListener.php:60
    19	YOOtheme\Builder\Joomla\Source\TemplateListener::loadTemplate()	JROOT/templates/yootheme/vendor/yootheme/container/src/Container.php:268
    18	YOOtheme\Container->call()	JROOT/templates/yootheme/vendor/yootheme/application/src/Application/EventLoader.php:71
    17	YOOtheme\Application\EventLoader::YOOtheme\Application\{closure}()	JROOT/templates/yootheme/vendor/yootheme/utils/src/EventDispatcher.php:115
    16	YOOtheme\EventDispatcher->handleDefault()	JROOT/templates/yootheme/vendor/yootheme/utils/src/EventDispatcher.php:45
    15	YOOtheme\EventDispatcher->dispatch()	JROOT/templates/yootheme/vendor/yootheme/platform-joomla/src/Dispatcher.php:44
    14	YOOtheme\Joomla\Dispatcher->YOOtheme\Joomla\{closure}()	JROOT/libraries/joomla/event/dispatcher.php:165
    13	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    12	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/administrator/components/com_zoo/framework/classes/view.php:58
    11	AppView->display()	JROOT/components/com_zoo/controllers/default.php:211
    10	DefaultController->item()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:266
    8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:298
    7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:35
    6	require_once JROOT/components/com_zoo/zoo.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檔案中來建立檔案的連結]

    ---

39. 查詢時間: 0.57 ms 最後的查詢: 1.30 ms 之後 查詢記憶體: 0.016 MB 記憶體於查詢: 16.950 MB 前 回傳的列: 1

    SELECT b.id 
      FROM ngzbl_zoo_category_item AS a JOIN ngzbl_zoo_category AS b 
      ON a.category_id = b.id 
      WHERE a.item_id=3717 
      AND b.published = 1 UNION SELECT 0 
      FROM ngzbl_zoo_category_item AS a 
      WHERE a.item_id=3717 
      AND a.category_id = 0

    說明

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	PRIMARY	a	NULL	ref	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	ITEMID_INDEX	4	const	1	100.00	Using index
    1	PRIMARY	b	NULL	eq_ref	PRIMARY,PUBLISHED_INDEX	PRIMARY	4	cawiaorg_site.a.category_id	1	100.00	Using where
    2	UNION	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table
    3	UNION RESULT	<union1,2>	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	Using temporary

    側寫

    Status	Duration
    starting	0.06 ms
    Executing hook on transaction	0.02 ms
    starting	0.02 ms
    checking permissions	0.02 ms
    Opening tables	0.03 ms
    init	0.02 ms
    System lock	0.02 ms
    optimizing	0.02 ms
    statistics	0.05 ms
    preparing	0.02 ms
    executing	0.02 ms
    end	0.01 ms
    query end	0.01 ms
    waiting for handler commit	0.02 ms
    closing tables	0.02 ms
    freeing items	0.03 ms
    cleaning up	0.02 ms

    呼叫堆疊

    #	Caller	檔案與行號
    35	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    34	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:159
    33	DatabaseHelper->queryResultArray()	JROOT/administrator/components/com_zoo/helpers/category.php:63
    32	CategoryHelper->getItemsRelatedCategoryIds()	JROOT/administrator/components/com_zoo/classes/item.php:567
    31	Item->getRelatedCategoryIds()	JROOT/administrator/components/com_zoo/helpers/route.php:315
    30	RouteHelper->item()	JROOT/media/zoo/elements/itemprevnext/itemprevnext.php:56
    29	ElementItemPrevNext->getValue()	JROOT/plugins/system/zoopro/src/TemplateListener.php:35
    28	YOOtheme\Builder\Joomla\Zoo\TemplateListener::YOOtheme\Builder\Joomla\Zoo\{closure}()	JROOT/templates/yootheme/vendor/yootheme/builder-joomla-source/elements/pagination/element.php:31
    27	YOOtheme\Configuration\Resolver->YOOtheme\{closure}()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:286
    26	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:269
    25	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:269
    24	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:269
    23	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:269
    22	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:94
    21	YOOtheme\Builder->load()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:111
    20	YOOtheme\Builder->render()	JROOT/templates/yootheme/vendor/yootheme/builder-joomla-source/src/TemplateListener.php:60
    19	YOOtheme\Builder\Joomla\Source\TemplateListener::loadTemplate()	JROOT/templates/yootheme/vendor/yootheme/container/src/Container.php:268
    18	YOOtheme\Container->call()	JROOT/templates/yootheme/vendor/yootheme/application/src/Application/EventLoader.php:71
    17	YOOtheme\Application\EventLoader::YOOtheme\Application\{closure}()	JROOT/templates/yootheme/vendor/yootheme/utils/src/EventDispatcher.php:115
    16	YOOtheme\EventDispatcher->handleDefault()	JROOT/templates/yootheme/vendor/yootheme/utils/src/EventDispatcher.php:45
    15	YOOtheme\EventDispatcher->dispatch()	JROOT/templates/yootheme/vendor/yootheme/platform-joomla/src/Dispatcher.php:44
    14	YOOtheme\Joomla\Dispatcher->YOOtheme\Joomla\{closure}()	JROOT/libraries/joomla/event/dispatcher.php:165
    13	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    12	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/administrator/components/com_zoo/framework/classes/view.php:58
    11	AppView->display()	JROOT/components/com_zoo/controllers/default.php:211
    10	DefaultController->item()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:266
    8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:298
    7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:35
    6	require_once JROOT/components/com_zoo/zoo.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檔案中來建立檔案的連結]

    ---

40. 查詢時間: 0.61 ms 最後的查詢: 0.67 ms 之後 查詢記憶體: 0.016 MB 記憶體於查詢: 16.968 MB 前 回傳的列: 1

    SELECT b.id 
      FROM ngzbl_zoo_category_item AS a JOIN ngzbl_zoo_category AS b 
      ON a.category_id = b.id 
      WHERE a.item_id=3719 
      AND b.published = 1 UNION SELECT 0 
      FROM ngzbl_zoo_category_item AS a 
      WHERE a.item_id=3719 
      AND a.category_id = 0

    說明

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	PRIMARY	a	NULL	ref	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	ITEMID_INDEX	4	const	1	100.00	Using index
    1	PRIMARY	b	NULL	eq_ref	PRIMARY,PUBLISHED_INDEX	PRIMARY	4	cawiaorg_site.a.category_id	1	100.00	Using where
    2	UNION	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table
    3	UNION RESULT	<union1,2>	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	Using temporary

    側寫

    Status	Duration
    starting	0.10 ms
    Executing hook on transaction	0.02 ms
    starting	0.02 ms
    checking permissions	0.02 ms
    Opening tables	1.07 ms
    init	0.04 ms
    System lock	0.02 ms
    optimizing	0.02 ms
    statistics	0.03 ms
    preparing	0.03 ms
    executing	18.00 ms
    end	0.05 ms
    query end	0.02 ms
    waiting for handler commit	0.02 ms
    closing tables	0.02 ms
    freeing items	0.03 ms
    cleaning up	0.02 ms

    呼叫堆疊

    #	Caller	檔案與行號
    35	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    34	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:159
    33	DatabaseHelper->queryResultArray()	JROOT/administrator/components/com_zoo/helpers/category.php:63
    32	CategoryHelper->getItemsRelatedCategoryIds()	JROOT/administrator/components/com_zoo/classes/item.php:567
    31	Item->getRelatedCategoryIds()	JROOT/administrator/components/com_zoo/helpers/route.php:315
    30	RouteHelper->item()	JROOT/media/zoo/elements/itemprevnext/itemprevnext.php:58
    29	ElementItemPrevNext->getValue()	JROOT/plugins/system/zoopro/src/TemplateListener.php:35
    28	YOOtheme\Builder\Joomla\Zoo\TemplateListener::YOOtheme\Builder\Joomla\Zoo\{closure}()	JROOT/templates/yootheme/vendor/yootheme/builder-joomla-source/elements/pagination/element.php:31
    27	YOOtheme\Configuration\Resolver->YOOtheme\{closure}()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:286
    26	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:269
    25	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:269
    24	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:269
    23	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:269
    22	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:94
    21	YOOtheme\Builder->load()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:111
    20	YOOtheme\Builder->render()	JROOT/templates/yootheme/vendor/yootheme/builder-joomla-source/src/TemplateListener.php:60
    19	YOOtheme\Builder\Joomla\Source\TemplateListener::loadTemplate()	JROOT/templates/yootheme/vendor/yootheme/container/src/Container.php:268
    18	YOOtheme\Container->call()	JROOT/templates/yootheme/vendor/yootheme/application/src/Application/EventLoader.php:71
    17	YOOtheme\Application\EventLoader::YOOtheme\Application\{closure}()	JROOT/templates/yootheme/vendor/yootheme/utils/src/EventDispatcher.php:115
    16	YOOtheme\EventDispatcher->handleDefault()	JROOT/templates/yootheme/vendor/yootheme/utils/src/EventDispatcher.php:45
    15	YOOtheme\EventDispatcher->dispatch()	JROOT/templates/yootheme/vendor/yootheme/platform-joomla/src/Dispatcher.php:44
    14	YOOtheme\Joomla\Dispatcher->YOOtheme\Joomla\{closure}()	JROOT/libraries/joomla/event/dispatcher.php:165
    13	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    12	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/administrator/components/com_zoo/framework/classes/view.php:58
    11	AppView->display()	JROOT/components/com_zoo/controllers/default.php:211
    10	DefaultController->item()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:266
    8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:298
    7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:35
    6	require_once JROOT/components/com_zoo/zoo.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檔案中來建立檔案的連結]

    ---

41. 查詢時間: 0.59 ms 最後的查詢: 15.34 ms 之後 查詢記憶體: 0.005 MB 記憶體於查詢: 17.164 MB 前 回傳的列: 1

    SELECT params
    
      FROM ngzbl_extensions
    
      WHERE `type` = 'plugin' 
      AND `element` = 'jlsitemap_cron' 
      AND `folder` = 'system'

    說明

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

    側寫

    Status	Duration
    starting	0.12 ms
    Executing hook on transaction	0.02 ms
    starting	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    Opening tables	0.13 ms
    init	0.02 ms
    System lock	0.02 ms
    optimizing	0.01 ms
    optimizing	0.01 ms
    optimizing	0.02 ms
    executing	0.02 ms
    optimizing	0.03 ms
    statistics	1.29 ms
    preparing	0.06 ms
    Creating tmp table	0.05 ms
    statistics	0.02 ms
    preparing	0.03 ms
    statistics	0.03 ms
    preparing	0.03 ms
    executing	22.62 ms
    end	0.03 ms
    query end	0.01 ms
    waiting for handler commit	0.08 ms
    closing tables	0.03 ms
    freeing items	0.05 ms
    cleaning up	0.05 ms

    呼叫堆疊

    #	Caller	檔案與行號
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    9	JDatabaseDriver->loadResult()	JROOT/plugins/system/jlsitemap_cron/jlsitemap_cron.php:197
    8	PlgSystemJLSitemap_Cron->checkCacheTime()	JROOT/plugins/system/jlsitemap_cron/jlsitemap_cron.php:52
    7	PlgSystemJLSitemap_Cron->onBeforeRender()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1102
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

42. 查詢時間: 1.25 ms 最後的查詢: 4.54 ms 之後 查詢記憶體: 0.010 MB 記憶體於查詢: 17.237 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 ngzbl_fields AS a
    
      LEFT JOIN `ngzbl_languages` AS l 
      ON l.lang_code = a.language
    
      LEFT JOIN ngzbl_users AS uc 
      ON uc.id=a.checked_out
    
      LEFT JOIN ngzbl_viewlevels AS ag 
      ON ag.id = a.access
    
      LEFT JOIN ngzbl_users AS ua 
      ON ua.id = a.created_user_id
    
      LEFT JOIN ngzbl_fields_groups AS g 
      ON g.id = a.group_id
    
      WHERE a.context = 'mod_custom.content' 
      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_context	766	const	1	100.00	Using where; Using temporary; 使用filesort
    1	SIMPLE	l	NULL	eq_ref	idx_langcode	idx_langcode	28	cawiaorg_site.a.language	1	100.00	Using index condition
    1	SIMPLE	uc	NULL	eq_ref	PRIMARY	PRIMARY	4	cawiaorg_site.a.checked_out	1	100.00	NULL
    1	SIMPLE	ag	NULL	eq_ref	PRIMARY	PRIMARY	4	cawiaorg_site.a.access	1	100.00	Using where
    1	SIMPLE	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	cawiaorg_site.a.created_user_id	1	100.00	Using where
    1	SIMPLE	g	NULL	eq_ref	PRIMARY	PRIMARY	4	cawiaorg_site.a.group_id	1	100.00	Using where

    側寫

    Status	Duration
    starting	0.11 ms
    Executing hook on transaction	0.01 ms
    starting	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.09 ms
    init	0.03 ms
    System lock	0.02 ms
    optimizing	0.01 ms
    optimizing	0.01 ms
    optimizing	0.02 ms
    executing	0.03 ms
    optimizing	0.05 ms
    statistics	0.30 ms
    preparing	0.06 ms
    Creating tmp table	0.06 ms
    statistics	0.02 ms
    preparing	0.03 ms
    statistics	0.03 ms
    preparing	0.03 ms
    executing	10.99 ms
    end	0.09 ms
    query end	0.03 ms
    waiting for handler commit	0.04 ms
    closing tables	0.03 ms
    freeing items	0.05 ms
    cleaning up	0.02 ms

    呼叫堆疊

    #	Caller	檔案與行號
    23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    22	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
    21	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
    20	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
    19	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
    18	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
    17	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    15	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
    14	JHtmlContent::prepare()	與下面行一樣的呼叫
    13	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
    12	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
    11	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/modules/mod_custom/mod_custom.php:15
    10	include JROOT/modules/mod_custom/mod_custom.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/yootheme/vendor/yootheme/theme-joomla-modules/src/ModulesRenderer.php:29
    7	YOOtheme\Theme\Joomla\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

43. 查詢時間: 0.34 ms 最後的查詢: 0.71 ms 之後 查詢記憶體: 0.007 MB 記憶體於查詢: 17.279 MB 前 回傳的列: 1

    SELECT `language` 
      FROM `ngzbl_modules` 
      WHERE `id` = "94"

    說明

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

    側寫

    Status	Duration
    starting	0.06 ms
    Executing hook on transaction	0.02 ms
    starting	0.02 ms
    checking permissions	0.02 ms
    Opening tables	0.05 ms
    init	0.02 ms
    System lock	0.02 ms
    optimizing	0.02 ms
    statistics	0.06 ms
    preparing	0.02 ms
    executing	0.03 ms
    end	0.02 ms
    query end	0.01 ms
    waiting for handler commit	0.02 ms
    closing tables	0.02 ms
    freeing items	0.03 ms
    cleaning up	0.02 ms

    呼叫堆疊

    #	Caller	檔案與行號
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    13	JDatabaseDriver->loadResult()	JROOT/modules/mod_myshortlist/helper.php:78
    12	ModMyShortlistHelper->getLanguageFromModuleID()	JROOT/modules/mod_myshortlist/helper.php:49
    11	ModMyShortlistHelper->initialize()	JROOT/modules/mod_myshortlist/mod_myshortlist.php:17
    10	include JROOT/modules/mod_myshortlist/mod_myshortlist.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/yootheme/vendor/yootheme/theme-joomla-modules/src/ModulesRenderer.php:29
    7	YOOtheme\Theme\Joomla\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

44. 查詢時間: 0.29 ms 最後的查詢: 0.45 ms 之後 查詢記憶體: 0.007 MB 記憶體於查詢: 17.289 MB 前 回傳的列: 1

    SELECT `language` 
      FROM `ngzbl_modules` 
      WHERE `id` = "109"

    說明

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

    側寫

    Status	Duration
    starting	0.04 ms
    Executing hook on transaction	0.02 ms
    starting	0.02 ms
    checking permissions	0.02 ms
    Opening tables	0.04 ms
    init	0.02 ms
    System lock	0.02 ms
    optimizing	0.02 ms
    statistics	0.04 ms
    preparing	0.03 ms
    executing	0.03 ms
    end	0.01 ms
    query end	0.01 ms
    waiting for handler commit	0.02 ms
    closing tables	0.02 ms
    freeing items	0.02 ms
    cleaning up	0.01 ms

    呼叫堆疊

    #	Caller	檔案與行號
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    13	JDatabaseDriver->loadResult()	JROOT/modules/mod_myshortlist/helper.php:78
    12	ModMyShortlistHelper->getLanguageFromModuleID()	JROOT/modules/mod_myshortlist/helper.php:49
    11	ModMyShortlistHelper->initialize()	JROOT/modules/mod_myshortlist/mod_myshortlist.php:17
    10	include JROOT/modules/mod_myshortlist/mod_myshortlist.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/yootheme/vendor/yootheme/theme-joomla-modules/src/ModulesRenderer.php:29
    7	YOOtheme\Theme\Joomla\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

45. 查詢時間: 0.29 ms 最後的查詢: 4.53 ms 之後 查詢記憶體: 0.007 MB 記憶體於查詢: 17.282 MB 前 回傳的列: 1
    重覆查詢: #9  #46

    SELECT MAX(`id`) 
      FROM `ngzbl_myshortlist_customblock_items`

    說明

    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 min/max row

    側寫

    Status	Duration
    starting	0.06 ms
    Executing hook on transaction	0.01 ms
    starting	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.05 ms
    init	0.02 ms
    System lock	0.02 ms
    optimizing	0.02 ms
    statistics	0.07 ms
    preparing	0.03 ms
    optimizing	0.02 ms
    statistics	0.03 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    preparing	0.02 ms
    executing	0.03 ms
    end	0.02 ms
    query end	0.01 ms
    waiting for handler commit	0.02 ms
    closing tables	0.02 ms
    freeing items	0.02 ms
    cleaning up	0.01 ms

    呼叫堆疊

    #	Caller	檔案與行號
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    15	JDatabaseDriver->loadResult()	JROOT/plugins/system/myshortlist_button/helper.php:44
    14	MyShortlistPluginHelper->loadLastID()	JROOT/plugins/system/myshortlist_button/helper.php:31
    13	MyShortlistPluginHelper->__construct()	JROOT/plugins/system/myshortlist_button/myshortlist_button.php:29
    12	plgSystemMyShortlist_Button->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
    11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
    8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
    7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

46. 查詢時間: 0.38 ms 最後的查詢: 1.77 ms 之後 查詢記憶體: 0.005 MB 記憶體於查詢: 17.349 MB 前 回傳的列: 1
    重覆查詢: #9  #45

    SELECT MAX(`id`) 
      FROM `ngzbl_myshortlist_customblock_items`

    說明

    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 min/max row

    側寫

    Status	Duration
    starting	0.09 ms
    Executing hook on transaction	0.01 ms
    starting	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.05 ms
    init	0.02 ms
    System lock	0.02 ms
    optimizing	0.02 ms
    statistics	0.06 ms
    preparing	0.02 ms
    optimizing	0.02 ms
    statistics	0.03 ms
    optimizing	0.03 ms
    statistics	0.02 ms
    preparing	0.02 ms
    executing	0.03 ms
    end	0.02 ms
    query end	0.01 ms
    waiting for handler commit	0.02 ms
    closing tables	0.02 ms
    freeing items	0.02 ms
    cleaning up	0.01 ms

    呼叫堆疊

    #	Caller	檔案與行號
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    10	JDatabaseDriver->loadResult()	JROOT/plugins/system/myshortlist_button/helper.php:44
    9	MyShortlistPluginHelper->loadLastID()	JROOT/plugins/system/myshortlist_button/helper.php:31
    8	MyShortlistPluginHelper->__construct()	JROOT/plugins/system/myshortlist_button/myshortlist_button.php:101
    7	plgSystemMyShortlist_Button->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

47. 查詢時間: 0.48 ms 最後的查詢: 0.24 ms 之後 查詢記憶體: 0.009 MB 記憶體於查詢: 17.360 MB 前 回傳的列: 1

    SELECT `alias`
    
      FROM `ngzbl_content`
    
      WHERE id = '162'

    說明

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

    側寫

    Status	Duration
    starting	0.11 ms
    Executing hook on transaction	0.02 ms
    starting	0.03 ms
    checking permissions	0.02 ms
    Opening tables	0.03 ms
    init	0.01 ms
    System lock	0.02 ms
    optimizing	0.02 ms
    statistics	0.08 ms
    preparing	0.03 ms
    executing	0.05 ms
    end	0.03 ms
    query end	0.02 ms
    waiting for handler commit	0.02 ms
    closing tables	0.02 ms
    freeing items	0.02 ms
    cleaning up	0.01 ms

    呼叫堆疊

    #	Caller	檔案與行號
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    18	JDatabaseDriver->loadResult()	JROOT/components/com_content/router.php:125
    17	ContentRouter->getArticleSegment()	與下面行一樣的呼叫
    16	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
    15	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
    14	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
    13	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:676
    12	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
    11	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
    10	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    9	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    8	Joomla\CMS\Router\Route::_()	JROOT/plugins/system/sef/sef.php:110
    7	PlgSystemSef->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

48. 查詢時間: 0.73 ms 最後的查詢: 0.32 ms 之後 查詢記憶體: 0.009 MB 記憶體於查詢: 17.376 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 `ngzbl_categories` AS `s`
    
      INNER JOIN `ngzbl_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 = 2
    
      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	NULL
    1	SIMPLE	c	NULL	range	cat_idx,idx_access,idx_left_right	idx_left_right	4	NULL	2	100.00	Using index condition; Using where

    側寫

    Status	Duration
    starting	0.12 ms
    Executing hook on transaction	0.02 ms
    starting	0.02 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.31 ms
    init	0.03 ms
    System lock	0.02 ms
    optimizing	0.03 ms
    statistics	0.11 ms
    preparing	0.03 ms
    Creating tmp table	0.06 ms
    executing	0.25 ms
    end	0.02 ms
    query end	0.01 ms
    waiting for handler commit	0.04 ms
    closing tables	0.02 ms
    freeing items	0.03 ms
    cleaning up	0.02 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/components/com_content/router.php:72
    17	ContentRouter->getCategorySegment()	與下面行一樣的呼叫
    16	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
    15	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
    14	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
    13	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:676
    12	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
    11	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
    10	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    9	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    8	Joomla\CMS\Router\Route::_()	JROOT/plugins/system/sef/sef.php:110
    7	PlgSystemSef->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

49. 查詢時間: 0.34 ms 最後的查詢: 0.21 ms 之後 查詢記憶體: 0.008 MB 記憶體於查詢: 17.395 MB 前 回傳的列: 1

    SELECT alias
    
      FROM ngzbl_content
    
      WHERE id=162

    說明

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

    側寫

    Status	Duration
    starting	0.04 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    init	0.01 ms
    System lock	0.02 ms
    optimizing	0.02 ms
    statistics	0.04 ms
    preparing	0.02 ms
    executing	0.02 ms
    end	0.01 ms
    query end	0.01 ms
    waiting for handler commit	0.02 ms
    closing tables	0.02 ms
    freeing items	0.02 ms
    cleaning up	0.01 ms

    呼叫堆疊

    #	Caller	檔案與行號
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    16	JDatabaseDriver->loadResult()	JROOT/components/com_content/helpers/legacyrouter.php:140
    15	ContentRouterRulesLegacy->build()	JROOT/libraries/src/Component/Router/RouterView.php:244
    14	Joomla\CMS\Component\Router\RouterView->build()	JROOT/libraries/src/Router/SiteRouter.php:532
    13	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
    12	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
    11	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
    10	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    9	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    8	Joomla\CMS\Router\Route::_()	JROOT/plugins/system/sef/sef.php:110
    7	PlgSystemSef->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

50. 查詢時間: 0.34 ms 最後的查詢: 0.21 ms 之後 查詢記憶體: 0.009 MB 記憶體於查詢: 17.444 MB 前 回傳的列: 1

    SELECT `alias`
    
      FROM `ngzbl_content`
    
      WHERE id = '176'

    說明

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

    側寫

    Status	Duration
    starting	0.03 ms
    Executing hook on transaction	0.01 ms
    starting	0.02 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.03 ms
    preparing	0.02 ms
    executing	0.02 ms
    end	0.01 ms
    query end	0.01 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.01 ms

    呼叫堆疊

    #	Caller	檔案與行號
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    18	JDatabaseDriver->loadResult()	JROOT/components/com_content/router.php:125
    17	ContentRouter->getArticleSegment()	與下面行一樣的呼叫
    16	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
    15	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
    14	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
    13	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:676
    12	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
    11	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
    10	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    9	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    8	Joomla\CMS\Router\Route::_()	JROOT/plugins/system/sef/sef.php:110
    7	PlgSystemSef->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---