Joomla运行环境要求原

Joomla是基于PHP语言开发的跨平台CMS系统，可以同时运行于WINDOWS环境和LINUX环境。其各个版本对运行环境的要求如下。

运行Joomla! 3.x的环境要求

软件	推荐版本	最低要求	更多信息
PHP^[1]	7.3 +	5.3.10	https://www.php.net (Magic Quotes GPC, MB String Overload = off) (Zlib Compression Support, XML Support, INI Parser Support, JSON Support, MB Language = Default)
支持的数据库
MySQL^[2]	5.5.3 +	5.1	https://www.mysql.com (InnoDB support required)
SQL Server	10.50.1600.1 +	10.50.1600.1	https://www.microsoft.com/sql
PostgreSQL	9.1 +	8.3.18	https://www.postgresql.org/
支持的WEB服务器
Apache^[3]	2.4 +	2.0	https://www.apache.org (with mod_mysql, mod_xml, and mod_zlib)
Nginx	1.8 +	1.0	https://www.nginx.com/resources/wiki/
Microsoft IIS^[6]	7	7	https://www.iis.net

已经不再维护的版本

运行 Joomla! 1.6, 1.7, & 2.5 的环境要求

本版本已于2014年12月31日停止维护

软件	推荐版本	最低版本	更多信息
PHP	5.6	5.2.4	https://www.php.net
支持的数据库
MySQL	5.0.4 +	5.0.4	https://www.mysql.com
SQL Server^[5]	10.50.1600.1 +	10.50.1600.1	https://www.microsoft.com/sql
支持的WEB服务器
Apache^[3]	2.2 +	2.0	https://www.apache.org (with mod_mysql, mod_xml, and mod_zlib)
Nginx	1.1 +	1.0	https://www.nginx.com/resources/wiki/
Microsoft IIS^[6]	7	7	https://www.iis.net

运行Joomla! 1.5的环境要求

此版本已于2012年12月31日停止维护

软件	推荐版本	最低版本	更多信息
PHP^[4]	5.3	4.3.10	https://www.php.net
支持的数据库
MySQL	4.1.x +	3.23	https://www.mysql.com
支持的WEB服务器
Apache^[3]	2.0 +	1.3	https://www.apache.org (with mod_mysql, mod_xml, and mod_zlib)
Microsoft IIS^[6]	7	6	https://www.iis.net

运行Joomla! 1.0的环境要求

此版本已于2009年7月22日停止维护

软件	推荐版本	最低版本	更多信息
PHP^[4]	5.3	4.3.10	https://www.php.net
Supported Databases
MySQL	4.1.x +	3.23	https://www.mysql.com
Supported Web Servers
Apache^[3]	2.0 +	1.3	https://www.apache.org (with mod_mysql, mod_xml, and mod_zlib)
Microsoft IIS^[6]	7	6	https://www.iis.net

脚注说明

[1] PHP 5.3.1 可以正常运行Joomla 3.0，Joomla 3.2. 但是在Joomla 3.3, 最低的 PHP 版本为 5.3.10. Joomla 3.5以及以后的版本都会兼容PHP7

[2] Joomla! 3.5以后默认支持 MySQL's `utf8mb4` 字符集.

[3] 为了使用SEO URL，您将需要安装Apache mod_rewrite扩展。

[4] 不要使用PHP4.3.9,4.4.2 和5.0.4.，这些版本中已知的BUG会导致安装失败. PHP4.4 的 Zend Optimizer 扩展也有严重的BUG,不要使用. Joomla1.5及以后的版本都支持PHP5.3 请注意OpenID 库不兼容 PHP 5.3.

[5] 2.5版本增加了对Microsoft SQL Server的支持。 1.6和1.7没有此支持

[6] 对于Microsoft IIS的支持（取决于您的设置），您可能需要以下内容：

PHP - Installation instructions
MySQL - Installation instructions
Microsoft URL重写模块 - 当开启URL SEO优化时需要
FastCGI - Download for IIS6. Download for IIS7.

快速环境搭建工具

如果你想在本地搭建一个Joomla的运行环境，下面的一些工具可以非常轻松的帮你完成。

LAMP (Linux) - 大多数Linux发行版都带有预配置的LAMP服务器
WAMP (Windows) - 了解详情, 请访问 the WampServer homepage
MAMP (Apple OS) - 了解详情, 请访问 the MAMP homepage
XAMPP (Multi-platform) - 了解详情, 请访问 the XAMPP homepage

最新在前
最佳在前

Joomla! 除错面板

会话

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1631920767,
                "last": 1631920767,
                "now": 1631920767
            },
            "token": "18stADc9oNZsjB01QZOZ5x0OVZ1VjMip"
        },
        "registry": {
            "zmaxlogin": {
                "login": {
                    "return": "http:\/\/www.joomlachina.cn\/beyong-love-2"
                },
                "logout": {
                    "return": "http:\/\/www.joomlachina.cn\/beyong-love-2"
                }
            }
        },
        "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
        },
        "com_mailto": {
            "links": {
                "f06b6c6a4ce4a2fbc0e668393abeaad78aacdfe8": {
                    "link": "http:\/\/www.joomlachina.cn\/beyong-love-2",
                    "expiry": 1631920767
                }
            }
        }
    }
}

方案信息

时间

内存

时间: 19.64 ms / 19.64 ms 内存: 1.676 MB / 2.01 MB Application: afterLoad

时间: 118.42 ms / 138.06 ms 内存: 5.267 MB / 7.28 MB Application: afterInitialise

时间: 40.36 ms / 178.42 ms 内存: 2.191 MB / 9.47 MB Application: afterRoute

时间: 7.35 ms / 185.77 ms 内存: 0.292 MB / 9.76 MB Application: beforeRenderComponent com_content

时间: 3.90 ms / 189.67 ms 内存: 0.232 MB / 10.00 MB Application: Before Access::preloadComponents (all components)

时间: 1.53 ms / 191.20 ms 内存: 0.081 MB / 10.08 MB Application: After Access::preloadComponents (all components)

时间: 0.03 ms / 191.23 ms 内存: 0.000 MB / 10.07 MB Application: Before Access::preloadPermissions (com_content)

时间: 8.93 ms / 200.16 ms 内存: 1.343 MB / 11.42 MB Application: After Access::preloadPermissions (com_content)

时间: 0.07 ms / 200.23 ms 内存: 0.000 MB / 11.35 MB Application: Before Access::getAssetRules (id:1396 name:com_content.article.823)

时间: 0.72 ms / 200.95 ms 内存: 0.027 MB / 11.38 MB Application: After Access::getAssetRules (id:1396 name:com_content.article.823)

时间: 64.46 ms / 265.41 ms 内存: 2.797 MB / 14.17 MB Application: afterRenderComponent com_content

时间: 1.09 ms / 266.50 ms 内存: 0.004 MB / 14.18 MB Application: afterDispatch

时间: 17.39 ms / 283.89 ms 内存: 0.373 MB / 14.55 MB Application: beforeRenderModule mod_custom (网站版权信息)

时间: 4.00 ms / 287.89 ms 内存: 0.066 MB / 14.62 MB Application: afterRenderModule mod_custom (网站版权信息)

时间: 0.04 ms / 287.93 ms 内存: 0.000 MB / 14.61 MB Application: beforeRenderModule mod_zmaxqqonline (QQ在线客服)

时间: 1.28 ms / 289.21 ms 内存: 0.030 MB / 14.64 MB Application: afterRenderModule mod_zmaxqqonline (QQ在线客服)

时间: 0.08 ms / 289.29 ms 内存: 0.005 MB / 14.65 MB Application: beforeRenderModule mod_menu (关于)

时间: 7.05 ms / 296.34 ms 内存: 0.115 MB / 14.76 MB Application: afterRenderModule mod_menu (关于)

时间: 0.07 ms / 296.41 ms 内存: 0.000 MB / 14.76 MB Application: beforeRenderModule mod_sj_flat_menu (关于Joomla)

时间: 4.00 ms / 300.41 ms 内存: 0.103 MB / 14.86 MB Application: afterRenderModule mod_sj_flat_menu (关于Joomla)

时间: 0.06 ms / 300.47 ms 内存: 0.001 MB / 14.86 MB Application: beforeRenderModule mod_breadcrumbs (顶部导航路径 )

时间: 1.41 ms / 301.88 ms 内存: 0.020 MB / 14.88 MB Application: afterRenderModule mod_breadcrumbs (顶部导航路径 )

时间: 0.06 ms / 301.94 ms 内存: 0.000 MB / 14.88 MB Application: beforeRenderModule mod_zmaxcustom (顶部广告)

时间: 0.63 ms / 302.57 ms 内存: 0.008 MB / 14.89 MB Application: afterRenderModule mod_zmaxcustom (顶部广告)

时间: 0.07 ms / 302.64 ms 内存: 0.001 MB / 14.89 MB Application: beforeRenderModule mod_zmaxloginpro (顶部登录)

时间: 1.74 ms / 304.38 ms 内存: 0.032 MB / 14.92 MB Application: afterRenderModule mod_zmaxloginpro (顶部登录)

时间: 0.07 ms / 304.44 ms 内存: 0.000 MB / 14.92 MB Application: beforeRenderModule mod_sj_flat_menu (顶部导航菜单)

时间: 3.06 ms / 307.50 ms 内存: 0.041 MB / 14.96 MB Application: afterRenderModule mod_sj_flat_menu (顶部导航菜单)

时间: 57.38 ms / 364.88 ms 内存: 1.481 MB / 16.44 MB Application: afterRender

数据库查询总数： 65.38 ms

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	joomlachina_session	const	PRIMARY	PRIMARY	194	const	1	100.00	NULL

#	调用者	文件及行号
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:660
9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:620
8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:498
7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:455
6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:758
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:344
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

#	调用者	文件及行号
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:153
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:760
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:344
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

EXPLAIN 在 INSERT INTO `joomlachina_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'6f676f756f3075396561686b6465617572747376723461637363', 1, 1631920767, 0, '', 0) 查询上无法执行

方案

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
update	0.08 ms
end	0.01 ms
query end	22.25 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 ms

调用堆栈

#	调用者	文件及行号
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:153
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:760
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:344
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

[给你的 php.ini 文件中添加 xdebug.file_link_format 指令来获得文件链接。]

查询时间： 0.56 ms 在上次查询之后: 3.82 ms 查询内存： 0.036 MB ；查询前的内存： 3.916 MB 返回的行数： 59

SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`

  FROM `joomlachina_extensions`

  WHERE `type` = 'component' 
  AND `state` = 0 
  AND `enabled` = 1

解释

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	joomlachina_extensions	ref	extension	extension	82	const	60	100.00	Using index condition; Using where

方案

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.26 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 ms

调用堆栈

#	调用者	文件及行号
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[给你的 php.ini 文件中添加 xdebug.file_link_format 指令来获得文件链接。]

查询时间： 0.22 ms 在上次查询之后: 3.03 ms 查询内存： 0.023 MB ；查询前的内存： 4.137 MB 返回的行数： 8

SELECT id, rules

  FROM `joomlachina_viewlevels`

解释

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	joomlachina_viewlevels	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	7	100.00	NULL

方案

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

调用堆栈

#	调用者	文件及行号
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Access/Access.php:1063
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:321
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[给你的 php.ini 文件中添加 xdebug.file_link_format 指令来获得文件链接。]

查询时间： 0.24 ms 在上次查询之后: 0.10 ms 查询内存： 0.022 MB ；查询前的内存： 4.150 MB 返回的行数： 2

SELECT b.id

  FROM joomlachina_usergroups AS a

  LEFT JOIN joomlachina_usergroups AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt

  WHERE a.id = 13

解释

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

方案

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

调用堆栈

#	调用者	文件及行号
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
10	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
9	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/Access/Access.php:1095
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:321
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[给你的 php.ini 文件中添加 xdebug.file_link_format 指令来获得文件链接。]

查询时间： 1.39 ms 在上次查询之后: 0.79 ms 查询内存： 0.035 MB ；查询前的内存： 4.216 MB 返回的行数： 124

SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`

  FROM joomlachina_extensions

  WHERE enabled = 1 
  AND type = 'plugin' 
  AND state IN (0,1) 
  AND access IN (1,1,5)

  ORDER BY ordering

解释

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	joomlachina_extensions	ref	extension	extension	82	const	165	100.00	Using index condition; Using where; 使用文件排序

方案

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.02 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.75 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 ms

调用堆栈

#	调用者	文件及行号
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:354
9	Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()	与下面行的调用一样
8	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
7	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Plugin/PluginHelper.php:359
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[给你的 php.ini 文件中添加 xdebug.file_link_format 指令来获得文件链接。]

查询时间： 1.76 ms 在上次查询之后: 36.45 ms 查询内存： 0.198 MB ；查询前的内存： 6.453 MB 返回的行数： 194

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 joomlachina_menu AS m

  LEFT JOIN joomlachina_extensions AS e 
  ON m.component_id = e.extension_id

  WHERE m.published = 1 
  AND m.parent_id > 0 
  AND m.client_id = 0

  ORDER BY m.lft

解释

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	ALL	idx_client_id_parent_id_alias_language	NO INDEX KEY COULD BE USED	NULL	NULL	367	73.57	Using where; 使用文件排序
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	www_joomlachina_.m.component_id	1	100.00	Using where

方案

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.02 ms
Creating sort index	1.29 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 ms

调用堆栈

#	调用者	文件及行号
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:76
17	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
16	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:131
15	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:375
14	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
13	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php: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:491
10	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
9	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/plugins/system/zmaxhideadmin/zmaxhideadmin.php:32
8	plgSystemZmaxHideAdmin->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[给你的 php.ini 文件中添加 xdebug.file_link_format 指令来获得文件链接。]

查询时间： 2.04 ms 在上次查询之后: 15.43 ms 查询内存： 0.029 MB ；查询前的内存： 8.116 MB 返回的行数： 2

SHOW FULL COLUMNS 
  FROM `joomlachina_komento_configs`

解释

EXPLAIN 在 SHOW FULL COLUMNS FROM `joomlachina_komento_configs` 查询上无法执行

方案

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	1.24 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.01 ms
Opening tables	0.01 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
removing tmp table	0.52 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 ms

调用堆栈

#	调用者	文件及行号
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
17	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
16	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
15	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_komento/tables/parent.php:18
14	KomentoParentTable->__construct()	JROOT/administrator/components/com_komento/tables/configs.php:40
13	KomentoTableConfigs->__construct()	JROOT/libraries/src/Table/Table.php:312
12	Joomla\CMS\Table\Table::getInstance()	JROOT/administrator/components/com_komento/tables/parent.php:49
11	KomentoParentTable::getInstance()	JROOT/components/com_komento/helpers/helper.php:99
10	Komento::getTable()	JROOT/components/com_komento/helpers/helper.php:228
9	Komento::getKonfig()	JROOT/components/com_komento/bootstrap.php:30
8	require_once JROOT/components/com_komento/bootstrap.php	JROOT/components/com_komento/router.php:16
7	require_once JROOT/components/com_komento/router.php	JROOT/libraries/src/Router/SiteRouter.php:779
6	Joomla\CMS\Router\SiteRouter->getComponentRouter()	JROOT/libraries/src/Router/SiteRouter.php:131
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[给你的 php.ini 文件中添加 xdebug.file_link_format 指令来获得文件链接。]

查询时间： 0.19 ms 在上次查询之后: 0.85 ms 查询内存： 0.024 MB ；查询前的内存： 8.148 MB 返回的行数： 1

SELECT *

  FROM joomlachina_komento_configs

  WHERE `component` = 'com_komento'

解释

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

方案

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

调用堆栈

#	调用者	文件及行号
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
11	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
10	Joomla\CMS\Table\Table->load()	JROOT/components/com_komento/helpers/helper.php:229
9	Komento::getKonfig()	JROOT/components/com_komento/bootstrap.php:30
8	require_once JROOT/components/com_komento/bootstrap.php	JROOT/components/com_komento/router.php:16
7	require_once JROOT/components/com_komento/router.php	JROOT/libraries/src/Router/SiteRouter.php:779
6	Joomla\CMS\Router\SiteRouter->getComponentRouter()	JROOT/libraries/src/Router/SiteRouter.php:131
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[给你的 php.ini 文件中添加 xdebug.file_link_format 指令来获得文件链接。]

查询时间： 0.66 ms 在上次查询之后: 11.87 ms 查询内存： 0.178 MB ；查询前的内存： 8.791 MB 返回的行数： 28

SELECT id, home, template, s.params

  FROM joomlachina_template_styles as s

  LEFT JOIN joomlachina_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id

  WHERE s.client_id = 0 
  AND e.enabled = 1

解释

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	extension	82	const	9	100.00	Using index condition; Using where
1	SIMPLE	s	ref	idx_template,idx_client_id,idx_client_id_home	idx_template	202	www_joomlachina_.e.element	1	100.00	Using index condition; Using where

方案

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.27 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 ms

调用堆栈

#	调用者	文件及行号
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/t3/includes/core/t3.php:320
9	T3::detect()	JROOT/plugins/system/t3/t3.php:81
8	plgSystemT3->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[给你的 php.ini 文件中添加 xdebug.file_link_format 指令来获得文件链接。]

查询时间： 0.31 ms 在上次查询之后: 12.84 ms 查询内存： 0.025 MB ；查询前的内存： 9.506 MB 返回的行数： 1

SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`

  FROM `joomlachina_extensions`

  WHERE `type` = 'library' 
  AND `element` = 'joomla'

解释

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	joomlachina_extensions	ref	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	Using index condition

方案

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

调用堆栈

#	调用者	文件及行号
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}()	与下面行的调用一样
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:1130
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[给你的 php.ini 文件中添加 xdebug.file_link_format 指令来获得文件链接。]

查询时间： 2.95 ms 在上次查询之后: 0.16 ms 查询内存： 0.005 MB ；查询前的内存： 9.496 MB

UPDATE `joomlachina_extensions`

  SET `params` = '{\"mediaversion\":\"a1ead0f9fd4096771170e18cea76bf5e\"}'

  WHERE `type` = 'library' 
  AND `element` = 'joomla'

解释

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	joomlachina_extensions	range	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	Using where

方案

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.05 ms
updating	0.04 ms
end	0.01 ms
query end	2.73 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 ms

调用堆栈

#	调用者	文件及行号
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:1130
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[给你的 php.ini 文件中添加 xdebug.file_link_format 指令来获得文件链接。]

查询时间： 0.27 ms 在上次查询之后: 2.42 ms 查询内存： 0.025 MB ；查询前的内存： 9.739 MB 返回的行数： 1

SELECT *

  FROM joomlachina_languages

  WHERE published=1

  ORDER BY ordering ASC

解释

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	joomlachina_languages	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Using where; 使用文件排序

方案

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 ms

调用堆栈

#	调用者	文件及行号
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/Application/SiteApplication.php:330
4	Joomla\CMS\Application\SiteApplication->getParams()	JROOT/libraries/src/Application/SiteApplication.php:138
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[给你的 php.ini 文件中添加 xdebug.file_link_format 指令来获得文件链接。]

查询时间： 1.26 ms 在上次查询之后: 4.78 ms 查询内存： 0.032 MB ；查询前的内存： 10.000 MB 返回的行数： 59

SELECT `id`,`name`,`rules`,`parent_id`

  FROM `joomlachina_assets`

  WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_akeeba','com_appbuilder','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_dbreplacer','com_fields','com_finder','com_installer','com_jch_optimize','com_joomlaupdate','com_komento','com_kunena','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_uniterevolution2','com_users','com_weblinks','com_wrapper','com_xmap','com_zmaxappstore','com_zmaxcaptcha','com_zmaxcase','com_zmaxcdn','com_zmaxhh','com_zmaxim','com_zmaxintegral','com_zmaxlogin','com_zmaxpay','com_zmaxpublish','com_zmaxsms','com_zmaxstore','com_zmaxtask','com_zmaxucenter','com_zmaxvclass','com_zmaxwechat')

解释

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	joomlachina_assets	range	idx_asset_name	idx_asset_name	202	NULL	60	100.00	Using index condition

方案

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.10 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.27 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.63 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 ms

调用堆栈

#	调用者	文件及行号
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:440
10	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/components/com_content/models/article.php:251
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[给你的 php.ini 文件中添加 xdebug.file_link_format 指令来获得文件链接。]

查询时间： 6.34 ms 在上次查询之后: 0.24 ms 查询内存： 0.297 MB ；查询前的内存： 10.072 MB 返回的行数： 1676

SELECT `id`,`name`,`rules`,`parent_id`

  FROM `joomlachina_assets`

  WHERE `name` LIKE 'com_content.%' OR `name` = 'com_content' OR `parent_id` = 0

解释

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

方案

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	5.68 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 ms

调用堆栈

#	调用者	文件及行号
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:440
10	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/components/com_content/models/article.php:251
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[给你的 php.ini 文件中添加 xdebug.file_link_format 指令来获得文件链接。]

查询时间： 1.72 ms 在上次查询之后: 4.36 ms 查询内存： 0.036 MB ；查询前的内存： 11.419 MB 返回的行数： 31

SHOW FULL COLUMNS 
  FROM `joomlachina_content`

解释

EXPLAIN 在 SHOW FULL COLUMNS FROM `joomlachina_content` 查询上无法执行

方案

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.71 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.01 ms
Opening tables	0.02 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.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Sending data	0.06 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
removing tmp table	0.40 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 ms

调用堆栈

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

[给你的 php.ini 文件中添加 xdebug.file_link_format 指令来获得文件链接。]

查询时间： 1.73 ms 在上次查询之后: 3.48 ms 查询内存： 0.005 MB ；查询前的内存： 11.650 MB

UPDATE joomlachina_content

  SET `hits` = (`hits` + 1)

  WHERE `id` = '823'

解释

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	joomlachina_content	range	PRIMARY	PRIMARY	4	const	1	100.00	Using where

方案

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.03 ms
updating	0.05 ms
end	0.01 ms
query end	1.49 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 ms

调用堆栈

#	调用者	文件及行号
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Table/Table.php:1245
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:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[给你的 php.ini 文件中添加 xdebug.file_link_format 指令来获得文件链接。]

查询时间： 0.57 ms 在上次查询之后: 1.88 ms 查询内存： 0.048 MB ；查询前的内存： 11.777 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 joomlachina_content AS a

  INNER JOIN joomlachina_categories AS c 
  on c.id = a.catid

  LEFT JOIN joomlachina_users AS u 
  on u.id = a.created_by

  LEFT JOIN joomlachina_categories as parent 
  ON parent.id = c.parent_id

  LEFT JOIN joomlachina_content_rating AS v 
  ON a.id = v.content_id

  WHERE a.id = 823 
  AND c.published > 0 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2021-09-17 23:19:27') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-09-17 23:19:27') 
  AND (a.state = 1 OR a.state =2)

解释

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

方案

Status	Duration
starting	0.12 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.07 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.10 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.07 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.02 ms

调用堆栈

#	调用者	文件及行号
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/plugins/system/t3/includes/joomla4/HtmlView.php:423
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_content/views/article/view.html.php:43
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[给你的 php.ini 文件中添加 xdebug.file_link_format 指令来获得文件链接。]

查询时间： 0.75 ms 在上次查询之后: 2.25 ms 查询内存： 0.035 MB ；查询前的内存： 12.004 MB 返回的行数： 0

SELECT `m`.`tag_id`,`t`.*

  FROM `joomlachina_contentitem_tag_map` AS m 

  INNER JOIN `joomlachina_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

  WHERE `m`.`type_alias` = 'com_content.article' 
  AND `m`.`content_item_id` = 823 
  AND `t`.`published` = 1 
  AND t.access IN (1,1,5)

解释

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

方案

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.42 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 ms

调用堆栈

#	调用者	文件及行号
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:185
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[给你的 php.ini 文件中添加 xdebug.file_link_format 指令来获得文件链接。]

查询时间： 1.21 ms 在上次查询之后: 20.13 ms 查询内存： 0.041 MB ；查询前的内存： 13.170 MB 返回的行数： 6

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 `joomlachina_categories` AS `s`

  INNER JOIN `joomlachina_categories` AS `c` 
  ON (s.lft <= c.lft 
  AND c.lft < s.rgt) 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 = 164

  ORDER BY c.lft

解释

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	使用文件排序
1	SIMPLE	c	range	cat_idx,idx_access,idx_left_right	cat_idx	207	NULL	143	100.00	Using index condition; Using where

方案

Status	Duration
starting	0.09 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.05 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.12 ms
preparing	0.02 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.02 ms
Creating sort index	0.68 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

调用堆栈

#	调用者	文件及行号
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
19	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
18	Joomla\CMS\Categories\Categories->get()	JROOT/administrator/components/com_fields/models/fields.php:203
17	FieldsModelFields->getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:133
16	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:187
15	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php: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:194
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[给你的 php.ini 文件中添加 xdebug.file_link_format 指令来获得文件链接。]

查询时间： 2.04 ms 在上次查询之后: 0.72 ms 查询内存： 0.037 MB ；查询前的内存： 13.234 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 joomlachina_fields AS a

  LEFT JOIN `joomlachina_languages` AS l 
  ON l.lang_code = a.language

  LEFT JOIN joomlachina_users AS uc 
  ON uc.id=a.checked_out

  LEFT JOIN joomlachina_viewlevels AS ag 
  ON ag.id = a.access

  LEFT JOIN joomlachina_users AS ua 
  ON ua.id = a.created_user_id

  LEFT JOIN joomlachina_fields_groups AS g 
  ON g.id = a.group_id

  LEFT JOIN `joomlachina_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 (164,0,84,327)) 
  AND a.access IN (1,1,5) 
  AND (a.group_id = 0 OR g.access IN (1,1,5)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

解释

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	100.00	Using where; Using temporary; 使用文件排序
1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	www_joomlachina_.a.language	1	100.00	Using where
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	www_joomlachina_.a.checked_out	1	100.00	NULL
1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	www_joomlachina_.a.access	1	100.00	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	www_joomlachina_.a.created_user_id	1	100.00	Using where
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	www_joomlachina_.a.group_id	1	100.00	Using where
1	SIMPLE	fc	ref	PRIMARY	PRIMARY	4	www_joomlachina_.a.id	1	100.00	Using where; Using index; Distinct

方案

Status	Duration
starting	0.10 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.05 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.11 ms
preparing	0.03 ms
Creating tmp table	0.05 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	1.04 ms
Creating sort index	0.02 ms
end	0.01 ms
removing tmp table	0.43 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.02 ms
cleaning up	0.01 ms

调用堆栈

#	调用者	文件及行号
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
17	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
16	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
15	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php: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:194
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[给你的 php.ini 文件中添加 xdebug.file_link_format 指令来获得文件链接。]

查询时间： 1.03 ms 在上次查询之后: 8.29 ms 查询内存： 0.029 MB ；查询前的内存： 13.719 MB 返回的行数： 27

SELECT a.id, a.title, a.catid, a.language, 
  CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, 
  CASE WHEN CHAR_LENGTH(cc.alias) != 0 THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as catslug

  FROM joomlachina_content AS a

  LEFT JOIN joomlachina_categories AS cc 
  ON cc.id = a.catid

  WHERE a.catid = 164 
  AND a.state = 1 
  AND a.access IN (1,1,5)  
  AND (a.state = 1 OR a.state = -1) 
  AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2021-09-17 23:19:27') 
  AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2021-09-17 23:19:27')

  ORDER BY  
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END DESC

解释

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	index_merge	idx_access,idx_state,idx_catid	idx_catid,idx_state	4,1	NULL	19	78.95	Using intersect(idx_catid,idx_state); Using where; 使用文件排序
1	SIMPLE	cc	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

方案

Status	Duration
starting	0.09 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.05 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.08 ms
preparing	0.02 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.58 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 ms

调用堆栈

#	调用者	文件及行号
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/plugins/content/pagenavigation/pagenavigation.php:161
13	PlgContentPagenavigation->onContentBeforeDisplay()	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:200
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[给你的 php.ini 文件中添加 xdebug.file_link_format 指令来获得文件链接。]

查询时间： 2.29 ms 在上次查询之后: 15.06 ms 查询内存： 0.054 MB ；查询前的内存： 14.208 MB 返回的行数： 52

SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid

  FROM joomlachina_modules AS m

  LEFT JOIN joomlachina_modules_menu AS mm 
  ON mm.moduleid = m.id

  LEFT JOIN joomlachina_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 <= '2021-09-17 23:19:27') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2021-09-17 23:19:27') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 1631 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

解释

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	ref	PRIMARY,published,newsfeeds	published	1	const	112	100.00	Using index condition; Using where; 使用文件排序
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	www_joomlachina_.m.module,const	1	100.00	Using index condition; Using where
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	www_joomlachina_.m.id	1	100.00	Using where; Using index

方案

Status	Duration
starting	0.07 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.04 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.07 ms
preparing	0.03 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	1.83 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

调用堆栈

#	调用者	文件及行号
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
22	JDatabaseDriver->loadObjectList()	与下面行的调用一样
21	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
20	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:452
19	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:382
18	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:87
17	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/templates/purity_iii/helper.php:38
16	JATemplateHelper::loadModules()	JROOT/templates/purity_iii/html/com_content/article/default_desktop.php:184
15	include JROOT/templates/purity_iii/html/com_content/article/default_desktop.php	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:695
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/templates/purity_iii/html/com_content/article/default.php:44
13	include JROOT/templates/purity_iii/html/com_content/article/default.php	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:695
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_content/views/article/view.html.php:213
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[给你的 php.ini 文件中添加 xdebug.file_link_format 指令来获得文件链接。]

查询时间： 1.80 ms 在上次查询之后: 19.71 ms 查询内存： 0.039 MB ；查询前的内存： 14.581 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 joomlachina_fields AS a

  LEFT JOIN `joomlachina_languages` AS l 
  ON l.lang_code = a.language

  LEFT JOIN joomlachina_users AS uc 
  ON uc.id=a.checked_out

  LEFT JOIN joomlachina_viewlevels AS ag 
  ON ag.id = a.access

  LEFT JOIN joomlachina_users AS ua 
  ON ua.id = a.created_user_id

  LEFT JOIN joomlachina_fields_groups AS g 
  ON g.id = a.group_id

  WHERE a.context = 'mod_custom.content' 
  AND a.access IN (1,1,5) 
  AND (a.group_id = 0 OR g.access IN (1,1,5)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

解释

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	100.00	Using where; Using temporary; 使用文件排序
1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	www_joomlachina_.a.language	1	100.00	Using where
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	www_joomlachina_.a.checked_out	1	100.00	NULL
1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	www_joomlachina_.a.access	1	100.00	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	www_joomlachina_.a.created_user_id	1	100.00	Using where
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	www_joomlachina_.a.group_id	1	100.00	Using where

方案

Status	Duration
starting	0.09 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.05 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.10 ms
preparing	0.03 ms
Creating tmp table	0.05 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.84 ms
Creating sort index	0.02 ms
end	0.01 ms
removing tmp table	0.38 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

调用堆栈

#	调用者	文件及行号
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
21	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
20	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
19	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
18	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
17	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
15	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
14	JHtmlContent::prepare()	与下面行的调用一样
13	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
12	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
11	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/modules/mod_custom/mod_custom.php:15
10	include JROOT/modules/mod_custom/mod_custom.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:201
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:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[给你的 php.ini 文件中添加 xdebug.file_link_format 指令来获得文件链接。]

查询时间： 0.21 ms 在上次查询之后: 16.95 ms 查询内存： 0.024 MB ；查询前的内存： 14.924 MB 返回的行数： 2

SELECT title,path,link

  FROM joomlachina_menu

  WHERE id IN(1626,1448)

解释

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	joomlachina_menu	range	PRIMARY	PRIMARY	4	NULL	2	100.00	Using where

方案

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

调用堆栈

#	调用者	文件及行号
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_zmaxloginpro/helper.php:29
11	ModZmaxLoginproHelper::getMenuList()	JROOT/modules/mod_zmaxloginpro/mod_zmaxloginpro.php:24
10	include JROOT/modules/mod_zmaxloginpro/mod_zmaxloginpro.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:201
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:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[给你的 php.ini 文件中添加 xdebug.file_link_format 指令来获得文件链接。]

查询时间： 0.22 ms 在上次查询之后: 11.48 ms 查询内存： 0.027 MB ；查询前的内存： 15.412 MB 返回的行数： 0

SELECT *

  FROM joomlachina_zmaxwechat_plan

  WHERE published=1 
  AND done=0 
  AND start_date <='2021-09-17 23:19:27' 
  AND end_date >='2021-09-17 23:19:27'

解释

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

方案

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.02 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 ms

调用堆栈

#	调用者	文件及行号
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_zmaxwechat/libs/plan.php:93
9	zmaxwechatPlan->loadPlan()	JROOT/administrator/components/com_zmaxwechat/libs/plan.php:65
8	zmaxwechatPlan->doPlan()	JROOT/plugins/system/zmaxwechat/zmaxwechat.php:35
7	plgSystemZmaxwechat->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1050
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[给你的 php.ini 文件中添加 xdebug.file_link_format 指令来获得文件链接。]

查询时间： 0.16 ms 在上次查询之后: 0.09 ms 查询内存： 0.022 MB ；查询前的内存： 15.418 MB 返回的行数： 0

SELECT plan_id

  FROM joomlachina_zmaxwechat_plan_state

  WHERE time > 1631836800

解释

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

方案

Status	Duration
starting	0.02 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.01 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 ms

调用堆栈

#	调用者	文件及行号
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
10	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_zmaxwechat/libs/plan.php:105
9	zmaxwechatPlan->loadPlan()	JROOT/administrator/components/com_zmaxwechat/libs/plan.php:65
8	zmaxwechatPlan->doPlan()	JROOT/plugins/system/zmaxwechat/zmaxwechat.php:35
7	plgSystemZmaxwechat->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1050
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[给你的 php.ini 文件中添加 xdebug.file_link_format 指令来获得文件链接。]

26 查询种类记录依照发现记录降序排序

选择表格:

2 × SELECT `id`,`name`,`rules`,`parent_id` 
  FROM `joomlachina_assets`

2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` 
  FROM `joomlachina_extensions`

1 × SELECT `m`.`tag_id`,`t`.* 
  FROM `joomlachina_contentitem_tag_map` AS m  
  INNER JOIN `joomlachina_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

1 × SELECT * 
  FROM joomlachina_zmaxwechat_plan

1 × SELECT title,path,link 
  FROM joomlachina_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 joomlachina_fields AS a 
  LEFT JOIN `joomlachina_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN joomlachina_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN joomlachina_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN joomlachina_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN joomlachina_fields_groups AS g 
  ON g.id = a.group_id

1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
  FROM joomlachina_modules AS m 
  LEFT JOIN joomlachina_modules_menu AS mm 
  ON mm.moduleid = m.id 
  LEFT JOIN joomlachina_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

1 × SELECT a.id, a.title, a.catid, a.language, 
  CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, 
  CASE WHEN CHAR_LENGTH(cc.alias) != 0 THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as catslug 
  FROM joomlachina_content AS a 
  LEFT JOIN joomlachina_categories AS cc 
  ON cc.id = a.catid

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 joomlachina_fields AS a 
  LEFT JOIN `joomlachina_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN joomlachina_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN joomlachina_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN joomlachina_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN joomlachina_fields_groups AS g 
  ON g.id = a.group_id 
  LEFT JOIN `joomlachina_fields_categories` AS fc 
  ON fc.field_id = a.id

1 × 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 `joomlachina_categories` AS `s` 
  INNER JOIN `joomlachina_categories` AS `c` 
  ON (s.lft <= c.lft 
  AND c.lft < s.rgt) OR (c.lft < s.lft 
  AND s.rgt < c.rgt)

1 × SELECT `data` 
  FROM `joomlachina_session`

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 joomlachina_content AS a 
  INNER JOIN joomlachina_categories AS c 
  on c.id = a.catid 
  LEFT JOIN joomlachina_users AS u 
  on u.id = a.created_by 
  LEFT JOIN joomlachina_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN joomlachina_content_rating AS v 
  ON a.id = v.content_id

1 × SELECT `session_id` 
  FROM `joomlachina_session`

1 × SELECT * 
  FROM joomlachina_languages

1 × SELECT id, home, template, s.params 
  FROM joomlachina_template_styles as s 
  LEFT JOIN joomlachina_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id

1 × SELECT * 
  FROM joomlachina_komento_configs

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 joomlachina_menu AS m 
  LEFT JOIN joomlachina_extensions AS e 
  ON m.component_id = e.extension_id

1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` 
  FROM joomlachina_extensions

1 × SELECT b.id 
  FROM joomlachina_usergroups AS a 
  LEFT JOIN joomlachina_usergroups AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt

1 × SELECT id, rules 
  FROM `joomlachina_viewlevels

1 × SELECT plan_id 
  FROM joomlachina_zmaxwechat_plan_state

其它表：

1 × INSERT INTO `joomlachina_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  (X'6f676f756f3075396561686b6465617572747376723461637363', 1, 1631920767, 0, '', 0

1 × SHOW FULL COLUMNS 
  FROM `joomlachina_komento_configs

1 × UPDATE `joomlachina_extensions` 
  SET `params` = '{\"mediaversion\":\"a1ead0f9fd4096771170e18cea76bf5e\"}'

1 × SHOW FULL COLUMNS 
  FROM `joomlachina_content

1 × UPDATE joomlachina_content 
  SET `hits` = (`hits` + 1)

运行环境

Joomla运行环境要求原

运行Joomla! 3.x的环境要求

已经不再维护的版本

运行 Joomla! 1.6, 1.7, & 2.5 的环境要求

运行Joomla! 1.5的环境要求

运行Joomla! 1.0的环境要求

脚注说明

快速环境搭建工具

评论 (0)

关于Joomla

Joomla! 除错面板

会话

方案信息

时间

内存

内存使用量

数据库查询

28 查询记录 65.38 ms

26 查询种类记录依照发现记录降序排序

选择表格:

其它表：