Joomla！调试控制台

会议

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1720850112,
                "last": 1720850112,
                "now": 1720850112
            },
            "client": {
                "forwarded": "3.133.114.63"
            },
            "token": "Onx9fwb3nIxah1r0kcPoTkXpzBauQFOl"
        },
        "registry": {
            "com_kunena": {
                "user0_read": {
                    "1": 1,
                    "2": 2,
                    "3": 3
                }
            }
        },
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        },
        "jomsocial_userip": "3.133.114.63"
    }
}

档案信息

内存使用情况

数据库查询

记录了 76 个查询 168.79 ms

找到 6 个重复项！

2 重复: #37 #43

2 重复: #38 #44

2 重复: #60 #63

查询时间：1.01 ms 查询内存：0.020 MB 查询前内存：4.105 MB 返回的行数：0

SELECT `session_id`

  FROM `joom_session`

  WHERE `session_id` = 'alhru7ig8kc7ojfp3vbvhnkooq' 
  LIMIT 1

解释

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	joom_session	NULL	const	PRIMARY	PRIMARY	766	const	1	100.00	Using index

轮廓

Status	Duration
starting	0.03 ms
checking query cache for query	0.08 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
init	0.02 ms
System lock	0.03 ms
optimizing	0.01 ms
statistics	0.05 ms
executing	0.01 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
storing result in query cache	0.01 ms
cleaned up	0.01 ms
cleaning up	0.00 ms

调用堆栈

#	呼叫者	文件和行号
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1760
7	JDatabaseDriver->loadResult()	JROOT/libraries/cms/application/cms.php:176
6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:888
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:469
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::getApplication()	JROOT/index.php:50

[将 xdebug.file_link_format 指令添加到您的 php.ini 文件以获取文件链接。]

查询时间：3.36 ms 上次查询后：0.06 ms 查询内存：0.003 MB 查询前内存：4.172 MB

INSERT INTO `joom_session`
(`session_id`,`guest`,`time`,`userid`,`username`) 
  VALUES 
('alhru7ig8kc7ojfp3vbvhnkooq', 1, '1720850112', 0, '')

解释

查询时无法解释：INSERT INTO `joom_session` (`session_id`,`guest`,`time`,`userid`,`username`) VALUES ('alhru7ig8kc7ojfp3vbvhnkooq', 1, '1720850112', 0, '')

轮廓

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
update	0.10 ms
end	0.01 ms
query end	0.03 ms
closing tables	0.01 ms
freeing items	0.01 ms
delayed commit ok initiated	2.54 ms
delayed commit ok done	0.02 ms
cleaning up	0.01 ms

调用堆栈

#	呼叫者	文件和行号
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:216
6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:888
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:469
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::getApplication()	JROOT/index.php:50

[将 xdebug.file_link_format 指令添加到您的 php.ini 文件以获取文件链接。]

查询时间：1.35 ms 上次查询后：49.67 ms 查询内存：0.045 MB 查询前内存：4.344 MB 返回的行数：80

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

  FROM `joom_extensions`

  WHERE `type` = 'component'

解释

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	joom_extensions	NULL	ref	extension	extension	82	const	80	100.00	NULL

轮廓

Status	Duration
starting	0.03 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.09 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.02 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.01 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.04 ms
storing result in query cache	0.01 ms
cleaned up	0.01 ms
cleaning up	0.00 ms

调用堆栈

#	呼叫者	文件和行号
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1721
9	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/component/helper.php:447
8	JComponentHelper::{closure}()	JROOT/libraries/joomla/cache/controller/callback.php:169
7	JCacheControllerCallback->get()	JROOT/libraries/cms/component/helper.php:455
6	JComponentHelper::load()	JROOT/libraries/cms/component/helper.php:43
5	JComponentHelper::getComponent()	JROOT/libraries/cms/component/helper.php:111
4	JComponentHelper::getParams()	JROOT/libraries/cms/application/site.php:598
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

[将 xdebug.file_link_format 指令添加到您的 php.ini 文件以获取文件链接。]

查询时间：0.82 ms 上次查询后：49.01 ms 查询内存：0.021 MB 查询前内存：4.554 MB 返回的行数：7

SELECT id, rules

  FROM `joom_viewlevels`

解释

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	joom_viewlevels	NULL	ALL	NULL	不能使用任何索引键	NULL	NULL	7	100.00	NULL

轮廓

Status	Duration
starting	0.03 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.06 ms
sending cached result to clien	0.03 ms
cleaned up	0.01 ms
cleaning up	0.00 ms

调用堆栈

#	呼叫者	文件和行号
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1526
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:1062
8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:453
7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:293
6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:608
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

[将 xdebug.file_link_format 指令添加到您的 php.ini 文件以获取文件链接。]

查询时间：0.60 ms 上次查询后：0.05 ms 查询内存：0.021 MB 查询前内存：4.566 MB 返回的行数：1

SELECT b.id

  FROM joom_usergroups AS a

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

  WHERE a.id = 1

解释

id	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	1	100.00	Using where; Using index

轮廓

Status	Duration
starting	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
sending cached result to clien	0.02 ms
cleaned up	0.01 ms
cleaning up	0.00 ms

调用堆栈

#	呼叫者	文件和行号
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1570
10	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:979
9	JAccess::getGroupsByUser()	JROOT/libraries/joomla/access/access.php:1094
8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:453
7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:293
6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:608
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

[将 xdebug.file_link_format 指令添加到您的 php.ini 文件以获取文件链接。]

查询时间：2.69 ms 上次查询后：4.19 ms 查询内存：0.046 MB 查询前内存：4.628 MB 返回的行数：142

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

  FROM joom_extensions

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

  ORDER BY ordering

解释

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	joom_extensions	NULL	ref	extension	extension	82	const	277	0.40	Using index condition; Using where; 使用文件排序

轮廓

Status	Duration
starting	0.04 ms
checking query cache for query	0.02 ms
checking privileges on cached	0.01 ms
checking permissions	0.17 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
init	0.09 ms
System lock	0.03 ms
optimizing	0.03 ms
statistics	0.13 ms
preparing	0.05 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
Creating sort index	1.27 ms
end	0.02 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.08 ms
storing result in query cache	0.01 ms
cleaned up	0.01 ms
cleaning up	0.01 ms

调用堆栈

#	呼叫者	文件和行号
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1721
9	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/plugin/helper.php:311
8	JPluginHelper::{closure}()	JROOT/libraries/joomla/cache/controller/callback.php:169
7	JCacheControllerCallback->get()	JROOT/libraries/cms/plugin/helper.php:316
6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:608
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

[将 xdebug.file_link_format 指令添加到您的 php.ini 文件以获取文件链接。]

查询时间：1.13 ms 上次查询后：93.83 ms 查询内存：0.024 MB 查询前内存：5.536 MB 返回的行数：1

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

  FROM `joom_extensions`

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

解释

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	joom_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	NULL

轮廓

Status	Duration
starting	0.03 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.09 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.09 ms
preparing	0.02 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.05 ms
storing result in query cache	0.01 ms
cleaned up	0.01 ms
cleaning up	0.00 ms

调用堆栈

#	呼叫者	文件和行号
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1682
16	JDatabaseDriver->loadObject()	JROOT/libraries/cms/library/helper.php:166
15	JLibraryHelper::{closure}()	JROOT/libraries/joomla/cache/controller/callback.php:169
14	JCacheControllerCallback->get()	JROOT/libraries/cms/library/helper.php:174
13	JLibraryHelper::loadLibrary()	JROOT/libraries/cms/library/helper.php:42
12	JLibraryHelper::getLibrary()	JROOT/libraries/cms/library/helper.php:89
11	JLibraryHelper::getParams()	JROOT/libraries/cms/version/version.php:270
10	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:775
9	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
8	JFactory::getDocument()	JROOT/plugins/system/mootable/mootable.php:100
7	PlgSystemMootable->__construct()	JROOT/libraries/cms/plugin/helper.php:255
6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:739
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:690
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

[将 xdebug.file_link_format 指令添加到您的 php.ini 文件以获取文件链接。]

查询时间：4.02 ms 上次查询后：0.11 ms 查询内存：0.006 MB 查询前内存：5.528 MB

UPDATE `joom_extensions`

  SET `params` = '{\"mediaversion\":\"58e0acaf9ac9cfca3c8fb8e26b67d0e8\"}'

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

解释

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	UPDATE	joom_extensions	NULL	range	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	Using where

轮廓

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.07 ms
updating	0.11 ms
end	0.01 ms
query end	0.05 ms
closing tables	0.01 ms
freeing items	0.01 ms
delayed commit ok initiated	3.08 ms
delayed commit ok done	0.02 ms
cleaning up	0.01 ms

调用堆栈

#	呼叫者	文件和行号
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/library/helper.php:116
12	JLibraryHelper::saveParams()	JROOT/libraries/cms/version/version.php:321
11	JVersion->setMediaVersion()	JROOT/libraries/cms/version/version.php:280
10	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:775
9	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
8	JFactory::getDocument()	JROOT/plugins/system/mootable/mootable.php:100
7	PlgSystemMootable->__construct()	JROOT/libraries/cms/plugin/helper.php:255
6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:739
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:690
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

[将 xdebug.file_link_format 指令添加到您的 php.ini 文件以获取文件链接。]

查询时间：0.83 ms 上次查询后：208.70 ms 查询内存：0.029 MB 查询前内存：8.021 MB 返回的行数：19

SELECT *

  FROM joom_languages

  WHERE published=1

  ORDER BY ordering ASC

解释

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	joom_languages	NULL	ALL	NULL	不能使用任何索引键	NULL	NULL	19	10.00	Using where; 使用文件排序

轮廓

Status	Duration
starting	0.03 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.02 ms
sending cached result to clien	0.04 ms
cleaned up	0.01 ms
cleaning up	0.01 ms

调用堆栈

#	呼叫者	文件和行号
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1721
9	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/language/helper.php:148
8	JLanguageHelper::getLanguages()	JROOT/plugins/system/languagefilter/languagefilter.php:99
7	PlgSystemLanguageFilter->__construct()	JROOT/libraries/cms/plugin/helper.php:255
6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:739
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:690
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

[将 xdebug.file_link_format 指令添加到您的 php.ini 文件以获取文件链接。]

查询时间：0.77 ms 上次查询后：5.69 ms 查询内存：0.021 MB 查询前内存：8.088 MB 返回的行数：1

SELECT * 
  FROM axs_domains 
  WHERE domain = 'k8s.intg.tovuti.io'

解释

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	axs_domains	NULL	ALL	NULL	不能使用任何索引键	NULL	NULL	1	100.00	Using where

轮廓

Status	Duration
starting	0.03 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.02 ms
sending cached result to clien	0.03 ms
cleaned up	0.01 ms
cleaning up	0.00 ms

调用堆栈

#	呼叫者	文件和行号
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1682
9	JDatabaseDriver->loadObject()	JROOT/libraries/axslibs/language.php:155
8	AxsLanguage::getSubdomainDefault()	JROOT/plugins/system/languagefilter/languagefilter.php:103
7	PlgSystemLanguageFilter->__construct()	JROOT/libraries/cms/plugin/helper.php:255
6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:739
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:690
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

[将 xdebug.file_link_format 指令添加到您的 php.ini 文件以获取文件链接。]

查询时间：1.28 ms 上次查询后：0.08 ms 查询内存：0.030 MB 查询前内存：8.096 MB 返回的行数：94

SELECT `element`,`name`,`client_id`,`extension_id`

  FROM `joom_extensions`

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

解释

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	joom_extensions	NULL	ref	extension	extension	82	const	98	1.00	Using where

轮廓

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

调用堆栈

#	呼叫者	文件和行号
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1721
9	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/language/helper.php:207
8	JLanguageHelper::getInstalledLanguages()	JROOT/plugins/system/languagefilter/languagefilter.php:113
7	PlgSystemLanguageFilter->__construct()	JROOT/libraries/cms/plugin/helper.php:255
6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:739
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:690
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

[将 xdebug.file_link_format 指令添加到您的 php.ini 文件以获取文件链接。]

查询时间：0.80 ms 上次查询后：7.99 ms 查询内存：0.022 MB 查询前内存：8.228 MB 返回的行数：1

SELECT * 
  FROM `axs_brands` 
  WHERE language = 'en-GB' 
  AND (FIND_IN_SET('k8s.intg.tovuti.io', domains) > 0) 
  LIMIT 1

解释

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	axs_brands	NULL	ALL	NULL	不能使用任何索引键	NULL	NULL	3	33.33	Using where

轮廓

Status	Duration
starting	0.03 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.02 ms
sending cached result to clien	0.03 ms
cleaned up	0.01 ms
cleaning up	0.00 ms

调用堆栈

#	呼叫者	文件和行号
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1721
12	JDatabaseDriver->loadObjectList()	JROOT/libraries/axslibs/brands.php:290
11	AxsBrands::getData()	JROOT/libraries/axslibs/brands.php:355
10	AxsBrands::getBrandObject()	JROOT/libraries/axslibs/brands.php:55
9	AxsBrands::getBrand()	JROOT/plugins/system/axslibs/axslibs.php:35
8	plgSystemAxslibs->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:740
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:690
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

[将 xdebug.file_link_format 指令添加到您的 php.ini 文件以获取文件链接。]

查询时间：0.64 ms 上次查询后：0.08 ms 查询内存：0.030 MB 查询前内存：8.250 MB 返回的行数：19

SELECT * 
  FROM joom_languages 
  WHERE published = 1 
  ORDER BY `title`

解释

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	joom_languages	NULL	ALL	NULL	不能使用任何索引键	NULL	NULL	19	10.00	Using where; 使用文件排序

轮廓

Status	Duration
starting	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.02 ms
cleaned up	0.01 ms
cleaning up	0.00 ms

调用堆栈

#	呼叫者	文件和行号
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1721
13	JDatabaseDriver->loadObjectList()	JROOT/libraries/axslibs/language.php:314
12	AxsLanguage::getPublishedLanguages()	JROOT/libraries/axslibs/language.php:223
11	AxsLanguage::getCurrentLanguage()	JROOT/libraries/axslibs/brands.php:371
10	AxsBrands::getBrandObject()	JROOT/libraries/axslibs/brands.php:55
9	AxsBrands::getBrand()	JROOT/plugins/system/axslibs/axslibs.php:35
8	plgSystemAxslibs->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:740
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:690
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

[将 xdebug.file_link_format 指令添加到您的 php.ini 文件以获取文件链接。]

查询时间：0.81 ms 上次查询后：18.59 ms 查询内存：0.021 MB 查询前内存：8.519 MB 返回的行数：1

SELECT * 
  FROM `axs_homepage_templates` 
  WHERE id='1'

解释

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	axs_homepage_templates	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

轮廓

Status	Duration
starting	0.03 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.02 ms
sending cached result to clien	0.04 ms
cleaned up	0.01 ms
cleaning up	0.00 ms

调用堆栈

#	呼叫者	文件和行号
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1721
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/axslibs/brands.php:388
10	AxsBrands::getBrandObject()	JROOT/libraries/axslibs/brands.php:55
9	AxsBrands::getBrand()	JROOT/plugins/system/axslibs/axslibs.php:35
8	plgSystemAxslibs->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:740
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:690
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

[将 xdebug.file_link_format 指令添加到您的 php.ini 文件以获取文件链接。]

查询时间：0.66 ms 上次查询后：0.09 ms 查询内存：0.021 MB 查询前内存：8.560 MB 返回的行数：1

SELECT * 
  FROM `axs_dashboard_templates` 
  WHERE id='2'

解释

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	axs_dashboard_templates	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

轮廓

Status	Duration
starting	0.02 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.02 ms
sending cached result to clien	0.03 ms
cleaned up	0.01 ms
cleaning up	0.01 ms

调用堆栈

#	呼叫者	文件和行号
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1721
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/axslibs/brands.php:406
10	AxsBrands::getBrandObject()	JROOT/libraries/axslibs/brands.php:55
9	AxsBrands::getBrand()	JROOT/plugins/system/axslibs/axslibs.php:35
8	plgSystemAxslibs->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:740
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:690
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

[将 xdebug.file_link_format 指令添加到您的 php.ini 文件以获取文件链接。]

查询时间：0.64 ms 上次查询后：0.07 ms 查询内存：0.022 MB 查询前内存：8.579 MB 返回的行数：1

SELECT *

  FROM axs_email_settings

  WHERE id = '1'

解释

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	axs_email_settings	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

轮廓

Status	Duration
starting	0.02 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.02 ms
sending cached result to clien	0.03 ms
cleaned up	0.01 ms
cleaning up	0.00 ms

调用堆栈

#	呼叫者	文件和行号
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1682
12	JDatabaseDriver->loadObject()	JROOT/libraries/axslibs/brands.php:632
11	AxsBrands::getEmailSettingsById()	JROOT/libraries/axslibs/brands.php:409
10	AxsBrands::getBrandObject()	JROOT/libraries/axslibs/brands.php:55
9	AxsBrands::getBrand()	JROOT/plugins/system/axslibs/axslibs.php:35
8	plgSystemAxslibs->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:740
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:690
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

[将 xdebug.file_link_format 指令添加到您的 php.ini 文件以获取文件链接。]

查询时间：0.65 ms 上次查询后：0.05 ms 查询内存：0.022 MB 查询前内存：8.589 MB 返回的行数：1

SELECT *

  FROM axs_payment_gateways

  WHERE id = '1'

解释

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	axs_payment_gateways	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

轮廓

Status	Duration
starting	0.02 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.02 ms
cleaned up	0.02 ms
cleaning up	0.00 ms

调用堆栈

#	呼叫者	文件和行号
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1682
12	JDatabaseDriver->loadObject()	JROOT/libraries/axslibs/brands.php:582
11	AxsBrands::getPaymentGatewayById()	JROOT/libraries/axslibs/brands.php:412
10	AxsBrands::getBrandObject()	JROOT/libraries/axslibs/brands.php:55
9	AxsBrands::getBrand()	JROOT/plugins/system/axslibs/axslibs.php:35
8	plgSystemAxslibs->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:740
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:690
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

[将 xdebug.file_link_format 指令添加到您的 php.ini 文件以获取文件链接。]

查询时间：0.61 ms 上次查询后：0.06 ms 查询内存：0.022 MB 查询前内存：8.601 MB 返回的行数：1

SELECT *

  FROM axs_integrations

  WHERE id = '1'

解释

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	axs_integrations	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

轮廓

Status	Duration
starting	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.02 ms
cleaned up	0.01 ms
cleaning up	0.00 ms

调用堆栈

#	呼叫者	文件和行号
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1682
12	JDatabaseDriver->loadObject()	JROOT/libraries/axslibs/brands.php:659
11	AxsBrands::getIntegrationById()	JROOT/libraries/axslibs/brands.php:418
10	AxsBrands::getBrandObject()	JROOT/libraries/axslibs/brands.php:55
9	AxsBrands::getBrand()	JROOT/plugins/system/axslibs/axslibs.php:35
8	plgSystemAxslibs->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:740
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:690
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

[将 xdebug.file_link_format 指令添加到您的 php.ini 文件以获取文件链接。]

查询时间：2.01 ms 上次查询后：105.84 ms 查询内存：0.101 MB 查询前内存：10.157 MB 返回的行数：88

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

  LEFT JOIN joom_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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	128	3.33	Using index condition; Using where; 使用文件排序
1	SIMPLE	e	NULL	eq_ref	PRIMARY	PRIMARY	4	root_db.m.component_id	1	100.00	Using where

轮廓

Status	Duration
starting	0.04 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.12 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.04 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.03 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.81 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaned up	0.01 ms
cleaning up	0.01 ms

调用堆栈

#	呼叫者	文件和行号
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1721
21	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/menu/site.php:88
20	JMenuSite->{closure}()	JROOT/libraries/joomla/cache/controller/callback.php:169
19	JCacheControllerCallback->get()	JROOT/libraries/cms/menu/site.php:96
18	JMenuSite->load()	JROOT/libraries/cms/menu/menu.php:74
17	JMenu->__construct()	JROOT/libraries/cms/menu/site.php:57
16	JMenuSite->__construct()	JROOT/libraries/cms/menu/menu.php:129
15	JMenu::getInstance()	JROOT/libraries/cms/application/cms.php:500
14	JApplicationCms->getMenu()	JROOT/libraries/cms/application/site.php:277
13	JApplicationSite->getMenu()	JROOT/libraries/cms/router/site.php:59
12	JRouterSite->__construct()	JROOT/libraries/cms/router/router.php:198
11	JRouter::getInstance()	JROOT/libraries/cms/application/cms.php:605
10	JApplicationCms::getRouter()	JROOT/libraries/cms/application/site.php:407
9	JApplicationSite::getRouter()	JROOT/plugins/system/languagefilter/languagefilter.php:134
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/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:740
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:690
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

[将 xdebug.file_link_format 指令添加到您的 php.ini 文件以获取文件链接。]

查询时间：1.33 ms 上次查询后：171.66 ms 查询内存：0.028 MB 查询前内存：12.354 MB 返回的行数：17

SHOW FULL COLUMNS 
  FROM `joom_users`

解释

查询时无法解释：SHOW FULL COLUMNS FROM `joom_users`

轮廓

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

调用堆栈

#	呼叫者	文件和行号
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1721
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:421
18	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:244
17	JTable->getFields()	JROOT/libraries/joomla/table/table.php:163
16	JTable->__construct()	JROOT/libraries/joomla/table/user.php:39
15	JTableUser->__construct()	JROOT/libraries/joomla/table/table.php:311
14	JTable::getInstance()	JROOT/libraries/joomla/user/user.php:598
13	JUser::getTable()	JROOT/libraries/joomla/user/user.php:782
12	JUser->save()	JROOT/plugins/system/languagefilter/languagefilter.php:848
11	PlgSystemLanguageFilter->setPreferredLanguage()	JROOT/plugins/system/languagefilter/languagefilter.php:512
10	PlgSystemLanguageFilter->parseRule()	JROOT/libraries/cms/router/router.php:597
9	JRouter->processParseRules()	JROOT/libraries/cms/router/site.php:584
8	JRouterSite->processParseRules()	JROOT/libraries/cms/router/router.php:571
7	JRouter->_processParseRules()	JROOT/libraries/cms/router/router.php:225
6	JRouter->parse()	JROOT/libraries/cms/router/site.php:133
5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1220
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:800
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

[将 xdebug.file_link_format 指令添加到您的 php.ini 文件以获取文件链接。]

查询时间：0.73 ms 上次查询后：18.87 ms 查询内存：0.022 MB 查询前内存：12.398 MB 返回的行数：1

SELECT `id`,`title`

  FROM `joom_usergroups`

  WHERE `id` = 1

解释

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	joom_usergroups	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

轮廓

Status	Duration
starting	0.04 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.02 ms
sending cached result to clien	0.03 ms
cleaned up	0.01 ms
cleaning up	0.00 ms

调用堆栈

#	呼叫者	文件和行号
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1526
14	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/table/user.php:152
13	JTableUser->bind()	JROOT/libraries/joomla/user/user.php:784
12	JUser->save()	JROOT/plugins/system/languagefilter/languagefilter.php:848
11	PlgSystemLanguageFilter->setPreferredLanguage()	JROOT/plugins/system/languagefilter/languagefilter.php:512
10	PlgSystemLanguageFilter->parseRule()	JROOT/libraries/cms/router/router.php:597
9	JRouter->processParseRules()	JROOT/libraries/cms/router/site.php:584
8	JRouterSite->processParseRules()	JROOT/libraries/cms/router/router.php:571
7	JRouter->_processParseRules()	JROOT/libraries/cms/router/router.php:225
6	JRouter->parse()	JROOT/libraries/cms/router/site.php:133
5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1220
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:800
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

[将 xdebug.file_link_format 指令添加到您的 php.ini 文件以获取文件链接。]

查询时间：0.72 ms 上次查询后：63.47 ms 查询内存：0.019 MB 查询前内存：12.997 MB 返回的行数：0

SELECT params

  FROM axs_user_settings

  WHERE id = 1

解释

id	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.03 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.02 ms
sending cached result to clien	0.03 ms
cleaned up	0.01 ms
cleaning up	0.00 ms

调用堆栈

#	呼叫者	文件和行号
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1682
6	JDatabaseDriver->loadObject()	JROOT/libraries/axslibs/user.php:666
5	AxsUser::getGlobalUserSettings()	JROOT/libraries/axslibs/security.php:35
4	AxsSecurity::getSettings()	JROOT/libraries/cms/application/cms.php:377
3	JApplicationCms->checkUserRequireTwoFactor()	JROOT/libraries/cms/application/site.php:231
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

[将 xdebug.file_link_format 指令添加到您的 php.ini 文件以获取文件链接。]

查询时间：0.73 ms 上次查询后：18.76 ms 查询内存：0.019 MB 查询前内存：13.325 MB 返回的行数：0

SELECT *

  FROM `joom_users`

  WHERE `id` = 0

解释

id	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.03 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.02 ms
sending cached result to clien	0.04 ms
cleaned up	0.02 ms
cleaning up	0.01 ms

调用堆栈

#	呼叫者	文件和行号
6	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1682
5	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_users/models/user.php:992
4	UsersModelUser->getOtpConfig()	JROOT/libraries/cms/application/cms.php:381
3	JApplicationCms->checkUserRequireTwoFactor()	JROOT/libraries/cms/application/site.php:231
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

[将 xdebug.file_link_format 指令添加到您的 php.ini 文件以获取文件链接。]

查询时间：1.17 ms 上次查询后：0.15 ms 查询内存：0.019 MB 查询前内存：13.333 MB 返回的行数：6

SELECT id, home, template, s.params

  FROM joom_template_styles as s

  LEFT JOIN joom_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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	NULL	ALL	idx_template	不能使用任何索引键	NULL	NULL	9	11.11	Using where
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	root_db.s.template,const	1	4.07	Using index condition; Using where

轮廓

Status	Duration
starting	0.02 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.12 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.08 ms
preparing	0.03 ms
executing	0.00 ms
Sending data	0.11 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaned up	0.01 ms
cleaning up	0.01 ms

调用堆栈

#	呼叫者	文件和行号
6	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1721
5	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/application/site.php:490
4	JApplicationSite->getTemplate()	JROOT/libraries/cms/application/site.php:165
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

[将 xdebug.file_link_format 指令添加到您的 php.ini 文件以获取文件链接。]

查询时间：0.74 ms 上次查询后：53.72 ms 查询内存：0.021 MB 查询前内存：13.575 MB 返回的行数：1

SELECT * 
  FROM joom_kunena_configuration 
  WHERE id=1

解释

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	joom_kunena_configuration	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

轮廓

Status	Duration
starting	0.03 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.02 ms
sending cached result to clien	0.03 ms
cleaned up	0.01 ms
cleaning up	0.01 ms

调用堆栈

#	呼叫者	文件和行号
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1485
9	JDatabaseDriver->loadAssoc()	JROOT/libraries/kunena/config.php:1306
8	KunenaConfig->load()	JROOT/libraries/kunena/config.php:1239
7	KunenaConfig::getInstance()	JROOT/components/com_kunena/kunena.php:33
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

[将 xdebug.file_link_format 指令添加到您的 php.ini 文件以获取文件链接。]

查询时间：1.21 ms 上次查询后：93.34 ms 查询内存：0.025 MB 查询前内存：13.863 MB 返回的行数：5

SHOW FULL COLUMNS 
  FROM `joom_kunena_sessions`

解释

查询时无法解释：SHOW FULL COLUMNS FROM `joom_kunena_sessions`

轮廓

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

调用堆栈

#	呼叫者	文件和行号
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1721
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:421
16	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:244
15	JTable->getFields()	JROOT/libraries/joomla/table/table.php:163
14	JTable->__construct()	JROOT/libraries/kunena/tables/kunenasessions.php:31
13	TableKunenaSessions->__construct()	JROOT/libraries/joomla/table/table.php:311
12	JTable::getInstance()	JROOT/libraries/kunena/session.php:96
11	KunenaSession->getTable()	JROOT/libraries/kunena/session.php:110
10	KunenaSession->load()	JROOT/libraries/kunena/session.php:30
9	KunenaSession->__construct()	JROOT/libraries/kunena/session.php:60
8	KunenaSession::getInstance()	JROOT/libraries/kunena/factory.php:86
7	KunenaFactory::getSession()	JROOT/components/com_kunena/kunena.php:61
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

[将 xdebug.file_link_format 指令添加到您的 php.ini 文件以获取文件链接。]

查询时间：1.58 ms 上次查询后：97.98 ms 查询内存：0.036 MB 查询前内存：14.577 MB 返回的行数：51

SHOW FULL COLUMNS 
  FROM `joom_kunena_users`

解释

查询时无法解释：SHOW FULL COLUMNS FROM `joom_kunena_users`

轮廓

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

调用堆栈

#	呼叫者	文件和行号
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1721
24	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:421
23	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:244
22	JTable->getFields()	JROOT/libraries/joomla/table/table.php:163
21	JTable->__construct()	JROOT/libraries/kunena/tables/kunenausers.php:329
20	TableKunenaUsers->__construct()	JROOT/libraries/joomla/table/table.php:311
19	JTable::getInstance()	JROOT/libraries/kunena/user/user.php:252
18	KunenaUser->getTable()	JROOT/libraries/kunena/user/user.php:275
17	KunenaUser->load()	JROOT/libraries/kunena/user/user.php:100
16	KunenaUser->__construct()	JROOT/libraries/kunena/user/helper.php:59
15	KunenaUserHelper::initialize()	JROOT/libraries/kunena/user/helper.php:13
14	include JROOT/libraries/kunena/user/helper.php	JROOT/libraries/loader.php:702
13	JLoader::_load()	JROOT/libraries/loader.php:671
12	JLoader::_autoload()	与下面一行中的调用相同。
11	spl_autoload_call()	JROOT/libraries/kunena/route/route.php:699
10	KunenaRoute::build()	JROOT/libraries/kunena/route/route.php:852
9	KunenaRoute::setItemID()	JROOT/libraries/kunena/route/route.php:115
8	KunenaRoute::getItemID()	JROOT/components/com_kunena/controller/application/home/default/display.php:55
7	ComponentKunenaControllerApplicationHomeDefaultDisplay->execute()	JROOT/components/com_kunena/kunena.php:96
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

[将 xdebug.file_link_format 指令添加到您的 php.ini 文件以获取文件链接。]

查询时间：1.32 ms 上次查询后：14.95 ms 查询内存：0.026 MB 查询前内存：14.674 MB 返回的行数：0

SELECT   a.`userid` as _userid , a.`status` as _status ,  a.`points` as _points,  a.`posted_on` as _posted_on,  a.`avatar` as _avatar ,  a.`thumb` as _thumb ,  a.`invite` as _invite,  a.`params` as _cparams,   a.`view` as _view,  a.`friends` as _friends,  a.`groups` as _groups,  a.`events` as _events,  a.`alias`	as _alias,  a.`profile_id` as _profile_id,  a.`friendcount` as _friendcount,  a.`storage` as _storage,  a.`watermark_hash` as _watermark_hash,  a.`search_email` AS _search_email,  s.`userid` as _isonline, u.*  
  FROM `joom_community_users` as a  
  LEFT JOIN `joom_users` u  
  ON u.`id`=a.`userid` 
  LEFT 
  OUTER JOIN `joom_session`s  
  ON s.`userid`=a.`userid` 
  WHERE a.`userid` IN (0)

解释

id	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.03 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.21 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.04 ms
System lock	0.03 ms
optimizing	0.01 ms
statistics	0.15 ms
executing	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
storing result in query cache	0.01 ms
cleaned up	0.11 ms
cleaning up	0.01 ms

调用堆栈

#	呼叫者	文件和行号
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1721
18	JDatabaseDriver->loadObjectList()	JROOT/components/com_community/libraries/core.php:124
17	CFactory::loadUsers()	JROOT/plugins/kunena/community/avatar.php:37
16	KunenaAvatarCommunity->load()	JROOT/libraries/kunena/user/helper.php:63
15	KunenaUserHelper::initialize()	JROOT/libraries/kunena/user/helper.php:13
14	include JROOT/libraries/kunena/user/helper.php	JROOT/libraries/loader.php:702
13	JLoader::_load()	JROOT/libraries/loader.php:671
12	JLoader::_autoload()	与下面一行中的调用相同。
11	spl_autoload_call()	JROOT/libraries/kunena/route/route.php:699
10	KunenaRoute::build()	JROOT/libraries/kunena/route/route.php:852
9	KunenaRoute::setItemID()	JROOT/libraries/kunena/route/route.php:115
8	KunenaRoute::getItemID()	JROOT/components/com_kunena/controller/application/home/default/display.php:55
7	ComponentKunenaControllerApplicationHomeDefaultDisplay->execute()	JROOT/components/com_kunena/kunena.php:96
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

[将 xdebug.file_link_format 指令添加到您的 php.ini 文件以获取文件链接。]

查询时间：0.80 ms 上次查询后：145.98 ms 查询内存：0.023 MB 查询前内存：15.864 MB 返回的行数：0

SELECT g.memberid AS user_id, c.id AS category_id, 2 AS role
			
  FROM joom_kunena_categories AS c
			
  INNER JOIN joom_community_groups_members AS g 
  ON c.accesstype='jomsocial' 
  AND c.access=g.groupid
			
  WHERE c.published=1 
  AND g.approved=1 
  AND g.permissions='1'

解释

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c	NULL	ref	category_access,published_pubaccess_id	category_access	62	const	1	100.00	Using where
1	SIMPLE	g	NULL	ref	PRIMARY,groupid	PRIMARY	4	root_db.c.access	1	100.00	Using where

轮廓

Status	Duration
starting	0.03 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.03 ms
checking permissions	0.01 ms
sending cached result to clien	0.03 ms
cleaned up	0.01 ms
cleaning up	0.00 ms

调用堆栈

#	呼叫者	文件和行号
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1721
15	JDatabaseDriver->loadObjectList()	JROOT/plugins/kunena/community/access.php:136
14	KunenaAccessCommunity->loadCategoryRoles()	JROOT/libraries/kunena/access.php:125
13	KunenaAccess->clearCache()	JROOT/libraries/kunena/access.php:82
12	KunenaAccess->__construct()	JROOT/libraries/kunena/access.php:97
11	KunenaAccess::getInstance()	JROOT/libraries/kunena/user/user.php:441
10	KunenaUser->isAdmin()	JROOT/libraries/kunena/controller/application/display.php:221
9	KunenaControllerApplicationDisplay->before()	JROOT/libraries/kunena/controller/application/display.php:83
8	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/controller/application/home/default/display.php:107
7	ComponentKunenaControllerApplicationHomeDefaultDisplay->execute()	JROOT/components/com_kunena/kunena.php:96
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

[将 xdebug.file_link_format 指令添加到您的 php.ini 文件以获取文件链接。]

查询时间：0.63 ms 上次查询后：0.15 ms 查询内存：0.030 MB 查询前内存：15.884 MB 返回的行数：63

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

  FROM `joom_assets`

  WHERE `name` IN ('com_accessibility','com_admin','com_advpoll','com_affiliate','com_ajax','com_associations','com_award','com_axs','com_banners','com_bigbluebutton','com_board','com_cache','com_categories','com_checkin','com_community','com_config','com_contact','com_contactpage','com_content','com_contenthistory','com_contracts','com_converge','com_cpanel','com_dashboard','com_dbmanager','com_demo','com_domains','com_dump','com_easyblog','com_eshop','com_eventbooking','com_fields','com_finder','com_improved_ajax_login','com_installer','com_interactivecontent','com_invitex','com_jbusinessdirectory','com_jce','com_joomlaupdate','com_jumi','com_kunena','com_languages','com_lifeboard','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_notifications','com_offlajn_installer','com_osmembership','com_permissioning','com_plugins','com_postinstall','com_redirect','com_reports','com_rsticketspro','com_saas','com_scheduler','com_search','com_splms','com_tags','com_templates','com_uniterevolution','com_uniterevolution2','com_uniteshowbiz','com_user_view','com_users','com_weblinks','com_wrapper') OR `parent_id` = 0

解释

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	joom_assets	NULL	ALL	idx_asset_name,idx_parent_id	不能使用任何索引键	NULL	NULL	264	54.55	Using where

轮廓

Status	Duration
starting	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.02 ms
cleaned up	0.01 ms
cleaning up	0.00 ms

调用堆栈

#	呼叫者	文件和行号
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1721
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/access/access.php:427
18	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:211
17	JAccess::preload()	JROOT/libraries/joomla/access/access.php:530
16	JAccess::getAssetRules()	JROOT/plugins/kunena/joomla/access.php:461
15	KunenaAccessJoomla->getAuthorisedUsers()	JROOT/plugins/kunena/joomla/access.php:233
14	KunenaAccessJoomla->loadCategoryRoles()	JROOT/libraries/kunena/access.php:125
13	KunenaAccess->clearCache()	JROOT/libraries/kunena/access.php:82
12	KunenaAccess->__construct()	JROOT/libraries/kunena/access.php:97
11	KunenaAccess::getInstance()	JROOT/libraries/kunena/user/user.php:441
10	KunenaUser->isAdmin()	JROOT/libraries/kunena/controller/application/display.php:221
9	KunenaControllerApplicationDisplay->before()	JROOT/libraries/kunena/controller/application/display.php:83
8	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/controller/application/home/default/display.php:107
7	ComponentKunenaControllerApplicationHomeDefaultDisplay->execute()	JROOT/components/com_kunena/kunena.php:96
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

[将 xdebug.file_link_format 指令添加到您的 php.ini 文件以获取文件链接。]

查询时间：0.69 ms 上次查询后：11.16 ms 查询内存：0.024 MB 查询前内存：15.982 MB 返回的行数：5

SELECT DISTINCT(user_id)

  FROM joom_usergroups as ug1

  INNER JOIN joom_usergroups AS ug2 
  ON ug2.lft>=ug1.lft 
  AND ug1.rgt>=ug2.rgt

  INNER JOIN joom_user_usergroup_map AS m 
  ON ug2.id=m.group_id

  WHERE ug1.id IN (8)

解释

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ug1	NULL	const	PRIMARY,idx_usergroup_nested_set_lookup	PRIMARY	4	const	1	100.00	Using temporary
1	SIMPLE	ug2	NULL	range	PRIMARY,idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	4	NULL	74	33.33	Using where; Using index
1	SIMPLE	m	NULL	ref	PRIMARY,group_id,user_id	group_id	4	root_db.ug2.id	106	100.00	Using index

轮廓

Status	Duration
starting	0.02 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
sending cached result to clien	0.03 ms
cleaned up	0.01 ms
cleaning up	0.00 ms

调用堆栈

#	呼叫者	文件和行号
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1570
17	JDatabaseDriver->loadColumn()	JROOT/plugins/kunena/joomla/access.php:441
16	KunenaAccessJoomla->getUsersByGroup()	JROOT/plugins/kunena/joomla/access.php:492
15	KunenaAccessJoomla->getAuthorisedUsers()	JROOT/plugins/kunena/joomla/access.php:233
14	KunenaAccessJoomla->loadCategoryRoles()	JROOT/libraries/kunena/access.php:125
13	KunenaAccess->clearCache()	JROOT/libraries/kunena/access.php:82
12	KunenaAccess->__construct()	JROOT/libraries/kunena/access.php:97
11	KunenaAccess::getInstance()	JROOT/libraries/kunena/user/user.php:441
10	KunenaUser->isAdmin()	JROOT/libraries/kunena/controller/application/display.php:221
9	KunenaControllerApplicationDisplay->before()	JROOT/libraries/kunena/controller/application/display.php:83
8	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/controller/application/home/default/display.php:107
7	ComponentKunenaControllerApplicationHomeDefaultDisplay->execute()	JROOT/components/com_kunena/kunena.php:96
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

[将 xdebug.file_link_format 指令添加到您的 php.ini 文件以获取文件链接。]

查询时间：0.66 ms 上次查询后：0.04 ms 查询内存：0.025 MB 查询前内存：15.992 MB 返回的行数：23

SELECT DISTINCT(user_id)

  FROM joom_usergroups as ug1

  INNER JOIN joom_usergroups AS ug2 
  ON ug2.lft>=ug1.lft 
  AND ug1.rgt>=ug2.rgt

  INNER JOIN joom_user_usergroup_map AS m 
  ON ug2.id=m.group_id

  WHERE ug1.id IN (32,20)

解释

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ug1	NULL	range	PRIMARY,idx_usergroup_nested_set_lookup	PRIMARY	4	NULL	2	100.00	Using where; Using temporary
1	SIMPLE	ug2	NULL	ALL	PRIMARY,idx_usergroup_nested_set_lookup	不能使用任何索引键	NULL	NULL	82	11.11	Range checked for each record (index map: 0x9)
1	SIMPLE	m	NULL	ref	PRIMARY,group_id,user_id	group_id	4	root_db.ug2.id	106	100.00	Using index

轮廓

Status	Duration
starting	0.02 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
sending cached result to clien	0.03 ms
cleaned up	0.01 ms
cleaning up	0.01 ms

调用堆栈

#	呼叫者	文件和行号
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1570
17	JDatabaseDriver->loadColumn()	JROOT/plugins/kunena/joomla/access.php:441
16	KunenaAccessJoomla->getUsersByGroup()	JROOT/plugins/kunena/joomla/access.php:492
15	KunenaAccessJoomla->getAuthorisedUsers()	JROOT/plugins/kunena/joomla/access.php:233
14	KunenaAccessJoomla->loadCategoryRoles()	JROOT/libraries/kunena/access.php:125
13	KunenaAccess->clearCache()	JROOT/libraries/kunena/access.php:82
12	KunenaAccess->__construct()	JROOT/libraries/kunena/access.php:97
11	KunenaAccess::getInstance()	JROOT/libraries/kunena/user/user.php:441
10	KunenaUser->isAdmin()	JROOT/libraries/kunena/controller/application/display.php:221
9	KunenaControllerApplicationDisplay->before()	JROOT/libraries/kunena/controller/application/display.php:83
8	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/controller/application/home/default/display.php:107
7	ComponentKunenaControllerApplicationHomeDefaultDisplay->execute()	JROOT/components/com_kunena/kunena.php:96
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

[将 xdebug.file_link_format 指令添加到您的 php.ini 文件以获取文件链接。]

查询时间：0.63 ms 上次查询后：0.04 ms 查询内存：0.024 MB 查询前内存：16.014 MB 返回的行数：0

SELECT user_id, category_id, role 
  FROM joom_kunena_user_categories 
  WHERE role IN (1,2)

解释

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	joom_kunena_user_categories	NULL	range	role	role	1	NULL	2	100.00	Using where; Using index

轮廓

Status	Duration
starting	0.02 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.02 ms
cleaned up	0.01 ms
cleaning up	0.00 ms

调用堆栈

#	呼叫者	文件和行号
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1721
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/kunena/access.php:136
13	KunenaAccess->clearCache()	JROOT/libraries/kunena/access.php:82
12	KunenaAccess->__construct()	JROOT/libraries/kunena/access.php:97
11	KunenaAccess::getInstance()	JROOT/libraries/kunena/user/user.php:441
10	KunenaUser->isAdmin()	JROOT/libraries/kunena/controller/application/display.php:221
9	KunenaControllerApplicationDisplay->before()	JROOT/libraries/kunena/controller/application/display.php:83
8	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/controller/application/home/default/display.php:107
7	ComponentKunenaControllerApplicationHomeDefaultDisplay->execute()	JROOT/components/com_kunena/kunena.php:96
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

[将 xdebug.file_link_format 指令添加到您的 php.ini 文件以获取文件链接。]

查询时间：0.83 ms 上次查询后：42.54 ms 查询内存：0.029 MB 查询前内存：16.226 MB 返回的行数：3

SELECT * 
  FROM joom_kunena_categories 
  ORDER BY ordering, name

解释

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	joom_kunena_categories	NULL	ALL	NULL	不能使用任何索引键	NULL	NULL	3	100.00	使用文件排序

轮廓

Status	Duration
starting	0.03 ms
checking query cache for query	0.02 ms
checking privileges on cached	0.01 ms
checking permissions	0.02 ms
sending cached result to clien	0.05 ms
cleaned up	0.01 ms
cleaning up	0.00 ms

调用堆栈

#	呼叫者	文件和行号
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1721
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/kunena/forum/category/helper.php:865
21	KunenaForumCategoryHelper::loadCategories()	JROOT/libraries/kunena/forum/category/helper.php:43
20	KunenaForumCategoryHelper::initialize()	JROOT/libraries/kunena/forum/category/helper.php:1052
19	include JROOT/libraries/kunena/forum/category/helper.php	JROOT/libraries/loader.php:702
18	JLoader::_load()	JROOT/libraries/loader.php:671
17	JLoader::_autoload()	与下面一行中的调用相同。
16	spl_autoload_call()	JROOT/libraries/kunena/access.php:559
15	KunenaAccess->getAllowedCategories()	JROOT/components/com_kunena/controller/category/index/display.php:50
14	ComponentKunenaControllerCategoryIndexDisplay->before()	JROOT/libraries/kunena/controller/display.php:31
13	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/layout/page.php:46
12	KunenaLayoutPage->execute()	JROOT/components/com_kunena/template/nts_kbento/pages/category/list/default.php:13
11	include JROOT/components/com_kunena/template/nts_kbento/pages/category/list/default.php	JROOT/libraries/kunena/layout/base.php:183
10	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
9	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:123
8	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/controller/application/home/default/display.php:107
7	ComponentKunenaControllerApplicationHomeDefaultDisplay->execute()	JROOT/components/com_kunena/kunena.php:96
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

[将 xdebug.file_link_format 指令添加到您的 php.ini 文件以获取文件链接。]

查询时间：0.76 ms 上次查询后：4.76 ms 查询内存：0.027 MB 查询前内存：16.497 MB 返回的行数：0

SELECT groupid

  FROM joom_community_groups_members

  WHERE approved = 1 
  AND memberid = 0

解释

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	joom_community_groups_members	NULL	ref	idx_memberid	idx_memberid	4	const	1	100.00	Using where

轮廓

Status	Duration
starting	0.04 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.02 ms
sending cached result to clien	0.03 ms
cleaned up	0.01 ms
cleaning up	0.00 ms

调用堆栈

#	呼叫者	文件和行号
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1721
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/kunena/forum/category/helper.php:881
21	KunenaForumCategoryHelper::loadCategories()	JROOT/libraries/kunena/forum/category/helper.php:43
20	KunenaForumCategoryHelper::initialize()	JROOT/libraries/kunena/forum/category/helper.php:1052
19	include JROOT/libraries/kunena/forum/category/helper.php	JROOT/libraries/loader.php:702
18	JLoader::_load()	JROOT/libraries/loader.php:671
17	JLoader::_autoload()	与下面一行中的调用相同。
16	spl_autoload_call()	JROOT/libraries/kunena/access.php:559
15	KunenaAccess->getAllowedCategories()	JROOT/components/com_kunena/controller/category/index/display.php:50
14	ComponentKunenaControllerCategoryIndexDisplay->before()	JROOT/libraries/kunena/controller/display.php:31
13	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/layout/page.php:46
12	KunenaLayoutPage->execute()	JROOT/components/com_kunena/template/nts_kbento/pages/category/list/default.php:13
11	include JROOT/components/com_kunena/template/nts_kbento/pages/category/list/default.php	JROOT/libraries/kunena/layout/base.php:183
10	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
9	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:123
8	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/controller/application/home/default/display.php:107
7	ComponentKunenaControllerApplicationHomeDefaultDisplay->execute()	JROOT/components/com_kunena/kunena.php:96
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

[将 xdebug.file_link_format 指令添加到您的 php.ini 文件以获取文件链接。]

查询时间：1.47 ms 上次查询后：19.11 ms 查询内存：0.037 MB 查询前内存：17.260 MB 返回的行数：39

SHOW FULL COLUMNS 
  FROM `joom_kunena_categories`

解释

查询时无法解释：SHOW FULL COLUMNS FROM `joom_kunena_categories`

轮廓

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.15 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.00 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.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.04 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.00 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
Sending data	0.08 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.00 ms
removing tmp table	0.03 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaned up	0.01 ms
cleaning up	0.00 ms

调用堆栈

#	呼叫者	文件和行号
28	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1721
27	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:421
26	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:244
25	JTable->getFields()	JROOT/libraries/joomla/table/table.php:163
24	JTable->__construct()	JROOT/libraries/kunena/tables/kunenacategories.php:61
23	TableKunenaCategories->__construct()	JROOT/libraries/joomla/table/table.php:311
22	JTable::getInstance()	JROOT/libraries/kunena/database/object.php:282
21	KunenaDatabaseObject->getTable()	JROOT/libraries/kunena/database/object.php:100
20	KunenaDatabaseObject->load()	JROOT/libraries/kunena/forum/category/category.php:1031
19	KunenaForumCategory->load()	JROOT/libraries/kunena/forum/category/helper.php:88
18	KunenaForumCategoryHelper::get()	JROOT/libraries/kunena/html/html/kunenaforum.php:77
17	JHtmlKunenaForum::categorylist()	JROOT/libraries/cms/html/html.php:233
16	JHtml::call()	JROOT/libraries/cms/html/html.php:140
15	JHtml::_()	JROOT/components/com_kunena/controller/category/index/display.php:61
14	ComponentKunenaControllerCategoryIndexDisplay->before()	JROOT/libraries/kunena/controller/display.php:31
13	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/layout/page.php:46
12	KunenaLayoutPage->execute()	JROOT/components/com_kunena/template/nts_kbento/pages/category/list/default.php:13
11	include JROOT/components/com_kunena/template/nts_kbento/pages/category/list/default.php	JROOT/libraries/kunena/layout/base.php:183
10	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
9	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:123
8	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/controller/application/home/default/display.php:107
7	ComponentKunenaControllerApplicationHomeDefaultDisplay->execute()	JROOT/components/com_kunena/kunena.php:96
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

[将 xdebug.file_link_format 指令添加到您的 php.ini 文件以获取文件链接。]

查询时间：0.80 ms 上次查询后：8.39 ms 查询内存：0.025 MB 查询前内存：17.317 MB 返回的行数：0

重复查询: #43

SELECT *

  FROM `joom_kunena_topics`

  WHERE `category_id`='2'

解释

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	joom_kunena_topics	NULL	ref	category_id	category_id	4	const	1	100.00	NULL

轮廓

Status	Duration
starting	0.04 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.03 ms
sending cached result to clien	0.05 ms
cleaned up	0.01 ms
cleaning up	0.00 ms

调用堆栈

#	呼叫者	文件和行号
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1721
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/axslibs/forum.php:38
17	AxsForum::getCategoryCounts()	JROOT/libraries/kunena/forum/category/category.php:1488
16	KunenaForumCategory->buildInfo()	JROOT/libraries/kunena/forum/category/category.php:536
15	KunenaForumCategory->getLastCategory()	JROOT/components/com_kunena/controller/category/index/display.php:146
14	ComponentKunenaControllerCategoryIndexDisplay->before()	JROOT/libraries/kunena/controller/display.php:31
13	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/layout/page.php:46
12	KunenaLayoutPage->execute()	JROOT/components/com_kunena/template/nts_kbento/pages/category/list/default.php:13
11	include JROOT/components/com_kunena/template/nts_kbento/pages/category/list/default.php	JROOT/libraries/kunena/layout/base.php:183
10	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
9	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:123
8	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/controller/application/home/default/display.php:107
7	ComponentKunenaControllerApplicationHomeDefaultDisplay->execute()	JROOT/components/com_kunena/kunena.php:96
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

[将 xdebug.file_link_format 指令添加到您的 php.ini 文件以获取文件链接。]

查询时间：1.11 ms 上次查询后：0.06 ms 查询内存：0.025 MB 查询前内存：17.327 MB 返回的行数：0

重复查询: #44

SELECT *

  FROM `joom_kunena_topics`

  WHERE `category_id`='3'

解释

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	joom_kunena_topics	NULL	ref	category_id	category_id	4	const	1	100.00	NULL

轮廓

Status	Duration
starting	0.02 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.03 ms
cleaned up	0.01 ms
cleaning up	0.00 ms

调用堆栈

#	呼叫者	文件和行号
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1721
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/axslibs/forum.php:38
17	AxsForum::getCategoryCounts()	JROOT/libraries/kunena/forum/category/category.php:1488
16	KunenaForumCategory->buildInfo()	JROOT/libraries/kunena/forum/category/category.php:536
15	KunenaForumCategory->getLastCategory()	JROOT/components/com_kunena/controller/category/index/display.php:146
14	ComponentKunenaControllerCategoryIndexDisplay->before()	JROOT/libraries/kunena/controller/display.php:31
13	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/layout/page.php:46
12	KunenaLayoutPage->execute()	JROOT/components/com_kunena/template/nts_kbento/pages/category/list/default.php:13
11	include JROOT/components/com_kunena/template/nts_kbento/pages/category/list/default.php	JROOT/libraries/kunena/layout/base.php:183
10	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
9	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:123
8	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/controller/application/home/default/display.php:107
7	ComponentKunenaControllerApplicationHomeDefaultDisplay->execute()	JROOT/components/com_kunena/kunena.php:96
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

[将 xdebug.file_link_format 指令添加到您的 php.ini 文件以获取文件链接。]

查询时间：0.76 ms 上次查询后：5.31 ms 查询内存：0.025 MB 查询前内存：17.390 MB 返回的行数：0

SELECT * 
  FROM joom_kunena_topics 
  WHERE id IN (3,2)

解释

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

轮廓

Status	Duration
starting	0.05 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.02 ms
sending cached result to clien	0.05 ms
cleaned up	0.03 ms
cleaning up	0.01 ms

调用堆栈

#	呼叫者	文件和行号
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1526
17	JDatabaseDriver->loadAssocList()	JROOT/libraries/kunena/forum/topic/helper.php:689
16	KunenaForumTopicHelper::loadTopics()	JROOT/libraries/kunena/forum/topic/helper.php:141
15	KunenaForumTopicHelper::getTopics()	JROOT/components/com_kunena/controller/category/index/display.php:173
14	ComponentKunenaControllerCategoryIndexDisplay->before()	JROOT/libraries/kunena/controller/display.php:31
13	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/layout/page.php:46
12	KunenaLayoutPage->execute()	JROOT/components/com_kunena/template/nts_kbento/pages/category/list/default.php:13
11	include JROOT/components/com_kunena/template/nts_kbento/pages/category/list/default.php	JROOT/libraries/kunena/layout/base.php:183
10	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
9	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:123
8	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/controller/application/home/default/display.php:107
7	ComponentKunenaControllerApplicationHomeDefaultDisplay->execute()	JROOT/components/com_kunena/kunena.php:96
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

[将 xdebug.file_link_format 指令添加到您的 php.ini 文件以获取文件链接。]

查询时间：2.08 ms 上次查询后：39.40 ms 查询内存：0.032 MB 查询前内存：17.622 MB 返回的行数：21

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

  FROM joom_modules AS m

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

  LEFT JOIN joom_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 <= '2024-07-13 05:55:13') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-07-13 05:55:13') 
  AND m.access IN (1,1) 
  AND m.client_id = 0 
  AND (mm.menuid = 871 OR mm.menuid <= 0) 
  AND m.language IN ('zh-CN','*')

  ORDER BY m.position, m.ordering

解释

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	range	PRIMARY,idx_language,newsfeeds,published	published	5	NULL	58	1.56	Using index condition; Using where; 使用文件排序
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid	element_clientid	403	root_db.m.module,const	1	10.00	Using index condition; Using where
1	SIMPLE	mm	NULL	ref	PRIMARY	PRIMARY	4	root_db.m.id	3	40.00	Using where; Using index

轮廓

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

调用堆栈

#	呼叫者	文件和行号
27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1721
26	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/cache/controller/callback.php:169
25	JCacheControllerCallback->get()	JROOT/libraries/cms/module/helper.php:424
24	JModuleHelper::getModuleList()	JROOT/libraries/cms/module/helper.php:360
23	JModuleHelper::load()	JROOT/libraries/cms/module/helper.php:84
22	JModuleHelper::getModules()	JROOT/libraries/joomla/document/html.php:576
21	JDocumentHtml->countModules()	JROOT/components/com_kunena/layout/widget/module.php:33
20	KunenaLayoutWidgetModule->renderPosition()	JROOT/components/com_kunena/template/nts_kbento/layouts/widget/module/default.php:13
19	include JROOT/components/com_kunena/template/nts_kbento/layouts/widget/module/default.php	JROOT/libraries/kunena/layout/base.php:183
18	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
17	KunenaLayout->render()	JROOT/libraries/kunena/layout/base.php:91
16	KunenaLayoutBase->__toString()	JROOT/components/com_kunena/template/nts_kbento/layouts/category/index/default.php:29
15	include JROOT/components/com_kunena/template/nts_kbento/layouts/category/index/default.php	JROOT/libraries/kunena/layout/base.php:183
14	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
13	KunenaLayout->render()	JROOT/libraries/kunena/layout/base.php:91
12	KunenaLayoutBase->__toString()	JROOT/components/com_kunena/template/nts_kbento/pages/category/list/default.php:20
11	include JROOT/components/com_kunena/template/nts_kbento/pages/category/list/default.php	JROOT/libraries/kunena/layout/base.php:183
10	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
9	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:123
8	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/controller/application/home/default/display.php:107
7	ComponentKunenaControllerApplicationHomeDefaultDisplay->execute()	JROOT/components/com_kunena/kunena.php:96
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

[将 xdebug.file_link_format 指令添加到您的 php.ini 文件以获取文件链接。]

查询时间：0.74 ms 上次查询后：13.29 ms 查询内存：0.030 MB 查询前内存：18.420 MB 返回的行数：66

SELECT code, location 
  FROM joom_kunena_smileys

解释

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	joom_kunena_smileys	NULL	ALL	NULL	不能使用任何索引键	NULL	NULL	66	100.00	NULL

轮廓

Status	Duration
starting	0.03 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.02 ms
sending cached result to clien	0.03 ms
cleaned up	0.01 ms
cleaning up	0.00 ms

调用堆栈

#	呼叫者	文件和行号
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1721
21	JDatabaseDriver->loadObjectList()	JROOT/libraries/kunena/bbcode/bbcode.php:1030
20	KunenaBbcodeLibrary->__construct()	JROOT/libraries/kunena/bbcode/bbcode.php:44
19	KunenaBbcode->__construct()	JROOT/libraries/kunena/bbcode/bbcode.php:77
18	KunenaBbcode::getInstance()	JROOT/libraries/kunena/html/parser.php:112
17	KunenaHtmlParser::parseBBCode()	JROOT/libraries/kunena/forum/category/category.php:334
16	KunenaForumCategory->displayField()	JROOT/components/com_kunena/template/nts_kbento/layouts/category/index/default.php:47
15	include JROOT/components/com_kunena/template/nts_kbento/layouts/category/index/default.php	JROOT/libraries/kunena/layout/base.php:183
14	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
13	KunenaLayout->render()	JROOT/libraries/kunena/layout/base.php:91
12	KunenaLayoutBase->__toString()	JROOT/components/com_kunena/template/nts_kbento/pages/category/list/default.php:20
11	include JROOT/components/com_kunena/template/nts_kbento/pages/category/list/default.php	JROOT/libraries/kunena/layout/base.php:183
10	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
9	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:123
8	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/controller/application/home/default/display.php:107
7	ComponentKunenaControllerApplicationHomeDefaultDisplay->execute()	JROOT/components/com_kunena/kunena.php:96
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

[将 xdebug.file_link_format 指令添加到您的 php.ini 文件以获取文件链接。]

查询时间：0.65 ms 上次查询后：1.04 ms 查询内存：0.026 MB 查询前内存：18.455 MB 返回的行数：0

SELECT *

  FROM `joom_kunena_topics`

  WHERE `category_id`='1'

解释

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	joom_kunena_topics	NULL	ref	category_id	category_id	4	const	1	100.00	NULL

轮廓

Status	Duration
starting	0.02 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.02 ms
cleaned up	0.01 ms
cleaning up	0.00 ms

调用堆栈

#	呼叫者	文件和行号
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1721
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/axslibs/forum.php:38
18	AxsForum::getCategoryCounts()	JROOT/libraries/kunena/forum/category/category.php:1488
17	KunenaForumCategory->buildInfo()	JROOT/libraries/kunena/forum/category/category.php:223
16	KunenaForumCategory->isSection()	JROOT/components/com_kunena/template/nts_kbento/layouts/category/index/default.php:54
15	include JROOT/components/com_kunena/template/nts_kbento/layouts/category/index/default.php	JROOT/libraries/kunena/layout/base.php:183
14	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
13	KunenaLayout->render()	JROOT/libraries/kunena/layout/base.php:91
12	KunenaLayoutBase->__toString()	JROOT/components/com_kunena/template/nts_kbento/pages/category/list/default.php:20
11	include JROOT/components/com_kunena/template/nts_kbento/pages/category/list/default.php	JROOT/libraries/kunena/layout/base.php:183
10	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
9	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:123
8	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/controller/application/home/default/display.php:107
7	ComponentKunenaControllerApplicationHomeDefaultDisplay->execute()	JROOT/components/com_kunena/kunena.php:96
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

[将 xdebug.file_link_format 指令添加到您的 php.ini 文件以获取文件链接。]

查询时间：0.66 ms 上次查询后：0.05 ms 查询内存：0.026 MB 查询前内存：18.466 MB 返回的行数：0

重复查询: #37

SELECT *

  FROM `joom_kunena_topics`

  WHERE `category_id`='2'

解释

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	joom_kunena_topics	NULL	ref	category_id	category_id	4	const	1	100.00	NULL

轮廓

Status	Duration
starting	0.02 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.02 ms
cleaned up	0.01 ms
cleaning up	0.00 ms

调用堆栈

#	呼叫者	文件和行号
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1721
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/axslibs/forum.php:38
18	AxsForum::getCategoryCounts()	JROOT/libraries/kunena/forum/category/category.php:1488
17	KunenaForumCategory->buildInfo()	JROOT/libraries/kunena/forum/category/category.php:223
16	KunenaForumCategory->isSection()	JROOT/components/com_kunena/template/nts_kbento/layouts/category/index/default.php:54
15	include JROOT/components/com_kunena/template/nts_kbento/layouts/category/index/default.php	JROOT/libraries/kunena/layout/base.php:183
14	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
13	KunenaLayout->render()	JROOT/libraries/kunena/layout/base.php:91
12	KunenaLayoutBase->__toString()	JROOT/components/com_kunena/template/nts_kbento/pages/category/list/default.php:20
11	include JROOT/components/com_kunena/template/nts_kbento/pages/category/list/default.php	JROOT/libraries/kunena/layout/base.php:183
10	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
9	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:123
8	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/controller/application/home/default/display.php:107
7	ComponentKunenaControllerApplicationHomeDefaultDisplay->execute()	JROOT/components/com_kunena/kunena.php:96
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

[将 xdebug.file_link_format 指令添加到您的 php.ini 文件以获取文件链接。]

查询时间：0.65 ms 上次查询后：0.08 ms 查询内存：0.026 MB 查询前内存：18.476 MB 返回的行数：0

重复查询: #38

SELECT *

  FROM `joom_kunena_topics`

  WHERE `category_id`='3'

解释

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	joom_kunena_topics	NULL	ref	category_id	category_id	4	const	1	100.00	NULL

轮廓

Status	Duration
starting	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.02 ms
cleaned up	0.01 ms
cleaning up	0.00 ms

调用堆栈

#	呼叫者	文件和行号
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1721
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/axslibs/forum.php:38
18	AxsForum::getCategoryCounts()	JROOT/libraries/kunena/forum/category/category.php:1488
17	KunenaForumCategory->buildInfo()	JROOT/libraries/kunena/forum/category/category.php:223
16	KunenaForumCategory->isSection()	JROOT/components/com_kunena/template/nts_kbento/layouts/category/index/default.php:54
15	include JROOT/components/com_kunena/template/nts_kbento/layouts/category/index/default.php	JROOT/libraries/kunena/layout/base.php:183
14	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
13	KunenaLayout->render()	JROOT/libraries/kunena/layout/base.php:91
12	KunenaLayoutBase->__toString()	JROOT/components/com_kunena/template/nts_kbento/pages/category/list/default.php:20
11	include JROOT/components/com_kunena/template/nts_kbento/pages/category/list/default.php	JROOT/libraries/kunena/layout/base.php:183
10	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
9	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:123
8	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/controller/application/home/default/display.php:107
7	ComponentKunenaControllerApplicationHomeDefaultDisplay->execute()	JROOT/components/com_kunena/kunena.php:96
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

[将 xdebug.file_link_format 指令添加到您的 php.ini 文件以获取文件链接。]

查询时间：1.31 ms 上次查询后：16.84 ms 查询内存：0.033 MB 查询前内存：18.763 MB 返回的行数：25

SHOW FULL COLUMNS 
  FROM `joom_kunena_topics`

解释

查询时无法解释：SHOW FULL COLUMNS FROM `joom_kunena_topics`

轮廓

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

调用堆栈

#	呼叫者	文件和行号
29	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1721
28	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:421
27	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:244
26	JTable->getFields()	JROOT/libraries/joomla/table/table.php:163
25	JTable->__construct()	JROOT/libraries/kunena/tables/kunenatopics.php:50
24	TableKunenaTopics->__construct()	JROOT/libraries/joomla/table/table.php:311
23	JTable::getInstance()	JROOT/libraries/kunena/database/object.php:282
22	KunenaDatabaseObject->getTable()	JROOT/libraries/kunena/database/object.php:100
21	KunenaDatabaseObject->load()	JROOT/libraries/kunena/forum/topic/topic.php:964
20	KunenaForumTopic->load()	JROOT/libraries/kunena/database/object.php:271
19	KunenaDatabaseObject->__construct()	JROOT/libraries/kunena/forum/topic/topic.php:119
18	KunenaForumTopic->__construct()	JROOT/libraries/kunena/forum/topic/helper.php:47
17	KunenaForumTopicHelper::get()	JROOT/libraries/kunena/forum/category/category.php:546
16	KunenaForumCategory->getLastTopic()	JROOT/components/com_kunena/template/nts_kbento/layouts/category/index/default.php:110
15	include JROOT/components/com_kunena/template/nts_kbento/layouts/category/index/default.php	JROOT/libraries/kunena/layout/base.php:183
14	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
13	KunenaLayout->render()	JROOT/libraries/kunena/layout/base.php:91
12	KunenaLayoutBase->__toString()	JROOT/components/com_kunena/template/nts_kbento/pages/category/list/default.php:20
11	include JROOT/components/com_kunena/template/nts_kbento/pages/category/list/default.php	JROOT/libraries/kunena/layout/base.php:183
10	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
9	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:123
8	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/controller/application/home/default/display.php:107
7	ComponentKunenaControllerApplicationHomeDefaultDisplay->execute()	JROOT/components/com_kunena/kunena.php:96
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

[将 xdebug.file_link_format 指令添加到您的 php.ini 文件以获取文件链接。]

查询时间：1.19 ms 上次查询后：5.34 ms 查询内存：0.024 MB 查询前内存：18.778 MB 返回的行数：0

SELECT userid, MAX(time) AS time

  FROM joom_session

  WHERE client_id=0 
  AND userid>0 
  AND time > 1720848313

  GROUP BY userid

  ORDER BY time DESC

解释

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	joom_session	NULL	range	time,userid	userid	5	NULL	6	3.33	Using index condition; Using where; Using temporary; 使用文件排序

轮廓

Status	Duration
starting	0.03 ms
checking query cache for query	0.09 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.03 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.03 ms
Creating tmp table	0.02 ms
Sorting for group	0.01 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.11 ms
Creating sort index	0.02 ms
end	0.01 ms
query end	0.01 ms
removing tmp table	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
storing result in query cache	0.01 ms
cleaned up	0.01 ms
cleaning up	0.02 ms

调用堆栈

#	呼叫者	文件和行号
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1721
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/kunena/user/helper.php:365
15	KunenaUserHelper::getOnlineUsers()	JROOT/components/com_kunena/controller/widget/whoisonline/display.php:45
14	ComponentKunenaControllerWidgetWhoisonlineDisplay->before()	JROOT/libraries/kunena/controller/display.php:31
13	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/controller/display.php:127
12	KunenaControllerDisplay->__toString()	JROOT/components/com_kunena/template/nts_kbento/pages/category/list/default.php:21
11	include JROOT/components/com_kunena/template/nts_kbento/pages/category/list/default.php	JROOT/libraries/kunena/layout/base.php:183
10	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
9	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:123
8	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/controller/application/home/default/display.php:107
7	ComponentKunenaControllerApplicationHomeDefaultDisplay->execute()	JROOT/components/com_kunena/kunena.php:96
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

[将 xdebug.file_link_format 指令添加到您的 php.ini 文件以获取文件链接。]

查询时间：90.95 ms 上次查询后：0.05 ms 查询内存：0.024 MB 查询前内存：18.786 MB 返回的行数：1

SELECT COUNT(*)

  FROM joom_session

  WHERE client_id=0 
  AND userid=0 
  AND time > 1720848313

解释

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	joom_session	NULL	ref	time,userid	userid	5	const	16662	3.33	Using where

轮廓

Status	Duration
starting	0.02 ms
checking query cache for query	0.05 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.03 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	89.91 ms
end	0.02 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.05 ms
storing result in query cache	0.01 ms
cleaned up	0.03 ms
cleaning up	0.01 ms

调用堆栈

#	呼叫者	文件和行号
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1760
16	JDatabaseDriver->loadResult()	JROOT/libraries/kunena/user/helper.php:484
15	KunenaUserHelper::getOnlineCount()	JROOT/components/com_kunena/controller/widget/whoisonline/display.php:47
14	ComponentKunenaControllerWidgetWhoisonlineDisplay->before()	JROOT/libraries/kunena/controller/display.php:31
13	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/controller/display.php:127
12	KunenaControllerDisplay->__toString()	JROOT/components/com_kunena/template/nts_kbento/pages/category/list/default.php:21
11	include JROOT/components/com_kunena/template/nts_kbento/pages/category/list/default.php	JROOT/libraries/kunena/layout/base.php:183
10	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
9	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:123
8	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/controller/application/home/default/display.php:107
7	ComponentKunenaControllerApplicationHomeDefaultDisplay->execute()	JROOT/components/com_kunena/kunena.php:96
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

[将 xdebug.file_link_format 指令添加到您的 php.ini 文件以获取文件链接。]

查询时间：1.19 ms 上次查询后：34.42 ms 查询内存：0.028 MB 查询前内存：18.984 MB 返回的行数：2

SHOW FULL COLUMNS 
  FROM `joom_community_config`

解释

查询时无法解释：SHOW FULL COLUMNS FROM `joom_community_config`

轮廓

Status	Duration
starting	0.07 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.14 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.00 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.01 ms
Sending data	0.04 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
removing tmp table	0.03 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaned up	0.02 ms
cleaning up	0.01 ms

调用堆栈

#	呼叫者	文件和行号
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1721
24	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:421
23	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:244
22	JTable->getFields()	JROOT/libraries/joomla/table/table.php:163
21	JTable->__construct()	JROOT/administrator/components/com_community/tables/configuration.php:22
20	CommunityTableConfiguration->__construct()	JROOT/libraries/joomla/table/table.php:311
19	JTable::getInstance()	JROOT/components/com_community/libraries/core.php:1057
18	CConfig::getInstance()	JROOT/components/com_community/libraries/core.php:237
17	CFactory::getConfig()	JROOT/components/com_community/libraries/core.php:1257
16	CRoute::_()	JROOT/plugins/kunena/community/profile.php:45
15	KunenaProfileCommunity->getUserListURL()	JROOT/components/com_kunena/controller/widget/whoisonline/display.php:99
14	ComponentKunenaControllerWidgetWhoisonlineDisplay->before()	JROOT/libraries/kunena/controller/display.php:31
13	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/controller/display.php:127
12	KunenaControllerDisplay->__toString()	JROOT/components/com_kunena/template/nts_kbento/pages/category/list/default.php:21
11	include JROOT/components/com_kunena/template/nts_kbento/pages/category/list/default.php	JROOT/libraries/kunena/layout/base.php:183
10	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
9	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:123
8	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/controller/application/home/default/display.php:107
7	ComponentKunenaControllerApplicationHomeDefaultDisplay->execute()	JROOT/components/com_kunena/kunena.php:96
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

[将 xdebug.file_link_format 指令添加到您的 php.ini 文件以获取文件链接。]

查询时间：0.65 ms 上次查询后：0.11 ms 查询内存：0.026 MB 查询前内存：19.001 MB 返回的行数：1

SELECT *

  FROM joom_community_config

  WHERE `name` = 'config'

解释

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

轮廓

Status	Duration
starting	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.02 ms
cleaned up	0.01 ms
cleaning up	0.01 ms

调用堆栈

#	呼叫者	文件和行号
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1485
20	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:729
19	JTable->load()	JROOT/components/com_community/libraries/core.php:1058
18	CConfig::getInstance()	JROOT/components/com_community/libraries/core.php:237
17	CFactory::getConfig()	JROOT/components/com_community/libraries/core.php:1257
16	CRoute::_()	JROOT/plugins/kunena/community/profile.php:45
15	KunenaProfileCommunity->getUserListURL()	JROOT/components/com_kunena/controller/widget/whoisonline/display.php:99
14	ComponentKunenaControllerWidgetWhoisonlineDisplay->before()	JROOT/libraries/kunena/controller/display.php:31
13	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/controller/display.php:127
12	KunenaControllerDisplay->__toString()	JROOT/components/com_kunena/template/nts_kbento/pages/category/list/default.php:21
11	include JROOT/components/com_kunena/template/nts_kbento/pages/category/list/default.php	JROOT/libraries/kunena/layout/base.php:183
10	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
9	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:123
8	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/controller/application/home/default/display.php:107
7	ComponentKunenaControllerApplicationHomeDefaultDisplay->execute()	JROOT/components/com_kunena/kunena.php:96
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

[将 xdebug.file_link_format 指令添加到您的 php.ini 文件以获取文件链接。]

查询时间：1.76 ms 上次查询后：28.02 ms 查询内存：0.027 MB 查询前内存：19.192 MB 返回的行数：1

SELECT * 
  FROM joom_extensions 
  WHERE name='com_media'

解释

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	joom_extensions	NULL	ALL	NULL	不能使用任何索引键	NULL	NULL	653	10.00	Using where

轮廓

Status	Duration
starting	0.03 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.08 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.03 ms
executing	0.00 ms
Sending data	0.80 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaned up	0.01 ms
cleaning up	0.00 ms

调用堆栈

#	呼叫者	文件和行号
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1682
21	JDatabaseDriver->loadObject()	JROOT/libraries/axslibs/images.php:66
20	AxsImages::setSession()	JROOT/libraries/axslibs/images.php:15
19	AxsImages::getImagesPath()	JROOT/components/com_community/libraries/core.php:1092
18	CConfig::getInstance()	JROOT/components/com_community/libraries/core.php:237
17	CFactory::getConfig()	JROOT/components/com_community/libraries/core.php:1257
16	CRoute::_()	JROOT/plugins/kunena/community/profile.php:45
15	KunenaProfileCommunity->getUserListURL()	JROOT/components/com_kunena/controller/widget/whoisonline/display.php:99
14	ComponentKunenaControllerWidgetWhoisonlineDisplay->before()	JROOT/libraries/kunena/controller/display.php:31
13	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/controller/display.php:127
12	KunenaControllerDisplay->__toString()	JROOT/components/com_kunena/template/nts_kbento/pages/category/list/default.php:21
11	include JROOT/components/com_kunena/template/nts_kbento/pages/category/list/default.php	JROOT/libraries/kunena/layout/base.php:183
10	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
9	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:123
8	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/controller/application/home/default/display.php:107
7	ComponentKunenaControllerApplicationHomeDefaultDisplay->execute()	JROOT/components/com_kunena/kunena.php:96
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

[将 xdebug.file_link_format 指令添加到您的 php.ini 文件以获取文件链接。]

查询时间：0.69 ms 上次查询后：5.47 ms 查询内存：0.025 MB 查询前内存：19.215 MB 返回的行数：0

SELECT `id` 
  FROM `joom_menu` 
  WHERE `link` LIKE '%option=com_community&view=search%' 
  AND `published`='1' 
  AND `menutype`!='jomsocial' 
  AND `type`='component'

解释

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	joom_menu	NULL	ALL	idx_menutype	不能使用任何索引键	NULL	NULL	257	0.39	Using where

轮廓

Status	Duration
starting	0.03 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.02 ms
sending cached result to clien	0.03 ms
cleaned up	0.02 ms
cleaning up	0.00 ms

调用堆栈

#	呼叫者	文件和行号
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1760
18	JDatabaseDriver->loadResult()	JROOT/components/com_community/libraries/core.php:1391
17	CRoute::_getViewItemid()	JROOT/components/com_community/libraries/core.php:1301
16	CRoute::_()	JROOT/plugins/kunena/community/profile.php:45
15	KunenaProfileCommunity->getUserListURL()	JROOT/components/com_kunena/controller/widget/whoisonline/display.php:99
14	ComponentKunenaControllerWidgetWhoisonlineDisplay->before()	JROOT/libraries/kunena/controller/display.php:31
13	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/controller/display.php:127
12	KunenaControllerDisplay->__toString()	JROOT/components/com_kunena/template/nts_kbento/pages/category/list/default.php:21
11	include JROOT/components/com_kunena/template/nts_kbento/pages/category/list/default.php	JROOT/libraries/kunena/layout/base.php:183
10	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
9	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:123
8	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/controller/application/home/default/display.php:107
7	ComponentKunenaControllerApplicationHomeDefaultDisplay->execute()	JROOT/components/com_kunena/kunena.php:96
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

[将 xdebug.file_link_format 指令添加到您的 php.ini 文件以获取文件链接。]

查询时间：0.61 ms 上次查询后：0.04 ms 查询内存：0.025 MB 查询前内存：19.224 MB 返回的行数：0

SELECT `id` 
  FROM `joom_menu` 
  WHERE `link` = 'index.php?option=com_community&view=frontpage' 
  AND `published`='1' 
  AND `type`='component' 
  AND (`language` = 'zh-CN' )

解释

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	joom_menu	NULL	ref	idx_language	idx_language	28	const	1	5.00	Using where

轮廓

Status	Duration
starting	0.01 ms
checking query cache for query	0.02 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.02 ms
cleaned up	0.01 ms
cleaning up	0.00 ms

调用堆栈

#	呼叫者	文件和行号
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1760
18	JDatabaseDriver->loadResult()	JROOT/components/com_community/libraries/core.php:1431
17	CRoute::_getDefaultItemid()	JROOT/components/com_community/libraries/core.php:1316
16	CRoute::_()	JROOT/plugins/kunena/community/profile.php:45
15	KunenaProfileCommunity->getUserListURL()	JROOT/components/com_kunena/controller/widget/whoisonline/display.php:99
14	ComponentKunenaControllerWidgetWhoisonlineDisplay->before()	JROOT/libraries/kunena/controller/display.php:31
13	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/controller/display.php:127
12	KunenaControllerDisplay->__toString()	JROOT/components/com_kunena/template/nts_kbento/pages/category/list/default.php:21
11	include JROOT/components/com_kunena/template/nts_kbento/pages/category/list/default.php	JROOT/libraries/kunena/layout/base.php:183
10	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
9	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:123
8	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/controller/application/home/default/display.php:107
7	ComponentKunenaControllerApplicationHomeDefaultDisplay->execute()	JROOT/components/com_kunena/kunena.php:96
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

[将 xdebug.file_link_format 指令添加到您的 php.ini 文件以获取文件链接。]

查询时间：0.58 ms 上次查询后：0.02 ms 查询内存：0.026 MB 查询前内存：19.234 MB 返回的行数：27

SELECT `id` 
  FROM `joom_menu` 
  WHERE `link` LIKE '%option=com_community%' 
  AND `published`='1' 
  AND `type`='component'

解释

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	joom_menu	NULL	ALL	NULL	不能使用任何索引键	NULL	NULL	257	0.39	Using where

轮廓

Status	Duration
starting	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.01 ms
cleaned up	0.01 ms
cleaning up	0.00 ms

调用堆栈

#	呼叫者	文件和行号
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1760
18	JDatabaseDriver->loadResult()	JROOT/components/com_community/libraries/core.php:1440
17	CRoute::_getDefaultItemid()	JROOT/components/com_community/libraries/core.php:1316
16	CRoute::_()	JROOT/plugins/kunena/community/profile.php:45
15	KunenaProfileCommunity->getUserListURL()	JROOT/components/com_kunena/controller/widget/whoisonline/display.php:99
14	ComponentKunenaControllerWidgetWhoisonlineDisplay->before()	JROOT/libraries/kunena/controller/display.php:31
13	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/controller/display.php:127
12	KunenaControllerDisplay->__toString()	JROOT/components/com_kunena/template/nts_kbento/pages/category/list/default.php:21
11	include JROOT/components/com_kunena/template/nts_kbento/pages/category/list/default.php	JROOT/libraries/kunena/layout/base.php:183
10	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
9	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:123
8	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/controller/application/home/default/display.php:107
7	ComponentKunenaControllerApplicationHomeDefaultDisplay->execute()	JROOT/components/com_kunena/kunena.php:96
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

[将 xdebug.file_link_format 指令添加到您的 php.ini 文件以获取文件链接。]

查询时间：0.73 ms 上次查询后：21.61 ms 查询内存：0.025 MB 查询前内存：19.303 MB 返回的行数：1

SELECT COUNT(*), MAX(id) 
  FROM joom_users 
  WHERE (block=0 OR activation="")

解释

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	joom_users	NULL	ALL	idx_block	不能使用任何索引键	NULL	NULL	1022	100.00	Using where

轮廓

Status	Duration
starting	0.03 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.02 ms
sending cached result to clien	0.03 ms
cleaned up	0.01 ms
cleaning up	0.01 ms

调用堆栈

#	呼叫者	文件和行号
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1793
18	JDatabaseDriver->loadRow()	JROOT/libraries/kunena/user/helper.php:277
17	KunenaUserHelper::getTotalCount()	JROOT/libraries/kunena/forum/statistics.php:181
16	KunenaForumStatistics->loadMemberCount()	JROOT/libraries/kunena/forum/statistics.php:103
15	KunenaForumStatistics->loadGeneral()	JROOT/components/com_kunena/controller/widget/statistics/display.php:45
14	ComponentKunenaControllerWidgetStatisticsDisplay->before()	JROOT/libraries/kunena/controller/display.php:31
13	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/controller/display.php:127
12	KunenaControllerDisplay->__toString()	JROOT/components/com_kunena/template/nts_kbento/pages/category/list/default.php:22
11	include JROOT/components/com_kunena/template/nts_kbento/pages/category/list/default.php	JROOT/libraries/kunena/layout/base.php:183
10	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
9	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:123
8	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/controller/application/home/default/display.php:107
7	ComponentKunenaControllerApplicationHomeDefaultDisplay->execute()	JROOT/components/com_kunena/kunena.php:96
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

[将 xdebug.file_link_format 指令添加到您的 php.ini 文件以获取文件链接。]

查询时间：0.64 ms 上次查询后：0.06 ms 查询内存：0.025 MB 查询前内存：19.313 MB 返回的行数：1

SELECT
				SUM(time>=1720828800 
  AND parent=0) AS todayTopicCount,
				SUM(time>=1720828800 
  AND parent>0) AS todayReplyCount,
				SUM(time>=1720742400 
  AND time<1720828800 
  AND parent=0) AS yesterdayTopicCount,
				SUM(time>=1720742400 
  AND time<1720828800 
  AND parent>0) AS yesterdayReplyCount
				
  FROM joom_kunena_messages 
  WHERE time>=1720742400 
  AND hold=0

解释

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	joom_kunena_messages	NULL	range	hold_time,time	hold_time	5	NULL	1	100.00	Using index condition

轮廓

Status	Duration
starting	0.02 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.02 ms
cleaned up	0.01 ms
cleaning up	0.00 ms

调用堆栈

#	呼叫者	文件和行号
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1682
17	JDatabaseDriver->loadObject()	JROOT/libraries/kunena/forum/statistics.php:227
16	KunenaForumStatistics->loadLastDays()	JROOT/libraries/kunena/forum/statistics.php:106
15	KunenaForumStatistics->loadGeneral()	JROOT/components/com_kunena/controller/widget/statistics/display.php:45
14	ComponentKunenaControllerWidgetStatisticsDisplay->before()	JROOT/libraries/kunena/controller/display.php:31
13	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/controller/display.php:127
12	KunenaControllerDisplay->__toString()	JROOT/components/com_kunena/template/nts_kbento/pages/category/list/default.php:22
11	include JROOT/components/com_kunena/template/nts_kbento/pages/category/list/default.php	JROOT/libraries/kunena/layout/base.php:183
10	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
9	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:123
8	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/controller/application/home/default/display.php:107
7	ComponentKunenaControllerApplicationHomeDefaultDisplay->execute()	JROOT/components/com_kunena/kunena.php:96
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

[将 xdebug.file_link_format 指令添加到您的 php.ini 文件以获取文件链接。]

查询时间：0.63 ms 上次查询后：0.07 ms 查询内存：0.027 MB 查询前内存：19.334 MB 返回的行数：1

SELECT u.name, u.username, u.email, u.block as blocked, u.registerDate, u.lastvisitDate, ku.*
			
  FROM joom_users AS u
			
  LEFT JOIN joom_kunena_users AS ku 
  ON u.id = ku.userid
			
  WHERE u.id = 1621330

解释

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	u	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	ku	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

轮廓

Status	Duration
starting	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
sending cached result to clien	0.01 ms
cleaned up	0.02 ms
cleaning up	0.00 ms

调用堆栈

#	呼叫者	文件和行号
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1485
20	JDatabaseDriver->loadAssoc()	JROOT/libraries/kunena/tables/kunenausers.php:365
19	TableKunenaUsers->load()	JROOT/libraries/kunena/user/user.php:280
18	KunenaUser->load()	JROOT/libraries/kunena/user/user.php:100
17	KunenaUser->__construct()	JROOT/libraries/kunena/user/helper.php:115
16	KunenaUserHelper::get()	JROOT/libraries/kunena/factory.php:71
15	KunenaFactory::getUser()	JROOT/components/com_kunena/controller/widget/statistics/display.php:48
14	ComponentKunenaControllerWidgetStatisticsDisplay->before()	JROOT/libraries/kunena/controller/display.php:31
13	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/controller/display.php:127
12	KunenaControllerDisplay->__toString()	JROOT/components/com_kunena/template/nts_kbento/pages/category/list/default.php:22
11	include JROOT/components/com_kunena/template/nts_kbento/pages/category/list/default.php	JROOT/libraries/kunena/layout/base.php:183
10	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
9	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:123
8	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/controller/application/home/default/display.php:107
7	ComponentKunenaControllerApplicationHomeDefaultDisplay->execute()	JROOT/components/com_kunena/kunena.php:96
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

[将 xdebug.file_link_format 指令添加到您的 php.ini 文件以获取文件链接。]

查询时间：1.11 ms 上次查询后：0.10 ms 查询内存：0.026 MB 查询前内存：19.344 MB 返回的行数：1

SELECT   a.`userid` as _userid , a.`status` as _status ,  a.`points` as _points,  a.`posted_on` as _posted_on,  a.`avatar` as _avatar ,  a.`thumb` as _thumb ,  a.`invite` as _invite,  a.`params` as _cparams,   a.`view` as _view,  a.`friends` as _friends,  a.`groups` as _groups,  a.`events` as _events,  a.`alias`	as _alias,  a.`profile_id` as _profile_id,  a.`friendcount` as _friendcount,  a.`storage` as _storage,  a.`watermark_hash` as _watermark_hash,  a.`search_email` AS _search_email,  s.`userid` as _isonline, u.*  
  FROM `joom_community_users` as a  
  LEFT JOIN `joom_users` u  
  ON u.`id`=a.`userid` 
  LEFT 
  OUTER JOIN `joom_session`s  
  ON s.`userid`=a.`userid` 
  WHERE a.`userid` IN (1621330)

解释

id	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	u	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	s	NULL	ref	userid	userid	5	const	1	100.00	Using index

轮廓

Status	Duration
starting	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.15 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.04 ms
System lock	0.03 ms
optimizing	0.01 ms
statistics	0.10 ms
preparing	0.02 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.03 ms
storing result in query cache	0.01 ms
cleaned up	0.01 ms
cleaning up	0.02 ms

调用堆栈

#	呼叫者	文件和行号
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1721
19	JDatabaseDriver->loadObjectList()	JROOT/components/com_community/libraries/core.php:124
18	CFactory::loadUsers()	JROOT/plugins/kunena/community/avatar.php:37
17	KunenaAvatarCommunity->load()	JROOT/libraries/kunena/user/helper.php:119
16	KunenaUserHelper::get()	JROOT/libraries/kunena/factory.php:71
15	KunenaFactory::getUser()	JROOT/components/com_kunena/controller/widget/statistics/display.php:48
14	ComponentKunenaControllerWidgetStatisticsDisplay->before()	JROOT/libraries/kunena/controller/display.php:31
13	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/controller/display.php:127
12	KunenaControllerDisplay->__toString()	JROOT/components/com_kunena/template/nts_kbento/pages/category/list/default.php:22
11	include JROOT/components/com_kunena/template/nts_kbento/pages/category/list/default.php	JROOT/libraries/kunena/layout/base.php:183
10	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
9	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:123
8	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/controller/application/home/default/display.php:107
7	ComponentKunenaControllerApplicationHomeDefaultDisplay->execute()	JROOT/components/com_kunena/kunena.php:96
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

[将 xdebug.file_link_format 指令添加到您的 php.ini 文件以获取文件链接。]

查询时间：3.08 ms 上次查询后：12.82 ms 查询内存：0.030 MB 查询前内存：19.570 MB 返回的行数：15

SHOW FULL COLUMNS 
  FROM `joom_community_profiles`

解释

查询时无法解释：SHOW FULL COLUMNS FROM `joom_community_profiles`

轮廓

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.14 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.00 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
Sending data	0.05 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.00 ms
removing tmp table	0.03 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaned up	0.01 ms
cleaning up	0.00 ms

调用堆栈

#	呼叫者	文件和行号
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1721
25	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:421
24	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:244
23	JTable->getFields()	JROOT/libraries/joomla/table/table.php:163
22	JTable->__construct()	JROOT/components/com_community/tables/multiprofile.php:32
21	CTableMultiProfile->__construct()	JROOT/libraries/joomla/table/table.php:311
20	JTable::getInstance()	JROOT/components/com_community/libraries/user.php:732
19	CUser->getThumbAvatar()	JROOT/components/com_community/libraries/core.php:130
18	CFactory::loadUsers()	JROOT/plugins/kunena/community/avatar.php:37
17	KunenaAvatarCommunity->load()	JROOT/libraries/kunena/user/helper.php:119
16	KunenaUserHelper::get()	JROOT/libraries/kunena/factory.php:71
15	KunenaFactory::getUser()	JROOT/components/com_kunena/controller/widget/statistics/display.php:48
14	ComponentKunenaControllerWidgetStatisticsDisplay->before()	JROOT/libraries/kunena/controller/display.php:31
13	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/controller/display.php:127
12	KunenaControllerDisplay->__toString()	JROOT/components/com_kunena/template/nts_kbento/pages/category/list/default.php:22
11	include JROOT/components/com_kunena/template/nts_kbento/pages/category/list/default.php	JROOT/libraries/kunena/layout/base.php:183
10	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
9	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:123
8	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/controller/application/home/default/display.php:107
7	ComponentKunenaControllerApplicationHomeDefaultDisplay->execute()	JROOT/components/com_kunena/kunena.php:96
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

[将 xdebug.file_link_format 指令添加到您的 php.ini 文件以获取文件链接。]

查询时间：0.79 ms 上次查询后：14.29 ms 查询内存：0.027 MB 查询前内存：19.765 MB 返回的行数：1

SELECT `id` 
  FROM `joom_community_fields` 
  WHERE `fieldcode`='FIELD_GENDER'

解释

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	joom_community_fields	NULL	ref	fieldcode	fieldcode	767	const	1	100.00	Using index

轮廓

Status	Duration
starting	0.03 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.04 ms
sending cached result to clien	0.04 ms
cleaned up	0.01 ms
cleaning up	0.01 ms

调用堆栈

#	呼叫者	文件和行号
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1760
23	JDatabaseDriver->loadResult()	JROOT/components/com_community/models/profile.php:788
22	CommunityModelProfile->_getgenderId()	JROOT/components/com_community/models/profile.php:762
21	CommunityModelProfile->getGender()	JROOT/components/com_community/libraries/user.php:629
20	CUser->_getGender()	JROOT/components/com_community/libraries/user.php:767
19	CUser->getThumbAvatar()	JROOT/components/com_community/libraries/core.php:130
18	CFactory::loadUsers()	JROOT/plugins/kunena/community/avatar.php:37
17	KunenaAvatarCommunity->load()	JROOT/libraries/kunena/user/helper.php:119
16	KunenaUserHelper::get()	JROOT/libraries/kunena/factory.php:71
15	KunenaFactory::getUser()	JROOT/components/com_kunena/controller/widget/statistics/display.php:48
14	ComponentKunenaControllerWidgetStatisticsDisplay->before()	JROOT/libraries/kunena/controller/display.php:31
13	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/controller/display.php:127
12	KunenaControllerDisplay->__toString()	JROOT/components/com_kunena/template/nts_kbento/pages/category/list/default.php:22
11	include JROOT/components/com_kunena/template/nts_kbento/pages/category/list/default.php	JROOT/libraries/kunena/layout/base.php:183
10	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
9	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:123
8	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/controller/application/home/default/display.php:107
7	ComponentKunenaControllerApplicationHomeDefaultDisplay->execute()	JROOT/components/com_kunena/kunena.php:96
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

[将 xdebug.file_link_format 指令添加到您的 php.ini 文件以获取文件链接。]

查询时间：0.63 ms 上次查询后：0.04 ms 查询内存：0.026 MB 查询前内存：19.776 MB 返回的行数：0

重复查询: #63

SELECT `value` 
  FROM `joom_community_fields_values` 
  WHERE `field_id` = '2' 
  AND `user_id` = '1621330'

解释

id	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.02 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.02 ms
cleaned up	0.01 ms
cleaning up	0.00 ms

调用堆栈

#	呼叫者	文件和行号
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1760
22	JDatabaseDriver->loadResult()	JROOT/components/com_community/models/profile.php:771
21	CommunityModelProfile->getGender()	JROOT/components/com_community/libraries/user.php:629
20	CUser->_getGender()	JROOT/components/com_community/libraries/user.php:767
19	CUser->getThumbAvatar()	JROOT/components/com_community/libraries/core.php:130
18	CFactory::loadUsers()	JROOT/plugins/kunena/community/avatar.php:37
17	KunenaAvatarCommunity->load()	JROOT/libraries/kunena/user/helper.php:119
16	KunenaUserHelper::get()	JROOT/libraries/kunena/factory.php:71
15	KunenaFactory::getUser()	JROOT/components/com_kunena/controller/widget/statistics/display.php:48
14	ComponentKunenaControllerWidgetStatisticsDisplay->before()	JROOT/libraries/kunena/controller/display.php:31
13	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/controller/display.php:127
12	KunenaControllerDisplay->__toString()	JROOT/components/com_kunena/template/nts_kbento/pages/category/list/default.php:22
11	include JROOT/components/com_kunena/template/nts_kbento/pages/category/list/default.php	JROOT/libraries/kunena/layout/base.php:183
10	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
9	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:123
8	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/controller/application/home/default/display.php:107
7	ComponentKunenaControllerApplicationHomeDefaultDisplay->execute()	JROOT/components/com_kunena/kunena.php:96
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

[将 xdebug.file_link_format 指令添加到您的 php.ini 文件以获取文件链接。]

查询时间：0.77 ms 上次查询后：14.99 ms 查询内存：0.025 MB 查询前内存：19.807 MB 返回的行数：1

SELECT `id` 
  FROM `joom_users` 
  WHERE id='1621330'

解释

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	joom_users	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	Using index

轮廓

Status	Duration
starting	0.03 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.03 ms
sending cached result to clien	0.04 ms
cleaned up	0.01 ms
cleaning up	0.00 ms

调用堆栈

#	呼叫者	文件和行号
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1760
19	JDatabaseDriver->loadResult()	JROOT/components/com_community/libraries/core.php:190
18	CFactory::getUser()	JROOT/plugins/kunena/community/profile.php:58
17	KunenaProfileCommunity->getProfileURL()	JROOT/libraries/kunena/user/user.php:663
16	KunenaUser->getURL()	JROOT/libraries/kunena/user/user.php:602
15	KunenaUser->getLink()	JROOT/components/com_kunena/controller/widget/statistics/display.php:48
14	ComponentKunenaControllerWidgetStatisticsDisplay->before()	JROOT/libraries/kunena/controller/display.php:31
13	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/controller/display.php:127
12	KunenaControllerDisplay->__toString()	JROOT/components/com_kunena/template/nts_kbento/pages/category/list/default.php:22
11	include JROOT/components/com_kunena/template/nts_kbento/pages/category/list/default.php	JROOT/libraries/kunena/layout/base.php:183
10	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
9	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:123
8	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/controller/application/home/default/display.php:107
7	ComponentKunenaControllerApplicationHomeDefaultDisplay->execute()	JROOT/components/com_kunena/kunena.php:96
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

[将 xdebug.file_link_format 指令添加到您的 php.ini 文件以获取文件链接。]

查询时间：1.23 ms 上次查询后：0.05 ms 查询内存：0.026 MB 查询前内存：19.819 MB 返回的行数：1

SELECT  	a.`userid` as _userid , 	a.`status` as _status , 	a.`points`	as _points, 	a.`posted_on` as _posted_on, 	a.`avatar`	as _avatar , 	a.`cover`	as _cover , 	a.`thumb`	as _thumb , 	a.`invite`	as _invite, 	a.`params`	as _cparams,  	a.`view`	as _view,  a.`friends` as _friends,  a.`groups` as _groups,  a.`events` as _events,  a.`friendcount` as _friendcount,  a.`alias` as _alias,  a.`profile_id` as _profile_id,  a.`storage` as _storage,  a.`watermark_hash` as _watermark_hash,  a.`search_email` as _search_email,  s.`userid` as _isonline, u.*  
  FROM `joom_community_users` as a  
  LEFT JOIN `joom_users` u  
  ON u.`id`=a.`userid` 
  LEFT 
  OUTER JOIN `joom_session` s  
  ON s.`userid`=a.`userid` 
  AND s.`client_id` !='1' 
  WHERE a.`userid`='1621330'

解释

id	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	u	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	s	NULL	ref	userid	userid	5	const	1	100.00	Using where

轮廓

Status	Duration
starting	0.02 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.17 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.04 ms
System lock	0.03 ms
optimizing	0.02 ms
statistics	0.10 ms
preparing	0.03 ms
executing	0.00 ms
Sending data	0.04 ms
end	0.05 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
storing result in query cache	0.01 ms
cleaned up	0.01 ms
cleaning up	0.00 ms

调用堆栈

#	呼叫者	文件和行号
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1682
20	JDatabaseDriver->loadObject()	JROOT/components/com_community/libraries/user.php:168
19	CUser->init()	JROOT/components/com_community/libraries/core.php:201
18	CFactory::getUser()	JROOT/plugins/kunena/community/profile.php:58
17	KunenaProfileCommunity->getProfileURL()	JROOT/libraries/kunena/user/user.php:663
16	KunenaUser->getURL()	JROOT/libraries/kunena/user/user.php:602
15	KunenaUser->getLink()	JROOT/components/com_kunena/controller/widget/statistics/display.php:48
14	ComponentKunenaControllerWidgetStatisticsDisplay->before()	JROOT/libraries/kunena/controller/display.php:31
13	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/controller/display.php:127
12	KunenaControllerDisplay->__toString()	JROOT/components/com_kunena/template/nts_kbento/pages/category/list/default.php:22
11	include JROOT/components/com_kunena/template/nts_kbento/pages/category/list/default.php	JROOT/libraries/kunena/layout/base.php:183
10	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
9	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:123
8	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/controller/application/home/default/display.php:107
7	ComponentKunenaControllerApplicationHomeDefaultDisplay->execute()	JROOT/components/com_kunena/kunena.php:96
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

[将 xdebug.file_link_format 指令添加到您的 php.ini 文件以获取文件链接。]

查询时间：0.65 ms 上次查询后：0.12 ms 查询内存：0.026 MB 查询前内存：19.846 MB 返回的行数：0

重复查询: #60

SELECT `value` 
  FROM `joom_community_fields_values` 
  WHERE `field_id` = '2' 
  AND `user_id` = '1621330'

解释

id	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.02 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.02 ms
cleaned up	0.01 ms
cleaning up	0.00 ms

调用堆栈

#	呼叫者	文件和行号
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1760
22	JDatabaseDriver->loadResult()	JROOT/components/com_community/models/profile.php:771
21	CommunityModelProfile->getGender()	JROOT/components/com_community/libraries/user.php:629
20	CUser->_getGender()	JROOT/components/com_community/libraries/user.php:767
19	CUser->getThumbAvatar()	JROOT/components/com_community/libraries/core.php:202
18	CFactory::getUser()	JROOT/plugins/kunena/community/profile.php:58
17	KunenaProfileCommunity->getProfileURL()	JROOT/libraries/kunena/user/user.php:663
16	KunenaUser->getURL()	JROOT/libraries/kunena/user/user.php:602
15	KunenaUser->getLink()	JROOT/components/com_kunena/controller/widget/statistics/display.php:48
14	ComponentKunenaControllerWidgetStatisticsDisplay->before()	JROOT/libraries/kunena/controller/display.php:31
13	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/controller/display.php:127
12	KunenaControllerDisplay->__toString()	JROOT/components/com_kunena/template/nts_kbento/pages/category/list/default.php:22
11	include JROOT/components/com_kunena/template/nts_kbento/pages/category/list/default.php	JROOT/libraries/kunena/layout/base.php:183
10	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
9	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:123
8	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/controller/application/home/default/display.php:107
7	ComponentKunenaControllerApplicationHomeDefaultDisplay->execute()	JROOT/components/com_kunena/kunena.php:96
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

[将 xdebug.file_link_format 指令添加到您的 php.ini 文件以获取文件链接。]

查询时间：0.67 ms 上次查询后：0.16 ms 查询内存：0.026 MB 查询前内存：19.857 MB 返回的行数：3

SELECT `id` 
  FROM `joom_menu` 
  WHERE `link` LIKE '%option=com_community&view=profile%' 
  AND `published`='1' 
  AND `menutype`!='jomsocial' 
  AND `type`='component'

解释

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	joom_menu	NULL	ALL	idx_menutype	不能使用任何索引键	NULL	NULL	257	0.39	Using where

轮廓

Status	Duration
starting	0.02 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.02 ms
sending cached result to clien	0.02 ms
cleaned up	0.01 ms
cleaning up	0.01 ms

调用堆栈

#	呼叫者	文件和行号
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1760
20	JDatabaseDriver->loadResult()	JROOT/components/com_community/libraries/core.php:1391
19	CRoute::_getViewItemid()	JROOT/components/com_community/libraries/core.php:1301
18	CRoute::_()	JROOT/plugins/kunena/community/profile.php:63
17	KunenaProfileCommunity->getProfileURL()	JROOT/libraries/kunena/user/user.php:663
16	KunenaUser->getURL()	JROOT/libraries/kunena/user/user.php:602
15	KunenaUser->getLink()	JROOT/components/com_kunena/controller/widget/statistics/display.php:48
14	ComponentKunenaControllerWidgetStatisticsDisplay->before()	JROOT/libraries/kunena/controller/display.php:31
13	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/controller/display.php:127
12	KunenaControllerDisplay->__toString()	JROOT/components/com_kunena/template/nts_kbento/pages/category/list/default.php:22
11	include JROOT/components/com_kunena/template/nts_kbento/pages/category/list/default.php	JROOT/libraries/kunena/layout/base.php:183
10	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
9	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:123
8	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/controller/application/home/default/display.php:107
7	ComponentKunenaControllerApplicationHomeDefaultDisplay->execute()	JROOT/components/com_kunena/kunena.php:96
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

[将 xdebug.file_link_format 指令添加到您的 php.ini 文件以获取文件链接。]

查询时间：0.83 ms 上次查询后：66.13 ms 查询内存：0.032 MB 查询前内存：19.997 MB 返回的行数：0

SELECT `id` 
  FROM `joom_menu` 
  WHERE `link` LIKE '%option=com_community&view=register%' 
  AND `published`='1' 
  AND `menutype`!='jomsocial' 
  AND `type`='component'

解释

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	joom_menu	NULL	ALL	idx_menutype	不能使用任何索引键	NULL	NULL	257	0.39	Using where

轮廓

Status	Duration
starting	0.05 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.02 ms
sending cached result to clien	0.04 ms
cleaned up	0.01 ms
cleaning up	0.00 ms

调用堆栈

#	呼叫者	文件和行号
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1760
22	JDatabaseDriver->loadResult()	JROOT/components/com_community/libraries/core.php:1391
21	CRoute::_getViewItemid()	JROOT/components/com_community/libraries/core.php:1301
20	CRoute::_()	JROOT/plugins/kunena/community/login.php:53
19	KunenaLoginCommunity->getRegistrationURL()	JROOT/libraries/kunena/login.php:167
18	KunenaLogin->getRegistrationURL()	JROOT/components/com_kunena/controller/widget/login/display.php:69
17	ComponentKunenaControllerWidgetLoginDisplay->before()	JROOT/libraries/kunena/controller/display.php:31
16	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/controller/display.php:127
15	KunenaControllerDisplay->__toString()	JROOT/components/com_kunena/template/nts_kbento/layouts/widget/menubar/default.php:20
14	include JROOT/components/com_kunena/template/nts_kbento/layouts/widget/menubar/default.php	JROOT/libraries/kunena/layout/base.php:183
13	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
12	KunenaLayout->render()	JROOT/libraries/kunena/layout/base.php:91
11	KunenaLayoutBase->__toString()	JROOT/components/com_kunena/template/nts_kbento/layouts/page/default.php:20
10	include JROOT/components/com_kunena/template/nts_kbento/layouts/page/default.php	JROOT/libraries/kunena/layout/base.php:183
9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
8	KunenaLayout->render()	JROOT/libraries/kunena/layout/base.php:91
7	KunenaLayoutBase->__toString()	JROOT/components/com_kunena/kunena.php:131
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

[将 xdebug.file_link_format 指令添加到您的 php.ini 文件以获取文件链接。]

查询时间：0.89 ms 上次查询后：52.37 ms 查询内存：0.025 MB 查询前内存：20.374 MB 返回的行数：1

SELECT special_characters 
  FROM joom_languages 
  WHERE sef = 'zh' 
  LIMIT 1

解释

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	joom_languages	NULL	const	idx_sef	idx_sef	202	const	1	100.00	NULL

轮廓

Status	Duration
starting	0.07 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.03 ms
sending cached result to clien	0.06 ms
cleaned up	0.01 ms
cleaning up	0.00 ms

调用堆栈

#	呼叫者	文件和行号
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1682
18	JDatabaseDriver->loadObject()	JROOT/libraries/axslibs/language.php:280
17	AxsLanguage::getSpecialCharacters()	JROOT/libraries/axslibs/language.php:26
16	AxsLanguage::translate()	JROOT/libraries/axslibs/language.php:408
15	AxsLanguage::getLocalizationVariable()	JROOT/components/com_kunena/template/nts_kbento/layouts/widget/breadcrumb/default.php:26
14	include JROOT/components/com_kunena/template/nts_kbento/layouts/widget/breadcrumb/default.php	JROOT/libraries/kunena/layout/base.php:183
13	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
12	KunenaLayout->render()	JROOT/libraries/kunena/layout/base.php:91
11	KunenaLayoutBase->__toString()	JROOT/components/com_kunena/template/nts_kbento/layouts/page/default.php:30
10	include JROOT/components/com_kunena/template/nts_kbento/layouts/page/default.php	JROOT/libraries/kunena/layout/base.php:183
9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
8	KunenaLayout->render()	JROOT/libraries/kunena/layout/base.php:91
7	KunenaLayoutBase->__toString()	JROOT/components/com_kunena/kunena.php:131
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

[将 xdebug.file_link_format 指令添加到您的 php.ini 文件以获取文件链接。]

查询时间：0.72 ms 上次查询后：0.06 ms 查询内存：0.026 MB 查询前内存：20.386 MB 返回的行数：12

SELECT *

  FROM axs_translations

  WHERE language_tag = 'zh'

解释

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	axs_translations	NULL	ref	language_tag	language_tag	13	const	12	100.00	NULL

轮廓

Status	Duration
starting	0.02 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.03 ms
cleaned up	0.01 ms
cleaning up	0.00 ms

调用堆栈

#	呼叫者	文件和行号
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1526
18	JDatabaseDriver->loadAssocList()	JROOT/libraries/axslibs/language.php:122
17	AxsLanguage::getTranslationMap()	JROOT/libraries/axslibs/language.php:39
16	AxsLanguage::translate()	JROOT/libraries/axslibs/language.php:408
15	AxsLanguage::getLocalizationVariable()	JROOT/components/com_kunena/template/nts_kbento/layouts/widget/breadcrumb/default.php:26
14	include JROOT/components/com_kunena/template/nts_kbento/layouts/widget/breadcrumb/default.php	JROOT/libraries/kunena/layout/base.php:183
13	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
12	KunenaLayout->render()	JROOT/libraries/kunena/layout/base.php:91
11	KunenaLayoutBase->__toString()	JROOT/components/com_kunena/template/nts_kbento/layouts/page/default.php:30
10	include JROOT/components/com_kunena/template/nts_kbento/layouts/page/default.php	JROOT/libraries/kunena/layout/base.php:183
9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
8	KunenaLayout->render()	JROOT/libraries/kunena/layout/base.php:91
7	KunenaLayoutBase->__toString()	JROOT/components/com_kunena/kunena.php:131
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

[将 xdebug.file_link_format 指令添加到您的 php.ini 文件以获取文件链接。]

查询时间：1.86 ms 上次查询后：11.46 ms 查询内存：0.023 MB 查询前内存：20.408 MB 返回的行数：0

SELECT *

  FROM joom_kunena_announcement

  WHERE (published = 1) 
  AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2024-07-13 05:55:13') 
  AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2024-07-13 05:55:13')

  ORDER BY id DESC 
  LIMIT 1

解释

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	joom_kunena_announcement	NULL	index	NULL	PRIMARY	4	NULL	1	100.00	Using where

轮廓

Status	Duration
starting	0.03 ms
checking query cache for query	0.08 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.04 ms
System lock	0.03 ms
optimizing	0.02 ms
statistics	0.02 ms
preparing	0.03 ms
Sorting result	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.05 ms
storing result in query cache	0.01 ms
cleaned up	0.01 ms
cleaning up	0.00 ms

调用堆栈

#	呼叫者	文件和行号
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1526
15	JDatabaseDriver->loadAssocList()	JROOT/libraries/kunena/forum/announcement/helper.php:131
14	KunenaForumAnnouncementHelper::getAnnouncements()	JROOT/components/com_kunena/controller/widget/announcement/display.php:40
13	ComponentKunenaControllerWidgetAnnouncementDisplay->before()	JROOT/libraries/kunena/controller/display.php:31
12	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/controller/display.php:127
11	KunenaControllerDisplay->__toString()	JROOT/components/com_kunena/template/nts_kbento/layouts/page/default.php:35
10	include JROOT/components/com_kunena/template/nts_kbento/layouts/page/default.php	JROOT/libraries/kunena/layout/base.php:183
9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
8	KunenaLayout->render()	JROOT/libraries/kunena/layout/base.php:91
7	KunenaLayoutBase->__toString()	JROOT/components/com_kunena/kunena.php:131
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

[将 xdebug.file_link_format 指令添加到您的 php.ini 文件以获取文件链接。]

查询时间：0.81 ms 上次查询后：34.82 ms 查询内存：0.021 MB 查询前内存：20.459 MB 返回的行数：1

SELECT language,id

  FROM `joom_menu`

  WHERE home = 1 
  AND published = 1 
  AND client_id = 0

解释

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	joom_menu	NULL	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	104	1.00	Using where

轮廓

Status	Duration
starting	0.03 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.02 ms
sending cached result to clien	0.04 ms
cleaned up	0.01 ms
cleaning up	0.03 ms

调用堆栈

#	呼叫者	文件和行号
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1721
9	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/language/multilang.php:106
8	JLanguageMultilang::getSiteHomePages()	JROOT/plugins/system/languagefilter/languagefilter.php:729
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/joomla/application/base.php:106
4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/site.php:196
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

[将 xdebug.file_link_format 指令添加到您的 php.ini 文件以获取文件链接。]

查询时间：0.82 ms 上次查询后：12.88 ms 查询内存：0.021 MB 查询前内存：20.512 MB 返回的行数：0

SELECT `c2`.`language`,`c2`.`id`

  FROM `joom_menu` AS `c`

  INNER JOIN `joom_associations` AS `a` 
  ON a.id = c.`id` 
  AND a.context='com_menus.item'

  INNER JOIN `joom_associations` AS `a2` 
  ON a.key = a2.key

  INNER JOIN `joom_menu` AS `c2` 
  ON a2.id = c2.`id`

  WHERE c.id = 871

解释

id	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.03 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.05 ms
cleaned up	0.01 ms
cleaning up	0.01 ms

调用堆栈

#	呼叫者	文件和行号
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1721
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/language/associations.php:101
9	JLanguageAssociations::getAssociations()	JROOT/administrator/components/com_menus/helpers/menus.php:313
8	MenusHelper::getAssociations()	JROOT/plugins/system/languagefilter/languagefilter.php:746
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/joomla/application/base.php:106
4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/site.php:196
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

[将 xdebug.file_link_format 指令添加到您的 php.ini 文件以获取文件链接。]

查询时间：0.81 ms 上次查询后：35.78 ms 查询内存：0.022 MB 查询前内存：20.846 MB 返回的行数：1

SELECT *

  FROM `currency`

  WHERE `base_currency`=1 
  LIMIT 1

解释

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	currency	NULL	ALL	NULL	不能使用任何索引键	NULL	NULL	136	10.00	Using where

轮廓

Status	Duration
starting	0.03 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.02 ms
sending cached result to clien	0.05 ms
cleaned up	0.02 ms
cleaning up	0.01 ms

调用堆栈

#	呼叫者	文件和行号
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1682
11	JDatabaseDriver->loadObject()	JROOT/libraries/axslibs/currency.php:84
10	AxsCurrency->getBaseCurrency()	JROOT/libraries/axslibs/currency.php:22
9	AxsCurrency->__construct()	JROOT/templates/axs/home.php:20
8	include JROOT/templates/axs/home.php	JROOT/templates/axs/index.php:58
7	require JROOT/templates/axs/index.php	JROOT/libraries/joomla/document/html.php:653
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1173
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:782
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:72

[将 xdebug.file_link_format 指令添加到您的 php.ini 文件以获取文件链接。]

查询时间：0.75 ms 上次查询后：5.26 ms 查询内存：0.023 MB 查询前内存：20.852 MB 返回的行数：10

SELECT * 
  FROM axs_fonts 
  WHERE enabled = 1

解释

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	axs_fonts	NULL	ALL	NULL	不能使用任何索引键	NULL	NULL	10	10.00	Using where

轮廓

Status	Duration
starting	0.03 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.03 ms
sending cached result to clien	0.06 ms
cleaned up	0.01 ms
cleaning up	0.00 ms

调用堆栈

#	呼叫者	文件和行号
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1721
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/axslibs/fonts.php:34
9	AxsFonts::getFonts()	JROOT/templates/axs/home.php:93
8	include JROOT/templates/axs/home.php	JROOT/templates/axs/index.php:58
7	require JROOT/templates/axs/index.php	JROOT/libraries/joomla/document/html.php:653
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1173
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:782
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:72

[将 xdebug.file_link_format 指令添加到您的 php.ini 文件以获取文件链接。]

查询时间：0.74 ms 上次查询后：6.03 ms 查询内存：0.022 MB 查询前内存：20.888 MB 返回的行数：0

SELECT *

  FROM accessibility_images

  WHERE `path`='images/pDJC5BxLjAW4jMgmh4ZjVUqCNDU3NDQ2OTkwOTMw/graphics/blue-logo.png' 
  AND enabled= 1

解释

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	accessibility_images	NULL	ALL	NULL	不能使用任何索引键	NULL	NULL	1	100.00	Using where

轮廓

Status	Duration
starting	0.03 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.02 ms
sending cached result to clien	0.04 ms
cleaned up	0.03 ms
cleaning up	0.01 ms

调用堆栈

#	呼叫者	文件和行号
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1682
11	JDatabaseDriver->loadObject()	JROOT/libraries/axslibs/accessibility.php:42
10	AxsAccessibility::query()	JROOT/libraries/axslibs/accessibility.php:49
9	AxsAccessibility::image()	JROOT/templates/axs/home.php:806
8	include JROOT/templates/axs/home.php	JROOT/templates/axs/index.php:58
7	require JROOT/templates/axs/index.php	JROOT/libraries/joomla/document/html.php:653
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1173
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:782
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:72

[将 xdebug.file_link_format 指令添加到您的 php.ini 文件以获取文件链接。]

查询时间：1.06 ms 上次查询后：7.12 ms 查询内存：0.022 MB 查询前内存：20.940 MB 返回的行数：0

SELECT * 
  FROM axs_notifications  
  WHERE enabled = 1  
  AND   DATE(start_date) <= NOW()  
  AND   ( DATE(end_date) > NOW() OR end_date = 0 )  
  AND (  ( access_type = 'access' 
  AND (  ( FIND_IN_SET( 1, accesslevel ) > 0 )  OR  ( FIND_IN_SET( 1, accesslevel ) > 0 )  ) )  OR   ( access_type = 'user'   
  AND (  ( FIND_IN_SET( 1, usergroup ) > 0 )  ) )  OR   ( access_type = 'list'   
  AND ( FIND_IN_SET( 0, userlist ) > 0 ) )  OR   ( access_type = 'none' ) )

解释

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	axs_notifications	NULL	ALL	NULL	不能使用任何索引键	NULL	NULL	1	100.00	Using where

轮廓

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

调用堆栈

#	呼叫者	文件和行号
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1721
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/axslibs/notifications.php:17
9	AxsNotifications::loadNotifications()	JROOT/templates/axs/home.php:1795
8	include JROOT/templates/axs/home.php	JROOT/templates/axs/index.php:58
7	require JROOT/templates/axs/index.php	JROOT/libraries/joomla/document/html.php:653
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1173
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:782
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:72

[将 xdebug.file_link_format 指令添加到您的 php.ini 文件以获取文件链接。]

查询时间：0.79 ms 上次查询后：41.09 ms 查询内存：0.023 MB 查询前内存：20.851 MB 返回的行数：1

SELECT sef 
  FROM joom_languages 
  WHERE lang_code = 'zh-CN' 
  LIMIT 1

解释

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	joom_languages	NULL	const	idx_langcode	idx_langcode	28	const	1	100.00	NULL

轮廓

Status	Duration
starting	0.03 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.02 ms
sending cached result to clien	0.03 ms
cleaned up	0.01 ms
cleaning up	0.00 ms

调用堆栈

#	呼叫者	文件和行号
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1682
13	JDatabaseDriver->loadObject()	JROOT/libraries/axslibs/language.php:257
12	AxsLanguage::getSefByLangCode()	JROOT/modules/mod_mediamodal/tmpl/default.php:8
11	require JROOT/modules/mod_mediamodal/tmpl/default.php	JROOT/modules/mod_mediamodal/mod_mediamodal.php:9
10	include JROOT/modules/mod_mediamodal/mod_mediamodal.php	JROOT/libraries/cms/module/helper.php:198
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:486
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1190
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:782
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:72

[将 xdebug.file_link_format 指令添加到您的 php.ini 文件以获取文件链接。]

查询时间：0.77 ms 上次查询后：62.55 ms 查询内存：0.026 MB 查询前内存：21.151 MB 返回的行数：0

SELECT *

  FROM joom_easyblog_configs

  WHERE `name` = 'config'

解释

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	joom_easyblog_configs	NULL	ALL	NULL	不能使用任何索引键	NULL	NULL	1	100.00	Using where

轮廓

Status	Duration
starting	0.04 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.02 ms
sending cached result to clien	0.04 ms
cleaned up	0.01 ms
cleaning up	0.01 ms

调用堆栈

#	呼叫者	文件和行号
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1485
21	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:729
20	JTable->load()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:415
19	EB::config()	JROOT/components/com_easyblog/router.php:19
18	EasyBlogBuildRoute()	JROOT/libraries/cms/component/router/legacy.php:68
17	JComponentRouterLegacy->build()	JROOT/libraries/cms/router/site.php:519
16	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:489
15	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:282
14	JRouter->build()	JROOT/libraries/cms/router/site.php:149
13	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
12	JRoute::_()	JROOT/modules/mod_defaultmenu/helper.php:134
11	ModDefaultHelper::getList()	JROOT/modules/mod_defaultmenu/mod_defaultmenu.php:15
10	include JROOT/modules/mod_defaultmenu/mod_defaultmenu.php	JROOT/libraries/cms/module/helper.php:198
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:486
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1190
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:782
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:72

[将 xdebug.file_link_format 指令添加到您的 php.ini 文件以获取文件链接。]

记录了 63 个查询类型，按出现次数排序。

选择表：

5 × SELECT * 
  FROM `joom_kunena_topics`

```
5 × SELECT `id` 
  FROM `joom_menu`
```

2 × SELECT `value` 
  FROM `joom_community_fields_values`

2 × SELECT DISTINCT(user_id) 
  FROM joom_usergroups as ug1 
  INNER JOIN joom_usergroups AS ug2 
  ON ug2.lft>=ug1.lft 
  AND ug1.rgt>=ug2.rgt 
  INNER JOIN joom_user_usergroup_map AS m 
  ON ug2.id=m.group_id

2 × SELECT   a.`userid` as _userid , a.`status` as _status ,  a.`points` as _points,  a.`posted_on` as _posted_on,  a.`avatar` as _avatar ,  a.`thumb` as _thumb ,  a.`invite` as _invite,  a.`params` as _cparams,   a.`view` as _view,  a.`friends` as _friends,  a.`groups` as _groups,  a.`events` as _events,  a.`alias` as _alias,  a.`profile_id` as _profile_id,  a.`friendcount` as _friendcount,  a.`storage` as _storage,  a.`watermark_hash` as _watermark_hash,  a.`search_email` AS _search_email,  s.`userid` as _isonline, u.*  
  FROM `joom_community_users` as a  
  LEFT JOIN `joom_users` u  
  ON u.`id`=a.`userid` 
  LEFT 
  OUTER JOIN `joom_session`s  
  ON s.`userid`=a.`userid`

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

```
2 × SELECT * 
  FROM joom_languages
```
```
1 × SELECT * 
  FROM axs_fonts
```

1 × SELECT     SUM(time>=1720828800 
  AND parent=0) AS todayTopicCount,     SUM(time>=1720828800 
  AND parent>0) AS todayReplyCount,     SUM(time>=1720742400 
  AND time<1720828800 
  AND parent=0) AS yesterdayTopicCount,     SUM(time>=1720742400 
  AND time<1720828800 
  AND parent>0) AS yesterdayReplyCount     
  FROM joom_kunena_messages

1 × SELECT userid, MAX(time) AS time 
  FROM joom_session

1 × SELECT COUNT(*) 
  FROM joom_session

1 × SELECT * 
  FROM joom_community_config

```
1 × SELECT sef 
  FROM joom_languages
```
```
1 × SELECT * 
  FROM joom_extensions
```

1 × SELECT * 
  FROM axs_notifications

1 × SELECT * 
  FROM accessibility_images

1 × SELECT COUNT(*), MAX(id) 
  FROM joom_users

1 × SELECT u.name, u.username, u.email, u.block as blocked, u.registerDate, u.lastvisitDate, ku.*    
  FROM joom_users AS u    
  LEFT JOIN joom_kunena_users AS ku 
  ON u.id = ku.userid

```
1 × SELECT * 
  FROM `currency`
```

1 × SELECT `id` 
  FROM `joom_community_fields`

1 × SELECT code, location 
  FROM joom_kunena_smiley

1 × SELECT   a.`userid` as _userid ,  a.`status` as _status ,  a.`points` as _points,  a.`posted_on` as _posted_on,  a.`avatar` as _avatar ,  a.`cover` as _cover ,  a.`thumb` as _thumb ,  a.`invite` as _invite,  a.`params` as _cparams,   a.`view` as _view,  a.`friends` as _friends,  a.`groups` as _groups,  a.`events` as _events,  a.`friendcount` as _friendcount,  a.`alias` as _alias,  a.`profile_id` as _profile_id,  a.`storage` as _storage,  a.`watermark_hash` as _watermark_hash,  a.`search_email` as _search_email,  s.`userid` as _isonline, u.*  
  FROM `joom_community_users` as a  
  LEFT JOIN `joom_users` u  
  ON u.`id`=a.`userid` 
  LEFT 
  OUTER JOIN `joom_session` s  
  ON s.`userid`=a.`userid` 
  AND s.`client_id` !='1'

1 × SELECT special_characters 
  FROM joom_languages

```
1 × SELECT * 
  FROM axs_translations
```

1 × SELECT * 
  FROM joom_kunena_announcement

1 × SELECT language,id 
  FROM `joom_menu`

1 × SELECT `c2`.`language`,`c2`.`id` 
  FROM `joom_menu` AS `c` 
  INNER JOIN `joom_associations` AS `a` 
  ON a.id = c.`id` 
  AND a.context='com_menus.item' 
  INNER JOIN `joom_associations` AS `a2` 
  ON a.key = a2.key 
  INNER JOIN `joom_menu` AS `c2` 
  ON a2.id = c2.`id`

```
1 × SELECT `id` 
  FROM `joom_users`
```

1 × SELECT `session_id` 
  FROM `joom_session`

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

```
1 × SELECT * 
  FROM axs_integrations
```

1 × SELECT id, rules 
  FROM `joom_viewlevels

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

1 × SELECT `folder` AS `type`,`element` AS `name`,`params` 
  FROM joom_extensions

```
1 × SELECT * 
  FROM axs_domains
```

1 × SELECT `element`,`name`,`client_id`,`extension_id` 
  FROM `joom_extensions`

```
1 × SELECT * 
  FROM `axs_brands`
```

1 × SELECT * 
  FROM `axs_homepage_templates`

1 × SELECT * 
  FROM `axs_dashboard_templates`

1 × SELECT * 
  FROM axs_email_settings

1 × SELECT * 
  FROM axs_payment_gateways

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

1 × SELECT * 
  FROM joom_kunena_topics

1 × SELECT `id`,`title` 
  FROM `joom_usergroups`

1 × SELECT params 
  FROM axs_user_settings

```
1 × SELECT * 
  FROM `joom_users`
```

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

1 × SELECT * 
  FROM joom_kunena_configuration

1 × SELECT g.memberid AS user_id, c.id AS category_id, 2 AS role    
  FROM joom_kunena_categories AS c    
  INNER JOIN joom_community_groups_members AS g 
  ON c.accesstype='jomsocial' 
  AND c.access=g.groupid

1 × SELECT `id`,`name`,`rules`,`parent_id` 
  FROM `joom_assets`

1 × SELECT user_id, category_id, role 
  FROM joom_kunena_user_categories

1 × SELECT * 
  FROM joom_kunena_categories

1 × SELECT groupid 
  FROM joom_community_groups_members

1 × SELECT * 
  FROM joom_easyblog_configs

其他表：

1 × INSERT INTO `joom_session` (`session_id`,`guest`,`time`,`userid`,`username`) 
  VALUES  ('alhru7ig8kc7ojfp3vbvhnkooq', 1, '1720850112', 0, ''

1 × UPDATE `joom_extensions` 
  SET `params` = '{\"mediaversion\":\"58e0acaf9ac9cfca3c8fb8e26b67d0e8\"}'

1 × SHOW FULL COLUMNS 
  FROM `joom_users

1 × SHOW FULL COLUMNS 
  FROM `joom_kunena_sessions

1 × SHOW FULL COLUMNS 
  FROM `joom_kunena_users

1 × SHOW FULL COLUMNS 
  FROM `joom_kunena_categories

1 × SHOW FULL COLUMNS 
  FROM `joom_kunena_topics

1 × SHOW FULL COLUMNS 
  FROM `joom_community_config

1 × SHOW FULL COLUMNS 
  FROM `joom_community_profiles

注意

Main Forum

统计数据

Joomla！调试控制台

会议

档案信息

时间

记忆

内存使用情况

数据库查询

记录了 76 个查询 168.79 ms

找到 6 个重复项！

记录了 63 个查询类型，按出现次数排序。

选择表：

其他表：