在商业和开源数据库产品之间进行选择并不容易，因为许多流行的商业数据库以低成本甚至免费提供给开发人员或学生。在其他情况下，母公司提供类似其企业级产品的开源版本。
根据用户意见调查，查看所有数据库类型（无论是付费还是免费）的简介时，都会出现一个有趣的趋势。总体而言，似乎数据库系统（DBMS）的用户绝大部分时间都采用了开源解决方案。不是任何开源解决方案，而且是 MySQL。MySQL Community Edition多年来一直在“最受欢迎数据库平台”清单中排名第一。以下是 2019 年排名前 5 位的商业数据库和免费数据库，及其市场份额百分比：
- MySQL: 52%
- PostgreSQL: 36%
- MS SQL Server: 34%
- SQLite: 30%
- MongoDB: 26%
那么，为什么 MySQL 如此受欢迎呢？
它是开源的
如上所述，MySQL 是免费的，但它的价值比价格要高得多。MySQL 的另一个吸引人的特点是它是开源软件。这样就可以根据用户需要对其进行自定义或修改。此外，由于不需要许可证费用，因此许多公司为 MySQL 开发了第三方工具和界面。其中之一当然是Navicat for MySQL。
自从 90 年代中期由一家瑞典公司创立以来，MySQL 已多次被大型公司收购：昇阳微系统（Sun Microsystems）在 2008 年收购了 MySQL，然后被甲骨文公司（Oracle）在 2010 年收购。每次，人们都在猜测 MySQL 的免费状态很快就会改变。但是，到目前为止，情况并非如此。目前所有迹象表明 Oracle 将继续免费提供 MySQL Community Edition。
多功能性
MySQL 是功能非常强大的数据库。它具有足够的便携性以供开发使用，但也足以满足大多数任务关键应用。实际上，许多世界上最大、增长最快的组织，包括 Facebook、Google、Adobe、Alcatel Lucent 和 Zappos，都依靠 MySQL 来节省时间和金钱，以支持其高容量网站、关键业务系统和套装软件。
Web 应用程序的出现
有人提出，由小型初创公司或个人开发的 Web 应用程序的兴起以多种方式促成了 MySQL 的普及。同样，除价格外，MySQL 使用基本 SQL 且易于设置和配置使其成为许多 Web 应用程序的选择。
社区支持
MySQL 的另一个重要特点是支持它的庞大的在线社区。来自世界各地的自由开发人员都在不断增加数据库平台的功能和实用性。还可以从 Oracle 获得付费支持，但需要额外费用。
第三方软件
MySQL 受到极力追捧促使许多第三方供应商创建了与之配合使用的软件。其中包括开发和管理客户端（例如，Navicat for MySQL）和监控工具（例如，Navicat Monitor）。尽管这两种工具都不是免费的，但它们提供一个全包的前端来维持其优势，该前端具有用于数据库管理、开发和维护的直观而强大的图形界面。这样的工具功能强大且易于使用，可为开发人员和管理员节省时间和精力。
总结
拥有如此众多的强大功能，以及诸如 Navicat for MySQL 和 Navicat Monitor之类的高端用户工具的数目迅速增加，MySQL Community Edition 继续占据着关系数据库的榜首位置。
Joomla!调试控制台
{
"__default": {
"session": {
"counter": 1,
"timer": {
"start": 1790714029,
"last": 1790714029,
"now": 1790714029
}
},
"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-CN"
}
}
}
时间
内存
时间: 1.34 ms / 1.34 ms 内存: 0.433 MB / 0.77 MB Application: afterLoad
时间: 27.31 ms / 28.65 ms 内存: 4.027 MB / 4.79 MB Application: afterInitialise
时间: 2.87 ms / 31.52 ms 内存: 0.172 MB / 4.96 MB Application: afterRoute
时间: 3.40 ms / 34.92 ms 内存: 0.052 MB / 5.02 MB Application: beforeRenderComponent com_content
时间: 0.65 ms / 35.57 ms 内存: 0.194 MB / 5.21 MB Application: Before Access::preloadComponents (all components)
时间: 0.62 ms / 36.19 ms 内存: 0.053 MB / 5.26 MB Application: After Access::preloadComponents (all components)
时间: 0.02 ms / 36.21 ms 内存: -0.004 MB / 5.26 MB Application: Before Access::preloadPermissions (com_content)
时间: 2.10 ms / 38.31 ms 内存: 0.848 MB / 6.11 MB Application: After Access::preloadPermissions (com_content)
时间: 0.04 ms / 38.34 ms 内存: -0.034 MB / 6.07 MB Application: Before Access::getAssetRules (id:597 name:com_content.article.391)
时间: 0.14 ms / 38.49 ms 内存: 0.009 MB / 6.08 MB Application: After Access::getAssetRules (id:597 name:com_content.article.391)
时间: 7.76 ms / 46.24 ms 内存: 0.310 MB / 6.39 MB Application: Before Access::getAssetRules (id:1 name:root.1)
时间: 0.03 ms / 46.27 ms 内存: 0.007 MB / 6.40 MB Application: After Access::getAssetRules (id:1 name:root.1)
时间: 2.60 ms / 48.87 ms 内存: 0.111 MB / 6.51 MB Application: afterRenderComponent com_content
时间: 2.61 ms / 51.48 ms 内存: 0.038 MB / 6.55 MB Application: Before Access::getAssetRules (id:8 name:com_content)
时间: 0.01 ms / 51.50 ms 内存: 0.002 MB / 6.55 MB Application: After Access::getAssetRules (id:8 name:com_content)
时间: 0.93 ms / 52.42 ms 内存: 0.007 MB / 6.56 MB Application: afterDispatch
时间: 2.35 ms / 54.77 ms 内存: 0.065 MB / 6.62 MB Application: beforeRenderModule mod_custom (Navicat Footer)
时间: 0.25 ms / 55.02 ms 内存: 0.007 MB / 6.63 MB Application: afterRenderModule mod_custom (Navicat Footer)
时间: 0.05 ms / 55.07 ms 内存: -0.001 MB / 6.63 MB Application: beforeRenderModule mod_custom (Navicat Sitemap)
时间: 0.05 ms / 55.12 ms 内存: 0.003 MB / 6.63 MB Application: afterRenderModule mod_custom (Navicat Sitemap)
时间: 0.03 ms / 55.14 ms 内存: -0.001 MB / 6.63 MB Application: beforeRenderModule mod_addtoany (Share Button)
时间: 0.12 ms / 55.27 ms 内存: 0.007 MB / 6.64 MB Application: afterRenderModule mod_addtoany (Share Button)
时间: 0.01 ms / 55.28 ms 内存: -0.003 MB / 6.63 MB Application: beforeRenderModule mod_custom (Treeview menu in blog page)
时间: 0.04 ms / 55.32 ms 内存: 0.003 MB / 6.64 MB Application: afterRenderModule mod_custom (Treeview menu in blog page)
时间: 0.03 ms / 55.35 ms 内存: 0.001 MB / 6.64 MB Application: beforeRenderModule mod_custom (Navicat Banner Blog)
时间: 0.03 ms / 55.38 ms 内存: 0.003 MB / 6.64 MB Application: afterRenderModule mod_custom (Navicat Banner Blog)
时间: 0.02 ms / 55.40 ms 内存: -0.001 MB / 6.64 MB Application: beforeRenderModule mod_custom (Navicat Sub Navigation Bar About Us)
时间: 0.03 ms / 55.43 ms 内存: 0.004 MB / 6.64 MB Application: afterRenderModule mod_custom (Navicat Sub Navigation Bar About Us)
时间: 0.02 ms / 55.45 ms 内存: -0.000 MB / 6.64 MB Application: beforeRenderModule mod_finder (Navicat Index Page Smart Search)
时间: 2.38 ms / 57.83 ms 内存: 0.058 MB / 6.70 MB Application: afterRenderModule mod_finder (Navicat Index Page Smart Search)
时间: 0.06 ms / 57.89 ms 内存: -0.006 MB / 6.70 MB Application: beforeRenderModule mod_custom (Navicat Navigation Bar)
时间: 0.05 ms / 57.93 ms 内存: 0.003 MB / 6.70 MB Application: afterRenderModule mod_custom (Navicat Navigation Bar)
时间: 19.40 ms / 77.34 ms 内存: 0.176 MB / 6.88 MB Application: afterRender
数据库总查询：24.77 ms
7.36 MB (7,718,128 字节)
33条SQL查询记录 24.77 ms
- 查询时间：0.21 ms 查询内存： 0.023 MB 内存（查询 1.045 MB 之前） 返回排数：0
SELECT `data`
FROM `tbw0l_session`
WHERE `session_id` = X'3730376867713338756e68723538677471626e33696868737174'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE tbw0l_session NULL const PRIMARY PRIMARY 194 const 1 100.00 NULL Status Duration starting 0.04 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.00 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.04 ms executing 0.01 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.01 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 15 JDatabaseDriver->loadResult() JROOT/libraries/joomla/session/storage/database.php:45 14 JSessionStorageDatabase->read() Same as call in the line below. 13 session_start() JROOT/libraries/joomla/session/handler/native.php:260 12 JSessionHandlerNative->doSessionStart() JROOT/libraries/joomla/session/handler/native.php:50 11 JSessionHandlerNative->start() JROOT/libraries/joomla/session/handler/joomla.php:88 10 JSessionHandlerJoomla->start() JROOT/libraries/src/Session/Session.php: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:43 - 查询时间：0.16 ms 最后一次查询之后：0.24 ms 查询内存： 0.020 MB 内存（查询 1.059 MB 之前） 返回排数：0
SELECT `session_id`
FROM `tbw0l_session`
WHERE `session_id` = X'3730376867713338756e68723538677471626e33696868737174'
LIMIT 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE tbw0l_session NULL const PRIMARY PRIMARY 194 const 1 100.00 Using index Status Duration starting 0.03 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.00 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.02 ms executing 0.01 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.00 ms freeing items 0.01 ms cleaning up 0.01 ms # Caller File and line number 9 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 8 JDatabaseDriver->loadResult() JROOT/libraries/src/Session/MetadataManager.php:74 7 Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() JROOT/libraries/src/Application/CMSApplication.php: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:43 - 查询时间：2.09 ms 最后一次查询之后：0.07 ms 查询内存： 0.004 MB 内存（查询 1.064 MB 之前）
INSERT INTO `tbw0l_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'3730376867713338756e68723538677471626e33696868737174', 1, 1790714029, 0, '', 0)无法EXPLAIN（解释）的查询：INSERT INTO `tbw0l_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3730376867713338756e68723538677471626e33696868737174', 1, 1790714029, 0, '', 0)Status Duration starting 0.03 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.00 ms System lock 0.01 ms update 0.06 ms end 0.00 ms query end 0.00 ms waiting for handler commit 1.87 ms closing tables 0.02 ms freeing items 0.01 ms cleaning up 0.01 ms # Caller File and line number 8 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Session/MetadataManager.php:116 7 Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() JROOT/libraries/src/Application/CMSApplication.php: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:43 - 查询时间：0.32 ms 最后一次查询之后：0.29 ms 查询内存： 0.024 MB 内存（查询 1.096 MB 之前） 返回排数：35
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `tbw0l_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 tbw0l_extensions NULL ref extension extension 82 const 35 1.00 Using where Status Duration starting 0.04 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.00 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.01 ms executing 0.09 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Component/ComponentHelper.php:445 10 Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}() Same as call in the line below. 9 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 8 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Component/ComponentHelper.php:453 7 Joomla\CMS\Component\ComponentHelper::load() JROOT/libraries/src/Component/ComponentHelper.php:519 6 Joomla\CMS\Component\ComponentHelper::getComponents() JROOT/libraries/src/Component/ComponentHelper.php:44 5 Joomla\CMS\Component\ComponentHelper::getComponent() JROOT/libraries/src/Component/ComponentHelper.php:103 4 Joomla\CMS\Component\ComponentHelper::getParams() JROOT/libraries/src/Application/SiteApplication.php:594 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:46 - 查询时间：0.16 ms 最后一次查询之后：0.38 ms 查询内存： 0.021 MB 内存（查询 1.120 MB 之前） 返回排数：5
SELECT id, rules
FROM `tbw0l_viewlevels`id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE tbw0l_viewlevels NULL ALL NULL 没有可使用的索引键 NULL NULL 5 100.00 NULL Status Duration starting 0.02 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.00 ms System lock 0.00 ms optimizing 0.00 ms statistics 0.01 ms preparing 0.01 ms executing 0.02 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.00 ms freeing items 0.01 ms cleaning up 0.01 ms # Caller File and line number 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506 9 JDatabaseDriver->loadAssocList() JROOT/libraries/src/Access/Access.php:1063 8 Joomla\CMS\Access\Access::getAuthorisedViewLevels() JROOT/libraries/src/User/User.php:458 7 Joomla\CMS\User\User->getAuthorisedViewLevels() JROOT/libraries/src/Plugin/PluginHelper.php: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:46 - 查询时间：0.21 ms 最后一次查询之后：0.08 ms 查询内存： 0.021 MB 内存（查询 1.132 MB 之前） 返回排数：2
SELECT b.id
FROM tbw0l_usergroups AS a
LEFT JOIN tbw0l_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.03 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.00 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.02 ms executing 0.02 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.00 ms freeing items 0.01 ms cleaning up 0.01 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 10 JDatabaseDriver->loadColumn() JROOT/libraries/src/Access/Access.php:980 9 Joomla\CMS\Access\Access::getGroupsByUser() JROOT/libraries/src/Access/Access.php:1095 8 Joomla\CMS\Access\Access::getAuthorisedViewLevels() JROOT/libraries/src/User/User.php:458 7 Joomla\CMS\User\User->getAuthorisedViewLevels() JROOT/libraries/src/Plugin/PluginHelper.php: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:46 - 查询时间：0.49 ms 最后一次查询之后：0.11 ms 查询内存： 0.030 MB 内存（查询 1.153 MB 之前） 返回排数：85
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM tbw0l_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 tbw0l_extensions NULL ref extension extension 82 const 102 0.60 Using where; 使用filesort算法 Status Duration starting 0.04 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.00 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.02 ms executing 0.25 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 10 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Plugin/PluginHelper.php:351 9 Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}() Same as call in the line below. 8 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 7 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Plugin/PluginHelper.php: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:46 - 查询时间：0.19 ms 最后一次查询之后：2.99 ms 查询内存： 0.022 MB 内存（查询 1.557 MB 之前） 返回排数：1
SELECT `value`
FROM `tbw0l_admintools_storage`
WHERE `key` = 'cparams'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE tbw0l_admintools_storage NULL const PRIMARY PRIMARY 402 const 1 100.00 NULL Status Duration starting 0.04 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.00 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.02 ms executing 0.01 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.01 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 13 JDatabaseDriver->loadResult() JROOT/administrator/components/com_admintools/Helper/Storage.php:122 12 Akeeba\AdminTools\Admin\Helper\Storage->load() JROOT/administrator/components/com_admintools/Helper/Storage.php:37 11 Akeeba\AdminTools\Admin\Helper\Storage->__construct() JROOT/administrator/components/com_admintools/Helper/Storage.php:49 10 Akeeba\AdminTools\Admin\Helper\Storage::getInstance() JROOT/plugins/system/admintools/admintools/main.php:409 9 plgSystemAdmintools->loadComponentParameters() JROOT/plugins/system/admintools/admintools/main.php:892 8 plgSystemAdmintools->initialize() JROOT/plugins/system/admintools/admintools/main.php:84 7 plgSystemAdmintools->__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:46 - 查询时间：0.23 ms 最后一次查询之后：0.19 ms 查询内存： 0.022 MB 内存（查询 1.568 MB 之前） 返回排数：1
SELECT *
FROM tbw0l_languages
WHERE published=1
ORDER BY ordering ASCid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE tbw0l_languages NULL ALL NULL 没有可使用的索引键 NULL NULL 13 10.00 Using where; 使用filesort算法 Status Duration starting 0.02 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.00 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.02 ms executing 0.05 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.01 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 12 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Language/LanguageHelper.php:150 11 Joomla\CMS\Language\LanguageHelper::getLanguages() JROOT/plugins/system/admintools/admintools/main.php:700 10 plgSystemAdmintools->loadWAFExceptionsSEF() JROOT/plugins/system/admintools/admintools/main.php:640 9 plgSystemAdmintools->loadWAFExceptions() JROOT/plugins/system/admintools/admintools/main.php:901 8 plgSystemAdmintools->initialize() JROOT/plugins/system/admintools/admintools/main.php:84 7 plgSystemAdmintools->__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:46 - 查询时间：0.15 ms 最后一次查询之后：0.06 ms 查询内存： 0.021 MB 内存（查询 1.576 MB 之前） 返回排数：0
SELECT *
FROM `tbw0l_admintools_wafexceptions`
WHERE NOT(`option` LIKE 'com_%')id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE tbw0l_admintools_wafexceptions NULL ALL NULL 没有可使用的索引键 NULL NULL 1 100.00 Using where Status Duration starting 0.03 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.00 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms executing 0.01 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.00 ms freeing items 0.01 ms cleaning up 0.01 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506 11 JDatabaseDriver->loadAssocList() JROOT/plugins/system/admintools/admintools/main.php:729 10 plgSystemAdmintools->loadWAFExceptionsSEF() JROOT/plugins/system/admintools/admintools/main.php:640 9 plgSystemAdmintools->loadWAFExceptions() JROOT/plugins/system/admintools/admintools/main.php:901 8 plgSystemAdmintools->initialize() JROOT/plugins/system/admintools/admintools/main.php:84 7 plgSystemAdmintools->__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:46 - 查询时间：0.27 ms 最后一次查询之后：1.62 ms 查询内存： 0.023 MB 内存（查询 1.790 MB 之前） 返回排数：26
SELECT `element`,`name`,`client_id`,`extension_id`
FROM `tbw0l_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 tbw0l_extensions NULL ref extension extension 82 const 26 1.00 Using where Status Duration starting 0.03 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.00 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.01 ms executing 0.07 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.01 ms # Caller File and line number 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 9 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Language/LanguageHelper.php:209 8 Joomla\CMS\Language\LanguageHelper::getInstalledLanguages() JROOT/plugins/system/languagefilter/languagefilter.php:110 7 PlgSystemLanguageFilter->__construct() JROOT/libraries/src/Plugin/PluginHelper.php: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:46 - 查询时间：0.22 ms 最后一次查询之后：3.73 ms 查询内存： 0.021 MB 内存（查询 1.847 MB 之前） 返回排数：0
SELECT `source`,`keepurlparams`
FROM `tbw0l_admintools_redirects`
WHERE ((`dest` = 'company/aboutus/blog/391-%E4%B8%BA%E4%BB%80%E4%B9%88-mysql%EF%BC%88%E4%BB%8D%E7%84%B6%EF%BC%89%E5%B1%85%E6%9C%80%E5%8F%97%E6%AC%A2%E8%BF%8E%E6%95%B0%E6%8D%AE%E5%BA%93%E5%B9%B3%E5%8F%B0%E4%B9%8B%E9%A6%96') OR (`dest` = 'company/aboutus/blog/391-%E4%B8%BA%E4%BB%80%E4%B9%88-mysql%EF%BC%88%E4%BB%8D%E7%84%B6%EF%BC%89%E5%B1%85%E6%9C%80%E5%8F%97%E6%AC%A2%E8%BF%8E%E6%95%B0%E6%8D%AE%E5%BA%93%E5%B9%B3%E5%8F%B0%E4%B9%8B%E9%A6%96') OR ('company/aboutus/blog/391-%E4%B8%BA%E4%BB%80%E4%B9%88-mysql%EF%BC%88%E4%BB%8D%E7%84%B6%EF%BC%89%E5%B1%85%E6%9C%80%E5%8F%97%E6%AC%A2%E8%BF%8E%E6%95%B0%E6%8D%AE%E5%BA%93%E5%B9%B3%E5%8F%B0%E4%B9%8B%E9%A6%96' LIKE `dest`))
AND `published` = '1'
ORDER BY `ordering` DESC
LIMIT 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE tbw0l_admintools_redirects NULL ALL NULL 没有可使用的索引键 NULL NULL 1 100.00 Using where; 使用filesort算法 Status Duration starting 0.05 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.00 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.02 ms executing 0.02 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.00 ms freeing items 0.01 ms cleaning up 0.01 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1773 11 JDatabaseDriver->loadRow() JROOT/plugins/system/admintools/feature/urlredir.php:91 10 AtsystemFeatureUrlredir->onAfterInitialise() JROOT/plugins/system/admintools/admintools/main.php:308 9 plgSystemAdmintools->runFeature() JROOT/plugins/system/admintools/admintools/main.php:144 8 plgSystemAdmintools->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php: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:46 - 查询时间：4.43 ms 最后一次查询之后：0.70 ms 查询内存： 1.033 MB 内存（查询 1.889 MB 之前） 返回排数：730
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 tbw0l_menu AS m
LEFT JOIN tbw0l_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 没有可使用的索引键 NULL NULL 746 10.00 Using where; 使用filesort算法 1 SIMPLE e NULL eq_ref PRIMARY PRIMARY 4 cn_navicat_com_20230208.m.component_id 1 100.00 Using where Status Duration starting 0.05 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.00 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.02 ms executing 4.03 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.13 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.01 ms # Caller File and line number 23 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 22 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Menu/SiteMenu.php:93 21 Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}() Same as call in the line below. 20 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 19 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Menu/SiteMenu.php:101 18 Joomla\CMS\Menu\SiteMenu->load() JROOT/libraries/src/Menu/AbstractMenu.php: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:46 - 查询时间：0.38 ms 最后一次查询之后：5.21 ms 查询内存： 0.022 MB 内存（查询 4.956 MB 之前） 返回排数：0
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 `tbw0l_categories` AS `s`
INNER JOIN `tbw0l_categories` AS `c`
ON (s.lft < c.lft
AND c.lft < s.rgt
AND c.language IN ('zh-CN','*')) 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 = 391
ORDER BY c.lftid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE NULL NULL NULL NULL 没有可使用的索引键 NULL NULL NULL NULL no matching row in const table Status Duration starting 0.12 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.05 ms init 0.00 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.05 ms executing 0.02 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 13 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 12 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 11 Joomla\CMS\Categories\Categories->get() JROOT/components/com_content/helpers/legacyrouter.php:350 10 ContentRouterRulesLegacy->parse() JROOT/libraries/src/Component/Router/RouterView.php:266 9 Joomla\CMS\Component\Router\RouterView->parse() JROOT/libraries/src/Router/SiteRouter.php:438 8 Joomla\CMS\Router\SiteRouter->parseSefRoute() JROOT/libraries/src/Router/Router.php:482 7 Joomla\CMS\Router\Router->_parseSefRoute() JROOT/libraries/src/Router/Router.php:227 6 Joomla\CMS\Router\Router->parse() JROOT/libraries/src/Router/SiteRouter.php:139 5 Joomla\CMS\Router\SiteRouter->parse() JROOT/libraries/src/Application/CMSApplication.php:1142 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:46 - 查询时间：0.16 ms 最后一次查询之后：0.07 ms 查询内存： 0.021 MB 内存（查询 4.960 MB 之前） 返回排数：1
SELECT `alias`,`catid`
FROM `tbw0l_content`
WHERE `id` = 391id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE tbw0l_content NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.02 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.00 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.01 ms executing 0.01 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.00 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.01 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 11 JDatabaseDriver->loadObject() JROOT/components/com_content/helpers/legacyrouter.php:366 10 ContentRouterRulesLegacy->parse() JROOT/libraries/src/Component/Router/RouterView.php:266 9 Joomla\CMS\Component\Router\RouterView->parse() JROOT/libraries/src/Router/SiteRouter.php:438 8 Joomla\CMS\Router\SiteRouter->parseSefRoute() JROOT/libraries/src/Router/Router.php:482 7 Joomla\CMS\Router\Router->_parseSefRoute() JROOT/libraries/src/Router/Router.php:227 6 Joomla\CMS\Router\Router->parse() JROOT/libraries/src/Router/SiteRouter.php:139 5 Joomla\CMS\Router\SiteRouter->parse() JROOT/libraries/src/Application/CMSApplication.php:1142 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:46 - 查询时间：0.23 ms 最后一次查询之后：0.31 ms 查询内存： 0.022 MB 内存（查询 4.984 MB 之前） 返回排数：1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `tbw0l_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE tbw0l_extensions NULL ref element_clientid,element_folder_clientid,extension extension 484 const,const 1 100.00 NULL Status Duration starting 0.03 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.00 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.01 ms executing 0.02 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Caller File and line number 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 14 JDatabaseDriver->loadObject() JROOT/libraries/src/Helper/LibraryHelper.php:167 13 Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}() Same as call in the line below. 12 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 11 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/LibraryHelper.php:175 10 Joomla\CMS\Helper\LibraryHelper::loadLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:43 9 Joomla\CMS\Helper\LibraryHelper::getLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:90 8 Joomla\CMS\Helper\LibraryHelper::getParams() JROOT/libraries/src/Version.php:321 7 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 6 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 5 Joomla\CMS\Factory::getDocument() JROOT/libraries/src/Application/WebApplication.php:1137 4 Joomla\CMS\Application\WebApplication->loadDocument() JROOT/libraries/src/Application/SiteApplication.php:133 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:46 - 查询时间：2.19 ms 最后一次查询之后：0.09 ms 查询内存： 0.005 MB 内存（查询 4.976 MB 之前）
UPDATE `tbw0l_extensions`
SET `params` = '{\"mediaversion\":\"74d62e79338ef817613b0ff3c8bd0dbb\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'无法EXPLAIN（解释）的查询：UPDATE `tbw0l_extensions` SET `params` = '{\"mediaversion\":\"74d62e79338ef817613b0ff3c8bd0dbb\"}' WHERE `type` = 'library' AND `element` = 'joomla'Status Duration starting 0.03 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.00 ms System lock 0.04 ms updating 0.06 ms end 0.00 ms query end 0.00 ms waiting for handler commit 1.96 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Caller File and line number 10 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Helper/LibraryHelper.php:117 9 Joomla\CMS\Helper\LibraryHelper::saveParams() JROOT/libraries/src/Version.php:372 8 Joomla\CMS\Version->setMediaVersion() JROOT/libraries/src/Version.php:331 7 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 6 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 5 Joomla\CMS\Factory::getDocument() JROOT/libraries/src/Application/WebApplication.php:1137 4 Joomla\CMS\Application\WebApplication->loadDocument() JROOT/libraries/src/Application/SiteApplication.php:133 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:46 - 查询时间：0.30 ms 最后一次查询之后：0.32 ms 查询内存： 0.019 MB 内存（查询 5.011 MB 之前） 返回排数：4
SELECT id, home, template, s.params
FROM tbw0l_template_styles as s
LEFT JOIN tbw0l_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 e NULL ref element_clientid,element_folder_clientid,extension extension 82 const 6 1.00 Using index condition; Using where 1 SIMPLE s NULL ref idx_template,idx_client_id,idx_client_id_home idx_template 202 cn_navicat_com_20230208.e.element 1 66.67 Using index condition; Using where Status Duration starting 0.04 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.00 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.07 ms preparing 0.02 ms executing 0.05 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.01 ms # Caller File and line number 6 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 5 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Application/SiteApplication.php:486 4 Joomla\CMS\Application\SiteApplication->getTemplate() JROOT/libraries/src/Application/SiteApplication.php:168 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:46 - 查询时间：0.48 ms 最后一次查询之后：0.86 ms 查询内存： 0.027 MB 内存（查询 5.214 MB 之前） 返回排数：35
SELECT `id`,`name`,`rules`,`parent_id`
FROM `tbw0l_assets`
WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_admintools','com_ajax','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_installer','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_wrapper')id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE tbw0l_assets NULL range idx_asset_name idx_asset_name 202 NULL 36 100.00 Using index condition Status Duration starting 0.05 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.00 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.06 ms preparing 0.01 ms executing 0.24 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.00 ms freeing items 0.01 ms cleaning up 0.01 ms # Caller File and line number 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:46 - 查询时间：1.30 ms 最后一次查询之后：0.12 ms 查询内存： 0.180 MB 内存（查询 5.260 MB 之前） 返回排数：1022
SELECT `id`,`name`,`rules`,`parent_id`
FROM `tbw0l_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 tbw0l_assets NULL ALL idx_asset_name,idx_parent_id 没有可使用的索引键 NULL NULL 1208 22.96 Using where Status Duration starting 0.06 ms Executing hook on transaction 0.00 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.97 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Caller File and line number 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:46 - 查询时间：1.51 ms 最后一次查询之后：1.04 ms 查询内存： 0.031 MB 内存（查询 6.084 MB 之前） 返回排数：31
SHOW FULL COLUMNS
FROM `tbw0l_content`无法EXPLAIN（解释）的查询：SHOW FULL COLUMNS FROM `tbw0l_content`Status Duration starting 0.05 ms Executing hook on transaction 0.00 ms starting 0.04 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.43 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.06 ms preparing 0.02 ms Creating tmp table 0.05 ms executing 0.06 ms checking permissions 0.05 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.06 ms checking permissions 0.03 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 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 checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.05 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.02 ms closing tables 0.01 ms freeing items 0.05 ms cleaning up 0.01 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 15 JDatabaseDriver->loadObjectList() JROOT/libraries/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:46 - 查询时间：2.07 ms 最后一次查询之后：0.46 ms 查询内存： 0.005 MB 内存（查询 6.145 MB 之前）
UPDATE tbw0l_content
SET `hits` = (`hits` + 1)
WHERE `id` = '391'无法EXPLAIN（解释）的查询：UPDATE tbw0l_content SET `hits` = (`hits` + 1) WHERE `id` = '391'Status Duration starting 0.03 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.03 ms Opening tables 0.02 ms init 0.00 ms System lock 0.04 ms updating 0.06 ms end 0.00 ms query end 0.00 ms waiting for handler commit 1.80 ms closing tables 0.02 ms freeing items 0.02 ms cleaning up 0.02 ms # Caller File and line number 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:46 - 查询时间：0.55 ms 最后一次查询之后：0.32 ms 查询内存： 0.039 MB 内存（查询 6.178 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 tbw0l_content AS a
INNER JOIN tbw0l_categories AS c
on c.id = a.catid
LEFT JOIN tbw0l_users AS u
on u.id = a.created_by
LEFT JOIN tbw0l_categories as parent
ON parent.id = c.parent_id
LEFT JOIN tbw0l_content_rating AS v
ON a.id = v.content_id
WHERE a.id = 391
AND c.published > 0
AND a.language in ('zh-CN','*')
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-09-29 20:33:49')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-09-29 20:33:49')
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.00 ms starting 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.08 ms init 0.00 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.09 ms preparing 0.02 ms executing 0.04 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Caller File and line number 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:46 - 查询时间：0.55 ms 最后一次查询之后：1.20 ms 查询内存： 0.027 MB 内存（查询 6.262 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 `tbw0l_categories` AS `s`
INNER JOIN `tbw0l_categories` AS `c`
ON (s.lft < c.lft
AND c.lft < s.rgt
AND c.language IN ('zh-CN','*')) 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 = 23
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 range cat_idx,idx_access,idx_left_right,idx_language cat_idx 207 NULL 9 44.72 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.00 ms checking permissions 0.00 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.03 ms executing 0.08 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Caller File and line number 24 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 23 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 22 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 21 Joomla\CMS\Categories\Categories->get() JROOT/components/com_content/router.php:72 20 ContentRouter->getCategorySegment() Same as call in the line below. 19 call_user_func_array() JROOT/libraries/src/Component/Router/RouterView.php:120 18 Joomla\CMS\Component\Router\RouterView->getPath() JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 17 Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() JROOT/libraries/src/Component/Router/RouterView.php:222 16 Joomla\CMS\Component\Router\RouterView->preprocess() JROOT/libraries/src/Router/SiteRouter.php:676 15 Joomla\CMS\Router\SiteRouter->processBuildRules() JROOT/libraries/src/Router/Router.php:266 14 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155 13 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 12 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 11 Joomla\CMS\Router\Route::_() JROOT/components/com_content/views/article/view.html.php:71 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:46 - 查询时间：0.35 ms 最后一次查询之后：0.32 ms 查询内存： 0.022 MB 内存（查询 6.357 MB 之前） 返回排数：0
SELECT `m`.`tag_id`,`t`.*
FROM `tbw0l_contentitem_tag_map` AS m
INNER JOIN `tbw0l_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 391
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 没有可使用的索引键 NULL NULL 4 25.00 Using where 1 SIMPLE t NULL eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 cn_navicat_com_20230208.m.tag_id 1 100.00 Using where Status Duration starting 0.06 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.04 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.00 ms query end 0.00 ms waiting for handler commit 0.02 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Caller File and line number 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:46 - 查询时间：0.58 ms 最后一次查询之后：0.87 ms 查询内存： 0.025 MB 内存（查询 6.420 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 tbw0l_fields AS a
LEFT JOIN `tbw0l_languages` AS l
ON l.lang_code = a.language
LEFT JOIN tbw0l_users AS uc
ON uc.id=a.checked_out
LEFT JOIN tbw0l_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN tbw0l_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN tbw0l_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `tbw0l_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 (23,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-CN')
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 where; Using temporary; 使用filesort算法 1 SIMPLE l NULL eq_ref idx_langcode idx_langcode 28 cn_navicat_com_20230208.a.language 1 100.00 Using index condition 1 SIMPLE uc NULL eq_ref PRIMARY PRIMARY 4 cn_navicat_com_20230208.a.checked_out 1 100.00 NULL 1 SIMPLE ag NULL eq_ref PRIMARY PRIMARY 4 cn_navicat_com_20230208.a.access 1 100.00 Using where 1 SIMPLE ua NULL eq_ref PRIMARY PRIMARY 4 cn_navicat_com_20230208.a.created_user_id 1 100.00 Using where 1 SIMPLE g NULL eq_ref PRIMARY PRIMARY 4 cn_navicat_com_20230208.a.group_id 1 100.00 Using where 1 SIMPLE fc NULL ref PRIMARY PRIMARY 4 cn_navicat_com_20230208.a.id 1 100.00 Using where; Using index; Distinct Status Duration starting 0.11 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.06 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.11 ms preparing 0.03 ms Creating tmp table 0.05 ms executing 0.05 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 18 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php: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:46 - 查询时间：1.69 ms 最后一次查询之后：1.61 ms 查询内存： 0.021 MB 内存（查询 6.522 MB 之前） 返回排数：2
SELECT language,id
FROM `tbw0l_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 tbw0l_menu NULL ref idx_client_id_parent_id_alias_language idx_client_id_parent_id_alias_language 1 const 779 1.00 Using where Status Duration starting 0.04 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.00 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.01 ms executing 1.40 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Caller File and line number 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 9 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Language/Multilanguage.php:107 8 Joomla\CMS\Language\Multilanguage::getSiteHomePages() JROOT/plugins/system/languagefilter/languagefilter.php:751 7 PlgSystemLanguageFilter->onAfterDispatch() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/SiteApplication.php:199 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:46 - 查询时间：0.23 ms 最后一次查询之后：0.17 ms 查询内存： 0.024 MB 内存（查询 6.531 MB 之前） 返回排数：1
SELECT `alias`
FROM `tbw0l_content`
WHERE id = '391'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE tbw0l_content NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.03 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.01 ms executing 0.01 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.01 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 18 JDatabaseDriver->loadResult() JROOT/components/com_content/router.php:125 17 ContentRouter->getArticleSegment() Same as call in the line below. 16 call_user_func_array() JROOT/libraries/src/Component/Router/RouterView.php:120 15 Joomla\CMS\Component\Router\RouterView->getPath() JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 14 Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() JROOT/libraries/src/Component/Router/RouterView.php:222 13 Joomla\CMS\Component\Router\RouterView->preprocess() JROOT/libraries/src/Router/SiteRouter.php:676 12 Joomla\CMS\Router\SiteRouter->processBuildRules() JROOT/libraries/src/Router/Router.php:266 11 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155 10 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 9 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 8 Joomla\CMS\Router\Route::_() JROOT/plugins/system/languagefilter/languagefilter.php:763 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:46 - 查询时间：0.19 ms 最后一次查询之后：0.08 ms 查询内存： 0.024 MB 内存（查询 6.539 MB 之前） 返回排数：1
SELECT alias
FROM tbw0l_content
WHERE id=391id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE tbw0l_content NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.03 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.00 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.01 ms executing 0.01 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.01 ms # Caller File and line number 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 16 JDatabaseDriver->loadResult() JROOT/components/com_content/helpers/legacyrouter.php:140 15 ContentRouterRulesLegacy->build() JROOT/libraries/src/Component/Router/RouterView.php:244 14 Joomla\CMS\Component\Router\RouterView->build() JROOT/libraries/src/Router/SiteRouter.php:532 13 Joomla\CMS\Router\SiteRouter->buildSefRoute() JROOT/libraries/src/Router/SiteRouter.php:502 12 Joomla\CMS\Router\SiteRouter->_buildSefRoute() JROOT/libraries/src/Router/Router.php:281 11 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155 10 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 9 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 8 Joomla\CMS\Router\Route::_() JROOT/plugins/system/languagefilter/languagefilter.php:763 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:46 - 查询时间：0.45 ms 最后一次查询之后：0.26 ms 查询内存： 0.021 MB 内存（查询 6.555 MB 之前） 返回排数：0
SELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`,CONCAT_WS(':', ca.id, ca.alias) AS `catid`
FROM `tbw0l_content` AS `c`
INNER JOIN `tbw0l_associations` AS `a`
ON a.id = c.`id`
AND a.context='com_content.item'
INNER JOIN `tbw0l_associations` AS `a2`
ON `a`.`key` = `a2`.`key`
INNER JOIN `tbw0l_content` AS `c2`
ON a2.id = c2.`id`
INNER JOIN `tbw0l_categories` AS `ca`
ON `c2`.`catid` = ca.id
AND ca.extension = 'com_content'
WHERE c.id = 391
AND c2.access IN (1,1,5)
AND c2.language != 'zh-CN'
AND (c2.publish_up = '0000-00-00 00:00:00' OR c2.publish_up <= '2026-09-29 20:33:49')
AND (c2.publish_down = '0000-00-00 00:00:00' OR c2.publish_down >= '2026-09-29 20:33:49')
AND c2.state = 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE NULL NULL NULL NULL 没有可使用的索引键 NULL NULL NULL NULL no matching row in const table Status Duration starting 0.07 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.05 ms init 0.01 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.13 ms executing 0.01 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 10 JDatabaseDriver->loadObjectList() JROOT/libraries/src/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:46 - 查询时间：1.83 ms 最后一次查询之后：0.80 ms 查询内存： 0.071 MB 内存（查询 6.592 MB 之前） 返回排数：17
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM tbw0l_modules AS m
LEFT JOIN tbw0l_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN tbw0l_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-09-29 20:33:49')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-09-29 20:33:49')
AND m.access IN (1,1,5)
AND m.client_id = 0
AND (mm.menuid = 282 OR mm.menuid <= 0)
AND m.language IN ('zh-CN','*')
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 没有可使用的索引键 NULL NULL 122 1.03 Using where; 使用filesort算法 1 SIMPLE e NULL ref element_clientid,element_folder_clientid element_clientid 403 cn_navicat_com_20230208.m.module,const 1 10.00 Using index condition; Using where 1 SIMPLE mm NULL ref PRIMARY PRIMARY 4 cn_navicat_com_20230208.m.id 7 40.00 Using where; Using index Status Duration starting 0.09 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 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.03 ms executing 1.37 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.01 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 13 JDatabaseDriver->loadObjectList() Same as call in the line below. 12 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 11 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:441 10 Joomla\CMS\Helper\ModuleHelper::getModuleList() JROOT/libraries/src/Helper/ModuleHelper.php:371 9 Joomla\CMS\Helper\ModuleHelper::load() JROOT/libraries/src/Helper/ModuleHelper.php:87 8 Joomla\CMS\Helper\ModuleHelper::getModules() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:45 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:46 - 查询时间：0.34 ms 最后一次查询之后：1.33 ms 查询内存： 0.022 MB 内存（查询 6.676 MB 之前） 返回排数：5
SELECT `name`,`element`
FROM `tbw0l_extensions`
WHERE `type` = 'plugin'
AND `folder` = 'finder'
AND `enabled` = 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE tbw0l_extensions NULL ref extension extension 82 const 102 1.00 Using index condition; Using where Status Duration starting 0.05 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.00 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.02 ms executing 0.08 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 12 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_finder/helpers/language.php:126 11 FinderHelperLanguage::loadPluginLanguage() JROOT/modules/mod_finder/mod_finder.php:51 10 include JROOT/modules/mod_finder/mod_finder.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:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:46 - 查询时间：0.26 ms 最后一次查询之后：0.65 ms 查询内存： 0.024 MB 内存（查询 6.702 MB 之前） 返回排数：4
SELECT `title`
FROM `tbw0l_finder_taxonomy`
WHERE `parent_id` = 1
AND `state` = 1
AND `access` IN (1,1,5)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE tbw0l_finder_taxonomy NULL ref parent_id,state,access,idx_parent_published parent_id 4 const 4 68.72 Using where Status Duration starting 0.03 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.00 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.01 ms executing 0.03 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 15 JDatabaseDriver->loadColumn() JROOT/administrator/components/com_finder/helpers/indexer/taxonomy.php:258 14 FinderIndexerTaxonomy::getBranchTitles() JROOT/administrator/components/com_finder/helpers/indexer/query.php:750 13 FinderIndexerQuery->processString() JROOT/administrator/components/com_finder/helpers/indexer/query.php:236 12 FinderIndexerQuery->__construct() JROOT/modules/mod_finder/helper.php:84 11 ModFinderHelper::getQuery() JROOT/modules/mod_finder/mod_finder.php:54 10 include JROOT/modules/mod_finder/mod_finder.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:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:46
30 个查询类型记录，按记录升序排序
选择表：
2 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `tbw0l_assets`2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `tbw0l_extensions`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 `tbw0l_categories` AS `s`
INNER JOIN `tbw0l_categories` AS `c`
ON (s.lft < c.lft
AND c.lft < s.rgt
AND c.language IN ('zh-CN','*')) OR (c.lft <= s.lft
AND s.rgt <= c.rgt)1 × SELECT `data`
FROM `tbw0l_session`1 × SELECT `name`,`element`
FROM `tbw0l_extensions`1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM tbw0l_modules AS m
LEFT JOIN tbw0l_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN tbw0l_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id1 × SELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`,CONCAT_WS(':', ca.id, ca.alias) AS `catid`
FROM `tbw0l_content` AS `c`
INNER JOIN `tbw0l_associations` AS `a`
ON a.id = c.`id`
AND a.context='com_content.item'
INNER JOIN `tbw0l_associations` AS `a2`
ON `a`.`key` = `a2`.`key`
INNER JOIN `tbw0l_content` AS `c2`
ON a2.id = c2.`id`
INNER JOIN `tbw0l_categories` AS `ca`
ON `c2`.`catid` = ca.id
AND ca.extension = 'com_content'1 × SELECT alias
FROM tbw0l_content1 × SELECT `alias`
FROM `tbw0l_content`1 × SELECT language,id
FROM `tbw0l_menu`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 tbw0l_fields AS a
LEFT JOIN `tbw0l_languages` AS l
ON l.lang_code = a.language
LEFT JOIN tbw0l_users AS uc
ON uc.id=a.checked_out
LEFT JOIN tbw0l_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN tbw0l_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN tbw0l_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `tbw0l_fields_categories` AS fc
ON fc.field_id = a.id1 × SELECT `m`.`tag_id`,`t`.*
FROM `tbw0l_contentitem_tag_map` AS m
INNER JOIN `tbw0l_tags` AS t
ON `m`.`tag_id` = `t`.`id`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 tbw0l_content AS a
INNER JOIN tbw0l_categories AS c
on c.id = a.catid
LEFT JOIN tbw0l_users AS u
on u.id = a.created_by
LEFT JOIN tbw0l_categories as parent
ON parent.id = c.parent_id
LEFT JOIN tbw0l_content_rating AS v
ON a.id = v.content_id1 × SELECT `alias`,`catid`
FROM `tbw0l_content`1 × SELECT id, home, template, s.params
FROM tbw0l_template_styles as s
LEFT JOIN tbw0l_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id1 × SELECT `session_id`
FROM `tbw0l_session`1 × 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 tbw0l_menu AS m
LEFT JOIN tbw0l_extensions AS e
ON m.component_id = e.extension_id1 × SELECT `source`,`keepurlparams`
FROM `tbw0l_admintools_redirects`1 × SELECT `element`,`name`,`client_id`,`extension_id`
FROM `tbw0l_extensions`1 × SELECT *
FROM `tbw0l_admintools_wafexceptions`1 × SELECT *
FROM tbw0l_languages1 × SELECT `value`
FROM `tbw0l_admintools_storage`1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM tbw0l_extensions1 × SELECT b.id
FROM tbw0l_usergroups AS a
LEFT JOIN tbw0l_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt1 × SELECT id, rules
FROM `tbw0l_viewlevels1 × SELECT `title`
FROM `tbw0l_finder_taxonomy`
其它表：
1 × INSERT INTO `tbw0l_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'3730376867713338756e68723538677471626e33696868737174', 1, 1790714029, 0, '', 01 × UPDATE `tbw0l_extensions`
SET `params` = '{\"mediaversion\":\"74d62e79338ef817613b0ff3c8bd0dbb\"}'1 × SHOW FULL COLUMNS
FROM `tbw0l_content1 × UPDATE tbw0l_content
SET `hits` = (`hits` + 1)
