2020-02-18, 週二
×
How to resolve AdBlock issue?
X
Joomla! 除錯主控台
{
"__default": {
"session": {
"counter": 1,
"timer": {
"start": 1581958464,
"last": 1581958464,
"now": 1581958464
},
"client": {
"forwarded": "3.234.208.66"
},
"token": "zj0AMuDBz7TgEhelCSzTVePYBqDa69Dc"
},
"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
},
"jomsocial_userip": "3.234.208.66",
"plg_system_languagefilter": {
"language": "zh-TW"
}
}
}
時間
記憶體
時間: 1.24 ms / 1.24 ms 記憶體: 0.578 MB / 0.95 MB Application: afterLoad
時間: 31.59 ms / 32.83 ms 記憶體: 3.378 MB / 4.32 MB Application: afterInitialise
時間: 12.02 ms / 44.86 ms 記憶體: 1.040 MB / 5.36 MB Application: afterRoute
時間: 0.99 ms / 45.85 ms 記憶體: 0.060 MB / 5.42 MB Application: beforeRenderComponent com_tags
時間: 28.75 ms / 74.59 ms 記憶體: 1.029 MB / 6.45 MB Application: Before Access::preloadComponents (all components)
時間: 1.17 ms / 75.76 ms 記憶體: 0.083 MB / 6.53 MB Application: After Access::preloadComponents (all components)
時間: 0.03 ms / 75.79 ms 記憶體: 0.000 MB / 6.53 MB Application: Before Access::getAssetRules (id:35 name:com_tags)
時間: 0.11 ms / 75.90 ms 記憶體: 0.009 MB / 6.54 MB Application: After Access::getAssetRules (id:35 name:com_tags)
時間: 2.10 ms / 78.00 ms 記憶體: 0.035 MB / 6.57 MB Application: afterRenderComponent com_tags
時間: 0.85 ms / 78.85 ms 記憶體: 0.078 MB / 6.65 MB Application: Before Access::getAssetRules (id:1 name:root.1)
時間: 0.03 ms / 78.88 ms 記憶體: 0.007 MB / 6.66 MB Application: After Access::getAssetRules (id:1 name:root.1)
時間: 6.89 ms / 85.77 ms 記憶體: 0.112 MB / 6.77 MB Application: beforeRenderModule mod_ijoomla_adagency_zone (In House - Desktop - Popup)
時間: 15.78 ms / 101.55 ms 記憶體: 0.225 MB / 7.00 MB Application: afterRenderModule mod_ijoomla_adagency_zone (In House - Desktop - Popup)
時間: 2.63 ms / 104.18 ms 記憶體: 0.000 MB / 6.96 MB Application: afterDispatch
時間: 154.97 ms / 259.16 ms 記憶體: 0.995 MB / 7.95 MB Application: beforeRenderModule mod_menu (Offcanvas Menu)
時間: 2.30 ms / 261.46 ms 記憶體: 0.124 MB / 8.08 MB Application: afterRenderModule mod_menu (Offcanvas Menu)
時間: 0.07 ms / 261.53 ms 記憶體: 0.001 MB / 8.08 MB Application: beforeRenderModule mod_tags_popular (熱門搜尋)
時間: 6.57 ms / 268.10 ms 記憶體: 0.039 MB / 8.12 MB Application: afterRenderModule mod_tags_popular (熱門搜尋)
時間: 0.06 ms / 268.16 ms 記憶體: 0.000 MB / 8.11 MB Application: beforeRenderModule mod_menu (Quick Link)
時間: 0.47 ms / 268.64 ms 記憶體: 0.017 MB / 8.12 MB Application: afterRenderModule mod_menu (Quick Link)
時間: 0.04 ms / 268.68 ms 記憶體: 0.000 MB / 8.12 MB Application: beforeRenderModule mod_custom (Bottom-1)
時間: 0.56 ms / 269.23 ms 記憶體: 0.007 MB / 8.13 MB Application: afterRenderModule mod_custom (Bottom-1)
時間: 0.04 ms / 269.27 ms 記憶體: 0.000 MB / 8.13 MB Application: beforeRenderModule mod_articles_popular (父母最關注)
時間: 0.67 ms / 269.94 ms 記憶體: 0.040 MB / 8.17 MB Application: Before Access::getAssetRules (id:8 name:com_content)
時間: 0.05 ms / 269.99 ms 記憶體: 0.007 MB / 8.17 MB Application: After Access::getAssetRules (id:8 name:com_content)
時間: 40.09 ms / 310.08 ms 記憶體: 0.172 MB / 8.34 MB Application: afterRenderModule mod_articles_popular (父母最關注)
時間: 0.04 ms / 310.12 ms 記憶體: 0.000 MB / 8.24 MB Application: beforeRenderModule mod_articles_popular (Top 5)
時間: 7.97 ms / 318.09 ms 記憶體: 0.147 MB / 8.39 MB Application: afterRenderModule mod_articles_popular (Top 5)
時間: 0.10 ms / 318.19 ms 記憶體: 0.000 MB / 8.28 MB Application: beforeRenderModule mod_sp_date (SP Date)
時間: 0.17 ms / 318.36 ms 記憶體: 0.007 MB / 8.28 MB Application: afterRenderModule mod_sp_date (SP Date)
時間: 0.02 ms / 318.38 ms 記憶體: 0.000 MB / 8.28 MB Application: beforeRenderModule mod_search (Search-top)
時間: 0.82 ms / 319.20 ms 記憶體: 0.015 MB / 8.30 MB Application: afterRenderModule mod_search (Search-top)
時間: 50.74 ms / 369.94 ms 記憶體: 0.143 MB / 8.44 MB Application: afterRender
資料庫查詢總計: 95.82 ms
9.42 MB (9,880,256 位元組)
66 查詢記錄 95.82 ms
- 查詢時間: 0.22 ms 查詢記憶體: 0.025 MB 記憶體於查詢: 1.278 MB 前 回傳的列: 0
SELECT `data`
FROM `byat8_session`
WHERE `session_id` = 'nfu61315sha1rkaa6iec69l6ob'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE byat8_session const PRIMARY PRIMARY 194 const 1 Status Duration starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.00 ms After table lock 0.01 ms init 0.01 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.00 ms executing 0.01 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.01 ms updating status 0.01 ms cleaning up 0.01 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 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 - 查詢時間: 0.17 ms 最後的查詢: 0.21 ms 之後 查詢記憶體: 0.022 MB 記憶體於查詢: 1.293 MB 前 回傳的列: 0
SELECT `session_id`
FROM `byat8_session`
WHERE `session_id` = 'nfu61315sha1rkaa6iec69l6ob'
LIMIT 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE byat8_session const PRIMARY PRIMARY 194 const 1 Using index Status Duration starting 0.02 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 After 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.01 ms freeing items 0.01 ms updating status 0.01 ms cleaning up 0.01 ms # Caller File and line number 9 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 8 JDatabaseDriver->loadResult() JROOT/libraries/src/Session/MetadataManager.php:74 7 Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() JROOT/libraries/src/Application/CMSApplication.php: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 - 查詢時間: 0.38 ms 最後的查詢: 0.07 ms 之後 查詢記憶體: 0.004 MB 記憶體於查詢: 1.299 MB 前
INSERT INTO `byat8_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES ('nfu61315sha1rkaa6iec69l6ob', 1, 1581958464, 0, '', 0)EXPLAIN 無法被使用於查詢: INSERT INTO `byat8_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('nfu61315sha1rkaa6iec69l6ob', 1, 1581958464, 0, '', 0)Status Duration starting 0.02 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 After table lock 0.00 ms init 0.01 ms update 0.05 ms Waiting for query cache lock 0.00 ms update 0.01 ms end 0.00 ms query end 0.19 ms closing tables 0.01 ms freeing items 0.00 ms updating status 0.01 ms cleaning up 0.01 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 - 查詢時間: 0.46 ms 最後的查詢: 0.26 ms 之後 查詢記憶體: 0.042 MB 記憶體於查詢: 1.334 MB 前 回傳的列: 62
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `byat8_extensions`
WHERE `type` = 'component'
AND `state` = 0
AND `enabled` = 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE byat8_extensions ref extension extension 82 const 68 Using index condition; Using where Status Duration starting 0.02 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 After table lock 0.00 ms init 0.01 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.02 ms executing 0.00 ms Sending data 0.21 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.00 ms updating status 0.01 ms cleaning up 0.01 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Component/ComponentHelper.php:445 10 Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}() 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 - 查詢時間: 0.17 ms 最後的查詢: 0.34 ms 之後 查詢記憶體: 0.023 MB 記憶體於查詢: 1.462 MB 前 回傳的列: 5
SELECT id, rules
FROM `byat8_viewlevels`id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE byat8_viewlevels ALL NULL NO INDEX KEY COULD BE USED NULL NULL 5 Status Duration starting 0.02 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 After 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.03 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.00 ms updating status 0.01 ms cleaning up 0.01 ms # Caller File and line number 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506 9 JDatabaseDriver->loadAssocList() JROOT/libraries/src/Access/Access.php:1063 8 Joomla\CMS\Access\Access::getAuthorisedViewLevels() JROOT/libraries/src/User/User.php:458 7 Joomla\CMS\User\User->getAuthorisedViewLevels() JROOT/libraries/src/Plugin/PluginHelper.php: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 - 查詢時間: 0.24 ms 最後的查詢: 0.07 ms 之後 查詢記憶體: 0.022 MB 記憶體於查詢: 1.474 MB 前 回傳的列: 2
SELECT b.id
FROM byat8_usergroups AS a
LEFT JOIN byat8_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 9id 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.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 After table lock 0.01 ms init 0.01 ms optimizing 0.01 ms statistics 0.03 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.01 ms freeing items 0.01 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:1550 10 JDatabaseDriver->loadColumn() JROOT/libraries/src/Access/Access.php:980 9 Joomla\CMS\Access\Access::getGroupsByUser() JROOT/libraries/src/Access/Access.php:1095 8 Joomla\CMS\Access\Access::getAuthorisedViewLevels() JROOT/libraries/src/User/User.php:458 7 Joomla\CMS\User\User->getAuthorisedViewLevels() JROOT/libraries/src/Plugin/PluginHelper.php: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 - 查詢時間: 1.39 ms 最後的查詢: 0.10 ms 之後 查詢記憶體: 0.046 MB 記憶體於查詢: 1.497 MB 前 回傳的列: 235
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM byat8_extensions
WHERE enabled = 1
AND type = 'plugin'
AND state IN (0,1)
AND access IN (1,1,5)
ORDER BY orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE byat8_extensions ref extension extension 82 const 415 Using index condition; Using where; Using filesort 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 After table lock 0.00 ms init 0.01 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.02 ms executing 0.00 ms Sorting result 0.77 ms Sending data 0.38 ms end 0.01 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.01 ms updating status 0.01 ms cleaning up 0.01 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 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 - 查詢時間: 0.29 ms 最後的查詢: 2.56 ms 之後 查詢記憶體: 0.024 MB 記憶體於查詢: 1.969 MB 前 回傳的列: 0重覆查詢: #9
SELECT `manifest_cache`
FROM `byat8_extensions`
WHERE `type` = 'component'
AND `name` = 'com_admintools'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE byat8_extensions ref extension extension 82 const 68 Using index condition; Using where Status Duration starting 0.02 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 After 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 Sending data 0.11 ms end 0.01 ms query end 0.00 ms closing 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:1740 13 JDatabaseDriver->loadResult() JROOT/libraries/fof30/Container/Container.php:795 12 FOF30\Container\Container->getDefaultMediaVersion() JROOT/libraries/fof30/Container/Container.php:683 11 FOF30\Container\Container->__construct() JROOT/libraries/fof30/Container/Container.php:162 10 FOF30\Container\Container::makeInstance() JROOT/libraries/fof30/Container/Container.php:143 9 FOF30\Container\Container::getInstance() JROOT/plugins/system/admintools/admintools/main.php:813 8 plgSystemAdmintools->initialize() JROOT/plugins/system/admintools/admintools/main.php:110 7 plgSystemAdmintools->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:283 6 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 5 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/libraries/src/Application/CMSApplication.php:625 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 - 查詢時間: 0.31 ms 最後的查詢: 0.93 ms 之後 查詢記憶體: 0.024 MB 記憶體於查詢: 2.060 MB 前 回傳的列: 0重覆查詢: #8
SELECT `manifest_cache`
FROM `byat8_extensions`
WHERE `type` = 'component'
AND `name` = 'com_admintools'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE byat8_extensions ref extension extension 82 const 68 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 After 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 Sending data 0.14 ms end 0.01 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.00 ms updating status 0.01 ms cleaning up 0.01 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 13 JDatabaseDriver->loadResult() JROOT/libraries/fof30/Container/Container.php:795 12 FOF30\Container\Container->getDefaultMediaVersion() JROOT/libraries/fof30/Container/Container.php:683 11 FOF30\Container\Container->__construct() JROOT/libraries/fof30/Container/Container.php:293 10 FOF30\Container\Container::makeInstance() JROOT/libraries/fof30/Container/Container.php:143 9 FOF30\Container\Container::getInstance() JROOT/plugins/system/admintools/admintools/main.php:813 8 plgSystemAdmintools->initialize() JROOT/plugins/system/admintools/admintools/main.php:110 7 plgSystemAdmintools->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:283 6 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 5 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/libraries/src/Application/CMSApplication.php:625 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 - 查詢時間: 0.17 ms 最後的查詢: 0.08 ms 之後 查詢記憶體: 0.024 MB 記憶體於查詢: 2.067 MB 前 回傳的列: 1
SELECT `value`
FROM `byat8_admintools_storage`
WHERE `key` = 'cparams'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE byat8_admintools_storage const PRIMARY PRIMARY 402 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 After 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.01 ms end 0.00 ms query end 0.00 ms closing 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:1740 13 JDatabaseDriver->loadResult() JROOT/administrator/components/com_admintools/Helper/Storage.php:123 12 Akeeba\AdminTools\Admin\Helper\Storage->load() JROOT/administrator/components/com_admintools/Helper/Storage.php:53 11 Akeeba\AdminTools\Admin\Helper\Storage->__construct() JROOT/administrator/components/com_admintools/Helper/Storage.php:41 10 Akeeba\AdminTools\Admin\Helper\Storage::getInstance() JROOT/plugins/system/admintools/admintools/main.php:278 9 plgSystemAdmintools->loadComponentParameters() JROOT/plugins/system/admintools/admintools/main.php:831 8 plgSystemAdmintools->initialize() JROOT/plugins/system/admintools/admintools/main.php:110 7 plgSystemAdmintools->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:283 6 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 5 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/libraries/src/Application/CMSApplication.php:625 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 - 查詢時間: 0.20 ms 最後的查詢: 0.30 ms 之後 查詢記憶體: 0.027 MB 記憶體於查詢: 2.103 MB 前 回傳的列: 1
SELECT *
FROM byat8_languages
WHERE published=1
ORDER BY ordering ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE byat8_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.01 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.00 ms After 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 Sorting result 0.02 ms Sending data 0.02 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.00 ms updating status 0.01 ms cleaning up 0.00 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 12 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Language/LanguageHelper.php:150 11 Joomla\CMS\Language\LanguageHelper::getLanguages() JROOT/plugins/system/admintools/admintools/main.php:520 10 plgSystemAdmintools->loadWAFExceptionsSEF() JROOT/plugins/system/admintools/admintools/main.php:460 9 plgSystemAdmintools->loadWAFExceptions() JROOT/plugins/system/admintools/admintools/main.php:843 8 plgSystemAdmintools->initialize() JROOT/plugins/system/admintools/admintools/main.php:110 7 plgSystemAdmintools->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:283 6 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 5 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/libraries/src/Application/CMSApplication.php:625 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 - 查詢時間: 0.75 ms 最後的查詢: 0.07 ms 之後 查詢記憶體: 0.024 MB 記憶體於查詢: 2.112 MB 前 回傳的列: 0
SELECT *
FROM `byat8_admintools_wafexceptions`
WHERE NOT(`option` LIKE 'com_%')id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE byat8_admintools_wafexceptions ALL NULL NO INDEX KEY COULD BE USED NULL NULL 1 Using where Status Duration starting 0.02 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 After table lock 0.02 ms init 0.02 ms optimizing 0.01 ms statistics 0.01 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.01 ms freeing items 0.00 ms updating status 0.56 ms cleaning up 0.01 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506 11 JDatabaseDriver->loadAssocList() JROOT/plugins/system/admintools/admintools/main.php:549 10 plgSystemAdmintools->loadWAFExceptionsSEF() JROOT/plugins/system/admintools/admintools/main.php:460 9 plgSystemAdmintools->loadWAFExceptions() JROOT/plugins/system/admintools/admintools/main.php:843 8 plgSystemAdmintools->initialize() JROOT/plugins/system/admintools/admintools/main.php:110 7 plgSystemAdmintools->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:283 6 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 5 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/libraries/src/Application/CMSApplication.php:625 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 - 查詢時間: 0.24 ms 最後的查詢: 5.15 ms 之後 查詢記憶體: 0.023 MB 記憶體於查詢: 2.780 MB 前 回傳的列: 6
SELECT `element`,`name`,`client_id`,`extension_id`
FROM `byat8_extensions`
WHERE `type` = 'language'
AND `state` = 0
AND `enabled` = 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE byat8_extensions ref extension extension 82 const 6 Using index condition; Using where Status Duration starting 0.02 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 After table lock 0.01 ms init 0.01 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.01 ms executing 0.00 ms Sending data 0.03 ms end 0.01 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.01 ms updating status 0.01 ms cleaning up 0.01 ms # Caller File and line number 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 9 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Language/LanguageHelper.php:209 8 Joomla\CMS\Language\LanguageHelper::getInstalledLanguages() JROOT/plugins/system/languagefilter/languagefilter.php:110 7 PlgSystemLanguageFilter->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:283 6 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 5 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/libraries/src/Application/CMSApplication.php:625 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 - 查詢時間: 0.40 ms 最後的查詢: 3.30 ms 之後 查詢記憶體: 0.023 MB 記憶體於查詢: 2.825 MB 前 回傳的列: 1
SHOW VARIABLES LIKE "collation_database"
EXPLAIN 無法被使用於查詢: SHOW VARIABLES LIKE "collation_database"Status Duration starting 0.02 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.00 ms Table lock 0.00 ms After 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 Filling schema table 0.17 ms executing 0.00 ms Sending data 0.01 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms removing tmp table 0.01 ms closing tables 0.00 ms freeing items 0.00 ms updating status 0.01 ms cleaning up 0.01 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 12 JDatabaseDriver->loadObject() JROOT/libraries/joomla/database/driver/mysqli.php:342 11 JDatabaseDriverMysqli->getCollation() JROOT/plugins/system/admintools/feature/utf8mb4.php:28 10 AtsystemFeatureUtf8mb4->onAfterInitialise() JROOT/plugins/system/admintools/admintools/main.php:710 9 plgSystemAdmintools->runFeature() JROOT/plugins/system/admintools/admintools/main.php:135 8 plgSystemAdmintools->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 - 查詢時間: 0.17 ms 最後的查詢: 0.11 ms 之後 查詢記憶體: 0.024 MB 記憶體於查詢: 2.834 MB 前 回傳的列: 0
SELECT *
FROM `byat8_admintools_ipautoban`
WHERE `ip` = '3.234.208.66'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.02 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 After table lock 0.01 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.01 ms freeing items 0.00 ms updating status 0.01 ms cleaning up 0.01 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 12 JDatabaseDriver->loadObject() JROOT/plugins/system/admintools/feature/autoipfiltering.php:74 11 AtsystemFeatureAutoipfiltering->isIPBlocked() JROOT/plugins/system/admintools/feature/autoipfiltering.php:23 10 AtsystemFeatureAutoipfiltering->onAfterInitialise() JROOT/plugins/system/admintools/admintools/main.php:710 9 plgSystemAdmintools->runFeature() JROOT/plugins/system/admintools/admintools/main.php:135 8 plgSystemAdmintools->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 - 查詢時間: 0.18 ms 最後的查詢: 0.05 ms 之後 查詢記憶體: 0.023 MB 記憶體於查詢: 2.839 MB 前 回傳的列: 2
SELECT `ip`
FROM `byat8_admintools_ipblock`id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE byat8_admintools_ipblock ALL NULL NO INDEX KEY COULD BE USED NULL NULL 2 Status Duration starting 0.02 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 After 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 Sending data 0.02 ms end 0.01 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.00 ms updating status 0.01 ms cleaning up 0.01 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 12 JDatabaseDriver->loadColumn() JROOT/plugins/system/admintools/feature/ipblacklist.php:139 11 AtsystemFeatureIpblacklist->isIPBlocked() JROOT/plugins/system/admintools/feature/ipblacklist.php:33 10 AtsystemFeatureIpblacklist->onAfterInitialise() JROOT/plugins/system/admintools/admintools/main.php:710 9 plgSystemAdmintools->runFeature() JROOT/plugins/system/admintools/admintools/main.php:135 8 plgSystemAdmintools->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 - 查詢時間: 0.22 ms 最後的查詢: 0.06 ms 之後 查詢記憶體: 0.024 MB 記憶體於查詢: 2.847 MB 前 回傳的列: 1
SELECT *
FROM `byat8_admintools_storage`
WHERE `key` LIKE 'timestamp_%'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE byat8_admintools_storage range PRIMARY PRIMARY 402 NULL 1 Using where Status Duration starting 0.02 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 After table lock 0.01 ms init 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.01 ms executing 0.00 ms Sending data 0.02 ms end 0.03 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.00 ms updating status 0.01 ms cleaning up 0.01 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506 13 JDatabaseDriver->loadAssocList() JROOT/plugins/system/admintools/feature/abstract.php:269 12 AtsystemFeatureAbstract->loadTimestamps() JROOT/plugins/system/admintools/feature/abstract.php:349 11 AtsystemFeatureAbstract->getTimestamp() JROOT/plugins/system/admintools/feature/disableobsoleteadmins.php:113 10 AtsystemFeatureDisableobsoleteadmins->onAfterInitialise() JROOT/plugins/system/admintools/admintools/main.php:710 9 plgSystemAdmintools->runFeature() JROOT/plugins/system/admintools/admintools/main.php:135 8 plgSystemAdmintools->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 - 查詢時間: 0.20 ms 最後的查詢: 0.20 ms 之後 查詢記憶體: 0.023 MB 記憶體於查詢: 2.857 MB 前 回傳的列: 0
SELECT `source`,`keepurlparams`
FROM `byat8_admintools_redirects`
WHERE ((`dest` = 'index.php/zh/component/tags/tag/%E6%84%8F%E5%A4%96') OR (`dest` = 'index.php/zh/component/tags/tag/%E6%84%8F%E5%A4%96') OR ('index.php/zh/component/tags/tag/%E6%84%8F%E5%A4%96' LIKE `dest`))
AND `published` = '1'
ORDER BY `ordering` DESC
LIMIT 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE byat8_admintools_redirects ALL NULL NO INDEX KEY COULD BE USED NULL NULL 1 Using where; Using filesort Status Duration starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.00 ms Table lock 0.00 ms After 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.01 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.01 ms updating status 0.01 ms cleaning up 0.01 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1773 11 JDatabaseDriver->loadRow() JROOT/plugins/system/admintools/feature/urlredir.php:89 10 AtsystemFeatureUrlredir->onAfterInitialise() JROOT/plugins/system/admintools/admintools/main.php:710 9 plgSystemAdmintools->runFeature() JROOT/plugins/system/admintools/admintools/main.php:135 8 plgSystemAdmintools->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 - 查詢時間: 0.25 ms 最後的查詢: 0.69 ms 之後 查詢記憶體: 0.028 MB 記憶體於查詢: 3.077 MB 前 回傳的列: 1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `byat8_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE byat8_extensions ref element_clientid,element_folder_clientid,extension extension 484 const,const 1 Using index condition Status Duration starting 0.02 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.01 ms After table lock 0.01 ms init 0.01 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.01 ms executing 0.00 ms Sending data 0.03 ms end 0.01 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.01 ms updating status 0.01 ms cleaning up 0.01 ms # Caller File and line number 21 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 20 JDatabaseDriver->loadObject() JROOT/libraries/src/Helper/LibraryHelper.php:167 19 Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}() Same as call in the line below. 18 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 17 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/LibraryHelper.php:175 16 Joomla\CMS\Helper\LibraryHelper::loadLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:43 15 Joomla\CMS\Helper\LibraryHelper::getLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:90 14 Joomla\CMS\Helper\LibraryHelper::getParams() JROOT/libraries/src/Version.php:321 13 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 12 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 11 Joomla\CMS\Factory::getDocument() JROOT/administrator/components/com_hikashop/helpers/helper.php:2751 10 include_once JROOT/administrator/components/com_hikashop/helpers/helper.php JROOT/plugins/system/hikashopgeolocation/hikashopgeolocation.php:168 9 plgSystemHikashopgeolocation->process() JROOT/plugins/system/hikashopgeolocation/hikashopgeolocation.php:57 8 plgSystemHikashopgeolocation->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 - 查詢時間: 2.35 ms 最後的查詢: 0.14 ms 之後 查詢記憶體: 0.007 MB 記憶體於查詢: 3.070 MB 前
UPDATE `byat8_extensions`
SET `params` = '{\"mediaversion\":\"f4b9b9561b1c3e0bfc071c8c82025d28\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'EXPLAIN 無法被使用於查詢: UPDATE `byat8_extensions` SET `params` = '{\"mediaversion\":\"f4b9b9561b1c3e0bfc071c8c82025d28\"}' WHERE `type` = 'library' AND `element` = 'joomla'Status Duration starting 0.02 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 After table lock 0.00 ms init 0.04 ms Updating 0.04 ms end 0.01 ms query end 2.15 ms closing tables 0.01 ms freeing items 0.01 ms updating status 0.01 ms cleaning up 0.01 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Helper/LibraryHelper.php:117 15 Joomla\CMS\Helper\LibraryHelper::saveParams() JROOT/libraries/src/Version.php:372 14 Joomla\CMS\Version->setMediaVersion() JROOT/libraries/src/Version.php:331 13 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 12 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 11 Joomla\CMS\Factory::getDocument() JROOT/administrator/components/com_hikashop/helpers/helper.php:2751 10 include_once JROOT/administrator/components/com_hikashop/helpers/helper.php JROOT/plugins/system/hikashopgeolocation/hikashopgeolocation.php:168 9 plgSystemHikashopgeolocation->process() JROOT/plugins/system/hikashopgeolocation/hikashopgeolocation.php:57 8 plgSystemHikashopgeolocation->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 - 查詢時間: 0.43 ms 最後的查詢: 2.98 ms 之後 查詢記憶體: 0.061 MB 記憶體於查詢: 3.559 MB 前 回傳的列: 359
SELECT *
FROM byat8_hikashop_configid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE byat8_hikashop_config ALL NULL NO INDEX KEY COULD BE USED NULL NULL 359 Status Duration starting 0.02 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms After table lock 0.02 ms init 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms executing 0.00 ms Sending data 0.15 ms end 0.01 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.01 ms updating status 0.01 ms cleaning up 0.01 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 13 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_hikashop/classes/config.php:16 12 hikashopConfigClass->load() JROOT/administrator/components/com_hikashop/helpers/helper.php:1067 11 hikashop_config() JROOT/administrator/components/com_hikashop/helpers/helper.php:2770 10 include_once JROOT/administrator/components/com_hikashop/helpers/helper.php JROOT/plugins/system/hikashopgeolocation/hikashopgeolocation.php:168 9 plgSystemHikashopgeolocation->process() JROOT/plugins/system/hikashopgeolocation/hikashopgeolocation.php:57 8 plgSystemHikashopgeolocation->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 - 查詢時間: 1.29 ms 最後的查詢: 0.82 ms 之後 查詢記憶體: 0.187 MB 記憶體於查詢: 3.871 MB 前 回傳的列: 103
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 byat8_menu AS m
LEFT JOIN byat8_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.lftid 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 197 Using index condition; Using where; Using filesort 1 SIMPLE e eq_ref PRIMARY PRIMARY 4 parentingheadline_db.m.component_id 1 Using where Status Duration starting 0.05 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.00 ms After table lock 0.01 ms init 0.02 ms optimizing 0.02 ms statistics 0.05 ms preparing 0.02 ms executing 0.00 ms Sorting result 0.40 ms Sending data 0.50 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.01 ms updating status 0.01 ms cleaning up 0.01 ms # Caller File and line number 23 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 22 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Menu/SiteMenu.php:93 21 Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}() Same as call in the line below. 20 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 19 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Menu/SiteMenu.php:101 18 Joomla\CMS\Menu\SiteMenu->load() JROOT/libraries/src/Menu/AbstractMenu.php:76 17 Joomla\CMS\Menu\AbstractMenu->__construct() JROOT/libraries/src/Menu/SiteMenu.php:62 16 Joomla\CMS\Menu\SiteMenu->__construct() JROOT/libraries/src/Menu/AbstractMenu.php:131 15 Joomla\CMS\Menu\AbstractMenu::getInstance() JROOT/libraries/src/Application/CMSApplication.php:375 14 Joomla\CMS\Application\CMSApplication->getMenu() JROOT/libraries/src/Application/SiteApplication.php:275 13 Joomla\CMS\Application\SiteApplication->getMenu() JROOT/libraries/src/Router/SiteRouter.php:64 12 Joomla\CMS\Router\SiteRouter->__construct() JROOT/libraries/src/Router/Router.php:189 11 Joomla\CMS\Router\Router::getInstance() JROOT/libraries/src/Application/CMSApplication.php:491 10 Joomla\CMS\Application\CMSApplication::getRouter() JROOT/libraries/src/Application/SiteApplication.php:403 9 Joomla\CMS\Application\SiteApplication::getRouter() JROOT/plugins/system/languagefilter/languagefilter.php:145 8 PlgSystemLanguageFilter->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 - 查詢時間: 0.40 ms 最後的查詢: 6.49 ms 之後 查詢記憶體: 0.023 MB 記憶體於查詢: 4.856 MB 前 回傳的列: 1
SELECT id
FROM `byat8_tags`
WHERE `alias` = '意外'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE byat8_tags ref idx_alias idx_alias 402 const 1 Using where Status Duration starting 0.06 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms After table lock 0.01 ms init 0.02 ms optimizing 0.02 ms statistics 0.06 ms preparing 0.02 ms executing 0.01 ms Sending data 0.04 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.01 ms updating status 0.01 ms cleaning up 0.01 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 11 JDatabaseDriver->loadResult() JROOT/components/com_tags/router.php:179 10 TagsRouter->fixSegment() JROOT/components/com_tags/router.php:147 9 TagsRouter->parse() JROOT/libraries/src/Router/SiteRouter.php:437 8 Joomla\CMS\Router\SiteRouter->parseSefRoute() JROOT/libraries/src/Router/Router.php:482 7 Joomla\CMS\Router\Router->_parseSefRoute() JROOT/libraries/src/Router/Router.php:227 6 Joomla\CMS\Router\Router->parse() JROOT/libraries/src/Router/SiteRouter.php:138 5 Joomla\CMS\Router\SiteRouter->parse() JROOT/libraries/src/Application/CMSApplication.php:1074 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 - 查詢時間: 0.32 ms 最後的查詢: 0.16 ms 之後 查詢記憶體: 0.026 MB 記憶體於查詢: 4.863 MB 前 回傳的列: 1
SELECT *
FROM `byat8_admintools_wafblacklists`
WHERE `verb` IN('','GET')
AND `option` IN('','com_tags')
AND `view` IN('','tag')
AND `task` IN('','tag.')
AND `enabled` = '1'
GROUP BY `query`
ORDER BY `query` ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE byat8_admintools_wafblacklists ALL NULL NO INDEX KEY COULD BE USED NULL NULL 2 Using where; Using temporary; Using filesort Status Duration starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.00 ms Table lock 0.00 ms After table lock 0.01 ms init 0.02 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms executing 0.00 ms Creating tmp table 0.03 ms Copying to tmp table 0.03 ms Sorting result 0.01 ms Sending data 0.01 ms end 0.00 ms removing tmp table 0.01 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.01 ms updating status 0.01 ms cleaning up 0.01 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/plugins/system/admintools/feature/wafblacklist.php:87 10 AtsystemFeatureWafblacklist->onAfterRoute() JROOT/plugins/system/admintools/admintools/main.php:710 9 plgSystemAdmintools->runFeature() JROOT/plugins/system/admintools/admintools/main.php:145 8 plgSystemAdmintools->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:1122 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 - 查詢時間: 0.40 ms 最後的查詢: 1.87 ms 之後 查詢記憶體: 0.036 MB 記憶體於查詢: 5.264 MB 前 回傳的列: 11
SELECT id, home, template, s.params
FROM byat8_template_styles as s
LEFT JOIN byat8_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 = 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE s ALL idx_template,idx_client_id,idx_client_id_home NO INDEX KEY COULD BE USED NULL NULL 7 Using where 1 SIMPLE e ref element_clientid,element_folder_clientid,extension element_clientid 403 parentingheadline_db.s.template,const 1 Using index condition; Using where Status Duration starting 0.03 ms checking permissions 0.01 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 After table lock 0.00 ms init 0.01 ms optimizing 0.01 ms statistics 0.06 ms preparing 0.02 ms executing 0.00 ms Sending data 0.10 ms end 0.01 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.02 ms updating status 0.01 ms cleaning up 0.01 ms # Caller File and line number 21 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 20 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Application/SiteApplication.php:486 19 Joomla\CMS\Application\SiteApplication->getTemplate() JROOT/libraries/src/HTML/HTMLHelper.php:365 18 Joomla\CMS\HTML\HTMLHelper::includeRelativeFiles() JROOT/libraries/src/HTML/HTMLHelper.php:712 17 Joomla\CMS\HTML\HTMLHelper::script() Same as call in the line below. 16 call_user_func_array() JROOT/libraries/src/HTML/HTMLHelper.php:239 15 Joomla\CMS\HTML\HTMLHelper::call() JROOT/libraries/src/HTML/HTMLHelper.php:146 14 Joomla\CMS\HTML\HTMLHelper::_() JROOT/libraries/cms/html/jquery.php:52 13 JHtmlJquery::framework() Same as call in the line below. 12 call_user_func_array() JROOT/libraries/src/HTML/HTMLHelper.php:239 11 Joomla\CMS\HTML\HTMLHelper::call() JROOT/libraries/src/HTML/HTMLHelper.php:146 10 Joomla\CMS\HTML\HTMLHelper::_() JROOT/administrator/components/com_k2/helpers/html.php:79 9 K2HelperHTML::loadjQuery() JROOT/plugins/system/k2/k2.php:45 8 plgSystemK2->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:1122 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 - 查詢時間: 0.24 ms 最後的查詢: 2.17 ms 之後 查詢記憶體: 0.024 MB 記憶體於查詢: 5.332 MB 前 回傳的列: 3
SELECT `id`, `name`,`alias`, `use_feedburner`, `uri`, `feed_type`
FROM `byat8_obrss`
WHERE `published` = 1
AND `feeded` = 1
ORDER BY `ordering`id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE byat8_obrss ALL NULL NO INDEX KEY COULD BE USED NULL NULL 3 Using where; Using filesort Status Duration starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.00 ms Table lock 0.00 ms After 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.01 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.01 ms updating status 0.01 ms cleaning up 0.01 ms # Caller File and line number 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 9 JDatabaseDriver->loadObjectList() JROOT/plugins/system/obrss/obrss.php:40 8 plgSystemobrss->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:1122 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 - 查詢時間: 0.29 ms 最後的查詢: 2.61 ms 之後 查詢記憶體: 0.036 MB 記憶體於查詢: 5.478 MB 前 回傳的列: 14
SELECT *
FROM `byat8_content_types`id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE byat8_content_types ALL NULL NO INDEX KEY COULD BE USED NULL NULL 9 Status Duration starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.00 ms After 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 Sending data 0.08 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.01 ms updating status 0.01 ms cleaning up 0.01 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506 18 JDatabaseDriver->loadAssocList() JROOT/libraries/src/Helper/TagsHelper.php:794 17 Joomla\CMS\Helper\TagsHelper::getTypes() JROOT/libraries/src/Helper/TagsHelper.php:628 16 Joomla\CMS\Helper\TagsHelper->getTagItemsQuery() JROOT/components/com_tags/models/tag.php:149 15 TagsModelTag->getListQuery() JROOT/libraries/src/MVC/Model/ListModel.php:133 14 Joomla\CMS\MVC\Model\ListModel->_getListQuery() JROOT/libraries/src/MVC/Model/ListModel.php:187 13 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/components/com_tags/models/tag.php:86 12 TagsModelTag->getItems() JROOT/libraries/src/MVC/View/HtmlView.php:425 11 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_tags/views/tag/view.html.php:93 10 TagsViewTag->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_tags/controller.php:52 8 TagsController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_tags/tags.php:15 6 require_once JROOT/components/com_tags/tags.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 - 查詢時間: 1.99 ms 最後的查詢: 0.11 ms 之後 查詢記憶體: 0.065 MB 記憶體於查詢: 5.489 MB 前 回傳的列: 19
SELECT m.type_alias, m.content_item_id, m.core_content_id, count(m.tag_id) AS match_count, MAX(m.tag_date) as tag_date, MAX(c.core_title) AS core_title, MAX(c.core_params) AS core_params,MAX(c.core_alias) AS core_alias, MAX(c.core_body) AS core_body, MAX(c.core_state) AS core_state, MAX(c.core_access) AS core_access,MAX(c.core_metadata) AS core_metadata, MAX(c.core_created_user_id) AS core_created_user_id, MAX(c.core_created_by_alias) AS core_created_by_alias,MAX(c.core_created_time) as core_created_time, MAX(c.core_images) as core_images,
CASE WHEN c.core_modified_time = '0000-00-00 00:00:00' THEN c.core_created_time ELSE c.core_modified_time END as core_modified_time,MAX(c.core_language) AS core_language, MAX(c.core_catid) AS core_catid,MAX(c.core_publish_up) AS core_publish_up, MAX(c.core_publish_down) as core_publish_down,MAX(ct.type_title) AS content_type_title, MAX(ct.router) AS router,
CASE WHEN c.core_created_by_alias > ' ' THEN c.core_created_by_alias ELSE ua.name END AS author,ua.email AS author_email
FROM byat8_contentitem_tag_map AS m
INNER JOIN byat8_ucm_content AS c
ON m.type_alias = c.core_type_alias
AND m.core_content_id = c.core_content_id
AND c.core_state IN (1)
AND (c.core_publish_up = '0000-00-00 00:00:00' OR c.core_publish_up <= '2020-02-17 16:54:24')
AND (c.core_publish_down = '0000-00-00 00:00:00' OR c.core_publish_down >= '2020-02-17 16:54:24')
INNER JOIN byat8_content_types AS ct
ON ct.type_alias = m.type_alias
LEFT JOIN byat8_categories AS tc
ON tc.id = c.core_catid
LEFT JOIN byat8_users AS ua
ON ua.id = c.core_created_user_id
WHERE m.tag_id IN (173)
AND (c.core_catid = 0 OR tc.published = 1)
AND m.type_alias IN ('com_content.article','com_contact.contact','com_newsfeeds.newsfeed','com_users.user','com_content.category','com_contact.category','com_newsfeeds.category','com_tags.tag','com_banners.banner','com_banners.category','com_banners.client','com_users.note','com_users.category','com_hikashop.product')
AND c.core_access IN (0,1,5)
GROUP BY m.type_alias, m.content_item_id, m.core_content_id, core_modified_time, core_created_time, core_created_by_alias, author, author_email
ORDER BY MAX(`c`.`core_title`) ASC
LIMIT 20id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ref idx_tag_type,idx_core_content_id idx_tag_type 4 const 19 Using where; Using temporary; Using filesort 1 SIMPLE c eq_ref PRIMARY,tag_idx,idx_access,idx_content_type PRIMARY 4 parentingheadline_db.m.core_content_id 1 Using where 1 SIMPLE tc eq_ref PRIMARY PRIMARY 4 parentingheadline_db.c.core_catid 1 Using where 1 SIMPLE ua eq_ref PRIMARY PRIMARY 4 parentingheadline_db.c.core_created_user_id 1 Using where 1 SIMPLE ct ALL idx_alias NO INDEX KEY COULD BE USED NULL NULL 9 Using where; Using join buffer (flat, BNL join) Status Duration starting 0.13 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 Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.00 ms After table lock 0.01 ms init 0.09 ms optimizing 0.03 ms statistics 0.11 ms preparing 0.05 ms executing 0.01 ms Creating tmp table 0.24 ms Copying to tmp table 0.93 ms Sorting result 0.05 ms Sending data 0.09 ms end 0.01 ms removing tmp table 0.07 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.01 ms updating status 0.01 ms cleaning up 0.01 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 15 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 14 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:187 13 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/components/com_tags/models/tag.php:86 12 TagsModelTag->getItems() JROOT/libraries/src/MVC/View/HtmlView.php:425 11 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_tags/views/tag/view.html.php:93 10 TagsViewTag->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_tags/controller.php:52 8 TagsController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_tags/tags.php:15 6 require_once JROOT/components/com_tags/tags.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 - 查詢時間: 0.66 ms 最後的查詢: 0.38 ms 之後 查詢記憶體: 0.037 MB 記憶體於查詢: 5.690 MB 前 回傳的列: 30
SHOW FULL COLUMNS
FROM `byat8_tags`EXPLAIN 無法被使用於查詢: SHOW FULL COLUMNS FROM `byat8_tags`Status Duration starting 0.02 ms checking permissions 0.01 ms Opening tables 0.14 ms After opening tables 0.01 ms System lock 0.03 ms Table lock 0.00 ms After 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 Filling schema table 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms 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.01 ms query end 0.00 ms closing tables 0.00 ms removing tmp table 0.05 ms closing tables 0.01 ms freeing items 0.01 ms updating status 0.01 ms cleaning up 0.01 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 18 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:445 17 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:245 16 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:164 15 Joomla\CMS\Table\Table->__construct() JROOT/administrator/components/com_tags/tables/tag.php:29 14 TagsTableTag->__construct() JROOT/libraries/src/Table/Table.php:312 13 Joomla\CMS\Table\Table::getInstance() JROOT/components/com_tags/models/tag.php:272 12 TagsModelTag->getItem() JROOT/libraries/src/MVC/View/HtmlView.php:425 11 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_tags/views/tag/view.html.php:94 10 TagsViewTag->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_tags/controller.php:52 8 TagsController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_tags/tags.php:15 6 require_once JROOT/components/com_tags/tags.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 - 查詢時間: 0.23 ms 最後的查詢: 0.38 ms 之後 查詢記憶體: 0.036 MB 記憶體於查詢: 5.757 MB 前 回傳的列: 1重覆查詢: #40
SELECT *
FROM byat8_tags
WHERE `id` = '173'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE byat8_tags const PRIMARY PRIMARY 4 const 1 Status Duration starting 0.02 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.00 ms Table lock 0.00 ms After table lock 0.01 ms init 0.02 ms optimizing 0.01 ms statistics 0.04 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.01 ms freeing items 0.01 ms updating status 0.01 ms cleaning up 0.01 ms # Caller File and line number 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 14 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/Table.php:731 13 Joomla\CMS\Table\Table->load() JROOT/components/com_tags/models/tag.php:281 12 TagsModelTag->getItem() JROOT/libraries/src/MVC/View/HtmlView.php:425 11 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_tags/views/tag/view.html.php:94 10 TagsViewTag->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_tags/controller.php:52 8 TagsController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_tags/tags.php:15 6 require_once JROOT/components/com_tags/tags.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 - 查詢時間: 1.55 ms 最後的查詢: 0.26 ms 之後 查詢記憶體: 0.065 MB 記憶體於查詢: 5.783 MB 前 回傳的列: 19
SELECT m.type_alias, m.content_item_id, m.core_content_id, count(m.tag_id) AS match_count, MAX(m.tag_date) as tag_date, MAX(c.core_title) AS core_title, MAX(c.core_params) AS core_params,MAX(c.core_alias) AS core_alias, MAX(c.core_body) AS core_body, MAX(c.core_state) AS core_state, MAX(c.core_access) AS core_access,MAX(c.core_metadata) AS core_metadata, MAX(c.core_created_user_id) AS core_created_user_id, MAX(c.core_created_by_alias) AS core_created_by_alias,MAX(c.core_created_time) as core_created_time, MAX(c.core_images) as core_images,
CASE WHEN c.core_modified_time = '0000-00-00 00:00:00' THEN c.core_created_time ELSE c.core_modified_time END as core_modified_time,MAX(c.core_language) AS core_language, MAX(c.core_catid) AS core_catid,MAX(c.core_publish_up) AS core_publish_up, MAX(c.core_publish_down) as core_publish_down,MAX(ct.type_title) AS content_type_title, MAX(ct.router) AS router,
CASE WHEN c.core_created_by_alias > ' ' THEN c.core_created_by_alias ELSE ua.name END AS author,ua.email AS author_email
FROM byat8_contentitem_tag_map AS m
INNER JOIN byat8_ucm_content AS c
ON m.type_alias = c.core_type_alias
AND m.core_content_id = c.core_content_id
AND c.core_state IN (1)
AND (c.core_publish_up = '0000-00-00 00:00:00' OR c.core_publish_up <= '2020-02-17 16:54:24')
AND (c.core_publish_down = '0000-00-00 00:00:00' OR c.core_publish_down >= '2020-02-17 16:54:24')
INNER JOIN byat8_content_types AS ct
ON ct.type_alias = m.type_alias
LEFT JOIN byat8_categories AS tc
ON tc.id = c.core_catid
LEFT JOIN byat8_users AS ua
ON ua.id = c.core_created_user_id
WHERE m.tag_id IN (173)
AND (c.core_catid = 0 OR tc.published = 1)
AND m.type_alias IN ('com_content.article','com_contact.contact','com_newsfeeds.newsfeed','com_users.user','com_content.category','com_contact.category','com_newsfeeds.category','com_tags.tag','com_banners.banner','com_banners.category','com_banners.client','com_users.note','com_users.category','com_hikashop.product')
AND c.core_access IN (0,1,5)
GROUP BY m.type_alias, m.content_item_id, m.core_content_id, core_modified_time, core_created_time, core_created_by_alias, author, author_email
ORDER BY MAX(`c`.`core_title`) ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ref idx_tag_type,idx_core_content_id idx_tag_type 4 const 19 Using where; Using temporary; Using filesort 1 SIMPLE c eq_ref PRIMARY,tag_idx,idx_access,idx_content_type PRIMARY 4 parentingheadline_db.m.core_content_id 1 Using where 1 SIMPLE tc eq_ref PRIMARY PRIMARY 4 parentingheadline_db.c.core_catid 1 Using where 1 SIMPLE ua eq_ref PRIMARY PRIMARY 4 parentingheadline_db.c.core_created_user_id 1 Using where 1 SIMPLE ct ALL idx_alias NO INDEX KEY COULD BE USED NULL NULL 9 Using where; Using join buffer (flat, BNL join) Status Duration starting 0.10 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 Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.00 ms Table lock 0.00 ms After table lock 0.01 ms init 0.08 ms optimizing 0.03 ms statistics 0.10 ms preparing 0.05 ms executing 0.00 ms Creating tmp table 0.17 ms Copying to tmp table 0.64 ms Sorting result 0.05 ms Sending data 0.09 ms end 0.01 ms removing tmp table 0.05 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.01 ms updating status 0.01 ms cleaning up 0.01 ms # Caller File and line number 15 JDatabaseDriverMysqli->execute() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:353 14 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount() JROOT/libraries/src/MVC/Model/ListModel.php:282 13 Joomla\CMS\MVC\Model\ListModel->getTotal() JROOT/libraries/src/MVC/Model/ListModel.php:232 12 Joomla\CMS\MVC\Model\ListModel->getPagination() JROOT/libraries/src/MVC/View/HtmlView.php:425 11 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_tags/views/tag/view.html.php:97 10 TagsViewTag->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_tags/controller.php:52 8 TagsController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_tags/tags.php:15 6 require_once JROOT/components/com_tags/tags.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 - 查詢時間: 0.56 ms 最後的查詢: 5.33 ms 之後 查詢記憶體: 0.039 MB 記憶體於查詢: 6.041 MB 前 回傳的列: 4
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM `byat8_categories` AS `s`
INNER JOIN `byat8_categories` AS `c`
ON (s.lft < c.lft
AND c.lft < s.rgt
AND c.language IN ('zh-TW','*')) OR (c.lft <= s.lft
AND s.rgt <= c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1,5)
AND c.published = 1
AND s.id = 25
ORDER BY c.lftid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE s const PRIMARY,idx_left_right PRIMARY 4 const 1 Using filesort 1 SIMPLE c ALL cat_idx,idx_access,idx_left_right,idx_language NO INDEX KEY COULD BE USED NULL NULL 153 Using where Status Duration starting 0.07 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.00 ms After table lock 0.01 ms init 0.03 ms optimizing 0.02 ms statistics 0.10 ms preparing 0.02 ms executing 0.00 ms Sorting result 0.11 ms Sending data 0.05 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.01 ms updating status 0.01 ms cleaning up 0.01 ms # Caller File and line number 21 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 20 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 19 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 18 Joomla\CMS\Categories\Categories->get() JROOT/administrator/components/com_fields/models/fields.php:203 17 FieldsModelFields->getListQuery() JROOT/libraries/src/MVC/Model/ListModel.php:133 16 Joomla\CMS\MVC\Model\ListModel->_getListQuery() JROOT/libraries/src/MVC/Model/ListModel.php:187 15 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:135 14 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:488 13 PlgSystemFields->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_tags/views/tag/view.html.php:146 10 TagsViewTag->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_tags/controller.php:52 8 TagsController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_tags/tags.php:15 6 require_once JROOT/components/com_tags/tags.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 - 查詢時間: 0.85 ms 最後的查詢: 0.22 ms 之後 查詢記憶體: 0.038 MB 記憶體於查詢: 6.077 MB 前 回傳的列: 0
SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM byat8_fields AS a
LEFT JOIN `byat8_languages` AS l
ON l.lang_code = a.language
LEFT JOIN byat8_users AS uc
ON uc.id=a.checked_out
LEFT JOIN byat8_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN byat8_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN byat8_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `byat8_fields_categories` AS fc
ON fc.field_id = a.id
WHERE a.context = 'com_content.article'
AND (fc.category_id IS NULL OR fc.category_id IN (25,0,22,10))
AND a.access IN (1,1,5)
AND (a.group_id = 0 OR g.access IN (1,1,5))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ref idx_state,idx_access,idx_context idx_state 1 const 1 Using where; Using temporary; Using filesort 1 SIMPLE l eq_ref idx_langcode idx_langcode 28 parentingheadline_db.a.language 1 Using where 1 SIMPLE uc eq_ref PRIMARY PRIMARY 4 parentingheadline_db.a.checked_out 1 1 SIMPLE ag eq_ref PRIMARY PRIMARY 4 parentingheadline_db.a.access 1 Using where 1 SIMPLE ua eq_ref PRIMARY PRIMARY 4 parentingheadline_db.a.created_user_id 1 Using where 1 SIMPLE g eq_ref PRIMARY PRIMARY 4 parentingheadline_db.a.group_id 1 Using where 1 SIMPLE fc ref PRIMARY PRIMARY 4 parentingheadline_db.a.id 1 Using where; Using index; Distinct Status Duration starting 0.06 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.01 ms checking permissions 0.00 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms After table lock 0.01 ms init 0.03 ms optimizing 0.02 ms statistics 0.07 ms preparing 0.03 ms executing 0.00 ms Creating tmp table 0.34 ms Copying to tmp table 0.02 ms Sorting result 0.01 ms Sending data 0.02 ms end 0.01 ms removing tmp table 0.05 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.01 ms updating status 0.01 ms cleaning up 0.01 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 18 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 17 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_fields/models/fields.php:333 16 FieldsModelFields->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:187 15 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:135 14 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:488 13 PlgSystemFields->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_tags/views/tag/view.html.php:146 10 TagsViewTag->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_tags/controller.php:52 8 TagsController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_tags/tags.php:15 6 require_once JROOT/components/com_tags/tags.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 - 查詢時間: 0.42 ms 最後的查詢: 1.44 ms 之後 查詢記憶體: 0.042 MB 記憶體於查詢: 6.217 MB 前 回傳的列: 7
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM `byat8_categories` AS `s`
INNER JOIN `byat8_categories` AS `c`
ON (s.lft < c.lft
AND c.lft < s.rgt
AND c.language IN ('zh-TW','*')) OR (c.lft <= s.lft
AND s.rgt <= c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1,5)
AND c.published = 1
AND s.id = 41
ORDER BY c.lftid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE s const PRIMARY,idx_left_right PRIMARY 4 const 1 1 SIMPLE c range cat_idx,idx_access,idx_left_right,idx_language idx_left_right 4 NULL 11 Using index condition; Using where Status Duration starting 0.05 ms checking permissions 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 After table lock 0.01 ms init 0.03 ms optimizing 0.02 ms statistics 0.09 ms preparing 0.02 ms executing 0.00 ms Sorting result 0.00 ms Sending data 0.08 ms end 0.01 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.01 ms updating status 0.01 ms cleaning up 0.01 ms # Caller File and line number 21 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 20 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 19 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 18 Joomla\CMS\Categories\Categories->get() JROOT/administrator/components/com_fields/models/fields.php:203 17 FieldsModelFields->getListQuery() JROOT/libraries/src/MVC/Model/ListModel.php:133 16 Joomla\CMS\MVC\Model\ListModel->_getListQuery() JROOT/libraries/src/MVC/Model/ListModel.php:187 15 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:135 14 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:488 13 PlgSystemFields->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_tags/views/tag/view.html.php:146 10 TagsViewTag->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_tags/controller.php:52 8 TagsController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_tags/tags.php:15 6 require_once JROOT/components/com_tags/tags.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 - 查詢時間: 0.67 ms 最後的查詢: 0.14 ms 之後 查詢記憶體: 0.037 MB 記憶體於查詢: 6.245 MB 前 回傳的列: 0
SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM byat8_fields AS a
LEFT JOIN `byat8_languages` AS l
ON l.lang_code = a.language
LEFT JOIN byat8_users AS uc
ON uc.id=a.checked_out
LEFT JOIN byat8_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN byat8_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN byat8_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `byat8_fields_categories` AS fc
ON fc.field_id = a.id
WHERE a.context = 'com_content.article'
AND (fc.category_id IS NULL OR fc.category_id IN (41,0))
AND a.access IN (1,1,5)
AND (a.group_id = 0 OR g.access IN (1,1,5))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ref idx_state,idx_access,idx_context idx_state 1 const 1 Using where; Using temporary; Using filesort 1 SIMPLE l eq_ref idx_langcode idx_langcode 28 parentingheadline_db.a.language 1 Using where 1 SIMPLE uc eq_ref PRIMARY PRIMARY 4 parentingheadline_db.a.checked_out 1 1 SIMPLE ag eq_ref PRIMARY PRIMARY 4 parentingheadline_db.a.access 1 Using where 1 SIMPLE ua eq_ref PRIMARY PRIMARY 4 parentingheadline_db.a.created_user_id 1 Using where 1 SIMPLE g eq_ref PRIMARY PRIMARY 4 parentingheadline_db.a.group_id 1 Using where 1 SIMPLE fc ref PRIMARY PRIMARY 4 parentingheadline_db.a.id 1 Using where; Using index; Distinct Status Duration starting 0.08 ms checking permissions 0.02 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.00 ms Table lock 0.00 ms After table lock 0.01 ms init 0.03 ms optimizing 0.02 ms statistics 0.06 ms preparing 0.03 ms executing 0.00 ms Creating tmp table 0.17 ms Copying to tmp table 0.02 ms Sorting result 0.01 ms Sending data 0.02 ms end 0.01 ms removing tmp table 0.04 ms end 0.01 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.01 ms updating status 0.01 ms cleaning up 0.01 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 18 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 17 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_fields/models/fields.php:333 16 FieldsModelFields->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:187 15 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:135 14 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:488 13 PlgSystemFields->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_tags/views/tag/view.html.php:146 10 TagsViewTag->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_tags/controller.php:52 8 TagsController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_tags/tags.php:15 6 require_once JROOT/components/com_tags/tags.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 - 查詢時間: 0.52 ms 最後的查詢: 2.25 ms 之後 查詢記憶體: 0.039 MB 記憶體於查詢: 6.283 MB 前 回傳的列: 3
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM `byat8_categories` AS `s`
INNER JOIN `byat8_categories` AS `c`
ON (s.lft < c.lft
AND c.lft < s.rgt
AND c.language IN ('zh-TW','*')) OR (c.lft <= s.lft
AND s.rgt <= c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1,5)
AND c.published = 1
AND s.id = 52
ORDER BY c.lftid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE s const PRIMARY,idx_left_right PRIMARY 4 const 1 Using filesort 1 SIMPLE c ALL cat_idx,idx_access,idx_left_right,idx_language NO INDEX KEY COULD BE USED NULL NULL 153 Using where Status Duration starting 0.05 ms checking permissions 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 After table lock 0.01 ms init 0.03 ms optimizing 0.02 ms statistics 0.12 ms preparing 0.02 ms executing 0.00 ms Sorting result 0.11 ms Sending data 0.04 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.01 ms updating status 0.01 ms cleaning up 0.01 ms # Caller File and line number 21 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 20 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 19 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 18 Joomla\CMS\Categories\Categories->get() JROOT/administrator/components/com_fields/models/fields.php:203 17 FieldsModelFields->getListQuery() JROOT/libraries/src/MVC/Model/ListModel.php:133 16 Joomla\CMS\MVC\Model\ListModel->_getListQuery() JROOT/libraries/src/MVC/Model/ListModel.php:187 15 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:135 14 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:488 13 PlgSystemFields->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_tags/views/tag/view.html.php:146 10 TagsViewTag->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_tags/controller.php:52 8 TagsController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_tags/tags.php:15 6 require_once JROOT/components/com_tags/tags.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 - 查詢時間: 0.66 ms 最後的查詢: 0.11 ms 之後 查詢記憶體: 0.037 MB 記憶體於查詢: 6.293 MB 前 回傳的列: 0
SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM byat8_fields AS a
LEFT JOIN `byat8_languages` AS l
ON l.lang_code = a.language
LEFT JOIN byat8_users AS uc
ON uc.id=a.checked_out
LEFT JOIN byat8_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN byat8_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN byat8_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `byat8_fields_categories` AS fc
ON fc.field_id = a.id
WHERE a.context = 'com_content.article'
AND (fc.category_id IS NULL OR fc.category_id IN (52,0,66))
AND a.access IN (1,1,5)
AND (a.group_id = 0 OR g.access IN (1,1,5))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ref idx_state,idx_access,idx_context idx_state 1 const 1 Using where; Using temporary; Using filesort 1 SIMPLE l eq_ref idx_langcode idx_langcode 28 parentingheadline_db.a.language 1 Using where 1 SIMPLE uc eq_ref PRIMARY PRIMARY 4 parentingheadline_db.a.checked_out 1 1 SIMPLE ag eq_ref PRIMARY PRIMARY 4 parentingheadline_db.a.access 1 Using where 1 SIMPLE ua eq_ref PRIMARY PRIMARY 4 parentingheadline_db.a.created_user_id 1 Using where 1 SIMPLE g eq_ref PRIMARY PRIMARY 4 parentingheadline_db.a.group_id 1 Using where 1 SIMPLE fc ref PRIMARY PRIMARY 4 parentingheadline_db.a.id 1 Using where; Using index; Distinct Status Duration starting 0.06 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 Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.00 ms Table lock 0.00 ms After table lock 0.01 ms init 0.03 ms optimizing 0.02 ms statistics 0.06 ms preparing 0.03 ms executing 0.00 ms Creating tmp table 0.17 ms Copying to tmp table 0.02 ms Sorting result 0.01 ms Sending data 0.02 ms end 0.01 ms removing tmp table 0.04 ms end 0.01 ms query end 0.04 ms closing tables 0.01 ms freeing items 0.01 ms updating status 0.01 ms cleaning up 0.01 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 18 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 17 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_fields/models/fields.php:333 16 FieldsModelFields->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:187 15 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:135 14 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:488 13 PlgSystemFields->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_tags/views/tag/view.html.php:146 10 TagsViewTag->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_tags/controller.php:52 8 TagsController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_tags/tags.php:15 6 require_once JROOT/components/com_tags/tags.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 - 查詢時間: 0.62 ms 最後的查詢: 1.75 ms 之後 查詢記憶體: 0.039 MB 記憶體於查詢: 6.330 MB 前 回傳的列: 3
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM `byat8_categories` AS `s`
INNER JOIN `byat8_categories` AS `c`
ON (s.lft < c.lft
AND c.lft < s.rgt
AND c.language IN ('zh-TW','*')) OR (c.lft <= s.lft
AND s.rgt <= c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1,5)
AND c.published = 1
AND s.id = 18
ORDER BY c.lftid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE s const PRIMARY,idx_left_right PRIMARY 4 const 1 Using filesort 1 SIMPLE c ALL cat_idx,idx_access,idx_left_right,idx_language NO INDEX KEY COULD BE USED NULL NULL 153 Using where Status Duration starting 0.10 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.00 ms Table lock 0.01 ms After table lock 0.01 ms init 0.03 ms optimizing 0.02 ms statistics 0.16 ms preparing 0.02 ms executing 0.00 ms Sorting result 0.10 ms Sending data 0.04 ms end 0.01 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.01 ms updating status 0.01 ms cleaning up 0.01 ms # Caller File and line number 21 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 20 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 19 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 18 Joomla\CMS\Categories\Categories->get() JROOT/administrator/components/com_fields/models/fields.php:203 17 FieldsModelFields->getListQuery() JROOT/libraries/src/MVC/Model/ListModel.php:133 16 Joomla\CMS\MVC\Model\ListModel->_getListQuery() JROOT/libraries/src/MVC/Model/ListModel.php:187 15 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:135 14 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:488 13 PlgSystemFields->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_tags/views/tag/view.html.php:146 10 TagsViewTag->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_tags/controller.php:52 8 TagsController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_tags/tags.php:15 6 require_once JROOT/components/com_tags/tags.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 - 查詢時間: 0.86 ms 最後的查詢: 0.12 ms 之後 查詢記憶體: 0.037 MB 記憶體於查詢: 6.341 MB 前 回傳的列: 0
SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM byat8_fields AS a
LEFT JOIN `byat8_languages` AS l
ON l.lang_code = a.language
LEFT JOIN byat8_users AS uc
ON uc.id=a.checked_out
LEFT JOIN byat8_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN byat8_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN byat8_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `byat8_fields_categories` AS fc
ON fc.field_id = a.id
WHERE a.context = 'com_content.article'
AND (fc.category_id IS NULL OR fc.category_id IN (18,0,17))
AND a.access IN (1,1,5)
AND (a.group_id = 0 OR g.access IN (1,1,5))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ref idx_state,idx_access,idx_context idx_state 1 const 1 Using where; Using temporary; Using filesort 1 SIMPLE l eq_ref idx_langcode idx_langcode 28 parentingheadline_db.a.language 1 Using where 1 SIMPLE uc eq_ref PRIMARY PRIMARY 4 parentingheadline_db.a.checked_out 1 1 SIMPLE ag eq_ref PRIMARY PRIMARY 4 parentingheadline_db.a.access 1 Using where 1 SIMPLE ua eq_ref PRIMARY PRIMARY 4 parentingheadline_db.a.created_user_id 1 Using where 1 SIMPLE g eq_ref PRIMARY PRIMARY 4 parentingheadline_db.a.group_id 1 Using where 1 SIMPLE fc ref PRIMARY PRIMARY 4 parentingheadline_db.a.id 1 Using where; Using index; Distinct Status Duration starting 0.12 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 Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.00 ms Table lock 0.00 ms After table lock 0.01 ms init 0.03 ms optimizing 0.02 ms statistics 0.06 ms preparing 0.03 ms executing 0.00 ms Creating tmp table 0.33 ms Copying to tmp table 0.02 ms Sorting result 0.01 ms Sending data 0.02 ms end 0.01 ms removing tmp table 0.04 ms end 0.01 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.01 ms updating status 0.01 ms cleaning up 0.01 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 18 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 17 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_fields/models/fields.php:333 16 FieldsModelFields->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:187 15 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:135 14 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:488 13 PlgSystemFields->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_tags/views/tag/view.html.php:146 10 TagsViewTag->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_tags/controller.php:52 8 TagsController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_tags/tags.php:15 6 require_once JROOT/components/com_tags/tags.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 - 查詢時間: 0.23 ms 最後的查詢: 2.89 ms 之後 查詢記憶體: 0.036 MB 記憶體於查詢: 6.375 MB 前 回傳的列: 1重覆查詢: #30
SELECT *
FROM byat8_tags
WHERE `id` = '173'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE byat8_tags const PRIMARY PRIMARY 4 const 1 Status Duration starting 0.02 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 After table lock 0.01 ms init 0.02 ms optimizing 0.01 ms statistics 0.03 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.01 ms freeing items 0.01 ms updating status 0.01 ms cleaning up 0.01 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 13 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/Table.php:731 12 Joomla\CMS\Table\Table->load() JROOT/components/com_tags/models/tag.php:336 11 TagsModelTag->hit() JROOT/components/com_tags/views/tag/view.html.php:245 10 TagsViewTag->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_tags/controller.php:52 8 TagsController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_tags/tags.php:15 6 require_once JROOT/components/com_tags/tags.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 - 查詢時間: 0.43 ms 最後的查詢: 0.09 ms 之後 查詢記憶體: 0.006 MB 記憶體於查詢: 6.381 MB 前
UPDATE byat8_tags
SET `hits` = (`hits` + 1)
WHERE `id` = '173'EXPLAIN 無法被使用於查詢: UPDATE byat8_tags SET `hits` = (`hits` + 1) WHERE `id` = '173'Status Duration starting 0.02 ms checking permissions 0.01 ms Opening tables 0.04 ms After opening tables 0.01 ms System lock 0.00 ms Table lock 0.00 ms After table lock 0.00 ms init 0.03 ms Updating 0.04 ms end 0.01 ms Waiting for query cache lock 0.00 ms end 0.01 ms query end 0.20 ms closing tables 0.01 ms freeing items 0.01 ms updating status 0.01 ms cleaning up 0.01 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Table/Table.php:1245 12 Joomla\CMS\Table\Table->hit() JROOT/components/com_tags/models/tag.php:337 11 TagsModelTag->hit() JROOT/components/com_tags/views/tag/view.html.php:245 10 TagsViewTag->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_tags/controller.php:52 8 TagsController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_tags/tags.php:15 6 require_once JROOT/components/com_tags/tags.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 - 查詢時間: 0.66 ms 最後的查詢: 0.57 ms 之後 查詢記憶體: 0.040 MB 記憶體於查詢: 6.414 MB 前 回傳的列: 0
SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM byat8_fields AS a
LEFT JOIN `byat8_languages` AS l
ON l.lang_code = a.language
LEFT JOIN byat8_users AS uc
ON uc.id=a.checked_out
LEFT JOIN byat8_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN byat8_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN byat8_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `byat8_fields_categories` AS fc
ON fc.field_id = a.id
WHERE a.context = 'com_tag.tag'
AND (fc.category_id IS NULL OR fc.category_id IN (41,0))
AND a.access IN (1,1,5)
AND (a.group_id = 0 OR g.access IN (1,1,5))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ref idx_state,idx_access,idx_context idx_state 1 const 1 Using where; Using temporary; Using filesort 1 SIMPLE l eq_ref idx_langcode idx_langcode 28 parentingheadline_db.a.language 1 Using where 1 SIMPLE uc eq_ref PRIMARY PRIMARY 4 parentingheadline_db.a.checked_out 1 1 SIMPLE ag eq_ref PRIMARY PRIMARY 4 parentingheadline_db.a.access 1 Using where 1 SIMPLE ua eq_ref PRIMARY PRIMARY 4 parentingheadline_db.a.created_user_id 1 Using where 1 SIMPLE g eq_ref PRIMARY PRIMARY 4 parentingheadline_db.a.group_id 1 Using where 1 SIMPLE fc ref PRIMARY PRIMARY 4 parentingheadline_db.a.id 1 Using where; Using index; Distinct Status Duration starting 0.06 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 Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.00 ms Table lock 0.00 ms After table lock 0.01 ms init 0.03 ms optimizing 0.02 ms statistics 0.06 ms preparing 0.03 ms executing 0.00 ms Creating tmp table 0.19 ms Copying to tmp table 0.02 ms Sorting result 0.01 ms Sending data 0.02 ms end 0.01 ms removing tmp table 0.04 ms end 0.01 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.01 ms updating status 0.01 ms cleaning up 0.01 ms # Caller File and line number 26 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 25 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 24 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_fields/models/fields.php:333 23 FieldsModelFields->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:187 22 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:135 21 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:488 20 PlgSystemFields->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 19 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 18 JEventDispatcher->trigger() JROOT/libraries/cms/html/content.php:41 17 JHtmlContent::prepare() Same as call in the line below. 16 call_user_func_array() JROOT/libraries/src/HTML/HTMLHelper.php:239 15 Joomla\CMS\HTML\HTMLHelper::call() JROOT/libraries/src/HTML/HTMLHelper.php:146 14 Joomla\CMS\HTML\HTMLHelper::_() JROOT/components/com_tags/views/tag/tmpl/default.php:25 13 include JROOT/components/com_tags/views/tag/tmpl/default.php JROOT/libraries/src/MVC/View/HtmlView.php:697 12 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/libraries/src/MVC/View/HtmlView.php:230 11 Joomla\CMS\MVC\View\HtmlView->display() JROOT/components/com_tags/views/tag/view.html.php:249 10 TagsViewTag->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_tags/controller.php:52 8 TagsController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_tags/tags.php:15 6 require_once JROOT/components/com_tags/tags.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 - 查詢時間: 0.97 ms 最後的查詢: 0.69 ms 之後 查詢記憶體: 0.035 MB 記憶體於查詢: 6.459 MB 前 回傳的列: 61
SELECT `id`,`name`,`rules`,`parent_id`
FROM `byat8_assets`
WHERE `name` IN ('root.1','com_actionlogs','com_acymailing','com_adagency','com_admin','com_admintools','com_advancedmodules','com_ajax','com_akeeba','com_alphauserpoints','com_app2one_push','com_associations','com_banners','com_blankcomponent','com_cache','com_categories','com_categoryblock','com_checkin','com_coalawebsociallinks','com_community','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_csvi','com_fields','com_finder','com_freevotes','com_fsj_main','com_fsj_transman','com_hikaserial','com_hikashop','com_ijoomlainstaller','com_installer','com_jbackend','com_jce','com_jcomments','com_joomlaupdate','com_k2','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_obrss','com_offlajn_installer','com_plugins','com_postinstall','com_privacy','com_quicklogout','com_redirect','com_rstbox','com_search','com_sppagebuilder','com_tags','com_tcpdf','com_templates','com_users','com_wrapper')id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE byat8_assets range idx_asset_name idx_asset_name 202 NULL 63 Using index condition Status Duration starting 0.04 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.00 ms Table lock 0.00 ms After table lock 0.09 ms init 0.06 ms optimizing 0.01 ms statistics 0.15 ms preparing 0.01 ms executing 0.00 ms Sending data 0.47 ms end 0.01 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.01 ms updating status 0.01 ms cleaning up 0.01 ms # Caller File and line number 22 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 21 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Access/Access.php:429 20 Joomla\CMS\Access\Access::preloadComponents() JROOT/libraries/src/Access/Access.php:213 19 Joomla\CMS\Access\Access::preload() JROOT/libraries/src/Access/Access.php:531 18 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 17 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 16 Joomla\CMS\User\User->authorise() JROOT/components/com_tags/views/tag/tmpl/default_items.php:20 15 include JROOT/components/com_tags/views/tag/tmpl/default_items.php JROOT/libraries/src/MVC/View/HtmlView.php:697 14 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/components/com_tags/views/tag/tmpl/default.php:50 13 include JROOT/components/com_tags/views/tag/tmpl/default.php JROOT/libraries/src/MVC/View/HtmlView.php:697 12 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/libraries/src/MVC/View/HtmlView.php:230 11 Joomla\CMS\MVC\View\HtmlView->display() JROOT/components/com_tags/views/tag/view.html.php:249 10 TagsViewTag->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_tags/controller.php:52 8 TagsController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_tags/tags.php:15 6 require_once JROOT/components/com_tags/tags.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 - 查詢時間: 0.42 ms 最後的查詢: 2.49 ms 之後 查詢記憶體: 0.022 MB 記憶體於查詢: 6.578 MB 前 回傳的列: 1
SELECT language,id
FROM `byat8_menu`
WHERE home = 1
AND published = 1
AND client_id = 0id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE byat8_menu ref idx_client_id_parent_id_alias_language idx_client_id_parent_id_alias_language 1 const 198 Using where Status Duration starting 0.02 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 After table lock 0.01 ms init 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.01 ms executing 0.00 ms Sending data 0.23 ms end 0.01 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.01 ms updating status 0.01 ms cleaning up 0.01 ms # Caller File and line number 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 9 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Language/Multilanguage.php:107 8 Joomla\CMS\Language\Multilanguage::getSiteHomePages() JROOT/plugins/system/languagefilter/languagefilter.php:751 7 PlgSystemLanguageFilter->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 - 查詢時間: 0.22 ms 最後的查詢: 0.34 ms 之後 查詢記憶體: 0.025 MB 記憶體於查詢: 6.658 MB 前 回傳的列: 2
select b.*
from byat8_rstbox b
where b.published = 1
AND b.testmode=0id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE b ALL NULL NO INDEX KEY COULD BE USED NULL NULL 11 Using where Status Duration starting 0.02 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 After 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 Sending data 0.04 ms end 0.01 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.01 ms updating status 0.01 ms cleaning up 0.01 ms # Caller File and line number 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 9 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_rstbox/helpers/helper.php:242 8 EBHelper::getBoxes() JROOT/plugins/system/rstbox/rstbox.php:78 7 PlgSystemRstBox->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 - 查詢時間: 0.26 ms 最後的查詢: 6.28 ms 之後 查詢記憶體: 0.030 MB 記憶體於查詢: 6.759 MB 前 回傳的列: 1
SELECT *
FROM byat8_modules
WHERE id='638'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE byat8_modules const PRIMARY PRIMARY 4 const 1 Status Duration starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.00 ms After table lock 0.01 ms init 0.02 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.01 ms executing 0.00 ms Sending data 0.02 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.01 ms updating status 0.01 ms cleaning up 0.01 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 15 JDatabaseDriver->loadObject() JROOT/plugins/system/nrframework/NRFramework/Functions.php:366 14 NRFramework\Functions::loadModule() JROOT/plugins/engagebox/module/layout/module.php:18 13 include JROOT/plugins/engagebox/module/layout/module.php JROOT/libraries/src/Layout/FileLayout.php:125 12 Joomla\CMS\Layout\FileLayout->render() JROOT/administrator/components/com_rstbox/helpers/type.php:70 11 EngageBoxType->onEngageBoxTypeRender() JROOT/libraries/joomla/event/event.php:70 10 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 9 JEventDispatcher->trigger() JROOT/administrator/components/com_rstbox/helpers/helper.php:262 8 EBHelper::getBoxes() JROOT/plugins/system/rstbox/rstbox.php:78 7 PlgSystemRstBox->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 - 查詢時間: 0.19 ms 最後的查詢: 0.59 ms 之後 查詢記憶體: 0.027 MB 記憶體於查詢: 6.793 MB 前 回傳的列: 1重覆查詢: #48
select `blacklist`
from byat8_ad_agency_settingsid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE byat8_ad_agency_settings system NULL NO INDEX KEY COULD BE USED NULL NULL 1 Status Duration starting 0.02 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.00 ms After table lock 0.01 ms init 0.01 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.01 ms executing 0.00 ms Sending data 0.01 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.00 ms updating status 0.01 ms cleaning up 0.01 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/database.php:33 18 JDatabase->query() JROOT/modules/mod_ijoomla_adagency_zone/helper.php:1997 17 getIPBlocklist() JROOT/modules/mod_ijoomla_adagency_zone/mod_ijoomla_adagency_zone.php:19 16 include JROOT/modules/mod_ijoomla_adagency_zone/mod_ijoomla_adagency_zone.php JROOT/libraries/src/Helper/ModuleHelper.php:200 15 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/plugins/system/nrframework/NRFramework/Functions.php:372 14 NRFramework\Functions::loadModule() JROOT/plugins/engagebox/module/layout/module.php:18 13 include JROOT/plugins/engagebox/module/layout/module.php JROOT/libraries/src/Layout/FileLayout.php:125 12 Joomla\CMS\Layout\FileLayout->render() JROOT/administrator/components/com_rstbox/helpers/type.php:70 11 EngageBoxType->onEngageBoxTypeRender() JROOT/libraries/joomla/event/event.php:70 10 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 9 JEventDispatcher->trigger() JROOT/administrator/components/com_rstbox/helpers/helper.php:262 8 EBHelper::getBoxes() JROOT/plugins/system/rstbox/rstbox.php:78 7 PlgSystemRstBox->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 - 查詢時間: 0.16 ms 最後的查詢: 0.03 ms 之後 查詢記憶體: 0.027 MB 記憶體於查詢: 6.802 MB 前 回傳的列: 1重覆查詢: #47
select `blacklist`
from byat8_ad_agency_settingsid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE byat8_ad_agency_settings system NULL NO INDEX KEY COULD BE USED NULL NULL 1 Status Duration starting 0.01 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 After 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 Sending data 0.01 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.00 ms updating status 0.01 ms cleaning up 0.01 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 18 JDatabaseDriver->loadColumn() JROOT/modules/mod_ijoomla_adagency_zone/helper.php:1998 17 getIPBlocklist() JROOT/modules/mod_ijoomla_adagency_zone/mod_ijoomla_adagency_zone.php:19 16 include JROOT/modules/mod_ijoomla_adagency_zone/mod_ijoomla_adagency_zone.php JROOT/libraries/src/Helper/ModuleHelper.php:200 15 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/plugins/system/nrframework/NRFramework/Functions.php:372 14 NRFramework\Functions::loadModule() JROOT/plugins/engagebox/module/layout/module.php:18 13 include JROOT/plugins/engagebox/module/layout/module.php JROOT/libraries/src/Layout/FileLayout.php:125 12 Joomla\CMS\Layout\FileLayout->render() JROOT/administrator/components/com_rstbox/helpers/type.php:70 11 EngageBoxType->onEngageBoxTypeRender() JROOT/libraries/joomla/event/event.php:70 10 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 9 JEventDispatcher->trigger() JROOT/administrator/components/com_rstbox/helpers/helper.php:262 8 EBHelper::getBoxes() JROOT/plugins/system/rstbox/rstbox.php:78 7 PlgSystemRstBox->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 - 查詢時間: 0.16 ms 最後的查詢: 0.11 ms 之後 查詢記憶體: 0.027 MB 記憶體於查詢: 6.813 MB 前 回傳的列: 1重覆查詢: #56
select `params`
from byat8_ad_agency_settingsid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE byat8_ad_agency_settings system NULL NO INDEX KEY COULD BE USED NULL NULL 1 Status Duration starting 0.01 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 After 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 Sending data 0.01 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.00 ms updating status 0.01 ms cleaning up 0.01 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 18 JDatabaseDriver->loadColumn() JROOT/modules/mod_ijoomla_adagency_zone/helper.php:52 17 modAdAgencyZoneHelper->getParams() JROOT/modules/mod_ijoomla_adagency_zone/mod_ijoomla_adagency_zone.php:26 16 include JROOT/modules/mod_ijoomla_adagency_zone/mod_ijoomla_adagency_zone.php JROOT/libraries/src/Helper/ModuleHelper.php:200 15 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/plugins/system/nrframework/NRFramework/Functions.php:372 14 NRFramework\Functions::loadModule() JROOT/plugins/engagebox/module/layout/module.php:18 13 include JROOT/plugins/engagebox/module/layout/module.php JROOT/libraries/src/Layout/FileLayout.php:125 12 Joomla\CMS\Layout\FileLayout->render() JROOT/administrator/components/com_rstbox/helpers/type.php:70 11 EngageBoxType->onEngageBoxTypeRender() JROOT/libraries/joomla/event/event.php:70 10 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 9 JEventDispatcher->trigger() JROOT/administrator/components/com_rstbox/helpers/helper.php:262 8 EBHelper::getBoxes() JROOT/plugins/system/rstbox/rstbox.php:78 7 PlgSystemRstBox->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 - 查詢時間: 0.28 ms 最後的查詢: 0.13 ms 之後 查詢記憶體: 0.113 MB 記憶體於查詢: 6.909 MB 前 回傳的列: 1
SELECT *
FROM byat8_ad_agency_settings
LIMIT 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE byat8_ad_agency_settings system NULL NO INDEX KEY COULD BE USED NULL NULL 1 Status Duration starting 0.02 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 After table lock 0.01 ms init 0.03 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.01 ms executing 0.00 ms Sending data 0.07 ms end 0.01 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.01 ms updating status 0.01 ms cleaning up 0.01 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 18 JDatabaseDriver->loadObject() JROOT/modules/mod_ijoomla_adagency_zone/helper.php:79 17 modAdAgencyZoneHelper->getParams() JROOT/modules/mod_ijoomla_adagency_zone/mod_ijoomla_adagency_zone.php:26 16 include JROOT/modules/mod_ijoomla_adagency_zone/mod_ijoomla_adagency_zone.php JROOT/libraries/src/Helper/ModuleHelper.php:200 15 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/plugins/system/nrframework/NRFramework/Functions.php:372 14 NRFramework\Functions::loadModule() JROOT/plugins/engagebox/module/layout/module.php:18 13 include JROOT/plugins/engagebox/module/layout/module.php JROOT/libraries/src/Layout/FileLayout.php:125 12 Joomla\CMS\Layout\FileLayout->render() JROOT/administrator/components/com_rstbox/helpers/type.php:70 11 EngageBoxType->onEngageBoxTypeRender() JROOT/libraries/joomla/event/event.php:70 10 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 9 JEventDispatcher->trigger() JROOT/administrator/components/com_rstbox/helpers/helper.php:262 8 EBHelper::getBoxes() JROOT/plugins/system/rstbox/rstbox.php:78 7 PlgSystemRstBox->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 - 查詢時間: 0.21 ms 最後的查詢: 0.05 ms 之後 查詢記憶體: 0.035 MB 記憶體於查詢: 6.996 MB 前 回傳的列: 1重覆查詢: #55
SELECT *
FROM byat8_ad_agency_zone
WHERE zoneid=638
LIMIT 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE byat8_ad_agency_zone const PRIMARY PRIMARY 4 const 1 Status Duration starting 0.02 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 After table lock 0.01 ms init 0.02 ms optimizing 0.01 ms statistics 0.03 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.01 ms freeing items 0.01 ms updating status 0.01 ms cleaning up 0.01 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 18 JDatabaseDriver->loadObject() JROOT/modules/mod_ijoomla_adagency_zone/helper.php:83 17 modAdAgencyZoneHelper->getParams() JROOT/modules/mod_ijoomla_adagency_zone/mod_ijoomla_adagency_zone.php:26 16 include JROOT/modules/mod_ijoomla_adagency_zone/mod_ijoomla_adagency_zone.php JROOT/libraries/src/Helper/ModuleHelper.php:200 15 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/plugins/system/nrframework/NRFramework/Functions.php:372 14 NRFramework\Functions::loadModule() JROOT/plugins/engagebox/module/layout/module.php:18 13 include JROOT/plugins/engagebox/module/layout/module.php JROOT/libraries/src/Layout/FileLayout.php:125 12 Joomla\CMS\Layout\FileLayout->render() JROOT/administrator/components/com_rstbox/helpers/type.php:70 11 EngageBoxType->onEngageBoxTypeRender() JROOT/libraries/joomla/event/event.php:70 10 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 9 JEventDispatcher->trigger() JROOT/administrator/components/com_rstbox/helpers/helper.php:262 8 EBHelper::getBoxes() JROOT/plugins/system/rstbox/rstbox.php:78 7 PlgSystemRstBox->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 - 查詢時間: 0.17 ms 最後的查詢: 0.06 ms 之後 查詢記憶體: 0.027 MB 記憶體於查詢: 7.011 MB 前 回傳的列: 0