網站導覽
(1) 導覽連結區、(2) 主要內容區、(3) 相關內容區，以及(4) 網頁資訊區。
本網站的便捷鍵﹝Accesskey,也稱為快速鍵﹞設定如下：
Alt+U：上方導覽連結區，此區塊列有本網站的主要連結。
Alt+L：左方相關內容區，此區塊呈現同層次的相關項目。
Alt+C：中間主要內容區，主要內容區塊呈現各網頁的主要內容。
Alt+B：下方網頁資訊區，此區塊包括本站聯絡地址、電話等相關資訊。
Joomla! 除錯主控台
{
"__default": {
"session": {
"counter": 1,
"timer": {
"start": 1685909322,
"last": 1685909322,
"now": 1685909322
},
"token": "EZ12o5xiieY7H9j2TCbxPSN1akDujmeS"
},
"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"
}
}
}
時間
記憶體
時間: 2.92 ms / 2.92 ms 記憶體: 0.413 MB / 0.74 MB Application: afterLoad
時間: 67.23 ms / 70.15 ms 記憶體: 1.854 MB / 2.60 MB Application: afterInitialise
時間: 13.47 ms / 83.62 ms 記憶體: 0.754 MB / 3.35 MB Application: afterRoute
時間: 0.23 ms / 83.84 ms 記憶體: 0.017 MB / 3.37 MB Application: beforeRenderComponent com_content
時間: 1.24 ms / 85.08 ms 記憶體: 0.062 MB / 3.43 MB Application: Before Access::preloadComponents (all components)
時間: 0.95 ms / 86.04 ms 記憶體: 0.056 MB / 3.49 MB Application: After Access::preloadComponents (all components)
時間: 0.02 ms / 86.06 ms 記憶體: -0.004 MB / 3.48 MB Application: Before Access::preloadPermissions (com_content)
時間: 1.12 ms / 87.18 ms 記憶體: 0.144 MB / 3.63 MB Application: After Access::preloadPermissions (com_content)
時間: 0.02 ms / 87.20 ms 記憶體: -0.011 MB / 3.62 MB Application: Before Access::getAssetRules (id:128 name:com_content.article.28)
時間: 0.22 ms / 87.42 ms 記憶體: 0.009 MB / 3.63 MB Application: After Access::getAssetRules (id:128 name:com_content.article.28)
時間: 18.41 ms / 105.83 ms 記憶體: 0.421 MB / 4.05 MB Application: Before Access::getAssetRules (id:1 name:root.1)
時間: 0.03 ms / 105.87 ms 記憶體: 0.007 MB / 4.05 MB Application: After Access::getAssetRules (id:1 name:root.1)
時間: 8.30 ms / 114.17 ms 記憶體: 0.409 MB / 4.46 MB Application: afterRenderComponent com_content
時間: 4.04 ms / 118.20 ms 記憶體: 0.053 MB / 4.52 MB Application: Before Access::getAssetRules (id:8 name:com_content)
時間: 0.05 ms / 118.25 ms 記憶體: 0.015 MB / 4.53 MB Application: After Access::getAssetRules (id:8 name:com_content)
時間: 1.14 ms / 119.38 ms 記憶體: 0.013 MB / 4.54 MB Application: afterDispatch
時間: 3.16 ms / 122.54 ms 記憶體: 0.286 MB / 4.83 MB Application: beforeRenderModule mod_custom_advanced (中間區塊導盲磚 :::)
時間: 0.39 ms / 122.93 ms 記憶體: 0.011 MB / 4.84 MB Application: afterRenderModule mod_custom_advanced (中間區塊導盲磚 :::)
時間: 0.16 ms / 123.09 ms 記憶體: 0.015 MB / 4.86 MB Application: beforeRenderModule mod_custom_advanced (網站導覽快速連結)
時間: 0.10 ms / 123.19 ms 記憶體: 0.019 MB / 4.88 MB Application: afterRenderModule mod_custom_advanced (網站導覽快速連結)
時間: 1.26 ms / 124.45 ms 記憶體: 0.080 MB / 4.96 MB Application: beforeRenderModule mod_custom_advanced (nknu_logo)
時間: 0.07 ms / 124.52 ms 記憶體: 0.005 MB / 4.96 MB Application: afterRenderModule mod_custom_advanced (nknu_logo)
時間: 0.06 ms / 124.57 ms 記憶體: 0.004 MB / 4.96 MB Application: beforeRenderModule mod_custom_advanced (AQI空氣品質指數)
時間: 1.05 ms / 125.62 ms 記憶體: 0.027 MB / 4.99 MB Application: afterRenderModule mod_custom_advanced (AQI空氣品質指數)
時間: 0.05 ms / 125.67 ms 記憶體: -0.003 MB / 4.99 MB Application: beforeRenderModule mod_custom_advanced (上方導覽連結區:::)
時間: 0.06 ms / 125.73 ms 記憶體: 0.005 MB / 4.99 MB Application: afterRenderModule mod_custom_advanced (上方導覽連結區:::)
時間: 0.02 ms / 125.75 ms 記憶體: -0.000 MB / 4.99 MB Application: beforeRenderModule mod_menu (top)
時間: 0.95 ms / 126.70 ms 記憶體: 0.021 MB / 5.01 MB Application: afterRenderModule mod_menu (top)
時間: 0.03 ms / 126.73 ms 記憶體: -0.002 MB / 5.01 MB Application: beforeRenderModule mod_languages (語言切換器)
時間: 0.94 ms / 127.68 ms 記憶體: 0.016 MB / 5.03 MB Application: afterRenderModule mod_languages (語言切換器)
時間: 0.05 ms / 127.72 ms 記憶體: 0.001 MB / 5.03 MB Application: beforeRenderModule mod_custom_advanced (關鍵字搜尋)
時間: 0.06 ms / 127.78 ms 記憶體: 0.006 MB / 5.03 MB Application: afterRenderModule mod_custom_advanced (關鍵字搜尋)
時間: 1.42 ms / 129.21 ms 記憶體: 0.037 MB / 5.07 MB Application: beforeRenderModule mod_menu (Main Menu)
時間: 1.13 ms / 130.33 ms 記憶體: 0.053 MB / 5.13 MB Application: afterRenderModule mod_menu (Main Menu)
時間: 1.29 ms / 131.62 ms 記憶體: -0.001 MB / 5.12 MB Application: beforeRenderModule mod_custom (學校連絡資訊)
時間: 0.38 ms / 132.00 ms 記憶體: 0.006 MB / 5.13 MB Application: afterRenderModule mod_custom (學校連絡資訊)
時間: 0.04 ms / 132.04 ms 記憶體: 0.002 MB / 5.13 MB Application: beforeRenderModule mod_custom_advanced (Google翻譯_zh)
時間: 0.05 ms / 132.09 ms 記憶體: 0.005 MB / 5.14 MB Application: afterRenderModule mod_custom_advanced (Google翻譯_zh)
時間: 0.14 ms / 132.23 ms 記憶體: 0.003 MB / 5.14 MB Application: beforeRenderModule mod_baccessibility (無障礙網頁)
時間: 0.39 ms / 132.61 ms 記憶體: 0.017 MB / 5.16 MB Application: afterRenderModule mod_baccessibility (無障礙網頁)
時間: 0.14 ms / 132.76 ms 記憶體: 0.013 MB / 5.17 MB Application: beforeRenderModule mod_menu (Main Menu-offcanvas)
時間: 0.63 ms / 133.38 ms 記憶體: 0.006 MB / 5.18 MB Application: afterRenderModule mod_menu (Main Menu-offcanvas)
時間: 0.03 ms / 133.41 ms 記憶體: -0.001 MB / 5.17 MB Application: beforeRenderModule mod_menu (top-offcanvas)
時間: 0.32 ms / 133.73 ms 記憶體: 0.006 MB / 5.18 MB Application: afterRenderModule mod_menu (top-offcanvas)
時間: 0.06 ms / 133.79 ms 記憶體: 0.003 MB / 5.18 MB Application: beforeRenderModule mod_custom_advanced (AQI空氣品質指數)
時間: 0.17 ms / 133.96 ms 記憶體: 0.007 MB / 5.19 MB Application: afterRenderModule mod_custom_advanced (AQI空氣品質指數)
時間: 0.03 ms / 133.98 ms 記憶體: -0.004 MB / 5.19 MB Application: beforeRenderModule mod_languages (語言切換器-offcanvas)
時間: 0.51 ms / 134.50 ms 記憶體: 0.005 MB / 5.19 MB Application: afterRenderModule mod_languages (語言切換器-offcanvas)
時間: 11.59 ms / 146.08 ms 記憶體: 0.071 MB / 5.26 MB Application: afterRender
資料庫查詢總計: 65.00 ms
5.62 MB (5,890,032 位元組)
29 查詢記錄 65.00 ms
- 查詢時間: 0.40 ms 查詢記憶體: 0.023 MB 記憶體於查詢: 1.024 MB 前 回傳的列: 0
SELECT `data`
FROM `x105_session`
WHERE `session_id` = X'366f6937616b696c6167716b3272646b396d6c70706d36306330'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE x105_session NULL const PRIMARY PRIMARY 194 const 1 100.00 NULL Status Duration starting 0.06 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.04 ms init 0.01 ms System lock 0.02 ms optimizing 0.02 ms statistics 0.09 ms executing 0.02 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Caller 檔案與行號 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 15 JDatabaseDriver->loadResult() JROOT/libraries/joomla/session/storage/database.php:45 14 JSessionStorageDatabase->read() 與下面行一樣的呼叫 13 session_start() JROOT/libraries/joomla/session/handler/native.php:260 12 JSessionHandlerNative->doSessionStart() JROOT/libraries/joomla/session/handler/native.php:50 11 JSessionHandlerNative->start() JROOT/libraries/joomla/session/handler/joomla.php:88 10 JSessionHandlerJoomla->start() JROOT/libraries/src/Session/Session.php:661 9 Joomla\CMS\Session\Session->_start() JROOT/libraries/src/Session/Session.php:621 8 Joomla\CMS\Session\Session->start() JROOT/libraries/src/Session/Session.php:499 7 Joomla\CMS\Session\Session->get() JROOT/libraries/src/Session/Session.php:456 6 Joomla\CMS\Session\Session->isNew() JROOT/libraries/src/Application/CMSApplication.php:826 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:136 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:386 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - 查詢時間: 0.23 ms 最後的查詢: 0.29 ms 之後 查詢記憶體: 0.020 MB 記憶體於查詢: 1.038 MB 前 回傳的列: 0
SELECT `session_id`
FROM `x105_session`
WHERE `session_id` = X'366f6937616b696c6167716b3272646b396d6c70706d36306330'
LIMIT 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE x105_session NULL const PRIMARY PRIMARY 194 const 1 100.00 Using index Status Duration starting 0.03 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.03 ms executing 0.01 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.02 ms # Caller 檔案與行號 9 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 8 JDatabaseDriver->loadResult() JROOT/libraries/src/Session/MetadataManager.php:74 7 Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() JROOT/libraries/src/Application/CMSApplication.php:154 6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:828 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:136 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:386 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - 查詢時間: 33.63 ms 最後的查詢: 0.09 ms 之後 查詢記憶體: 0.004 MB 記憶體於查詢: 1.043 MB 前
INSERT INTO `x105_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'366f6937616b696c6167716b3272646b396d6c70706d36306330', 1, 1685909322, 0, '', 0)EXPLAIN 無法被使用於查詢: INSERT INTO `x105_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'366f6937616b696c6167716b3272646b396d6c70706d36306330', 1, 1685909322, 0, '', 0)Status Duration starting 0.04 ms Executing hook on transaction 0.01 ms starting 0.03 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms update 0.25 ms end 0.01 ms query end 0.01 ms waiting for handler commit 33.14 ms closing tables 0.03 ms freeing items 0.02 ms cleaning up 0.01 ms # Caller 檔案與行號 8 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Session/MetadataManager.php:116 7 Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() JROOT/libraries/src/Application/CMSApplication.php:154 6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:828 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:136 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:386 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - 查詢時間: 0.67 ms 最後的查詢: 0.56 ms 之後 查詢記憶體: 0.024 MB 記憶體於查詢: 1.074 MB 前 回傳的列: 39
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `x105_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 x105_extensions NULL ref extension extension 82 const 40 1.00 Using where Status Duration starting 0.06 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.05 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.07 ms preparing 0.02 ms executing 0.24 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Caller 檔案與行號 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}() 與下面行一樣的呼叫 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - 查詢時間: 0.39 ms 最後的查詢: 0.51 ms 之後 查詢記憶體: 0.021 MB 記憶體於查詢: 1.102 MB 前 回傳的列: 5
SELECT id, rules
FROM `x105_viewlevels`id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE x105_viewlevels NULL ALL NULL NO INDEX KEY COULD BE USED NULL NULL 5 100.00 NULL Status Duration starting 0.04 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.04 ms init 0.01 ms System lock 0.02 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.02 ms executing 0.09 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Caller 檔案與行號 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506 9 JDatabaseDriver->loadAssocList() JROOT/libraries/src/Access/Access.php:1063 8 Joomla\CMS\Access\Access::getAuthorisedViewLevels() JROOT/libraries/src/User/User.php:458 7 Joomla\CMS\User\User->getAuthorisedViewLevels() JROOT/libraries/src/Plugin/PluginHelper.php:318 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - 查詢時間: 0.41 ms 最後的查詢: 0.11 ms 之後 查詢記憶體: 0.021 MB 記憶體於查詢: 1.114 MB 前 回傳的列: 2
SELECT b.id
FROM x105_usergroups AS a
LEFT JOIN x105_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 9id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 SIMPLE b NULL range idx_usergroup_nested_set_lookup idx_usergroup_nested_set_lookup 4 NULL 2 100.00 Using where; Using index Status Duration starting 0.05 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.04 ms init 0.01 ms System lock 0.02 ms optimizing 0.01 ms statistics 0.08 ms preparing 0.03 ms executing 0.04 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Caller 檔案與行號 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 10 JDatabaseDriver->loadColumn() JROOT/libraries/src/Access/Access.php:980 9 Joomla\CMS\Access\Access::getGroupsByUser() JROOT/libraries/src/Access/Access.php:1095 8 Joomla\CMS\Access\Access::getAuthorisedViewLevels() JROOT/libraries/src/User/User.php:458 7 Joomla\CMS\User\User->getAuthorisedViewLevels() JROOT/libraries/src/Plugin/PluginHelper.php:318 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - 查詢時間: 1.03 ms 最後的查詢: 0.16 ms 之後 查詢記憶體: 0.046 MB 記憶體於查詢: 1.135 MB 前 回傳的列: 111
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM x105_extensions
WHERE enabled = 1
AND type = 'plugin'
AND state IN (0,1)
AND access IN (1,1,5)
ORDER BY orderingid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE x105_extensions NULL ref extension extension 82 const 134 0.60 Using where; 使用filesort Status Duration starting 0.06 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.04 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.05 ms preparing 0.03 ms executing 0.65 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Caller 檔案與行號 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 10 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Plugin/PluginHelper.php:351 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:356 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - 查詢時間: 0.37 ms 最後的查詢: 0.38 ms 之後 查詢記憶體: 0.019 MB 記憶體於查詢: 1.201 MB 前 回傳的列: 2
SELECT *
FROM x105_languages
WHERE published=1
ORDER BY ordering ASCid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE x105_languages NULL ALL NULL NO INDEX KEY COULD BE USED NULL NULL 2 50.00 Using where; 使用filesort Status Duration starting 0.03 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.02 ms executing 0.07 ms end 0.02 ms query end 0.01 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Caller 檔案與行號 7 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 6 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Language/LanguageHelper.php:150 5 Joomla\CMS\Language\LanguageHelper::getLanguages() JROOT/libraries/src/Language/LanguageHelper.php:67 4 Joomla\CMS\Language\LanguageHelper::detectLanguage() JROOT/libraries/src/Application/SiteApplication.php:653 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - 查詢時間: 0.35 ms 最後的查詢: 7.25 ms 之後 查詢記憶體: 0.021 MB 記憶體於查詢: 1.925 MB 前 回傳的列: 8
SELECT `element`,`name`,`client_id`,`extension_id`
FROM `x105_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 x105_extensions NULL ref extension extension 82 const 8 1.00 Using where Status Duration starting 0.04 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.02 ms executing 0.06 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.02 ms # Caller 檔案與行號 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:280 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:667 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - 查詢時間: 1.43 ms 最後的查詢: 10.58 ms 之後 查詢記憶體: 0.161 MB 記憶體於查詢: 2.127 MB 前 回傳的列: 131
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 x105_menu AS m
LEFT JOIN x105_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 ALL idx_client_id_parent_id_alias_language NO INDEX KEY COULD BE USED NULL NULL 186 7.85 Using where; 使用filesort 1 SIMPLE e NULL eq_ref PRIMARY PRIMARY 4 nknu.m.component_id 1 100.00 Using where Status Duration starting 0.07 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.04 ms init 0.03 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.06 ms preparing 0.03 ms executing 1.01 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Caller 檔案與行號 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}() 與下面行一樣的呼叫 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:78 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:142 15 Joomla\CMS\Menu\AbstractMenu::getInstance() JROOT/libraries/src/Application/CMSApplication.php:417 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:65 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:533 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:668 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - 查詢時間: 0.37 ms 最後的查詢: 9.06 ms 之後 查詢記憶體: 0.025 MB 記憶體於查詢: 3.332 MB 前 回傳的列: 1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `x105_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE x105_extensions NULL ref element_clientid,element_folder_clientid,extension extension 484 const,const 1 100.00 NULL Status Duration starting 0.04 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.08 ms preparing 0.02 ms executing 0.03 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.02 ms # Caller 檔案與行號 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 19 JDatabaseDriver->loadObject() JROOT/libraries/src/Helper/LibraryHelper.php:167 18 Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}() 與下面行一樣的呼叫 17 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 16 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/LibraryHelper.php:175 15 Joomla\CMS\Helper\LibraryHelper::loadLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:43 14 Joomla\CMS\Helper\LibraryHelper::getLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:90 13 Joomla\CMS\Helper\LibraryHelper::getParams() JROOT/libraries/src/Version.php:321 12 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 11 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 10 Joomla\CMS\Factory::getDocument() JROOT/plugins/system/jqueryeasy/helper.php:18 9 plgJQueryEasyHelper::isEnabledOnPage() JROOT/plugins/system/jqueryeasy/jqueryeasy.php:73 8 plgSystemJqueryeasy->onAfterRoute() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1190 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - 查詢時間: 3.67 ms 最後的查詢: 0.13 ms 之後 查詢記憶體: 0.006 MB 記憶體於查詢: 3.325 MB 前
UPDATE `x105_extensions`
SET `params` = '{\"mediaversion\":\"da20181b2458f0a1d262f91ae83023f1\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'EXPLAIN 無法被使用於查詢: UPDATE `x105_extensions` SET `params` = '{\"mediaversion\":\"da20181b2458f0a1d262f91ae83023f1\"}' WHERE `type` = 'library' AND `element` = 'joomla'Status Duration starting 0.04 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.01 ms System lock 0.06 ms updating 0.12 ms end 0.01 ms query end 0.01 ms waiting for handler commit 3.25 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.02 ms # Caller 檔案與行號 15 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Helper/LibraryHelper.php:117 14 Joomla\CMS\Helper\LibraryHelper::saveParams() JROOT/libraries/src/Version.php:372 13 Joomla\CMS\Version->setMediaVersion() JROOT/libraries/src/Version.php:331 12 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 11 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 10 Joomla\CMS\Factory::getDocument() JROOT/plugins/system/jqueryeasy/helper.php:18 9 plgJQueryEasyHelper::isEnabledOnPage() JROOT/plugins/system/jqueryeasy/jqueryeasy.php:73 8 plgSystemJqueryeasy->onAfterRoute() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1190 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - 查詢時間: 0.49 ms 最後的查詢: 0.34 ms 之後 查詢記憶體: 0.021 MB 記憶體於查詢: 3.346 MB 前 回傳的列: 2
SELECT id, home, template, s.params
FROM x105_template_styles as s
LEFT JOIN x105_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 ref idx_template,idx_client_id,idx_client_id_home idx_client_id 1 const 2 100.00 NULL 1 SIMPLE e NULL ref element_clientid,element_folder_clientid,extension element_clientid 403 nknu.s.template,const 1 4.35 Using index condition; Using where Status Duration starting 0.08 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.05 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.08 ms preparing 0.02 ms executing 0.07 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.03 ms # Caller 檔案與行號 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Application/SiteApplication.php:486 10 Joomla\CMS\Application\SiteApplication->getTemplate() JROOT/plugins/system/jqueryeasy/helper.php:24 9 plgJQueryEasyHelper::isEnabledOnPage() JROOT/plugins/system/jqueryeasy/jqueryeasy.php:73 8 plgSystemJqueryeasy->onAfterRoute() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1190 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - 查詢時間: 0.79 ms 最後的查詢: 1.93 ms 之後 查詢記憶體: 0.027 MB 記憶體於查詢: 3.436 MB 前 回傳的列: 38
SELECT `id`,`name`,`rules`,`parent_id`
FROM `x105_assets`
WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_associations','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_imageshow','com_installer','com_jce','com_joomlaupdate','com_languages','com_login','com_mailto','com_maximenuck','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_sitemapgenerator','com_smartcountdown3','com_tags','com_templates','com_users','com_widgetkit','com_wrapper')id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE x105_assets NULL range idx_asset_name idx_asset_name 202 NULL 40 100.00 Using index condition Status Duration starting 0.06 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.04 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.13 ms preparing 0.02 ms executing 0.38 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Caller 檔案與行號 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 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:457 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:702 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - 查詢時間: 0.89 ms 最後的查詢: 0.15 ms 之後 查詢記憶體: 0.038 MB 記憶體於查詢: 3.485 MB 前 回傳的列: 137
SELECT `id`,`name`,`rules`,`parent_id`
FROM `x105_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 x105_assets NULL ALL idx_asset_name,idx_parent_id NO INDEX KEY COULD BE USED NULL NULL 332 23.81 Using where Status Duration starting 0.04 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.02 ms executing 0.33 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.28 ms # Caller 檔案與行號 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 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:457 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:702 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - 查詢時間: 2.27 ms 最後的查詢: 0.66 ms 之後 查詢記憶體: 0.031 MB 記憶體於查詢: 3.631 MB 前 回傳的列: 31
SHOW FULL COLUMNS
FROM `x105_content`EXPLAIN 無法被使用於查詢: SHOW FULL COLUMNS FROM `x105_content`Status Duration starting 0.06 ms Executing hook on transaction 0.01 ms starting 0.07 ms checking permissions 0.01 ms checking permissions 0.00 ms Opening tables 0.60 ms init 0.01 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.14 ms preparing 0.04 ms Creating tmp table 0.06 ms executing 0.09 ms checking permissions 0.07 ms checking permissions 0.03 ms checking permissions 0.03 ms checking permissions 0.03 ms checking permissions 0.03 ms checking permissions 0.02 ms checking permissions 0.03 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.05 ms checking permissions 0.03 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.03 ms checking permissions 0.02 ms checking permissions 0.03 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.03 ms checking permissions 0.02 ms checking permissions 0.04 ms checking permissions 0.02 ms checking permissions 0.05 ms checking permissions 0.04 ms checking permissions 0.03 ms checking permissions 0.03 ms checking permissions 0.03 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.07 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.02 ms closing tables 0.02 ms freeing items 0.04 ms cleaning up 0.01 ms # Caller 檔案與行號 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 15 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:448 14 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:261 13 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:180 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:328 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:702 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - 查詢時間: 9.90 ms 最後的查詢: 0.80 ms 之後 查詢記憶體: 0.006 MB 記憶體於查詢: 3.779 MB 前
UPDATE x105_content
SET `hits` = (`hits` + 1)
WHERE `id` = '28'EXPLAIN 無法被使用於查詢: UPDATE x105_content SET `hits` = (`hits` + 1) WHERE `id` = '28'Status Duration starting 0.04 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.01 ms System lock 0.07 ms updating 0.13 ms end 0.01 ms query end 0.01 ms waiting for handler commit 9.49 ms closing tables 0.02 ms freeing items 0.03 ms cleaning up 0.02 ms # Caller 檔案與行號 11 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Table/Table.php:1264 10 Joomla\CMS\Table\Table->hit() 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:702 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - 查詢時間: 0.77 ms 最後的查詢: 0.49 ms 之後 查詢記憶體: 0.023 MB 記憶體於查詢: 3.805 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 x105_content AS a
INNER JOIN x105_categories AS c
on c.id = a.catid
LEFT JOIN x105_users AS u
on u.id = a.created_by
LEFT JOIN x105_categories as parent
ON parent.id = c.parent_id
LEFT JOIN x105_content_rating AS v
ON a.id = v.content_id
WHERE a.id = 28
AND c.published > 0
AND a.language in ('zh-TW','*')
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-06-04 20:08:42')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-06-04 20:08:42')
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.13 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.01 ms Opening tables 0.14 ms init 0.01 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.18 ms preparing 0.02 ms executing 0.03 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.01 ms closing tables 0.02 ms freeing items 0.03 ms cleaning up 0.01 ms # Caller 檔案與行號 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 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:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - 查詢時間: 0.45 ms 最後的查詢: 0.95 ms 之後 查詢記憶體: 0.022 MB 記憶體於查詢: 3.858 MB 前 回傳的列: 0
SELECT `m`.`tag_id`,`t`.*
FROM `x105_contentitem_tag_map` AS m
INNER JOIN `x105_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 28
AND `t`.`published` = 1
AND t.access IN (1,1,5)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 nknu.m.tag_id 1 100.00 Using where Status Duration starting 0.05 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.06 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.08 ms preparing 0.03 ms executing 0.05 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Caller 檔案與行號 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 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:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - 查詢時間: 0.33 ms 最後的查詢: 1.20 ms 之後 查詢記憶體: 0.025 MB 記憶體於查詢: 3.953 MB 前 回傳的列: 1
SELECT `extension_id`,`name`,`enabled`,`params`
FROM x105_extensions
WHERE `type` = 'plugin'
AND `element` = 'osyoutube'
AND `folder` = 'content'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE x105_extensions NULL ref element_clientid,element_folder_clientid,extension element_clientid 402 const 1 5.00 Using where Status Duration starting 0.04 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.06 ms preparing 0.02 ms executing 0.03 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Caller 檔案與行號 21 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 20 JDatabaseDriver->loadObject() JROOT/libraries/allediaframework/Framework/Joomla/Extension/Generic.php:170 19 Alledia\Framework\Joomla\Extension\Generic->getDataFromDatabase() JROOT/libraries/allediaframework/Framework/Joomla/Extension/Generic.php:140 18 Alledia\Framework\Joomla\Extension\Generic->__construct() JROOT/libraries/allediaframework/Framework/Joomla/Extension/Licensed.php:62 17 Alledia\Framework\Joomla\Extension\Licensed->__construct() JROOT/libraries/allediaframework/Framework/Factory.php:63 16 Alledia\Framework\Factory::getExtension() JROOT/libraries/allediaframework/Framework/Joomla/Extension/AbstractPlugin.php:85 15 Alledia\Framework\Joomla\Extension\AbstractPlugin->loadExtension() JROOT/libraries/allediaframework/Framework/Joomla/Extension/AbstractPlugin.php:56 14 Alledia\Framework\Joomla\Extension\AbstractPlugin->init() JROOT/plugins/content/osyoutube/library/BasePlugin.php:56 13 Alledia\OSYouTube\BasePlugin->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:280 12 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 11 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/components/com_content/views/article/view.html.php:192 10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - 查詢時間: 0.59 ms 最後的查詢: 2.15 ms 之後 查詢記憶體: 0.026 MB 記憶體於查詢: 4.083 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 `x105_categories` AS `s`
INNER JOIN `x105_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 = 8
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 NULL 1 SIMPLE c NULL range cat_idx,idx_access,idx_left_right,idx_language idx_left_right 4 NULL 8 36.29 Using index condition; Using where Status Duration starting 0.11 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.05 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.12 ms preparing 0.03 ms executing 0.08 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Caller 檔案與行號 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:140 16 Joomla\CMS\MVC\Model\ListModel->_getListQuery() JROOT/libraries/src/MVC/Model/ListModel.php:194 15 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 14 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:495 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:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - 查詢時間: 0.77 ms 最後的查詢: 0.20 ms 之後 查詢記憶體: 0.025 MB 記憶體於查詢: 4.104 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 x105_fields AS a
LEFT JOIN `x105_languages` AS l
ON l.lang_code = a.language
LEFT JOIN x105_users AS uc
ON uc.id=a.checked_out
LEFT JOIN x105_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN x105_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN x105_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `x105_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 (8,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)
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_language,idx_context idx_state 1 const 1 100.00 Using where; Using temporary; 使用filesort 1 SIMPLE l NULL eq_ref idx_langcode idx_langcode 28 nknu.a.language 1 100.00 Using where 1 SIMPLE uc NULL eq_ref PRIMARY PRIMARY 4 nknu.a.checked_out 1 100.00 NULL 1 SIMPLE ag NULL eq_ref PRIMARY PRIMARY 4 nknu.a.access 1 100.00 Using where 1 SIMPLE ua NULL eq_ref PRIMARY PRIMARY 4 nknu.a.created_user_id 1 100.00 Using where 1 SIMPLE g NULL eq_ref PRIMARY PRIMARY 4 nknu.a.group_id 1 100.00 Using where 1 SIMPLE fc NULL ref PRIMARY PRIMARY 4 nknu.a.id 1 100.00 Using where; Using index; Distinct Status Duration starting 0.12 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.11 ms init 0.01 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.14 ms preparing 0.03 ms Creating tmp table 0.08 ms executing 0.06 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.02 ms closing tables 0.02 ms freeing items 0.03 ms cleaning up 0.01 ms # Caller 檔案與行號 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 18 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 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:194 15 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 14 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:495 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:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - 查詢時間: 0.31 ms 最後的查詢: 0.90 ms 之後 查詢記憶體: 0.025 MB 記憶體於查詢: 4.151 MB 前 回傳的列: 3
SELECT `name`, `value`
FROM `x105_jsn_imageshow_config`
WHERE `name` IN ('show_quick_icons', 'enable_update_checking', 'number_of_images_on_loading')id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE x105_jsn_imageshow_config NULL range name name 767 NULL 3 100.00 Using where Status Duration starting 0.04 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.01 ms executing 0.03 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Caller 檔案與行號 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 17 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_imageshow/classes/jsn_is_parameter.php:81 16 JSNISParameter->getParameters() JROOT/administrator/components/com_imageshow/imageshow.defines.php:27 15 require_once JROOT/administrator/components/com_imageshow/imageshow.defines.php JROOT/administrator/components/com_imageshow/classes/jsn_is_factory.php:16 14 include_once JROOT/administrator/components/com_imageshow/classes/jsn_is_factory.php JROOT/plugins/content/imageshow/imageshow.php:28 13 plgContentImageShow->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:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - 查詢時間: 0.32 ms 最後的查詢: 0.48 ms 之後 查詢記憶體: 0.023 MB 記憶體於查詢: 4.170 MB 前 回傳的列: 1重覆查詢: #29
SELECT *
FROM x105_extensions
WHERE element='com_imageshow'
AND type='component'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE x105_extensions NULL ref element_clientid,element_folder_clientid,extension element_clientid 402 const 1 10.00 Using where Status Duration starting 0.03 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.06 ms preparing 0.02 ms executing 0.04 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Caller 檔案與行號 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 15 JDatabaseDriver->loadObject() JROOT/administrator/components/com_imageshow/classes/jsn_is_utils.php:310 14 JSNISUtils->getComponentInfo() JROOT/plugins/content/imageshow/imageshow.php:45 13 plgContentImageShow->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:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - 查詢時間: 0.59 ms 最後的查詢: 6.08 ms 之後 查詢記憶體: 0.021 MB 記憶體於查詢: 4.496 MB 前 回傳的列: 3
SELECT language,id
FROM `x105_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 x105_menu NULL ref idx_client_id_parent_id_alias_language idx_client_id_parent_id_alias_language 1 const 147 1.00 Using where Status Duration starting 0.04 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.02 ms executing 0.30 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Caller 檔案與行號 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - 查詢時間: 0.43 ms 最後的查詢: 0.37 ms 之後 查詢記憶體: 0.021 MB 記憶體於查詢: 4.508 MB 前 回傳的列: 2
SELECT `c2`.`language`,`c2`.`id`
FROM `x105_menu` AS `c`
INNER JOIN `x105_associations` AS `a`
ON a.id = c.`id`
AND a.context='com_menus.item'
INNER JOIN `x105_associations` AS `a2`
ON `a`.`key` = `a2`.`key`
INNER JOIN `x105_menu` AS `c2`
ON a2.id = c2.`id`
WHERE c.id = 234id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE c NULL const PRIMARY PRIMARY 4 const 1 100.00 Using index 1 SIMPLE a NULL const PRIMARY,idx_key PRIMARY 206 const,const 1 100.00 NULL 1 SIMPLE a2 NULL ref idx_key idx_key 128 const 2 100.00 Using index 1 SIMPLE c2 NULL eq_ref PRIMARY PRIMARY 4 nknu.a2.id 1 100.00 NULL Status Duration starting 0.05 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.01 ms Opening tables 0.06 ms init 0.01 ms System lock 0.02 ms optimizing 0.02 ms statistics 0.09 ms preparing 0.02 ms executing 0.03 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Caller 檔案與行號 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - 查詢時間: 0.51 ms 最後的查詢: 0.30 ms 之後 查詢記憶體: 0.021 MB 記憶體於查詢: 4.533 MB 前 回傳的列: 0
SELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`,CONCAT_WS(':', ca.id, ca.alias) AS `catid`
FROM `x105_content` AS `c`
INNER JOIN `x105_associations` AS `a`
ON a.id = c.`id`
AND a.context='com_content.item'
INNER JOIN `x105_associations` AS `a2`
ON `a`.`key` = `a2`.`key`
INNER JOIN `x105_content` AS `c2`
ON a2.id = c2.`id`
INNER JOIN `x105_categories` AS `ca`
ON `c2`.`catid` = ca.id
AND ca.extension = 'com_content'
WHERE c.id = 28
AND c2.access IN (1,1,5)
AND c2.language != 'zh-TW'
AND (c2.publish_up = '0000-00-00 00:00:00' OR c2.publish_up <= '2023-06-04 20:08:42')
AND (c2.publish_down = '0000-00-00 00:00:00' OR c2.publish_down >= '2023-06-04 20:08:42')
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.08 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.01 ms Opening tables 0.06 ms init 0.01 ms System lock 0.01 ms optimizing 0.04 ms statistics 0.14 ms executing 0.02 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Caller 檔案與行號 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - 查詢時間: 2.30 ms 最後的查詢: 1.07 ms 之後 查詢記憶體: 0.261 MB 記憶體於查詢: 4.601 MB 前 回傳的列: 60
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM x105_modules AS m
LEFT JOIN x105_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN x105_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 <= '2023-06-04 20:08:42')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-06-04 20:08:42')
AND m.access IN (1,1,5)
AND m.client_id = 0
AND (mm.menuid = 234 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 ALL PRIMARY,published,newsfeeds,idx_language NO INDEX KEY COULD BE USED NULL NULL 132 1.48 Using where; 使用filesort 1 SIMPLE e NULL ref element_clientid,element_folder_clientid element_clientid 403 nknu.m.module,const 1 10.00 Using index condition; Using where 1 SIMPLE mm NULL ref PRIMARY PRIMARY 4 nknu.m.id 2 40.00 Using where; Using index Status Duration starting 0.08 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.01 ms Opening tables 0.07 ms init 0.01 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.10 ms preparing 0.05 ms executing 1.81 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Caller 檔案與行號 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 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:441 15 Joomla\CMS\Helper\ModuleHelper::getModuleList() JROOT/libraries/src/Helper/ModuleHelper.php:371 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:601 12 Joomla\CMS\Document\HtmlDocument->countModules() JROOT/templates/simple_v1/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:54 11 Warp\Joomla\Helper\WidgetsHelper->count() JROOT/templates/simple_v1/layouts/theme.config.php:26 10 include JROOT/templates/simple_v1/layouts/theme.config.php JROOT/templates/simple_v1/layouts/theme.php:10 9 include JROOT/templates/simple_v1/layouts/theme.php JROOT/templates/simple_v1/warp/src/Warp/Helper/TemplateHelper.php:49 8 Warp\Helper\TemplateHelper->render() JROOT/templates/simple_v1/index.php:16 7 require JROOT/templates/simple_v1/index.php JROOT/libraries/src/Document/HtmlDocument.php:678 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:740 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:555 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1098 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - 查詢時間: 0.35 ms 最後的查詢: 2.70 ms 之後 查詢記憶體: 0.029 MB 記憶體於查詢: 4.987 MB 前 回傳的列: 1重覆查詢: #24
SELECT *
FROM x105_extensions
WHERE element='com_imageshow'
AND type='component'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE x105_extensions NULL ref element_clientid,element_folder_clientid,extension element_clientid 402 const 1 10.00 Using where Status Duration starting 0.03 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.06 ms preparing 0.02 ms executing 0.04 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Caller 檔案與行號 26 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 25 JDatabaseDriver->loadObject() JROOT/administrator/components/com_imageshow/classes/jsn_is_utils.php:310 24 JSNISUtils->getComponentInfo() JROOT/plugins/content/imageshow/imageshow.php:45 23 plgContentImageShow->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 22 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 21 JEventDispatcher->trigger() JROOT/libraries/cms/html/content.php:41 20 JHtmlContent::prepare() 與下面行一樣的呼叫 19 call_user_func_array() JROOT/libraries/src/HTML/HTMLHelper.php:239 18 Joomla\CMS\HTML\HTMLHelper::call() JROOT/libraries/src/HTML/HTMLHelper.php:146 17 Joomla\CMS\HTML\HTMLHelper::_() JROOT/modules/mod_custom_advanced/mod_custom_advanced.php:52 16 include JROOT/modules/mod_custom_advanced/mod_custom_advanced.php JROOT/libraries/src/Helper/ModuleHelper.php:200 15 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 14 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/templates/simple_v1/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92 13 Warp\Joomla\Helper\WidgetsHelper->load() JROOT/templates/simple_v1/warp/systems/joomla/layouts/widgets.php:10 12 include JROOT/templates/simple_v1/warp/systems/joomla/layouts/widgets.php JROOT/templates/simple_v1/warp/src/Warp/Helper/TemplateHelper.php:49 11 Warp\Helper\TemplateHelper->render() JROOT/templates/simple_v1/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:69 10 Warp\Joomla\Helper\WidgetsHelper->render() JROOT/templates/simple_v1/layouts/theme.php:28 9 include JROOT/templates/simple_v1/layouts/theme.php JROOT/templates/simple_v1/warp/src/Warp/Helper/TemplateHelper.php:49 8 Warp\Helper\TemplateHelper->render() JROOT/templates/simple_v1/index.php:16 7 require JROOT/templates/simple_v1/index.php JROOT/libraries/src/Document/HtmlDocument.php:678 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:740 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:555 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1098 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
26 查詢種類已記錄，由呈現記錄儲存。
選擇表格:
2 × SELECT *
FROM x105_extensions2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `x105_extensions`2 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `x105_assets`1 × SELECT `data`
FROM `x105_session`1 × SELECT `extension_id`,`name`,`enabled`,`params`
FROM x105_extensions1 × SELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`,CONCAT_WS(':', ca.id, ca.alias) AS `catid`
FROM `x105_content` AS `c`
INNER JOIN `x105_associations` AS `a`
ON a.id = c.`id`
AND a.context='com_content.item'
INNER JOIN `x105_associations` AS `a2`
ON `a`.`key` = `a2`.`key`
INNER JOIN `x105_content` AS `c2`
ON a2.id = c2.`id`
INNER JOIN `x105_categories` AS `ca`
ON `c2`.`catid` = ca.id
AND ca.extension = 'com_content'1 × SELECT `c2`.`language`,`c2`.`id`
FROM `x105_menu` AS `c`
INNER JOIN `x105_associations` AS `a`
ON a.id = c.`id`
AND a.context='com_menus.item'
INNER JOIN `x105_associations` AS `a2`
ON `a`.`key` = `a2`.`key`
INNER JOIN `x105_menu` AS `c2`
ON a2.id = c2.`id`1 × SELECT language,id
FROM `x105_menu`1 × SELECT `name`, `value`
FROM `x105_jsn_imageshow_config`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 x105_fields AS a
LEFT JOIN `x105_languages` AS l
ON l.lang_code = a.language
LEFT JOIN x105_users AS uc
ON uc.id=a.checked_out
LEFT JOIN x105_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN x105_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN x105_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `x105_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 `x105_categories` AS `s`
INNER JOIN `x105_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 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 x105_content AS a
INNER JOIN x105_categories AS c
on c.id = a.catid
LEFT JOIN x105_users AS u
on u.id = a.created_by
LEFT JOIN x105_categories as parent
ON parent.id = c.parent_id
LEFT JOIN x105_content_rating AS v
ON a.id = v.content_id1 × SELECT `m`.`tag_id`,`t`.*
FROM `x105_contentitem_tag_map` AS m
INNER JOIN `x105_tags` AS t
ON `m`.`tag_id` = `t`.`id`1 × SELECT `session_id`
FROM `x105_session`1 × SELECT id, home, template, s.params
FROM x105_template_styles as s
LEFT JOIN x105_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 x105_menu AS m
LEFT JOIN x105_extensions AS e
ON m.component_id = e.extension_id1 × SELECT `element`,`name`,`client_id`,`extension_id`
FROM `x105_extensions`1 × SELECT *
FROM x105_languages1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM x105_extensions1 × SELECT b.id
FROM x105_usergroups AS a
LEFT JOIN x105_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt1 × SELECT id, rules
FROM `x105_viewlevels1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM x105_modules AS m
LEFT JOIN x105_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN x105_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
其他表格:
1 × INSERT INTO `x105_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'366f6937616b696c6167716b3272646b396d6c70706d36306330', 1, 1685909322, 0, '', 01 × UPDATE `x105_extensions`
SET `params` = '{\"mediaversion\":\"da20181b2458f0a1d262f91ae83023f1\"}'1 × SHOW FULL COLUMNS
FROM `x105_content1 × UPDATE x105_content
SET `hits` = (`hits` + 1)