酷妹

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1778692106,
                "last": 1778692106,
                "now": 1778692106
            },
            "token": "nAJo4Q9F0pYCLaioXLSJkYK3DKKeu8I6"
        },
        "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": "955"
                },
                "categories": {
                    "current": null
                }
            }
        }
    }
}

時間

記憶體

38 查詢記錄 68.49 ms

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

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

   說明

   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.16 ms
   Executing hook on transaction	0.06 ms
   starting	0.03 ms
   checking permissions	0.04 ms
   Opening tables	1.48 ms
   init	0.03 ms
   System lock	0.02 ms
   optimizing	0.02 ms
   statistics	0.08 ms
   executing	0.02 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.02 ms
   cleaning up	0.01 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.33 ms 最後的查詢: 0.38 ms 之後 查詢記憶體: 0.004 MB 記憶體於查詢: 0.993 MB 前 回傳的列: 0

   SELECT `session_id`
   
     FROM `ngzbl_session`
   
     WHERE `session_id` = X'3836636465306432663863396335326264366466623963663131613834393863' 
     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.04 ms
   Executing hook on transaction	0.01 ms
   starting	0.02 ms
   checking permissions	0.02 ms
   Opening tables	0.02 ms
   init	0.02 ms
   System lock	0.02 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.04 ms
   cleaning up	0.01 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.56 ms 最後的查詢: 0.07 ms 之後 查詢記憶體: 0.004 MB 記憶體於查詢: 0.998 MB 前

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

   說明

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

   側寫

   Status	Duration
   starting	0.04 ms
   Executing hook on transaction	0.01 ms
   starting	0.03 ms
   checking permissions	0.02 ms
   Opening tables	0.03 ms
   init	0.02 ms
   System lock	0.03 ms
   update	0.24 ms
   end	0.02 ms
   query end	0.03 ms
   waiting for handler commit	0.03 ms
   closing tables	0.02 ms
   freeing items	0.03 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. 查詢時間: 1.61 ms 最後的查詢: 1.31 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.05 ms
   Executing hook on transaction	0.01 ms
   starting	0.02 ms
   checking permissions	0.01 ms
   Opening tables	1.11 ms
   init	0.03 ms
   System lock	0.02 ms
   optimizing	0.01 ms
   statistics	0.02 ms
   preparing	0.02 ms
   executing	0.10 ms
   end	0.02 ms
   query end	0.02 ms
   waiting for handler commit	0.02 ms
   closing tables	0.03 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.55 ms 最後的查詢: 0.08 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.05 ms
   Executing hook on transaction	0.01 ms
   starting	0.02 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   Opening tables	1.08 ms
   init	0.03 ms
   System lock	0.03 ms
   optimizing	0.04 ms
   statistics	0.06 ms
   preparing	0.03 ms
   executing	0.04 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.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. 查詢時間: 1.92 ms 最後的查詢: 17.18 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.15 ms
   Executing hook on transaction	0.06 ms
   starting	0.03 ms
   checking permissions	0.02 ms
   Opening tables	1.17 ms
   init	0.06 ms
   System lock	0.02 ms
   optimizing	0.02 ms
   statistics	0.15 ms
   preparing	0.03 ms
   executing	0.10 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	檔案與行號
   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. 查詢時間: 1.84 ms 最後的查詢: 13.07 ms 之後 查詢記憶體: 0.007 MB 記憶體於查詢: 5.526 MB 前 回傳的列: 1

   SELECT id 
     FROM ngzbl_zoo_item 
     WHERE alias = '酷妹' 
     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.12 ms
   Executing hook on transaction	0.02 ms
   starting	0.02 ms
   checking permissions	0.02 ms
   Opening tables	1.24 ms
   init	0.03 ms
   System lock	0.02 ms
   optimizing	0.02 ms
   statistics	0.13 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.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: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. 查詢時間: 1.14 ms 最後的查詢: 0.19 ms 之後 查詢記憶體: 0.007 MB 記憶體於查詢: 5.537 MB 前 回傳的列: 0

   SELECT id 
     FROM ngzbl_zoo_category 
     WHERE alias = '酷妹' 
     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.04 ms
   Executing hook on transaction	0.01 ms
   starting	0.02 ms
   checking permissions	0.02 ms
   Opening tables	0.77 ms
   init	0.03 ms
   System lock	0.02 ms
   optimizing	0.02 ms
   statistics	0.10 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	檔案與行號
   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. 查詢時間: 1.10 ms 最後的查詢: 0.41 ms 之後 查詢記憶體: 0.006 MB 記憶體於查詢: 5.545 MB 前 回傳的列: 1
   重覆查詢: #33  #34

   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.04 ms
   Executing hook on transaction	0.01 ms
   starting	0.02 ms
   checking permissions	0.02 ms
   Opening tables	0.72 ms
   init	0.03 ms
   System lock	0.02 ms
   optimizing	0.08 ms
   executing	0.02 ms
   end	0.03 ms
   query end	0.02 ms
   waiting for handler commit	0.03 ms
   closing tables	0.04 ms
   freeing items	0.02 ms
   cleaning up	0.02 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 最後的查詢: 2.14 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.01 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.07 ms
    preparing	0.02 ms
    executing	0.04 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	檔案與行號
    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.70 ms 最後的查詢: 4.85 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.07 ms
    Executing hook on transaction	0.03 ms
    starting	0.03 ms
    checking permissions	0.03 ms
    Opening tables	0.05 ms
    init	0.03 ms
    System lock	0.14 ms
    updating	0.10 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.02 ms
    cleaning up	0.01 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.19 ms 最後的查詢: 6.46 ms 之後 查詢記憶體: 0.009 MB 記憶體於查詢: 6.482 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.04 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.02 ms
    Opening tables	0.03 ms
    init	0.03 ms
    System lock	0.02 ms
    optimizing	0.02 ms
    statistics	0.17 ms
    preparing	0.02 ms
    executing	0.03 ms
    end	0.01 ms
    query end	0.03 ms
    waiting for handler commit	0.03 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/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. 查詢時間: 1.64 ms 最後的查詢: 3.62 ms 之後 查詢記憶體: 0.009 MB 記憶體於查詢: 6.751 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=955 
      AND b.published = 1 UNION SELECT 0 
      FROM ngzbl_zoo_category_item AS a 
      WHERE a.item_id=955 
      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.03 ms
    Executing hook on transaction	0.01 ms
    starting	0.02 ms
    checking permissions	0.03 ms
    Opening tables	0.79 ms
    init	0.03 ms
    System lock	0.02 ms
    optimizing	0.02 ms
    statistics	0.12 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.03 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.69 ms 最後的查詢: 10.86 ms 之後 查詢記憶體: 0.006 MB 記憶體於查詢: 6.875 MB 前

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

    說明

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

    側寫

    Status	Duration
    starting	0.10 ms
    Executing hook on transaction	0.02 ms
    starting	0.03 ms
    checking permissions	0.02 ms
    Opening tables	0.91 ms
    init	0.03 ms
    System lock	0.02 ms
    optimizing	0.02 ms
    statistics	0.09 ms
    preparing	0.02 ms
    executing	0.73 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檔案中來建立檔案的連結]

    ---

15. 查詢時間: 1.63 ms 最後的查詢: 0.75 ms 之後 查詢記憶體: 0.016 MB 記憶體於查詢: 6.906 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.04 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.11 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	檔案與行號
    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檔案中來建立檔案的連結]

    ---

16. 查詢時間: 2.19 ms 最後的查詢: 35.75 ms 之後 查詢記憶體: 0.013 MB 記憶體於查詢: 10.650 MB 前 回傳的列: 1

    SELECT name 
      FROM ngzbl_zoo_tag 
      WHERE item_id = 955

    說明

    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.05 ms
    Executing hook on transaction	0.02 ms
    starting	0.03 ms
    checking permissions	0.03 ms
    Opening tables	0.04 ms
    init	0.01 ms
    System lock	0.03 ms
    optimizing	0.03 ms
    statistics	0.14 ms
    preparing	0.03 ms
    executing	0.14 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.04 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檔案中來建立檔案的連結]

    ---

17. 查詢時間: 1.83 ms 最後的查詢: 0.22 ms 之後 查詢記憶體: 0.017 MB 記憶體於查詢: 10.670 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.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.90 ms
    init	0.03 ms
    System lock	0.04 ms
    optimizing	0.02 ms
    statistics	0.14 ms
    preparing	0.03 ms
    optimizing	0.02 ms
    statistics	0.08 ms
    optimizing	0.02 ms
    statistics	0.03 ms
    preparing	0.03 ms
    executing	0.05 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.02 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檔案中來建立檔案的連結]

    ---

18. 查詢時間: 2.80 ms 最後的查詢: 0.51 ms 之後 查詢記憶體: 0.017 MB 記憶體於查詢: 10.722 MB 前 回傳的列: 8

    SHOW FULL COLUMNS 
      FROM `ngzbl_assets`

    說明

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

    側寫

    Status	Duration
    starting	0.08 ms
    Executing hook on transaction	0.02 ms
    starting	0.03 ms
    checking permissions	0.02 ms
    Opening tables	0.04 ms
    init	0.02 ms
    System lock	0.19 ms
    updating	0.08 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.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檔案中來建立檔案的連結]

    ---

19. 查詢時間: 0.47 ms 最後的查詢: 0.50 ms 之後 查詢記憶體: 0.016 MB 記憶體於查詢: 10.756 MB 前 回傳的列: 0
    重覆查詢: #20

    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.05 ms
    Executing hook on transaction	0.02 ms
    starting	0.03 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.07 ms
    preparing	0.02 ms
    executing	0.85 ms
    end	0.03 ms
    query end	0.02 ms
    waiting for handler commit	0.02 ms
    closing tables	0.03 ms
    freeing items	0.03 ms
    cleaning up	0.02 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檔案中來建立檔案的連結]

    ---

20. 查詢時間: 0.48 ms 最後的查詢: 0.28 ms 之後 查詢記憶體: 0.016 MB 記憶體於查詢: 10.774 MB 前 回傳的列: 0
    重覆查詢: #19

    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.18 ms
    Executing hook on transaction	0.05 ms
    starting	0.03 ms
    checking permissions	0.02 ms
    Opening tables	1.41 ms
    init	0.04 ms
    System lock	0.02 ms
    optimizing	0.02 ms
    statistics	0.15 ms
    preparing	0.03 ms
    executing	0.04 ms
    end	0.02 ms
    query end	0.02 ms
    waiting for handler commit	0.05 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: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檔案中來建立檔案的連結]

    ---

21. 查詢時間: 0.57 ms 最後的查詢: 129.75 ms 之後 查詢記憶體: 0.017 MB 記憶體於查詢: 16.411 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.07 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.03 ms
    statistics	0.13 ms
    preparing	0.03 ms
    executing	1.29 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.03 ms
    cleaning up	0.02 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檔案中來建立檔案的連結]

    ---

22. 查詢時間: 0.71 ms 最後的查詢: 8.19 ms 之後 查詢記憶體: 0.016 MB 記憶體於查詢: 16.616 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.08 ms
    Executing hook on transaction	0.02 ms
    starting	0.07 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    Opening tables	1.04 ms
    init	0.04 ms
    System lock	0.02 ms
    optimizing	0.04 ms
    statistics	0.14 ms
    preparing	0.05 ms
    Creating tmp table	0.08 ms
    executing	0.35 ms
    checking permissions	0.14 ms
    checking permissions	0.05 ms
    checking permissions	0.05 ms
    checking permissions	0.04 ms
    checking permissions	0.03 ms
    checking permissions	0.07 ms
    checking permissions	0.03 ms
    checking permissions	0.03 ms
    checking permissions	0.02 ms
    checking permissions	0.09 ms
    end	0.02 ms
    query end	0.02 ms
    waiting for handler commit	0.07 ms
    closing tables	0.03 ms
    freeing items	0.07 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檔案中來建立檔案的連結]

    ---

23. 查詢時間: 0.43 ms 最後的查詢: 1.09 ms 之後 查詢記憶體: 0.016 MB 記憶體於查詢: 16.666 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.07 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.07 ms
    executing	0.03 ms
    end	0.02 ms
    query end	0.02 ms
    waiting for handler commit	0.02 ms
    closing tables	0.03 ms
    freeing items	0.02 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檔案中來建立檔案的連結]

    ---

24. 查詢時間: 17.63 ms 最後的查詢: 7.58 ms 之後 查詢記憶體: 0.018 MB 記憶體於查詢: 16.710 MB 前 回傳的列: 0

    SELECT ritem_id, params 
      FROM ngzbl_zoo_relateditemsproxref 
      WHERE item_id = 955 
      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.06 ms
    Executing hook on transaction	0.02 ms
    starting	0.02 ms
    checking permissions	0.03 ms
    Opening tables	0.04 ms
    init	0.02 ms
    System lock	0.03 ms
    optimizing	0.03 ms
    statistics	0.07 ms
    executing	0.03 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.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檔案中來建立檔案的連結]

    ---

25. 查詢時間: 6.09 ms 最後的查詢: 1.07 ms 之後 查詢記憶體: 0.016 MB 記憶體於查詢: 16.680 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  = 6 
      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 = 955

    說明

    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	282	100.00	NULL
    4	DERIVED	b	NULL	ref	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	PRIMARY	4	const	282	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.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.03 ms
    preparing	0.03 ms
    executing	0.07 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檔案中來建立檔案的連結]

    ---

26. 查詢時間: 3.22 ms 最後的查詢: 0.18 ms 之後 查詢記憶體: 0.016 MB 記憶體於查詢: 16.697 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  = 6 
      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 = 202 OR ROWNUM = 204

    說明

    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	282	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	282	100.00	NULL
    4	DERIVED	b	NULL	ref	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	PRIMARY	4	const	282	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.13 ms
    Executing hook on transaction	0.04 ms
    starting	0.03 ms
    checking permissions	0.02 ms
    Opening tables	0.16 ms
    init	0.02 ms
    System lock	0.02 ms
    optimizing	0.03 ms
    statistics	0.07 ms
    preparing	0.02 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檔案中來建立檔案的連結]

    ---

27. 查詢時間: 0.79 ms 最後的查詢: 1.29 ms 之後 查詢記憶體: 0.016 MB 記憶體於查詢: 16.758 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=953 
      AND b.published = 1 UNION SELECT 0 
      FROM ngzbl_zoo_category_item AS a 
      WHERE a.item_id=953 
      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.07 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.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: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檔案中來建立檔案的連結]

    ---

28. 查詢時間: 0.74 ms 最後的查詢: 0.77 ms 之後 查詢記憶體: 0.016 MB 記憶體於查詢: 16.777 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=956 
      AND b.published = 1 UNION SELECT 0 
      FROM ngzbl_zoo_category_item AS a 
      WHERE a.item_id=956 
      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.16 ms
    Executing hook on transaction	0.03 ms
    starting	0.02 ms
    checking permissions	0.02 ms
    Opening tables	0.15 ms
    init	0.02 ms
    System lock	0.02 ms
    optimizing	0.02 ms
    statistics	0.04 ms
    preparing	0.03 ms
    executing	16.70 ms
    end	0.12 ms
    query end	0.05 ms
    waiting for handler commit	0.03 ms
    closing tables	0.03 ms
    freeing items	0.04 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檔案中來建立檔案的連結]

    ---

29. 查詢時間: 0.60 ms 最後的查詢: 19.37 ms 之後 查詢記憶體: 0.005 MB 記憶體於查詢: 16.966 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.18 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.14 ms
    init	0.02 ms
    System lock	0.02 ms
    optimizing	0.02 ms
    optimizing	0.02 ms
    optimizing	0.02 ms
    executing	0.02 ms
    optimizing	0.05 ms
    statistics	0.38 ms
    preparing	0.05 ms
    Creating tmp table	0.05 ms
    statistics	0.02 ms
    preparing	0.03 ms
    statistics	0.03 ms
    preparing	0.03 ms
    executing	4.66 ms
    end	0.06 ms
    query end	0.02 ms
    waiting for handler commit	0.06 ms
    closing tables	0.02 ms
    freeing items	0.05 ms
    cleaning up	0.02 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檔案中來建立檔案的連結]

    ---

30. 查詢時間: 4.43 ms 最後的查詢: 4.68 ms 之後 查詢記憶體: 0.010 MB 記憶體於查詢: 17.039 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.13 ms
    Executing hook on transaction	0.03 ms
    starting	0.03 ms
    checking permissions	0.04 ms
    checking permissions	0.03 ms
    Opening tables	0.11 ms
    init	0.02 ms
    System lock	0.02 ms
    optimizing	0.02 ms
    optimizing	0.02 ms
    optimizing	0.02 ms
    executing	0.02 ms
    optimizing	0.05 ms
    statistics	0.29 ms
    preparing	0.04 ms
    Creating tmp table	0.05 ms
    statistics	0.02 ms
    preparing	0.03 ms
    statistics	0.03 ms
    preparing	0.03 ms
    executing	2.01 ms
    end	0.04 ms
    query end	0.02 ms
    waiting for handler commit	0.03 ms
    closing tables	0.02 ms
    freeing items	0.04 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檔案中來建立檔案的連結]

    ---

31. 查詢時間: 0.35 ms 最後的查詢: 0.81 ms 之後 查詢記憶體: 0.007 MB 記憶體於查詢: 17.080 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.05 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.07 ms
    preparing	0.02 ms
    executing	0.03 ms
    end	0.01 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	檔案與行號
    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檔案中來建立檔案的連結]

    ---

32. 查詢時間: 0.30 ms 最後的查詢: 0.51 ms 之後 查詢記憶體: 0.007 MB 記憶體於查詢: 17.091 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.03 ms
    Opening tables	0.08 ms
    init	0.02 ms
    System lock	0.03 ms
    optimizing	0.02 ms
    statistics	0.05 ms
    preparing	0.02 ms
    executing	0.03 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	檔案與行號
    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檔案中來建立檔案的連結]

    ---

33. 查詢時間: 0.42 ms 最後的查詢: 4.65 ms 之後 查詢記憶體: 0.008 MB 記憶體於查詢: 17.090 MB 前 回傳的列: 1
    重覆查詢: #9  #34

    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.08 ms
    Executing hook on transaction	0.03 ms
    starting	0.03 ms
    checking permissions	0.03 ms
    checking permissions	0.01 ms
    checking permissions	0.03 ms
    Opening tables	0.07 ms
    init	0.02 ms
    System lock	0.02 ms
    optimizing	0.02 ms
    statistics	0.09 ms
    preparing	0.03 ms
    optimizing	0.02 ms
    statistics	0.04 ms
    optimizing	0.02 ms
    statistics	0.02 ms
    preparing	0.03 ms
    executing	0.05 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	檔案與行號
    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檔案中來建立檔案的連結]

    ---

34. 查詢時間: 0.34 ms 最後的查詢: 1.76 ms 之後 查詢記憶體: 0.005 MB 記憶體於查詢: 17.158 MB 前 回傳的列: 1
    重覆查詢: #9  #33

    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.08 ms
    Executing hook on transaction	0.02 ms
    starting	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    Opening tables	0.06 ms
    init	0.02 ms
    System lock	0.02 ms
    optimizing	0.02 ms
    statistics	0.07 ms
    preparing	0.03 ms
    optimizing	0.03 ms
    statistics	0.05 ms
    optimizing	0.02 ms
    statistics	0.02 ms
    preparing	0.02 ms
    executing	0.04 ms
    end	0.02 ms
    query end	0.04 ms
    waiting for handler commit	0.04 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: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檔案中來建立檔案的連結]

    ---

35. 查詢時間: 1.61 ms 最後的查詢: 0.24 ms 之後 查詢記憶體: 0.009 MB 記憶體於查詢: 17.170 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.15 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.09 ms
    preparing	0.02 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.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檔案中來建立檔案的連結]

    ---

36. 查詢時間: 2.16 ms 最後的查詢: 0.43 ms 之後 查詢記憶體: 0.009 MB 記憶體於查詢: 17.185 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.14 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	3.39 ms
    init	0.09 ms
    System lock	0.03 ms
    optimizing	0.04 ms
    statistics	0.12 ms
    preparing	0.04 ms
    Creating tmp table	0.06 ms
    executing	0.23 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.01 ms

    呼叫堆疊

    #	Caller	檔案與行號
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
    19	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
    18	Joomla\CMS\Categories\Categories->get()	JROOT/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檔案中來建立檔案的連結]

    ---

37. 查詢時間: 0.46 ms 最後的查詢: 0.29 ms 之後 查詢記憶體: 0.008 MB 記憶體於查詢: 17.204 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.02 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.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檔案中來建立檔案的連結]

    ---

38. 查詢時間: 0.38 ms 最後的查詢: 0.20 ms 之後 查詢記憶體: 0.009 MB 記憶體於查詢: 17.253 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.01 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.02 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.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檔案中來建立檔案的連結]

    ---