クエリ時間:1.21 ms クエリメモリ:0.020 MB クエリ前のメモリ:6.310 MB 返された行:1
SELECT session_id
FROM `joom_session `
WHERE `session_id` = '7kvgstlcf1885djml04qftlj0g' LIMIT 1クエリではEXPLAINは使用できません:SELECT session_id
FROM `joom_session`
WHERE `session_id` = '7kvgstlcf1885djml04qftlj0g' LIMIT 1
Status Duration starting 0.07 ms Executing hook on transaction 0.01 ms starting 0.02 ms checking permissions 0.00 ms Opening tables 0.05 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.01 ms executing 0.01 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 8 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:16547 JDatabaseDriver->loadObject() Copy JROOT/libraries/cms/application/cms.php:1736 JApplicationCms->checkSession() Copy JROOT/libraries/cms/application/cms.php:8625 JApplicationCms->loadSession() Copy JROOT/libraries/cms/application/cms.php:1294 JApplicationCms->__construct() Copy JROOT/libraries/cms/application/site.php:633 JApplicationSite->__construct() Copy JROOT/libraries/cms/application/cms.php:4692 JApplicationCms::getInstance() Copy JROOT/libraries/joomla/factory.php:1331 JFactory::getApplication() Copy JROOT/index.php:48
クエリ時間:7.77 ms 最後のクエリの後:0.05 ms クエリメモリ:0.003 MB クエリ前のメモリ:6.315 MB
UPDATE `joom_session ` SET `time`= '1782316657' WHERE `session_id` = '7kvgstlcf1885djml04qftlj0g'クエリではEXPLAINは使用できません:UPDATE `joom_session` SET `time`='1782316657' WHERE `session_id` = '7kvgstlcf1885djml04qftlj0g'
Status Duration starting 0.04 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.01 ms System lock 0.04 ms updating 0.27 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.10 ms closing tables 0.01 ms freeing items 0.01 ms async commit 6.32 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 8 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:22857 JDatabaseDriver->updateObject() Copy JROOT/libraries/cms/application/cms.php:2176 JApplicationCms->checkSession() Copy JROOT/libraries/cms/application/cms.php:8625 JApplicationCms->loadSession() Copy JROOT/libraries/cms/application/cms.php:1294 JApplicationCms->__construct() Copy JROOT/libraries/cms/application/site.php:633 JApplicationSite->__construct() Copy JROOT/libraries/cms/application/cms.php:4692 JApplicationCms::getInstance() Copy JROOT/libraries/joomla/factory.php:1331 JFactory::getApplication() Copy JROOT/index.php:48
クエリ時間:1.25 ms 最後のクエリの後:19.17 ms クエリメモリ:0.020 MB クエリ前のメモリ:7.645 MB 返された行:1
SELECT * FROM `axs_brands` WHERE language = 'en-GB ' AND (FIND_IN_SET ('k8s.intg.tovuti.io', domains) > 0) LIMIT 1クエリではEXPLAINは使用できません:SELECT * FROM `axs_brands` WHERE language = 'en-GB' AND (FIND_IN_SET('k8s.intg.tovuti.io', domains) > 0) LIMIT 1
Status Duration starting 0.08 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.05 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.02 ms executing 0.09 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 10 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:16939 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/axslibs/brands.php:3708 AxsBrands::getData() Copy JROOT/libraries/axslibs/brands.php:4377 AxsBrands::getBrandObject() Copy JROOT/libraries/axslibs/brands.php:576 AxsBrands::getBrand() Copy JROOT/libraries/tovuti/Providers/FeatureFlaggingServiceProvider.php:715 Tovuti\Providers\FeatureFlaggingServiceProvider->getClientMetadata() Copy JROOT/libraries/tovuti/Providers/FeatureFlaggingServiceProvider.php:334 Tovuti\Providers\FeatureFlaggingServiceProvider->register() Copy JROOT/libraries/tovuti/Helpers/AppBootstrapHelper.php:1153 Tovuti\Helpers\AppBootstrapHelper::registerProviderWithDependencies() Copy JROOT/libraries/tovuti/Helpers/AppBootstrapHelper.php:902 Tovuti\Helpers\AppBootstrapHelper::bootstrapServices() Copy JROOT/libraries/tovuti/Helpers/AppBootstrapHelper.php:471 Tovuti\Helpers\AppBootstrapHelper::bootstrap() Copy JROOT/index.php:70
クエリ時間:1.45 ms 最後のクエリの後:0.46 ms クエリメモリ:0.021 MB クエリ前のメモリ:7.713 MB 返された行:20
SELECT * FROM joom_languages WHERE published = 1 ORDER BY `title`クエリではEXPLAINは使用できません:SELECT * FROM joom_languages WHERE published = 1 ORDER BY `title`
Status Duration starting 0.04 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.04 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.02 ms executing 0.18 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.02 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 11 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:169310 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/axslibs/language.php:3429 AxsLanguage::getPublishedLanguages() Copy JROOT/libraries/axslibs/language.php:2518 AxsLanguage::getCurrentLanguage() Copy JROOT/libraries/axslibs/brands.php:4537 AxsBrands::getBrandObject() Copy JROOT/libraries/axslibs/brands.php:576 AxsBrands::getBrand() Copy JROOT/libraries/tovuti/Providers/FeatureFlaggingServiceProvider.php:715 Tovuti\Providers\FeatureFlaggingServiceProvider->getClientMetadata() Copy JROOT/libraries/tovuti/Providers/FeatureFlaggingServiceProvider.php:334 Tovuti\Providers\FeatureFlaggingServiceProvider->register() Copy JROOT/libraries/tovuti/Helpers/AppBootstrapHelper.php:1153 Tovuti\Helpers\AppBootstrapHelper::registerProviderWithDependencies() Copy JROOT/libraries/tovuti/Helpers/AppBootstrapHelper.php:902 Tovuti\Helpers\AppBootstrapHelper::bootstrapServices() Copy JROOT/libraries/tovuti/Helpers/AppBootstrapHelper.php:471 Tovuti\Helpers\AppBootstrapHelper::bootstrap() Copy JROOT/index.php:70
クエリ時間:1.10 ms 最後のクエリの後:1.65 ms クエリメモリ:0.020 MB クエリ前のメモリ:8.078 MB 返された行:1
SELECT * FROM `axs_homepage_templates` WHERE id = '1'クエリではEXPLAINは使用できません:SELECT * FROM `axs_homepage_templates` WHERE id = '1'
Status Duration starting 0.05 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.01 ms executing 0.02 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 10 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:16939 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/axslibs/brands.php:5128 AxsBrands::getHomepageTemplate() Copy JROOT/libraries/axslibs/brands.php:4687 AxsBrands::getBrandObject() Copy JROOT/libraries/axslibs/brands.php:576 AxsBrands::getBrand() Copy JROOT/libraries/tovuti/Providers/FeatureFlaggingServiceProvider.php:715 Tovuti\Providers\FeatureFlaggingServiceProvider->getClientMetadata() Copy JROOT/libraries/tovuti/Providers/FeatureFlaggingServiceProvider.php:334 Tovuti\Providers\FeatureFlaggingServiceProvider->register() Copy JROOT/libraries/tovuti/Helpers/AppBootstrapHelper.php:1153 Tovuti\Helpers\AppBootstrapHelper::registerProviderWithDependencies() Copy JROOT/libraries/tovuti/Helpers/AppBootstrapHelper.php:902 Tovuti\Helpers\AppBootstrapHelper::bootstrapServices() Copy JROOT/libraries/tovuti/Helpers/AppBootstrapHelper.php:471 Tovuti\Helpers\AppBootstrapHelper::bootstrap() Copy JROOT/index.php:70
クエリ時間:1.10 ms 最後のクエリの後:0.07 ms クエリメモリ:0.020 MB クエリ前のメモリ:8.118 MB 返された行:1
SELECT * FROM `axs_dashboard_templates` WHERE id = '2'クエリではEXPLAINは使用できません:SELECT * FROM `axs_dashboard_templates` WHERE id = '2'
Status Duration starting 0.04 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.04 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.01 ms executing 0.01 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms
# 発信者 ファイルと行番号 10 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:16939 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/axslibs/brands.php:5208 AxsBrands::getDashboardTemplate() Copy JROOT/libraries/axslibs/brands.php:4847 AxsBrands::getBrandObject() Copy JROOT/libraries/axslibs/brands.php:576 AxsBrands::getBrand() Copy JROOT/libraries/tovuti/Providers/FeatureFlaggingServiceProvider.php:715 Tovuti\Providers\FeatureFlaggingServiceProvider->getClientMetadata() Copy JROOT/libraries/tovuti/Providers/FeatureFlaggingServiceProvider.php:334 Tovuti\Providers\FeatureFlaggingServiceProvider->register() Copy JROOT/libraries/tovuti/Helpers/AppBootstrapHelper.php:1153 Tovuti\Helpers\AppBootstrapHelper::registerProviderWithDependencies() Copy JROOT/libraries/tovuti/Helpers/AppBootstrapHelper.php:902 Tovuti\Helpers\AppBootstrapHelper::bootstrapServices() Copy JROOT/libraries/tovuti/Helpers/AppBootstrapHelper.php:471 Tovuti\Helpers\AppBootstrapHelper::bootstrap() Copy JROOT/index.php:70
クエリ時間:3.46 ms 最後のクエリの後:0.11 ms クエリメモリ:0.020 MB クエリ前のメモリ:8.142 MB 返された行:1
SELECT *
FROM axs_email_settings
WHERE id = '1'クエリではEXPLAINは使用できません:SELECT *
FROM axs_email_settings
WHERE id = '1'
Status Duration starting 0.06 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.01 ms executing 0.01 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.00 ms
# 発信者 ファイルと行番号 10 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:16549 JDatabaseDriver->loadObject() Copy JROOT/libraries/axslibs/brands.php:7928 AxsBrands::getEmailSettingsById() Copy JROOT/libraries/axslibs/brands.php:4907 AxsBrands::getBrandObject() Copy JROOT/libraries/axslibs/brands.php:576 AxsBrands::getBrand() Copy JROOT/libraries/tovuti/Providers/FeatureFlaggingServiceProvider.php:715 Tovuti\Providers\FeatureFlaggingServiceProvider->getClientMetadata() Copy JROOT/libraries/tovuti/Providers/FeatureFlaggingServiceProvider.php:334 Tovuti\Providers\FeatureFlaggingServiceProvider->register() Copy JROOT/libraries/tovuti/Helpers/AppBootstrapHelper.php:1153 Tovuti\Helpers\AppBootstrapHelper::registerProviderWithDependencies() Copy JROOT/libraries/tovuti/Helpers/AppBootstrapHelper.php:902 Tovuti\Helpers\AppBootstrapHelper::bootstrapServices() Copy JROOT/libraries/tovuti/Helpers/AppBootstrapHelper.php:471 Tovuti\Helpers\AppBootstrapHelper::bootstrap() Copy JROOT/index.php:70
クエリ時間:2.49 ms 最後のクエリの後:2.43 ms クエリメモリ:0.039 MB クエリ前のメモリ:8.422 MB 返された行:80
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `joom_extensions `
WHERE `type` = 'component'クエリではEXPLAINは使用できません:SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `joom_extensions`
WHERE `type` = 'component'
Status Duration starting 0.05 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.06 ms preparing 0.01 ms executing 0.30 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 16 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:169315 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/cms/component/helper.php:44714 JComponentHelper::{closure}() Copy JROOT/libraries/joomla/cache/controller/callback.php:16913 JCacheControllerCallback->get() Copy JROOT/libraries/cms/component/helper.php:45512 JComponentHelper::load() Copy JROOT/libraries/cms/component/helper.php:4311 JComponentHelper::getComponent() Copy JROOT/libraries/cms/component/helper.php:11110 JComponentHelper::getParams() Copy JROOT/libraries/joomla/access/access.php:9419 JAccess::getGroupsByUser() Copy JROOT/libraries/joomla/user/user.php:4768 JUser->getAuthorisedGroups() Copy JROOT/libraries/axslibs/brands.php:4917 AxsBrands::getBrandObject() Copy JROOT/libraries/axslibs/brands.php:576 AxsBrands::getBrand() Copy JROOT/libraries/tovuti/Providers/FeatureFlaggingServiceProvider.php:715 Tovuti\Providers\FeatureFlaggingServiceProvider->getClientMetadata() Copy JROOT/libraries/tovuti/Providers/FeatureFlaggingServiceProvider.php:334 Tovuti\Providers\FeatureFlaggingServiceProvider->register() Copy JROOT/libraries/tovuti/Helpers/AppBootstrapHelper.php:1153 Tovuti\Helpers\AppBootstrapHelper::registerProviderWithDependencies() Copy JROOT/libraries/tovuti/Helpers/AppBootstrapHelper.php:902 Tovuti\Helpers\AppBootstrapHelper::bootstrapServices() Copy JROOT/libraries/tovuti/Helpers/AppBootstrapHelper.php:471 Tovuti\Helpers\AppBootstrapHelper::bootstrap() Copy JROOT/index.php:70
クエリ時間:1.28 ms 最後のクエリの後:0.49 ms クエリメモリ:0.021 MB クエリ前のメモリ:8.479 MB 返された行:1
SELECT b.id
FROM joom_usergroups AS a
LEFT JOIN joom_usergroups AS b ON b.lft <= a.lft AND b.rgt >= a.rgt
WHERE a.id = 1クエリではEXPLAINは使用できません:SELECT b.id
FROM joom_usergroups AS a
LEFT JOIN joom_usergroups AS b ON b.lft <= a.lft AND b.rgt >= a.rgt
WHERE a.id = 1
Status Duration starting 0.07 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.02 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.07 ms preparing 0.03 ms executing 0.02 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.00 ms
# 発信者 ファイルと行番号 11 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:154210 JDatabaseDriver->loadColumn() Copy JROOT/libraries/joomla/access/access.php:9829 JAccess::getGroupsByUser() Copy JROOT/libraries/joomla/user/user.php:4768 JUser->getAuthorisedGroups() Copy JROOT/libraries/axslibs/brands.php:4917 AxsBrands::getBrandObject() Copy JROOT/libraries/axslibs/brands.php:576 AxsBrands::getBrand() Copy JROOT/libraries/tovuti/Providers/FeatureFlaggingServiceProvider.php:715 Tovuti\Providers\FeatureFlaggingServiceProvider->getClientMetadata() Copy JROOT/libraries/tovuti/Providers/FeatureFlaggingServiceProvider.php:334 Tovuti\Providers\FeatureFlaggingServiceProvider->register() Copy JROOT/libraries/tovuti/Helpers/AppBootstrapHelper.php:1153 Tovuti\Helpers\AppBootstrapHelper::registerProviderWithDependencies() Copy JROOT/libraries/tovuti/Helpers/AppBootstrapHelper.php:902 Tovuti\Helpers\AppBootstrapHelper::bootstrapServices() Copy JROOT/libraries/tovuti/Helpers/AppBootstrapHelper.php:471 Tovuti\Helpers\AppBootstrapHelper::bootstrap() Copy JROOT/index.php:70
クエリ時間:1.12 ms 最後のクエリの後:0.04 ms クエリメモリ:0.020 MB クエリ前のメモリ:8.484 MB 返された行:1
SELECT *
FROM axs_payment_gateways
WHERE id = '1'クエリではEXPLAINは使用できません:SELECT *
FROM axs_payment_gateways
WHERE id = '1'
Status Duration starting 0.04 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.01 ms executing 0.01 ms end 0.03 ms query end 0.01 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 10 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:16549 JDatabaseDriver->loadObject() Copy JROOT/libraries/axslibs/brands.php:7408 AxsBrands::getPaymentGatewayById() Copy JROOT/libraries/axslibs/brands.php:4937 AxsBrands::getBrandObject() Copy JROOT/libraries/axslibs/brands.php:576 AxsBrands::getBrand() Copy JROOT/libraries/tovuti/Providers/FeatureFlaggingServiceProvider.php:715 Tovuti\Providers\FeatureFlaggingServiceProvider->getClientMetadata() Copy JROOT/libraries/tovuti/Providers/FeatureFlaggingServiceProvider.php:334 Tovuti\Providers\FeatureFlaggingServiceProvider->register() Copy JROOT/libraries/tovuti/Helpers/AppBootstrapHelper.php:1153 Tovuti\Helpers\AppBootstrapHelper::registerProviderWithDependencies() Copy JROOT/libraries/tovuti/Helpers/AppBootstrapHelper.php:902 Tovuti\Helpers\AppBootstrapHelper::bootstrapServices() Copy JROOT/libraries/tovuti/Helpers/AppBootstrapHelper.php:471 Tovuti\Helpers\AppBootstrapHelper::bootstrap() Copy JROOT/index.php:70
クエリ時間:3.25 ms 最後のクエリの後:0.06 ms クエリメモリ:0.020 MB クエリ前のメモリ:8.494 MB 返された行:1
SELECT *
FROM axs_integrations
WHERE id = '1'クエリではEXPLAINは使用できません:SELECT *
FROM axs_integrations
WHERE id = '1'
Status Duration starting 0.05 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.01 ms executing 0.01 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 10 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:16549 JDatabaseDriver->loadObject() Copy JROOT/libraries/axslibs/brands.php:8118 AxsBrands::getIntegrationById() Copy JROOT/libraries/axslibs/brands.php:5007 AxsBrands::getBrandObject() Copy JROOT/libraries/axslibs/brands.php:576 AxsBrands::getBrand() Copy JROOT/libraries/tovuti/Providers/FeatureFlaggingServiceProvider.php:715 Tovuti\Providers\FeatureFlaggingServiceProvider->getClientMetadata() Copy JROOT/libraries/tovuti/Providers/FeatureFlaggingServiceProvider.php:334 Tovuti\Providers\FeatureFlaggingServiceProvider->register() Copy JROOT/libraries/tovuti/Helpers/AppBootstrapHelper.php:1153 Tovuti\Helpers\AppBootstrapHelper::registerProviderWithDependencies() Copy JROOT/libraries/tovuti/Helpers/AppBootstrapHelper.php:902 Tovuti\Helpers\AppBootstrapHelper::bootstrapServices() Copy JROOT/libraries/tovuti/Helpers/AppBootstrapHelper.php:471 Tovuti\Helpers\AppBootstrapHelper::bootstrap() Copy JROOT/index.php:70
クエリ時間:1.32 ms 最後のクエリの後:11.35 ms クエリメモリ:0.020 MB クエリ前のメモリ:9.886 MB 返された行:7
SELECT id, rules
FROM `joom_viewlevels `クエリではEXPLAINは使用できません:SELECT id, rules
FROM `joom_viewlevels`
Status Duration starting 0.04 ms Executing hook on transaction 0.00 ms starting 0.02 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.01 ms System lock 0.01 ms optimizing 0.00 ms statistics 0.01 ms preparing 0.01 ms executing 0.04 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 10 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:14989 JDatabaseDriver->loadAssocList() Copy JROOT/libraries/joomla/access/access.php:10658 JAccess::getAuthorisedViewLevels() Copy JROOT/libraries/joomla/user/user.php:4547 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:2671 JApplicationCms->execute() Copy JROOT/index.php:73
クエリ時間:2.49 ms 最後のクエリの後:0.08 ms クエリメモリ:0.038 MB クエリ前のメモリ:9.911 MB 返された行:142
SELECT `folder` AS `type`,`element` AS `name`,`params`
FROM joom_extensions
WHERE enabled = 1 AND type = 'plugin' AND state IN (0,1) AND access IN (1,1)
ORDER BY orderingクエリではEXPLAINは使用できません:SELECT `folder` AS `type`,`element` AS `name`,`params`
FROM joom_extensions
WHERE enabled = 1 AND type = 'plugin' AND state IN (0,1) AND access IN (1,1)
ORDER BY ordering
Status Duration starting 0.07 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.04 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.09 ms preparing 0.03 ms executing 1.22 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 10 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:16939 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:2671 JApplicationCms->execute() Copy JROOT/index.php:73
クエリ時間:1.46 ms 最後のクエリの後:23.46 ms クエリメモリ:0.023 MB クエリ前のメモリ:12.235 MB 返された行:1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `joom_extensions `
WHERE `type` = 'library' AND `element` = 'joomla'クエリではEXPLAINは使用できません:SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `joom_extensions`
WHERE `type` = 'library' AND `element` = 'joomla'
Status Duration starting 0.06 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.08 ms preparing 0.02 ms executing 0.04 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms
# 発信者 ファイルと行番号 17 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:165416 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:8509 JFactory::createDocument() Copy JROOT/libraries/joomla/factory.php:2248 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:7174 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:2671 JApplicationCms->execute() Copy JROOT/index.php:73
クエリ時間:9.09 ms 最後のクエリの後:0.13 ms クエリメモリ:0.005 MB クエリ前のメモリ:12.227 MB
UPDATE `joom_extensions `
SET `params` = '{\"mediaversion\":\"f823d419e77150989e92efbb55a77bdd\"}'
WHERE `type` = 'library' AND `element` = 'joomla'クエリではEXPLAINは使用できません:UPDATE `joom_extensions`
SET `params` = '{\"mediaversion\":\"f823d419e77150989e92efbb55a77bdd\"}'
WHERE `type` = 'library' AND `element` = 'joomla'
Status Duration starting 0.06 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.01 ms System lock 0.09 ms updating 0.15 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.10 ms closing tables 0.01 ms freeing items 0.01 ms async commit 7.74 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 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:8509 JFactory::createDocument() Copy JROOT/libraries/joomla/factory.php:2248 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:7174 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:2671 JApplicationCms->execute() Copy JROOT/index.php:73
クエリ時間:1.33 ms 最後のクエリの後:5.24 ms クエリメモリ:0.020 MB クエリ前のメモリ:12.897 MB 返された行:20
SELECT *
FROM joom_languages
WHERE published= 1
ORDER BY ordering ASC クエリではEXPLAINは使用できません:SELECT *
FROM joom_languages
WHERE published=1
ORDER BY ordering ASC
Status Duration starting 0.06 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.04 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.03 ms executing 0.18 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 10 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:16939 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:7174 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:2671 JApplicationCms->execute() Copy JROOT/index.php:73
クエリ時間:1.13 ms 最後のクエリの後:0.08 ms クエリメモリ:0.020 MB クエリ前のメモリ:12.922 MB 返された行:1
SELECT * FROM axs_domains WHERE domain = 'k8s.intg.tovuti.io'クエリではEXPLAINは使用できません:SELECT * FROM axs_domains WHERE domain = 'k8s.intg.tovuti.io'
Status Duration starting 0.04 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.02 ms executing 0.04 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms
# 発信者 ファイルと行番号 10 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:16549 JDatabaseDriver->loadObject() Copy JROOT/libraries/axslibs/language.php:1848 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:7174 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:2671 JApplicationCms->execute() Copy JROOT/index.php:73
クエリ時間:1.49 ms 最後のクエリの後:0.06 ms クエリメモリ:0.021 MB クエリ前のメモリ:12.929 MB 返された行:96
SELECT `element`,`name`,`client_id`,`extension_id`
FROM `joom_extensions `
WHERE `type` = 'language' AND `state` = 0 AND `enabled` = 1クエリではEXPLAINは使用できません:SELECT `element`,`name`,`client_id`,`extension_id`
FROM `joom_extensions`
WHERE `type` = 'language' AND `state` = 0 AND `enabled` = 1
Status Duration starting 0.05 ms Executing hook on transaction 0.01 ms starting 0.02 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.06 ms preparing 0.02 ms executing 0.32 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.07 ms cleaning up 0.02 ms
# 発信者 ファイルと行番号 10 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:16939 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:7174 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:2671 JApplicationCms->execute() Copy JROOT/index.php:73
クエリ時間:2.22 ms 最後のクエリの後:13.39 ms クエリメモリ:0.074 MB クエリ前のメモリ:14.516 MB 返された行:88
SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM joom_menu AS m
LEFT JOIN joom_extensions AS e ON m.component_id = e.extension_id
WHERE m.published = 1 AND m.parent_id > 0 AND m.client_id = 0
ORDER BY m.lftクエリではEXPLAINは使用できません:SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM joom_menu AS m
LEFT JOIN joom_extensions AS e ON m.component_id = e.extension_id
WHERE m.published = 1 AND m.parent_id > 0 AND m.client_id = 0
ORDER BY m.lft
Status Duration starting 0.08 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.05 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.07 ms preparing 0.07 ms executing 0.98 ms end 0.02 ms query end 0.01 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 24 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:169323 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/cms/menu/site.php:8822 JMenuSite->{closure}() Copy JROOT/libraries/joomla/cache/controller/callback.php:16921 JCacheControllerCallback->get() Copy JROOT/libraries/cms/menu/site.php:9620 JMenuSite->load() Copy JROOT/libraries/cms/menu/menu.php:7419 JMenu->__construct() Copy JROOT/libraries/cms/menu/site.php:5718 JMenuSite->__construct() Copy JROOT/libraries/cms/menu/menu.php:12917 JMenu::getInstance() Copy JROOT/libraries/cms/application/cms.php:49716 JApplicationCms->getMenu() Copy JROOT/libraries/cms/application/site.php:27715 JApplicationSite->getMenu() Copy JROOT/libraries/cms/router/site.php:5914 JRouterSite->__construct() Copy JROOT/libraries/cms/router/router.php:19813 JRouter::getInstance() Copy JROOT/libraries/cms/application/cms.php:59112 JApplicationCms::getRouter() Copy JROOT/libraries/cms/application/site.php:40711 JApplicationSite::getRouter() Copy JROOT/plugins/system/languagefilter/languagefilter.php:13410 PlgSystemLanguageFilter->onAfterInitialise() 以下の行の呼び出しと同じです。 9 ReflectionMethod->invokeArgs() Copy JROOT/libraries/tovuti/Helpers/MethodHelper.php:588 Tovuti\Helpers\MethodHelper::call() Copy JROOT/libraries/joomla/event/event.php:727 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:7184 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:2671 JApplicationCms->execute() Copy JROOT/index.php:73
クエリ時間:2.46 ms 最後のクエリの後:20.50 ms クエリメモリ:0.024 MB クエリ前のメモリ:17.349 MB 返された行:17
SHOW FULL COLUMNS FROM `joom_users `クエリではEXPLAINは使用できません:SHOW FULL COLUMNS FROM `joom_users`
Status Duration starting 0.06 ms Executing hook on transaction 0.01 ms starting 0.06 ms checking permissions 0.01 ms checking permissions 0.00 ms Opening tables 0.53 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.12 ms preparing 0.05 ms Creating tmp table 0.06 ms executing 0.09 ms checking permissions 0.06 ms checking permissions 0.03 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.07 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.02 ms closing tables 0.02 ms freeing items 0.06 ms cleaning up 0.03 ms
# 発信者 ファイルと行番号 20 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:169319 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/joomla/database/driver/mysqli.php:43518 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:59913 JUser::getTable() Copy JROOT/libraries/joomla/user/user.php:78312 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:11784 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:2671 JApplicationCms->execute() Copy JROOT/index.php:73
クエリ時間:1.06 ms 最後のクエリの後:0.37 ms クエリメモリ:0.022 MB クエリ前のメモリ:17.392 MB 返された行:1
SELECT `id`,`title`
FROM `joom_usergroups `
WHERE `id` = 1クエリではEXPLAINは使用できません:SELECT `id`,`title`
FROM `joom_usergroups`
WHERE `id` = 1
Status Duration starting 0.04 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.03 ms executing 0.01 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms
# 発信者 ファイルと行番号 15 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:149814 JDatabaseDriver->loadAssocList() Copy JROOT/libraries/joomla/table/user.php:16313 JTableUser->bind() Copy JROOT/libraries/joomla/user/user.php:78512 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:11784 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:2671 JApplicationCms->execute() Copy JROOT/index.php:73
クエリ時間:1.15 ms 最後のクエリの後:14.27 ms クエリメモリ:0.020 MB クエリ前のメモリ:17.970 MB 返された行:0
SELECT params
FROM axs_user_settings
WHERE id = 1クエリではEXPLAINは使用できません:SELECT params
FROM axs_user_settings
WHERE id = 1
Status Duration starting 0.05 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.04 ms executing 0.01 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms
# 発信者 ファイルと行番号 9 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:16548 JDatabaseDriver->loadObject() Copy JROOT/libraries/axslibs/user.php:8027 AxsUser::{closure}() Copy JROOT/libraries/tovuti/Traits/Memoization.php:256 AxsUser::memoizeStatic() Copy JROOT/libraries/axslibs/user.php:7925 AxsUser::getGlobalUserSettings() Copy JROOT/libraries/axslibs/security.php:354 AxsSecurity::getSettings() Copy JROOT/libraries/cms/application/cms.php:3683 JApplicationCms->checkUserRequireTwoFactor() Copy JROOT/libraries/cms/application/site.php:2312 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2671 JApplicationCms->execute() Copy JROOT/index.php:73
クエリ時間:1.17 ms 最後のクエリの後:3.50 ms クエリメモリ:0.018 MB クエリ前のメモリ:18.402 MB 返された行:0
SELECT *
FROM `joom_users `
WHERE `id` = 0クエリではEXPLAINは使用できません:SELECT *
FROM `joom_users`
WHERE `id` = 0
Status Duration starting 0.05 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.04 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.05 ms executing 0.02 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms
# 発信者 ファイルと行番号 6 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:16545 JDatabaseDriver->loadObject() Copy JROOT/administrator/components/com_users/models/user.php:9924 UsersModelUser->getOtpConfig() Copy JROOT/libraries/cms/application/cms.php:3723 JApplicationCms->checkUserRequireTwoFactor() Copy JROOT/libraries/cms/application/site.php:2312 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2671 JApplicationCms->execute() Copy JROOT/index.php:73
クエリ時間:5.61 ms 最後のクエリの後:0.16 ms クエリメモリ:0.019 MB クエリ前のメモリ:18.409 MB 返された行:6
SELECT id, home, template, s.params
FROM joom_template_styles as s
LEFT JOIN joom_extensions as e ON e.element= s.template AND e.type= 'template' AND e.client_id= s.client_id
WHERE s.client_id = 0 AND e.enabled = 1クエリではEXPLAINは使用できません:SELECT id, home, template, s.params
FROM joom_template_styles as s
LEFT JOIN joom_extensions as e ON e.element=s.template AND e.type='template' AND e.client_id=s.client_id
WHERE s.client_id = 0 AND e.enabled = 1
Status Duration starting 0.10 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms checking permissions 0.00 ms Opening tables 0.05 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.08 ms preparing 0.03 ms executing 0.12 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.05 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 6 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:16935 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:2671 JApplicationCms->execute() Copy JROOT/index.php:73
クエリ時間:1.20 ms 最後のクエリの後:3.99 ms クエリメモリ:0.020 MB クエリ前のメモリ:18.596 MB 返された行:1
SELECT * FROM joom_kunena_configuration WHERE id= 1クエリではEXPLAINは使用できません:SELECT * FROM joom_kunena_configuration WHERE id=1
Status Duration starting 0.05 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.02 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.07 ms preparing 0.01 ms executing 0.02 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 10 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:14579 JDatabaseDriver->loadAssoc() Copy JROOT/libraries/kunena/config.php:13068 KunenaConfig->load() Copy JROOT/libraries/kunena/config.php:12397 KunenaConfig::getInstance() Copy JROOT/components/com_kunena/kunena.php:336 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:2671 JApplicationCms->execute() Copy JROOT/index.php:73
クエリ時間:2.20 ms 最後のクエリの後:4.77 ms クエリメモリ:0.023 MB クエリ前のメモリ:18.887 MB 返された行:5
SHOW FULL COLUMNS FROM `joom_kunena_sessions `クエリではEXPLAINは使用できません:SHOW FULL COLUMNS FROM `joom_kunena_sessions`
Status Duration starting 0.05 ms Executing hook on transaction 0.00 ms starting 0.07 ms checking permissions 0.01 ms checking permissions 0.00 ms Opening tables 0.45 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.11 ms preparing 0.03 ms Creating tmp table 0.05 ms executing 0.08 ms checking permissions 0.06 ms checking permissions 0.03 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.05 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.02 ms closing tables 0.02 ms freeing items 0.06 ms cleaning up 0.02 ms
# 発信者 ファイルと行番号 18 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:169317 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/joomla/database/driver/mysqli.php:43516 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:2671 JApplicationCms->execute() Copy JROOT/index.php:73
クエリ時間:7.96 ms 最後のクエリの後:8.96 ms クエリメモリ:0.026 MB クエリ前のメモリ:19.829 MB 返された行:51
SHOW FULL COLUMNS FROM `joom_kunena_users `クエリではEXPLAINは使用できません:SHOW FULL COLUMNS FROM `joom_kunena_users`
Status Duration starting 0.06 ms Executing hook on transaction 0.01 ms starting 0.05 ms checking permissions 0.01 ms checking permissions 0.00 ms Opening tables 0.48 ms init 0.01 ms System lock 0.01 ms optimizing 0.05 ms statistics 0.13 ms preparing 0.04 ms Creating tmp table 0.05 ms executing 0.12 ms checking permissions 0.07 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.03 ms checking permissions 0.03 ms checking permissions 1.73 ms checking permissions 0.03 ms checking permissions 0.03 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.04 ms checking permissions 0.02 ms checking permissions 0.03 ms checking permissions 0.02 ms checking permissions 0.03 ms checking permissions 0.02 ms checking permissions 0.04 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.03 ms checking permissions 0.03 ms checking permissions 0.03 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.05 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.20 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.03 ms checking permissions 0.04 ms checking permissions 0.03 ms checking permissions 0.03 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 2.76 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.03 ms closing tables 0.02 ms freeing items 0.07 ms cleaning up 0.02 ms
# 発信者 ファイルと行番号 22 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:169321 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/joomla/database/driver/mysqli.php:43520 JDatabaseDriverMysqli->getTableColumns() Copy JROOT/libraries/joomla/table/table.php:24419 JTable->getFields() Copy JROOT/libraries/joomla/table/table.php:16318 JTable->__construct() Copy JROOT/libraries/kunena/tables/kunenausers.php:32917 TableKunenaUsers->__construct() Copy JROOT/libraries/joomla/table/table.php:31116 JTable::getInstance() Copy JROOT/libraries/kunena/user/user.php:25215 KunenaUser->getTable() Copy JROOT/libraries/kunena/user/user.php:27514 KunenaUser->load() Copy JROOT/libraries/kunena/user/user.php:10013 KunenaUser->__construct() Copy JROOT/libraries/kunena/user/helper.php:5912 KunenaUserHelper::initialize() Copy JROOT/libraries/kunena/user/helper.php:1311 include Copy JROOT/libraries/kunena/user/helper.php Copy JROOT/libraries/loader.php:70210 JLoader::_load() Copy JROOT/libraries/loader.php:6719 JLoader::_autoload() 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:1126 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:2671 JApplicationCms->execute() Copy JROOT/index.php:73
クエリ時間:1.34 ms 最後のクエリの後:0.46 ms クエリメモリ:0.023 MB クエリ前のメモリ:19.924 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)クエリではEXPLAINは使用できません: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)
Status Duration starting 0.10 ms Executing hook on transaction 0.01 ms starting 0.03 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.06 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.07 ms executing 0.02 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 16 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:169315 JDatabaseDriver->loadObjectList() Copy JROOT/components/com_community/libraries/core.php:12414 CFactory::loadUsers() Copy JROOT/plugins/kunena/community/avatar.php:3713 KunenaAvatarCommunity->load() Copy JROOT/libraries/kunena/user/helper.php:6312 KunenaUserHelper::initialize() Copy JROOT/libraries/kunena/user/helper.php:1311 include Copy JROOT/libraries/kunena/user/helper.php Copy JROOT/libraries/loader.php:70210 JLoader::_load() Copy JROOT/libraries/loader.php:6719 JLoader::_autoload() 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:1126 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:2671 JApplicationCms->execute() Copy JROOT/index.php:73
クエリ時間:1.34 ms 最後のクエリの後:10.05 ms クエリメモリ:0.022 MB クエリ前のメモリ:20.877 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'クエリではEXPLAINは使用できません: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'
Status Duration starting 0.08 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.05 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.10 ms preparing 0.04 ms executing 0.03 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 15 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:169314 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:1126 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:2671 JApplicationCms->execute() Copy JROOT/index.php:73
クエリ時間:3.79 ms 最後のクエリの後:0.15 ms クエリメモリ:0.025 MB クエリ前のメモリ:20.890 MB 返された行:63
SELECT `id`,`name`,`rules`,`parent_id`
FROM `joom_assets `
WHERE `name` IN ('com_accessibility','com_admin','com_advpoll','com_affiliate','com_ajax','com_associations','com_award','com_axs','com_banners','com_bigbluebutton','com_board','com_cache','com_categories','com_checkin','com_community','com_config','com_contact','com_contactpage','com_content','com_contenthistory','com_contracts','com_converge','com_cpanel','com_dashboard','com_dbmanager','com_demo','com_domains','com_dump','com_easyblog','com_eshop','com_eventbooking','com_fields','com_finder','com_improved_ajax_login','com_installer','com_interactivecontent','com_invitex','com_jbusinessdirectory','com_jce','com_joomlaupdate','com_jumi','com_kunena','com_languages','com_lifeboard','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_notifications','com_offlajn_installer','com_osmembership','com_permissioning','com_plugins','com_postinstall','com_redirect','com_reports','com_rsticketspro','com_saas','com_scheduler','com_search','com_splms','com_tags','com_templates','com_uniterevolution','com_uniterevolution2','com_uniteshowbiz','com_user_view','com_users','com_weblinks','com_wrapper') OR `parent_id` = 0クエリではEXPLAINは使用できません:SELECT `id`,`name`,`rules`,`parent_id`
FROM `joom_assets`
WHERE `name` IN ('com_accessibility','com_admin','com_advpoll','com_affiliate','com_ajax','com_associations','com_award','com_axs','com_banners','com_bigbluebutton','com_board','com_cache','com_categories','com_checkin','com_community','com_config','com_contact','com_contactpage','com_content','com_contenthistory','com_contracts','com_converge','com_cpanel','com_dashboard','com_dbmanager','com_demo','com_domains','com_dump','com_easyblog','com_eshop','com_eventbooking','com_fields','com_finder','com_improved_ajax_login','com_installer','com_interactivecontent','com_invitex','com_jbusinessdirectory','com_jce','com_joomlaupdate','com_jumi','com_kunena','com_languages','com_lifeboard','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_notifications','com_offlajn_installer','com_osmembership','com_permissioning','com_plugins','com_postinstall','com_redirect','com_reports','com_rsticketspro','com_saas','com_scheduler','com_search','com_splms','com_tags','com_templates','com_uniterevolution','com_uniterevolution2','com_uniteshowbiz','com_user_view','com_users','com_weblinks','com_wrapper') OR `parent_id` = 0
Status Duration starting 0.09 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.07 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.22 ms preparing 0.02 ms executing 0.59 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 19 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:169318 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/joomla/access/access.php:43017 JAccess::preloadComponents() Copy JROOT/libraries/joomla/access/access.php:21116 JAccess::preload() Copy JROOT/libraries/joomla/access/access.php:53315 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:1126 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:2671 JApplicationCms->execute() Copy JROOT/index.php:73
クエリ時間:1.52 ms 最後のクエリの後:0.39 ms クエリメモリ:0.023 MB クエリ前のメモリ:20.999 MB 返された行:7
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)クエリではEXPLAINは使用できません: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)
Status Duration starting 0.06 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.08 ms preparing 0.02 ms Creating tmp table 0.03 ms executing 0.07 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 17 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:154216 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:1126 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:2671 JApplicationCms->execute() Copy JROOT/index.php:73
クエリ時間:1.34 ms 最後のクエリの後:0.04 ms クエリメモリ:0.023 MB クエリ前のメモリ:21.007 MB 返された行:25
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)クエリではEXPLAINは使用できません: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)
Status Duration starting 0.07 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.06 ms preparing 0.02 ms Creating tmp table 0.03 ms executing 0.17 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.05 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 17 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:154216 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:1126 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:2671 JApplicationCms->execute() Copy JROOT/index.php:73
クエリ時間:1.09 ms 最後のクエリの後:0.04 ms クエリメモリ:0.022 MB クエリ前のメモリ:21.021 MB 返された行:0
SELECT user_id, category_id, role FROM joom_kunena_user_categories WHERE role IN (1,2)クエリではEXPLAINは使用できません:SELECT user_id, category_id, role FROM joom_kunena_user_categories WHERE role IN (1,2)
Status Duration starting 0.04 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.01 ms executing 0.02 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.00 ms
# 発信者 ファイルと行番号 14 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:169313 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:1126 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:2671 JApplicationCms->execute() Copy JROOT/index.php:73
クエリ時間:1.24 ms 最後のクエリの後:2.30 ms クエリメモリ:0.025 MB クエリ前のメモリ:21.232 MB 返された行:3
SELECT * FROM joom_kunena_categories ORDER BY ordering, nameクエリではEXPLAINは使用できません:SELECT * FROM joom_kunena_categories ORDER BY ordering, name
Status Duration starting 0.04 ms Executing hook on transaction 0.00 ms starting 0.02 ms checking permissions 0.00 ms Opening tables 0.04 ms init 0.02 ms System lock 0.01 ms optimizing 0.00 ms statistics 0.01 ms preparing 0.02 ms executing 0.13 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms
# 発信者 ファイルと行番号 21 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:169320 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/kunena/forum/category/helper.php:86519 KunenaForumCategoryHelper::loadCategories() Copy JROOT/libraries/kunena/forum/category/helper.php:4318 KunenaForumCategoryHelper::initialize() Copy JROOT/libraries/kunena/forum/category/helper.php:105217 include Copy JROOT/libraries/kunena/forum/category/helper.php Copy JROOT/libraries/loader.php:70216 JLoader::_load() Copy JROOT/libraries/loader.php:67115 JLoader::_autoload() Copy JROOT/libraries/kunena/access.php:55914 KunenaAccess->getAllowedCategories() Copy JROOT/components/com_kunena/controller/category/index/display.php:5013 ComponentKunenaControllerCategoryIndexDisplay->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/category/list/default.php:1310 include Copy JROOT/components/com_kunena/template/nts_kbento/pages/category/list/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:1126 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:2671 JApplicationCms->execute() Copy JROOT/index.php:73
クエリ時間:1.09 ms 最後のクエリの後:1.81 ms クエリメモリ:0.025 MB クエリ前のメモリ:21.433 MB 返された行:0
SELECT groupid
FROM joom_community_groups_members
WHERE approved = 1 AND memberid = 0クエリではEXPLAINは使用できません:SELECT groupid
FROM joom_community_groups_members
WHERE approved = 1 AND memberid = 0
Status Duration starting 0.05 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.02 ms executing 0.02 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.02 ms
# 発信者 ファイルと行番号 21 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:169320 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/kunena/forum/category/helper.php:88119 KunenaForumCategoryHelper::loadCategories() Copy JROOT/libraries/kunena/forum/category/helper.php:4318 KunenaForumCategoryHelper::initialize() Copy JROOT/libraries/kunena/forum/category/helper.php:105217 include Copy JROOT/libraries/kunena/forum/category/helper.php Copy JROOT/libraries/loader.php:70216 JLoader::_load() Copy JROOT/libraries/loader.php:67115 JLoader::_autoload() Copy JROOT/libraries/kunena/access.php:55914 KunenaAccess->getAllowedCategories() Copy JROOT/components/com_kunena/controller/category/index/display.php:5013 ComponentKunenaControllerCategoryIndexDisplay->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/category/list/default.php:1310 include Copy JROOT/components/com_kunena/template/nts_kbento/pages/category/list/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:1126 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:2671 JApplicationCms->execute() Copy JROOT/index.php:73
クエリ時間:2.87 ms 最後のクエリの後:1.68 ms クエリメモリ:0.027 MB クエリ前のメモリ:21.670 MB 返された行:39
SHOW FULL COLUMNS FROM `joom_kunena_categories `クエリではEXPLAINは使用できません:SHOW FULL COLUMNS FROM `joom_kunena_categories`
Status Duration starting 0.06 ms Executing hook on transaction 0.00 ms starting 0.05 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.44 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.14 ms preparing 0.05 ms Creating tmp table 0.05 ms executing 0.09 ms checking permissions 0.06 ms checking permissions 0.03 ms checking permissions 0.03 ms checking permissions 0.02 ms checking permissions 0.03 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.03 ms checking permissions 0.02 ms checking permissions 0.04 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.03 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.09 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.02 ms closing tables 0.02 ms freeing items 0.06 ms cleaning up 0.02 ms
# 発信者 ファイルと行番号 27 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:169326 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/joomla/database/driver/mysqli.php:43525 JDatabaseDriverMysqli->getTableColumns() Copy JROOT/libraries/joomla/table/table.php:24424 JTable->getFields() Copy JROOT/libraries/joomla/table/table.php:16323 JTable->__construct() Copy JROOT/libraries/kunena/tables/kunenacategories.php:6122 TableKunenaCategories->__construct() Copy JROOT/libraries/joomla/table/table.php:31121 JTable::getInstance() Copy JROOT/libraries/kunena/database/object.php:28220 KunenaDatabaseObject->getTable() Copy JROOT/libraries/kunena/database/object.php:10019 KunenaDatabaseObject->load() Copy JROOT/libraries/kunena/forum/category/category.php:103118 KunenaForumCategory->load() Copy JROOT/libraries/kunena/forum/category/helper.php:8817 KunenaForumCategoryHelper::get() Copy JROOT/libraries/kunena/html/html/kunenaforum.php:7716 JHtmlKunenaForum::categorylist() Copy JROOT/libraries/cms/html/html.php:23315 JHtml::call() Copy JROOT/libraries/cms/html/html.php:14014 JHtml::_() Copy JROOT/components/com_kunena/controller/category/index/display.php:6113 ComponentKunenaControllerCategoryIndexDisplay->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/category/list/default.php:1310 include Copy JROOT/components/com_kunena/template/nts_kbento/pages/category/list/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:1126 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:2671 JApplicationCms->execute() Copy JROOT/index.php:73
クエリ時間:1.29 ms 最後のクエリの後:0.47 ms クエリメモリ:0.024 MB クエリ前のメモリ:21.725 MB 返された行:0
SELECT *
FROM `joom_kunena_topics `
WHERE `category_id`= '2'クエリではEXPLAINは使用できません:SELECT *
FROM `joom_kunena_topics`
WHERE `category_id`='2'
Status Duration starting 0.04 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.07 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.05 ms preparing 0.01 ms executing 0.03 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms
# 発信者 ファイルと行番号 18 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:169317 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/axslibs/forum.php:3816 AxsForum::getCategoryCounts() Copy JROOT/libraries/kunena/forum/category/category.php:148815 KunenaForumCategory->buildInfo() Copy JROOT/libraries/kunena/forum/category/category.php:53614 KunenaForumCategory->getLastCategory() Copy JROOT/components/com_kunena/controller/category/index/display.php:14613 ComponentKunenaControllerCategoryIndexDisplay->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/category/list/default.php:1310 include Copy JROOT/components/com_kunena/template/nts_kbento/pages/category/list/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:1126 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:2671 JApplicationCms->execute() Copy JROOT/index.php:73
クエリ時間:1.10 ms 最後のクエリの後:0.06 ms クエリメモリ:0.024 MB クエリ前のメモリ:21.734 MB 返された行:0
SELECT *
FROM `joom_kunena_topics `
WHERE `category_id`= '3'クエリではEXPLAINは使用できません:SELECT *
FROM `joom_kunena_topics`
WHERE `category_id`='3'
Status Duration starting 0.03 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.01 ms executing 0.03 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 18 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:169317 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/axslibs/forum.php:3816 AxsForum::getCategoryCounts() Copy JROOT/libraries/kunena/forum/category/category.php:148815 KunenaForumCategory->buildInfo() Copy JROOT/libraries/kunena/forum/category/category.php:53614 KunenaForumCategory->getLastCategory() Copy JROOT/components/com_kunena/controller/category/index/display.php:14613 ComponentKunenaControllerCategoryIndexDisplay->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/category/list/default.php:1310 include Copy JROOT/components/com_kunena/template/nts_kbento/pages/category/list/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:1126 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:2671 JApplicationCms->execute() Copy JROOT/index.php:73
クエリ時間:1.15 ms 最後のクエリの後:0.80 ms クエリメモリ:0.023 MB クエリ前のメモリ:21.796 MB 返された行:0
SELECT * FROM joom_kunena_topics WHERE id IN (3,2)クエリではEXPLAINは使用できません:SELECT * FROM joom_kunena_topics WHERE id IN (3,2)
Status Duration starting 0.05 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.01 ms executing 0.03 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms
# 発信者 ファイルと行番号 17 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:149816 JDatabaseDriver->loadAssocList() Copy JROOT/libraries/kunena/forum/topic/helper.php:68915 KunenaForumTopicHelper::loadTopics() Copy JROOT/libraries/kunena/forum/topic/helper.php:14114 KunenaForumTopicHelper::getTopics() Copy JROOT/components/com_kunena/controller/category/index/display.php:17313 ComponentKunenaControllerCategoryIndexDisplay->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/category/list/default.php:1310 include Copy JROOT/components/com_kunena/template/nts_kbento/pages/category/list/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:1126 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:2671 JApplicationCms->execute() Copy JROOT/index.php:73
クエリ時間:2.55 ms 最後のクエリの後:2.98 ms クエリメモリ:0.027 MB クエリ前のメモリ:22.038 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 <= '2026-06-24 15:57:37') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-06-24 15:57:37') AND m.access IN (1,1) AND m.client_id = 0 AND (mm.menuid = 839 OR mm.menuid <= 0) AND m.language IN ('ja-JA ','* ')
ORDER BY m.position, m.orderingクエリではEXPLAINは使用できません: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 <= '2026-06-24 15:57:37') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-06-24 15:57:37') AND m.access IN (1,1) AND m.client_id = 0 AND (mm.menuid = 839 OR mm.menuid <= 0) AND m.language IN ('ja-JA','*')
ORDER BY m.position, m.ordering
Status Duration starting 0.10 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.07 ms init 0.01 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.11 ms preparing 0.05 ms executing 1.04 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 26 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:169325 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/joomla/cache/controller/callback.php:16924 JCacheControllerCallback->get() Copy JROOT/libraries/cms/module/helper.php:42423 JModuleHelper::getModuleList() Copy JROOT/libraries/cms/module/helper.php:36022 JModuleHelper::load() Copy JROOT/libraries/cms/module/helper.php:8421 JModuleHelper::getModules() Copy JROOT/libraries/joomla/document/html.php:57620 JDocumentHtml->countModules() Copy JROOT/components/com_kunena/layout/widget/module.php:3319 KunenaLayoutWidgetModule->renderPosition() Copy JROOT/components/com_kunena/template/nts_kbento/layouts/widget/module/default.php:1318 include Copy JROOT/components/com_kunena/template/nts_kbento/layouts/widget/module/default.php Copy JROOT/libraries/kunena/layout/base.php:18317 KunenaLayoutBase->render() Copy JROOT/libraries/kunena/layout/layout.php:6816 KunenaLayout->render() Copy JROOT/libraries/kunena/layout/base.php:9115 KunenaLayoutBase->__toString() Copy JROOT/components/com_kunena/template/nts_kbento/layouts/category/index/default.php:2914 include Copy JROOT/components/com_kunena/template/nts_kbento/layouts/category/index/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/pages/category/list/default.php:2010 include Copy JROOT/components/com_kunena/template/nts_kbento/pages/category/list/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:1126 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:2671 JApplicationCms->execute() Copy JROOT/index.php:73
クエリ時間:1.50 ms 最後のクエリの後:6.31 ms クエリメモリ:0.026 MB クエリ前のメモリ:22.747 MB 返された行:66
SELECT code, location FROM joom_kunena_smileys クエリではEXPLAINは使用できません:SELECT code, location FROM joom_kunena_smileys
Status Duration starting 0.04 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.00 ms System lock 0.01 ms optimizing 0.00 ms statistics 0.01 ms preparing 0.01 ms executing 0.06 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 21 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:169320 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/kunena/bbcode/bbcode.php:103019 KunenaBbcodeLibrary->__construct() Copy JROOT/libraries/kunena/bbcode/bbcode.php:4418 KunenaBbcode->__construct() Copy JROOT/libraries/kunena/bbcode/bbcode.php:7717 KunenaBbcode::getInstance() Copy JROOT/libraries/kunena/html/parser.php:11216 KunenaHtmlParser::parseBBCode() Copy JROOT/libraries/kunena/forum/category/category.php:33415 KunenaForumCategory->displayField() Copy JROOT/components/com_kunena/template/nts_kbento/layouts/category/index/default.php:4714 include Copy JROOT/components/com_kunena/template/nts_kbento/layouts/category/index/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/pages/category/list/default.php:2010 include Copy JROOT/components/com_kunena/template/nts_kbento/pages/category/list/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:1126 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:2671 JApplicationCms->execute() Copy JROOT/index.php:73
クエリ時間:1.17 ms 最後のクエリの後:1.12 ms クエリメモリ:0.024 MB クエリ前のメモリ:22.779 MB 返された行:0
SELECT *
FROM `joom_kunena_topics `
WHERE `category_id`= '1'クエリではEXPLAINは使用できません:SELECT *
FROM `joom_kunena_topics`
WHERE `category_id`='1'
Status Duration starting 0.04 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.05 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.06 ms preparing 0.02 ms executing 0.03 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms
# 発信者 ファイルと行番号 19 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:169318 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/axslibs/forum.php:3817 AxsForum::getCategoryCounts() Copy JROOT/libraries/kunena/forum/category/category.php:148816 KunenaForumCategory->buildInfo() Copy JROOT/libraries/kunena/forum/category/category.php:22315 KunenaForumCategory->isSection() Copy JROOT/components/com_kunena/template/nts_kbento/layouts/category/index/default.php:5414 include Copy JROOT/components/com_kunena/template/nts_kbento/layouts/category/index/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/pages/category/list/default.php:2010 include Copy JROOT/components/com_kunena/template/nts_kbento/pages/category/list/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:1126 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:2671 JApplicationCms->execute() Copy JROOT/index.php:73
クエリ時間:1.13 ms 最後のクエリの後:0.05 ms クエリメモリ:0.024 MB クエリ前のメモリ:22.788 MB 返された行:0
SELECT *
FROM `joom_kunena_topics `
WHERE `category_id`= '2'クエリではEXPLAINは使用できません:SELECT *
FROM `joom_kunena_topics`
WHERE `category_id`='2'
Status Duration starting 0.04 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.07 ms preparing 0.02 ms executing 0.03 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 19 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:169318 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/axslibs/forum.php:3817 AxsForum::getCategoryCounts() Copy JROOT/libraries/kunena/forum/category/category.php:148816 KunenaForumCategory->buildInfo() Copy JROOT/libraries/kunena/forum/category/category.php:22315 KunenaForumCategory->isSection() Copy JROOT/components/com_kunena/template/nts_kbento/layouts/category/index/default.php:5414 include Copy JROOT/components/com_kunena/template/nts_kbento/layouts/category/index/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/pages/category/list/default.php:2010 include Copy JROOT/components/com_kunena/template/nts_kbento/pages/category/list/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:1126 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:2671 JApplicationCms->execute() Copy JROOT/index.php:73
クエリ時間:1.13 ms 最後のクエリの後:0.04 ms クエリメモリ:0.024 MB クエリ前のメモリ:22.796 MB 返された行:0
SELECT *
FROM `joom_kunena_topics `
WHERE `category_id`= '3'クエリではEXPLAINは使用できません:SELECT *
FROM `joom_kunena_topics`
WHERE `category_id`='3'
Status Duration starting 0.03 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.01 ms executing 0.04 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 19 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:169318 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/axslibs/forum.php:3817 AxsForum::getCategoryCounts() Copy JROOT/libraries/kunena/forum/category/category.php:148816 KunenaForumCategory->buildInfo() Copy JROOT/libraries/kunena/forum/category/category.php:22315 KunenaForumCategory->isSection() Copy JROOT/components/com_kunena/template/nts_kbento/layouts/category/index/default.php:5414 include Copy JROOT/components/com_kunena/template/nts_kbento/layouts/category/index/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/pages/category/list/default.php:2010 include Copy JROOT/components/com_kunena/template/nts_kbento/pages/category/list/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:1126 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:2671 JApplicationCms->execute() Copy JROOT/index.php:73
クエリ時間:3.06 ms 最後のクエリの後:3.18 ms クエリメモリ:0.028 MB クエリ前のメモリ:23.179 MB 返された行:25
SHOW FULL COLUMNS FROM `joom_kunena_topics `クエリではEXPLAINは使用できません:SHOW FULL COLUMNS FROM `joom_kunena_topics`
Status Duration starting 0.07 ms Executing hook on transaction 0.01 ms starting 0.06 ms checking permissions 0.02 ms checking permissions 0.00 ms Opening tables 0.54 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.12 ms preparing 0.29 ms Creating tmp table 0.06 ms executing 0.09 ms checking permissions 0.07 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.03 ms checking permissions 0.02 ms checking permissions 0.03 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.06 ms checking permissions 0.03 ms checking permissions 0.03 ms checking permissions 0.04 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.03 ms checking permissions 0.04 ms checking permissions 0.03 ms checking permissions 0.09 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.03 ms closing tables 0.02 ms freeing items 0.06 ms cleaning up 0.02 ms
# 発信者 ファイルと行番号 28 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:169327 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/joomla/database/driver/mysqli.php:43526 JDatabaseDriverMysqli->getTableColumns() Copy JROOT/libraries/joomla/table/table.php:24425 JTable->getFields() Copy JROOT/libraries/joomla/table/table.php:16324 JTable->__construct() Copy JROOT/libraries/kunena/tables/kunenatopics.php:5023 TableKunenaTopics->__construct() Copy JROOT/libraries/joomla/table/table.php:31122 JTable::getInstance() Copy JROOT/libraries/kunena/database/object.php:28221 KunenaDatabaseObject->getTable() Copy JROOT/libraries/kunena/database/object.php:10020 KunenaDatabaseObject->load() Copy JROOT/libraries/kunena/forum/topic/topic.php:96419 KunenaForumTopic->load() Copy JROOT/libraries/kunena/database/object.php:27118 KunenaDatabaseObject->__construct() Copy JROOT/libraries/kunena/forum/topic/topic.php:11917 KunenaForumTopic->__construct() Copy JROOT/libraries/kunena/forum/topic/helper.php:4716 KunenaForumTopicHelper::get() Copy JROOT/libraries/kunena/forum/category/category.php:54615 KunenaForumCategory->getLastTopic() Copy JROOT/components/com_kunena/template/nts_kbento/layouts/category/index/default.php:11014 include Copy JROOT/components/com_kunena/template/nts_kbento/layouts/category/index/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/pages/category/list/default.php:2010 include Copy JROOT/components/com_kunena/template/nts_kbento/pages/category/list/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:1126 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:2671 JApplicationCms->execute() Copy JROOT/index.php:73
クエリ時間:1.47 ms 最後のクエリの後:1.19 ms クエリメモリ:0.023 MB クエリ前のメモリ:23.189 MB 返された行:0
SELECT userid, MAX (time) AS time
FROM joom_session
WHERE client_id= 0 AND userid>0 AND time > 1782314857
GROUP BY userid
ORDER BY time DESC クエリではEXPLAINは使用できません:SELECT userid, MAX(time) AS time
FROM joom_session
WHERE client_id=0 AND userid>0 AND time > 1782314857
GROUP BY userid
ORDER BY time DESC
Status Duration starting 0.08 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.04 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.06 ms preparing 0.02 ms Creating tmp table 0.04 ms executing 0.22 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 16 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:169315 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/kunena/user/helper.php:36514 KunenaUserHelper::getOnlineUsers() Copy JROOT/components/com_kunena/controller/widget/whoisonline/display.php:4513 ComponentKunenaControllerWidgetWhoisonlineDisplay->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/pages/category/list/default.php:2110 include Copy JROOT/components/com_kunena/template/nts_kbento/pages/category/list/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:1126 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:2671 JApplicationCms->execute() Copy JROOT/index.php:73
クエリ時間:2246.03 ms 最後のクエリの後:0.05 ms クエリメモリ:0.023 MB クエリ前のメモリ:23.196 MB 返された行:1
SELECT COUNT (* )
FROM joom_session
WHERE client_id= 0 AND userid= 0 AND time > 1782314857クエリではEXPLAINは使用できません:SELECT COUNT(*)
FROM joom_session
WHERE client_id=0 AND userid=0 AND time > 1782314857
Status Duration starting 0.04 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.07 ms preparing 0.05 ms executing 2244.88 ms end 0.02 ms query end 0.01 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 16 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:173215 JDatabaseDriver->loadResult() Copy JROOT/libraries/kunena/user/helper.php:48414 KunenaUserHelper::getOnlineCount() Copy JROOT/components/com_kunena/controller/widget/whoisonline/display.php:4713 ComponentKunenaControllerWidgetWhoisonlineDisplay->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/pages/category/list/default.php:2110 include Copy JROOT/components/com_kunena/template/nts_kbento/pages/category/list/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:1126 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:2671 JApplicationCms->execute() Copy JROOT/index.php:73
クエリ時間:2.17 ms 最後のクエリの後:1.64 ms クエリメモリ:0.026 MB クエリ前のメモリ:23.333 MB 返された行:2
SHOW FULL COLUMNS FROM `joom_community_config `クエリではEXPLAINは使用できません:SHOW FULL COLUMNS FROM `joom_community_config`
Status Duration starting 0.06 ms Executing hook on transaction 0.01 ms starting 0.06 ms checking permissions 0.01 ms checking permissions 0.00 ms Opening tables 0.49 ms init 0.02 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.12 ms preparing 0.03 ms Creating tmp table 0.05 ms executing 0.15 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.07 ms checking permissions 0.05 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.02 ms closing tables 0.02 ms freeing items 0.06 ms cleaning up 0.02 ms
# 発信者 ファイルと行番号 24 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:169323 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/joomla/database/driver/mysqli.php:43522 JDatabaseDriverMysqli->getTableColumns() Copy JROOT/libraries/joomla/table/table.php:24421 JTable->getFields() Copy JROOT/libraries/joomla/table/table.php:16320 JTable->__construct() Copy JROOT/administrator/components/com_community/tables/configuration.php:2219 CommunityTableConfiguration->__construct() Copy JROOT/libraries/joomla/table/table.php:31118 JTable::getInstance() Copy JROOT/components/com_community/libraries/core.php:105617 CConfig::getInstance() Copy JROOT/components/com_community/libraries/core.php:23716 CFactory::getConfig() Copy JROOT/components/com_community/libraries/core.php:125615 CRoute::_() Copy JROOT/plugins/kunena/community/profile.php:4514 KunenaProfileCommunity->getUserListURL() Copy JROOT/components/com_kunena/controller/widget/whoisonline/display.php:9913 ComponentKunenaControllerWidgetWhoisonlineDisplay->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/pages/category/list/default.php:2110 include Copy JROOT/components/com_kunena/template/nts_kbento/pages/category/list/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:1126 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:2671 JApplicationCms->execute() Copy JROOT/index.php:73
クエリ時間:1.09 ms 最後のクエリの後:0.07 ms クエリメモリ:0.024 MB クエリ前のメモリ:23.348 MB 返された行:1
SELECT *
FROM joom_community_config
WHERE `name` = 'config'クエリではEXPLAINは使用できません:SELECT *
FROM joom_community_config
WHERE `name` = 'config'
Status Duration starting 0.05 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.01 ms executing 0.01 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.04 ms freeing items 0.03 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 20 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:145719 JDatabaseDriver->loadAssoc() Copy JROOT/libraries/joomla/table/table.php:72918 JTable->load() Copy JROOT/components/com_community/libraries/core.php:105717 CConfig::getInstance() Copy JROOT/components/com_community/libraries/core.php:23716 CFactory::getConfig() Copy JROOT/components/com_community/libraries/core.php:125615 CRoute::_() Copy JROOT/plugins/kunena/community/profile.php:4514 KunenaProfileCommunity->getUserListURL() Copy JROOT/components/com_kunena/controller/widget/whoisonline/display.php:9913 ComponentKunenaControllerWidgetWhoisonlineDisplay->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/pages/category/list/default.php:2110 include Copy JROOT/components/com_kunena/template/nts_kbento/pages/category/list/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:1126 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:2671 JApplicationCms->execute() Copy JROOT/index.php:73
クエリ時間:1.54 ms 最後のクエリの後:2.08 ms クエリメモリ:0.024 MB クエリ前のメモリ:23.561 MB 返された行:0
SELECT `id` FROM `joom_menu ` WHERE `link` LIKE '%option= com_community&view= search%' AND `published`= '1' AND `menutype`!= 'jomsocial' AND `type`= 'component'クエリではEXPLAINは使用できません:SELECT `id` FROM `joom_menu` WHERE `link` LIKE '%option=com_community&view=search%' AND `published`='1' AND `menutype`!='jomsocial' AND `type`='component'
Status Duration starting 0.06 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.07 ms preparing 0.02 ms executing 0.36 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 18 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:173217 JDatabaseDriver->loadResult() Copy JROOT/components/com_community/libraries/core.php:139016 CRoute::_getViewItemid() Copy JROOT/components/com_community/libraries/core.php:130015 CRoute::_() Copy JROOT/plugins/kunena/community/profile.php:4514 KunenaProfileCommunity->getUserListURL() Copy JROOT/components/com_kunena/controller/widget/whoisonline/display.php:9913 ComponentKunenaControllerWidgetWhoisonlineDisplay->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/pages/category/list/default.php:2110 include Copy JROOT/components/com_kunena/template/nts_kbento/pages/category/list/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:1126 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:2671 JApplicationCms->execute() Copy JROOT/index.php:73
クエリ時間:1.17 ms 最後のクエリの後:0.04 ms クエリメモリ:0.024 MB クエリ前のメモリ:23.570 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 ' )クエリではEXPLAINは使用できません:SELECT `id` FROM `joom_menu` WHERE `link` = 'index.php?option=com_community&view=frontpage' AND `published`='1' AND `type`='component' AND (`language` = 'ja-JA' )
Status Duration starting 0.05 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.06 ms preparing 0.05 ms executing 0.02 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 18 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:173217 JDatabaseDriver->loadResult() Copy JROOT/components/com_community/libraries/core.php:143016 CRoute::_getDefaultItemid() Copy JROOT/components/com_community/libraries/core.php:131515 CRoute::_() Copy JROOT/plugins/kunena/community/profile.php:4514 KunenaProfileCommunity->getUserListURL() Copy JROOT/components/com_kunena/controller/widget/whoisonline/display.php:9913 ComponentKunenaControllerWidgetWhoisonlineDisplay->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/pages/category/list/default.php:2110 include Copy JROOT/components/com_kunena/template/nts_kbento/pages/category/list/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:1126 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:2671 JApplicationCms->execute() Copy JROOT/index.php:73
クエリ時間:1.43 ms 最後のクエリの後:0.03 ms クエリメモリ:0.024 MB クエリ前のメモリ:23.578 MB 返された行:27
SELECT `id` FROM `joom_menu ` WHERE `link` LIKE '%option= com_community%' AND `published`= '1' AND `type`= 'component'クエリではEXPLAINは使用できません:SELECT `id` FROM `joom_menu` WHERE `link` LIKE '%option=com_community%' AND `published`='1' AND `type`='component'
Status Duration starting 0.05 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.02 ms preparing 0.02 ms executing 0.35 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 18 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:173217 JDatabaseDriver->loadResult() Copy JROOT/components/com_community/libraries/core.php:143916 CRoute::_getDefaultItemid() Copy JROOT/components/com_community/libraries/core.php:131515 CRoute::_() Copy JROOT/plugins/kunena/community/profile.php:4514 KunenaProfileCommunity->getUserListURL() Copy JROOT/components/com_kunena/controller/widget/whoisonline/display.php:9913 ComponentKunenaControllerWidgetWhoisonlineDisplay->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/pages/category/list/default.php:2110 include Copy JROOT/components/com_kunena/template/nts_kbento/pages/category/list/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:1126 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:2671 JApplicationCms->execute() Copy JROOT/index.php:73
クエリ時間:1.80 ms 最後のクエリの後:1.03 ms クエリメモリ:0.024 MB クエリ前のメモリ:23.645 MB 返された行:1
SELECT COUNT (* ), MAX (id) FROM joom_users WHERE (block= 0 OR activation= "")クエリではEXPLAINは使用できません:SELECT COUNT(*), MAX(id) FROM joom_users WHERE (block=0 OR activation="")
Status Duration starting 0.08 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.04 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.04 ms preparing 0.03 ms executing 0.60 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 18 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:176517 JDatabaseDriver->loadRow() Copy JROOT/libraries/kunena/user/helper.php:27716 KunenaUserHelper::getTotalCount() Copy JROOT/libraries/kunena/forum/statistics.php:18115 KunenaForumStatistics->loadMemberCount() Copy JROOT/libraries/kunena/forum/statistics.php:10314 KunenaForumStatistics->loadGeneral() Copy JROOT/components/com_kunena/controller/widget/statistics/display.php:4513 ComponentKunenaControllerWidgetStatisticsDisplay->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/pages/category/list/default.php:2210 include Copy JROOT/components/com_kunena/template/nts_kbento/pages/category/list/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:1126 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:2671 JApplicationCms->execute() Copy JROOT/index.php:73
クエリ時間:1.15 ms 最後のクエリの後:0.05 ms クエリメモリ:0.023 MB クエリ前のメモリ:23.653 MB 返された行:1
SELECT
SUM (time>= 1782273600 AND parent= 0) AS todayTopicCount,
SUM (time>= 1782273600 AND parent>0) AS todayReplyCount,
SUM (time>= 1782187200 AND time<1782273600 AND parent= 0) AS yesterdayTopicCount,
SUM (time>= 1782187200 AND time<1782273600 AND parent>0) AS yesterdayReplyCount
FROM joom_kunena_messages WHERE time>= 1782187200 AND hold= 0クエリではEXPLAINは使用できません:SELECT
SUM(time>=1782273600 AND parent=0) AS todayTopicCount,
SUM(time>=1782273600 AND parent>0) AS todayReplyCount,
SUM(time>=1782187200 AND time<1782273600 AND parent=0) AS yesterdayTopicCount,
SUM(time>=1782187200 AND time<1782273600 AND parent>0) AS yesterdayReplyCount
FROM joom_kunena_messages WHERE time>=1782187200 AND hold=0
Status Duration starting 0.07 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.06 ms preparing 0.02 ms executing 0.02 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 17 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:165416 JDatabaseDriver->loadObject() Copy JROOT/libraries/kunena/forum/statistics.php:22715 KunenaForumStatistics->loadLastDays() Copy JROOT/libraries/kunena/forum/statistics.php:10614 KunenaForumStatistics->loadGeneral() Copy JROOT/components/com_kunena/controller/widget/statistics/display.php:4513 ComponentKunenaControllerWidgetStatisticsDisplay->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/pages/category/list/default.php:2210 include Copy JROOT/components/com_kunena/template/nts_kbento/pages/category/list/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:1126 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:2671 JApplicationCms->execute() Copy JROOT/index.php:73
クエリ時間:1.22 ms 最後のクエリの後:0.07 ms クエリメモリ:0.024 MB クエリ前のメモリ:23.672 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 = 1621333クエリではEXPLAINは使用できません: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 = 1621333
Status Duration starting 0.06 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.05 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.08 ms preparing 0.01 ms executing 0.03 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 20 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:145719 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/widget/statistics/display.php:4813 ComponentKunenaControllerWidgetStatisticsDisplay->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/pages/category/list/default.php:2210 include Copy JROOT/components/com_kunena/template/nts_kbento/pages/category/list/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:1126 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:2671 JApplicationCms->execute() Copy JROOT/index.php:73
クエリ時間:1.30 ms 最後のクエリの後:0.09 ms クエリメモリ:0.024 MB クエリ前のメモリ:23.681 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 (1621333)クエリではEXPLAINは使用できません: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 (1621333)
Status Duration starting 0.09 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.01 ms Opening tables 0.05 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.11 ms preparing 0.02 ms executing 0.04 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 19 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:169318 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/widget/statistics/display.php:4813 ComponentKunenaControllerWidgetStatisticsDisplay->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/pages/category/list/default.php:2210 include Copy JROOT/components/com_kunena/template/nts_kbento/pages/category/list/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:1126 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:2671 JApplicationCms->execute() Copy JROOT/index.php:73
クエリ時間:2.36 ms 最後のクエリの後:1.78 ms クエリメモリ:0.026 MB クエリ前のメモリ:23.902 MB 返された行:15
SHOW FULL COLUMNS FROM `joom_community_profiles `クエリではEXPLAINは使用できません:SHOW FULL COLUMNS FROM `joom_community_profiles`
Status Duration starting 0.07 ms Executing hook on transaction 0.01 ms starting 0.06 ms checking permissions 0.01 ms checking permissions 0.00 ms Opening tables 0.47 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.13 ms preparing 0.04 ms Creating tmp table 0.05 ms executing 0.10 ms checking permissions 0.07 ms checking permissions 0.03 ms checking permissions 0.03 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.03 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.06 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.02 ms closing tables 0.02 ms freeing items 0.06 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 25 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:169324 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/joomla/database/driver/mysqli.php:43523 JDatabaseDriverMysqli->getTableColumns() Copy JROOT/libraries/joomla/table/table.php:24422 JTable->getFields() Copy JROOT/libraries/joomla/table/table.php:16321 JTable->__construct() Copy JROOT/components/com_community/tables/multiprofile.php:3220 CTableMultiProfile->__construct() Copy JROOT/libraries/joomla/table/table.php:31119 JTable::getInstance() Copy JROOT/components/com_community/libraries/user.php:73218 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/widget/statistics/display.php:4813 ComponentKunenaControllerWidgetStatisticsDisplay->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/pages/category/list/default.php:2210 include Copy JROOT/components/com_kunena/template/nts_kbento/pages/category/list/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:1126 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:2671 JApplicationCms->execute() Copy JROOT/index.php:73
クエリ時間:1.14 ms 最後のクエリの後:1.06 ms クエリメモリ:0.025 MB クエリ前のメモリ:24.136 MB 返された行:1
SELECT `id` FROM `joom_community_fields ` WHERE `fieldcode`= 'FIELD_GENDER 'クエリではEXPLAINは使用できません:SELECT `id` FROM `joom_community_fields` WHERE `fieldcode`='FIELD_GENDER'
Status Duration starting 0.05 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.06 ms preparing 0.02 ms executing 0.03 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 23 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:173222 JDatabaseDriver->loadResult() Copy JROOT/components/com_community/models/profile.php:79221 CommunityModelProfile->_getgenderId() Copy JROOT/components/com_community/models/profile.php:76620 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/widget/statistics/display.php:4813 ComponentKunenaControllerWidgetStatisticsDisplay->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/pages/category/list/default.php:2210 include Copy JROOT/components/com_kunena/template/nts_kbento/pages/category/list/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:1126 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:2671 JApplicationCms->execute() Copy JROOT/index.php:73
クエリ時間:1.08 ms 最後のクエリの後:0.03 ms クエリメモリ:0.025 MB クエリ前のメモリ:24.146 MB 返された行:0
SELECT `value` FROM `joom_community_fields_values ` WHERE `field_id` = '2' AND `user_id` = '1621333'クエリではEXPLAINは使用できません:SELECT `value` FROM `joom_community_fields_values` WHERE `field_id` = '2' AND `user_id` = '1621333'
Status Duration starting 0.06 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.05 ms executing 0.01 ms end 0.02 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 22 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:173221 JDatabaseDriver->loadResult() Copy JROOT/components/com_community/models/profile.php:77520 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/widget/statistics/display.php:4813 ComponentKunenaControllerWidgetStatisticsDisplay->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/pages/category/list/default.php:2210 include Copy JROOT/components/com_kunena/template/nts_kbento/pages/category/list/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:1126 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:2671 JApplicationCms->execute() Copy JROOT/index.php:73
クエリ時間:1.09 ms 最後のクエリの後:0.59 ms クエリメモリ:0.024 MB クエリ前のメモリ:24.189 MB 返された行:1
SELECT `id` FROM `joom_users ` WHERE id= '1621333'クエリではEXPLAINは使用できません:SELECT `id` FROM `joom_users` WHERE id='1621333'
Status Duration starting 0.04 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.01 ms executing 0.01 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 19 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:173218 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/widget/statistics/display.php:4813 ComponentKunenaControllerWidgetStatisticsDisplay->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/pages/category/list/default.php:2210 include Copy JROOT/components/com_kunena/template/nts_kbento/pages/category/list/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:1126 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:2671 JApplicationCms->execute() Copy JROOT/index.php:73
クエリ時間:1.37 ms 最後のクエリの後:0.04 ms クエリメモリ:0.024 MB クエリ前のメモリ:24.199 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`= '1621333'クエリではEXPLAINは使用できません: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`='1621333'
Status Duration starting 0.10 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.06 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.12 ms preparing 0.03 ms executing 0.06 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.06 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 20 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:165419 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/widget/statistics/display.php:4813 ComponentKunenaControllerWidgetStatisticsDisplay->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/pages/category/list/default.php:2210 include Copy JROOT/components/com_kunena/template/nts_kbento/pages/category/list/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:1126 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:2671 JApplicationCms->execute() Copy JROOT/index.php:73
クエリ時間:1.05 ms 最後のクエリの後:0.10 ms クエリメモリ:0.025 MB クエリ前のメモリ:24.213 MB 返された行:0
SELECT `value` FROM `joom_community_fields_values ` WHERE `field_id` = '2' AND `user_id` = '1621333'クエリではEXPLAINは使用できません:SELECT `value` FROM `joom_community_fields_values` WHERE `field_id` = '2' AND `user_id` = '1621333'
Status Duration starting 0.06 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.05 ms executing 0.01 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 22 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:173221 JDatabaseDriver->loadResult() Copy JROOT/components/com_community/models/profile.php:77520 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/widget/statistics/display.php:4813 ComponentKunenaControllerWidgetStatisticsDisplay->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/pages/category/list/default.php:2210 include Copy JROOT/components/com_kunena/template/nts_kbento/pages/category/list/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:1126 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:2671 JApplicationCms->execute() Copy JROOT/index.php:73
クエリ時間:1.55 ms 最後のクエリの後:0.15 ms クエリメモリ:0.024 MB クエリ前のメモリ:24.223 MB 返された行:3
SELECT `id` FROM `joom_menu ` WHERE `link` LIKE '%option= com_community&view= profile%' AND `published`= '1' AND `menutype`!= 'jomsocial' AND `type`= 'component'クエリではEXPLAINは使用できません:SELECT `id` FROM `joom_menu` WHERE `link` LIKE '%option=com_community&view=profile%' AND `published`='1' AND `menutype`!='jomsocial' AND `type`='component'
Status Duration starting 0.05 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.07 ms preparing 0.05 ms executing 0.40 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 20 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:173219 JDatabaseDriver->loadResult() Copy JROOT/components/com_community/libraries/core.php:139018 CRoute::_getViewItemid() Copy JROOT/components/com_community/libraries/core.php:130017 CRoute::_() Copy JROOT/plugins/kunena/community/profile.php:6316 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/widget/statistics/display.php:4813 ComponentKunenaControllerWidgetStatisticsDisplay->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/pages/category/list/default.php:2210 include Copy JROOT/components/com_kunena/template/nts_kbento/pages/category/list/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:1126 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:2671 JApplicationCms->execute() Copy JROOT/index.php:73
クエリ時間:1.51 ms 最後のクエリの後:2.48 ms クエリメモリ:0.026 MB クエリ前のメモリ:24.358 MB 返された行:0
SELECT `id` FROM `joom_menu ` WHERE `link` LIKE '%option= com_community&view= register%' AND `published`= '1' AND `menutype`!= 'jomsocial' AND `type`= 'component'クエリではEXPLAINは使用できません:SELECT `id` FROM `joom_menu` WHERE `link` LIKE '%option=com_community&view=register%' AND `published`='1' AND `menutype`!='jomsocial' AND `type`='component'
Status Duration starting 0.05 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.07 ms preparing 0.02 ms executing 0.37 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 23 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:173222 JDatabaseDriver->loadResult() Copy JROOT/components/com_community/libraries/core.php:139021 CRoute::_getViewItemid() Copy JROOT/components/com_community/libraries/core.php:130020 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:1476 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:2671 JApplicationCms->execute() Copy JROOT/index.php:73
クエリ時間:1.23 ms 最後のクエリの後:4.44 ms クエリメモリ:0.024 MB クエリ前のメモリ:24.686 MB 返された行:0
SELECT *
FROM joom_kunena_announcement
WHERE (published = 1) AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2026-06-24 15:57:37') AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2026-06-24 15:57:37')
ORDER BY id DESC LIMIT 1クエリではEXPLAINは使用できません:SELECT *
FROM joom_kunena_announcement
WHERE (published = 1) AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2026-06-24 15:57:37') AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2026-06-24 15:57:37')
ORDER BY id DESC LIMIT 1
Status Duration starting 0.07 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.05 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.03 ms preparing 0.07 ms executing 0.03 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 16 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:149815 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:1476 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:2671 JApplicationCms->execute() Copy JROOT/index.php:73
クエリ時間:1.64 ms 最後のクエリの後:2.91 ms クエリメモリ:0.021 MB クエリ前のメモリ:24.733 MB 返された行:1
SELECT language,id
FROM `joom_menu `
WHERE home = 1 AND published = 1 AND client_id = 0クエリではEXPLAINは使用できません:SELECT language,id
FROM `joom_menu`
WHERE home = 1 AND published = 1 AND client_id = 0
Status Duration starting 0.05 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.06 ms preparing 0.02 ms executing 0.30 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 12 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:169311 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/cms/language/multilang.php:10610 JLanguageMultilang::getSiteHomePages() Copy JROOT/plugins/system/languagefilter/languagefilter.php:7299 PlgSystemLanguageFilter->onAfterDispatch() 以下の行の呼び出しと同じです。 8 ReflectionMethod->invokeArgs() Copy JROOT/libraries/tovuti/Helpers/MethodHelper.php:587 Tovuti\Helpers\MethodHelper::call() Copy JROOT/libraries/joomla/event/event.php:726 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:2671 JApplicationCms->execute() Copy JROOT/index.php:73
クエリ時間:1.37 ms 最後のクエリの後:0.78 ms クエリメモリ:0.021 MB クエリ前のメモリ:24.785 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 = 839クエリではEXPLAINは使用できません: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 = 839
Status Duration starting 0.08 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.05 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.09 ms executing 0.01 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 13 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:169312 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/cms/language/associations.php:10111 JLanguageAssociations::getAssociations() Copy JROOT/administrator/components/com_menus/helpers/menus.php:31310 MenusHelper::getAssociations() Copy JROOT/plugins/system/languagefilter/languagefilter.php:7469 PlgSystemLanguageFilter->onAfterDispatch() 以下の行の呼び出しと同じです。 8 ReflectionMethod->invokeArgs() Copy JROOT/libraries/tovuti/Helpers/MethodHelper.php:587 Tovuti\Helpers\MethodHelper::call() Copy JROOT/libraries/joomla/event/event.php:726 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:2671 JApplicationCms->execute() Copy JROOT/index.php:73
クエリ時間:1.20 ms 最後のクエリの後:7.35 ms クエリメモリ:0.021 MB クエリ前のメモリ:25.250 MB 返された行:10
SELECT * FROM axs_fonts WHERE enabled = 1クエリではEXPLAINは使用できません:SELECT * FROM axs_fonts WHERE enabled = 1
Status Duration starting 0.08 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.02 ms executing 0.07 ms end 0.02 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 11 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:169310 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/axslibs/fonts.php:349 AxsFonts::getFonts() Copy JROOT/templates/axs/home.php:1388 include Copy JROOT/templates/axs/home.php Copy JROOT/templates/axs/index.php:727 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:11323 JApplicationCms->render() Copy JROOT/libraries/cms/application/site.php:7822 JApplicationSite->render() Copy JROOT/libraries/cms/application/cms.php:2721 JApplicationCms->execute() Copy JROOT/index.php:73
クエリ時間:1.36 ms 最後のクエリの後:0.34 ms クエリメモリ:0.021 MB クエリ前のメモリ:25.285 MB 返された行:0
SELECT *
FROM accessibility_images
WHERE `path`= 'images/pDJC5BxLjAW4jMgmh4ZjVUqCNDU3NDQ2OTkwOTMw/graphics/blue-logo.png' AND enabled= 1クエリではEXPLAINは使用できません:SELECT *
FROM accessibility_images
WHERE `path`='images/pDJC5BxLjAW4jMgmh4ZjVUqCNDU3NDQ2OTkwOTMw/graphics/blue-logo.png' AND enabled= 1
Status Duration starting 0.05 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.04 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.02 ms executing 0.03 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 12 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:165411 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:8388 include Copy JROOT/templates/axs/home.php Copy JROOT/templates/axs/index.php:727 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:11323 JApplicationCms->render() Copy JROOT/libraries/cms/application/site.php:7822 JApplicationSite->render() Copy JROOT/libraries/cms/application/cms.php:2721 JApplicationCms->execute() Copy JROOT/index.php:73
クエリ時間:1.65 ms 最後のクエリの後:1.80 ms クエリメモリ:0.021 MB クエリ前のメモリ:25.339 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' ) )クエリではEXPLAINは使用できません: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' ) )
Status Duration starting 0.09 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.06 ms init 0.01 ms System lock 0.01 ms optimizing 0.04 ms statistics 0.03 ms preparing 0.03 ms executing 0.03 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.74 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 11 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:169310 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/axslibs/notifications.php:199 AxsNotifications::loadNotifications() Copy JROOT/templates/axs/home.php:18278 include Copy JROOT/templates/axs/home.php Copy JROOT/templates/axs/index.php:727 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:11323 JApplicationCms->render() Copy JROOT/libraries/cms/application/site.php:7822 JApplicationSite->render() Copy JROOT/libraries/cms/application/cms.php:2721 JApplicationCms->execute() Copy JROOT/index.php:73
クエリ時間:1.15 ms 最後のクエリの後:1.28 ms クエリメモリ:0.022 MB クエリ前のメモリ:25.256 MB 返された行:1
SELECT sef FROM joom_languages WHERE lang_code = 'ja-JA ' LIMIT 1クエリではEXPLAINは使用できません:SELECT sef FROM joom_languages WHERE lang_code = 'ja-JA' LIMIT 1
Status Duration starting 0.07 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.04 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.07 ms preparing 0.01 ms executing 0.01 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 14 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:165413 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:11483 JApplicationCms->render() Copy JROOT/libraries/cms/application/site.php:7822 JApplicationSite->render() Copy JROOT/libraries/cms/application/cms.php:2721 JApplicationCms->execute() Copy JROOT/index.php:73
クエリ時間:1.12 ms 最後のクエリの後:5.01 ms クエリメモリ:0.025 MB クエリ前のメモリ:25.499 MB 返された行:0
SELECT *
FROM joom_easyblog_configs
WHERE `name` = 'config'クエリではEXPLAINは使用できません:SELECT *
FROM joom_easyblog_configs
WHERE `name` = 'config'
Status Duration starting 0.05 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.02 ms executing 0.03 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 22 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:145721 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:11483 JApplicationCms->render() Copy JROOT/libraries/cms/application/site.php:7822 JApplicationSite->render() Copy JROOT/libraries/cms/application/cms.php:2721 JApplicationCms->execute() Copy JROOT/index.php:73
クエリ時間:4.58 ms 最後のクエリの後:1.17 ms クエリメモリ:0.023 MB クエリ前のメモリ:25.566 MB 返された行:1
SELECT special_characters FROM joom_languages WHERE sef = 'ja' LIMIT 1クエリではEXPLAINは使用できません:SELECT special_characters FROM joom_languages WHERE sef = 'ja' LIMIT 1
Status Duration starting 0.47 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.43 ms Opening tables 1.88 ms init 0.36 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.06 ms preparing 0.01 ms executing 0.01 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 16 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:165415 JDatabaseDriver->loadObject() Copy JROOT/libraries/axslibs/language.php:30814 AxsLanguage::getSpecialCharacters() Copy JROOT/libraries/axslibs/language.php:2713 AxsLanguage::translate() Copy JROOT/modules/mod_defaultmenu/tmpl/default_component.php:3312 require Copy JROOT/modules/mod_defaultmenu/tmpl/default_component.php Copy JROOT/modules/mod_defaultmenu/tmpl/default.php:7211 require Copy JROOT/modules/mod_defaultmenu/tmpl/default.php Copy JROOT/modules/mod_defaultmenu/mod_defaultmenu.php:2510 include Copy JROOT/modules/mod_defaultmenu/mod_defaultmenu.php Copy JROOT/libraries/cms/module/helper.php:1989 JModuleHelper::renderModule() Copy JROOT/libraries/joomla/document/renderer/html/module.php:938 JDocumentRendererHtmlModule->render() Copy JROOT/libraries/joomla/document/renderer/html/modules.php:427 JDocumentRendererHtmlModules->render() Copy JROOT/libraries/joomla/document/html.php:4866 JDocumentHtml->getBuffer() Copy JROOT/libraries/joomla/document/html.php:7775 JDocumentHtml->_renderTemplate() Copy JROOT/libraries/joomla/document/html.php:5524 JDocumentHtml->render() Copy JROOT/libraries/cms/application/cms.php:11483 JApplicationCms->render() Copy JROOT/libraries/cms/application/site.php:7822 JApplicationSite->render() Copy JROOT/libraries/cms/application/cms.php:2721 JApplicationCms->execute() Copy JROOT/index.php:73
クエリ時間:1.32 ms 最後のクエリの後:0.06 ms クエリメモリ:0.023 MB クエリ前のメモリ:25.575 MB 返された行:25
SELECT *
FROM axs_translations
WHERE language_tag = 'ja'クエリではEXPLAINは使用できません:SELECT *
FROM axs_translations
WHERE language_tag = 'ja'
Status Duration starting 0.05 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.02 ms executing 0.10 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 16 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:149815 JDatabaseDriver->loadAssocList() Copy JROOT/libraries/axslibs/language.php:15114 AxsLanguage::getTranslationMap() Copy JROOT/libraries/axslibs/language.php:4013 AxsLanguage::translate() Copy JROOT/modules/mod_defaultmenu/tmpl/default_component.php:3312 require Copy JROOT/modules/mod_defaultmenu/tmpl/default_component.php Copy JROOT/modules/mod_defaultmenu/tmpl/default.php:7211 require Copy JROOT/modules/mod_defaultmenu/tmpl/default.php Copy JROOT/modules/mod_defaultmenu/mod_defaultmenu.php:2510 include Copy JROOT/modules/mod_defaultmenu/mod_defaultmenu.php Copy JROOT/libraries/cms/module/helper.php:1989 JModuleHelper::renderModule() Copy JROOT/libraries/joomla/document/renderer/html/module.php:938 JDocumentRendererHtmlModule->render() Copy JROOT/libraries/joomla/document/renderer/html/modules.php:427 JDocumentRendererHtmlModules->render() Copy JROOT/libraries/joomla/document/html.php:4866 JDocumentHtml->getBuffer() Copy JROOT/libraries/joomla/document/html.php:7775 JDocumentHtml->_renderTemplate() Copy JROOT/libraries/joomla/document/html.php:5524 JDocumentHtml->render() Copy JROOT/libraries/cms/application/cms.php:11483 JApplicationCms->render() Copy JROOT/libraries/cms/application/site.php:7822 JApplicationSite->render() Copy JROOT/libraries/cms/application/cms.php:2721 JApplicationCms->execute() Copy JROOT/index.php:73
5×SELECT * FROM `joom_kunena_topics ` 5×SELECT `id` FROM `joom_menu ` 2×SELECT * FROM joom_languages 2×SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `joom_extensions ` 2×SELECT a.`userid` as _userid , a.`status` as _status , a.`points` as _points, a.`posted_on` as _posted_on, a.`avatar` as _avatar , a.`thumb` as _thumb , a.`invite` as _invite, a.`params` as _cparams, a.`view` as _view, a.`friends` as _friends, a.`groups` as _groups, a.`events` as _events, a.`alias` as _alias, a.`profile_id` as _profile_id, a.`friendcount` as _friendcount, a.`storage` as _storage, a.`watermark_hash` as _watermark_hash, a.`search_email` AS _search_email, s.`userid` as _isonline, u.* FROM `joom_community_users ` as a LEFT JOIN `joom_users ` u ON u.`id`= a.`userid` LEFT OUTER JOIN `joom_session `s ON s.`userid`= a.`userid` 2×SELECT 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 `value` FROM `joom_community_fields_values ` 1×SELECT session_id FROM `joom_session ` 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 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 * FROM axs_payment_gateways 1×SELECT * FROM axs_integrations 1×SELECT id, rules FROM `joom_viewlevels 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 m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component FROM joom_menu AS m LEFT JOIN joom_extensions AS e ON m.component_id = e.extension_id 1×SELECT `id`,`title` FROM `joom_usergroups ` 1×SELECT params FROM axs_user_settings 1×SELECT * FROM `joom_users ` 1×SELECT id, home, template, s.params FROM joom_template_styles as s LEFT JOIN joom_extensions as e ON e.element= s.template AND e.type= 'template' AND e.client_id= s.client_id 1×SELECT * FROM joom_kunena_configuration 1×SELECT g.memberid AS user_id, c.id AS category_id, 2 AS role FROM joom_kunena_categories AS c INNER JOIN joom_community_groups_members AS g ON c.accesstype= 'jomsocial' AND c.access= g.groupid 1×SELECT `id`,`name`,`rules`,`parent_id` FROM `joom_assets ` 1×SELECT user_id, category_id, role FROM joom_kunena_user_categories 1×SELECT * FROM joom_kunena_categories 1×SELECT groupid FROM joom_community_groups_members 1×SELECT * FROM joom_kunena_topics 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 code, location FROM joom_kunena_smiley 1×SELECT userid, MAX (time) AS time FROM joom_session 1×SELECT COUNT (* ) FROM joom_session 1×SELECT * FROM joom_community_config 1×SELECT COUNT (* ), MAX (id) FROM joom_users 1×SELECT SUM (time>= 1782273600 AND parent= 0) AS todayTopicCount, SUM (time>= 1782273600 AND parent>0) AS todayReplyCount, SUM (time>= 1782187200 AND time<1782273600 AND parent= 0) AS yesterdayTopicCount, SUM (time>= 1782187200 AND time<1782273600 AND parent>0) AS yesterdayReplyCount FROM joom_kunena_messages 1×SELECT u.name, u.username, u.email, u.block as blocked, u.registerDate, u.lastvisitDate, ku.* FROM joom_users AS u LEFT JOIN joom_kunena_users AS ku ON u.id = ku.userid 1×SELECT `id` FROM `joom_community_fields ` 1×SELECT `id` FROM `joom_users ` 1×SELECT a.`userid` as _userid , a.`status` as _status , a.`points` as _points, a.`posted_on` as _posted_on, a.`avatar` as _avatar , a.`cover` as _cover , a.`thumb` as _thumb , a.`invite` as _invite, a.`params` as _cparams, a.`view` as _view, a.`friends` as _friends, a.`groups` as _groups, a.`events` as _events, a.`friendcount` as _friendcount, a.`alias` as _alias, a.`profile_id` as _profile_id, a.`storage` as _storage, a.`watermark_hash` as _watermark_hash, a.`search_email` as _search_email, s.`userid` as _isonline, u.* FROM `joom_community_users ` as a LEFT JOIN `joom_users ` u ON u.`id`= a.`userid` LEFT OUTER JOIN `joom_session ` s ON s.`userid`= a.`userid` AND s.`client_id` != '1' 1×SELECT * FROM joom_kunena_announcement 1×SELECT language,id FROM `joom_menu ` 1×SELECT `c2`.`language`,`c2`.`id` FROM `joom_menu ` AS `c` INNER JOIN `joom_associations ` AS `a` ON a.id = c.`id` AND a.context= 'com_menus.item' INNER JOIN `joom_associations ` AS `a2` ON a.key = a2.key INNER JOIN `joom_menu ` AS `c2` ON a2.id = c2.`id` 1×SELECT * FROM axs_fonts 1×SELECT * FROM accessibility_images 1×SELECT * FROM axs_notifications 1×SELECT sef FROM joom_languages 1×SELECT * FROM joom_easyblog_configs 1×SELECT special_characters FROM joom_languages 1×SELECT * FROM axs_translations