クエリ時間:0.62 ms クエリメモリ:0.020 MB クエリ前のメモリ:4.118 MB 返された行:0
SELECT `session_id`
FROM `joom_session `
WHERE `session_id` = 'f02c2s776fc2tvkt3d70dtj17u' LIMIT 1クエリではEXPLAINは使用できません:SELECT `session_id`
FROM `joom_session`
WHERE `session_id` = 'f02c2s776fc2tvkt3d70dtj17u' 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.05 ms executing 0.01 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 8 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:17607 JDatabaseDriver->loadResult() Copy JROOT/libraries/cms/application/cms.php:1766 JApplicationCms->checkSession() Copy JROOT/libraries/cms/application/cms.php:8885 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:4692 JApplicationCms::getInstance() Copy JROOT/libraries/joomla/factory.php:1251 JFactory::getApplication() Copy JROOT/index.php:50
クエリ時間:2.32 ms 最後のクエリの後:0.04 ms クエリメモリ:0.003 MB クエリ前のメモリ:4.185 MB
INSERT INTO `joom_session `
(`session_id`,`guest`,`time`,`userid`,`username`) VALUES
('f02c2s776fc2tvkt3d70dtj17u', 1, '1728145670', 0, '')クエリではEXPLAINは使用できません:INSERT INTO `joom_session`
(`session_id`,`guest`,`time`,`userid`,`username`) VALUES
('f02c2s776fc2tvkt3d70dtj17u', 1, '1728145670', 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.02 ms init 0.00 ms System lock 0.01 ms update 0.10 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.02 ms closing tables 0.01 ms freeing items 0.01 ms async commit 1.77 ms cleaning up 0.02 ms
# 発信者 ファイルと行番号 7 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/cms/application/cms.php:2166 JApplicationCms->checkSession() Copy JROOT/libraries/cms/application/cms.php:8885 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:4692 JApplicationCms::getInstance() Copy JROOT/libraries/joomla/factory.php:1251 JFactory::getApplication() Copy JROOT/index.php:50
クエリ時間:0.91 ms 最後のクエリの後:1.71 ms クエリメモリ:0.045 MB クエリ前のメモリ:4.356 MB 返された行:80
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `joom_extensions `
WHERE `type` = 'component'クエリではEXPLAINは使用できません:SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `joom_extensions`
WHERE `type` = 'component'
Status Duration starting 0.05 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.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.28 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:17219 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/cms/component/helper.php:4478 JComponentHelper::{closure}() Copy JROOT/libraries/joomla/cache/controller/callback.php:1697 JCacheControllerCallback->get() Copy JROOT/libraries/cms/component/helper.php:4556 JComponentHelper::load() Copy JROOT/libraries/cms/component/helper.php:435 JComponentHelper::getComponent() Copy JROOT/libraries/cms/component/helper.php:1114 JComponentHelper::getParams() Copy JROOT/libraries/cms/application/site.php:5983 JApplicationSite->initialiseApp() Copy JROOT/libraries/cms/application/site.php:2092 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:0.53 ms 最後のクエリの後:1.18 ms クエリメモリ:0.021 MB クエリ前のメモリ:4.567 MB 返された行:7
SELECT id, rules
FROM `joom_viewlevels `クエリではEXPLAINは使用できません:SELECT id, rules
FROM `joom_viewlevels`
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.00 ms statistics 0.01 ms preparing 0.02 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.02 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 10 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:15269 JDatabaseDriver->loadAssocList() Copy JROOT/libraries/joomla/access/access.php:10628 JAccess::getAuthorisedViewLevels() Copy JROOT/libraries/joomla/user/user.php:4537 JUser->getAuthorisedViewLevels() Copy JROOT/libraries/cms/plugin/helper.php:2936 JPluginHelper::load() Copy JROOT/libraries/cms/plugin/helper.php:865 JPluginHelper::getPlugin() Copy JROOT/libraries/cms/plugin/helper.php:1284 JPluginHelper::isEnabled() Copy JROOT/libraries/cms/application/site.php:6083 JApplicationSite->initialiseApp() Copy JROOT/libraries/cms/application/site.php:2092 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:0.59 ms 最後のクエリの後:0.04 ms クエリメモリ:0.021 MB クエリ前のメモリ:4.579 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.05 ms Executing hook on transaction 0.01 ms starting 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.00 ms optimizing 0.03 ms statistics 0.07 ms preparing 0.02 ms executing 0.02 ms end 0.00 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
# 発信者 ファイルと行番号 11 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:157010 JDatabaseDriver->loadColumn() Copy JROOT/libraries/joomla/access/access.php:9799 JAccess::getGroupsByUser() Copy JROOT/libraries/joomla/access/access.php:10948 JAccess::getAuthorisedViewLevels() Copy JROOT/libraries/joomla/user/user.php:4537 JUser->getAuthorisedViewLevels() Copy JROOT/libraries/cms/plugin/helper.php:2936 JPluginHelper::load() Copy JROOT/libraries/cms/plugin/helper.php:865 JPluginHelper::getPlugin() Copy JROOT/libraries/cms/plugin/helper.php:1284 JPluginHelper::isEnabled() Copy JROOT/libraries/cms/application/site.php:6083 JApplicationSite->initialiseApp() Copy JROOT/libraries/cms/application/site.php:2092 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:1.85 ms 最後のクエリの後:0.36 ms クエリメモリ:0.046 MB クエリ前のメモリ:4.641 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.07 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.06 ms preparing 0.03 ms executing 1.20 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 10 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:17219 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/cms/plugin/helper.php:3118 JPluginHelper::{closure}() Copy JROOT/libraries/joomla/cache/controller/callback.php:1697 JCacheControllerCallback->get() Copy JROOT/libraries/cms/plugin/helper.php:3166 JPluginHelper::load() Copy JROOT/libraries/cms/plugin/helper.php:865 JPluginHelper::getPlugin() Copy JROOT/libraries/cms/plugin/helper.php:1284 JPluginHelper::isEnabled() Copy JROOT/libraries/cms/application/site.php:6083 JApplicationSite->initialiseApp() Copy JROOT/libraries/cms/application/site.php:2092 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:0.56 ms 最後のクエリの後:16.29 ms クエリメモリ:0.024 MB クエリ前のメモリ:7.102 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.02 ms init 0.01 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.07 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:168216 JDatabaseDriver->loadObject() Copy JROOT/libraries/cms/library/helper.php:16615 JLibraryHelper::{closure}() Copy JROOT/libraries/joomla/cache/controller/callback.php:16914 JCacheControllerCallback->get() Copy JROOT/libraries/cms/library/helper.php:17413 JLibraryHelper::loadLibrary() Copy JROOT/libraries/cms/library/helper.php:4212 JLibraryHelper::getLibrary() Copy JROOT/libraries/cms/library/helper.php:8911 JLibraryHelper::getParams() Copy JROOT/libraries/cms/version/version.php:27010 JVersion->getMediaVersion() Copy JROOT/libraries/joomla/factory.php: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:7394 JApplicationCms->initialiseApp() Copy JROOT/libraries/cms/application/site.php:6903 JApplicationSite->initialiseApp() Copy JROOT/libraries/cms/application/site.php:2092 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:7.36 ms 最後のクエリの後:0.06 ms クエリメモリ:0.006 MB クエリ前のメモリ:7.094 MB
UPDATE `joom_extensions `
SET `params` = '{\"mediaversion\":\"67e8f9a3ac5d0470b507efd5f397487b\"}'
WHERE `type` = 'library' AND `element` = 'joomla'クエリではEXPLAINは使用できません:UPDATE `joom_extensions`
SET `params` = '{\"mediaversion\":\"67e8f9a3ac5d0470b507efd5f397487b\"}'
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.08 ms updating 0.09 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.04 ms closing tables 0.01 ms freeing items 0.01 ms async commit 6.71 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 13 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/cms/library/helper.php:11612 JLibraryHelper::saveParams() Copy JROOT/libraries/cms/version/version.php:32111 JVersion->setMediaVersion() Copy JROOT/libraries/cms/version/version.php:28010 JVersion->getMediaVersion() Copy JROOT/libraries/joomla/factory.php: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:7394 JApplicationCms->initialiseApp() Copy JROOT/libraries/cms/application/site.php:6903 JApplicationSite->initialiseApp() Copy JROOT/libraries/cms/application/site.php:2092 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:0.74 ms 最後のクエリの後:3.86 ms クエリメモリ:0.029 MB クエリ前のメモリ:8.035 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.06 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.04 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.03 ms executing 0.15 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.00 ms
# 発信者 ファイルと行番号 10 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:17219 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/joomla/language/helper.php:1488 JLanguageHelper::getLanguages() Copy JROOT/plugins/system/languagefilter/languagefilter.php:997 PlgSystemLanguageFilter->__construct() Copy JROOT/libraries/cms/plugin/helper.php:2556 JPluginHelper::import() Copy JROOT/libraries/cms/plugin/helper.php:1705 JPluginHelper::importPlugin() Copy JROOT/libraries/cms/application/cms.php:7394 JApplicationCms->initialiseApp() Copy JROOT/libraries/cms/application/site.php:6903 JApplicationSite->initialiseApp() Copy JROOT/libraries/cms/application/site.php:2092 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:0.50 ms 最後のクエリの後:0.44 ms クエリメモリ:0.021 MB クエリ前のメモリ:8.106 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.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
# 発信者 ファイルと行番号 10 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:16829 JDatabaseDriver->loadObject() Copy JROOT/libraries/axslibs/language.php:1838 AxsLanguage::getSubdomainDefault() Copy JROOT/plugins/system/languagefilter/languagefilter.php:1037 PlgSystemLanguageFilter->__construct() Copy JROOT/libraries/cms/plugin/helper.php:2556 JPluginHelper::import() Copy JROOT/libraries/cms/plugin/helper.php:1705 JPluginHelper::importPlugin() Copy JROOT/libraries/cms/application/cms.php:7394 JApplicationCms->initialiseApp() Copy JROOT/libraries/cms/application/site.php:6903 JApplicationSite->initialiseApp() Copy JROOT/libraries/cms/application/site.php:2092 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:0.89 ms 最後のクエリの後:0.05 ms クエリメモリ:0.030 MB クエリ前のメモリ:8.113 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.05 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.06 ms preparing 0.02 ms executing 0.32 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 10 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:17219 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/joomla/language/helper.php:2078 JLanguageHelper::getInstalledLanguages() Copy JROOT/plugins/system/languagefilter/languagefilter.php:1137 PlgSystemLanguageFilter->__construct() Copy JROOT/libraries/cms/plugin/helper.php:2556 JPluginHelper::import() Copy JROOT/libraries/cms/plugin/helper.php:1705 JPluginHelper::importPlugin() Copy JROOT/libraries/cms/application/cms.php:7394 JApplicationCms->initialiseApp() Copy JROOT/libraries/cms/application/site.php:6903 JApplicationSite->initialiseApp() Copy JROOT/libraries/cms/application/site.php:2092 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:0.52 ms 最後のクエリの後:0.87 ms クエリメモリ:0.022 MB クエリ前のメモリ:8.245 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.05 ms Executing hook on transaction 0.01 ms starting 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.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
# 発信者 ファイルと行番号 13 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172112 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/axslibs/brands.php:29011 AxsBrands::getData() Copy JROOT/libraries/axslibs/brands.php:35510 AxsBrands::getBrandObject() Copy JROOT/libraries/axslibs/brands.php:559 AxsBrands::getBrand() Copy JROOT/plugins/system/axslibs/axslibs.php:358 plgSystemAxslibs->onAfterInitialise() Copy JROOT/libraries/joomla/event/event.php:707 JEvent->update() Copy JROOT/libraries/joomla/event/dispatcher.php:1606 JEventDispatcher->trigger() Copy JROOT/libraries/joomla/application/base.php:1065 JApplicationBase->triggerEvent() Copy JROOT/libraries/cms/application/cms.php:7404 JApplicationCms->initialiseApp() Copy JROOT/libraries/cms/application/site.php:6903 JApplicationSite->initialiseApp() Copy JROOT/libraries/cms/application/site.php:2092 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:0.59 ms 最後のクエリの後:0.04 ms クエリメモリ:0.030 MB クエリ前のメモリ:8.267 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.00 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.01 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.01 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.02 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 14 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172113 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/axslibs/language.php:34212 AxsLanguage::getPublishedLanguages() Copy JROOT/libraries/axslibs/language.php:25111 AxsLanguage::getCurrentLanguage() Copy JROOT/libraries/axslibs/brands.php:37110 AxsBrands::getBrandObject() Copy JROOT/libraries/axslibs/brands.php:559 AxsBrands::getBrand() Copy JROOT/plugins/system/axslibs/axslibs.php:358 plgSystemAxslibs->onAfterInitialise() Copy JROOT/libraries/joomla/event/event.php:707 JEvent->update() Copy JROOT/libraries/joomla/event/dispatcher.php:1606 JEventDispatcher->trigger() Copy JROOT/libraries/joomla/application/base.php:1065 JApplicationBase->triggerEvent() Copy JROOT/libraries/cms/application/cms.php:7404 JApplicationCms->initialiseApp() Copy JROOT/libraries/cms/application/site.php:6903 JApplicationSite->initialiseApp() Copy JROOT/libraries/cms/application/site.php:2092 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:0.52 ms 最後のクエリの後:1.07 ms クエリメモリ:0.021 MB クエリ前のメモリ:8.556 MB 返された行:1
SELECT * FROM `axs_homepage_templates` WHERE id= '1'クエリではEXPLAINは使用できません:SELECT * FROM `axs_homepage_templates` WHERE id='1'
Status Duration starting 0.04 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.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.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 12 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172111 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/axslibs/brands.php:38810 AxsBrands::getBrandObject() Copy JROOT/libraries/axslibs/brands.php:559 AxsBrands::getBrand() Copy JROOT/plugins/system/axslibs/axslibs.php:358 plgSystemAxslibs->onAfterInitialise() Copy JROOT/libraries/joomla/event/event.php:707 JEvent->update() Copy JROOT/libraries/joomla/event/dispatcher.php:1606 JEventDispatcher->trigger() Copy JROOT/libraries/joomla/application/base.php:1065 JApplicationBase->triggerEvent() Copy JROOT/libraries/cms/application/cms.php:7404 JApplicationCms->initialiseApp() Copy JROOT/libraries/cms/application/site.php:6903 JApplicationSite->initialiseApp() Copy JROOT/libraries/cms/application/site.php:2092 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:0.47 ms 最後のクエリの後:0.08 ms クエリメモリ:0.021 MB クエリ前のメモリ:8.597 MB 返された行:1
SELECT * FROM `axs_dashboard_templates` WHERE id= '2'クエリではEXPLAINは使用できません:SELECT * FROM `axs_dashboard_templates` WHERE id='2'
Status Duration starting 0.02 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.01 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.01 ms executing 0.01 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.00 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 12 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172111 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/axslibs/brands.php:40610 AxsBrands::getBrandObject() Copy JROOT/libraries/axslibs/brands.php:559 AxsBrands::getBrand() Copy JROOT/plugins/system/axslibs/axslibs.php:358 plgSystemAxslibs->onAfterInitialise() Copy JROOT/libraries/joomla/event/event.php:707 JEvent->update() Copy JROOT/libraries/joomla/event/dispatcher.php:1606 JEventDispatcher->trigger() Copy JROOT/libraries/joomla/application/base.php:1065 JApplicationBase->triggerEvent() Copy JROOT/libraries/cms/application/cms.php:7404 JApplicationCms->initialiseApp() Copy JROOT/libraries/cms/application/site.php:6903 JApplicationSite->initialiseApp() Copy JROOT/libraries/cms/application/site.php:2092 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:0.43 ms 最後のクエリの後:0.05 ms クエリメモリ:0.022 MB クエリ前のメモリ:8.617 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.00 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.01 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.01 ms executing 0.01 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.02 ms cleaning up 0.00 ms
# 発信者 ファイルと行番号 13 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:168212 JDatabaseDriver->loadObject() Copy JROOT/libraries/axslibs/brands.php:63211 AxsBrands::getEmailSettingsById() Copy JROOT/libraries/axslibs/brands.php:40910 AxsBrands::getBrandObject() Copy JROOT/libraries/axslibs/brands.php:559 AxsBrands::getBrand() Copy JROOT/plugins/system/axslibs/axslibs.php:358 plgSystemAxslibs->onAfterInitialise() Copy JROOT/libraries/joomla/event/event.php:707 JEvent->update() Copy JROOT/libraries/joomla/event/dispatcher.php:1606 JEventDispatcher->trigger() Copy JROOT/libraries/joomla/application/base.php:1065 JApplicationBase->triggerEvent() Copy JROOT/libraries/cms/application/cms.php:7404 JApplicationCms->initialiseApp() Copy JROOT/libraries/cms/application/site.php:6903 JApplicationSite->initialiseApp() Copy JROOT/libraries/cms/application/site.php:2092 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:0.44 ms 最後のクエリの後:0.04 ms クエリメモリ:0.022 MB クエリ前のメモリ:8.626 MB 返された行:1
SELECT *
FROM axs_payment_gateways
WHERE id = '1'クエリではEXPLAINは使用できません:SELECT *
FROM axs_payment_gateways
WHERE id = '1'
Status Duration starting 0.02 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.01 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.01 ms executing 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.02 ms cleaning up 0.00 ms
# 発信者 ファイルと行番号 13 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:168212 JDatabaseDriver->loadObject() Copy JROOT/libraries/axslibs/brands.php:58211 AxsBrands::getPaymentGatewayById() Copy JROOT/libraries/axslibs/brands.php:41210 AxsBrands::getBrandObject() Copy JROOT/libraries/axslibs/brands.php:559 AxsBrands::getBrand() Copy JROOT/plugins/system/axslibs/axslibs.php:358 plgSystemAxslibs->onAfterInitialise() Copy JROOT/libraries/joomla/event/event.php:707 JEvent->update() Copy JROOT/libraries/joomla/event/dispatcher.php:1606 JEventDispatcher->trigger() Copy JROOT/libraries/joomla/application/base.php:1065 JApplicationBase->triggerEvent() Copy JROOT/libraries/cms/application/cms.php:7404 JApplicationCms->initialiseApp() Copy JROOT/libraries/cms/application/site.php:6903 JApplicationSite->initialiseApp() Copy JROOT/libraries/cms/application/site.php:2092 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:0.45 ms 最後のクエリの後:0.06 ms クエリメモリ:0.022 MB クエリ前のメモリ:8.638 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.00 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.01 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.01 ms executing 0.01 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.02 ms cleaning up 0.00 ms
# 発信者 ファイルと行番号 13 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:168212 JDatabaseDriver->loadObject() Copy JROOT/libraries/axslibs/brands.php:65911 AxsBrands::getIntegrationById() Copy JROOT/libraries/axslibs/brands.php:41810 AxsBrands::getBrandObject() Copy JROOT/libraries/axslibs/brands.php:559 AxsBrands::getBrand() Copy JROOT/plugins/system/axslibs/axslibs.php:358 plgSystemAxslibs->onAfterInitialise() Copy JROOT/libraries/joomla/event/event.php:707 JEvent->update() Copy JROOT/libraries/joomla/event/dispatcher.php:1606 JEventDispatcher->trigger() Copy JROOT/libraries/joomla/application/base.php:1065 JApplicationBase->triggerEvent() Copy JROOT/libraries/cms/application/cms.php:7404 JApplicationCms->initialiseApp() Copy JROOT/libraries/cms/application/site.php:6903 JApplicationSite->initialiseApp() Copy JROOT/libraries/cms/application/site.php:2092 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:1.66 ms 最後のクエリの後:10.95 ms クエリメモリ:0.101 MB クエリ前のメモリ:10.349 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.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.07 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.08 ms preparing 0.04 ms executing 0.98 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.02 ms freeing items 0.02 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 22 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172121 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/cms/menu/site.php:8820 JMenuSite->{closure}() Copy JROOT/libraries/joomla/cache/controller/callback.php:16919 JCacheControllerCallback->get() Copy JROOT/libraries/cms/menu/site.php:9618 JMenuSite->load() Copy JROOT/libraries/cms/menu/menu.php:7417 JMenu->__construct() Copy JROOT/libraries/cms/menu/site.php:5716 JMenuSite->__construct() Copy JROOT/libraries/cms/menu/menu.php:12915 JMenu::getInstance() Copy JROOT/libraries/cms/application/cms.php:50014 JApplicationCms->getMenu() Copy JROOT/libraries/cms/application/site.php:27713 JApplicationSite->getMenu() Copy JROOT/libraries/cms/router/site.php:5912 JRouterSite->__construct() Copy JROOT/libraries/cms/router/router.php:19811 JRouter::getInstance() Copy JROOT/libraries/cms/application/cms.php:60510 JApplicationCms::getRouter() Copy JROOT/libraries/cms/application/site.php:4079 JApplicationSite::getRouter() Copy JROOT/plugins/system/languagefilter/languagefilter.php:1348 PlgSystemLanguageFilter->onAfterInitialise() Copy JROOT/libraries/joomla/event/event.php:707 JEvent->update() Copy JROOT/libraries/joomla/event/dispatcher.php:1606 JEventDispatcher->trigger() Copy JROOT/libraries/joomla/application/base.php:1065 JApplicationBase->triggerEvent() Copy JROOT/libraries/cms/application/cms.php:7404 JApplicationCms->initialiseApp() Copy JROOT/libraries/cms/application/site.php:6903 JApplicationSite->initialiseApp() Copy JROOT/libraries/cms/application/site.php:2092 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:1.82 ms 最後のクエリの後:13.10 ms クエリメモリ:0.028 MB クエリ前のメモリ:12.626 MB 返された行:17
SHOW FULL COLUMNS FROM `joom_users `クエリではEXPLAINは使用できません:SHOW FULL COLUMNS FROM `joom_users`
Status Duration starting 0.06 ms Executing hook on transaction 0.01 ms starting 0.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.08 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.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.03 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.05 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.05 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 20 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172119 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/joomla/database/driver/mysqli.php:42118 JDatabaseDriverMysqli->getTableColumns() Copy JROOT/libraries/joomla/table/table.php:24417 JTable->getFields() Copy JROOT/libraries/joomla/table/table.php:16316 JTable->__construct() Copy JROOT/libraries/joomla/table/user.php:3915 JTableUser->__construct() Copy JROOT/libraries/joomla/table/table.php:31114 JTable::getInstance() Copy JROOT/libraries/joomla/user/user.php:59813 JUser::getTable() Copy JROOT/libraries/joomla/user/user.php:78212 JUser->save() Copy JROOT/plugins/system/languagefilter/languagefilter.php:84811 PlgSystemLanguageFilter->setPreferredLanguage() Copy JROOT/plugins/system/languagefilter/languagefilter.php:51210 PlgSystemLanguageFilter->parseRule() Copy JROOT/libraries/cms/router/router.php:5979 JRouter->processParseRules() Copy JROOT/libraries/cms/router/site.php:5848 JRouterSite->processParseRules() Copy JROOT/libraries/cms/router/router.php:5717 JRouter->_processParseRules() Copy JROOT/libraries/cms/router/router.php:2256 JRouter->parse() Copy JROOT/libraries/cms/router/site.php:1335 JRouterSite->parse() Copy JROOT/libraries/cms/application/cms.php:12204 JApplicationCms->route() Copy JROOT/libraries/cms/application/site.php:8003 JApplicationSite->route() Copy JROOT/libraries/cms/application/site.php:2152 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:0.54 ms 最後のクエリの後:0.25 ms クエリメモリ:0.022 MB クエリ前のメモリ:12.670 MB 返された行:1
SELECT `id`,`title`
FROM `joom_usergroups `
WHERE `id` = 1クエリではEXPLAINは使用できません:SELECT `id`,`title`
FROM `joom_usergroups`
WHERE `id` = 1
Status Duration starting 0.04 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.01 ms executing 0.01 ms end 0.00 ms query end 0.01 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 15 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:152614 JDatabaseDriver->loadAssocList() Copy JROOT/libraries/joomla/table/user.php:15213 JTableUser->bind() Copy JROOT/libraries/joomla/user/user.php:78412 JUser->save() Copy JROOT/plugins/system/languagefilter/languagefilter.php:84811 PlgSystemLanguageFilter->setPreferredLanguage() Copy JROOT/plugins/system/languagefilter/languagefilter.php:51210 PlgSystemLanguageFilter->parseRule() Copy JROOT/libraries/cms/router/router.php:5979 JRouter->processParseRules() Copy JROOT/libraries/cms/router/site.php:5848 JRouterSite->processParseRules() Copy JROOT/libraries/cms/router/router.php:5717 JRouter->_processParseRules() Copy JROOT/libraries/cms/router/router.php:2256 JRouter->parse() Copy JROOT/libraries/cms/router/site.php:1335 JRouterSite->parse() Copy JROOT/libraries/cms/application/cms.php:12204 JApplicationCms->route() Copy JROOT/libraries/cms/application/site.php:8003 JApplicationSite->route() Copy JROOT/libraries/cms/application/site.php:2152 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:0.51 ms 最後のクエリの後:4.96 ms クエリメモリ:0.022 MB クエリ前のメモリ:13.475 MB 返された行:0
SELECT *
FROM joom_easyblog_configs
WHERE `name` = 'config'クエリではEXPLAINは使用できません:SELECT *
FROM joom_easyblog_configs
WHERE `name` = 'config'
Status Duration starting 0.04 ms Executing hook on transaction 0.00 ms starting 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.01 ms preparing 0.02 ms executing 0.02 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms
# 発信者 ファイルと行番号 14 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:148513 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:12204 JApplicationCms->route() Copy JROOT/libraries/cms/application/site.php:8003 JApplicationSite->route() Copy JROOT/libraries/cms/application/site.php:2152 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:1.72 ms 最後のクエリの後:0.11 ms クエリメモリ:0.023 MB クエリ前のメモリ:13.524 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.01 ms preparing 0.02 ms executing 1.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
# 発信者 ファイルと行番号 15 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:168214 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:12204 JApplicationCms->route() Copy JROOT/libraries/cms/application/site.php:8003 JApplicationSite->route() Copy JROOT/libraries/cms/application/site.php:2152 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:0.51 ms 最後のクエリの後:0.05 ms クエリメモリ:0.022 MB クエリ前のメモリ:13.504 MB 返された行:1
SELECT `id` FROM `joom_easyblog_users ` WHERE `permalink`= 'jimliriano'クエリではEXPLAINは使用できません:SELECT `id` FROM `joom_easyblog_users` WHERE `permalink`='jimliriano'
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.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.02 ms cleaning up 0.00 ms
# 発信者 ファイルと行番号 14 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:176013 JDatabaseDriver->loadResult() Copy JROOT/administrator/components/com_easyblog/includes/utils.php:23512 EasyBlogDbJoomla->__call() Copy JROOT/administrator/components/com_easyblog/includes/easyblog.php:219911 EB::getUserId() Copy JROOT/components/com_easyblog/router.php:58510 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:12204 JApplicationCms->route() Copy JROOT/libraries/cms/application/site.php:8003 JApplicationSite->route() Copy JROOT/libraries/cms/application/site.php:2152 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:0.51 ms 最後のクエリの後:6.72 ms クエリメモリ:0.019 MB クエリ前のメモリ:13.959 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.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.03 ms executing 0.01 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.02 ms cleaning up 0.00 ms
# 発信者 ファイルと行番号 7 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:16826 JDatabaseDriver->loadObject() Copy JROOT/libraries/axslibs/user.php:6735 AxsUser::getGlobalUserSettings() Copy JROOT/libraries/axslibs/security.php:354 AxsSecurity::getSettings() Copy JROOT/libraries/cms/application/cms.php:3773 JApplicationCms->checkUserRequireTwoFactor() Copy JROOT/libraries/cms/application/site.php:2312 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:0.54 ms 最後のクエリの後:2.00 ms クエリメモリ:0.019 MB クエリ前のメモリ:14.349 MB 返された行:1
SELECT *
FROM `joom_users `
WHERE `id` = 1621309クエリではEXPLAINは使用できません:SELECT *
FROM `joom_users`
WHERE `id` = 1621309
Status Duration starting 0.03 ms Executing hook on transaction 0.00 ms starting 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.01 ms executing 0.03 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.02 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 6 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:16825 JDatabaseDriver->loadObject() Copy JROOT/administrator/components/com_users/models/user.php:9924 UsersModelUser->getOtpConfig() Copy JROOT/libraries/cms/application/cms.php:3813 JApplicationCms->checkUserRequireTwoFactor() Copy JROOT/libraries/cms/application/site.php:2312 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:0.71 ms 最後のクエリの後:0.13 ms クエリメモリ:0.019 MB クエリ前のメモリ:14.362 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.05 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.07 ms preparing 0.03 ms executing 0.11 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms
# 発信者 ファイルと行番号 6 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:17215 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/cms/application/site.php:4904 JApplicationSite->getTemplate() Copy JROOT/libraries/cms/application/site.php:1653 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:0.58 ms 最後のクエリの後:2.67 ms クエリメモリ:0.006 MB クエリ前のメモリ:14.684 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.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.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.01 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:2651 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:0.50 ms 最後のクエリの後:0.02 ms クエリメモリ:0.022 MB クエリ前のメモリ:14.690 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.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.00 ms System lock 0.00 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:172112 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:2651 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:0.76 ms 最後のクエリの後:5.15 ms クエリメモリ:0.023 MB クエリ前のメモリ:15.788 MB 返された行:0
SELECT * FROM `joom_easyblog_post ` WHERE `publish_up`<= '2024-10-05 16:27:50' AND `published`= '2' AND `state`= '0' ORDER BY `id` LIMIT 5クエリではEXPLAINは使用できません:SELECT * FROM `joom_easyblog_post` WHERE `publish_up`<='2024-10-05 16:27:50' AND `published`='2' AND `state`='0' ORDER BY `id` LIMIT 5
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.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.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.03 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 13 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172112 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:2651 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:0.61 ms 最後のクエリの後:0.04 ms クエリメモリ:0.022 MB クエリ前のメモリ:15.801 MB 返された行:0
SELECT id, created_by FROM `joom_easyblog_post ` WHERE `publish_down` > `publish_up` AND `publish_down` <= '2024-10-05 16:27:50' 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` <= '2024-10-05 16:27:50' AND `publish_down` != '0000-00-00 00:00:00' AND `published` = '1' AND `state` = '0'
Status Duration starting 0.05 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.05 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.06 ms preparing 0.02 ms executing 0.03 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 13 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172112 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:2651 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:0.51 ms 最後のクエリの後:0.28 ms クエリメモリ:0.022 MB クエリ前のメモリ:15.839 MB 返された行:0
SELECT * FROM `joom_easyblog_uploader_tmp ` WHERE `created` <= DATE_SUB ('2024-10-05 16:27:50' , INTERVAL 120 MINUTE )クエリではEXPLAINは使用できません:SELECT * FROM `joom_easyblog_uploader_tmp` WHERE `created` <= DATE_SUB('2024-10-05 16:27:50' , INTERVAL 120 MINUTE)
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.04 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.01 ms executing 0.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.02 ms cleaning up 0.00 ms
# 発信者 ファイルと行番号 12 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:168211 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:2651 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:0.83 ms 最後のクエリの後:0.05 ms クエリメモリ:0.007 MB クエリ前のメモリ:15.852 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 ('2024-10-05 16:27:50', 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('2024-10-05 16:27:50', INTERVAL 3 DAY)
Status Duration starting 0.04 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.00 ms checking permissions 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.02 ms statistics 0.07 ms preparing 0.02 ms deleting from main table 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.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:2651 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:0.82 ms 最後のクエリの後:0.41 ms クエリメモリ:0.023 MB クエリ前のメモリ:15.931 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.05 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.00 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.05 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.02 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 15 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172114 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:2651 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:0.59 ms 最後のクエリの後:0.45 ms クエリメモリ:0.030 MB クエリ前のメモリ:15.983 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.03 ms Executing hook on transaction 0.01 ms starting 0.00 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.00 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.03 ms executing 0.08 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms
# 発信者 ファイルと行番号 13 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172112 JDatabaseDriver->loadObjectList() Copy JROOT/administrator/components/com_easyblog/includes/acl/acl.php:29811 EasyBlogAcl::getRules() Copy JROOT/administrator/components/com_easyblog/includes/acl/acl.php:3810 EasyBlogAcl::getRuleSet() Copy JROOT/administrator/components/com_easyblog/includes/easyblog.php:1419 EB::acl() Copy JROOT/components/com_easyblog/controllers/controller.php:228 EasyBlogController->__construct() Copy JROOT/libraries/legacy/controller/legacy.php:3017 JControllerLegacy::getInstance() Copy JROOT/components/com_easyblog/easyblog.php:406 require_once Copy JROOT/components/com_easyblog/easyblog.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:0.63 ms 最後のクエリの後:0.09 ms クエリメモリ:0.026 MB クエリ前のメモリ:16.014 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.03 ms Executing hook on transaction 0.01 ms starting 0.00 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.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
# 発信者 ファイルと行番号 13 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172112 JDatabaseDriver->loadObjectList() Copy JROOT/administrator/components/com_easyblog/includes/utils.php:23511 EasyBlogDbJoomla->__call() Copy JROOT/administrator/components/com_easyblog/includes/acl/acl.php:11210 EasyBlogAcl::getRuleSet() Copy JROOT/administrator/components/com_easyblog/includes/easyblog.php:1419 EB::acl() Copy JROOT/components/com_easyblog/controllers/controller.php:228 EasyBlogController->__construct() Copy JROOT/libraries/legacy/controller/legacy.php:3017 JControllerLegacy::getInstance() Copy JROOT/components/com_easyblog/easyblog.php:406 require_once Copy JROOT/components/com_easyblog/easyblog.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:1.14 ms 最後のクエリの後:1.63 ms クエリメモリ:0.030 MB クエリ前のメモリ:16.268 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.08 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.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.02 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 21 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172120 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:2651 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:1.60 ms 最後のクエリの後:1.05 ms クエリメモリ:0.024 MB クエリ前のメモリ:16.541 MB 返された行:0
SELECT `id` FROM `joom_menu ` WHERE ( `link` LIKE 'index.php?option= com_easyblog&view= blogger&layout= listings&id= 1621309%' OR `link` LIKE 'index.php?option= com_easyblog&view= blogger&layout= listings&id= 1621309%' ) 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=blogger&layout=listings&id=1621309%' OR `link` LIKE 'index.php?option=com_easyblog&view=blogger&layout=listings&id=1621309%' ) 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.01 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.07 ms preparing 0.03 ms executing 0.99 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:176017 JDatabaseDriver->loadResult() Copy JROOT/administrator/components/com_easyblog/includes/utils.php:23516 EasyBlogDbJoomla->__call() Copy JROOT/administrator/components/com_easyblog/models/menu.php:33815 EasyBlogModelMenu->getMenusByBloggerId() Copy JROOT/administrator/components/com_easyblog/includes/easyblog.php:466414 EB::getMenuParams() Copy JROOT/administrator/components/com_easyblog/includes/themes/themes.php:15313 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:2651 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:0.59 ms 最後のクエリの後:1.05 ms クエリメモリ:0.023 MB クエリ前のメモリ:16.638 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.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.05 ms preparing 0.01 ms executing 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.02 ms cleaning up 0.00 ms
# 発信者 ファイルと行番号 16 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172115 JDatabaseDriver->loadObjectList() Copy JROOT/administrator/components/com_easyblog/includes/utils.php:23514 EasyBlogDbJoomla->__call() Copy JROOT/administrator/components/com_easyblog/models/users.php:30013 EasyBlogModelUsers->getUsersMeta() Copy JROOT/administrator/components/com_easyblog/includes/user/user.php:19312 EasyBlogUser::loadUsers() Copy JROOT/administrator/components/com_easyblog/includes/user/user.php:8511 EasyBlogUser::factory() Copy JROOT/administrator/components/com_easyblog/includes/easyblog.php:89510 EB::user() Copy JROOT/components/com_easyblog/views/blogger/view.html.php:2089 EasyBlogViewBlogger->listings() Copy JROOT/components/com_easyblog/controllers/controller.php:1068 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:2651 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:0.51 ms 最後のクエリの後:0.47 ms クエリメモリ:0.025 MB クエリ前のメモリ:16.705 MB 返された行:1
SELECT *
FROM `joom_users `
WHERE `id` = 1621309クエリではEXPLAINは使用できません:SELECT *
FROM `joom_users`
WHERE `id` = 1621309
Status Duration starting 0.03 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.01 ms executing 0.01 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.02 ms cleaning up 0.00 ms
# 発信者 ファイルと行番号 19 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:148518 JDatabaseDriver->loadAssoc() Copy JROOT/libraries/joomla/table/user.php:8517 JTableUser->load() Copy JROOT/libraries/joomla/user/user.php:93616 JUser->load() Copy JROOT/libraries/joomla/user/user.php:24315 JUser->__construct() Copy JROOT/libraries/joomla/user/user.php:29614 JUser::getInstance() Copy JROOT/libraries/joomla/factory.php:26313 JFactory::getUser() Copy JROOT/administrator/components/com_easyblog/includes/user/user.php:23812 EasyBlogUser::loadUsers() Copy JROOT/administrator/components/com_easyblog/includes/user/user.php:8511 EasyBlogUser::factory() Copy JROOT/administrator/components/com_easyblog/includes/easyblog.php:89510 EB::user() Copy JROOT/components/com_easyblog/views/blogger/view.html.php:2089 EasyBlogViewBlogger->listings() Copy JROOT/components/com_easyblog/controllers/controller.php:1068 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:2651 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:0.60 ms 最後のクエリの後:1.75 ms クエリメモリ:0.025 MB クエリ前のメモリ:17.457 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.05 ms Executing hook on transaction 0.00 ms starting 0.01 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.01 ms statistics 0.07 ms preparing 0.02 ms executing 0.03 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.02 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 19 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:152618 JDatabaseDriver->loadAssocList() Copy JROOT/libraries/joomla/table/user.php:11017 JTableUser->load() Copy JROOT/libraries/joomla/user/user.php:93616 JUser->load() Copy JROOT/libraries/joomla/user/user.php:24315 JUser->__construct() Copy JROOT/libraries/joomla/user/user.php:29614 JUser::getInstance() Copy JROOT/libraries/joomla/factory.php:26313 JFactory::getUser() Copy JROOT/administrator/components/com_easyblog/includes/user/user.php:23812 EasyBlogUser::loadUsers() Copy JROOT/administrator/components/com_easyblog/includes/user/user.php:8511 EasyBlogUser::factory() Copy JROOT/administrator/components/com_easyblog/includes/easyblog.php:89510 EB::user() Copy JROOT/components/com_easyblog/views/blogger/view.html.php:2089 EasyBlogViewBlogger->listings() Copy JROOT/components/com_easyblog/controllers/controller.php:1068 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:2651 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:0.69 ms 最後のクエリの後:0.06 ms クエリメモリ:0.022 MB クエリ前のメモリ:17.465 MB 返された行:2
SELECT `group_id` FROM `joom_user_usergroup_map ` WHERE `user_id` = '1621309'クエリではEXPLAINは使用できません:SELECT `group_id` FROM `joom_user_usergroup_map` WHERE `user_id` = '1621309'
Status Duration starting 0.03 ms Executing hook on transaction 0.01 ms starting 0.00 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.00 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.05 ms preparing 0.01 ms executing 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.02 ms cleaning up 0.00 ms
# 発信者 ファイルと行番号 14 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:157013 JDatabaseDriver->loadColumn() Copy JROOT/administrator/components/com_easyblog/includes/utils.php:23512 EasyBlogDbJoomla->__call() Copy JROOT/administrator/components/com_easyblog/includes/acl/acl.php:6011 EasyBlogAcl::getRuleSet() Copy JROOT/administrator/components/com_easyblog/includes/easyblog.php:14110 EB::acl() Copy JROOT/components/com_easyblog/views/blogger/view.html.php:2169 EasyBlogViewBlogger->listings() Copy JROOT/components/com_easyblog/controllers/controller.php:1068 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:2651 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:0.87 ms 最後のクエリの後:0.02 ms クエリメモリ:0.031 MB クエリ前のメモリ:17.472 MB 返された行:80
SELECT * FROM `joom_easyblog_acl_group ` WHERE `content_id` IN (2, 32) AND `type`= ' group'クエリではEXPLAINは使用できません:SELECT * FROM `joom_easyblog_acl_group` WHERE `content_id` IN (2, 32) AND `type`='group'
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.06 ms preparing 0.02 ms executing 0.28 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.03 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 14 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172113 JDatabaseDriver->loadObjectList() Copy JROOT/administrator/components/com_easyblog/includes/utils.php:23512 EasyBlogDbJoomla->__call() Copy JROOT/administrator/components/com_easyblog/includes/acl/acl.php:7611 EasyBlogAcl::getRuleSet() Copy JROOT/administrator/components/com_easyblog/includes/easyblog.php:14110 EB::acl() Copy JROOT/components/com_easyblog/views/blogger/view.html.php:2169 EasyBlogViewBlogger->listings() Copy JROOT/components/com_easyblog/controllers/controller.php:1068 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:2651 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:0.52 ms 最後のクエリの後:0.27 ms クエリメモリ:0.022 MB クエリ前のメモリ:17.506 MB 返された行:0
SELECT *
FROM joom_easyblog_meta
WHERE `type` = 'blogger' AND `content_id` = '1621309'クエリではEXPLAINは使用できません:SELECT *
FROM joom_easyblog_meta
WHERE `type` = 'blogger' AND `content_id` = '1621309'
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.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.02 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 13 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:148512 JDatabaseDriver->loadAssoc() Copy JROOT/libraries/joomla/table/table.php:72911 JTable->load() Copy JROOT/administrator/components/com_easyblog/includes/easyblog.php:225810 EB::setMeta() Copy JROOT/components/com_easyblog/views/blogger/view.html.php:2209 EasyBlogViewBlogger->listings() Copy JROOT/components/com_easyblog/controllers/controller.php:1068 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:2651 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:0.59 ms 最後のクエリの後:3.09 ms クエリメモリ:0.022 MB クエリ前のメモリ:18.116 MB 返された行:1
SELECT *
FROM joom_easyblog_users
WHERE `id` = '1621309'クエリではEXPLAINは使用できません:SELECT *
FROM joom_easyblog_users
WHERE `id` = '1621309'
Status Duration starting 0.06 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.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.00 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
# 発信者 ファイルと行番号 14 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:148513 JDatabaseDriver->loadAssoc() Copy JROOT/libraries/joomla/table/table.php:72912 JTable->load() Copy JROOT/administrator/components/com_easyblog/tables/profile.php:16111 EasyBlogTableProfile->load() Copy JROOT/administrator/components/com_easyblog/includes/easyblog.php:228210 EB::setMeta() Copy JROOT/components/com_easyblog/views/blogger/view.html.php:2209 EasyBlogViewBlogger->listings() Copy JROOT/components/com_easyblog/controllers/controller.php:1068 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:2651 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:1.49 ms 最後のクエリの後:3.61 ms クエリメモリ:0.023 MB クエリ前のメモリ:19.306 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))))) ORDER BY a.`created` desc LIMIT 0,10クエリでは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))))) ORDER BY a.`created` desc LIMIT 0,10
Status Duration starting 0.16 ms Executing hook on transaction 0.01 ms starting 0.02 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.05 ms optimizing 0.01 ms statistics 0.04 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.02 ms executing 0.06 ms executing 0.05 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:172112 JDatabaseDriver->loadObjectList() Copy JROOT/administrator/components/com_easyblog/includes/utils.php:23511 EasyBlogDbJoomla->__call() Copy JROOT/administrator/components/com_easyblog/models/blog.php:77610 EasyBlogModelBlog->getBlogsBy() Copy JROOT/components/com_easyblog/views/blogger/view.html.php:2509 EasyBlogViewBlogger->listings() Copy JROOT/components/com_easyblog/controllers/controller.php:1068 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:2651 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:0.41 ms 最後のクエリの後:0.02 ms クエリメモリ:0.022 MB クエリ前のメモリ:19.319 MB 返された行:1
select FOUND_ROWS () クエリではEXPLAINは使用できません:select FOUND_ROWS()
Status Duration starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.00 ms optimizing 0.01 ms executing 0.01 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.01 ms cleaning up 0.00 ms
# 発信者 ファイルと行番号 13 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:176012 JDatabaseDriver->loadResult() Copy JROOT/administrator/components/com_easyblog/includes/utils.php:23511 EasyBlogDbJoomla->__call() Copy JROOT/administrator/components/com_easyblog/models/blog.php:78210 EasyBlogModelBlog->getBlogsBy() Copy JROOT/components/com_easyblog/views/blogger/view.html.php:2509 EasyBlogViewBlogger->listings() Copy JROOT/components/com_easyblog/controllers/controller.php:1068 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:2651 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:0.76 ms 最後のクエリの後:1.35 ms クエリメモリ:0.024 MB クエリ前のメモリ:19.503 MB 返された行:0
SELECT COUNT (1) as `voted`, `uid` FROM `joom_easyblog_ratings ` WHERE `uid` IN (3,2) AND `type`= 'entry' AND `created_by`= '0' AND (`sessionid` = 'f02c2s776fc2tvkt3d70dtj17u' OR `ip` = '10.7.52.206') GROUP BY `uid` ORDER BY NULL クエリではEXPLAINは使用できません:SELECT COUNT(1) as `voted`, `uid` FROM `joom_easyblog_ratings` WHERE `uid` IN (3,2) AND `type`='entry' AND `created_by`='0' AND (`sessionid` = 'f02c2s776fc2tvkt3d70dtj17u' OR `ip` = '10.7.52.206') GROUP BY `uid` ORDER BY NULL
Status Duration starting 0.06 ms Executing hook on transaction 0.01 ms starting 0.00 ms checking permissions 0.00 ms Opening tables 0.04 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.10 ms preparing 0.02 ms Creating tmp table 0.03 ms executing 0.07 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 18 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172117 JDatabaseDriver->loadObjectList() Copy JROOT/administrator/components/com_easyblog/includes/utils.php:23516 EasyBlogDbJoomla->__call() Copy JROOT/administrator/components/com_easyblog/models/ratings.php:13315 EasyBlogModelRatings->preloadUserPostRatings() Copy JROOT/administrator/components/com_easyblog/includes/cache/cache.php:33714 EasyBlogCache->cacheVoted() Copy JROOT/administrator/components/com_easyblog/includes/cache/cache.php:26113 EasyBlogCache->insert() Copy JROOT/administrator/components/com_easyblog/includes/formatter/types/list.php:3112 EasyBlogFormatterList->execute() Copy JROOT/administrator/components/com_easyblog/includes/formatter/formatter.php:5111 EasyBlogFormatter->execute() Copy JROOT/administrator/components/com_easyblog/includes/easyblog.php:430810 EB::formatter() Copy JROOT/components/com_easyblog/views/blogger/view.html.php:2549 EasyBlogViewBlogger->listings() Copy JROOT/components/com_easyblog/controllers/controller.php:1068 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:2651 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:0.60 ms 最後のクエリの後:0.03 ms クエリメモリ:0.024 MB クエリ前のメモリ:19.512 MB 返された行:0
SELECT AVG (`value`) AS `ratings` ,COUNT (1) AS `total` ,`uid` FROM `joom_easyblog_ratings ` AS a WHERE a.`uid` IN (3,2) AND `type`= 'entry' GROUP BY `uid` ORDER BY NULL クエリではEXPLAINは使用できません:SELECT AVG(`value`) AS `ratings` ,COUNT(1) AS `total` ,`uid` FROM `joom_easyblog_ratings` AS a WHERE a.`uid` IN(3,2) AND `type`='entry' GROUP BY `uid` ORDER BY NULL
Status Duration starting 0.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.04 ms executing 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.02 ms cleaning up 0.00 ms
# 発信者 ファイルと行番号 18 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172117 JDatabaseDriver->loadObjectList() Copy JROOT/administrator/components/com_easyblog/includes/utils.php:23516 EasyBlogDbJoomla->__call() Copy JROOT/administrator/components/com_easyblog/models/ratings.php:17415 EasyBlogModelRatings->preloadRatings() Copy JROOT/administrator/components/com_easyblog/includes/cache/cache.php:46114 EasyBlogCache->cacheRatings() Copy JROOT/administrator/components/com_easyblog/includes/cache/cache.php:26413 EasyBlogCache->insert() Copy JROOT/administrator/components/com_easyblog/includes/formatter/types/list.php:3112 EasyBlogFormatterList->execute() Copy JROOT/administrator/components/com_easyblog/includes/formatter/formatter.php:5111 EasyBlogFormatter->execute() Copy JROOT/administrator/components/com_easyblog/includes/easyblog.php:430810 EB::formatter() Copy JROOT/components/com_easyblog/views/blogger/view.html.php:2549 EasyBlogViewBlogger->listings() Copy JROOT/components/com_easyblog/controllers/controller.php:1068 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:2651 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:0.56 ms 最後のクエリの後:0.84 ms クエリメモリ:0.024 MB クエリ前のメモリ:19.662 MB 返された行:0
SELECT a.* FROM `joom_easyblog_comment ` AS a WHERE a.`post_id` IN (3,2) AND a.`published`= '1'クエリではEXPLAINは使用できません:SELECT a.* FROM `joom_easyblog_comment` AS a WHERE a.`post_id` IN(3,2) AND a.`published`='1'
Status Duration starting 0.03 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.01 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.02 ms executing 0.03 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.02 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 18 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172117 JDatabaseDriver->loadObjectList() Copy JROOT/administrator/components/com_easyblog/includes/utils.php:23516 EasyBlogDbJoomla->__call() Copy JROOT/administrator/components/com_easyblog/models/comment.php:57415 EasyBlogModelComment->preloadComments() Copy JROOT/administrator/components/com_easyblog/includes/cache/cache.php:49314 EasyBlogCache->cacheComments() Copy JROOT/administrator/components/com_easyblog/includes/cache/cache.php:26713 EasyBlogCache->insert() Copy JROOT/administrator/components/com_easyblog/includes/formatter/types/list.php:3112 EasyBlogFormatterList->execute() Copy JROOT/administrator/components/com_easyblog/includes/formatter/formatter.php:5111 EasyBlogFormatter->execute() Copy JROOT/administrator/components/com_easyblog/includes/easyblog.php:430810 EB::formatter() Copy JROOT/components/com_easyblog/views/blogger/view.html.php:2549 EasyBlogViewBlogger->listings() Copy JROOT/components/com_easyblog/controllers/controller.php:1068 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:2651 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:0.51 ms 最後のクエリの後:0.04 ms クエリメモリ:0.024 MB クエリ前のメモリ:19.672 MB 返された行:0
SELECT a.`post_id`, COUNT (1) AS `count` FROM `joom_easyblog_comment ` AS a WHERE a.`post_id` IN (3,2) AND a.`published`= '1' GROUP BY a.`post_id`クエリではEXPLAINは使用できません:SELECT a.`post_id`, COUNT(1) AS `count` FROM `joom_easyblog_comment` AS a WHERE a.`post_id` IN(3,2) AND a.`published`='1' GROUP BY a.`post_id`
Status Duration starting 0.04 ms Executing hook on transaction 0.01 ms starting 0.00 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.01 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.02 ms executing 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.02 ms cleaning up 0.00 ms
# 発信者 ファイルと行番号 18 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172117 JDatabaseDriver->loadObjectList() Copy JROOT/administrator/components/com_easyblog/includes/utils.php:23516 EasyBlogDbJoomla->__call() Copy JROOT/administrator/components/com_easyblog/models/comment.php:61815 EasyBlogModelComment->preloadCommentCount() Copy JROOT/administrator/components/com_easyblog/includes/cache/cache.php:51914 EasyBlogCache->cacheCommentCount() Copy JROOT/administrator/components/com_easyblog/includes/cache/cache.php:27013 EasyBlogCache->insert() Copy JROOT/administrator/components/com_easyblog/includes/formatter/types/list.php:3112 EasyBlogFormatterList->execute() Copy JROOT/administrator/components/com_easyblog/includes/formatter/formatter.php:5111 EasyBlogFormatter->execute() Copy JROOT/administrator/components/com_easyblog/includes/easyblog.php:430810 EB::formatter() Copy JROOT/components/com_easyblog/views/blogger/view.html.php:2549 EasyBlogViewBlogger->listings() Copy JROOT/components/com_easyblog/controllers/controller.php:1068 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:2651 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:0.81 ms 最後のクエリの後:1.00 ms クエリメモリ:0.025 MB クエリ前のメモリ:19.839 MB 返された行:2
select a.* , b.`post_id`, b.`primary` from `joom_easyblog_category ` as a inner join `joom_easyblog_post_category ` as b on a.`id` = b.`category_id` where b.`post_id` IN ( 3,2) クエリではEXPLAINは使用できません:select a.*, b.`post_id`, b.`primary` from `joom_easyblog_category` as a inner join `joom_easyblog_post_category` as b on a.`id` = b.`category_id` where b.`post_id` IN ( 3,2)
Status Duration starting 0.04 ms Executing hook on transaction 0.00 ms starting 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.06 ms preparing 0.16 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.02 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 18 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172117 JDatabaseDriver->loadObjectList() Copy JROOT/administrator/components/com_easyblog/includes/utils.php:23516 EasyBlogDbJoomla->__call() Copy JROOT/administrator/components/com_easyblog/models/category.php:139115 EasyBlogModelCategory->preloadByPosts() Copy JROOT/administrator/components/com_easyblog/includes/cache/cache.php:60014 EasyBlogCache->cacheCategories() Copy JROOT/administrator/components/com_easyblog/includes/cache/cache.php:27313 EasyBlogCache->insert() Copy JROOT/administrator/components/com_easyblog/includes/formatter/types/list.php:3112 EasyBlogFormatterList->execute() Copy JROOT/administrator/components/com_easyblog/includes/formatter/formatter.php:5111 EasyBlogFormatter->execute() Copy JROOT/administrator/components/com_easyblog/includes/easyblog.php:430810 EB::formatter() Copy JROOT/components/com_easyblog/views/blogger/view.html.php:2549 EasyBlogViewBlogger->listings() Copy JROOT/components/com_easyblog/controllers/controller.php:1068 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:2651 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:0.56 ms 最後のクエリの後:1.25 ms クエリメモリ:0.024 MB クエリ前のメモリ:20.127 MB 返された行:0
select a.* , b.`post_id` from `joom_easyblog_tag ` as a inner join `joom_easyblog_post_tag ` as b on a.`id` = b.`tag_id` where b.`post_id` IN ( 3,2) クエリではEXPLAINは使用できません:select a.*, b.`post_id` from `joom_easyblog_tag` as a inner join `joom_easyblog_post_tag` as b on a.`id` = b.`tag_id` where b.`post_id` IN ( 3,2)
Status Duration starting 0.04 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:172117 JDatabaseDriver->loadObjectList() Copy JROOT/administrator/components/com_easyblog/includes/utils.php:23516 EasyBlogDbJoomla->__call() Copy JROOT/administrator/components/com_easyblog/models/tags.php:83215 EasyBlogModelTags->preloadByPosts() Copy JROOT/administrator/components/com_easyblog/includes/cache/cache.php:66714 EasyBlogCache->cacheTags() Copy JROOT/administrator/components/com_easyblog/includes/cache/cache.php:27613 EasyBlogCache->insert() Copy JROOT/administrator/components/com_easyblog/includes/formatter/types/list.php:3112 EasyBlogFormatterList->execute() Copy JROOT/administrator/components/com_easyblog/includes/formatter/formatter.php:5111 EasyBlogFormatter->execute() Copy JROOT/administrator/components/com_easyblog/includes/easyblog.php:430810 EB::formatter() Copy JROOT/components/com_easyblog/views/blogger/view.html.php:2549 EasyBlogViewBlogger->listings() Copy JROOT/components/com_easyblog/controllers/controller.php:1068 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:2651 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:0.67 ms 最後のクエリの後:0.41 ms クエリメモリ:0.025 MB クエリ前のメモリ:20.204 MB 返された行:2
select a.* from `joom_easyblog_revisions ` as a where a.`id` IN ( 14,13) クエリではEXPLAINは使用できません:select a.* from `joom_easyblog_revisions` as a where a.`id` IN ( 14,13)
Status Duration starting 0.03 ms Executing hook on transaction 0.00 ms starting 0.00 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.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
# 発信者 ファイルと行番号 18 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172117 JDatabaseDriver->loadObjectList() Copy JROOT/administrator/components/com_easyblog/includes/utils.php:23516 EasyBlogDbJoomla->__call() Copy JROOT/administrator/components/com_easyblog/models/revisions.php:55815 EasyBlogModelRevisions->preload() Copy JROOT/administrator/components/com_easyblog/includes/cache/cache.php:57614 EasyBlogCache->cacheRevisions() Copy JROOT/administrator/components/com_easyblog/includes/cache/cache.php:27913 EasyBlogCache->insert() Copy JROOT/administrator/components/com_easyblog/includes/formatter/types/list.php:3112 EasyBlogFormatterList->execute() Copy JROOT/administrator/components/com_easyblog/includes/formatter/formatter.php:5111 EasyBlogFormatter->execute() Copy JROOT/administrator/components/com_easyblog/includes/easyblog.php:430810 EB::formatter() Copy JROOT/components/com_easyblog/views/blogger/view.html.php:2549 EasyBlogViewBlogger->listings() Copy JROOT/components/com_easyblog/controllers/controller.php:1068 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:2651 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:0.80 ms 最後のクエリの後:0.62 ms クエリメモリ:0.024 MB クエリ前のメモリ:20.305 MB 返された行:0
select `a`.`id` as `cat_fg_id`, `a`.`category_id` as `cat_fg_category_id`, `a`.`group_id` as `cat_fg_group_id`, `fg`.`id` as `fg_id`, `fg`.`title` as `fg_title`, `fg`.`description` as `fg_description`, `fg`.`created` as `fg_created`, `fg`.`state` as `fg_state`, `fg`.`read` as `fg_read`, `fg`.`write` as `fg_write`, `fg`.`params` as `fg_params`, `f`.`id` as `f_id`, `f`.`group_id` as `f_group_id`, `f`.`title` as `f_title`, `f`.`help` as `f_help`, `f`.`state` as `f_state`, `f`.`required` as `f_required`, `f`.`type` as `f_type`, `f`.`params` as `f_params`, `f`.`created` as `f_created`, `f`.`options` as `f_options`, `fv`.`id` as `fv_id`, `fv`.`field_id` as `fv_field_id`, `fv`.`post_id` as `fv_post_id`, `fv`.`value` as `fv_value` from `joom_easyblog_category_fields_groups ` as a inner join `joom_easyblog_post_category ` as p on `a`.`category_id` = `p`.`category_id` inner join `joom_easyblog_fields_groups ` as fg on `a`.`group_id` = `fg`.`id` inner join `joom_easyblog_fields ` as f on `fg`.`id` = `f`.`group_id` left join `joom_easyblog_fields_values ` as fv on `fv`.`field_id` = `f`.`id` and `fv`.`post_id` = `p`.`post_id` where p.post_id IN (3,2) クエリではEXPLAINは使用できません:select `a`.`id` as `cat_fg_id`, `a`.`category_id` as `cat_fg_category_id`, `a`.`group_id` as `cat_fg_group_id`, `fg`.`id` as `fg_id`, `fg`.`title` as `fg_title`, `fg`.`description` as `fg_description`, `fg`.`created` as `fg_created`, `fg`.`state` as `fg_state`, `fg`.`read` as `fg_read`, `fg`.`write` as `fg_write`, `fg`.`params` as `fg_params`, `f`.`id` as `f_id`, `f`.`group_id` as `f_group_id`, `f`.`title` as `f_title`, `f`.`help` as `f_help`, `f`.`state` as `f_state`, `f`.`required` as `f_required`, `f`.`type` as `f_type`, `f`.`params` as `f_params`, `f`.`created` as `f_created`, `f`.`options` as `f_options`, `fv`.`id` as `fv_id`, `fv`.`field_id` as `fv_field_id`, `fv`.`post_id` as `fv_post_id`, `fv`.`value` as `fv_value` from `joom_easyblog_category_fields_groups` as a inner join `joom_easyblog_post_category` as p on `a`.`category_id` = `p`.`category_id` inner join `joom_easyblog_fields_groups` as fg on `a`.`group_id` = `fg`.`id` inner join `joom_easyblog_fields` as f on `fg`.`id` = `f`.`group_id` left join `joom_easyblog_fields_values` as fv on `fv`.`field_id` = `f`.`id` and `fv`.`post_id` = `p`.`post_id` where p.post_id IN (3,2)
Status Duration starting 0.08 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.06 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.09 ms preparing 0.09 ms executing 0.04 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 18 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172117 JDatabaseDriver->loadObjectList() Copy JROOT/administrator/components/com_easyblog/includes/utils.php:23516 EasyBlogDbJoomla->__call() Copy JROOT/administrator/components/com_easyblog/models/fields.php:29815 EasyBlogModelFields->preloadFields() Copy JROOT/administrator/components/com_easyblog/includes/cache/cache.php:37414 EasyBlogCache->cacheFields() Copy JROOT/administrator/components/com_easyblog/includes/cache/cache.php:28513 EasyBlogCache->insert() Copy JROOT/administrator/components/com_easyblog/includes/formatter/types/list.php:3112 EasyBlogFormatterList->execute() Copy JROOT/administrator/components/com_easyblog/includes/formatter/formatter.php:5111 EasyBlogFormatter->execute() Copy JROOT/administrator/components/com_easyblog/includes/easyblog.php:430810 EB::formatter() Copy JROOT/components/com_easyblog/views/blogger/view.html.php:2549 EasyBlogViewBlogger->listings() Copy JROOT/components/com_easyblog/controllers/controller.php:1068 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:2651 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:0.53 ms 最後のクエリの後:0.30 ms クエリメモリ:0.025 MB クエリ前のメモリ:20.360 MB 返された行:2
select * from `joom_easyblog_meta ` where `content_id` in (3,2) and `type` = 'post' クエリではEXPLAINは使用できません:select * from `joom_easyblog_meta` where `content_id` in (3,2) and `type` = 'post'
Status Duration starting 0.03 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.02 ms executing 0.03 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.03 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 18 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172117 JDatabaseDriver->loadObjectList() Copy JROOT/administrator/components/com_easyblog/includes/utils.php:23516 EasyBlogDbJoomla->__call() Copy JROOT/administrator/components/com_easyblog/models/metas.php:38615 EasyBlogModelMetas->preloadPostMetas() Copy JROOT/administrator/components/com_easyblog/includes/cache/cache.php:30314 EasyBlogCache->cacheMetas() Copy JROOT/administrator/components/com_easyblog/includes/cache/cache.php:28813 EasyBlogCache->insert() Copy JROOT/administrator/components/com_easyblog/includes/formatter/types/list.php:3112 EasyBlogFormatterList->execute() Copy JROOT/administrator/components/com_easyblog/includes/formatter/formatter.php:5111 EasyBlogFormatter->execute() Copy JROOT/administrator/components/com_easyblog/includes/easyblog.php:430810 EB::formatter() Copy JROOT/components/com_easyblog/views/blogger/view.html.php:2549 EasyBlogViewBlogger->listings() Copy JROOT/components/com_easyblog/controllers/controller.php:1068 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:2651 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:0.49 ms 最後のクエリの後:0.87 ms クエリメモリ:0.024 MB クエリ前のメモリ:20.516 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.02 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.01 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.01 ms executing 0.01 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.02 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 18 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:176017 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/list.php:7112 EasyBlogFormatterList->execute() Copy JROOT/administrator/components/com_easyblog/includes/formatter/formatter.php:5111 EasyBlogFormatter->execute() Copy JROOT/administrator/components/com_easyblog/includes/easyblog.php:430810 EB::formatter() Copy JROOT/components/com_easyblog/views/blogger/view.html.php:2549 EasyBlogViewBlogger->listings() Copy JROOT/components/com_easyblog/controllers/controller.php:1068 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:2651 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:0.55 ms 最後のクエリの後:0.16 ms クエリメモリ:0.024 MB クエリ前のメモリ:20.539 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.03 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.04 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
# 発信者 ファイルと行番号 18 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172117 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/list.php:7112 EasyBlogFormatterList->execute() Copy JROOT/administrator/components/com_easyblog/includes/formatter/formatter.php:5111 EasyBlogFormatter->execute() Copy JROOT/administrator/components/com_easyblog/includes/easyblog.php:430810 EB::formatter() Copy JROOT/components/com_easyblog/views/blogger/view.html.php:2549 EasyBlogViewBlogger->listings() Copy JROOT/components/com_easyblog/controllers/controller.php:1068 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:2651 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:0.55 ms 最後のクエリの後:0.84 ms クエリメモリ:0.022 MB クエリ前のメモリ:20.637 MB 返された行:0
SELECT `id` FROM `joom_easyblog_subscriptions ` WHERE `uid` = '1621309' AND `utype` = 'blogger' AND `email` = ''クエリではEXPLAINは使用できません:SELECT `id` FROM `joom_easyblog_subscriptions` WHERE `uid` = '1621309' AND `utype` = 'blogger' AND `email` = ''
Status Duration starting 0.03 ms Executing hook on transaction 0.01 ms starting 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
# 発信者 ファイルと行番号 13 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:176012 JDatabaseDriver->loadResult() Copy JROOT/administrator/components/com_easyblog/includes/utils.php:23511 EasyBlogDbJoomla->__call() Copy JROOT/administrator/components/com_easyblog/models/blogger.php:20410 EasyBlogModelBlogger->isBloggerSubscribedEmail() Copy JROOT/components/com_easyblog/views/blogger/view.html.php:2659 EasyBlogViewBlogger->listings() Copy JROOT/components/com_easyblog/controllers/controller.php:1068 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:2651 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:0.54 ms 最後のクエリの後:9.07 ms クエリメモリ:0.024 MB クエリ前のメモリ:21.709 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.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.00 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.01 ms executing 0.03 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.02 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 17 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:176016 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/blogger/view.html.php:2799 EasyBlogViewBlogger->listings() Copy JROOT/components/com_easyblog/controllers/controller.php:1068 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:2651 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:0.56 ms 最後のクエリの後:1.06 ms クエリメモリ:0.024 MB クエリ前のメモリ:21.864 MB 返された行:1
SELECT COUNT (1) FROM `joom_easyblog_featured ` WHERE `content_id`= '1621309' AND `type`= 'blogger'クエリではEXPLAINは使用できません:SELECT COUNT(1) FROM `joom_easyblog_featured` WHERE `content_id`='1621309' AND `type`='blogger'
Status Duration starting 0.05 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.02 ms executing 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.02 ms cleaning up 0.00 ms
# 発信者 ファイルと行番号 17 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:176016 JDatabaseDriver->loadResult() Copy JROOT/administrator/components/com_easyblog/includes/utils.php:23515 EasyBlogDbJoomla->__call() Copy JROOT/administrator/components/com_easyblog/models/featured.php:17214 EasyBlogModelFeatured->isFeatured() Copy JROOT/administrator/components/com_easyblog/tables/profile.php:40913 EasyBlogTableProfile->isFeatured() Copy JROOT/components/com_easyblog/themes/wireframe/authors/item.php:3512 include Copy JROOT/components/com_easyblog/themes/wireframe/authors/item.php Copy JROOT/administrator/components/com_easyblog/includes/themes/themes.php:44511 EasyBlogThemes->output() Copy JROOT/components/com_easyblog/views/views.php:16410 EasyBlogView->display() Copy JROOT/components/com_easyblog/views/blogger/view.html.php:2799 EasyBlogViewBlogger->listings() Copy JROOT/components/com_easyblog/controllers/controller.php:1068 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:2651 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:0.51 ms 最後のクエリの後:0.25 ms クエリメモリ:0.024 MB クエリ前のメモリ:21.904 MB 返された行:0
SELECT * FROM `joom_easyblog_oauth ` WHERE `user_id`= '1621309' AND `type`= 'twitter' LIMIT 1クエリではEXPLAINは使用できません:SELECT * FROM `joom_easyblog_oauth` WHERE `user_id`='1621309' AND `type`='twitter' LIMIT 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.00 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.01 ms executing 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.02 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 17 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:168216 JDatabaseDriver->loadObject() Copy JROOT/administrator/components/com_easyblog/includes/utils.php:23515 EasyBlogDbJoomla->__call() Copy JROOT/administrator/components/com_easyblog/tables/oauth.php:7314 EasyBlogTableOauth->loadByUser() Copy JROOT/administrator/components/com_easyblog/tables/profile.php:38413 EasyBlogTableProfile->getTwitterLink() Copy JROOT/components/com_easyblog/themes/wireframe/authors/item.php:4212 include Copy JROOT/components/com_easyblog/themes/wireframe/authors/item.php Copy JROOT/administrator/components/com_easyblog/includes/themes/themes.php:44511 EasyBlogThemes->output() Copy JROOT/components/com_easyblog/views/views.php:16410 EasyBlogView->display() Copy JROOT/components/com_easyblog/views/blogger/view.html.php:2799 EasyBlogViewBlogger->listings() Copy JROOT/components/com_easyblog/controllers/controller.php:1068 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:2651 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:1.52 ms 最後のクエリの後:1.54 ms クエリメモリ:0.027 MB クエリ前のメモリ:22.112 MB 返された行:2
SHOW FULL COLUMNS FROM `joom_community_config `クエリではEXPLAINは使用できません:SHOW FULL COLUMNS FROM `joom_community_config`
Status Duration starting 0.07 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.52 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.09 ms preparing 0.04 ms Creating tmp table 0.06 ms executing 0.08 ms checking permissions 0.06 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 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.05 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 24 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172123 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/joomla/database/driver/mysqli.php:42122 JDatabaseDriverMysqli->getTableColumns() Copy JROOT/libraries/joomla/table/table.php:24421 JTable->getFields() Copy JROOT/libraries/joomla/table/table.php:16320 JTable->__construct() Copy JROOT/administrator/components/com_community/tables/configuration.php:2219 CommunityTableConfiguration->__construct() Copy JROOT/libraries/joomla/table/table.php:31118 JTable::getInstance() Copy JROOT/components/com_community/libraries/core.php:105717 CConfig::getInstance() Copy JROOT/components/com_community/libraries/core.php:23716 CFactory::getConfig() Copy JROOT/components/com_community/libraries/messaging.php:2215 CMessaging::load() Copy JROOT/administrator/components/com_easyblog/includes/jomsocial/jomsocial.php:5114 EasyBlogJomSocial->getMessagingHtml() Copy JROOT/administrator/components/com_easyblog/includes/messaging/messaging.php:6313 EasyBlogMessaging->html() Copy JROOT/components/com_easyblog/themes/wireframe/authors/item.php:6412 include Copy JROOT/components/com_easyblog/themes/wireframe/authors/item.php Copy JROOT/administrator/components/com_easyblog/includes/themes/themes.php:44511 EasyBlogThemes->output() Copy JROOT/components/com_easyblog/views/views.php:16410 EasyBlogView->display() Copy JROOT/components/com_easyblog/views/blogger/view.html.php:2799 EasyBlogViewBlogger->listings() Copy JROOT/components/com_easyblog/controllers/controller.php:1068 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:2651 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:0.68 ms 最後のクエリの後:0.05 ms クエリメモリ:0.025 MB クエリ前のメモリ:22.128 MB 返された行:1
SELECT *
FROM joom_community_config
WHERE `name` = 'config'クエリではEXPLAINは使用できません:SELECT *
FROM joom_community_config
WHERE `name` = 'config'
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.03 ms preparing 0.01 ms executing 0.01 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.02 ms cleaning up 0.00 ms
# 発信者 ファイルと行番号 20 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:148519 JDatabaseDriver->loadAssoc() Copy JROOT/libraries/joomla/table/table.php:72918 JTable->load() Copy JROOT/components/com_community/libraries/core.php:105817 CConfig::getInstance() Copy JROOT/components/com_community/libraries/core.php:23716 CFactory::getConfig() Copy JROOT/components/com_community/libraries/messaging.php:2215 CMessaging::load() Copy JROOT/administrator/components/com_easyblog/includes/jomsocial/jomsocial.php:5114 EasyBlogJomSocial->getMessagingHtml() Copy JROOT/administrator/components/com_easyblog/includes/messaging/messaging.php:6313 EasyBlogMessaging->html() Copy JROOT/components/com_easyblog/themes/wireframe/authors/item.php:6412 include Copy JROOT/components/com_easyblog/themes/wireframe/authors/item.php Copy JROOT/administrator/components/com_easyblog/includes/themes/themes.php:44511 EasyBlogThemes->output() Copy JROOT/components/com_easyblog/views/views.php:16410 EasyBlogView->display() Copy JROOT/components/com_easyblog/views/blogger/view.html.php:2799 EasyBlogViewBlogger->listings() Copy JROOT/components/com_easyblog/controllers/controller.php:1068 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:2651 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:0.63 ms 最後のクエリの後:3.13 ms クエリメモリ:0.032 MB クエリ前のメモリ:22.626 MB 返された行:0
SELECT `id` FROM `joom_users ` WHERE id= '0'クエリではEXPLAINは使用できません:SELECT `id` FROM `joom_users` WHERE id='0'
Status Duration starting 0.03 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.00 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.03 ms executing 0.01 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.02 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 23 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:176022 JDatabaseDriver->loadResult() Copy JROOT/components/com_community/libraries/core.php:19021 CFactory::getUser() Copy JROOT/components/com_community/libraries/assets.php:9320 CAssets->_init() Copy JROOT/components/com_community/libraries/assets.php:2819 CAssets->__construct() Copy JROOT/components/com_community/libraries/assets.php:4018 CAssets::getInstance() Copy JROOT/components/com_community/libraries/core.php:101917 CFactory::attach() Copy JROOT/components/com_community/libraries/template.php:34216 CTemplate::addStylesheet() Copy JROOT/components/com_community/libraries/messaging.php:3115 CMessaging::load() Copy JROOT/administrator/components/com_easyblog/includes/jomsocial/jomsocial.php:5114 EasyBlogJomSocial->getMessagingHtml() Copy JROOT/administrator/components/com_easyblog/includes/messaging/messaging.php:6313 EasyBlogMessaging->html() Copy JROOT/components/com_easyblog/themes/wireframe/authors/item.php:6412 include Copy JROOT/components/com_easyblog/themes/wireframe/authors/item.php Copy JROOT/administrator/components/com_easyblog/includes/themes/themes.php:44511 EasyBlogThemes->output() Copy JROOT/components/com_easyblog/views/views.php:16410 EasyBlogView->display() Copy JROOT/components/com_easyblog/views/blogger/view.html.php:2799 EasyBlogViewBlogger->listings() Copy JROOT/components/com_easyblog/controllers/controller.php:1068 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:2651 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:0.60 ms 最後のクエリの後:1.18 ms クエリメモリ:0.027 MB クエリ前のメモリ:22.864 MB 返された行:0
SELECT a.`userid` as _userid , a.`status` as _status , a.`points` as _points, a.`posted_on` as _posted_on, a.`avatar` as _avatar , a.`cover` as _cover , a.`thumb` as _thumb , a.`invite` as _invite, a.`params` as _cparams, a.`view` as _view, a.`friends` as _friends, a.`groups` as _groups, a.`events` as _events, a.`friendcount` as _friendcount, a.`alias` as _alias, a.`profile_id` as _profile_id, a.`storage` as _storage, a.`watermark_hash` as _watermark_hash, a.`search_email` as _search_email, s.`userid` as _isonline, u.* FROM `joom_community_users ` as a LEFT JOIN `joom_users ` u ON u.`id`= a.`userid` LEFT OUTER JOIN `joom_session ` s ON s.`userid`= a.`userid` AND s.`client_id` != '1' WHERE a.`userid`= '0'クエリではEXPLAINは使用できません:SELECT a.`userid` as _userid , a.`status` as _status , a.`points` as _points, a.`posted_on` as _posted_on, a.`avatar` as _avatar , a.`cover` as _cover , a.`thumb` as _thumb , a.`invite` as _invite, a.`params` as _cparams, a.`view` as _view, a.`friends` as _friends, a.`groups` as _groups, a.`events` as _events, a.`friendcount` as _friendcount, a.`alias` as _alias, a.`profile_id` as _profile_id, a.`storage` as _storage, a.`watermark_hash` as _watermark_hash, a.`search_email` as _search_email, s.`userid` as _isonline, u.* FROM `joom_community_users` as a LEFT JOIN `joom_users` u ON u.`id`=a.`userid` LEFT OUTER JOIN `joom_session` s ON s.`userid`=a.`userid` AND s.`client_id` !='1' WHERE a.`userid`='0'
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 Opening tables 0.05 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.04 ms executing 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.02 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 24 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:168223 JDatabaseDriver->loadObject() Copy JROOT/components/com_community/libraries/user.php:16822 CUser->init() Copy JROOT/components/com_community/libraries/core.php:20121 CFactory::getUser() Copy JROOT/components/com_community/libraries/assets.php:9320 CAssets->_init() Copy JROOT/components/com_community/libraries/assets.php:2819 CAssets->__construct() Copy JROOT/components/com_community/libraries/assets.php:4018 CAssets::getInstance() Copy JROOT/components/com_community/libraries/core.php:101917 CFactory::attach() Copy JROOT/components/com_community/libraries/template.php:34216 CTemplate::addStylesheet() Copy JROOT/components/com_community/libraries/messaging.php:3115 CMessaging::load() Copy JROOT/administrator/components/com_easyblog/includes/jomsocial/jomsocial.php:5114 EasyBlogJomSocial->getMessagingHtml() Copy JROOT/administrator/components/com_easyblog/includes/messaging/messaging.php:6313 EasyBlogMessaging->html() Copy JROOT/components/com_easyblog/themes/wireframe/authors/item.php:6412 include Copy JROOT/components/com_easyblog/themes/wireframe/authors/item.php Copy JROOT/administrator/components/com_easyblog/includes/themes/themes.php:44511 EasyBlogThemes->output() Copy JROOT/components/com_easyblog/views/views.php:16410 EasyBlogView->display() Copy JROOT/components/com_easyblog/views/blogger/view.html.php:2799 EasyBlogViewBlogger->listings() Copy JROOT/components/com_easyblog/controllers/controller.php:1068 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:2651 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:1.63 ms 最後のクエリの後:0.30 ms クエリメモリ:0.031 MB クエリ前のメモリ:22.913 MB 返された行:15
SHOW FULL COLUMNS FROM `joom_community_profiles `クエリではEXPLAINは使用できません:SHOW FULL COLUMNS FROM `joom_community_profiles`
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.44 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.08 ms preparing 0.03 ms Creating tmp table 0.05 ms executing 0.08 ms checking permissions 0.06 ms checking permissions 0.03 ms checking permissions 0.02 ms checking permissions 0.03 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.03 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.05 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.02 ms freeing items 0.04 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 29 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172128 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/joomla/database/driver/mysqli.php:42127 JDatabaseDriverMysqli->getTableColumns() Copy JROOT/libraries/joomla/table/table.php:24426 JTable->getFields() Copy JROOT/libraries/joomla/table/table.php:16325 JTable->__construct() Copy JROOT/components/com_community/tables/multiprofile.php:3224 CTableMultiProfile->__construct() Copy JROOT/libraries/joomla/table/table.php:31123 JTable::getInstance() Copy JROOT/components/com_community/libraries/user.php:73222 CUser->getThumbAvatar() Copy JROOT/components/com_community/libraries/core.php:20221 CFactory::getUser() Copy JROOT/components/com_community/libraries/assets.php:9320 CAssets->_init() Copy JROOT/components/com_community/libraries/assets.php:2819 CAssets->__construct() Copy JROOT/components/com_community/libraries/assets.php:4018 CAssets::getInstance() Copy JROOT/components/com_community/libraries/core.php:101917 CFactory::attach() Copy JROOT/components/com_community/libraries/template.php:34216 CTemplate::addStylesheet() Copy JROOT/components/com_community/libraries/messaging.php:3115 CMessaging::load() Copy JROOT/administrator/components/com_easyblog/includes/jomsocial/jomsocial.php:5114 EasyBlogJomSocial->getMessagingHtml() Copy JROOT/administrator/components/com_easyblog/includes/messaging/messaging.php:6313 EasyBlogMessaging->html() Copy JROOT/components/com_easyblog/themes/wireframe/authors/item.php:6412 include Copy JROOT/components/com_easyblog/themes/wireframe/authors/item.php Copy JROOT/administrator/components/com_easyblog/includes/themes/themes.php:44511 EasyBlogThemes->output() Copy JROOT/components/com_easyblog/views/views.php:16410 EasyBlogView->display() Copy JROOT/components/com_easyblog/views/blogger/view.html.php:2799 EasyBlogViewBlogger->listings() Copy JROOT/components/com_easyblog/controllers/controller.php:1068 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:2651 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:0.50 ms 最後のクエリの後:0.79 ms クエリメモリ:0.028 MB クエリ前のメモリ:23.040 MB 返された行:1
SELECT `id` FROM `joom_community_fields ` WHERE `fieldcode`= 'FIELD_GENDER 'クエリではEXPLAINは使用できません:SELECT `id` FROM `joom_community_fields` WHERE `fieldcode`='FIELD_GENDER'
Status Duration starting 0.03 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.01 ms executing 0.02 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.00 ms
# 発信者 ファイルと行番号 27 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:176026 JDatabaseDriver->loadResult() Copy JROOT/components/com_community/models/profile.php:78825 CommunityModelProfile->_getgenderId() Copy JROOT/components/com_community/models/profile.php:76224 CommunityModelProfile->getGender() Copy JROOT/components/com_community/libraries/user.php:62923 CUser->_getGender() Copy JROOT/components/com_community/libraries/user.php:76722 CUser->getThumbAvatar() Copy JROOT/components/com_community/libraries/core.php:20221 CFactory::getUser() Copy JROOT/components/com_community/libraries/assets.php:9320 CAssets->_init() Copy JROOT/components/com_community/libraries/assets.php:2819 CAssets->__construct() Copy JROOT/components/com_community/libraries/assets.php:4018 CAssets::getInstance() Copy JROOT/components/com_community/libraries/core.php:101917 CFactory::attach() Copy JROOT/components/com_community/libraries/template.php:34216 CTemplate::addStylesheet() Copy JROOT/components/com_community/libraries/messaging.php:3115 CMessaging::load() Copy JROOT/administrator/components/com_easyblog/includes/jomsocial/jomsocial.php:5114 EasyBlogJomSocial->getMessagingHtml() Copy JROOT/administrator/components/com_easyblog/includes/messaging/messaging.php:6313 EasyBlogMessaging->html() Copy JROOT/components/com_easyblog/themes/wireframe/authors/item.php:6412 include Copy JROOT/components/com_easyblog/themes/wireframe/authors/item.php Copy JROOT/administrator/components/com_easyblog/includes/themes/themes.php:44511 EasyBlogThemes->output() Copy JROOT/components/com_easyblog/views/views.php:16410 EasyBlogView->display() Copy JROOT/components/com_easyblog/views/blogger/view.html.php:2799 EasyBlogViewBlogger->listings() Copy JROOT/components/com_easyblog/controllers/controller.php:1068 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:2651 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:0.46 ms 最後のクエリの後:0.03 ms クエリメモリ:0.028 MB クエリ前のメモリ:23.052 MB 返された行:0
SELECT `value` FROM `joom_community_fields_values ` WHERE `field_id` = '2' AND `user_id` = '0'クエリではEXPLAINは使用できません:SELECT `value` FROM `joom_community_fields_values` WHERE `field_id` = '2' AND `user_id` = '0'
Status Duration starting 0.04 ms Executing hook on transaction 0.00 ms starting 0.00 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 executing 0.01 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.02 ms cleaning up 0.00 ms
# 発信者 ファイルと行番号 26 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:176025 JDatabaseDriver->loadResult() Copy JROOT/components/com_community/models/profile.php:77124 CommunityModelProfile->getGender() Copy JROOT/components/com_community/libraries/user.php:62923 CUser->_getGender() Copy JROOT/components/com_community/libraries/user.php:76722 CUser->getThumbAvatar() Copy JROOT/components/com_community/libraries/core.php:20221 CFactory::getUser() Copy JROOT/components/com_community/libraries/assets.php:9320 CAssets->_init() Copy JROOT/components/com_community/libraries/assets.php:2819 CAssets->__construct() Copy JROOT/components/com_community/libraries/assets.php:4018 CAssets::getInstance() Copy JROOT/components/com_community/libraries/core.php:101917 CFactory::attach() Copy JROOT/components/com_community/libraries/template.php:34216 CTemplate::addStylesheet() Copy JROOT/components/com_community/libraries/messaging.php:3115 CMessaging::load() Copy JROOT/administrator/components/com_easyblog/includes/jomsocial/jomsocial.php:5114 EasyBlogJomSocial->getMessagingHtml() Copy JROOT/administrator/components/com_easyblog/includes/messaging/messaging.php:6313 EasyBlogMessaging->html() Copy JROOT/components/com_easyblog/themes/wireframe/authors/item.php:6412 include Copy JROOT/components/com_easyblog/themes/wireframe/authors/item.php Copy JROOT/administrator/components/com_easyblog/includes/themes/themes.php:44511 EasyBlogThemes->output() Copy JROOT/components/com_easyblog/views/views.php:16410 EasyBlogView->display() Copy JROOT/components/com_easyblog/views/blogger/view.html.php:2799 EasyBlogViewBlogger->listings() Copy JROOT/components/com_easyblog/controllers/controller.php:1068 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:2651 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:0.46 ms 最後のクエリの後:0.47 ms クエリメモリ:0.026 MB クエリ前のメモリ:23.105 MB 返された行:0
SELECT `id` FROM `joom_users ` WHERE id= '0'クエリではEXPLAINは使用できません:SELECT `id` FROM `joom_users` WHERE id='0'
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.00 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.03 ms executing 0.01 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.02 ms cleaning up 0.00 ms
# 発信者 ファイルと行番号 23 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:176022 JDatabaseDriver->loadResult() Copy JROOT/components/com_community/libraries/core.php:19021 CFactory::getUser() Copy JROOT/components/com_community/libraries/assets.php:9520 CAssets->_init() Copy JROOT/components/com_community/libraries/assets.php:2819 CAssets->__construct() Copy JROOT/components/com_community/libraries/assets.php:4018 CAssets::getInstance() Copy JROOT/components/com_community/libraries/core.php:101917 CFactory::attach() Copy JROOT/components/com_community/libraries/template.php:34216 CTemplate::addStylesheet() Copy JROOT/components/com_community/libraries/messaging.php:3115 CMessaging::load() Copy JROOT/administrator/components/com_easyblog/includes/jomsocial/jomsocial.php:5114 EasyBlogJomSocial->getMessagingHtml() Copy JROOT/administrator/components/com_easyblog/includes/messaging/messaging.php:6313 EasyBlogMessaging->html() Copy JROOT/components/com_easyblog/themes/wireframe/authors/item.php:6412 include Copy JROOT/components/com_easyblog/themes/wireframe/authors/item.php Copy JROOT/administrator/components/com_easyblog/includes/themes/themes.php:44511 EasyBlogThemes->output() Copy JROOT/components/com_easyblog/views/views.php:16410 EasyBlogView->display() Copy JROOT/components/com_easyblog/views/blogger/view.html.php:2799 EasyBlogViewBlogger->listings() Copy JROOT/components/com_easyblog/controllers/controller.php:1068 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:2651 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:0.89 ms 最後のクエリの後:7.02 ms クエリメモリ:0.028 MB クエリ前のメモリ:23.870 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.13 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 Opening tables 0.08 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.12 ms preparing 0.06 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
# 発信者 ファイルと行番号 26 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172125 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/legacy/model/legacy.php:30724 JModelLegacy->_getList() Copy JROOT/administrator/components/com_fields/models/fields.php:32623 FieldsModelFields->_getList() Copy JROOT/libraries/legacy/model/list.php:18922 JModelList->getItems() Copy JROOT/administrator/components/com_fields/helpers/fields.php:13421 FieldsHelper::getFields() Copy JROOT/plugins/system/fields/fields.php:37820 PlgSystemFields->onContentPrepare() Copy JROOT/libraries/joomla/event/event.php:7019 JEvent->update() Copy JROOT/libraries/joomla/event/dispatcher.php:16018 JEventDispatcher->trigger() Copy JROOT/administrator/components/com_easyblog/includes/triggers/triggers.php:4317 EasyBlogTriggers->trigger() Copy JROOT/administrator/components/com_easyblog/includes/post/post.php:397416 EasyBlogPost->prepareContent() Copy JROOT/administrator/components/com_easyblog/includes/post/post.php:365915 EasyBlogPost->getIntro() Copy JROOT/components/com_easyblog/themes/wireframe/blogs/latest/default.main.php:15714 include Copy JROOT/components/com_easyblog/themes/wireframe/blogs/latest/default.main.php Copy JROOT/administrator/components/com_easyblog/includes/themes/themes.php:44513 EasyBlogThemes->output() Copy JROOT/components/com_easyblog/themes/wireframe/authors/item.php:10612 include Copy JROOT/components/com_easyblog/themes/wireframe/authors/item.php Copy JROOT/administrator/components/com_easyblog/includes/themes/themes.php:44511 EasyBlogThemes->output() Copy JROOT/components/com_easyblog/views/views.php:16410 EasyBlogView->display() Copy JROOT/components/com_easyblog/views/blogger/view.html.php:2799 EasyBlogViewBlogger->listings() Copy JROOT/components/com_easyblog/controllers/controller.php:1068 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:2651 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:0.67 ms 最後のクエリの後:2.79 ms クエリメモリ:0.027 MB クエリ前のメモリ:24.152 MB 返された行:0
SELECT a.* FROM `joom_easyblog_comment ` a INNER JOIN joom_users AS c ON a.`created_by` = c.`id` WHERE a.`post_id` = '3' AND a.`published` = 1 ORDER BY a.`lft` asc LIMIT 3クエリではEXPLAINは使用できません:SELECT a.* FROM `joom_easyblog_comment` a INNER JOIN joom_users AS c ON a.`created_by` = c.`id` WHERE a.`post_id` = '3' AND a.`published` = 1 ORDER BY a.`lft` asc LIMIT 3
Status Duration starting 0.06 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.05 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.06 ms preparing 0.03 ms executing 0.03 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 22 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172121 JDatabaseDriver->loadObjectList() Copy JROOT/administrator/components/com_easyblog/includes/utils.php:23520 EasyBlogDbJoomla->__call() Copy JROOT/administrator/components/com_easyblog/models/blog.php:15519 EasyBlogModelBlog->getBlogComment() Copy JROOT/administrator/components/com_easyblog/includes/comment/comment.php:30618 EasyBlogComment->getPreviewBlogComment() Copy JROOT/administrator/components/com_easyblog/includes/post/post.php:342717 EasyBlogPost->getPreviewComments() Copy JROOT/components/com_easyblog/themes/wireframe/blogs/latest/part.comments.php:1416 include Copy JROOT/components/com_easyblog/themes/wireframe/blogs/latest/part.comments.php Copy JROOT/administrator/components/com_easyblog/includes/themes/themes.php:44515 EasyBlogThemes->output() Copy JROOT/components/com_easyblog/themes/wireframe/blogs/latest/default.main.php:19614 include Copy JROOT/components/com_easyblog/themes/wireframe/blogs/latest/default.main.php Copy JROOT/administrator/components/com_easyblog/includes/themes/themes.php:44513 EasyBlogThemes->output() Copy JROOT/components/com_easyblog/themes/wireframe/authors/item.php:10612 include Copy JROOT/components/com_easyblog/themes/wireframe/authors/item.php Copy JROOT/administrator/components/com_easyblog/includes/themes/themes.php:44511 EasyBlogThemes->output() Copy JROOT/components/com_easyblog/views/views.php:16410 EasyBlogView->display() Copy JROOT/components/com_easyblog/views/blogger/view.html.php:2799 EasyBlogViewBlogger->listings() Copy JROOT/components/com_easyblog/controllers/controller.php:1068 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:2651 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:0.60 ms 最後のクエリの後:2.05 ms クエリメモリ:0.027 MB クエリ前のメモリ:24.167 MB 返された行:0
SELECT a.* FROM `joom_easyblog_comment ` a INNER JOIN joom_users AS c ON a.`created_by` = c.`id` WHERE a.`post_id` = '2' AND a.`published` = 1 ORDER BY a.`lft` asc LIMIT 3クエリではEXPLAINは使用できません:SELECT a.* FROM `joom_easyblog_comment` a INNER JOIN joom_users AS c ON a.`created_by` = c.`id` WHERE a.`post_id` = '2' AND a.`published` = 1 ORDER BY a.`lft` asc LIMIT 3
Status Duration starting 0.04 ms Executing hook on transaction 0.00 ms starting 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.05 ms preparing 0.03 ms executing 0.03 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.02 ms cleaning up 0.00 ms
# 発信者 ファイルと行番号 22 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172121 JDatabaseDriver->loadObjectList() Copy JROOT/administrator/components/com_easyblog/includes/utils.php:23520 EasyBlogDbJoomla->__call() Copy JROOT/administrator/components/com_easyblog/models/blog.php:15519 EasyBlogModelBlog->getBlogComment() Copy JROOT/administrator/components/com_easyblog/includes/comment/comment.php:30618 EasyBlogComment->getPreviewBlogComment() Copy JROOT/administrator/components/com_easyblog/includes/post/post.php:342717 EasyBlogPost->getPreviewComments() Copy JROOT/components/com_easyblog/themes/wireframe/blogs/latest/part.comments.php:1416 include Copy JROOT/components/com_easyblog/themes/wireframe/blogs/latest/part.comments.php Copy JROOT/administrator/components/com_easyblog/includes/themes/themes.php:44515 EasyBlogThemes->output() Copy JROOT/components/com_easyblog/themes/wireframe/blogs/latest/default.main.php:19614 include Copy JROOT/components/com_easyblog/themes/wireframe/blogs/latest/default.main.php Copy JROOT/administrator/components/com_easyblog/includes/themes/themes.php:44513 EasyBlogThemes->output() Copy JROOT/components/com_easyblog/themes/wireframe/authors/item.php:10612 include Copy JROOT/components/com_easyblog/themes/wireframe/authors/item.php Copy JROOT/administrator/components/com_easyblog/includes/themes/themes.php:44511 EasyBlogThemes->output() Copy JROOT/components/com_easyblog/views/views.php:16410 EasyBlogView->display() Copy JROOT/components/com_easyblog/views/blogger/view.html.php:2799 EasyBlogViewBlogger->listings() Copy JROOT/components/com_easyblog/controllers/controller.php:1068 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:2651 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:1.92 ms 最後のクエリの後:1.85 ms クエリメモリ:0.029 MB クエリ前のメモリ:24.391 MB 返された行:21
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM joom_modules AS m
LEFT JOIN joom_modules_menu AS mm ON mm.moduleid = m.id
LEFT JOIN joom_extensions AS e ON e.element = m.module AND e.client_id = m.client_id
WHERE m.published = 1 AND e.enabled = 1 AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2024-10-05 16:27:50') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-10-05 16:27:50') AND m.access IN (1,1) AND m.client_id = 0 AND (mm.menuid = 618 OR mm.menuid <= 0) AND m.language IN ('ja-JA ','* ')
ORDER BY m.position, m.orderingクエリではEXPLAINは使用できません:SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM joom_modules AS m
LEFT JOIN joom_modules_menu AS mm ON mm.moduleid = m.id
LEFT JOIN joom_extensions AS e ON e.element = m.module AND e.client_id = m.client_id
WHERE m.published = 1 AND e.enabled = 1 AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2024-10-05 16:27:50') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-10-05 16:27:50') AND m.access IN (1,1) AND m.client_id = 0 AND (mm.menuid = 618 OR mm.menuid <= 0) AND m.language IN ('ja-JA','*')
ORDER BY m.position, m.ordering
Status Duration starting 0.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 Opening tables 0.07 ms init 0.01 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.11 ms preparing 0.05 ms executing 1.11 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
# 発信者 ファイルと行番号 20 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172119 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/joomla/cache/controller/callback.php:16918 JCacheControllerCallback->get() Copy JROOT/libraries/cms/module/helper.php:42417 JModuleHelper::getModuleList() Copy JROOT/libraries/cms/module/helper.php:36016 JModuleHelper::load() Copy JROOT/libraries/cms/module/helper.php:8415 JModuleHelper::getModules() Copy JROOT/administrator/components/com_easyblog/includes/easyblog.php:212414 EB::renderModule() Copy JROOT/components/com_easyblog/themes/wireframe/toolbar/default.php:1413 include Copy JROOT/components/com_easyblog/themes/wireframe/toolbar/default.php Copy JROOT/administrator/components/com_easyblog/includes/themes/themes.php:44512 EasyBlogThemes->output() Copy JROOT/components/com_easyblog/views/views.php:43811 EasyBlogView->getToolbar() Copy JROOT/components/com_easyblog/views/views.php:19610 EasyBlogView->display() Copy JROOT/components/com_easyblog/views/blogger/view.html.php:2799 EasyBlogViewBlogger->listings() Copy JROOT/components/com_easyblog/controllers/controller.php:1068 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:2651 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:0.90 ms 最後のクエリの後:3.11 ms クエリメモリ:0.021 MB クエリ前のメモリ:24.469 MB 返された行:1
SELECT language,id
FROM `joom_menu `
WHERE home = 1 AND published = 1 AND client_id = 0クエリではEXPLAINは使用できません:SELECT language,id
FROM `joom_menu`
WHERE home = 1 AND published = 1 AND client_id = 0
Status Duration starting 0.06 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.06 ms preparing 0.02 ms executing 0.28 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:17219 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/cms/language/multilang.php:1068 JLanguageMultilang::getSiteHomePages() Copy JROOT/plugins/system/languagefilter/languagefilter.php:7297 PlgSystemLanguageFilter->onAfterDispatch() Copy JROOT/libraries/joomla/event/event.php:706 JEvent->update() Copy JROOT/libraries/joomla/event/dispatcher.php:1605 JEventDispatcher->trigger() Copy JROOT/libraries/joomla/application/base.php:1064 JApplicationBase->triggerEvent() Copy JROOT/libraries/cms/application/site.php:1963 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:0.64 ms 最後のクエリの後:2.96 ms クエリメモリ:0.022 MB クエリ前のメモリ:24.815 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.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.00 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.02 ms cleaning up 0.00 ms
# 発信者 ファイルと行番号 12 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:168211 JDatabaseDriver->loadObject() Copy JROOT/libraries/axslibs/currency.php:8410 AxsCurrency->getBaseCurrency() Copy JROOT/libraries/axslibs/currency.php:229 AxsCurrency->__construct() Copy JROOT/templates/axs/home.php:208 include Copy JROOT/templates/axs/home.php Copy JROOT/templates/axs/index.php:597 require Copy JROOT/templates/axs/index.php Copy JROOT/libraries/joomla/document/html.php:6536 JDocumentHtml->_loadTemplate() Copy JROOT/libraries/joomla/document/html.php:7155 JDocumentHtml->_fetchTemplate() Copy JROOT/libraries/joomla/document/html.php:5304 JDocumentHtml->parse() Copy JROOT/libraries/cms/application/cms.php:11733 JApplicationCms->render() Copy JROOT/libraries/cms/application/site.php:7822 JApplicationSite->render() Copy JROOT/libraries/cms/application/cms.php:2711 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:0.47 ms 最後のクエリの後:0.10 ms クエリメモリ:0.023 MB クエリ前のメモリ:24.822 MB 返された行:10
SELECT * FROM axs_fonts WHERE enabled = 1クエリではEXPLAINは使用できません:SELECT * FROM axs_fonts WHERE enabled = 1
Status Duration starting 0.02 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.00 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms executing 0.03 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.02 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 11 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172110 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/axslibs/fonts.php:349 AxsFonts::getFonts() Copy JROOT/templates/axs/home.php:938 include Copy JROOT/templates/axs/home.php Copy JROOT/templates/axs/index.php:597 require Copy JROOT/templates/axs/index.php Copy JROOT/libraries/joomla/document/html.php:6536 JDocumentHtml->_loadTemplate() Copy JROOT/libraries/joomla/document/html.php:7155 JDocumentHtml->_fetchTemplate() Copy JROOT/libraries/joomla/document/html.php:5304 JDocumentHtml->parse() Copy JROOT/libraries/cms/application/cms.php:11733 JApplicationCms->render() Copy JROOT/libraries/cms/application/site.php:7822 JApplicationSite->render() Copy JROOT/libraries/cms/application/cms.php:2711 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:0.47 ms 最後のクエリの後:0.19 ms クエリメモリ:0.022 MB クエリ前のメモリ:24.858 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.03 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.01 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.01 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
# 発信者 ファイルと行番号 12 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:168211 JDatabaseDriver->loadObject() Copy JROOT/libraries/axslibs/accessibility.php:4210 AxsAccessibility::query() Copy JROOT/libraries/axslibs/accessibility.php:499 AxsAccessibility::image() Copy JROOT/templates/axs/home.php:7998 include Copy JROOT/templates/axs/home.php Copy JROOT/templates/axs/index.php:597 require Copy JROOT/templates/axs/index.php Copy JROOT/libraries/joomla/document/html.php:6536 JDocumentHtml->_loadTemplate() Copy JROOT/libraries/joomla/document/html.php:7155 JDocumentHtml->_fetchTemplate() Copy JROOT/libraries/joomla/document/html.php:5304 JDocumentHtml->parse() Copy JROOT/libraries/cms/application/cms.php:11733 JApplicationCms->render() Copy JROOT/libraries/cms/application/site.php:7822 JApplicationSite->render() Copy JROOT/libraries/cms/application/cms.php:2711 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:0.64 ms 最後のクエリの後:0.87 ms クエリメモリ:0.022 MB クエリ前のメモリ:24.910 MB 返された行:0
SELECT * FROM axs_notifications WHERE enabled = 1 AND DATE (start_date) <= NOW () AND ( DATE (end_date) > NOW () OR end_date = 0 ) AND ( ( access_type = 'access' AND ( ( FIND_IN_SET ( 1, accesslevel ) > 0 ) OR ( FIND_IN_SET ( 1, accesslevel ) > 0 ) ) ) OR ( access_type = 'user' AND ( ( FIND_IN_SET ( 1, usergroup ) > 0 ) ) ) OR ( access_type = 'list' AND ( FIND_IN_SET ( 0, userlist ) > 0 ) ) OR ( access_type = 'none' ) )クエリではEXPLAINは使用できません:SELECT * FROM axs_notifications WHERE enabled = 1 AND DATE(start_date) <= NOW() AND ( DATE(end_date) > NOW() OR end_date = 0 ) AND ( ( access_type = 'access' AND ( ( FIND_IN_SET( 1, accesslevel ) > 0 ) OR ( FIND_IN_SET( 1, accesslevel ) > 0 ) ) ) OR ( access_type = 'user' AND ( ( FIND_IN_SET( 1, usergroup ) > 0 ) ) ) OR ( access_type = 'list' AND ( FIND_IN_SET( 0, userlist ) > 0 ) ) OR ( access_type = 'none' ) )
Status Duration starting 0.08 ms Executing hook on transaction 0.01 ms starting 0.00 ms checking permissions 0.00 ms Opening tables 0.06 ms init 0.01 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.02 ms preparing 0.03 ms executing 0.03 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 11 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172110 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/axslibs/notifications.php:179 AxsNotifications::loadNotifications() Copy JROOT/templates/axs/home.php:17888 include Copy JROOT/templates/axs/home.php Copy JROOT/templates/axs/index.php:597 require Copy JROOT/templates/axs/index.php Copy JROOT/libraries/joomla/document/html.php:6536 JDocumentHtml->_loadTemplate() Copy JROOT/libraries/joomla/document/html.php:7155 JDocumentHtml->_fetchTemplate() Copy JROOT/libraries/joomla/document/html.php:5304 JDocumentHtml->parse() Copy JROOT/libraries/cms/application/cms.php:11733 JApplicationCms->render() Copy JROOT/libraries/cms/application/site.php:7822 JApplicationSite->render() Copy JROOT/libraries/cms/application/cms.php:2711 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:1.11 ms 最後のクエリの後:0.46 ms クエリメモリ:0.023 MB クエリ前のメモリ:24.807 MB 返された行:1
SELECT sef FROM joom_languages WHERE lang_code = 'ja-JA ' LIMIT 1クエリではEXPLAINは使用できません:SELECT sef FROM joom_languages WHERE lang_code = 'ja-JA' LIMIT 1
Status Duration starting 0.04 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.00 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.01 ms executing 0.01 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.02 ms cleaning up 0.00 ms
# 発信者 ファイルと行番号 14 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:168213 JDatabaseDriver->loadObject() Copy JROOT/libraries/axslibs/language.php:28512 AxsLanguage::getSefByLangCode() Copy JROOT/modules/mod_mediamodal/tmpl/default.php:811 require Copy JROOT/modules/mod_mediamodal/tmpl/default.php Copy JROOT/modules/mod_mediamodal/mod_mediamodal.php:910 include Copy JROOT/modules/mod_mediamodal/mod_mediamodal.php Copy JROOT/libraries/cms/module/helper.php:1989 JModuleHelper::renderModule() Copy JROOT/libraries/joomla/document/renderer/html/module.php:938 JDocumentRendererHtmlModule->render() Copy JROOT/libraries/joomla/document/renderer/html/modules.php:427 JDocumentRendererHtmlModules->render() Copy JROOT/libraries/joomla/document/html.php:4866 JDocumentHtml->getBuffer() Copy JROOT/libraries/joomla/document/html.php:7775 JDocumentHtml->_renderTemplate() Copy JROOT/libraries/joomla/document/html.php:5524 JDocumentHtml->render() Copy JROOT/libraries/cms/application/cms.php:11903 JApplicationCms->render() Copy JROOT/libraries/cms/application/site.php:7822 JApplicationSite->render() Copy JROOT/libraries/cms/application/cms.php:2711 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:0.53 ms 最後のクエリの後:3.91 ms クエリメモリ:0.028 MB クエリ前のメモリ:25.188 MB 返された行:1
SELECT * FROM joom_kunena_configuration WHERE id= 1クエリではEXPLAINは使用できません:SELECT * FROM joom_kunena_configuration WHERE id=1
Status Duration starting 0.02 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.00 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.01 ms executing 0.01 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.02 ms cleaning up 0.00 ms
# 発信者 ファイルと行番号 28 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:148527 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:11903 JApplicationCms->render() Copy JROOT/libraries/cms/application/site.php:7822 JApplicationSite->render() Copy JROOT/libraries/cms/application/cms.php:2711 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:0.52 ms 最後のクエリの後:4.87 ms クエリメモリ:0.024 MB クエリ前のメモリ:25.399 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.03 ms Executing hook on transaction 0.00 ms starting 0.00 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.00 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:168215 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:11903 JApplicationCms->render() Copy JROOT/libraries/cms/application/site.php:7822 JApplicationSite->render() Copy JROOT/libraries/cms/application/cms.php:2711 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:0.56 ms 最後のクエリの後:0.06 ms クエリメモリ:0.026 MB クエリ前のメモリ:25.409 MB 返された行:25
SELECT *
FROM axs_translations
WHERE language_tag = 'ja'クエリではEXPLAINは使用できません:SELECT *
FROM axs_translations
WHERE language_tag = 'ja'
Status Duration starting 0.02 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.00 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.01 ms executing 0.09 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.02 ms cleaning up 0.00 ms
# 発信者 ファイルと行番号 16 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:152615 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:11903 JApplicationCms->render() Copy JROOT/libraries/cms/application/site.php:7822 JApplicationSite->render() Copy JROOT/libraries/cms/application/cms.php:2711 JApplicationCms->execute() Copy JROOT/index.php:72
クエリ時間:0.64 ms 最後のクエリの後:3.82 ms クエリメモリ:0.023 MB クエリ前のメモリ:25.472 MB 返された行:0
SELECT `c2`.`language`,`c2`.`id`
FROM `joom_menu ` AS `c`
INNER JOIN `joom_associations ` AS `a` ON a.id = c.`id` AND a.context= 'com_menus.item'
INNER JOIN `joom_associations ` AS `a2` ON a.key = a2.key
INNER JOIN `joom_menu ` AS `c2` ON a2.id = c2.`id`
WHERE c.id = 618クエリではEXPLAINは使用できません:SELECT `c2`.`language`,`c2`.`id`
FROM `joom_menu` AS `c`
INNER JOIN `joom_associations` AS `a` ON a.id = c.`id` AND a.context='com_menus.item'
INNER JOIN `joom_associations` AS `a2` ON a.key = a2.key
INNER JOIN `joom_menu` AS `c2` ON a2.id = c2.`id`
WHERE c.id = 618
Status Duration starting 0.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.01 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.08 ms executing 0.01 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.02 ms cleaning up 0.01 ms
# 発信者 ファイルと行番号 15 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172114 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/cms/language/associations.php:10113 JLanguageAssociations::getAssociations() Copy JROOT/administrator/components/com_menus/helpers/menus.php:31312 MenusHelper::getAssociations() Copy JROOT/modules/mod_language_selector/tmpl/default.php:9111 require Copy JROOT/modules/mod_language_selector/tmpl/default.php Copy JROOT/modules/mod_language_selector/mod_language_selector.php:410 include Copy JROOT/modules/mod_language_selector/mod_language_selector.php Copy JROOT/libraries/cms/module/helper.php:1989 JModuleHelper::renderModule() Copy JROOT/libraries/joomla/document/renderer/html/module.php:938 JDocumentRendererHtmlModule->render() Copy JROOT/libraries/joomla/document/renderer/html/modules.php:427 JDocumentRendererHtmlModules->render() Copy JROOT/libraries/joomla/document/html.php:4866 JDocumentHtml->getBuffer() Copy JROOT/libraries/joomla/document/html.php:7775 JDocumentHtml->_renderTemplate() Copy JROOT/libraries/joomla/document/html.php:5524 JDocumentHtml->render() Copy JROOT/libraries/cms/application/cms.php:11903 JApplicationCms->render() Copy JROOT/libraries/cms/application/site.php:7822 JApplicationSite->render() Copy JROOT/libraries/cms/application/cms.php:2711 JApplicationCms->execute() Copy JROOT/index.php:72
2×SELECT `id` FROM `joom_users ` 2×SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `joom_extensions ` 2×SELECT * FROM joom_languages 2×SELECT a.* FROM `joom_easyblog_comment ` a INNER JOIN joom_users AS c ON a.`created_by` = c.`id` 2×SELECT * FROM `joom_users ` 2×SELECT * FROM `joom_easyblog_acl_group ` 1×SELECT `group_id` FROM `joom_easyblog_category_fields_groups ` 1×SELECT COUNT (1) FROM `joom_easyblog_featured ` 1×SELECT `template` FROM `joom_template_styles ` 1×SELECT `id` FROM `joom_easyblog_subscriptions ` 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 `a`.`id` as `cat_fg_id`, `a`.`category_id` as `cat_fg_category_id`, `a`.`group_id` as `cat_fg_group_id`, `fg`.`id` as `fg_id`, `fg`.`title` as `fg_title`, `fg`.`description` as `fg_description`, `fg`.`created` as `fg_created`, `fg`.`state` as `fg_state`, `fg`.`read` as `fg_read`, `fg`.`write` as `fg_write`, `fg`.`params` as `fg_params`, `f`.`id` as `f_id`, `f`.`group_id` as `f_group_id`, `f`.`title` as `f_title`, `f`.`help` as `f_help`, `f`.`state` as `f_state`, `f`.`required` as `f_required`, `f`.`type` as `f_type`, `f`.`params` as `f_params`, `f`.`created` as `f_created`, `f`.`options` as `f_options`, `fv`.`id` as `fv_id`, `fv`.`field_id` as `fv_field_id`, `fv`.`post_id` as `fv_post_id`, `fv`.`value` as `fv_value` from `joom_easyblog_category_fields_groups ` as a inner join `joom_easyblog_post_category ` as p on `a`.`category_id` = `p`.`category_id` inner join `joom_easyblog_fields_groups ` as fg on `a`.`group_id` = `fg`.`id` inner join `joom_easyblog_fields ` as f on `fg`.`id` = `f`.`group_id` left join `joom_easyblog_fields_values ` as fv on `fv`.`field_id` = `f`.`id` and `fv`.`post_id` = `p`.`post_id` 1×select * from `joom_easyblog_meta ` 1×select a.* from `joom_easyblog_revisions ` as a 1×select a.* , b.`post_id` from `joom_easyblog_tag ` as a inner join `joom_easyblog_post_tag ` as b on a.`id` = b.`tag_id` 1×select a.* , b.`post_id`, b.`primary` from `joom_easyblog_category ` as a inner join `joom_easyblog_post_category ` as b on a.`id` = b.`category_id` 1×SELECT a.`post_id`, COUNT (1) AS `count` FROM `joom_easyblog_comment ` AS a 1×SELECT a.* FROM `joom_easyblog_comment ` AS a 1×SELECT * FROM `joom_easyblog_oauth ` 1×SELECT `session_id` FROM `joom_session ` 1×SELECT * FROM joom_community_config 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 COUNT (1) as `voted`, `uid` FROM `joom_easyblog_ratings ` 1×SELECT language,id FROM `joom_menu ` 1×SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid FROM joom_modules AS m LEFT JOIN joom_modules_menu AS mm ON mm.moduleid = m.id LEFT JOIN joom_extensions AS e ON e.element = m.module AND e.client_id = m.client_id 1×SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state FROM joom_fields AS a LEFT JOIN `joom_languages ` AS l ON l.lang_code = a.language LEFT JOIN joom_users AS uc ON uc.id= a.checked_out LEFT JOIN joom_viewlevels AS ag ON ag.id = a.access LEFT JOIN joom_users AS ua ON ua.id = a.created_user_id LEFT JOIN joom_fields_groups AS g ON g.id = a.group_id LEFT JOIN `joom_fields_categories ` AS fc ON fc.field_id = a.id 1×SELECT `value` FROM `joom_community_fields_values ` 1×SELECT `id` FROM `joom_community_fields ` 1×SELECT a.`userid` as _userid , a.`status` as _status , a.`points` as _points, a.`posted_on` as _posted_on, a.`avatar` as _avatar , a.`cover` as _cover , a.`thumb` as _thumb , a.`invite` as _invite, a.`params` as _cparams, a.`view` as _view, a.`friends` as _friends, a.`groups` as _groups, a.`events` as _events, a.`friendcount` as _friendcount, a.`alias` as _alias, a.`profile_id` as _profile_id, a.`storage` as _storage, a.`watermark_hash` as _watermark_hash, a.`search_email` as _search_email, s.`userid` as _isonline, u.* FROM `joom_community_users ` as a LEFT JOIN `joom_users ` u ON u.`id`= a.`userid` LEFT OUTER JOIN `joom_session ` s ON s.`userid`= a.`userid` AND s.`client_id` != '1' 1×SELECT AVG (`value`) AS `ratings` ,COUNT (1) AS `total` ,`uid` FROM `joom_easyblog_ratings ` AS a 1×SELECT * FROM joom_easyblog_users 1×select FOUND_ROWS ( 1×SELECT * FROM joom_extensions 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_easyblog_configs 1×SELECT `id` FROM `joom_easyblog_users ` 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 params FROM axs_user_settings 1×SELECT id, home, template, s.params FROM joom_template_styles as s LEFT JOIN joom_extensions as e ON e.element= s.template AND e.type= 'template' AND e.client_id= s.client_id 1×SELECT `id` FROM `joom_easyblog_mailq ` 1×SELECT * FROM `joom_easyblog_post ` 1×SELECT id, created_by FROM `joom_easyblog_post ` 1×SELECT * FROM `joom_easyblog_uploader_tmp ` 1×SELECT * FROM `joom_menu ` 1×SELECT * FROM `joom_easyblog_acl ` 1×SELECT `id`,`name`,`rules`,`parent_id` FROM `joom_assets ` 1×SELECT `id` FROM `joom_menu ` 1×select u.* , e.`id` as `eb_id`, e.`nickname`, e.`avatar`, e.`description`, e.`url`, e.`params` as `eb_params`, e.`published` as `eb_published`, e.`title` as `eb_title`, e.`biography`, e.`permalink`, e.`custom_css` from `joom_users ` as u left join `joom_easyblog_users ` as e ON u.`id` = e.`id` 1×SELECT `g`.`id`,`g`.`title` FROM `joom_usergroups ` AS g INNER JOIN `joom_user_usergroup_map ` AS m ON m.group_id = g.id 1×SELECT `group_id` FROM `joom_user_usergroup_map ` 1×SELECT * FROM joom_easyblog_meta 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`