クエリ時間:1.17 ms クエリメモリ:0.020 MB クエリ前のメモリ:4.249 MB 返された行:1
SELECT `session_id`
FROM `joom_session `
WHERE `session_id` = 'osmj4mv20difvhgo577ls3ssaf' LIMIT 1クエリではEXPLAINは使用できません:SELECT `session_id`
FROM `joom_session`
WHERE `session_id` = 'osmj4mv20difvhgo577ls3ssaf' LIMIT 1
Status Duration starting 0.03 ms Executing hook on transaction 0.01 ms starting 0.02 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.01 ms executing 0.01 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.04 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms
# 発信者 ファイルと行番号 8 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:17657 JDatabaseDriver->loadResult() Copy JROOT/libraries/cms/application/cms.php:1766 JApplicationCms->checkSession() Copy JROOT/libraries/cms/application/cms.php:8965 JApplicationCms->loadSession() Copy JROOT/libraries/cms/application/cms.php:1314 JApplicationCms->__construct() Copy JROOT/libraries/cms/application/site.php:633 JApplicationSite->__construct() Copy JROOT/libraries/cms/application/cms.php:4772 JApplicationCms::getInstance() Copy JROOT/libraries/joomla/factory.php:1251 JFactory::getApplication() Copy JROOT/index.php:50
クエリ時間:1.46 ms 最後のクエリの後:1.24 ms クエリメモリ:0.045 MB クエリ前のメモリ:4.422 MB 返された行:80
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `joom_extensions `
WHERE `type` = 'component'クエリではEXPLAINは使用できません:SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `joom_extensions`
WHERE `type` = 'component'
Status Duration starting 0.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.05 ms preparing 0.02 ms executing 0.27 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.00 ms
# 発信者 ファイルと行番号 10 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:17269 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/cms/component/helper.php:4478 JComponentHelper::{closure}() Copy JROOT/libraries/joomla/cache/controller/callback.php:1697 JCacheControllerCallback->get() Copy JROOT/libraries/cms/component/helper.php:4556 JComponentHelper::load() Copy JROOT/libraries/cms/component/helper.php:435 JComponentHelper::getComponent() Copy JROOT/libraries/cms/component/helper.php:1114 JComponentHelper::getParams() Copy JROOT/libraries/cms/application/site.php:5983 JApplicationSite->initialiseApp() Copy JROOT/libraries/cms/application/site.php:2092 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2731 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:1.14 ms 最後のクエリの後:1.72 ms クエリメモリ:0.021 MB クエリ前のメモリ:4.632 MB 返された行:7
SELECT id, rules
FROM `joom_viewlevels `クエリではEXPLAINは使用できません:SELECT id, rules
FROM `joom_viewlevels`
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.03 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 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.02 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 10 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:15319 JDatabaseDriver->loadAssocList() Copy JROOT/libraries/joomla/access/access.php:10628 JAccess::getAuthorisedViewLevels() Copy JROOT/libraries/joomla/user/user.php:4537 JUser->getAuthorisedViewLevels() Copy JROOT/libraries/cms/plugin/helper.php:2936 JPluginHelper::load() Copy JROOT/libraries/cms/plugin/helper.php:865 JPluginHelper::getPlugin() Copy JROOT/libraries/cms/plugin/helper.php:1284 JPluginHelper::isEnabled() Copy JROOT/libraries/cms/application/site.php:6083 JApplicationSite->initialiseApp() Copy JROOT/libraries/cms/application/site.php:2092 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2731 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:1.26 ms 最後のクエリの後:0.06 ms クエリメモリ:0.021 MB クエリ前のメモリ:4.644 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.04 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.06 ms preparing 0.02 ms executing 0.02 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms
# 発信者 ファイルと行番号 11 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:157510 JDatabaseDriver->loadColumn() Copy JROOT/libraries/joomla/access/access.php:9799 JAccess::getGroupsByUser() Copy JROOT/libraries/joomla/access/access.php:10948 JAccess::getAuthorisedViewLevels() Copy JROOT/libraries/joomla/user/user.php:4537 JUser->getAuthorisedViewLevels() Copy JROOT/libraries/cms/plugin/helper.php:2936 JPluginHelper::load() Copy JROOT/libraries/cms/plugin/helper.php:865 JPluginHelper::getPlugin() Copy JROOT/libraries/cms/plugin/helper.php:1284 JPluginHelper::isEnabled() Copy JROOT/libraries/cms/application/site.php:6083 JApplicationSite->initialiseApp() Copy JROOT/libraries/cms/application/site.php:2092 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2731 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:2.64 ms 最後のクエリの後:0.48 ms クエリメモリ:0.046 MB クエリ前のメモリ:4.706 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.05 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.01 ms statistics 0.05 ms preparing 0.03 ms executing 1.36 ms end 0.01 ms query end 0.03 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 10 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:17269 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:2731 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:1.24 ms 最後のクエリの後:6.64 ms クエリメモリ:0.024 MB クエリ前のメモリ:5.715 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.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.03 ms optimizing 0.01 ms statistics 0.08 ms preparing 0.02 ms executing 0.03 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms
# 発信者 ファイルと行番号 17 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:168716 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:7779 JFactory::createDocument() Copy JROOT/libraries/joomla/factory.php:2168 JFactory::getDocument() Copy JROOT/plugins/system/mootable/mootable.php:1007 PlgSystemMootable->__construct() Copy JROOT/libraries/cms/plugin/helper.php:2556 JPluginHelper::import() Copy JROOT/libraries/cms/plugin/helper.php:1705 JPluginHelper::importPlugin() Copy JROOT/libraries/cms/application/cms.php:7474 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:2731 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:1.18 ms 最後のクエリの後:0.11 ms クエリメモリ:0.006 MB クエリ前のメモリ:5.707 MB
UPDATE `joom_extensions `
SET `params` = '{\"mediaversion\":\"af3b1724a69aed76c920d9e6865e8a0c\"}'
WHERE `type` = 'library' AND `element` = 'joomla'クエリではEXPLAINは使用できません:UPDATE `joom_extensions`
SET `params` = '{\"mediaversion\":\"af3b1724a69aed76c920d9e6865e8a0c\"}'
WHERE `type` = 'library' AND `element` = 'joomla'
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.08 ms updating 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.01 ms cleaning up 0.00 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:7779 JFactory::createDocument() Copy JROOT/libraries/joomla/factory.php:2168 JFactory::getDocument() Copy JROOT/plugins/system/mootable/mootable.php:1007 PlgSystemMootable->__construct() Copy JROOT/libraries/cms/plugin/helper.php:2556 JPluginHelper::import() Copy JROOT/libraries/cms/plugin/helper.php:1705 JPluginHelper::importPlugin() Copy JROOT/libraries/cms/application/cms.php:7474 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:2731 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:1.31 ms 最後のクエリの後:23.30 ms クエリメモリ:0.029 MB クエリ前のメモリ:8.108 MB 返された行:19
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.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.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.00 ms
# 発信者 ファイルと行番号 10 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:17269 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:7474 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:2731 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:1.21 ms 最後のクエリの後:0.40 ms クエリメモリ:0.021 MB クエリ前のメモリ:8.180 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.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.04 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms
# 発信者 ファイルと行番号 10 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:16879 JDatabaseDriver->loadObject() Copy JROOT/libraries/axslibs/language.php:1838 AxsLanguage::getSubdomainDefault() Copy JROOT/plugins/system/languagefilter/languagefilter.php:1037 PlgSystemLanguageFilter->__construct() Copy JROOT/libraries/cms/plugin/helper.php:2556 JPluginHelper::import() Copy JROOT/libraries/cms/plugin/helper.php:1705 JPluginHelper::importPlugin() Copy JROOT/libraries/cms/application/cms.php:7474 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:2731 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:1.48 ms 最後のクエリの後:0.05 ms クエリメモリ:0.030 MB クエリ前のメモリ:8.188 MB 返された行:94
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.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.34 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:17269 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:7474 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:2731 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:1.26 ms 最後のクエリの後:0.89 ms クエリメモリ:0.022 MB クエリ前のメモリ:8.321 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.06 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.04 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.02 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.00 ms
# 発信者 ファイルと行番号 13 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172612 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/axslibs/brands.php:29811 AxsBrands::getData() Copy JROOT/libraries/axslibs/brands.php:36310 AxsBrands::getBrandObject() Copy JROOT/libraries/axslibs/brands.php:559 AxsBrands::getBrand() Copy JROOT/plugins/system/axslibs/axslibs.php:358 plgSystemAxslibs->onAfterInitialise() Copy JROOT/libraries/joomla/event/event.php:707 JEvent->update() Copy JROOT/libraries/joomla/event/dispatcher.php:1606 JEventDispatcher->trigger() Copy JROOT/libraries/joomla/application/base.php:1065 JApplicationBase->triggerEvent() Copy JROOT/libraries/cms/application/cms.php:7484 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:2731 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:1.36 ms 最後のクエリの後:0.04 ms クエリメモリ:0.030 MB クエリ前のメモリ:8.343 MB 返された行:19
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.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.02 ms preparing 0.03 ms executing 0.15 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms
# 発信者 ファイルと行番号 14 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172613 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/axslibs/language.php:34212 AxsLanguage::getPublishedLanguages() Copy JROOT/libraries/axslibs/language.php:25111 AxsLanguage::getCurrentLanguage() Copy JROOT/libraries/axslibs/brands.php:37910 AxsBrands::getBrandObject() Copy JROOT/libraries/axslibs/brands.php:559 AxsBrands::getBrand() Copy JROOT/plugins/system/axslibs/axslibs.php:358 plgSystemAxslibs->onAfterInitialise() Copy JROOT/libraries/joomla/event/event.php:707 JEvent->update() Copy JROOT/libraries/joomla/event/dispatcher.php:1606 JEventDispatcher->trigger() Copy JROOT/libraries/joomla/application/base.php:1065 JApplicationBase->triggerEvent() Copy JROOT/libraries/cms/application/cms.php:7484 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:2731 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:1.14 ms 最後のクエリの後:1.16 ms クエリメモリ:0.021 MB クエリ前のメモリ:8.640 MB 返された行:1
SELECT * FROM `axs_homepage_templates` WHERE id= '1'クエリではEXPLAINは使用できません:SELECT * FROM `axs_homepage_templates` WHERE id='1'
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.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.04 ms preparing 0.01 ms executing 0.02 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms
# 発信者 ファイルと行番号 12 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172611 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/axslibs/brands.php:39610 AxsBrands::getBrandObject() Copy JROOT/libraries/axslibs/brands.php:559 AxsBrands::getBrand() Copy JROOT/plugins/system/axslibs/axslibs.php:358 plgSystemAxslibs->onAfterInitialise() Copy JROOT/libraries/joomla/event/event.php:707 JEvent->update() Copy JROOT/libraries/joomla/event/dispatcher.php:1606 JEventDispatcher->trigger() Copy JROOT/libraries/joomla/application/base.php:1065 JApplicationBase->triggerEvent() Copy JROOT/libraries/cms/application/cms.php:7484 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:2731 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:1.14 ms 最後のクエリの後:0.07 ms クエリメモリ:0.021 MB クエリ前のメモリ:8.681 MB 返された行:1
SELECT * FROM `axs_dashboard_templates` WHERE id= '2'クエリではEXPLAINは使用できません:SELECT * FROM `axs_dashboard_templates` WHERE id='2'
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.05 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.01 ms executing 0.02 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms
# 発信者 ファイルと行番号 12 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172611 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/axslibs/brands.php:41410 AxsBrands::getBrandObject() Copy JROOT/libraries/axslibs/brands.php:559 AxsBrands::getBrand() Copy JROOT/plugins/system/axslibs/axslibs.php:358 plgSystemAxslibs->onAfterInitialise() Copy JROOT/libraries/joomla/event/event.php:707 JEvent->update() Copy JROOT/libraries/joomla/event/dispatcher.php:1606 JEventDispatcher->trigger() Copy JROOT/libraries/joomla/application/base.php:1065 JApplicationBase->triggerEvent() Copy JROOT/libraries/cms/application/cms.php:7484 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:2731 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:1.08 ms 最後のクエリの後:0.05 ms クエリメモリ:0.022 MB クエリ前のメモリ:8.701 MB 返された行:1
SELECT *
FROM axs_email_settings
WHERE id = '1'クエリではEXPLAINは使用できません:SELECT *
FROM axs_email_settings
WHERE id = '1'
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.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.00 ms
# 発信者 ファイルと行番号 13 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:168712 JDatabaseDriver->loadObject() Copy JROOT/libraries/axslibs/brands.php:64011 AxsBrands::getEmailSettingsById() Copy JROOT/libraries/axslibs/brands.php:41710 AxsBrands::getBrandObject() Copy JROOT/libraries/axslibs/brands.php:559 AxsBrands::getBrand() Copy JROOT/plugins/system/axslibs/axslibs.php:358 plgSystemAxslibs->onAfterInitialise() Copy JROOT/libraries/joomla/event/event.php:707 JEvent->update() Copy JROOT/libraries/joomla/event/dispatcher.php:1606 JEventDispatcher->trigger() Copy JROOT/libraries/joomla/application/base.php:1065 JApplicationBase->triggerEvent() Copy JROOT/libraries/cms/application/cms.php:7484 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:2731 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:1.07 ms 最後のクエリの後:0.04 ms クエリメモリ:0.022 MB クエリ前のメモリ:8.708 MB 返された行:1
SELECT *
FROM axs_payment_gateways
WHERE id = '1'クエリではEXPLAINは使用できません:SELECT *
FROM axs_payment_gateways
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.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.00 ms
# 発信者 ファイルと行番号 13 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:168712 JDatabaseDriver->loadObject() Copy JROOT/libraries/axslibs/brands.php:59011 AxsBrands::getPaymentGatewayById() Copy JROOT/libraries/axslibs/brands.php:42010 AxsBrands::getBrandObject() Copy JROOT/libraries/axslibs/brands.php:559 AxsBrands::getBrand() Copy JROOT/plugins/system/axslibs/axslibs.php:358 plgSystemAxslibs->onAfterInitialise() Copy JROOT/libraries/joomla/event/event.php:707 JEvent->update() Copy JROOT/libraries/joomla/event/dispatcher.php:1606 JEventDispatcher->trigger() Copy JROOT/libraries/joomla/application/base.php:1065 JApplicationBase->triggerEvent() Copy JROOT/libraries/cms/application/cms.php:7484 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:2731 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:1.11 ms 最後のクエリの後:0.05 ms クエリメモリ:0.022 MB クエリ前のメモリ:8.722 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.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
# 発信者 ファイルと行番号 13 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:168712 JDatabaseDriver->loadObject() Copy JROOT/libraries/axslibs/brands.php:66711 AxsBrands::getIntegrationById() Copy JROOT/libraries/axslibs/brands.php:42610 AxsBrands::getBrandObject() Copy JROOT/libraries/axslibs/brands.php:559 AxsBrands::getBrand() Copy JROOT/plugins/system/axslibs/axslibs.php:358 plgSystemAxslibs->onAfterInitialise() Copy JROOT/libraries/joomla/event/event.php:707 JEvent->update() Copy JROOT/libraries/joomla/event/dispatcher.php:1606 JEventDispatcher->trigger() Copy JROOT/libraries/joomla/application/base.php:1065 JApplicationBase->triggerEvent() Copy JROOT/libraries/cms/application/cms.php:7484 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:2731 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:2.52 ms 最後のクエリの後:9.71 ms クエリメモリ:0.101 MB クエリ前のメモリ:10.435 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.09 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.14 ms preparing 0.05 ms executing 1.05 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.01 ms closing tables 0.02 ms freeing items 0.03 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 22 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172621 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/cms/menu/site.php:8820 JMenuSite->{closure}() Copy JROOT/libraries/joomla/cache/controller/callback.php:16919 JCacheControllerCallback->get() Copy JROOT/libraries/cms/menu/site.php:9618 JMenuSite->load() Copy JROOT/libraries/cms/menu/menu.php:7417 JMenu->__construct() Copy JROOT/libraries/cms/menu/site.php:5716 JMenuSite->__construct() Copy JROOT/libraries/cms/menu/menu.php:12915 JMenu::getInstance() Copy JROOT/libraries/cms/application/cms.php:50814 JApplicationCms->getMenu() Copy JROOT/libraries/cms/application/site.php:27713 JApplicationSite->getMenu() Copy JROOT/libraries/cms/router/site.php:5912 JRouterSite->__construct() Copy JROOT/libraries/cms/router/router.php:19811 JRouter::getInstance() Copy JROOT/libraries/cms/application/cms.php:61310 JApplicationCms::getRouter() Copy JROOT/libraries/cms/application/site.php:4079 JApplicationSite::getRouter() Copy JROOT/plugins/system/languagefilter/languagefilter.php:1348 PlgSystemLanguageFilter->onAfterInitialise() Copy JROOT/libraries/joomla/event/event.php:707 JEvent->update() Copy JROOT/libraries/joomla/event/dispatcher.php:1606 JEventDispatcher->trigger() Copy JROOT/libraries/joomla/application/base.php:1065 JApplicationBase->triggerEvent() Copy JROOT/libraries/cms/application/cms.php:7484 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:2731 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:2.52 ms 最後のクエリの後:13.57 ms クエリメモリ:0.028 MB クエリ前のメモリ:12.711 MB 返された行:17
SHOW FULL COLUMNS FROM `joom_users `クエリではEXPLAINは使用できません:SHOW FULL COLUMNS FROM `joom_users`
Status Duration starting 0.05 ms Executing hook on transaction 0.01 ms starting 0.05 ms checking permissions 0.01 ms checking permissions 0.00 ms Opening tables 0.50 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.10 ms preparing 0.03 ms Creating tmp table 0.05 ms executing 0.09 ms checking permissions 0.06 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.02 ms checking permissions 0.04 ms checking permissions 0.03 ms checking permissions 0.02 ms checking permissions 0.03 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.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.05 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 20 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172619 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/joomla/database/driver/mysqli.php:42118 JDatabaseDriverMysqli->getTableColumns() Copy JROOT/libraries/joomla/table/table.php:24417 JTable->getFields() Copy JROOT/libraries/joomla/table/table.php:16316 JTable->__construct() Copy JROOT/libraries/joomla/table/user.php:3915 JTableUser->__construct() Copy JROOT/libraries/joomla/table/table.php:31114 JTable::getInstance() Copy JROOT/libraries/joomla/user/user.php:59813 JUser::getTable() Copy JROOT/libraries/joomla/user/user.php:78212 JUser->save() Copy JROOT/plugins/system/languagefilter/languagefilter.php:84811 PlgSystemLanguageFilter->setPreferredLanguage() Copy JROOT/plugins/system/languagefilter/languagefilter.php:51210 PlgSystemLanguageFilter->parseRule() Copy JROOT/libraries/cms/router/router.php:5979 JRouter->processParseRules() Copy JROOT/libraries/cms/router/site.php:5848 JRouterSite->processParseRules() Copy JROOT/libraries/cms/router/router.php:5717 JRouter->_processParseRules() Copy JROOT/libraries/cms/router/router.php:2256 JRouter->parse() Copy JROOT/libraries/cms/router/site.php:1335 JRouterSite->parse() Copy JROOT/libraries/cms/application/cms.php:12284 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:2731 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:1.18 ms 最後のクエリの後:0.27 ms クエリメモリ:0.022 MB クエリ前のメモリ:12.755 MB 返された行:1
SELECT `id`,`title`
FROM `joom_usergroups `
WHERE `id` = 1クエリではEXPLAINは使用できません:SELECT `id`,`title`
FROM `joom_usergroups`
WHERE `id` = 1
Status Duration starting 0.04 ms Executing hook on transaction 0.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.00 ms
# 発信者 ファイルと行番号 15 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:153114 JDatabaseDriver->loadAssocList() Copy JROOT/libraries/joomla/table/user.php:15213 JTableUser->bind() Copy JROOT/libraries/joomla/user/user.php:78412 JUser->save() Copy JROOT/plugins/system/languagefilter/languagefilter.php:84811 PlgSystemLanguageFilter->setPreferredLanguage() Copy JROOT/plugins/system/languagefilter/languagefilter.php:51210 PlgSystemLanguageFilter->parseRule() Copy JROOT/libraries/cms/router/router.php:5979 JRouter->processParseRules() Copy JROOT/libraries/cms/router/site.php:5848 JRouterSite->processParseRules() Copy JROOT/libraries/cms/router/router.php:5717 JRouter->_processParseRules() Copy JROOT/libraries/cms/router/router.php:2256 JRouter->parse() Copy JROOT/libraries/cms/router/site.php:1335 JRouterSite->parse() Copy JROOT/libraries/cms/application/cms.php:12284 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:2731 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:1.21 ms 最後のクエリの後:9.44 ms クエリメモリ:0.022 MB クエリ前のメモリ:13.560 MB 返された行:0
SELECT *
FROM joom_easyblog_configs
WHERE `name` = 'config'クエリではEXPLAINは使用できません:SELECT *
FROM joom_easyblog_configs
WHERE `name` = 'config'
Status Duration starting 0.05 ms Executing hook on transaction 0.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.03 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms
# 発信者 ファイルと行番号 14 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:149013 JDatabaseDriver->loadAssoc() Copy JROOT/libraries/joomla/table/table.php:72912 JTable->load() Copy JROOT/administrator/components/com_easyblog/includes/easyblog.php:41511 EB::config() Copy JROOT/components/com_easyblog/router.php:30910 EasyBlogParseRoute() Copy JROOT/libraries/cms/component/router/legacy.php:1049 JComponentRouterLegacy->parse() Copy JROOT/libraries/cms/router/site.php:4328 JRouterSite->parseSefRoute() Copy JROOT/libraries/cms/router/router.php:4837 JRouter->_parseSefRoute() Copy JROOT/libraries/cms/router/router.php:2366 JRouter->parse() Copy JROOT/libraries/cms/router/site.php:1335 JRouterSite->parse() Copy JROOT/libraries/cms/application/cms.php:12284 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:2731 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:2.42 ms 最後のクエリの後:0.15 ms クエリメモリ:0.023 MB クエリ前のメモリ:13.610 MB 返された行:1
SELECT * FROM joom_extensions WHERE name= 'com_media'クエリではEXPLAINは使用できません:SELECT * FROM joom_extensions WHERE name='com_media'
Status Duration starting 0.04 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.02 ms executing 1.06 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 15 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:168714 JDatabaseDriver->loadObject() Copy JROOT/libraries/axslibs/images.php:6613 AxsImages::setSession() Copy JROOT/libraries/axslibs/images.php:1512 AxsImages::getImagesPath() Copy JROOT/administrator/components/com_easyblog/includes/easyblog.php:43011 EB::config() Copy JROOT/components/com_easyblog/router.php:30910 EasyBlogParseRoute() Copy JROOT/libraries/cms/component/router/legacy.php:1049 JComponentRouterLegacy->parse() Copy JROOT/libraries/cms/router/site.php:4328 JRouterSite->parseSefRoute() Copy JROOT/libraries/cms/router/router.php:4837 JRouter->_parseSefRoute() Copy JROOT/libraries/cms/router/router.php:2366 JRouter->parse() Copy JROOT/libraries/cms/router/site.php:1335 JRouterSite->parse() Copy JROOT/libraries/cms/application/cms.php:12284 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:2731 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:1.48 ms 最後のクエリの後:6.76 ms クエリメモリ:0.032 MB クエリ前のメモリ:14.410 MB 返された行:40
SELECT * FROM `joom_easyblog_acl ` WHERE `published`= '1' ORDER BY `id` ASC クエリではEXPLAINは使用できません:SELECT * FROM `joom_easyblog_acl` WHERE `published`='1' ORDER BY `id` ASC
Status Duration starting 0.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.08 ms preparing 0.03 ms executing 0.14 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.04 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 17 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172616 JDatabaseDriver->loadObjectList() Copy JROOT/administrator/components/com_easyblog/includes/acl/acl.php:29815 EasyBlogAcl::getRules() Copy JROOT/administrator/components/com_easyblog/includes/acl/acl.php:3814 EasyBlogAcl::getRuleSet() Copy JROOT/administrator/components/com_easyblog/includes/easyblog.php:14113 EB::acl() Copy JROOT/administrator/components/com_easyblog/includes/post/post.php:20512 EasyBlogPost->__construct() Copy JROOT/administrator/components/com_easyblog/includes/easyblog.php:436311 EB::post() Copy JROOT/components/com_easyblog/router.php:40310 EasyBlogParseRoute() Copy JROOT/libraries/cms/component/router/legacy.php:1049 JComponentRouterLegacy->parse() Copy JROOT/libraries/cms/router/site.php:4328 JRouterSite->parseSefRoute() Copy JROOT/libraries/cms/router/router.php:4837 JRouter->_parseSefRoute() Copy JROOT/libraries/cms/router/router.php:2366 JRouter->parse() Copy JROOT/libraries/cms/router/site.php:1335 JRouterSite->parse() Copy JROOT/libraries/cms/application/cms.php:12284 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:2731 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:1.29 ms 最後のクエリの後:0.08 ms クエリメモリ:0.028 MB クエリ前のメモリ:14.443 MB 返された行:40
SELECT * FROM `joom_easyblog_acl_group ` WHERE `content_id`= '1' AND `type`= ' group'クエリではEXPLAINは使用できません:SELECT * FROM `joom_easyblog_acl_group` WHERE `content_id`='1' AND `type`='group'
Status Duration starting 0.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.06 ms preparing 0.03 ms executing 0.14 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:172616 JDatabaseDriver->loadObjectList() Copy JROOT/administrator/components/com_easyblog/includes/utils.php:23515 EasyBlogDbJoomla->__call() Copy JROOT/administrator/components/com_easyblog/includes/acl/acl.php:11214 EasyBlogAcl::getRuleSet() Copy JROOT/administrator/components/com_easyblog/includes/easyblog.php:14113 EB::acl() Copy JROOT/administrator/components/com_easyblog/includes/post/post.php:20512 EasyBlogPost->__construct() Copy JROOT/administrator/components/com_easyblog/includes/easyblog.php:436311 EB::post() Copy JROOT/components/com_easyblog/router.php:40310 EasyBlogParseRoute() Copy JROOT/libraries/cms/component/router/legacy.php:1049 JComponentRouterLegacy->parse() Copy JROOT/libraries/cms/router/site.php:4328 JRouterSite->parseSefRoute() Copy JROOT/libraries/cms/router/router.php:4837 JRouter->_parseSefRoute() Copy JROOT/libraries/cms/router/router.php:2366 JRouter->parse() Copy JROOT/libraries/cms/router/site.php:1335 JRouterSite->parse() Copy JROOT/libraries/cms/application/cms.php:12284 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:2731 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:1.20 ms 最後のクエリの後:0.12 ms クエリメモリ:0.022 MB クエリ前のメモリ:14.457 MB 返された行:0
SELECT `id` FROM `joom_easyblog_post ` WHERE `permalink`= 'stage:test'クエリではEXPLAINは使用できません:SELECT `id` FROM `joom_easyblog_post` WHERE `permalink`='stage:test'
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.05 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.06 ms preparing 0.02 ms executing 0.02 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms
# 発信者 ファイルと行番号 14 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:176513 JDatabaseDriver->loadResult() Copy JROOT/administrator/components/com_easyblog/includes/utils.php:23512 EasyBlogDbJoomla->__call() Copy JROOT/administrator/components/com_easyblog/includes/post/post.php:39511 EasyBlogPost->loadByPermalink() Copy JROOT/components/com_easyblog/router.php:40410 EasyBlogParseRoute() Copy JROOT/libraries/cms/component/router/legacy.php:1049 JComponentRouterLegacy->parse() Copy JROOT/libraries/cms/router/site.php:4328 JRouterSite->parseSefRoute() Copy JROOT/libraries/cms/router/router.php:4837 JRouter->_parseSefRoute() Copy JROOT/libraries/cms/router/router.php:2366 JRouter->parse() Copy JROOT/libraries/cms/router/site.php:1335 JRouterSite->parse() Copy JROOT/libraries/cms/application/cms.php:12284 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:2731 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:1.47 ms 最後のクエリの後:0.16 ms クエリメモリ:0.022 MB クエリ前のメモリ:14.468 MB 返された行:1
SELECT `id` FROM `joom_easyblog_post ` WHERE `permalink`= 'stage-test'クエリではEXPLAINは使用できません:SELECT `id` FROM `joom_easyblog_post` WHERE `permalink`='stage-test'
Status Duration starting 0.04 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.01 ms executing 0.03 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms
# 発信者 ファイルと行番号 14 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:176513 JDatabaseDriver->loadResult() Copy JROOT/administrator/components/com_easyblog/includes/utils.php:23512 EasyBlogDbJoomla->__call() Copy JROOT/administrator/components/com_easyblog/includes/post/post.php:40911 EasyBlogPost->loadByPermalink() Copy JROOT/components/com_easyblog/router.php:40410 EasyBlogParseRoute() Copy JROOT/libraries/cms/component/router/legacy.php:1049 JComponentRouterLegacy->parse() Copy JROOT/libraries/cms/router/site.php:4328 JRouterSite->parseSefRoute() Copy JROOT/libraries/cms/router/router.php:4837 JRouter->_parseSefRoute() Copy JROOT/libraries/cms/router/router.php:2366 JRouter->parse() Copy JROOT/libraries/cms/router/site.php:1335 JRouterSite->parse() Copy JROOT/libraries/cms/application/cms.php:12284 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:2731 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:1.24 ms 最後のクエリの後:1.24 ms クエリメモリ:0.024 MB クエリ前のメモリ:14.576 MB 返された行:1
SELECT *
FROM joom_easyblog_post
WHERE `id` = '3'クエリではEXPLAINは使用できません:SELECT *
FROM joom_easyblog_post
WHERE `id` = '3'
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.04 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.01 ms executing 0.02 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms
# 発信者 ファイルと行番号 17 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:149016 JDatabaseDriver->loadAssoc() Copy JROOT/libraries/joomla/table/table.php:72915 JTable->load() Copy JROOT/administrator/components/com_easyblog/tables/post.php:7914 EasyBlogTablePost->load() Copy JROOT/administrator/components/com_easyblog/includes/post/post.php:33113 EasyBlogPost->loadPost() Copy JROOT/administrator/components/com_easyblog/includes/post/post.php:25612 EasyBlogPost->load() Copy JROOT/administrator/components/com_easyblog/includes/post/post.php:41311 EasyBlogPost->loadByPermalink() Copy JROOT/components/com_easyblog/router.php:40410 EasyBlogParseRoute() Copy JROOT/libraries/cms/component/router/legacy.php:1049 JComponentRouterLegacy->parse() Copy JROOT/libraries/cms/router/site.php:4328 JRouterSite->parseSefRoute() Copy JROOT/libraries/cms/router/router.php:4837 JRouter->_parseSefRoute() Copy JROOT/libraries/cms/router/router.php:2366 JRouter->parse() Copy JROOT/libraries/cms/router/site.php:1335 JRouterSite->parse() Copy JROOT/libraries/cms/application/cms.php:12284 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:2731 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:1.17 ms 最後のクエリの後:0.55 ms クエリメモリ:0.023 MB クエリ前のメモリ:14.679 MB 返された行:1
SELECT *
FROM joom_easyblog_revisions
WHERE `id` = '14'クエリではEXPLAINは使用できません:SELECT *
FROM joom_easyblog_revisions
WHERE `id` = '14'
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.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.00 ms
# 発信者 ファイルと行番号 16 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:149015 JDatabaseDriver->loadAssoc() Copy JROOT/libraries/joomla/table/table.php:72914 JTable->load() Copy JROOT/administrator/components/com_easyblog/includes/post/post.php:36913 EasyBlogPost::loadRevision() Copy JROOT/administrator/components/com_easyblog/includes/post/post.php:28512 EasyBlogPost->load() Copy JROOT/administrator/components/com_easyblog/includes/post/post.php:41311 EasyBlogPost->loadByPermalink() Copy JROOT/components/com_easyblog/router.php:40410 EasyBlogParseRoute() Copy JROOT/libraries/cms/component/router/legacy.php:1049 JComponentRouterLegacy->parse() Copy JROOT/libraries/cms/router/site.php:4328 JRouterSite->parseSefRoute() Copy JROOT/libraries/cms/router/router.php:4837 JRouter->_parseSefRoute() Copy JROOT/libraries/cms/router/router.php:2366 JRouter->parse() Copy JROOT/libraries/cms/router/site.php:1335 JRouterSite->parse() Copy JROOT/libraries/cms/application/cms.php:12284 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:2731 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:1.21 ms 最後のクエリの後:0.36 ms クエリメモリ:0.024 MB クエリ前のメモリ:14.712 MB 返された行:1
SELECT * FROM `joom_easyblog_meta ` WHERE `type`= 'post' AND `content_id`= '3'クエリではEXPLAINは使用できません:SELECT * FROM `joom_easyblog_meta` WHERE `type`='post' AND `content_id`='3'
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.05 ms preparing 0.01 ms executing 0.03 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms
# 発信者 ファイルと行番号 17 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:168716 JDatabaseDriver->loadObject() Copy JROOT/administrator/components/com_easyblog/includes/utils.php:23515 EasyBlogDbJoomla->__call() Copy JROOT/administrator/components/com_easyblog/tables/meta.php:5114 EasyBlogTableMeta->loadByType() Copy JROOT/administrator/components/com_easyblog/includes/post/post.php:45213 EasyBlogPost->loadMeta() Copy JROOT/administrator/components/com_easyblog/includes/post/post.php:30412 EasyBlogPost->load() Copy JROOT/administrator/components/com_easyblog/includes/post/post.php:41311 EasyBlogPost->loadByPermalink() Copy JROOT/components/com_easyblog/router.php:40410 EasyBlogParseRoute() Copy JROOT/libraries/cms/component/router/legacy.php:1049 JComponentRouterLegacy->parse() Copy JROOT/libraries/cms/router/site.php:4328 JRouterSite->parseSefRoute() Copy JROOT/libraries/cms/router/router.php:4837 JRouter->_parseSefRoute() Copy JROOT/libraries/cms/router/router.php:2366 JRouter->parse() Copy JROOT/libraries/cms/router/site.php:1335 JRouterSite->parse() Copy JROOT/libraries/cms/application/cms.php:12284 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:2731 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:1.13 ms 最後のクエリの後:12.52 ms クエリメモリ:0.019 MB クエリ前のメモリ:15.149 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.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.05 ms executing 0.02 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms
# 発信者 ファイルと行番号 7 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:16876 JDatabaseDriver->loadObject() Copy JROOT/libraries/axslibs/user.php:7075 AxsUser::getGlobalUserSettings() Copy JROOT/libraries/axslibs/security.php:354 AxsSecurity::getSettings() Copy JROOT/libraries/cms/application/cms.php:3853 JApplicationCms->checkUserRequireTwoFactor() Copy JROOT/libraries/cms/application/site.php:2312 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2731 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:1.24 ms 最後のクエリの後:2.94 ms クエリメモリ:0.019 MB クエリ前のメモリ:15.476 MB 返された行:0
SELECT *
FROM `joom_users `
WHERE `id` = 3クエリではEXPLAINは使用できません:SELECT *
FROM `joom_users`
WHERE `id` = 3
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.05 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 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.02 ms cleaning up 0.00 ms
# 発信者 ファイルと行番号 6 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:16875 JDatabaseDriver->loadObject() Copy JROOT/administrator/components/com_users/models/user.php:9924 UsersModelUser->getOtpConfig() Copy JROOT/libraries/cms/application/cms.php:3893 JApplicationCms->checkUserRequireTwoFactor() Copy JROOT/libraries/cms/application/site.php:2312 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2731 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:1.37 ms 最後のクエリの後:0.19 ms クエリメモリ:0.019 MB クエリ前のメモリ:15.552 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.06 ms Executing hook on transaction 0.01 ms starting 0.03 ms checking permissions 0.01 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.06 ms preparing 0.03 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.03 ms cleaning up 0.04 ms
# 発信者 ファイルと行番号 6 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:17265 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:2731 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:1.20 ms 最後のクエリの後:2.63 ms クエリメモリ:0.008 MB クエリ前のメモリ:15.742 MB
DELETE FROM `joom_easyblog_mailq ` WHERE `status`= '1' AND DATEDIFF (NOW (), `created`) >= '7'クエリではEXPLAINは使用できません:DELETE FROM `joom_easyblog_mailq` WHERE `status`='1' AND DATEDIFF(NOW(), `created`) >='7'
Status Duration starting 0.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.06 ms updating 0.02 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.00 ms
# 発信者 ファイルと行番号 13 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/database.php:3312 JDatabase->query() Copy JROOT/administrator/components/com_easyblog/includes/utils.php:23511 EasyBlogDbJoomla->__call() Copy JROOT/administrator/components/com_easyblog/models/mailer.php:3910 EasyBlogModelMailer->cleanup() Copy JROOT/administrator/components/com_easyblog/includes/mailer/mailer.php:389 EasyBlogMailer->dispatch() Copy JROOT/components/com_easyblog/services/maintenance.php:188 require_once Copy JROOT/components/com_easyblog/services/maintenance.php Copy JROOT/administrator/components/com_easyblog/includes/easyblog.php:42757 EB::loadServices() Copy JROOT/components/com_easyblog/easyblog.php:336 require_once Copy JROOT/components/com_easyblog/easyblog.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2731 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:1.20 ms 最後のクエリの後:0.03 ms クエリメモリ:0.022 MB クエリ前のメモリ:15.750 MB 返された行:0
SELECT `id` FROM `joom_easyblog_mailq ` WHERE `status`= '0' ORDER BY `created` ASC LIMIT 5クエリではEXPLAINは使用できません:SELECT `id` FROM `joom_easyblog_mailq` WHERE `status`='0' ORDER BY `created` ASC LIMIT 5
Status Duration starting 0.05 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.05 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.06 ms preparing 0.03 ms executing 0.02 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 13 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172612 JDatabaseDriver->loadObjectList() Copy JROOT/administrator/components/com_easyblog/includes/utils.php:23511 EasyBlogDbJoomla->__call() Copy JROOT/administrator/components/com_easyblog/models/mailer.php:6510 EasyBlogModelMailer->getPendingEmails() Copy JROOT/administrator/components/com_easyblog/includes/mailer/mailer.php:419 EasyBlogMailer->dispatch() Copy JROOT/components/com_easyblog/services/maintenance.php:188 require_once Copy JROOT/components/com_easyblog/services/maintenance.php Copy JROOT/administrator/components/com_easyblog/includes/easyblog.php:42757 EB::loadServices() Copy JROOT/components/com_easyblog/easyblog.php:336 require_once Copy JROOT/components/com_easyblog/easyblog.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2731 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:1.36 ms 最後のクエリの後:5.52 ms クエリメモリ:0.022 MB クエリ前のメモリ:16.785 MB 返された行:0
SELECT * FROM `joom_easyblog_post ` WHERE `publish_up`<= '2025-04-04 13:06:07' AND `published`= '2' AND `state`= '0' ORDER BY `id` LIMIT 5クエリではEXPLAINは使用できません:SELECT * FROM `joom_easyblog_post` WHERE `publish_up`<='2025-04-04 13:06:07' AND `published`='2' AND `state`='0' ORDER BY `id` LIMIT 5
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.06 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.09 ms preparing 0.04 ms executing 0.05 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 13 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172612 JDatabaseDriver->loadObjectList() Copy JROOT/administrator/components/com_easyblog/includes/utils.php:23511 EasyBlogDbJoomla->__call() Copy JROOT/administrator/components/com_easyblog/models/blogs.php:27310 EasyBlogModelBlogs->getScheduledPosts() Copy JROOT/administrator/components/com_easyblog/includes/scheduler/scheduler.php:609 EasyBlogScheduler->publish() Copy JROOT/components/com_easyblog/services/maintenance.php:228 require_once Copy JROOT/components/com_easyblog/services/maintenance.php Copy JROOT/administrator/components/com_easyblog/includes/easyblog.php:42757 EB::loadServices() Copy JROOT/components/com_easyblog/easyblog.php:336 require_once Copy JROOT/components/com_easyblog/easyblog.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2731 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:1.17 ms 最後のクエリの後:0.05 ms クエリメモリ:0.022 MB クエリ前のメモリ:16.798 MB 返された行:0
SELECT id, created_by FROM `joom_easyblog_post ` WHERE `publish_down` > `publish_up` AND `publish_down` <= '2025-04-04 13:06:07' AND `publish_down` != '0000-00-00 00:00:00' AND `published` = '1' AND `state` = '0'クエリではEXPLAINは使用できません:SELECT id, created_by FROM`joom_easyblog_post` WHERE `publish_down` > `publish_up` AND `publish_down` <= '2025-04-04 13:06:07' AND `publish_down` != '0000-00-00 00:00:00' AND `published` = '1' AND `state` = '0'
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.02 ms statistics 0.06 ms preparing 0.02 ms executing 0.03 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms
# 発信者 ファイルと行番号 13 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172612 JDatabaseDriver->loadObjectList() Copy JROOT/administrator/components/com_easyblog/includes/utils.php:23511 EasyBlogDbJoomla->__call() Copy JROOT/administrator/components/com_easyblog/models/blogs.php:31610 EasyBlogModelBlogs->getUnpublishScheduledPosts() Copy JROOT/administrator/components/com_easyblog/includes/scheduler/scheduler.php:349 EasyBlogScheduler->unpublish() Copy JROOT/components/com_easyblog/services/maintenance.php:258 require_once Copy JROOT/components/com_easyblog/services/maintenance.php Copy JROOT/administrator/components/com_easyblog/includes/easyblog.php:42757 EB::loadServices() Copy JROOT/components/com_easyblog/easyblog.php:336 require_once Copy JROOT/components/com_easyblog/easyblog.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2731 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:1.12 ms 最後のクエリの後:0.29 ms クエリメモリ:0.022 MB クエリ前のメモリ:16.851 MB 返された行:0
SELECT * FROM `joom_easyblog_uploader_tmp ` WHERE `created` <= DATE_SUB ('2025-04-04 13:06:07' , INTERVAL 120 MINUTE )クエリではEXPLAINは使用できません:SELECT * FROM `joom_easyblog_uploader_tmp` WHERE `created` <= DATE_SUB('2025-04-04 13:06:07' , INTERVAL 120 MINUTE)
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.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.00 ms
# 発信者 ファイルと行番号 12 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:168711 JDatabaseDriver->loadObject() Copy JROOT/administrator/components/com_easyblog/includes/utils.php:23510 EasyBlogDbJoomla->__call() Copy JROOT/administrator/components/com_easyblog/includes/scheduler/scheduler.php:979 EasyBlogScheduler->removeTmpFiles() Copy JROOT/components/com_easyblog/services/maintenance.php:288 require_once Copy JROOT/components/com_easyblog/services/maintenance.php Copy JROOT/administrator/components/com_easyblog/includes/easyblog.php:42757 EB::loadServices() Copy JROOT/components/com_easyblog/easyblog.php:336 require_once Copy JROOT/components/com_easyblog/easyblog.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2731 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:1.22 ms 最後のクエリの後:0.05 ms クエリメモリ:0.006 MB クエリ前のメモリ:16.858 MB
delete a, b from `joom_easyblog_post ` as a inner join `joom_easyblog_revisions ` as b on a.`id` = b.`post_id` where a.`published` = '9' and a.`created` <= DATE_SUB ('2025-04-04 13:06:07', INTERVAL 3 DAY ) クエリではEXPLAINは使用できません:delete a, b from `joom_easyblog_post` as a inner join `joom_easyblog_revisions` as b on a.`id` = b.`post_id` where a.`published` = '9' and a.`created` <= DATE_SUB('2025-04-04 13:06:07', INTERVAL 3 DAY)
Status Duration starting 0.05 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.04 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.07 ms preparing 0.02 ms deleting from main table 0.01 ms executing 0.04 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.00 ms
# 発信者 ファイルと行番号 12 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/database.php:3311 JDatabase->query() Copy JROOT/administrator/components/com_easyblog/includes/utils.php:23510 EasyBlogDbJoomla->__call() Copy JROOT/administrator/components/com_easyblog/includes/scheduler/scheduler.php:1349 EasyBlogScheduler->removeBlankPosts() Copy JROOT/components/com_easyblog/services/maintenance.php:328 require_once Copy JROOT/components/com_easyblog/services/maintenance.php Copy JROOT/administrator/components/com_easyblog/includes/easyblog.php:42757 EB::loadServices() Copy JROOT/components/com_easyblog/easyblog.php:336 require_once Copy JROOT/components/com_easyblog/easyblog.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2731 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:1.37 ms 最後のクエリの後:0.44 ms クエリメモリ:0.023 MB クエリ前のメモリ:16.936 MB 返された行:1
SELECT * FROM `joom_menu ` WHERE `published`= '1' AND `link` LIKE 'index.php?option= com_easyblog%' AND `menutype`= 'mainmenu'クエリではEXPLAINは使用できません:SELECT * FROM `joom_menu` WHERE `published`='1' AND `link` LIKE 'index.php?option=com_easyblog%' AND `menutype`='mainmenu'
Status Duration starting 0.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.05 ms preparing 0.02 ms executing 0.12 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms
# 発信者 ファイルと行番号 15 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172614 JDatabaseDriver->loadObjectList() Copy JROOT/administrator/components/com_easyblog/includes/utils.php:23513 EasyBlogDbJoomla->__call() Copy JROOT/administrator/components/com_easyblog/models/menu.php:5212 EasyBlogModelMenu->getAssociatedMenus() Copy JROOT/administrator/components/com_easyblog/includes/router.php:8011 EBR::getMenus() Copy JROOT/administrator/components/com_easyblog/includes/router.php:34710 EBR::_() Copy JROOT/administrator/components/com_easyblog/includes/easyblog.php:43239 EB::_() Copy JROOT/components/com_easyblog/services/weblog.php:278 require_once Copy JROOT/components/com_easyblog/services/weblog.php Copy JROOT/administrator/components/com_easyblog/includes/easyblog.php:42757 EB::loadServices() Copy JROOT/components/com_easyblog/easyblog.php:336 require_once Copy JROOT/components/com_easyblog/easyblog.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2731 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:1.87 ms 最後のクエリの後:1.95 ms クエリメモリ:0.030 MB クエリ前のメモリ:17.277 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.07 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.21 ms preparing 0.02 ms executing 0.36 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 21 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172620 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/joomla/access/access.php:42719 JAccess::preloadComponents() Copy JROOT/libraries/joomla/access/access.php:21118 JAccess::preload() Copy JROOT/libraries/joomla/access/access.php:53017 JAccess::getAssetRules() Copy JROOT/libraries/joomla/access/access.php:18116 JAccess::check() Copy JROOT/libraries/joomla/user/user.php:39315 JUser->authorise() Copy JROOT/administrator/components/com_easyblog/includes/easyblog.php:102014 EB::isSiteAdmin() Copy JROOT/administrator/components/com_easyblog/includes/themes/themes.php:9413 EasyBlogThemes->__construct() Copy JROOT/administrator/components/com_easyblog/includes/easyblog.php:423112 EB::template() Copy JROOT/components/com_easyblog/views/views.php:5111 EasyBlogView->__construct() Copy JROOT/libraries/legacy/controller/legacy.php:59710 JControllerLegacy->createView() Copy JROOT/libraries/legacy/controller/legacy.php:8439 JControllerLegacy->getView() Copy JROOT/components/com_easyblog/controllers/controller.php:728 EasyBlogController->display() Copy JROOT/libraries/legacy/controller/legacy.php:7097 JControllerLegacy->execute() Copy JROOT/components/com_easyblog/easyblog.php:436 require_once Copy JROOT/components/com_easyblog/easyblog.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2731 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:1.14 ms 最後のクエリの後:0.47 ms クエリメモリ:0.025 MB クエリ前のメモリ:17.394 MB 返された行:1
SELECT *
FROM joom_easyblog_post
WHERE `id` = '3'クエリではEXPLAINは使用できません:SELECT *
FROM joom_easyblog_post
WHERE `id` = '3'
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.04 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.01 ms executing 0.02 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 17 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:149016 JDatabaseDriver->loadAssoc() Copy JROOT/libraries/joomla/table/table.php:72915 JTable->load() Copy JROOT/administrator/components/com_easyblog/tables/post.php:7914 EasyBlogTablePost->load() Copy JROOT/administrator/components/com_easyblog/includes/post/post.php:33113 EasyBlogPost->loadPost() Copy JROOT/administrator/components/com_easyblog/includes/post/post.php:25612 EasyBlogPost->load() Copy JROOT/administrator/components/com_easyblog/includes/post/post.php:21111 EasyBlogPost->__construct() Copy JROOT/administrator/components/com_easyblog/includes/easyblog.php:436310 EB::post() Copy JROOT/components/com_easyblog/views/entry/view.html.php:329 EasyBlogViewEntry->display() Copy JROOT/components/com_easyblog/controllers/controller.php:1088 EasyBlogController->display() Copy JROOT/libraries/legacy/controller/legacy.php:7097 JControllerLegacy->execute() Copy JROOT/components/com_easyblog/easyblog.php:436 require_once Copy JROOT/components/com_easyblog/easyblog.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2731 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:1.12 ms 最後のクエリの後:0.06 ms クエリメモリ:0.023 MB クエリ前のメモリ:17.403 MB 返された行:1
SELECT *
FROM joom_easyblog_revisions
WHERE `id` = '14'クエリではEXPLAINは使用できません:SELECT *
FROM joom_easyblog_revisions
WHERE `id` = '14'
Status Duration starting 0.05 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.01 ms executing 0.01 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms
# 発信者 ファイルと行番号 16 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:149015 JDatabaseDriver->loadAssoc() Copy JROOT/libraries/joomla/table/table.php:72914 JTable->load() Copy JROOT/administrator/components/com_easyblog/includes/post/post.php:36913 EasyBlogPost::loadRevision() Copy JROOT/administrator/components/com_easyblog/includes/post/post.php:28512 EasyBlogPost->load() Copy JROOT/administrator/components/com_easyblog/includes/post/post.php:21111 EasyBlogPost->__construct() Copy JROOT/administrator/components/com_easyblog/includes/easyblog.php:436310 EB::post() Copy JROOT/components/com_easyblog/views/entry/view.html.php:329 EasyBlogViewEntry->display() Copy JROOT/components/com_easyblog/controllers/controller.php:1088 EasyBlogController->display() Copy JROOT/libraries/legacy/controller/legacy.php:7097 JControllerLegacy->execute() Copy JROOT/components/com_easyblog/easyblog.php:436 require_once Copy JROOT/components/com_easyblog/easyblog.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2731 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:1.17 ms 最後のクエリの後:0.07 ms クエリメモリ:0.024 MB クエリ前のメモリ:17.415 MB 返された行:1
SELECT * FROM `joom_easyblog_meta ` WHERE `type`= 'post' AND `content_id`= '3'クエリではEXPLAINは使用できません:SELECT * FROM `joom_easyblog_meta` WHERE `type`='post' AND `content_id`='3'
Status Duration starting 0.03 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.02 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.05 ms preparing 0.01 ms executing 0.03 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 17 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:168716 JDatabaseDriver->loadObject() Copy JROOT/administrator/components/com_easyblog/includes/utils.php:23515 EasyBlogDbJoomla->__call() Copy JROOT/administrator/components/com_easyblog/tables/meta.php:5114 EasyBlogTableMeta->loadByType() Copy JROOT/administrator/components/com_easyblog/includes/post/post.php:45213 EasyBlogPost->loadMeta() Copy JROOT/administrator/components/com_easyblog/includes/post/post.php:30412 EasyBlogPost->load() Copy JROOT/administrator/components/com_easyblog/includes/post/post.php:21111 EasyBlogPost->__construct() Copy JROOT/administrator/components/com_easyblog/includes/easyblog.php:436310 EB::post() Copy JROOT/components/com_easyblog/views/entry/view.html.php:329 EasyBlogViewEntry->display() Copy JROOT/components/com_easyblog/controllers/controller.php:1088 EasyBlogController->display() Copy JROOT/libraries/legacy/controller/legacy.php:7097 JControllerLegacy->execute() Copy JROOT/components/com_easyblog/easyblog.php:436 require_once Copy JROOT/components/com_easyblog/easyblog.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2731 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:1.24 ms 最後のクエリの後:0.31 ms クエリメモリ:0.023 MB クエリ前のメモリ:17.467 MB 返された行:0
SELECT COUNT (1) as `voted`, `uid` FROM `joom_easyblog_ratings ` WHERE `uid` = '3' AND `type`= 'entry' AND `created_by`= '0' AND (`sessionid` = 'osmj4mv20difvhgo577ls3ssaf' OR `ip` = '10.7.42.234') GROUP BY `uid` ORDER BY NULL クエリではEXPLAINは使用できません:SELECT COUNT(1) as `voted`, `uid` FROM `joom_easyblog_ratings` WHERE `uid` = '3' AND `type`='entry' AND `created_by`='0' AND (`sessionid` = 'osmj4mv20difvhgo577ls3ssaf' OR `ip` = '10.7.42.234') GROUP BY `uid` ORDER BY NULL
Status Duration starting 0.06 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.06 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.09 ms preparing 0.03 ms executing 0.02 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms
# 発信者 ファイルと行番号 15 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172614 JDatabaseDriver->loadObjectList() Copy JROOT/administrator/components/com_easyblog/includes/utils.php:23513 EasyBlogDbJoomla->__call() Copy JROOT/administrator/components/com_easyblog/models/ratings.php:13312 EasyBlogModelRatings->preloadUserPostRatings() Copy JROOT/administrator/components/com_easyblog/includes/cache/cache.php:33711 EasyBlogCache->cacheVoted() Copy JROOT/administrator/components/com_easyblog/includes/cache/cache.php:26110 EasyBlogCache->insert() Copy JROOT/components/com_easyblog/views/entry/view.html.php:439 EasyBlogViewEntry->display() Copy JROOT/components/com_easyblog/controllers/controller.php:1088 EasyBlogController->display() Copy JROOT/libraries/legacy/controller/legacy.php:7097 JControllerLegacy->execute() Copy JROOT/components/com_easyblog/easyblog.php:436 require_once Copy JROOT/components/com_easyblog/easyblog.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2731 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:1.15 ms 最後のクエリの後:0.03 ms クエリメモリ:0.023 MB クエリ前のメモリ:17.474 MB 返された行:0
SELECT AVG (`value`) AS `ratings` ,COUNT (1) AS `total` ,`uid` FROM `joom_easyblog_ratings ` AS a WHERE a.`uid` IN (3) AND `type`= 'entry' GROUP BY `uid` ORDER BY NULL クエリではEXPLAINは使用できません:SELECT AVG(`value`) AS `ratings` ,COUNT(1) AS `total` ,`uid` FROM `joom_easyblog_ratings` AS a WHERE a.`uid` IN(3) AND `type`='entry' GROUP BY `uid` ORDER BY NULL
Status Duration starting 0.05 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.00 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.06 ms preparing 0.03 ms executing 0.02 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms
# 発信者 ファイルと行番号 15 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172614 JDatabaseDriver->loadObjectList() Copy JROOT/administrator/components/com_easyblog/includes/utils.php:23513 EasyBlogDbJoomla->__call() Copy JROOT/administrator/components/com_easyblog/models/ratings.php:17412 EasyBlogModelRatings->preloadRatings() Copy JROOT/administrator/components/com_easyblog/includes/cache/cache.php:46111 EasyBlogCache->cacheRatings() Copy JROOT/administrator/components/com_easyblog/includes/cache/cache.php:26410 EasyBlogCache->insert() Copy JROOT/components/com_easyblog/views/entry/view.html.php:439 EasyBlogViewEntry->display() Copy JROOT/components/com_easyblog/controllers/controller.php:1088 EasyBlogController->display() Copy JROOT/libraries/legacy/controller/legacy.php:7097 JControllerLegacy->execute() Copy JROOT/components/com_easyblog/easyblog.php:436 require_once Copy JROOT/components/com_easyblog/easyblog.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2731 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:1.15 ms 最後のクエリの後:0.92 ms クエリメモリ:0.023 MB クエリ前のメモリ:17.624 MB 返された行:0
SELECT a.* FROM `joom_easyblog_comment ` AS a WHERE a.`post_id` IN (3) AND a.`published`= '1'クエリではEXPLAINは使用できません:SELECT a.* FROM `joom_easyblog_comment` AS a WHERE a.`post_id` IN(3) AND a.`published`='1'
Status Duration starting 0.04 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.06 ms preparing 0.02 ms executing 0.03 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 15 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172614 JDatabaseDriver->loadObjectList() Copy JROOT/administrator/components/com_easyblog/includes/utils.php:23513 EasyBlogDbJoomla->__call() Copy JROOT/administrator/components/com_easyblog/models/comment.php:57412 EasyBlogModelComment->preloadComments() Copy JROOT/administrator/components/com_easyblog/includes/cache/cache.php:49311 EasyBlogCache->cacheComments() Copy JROOT/administrator/components/com_easyblog/includes/cache/cache.php:26710 EasyBlogCache->insert() Copy JROOT/components/com_easyblog/views/entry/view.html.php:439 EasyBlogViewEntry->display() Copy JROOT/components/com_easyblog/controllers/controller.php:1088 EasyBlogController->display() Copy JROOT/libraries/legacy/controller/legacy.php:7097 JControllerLegacy->execute() Copy JROOT/components/com_easyblog/easyblog.php:436 require_once Copy JROOT/components/com_easyblog/easyblog.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2731 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:1.12 ms 最後のクエリの後:0.04 ms クエリメモリ:0.023 MB クエリ前のメモリ:17.631 MB 返された行:0
SELECT a.`post_id`, COUNT (1) AS `count` FROM `joom_easyblog_comment ` AS a WHERE a.`post_id` IN (3) AND a.`published`= '1' GROUP BY a.`post_id`クエリではEXPLAINは使用できません:SELECT a.`post_id`, COUNT(1) AS `count` FROM `joom_easyblog_comment` AS a WHERE a.`post_id` IN(3) AND a.`published`='1' GROUP BY a.`post_id`
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.02 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.02 ms executing 0.02 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms
# 発信者 ファイルと行番号 15 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172614 JDatabaseDriver->loadObjectList() Copy JROOT/administrator/components/com_easyblog/includes/utils.php:23513 EasyBlogDbJoomla->__call() Copy JROOT/administrator/components/com_easyblog/models/comment.php:61812 EasyBlogModelComment->preloadCommentCount() Copy JROOT/administrator/components/com_easyblog/includes/cache/cache.php:51911 EasyBlogCache->cacheCommentCount() Copy JROOT/administrator/components/com_easyblog/includes/cache/cache.php:27010 EasyBlogCache->insert() Copy JROOT/components/com_easyblog/views/entry/view.html.php:439 EasyBlogViewEntry->display() Copy JROOT/components/com_easyblog/controllers/controller.php:1088 EasyBlogController->display() Copy JROOT/libraries/legacy/controller/legacy.php:7097 JControllerLegacy->execute() Copy JROOT/components/com_easyblog/easyblog.php:436 require_once Copy JROOT/components/com_easyblog/easyblog.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2731 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:1.26 ms 最後のクエリの後:1.02 ms クエリメモリ:0.023 MB クエリ前のメモリ:17.799 MB 返された行:1
select a.* , b.`post_id`, b.`primary` from `joom_easyblog_category ` as a inner join `joom_easyblog_post_category ` as b on a.`id` = b.`category_id` where b.`post_id` IN ( 3) クエリではEXPLAINは使用できません:select a.*, b.`post_id`, b.`primary` from `joom_easyblog_category` as a inner join `joom_easyblog_post_category` as b on a.`id` = b.`category_id` where b.`post_id` IN ( 3)
Status Duration starting 0.04 ms Executing hook on transaction 0.00 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.07 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.02 ms cleaning up 0.00 ms
# 発信者 ファイルと行番号 15 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172614 JDatabaseDriver->loadObjectList() Copy JROOT/administrator/components/com_easyblog/includes/utils.php:23513 EasyBlogDbJoomla->__call() Copy JROOT/administrator/components/com_easyblog/models/category.php:139112 EasyBlogModelCategory->preloadByPosts() Copy JROOT/administrator/components/com_easyblog/includes/cache/cache.php:60011 EasyBlogCache->cacheCategories() Copy JROOT/administrator/components/com_easyblog/includes/cache/cache.php:27310 EasyBlogCache->insert() Copy JROOT/components/com_easyblog/views/entry/view.html.php:439 EasyBlogViewEntry->display() Copy JROOT/components/com_easyblog/controllers/controller.php:1088 EasyBlogController->display() Copy JROOT/libraries/legacy/controller/legacy.php:7097 JControllerLegacy->execute() Copy JROOT/components/com_easyblog/easyblog.php:436 require_once Copy JROOT/components/com_easyblog/easyblog.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2731 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:1.22 ms 最後のクエリの後:1.27 ms クエリメモリ:0.023 MB クエリ前のメモリ:18.080 MB 返された行:0
select a.* , b.`post_id` from `joom_easyblog_tag ` as a inner join `joom_easyblog_post_tag ` as b on a.`id` = b.`tag_id` where b.`post_id` IN ( 3) クエリではEXPLAINは使用できません:select a.*, b.`post_id` from `joom_easyblog_tag` as a inner join `joom_easyblog_post_tag` as b on a.`id` = b.`tag_id` where b.`post_id` IN ( 3)
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.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.03 ms cleaning up 0.00 ms
# 発信者 ファイルと行番号 15 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172614 JDatabaseDriver->loadObjectList() Copy JROOT/administrator/components/com_easyblog/includes/utils.php:23513 EasyBlogDbJoomla->__call() Copy JROOT/administrator/components/com_easyblog/models/tags.php:83212 EasyBlogModelTags->preloadByPosts() Copy JROOT/administrator/components/com_easyblog/includes/cache/cache.php:66711 EasyBlogCache->cacheTags() Copy JROOT/administrator/components/com_easyblog/includes/cache/cache.php:27610 EasyBlogCache->insert() Copy JROOT/components/com_easyblog/views/entry/view.html.php:439 EasyBlogViewEntry->display() Copy JROOT/components/com_easyblog/controllers/controller.php:1088 EasyBlogController->display() Copy JROOT/libraries/legacy/controller/legacy.php:7097 JControllerLegacy->execute() Copy JROOT/components/com_easyblog/easyblog.php:436 require_once Copy JROOT/components/com_easyblog/easyblog.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2731 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:1.13 ms 最後のクエリの後:0.42 ms クエリメモリ:0.023 MB クエリ前のメモリ:18.155 MB 返された行:1
select a.* from `joom_easyblog_revisions ` as a where a.`id` IN ( 14) クエリではEXPLAINは使用できません:select a.* from `joom_easyblog_revisions` as a where a.`id` IN ( 14)
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.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.04 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 15 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172614 JDatabaseDriver->loadObjectList() Copy JROOT/administrator/components/com_easyblog/includes/utils.php:23513 EasyBlogDbJoomla->__call() Copy JROOT/administrator/components/com_easyblog/models/revisions.php:55812 EasyBlogModelRevisions->preload() Copy JROOT/administrator/components/com_easyblog/includes/cache/cache.php:57611 EasyBlogCache->cacheRevisions() Copy JROOT/administrator/components/com_easyblog/includes/cache/cache.php:27910 EasyBlogCache->insert() Copy JROOT/components/com_easyblog/views/entry/view.html.php:439 EasyBlogViewEntry->display() Copy JROOT/components/com_easyblog/controllers/controller.php:1088 EasyBlogController->display() Copy JROOT/libraries/legacy/controller/legacy.php:7097 JControllerLegacy->execute() Copy JROOT/components/com_easyblog/easyblog.php:436 require_once Copy JROOT/components/com_easyblog/easyblog.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2731 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:1.19 ms 最後のクエリの後:0.29 ms クエリメモリ:0.025 MB クエリ前のメモリ:18.204 MB 返された行:1
select u.* , e.`id` as `eb_id`, e.`nickname`, e.`avatar`, e.`description`, e.`url`, e.`params` as `eb_params`, e.`published` as `eb_published`, e.`title` as `eb_title`, e.`biography`, e.`permalink`, e.`custom_css` from `joom_users ` as u left join `joom_easyblog_users ` as e ON u.`id` = e.`id` where u.`id` = 1621309 クエリではEXPLAINは使用できません:select u.*, e.`id` as `eb_id`, e.`nickname`, e.`avatar`, e.`description`, e.`url`, e.`params` as `eb_params`, e.`published` as `eb_published`, e.`title` as `eb_title`, e.`biography`, e.`permalink`, e.`custom_css` from `joom_users` as u left join `joom_easyblog_users` as e ON u.`id` = e.`id` where u.`id` = 1621309
Status Duration starting 0.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.06 ms preparing 0.01 ms executing 0.02 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.00 ms
# 発信者 ファイルと行番号 18 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172617 JDatabaseDriver->loadObjectList() Copy JROOT/administrator/components/com_easyblog/includes/utils.php:23516 EasyBlogDbJoomla->__call() Copy JROOT/administrator/components/com_easyblog/models/users.php:30015 EasyBlogModelUsers->getUsersMeta() Copy JROOT/administrator/components/com_easyblog/includes/user/user.php:19314 EasyBlogUser::loadUsers() Copy JROOT/administrator/components/com_easyblog/includes/user/user.php:8513 EasyBlogUser::factory() Copy JROOT/administrator/components/com_easyblog/includes/easyblog.php:89512 EB::user() Copy JROOT/administrator/components/com_easyblog/includes/cache/cache.php:64811 EasyBlogCache->cacheAuthors() Copy JROOT/administrator/components/com_easyblog/includes/cache/cache.php:28210 EasyBlogCache->insert() Copy JROOT/components/com_easyblog/views/entry/view.html.php:439 EasyBlogViewEntry->display() Copy JROOT/components/com_easyblog/controllers/controller.php:1088 EasyBlogController->display() Copy JROOT/libraries/legacy/controller/legacy.php:7097 JControllerLegacy->execute() Copy JROOT/components/com_easyblog/easyblog.php:436 require_once Copy JROOT/components/com_easyblog/easyblog.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2731 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:1.17 ms 最後のクエリの後:0.53 ms クエリメモリ:0.026 MB クエリ前のメモリ:18.897 MB 返された行:1
SELECT *
FROM `joom_users `
WHERE `id` = 1621309クエリではEXPLAINは使用できません:SELECT *
FROM `joom_users`
WHERE `id` = 1621309
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.04 ms preparing 0.01 ms executing 0.01 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.00 ms
# 発信者 ファイルと行番号 21 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:149020 JDatabaseDriver->loadAssoc() Copy JROOT/libraries/joomla/table/user.php:8519 JTableUser->load() Copy JROOT/libraries/joomla/user/user.php:93618 JUser->load() Copy JROOT/libraries/joomla/user/user.php:24317 JUser->__construct() Copy JROOT/libraries/joomla/user/user.php:29616 JUser::getInstance() Copy JROOT/libraries/joomla/factory.php:26315 JFactory::getUser() Copy JROOT/administrator/components/com_easyblog/includes/user/user.php:23814 EasyBlogUser::loadUsers() Copy JROOT/administrator/components/com_easyblog/includes/user/user.php:8513 EasyBlogUser::factory() Copy JROOT/administrator/components/com_easyblog/includes/easyblog.php:89512 EB::user() Copy JROOT/administrator/components/com_easyblog/includes/cache/cache.php:64811 EasyBlogCache->cacheAuthors() Copy JROOT/administrator/components/com_easyblog/includes/cache/cache.php:28210 EasyBlogCache->insert() Copy JROOT/components/com_easyblog/views/entry/view.html.php:439 EasyBlogViewEntry->display() Copy JROOT/components/com_easyblog/controllers/controller.php:1088 EasyBlogController->display() Copy JROOT/libraries/legacy/controller/legacy.php:7097 JControllerLegacy->execute() Copy JROOT/components/com_easyblog/easyblog.php:436 require_once Copy JROOT/components/com_easyblog/easyblog.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2731 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:1.27 ms 最後のクエリの後:1.89 ms クエリメモリ:0.025 MB クエリ前のメモリ:19.650 MB 返された行:2
SELECT `g`.`id`,`g`.`title`
FROM `joom_usergroups ` AS g
INNER JOIN `joom_user_usergroup_map ` AS m ON m.group_id = g.id
WHERE `m`.`user_id` = 1621309クエリではEXPLAINは使用できません:SELECT `g`.`id`,`g`.`title`
FROM `joom_usergroups` AS g
INNER JOIN `joom_user_usergroup_map` AS m ON m.group_id = g.id
WHERE `m`.`user_id` = 1621309
Status Duration starting 0.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.07 ms preparing 0.02 ms executing 0.03 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms
# 発信者 ファイルと行番号 21 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:153120 JDatabaseDriver->loadAssocList() Copy JROOT/libraries/joomla/table/user.php:11019 JTableUser->load() Copy JROOT/libraries/joomla/user/user.php:93618 JUser->load() Copy JROOT/libraries/joomla/user/user.php:24317 JUser->__construct() Copy JROOT/libraries/joomla/user/user.php:29616 JUser::getInstance() Copy JROOT/libraries/joomla/factory.php:26315 JFactory::getUser() Copy JROOT/administrator/components/com_easyblog/includes/user/user.php:23814 EasyBlogUser::loadUsers() Copy JROOT/administrator/components/com_easyblog/includes/user/user.php:8513 EasyBlogUser::factory() Copy JROOT/administrator/components/com_easyblog/includes/easyblog.php:89512 EB::user() Copy JROOT/administrator/components/com_easyblog/includes/cache/cache.php:64811 EasyBlogCache->cacheAuthors() Copy JROOT/administrator/components/com_easyblog/includes/cache/cache.php:28210 EasyBlogCache->insert() Copy JROOT/components/com_easyblog/views/entry/view.html.php:439 EasyBlogViewEntry->display() Copy JROOT/components/com_easyblog/controllers/controller.php:1088 EasyBlogController->display() Copy JROOT/libraries/legacy/controller/legacy.php:7097 JControllerLegacy->execute() Copy JROOT/components/com_easyblog/easyblog.php:436 require_once Copy JROOT/components/com_easyblog/easyblog.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2731 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:1.33 ms 最後のクエリの後:0.44 ms クエリメモリ:0.023 MB クエリ前のメモリ:19.710 MB 返された行:0
select `a`.`id` as `cat_fg_id`, `a`.`category_id` as `cat_fg_category_id`, `a`.`group_id` as `cat_fg_group_id`, `fg`.`id` as `fg_id`, `fg`.`title` as `fg_title`, `fg`.`description` as `fg_description`, `fg`.`created` as `fg_created`, `fg`.`state` as `fg_state`, `fg`.`read` as `fg_read`, `fg`.`write` as `fg_write`, `fg`.`params` as `fg_params`, `f`.`id` as `f_id`, `f`.`group_id` as `f_group_id`, `f`.`title` as `f_title`, `f`.`help` as `f_help`, `f`.`state` as `f_state`, `f`.`required` as `f_required`, `f`.`type` as `f_type`, `f`.`params` as `f_params`, `f`.`created` as `f_created`, `f`.`options` as `f_options`, `fv`.`id` as `fv_id`, `fv`.`field_id` as `fv_field_id`, `fv`.`post_id` as `fv_post_id`, `fv`.`value` as `fv_value` from `joom_easyblog_category_fields_groups ` as a inner join `joom_easyblog_post_category ` as p on `a`.`category_id` = `p`.`category_id` inner join `joom_easyblog_fields_groups ` as fg on `a`.`group_id` = `fg`.`id` inner join `joom_easyblog_fields ` as f on `fg`.`id` = `f`.`group_id` left join `joom_easyblog_fields_values ` as fv on `fv`.`field_id` = `f`.`id` and `fv`.`post_id` = `p`.`post_id` where `p`.`post_id` = '3' クエリではEXPLAINは使用できません:select `a`.`id` as `cat_fg_id`, `a`.`category_id` as `cat_fg_category_id`, `a`.`group_id` as `cat_fg_group_id`, `fg`.`id` as `fg_id`, `fg`.`title` as `fg_title`, `fg`.`description` as `fg_description`, `fg`.`created` as `fg_created`, `fg`.`state` as `fg_state`, `fg`.`read` as `fg_read`, `fg`.`write` as `fg_write`, `fg`.`params` as `fg_params`, `f`.`id` as `f_id`, `f`.`group_id` as `f_group_id`, `f`.`title` as `f_title`, `f`.`help` as `f_help`, `f`.`state` as `f_state`, `f`.`required` as `f_required`, `f`.`type` as `f_type`, `f`.`params` as `f_params`, `f`.`created` as `f_created`, `f`.`options` as `f_options`, `fv`.`id` as `fv_id`, `fv`.`field_id` as `fv_field_id`, `fv`.`post_id` as `fv_post_id`, `fv`.`value` as `fv_value` from `joom_easyblog_category_fields_groups` as a inner join `joom_easyblog_post_category` as p on `a`.`category_id` = `p`.`category_id` inner join `joom_easyblog_fields_groups` as fg on `a`.`group_id` = `fg`.`id` inner join `joom_easyblog_fields` as f on `fg`.`id` = `f`.`group_id` left join `joom_easyblog_fields_values` as fv on `fv`.`field_id` = `f`.`id` and `fv`.`post_id` = `p`.`post_id` where `p`.`post_id` = '3'
Status Duration starting 0.09 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.06 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.08 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
# 発信者 ファイルと行番号 15 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172614 JDatabaseDriver->loadObjectList() Copy JROOT/administrator/components/com_easyblog/includes/utils.php:23513 EasyBlogDbJoomla->__call() Copy JROOT/administrator/components/com_easyblog/models/fields.php:29812 EasyBlogModelFields->preloadFields() Copy JROOT/administrator/components/com_easyblog/includes/cache/cache.php:37411 EasyBlogCache->cacheFields() Copy JROOT/administrator/components/com_easyblog/includes/cache/cache.php:28510 EasyBlogCache->insert() Copy JROOT/components/com_easyblog/views/entry/view.html.php:439 EasyBlogViewEntry->display() Copy JROOT/components/com_easyblog/controllers/controller.php:1088 EasyBlogController->display() Copy JROOT/libraries/legacy/controller/legacy.php:7097 JControllerLegacy->execute() Copy JROOT/components/com_easyblog/easyblog.php:436 require_once Copy JROOT/components/com_easyblog/easyblog.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2731 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:1.15 ms 最後のクエリの後:0.32 ms クエリメモリ:0.023 MB クエリ前のメモリ:19.763 MB 返された行:1
select * from `joom_easyblog_meta ` where `content_id` in (3) and `type` = 'post' クエリではEXPLAINは使用できません:select * from `joom_easyblog_meta` where `content_id` in (3) and `type` = 'post'
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.04 ms preparing 0.01 ms executing 0.03 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms
# 発信者 ファイルと行番号 15 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172614 JDatabaseDriver->loadObjectList() Copy JROOT/administrator/components/com_easyblog/includes/utils.php:23513 EasyBlogDbJoomla->__call() Copy JROOT/administrator/components/com_easyblog/models/metas.php:38612 EasyBlogModelMetas->preloadPostMetas() Copy JROOT/administrator/components/com_easyblog/includes/cache/cache.php:30311 EasyBlogCache->cacheMetas() Copy JROOT/administrator/components/com_easyblog/includes/cache/cache.php:28810 EasyBlogCache->insert() Copy JROOT/components/com_easyblog/views/entry/view.html.php:439 EasyBlogViewEntry->display() Copy JROOT/components/com_easyblog/controllers/controller.php:1088 EasyBlogController->display() Copy JROOT/libraries/legacy/controller/legacy.php:7097 JControllerLegacy->execute() Copy JROOT/components/com_easyblog/easyblog.php:436 require_once Copy JROOT/components/com_easyblog/easyblog.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2731 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:1.15 ms 最後のクエリの後:0.07 ms クエリメモリ:0.022 MB クエリ前のメモリ:19.776 MB 返された行:1
SELECT *
FROM joom_easyblog_meta
WHERE `type` = 'post' AND `content_id` = '3'クエリではEXPLAINは使用できません:SELECT *
FROM joom_easyblog_meta
WHERE `type` = 'post' AND `content_id` = '3'
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.02 ms statistics 0.05 ms preparing 0.02 ms executing 0.03 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms
# 発信者 ファイルと行番号 14 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:149013 JDatabaseDriver->loadAssoc() Copy JROOT/libraries/joomla/table/table.php:72912 JTable->load() Copy JROOT/administrator/components/com_easyblog/includes/easyblog.php:225811 EB::setMeta() Copy JROOT/administrator/components/com_easyblog/includes/post/post.php:567610 EasyBlogPost->renderHeaders() Copy JROOT/components/com_easyblog/views/entry/view.html.php:469 EasyBlogViewEntry->display() Copy JROOT/components/com_easyblog/controllers/controller.php:1088 EasyBlogController->display() Copy JROOT/libraries/legacy/controller/legacy.php:7097 JControllerLegacy->execute() Copy JROOT/components/com_easyblog/easyblog.php:436 require_once Copy JROOT/components/com_easyblog/easyblog.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2731 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:1.72 ms 最後のクエリの後:6.24 ms クエリメモリ:0.026 MB クエリ前のメモリ:20.540 MB 返された行:0
SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state
FROM joom_fields AS a
LEFT JOIN `joom_languages ` AS l ON l.lang_code = a.language
LEFT JOIN joom_users AS uc ON uc.id= a.checked_out
LEFT JOIN joom_viewlevels AS ag ON ag.id = a.access
LEFT JOIN joom_users AS ua ON ua.id = a.created_user_id
LEFT JOIN joom_fields_groups AS g ON g.id = a.group_id
LEFT JOIN `joom_fields_categories ` AS fc ON fc.field_id = a.id
WHERE a.context = 'easyblog.blog' AND (fc.category_id IS NULL OR fc.category_id IN (1,0)) AND a.access IN (1,1) AND (a.group_id = 0 OR g.access IN (1,1)) AND a.state = 1 AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering ASC クエリではEXPLAINは使用できません:SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state
FROM joom_fields AS a
LEFT JOIN `joom_languages` AS l ON l.lang_code = a.language
LEFT JOIN joom_users AS uc ON uc.id=a.checked_out
LEFT JOIN joom_viewlevels AS ag ON ag.id = a.access
LEFT JOIN joom_users AS ua ON ua.id = a.created_user_id
LEFT JOIN joom_fields_groups AS g ON g.id = a.group_id
LEFT JOIN `joom_fields_categories` AS fc ON fc.field_id = a.id
WHERE a.context = 'easyblog.blog' AND (fc.category_id IS NULL OR fc.category_id IN (1,0)) AND a.access IN (1,1) AND (a.group_id = 0 OR g.access IN (1,1)) AND a.state = 1 AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering ASC
Status Duration starting 0.15 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 checking permissions 0.03 ms Opening tables 0.11 ms init 0.01 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.13 ms preparing 0.07 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.02 ms
# 発信者 ファイルと行番号 23 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172622 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/legacy/model/legacy.php:30721 JModelLegacy->_getList() Copy JROOT/administrator/components/com_fields/models/fields.php:32620 FieldsModelFields->_getList() Copy JROOT/libraries/legacy/model/list.php:18919 JModelList->getItems() Copy JROOT/administrator/components/com_fields/helpers/fields.php:13418 FieldsHelper::getFields() Copy JROOT/plugins/system/fields/fields.php:37817 PlgSystemFields->onContentPrepare() Copy JROOT/libraries/joomla/event/event.php:7016 JEvent->update() Copy JROOT/libraries/joomla/event/dispatcher.php:16015 JEventDispatcher->trigger() Copy JROOT/administrator/components/com_easyblog/includes/triggers/triggers.php:4314 EasyBlogTriggers->trigger() Copy JROOT/administrator/components/com_easyblog/includes/post/post.php:397413 EasyBlogPost->prepareContent() Copy JROOT/administrator/components/com_easyblog/includes/post/post.php:365912 EasyBlogPost->getIntro() Copy JROOT/administrator/components/com_easyblog/includes/easyblog.php:231811 EB::setMeta() Copy JROOT/administrator/components/com_easyblog/includes/post/post.php:567610 EasyBlogPost->renderHeaders() Copy JROOT/components/com_easyblog/views/entry/view.html.php:469 EasyBlogViewEntry->display() Copy JROOT/components/com_easyblog/controllers/controller.php:1088 EasyBlogController->display() Copy JROOT/libraries/legacy/controller/legacy.php:7097 JControllerLegacy->execute() Copy JROOT/components/com_easyblog/easyblog.php:436 require_once Copy JROOT/components/com_easyblog/easyblog.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2731 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:4.02 ms 最後のクエリの後:3.32 ms クエリメモリ:0.006 MB クエリ前のメモリ:20.988 MB
UPDATE joom_easyblog_post
SET `hits` = (`hits` + 1)
WHERE `id` = '3'クエリではEXPLAINは使用できません:UPDATE joom_easyblog_post
SET `hits` = (`hits` + 1)
WHERE `id` = '3'
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.09 ms updating 0.17 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.10 ms closing tables 0.03 ms freeing items 0.02 ms async commit 2.54 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 12 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/table/table.php:127911 JTable->hit() Copy JROOT/administrator/components/com_easyblog/includes/post/post.php:108210 EasyBlogPost->hit() Copy JROOT/components/com_easyblog/views/entry/view.html.php:639 EasyBlogViewEntry->display() Copy JROOT/components/com_easyblog/controllers/controller.php:1088 EasyBlogController->display() Copy JROOT/libraries/legacy/controller/legacy.php:7097 JControllerLegacy->execute() Copy JROOT/components/com_easyblog/easyblog.php:436 require_once Copy JROOT/components/com_easyblog/easyblog.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2731 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:2.96 ms 最後のクエリの後:2.89 ms クエリメモリ:0.024 MB クエリ前のメモリ:21.286 MB 返された行:1
SELECT COUNT (1) FROM `joom_easyblog_featured ` WHERE `content_id`= '3' AND `type`= 'post'クエリではEXPLAINは使用できません:SELECT COUNT(1) FROM `joom_easyblog_featured` WHERE `content_id`='3' AND `type`='post'
Status Duration starting 0.06 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.04 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.07 ms preparing 0.03 ms executing 0.02 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms
# 発信者 ファイルと行番号 17 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:176516 JDatabaseDriver->loadResult() Copy JROOT/administrator/components/com_easyblog/includes/utils.php:23515 EasyBlogDbJoomla->__call() Copy JROOT/administrator/components/com_easyblog/models/blog.php:6314 EasyBlogModelBlog->isFeatured() Copy JROOT/administrator/components/com_easyblog/includes/post/post.php:458913 EasyBlogPost->isFeatured() Copy JROOT/administrator/components/com_easyblog/includes/formatter/types/entry.php:2412 EasyBlogFormatterEntry->execute() Copy JROOT/administrator/components/com_easyblog/includes/formatter/formatter.php:5111 EasyBlogFormatter->execute() Copy JROOT/administrator/components/com_easyblog/includes/easyblog.php:430810 EB::formatter() Copy JROOT/components/com_easyblog/views/entry/view.html.php:669 EasyBlogViewEntry->display() Copy JROOT/components/com_easyblog/controllers/controller.php:1088 EasyBlogController->display() Copy JROOT/libraries/legacy/controller/legacy.php:7097 JControllerLegacy->execute() Copy JROOT/components/com_easyblog/easyblog.php:436 require_once Copy JROOT/components/com_easyblog/easyblog.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2731 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:1.19 ms 最後のクエリの後:0.36 ms クエリメモリ:0.024 MB クエリ前のメモリ:21.316 MB 返された行:1
SELECT COUNT (1) FROM `joom_easyblog_comment ` WHERE `post_id`= '3' AND `published`= '1'クエリではEXPLAINは使用できません:SELECT COUNT(1) FROM `joom_easyblog_comment` WHERE `post_id`='3' AND `published`='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.02 ms statistics 0.06 ms preparing 0.03 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
# 発信者 ファイルと行番号 18 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:176517 JDatabaseDriver->loadResult() Copy JROOT/administrator/components/com_easyblog/includes/utils.php:23516 EasyBlogDbJoomla->__call() Copy JROOT/administrator/components/com_easyblog/models/comment.php:54915 EasyBlogModelComment->getCount() Copy JROOT/administrator/components/com_easyblog/includes/comment/adapters/easyblog.php:16214 EasyBlogCommentEasyBlog->getCount() Copy JROOT/administrator/components/com_easyblog/includes/comment/comment.php:24913 EasyBlogComment->getCommentCount() Copy JROOT/administrator/components/com_easyblog/includes/formatter/types/entry.php:3712 EasyBlogFormatterEntry->execute() Copy JROOT/administrator/components/com_easyblog/includes/formatter/formatter.php:5111 EasyBlogFormatter->execute() Copy JROOT/administrator/components/com_easyblog/includes/easyblog.php:430810 EB::formatter() Copy JROOT/components/com_easyblog/views/entry/view.html.php:669 EasyBlogViewEntry->display() Copy JROOT/components/com_easyblog/controllers/controller.php:1088 EasyBlogController->display() Copy JROOT/libraries/legacy/controller/legacy.php:7097 JControllerLegacy->execute() Copy JROOT/components/com_easyblog/easyblog.php:436 require_once Copy JROOT/components/com_easyblog/easyblog.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2731 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:1.22 ms 最後のクエリの後:1.23 ms クエリメモリ:0.024 MB クエリ前のメモリ:21.449 MB 返された行:0
SELECT `group_id` FROM `joom_easyblog_category_fields_groups ` WHERE `category_id`= '1'クエリではEXPLAINは使用できません:SELECT `group_id` FROM `joom_easyblog_category_fields_groups` WHERE `category_id`='1'
Status Duration starting 0.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.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.03 ms freeing items 0.03 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 18 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:176517 JDatabaseDriver->loadResult() Copy JROOT/administrator/components/com_easyblog/includes/utils.php:23516 EasyBlogDbJoomla->__call() Copy JROOT/administrator/components/com_easyblog/models/categories.php:5315 EasyBlogModelCategories->getCustomFieldGroup() Copy JROOT/administrator/components/com_easyblog/tables/category.php:101314 EasyBlogTableCategory->getCustomFields() Copy JROOT/administrator/components/com_easyblog/includes/post/post.php:525013 EasyBlogPost->getCustomFields() Copy JROOT/administrator/components/com_easyblog/includes/formatter/types/entry.php:4012 EasyBlogFormatterEntry->execute() Copy JROOT/administrator/components/com_easyblog/includes/formatter/formatter.php:5111 EasyBlogFormatter->execute() Copy JROOT/administrator/components/com_easyblog/includes/easyblog.php:430810 EB::formatter() Copy JROOT/components/com_easyblog/views/entry/view.html.php:669 EasyBlogViewEntry->display() Copy JROOT/components/com_easyblog/controllers/controller.php:1088 EasyBlogController->display() Copy JROOT/libraries/legacy/controller/legacy.php:7097 JControllerLegacy->execute() Copy JROOT/components/com_easyblog/easyblog.php:436 require_once Copy JROOT/components/com_easyblog/easyblog.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2731 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:1.20 ms 最後のクエリの後:0.27 ms クエリメモリ:0.024 MB クエリ前のメモリ:21.472 MB 返された行:0
SELECT a.* FROM `joom_easyblog_fields ` AS a INNER JOIN `joom_easyblog_category_fields_groups ` AS b ON a.`group_id`= b.`group_id` WHERE b.`category_id`= '1' AND a.`state`= '1'クエリではEXPLAINは使用できません:SELECT a.* FROM `joom_easyblog_fields` AS a INNER JOIN `joom_easyblog_category_fields_groups` AS b ON a.`group_id`= b.`group_id` WHERE b.`category_id`='1' AND a.`state`='1'
Status Duration starting 0.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.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.00 ms
# 発信者 ファイルと行番号 18 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172617 JDatabaseDriver->loadObjectList() Copy JROOT/administrator/components/com_easyblog/includes/utils.php:23516 EasyBlogDbJoomla->__call() Copy JROOT/administrator/components/com_easyblog/models/categories.php:8115 EasyBlogModelCategories->getCustomFields() Copy JROOT/administrator/components/com_easyblog/tables/category.php:101414 EasyBlogTableCategory->getCustomFields() Copy JROOT/administrator/components/com_easyblog/includes/post/post.php:525013 EasyBlogPost->getCustomFields() Copy JROOT/administrator/components/com_easyblog/includes/formatter/types/entry.php:4012 EasyBlogFormatterEntry->execute() Copy JROOT/administrator/components/com_easyblog/includes/formatter/formatter.php:5111 EasyBlogFormatter->execute() Copy JROOT/administrator/components/com_easyblog/includes/easyblog.php:430810 EB::formatter() Copy JROOT/components/com_easyblog/views/entry/view.html.php:669 EasyBlogViewEntry->display() Copy JROOT/components/com_easyblog/controllers/controller.php:1088 EasyBlogController->display() Copy JROOT/libraries/legacy/controller/legacy.php:7097 JControllerLegacy->execute() Copy JROOT/components/com_easyblog/easyblog.php:436 require_once Copy JROOT/components/com_easyblog/easyblog.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2731 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:1.13 ms 最後のクエリの後:0.18 ms クエリメモリ:0.024 MB クエリ前のメモリ:21.494 MB 返された行:0
SELECT `key`,`value` FROM `joom_easyblog_post_assets ` WHERE `post_id`= '3'クエリではEXPLAINは使用できません:SELECT `key`,`value` FROM `joom_easyblog_post_assets` WHERE `post_id`='3'
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.03 ms preparing 0.01 ms executing 0.02 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.00 ms
# 発信者 ファイルと行番号 17 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172616 JDatabaseDriver->loadObjectList() Copy JROOT/administrator/components/com_easyblog/includes/utils.php:23515 EasyBlogDbJoomla->__call() Copy JROOT/administrator/components/com_easyblog/models/assets.php:7214 EasyBlogModelAssets->getPostAssets() Copy JROOT/administrator/components/com_easyblog/includes/post/post.php:325313 EasyBlogPost->getAssets() Copy JROOT/administrator/components/com_easyblog/includes/formatter/types/entry.php:4712 EasyBlogFormatterEntry->execute() Copy JROOT/administrator/components/com_easyblog/includes/formatter/formatter.php:5111 EasyBlogFormatter->execute() Copy JROOT/administrator/components/com_easyblog/includes/easyblog.php:430810 EB::formatter() Copy JROOT/components/com_easyblog/views/entry/view.html.php:669 EasyBlogViewEntry->display() Copy JROOT/components/com_easyblog/controllers/controller.php:1088 EasyBlogController->display() Copy JROOT/libraries/legacy/controller/legacy.php:7097 JControllerLegacy->execute() Copy JROOT/components/com_easyblog/easyblog.php:436 require_once Copy JROOT/components/com_easyblog/easyblog.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2731 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:2.05 ms 最後のクエリの後:1.26 ms クエリメモリ:0.024 MB クエリ前のメモリ:21.645 MB 返された行:2
SELECT SQL_CALC_FOUND_ROWS a.`id` AS key1, a.* , ifnull(f.`id`, 0) as `featured` FROM `joom_easyblog_post ` AS a LEFT JOIN `joom_easyblog_featured ` AS f ON a.`id` = f.`content_id` AND f.`type` = 'post' WHERE a.`published`= '1' AND a.`state`= '0' AND a.`access` = '0' AND a.`created_by` = '1621309' AND (`a`.`language`= 'ja-JA ' OR `a`.`language`= '' OR `a`.`language`= '* ') AND (1 <= (select count(1) from `joom_easyblog_post_category ` AS acp INNER JOIN `joom_easyblog_category ` as cat on acp.`category_id` = cat.`id` where acp.`post_id` = a.`id` and ( ( cat.`private` = 0 ) OR ( (cat.`private` = 1) and (0 > 0) ) OR ( (cat.`private` = 2) and ( (select count(1) from `joom_easyblog_category_acl ` as cacl where cacl.`category_id` = cat.id and cacl.`acl_id` = 1 and cacl.`content_id` in (1)) > 0 ) ) ) )) AND ( (a.`source_type` = 'easyblog.sitewide') OR ( a.`source_type` = 'easyblog.team' and 1 <= (select count(1) from `joom_easyblog_team ` as srcteam where srcteam.`id` = a.`source_id` and srcteam.`published` = 1 and ( (srcteam.`access` = 3) OR (srcteam.`access` = 2 and (select count(1) from `joom_easyblog_team_groups ` as srcteamgrp where srcteamgrp.`team_id` = srcteam.`id` and srcteamgrp.`group_id` IN (1) ) > 0) OR (srcteam.`access` = 1 and (select count(1) from `joom_easyblog_team_groups ` as srcteamgrp where srcteamgrp.`team_id` = srcteam.`id` and srcteamgrp.`group_id` IN (1) ) > 0))))) ORDER BY a.`created` desc LIMIT 3クエリではEXPLAINは使用できません:SELECT SQL_CALC_FOUND_ROWS a.`id` AS key1, a.*, ifnull(f.`id`, 0) as `featured` FROM `joom_easyblog_post` AS a LEFT JOIN `joom_easyblog_featured` AS f ON a.`id` = f.`content_id` AND f.`type` = 'post' WHERE a.`published`='1' AND a.`state`='0' AND a.`access` = '0' AND a.`created_by` = '1621309' AND (`a`.`language`='ja-JA' OR `a`.`language`='' OR `a`.`language`='*') AND (1 <= (select count(1) from `joom_easyblog_post_category` AS acp INNER JOIN `joom_easyblog_category` as cat on acp.`category_id` = cat.`id` where acp.`post_id` = a.`id` and ( ( cat.`private` = 0 ) OR ( (cat.`private` = 1) and (0 > 0) ) OR ( (cat.`private` = 2) and ( (select count(1) from `joom_easyblog_category_acl` as cacl where cacl.`category_id` = cat.id and cacl.`acl_id` = 1 and cacl.`content_id` in (1)) > 0 ) ) ) )) AND ( (a.`source_type` = 'easyblog.sitewide') OR ( a.`source_type` = 'easyblog.team' and 1 <= (select count(1) from `joom_easyblog_team` as srcteam where srcteam.`id` = a.`source_id` and srcteam.`published` = 1 and ( (srcteam.`access` = 3) OR (srcteam.`access` = 2 and (select count(1) from `joom_easyblog_team_groups` as srcteamgrp where srcteamgrp.`team_id` = srcteam.`id` and srcteamgrp.`group_id` IN (1) ) > 0) OR (srcteam.`access` = 1 and (select count(1) from `joom_easyblog_team_groups` as srcteamgrp where srcteamgrp.`team_id` = srcteam.`id` and srcteamgrp.`group_id` IN (1) ) > 0))))) ORDER BY a.`created` desc LIMIT 3
Status Duration starting 0.17 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 checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.13 ms init 0.01 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.14 ms preparing 0.04 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.01 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.03 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.01 ms executing 0.06 ms executing 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.02 ms freeing items 0.05 ms cleaning up 0.02 ms
# 発信者 ファイルと行番号 14 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172613 JDatabaseDriver->loadObjectList() Copy JROOT/administrator/components/com_easyblog/includes/utils.php:23512 EasyBlogDbJoomla->__call() Copy JROOT/administrator/components/com_easyblog/models/blog.php:77611 EasyBlogModelBlog->getBlogsBy() Copy JROOT/components/com_easyblog/views/entry/view.html.php:48910 EasyBlogViewEntry->getRecentPosts() Copy JROOT/components/com_easyblog/views/entry/view.html.php:829 EasyBlogViewEntry->display() Copy JROOT/components/com_easyblog/controllers/controller.php:1088 EasyBlogController->display() Copy JROOT/libraries/legacy/controller/legacy.php:7097 JControllerLegacy->execute() Copy JROOT/components/com_easyblog/easyblog.php:436 require_once Copy JROOT/components/com_easyblog/easyblog.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2731 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:2.25 ms 最後のクエリの後:0.22 ms クエリメモリ:0.028 MB クエリ前のメモリ:21.666 MB 返された行:0
SELECT `id` FROM `joom_menu ` WHERE ( `link` LIKE 'index.php?option= com_easyblog&view= entry&id= 3%' OR `link` LIKE 'index.php?option= com_easyblog&view= entry&id= 3%' ) AND `published`= '1' AND (`language`= 'ja-JA ' OR `language`= '' OR `language`= '* ') LIMIT 1クエリではEXPLAINは使用できません:SELECT `id` FROM `joom_menu` WHERE ( `link` LIKE 'index.php?option=com_easyblog&view=entry&id=3%' OR `link` LIKE 'index.php?option=com_easyblog&view=entry&id=3%' ) AND `published`='1' AND (`language`='ja-JA' OR `language`='' OR `language`='*') LIMIT 1
Status Duration starting 0.06 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.06 ms preparing 0.02 ms executing 0.98 ms end 0.04 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:176514 JDatabaseDriver->loadResult() Copy JROOT/administrator/components/com_easyblog/includes/utils.php:23513 EasyBlogDbJoomla->__call() Copy JROOT/administrator/components/com_easyblog/models/menu.php:23912 EasyBlogModelMenu->getMenusByPostId() Copy JROOT/administrator/components/com_easyblog/includes/post/post.php:501911 EasyBlogPost->getMenuParams() Copy JROOT/components/com_easyblog/views/entry/view.html.php:51810 EasyBlogViewEntry->prepareNavigation() Copy JROOT/components/com_easyblog/views/entry/view.html.php:909 EasyBlogViewEntry->display() Copy JROOT/components/com_easyblog/controllers/controller.php:1088 EasyBlogController->display() Copy JROOT/libraries/legacy/controller/legacy.php:7097 JControllerLegacy->execute() Copy JROOT/components/com_easyblog/easyblog.php:436 require_once Copy JROOT/components/com_easyblog/easyblog.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2731 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:12.33 ms 最後のクエリの後:0.95 ms クエリメモリ:0.022 MB クエリ前のメモリ:21.759 MB 返された行:1
SELECT a.`id`, a.`title` FROM `joom_easyblog_post ` AS `a` WHERE a.`published` = '1' AND a.`state` = '0' AND a.`access`= '0' AND a.`source_type`= 'easyblog.sitewide' AND (`a`.`language`= 'ja-JA ' OR `a`.`language`= '' OR `a`.`language`= '* ') AND a.`created` < '2022-06-29 04:20:48' ORDER BY a.`created` DESC LIMIT 1クエリではEXPLAINは使用できません:SELECT a.`id`, a.`title` FROM `joom_easyblog_post` AS `a` WHERE a.`published` = '1' AND a.`state` = '0' AND a.`access`='0' AND a.`source_type`='easyblog.sitewide' AND (`a`.`language`='ja-JA' OR `a`.`language`='' OR `a`.`language`='*') AND a.`created` < '2022-06-29 04:20:48' ORDER BY a.`created` DESC LIMIT 1
Status Duration starting 0.09 ms Executing hook on transaction 7.63 ms starting 0.02 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.10 ms preparing 0.04 ms executing 0.04 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 14 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:168713 JDatabaseDriver->loadObject() Copy JROOT/administrator/components/com_easyblog/includes/utils.php:23512 EasyBlogDbJoomla->__call() Copy JROOT/administrator/components/com_easyblog/models/blog.php:142411 EasyBlogModelBlog->getPostNavigation() Copy JROOT/components/com_easyblog/views/entry/view.html.php:52310 EasyBlogViewEntry->prepareNavigation() Copy JROOT/components/com_easyblog/views/entry/view.html.php:909 EasyBlogViewEntry->display() Copy JROOT/components/com_easyblog/controllers/controller.php:1088 EasyBlogController->display() Copy JROOT/libraries/legacy/controller/legacy.php:7097 JControllerLegacy->execute() Copy JROOT/components/com_easyblog/easyblog.php:436 require_once Copy JROOT/components/com_easyblog/easyblog.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2731 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:3.63 ms 最後のクエリの後:0.17 ms クエリメモリ:0.022 MB クエリ前のメモリ:21.766 MB 返された行:0
SELECT a.`id`, a.`title` FROM `joom_easyblog_post ` AS `a` WHERE a.`published` = '1' AND a.`state` = '0' AND a.`access`= '0' AND a.`source_type`= 'easyblog.sitewide' AND (`a`.`language`= 'ja-JA ' OR `a`.`language`= '' OR `a`.`language`= '* ') AND a.`created` > '2022-06-29 04:20:48' ORDER BY a.`created` ASC LIMIT 1クエリではEXPLAINは使用できません:SELECT a.`id`, a.`title` FROM `joom_easyblog_post` AS `a` WHERE a.`published` = '1' AND a.`state` = '0' AND a.`access`='0' AND a.`source_type`='easyblog.sitewide' AND (`a`.`language`='ja-JA' OR `a`.`language`='' OR `a`.`language`='*') AND a.`created` > '2022-06-29 04:20:48' ORDER BY a.`created` ASC LIMIT 1
Status Duration starting 0.11 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.06 ms init 0.01 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.11 ms preparing 0.05 ms executing 0.03 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 14 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:168713 JDatabaseDriver->loadObject() Copy JROOT/administrator/components/com_easyblog/includes/utils.php:23512 EasyBlogDbJoomla->__call() Copy JROOT/administrator/components/com_easyblog/models/blog.php:142411 EasyBlogModelBlog->getPostNavigation() Copy JROOT/components/com_easyblog/views/entry/view.html.php:52310 EasyBlogViewEntry->prepareNavigation() Copy JROOT/components/com_easyblog/views/entry/view.html.php:909 EasyBlogViewEntry->display() Copy JROOT/components/com_easyblog/controllers/controller.php:1088 EasyBlogController->display() Copy JROOT/libraries/legacy/controller/legacy.php:7097 JControllerLegacy->execute() Copy JROOT/components/com_easyblog/easyblog.php:436 require_once Copy JROOT/components/com_easyblog/easyblog.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2731 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:1.29 ms 最後のクエリの後:0.15 ms クエリメモリ:0.025 MB クエリ前のメモリ:21.782 MB 返された行:1
SELECT *
FROM joom_easyblog_post
WHERE `id` = '2'クエリではEXPLAINは使用できません:SELECT *
FROM joom_easyblog_post
WHERE `id` = '2'
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.05 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 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.03 ms cleaning up 0.00 ms
# 発信者 ファイルと行番号 17 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:149016 JDatabaseDriver->loadAssoc() Copy JROOT/libraries/joomla/table/table.php:72915 JTable->load() Copy JROOT/administrator/components/com_easyblog/tables/post.php:7914 EasyBlogTablePost->load() Copy JROOT/administrator/components/com_easyblog/includes/cache/cache.php:74513 EasyBlogCache->fallback() Copy JROOT/administrator/components/com_easyblog/includes/cache/cache.php:72012 EasyBlogCache->get() Copy JROOT/administrator/components/com_easyblog/includes/router.php:36711 EBR::_() Copy JROOT/components/com_easyblog/views/entry/view.html.php:52710 EasyBlogViewEntry->prepareNavigation() Copy JROOT/components/com_easyblog/views/entry/view.html.php:909 EasyBlogViewEntry->display() Copy JROOT/components/com_easyblog/controllers/controller.php:1088 EasyBlogController->display() Copy JROOT/libraries/legacy/controller/legacy.php:7097 JControllerLegacy->execute() Copy JROOT/components/com_easyblog/easyblog.php:436 require_once Copy JROOT/components/com_easyblog/easyblog.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2731 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:1.70 ms 最後のクエリの後:0.23 ms クエリメモリ:0.026 MB クエリ前のメモリ:21.805 MB 返された行:1
SELECT *
FROM joom_easyblog_revisions
WHERE `id` = '13'クエリではEXPLAINは使用できません:SELECT *
FROM joom_easyblog_revisions
WHERE `id` = '13'
Status Duration starting 0.06 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.04 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.01 ms executing 0.01 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 23 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:149022 JDatabaseDriver->loadAssoc() Copy JROOT/libraries/joomla/table/table.php:72921 JTable->load() Copy JROOT/administrator/components/com_easyblog/includes/post/post.php:36920 EasyBlogPost::loadRevision() Copy JROOT/administrator/components/com_easyblog/includes/post/post.php:28519 EasyBlogPost->load() Copy JROOT/components/com_easyblog/router.php:4118 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/administrator/components/com_easyblog/includes/router.php:46511 EBR::_() Copy JROOT/components/com_easyblog/views/entry/view.html.php:52710 EasyBlogViewEntry->prepareNavigation() Copy JROOT/components/com_easyblog/views/entry/view.html.php:909 EasyBlogViewEntry->display() Copy JROOT/components/com_easyblog/controllers/controller.php:1088 EasyBlogController->display() Copy JROOT/libraries/legacy/controller/legacy.php:7097 JControllerLegacy->execute() Copy JROOT/components/com_easyblog/easyblog.php:436 require_once Copy JROOT/components/com_easyblog/easyblog.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2731 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:3.16 ms 最後のクエリの後:0.10 ms クエリメモリ:0.027 MB クエリ前のメモリ:21.817 MB 返された行:1
SELECT * FROM `joom_easyblog_meta ` WHERE `type`= 'post' AND `content_id`= '2'クエリではEXPLAINは使用できません:SELECT * FROM `joom_easyblog_meta` WHERE `type`='post' AND `content_id`='2'
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.06 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.08 ms preparing 0.03 ms executing 0.05 ms end 0.02 ms query end 0.00 ms waiting for handler commit 0.19 ms closing tables 0.02 ms freeing items 0.05 ms cleaning up 0.02 ms
# 発信者 ファイルと行番号 24 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:168723 JDatabaseDriver->loadObject() Copy JROOT/administrator/components/com_easyblog/includes/utils.php:23522 EasyBlogDbJoomla->__call() Copy JROOT/administrator/components/com_easyblog/tables/meta.php:5121 EasyBlogTableMeta->loadByType() Copy JROOT/administrator/components/com_easyblog/includes/post/post.php:45220 EasyBlogPost->loadMeta() Copy JROOT/administrator/components/com_easyblog/includes/post/post.php:30419 EasyBlogPost->load() Copy JROOT/components/com_easyblog/router.php:4118 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/administrator/components/com_easyblog/includes/router.php:46511 EBR::_() Copy JROOT/components/com_easyblog/views/entry/view.html.php:52710 EasyBlogViewEntry->prepareNavigation() Copy JROOT/components/com_easyblog/views/entry/view.html.php:909 EasyBlogViewEntry->display() Copy JROOT/components/com_easyblog/controllers/controller.php:1088 EasyBlogController->display() Copy JROOT/libraries/legacy/controller/legacy.php:7097 JControllerLegacy->execute() Copy JROOT/components/com_easyblog/easyblog.php:436 require_once Copy JROOT/components/com_easyblog/easyblog.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2731 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:1.24 ms 最後のクエリの後:0.29 ms クエリメモリ:0.022 MB クエリ前のメモリ:21.841 MB 返された行:0
select `id` FROM `joom_easyblog_adsense ` where user_id = '1621309' クエリではEXPLAINは使用できません:select `id` FROM `joom_easyblog_adsense` where user_id = '1621309'
Status Duration starting 0.06 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.02 ms executing 0.02 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.00 ms
# 発信者 ファイルと行番号 14 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:176513 JDatabaseDriver->loadResult() Copy JROOT/administrator/components/com_easyblog/includes/utils.php:23512 EasyBlogDbJoomla->__call() Copy JROOT/administrator/components/com_easyblog/tables/adsense.php:3811 EasyBlogTableAdsense->load() Copy JROOT/administrator/components/com_easyblog/includes/adsense/adsense.php:6410 EasyBlogAdsense->html() Copy JROOT/components/com_easyblog/views/entry/view.html.php:939 EasyBlogViewEntry->display() Copy JROOT/components/com_easyblog/controllers/controller.php:1088 EasyBlogController->display() Copy JROOT/libraries/legacy/controller/legacy.php:7097 JControllerLegacy->execute() Copy JROOT/components/com_easyblog/easyblog.php:436 require_once Copy JROOT/components/com_easyblog/easyblog.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2731 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:1.96 ms 最後のクエリの後:0.27 ms クエリメモリ:0.022 MB クエリ前のメモリ:21.872 MB 返された行:0
SELECT `tag_id` FROM `joom_easyblog_post_tag ` WHERE `post_id`= '3'クエリではEXPLAINは使用できません:SELECT `tag_id` FROM `joom_easyblog_post_tag` WHERE `post_id`='3'
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.08 ms preparing 0.03 ms executing 0.02 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.06 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 13 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:157512 JDatabaseDriver->loadColumn() Copy JROOT/administrator/components/com_easyblog/includes/utils.php:23511 EasyBlogDbJoomla->__call() Copy JROOT/administrator/components/com_easyblog/models/blog.php:151510 EasyBlogModelBlog->getRelatedPosts() Copy JROOT/components/com_easyblog/views/entry/view.html.php:1179 EasyBlogViewEntry->display() Copy JROOT/components/com_easyblog/controllers/controller.php:1088 EasyBlogController->display() Copy JROOT/libraries/legacy/controller/legacy.php:7097 JControllerLegacy->execute() Copy JROOT/components/com_easyblog/easyblog.php:436 require_once Copy JROOT/components/com_easyblog/easyblog.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2731 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:3.14 ms 最後のクエリの後:8.36 ms クエリメモリ:0.024 MB クエリ前のメモリ:22.887 MB 返された行:1
SELECT `template` FROM `joom_template_styles ` WHERE `home`= '1' AND `client_id`= '0'クエリではEXPLAINは使用できません:SELECT `template` FROM `joom_template_styles` WHERE `home`='1' AND `client_id`='0'
Status Duration starting 0.09 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.01 ms optimizing 0.03 ms statistics 0.09 ms preparing 0.04 ms executing 0.06 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.03 ms freeing items 0.04 ms cleaning up 0.02 ms
# 発信者 ファイルと行番号 17 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:176516 JDatabaseDriver->loadResult() Copy JROOT/administrator/components/com_easyblog/includes/utils.php:23515 EasyBlogDbJoomla->__call() Copy JROOT/administrator/components/com_easyblog/models/themes.php:4614 EasyBlogModelThemes->getDefaultJoomlaTemplate() Copy JROOT/administrator/components/com_easyblog/includes/easyblog.php:249313 EB::getCurrentTemplate() Copy JROOT/administrator/components/com_easyblog/includes/themes/themes.php:22212 EasyBlogThemes->resolve() Copy JROOT/administrator/components/com_easyblog/includes/themes/themes.php:42911 EasyBlogThemes->output() Copy JROOT/components/com_easyblog/views/views.php:16410 EasyBlogView->display() Copy JROOT/components/com_easyblog/views/entry/view.html.php:1899 EasyBlogViewEntry->display() Copy JROOT/components/com_easyblog/controllers/controller.php:1088 EasyBlogController->display() Copy JROOT/libraries/legacy/controller/legacy.php:7097 JControllerLegacy->execute() Copy JROOT/components/com_easyblog/easyblog.php:436 require_once Copy JROOT/components/com_easyblog/easyblog.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2731 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:10.54 ms 最後のクエリの後:1.64 ms クエリメモリ:0.028 MB クエリ前のメモリ:23.121 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 <= '2025-04-04 13:06:08') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2025-04-04 13:06:08') AND m.access IN (1,1) AND m.client_id = 0 AND (mm.menuid = 868 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 <= '2025-04-04 13:06:08') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2025-04-04 13:06:08') AND m.access IN (1,1) AND m.client_id = 0 AND (mm.menuid = 868 OR mm.menuid <= 0) AND m.language IN ('ja-JA','*')
ORDER BY m.position, m.ordering
Status Duration starting 0.19 ms Executing hook on transaction 0.01 ms starting 0.03 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.11 ms init 0.01 ms System lock 0.02 ms optimizing 0.04 ms statistics 0.17 ms preparing 0.07 ms executing 1.28 ms end 0.03 ms query end 0.01 ms waiting for handler commit 0.02 ms closing tables 0.03 ms freeing items 0.08 ms cleaning up 0.03 ms
# 発信者 ファイルと行番号 19 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172618 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/joomla/cache/controller/callback.php:16917 JCacheControllerCallback->get() Copy JROOT/libraries/cms/module/helper.php:42416 JModuleHelper::getModuleList() Copy JROOT/libraries/cms/module/helper.php:36015 JModuleHelper::load() Copy JROOT/libraries/cms/module/helper.php:8414 JModuleHelper::getModules() Copy JROOT/administrator/components/com_easyblog/includes/themes/themes.php:29513 EasyBlogThemes->renderModule() Copy JROOT/components/com_easyblog/themes/wireframe/blogs/entry/default.php:5312 include Copy JROOT/components/com_easyblog/themes/wireframe/blogs/entry/default.php Copy JROOT/administrator/components/com_easyblog/includes/themes/themes.php:44511 EasyBlogThemes->output() Copy JROOT/components/com_easyblog/views/views.php:16410 EasyBlogView->display() Copy JROOT/components/com_easyblog/views/entry/view.html.php:1899 EasyBlogViewEntry->display() Copy JROOT/components/com_easyblog/controllers/controller.php:1088 EasyBlogController->display() Copy JROOT/libraries/legacy/controller/legacy.php:7097 JControllerLegacy->execute() Copy JROOT/components/com_easyblog/easyblog.php:436 require_once Copy JROOT/components/com_easyblog/easyblog.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2731 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:1.78 ms 最後のクエリの後:3.47 ms クエリメモリ:0.028 MB クエリ前のメモリ:23.385 MB 返された行:1
SELECT *
FROM joom_easyblog_revisions
WHERE `id` = '13'クエリではEXPLAINは使用できません:SELECT *
FROM joom_easyblog_revisions
WHERE `id` = '13'
Status Duration starting 0.07 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.04 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.12 ms preparing 0.01 ms executing 0.03 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.42 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms
# 発信者 ファイルと行番号 27 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:149026 JDatabaseDriver->loadAssoc() Copy JROOT/libraries/joomla/table/table.php:72925 JTable->load() Copy JROOT/administrator/components/com_easyblog/includes/post/post.php:36924 EasyBlogPost::loadRevision() Copy JROOT/administrator/components/com_easyblog/includes/post/post.php:28523 EasyBlogPost->load() Copy JROOT/components/com_easyblog/router.php:4122 EasyBlogBuildRoute() Copy JROOT/libraries/cms/component/router/legacy.php:6821 JComponentRouterLegacy->build() Copy JROOT/libraries/cms/router/site.php:51920 JRouterSite->buildSefRoute() Copy JROOT/libraries/cms/router/site.php:48919 JRouterSite->_buildSefRoute() Copy JROOT/libraries/cms/router/router.php:28218 JRouter->build() Copy JROOT/libraries/cms/router/site.php:14917 JRouterSite->build() Copy JROOT/libraries/joomla/application/route.php:6216 JRoute::_() Copy JROOT/administrator/components/com_easyblog/includes/post/post.php:475715 EasyBlogPost->getPermalink() Copy JROOT/components/com_easyblog/themes/wireframe/blogs/entry/author.php:9714 include Copy JROOT/components/com_easyblog/themes/wireframe/blogs/entry/author.php Copy JROOT/administrator/components/com_easyblog/includes/themes/themes.php:44513 EasyBlogThemes->output() Copy JROOT/components/com_easyblog/themes/wireframe/blogs/entry/default.php:20712 include Copy JROOT/components/com_easyblog/themes/wireframe/blogs/entry/default.php Copy JROOT/administrator/components/com_easyblog/includes/themes/themes.php:44511 EasyBlogThemes->output() Copy JROOT/components/com_easyblog/views/views.php:16410 EasyBlogView->display() Copy JROOT/components/com_easyblog/views/entry/view.html.php:1899 EasyBlogViewEntry->display() Copy JROOT/components/com_easyblog/controllers/controller.php:1088 EasyBlogController->display() Copy JROOT/libraries/legacy/controller/legacy.php:7097 JControllerLegacy->execute() Copy JROOT/components/com_easyblog/easyblog.php:436 require_once Copy JROOT/components/com_easyblog/easyblog.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2731 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:1.44 ms 最後のクエリの後:0.07 ms クエリメモリ:0.029 MB クエリ前のメモリ:23.399 MB 返された行:1
SELECT * FROM `joom_easyblog_meta ` WHERE `type`= 'post' AND `content_id`= '2'クエリではEXPLAINは使用できません:SELECT * FROM `joom_easyblog_meta` WHERE `type`='post' AND `content_id`='2'
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.02 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.05 ms preparing 0.02 ms executing 0.03 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 28 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:168727 JDatabaseDriver->loadObject() Copy JROOT/administrator/components/com_easyblog/includes/utils.php:23526 EasyBlogDbJoomla->__call() Copy JROOT/administrator/components/com_easyblog/tables/meta.php:5125 EasyBlogTableMeta->loadByType() Copy JROOT/administrator/components/com_easyblog/includes/post/post.php:45224 EasyBlogPost->loadMeta() Copy JROOT/administrator/components/com_easyblog/includes/post/post.php:30423 EasyBlogPost->load() Copy JROOT/components/com_easyblog/router.php:4122 EasyBlogBuildRoute() Copy JROOT/libraries/cms/component/router/legacy.php:6821 JComponentRouterLegacy->build() Copy JROOT/libraries/cms/router/site.php:51920 JRouterSite->buildSefRoute() Copy JROOT/libraries/cms/router/site.php:48919 JRouterSite->_buildSefRoute() Copy JROOT/libraries/cms/router/router.php:28218 JRouter->build() Copy JROOT/libraries/cms/router/site.php:14917 JRouterSite->build() Copy JROOT/libraries/joomla/application/route.php:6216 JRoute::_() Copy JROOT/administrator/components/com_easyblog/includes/post/post.php:475715 EasyBlogPost->getPermalink() Copy JROOT/components/com_easyblog/themes/wireframe/blogs/entry/author.php:9714 include Copy JROOT/components/com_easyblog/themes/wireframe/blogs/entry/author.php Copy JROOT/administrator/components/com_easyblog/includes/themes/themes.php:44513 EasyBlogThemes->output() Copy JROOT/components/com_easyblog/themes/wireframe/blogs/entry/default.php:20712 include Copy JROOT/components/com_easyblog/themes/wireframe/blogs/entry/default.php Copy JROOT/administrator/components/com_easyblog/includes/themes/themes.php:44511 EasyBlogThemes->output() Copy JROOT/components/com_easyblog/views/views.php:16410 EasyBlogView->display() Copy JROOT/components/com_easyblog/views/entry/view.html.php:1899 EasyBlogViewEntry->display() Copy JROOT/components/com_easyblog/controllers/controller.php:1088 EasyBlogController->display() Copy JROOT/libraries/legacy/controller/legacy.php:7097 JControllerLegacy->execute() Copy JROOT/components/com_easyblog/easyblog.php:436 require_once Copy JROOT/components/com_easyblog/easyblog.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2731 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:1.74 ms 最後のクエリの後:0.20 ms クエリメモリ:0.025 MB クエリ前のメモリ:23.386 MB 返された行:1
SELECT COUNT (1) FROM (SELECT a.* , (count(b.id) - 1) AS `depth` FROM `joom_easyblog_comment ` AS a INNER JOIN `joom_easyblog_comment ` AS b LEFT JOIN `joom_users ` AS c ON a.`created_by` = c.`id` WHERE a.`post_id` = '3' AND b.`post_id` = '3' AND a.`published` = 1 AND b.`published` = 1 AND a.`lft` BETWEEN b.`lft` AND b.`rgt` GROUP BY a.`id`) AS xクエリではEXPLAINは使用できません:SELECT COUNT(1) FROM (SELECT a.*, (count(b.id) - 1) AS `depth` FROM `joom_easyblog_comment` AS a INNER JOIN `joom_easyblog_comment` AS b LEFT JOIN `joom_users` AS c ON a.`created_by` = c.`id` WHERE a.`post_id` = '3' AND b.`post_id` = '3' AND a.`published` = 1 AND b.`published` = 1 AND a.`lft` BETWEEN b.`lft` AND b.`rgt` GROUP BY a.`id`) AS x
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 checking permissions 0.00 ms Opening tables 0.13 ms init 0.01 ms System lock 0.01 ms optimizing 0.00 ms optimizing 0.02 ms statistics 0.14 ms preparing 0.05 ms statistics 0.01 ms preparing 0.05 ms executing 0.04 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.04 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 19 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:176518 JDatabaseDriver->loadResult() Copy JROOT/administrator/components/com_easyblog/includes/utils.php:23517 EasyBlogDbJoomla->__call() Copy JROOT/administrator/components/com_easyblog/models/blog.php:14616 EasyBlogModelBlog->getBlogComment() Copy JROOT/administrator/components/com_easyblog/includes/comment/adapters/easyblog.php:11515 EasyBlogCommentEasyBlog->prepareComments() Copy JROOT/administrator/components/com_easyblog/includes/comment/adapters/easyblog.php:3214 EasyBlogCommentEasyBlog->html() Copy JROOT/administrator/components/com_easyblog/includes/comment/comment.php:45713 EasyBlogComment->getCommentHTML() Copy JROOT/components/com_easyblog/themes/wireframe/blogs/entry/default.php:23912 include Copy JROOT/components/com_easyblog/themes/wireframe/blogs/entry/default.php Copy JROOT/administrator/components/com_easyblog/includes/themes/themes.php:44511 EasyBlogThemes->output() Copy JROOT/components/com_easyblog/views/views.php:16410 EasyBlogView->display() Copy JROOT/components/com_easyblog/views/entry/view.html.php:1899 EasyBlogViewEntry->display() Copy JROOT/components/com_easyblog/controllers/controller.php:1088 EasyBlogController->display() Copy JROOT/libraries/legacy/controller/legacy.php:7097 JControllerLegacy->execute() Copy JROOT/components/com_easyblog/easyblog.php:436 require_once Copy JROOT/components/com_easyblog/easyblog.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2731 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:2.38 ms 最後のクエリの後:0.20 ms クエリメモリ:0.025 MB クエリ前のメモリ:23.413 MB 返された行:0
SELECT a.* , (count(b.id) - 1) AS `depth` FROM `joom_easyblog_comment ` AS a INNER JOIN `joom_easyblog_comment ` AS b LEFT JOIN `joom_users ` AS c ON a.`created_by` = c.`id` WHERE a.`post_id` = '3' AND b.`post_id` = '3' AND a.`published` = 1 AND b.`published` = 1 AND a.`lft` BETWEEN b.`lft` AND b.`rgt` GROUP BY a.`id` ORDER BY a.`lft` asc LIMIT 0,10クエリではEXPLAINは使用できません:SELECT a.*, (count(b.id) - 1) AS `depth` FROM `joom_easyblog_comment` AS a INNER JOIN `joom_easyblog_comment` AS b LEFT JOIN `joom_users` AS c ON a.`created_by` = c.`id` WHERE a.`post_id` = '3' AND b.`post_id` = '3' AND a.`published` = 1 AND b.`published` = 1 AND a.`lft` BETWEEN b.`lft` AND b.`rgt` GROUP BY a.`id` ORDER BY a.`lft` asc LIMIT 0,10
Status Duration starting 0.12 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms 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.33 ms preparing 0.03 ms Creating tmp table 0.08 ms executing 0.04 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.03 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 19 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172618 JDatabaseDriver->loadObjectList() Copy JROOT/administrator/components/com_easyblog/includes/utils.php:23517 EasyBlogDbJoomla->__call() Copy JROOT/administrator/components/com_easyblog/models/blog.php:15516 EasyBlogModelBlog->getBlogComment() Copy JROOT/administrator/components/com_easyblog/includes/comment/adapters/easyblog.php:11515 EasyBlogCommentEasyBlog->prepareComments() Copy JROOT/administrator/components/com_easyblog/includes/comment/adapters/easyblog.php:3214 EasyBlogCommentEasyBlog->html() Copy JROOT/administrator/components/com_easyblog/includes/comment/comment.php:45713 EasyBlogComment->getCommentHTML() Copy JROOT/components/com_easyblog/themes/wireframe/blogs/entry/default.php:23912 include Copy JROOT/components/com_easyblog/themes/wireframe/blogs/entry/default.php Copy JROOT/administrator/components/com_easyblog/includes/themes/themes.php:44511 EasyBlogThemes->output() Copy JROOT/components/com_easyblog/views/views.php:16410 EasyBlogView->display() Copy JROOT/components/com_easyblog/views/entry/view.html.php:1899 EasyBlogViewEntry->display() Copy JROOT/components/com_easyblog/controllers/controller.php:1088 EasyBlogController->display() Copy JROOT/libraries/legacy/controller/legacy.php:7097 JControllerLegacy->execute() Copy JROOT/components/com_easyblog/easyblog.php:436 require_once Copy JROOT/components/com_easyblog/easyblog.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2731 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:3.04 ms 最後のクエリの後:1.87 ms クエリメモリ:0.023 MB クエリ前のメモリ:23.582 MB 返された行:1
SELECT *
FROM joom_easyblog_post
WHERE `id` = '3'クエリではEXPLAINは使用できません:SELECT *
FROM joom_easyblog_post
WHERE `id` = '3'
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.06 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.07 ms preparing 0.02 ms executing 0.03 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 15 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:149014 JDatabaseDriver->loadAssoc() Copy JROOT/libraries/joomla/table/table.php:72913 JTable->load() Copy JROOT/administrator/components/com_easyblog/tables/blog.php:8512 EasyBlogTableBlog->load() Copy JROOT/components/com_easyblog/views/views.php:36111 EasyBlogView->getToolbar() Copy JROOT/components/com_easyblog/views/views.php:19610 EasyBlogView->display() Copy JROOT/components/com_easyblog/views/entry/view.html.php:1899 EasyBlogViewEntry->display() Copy JROOT/components/com_easyblog/controllers/controller.php:1088 EasyBlogController->display() Copy JROOT/libraries/legacy/controller/legacy.php:7097 JControllerLegacy->execute() Copy JROOT/components/com_easyblog/easyblog.php:436 require_once Copy JROOT/components/com_easyblog/easyblog.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2731 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:1.41 ms 最後のクエリの後:4.00 ms クエリメモリ:0.021 MB クエリ前のメモリ:23.786 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.03 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.02 ms executing 0.26 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:17269 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/cms/language/multilang.php:1068 JLanguageMultilang::getSiteHomePages() Copy JROOT/plugins/system/languagefilter/languagefilter.php:7297 PlgSystemLanguageFilter->onAfterDispatch() Copy JROOT/libraries/joomla/event/event.php:706 JEvent->update() Copy JROOT/libraries/joomla/event/dispatcher.php:1605 JEventDispatcher->trigger() Copy JROOT/libraries/joomla/application/base.php:1064 JApplicationBase->triggerEvent() Copy JROOT/libraries/cms/application/site.php:1963 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2731 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:1.24 ms 最後のクエリの後:0.36 ms クエリメモリ:0.021 MB クエリ前のメモリ:23.798 MB 返された行:0
select p.`language`, a.`post_id` as `id` from `joom_easyblog_associations ` as a inner join `joom_easyblog_associations ` as b on a.`key` = b.`key` inner join `joom_easyblog_post ` as p on a.`post_id` = p.`id` where b.`post_id` = '3' クエリではEXPLAINは使用できません:select p.`language`, a.`post_id` as `id` from `joom_easyblog_associations` as a inner join `joom_easyblog_associations` as b on a.`key` = b.`key` inner join `joom_easyblog_post` as p on a.`post_id` = p.`id` where b.`post_id` = '3'
Status Duration starting 0.06 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.07 ms preparing 0.03 ms executing 0.02 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.00 ms
# 発信者 ファイルと行番号 11 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172610 JDatabaseDriver->loadObjectList() Copy JROOT/administrator/components/com_easyblog/includes/utils.php:2359 EasyBlogDbJoomla->__call() Copy JROOT/components/com_easyblog/helpers/association.php:458 EasyBlogHelperAssociation::getAssociations() Copy JROOT/plugins/system/languagefilter/languagefilter.php:7617 PlgSystemLanguageFilter->onAfterDispatch() Copy JROOT/libraries/joomla/event/event.php:706 JEvent->update() Copy JROOT/libraries/joomla/event/dispatcher.php:1605 JEventDispatcher->trigger() Copy JROOT/libraries/joomla/application/base.php:1064 JApplicationBase->triggerEvent() Copy JROOT/libraries/cms/application/site.php:1963 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2731 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:1.31 ms 最後のクエリの後:2.80 ms クエリメモリ:0.022 MB クエリ前のメモリ:24.137 MB 返された行:1
SELECT *
FROM `currency`
WHERE `base_currency`= 1 LIMIT 1クエリではEXPLAINは使用できません:SELECT *
FROM `currency`
WHERE `base_currency`=1 LIMIT 1
Status Duration starting 0.06 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.02 ms executing 0.14 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
# 発信者 ファイルと行番号 12 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:168711 JDatabaseDriver->loadObject() Copy JROOT/libraries/axslibs/currency.php:8410 AxsCurrency->getBaseCurrency() Copy JROOT/libraries/axslibs/currency.php:229 AxsCurrency->__construct() Copy JROOT/templates/axs/home.php:208 include Copy JROOT/templates/axs/home.php Copy JROOT/templates/axs/index.php: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:11813 JApplicationCms->render() Copy JROOT/libraries/cms/application/site.php:7822 JApplicationSite->render() Copy JROOT/libraries/cms/application/cms.php:2791 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:1.43 ms 最後のクエリの後:0.10 ms クエリメモリ:0.023 MB クエリ前のメモリ:24.143 MB 返された行:10
SELECT * FROM axs_fonts WHERE enabled = 1クエリではEXPLAINは使用できません:SELECT * FROM axs_fonts WHERE enabled = 1
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.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.17 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
# 発信者 ファイルと行番号 11 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172610 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/axslibs/fonts.php:349 AxsFonts::getFonts() Copy JROOT/templates/axs/home.php:938 include Copy JROOT/templates/axs/home.php Copy JROOT/templates/axs/index.php: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:11813 JApplicationCms->render() Copy JROOT/libraries/cms/application/site.php:7822 JApplicationSite->render() Copy JROOT/libraries/cms/application/cms.php:2791 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:1.20 ms 最後のクエリの後:0.19 ms クエリメモリ:0.022 MB クエリ前のメモリ:24.179 MB 返された行:0
SELECT *
FROM accessibility_images
WHERE `path`= 'images/pDJC5BxLjAW4jMgmh4ZjVUqCNDU3NDQ2OTkwOTMw/graphics/blue-logo.png' AND enabled= 1クエリではEXPLAINは使用できません:SELECT *
FROM accessibility_images
WHERE `path`='images/pDJC5BxLjAW4jMgmh4ZjVUqCNDU3NDQ2OTkwOTMw/graphics/blue-logo.png' AND enabled= 1
Status Duration starting 0.05 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.02 ms preparing 0.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.00 ms
# 発信者 ファイルと行番号 12 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:168711 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:7998 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:11813 JApplicationCms->render() Copy JROOT/libraries/cms/application/site.php:7822 JApplicationSite->render() Copy JROOT/libraries/cms/application/cms.php:2791 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:1.52 ms 最後のクエリの後:1.79 ms クエリメモリ:0.022 MB クエリ前のメモリ:24.233 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.15 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.02 ms Opening tables 0.08 ms init 0.01 ms System lock 0.01 ms optimizing 0.05 ms statistics 0.04 ms preparing 0.05 ms executing 0.04 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.02 ms closing tables 0.02 ms freeing items 0.06 ms cleaning up 0.02 ms
# 発信者 ファイルと行番号 11 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172610 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/axslibs/notifications.php:199 AxsNotifications::loadNotifications() Copy JROOT/templates/axs/home.php:17888 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:11813 JApplicationCms->render() Copy JROOT/libraries/cms/application/site.php:7822 JApplicationSite->render() Copy JROOT/libraries/cms/application/cms.php:2791 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:1.25 ms 最後のクエリの後:0.66 ms クエリメモリ:0.023 MB クエリ前のメモリ:24.133 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.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.06 ms preparing 0.01 ms executing 0.01 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 14 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:168713 JDatabaseDriver->loadObject() Copy JROOT/libraries/axslibs/language.php:28512 AxsLanguage::getSefByLangCode() Copy JROOT/modules/mod_mediamodal/tmpl/default.php:811 require Copy JROOT/modules/mod_mediamodal/tmpl/default.php Copy JROOT/modules/mod_mediamodal/mod_mediamodal.php:910 include Copy JROOT/modules/mod_mediamodal/mod_mediamodal.php Copy JROOT/libraries/cms/module/helper.php:1989 JModuleHelper::renderModule() Copy JROOT/libraries/joomla/document/renderer/html/module.php:938 JDocumentRendererHtmlModule->render() Copy JROOT/libraries/joomla/document/renderer/html/modules.php:427 JDocumentRendererHtmlModules->render() Copy JROOT/libraries/joomla/document/html.php:4866 JDocumentHtml->getBuffer() Copy JROOT/libraries/joomla/document/html.php:7775 JDocumentHtml->_renderTemplate() Copy JROOT/libraries/joomla/document/html.php:5524 JDocumentHtml->render() Copy JROOT/libraries/cms/application/cms.php:11983 JApplicationCms->render() Copy JROOT/libraries/cms/application/site.php:7822 JApplicationSite->render() Copy JROOT/libraries/cms/application/cms.php:2791 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:3.48 ms 最後のクエリの後:5.75 ms クエリメモリ:0.028 MB クエリ前のメモリ:24.508 MB 返された行:1
SELECT * FROM joom_kunena_configuration WHERE id= 1クエリではEXPLAINは使用できません:SELECT * FROM joom_kunena_configuration WHERE id=1
Status Duration starting 0.05 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.10 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.05 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.69 ms cleaning up 0.37 ms
# 発信者 ファイルと行番号 28 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:149027 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:11983 JApplicationCms->render() Copy JROOT/libraries/cms/application/site.php:7822 JApplicationSite->render() Copy JROOT/libraries/cms/application/cms.php:2791 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:3.58 ms 最後のクエリの後:4.30 ms クエリメモリ:0.024 MB クエリ前のメモリ:24.723 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.05 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.01 ms System lock 0.02 ms optimizing 0.02 ms statistics 0.09 ms preparing 0.02 ms executing 0.01 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.02 ms
# 発信者 ファイルと行番号 16 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:168715 JDatabaseDriver->loadObject() Copy JROOT/libraries/axslibs/language.php:30814 AxsLanguage::getSpecialCharacters() Copy JROOT/libraries/axslibs/language.php:2613 AxsLanguage::translate() Copy JROOT/modules/mod_defaultmenu/tmpl/default_component.php:2112 require Copy JROOT/modules/mod_defaultmenu/tmpl/default_component.php Copy JROOT/modules/mod_defaultmenu/tmpl/default.php:7211 require Copy JROOT/modules/mod_defaultmenu/tmpl/default.php Copy JROOT/modules/mod_defaultmenu/mod_defaultmenu.php:2510 include Copy JROOT/modules/mod_defaultmenu/mod_defaultmenu.php Copy JROOT/libraries/cms/module/helper.php:1989 JModuleHelper::renderModule() Copy JROOT/libraries/joomla/document/renderer/html/module.php:938 JDocumentRendererHtmlModule->render() Copy JROOT/libraries/joomla/document/renderer/html/modules.php:427 JDocumentRendererHtmlModules->render() Copy JROOT/libraries/joomla/document/html.php:4866 JDocumentHtml->getBuffer() Copy JROOT/libraries/joomla/document/html.php:7775 JDocumentHtml->_renderTemplate() Copy JROOT/libraries/joomla/document/html.php:5524 JDocumentHtml->render() Copy JROOT/libraries/cms/application/cms.php:11983 JApplicationCms->render() Copy JROOT/libraries/cms/application/site.php:7822 JApplicationSite->render() Copy JROOT/libraries/cms/application/cms.php:2791 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:3.64 ms 最後のクエリの後:0.05 ms クエリメモリ:0.026 MB クエリ前のメモリ:24.734 MB 返された行:25
SELECT *
FROM axs_translations
WHERE language_tag = 'ja'クエリではEXPLAINは使用できません:SELECT *
FROM axs_translations
WHERE language_tag = 'ja'
Status Duration starting 0.04 ms Executing hook on transaction 0.02 ms starting 0.01 ms checking permissions 0.02 ms Opening tables 0.06 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.06 ms preparing 0.02 ms executing 0.12 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.02 ms
# 発信者 ファイルと行番号 16 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:153115 JDatabaseDriver->loadAssocList() Copy JROOT/libraries/axslibs/language.php:15014 AxsLanguage::getTranslationMap() Copy JROOT/libraries/axslibs/language.php:3913 AxsLanguage::translate() Copy JROOT/modules/mod_defaultmenu/tmpl/default_component.php:2112 require Copy JROOT/modules/mod_defaultmenu/tmpl/default_component.php Copy JROOT/modules/mod_defaultmenu/tmpl/default.php:7211 require Copy JROOT/modules/mod_defaultmenu/tmpl/default.php Copy JROOT/modules/mod_defaultmenu/mod_defaultmenu.php:2510 include Copy JROOT/modules/mod_defaultmenu/mod_defaultmenu.php Copy JROOT/libraries/cms/module/helper.php:1989 JModuleHelper::renderModule() Copy JROOT/libraries/joomla/document/renderer/html/module.php:938 JDocumentRendererHtmlModule->render() Copy JROOT/libraries/joomla/document/renderer/html/modules.php:427 JDocumentRendererHtmlModules->render() Copy JROOT/libraries/joomla/document/html.php:4866 JDocumentHtml->getBuffer() Copy JROOT/libraries/joomla/document/html.php:7775 JDocumentHtml->_renderTemplate() Copy JROOT/libraries/joomla/document/html.php:5524 JDocumentHtml->render() Copy JROOT/libraries/cms/application/cms.php:11983 JApplicationCms->render() Copy JROOT/libraries/cms/application/site.php:7822 JApplicationSite->render() Copy JROOT/libraries/cms/application/cms.php:2791 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:2.23 ms 最後のクエリの後:4.19 ms クエリメモリ:0.023 MB クエリ前のメモリ:24.797 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 = 868クエリでは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 = 868
Status Duration starting 0.09 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.05 ms init 0.01 ms System lock 0.02 ms optimizing 0.03 ms statistics 0.15 ms executing 0.01 ms end 0.01 ms query end 0.63 ms waiting for handler commit 0.02 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 15 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172614 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/cms/language/associations.php:10113 JLanguageAssociations::getAssociations() Copy JROOT/administrator/components/com_menus/helpers/menus.php:31312 MenusHelper::getAssociations() Copy JROOT/modules/mod_language_selector/tmpl/default.php:9111 require Copy JROOT/modules/mod_language_selector/tmpl/default.php Copy JROOT/modules/mod_language_selector/mod_language_selector.php:410 include Copy JROOT/modules/mod_language_selector/mod_language_selector.php Copy JROOT/libraries/cms/module/helper.php:1989 JModuleHelper::renderModule() Copy JROOT/libraries/joomla/document/renderer/html/module.php:938 JDocumentRendererHtmlModule->render() Copy JROOT/libraries/joomla/document/renderer/html/modules.php:427 JDocumentRendererHtmlModules->render() Copy JROOT/libraries/joomla/document/html.php:4866 JDocumentHtml->getBuffer() Copy JROOT/libraries/joomla/document/html.php:7775 JDocumentHtml->_renderTemplate() Copy JROOT/libraries/joomla/document/html.php:5524 JDocumentHtml->render() Copy JROOT/libraries/cms/application/cms.php:11983 JApplicationCms->render() Copy JROOT/libraries/cms/application/site.php:7822 JApplicationSite->render() Copy JROOT/libraries/cms/application/cms.php:2791 JApplicationCms->execute() Copy JROOT/index.php:72
4×SELECT * FROM joom_easyblog_post 4×SELECT * FROM joom_easyblog_revisions 4×SELECT * FROM `joom_easyblog_meta ` 2×SELECT `id` FROM `joom_easyblog_post ` 2×SELECT * FROM `joom_users ` 2×SELECT a.`id`, a.`title` FROM `joom_easyblog_post ` AS `a` 2×SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `joom_extensions ` 2×SELECT * FROM joom_languages 1×SELECT * FROM joom_easyblog_meta 1×SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state FROM joom_fields AS a LEFT JOIN `joom_languages ` AS l ON l.lang_code = a.language LEFT JOIN joom_users AS uc ON uc.id= a.checked_out LEFT JOIN joom_viewlevels AS ag ON ag.id = a.access LEFT JOIN joom_users AS ua ON ua.id = a.created_user_id LEFT JOIN joom_fields_groups AS g ON g.id = a.group_id LEFT JOIN `joom_fields_categories ` AS fc ON fc.field_id = a.id 1×SELECT COUNT (1) FROM `joom_easyblog_featured ` 1×SELECT `group_id` FROM `joom_easyblog_category_fields_groups ` 1×SELECT a.* FROM `joom_easyblog_fields ` AS a INNER JOIN `joom_easyblog_category_fields_groups ` AS b ON a.`group_id`= b.`group_id` 1×SELECT `key`,`value` FROM `joom_easyblog_post_assets ` 1×SELECT SQL_CALC_FOUND_ROWS a.`id` AS key1, a.* , ifnull(f.`id`, 0) as `featured` FROM `joom_easyblog_post ` AS a LEFT JOIN `joom_easyblog_featured ` AS f ON a.`id` = f.`content_id` AND f.`type` = 'post' 1×select * from `joom_easyblog_meta ` 1×SELECT `id` FROM `joom_menu ` 1×select `a`.`id` as `cat_fg_id`, `a`.`category_id` as `cat_fg_category_id`, `a`.`group_id` as `cat_fg_group_id`, `fg`.`id` as `fg_id`, `fg`.`title` as `fg_title`, `fg`.`description` as `fg_description`, `fg`.`created` as `fg_created`, `fg`.`state` as `fg_state`, `fg`.`read` as `fg_read`, `fg`.`write` as `fg_write`, `fg`.`params` as `fg_params`, `f`.`id` as `f_id`, `f`.`group_id` as `f_group_id`, `f`.`title` as `f_title`, `f`.`help` as `f_help`, `f`.`state` as `f_state`, `f`.`required` as `f_required`, `f`.`type` as `f_type`, `f`.`params` as `f_params`, `f`.`created` as `f_created`, `f`.`options` as `f_options`, `fv`.`id` as `fv_id`, `fv`.`field_id` as `fv_field_id`, `fv`.`post_id` as `fv_post_id`, `fv`.`value` as `fv_value` from `joom_easyblog_category_fields_groups ` as a inner join `joom_easyblog_post_category ` as p on `a`.`category_id` = `p`.`category_id` inner join `joom_easyblog_fields_groups ` as fg on `a`.`group_id` = `fg`.`id` inner join `joom_easyblog_fields ` as f on `fg`.`id` = `f`.`group_id` left join `joom_easyblog_fields_values ` as fv on `fv`.`field_id` = `f`.`id` and `fv`.`post_id` = `p`.`post_id` 1×SELECT COUNT (1) FROM `joom_easyblog_comment ` 1×SELECT `session_id` FROM `joom_session ` 1×select u.* , e.`id` as `eb_id`, e.`nickname`, e.`avatar`, e.`description`, e.`url`, e.`params` as `eb_params`, e.`published` as `eb_published`, e.`title` as `eb_title`, e.`biography`, e.`permalink`, e.`custom_css` from `joom_users ` as u left join `joom_easyblog_users ` as e ON u.`id` = e.`id` 1×SELECT * FROM axs_fonts 1×SELECT * FROM axs_translations 1×SELECT special_characters FROM joom_languages 1×SELECT * FROM joom_kunena_configuration 1×SELECT sef FROM joom_languages 1×SELECT * FROM axs_notifications 1×SELECT * FROM accessibility_images 1×SELECT * FROM `currency` 1×select `id` FROM `joom_easyblog_adsense ` 1×select p.`language`, a.`post_id` as `id` from `joom_easyblog_associations ` as a inner join `joom_easyblog_associations ` as b on a.`key` = b.`key` inner join `joom_easyblog_post ` as p on a.`post_id` = p.`id` 1×SELECT language,id FROM `joom_menu ` 1×SELECT a.* , (count(b.id) - 1) AS `depth` FROM `joom_easyblog_comment ` AS a INNER JOIN `joom_easyblog_comment ` AS b LEFT JOIN `joom_users ` AS c ON a.`created_by` = c.`id` 1×SELECT COUNT (1) FROM (SELECT a.* , (count(b.id) - 1) AS `depth` FROM `joom_easyblog_comment ` AS a INNER JOIN `joom_easyblog_comment ` AS b LEFT JOIN `joom_users ` AS c ON a.`created_by` = c.`id` 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 `template` FROM `joom_template_styles ` 1×SELECT `tag_id` FROM `joom_easyblog_post_tag ` 1×SELECT `g`.`id`,`g`.`title` FROM `joom_usergroups ` AS g INNER JOIN `joom_user_usergroup_map ` AS m ON m.group_id = g.id 1×SELECT a.* FROM `joom_easyblog_comment ` AS a 1×select a.* from `joom_easyblog_revisions ` as a 1×SELECT * FROM joom_easyblog_configs 1×SELECT id, rules FROM `joom_viewlevels 1×SELECT b.id FROM joom_usergroups AS a LEFT JOIN joom_usergroups AS b ON b.lft <= a.lft AND b.rgt >= a.rgt 1×SELECT `folder` AS `type`,`element` AS `name`,`params` FROM joom_extensions 1×SELECT * FROM axs_domains 1×SELECT `element`,`name`,`client_id`,`extension_id` FROM `joom_extensions ` 1×SELECT * FROM `axs_brands` 1×SELECT * FROM `axs_homepage_templates` 1×SELECT * FROM `axs_dashboard_templates` 1×SELECT * FROM axs_email_settings 1×SELECT * FROM axs_payment_gateways 1×SELECT * FROM axs_integrations 1×SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component FROM joom_menu AS m LEFT JOIN joom_extensions AS e ON m.component_id = e.extension_id 1×SELECT `id`,`title` FROM `joom_usergroups ` 1×SELECT * FROM joom_extensions 1×select a.* , b.`post_id` from `joom_easyblog_tag ` as a inner join `joom_easyblog_post_tag ` as b on a.`id` = b.`tag_id` 1×SELECT * FROM `joom_easyblog_acl ` 1×SELECT * FROM `joom_easyblog_acl_group ` 1×SELECT params FROM axs_user_settings 1×SELECT id, home, template, s.params FROM joom_template_styles as s LEFT JOIN joom_extensions as e ON e.element= s.template AND e.type= 'template' AND e.client_id= s.client_id 1×SELECT `id` FROM `joom_easyblog_mailq ` 1×SELECT * FROM `joom_easyblog_post ` 1×SELECT id, created_by FROM `joom_easyblog_post ` 1×SELECT * FROM `joom_easyblog_uploader_tmp ` 1×SELECT * FROM `joom_menu ` 1×SELECT `id`,`name`,`rules`,`parent_id` FROM `joom_assets ` 1×SELECT COUNT (1) as `voted`, `uid` FROM `joom_easyblog_ratings ` 1×SELECT AVG (`value`) AS `ratings` ,COUNT (1) AS `total` ,`uid` FROM `joom_easyblog_ratings ` AS a 1×SELECT a.`post_id`, COUNT (1) AS `count` FROM `joom_easyblog_comment ` AS a 1×select a.* , b.`post_id`, b.`primary` from `joom_easyblog_category ` as a inner join `joom_easyblog_post_category ` as b on a.`id` = b.`category_id` 1×SELECT `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`