クエリ時間:1.22 ms クエリメモリ:0.020 MB クエリ前のメモリ:6.415 MB 返された行:0
SELECT session_id
FROM `joom_session `
WHERE `session_id` = 'fasb9rmd36q4tcqkt5okihq1km' LIMIT 1クエリではEXPLAINは使用できません:SELECT session_id
FROM `joom_session`
WHERE `session_id` = 'fasb9rmd36q4tcqkt5okihq1km' LIMIT 1
Status Duration starting 0.09 ms Executing hook on transaction 0.01 ms starting 0.02 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 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
# 発信者 ファイルと行番号 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:53
クエリ時間:3.46 ms 最後のクエリの後:0.07 ms クエリメモリ:0.003 MB クエリ前のメモリ:6.420 MB
INSERT INTO `joom_session `
(`session_id`,`guest`,`time`,`userid`,`username`) VALUES
('fasb9rmd36q4tcqkt5okihq1km', 1, '1792212142', 0, '')クエリではEXPLAINは使用できません:INSERT INTO `joom_session`
(`session_id`,`guest`,`time`,`userid`,`username`) VALUES
('fasb9rmd36q4tcqkt5okihq1km', 1, '1792212142', 0, '')
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 update 0.22 ms end 0.01 ms query end 0.02 ms waiting for handler commit 0.09 ms closing tables 0.01 ms freeing items 0.01 ms async commit 2.07 ms cleaning up 0.02 ms
# 発信者 ファイルと行番号 7 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/cms/application/cms.php:2106 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:53
クエリ時間:1.35 ms 最後のクエリの後:18.37 ms クエリメモリ:0.020 MB クエリ前のメモリ:7.801 MB 返された行:1
SELECT * FROM `axs_brands` WHERE 1 = 1 AND language = 'en-GB ' AND (FIND_IN_SET ('k8s.intg.tovuti.io', domains) > 0) LIMIT 1クエリではEXPLAINは使用できません:SELECT * FROM `axs_brands` WHERE 1 = 1 AND language = 'en-GB' AND (FIND_IN_SET('k8s.intg.tovuti.io', domains) > 0) LIMIT 1
Status Duration starting 0.14 ms Executing hook on transaction 0.01 ms starting 0.02 ms checking permissions 0.01 ms Opening tables 0.06 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.02 ms preparing 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.04 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:6978 AxsBrands::getData() Copy JROOT/libraries/axslibs/brands.php:7647 AxsBrands::getBrandObject() Copy JROOT/libraries/axslibs/brands.php:676 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:75
クエリ時間:2.31 ms 最後のクエリの後:0.69 ms クエリメモリ:0.021 MB クエリ前のメモリ:7.884 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.11 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.03 ms preparing 0.03 ms executing 0.21 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.02 ms
# 発信者 ファイルと行番号 11 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:169310 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/axslibs/language.php:4849 AxsLanguage::getPublishedLanguages() Copy JROOT/libraries/axslibs/language.php:3938 AxsLanguage::getCurrentLanguage() Copy JROOT/libraries/axslibs/brands.php:7807 AxsBrands::getBrandObject() Copy JROOT/libraries/axslibs/brands.php:676 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:75
クエリ時間:1.31 ms 最後のクエリの後:1.88 ms クエリメモリ:0.020 MB クエリ前のメモリ:8.267 MB 返された行:1
SELECT * FROM `axs_homepage_templates` WHERE id = '1'クエリではEXPLAINは使用できません:SELECT * FROM `axs_homepage_templates` WHERE id = '1'
Status Duration starting 0.11 ms Executing hook on transaction 0.01 ms starting 0.03 ms checking permissions 0.01 ms Opening tables 0.05 ms init 0.01 ms System lock 0.03 ms optimizing 0.02 ms statistics 0.07 ms preparing 0.02 ms executing 0.03 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.06 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:8438 AxsBrands::getHomepageTemplate() Copy JROOT/libraries/axslibs/brands.php:7957 AxsBrands::getBrandObject() Copy JROOT/libraries/axslibs/brands.php:676 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:75
クエリ時間:1.21 ms 最後のクエリの後:0.08 ms クエリメモリ:0.020 MB クエリ前のメモリ:8.307 MB 返された行:1
SELECT * FROM `axs_dashboard_templates` WHERE id = '2'クエリではEXPLAINは使用できません:SELECT * FROM `axs_dashboard_templates` WHERE id = '2'
Status Duration starting 0.08 ms Executing hook on transaction 0.02 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.04 ms init 0.01 ms System lock 0.02 ms optimizing 0.02 ms statistics 0.07 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.03 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/axslibs/brands.php:8518 AxsBrands::getDashboardTemplate() Copy JROOT/libraries/axslibs/brands.php:8157 AxsBrands::getBrandObject() Copy JROOT/libraries/axslibs/brands.php:676 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:75
クエリ時間:1.11 ms 最後のクエリの後:0.07 ms クエリメモリ:0.020 MB クエリ前のメモリ:8.331 MB 返された行:1
SELECT *
FROM axs_email_settings
WHERE id = '1'クエリではEXPLAINは使用できません:SELECT *
FROM axs_email_settings
WHERE id = '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.03 ms init 0.01 ms System lock 0.02 ms optimizing 0.02 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.04 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:11298 AxsBrands::getEmailSettingsById() Copy JROOT/libraries/axslibs/brands.php:8217 AxsBrands::getBrandObject() Copy JROOT/libraries/axslibs/brands.php:676 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:75
クエリ時間:1.50 ms 最後のクエリの後:2.08 ms クエリメモリ:0.039 MB クエリ前のメモリ:8.610 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.04 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 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.29 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:8227 AxsBrands::getBrandObject() Copy JROOT/libraries/axslibs/brands.php:676 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:75
クエリ時間:1.23 ms 最後のクエリの後:0.41 ms クエリメモリ:0.021 MB クエリ前のメモリ:8.668 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.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.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.01 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:8227 AxsBrands::getBrandObject() Copy JROOT/libraries/axslibs/brands.php:676 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:75
クエリ時間:1.02 ms 最後のクエリの後:0.03 ms クエリメモリ:0.020 MB クエリ前のメモリ:8.673 MB 返された行:1
SELECT *
FROM axs_payment_gateways
WHERE id = '1'クエリではEXPLAINは使用できません:SELECT *
FROM axs_payment_gateways
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.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.01 ms
# 発信者 ファイルと行番号 10 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:16549 JDatabaseDriver->loadObject() Copy JROOT/libraries/axslibs/brands.php:10778 AxsBrands::getPaymentGatewayById() Copy JROOT/libraries/axslibs/brands.php:8247 AxsBrands::getBrandObject() Copy JROOT/libraries/axslibs/brands.php:676 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:75
クエリ時間:1.03 ms 最後のクエリの後:0.05 ms クエリメモリ:0.020 MB クエリ前のメモリ:8.683 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.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.03 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:11488 AxsBrands::getIntegrationById() Copy JROOT/libraries/axslibs/brands.php:8317 AxsBrands::getBrandObject() Copy JROOT/libraries/axslibs/brands.php:676 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:75
クエリ時間:1.69 ms 最後のクエリの後:12.76 ms クエリメモリ:0.020 MB クエリ前のメモリ:10.551 MB 返された行:7
SELECT id, rules
FROM `joom_viewlevels `クエリではEXPLAINは使用できません:SELECT id, rules
FROM `joom_viewlevels`
Status Duration starting 0.13 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.03 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.03 ms executing 0.05 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.03 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.02 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:78
クエリ時間:2.52 ms 最後のクエリの後:0.07 ms クエリメモリ:0.038 MB クエリ前のメモリ:10.576 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.09 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.07 ms preparing 0.03 ms executing 1.28 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.04 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:78
クエリ時間:2.10 ms 最後のクエリの後:15.39 ms クエリメモリ:0.023 MB クエリ前のメモリ:13.020 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.12 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.10 ms preparing 0.29 ms executing 0.06 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.01 ms closing tables 0.02 ms freeing items 0.04 ms cleaning up 0.03 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:78
クエリ時間:1.44 ms 最後のクエリの後:0.08 ms クエリメモリ:0.005 MB クエリ前のメモリ:13.011 MB
UPDATE `joom_extensions `
SET `params` = '{\"mediaversion\":\"bac2857630fda9fd2e79f7a7abd309bd\"}'
WHERE `type` = 'library' AND `element` = 'joomla'クエリではEXPLAINは使用できません:UPDATE `joom_extensions`
SET `params` = '{\"mediaversion\":\"bac2857630fda9fd2e79f7a7abd309bd\"}'
WHERE `type` = 'library' AND `element` = 'joomla'
Status Duration starting 0.29 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.09 ms updating 0.06 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.01 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:78
クエリ時間:1.38 ms 最後のクエリの後:4.66 ms クエリメモリ:0.020 MB クエリ前のメモリ:13.586 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.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.03 ms preparing 0.03 ms executing 0.20 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.03 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: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:78
クエリ時間:1.10 ms 最後のクエリの後:0.05 ms クエリメモリ:0.020 MB クエリ前のメモリ:13.611 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.06 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.02 ms preparing 0.02 ms executing 0.05 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:16549 JDatabaseDriver->loadObject() Copy JROOT/libraries/axslibs/language.php:1958 AxsLanguage::getSubdomainDefault() Copy JROOT/plugins/system/languagefilter/languagefilter.php:1077 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:78
クエリ時間:1.04 ms 最後のクエリの後:0.02 ms クエリメモリ:0.020 MB クエリ前のメモリ:13.617 MB 返された行:1
SELECT language, published FROM axs_brands WHERE id = 1クエリではEXPLAINは使用できません:SELECT language, published FROM axs_brands 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.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:165410 JDatabaseDriver->loadObject() Copy JROOT/libraries/axslibs/language.php:2959 AxsLanguage::getBrandDefaultLanguage() Copy JROOT/libraries/axslibs/language.php:2018 AxsLanguage::getSubdomainDefault() Copy JROOT/plugins/system/languagefilter/languagefilter.php:1077 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:78
クエリ時間:1.46 ms 最後のクエリの後:0.05 ms クエリメモリ:0.021 MB クエリ前のメモリ:13.623 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.07 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.02 ms executing 0.33 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/joomla/language/helper.php:2078 JLanguageHelper::getInstalledLanguages() Copy JROOT/plugins/system/languagefilter/languagefilter.php:1177 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:78
クエリ時間:2.37 ms 最後のクエリの後:12.68 ms クエリメモリ:0.074 MB クエリ前のメモリ:15.233 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.12 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.07 ms preparing 0.04 ms executing 1.12 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.02 ms closing tables 0.01 ms freeing items 0.05 ms cleaning up 0.02 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:13810 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:78
クエリ時間:1.21 ms 最後のクエリの後:20.67 ms クエリメモリ:0.021 MB クエリ前のメモリ:19.017 MB 返された行:0
SELECT *
FROM joom_easyblog_configs
WHERE `name` = 'config'クエリではEXPLAINは使用できません:SELECT *
FROM joom_easyblog_configs
WHERE `name` = 'config'
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.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.03 ms cleaning up 0.02 ms
# 発信者 ファイルと行番号 14 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:145713 JDatabaseDriver->loadAssoc() Copy JROOT/libraries/joomla/table/table.php:72912 JTable->load() Copy JROOT/administrator/components/com_easyblog/includes/easyblog.php:41511 EB::config() Copy JROOT/components/com_easyblog/router.php:30910 EasyBlogParseRoute() Copy JROOT/libraries/cms/component/router/legacy.php:1049 JComponentRouterLegacy->parse() Copy JROOT/libraries/cms/router/site.php:4328 JRouterSite->parseSefRoute() Copy JROOT/libraries/cms/router/router.php:4837 JRouter->_parseSefRoute() Copy JROOT/libraries/cms/router/router.php:2366 JRouter->parse() Copy JROOT/libraries/cms/router/site.php:1335 JRouterSite->parse() Copy JROOT/libraries/cms/application/cms.php: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:78
クエリ時間:2.18 ms 最後のクエリの後:0.16 ms クエリメモリ:0.022 MB クエリ前のメモリ:19.071 MB 返された行:1
SELECT * FROM joom_extensions WHERE name= 'com_media'クエリではEXPLAINは使用できません:SELECT * FROM joom_extensions WHERE name='com_media'
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.04 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.02 ms executing 1.06 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
# 発信者 ファイルと行番号 15 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:165414 JDatabaseDriver->loadObject() Copy JROOT/libraries/axslibs/images.php:6613 AxsImages::setSession() Copy JROOT/libraries/axslibs/images.php:1512 AxsImages::getImagesPath() Copy JROOT/administrator/components/com_easyblog/includes/easyblog.php:43011 EB::config() Copy JROOT/components/com_easyblog/router.php:30910 EasyBlogParseRoute() Copy JROOT/libraries/cms/component/router/legacy.php:1049 JComponentRouterLegacy->parse() Copy JROOT/libraries/cms/router/site.php:4328 JRouterSite->parseSefRoute() Copy JROOT/libraries/cms/router/router.php:4837 JRouter->_parseSefRoute() Copy JROOT/libraries/cms/router/router.php:2366 JRouter->parse() Copy JROOT/libraries/cms/router/site.php:1335 JRouterSite->parse() Copy JROOT/libraries/cms/application/cms.php: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:78
クエリ時間:1.23 ms 最後のクエリの後:0.88 ms クエリメモリ:0.021 MB クエリ前のメモリ:19.179 MB 返された行:1
SELECT *
FROM joom_easyblog_category
WHERE `alias` = 'blog'クエリではEXPLAINは使用できません:SELECT *
FROM joom_easyblog_category
WHERE `alias` = 'blog'
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.01 ms statistics 0.07 ms preparing 0.02 ms executing 0.05 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:145712 JDatabaseDriver->loadAssoc() Copy JROOT/libraries/joomla/table/table.php:72911 JTable->load() Copy JROOT/components/com_easyblog/router.php:51010 EasyBlogParseRoute() Copy JROOT/libraries/cms/component/router/legacy.php:1049 JComponentRouterLegacy->parse() Copy JROOT/libraries/cms/router/site.php:4328 JRouterSite->parseSefRoute() Copy JROOT/libraries/cms/router/router.php:4837 JRouter->_parseSefRoute() Copy JROOT/libraries/cms/router/router.php:2366 JRouter->parse() Copy JROOT/libraries/cms/router/site.php:1335 JRouterSite->parse() Copy JROOT/libraries/cms/application/cms.php: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:78
クエリ時間:1.20 ms 最後のクエリの後:11.93 ms クエリメモリ:0.020 MB クエリ前のメモリ:19.784 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.09 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.05 ms executing 0.02 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.01 ms closing tables 0.02 ms freeing items 0.04 ms cleaning up 0.02 ms
# 発信者 ファイルと行番号 9 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:16548 JDatabaseDriver->loadObject() Copy JROOT/libraries/axslibs/user.php:8047 AxsUser::{closure}() Copy JROOT/libraries/tovuti/Traits/Memoization.php:256 AxsUser::memoizeStatic() Copy JROOT/libraries/axslibs/user.php:7945 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:78
クエリ時間:2.87 ms 最後のクエリの後:2.69 ms クエリメモリ:0.022 MB クエリ前のメモリ:20.175 MB 返された行:20
SHOW FULL COLUMNS FROM `joom_users `クエリではEXPLAINは使用できません:SHOW FULL COLUMNS FROM `joom_users`
Status Duration starting 0.11 ms Executing hook on transaction 0.01 ms starting 0.06 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.62 ms init 0.02 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.13 ms preparing 0.04 ms Creating tmp table 0.06 ms executing 0.11 ms checking permissions 0.08 ms checking permissions 0.05 ms checking permissions 0.04 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.03 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.03 ms checking permissions 0.02 ms checking permissions 0.03 ms checking permissions 0.02 ms checking permissions 0.03 ms checking permissions 0.01 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.03 ms freeing items 0.08 ms cleaning up 0.03 ms
# 発信者 ファイルと行番号 14 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:169313 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/joomla/database/driver/mysqli.php:43512 JDatabaseDriverMysqli->getTableColumns() Copy JROOT/libraries/joomla/table/table.php:24411 JTable->getFields() Copy JROOT/libraries/joomla/table/table.php:16310 JTable->__construct() Copy JROOT/libraries/joomla/table/user.php:399 JTableUser->__construct() Copy JROOT/libraries/joomla/table/table.php:3118 JTable::getInstance() Copy JROOT/administrator/components/com_users/models/user.php:647 UsersModelUser->getTable() Copy JROOT/libraries/legacy/model/admin.php:9516 JModelAdmin->populateState() Copy JROOT/libraries/legacy/model/legacy.php:4405 JModelLegacy->getState() Copy JROOT/administrator/components/com_users/models/user.php:9734 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:78
クエリ時間:2.26 ms 最後のクエリの後:0.06 ms クエリメモリ:0.019 MB クエリ前のメモリ:20.202 MB 返された行:0
SELECT *
FROM `joom_users `
WHERE `id` = 1クエリではEXPLAINは使用できません:SELECT *
FROM `joom_users`
WHERE `id` = 1
Status Duration starting 0.24 ms Executing hook on transaction 0.03 ms starting 0.06 ms checking permissions 0.04 ms Opening tables 0.18 ms init 0.04 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.03 ms waiting for handler commit 0.04 ms closing tables 0.05 ms freeing items 0.11 ms cleaning up 0.09 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:78
クエリ時間:1.95 ms 最後のクエリの後:0.14 ms クエリメモリ:0.019 MB クエリ前のメモリ:20.215 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.15 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.10 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.09 ms preparing 0.04 ms executing 0.55 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.04 ms cleaning up 0.02 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:78
クエリ時間:1.25 ms 最後のクエリの後:3.09 ms クエリメモリ:0.006 MB クエリ前のメモリ:20.637 MB
DELETE FROM `joom_easyblog_mailq ` WHERE `status`= '1' AND DATEDIFF (NOW (), `created`) >= '7'クエリではEXPLAINは使用できません:DELETE FROM `joom_easyblog_mailq` WHERE `status`='1' AND DATEDIFF(NOW(), `created`) >='7'
Status Duration starting 0.10 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.09 ms updating 0.03 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.02 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 13 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/database.php:3312 JDatabase->query() Copy JROOT/administrator/components/com_easyblog/includes/utils.php:23611 EasyBlogDbJoomla->__call() Copy JROOT/administrator/components/com_easyblog/models/mailer.php:3910 EasyBlogModelMailer->cleanup() Copy JROOT/administrator/components/com_easyblog/includes/mailer/mailer.php:389 EasyBlogMailer->dispatch() Copy JROOT/components/com_easyblog/services/maintenance.php:188 require_once Copy JROOT/components/com_easyblog/services/maintenance.php Copy JROOT/administrator/components/com_easyblog/includes/easyblog.php:41727 EB::loadServices() Copy JROOT/components/com_easyblog/easyblog.php:336 require_once Copy JROOT/components/com_easyblog/easyblog.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:78
クエリ時間:1.21 ms 最後のクエリの後:0.02 ms クエリメモリ:0.022 MB クエリ前のメモリ:20.643 MB 返された行:0
SELECT `id` FROM `joom_easyblog_mailq ` WHERE `status`= '0' ORDER BY `created` ASC LIMIT 5クエリではEXPLAINは使用できません:SELECT `id` FROM `joom_easyblog_mailq` WHERE `status`='0' ORDER BY `created` ASC LIMIT 5
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.04 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.07 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.03 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 13 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:169312 JDatabaseDriver->loadObjectList() Copy JROOT/administrator/components/com_easyblog/includes/utils.php:23611 EasyBlogDbJoomla->__call() Copy JROOT/administrator/components/com_easyblog/models/mailer.php:6510 EasyBlogModelMailer->getPendingEmails() Copy JROOT/administrator/components/com_easyblog/includes/mailer/mailer.php:419 EasyBlogMailer->dispatch() Copy JROOT/components/com_easyblog/services/maintenance.php:188 require_once Copy JROOT/components/com_easyblog/services/maintenance.php Copy JROOT/administrator/components/com_easyblog/includes/easyblog.php:41727 EB::loadServices() Copy JROOT/components/com_easyblog/easyblog.php:336 require_once Copy JROOT/components/com_easyblog/easyblog.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:78
クエリ時間:1.41 ms 最後のクエリの後:6.36 ms クエリメモリ:0.022 MB クエリ前のメモリ:21.397 MB 返された行:0
SELECT * FROM `joom_easyblog_post ` WHERE `publish_up`<= '2026-10-17 00:42:23' AND `published`= '2' AND `state`= '0' ORDER BY `id` LIMIT 5クエリではEXPLAINは使用できません:SELECT * FROM `joom_easyblog_post` WHERE `publish_up`<='2026-10-17 00:42:23' AND `published`='2' AND `state`='0' ORDER BY `id` LIMIT 5
Status Duration starting 0.11 ms Executing hook on transaction 0.01 ms starting 0.02 ms checking permissions 0.01 ms Opening tables 0.07 ms init 0.01 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.10 ms preparing 0.05 ms executing 0.06 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.02 ms
# 発信者 ファイルと行番号 13 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:169312 JDatabaseDriver->loadObjectList() Copy JROOT/administrator/components/com_easyblog/includes/utils.php:23611 EasyBlogDbJoomla->__call() Copy JROOT/administrator/components/com_easyblog/models/blogs.php:27310 EasyBlogModelBlogs->getScheduledPosts() Copy JROOT/administrator/components/com_easyblog/includes/scheduler/scheduler.php:609 EasyBlogScheduler->publish() Copy JROOT/components/com_easyblog/services/maintenance.php:228 require_once Copy JROOT/components/com_easyblog/services/maintenance.php Copy JROOT/administrator/components/com_easyblog/includes/easyblog.php:41727 EB::loadServices() Copy JROOT/components/com_easyblog/easyblog.php:336 require_once Copy JROOT/components/com_easyblog/easyblog.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:78
クエリ時間:1.25 ms 最後のクエリの後:0.05 ms クエリメモリ:0.022 MB クエリ前のメモリ:21.409 MB 返された行:0
SELECT id, created_by FROM `joom_easyblog_post ` WHERE `publish_down` > `publish_up` AND `publish_down` <= '2026-10-17 00:42:23' AND `publish_down` != '0000-00-00 00:00:00' AND `published` = '1' AND `state` = '0'クエリではEXPLAINは使用できません:SELECT id, created_by FROM`joom_easyblog_post` WHERE `publish_down` > `publish_up` AND `publish_down` <= '2026-10-17 00:42:23' AND `publish_down` != '0000-00-00 00:00:00' AND `published` = '1' AND `state` = '0'
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.05 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.09 ms preparing 0.03 ms executing 0.05 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/administrator/components/com_easyblog/includes/utils.php:23611 EasyBlogDbJoomla->__call() Copy JROOT/administrator/components/com_easyblog/models/blogs.php:31610 EasyBlogModelBlogs->getUnpublishScheduledPosts() Copy JROOT/administrator/components/com_easyblog/includes/scheduler/scheduler.php:349 EasyBlogScheduler->unpublish() Copy JROOT/components/com_easyblog/services/maintenance.php:258 require_once Copy JROOT/components/com_easyblog/services/maintenance.php Copy JROOT/administrator/components/com_easyblog/includes/easyblog.php:41727 EB::loadServices() Copy JROOT/components/com_easyblog/easyblog.php:336 require_once Copy JROOT/components/com_easyblog/easyblog.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:78
クエリ時間:1.20 ms 最後のクエリの後:0.28 ms クエリメモリ:0.021 MB クエリ前のメモリ:21.446 MB 返された行:0
SELECT * FROM `joom_easyblog_uploader_tmp ` WHERE `created` <= DATE_SUB ('2026-10-17 04:42:23' , INTERVAL 120 MINUTE )クエリではEXPLAINは使用できません:SELECT * FROM `joom_easyblog_uploader_tmp` WHERE `created` <= DATE_SUB('2026-10-17 04:42:23' , INTERVAL 120 MINUTE)
Status Duration starting 0.12 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.05 ms preparing 0.02 ms executing 0.03 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.03 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 12 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:165411 JDatabaseDriver->loadObject() Copy JROOT/administrator/components/com_easyblog/includes/utils.php:23610 EasyBlogDbJoomla->__call() Copy JROOT/administrator/components/com_easyblog/includes/scheduler/scheduler.php:979 EasyBlogScheduler->removeTmpFiles() Copy JROOT/components/com_easyblog/services/maintenance.php:288 require_once Copy JROOT/components/com_easyblog/services/maintenance.php Copy JROOT/administrator/components/com_easyblog/includes/easyblog.php:41727 EB::loadServices() Copy JROOT/components/com_easyblog/easyblog.php:336 require_once Copy JROOT/components/com_easyblog/easyblog.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:78
クエリ時間:1.30 ms 最後のクエリの後:0.04 ms クエリメモリ:0.006 MB クエリ前のメモリ:21.454 MB
delete a, b from `joom_easyblog_post ` as a inner join `joom_easyblog_revisions ` as b on a.`id` = b.`post_id` where a.`published` = '9' and a.`created` <= DATE_SUB ('2026-10-17 04:42:23', INTERVAL 3 DAY ) クエリではEXPLAINは使用できません:delete a, b from `joom_easyblog_post` as a inner join `joom_easyblog_revisions` as b on a.`id` = b.`post_id` where a.`published` = '9' and a.`created` <= DATE_SUB('2026-10-17 04:42:23', INTERVAL 3 DAY)
Status Duration starting 0.09 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 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.10 ms preparing 0.02 ms deleting from main table 0.01 ms executing 0.05 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.01 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 12 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/database.php:3311 JDatabase->query() Copy JROOT/administrator/components/com_easyblog/includes/utils.php:23610 EasyBlogDbJoomla->__call() Copy JROOT/administrator/components/com_easyblog/includes/scheduler/scheduler.php:1349 EasyBlogScheduler->removeBlankPosts() Copy JROOT/components/com_easyblog/services/maintenance.php:328 require_once Copy JROOT/components/com_easyblog/services/maintenance.php Copy JROOT/administrator/components/com_easyblog/includes/easyblog.php:41727 EB::loadServices() Copy JROOT/components/com_easyblog/easyblog.php:336 require_once Copy JROOT/components/com_easyblog/easyblog.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:78
クエリ時間:1.25 ms 最後のクエリの後:0.45 ms クエリメモリ:0.022 MB クエリ前のメモリ:21.532 MB 返された行:1
SELECT * FROM `joom_menu ` WHERE `published`= '1' AND `link` LIKE 'index.php?option= com_easyblog%' AND `menutype`= 'mainmenu'クエリではEXPLAINは使用できません:SELECT * FROM `joom_menu` WHERE `published`='1' AND `link` LIKE 'index.php?option=com_easyblog%' AND `menutype`='mainmenu'
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.04 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.06 ms preparing 0.02 ms executing 0.13 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.03 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 15 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:169314 JDatabaseDriver->loadObjectList() Copy JROOT/administrator/components/com_easyblog/includes/utils.php:23613 EasyBlogDbJoomla->__call() Copy JROOT/administrator/components/com_easyblog/models/menu.php:5212 EasyBlogModelMenu->getAssociatedMenus() Copy JROOT/administrator/components/com_easyblog/includes/router.php:8011 EBR::getMenus() Copy JROOT/administrator/components/com_easyblog/includes/router.php:34310 EBR::_() Copy JROOT/administrator/components/com_easyblog/includes/easyblog.php:42209 EB::_() Copy JROOT/components/com_easyblog/services/weblog.php:278 require_once Copy JROOT/components/com_easyblog/services/weblog.php Copy JROOT/administrator/components/com_easyblog/includes/easyblog.php:41727 EB::loadServices() Copy JROOT/components/com_easyblog/easyblog.php:336 require_once Copy JROOT/components/com_easyblog/easyblog.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:78
クエリ時間:1.20 ms 最後のクエリの後:0.48 ms クエリメモリ:0.022 MB クエリ前のメモリ:21.583 MB 返された行:40
SELECT * FROM `joom_easyblog_acl ` WHERE `published`= '1' ORDER BY `id` ASC クエリではEXPLAINは使用できません:SELECT * FROM `joom_easyblog_acl` WHERE `published`='1' ORDER BY `id` ASC
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.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.03 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.03 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 13 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:169312 JDatabaseDriver->loadObjectList() Copy JROOT/administrator/components/com_easyblog/includes/acl/acl.php:29811 EasyBlogAcl::getRules() Copy JROOT/administrator/components/com_easyblog/includes/acl/acl.php:3810 EasyBlogAcl::getRuleSet() Copy JROOT/administrator/components/com_easyblog/includes/easyblog.php:1419 EB::acl() Copy JROOT/components/com_easyblog/controllers/controller.php:228 EasyBlogController->__construct() Copy JROOT/libraries/legacy/controller/legacy.php:3017 JControllerLegacy::getInstance() Copy JROOT/components/com_easyblog/easyblog.php:406 require_once Copy JROOT/components/com_easyblog/easyblog.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:78
クエリ時間:1.35 ms 最後のクエリの後:0.05 ms クエリメモリ:0.022 MB クエリ前のメモリ:21.612 MB 返された行:40
SELECT * FROM `joom_easyblog_acl_group ` WHERE `content_id`= '1' AND `type`= ' group'クエリではEXPLAINは使用できません:SELECT * FROM `joom_easyblog_acl_group` WHERE `content_id`='1' AND `type`='group'
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.02 ms executing 0.15 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/administrator/components/com_easyblog/includes/utils.php:23611 EasyBlogDbJoomla->__call() Copy JROOT/administrator/components/com_easyblog/includes/acl/acl.php:11210 EasyBlogAcl::getRuleSet() Copy JROOT/administrator/components/com_easyblog/includes/easyblog.php:1419 EB::acl() Copy JROOT/components/com_easyblog/controllers/controller.php:228 EasyBlogController->__construct() Copy JROOT/libraries/legacy/controller/legacy.php:3017 JControllerLegacy::getInstance() Copy JROOT/components/com_easyblog/easyblog.php:406 require_once Copy JROOT/components/com_easyblog/easyblog.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:78
クエリ時間:1.87 ms 最後のクエリの後:1.83 ms クエリメモリ:0.026 MB クエリ前のメモリ:21.857 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.12 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.08 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.28 ms preparing 0.03 ms executing 0.38 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.02 ms
# 発信者 ファイルと行番号 22 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:169321 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/joomla/access/access.php:43020 JAccess::preloadComponents() Copy JROOT/libraries/joomla/access/access.php:21119 JAccess::preload() Copy JROOT/libraries/joomla/access/access.php:53318 JAccess::getAssetRules() Copy JROOT/libraries/joomla/access/access.php:18117 JAccess::check() Copy JROOT/libraries/joomla/user/user.php:39416 JUser->authorise() Copy JROOT/administrator/components/com_easyblog/includes/easyblog.php:102015 EB::isSiteAdmin() Copy JROOT/administrator/components/com_easyblog/includes/themes/themes.php:9414 EasyBlogThemes->__construct() Copy JROOT/administrator/components/com_easyblog/includes/easyblog.php:412813 EB::template() Copy JROOT/components/com_easyblog/views/views.php:5112 EasyBlogView->__construct() Copy JROOT/components/com_easyblog/views/categories/view.html.php:2811 EasyBlogViewCategories->__construct() Copy JROOT/libraries/legacy/controller/legacy.php:59710 JControllerLegacy->createView() Copy JROOT/libraries/legacy/controller/legacy.php:8449 JControllerLegacy->getView() Copy JROOT/components/com_easyblog/controllers/controller.php:728 EasyBlogController->display() Copy JROOT/libraries/legacy/controller/legacy.php:7107 JControllerLegacy->execute() Copy JROOT/components/com_easyblog/easyblog.php:436 require_once Copy JROOT/components/com_easyblog/easyblog.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:78
クエリ時間:2.40 ms 最後のクエリの後:1.11 ms クエリメモリ:0.024 MB クエリ前のメモリ:22.053 MB 返された行:0
SELECT `id` FROM `joom_menu ` WHERE ( `link`= 'index.php?option= com_easyblog&view= categories&layout= listings&id= 1' OR `link` LIKE 'index.php?option= com_easyblog&view= categories&layout= listings&id= 1& limit%' OR `link`= 'index.php?option= com_easyblog&view= categories&layout= listings&id= 1' ) AND `published`= '1' AND (`language`= 'ja-JA ' OR `language`= '' OR `language`= '* ') LIMIT 1クエリではEXPLAINは使用できません:SELECT `id` FROM `joom_menu` WHERE ( `link`='index.php?option=com_easyblog&view=categories&layout=listings&id=1' OR `link` LIKE 'index.php?option=com_easyblog&view=categories&layout=listings&id=1&limit%' OR `link`='index.php?option=com_easyblog&view=categories&layout=listings&id=1' ) AND `published`='1' AND (`language`='ja-JA' OR `language`='' OR `language`='*') LIMIT 1
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.05 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.09 ms preparing 0.03 ms executing 1.16 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.04 ms cleaning up 0.02 ms
# 発信者 ファイルと行番号 19 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:173218 JDatabaseDriver->loadResult() Copy JROOT/administrator/components/com_easyblog/includes/utils.php:23617 EasyBlogDbJoomla->__call() Copy JROOT/administrator/components/com_easyblog/models/menu.php:30616 EasyBlogModelMenu->getMenusByCategoryId() Copy JROOT/administrator/components/com_easyblog/includes/easyblog.php:455315 EB::getMenuParams() Copy JROOT/administrator/components/com_easyblog/includes/themes/themes.php:14514 EasyBlogThemes->__construct() Copy JROOT/administrator/components/com_easyblog/includes/easyblog.php:412813 EB::template() Copy JROOT/components/com_easyblog/views/views.php:5112 EasyBlogView->__construct() Copy JROOT/components/com_easyblog/views/categories/view.html.php:2811 EasyBlogViewCategories->__construct() Copy JROOT/libraries/legacy/controller/legacy.php:59710 JControllerLegacy->createView() Copy JROOT/libraries/legacy/controller/legacy.php:8449 JControllerLegacy->getView() Copy JROOT/components/com_easyblog/controllers/controller.php:728 EasyBlogController->display() Copy JROOT/libraries/legacy/controller/legacy.php:7107 JControllerLegacy->execute() Copy JROOT/components/com_easyblog/easyblog.php:436 require_once Copy JROOT/components/com_easyblog/easyblog.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:78
クエリ時間:1.31 ms 最後のクエリの後:0.83 ms クエリメモリ:0.021 MB クエリ前のメモリ:22.202 MB 返された行:1
SELECT *
FROM joom_easyblog_category
WHERE `id` = '1'クエリではEXPLAINは使用できません:SELECT *
FROM joom_easyblog_category
WHERE `id` = '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.17 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
# 発信者 ファイルと行番号 12 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:145711 JDatabaseDriver->loadAssoc() Copy JROOT/libraries/joomla/table/table.php:72910 JTable->load() Copy JROOT/components/com_easyblog/views/categories/view.html.php:1249 EasyBlogViewCategories->listings() Copy JROOT/components/com_easyblog/controllers/controller.php:1068 EasyBlogController->display() Copy JROOT/libraries/legacy/controller/legacy.php:7107 JControllerLegacy->execute() Copy JROOT/components/com_easyblog/easyblog.php:436 require_once Copy JROOT/components/com_easyblog/easyblog.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:78
クエリ時間:1.24 ms 最後のクエリの後:0.22 ms クエリメモリ:0.021 MB クエリ前のメモリ:22.233 MB 返された行:1
SELECT *
FROM joom_easyblog_meta
WHERE `type` = 'category' AND `content_id` = '1'クエリではEXPLAINは使用できません:SELECT *
FROM joom_easyblog_meta
WHERE `type` = 'category' AND `content_id` = '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.06 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
# 発信者 ファイルと行番号 13 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:145712 JDatabaseDriver->loadAssoc() Copy JROOT/libraries/joomla/table/table.php:72911 JTable->load() Copy JROOT/administrator/components/com_easyblog/includes/easyblog.php:225810 EB::setMeta() Copy JROOT/components/com_easyblog/views/categories/view.html.php:1349 EasyBlogViewCategories->listings() Copy JROOT/components/com_easyblog/controllers/controller.php:1068 EasyBlogController->display() Copy JROOT/libraries/legacy/controller/legacy.php:7107 JControllerLegacy->execute() Copy JROOT/components/com_easyblog/easyblog.php:436 require_once Copy JROOT/components/com_easyblog/easyblog.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:78
クエリ時間:1.25 ms 最後のクエリの後:5.30 ms クエリメモリ:0.026 MB クエリ前のメモリ:22.780 MB 返された行:1
SELECT *
FROM joom_easyblog_category
WHERE `id` = '1'クエリではEXPLAINは使用できません:SELECT *
FROM joom_easyblog_category
WHERE `id` = '1'
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.05 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.07 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.03 ms cleaning up 0.03 ms
# 発信者 ファイルと行番号 24 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:145723 JDatabaseDriver->loadAssoc() Copy JROOT/libraries/joomla/table/table.php:72922 JTable->load() Copy JROOT/administrator/components/com_easyblog/includes/cache/cache.php:74521 EasyBlogCache->fallback() Copy JROOT/administrator/components/com_easyblog/includes/cache/cache.php:72020 EasyBlogCache->get() Copy JROOT/components/com_easyblog/router.php:10019 EasyBlogBuildRoute() Copy JROOT/libraries/cms/component/router/legacy.php:6818 JComponentRouterLegacy->build() Copy JROOT/libraries/cms/router/site.php:51917 JRouterSite->buildSefRoute() Copy JROOT/libraries/cms/router/site.php:48916 JRouterSite->_buildSefRoute() Copy JROOT/libraries/cms/router/router.php:28215 JRouter->build() Copy JROOT/libraries/cms/router/site.php:14914 JRouterSite->build() Copy JROOT/libraries/joomla/application/route.php:6213 JRoute::_() Copy JROOT/administrator/components/com_easyblog/includes/router.php:46112 EBR::_() Copy JROOT/administrator/components/com_easyblog/includes/router.php:74411 EBR::getRoutedURL() Copy JROOT/administrator/components/com_easyblog/tables/category.php:115710 EasyBlogTableCategory->getExternalPermalink() Copy JROOT/components/com_easyblog/views/categories/view.html.php:1379 EasyBlogViewCategories->listings() Copy JROOT/components/com_easyblog/controllers/controller.php:1068 EasyBlogController->display() Copy JROOT/libraries/legacy/controller/legacy.php:7107 JControllerLegacy->execute() Copy JROOT/components/com_easyblog/easyblog.php:436 require_once Copy JROOT/components/com_easyblog/easyblog.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:78
クエリ時間:1.23 ms 最後のクエリの後:1.92 ms クエリメモリ:0.022 MB クエリ前のメモリ:22.947 MB 返された行:1
SELECT *
FROM joom_easyblog_category
WHERE `id` = '1'クエリではEXPLAINは使用できません:SELECT *
FROM joom_easyblog_category
WHERE `id` = '1'
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.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.04 ms cleaning up 0.03 ms
# 発信者 ファイルと行番号 14 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:145713 JDatabaseDriver->loadAssoc() Copy JROOT/libraries/joomla/table/table.php:72912 JTable->load() Copy JROOT/administrator/components/com_easyblog/models/categories.php:57411 EasyBlogModelCategories->getChildCategories() Copy JROOT/administrator/components/com_easyblog/includes/easyblog.php:282610 EB::buildNestedCategories() Copy JROOT/components/com_easyblog/views/categories/view.html.php:1559 EasyBlogViewCategories->listings() Copy JROOT/components/com_easyblog/controllers/controller.php:1068 EasyBlogController->display() Copy JROOT/libraries/legacy/controller/legacy.php:7107 JControllerLegacy->execute() Copy JROOT/components/com_easyblog/easyblog.php:436 require_once Copy JROOT/components/com_easyblog/easyblog.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:78
クエリ時間:1.46 ms 最後のクエリの後:0.40 ms クエリメモリ:0.022 MB クエリ前のメモリ:22.984 MB 返された行:0
select a.`id`, a.`title`, a.`alias`, a.`private`, a.`parent_id` from `joom_easyblog_category ` as a WHERE a.`lft` > '1' AND a.`lft` < '2' and a.`published` = '1' AND (( ( a.`private` = 0) OR ( a.`private` = 1 and 1 > 0) OR ( a.`private` = 2 and (select count(1) from `joom_easyblog_category_acl ` where `category_id` = a.`id` and `acl_id` in (1) and `content_id` in (1)) > 0))) ORDER BY a.`lft` ASC クエリではEXPLAINは使用できません:select a.`id`, a.`title`, a.`alias`, a.`private`, a.`parent_id` from `joom_easyblog_category` as a WHERE a.`lft` > '1' AND a.`lft` < '2' and a.`published` = '1' AND (( ( a.`private` = 0) OR ( a.`private` = 1 and 1 > 0) OR ( a.`private` = 2 and (select count(1) from `joom_easyblog_category_acl` where `category_id` = a.`id` and `acl_id` in (1) and `content_id` in (1)) > 0))) ORDER BY a.`lft` ASC
Status Duration starting 0.13 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.07 ms init 0.01 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.10 ms preparing 0.04 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.02 ms executing 0.04 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.02 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.03 ms
# 発信者 ファイルと行番号 14 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:169313 JDatabaseDriver->loadObjectList() Copy JROOT/administrator/components/com_easyblog/includes/utils.php:23612 EasyBlogDbJoomla->__call() Copy JROOT/administrator/components/com_easyblog/models/categories.php:62811 EasyBlogModelCategories->getChildCategories() Copy JROOT/administrator/components/com_easyblog/includes/easyblog.php:282610 EB::buildNestedCategories() Copy JROOT/components/com_easyblog/views/categories/view.html.php:1559 EasyBlogViewCategories->listings() Copy JROOT/components/com_easyblog/controllers/controller.php:1068 EasyBlogController->display() Copy JROOT/libraries/legacy/controller/legacy.php:7107 JControllerLegacy->execute() Copy JROOT/components/com_easyblog/easyblog.php:436 require_once Copy JROOT/components/com_easyblog/easyblog.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:78
クエリ時間:1.50 ms 最後のクエリの後:1.55 ms クエリメモリ:0.021 MB クエリ前のメモリ:23.137 MB 返された行:1
SELECT COUNT (1) AS `cnt` FROM `joom_easyblog_post_category ` AS `a` INNER JOIN `joom_easyblog_post ` AS `b` ON a.`post_id` = b.`id` AND b.`published`= '1' INNER JOIN `joom_easyblog_category ` AS `c` ON a.`category_id` = c.`id` AND b.`access`= '0' WHERE ( c.`id` IN (1) or c.`parent_id` IN (1)) AND b.`state`= '0' AND ( b.`language`= 'ja-JA ' OR b.`language`= '' OR b.`language`= '* ' )クエリではEXPLAINは使用できません:SELECT COUNT(1) AS `cnt` FROM `joom_easyblog_post_category` AS `a` INNER JOIN `joom_easyblog_post` AS `b` ON a.`post_id` = b.`id` AND b.`published`='1' INNER JOIN `joom_easyblog_category` AS `c` ON a.`category_id` = c.`id` AND b.`access`='0' WHERE ( c.`id` IN (1) or c.`parent_id` IN (1)) AND b.`state`='0' AND ( b.`language`='ja-JA' OR b.`language`='' OR b.`language`='*' )
Status Duration starting 0.13 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 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.15 ms preparing 0.06 ms executing 0.08 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.02 ms
# 発信者 ファイルと行番号 13 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:154212 JDatabaseDriver->loadColumn() Copy JROOT/administrator/components/com_easyblog/includes/utils.php:11911 EasyBlogDbJoomla->loadResultArray() Copy JROOT/administrator/components/com_easyblog/models/category.php:66810 EasyBlogModelCategory->getTotalPostCount() Copy JROOT/components/com_easyblog/views/categories/view.html.php:1989 EasyBlogViewCategories->listings() Copy JROOT/components/com_easyblog/controllers/controller.php:1068 EasyBlogController->display() Copy JROOT/libraries/legacy/controller/legacy.php:7107 JControllerLegacy->execute() Copy JROOT/components/com_easyblog/easyblog.php:436 require_once Copy JROOT/components/com_easyblog/easyblog.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:78
クエリ時間:2.35 ms 最後のクエリの後:3.47 ms クエリメモリ:0.021 MB クエリ前のメモリ:23.566 MB 返された行:1
SELECT COUNT (1) FROM `joom_easyblog_post ` AS a WHERE a.`published`= '1' AND a.`state`= '0' AND ( (a.`source_type` = 'easyblog.sitewide') OR ( a.`source_type` = 'easyblog.team' and 1 <= (select count(1) from `joom_easyblog_team ` as srcteam where srcteam.`id` = a.`source_id` and srcteam.`published` = 1 and ( (srcteam.`access` = 3) OR (srcteam.`access` = 2 and (select count(1) from `joom_easyblog_team_groups ` as srcteamgrp where srcteamgrp.`team_id` = srcteam.`id` and srcteamgrp.`group_id` IN (1) ) > 0) OR (srcteam.`access` = 1 and (select count(1) from `joom_easyblog_team_groups ` as srcteamgrp where srcteamgrp.`team_id` = srcteam.`id` and srcteamgrp.`group_id` IN (1) ) > 0))))) AND (1 <= (select count(1) from `joom_easyblog_post_category ` AS acp INNER JOIN `joom_easyblog_category ` as cat on acp.`category_id` = cat.`id` where acp.`post_id` = a.`id` AND cat.`id` = 1 and ( ( cat.`private` = 0 ) OR ( (cat.`private` = 1) and (0 > 0) ) OR ( (cat.`private` = 2) and ( (select count(1) from `joom_easyblog_category_acl ` as cacl where cacl.`category_id` = cat.id and cacl.`acl_id` = 1 and cacl.`content_id` in (1)) > 0 ) ) ) )) AND a.`access`= '0' AND (a.`language`= 'ja-JA ' OR a.`language`= '* ' OR a.`language`= '') ORDER BY a.`created` descクエリではEXPLAINは使用できません:SELECT COUNT(1) FROM `joom_easyblog_post` AS a WHERE a.`published`='1' AND a.`state`='0' AND ( (a.`source_type` = 'easyblog.sitewide') OR ( a.`source_type` = 'easyblog.team' and 1 <= (select count(1) from `joom_easyblog_team` as srcteam where srcteam.`id` = a.`source_id` and srcteam.`published` = 1 and ( (srcteam.`access` = 3) OR (srcteam.`access` = 2 and (select count(1) from `joom_easyblog_team_groups` as srcteamgrp where srcteamgrp.`team_id` = srcteam.`id` and srcteamgrp.`group_id` IN (1) ) > 0) OR (srcteam.`access` = 1 and (select count(1) from `joom_easyblog_team_groups` as srcteamgrp where srcteamgrp.`team_id` = srcteam.`id` and srcteamgrp.`group_id` IN (1) ) > 0))))) AND (1 <= (select count(1) from `joom_easyblog_post_category` AS acp INNER JOIN `joom_easyblog_category` as cat on acp.`category_id` = cat.`id` where acp.`post_id` = a.`id` AND cat.`id` = 1 and ( ( cat.`private` = 0 ) OR ( (cat.`private` = 1) and (0 > 0) ) OR ( (cat.`private` = 2) and ( (select count(1) from `joom_easyblog_category_acl` as cacl where cacl.`category_id` = cat.id and cacl.`acl_id` = 1 and cacl.`content_id` in (1)) > 0 ) ) ) )) AND a.`access`='0' AND (a.`language`='ja-JA' OR a.`language`='*' OR a.`language`='') ORDER BY a.`created` desc
Status Duration starting 0.19 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.01 ms Opening tables 0.12 ms init 0.01 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.12 ms preparing 0.03 ms optimizing 0.01 ms statistics 0.08 ms preparing 0.02 ms optimizing 0.01 ms statistics 0.10 ms preparing 0.02 ms optimizing 0.02 ms statistics 0.05 ms preparing 0.01 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.02 ms executing 0.04 ms executing 0.02 ms executing 0.02 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.02 ms closing tables 0.02 ms freeing items 0.04 ms cleaning up 0.07 ms
# 発信者 ファイルと行番号 13 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:173212 JDatabaseDriver->loadResult() Copy JROOT/administrator/components/com_easyblog/includes/utils.php:23611 EasyBlogDbJoomla->__call() Copy JROOT/administrator/components/com_easyblog/models/category.php:107010 EasyBlogModelCategory->getPosts() Copy JROOT/components/com_easyblog/views/categories/view.html.php:2039 EasyBlogViewCategories->listings() Copy JROOT/components/com_easyblog/controllers/controller.php:1068 EasyBlogController->display() Copy JROOT/libraries/legacy/controller/legacy.php:7107 JControllerLegacy->execute() Copy JROOT/components/com_easyblog/easyblog.php:436 require_once Copy JROOT/components/com_easyblog/easyblog.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:78
クエリ時間:2.22 ms 最後のクエリの後:0.06 ms クエリメモリ:0.021 MB クエリ前のメモリ:23.574 MB 返された行:2
SELECT a.* FROM `joom_easyblog_post ` AS a WHERE a.`published`= '1' AND a.`state`= '0' AND ( (a.`source_type` = 'easyblog.sitewide') OR ( a.`source_type` = 'easyblog.team' and 1 <= (select count(1) from `joom_easyblog_team ` as srcteam where srcteam.`id` = a.`source_id` and srcteam.`published` = 1 and ( (srcteam.`access` = 3) OR (srcteam.`access` = 2 and (select count(1) from `joom_easyblog_team_groups ` as srcteamgrp where srcteamgrp.`team_id` = srcteam.`id` and srcteamgrp.`group_id` IN (1) ) > 0) OR (srcteam.`access` = 1 and (select count(1) from `joom_easyblog_team_groups ` as srcteamgrp where srcteamgrp.`team_id` = srcteam.`id` and srcteamgrp.`group_id` IN (1) ) > 0))))) AND (1 <= (select count(1) from `joom_easyblog_post_category ` AS acp INNER JOIN `joom_easyblog_category ` as cat on acp.`category_id` = cat.`id` where acp.`post_id` = a.`id` AND cat.`id` = 1 and ( ( cat.`private` = 0 ) OR ( (cat.`private` = 1) and (0 > 0) ) OR ( (cat.`private` = 2) and ( (select count(1) from `joom_easyblog_category_acl ` as cacl where cacl.`category_id` = cat.id and cacl.`acl_id` = 1 and cacl.`content_id` in (1)) > 0 ) ) ) )) AND a.`access`= '0' AND (a.`language`= 'ja-JA ' OR a.`language`= '* ' OR a.`language`= '') ORDER BY a.`created` desc LIMIT 0,5クエリではEXPLAINは使用できません:SELECT a.* FROM `joom_easyblog_post` AS a WHERE a.`published`='1' AND a.`state`='0' AND ( (a.`source_type` = 'easyblog.sitewide') OR ( a.`source_type` = 'easyblog.team' and 1 <= (select count(1) from `joom_easyblog_team` as srcteam where srcteam.`id` = a.`source_id` and srcteam.`published` = 1 and ( (srcteam.`access` = 3) OR (srcteam.`access` = 2 and (select count(1) from `joom_easyblog_team_groups` as srcteamgrp where srcteamgrp.`team_id` = srcteam.`id` and srcteamgrp.`group_id` IN (1) ) > 0) OR (srcteam.`access` = 1 and (select count(1) from `joom_easyblog_team_groups` as srcteamgrp where srcteamgrp.`team_id` = srcteam.`id` and srcteamgrp.`group_id` IN (1) ) > 0))))) AND (1 <= (select count(1) from `joom_easyblog_post_category` AS acp INNER JOIN `joom_easyblog_category` as cat on acp.`category_id` = cat.`id` where acp.`post_id` = a.`id` AND cat.`id` = 1 and ( ( cat.`private` = 0 ) OR ( (cat.`private` = 1) and (0 > 0) ) OR ( (cat.`private` = 2) and ( (select count(1) from `joom_easyblog_category_acl` as cacl where cacl.`category_id` = cat.id and cacl.`acl_id` = 1 and cacl.`content_id` in (1)) > 0 ) ) ) )) AND a.`access`='0' AND (a.`language`='ja-JA' OR a.`language`='*' OR a.`language`='') ORDER BY a.`created` desc LIMIT 0,5
Status Duration starting 0.18 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.15 ms init 0.01 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.16 ms preparing 0.04 ms optimizing 0.02 ms statistics 0.07 ms preparing 0.01 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.01 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.02 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.01 ms executing 0.06 ms executing 0.04 ms executing 0.04 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.02 ms closing tables 0.02 ms freeing items 0.05 ms cleaning up 0.02 ms
# 発信者 ファイルと行番号 13 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:169312 JDatabaseDriver->loadObjectList() Copy JROOT/administrator/components/com_easyblog/includes/utils.php:23611 EasyBlogDbJoomla->__call() Copy JROOT/administrator/components/com_easyblog/models/category.php:109010 EasyBlogModelCategory->getPosts() Copy JROOT/components/com_easyblog/views/categories/view.html.php:2039 EasyBlogViewCategories->listings() Copy JROOT/components/com_easyblog/controllers/controller.php:1068 EasyBlogController->display() Copy JROOT/libraries/legacy/controller/legacy.php:7107 JControllerLegacy->execute() Copy JROOT/components/com_easyblog/easyblog.php:436 require_once Copy JROOT/components/com_easyblog/easyblog.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:78
クエリ時間:1.23 ms 最後のクエリの後:0.05 ms クエリメモリ:0.021 MB クエリ前のメモリ:23.581 MB 返された行:1
SELECT COUNT (1) FROM `joom_easyblog_category_acl ` WHERE `acl_id` = '1' AND `status` = '1' AND `category_id` = '1' AND `content_id` IN ('1')クエリではEXPLAINは使用できません:SELECT COUNT(1) FROM `joom_easyblog_category_acl` WHERE `acl_id` = '1' AND `status` = '1' AND `category_id` = '1' AND `content_id` IN ('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.08 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.06 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.02 ms
# 発信者 ファイルと行番号 13 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:173212 JDatabaseDriver->loadResult() Copy JROOT/administrator/components/com_easyblog/includes/utils.php:23611 EasyBlogDbJoomla->__call() Copy JROOT/administrator/components/com_easyblog/models/category.php:132110 EasyBlogModelCategory->allowAclCategory() Copy JROOT/components/com_easyblog/views/categories/view.html.php:2099 EasyBlogViewCategories->listings() Copy JROOT/components/com_easyblog/controllers/controller.php:1068 EasyBlogController->display() Copy JROOT/libraries/legacy/controller/legacy.php:7107 JControllerLegacy->execute() Copy JROOT/components/com_easyblog/easyblog.php:436 require_once Copy JROOT/components/com_easyblog/easyblog.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:78
クエリ時間:1.38 ms 最後のクエリの後:1.93 ms クエリメモリ:0.023 MB クエリ前のメモリ:23.767 MB 返された行:0
SELECT COUNT (1) as `voted`, `uid` FROM `joom_easyblog_ratings ` WHERE `uid` IN (3,2) AND `type`= 'entry' AND `created_by`= '0' AND (`sessionid` = 'fasb9rmd36q4tcqkt5okihq1km' OR `ip` = '10.7.52.35') GROUP BY `uid` ORDER BY NULL クエリではEXPLAINは使用できません:SELECT COUNT(1) as `voted`, `uid` FROM `joom_easyblog_ratings` WHERE `uid` IN (3,2) AND `type`='entry' AND `created_by`='0' AND (`sessionid` = 'fasb9rmd36q4tcqkt5okihq1km' OR `ip` = '10.7.52.35') GROUP BY `uid` ORDER BY NULL
Status Duration starting 0.10 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.15 ms preparing 0.03 ms Creating tmp table 0.04 ms executing 0.03 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.02 ms closing tables 0.01 ms freeing items 0.10 ms cleaning up 0.03 ms
# 発信者 ファイルと行番号 18 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:169317 JDatabaseDriver->loadObjectList() Copy JROOT/administrator/components/com_easyblog/includes/utils.php:23616 EasyBlogDbJoomla->__call() Copy JROOT/administrator/components/com_easyblog/models/ratings.php:13315 EasyBlogModelRatings->preloadUserPostRatings() Copy JROOT/administrator/components/com_easyblog/includes/cache/cache.php:33714 EasyBlogCache->cacheVoted() Copy JROOT/administrator/components/com_easyblog/includes/cache/cache.php:26113 EasyBlogCache->insert() Copy JROOT/administrator/components/com_easyblog/includes/formatter/types/list.php:3112 EasyBlogFormatterList->execute() Copy JROOT/administrator/components/com_easyblog/includes/formatter/formatter.php:5111 EasyBlogFormatter->execute() Copy JROOT/administrator/components/com_easyblog/includes/easyblog.php:420510 EB::formatter() Copy JROOT/components/com_easyblog/views/categories/view.html.php:2169 EasyBlogViewCategories->listings() Copy JROOT/components/com_easyblog/controllers/controller.php:1068 EasyBlogController->display() Copy JROOT/libraries/legacy/controller/legacy.php:7107 JControllerLegacy->execute() Copy JROOT/components/com_easyblog/easyblog.php:436 require_once Copy JROOT/components/com_easyblog/easyblog.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:78
クエリ時間:1.24 ms 最後のクエリの後:0.04 ms クエリメモリ:0.023 MB クエリ前のメモリ:23.775 MB 返された行:0
SELECT AVG (`value`) AS `ratings` ,COUNT (1) AS `total` ,`uid` FROM `joom_easyblog_ratings ` AS a WHERE a.`uid` IN (3,2) AND `type`= 'entry' GROUP BY `uid` ORDER BY NULL クエリではEXPLAINは使用できません:SELECT AVG(`value`) AS `ratings` ,COUNT(1) AS `total` ,`uid` FROM `joom_easyblog_ratings` AS a WHERE a.`uid` IN(3,2) AND `type`='entry' GROUP BY `uid` ORDER BY NULL
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.08 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.03 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 18 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:169317 JDatabaseDriver->loadObjectList() Copy JROOT/administrator/components/com_easyblog/includes/utils.php:23616 EasyBlogDbJoomla->__call() Copy JROOT/administrator/components/com_easyblog/models/ratings.php:17415 EasyBlogModelRatings->preloadRatings() Copy JROOT/administrator/components/com_easyblog/includes/cache/cache.php:46114 EasyBlogCache->cacheRatings() Copy JROOT/administrator/components/com_easyblog/includes/cache/cache.php:26413 EasyBlogCache->insert() Copy JROOT/administrator/components/com_easyblog/includes/formatter/types/list.php:3112 EasyBlogFormatterList->execute() Copy JROOT/administrator/components/com_easyblog/includes/formatter/formatter.php:5111 EasyBlogFormatter->execute() Copy JROOT/administrator/components/com_easyblog/includes/easyblog.php:420510 EB::formatter() Copy JROOT/components/com_easyblog/views/categories/view.html.php:2169 EasyBlogViewCategories->listings() Copy JROOT/components/com_easyblog/controllers/controller.php:1068 EasyBlogController->display() Copy JROOT/libraries/legacy/controller/legacy.php:7107 JControllerLegacy->execute() Copy JROOT/components/com_easyblog/easyblog.php:436 require_once Copy JROOT/components/com_easyblog/easyblog.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:78
クエリ時間:1.16 ms 最後のクエリの後:1.08 ms クエリメモリ:0.023 MB クエリ前のメモリ:23.924 MB 返された行:0
SELECT a.* FROM `joom_easyblog_comment ` AS a WHERE a.`post_id` IN (3,2) AND a.`published`= '1'クエリではEXPLAINは使用できません:SELECT a.* FROM `joom_easyblog_comment` AS a WHERE a.`post_id` IN(3,2) AND a.`published`='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.04 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.06 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.03 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 18 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:169317 JDatabaseDriver->loadObjectList() Copy JROOT/administrator/components/com_easyblog/includes/utils.php:23616 EasyBlogDbJoomla->__call() Copy JROOT/administrator/components/com_easyblog/models/comment.php:57415 EasyBlogModelComment->preloadComments() Copy JROOT/administrator/components/com_easyblog/includes/cache/cache.php:49314 EasyBlogCache->cacheComments() Copy JROOT/administrator/components/com_easyblog/includes/cache/cache.php:26713 EasyBlogCache->insert() Copy JROOT/administrator/components/com_easyblog/includes/formatter/types/list.php:3112 EasyBlogFormatterList->execute() Copy JROOT/administrator/components/com_easyblog/includes/formatter/formatter.php:5111 EasyBlogFormatter->execute() Copy JROOT/administrator/components/com_easyblog/includes/easyblog.php:420510 EB::formatter() Copy JROOT/components/com_easyblog/views/categories/view.html.php:2169 EasyBlogViewCategories->listings() Copy JROOT/components/com_easyblog/controllers/controller.php:1068 EasyBlogController->display() Copy JROOT/libraries/legacy/controller/legacy.php:7107 JControllerLegacy->execute() Copy JROOT/components/com_easyblog/easyblog.php:436 require_once Copy JROOT/components/com_easyblog/easyblog.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:78
クエリ時間:1.16 ms 最後のクエリの後:0.04 ms クエリメモリ:0.023 MB クエリ前のメモリ:23.932 MB 返された行:0
SELECT a.`post_id`, COUNT (1) AS `count` FROM `joom_easyblog_comment ` AS a WHERE a.`post_id` IN (3,2) AND a.`published`= '1' GROUP BY a.`post_id`クエリではEXPLAINは使用できません:SELECT a.`post_id`, COUNT(1) AS `count` FROM `joom_easyblog_comment` AS a WHERE a.`post_id` IN(3,2) AND a.`published`='1' GROUP BY a.`post_id`
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.02 ms statistics 0.06 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.03 ms
# 発信者 ファイルと行番号 18 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:169317 JDatabaseDriver->loadObjectList() Copy JROOT/administrator/components/com_easyblog/includes/utils.php:23616 EasyBlogDbJoomla->__call() Copy JROOT/administrator/components/com_easyblog/models/comment.php:61815 EasyBlogModelComment->preloadCommentCount() Copy JROOT/administrator/components/com_easyblog/includes/cache/cache.php:51914 EasyBlogCache->cacheCommentCount() Copy JROOT/administrator/components/com_easyblog/includes/cache/cache.php:27013 EasyBlogCache->insert() Copy JROOT/administrator/components/com_easyblog/includes/formatter/types/list.php:3112 EasyBlogFormatterList->execute() Copy JROOT/administrator/components/com_easyblog/includes/formatter/formatter.php:5111 EasyBlogFormatter->execute() Copy JROOT/administrator/components/com_easyblog/includes/easyblog.php:420510 EB::formatter() Copy JROOT/components/com_easyblog/views/categories/view.html.php:2169 EasyBlogViewCategories->listings() Copy JROOT/components/com_easyblog/controllers/controller.php:1068 EasyBlogController->display() Copy JROOT/libraries/legacy/controller/legacy.php:7107 JControllerLegacy->execute() Copy JROOT/components/com_easyblog/easyblog.php:436 require_once Copy JROOT/components/com_easyblog/easyblog.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:78
クエリ時間:1.26 ms 最後のクエリの後:0.04 ms クエリメモリ:0.023 MB クエリ前のメモリ:23.940 MB 返された行:2
select a.* , b.`post_id`, b.`primary` from `joom_easyblog_category ` as a inner join `joom_easyblog_post_category ` as b on a.`id` = b.`category_id` where b.`post_id` IN ( 3,2) クエリではEXPLAINは使用できません:select a.*, b.`post_id`, b.`primary` from `joom_easyblog_category` as a inner join `joom_easyblog_post_category` as b on a.`id` = b.`category_id` where b.`post_id` IN ( 3,2)
Status Duration starting 0.08 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.01 ms statistics 0.07 ms preparing 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.03 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 18 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:169317 JDatabaseDriver->loadObjectList() Copy JROOT/administrator/components/com_easyblog/includes/utils.php:23616 EasyBlogDbJoomla->__call() Copy JROOT/administrator/components/com_easyblog/models/category.php:133415 EasyBlogModelCategory->preloadByPosts() Copy JROOT/administrator/components/com_easyblog/includes/cache/cache.php:60014 EasyBlogCache->cacheCategories() Copy JROOT/administrator/components/com_easyblog/includes/cache/cache.php:27313 EasyBlogCache->insert() Copy JROOT/administrator/components/com_easyblog/includes/formatter/types/list.php:3112 EasyBlogFormatterList->execute() Copy JROOT/administrator/components/com_easyblog/includes/formatter/formatter.php:5111 EasyBlogFormatter->execute() Copy JROOT/administrator/components/com_easyblog/includes/easyblog.php:420510 EB::formatter() Copy JROOT/components/com_easyblog/views/categories/view.html.php:2169 EasyBlogViewCategories->listings() Copy JROOT/components/com_easyblog/controllers/controller.php:1068 EasyBlogController->display() Copy JROOT/libraries/legacy/controller/legacy.php:7107 JControllerLegacy->execute() Copy JROOT/components/com_easyblog/easyblog.php:436 require_once Copy JROOT/components/com_easyblog/easyblog.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:78
クエリ時間:1.72 ms 最後のクエリの後:0.71 ms クエリメモリ:0.023 MB クエリ前のメモリ:24.043 MB 返された行:0
select a.* , b.`post_id` from `joom_easyblog_tag ` as a inner join `joom_easyblog_post_tag ` as b on a.`id` = b.`tag_id` where b.`post_id` IN ( 3,2) クエリではEXPLAINは使用できません:select a.*, b.`post_id` from `joom_easyblog_tag` as a inner join `joom_easyblog_post_tag` as b on a.`id` = b.`tag_id` where b.`post_id` IN ( 3,2)
Status Duration starting 0.09 ms Executing hook on transaction 0.01 ms starting 0.02 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.07 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.03 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 18 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:169317 JDatabaseDriver->loadObjectList() Copy JROOT/administrator/components/com_easyblog/includes/utils.php:23616 EasyBlogDbJoomla->__call() Copy JROOT/administrator/components/com_easyblog/models/tags.php:83215 EasyBlogModelTags->preloadByPosts() Copy JROOT/administrator/components/com_easyblog/includes/cache/cache.php:66714 EasyBlogCache->cacheTags() Copy JROOT/administrator/components/com_easyblog/includes/cache/cache.php:27613 EasyBlogCache->insert() Copy JROOT/administrator/components/com_easyblog/includes/formatter/types/list.php:3112 EasyBlogFormatterList->execute() Copy JROOT/administrator/components/com_easyblog/includes/formatter/formatter.php:5111 EasyBlogFormatter->execute() Copy JROOT/administrator/components/com_easyblog/includes/easyblog.php:420510 EB::formatter() Copy JROOT/components/com_easyblog/views/categories/view.html.php:2169 EasyBlogViewCategories->listings() Copy JROOT/components/com_easyblog/controllers/controller.php:1068 EasyBlogController->display() Copy JROOT/libraries/legacy/controller/legacy.php:7107 JControllerLegacy->execute() Copy JROOT/components/com_easyblog/easyblog.php:436 require_once Copy JROOT/components/com_easyblog/easyblog.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:78
クエリ時間:2.77 ms 最後のクエリの後:0.53 ms クエリメモリ:0.023 MB クエリ前のメモリ:24.118 MB 返された行:2
select a.* from `joom_easyblog_revisions ` as a where a.`id` IN ( 14,13) クエリではEXPLAINは使用できません:select a.* from `joom_easyblog_revisions` as a where a.`id` IN ( 14,13)
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.04 ms preparing 0.02 ms executing 0.05 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
# 発信者 ファイルと行番号 18 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:169317 JDatabaseDriver->loadObjectList() Copy JROOT/administrator/components/com_easyblog/includes/utils.php:23616 EasyBlogDbJoomla->__call() Copy JROOT/administrator/components/com_easyblog/models/revisions.php:55815 EasyBlogModelRevisions->preload() Copy JROOT/administrator/components/com_easyblog/includes/cache/cache.php:57614 EasyBlogCache->cacheRevisions() Copy JROOT/administrator/components/com_easyblog/includes/cache/cache.php:27913 EasyBlogCache->insert() Copy JROOT/administrator/components/com_easyblog/includes/formatter/types/list.php:3112 EasyBlogFormatterList->execute() Copy JROOT/administrator/components/com_easyblog/includes/formatter/formatter.php:5111 EasyBlogFormatter->execute() Copy JROOT/administrator/components/com_easyblog/includes/easyblog.php:420510 EB::formatter() Copy JROOT/components/com_easyblog/views/categories/view.html.php:2169 EasyBlogViewCategories->listings() Copy JROOT/components/com_easyblog/controllers/controller.php:1068 EasyBlogController->display() Copy JROOT/libraries/legacy/controller/legacy.php:7107 JControllerLegacy->execute() Copy JROOT/components/com_easyblog/easyblog.php:436 require_once Copy JROOT/components/com_easyblog/easyblog.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:78
クエリ時間:1.24 ms 最後のクエリの後:0.55 ms クエリメモリ:0.024 MB クエリ前のメモリ:24.205 MB 返された行:1
select u.* , e.`id` as `eb_id`, e.`nickname`, e.`avatar`, e.`description`, e.`url`, e.`params` as `eb_params`, e.`published` as `eb_published`, e.`title` as `eb_title`, e.`biography`, e.`permalink`, e.`custom_css` from `joom_users ` as u left join `joom_easyblog_users ` as e ON u.`id` = e.`id` where u.`id` = 1621309 クエリではEXPLAINは使用できません:select u.*, e.`id` as `eb_id`, e.`nickname`, e.`avatar`, e.`description`, e.`url`, e.`params` as `eb_params`, e.`published` as `eb_published`, e.`title` as `eb_title`, e.`biography`, e.`permalink`, e.`custom_css` from `joom_users` as u left join `joom_easyblog_users` as e ON u.`id` = e.`id` where u.`id` = 1621309
Status Duration starting 0.07 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.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.03 ms
# 発信者 ファイルと行番号 21 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:169320 JDatabaseDriver->loadObjectList() Copy JROOT/administrator/components/com_easyblog/includes/utils.php:23619 EasyBlogDbJoomla->__call() Copy JROOT/administrator/components/com_easyblog/models/users.php:30018 EasyBlogModelUsers->getUsersMeta() Copy JROOT/administrator/components/com_easyblog/includes/user/user.php:19317 EasyBlogUser::loadUsers() Copy JROOT/administrator/components/com_easyblog/includes/user/user.php:8516 EasyBlogUser::factory() Copy JROOT/administrator/components/com_easyblog/includes/easyblog.php:89515 EB::user() Copy JROOT/administrator/components/com_easyblog/includes/cache/cache.php:64814 EasyBlogCache->cacheAuthors() Copy JROOT/administrator/components/com_easyblog/includes/cache/cache.php:28213 EasyBlogCache->insert() Copy JROOT/administrator/components/com_easyblog/includes/formatter/types/list.php:3112 EasyBlogFormatterList->execute() Copy JROOT/administrator/components/com_easyblog/includes/formatter/formatter.php:5111 EasyBlogFormatter->execute() Copy JROOT/administrator/components/com_easyblog/includes/easyblog.php:420510 EB::formatter() Copy JROOT/components/com_easyblog/views/categories/view.html.php:2169 EasyBlogViewCategories->listings() Copy JROOT/components/com_easyblog/controllers/controller.php:1068 EasyBlogController->display() Copy JROOT/libraries/legacy/controller/legacy.php:7107 JControllerLegacy->execute() Copy JROOT/components/com_easyblog/easyblog.php:436 require_once Copy JROOT/components/com_easyblog/easyblog.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:78
クエリ時間:1.19 ms 最後のクエリの後:0.49 ms クエリメモリ:0.026 MB クエリ前のメモリ:24.275 MB 返された行:1
SELECT *
FROM `joom_users `
WHERE `id` = 1621309クエリではEXPLAINは使用できません:SELECT *
FROM `joom_users`
WHERE `id` = 1621309
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.08 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.05 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
# 発信者 ファイルと行番号 25 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:145724 JDatabaseDriver->loadAssoc() Copy JROOT/libraries/joomla/table/user.php:10923 JTableUser->loadUserData() Copy JROOT/libraries/joomla/table/user.php:8022 JTableUser->load() Copy JROOT/libraries/joomla/user/user.php:93721 JUser->load() Copy JROOT/libraries/joomla/user/user.php:24420 JUser->__construct() Copy JROOT/libraries/joomla/user/user.php:29719 JUser::getInstance() Copy JROOT/libraries/joomla/factory.php:27118 JFactory::getUser() Copy JROOT/administrator/components/com_easyblog/includes/user/user.php:23817 EasyBlogUser::loadUsers() Copy JROOT/administrator/components/com_easyblog/includes/user/user.php:8516 EasyBlogUser::factory() Copy JROOT/administrator/components/com_easyblog/includes/easyblog.php:89515 EB::user() Copy JROOT/administrator/components/com_easyblog/includes/cache/cache.php:64814 EasyBlogCache->cacheAuthors() Copy JROOT/administrator/components/com_easyblog/includes/cache/cache.php:28213 EasyBlogCache->insert() Copy JROOT/administrator/components/com_easyblog/includes/formatter/types/list.php:3112 EasyBlogFormatterList->execute() Copy JROOT/administrator/components/com_easyblog/includes/formatter/formatter.php:5111 EasyBlogFormatter->execute() Copy JROOT/administrator/components/com_easyblog/includes/easyblog.php:420510 EB::formatter() Copy JROOT/components/com_easyblog/views/categories/view.html.php:2169 EasyBlogViewCategories->listings() Copy JROOT/components/com_easyblog/controllers/controller.php:1068 EasyBlogController->display() Copy JROOT/libraries/legacy/controller/legacy.php:7107 JControllerLegacy->execute() Copy JROOT/components/com_easyblog/easyblog.php:436 require_once Copy JROOT/components/com_easyblog/easyblog.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:78
クエリ時間:1.81 ms 最後のクエリの後:2.09 ms クエリメモリ:0.026 MB クエリ前のメモリ:24.806 MB 返された行:2
SELECT `g`.`id`,`g`.`title`
FROM `joom_usergroups ` AS g
INNER JOIN `joom_user_usergroup_map ` AS m ON m.group_id = g.id
WHERE `m`.`user_id` = 1621309クエリではEXPLAINは使用できません:SELECT `g`.`id`,`g`.`title`
FROM `joom_usergroups` AS g
INNER JOIN `joom_user_usergroup_map` AS m ON m.group_id = g.id
WHERE `m`.`user_id` = 1621309
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.01 ms Opening tables 0.07 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.10 ms preparing 0.02 ms executing 0.48 ms end 0.02 ms query end 0.03 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.04 ms
# 発信者 ファイルと行番号 25 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:149824 JDatabaseDriver->loadAssocList() Copy JROOT/libraries/joomla/table/user.php:12423 JTableUser->loadUsergroups() Copy JROOT/libraries/joomla/table/user.php:9622 JTableUser->load() Copy JROOT/libraries/joomla/user/user.php:93721 JUser->load() Copy JROOT/libraries/joomla/user/user.php:24420 JUser->__construct() Copy JROOT/libraries/joomla/user/user.php:29719 JUser::getInstance() Copy JROOT/libraries/joomla/factory.php:27118 JFactory::getUser() Copy JROOT/administrator/components/com_easyblog/includes/user/user.php:23817 EasyBlogUser::loadUsers() Copy JROOT/administrator/components/com_easyblog/includes/user/user.php:8516 EasyBlogUser::factory() Copy JROOT/administrator/components/com_easyblog/includes/easyblog.php:89515 EB::user() Copy JROOT/administrator/components/com_easyblog/includes/cache/cache.php:64814 EasyBlogCache->cacheAuthors() Copy JROOT/administrator/components/com_easyblog/includes/cache/cache.php:28213 EasyBlogCache->insert() Copy JROOT/administrator/components/com_easyblog/includes/formatter/types/list.php:3112 EasyBlogFormatterList->execute() Copy JROOT/administrator/components/com_easyblog/includes/formatter/formatter.php:5111 EasyBlogFormatter->execute() Copy JROOT/administrator/components/com_easyblog/includes/easyblog.php:420510 EB::formatter() Copy JROOT/components/com_easyblog/views/categories/view.html.php:2169 EasyBlogViewCategories->listings() Copy JROOT/components/com_easyblog/controllers/controller.php:1068 EasyBlogController->display() Copy JROOT/libraries/legacy/controller/legacy.php:7107 JControllerLegacy->execute() Copy JROOT/components/com_easyblog/easyblog.php:436 require_once Copy JROOT/components/com_easyblog/easyblog.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:78
クエリ時間:2.24 ms 最後のクエリの後:0.42 ms クエリメモリ:0.023 MB クエリ前のメモリ:24.974 MB 返された行:0
select `a`.`id` as `cat_fg_id`, `a`.`category_id` as `cat_fg_category_id`, `a`.`group_id` as `cat_fg_group_id`, `fg`.`id` as `fg_id`, `fg`.`title` as `fg_title`, `fg`.`description` as `fg_description`, `fg`.`created` as `fg_created`, `fg`.`state` as `fg_state`, `fg`.`read` as `fg_read`, `fg`.`write` as `fg_write`, `fg`.`params` as `fg_params`, `f`.`id` as `f_id`, `f`.`group_id` as `f_group_id`, `f`.`title` as `f_title`, `f`.`help` as `f_help`, `f`.`state` as `f_state`, `f`.`required` as `f_required`, `f`.`type` as `f_type`, `f`.`params` as `f_params`, `f`.`created` as `f_created`, `f`.`options` as `f_options`, `fv`.`id` as `fv_id`, `fv`.`field_id` as `fv_field_id`, `fv`.`post_id` as `fv_post_id`, `fv`.`value` as `fv_value` from `joom_easyblog_category_fields_groups ` as a inner join `joom_easyblog_post_category ` as p on `a`.`category_id` = `p`.`category_id` inner join `joom_easyblog_fields_groups ` as fg on `a`.`group_id` = `fg`.`id` inner join `joom_easyblog_fields ` as f on `fg`.`id` = `f`.`group_id` left join `joom_easyblog_fields_values ` as fv on `fv`.`field_id` = `f`.`id` and `fv`.`post_id` = `p`.`post_id` where p.post_id IN (3,2) クエリではEXPLAINは使用できません:select `a`.`id` as `cat_fg_id`, `a`.`category_id` as `cat_fg_category_id`, `a`.`group_id` as `cat_fg_group_id`, `fg`.`id` as `fg_id`, `fg`.`title` as `fg_title`, `fg`.`description` as `fg_description`, `fg`.`created` as `fg_created`, `fg`.`state` as `fg_state`, `fg`.`read` as `fg_read`, `fg`.`write` as `fg_write`, `fg`.`params` as `fg_params`, `f`.`id` as `f_id`, `f`.`group_id` as `f_group_id`, `f`.`title` as `f_title`, `f`.`help` as `f_help`, `f`.`state` as `f_state`, `f`.`required` as `f_required`, `f`.`type` as `f_type`, `f`.`params` as `f_params`, `f`.`created` as `f_created`, `f`.`options` as `f_options`, `fv`.`id` as `fv_id`, `fv`.`field_id` as `fv_field_id`, `fv`.`post_id` as `fv_post_id`, `fv`.`value` as `fv_value` from `joom_easyblog_category_fields_groups` as a inner join `joom_easyblog_post_category` as p on `a`.`category_id` = `p`.`category_id` inner join `joom_easyblog_fields_groups` as fg on `a`.`group_id` = `fg`.`id` inner join `joom_easyblog_fields` as f on `fg`.`id` = `f`.`group_id` left join `joom_easyblog_fields_values` as fv on `fv`.`field_id` = `f`.`id` and `fv`.`post_id` = `p`.`post_id` where p.post_id IN (3,2)
Status Duration starting 0.16 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.01 ms Opening tables 0.11 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.13 ms preparing 0.69 ms executing 0.11 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.02 ms closing tables 0.02 ms freeing items 0.06 ms cleaning up 0.04 ms
# 発信者 ファイルと行番号 18 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:169317 JDatabaseDriver->loadObjectList() Copy JROOT/administrator/components/com_easyblog/includes/utils.php:23616 EasyBlogDbJoomla->__call() Copy JROOT/administrator/components/com_easyblog/models/fields.php:29815 EasyBlogModelFields->preloadFields() Copy JROOT/administrator/components/com_easyblog/includes/cache/cache.php:37414 EasyBlogCache->cacheFields() Copy JROOT/administrator/components/com_easyblog/includes/cache/cache.php:28513 EasyBlogCache->insert() Copy JROOT/administrator/components/com_easyblog/includes/formatter/types/list.php:3112 EasyBlogFormatterList->execute() Copy JROOT/administrator/components/com_easyblog/includes/formatter/formatter.php:5111 EasyBlogFormatter->execute() Copy JROOT/administrator/components/com_easyblog/includes/easyblog.php:420510 EB::formatter() Copy JROOT/components/com_easyblog/views/categories/view.html.php:2169 EasyBlogViewCategories->listings() Copy JROOT/components/com_easyblog/controllers/controller.php:1068 EasyBlogController->display() Copy JROOT/libraries/legacy/controller/legacy.php:7107 JControllerLegacy->execute() Copy JROOT/components/com_easyblog/easyblog.php:436 require_once Copy JROOT/components/com_easyblog/easyblog.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:78
クエリ時間:1.81 ms 最後のクエリの後:0.32 ms クエリメモリ:0.023 MB クエリ前のメモリ:25.029 MB 返された行:2
select * from `joom_easyblog_meta ` where `content_id` in (3,2) and `type` = 'post' クエリではEXPLAINは使用できません:select * from `joom_easyblog_meta` where `content_id` in (3,2) and `type` = 'post'
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.05 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.07 ms preparing 0.02 ms executing 0.08 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
# 発信者 ファイルと行番号 18 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:169317 JDatabaseDriver->loadObjectList() Copy JROOT/administrator/components/com_easyblog/includes/utils.php:23616 EasyBlogDbJoomla->__call() Copy JROOT/administrator/components/com_easyblog/models/metas.php:38615 EasyBlogModelMetas->preloadPostMetas() Copy JROOT/administrator/components/com_easyblog/includes/cache/cache.php:30314 EasyBlogCache->cacheMetas() Copy JROOT/administrator/components/com_easyblog/includes/cache/cache.php:28813 EasyBlogCache->insert() Copy JROOT/administrator/components/com_easyblog/includes/formatter/types/list.php:3112 EasyBlogFormatterList->execute() Copy JROOT/administrator/components/com_easyblog/includes/formatter/formatter.php:5111 EasyBlogFormatter->execute() Copy JROOT/administrator/components/com_easyblog/includes/easyblog.php:420510 EB::formatter() Copy JROOT/components/com_easyblog/views/categories/view.html.php:2169 EasyBlogViewCategories->listings() Copy JROOT/components/com_easyblog/controllers/controller.php:1068 EasyBlogController->display() Copy JROOT/libraries/legacy/controller/legacy.php:7107 JControllerLegacy->execute() Copy JROOT/components/com_easyblog/easyblog.php:436 require_once Copy JROOT/components/com_easyblog/easyblog.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:78
クエリ時間:1.22 ms 最後のクエリの後:0.29 ms クエリメモリ:0.023 MB クエリ前のメモリ:25.075 MB 返された行:0
SELECT * FROM `joom_easyblog_featured ` WHERE `content_id` IN (3,2) AND `type`= 'post'クエリではEXPLAINは使用できません:SELECT * FROM `joom_easyblog_featured` WHERE `content_id` IN(3,2) AND `type`='post'
Status Duration starting 0.08 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.02 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.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.03 ms
# 発信者 ファイルと行番号 17 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:169316 JDatabaseDriver->loadObjectList() Copy JROOT/administrator/components/com_easyblog/includes/utils.php:23615 EasyBlogDbJoomla->__call() Copy JROOT/administrator/components/com_easyblog/models/featured.php:25314 EasyBlogModelFeatured->preload() Copy JROOT/administrator/components/com_easyblog/includes/formatter/types/standard.php:16513 EasyBlogFormatterStandard->preloadFeaturedItems() Copy JROOT/administrator/components/com_easyblog/includes/formatter/types/list.php:3912 EasyBlogFormatterList->execute() Copy JROOT/administrator/components/com_easyblog/includes/formatter/formatter.php:5111 EasyBlogFormatter->execute() Copy JROOT/administrator/components/com_easyblog/includes/easyblog.php:420510 EB::formatter() Copy JROOT/components/com_easyblog/views/categories/view.html.php:2169 EasyBlogViewCategories->listings() Copy JROOT/components/com_easyblog/controllers/controller.php:1068 EasyBlogController->display() Copy JROOT/libraries/legacy/controller/legacy.php:7107 JControllerLegacy->execute() Copy JROOT/components/com_easyblog/easyblog.php:436 require_once Copy JROOT/components/com_easyblog/easyblog.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:78
クエリ時間:1.10 ms 最後のクエリの後:0.12 ms クエリメモリ:0.023 MB クエリ前のメモリ:25.100 MB 返された行:0
SELECT `group_id` FROM `joom_easyblog_category_fields_groups ` WHERE `category_id`= '1'クエリではEXPLAINは使用できません:SELECT `group_id` FROM `joom_easyblog_category_fields_groups` WHERE `category_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.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.03 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 18 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:173217 JDatabaseDriver->loadResult() Copy JROOT/administrator/components/com_easyblog/includes/utils.php:23616 EasyBlogDbJoomla->__call() Copy JROOT/administrator/components/com_easyblog/models/categories.php:5315 EasyBlogModelCategories->getCustomFieldGroup() Copy JROOT/administrator/components/com_easyblog/tables/category.php:101314 EasyBlogTableCategory->getCustomFields() Copy JROOT/administrator/components/com_easyblog/includes/post/post.php:525013 EasyBlogPost->getCustomFields() Copy JROOT/administrator/components/com_easyblog/includes/formatter/types/list.php:7112 EasyBlogFormatterList->execute() Copy JROOT/administrator/components/com_easyblog/includes/formatter/formatter.php:5111 EasyBlogFormatter->execute() Copy JROOT/administrator/components/com_easyblog/includes/easyblog.php:420510 EB::formatter() Copy JROOT/components/com_easyblog/views/categories/view.html.php:2169 EasyBlogViewCategories->listings() Copy JROOT/components/com_easyblog/controllers/controller.php:1068 EasyBlogController->display() Copy JROOT/libraries/legacy/controller/legacy.php:7107 JControllerLegacy->execute() Copy JROOT/components/com_easyblog/easyblog.php:436 require_once Copy JROOT/components/com_easyblog/easyblog.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:78
クエリ時間:1.18 ms 最後のクエリの後:0.17 ms クエリメモリ:0.023 MB クエリ前のメモリ:25.122 MB 返された行:0
SELECT a.* FROM `joom_easyblog_fields ` AS a INNER JOIN `joom_easyblog_category_fields_groups ` AS b ON a.`group_id`= b.`group_id` WHERE b.`category_id`= '1' AND a.`state`= '1'クエリではEXPLAINは使用できません:SELECT a.* FROM `joom_easyblog_fields` AS a INNER JOIN `joom_easyblog_category_fields_groups` AS b ON a.`group_id`= b.`group_id` WHERE b.`category_id`='1' AND a.`state`='1'
Status Duration starting 0.08 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.04 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.06 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.03 ms cleaning up 0.03 ms
# 発信者 ファイルと行番号 18 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:169317 JDatabaseDriver->loadObjectList() Copy JROOT/administrator/components/com_easyblog/includes/utils.php:23616 EasyBlogDbJoomla->__call() Copy JROOT/administrator/components/com_easyblog/models/categories.php:8115 EasyBlogModelCategories->getCustomFields() Copy JROOT/administrator/components/com_easyblog/tables/category.php:101414 EasyBlogTableCategory->getCustomFields() Copy JROOT/administrator/components/com_easyblog/includes/post/post.php:525013 EasyBlogPost->getCustomFields() Copy JROOT/administrator/components/com_easyblog/includes/formatter/types/list.php:7112 EasyBlogFormatterList->execute() Copy JROOT/administrator/components/com_easyblog/includes/formatter/formatter.php:5111 EasyBlogFormatter->execute() Copy JROOT/administrator/components/com_easyblog/includes/easyblog.php:420510 EB::formatter() Copy JROOT/components/com_easyblog/views/categories/view.html.php:2169 EasyBlogViewCategories->listings() Copy JROOT/components/com_easyblog/controllers/controller.php:1068 EasyBlogController->display() Copy JROOT/libraries/legacy/controller/legacy.php:7107 JControllerLegacy->execute() Copy JROOT/components/com_easyblog/easyblog.php:436 require_once Copy JROOT/components/com_easyblog/easyblog.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:78
クエリ時間:1.14 ms 最後のクエリの後:0.15 ms クエリメモリ:0.021 MB クエリ前のメモリ:25.145 MB 返された行:0
SELECT `id` FROM `joom_easyblog_subscriptions ` WHERE `uid` = '1' AND `utype` = 'category' AND `email` = ''クエリではEXPLAINは使用できません:SELECT `id` FROM `joom_easyblog_subscriptions` WHERE `uid` = '1' AND `utype` = 'category' AND `email` = ''
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.08 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.03 ms cleaning up 0.03 ms
# 発信者 ファイルと行番号 13 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:173212 JDatabaseDriver->loadResult() Copy JROOT/administrator/components/com_easyblog/includes/utils.php:23611 EasyBlogDbJoomla->__call() Copy JROOT/administrator/components/com_easyblog/models/category.php:122910 EasyBlogModelCategory->isCategorySubscribedEmail() Copy JROOT/components/com_easyblog/views/categories/view.html.php:2209 EasyBlogViewCategories->listings() Copy JROOT/components/com_easyblog/controllers/controller.php:1068 EasyBlogController->display() Copy JROOT/libraries/legacy/controller/legacy.php:7107 JControllerLegacy->execute() Copy JROOT/components/com_easyblog/easyblog.php:436 require_once Copy JROOT/components/com_easyblog/easyblog.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:78
クエリ時間:1.36 ms 最後のクエリの後:9.61 ms クエリメモリ:0.023 MB クエリ前のメモリ:26.205 MB 返された行:1
SELECT `template` FROM `joom_template_styles ` WHERE `home`= '1' AND `client_id`= '0'クエリではEXPLAINは使用できません:SELECT `template` FROM `joom_template_styles` WHERE `home`='1' AND `client_id`='0'
Status Duration starting 0.20 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.07 ms preparing 0.03 ms executing 0.05 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
# 発信者 ファイルと行番号 17 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:173216 JDatabaseDriver->loadResult() Copy JROOT/administrator/components/com_easyblog/includes/utils.php:23615 EasyBlogDbJoomla->__call() Copy JROOT/administrator/components/com_easyblog/models/themes.php:4614 EasyBlogModelThemes->getDefaultJoomlaTemplate() Copy JROOT/administrator/components/com_easyblog/includes/easyblog.php:249313 EB::getCurrentTemplate() Copy JROOT/administrator/components/com_easyblog/includes/themes/themes.php:22212 EasyBlogThemes->resolve() Copy JROOT/administrator/components/com_easyblog/includes/themes/themes.php:42911 EasyBlogThemes->output() Copy JROOT/components/com_easyblog/views/views.php:16410 EasyBlogView->display() Copy JROOT/components/com_easyblog/views/categories/view.html.php:2539 EasyBlogViewCategories->listings() Copy JROOT/components/com_easyblog/controllers/controller.php:1068 EasyBlogController->display() Copy JROOT/libraries/legacy/controller/legacy.php:7107 JControllerLegacy->execute() Copy JROOT/components/com_easyblog/easyblog.php:436 require_once Copy JROOT/components/com_easyblog/easyblog.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:78
クエリ時間:2.69 ms 最後のクエリの後:0.92 ms クエリメモリ:0.026 MB クエリ前のメモリ:26.343 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-10-17 04:42:23') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-10-17 04:42:23') AND m.access IN (1,1) AND m.client_id = 0 AND (mm.menuid = 618 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-10-17 04:42:23') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-10-17 04:42:23') AND m.access IN (1,1) AND m.client_id = 0 AND (mm.menuid = 618 OR mm.menuid <= 0) AND m.language IN ('ja-JA','*')
ORDER BY m.position, m.ordering
Status Duration starting 0.15 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.09 ms init 0.01 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.13 ms preparing 0.05 ms executing 1.13 ms end 0.02 ms query end 0.01 ms waiting for handler commit 0.02 ms closing tables 0.02 ms freeing items 0.05 ms cleaning up 0.02 ms
# 発信者 ファイルと行番号 19 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:169318 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/joomla/cache/controller/callback.php:16917 JCacheControllerCallback->get() Copy JROOT/libraries/cms/module/helper.php:42416 JModuleHelper::getModuleList() Copy JROOT/libraries/cms/module/helper.php:36015 JModuleHelper::load() Copy JROOT/libraries/cms/module/helper.php:8414 JModuleHelper::getModules() Copy JROOT/administrator/components/com_easyblog/includes/easyblog.php:212413 EB::renderModule() Copy JROOT/components/com_easyblog/themes/wireframe/blogs/categories/item.php:7112 include Copy JROOT/components/com_easyblog/themes/wireframe/blogs/categories/item.php Copy JROOT/administrator/components/com_easyblog/includes/themes/themes.php:44511 EasyBlogThemes->output() Copy JROOT/components/com_easyblog/views/views.php:16410 EasyBlogView->display() Copy JROOT/components/com_easyblog/views/categories/view.html.php:2539 EasyBlogViewCategories->listings() Copy JROOT/components/com_easyblog/controllers/controller.php:1068 EasyBlogController->display() Copy JROOT/libraries/legacy/controller/legacy.php:7107 JControllerLegacy->execute() Copy JROOT/components/com_easyblog/easyblog.php:436 require_once Copy JROOT/components/com_easyblog/easyblog.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:78
クエリ時間:1.65 ms 最後のクエリの後:8.20 ms クエリメモリ:0.028 MB クエリ前のメモリ:27.206 MB 返された行:0
SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state
FROM joom_fields AS a
LEFT JOIN `joom_languages ` AS l ON l.lang_code = a.language
LEFT JOIN joom_users AS uc ON uc.id= a.checked_out
LEFT JOIN joom_viewlevels AS ag ON ag.id = a.access
LEFT JOIN joom_users AS ua ON ua.id = a.created_user_id
LEFT JOIN joom_fields_groups AS g ON g.id = a.group_id
LEFT JOIN `joom_fields_categories ` AS fc ON fc.field_id = a.id
WHERE a.context = 'easyblog.blog' AND (fc.category_id IS NULL OR fc.category_id IN (1,0)) AND a.access IN (1,1) AND (a.group_id = 0 OR g.access IN (1,1)) AND a.state = 1 AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering ASC クエリではEXPLAINは使用できません:SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state
FROM joom_fields AS a
LEFT JOIN `joom_languages` AS l ON l.lang_code = a.language
LEFT JOIN joom_users AS uc ON uc.id=a.checked_out
LEFT JOIN joom_viewlevels AS ag ON ag.id = a.access
LEFT JOIN joom_users AS ua ON ua.id = a.created_user_id
LEFT JOIN joom_fields_groups AS g ON g.id = a.group_id
LEFT JOIN `joom_fields_categories` AS fc ON fc.field_id = a.id
WHERE a.context = 'easyblog.blog' AND (fc.category_id IS NULL OR fc.category_id IN (1,0)) AND a.access IN (1,1) AND (a.group_id = 0 OR g.access IN (1,1)) AND a.state = 1 AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering ASC
Status Duration starting 0.19 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.11 ms init 0.01 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.16 ms preparing 0.06 ms executing 0.05 ms end 0.03 ms query end 0.01 ms waiting for handler commit 0.01 ms closing tables 0.02 ms freeing items 0.05 ms cleaning up 0.03 ms
# 発信者 ファイルと行番号 28 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:169327 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/legacy/model/legacy.php:30726 JModelLegacy->_getList() Copy JROOT/administrator/components/com_fields/models/fields.php:32625 FieldsModelFields->_getList() Copy JROOT/libraries/legacy/model/list.php:18924 JModelList->getItems() Copy JROOT/administrator/components/com_fields/helpers/fields.php:13423 FieldsHelper::getFields() Copy JROOT/plugins/system/fields/fields.php:37822 PlgSystemFields->onContentPrepare() 以下の行の呼び出しと同じです。 21 ReflectionMethod->invokeArgs() Copy JROOT/libraries/tovuti/Helpers/MethodHelper.php:5820 Tovuti\Helpers\MethodHelper::call() Copy JROOT/libraries/joomla/event/event.php:7219 JEvent->update() Copy JROOT/libraries/joomla/event/dispatcher.php:16018 JEventDispatcher->trigger() Copy JROOT/administrator/components/com_easyblog/includes/triggers/triggers.php:4317 EasyBlogTriggers->trigger() Copy JROOT/administrator/components/com_easyblog/includes/post/post.php:397416 EasyBlogPost->prepareContent() Copy JROOT/administrator/components/com_easyblog/includes/post/post.php:365915 EasyBlogPost->getIntro() Copy JROOT/components/com_easyblog/themes/wireframe/blogs/latest/default.main.php:15714 include Copy JROOT/components/com_easyblog/themes/wireframe/blogs/latest/default.main.php Copy JROOT/administrator/components/com_easyblog/includes/themes/themes.php:44513 EasyBlogThemes->output() Copy JROOT/components/com_easyblog/themes/wireframe/blogs/categories/item.php:9812 include Copy JROOT/components/com_easyblog/themes/wireframe/blogs/categories/item.php Copy JROOT/administrator/components/com_easyblog/includes/themes/themes.php:44511 EasyBlogThemes->output() Copy JROOT/components/com_easyblog/views/views.php:16410 EasyBlogView->display() Copy JROOT/components/com_easyblog/views/categories/view.html.php:2539 EasyBlogViewCategories->listings() Copy JROOT/components/com_easyblog/controllers/controller.php:1068 EasyBlogController->display() Copy JROOT/libraries/legacy/controller/legacy.php:7107 JControllerLegacy->execute() Copy JROOT/components/com_easyblog/easyblog.php:436 require_once Copy JROOT/components/com_easyblog/easyblog.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:78
クエリ時間:1.34 ms 最後のクエリの後:4.66 ms クエリメモリ:0.025 MB クエリ前のメモリ:27.688 MB 返された行:0
SELECT a.* FROM `joom_easyblog_comment ` a INNER JOIN joom_users AS c ON a.`created_by` = c.`id` WHERE a.`post_id` = '3' AND a.`published` = 1 ORDER BY a.`lft` asc LIMIT 3クエリではEXPLAINは使用できません:SELECT a.* FROM `joom_easyblog_comment` a INNER JOIN joom_users AS c ON a.`created_by` = c.`id` WHERE a.`post_id` = '3' AND a.`published` = 1 ORDER BY a.`lft` asc LIMIT 3
Status Duration starting 0.08 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.01 ms statistics 0.07 ms preparing 0.04 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
# 発信者 ファイルと行番号 22 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:169321 JDatabaseDriver->loadObjectList() Copy JROOT/administrator/components/com_easyblog/includes/utils.php:23620 EasyBlogDbJoomla->__call() Copy JROOT/administrator/components/com_easyblog/models/blog.php:15519 EasyBlogModelBlog->getBlogComment() Copy JROOT/administrator/components/com_easyblog/includes/comment/comment.php:30618 EasyBlogComment->getPreviewBlogComment() Copy JROOT/administrator/components/com_easyblog/includes/post/post.php:342717 EasyBlogPost->getPreviewComments() Copy JROOT/components/com_easyblog/themes/wireframe/blogs/latest/part.comments.php:1416 include Copy JROOT/components/com_easyblog/themes/wireframe/blogs/latest/part.comments.php Copy JROOT/administrator/components/com_easyblog/includes/themes/themes.php:44515 EasyBlogThemes->output() Copy JROOT/components/com_easyblog/themes/wireframe/blogs/latest/default.main.php:19614 include Copy JROOT/components/com_easyblog/themes/wireframe/blogs/latest/default.main.php Copy JROOT/administrator/components/com_easyblog/includes/themes/themes.php:44513 EasyBlogThemes->output() Copy JROOT/components/com_easyblog/themes/wireframe/blogs/categories/item.php:9812 include Copy JROOT/components/com_easyblog/themes/wireframe/blogs/categories/item.php Copy JROOT/administrator/components/com_easyblog/includes/themes/themes.php:44511 EasyBlogThemes->output() Copy JROOT/components/com_easyblog/views/views.php:16410 EasyBlogView->display() Copy JROOT/components/com_easyblog/views/categories/view.html.php:2539 EasyBlogViewCategories->listings() Copy JROOT/components/com_easyblog/controllers/controller.php:1068 EasyBlogController->display() Copy JROOT/libraries/legacy/controller/legacy.php:7107 JControllerLegacy->execute() Copy JROOT/components/com_easyblog/easyblog.php:436 require_once Copy JROOT/components/com_easyblog/easyblog.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:78
クエリ時間:1.31 ms 最後のクエリの後:2.27 ms クエリメモリ:0.025 MB クエリ前のメモリ:27.702 MB 返された行:0
SELECT a.* FROM `joom_easyblog_comment ` a INNER JOIN joom_users AS c ON a.`created_by` = c.`id` WHERE a.`post_id` = '2' AND a.`published` = 1 ORDER BY a.`lft` asc LIMIT 3クエリではEXPLAINは使用できません:SELECT a.* FROM `joom_easyblog_comment` a INNER JOIN joom_users AS c ON a.`created_by` = c.`id` WHERE a.`post_id` = '2' AND a.`published` = 1 ORDER BY a.`lft` asc LIMIT 3
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.06 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.09 ms preparing 0.04 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.03 ms
# 発信者 ファイルと行番号 22 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:169321 JDatabaseDriver->loadObjectList() Copy JROOT/administrator/components/com_easyblog/includes/utils.php:23620 EasyBlogDbJoomla->__call() Copy JROOT/administrator/components/com_easyblog/models/blog.php:15519 EasyBlogModelBlog->getBlogComment() Copy JROOT/administrator/components/com_easyblog/includes/comment/comment.php:30618 EasyBlogComment->getPreviewBlogComment() Copy JROOT/administrator/components/com_easyblog/includes/post/post.php:342717 EasyBlogPost->getPreviewComments() Copy JROOT/components/com_easyblog/themes/wireframe/blogs/latest/part.comments.php:1416 include Copy JROOT/components/com_easyblog/themes/wireframe/blogs/latest/part.comments.php Copy JROOT/administrator/components/com_easyblog/includes/themes/themes.php:44515 EasyBlogThemes->output() Copy JROOT/components/com_easyblog/themes/wireframe/blogs/latest/default.main.php:19614 include Copy JROOT/components/com_easyblog/themes/wireframe/blogs/latest/default.main.php Copy JROOT/administrator/components/com_easyblog/includes/themes/themes.php:44513 EasyBlogThemes->output() Copy JROOT/components/com_easyblog/themes/wireframe/blogs/categories/item.php:9812 include Copy JROOT/components/com_easyblog/themes/wireframe/blogs/categories/item.php Copy JROOT/administrator/components/com_easyblog/includes/themes/themes.php:44511 EasyBlogThemes->output() Copy JROOT/components/com_easyblog/views/views.php:16410 EasyBlogView->display() Copy JROOT/components/com_easyblog/views/categories/view.html.php:2539 EasyBlogViewCategories->listings() Copy JROOT/components/com_easyblog/controllers/controller.php:1068 EasyBlogController->display() Copy JROOT/libraries/legacy/controller/legacy.php:7107 JControllerLegacy->execute() Copy JROOT/components/com_easyblog/easyblog.php:436 require_once Copy JROOT/components/com_easyblog/easyblog.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:78
クエリ時間:1.62 ms 最後のクエリの後:4.66 ms クエリメモリ:0.021 MB クエリ前のメモリ:27.838 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.09 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.06 ms preparing 0.02 ms executing 0.38 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.03 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:7419 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:78
クエリ時間:1.14 ms 最後のクエリの後:16.02 ms クエリメモリ:0.021 MB クエリ前のメモリ:28.324 MB 返された行:10
SELECT * FROM axs_fonts WHERE enabled = 1クエリではEXPLAINは使用できません:SELECT * FROM axs_fonts WHERE enabled = 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.02 ms preparing 0.02 ms executing 0.06 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.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:1808 include Copy JROOT/templates/axs/home.php Copy JROOT/templates/axs/index.php:807 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:78
クエリ時間:1.11 ms 最後のクエリの後:0.20 ms クエリメモリ:0.021 MB クエリ前のメモリ:28.359 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.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.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.03 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:8818 include Copy JROOT/templates/axs/home.php Copy JROOT/templates/axs/index.php:807 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:78
クエリ時間:1.28 ms 最後のクエリの後:1.61 ms クエリメモリ:0.021 MB クエリ前のメモリ:28.412 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.12 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.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
# 発信者 ファイルと行番号 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:18708 include Copy JROOT/templates/axs/home.php Copy JROOT/templates/axs/index.php:807 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:78
クエリ時間:1.11 ms 最後のクエリの後:0.70 ms クエリメモリ:0.022 MB クエリ前のメモリ:28.307 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.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
# 発信者 ファイルと行番号 14 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:165413 JDatabaseDriver->loadObject() Copy JROOT/libraries/axslibs/language.php:42712 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:78
クエリ時間:1.30 ms 最後のクエリの後:6.02 ms クエリメモリ:0.027 MB クエリ前のメモリ:28.637 MB 返された行:1
SELECT * FROM joom_kunena_configuration WHERE id= 1クエリではEXPLAINは使用できません:SELECT * FROM joom_kunena_configuration WHERE id=1
Status Duration starting 0.09 ms Executing hook on transaction 0.01 ms starting 0.02 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 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.03 ms
# 発信者 ファイルと行番号 27 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:145726 JDatabaseDriver->loadAssoc() Copy JROOT/libraries/kunena/config.php:130625 KunenaConfig->load() Copy JROOT/libraries/kunena/config.php:123924 KunenaConfig::getInstance() Copy JROOT/libraries/kunena/factory.php:2823 KunenaFactory::getConfig() Copy JROOT/libraries/kunena/route/route.php:48022 KunenaRoute::initialize() Copy JROOT/libraries/kunena/route/route.php:1721 include Copy JROOT/libraries/kunena/route/route.php Copy JROOT/libraries/loader.php:71620 JLoader::_load() Copy JROOT/libraries/loader.php:67119 JLoader::_autoload() Copy JROOT/components/com_kunena/router.php:3818 KunenaBuildRoute() Copy JROOT/libraries/cms/component/router/legacy.php:6817 JComponentRouterLegacy->build() Copy JROOT/libraries/cms/router/site.php:51916 JRouterSite->buildSefRoute() Copy JROOT/libraries/cms/router/site.php:48915 JRouterSite->_buildSefRoute() Copy JROOT/libraries/cms/router/router.php:28214 JRouter->build() Copy JROOT/libraries/cms/router/site.php:14913 JRouterSite->build() Copy JROOT/libraries/joomla/application/route.php:6212 JRoute::_() Copy JROOT/modules/mod_defaultmenu/helper.php:13411 ModDefaultHelper::getList() Copy JROOT/modules/mod_defaultmenu/mod_defaultmenu.php:1510 include Copy JROOT/modules/mod_defaultmenu/mod_defaultmenu.php Copy JROOT/libraries/cms/module/helper.php:1989 JModuleHelper::renderModule() Copy JROOT/libraries/joomla/document/renderer/html/module.php:938 JDocumentRendererHtmlModule->render() Copy JROOT/libraries/joomla/document/renderer/html/modules.php:427 JDocumentRendererHtmlModules->render() Copy JROOT/libraries/joomla/document/html.php:4866 JDocumentHtml->getBuffer() Copy JROOT/libraries/joomla/document/html.php:7775 JDocumentHtml->_renderTemplate() Copy JROOT/libraries/joomla/document/html.php:5524 JDocumentHtml->render() Copy JROOT/libraries/cms/application/cms.php: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:78
クエリ時間:1.23 ms 最後のクエリの後:6.02 ms クエリメモリ:0.023 MB クエリ前のメモリ:28.871 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.10 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.02 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.03 ms
# 発信者 ファイルと行番号 16 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:165415 JDatabaseDriver->loadObject() Copy JROOT/libraries/axslibs/language.php:45014 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:78
クエリ時間:1.19 ms 最後のクエリの後:0.04 ms クエリメモリ:0.023 MB クエリ前のメモリ:28.880 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.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 preparing 0.01 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.03 ms cleaning up 0.03 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:78
クエリ時間:1.30 ms 最後のクエリの後:3.41 ms クエリメモリ:0.022 MB クエリ前のメモリ:28.943 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 = 618クエリでは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 = 618
Status Duration starting 0.11 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.01 ms Opening tables 0.06 ms init 0.01 ms System lock 0.02 ms optimizing 0.02 ms statistics 0.10 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.03 ms
# 発信者 ファイルと行番号 15 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:169314 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/cms/language/associations.php:10113 JLanguageAssociations::getAssociations() Copy JROOT/administrator/components/com_menus/helpers/menus.php:31312 MenusHelper::getAssociations() Copy JROOT/modules/mod_language_selector/tmpl/default.php:9811 require Copy JROOT/modules/mod_language_selector/tmpl/default.php Copy JROOT/modules/mod_language_selector/mod_language_selector.php:410 include Copy JROOT/modules/mod_language_selector/mod_language_selector.php Copy JROOT/libraries/cms/module/helper.php:1989 JModuleHelper::renderModule() Copy JROOT/libraries/joomla/document/renderer/html/module.php:938 JDocumentRendererHtmlModule->render() Copy JROOT/libraries/joomla/document/renderer/html/modules.php:427 JDocumentRendererHtmlModules->render() Copy JROOT/libraries/joomla/document/html.php:4866 JDocumentHtml->getBuffer() Copy JROOT/libraries/joomla/document/html.php:7775 JDocumentHtml->_renderTemplate() Copy JROOT/libraries/joomla/document/html.php:5524 JDocumentHtml->render() Copy JROOT/libraries/cms/application/cms.php: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:78
4×SELECT * FROM joom_easyblog_category 2×SELECT * FROM joom_languages 2×SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `joom_extensions ` 2×SELECT * FROM `joom_users ` 2×SELECT a.* FROM `joom_easyblog_comment ` a INNER JOIN joom_users AS c ON a.`created_by` = c.`id` 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 language, published FROM axs_brands 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 * FROM joom_easyblog_configs 1×SELECT * FROM joom_extensions 1×SELECT params FROM axs_user_settings 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 `id` FROM `joom_easyblog_mailq ` 1×SELECT * FROM `joom_easyblog_post ` 1×SELECT id, created_by FROM `joom_easyblog_post ` 1×SELECT * FROM `joom_easyblog_uploader_tmp ` 1×SELECT * FROM `joom_menu ` 1×SELECT * FROM `joom_easyblog_acl ` 1×SELECT * FROM `joom_easyblog_acl_group ` 1×SELECT `id`,`name`,`rules`,`parent_id` FROM `joom_assets ` 1×SELECT `id` FROM `joom_menu ` 1×SELECT * FROM joom_easyblog_meta 1×select a.`id`, a.`title`, a.`alias`, a.`private`, a.`parent_id` from `joom_easyblog_category ` as a 1×SELECT COUNT (1) AS `cnt` FROM `joom_easyblog_post_category ` AS `a` INNER JOIN `joom_easyblog_post ` AS `b` ON a.`post_id` = b.`id` AND b.`published`= '1' INNER JOIN `joom_easyblog_category ` AS `c` ON a.`category_id` = c.`id` AND b.`access`= '0' 1×SELECT COUNT (1) FROM `joom_easyblog_post ` AS a 1×SELECT a.* FROM `joom_easyblog_post ` AS a 1×SELECT COUNT (1) FROM `joom_easyblog_category_acl ` 1×SELECT COUNT (1) as `voted`, `uid` FROM `joom_easyblog_ratings ` 1×SELECT AVG (`value`) AS `ratings` ,COUNT (1) AS `total` ,`uid` FROM `joom_easyblog_ratings ` AS a 1×SELECT a.* FROM `joom_easyblog_comment ` AS a 1×SELECT a.`post_id`, COUNT (1) AS `count` FROM `joom_easyblog_comment ` AS a 1×select a.* , b.`post_id`, b.`primary` from `joom_easyblog_category ` as a inner join `joom_easyblog_post_category ` as b on a.`id` = b.`category_id` 1×select a.* , b.`post_id` from `joom_easyblog_tag ` as a inner join `joom_easyblog_post_tag ` as b on a.`id` = b.`tag_id` 1×select a.* from `joom_easyblog_revisions ` as a 1×select u.* , e.`id` as `eb_id`, e.`nickname`, e.`avatar`, e.`description`, e.`url`, e.`params` as `eb_params`, e.`published` as `eb_published`, e.`title` as `eb_title`, e.`biography`, e.`permalink`, e.`custom_css` from `joom_users ` as u left join `joom_easyblog_users ` as e ON u.`id` = e.`id` 1×SELECT `g`.`id`,`g`.`title` FROM `joom_usergroups ` AS g INNER JOIN `joom_user_usergroup_map ` AS m ON m.group_id = g.id 1×select `a`.`id` as `cat_fg_id`, `a`.`category_id` as `cat_fg_category_id`, `a`.`group_id` as `cat_fg_group_id`, `fg`.`id` as `fg_id`, `fg`.`title` as `fg_title`, `fg`.`description` as `fg_description`, `fg`.`created` as `fg_created`, `fg`.`state` as `fg_state`, `fg`.`read` as `fg_read`, `fg`.`write` as `fg_write`, `fg`.`params` as `fg_params`, `f`.`id` as `f_id`, `f`.`group_id` as `f_group_id`, `f`.`title` as `f_title`, `f`.`help` as `f_help`, `f`.`state` as `f_state`, `f`.`required` as `f_required`, `f`.`type` as `f_type`, `f`.`params` as `f_params`, `f`.`created` as `f_created`, `f`.`options` as `f_options`, `fv`.`id` as `fv_id`, `fv`.`field_id` as `fv_field_id`, `fv`.`post_id` as `fv_post_id`, `fv`.`value` as `fv_value` from `joom_easyblog_category_fields_groups ` as a inner join `joom_easyblog_post_category ` as p on `a`.`category_id` = `p`.`category_id` inner join `joom_easyblog_fields_groups ` as fg on `a`.`group_id` = `fg`.`id` inner join `joom_easyblog_fields ` as f on `fg`.`id` = `f`.`group_id` left join `joom_easyblog_fields_values ` as fv on `fv`.`field_id` = `f`.`id` and `fv`.`post_id` = `p`.`post_id` 1×select * from `joom_easyblog_meta ` 1×SELECT * FROM `joom_easyblog_featured ` 1×SELECT `group_id` FROM `joom_easyblog_category_fields_groups ` 1×SELECT a.* FROM `joom_easyblog_fields ` AS a INNER JOIN `joom_easyblog_category_fields_groups ` AS b ON a.`group_id`= b.`group_id` 1×SELECT `id` FROM `joom_easyblog_subscriptions ` 1×SELECT `template` FROM `joom_template_styles ` 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 a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state FROM joom_fields AS a LEFT JOIN `joom_languages ` AS l ON l.lang_code = a.language LEFT JOIN joom_users AS uc ON uc.id= a.checked_out LEFT JOIN joom_viewlevels AS ag ON ag.id = a.access LEFT JOIN joom_users AS ua ON ua.id = a.created_user_id LEFT JOIN joom_fields_groups AS g ON g.id = a.group_id LEFT JOIN `joom_fields_categories ` AS fc ON fc.field_id = a.id 1×SELECT language,id FROM `joom_menu ` 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_kunena_configuration 1×SELECT special_characters FROM joom_languages 1×SELECT * FROM axs_translations 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`