查询时间:1.29 ms 查询内存:0.020 MB 查询前内存:4.105 MB 返回的行数:0
SELECT `session_id`
FROM `joom_session `
WHERE `session_id` = 'nkhojsr90mtvfpc5p76f37mhec' LIMIT 1id 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
没有 SHOW PROFILE(可能是因为有超过 100 个查询)
# 呼叫者 文件和行号 8 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:17607 JDatabaseDriver->loadResult() Copy JROOT/libraries/cms/application/cms.php:1766 JApplicationCms->checkSession() Copy JROOT/libraries/cms/application/cms.php:8885 JApplicationCms->loadSession() Copy JROOT/libraries/cms/application/cms.php:1314 JApplicationCms->__construct() Copy JROOT/libraries/cms/application/site.php:633 JApplicationSite->__construct() Copy JROOT/libraries/cms/application/cms.php:4692 JApplicationCms::getInstance() Copy JROOT/libraries/joomla/factory.php:1251 JFactory::getApplication() Copy JROOT/index.php:50
查询时间:4.02 ms 上次查询后:0.04 ms 查询内存:0.003 MB 查询前内存:4.173 MB
INSERT INTO `joom_session `
(`session_id`,`guest`,`time`,`userid`,`username`) VALUES
('nkhojsr90mtvfpc5p76f37mhec', 1, '1723106269', 0, '')查询时无法解释:INSERT INTO `joom_session`
(`session_id`,`guest`,`time`,`userid`,`username`) VALUES
('nkhojsr90mtvfpc5p76f37mhec', 1, '1723106269', 0, '')
没有 SHOW PROFILE(可能是因为有超过 100 个查询)
# 呼叫者 文件和行号 7 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/cms/application/cms.php:2166 JApplicationCms->checkSession() Copy JROOT/libraries/cms/application/cms.php:8885 JApplicationCms->loadSession() Copy JROOT/libraries/cms/application/cms.php:1314 JApplicationCms->__construct() Copy JROOT/libraries/cms/application/site.php:633 JApplicationSite->__construct() Copy JROOT/libraries/cms/application/cms.php:4692 JApplicationCms::getInstance() Copy JROOT/libraries/joomla/factory.php:1251 JFactory::getApplication() Copy JROOT/index.php:50
查询时间:1.63 ms 上次查询后:1.22 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
没有 SHOW PROFILE(可能是因为有超过 100 个查询)
# 呼叫者 文件和行号 10 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:17219 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/cms/component/helper.php:4478 JComponentHelper::{closure}() Copy JROOT/libraries/joomla/cache/controller/callback.php:1697 JCacheControllerCallback->get() Copy JROOT/libraries/cms/component/helper.php:4556 JComponentHelper::load() Copy JROOT/libraries/cms/component/helper.php:435 JComponentHelper::getComponent() Copy JROOT/libraries/cms/component/helper.php:1114 JComponentHelper::getParams() Copy JROOT/libraries/cms/application/site.php:5983 JApplicationSite->initialiseApp() Copy JROOT/libraries/cms/application/site.php:2092 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
查询时间:1.01 ms 上次查询后:1.22 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
没有 SHOW PROFILE(可能是因为有超过 100 个查询)
# 呼叫者 文件和行号 10 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:15269 JDatabaseDriver->loadAssocList() Copy JROOT/libraries/joomla/access/access.php:10628 JAccess::getAuthorisedViewLevels() Copy JROOT/libraries/joomla/user/user.php:4537 JUser->getAuthorisedViewLevels() Copy JROOT/libraries/cms/plugin/helper.php:2936 JPluginHelper::load() Copy JROOT/libraries/cms/plugin/helper.php:865 JPluginHelper::getPlugin() Copy JROOT/libraries/cms/plugin/helper.php:1284 JPluginHelper::isEnabled() Copy JROOT/libraries/cms/application/site.php:6083 JApplicationSite->initialiseApp() Copy JROOT/libraries/cms/application/site.php:2092 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
查询时间:1.02 ms 上次查询后:0.04 ms 查询内存:0.021 MB 查询前内存:4.567 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 = 1id 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
没有 SHOW PROFILE(可能是因为有超过 100 个查询)
# 呼叫者 文件和行号 11 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:157010 JDatabaseDriver->loadColumn() Copy JROOT/libraries/joomla/access/access.php:9799 JAccess::getGroupsByUser() Copy JROOT/libraries/joomla/access/access.php:10948 JAccess::getAuthorisedViewLevels() Copy JROOT/libraries/joomla/user/user.php:4537 JUser->getAuthorisedViewLevels() Copy JROOT/libraries/cms/plugin/helper.php:2936 JPluginHelper::load() Copy JROOT/libraries/cms/plugin/helper.php:865 JPluginHelper::getPlugin() Copy JROOT/libraries/cms/plugin/helper.php:1284 JPluginHelper::isEnabled() Copy JROOT/libraries/cms/application/site.php:6083 JApplicationSite->initialiseApp() Copy JROOT/libraries/cms/application/site.php:2092 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
查询时间:2.65 ms 上次查询后:0.35 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 orderingid 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; 使用文件排序
没有 SHOW PROFILE(可能是因为有超过 100 个查询)
# 呼叫者 文件和行号 10 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:17219 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/cms/plugin/helper.php:3118 JPluginHelper::{closure}() Copy JROOT/libraries/joomla/cache/controller/callback.php:1697 JCacheControllerCallback->get() Copy JROOT/libraries/cms/plugin/helper.php:3166 JPluginHelper::load() Copy JROOT/libraries/cms/plugin/helper.php:865 JPluginHelper::getPlugin() Copy JROOT/libraries/cms/plugin/helper.php:1284 JPluginHelper::isEnabled() Copy JROOT/libraries/cms/application/site.php:6083 JApplicationSite->initialiseApp() Copy JROOT/libraries/cms/application/site.php:2092 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
查询时间:1.44 ms 上次查询后:8.89 ms 查询内存:0.024 MB 查询前内存:5.537 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
没有 SHOW PROFILE(可能是因为有超过 100 个查询)
# 呼叫者 文件和行号 17 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:168216 JDatabaseDriver->loadObject() Copy JROOT/libraries/cms/library/helper.php:16615 JLibraryHelper::{closure}() Copy JROOT/libraries/joomla/cache/controller/callback.php:16914 JCacheControllerCallback->get() Copy JROOT/libraries/cms/library/helper.php:17413 JLibraryHelper::loadLibrary() Copy JROOT/libraries/cms/library/helper.php:4212 JLibraryHelper::getLibrary() Copy JROOT/libraries/cms/library/helper.php:8911 JLibraryHelper::getParams() Copy JROOT/libraries/cms/version/version.php:27010 JVersion->getMediaVersion() Copy JROOT/libraries/joomla/factory.php:7759 JFactory::createDocument() Copy JROOT/libraries/joomla/factory.php:2168 JFactory::getDocument() Copy JROOT/plugins/system/mootable/mootable.php:1007 PlgSystemMootable->__construct() Copy JROOT/libraries/cms/plugin/helper.php:2556 JPluginHelper::import() Copy JROOT/libraries/cms/plugin/helper.php:1705 JPluginHelper::importPlugin() Copy JROOT/libraries/cms/application/cms.php:7394 JApplicationCms->initialiseApp() Copy JROOT/libraries/cms/application/site.php:6903 JApplicationSite->initialiseApp() Copy JROOT/libraries/cms/application/site.php:2092 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
查询时间:6.58 ms 上次查询后:0.07 ms 查询内存:0.006 MB 查询前内存:5.529 MB
UPDATE `joom_extensions `
SET `params` = '{\"mediaversion\":\"8cf48a03c4a9bac52895d8f6df7e2d68\"}'
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
没有 SHOW PROFILE(可能是因为有超过 100 个查询)
# 呼叫者 文件和行号 13 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/cms/library/helper.php:11612 JLibraryHelper::saveParams() Copy JROOT/libraries/cms/version/version.php:32111 JVersion->setMediaVersion() Copy JROOT/libraries/cms/version/version.php:28010 JVersion->getMediaVersion() Copy JROOT/libraries/joomla/factory.php:7759 JFactory::createDocument() Copy JROOT/libraries/joomla/factory.php:2168 JFactory::getDocument() Copy JROOT/plugins/system/mootable/mootable.php:1007 PlgSystemMootable->__construct() Copy JROOT/libraries/cms/plugin/helper.php:2556 JPluginHelper::import() Copy JROOT/libraries/cms/plugin/helper.php:1705 JPluginHelper::importPlugin() Copy JROOT/libraries/cms/application/cms.php:7394 JApplicationCms->initialiseApp() Copy JROOT/libraries/cms/application/site.php:6903 JApplicationSite->initialiseApp() Copy JROOT/libraries/cms/application/site.php:2092 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
查询时间:1.13 ms 上次查询后:14.00 ms 查询内存:0.029 MB 查询前内存:8.022 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; 使用文件排序
没有 SHOW PROFILE(可能是因为有超过 100 个查询)
# 呼叫者 文件和行号 10 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:17219 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/joomla/language/helper.php:1488 JLanguageHelper::getLanguages() Copy JROOT/plugins/system/languagefilter/languagefilter.php:997 PlgSystemLanguageFilter->__construct() Copy JROOT/libraries/cms/plugin/helper.php:2556 JPluginHelper::import() Copy JROOT/libraries/cms/plugin/helper.php:1705 JPluginHelper::importPlugin() Copy JROOT/libraries/cms/application/cms.php:7394 JApplicationCms->initialiseApp() Copy JROOT/libraries/cms/application/site.php:6903 JApplicationSite->initialiseApp() Copy JROOT/libraries/cms/application/site.php:2092 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
查询时间:1.03 ms 上次查询后:0.55 ms 查询内存:0.021 MB 查询前内存:8.094 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
没有 SHOW PROFILE(可能是因为有超过 100 个查询)
# 呼叫者 文件和行号 10 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:16829 JDatabaseDriver->loadObject() Copy JROOT/libraries/axslibs/language.php:1838 AxsLanguage::getSubdomainDefault() Copy JROOT/plugins/system/languagefilter/languagefilter.php:1037 PlgSystemLanguageFilter->__construct() Copy JROOT/libraries/cms/plugin/helper.php:2556 JPluginHelper::import() Copy JROOT/libraries/cms/plugin/helper.php:1705 JPluginHelper::importPlugin() Copy JROOT/libraries/cms/application/cms.php:7394 JApplicationCms->initialiseApp() Copy JROOT/libraries/cms/application/site.php:6903 JApplicationSite->initialiseApp() Copy JROOT/libraries/cms/application/site.php:2092 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
查询时间:1.89 ms 上次查询后:0.06 ms 查询内存:0.030 MB 查询前内存:8.101 MB 返回的行数:94
SELECT `element`,`name`,`client_id`,`extension_id`
FROM `joom_extensions `
WHERE `type` = 'language' AND `state` = 0 AND `enabled` = 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE joom_extensions NULL ref extension extension 82 const 98 1.00 Using where
没有 SHOW PROFILE(可能是因为有超过 100 个查询)
# 呼叫者 文件和行号 10 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:17219 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/joomla/language/helper.php:2078 JLanguageHelper::getInstalledLanguages() Copy JROOT/plugins/system/languagefilter/languagefilter.php:1137 PlgSystemLanguageFilter->__construct() Copy JROOT/libraries/cms/plugin/helper.php:2556 JPluginHelper::import() Copy JROOT/libraries/cms/plugin/helper.php:1705 JPluginHelper::importPlugin() Copy JROOT/libraries/cms/application/cms.php:7394 JApplicationCms->initialiseApp() Copy JROOT/libraries/cms/application/site.php:6903 JApplicationSite->initialiseApp() Copy JROOT/libraries/cms/application/site.php:2092 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
查询时间:1.02 ms 上次查询后:1.17 ms 查询内存:0.022 MB 查询前内存:8.233 MB 返回的行数:1
SELECT * FROM `axs_brands` WHERE language = 'en-GB ' AND (FIND_IN_SET ('k8s.intg.tovuti.io', domains) > 0) LIMIT 1id 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
没有 SHOW PROFILE(可能是因为有超过 100 个查询)
# 呼叫者 文件和行号 13 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172112 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/axslibs/brands.php:29011 AxsBrands::getData() Copy JROOT/libraries/axslibs/brands.php:35510 AxsBrands::getBrandObject() Copy JROOT/libraries/axslibs/brands.php:559 AxsBrands::getBrand() Copy JROOT/plugins/system/axslibs/axslibs.php:358 plgSystemAxslibs->onAfterInitialise() Copy JROOT/libraries/joomla/event/event.php:707 JEvent->update() Copy JROOT/libraries/joomla/event/dispatcher.php:1606 JEventDispatcher->trigger() Copy JROOT/libraries/joomla/application/base.php:1065 JApplicationBase->triggerEvent() Copy JROOT/libraries/cms/application/cms.php:7404 JApplicationCms->initialiseApp() Copy JROOT/libraries/cms/application/site.php:6903 JApplicationSite->initialiseApp() Copy JROOT/libraries/cms/application/site.php:2092 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
查询时间:0.94 ms 上次查询后:0.05 ms 查询内存:0.030 MB 查询前内存:8.255 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; 使用文件排序
没有 SHOW PROFILE(可能是因为有超过 100 个查询)
# 呼叫者 文件和行号 14 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172113 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/axslibs/language.php:34212 AxsLanguage::getPublishedLanguages() Copy JROOT/libraries/axslibs/language.php:25111 AxsLanguage::getCurrentLanguage() Copy JROOT/libraries/axslibs/brands.php:37110 AxsBrands::getBrandObject() Copy JROOT/libraries/axslibs/brands.php:559 AxsBrands::getBrand() Copy JROOT/plugins/system/axslibs/axslibs.php:358 plgSystemAxslibs->onAfterInitialise() Copy JROOT/libraries/joomla/event/event.php:707 JEvent->update() Copy JROOT/libraries/joomla/event/dispatcher.php:1606 JEventDispatcher->trigger() Copy JROOT/libraries/joomla/application/base.php:1065 JApplicationBase->triggerEvent() Copy JROOT/libraries/cms/application/cms.php:7404 JApplicationCms->initialiseApp() Copy JROOT/libraries/cms/application/site.php:6903 JApplicationSite->initialiseApp() Copy JROOT/libraries/cms/application/site.php:2092 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
查询时间:1.02 ms 上次查询后:1.16 ms 查询内存:0.021 MB 查询前内存:8.524 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
没有 SHOW PROFILE(可能是因为有超过 100 个查询)
# 呼叫者 文件和行号 12 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172111 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/axslibs/brands.php:38810 AxsBrands::getBrandObject() Copy JROOT/libraries/axslibs/brands.php:559 AxsBrands::getBrand() Copy JROOT/plugins/system/axslibs/axslibs.php:358 plgSystemAxslibs->onAfterInitialise() Copy JROOT/libraries/joomla/event/event.php:707 JEvent->update() Copy JROOT/libraries/joomla/event/dispatcher.php:1606 JEventDispatcher->trigger() Copy JROOT/libraries/joomla/application/base.php:1065 JApplicationBase->triggerEvent() Copy JROOT/libraries/cms/application/cms.php:7404 JApplicationCms->initialiseApp() Copy JROOT/libraries/cms/application/site.php:6903 JApplicationSite->initialiseApp() Copy JROOT/libraries/cms/application/site.php:2092 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
查询时间:0.98 ms 上次查询后:0.07 ms 查询内存:0.021 MB 查询前内存:8.565 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
没有 SHOW PROFILE(可能是因为有超过 100 个查询)
# 呼叫者 文件和行号 12 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172111 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/axslibs/brands.php:40610 AxsBrands::getBrandObject() Copy JROOT/libraries/axslibs/brands.php:559 AxsBrands::getBrand() Copy JROOT/plugins/system/axslibs/axslibs.php:358 plgSystemAxslibs->onAfterInitialise() Copy JROOT/libraries/joomla/event/event.php:707 JEvent->update() Copy JROOT/libraries/joomla/event/dispatcher.php:1606 JEventDispatcher->trigger() Copy JROOT/libraries/joomla/application/base.php:1065 JApplicationBase->triggerEvent() Copy JROOT/libraries/cms/application/cms.php:7404 JApplicationCms->initialiseApp() Copy JROOT/libraries/cms/application/site.php:6903 JApplicationSite->initialiseApp() Copy JROOT/libraries/cms/application/site.php:2092 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
查询时间:0.98 ms 上次查询后:0.05 ms 查询内存:0.022 MB 查询前内存:8.585 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
没有 SHOW PROFILE(可能是因为有超过 100 个查询)
# 呼叫者 文件和行号 13 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:168212 JDatabaseDriver->loadObject() Copy JROOT/libraries/axslibs/brands.php:63211 AxsBrands::getEmailSettingsById() Copy JROOT/libraries/axslibs/brands.php:40910 AxsBrands::getBrandObject() Copy JROOT/libraries/axslibs/brands.php:559 AxsBrands::getBrand() Copy JROOT/plugins/system/axslibs/axslibs.php:358 plgSystemAxslibs->onAfterInitialise() Copy JROOT/libraries/joomla/event/event.php:707 JEvent->update() Copy JROOT/libraries/joomla/event/dispatcher.php:1606 JEventDispatcher->trigger() Copy JROOT/libraries/joomla/application/base.php:1065 JApplicationBase->triggerEvent() Copy JROOT/libraries/cms/application/cms.php:7404 JApplicationCms->initialiseApp() Copy JROOT/libraries/cms/application/site.php:6903 JApplicationSite->initialiseApp() Copy JROOT/libraries/cms/application/site.php:2092 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
查询时间:0.93 ms 上次查询后:0.05 ms 查询内存:0.022 MB 查询前内存:8.594 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
没有 SHOW PROFILE(可能是因为有超过 100 个查询)
# 呼叫者 文件和行号 13 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:168212 JDatabaseDriver->loadObject() Copy JROOT/libraries/axslibs/brands.php:58211 AxsBrands::getPaymentGatewayById() Copy JROOT/libraries/axslibs/brands.php:41210 AxsBrands::getBrandObject() Copy JROOT/libraries/axslibs/brands.php:559 AxsBrands::getBrand() Copy JROOT/plugins/system/axslibs/axslibs.php:358 plgSystemAxslibs->onAfterInitialise() Copy JROOT/libraries/joomla/event/event.php:707 JEvent->update() Copy JROOT/libraries/joomla/event/dispatcher.php:1606 JEventDispatcher->trigger() Copy JROOT/libraries/joomla/application/base.php:1065 JApplicationBase->triggerEvent() Copy JROOT/libraries/cms/application/cms.php:7404 JApplicationCms->initialiseApp() Copy JROOT/libraries/cms/application/site.php:6903 JApplicationSite->initialiseApp() Copy JROOT/libraries/cms/application/site.php:2092 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
查询时间:0.93 ms 上次查询后:0.05 ms 查询内存:0.022 MB 查询前内存:8.607 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
没有 SHOW PROFILE(可能是因为有超过 100 个查询)
# 呼叫者 文件和行号 13 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:168212 JDatabaseDriver->loadObject() Copy JROOT/libraries/axslibs/brands.php:65911 AxsBrands::getIntegrationById() Copy JROOT/libraries/axslibs/brands.php:41810 AxsBrands::getBrandObject() Copy JROOT/libraries/axslibs/brands.php:559 AxsBrands::getBrand() Copy JROOT/plugins/system/axslibs/axslibs.php:358 plgSystemAxslibs->onAfterInitialise() Copy JROOT/libraries/joomla/event/event.php:707 JEvent->update() Copy JROOT/libraries/joomla/event/dispatcher.php:1606 JEventDispatcher->trigger() Copy JROOT/libraries/joomla/application/base.php:1065 JApplicationBase->triggerEvent() Copy JROOT/libraries/cms/application/cms.php:7404 JApplicationCms->initialiseApp() Copy JROOT/libraries/cms/application/site.php:6903 JApplicationSite->initialiseApp() Copy JROOT/libraries/cms/application/site.php:2092 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
查询时间:2.23 ms 上次查询后:11.53 ms 查询内存:0.101 MB 查询前内存:10.171 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.lftid 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
没有 SHOW PROFILE(可能是因为有超过 100 个查询)
# 呼叫者 文件和行号 22 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172121 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/cms/menu/site.php:8820 JMenuSite->{closure}() Copy JROOT/libraries/joomla/cache/controller/callback.php:16919 JCacheControllerCallback->get() Copy JROOT/libraries/cms/menu/site.php:9618 JMenuSite->load() Copy JROOT/libraries/cms/menu/menu.php:7417 JMenu->__construct() Copy JROOT/libraries/cms/menu/site.php:5716 JMenuSite->__construct() Copy JROOT/libraries/cms/menu/menu.php:12915 JMenu::getInstance() Copy JROOT/libraries/cms/application/cms.php:50014 JApplicationCms->getMenu() Copy JROOT/libraries/cms/application/site.php:27713 JApplicationSite->getMenu() Copy JROOT/libraries/cms/router/site.php:5912 JRouterSite->__construct() Copy JROOT/libraries/cms/router/router.php:19811 JRouter::getInstance() Copy JROOT/libraries/cms/application/cms.php:60510 JApplicationCms::getRouter() Copy JROOT/libraries/cms/application/site.php:4079 JApplicationSite::getRouter() Copy JROOT/plugins/system/languagefilter/languagefilter.php:1348 PlgSystemLanguageFilter->onAfterInitialise() Copy JROOT/libraries/joomla/event/event.php:707 JEvent->update() Copy JROOT/libraries/joomla/event/dispatcher.php:1606 JEventDispatcher->trigger() Copy JROOT/libraries/joomla/application/base.php:1065 JApplicationBase->triggerEvent() Copy JROOT/libraries/cms/application/cms.php:7404 JApplicationCms->initialiseApp() Copy JROOT/libraries/cms/application/site.php:6903 JApplicationSite->initialiseApp() Copy JROOT/libraries/cms/application/site.php:2092 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
查询时间:1.60 ms 上次查询后:16.66 ms 查询内存:0.028 MB 查询前内存:12.368 MB 返回的行数:17
SHOW FULL COLUMNS FROM `joom_users `查询时无法解释:SHOW FULL COLUMNS FROM `joom_users`
没有 SHOW PROFILE(可能是因为有超过 100 个查询)
# 呼叫者 文件和行号 20 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172119 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/joomla/database/driver/mysqli.php:42118 JDatabaseDriverMysqli->getTableColumns() Copy JROOT/libraries/joomla/table/table.php:24417 JTable->getFields() Copy JROOT/libraries/joomla/table/table.php:16316 JTable->__construct() Copy JROOT/libraries/joomla/table/user.php:3915 JTableUser->__construct() Copy JROOT/libraries/joomla/table/table.php:31114 JTable::getInstance() Copy JROOT/libraries/joomla/user/user.php:59813 JUser::getTable() Copy JROOT/libraries/joomla/user/user.php:78212 JUser->save() Copy JROOT/plugins/system/languagefilter/languagefilter.php:84811 PlgSystemLanguageFilter->setPreferredLanguage() Copy JROOT/plugins/system/languagefilter/languagefilter.php:51210 PlgSystemLanguageFilter->parseRule() Copy JROOT/libraries/cms/router/router.php:5979 JRouter->processParseRules() Copy JROOT/libraries/cms/router/site.php:5848 JRouterSite->processParseRules() Copy JROOT/libraries/cms/router/router.php:5717 JRouter->_processParseRules() Copy JROOT/libraries/cms/router/router.php:2256 JRouter->parse() Copy JROOT/libraries/cms/router/site.php:1335 JRouterSite->parse() Copy JROOT/libraries/cms/application/cms.php:12204 JApplicationCms->route() Copy JROOT/libraries/cms/application/site.php:8003 JApplicationSite->route() Copy JROOT/libraries/cms/application/site.php:2152 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
查询时间:1.01 ms 上次查询后:0.29 ms 查询内存:0.022 MB 查询前内存:12.412 MB 返回的行数:1
SELECT `id`,`title`
FROM `joom_usergroups `
WHERE `id` = 1id 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
没有 SHOW PROFILE(可能是因为有超过 100 个查询)
# 呼叫者 文件和行号 15 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:152614 JDatabaseDriver->loadAssocList() Copy JROOT/libraries/joomla/table/user.php:15213 JTableUser->bind() Copy JROOT/libraries/joomla/user/user.php:78412 JUser->save() Copy JROOT/plugins/system/languagefilter/languagefilter.php:84811 PlgSystemLanguageFilter->setPreferredLanguage() Copy JROOT/plugins/system/languagefilter/languagefilter.php:51210 PlgSystemLanguageFilter->parseRule() Copy JROOT/libraries/cms/router/router.php:5979 JRouter->processParseRules() Copy JROOT/libraries/cms/router/site.php:5848 JRouterSite->processParseRules() Copy JROOT/libraries/cms/router/router.php:5717 JRouter->_processParseRules() Copy JROOT/libraries/cms/router/router.php:2256 JRouter->parse() Copy JROOT/libraries/cms/router/site.php:1335 JRouterSite->parse() Copy JROOT/libraries/cms/application/cms.php:12204 JApplicationCms->route() Copy JROOT/libraries/cms/application/site.php:8003 JApplicationSite->route() Copy JROOT/libraries/cms/application/site.php:2152 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
查询时间:1.31 ms 上次查询后:0.83 ms 查询内存:0.022 MB 查询前内存:12.507 MB 返回的行数:1
SELECT `userid` FROM `joom_community_users ` WHERE `alias`= '1621330:zack-galyen'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE joom_community_users NULL ref alias alias 767 const 1 100.00 Using index
没有 SHOW PROFILE(可能是因为有超过 100 个查询)
# 呼叫者 文件和行号 13 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:176012 JDatabaseDriver->loadResult() Copy JROOT/components/com_community/router.php:47711 CommunityGetUserId() Copy JROOT/components/com_community/router.php:22910 CommunityParseRoute() Copy JROOT/libraries/cms/component/router/legacy.php:1049 JComponentRouterLegacy->parse() Copy JROOT/libraries/cms/router/site.php:4328 JRouterSite->parseSefRoute() Copy JROOT/libraries/cms/router/router.php:4837 JRouter->_parseSefRoute() Copy JROOT/libraries/cms/router/router.php:2366 JRouter->parse() Copy JROOT/libraries/cms/router/site.php:1335 JRouterSite->parse() Copy JROOT/libraries/cms/application/cms.php:12204 JApplicationCms->route() Copy JROOT/libraries/cms/application/site.php:8003 JApplicationSite->route() Copy JROOT/libraries/cms/application/site.php:2152 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
查询时间:1.06 ms 上次查询后:4.06 ms 查询内存:0.019 MB 查询前内存:13.000 MB 返回的行数:0
SELECT params
FROM axs_user_settings
WHERE id = 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE NULL NULL NULL NULL 不能使用任何索引键 NULL NULL NULL NULL no matching row in const table
没有 SHOW PROFILE(可能是因为有超过 100 个查询)
# 呼叫者 文件和行号 7 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:16826 JDatabaseDriver->loadObject() Copy JROOT/libraries/axslibs/user.php:6695 AxsUser::getGlobalUserSettings() Copy JROOT/libraries/axslibs/security.php:354 AxsSecurity::getSettings() Copy JROOT/libraries/cms/application/cms.php:3773 JApplicationCms->checkUserRequireTwoFactor() Copy JROOT/libraries/cms/application/site.php:2312 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
查询时间:1.04 ms 上次查询后:2.44 ms 查询内存:0.019 MB 查询前内存:13.328 MB 返回的行数:0
SELECT *
FROM `joom_users `
WHERE `id` = 0id 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
没有 SHOW PROFILE(可能是因为有超过 100 个查询)
# 呼叫者 文件和行号 6 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:16825 JDatabaseDriver->loadObject() Copy JROOT/administrator/components/com_users/models/user.php:9924 UsersModelUser->getOtpConfig() Copy JROOT/libraries/cms/application/cms.php:3813 JApplicationCms->checkUserRequireTwoFactor() Copy JROOT/libraries/cms/application/site.php:2312 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
查询时间:1.48 ms 上次查询后:0.19 ms 查询内存:0.019 MB 查询前内存:13.336 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 = 1id 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
没有 SHOW PROFILE(可能是因为有超过 100 个查询)
# 呼叫者 文件和行号 6 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:17215 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/cms/application/site.php:4904 JApplicationSite->getTemplate() Copy JROOT/libraries/cms/application/site.php:1653 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
查询时间:1.54 ms 上次查询后:18.94 ms 查询内存:0.023 MB 查询前内存:14.327 MB 返回的行数:2
SHOW FULL COLUMNS FROM `joom_community_config `查询时无法解释:SHOW FULL COLUMNS FROM `joom_community_config`
没有 SHOW PROFILE(可能是因为有超过 100 个查询)
# 呼叫者 文件和行号 15 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172114 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/joomla/database/driver/mysqli.php:42113 JDatabaseDriverMysqli->getTableColumns() Copy JROOT/libraries/joomla/table/table.php:24412 JTable->getFields() Copy JROOT/libraries/joomla/table/table.php:16311 JTable->__construct() Copy JROOT/administrator/components/com_community/tables/configuration.php:2210 CommunityTableConfiguration->__construct() Copy JROOT/libraries/joomla/table/table.php:3119 JTable::getInstance() Copy JROOT/components/com_community/libraries/core.php:10578 CConfig::getInstance() Copy JROOT/components/com_community/libraries/core.php:2377 CFactory::getConfig() Copy JROOT/components/com_community/community.php:456 require_once Copy JROOT/components/com_community/community.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
查询时间:1.07 ms 上次查询后:0.09 ms 查询内存:0.021 MB 查询前内存:14.339 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
没有 SHOW PROFILE(可能是因为有超过 100 个查询)
# 呼叫者 文件和行号 11 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:148510 JDatabaseDriver->loadAssoc() Copy JROOT/libraries/joomla/table/table.php:7299 JTable->load() Copy JROOT/components/com_community/libraries/core.php:10588 CConfig::getInstance() Copy JROOT/components/com_community/libraries/core.php:2377 CFactory::getConfig() Copy JROOT/components/com_community/community.php:456 require_once Copy JROOT/components/com_community/community.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
查询时间:2.15 ms 上次查询后:0.99 ms 查询内存:0.022 MB 查询前内存:14.457 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
没有 SHOW PROFILE(可能是因为有超过 100 个查询)
# 呼叫者 文件和行号 12 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:168211 JDatabaseDriver->loadObject() Copy JROOT/libraries/axslibs/images.php:6610 AxsImages::setSession() Copy JROOT/libraries/axslibs/images.php:159 AxsImages::getImagesPath() Copy JROOT/components/com_community/libraries/core.php:10928 CConfig::getInstance() Copy JROOT/components/com_community/libraries/core.php:2377 CFactory::getConfig() Copy JROOT/components/com_community/community.php:456 require_once Copy JROOT/components/com_community/community.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
查询时间:1.14 ms 上次查询后:15.01 ms 查询内存:0.022 MB 查询前内存:17.142 MB 返回的行数:0
SELECT `id` 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.05 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
# 呼叫者 文件和行号 10 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:17609 JDatabaseDriver->loadResult() Copy JROOT/components/com_community/libraries/core.php:1908 CFactory::getUser() Copy JROOT/components/com_community/controllers/controller.php:407 CommunityBaseController->__construct() Copy JROOT/components/com_community/community.php:1446 require_once Copy JROOT/components/com_community/community.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
查询时间:1.58 ms 上次查询后:1.19 ms 查询内存:0.021 MB 查询前内存:17.307 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.`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`= '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.20 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.02 ms Opening tables 0.03 ms init 0.05 ms System lock 0.04 ms optimizing 0.02 ms statistics 0.07 ms executing 0.04 ms end 0.01 ms query end 0.02 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.01 ms
# 呼叫者 文件和行号 11 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:168210 JDatabaseDriver->loadObject() Copy JROOT/components/com_community/libraries/user.php:1689 CUser->init() Copy JROOT/components/com_community/libraries/core.php:2018 CFactory::getUser() Copy JROOT/components/com_community/controllers/controller.php:407 CommunityBaseController->__construct() Copy JROOT/components/com_community/community.php:1446 require_once Copy JROOT/components/com_community/community.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
查询时间:1.53 ms 上次查询后:0.35 ms 查询内存:0.026 MB 查询前内存:17.349 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.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.02 ms checking permissions 0.04 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 Sending data 0.05 ms end 0.01 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
# 呼叫者 文件和行号 16 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172115 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/joomla/database/driver/mysqli.php:42114 JDatabaseDriverMysqli->getTableColumns() Copy JROOT/libraries/joomla/table/table.php:24413 JTable->getFields() Copy JROOT/libraries/joomla/table/table.php:16312 JTable->__construct() Copy JROOT/components/com_community/tables/multiprofile.php:3211 CTableMultiProfile->__construct() Copy JROOT/libraries/joomla/table/table.php:31110 JTable::getInstance() Copy JROOT/components/com_community/libraries/user.php:7329 CUser->getThumbAvatar() Copy JROOT/components/com_community/libraries/core.php:2028 CFactory::getUser() Copy JROOT/components/com_community/controllers/controller.php:407 CommunityBaseController->__construct() Copy JROOT/components/com_community/community.php:1446 require_once Copy JROOT/components/com_community/community.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
查询时间:1.04 ms 上次查询后:0.71 ms 查询内存:0.022 MB 查询前内存:17.461 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.02 ms sending cached result to clien 0.05 ms cleaned up 0.01 ms cleaning up 0.00 ms
# 呼叫者 文件和行号 14 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:176013 JDatabaseDriver->loadResult() Copy JROOT/components/com_community/models/profile.php:78812 CommunityModelProfile->_getgenderId() Copy JROOT/components/com_community/models/profile.php:76211 CommunityModelProfile->getGender() Copy JROOT/components/com_community/libraries/user.php:62910 CUser->_getGender() Copy JROOT/components/com_community/libraries/user.php:7679 CUser->getThumbAvatar() Copy JROOT/components/com_community/libraries/core.php:2028 CFactory::getUser() Copy JROOT/components/com_community/controllers/controller.php:407 CommunityBaseController->__construct() Copy JROOT/components/com_community/community.php:1446 require_once Copy JROOT/components/com_community/community.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
查询时间:1.00 ms 上次查询后:0.02 ms 查询内存:0.023 MB 查询前内存:17.474 MB 返回的行数:0
SELECT `value` FROM `joom_community_fields_values ` WHERE `field_id` = '2' AND `user_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.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
# 呼叫者 文件和行号 13 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:176012 JDatabaseDriver->loadResult() Copy JROOT/components/com_community/models/profile.php:77111 CommunityModelProfile->getGender() Copy JROOT/components/com_community/libraries/user.php:62910 CUser->_getGender() Copy JROOT/components/com_community/libraries/user.php:7679 CUser->getThumbAvatar() Copy JROOT/components/com_community/libraries/core.php:2028 CFactory::getUser() Copy JROOT/components/com_community/controllers/controller.php:407 CommunityBaseController->__construct() Copy JROOT/components/com_community/community.php:1446 require_once Copy JROOT/components/com_community/community.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
查询时间:0.99 ms 上次查询后:2.69 ms 查询内存:0.022 MB 查询前内存:17.761 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.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.05 ms cleaned up 0.01 ms cleaning up 0.00 ms
# 呼叫者 文件和行号 12 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:176011 JDatabaseDriver->loadResult() Copy JROOT/components/com_community/libraries/core.php:19010 CFactory::getUser() Copy JROOT/components/com_community/controllers/profile.php:14149 CommunityProfileController->profile() Copy JROOT/components/com_community/controllers/profile.php:12028 CommunityProfileController->display() Copy JROOT/components/com_community/controllers/controller.php:3317 CommunityBaseController->execute() Copy JROOT/components/com_community/community.php:1456 require_once Copy JROOT/components/com_community/community.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
查询时间:1.77 ms 上次查询后:0.04 ms 查询内存:0.023 MB 查询前内存:17.769 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.03 ms checking query cache for query 0.01 ms checking privileges on cached 0.01 ms checking permissions 0.23 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.05 ms System lock 0.03 ms optimizing 0.05 ms statistics 0.18 ms preparing 0.03 ms executing 0.01 ms Sending data 0.06 ms end 0.01 ms query end 0.02 ms closing tables 0.01 ms freeing items 0.06 ms storing result in query cache 0.02 ms cleaned up 0.01 ms cleaning up 0.01 ms
# 呼叫者 文件和行号 13 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:168212 JDatabaseDriver->loadObject() Copy JROOT/components/com_community/libraries/user.php:16811 CUser->init() Copy JROOT/components/com_community/libraries/core.php:20110 CFactory::getUser() Copy JROOT/components/com_community/controllers/profile.php:14149 CommunityProfileController->profile() Copy JROOT/components/com_community/controllers/profile.php:12028 CommunityProfileController->display() Copy JROOT/components/com_community/controllers/controller.php:3317 CommunityBaseController->execute() Copy JROOT/components/com_community/community.php:1456 require_once Copy JROOT/components/com_community/community.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
查询时间:0.99 ms 上次查询后:0.09 ms 查询内存:0.023 MB 查询前内存:17.792 MB 返回的行数:0
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.02 ms sending cached result to clien 0.03 ms cleaned up 0.01 ms cleaning up 0.00 ms
# 呼叫者 文件和行号 15 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:176014 JDatabaseDriver->loadResult() Copy JROOT/components/com_community/models/profile.php:77113 CommunityModelProfile->getGender() Copy JROOT/components/com_community/libraries/user.php:62912 CUser->_getGender() Copy JROOT/components/com_community/libraries/user.php:76711 CUser->getThumbAvatar() Copy JROOT/components/com_community/libraries/core.php:20210 CFactory::getUser() Copy JROOT/components/com_community/controllers/profile.php:14149 CommunityProfileController->profile() Copy JROOT/components/com_community/controllers/profile.php:12028 CommunityProfileController->display() Copy JROOT/components/com_community/controllers/controller.php:3317 CommunityBaseController->execute() Copy JROOT/components/com_community/community.php:1456 require_once Copy JROOT/components/com_community/community.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
查询时间:1.10 ms 上次查询后:0.13 ms 查询内存:0.026 MB 查询前内存:17.799 MB 返回的行数:14
SELECT field.* , value.`value`,value.`access`, value.`params` as fieldparams FROM `joom_community_fields ` AS field LEFT JOIN `joom_community_fields_values ` AS value ON field.`id`= value.`field_id` AND value.`user_id`= '1621330' WHERE field.`published`= '1' AND field.`visible`>= '1' ORDER BY field.`ordering`id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE field NULL ALL NULL 不能使用任何索引键 NULL NULL 17 5.88 Using where; 使用文件排序 1 SIMPLE value NULL eq_ref unique_field_values,field_id,idx_user_fieldid,user_id unique_field_values 8 const,root_db.field.id 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 checking permissions 0.01 ms sending cached result to clien 0.02 ms cleaned up 0.01 ms cleaning up 0.00 ms
# 呼叫者 文件和行号 12 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:152611 JDatabaseDriver->loadAssocList() Copy JROOT/components/com_community/models/profile.php:29510 CommunityModelProfile->getViewableProfile() Copy JROOT/components/com_community/controllers/profile.php:14239 CommunityProfileController->profile() Copy JROOT/components/com_community/controllers/profile.php:12028 CommunityProfileController->display() Copy JROOT/components/com_community/controllers/controller.php:3317 CommunityBaseController->execute() Copy JROOT/components/com_community/community.php:1456 require_once Copy JROOT/components/com_community/community.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
查询时间:1.03 ms 上次查询后:0.60 ms 查询内存:0.030 MB 查询前内存:17.918 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` = 0id 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.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.04 ms cleaned up 0.01 ms cleaning up 0.00 ms
# 呼叫者 文件和行号 19 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172118 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/joomla/access/access.php:42717 JAccess::preloadComponents() Copy JROOT/libraries/joomla/access/access.php:21116 JAccess::preload() Copy JROOT/libraries/joomla/access/access.php:53015 JAccess::getAssetRules() Copy JROOT/libraries/joomla/access/access.php:18114 JAccess::check() Copy JROOT/libraries/joomla/user/user.php:39313 JUser->authorise() Copy JROOT/components/com_community/libraries/user.php:123512 CUser->authorise() Copy JROOT/components/com_community/helpers/owner.php:5111 COwnerHelper::isCommunityAdmin() Copy JROOT/components/com_community/models/profile.php:32710 CommunityModelProfile->getViewableProfile() Copy JROOT/components/com_community/controllers/profile.php:14239 CommunityProfileController->profile() Copy JROOT/components/com_community/controllers/profile.php:12028 CommunityProfileController->display() Copy JROOT/components/com_community/controllers/controller.php:3317 CommunityBaseController->execute() Copy JROOT/components/com_community/community.php:1456 require_once Copy JROOT/components/com_community/community.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
查询时间:1.04 ms 上次查询后:8.20 ms 查询内存:0.023 MB 查询前内存:18.730 MB 返回的行数:0
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.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
# 呼叫者 文件和行号 15 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:176014 JDatabaseDriver->loadResult() Copy JROOT/components/com_community/models/profile.php:77113 CommunityModelProfile->getGender() Copy JROOT/components/com_community/libraries/user.php:127412 CUser->getCover() Copy JROOT/components/com_community/views/profile/view.html.php:57511 CommunityViewProfile->profile() Copy JROOT/components/com_community/views/views.php:25110 CommunityView->get() Copy JROOT/components/com_community/controllers/profile.php:14549 CommunityProfileController->profile() Copy JROOT/components/com_community/controllers/profile.php:12028 CommunityProfileController->display() Copy JROOT/components/com_community/controllers/controller.php:3317 CommunityBaseController->execute() Copy JROOT/components/com_community/community.php:1456 require_once Copy JROOT/components/com_community/community.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
查询时间:1.04 ms 上次查询后:0.85 ms 查询内存:0.023 MB 查询前内存:18.765 MB 返回的行数:8
SELECT `id`,`parent_id` FROM `joom_menu ` WHERE `menutype`= 'jomsocial' AND `published`= '1' AND `link` LIKE '%index.php?option= com_community&view= profile%'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE joom_menu NULL ref idx_menutype idx_menutype 98 const 33 1.11 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.03 ms cleaned up 0.01 ms cleaning up 0.01 ms
# 呼叫者 文件和行号 15 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:168214 JDatabaseDriver->loadObject() Copy JROOT/components/com_community/models/toolbar.php:14013 CommunityModelToolbar->getActiveId() Copy JROOT/components/com_community/helpers/head.php:9612 CHeadHelper::setType() Copy JROOT/components/com_community/views/profile/view.html.php:57511 CommunityViewProfile->profile() Copy JROOT/components/com_community/views/views.php:25110 CommunityView->get() Copy JROOT/components/com_community/controllers/profile.php:14549 CommunityProfileController->profile() Copy JROOT/components/com_community/controllers/profile.php:12028 CommunityProfileController->display() Copy JROOT/components/com_community/controllers/controller.php:3317 CommunityBaseController->execute() Copy JROOT/components/com_community/community.php:1456 require_once Copy JROOT/components/com_community/community.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
查询时间:0.98 ms 上次查询后:0.36 ms 查询内存:0.024 MB 查询前内存:18.799 MB 返回的行数:1
SELECT `id` FROM `joom_menu ` WHERE `link` LIKE '%option= com_community&view= frontpage%' 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.02 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
# 呼叫者 文件和行号 17 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:176016 JDatabaseDriver->loadResult() Copy JROOT/components/com_community/libraries/core.php:139115 CRoute::_getViewItemid() Copy JROOT/components/com_community/libraries/core.php:130114 CRoute::_() Copy JROOT/components/com_community/libraries/core.php:124113 CRoute::getExternalURL() Copy JROOT/components/com_community/helpers/head.php:14912 CHeadHelper::setType() Copy JROOT/components/com_community/views/profile/view.html.php:57511 CommunityViewProfile->profile() Copy JROOT/components/com_community/views/views.php:25110 CommunityView->get() Copy JROOT/components/com_community/controllers/profile.php:14549 CommunityProfileController->profile() Copy JROOT/components/com_community/controllers/profile.php:12028 CommunityProfileController->display() Copy JROOT/components/com_community/controllers/controller.php:3317 CommunityBaseController->execute() Copy JROOT/components/com_community/community.php:1456 require_once Copy JROOT/components/com_community/community.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
查询时间:1.00 ms 上次查询后:0.22 ms 查询内存:0.024 MB 查询前内存:18.883 MB 返回的行数:1
SELECT `id` FROM `joom_menu ` WHERE `link` LIKE '%option= com_community&view= groups%' 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.03 ms cleaned up 0.01 ms cleaning up 0.00 ms
# 呼叫者 文件和行号 17 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:176016 JDatabaseDriver->loadResult() Copy JROOT/components/com_community/libraries/core.php:139115 CRoute::_getViewItemid() Copy JROOT/components/com_community/libraries/core.php:130114 CRoute::_() Copy JROOT/components/com_community/libraries/core.php:124113 CRoute::getExternalURL() Copy JROOT/components/com_community/helpers/head.php:15012 CHeadHelper::setType() Copy JROOT/components/com_community/views/profile/view.html.php:57511 CommunityViewProfile->profile() Copy JROOT/components/com_community/views/views.php:25110 CommunityView->get() Copy JROOT/components/com_community/controllers/profile.php:14549 CommunityProfileController->profile() Copy JROOT/components/com_community/controllers/profile.php:12028 CommunityProfileController->display() Copy JROOT/components/com_community/controllers/controller.php:3317 CommunityBaseController->execute() Copy JROOT/components/com_community/community.php:1456 require_once Copy JROOT/components/com_community/community.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
查询时间:1.06 ms 上次查询后:0.08 ms 查询内存:0.024 MB 查询前内存:18.893 MB 返回的行数:0
SELECT `id` FROM `joom_menu ` WHERE `link` LIKE '%option= com_community&view= photos%' 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.01 ms sending cached result to clien 0.03 ms cleaned up 0.01 ms cleaning up 0.00 ms
# 呼叫者 文件和行号 17 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:176016 JDatabaseDriver->loadResult() Copy JROOT/components/com_community/libraries/core.php:139115 CRoute::_getViewItemid() Copy JROOT/components/com_community/libraries/core.php:130114 CRoute::_() Copy JROOT/components/com_community/libraries/core.php:124113 CRoute::getExternalURL() Copy JROOT/components/com_community/helpers/head.php:15112 CHeadHelper::setType() Copy JROOT/components/com_community/views/profile/view.html.php:57511 CommunityViewProfile->profile() Copy JROOT/components/com_community/views/views.php:25110 CommunityView->get() Copy JROOT/components/com_community/controllers/profile.php:14549 CommunityProfileController->profile() Copy JROOT/components/com_community/controllers/profile.php:12028 CommunityProfileController->display() Copy JROOT/components/com_community/controllers/controller.php:3317 CommunityBaseController->execute() Copy JROOT/components/com_community/community.php:1456 require_once Copy JROOT/components/com_community/community.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
查询时间:1.02 ms 上次查询后:0.06 ms 查询内存:0.024 MB 查询前内存:18.901 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.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.00 ms
# 呼叫者 文件和行号 17 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:176016 JDatabaseDriver->loadResult() Copy JROOT/components/com_community/libraries/core.php:143115 CRoute::_getDefaultItemid() Copy JROOT/components/com_community/libraries/core.php:131614 CRoute::_() Copy JROOT/components/com_community/libraries/core.php:124113 CRoute::getExternalURL() Copy JROOT/components/com_community/helpers/head.php:15112 CHeadHelper::setType() Copy JROOT/components/com_community/views/profile/view.html.php:57511 CommunityViewProfile->profile() Copy JROOT/components/com_community/views/views.php:25110 CommunityView->get() Copy JROOT/components/com_community/controllers/profile.php:14549 CommunityProfileController->profile() Copy JROOT/components/com_community/controllers/profile.php:12028 CommunityProfileController->display() Copy JROOT/components/com_community/controllers/controller.php:3317 CommunityBaseController->execute() Copy JROOT/components/com_community/community.php:1456 require_once Copy JROOT/components/com_community/community.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
查询时间:1.02 ms 上次查询后:0.03 ms 查询内存:0.025 MB 查询前内存:18.909 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.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
# 呼叫者 文件和行号 17 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:176016 JDatabaseDriver->loadResult() Copy JROOT/components/com_community/libraries/core.php:144015 CRoute::_getDefaultItemid() Copy JROOT/components/com_community/libraries/core.php:131614 CRoute::_() Copy JROOT/components/com_community/libraries/core.php:124113 CRoute::getExternalURL() Copy JROOT/components/com_community/helpers/head.php:15112 CHeadHelper::setType() Copy JROOT/components/com_community/views/profile/view.html.php:57511 CommunityViewProfile->profile() Copy JROOT/components/com_community/views/views.php:25110 CommunityView->get() Copy JROOT/components/com_community/controllers/profile.php:14549 CommunityProfileController->profile() Copy JROOT/components/com_community/controllers/profile.php:12028 CommunityProfileController->display() Copy JROOT/components/com_community/controllers/controller.php:3317 CommunityBaseController->execute() Copy JROOT/components/com_community/community.php:1456 require_once Copy JROOT/components/com_community/community.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
查询时间:1.00 ms 上次查询后:0.11 ms 查询内存:0.024 MB 查询前内存:18.919 MB 返回的行数:0
SELECT `id` FROM `joom_menu ` WHERE `link` LIKE '%option= com_community&view= videos%' 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.01 ms sending cached result to clien 0.02 ms cleaned up 0.01 ms cleaning up 0.00 ms
# 呼叫者 文件和行号 17 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:176016 JDatabaseDriver->loadResult() Copy JROOT/components/com_community/libraries/core.php:139115 CRoute::_getViewItemid() Copy JROOT/components/com_community/libraries/core.php:130114 CRoute::_() Copy JROOT/components/com_community/libraries/core.php:124113 CRoute::getExternalURL() Copy JROOT/components/com_community/helpers/head.php:15212 CHeadHelper::setType() Copy JROOT/components/com_community/views/profile/view.html.php:57511 CommunityViewProfile->profile() Copy JROOT/components/com_community/views/views.php:25110 CommunityView->get() Copy JROOT/components/com_community/controllers/profile.php:14549 CommunityProfileController->profile() Copy JROOT/components/com_community/controllers/profile.php:12028 CommunityProfileController->display() Copy JROOT/components/com_community/controllers/controller.php:3317 CommunityBaseController->execute() Copy JROOT/components/com_community/community.php:1456 require_once Copy JROOT/components/com_community/community.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
查询时间:0.99 ms 上次查询后:0.13 ms 查询内存:0.024 MB 查询前内存:18.928 MB 返回的行数:0
SELECT `id` FROM `joom_menu ` WHERE `link` LIKE '%option= com_community&view= events%' 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.01 ms sending cached result to clien 0.02 ms cleaned up 0.01 ms cleaning up 0.01 ms
# 呼叫者 文件和行号 17 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:176016 JDatabaseDriver->loadResult() Copy JROOT/components/com_community/libraries/core.php:139115 CRoute::_getViewItemid() Copy JROOT/components/com_community/libraries/core.php:130114 CRoute::_() Copy JROOT/components/com_community/libraries/core.php:124113 CRoute::getExternalURL() Copy JROOT/components/com_community/helpers/head.php:15312 CHeadHelper::setType() Copy JROOT/components/com_community/views/profile/view.html.php:57511 CommunityViewProfile->profile() Copy JROOT/components/com_community/views/views.php:25110 CommunityView->get() Copy JROOT/components/com_community/controllers/profile.php:14549 CommunityProfileController->profile() Copy JROOT/components/com_community/controllers/profile.php:12028 CommunityProfileController->display() Copy JROOT/components/com_community/controllers/controller.php:3317 CommunityBaseController->execute() Copy JROOT/components/com_community/community.php:1456 require_once Copy JROOT/components/com_community/community.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
查询时间:1.05 ms 上次查询后:0.12 ms 查询内存:0.023 MB 查询前内存:18.936 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.01 ms sending cached result to clien 0.03 ms cleaned up 0.01 ms cleaning up 0.00 ms
# 呼叫者 文件和行号 16 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:176015 JDatabaseDriver->loadResult() Copy JROOT/components/com_community/libraries/core.php:139114 CRoute::_getViewItemid() Copy JROOT/components/com_community/libraries/core.php:130113 CRoute::_() Copy JROOT/components/com_community/libraries/core.php:124112 CRoute::getExternalURL() Copy JROOT/components/com_community/views/profile/view.html.php:58811 CommunityViewProfile->profile() Copy JROOT/components/com_community/views/views.php:25110 CommunityView->get() Copy JROOT/components/com_community/controllers/profile.php:14549 CommunityProfileController->profile() Copy JROOT/components/com_community/controllers/profile.php:12028 CommunityProfileController->display() Copy JROOT/components/com_community/controllers/controller.php:3317 CommunityBaseController->execute() Copy JROOT/components/com_community/community.php:1456 require_once Copy JROOT/components/com_community/community.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
查询时间:2.07 ms 上次查询后:3.66 ms 查询内存:0.023 MB 查询前内存:19.090 MB 返回的行数:1
SELECT `element` FROM `joom_extensions ` WHERE `enabled`= '1' AND `folder`= 'community'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 1.00 Using where
Status Duration starting 0.05 ms checking query cache for query 0.08 ms checking permissions 0.03 ms Opening tables 0.02 ms init 0.03 ms System lock 0.04 ms optimizing 0.02 ms statistics 0.03 ms preparing 0.02 ms executing 0.00 ms Sending data 0.62 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.01 ms cleaning up 0.02 ms
# 呼叫者 文件和行号 16 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:157015 JDatabaseDriver->loadColumn() Copy JROOT/components/com_community/models/apps.php:18614 CommunityModelApps->getUserApps() Copy JROOT/components/com_community/libraries/apps.php:17413 CAppPlugins->_triggerOnProfileDisplay() Copy JROOT/components/com_community/libraries/apps.php:28912 CAppPlugins->triggerEvent() Copy JROOT/components/com_community/views/profile/view.html.php:62211 CommunityViewProfile->profile() Copy JROOT/components/com_community/views/views.php:25110 CommunityView->get() Copy JROOT/components/com_community/controllers/profile.php:14549 CommunityProfileController->profile() Copy JROOT/components/com_community/controllers/profile.php:12028 CommunityProfileController->display() Copy JROOT/components/com_community/controllers/controller.php:3317 CommunityBaseController->execute() Copy JROOT/components/com_community/community.php:1456 require_once Copy JROOT/components/com_community/community.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
查询时间:1.06 ms 上次查询后:0.07 ms 查询内存:0.023 MB 查询前内存:19.098 MB 返回的行数:0
SELECT DISTINCT a.* FROM `joom_community_apps ` AS a WHERE a.`userid`= '1621330' AND a.`apps`!= 'news_feed' AND a.`apps`!= 'profile' AND a.`apps`!= 'friends' AND a.`apps` IN ('walls') ORDER BY a.`ordering`id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL ref idx_user_apps,idx_userid idx_user_apps 606 const,const 1 100.00 Using index condition; 使用文件排序
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.01 ms
# 呼叫者 文件和行号 16 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172115 JDatabaseDriver->loadObjectList() Copy JROOT/components/com_community/models/apps.php:20814 CommunityModelApps->getUserApps() Copy JROOT/components/com_community/libraries/apps.php:17413 CAppPlugins->_triggerOnProfileDisplay() Copy JROOT/components/com_community/libraries/apps.php:28912 CAppPlugins->triggerEvent() Copy JROOT/components/com_community/views/profile/view.html.php:62211 CommunityViewProfile->profile() Copy JROOT/components/com_community/views/views.php:25110 CommunityView->get() Copy JROOT/components/com_community/controllers/profile.php:14549 CommunityProfileController->profile() Copy JROOT/components/com_community/controllers/profile.php:12028 CommunityProfileController->display() Copy JROOT/components/com_community/controllers/controller.php:3317 CommunityBaseController->execute() Copy JROOT/components/com_community/community.php:1456 require_once Copy JROOT/components/com_community/community.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
查询时间:1.30 ms 上次查询后:0.54 ms 查询内存:0.025 MB 查询前内存:19.109 MB 返回的行数:1
SELECT `extension_id` FROM `joom_extensions ` WHERE `element`= 'walls' AND `folder`= 'community'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 element_clientid 402 const 1 10.00 Using where
Status Duration starting 0.02 ms checking query cache for query 0.06 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.03 ms System lock 0.02 ms optimizing 0.02 ms statistics 0.08 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.00 ms
# 呼叫者 文件和行号 20 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:176019 JDatabaseDriver->loadResult() Copy JROOT/components/com_community/models/apps.php:71718 CommunityModelApps->getPluginId() Copy JROOT/components/com_community/models/apps.php:41817 CommunityModelApps->getAppInfo() Copy JROOT/components/com_community/models/apps.php:36216 CommunityModelApps->getAvailableApps() Copy JROOT/components/com_community/models/apps.php:47015 CommunityModelApps->getCoreApps() Copy JROOT/components/com_community/models/apps.php:21714 CommunityModelApps->getUserApps() Copy JROOT/components/com_community/libraries/apps.php:17413 CAppPlugins->_triggerOnProfileDisplay() Copy JROOT/components/com_community/libraries/apps.php:28912 CAppPlugins->triggerEvent() Copy JROOT/components/com_community/views/profile/view.html.php:62211 CommunityViewProfile->profile() Copy JROOT/components/com_community/views/views.php:25110 CommunityView->get() Copy JROOT/components/com_community/controllers/profile.php:14549 CommunityProfileController->profile() Copy JROOT/components/com_community/controllers/profile.php:12028 CommunityProfileController->display() Copy JROOT/components/com_community/controllers/controller.php:3317 CommunityBaseController->execute() Copy JROOT/components/com_community/community.php:1456 require_once Copy JROOT/components/com_community/community.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
查询时间:2.76 ms 上次查询后:0.05 ms 查询内存:0.025 MB 查询前内存:19.118 MB 返回的行数:1
SELECT `params` FROM `joom_extensions ` WHERE `extension_id`= '10040'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE joom_extensions NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL
Status Duration starting 0.02 ms checking query cache for query 0.04 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.04 ms preparing 0.01 ms executing 0.00 ms Sending data 0.01 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms storing result in query cache 0.01 ms cleaned up 0.01 ms cleaning up 0.00 ms
# 呼叫者 文件和行号 20 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:176019 JDatabaseDriver->loadResult() Copy JROOT/components/com_community/models/apps.php:58918 CommunityModelApps->getPluginParams() Copy JROOT/components/com_community/models/apps.php:41817 CommunityModelApps->getAppInfo() Copy JROOT/components/com_community/models/apps.php:36216 CommunityModelApps->getAvailableApps() Copy JROOT/components/com_community/models/apps.php:47015 CommunityModelApps->getCoreApps() Copy JROOT/components/com_community/models/apps.php:21714 CommunityModelApps->getUserApps() Copy JROOT/components/com_community/libraries/apps.php:17413 CAppPlugins->_triggerOnProfileDisplay() Copy JROOT/components/com_community/libraries/apps.php:28912 CAppPlugins->triggerEvent() Copy JROOT/components/com_community/views/profile/view.html.php:62211 CommunityViewProfile->profile() Copy JROOT/components/com_community/views/views.php:25110 CommunityView->get() Copy JROOT/components/com_community/controllers/profile.php:14549 CommunityProfileController->profile() Copy JROOT/components/com_community/controllers/profile.php:12028 CommunityProfileController->display() Copy JROOT/components/com_community/controllers/controller.php:3317 CommunityBaseController->execute() Copy JROOT/components/com_community/community.php:1456 require_once Copy JROOT/components/com_community/community.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
查询时间:1.31 ms 上次查询后:0.65 ms 查询内存:0.025 MB 查询前内存:19.130 MB 返回的行数:1
SELECT `name` FROM `joom_extensions ` WHERE `element`= 'walls' AND `folder`= 'community'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 element_clientid 402 const 1 10.00 Using where
Status Duration starting 0.03 ms checking query cache for query 0.06 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.02 ms System lock 0.03 ms optimizing 0.02 ms statistics 0.08 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.03 ms cleaning up 0.01 ms
# 呼叫者 文件和行号 20 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:176019 JDatabaseDriver->loadResult() Copy JROOT/components/com_community/models/apps.php:10518 CommunityModelApps->getAppTitle() Copy JROOT/components/com_community/models/apps.php:42817 CommunityModelApps->getAppInfo() Copy JROOT/components/com_community/models/apps.php:36216 CommunityModelApps->getAvailableApps() Copy JROOT/components/com_community/models/apps.php:47015 CommunityModelApps->getCoreApps() Copy JROOT/components/com_community/models/apps.php:21714 CommunityModelApps->getUserApps() Copy JROOT/components/com_community/libraries/apps.php:17413 CAppPlugins->_triggerOnProfileDisplay() Copy JROOT/components/com_community/libraries/apps.php:28912 CAppPlugins->triggerEvent() Copy JROOT/components/com_community/views/profile/view.html.php:62211 CommunityViewProfile->profile() Copy JROOT/components/com_community/views/views.php:25110 CommunityView->get() Copy JROOT/components/com_community/controllers/profile.php:14549 CommunityProfileController->profile() Copy JROOT/components/com_community/controllers/profile.php:12028 CommunityProfileController->display() Copy JROOT/components/com_community/controllers/controller.php:3317 CommunityBaseController->execute() Copy JROOT/components/com_community/community.php:1456 require_once Copy JROOT/components/com_community/community.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
查询时间:1.06 ms 上次查询后:0.87 ms 查询内存:0.024 MB 查询前内存:19.220 MB 返回的行数:1
SELECT `extension_id` FROM `joom_extensions ` WHERE `element`= 'walls' AND `folder`= 'community'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 element_clientid 402 const 1 10.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
# 呼叫者 文件和行号 18 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:176017 JDatabaseDriver->loadResult() Copy JROOT/components/com_community/models/apps.php:71716 CommunityModelApps->getPluginId() Copy JROOT/components/com_community/models/apps.php:47615 CommunityModelApps->getCoreApps() Copy JROOT/components/com_community/models/apps.php:21714 CommunityModelApps->getUserApps() Copy JROOT/components/com_community/libraries/apps.php:17413 CAppPlugins->_triggerOnProfileDisplay() Copy JROOT/components/com_community/libraries/apps.php:28912 CAppPlugins->triggerEvent() Copy JROOT/components/com_community/views/profile/view.html.php:62211 CommunityViewProfile->profile() Copy JROOT/components/com_community/views/views.php:25110 CommunityView->get() Copy JROOT/components/com_community/controllers/profile.php:14549 CommunityProfileController->profile() Copy JROOT/components/com_community/controllers/profile.php:12028 CommunityProfileController->display() Copy JROOT/components/com_community/controllers/controller.php:3317 CommunityBaseController->execute() Copy JROOT/components/com_community/community.php:1456 require_once Copy JROOT/components/com_community/community.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
查询时间:1.03 ms 上次查询后:0.04 ms 查询内存:0.024 MB 查询前内存:19.229 MB 返回的行数:1
SELECT `params` FROM `joom_extensions ` WHERE `extension_id`= '10040'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE joom_extensions 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
# 呼叫者 文件和行号 18 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:176017 JDatabaseDriver->loadResult() Copy JROOT/components/com_community/models/apps.php:58916 CommunityModelApps->getPluginParams() Copy JROOT/components/com_community/models/apps.php:47615 CommunityModelApps->getCoreApps() Copy JROOT/components/com_community/models/apps.php:21714 CommunityModelApps->getUserApps() Copy JROOT/components/com_community/libraries/apps.php:17413 CAppPlugins->_triggerOnProfileDisplay() Copy JROOT/components/com_community/libraries/apps.php:28912 CAppPlugins->triggerEvent() Copy JROOT/components/com_community/views/profile/view.html.php:62211 CommunityViewProfile->profile() Copy JROOT/components/com_community/views/views.php:25110 CommunityView->get() Copy JROOT/components/com_community/controllers/profile.php:14549 CommunityProfileController->profile() Copy JROOT/components/com_community/controllers/profile.php:12028 CommunityProfileController->display() Copy JROOT/components/com_community/controllers/controller.php:3317 CommunityBaseController->execute() Copy JROOT/components/com_community/community.php:1456 require_once Copy JROOT/components/com_community/community.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
查询时间:1.01 ms 上次查询后:0.04 ms 查询内存:0.023 MB 查询前内存:19.237 MB 返回的行数:0
SELECT * FROM `joom_community_apps ` WHERE `userid`= '1621330' AND `apps`!= 'news_feed' AND `apps`!= 'profile' AND `apps`!= 'friends' ORDER BY `ordering`id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE joom_community_apps NULL ref idx_user_apps,idx_userid idx_userid 4 const 1 100.00 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.02 ms sending cached result to clien 0.06 ms cleaned up 0.01 ms cleaning up 0.00 ms
# 呼叫者 文件和行号 16 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172115 JDatabaseDriver->loadObjectList() Copy JROOT/components/com_community/models/apps.php:25814 CommunityModelApps->getUserApps() Copy JROOT/components/com_community/libraries/apps.php:17413 CAppPlugins->_triggerOnProfileDisplay() Copy JROOT/components/com_community/libraries/apps.php:28912 CAppPlugins->triggerEvent() Copy JROOT/components/com_community/views/profile/view.html.php:62211 CommunityViewProfile->profile() Copy JROOT/components/com_community/views/views.php:25110 CommunityView->get() Copy JROOT/components/com_community/controllers/profile.php:14549 CommunityProfileController->profile() Copy JROOT/components/com_community/controllers/profile.php:12028 CommunityProfileController->display() Copy JROOT/components/com_community/controllers/controller.php:3317 CommunityBaseController->execute() Copy JROOT/components/com_community/community.php:1456 require_once Copy JROOT/components/com_community/community.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
查询时间:1.06 ms 上次查询后:13.27 ms 查询内存:0.024 MB 查询前内存:20.156 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.00 ms checking permissions 0.02 ms sending cached result to clien 0.03 ms cleaned up 0.02 ms cleaning up 0.01 ms
# 呼叫者 文件和行号 17 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:176016 JDatabaseDriver->loadResult() Copy JROOT/components/com_community/libraries/core.php:19015 CFactory::getUser() Copy JROOT/components/com_community/libraries/activities.php:106914 CActivities->getHTML() Copy JROOT/components/com_community/libraries/activities.php:148113 CActivities::getActivitiesByFilter() Copy JROOT/components/com_community/views/profile/view.html.php:32512 CommunityViewProfile->_getNewsfeedHTML() Copy JROOT/components/com_community/views/profile/view.html.php:64811 CommunityViewProfile->profile() Copy JROOT/components/com_community/views/views.php:25110 CommunityView->get() Copy JROOT/components/com_community/controllers/profile.php:14549 CommunityProfileController->profile() Copy JROOT/components/com_community/controllers/profile.php:12028 CommunityProfileController->display() Copy JROOT/components/com_community/controllers/controller.php:3317 CommunityBaseController->execute() Copy JROOT/components/com_community/community.php:1456 require_once Copy JROOT/components/com_community/community.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
查询时间:1.01 ms 上次查询后:0.06 ms 查询内存:0.025 MB 查询前内存:20.169 MB 返回的行数:0
SELECT m.* ,n.`name` FROM `joom_community_blocklist ` m LEFT JOIN `joom_users ` n ON m.`blocked_userid`= n.`id` WHERE m.`userid`= '0' AND m.`blocked_userid`!= 0id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL ref blocked_userid,userid userid 4 const 1 100.00 Using where 1 SIMPLE n NULL eq_ref PRIMARY PRIMARY 4 root_db.m.blocked_userid 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 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() Copy JROOT/libraries/joomla/database/driver.php:172118 JDatabaseDriver->loadObjectList() Copy JROOT/components/com_community/models/block.php:13317 CommunityModelBlock->getBlockedList() Copy JROOT/components/com_community/libraries/user.php:135116 CUser->getBlockedUsers() Copy JROOT/components/com_community/libraries/activities.php:41115 CActivities->_getData() Copy JROOT/components/com_community/libraries/activities.php:109514 CActivities->getHTML() Copy JROOT/components/com_community/libraries/activities.php:148113 CActivities::getActivitiesByFilter() Copy JROOT/components/com_community/views/profile/view.html.php:32512 CommunityViewProfile->_getNewsfeedHTML() Copy JROOT/components/com_community/views/profile/view.html.php:64811 CommunityViewProfile->profile() Copy JROOT/components/com_community/views/views.php:25110 CommunityView->get() Copy JROOT/components/com_community/controllers/profile.php:14549 CommunityProfileController->profile() Copy JROOT/components/com_community/controllers/profile.php:12028 CommunityProfileController->display() Copy JROOT/components/com_community/controllers/controller.php:3317 CommunityBaseController->execute() Copy JROOT/components/com_community/community.php:1456 require_once Copy JROOT/components/com_community/community.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
查询时间:1.01 ms 上次查询后:1.23 ms 查询内存:0.025 MB 查询前内存:20.291 MB 返回的行数:0
SELECT `id` FROM `joom_users ` WHERE `block`= '1'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE joom_users NULL ref idx_block idx_block 1 const 1 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.03 ms sending cached result to clien 0.03 ms cleaned up 0.01 ms cleaning up 0.00 ms
# 呼叫者 文件和行号 19 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:157018 JDatabaseDriver->loadColumn() Copy JROOT/components/com_community/models/user.php:77017 CommunityModelUser->getBannedUser() Copy JROOT/components/com_community/models/activities.php:29416 CommunityModelActivities->getActivities() Copy JROOT/components/com_community/libraries/activities.php:42615 CActivities->_getData() Copy JROOT/components/com_community/libraries/activities.php:109514 CActivities->getHTML() Copy JROOT/components/com_community/libraries/activities.php:148113 CActivities::getActivitiesByFilter() Copy JROOT/components/com_community/views/profile/view.html.php:32512 CommunityViewProfile->_getNewsfeedHTML() Copy JROOT/components/com_community/views/profile/view.html.php:64811 CommunityViewProfile->profile() Copy JROOT/components/com_community/views/views.php:25110 CommunityView->get() Copy JROOT/components/com_community/controllers/profile.php:14549 CommunityProfileController->profile() Copy JROOT/components/com_community/controllers/profile.php:12028 CommunityProfileController->display() Copy JROOT/components/com_community/controllers/controller.php:3317 CommunityBaseController->execute() Copy JROOT/components/com_community/community.php:1456 require_once Copy JROOT/components/com_community/community.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
查询时间:1.07 ms 上次查询后:2.09 ms 查询内存:0.025 MB 查询前内存:20.590 MB 返回的行数:0
SELECT DISTINCT a.`id` FROM `joom_community_events ` AS a LEFT JOIN `joom_community_events_members ` AS b ON a.`id`= b.`eventid` WHERE ( b.`status`= '1' OR b.`status`= '2' OR b.`status`= '3' ) AND b.memberid= '0'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL index PRIMARY,idx_catid,idx_creator,idx_period,idx_published,idx_type idx_catid 4 NULL 1 100.00 Using index; Using temporary 1 SIMPLE b NULL ref idx_eventid,idx_member_event,idx_permission,idx_status idx_eventid 4 root_db.a.id 1 100.00 Using where; Distinct
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 checking permissions 0.01 ms sending cached result to clien 0.03 ms cleaned up 0.01 ms cleaning up 0.00 ms
# 呼叫者 文件和行号 20 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:157019 JDatabaseDriver->loadColumn() Copy JROOT/components/com_community/models/events.php:52818 CommunityModelEvents->getEventIds() Copy JROOT/components/com_community/models/activities.php:57717 CommunityModelActivities->_buildQuery() Copy JROOT/components/com_community/models/activities.php:33716 CommunityModelActivities->getActivities() Copy JROOT/components/com_community/libraries/activities.php:42615 CActivities->_getData() Copy JROOT/components/com_community/libraries/activities.php:109514 CActivities->getHTML() Copy JROOT/components/com_community/libraries/activities.php:148113 CActivities::getActivitiesByFilter() Copy JROOT/components/com_community/views/profile/view.html.php:32512 CommunityViewProfile->_getNewsfeedHTML() Copy JROOT/components/com_community/views/profile/view.html.php:64811 CommunityViewProfile->profile() Copy JROOT/components/com_community/views/views.php:25110 CommunityView->get() Copy JROOT/components/com_community/controllers/profile.php:14549 CommunityProfileController->profile() Copy JROOT/components/com_community/controllers/profile.php:12028 CommunityProfileController->display() Copy JROOT/components/com_community/controllers/controller.php:3317 CommunityBaseController->execute() Copy JROOT/components/com_community/community.php:1456 require_once Copy JROOT/components/com_community/community.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
查询时间:0.98 ms 上次查询后:0.02 ms 查询内存:0.025 MB 查询前内存:20.599 MB 返回的行数:0
SELECT `id` FROM `joom_community_groups ` WHERE `approvals` = 0id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE joom_community_groups NULL ALL NULL 不能使用任何索引键 NULL NULL 1 100.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.02 ms
# 呼叫者 文件和行号 20 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:157019 JDatabaseDriver->loadColumn() Copy JROOT/components/com_community/models/activities.php:80718 CommunityModelActivities->_getGroups() Copy JROOT/components/com_community/models/activities.php:62217 CommunityModelActivities->_buildQuery() Copy JROOT/components/com_community/models/activities.php:33716 CommunityModelActivities->getActivities() Copy JROOT/components/com_community/libraries/activities.php:42615 CActivities->_getData() Copy JROOT/components/com_community/libraries/activities.php:109514 CActivities->getHTML() Copy JROOT/components/com_community/libraries/activities.php:148113 CActivities::getActivitiesByFilter() Copy JROOT/components/com_community/views/profile/view.html.php:32512 CommunityViewProfile->_getNewsfeedHTML() Copy JROOT/components/com_community/views/profile/view.html.php:64811 CommunityViewProfile->profile() Copy JROOT/components/com_community/views/views.php:25110 CommunityView->get() Copy JROOT/components/com_community/controllers/profile.php:14549 CommunityProfileController->profile() Copy JROOT/components/com_community/controllers/profile.php:12028 CommunityProfileController->display() Copy JROOT/components/com_community/controllers/controller.php:3317 CommunityBaseController->execute() Copy JROOT/components/com_community/community.php:1456 require_once Copy JROOT/components/com_community/community.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
查询时间:0.92 ms 上次查询后:0.02 ms 查询内存:0.025 MB 查询前内存:20.609 MB 返回的行数:0
SELECT `groupid` FROM `joom_community_groups_members ` WHERE `approved` = 1 AND `memberid` = 0 GROUP BY `groupid`id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE joom_community_groups_members NULL ref PRIMARY,groupid,idx_memberid idx_memberid 4 const 1 100.00 Using index condition; 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() Copy JROOT/libraries/joomla/database/driver.php:157019 JDatabaseDriver->loadColumn() Copy JROOT/components/com_community/models/activities.php:81418 CommunityModelActivities->_getGroups() Copy JROOT/components/com_community/models/activities.php:62217 CommunityModelActivities->_buildQuery() Copy JROOT/components/com_community/models/activities.php:33716 CommunityModelActivities->getActivities() Copy JROOT/components/com_community/libraries/activities.php:42615 CActivities->_getData() Copy JROOT/components/com_community/libraries/activities.php:109514 CActivities->getHTML() Copy JROOT/components/com_community/libraries/activities.php:148113 CActivities::getActivitiesByFilter() Copy JROOT/components/com_community/views/profile/view.html.php:32512 CommunityViewProfile->_getNewsfeedHTML() Copy JROOT/components/com_community/views/profile/view.html.php:64811 CommunityViewProfile->profile() Copy JROOT/components/com_community/views/views.php:25110 CommunityView->get() Copy JROOT/components/com_community/controllers/profile.php:14549 CommunityProfileController->profile() Copy JROOT/components/com_community/controllers/profile.php:12028 CommunityProfileController->display() Copy JROOT/components/com_community/controllers/controller.php:3317 CommunityBaseController->execute() Copy JROOT/components/com_community/community.php:1456 require_once Copy JROOT/components/com_community/community.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
查询时间:0.98 ms 上次查询后:0.02 ms 查询内存:0.025 MB 查询前内存:20.618 MB 返回的行数:0
SELECT `id` FROM `joom_community_videos ` WHERE `published` = 0id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE joom_community_videos NULL ALL NULL 不能使用任何索引键 NULL NULL 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.01 ms sending cached result to clien 0.02 ms cleaned up 0.01 ms cleaning up 0.00 ms
# 呼叫者 文件和行号 20 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:157019 JDatabaseDriver->loadColumn() Copy JROOT/components/com_community/models/activities.php:83418 CommunityModelActivities->_getUnpublishedVideos() Copy JROOT/components/com_community/models/activities.php:63317 CommunityModelActivities->_buildQuery() Copy JROOT/components/com_community/models/activities.php:33716 CommunityModelActivities->getActivities() Copy JROOT/components/com_community/libraries/activities.php:42615 CActivities->_getData() Copy JROOT/components/com_community/libraries/activities.php:109514 CActivities->getHTML() Copy JROOT/components/com_community/libraries/activities.php:148113 CActivities::getActivitiesByFilter() Copy JROOT/components/com_community/views/profile/view.html.php:32512 CommunityViewProfile->_getNewsfeedHTML() Copy JROOT/components/com_community/views/profile/view.html.php:64811 CommunityViewProfile->profile() Copy JROOT/components/com_community/views/views.php:25110 CommunityView->get() Copy JROOT/components/com_community/controllers/profile.php:14549 CommunityProfileController->profile() Copy JROOT/components/com_community/controllers/profile.php:12028 CommunityProfileController->display() Copy JROOT/components/com_community/controllers/controller.php:3317 CommunityBaseController->execute() Copy JROOT/components/com_community/community.php:1456 require_once Copy JROOT/components/com_community/community.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
查询时间:0.92 ms 上次查询后:0.02 ms 查询内存:0.025 MB 查询前内存:20.628 MB 返回的行数:1
SELECT GROUP_CONCAT (DISTINCT b.`activity_id`) as activity_id FROM `joom_community_activities_hide ` as b WHERE b.`user_id` = '0'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE b NULL ref user_id user_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.01 ms cleaned up 0.01 ms cleaning up 0.00 ms
# 呼叫者 文件和行号 19 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:157018 JDatabaseDriver->loadColumn() Copy JROOT/components/com_community/models/activities.php:67317 CommunityModelActivities->_buildQuery() Copy JROOT/components/com_community/models/activities.php:33716 CommunityModelActivities->getActivities() Copy JROOT/components/com_community/libraries/activities.php:42615 CActivities->_getData() Copy JROOT/components/com_community/libraries/activities.php:109514 CActivities->getHTML() Copy JROOT/components/com_community/libraries/activities.php:148113 CActivities::getActivitiesByFilter() Copy JROOT/components/com_community/views/profile/view.html.php:32512 CommunityViewProfile->_getNewsfeedHTML() Copy JROOT/components/com_community/views/profile/view.html.php:64811 CommunityViewProfile->profile() Copy JROOT/components/com_community/views/views.php:25110 CommunityView->get() Copy JROOT/components/com_community/controllers/profile.php:14549 CommunityProfileController->profile() Copy JROOT/components/com_community/controllers/profile.php:12028 CommunityProfileController->display() Copy JROOT/components/com_community/controllers/controller.php:3317 CommunityBaseController->execute() Copy JROOT/components/com_community/community.php:1456 require_once Copy JROOT/components/com_community/community.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
查询时间:1.06 ms 上次查询后:4.46 ms 查询内存:0.030 MB 查询前内存:20.647 MB 返回的行数:0
SELECT cid FROM `joom_community_featured ` WHERE target_id= 1621330 AND type= 'stream.profile'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE joom_community_featured NULL ref type type 767 const 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.03 ms sending cached result to clien 0.04 ms cleaned up 0.03 ms cleaning up 0.01 ms
# 呼叫者 文件和行号 19 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:157018 JDatabaseDriver->loadColumn() Copy JROOT/components/com_community/models/activities.php:75317 CommunityModelActivities->_buildQuery() Copy JROOT/components/com_community/models/activities.php:33716 CommunityModelActivities->getActivities() Copy JROOT/components/com_community/libraries/activities.php:42615 CActivities->_getData() Copy JROOT/components/com_community/libraries/activities.php:109514 CActivities->getHTML() Copy JROOT/components/com_community/libraries/activities.php:148113 CActivities::getActivitiesByFilter() Copy JROOT/components/com_community/views/profile/view.html.php:32512 CommunityViewProfile->_getNewsfeedHTML() Copy JROOT/components/com_community/views/profile/view.html.php:64811 CommunityViewProfile->profile() Copy JROOT/components/com_community/views/views.php:25110 CommunityView->get() Copy JROOT/components/com_community/controllers/profile.php:14549 CommunityProfileController->profile() Copy JROOT/components/com_community/controllers/profile.php:12028 CommunityProfileController->display() Copy JROOT/components/com_community/controllers/controller.php:3317 CommunityBaseController->execute() Copy JROOT/components/com_community/community.php:1456 require_once Copy JROOT/components/com_community/community.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
查询时间:1.01 ms 上次查询后:0.08 ms 查询内存:0.024 MB 查询前内存:20.658 MB 返回的行数:0
SELECT a.* FROM `joom_community_activities ` as a LEFT JOIN `joom_kunena_topics ` as b ON (a.cid = b.id AND a.app = 'kunena.thread.post') LEFT JOIN `joom_kunena_categories ` as c ON (b.category_id = c.id AND a.app = 'kunena.thread.post') WHERE (c.published = 1 OR c.published IS NULL ) AND ( (a.`actor`= '1621330') OR (
(a.`actor`= '0') AND
(a.`actors` LIKE '%{"id":"1621330"}%')
) OR (a.`actor` IN (1621330)) OR (a.`target` IN (1621330)) OR (a.`target`= '1621330') ) AND ( 1 AND (( a.`actor` <> '1621330' AND a.target <> a.actor) OR a.target = 1621330 OR a.target = 0 OR (a.`actor` IN (1621330)) ) AND ( (a.`group_access`= '0') OR (a.`groupid` IN ('' ) ) OR (a.`groupid`= '0')) AND (a.`event_access`= '0') AND (a.`access` <= 10) ) AND a.`archived` = 0 GROUP BY a.`id` ORDER BY a. `id` DESC LIMIT 20id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL index PRIMARY,actor,app,archived,created,target PRIMARY 4 NULL 10 10.00 Using where 1 SIMPLE b NULL eq_ref PRIMARY PRIMARY 4 root_db.a.cid 1 100.00 Using where 1 SIMPLE c NULL eq_ref PRIMARY PRIMARY 4 root_db.b.category_id 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.02 ms checking permissions 0.01 ms checking permissions 0.01 ms sending cached result to clien 0.03 ms cleaned up 0.01 ms cleaning up 0.00 ms
# 呼叫者 文件和行号 18 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172117 JDatabaseDriver->loadObjectList() Copy JROOT/components/com_community/models/activities.php:34316 CommunityModelActivities->getActivities() Copy JROOT/components/com_community/libraries/activities.php:42615 CActivities->_getData() Copy JROOT/components/com_community/libraries/activities.php:109514 CActivities->getHTML() Copy JROOT/components/com_community/libraries/activities.php:148113 CActivities::getActivitiesByFilter() Copy JROOT/components/com_community/views/profile/view.html.php:32512 CommunityViewProfile->_getNewsfeedHTML() Copy JROOT/components/com_community/views/profile/view.html.php:64811 CommunityViewProfile->profile() Copy JROOT/components/com_community/views/views.php:25110 CommunityView->get() Copy JROOT/components/com_community/controllers/profile.php:14549 CommunityProfileController->profile() Copy JROOT/components/com_community/controllers/profile.php:12028 CommunityProfileController->display() Copy JROOT/components/com_community/controllers/controller.php:3317 CommunityBaseController->execute() Copy JROOT/components/com_community/community.php:1456 require_once Copy JROOT/components/com_community/community.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
查询时间:0.95 ms 上次查询后:0.06 ms 查询内存:0.024 MB 查询前内存:20.665 MB 返回的行数:1
SELECT COUNT (1) FROM `joom_community_activities ` WHERE 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE joom_community_activities NULL index NULL archived 1 NULL 10 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.01 ms sending cached result to clien 0.01 ms cleaned up 0.01 ms cleaning up 0.00 ms
# 呼叫者 文件和行号 17 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:176016 JDatabaseDriver->loadResult() Copy JROOT/components/com_community/models/activities.php:151815 CommunityModelActivities->getTotalActivities() Copy JROOT/components/com_community/libraries/activities.php:110414 CActivities->getHTML() Copy JROOT/components/com_community/libraries/activities.php:148113 CActivities::getActivitiesByFilter() Copy JROOT/components/com_community/views/profile/view.html.php:32512 CommunityViewProfile->_getNewsfeedHTML() Copy JROOT/components/com_community/views/profile/view.html.php:64811 CommunityViewProfile->profile() Copy JROOT/components/com_community/views/views.php:25110 CommunityView->get() Copy JROOT/components/com_community/controllers/profile.php:14549 CommunityProfileController->profile() Copy JROOT/components/com_community/controllers/profile.php:12028 CommunityProfileController->display() Copy JROOT/components/com_community/controllers/controller.php:3317 CommunityBaseController->execute() Copy JROOT/components/com_community/community.php:1456 require_once Copy JROOT/components/com_community/community.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
查询时间:1.34 ms 上次查询后:5.50 ms 查询内存:0.025 MB 查询前内存:21.239 MB 返回的行数:1
SELECT extension_id FROM joom_extensions WHERE element = 'com_adagency' AND type= 'component'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 element_clientid 402 const 1 10.00 Using where
Status Duration starting 0.03 ms checking query cache for query 0.07 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.03 ms storing result in query cache 0.01 ms cleaned up 0.01 ms cleaning up 0.00 ms
# 呼叫者 文件和行号 19 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:176018 JDatabaseDriver->loadResult() Copy JROOT/components/com_community/helpers/system.php:2317 CSystemHelper::isComponentExists() Copy JROOT/components/com_community/templates/jomsocial/layouts/stream/base.php:34816 require Copy JROOT/components/com_community/templates/jomsocial/layouts/stream/base.php Copy JROOT/components/com_community/libraries/template.php:24015 CTemplate->fetch() Copy JROOT/components/com_community/libraries/activities.php:116714 CActivities->getHTML() Copy JROOT/components/com_community/libraries/activities.php:148113 CActivities::getActivitiesByFilter() Copy JROOT/components/com_community/views/profile/view.html.php:32512 CommunityViewProfile->_getNewsfeedHTML() Copy JROOT/components/com_community/views/profile/view.html.php:64811 CommunityViewProfile->profile() Copy JROOT/components/com_community/views/views.php:25110 CommunityView->get() Copy JROOT/components/com_community/controllers/profile.php:14549 CommunityProfileController->profile() Copy JROOT/components/com_community/controllers/profile.php:12028 CommunityProfileController->display() Copy JROOT/components/com_community/controllers/controller.php:3317 CommunityBaseController->execute() Copy JROOT/components/com_community/community.php:1456 require_once Copy JROOT/components/com_community/community.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
查询时间:1.04 ms 上次查询后:8.53 ms 查询内存:0.025 MB 查询前内存:21.271 MB 返回的行数:0
SELECT `id` FROM `joom_users ` WHERE `block`= '1'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE joom_users NULL ref idx_block idx_block 1 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.02 ms sending cached result to clien 0.03 ms cleaned up 0.01 ms cleaning up 0.00 ms
# 呼叫者 文件和行号 19 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:157018 JDatabaseDriver->loadColumn() Copy JROOT/components/com_community/models/user.php:77017 CommunityModelUser->getBannedUser() Copy JROOT/components/com_community/models/activities.php:29416 CommunityModelActivities->getActivities() Copy JROOT/components/com_community/libraries/activities.php:42615 CActivities->_getData() Copy JROOT/components/com_community/libraries/activities.php:109514 CActivities->getHTML() Copy JROOT/components/com_community/libraries/activities.php:148113 CActivities::getActivitiesByFilter() Copy JROOT/components/com_community/views/profile/view.html.php:32512 CommunityViewProfile->_getNewsfeedHTML() Copy JROOT/components/com_community/views/profile/view.html.php:78911 CommunityViewProfile->profile() Copy JROOT/components/com_community/views/views.php:25110 CommunityView->get() Copy JROOT/components/com_community/controllers/profile.php:14549 CommunityProfileController->profile() Copy JROOT/components/com_community/controllers/profile.php:12028 CommunityProfileController->display() Copy JROOT/components/com_community/controllers/controller.php:3317 CommunityBaseController->execute() Copy JROOT/components/com_community/community.php:1456 require_once Copy JROOT/components/com_community/community.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
查询时间:0.93 ms 上次查询后:0.05 ms 查询内存:0.025 MB 查询前内存:21.284 MB 返回的行数:0
SELECT DISTINCT a.`id` FROM `joom_community_events ` AS a LEFT JOIN `joom_community_events_members ` AS b ON a.`id`= b.`eventid` WHERE ( b.`status`= '1' OR b.`status`= '2' OR b.`status`= '3' ) AND b.memberid= '0'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL index PRIMARY,idx_catid,idx_creator,idx_period,idx_published,idx_type idx_catid 4 NULL 1 100.00 Using index; Using temporary 1 SIMPLE b NULL ref idx_eventid,idx_member_event,idx_permission,idx_status idx_eventid 4 root_db.a.id 1 100.00 Using where; Distinct
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.01 ms cleaned up 0.01 ms cleaning up 0.00 ms
# 呼叫者 文件和行号 20 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:157019 JDatabaseDriver->loadColumn() Copy JROOT/components/com_community/models/events.php:52818 CommunityModelEvents->getEventIds() Copy JROOT/components/com_community/models/activities.php:57717 CommunityModelActivities->_buildQuery() Copy JROOT/components/com_community/models/activities.php:33716 CommunityModelActivities->getActivities() Copy JROOT/components/com_community/libraries/activities.php:42615 CActivities->_getData() Copy JROOT/components/com_community/libraries/activities.php:109514 CActivities->getHTML() Copy JROOT/components/com_community/libraries/activities.php:148113 CActivities::getActivitiesByFilter() Copy JROOT/components/com_community/views/profile/view.html.php:32512 CommunityViewProfile->_getNewsfeedHTML() Copy JROOT/components/com_community/views/profile/view.html.php:78911 CommunityViewProfile->profile() Copy JROOT/components/com_community/views/views.php:25110 CommunityView->get() Copy JROOT/components/com_community/controllers/profile.php:14549 CommunityProfileController->profile() Copy JROOT/components/com_community/controllers/profile.php:12028 CommunityProfileController->display() Copy JROOT/components/com_community/controllers/controller.php:3317 CommunityBaseController->execute() Copy JROOT/components/com_community/community.php:1456 require_once Copy JROOT/components/com_community/community.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
查询时间:0.94 ms 上次查询后:0.02 ms 查询内存:0.025 MB 查询前内存:21.293 MB 返回的行数:0
SELECT `id` FROM `joom_community_videos ` WHERE `published` = 0id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE joom_community_videos NULL ALL NULL 不能使用任何索引键 NULL NULL 1 100.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
# 呼叫者 文件和行号 20 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:157019 JDatabaseDriver->loadColumn() Copy JROOT/components/com_community/models/activities.php:83418 CommunityModelActivities->_getUnpublishedVideos() Copy JROOT/components/com_community/models/activities.php:63317 CommunityModelActivities->_buildQuery() Copy JROOT/components/com_community/models/activities.php:33716 CommunityModelActivities->getActivities() Copy JROOT/components/com_community/libraries/activities.php:42615 CActivities->_getData() Copy JROOT/components/com_community/libraries/activities.php:109514 CActivities->getHTML() Copy JROOT/components/com_community/libraries/activities.php:148113 CActivities::getActivitiesByFilter() Copy JROOT/components/com_community/views/profile/view.html.php:32512 CommunityViewProfile->_getNewsfeedHTML() Copy JROOT/components/com_community/views/profile/view.html.php:78911 CommunityViewProfile->profile() Copy JROOT/components/com_community/views/views.php:25110 CommunityView->get() Copy JROOT/components/com_community/controllers/profile.php:14549 CommunityProfileController->profile() Copy JROOT/components/com_community/controllers/profile.php:12028 CommunityProfileController->display() Copy JROOT/components/com_community/controllers/controller.php:3317 CommunityBaseController->execute() Copy JROOT/components/com_community/community.php:1456 require_once Copy JROOT/components/com_community/community.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
查询时间:0.94 ms 上次查询后:0.02 ms 查询内存:0.025 MB 查询前内存:21.303 MB 返回的行数:1
SELECT GROUP_CONCAT (DISTINCT b.`activity_id`) as activity_id FROM `joom_community_activities_hide ` as b WHERE b.`user_id` = '0'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE b NULL ref user_id user_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.01 ms cleaned up 0.01 ms cleaning up 0.00 ms
# 呼叫者 文件和行号 19 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:157018 JDatabaseDriver->loadColumn() Copy JROOT/components/com_community/models/activities.php:67317 CommunityModelActivities->_buildQuery() Copy JROOT/components/com_community/models/activities.php:33716 CommunityModelActivities->getActivities() Copy JROOT/components/com_community/libraries/activities.php:42615 CActivities->_getData() Copy JROOT/components/com_community/libraries/activities.php:109514 CActivities->getHTML() Copy JROOT/components/com_community/libraries/activities.php:148113 CActivities::getActivitiesByFilter() Copy JROOT/components/com_community/views/profile/view.html.php:32512 CommunityViewProfile->_getNewsfeedHTML() Copy JROOT/components/com_community/views/profile/view.html.php:78911 CommunityViewProfile->profile() Copy JROOT/components/com_community/views/views.php:25110 CommunityView->get() Copy JROOT/components/com_community/controllers/profile.php:14549 CommunityProfileController->profile() Copy JROOT/components/com_community/controllers/profile.php:12028 CommunityProfileController->display() Copy JROOT/components/com_community/controllers/controller.php:3317 CommunityBaseController->execute() Copy JROOT/components/com_community/community.php:1456 require_once Copy JROOT/components/com_community/community.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
查询时间:1.06 ms 上次查询后:4.40 ms 查询内存:0.025 MB 查询前内存:21.313 MB 返回的行数:0
SELECT cid FROM `joom_community_featured ` WHERE target_id= 1621330 AND type= 'stream.profile'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE joom_community_featured NULL ref type type 767 const 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
# 呼叫者 文件和行号 19 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:157018 JDatabaseDriver->loadColumn() Copy JROOT/components/com_community/models/activities.php:75317 CommunityModelActivities->_buildQuery() Copy JROOT/components/com_community/models/activities.php:33716 CommunityModelActivities->getActivities() Copy JROOT/components/com_community/libraries/activities.php:42615 CActivities->_getData() Copy JROOT/components/com_community/libraries/activities.php:109514 CActivities->getHTML() Copy JROOT/components/com_community/libraries/activities.php:148113 CActivities::getActivitiesByFilter() Copy JROOT/components/com_community/views/profile/view.html.php:32512 CommunityViewProfile->_getNewsfeedHTML() Copy JROOT/components/com_community/views/profile/view.html.php:78911 CommunityViewProfile->profile() Copy JROOT/components/com_community/views/views.php:25110 CommunityView->get() Copy JROOT/components/com_community/controllers/profile.php:14549 CommunityProfileController->profile() Copy JROOT/components/com_community/controllers/profile.php:12028 CommunityProfileController->display() Copy JROOT/components/com_community/controllers/controller.php:3317 CommunityBaseController->execute() Copy JROOT/components/com_community/community.php:1456 require_once Copy JROOT/components/com_community/community.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
查询时间:1.02 ms 上次查询后:0.06 ms 查询内存:0.024 MB 查询前内存:21.319 MB 返回的行数:0
SELECT a.* FROM `joom_community_activities ` as a LEFT JOIN `joom_kunena_topics ` as b ON (a.cid = b.id AND a.app = 'kunena.thread.post') LEFT JOIN `joom_kunena_categories ` as c ON (b.category_id = c.id AND a.app = 'kunena.thread.post') WHERE (c.published = 1 OR c.published IS NULL ) AND ( (a.`actor`= '1621330') OR (
(a.`actor`= '0') AND
(a.`actors` LIKE '%{"id":"1621330"}%')
) OR (a.`actor` IN (1621330)) OR (a.`target` IN (1621330)) OR (a.`target`= '1621330') ) AND ( 1 AND (( a.`actor` <> '1621330' AND a.target <> a.actor) OR a.target = 1621330 OR a.target = 0 OR (a.`actor` IN (1621330)) ) AND ( (a.`group_access`= '0') OR (a.`groupid` IN ('' ) ) OR (a.`groupid`= '0')) AND (a.`event_access`= '0') AND (a.`access` <= 10) ) AND a.`archived` = 0 GROUP BY a.`id` ORDER BY a. `id` DESC LIMIT 20id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL index PRIMARY,actor,app,archived,created,target PRIMARY 4 NULL 10 10.00 Using where 1 SIMPLE b NULL eq_ref PRIMARY PRIMARY 4 root_db.a.cid 1 100.00 Using where 1 SIMPLE c NULL eq_ref PRIMARY PRIMARY 4 root_db.b.category_id 1 100.00 Using where
Status Duration starting 0.02 ms checking query cache for query 0.02 ms checking privileges on cached 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms sending cached result to clien 0.04 ms cleaned up 0.01 ms cleaning up 0.00 ms
# 呼叫者 文件和行号 18 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172117 JDatabaseDriver->loadObjectList() Copy JROOT/components/com_community/models/activities.php:34316 CommunityModelActivities->getActivities() Copy JROOT/components/com_community/libraries/activities.php:42615 CActivities->_getData() Copy JROOT/components/com_community/libraries/activities.php:109514 CActivities->getHTML() Copy JROOT/components/com_community/libraries/activities.php:148113 CActivities::getActivitiesByFilter() Copy JROOT/components/com_community/views/profile/view.html.php:32512 CommunityViewProfile->_getNewsfeedHTML() Copy JROOT/components/com_community/views/profile/view.html.php:78911 CommunityViewProfile->profile() Copy JROOT/components/com_community/views/views.php:25110 CommunityView->get() Copy JROOT/components/com_community/controllers/profile.php:14549 CommunityProfileController->profile() Copy JROOT/components/com_community/controllers/profile.php:12028 CommunityProfileController->display() Copy JROOT/components/com_community/controllers/controller.php:3317 CommunityBaseController->execute() Copy JROOT/components/com_community/community.php:1456 require_once Copy JROOT/components/com_community/community.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
查询时间:1.00 ms 上次查询后:0.46 ms 查询内存:0.025 MB 查询前内存:21.382 MB 返回的行数:1
SELECT extension_id FROM joom_extensions WHERE element = 'com_adagency' AND type= 'component'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 element_clientid 402 const 1 10.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.01 ms sending cached result to clien 0.02 ms cleaned up 0.01 ms cleaning up 0.00 ms
# 呼叫者 文件和行号 19 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:176018 JDatabaseDriver->loadResult() Copy JROOT/components/com_community/helpers/system.php:2317 CSystemHelper::isComponentExists() Copy JROOT/components/com_community/templates/jomsocial/layouts/stream/base.php:34816 require Copy JROOT/components/com_community/templates/jomsocial/layouts/stream/base.php Copy JROOT/components/com_community/libraries/template.php:24015 CTemplate->fetch() Copy JROOT/components/com_community/libraries/activities.php:116714 CActivities->getHTML() Copy JROOT/components/com_community/libraries/activities.php:148113 CActivities::getActivitiesByFilter() Copy JROOT/components/com_community/views/profile/view.html.php:32512 CommunityViewProfile->_getNewsfeedHTML() Copy JROOT/components/com_community/views/profile/view.html.php:78911 CommunityViewProfile->profile() Copy JROOT/components/com_community/views/views.php:25110 CommunityView->get() Copy JROOT/components/com_community/controllers/profile.php:14549 CommunityProfileController->profile() Copy JROOT/components/com_community/controllers/profile.php:12028 CommunityProfileController->display() Copy JROOT/components/com_community/controllers/controller.php:3317 CommunityBaseController->execute() Copy JROOT/components/com_community/community.php:1456 require_once Copy JROOT/components/com_community/community.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
查询时间:2.76 ms 上次查询后:1.15 ms 查询内存:0.029 MB 查询前内存:21.442 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-08-08 08:37:49') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-08-08 08:37:49') AND m.access IN (1,1) AND m.client_id = 0 AND (mm.menuid = 711 OR mm.menuid <= 0) AND m.language IN ('zh-CN ','* ')
ORDER BY m.position, m.orderingid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL 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.15 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.02 ms Opening tables 0.03 ms init 0.07 ms System lock 0.04 ms optimizing 0.03 ms statistics 0.17 ms preparing 0.04 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.01 ms Creating sort index 1.04 ms end 0.02 ms query end 0.02 ms closing tables 0.01 ms freeing items 0.07 ms storing result in query cache 0.01 ms cleaned up 0.01 ms cleaning up 0.03 ms
# 呼叫者 文件和行号 20 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172119 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/joomla/cache/controller/callback.php:16918 JCacheControllerCallback->get() Copy JROOT/libraries/cms/module/helper.php:42417 JModuleHelper::getModuleList() Copy JROOT/libraries/cms/module/helper.php:36016 JModuleHelper::load() Copy JROOT/libraries/cms/module/helper.php:8415 JModuleHelper::getModules() Copy JROOT/components/com_community/libraries/template.php:37714 CTemplate::renderModules() Copy JROOT/components/com_community/templates/jomsocial/layouts/profile/base.php:2413 require Copy JROOT/components/com_community/templates/jomsocial/layouts/profile/base.php Copy JROOT/components/com_community/libraries/template.php:24012 CTemplate->fetch() Copy JROOT/components/com_community/views/profile/view.html.php:79611 CommunityViewProfile->profile() Copy JROOT/components/com_community/views/views.php:25110 CommunityView->get() Copy JROOT/components/com_community/controllers/profile.php:14549 CommunityProfileController->profile() Copy JROOT/components/com_community/controllers/profile.php:12028 CommunityProfileController->display() Copy JROOT/components/com_community/controllers/controller.php:3317 CommunityBaseController->execute() Copy JROOT/components/com_community/community.php:1456 require_once Copy JROOT/components/com_community/community.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
查询时间:1.10 ms 上次查询后:1.10 ms 查询内存:0.028 MB 查询前内存:21.458 MB 返回的行数:14
SELECT field.* , value.`value`,value.`access`, value.`params` as fieldparams FROM `joom_community_fields ` AS field LEFT JOIN `joom_community_fields_values ` AS value ON field.`id`= value.`field_id` AND value.`user_id`= '1621330' WHERE field.`published`= '1' AND field.`visible`>= '1' ORDER BY field.`ordering`id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE field NULL ALL NULL 不能使用任何索引键 NULL NULL 17 5.88 Using where; 使用文件排序 1 SIMPLE value NULL eq_ref unique_field_values,field_id,idx_user_fieldid,user_id unique_field_values 8 const,root_db.field.id 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.02 ms checking permissions 0.01 ms sending cached result to clien 0.04 ms cleaned up 0.01 ms cleaning up 0.00 ms
# 呼叫者 文件和行号 17 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:152616 JDatabaseDriver->loadAssocList() Copy JROOT/components/com_community/models/profile.php:29515 CommunityModelProfile->getViewableProfile() Copy JROOT/components/com_community/views/profile/view.html.php:165214 CommunityViewProfile->modProfileUserinfo() Copy JROOT/components/com_community/templates/jomsocial/layouts/profile/base.php:3313 require Copy JROOT/components/com_community/templates/jomsocial/layouts/profile/base.php Copy JROOT/components/com_community/libraries/template.php:24012 CTemplate->fetch() Copy JROOT/components/com_community/views/profile/view.html.php:79611 CommunityViewProfile->profile() Copy JROOT/components/com_community/views/views.php:25110 CommunityView->get() Copy JROOT/components/com_community/controllers/profile.php:14549 CommunityProfileController->profile() Copy JROOT/components/com_community/controllers/profile.php:12028 CommunityProfileController->display() Copy JROOT/components/com_community/controllers/controller.php:3317 CommunityBaseController->execute() Copy JROOT/components/com_community/community.php:1456 require_once Copy JROOT/components/com_community/community.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
查询时间:1.09 ms 上次查询后:5.64 ms 查询内存:0.024 MB 查询前内存:21.891 MB 返回的行数:1
SELECT count(* ) FROM `joom_community_connection ` as a, `joom_users ` as b WHERE a.`connect_to`= '0' AND a.`status`= '0' AND a.`connect_from`= b.`id` ORDER BY a.`connection_id` DESC id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL ref connect_from,idx_connect_from,idx_connect_to,idx_connect_tofrom idx_connect_to 4 const 1 100.00 Using where 1 SIMPLE b NULL eq_ref PRIMARY PRIMARY 4 root_db.a.connect_from 1 100.00 Using index
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 checking permissions 0.01 ms sending cached result to clien 0.03 ms cleaned up 0.02 ms cleaning up 0.00 ms
# 呼叫者 文件和行号 17 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:176016 JDatabaseDriver->loadResult() Copy JROOT/components/com_community/models/friends.php:75515 CommunityModelFriends->countPending() Copy JROOT/components/com_community/views/profile/view.html.php:167314 CommunityViewProfile->modProfileUserinfo() Copy JROOT/components/com_community/templates/jomsocial/layouts/profile/base.php:3313 require Copy JROOT/components/com_community/templates/jomsocial/layouts/profile/base.php Copy JROOT/components/com_community/libraries/template.php:24012 CTemplate->fetch() Copy JROOT/components/com_community/views/profile/view.html.php:79611 CommunityViewProfile->profile() Copy JROOT/components/com_community/views/views.php:25110 CommunityView->get() Copy JROOT/components/com_community/controllers/profile.php:14549 CommunityProfileController->profile() Copy JROOT/components/com_community/controllers/profile.php:12028 CommunityProfileController->display() Copy JROOT/components/com_community/controllers/controller.php:3317 CommunityBaseController->execute() Copy JROOT/components/com_community/community.php:1456 require_once Copy JROOT/components/com_community/community.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
查询时间:1.52 ms 上次查询后:2.36 ms 查询内存:0.029 MB 查询前内存:22.151 MB 返回的行数:17
SHOW FULL COLUMNS FROM `joom_community_photos_albums `查询时无法解释:SHOW FULL COLUMNS FROM `joom_community_photos_albums`
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 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.02 ms
# 呼叫者 文件和行号 21 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172120 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/joomla/database/driver/mysqli.php:42119 JDatabaseDriverMysqli->getTableColumns() Copy JROOT/libraries/joomla/table/table.php:24418 JTable->getFields() Copy JROOT/libraries/joomla/table/table.php:16317 JTable->__construct() Copy JROOT/components/com_community/tables/album.php:3916 CTableAlbum->__construct() Copy JROOT/libraries/joomla/table/table.php:31115 JTable::getInstance() Copy JROOT/components/com_community/views/profile/view.html.php:168214 CommunityViewProfile->modProfileUserinfo() Copy JROOT/components/com_community/templates/jomsocial/layouts/profile/base.php:3313 require Copy JROOT/components/com_community/templates/jomsocial/layouts/profile/base.php Copy JROOT/components/com_community/libraries/template.php:24012 CTemplate->fetch() Copy JROOT/components/com_community/views/profile/view.html.php:79611 CommunityViewProfile->profile() Copy JROOT/components/com_community/views/views.php:25110 CommunityView->get() Copy JROOT/components/com_community/controllers/profile.php:14549 CommunityProfileController->profile() Copy JROOT/components/com_community/controllers/profile.php:12028 CommunityProfileController->display() Copy JROOT/components/com_community/controllers/controller.php:3317 CommunityBaseController->execute() Copy JROOT/components/com_community/community.php:1456 require_once Copy JROOT/components/com_community/community.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
查询时间:1.02 ms 上次查询后:0.07 ms 查询内存:0.024 MB 查询前内存:22.179 MB 返回的行数:0
SELECT `id` FROM `joom_community_photos_albums ` WHERE `creator` = '1621330' AND `type` = 'profile.avatar'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE joom_community_photos_albums NULL ref creator,idx_creatortype,idx_type creator 4 const 1 50.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.02 ms sending cached result to clien 0.03 ms cleaned up 0.01 ms cleaning up 0.00 ms
# 呼叫者 文件和行号 17 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:176016 JDatabaseDriver->loadResult() Copy JROOT/components/com_community/tables/album.php:69015 CTableAlbum->isAvatarAlbumExists() Copy JROOT/components/com_community/views/profile/view.html.php:168314 CommunityViewProfile->modProfileUserinfo() Copy JROOT/components/com_community/templates/jomsocial/layouts/profile/base.php:3313 require Copy JROOT/components/com_community/templates/jomsocial/layouts/profile/base.php Copy JROOT/components/com_community/libraries/template.php:24012 CTemplate->fetch() Copy JROOT/components/com_community/views/profile/view.html.php:79611 CommunityViewProfile->profile() Copy JROOT/components/com_community/views/views.php:25110 CommunityView->get() Copy JROOT/components/com_community/controllers/profile.php:14549 CommunityProfileController->profile() Copy JROOT/components/com_community/controllers/profile.php:12028 CommunityProfileController->display() Copy JROOT/components/com_community/controllers/controller.php:3317 CommunityBaseController->execute() Copy JROOT/components/com_community/community.php:1456 require_once Copy JROOT/components/com_community/community.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
查询时间:1.45 ms 上次查询后:0.68 ms 查询内存:0.025 MB 查询前内存:22.214 MB 返回的行数:1
SELECT * from `joom_community_users ` WHERE `userid`= '1621330' AND (`status_access` <= 10) ORDER BY `posted_on` DESC LIMIT 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE joom_community_users 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.01 ms checking permissions 0.10 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.04 ms System lock 0.02 ms optimizing 0.02 ms statistics 0.06 ms preparing 0.04 ms executing 0.01 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.01 ms
# 呼叫者 文件和行号 18 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172117 JDatabaseDriver->loadObjectList() Copy JROOT/components/com_community/models/status.php:10616 CommunityModelStatus->get() Copy JROOT/components/com_community/libraries/user.php:47015 CUser->getStatus() Copy JROOT/components/com_community/views/profile/view.html.php:169014 CommunityViewProfile->modProfileUserinfo() Copy JROOT/components/com_community/templates/jomsocial/layouts/profile/base.php:3313 require Copy JROOT/components/com_community/templates/jomsocial/layouts/profile/base.php Copy JROOT/components/com_community/libraries/template.php:24012 CTemplate->fetch() Copy JROOT/components/com_community/views/profile/view.html.php:79611 CommunityViewProfile->profile() Copy JROOT/components/com_community/views/views.php:25110 CommunityView->get() Copy JROOT/components/com_community/controllers/profile.php:14549 CommunityProfileController->profile() Copy JROOT/components/com_community/controllers/profile.php:12028 CommunityProfileController->display() Copy JROOT/components/com_community/controllers/controller.php:3317 CommunityBaseController->execute() Copy JROOT/components/com_community/community.php:1456 require_once Copy JROOT/components/com_community/community.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
查询时间:1.05 ms 上次查询后:1.81 ms 查询内存:0.034 MB 查询前内存:22.291 MB 返回的行数:44
SELECT * FROM `joom_community_moods ` ORDER BY `ordering` ASC id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE joom_community_moods NULL ALL NULL 不能使用任何索引键 NULL NULL 44 100.00 使用文件排序
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
# 呼叫者 文件和行号 21 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172120 JDatabaseDriver->loadObjectList() Copy JROOT/components/com_community/models/moods.php:3119 CommunityModelMoods->__construct() Copy JROOT/components/com_community/helpers/string.php:25318 CStringHelper::getMoodsModel() Copy JROOT/components/com_community/helpers/string.php:26417 CStringHelper::getMood() Copy JROOT/components/com_community/libraries/activities.php:156316 CActivities::format() Copy JROOT/components/com_community/libraries/user.php:48815 CUser->getStatus() Copy JROOT/components/com_community/views/profile/view.html.php:169014 CommunityViewProfile->modProfileUserinfo() Copy JROOT/components/com_community/templates/jomsocial/layouts/profile/base.php:3313 require Copy JROOT/components/com_community/templates/jomsocial/layouts/profile/base.php Copy JROOT/components/com_community/libraries/template.php:24012 CTemplate->fetch() Copy JROOT/components/com_community/views/profile/view.html.php:79611 CommunityViewProfile->profile() Copy JROOT/components/com_community/views/views.php:25110 CommunityView->get() Copy JROOT/components/com_community/controllers/profile.php:14549 CommunityProfileController->profile() Copy JROOT/components/com_community/controllers/profile.php:12028 CommunityProfileController->display() Copy JROOT/components/com_community/controllers/controller.php:3317 CommunityBaseController->execute() Copy JROOT/components/com_community/community.php:1456 require_once Copy JROOT/components/com_community/community.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
查询时间:1.01 ms 上次查询后:0.46 ms 查询内存:0.025 MB 查询前内存:22.323 MB 返回的行数:0
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.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
# 呼叫者 文件和行号 18 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:176017 JDatabaseDriver->loadResult() Copy JROOT/components/com_community/models/profile.php:77116 CommunityModelProfile->getGender() Copy JROOT/components/com_community/libraries/user.php:140015 CUser->isDefaultCover() Copy JROOT/components/com_community/views/profile/view.html.php:169114 CommunityViewProfile->modProfileUserinfo() Copy JROOT/components/com_community/templates/jomsocial/layouts/profile/base.php:3313 require Copy JROOT/components/com_community/templates/jomsocial/layouts/profile/base.php Copy JROOT/components/com_community/libraries/template.php:24012 CTemplate->fetch() Copy JROOT/components/com_community/views/profile/view.html.php:79611 CommunityViewProfile->profile() Copy JROOT/components/com_community/views/views.php:25110 CommunityView->get() Copy JROOT/components/com_community/controllers/profile.php:14549 CommunityProfileController->profile() Copy JROOT/components/com_community/controllers/profile.php:12028 CommunityProfileController->display() Copy JROOT/components/com_community/controllers/controller.php:3317 CommunityBaseController->execute() Copy JROOT/components/com_community/community.php:1456 require_once Copy JROOT/components/com_community/community.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
查询时间:1.02 ms 上次查询后:0.11 ms 查询内存:0.025 MB 查询前内存:22.332 MB 返回的行数:0
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.02 ms sending cached result to clien 0.03 ms cleaned up 0.01 ms cleaning up 0.00 ms
# 呼叫者 文件和行号 18 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:176017 JDatabaseDriver->loadResult() Copy JROOT/components/com_community/models/profile.php:77116 CommunityModelProfile->getGender() Copy JROOT/components/com_community/libraries/user.php:127415 CUser->getCover() Copy JROOT/components/com_community/views/profile/view.html.php:169214 CommunityViewProfile->modProfileUserinfo() Copy JROOT/components/com_community/templates/jomsocial/layouts/profile/base.php:3313 require Copy JROOT/components/com_community/templates/jomsocial/layouts/profile/base.php Copy JROOT/components/com_community/libraries/template.php:24012 CTemplate->fetch() Copy JROOT/components/com_community/views/profile/view.html.php:79611 CommunityViewProfile->profile() Copy JROOT/components/com_community/views/views.php:25110 CommunityView->get() Copy JROOT/components/com_community/controllers/profile.php:14549 CommunityProfileController->profile() Copy JROOT/components/com_community/controllers/profile.php:12028 CommunityProfileController->display() Copy JROOT/components/com_community/controllers/controller.php:3317 CommunityBaseController->execute() Copy JROOT/components/com_community/community.php:1456 require_once Copy JROOT/components/com_community/community.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
查询时间:1.01 ms 上次查询后:0.18 ms 查询内存:0.024 MB 查询前内存:22.341 MB 返回的行数:0
SELECT `id` FROM `joom_community_photos_albums ` WHERE `creator` = '1621330' AND `type` = 'profile.cover'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE joom_community_photos_albums NULL ref creator,idx_creatortype,idx_type creator 4 const 1 50.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.02 ms sending cached result to clien 0.03 ms cleaned up 0.01 ms cleaning up 0.00 ms
# 呼叫者 文件和行号 17 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:176016 JDatabaseDriver->loadResult() Copy JROOT/components/com_community/tables/album.php:55515 CTableAlbum->isCoverExist() Copy JROOT/components/com_community/views/profile/view.html.php:170314 CommunityViewProfile->modProfileUserinfo() Copy JROOT/components/com_community/templates/jomsocial/layouts/profile/base.php:3313 require Copy JROOT/components/com_community/templates/jomsocial/layouts/profile/base.php Copy JROOT/components/com_community/libraries/template.php:24012 CTemplate->fetch() Copy JROOT/components/com_community/views/profile/view.html.php:79611 CommunityViewProfile->profile() Copy JROOT/components/com_community/views/views.php:25110 CommunityView->get() Copy JROOT/components/com_community/controllers/profile.php:14549 CommunityProfileController->profile() Copy JROOT/components/com_community/controllers/profile.php:12028 CommunityProfileController->display() Copy JROOT/components/com_community/controllers/controller.php:3317 CommunityBaseController->execute() Copy JROOT/components/com_community/community.php:1456 require_once Copy JROOT/components/com_community/community.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
查询时间:1.03 ms 上次查询后:3.18 ms 查询内存:0.024 MB 查询前内存:22.679 MB 返回的行数:1
SELECT COUNT (* ) FROM `joom_community_groups_members ` AS a INNER JOIN `joom_community_groups ` AS b WHERE a.`groupid`= b.`id` AND `memberid`= '1621330' AND `approved`= '1' AND b.`published`= '1'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL ref PRIMARY,groupid,idx_memberid idx_memberid 4 const 1 100.00 Using where 1 SIMPLE b NULL eq_ref PRIMARY PRIMARY 4 root_db.a.groupid 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 checking permissions 0.01 ms sending cached result to clien 0.03 ms cleaned up 0.01 ms cleaning up 0.00 ms
# 呼叫者 文件和行号 17 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:176016 JDatabaseDriver->loadResult() Copy JROOT/components/com_community/models/groups.php:42515 CommunityModelGroups->getGroupsCount() Copy JROOT/components/com_community/views/profile/view.html.php:171114 CommunityViewProfile->modProfileUserinfo() Copy JROOT/components/com_community/templates/jomsocial/layouts/profile/base.php:3313 require Copy JROOT/components/com_community/templates/jomsocial/layouts/profile/base.php Copy JROOT/components/com_community/libraries/template.php:24012 CTemplate->fetch() Copy JROOT/components/com_community/views/profile/view.html.php:79611 CommunityViewProfile->profile() Copy JROOT/components/com_community/views/views.php:25110 CommunityView->get() Copy JROOT/components/com_community/controllers/profile.php:14549 CommunityProfileController->profile() Copy JROOT/components/com_community/controllers/profile.php:12028 CommunityProfileController->display() Copy JROOT/components/com_community/controllers/controller.php:3317 CommunityBaseController->execute() Copy JROOT/components/com_community/community.php:1456 require_once Copy JROOT/components/com_community/community.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
查询时间:1.36 ms 上次查询后:0.04 ms 查询内存:0.024 MB 查询前内存:22.688 MB 返回的行数:1
SELECT COUNT (* ) FROM `joom_community_events_members ` AS a INNER JOIN `joom_community_events ` AS b ON b.`id`= a.`eventid` AND b.`enddate` > '2024-08-08 08:37:49' WHERE a.`memberid`= '1621330' AND a.`status` IN ('1','0')id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL ALL idx_eventid,idx_member_event,idx_permission,idx_status 不能使用任何索引键 NULL NULL 1 100.00 Using where 1 SIMPLE b NULL eq_ref PRIMARY PRIMARY 4 root_db.a.eventid 1 100.00 Using where
Status Duration starting 0.02 ms checking query cache for query 0.10 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.05 ms System lock 0.02 ms optimizing 0.02 ms statistics 0.07 ms preparing 0.03 ms executing 0.00 ms Sending data 0.02 ms end 0.01 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.05 ms storing result in query cache 0.01 ms cleaned up 0.01 ms cleaning up 0.01 ms
# 呼叫者 文件和行号 17 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:176016 JDatabaseDriver->loadResult() Copy JROOT/components/com_community/models/events.php:58815 CommunityModelEvents->getEventsCount() Copy JROOT/components/com_community/views/profile/view.html.php:171414 CommunityViewProfile->modProfileUserinfo() Copy JROOT/components/com_community/templates/jomsocial/layouts/profile/base.php:3313 require Copy JROOT/components/com_community/templates/jomsocial/layouts/profile/base.php Copy JROOT/components/com_community/libraries/template.php:24012 CTemplate->fetch() Copy JROOT/components/com_community/views/profile/view.html.php:79611 CommunityViewProfile->profile() Copy JROOT/components/com_community/views/views.php:25110 CommunityView->get() Copy JROOT/components/com_community/controllers/profile.php:14549 CommunityProfileController->profile() Copy JROOT/components/com_community/controllers/profile.php:12028 CommunityProfileController->display() Copy JROOT/components/com_community/controllers/controller.php:3317 CommunityBaseController->execute() Copy JROOT/components/com_community/community.php:1456 require_once Copy JROOT/components/com_community/community.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
查询时间:1.03 ms 上次查询后:1.47 ms 查询内存:0.024 MB 查询前内存:22.818 MB 返回的行数:1
SELECT COUNT (1) FROM `joom_community_videos ` AS a WHERE `creator`= '1621330' AND `creator_type`= 'user' AND (`status` = 'ready' OR `type` = 'file')id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL ref creator creator 4 const 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
# 呼叫者 文件和行号 17 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:176016 JDatabaseDriver->loadResult() Copy JROOT/components/com_community/models/videos.php:61515 CommunityModelVideos->getVideosCount() Copy JROOT/components/com_community/views/profile/view.html.php:171914 CommunityViewProfile->modProfileUserinfo() Copy JROOT/components/com_community/templates/jomsocial/layouts/profile/base.php:3313 require Copy JROOT/components/com_community/templates/jomsocial/layouts/profile/base.php Copy JROOT/components/com_community/libraries/template.php:24012 CTemplate->fetch() Copy JROOT/components/com_community/views/profile/view.html.php:79611 CommunityViewProfile->profile() Copy JROOT/components/com_community/views/views.php:25110 CommunityView->get() Copy JROOT/components/com_community/controllers/profile.php:14549 CommunityProfileController->profile() Copy JROOT/components/com_community/controllers/profile.php:12028 CommunityProfileController->display() Copy JROOT/components/com_community/controllers/controller.php:3317 CommunityBaseController->execute() Copy JROOT/components/com_community/community.php:1456 require_once Copy JROOT/components/com_community/community.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
查询时间:0.97 ms 上次查询后:2.32 ms 查询内存:0.024 MB 查询前内存:23.050 MB 返回的行数:1
SELECT COUNT (1) FROM `joom_community_photos ` AS a INNER JOIN `joom_community_photos_albums ` AS b ON a.albumid= b.id WHERE published = 1 AND a.creator= '1621330' AND (b.type LIKE 'user%' or b.type LIKE 'profile.%') AND `albumid`<>0id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL ALL albumid 不能使用任何索引键 NULL NULL 3 33.33 Using where 1 SIMPLE b NULL eq_ref PRIMARY,idx_albumtype,idx_type PRIMARY 4 root_db.a.albumid 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.01 ms checking permissions 0.01 ms sending cached result to clien 0.02 ms cleaned up 0.01 ms cleaning up 0.00 ms
# 呼叫者 文件和行号 17 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:176016 JDatabaseDriver->loadResult() Copy JROOT/components/com_community/models/photos.php:128315 CommunityModelPhotos->getPhotosCount() Copy JROOT/components/com_community/views/profile/view.html.php:172214 CommunityViewProfile->modProfileUserinfo() Copy JROOT/components/com_community/templates/jomsocial/layouts/profile/base.php:3313 require Copy JROOT/components/com_community/templates/jomsocial/layouts/profile/base.php Copy JROOT/components/com_community/libraries/template.php:24012 CTemplate->fetch() Copy JROOT/components/com_community/views/profile/view.html.php:79611 CommunityViewProfile->profile() Copy JROOT/components/com_community/views/views.php:25110 CommunityView->get() Copy JROOT/components/com_community/controllers/profile.php:14549 CommunityProfileController->profile() Copy JROOT/components/com_community/controllers/profile.php:12028 CommunityProfileController->display() Copy JROOT/components/com_community/controllers/controller.php:3317 CommunityBaseController->execute() Copy JROOT/components/com_community/community.php:1456 require_once Copy JROOT/components/com_community/community.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
查询时间:1.01 ms 上次查询后:0.59 ms 查询内存:0.024 MB 查询前内存:23.075 MB 返回的行数:1
SELECT COUNT (1) FROM `joom_community_featured ` WHERE `type`= 'users' AND `cid`= '1621330'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE joom_community_featured NULL ref type type 767 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.02 ms sending cached result to clien 0.04 ms cleaned up 0.01 ms cleaning up 0.00 ms
# 呼叫者 文件和行号 17 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:176016 JDatabaseDriver->loadResult() Copy JROOT/components/com_community/models/featured.php:3215 CommunityModelFeatured->isExists() Copy JROOT/components/com_community/views/profile/view.html.php:173414 CommunityViewProfile->modProfileUserinfo() Copy JROOT/components/com_community/templates/jomsocial/layouts/profile/base.php:3313 require Copy JROOT/components/com_community/templates/jomsocial/layouts/profile/base.php Copy JROOT/components/com_community/libraries/template.php:24012 CTemplate->fetch() Copy JROOT/components/com_community/views/profile/view.html.php:79611 CommunityViewProfile->profile() Copy JROOT/components/com_community/views/views.php:25110 CommunityView->get() Copy JROOT/components/com_community/controllers/profile.php:14549 CommunityProfileController->profile() Copy JROOT/components/com_community/controllers/profile.php:12028 CommunityProfileController->display() Copy JROOT/components/com_community/controllers/controller.php:3317 CommunityBaseController->execute() Copy JROOT/components/com_community/community.php:1456 require_once Copy JROOT/components/com_community/community.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
查询时间:1.55 ms 上次查询后:1.11 ms 查询内存:0.030 MB 查询前内存:23.210 MB 返回的行数:25
SHOW FULL COLUMNS FROM `joom_community_videos `查询时无法解释:SHOW FULL COLUMNS FROM `joom_community_videos`
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.02 ms executing 0.01 ms Opening tables 0.02 ms checking permissions 0.05 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.06 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
# 呼叫者 文件和行号 21 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172120 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/joomla/database/driver/mysqli.php:42119 JDatabaseDriverMysqli->getTableColumns() Copy JROOT/libraries/joomla/table/table.php:24418 JTable->getFields() Copy JROOT/libraries/joomla/table/table.php:16317 JTable->__construct() Copy JROOT/components/com_community/tables/video.php:5816 CTableVideo->__construct() Copy JROOT/libraries/joomla/table/table.php:31115 JTable::getInstance() Copy JROOT/components/com_community/views/profile/view.html.php:173914 CommunityViewProfile->modProfileUserinfo() Copy JROOT/components/com_community/templates/jomsocial/layouts/profile/base.php:3313 require Copy JROOT/components/com_community/templates/jomsocial/layouts/profile/base.php Copy JROOT/components/com_community/libraries/template.php:24012 CTemplate->fetch() Copy JROOT/components/com_community/views/profile/view.html.php:79611 CommunityViewProfile->profile() Copy JROOT/components/com_community/views/views.php:25110 CommunityView->get() Copy JROOT/components/com_community/controllers/profile.php:14549 CommunityProfileController->profile() Copy JROOT/components/com_community/controllers/profile.php:12028 CommunityProfileController->display() Copy JROOT/components/com_community/controllers/controller.php:3317 CommunityBaseController->execute() Copy JROOT/components/com_community/community.php:1456 require_once Copy JROOT/components/com_community/community.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
查询时间:6.36 ms 上次查询后:1.05 ms 查询内存:0.008 MB 查询前内存:23.295 MB
UPDATE `joom_community_users ` SET `view` = ( `view` + 1 ) WHERE `userid`= '1621330'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 UPDATE joom_community_users NULL range PRIMARY PRIMARY 4 const 1 100.00 Using where
Status Duration starting 0.07 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.02 ms System lock 0.05 ms updating 0.10 ms end 0.01 ms query end 0.05 ms closing tables 0.01 ms freeing items 0.01 ms delayed commit ok initiated 5.08 ms delayed commit ok done 0.05 ms cleaning up 0.01 ms
# 呼叫者 文件和行号 16 JDatabaseDriverMysqli->execute() Copy JROOT/components/com_community/libraries/user.php:106515 CUser->viewHit() Copy JROOT/components/com_community/views/profile/view.html.php:175814 CommunityViewProfile->modProfileUserinfo() Copy JROOT/components/com_community/templates/jomsocial/layouts/profile/base.php:3313 require Copy JROOT/components/com_community/templates/jomsocial/layouts/profile/base.php Copy JROOT/components/com_community/libraries/template.php:24012 CTemplate->fetch() Copy JROOT/components/com_community/views/profile/view.html.php:79611 CommunityViewProfile->profile() Copy JROOT/components/com_community/views/views.php:25110 CommunityView->get() Copy JROOT/components/com_community/controllers/profile.php:14549 CommunityProfileController->profile() Copy JROOT/components/com_community/controllers/profile.php:12028 CommunityProfileController->display() Copy JROOT/components/com_community/controllers/controller.php:3317 CommunityBaseController->execute() Copy JROOT/components/com_community/community.php:1456 require_once Copy JROOT/components/com_community/community.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
查询时间:1.32 ms 上次查询后:0.65 ms 查询内存:0.025 MB 查询前内存:23.330 MB 返回的行数:0
SELECT id, count FROM `joom_community_profile_stats ` WHERE `date` = '2024-08-08' AND `type` LIKE 'view' AND `uid` = '1621330'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE joom_community_profile_stats NULL ALL NULL 不能使用任何索引键 NULL NULL 140 0.71 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.03 ms statistics 0.03 ms preparing 0.02 ms executing 0.00 ms Sending data 0.10 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.01 ms
# 呼叫者 文件和行号 18 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:168217 JDatabaseDriver->loadObject() Copy JROOT/components/com_community/models/stats.php:3516 CommunityModelStats->addProfileStats() Copy JROOT/components/com_community/libraries/user.php:107015 CUser->viewHit() Copy JROOT/components/com_community/views/profile/view.html.php:175814 CommunityViewProfile->modProfileUserinfo() Copy JROOT/components/com_community/templates/jomsocial/layouts/profile/base.php:3313 require Copy JROOT/components/com_community/templates/jomsocial/layouts/profile/base.php Copy JROOT/components/com_community/libraries/template.php:24012 CTemplate->fetch() Copy JROOT/components/com_community/views/profile/view.html.php:79611 CommunityViewProfile->profile() Copy JROOT/components/com_community/views/views.php:25110 CommunityView->get() Copy JROOT/components/com_community/controllers/profile.php:14549 CommunityProfileController->profile() Copy JROOT/components/com_community/controllers/profile.php:12028 CommunityProfileController->display() Copy JROOT/components/com_community/controllers/controller.php:3317 CommunityBaseController->execute() Copy JROOT/components/com_community/community.php:1456 require_once Copy JROOT/components/com_community/community.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
查询时间:1.38 ms 上次查询后:0.48 ms 查询内存:0.028 MB 查询前内存:23.346 MB 返回的行数:7
SHOW FULL COLUMNS FROM `joom_community_profile_stats `查询时无法解释:SHOW FULL COLUMNS FROM `joom_community_profile_stats`
Status Duration starting 0.04 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 Sending data 0.04 ms end 0.00 ms query end 0.01 ms closing tables 0.00 ms removing tmp table 0.03 ms closing tables 0.00 ms freeing items 0.03 ms cleaned up 0.01 ms cleaning up 0.00 ms
# 呼叫者 文件和行号 23 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172122 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/joomla/database/driver/mysqli.php:42121 JDatabaseDriverMysqli->getTableColumns() Copy JROOT/libraries/joomla/table/table.php:24420 JTable->getFields() Copy JROOT/libraries/joomla/table/table.php:16319 JTable->__construct() Copy JROOT/components/com_community/tables/profilestats.php:2418 CTableProfileStats->__construct() Copy JROOT/libraries/joomla/table/table.php:31117 JTable::getInstance() Copy JROOT/components/com_community/models/stats.php:3716 CommunityModelStats->addProfileStats() Copy JROOT/components/com_community/libraries/user.php:107015 CUser->viewHit() Copy JROOT/components/com_community/views/profile/view.html.php:175814 CommunityViewProfile->modProfileUserinfo() Copy JROOT/components/com_community/templates/jomsocial/layouts/profile/base.php:3313 require Copy JROOT/components/com_community/templates/jomsocial/layouts/profile/base.php Copy JROOT/components/com_community/libraries/template.php:24012 CTemplate->fetch() Copy JROOT/components/com_community/views/profile/view.html.php:79611 CommunityViewProfile->profile() Copy JROOT/components/com_community/views/views.php:25110 CommunityView->get() Copy JROOT/components/com_community/controllers/profile.php:14549 CommunityProfileController->profile() Copy JROOT/components/com_community/controllers/profile.php:12028 CommunityProfileController->display() Copy JROOT/components/com_community/controllers/controller.php:3317 CommunityBaseController->execute() Copy JROOT/components/com_community/community.php:1456 require_once Copy JROOT/components/com_community/community.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
查询时间:1.45 ms 上次查询后:0.06 ms 查询内存:0.026 MB 查询前内存:23.365 MB 返回的行数:1
SELECT *
FROM table_keys
WHERE `table_name` = 'joom_community_profile_stats 'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE table_keys NULL ALL NULL 不能使用任何索引键 NULL NULL 349 10.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.06 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.01 ms preparing 0.02 ms executing 0.00 ms Sending data 0.28 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
# 呼叫者 文件和行号 21 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:168220 JDatabaseDriver->loadObject() Copy JROOT/libraries/joomla/database/driver.php:138319 JDatabaseDriver->insertObject() Copy JROOT/libraries/joomla/table/table.php:83918 JTable->store() Copy JROOT/components/com_community/tables/profilestats.php:3317 CTableProfileStats->store() Copy JROOT/components/com_community/models/stats.php:5016 CommunityModelStats->addProfileStats() Copy JROOT/components/com_community/libraries/user.php:107015 CUser->viewHit() Copy JROOT/components/com_community/views/profile/view.html.php:175814 CommunityViewProfile->modProfileUserinfo() Copy JROOT/components/com_community/templates/jomsocial/layouts/profile/base.php:3313 require Copy JROOT/components/com_community/templates/jomsocial/layouts/profile/base.php Copy JROOT/components/com_community/libraries/template.php:24012 CTemplate->fetch() Copy JROOT/components/com_community/views/profile/view.html.php:79611 CommunityViewProfile->profile() Copy JROOT/components/com_community/views/views.php:25110 CommunityView->get() Copy JROOT/components/com_community/controllers/profile.php:14549 CommunityProfileController->profile() Copy JROOT/components/com_community/controllers/profile.php:12028 CommunityProfileController->display() Copy JROOT/components/com_community/controllers/controller.php:3317 CommunityBaseController->execute() Copy JROOT/components/com_community/community.php:1456 require_once Copy JROOT/components/com_community/community.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
查询时间:1.30 ms 上次查询后:0.03 ms 查询内存:0.026 MB 查询前内存:23.376 MB 返回的行数:1
SELECT AUTO_INCREMENT
FROM `information_schema`.`TABLES `
WHERE TABLE_SCHEMA = 'root_db'
AND TABLE_NAME = 'joom_community_profile_stats 'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE TABLES NULL ALL NULL TABLE_SCHEMA,TABLE_NAME NULL NULL NULL NULL Using where; Open_full_table; Scanned 0 databases
Status Duration starting 0.02 ms checking query cache for query 0.06 ms checking permissions 0.01 ms Opening tables 0.05 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms executing 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms Sending data 0.01 ms end 0.02 ms query end 0.01 ms closing tables 0.00 ms removing tmp table 0.01 ms closing tables 0.00 ms freeing items 0.02 ms cleaned up 0.01 ms cleaning up 0.00 ms
# 呼叫者 文件和行号 21 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:168220 JDatabaseDriver->loadObject() Copy JROOT/libraries/joomla/database/driver.php:139219 JDatabaseDriver->insertObject() Copy JROOT/libraries/joomla/table/table.php:83918 JTable->store() Copy JROOT/components/com_community/tables/profilestats.php:3317 CTableProfileStats->store() Copy JROOT/components/com_community/models/stats.php:5016 CommunityModelStats->addProfileStats() Copy JROOT/components/com_community/libraries/user.php:107015 CUser->viewHit() Copy JROOT/components/com_community/views/profile/view.html.php:175814 CommunityViewProfile->modProfileUserinfo() Copy JROOT/components/com_community/templates/jomsocial/layouts/profile/base.php:3313 require Copy JROOT/components/com_community/templates/jomsocial/layouts/profile/base.php Copy JROOT/components/com_community/libraries/template.php:24012 CTemplate->fetch() Copy JROOT/components/com_community/views/profile/view.html.php:79611 CommunityViewProfile->profile() Copy JROOT/components/com_community/views/views.php:25110 CommunityView->get() Copy JROOT/components/com_community/controllers/profile.php:14549 CommunityProfileController->profile() Copy JROOT/components/com_community/controllers/profile.php:12028 CommunityProfileController->display() Copy JROOT/components/com_community/controllers/controller.php:3317 CommunityBaseController->execute() Copy JROOT/components/com_community/community.php:1456 require_once Copy JROOT/components/com_community/community.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
查询时间:3.54 ms 上次查询后:0.05 ms 查询内存:0.010 MB 查询前内存:23.388 MB
INSERT INTO `joom_community_profile_stats `
(`uid`,`type`,`count`,`date`) VALUES
('1621330','view','1','2024-08-08')查询时无法解释:INSERT INTO `joom_community_profile_stats`
(`uid`,`type`,`count`,`date`) VALUES
('1621330','view','1','2024-08-08')
Status Duration starting 0.05 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.01 ms System lock 0.01 ms update 0.11 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.40 ms delayed commit ok done 0.03 ms cleaning up 0.01 ms
# 呼叫者 文件和行号 20 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:143419 JDatabaseDriver->insertObject() Copy JROOT/libraries/joomla/table/table.php:83918 JTable->store() Copy JROOT/components/com_community/tables/profilestats.php:3317 CTableProfileStats->store() Copy JROOT/components/com_community/models/stats.php:5016 CommunityModelStats->addProfileStats() Copy JROOT/components/com_community/libraries/user.php:107015 CUser->viewHit() Copy JROOT/components/com_community/views/profile/view.html.php:175814 CommunityViewProfile->modProfileUserinfo() Copy JROOT/components/com_community/templates/jomsocial/layouts/profile/base.php:3313 require Copy JROOT/components/com_community/templates/jomsocial/layouts/profile/base.php Copy JROOT/components/com_community/libraries/template.php:24012 CTemplate->fetch() Copy JROOT/components/com_community/views/profile/view.html.php:79611 CommunityViewProfile->profile() Copy JROOT/components/com_community/views/views.php:25110 CommunityView->get() Copy JROOT/components/com_community/controllers/profile.php:14549 CommunityProfileController->profile() Copy JROOT/components/com_community/controllers/profile.php:12028 CommunityProfileController->display() Copy JROOT/components/com_community/controllers/controller.php:3317 CommunityBaseController->execute() Copy JROOT/components/com_community/community.php:1456 require_once Copy JROOT/components/com_community/community.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
查询时间:21.00 ms 上次查询后:0.03 ms 查询内存:0.010 MB 查询前内存:23.400 MB
UPDATE `table_keys` SET `field_name`= 'id',`auto_increment_value`= '141' WHERE `table_name` = 'joom_community_profile_stats 'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 UPDATE table_keys NULL ALL NULL 不能使用任何索引键 NULL NULL 349 100.00 Using where
Status Duration starting 0.07 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.03 ms System lock 0.03 ms updating 0.37 ms end 0.01 ms query end 0.06 ms closing tables 0.01 ms freeing items 0.01 ms delayed commit ok initiated 19.49 ms delayed commit ok done 0.04 ms cleaning up 0.01 ms
# 呼叫者 文件和行号 21 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:230820 JDatabaseDriver->updateObject() Copy JROOT/libraries/joomla/database/driver.php:144619 JDatabaseDriver->insertObject() Copy JROOT/libraries/joomla/table/table.php:83918 JTable->store() Copy JROOT/components/com_community/tables/profilestats.php:3317 CTableProfileStats->store() Copy JROOT/components/com_community/models/stats.php:5016 CommunityModelStats->addProfileStats() Copy JROOT/components/com_community/libraries/user.php:107015 CUser->viewHit() Copy JROOT/components/com_community/views/profile/view.html.php:175814 CommunityViewProfile->modProfileUserinfo() Copy JROOT/components/com_community/templates/jomsocial/layouts/profile/base.php:3313 require Copy JROOT/components/com_community/templates/jomsocial/layouts/profile/base.php Copy JROOT/components/com_community/libraries/template.php:24012 CTemplate->fetch() Copy JROOT/components/com_community/views/profile/view.html.php:79611 CommunityViewProfile->profile() Copy JROOT/components/com_community/views/views.php:25110 CommunityView->get() Copy JROOT/components/com_community/controllers/profile.php:14549 CommunityProfileController->profile() Copy JROOT/components/com_community/controllers/profile.php:12028 CommunityProfileController->display() Copy JROOT/components/com_community/controllers/controller.php:3317 CommunityBaseController->execute() Copy JROOT/components/com_community/community.php:1456 require_once Copy JROOT/components/com_community/community.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
查询时间:1.53 ms 上次查询后:2.48 ms 查询内存:0.027 MB 查询前内存:23.489 MB 返回的行数:5
SHOW FULL COLUMNS FROM `joom_community_likes `查询时无法解释:SHOW FULL COLUMNS FROM `joom_community_likes`
Status Duration starting 0.07 ms checking permissions 0.04 ms checking permissions 0.01 ms Opening tables 0.16 ms init 0.02 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.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.02 ms Sending data 0.04 ms end 0.00 ms query end 0.01 ms closing tables 0.01 ms removing tmp table 0.05 ms closing tables 0.01 ms freeing items 0.04 ms cleaned up 0.02 ms cleaning up 0.01 ms
# 呼叫者 文件和行号 22 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172121 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/joomla/database/driver/mysqli.php:42120 JDatabaseDriverMysqli->getTableColumns() Copy JROOT/libraries/joomla/table/table.php:24419 JTable->getFields() Copy JROOT/libraries/joomla/table/table.php:16318 JTable->__construct() Copy JROOT/components/com_community/tables/like.php:2917 CTableLike->__construct() Copy JROOT/libraries/joomla/table/table.php:31116 JTable::getInstance() Copy JROOT/components/com_community/libraries/like.php:35315 CLike->userLiked() Copy JROOT/components/com_community/views/profile/view.html.php:178614 CommunityViewProfile->modProfileUserinfo() Copy JROOT/components/com_community/templates/jomsocial/layouts/profile/base.php:3313 require Copy JROOT/components/com_community/templates/jomsocial/layouts/profile/base.php Copy JROOT/components/com_community/libraries/template.php:24012 CTemplate->fetch() Copy JROOT/components/com_community/views/profile/view.html.php:79611 CommunityViewProfile->profile() Copy JROOT/components/com_community/views/views.php:25110 CommunityView->get() Copy JROOT/components/com_community/controllers/profile.php:14549 CommunityProfileController->profile() Copy JROOT/components/com_community/controllers/profile.php:12028 CommunityProfileController->display() Copy JROOT/components/com_community/controllers/controller.php:3317 CommunityBaseController->execute() Copy JROOT/components/com_community/community.php:1456 require_once Copy JROOT/components/com_community/community.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
查询时间:1.01 ms 上次查询后:0.04 ms 查询内存:0.025 MB 查询前内存:23.504 MB 返回的行数:0
SELECT * FROM `joom_community_likes ` WHERE `element`= 'profile' AND `uid`= '1621330'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE joom_community_likes NULL ref element element 606 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.02 ms sending cached result to clien 0.03 ms cleaned up 0.02 ms cleaning up 0.00 ms
# 呼叫者 文件和行号 18 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:168217 JDatabaseDriver->loadObject() Copy JROOT/components/com_community/tables/like.php:5116 CTableLike->loadInfo() Copy JROOT/components/com_community/libraries/like.php:35415 CLike->userLiked() Copy JROOT/components/com_community/views/profile/view.html.php:178614 CommunityViewProfile->modProfileUserinfo() Copy JROOT/components/com_community/templates/jomsocial/layouts/profile/base.php:3313 require Copy JROOT/components/com_community/templates/jomsocial/layouts/profile/base.php Copy JROOT/components/com_community/libraries/template.php:24012 CTemplate->fetch() Copy JROOT/components/com_community/views/profile/view.html.php:79611 CommunityViewProfile->profile() Copy JROOT/components/com_community/views/views.php:25110 CommunityView->get() Copy JROOT/components/com_community/controllers/profile.php:14549 CommunityProfileController->profile() Copy JROOT/components/com_community/controllers/profile.php:12028 CommunityProfileController->display() Copy JROOT/components/com_community/controllers/controller.php:3317 CommunityBaseController->execute() Copy JROOT/components/com_community/community.php:1456 require_once Copy JROOT/components/com_community/community.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
查询时间:1.66 ms 上次查询后:0.03 ms 查询内存:0.025 MB 查询前内存:23.513 MB 返回的行数:0
SELECT * FROM `joom_community_likes ` WHERE `element`= 'profile' AND `uid`= '1621330'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE joom_community_likes NULL ref element element 606 const,const 1 100.00 NULL
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.03 ms cleaned up 0.01 ms cleaning up 0.00 ms
# 呼叫者 文件和行号 18 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:168217 JDatabaseDriver->loadObject() Copy JROOT/components/com_community/tables/like.php:5116 CTableLike->loadInfo() Copy JROOT/components/com_community/libraries/like.php:39215 CLike->getLikeCount() Copy JROOT/components/com_community/views/profile/view.html.php:178914 CommunityViewProfile->modProfileUserinfo() Copy JROOT/components/com_community/templates/jomsocial/layouts/profile/base.php:3313 require Copy JROOT/components/com_community/templates/jomsocial/layouts/profile/base.php Copy JROOT/components/com_community/libraries/template.php:24012 CTemplate->fetch() Copy JROOT/components/com_community/views/profile/view.html.php:79611 CommunityViewProfile->profile() Copy JROOT/components/com_community/views/views.php:25110 CommunityView->get() Copy JROOT/components/com_community/controllers/profile.php:14549 CommunityProfileController->profile() Copy JROOT/components/com_community/controllers/profile.php:12028 CommunityProfileController->display() Copy JROOT/components/com_community/controllers/controller.php:3317 CommunityBaseController->execute() Copy JROOT/components/com_community/community.php:1456 require_once Copy JROOT/components/com_community/community.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
查询时间:1.06 ms 上次查询后:0.06 ms 查询内存:0.026 MB 查询前内存:23.525 MB 返回的行数:6
SELECT b.id
FROM joom_user_usergroup_map AS map
LEFT JOIN joom_usergroups AS a ON a.id = map.group_id
LEFT JOIN joom_usergroups AS b ON b.lft <= a.lft AND b.rgt >= a.rgt
WHERE map.user_id = 1621330id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE map NULL ref PRIMARY,user_id user_id 4 const 2 100.00 Using index 1 SIMPLE a NULL eq_ref PRIMARY PRIMARY 4 root_db.map.group_id 1 100.00 NULL 1 SIMPLE b NULL ALL idx_usergroup_nested_set_lookup 不能使用任何索引键 NULL NULL 82 100.00 Range checked for each record (index map: 0x8)
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.00 ms checking permissions 0.01 ms sending cached result to clien 0.07 ms cleaned up 0.01 ms cleaning up 0.00 ms
# 呼叫者 文件和行号 21 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:157020 JDatabaseDriver->loadColumn() Copy JROOT/libraries/joomla/access/access.php:97919 JAccess::getGroupsByUser() Copy JROOT/libraries/joomla/user/user.php:47518 JUser->getAuthorisedGroups() Copy JROOT/libraries/joomla/user/user.php:38117 JUser->authorise() Copy JROOT/components/com_community/libraries/user.php:123516 CUser->authorise() Copy JROOT/components/com_community/helpers/owner.php:5115 COwnerHelper::isCommunityAdmin() Copy JROOT/components/com_community/views/profile/view.html.php:180414 CommunityViewProfile->modProfileUserinfo() Copy JROOT/components/com_community/templates/jomsocial/layouts/profile/base.php:3313 require Copy JROOT/components/com_community/templates/jomsocial/layouts/profile/base.php Copy JROOT/components/com_community/libraries/template.php:24012 CTemplate->fetch() Copy JROOT/components/com_community/views/profile/view.html.php:79611 CommunityViewProfile->profile() Copy JROOT/components/com_community/views/views.php:25110 CommunityView->get() Copy JROOT/components/com_community/controllers/profile.php:14549 CommunityProfileController->profile() Copy JROOT/components/com_community/controllers/profile.php:12028 CommunityProfileController->display() Copy JROOT/components/com_community/controllers/controller.php:3317 CommunityBaseController->execute() Copy JROOT/components/com_community/community.php:1456 require_once Copy JROOT/components/com_community/community.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
查询时间:1.13 ms 上次查询后:1.99 ms 查询内存:0.024 MB 查询前内存:23.594 MB 返回的行数:0
SELECT connection_id FROM `joom_community_connection ` WHERE `connect_from`= '0' AND `connect_to`= '1621330' AND `status` = '0'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE joom_community_connection NULL ref connect_from,idx_connect_from,idx_connect_to,idx_connect_tofrom connect_from 9 const,const,const 1 100.00 Using index
Status Duration starting 0.04 ms checking query cache for query 0.01 ms checking privileges on cached 0.05 ms checking permissions 0.02 ms sending cached result to clien 0.04 ms cleaned up 0.01 ms cleaning up 0.00 ms
# 呼叫者 文件和行号 17 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:176016 JDatabaseDriver->loadResult() Copy JROOT/components/com_community/helpers/friends.php:6815 CFriendsHelper::isWaitingApproval() Copy JROOT/components/com_community/views/profile/view.html.php:183214 CommunityViewProfile->modProfileUserinfo() Copy JROOT/components/com_community/templates/jomsocial/layouts/profile/base.php:3313 require Copy JROOT/components/com_community/templates/jomsocial/layouts/profile/base.php Copy JROOT/components/com_community/libraries/template.php:24012 CTemplate->fetch() Copy JROOT/components/com_community/views/profile/view.html.php:79611 CommunityViewProfile->profile() Copy JROOT/components/com_community/views/views.php:25110 CommunityView->get() Copy JROOT/components/com_community/controllers/profile.php:14549 CommunityProfileController->profile() Copy JROOT/components/com_community/controllers/profile.php:12028 CommunityProfileController->display() Copy JROOT/components/com_community/controllers/controller.php:3317 CommunityBaseController->execute() Copy JROOT/components/com_community/community.php:1456 require_once Copy JROOT/components/com_community/community.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
查询时间:1.04 ms 上次查询后:0.02 ms 查询内存:0.024 MB 查询前内存:23.603 MB 返回的行数:0
SELECT connection_id FROM `joom_community_connection ` WHERE `connect_from`= '1621330' AND `connect_to`= '0' AND `status` = '0'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE joom_community_connection NULL ref connect_from,idx_connect_from,idx_connect_to,idx_connect_tofrom connect_from 9 const,const,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.02 ms sending cached result to clien 0.04 ms cleaned up 0.02 ms cleaning up 0.00 ms
# 呼叫者 文件和行号 17 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:176016 JDatabaseDriver->loadResult() Copy JROOT/components/com_community/helpers/friends.php:6815 CFriendsHelper::isWaitingApproval() Copy JROOT/components/com_community/views/profile/view.html.php:183314 CommunityViewProfile->modProfileUserinfo() Copy JROOT/components/com_community/templates/jomsocial/layouts/profile/base.php:3313 require Copy JROOT/components/com_community/templates/jomsocial/layouts/profile/base.php Copy JROOT/components/com_community/libraries/template.php:24012 CTemplate->fetch() Copy JROOT/components/com_community/views/profile/view.html.php:79611 CommunityViewProfile->profile() Copy JROOT/components/com_community/views/views.php:25110 CommunityView->get() Copy JROOT/components/com_community/controllers/profile.php:14549 CommunityProfileController->profile() Copy JROOT/components/com_community/controllers/profile.php:12028 CommunityProfileController->display() Copy JROOT/components/com_community/controllers/controller.php:3317 CommunityBaseController->execute() Copy JROOT/components/com_community/community.php:1456 require_once Copy JROOT/components/com_community/community.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
查询时间:1.18 ms 上次查询后:1.82 ms 查询内存:0.026 MB 查询前内存:23.710 MB 返回的行数:0
SELECT * FROM `joom_community_theme ` WHERE `key`= 'settings' LIMIT 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE NULL NULL NULL NULL 不能使用任何索引键 NULL NULL NULL NULL no matching row in const table
Status Duration starting 0.03 ms checking query cache for query 0.01 ms checking privileges on cached 0.01 ms checking permissions 0.08 ms sending cached result to clien 0.04 ms cleaned up 0.02 ms cleaning up 0.01 ms
# 呼叫者 文件和行号 20 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172119 JDatabaseDriver->loadObjectList() Copy JROOT/components/com_community/models/theme.php:2818 CommunityModelTheme->__construct() Copy JROOT/components/com_community/libraries/core.php:37717 CFactory::getModel() Copy JROOT/components/com_community/templates/jomsocial/layouts/profile/focus.php:1716 require Copy JROOT/components/com_community/templates/jomsocial/layouts/profile/focus.php Copy JROOT/components/com_community/libraries/template.php:24015 CTemplate->fetch() Copy JROOT/components/com_community/views/profile/view.html.php:185314 CommunityViewProfile->modProfileUserinfo() Copy JROOT/components/com_community/templates/jomsocial/layouts/profile/base.php:3313 require Copy JROOT/components/com_community/templates/jomsocial/layouts/profile/base.php Copy JROOT/components/com_community/libraries/template.php:24012 CTemplate->fetch() Copy JROOT/components/com_community/views/profile/view.html.php:79611 CommunityViewProfile->profile() Copy JROOT/components/com_community/views/views.php:25110 CommunityView->get() Copy JROOT/components/com_community/controllers/profile.php:14549 CommunityProfileController->profile() Copy JROOT/components/com_community/controllers/profile.php:12028 CommunityProfileController->display() Copy JROOT/components/com_community/controllers/controller.php:3317 CommunityBaseController->execute() Copy JROOT/components/com_community/community.php:1456 require_once Copy JROOT/components/com_community/community.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
查询时间:1.07 ms 上次查询后:0.70 ms 查询内存:0.026 MB 查询前内存:23.746 MB 返回的行数:0
SELECT * FROM `joom_community_featured ` WHERE `type`= 'users' ORDER BY `id` DESC LIMIT 0,10id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE joom_community_featured NULL ref type type 767 const 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.03 ms cleaned up 0.03 ms cleaning up 0.00 ms
# 呼叫者 文件和行号 20 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172119 JDatabaseDriver->loadObjectList() Copy JROOT/components/com_community/libraries/featured.php:4118 CFeatured->_load() Copy JROOT/components/com_community/libraries/featured.php:2317 CFeatured->__construct() Copy JROOT/components/com_community/templates/jomsocial/layouts/profile/focus.php:2416 require Copy JROOT/components/com_community/templates/jomsocial/layouts/profile/focus.php Copy JROOT/components/com_community/libraries/template.php:24015 CTemplate->fetch() Copy JROOT/components/com_community/views/profile/view.html.php:185314 CommunityViewProfile->modProfileUserinfo() Copy JROOT/components/com_community/templates/jomsocial/layouts/profile/base.php:3313 require Copy JROOT/components/com_community/templates/jomsocial/layouts/profile/base.php Copy JROOT/components/com_community/libraries/template.php:24012 CTemplate->fetch() Copy JROOT/components/com_community/views/profile/view.html.php:79611 CommunityViewProfile->profile() Copy JROOT/components/com_community/views/views.php:25110 CommunityView->get() Copy JROOT/components/com_community/controllers/profile.php:14549 CommunityProfileController->profile() Copy JROOT/components/com_community/controllers/profile.php:12028 CommunityProfileController->display() Copy JROOT/components/com_community/controllers/controller.php:3317 CommunityBaseController->execute() Copy JROOT/components/com_community/community.php:1456 require_once Copy JROOT/components/com_community/community.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
查询时间:1.01 ms 上次查询后:0.50 ms 查询内存:0.025 MB 查询前内存:23.817 MB 返回的行数:1
SELECT SUM (points) AS totalPoints
FROM axs_points
WHERE `user_id` = 1621330id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE axs_points 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.03 ms cleaned up 0.02 ms cleaning up 0.01 ms
# 呼叫者 文件和行号 19 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:168218 JDatabaseDriver->loadObject() Copy JROOT/libraries/axslibs/learnerDashboard.php:23717 AxsLearnerDashboard::getLeaderBoardPointsForUser() Copy JROOT/components/com_community/templates/jomsocial/layouts/profile/focus.php:2716 require Copy JROOT/components/com_community/templates/jomsocial/layouts/profile/focus.php Copy JROOT/components/com_community/libraries/template.php:24015 CTemplate->fetch() Copy JROOT/components/com_community/views/profile/view.html.php:185314 CommunityViewProfile->modProfileUserinfo() Copy JROOT/components/com_community/templates/jomsocial/layouts/profile/base.php:3313 require Copy JROOT/components/com_community/templates/jomsocial/layouts/profile/base.php Copy JROOT/components/com_community/libraries/template.php:24012 CTemplate->fetch() Copy JROOT/components/com_community/views/profile/view.html.php:79611 CommunityViewProfile->profile() Copy JROOT/components/com_community/views/views.php:25110 CommunityView->get() Copy JROOT/components/com_community/controllers/profile.php:14549 CommunityProfileController->profile() Copy JROOT/components/com_community/controllers/profile.php:12028 CommunityProfileController->display() Copy JROOT/components/com_community/controllers/controller.php:3317 CommunityBaseController->execute() Copy JROOT/components/com_community/community.php:1456 require_once Copy JROOT/components/com_community/community.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
查询时间:1.10 ms 上次查询后:5.05 ms 查询内存:0.025 MB 查询前内存:24.579 MB 返回的行数:1
SELECT *
FROM axs_lms_settings
WHERE id= 1 LIMIT 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE axs_lms_settings 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.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
# 呼叫者 文件和行号 19 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:168218 JDatabaseDriver->loadObject() Copy JROOT/libraries/axslibs/lms.php:180517 AxsLMS::getSettings() Copy JROOT/components/com_community/templates/jomsocial/layouts/profile/focus.php:6916 require Copy JROOT/components/com_community/templates/jomsocial/layouts/profile/focus.php Copy JROOT/components/com_community/libraries/template.php:24015 CTemplate->fetch() Copy JROOT/components/com_community/views/profile/view.html.php:185314 CommunityViewProfile->modProfileUserinfo() Copy JROOT/components/com_community/templates/jomsocial/layouts/profile/base.php:3313 require Copy JROOT/components/com_community/templates/jomsocial/layouts/profile/base.php Copy JROOT/components/com_community/libraries/template.php:24012 CTemplate->fetch() Copy JROOT/components/com_community/views/profile/view.html.php:79611 CommunityViewProfile->profile() Copy JROOT/components/com_community/views/views.php:25110 CommunityView->get() Copy JROOT/components/com_community/controllers/profile.php:14549 CommunityProfileController->profile() Copy JROOT/components/com_community/controllers/profile.php:12028 CommunityProfileController->display() Copy JROOT/components/com_community/controllers/controller.php:3317 CommunityBaseController->execute() Copy JROOT/components/com_community/community.php:1456 require_once Copy JROOT/components/com_community/community.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
查询时间:1.06 ms 上次查询后:0.94 ms 查询内存:0.026 MB 查询前内存:24.635 MB 返回的行数:1
SELECT * FROM joom_community_badges WHERE `points` <= 0 AND `published`= 1 ORDER by `points` DESC LIMIT 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE joom_community_badges NULL range points points 4 NULL 1 16.67 Using index condition; 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.00 ms
# 呼叫者 文件和行号 19 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172118 JDatabaseDriver->loadObjectList() Copy JROOT/components/com_community/libraries/badge.php:5617 CBadge->getBadge() Copy JROOT/components/com_community/templates/jomsocial/layouts/profile/focus.php:35416 require Copy JROOT/components/com_community/templates/jomsocial/layouts/profile/focus.php Copy JROOT/components/com_community/libraries/template.php:24015 CTemplate->fetch() Copy JROOT/components/com_community/views/profile/view.html.php:185314 CommunityViewProfile->modProfileUserinfo() Copy JROOT/components/com_community/templates/jomsocial/layouts/profile/base.php:3313 require Copy JROOT/components/com_community/templates/jomsocial/layouts/profile/base.php Copy JROOT/components/com_community/libraries/template.php:24012 CTemplate->fetch() Copy JROOT/components/com_community/views/profile/view.html.php:79611 CommunityViewProfile->profile() Copy JROOT/components/com_community/views/views.php:25110 CommunityView->get() Copy JROOT/components/com_community/controllers/profile.php:14549 CommunityProfileController->profile() Copy JROOT/components/com_community/controllers/profile.php:12028 CommunityProfileController->display() Copy JROOT/components/com_community/controllers/controller.php:3317 CommunityBaseController->execute() Copy JROOT/components/com_community/community.php:1456 require_once Copy JROOT/components/com_community/community.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
查询时间:1.03 ms 上次查询后:0.03 ms 查询内存:0.026 MB 查询前内存:24.646 MB 返回的行数:1
SELECT * FROM joom_community_badges WHERE `points` > 0 AND `published`= 1 ORDER by `points` ASC LIMIT 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE joom_community_badges NULL range points points 4 NULL 5 16.67 Using index condition; 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.01 ms sending cached result to clien 0.03 ms cleaned up 0.01 ms cleaning up 0.00 ms
# 呼叫者 文件和行号 19 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172118 JDatabaseDriver->loadObjectList() Copy JROOT/components/com_community/libraries/badge.php:6917 CBadge->getBadge() Copy JROOT/components/com_community/templates/jomsocial/layouts/profile/focus.php:35416 require Copy JROOT/components/com_community/templates/jomsocial/layouts/profile/focus.php Copy JROOT/components/com_community/libraries/template.php:24015 CTemplate->fetch() Copy JROOT/components/com_community/views/profile/view.html.php:185314 CommunityViewProfile->modProfileUserinfo() Copy JROOT/components/com_community/templates/jomsocial/layouts/profile/base.php:3313 require Copy JROOT/components/com_community/templates/jomsocial/layouts/profile/base.php Copy JROOT/components/com_community/libraries/template.php:24012 CTemplate->fetch() Copy JROOT/components/com_community/views/profile/view.html.php:79611 CommunityViewProfile->profile() Copy JROOT/components/com_community/views/views.php:25110 CommunityView->get() Copy JROOT/components/com_community/controllers/profile.php:14549 CommunityProfileController->profile() Copy JROOT/components/com_community/controllers/profile.php:12028 CommunityProfileController->display() Copy JROOT/components/com_community/controllers/controller.php:3317 CommunityBaseController->execute() Copy JROOT/components/com_community/community.php:1456 require_once Copy JROOT/components/com_community/community.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
查询时间:0.97 ms 上次查询后:0.08 ms 查询内存:0.026 MB 查询前内存:24.657 MB 返回的行数:0
SELECT `id` FROM `joom_menu ` WHERE `link` LIKE '%option= com_community&view= friends%' 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.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() Copy JROOT/libraries/joomla/database/driver.php:176019 JDatabaseDriver->loadResult() Copy JROOT/components/com_community/libraries/core.php:139118 CRoute::_getViewItemid() Copy JROOT/components/com_community/libraries/core.php:130117 CRoute::_() Copy JROOT/components/com_community/templates/jomsocial/layouts/profile/focus.php:36816 require Copy JROOT/components/com_community/templates/jomsocial/layouts/profile/focus.php Copy JROOT/components/com_community/libraries/template.php:24015 CTemplate->fetch() Copy JROOT/components/com_community/views/profile/view.html.php:185314 CommunityViewProfile->modProfileUserinfo() Copy JROOT/components/com_community/templates/jomsocial/layouts/profile/base.php:3313 require Copy JROOT/components/com_community/templates/jomsocial/layouts/profile/base.php Copy JROOT/components/com_community/libraries/template.php:24012 CTemplate->fetch() Copy JROOT/components/com_community/views/profile/view.html.php:79611 CommunityViewProfile->profile() Copy JROOT/components/com_community/views/views.php:25110 CommunityView->get() Copy JROOT/components/com_community/controllers/profile.php:14549 CommunityProfileController->profile() Copy JROOT/components/com_community/controllers/profile.php:12028 CommunityProfileController->display() Copy JROOT/components/com_community/controllers/controller.php:3317 CommunityBaseController->execute() Copy JROOT/components/com_community/community.php:1456 require_once Copy JROOT/components/com_community/community.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
查询时间:1.09 ms 上次查询后:1.90 ms 查询内存:0.026 MB 查询前内存:24.559 MB 返回的行数:1
SELECT id, title
FROM axs_points_categories
WHERE enabled = 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE axs_points_categories 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.01 ms cleaning up 0.00 ms
# 呼叫者 文件和行号 20 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172119 JDatabaseDriver->loadObjectList() Copy JROOT/modules/mod_award/helper.php:3918 ModAwardHelper::makeBadges() Copy JROOT/modules/mod_award/helper.php:2517 ModAwardHelper::makeAward() Copy JROOT/modules/mod_award/mod_award.php:1716 include Copy JROOT/modules/mod_award/mod_award.php Copy JROOT/libraries/cms/module/helper.php:19815 JModuleHelper::renderModule() Copy JROOT/components/com_community/libraries/template.php:38714 CTemplate::renderModules() Copy JROOT/components/com_community/templates/jomsocial/layouts/profile/base.php:7813 require Copy JROOT/components/com_community/templates/jomsocial/layouts/profile/base.php Copy JROOT/components/com_community/libraries/template.php:24012 CTemplate->fetch() Copy JROOT/components/com_community/views/profile/view.html.php:79611 CommunityViewProfile->profile() Copy JROOT/components/com_community/views/views.php:25110 CommunityView->get() Copy JROOT/components/com_community/controllers/profile.php:14549 CommunityProfileController->profile() Copy JROOT/components/com_community/controllers/profile.php:12028 CommunityProfileController->display() Copy JROOT/components/com_community/controllers/controller.php:3317 CommunityBaseController->execute() Copy JROOT/components/com_community/community.php:1456 require_once Copy JROOT/components/com_community/community.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
查询时间:1.07 ms 上次查询后:0.02 ms 查询内存:0.026 MB 查询前内存:24.569 MB 返回的行数:0
SELECT earned.* , badge.* , axs_points.points
FROM axs_awards_earned AS earned
JOIN axs_awards AS badge
LEFT JOIN axs_points ON JSON_UNQUOTE (axs_points.params->'$.award_id') = badge.id AND axs_points.user_id = 1621330
WHERE earned.user_id = 1621330
AND earned.badge_id = badge.id
AND (badge.type = 'badge' OR badge.type = '')
AND badge.enabled = 1
GROUP BY earned.award_idid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE earned NULL ref PRIMARY,award_id PRIMARY 4 const 1 100.00 Using temporary; 使用文件排序 1 SIMPLE badge NULL eq_ref PRIMARY PRIMARY 4 root_db.earned.badge_id 1 12.50 Using where 1 SIMPLE axs_points NULL ALL NULL 不能使用任何索引键 NULL NULL 1 100.00 Using where; Using join buffer (Block Nested Loop)
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 checking permissions 0.01 ms checking permissions 0.00 ms sending cached result to clien 0.04 ms cleaned up 0.01 ms cleaning up 0.00 ms
# 呼叫者 文件和行号 20 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172119 JDatabaseDriver->loadObjectList() Copy JROOT/modules/mod_award/helper.php:5218 ModAwardHelper::makeBadges() Copy JROOT/modules/mod_award/helper.php:2517 ModAwardHelper::makeAward() Copy JROOT/modules/mod_award/mod_award.php:1716 include Copy JROOT/modules/mod_award/mod_award.php Copy JROOT/libraries/cms/module/helper.php:19815 JModuleHelper::renderModule() Copy JROOT/components/com_community/libraries/template.php:38714 CTemplate::renderModules() Copy JROOT/components/com_community/templates/jomsocial/layouts/profile/base.php:7813 require Copy JROOT/components/com_community/templates/jomsocial/layouts/profile/base.php Copy JROOT/components/com_community/libraries/template.php:24012 CTemplate->fetch() Copy JROOT/components/com_community/views/profile/view.html.php:79611 CommunityViewProfile->profile() Copy JROOT/components/com_community/views/views.php:25110 CommunityView->get() Copy JROOT/components/com_community/controllers/profile.php:14549 CommunityProfileController->profile() Copy JROOT/components/com_community/controllers/profile.php:12028 CommunityProfileController->display() Copy JROOT/components/com_community/controllers/controller.php:3317 CommunityBaseController->execute() Copy JROOT/components/com_community/community.php:1456 require_once Copy JROOT/components/com_community/community.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
查询时间:1.02 ms 上次查询后:0.02 ms 查询内存:0.026 MB 查询前内存:24.579 MB 返回的行数:1
SELECT sef FROM joom_languages WHERE lang_code = 'zh-CN ' LIMIT 1id 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.02 ms cleaning up 0.00 ms
# 呼叫者 文件和行号 21 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:168220 JDatabaseDriver->loadObject() Copy JROOT/libraries/axslibs/language.php:28519 AxsLanguage::getSefByLangCode() Copy JROOT/modules/mod_award/helper.php:5718 ModAwardHelper::makeBadges() Copy JROOT/modules/mod_award/helper.php:2517 ModAwardHelper::makeAward() Copy JROOT/modules/mod_award/mod_award.php:1716 include Copy JROOT/modules/mod_award/mod_award.php Copy JROOT/libraries/cms/module/helper.php:19815 JModuleHelper::renderModule() Copy JROOT/components/com_community/libraries/template.php:38714 CTemplate::renderModules() Copy JROOT/components/com_community/templates/jomsocial/layouts/profile/base.php:7813 require Copy JROOT/components/com_community/templates/jomsocial/layouts/profile/base.php Copy JROOT/components/com_community/libraries/template.php:24012 CTemplate->fetch() Copy JROOT/components/com_community/views/profile/view.html.php:79611 CommunityViewProfile->profile() Copy JROOT/components/com_community/views/views.php:25110 CommunityView->get() Copy JROOT/components/com_community/controllers/profile.php:14549 CommunityProfileController->profile() Copy JROOT/components/com_community/controllers/profile.php:12028 CommunityProfileController->display() Copy JROOT/components/com_community/controllers/controller.php:3317 CommunityBaseController->execute() Copy JROOT/components/com_community/community.php:1456 require_once Copy JROOT/components/com_community/community.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
查询时间:1.02 ms 上次查询后:0.02 ms 查询内存:0.026 MB 查询前内存:24.591 MB 返回的行数:1
SELECT id, title
FROM axs_points_categories
WHERE enabled = 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE axs_points_categories 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
# 呼叫者 文件和行号 20 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172119 JDatabaseDriver->loadObjectList() Copy JROOT/modules/mod_award/helper.php:34218 ModAwardHelper::makeCertificates() Copy JROOT/modules/mod_award/helper.php:2617 ModAwardHelper::makeAward() Copy JROOT/modules/mod_award/mod_award.php:1716 include Copy JROOT/modules/mod_award/mod_award.php Copy JROOT/libraries/cms/module/helper.php:19815 JModuleHelper::renderModule() Copy JROOT/components/com_community/libraries/template.php:38714 CTemplate::renderModules() Copy JROOT/components/com_community/templates/jomsocial/layouts/profile/base.php:7813 require Copy JROOT/components/com_community/templates/jomsocial/layouts/profile/base.php Copy JROOT/components/com_community/libraries/template.php:24012 CTemplate->fetch() Copy JROOT/components/com_community/views/profile/view.html.php:79611 CommunityViewProfile->profile() Copy JROOT/components/com_community/views/views.php:25110 CommunityView->get() Copy JROOT/components/com_community/controllers/profile.php:14549 CommunityProfileController->profile() Copy JROOT/components/com_community/controllers/profile.php:12028 CommunityProfileController->display() Copy JROOT/components/com_community/controllers/controller.php:3317 CommunityBaseController->execute() Copy JROOT/components/com_community/community.php:1456 require_once Copy JROOT/components/com_community/community.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
查询时间:1.03 ms 上次查询后:0.02 ms 查询内存:0.026 MB 查询前内存:24.600 MB 返回的行数:0
SELECT earned.* , badge.* , axs_points.points
FROM axs_awards_earned AS earned
JOIN axs_awards AS badge
LEFT JOIN axs_points ON JSON_UNQUOTE (axs_points.params->'$.award_id') = badge.id AND axs_points.user_id = 1621330
WHERE earned.user_id = 1621330
AND earned.badge_id = badge.id
AND badge.type = 'certificate'
AND badge.enabled = 1
GROUP BY earned.award_idid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE earned NULL ref PRIMARY,award_id PRIMARY 4 const 1 100.00 Using temporary; 使用文件排序 1 SIMPLE badge NULL eq_ref PRIMARY PRIMARY 4 root_db.earned.badge_id 1 12.50 Using where 1 SIMPLE axs_points NULL ALL NULL 不能使用任何索引键 NULL NULL 1 100.00 Using where; Using join buffer (Block Nested Loop)
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 checking permissions 0.01 ms checking permissions 0.00 ms sending cached result to clien 0.03 ms cleaned up 0.02 ms cleaning up 0.01 ms
# 呼叫者 文件和行号 20 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172119 JDatabaseDriver->loadObjectList() Copy JROOT/modules/mod_award/helper.php:35518 ModAwardHelper::makeCertificates() Copy JROOT/modules/mod_award/helper.php:2617 ModAwardHelper::makeAward() Copy JROOT/modules/mod_award/mod_award.php:1716 include Copy JROOT/modules/mod_award/mod_award.php Copy JROOT/libraries/cms/module/helper.php:19815 JModuleHelper::renderModule() Copy JROOT/components/com_community/libraries/template.php:38714 CTemplate::renderModules() Copy JROOT/components/com_community/templates/jomsocial/layouts/profile/base.php:7813 require Copy JROOT/components/com_community/templates/jomsocial/layouts/profile/base.php Copy JROOT/components/com_community/libraries/template.php:24012 CTemplate->fetch() Copy JROOT/components/com_community/views/profile/view.html.php:79611 CommunityViewProfile->profile() Copy JROOT/components/com_community/views/views.php:25110 CommunityView->get() Copy JROOT/components/com_community/controllers/profile.php:14549 CommunityProfileController->profile() Copy JROOT/components/com_community/controllers/profile.php:12028 CommunityProfileController->display() Copy JROOT/components/com_community/controllers/controller.php:3317 CommunityBaseController->execute() Copy JROOT/components/com_community/community.php:1456 require_once Copy JROOT/components/com_community/community.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
查询时间:1.09 ms 上次查询后:14.66 ms 查询内存:0.022 MB 查询前内存:25.053 MB 返回的行数:0
SELECT a.`params`, a.`id`, a.`link`, a.title as name, a.`parent_id`, false as script FROM `joom_menu ` AS a LEFT JOIN `joom_menu ` AS b ON b.`id`= a.`parent_id` AND b.`published`= '1' WHERE a.`published`= '1' AND a.`menutype`= 'jomsocial' AND a.`access`= '0' ORDER BY a.`lft`id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL ref idx_menutype idx_menutype 98 const 33 1.00 Using index condition; Using where; 使用文件排序 1 SIMPLE b NULL eq_ref PRIMARY PRIMARY 4 root_db.a.parent_id 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.00 ms sending cached result to clien 0.05 ms cleaned up 0.01 ms cleaning up 0.01 ms
# 呼叫者 文件和行号 13 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172112 JDatabaseDriver->loadObjectList() Copy JROOT/components/com_community/models/toolbar.php:7211 CommunityModelToolbar->getItems() Copy JROOT/components/com_community/libraries/toolbar.php:44310 CToolbarLibrary->__construct() Copy JROOT/components/com_community/libraries/toolbar.php:4539 CToolbarLibrary::getInstance() Copy JROOT/components/com_community/views/views.php:1408 CommunityView->showToolbar() Copy JROOT/components/com_community/controllers/controller.php:3447 CommunityBaseController->execute() Copy JROOT/components/com_community/community.php:1456 require_once Copy JROOT/components/com_community/community.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
查询时间:1.08 ms 上次查询后:4.51 ms 查询内存:0.021 MB 查询前内存:25.214 MB 返回的行数:1
SELECT language,id
FROM `joom_menu `
WHERE home = 1 AND published = 1 AND client_id = 0id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE 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.00 ms
# 呼叫者 文件和行号 10 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:17219 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/cms/language/multilang.php:1068 JLanguageMultilang::getSiteHomePages() Copy JROOT/plugins/system/languagefilter/languagefilter.php:7297 PlgSystemLanguageFilter->onAfterDispatch() Copy JROOT/libraries/joomla/event/event.php:706 JEvent->update() Copy JROOT/libraries/joomla/event/dispatcher.php:1605 JEventDispatcher->trigger() Copy JROOT/libraries/joomla/application/base.php:1064 JApplicationBase->triggerEvent() Copy JROOT/libraries/cms/application/site.php:1963 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
查询时间:1.12 ms 上次查询后:2.97 ms 查询内存:0.022 MB 查询前内存:25.552 MB 返回的行数:1
SELECT *
FROM `currency`
WHERE `base_currency`= 1 LIMIT 1id 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.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() Copy JROOT/libraries/joomla/database/driver.php:168211 JDatabaseDriver->loadObject() Copy JROOT/libraries/axslibs/currency.php:8410 AxsCurrency->getBaseCurrency() Copy JROOT/libraries/axslibs/currency.php:229 AxsCurrency->__construct() Copy JROOT/templates/axs/home.php:208 include Copy JROOT/templates/axs/home.php Copy JROOT/templates/axs/index.php:587 require Copy JROOT/templates/axs/index.php Copy JROOT/libraries/joomla/document/html.php:6536 JDocumentHtml->_loadTemplate() Copy JROOT/libraries/joomla/document/html.php:7155 JDocumentHtml->_fetchTemplate() Copy JROOT/libraries/joomla/document/html.php:5304 JDocumentHtml->parse() Copy JROOT/libraries/cms/application/cms.php:11733 JApplicationCms->render() Copy JROOT/libraries/cms/application/site.php:7822 JApplicationSite->render() Copy JROOT/libraries/cms/application/cms.php:2711 JApplicationCms->execute() Copy JROOT/index.php:72
查询时间:1.04 ms 上次查询后:0.11 ms 查询内存:0.023 MB 查询前内存:25.558 MB 返回的行数:10
SELECT * FROM axs_fonts WHERE enabled = 1id 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.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
# 呼叫者 文件和行号 11 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172110 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/axslibs/fonts.php:349 AxsFonts::getFonts() Copy JROOT/templates/axs/home.php:938 include Copy JROOT/templates/axs/home.php Copy JROOT/templates/axs/index.php:587 require Copy JROOT/templates/axs/index.php Copy JROOT/libraries/joomla/document/html.php:6536 JDocumentHtml->_loadTemplate() Copy JROOT/libraries/joomla/document/html.php:7155 JDocumentHtml->_fetchTemplate() Copy JROOT/libraries/joomla/document/html.php:5304 JDocumentHtml->parse() Copy JROOT/libraries/cms/application/cms.php:11733 JApplicationCms->render() Copy JROOT/libraries/cms/application/site.php:7822 JApplicationSite->render() Copy JROOT/libraries/cms/application/cms.php:2711 JApplicationCms->execute() Copy JROOT/index.php:72
查询时间:0.96 ms 上次查询后:0.20 ms 查询内存:0.022 MB 查询前内存:25.594 MB 返回的行数:0
SELECT *
FROM accessibility_images
WHERE `path`= 'images/pDJC5BxLjAW4jMgmh4ZjVUqCNDU3NDQ2OTkwOTMw/graphics/blue-logo.png' AND enabled= 1id 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.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
# 呼叫者 文件和行号 12 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:168211 JDatabaseDriver->loadObject() Copy JROOT/libraries/axslibs/accessibility.php:4210 AxsAccessibility::query() Copy JROOT/libraries/axslibs/accessibility.php:499 AxsAccessibility::image() Copy JROOT/templates/axs/home.php:8058 include Copy JROOT/templates/axs/home.php Copy JROOT/templates/axs/index.php:587 require Copy JROOT/templates/axs/index.php Copy JROOT/libraries/joomla/document/html.php:6536 JDocumentHtml->_loadTemplate() Copy JROOT/libraries/joomla/document/html.php:7155 JDocumentHtml->_fetchTemplate() Copy JROOT/libraries/joomla/document/html.php:5304 JDocumentHtml->parse() Copy JROOT/libraries/cms/application/cms.php:11733 JApplicationCms->render() Copy JROOT/libraries/cms/application/site.php:7822 JApplicationSite->render() Copy JROOT/libraries/cms/application/cms.php:2711 JApplicationCms->execute() Copy JROOT/index.php:72
查询时间:1.32 ms 上次查询后:1.47 ms 查询内存:0.022 MB 查询前内存:25.645 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.02 ms checking query cache for query 0.11 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.05 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.02 ms preparing 0.03 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 cleaned up 0.01 ms cleaning up 0.01 ms
# 呼叫者 文件和行号 11 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172110 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/axslibs/notifications.php:179 AxsNotifications::loadNotifications() Copy JROOT/templates/axs/home.php:17948 include Copy JROOT/templates/axs/home.php Copy JROOT/templates/axs/index.php:587 require Copy JROOT/templates/axs/index.php Copy JROOT/libraries/joomla/document/html.php:6536 JDocumentHtml->_loadTemplate() Copy JROOT/libraries/joomla/document/html.php:7155 JDocumentHtml->_fetchTemplate() Copy JROOT/libraries/joomla/document/html.php:5304 JDocumentHtml->parse() Copy JROOT/libraries/cms/application/cms.php:11733 JApplicationCms->render() Copy JROOT/libraries/cms/application/site.php:7822 JApplicationSite->render() Copy JROOT/libraries/cms/application/cms.php:2711 JApplicationCms->execute() Copy JROOT/index.php:72
查询时间:1.13 ms 上次查询后:3.62 ms 查询内存:0.026 MB 查询前内存:25.832 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.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.05 ms cleaned up 0.01 ms cleaning up 0.00 ms
# 呼叫者 文件和行号 22 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:148521 JDatabaseDriver->loadAssoc() Copy JROOT/libraries/joomla/table/table.php:72920 JTable->load() Copy JROOT/administrator/components/com_easyblog/includes/easyblog.php:41519 EB::config() Copy JROOT/components/com_easyblog/router.php:1918 EasyBlogBuildRoute() Copy JROOT/libraries/cms/component/router/legacy.php:6817 JComponentRouterLegacy->build() Copy JROOT/libraries/cms/router/site.php:51916 JRouterSite->buildSefRoute() Copy JROOT/libraries/cms/router/site.php:48915 JRouterSite->_buildSefRoute() Copy JROOT/libraries/cms/router/router.php:28214 JRouter->build() Copy JROOT/libraries/cms/router/site.php:14913 JRouterSite->build() Copy JROOT/libraries/joomla/application/route.php:6212 JRoute::_() Copy JROOT/modules/mod_defaultmenu/helper.php:13411 ModDefaultHelper::getList() Copy JROOT/modules/mod_defaultmenu/mod_defaultmenu.php:1510 include Copy JROOT/modules/mod_defaultmenu/mod_defaultmenu.php Copy JROOT/libraries/cms/module/helper.php:1989 JModuleHelper::renderModule() Copy JROOT/libraries/joomla/document/renderer/html/module.php:938 JDocumentRendererHtmlModule->render() Copy JROOT/libraries/joomla/document/renderer/html/modules.php:427 JDocumentRendererHtmlModules->render() Copy JROOT/libraries/joomla/document/html.php:4866 JDocumentHtml->getBuffer() Copy JROOT/libraries/joomla/document/html.php:7775 JDocumentHtml->_renderTemplate() Copy JROOT/libraries/joomla/document/html.php:5524 JDocumentHtml->render() Copy JROOT/libraries/cms/application/cms.php:11903 JApplicationCms->render() Copy JROOT/libraries/cms/application/site.php:7822 JApplicationSite->render() Copy JROOT/libraries/cms/application/cms.php:2711 JApplicationCms->execute() Copy JROOT/index.php:72
查询时间:1.11 ms 上次查询后:1.46 ms 查询内存:0.028 MB 查询前内存:26.062 MB 返回的行数:1
SELECT * FROM joom_kunena_configuration WHERE id= 1id 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.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.00 ms
# 呼叫者 文件和行号 28 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:148527 JDatabaseDriver->loadAssoc() Copy JROOT/libraries/kunena/config.php:130626 KunenaConfig->load() Copy JROOT/libraries/kunena/config.php:123925 KunenaConfig::getInstance() Copy JROOT/libraries/kunena/factory.php:2824 KunenaFactory::getConfig() Copy JROOT/libraries/kunena/route/route.php:48023 KunenaRoute::initialize() Copy JROOT/libraries/kunena/route/route.php:1722 include Copy JROOT/libraries/kunena/route/route.php Copy JROOT/libraries/loader.php:71621 JLoader::_load() Copy JROOT/libraries/loader.php:67120 JLoader::_autoload() 与下面一行中的调用相同。 19 spl_autoload_call() Copy JROOT/components/com_kunena/router.php:3818 KunenaBuildRoute() Copy JROOT/libraries/cms/component/router/legacy.php:6817 JComponentRouterLegacy->build() Copy JROOT/libraries/cms/router/site.php:51916 JRouterSite->buildSefRoute() Copy JROOT/libraries/cms/router/site.php:48915 JRouterSite->_buildSefRoute() Copy JROOT/libraries/cms/router/router.php:28214 JRouter->build() Copy JROOT/libraries/cms/router/site.php:14913 JRouterSite->build() Copy JROOT/libraries/joomla/application/route.php:6212 JRoute::_() Copy JROOT/modules/mod_defaultmenu/helper.php:13411 ModDefaultHelper::getList() Copy JROOT/modules/mod_defaultmenu/mod_defaultmenu.php:1510 include Copy JROOT/modules/mod_defaultmenu/mod_defaultmenu.php Copy JROOT/libraries/cms/module/helper.php:1989 JModuleHelper::renderModule() Copy JROOT/libraries/joomla/document/renderer/html/module.php:938 JDocumentRendererHtmlModule->render() Copy JROOT/libraries/joomla/document/renderer/html/modules.php:427 JDocumentRendererHtmlModules->render() Copy JROOT/libraries/joomla/document/html.php:4866 JDocumentHtml->getBuffer() Copy JROOT/libraries/joomla/document/html.php:7775 JDocumentHtml->_renderTemplate() Copy JROOT/libraries/joomla/document/html.php:5524 JDocumentHtml->render() Copy JROOT/libraries/cms/application/cms.php:11903 JApplicationCms->render() Copy JROOT/libraries/cms/application/site.php:7822 JApplicationSite->render() Copy JROOT/libraries/cms/application/cms.php:2711 JApplicationCms->execute() Copy JROOT/index.php:72
查询时间:1.06 ms 上次查询后:2.34 ms 查询内存:0.024 MB 查询前内存:26.272 MB 返回的行数:1
SELECT special_characters FROM joom_languages WHERE sef = 'zh' LIMIT 1id 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.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.20 ms cleaned up 0.02 ms cleaning up 0.01 ms
# 呼叫者 文件和行号 16 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:168215 JDatabaseDriver->loadObject() Copy JROOT/libraries/axslibs/language.php:30814 AxsLanguage::getSpecialCharacters() Copy JROOT/libraries/axslibs/language.php:2613 AxsLanguage::translate() Copy JROOT/modules/mod_defaultmenu/tmpl/default_component.php:2112 require Copy JROOT/modules/mod_defaultmenu/tmpl/default_component.php Copy JROOT/modules/mod_defaultmenu/tmpl/default.php:7211 require Copy JROOT/modules/mod_defaultmenu/tmpl/default.php Copy JROOT/modules/mod_defaultmenu/mod_defaultmenu.php:2510 include Copy JROOT/modules/mod_defaultmenu/mod_defaultmenu.php Copy JROOT/libraries/cms/module/helper.php:1989 JModuleHelper::renderModule() Copy JROOT/libraries/joomla/document/renderer/html/module.php:938 JDocumentRendererHtmlModule->render() Copy JROOT/libraries/joomla/document/renderer/html/modules.php:427 JDocumentRendererHtmlModules->render() Copy JROOT/libraries/joomla/document/html.php:4866 JDocumentHtml->getBuffer() Copy JROOT/libraries/joomla/document/html.php:7775 JDocumentHtml->_renderTemplate() Copy JROOT/libraries/joomla/document/html.php:5524 JDocumentHtml->render() Copy JROOT/libraries/cms/application/cms.php:11903 JApplicationCms->render() Copy JROOT/libraries/cms/application/site.php:7822 JApplicationSite->render() Copy JROOT/libraries/cms/application/cms.php:2711 JApplicationCms->execute() Copy JROOT/index.php:72
查询时间:1.06 ms 上次查询后:0.03 ms 查询内存:0.025 MB 查询前内存:26.282 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.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
# 呼叫者 文件和行号 16 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:152615 JDatabaseDriver->loadAssocList() Copy JROOT/libraries/axslibs/language.php:15014 AxsLanguage::getTranslationMap() Copy JROOT/libraries/axslibs/language.php:3913 AxsLanguage::translate() Copy JROOT/modules/mod_defaultmenu/tmpl/default_component.php:2112 require Copy JROOT/modules/mod_defaultmenu/tmpl/default_component.php Copy JROOT/modules/mod_defaultmenu/tmpl/default.php:7211 require Copy JROOT/modules/mod_defaultmenu/tmpl/default.php Copy JROOT/modules/mod_defaultmenu/mod_defaultmenu.php:2510 include Copy JROOT/modules/mod_defaultmenu/mod_defaultmenu.php Copy JROOT/libraries/cms/module/helper.php:1989 JModuleHelper::renderModule() Copy JROOT/libraries/joomla/document/renderer/html/module.php:938 JDocumentRendererHtmlModule->render() Copy JROOT/libraries/joomla/document/renderer/html/modules.php:427 JDocumentRendererHtmlModules->render() Copy JROOT/libraries/joomla/document/html.php:4866 JDocumentHtml->getBuffer() Copy JROOT/libraries/joomla/document/html.php:7775 JDocumentHtml->_renderTemplate() Copy JROOT/libraries/joomla/document/html.php:5524 JDocumentHtml->render() Copy JROOT/libraries/cms/application/cms.php:11903 JApplicationCms->render() Copy JROOT/libraries/cms/application/site.php:7822 JApplicationSite->render() Copy JROOT/libraries/cms/application/cms.php:2711 JApplicationCms->execute() Copy JROOT/index.php:72
查询时间:1.13 ms 上次查询后:2.34 ms 查询内存:0.023 MB 查询前内存:26.341 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 = 711id 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.01 ms checking permissions 0.01 ms sending cached result to clien 0.05 ms cleaned up 0.01 ms cleaning up 0.00 ms
# 呼叫者 文件和行号 15 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172114 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/cms/language/associations.php:10113 JLanguageAssociations::getAssociations() Copy JROOT/administrator/components/com_menus/helpers/menus.php:31312 MenusHelper::getAssociations() Copy JROOT/modules/mod_language_selector/tmpl/default.php:9111 require Copy JROOT/modules/mod_language_selector/tmpl/default.php Copy JROOT/modules/mod_language_selector/mod_language_selector.php:410 include Copy JROOT/modules/mod_language_selector/mod_language_selector.php Copy JROOT/libraries/cms/module/helper.php:1989 JModuleHelper::renderModule() Copy JROOT/libraries/joomla/document/renderer/html/module.php:938 JDocumentRendererHtmlModule->render() Copy JROOT/libraries/joomla/document/renderer/html/modules.php:427 JDocumentRendererHtmlModules->render() Copy JROOT/libraries/joomla/document/html.php:4866 JDocumentHtml->getBuffer() Copy JROOT/libraries/joomla/document/html.php:7775 JDocumentHtml->_renderTemplate() Copy JROOT/libraries/joomla/document/html.php:5524 JDocumentHtml->render() Copy JROOT/libraries/cms/application/cms.php:11903 JApplicationCms->render() Copy JROOT/libraries/cms/application/site.php:7822 JApplicationSite->render() Copy JROOT/libraries/cms/application/cms.php:2711 JApplicationCms->execute() Copy JROOT/index.php:72
9 × SELECT `id` FROM `joom_menu ` 5 × SELECT `id` FROM `joom_users ` 5 × SELECT `value` FROM `joom_community_fields_values ` 2 × SELECT GROUP_CONCAT (DISTINCT b.`activity_id`) as activity_id FROM `joom_community_activities_hide ` as b 2 × SELECT extension_id FROM joom_extensions 2 × SELECT a.* FROM `joom_community_activities ` as a LEFT JOIN `joom_kunena_topics ` as b ON (a.cid = b.id AND a.app = 'kunena.thread.post') LEFT JOIN `joom_kunena_categories ` as c ON (b.category_id = c.id AND a.app = 'kunena.thread.post') 2 × SELECT cid FROM `joom_community_featured ` 2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `joom_extensions ` 2 × SELECT `id` FROM `joom_community_videos ` 2 × SELECT DISTINCT a.`id` FROM `joom_community_events ` AS a LEFT JOIN `joom_community_events_members ` AS b ON a.`id`= b.`eventid` 2 × SELECT `params` FROM `joom_extensions ` 2 × SELECT `extension_id` FROM `joom_extensions ` 2 × SELECT * FROM `joom_community_likes ` 2 × SELECT field.* , value.`value`,value.`access`, value.`params` as fieldparams FROM `joom_community_fields ` AS field LEFT JOIN `joom_community_fields_values ` AS value ON field.`id`= value.`field_id` AND value.`user_id`= '1621330' 2 × SELECT `id` FROM `joom_community_photos_albums ` 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.`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' 2 × SELECT connection_id FROM `joom_community_connection ` 2 × SELECT * FROM joom_community_badges 2 × SELECT id, title FROM axs_points_categories 2 × SELECT * FROM joom_languages 1 × SELECT id, count FROM `joom_community_profile_stats ` 1 × SELECT * FROM `joom_community_moods ` 1 × SELECT * FROM axs_translations 1 × SELECT COUNT (* ) FROM `joom_community_groups_members ` AS a INNER JOIN `joom_community_groups ` AS b 1 × SELECT special_characters FROM joom_languages 1 × SELECT * FROM joom_kunena_configuration 1 × SELECT * FROM joom_easyblog_configs 1 × SELECT COUNT (* ) FROM `joom_community_events_members ` AS a INNER JOIN `joom_community_events ` AS b ON b.`id`= a.`eventid` AND b.`enddate` > '2024-08-08 08:37:49' 1 × SELECT COUNT (1) FROM `joom_community_videos ` AS a 1 × SELECT * FROM axs_notifications 1 × SELECT COUNT (1) FROM `joom_community_photos ` AS a INNER JOIN `joom_community_photos_albums ` AS b ON a.albumid= b.id 1 × SELECT COUNT (1) FROM `joom_community_featured ` 1 × SELECT * FROM axs_fonts 1 × SELECT * FROM accessibility_images 1 × SELECT * FROM axs_lms_settings 1 × SELECT * FROM table_keys 1 × SELECT AUTO_INCREMENT FROM `information_schema`.`TABLES ` 1 × SELECT * FROM `currency` 1 × SELECT language,id FROM `joom_menu ` 1 × SELECT b.id FROM joom_user_usergroup_map AS map LEFT JOIN joom_usergroups AS a ON a.id = map.group_id LEFT JOIN joom_usergroups AS b ON b.lft <= a.lft AND b.rgt >= a.rgt 1 × SELECT a.`params`, a.`id`, a.`link`, a.title as name, a.`parent_id`, false as script FROM `joom_menu ` AS a LEFT JOIN `joom_menu ` AS b ON b.`id`= a.`parent_id` AND b.`published`= '1' 1 × SELECT earned.* , badge.* , axs_points.points FROM axs_awards_earned AS earned JOIN axs_awards AS badge LEFT JOIN axs_points ON JSON_UNQUOTE (axs_points.params->'$.award_id') = badge.id AND axs_points.user_id = 1621330 1 × SELECT sef FROM joom_languages 1 × SELECT earned.* , badge.* , axs_points.points FROM axs_awards_earned AS earned JOIN axs_awards AS badge LEFT JOIN axs_points ON JSON_UNQUOTE (axs_points.params->'$.award_id') = badge.id AND axs_points.user_id = 1621330 1 × SELECT * FROM `joom_community_theme ` 1 × SELECT * FROM `joom_community_featured ` 1 × SELECT SUM (points) AS totalPoints FROM axs_points 1 × SELECT * from `joom_community_users ` 1 × SELECT `session_id` FROM `joom_session ` 1 × SELECT count(* ) FROM `joom_community_connection ` as a, `joom_users ` as b 1 × SELECT params FROM axs_user_settings 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 * FROM axs_integrations 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 `id`,`title` FROM `joom_usergroups ` 1 × SELECT `userid` FROM `joom_community_users ` 1 × SELECT * FROM `joom_users ` 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 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_community_config 1 × SELECT * FROM joom_extensions 1 × SELECT `id` FROM `joom_community_fields ` 1 × SELECT `id`,`name`,`rules`,`parent_id` FROM `joom_assets ` 1 × SELECT `id`,`parent_id` FROM `joom_menu ` 1 × SELECT `element` FROM `joom_extensions ` 1 × SELECT DISTINCT a.* FROM `joom_community_apps ` AS a 1 × SELECT `name` FROM `joom_extensions ` 1 × SELECT * FROM `joom_community_apps ` 1 × SELECT m.* ,n.`name` FROM `joom_community_blocklist ` m LEFT JOIN `joom_users ` n ON m.`blocked_userid`= n.`id` 1 × SELECT `id` FROM `joom_community_groups ` 1 × SELECT `groupid` FROM `joom_community_groups_members ` 1 × SELECT COUNT (1) FROM `joom_community_activities ` 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`