社區活動
「的士小巴抗疫大行動」啟動禮
2020年2月
港島、九龍區百萬行
2020年1月
公益金50週年百萬行中環及灣仔繞道
支票遞交儀式及頒獎典禮
2019年6月
公開展示低地台輪椅小巴設施
2017年8月
Joomla! 除錯主控台
{
"__default": {
"session": {
"counter": 1,
"timer": {
"start": 1793089556,
"last": 1793089556,
"now": 1793089556
}
},
"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
},
"plg_system_languagefilter": {
"language": "zh-TW"
}
}
}
時間
記憶體
時間: 3.85 ms / 3.85 ms 記憶體: 0.568 MB / 0.93 MB Application: afterLoad
時間: 145.83 ms / 149.67 ms 記憶體: 1.486 MB / 2.42 MB Application: afterInitialise
時間: 173.12 ms / 322.79 ms 記憶體: 0.429 MB / 2.85 MB Application: afterRoute
時間: 0.49 ms / 323.28 ms 記憶體: 0.019 MB / 2.87 MB Application: beforeRenderComponent com_content
時間: 2.21 ms / 325.49 ms 記憶體: 0.114 MB / 2.98 MB Application: Before Access::preloadComponents (all components)
時間: 2.42 ms / 327.91 ms 記憶體: 0.060 MB / 3.04 MB Application: After Access::preloadComponents (all components)
時間: 0.06 ms / 327.97 ms 記憶體: 0.000 MB / 3.04 MB Application: Before Access::preloadPermissions (com_content)
時間: 4.65 ms / 332.62 ms 記憶體: 0.245 MB / 3.28 MB Application: After Access::preloadPermissions (com_content)
時間: 0.07 ms / 332.69 ms 記憶體: 0.000 MB / 3.27 MB Application: Before Access::getAssetRules (id:834 name:com_content.article.152)
時間: 0.40 ms / 333.09 ms 記憶體: 0.009 MB / 3.28 MB Application: After Access::getAssetRules (id:834 name:com_content.article.152)
時間: 97.09 ms / 430.19 ms 記憶體: 0.399 MB / 3.67 MB Application: Before Access::getAssetRules (id:1 name:root.1)
時間: 0.11 ms / 430.30 ms 記憶體: 0.007 MB / 3.68 MB Application: After Access::getAssetRules (id:1 name:root.1)
時間: 16.26 ms / 446.56 ms 記憶體: 0.162 MB / 3.84 MB Application: afterRenderComponent com_content
時間: 3.39 ms / 449.95 ms 記憶體: 0.026 MB / 3.87 MB Application: Before Access::getAssetRules (id:8 name:com_content)
時間: 0.05 ms / 450.00 ms 記憶體: 0.002 MB / 3.87 MB Application: After Access::getAssetRules (id:8 name:com_content)
時間: 2.55 ms / 452.55 ms 記憶體: 0.072 MB / 3.94 MB Application: afterDispatch
時間: 27.47 ms / 480.01 ms 記憶體: 0.304 MB / 4.25 MB Application: beforeRenderModule mod_custom (Copyrights-zh)
時間: 0.84 ms / 480.85 ms 記憶體: 0.007 MB / 4.25 MB Application: afterRenderModule mod_custom (Copyrights-zh)
時間: 0.12 ms / 480.97 ms 記憶體: 0.002 MB / 4.25 MB Application: beforeRenderModule mod_custom (Language)
時間: 0.20 ms / 481.17 ms 記憶體: 0.003 MB / 4.26 MB Application: afterRenderModule mod_custom (Language)
時間: 0.10 ms / 481.27 ms 記憶體: 0.026 MB / 4.28 MB Application: beforeRenderModule mod_djmegamenu (DJ-MegaMenu-zh)
時間: 9.07 ms / 490.34 ms 記憶體: 0.128 MB / 4.41 MB Application: afterRenderModule mod_djmegamenu (DJ-MegaMenu-zh)
時間: 19.36 ms / 509.70 ms 記憶體: 0.129 MB / 4.54 MB Application: afterRender
資料庫查詢總計: 370.75 ms
4.94 MB (5,175,888 位元組)
34 查詢記錄 370.75 ms
- 查詢時間: 0.52 ms 查詢記憶體: 0.025 MB 記憶體於查詢: 1.204 MB 前 回傳的列: 0
SELECT `data`
FROM `pap1z_session`
WHERE `session_id` = 'qkaf499el5rnidq9co40inthde'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE pap1z_session NULL const PRIMARY PRIMARY 194 const 1 100.00 NULL Status Duration starting 0.08 ms checking permissions 0.02 ms Opening tables 0.04 ms init 0.03 ms System lock 0.02 ms optimizing 0.02 ms statistics 0.09 ms executing 0.03 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.03 ms # Caller 檔案與行號 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1734 15 JDatabaseDriver->loadResult() JROOT/libraries/joomla/session/storage/database.php:45 14 JSessionStorageDatabase->read() 與下面行一樣的呼叫 13 session_start() JROOT/libraries/joomla/session/handler/native.php:260 12 JSessionHandlerNative->doSessionStart() JROOT/libraries/joomla/session/handler/native.php:50 11 JSessionHandlerNative->start() JROOT/libraries/joomla/session/handler/joomla.php:88 10 JSessionHandlerJoomla->start() JROOT/libraries/src/Session/Session.php: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.43 ms 最後的查詢: 0.72 ms 之後 查詢記憶體: 0.022 MB 記憶體於查詢: 1.219 MB 前 回傳的列: 0
SELECT `session_id`
FROM `pap1z_session`
WHERE `session_id` = 'qkaf499el5rnidq9co40inthde'
LIMIT 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE pap1z_session NULL const PRIMARY PRIMARY 194 const 1 100.00 Using index Status Duration starting 0.06 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.03 ms System lock 0.02 ms optimizing 0.02 ms statistics 0.05 ms executing 0.02 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.03 ms # Caller 檔案與行號 9 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1734 8 JDatabaseDriver->loadResult() JROOT/libraries/src/Session/MetadataManager.php:74 7 Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() JROOT/libraries/src/Application/CMSApplication.php:153 6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:760 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:135 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:344 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - 查詢時間: 79.00 ms 最後的查詢: 0.18 ms 之後 查詢記憶體: 0.004 MB 記憶體於查詢: 1.287 MB 前
INSERT INTO `pap1z_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES ('qkaf499el5rnidq9co40inthde', 1, 1793089556, 0, '', 0)EXPLAIN 無法被使用於查詢: INSERT INTO `pap1z_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('qkaf499el5rnidq9co40inthde', 1, 1793089556, 0, '', 0)Status Duration starting 0.08 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.03 ms System lock 0.01 ms update 0.16 ms end 0.01 ms query end 78.36 ms closing tables 0.04 ms freeing items 0.04 ms cleaning up 0.12 ms # Caller 檔案與行號 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 - 查詢時間: 1.60 ms 最後的查詢: 1.02 ms 之後 查詢記憶體: 0.040 MB 記憶體於查詢: 1.322 MB 前 回傳的列: 39
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `pap1z_extensions`
WHERE `type` = 'component'
AND `state` = 0
AND `enabled` = 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE pap1z_extensions NULL ref extension extension 62 const 40 1.00 Using where Status Duration starting 0.10 ms checking permissions 0.02 ms Opening tables 0.03 ms init 0.05 ms System lock 0.02 ms optimizing 0.03 ms statistics 0.12 ms preparing 0.04 ms executing 0.01 ms Sending data 0.88 ms end 0.02 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.03 ms cleaning up 0.04 ms # Caller 檔案與行號 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 11 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Component/ComponentHelper.php:445 10 Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}() 與下面行一樣的呼叫 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 - 查詢時間: 8.65 ms 最後的查詢: 0.92 ms 之後 查詢記憶體: 0.023 MB 記憶體於查詢: 1.374 MB 前 回傳的列: 5
SELECT id, rules
FROM `pap1z_viewlevels`id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE pap1z_viewlevels NULL ALL NULL NO INDEX KEY COULD BE USED NULL NULL 5 100.00 NULL Status Duration starting 0.07 ms checking permissions 0.01 ms Opening tables 0.06 ms init 0.02 ms System lock 0.02 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.02 ms executing 0.01 ms Sending data 0.08 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 8.02 ms cleaning up 0.05 ms # Caller 檔案與行號 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1500 9 JDatabaseDriver->loadAssocList() JROOT/libraries/src/Access/Access.php:1063 8 Joomla\CMS\Access\Access::getAuthorisedViewLevels() JROOT/libraries/src/User/User.php:458 7 Joomla\CMS\User\User->getAuthorisedViewLevels() JROOT/libraries/src/Plugin/PluginHelper.php:321 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - 查詢時間: 0.77 ms 最後的查詢: 0.30 ms 之後 查詢記憶體: 0.022 MB 記憶體於查詢: 1.386 MB 前 回傳的列: 0
SELECT b.id
FROM pap1z_usergroups AS a
LEFT JOIN pap1z_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 13id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE NULL NULL NULL NULL NO INDEX KEY COULD BE USED NULL NULL NULL NULL no matching row in const table Status Duration starting 0.12 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.04 ms init 0.05 ms System lock 0.02 ms optimizing 0.03 ms statistics 0.11 ms executing 0.03 ms end 0.01 ms query end 0.02 ms closing tables 0.02 ms freeing items 0.07 ms cleaning up 0.05 ms # Caller 檔案與行號 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1544 10 JDatabaseDriver->loadColumn() JROOT/libraries/src/Access/Access.php:980 9 Joomla\CMS\Access\Access::getGroupsByUser() JROOT/libraries/src/Access/Access.php:1095 8 Joomla\CMS\Access\Access::getAuthorisedViewLevels() JROOT/libraries/src/User/User.php:458 7 Joomla\CMS\User\User->getAuthorisedViewLevels() JROOT/libraries/src/Plugin/PluginHelper.php:321 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - 查詢時間: 2.21 ms 最後的查詢: 0.35 ms 之後 查詢記憶體: 0.034 MB 記憶體於查詢: 1.408 MB 前 回傳的列: 96
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM pap1z_extensions
WHERE enabled = 1
AND type = 'plugin'
AND state IN (0,1)
AND access IN (1,1)
ORDER BY orderingid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE pap1z_extensions NULL ref extension extension 62 const 142 0.40 Using index condition; Using where; 使用filesort Status Duration starting 0.10 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.05 ms System lock 0.02 ms optimizing 0.02 ms statistics 0.10 ms preparing 0.05 ms Sorting result 0.02 ms executing 0.01 ms Sending data 0.02 ms Creating sort index 1.35 ms end 0.01 ms query end 0.02 ms closing tables 0.01 ms freeing items 0.08 ms cleaning up 0.03 ms # Caller 檔案與行號 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 10 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Plugin/PluginHelper.php:354 9 Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}() 與下面行一樣的呼叫 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.79 ms 最後的查詢: 14.03 ms 之後 查詢記憶體: 0.026 MB 記憶體於查詢: 1.994 MB 前 回傳的列: 2
SELECT *
FROM pap1z_languages
WHERE published=1
ORDER BY ordering ASCid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE pap1z_languages NULL ALL NULL NO INDEX KEY COULD BE USED NULL NULL 2 50.00 Using where; 使用filesort Status Duration starting 0.07 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.05 ms System lock 0.02 ms optimizing 0.02 ms statistics 0.03 ms preparing 0.03 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.02 ms Creating sort index 0.12 ms end 0.01 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.07 ms cleaning up 0.03 ms # Caller 檔案與行號 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 9 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Language/LanguageHelper.php:150 8 Joomla\CMS\Language\LanguageHelper::getLanguages() JROOT/plugins/system/languagefilter/languagefilter.php:96 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.83 ms 最後的查詢: 0.28 ms 之後 查詢記憶體: 0.023 MB 記憶體於查詢: 2.005 MB 前 回傳的列: 4
SELECT `element`,`name`,`client_id`,`extension_id`
FROM `pap1z_extensions`
WHERE `type` = 'language'
AND `state` = 0
AND `enabled` = 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE pap1z_extensions NULL ref extension extension 62 const 4 1.25 Using where Status Duration starting 0.08 ms checking permissions 0.02 ms Opening tables 0.02 ms init 0.04 ms System lock 0.02 ms optimizing 0.02 ms statistics 0.09 ms preparing 0.03 ms executing 0.01 ms Sending data 0.09 ms end 0.01 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.07 ms cleaning up 0.03 ms # Caller 檔案與行號 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 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 - 查詢時間: 2.22 ms 最後的查詢: 11.09 ms 之後 查詢記憶體: 0.029 MB 記憶體於查詢: 2.114 MB 前 回傳的列: 135
SHOW TABLES
EXPLAIN 無法被使用於查詢: SHOW TABLESStatus Duration starting 0.05 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.06 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.02 ms executing 0.01 ms checking permissions 1.22 ms Sending data 0.32 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms removing tmp table 0.01 ms closing tables 0.01 ms freeing items 0.07 ms cleaning up 0.04 ms # Caller 檔案與行號 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1544 10 JDatabaseDriver->loadColumn() JROOT/libraries/joomla/database/driver/mysqli.php:502 9 JDatabaseDriverMysqli->getTableList() JROOT/plugins/system/jdownloads/jdownloads.php:78 8 plgSystemjdownloads->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.30 ms 最後的查詢: 0.29 ms 之後 查詢記憶體: 0.022 MB 記憶體於查詢: 2.139 MB 前 回傳的列: 0
SELECT file_id
from pap1z_jdownloads_files
WHERE published = 1
AND use_timeframe = 1
AND publish_to != '0000-00-00 00:00:00'
AND publish_to <= '2026-10-27 16:25:56'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE pap1z_jdownloads_files NULL ALL idx_published NO INDEX KEY COULD BE USED NULL NULL 1237 2.94 Using where Status Duration starting 0.08 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.05 ms System lock 0.02 ms optimizing 0.02 ms statistics 0.09 ms preparing 0.03 ms executing 0.01 ms Sending data 1.58 ms end 0.02 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.07 ms cleaning up 0.04 ms # Caller 檔案與行號 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1544 9 JDatabaseDriver->loadColumn() JROOT/plugins/system/jdownloads/jdownloads.php:106 8 plgSystemjdownloads->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.72 ms 最後的查詢: 0.12 ms 之後 查詢記憶體: 0.022 MB 記憶體於查詢: 2.144 MB 前 回傳的列: 0
SELECT file_id
from pap1z_jdownloads_files
WHERE published = 0
AND use_timeframe = 1
AND publish_from != '0000-00-00 00:00:00'
AND publish_from <= '2026-10-27 16:25:56'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE pap1z_jdownloads_files NULL ref idx_published idx_published 1 const 4 3.00 Using where Status Duration starting 0.07 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.04 ms System lock 0.02 ms optimizing 0.02 ms statistics 0.08 ms preparing 0.03 ms executing 0.01 ms Sending data 0.07 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.07 ms cleaning up 0.05 ms # Caller 檔案與行號 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1544 9 JDatabaseDriver->loadColumn() JROOT/plugins/system/jdownloads/jdownloads.php:114 8 plgSystemjdownloads->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 - 查詢時間: 3.39 ms 最後的查詢: 1.63 ms 之後 查詢記憶體: 0.113 MB 記憶體於查詢: 2.162 MB 前 回傳的列: 61
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 pap1z_menu AS m
LEFT JOIN pap1z_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 partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL range idx_client_id_parent_id_alias_language idx_client_id_parent_id_alias_language 5 NULL 104 10.00 Using index condition; Using where; 使用filesort 1 SIMPLE e NULL eq_ref PRIMARY PRIMARY 4 amspt.m.component_id 1 100.00 Using where Status Duration starting 0.14 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.06 ms System lock 0.02 ms optimizing 0.02 ms statistics 0.13 ms preparing 0.04 ms Sorting result 0.02 ms executing 0.01 ms Sending data 0.03 ms Creating sort index 2.51 ms end 0.01 ms query end 0.02 ms closing tables 0.02 ms freeing items 0.08 ms cleaning up 0.04 ms # Caller 檔案與行號 23 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 22 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Menu/SiteMenu.php:93 21 Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}() 與下面行一樣的呼叫 20 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 19 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Menu/SiteMenu.php:101 18 Joomla\CMS\Menu\SiteMenu->load() JROOT/libraries/src/Menu/AbstractMenu.php: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.93 ms 最後的查詢: 6.40 ms 之後 查詢記憶體: 0.027 MB 記憶體於查詢: 2.617 MB 前 回傳的列: 1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `pap1z_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE pap1z_extensions NULL ref element_clientid,element_folder_clientid,extension extension 364 const,const 1 100.00 NULL Status Duration starting 0.10 ms checking permissions 0.02 ms Opening tables 0.03 ms init 0.04 ms System lock 0.02 ms optimizing 0.02 ms statistics 0.15 ms preparing 0.03 ms executing 0.01 ms Sending data 0.09 ms end 0.01 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.07 ms cleaning up 0.05 ms # Caller 檔案與行號 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1656 18 JDatabaseDriver->loadObject() JROOT/libraries/src/Helper/LibraryHelper.php:167 17 Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}() 與下面行一樣的呼叫 16 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 15 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/LibraryHelper.php:175 14 Joomla\CMS\Helper\LibraryHelper::loadLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:43 13 Joomla\CMS\Helper\LibraryHelper::getLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:90 12 Joomla\CMS\Helper\LibraryHelper::getParams() JROOT/libraries/src/Version.php:321 11 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 10 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 9 Joomla\CMS\Factory::getDocument() JROOT/plugins/system/djjquerymonster/djjquerymonster.php:58 8 plgSystemDJjQueryMonster->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 - 查詢時間: 155.19 ms 最後的查詢: 0.35 ms 之後 查詢記憶體: 0.006 MB 記憶體於查詢: 2.609 MB 前
UPDATE `pap1z_extensions`
SET `params` = '{\"mediaversion\":\"05f33aa4eff4a3bebaa62e87fc7938de\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 UPDATE pap1z_extensions NULL range element_clientid,element_folder_clientid,extension extension 364 const,const 1 100.00 Using where Status Duration starting 0.08 ms checking permissions 0.01 ms Opening tables 0.04 ms init 0.04 ms System lock 0.13 ms updating 0.15 ms end 0.02 ms query end 154.28 ms closing tables 0.05 ms freeing items 0.09 ms cleaning up 0.06 ms # Caller 檔案與行號 14 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Helper/LibraryHelper.php:117 13 Joomla\CMS\Helper\LibraryHelper::saveParams() JROOT/libraries/src/Version.php:372 12 Joomla\CMS\Version->setMediaVersion() JROOT/libraries/src/Version.php:331 11 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 10 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 9 Joomla\CMS\Factory::getDocument() JROOT/plugins/system/djjquerymonster/djjquerymonster.php:58 8 plgSystemDJjQueryMonster->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 - 查詢時間: 1.36 ms 最後的查詢: 1.02 ms 之後 查詢記憶體: 0.024 MB 記憶體於查詢: 2.637 MB 前 回傳的列: 5
SELECT id, home, template, s.params
FROM pap1z_template_styles as s
LEFT JOIN pap1z_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 partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE s NULL ALL idx_template NO INDEX KEY COULD BE USED NULL NULL 7 14.29 Using where 1 SIMPLE e NULL ref element_clientid,element_folder_clientid,extension element_clientid 303 amspt.s.template,const 1 4.33 Using index condition; Using where Status Duration starting 0.17 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.04 ms init 0.07 ms System lock 0.02 ms optimizing 0.04 ms statistics 0.18 ms preparing 0.05 ms executing 0.01 ms Sending data 0.29 ms end 0.01 ms query end 0.02 ms closing tables 0.02 ms freeing items 0.09 ms cleaning up 0.03 ms # Caller 檔案與行號 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 11 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Application/SiteApplication.php:486 10 Joomla\CMS\Application\SiteApplication->getTemplate() JROOT/plugins/system/ef4_jmframework/ef4_jmframework.php:987 9 plgSystemEF4_JMFramework->getTemplateName() JROOT/plugins/system/ef4_jmframework/ef4_jmframework.php:210 8 plgSystemEF4_JMFramework->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 - 查詢時間: 2.24 ms 最後的查詢: 6.88 ms 之後 查詢記憶體: 0.030 MB 記憶體於查詢: 2.845 MB 前 回傳的列: 135
SHOW TABLES
EXPLAIN 無法被使用於查詢: SHOW TABLESStatus Duration starting 0.07 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.07 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.02 ms executing 0.01 ms checking permissions 1.15 ms Sending data 0.32 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms removing tmp table 0.01 ms closing tables 0.01 ms freeing items 0.07 ms cleaning up 0.05 ms # Caller 檔案與行號 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1544 10 JDatabaseDriver->loadColumn() JROOT/libraries/joomla/database/driver/mysqli.php:502 9 JDatabaseDriverMysqli->getTableList() JROOT/plugins/system/jdownloads/jdownloads.php:353 8 plgSystemjdownloads->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 - 查詢時間: 2.00 ms 最後的查詢: 3.18 ms 之後 查詢記憶體: 0.030 MB 記憶體於查詢: 2.990 MB 前 回傳的列: 39
SELECT `id`,`name`,`rules`,`parent_id`
FROM `pap1z_assets`
WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_akeeba','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_djcatalog2','com_djmediatools','com_fields','com_finder','com_installer','com_jdownloads','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_tags','com_templates','com_users','com_weblinks','com_wrapper')id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE pap1z_assets NULL range idx_asset_name idx_asset_name 152 NULL 40 100.00 Using index condition Status Duration starting 0.18 ms checking permissions 0.02 ms Opening tables 0.03 ms init 0.10 ms System lock 0.02 ms optimizing 0.02 ms statistics 0.40 ms preparing 0.03 ms executing 0.01 ms Sending data 0.78 ms end 0.01 ms query end 0.03 ms closing tables 0.02 ms freeing items 0.07 ms cleaning up 0.05 ms # Caller 檔案與行號 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 17 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Access/Access.php:429 16 Joomla\CMS\Access\Access::preloadComponents() JROOT/libraries/src/Access/Access.php:213 15 Joomla\CMS\Access\Access::preload() JROOT/libraries/src/Access/Access.php:531 14 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 13 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 12 Joomla\CMS\User\User->authorise() JROOT/components/com_content/models/article.php:58 11 ContentModelArticle->populateState() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:440 10 Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() JROOT/components/com_content/models/article.php:251 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - 查詢時間: 3.54 ms 最後的查詢: 0.43 ms 之後 查詢記憶體: 0.054 MB 記憶體於查詢: 3.040 MB 前 回傳的列: 258
SELECT `id`,`name`,`rules`,`parent_id`
FROM `pap1z_assets`
WHERE `name` LIKE 'com_content.%' OR `name` = 'com_content' OR `parent_id` = 0id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE pap1z_assets NULL ALL idx_asset_name,idx_parent_id NO INDEX KEY COULD BE USED NULL NULL 1320 21.05 Using where Status Duration starting 0.09 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.05 ms System lock 0.02 ms optimizing 0.02 ms statistics 0.13 ms preparing 0.03 ms executing 0.01 ms Sending data 2.05 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.09 ms cleaning up 0.03 ms # Caller 檔案與行號 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 17 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Access/Access.php:359 16 Joomla\CMS\Access\Access::preloadPermissions() JROOT/libraries/src/Access/Access.php:226 15 Joomla\CMS\Access\Access::preload() JROOT/libraries/src/Access/Access.php:540 14 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 13 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 12 Joomla\CMS\User\User->authorise() JROOT/components/com_content/models/article.php:58 11 ContentModelArticle->populateState() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:440 10 Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() JROOT/components/com_content/models/article.php:251 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - 查詢時間: 1.99 ms 最後的查詢: 1.87 ms 之後 查詢記憶體: 0.035 MB 記憶體於查詢: 3.279 MB 前 回傳的列: 31
SHOW FULL COLUMNS
FROM `pap1z_content`EXPLAIN 無法被使用於查詢: SHOW FULL COLUMNS FROM `pap1z_content`Status Duration starting 0.06 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.28 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.02 ms executing 0.02 ms Opening tables 0.04 ms checking permissions 0.08 ms checking permissions 0.04 ms checking permissions 0.04 ms checking permissions 0.03 ms checking permissions 0.04 ms checking permissions 0.02 ms checking permissions 0.06 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.03 ms Sending data 0.18 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms removing tmp table 0.07 ms closing tables 0.01 ms freeing items 0.07 ms cleaning up 0.04 ms # Caller 檔案與行號 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 15 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:445 14 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:245 13 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:164 12 Joomla\CMS\Table\Table->__construct() JROOT/libraries/src/Table/Content.php:39 11 Joomla\CMS\Table\Content->__construct() JROOT/libraries/src/Table/Table.php:312 10 Joomla\CMS\Table\Table::getInstance() JROOT/components/com_content/models/article.php:253 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - 查詢時間: 0.94 ms 最後的查詢: 1.59 ms 之後 查詢記憶體: 0.046 MB 記憶體於查詢: 3.361 MB 前 回傳的列: 1
SELECT *
FROM pap1z_content
WHERE `id` = '152'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE pap1z_content NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.06 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.05 ms System lock 0.02 ms optimizing 0.02 ms statistics 0.11 ms preparing 0.03 ms executing 0.01 ms Sending data 0.19 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.08 ms cleaning up 0.04 ms # Caller 檔案與行號 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1459 11 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/Table.php:731 10 Joomla\CMS\Table\Table->load() JROOT/components/com_content/models/article.php:254 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - 查詢時間: 81.31 ms 最後的查詢: 0.28 ms 之後 查詢記憶體: 0.005 MB 記憶體於查詢: 3.391 MB 前
UPDATE pap1z_content
SET `hits` = (`hits` + 1)
WHERE `id` = '152'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 UPDATE pap1z_content NULL range PRIMARY PRIMARY 4 const 1 100.00 Using where Status Duration starting 0.09 ms checking permissions 0.02 ms Opening tables 0.03 ms init 0.03 ms System lock 0.07 ms updating 0.15 ms end 0.02 ms query end 80.44 ms closing tables 0.06 ms freeing items 0.10 ms cleaning up 0.04 ms # Caller 檔案與行號 11 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Table/Table.php:1245 10 Joomla\CMS\Table\Table->hit() JROOT/components/com_content/models/article.php:255 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - 查詢時間: 2.21 ms 最後的查詢: 1.25 ms 之後 查詢記憶體: 0.036 MB 記憶體於查詢: 3.478 MB 前 回傳的列: 1
SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
FROM pap1z_content AS a
INNER JOIN pap1z_categories AS c
on c.id = a.catid
LEFT JOIN pap1z_users AS u
on u.id = a.created_by
LEFT JOIN pap1z_categories as parent
ON parent.id = c.parent_id
LEFT JOIN pap1z_content_rating AS v
ON a.id = v.content_id
WHERE a.id = 152
AND c.published > 0
AND a.language in ('zh-TW','*')
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-10-27 08:25:56')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-10-27 08:25:56')
AND (a.state = 1 OR a.state =2)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL const PRIMARY,idx_state,idx_catid,idx_language PRIMARY 4 const 1 100.00 NULL 1 SIMPLE c NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 SIMPLE u NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 SIMPLE parent NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 SIMPLE v NULL const PRIMARY PRIMARY 4 const 0 0.00 unique row not found Status Duration starting 0.38 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.06 ms init 0.17 ms System lock 0.03 ms optimizing 0.05 ms statistics 0.32 ms preparing 0.05 ms executing 0.01 ms Sending data 0.22 ms end 0.01 ms query end 0.02 ms closing tables 0.02 ms freeing items 0.16 ms cleaning up 0.06 ms # Caller 檔案與行號 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1656 13 JDatabaseDriver->loadObject() JROOT/components/com_content/models/article.php:151 12 ContentModelArticle->getItem() JROOT/libraries/src/MVC/View/HtmlView.php:425 11 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_content/views/article/view.html.php:42 10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - 查詢時間: 0.99 ms 最後的查詢: 2.03 ms 之後 查詢記憶體: 0.034 MB 記憶體於查詢: 3.554 MB 前 回傳的列: 0
SELECT `m`.`tag_id`,`t`.*
FROM `pap1z_contentitem_tag_map` AS m
INNER JOIN `pap1z_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 152
AND `t`.`published` = 1
AND t.access IN (1,1)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL ALL idx_tag_type NO INDEX KEY COULD BE USED NULL NULL 1 100.00 Using where 1 SIMPLE t NULL eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 amspt.m.tag_id 1 100.00 Using where Status Duration starting 0.12 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.08 ms System lock 0.02 ms optimizing 0.03 ms statistics 0.17 ms preparing 0.05 ms executing 0.01 ms Sending data 0.07 ms end 0.01 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.08 ms cleaning up 0.03 ms # Caller 檔案與行號 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 12 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Helper/TagsHelper.php:454 11 Joomla\CMS\Helper\TagsHelper->getItemTags() JROOT/components/com_content/views/article/view.html.php:184 10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - 查詢時間: 1.37 ms 最後的查詢: 10.11 ms 之後 查詢記憶體: 0.038 MB 記憶體於查詢: 3.714 MB 前 回傳的列: 2
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM `pap1z_categories` AS `s`
INNER JOIN `pap1z_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)
AND c.published = 1
AND s.id = 94
ORDER BY c.lftid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE s NULL const PRIMARY,idx_left_right PRIMARY 4 const 1 100.00 使用filesort 1 SIMPLE c NULL ALL cat_idx,idx_access,idx_left_right,idx_language NO INDEX KEY COULD BE USED NULL NULL 20 37.33 Using where Status Duration starting 0.22 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.11 ms System lock 0.02 ms optimizing 0.03 ms statistics 0.23 ms preparing 0.05 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.04 ms Creating sort index 0.19 ms end 0.01 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.09 ms cleaning up 0.05 ms # Caller 檔案與行號 21 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 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_content/views/article/view.html.php:193 10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - 查詢時間: 2.06 ms 最後的查詢: 0.51 ms 之後 查詢記憶體: 0.037 MB 記憶體於查詢: 3.735 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 pap1z_fields AS a
LEFT JOIN `pap1z_languages` AS l
ON l.lang_code = a.language
LEFT JOIN pap1z_users AS uc
ON uc.id=a.checked_out
LEFT JOIN pap1z_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN pap1z_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN pap1z_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `pap1z_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 (94,0))
AND a.access IN (1,1)
AND (a.group_id = 0 OR g.access IN (1,1))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
AND a.language in ('*','zh-TW')
ORDER BY a.ordering ASCid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL ref idx_state,idx_access,idx_context,idx_language idx_state 1 const 1 100.00 Using index condition; Using where; Using temporary; 使用filesort 1 SIMPLE l NULL eq_ref idx_langcode idx_langcode 21 amspt.a.language 1 100.00 NULL 1 SIMPLE uc NULL eq_ref PRIMARY PRIMARY 4 amspt.a.checked_out 1 100.00 NULL 1 SIMPLE ag NULL eq_ref PRIMARY PRIMARY 4 amspt.a.access 1 100.00 Using where 1 SIMPLE ua NULL eq_ref PRIMARY PRIMARY 4 amspt.a.created_user_id 1 100.00 Using where 1 SIMPLE g NULL eq_ref PRIMARY PRIMARY 4 amspt.a.group_id 1 100.00 Using where 1 SIMPLE fc NULL ref PRIMARY PRIMARY 4 amspt.a.id 1 100.00 Using where; Using index; Distinct Status Duration starting 0.28 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.06 ms init 0.13 ms System lock 0.02 ms optimizing 0.04 ms statistics 0.27 ms preparing 0.07 ms Creating tmp table 0.11 ms Sorting result 0.02 ms executing 0.01 ms Sending data 0.42 ms Creating sort index 0.07 ms end 0.01 ms query end 0.02 ms removing tmp table 0.08 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.09 ms cleaning up 0.05 ms # Caller 檔案與行號 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 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_content/views/article/view.html.php:193 10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - 查詢時間: 0.87 ms 最後的查詢: 1.33 ms 之後 查詢記憶體: 0.026 MB 記憶體於查詢: 3.828 MB 前 回傳的列: 1
SELECT MAX(contact.id) AS contactid, contact.alias, contact.catid, contact.webpage, contact.email_to
FROM `pap1z_contact_details` AS `contact`
WHERE contact.published = 1
AND contact.user_id = 728
AND (contact.language in ('zh-TW','*') OR contact.language IS NULL)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE contact NULL ALL idx_state,idx_language NO INDEX KEY COULD BE USED NULL NULL 3 33.33 Using where Status Duration starting 0.11 ms checking permissions 0.02 ms Opening tables 0.02 ms init 0.07 ms System lock 0.02 ms optimizing 0.03 ms statistics 0.10 ms preparing 0.04 ms executing 0.01 ms Sending data 0.08 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.08 ms cleaning up 0.03 ms # Caller 檔案與行號 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1656 15 JDatabaseDriver->loadObject() JROOT/plugins/content/contact/contact.php:125 14 PlgContentContact->getContactData() JROOT/plugins/content/contact/contact.php:66 13 PlgContentContact->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_content/views/article/view.html.php:193 10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - 查詢時間: 1.14 ms 最後的查詢: 4.51 ms 之後 查詢記憶體: 0.022 MB 記憶體於查詢: 3.849 MB 前 回傳的列: 1
SELECT language,id
FROM `pap1z_menu`
WHERE home = 1
AND published = 1
AND client_id = 0id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE pap1z_menu NULL ref idx_client_id_parent_id_alias_language idx_client_id_parent_id_alias_language 1 const 105 1.00 Using where Status Duration starting 0.08 ms checking permissions 0.02 ms Opening tables 0.03 ms init 0.03 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.08 ms preparing 0.03 ms executing 0.01 ms Sending data 0.47 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.07 ms cleaning up 0.03 ms # Caller 檔案與行號 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 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.81 ms 最後的查詢: 0.68 ms 之後 查詢記憶體: 0.023 MB 記憶體於查詢: 3.861 MB 前 回傳的列: 0
SELECT `c2`.`language`,`c2`.`id`
FROM `pap1z_menu` AS `c`
INNER JOIN `pap1z_associations` AS `a`
ON a.id = c.`id`
AND a.context='com_menus.item'
INNER JOIN `pap1z_associations` AS `a2`
ON `a`.`key` = `a2`.`key`
INNER JOIN `pap1z_menu` AS `c2`
ON a2.id = c2.`id`
WHERE c.id = 736id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE NULL NULL NULL NULL NO INDEX KEY COULD BE USED NULL NULL NULL NULL no matching row in const table Status Duration starting 0.11 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.04 ms init 0.06 ms System lock 0.02 ms optimizing 0.03 ms statistics 0.14 ms executing 0.03 ms end 0.01 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.07 ms cleaning up 0.04 ms # Caller 檔案與行號 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 10 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Language/Associations.php:115 9 Joomla\CMS\Language\Associations::getAssociations() JROOT/administrator/components/com_menus/helpers/menus.php:321 8 MenusHelper::getAssociations() JROOT/plugins/system/languagefilter/languagefilter.php:768 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 - 查詢時間: 1.16 ms 最後的查詢: 0.73 ms 之後 查詢記憶體: 0.023 MB 記憶體於查詢: 3.872 MB 前 回傳的列: 0
SELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`,CONCAT_WS(':', ca.id, ca.alias) AS `catid`
FROM `pap1z_content` AS `c`
INNER JOIN `pap1z_associations` AS `a`
ON a.id = c.`id`
AND a.context='com_content.item'
INNER JOIN `pap1z_associations` AS `a2`
ON `a`.`key` = `a2`.`key`
INNER JOIN `pap1z_content` AS `c2`
ON a2.id = c2.`id`
INNER JOIN `pap1z_categories` AS `ca`
ON `c2`.`catid` = ca.id
AND ca.extension = 'com_content'
WHERE c.id = 152
AND c2.access IN (1,1)
AND c2.language != 'zh-TW'
AND (c2.publish_up = '0000-00-00 00:00:00' OR c2.publish_up <= '2026-10-27 08:25:56')
AND (c2.publish_down = '0000-00-00 00:00:00' OR c2.publish_down >= '2026-10-27 08:25:56')
AND c2.state = 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE NULL NULL NULL NULL NO INDEX KEY COULD BE USED NULL NULL NULL NULL no matching row in const table Status Duration starting 0.22 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.04 ms init 0.10 ms System lock 0.02 ms optimizing 0.05 ms statistics 0.29 ms executing 0.03 ms end 0.01 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.08 ms cleaning up 0.03 ms # Caller 檔案與行號 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 10 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Language/Associations.php:115 9 Joomla\CMS\Language\Associations::getAssociations() JROOT/components/com_content/helpers/association.php:76 8 ContentHelperAssociation::getAssociations() JROOT/plugins/system/languagefilter/languagefilter.php:783 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.64 ms 最後的查詢: 3.32 ms 之後 查詢記憶體: 0.023 MB 記憶體於查詢: 3.995 MB 前 回傳的列: 7
SELECT id
FROM pap1z_template_styles
ORDER BY idid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE pap1z_template_styles NULL index NULL PRIMARY 4 NULL 7 100.00 Using index Status Duration starting 0.06 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.02 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.06 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.07 ms cleaning up 0.04 ms # Caller 檔案與行號 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1544 10 JDatabaseDriver->loadColumn() JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:319 9 JMFTemplate->setup() JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:126 8 JMFTemplate->__construct() JROOT/templates/jm-exclusive-furniture-ef4/index.php:18 7 require JROOT/templates/jm-exclusive-furniture-ef4/index.php JROOT/libraries/src/Document/HtmlDocument.php:658 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:720 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:535 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1030 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - 查詢時間: 3.31 ms 最後的查詢: 3.30 ms 之後 查詢記憶體: 0.045 MB 記憶體於查詢: 4.141 MB 前 回傳的列: 6
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM pap1z_modules AS m
LEFT JOIN pap1z_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN pap1z_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
WHERE m.published = 1
AND e.enabled = 1
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2026-10-27 08:25:56')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-10-27 08:25:56')
AND m.access IN (1,1)
AND m.client_id = 0
AND (mm.menuid = 736 OR mm.menuid <= 0)
AND m.language IN ('zh-TW','*')
ORDER BY m.position, m.orderingid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL range PRIMARY,published,newsfeeds,idx_language published 5 NULL 53 1.46 Using index condition; Using where; 使用filesort 1 SIMPLE e NULL ref element_clientid,element_folder_clientid element_clientid 303 amspt.m.module,const 1 10.00 Using index condition; Using where 1 SIMPLE mm NULL ref PRIMARY PRIMARY 4 amspt.m.id 3 40.00 Using where; Using index Status Duration starting 0.17 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.04 ms init 0.10 ms System lock 0.02 ms optimizing 0.04 ms statistics 0.22 ms preparing 0.06 ms Sorting result 0.02 ms executing 0.01 ms Sending data 0.02 ms Creating sort index 2.20 ms end 0.02 ms query end 0.02 ms closing tables 0.02 ms freeing items 0.08 ms cleaning up 0.04 ms # Caller 檔案與行號 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 18 JDatabaseDriver->loadObjectList() 與下面行一樣的呼叫 17 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 16 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:432 15 Joomla\CMS\Helper\ModuleHelper::getModuleList() JROOT/libraries/src/Helper/ModuleHelper.php:362 14 Joomla\CMS\Helper\ModuleHelper::load() JROOT/libraries/src/Helper/ModuleHelper.php:87 13 Joomla\CMS\Helper\ModuleHelper::getModules() JROOT/libraries/src/Document/HtmlDocument.php:581 12 Joomla\CMS\Document\HtmlDocument->countModules() JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:466 11 JMFTemplate->countModules() JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:459 10 JMFTemplate->checkModules() JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:1698 9 JMFTemplate->getAllColumnsClasses() JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:191 8 JMFTemplate->__construct() JROOT/templates/jm-exclusive-furniture-ef4/index.php:18 7 require JROOT/templates/jm-exclusive-furniture-ef4/index.php JROOT/libraries/src/Document/HtmlDocument.php:658 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:720 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:535 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1030 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - 查詢時間: 1.07 ms 最後的查詢: 23.87 ms 之後 查詢記憶體: 0.025 MB 記憶體於查詢: 4.399 MB 前 回傳的列: 1
SELECT manifest_cache
FROM pap1z_extensions
WHERE element='mod_djmegamenu'
LIMIT 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE pap1z_extensions NULL ref element_clientid,element_folder_clientid element_clientid 302 const 1 100.00 NULL Status Duration starting 0.15 ms checking permissions 0.02 ms Opening tables 0.04 ms init 0.05 ms System lock 0.02 ms optimizing 0.02 ms statistics 0.21 ms preparing 0.03 ms executing 0.01 ms Sending data 0.09 ms end 0.01 ms query end 0.02 ms closing tables 0.02 ms freeing items 0.08 ms cleaning up 0.05 ms # Caller 檔案與行號 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1734 12 JDatabaseDriver->loadResult() JROOT/modules/mod_djmegamenu/helper.php:313 11 modDJMMHelper::getVersion() JROOT/modules/mod_djmegamenu/mod_djmegamenu.php:80 10 include JROOT/modules/mod_djmegamenu/mod_djmegamenu.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1044 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - 查詢時間: 2.17 ms 最後的查詢: 18.83 ms 之後 查詢記憶體: 0.029 MB 記憶體於查詢: 4.521 MB 前 回傳的列: 135
SHOW TABLES
EXPLAIN 無法被使用於查詢: SHOW TABLESStatus Duration starting 0.05 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.07 ms init 0.02 ms System lock 0.02 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.03 ms executing 0.02 ms checking permissions 1.19 ms Sending data 0.32 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms removing tmp table 0.01 ms closing tables 0.01 ms freeing items 0.07 ms cleaning up 0.05 ms # Caller 檔案與行號 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1544 9 JDatabaseDriver->loadColumn() JROOT/libraries/joomla/database/driver/mysqli.php:502 8 JDatabaseDriverMysqli->getTableList() JROOT/plugins/system/jdownloads/jdownloads.php:253 7 plgSystemjdownloads->onAfterRender() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1050 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
29 查詢種類已記錄，由呈現記錄儲存。
選擇表格:
2 × SELECT file_id
from pap1z_jdownloads_files2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `pap1z_extensions`2 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `pap1z_assets`1 × SELECT `data`
FROM `pap1z_session`1 × SELECT `m`.`tag_id`,`t`.*
FROM `pap1z_contentitem_tag_map` AS m
INNER JOIN `pap1z_tags` AS t
ON `m`.`tag_id` = `t`.`id`1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM pap1z_modules AS m
LEFT JOIN pap1z_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN pap1z_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id1 × SELECT id
FROM pap1z_template_styles1 × SELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`,CONCAT_WS(':', ca.id, ca.alias) AS `catid`
FROM `pap1z_content` AS `c`
INNER JOIN `pap1z_associations` AS `a`
ON a.id = c.`id`
AND a.context='com_content.item'
INNER JOIN `pap1z_associations` AS `a2`
ON `a`.`key` = `a2`.`key`
INNER JOIN `pap1z_content` AS `c2`
ON a2.id = c2.`id`
INNER JOIN `pap1z_categories` AS `ca`
ON `c2`.`catid` = ca.id
AND ca.extension = 'com_content'1 × SELECT `c2`.`language`,`c2`.`id`
FROM `pap1z_menu` AS `c`
INNER JOIN `pap1z_associations` AS `a`
ON a.id = c.`id`
AND a.context='com_menus.item'
INNER JOIN `pap1z_associations` AS `a2`
ON `a`.`key` = `a2`.`key`
INNER JOIN `pap1z_menu` AS `c2`
ON a2.id = c2.`id`1 × SELECT language,id
FROM `pap1z_menu`1 × SELECT MAX(contact.id) AS contactid, contact.alias, contact.catid, contact.webpage, contact.email_to
FROM `pap1z_contact_details` AS `contact`1 × 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 pap1z_fields AS a
LEFT JOIN `pap1z_languages` AS l
ON l.lang_code = a.language
LEFT JOIN pap1z_users AS uc
ON uc.id=a.checked_out
LEFT JOIN pap1z_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN pap1z_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN pap1z_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `pap1z_fields_categories` AS fc
ON fc.field_id = a.id1 × 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 `pap1z_categories` AS `s`
INNER JOIN `pap1z_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)1 × SELECT *
FROM pap1z_content1 × SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
FROM pap1z_content AS a
INNER JOIN pap1z_categories AS c
on c.id = a.catid
LEFT JOIN pap1z_users AS u
on u.id = a.created_by
LEFT JOIN pap1z_categories as parent
ON parent.id = c.parent_id
LEFT JOIN pap1z_content_rating AS v
ON a.id = v.content_id1 × SELECT `session_id`
FROM `pap1z_session`1 × SELECT id, home, template, s.params
FROM pap1z_template_styles as s
LEFT JOIN pap1z_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id1 × 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 pap1z_menu AS m
LEFT JOIN pap1z_extensions AS e
ON m.component_id = e.extension_id1 × SELECT `element`,`name`,`client_id`,`extension_id`
FROM `pap1z_extensions`1 × SELECT *
FROM pap1z_languages1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM pap1z_extensions1 × SELECT b.id
FROM pap1z_usergroups AS a
LEFT JOIN pap1z_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt1 × SELECT id, rules
FROM `pap1z_viewlevels1 × SELECT manifest_cache
FROM pap1z_extensions
其他表格:
3 × SHOW TABLE
1 × INSERT INTO `pap1z_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES ('qkaf499el5rnidq9co40inthde', 1, 1793089556, 0, '', 01 × UPDATE `pap1z_extensions`
SET `params` = '{\"mediaversion\":\"05f33aa4eff4a3bebaa62e87fc7938de\"}'1 × SHOW FULL COLUMNS
FROM `pap1z_content1 × UPDATE pap1z_content
SET `hits` = (`hits` + 1)