{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1728739834,
                "last": 1728739834,
                "now": 1728739834
            },
            "client": {
                "forwarded": "3.239.3.196"
            },
            "token": "MPXeSrkSst3eimZ5z2f55MQavlNTJTXb"
        },
        "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
        }
    }
}

時間

記憶體

96 查詢記錄 216.57 ms

1. 查詢時間: 0.15 ms 查詢記憶體: 0.025 MB 記憶體於查詢: 1.201 MB 前 回傳的列: 0

   SELECT `data`
   
     FROM `c6rhi_session`
   
     WHERE `session_id` = '2hc62qqp4scppgq50e00vq7tmt'

   說明

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	c6rhi_session	const	PRIMARY	PRIMARY	194	const	1

   側寫

   Status	Duration
   starting	0.02 ms
   checking permissions	0.00 ms
   Opening tables	0.01 ms
   After opening tables	0.00 ms
   System lock	0.00 ms
   Table lock	0.00 ms
   init	0.01 ms
   optimizing	0.01 ms
   statistics	0.02 ms
   preparing	0.00 ms
   executing	0.01 ms
   end	0.00 ms
   query end	0.00 ms
   closing tables	0.00 ms
   Unlocking tables	0.00 ms
   freeing items	0.00 ms
   updating status	0.01 ms
   cleaning up	0.00 ms

   呼叫堆疊

   #	Caller	File and line number
   16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
   15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
   14	JSessionStorageDatabase->read()	Same as call in the line below.
   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:660
   9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:620
   8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:498
   7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:455
   6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:758
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
   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:344
   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.12 ms 最後的查詢: 0.45 ms 之後 查詢記憶體: 0.022 MB 記憶體於查詢: 1.217 MB 前 回傳的列: 0

   SELECT `session_id`
   
     FROM `c6rhi_session`
   
     WHERE `session_id` = '2hc62qqp4scppgq50e00vq7tmt' 
     LIMIT 1

   說明

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	c6rhi_session	const	PRIMARY	PRIMARY	194	const	1	Using index

   側寫

   Status	Duration
   starting	0.02 ms
   checking permissions	0.00 ms
   Opening tables	0.01 ms
   After opening tables	0.00 ms
   System lock	0.00 ms
   Table lock	0.00 ms
   init	0.01 ms
   optimizing	0.01 ms
   statistics	0.02 ms
   preparing	0.00 ms
   executing	0.01 ms
   end	0.00 ms
   query end	0.00 ms
   closing tables	0.00 ms
   Unlocking tables	0.00 ms
   freeing items	0.00 ms
   updating status	0.01 ms
   cleaning up	0.00 ms

   呼叫堆疊

   #	Caller	File and line number
   9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
   8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
   7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:153
   6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:760
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
   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:344
   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.62 ms 最後的查詢: 0.05 ms 之後 查詢記憶體: 0.004 MB 記憶體於查詢: 1.222 MB 前

   INSERT INTO `c6rhi_session`
   (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES 
   ('2hc62qqp4scppgq50e00vq7tmt', 1, 1728739834, 0, '', 0)

   說明

   EXPLAIN 無法被使用於查詢: INSERT INTO `c6rhi_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('2hc62qqp4scppgq50e00vq7tmt', 1, 1728739834, 0, '', 0)

   側寫

   Status	Duration
   starting	0.02 ms
   checking permissions	0.00 ms
   Opening tables	0.01 ms
   After opening tables	0.00 ms
   System lock	0.00 ms
   Table lock	0.00 ms
   init	0.01 ms
   update	0.06 ms
   Waiting for query cache lock	0.00 ms
   update	0.00 ms
   end	0.00 ms
   query end	0.48 ms
   closing tables	0.00 ms
   Unlocking tables	0.00 ms
   freeing items	0.00 ms
   updating status	0.01 ms
   cleaning up	0.00 ms

   呼叫堆疊

   #	Caller	File and line number
   8	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
   7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:153
   6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:760
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
   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:344
   2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
   1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

   ---

4. 查詢時間: 0.29 ms 最後的查詢: 0.63 ms 之後 查詢記憶體: 0.031 MB 記憶體於查詢: 1.320 MB 前 回傳的列: 44

   SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
   
     FROM `c6rhi_extensions`
   
     WHERE `type` = 'component' 
     AND `state` = 0 
     AND `enabled` = 1

   說明

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	c6rhi_extensions	ref	extension	extension	62	const	44	Using index condition; Using where

   側寫

   Status	Duration
   starting	0.02 ms
   checking permissions	0.00 ms
   Opening tables	0.01 ms
   After opening tables	0.00 ms
   System lock	0.00 ms
   Table lock	0.00 ms
   init	0.01 ms
   optimizing	0.01 ms
   statistics	0.02 ms
   preparing	0.01 ms
   executing	0.00 ms
   Sending data	0.12 ms
   end	0.00 ms
   query end	0.00 ms
   closing tables	0.00 ms
   Unlocking tables	0.00 ms
   freeing items	0.00 ms
   updating status	0.02 ms
   cleaning up	0.00 ms

   呼叫堆疊

   #	Caller	File and line number
   12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
   11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Component/ComponentHelper.php:445
   10	Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}()	Same as call in the line below.
   9	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
   8	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Component/ComponentHelper.php:453
   7	Joomla\CMS\Component\ComponentHelper::load()	JROOT/libraries/src/Component/ComponentHelper.php:519
   6	Joomla\CMS\Component\ComponentHelper::getComponents()	JROOT/libraries/src/Component/ComponentHelper.php:44
   5	Joomla\CMS\Component\ComponentHelper::getComponent()	JROOT/libraries/src/Component/ComponentHelper.php:103
   4	Joomla\CMS\Component\ComponentHelper::getParams()	JROOT/libraries/src/Application/SiteApplication.php:594
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

5. 查詢時間: 0.28 ms 最後的查詢: 0.48 ms 之後 查詢記憶體: 0.023 MB 記憶體於查詢: 1.357 MB 前 回傳的列: 8

   SELECT id, rules
   
     FROM `c6rhi_viewlevels`

   說明

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	c6rhi_viewlevels	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	8

   側寫

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

   呼叫堆疊

   #	Caller	File and line number
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1500
   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:321
   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:196
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

6. 查詢時間: 0.21 ms 最後的查詢: 0.07 ms 之後 查詢記憶體: 0.022 MB 記憶體於查詢: 1.371 MB 前 回傳的列: 2

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

   說明

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

   側寫

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

   呼叫堆疊

   #	Caller	File and line number
   11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1544
   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:321
   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:196
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

7. 查詢時間: 0.65 ms 最後的查詢: 0.09 ms 之後 查詢記憶體: 0.034 MB 記憶體於查詢: 1.393 MB 前 回傳的列: 108

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

   說明

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	c6rhi_extensions	ref	extension	extension	62	const	258	Using index condition; Using where; Using filesort

   側寫

   Status	Duration
   starting	0.02 ms
   checking permissions	0.00 ms
   Opening tables	0.01 ms
   After opening tables	0.00 ms
   System lock	0.00 ms
   Table lock	0.00 ms
   init	0.01 ms
   optimizing	0.01 ms
   statistics	0.02 ms
   preparing	0.01 ms
   executing	0.00 ms
   Sorting result	0.37 ms
   Sending data	0.11 ms
   end	0.00 ms
   query end	0.00 ms
   closing tables	0.00 ms
   Unlocking tables	0.00 ms
   freeing items	0.00 ms
   updating status	0.01 ms
   cleaning up	0.00 ms

   呼叫堆疊

   #	Caller	File and line number
   11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
   10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:354
   9	Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()	Same as call in the line below.
   8	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
   7	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Plugin/PluginHelper.php:359
   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:196
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

8. 查詢時間: 0.42 ms 最後的查詢: 12.45 ms 之後 查詢記憶體: 0.027 MB 記憶體於查詢: 2.332 MB 前 回傳的列: 1

   SELECT id,template 
     FROM c6rhi_template_styles 
     WHERE client_id=0 
     AND home=1

   說明

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	c6rhi_template_styles	ALL	idx_home	NO INDEX KEY COULD BE USED	NULL	NULL	5	Using where

   側寫

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

   呼叫堆疊

   #	Caller	File and line number
   18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
   17	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_widgetkit/widgetkit.php:23
   16	plgSystemWidgetkit_zoo->{closure}()	JROOT/administrator/components/com_widgetkit/vendor/yootheme/framework/src/Container.php:240
   15	YOOtheme\Framework\Container->offsetGet()	JROOT/administrator/components/com_widgetkit/src/Application.php:49
   14	YOOtheme\Widgetkit\Application->YOOtheme\Widgetkit\{closure}()	Same as call in the line below.
   13	call_user_func_array()	JROOT/administrator/components/com_widgetkit/vendor/yootheme/framework/src/Event/EventDispatcher.php:113
   12	YOOtheme\Framework\Event\EventDispatcher->trigger()	JROOT/administrator/components/com_widgetkit/vendor/yootheme/framework/src/Application.php:149
   11	YOOtheme\Framework\Application->boot()	JROOT/administrator/components/com_widgetkit/widgetkit.php:91
   10	include JROOT/administrator/components/com_widgetkit/widgetkit.php	JROOT/administrator/components/com_widgetkit/widgetkit-app.php:6
   9	include JROOT/administrator/components/com_widgetkit/widgetkit-app.php	JROOT/plugins/system/widgetkit_zoo/widgetkit_zoo.php:9
   8	plgSystemWidgetkit_zoo->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:626
   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:196
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

9. 查詢時間: 27.64 ms 最後的查詢: 0.57 ms 之後 查詢記憶體: 0.005 MB 記憶體於查詢: 2.349 MB 前

   UPDATE c6rhi_redirectonlogin_sessions 
     SET session_id='2hc62qqp4scppgq50e00vq7tmt', unixtime='1728739834' 
     WHERE session_id='adopt_me'

   說明

   EXPLAIN 無法被使用於查詢: UPDATE c6rhi_redirectonlogin_sessions SET session_id='2hc62qqp4scppgq50e00vq7tmt', unixtime='1728739834' WHERE session_id='adopt_me'

   側寫

   Status	Duration
   starting	0.03 ms
   checking permissions	0.00 ms
   Opening tables	0.01 ms
   After opening tables	0.00 ms
   System lock	0.00 ms
   Table lock	0.00 ms
   init	0.02 ms
   updating	27.46 ms
   end	0.01 ms
   query end	0.02 ms
   closing tables	0.00 ms
   Unlocking tables	0.01 ms
   freeing items	0.00 ms
   updating status	0.02 ms
   cleaning up	0.00 ms

   呼叫堆疊

   #	Caller	File and line number
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
   9	JDatabase->query()	JROOT/administrator/components/com_redirectonlogin/plugin_system/plugin_system2.php:120
   8	plgSystemRedirectonlogin->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:626
   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:196
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

10. 查詢時間: 16.96 ms 最後的查詢: 0.04 ms 之後 查詢記憶體: 0.025 MB 記憶體於查詢: 2.354 MB 前 回傳的列: 0

    SELECT *  
      FROM c6rhi_redirectonlogin_sessions  
      WHERE session_id='2hc62qqp4scppgq50e00vq7tmt'  
      LIMIT 1

    說明

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	c6rhi_redirectonlogin_sessions	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	44341	Using where

    側寫

    Status	Duration
    starting	0.02 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    Table lock	0.00 ms
    init	0.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	16.80 ms
    end	0.01 ms
    query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.01 ms
    freeing items	0.00 ms
    updating status	0.02 ms
    cleaning up	0.00 ms

    呼叫堆疊

    #	Caller	File and line number
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    9	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_redirectonlogin/plugin_system/plugin_system2.php:128
    8	plgSystemRedirectonlogin->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:626
    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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

11. 查詢時間: 16.83 ms 最後的查詢: 0.04 ms 之後 查詢記憶體: 0.025 MB 記憶體於查詢: 2.359 MB 前 回傳的列: 0

    SELECT *  
      FROM c6rhi_redirectonlogin_sessions  
      WHERE session_id='adopt_me'  
      AND ip='185.93.229.13'  
      LIMIT 1

    說明

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	c6rhi_redirectonlogin_sessions	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	44341	Using where

    側寫

    Status	Duration
    starting	0.02 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.01 ms
    Table lock	0.00 ms
    init	0.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	16.45 ms
    end	0.01 ms
    query end	0.19 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    freeing items	0.00 ms
    updating status	0.02 ms
    cleaning up	0.00 ms

    呼叫堆疊

    #	Caller	File and line number
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    9	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_redirectonlogin/plugin_system/plugin_system2.php:155
    8	plgSystemRedirectonlogin->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:626
    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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

12. 查詢時間: 0.79 ms 最後的查詢: 0.05 ms 之後 查詢記憶體: 0.005 MB 記憶體於查詢: 2.363 MB 前

    INSERT INTO c6rhi_redirectonlogin_sessions 
      SET session_id='2hc62qqp4scppgq50e00vq7tmt', unixtime='1728739834'

    說明

    EXPLAIN 無法被使用於查詢: INSERT INTO c6rhi_redirectonlogin_sessions SET session_id='2hc62qqp4scppgq50e00vq7tmt', unixtime='1728739834'

    側寫

    Status	Duration
    starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    Table lock	0.00 ms
    init	0.01 ms
    update	0.04 ms
    Waiting for query cache lock	0.00 ms
    update	0.00 ms
    end	0.00 ms
    query end	0.61 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    freeing items	0.00 ms
    updating status	0.01 ms
    cleaning up	0.00 ms

    呼叫堆疊

    #	Caller	File and line number
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
    9	JDatabase->query()	JROOT/administrator/components/com_redirectonlogin/plugin_system/plugin_system2.php:174
    8	plgSystemRedirectonlogin->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:626
    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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

13. 查詢時間: 0.74 ms 最後的查詢: 1.68 ms 之後 查詢記憶體: 0.086 MB 記憶體於查詢: 2.413 MB 前 回傳的列: 82

    SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
    
      FROM c6rhi_menu AS m
    
      LEFT JOIN c6rhi_extensions AS e 
      ON m.component_id = e.extension_id
    
      WHERE m.published = 1 
      AND m.parent_id > 0 
      AND m.client_id = 0
    
      ORDER BY m.lft

    說明

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	m	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	96	Using index condition; Using where; Using filesort
    1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	c1_supermami_prod.m.component_id	1	Using where

    側寫

    Status	Duration
    starting	0.04 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.02 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    Table lock	0.00 ms
    init	0.02 ms
    optimizing	0.02 ms
    statistics	0.04 ms
    preparing	0.02 ms
    executing	0.00 ms
    Sorting result	0.20 ms
    Sending data	0.27 ms
    end	0.00 ms
    query end	0.01 ms
    closing tables	0.00 ms
    Unlocking tables	0.01 ms
    freeing items	0.00 ms
    updating status	0.01 ms
    cleaning up	0.00 ms

    呼叫堆疊

    #	Caller	File and line number
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
    17	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Same as call in the line below.
    16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
    14	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:76
    13	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
    12	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:131
    11	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:375
    10	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
    9	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:64
    8	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
    7	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:491
    6	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
    5	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/libraries/src/Application/CMSApplication.php:1073
    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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

14. 查詢時間: 0.25 ms 最後的查詢: 4.96 ms 之後 查詢記憶體: 0.027 MB 記憶體於查詢: 3.013 MB 前 回傳的列: 1

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

    說明

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

    側寫

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

    呼叫堆疊

    #	Caller	File and line number
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
    19	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
    18	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Same as call in the line below.
    17	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    16	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
    15	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
    14	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
    13	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
    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:520
    9	plgSystemZooSeo->addOpenGraphTags()	JROOT/plugins/system/zooseo/zooseo.php:100
    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:1119
    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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

15. 查詢時間: 0.62 ms 最後的查詢: 0.10 ms 之後 查詢記憶體: 0.006 MB 記憶體於查詢: 3.005 MB 前

    UPDATE `c6rhi_extensions`
    
      SET `params` = '{\"mediaversion\":\"19cae5f3eb1310272f36405d75b39f0a\"}'
    
      WHERE `type` = 'library' 
      AND `element` = 'joomla'

    說明

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

    側寫

    Status	Duration
    starting	0.02 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    Table lock	0.00 ms
    init	0.04 ms
    updating	0.03 ms
    end	0.00 ms
    Waiting for query cache lock	0.00 ms
    end	0.00 ms
    query end	0.44 ms
    closing tables	0.00 ms
    Unlocking tables	0.01 ms
    freeing items	0.00 ms
    updating status	0.01 ms
    cleaning up	0.00 ms

    呼叫堆疊

    #	Caller	File and line number
    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:520
    9	plgSystemZooSeo->addOpenGraphTags()	JROOT/plugins/system/zooseo/zooseo.php:100
    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:1119
    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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

16. 查詢時間: 0.35 ms 最後的查詢: 2.43 ms 之後 查詢記憶體: 0.024 MB 記憶體於查詢: 3.178 MB 前 回傳的列: 3

    SELECT id, home, template, s.params
    
      FROM c6rhi_template_styles as s
    
      LEFT JOIN c6rhi_extensions as e 
      ON e.element=s.template 
      AND e.type='template' 
      AND e.client_id=s.client_id
    
      WHERE s.client_id = 0 
      AND e.enabled = 1

    說明

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	extension	62	const	5	Using index condition; Using where
    1	SIMPLE	s	ALL	idx_template	NO INDEX KEY COULD BE USED	NULL	NULL	5	Using where; Using join buffer (flat, BNL join)

    側寫

    Status	Duration
    starting	0.03 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    Table lock	0.00 ms
    init	0.01 ms
    optimizing	0.02 ms
    statistics	0.03 ms
    preparing	0.03 ms
    executing	0.00 ms
    Sending data	0.12 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.01 ms
    freeing items	0.00 ms
    updating status	0.01 ms
    cleaning up	0.00 ms

    呼叫堆疊

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    13	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
    12	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/administrator/components/com_widgetkit/widgetkit.php:43
    11	plgSystemWidgetkit_zoo->{closure}()	Same as call in the line below.
    10	call_user_func_array()	JROOT/administrator/components/com_widgetkit/vendor/yootheme/framework/src/Event/EventDispatcher.php:113
    9	YOOtheme\Framework\Event\EventDispatcher->trigger()	JROOT/administrator/components/com_widgetkit/vendor/yootheme/framework/src/Application.php:132
    8	YOOtheme\Framework\Application->trigger()	JROOT/administrator/components/com_widgetkit/vendor/yootheme/framework/plugins/joomla/src/JoomlaPlugin.php:141
    7	YOOtheme\Framework\Joomla\JoomlaPlugin->init()	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:1119
    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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

17. 查詢時間: 0.23 ms 最後的查詢: 1.30 ms 之後 查詢記憶體: 0.025 MB 記憶體於查詢: 3.257 MB 前 回傳的列: 1

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

    說明

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

    側寫

    Status	Duration
    starting	0.02 ms
    checking permissions	0.00 ms
    Opening tables	0.02 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    Table lock	0.01 ms
    init	0.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sorting result	0.02 ms
    Sending data	0.02 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.01 ms
    freeing items	0.00 ms
    updating status	0.02 ms
    cleaning up	0.00 ms

    呼叫堆疊

    #	Caller	File and line number
    7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    6	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
    5	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/libraries/src/Application/SiteApplication.php:330
    4	Joomla\CMS\Application\SiteApplication->getParams()	JROOT/libraries/src/Application/SiteApplication.php:138
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

18. 查詢時間: 0.37 ms 最後的查詢: 1.74 ms 之後 查詢記憶體: 0.031 MB 記憶體於查詢: 3.388 MB 前 回傳的列: 44

    SELECT `id`,`name`,`rules`,`parent_id`
    
      FROM `c6rhi_assets`
    
      WHERE `name` IN ('root.1','com_actionlogs','com_acymailing','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_fields','com_finder','com_hikashop','com_installer','com_jce','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_redirect','com_redirectonlogin','com_rsform','com_search','com_tags','com_templates','com_users','com_weblinks','com_widgetkit','com_wrapper','com_zoo','com_zoolanders')

    說明

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	c6rhi_assets	ALL	idx_asset_name	NO INDEX KEY COULD BE USED	NULL	NULL	264	Using where

    側寫

    Status	Duration
    starting	0.03 ms
    checking permissions	0.00 ms
    Opening tables	0.02 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    Table lock	0.00 ms
    init	0.03 ms
    optimizing	0.01 ms
    statistics	0.04 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.14 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    freeing items	0.00 ms
    updating status	0.01 ms
    cleaning up	0.00 ms

    呼叫堆疊

    #	Caller	File and line number
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
    16	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
    15	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
    14	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
    13	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
    12	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/article.php:58
    11	ContentModelArticle->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:435
    10	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/components/com_content/models/article.php:251
    9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

19. 查詢時間: 0.34 ms 最後的查詢: 0.12 ms 之後 查詢記憶體: 0.028 MB 記憶體於查詢: 3.448 MB 前 回傳的列: 19

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

    說明

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	c6rhi_assets	ALL	idx_asset_name,idx_parent_id	NO INDEX KEY COULD BE USED	NULL	NULL	264	Using where

    側寫

    Status	Duration
    starting	0.02 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    Table lock	0.00 ms
    init	0.02 ms
    optimizing	0.01 ms
    statistics	0.04 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.13 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    freeing items	0.00 ms
    updating status	0.02 ms
    cleaning up	0.01 ms

    呼叫堆疊

    #	Caller	File and line number
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:359
    16	Joomla\CMS\Access\Access::preloadPermissions()	JROOT/libraries/src/Access/Access.php:226
    15	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:540
    14	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
    13	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
    12	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/article.php:58
    11	ContentModelArticle->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:435
    10	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/components/com_content/models/article.php:251
    9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

20. 查詢時間: 0.56 ms 最後的查詢: 0.59 ms 之後 查詢記憶體: 0.035 MB 記憶體於查詢: 3.486 MB 前 回傳的列: 31

    SHOW FULL COLUMNS 
      FROM `c6rhi_content`

    說明

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

    側寫

    Status	Duration
    starting	0.02 ms
    checking permissions	0.00 ms
    closing tables	0.00 ms
    Opening tables	0.17 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    Table lock	0.00 ms
    init	0.00 ms
    optimizing	0.00 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.00 ms
    Filling schema table	0.00 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    checking permissions	0.03 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    closing tables	0.01 ms
    executing	0.00 ms
    Sending data	0.04 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.00 ms
    removing tmp table	0.05 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    freeing items	0.00 ms
    updating status	0.02 ms
    cleaning up	0.00 ms

    呼叫堆疊

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    15	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
    14	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
    13	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
    12	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/Content.php:39
    11	Joomla\CMS\Table\Content->__construct()	JROOT/libraries/src/Table/Table.php:312
    10	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_content/models/article.php:253
    9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

21. 查詢時間: 0.19 ms 最後的查詢: 1.12 ms 之後 查詢記憶體: 0.035 MB 記憶體於查詢: 3.568 MB 前 回傳的列: 1

    SELECT *
    
      FROM c6rhi_content
    
      WHERE `id` = '11'

    說明

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	c6rhi_content	const	PRIMARY	PRIMARY	4	const	1

    側寫

    Status	Duration
    starting	0.02 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    Table lock	0.00 ms
    init	0.01 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    preparing	0.00 ms
    Unlocking tables	0.01 ms
    executing	0.01 ms
    Sending data	0.02 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    freeing items	0.00 ms
    updating status	0.01 ms
    cleaning up	0.00 ms

    呼叫堆疊

    #	Caller	File and line number
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1459
    11	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
    10	Joomla\CMS\Table\Table->load()	JROOT/components/com_content/models/article.php:254
    9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

22. 查詢時間: 0.61 ms 最後的查詢: 0.07 ms 之後 查詢記憶體: 0.005 MB 記憶體於查詢: 3.574 MB 前

    UPDATE c6rhi_content
    
      SET `hits` = (`hits` + 1)
    
      WHERE `id` = '11'

    說明

    EXPLAIN 無法被使用於查詢: UPDATE c6rhi_content SET `hits` = (`hits` + 1) WHERE `id` = '11'

    側寫

    Status	Duration
    starting	0.01 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    Table lock	0.00 ms
    init	0.02 ms
    updating	0.03 ms
    end	0.00 ms
    Waiting for query cache lock	0.00 ms
    end	0.00 ms
    query end	0.46 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    freeing items	0.00 ms
    updating status	0.01 ms
    cleaning up	0.00 ms

    呼叫堆疊

    #	Caller	File and line number
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Table/Table.php:1242
    10	Joomla\CMS\Table\Table->hit()	JROOT/components/com_content/models/article.php:255
    9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

23. 查詢時間: 0.45 ms 最後的查詢: 0.47 ms 之後 查詢記憶體: 0.036 MB 記憶體於查詢: 3.599 MB 前 回傳的列: 1

    SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, 
      CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
    
      FROM c6rhi_content AS a
    
      INNER JOIN c6rhi_categories AS c 
      on c.id = a.catid
    
      LEFT JOIN c6rhi_users AS u 
      on u.id = a.created_by
    
      LEFT JOIN c6rhi_categories as parent 
      ON parent.id = c.parent_id
    
      LEFT JOIN c6rhi_content_rating AS v 
      ON a.id = v.content_id
    
      WHERE a.id = 11 
      AND c.published > 0 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-10-12 13:30:34') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-10-12 13:30:34') 
      AND (a.state = 1 OR a.state =2)

    說明

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a	const	PRIMARY,idx_state,idx_catid	PRIMARY	4	const	1
    1	SIMPLE	c	const	PRIMARY	PRIMARY	4	const	1
    1	SIMPLE	u	const	PRIMARY	PRIMARY	4	const	1
    1	SIMPLE	parent	const	PRIMARY	PRIMARY	4	const	1
    1	SIMPLE	v	const	PRIMARY	PRIMARY	4	const	0	unique row not found

    側寫

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

    呼叫堆疊

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
    13	JDatabaseDriver->loadObject()	JROOT/components/com_content/models/article.php:151
    12	ContentModelArticle->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_content/views/article/view.html.php:42
    10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

24. 查詢時間: 0.29 ms 最後的查詢: 0.81 ms 之後 查詢記憶體: 0.034 MB 記憶體於查詢: 3.712 MB 前 回傳的列: 0

    SELECT `m`.`tag_id`,`t`.*
    
      FROM `c6rhi_contentitem_tag_map` AS m 
    
      INNER JOIN `c6rhi_tags` AS t  
      ON `m`.`tag_id` = `t`.`id`
    
      WHERE `m`.`type_alias` = 'com_content.article' 
      AND `m`.`content_item_id` = 11 
      AND `t`.`published` = 1 
      AND t.access IN (1,1,5)

    說明

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	m	ALL	idx_tag_type	NO INDEX KEY COULD BE USED	NULL	NULL	1	Using where
    1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	c1_supermami_prod.m.tag_id	1	Using where

    側寫

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

    呼叫堆疊

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    12	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
    11	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/views/article/view.html.php:184
    10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

25. 查詢時間: 0.15 ms 最後的查詢: 5.69 ms 之後 查詢記憶體: 0.026 MB 記憶體於查詢: 4.153 MB 前 回傳的列: 37

    SELECT *
    
      FROM c6rhi_rsform_config

    說明

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	c6rhi_rsform_config	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	37

    側寫

    Status	Duration
    starting	0.01 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    Table lock	0.00 ms
    init	0.00 ms
    optimizing	0.00 ms
    statistics	0.00 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.02 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    freeing items	0.01 ms
    updating status	0.01 ms
    cleaning up	0.00 ms

    呼叫堆疊

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    13	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_rsform/helpers/config.php:50
    12	RSFormProConfig->load()	JROOT/administrator/components/com_rsform/helpers/config.php:17
    11	RSFormProConfig->__construct()	JROOT/administrator/components/com_rsform/helpers/config.php:97
    10	RSFormProConfig::getInstance()	JROOT/administrator/components/com_rsform/helpers/rsform.php:440
    9	RSFormProHelper::readConfig()	JROOT/plugins/system/rsfpregistration/rsfpregistration.php:25
    8	plgSystemRSFPRegistration->canRun()	JROOT/plugins/system/rsfpregistration/rsfpregistration.php:929
    7	plgSystemRSFPRegistration->onAfterDispatch()	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/SiteApplication.php:199
    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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

26. 查詢時間: 1.25 ms 最後的查詢: 4.31 ms 之後 查詢記憶體: 0.047 MB 記憶體於查詢: 4.304 MB 前 回傳的列: 64

    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM c6rhi_modules AS m
    
      LEFT JOIN c6rhi_modules_menu AS mm 
      ON mm.moduleid = m.id
    
      LEFT JOIN c6rhi_extensions AS e 
      ON e.element = m.module 
      AND e.client_id = m.client_id
    
      WHERE m.published = 1 
      AND e.enabled = 1 
      AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2024-10-12 13:30:34') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-10-12 13:30:34') 
      AND m.access IN (1,1,5) 
      AND m.client_id = 0 
      AND (mm.menuid = 170 OR mm.menuid <= 0)
    
      ORDER BY m.position, m.ordering

    說明

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	m	ref	PRIMARY,published,newsfeeds	published	1	const	81	Using index condition; Using where; Using filesort
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	303	c1_supermami_prod.m.module,const	1	Using index condition; Using where
    1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	c1_supermami_prod.m.id	1	Using where; Using index

    側寫

    Status	Duration
    starting	0.06 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.03 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    Table lock	0.00 ms
    init	0.02 ms
    optimizing	0.02 ms
    statistics	0.05 ms
    preparing	0.03 ms
    executing	0.00 ms
    Sorting result	0.39 ms
    Sending data	0.51 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.01 ms
    cleaning up	0.00 ms

    呼叫堆疊

    #	Caller	File and line number
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    18	JDatabaseDriver->loadObjectList()	Same as call in the line below.
    17	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    16	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:432
    15	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:362
    14	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
    13	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:581
    12	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/templates/yoo_master2/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:54
    11	Warp\Joomla\Helper\WidgetsHelper->count()	JROOT/templates/yoo_master2/layouts/theme.config.php:26
    10	include JROOT/templates/yoo_master2/layouts/theme.config.php	JROOT/templates/yoo_master2/layouts/theme.php:10
    9	include JROOT/templates/yoo_master2/layouts/theme.php	JROOT/templates/yoo_master2/warp/src/Warp/Helper/TemplateHelper.php:49
    8	Warp\Helper\TemplateHelper->render()	JROOT/templates/yoo_master2/index.php:16
    7	require JROOT/templates/yoo_master2/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
    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:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

27. 查詢時間: 0.17 ms 最後的查詢: 1.32 ms 之後 查詢記憶體: 0.030 MB 記憶體於查詢: 4.448 MB 前 回傳的列: 1

    SELECT * 
      FROM c6rhi_zoo_application 
      WHERE id = 8

    說明

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	c6rhi_zoo_application	const	PRIMARY	PRIMARY	4	const	1

    側寫

    Status	Duration
    starting	0.02 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    Table lock	0.00 ms
    init	0.01 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    preparing	0.00 ms
    Unlocking tables	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    freeing items	0.00 ms
    updating status	0.02 ms
    cleaning up	0.00 ms

    呼叫堆疊

    #	Caller	File and line number
    20	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:64
    19	DatabaseHelper->query()	JROOT/administrator/components/com_zoo/framework/classes/table.php:399
    18	AppTable->_queryObject()	JROOT/administrator/components/com_zoo/framework/classes/table.php:189
    17	AppTable->find()	JROOT/administrator/components/com_zoo/tables/application.php:131
    16	ApplicationTable->find()	JROOT/administrator/components/com_zoo/framework/classes/table.php:136
    15	AppTable->get()	JROOT/modules/mod_zootag/mod_zootag.php:32
    14	include JROOT/modules/mod_zootag/mod_zootag.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    13	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    12	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/yoo_master2/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
    11	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/yoo_master2/layouts/theme.config.php:72
    10	include JROOT/templates/yoo_master2/layouts/theme.config.php	JROOT/templates/yoo_master2/layouts/theme.php:10
    9	include JROOT/templates/yoo_master2/layouts/theme.php	JROOT/templates/yoo_master2/warp/src/Warp/Helper/TemplateHelper.php:49
    8	Warp\Helper\TemplateHelper->render()	JROOT/templates/yoo_master2/index.php:16
    7	require JROOT/templates/yoo_master2/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
    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:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

28. 查詢時間: 114.87 ms 最後的查詢: 1.70 ms 之後 查詢記憶體: 0.029 MB 記憶體於查詢: 4.550 MB 前 回傳的列: 20

    SELECT a.name, COUNT(a.item_id) AS items 
      FROM c6rhi_zoo_tag AS a, c6rhi_zoo_item AS b USE INDEX (ID_APPLICATION_INDEX) 
      WHERE 1 
      AND a.item_id = b.id 
      AND b.application_id = 8 
      AND b.state = 1 
      AND b.type = 'blog-post' 
      AND (b.publish_up = '0000-00-00 00:00:00' OR b.publish_up <= '2024-10-12 13:30:34') 
      AND (b.publish_down = '0000-00-00 00:00:00' OR b.publish_down >= '2024-10-12 13:30:34') 
      GROUP BY a.name 
      ORDER BY items DESC 
      LIMIT 0,20

    說明

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	b	ALL	ID_APPLICATION_INDEX	NO INDEX KEY COULD BE USED	NULL	NULL	14850	Using where; Using temporary; Using filesort
    1	SIMPLE	a	ref	PRIMARY	PRIMARY	4	c1_supermami_prod.b.id	6	Using index

    側寫

    Status	Duration
    starting	0.04 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    Table lock	0.01 ms
    init	0.02 ms
    optimizing	0.02 ms
    statistics	0.02 ms
    preparing	0.02 ms
    executing	0.00 ms
    Creating tmp table	0.02 ms
    Copying to tmp table	114.08 ms
    Sorting result	0.24 ms
    Sending data	0.02 ms
    end	0.00 ms
    removing tmp table	0.16 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.11 ms
    freeing items	0.01 ms
    updating status	0.02 ms
    cleaning up	0.00 ms

    呼叫堆疊

    #	Caller	File and line number
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    18	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:134
    17	DatabaseHelper->queryObjectList()	JROOT/administrator/components/com_zoo/tables/tag.php:54
    16	TagTable->getAll()	JROOT/modules/mod_zootag/helper.php:41
    15	TagModuleHelper->buildTagCloud()	JROOT/modules/mod_zootag/mod_zootag.php:40
    14	include JROOT/modules/mod_zootag/mod_zootag.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    13	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    12	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/yoo_master2/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
    11	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/yoo_master2/layouts/theme.config.php:72
    10	include JROOT/templates/yoo_master2/layouts/theme.config.php	JROOT/templates/yoo_master2/layouts/theme.php:10
    9	include JROOT/templates/yoo_master2/layouts/theme.php	JROOT/templates/yoo_master2/warp/src/Warp/Helper/TemplateHelper.php:49
    8	Warp\Helper\TemplateHelper->render()	JROOT/templates/yoo_master2/index.php:16
    7	require JROOT/templates/yoo_master2/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
    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:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

29. 查詢時間: 0.24 ms 最後的查詢: 3.32 ms 之後 查詢記憶體: 0.030 MB 記憶體於查詢: 4.663 MB 前 回傳的列: 1

    SELECT * 
      FROM c6rhi_zoo_application 
      WHERE id = 3

    說明

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	c6rhi_zoo_application	const	PRIMARY	PRIMARY	4	const	1

    側寫

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

    呼叫堆疊

    #	Caller	File and line number
    20	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:64
    19	DatabaseHelper->query()	JROOT/administrator/components/com_zoo/framework/classes/table.php:399
    18	AppTable->_queryObject()	JROOT/administrator/components/com_zoo/framework/classes/table.php:189
    17	AppTable->find()	JROOT/administrator/components/com_zoo/tables/application.php:131
    16	ApplicationTable->find()	JROOT/administrator/components/com_zoo/framework/classes/table.php:136
    15	AppTable->get()	JROOT/modules/mod_zoocategory/mod_zoocategory.php:31
    14	include JROOT/modules/mod_zoocategory/mod_zoocategory.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    13	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    12	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/yoo_master2/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
    11	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/yoo_master2/layouts/theme.config.php:72
    10	include JROOT/templates/yoo_master2/layouts/theme.config.php	JROOT/templates/yoo_master2/layouts/theme.php:10
    9	include JROOT/templates/yoo_master2/layouts/theme.php	JROOT/templates/yoo_master2/warp/src/Warp/Helper/TemplateHelper.php:49
    8	Warp\Helper\TemplateHelper->render()	JROOT/templates/yoo_master2/index.php:16
    7	require JROOT/templates/yoo_master2/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
    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:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

30. 查詢時間: 0.27 ms 最後的查詢: 0.82 ms 之後 查詢記憶體: 0.034 MB 記憶體於查詢: 4.694 MB 前 回傳的列: 19

    SELECT * 
      FROM c6rhi_zoo_category 
      WHERE application_id = 3 
      AND published = 1 
      ORDER BY ordering

    說明

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	c6rhi_zoo_category	ref	APPLICATIONID_ID_INDEX2,published	APPLICATIONID_ID_INDEX2	4	const	19	Using where; Using filesort

    側寫

    Status	Duration
    starting	0.03 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    Table lock	0.00 ms
    init	0.01 ms
    optimizing	0.01 ms
    statistics	0.03 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sorting result	0.04 ms
    Sending data	0.04 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    freeing items	0.00 ms
    updating status	0.02 ms
    cleaning up	0.00 ms

    呼叫堆疊

    #	Caller	File and line number
    22	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:64
    21	DatabaseHelper->query()	JROOT/administrator/components/com_zoo/framework/classes/table.php:425
    20	AppTable->_queryObjectList()	JROOT/administrator/components/com_zoo/framework/classes/table.php:192
    19	AppTable->find()	JROOT/administrator/components/com_zoo/framework/classes/table.php:165
    18	AppTable->all()	JROOT/administrator/components/com_zoo/tables/category.php:222
    17	CategoryTable->getAll()	JROOT/administrator/components/com_zoo/classes/application.php:425
    16	Application->getCategories()	JROOT/administrator/components/com_zoo/classes/application.php:449
    15	Application->getCategoryTree()	JROOT/modules/mod_zoocategory/mod_zoocategory.php:36
    14	include JROOT/modules/mod_zoocategory/mod_zoocategory.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    13	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    12	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/yoo_master2/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
    11	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/yoo_master2/layouts/theme.config.php:72
    10	include JROOT/templates/yoo_master2/layouts/theme.config.php	JROOT/templates/yoo_master2/layouts/theme.php:10
    9	include JROOT/templates/yoo_master2/layouts/theme.php	JROOT/templates/yoo_master2/warp/src/Warp/Helper/TemplateHelper.php:49
    8	Warp\Helper\TemplateHelper->render()	JROOT/templates/yoo_master2/index.php:16
    7	require JROOT/templates/yoo_master2/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
    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:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

31. 查詢時間: 0.13 ms 最後的查詢: 0.73 ms 之後 查詢記憶體: 0.033 MB 記憶體於查詢: 4.765 MB 前 回傳的列: 0
    重覆查詢: #34

    SELECT * 
      FROM c6rhi_zoo_item 
      WHERE id = 0

    說明

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

    側寫

    Status	Duration
    starting	0.01 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    Table lock	0.00 ms
    init	0.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.00 ms
    executing	0.01 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    freeing items	0.00 ms
    updating status	0.01 ms
    cleaning up	0.00 ms

    呼叫堆疊

    #	Caller	File and line number
    21	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:64
    20	DatabaseHelper->query()	JROOT/administrator/components/com_zoo/framework/classes/table.php:399
    19	AppTable->_queryObject()	JROOT/administrator/components/com_zoo/framework/classes/table.php:189
    18	AppTable->find()	JROOT/administrator/components/com_zoo/framework/classes/table.php:136
    17	AppTable->get()	JROOT/modules/mod_zoocategory/helper.php:21
    16	CategoryModuleHelper->render()	JROOT/modules/mod_zoocategory/tmpl/flatlist.php:15
    15	include JROOT/modules/mod_zoocategory/tmpl/flatlist.php	JROOT/modules/mod_zoocategory/mod_zoocategory.php:38
    14	include JROOT/modules/mod_zoocategory/mod_zoocategory.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    13	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    12	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/yoo_master2/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
    11	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/yoo_master2/layouts/theme.config.php:72
    10	include JROOT/templates/yoo_master2/layouts/theme.config.php	JROOT/templates/yoo_master2/layouts/theme.php:10
    9	include JROOT/templates/yoo_master2/layouts/theme.php	JROOT/templates/yoo_master2/warp/src/Warp/Helper/TemplateHelper.php:49
    8	Warp\Helper\TemplateHelper->render()	JROOT/templates/yoo_master2/index.php:16
    7	require JROOT/templates/yoo_master2/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
    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:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

32. 查詢時間: 0.12 ms 最後的查詢: 1.37 ms 之後 查詢記憶體: 0.030 MB 記憶體於查詢: 4.864 MB 前 回傳的列: 1

    SELECT * 
      FROM c6rhi_zoo_application 
      WHERE id = 7

    說明

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	c6rhi_zoo_application	const	PRIMARY	PRIMARY	4	const	1

    側寫

    Status	Duration
    starting	0.01 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    Table lock	0.00 ms
    init	0.01 ms
    optimizing	0.00 ms
    statistics	0.01 ms
    preparing	0.00 ms
    Unlocking tables	0.00 ms
    executing	0.00 ms
    Sending data	0.01 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    freeing items	0.00 ms
    updating status	0.01 ms
    cleaning up	0.00 ms

    呼叫堆疊

    #	Caller	File and line number
    20	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:64
    19	DatabaseHelper->query()	JROOT/administrator/components/com_zoo/framework/classes/table.php:399
    18	AppTable->_queryObject()	JROOT/administrator/components/com_zoo/framework/classes/table.php:189
    17	AppTable->find()	JROOT/administrator/components/com_zoo/tables/application.php:131
    16	ApplicationTable->find()	JROOT/administrator/components/com_zoo/framework/classes/table.php:136
    15	AppTable->get()	JROOT/modules/mod_zoocategory/mod_zoocategory.php:31
    14	include JROOT/modules/mod_zoocategory/mod_zoocategory.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    13	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    12	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/yoo_master2/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
    11	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/yoo_master2/layouts/theme.config.php:72
    10	include JROOT/templates/yoo_master2/layouts/theme.config.php	JROOT/templates/yoo_master2/layouts/theme.php:10
    9	include JROOT/templates/yoo_master2/layouts/theme.php	JROOT/templates/yoo_master2/warp/src/Warp/Helper/TemplateHelper.php:49
    8	Warp\Helper\TemplateHelper->render()	JROOT/templates/yoo_master2/index.php:16
    7	require JROOT/templates/yoo_master2/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
    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:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

33. 查詢時間: 0.21 ms 最後的查詢: 0.47 ms 之後 查詢記憶體: 0.034 MB 記憶體於查詢: 4.891 MB 前 回傳的列: 12

    SELECT * 
      FROM c6rhi_zoo_category 
      WHERE application_id = 7 
      AND published = 1 
      ORDER BY ordering

    說明

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	c6rhi_zoo_category	ref	APPLICATIONID_ID_INDEX2,published	APPLICATIONID_ID_INDEX2	4	const	12	Using where; Using filesort

    側寫

    Status	Duration
    starting	0.01 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    Table lock	0.00 ms
    init	0.01 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sorting result	0.03 ms
    Sending data	0.03 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    freeing items	0.00 ms
    updating status	0.01 ms
    cleaning up	0.00 ms

    呼叫堆疊

    #	Caller	File and line number
    22	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:64
    21	DatabaseHelper->query()	JROOT/administrator/components/com_zoo/framework/classes/table.php:425
    20	AppTable->_queryObjectList()	JROOT/administrator/components/com_zoo/framework/classes/table.php:192
    19	AppTable->find()	JROOT/administrator/components/com_zoo/framework/classes/table.php:165
    18	AppTable->all()	JROOT/administrator/components/com_zoo/tables/category.php:222
    17	CategoryTable->getAll()	JROOT/administrator/components/com_zoo/classes/application.php:425
    16	Application->getCategories()	JROOT/administrator/components/com_zoo/classes/application.php:449
    15	Application->getCategoryTree()	JROOT/modules/mod_zoocategory/mod_zoocategory.php:36
    14	include JROOT/modules/mod_zoocategory/mod_zoocategory.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    13	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    12	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/yoo_master2/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
    11	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/yoo_master2/layouts/theme.config.php:72
    10	include JROOT/templates/yoo_master2/layouts/theme.config.php	JROOT/templates/yoo_master2/layouts/theme.php:10
    9	include JROOT/templates/yoo_master2/layouts/theme.php	JROOT/templates/yoo_master2/warp/src/Warp/Helper/TemplateHelper.php:49
    8	Warp\Helper\TemplateHelper->render()	JROOT/templates/yoo_master2/index.php:16
    7	require JROOT/templates/yoo_master2/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
    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:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

34. 查詢時間: 0.12 ms 最後的查詢: 0.31 ms 之後 查詢記憶體: 0.033 MB 記憶體於查詢: 4.929 MB 前 回傳的列: 0
    重覆查詢: #31

    SELECT * 
      FROM c6rhi_zoo_item 
      WHERE id = 0

    說明

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

    側寫

    Status	Duration
    starting	0.01 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    Table lock	0.00 ms
    init	0.01 ms
    optimizing	0.00 ms
    statistics	0.01 ms
    preparing	0.00 ms
    executing	0.01 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    freeing items	0.00 ms
    updating status	0.01 ms
    cleaning up	0.00 ms

    呼叫堆疊

    #	Caller	File and line number
    21	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:64
    20	DatabaseHelper->query()	JROOT/administrator/components/com_zoo/framework/classes/table.php:399
    19	AppTable->_queryObject()	JROOT/administrator/components/com_zoo/framework/classes/table.php:189
    18	AppTable->find()	JROOT/administrator/components/com_zoo/framework/classes/table.php:136
    17	AppTable->get()	JROOT/modules/mod_zoocategory/helper.php:21
    16	CategoryModuleHelper->render()	JROOT/modules/mod_zoocategory/tmpl/flatlist.php:15
    15	include JROOT/modules/mod_zoocategory/tmpl/flatlist.php	JROOT/modules/mod_zoocategory/mod_zoocategory.php:38
    14	include JROOT/modules/mod_zoocategory/mod_zoocategory.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    13	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    12	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/yoo_master2/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
    11	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/yoo_master2/layouts/theme.config.php:72
    10	include JROOT/templates/yoo_master2/layouts/theme.config.php	JROOT/templates/yoo_master2/layouts/theme.php:10
    9	include JROOT/templates/yoo_master2/layouts/theme.php	JROOT/templates/yoo_master2/warp/src/Warp/Helper/TemplateHelper.php:49
    8	Warp\Helper\TemplateHelper->render()	JROOT/templates/yoo_master2/index.php:16
    7	require JROOT/templates/yoo_master2/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
    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:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

35. 查詢時間: 0.16 ms 最後的查詢: 1.82 ms 之後 查詢記憶體: 0.039 MB 記憶體於查詢: 4.970 MB 前 回傳的列: 0
    重覆查詢: #39  #41  #44  #79  #81  #84  #87  #91

    SELECT *
    
      FROM c6rhi_banners
    
      WHERE '2024-10-12 13:30:34' >= 'reset' 
      AND `reset` != '0000-00-00 00:00:00' 
      AND `reset`!= NULL 
      AND (`checked_out` = 0 OR `checked_out` = 0)

    說明

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	Impossible WHERE

    側寫

    Status	Duration
    starting	0.02 ms
    checking permissions	0.00 ms
    Opening tables	0.02 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    Table lock	0.00 ms
    init	0.02 ms
    optimizing	0.01 ms
    executing	0.01 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    freeing items	0.00 ms
    updating status	0.01 ms
    cleaning up	0.00 ms

    呼叫堆疊

    #	Caller	File and line number
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    16	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_banners/helpers/banners.php:79
    15	BannersHelper::updateReset()	JROOT/modules/mod_banners/mod_banners.php:19
    14	include JROOT/modules/mod_banners/mod_banners.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    13	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    12	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/yoo_master2/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
    11	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/yoo_master2/layouts/theme.config.php:72
    10	include JROOT/templates/yoo_master2/layouts/theme.config.php	JROOT/templates/yoo_master2/layouts/theme.php:10
    9	include JROOT/templates/yoo_master2/layouts/theme.php	JROOT/templates/yoo_master2/warp/src/Warp/Helper/TemplateHelper.php:49
    8	Warp\Helper\TemplateHelper->render()	JROOT/templates/yoo_master2/index.php:16
    7	require JROOT/templates/yoo_master2/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
    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:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

36. 查詢時間: 0.34 ms 最後的查詢: 0.39 ms 之後 查詢記憶體: 0.030 MB 記憶體於查詢: 4.992 MB 前 回傳的列: 1

    SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.description as description,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
    
      FROM c6rhi_banners as a
    
      LEFT JOIN c6rhi_banner_clients AS cl 
      ON cl.id = a.cid
    
      WHERE a.state=1 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-10-12 13:30:34') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-10-12 13:30:34') 
      AND (a.imptotal = 0 OR a.impmade <= a.imptotal) 
      AND a.catid IN (17)
    
      ORDER BY a.sticky DESC,a.ordering 
      LIMIT 5

    說明

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a	ref	idx_state,idx_banner_catid	idx_banner_catid	4	const	1	Using where; Using filesort
    1	SIMPLE	cl	eq_ref	PRIMARY	PRIMARY	4	c1_supermami_prod.a.cid	1

    側寫

    Status	Duration
    starting	0.05 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.02 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    Table lock	0.00 ms
    init	0.02 ms
    optimizing	0.04 ms
    statistics	0.04 ms
    preparing	0.02 ms
    executing	0.00 ms
    Sorting result	0.03 ms
    Sending data	0.03 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    freeing items	0.00 ms
    updating status	0.01 ms
    cleaning up	0.00 ms

    呼叫堆疊

    #	Caller	File and line number
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    19	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    18	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
    17	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_banners/models/banners.php:205
    16	BannersModelBanners->getItems()	JROOT/modules/mod_banners/helper.php:44
    15	ModBannersHelper::getList()	JROOT/modules/mod_banners/mod_banners.php:20
    14	include JROOT/modules/mod_banners/mod_banners.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    13	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    12	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/yoo_master2/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
    11	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/yoo_master2/layouts/theme.config.php:72
    10	include JROOT/templates/yoo_master2/layouts/theme.config.php	JROOT/templates/yoo_master2/layouts/theme.php:10
    9	include JROOT/templates/yoo_master2/layouts/theme.php	JROOT/templates/yoo_master2/warp/src/Warp/Helper/TemplateHelper.php:49
    8	Warp\Helper\TemplateHelper->render()	JROOT/templates/yoo_master2/index.php:16
    7	require JROOT/templates/yoo_master2/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
    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:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

37. 查詢時間: 0.94 ms 最後的查詢: 0.06 ms 之後 查詢記憶體: 0.009 MB 記憶體於查詢: 5.009 MB 前

    UPDATE c6rhi_banners
    
      SET impmade = (impmade + 1)
    
      WHERE id IN (27)

    說明

    EXPLAIN 無法被使用於查詢: UPDATE c6rhi_banners SET impmade = (impmade + 1) WHERE id IN (27)

    側寫

    Status	Duration
    starting	0.02 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.01 ms
    Table lock	0.00 ms
    init	0.02 ms
    updating	0.03 ms
    end	0.00 ms
    Waiting for query cache lock	0.00 ms
    end	0.00 ms
    query end	0.79 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    freeing items	0.00 ms
    updating status	0.01 ms
    cleaning up	0.00 ms

    呼叫堆疊

    #	Caller	File and line number
    17	JDatabaseDriverMysqli->execute()	JROOT/components/com_banners/models/banners.php:249
    16	BannersModelBanners->impress()	JROOT/modules/mod_banners/helper.php:48
    15	ModBannersHelper::getList()	JROOT/modules/mod_banners/mod_banners.php:20
    14	include JROOT/modules/mod_banners/mod_banners.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    13	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    12	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/yoo_master2/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
    11	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/yoo_master2/layouts/theme.config.php:72
    10	include JROOT/templates/yoo_master2/layouts/theme.config.php	JROOT/templates/yoo_master2/layouts/theme.php:10
    9	include JROOT/templates/yoo_master2/layouts/theme.php	JROOT/templates/yoo_master2/warp/src/Warp/Helper/TemplateHelper.php:49
    8	Warp\Helper\TemplateHelper->render()	JROOT/templates/yoo_master2/index.php:16
    7	require JROOT/templates/yoo_master2/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
    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:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

38. 查詢時間: 0.16 ms 最後的查詢: 0.04 ms 之後 查詢記憶體: 0.009 MB 記憶體於查詢: 5.019 MB 前

    UPDATE c6rhi_banner_tracks
    
      SET `count` = (`count` + 1)
    
      WHERE track_type=1 
      AND banner_id=27 
      AND track_date='2024-10-12 13'

    說明

    EXPLAIN 無法被使用於查詢: UPDATE c6rhi_banner_tracks SET `count` = (`count` + 1) WHERE track_type=1 AND banner_id=27 AND track_date='2024-10-12 13'

    側寫

    Status	Duration
    starting	0.02 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    Table lock	0.00 ms
    init	0.04 ms
    updating	0.02 ms
    end	0.00 ms
    Waiting for query cache lock	0.00 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Waiting for query cache lock	0.00 ms
    Unlocking tables	0.01 ms
    freeing items	0.00 ms
    updating status	0.01 ms
    cleaning up	0.00 ms

    呼叫堆疊

    #	Caller	File and line number
    17	JDatabaseDriverMysqli->execute()	JROOT/components/com_banners/models/banners.php:287
    16	BannersModelBanners->impress()	JROOT/modules/mod_banners/helper.php:48
    15	ModBannersHelper::getList()	JROOT/modules/mod_banners/mod_banners.php:20
    14	include JROOT/modules/mod_banners/mod_banners.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    13	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    12	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/yoo_master2/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
    11	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/yoo_master2/layouts/theme.config.php:72
    10	include JROOT/templates/yoo_master2/layouts/theme.config.php	JROOT/templates/yoo_master2/layouts/theme.php:10
    9	include JROOT/templates/yoo_master2/layouts/theme.php	JROOT/templates/yoo_master2/warp/src/Warp/Helper/TemplateHelper.php:49
    8	Warp\Helper\TemplateHelper->render()	JROOT/templates/yoo_master2/index.php:16
    7	require JROOT/templates/yoo_master2/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
    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:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

39. 查詢時間: 0.14 ms 最後的查詢: 0.35 ms 之後 查詢記憶體: 0.039 MB 記憶體於查詢: 5.023 MB 前 回傳的列: 0
    重覆查詢: #35  #41  #44  #79  #81  #84  #87  #91

    SELECT *
    
      FROM c6rhi_banners
    
      WHERE '2024-10-12 13:30:34' >= 'reset' 
      AND `reset` != '0000-00-00 00:00:00' 
      AND `reset`!= NULL 
      AND (`checked_out` = 0 OR `checked_out` = 0)

    說明

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	Impossible WHERE

    側寫

    Status	Duration
    starting	0.02 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    Table lock	0.00 ms
    init	0.02 ms
    optimizing	0.01 ms
    executing	0.02 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    freeing items	0.00 ms
    updating status	0.01 ms
    cleaning up	0.01 ms

    呼叫堆疊

    #	Caller	File and line number
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    16	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_banners/helpers/banners.php:79
    15	BannersHelper::updateReset()	JROOT/modules/mod_banners/mod_banners.php:19
    14	include JROOT/modules/mod_banners/mod_banners.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    13	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    12	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/yoo_master2/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
    11	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/yoo_master2/layouts/theme.config.php:72
    10	include JROOT/templates/yoo_master2/layouts/theme.config.php	JROOT/templates/yoo_master2/layouts/theme.php:10
    9	include JROOT/templates/yoo_master2/layouts/theme.php	JROOT/templates/yoo_master2/warp/src/Warp/Helper/TemplateHelper.php:49
    8	Warp\Helper\TemplateHelper->render()	JROOT/templates/yoo_master2/index.php:16
    7	require JROOT/templates/yoo_master2/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
    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:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

40. 查詢時間: 0.24 ms 最後的查詢: 0.08 ms 之後 查詢記憶體: 0.030 MB 記憶體於查詢: 5.037 MB 前 回傳的列: 0

    SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.description as description,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
    
      FROM c6rhi_banners as a
    
      LEFT JOIN c6rhi_banner_clients AS cl 
      ON cl.id = a.cid
    
      WHERE a.state=1 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-10-12 13:30:34') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-10-12 13:30:34') 
      AND (a.imptotal = 0 OR a.impmade <= a.imptotal) 
      AND a.catid IN (21)
    
      ORDER BY a.sticky DESC,a.ordering 
      LIMIT 5

    說明

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a	ref	idx_state,idx_banner_catid	idx_banner_catid	4	const	1	Using where; Using filesort
    1	SIMPLE	cl	eq_ref	PRIMARY	PRIMARY	4	c1_supermami_prod.a.cid	1

    側寫

    Status	Duration
    starting	0.04 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    Table lock	0.00 ms
    init	0.02 ms
    optimizing	0.01 ms
    statistics	0.03 ms
    preparing	0.02 ms
    executing	0.00 ms
    Sorting result	0.02 ms
    Sending data	0.01 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.01 ms
    Unlocking tables	0.00 ms
    freeing items	0.00 ms
    updating status	0.01 ms
    cleaning up	0.00 ms

    呼叫堆疊

    #	Caller	File and line number
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    19	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    18	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
    17	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_banners/models/banners.php:205
    16	BannersModelBanners->getItems()	JROOT/modules/mod_banners/helper.php:44
    15	ModBannersHelper::getList()	JROOT/modules/mod_banners/mod_banners.php:20
    14	include JROOT/modules/mod_banners/mod_banners.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    13	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    12	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/yoo_master2/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
    11	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/yoo_master2/layouts/theme.config.php:72
    10	include JROOT/templates/yoo_master2/layouts/theme.config.php	JROOT/templates/yoo_master2/layouts/theme.php:10
    9	include JROOT/templates/yoo_master2/layouts/theme.php	JROOT/templates/yoo_master2/warp/src/Warp/Helper/TemplateHelper.php:49
    8	Warp\Helper\TemplateHelper->render()	JROOT/templates/yoo_master2/index.php:16
    7	require JROOT/templates/yoo_master2/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
    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:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

41. 查詢時間: 0.16 ms 最後的查詢: 0.56 ms 之後 查詢記憶體: 0.039 MB 記憶體於查詢: 5.052 MB 前 回傳的列: 0
    重覆查詢: #35  #39  #44  #79  #81  #84  #87  #91

    SELECT *
    
      FROM c6rhi_banners
    
      WHERE '2024-10-12 13:30:34' >= 'reset' 
      AND `reset` != '0000-00-00 00:00:00' 
      AND `reset`!= NULL 
      AND (`checked_out` = 0 OR `checked_out` = 0)

    說明

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	Impossible WHERE

    側寫

    Status	Duration
    starting	0.02 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    Table lock	0.00 ms
    init	0.03 ms
    optimizing	0.01 ms
    executing	0.01 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    freeing items	0.00 ms
    updating status	0.01 ms
    cleaning up	0.00 ms

    呼叫堆疊

    #	Caller	File and line number
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    16	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_banners/helpers/banners.php:79
    15	BannersHelper::updateReset()	JROOT/modules/mod_banners/mod_banners.php:19
    14	include JROOT/modules/mod_banners/mod_banners.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    13	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    12	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/yoo_master2/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
    11	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/yoo_master2/layouts/theme.config.php:72
    10	include JROOT/templates/yoo_master2/layouts/theme.config.php	JROOT/templates/yoo_master2/layouts/theme.php:10
    9	include JROOT/templates/yoo_master2/layouts/theme.php	JROOT/templates/yoo_master2/warp/src/Warp/Helper/TemplateHelper.php:49
    8	Warp\Helper\TemplateHelper->render()	JROOT/templates/yoo_master2/index.php:16
    7	require JROOT/templates/yoo_master2/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
    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:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

42. 查詢時間: 0.56 ms 最後的查詢: 0.08 ms 之後 查詢記憶體: 0.030 MB 記憶體於查詢: 5.066 MB 前 回傳的列: 0

    SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.description as description,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
    
      FROM c6rhi_banners as a
    
      LEFT JOIN c6rhi_banner_clients AS cl 
      ON cl.id = a.cid
    
      WHERE a.state=1 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-10-12 13:30:34') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-10-12 13:30:34') 
      AND (a.imptotal = 0 OR a.impmade <= a.imptotal) 
      AND a.catid IN (18)
    
      ORDER BY a.sticky DESC, RAND()  
      LIMIT 1

    說明

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a	index_merge	idx_state,idx_banner_catid	idx_banner_catid,idx_state	4,1	NULL	12	Using intersect(idx_banner_catid,idx_state); Using where; Using temporary; Using filesort
    1	SIMPLE	cl	eq_ref	PRIMARY	PRIMARY	4	c1_supermami_prod.a.cid	1

    側寫

    Status	Duration
    starting	0.04 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    Table lock	0.00 ms
    init	0.01 ms
    optimizing	0.01 ms
    statistics	0.03 ms
    preparing	0.03 ms
    executing	0.00 ms
    Creating tmp table	0.15 ms
    Copying to tmp table	0.13 ms
    Sorting result	0.02 ms
    Sending data	0.01 ms
    end	0.01 ms
    removing tmp table	0.05 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.01 ms
    cleaning up	0.00 ms

    呼叫堆疊

    #	Caller	File and line number
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    19	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    18	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
    17	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_banners/models/banners.php:205
    16	BannersModelBanners->getItems()	JROOT/modules/mod_banners/helper.php:44
    15	ModBannersHelper::getList()	JROOT/modules/mod_banners/mod_banners.php:20
    14	include JROOT/modules/mod_banners/mod_banners.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    13	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    12	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/yoo_master2/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
    11	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/yoo_master2/layouts/theme.config.php:72
    10	include JROOT/templates/yoo_master2/layouts/theme.config.php	JROOT/templates/yoo_master2/layouts/theme.php:10
    9	include JROOT/templates/yoo_master2/layouts/theme.php	JROOT/templates/yoo_master2/warp/src/Warp/Helper/TemplateHelper.php:49
    8	Warp\Helper\TemplateHelper->render()	JROOT/templates/yoo_master2/index.php:16
    7	require JROOT/templates/yoo_master2/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
    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:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

43. 查詢時間: 0.29 ms 最後的查詢: 3.97 ms 之後 查詢記憶體: 0.057 MB 記憶體於查詢: 5.320 MB 前 回傳的列: 286