クエリ時間:1.35 ms クエリメモリ:0.046 MB クエリ前のメモリ:4.341 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
クエリ時間:0.65 ms 最後のクエリの後:1.17 ms クエリメモリ:0.021 MB クエリ前のメモリ:4.552 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
クエリ時間:0.64 ms 最後のクエリの後:0.04 ms クエリメモリ:0.021 MB クエリ前のメモリ:4.564 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.06 ms 最後のクエリの後:0.34 ms クエリメモリ:0.046 MB クエリ前のメモリ:4.626 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; filesortの使用
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.06 ms 最後のクエリの後:8.71 ms クエリメモリ:0.024 MB クエリ前のメモリ:5.535 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
クエリ時間:4.71 ms 最後のクエリの後:0.06 ms クエリメモリ:0.006 MB クエリ前のメモリ:5.527 MB
UPDATE `joom_extensions `
SET `params` = '{\"mediaversion\":\"85b3ce29fe65551606910474ae74bd3f\"}'
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
クエリ時間:0.73 ms 最後のクエリの後:12.21 ms クエリメモリ:0.029 MB クエリ前のメモリ:8.019 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; filesortの使用
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
# 発信者 ファイルと行番号 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
クエリ時間:0.64 ms 最後のクエリの後:0.39 ms クエリメモリ:0.021 MB クエリ前のメモリ:8.090 MB 返された行:1
SELECT * FROM axs_domains WHERE domain = 'k8s.intg.tovuti.io'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE axs_domains NULL ALL NULL インデックスキーを使用できませんでした NULL NULL 1 100.00 Using where
Status Duration starting 0.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
# 発信者 ファイルと行番号 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.20 ms 最後のクエリの後:0.05 ms クエリメモリ:0.030 MB クエリ前のメモリ:8.099 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
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.07 ms preparing 0.02 ms executing 0.00 ms Sending data 0.29 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
# 発信者 ファイルと行番号 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
クエリ時間:0.77 ms 最後のクエリの後:0.91 ms クエリメモリ:0.022 MB クエリ前のメモリ:8.231 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
Status Duration starting 0.03 ms checking query cache for query 0.01 ms checking privileges on cached 0.00 ms checking permissions 0.02 ms sending cached result to clien 0.03 ms cleaned up 0.01 ms cleaning up 0.00 ms
# 発信者 ファイルと行番号 13 JDatabaseDriverMysqli->execute() 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.62 ms 最後のクエリの後:0.04 ms クエリメモリ:0.030 MB クエリ前のメモリ:8.253 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; filesortの使用
Status Duration starting 0.01 ms checking query cache for query 0.01 ms checking privileges on cached 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
# 発信者 ファイルと行番号 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
クエリ時間:0.75 ms 最後のクエリの後:1.04 ms クエリメモリ:0.021 MB クエリ前のメモリ:8.541 MB 返された行:1
SELECT * FROM `axs_homepage_templates` WHERE id= '1'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE axs_homepage_templates NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL
Status Duration starting 0.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.01 ms
# 発信者 ファイルと行番号 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.60 ms 最後のクエリの後:0.07 ms クエリメモリ:0.021 MB クエリ前のメモリ:8.581 MB 返された行:1
SELECT * FROM `axs_dashboard_templates` WHERE id= '2'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE axs_dashboard_templates NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL
Status Duration starting 0.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: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.67 ms 最後のクエリの後:0.07 ms クエリメモリ:0.022 MB クエリ前のメモリ:8.601 MB 返された行:1
SELECT *
FROM axs_email_settings
WHERE id = '1'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE axs_email_settings NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL
Status Duration starting 0.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
# 発信者 ファイルと行番号 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.61 ms 最後のクエリの後:0.04 ms クエリメモリ:0.022 MB クエリ前のメモリ:8.609 MB 返された行:1
SELECT *
FROM axs_payment_gateways
WHERE id = '1'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE axs_payment_gateways NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL
Status Duration starting 0.01 ms checking query cache for query 0.01 ms checking privileges on cached 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
# 発信者 ファイルと行番号 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.65 ms 最後のクエリの後:0.05 ms クエリメモリ:0.022 MB クエリ前のメモリ:8.620 MB 返された行:1
SELECT *
FROM axs_integrations
WHERE id = '1'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE axs_integrations NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL
Status Duration starting 0.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
# 発信者 ファイルと行番号 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
クエリ時間:1.97 ms 最後のクエリの後:8.84 ms クエリメモリ:0.102 MB クエリ前のメモリ:10.123 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; filesortの使用 1 SIMPLE e NULL eq_ref PRIMARY PRIMARY 4 root_db.m.component_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.00 ms checking permissions 0.12 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.04 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.06 ms preparing 0.03 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.01 ms Creating sort index 0.90 ms end 0.02 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.04 ms cleaned up 0.01 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 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.21 ms 最後のクエリの後:13.15 ms クエリメモリ:0.028 MB クエリ前のメモリ:12.463 MB 返された行:17
SHOW FULL COLUMNS FROM `joom_users `クエリではEXPLAINは使用できません:SHOW FULL COLUMNS FROM `joom_users`
Status Duration starting 0.07 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.01 ms checking permissions 0.03 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.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.00 ms freeing items 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/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
クエリ時間:0.62 ms 最後のクエリの後:0.26 ms クエリメモリ:0.022 MB クエリ前のメモリ:12.507 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
Status Duration starting 0.01 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
# 発信者 ファイルと行番号 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
クエリ時間:0.74 ms 最後のクエリの後:1.81 ms クエリメモリ:0.025 MB クエリ前のメモリ:12.871 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.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:148519 JDatabaseDriver->loadAssoc() Copy JROOT/libraries/kunena/config.php:130618 KunenaConfig->load() Copy JROOT/libraries/kunena/config.php:123917 KunenaConfig::getInstance() Copy JROOT/libraries/kunena/factory.php:2816 KunenaFactory::getConfig() Copy JROOT/libraries/kunena/route/route.php:48015 KunenaRoute::initialize() Copy JROOT/libraries/kunena/route/route.php:1714 include Copy JROOT/libraries/kunena/route/route.php Copy JROOT/libraries/loader.php:71613 JLoader::_load() Copy JROOT/libraries/loader.php:67112 JLoader::_autoload() 以下の行の呼び出しと同じです。 11 spl_autoload_call() Copy JROOT/components/com_kunena/router.php:30110 KunenaParseRoute() 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
クエリ時間:0.63 ms 最後のクエリの後:1.82 ms クエリメモリ:0.022 MB クエリ前のメモリ:13.034 MB 返された行:1
SELECT * FROM joom_kunena_aliases WHERE alias LIKE 'statistics%'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE joom_kunena_aliases NULL range alias alias 572 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.02 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:172112 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/kunena/route/route.php:45011 KunenaRoute::resolveAlias() Copy JROOT/components/com_kunena/router.php:31610 KunenaParseRoute() 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
クエリ時間:0.64 ms 最後のクエリの後:11.39 ms クエリメモリ:0.019 MB クエリ前のメモリ:13.539 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
Status Duration starting 0.03 ms checking query cache for query 0.01 ms checking privileges on cached 0.01 ms checking permissions 0.01 ms sending cached result to clien 0.02 ms cleaned up 0.02 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 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
クエリ時間:0.66 ms 最後のクエリの後:1.97 ms クエリメモリ:0.019 MB クエリ前のメモリ:13.867 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
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
# 発信者 ファイルと行番号 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.12 ms 最後のクエリの後:0.11 ms クエリメモリ:0.019 MB クエリ前のメモリ:13.875 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
Status Duration starting 0.01 ms checking query cache for query 0.01 ms checking privileges on cached 0.00 ms checking permissions 0.11 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.03 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.08 ms preparing 0.03 ms executing 0.00 ms Sending data 0.14 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.04 ms cleaned up 0.01 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 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.12 ms 最後のクエリの後:2.39 ms クエリメモリ:0.025 MB クエリ前のメモリ:14.097 MB 返された行:5
SHOW FULL COLUMNS FROM `joom_kunena_sessions `クエリではEXPLAINは使用できません:SHOW FULL COLUMNS FROM `joom_kunena_sessions`
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.01 ms checking permissions 0.03 ms checking permissions 0.03 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.04 ms closing tables 0.01 ms freeing items 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/libraries/joomla/database/driver/mysqli.php:42116 JDatabaseDriverMysqli->getTableColumns() Copy JROOT/libraries/joomla/table/table.php:24415 JTable->getFields() Copy JROOT/libraries/joomla/table/table.php:16314 JTable->__construct() Copy JROOT/libraries/kunena/tables/kunenasessions.php:3113 TableKunenaSessions->__construct() Copy JROOT/libraries/joomla/table/table.php:31112 JTable::getInstance() Copy JROOT/libraries/kunena/session.php:9611 KunenaSession->getTable() Copy JROOT/libraries/kunena/session.php:11010 KunenaSession->load() Copy JROOT/libraries/kunena/session.php:309 KunenaSession->__construct() Copy JROOT/libraries/kunena/session.php:608 KunenaSession::getInstance() Copy JROOT/libraries/kunena/factory.php:867 KunenaFactory::getSession() Copy JROOT/components/com_kunena/kunena.php:616 require_once Copy JROOT/components/com_kunena/kunena.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.51 ms 最後のクエリの後:5.39 ms クエリメモリ:0.035 MB クエリ前のメモリ:14.878 MB 返された行:51
SHOW FULL COLUMNS FROM `joom_kunena_users `クエリではEXPLAINは使用できません:SHOW FULL COLUMNS FROM `joom_kunena_users`
Status Duration starting 0.07 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.16 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.02 ms executing 0.01 ms Opening tables 0.02 ms checking permissions 0.07 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Sending data 0.11 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms removing tmp table 0.03 ms closing tables 0.01 ms freeing items 0.04 ms cleaned up 0.02 ms cleaning up 0.01 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/libraries/kunena/tables/kunenausers.php:32918 TableKunenaUsers->__construct() Copy JROOT/libraries/joomla/table/table.php:31117 JTable::getInstance() Copy JROOT/libraries/kunena/user/user.php:25216 KunenaUser->getTable() Copy JROOT/libraries/kunena/user/user.php:27515 KunenaUser->load() Copy JROOT/libraries/kunena/user/user.php:10014 KunenaUser->__construct() Copy JROOT/libraries/kunena/user/helper.php:5913 KunenaUserHelper::initialize() Copy JROOT/libraries/kunena/user/helper.php:1312 include Copy JROOT/libraries/kunena/user/helper.php Copy JROOT/libraries/loader.php:70211 JLoader::_load() Copy JROOT/libraries/loader.php:67110 JLoader::_autoload() 以下の行の呼び出しと同じです。 9 spl_autoload_call() Copy JROOT/libraries/kunena/controller/application/display.php:2158 KunenaControllerApplicationDisplay->before() Copy JROOT/libraries/kunena/controller/application/display.php:837 KunenaControllerApplicationDisplay->execute() Copy JROOT/components/com_kunena/kunena.php:966 require_once Copy JROOT/components/com_kunena/kunena.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 最後のクエリの後:0.40 ms クエリメモリ:0.025 MB クエリ前のメモリ:14.975 MB 返された行:0
SELECT a.`userid` as _userid , a.`status` as _status , a.`points` as _points, a.`posted_on` as _posted_on, a.`avatar` as _avatar , a.`thumb` as _thumb , a.`invite` as _invite, a.`params` as _cparams, a.`view` as _view, a.`friends` as _friends, a.`groups` as _groups, a.`events` as _events, a.`alias` as _alias, a.`profile_id` as _profile_id, a.`friendcount` as _friendcount, a.`storage` as _storage, a.`watermark_hash` as _watermark_hash, a.`search_email` AS _search_email, s.`userid` as _isonline, u.* FROM `joom_community_users ` as a LEFT JOIN `joom_users ` u ON u.`id`= a.`userid` LEFT OUTER JOIN `joom_session `s ON s.`userid`= a.`userid` WHERE a.`userid` IN (0)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE NULL NULL NULL NULL インデックスキーを使用できませんでした NULL NULL NULL NULL no matching row in const table
Status Duration starting 0.01 ms checking query cache for query 0.01 ms checking privileges on cached 0.01 ms checking permissions 0.16 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.04 ms System lock 0.03 ms optimizing 0.02 ms statistics 0.09 ms executing 0.02 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms storing result in query cache 0.01 ms cleaned up 0.01 ms cleaning up 0.02 ms
# 発信者 ファイルと行番号 17 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172116 JDatabaseDriver->loadObjectList() Copy JROOT/components/com_community/libraries/core.php:12415 CFactory::loadUsers() Copy JROOT/plugins/kunena/community/avatar.php:3714 KunenaAvatarCommunity->load() Copy JROOT/libraries/kunena/user/helper.php:6313 KunenaUserHelper::initialize() Copy JROOT/libraries/kunena/user/helper.php:1312 include Copy JROOT/libraries/kunena/user/helper.php Copy JROOT/libraries/loader.php:70211 JLoader::_load() Copy JROOT/libraries/loader.php:67110 JLoader::_autoload() 以下の行の呼び出しと同じです。 9 spl_autoload_call() Copy JROOT/libraries/kunena/controller/application/display.php:2158 KunenaControllerApplicationDisplay->before() Copy JROOT/libraries/kunena/controller/application/display.php:837 KunenaControllerApplicationDisplay->execute() Copy JROOT/components/com_kunena/kunena.php:966 require_once Copy JROOT/components/com_kunena/kunena.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.75 ms 最後のクエリの後:7.04 ms クエリメモリ:0.023 MB クエリ前のメモリ:15.971 MB 返された行:0
SELECT g.memberid AS user_id, c.id AS category_id, 2 AS role
FROM joom_kunena_categories AS c
INNER JOIN joom_community_groups_members AS g ON c.accesstype= 'jomsocial' AND c.access= g.groupid
WHERE c.published= 1 AND g.approved= 1 AND g.permissions= '1'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE c NULL ref category_access,published_pubaccess_id category_access 62 const 1 100.00 Using where 1 SIMPLE g NULL ref PRIMARY,groupid PRIMARY 4 root_db.c.access 1 100.00 Using where
Status Duration starting 0.03 ms checking query cache for query 0.01 ms checking privileges on cached 0.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
# 発信者 ファイルと行番号 15 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172114 JDatabaseDriver->loadObjectList() Copy JROOT/plugins/kunena/community/access.php:13613 KunenaAccessCommunity->loadCategoryRoles() Copy JROOT/libraries/kunena/access.php:12512 KunenaAccess->clearCache() Copy JROOT/libraries/kunena/access.php:8211 KunenaAccess->__construct() Copy JROOT/libraries/kunena/access.php:9710 KunenaAccess::getInstance() Copy JROOT/libraries/kunena/user/user.php:4419 KunenaUser->isAdmin() Copy JROOT/libraries/kunena/controller/application/display.php:2218 KunenaControllerApplicationDisplay->before() Copy JROOT/libraries/kunena/controller/application/display.php:837 KunenaControllerApplicationDisplay->execute() Copy JROOT/components/com_kunena/kunena.php:966 require_once Copy JROOT/components/com_kunena/kunena.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.70 ms 最後のクエリの後:0.10 ms クエリメモリ:0.030 MB クエリ前のメモリ:15.991 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.01 ms checking permissions 0.01 ms sending cached result to clien 0.03 ms cleaned up 0.01 ms cleaning up 0.01 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/plugins/kunena/joomla/access.php:46114 KunenaAccessJoomla->getAuthorisedUsers() Copy JROOT/plugins/kunena/joomla/access.php:23313 KunenaAccessJoomla->loadCategoryRoles() Copy JROOT/libraries/kunena/access.php:12512 KunenaAccess->clearCache() Copy JROOT/libraries/kunena/access.php:8211 KunenaAccess->__construct() Copy JROOT/libraries/kunena/access.php:9710 KunenaAccess::getInstance() Copy JROOT/libraries/kunena/user/user.php:4419 KunenaUser->isAdmin() Copy JROOT/libraries/kunena/controller/application/display.php:2218 KunenaControllerApplicationDisplay->before() Copy JROOT/libraries/kunena/controller/application/display.php:837 KunenaControllerApplicationDisplay->execute() Copy JROOT/components/com_kunena/kunena.php:966 require_once Copy JROOT/components/com_kunena/kunena.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.63 ms 最後のクエリの後:0.33 ms クエリメモリ:0.024 MB クエリ前のメモリ:16.089 MB 返された行:5
SELECT DISTINCT (user_id)
FROM joom_usergroups as ug1
INNER JOIN joom_usergroups AS ug2 ON ug2.lft>= ug1.lft AND ug1.rgt>= ug2.rgt
INNER JOIN joom_user_usergroup_map AS m ON ug2.id= m.group_id
WHERE ug1.id IN (8)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE ug1 NULL const PRIMARY,idx_usergroup_nested_set_lookup PRIMARY 4 const 1 100.00 Using temporary 1 SIMPLE ug2 NULL range PRIMARY,idx_usergroup_nested_set_lookup idx_usergroup_nested_set_lookup 4 NULL 74 33.33 Using where; Using index 1 SIMPLE m NULL ref PRIMARY,group_id,user_id group_id 4 root_db.ug2.id 106 100.00 Using index
Status Duration starting 0.01 ms checking query cache for query 0.01 ms checking privileges on cached 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.00 ms sending cached result to clien 0.02 ms cleaned up 0.02 ms cleaning up 0.00 ms
# 発信者 ファイルと行番号 17 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:157016 JDatabaseDriver->loadColumn() Copy JROOT/plugins/kunena/joomla/access.php:44115 KunenaAccessJoomla->getUsersByGroup() Copy JROOT/plugins/kunena/joomla/access.php:49214 KunenaAccessJoomla->getAuthorisedUsers() Copy JROOT/plugins/kunena/joomla/access.php:23313 KunenaAccessJoomla->loadCategoryRoles() Copy JROOT/libraries/kunena/access.php:12512 KunenaAccess->clearCache() Copy JROOT/libraries/kunena/access.php:8211 KunenaAccess->__construct() Copy JROOT/libraries/kunena/access.php:9710 KunenaAccess::getInstance() Copy JROOT/libraries/kunena/user/user.php:4419 KunenaUser->isAdmin() Copy JROOT/libraries/kunena/controller/application/display.php:2218 KunenaControllerApplicationDisplay->before() Copy JROOT/libraries/kunena/controller/application/display.php:837 KunenaControllerApplicationDisplay->execute() Copy JROOT/components/com_kunena/kunena.php:966 require_once Copy JROOT/components/com_kunena/kunena.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.60 ms 最後のクエリの後:0.03 ms クエリメモリ:0.025 MB クエリ前のメモリ:16.098 MB 返された行:23
SELECT DISTINCT (user_id)
FROM joom_usergroups as ug1
INNER JOIN joom_usergroups AS ug2 ON ug2.lft>= ug1.lft AND ug1.rgt>= ug2.rgt
INNER JOIN joom_user_usergroup_map AS m ON ug2.id= m.group_id
WHERE ug1.id IN (32,20)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE ug1 NULL range PRIMARY,idx_usergroup_nested_set_lookup PRIMARY 4 NULL 2 100.00 Using where; Using temporary 1 SIMPLE ug2 NULL ALL PRIMARY,idx_usergroup_nested_set_lookup インデックスキーを使用できませんでした NULL NULL 82 11.11 Range checked for each record (index map: 0x9) 1 SIMPLE m NULL ref PRIMARY,group_id,user_id group_id 4 root_db.ug2.id 106 100.00 Using index
Status Duration starting 0.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 checking permissions 0.00 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:157016 JDatabaseDriver->loadColumn() Copy JROOT/plugins/kunena/joomla/access.php:44115 KunenaAccessJoomla->getUsersByGroup() Copy JROOT/plugins/kunena/joomla/access.php:49214 KunenaAccessJoomla->getAuthorisedUsers() Copy JROOT/plugins/kunena/joomla/access.php:23313 KunenaAccessJoomla->loadCategoryRoles() Copy JROOT/libraries/kunena/access.php:12512 KunenaAccess->clearCache() Copy JROOT/libraries/kunena/access.php:8211 KunenaAccess->__construct() Copy JROOT/libraries/kunena/access.php:9710 KunenaAccess::getInstance() Copy JROOT/libraries/kunena/user/user.php:4419 KunenaUser->isAdmin() Copy JROOT/libraries/kunena/controller/application/display.php:2218 KunenaControllerApplicationDisplay->before() Copy JROOT/libraries/kunena/controller/application/display.php:837 KunenaControllerApplicationDisplay->execute() Copy JROOT/components/com_kunena/kunena.php:966 require_once Copy JROOT/components/com_kunena/kunena.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.59 ms 最後のクエリの後:0.04 ms クエリメモリ:0.022 MB クエリ前のメモリ:16.114 MB 返された行:0
SELECT user_id, category_id, role FROM joom_kunena_user_categories WHERE role IN (1,2)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE joom_kunena_user_categories NULL range role role 1 NULL 2 100.00 Using where; Using index
Status Duration starting 0.01 ms checking query cache for query 0.00 ms checking privileges on cached 0.00 ms checking permissions 0.01 ms sending cached result to clien 0.02 ms cleaned up 0.01 ms cleaning up 0.00 ms
# 発信者 ファイルと行番号 14 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172113 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/kunena/access.php:13612 KunenaAccess->clearCache() Copy JROOT/libraries/kunena/access.php:8211 KunenaAccess->__construct() Copy JROOT/libraries/kunena/access.php:9710 KunenaAccess::getInstance() Copy JROOT/libraries/kunena/user/user.php:4419 KunenaUser->isAdmin() Copy JROOT/libraries/kunena/controller/application/display.php:2218 KunenaControllerApplicationDisplay->before() Copy JROOT/libraries/kunena/controller/application/display.php:837 KunenaControllerApplicationDisplay->execute() Copy JROOT/components/com_kunena/kunena.php:966 require_once Copy JROOT/components/com_kunena/kunena.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.67 ms 最後のクエリの後:0.97 ms クエリメモリ:0.026 MB クエリ前のメモリ:16.245 MB 返された行:1
SELECT COUNT (* ), MAX (id) FROM joom_users WHERE (block= 0 OR activation= "")id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE joom_users NULL ALL idx_block インデックスキーを使用できませんでした NULL NULL 1022 100.00 Using where
Status Duration starting 0.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
# 発信者 ファイルと行番号 19 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:179318 JDatabaseDriver->loadRow() Copy JROOT/libraries/kunena/user/helper.php:27717 KunenaUserHelper::getTotalCount() Copy JROOT/libraries/kunena/forum/statistics.php:18116 KunenaForumStatistics->loadMemberCount() Copy JROOT/libraries/kunena/forum/statistics.php:10315 KunenaForumStatistics->loadGeneral() Copy JROOT/libraries/kunena/forum/statistics.php:8814 KunenaForumStatistics->loadAll() Copy JROOT/components/com_kunena/controller/statistics/general/display.php:4613 ComponentKunenaControllerStatisticsGeneralDisplay->before() Copy JROOT/libraries/kunena/controller/display.php:3112 KunenaControllerDisplay->execute() Copy JROOT/libraries/kunena/layout/page.php:4611 KunenaLayoutPage->execute() Copy JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php:1310 include Copy JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php Copy JROOT/libraries/kunena/layout/base.php:1839 KunenaLayoutBase->render() Copy JROOT/libraries/kunena/layout/layout.php:688 KunenaLayout->render() Copy JROOT/libraries/kunena/controller/application/display.php:1237 KunenaControllerApplicationDisplay->execute() Copy JROOT/components/com_kunena/kunena.php:966 require_once Copy JROOT/components/com_kunena/kunena.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.66 ms 最後のクエリの後:0.72 ms クエリメモリ:0.029 MB クエリ前のメモリ:16.364 MB 返された行:3
SELECT * FROM joom_kunena_categories ORDER BY ordering, nameid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE joom_kunena_categories NULL ALL NULL インデックスキーを使用できませんでした NULL NULL 3 100.00 filesortの使用
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
# 発信者 ファイルと行番号 24 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172123 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/kunena/forum/category/helper.php:86522 KunenaForumCategoryHelper::loadCategories() Copy JROOT/libraries/kunena/forum/category/helper.php:4321 KunenaForumCategoryHelper::initialize() Copy JROOT/libraries/kunena/forum/category/helper.php:105220 include Copy JROOT/libraries/kunena/forum/category/helper.php Copy JROOT/libraries/loader.php:70219 JLoader::_load() Copy JROOT/libraries/loader.php:67118 JLoader::_autoload() 以下の行の呼び出しと同じです。 17 spl_autoload_call() Copy JROOT/libraries/kunena/forum/statistics.php:19016 KunenaForumStatistics->loadCategoryCount() Copy JROOT/libraries/kunena/forum/statistics.php:10515 KunenaForumStatistics->loadGeneral() Copy JROOT/libraries/kunena/forum/statistics.php:8814 KunenaForumStatistics->loadAll() Copy JROOT/components/com_kunena/controller/statistics/general/display.php:4613 ComponentKunenaControllerStatisticsGeneralDisplay->before() Copy JROOT/libraries/kunena/controller/display.php:3112 KunenaControllerDisplay->execute() Copy JROOT/libraries/kunena/layout/page.php:4611 KunenaLayoutPage->execute() Copy JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php:1310 include Copy JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php Copy JROOT/libraries/kunena/layout/base.php:1839 KunenaLayoutBase->render() Copy JROOT/libraries/kunena/layout/layout.php:688 KunenaLayout->render() Copy JROOT/libraries/kunena/controller/application/display.php:1237 KunenaControllerApplicationDisplay->execute() Copy JROOT/components/com_kunena/kunena.php:966 require_once Copy JROOT/components/com_kunena/kunena.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.71 ms 最後のクエリの後:1.88 ms クエリメモリ:0.027 MB クエリ前のメモリ:17.199 MB 返された行:0
SELECT groupid
FROM joom_community_groups_members
WHERE approved = 1 AND memberid = 0id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE joom_community_groups_members NULL ref idx_memberid idx_memberid 4 const 1 100.00 Using where
Status Duration starting 0.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.02 ms cleaning up 0.00 ms
# 発信者 ファイルと行番号 24 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172123 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/kunena/forum/category/helper.php:88122 KunenaForumCategoryHelper::loadCategories() Copy JROOT/libraries/kunena/forum/category/helper.php:4321 KunenaForumCategoryHelper::initialize() Copy JROOT/libraries/kunena/forum/category/helper.php:105220 include Copy JROOT/libraries/kunena/forum/category/helper.php Copy JROOT/libraries/loader.php:70219 JLoader::_load() Copy JROOT/libraries/loader.php:67118 JLoader::_autoload() 以下の行の呼び出しと同じです。 17 spl_autoload_call() Copy JROOT/libraries/kunena/forum/statistics.php:19016 KunenaForumStatistics->loadCategoryCount() Copy JROOT/libraries/kunena/forum/statistics.php:10515 KunenaForumStatistics->loadGeneral() Copy JROOT/libraries/kunena/forum/statistics.php:8814 KunenaForumStatistics->loadAll() Copy JROOT/components/com_kunena/controller/statistics/general/display.php:4613 ComponentKunenaControllerStatisticsGeneralDisplay->before() Copy JROOT/libraries/kunena/controller/display.php:3112 KunenaControllerDisplay->execute() Copy JROOT/libraries/kunena/layout/page.php:4611 KunenaLayoutPage->execute() Copy JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php:1310 include Copy JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php Copy JROOT/libraries/kunena/layout/base.php:1839 KunenaLayoutBase->render() Copy JROOT/libraries/kunena/layout/layout.php:688 KunenaLayout->render() Copy JROOT/libraries/kunena/controller/application/display.php:1237 KunenaControllerApplicationDisplay->execute() Copy JROOT/components/com_kunena/kunena.php:966 require_once Copy JROOT/components/com_kunena/kunena.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.66 ms 最後のクエリの後:0.25 ms クエリメモリ:0.026 MB クエリ前のメモリ:17.279 MB 返された行:0
SELECT *
FROM `joom_kunena_topics `
WHERE `category_id`= '1'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE joom_kunena_topics NULL ref category_id category_id 4 const 1 100.00 NULL
Status Duration starting 0.02 ms checking query cache for query 0.01 ms checking privileges on cached 0.00 ms checking permissions 0.01 ms sending cached result to clien 0.02 ms cleaned up 0.01 ms cleaning up 0.00 ms
# 発信者 ファイルと行番号 21 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172120 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/axslibs/forum.php:3819 AxsForum::getCategoryCounts() Copy JROOT/libraries/kunena/forum/category/category.php:148818 KunenaForumCategory->buildInfo() Copy JROOT/libraries/kunena/forum/category/category.php:22317 KunenaForumCategory->isSection() Copy JROOT/libraries/kunena/forum/statistics.php:19916 KunenaForumStatistics->loadCategoryCount() Copy JROOT/libraries/kunena/forum/statistics.php:10515 KunenaForumStatistics->loadGeneral() Copy JROOT/libraries/kunena/forum/statistics.php:8814 KunenaForumStatistics->loadAll() Copy JROOT/components/com_kunena/controller/statistics/general/display.php:4613 ComponentKunenaControllerStatisticsGeneralDisplay->before() Copy JROOT/libraries/kunena/controller/display.php:3112 KunenaControllerDisplay->execute() Copy JROOT/libraries/kunena/layout/page.php:4611 KunenaLayoutPage->execute() Copy JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php:1310 include Copy JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php Copy JROOT/libraries/kunena/layout/base.php:1839 KunenaLayoutBase->render() Copy JROOT/libraries/kunena/layout/layout.php:688 KunenaLayout->render() Copy JROOT/libraries/kunena/controller/application/display.php:1237 KunenaControllerApplicationDisplay->execute() Copy JROOT/components/com_kunena/kunena.php:966 require_once Copy JROOT/components/com_kunena/kunena.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.69 ms 最後のクエリの後:0.05 ms クエリメモリ:0.026 MB クエリ前のメモリ:17.290 MB 返された行:0
SELECT *
FROM `joom_kunena_topics `
WHERE `category_id`= '2'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE joom_kunena_topics NULL ref category_id category_id 4 const 1 100.00 NULL
Status Duration starting 0.02 ms checking query cache for query 0.01 ms checking privileges on cached 0.00 ms checking permissions 0.01 ms sending cached result to clien 0.04 ms cleaned up 0.01 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 22 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172121 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/axslibs/forum.php:3820 AxsForum::getCategoryCounts() Copy JROOT/libraries/kunena/forum/category/category.php:148819 KunenaForumCategory->buildInfo() Copy JROOT/libraries/kunena/forum/category/category.php:148518 KunenaForumCategory->buildInfo() Copy JROOT/libraries/kunena/forum/category/category.php:22317 KunenaForumCategory->isSection() Copy JROOT/libraries/kunena/forum/statistics.php:19916 KunenaForumStatistics->loadCategoryCount() Copy JROOT/libraries/kunena/forum/statistics.php:10515 KunenaForumStatistics->loadGeneral() Copy JROOT/libraries/kunena/forum/statistics.php:8814 KunenaForumStatistics->loadAll() Copy JROOT/components/com_kunena/controller/statistics/general/display.php:4613 ComponentKunenaControllerStatisticsGeneralDisplay->before() Copy JROOT/libraries/kunena/controller/display.php:3112 KunenaControllerDisplay->execute() Copy JROOT/libraries/kunena/layout/page.php:4611 KunenaLayoutPage->execute() Copy JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php:1310 include Copy JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php Copy JROOT/libraries/kunena/layout/base.php:1839 KunenaLayoutBase->render() Copy JROOT/libraries/kunena/layout/layout.php:688 KunenaLayout->render() Copy JROOT/libraries/kunena/controller/application/display.php:1237 KunenaControllerApplicationDisplay->execute() Copy JROOT/components/com_kunena/kunena.php:966 require_once Copy JROOT/components/com_kunena/kunena.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.68 ms 最後のクエリの後:0.05 ms クエリメモリ:0.026 MB クエリ前のメモリ:17.300 MB 返された行:0
SELECT *
FROM `joom_kunena_topics `
WHERE `category_id`= '2'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE joom_kunena_topics NULL ref category_id category_id 4 const 1 100.00 NULL
Status Duration starting 0.02 ms checking query cache for query 0.01 ms checking privileges on cached 0.00 ms checking permissions 0.01 ms sending cached result to clien 0.02 ms cleaned up 0.02 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 21 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172120 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/axslibs/forum.php:3819 AxsForum::getCategoryCounts() Copy JROOT/libraries/kunena/forum/category/category.php:148818 KunenaForumCategory->buildInfo() Copy JROOT/libraries/kunena/forum/category/category.php:22317 KunenaForumCategory->isSection() Copy JROOT/libraries/kunena/forum/statistics.php:19916 KunenaForumStatistics->loadCategoryCount() Copy JROOT/libraries/kunena/forum/statistics.php:10515 KunenaForumStatistics->loadGeneral() Copy JROOT/libraries/kunena/forum/statistics.php:8814 KunenaForumStatistics->loadAll() Copy JROOT/components/com_kunena/controller/statistics/general/display.php:4613 ComponentKunenaControllerStatisticsGeneralDisplay->before() Copy JROOT/libraries/kunena/controller/display.php:3112 KunenaControllerDisplay->execute() Copy JROOT/libraries/kunena/layout/page.php:4611 KunenaLayoutPage->execute() Copy JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php:1310 include Copy JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php Copy JROOT/libraries/kunena/layout/base.php:1839 KunenaLayoutBase->render() Copy JROOT/libraries/kunena/layout/layout.php:688 KunenaLayout->render() Copy JROOT/libraries/kunena/controller/application/display.php:1237 KunenaControllerApplicationDisplay->execute() Copy JROOT/components/com_kunena/kunena.php:966 require_once Copy JROOT/components/com_kunena/kunena.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.81 ms 最後のクエリの後:0.09 ms クエリメモリ:0.026 MB クエリ前のメモリ:17.311 MB 返された行:0
SELECT *
FROM `joom_kunena_topics `
WHERE `category_id`= '3'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE joom_kunena_topics NULL ref category_id category_id 4 const 1 100.00 NULL
Status Duration starting 0.02 ms checking query cache for query 0.01 ms checking privileges on cached 0.00 ms checking permissions 0.01 ms sending cached result to clien 0.02 ms cleaned up 0.03 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 22 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172121 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/axslibs/forum.php:3820 AxsForum::getCategoryCounts() Copy JROOT/libraries/kunena/forum/category/category.php:148819 KunenaForumCategory->buildInfo() Copy JROOT/libraries/kunena/forum/category/category.php:148518 KunenaForumCategory->buildInfo() Copy JROOT/libraries/kunena/forum/category/category.php:22317 KunenaForumCategory->isSection() Copy JROOT/libraries/kunena/forum/statistics.php:19916 KunenaForumStatistics->loadCategoryCount() Copy JROOT/libraries/kunena/forum/statistics.php:10515 KunenaForumStatistics->loadGeneral() Copy JROOT/libraries/kunena/forum/statistics.php:8814 KunenaForumStatistics->loadAll() Copy JROOT/components/com_kunena/controller/statistics/general/display.php:4613 ComponentKunenaControllerStatisticsGeneralDisplay->before() Copy JROOT/libraries/kunena/controller/display.php:3112 KunenaControllerDisplay->execute() Copy JROOT/libraries/kunena/layout/page.php:4611 KunenaLayoutPage->execute() Copy JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php:1310 include Copy JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php Copy JROOT/libraries/kunena/layout/base.php:1839 KunenaLayoutBase->render() Copy JROOT/libraries/kunena/layout/layout.php:688 KunenaLayout->render() Copy JROOT/libraries/kunena/controller/application/display.php:1237 KunenaControllerApplicationDisplay->execute() Copy JROOT/components/com_kunena/kunena.php:966 require_once Copy JROOT/components/com_kunena/kunena.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.71 ms 最後のクエリの後:0.05 ms クエリメモリ:0.026 MB クエリ前のメモリ:17.321 MB 返された行:0
SELECT *
FROM `joom_kunena_topics `
WHERE `category_id`= '3'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE joom_kunena_topics NULL ref category_id category_id 4 const 1 100.00 NULL
Status Duration starting 0.02 ms checking query cache for query 0.01 ms checking privileges on cached 0.00 ms checking permissions 0.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:172120 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/axslibs/forum.php:3819 AxsForum::getCategoryCounts() Copy JROOT/libraries/kunena/forum/category/category.php:148818 KunenaForumCategory->buildInfo() Copy JROOT/libraries/kunena/forum/category/category.php:22317 KunenaForumCategory->isSection() Copy JROOT/libraries/kunena/forum/statistics.php:19916 KunenaForumStatistics->loadCategoryCount() Copy JROOT/libraries/kunena/forum/statistics.php:10515 KunenaForumStatistics->loadGeneral() Copy JROOT/libraries/kunena/forum/statistics.php:8814 KunenaForumStatistics->loadAll() Copy JROOT/components/com_kunena/controller/statistics/general/display.php:4613 ComponentKunenaControllerStatisticsGeneralDisplay->before() Copy JROOT/libraries/kunena/controller/display.php:3112 KunenaControllerDisplay->execute() Copy JROOT/libraries/kunena/layout/page.php:4611 KunenaLayoutPage->execute() Copy JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php:1310 include Copy JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php Copy JROOT/libraries/kunena/layout/base.php:1839 KunenaLayoutBase->render() Copy JROOT/libraries/kunena/layout/layout.php:688 KunenaLayout->render() Copy JROOT/libraries/kunena/controller/application/display.php:1237 KunenaControllerApplicationDisplay->execute() Copy JROOT/components/com_kunena/kunena.php:966 require_once Copy JROOT/components/com_kunena/kunena.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.65 ms 最後のクエリの後:0.06 ms クエリメモリ:0.025 MB クエリ前のメモリ:17.328 MB 返された行:1
SELECT
SUM (time>= 1723075200 AND parent= 0) AS todayTopicCount,
SUM (time>= 1723075200 AND parent>0) AS todayReplyCount,
SUM (time>= 1722988800 AND time<1723075200 AND parent= 0) AS yesterdayTopicCount,
SUM (time>= 1722988800 AND time<1723075200 AND parent>0) AS yesterdayReplyCount
FROM joom_kunena_messages WHERE time>= 1722988800 AND hold= 0id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE joom_kunena_messages NULL range hold_time,time hold_time 5 NULL 1 100.00 Using index condition
Status Duration starting 0.02 ms checking query cache for query 0.01 ms checking privileges on cached 0.00 ms checking permissions 0.01 ms sending cached result to clien 0.02 ms cleaned up 0.01 ms cleaning up 0.02 ms
# 発信者 ファイルと行番号 18 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:168217 JDatabaseDriver->loadObject() Copy JROOT/libraries/kunena/forum/statistics.php:22716 KunenaForumStatistics->loadLastDays() Copy JROOT/libraries/kunena/forum/statistics.php:10615 KunenaForumStatistics->loadGeneral() Copy JROOT/libraries/kunena/forum/statistics.php:8814 KunenaForumStatistics->loadAll() Copy JROOT/components/com_kunena/controller/statistics/general/display.php:4613 ComponentKunenaControllerStatisticsGeneralDisplay->before() Copy JROOT/libraries/kunena/controller/display.php:3112 KunenaControllerDisplay->execute() Copy JROOT/libraries/kunena/layout/page.php:4611 KunenaLayoutPage->execute() Copy JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php:1310 include Copy JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php Copy JROOT/libraries/kunena/layout/base.php:1839 KunenaLayoutBase->render() Copy JROOT/libraries/kunena/layout/layout.php:688 KunenaLayout->render() Copy JROOT/libraries/kunena/controller/application/display.php:1237 KunenaControllerApplicationDisplay->execute() Copy JROOT/components/com_kunena/kunena.php:966 require_once Copy JROOT/components/com_kunena/kunena.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.68 ms 最後のクエリの後:0.74 ms クエリメモリ:0.025 MB クエリ前のメモリ:17.396 MB 返された行:1
SELECT COUNT (* ) FROM joom_kunena_topics AS tt WHERE tt.hold IN (0) AND tt.category_id IN (2,3) AND tt.moved_id= '0'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE tt NULL ref category_id,hold hold 1 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.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/libraries/kunena/forum/topic/helper.php:27417 KunenaForumTopicHelper::getLatestTopics() Copy JROOT/libraries/kunena/forum/statistics.php:26016 KunenaForumStatistics->loadTopTopics() Copy JROOT/libraries/kunena/forum/statistics.php:14915 KunenaForumStatistics->loadTopicStats() Copy JROOT/libraries/kunena/forum/statistics.php:8914 KunenaForumStatistics->loadAll() Copy JROOT/components/com_kunena/controller/statistics/general/display.php:4613 ComponentKunenaControllerStatisticsGeneralDisplay->before() Copy JROOT/libraries/kunena/controller/display.php:3112 KunenaControllerDisplay->execute() Copy JROOT/libraries/kunena/layout/page.php:4611 KunenaLayoutPage->execute() Copy JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php:1310 include Copy JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php Copy JROOT/libraries/kunena/layout/base.php:1839 KunenaLayoutBase->render() Copy JROOT/libraries/kunena/layout/layout.php:688 KunenaLayout->render() Copy JROOT/libraries/kunena/controller/application/display.php:1237 KunenaControllerApplicationDisplay->execute() Copy JROOT/components/com_kunena/kunena.php:966 require_once Copy JROOT/components/com_kunena/kunena.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.62 ms 最後のクエリの後:0.08 ms クエリメモリ:0.025 MB クエリ前のメモリ:17.405 MB 返された行:0
SELECT poll.threadid AS id, SUM (opt.votes) AS count
FROM joom_kunena_polls_options AS opt
INNER JOIN joom_kunena_polls AS poll ON poll.id= opt.pollid
GROUP BY pollid
HAVING count > 0
ORDER BY count DESC LIMIT 0, 5id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE opt NULL ALL pollid インデックスキーを使用できませんでした NULL NULL 1 100.00 Using where; Using temporary; filesortの使用 1 SIMPLE poll NULL eq_ref PRIMARY PRIMARY 4 root_db.opt.pollid 1 100.00 NULL
Status Duration starting 0.01 ms checking query cache for query 0.01 ms checking privileges on cached 0.00 ms checking permissions 0.01 ms checking permissions 0.01 ms sending cached result to clien 0.02 ms cleaned up 0.02 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 18 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172117 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/kunena/forum/statistics.php:37616 KunenaForumStatistics->loadTopPolls() Copy JROOT/libraries/kunena/forum/statistics.php:15915 KunenaForumStatistics->loadTopicStats() Copy JROOT/libraries/kunena/forum/statistics.php:8914 KunenaForumStatistics->loadAll() Copy JROOT/components/com_kunena/controller/statistics/general/display.php:4613 ComponentKunenaControllerStatisticsGeneralDisplay->before() Copy JROOT/libraries/kunena/controller/display.php:3112 KunenaControllerDisplay->execute() Copy JROOT/libraries/kunena/layout/page.php:4611 KunenaLayoutPage->execute() Copy JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php:1310 include Copy JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php Copy JROOT/libraries/kunena/layout/base.php:1839 KunenaLayoutBase->render() Copy JROOT/libraries/kunena/layout/layout.php:688 KunenaLayout->render() Copy JROOT/libraries/kunena/controller/application/display.php:1237 KunenaControllerApplicationDisplay->execute() Copy JROOT/components/com_kunena/kunena.php:966 require_once Copy JROOT/components/com_kunena/kunena.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.62 ms 最後のクエリの後:0.11 ms クエリメモリ:0.025 MB クエリ前のメモリ:17.417 MB 返された行:0
SELECT `u`.`id`,`ku`.`posts` AS `count`
FROM `joom_kunena_users ` AS `ku`
INNER JOIN `joom_users ` AS `u` ON `u`.`id` = `ku`.`userid`
WHERE `ku`.`posts`>0
ORDER BY `ku`.`posts` DESC LIMIT 5id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE ku NULL range PRIMARY,posts posts 5 NULL 1 100.00 Using where; Using index 1 SIMPLE u NULL eq_ref PRIMARY PRIMARY 4 root_db.ku.userid 1 100.00 Using index
Status Duration starting 0.01 ms checking query cache for query 0.01 ms checking privileges on cached 0.00 ms checking permissions 0.01 ms checking permissions 0.01 ms sending cached result to clien 0.02 ms cleaned up 0.01 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 19 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172118 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/kunena/user/helper.php:31717 KunenaUserHelper::getTopPosters() Copy JROOT/libraries/kunena/forum/statistics.php:29616 KunenaForumStatistics->loadTopPosters() Copy JROOT/libraries/kunena/forum/statistics.php:11615 KunenaForumStatistics->loadUserStats() Copy JROOT/libraries/kunena/forum/statistics.php:9014 KunenaForumStatistics->loadAll() Copy JROOT/components/com_kunena/controller/statistics/general/display.php:4613 ComponentKunenaControllerStatisticsGeneralDisplay->before() Copy JROOT/libraries/kunena/controller/display.php:3112 KunenaControllerDisplay->execute() Copy JROOT/libraries/kunena/layout/page.php:4611 KunenaLayoutPage->execute() Copy JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php:1310 include Copy JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php Copy JROOT/libraries/kunena/layout/base.php:1839 KunenaLayoutBase->render() Copy JROOT/libraries/kunena/layout/layout.php:688 KunenaLayout->render() Copy JROOT/libraries/kunena/controller/application/display.php:1237 KunenaControllerApplicationDisplay->execute() Copy JROOT/components/com_kunena/kunena.php:966 require_once Copy JROOT/components/com_kunena/kunena.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.60 ms 最後のクエリの後:0.45 ms クエリメモリ:0.026 MB クエリ前のメモリ:17.451 MB 返された行:5
SELECT cu.userid AS id, cu.view AS count
FROM joom_community_users AS cu
INNER JOIN joom_users AS u ON u.id= cu.userid
WHERE cu.view>0
ORDER BY cu.view DESC LIMIT 0, 5id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE cu NULL ALL PRIMARY インデックスキーを使用できませんでした NULL NULL 96 33.33 Using where; filesortの使用 1 SIMPLE u NULL eq_ref PRIMARY PRIMARY 4 root_db.cu.userid 1 100.00 Using index
Status Duration starting 0.01 ms checking query cache for query 0.01 ms checking privileges on cached 0.00 ms checking permissions 0.01 ms checking permissions 0.01 ms sending cached result to clien 0.01 ms cleaned up 0.01 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 20 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172119 JDatabaseDriver->loadObjectList() Copy JROOT/plugins/kunena/community/profile.php:8318 KunenaProfileCommunity->_getTopHits() Copy JROOT/libraries/kunena/integration/profile.php:6517 KunenaProfile->getTopHits() Copy JROOT/libraries/kunena/forum/statistics.php:33116 KunenaForumStatistics->loadTopProfiles() Copy JROOT/libraries/kunena/forum/statistics.php:12315 KunenaForumStatistics->loadUserStats() Copy JROOT/libraries/kunena/forum/statistics.php:9014 KunenaForumStatistics->loadAll() Copy JROOT/components/com_kunena/controller/statistics/general/display.php:4613 ComponentKunenaControllerStatisticsGeneralDisplay->before() Copy JROOT/libraries/kunena/controller/display.php:3112 KunenaControllerDisplay->execute() Copy JROOT/libraries/kunena/layout/page.php:4611 KunenaLayoutPage->execute() Copy JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php:1310 include Copy JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php Copy JROOT/libraries/kunena/layout/base.php:1839 KunenaLayoutBase->render() Copy JROOT/libraries/kunena/layout/layout.php:688 KunenaLayout->render() Copy JROOT/libraries/kunena/controller/application/display.php:1237 KunenaControllerApplicationDisplay->execute() Copy JROOT/components/com_kunena/kunena.php:966 require_once Copy JROOT/components/com_kunena/kunena.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.70 ms 最後のクエリの後:0.12 ms クエリメモリ:0.027 MB クエリ前のメモリ:17.473 MB 返された行:1
SELECT u.name, u.username, u.email, u.block as blocked, u.registerDate, u.lastvisitDate, ku.*
FROM joom_users AS u
LEFT JOIN joom_kunena_users AS ku ON u.id = ku.userid
WHERE u.id = 1621327id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE u NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 SIMPLE ku NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL
Status Duration starting 0.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.01 ms
# 発信者 ファイルと行番号 22 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:148521 JDatabaseDriver->loadAssoc() Copy JROOT/libraries/kunena/tables/kunenausers.php:36520 TableKunenaUsers->load() Copy JROOT/libraries/kunena/user/user.php:28019 KunenaUser->load() Copy JROOT/libraries/kunena/user/user.php:10018 KunenaUser->__construct() Copy JROOT/libraries/kunena/user/helper.php:11517 KunenaUserHelper::get() Copy JROOT/libraries/kunena/forum/statistics.php:34716 KunenaForumStatistics->loadTopProfiles() Copy JROOT/libraries/kunena/forum/statistics.php:12315 KunenaForumStatistics->loadUserStats() Copy JROOT/libraries/kunena/forum/statistics.php:9014 KunenaForumStatistics->loadAll() Copy JROOT/components/com_kunena/controller/statistics/general/display.php:4613 ComponentKunenaControllerStatisticsGeneralDisplay->before() Copy JROOT/libraries/kunena/controller/display.php:3112 KunenaControllerDisplay->execute() Copy JROOT/libraries/kunena/layout/page.php:4611 KunenaLayoutPage->execute() Copy JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php:1310 include Copy JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php Copy JROOT/libraries/kunena/layout/base.php:1839 KunenaLayoutBase->render() Copy JROOT/libraries/kunena/layout/layout.php:688 KunenaLayout->render() Copy JROOT/libraries/kunena/controller/application/display.php:1237 KunenaControllerApplicationDisplay->execute() Copy JROOT/components/com_kunena/kunena.php:966 require_once Copy JROOT/components/com_kunena/kunena.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.15 ms 最後のクエリの後:0.12 ms クエリメモリ:0.026 MB クエリ前のメモリ:17.484 MB 返された行:1
SELECT a.`userid` as _userid , a.`status` as _status , a.`points` as _points, a.`posted_on` as _posted_on, a.`avatar` as _avatar , a.`thumb` as _thumb , a.`invite` as _invite, a.`params` as _cparams, a.`view` as _view, a.`friends` as _friends, a.`groups` as _groups, a.`events` as _events, a.`alias` as _alias, a.`profile_id` as _profile_id, a.`friendcount` as _friendcount, a.`storage` as _storage, a.`watermark_hash` as _watermark_hash, a.`search_email` AS _search_email, s.`userid` as _isonline, u.* FROM `joom_community_users ` as a LEFT JOIN `joom_users ` u ON u.`id`= a.`userid` LEFT OUTER JOIN `joom_session `s ON s.`userid`= a.`userid` WHERE a.`userid` IN (1621327)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 SIMPLE u NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 SIMPLE s NULL ref userid userid 5 const 1 100.00 Using index
Status Duration starting 0.01 ms checking query cache for query 0.01 ms checking privileges on cached 0.00 ms checking permissions 0.15 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.04 ms System lock 0.03 ms optimizing 0.02 ms statistics 0.12 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.02 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 21 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172120 JDatabaseDriver->loadObjectList() Copy JROOT/components/com_community/libraries/core.php:12419 CFactory::loadUsers() Copy JROOT/plugins/kunena/community/avatar.php:3718 KunenaAvatarCommunity->load() Copy JROOT/libraries/kunena/user/helper.php:11917 KunenaUserHelper::get() Copy JROOT/libraries/kunena/forum/statistics.php:34716 KunenaForumStatistics->loadTopProfiles() Copy JROOT/libraries/kunena/forum/statistics.php:12315 KunenaForumStatistics->loadUserStats() Copy JROOT/libraries/kunena/forum/statistics.php:9014 KunenaForumStatistics->loadAll() Copy JROOT/components/com_kunena/controller/statistics/general/display.php:4613 ComponentKunenaControllerStatisticsGeneralDisplay->before() Copy JROOT/libraries/kunena/controller/display.php:3112 KunenaControllerDisplay->execute() Copy JROOT/libraries/kunena/layout/page.php:4611 KunenaLayoutPage->execute() Copy JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php:1310 include Copy JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php Copy JROOT/libraries/kunena/layout/base.php:1839 KunenaLayoutBase->render() Copy JROOT/libraries/kunena/layout/layout.php:688 KunenaLayout->render() Copy JROOT/libraries/kunena/controller/application/display.php:1237 KunenaControllerApplicationDisplay->execute() Copy JROOT/components/com_kunena/kunena.php:966 require_once Copy JROOT/components/com_kunena/kunena.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 最後のクエリの後:2.38 ms クエリメモリ:0.029 MB クエリ前のメモリ:17.761 MB 返された行:2
SHOW FULL COLUMNS FROM `joom_community_config `クエリではEXPLAINは使用できません:SHOW FULL COLUMNS FROM `joom_community_config`
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.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 Sending data 0.03 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.02 ms cleaned up 0.01 ms cleaning up 0.00 ms
# 発信者 ファイルと行番号 29 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172128 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/joomla/database/driver/mysqli.php:42127 JDatabaseDriverMysqli->getTableColumns() Copy JROOT/libraries/joomla/table/table.php:24426 JTable->getFields() Copy JROOT/libraries/joomla/table/table.php:16325 JTable->__construct() Copy JROOT/administrator/components/com_community/tables/configuration.php:2224 CommunityTableConfiguration->__construct() Copy JROOT/libraries/joomla/table/table.php:31123 JTable::getInstance() Copy JROOT/components/com_community/libraries/core.php:105722 CConfig::getInstance() Copy JROOT/components/com_community/libraries/core.php:23721 CFactory::getConfig() Copy JROOT/components/com_community/libraries/user.php:13220 CUser->init() Copy JROOT/components/com_community/libraries/core.php:12819 CFactory::loadUsers() Copy JROOT/plugins/kunena/community/avatar.php:3718 KunenaAvatarCommunity->load() Copy JROOT/libraries/kunena/user/helper.php:11917 KunenaUserHelper::get() Copy JROOT/libraries/kunena/forum/statistics.php:34716 KunenaForumStatistics->loadTopProfiles() Copy JROOT/libraries/kunena/forum/statistics.php:12315 KunenaForumStatistics->loadUserStats() Copy JROOT/libraries/kunena/forum/statistics.php:9014 KunenaForumStatistics->loadAll() Copy JROOT/components/com_kunena/controller/statistics/general/display.php:4613 ComponentKunenaControllerStatisticsGeneralDisplay->before() Copy JROOT/libraries/kunena/controller/display.php:3112 KunenaControllerDisplay->execute() Copy JROOT/libraries/kunena/layout/page.php:4611 KunenaLayoutPage->execute() Copy JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php:1310 include Copy JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php Copy JROOT/libraries/kunena/layout/base.php:1839 KunenaLayoutBase->render() Copy JROOT/libraries/kunena/layout/layout.php:688 KunenaLayout->render() Copy JROOT/libraries/kunena/controller/application/display.php:1237 KunenaControllerApplicationDisplay->execute() Copy JROOT/components/com_kunena/kunena.php:966 require_once Copy JROOT/components/com_kunena/kunena.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.68 ms 最後のクエリの後:0.09 ms クエリメモリ:0.027 MB クエリ前のメモリ:17.779 MB 返された行:1
SELECT *
FROM joom_community_config
WHERE `name` = 'config'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE joom_community_config NULL const PRIMARY PRIMARY 194 const 1 100.00 NULL
Status Duration starting 0.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
# 発信者 ファイルと行番号 25 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:148524 JDatabaseDriver->loadAssoc() Copy JROOT/libraries/joomla/table/table.php:72923 JTable->load() Copy JROOT/components/com_community/libraries/core.php:105822 CConfig::getInstance() Copy JROOT/components/com_community/libraries/core.php:23721 CFactory::getConfig() Copy JROOT/components/com_community/libraries/user.php:13220 CUser->init() Copy JROOT/components/com_community/libraries/core.php:12819 CFactory::loadUsers() Copy JROOT/plugins/kunena/community/avatar.php:3718 KunenaAvatarCommunity->load() Copy JROOT/libraries/kunena/user/helper.php:11917 KunenaUserHelper::get() Copy JROOT/libraries/kunena/forum/statistics.php:34716 KunenaForumStatistics->loadTopProfiles() Copy JROOT/libraries/kunena/forum/statistics.php:12315 KunenaForumStatistics->loadUserStats() Copy JROOT/libraries/kunena/forum/statistics.php:9014 KunenaForumStatistics->loadAll() Copy JROOT/components/com_kunena/controller/statistics/general/display.php:4613 ComponentKunenaControllerStatisticsGeneralDisplay->before() Copy JROOT/libraries/kunena/controller/display.php:3112 KunenaControllerDisplay->execute() Copy JROOT/libraries/kunena/layout/page.php:4611 KunenaLayoutPage->execute() Copy JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php:1310 include Copy JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php Copy JROOT/libraries/kunena/layout/base.php:1839 KunenaLayoutBase->render() Copy JROOT/libraries/kunena/layout/layout.php:688 KunenaLayout->render() Copy JROOT/libraries/kunena/controller/application/display.php:1237 KunenaControllerApplicationDisplay->execute() Copy JROOT/components/com_kunena/kunena.php:966 require_once Copy JROOT/components/com_kunena/kunena.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.71 ms 最後のクエリの後:1.83 ms クエリメモリ:0.028 MB クエリ前のメモリ:17.971 MB 返された行:1
SELECT * FROM joom_extensions WHERE name= 'com_media'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE joom_extensions NULL ALL NULL インデックスキーを使用できませんでした NULL NULL 653 10.00 Using where
Status Duration starting 0.02 ms checking query cache for query 0.05 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.03 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.02 ms executing 0.00 ms Sending data 0.82 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
# 発信者 ファイルと行番号 26 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:168225 JDatabaseDriver->loadObject() Copy JROOT/libraries/axslibs/images.php:6624 AxsImages::setSession() Copy JROOT/libraries/axslibs/images.php:1523 AxsImages::getImagesPath() Copy JROOT/components/com_community/libraries/core.php:109222 CConfig::getInstance() Copy JROOT/components/com_community/libraries/core.php:23721 CFactory::getConfig() Copy JROOT/components/com_community/libraries/user.php:13220 CUser->init() Copy JROOT/components/com_community/libraries/core.php:12819 CFactory::loadUsers() Copy JROOT/plugins/kunena/community/avatar.php:3718 KunenaAvatarCommunity->load() Copy JROOT/libraries/kunena/user/helper.php:11917 KunenaUserHelper::get() Copy JROOT/libraries/kunena/forum/statistics.php:34716 KunenaForumStatistics->loadTopProfiles() Copy JROOT/libraries/kunena/forum/statistics.php:12315 KunenaForumStatistics->loadUserStats() Copy JROOT/libraries/kunena/forum/statistics.php:9014 KunenaForumStatistics->loadAll() Copy JROOT/components/com_kunena/controller/statistics/general/display.php:4613 ComponentKunenaControllerStatisticsGeneralDisplay->before() Copy JROOT/libraries/kunena/controller/display.php:3112 KunenaControllerDisplay->execute() Copy JROOT/libraries/kunena/layout/page.php:4611 KunenaLayoutPage->execute() Copy JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php:1310 include Copy JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php Copy JROOT/libraries/kunena/layout/base.php:1839 KunenaLayoutBase->render() Copy JROOT/libraries/kunena/layout/layout.php:688 KunenaLayout->render() Copy JROOT/libraries/kunena/controller/application/display.php:1237 KunenaControllerApplicationDisplay->execute() Copy JROOT/components/com_kunena/kunena.php:966 require_once Copy JROOT/components/com_kunena/kunena.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.61 ms 最後のクエリの後:0.49 ms クエリメモリ:0.031 MB クエリ前のメモリ:18.021 MB 返された行:15
SHOW FULL COLUMNS FROM `joom_community_profiles `クエリではEXPLAINは使用できません:SHOW FULL COLUMNS FROM `joom_community_profiles`
Status Duration starting 0.05 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.01 ms statistics 0.01 ms preparing 0.01 ms executing 0.01 ms Opening tables 0.02 ms checking permissions 0.03 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms 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
# 発信者 ファイルと行番号 27 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172126 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/joomla/database/driver/mysqli.php:42125 JDatabaseDriverMysqli->getTableColumns() Copy JROOT/libraries/joomla/table/table.php:24424 JTable->getFields() Copy JROOT/libraries/joomla/table/table.php:16323 JTable->__construct() Copy JROOT/components/com_community/tables/multiprofile.php:3222 CTableMultiProfile->__construct() Copy JROOT/libraries/joomla/table/table.php:31121 JTable::getInstance() Copy JROOT/components/com_community/libraries/user.php:73220 CUser->getThumbAvatar() Copy JROOT/components/com_community/libraries/core.php:13019 CFactory::loadUsers() Copy JROOT/plugins/kunena/community/avatar.php:3718 KunenaAvatarCommunity->load() Copy JROOT/libraries/kunena/user/helper.php:11917 KunenaUserHelper::get() Copy JROOT/libraries/kunena/forum/statistics.php:34716 KunenaForumStatistics->loadTopProfiles() Copy JROOT/libraries/kunena/forum/statistics.php:12315 KunenaForumStatistics->loadUserStats() Copy JROOT/libraries/kunena/forum/statistics.php:9014 KunenaForumStatistics->loadAll() Copy JROOT/components/com_kunena/controller/statistics/general/display.php:4613 ComponentKunenaControllerStatisticsGeneralDisplay->before() Copy JROOT/libraries/kunena/controller/display.php:3112 KunenaControllerDisplay->execute() Copy JROOT/libraries/kunena/layout/page.php:4611 KunenaLayoutPage->execute() Copy JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php:1310 include Copy JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php Copy JROOT/libraries/kunena/layout/base.php:1839 KunenaLayoutBase->render() Copy JROOT/libraries/kunena/layout/layout.php:688 KunenaLayout->render() Copy JROOT/libraries/kunena/controller/application/display.php:1237 KunenaControllerApplicationDisplay->execute() Copy JROOT/components/com_kunena/kunena.php:966 require_once Copy JROOT/components/com_kunena/kunena.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.71 ms 最後のクエリの後:1.26 ms クエリメモリ:0.027 MB クエリ前のメモリ:18.216 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.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
# 発信者 ファイルと行番号 25 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:176024 JDatabaseDriver->loadResult() Copy JROOT/components/com_community/models/profile.php:78823 CommunityModelProfile->_getgenderId() Copy JROOT/components/com_community/models/profile.php:76222 CommunityModelProfile->getGender() Copy JROOT/components/com_community/libraries/user.php:62921 CUser->_getGender() Copy JROOT/components/com_community/libraries/user.php:76720 CUser->getThumbAvatar() Copy JROOT/components/com_community/libraries/core.php:13019 CFactory::loadUsers() Copy JROOT/plugins/kunena/community/avatar.php:3718 KunenaAvatarCommunity->load() Copy JROOT/libraries/kunena/user/helper.php:11917 KunenaUserHelper::get() Copy JROOT/libraries/kunena/forum/statistics.php:34716 KunenaForumStatistics->loadTopProfiles() Copy JROOT/libraries/kunena/forum/statistics.php:12315 KunenaForumStatistics->loadUserStats() Copy JROOT/libraries/kunena/forum/statistics.php:9014 KunenaForumStatistics->loadAll() Copy JROOT/components/com_kunena/controller/statistics/general/display.php:4613 ComponentKunenaControllerStatisticsGeneralDisplay->before() Copy JROOT/libraries/kunena/controller/display.php:3112 KunenaControllerDisplay->execute() Copy JROOT/libraries/kunena/layout/page.php:4611 KunenaLayoutPage->execute() Copy JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php:1310 include Copy JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php Copy JROOT/libraries/kunena/layout/base.php:1839 KunenaLayoutBase->render() Copy JROOT/libraries/kunena/layout/layout.php:688 KunenaLayout->render() Copy JROOT/libraries/kunena/controller/application/display.php:1237 KunenaControllerApplicationDisplay->execute() Copy JROOT/components/com_kunena/kunena.php:966 require_once Copy JROOT/components/com_kunena/kunena.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.71 ms 最後のクエリの後:0.05 ms クエリメモリ:0.027 MB クエリ前のメモリ:18.228 MB 返された行:0
SELECT `value` FROM `joom_community_fields_values ` WHERE `field_id` = '2' AND `user_id` = '1621327'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE NULL NULL NULL NULL インデックスキーを使用できませんでした NULL NULL NULL NULL no matching row in const table
Status Duration starting 0.02 ms checking query cache for query 0.01 ms checking privileges on cached 0.00 ms checking permissions 0.01 ms sending cached result to clien 0.02 ms cleaned up 0.01 ms cleaning up 0.00 ms
# 発信者 ファイルと行番号 24 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:176023 JDatabaseDriver->loadResult() Copy JROOT/components/com_community/models/profile.php:77122 CommunityModelProfile->getGender() Copy JROOT/components/com_community/libraries/user.php:62921 CUser->_getGender() Copy JROOT/components/com_community/libraries/user.php:76720 CUser->getThumbAvatar() Copy JROOT/components/com_community/libraries/core.php:13019 CFactory::loadUsers() Copy JROOT/plugins/kunena/community/avatar.php:3718 KunenaAvatarCommunity->load() Copy JROOT/libraries/kunena/user/helper.php:11917 KunenaUserHelper::get() Copy JROOT/libraries/kunena/forum/statistics.php:34716 KunenaForumStatistics->loadTopProfiles() Copy JROOT/libraries/kunena/forum/statistics.php:12315 KunenaForumStatistics->loadUserStats() Copy JROOT/libraries/kunena/forum/statistics.php:9014 KunenaForumStatistics->loadAll() Copy JROOT/components/com_kunena/controller/statistics/general/display.php:4613 ComponentKunenaControllerStatisticsGeneralDisplay->before() Copy JROOT/libraries/kunena/controller/display.php:3112 KunenaControllerDisplay->execute() Copy JROOT/libraries/kunena/layout/page.php:4611 KunenaLayoutPage->execute() Copy JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php:1310 include Copy JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php Copy JROOT/libraries/kunena/layout/base.php:1839 KunenaLayoutBase->render() Copy JROOT/libraries/kunena/layout/layout.php:688 KunenaLayout->render() Copy JROOT/libraries/kunena/controller/application/display.php:1237 KunenaControllerApplicationDisplay->execute() Copy JROOT/components/com_kunena/kunena.php:966 require_once Copy JROOT/components/com_kunena/kunena.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.75 ms 最後のクエリの後:1.30 ms クエリメモリ:0.026 MB クエリ前のメモリ:18.259 MB 返された行:1
SELECT `id` FROM `joom_users ` WHERE id= '1621327'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE joom_users NULL const PRIMARY PRIMARY 4 const 1 100.00 Using index
Status Duration starting 0.03 ms checking query cache for query 0.01 ms checking privileges on cached 0.01 ms checking permissions 0.02 ms sending cached result to clien 0.03 ms cleaned up 0.01 ms cleaning up 0.00 ms
# 発信者 ファイルと行番号 22 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:176021 JDatabaseDriver->loadResult() Copy JROOT/components/com_community/libraries/core.php:19020 CFactory::getUser() Copy JROOT/plugins/kunena/community/profile.php:5819 KunenaProfileCommunity->getProfileURL() Copy JROOT/libraries/kunena/user/user.php:66318 KunenaUser->getURL() Copy JROOT/libraries/kunena/user/user.php:60217 KunenaUser->getLink() Copy JROOT/libraries/kunena/forum/statistics.php:34716 KunenaForumStatistics->loadTopProfiles() Copy JROOT/libraries/kunena/forum/statistics.php:12315 KunenaForumStatistics->loadUserStats() Copy JROOT/libraries/kunena/forum/statistics.php:9014 KunenaForumStatistics->loadAll() Copy JROOT/components/com_kunena/controller/statistics/general/display.php:4613 ComponentKunenaControllerStatisticsGeneralDisplay->before() Copy JROOT/libraries/kunena/controller/display.php:3112 KunenaControllerDisplay->execute() Copy JROOT/libraries/kunena/layout/page.php:4611 KunenaLayoutPage->execute() Copy JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php:1310 include Copy JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php Copy JROOT/libraries/kunena/layout/base.php:1839 KunenaLayoutBase->render() Copy JROOT/libraries/kunena/layout/layout.php:688 KunenaLayout->render() Copy JROOT/libraries/kunena/controller/application/display.php:1237 KunenaControllerApplicationDisplay->execute() Copy JROOT/components/com_kunena/kunena.php:966 require_once Copy JROOT/components/com_kunena/kunena.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.10 ms クエリメモリ:0.027 MB クエリ前のメモリ:18.272 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`= '1621327'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 SIMPLE u NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 SIMPLE s NULL ref userid userid 5 const 1 100.00 Using where
Status Duration starting 0.02 ms checking query cache for query 0.01 ms checking privileges on cached 0.00 ms checking permissions 0.18 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.07 ms System lock 0.03 ms optimizing 0.02 ms statistics 0.12 ms preparing 0.03 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.04 ms storing result in query cache 0.02 ms cleaned up 0.01 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 23 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:168222 JDatabaseDriver->loadObject() Copy JROOT/components/com_community/libraries/user.php:16821 CUser->init() Copy JROOT/components/com_community/libraries/core.php:20120 CFactory::getUser() Copy JROOT/plugins/kunena/community/profile.php:5819 KunenaProfileCommunity->getProfileURL() Copy JROOT/libraries/kunena/user/user.php:66318 KunenaUser->getURL() Copy JROOT/libraries/kunena/user/user.php:60217 KunenaUser->getLink() Copy JROOT/libraries/kunena/forum/statistics.php:34716 KunenaForumStatistics->loadTopProfiles() Copy JROOT/libraries/kunena/forum/statistics.php:12315 KunenaForumStatistics->loadUserStats() Copy JROOT/libraries/kunena/forum/statistics.php:9014 KunenaForumStatistics->loadAll() Copy JROOT/components/com_kunena/controller/statistics/general/display.php:4613 ComponentKunenaControllerStatisticsGeneralDisplay->before() Copy JROOT/libraries/kunena/controller/display.php:3112 KunenaControllerDisplay->execute() Copy JROOT/libraries/kunena/layout/page.php:4611 KunenaLayoutPage->execute() Copy JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php:1310 include Copy JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php Copy JROOT/libraries/kunena/layout/base.php:1839 KunenaLayoutBase->render() Copy JROOT/libraries/kunena/layout/layout.php:688 KunenaLayout->render() Copy JROOT/libraries/kunena/controller/application/display.php:1237 KunenaControllerApplicationDisplay->execute() Copy JROOT/components/com_kunena/kunena.php:966 require_once Copy JROOT/components/com_kunena/kunena.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.63 ms 最後のクエリの後:0.17 ms クエリメモリ:0.027 MB クエリ前のメモリ:18.300 MB 返された行:0
SELECT `value` FROM `joom_community_fields_values ` WHERE `field_id` = '2' AND `user_id` = '1621327'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.01 ms checking query cache for query 0.01 ms checking privileges on cached 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
# 発信者 ファイルと行番号 25 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:176024 JDatabaseDriver->loadResult() Copy JROOT/components/com_community/models/profile.php:77123 CommunityModelProfile->getGender() Copy JROOT/components/com_community/libraries/user.php:62922 CUser->_getGender() Copy JROOT/components/com_community/libraries/user.php:76721 CUser->getThumbAvatar() Copy JROOT/components/com_community/libraries/core.php:20220 CFactory::getUser() Copy JROOT/plugins/kunena/community/profile.php:5819 KunenaProfileCommunity->getProfileURL() Copy JROOT/libraries/kunena/user/user.php:66318 KunenaUser->getURL() Copy JROOT/libraries/kunena/user/user.php:60217 KunenaUser->getLink() Copy JROOT/libraries/kunena/forum/statistics.php:34716 KunenaForumStatistics->loadTopProfiles() Copy JROOT/libraries/kunena/forum/statistics.php:12315 KunenaForumStatistics->loadUserStats() Copy JROOT/libraries/kunena/forum/statistics.php:9014 KunenaForumStatistics->loadAll() Copy JROOT/components/com_kunena/controller/statistics/general/display.php:4613 ComponentKunenaControllerStatisticsGeneralDisplay->before() Copy JROOT/libraries/kunena/controller/display.php:3112 KunenaControllerDisplay->execute() Copy JROOT/libraries/kunena/layout/page.php:4611 KunenaLayoutPage->execute() Copy JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php:1310 include Copy JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php Copy JROOT/libraries/kunena/layout/base.php:1839 KunenaLayoutBase->render() Copy JROOT/libraries/kunena/layout/layout.php:688 KunenaLayout->render() Copy JROOT/libraries/kunena/controller/application/display.php:1237 KunenaControllerApplicationDisplay->execute() Copy JROOT/components/com_kunena/kunena.php:966 require_once Copy JROOT/components/com_kunena/kunena.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.70 ms 最後のクエリの後:0.38 ms クエリメモリ:0.027 MB クエリ前のメモリ:18.336 MB 返された行:3
SELECT `id` FROM `joom_menu ` WHERE `link` LIKE '%option= com_community&view= profile%' AND `published`= '1' AND `menutype`!= 'jomsocial' AND `type`= 'component'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE joom_menu NULL ALL idx_menutype インデックスキーを使用できませんでした NULL NULL 257 0.39 Using where
Status Duration starting 0.02 ms checking query cache for query 0.01 ms checking privileges on cached 0.00 ms checking permissions 0.02 ms sending cached result to clien 0.04 ms cleaned up 0.01 ms cleaning up 1.23 ms
# 発信者 ファイルと行番号 23 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:176022 JDatabaseDriver->loadResult() Copy JROOT/components/com_community/libraries/core.php:139121 CRoute::_getViewItemid() Copy JROOT/components/com_community/libraries/core.php:130120 CRoute::_() Copy JROOT/plugins/kunena/community/profile.php:6319 KunenaProfileCommunity->getProfileURL() Copy JROOT/libraries/kunena/user/user.php:66318 KunenaUser->getURL() Copy JROOT/libraries/kunena/user/user.php:60217 KunenaUser->getLink() Copy JROOT/libraries/kunena/forum/statistics.php:34716 KunenaForumStatistics->loadTopProfiles() Copy JROOT/libraries/kunena/forum/statistics.php:12315 KunenaForumStatistics->loadUserStats() Copy JROOT/libraries/kunena/forum/statistics.php:9014 KunenaForumStatistics->loadAll() Copy JROOT/components/com_kunena/controller/statistics/general/display.php:4613 ComponentKunenaControllerStatisticsGeneralDisplay->before() Copy JROOT/libraries/kunena/controller/display.php:3112 KunenaControllerDisplay->execute() Copy JROOT/libraries/kunena/layout/page.php:4611 KunenaLayoutPage->execute() Copy JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php:1310 include Copy JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php Copy JROOT/libraries/kunena/layout/base.php:1839 KunenaLayoutBase->render() Copy JROOT/libraries/kunena/layout/layout.php:688 KunenaLayout->render() Copy JROOT/libraries/kunena/controller/application/display.php:1237 KunenaControllerApplicationDisplay->execute() Copy JROOT/components/com_kunena/kunena.php:966 require_once Copy JROOT/components/com_kunena/kunena.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.12 ms 最後のクエリの後:0.33 ms クエリメモリ:0.027 MB クエリ前のメモリ:18.369 MB 返された行:1
SELECT u.name, u.username, u.email, u.block as blocked, u.registerDate, u.lastvisitDate, ku.*
FROM joom_users AS u
LEFT JOIN joom_kunena_users AS ku ON u.id = ku.userid
WHERE u.id = 1621329id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE u NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 SIMPLE ku NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL
Status Duration starting 0.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.04 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/kunena/tables/kunenausers.php:36520 TableKunenaUsers->load() Copy JROOT/libraries/kunena/user/user.php:28019 KunenaUser->load() Copy JROOT/libraries/kunena/user/user.php:10018 KunenaUser->__construct() Copy JROOT/libraries/kunena/user/helper.php:11517 KunenaUserHelper::get() Copy JROOT/libraries/kunena/forum/statistics.php:34716 KunenaForumStatistics->loadTopProfiles() Copy JROOT/libraries/kunena/forum/statistics.php:12315 KunenaForumStatistics->loadUserStats() Copy JROOT/libraries/kunena/forum/statistics.php:9014 KunenaForumStatistics->loadAll() Copy JROOT/components/com_kunena/controller/statistics/general/display.php:4613 ComponentKunenaControllerStatisticsGeneralDisplay->before() Copy JROOT/libraries/kunena/controller/display.php:3112 KunenaControllerDisplay->execute() Copy JROOT/libraries/kunena/layout/page.php:4611 KunenaLayoutPage->execute() Copy JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php:1310 include Copy JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php Copy JROOT/libraries/kunena/layout/base.php:1839 KunenaLayoutBase->render() Copy JROOT/libraries/kunena/layout/layout.php:688 KunenaLayout->render() Copy JROOT/libraries/kunena/controller/application/display.php:1237 KunenaControllerApplicationDisplay->execute() Copy JROOT/components/com_kunena/kunena.php:966 require_once Copy JROOT/components/com_kunena/kunena.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.20 ms 最後のクエリの後:0.18 ms クエリメモリ:0.026 MB クエリ前のメモリ:18.380 MB 返された行:1
SELECT a.`userid` as _userid , a.`status` as _status , a.`points` as _points, a.`posted_on` as _posted_on, a.`avatar` as _avatar , a.`thumb` as _thumb , a.`invite` as _invite, a.`params` as _cparams, a.`view` as _view, a.`friends` as _friends, a.`groups` as _groups, a.`events` as _events, a.`alias` as _alias, a.`profile_id` as _profile_id, a.`friendcount` as _friendcount, a.`storage` as _storage, a.`watermark_hash` as _watermark_hash, a.`search_email` AS _search_email, s.`userid` as _isonline, u.* FROM `joom_community_users ` as a LEFT JOIN `joom_users ` u ON u.`id`= a.`userid` LEFT OUTER JOIN `joom_session `s ON s.`userid`= a.`userid` WHERE a.`userid` IN (1621329)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 SIMPLE u NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 SIMPLE s NULL ref userid userid 5 const 1 100.00 Using index
Status Duration starting 0.02 ms checking query cache for query 0.01 ms checking privileges on cached 0.00 ms checking permissions 0.18 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.04 ms System lock 0.03 ms optimizing 0.01 ms statistics 0.12 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.01 ms
# 発信者 ファイルと行番号 21 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172120 JDatabaseDriver->loadObjectList() Copy JROOT/components/com_community/libraries/core.php:12419 CFactory::loadUsers() Copy JROOT/plugins/kunena/community/avatar.php:3718 KunenaAvatarCommunity->load() Copy JROOT/libraries/kunena/user/helper.php:11917 KunenaUserHelper::get() Copy JROOT/libraries/kunena/forum/statistics.php:34716 KunenaForumStatistics->loadTopProfiles() Copy JROOT/libraries/kunena/forum/statistics.php:12315 KunenaForumStatistics->loadUserStats() Copy JROOT/libraries/kunena/forum/statistics.php:9014 KunenaForumStatistics->loadAll() Copy JROOT/components/com_kunena/controller/statistics/general/display.php:4613 ComponentKunenaControllerStatisticsGeneralDisplay->before() Copy JROOT/libraries/kunena/controller/display.php:3112 KunenaControllerDisplay->execute() Copy JROOT/libraries/kunena/layout/page.php:4611 KunenaLayoutPage->execute() Copy JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php:1310 include Copy JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php Copy JROOT/libraries/kunena/layout/base.php:1839 KunenaLayoutBase->render() Copy JROOT/libraries/kunena/layout/layout.php:688 KunenaLayout->render() Copy JROOT/libraries/kunena/controller/application/display.php:1237 KunenaControllerApplicationDisplay->execute() Copy JROOT/components/com_kunena/kunena.php:966 require_once Copy JROOT/components/com_kunena/kunena.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.62 ms 最後のクエリの後:0.16 ms クエリメモリ:0.027 MB クエリ前のメモリ:18.412 MB 返された行:0
SELECT `value` FROM `joom_community_fields_values ` WHERE `field_id` = '2' AND `user_id` = '1621329'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.01 ms checking query cache for query 0.01 ms checking privileges on cached 0.00 ms checking permissions 0.01 ms sending cached result to clien 0.02 ms cleaned up 0.01 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 24 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:176023 JDatabaseDriver->loadResult() Copy JROOT/components/com_community/models/profile.php:77122 CommunityModelProfile->getGender() Copy JROOT/components/com_community/libraries/user.php:62921 CUser->_getGender() Copy JROOT/components/com_community/libraries/user.php:76720 CUser->getThumbAvatar() Copy JROOT/components/com_community/libraries/core.php:13019 CFactory::loadUsers() Copy JROOT/plugins/kunena/community/avatar.php:3718 KunenaAvatarCommunity->load() Copy JROOT/libraries/kunena/user/helper.php:11917 KunenaUserHelper::get() Copy JROOT/libraries/kunena/forum/statistics.php:34716 KunenaForumStatistics->loadTopProfiles() Copy JROOT/libraries/kunena/forum/statistics.php:12315 KunenaForumStatistics->loadUserStats() Copy JROOT/libraries/kunena/forum/statistics.php:9014 KunenaForumStatistics->loadAll() Copy JROOT/components/com_kunena/controller/statistics/general/display.php:4613 ComponentKunenaControllerStatisticsGeneralDisplay->before() Copy JROOT/libraries/kunena/controller/display.php:3112 KunenaControllerDisplay->execute() Copy JROOT/libraries/kunena/layout/page.php:4611 KunenaLayoutPage->execute() Copy JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php:1310 include Copy JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php Copy JROOT/libraries/kunena/layout/base.php:1839 KunenaLayoutBase->render() Copy JROOT/libraries/kunena/layout/layout.php:688 KunenaLayout->render() Copy JROOT/libraries/kunena/controller/application/display.php:1237 KunenaControllerApplicationDisplay->execute() Copy JROOT/components/com_kunena/kunena.php:966 require_once Copy JROOT/components/com_kunena/kunena.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.75 ms 最後のクエリの後:0.28 ms クエリメモリ:0.026 MB クエリ前のメモリ:18.401 MB 返された行:1
SELECT `id` FROM `joom_users ` WHERE id= '1621329'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.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
# 発信者 ファイルと行番号 22 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:176021 JDatabaseDriver->loadResult() Copy JROOT/components/com_community/libraries/core.php:19020 CFactory::getUser() Copy JROOT/plugins/kunena/community/profile.php:5819 KunenaProfileCommunity->getProfileURL() Copy JROOT/libraries/kunena/user/user.php:66318 KunenaUser->getURL() Copy JROOT/libraries/kunena/user/user.php:60217 KunenaUser->getLink() Copy JROOT/libraries/kunena/forum/statistics.php:34716 KunenaForumStatistics->loadTopProfiles() Copy JROOT/libraries/kunena/forum/statistics.php:12315 KunenaForumStatistics->loadUserStats() Copy JROOT/libraries/kunena/forum/statistics.php:9014 KunenaForumStatistics->loadAll() Copy JROOT/components/com_kunena/controller/statistics/general/display.php:4613 ComponentKunenaControllerStatisticsGeneralDisplay->before() Copy JROOT/libraries/kunena/controller/display.php:3112 KunenaControllerDisplay->execute() Copy JROOT/libraries/kunena/layout/page.php:4611 KunenaLayoutPage->execute() Copy JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php:1310 include Copy JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php Copy JROOT/libraries/kunena/layout/base.php:1839 KunenaLayoutBase->render() Copy JROOT/libraries/kunena/layout/layout.php:688 KunenaLayout->render() Copy JROOT/libraries/kunena/controller/application/display.php:1237 KunenaControllerApplicationDisplay->execute() Copy JROOT/components/com_kunena/kunena.php:966 require_once Copy JROOT/components/com_kunena/kunena.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 最後のクエリの後:0.09 ms クエリメモリ:0.027 MB クエリ前のメモリ:18.413 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`= '1621329'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.01 ms checking query cache for query 0.01 ms checking privileges on cached 0.00 ms checking permissions 0.15 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.06 ms System lock 0.03 ms optimizing 0.02 ms statistics 0.10 ms preparing 0.03 ms executing 0.00 ms Sending data 0.04 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms storing result in query cache 0.01 ms cleaned up 0.01 ms cleaning up 0.02 ms
# 発信者 ファイルと行番号 23 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:168222 JDatabaseDriver->loadObject() Copy JROOT/components/com_community/libraries/user.php:16821 CUser->init() Copy JROOT/components/com_community/libraries/core.php:20120 CFactory::getUser() Copy JROOT/plugins/kunena/community/profile.php:5819 KunenaProfileCommunity->getProfileURL() Copy JROOT/libraries/kunena/user/user.php:66318 KunenaUser->getURL() Copy JROOT/libraries/kunena/user/user.php:60217 KunenaUser->getLink() Copy JROOT/libraries/kunena/forum/statistics.php:34716 KunenaForumStatistics->loadTopProfiles() Copy JROOT/libraries/kunena/forum/statistics.php:12315 KunenaForumStatistics->loadUserStats() Copy JROOT/libraries/kunena/forum/statistics.php:9014 KunenaForumStatistics->loadAll() Copy JROOT/components/com_kunena/controller/statistics/general/display.php:4613 ComponentKunenaControllerStatisticsGeneralDisplay->before() Copy JROOT/libraries/kunena/controller/display.php:3112 KunenaControllerDisplay->execute() Copy JROOT/libraries/kunena/layout/page.php:4611 KunenaLayoutPage->execute() Copy JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php:1310 include Copy JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php Copy JROOT/libraries/kunena/layout/base.php:1839 KunenaLayoutBase->render() Copy JROOT/libraries/kunena/layout/layout.php:688 KunenaLayout->render() Copy JROOT/libraries/kunena/controller/application/display.php:1237 KunenaControllerApplicationDisplay->execute() Copy JROOT/components/com_kunena/kunena.php:966 require_once Copy JROOT/components/com_kunena/kunena.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.68 ms 最後のクエリの後:0.10 ms クエリメモリ:0.027 MB クエリ前のメモリ:18.441 MB 返された行:0
SELECT `value` FROM `joom_community_fields_values ` WHERE `field_id` = '2' AND `user_id` = '1621329'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.01 ms checking permissions 0.02 ms sending cached result to clien 0.02 ms cleaned up 0.01 ms cleaning up 0.00 ms
# 発信者 ファイルと行番号 25 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:176024 JDatabaseDriver->loadResult() Copy JROOT/components/com_community/models/profile.php:77123 CommunityModelProfile->getGender() Copy JROOT/components/com_community/libraries/user.php:62922 CUser->_getGender() Copy JROOT/components/com_community/libraries/user.php:76721 CUser->getThumbAvatar() Copy JROOT/components/com_community/libraries/core.php:20220 CFactory::getUser() Copy JROOT/plugins/kunena/community/profile.php:5819 KunenaProfileCommunity->getProfileURL() Copy JROOT/libraries/kunena/user/user.php:66318 KunenaUser->getURL() Copy JROOT/libraries/kunena/user/user.php:60217 KunenaUser->getLink() Copy JROOT/libraries/kunena/forum/statistics.php:34716 KunenaForumStatistics->loadTopProfiles() Copy JROOT/libraries/kunena/forum/statistics.php:12315 KunenaForumStatistics->loadUserStats() Copy JROOT/libraries/kunena/forum/statistics.php:9014 KunenaForumStatistics->loadAll() Copy JROOT/components/com_kunena/controller/statistics/general/display.php:4613 ComponentKunenaControllerStatisticsGeneralDisplay->before() Copy JROOT/libraries/kunena/controller/display.php:3112 KunenaControllerDisplay->execute() Copy JROOT/libraries/kunena/layout/page.php:4611 KunenaLayoutPage->execute() Copy JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php:1310 include Copy JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php Copy JROOT/libraries/kunena/layout/base.php:1839 KunenaLayoutBase->render() Copy JROOT/libraries/kunena/layout/layout.php:688 KunenaLayout->render() Copy JROOT/libraries/kunena/controller/application/display.php:1237 KunenaControllerApplicationDisplay->execute() Copy JROOT/components/com_kunena/kunena.php:966 require_once Copy JROOT/components/com_kunena/kunena.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.65 ms 最後のクエリの後:0.22 ms クエリメモリ:0.027 MB クエリ前のメモリ:18.462 MB 返された行:1
SELECT u.name, u.username, u.email, u.block as blocked, u.registerDate, u.lastvisitDate, ku.*
FROM joom_users AS u
LEFT JOIN joom_kunena_users AS ku ON u.id = ku.userid
WHERE u.id = 1621325id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE u NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 SIMPLE ku NULL const PRIMARY PRIMARY 4 const 0 0.00 unique row not found
Status Duration starting 0.01 ms checking query cache for query 0.01 ms checking privileges on cached 0.01 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
# 発信者 ファイルと行番号 22 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:148521 JDatabaseDriver->loadAssoc() Copy JROOT/libraries/kunena/tables/kunenausers.php:36520 TableKunenaUsers->load() Copy JROOT/libraries/kunena/user/user.php:28019 KunenaUser->load() Copy JROOT/libraries/kunena/user/user.php:10018 KunenaUser->__construct() Copy JROOT/libraries/kunena/user/helper.php:11517 KunenaUserHelper::get() Copy JROOT/libraries/kunena/forum/statistics.php:34716 KunenaForumStatistics->loadTopProfiles() Copy JROOT/libraries/kunena/forum/statistics.php:12315 KunenaForumStatistics->loadUserStats() Copy JROOT/libraries/kunena/forum/statistics.php:9014 KunenaForumStatistics->loadAll() Copy JROOT/components/com_kunena/controller/statistics/general/display.php:4613 ComponentKunenaControllerStatisticsGeneralDisplay->before() Copy JROOT/libraries/kunena/controller/display.php:3112 KunenaControllerDisplay->execute() Copy JROOT/libraries/kunena/layout/page.php:4611 KunenaLayoutPage->execute() Copy JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php:1310 include Copy JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php Copy JROOT/libraries/kunena/layout/base.php:1839 KunenaLayoutBase->render() Copy JROOT/libraries/kunena/layout/layout.php:688 KunenaLayout->render() Copy JROOT/libraries/kunena/controller/application/display.php:1237 KunenaControllerApplicationDisplay->execute() Copy JROOT/components/com_kunena/kunena.php:966 require_once Copy JROOT/components/com_kunena/kunena.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 最後のクエリの後:0.08 ms クエリメモリ:0.032 MB クエリ前のメモリ:18.482 MB 返された行:1
SELECT a.`userid` as _userid , a.`status` as _status , a.`points` as _points, a.`posted_on` as _posted_on, a.`avatar` as _avatar , a.`thumb` as _thumb , a.`invite` as _invite, a.`params` as _cparams, a.`view` as _view, a.`friends` as _friends, a.`groups` as _groups, a.`events` as _events, a.`alias` as _alias, a.`profile_id` as _profile_id, a.`friendcount` as _friendcount, a.`storage` as _storage, a.`watermark_hash` as _watermark_hash, a.`search_email` AS _search_email, s.`userid` as _isonline, u.* FROM `joom_community_users ` as a LEFT JOIN `joom_users ` u ON u.`id`= a.`userid` LEFT OUTER JOIN `joom_session `s ON s.`userid`= a.`userid` WHERE a.`userid` IN (1621325)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 SIMPLE u NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 SIMPLE s NULL ref userid userid 5 const 1 100.00 Using index
Status Duration starting 0.02 ms checking query cache for query 0.01 ms checking privileges on cached 0.01 ms checking permissions 0.17 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.04 ms System lock 0.03 ms optimizing 0.01 ms statistics 0.09 ms preparing 0.02 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.03 ms storing result in query cache 0.01 ms cleaned up 0.01 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 21 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172120 JDatabaseDriver->loadObjectList() Copy JROOT/components/com_community/libraries/core.php:12419 CFactory::loadUsers() Copy JROOT/plugins/kunena/community/avatar.php:3718 KunenaAvatarCommunity->load() Copy JROOT/libraries/kunena/user/helper.php:11917 KunenaUserHelper::get() Copy JROOT/libraries/kunena/forum/statistics.php:34716 KunenaForumStatistics->loadTopProfiles() Copy JROOT/libraries/kunena/forum/statistics.php:12315 KunenaForumStatistics->loadUserStats() Copy JROOT/libraries/kunena/forum/statistics.php:9014 KunenaForumStatistics->loadAll() Copy JROOT/components/com_kunena/controller/statistics/general/display.php:4613 ComponentKunenaControllerStatisticsGeneralDisplay->before() Copy JROOT/libraries/kunena/controller/display.php:3112 KunenaControllerDisplay->execute() Copy JROOT/libraries/kunena/layout/page.php:4611 KunenaLayoutPage->execute() Copy JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php:1310 include Copy JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php Copy JROOT/libraries/kunena/layout/base.php:1839 KunenaLayoutBase->render() Copy JROOT/libraries/kunena/layout/layout.php:688 KunenaLayout->render() Copy JROOT/libraries/kunena/controller/application/display.php:1237 KunenaControllerApplicationDisplay->execute() Copy JROOT/components/com_kunena/kunena.php:966 require_once Copy JROOT/components/com_kunena/kunena.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.64 ms 最後のクエリの後:0.09 ms クエリメモリ:0.027 MB クエリ前のメモリ:18.519 MB 返された行:1
SELECT `value` FROM `joom_community_fields_values ` WHERE `field_id` = '2' AND `user_id` = '1621325'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE joom_community_fields_values NULL const unique_field_values,field_id,idx_user_fieldid,user_id unique_field_values 8 const,const 1 100.00 NULL
Status Duration starting 0.02 ms checking query cache for query 0.01 ms checking privileges on cached 0.00 ms checking permissions 0.01 ms sending cached result to clien 0.02 ms cleaned up 0.01 ms cleaning up 0.00 ms
# 発信者 ファイルと行番号 24 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:176023 JDatabaseDriver->loadResult() Copy JROOT/components/com_community/models/profile.php:77122 CommunityModelProfile->getGender() Copy JROOT/components/com_community/libraries/user.php:62921 CUser->_getGender() Copy JROOT/components/com_community/libraries/user.php:76720 CUser->getThumbAvatar() Copy JROOT/components/com_community/libraries/core.php:13019 CFactory::loadUsers() Copy JROOT/plugins/kunena/community/avatar.php:3718 KunenaAvatarCommunity->load() Copy JROOT/libraries/kunena/user/helper.php:11917 KunenaUserHelper::get() Copy JROOT/libraries/kunena/forum/statistics.php:34716 KunenaForumStatistics->loadTopProfiles() Copy JROOT/libraries/kunena/forum/statistics.php:12315 KunenaForumStatistics->loadUserStats() Copy JROOT/libraries/kunena/forum/statistics.php:9014 KunenaForumStatistics->loadAll() Copy JROOT/components/com_kunena/controller/statistics/general/display.php:4613 ComponentKunenaControllerStatisticsGeneralDisplay->before() Copy JROOT/libraries/kunena/controller/display.php:3112 KunenaControllerDisplay->execute() Copy JROOT/libraries/kunena/layout/page.php:4611 KunenaLayoutPage->execute() Copy JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php:1310 include Copy JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php Copy JROOT/libraries/kunena/layout/base.php:1839 KunenaLayoutBase->render() Copy JROOT/libraries/kunena/layout/layout.php:688 KunenaLayout->render() Copy JROOT/libraries/kunena/controller/application/display.php:1237 KunenaControllerApplicationDisplay->execute() Copy JROOT/components/com_kunena/kunena.php:966 require_once Copy JROOT/components/com_kunena/kunena.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.63 ms 最後のクエリの後:0.14 ms クエリメモリ:0.026 MB クエリ前のメモリ:18.508 MB 返された行:1
SELECT `id` FROM `joom_users ` WHERE id= '1621325'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.01 ms sending cached result to clien 0.02 ms cleaned up 0.01 ms cleaning up 0.00 ms
# 発信者 ファイルと行番号 22 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:176021 JDatabaseDriver->loadResult() Copy JROOT/components/com_community/libraries/core.php:19020 CFactory::getUser() Copy JROOT/plugins/kunena/community/profile.php:5819 KunenaProfileCommunity->getProfileURL() Copy JROOT/libraries/kunena/user/user.php:66318 KunenaUser->getURL() Copy JROOT/libraries/kunena/user/user.php:60217 KunenaUser->getLink() Copy JROOT/libraries/kunena/forum/statistics.php:34716 KunenaForumStatistics->loadTopProfiles() Copy JROOT/libraries/kunena/forum/statistics.php:12315 KunenaForumStatistics->loadUserStats() Copy JROOT/libraries/kunena/forum/statistics.php:9014 KunenaForumStatistics->loadAll() Copy JROOT/components/com_kunena/controller/statistics/general/display.php:4613 ComponentKunenaControllerStatisticsGeneralDisplay->before() Copy JROOT/libraries/kunena/controller/display.php:3112 KunenaControllerDisplay->execute() Copy JROOT/libraries/kunena/layout/page.php:4611 KunenaLayoutPage->execute() Copy JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php:1310 include Copy JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php Copy JROOT/libraries/kunena/layout/base.php:1839 KunenaLayoutBase->render() Copy JROOT/libraries/kunena/layout/layout.php:688 KunenaLayout->render() Copy JROOT/libraries/kunena/controller/application/display.php:1237 KunenaControllerApplicationDisplay->execute() Copy JROOT/components/com_kunena/kunena.php:966 require_once Copy JROOT/components/com_kunena/kunena.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.19 ms 最後のクエリの後:0.04 ms クエリメモリ:0.027 MB クエリ前のメモリ:18.521 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`= '1621325'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 SIMPLE u NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 SIMPLE s NULL ref userid userid 5 const 1 100.00 Using where
Status Duration starting 0.02 ms checking query cache for query 0.01 ms checking privileges on cached 0.00 ms checking permissions 0.16 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.06 ms System lock 0.03 ms optimizing 0.02 ms statistics 0.12 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
# 発信者 ファイルと行番号 23 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:168222 JDatabaseDriver->loadObject() Copy JROOT/components/com_community/libraries/user.php:16821 CUser->init() Copy JROOT/components/com_community/libraries/core.php:20120 CFactory::getUser() Copy JROOT/plugins/kunena/community/profile.php:5819 KunenaProfileCommunity->getProfileURL() Copy JROOT/libraries/kunena/user/user.php:66318 KunenaUser->getURL() Copy JROOT/libraries/kunena/user/user.php:60217 KunenaUser->getLink() Copy JROOT/libraries/kunena/forum/statistics.php:34716 KunenaForumStatistics->loadTopProfiles() Copy JROOT/libraries/kunena/forum/statistics.php:12315 KunenaForumStatistics->loadUserStats() Copy JROOT/libraries/kunena/forum/statistics.php:9014 KunenaForumStatistics->loadAll() Copy JROOT/components/com_kunena/controller/statistics/general/display.php:4613 ComponentKunenaControllerStatisticsGeneralDisplay->before() Copy JROOT/libraries/kunena/controller/display.php:3112 KunenaControllerDisplay->execute() Copy JROOT/libraries/kunena/layout/page.php:4611 KunenaLayoutPage->execute() Copy JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php:1310 include Copy JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php Copy JROOT/libraries/kunena/layout/base.php:1839 KunenaLayoutBase->render() Copy JROOT/libraries/kunena/layout/layout.php:688 KunenaLayout->render() Copy JROOT/libraries/kunena/controller/application/display.php:1237 KunenaControllerApplicationDisplay->execute() Copy JROOT/components/com_kunena/kunena.php:966 require_once Copy JROOT/components/com_kunena/kunena.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.72 ms 最後のクエリの後:0.08 ms クエリメモリ:0.027 MB クエリ前のメモリ:18.548 MB 返された行:1
SELECT `value` FROM `joom_community_fields_values ` WHERE `field_id` = '2' AND `user_id` = '1621325'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE joom_community_fields_values NULL const unique_field_values,field_id,idx_user_fieldid,user_id unique_field_values 8 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.01 ms sending cached result to clien 0.02 ms cleaned up 0.01 ms cleaning up 0.00 ms
# 発信者 ファイルと行番号 25 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:176024 JDatabaseDriver->loadResult() Copy JROOT/components/com_community/models/profile.php:77123 CommunityModelProfile->getGender() Copy JROOT/components/com_community/libraries/user.php:62922 CUser->_getGender() Copy JROOT/components/com_community/libraries/user.php:76721 CUser->getThumbAvatar() Copy JROOT/components/com_community/libraries/core.php:20220 CFactory::getUser() Copy JROOT/plugins/kunena/community/profile.php:5819 KunenaProfileCommunity->getProfileURL() Copy JROOT/libraries/kunena/user/user.php:66318 KunenaUser->getURL() Copy JROOT/libraries/kunena/user/user.php:60217 KunenaUser->getLink() Copy JROOT/libraries/kunena/forum/statistics.php:34716 KunenaForumStatistics->loadTopProfiles() Copy JROOT/libraries/kunena/forum/statistics.php:12315 KunenaForumStatistics->loadUserStats() Copy JROOT/libraries/kunena/forum/statistics.php:9014 KunenaForumStatistics->loadAll() Copy JROOT/components/com_kunena/controller/statistics/general/display.php:4613 ComponentKunenaControllerStatisticsGeneralDisplay->before() Copy JROOT/libraries/kunena/controller/display.php:3112 KunenaControllerDisplay->execute() Copy JROOT/libraries/kunena/layout/page.php:4611 KunenaLayoutPage->execute() Copy JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php:1310 include Copy JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php Copy JROOT/libraries/kunena/layout/base.php:1839 KunenaLayoutBase->render() Copy JROOT/libraries/kunena/layout/layout.php:688 KunenaLayout->render() Copy JROOT/libraries/kunena/controller/application/display.php:1237 KunenaControllerApplicationDisplay->execute() Copy JROOT/components/com_kunena/kunena.php:966 require_once Copy JROOT/components/com_kunena/kunena.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.65 ms 最後のクエリの後:0.14 ms クエリメモリ:0.029 MB クエリ前のメモリ:18.560 MB 返された行:1
SELECT `id` FROM `joom_users ` WHERE id= '1621325'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.02 ms cleaned up 0.01 ms cleaning up 0.00 ms
# 発信者 ファイルと行番号 30 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:176029 JDatabaseDriver->loadResult() Copy JROOT/components/com_community/libraries/core.php:19028 CFactory::getUser() Copy JROOT/components/com_community/router.php:2527 CommunityBuildRoute() Copy JROOT/libraries/cms/component/router/legacy.php:6826 JComponentRouterLegacy->build() Copy JROOT/libraries/cms/router/site.php:51925 JRouterSite->buildSefRoute() Copy JROOT/libraries/cms/router/site.php:48924 JRouterSite->_buildSefRoute() Copy JROOT/libraries/cms/router/router.php:28223 JRouter->build() Copy JROOT/libraries/cms/router/site.php:14922 JRouterSite->build() Copy JROOT/libraries/joomla/application/route.php:6221 JRoute::_() Copy JROOT/components/com_community/libraries/core.php:136820 CRoute::_() Copy JROOT/plugins/kunena/community/profile.php:6319 KunenaProfileCommunity->getProfileURL() Copy JROOT/libraries/kunena/user/user.php:66318 KunenaUser->getURL() Copy JROOT/libraries/kunena/user/user.php:60217 KunenaUser->getLink() Copy JROOT/libraries/kunena/forum/statistics.php:34716 KunenaForumStatistics->loadTopProfiles() Copy JROOT/libraries/kunena/forum/statistics.php:12315 KunenaForumStatistics->loadUserStats() Copy JROOT/libraries/kunena/forum/statistics.php:9014 KunenaForumStatistics->loadAll() Copy JROOT/components/com_kunena/controller/statistics/general/display.php:4613 ComponentKunenaControllerStatisticsGeneralDisplay->before() Copy JROOT/libraries/kunena/controller/display.php:3112 KunenaControllerDisplay->execute() Copy JROOT/libraries/kunena/layout/page.php:4611 KunenaLayoutPage->execute() Copy JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php:1310 include Copy JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php Copy JROOT/libraries/kunena/layout/base.php:1839 KunenaLayoutBase->render() Copy JROOT/libraries/kunena/layout/layout.php:688 KunenaLayout->render() Copy JROOT/libraries/kunena/controller/application/display.php:1237 KunenaControllerApplicationDisplay->execute() Copy JROOT/components/com_kunena/kunena.php:966 require_once Copy JROOT/components/com_kunena/kunena.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.61 ms 最後のクエリの後:0.07 ms クエリメモリ:0.027 MB クエリ前のメモリ:18.583 MB 返された行:1
SELECT u.name, u.username, u.email, u.block as blocked, u.registerDate, u.lastvisitDate, ku.*
FROM joom_users AS u
LEFT JOIN joom_kunena_users AS ku ON u.id = ku.userid
WHERE u.id = 1621328id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE u NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 SIMPLE ku NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL
Status Duration starting 0.01 ms checking query cache for query 0.01 ms checking privileges on cached 0.00 ms checking permissions 0.01 ms checking permissions 0.00 ms sending cached result to clien 0.02 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/kunena/tables/kunenausers.php:36520 TableKunenaUsers->load() Copy JROOT/libraries/kunena/user/user.php:28019 KunenaUser->load() Copy JROOT/libraries/kunena/user/user.php:10018 KunenaUser->__construct() Copy JROOT/libraries/kunena/user/helper.php:11517 KunenaUserHelper::get() Copy JROOT/libraries/kunena/forum/statistics.php:34716 KunenaForumStatistics->loadTopProfiles() Copy JROOT/libraries/kunena/forum/statistics.php:12315 KunenaForumStatistics->loadUserStats() Copy JROOT/libraries/kunena/forum/statistics.php:9014 KunenaForumStatistics->loadAll() Copy JROOT/components/com_kunena/controller/statistics/general/display.php:4613 ComponentKunenaControllerStatisticsGeneralDisplay->before() Copy JROOT/libraries/kunena/controller/display.php:3112 KunenaControllerDisplay->execute() Copy JROOT/libraries/kunena/layout/page.php:4611 KunenaLayoutPage->execute() Copy JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php:1310 include Copy JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php Copy JROOT/libraries/kunena/layout/base.php:1839 KunenaLayoutBase->render() Copy JROOT/libraries/kunena/layout/layout.php:688 KunenaLayout->render() Copy JROOT/libraries/kunena/controller/application/display.php:1237 KunenaControllerApplicationDisplay->execute() Copy JROOT/components/com_kunena/kunena.php:966 require_once Copy JROOT/components/com_kunena/kunena.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.07 ms クエリメモリ:0.026 MB クエリ前のメモリ:18.594 MB 返された行:1
SELECT a.`userid` as _userid , a.`status` as _status , a.`points` as _points, a.`posted_on` as _posted_on, a.`avatar` as _avatar , a.`thumb` as _thumb , a.`invite` as _invite, a.`params` as _cparams, a.`view` as _view, a.`friends` as _friends, a.`groups` as _groups, a.`events` as _events, a.`alias` as _alias, a.`profile_id` as _profile_id, a.`friendcount` as _friendcount, a.`storage` as _storage, a.`watermark_hash` as _watermark_hash, a.`search_email` AS _search_email, s.`userid` as _isonline, u.* FROM `joom_community_users ` as a LEFT JOIN `joom_users ` u ON u.`id`= a.`userid` LEFT OUTER JOIN `joom_session `s ON s.`userid`= a.`userid` WHERE a.`userid` IN (1621328)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 SIMPLE u NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 SIMPLE s NULL ref userid userid 5 const 1 100.00 Using index
Status Duration starting 0.01 ms checking query cache for query 0.01 ms checking privileges on cached 0.00 ms checking permissions 0.15 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.04 ms System lock 0.03 ms optimizing 0.02 ms statistics 0.09 ms preparing 0.02 ms executing 0.00 ms Sending data 0.07 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms storing result in query cache 0.01 ms cleaned up 0.01 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 21 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172120 JDatabaseDriver->loadObjectList() Copy JROOT/components/com_community/libraries/core.php:12419 CFactory::loadUsers() Copy JROOT/plugins/kunena/community/avatar.php:3718 KunenaAvatarCommunity->load() Copy JROOT/libraries/kunena/user/helper.php:11917 KunenaUserHelper::get() Copy JROOT/libraries/kunena/forum/statistics.php:34716 KunenaForumStatistics->loadTopProfiles() Copy JROOT/libraries/kunena/forum/statistics.php:12315 KunenaForumStatistics->loadUserStats() Copy JROOT/libraries/kunena/forum/statistics.php:9014 KunenaForumStatistics->loadAll() Copy JROOT/components/com_kunena/controller/statistics/general/display.php:4613 ComponentKunenaControllerStatisticsGeneralDisplay->before() Copy JROOT/libraries/kunena/controller/display.php:3112 KunenaControllerDisplay->execute() Copy JROOT/libraries/kunena/layout/page.php:4611 KunenaLayoutPage->execute() Copy JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php:1310 include Copy JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php Copy JROOT/libraries/kunena/layout/base.php:1839 KunenaLayoutBase->render() Copy JROOT/libraries/kunena/layout/layout.php:688 KunenaLayout->render() Copy JROOT/libraries/kunena/controller/application/display.php:1237 KunenaControllerApplicationDisplay->execute() Copy JROOT/components/com_kunena/kunena.php:966 require_once Copy JROOT/components/com_kunena/kunena.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.58 ms 最後のクエリの後:0.08 ms クエリメモリ:0.027 MB クエリ前のメモリ:18.625 MB 返された行:0
SELECT `value` FROM `joom_community_fields_values ` WHERE `field_id` = '2' AND `user_id` = '1621328'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.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
# 発信者 ファイルと行番号 24 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:176023 JDatabaseDriver->loadResult() Copy JROOT/components/com_community/models/profile.php:77122 CommunityModelProfile->getGender() Copy JROOT/components/com_community/libraries/user.php:62921 CUser->_getGender() Copy JROOT/components/com_community/libraries/user.php:76720 CUser->getThumbAvatar() Copy JROOT/components/com_community/libraries/core.php:13019 CFactory::loadUsers() Copy JROOT/plugins/kunena/community/avatar.php:3718 KunenaAvatarCommunity->load() Copy JROOT/libraries/kunena/user/helper.php:11917 KunenaUserHelper::get() Copy JROOT/libraries/kunena/forum/statistics.php:34716 KunenaForumStatistics->loadTopProfiles() Copy JROOT/libraries/kunena/forum/statistics.php:12315 KunenaForumStatistics->loadUserStats() Copy JROOT/libraries/kunena/forum/statistics.php:9014 KunenaForumStatistics->loadAll() Copy JROOT/components/com_kunena/controller/statistics/general/display.php:4613 ComponentKunenaControllerStatisticsGeneralDisplay->before() Copy JROOT/libraries/kunena/controller/display.php:3112 KunenaControllerDisplay->execute() Copy JROOT/libraries/kunena/layout/page.php:4611 KunenaLayoutPage->execute() Copy JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php:1310 include Copy JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php Copy JROOT/libraries/kunena/layout/base.php:1839 KunenaLayoutBase->render() Copy JROOT/libraries/kunena/layout/layout.php:688 KunenaLayout->render() Copy JROOT/libraries/kunena/controller/application/display.php:1237 KunenaControllerApplicationDisplay->execute() Copy JROOT/components/com_kunena/kunena.php:966 require_once Copy JROOT/components/com_kunena/kunena.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.66 ms 最後のクエリの後:0.19 ms クエリメモリ:0.026 MB クエリ前のメモリ:18.614 MB 返された行:1
SELECT `id` FROM `joom_users ` WHERE id= '1621328'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.02 ms cleaned up 0.01 ms cleaning up 0.00 ms
# 発信者 ファイルと行番号 22 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:176021 JDatabaseDriver->loadResult() Copy JROOT/components/com_community/libraries/core.php:19020 CFactory::getUser() Copy JROOT/plugins/kunena/community/profile.php:5819 KunenaProfileCommunity->getProfileURL() Copy JROOT/libraries/kunena/user/user.php:66318 KunenaUser->getURL() Copy JROOT/libraries/kunena/user/user.php:60217 KunenaUser->getLink() Copy JROOT/libraries/kunena/forum/statistics.php:34716 KunenaForumStatistics->loadTopProfiles() Copy JROOT/libraries/kunena/forum/statistics.php:12315 KunenaForumStatistics->loadUserStats() Copy JROOT/libraries/kunena/forum/statistics.php:9014 KunenaForumStatistics->loadAll() Copy JROOT/components/com_kunena/controller/statistics/general/display.php:4613 ComponentKunenaControllerStatisticsGeneralDisplay->before() Copy JROOT/libraries/kunena/controller/display.php:3112 KunenaControllerDisplay->execute() Copy JROOT/libraries/kunena/layout/page.php:4611 KunenaLayoutPage->execute() Copy JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php:1310 include Copy JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php Copy JROOT/libraries/kunena/layout/base.php:1839 KunenaLayoutBase->render() Copy JROOT/libraries/kunena/layout/layout.php:688 KunenaLayout->render() Copy JROOT/libraries/kunena/controller/application/display.php:1237 KunenaControllerApplicationDisplay->execute() Copy JROOT/components/com_kunena/kunena.php:966 require_once Copy JROOT/components/com_kunena/kunena.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.06 ms クエリメモリ:0.027 MB クエリ前のメモリ:18.627 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`= '1621328'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.01 ms checking query cache for query 0.01 ms checking privileges on cached 0.00 ms checking permissions 0.15 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.04 ms System lock 0.03 ms optimizing 0.02 ms statistics 0.10 ms preparing 0.02 ms executing 0.00 ms Sending data 0.04 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms storing result in query cache 0.01 ms cleaned up 0.03 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 23 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:168222 JDatabaseDriver->loadObject() Copy JROOT/components/com_community/libraries/user.php:16821 CUser->init() Copy JROOT/components/com_community/libraries/core.php:20120 CFactory::getUser() Copy JROOT/plugins/kunena/community/profile.php:5819 KunenaProfileCommunity->getProfileURL() Copy JROOT/libraries/kunena/user/user.php:66318 KunenaUser->getURL() Copy JROOT/libraries/kunena/user/user.php:60217 KunenaUser->getLink() Copy JROOT/libraries/kunena/forum/statistics.php:34716 KunenaForumStatistics->loadTopProfiles() Copy JROOT/libraries/kunena/forum/statistics.php:12315 KunenaForumStatistics->loadUserStats() Copy JROOT/libraries/kunena/forum/statistics.php:9014 KunenaForumStatistics->loadAll() Copy JROOT/components/com_kunena/controller/statistics/general/display.php:4613 ComponentKunenaControllerStatisticsGeneralDisplay->before() Copy JROOT/libraries/kunena/controller/display.php:3112 KunenaControllerDisplay->execute() Copy JROOT/libraries/kunena/layout/page.php:4611 KunenaLayoutPage->execute() Copy JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php:1310 include Copy JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php Copy JROOT/libraries/kunena/layout/base.php:1839 KunenaLayoutBase->render() Copy JROOT/libraries/kunena/layout/layout.php:688 KunenaLayout->render() Copy JROOT/libraries/kunena/controller/application/display.php:1237 KunenaControllerApplicationDisplay->execute() Copy JROOT/components/com_kunena/kunena.php:966 require_once Copy JROOT/components/com_kunena/kunena.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.62 ms 最後のクエリの後:0.10 ms クエリメモリ:0.027 MB クエリ前のメモリ:18.654 MB 返された行:0
SELECT `value` FROM `joom_community_fields_values ` WHERE `field_id` = '2' AND `user_id` = '1621328'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.01 ms checking query cache for query 0.01 ms checking privileges on cached 0.00 ms checking permissions 0.01 ms sending cached result to clien 0.02 ms cleaned up 0.01 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 25 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:176024 JDatabaseDriver->loadResult() Copy JROOT/components/com_community/models/profile.php:77123 CommunityModelProfile->getGender() Copy JROOT/components/com_community/libraries/user.php:62922 CUser->_getGender() Copy JROOT/components/com_community/libraries/user.php:76721 CUser->getThumbAvatar() Copy JROOT/components/com_community/libraries/core.php:20220 CFactory::getUser() Copy JROOT/plugins/kunena/community/profile.php:5819 KunenaProfileCommunity->getProfileURL() Copy JROOT/libraries/kunena/user/user.php:66318 KunenaUser->getURL() Copy JROOT/libraries/kunena/user/user.php:60217 KunenaUser->getLink() Copy JROOT/libraries/kunena/forum/statistics.php:34716 KunenaForumStatistics->loadTopProfiles() Copy JROOT/libraries/kunena/forum/statistics.php:12315 KunenaForumStatistics->loadUserStats() Copy JROOT/libraries/kunena/forum/statistics.php:9014 KunenaForumStatistics->loadAll() Copy JROOT/components/com_kunena/controller/statistics/general/display.php:4613 ComponentKunenaControllerStatisticsGeneralDisplay->before() Copy JROOT/libraries/kunena/controller/display.php:3112 KunenaControllerDisplay->execute() Copy JROOT/libraries/kunena/layout/page.php:4611 KunenaLayoutPage->execute() Copy JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php:1310 include Copy JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php Copy JROOT/libraries/kunena/layout/base.php:1839 KunenaLayoutBase->render() Copy JROOT/libraries/kunena/layout/layout.php:688 KunenaLayout->render() Copy JROOT/libraries/kunena/controller/application/display.php:1237 KunenaControllerApplicationDisplay->execute() Copy JROOT/components/com_kunena/kunena.php:966 require_once Copy JROOT/components/com_kunena/kunena.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.65 ms 最後のクエリの後:0.19 ms クエリメモリ:0.027 MB クエリ前のメモリ:18.675 MB 返された行:1
SELECT u.name, u.username, u.email, u.block as blocked, u.registerDate, u.lastvisitDate, ku.*
FROM joom_users AS u
LEFT JOIN joom_kunena_users AS ku ON u.id = ku.userid
WHERE u.id = 1621326id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE u NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 SIMPLE ku NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL
Status Duration starting 0.01 ms checking query cache for query 0.01 ms checking privileges on cached 0.00 ms checking permissions 0.01 ms checking permissions 0.01 ms sending cached result to clien 0.02 ms cleaned up 0.01 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 22 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:148521 JDatabaseDriver->loadAssoc() Copy JROOT/libraries/kunena/tables/kunenausers.php:36520 TableKunenaUsers->load() Copy JROOT/libraries/kunena/user/user.php:28019 KunenaUser->load() Copy JROOT/libraries/kunena/user/user.php:10018 KunenaUser->__construct() Copy JROOT/libraries/kunena/user/helper.php:11517 KunenaUserHelper::get() Copy JROOT/libraries/kunena/forum/statistics.php:34716 KunenaForumStatistics->loadTopProfiles() Copy JROOT/libraries/kunena/forum/statistics.php:12315 KunenaForumStatistics->loadUserStats() Copy JROOT/libraries/kunena/forum/statistics.php:9014 KunenaForumStatistics->loadAll() Copy JROOT/components/com_kunena/controller/statistics/general/display.php:4613 ComponentKunenaControllerStatisticsGeneralDisplay->before() Copy JROOT/libraries/kunena/controller/display.php:3112 KunenaControllerDisplay->execute() Copy JROOT/libraries/kunena/layout/page.php:4611 KunenaLayoutPage->execute() Copy JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php:1310 include Copy JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php Copy JROOT/libraries/kunena/layout/base.php:1839 KunenaLayoutBase->render() Copy JROOT/libraries/kunena/layout/layout.php:688 KunenaLayout->render() Copy JROOT/libraries/kunena/controller/application/display.php:1237 KunenaControllerApplicationDisplay->execute() Copy JROOT/components/com_kunena/kunena.php:966 require_once Copy JROOT/components/com_kunena/kunena.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 最後のクエリの後:0.08 ms クエリメモリ:0.026 MB クエリ前のメモリ:18.686 MB 返された行:1
SELECT a.`userid` as _userid , a.`status` as _status , a.`points` as _points, a.`posted_on` as _posted_on, a.`avatar` as _avatar , a.`thumb` as _thumb , a.`invite` as _invite, a.`params` as _cparams, a.`view` as _view, a.`friends` as _friends, a.`groups` as _groups, a.`events` as _events, a.`alias` as _alias, a.`profile_id` as _profile_id, a.`friendcount` as _friendcount, a.`storage` as _storage, a.`watermark_hash` as _watermark_hash, a.`search_email` AS _search_email, s.`userid` as _isonline, u.* FROM `joom_community_users ` as a LEFT JOIN `joom_users ` u ON u.`id`= a.`userid` LEFT OUTER JOIN `joom_session `s ON s.`userid`= a.`userid` WHERE a.`userid` IN (1621326)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 SIMPLE u NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 SIMPLE s NULL ref userid userid 5 const 1 100.00 Using index
Status Duration starting 0.02 ms checking query cache for query 0.01 ms checking privileges on cached 0.00 ms checking permissions 0.16 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.04 ms System lock 0.03 ms optimizing 0.01 ms statistics 0.09 ms preparing 0.02 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.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:172120 JDatabaseDriver->loadObjectList() Copy JROOT/components/com_community/libraries/core.php:12419 CFactory::loadUsers() Copy JROOT/plugins/kunena/community/avatar.php:3718 KunenaAvatarCommunity->load() Copy JROOT/libraries/kunena/user/helper.php:11917 KunenaUserHelper::get() Copy JROOT/libraries/kunena/forum/statistics.php:34716 KunenaForumStatistics->loadTopProfiles() Copy JROOT/libraries/kunena/forum/statistics.php:12315 KunenaForumStatistics->loadUserStats() Copy JROOT/libraries/kunena/forum/statistics.php:9014 KunenaForumStatistics->loadAll() Copy JROOT/components/com_kunena/controller/statistics/general/display.php:4613 ComponentKunenaControllerStatisticsGeneralDisplay->before() Copy JROOT/libraries/kunena/controller/display.php:3112 KunenaControllerDisplay->execute() Copy JROOT/libraries/kunena/layout/page.php:4611 KunenaLayoutPage->execute() Copy JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php:1310 include Copy JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php Copy JROOT/libraries/kunena/layout/base.php:1839 KunenaLayoutBase->render() Copy JROOT/libraries/kunena/layout/layout.php:688 KunenaLayout->render() Copy JROOT/libraries/kunena/controller/application/display.php:1237 KunenaControllerApplicationDisplay->execute() Copy JROOT/components/com_kunena/kunena.php:966 require_once Copy JROOT/components/com_kunena/kunena.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.63 ms 最後のクエリの後:0.11 ms クエリメモリ:0.027 MB クエリ前のメモリ:18.726 MB 返された行:0
SELECT `value` FROM `joom_community_fields_values ` WHERE `field_id` = '2' AND `user_id` = '1621326'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE NULL NULL NULL NULL インデックスキーを使用できませんでした NULL NULL NULL NULL no matching row in const table
Status Duration starting 0.02 ms checking query cache for query 0.01 ms checking privileges on cached 0.00 ms checking permissions 0.01 ms sending cached result to clien 0.02 ms cleaned up 0.01 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 24 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:176023 JDatabaseDriver->loadResult() Copy JROOT/components/com_community/models/profile.php:77122 CommunityModelProfile->getGender() Copy JROOT/components/com_community/libraries/user.php:62921 CUser->_getGender() Copy JROOT/components/com_community/libraries/user.php:76720 CUser->getThumbAvatar() Copy JROOT/components/com_community/libraries/core.php:13019 CFactory::loadUsers() Copy JROOT/plugins/kunena/community/avatar.php:3718 KunenaAvatarCommunity->load() Copy JROOT/libraries/kunena/user/helper.php:11917 KunenaUserHelper::get() Copy JROOT/libraries/kunena/forum/statistics.php:34716 KunenaForumStatistics->loadTopProfiles() Copy JROOT/libraries/kunena/forum/statistics.php:12315 KunenaForumStatistics->loadUserStats() Copy JROOT/libraries/kunena/forum/statistics.php:9014 KunenaForumStatistics->loadAll() Copy JROOT/components/com_kunena/controller/statistics/general/display.php:4613 ComponentKunenaControllerStatisticsGeneralDisplay->before() Copy JROOT/libraries/kunena/controller/display.php:3112 KunenaControllerDisplay->execute() Copy JROOT/libraries/kunena/layout/page.php:4611 KunenaLayoutPage->execute() Copy JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php:1310 include Copy JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php Copy JROOT/libraries/kunena/layout/base.php:1839 KunenaLayoutBase->render() Copy JROOT/libraries/kunena/layout/layout.php:688 KunenaLayout->render() Copy JROOT/libraries/kunena/controller/application/display.php:1237 KunenaControllerApplicationDisplay->execute() Copy JROOT/components/com_kunena/kunena.php:966 require_once Copy JROOT/components/com_kunena/kunena.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.59 ms 最後のクエリの後:0.14 ms クエリメモリ:0.026 MB クエリ前のメモリ:18.715 MB 返された行:1
SELECT `id` FROM `joom_users ` WHERE id= '1621326'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.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
# 発信者 ファイルと行番号 22 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:176021 JDatabaseDriver->loadResult() Copy JROOT/components/com_community/libraries/core.php:19020 CFactory::getUser() Copy JROOT/plugins/kunena/community/profile.php:5819 KunenaProfileCommunity->getProfileURL() Copy JROOT/libraries/kunena/user/user.php:66318 KunenaUser->getURL() Copy JROOT/libraries/kunena/user/user.php:60217 KunenaUser->getLink() Copy JROOT/libraries/kunena/forum/statistics.php:34716 KunenaForumStatistics->loadTopProfiles() Copy JROOT/libraries/kunena/forum/statistics.php:12315 KunenaForumStatistics->loadUserStats() Copy JROOT/libraries/kunena/forum/statistics.php:9014 KunenaForumStatistics->loadAll() Copy JROOT/components/com_kunena/controller/statistics/general/display.php:4613 ComponentKunenaControllerStatisticsGeneralDisplay->before() Copy JROOT/libraries/kunena/controller/display.php:3112 KunenaControllerDisplay->execute() Copy JROOT/libraries/kunena/layout/page.php:4611 KunenaLayoutPage->execute() Copy JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php:1310 include Copy JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php Copy JROOT/libraries/kunena/layout/base.php:1839 KunenaLayoutBase->render() Copy JROOT/libraries/kunena/layout/layout.php:688 KunenaLayout->render() Copy JROOT/libraries/kunena/controller/application/display.php:1237 KunenaControllerApplicationDisplay->execute() Copy JROOT/components/com_kunena/kunena.php:966 require_once Copy JROOT/components/com_kunena/kunena.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.20 ms 最後のクエリの後:0.04 ms クエリメモリ:0.027 MB クエリ前のメモリ:18.727 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`= '1621326'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 SIMPLE u NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 SIMPLE s NULL ref userid userid 5 const 1 100.00 Using where
Status Duration starting 0.02 ms checking query cache for query 0.01 ms checking privileges on cached 0.00 ms checking permissions 0.16 ms checking permissions 0.01 ms checking permissions 0.02 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.04 ms System lock 0.04 ms optimizing 0.02 ms statistics 0.10 ms preparing 0.03 ms executing 0.00 ms Sending data 0.06 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.01 ms
# 発信者 ファイルと行番号 23 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:168222 JDatabaseDriver->loadObject() Copy JROOT/components/com_community/libraries/user.php:16821 CUser->init() Copy JROOT/components/com_community/libraries/core.php:20120 CFactory::getUser() Copy JROOT/plugins/kunena/community/profile.php:5819 KunenaProfileCommunity->getProfileURL() Copy JROOT/libraries/kunena/user/user.php:66318 KunenaUser->getURL() Copy JROOT/libraries/kunena/user/user.php:60217 KunenaUser->getLink() Copy JROOT/libraries/kunena/forum/statistics.php:34716 KunenaForumStatistics->loadTopProfiles() Copy JROOT/libraries/kunena/forum/statistics.php:12315 KunenaForumStatistics->loadUserStats() Copy JROOT/libraries/kunena/forum/statistics.php:9014 KunenaForumStatistics->loadAll() Copy JROOT/components/com_kunena/controller/statistics/general/display.php:4613 ComponentKunenaControllerStatisticsGeneralDisplay->before() Copy JROOT/libraries/kunena/controller/display.php:3112 KunenaControllerDisplay->execute() Copy JROOT/libraries/kunena/layout/page.php:4611 KunenaLayoutPage->execute() Copy JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php:1310 include Copy JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php Copy JROOT/libraries/kunena/layout/base.php:1839 KunenaLayoutBase->render() Copy JROOT/libraries/kunena/layout/layout.php:688 KunenaLayout->render() Copy JROOT/libraries/kunena/controller/application/display.php:1237 KunenaControllerApplicationDisplay->execute() Copy JROOT/components/com_kunena/kunena.php:966 require_once Copy JROOT/components/com_kunena/kunena.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.61 ms 最後のクエリの後:0.09 ms クエリメモリ:0.027 MB クエリ前のメモリ:18.755 MB 返された行:0
SELECT `value` FROM `joom_community_fields_values ` WHERE `field_id` = '2' AND `user_id` = '1621326'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.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
# 発信者 ファイルと行番号 25 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:176024 JDatabaseDriver->loadResult() Copy JROOT/components/com_community/models/profile.php:77123 CommunityModelProfile->getGender() Copy JROOT/components/com_community/libraries/user.php:62922 CUser->_getGender() Copy JROOT/components/com_community/libraries/user.php:76721 CUser->getThumbAvatar() Copy JROOT/components/com_community/libraries/core.php:20220 CFactory::getUser() Copy JROOT/plugins/kunena/community/profile.php:5819 KunenaProfileCommunity->getProfileURL() Copy JROOT/libraries/kunena/user/user.php:66318 KunenaUser->getURL() Copy JROOT/libraries/kunena/user/user.php:60217 KunenaUser->getLink() Copy JROOT/libraries/kunena/forum/statistics.php:34716 KunenaForumStatistics->loadTopProfiles() Copy JROOT/libraries/kunena/forum/statistics.php:12315 KunenaForumStatistics->loadUserStats() Copy JROOT/libraries/kunena/forum/statistics.php:9014 KunenaForumStatistics->loadAll() Copy JROOT/components/com_kunena/controller/statistics/general/display.php:4613 ComponentKunenaControllerStatisticsGeneralDisplay->before() Copy JROOT/libraries/kunena/controller/display.php:3112 KunenaControllerDisplay->execute() Copy JROOT/libraries/kunena/layout/page.php:4611 KunenaLayoutPage->execute() Copy JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php:1310 include Copy JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php Copy JROOT/libraries/kunena/layout/base.php:1839 KunenaLayoutBase->render() Copy JROOT/libraries/kunena/layout/layout.php:688 KunenaLayout->render() Copy JROOT/libraries/kunena/controller/application/display.php:1237 KunenaControllerApplicationDisplay->execute() Copy JROOT/components/com_kunena/kunena.php:966 require_once Copy JROOT/components/com_kunena/kunena.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.62 ms 最後のクエリの後:0.26 ms クエリメモリ:0.025 MB クエリ前のメモリ:18.769 MB 返された行:0
SELECT `t`.`targetuserid` AS `id`,COUNT (t.targetuserid) AS count
FROM `joom_kunena_thankyou ` AS `t`
INNER JOIN `joom_users ` AS `u` ON `u`.`id` = `t`.`targetuserid`
GROUP BY `t`.`targetuserid`
ORDER BY `count` DESC LIMIT 5id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE t NULL index targetuserid targetuserid 4 NULL 1 100.00 Using index; Using temporary; filesortの使用 1 SIMPLE u NULL eq_ref PRIMARY PRIMARY 4 root_db.t.targetuserid 1 100.00 Using index
Status Duration starting 0.01 ms checking query cache for query 0.01 ms checking privileges on cached 0.00 ms checking permissions 0.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
# 発信者 ファイルと行番号 18 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172117 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/kunena/forum/statistics.php:43816 KunenaForumStatistics->loadTopThankyous() Copy JROOT/libraries/kunena/forum/statistics.php:13215 KunenaForumStatistics->loadUserStats() Copy JROOT/libraries/kunena/forum/statistics.php:9014 KunenaForumStatistics->loadAll() Copy JROOT/components/com_kunena/controller/statistics/general/display.php:4613 ComponentKunenaControllerStatisticsGeneralDisplay->before() Copy JROOT/libraries/kunena/controller/display.php:3112 KunenaControllerDisplay->execute() Copy JROOT/libraries/kunena/layout/page.php:4611 KunenaLayoutPage->execute() Copy JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php:1310 include Copy JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php Copy JROOT/libraries/kunena/layout/base.php:1839 KunenaLayoutBase->render() Copy JROOT/libraries/kunena/layout/layout.php:688 KunenaLayout->render() Copy JROOT/libraries/kunena/controller/application/display.php:1237 KunenaControllerApplicationDisplay->execute() Copy JROOT/components/com_kunena/kunena.php:966 require_once Copy JROOT/components/com_kunena/kunena.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.61 ms 最後のクエリの後:0.06 ms クエリメモリ:0.026 MB クエリ前のメモリ:18.787 MB 返された行:1
SELECT u.name, u.username, u.email, u.block as blocked, u.registerDate, u.lastvisitDate, ku.*
FROM joom_users AS u
LEFT JOIN joom_kunena_users AS ku ON u.id = ku.userid
WHERE u.id = 1621330id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE u NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 SIMPLE ku NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL
Status Duration starting 0.01 ms checking query cache for query 0.01 ms checking privileges on cached 0.00 ms checking permissions 0.01 ms checking permissions 0.01 ms sending cached result to clien 0.02 ms cleaned up 0.01 ms cleaning up 0.00 ms
# 発信者 ファイルと行番号 20 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:148519 JDatabaseDriver->loadAssoc() Copy JROOT/libraries/kunena/tables/kunenausers.php:36518 TableKunenaUsers->load() Copy JROOT/libraries/kunena/user/user.php:28017 KunenaUser->load() Copy JROOT/libraries/kunena/user/user.php:10016 KunenaUser->__construct() Copy JROOT/libraries/kunena/user/helper.php:11515 KunenaUserHelper::get() Copy JROOT/libraries/kunena/factory.php:7114 KunenaFactory::getUser() Copy JROOT/components/com_kunena/controller/statistics/general/display.php:4913 ComponentKunenaControllerStatisticsGeneralDisplay->before() Copy JROOT/libraries/kunena/controller/display.php:3112 KunenaControllerDisplay->execute() Copy JROOT/libraries/kunena/layout/page.php:4611 KunenaLayoutPage->execute() Copy JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php:1310 include Copy JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php Copy JROOT/libraries/kunena/layout/base.php:1839 KunenaLayoutBase->render() Copy JROOT/libraries/kunena/layout/layout.php:688 KunenaLayout->render() Copy JROOT/libraries/kunena/controller/application/display.php:1237 KunenaControllerApplicationDisplay->execute() Copy JROOT/components/com_kunena/kunena.php:966 require_once Copy JROOT/components/com_kunena/kunena.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.08 ms クエリメモリ:0.026 MB クエリ前のメモリ:18.797 MB 返された行:1
SELECT a.`userid` as _userid , a.`status` as _status , a.`points` as _points, a.`posted_on` as _posted_on, a.`avatar` as _avatar , a.`thumb` as _thumb , a.`invite` as _invite, a.`params` as _cparams, a.`view` as _view, a.`friends` as _friends, a.`groups` as _groups, a.`events` as _events, a.`alias` as _alias, a.`profile_id` as _profile_id, a.`friendcount` as _friendcount, a.`storage` as _storage, a.`watermark_hash` as _watermark_hash, a.`search_email` AS _search_email, s.`userid` as _isonline, u.* FROM `joom_community_users ` as a LEFT JOIN `joom_users ` u ON u.`id`= a.`userid` LEFT OUTER JOIN `joom_session `s ON s.`userid`= a.`userid` WHERE a.`userid` IN (1621330)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 SIMPLE u NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 SIMPLE s NULL ref userid userid 5 const 1 100.00 Using index
Status Duration starting 0.01 ms checking query cache for query 0.01 ms checking privileges on cached 0.00 ms checking permissions 0.16 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.04 ms System lock 0.03 ms optimizing 0.01 ms statistics 0.10 ms preparing 0.02 ms executing 0.00 ms Sending data 0.05 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms storing result in query cache 0.01 ms cleaned up 0.01 ms cleaning up 0.02 ms
# 発信者 ファイルと行番号 19 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172118 JDatabaseDriver->loadObjectList() Copy JROOT/components/com_community/libraries/core.php:12417 CFactory::loadUsers() Copy JROOT/plugins/kunena/community/avatar.php:3716 KunenaAvatarCommunity->load() Copy JROOT/libraries/kunena/user/helper.php:11915 KunenaUserHelper::get() Copy JROOT/libraries/kunena/factory.php:7114 KunenaFactory::getUser() Copy JROOT/components/com_kunena/controller/statistics/general/display.php:4913 ComponentKunenaControllerStatisticsGeneralDisplay->before() Copy JROOT/libraries/kunena/controller/display.php:3112 KunenaControllerDisplay->execute() Copy JROOT/libraries/kunena/layout/page.php:4611 KunenaLayoutPage->execute() Copy JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php:1310 include Copy JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php Copy JROOT/libraries/kunena/layout/base.php:1839 KunenaLayoutBase->render() Copy JROOT/libraries/kunena/layout/layout.php:688 KunenaLayout->render() Copy JROOT/libraries/kunena/controller/application/display.php:1237 KunenaControllerApplicationDisplay->execute() Copy JROOT/components/com_kunena/kunena.php:966 require_once Copy JROOT/components/com_kunena/kunena.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.68 ms 最後のクエリの後:0.09 ms クエリメモリ:0.026 MB クエリ前のメモリ:18.828 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.02 ms cleaned up 0.01 ms cleaning up 0.00 ms
# 発信者 ファイルと行番号 22 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:176021 JDatabaseDriver->loadResult() Copy JROOT/components/com_community/models/profile.php:77120 CommunityModelProfile->getGender() Copy JROOT/components/com_community/libraries/user.php:62919 CUser->_getGender() Copy JROOT/components/com_community/libraries/user.php:76718 CUser->getThumbAvatar() Copy JROOT/components/com_community/libraries/core.php:13017 CFactory::loadUsers() Copy JROOT/plugins/kunena/community/avatar.php:3716 KunenaAvatarCommunity->load() Copy JROOT/libraries/kunena/user/helper.php:11915 KunenaUserHelper::get() Copy JROOT/libraries/kunena/factory.php:7114 KunenaFactory::getUser() Copy JROOT/components/com_kunena/controller/statistics/general/display.php:4913 ComponentKunenaControllerStatisticsGeneralDisplay->before() Copy JROOT/libraries/kunena/controller/display.php:3112 KunenaControllerDisplay->execute() Copy JROOT/libraries/kunena/layout/page.php:4611 KunenaLayoutPage->execute() Copy JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php:1310 include Copy JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php Copy JROOT/libraries/kunena/layout/base.php:1839 KunenaLayoutBase->render() Copy JROOT/libraries/kunena/layout/layout.php:688 KunenaLayout->render() Copy JROOT/libraries/kunena/controller/application/display.php:1237 KunenaControllerApplicationDisplay->execute() Copy JROOT/components/com_kunena/kunena.php:966 require_once Copy JROOT/components/com_kunena/kunena.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.63 ms 最後のクエリの後:0.14 ms クエリメモリ:0.025 MB クエリ前のメモリ:18.816 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.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
# 発信者 ファイルと行番号 19 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:176018 JDatabaseDriver->loadResult() Copy JROOT/components/com_community/libraries/core.php:19017 CFactory::getUser() Copy JROOT/plugins/kunena/community/profile.php:5816 KunenaProfileCommunity->getProfileURL() Copy JROOT/libraries/kunena/user/user.php:66315 KunenaUser->getURL() Copy JROOT/libraries/kunena/user/user.php:60214 KunenaUser->getLink() Copy JROOT/components/com_kunena/controller/statistics/general/display.php:4913 ComponentKunenaControllerStatisticsGeneralDisplay->before() Copy JROOT/libraries/kunena/controller/display.php:3112 KunenaControllerDisplay->execute() Copy JROOT/libraries/kunena/layout/page.php:4611 KunenaLayoutPage->execute() Copy JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php:1310 include Copy JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php Copy JROOT/libraries/kunena/layout/base.php:1839 KunenaLayoutBase->render() Copy JROOT/libraries/kunena/layout/layout.php:688 KunenaLayout->render() Copy JROOT/libraries/kunena/controller/application/display.php:1237 KunenaControllerApplicationDisplay->execute() Copy JROOT/components/com_kunena/kunena.php:966 require_once Copy JROOT/components/com_kunena/kunena.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.11 ms 最後のクエリの後:0.04 ms クエリメモリ:0.026 MB クエリ前のメモリ:18.828 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.01 ms checking query cache for query 0.01 ms checking privileges on cached 0.00 ms checking permissions 0.15 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.04 ms System lock 0.03 ms optimizing 0.02 ms statistics 0.10 ms preparing 0.02 ms executing 0.00 ms Sending data 0.06 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
# 発信者 ファイルと行番号 20 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:168219 JDatabaseDriver->loadObject() Copy JROOT/components/com_community/libraries/user.php:16818 CUser->init() Copy JROOT/components/com_community/libraries/core.php:20117 CFactory::getUser() Copy JROOT/plugins/kunena/community/profile.php:5816 KunenaProfileCommunity->getProfileURL() Copy JROOT/libraries/kunena/user/user.php:66315 KunenaUser->getURL() Copy JROOT/libraries/kunena/user/user.php:60214 KunenaUser->getLink() Copy JROOT/components/com_kunena/controller/statistics/general/display.php:4913 ComponentKunenaControllerStatisticsGeneralDisplay->before() Copy JROOT/libraries/kunena/controller/display.php:3112 KunenaControllerDisplay->execute() Copy JROOT/libraries/kunena/layout/page.php:4611 KunenaLayoutPage->execute() Copy JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php:1310 include Copy JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php Copy JROOT/libraries/kunena/layout/base.php:1839 KunenaLayoutBase->render() Copy JROOT/libraries/kunena/layout/layout.php:688 KunenaLayout->render() Copy JROOT/libraries/kunena/controller/application/display.php:1237 KunenaControllerApplicationDisplay->execute() Copy JROOT/components/com_kunena/kunena.php:966 require_once Copy JROOT/components/com_kunena/kunena.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.64 ms 最後のクエリの後:0.08 ms クエリメモリ:0.026 MB クエリ前のメモリ:18.854 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.01 ms sending cached result to clien 0.02 ms cleaned up 0.01 ms cleaning up 0.00 ms
# 発信者 ファイルと行番号 22 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:176021 JDatabaseDriver->loadResult() Copy JROOT/components/com_community/models/profile.php:77120 CommunityModelProfile->getGender() Copy JROOT/components/com_community/libraries/user.php:62919 CUser->_getGender() Copy JROOT/components/com_community/libraries/user.php:76718 CUser->getThumbAvatar() Copy JROOT/components/com_community/libraries/core.php:20217 CFactory::getUser() Copy JROOT/plugins/kunena/community/profile.php:5816 KunenaProfileCommunity->getProfileURL() Copy JROOT/libraries/kunena/user/user.php:66315 KunenaUser->getURL() Copy JROOT/libraries/kunena/user/user.php:60214 KunenaUser->getLink() Copy JROOT/components/com_kunena/controller/statistics/general/display.php:4913 ComponentKunenaControllerStatisticsGeneralDisplay->before() Copy JROOT/libraries/kunena/controller/display.php:3112 KunenaControllerDisplay->execute() Copy JROOT/libraries/kunena/layout/page.php:4611 KunenaLayoutPage->execute() Copy JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php:1310 include Copy JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php Copy JROOT/libraries/kunena/layout/base.php:1839 KunenaLayoutBase->render() Copy JROOT/libraries/kunena/layout/layout.php:688 KunenaLayout->render() Copy JROOT/libraries/kunena/controller/application/display.php:1237 KunenaControllerApplicationDisplay->execute() Copy JROOT/components/com_kunena/kunena.php:966 require_once Copy JROOT/components/com_kunena/kunena.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.65 ms 最後のクエリの後:0.20 ms クエリメモリ:0.025 MB クエリ前のメモリ:18.865 MB 返された行:0
SELECT `id` FROM `joom_menu ` WHERE `link` LIKE '%option= com_community&view= search%' AND `published`= '1' AND `menutype`!= 'jomsocial' AND `type`= 'component'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE joom_menu NULL ALL idx_menutype インデックスキーを使用できませんでした NULL NULL 257 0.39 Using where
Status Duration starting 0.02 ms checking query cache for query 0.01 ms checking privileges on cached 0.00 ms checking permissions 0.01 ms sending cached result to clien 0.02 ms cleaned up 0.01 ms cleaning up 0.00 ms
# 発信者 ファイルと行番号 18 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:176017 JDatabaseDriver->loadResult() Copy JROOT/components/com_community/libraries/core.php:139116 CRoute::_getViewItemid() Copy JROOT/components/com_community/libraries/core.php:130115 CRoute::_() Copy JROOT/plugins/kunena/community/profile.php:4514 KunenaProfileCommunity->getUserListURL() Copy JROOT/components/com_kunena/controller/statistics/general/display.php:5013 ComponentKunenaControllerStatisticsGeneralDisplay->before() Copy JROOT/libraries/kunena/controller/display.php:3112 KunenaControllerDisplay->execute() Copy JROOT/libraries/kunena/layout/page.php:4611 KunenaLayoutPage->execute() Copy JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php:1310 include Copy JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php Copy JROOT/libraries/kunena/layout/base.php:1839 KunenaLayoutBase->render() Copy JROOT/libraries/kunena/layout/layout.php:688 KunenaLayout->render() Copy JROOT/libraries/kunena/controller/application/display.php:1237 KunenaControllerApplicationDisplay->execute() Copy JROOT/components/com_kunena/kunena.php:966 require_once Copy JROOT/components/com_kunena/kunena.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.60 ms 最後のクエリの後:0.04 ms クエリメモリ:0.025 MB クエリ前のメモリ:18.874 MB 返された行:0
SELECT `id` FROM `joom_menu ` WHERE `link` = 'index.php?option= com_community&view= frontpage' AND `published`= '1' AND `type`= 'component' AND (`language` = 'ja-JA ' )id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE joom_menu NULL ref idx_language idx_language 28 const 1 5.00 Using where
Status Duration starting 0.01 ms checking query cache for query 0.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
# 発信者 ファイルと行番号 18 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:176017 JDatabaseDriver->loadResult() Copy JROOT/components/com_community/libraries/core.php:143116 CRoute::_getDefaultItemid() Copy JROOT/components/com_community/libraries/core.php:131615 CRoute::_() Copy JROOT/plugins/kunena/community/profile.php:4514 KunenaProfileCommunity->getUserListURL() Copy JROOT/components/com_kunena/controller/statistics/general/display.php:5013 ComponentKunenaControllerStatisticsGeneralDisplay->before() Copy JROOT/libraries/kunena/controller/display.php:3112 KunenaControllerDisplay->execute() Copy JROOT/libraries/kunena/layout/page.php:4611 KunenaLayoutPage->execute() Copy JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php:1310 include Copy JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php Copy JROOT/libraries/kunena/layout/base.php:1839 KunenaLayoutBase->render() Copy JROOT/libraries/kunena/layout/layout.php:688 KunenaLayout->render() Copy JROOT/libraries/kunena/controller/application/display.php:1237 KunenaControllerApplicationDisplay->execute() Copy JROOT/components/com_kunena/kunena.php:966 require_once Copy JROOT/components/com_kunena/kunena.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.61 ms 最後のクエリの後:0.03 ms クエリメモリ:0.026 MB クエリ前のメモリ:18.883 MB 返された行:27
SELECT `id` FROM `joom_menu ` WHERE `link` LIKE '%option= com_community%' AND `published`= '1' AND `type`= 'component'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE joom_menu NULL ALL NULL インデックスキーを使用できませんでした NULL NULL 257 0.39 Using where
Status Duration starting 0.01 ms checking query cache for query 0.01 ms checking privileges on cached 0.00 ms checking permissions 0.01 ms sending cached result to clien 0.02 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/libraries/core.php:144016 CRoute::_getDefaultItemid() Copy JROOT/components/com_community/libraries/core.php:131615 CRoute::_() Copy JROOT/plugins/kunena/community/profile.php:4514 KunenaProfileCommunity->getUserListURL() Copy JROOT/components/com_kunena/controller/statistics/general/display.php:5013 ComponentKunenaControllerStatisticsGeneralDisplay->before() Copy JROOT/libraries/kunena/controller/display.php:3112 KunenaControllerDisplay->execute() Copy JROOT/libraries/kunena/layout/page.php:4611 KunenaLayoutPage->execute() Copy JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php:1310 include Copy JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php Copy JROOT/libraries/kunena/layout/base.php:1839 KunenaLayoutBase->render() Copy JROOT/libraries/kunena/layout/layout.php:688 KunenaLayout->render() Copy JROOT/libraries/kunena/controller/application/display.php:1237 KunenaControllerApplicationDisplay->execute() Copy JROOT/components/com_kunena/kunena.php:966 require_once Copy JROOT/components/com_kunena/kunena.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.66 ms 最後のクエリの後:1.94 ms クエリメモリ:0.027 MB クエリ前のメモリ:19.017 MB 返された行:0
SELECT `id` FROM `joom_menu ` WHERE `link` LIKE '%option= com_community&view= register%' AND `published`= '1' AND `menutype`!= 'jomsocial' AND `type`= 'component'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE joom_menu NULL ALL idx_menutype インデックスキーを使用できませんでした NULL NULL 257 0.39 Using where
Status Duration starting 0.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.02 ms cleaning up 0.00 ms
# 発信者 ファイルと行番号 23 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:176022 JDatabaseDriver->loadResult() Copy JROOT/components/com_community/libraries/core.php:139121 CRoute::_getViewItemid() Copy JROOT/components/com_community/libraries/core.php:130120 CRoute::_() Copy JROOT/plugins/kunena/community/login.php:5319 KunenaLoginCommunity->getRegistrationURL() Copy JROOT/libraries/kunena/login.php:16718 KunenaLogin->getRegistrationURL() Copy JROOT/components/com_kunena/controller/widget/login/display.php:6917 ComponentKunenaControllerWidgetLoginDisplay->before() Copy JROOT/libraries/kunena/controller/display.php:3116 KunenaControllerDisplay->execute() Copy JROOT/libraries/kunena/controller/display.php:12715 KunenaControllerDisplay->__toString() Copy JROOT/components/com_kunena/template/nts_kbento/layouts/widget/menubar/default.php:2014 include Copy JROOT/components/com_kunena/template/nts_kbento/layouts/widget/menubar/default.php Copy JROOT/libraries/kunena/layout/base.php:18313 KunenaLayoutBase->render() Copy JROOT/libraries/kunena/layout/layout.php:6812 KunenaLayout->render() Copy JROOT/libraries/kunena/layout/base.php:9111 KunenaLayoutBase->__toString() Copy JROOT/components/com_kunena/template/nts_kbento/layouts/page/default.php:2010 include Copy JROOT/components/com_kunena/template/nts_kbento/layouts/page/default.php Copy JROOT/libraries/kunena/layout/base.php:1839 KunenaLayoutBase->render() Copy JROOT/libraries/kunena/layout/layout.php:688 KunenaLayout->render() Copy JROOT/libraries/kunena/layout/base.php:917 KunenaLayoutBase->__toString() Copy JROOT/components/com_kunena/kunena.php:1316 require_once Copy JROOT/components/com_kunena/kunena.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.20 ms 最後のクエリの後:4.83 ms クエリメモリ:0.034 MB クエリ前のメモリ:19.675 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 20:35:02') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-08-08 20:35:02') AND m.access IN (1,1) AND m.client_id = 0 AND (mm.menuid = 871 OR mm.menuid <= 0) AND m.language IN ('ja-JA ','* ')
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; filesortの使用 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.14 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.06 ms System lock 0.03 ms optimizing 0.03 ms statistics 0.12 ms preparing 0.03 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.01 ms Creating sort index 0.84 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.04 ms cleaned up 0.01 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 31 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172130 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/joomla/cache/controller/callback.php:16929 JCacheControllerCallback->get() Copy JROOT/libraries/cms/module/helper.php:42428 JModuleHelper::getModuleList() Copy JROOT/libraries/cms/module/helper.php:36027 JModuleHelper::load() Copy JROOT/libraries/cms/module/helper.php:8426 JModuleHelper::getModules() Copy JROOT/libraries/joomla/document/html.php:57625 JDocumentHtml->countModules() Copy JROOT/components/com_kunena/layout/widget/module.php:3324 KunenaLayoutWidgetModule->renderPosition() Copy JROOT/components/com_kunena/template/nts_kbento/layouts/widget/module/default.php:1323 include Copy JROOT/components/com_kunena/template/nts_kbento/layouts/widget/module/default.php Copy JROOT/libraries/kunena/layout/base.php:18322 KunenaLayoutBase->render() Copy JROOT/libraries/kunena/layout/layout.php:6821 KunenaLayout->render() Copy JROOT/libraries/kunena/layout/base.php:9120 KunenaLayoutBase->__toString() Copy JROOT/components/com_kunena/template/nts_kbento/layouts/widget/login/login/default.php:6919 include Copy JROOT/components/com_kunena/template/nts_kbento/layouts/widget/login/login/default.php Copy JROOT/libraries/kunena/layout/base.php:18318 KunenaLayoutBase->render() Copy JROOT/libraries/kunena/layout/layout.php:6817 KunenaLayout->render() Copy JROOT/libraries/kunena/layout/base.php:9116 KunenaLayoutBase->__toString() Copy JROOT/libraries/kunena/controller/display.php:15915 KunenaControllerDisplay->__toString() Copy JROOT/components/com_kunena/template/nts_kbento/layouts/widget/menubar/default.php:2014 include Copy JROOT/components/com_kunena/template/nts_kbento/layouts/widget/menubar/default.php Copy JROOT/libraries/kunena/layout/base.php:18313 KunenaLayoutBase->render() Copy JROOT/libraries/kunena/layout/layout.php:6812 KunenaLayout->render() Copy JROOT/libraries/kunena/layout/base.php:9111 KunenaLayoutBase->__toString() Copy JROOT/components/com_kunena/template/nts_kbento/layouts/page/default.php:2010 include Copy JROOT/components/com_kunena/template/nts_kbento/layouts/page/default.php Copy JROOT/libraries/kunena/layout/base.php:1839 KunenaLayoutBase->render() Copy JROOT/libraries/kunena/layout/layout.php:688 KunenaLayout->render() Copy JROOT/libraries/kunena/layout/base.php:917 KunenaLayoutBase->__toString() Copy JROOT/components/com_kunena/kunena.php:1316 require_once Copy JROOT/components/com_kunena/kunena.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.68 ms 最後のクエリの後:0.29 ms クエリメモリ:0.025 MB クエリ前のメモリ:19.651 MB 返された行:1
SELECT special_characters FROM joom_languages WHERE sef = 'ja' 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.02 ms checking query cache for query 0.01 ms checking privileges on cached 0.00 ms checking permissions 0.02 ms sending cached result to clien 0.02 ms cleaned up 0.01 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 19 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:168218 JDatabaseDriver->loadObject() Copy JROOT/libraries/axslibs/language.php:30817 AxsLanguage::getSpecialCharacters() Copy JROOT/libraries/axslibs/language.php:2616 AxsLanguage::translate() Copy JROOT/libraries/axslibs/language.php:43615 AxsLanguage::getLocalizationVariable() Copy JROOT/components/com_kunena/template/nts_kbento/layouts/widget/breadcrumb/default.php:2614 include Copy JROOT/components/com_kunena/template/nts_kbento/layouts/widget/breadcrumb/default.php Copy JROOT/libraries/kunena/layout/base.php:18313 KunenaLayoutBase->render() Copy JROOT/libraries/kunena/layout/layout.php:6812 KunenaLayout->render() Copy JROOT/libraries/kunena/layout/base.php:9111 KunenaLayoutBase->__toString() Copy JROOT/components/com_kunena/template/nts_kbento/layouts/page/default.php:3010 include Copy JROOT/components/com_kunena/template/nts_kbento/layouts/page/default.php Copy JROOT/libraries/kunena/layout/base.php:1839 KunenaLayoutBase->render() Copy JROOT/libraries/kunena/layout/layout.php:688 KunenaLayout->render() Copy JROOT/libraries/kunena/layout/base.php:917 KunenaLayoutBase->__toString() Copy JROOT/components/com_kunena/kunena.php:1316 require_once Copy JROOT/components/com_kunena/kunena.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.62 ms 最後のクエリの後:0.03 ms クエリメモリ:0.028 MB クエリ前のメモリ:19.663 MB 返された行:25
SELECT *
FROM axs_translations
WHERE language_tag = 'ja'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 25 100.00 NULL
Status Duration starting 0.01 ms checking query cache for query 0.01 ms checking privileges on cached 0.00 ms checking permissions 0.01 ms sending cached result to clien 0.02 ms cleaned up 0.01 ms cleaning up 0.02 ms
# 発信者 ファイルと行番号 19 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:152618 JDatabaseDriver->loadAssocList() Copy JROOT/libraries/axslibs/language.php:15017 AxsLanguage::getTranslationMap() Copy JROOT/libraries/axslibs/language.php:3916 AxsLanguage::translate() Copy JROOT/libraries/axslibs/language.php:43615 AxsLanguage::getLocalizationVariable() Copy JROOT/components/com_kunena/template/nts_kbento/layouts/widget/breadcrumb/default.php:2614 include Copy JROOT/components/com_kunena/template/nts_kbento/layouts/widget/breadcrumb/default.php Copy JROOT/libraries/kunena/layout/base.php:18313 KunenaLayoutBase->render() Copy JROOT/libraries/kunena/layout/layout.php:6812 KunenaLayout->render() Copy JROOT/libraries/kunena/layout/base.php:9111 KunenaLayoutBase->__toString() Copy JROOT/components/com_kunena/template/nts_kbento/layouts/page/default.php:3010 include Copy JROOT/components/com_kunena/template/nts_kbento/layouts/page/default.php Copy JROOT/libraries/kunena/layout/base.php:1839 KunenaLayoutBase->render() Copy JROOT/libraries/kunena/layout/layout.php:688 KunenaLayout->render() Copy JROOT/libraries/kunena/layout/base.php:917 KunenaLayoutBase->__toString() Copy JROOT/components/com_kunena/kunena.php:1316 require_once Copy JROOT/components/com_kunena/kunena.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.40 ms クエリメモリ:0.023 MB クエリ前のメモリ:19.700 MB 返された行:0
SELECT *
FROM joom_kunena_announcement
WHERE (published = 1) AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2024-08-08 20:35:02') AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2024-08-08 20:35:02')
ORDER BY id DESC LIMIT 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE joom_kunena_announcement NULL index NULL PRIMARY 4 NULL 1 100.00 Using where
Status Duration starting 0.02 ms checking query cache for query 0.07 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.05 ms System lock 0.02 ms optimizing 0.02 ms statistics 0.03 ms preparing 0.02 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.03 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms storing result in query cache 0.01 ms cleaned up 0.01 ms cleaning up 0.03 ms
# 発信者 ファイルと行番号 16 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:152615 JDatabaseDriver->loadAssocList() Copy JROOT/libraries/kunena/forum/announcement/helper.php:13114 KunenaForumAnnouncementHelper::getAnnouncements() Copy JROOT/components/com_kunena/controller/widget/announcement/display.php:4013 ComponentKunenaControllerWidgetAnnouncementDisplay->before() Copy JROOT/libraries/kunena/controller/display.php:3112 KunenaControllerDisplay->execute() Copy JROOT/libraries/kunena/controller/display.php:12711 KunenaControllerDisplay->__toString() Copy JROOT/components/com_kunena/template/nts_kbento/layouts/page/default.php:3510 include Copy JROOT/components/com_kunena/template/nts_kbento/layouts/page/default.php Copy JROOT/libraries/kunena/layout/base.php:1839 KunenaLayoutBase->render() Copy JROOT/libraries/kunena/layout/layout.php:688 KunenaLayout->render() Copy JROOT/libraries/kunena/layout/base.php:917 KunenaLayoutBase->__toString() Copy JROOT/components/com_kunena/kunena.php:1316 require_once Copy JROOT/components/com_kunena/kunena.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.70 ms 最後のクエリの後:1.94 ms クエリメモリ:0.021 MB クエリ前のメモリ:19.809 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.00 ms checking permissions 0.02 ms sending cached result to clien 0.03 ms cleaned up 0.01 ms cleaning up 0.00 ms
# 発信者 ファイルと行番号 10 JDatabaseDriverMysqli->execute() 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
クエリ時間:0.71 ms 最後のクエリの後:3.24 ms クエリメモリ:0.022 MB クエリ前のメモリ:20.148 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.03 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
クエリ時間:0.61 ms 最後のクエリの後:0.11 ms クエリメモリ:0.023 MB クエリ前のメモリ:20.154 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.01 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.59 ms 最後のクエリの後:0.27 ms クエリメモリ:0.022 MB クエリ前のメモリ:20.190 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.01 ms cleaned up 0.02 ms cleaning up 0.01 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
クエリ時間:0.97 ms 最後のクエリの後:1.35 ms クエリメモリ:0.022 MB クエリ前のメモリ:20.242 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.10 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.02 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
クエリ時間:0.63 ms 最後のクエリの後:0.66 ms クエリメモリ:0.023 MB クエリ前のメモリ:20.153 MB 返された行:1
SELECT sef FROM joom_languages WHERE lang_code = 'ja-JA ' 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.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.03 ms cleaned up 0.01 ms cleaning up 0.00 ms
# 発信者 ファイルと行番号 14 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:168213 JDatabaseDriver->loadObject() Copy JROOT/libraries/axslibs/language.php:28512 AxsLanguage::getSefByLangCode() Copy JROOT/modules/mod_mediamodal/tmpl/default.php:811 require Copy JROOT/modules/mod_mediamodal/tmpl/default.php Copy JROOT/modules/mod_mediamodal/mod_mediamodal.php:910 include Copy JROOT/modules/mod_mediamodal/mod_mediamodal.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
クエリ時間:0.65 ms 最後のクエリの後:3.09 ms クエリメモリ:0.026 MB クエリ前のメモリ:20.391 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.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
# 発信者 ファイルと行番号 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
クエリ時間:0.69 ms 最後のクエリの後:3.07 ms クエリメモリ:0.023 MB クエリ前のメモリ:20.500 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 = 871id 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 checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.00 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: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
12×SELECT `value` FROM `joom_community_fields_values ` 7×SELECT a.`userid` as _userid , a.`status` as _status , a.`points` as _points, a.`posted_on` as _posted_on, a.`avatar` as _avatar , a.`thumb` as _thumb , a.`invite` as _invite, a.`params` as _cparams, a.`view` as _view, a.`friends` as _friends, a.`groups` as _groups, a.`events` as _events, a.`alias` as _alias, a.`profile_id` as _profile_id, a.`friendcount` as _friendcount, a.`storage` as _storage, a.`watermark_hash` as _watermark_hash, a.`search_email` AS _search_email, s.`userid` as _isonline, u.* FROM `joom_community_users ` as a LEFT JOIN `joom_users ` u ON u.`id`= a.`userid` LEFT OUTER JOIN `joom_session `s ON s.`userid`= a.`userid` 7×SELECT `id` FROM `joom_users ` 6×SELECT u.name, u.username, u.email, u.block as blocked, u.registerDate, u.lastvisitDate, ku.* FROM joom_users AS u LEFT JOIN joom_kunena_users AS ku ON u.id = ku.userid 6×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' 5×SELECT * FROM `joom_kunena_topics ` 5×SELECT `id` FROM `joom_menu ` 2×SELECT DISTINCT (user_id) FROM joom_usergroups as ug1 INNER JOIN joom_usergroups AS ug2 ON ug2.lft>= ug1.lft AND ug1.rgt>= ug2.rgt INNER JOIN joom_user_usergroup_map AS m ON ug2.id= m.group_id 2×SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `joom_extensions ` 2×SELECT * FROM joom_languages 1×SELECT language,id FROM `joom_menu ` 1×SELECT poll.threadid AS id, SUM (opt.votes) AS count FROM joom_kunena_polls_options AS opt INNER JOIN joom_kunena_polls AS poll ON poll.id= opt.pollid GROUP BY pollid HAVING count > 0 1×SELECT `u`.`id`,`ku`.`posts` AS `count` FROM `joom_kunena_users ` AS `ku` INNER JOIN `joom_users ` AS `u` ON `u`.`id` = `ku`.`userid` 1×SELECT cu.userid AS id, cu.view AS count FROM joom_community_users AS cu INNER JOIN joom_users AS u ON u.id= cu.userid 1×SELECT * FROM joom_easyblog_configs 1×SELECT sef FROM joom_languages 1×SELECT * FROM joom_community_config 1×SELECT * FROM joom_extensions 1×SELECT `id` FROM `joom_community_fields ` 1×SELECT * FROM joom_kunena_announcement 1×SELECT * FROM axs_notifications 1×SELECT * FROM accessibility_images 1×SELECT * FROM axs_fonts 1×SELECT * FROM `currency` 1×SELECT COUNT (* ) FROM joom_kunena_topics AS tt 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 special_characters FROM joom_languages 1×SELECT * FROM axs_translations 1×SELECT `t`.`targetuserid` AS `id`,COUNT (t.targetuserid) AS count FROM `joom_kunena_thankyou ` AS `t` INNER JOIN `joom_users ` AS `u` ON `u`.`id` = `t`.`targetuserid` GROUP BY `t`.`targetuserid` 1×SELECT groupid FROM joom_community_groups_members 1×SELECT SUM (time>= 1723075200 AND parent= 0) AS todayTopicCount, SUM (time>= 1723075200 AND parent>0) AS todayReplyCount, SUM (time>= 1722988800 AND time<1723075200 AND parent= 0) AS yesterdayTopicCount, SUM (time>= 1722988800 AND time<1723075200 AND parent>0) AS yesterdayReplyCount FROM joom_kunena_messages 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 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 `id`,`title` FROM `joom_usergroups ` 1×SELECT id, rules FROM `joom_viewlevels 1×SELECT * FROM joom_kunena_configuration 1×SELECT * FROM joom_kunena_aliases 1×SELECT params FROM axs_user_settings 1×SELECT * FROM `joom_users ` 1×SELECT id, home, template, s.params FROM joom_template_styles as s LEFT JOIN joom_extensions as e ON e.element= s.template AND e.type= 'template' AND e.client_id= s.client_id 1×SELECT g.memberid AS user_id, c.id AS category_id, 2 AS role FROM joom_kunena_categories AS c INNER JOIN joom_community_groups_members AS g ON c.accesstype= 'jomsocial' AND c.access= g.groupid 1×SELECT `id`,`name`,`rules`,`parent_id` FROM `joom_assets ` 1×SELECT user_id, category_id, role FROM joom_kunena_user_categories 1×SELECT COUNT (* ), MAX (id) FROM joom_users 1×SELECT * FROM joom_kunena_categories 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`