クエリ時間：2.45 ms クエリメモリ：0.020 MB クエリ前のメモリ：6.005 MB 返された行：0
SELECT session_id
FROM `joom_session `
WHERE `session_id` = 'bko5b30lljh7b03jcvhf7pvcel' LIMIT 1クエリではEXPLAINは使用できません：SELECT session_id
FROM `joom_session`
WHERE `session_id` = 'bko5b30lljh7b03jcvhf7pvcel' LIMIT 1
Status Duration starting 0.08 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.09 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:48
クエリ時間：3.65 ms 最後のクエリの後：0.05 ms クエリメモリ：0.003 MB クエリ前のメモリ：6.010 MB
INSERT INTO `joom_session `
(`session_id`,`guest`,`time`,`userid`,`username`) VALUES
('bko5b30lljh7b03jcvhf7pvcel', 1, '1774037115', 0, '')クエリではEXPLAINは使用できません：INSERT INTO `joom_session`
(`session_id`,`guest`,`time`,`userid`,`username`) VALUES
('bko5b30lljh7b03jcvhf7pvcel', 1, '1774037115', 0, '')
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 update 0.22 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.11 ms closing tables 0.01 ms freeing items 0.01 ms async commit 2.51 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:48
クエリ時間：1.10 ms 最後のクエリの後：70.53 ms クエリメモリ：0.021 MB クエリ前のメモリ：7.288 MB 返された行：1
SELECT * FROM `axs_brands` WHERE language = 'en-GB ' AND (FIND_IN_SET ('k8s.intg.tovuti.io', domains) > 0) LIMIT 1クエリではEXPLAINは使用できません：SELECT * FROM `axs_brands` WHERE language = 'en-GB' AND (FIND_IN_SET('k8s.intg.tovuti.io', domains) > 0) LIMIT 1
Status Duration starting 0.10 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.02 ms statistics 0.02 ms preparing 0.03 ms executing 0.06 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.02 ms
# 発信者 ファイルと行番号 10 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:16939 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/axslibs/brands.php:3708 AxsBrands::getData() Copy JROOT/libraries/axslibs/brands.php:4377 AxsBrands::getBrandObject() Copy JROOT/libraries/axslibs/brands.php:576 AxsBrands::getBrand() Copy JROOT/libraries/tovuti/Providers/FeatureFlaggingServiceProvider.php:715 Tovuti\Providers\FeatureFlaggingServiceProvider->getClientMetadata() Copy JROOT/libraries/tovuti/Providers/FeatureFlaggingServiceProvider.php:334 Tovuti\Providers\FeatureFlaggingServiceProvider->register() Copy JROOT/libraries/tovuti/Helpers/AppBootstrapHelper.php:1153 Tovuti\Helpers\AppBootstrapHelper::registerProviderWithDependencies() Copy JROOT/libraries/tovuti/Helpers/AppBootstrapHelper.php:902 Tovuti\Helpers\AppBootstrapHelper::bootstrapServices() Copy JROOT/libraries/tovuti/Helpers/AppBootstrapHelper.php:471 Tovuti\Helpers\AppBootstrapHelper::bootstrap() Copy JROOT/index.php:70
クエリ時間：1.30 ms 最後のクエリの後：0.42 ms クエリメモリ：0.029 MB クエリ前のメモリ：7.357 MB 返された行：20
SELECT * FROM joom_languages WHERE published = 1 ORDER BY `title`クエリではEXPLAINは使用できません：SELECT * FROM joom_languages WHERE published = 1 ORDER BY `title`
Status Duration starting 0.04 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.02 ms executing 0.19 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/language.php:3429 AxsLanguage::getPublishedLanguages() Copy JROOT/libraries/axslibs/language.php:2518 AxsLanguage::getCurrentLanguage() Copy JROOT/libraries/axslibs/brands.php:4537 AxsBrands::getBrandObject() Copy JROOT/libraries/axslibs/brands.php:576 AxsBrands::getBrand() Copy JROOT/libraries/tovuti/Providers/FeatureFlaggingServiceProvider.php:715 Tovuti\Providers\FeatureFlaggingServiceProvider->getClientMetadata() Copy JROOT/libraries/tovuti/Providers/FeatureFlaggingServiceProvider.php:334 Tovuti\Providers\FeatureFlaggingServiceProvider->register() Copy JROOT/libraries/tovuti/Helpers/AppBootstrapHelper.php:1153 Tovuti\Helpers\AppBootstrapHelper::registerProviderWithDependencies() Copy JROOT/libraries/tovuti/Helpers/AppBootstrapHelper.php:902 Tovuti\Helpers\AppBootstrapHelper::bootstrapServices() Copy JROOT/libraries/tovuti/Helpers/AppBootstrapHelper.php:471 Tovuti\Helpers\AppBootstrapHelper::bootstrap() Copy JROOT/index.php:70
クエリ時間：0.98 ms 最後のクエリの後：1.28 ms クエリメモリ：0.021 MB クエリ前のメモリ：7.716 MB 返された行：1
SELECT * FROM `axs_homepage_templates` WHERE id = '1'クエリではEXPLAINは使用できません：SELECT * FROM `axs_homepage_templates` WHERE id = '1'
Status Duration starting 0.04 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.01 ms System lock 0.02 ms optimizing 0.02 ms statistics 0.06 ms preparing 0.01 ms executing 0.03 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.02 ms
# 発信者 ファイルと行番号 10 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:16939 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/axslibs/brands.php:5128 AxsBrands::getHomepageTemplate() Copy JROOT/libraries/axslibs/brands.php:4687 AxsBrands::getBrandObject() Copy JROOT/libraries/axslibs/brands.php:576 AxsBrands::getBrand() Copy JROOT/libraries/tovuti/Providers/FeatureFlaggingServiceProvider.php:715 Tovuti\Providers\FeatureFlaggingServiceProvider->getClientMetadata() Copy JROOT/libraries/tovuti/Providers/FeatureFlaggingServiceProvider.php:334 Tovuti\Providers\FeatureFlaggingServiceProvider->register() Copy JROOT/libraries/tovuti/Helpers/AppBootstrapHelper.php:1153 Tovuti\Helpers\AppBootstrapHelper::registerProviderWithDependencies() Copy JROOT/libraries/tovuti/Helpers/AppBootstrapHelper.php:902 Tovuti\Helpers\AppBootstrapHelper::bootstrapServices() Copy JROOT/libraries/tovuti/Helpers/AppBootstrapHelper.php:471 Tovuti\Helpers\AppBootstrapHelper::bootstrap() Copy JROOT/index.php:70
クエリ時間：0.93 ms 最後のクエリの後：0.08 ms クエリメモリ：0.021 MB クエリ前のメモリ：7.756 MB 返された行：1
SELECT * FROM `axs_dashboard_templates` WHERE id = '2'クエリではEXPLAINは使用できません：SELECT * FROM `axs_dashboard_templates` WHERE id = '2'
Status Duration starting 0.04 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 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
# 発信者 ファイルと行番号 10 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:16939 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/axslibs/brands.php:5208 AxsBrands::getDashboardTemplate() Copy JROOT/libraries/axslibs/brands.php:4847 AxsBrands::getBrandObject() Copy JROOT/libraries/axslibs/brands.php:576 AxsBrands::getBrand() Copy JROOT/libraries/tovuti/Providers/FeatureFlaggingServiceProvider.php:715 Tovuti\Providers\FeatureFlaggingServiceProvider->getClientMetadata() Copy JROOT/libraries/tovuti/Providers/FeatureFlaggingServiceProvider.php:334 Tovuti\Providers\FeatureFlaggingServiceProvider->register() Copy JROOT/libraries/tovuti/Helpers/AppBootstrapHelper.php:1153 Tovuti\Helpers\AppBootstrapHelper::registerProviderWithDependencies() Copy JROOT/libraries/tovuti/Helpers/AppBootstrapHelper.php:902 Tovuti\Helpers\AppBootstrapHelper::bootstrapServices() Copy JROOT/libraries/tovuti/Helpers/AppBootstrapHelper.php:471 Tovuti\Helpers\AppBootstrapHelper::bootstrap() Copy JROOT/index.php:70
クエリ時間：0.91 ms 最後のクエリの後：0.10 ms クエリメモリ：0.021 MB クエリ前のメモリ：7.784 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.04 ms init 0.01 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.05 ms preparing 0.01 ms executing 0.01 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.06 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:7388 AxsBrands::getEmailSettingsById() Copy JROOT/libraries/axslibs/brands.php:4907 AxsBrands::getBrandObject() Copy JROOT/libraries/axslibs/brands.php:576 AxsBrands::getBrand() Copy JROOT/libraries/tovuti/Providers/FeatureFlaggingServiceProvider.php:715 Tovuti\Providers\FeatureFlaggingServiceProvider->getClientMetadata() Copy JROOT/libraries/tovuti/Providers/FeatureFlaggingServiceProvider.php:334 Tovuti\Providers\FeatureFlaggingServiceProvider->register() Copy JROOT/libraries/tovuti/Helpers/AppBootstrapHelper.php:1153 Tovuti\Helpers\AppBootstrapHelper::registerProviderWithDependencies() Copy JROOT/libraries/tovuti/Helpers/AppBootstrapHelper.php:902 Tovuti\Helpers\AppBootstrapHelper::bootstrapServices() Copy JROOT/libraries/tovuti/Helpers/AppBootstrapHelper.php:471 Tovuti\Helpers\AppBootstrapHelper::bootstrap() Copy JROOT/index.php:70
クエリ時間：1.33 ms 最後のクエリの後：2.10 ms クエリメモリ：0.047 MB クエリ前のメモリ：8.126 MB 返された行：80
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `joom_extensions `
WHERE `type` = 'component'クエリではEXPLAINは使用できません：SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `joom_extensions`
WHERE `type` = 'component'
Status Duration starting 0.05 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.09 ms preparing 0.02 ms executing 0.31 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
# 発信者 ファイルと行番号 16 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:169315 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/cms/component/helper.php:44714 JComponentHelper::{closure}() Copy JROOT/libraries/joomla/cache/controller/callback.php:16913 JCacheControllerCallback->get() Copy JROOT/libraries/cms/component/helper.php:45512 JComponentHelper::load() Copy JROOT/libraries/cms/component/helper.php:4311 JComponentHelper::getComponent() Copy JROOT/libraries/cms/component/helper.php:11110 JComponentHelper::getParams() Copy JROOT/libraries/joomla/access/access.php:9419 JAccess::getGroupsByUser() Copy JROOT/libraries/joomla/user/user.php:4768 JUser->getAuthorisedGroups() Copy JROOT/libraries/axslibs/brands.php:4917 AxsBrands::getBrandObject() Copy JROOT/libraries/axslibs/brands.php:576 AxsBrands::getBrand() Copy JROOT/libraries/tovuti/Providers/FeatureFlaggingServiceProvider.php:715 Tovuti\Providers\FeatureFlaggingServiceProvider->getClientMetadata() Copy JROOT/libraries/tovuti/Providers/FeatureFlaggingServiceProvider.php:334 Tovuti\Providers\FeatureFlaggingServiceProvider->register() Copy JROOT/libraries/tovuti/Helpers/AppBootstrapHelper.php:1153 Tovuti\Helpers\AppBootstrapHelper::registerProviderWithDependencies() Copy JROOT/libraries/tovuti/Helpers/AppBootstrapHelper.php:902 Tovuti\Helpers\AppBootstrapHelper::bootstrapServices() Copy JROOT/libraries/tovuti/Helpers/AppBootstrapHelper.php:471 Tovuti\Helpers\AppBootstrapHelper::bootstrap() Copy JROOT/index.php:70
クエリ時間：1.04 ms 最後のクエリの後：0.42 ms クエリメモリ：0.021 MB クエリ前のメモリ：8.212 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.09 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.04 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.09 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.04 ms cleaning up 0.02 ms
# 発信者 ファイルと行番号 11 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:154210 JDatabaseDriver->loadColumn() Copy JROOT/libraries/joomla/access/access.php:9829 JAccess::getGroupsByUser() Copy JROOT/libraries/joomla/user/user.php:4768 JUser->getAuthorisedGroups() Copy JROOT/libraries/axslibs/brands.php:4917 AxsBrands::getBrandObject() Copy JROOT/libraries/axslibs/brands.php:576 AxsBrands::getBrand() Copy JROOT/libraries/tovuti/Providers/FeatureFlaggingServiceProvider.php:715 Tovuti\Providers\FeatureFlaggingServiceProvider->getClientMetadata() Copy JROOT/libraries/tovuti/Providers/FeatureFlaggingServiceProvider.php:334 Tovuti\Providers\FeatureFlaggingServiceProvider->register() Copy JROOT/libraries/tovuti/Helpers/AppBootstrapHelper.php:1153 Tovuti\Helpers\AppBootstrapHelper::registerProviderWithDependencies() Copy JROOT/libraries/tovuti/Helpers/AppBootstrapHelper.php:902 Tovuti\Helpers\AppBootstrapHelper::bootstrapServices() Copy JROOT/libraries/tovuti/Helpers/AppBootstrapHelper.php:471 Tovuti\Helpers\AppBootstrapHelper::bootstrap() Copy JROOT/index.php:70
クエリ時間：0.97 ms 最後のクエリの後：0.04 ms クエリメモリ：0.021 MB クエリ前のメモリ：8.218 MB 返された行：1
SELECT *
FROM axs_payment_gateways
WHERE id = '1'クエリではEXPLAINは使用できません：SELECT *
FROM axs_payment_gateways
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.04 ms init 0.01 ms System lock 0.01 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.04 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:6868 AxsBrands::getPaymentGatewayById() Copy JROOT/libraries/axslibs/brands.php:4937 AxsBrands::getBrandObject() Copy JROOT/libraries/axslibs/brands.php:576 AxsBrands::getBrand() Copy JROOT/libraries/tovuti/Providers/FeatureFlaggingServiceProvider.php:715 Tovuti\Providers\FeatureFlaggingServiceProvider->getClientMetadata() Copy JROOT/libraries/tovuti/Providers/FeatureFlaggingServiceProvider.php:334 Tovuti\Providers\FeatureFlaggingServiceProvider->register() Copy JROOT/libraries/tovuti/Helpers/AppBootstrapHelper.php:1153 Tovuti\Helpers\AppBootstrapHelper::registerProviderWithDependencies() Copy JROOT/libraries/tovuti/Helpers/AppBootstrapHelper.php:902 Tovuti\Helpers\AppBootstrapHelper::bootstrapServices() Copy JROOT/libraries/tovuti/Helpers/AppBootstrapHelper.php:471 Tovuti\Helpers\AppBootstrapHelper::bootstrap() Copy JROOT/index.php:70
クエリ時間：0.85 ms 最後のクエリの後：0.07 ms クエリメモリ：0.021 MB クエリ前のメモリ：8.228 MB 返された行：1
SELECT *
FROM axs_integrations
WHERE id = '1'クエリではEXPLAINは使用できません：SELECT *
FROM axs_integrations
WHERE id = '1'
Status Duration starting 0.03 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.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:7578 AxsBrands::getIntegrationById() Copy JROOT/libraries/axslibs/brands.php:5007 AxsBrands::getBrandObject() Copy JROOT/libraries/axslibs/brands.php:576 AxsBrands::getBrand() Copy JROOT/libraries/tovuti/Providers/FeatureFlaggingServiceProvider.php:715 Tovuti\Providers\FeatureFlaggingServiceProvider->getClientMetadata() Copy JROOT/libraries/tovuti/Providers/FeatureFlaggingServiceProvider.php:334 Tovuti\Providers\FeatureFlaggingServiceProvider->register() Copy JROOT/libraries/tovuti/Helpers/AppBootstrapHelper.php:1153 Tovuti\Helpers\AppBootstrapHelper::registerProviderWithDependencies() Copy JROOT/libraries/tovuti/Helpers/AppBootstrapHelper.php:902 Tovuti\Helpers\AppBootstrapHelper::bootstrapServices() Copy JROOT/libraries/tovuti/Helpers/AppBootstrapHelper.php:471 Tovuti\Helpers\AppBootstrapHelper::bootstrap() Copy JROOT/index.php:70
クエリ時間：2.59 ms 最後のクエリの後：4.74 ms クエリメモリ：0.021 MB クエリ前のメモリ：8.833 MB 返された行：7
SELECT id, rules
FROM `joom_viewlevels `クエリではEXPLAINは使用できません：SELECT id, rules
FROM `joom_viewlevels`
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.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:14989 JDatabaseDriver->loadAssocList() Copy JROOT/libraries/joomla/access/access.php:10658 JAccess::getAuthorisedViewLevels() Copy JROOT/libraries/joomla/user/user.php:4547 JUser->getAuthorisedViewLevels() Copy JROOT/libraries/cms/plugin/helper.php:2936 JPluginHelper::load() Copy JROOT/libraries/cms/plugin/helper.php:865 JPluginHelper::getPlugin() Copy JROOT/libraries/cms/plugin/helper.php:1284 JPluginHelper::isEnabled() Copy JROOT/libraries/cms/application/site.php:6083 JApplicationSite->initialiseApp() Copy JROOT/libraries/cms/application/site.php:2092 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2671 JApplicationCms->execute() Copy JROOT/index.php:73
クエリ時間：3.88 ms 最後のクエリの後：0.07 ms クエリメモリ：0.046 MB クエリ前のメモリ：8.860 MB 返された行：143
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.10 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.02 ms statistics 0.08 ms preparing 0.03 ms executing 1.29 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.78 ms cleaning up 0.02 ms
# 発信者 ファイルと行番号 10 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:16939 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/cms/plugin/helper.php:3118 JPluginHelper::{closure}() Copy JROOT/libraries/joomla/cache/controller/callback.php:1697 JCacheControllerCallback->get() Copy JROOT/libraries/cms/plugin/helper.php:3166 JPluginHelper::load() Copy JROOT/libraries/cms/plugin/helper.php:865 JPluginHelper::getPlugin() Copy JROOT/libraries/cms/plugin/helper.php:1284 JPluginHelper::isEnabled() Copy JROOT/libraries/cms/application/site.php:6083 JApplicationSite->initialiseApp() Copy JROOT/libraries/cms/application/site.php:2092 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2671 JApplicationCms->execute() Copy JROOT/index.php:73
クエリ時間：1.17 ms 最後のクエリの後：16.99 ms クエリメモリ：0.024 MB クエリ前のメモリ：11.149 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.10 ms Executing hook on transaction 0.01 ms starting 0.02 ms checking permissions 0.01 ms Opening tables 0.05 ms init 0.01 ms System lock 0.02 ms optimizing 0.02 ms statistics 0.11 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.02 ms freeing items 0.04 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 17 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:165416 JDatabaseDriver->loadObject() Copy JROOT/libraries/cms/library/helper.php:16615 JLibraryHelper::{closure}() Copy JROOT/libraries/joomla/cache/controller/callback.php:16914 JCacheControllerCallback->get() Copy JROOT/libraries/cms/library/helper.php:17413 JLibraryHelper::loadLibrary() Copy JROOT/libraries/cms/library/helper.php:4212 JLibraryHelper::getLibrary() Copy JROOT/libraries/cms/library/helper.php:8911 JLibraryHelper::getParams() Copy JROOT/libraries/cms/version/version.php:27010 JVersion->getMediaVersion() Copy JROOT/libraries/joomla/factory.php:8509 JFactory::createDocument() Copy JROOT/libraries/joomla/factory.php:2248 JFactory::getDocument() Copy JROOT/plugins/system/mootable/mootable.php:1007 PlgSystemMootable->__construct() Copy JROOT/libraries/cms/plugin/helper.php:2556 JPluginHelper::import() Copy JROOT/libraries/cms/plugin/helper.php:1705 JPluginHelper::importPlugin() Copy JROOT/libraries/cms/application/cms.php:7174 JApplicationCms->initialiseApp() Copy JROOT/libraries/cms/application/site.php:6903 JApplicationSite->initialiseApp() Copy JROOT/libraries/cms/application/site.php:2092 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2671 JApplicationCms->execute() Copy JROOT/index.php:73
クエリ時間：3.84 ms 最後のクエリの後：0.10 ms クエリメモリ：0.006 MB クエリ前のメモリ：11.141 MB
UPDATE `joom_extensions `
SET `params` = '{\"mediaversion\":\"ebd098dcd8addb84366d1859d28274e9\"}'
WHERE `type` = 'library' AND `element` = 'joomla'クエリではEXPLAINは使用できません：UPDATE `joom_extensions`
SET `params` = '{\"mediaversion\":\"ebd098dcd8addb84366d1859d28274e9\"}'
WHERE `type` = 'library' AND `element` = 'joomla'
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.11 ms updating 0.19 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.10 ms closing tables 0.01 ms freeing items 0.02 ms async commit 2.55 ms cleaning up 0.02 ms
# 発信者 ファイルと行番号 13 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/cms/library/helper.php:11612 JLibraryHelper::saveParams() Copy JROOT/libraries/cms/version/version.php:32111 JVersion->setMediaVersion() Copy JROOT/libraries/cms/version/version.php:28010 JVersion->getMediaVersion() Copy JROOT/libraries/joomla/factory.php:8509 JFactory::createDocument() Copy JROOT/libraries/joomla/factory.php:2248 JFactory::getDocument() Copy JROOT/plugins/system/mootable/mootable.php:1007 PlgSystemMootable->__construct() Copy JROOT/libraries/cms/plugin/helper.php:2556 JPluginHelper::import() Copy JROOT/libraries/cms/plugin/helper.php:1705 JPluginHelper::importPlugin() Copy JROOT/libraries/cms/application/cms.php:7174 JApplicationCms->initialiseApp() Copy JROOT/libraries/cms/application/site.php:6903 JApplicationSite->initialiseApp() Copy JROOT/libraries/cms/application/site.php:2092 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2671 JApplicationCms->execute() Copy JROOT/index.php:73
クエリ時間：2.05 ms 最後のクエリの後：4.63 ms クエリメモリ：0.029 MB クエリ前のメモリ：11.775 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.03 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.02 ms executing 0.18 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.02 ms freeing items 0.02 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 10 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:16939 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/joomla/language/helper.php:1488 JLanguageHelper::getLanguages() Copy JROOT/plugins/system/languagefilter/languagefilter.php:997 PlgSystemLanguageFilter->__construct() Copy JROOT/libraries/cms/plugin/helper.php:2556 JPluginHelper::import() Copy JROOT/libraries/cms/plugin/helper.php:1705 JPluginHelper::importPlugin() Copy JROOT/libraries/cms/application/cms.php:7174 JApplicationCms->initialiseApp() Copy JROOT/libraries/cms/application/site.php:6903 JApplicationSite->initialiseApp() Copy JROOT/libraries/cms/application/site.php:2092 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2671 JApplicationCms->execute() Copy JROOT/index.php:73
クエリ時間：1.17 ms 最後のクエリの後：0.06 ms クエリメモリ：0.021 MB クエリ前のメモリ：11.801 MB 返された行：1
SELECT * FROM axs_domains WHERE domain = 'k8s.intg.tovuti.io'クエリではEXPLAINは使用できません：SELECT * FROM axs_domains WHERE domain = 'k8s.intg.tovuti.io'
Status Duration starting 0.04 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.01 ms executing 0.04 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 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:1848 AxsLanguage::getSubdomainDefault() Copy JROOT/plugins/system/languagefilter/languagefilter.php:1037 PlgSystemLanguageFilter->__construct() Copy JROOT/libraries/cms/plugin/helper.php:2556 JPluginHelper::import() Copy JROOT/libraries/cms/plugin/helper.php:1705 JPluginHelper::importPlugin() Copy JROOT/libraries/cms/application/cms.php:7174 JApplicationCms->initialiseApp() Copy JROOT/libraries/cms/application/site.php:6903 JApplicationSite->initialiseApp() Copy JROOT/libraries/cms/application/site.php:2092 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2671 JApplicationCms->execute() Copy JROOT/index.php:73
クエリ時間：1.61 ms 最後のクエリの後：0.05 ms クエリメモリ：0.030 MB クエリ前のメモリ：11.809 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.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.07 ms preparing 0.03 ms executing 0.37 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.03 ms
# 発信者 ファイルと行番号 10 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:16939 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/joomla/language/helper.php:2078 JLanguageHelper::getInstalledLanguages() Copy JROOT/plugins/system/languagefilter/languagefilter.php:1137 PlgSystemLanguageFilter->__construct() Copy JROOT/libraries/cms/plugin/helper.php:2556 JPluginHelper::import() Copy JROOT/libraries/cms/plugin/helper.php:1705 JPluginHelper::importPlugin() Copy JROOT/libraries/cms/application/cms.php:7174 JApplicationCms->initialiseApp() Copy JROOT/libraries/cms/application/site.php:6903 JApplicationSite->initialiseApp() Copy JROOT/libraries/cms/application/site.php:2092 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2671 JApplicationCms->execute() Copy JROOT/index.php:73
クエリ時間：2.24 ms 最後のクエリの後：14.68 ms クエリメモリ：0.102 MB クエリ前のメモリ：13.545 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.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.06 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.09 ms preparing 0.05 ms executing 1.08 ms end 0.02 ms query end 0.01 ms waiting for handler commit 0.02 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 24 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:169323 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/cms/menu/site.php:8822 JMenuSite->{closure}() Copy JROOT/libraries/joomla/cache/controller/callback.php:16921 JCacheControllerCallback->get() Copy JROOT/libraries/cms/menu/site.php:9620 JMenuSite->load() Copy JROOT/libraries/cms/menu/menu.php:7419 JMenu->__construct() Copy JROOT/libraries/cms/menu/site.php:5718 JMenuSite->__construct() Copy JROOT/libraries/cms/menu/menu.php:12917 JMenu::getInstance() Copy JROOT/libraries/cms/application/cms.php:49716 JApplicationCms->getMenu() Copy JROOT/libraries/cms/application/site.php:27715 JApplicationSite->getMenu() Copy JROOT/libraries/cms/router/site.php:5914 JRouterSite->__construct() Copy JROOT/libraries/cms/router/router.php:19813 JRouter::getInstance() Copy JROOT/libraries/cms/application/cms.php:59112 JApplicationCms::getRouter() Copy JROOT/libraries/cms/application/site.php:40711 JApplicationSite::getRouter() Copy JROOT/plugins/system/languagefilter/languagefilter.php:13410 PlgSystemLanguageFilter->onAfterInitialise() 以下の行の呼び出しと同じです。 9 ReflectionMethod->invokeArgs() Copy JROOT/libraries/tovuti/Helpers/MethodHelper.php:588 Tovuti\Helpers\MethodHelper::call() Copy JROOT/libraries/joomla/event/event.php:727 JEvent->update() Copy JROOT/libraries/joomla/event/dispatcher.php:1606 JEventDispatcher->trigger() Copy JROOT/libraries/joomla/application/base.php:1065 JApplicationBase->triggerEvent() Copy JROOT/libraries/cms/application/cms.php:7184 JApplicationCms->initialiseApp() Copy JROOT/libraries/cms/application/site.php:6903 JApplicationSite->initialiseApp() Copy JROOT/libraries/cms/application/site.php:2092 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2671 JApplicationCms->execute() Copy JROOT/index.php:73
クエリ時間：2.34 ms 最後のクエリの後：24.36 ms クエリメモリ：0.028 MB クエリ前のメモリ：16.459 MB 返された行：17
SHOW FULL COLUMNS FROM `joom_users `クエリではEXPLAINは使用できません：SHOW FULL COLUMNS FROM `joom_users`
Status Duration starting 0.07 ms Executing hook on transaction 0.01 ms starting 0.06 ms checking permissions 0.01 ms checking permissions 0.00 ms Opening tables 0.57 ms init 0.01 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.12 ms preparing 0.04 ms Creating tmp table 0.06 ms executing 0.09 ms checking permissions 0.07 ms checking permissions 0.03 ms checking permissions 0.03 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.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.02 ms checking permissions 0.02 ms checking permissions 0.03 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.06 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.02 ms closing tables 0.02 ms freeing items 0.06 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 20 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:169319 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/joomla/database/driver/mysqli.php:43518 JDatabaseDriverMysqli->getTableColumns() Copy JROOT/libraries/joomla/table/table.php:24417 JTable->getFields() Copy JROOT/libraries/joomla/table/table.php:16316 JTable->__construct() Copy JROOT/libraries/joomla/table/user.php:3915 JTableUser->__construct() Copy JROOT/libraries/joomla/table/table.php:31114 JTable::getInstance() Copy JROOT/libraries/joomla/user/user.php:59913 JUser::getTable() Copy JROOT/libraries/joomla/user/user.php:78312 JUser->save() Copy JROOT/plugins/system/languagefilter/languagefilter.php:84811 PlgSystemLanguageFilter->setPreferredLanguage() Copy JROOT/plugins/system/languagefilter/languagefilter.php:51210 PlgSystemLanguageFilter->parseRule() Copy JROOT/libraries/cms/router/router.php:5979 JRouter->processParseRules() Copy JROOT/libraries/cms/router/site.php:5848 JRouterSite->processParseRules() Copy JROOT/libraries/cms/router/router.php:5717 JRouter->_processParseRules() Copy JROOT/libraries/cms/router/router.php:2256 JRouter->parse() Copy JROOT/libraries/cms/router/site.php:1335 JRouterSite->parse() Copy JROOT/libraries/cms/application/cms.php:11784 JApplicationCms->route() Copy JROOT/libraries/cms/application/site.php:8003 JApplicationSite->route() Copy JROOT/libraries/cms/application/site.php:2152 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2671 JApplicationCms->execute() Copy JROOT/index.php:73
クエリ時間：0.84 ms 最後のクエリの後：0.27 ms クエリメモリ：0.022 MB クエリ前のメモリ：16.565 MB 返された行：1
SELECT `id`,`title`
FROM `joom_usergroups `
WHERE `id` = 1クエリではEXPLAINは使用できません：SELECT `id`,`title`
FROM `joom_usergroups`
WHERE `id` = 1
Status Duration starting 0.03 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.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
# 発信者 ファイルと行番号 15 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:149814 JDatabaseDriver->loadAssocList() Copy JROOT/libraries/joomla/table/user.php:16313 JTableUser->bind() Copy JROOT/libraries/joomla/user/user.php:78512 JUser->save() Copy JROOT/plugins/system/languagefilter/languagefilter.php:84811 PlgSystemLanguageFilter->setPreferredLanguage() Copy JROOT/plugins/system/languagefilter/languagefilter.php:51210 PlgSystemLanguageFilter->parseRule() Copy JROOT/libraries/cms/router/router.php:5979 JRouter->processParseRules() Copy JROOT/libraries/cms/router/site.php:5848 JRouterSite->processParseRules() Copy JROOT/libraries/cms/router/router.php:5717 JRouter->_processParseRules() Copy JROOT/libraries/cms/router/router.php:2256 JRouter->parse() Copy JROOT/libraries/cms/router/site.php:1335 JRouterSite->parse() Copy JROOT/libraries/cms/application/cms.php:11784 JApplicationCms->route() Copy JROOT/libraries/cms/application/site.php:8003 JApplicationSite->route() Copy JROOT/libraries/cms/application/site.php:2152 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2671 JApplicationCms->execute() Copy JROOT/index.php:73
クエリ時間：0.87 ms 最後のクエリの後：10.19 ms クエリメモリ：0.020 MB クエリ前のメモリ：17.148 MB 返された行：0
SELECT params
FROM axs_user_settings
WHERE id = 1クエリではEXPLAINは使用できません：SELECT params
FROM axs_user_settings
WHERE id = 1
Status Duration starting 0.05 ms Executing hook on transaction 0.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 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
# 発信者 ファイルと行番号 9 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:16548 JDatabaseDriver->loadObject() Copy JROOT/libraries/axslibs/user.php:8017 AxsUser::{closure}() Copy JROOT/libraries/tovuti/Traits/Memoization.php:256 AxsUser::memoizeStatic() Copy JROOT/libraries/axslibs/user.php:8115 AxsUser::getGlobalUserSettings() Copy JROOT/libraries/axslibs/security.php:354 AxsSecurity::getSettings() Copy JROOT/libraries/cms/application/cms.php:3683 JApplicationCms->checkUserRequireTwoFactor() Copy JROOT/libraries/cms/application/site.php:2312 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2671 JApplicationCms->execute() Copy JROOT/index.php:73
クエリ時間：0.98 ms 最後のクエリの後：2.09 ms クエリメモリ：0.019 MB クエリ前のメモリ：17.540 MB 返された行：0
SELECT *
FROM `joom_users `
WHERE `id` = 0クエリではEXPLAINは使用できません：SELECT *
FROM `joom_users`
WHERE `id` = 0
Status Duration starting 0.04 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.05 ms executing 0.02 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.03 ms
# 発信者 ファイルと行番号 6 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:16545 JDatabaseDriver->loadObject() Copy JROOT/administrator/components/com_users/models/user.php:9924 UsersModelUser->getOtpConfig() Copy JROOT/libraries/cms/application/cms.php:3723 JApplicationCms->checkUserRequireTwoFactor() Copy JROOT/libraries/cms/application/site.php:2312 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2671 JApplicationCms->execute() Copy JROOT/index.php:73
クエリ時間：2.03 ms 最後のクエリの後：0.14 ms クエリメモリ：0.019 MB クエリ前のメモリ：17.551 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.07 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.09 ms preparing 0.03 ms executing 0.13 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 6 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:16935 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/cms/application/site.php:4904 JApplicationSite->getTemplate() Copy JROOT/libraries/cms/application/site.php:1653 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2671 JApplicationCms->execute() Copy JROOT/index.php:73
クエリ時間：1.00 ms 最後のクエリの後：12.89 ms クエリメモリ：0.024 MB クエリ前のメモリ：19.177 MB 返された行：1
SELECT *
FROM axs_lms_settings
WHERE id= 1 LIMIT 1クエリではEXPLAINは使用できません：SELECT *
FROM axs_lms_settings
WHERE id=1 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.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.01 ms executing 0.01 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 17 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:165416 JDatabaseDriver->loadObject() Copy JROOT/libraries/axslibs/lms.php:232315 AxsLMS::getSettings() Copy JROOT/components/com_splms/models/courses.php:4214 SplmsModelCourses->__construct() Copy JROOT/libraries/fof/model/model.php:34813 FOFModel::getAnInstance() Copy JROOT/libraries/fof/controller/controller.php:254412 FOFController->createModel() Copy JROOT/libraries/fof/controller/controller.php:231711 FOFController->getModel() Copy JROOT/libraries/fof/controller/controller.php:227910 FOFController->getThisModel() Copy JROOT/components/com_splms/controllers/courses.php:239 SplmsControllerCourses->onBeforeBrowse() Copy JROOT/libraries/fof/controller/controller.php:9198 FOFController->execute() Copy JROOT/libraries/fof/dispatcher/dispatcher.php:3327 FOFDispatcher->dispatch() Copy JROOT/components/com_splms/splms.php:356 require_once Copy JROOT/components/com_splms/splms.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2671 JApplicationCms->execute() Copy JROOT/index.php:73
クエリ時間：1.38 ms 最後のクエリの後：8.75 ms クエリメモリ：0.027 MB クエリ前のメモリ：20.215 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
WHERE a.context = 'com_splms.courses.form.default' 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
WHERE a.context = 'com_splms.courses.form.default' 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.11 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.08 ms init 0.01 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.12 ms preparing 0.05 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
# 発信者 ファイルと行番号 26 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:169325 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/legacy/model/legacy.php:30724 JModelLegacy->_getList() Copy JROOT/administrator/components/com_fields/models/fields.php:32623 FieldsModelFields->_getList() Copy JROOT/libraries/legacy/model/list.php:18922 JModelList->getItems() Copy JROOT/administrator/components/com_fields/helpers/fields.php:13421 FieldsHelper::getFields() Copy JROOT/administrator/components/com_fields/helpers/fields.php:28020 FieldsHelper::prepareForm() Copy JROOT/plugins/system/fields/fields.php:23619 PlgSystemFields->onContentPrepareForm() 以下の行の呼び出しと同じです。 18 ReflectionMethod->invokeArgs() Copy JROOT/libraries/tovuti/Helpers/MethodHelper.php:5817 Tovuti\Helpers\MethodHelper::call() Copy JROOT/libraries/joomla/event/event.php:7216 JEvent->update() Copy JROOT/libraries/joomla/event/dispatcher.php:16015 JEventDispatcher->trigger() Copy JROOT/libraries/joomla/application/base.php:10614 JApplicationBase->triggerEvent() Copy JROOT/libraries/fof/integration/joomla/platform.php:54513 FOFIntegrationJoomlaPlatform->runPlugins() Copy JROOT/libraries/fof/model/model.php:267112 FOFModel->preprocessForm() Copy JROOT/libraries/fof/model/model.php:251611 FOFModel->loadForm() Copy JROOT/libraries/fof/model/model.php:242610 FOFModel->getForm() Copy JROOT/libraries/fof/controller/controller.php:11589 FOFController->browse() Copy JROOT/libraries/fof/controller/controller.php:9678 FOFController->execute() Copy JROOT/libraries/fof/dispatcher/dispatcher.php:3327 FOFDispatcher->dispatch() Copy JROOT/components/com_splms/splms.php:356 require_once Copy JROOT/components/com_splms/splms.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2671 JApplicationCms->execute() Copy JROOT/index.php:73
クエリ時間：1.67 ms 最後のクエリの後：10.37 ms クエリメモリ：0.031 MB クエリ前のメモリ：20.862 MB 返された行：63
SELECT `id`,`name`,`rules`,`parent_id`
FROM `joom_assets `
WHERE `name` IN ('com_accessibility','com_admin','com_advpoll','com_affiliate','com_ajax','com_associations','com_award','com_axs','com_banners','com_bigbluebutton','com_board','com_cache','com_categories','com_checkin','com_community','com_config','com_contact','com_contactpage','com_content','com_contenthistory','com_contracts','com_converge','com_cpanel','com_dashboard','com_dbmanager','com_demo','com_domains','com_dump','com_easyblog','com_eshop','com_eventbooking','com_fields','com_finder','com_improved_ajax_login','com_installer','com_interactivecontent','com_invitex','com_jbusinessdirectory','com_jce','com_joomlaupdate','com_jumi','com_kunena','com_languages','com_lifeboard','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_notifications','com_offlajn_installer','com_osmembership','com_permissioning','com_plugins','com_postinstall','com_redirect','com_reports','com_rsticketspro','com_saas','com_scheduler','com_search','com_splms','com_tags','com_templates','com_uniterevolution','com_uniterevolution2','com_uniteshowbiz','com_user_view','com_users','com_weblinks','com_wrapper') OR `parent_id` = 0クエリではEXPLAINは使用できません：SELECT `id`,`name`,`rules`,`parent_id`
FROM `joom_assets`
WHERE `name` IN ('com_accessibility','com_admin','com_advpoll','com_affiliate','com_ajax','com_associations','com_award','com_axs','com_banners','com_bigbluebutton','com_board','com_cache','com_categories','com_checkin','com_community','com_config','com_contact','com_contactpage','com_content','com_contenthistory','com_contracts','com_converge','com_cpanel','com_dashboard','com_dbmanager','com_demo','com_domains','com_dump','com_easyblog','com_eshop','com_eventbooking','com_fields','com_finder','com_improved_ajax_login','com_installer','com_interactivecontent','com_invitex','com_jbusinessdirectory','com_jce','com_joomlaupdate','com_jumi','com_kunena','com_languages','com_lifeboard','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_notifications','com_offlajn_installer','com_osmembership','com_permissioning','com_plugins','com_postinstall','com_redirect','com_reports','com_rsticketspro','com_saas','com_scheduler','com_search','com_splms','com_tags','com_templates','com_uniterevolution','com_uniterevolution2','com_uniteshowbiz','com_user_view','com_users','com_weblinks','com_wrapper') OR `parent_id` = 0
Status Duration starting 0.09 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.07 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.24 ms preparing 0.07 ms executing 0.42 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 23 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:169322 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/joomla/access/access.php:43021 JAccess::preloadComponents() Copy JROOT/libraries/joomla/access/access.php:21120 JAccess::preload() Copy JROOT/libraries/joomla/access/access.php:53319 JAccess::getAssetRules() Copy JROOT/libraries/joomla/access/access.php:18118 JAccess::check() Copy JROOT/libraries/joomla/user/user.php:39417 JUser->authorise() Copy JROOT/libraries/fof/integration/joomla/platform.php:58416 FOFIntegrationJoomlaPlatform->authorise() Copy JROOT/libraries/fof/view/raw.php:8015 FOFViewRaw->__construct() Copy JROOT/libraries/fof/view/html.php:5314 FOFViewHtml->__construct() Copy JROOT/libraries/fof/controller/controller.php:280813 FOFController->createView() Copy JROOT/libraries/fof/controller/controller.php:250312 FOFController->getView() Copy JROOT/libraries/fof/controller/controller.php:240511 FOFController->getThisView() Copy JROOT/libraries/fof/controller/controller.php:102510 FOFController->display() Copy JROOT/libraries/fof/controller/controller.php:11659 FOFController->browse() Copy JROOT/libraries/fof/controller/controller.php:9678 FOFController->execute() Copy JROOT/libraries/fof/dispatcher/dispatcher.php:3327 FOFDispatcher->dispatch() Copy JROOT/components/com_splms/splms.php:356 require_once Copy JROOT/components/com_splms/splms.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2671 JApplicationCms->execute() Copy JROOT/index.php:73
クエリ時間：10.69 ms 最後のクエリの後：0.67 ms クエリメモリ：0.065 MB クエリ前のメモリ：20.974 MB 返された行：763
SHOW TABLES クエリではEXPLAINは使用できません：SHOW TABLES
Status Duration checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.05 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.05 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.05 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.05 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.27 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.02 ms closing tables 0.02 ms freeing items 0.09 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 22 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:154221 JDatabaseDriver->loadColumn() Copy JROOT/libraries/joomla/database/driver/mysqli.php:49120 JDatabaseDriverMysqli->getTableList() Copy JROOT/libraries/fof/database/driver/joomla.php:25119 FOFDatabaseDriverJoomla->getTableList() Copy JROOT/libraries/fof/table/table.php:209618 FOFTable->getTableFields() Copy JROOT/libraries/fof/table/table.php:53617 FOFTable->__construct() Copy JROOT/libraries/fof/table/table.php:43316 FOFTable::getAnInstance() Copy JROOT/libraries/fof/model/model.php:210015 FOFModel->_createTable() Copy JROOT/libraries/fof/model/model.php:205714 FOFModel->getTable() Copy JROOT/libraries/fof/view/raw.php:19013 FOFViewRaw->onDisplay() Copy JROOT/libraries/fof/view/raw.php:16712 FOFViewRaw->onBrowse() Copy JROOT/libraries/fof/view/form.php:4711 FOFViewForm->display() Copy JROOT/libraries/fof/controller/controller.php:112510 FOFController->display() Copy JROOT/libraries/fof/controller/controller.php:11659 FOFController->browse() Copy JROOT/libraries/fof/controller/controller.php:9678 FOFController->execute() Copy JROOT/libraries/fof/dispatcher/dispatcher.php:3327 FOFDispatcher->dispatch() Copy JROOT/components/com_splms/splms.php:356 require_once Copy JROOT/components/com_splms/splms.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2671 JApplicationCms->execute() Copy JROOT/index.php:73
クエリ時間：3.02 ms 最後のクエリの後：0.25 ms クエリメモリ：0.034 MB クエリ前のメモリ：21.057 MB 返された行：45
SHOW FULL COLUMNS FROM `joom_splms_courses `クエリではEXPLAINは使用できません：SHOW FULL COLUMNS FROM `joom_splms_courses`
Status Duration starting 0.06 ms Executing hook on transaction 0.01 ms starting 0.06 ms checking permissions 0.01 ms checking permissions 0.00 ms Opening tables 0.51 ms init 0.01 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.15 ms preparing 0.07 ms Creating tmp table 0.05 ms executing 0.09 ms checking permissions 0.07 ms checking permissions 0.03 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.03 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.03 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.03 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.03 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.07 ms checking permissions 0.03 ms checking permissions 0.03 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.03 ms checking permissions 0.01 ms checking permissions 0.08 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.02 ms closing tables 0.02 ms freeing items 0.06 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 22 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:169321 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/joomla/database/driver/mysqli.php:43520 JDatabaseDriverMysqli->getTableColumns() Copy JROOT/libraries/fof/database/driver/joomla.php:22919 FOFDatabaseDriverJoomla->getTableColumns() Copy JROOT/libraries/fof/table/table.php:218118 FOFTable->getTableFields() Copy JROOT/libraries/fof/table/table.php:53617 FOFTable->__construct() Copy JROOT/libraries/fof/table/table.php:43316 FOFTable::getAnInstance() Copy JROOT/libraries/fof/model/model.php:210015 FOFModel->_createTable() Copy JROOT/libraries/fof/model/model.php:205714 FOFModel->getTable() Copy JROOT/libraries/fof/view/raw.php:19013 FOFViewRaw->onDisplay() Copy JROOT/libraries/fof/view/raw.php:16712 FOFViewRaw->onBrowse() Copy JROOT/libraries/fof/view/form.php:4711 FOFViewForm->display() Copy JROOT/libraries/fof/controller/controller.php:112510 FOFController->display() Copy JROOT/libraries/fof/controller/controller.php:11659 FOFController->browse() Copy JROOT/libraries/fof/controller/controller.php:9678 FOFController->execute() Copy JROOT/libraries/fof/dispatcher/dispatcher.php:3327 FOFDispatcher->dispatch() Copy JROOT/components/com_splms/splms.php:356 require_once Copy JROOT/components/com_splms/splms.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2671 JApplicationCms->execute() Copy JROOT/index.php:73
クエリ時間：1.13 ms 最後のクエリの後：0.84 ms クエリメモリ：0.026 MB クエリ前のメモリ：21.211 MB 返された行：2
SELECT *
FROM `joom_splms_coursescategories `
WHERE enabled = 1 AND ( ( brand_specific = 1 AND FIND_IN_SET ( 1, brands ) > 0 ) OR ( brand_specific = 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' OR access_type IS NULL ) )
ORDER BY ordering ASC クエリではEXPLAINは使用できません：SELECT *
FROM `joom_splms_coursescategories`
WHERE enabled = 1 AND ( ( brand_specific = 1 AND FIND_IN_SET( 1, brands ) > 0 ) OR ( brand_specific = 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' OR access_type IS NULL ) )
ORDER BY ordering ASC
Status Duration starting 0.10 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.05 ms init 0.01 ms System lock 0.01 ms optimizing 0.05 ms statistics 0.03 ms preparing 0.07 ms executing 0.09 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.02 ms
# 発信者 ファイルと行番号 19 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:169318 JDatabaseDriver->loadObjectList() Copy JROOT/components/com_splms/models/courses.php:58917 SplmsModelCourses->getAllCategories() Copy JROOT/components/com_splms/models/courses.php:10816 SplmsModelCourses->getCategoryConditions() Copy JROOT/components/com_splms/models/courses.php:16415 SplmsModelCourses->getAllCourses() Copy JROOT/components/com_splms/models/courses.php:9014 SplmsModelCourses->getItemList() Copy JROOT/libraries/fof/view/raw.php:19813 FOFViewRaw->onDisplay() Copy JROOT/libraries/fof/view/raw.php:16712 FOFViewRaw->onBrowse() Copy JROOT/libraries/fof/view/form.php:4711 FOFViewForm->display() Copy JROOT/libraries/fof/controller/controller.php:112510 FOFController->display() Copy JROOT/libraries/fof/controller/controller.php:11659 FOFController->browse() Copy JROOT/libraries/fof/controller/controller.php:9678 FOFController->execute() Copy JROOT/libraries/fof/dispatcher/dispatcher.php:3327 FOFDispatcher->dispatch() Copy JROOT/components/com_splms/splms.php:356 require_once Copy JROOT/components/com_splms/splms.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2671 JApplicationCms->execute() Copy JROOT/index.php:73
クエリ時間：1.40 ms 最後のクエリの後：0.07 ms クエリメモリ：0.048 MB クエリ前のメモリ：21.220 MB 返された行：7
SELECT *
FROM `joom_splms_courses `
WHERE `enabled`= 1 AND (brand_specific = 0 OR (brand_specific = 1 AND FIND_IN_SET (1,brands))) AND (course_visible_before_open = 1 OR course_open_date IS NULL OR course_open_date = '0000-00-00' OR (DATE (NOW ()) >= course_open_date)) AND (course_visible_after_close = 1 OR course_close_date IS NULL OR course_close_date = '0000-00-00' OR (DATE (NOW ()) <= course_close_date)) 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' OR access_type IS NULL ) ) AND ((FIND_IN_SET ('1', splms_coursescategory_id) > 0)OR (FIND_IN_SET ('6', splms_coursescategory_id) > 0)) AND ( ( brand_specific = 1 AND FIND_IN_SET ( 1, brands ) > 0 ) OR ( brand_specific = 0 ))
ORDER BY ordering ASC LIMIT 32クエリではEXPLAINは使用できません：SELECT *
FROM `joom_splms_courses`
WHERE `enabled`=1 AND (brand_specific = 0 OR (brand_specific = 1 AND FIND_IN_SET(1,brands))) AND (course_visible_before_open = 1 OR course_open_date IS NULL OR course_open_date = '0000-00-00' OR (DATE(NOW()) >= course_open_date)) AND (course_visible_after_close = 1 OR course_close_date IS NULL OR course_close_date = '0000-00-00' OR (DATE(NOW()) <= course_close_date)) 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' OR access_type IS NULL ) ) AND ((FIND_IN_SET('1', splms_coursescategory_id) > 0)OR(FIND_IN_SET('6', splms_coursescategory_id) > 0)) AND ( ( brand_specific = 1 AND FIND_IN_SET( 1, brands ) > 0 ) OR ( brand_specific = 0 ))
ORDER BY ordering ASC LIMIT 32
Status Duration starting 0.13 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.05 ms statistics 0.08 ms preparing 0.08 ms executing 0.23 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
# 発信者 ファイルと行番号 17 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:169316 JDatabaseDriver->loadObjectList() Copy JROOT/components/com_splms/models/courses.php:17915 SplmsModelCourses->getAllCourses() Copy JROOT/components/com_splms/models/courses.php:9014 SplmsModelCourses->getItemList() Copy JROOT/libraries/fof/view/raw.php:19813 FOFViewRaw->onDisplay() Copy JROOT/libraries/fof/view/raw.php:16712 FOFViewRaw->onBrowse() Copy JROOT/libraries/fof/view/form.php:4711 FOFViewForm->display() Copy JROOT/libraries/fof/controller/controller.php:112510 FOFController->display() Copy JROOT/libraries/fof/controller/controller.php:11659 FOFController->browse() Copy JROOT/libraries/fof/controller/controller.php:9678 FOFController->execute() Copy JROOT/libraries/fof/dispatcher/dispatcher.php:3327 FOFDispatcher->dispatch() Copy JROOT/components/com_splms/splms.php:356 require_once Copy JROOT/components/com_splms/splms.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2671 JApplicationCms->execute() Copy JROOT/index.php:73
クエリ時間：1.31 ms 最後のクエリの後：0.08 ms クエリメモリ：0.024 MB クエリ前のメモリ：21.262 MB 返された行：1
SELECT COUNT (* ) as total
FROM `joom_splms_courses `
WHERE `enabled`= 1 AND (brand_specific = 0 OR (brand_specific = 1 AND FIND_IN_SET (1,brands))) AND (course_visible_before_open = 1 OR course_open_date IS NULL OR course_open_date = '0000-00-00' OR (DATE (NOW ()) >= course_open_date)) AND (course_visible_after_close = 1 OR course_close_date IS NULL OR course_close_date = '0000-00-00' OR (DATE (NOW ()) <= course_close_date)) 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' OR access_type IS NULL ) ) AND ((FIND_IN_SET ('1', splms_coursescategory_id) > 0)OR (FIND_IN_SET ('6', splms_coursescategory_id) > 0)) AND ( ( brand_specific = 1 AND FIND_IN_SET ( 1, brands ) > 0 ) OR ( brand_specific = 0 ))クエリではEXPLAINは使用できません：SELECT COUNT(*) as total
FROM `joom_splms_courses`
WHERE `enabled`=1 AND (brand_specific = 0 OR (brand_specific = 1 AND FIND_IN_SET(1,brands))) AND (course_visible_before_open = 1 OR course_open_date IS NULL OR course_open_date = '0000-00-00' OR (DATE(NOW()) >= course_open_date)) AND (course_visible_after_close = 1 OR course_close_date IS NULL OR course_close_date = '0000-00-00' OR (DATE(NOW()) <= course_close_date)) 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' OR access_type IS NULL ) ) AND ((FIND_IN_SET('1', splms_coursescategory_id) > 0)OR(FIND_IN_SET('6', splms_coursescategory_id) > 0)) AND ( ( brand_specific = 1 AND FIND_IN_SET( 1, brands ) > 0 ) OR ( brand_specific = 0 ))
Status Duration starting 0.12 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.06 ms init 0.01 ms System lock 0.01 ms optimizing 0.06 ms statistics 0.07 ms preparing 0.04 ms executing 0.09 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 17 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:165416 JDatabaseDriver->loadObject() Copy JROOT/components/com_splms/models/courses.php:18615 SplmsModelCourses->getAllCourses() Copy JROOT/components/com_splms/models/courses.php:9014 SplmsModelCourses->getItemList() Copy JROOT/libraries/fof/view/raw.php:19813 FOFViewRaw->onDisplay() Copy JROOT/libraries/fof/view/raw.php:16712 FOFViewRaw->onBrowse() Copy JROOT/libraries/fof/view/form.php:4711 FOFViewForm->display() Copy JROOT/libraries/fof/controller/controller.php:112510 FOFController->display() Copy JROOT/libraries/fof/controller/controller.php:11659 FOFController->browse() Copy JROOT/libraries/fof/controller/controller.php:9678 FOFController->execute() Copy JROOT/libraries/fof/dispatcher/dispatcher.php:3327 FOFDispatcher->dispatch() Copy JROOT/components/com_splms/splms.php:356 require_once Copy JROOT/components/com_splms/splms.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2671 JApplicationCms->execute() Copy JROOT/index.php:73
クエリ時間：0.92 ms 最後のクエリの後：8.09 ms クエリメモリ：0.026 MB クエリ前のメモリ：21.798 MB 返された行：0
SELECT id
FROM axs_starred
WHERE user_id = '0' AND uri = '/ja/courses-page'クエリではEXPLAINは使用できません：SELECT id
FROM axs_starred
WHERE user_id = '0' AND uri = '/ja/courses-page'
Status Duration starting 0.04 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.06 ms preparing 0.02 ms executing 0.02 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.05 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 18 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:165417 JDatabaseDriver->loadObject() Copy JROOT/libraries/axslibs/topbar.php:8216 AxsTopBar::getStarredId() Copy JROOT/administrator/includes/toolbar.php:5215 JToolbarHelper::title() Copy JROOT/administrator/components/com_splms/toolbar.php:5914 SplmsToolbar->onCoursesBrowse() Copy JROOT/libraries/fof/toolbar/toolbar.php:30813 FOFToolbar->renderToolbar() Copy JROOT/libraries/fof/view/html.php:7312 FOFViewHtml->preRender() Copy JROOT/libraries/fof/view/form.php:6311 FOFViewForm->display() Copy JROOT/libraries/fof/controller/controller.php:112510 FOFController->display() Copy JROOT/libraries/fof/controller/controller.php:11659 FOFController->browse() Copy JROOT/libraries/fof/controller/controller.php:9678 FOFController->execute() Copy JROOT/libraries/fof/dispatcher/dispatcher.php:3327 FOFDispatcher->dispatch() Copy JROOT/components/com_splms/splms.php:356 require_once Copy JROOT/components/com_splms/splms.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2671 JApplicationCms->execute() Copy JROOT/index.php:73
クエリ時間：1.13 ms 最後のクエリの後：12.08 ms クエリメモリ：0.024 MB クエリ前のメモリ：22.687 MB 返された行：2
SELECT *
FROM `joom_splms_coursescategories `
WHERE enabled = 1 AND ( ( brand_specific = 1 AND FIND_IN_SET ( 1, brands ) > 0 ) OR ( brand_specific = 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' OR access_type IS NULL ) )
ORDER BY ordering ASC クエリではEXPLAINは使用できません：SELECT *
FROM `joom_splms_coursescategories`
WHERE enabled = 1 AND ( ( brand_specific = 1 AND FIND_IN_SET( 1, brands ) > 0 ) OR ( brand_specific = 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' OR access_type IS NULL ) )
ORDER BY ordering ASC
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.06 ms init 0.01 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.03 ms preparing 0.05 ms executing 0.10 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
# 発信者 ファイルと行番号 16 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:169315 JDatabaseDriver->loadObjectList() Copy JROOT/components/com_splms/models/courses.php:58914 SplmsModelCourses->getAllCategories() Copy JROOT/components/com_splms/views/courses/tmpl/default.php:35713 include Copy JROOT/components/com_splms/views/courses/tmpl/default.php Copy JROOT/libraries/fof/view/view.php:44212 FOFView->loadAnyTemplate() Copy JROOT/libraries/fof/view/form.php:7611 FOFViewForm->display() Copy JROOT/libraries/fof/controller/controller.php:112510 FOFController->display() Copy JROOT/libraries/fof/controller/controller.php:11659 FOFController->browse() Copy JROOT/libraries/fof/controller/controller.php:9678 FOFController->execute() Copy JROOT/libraries/fof/dispatcher/dispatcher.php:3327 FOFDispatcher->dispatch() Copy JROOT/components/com_splms/splms.php:356 require_once Copy JROOT/components/com_splms/splms.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2671 JApplicationCms->execute() Copy JROOT/index.php:73
クエリ時間：0.87 ms 最後のクエリの後：0.32 ms クエリメモリ：0.023 MB クエリ前のメモリ：22.711 MB 返された行：0
SELECT * FROM `joom_splms_course_wishlist ` WHERE `user_id`= 0;クエリではEXPLAINは使用できません：SELECT * FROM `joom_splms_course_wishlist` WHERE `user_id`=0;
Status Duration starting 0.04 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.02 ms executing 0.02 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 16 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:169315 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/axslibs/lms.php:360614 AxsLMS::getUserAllCourses() Copy JROOT/components/com_splms/views/courses/tmpl/default.php:45013 include Copy JROOT/components/com_splms/views/courses/tmpl/default.php Copy JROOT/libraries/fof/view/view.php:44212 FOFView->loadAnyTemplate() Copy JROOT/libraries/fof/view/form.php:7611 FOFViewForm->display() Copy JROOT/libraries/fof/controller/controller.php:112510 FOFController->display() Copy JROOT/libraries/fof/controller/controller.php:11659 FOFController->browse() Copy JROOT/libraries/fof/controller/controller.php:9678 FOFController->execute() Copy JROOT/libraries/fof/dispatcher/dispatcher.php:3327 FOFDispatcher->dispatch() Copy JROOT/components/com_splms/splms.php:356 require_once Copy JROOT/components/com_splms/splms.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2671 JApplicationCms->execute() Copy JROOT/index.php:73
クエリ時間：1.01 ms 最後のクエリの後：0.02 ms クエリメモリ：0.023 MB クエリ前のメモリ：22.718 MB 返された行：0
SELECT * FROM `axs_course_purchases` WHERE user_id= 0 AND status= 'PAID ' OR status= 'PART ';クエリではEXPLAINは使用できません：SELECT * FROM `axs_course_purchases` WHERE user_id=0 AND status='PAID' OR status='PART';
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.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.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
# 発信者 ファイルと行番号 16 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:169315 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/axslibs/lms.php:369214 AxsLMS::getUserAllCourses() Copy JROOT/components/com_splms/views/courses/tmpl/default.php:45013 include Copy JROOT/components/com_splms/views/courses/tmpl/default.php Copy JROOT/libraries/fof/view/view.php:44212 FOFView->loadAnyTemplate() Copy JROOT/libraries/fof/view/form.php:7611 FOFViewForm->display() Copy JROOT/libraries/fof/controller/controller.php:112510 FOFController->display() Copy JROOT/libraries/fof/controller/controller.php:11659 FOFController->browse() Copy JROOT/libraries/fof/controller/controller.php:9678 FOFController->execute() Copy JROOT/libraries/fof/dispatcher/dispatcher.php:3327 FOFDispatcher->dispatch() Copy JROOT/components/com_splms/splms.php:356 require_once Copy JROOT/components/com_splms/splms.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2671 JApplicationCms->execute() Copy JROOT/index.php:73
クエリ時間：0.99 ms 最後のクエリの後：0.02 ms クエリメモリ：0.023 MB クエリ前のメモリ：22.726 MB 返された行：0
SELECT * FROM `joom_splms_course_progress ` WHERE archive_date IS NULL AND `user_id`= 0 GROUP BY user_id, course_id;クエリではEXPLAINは使用できません：SELECT * FROM `joom_splms_course_progress` WHERE archive_date IS NULL AND `user_id`=0 GROUP BY user_id, course_id;
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.04 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.07 ms preparing 0.02 ms Creating tmp table 0.04 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
# 発信者 ファイルと行番号 16 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:169315 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/axslibs/lms.php:372314 AxsLMS::getUserAllCourses() Copy JROOT/components/com_splms/views/courses/tmpl/default.php:45013 include Copy JROOT/components/com_splms/views/courses/tmpl/default.php Copy JROOT/libraries/fof/view/view.php:44212 FOFView->loadAnyTemplate() Copy JROOT/libraries/fof/view/form.php:7611 FOFViewForm->display() Copy JROOT/libraries/fof/controller/controller.php:112510 FOFController->display() Copy JROOT/libraries/fof/controller/controller.php:11659 FOFController->browse() Copy JROOT/libraries/fof/controller/controller.php:9678 FOFController->execute() Copy JROOT/libraries/fof/dispatcher/dispatcher.php:3327 FOFDispatcher->dispatch() Copy JROOT/components/com_splms/splms.php:356 require_once Copy JROOT/components/com_splms/splms.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2671 JApplicationCms->execute() Copy JROOT/index.php:73
クエリ時間：0.81 ms 最後のクエリの後：0.03 ms クエリメモリ：0.024 MB クエリ前のメモリ：22.734 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.04 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.01 ms executing 0.01 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms
# 発信者 ファイルと行番号 17 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:165416 JDatabaseDriver->loadObject() Copy JROOT/libraries/axslibs/language.php:28515 AxsLanguage::getSefByLangCode() Copy JROOT/components/com_splms/models/courses.php:130714 SplmsModelCourses::setOverrides() Copy JROOT/components/com_splms/views/courses/tmpl/default.php:45613 include Copy JROOT/components/com_splms/views/courses/tmpl/default.php Copy JROOT/libraries/fof/view/view.php:44212 FOFView->loadAnyTemplate() Copy JROOT/libraries/fof/view/form.php:7611 FOFViewForm->display() Copy JROOT/libraries/fof/controller/controller.php:112510 FOFController->display() Copy JROOT/libraries/fof/controller/controller.php:11659 FOFController->browse() Copy JROOT/libraries/fof/controller/controller.php:9678 FOFController->execute() Copy JROOT/libraries/fof/dispatcher/dispatcher.php:3327 FOFDispatcher->dispatch() Copy JROOT/components/com_splms/splms.php:356 require_once Copy JROOT/components/com_splms/splms.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2671 JApplicationCms->execute() Copy JROOT/index.php:73
クエリ時間：1.24 ms 最後のクエリの後：0.36 ms クエリメモリ：0.023 MB クエリ前のメモリ：22.776 MB 返された行：0
SELECT *
FROM `joom_splms_lessons `
WHERE `enabled`= '1' AND `splms_course_id`= '1' AND `language`= 'ja-JA '
ORDER BY ordering ASC クエリではEXPLAINは使用できません：SELECT *
FROM `joom_splms_lessons`
WHERE `enabled`='1' AND `splms_course_id`='1' AND `language`='ja-JA'
ORDER BY ordering ASC
Status Duration starting 0.04 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.04 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.07 ms preparing 0.03 ms executing 0.09 ms end 0.05 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
# 発信者 ファイルと行番号 16 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:169315 JDatabaseDriver->loadObjectList() Copy JROOT/components/com_splms/models/lessons.php:25614 SplmsModelLessons::getLessons() Copy JROOT/components/com_splms/views/courses/tmpl/default.php:46813 include Copy JROOT/components/com_splms/views/courses/tmpl/default.php Copy JROOT/libraries/fof/view/view.php:44212 FOFView->loadAnyTemplate() Copy JROOT/libraries/fof/view/form.php:7611 FOFViewForm->display() Copy JROOT/libraries/fof/controller/controller.php:112510 FOFController->display() Copy JROOT/libraries/fof/controller/controller.php:11659 FOFController->browse() Copy JROOT/libraries/fof/controller/controller.php:9678 FOFController->execute() Copy JROOT/libraries/fof/dispatcher/dispatcher.php:3327 FOFDispatcher->dispatch() Copy JROOT/components/com_splms/splms.php:356 require_once Copy JROOT/components/com_splms/splms.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2671 JApplicationCms->execute() Copy JROOT/index.php:73
クエリ時間：1.08 ms 最後のクエリの後：7.10 ms クエリメモリ：0.023 MB クエリ前のメモリ：23.881 MB 返された行：0
SELECT event_id
FROM joom_splms_courses_events ce
LEFT JOIN joom_eb_events e ON e.id = ce.event_id
WHERE ce.course_id = 1 AND e.published = 1クエリではEXPLAINは使用できません：SELECT event_id
FROM joom_splms_courses_events ce
LEFT JOIN joom_eb_events e ON e.id = ce.event_id
WHERE ce.course_id = 1 AND e.published = 1
Status Duration starting 0.10 ms Executing hook on transaction 0.01 ms starting 0.02 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.05 ms init 0.01 ms System lock 0.05 ms optimizing 0.01 ms statistics 0.08 ms preparing 0.04 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.01 ms
# 発信者 ファイルと行番号 16 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:154215 JDatabaseDriver->loadColumn() Copy JROOT/libraries/axslibs/events.php:23714 AxsEvents::getCourseEvents() Copy JROOT/components/com_splms/views/courses/tmpl/default.php:46913 include Copy JROOT/components/com_splms/views/courses/tmpl/default.php Copy JROOT/libraries/fof/view/view.php:44212 FOFView->loadAnyTemplate() Copy JROOT/libraries/fof/view/form.php:7611 FOFViewForm->display() Copy JROOT/libraries/fof/controller/controller.php:112510 FOFController->display() Copy JROOT/libraries/fof/controller/controller.php:11659 FOFController->browse() Copy JROOT/libraries/fof/controller/controller.php:9678 FOFController->execute() Copy JROOT/libraries/fof/dispatcher/dispatcher.php:3327 FOFDispatcher->dispatch() Copy JROOT/components/com_splms/splms.php:356 require_once Copy JROOT/components/com_splms/splms.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2671 JApplicationCms->execute() Copy JROOT/index.php:73
クエリ時間：1.14 ms 最後のクエリの後：0.05 ms クエリメモリ：0.024 MB クエリ前のメモリ：23.888 MB 返された行：0
SELECT *
FROM `joom_splms_lessons `
WHERE `splms_course_id`= 1 AND `enabled`= 1 AND `language`= 'ja-JA 'クエリではEXPLAINは使用できません：SELECT *
FROM `joom_splms_lessons`
WHERE `splms_course_id`=1 AND `enabled`= 1 AND `language`='ja-JA'
Status Duration starting 0.05 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.06 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.09 ms preparing 0.03 ms executing 0.18 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.02 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 17 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:169316 JDatabaseDriver->loadObjectList() Copy JROOT/components/com_splms/models/courses.php:107415 SplmsModelCourses->getLessons() Copy JROOT/components/com_splms/models/courses.php:68914 SplmsModelCourses->getCourseTeachers() Copy JROOT/components/com_splms/views/courses/tmpl/default.php:47513 include Copy JROOT/components/com_splms/views/courses/tmpl/default.php Copy JROOT/libraries/fof/view/view.php:44212 FOFView->loadAnyTemplate() Copy JROOT/libraries/fof/view/form.php:7611 FOFViewForm->display() Copy JROOT/libraries/fof/controller/controller.php:112510 FOFController->display() Copy JROOT/libraries/fof/controller/controller.php:11659 FOFController->browse() Copy JROOT/libraries/fof/controller/controller.php:9678 FOFController->execute() Copy JROOT/libraries/fof/dispatcher/dispatcher.php:3327 FOFDispatcher->dispatch() Copy JROOT/components/com_splms/splms.php:356 require_once Copy JROOT/components/com_splms/splms.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2671 JApplicationCms->execute() Copy JROOT/index.php:73
クエリ時間：1.19 ms 最後のクエリの後：66.60 ms クエリメモリ：0.023 MB クエリ前のメモリ：24.114 MB 返された行：0
SELECT *
FROM `joom_splms_lessons `
WHERE `enabled`= '1' AND `splms_course_id`= '2' AND `language`= 'ja-JA '
ORDER BY ordering ASC クエリではEXPLAINは使用できません：SELECT *
FROM `joom_splms_lessons`
WHERE `enabled`='1' AND `splms_course_id`='2' AND `language`='ja-JA'
ORDER BY ordering 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.05 ms init 0.01 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.09 ms preparing 0.03 ms executing 0.09 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.03 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 16 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:169315 JDatabaseDriver->loadObjectList() Copy JROOT/components/com_splms/models/lessons.php:25614 SplmsModelLessons::getLessons() Copy JROOT/components/com_splms/views/courses/tmpl/default.php:46813 include Copy JROOT/components/com_splms/views/courses/tmpl/default.php Copy JROOT/libraries/fof/view/view.php:44212 FOFView->loadAnyTemplate() Copy JROOT/libraries/fof/view/form.php:7611 FOFViewForm->display() Copy JROOT/libraries/fof/controller/controller.php:112510 FOFController->display() Copy JROOT/libraries/fof/controller/controller.php:11659 FOFController->browse() Copy JROOT/libraries/fof/controller/controller.php:9678 FOFController->execute() Copy JROOT/libraries/fof/dispatcher/dispatcher.php:3327 FOFDispatcher->dispatch() Copy JROOT/components/com_splms/splms.php:356 require_once Copy JROOT/components/com_splms/splms.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2671 JApplicationCms->execute() Copy JROOT/index.php:73
クエリ時間：0.91 ms 最後のクエリの後：0.05 ms クエリメモリ：0.023 MB クエリ前のメモリ：24.120 MB 返された行：0
SELECT event_id
FROM joom_splms_courses_events ce
LEFT JOIN joom_eb_events e ON e.id = ce.event_id
WHERE ce.course_id = 2 AND e.published = 1クエリではEXPLAINは使用できません：SELECT event_id
FROM joom_splms_courses_events ce
LEFT JOIN joom_eb_events e ON e.id = ce.event_id
WHERE ce.course_id = 2 AND e.published = 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.04 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.02 ms executing 0.02 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 16 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:154215 JDatabaseDriver->loadColumn() Copy JROOT/libraries/axslibs/events.php:23714 AxsEvents::getCourseEvents() Copy JROOT/components/com_splms/views/courses/tmpl/default.php:46913 include Copy JROOT/components/com_splms/views/courses/tmpl/default.php Copy JROOT/libraries/fof/view/view.php:44212 FOFView->loadAnyTemplate() Copy JROOT/libraries/fof/view/form.php:7611 FOFViewForm->display() Copy JROOT/libraries/fof/controller/controller.php:112510 FOFController->display() Copy JROOT/libraries/fof/controller/controller.php:11659 FOFController->browse() Copy JROOT/libraries/fof/controller/controller.php:9678 FOFController->execute() Copy JROOT/libraries/fof/dispatcher/dispatcher.php:3327 FOFDispatcher->dispatch() Copy JROOT/components/com_splms/splms.php:356 require_once Copy JROOT/components/com_splms/splms.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2671 JApplicationCms->execute() Copy JROOT/index.php:73
クエリ時間：0.98 ms 最後のクエリの後：0.05 ms クエリメモリ：0.024 MB クエリ前のメモリ：24.127 MB 返された行：0
SELECT *
FROM `joom_splms_lessons `
WHERE `splms_course_id`= 2 AND `enabled`= 1 AND `language`= 'ja-JA 'クエリではEXPLAINは使用できません：SELECT *
FROM `joom_splms_lessons`
WHERE `splms_course_id`=2 AND `enabled`= 1 AND `language`='ja-JA'
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.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.07 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.02 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 17 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:169316 JDatabaseDriver->loadObjectList() Copy JROOT/components/com_splms/models/courses.php:107415 SplmsModelCourses->getLessons() Copy JROOT/components/com_splms/models/courses.php:68914 SplmsModelCourses->getCourseTeachers() Copy JROOT/components/com_splms/views/courses/tmpl/default.php:47513 include Copy JROOT/components/com_splms/views/courses/tmpl/default.php Copy JROOT/libraries/fof/view/view.php:44212 FOFView->loadAnyTemplate() Copy JROOT/libraries/fof/view/form.php:7611 FOFViewForm->display() Copy JROOT/libraries/fof/controller/controller.php:112510 FOFController->display() Copy JROOT/libraries/fof/controller/controller.php:11659 FOFController->browse() Copy JROOT/libraries/fof/controller/controller.php:9678 FOFController->execute() Copy JROOT/libraries/fof/dispatcher/dispatcher.php:3327 FOFDispatcher->dispatch() Copy JROOT/components/com_splms/splms.php:356 require_once Copy JROOT/components/com_splms/splms.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2671 JApplicationCms->execute() Copy JROOT/index.php:73
クエリ時間：1.29 ms 最後のクエリの後：0.58 ms クエリメモリ：0.023 MB クエリ前のメモリ：24.150 MB 返された行：0
SELECT *
FROM `joom_splms_lessons `
WHERE `enabled`= '1' AND `splms_course_id`= '4' AND `language`= 'ja-JA '
ORDER BY ordering ASC クエリではEXPLAINは使用できません：SELECT *
FROM `joom_splms_lessons`
WHERE `enabled`='1' AND `splms_course_id`='4' AND `language`='ja-JA'
ORDER BY ordering ASC
Status Duration starting 0.05 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.04 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 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
# 発信者 ファイルと行番号 16 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:169315 JDatabaseDriver->loadObjectList() Copy JROOT/components/com_splms/models/lessons.php:25614 SplmsModelLessons::getLessons() Copy JROOT/components/com_splms/views/courses/tmpl/default.php:46813 include Copy JROOT/components/com_splms/views/courses/tmpl/default.php Copy JROOT/libraries/fof/view/view.php:44212 FOFView->loadAnyTemplate() Copy JROOT/libraries/fof/view/form.php:7611 FOFViewForm->display() Copy JROOT/libraries/fof/controller/controller.php:112510 FOFController->display() Copy JROOT/libraries/fof/controller/controller.php:11659 FOFController->browse() Copy JROOT/libraries/fof/controller/controller.php:9678 FOFController->execute() Copy JROOT/libraries/fof/dispatcher/dispatcher.php:3327 FOFDispatcher->dispatch() Copy JROOT/components/com_splms/splms.php:356 require_once Copy JROOT/components/com_splms/splms.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2671 JApplicationCms->execute() Copy JROOT/index.php:73
クエリ時間：1.61 ms 最後のクエリの後：0.04 ms クエリメモリ：0.023 MB クエリ前のメモリ：24.157 MB 返された行：0
SELECT event_id
FROM joom_splms_courses_events ce
LEFT JOIN joom_eb_events e ON e.id = ce.event_id
WHERE ce.course_id = 4 AND e.published = 1クエリではEXPLAINは使用できません：SELECT event_id
FROM joom_splms_courses_events ce
LEFT JOIN joom_eb_events e ON e.id = ce.event_id
WHERE ce.course_id = 4 AND e.published = 1
Status Duration starting 0.05 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.04 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.00 ms
# 発信者 ファイルと行番号 16 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:154215 JDatabaseDriver->loadColumn() Copy JROOT/libraries/axslibs/events.php:23714 AxsEvents::getCourseEvents() Copy JROOT/components/com_splms/views/courses/tmpl/default.php:46913 include Copy JROOT/components/com_splms/views/courses/tmpl/default.php Copy JROOT/libraries/fof/view/view.php:44212 FOFView->loadAnyTemplate() Copy JROOT/libraries/fof/view/form.php:7611 FOFViewForm->display() Copy JROOT/libraries/fof/controller/controller.php:112510 FOFController->display() Copy JROOT/libraries/fof/controller/controller.php:11659 FOFController->browse() Copy JROOT/libraries/fof/controller/controller.php:9678 FOFController->execute() Copy JROOT/libraries/fof/dispatcher/dispatcher.php:3327 FOFDispatcher->dispatch() Copy JROOT/components/com_splms/splms.php:356 require_once Copy JROOT/components/com_splms/splms.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2671 JApplicationCms->execute() Copy JROOT/index.php:73
クエリ時間：1.32 ms 最後のクエリの後：0.06 ms クエリメモリ：0.024 MB クエリ前のメモリ：24.164 MB 返された行：0
SELECT *
FROM `joom_splms_lessons `
WHERE `splms_course_id`= 4 AND `enabled`= 1 AND `language`= 'ja-JA 'クエリではEXPLAINは使用できません：SELECT *
FROM `joom_splms_lessons`
WHERE `splms_course_id`=4 AND `enabled`= 1 AND `language`='ja-JA'
Status Duration starting 0.05 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.04 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.09 ms preparing 0.03 ms executing 0.08 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
# 発信者 ファイルと行番号 17 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:169316 JDatabaseDriver->loadObjectList() Copy JROOT/components/com_splms/models/courses.php:107415 SplmsModelCourses->getLessons() Copy JROOT/components/com_splms/models/courses.php:68914 SplmsModelCourses->getCourseTeachers() Copy JROOT/components/com_splms/views/courses/tmpl/default.php:47513 include Copy JROOT/components/com_splms/views/courses/tmpl/default.php Copy JROOT/libraries/fof/view/view.php:44212 FOFView->loadAnyTemplate() Copy JROOT/libraries/fof/view/form.php:7611 FOFViewForm->display() Copy JROOT/libraries/fof/controller/controller.php:112510 FOFController->display() Copy JROOT/libraries/fof/controller/controller.php:11659 FOFController->browse() Copy JROOT/libraries/fof/controller/controller.php:9678 FOFController->execute() Copy JROOT/libraries/fof/dispatcher/dispatcher.php:3327 FOFDispatcher->dispatch() Copy JROOT/components/com_splms/splms.php:356 require_once Copy JROOT/components/com_splms/splms.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2671 JApplicationCms->execute() Copy JROOT/index.php:73
クエリ時間：1.75 ms 最後のクエリの後：0.63 ms クエリメモリ：0.023 MB クエリ前のメモリ：24.186 MB 返された行：0
SELECT *
FROM `joom_splms_lessons `
WHERE `enabled`= '1' AND `splms_course_id`= '5' AND `language`= 'ja-JA '
ORDER BY ordering ASC クエリではEXPLAINは使用できません：SELECT *
FROM `joom_splms_lessons`
WHERE `enabled`='1' AND `splms_course_id`='5' AND `language`='ja-JA'
ORDER BY ordering ASC
Status Duration starting 0.04 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.56 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.02 ms executing 0.07 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.02 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 16 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:169315 JDatabaseDriver->loadObjectList() Copy JROOT/components/com_splms/models/lessons.php:25614 SplmsModelLessons::getLessons() Copy JROOT/components/com_splms/views/courses/tmpl/default.php:46813 include Copy JROOT/components/com_splms/views/courses/tmpl/default.php Copy JROOT/libraries/fof/view/view.php:44212 FOFView->loadAnyTemplate() Copy JROOT/libraries/fof/view/form.php:7611 FOFViewForm->display() Copy JROOT/libraries/fof/controller/controller.php:112510 FOFController->display() Copy JROOT/libraries/fof/controller/controller.php:11659 FOFController->browse() Copy JROOT/libraries/fof/controller/controller.php:9678 FOFController->execute() Copy JROOT/libraries/fof/dispatcher/dispatcher.php:3327 FOFDispatcher->dispatch() Copy JROOT/components/com_splms/splms.php:356 require_once Copy JROOT/components/com_splms/splms.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2671 JApplicationCms->execute() Copy JROOT/index.php:73
クエリ時間：1.24 ms 最後のクエリの後：0.05 ms クエリメモリ：0.023 MB クエリ前のメモリ：24.193 MB 返された行：0
SELECT event_id
FROM joom_splms_courses_events ce
LEFT JOIN joom_eb_events e ON e.id = ce.event_id
WHERE ce.course_id = 5 AND e.published = 1クエリではEXPLAINは使用できません：SELECT event_id
FROM joom_splms_courses_events ce
LEFT JOIN joom_eb_events e ON e.id = ce.event_id
WHERE ce.course_id = 5 AND e.published = 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.04 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.02 ms executing 0.02 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 16 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:154215 JDatabaseDriver->loadColumn() Copy JROOT/libraries/axslibs/events.php:23714 AxsEvents::getCourseEvents() Copy JROOT/components/com_splms/views/courses/tmpl/default.php:46913 include Copy JROOT/components/com_splms/views/courses/tmpl/default.php Copy JROOT/libraries/fof/view/view.php:44212 FOFView->loadAnyTemplate() Copy JROOT/libraries/fof/view/form.php:7611 FOFViewForm->display() Copy JROOT/libraries/fof/controller/controller.php:112510 FOFController->display() Copy JROOT/libraries/fof/controller/controller.php:11659 FOFController->browse() Copy JROOT/libraries/fof/controller/controller.php:9678 FOFController->execute() Copy JROOT/libraries/fof/dispatcher/dispatcher.php:3327 FOFDispatcher->dispatch() Copy JROOT/components/com_splms/splms.php:356 require_once Copy JROOT/components/com_splms/splms.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2671 JApplicationCms->execute() Copy JROOT/index.php:73
クエリ時間：0.96 ms 最後のクエリの後：0.04 ms クエリメモリ：0.024 MB クエリ前のメモリ：24.200 MB 返された行：0
SELECT *
FROM `joom_splms_lessons `
WHERE `splms_course_id`= 5 AND `enabled`= 1 AND `language`= 'ja-JA 'クエリではEXPLAINは使用できません：SELECT *
FROM `joom_splms_lessons`
WHERE `splms_course_id`=5 AND `enabled`= 1 AND `language`='ja-JA'
Status Duration starting 0.04 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.06 ms preparing 0.02 ms executing 0.07 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.02 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 17 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:169316 JDatabaseDriver->loadObjectList() Copy JROOT/components/com_splms/models/courses.php:107415 SplmsModelCourses->getLessons() Copy JROOT/components/com_splms/models/courses.php:68914 SplmsModelCourses->getCourseTeachers() Copy JROOT/components/com_splms/views/courses/tmpl/default.php:47513 include Copy JROOT/components/com_splms/views/courses/tmpl/default.php Copy JROOT/libraries/fof/view/view.php:44212 FOFView->loadAnyTemplate() Copy JROOT/libraries/fof/view/form.php:7611 FOFViewForm->display() Copy JROOT/libraries/fof/controller/controller.php:112510 FOFController->display() Copy JROOT/libraries/fof/controller/controller.php:11659 FOFController->browse() Copy JROOT/libraries/fof/controller/controller.php:9678 FOFController->execute() Copy JROOT/libraries/fof/dispatcher/dispatcher.php:3327 FOFDispatcher->dispatch() Copy JROOT/components/com_splms/splms.php:356 require_once Copy JROOT/components/com_splms/splms.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2671 JApplicationCms->execute() Copy JROOT/index.php:73
クエリ時間：3.80 ms 最後のクエリの後：0.43 ms クエリメモリ：0.023 MB クエリ前のメモリ：24.222 MB 返された行：0
SELECT *
FROM `joom_splms_lessons `
WHERE `enabled`= '1' AND `splms_course_id`= '6' AND `language`= 'ja-JA '
ORDER BY ordering ASC クエリではEXPLAINは使用できません：SELECT *
FROM `joom_splms_lessons`
WHERE `enabled`='1' AND `splms_course_id`='6' AND `language`='ja-JA'
ORDER BY ordering ASC
Status Duration starting 0.04 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.04 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.06 ms preparing 0.05 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.00 ms
# 発信者 ファイルと行番号 16 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:169315 JDatabaseDriver->loadObjectList() Copy JROOT/components/com_splms/models/lessons.php:25614 SplmsModelLessons::getLessons() Copy JROOT/components/com_splms/views/courses/tmpl/default.php:46813 include Copy JROOT/components/com_splms/views/courses/tmpl/default.php Copy JROOT/libraries/fof/view/view.php:44212 FOFView->loadAnyTemplate() Copy JROOT/libraries/fof/view/form.php:7611 FOFViewForm->display() Copy JROOT/libraries/fof/controller/controller.php:112510 FOFController->display() Copy JROOT/libraries/fof/controller/controller.php:11659 FOFController->browse() Copy JROOT/libraries/fof/controller/controller.php:9678 FOFController->execute() Copy JROOT/libraries/fof/dispatcher/dispatcher.php:3327 FOFDispatcher->dispatch() Copy JROOT/components/com_splms/splms.php:356 require_once Copy JROOT/components/com_splms/splms.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2671 JApplicationCms->execute() Copy JROOT/index.php:73
クエリ時間：1.27 ms 最後のクエリの後：0.03 ms クエリメモリ：0.023 MB クエリ前のメモリ：24.229 MB 返された行：0
SELECT event_id
FROM joom_splms_courses_events ce
LEFT JOIN joom_eb_events e ON e.id = ce.event_id
WHERE ce.course_id = 6 AND e.published = 1クエリではEXPLAINは使用できません：SELECT event_id
FROM joom_splms_courses_events ce
LEFT JOIN joom_eb_events e ON e.id = ce.event_id
WHERE ce.course_id = 6 AND e.published = 1
Status Duration starting 0.07 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms 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.01 ms
# 発信者 ファイルと行番号 16 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:154215 JDatabaseDriver->loadColumn() Copy JROOT/libraries/axslibs/events.php:23714 AxsEvents::getCourseEvents() Copy JROOT/components/com_splms/views/courses/tmpl/default.php:46913 include Copy JROOT/components/com_splms/views/courses/tmpl/default.php Copy JROOT/libraries/fof/view/view.php:44212 FOFView->loadAnyTemplate() Copy JROOT/libraries/fof/view/form.php:7611 FOFViewForm->display() Copy JROOT/libraries/fof/controller/controller.php:112510 FOFController->display() Copy JROOT/libraries/fof/controller/controller.php:11659 FOFController->browse() Copy JROOT/libraries/fof/controller/controller.php:9678 FOFController->execute() Copy JROOT/libraries/fof/dispatcher/dispatcher.php:3327 FOFDispatcher->dispatch() Copy JROOT/components/com_splms/splms.php:356 require_once Copy JROOT/components/com_splms/splms.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2671 JApplicationCms->execute() Copy JROOT/index.php:73
クエリ時間：1.15 ms 最後のクエリの後：0.04 ms クエリメモリ：0.024 MB クエリ前のメモリ：24.236 MB 返された行：0
SELECT *
FROM `joom_splms_lessons `
WHERE `splms_course_id`= 6 AND `enabled`= 1 AND `language`= 'ja-JA 'クエリではEXPLAINは使用できません：SELECT *
FROM `joom_splms_lessons`
WHERE `splms_course_id`=6 AND `enabled`= 1 AND `language`='ja-JA'
Status Duration starting 0.03 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.00 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.07 ms preparing 0.02 ms executing 0.09 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.02 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 17 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:169316 JDatabaseDriver->loadObjectList() Copy JROOT/components/com_splms/models/courses.php:107415 SplmsModelCourses->getLessons() Copy JROOT/components/com_splms/models/courses.php:68914 SplmsModelCourses->getCourseTeachers() Copy JROOT/components/com_splms/views/courses/tmpl/default.php:47513 include Copy JROOT/components/com_splms/views/courses/tmpl/default.php Copy JROOT/libraries/fof/view/view.php:44212 FOFView->loadAnyTemplate() Copy JROOT/libraries/fof/view/form.php:7611 FOFViewForm->display() Copy JROOT/libraries/fof/controller/controller.php:112510 FOFController->display() Copy JROOT/libraries/fof/controller/controller.php:11659 FOFController->browse() Copy JROOT/libraries/fof/controller/controller.php:9678 FOFController->execute() Copy JROOT/libraries/fof/dispatcher/dispatcher.php:3327 FOFDispatcher->dispatch() Copy JROOT/components/com_splms/splms.php:356 require_once Copy JROOT/components/com_splms/splms.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2671 JApplicationCms->execute() Copy JROOT/index.php:73
クエリ時間：1.67 ms 最後のクエリの後：0.41 ms クエリメモリ：0.023 MB クエリ前のメモリ：24.258 MB 返された行：0
SELECT *
FROM `joom_splms_lessons `
WHERE `enabled`= '1' AND `splms_course_id`= '7' AND `language`= 'ja-JA '
ORDER BY ordering ASC クエリではEXPLAINは使用できません：SELECT *
FROM `joom_splms_lessons`
WHERE `enabled`='1' AND `splms_course_id`='7' AND `language`='ja-JA'
ORDER BY ordering ASC
Status Duration starting 0.04 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.06 ms preparing 0.03 ms executing 0.07 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.06 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 16 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:169315 JDatabaseDriver->loadObjectList() Copy JROOT/components/com_splms/models/lessons.php:25614 SplmsModelLessons::getLessons() Copy JROOT/components/com_splms/views/courses/tmpl/default.php:46813 include Copy JROOT/components/com_splms/views/courses/tmpl/default.php Copy JROOT/libraries/fof/view/view.php:44212 FOFView->loadAnyTemplate() Copy JROOT/libraries/fof/view/form.php:7611 FOFViewForm->display() Copy JROOT/libraries/fof/controller/controller.php:112510 FOFController->display() Copy JROOT/libraries/fof/controller/controller.php:11659 FOFController->browse() Copy JROOT/libraries/fof/controller/controller.php:9678 FOFController->execute() Copy JROOT/libraries/fof/dispatcher/dispatcher.php:3327 FOFDispatcher->dispatch() Copy JROOT/components/com_splms/splms.php:356 require_once Copy JROOT/components/com_splms/splms.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2671 JApplicationCms->execute() Copy JROOT/index.php:73
クエリ時間：1.42 ms 最後のクエリの後：0.04 ms クエリメモリ：0.023 MB クエリ前のメモリ：24.265 MB 返された行：0
SELECT event_id
FROM joom_splms_courses_events ce
LEFT JOIN joom_eb_events e ON e.id = ce.event_id
WHERE ce.course_id = 7 AND e.published = 1クエリではEXPLAINは使用できません：SELECT event_id
FROM joom_splms_courses_events ce
LEFT JOIN joom_eb_events e ON e.id = ce.event_id
WHERE ce.course_id = 7 AND e.published = 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.04 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
# 発信者 ファイルと行番号 16 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:154215 JDatabaseDriver->loadColumn() Copy JROOT/libraries/axslibs/events.php:23714 AxsEvents::getCourseEvents() Copy JROOT/components/com_splms/views/courses/tmpl/default.php:46913 include Copy JROOT/components/com_splms/views/courses/tmpl/default.php Copy JROOT/libraries/fof/view/view.php:44212 FOFView->loadAnyTemplate() Copy JROOT/libraries/fof/view/form.php:7611 FOFViewForm->display() Copy JROOT/libraries/fof/controller/controller.php:112510 FOFController->display() Copy JROOT/libraries/fof/controller/controller.php:11659 FOFController->browse() Copy JROOT/libraries/fof/controller/controller.php:9678 FOFController->execute() Copy JROOT/libraries/fof/dispatcher/dispatcher.php:3327 FOFDispatcher->dispatch() Copy JROOT/components/com_splms/splms.php:356 require_once Copy JROOT/components/com_splms/splms.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2671 JApplicationCms->execute() Copy JROOT/index.php:73
クエリ時間：1.01 ms 最後のクエリの後：0.05 ms クエリメモリ：0.024 MB クエリ前のメモリ：24.272 MB 返された行：0
SELECT *
FROM `joom_splms_lessons `
WHERE `splms_course_id`= 7 AND `enabled`= 1 AND `language`= 'ja-JA 'クエリではEXPLAINは使用できません：SELECT *
FROM `joom_splms_lessons`
WHERE `splms_course_id`=7 AND `enabled`= 1 AND `language`='ja-JA'
Status Duration starting 0.05 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.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.08 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.02 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 17 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:169316 JDatabaseDriver->loadObjectList() Copy JROOT/components/com_splms/models/courses.php:107415 SplmsModelCourses->getLessons() Copy JROOT/components/com_splms/models/courses.php:68914 SplmsModelCourses->getCourseTeachers() Copy JROOT/components/com_splms/views/courses/tmpl/default.php:47513 include Copy JROOT/components/com_splms/views/courses/tmpl/default.php Copy JROOT/libraries/fof/view/view.php:44212 FOFView->loadAnyTemplate() Copy JROOT/libraries/fof/view/form.php:7611 FOFViewForm->display() Copy JROOT/libraries/fof/controller/controller.php:112510 FOFController->display() Copy JROOT/libraries/fof/controller/controller.php:11659 FOFController->browse() Copy JROOT/libraries/fof/controller/controller.php:9678 FOFController->execute() Copy JROOT/libraries/fof/dispatcher/dispatcher.php:3327 FOFDispatcher->dispatch() Copy JROOT/components/com_splms/splms.php:356 require_once Copy JROOT/components/com_splms/splms.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2671 JApplicationCms->execute() Copy JROOT/index.php:73
クエリ時間：0.98 ms 最後のクエリの後：0.51 ms クエリメモリ：0.023 MB クエリ前のメモリ：24.294 MB 返された行：0
SELECT *
FROM `joom_splms_lessons `
WHERE `enabled`= '1' AND `splms_course_id`= '8' AND `language`= 'ja-JA '
ORDER BY ordering ASC クエリではEXPLAINは使用できません：SELECT *
FROM `joom_splms_lessons`
WHERE `enabled`='1' AND `splms_course_id`='8' AND `language`='ja-JA'
ORDER BY ordering ASC
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.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.07 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
# 発信者 ファイルと行番号 16 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:169315 JDatabaseDriver->loadObjectList() Copy JROOT/components/com_splms/models/lessons.php:25614 SplmsModelLessons::getLessons() Copy JROOT/components/com_splms/views/courses/tmpl/default.php:46813 include Copy JROOT/components/com_splms/views/courses/tmpl/default.php Copy JROOT/libraries/fof/view/view.php:44212 FOFView->loadAnyTemplate() Copy JROOT/libraries/fof/view/form.php:7611 FOFViewForm->display() Copy JROOT/libraries/fof/controller/controller.php:112510 FOFController->display() Copy JROOT/libraries/fof/controller/controller.php:11659 FOFController->browse() Copy JROOT/libraries/fof/controller/controller.php:9678 FOFController->execute() Copy JROOT/libraries/fof/dispatcher/dispatcher.php:3327 FOFDispatcher->dispatch() Copy JROOT/components/com_splms/splms.php:356 require_once Copy JROOT/components/com_splms/splms.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2671 JApplicationCms->execute() Copy JROOT/index.php:73
クエリ時間：0.86 ms 最後のクエリの後：0.04 ms クエリメモリ：0.023 MB クエリ前のメモリ：24.301 MB 返された行：0
SELECT event_id
FROM joom_splms_courses_events ce
LEFT JOIN joom_eb_events e ON e.id = ce.event_id
WHERE ce.course_id = 8 AND e.published = 1クエリではEXPLAINは使用できません：SELECT event_id
FROM joom_splms_courses_events ce
LEFT JOIN joom_eb_events e ON e.id = ce.event_id
WHERE ce.course_id = 8 AND e.published = 1
Status Duration starting 0.05 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.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.02 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 16 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:154215 JDatabaseDriver->loadColumn() Copy JROOT/libraries/axslibs/events.php:23714 AxsEvents::getCourseEvents() Copy JROOT/components/com_splms/views/courses/tmpl/default.php:46913 include Copy JROOT/components/com_splms/views/courses/tmpl/default.php Copy JROOT/libraries/fof/view/view.php:44212 FOFView->loadAnyTemplate() Copy JROOT/libraries/fof/view/form.php:7611 FOFViewForm->display() Copy JROOT/libraries/fof/controller/controller.php:112510 FOFController->display() Copy JROOT/libraries/fof/controller/controller.php:11659 FOFController->browse() Copy JROOT/libraries/fof/controller/controller.php:9678 FOFController->execute() Copy JROOT/libraries/fof/dispatcher/dispatcher.php:3327 FOFDispatcher->dispatch() Copy JROOT/components/com_splms/splms.php:356 require_once Copy JROOT/components/com_splms/splms.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2671 JApplicationCms->execute() Copy JROOT/index.php:73
クエリ時間：0.96 ms 最後のクエリの後：0.04 ms クエリメモリ：0.024 MB クエリ前のメモリ：24.308 MB 返された行：0
SELECT *
FROM `joom_splms_lessons `
WHERE `splms_course_id`= 8 AND `enabled`= 1 AND `language`= 'ja-JA 'クエリではEXPLAINは使用できません：SELECT *
FROM `joom_splms_lessons`
WHERE `splms_course_id`=8 AND `enabled`= 1 AND `language`='ja-JA'
Status Duration starting 0.04 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.06 ms preparing 0.02 ms executing 0.10 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 17 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:169316 JDatabaseDriver->loadObjectList() Copy JROOT/components/com_splms/models/courses.php:107415 SplmsModelCourses->getLessons() Copy JROOT/components/com_splms/models/courses.php:68914 SplmsModelCourses->getCourseTeachers() Copy JROOT/components/com_splms/views/courses/tmpl/default.php:47513 include Copy JROOT/components/com_splms/views/courses/tmpl/default.php Copy JROOT/libraries/fof/view/view.php:44212 FOFView->loadAnyTemplate() Copy JROOT/libraries/fof/view/form.php:7611 FOFViewForm->display() Copy JROOT/libraries/fof/controller/controller.php:112510 FOFController->display() Copy JROOT/libraries/fof/controller/controller.php:11659 FOFController->browse() Copy JROOT/libraries/fof/controller/controller.php:9678 FOFController->execute() Copy JROOT/libraries/fof/dispatcher/dispatcher.php:3327 FOFDispatcher->dispatch() Copy JROOT/components/com_splms/splms.php:356 require_once Copy JROOT/components/com_splms/splms.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2671 JApplicationCms->execute() Copy JROOT/index.php:73
クエリ時間：1.16 ms 最後のクエリの後：3.04 ms クエリメモリ：0.022 MB クエリ前のメモリ：24.393 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.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.02 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.04 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 12 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:169311 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/cms/language/multilang.php:10610 JLanguageMultilang::getSiteHomePages() Copy JROOT/plugins/system/languagefilter/languagefilter.php:7299 PlgSystemLanguageFilter->onAfterDispatch() 以下の行の呼び出しと同じです。 8 ReflectionMethod->invokeArgs() Copy JROOT/libraries/tovuti/Helpers/MethodHelper.php:587 Tovuti\Helpers\MethodHelper::call() Copy JROOT/libraries/joomla/event/event.php:726 JEvent->update() Copy JROOT/libraries/joomla/event/dispatcher.php:1605 JEventDispatcher->trigger() Copy JROOT/libraries/joomla/application/base.php:1064 JApplicationBase->triggerEvent() Copy JROOT/libraries/cms/application/site.php:1963 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2671 JApplicationCms->execute() Copy JROOT/index.php:73
クエリ時間：0.94 ms 最後のクエリの後：0.60 ms クエリメモリ：0.022 MB クエリ前のメモリ：24.446 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 = 864クエリでは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 = 864
Status Duration starting 0.06 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms 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.08 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.02 ms
# 発信者 ファイルと行番号 13 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:169312 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/cms/language/associations.php:10111 JLanguageAssociations::getAssociations() Copy JROOT/administrator/components/com_menus/helpers/menus.php:31310 MenusHelper::getAssociations() Copy JROOT/plugins/system/languagefilter/languagefilter.php:7469 PlgSystemLanguageFilter->onAfterDispatch() 以下の行の呼び出しと同じです。 8 ReflectionMethod->invokeArgs() Copy JROOT/libraries/tovuti/Helpers/MethodHelper.php:587 Tovuti\Helpers\MethodHelper::call() Copy JROOT/libraries/joomla/event/event.php:726 JEvent->update() Copy JROOT/libraries/joomla/event/dispatcher.php:1605 JEventDispatcher->trigger() Copy JROOT/libraries/joomla/application/base.php:1064 JApplicationBase->triggerEvent() Copy JROOT/libraries/cms/application/site.php:1963 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2671 JApplicationCms->execute() Copy JROOT/index.php:73
クエリ時間：0.90 ms 最後のクエリの後：17.35 ms クエリメモリ：0.023 MB クエリ前のメモリ：24.735 MB 返された行：10
SELECT * FROM axs_fonts WHERE enabled = 1クエリではEXPLAINは使用できません：SELECT * FROM axs_fonts WHERE enabled = 1
Status Duration starting 0.05 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.02 ms executing 0.07 ms end 0.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/fonts.php:349 AxsFonts::getFonts() Copy JROOT/templates/axs/home.php:1388 include Copy JROOT/templates/axs/home.php Copy JROOT/templates/axs/index.php:607 require Copy JROOT/templates/axs/index.php Copy JROOT/libraries/joomla/document/html.php:6536 JDocumentHtml->_loadTemplate() Copy JROOT/libraries/joomla/document/html.php:7155 JDocumentHtml->_fetchTemplate() Copy JROOT/libraries/joomla/document/html.php:5304 JDocumentHtml->parse() Copy JROOT/libraries/cms/application/cms.php:11323 JApplicationCms->render() Copy JROOT/libraries/cms/application/site.php:7822 JApplicationSite->render() Copy JROOT/libraries/cms/application/cms.php:2721 JApplicationCms->execute() Copy JROOT/index.php:73
クエリ時間：0.80 ms 最後のクエリの後：0.25 ms クエリメモリ：0.022 MB クエリ前のメモリ：24.779 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.04 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.02 ms executing 0.02 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.02 ms cleaning up 0.00 ms
# 発信者 ファイルと行番号 12 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:165411 JDatabaseDriver->loadObject() Copy JROOT/libraries/axslibs/accessibility.php:4210 AxsAccessibility::query() Copy JROOT/libraries/axslibs/accessibility.php:499 AxsAccessibility::image() Copy JROOT/templates/axs/home.php:8388 include Copy JROOT/templates/axs/home.php Copy JROOT/templates/axs/index.php:607 require Copy JROOT/templates/axs/index.php Copy JROOT/libraries/joomla/document/html.php:6536 JDocumentHtml->_loadTemplate() Copy JROOT/libraries/joomla/document/html.php:7155 JDocumentHtml->_fetchTemplate() Copy JROOT/libraries/joomla/document/html.php:5304 JDocumentHtml->parse() Copy JROOT/libraries/cms/application/cms.php:11323 JApplicationCms->render() Copy JROOT/libraries/cms/application/site.php:7822 JApplicationSite->render() Copy JROOT/libraries/cms/application/cms.php:2721 JApplicationCms->execute() Copy JROOT/index.php:73
クエリ時間：2.17 ms 最後のクエリの後：0.74 ms クエリメモリ：0.026 MB クエリ前のメモリ：24.863 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-03-20 20:05:15') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-03-20 20:05:15') AND m.access IN (1,1) AND m.client_id = 0 AND (mm.menuid = 864 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-03-20 20:05:15') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-03-20 20:05:15') AND m.access IN (1,1) AND m.client_id = 0 AND (mm.menuid = 864 OR mm.menuid <= 0) AND m.language IN ('ja-JA','*')
ORDER BY m.position, m.ordering
Status Duration starting 0.10 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.07 ms init 0.01 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.11 ms preparing 0.05 ms executing 1.00 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
# 発信者 ファイルと行番号 15 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:169314 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/joomla/cache/controller/callback.php:16913 JCacheControllerCallback->get() Copy JROOT/libraries/cms/module/helper.php:42412 JModuleHelper::getModuleList() Copy JROOT/libraries/cms/module/helper.php:36011 JModuleHelper::load() Copy JROOT/libraries/cms/module/helper.php:8410 JModuleHelper::getModules() Copy JROOT/libraries/joomla/document/html.php:5769 JDocumentHtml->countModules() Copy JROOT/templates/axs/home.php:8788 include Copy JROOT/templates/axs/home.php Copy JROOT/templates/axs/index.php:607 require Copy JROOT/templates/axs/index.php Copy JROOT/libraries/joomla/document/html.php:6536 JDocumentHtml->_loadTemplate() Copy JROOT/libraries/joomla/document/html.php:7155 JDocumentHtml->_fetchTemplate() Copy JROOT/libraries/joomla/document/html.php:5304 JDocumentHtml->parse() Copy JROOT/libraries/cms/application/cms.php:11323 JApplicationCms->render() Copy JROOT/libraries/cms/application/site.php:7822 JApplicationSite->render() Copy JROOT/libraries/cms/application/cms.php:2721 JApplicationCms->execute() Copy JROOT/index.php:73
クエリ時間：1.19 ms 最後のクエリの後：1.41 ms クエリメモリ：0.027 MB クエリ前のメモリ：24.934 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.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.03 ms statistics 0.02 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
# 発信者 ファイルと行番号 11 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:169310 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/axslibs/notifications.php:199 AxsNotifications::loadNotifications() Copy JROOT/templates/axs/home.php:18278 include Copy JROOT/templates/axs/home.php Copy JROOT/templates/axs/index.php:607 require Copy JROOT/templates/axs/index.php Copy JROOT/libraries/joomla/document/html.php:6536 JDocumentHtml->_loadTemplate() Copy JROOT/libraries/joomla/document/html.php:7155 JDocumentHtml->_fetchTemplate() Copy JROOT/libraries/joomla/document/html.php:5304 JDocumentHtml->parse() Copy JROOT/libraries/cms/application/cms.php:11323 JApplicationCms->render() Copy JROOT/libraries/cms/application/site.php:7822 JApplicationSite->render() Copy JROOT/libraries/cms/application/cms.php:2721 JApplicationCms->execute() Copy JROOT/index.php:73
クエリ時間：0.81 ms 最後のクエリの後：4.53 ms クエリメモリ：0.026 MB クエリ前のメモリ：25.170 MB 返された行：0
SELECT *
FROM joom_easyblog_configs
WHERE `name` = 'config'クエリではEXPLAINは使用できません：SELECT *
FROM joom_easyblog_configs
WHERE `name` = 'config'
Status Duration starting 0.04 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.02 ms executing 0.02 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms
# 発信者 ファイルと行番号 22 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:145721 JDatabaseDriver->loadAssoc() Copy JROOT/libraries/joomla/table/table.php:72920 JTable->load() Copy JROOT/administrator/components/com_easyblog/includes/easyblog.php:41519 EB::config() Copy JROOT/components/com_easyblog/router.php:1918 EasyBlogBuildRoute() Copy JROOT/libraries/cms/component/router/legacy.php:6817 JComponentRouterLegacy->build() Copy JROOT/libraries/cms/router/site.php:51916 JRouterSite->buildSefRoute() Copy JROOT/libraries/cms/router/site.php:48915 JRouterSite->_buildSefRoute() Copy JROOT/libraries/cms/router/router.php:28214 JRouter->build() Copy JROOT/libraries/cms/router/site.php:14913 JRouterSite->build() Copy JROOT/libraries/joomla/application/route.php:6212 JRoute::_() Copy JROOT/modules/mod_defaultmenu/helper.php:13411 ModDefaultHelper::getList() Copy JROOT/modules/mod_defaultmenu/mod_defaultmenu.php:1510 include Copy JROOT/modules/mod_defaultmenu/mod_defaultmenu.php Copy JROOT/libraries/cms/module/helper.php:1989 JModuleHelper::renderModule() Copy JROOT/libraries/joomla/document/renderer/html/module.php:938 JDocumentRendererHtmlModule->render() Copy JROOT/libraries/joomla/document/renderer/html/modules.php:427 JDocumentRendererHtmlModules->render() Copy JROOT/libraries/joomla/document/html.php:4866 JDocumentHtml->getBuffer() Copy JROOT/libraries/joomla/document/html.php:7775 JDocumentHtml->_renderTemplate() Copy JROOT/libraries/joomla/document/html.php:5524 JDocumentHtml->render() Copy JROOT/libraries/cms/application/cms.php:11483 JApplicationCms->render() Copy JROOT/libraries/cms/application/site.php:7822 JApplicationSite->render() Copy JROOT/libraries/cms/application/cms.php:2721 JApplicationCms->execute() Copy JROOT/index.php:73
クエリ時間：1.85 ms 最後のクエリの後：0.17 ms クエリメモリ：0.027 MB クエリ前のメモリ：25.228 MB 返された行：1
SELECT * FROM joom_extensions WHERE name= 'com_media'クエリではEXPLAINは使用できません：SELECT * FROM joom_extensions WHERE name='com_media'
Status Duration starting 0.03 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.01 ms preparing 0.02 ms executing 0.97 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 23 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:165422 JDatabaseDriver->loadObject() Copy JROOT/libraries/axslibs/images.php:6621 AxsImages::setSession() Copy JROOT/libraries/axslibs/images.php:1520 AxsImages::getImagesPath() Copy JROOT/administrator/components/com_easyblog/includes/easyblog.php:43019 EB::config() Copy JROOT/components/com_easyblog/router.php:1918 EasyBlogBuildRoute() Copy JROOT/libraries/cms/component/router/legacy.php:6817 JComponentRouterLegacy->build() Copy JROOT/libraries/cms/router/site.php:51916 JRouterSite->buildSefRoute() Copy JROOT/libraries/cms/router/site.php:48915 JRouterSite->_buildSefRoute() Copy JROOT/libraries/cms/router/router.php:28214 JRouter->build() Copy JROOT/libraries/cms/router/site.php:14913 JRouterSite->build() Copy JROOT/libraries/joomla/application/route.php:6212 JRoute::_() Copy JROOT/modules/mod_defaultmenu/helper.php:13411 ModDefaultHelper::getList() Copy JROOT/modules/mod_defaultmenu/mod_defaultmenu.php:1510 include Copy JROOT/modules/mod_defaultmenu/mod_defaultmenu.php Copy JROOT/libraries/cms/module/helper.php:1989 JModuleHelper::renderModule() Copy JROOT/libraries/joomla/document/renderer/html/module.php:938 JDocumentRendererHtmlModule->render() Copy JROOT/libraries/joomla/document/renderer/html/modules.php:427 JDocumentRendererHtmlModules->render() Copy JROOT/libraries/joomla/document/html.php:4866 JDocumentHtml->getBuffer() Copy JROOT/libraries/joomla/document/html.php:7775 JDocumentHtml->_renderTemplate() Copy JROOT/libraries/joomla/document/html.php:5524 JDocumentHtml->render() Copy JROOT/libraries/cms/application/cms.php:11483 JApplicationCms->render() Copy JROOT/libraries/cms/application/site.php:7822 JApplicationSite->render() Copy JROOT/libraries/cms/application/cms.php:2721 JApplicationCms->execute() Copy JROOT/index.php:73
クエリ時間：0.85 ms 最後のクエリの後：1.84 ms クエリメモリ：0.028 MB クエリ前のメモリ：25.427 MB 返された行：1
SELECT * FROM joom_kunena_configuration WHERE id= 1クエリではEXPLAINは使用できません：SELECT * FROM joom_kunena_configuration WHERE id=1
Status Duration starting 0.04 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.01 ms executing 0.01 ms end 0.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
# 発信者 ファイルと行番号 28 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:145727 JDatabaseDriver->loadAssoc() Copy JROOT/libraries/kunena/config.php:130626 KunenaConfig->load() Copy JROOT/libraries/kunena/config.php:123925 KunenaConfig::getInstance() Copy JROOT/libraries/kunena/factory.php:2824 KunenaFactory::getConfig() Copy JROOT/libraries/kunena/route/route.php:48023 KunenaRoute::initialize() Copy JROOT/libraries/kunena/route/route.php:1722 include Copy JROOT/libraries/kunena/route/route.php Copy JROOT/libraries/loader.php:71621 JLoader::_load() Copy JROOT/libraries/loader.php:67120 JLoader::_autoload() 以下の行の呼び出しと同じです。 19 spl_autoload_call() Copy JROOT/components/com_kunena/router.php:3818 KunenaBuildRoute() Copy JROOT/libraries/cms/component/router/legacy.php:6817 JComponentRouterLegacy->build() Copy JROOT/libraries/cms/router/site.php:51916 JRouterSite->buildSefRoute() Copy JROOT/libraries/cms/router/site.php:48915 JRouterSite->_buildSefRoute() Copy JROOT/libraries/cms/router/router.php:28214 JRouter->build() Copy JROOT/libraries/cms/router/site.php:14913 JRouterSite->build() Copy JROOT/libraries/joomla/application/route.php:6212 JRoute::_() Copy JROOT/modules/mod_defaultmenu/helper.php:13411 ModDefaultHelper::getList() Copy JROOT/modules/mod_defaultmenu/mod_defaultmenu.php:1510 include Copy JROOT/modules/mod_defaultmenu/mod_defaultmenu.php Copy JROOT/libraries/cms/module/helper.php:1989 JModuleHelper::renderModule() Copy JROOT/libraries/joomla/document/renderer/html/module.php:938 JDocumentRendererHtmlModule->render() Copy JROOT/libraries/joomla/document/renderer/html/modules.php:427 JDocumentRendererHtmlModules->render() Copy JROOT/libraries/joomla/document/html.php:4866 JDocumentHtml->getBuffer() Copy JROOT/libraries/joomla/document/html.php:7775 JDocumentHtml->_renderTemplate() Copy JROOT/libraries/joomla/document/html.php:5524 JDocumentHtml->render() Copy JROOT/libraries/cms/application/cms.php:11483 JApplicationCms->render() Copy JROOT/libraries/cms/application/site.php:7822 JApplicationSite->render() Copy JROOT/libraries/cms/application/cms.php:2721 JApplicationCms->execute() Copy JROOT/index.php:73
クエリ時間：0.90 ms 最後のクエリの後：4.47 ms クエリメモリ：0.024 MB クエリ前のメモリ：25.643 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.04 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.01 ms executing 0.01 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 16 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:165415 JDatabaseDriver->loadObject() Copy JROOT/libraries/axslibs/language.php:30814 AxsLanguage::getSpecialCharacters() Copy JROOT/libraries/axslibs/language.php:2713 AxsLanguage::translate() Copy JROOT/modules/mod_defaultmenu/tmpl/default_component.php:3312 require Copy JROOT/modules/mod_defaultmenu/tmpl/default_component.php Copy JROOT/modules/mod_defaultmenu/tmpl/default.php:7211 require Copy JROOT/modules/mod_defaultmenu/tmpl/default.php Copy JROOT/modules/mod_defaultmenu/mod_defaultmenu.php:2510 include Copy JROOT/modules/mod_defaultmenu/mod_defaultmenu.php Copy JROOT/libraries/cms/module/helper.php:1989 JModuleHelper::renderModule() Copy JROOT/libraries/joomla/document/renderer/html/module.php:938 JDocumentRendererHtmlModule->render() Copy JROOT/libraries/joomla/document/renderer/html/modules.php:427 JDocumentRendererHtmlModules->render() Copy JROOT/libraries/joomla/document/html.php:4866 JDocumentHtml->getBuffer() Copy JROOT/libraries/joomla/document/html.php:7775 JDocumentHtml->_renderTemplate() Copy JROOT/libraries/joomla/document/html.php:5524 JDocumentHtml->render() Copy JROOT/libraries/cms/application/cms.php:11483 JApplicationCms->render() Copy JROOT/libraries/cms/application/site.php:7822 JApplicationSite->render() Copy JROOT/libraries/cms/application/cms.php:2721 JApplicationCms->execute() Copy JROOT/index.php:73
クエリ時間：0.93 ms 最後のクエリの後：0.04 ms クエリメモリ：0.026 MB クエリ前のメモリ：25.653 MB 返された行：25
SELECT *
FROM axs_translations
WHERE language_tag = 'ja'クエリではEXPLAINは使用できません：SELECT *
FROM axs_translations
WHERE language_tag = 'ja'
Status Duration starting 0.03 ms Executing hook on transaction 0.00 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.05 ms preparing 0.01 ms executing 0.11 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms
# 発信者 ファイルと行番号 16 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:149815 JDatabaseDriver->loadAssocList() Copy JROOT/libraries/axslibs/language.php:15114 AxsLanguage::getTranslationMap() Copy JROOT/libraries/axslibs/language.php:4013 AxsLanguage::translate() Copy JROOT/modules/mod_defaultmenu/tmpl/default_component.php:3312 require Copy JROOT/modules/mod_defaultmenu/tmpl/default_component.php Copy JROOT/modules/mod_defaultmenu/tmpl/default.php:7211 require Copy JROOT/modules/mod_defaultmenu/tmpl/default.php Copy JROOT/modules/mod_defaultmenu/mod_defaultmenu.php:2510 include Copy JROOT/modules/mod_defaultmenu/mod_defaultmenu.php Copy JROOT/libraries/cms/module/helper.php:1989 JModuleHelper::renderModule() Copy JROOT/libraries/joomla/document/renderer/html/module.php:938 JDocumentRendererHtmlModule->render() Copy JROOT/libraries/joomla/document/renderer/html/modules.php:427 JDocumentRendererHtmlModules->render() Copy JROOT/libraries/joomla/document/html.php:4866 JDocumentHtml->getBuffer() Copy JROOT/libraries/joomla/document/html.php:7775 JDocumentHtml->_renderTemplate() Copy JROOT/libraries/joomla/document/html.php:5524 JDocumentHtml->render() Copy JROOT/libraries/cms/application/cms.php:11483 JApplicationCms->render() Copy JROOT/libraries/cms/application/site.php:7822 JApplicationSite->render() Copy JROOT/libraries/cms/application/cms.php:2721 JApplicationCms->execute() Copy JROOT/index.php:73
14×SELECT * FROM `joom_splms_lessons ` 7×SELECT event_id FROM joom_splms_courses_events ce LEFT JOIN joom_eb_events e ON e.id = ce.event_id 2×SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `joom_extensions ` 2×SELECT * FROM joom_languages 2×SELECT * FROM `joom_splms_coursescategories ` 1×SELECT session_id FROM `joom_session ` 1×SELECT language,id FROM `joom_menu ` 1×SELECT id FROM axs_starred 1×SELECT * FROM `joom_splms_course_wishlist ` 1×SELECT * FROM `axs_course_purchases` 1×SELECT * FROM `joom_splms_course_progress ` 1×SELECT sef FROM joom_languages 1×SELECT * FROM axs_fonts 1×SELECT `c2`.`language`,`c2`.`id` FROM `joom_menu ` AS `c` INNER JOIN `joom_associations ` AS `a` ON a.id = c.`id` AND a.context= 'com_menus.item' INNER JOIN `joom_associations ` AS `a2` ON a.key = a2.key INNER JOIN `joom_menu ` AS `c2` ON a2.id = c2.`id` 1×SELECT * FROM accessibility_images 1×SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid FROM joom_modules AS m LEFT JOIN joom_modules_menu AS mm ON mm.moduleid = m.id LEFT JOIN joom_extensions AS e ON e.element = m.module AND e.client_id = m.client_id 1×SELECT * FROM axs_notifications 1×SELECT * FROM joom_easyblog_configs 1×SELECT * FROM joom_extensions 1×SELECT * FROM joom_kunena_configuration 1×SELECT special_characters FROM joom_languages 1×SELECT COUNT (* ) as total FROM `joom_splms_courses ` 1×SELECT `id`,`name`,`rules`,`parent_id` FROM `joom_assets ` 1×SELECT * FROM `joom_splms_courses ` 1×SELECT `folder` AS `type`,`element` AS `name`,`params` FROM joom_extensions 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 * FROM axs_domains 1×SELECT * 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 `id`,`title` FROM `joom_usergroups ` 1×SELECT params FROM axs_user_settings 1×SELECT * FROM `joom_users ` 1×SELECT id, home, template, s.params FROM joom_template_styles as s LEFT JOIN joom_extensions as e ON e.element= s.template AND e.type= 'template' AND e.client_id= s.client_id 1×SELECT * FROM axs_lms_settings 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 1×SELECT * FROM axs_translations 
عربى 
中国人 
Dansk 
English 
Suomalainen 
Français 
Deutsch 
हिन्दी 
Italiano 
Norsk 
Português 
Español 