Query Time: 1.27 ms Query memory: 0.020 MB Memory before query: 4.247 MB Rows returned: 1
SELECT `session_id`
FROM `joom_session `
WHERE `session_id` = 'ihu9cuqkmdbf85tser805kh2av' LIMIT 1EXPLAIN not possible on query: SELECT `session_id`
FROM `joom_session`
WHERE `session_id` = 'ihu9cuqkmdbf85tser805kh2av' LIMIT 1
Status Duration starting 0.08 ms Executing hook on transaction 0.01 ms starting 0.02 ms checking permissions 0.01 ms Opening tables 0.04 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.02 ms executing 0.01 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.00 ms
# Caller File and line number 8 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:17657 JDatabaseDriver->loadResult() Copy JROOT/libraries/cms/application/cms.php:1766 JApplicationCms->checkSession() Copy JROOT/libraries/cms/application/cms.php:8965 JApplicationCms->loadSession() Copy JROOT/libraries/cms/application/cms.php:1314 JApplicationCms->__construct() Copy JROOT/libraries/cms/application/site.php:633 JApplicationSite->__construct() Copy JROOT/libraries/cms/application/cms.php:4772 JApplicationCms::getInstance() Copy JROOT/libraries/joomla/factory.php:1251 JFactory::getApplication() Copy JROOT/index.php:50
Query Time: 1.51 ms After last query: 1.16 ms Query memory: 0.045 MB Memory before query: 4.420 MB Rows returned: 80
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `joom_extensions `
WHERE `type` = 'component'EXPLAIN not possible on query: SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `joom_extensions`
WHERE `type` = 'component'
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.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.03 ms cleaning up 0.00 ms
# Caller File and line number 10 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:17269 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/cms/component/helper.php:4478 JComponentHelper::{closure}() Copy JROOT/libraries/joomla/cache/controller/callback.php:1697 JCacheControllerCallback->get() Copy JROOT/libraries/cms/component/helper.php:4556 JComponentHelper::load() Copy JROOT/libraries/cms/component/helper.php:435 JComponentHelper::getComponent() Copy JROOT/libraries/cms/component/helper.php:1114 JComponentHelper::getParams() Copy JROOT/libraries/cms/application/site.php:5983 JApplicationSite->initialiseApp() Copy JROOT/libraries/cms/application/site.php:2092 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2731 JApplicationCms->execute() Copy JROOT/index.php:72
Query Time: 1.13 ms After last query: 1.14 ms Query memory: 0.021 MB Memory before query: 4.630 MB Rows returned: 7
SELECT id, rules
FROM `joom_viewlevels `EXPLAIN not possible on query: SELECT id, rules
FROM `joom_viewlevels`
Status Duration starting 0.04 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.01 ms System lock 0.01 ms optimizing 0.00 ms statistics 0.01 ms preparing 0.01 ms executing 0.04 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms
# Caller File and line number 10 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:15319 JDatabaseDriver->loadAssocList() Copy JROOT/libraries/joomla/access/access.php:10628 JAccess::getAuthorisedViewLevels() Copy JROOT/libraries/joomla/user/user.php:4537 JUser->getAuthorisedViewLevels() Copy JROOT/libraries/cms/plugin/helper.php:2936 JPluginHelper::load() Copy JROOT/libraries/cms/plugin/helper.php:865 JPluginHelper::getPlugin() Copy JROOT/libraries/cms/plugin/helper.php:1284 JPluginHelper::isEnabled() Copy JROOT/libraries/cms/application/site.php:6083 JApplicationSite->initialiseApp() Copy JROOT/libraries/cms/application/site.php:2092 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2731 JApplicationCms->execute() Copy JROOT/index.php:72
Query Time: 1.17 ms After last query: 0.04 ms Query memory: 0.021 MB Memory before query: 4.642 MB Rows returned: 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 = 1EXPLAIN not possible on query: 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.00 ms starting 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.06 ms preparing 0.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
# Caller File and line number 11 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:157510 JDatabaseDriver->loadColumn() Copy JROOT/libraries/joomla/access/access.php:9799 JAccess::getGroupsByUser() Copy JROOT/libraries/joomla/access/access.php:10948 JAccess::getAuthorisedViewLevels() Copy JROOT/libraries/joomla/user/user.php:4537 JUser->getAuthorisedViewLevels() Copy JROOT/libraries/cms/plugin/helper.php:2936 JPluginHelper::load() Copy JROOT/libraries/cms/plugin/helper.php:865 JPluginHelper::getPlugin() Copy JROOT/libraries/cms/plugin/helper.php:1284 JPluginHelper::isEnabled() Copy JROOT/libraries/cms/application/site.php:6083 JApplicationSite->initialiseApp() Copy JROOT/libraries/cms/application/site.php:2092 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2731 JApplicationCms->execute() Copy JROOT/index.php:72
Query Time: 2.52 ms After last query: 0.33 ms Query memory: 0.046 MB Memory before query: 4.705 MB Rows returned: 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 orderingEXPLAIN not possible on query: 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.08 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.06 ms preparing 0.03 ms executing 1.22 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.01 ms
# Caller File and line number 10 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:17269 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/cms/plugin/helper.php:3118 JPluginHelper::{closure}() Copy JROOT/libraries/joomla/cache/controller/callback.php:1697 JCacheControllerCallback->get() Copy JROOT/libraries/cms/plugin/helper.php:3166 JPluginHelper::load() Copy JROOT/libraries/cms/plugin/helper.php:865 JPluginHelper::getPlugin() Copy JROOT/libraries/cms/plugin/helper.php:1284 JPluginHelper::isEnabled() Copy JROOT/libraries/cms/application/site.php:6083 JApplicationSite->initialiseApp() Copy JROOT/libraries/cms/application/site.php:2092 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2731 JApplicationCms->execute() Copy JROOT/index.php:72
Query Time: 1.35 ms After last query: 4.25 ms Query memory: 0.024 MB Memory before query: 5.713 MB Rows returned: 1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `joom_extensions `
WHERE `type` = 'library' AND `element` = 'joomla'EXPLAIN not possible on query: SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `joom_extensions`
WHERE `type` = 'library' AND `element` = 'joomla'
Status Duration starting 0.08 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.04 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.09 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.04 ms cleaning up 0.00 ms
# Caller File and line number 17 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:168716 JDatabaseDriver->loadObject() Copy JROOT/libraries/cms/library/helper.php:16615 JLibraryHelper::{closure}() Copy JROOT/libraries/joomla/cache/controller/callback.php:16914 JCacheControllerCallback->get() Copy JROOT/libraries/cms/library/helper.php:17413 JLibraryHelper::loadLibrary() Copy JROOT/libraries/cms/library/helper.php:4212 JLibraryHelper::getLibrary() Copy JROOT/libraries/cms/library/helper.php:8911 JLibraryHelper::getParams() Copy JROOT/libraries/cms/version/version.php:27010 JVersion->getMediaVersion() Copy JROOT/libraries/joomla/factory.php:7779 JFactory::createDocument() Copy JROOT/libraries/joomla/factory.php:2168 JFactory::getDocument() Copy JROOT/plugins/system/mootable/mootable.php:1007 PlgSystemMootable->__construct() Copy JROOT/libraries/cms/plugin/helper.php:2556 JPluginHelper::import() Copy JROOT/libraries/cms/plugin/helper.php:1705 JPluginHelper::importPlugin() Copy JROOT/libraries/cms/application/cms.php:7474 JApplicationCms->initialiseApp() Copy JROOT/libraries/cms/application/site.php:6903 JApplicationSite->initialiseApp() Copy JROOT/libraries/cms/application/site.php:2092 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2731 JApplicationCms->execute() Copy JROOT/index.php:72
Query Time: 6.83 ms After last query: 0.06 ms Query memory: 0.006 MB Memory before query: 5.705 MB
UPDATE `joom_extensions `
SET `params` = '{\"mediaversion\":\"b78672edb4c55d5997bce6870e8a9afb\"}'
WHERE `type` = 'library' AND `element` = 'joomla'EXPLAIN not possible on query: UPDATE `joom_extensions`
SET `params` = '{\"mediaversion\":\"b78672edb4c55d5997bce6870e8a9afb\"}'
WHERE `type` = 'library' AND `element` = 'joomla'
Status Duration starting 0.06 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.05 ms init 0.01 ms System lock 0.08 ms updating 0.21 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.10 ms closing tables 0.01 ms freeing items 0.02 ms async commit 5.28 ms cleaning up 0.02 ms
# Caller File and line number 13 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/cms/library/helper.php:11612 JLibraryHelper::saveParams() Copy JROOT/libraries/cms/version/version.php:32111 JVersion->setMediaVersion() Copy JROOT/libraries/cms/version/version.php:28010 JVersion->getMediaVersion() Copy JROOT/libraries/joomla/factory.php:7779 JFactory::createDocument() Copy JROOT/libraries/joomla/factory.php:2168 JFactory::getDocument() Copy JROOT/plugins/system/mootable/mootable.php:1007 PlgSystemMootable->__construct() Copy JROOT/libraries/cms/plugin/helper.php:2556 JPluginHelper::import() Copy JROOT/libraries/cms/plugin/helper.php:1705 JPluginHelper::importPlugin() Copy JROOT/libraries/cms/application/cms.php:7474 JApplicationCms->initialiseApp() Copy JROOT/libraries/cms/application/site.php:6903 JApplicationSite->initialiseApp() Copy JROOT/libraries/cms/application/site.php:2092 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2731 JApplicationCms->execute() Copy JROOT/index.php:72
Query Time: 1.32 ms After last query: 15.86 ms Query memory: 0.029 MB Memory before query: 8.106 MB Rows returned: 19
SELECT *
FROM joom_languages
WHERE published= 1
ORDER BY ordering ASC EXPLAIN not possible on query: 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.00 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.14 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms
# Caller File and line number 10 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:17269 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/joomla/language/helper.php:1488 JLanguageHelper::getLanguages() Copy JROOT/plugins/system/languagefilter/languagefilter.php:997 PlgSystemLanguageFilter->__construct() Copy JROOT/libraries/cms/plugin/helper.php:2556 JPluginHelper::import() Copy JROOT/libraries/cms/plugin/helper.php:1705 JPluginHelper::importPlugin() Copy JROOT/libraries/cms/application/cms.php:7474 JApplicationCms->initialiseApp() Copy JROOT/libraries/cms/application/site.php:6903 JApplicationSite->initialiseApp() Copy JROOT/libraries/cms/application/site.php:2092 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2731 JApplicationCms->execute() Copy JROOT/index.php:72
Query Time: 1.22 ms After last query: 0.38 ms Query memory: 0.021 MB Memory before query: 8.178 MB Rows returned: 1
SELECT * FROM axs_domains WHERE domain = 'k8s.intg.tovuti.io'EXPLAIN not possible on query: SELECT * FROM axs_domains WHERE domain = 'k8s.intg.tovuti.io'
Status Duration starting 0.05 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.02 ms executing 0.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.00 ms
# Caller File and line number 10 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:16879 JDatabaseDriver->loadObject() Copy JROOT/libraries/axslibs/language.php:1838 AxsLanguage::getSubdomainDefault() Copy JROOT/plugins/system/languagefilter/languagefilter.php:1037 PlgSystemLanguageFilter->__construct() Copy JROOT/libraries/cms/plugin/helper.php:2556 JPluginHelper::import() Copy JROOT/libraries/cms/plugin/helper.php:1705 JPluginHelper::importPlugin() Copy JROOT/libraries/cms/application/cms.php:7474 JApplicationCms->initialiseApp() Copy JROOT/libraries/cms/application/site.php:6903 JApplicationSite->initialiseApp() Copy JROOT/libraries/cms/application/site.php:2092 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2731 JApplicationCms->execute() Copy JROOT/index.php:72
Query Time: 1.64 ms After last query: 0.05 ms Query memory: 0.030 MB Memory before query: 8.186 MB Rows returned: 94
SELECT `element`,`name`,`client_id`,`extension_id`
FROM `joom_extensions `
WHERE `type` = 'language' AND `state` = 0 AND `enabled` = 1EXPLAIN not possible on query: SELECT `element`,`name`,`client_id`,`extension_id`
FROM `joom_extensions`
WHERE `type` = 'language' AND `state` = 0 AND `enabled` = 1
Status Duration starting 0.11 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.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.36 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms
# Caller File and line number 10 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:17269 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/joomla/language/helper.php:2078 JLanguageHelper::getInstalledLanguages() Copy JROOT/plugins/system/languagefilter/languagefilter.php:1137 PlgSystemLanguageFilter->__construct() Copy JROOT/libraries/cms/plugin/helper.php:2556 JPluginHelper::import() Copy JROOT/libraries/cms/plugin/helper.php:1705 JPluginHelper::importPlugin() Copy JROOT/libraries/cms/application/cms.php:7474 JApplicationCms->initialiseApp() Copy JROOT/libraries/cms/application/site.php:6903 JApplicationSite->initialiseApp() Copy JROOT/libraries/cms/application/site.php:2092 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2731 JApplicationCms->execute() Copy JROOT/index.php:72
Query Time: 1.30 ms After last query: 0.85 ms Query memory: 0.022 MB Memory before query: 8.319 MB Rows returned: 1
SELECT * FROM `axs_brands` WHERE language = 'en-GB ' AND (FIND_IN_SET ('k8s.intg.tovuti.io', domains) > 0) LIMIT 1EXPLAIN not possible on query: SELECT * FROM `axs_brands` WHERE language = 'en-GB' AND (FIND_IN_SET('k8s.intg.tovuti.io', domains) > 0) LIMIT 1
Status Duration starting 0.09 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.05 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.02 ms executing 0.05 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms
# Caller File and line number 13 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172612 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/axslibs/brands.php:29811 AxsBrands::getData() Copy JROOT/libraries/axslibs/brands.php:36310 AxsBrands::getBrandObject() Copy JROOT/libraries/axslibs/brands.php:559 AxsBrands::getBrand() Copy JROOT/plugins/system/axslibs/axslibs.php:358 plgSystemAxslibs->onAfterInitialise() Copy JROOT/libraries/joomla/event/event.php:707 JEvent->update() Copy JROOT/libraries/joomla/event/dispatcher.php:1606 JEventDispatcher->trigger() Copy JROOT/libraries/joomla/application/base.php:1065 JApplicationBase->triggerEvent() Copy JROOT/libraries/cms/application/cms.php:7484 JApplicationCms->initialiseApp() Copy JROOT/libraries/cms/application/site.php:6903 JApplicationSite->initialiseApp() Copy JROOT/libraries/cms/application/site.php:2092 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2731 JApplicationCms->execute() Copy JROOT/index.php:72
Query Time: 1.33 ms After last query: 0.04 ms Query memory: 0.030 MB Memory before query: 8.341 MB Rows returned: 19
SELECT * FROM joom_languages WHERE published = 1 ORDER BY `title`EXPLAIN not possible on query: SELECT * FROM joom_languages WHERE published = 1 ORDER BY `title`
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.02 ms preparing 0.03 ms executing 0.17 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms
# Caller File and line number 14 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172613 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/axslibs/language.php:34212 AxsLanguage::getPublishedLanguages() Copy JROOT/libraries/axslibs/language.php:25111 AxsLanguage::getCurrentLanguage() Copy JROOT/libraries/axslibs/brands.php:37910 AxsBrands::getBrandObject() Copy JROOT/libraries/axslibs/brands.php:559 AxsBrands::getBrand() Copy JROOT/plugins/system/axslibs/axslibs.php:358 plgSystemAxslibs->onAfterInitialise() Copy JROOT/libraries/joomla/event/event.php:707 JEvent->update() Copy JROOT/libraries/joomla/event/dispatcher.php:1606 JEventDispatcher->trigger() Copy JROOT/libraries/joomla/application/base.php:1065 JApplicationBase->triggerEvent() Copy JROOT/libraries/cms/application/cms.php:7484 JApplicationCms->initialiseApp() Copy JROOT/libraries/cms/application/site.php:6903 JApplicationSite->initialiseApp() Copy JROOT/libraries/cms/application/site.php:2092 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2731 JApplicationCms->execute() Copy JROOT/index.php:72
Query Time: 1.21 ms After last query: 0.04 ms Query memory: 0.021 MB Memory before query: 8.365 MB Rows returned: 1
SELECT * FROM `axs_homepage_templates` WHERE id= '1'EXPLAIN not possible on query: SELECT * FROM `axs_homepage_templates` 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.02 ms statistics 0.04 ms preparing 0.01 ms executing 0.02 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.00 ms
# Caller File and line number 12 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172611 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/axslibs/brands.php:39610 AxsBrands::getBrandObject() Copy JROOT/libraries/axslibs/brands.php:559 AxsBrands::getBrand() Copy JROOT/plugins/system/axslibs/axslibs.php:358 plgSystemAxslibs->onAfterInitialise() Copy JROOT/libraries/joomla/event/event.php:707 JEvent->update() Copy JROOT/libraries/joomla/event/dispatcher.php:1606 JEventDispatcher->trigger() Copy JROOT/libraries/joomla/application/base.php:1065 JApplicationBase->triggerEvent() Copy JROOT/libraries/cms/application/cms.php:7484 JApplicationCms->initialiseApp() Copy JROOT/libraries/cms/application/site.php:6903 JApplicationSite->initialiseApp() Copy JROOT/libraries/cms/application/site.php:2092 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2731 JApplicationCms->execute() Copy JROOT/index.php:72
Query Time: 1.55 ms After last query: 0.07 ms Query memory: 0.021 MB Memory before query: 8.406 MB Rows returned: 1
SELECT * FROM `axs_dashboard_templates` WHERE id= '2'EXPLAIN not possible on query: SELECT * FROM `axs_dashboard_templates` WHERE id='2'
Status Duration starting 0.05 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.34 ms Opening tables 0.04 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.04 ms preparing 0.01 ms executing 0.02 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms
# Caller File and line number 12 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172611 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/axslibs/brands.php:41410 AxsBrands::getBrandObject() Copy JROOT/libraries/axslibs/brands.php:559 AxsBrands::getBrand() Copy JROOT/plugins/system/axslibs/axslibs.php:358 plgSystemAxslibs->onAfterInitialise() Copy JROOT/libraries/joomla/event/event.php:707 JEvent->update() Copy JROOT/libraries/joomla/event/dispatcher.php:1606 JEventDispatcher->trigger() Copy JROOT/libraries/joomla/application/base.php:1065 JApplicationBase->triggerEvent() Copy JROOT/libraries/cms/application/cms.php:7484 JApplicationCms->initialiseApp() Copy JROOT/libraries/cms/application/site.php:6903 JApplicationSite->initialiseApp() Copy JROOT/libraries/cms/application/site.php:2092 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2731 JApplicationCms->execute() Copy JROOT/index.php:72
Query Time: 1.18 ms After last query: 0.05 ms Query memory: 0.022 MB Memory before query: 8.426 MB Rows returned: 1
SELECT *
FROM axs_email_settings
WHERE id = '1'EXPLAIN not possible on query: SELECT *
FROM axs_email_settings
WHERE id = '1'
Status Duration starting 0.05 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.01 ms executing 0.01 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms
# Caller File and line number 13 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:168712 JDatabaseDriver->loadObject() Copy JROOT/libraries/axslibs/brands.php:64011 AxsBrands::getEmailSettingsById() Copy JROOT/libraries/axslibs/brands.php:41710 AxsBrands::getBrandObject() Copy JROOT/libraries/axslibs/brands.php:559 AxsBrands::getBrand() Copy JROOT/plugins/system/axslibs/axslibs.php:358 plgSystemAxslibs->onAfterInitialise() Copy JROOT/libraries/joomla/event/event.php:707 JEvent->update() Copy JROOT/libraries/joomla/event/dispatcher.php:1606 JEventDispatcher->trigger() Copy JROOT/libraries/joomla/application/base.php:1065 JApplicationBase->triggerEvent() Copy JROOT/libraries/cms/application/cms.php:7484 JApplicationCms->initialiseApp() Copy JROOT/libraries/cms/application/site.php:6903 JApplicationSite->initialiseApp() Copy JROOT/libraries/cms/application/site.php:2092 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2731 JApplicationCms->execute() Copy JROOT/index.php:72
Query Time: 1.13 ms After last query: 0.04 ms Query memory: 0.022 MB Memory before query: 8.433 MB Rows returned: 1
SELECT *
FROM axs_payment_gateways
WHERE id = '1'EXPLAIN not possible on query: SELECT *
FROM axs_payment_gateways
WHERE id = '1'
Status Duration starting 0.04 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.01 ms executing 0.01 ms end 0.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
# Caller File and line number 13 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:168712 JDatabaseDriver->loadObject() Copy JROOT/libraries/axslibs/brands.php:59011 AxsBrands::getPaymentGatewayById() Copy JROOT/libraries/axslibs/brands.php:42010 AxsBrands::getBrandObject() Copy JROOT/libraries/axslibs/brands.php:559 AxsBrands::getBrand() Copy JROOT/plugins/system/axslibs/axslibs.php:358 plgSystemAxslibs->onAfterInitialise() Copy JROOT/libraries/joomla/event/event.php:707 JEvent->update() Copy JROOT/libraries/joomla/event/dispatcher.php:1606 JEventDispatcher->trigger() Copy JROOT/libraries/joomla/application/base.php:1065 JApplicationBase->triggerEvent() Copy JROOT/libraries/cms/application/cms.php:7484 JApplicationCms->initialiseApp() Copy JROOT/libraries/cms/application/site.php:6903 JApplicationSite->initialiseApp() Copy JROOT/libraries/cms/application/site.php:2092 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2731 JApplicationCms->execute() Copy JROOT/index.php:72
Query Time: 1.16 ms After last query: 0.06 ms Query memory: 0.022 MB Memory before query: 8.447 MB Rows returned: 1
SELECT *
FROM axs_integrations
WHERE id = '1'EXPLAIN not possible on query: SELECT *
FROM axs_integrations
WHERE id = '1'
Status Duration starting 0.05 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.01 ms executing 0.01 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.00 ms
# Caller File and line number 13 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:168712 JDatabaseDriver->loadObject() Copy JROOT/libraries/axslibs/brands.php:66711 AxsBrands::getIntegrationById() Copy JROOT/libraries/axslibs/brands.php:42610 AxsBrands::getBrandObject() Copy JROOT/libraries/axslibs/brands.php:559 AxsBrands::getBrand() Copy JROOT/plugins/system/axslibs/axslibs.php:358 plgSystemAxslibs->onAfterInitialise() Copy JROOT/libraries/joomla/event/event.php:707 JEvent->update() Copy JROOT/libraries/joomla/event/dispatcher.php:1606 JEventDispatcher->trigger() Copy JROOT/libraries/joomla/application/base.php:1065 JApplicationBase->triggerEvent() Copy JROOT/libraries/cms/application/cms.php:7484 JApplicationCms->initialiseApp() Copy JROOT/libraries/cms/application/site.php:6903 JApplicationSite->initialiseApp() Copy JROOT/libraries/cms/application/site.php:2092 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2731 JApplicationCms->execute() Copy JROOT/index.php:72
Query Time: 2.37 ms After last query: 9.36 ms Query memory: 0.101 MB Memory before query: 10.160 MB Rows returned: 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.lftEXPLAIN not possible on query: SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM joom_menu AS m
LEFT JOIN joom_extensions AS e ON m.component_id = e.extension_id
WHERE m.published = 1 AND m.parent_id > 0 AND m.client_id = 0
ORDER BY m.lft
Status Duration starting 0.12 ms Executing hook on transaction 0.01 ms starting 0.02 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.11 ms preparing 0.06 ms executing 0.95 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms
# Caller File and line number 22 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172621 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/cms/menu/site.php:8820 JMenuSite->{closure}() Copy JROOT/libraries/joomla/cache/controller/callback.php:16919 JCacheControllerCallback->get() Copy JROOT/libraries/cms/menu/site.php:9618 JMenuSite->load() Copy JROOT/libraries/cms/menu/menu.php:7417 JMenu->__construct() Copy JROOT/libraries/cms/menu/site.php:5716 JMenuSite->__construct() Copy JROOT/libraries/cms/menu/menu.php:12915 JMenu::getInstance() Copy JROOT/libraries/cms/application/cms.php:50814 JApplicationCms->getMenu() Copy JROOT/libraries/cms/application/site.php:27713 JApplicationSite->getMenu() Copy JROOT/libraries/cms/router/site.php:5912 JRouterSite->__construct() Copy JROOT/libraries/cms/router/router.php:19811 JRouter::getInstance() Copy JROOT/libraries/cms/application/cms.php:61310 JApplicationCms::getRouter() Copy JROOT/libraries/cms/application/site.php:4079 JApplicationSite::getRouter() Copy JROOT/plugins/system/languagefilter/languagefilter.php:1348 PlgSystemLanguageFilter->onAfterInitialise() Copy JROOT/libraries/joomla/event/event.php:707 JEvent->update() Copy JROOT/libraries/joomla/event/dispatcher.php:1606 JEventDispatcher->trigger() Copy JROOT/libraries/joomla/application/base.php:1065 JApplicationBase->triggerEvent() Copy JROOT/libraries/cms/application/cms.php:7484 JApplicationCms->initialiseApp() Copy JROOT/libraries/cms/application/site.php:6903 JApplicationSite->initialiseApp() Copy JROOT/libraries/cms/application/site.php:2092 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2731 JApplicationCms->execute() Copy JROOT/index.php:72
Query Time: 3.46 ms After last query: 8.75 ms Query memory: 0.028 MB Memory before query: 11.682 MB Rows returned: 17
SHOW FULL COLUMNS FROM `joom_users `EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `joom_users`
Status Duration starting 0.11 ms Executing hook on transaction 0.01 ms starting 0.08 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.74 ms init 0.02 ms System lock 0.02 ms optimizing 0.03 ms statistics 0.18 ms preparing 0.06 ms Creating tmp table 0.10 ms executing 0.13 ms checking permissions 0.11 ms checking permissions 0.06 ms checking permissions 0.05 ms checking permissions 0.04 ms checking permissions 0.03 ms checking permissions 0.04 ms checking permissions 0.04 ms checking permissions 0.04 ms checking permissions 0.03 ms checking permissions 0.03 ms checking permissions 0.02 ms checking permissions 0.05 ms checking permissions 0.05 ms checking permissions 0.03 ms checking permissions 0.03 ms checking permissions 0.03 ms checking permissions 0.03 ms checking permissions 0.01 ms checking permissions 0.08 ms end 0.02 ms query end 0.01 ms waiting for handler commit 0.03 ms closing tables 0.02 ms freeing items 0.11 ms cleaning up 0.03 ms
# Caller File and line number 20 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172619 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/joomla/database/driver/mysqli.php:42118 JDatabaseDriverMysqli->getTableColumns() Copy JROOT/libraries/joomla/table/table.php:24417 JTable->getFields() Copy JROOT/libraries/joomla/table/table.php:16316 JTable->__construct() Copy JROOT/libraries/joomla/table/user.php:3915 JTableUser->__construct() Copy JROOT/libraries/joomla/table/table.php:31114 JTable::getInstance() Copy JROOT/libraries/joomla/user/user.php:59813 JUser::getTable() Copy JROOT/libraries/joomla/user/user.php:78212 JUser->save() Copy JROOT/plugins/system/languagefilter/languagefilter.php:84811 PlgSystemLanguageFilter->setPreferredLanguage() Copy JROOT/plugins/system/languagefilter/languagefilter.php:51210 PlgSystemLanguageFilter->parseRule() Copy JROOT/libraries/cms/router/router.php:5979 JRouter->processParseRules() Copy JROOT/libraries/cms/router/site.php:5848 JRouterSite->processParseRules() Copy JROOT/libraries/cms/router/router.php:5717 JRouter->_processParseRules() Copy JROOT/libraries/cms/router/router.php:2256 JRouter->parse() Copy JROOT/libraries/cms/router/site.php:1335 JRouterSite->parse() Copy JROOT/libraries/cms/application/cms.php:12284 JApplicationCms->route() Copy JROOT/libraries/cms/application/site.php:8003 JApplicationSite->route() Copy JROOT/libraries/cms/application/site.php:2152 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2731 JApplicationCms->execute() Copy JROOT/index.php:72
Query Time: 1.30 ms After last query: 0.26 ms Query memory: 0.022 MB Memory before query: 11.726 MB Rows returned: 1
SELECT `id`,`title`
FROM `joom_usergroups `
WHERE `id` = 1EXPLAIN not possible on query: SELECT `id`,`title`
FROM `joom_usergroups`
WHERE `id` = 1
Status Duration starting 0.09 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.04 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.06 ms preparing 0.02 ms executing 0.01 ms end 0.02 ms query end 0.00 ms waiting for handler commit 0.02 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.01 ms
# Caller File and line number 15 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:153114 JDatabaseDriver->loadAssocList() Copy JROOT/libraries/joomla/table/user.php:15213 JTableUser->bind() Copy JROOT/libraries/joomla/user/user.php:78412 JUser->save() Copy JROOT/plugins/system/languagefilter/languagefilter.php:84811 PlgSystemLanguageFilter->setPreferredLanguage() Copy JROOT/plugins/system/languagefilter/languagefilter.php:51210 PlgSystemLanguageFilter->parseRule() Copy JROOT/libraries/cms/router/router.php:5979 JRouter->processParseRules() Copy JROOT/libraries/cms/router/site.php:5848 JRouterSite->processParseRules() Copy JROOT/libraries/cms/router/router.php:5717 JRouter->_processParseRules() Copy JROOT/libraries/cms/router/router.php:2256 JRouter->parse() Copy JROOT/libraries/cms/router/site.php:1335 JRouterSite->parse() Copy JROOT/libraries/cms/application/cms.php:12284 JApplicationCms->route() Copy JROOT/libraries/cms/application/site.php:8003 JApplicationSite->route() Copy JROOT/libraries/cms/application/site.php:2152 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2731 JApplicationCms->execute() Copy JROOT/index.php:72
Query Time: 1.20 ms After last query: 12.51 ms Query memory: 0.019 MB Memory before query: 12.333 MB Rows returned: 0
SELECT params
FROM axs_user_settings
WHERE id = 1EXPLAIN not possible on query: SELECT params
FROM axs_user_settings
WHERE id = 1
Status Duration starting 0.07 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.04 ms executing 0.01 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms
# Caller File and line number 7 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:16876 JDatabaseDriver->loadObject() Copy JROOT/libraries/axslibs/user.php:7075 AxsUser::getGlobalUserSettings() Copy JROOT/libraries/axslibs/security.php:354 AxsSecurity::getSettings() Copy JROOT/libraries/cms/application/cms.php:3853 JApplicationCms->checkUserRequireTwoFactor() Copy JROOT/libraries/cms/application/site.php:2312 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2731 JApplicationCms->execute() Copy JROOT/index.php:72
Query Time: 1.43 ms After last query: 1.94 ms Query memory: 0.019 MB Memory before query: 12.723 MB Rows returned: 0
SELECT *
FROM `joom_users `
WHERE `id` = 0EXPLAIN not possible on query: SELECT *
FROM `joom_users`
WHERE `id` = 0
Status Duration starting 0.09 ms Executing hook on transaction 0.01 ms starting 0.02 ms checking permissions 0.01 ms Opening tables 0.05 ms init 0.01 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.06 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.05 ms cleaning up 0.01 ms
# Caller File and line number 6 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:16875 JDatabaseDriver->loadObject() Copy JROOT/administrator/components/com_users/models/user.php:9924 UsersModelUser->getOtpConfig() Copy JROOT/libraries/cms/application/cms.php:3893 JApplicationCms->checkUserRequireTwoFactor() Copy JROOT/libraries/cms/application/site.php:2312 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2731 JApplicationCms->execute() Copy JROOT/index.php:72
Query Time: 1.57 ms After last query: 0.12 ms Query memory: 0.019 MB Memory before query: 12.734 MB Rows returned: 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 = 1EXPLAIN not possible on query: SELECT id, home, template, s.params
FROM joom_template_styles as s
LEFT JOIN joom_extensions as e ON e.element=s.template AND e.type='template' AND e.client_id=s.client_id
WHERE s.client_id = 0 AND e.enabled = 1
Status Duration starting 0.10 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.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.09 ms preparing 0.05 ms executing 0.18 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.01 ms closing tables 0.02 ms freeing items 0.05 ms cleaning up 0.01 ms
# Caller File and line number 6 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:17265 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/cms/application/site.php:4904 JApplicationSite->getTemplate() Copy JROOT/libraries/cms/application/site.php:1653 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2731 JApplicationCms->execute() Copy JROOT/index.php:72
Query Time: 1.30 ms After last query: 16.60 ms Query memory: 0.024 MB Memory before query: 15.260 MB Rows returned: 1
SELECT *
FROM axs_lms_settings
WHERE id= 1 LIMIT 1EXPLAIN not possible on query: SELECT *
FROM axs_lms_settings
WHERE id=1 LIMIT 1
Status Duration starting 0.08 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.04 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.01 ms executing 0.01 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.01 ms
# Caller File and line number 17 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:168716 JDatabaseDriver->loadObject() Copy JROOT/libraries/axslibs/lms.php:193615 AxsLMS::getSettings() Copy JROOT/components/com_splms/models/courses.php:3514 SplmsModelCourses->__construct() Copy JROOT/libraries/fof/model/model.php:34713 FOFModel::getAnInstance() Copy JROOT/libraries/fof/controller/controller.php:254712 FOFController->createModel() Copy JROOT/libraries/fof/controller/controller.php:232011 FOFController->getModel() Copy JROOT/libraries/fof/controller/controller.php:228210 FOFController->getThisModel() Copy JROOT/components/com_splms/controllers/courses.php:209 SplmsControllerCourses->onBeforeBrowse() Copy JROOT/libraries/fof/controller/controller.php:9228 FOFController->execute() Copy JROOT/libraries/fof/dispatcher/dispatcher.php:3287 FOFDispatcher->dispatch() Copy JROOT/components/com_splms/splms.php:356 require_once Copy JROOT/components/com_splms/splms.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2731 JApplicationCms->execute() Copy JROOT/index.php:72
Query Time: 1.70 ms After last query: 7.99 ms Query memory: 0.027 MB Memory before query: 16.860 MB Rows returned: 0
SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state
FROM joom_fields AS a
LEFT JOIN `joom_languages ` AS l ON l.lang_code = a.language
LEFT JOIN joom_users AS uc ON uc.id= a.checked_out
LEFT JOIN joom_viewlevels AS ag ON ag.id = a.access
LEFT JOIN joom_users AS ua ON ua.id = a.created_user_id
LEFT JOIN joom_fields_groups AS g ON g.id = a.group_id
WHERE a.context = 'com_splms.courses.form.default' AND a.access IN (1,1) AND (a.group_id = 0 OR g.access IN (1,1)) AND a.state = 1 AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering ASC EXPLAIN not possible on query: SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state
FROM joom_fields AS a
LEFT JOIN `joom_languages` AS l ON l.lang_code = a.language
LEFT JOIN joom_users AS uc ON uc.id=a.checked_out
LEFT JOIN joom_viewlevels AS ag ON ag.id = a.access
LEFT JOIN joom_users AS ua ON ua.id = a.created_user_id
LEFT JOIN joom_fields_groups AS g ON g.id = a.group_id
WHERE a.context = 'com_splms.courses.form.default' AND a.access IN (1,1) AND (a.group_id = 0 OR g.access IN (1,1)) AND a.state = 1 AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering ASC
Status Duration starting 0.16 ms Executing hook on transaction 0.01 ms starting 0.02 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.01 ms checking permissions 0.00 ms Opening tables 0.10 ms init 0.01 ms System lock 0.01 ms optimizing 0.05 ms statistics 0.14 ms preparing 0.06 ms executing 0.05 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.02 ms freeing items 0.05 ms cleaning up 0.01 ms
# Caller File and line number 24 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172623 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/legacy/model/legacy.php:30722 JModelLegacy->_getList() Copy JROOT/administrator/components/com_fields/models/fields.php:32621 FieldsModelFields->_getList() Copy JROOT/libraries/legacy/model/list.php:18920 JModelList->getItems() Copy JROOT/administrator/components/com_fields/helpers/fields.php:13419 FieldsHelper::getFields() Copy JROOT/administrator/components/com_fields/helpers/fields.php:28318 FieldsHelper::prepareForm() Copy JROOT/plugins/system/fields/fields.php:23617 PlgSystemFields->onContentPrepareForm() Copy JROOT/libraries/joomla/event/event.php:7016 JEvent->update() Copy JROOT/libraries/joomla/event/dispatcher.php:16015 JEventDispatcher->trigger() Copy JROOT/libraries/joomla/application/base.php:10614 JApplicationBase->triggerEvent() Copy JROOT/libraries/fof/integration/joomla/platform.php:54513 FOFIntegrationJoomlaPlatform->runPlugins() Copy JROOT/libraries/fof/model/model.php:266912 FOFModel->preprocessForm() Copy JROOT/libraries/fof/model/model.php:251411 FOFModel->loadForm() Copy JROOT/libraries/fof/model/model.php:242410 FOFModel->getForm() Copy JROOT/libraries/fof/controller/controller.php:11619 FOFController->browse() Copy JROOT/libraries/fof/controller/controller.php:9708 FOFController->execute() Copy JROOT/libraries/fof/dispatcher/dispatcher.php:3287 FOFDispatcher->dispatch() Copy JROOT/components/com_splms/splms.php:356 require_once Copy JROOT/components/com_splms/splms.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2731 JApplicationCms->execute() Copy JROOT/index.php:72
Query Time: 1.94 ms After last query: 6.21 ms Query memory: 0.031 MB Memory before query: 17.400 MB Rows returned: 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` = 0EXPLAIN not possible on query: 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.11 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.08 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.26 ms preparing 0.05 ms executing 0.37 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.01 ms
# Caller File and line number 23 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172622 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/joomla/access/access.php:42721 JAccess::preloadComponents() Copy JROOT/libraries/joomla/access/access.php:21120 JAccess::preload() Copy JROOT/libraries/joomla/access/access.php:53019 JAccess::getAssetRules() Copy JROOT/libraries/joomla/access/access.php:18118 JAccess::check() Copy JROOT/libraries/joomla/user/user.php:39317 JUser->authorise() Copy JROOT/libraries/fof/integration/joomla/platform.php:58416 FOFIntegrationJoomlaPlatform->authorise() Copy JROOT/libraries/fof/view/raw.php:8015 FOFViewRaw->__construct() Copy JROOT/libraries/fof/view/html.php:5314 FOFViewHtml->__construct() Copy JROOT/libraries/fof/controller/controller.php:281113 FOFController->createView() Copy JROOT/libraries/fof/controller/controller.php:250612 FOFController->getView() Copy JROOT/libraries/fof/controller/controller.php:240811 FOFController->getThisView() Copy JROOT/libraries/fof/controller/controller.php:102810 FOFController->display() Copy JROOT/libraries/fof/controller/controller.php:11689 FOFController->browse() Copy JROOT/libraries/fof/controller/controller.php:9708 FOFController->execute() Copy JROOT/libraries/fof/dispatcher/dispatcher.php:3287 FOFDispatcher->dispatch() Copy JROOT/components/com_splms/splms.php:356 require_once Copy JROOT/components/com_splms/splms.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2731 JApplicationCms->execute() Copy JROOT/index.php:72
Query Time: 10.02 ms After last query: 0.56 ms Query memory: 0.065 MB Memory before query: 17.526 MB Rows returned: 738
SHOW TABLES EXPLAIN not possible on query: SHOW TABLES
Status Duration checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.05 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.10 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.06 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.05 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.05 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.03 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.20 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.03 ms closing tables 0.02 ms freeing items 0.08 ms cleaning up 0.01 ms
# Caller File and line number 22 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:157521 JDatabaseDriver->loadColumn() Copy JROOT/libraries/joomla/database/driver/mysqli.php:47720 JDatabaseDriverMysqli->getTableList() Copy JROOT/libraries/fof/database/driver/joomla.php:25119 FOFDatabaseDriverJoomla->getTableList() Copy JROOT/libraries/fof/table/table.php:209618 FOFTable->getTableFields() Copy JROOT/libraries/fof/table/table.php:53617 FOFTable->__construct() Copy JROOT/libraries/fof/table/table.php:43316 FOFTable::getAnInstance() Copy JROOT/libraries/fof/model/model.php:209915 FOFModel->_createTable() Copy JROOT/libraries/fof/model/model.php:205614 FOFModel->getTable() Copy JROOT/libraries/fof/view/raw.php:19013 FOFViewRaw->onDisplay() Copy JROOT/libraries/fof/view/raw.php:16712 FOFViewRaw->onBrowse() Copy JROOT/libraries/fof/view/form.php:4711 FOFViewForm->display() Copy JROOT/libraries/fof/controller/controller.php:112810 FOFController->display() Copy JROOT/libraries/fof/controller/controller.php:11689 FOFController->browse() Copy JROOT/libraries/fof/controller/controller.php:9708 FOFController->execute() Copy JROOT/libraries/fof/dispatcher/dispatcher.php:3287 FOFDispatcher->dispatch() Copy JROOT/components/com_splms/splms.php:356 require_once Copy JROOT/components/com_splms/splms.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2731 JApplicationCms->execute() Copy JROOT/index.php:72
Query Time: 2.99 ms After last query: 0.15 ms Query memory: 0.034 MB Memory before query: 17.608 MB Rows returned: 41
SHOW FULL COLUMNS FROM `joom_splms_courses `EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `joom_splms_courses`
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.46 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.10 ms preparing 0.03 ms Creating tmp table 0.05 ms executing 0.08 ms checking permissions 0.06 ms checking permissions 0.03 ms checking permissions 0.02 ms checking permissions 0.04 ms checking permissions 0.03 ms checking permissions 0.03 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.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.03 ms checking permissions 0.03 ms checking permissions 0.03 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.03 ms checking permissions 0.02 ms checking permissions 0.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.01 ms checking permissions 0.07 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.02 ms closing tables 0.02 ms freeing items 0.07 ms cleaning up 0.01 ms
# Caller File and line number 22 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172621 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/joomla/database/driver/mysqli.php:42120 JDatabaseDriverMysqli->getTableColumns() Copy JROOT/libraries/fof/database/driver/joomla.php:22919 FOFDatabaseDriverJoomla->getTableColumns() Copy JROOT/libraries/fof/table/table.php:218118 FOFTable->getTableFields() Copy JROOT/libraries/fof/table/table.php:53617 FOFTable->__construct() Copy JROOT/libraries/fof/table/table.php:43316 FOFTable::getAnInstance() Copy JROOT/libraries/fof/model/model.php:209915 FOFModel->_createTable() Copy JROOT/libraries/fof/model/model.php:205614 FOFModel->getTable() Copy JROOT/libraries/fof/view/raw.php:19013 FOFViewRaw->onDisplay() Copy JROOT/libraries/fof/view/raw.php:16712 FOFViewRaw->onBrowse() Copy JROOT/libraries/fof/view/form.php:4711 FOFViewForm->display() Copy JROOT/libraries/fof/controller/controller.php:112810 FOFController->display() Copy JROOT/libraries/fof/controller/controller.php:11689 FOFController->browse() Copy JROOT/libraries/fof/controller/controller.php:9708 FOFController->execute() Copy JROOT/libraries/fof/dispatcher/dispatcher.php:3287 FOFDispatcher->dispatch() Copy JROOT/components/com_splms/splms.php:356 require_once Copy JROOT/components/com_splms/splms.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2731 JApplicationCms->execute() Copy JROOT/index.php:72
Query Time: 1.36 ms After last query: 0.74 ms Query memory: 0.026 MB Memory before query: 17.806 MB Rows returned: 2
SELECT *
FROM `joom_splms_coursescategories `
WHERE enabled = 1 AND ( ( brand_specific = 1 AND FIND_IN_SET ( 1, brands ) > 0 ) OR ( brand_specific = 0 )) AND ( ( access_type = 'access' AND ( ( FIND_IN_SET ( 1, accesslevel ) > 0 ) OR ( FIND_IN_SET ( 1, accesslevel ) > 0 ) ) ) OR ( access_type = 'user' AND ( ( FIND_IN_SET ( 1, usergroup ) > 0 ) ) ) OR ( access_type = 'list' AND ( FIND_IN_SET ( 0, userlist ) > 0 ) ) OR ( access_type = 'none' OR access_type IS NULL ) )
ORDER BY ordering ASC EXPLAIN not possible on query: SELECT *
FROM `joom_splms_coursescategories`
WHERE enabled = 1 AND ( ( brand_specific = 1 AND FIND_IN_SET( 1, brands ) > 0 ) OR ( brand_specific = 0 )) AND ( ( access_type = 'access' AND ( ( FIND_IN_SET( 1, accesslevel ) > 0 ) OR ( FIND_IN_SET( 1, accesslevel ) > 0 ) ) ) OR ( access_type = 'user' AND ( ( FIND_IN_SET( 1, usergroup ) > 0 ) ) ) OR ( access_type = 'list' AND ( FIND_IN_SET( 0, userlist ) > 0 ) ) OR ( access_type = 'none' OR access_type IS NULL ) )
ORDER BY ordering ASC
Status Duration starting 0.10 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.05 ms init 0.01 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.03 ms preparing 0.04 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
# Caller File and line number 19 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172618 JDatabaseDriver->loadObjectList() Copy JROOT/components/com_splms/models/courses.php:52417 SplmsModelCourses->getAllCategories() Copy JROOT/components/com_splms/models/courses.php:9816 SplmsModelCourses->getCategoryConditions() Copy JROOT/components/com_splms/models/courses.php:14915 SplmsModelCourses->getAllCourses() Copy JROOT/components/com_splms/models/courses.php:8314 SplmsModelCourses->getItemList() Copy JROOT/libraries/fof/view/raw.php:19813 FOFViewRaw->onDisplay() Copy JROOT/libraries/fof/view/raw.php:16712 FOFViewRaw->onBrowse() Copy JROOT/libraries/fof/view/form.php:4711 FOFViewForm->display() Copy JROOT/libraries/fof/controller/controller.php:112810 FOFController->display() Copy JROOT/libraries/fof/controller/controller.php:11689 FOFController->browse() Copy JROOT/libraries/fof/controller/controller.php:9708 FOFController->execute() Copy JROOT/libraries/fof/dispatcher/dispatcher.php:3287 FOFDispatcher->dispatch() Copy JROOT/components/com_splms/splms.php:356 require_once Copy JROOT/components/com_splms/splms.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2731 JApplicationCms->execute() Copy JROOT/index.php:72
Query Time: 1.42 ms After last query: 0.04 ms Query memory: 0.048 MB Memory before query: 17.814 MB Rows returned: 7
SELECT *
FROM `joom_splms_courses `
WHERE `enabled`= 1 AND ( ( access_type = 'access' AND ( ( FIND_IN_SET ( 1, accesslevel ) > 0 ) OR ( FIND_IN_SET ( 1, accesslevel ) > 0 ) ) ) OR ( access_type = 'user' AND ( ( FIND_IN_SET ( 1, usergroup ) > 0 ) ) ) OR ( access_type = 'list' AND ( FIND_IN_SET ( 0, userlist ) > 0 ) ) OR ( access_type = 'none' OR access_type IS NULL ) ) AND ((FIND_IN_SET ('1', splms_coursescategory_id) > 0)OR (FIND_IN_SET ('6', splms_coursescategory_id) > 0)) AND ( ( brand_specific = 1 AND FIND_IN_SET ( 1, brands ) > 0 ) OR ( brand_specific = 0 ))
ORDER BY ordering ASC LIMIT 32EXPLAIN not possible on query: SELECT *
FROM `joom_splms_courses`
WHERE `enabled`=1 AND ( ( access_type = 'access' AND ( ( FIND_IN_SET( 1, accesslevel ) > 0 ) OR ( FIND_IN_SET( 1, accesslevel ) > 0 ) ) ) OR ( access_type = 'user' AND ( ( FIND_IN_SET( 1, usergroup ) > 0 ) ) ) OR ( access_type = 'list' AND ( FIND_IN_SET( 0, userlist ) > 0 ) ) OR ( access_type = 'none' OR access_type IS NULL ) ) AND ((FIND_IN_SET('1', splms_coursescategory_id) > 0)OR(FIND_IN_SET('6', splms_coursescategory_id) > 0)) AND ( ( brand_specific = 1 AND FIND_IN_SET( 1, brands ) > 0 ) OR ( brand_specific = 0 ))
ORDER BY ordering ASC LIMIT 32
Status Duration starting 0.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.03 ms statistics 0.03 ms preparing 0.03 ms executing 0.19 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms
# Caller File and line number 17 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172616 JDatabaseDriver->loadObjectList() Copy JROOT/components/com_splms/models/courses.php:16215 SplmsModelCourses->getAllCourses() Copy JROOT/components/com_splms/models/courses.php:8314 SplmsModelCourses->getItemList() Copy JROOT/libraries/fof/view/raw.php:19813 FOFViewRaw->onDisplay() Copy JROOT/libraries/fof/view/raw.php:16712 FOFViewRaw->onBrowse() Copy JROOT/libraries/fof/view/form.php:4711 FOFViewForm->display() Copy JROOT/libraries/fof/controller/controller.php:112810 FOFController->display() Copy JROOT/libraries/fof/controller/controller.php:11689 FOFController->browse() Copy JROOT/libraries/fof/controller/controller.php:9708 FOFController->execute() Copy JROOT/libraries/fof/dispatcher/dispatcher.php:3287 FOFDispatcher->dispatch() Copy JROOT/components/com_splms/splms.php:356 require_once Copy JROOT/components/com_splms/splms.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2731 JApplicationCms->execute() Copy JROOT/index.php:72
Query Time: 1.25 ms After last query: 0.04 ms Query memory: 0.024 MB Memory before query: 17.855 MB Rows returned: 1
SELECT COUNT (* ) as total
FROM `joom_splms_courses `
WHERE `enabled`= 1 AND ( ( access_type = 'access' AND ( ( FIND_IN_SET ( 1, accesslevel ) > 0 ) OR ( FIND_IN_SET ( 1, accesslevel ) > 0 ) ) ) OR ( access_type = 'user' AND ( ( FIND_IN_SET ( 1, usergroup ) > 0 ) ) ) OR ( access_type = 'list' AND ( FIND_IN_SET ( 0, userlist ) > 0 ) ) OR ( access_type = 'none' OR access_type IS NULL ) ) AND ((FIND_IN_SET ('1', splms_coursescategory_id) > 0)OR (FIND_IN_SET ('6', splms_coursescategory_id) > 0)) AND ( ( brand_specific = 1 AND FIND_IN_SET ( 1, brands ) > 0 ) OR ( brand_specific = 0 ))EXPLAIN not possible on query: SELECT COUNT(*) as total
FROM `joom_splms_courses`
WHERE `enabled`=1 AND ( ( access_type = 'access' AND ( ( FIND_IN_SET( 1, accesslevel ) > 0 ) OR ( FIND_IN_SET( 1, accesslevel ) > 0 ) ) ) OR ( access_type = 'user' AND ( ( FIND_IN_SET( 1, usergroup ) > 0 ) ) ) OR ( access_type = 'list' AND ( FIND_IN_SET( 0, userlist ) > 0 ) ) OR ( access_type = 'none' OR access_type IS NULL ) ) AND ((FIND_IN_SET('1', splms_coursescategory_id) > 0)OR(FIND_IN_SET('6', splms_coursescategory_id) > 0)) AND ( ( brand_specific = 1 AND FIND_IN_SET( 1, brands ) > 0 ) OR ( brand_specific = 0 ))
Status Duration starting 0.08 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.04 ms init 0.01 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.02 ms preparing 0.03 ms executing 0.07 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms
# Caller File and line number 17 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:168716 JDatabaseDriver->loadObject() Copy JROOT/components/com_splms/models/courses.php:16915 SplmsModelCourses->getAllCourses() Copy JROOT/components/com_splms/models/courses.php:8314 SplmsModelCourses->getItemList() Copy JROOT/libraries/fof/view/raw.php:19813 FOFViewRaw->onDisplay() Copy JROOT/libraries/fof/view/raw.php:16712 FOFViewRaw->onBrowse() Copy JROOT/libraries/fof/view/form.php:4711 FOFViewForm->display() Copy JROOT/libraries/fof/controller/controller.php:112810 FOFController->display() Copy JROOT/libraries/fof/controller/controller.php:11689 FOFController->browse() Copy JROOT/libraries/fof/controller/controller.php:9708 FOFController->execute() Copy JROOT/libraries/fof/dispatcher/dispatcher.php:3287 FOFDispatcher->dispatch() Copy JROOT/components/com_splms/splms.php:356 require_once Copy JROOT/components/com_splms/splms.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2731 JApplicationCms->execute() Copy JROOT/index.php:72
Query Time: 1.23 ms After last query: 11.30 ms Query memory: 0.024 MB Memory before query: 18.230 MB Rows returned: 0
SELECT id
FROM axs_starred
WHERE user_id = '0' AND uri = '/courses-page'EXPLAIN not possible on query: SELECT id
FROM axs_starred
WHERE user_id = '0' AND uri = '/courses-page'
Status Duration starting 0.05 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.06 ms preparing 0.02 ms executing 0.02 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.00 ms
# Caller File and line number 18 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:168717 JDatabaseDriver->loadObject() Copy JROOT/libraries/axslibs/topbar.php:8216 AxsTopBar::getStarredId() Copy JROOT/administrator/includes/toolbar.php:5215 JToolbarHelper::title() Copy JROOT/administrator/components/com_splms/toolbar.php:5914 SplmsToolbar->onCoursesBrowse() Copy JROOT/libraries/fof/toolbar/toolbar.php:30413 FOFToolbar->renderToolbar() Copy JROOT/libraries/fof/view/html.php:7312 FOFViewHtml->preRender() Copy JROOT/libraries/fof/view/form.php:6311 FOFViewForm->display() Copy JROOT/libraries/fof/controller/controller.php:112810 FOFController->display() Copy JROOT/libraries/fof/controller/controller.php:11689 FOFController->browse() Copy JROOT/libraries/fof/controller/controller.php:9708 FOFController->execute() Copy JROOT/libraries/fof/dispatcher/dispatcher.php:3287 FOFDispatcher->dispatch() Copy JROOT/components/com_splms/splms.php:356 require_once Copy JROOT/components/com_splms/splms.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2731 JApplicationCms->execute() Copy JROOT/index.php:72
Query Time: 1.49 ms After last query: 9.01 ms Query memory: 0.025 MB Memory before query: 19.027 MB Rows returned: 2
SELECT *
FROM `joom_splms_coursescategories `
WHERE enabled = 1 AND ( ( brand_specific = 1 AND FIND_IN_SET ( 1, brands ) > 0 ) OR ( brand_specific = 0 )) AND ( ( access_type = 'access' AND ( ( FIND_IN_SET ( 1, accesslevel ) > 0 ) OR ( FIND_IN_SET ( 1, accesslevel ) > 0 ) ) ) OR ( access_type = 'user' AND ( ( FIND_IN_SET ( 1, usergroup ) > 0 ) ) ) OR ( access_type = 'list' AND ( FIND_IN_SET ( 0, userlist ) > 0 ) ) OR ( access_type = 'none' OR access_type IS NULL ) )
ORDER BY ordering ASC EXPLAIN not possible on query: SELECT *
FROM `joom_splms_coursescategories`
WHERE enabled = 1 AND ( ( brand_specific = 1 AND FIND_IN_SET( 1, brands ) > 0 ) OR ( brand_specific = 0 )) AND ( ( access_type = 'access' AND ( ( FIND_IN_SET( 1, accesslevel ) > 0 ) OR ( FIND_IN_SET( 1, accesslevel ) > 0 ) ) ) OR ( access_type = 'user' AND ( ( FIND_IN_SET( 1, usergroup ) > 0 ) ) ) OR ( access_type = 'list' AND ( FIND_IN_SET( 0, userlist ) > 0 ) ) OR ( access_type = 'none' OR access_type IS NULL ) )
ORDER BY ordering ASC
Status Duration starting 0.11 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.06 ms init 0.01 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.03 ms preparing 0.04 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.04 ms cleaning up 0.01 ms
# Caller File and line number 16 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172615 JDatabaseDriver->loadObjectList() Copy JROOT/components/com_splms/models/courses.php:52414 SplmsModelCourses->getAllCategories() Copy JROOT/components/com_splms/views/courses/tmpl/default.php:35513 include Copy JROOT/components/com_splms/views/courses/tmpl/default.php Copy JROOT/libraries/fof/view/view.php:44212 FOFView->loadAnyTemplate() Copy JROOT/libraries/fof/view/form.php:7611 FOFViewForm->display() Copy JROOT/libraries/fof/controller/controller.php:112810 FOFController->display() Copy JROOT/libraries/fof/controller/controller.php:11689 FOFController->browse() Copy JROOT/libraries/fof/controller/controller.php:9708 FOFController->execute() Copy JROOT/libraries/fof/dispatcher/dispatcher.php:3287 FOFDispatcher->dispatch() Copy JROOT/components/com_splms/splms.php:356 require_once Copy JROOT/components/com_splms/splms.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2731 JApplicationCms->execute() Copy JROOT/index.php:72
Query Time: 1.35 ms After last query: 0.28 ms Query memory: 0.023 MB Memory before query: 19.052 MB Rows returned: 0
SELECT * FROM `joom_splms_course_wishlist ` WHERE `user_id`= 0;EXPLAIN not possible on query: SELECT * FROM `joom_splms_course_wishlist` WHERE `user_id`=0;
Status Duration starting 0.04 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.12 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.02 ms executing 0.02 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms
# Caller File and line number 16 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172615 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/axslibs/lms.php:322714 AxsLMS::getUserAllCourses() Copy JROOT/components/com_splms/views/courses/tmpl/default.php:44813 include Copy JROOT/components/com_splms/views/courses/tmpl/default.php Copy JROOT/libraries/fof/view/view.php:44212 FOFView->loadAnyTemplate() Copy JROOT/libraries/fof/view/form.php:7611 FOFViewForm->display() Copy JROOT/libraries/fof/controller/controller.php:112810 FOFController->display() Copy JROOT/libraries/fof/controller/controller.php:11689 FOFController->browse() Copy JROOT/libraries/fof/controller/controller.php:9708 FOFController->execute() Copy JROOT/libraries/fof/dispatcher/dispatcher.php:3287 FOFDispatcher->dispatch() Copy JROOT/components/com_splms/splms.php:356 require_once Copy JROOT/components/com_splms/splms.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2731 JApplicationCms->execute() Copy JROOT/index.php:72
Query Time: 1.06 ms After last query: 0.04 ms Query memory: 0.008 MB Memory before query: 19.061 MB
SELECT
a.*
FROM
joom_splms_courses_groups a
INNER JOIN joom_splms_assignments_users u ON u.assignment_id = a.id
AND u.user_id = 0
UNION
SELECT
a.*
FROM
joom_splms_courses_groups a
INNER JOIN joom_splms_assignments_usergroups u ON u.assignment_id = a.id
WHERE
(a.all_groups_required = 1 AND (SELECT COUNT (* ) as total from joom_splms_assignments_usergroups ug WHERE ug.assignment_id = a.id
AND ug.usergroup_id IN ()
HAVING total = (SELECT COUNT (* ) as totalGroups from joom_splms_assignments_usergroups v WHERE v.assignment_id = a.id)
))
OR
(a.all_groups_required != 1
AND u.usergroup_id IN ()
)EXPLAIN not possible on query: SELECT
a.*
FROM
joom_splms_courses_groups a
INNER JOIN joom_splms_assignments_users u ON u.assignment_id = a.id
AND u.user_id = 0
UNION
SELECT
a.*
FROM
joom_splms_courses_groups a
INNER JOIN joom_splms_assignments_usergroups u ON u.assignment_id = a.id
WHERE
(a.all_groups_required = 1 AND (SELECT COUNT(*) as total from joom_splms_assignments_usergroups ug WHERE ug.assignment_id = a.id
AND ug.usergroup_id IN ()
HAVING total = (SELECT COUNT(*) as totalGroups from joom_splms_assignments_usergroups v WHERE v.assignment_id = a.id)
))
OR
(a.all_groups_required != 1
AND u.usergroup_id IN ()
)
Status Duration starting 0.07 ms freeing items 0.02 ms cleaning up 0.00 ms
# Caller File and line number 16 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172615 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/axslibs/lms.php:326614 AxsLMS::getUserAllCourses() Copy JROOT/components/com_splms/views/courses/tmpl/default.php:44813 include Copy JROOT/components/com_splms/views/courses/tmpl/default.php Copy JROOT/libraries/fof/view/view.php:44212 FOFView->loadAnyTemplate() Copy JROOT/libraries/fof/view/form.php:7611 FOFViewForm->display() Copy JROOT/libraries/fof/controller/controller.php:112810 FOFController->display() Copy JROOT/libraries/fof/controller/controller.php:11689 FOFController->browse() Copy JROOT/libraries/fof/controller/controller.php:9708 FOFController->execute() Copy JROOT/libraries/fof/dispatcher/dispatcher.php:3287 FOFDispatcher->dispatch() Copy JROOT/components/com_splms/splms.php:356 require_once Copy JROOT/components/com_splms/splms.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2731 JApplicationCms->execute() Copy JROOT/index.php:72
Query Time: 1.24 ms After last query: 1.08 ms Query memory: 0.023 MB Memory before query: 19.068 MB Rows returned: 0
SELECT * FROM `axs_course_purchases` WHERE user_id= 0 AND status= 'PAID ' OR status= 'PART ';EXPLAIN not possible on query: SELECT * FROM `axs_course_purchases` WHERE user_id=0 AND status='PAID' OR status='PART';
Status Duration starting 0.05 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.04 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.06 ms preparing 0.02 ms executing 0.04 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms
# Caller File and line number 16 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172615 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/axslibs/lms.php:331314 AxsLMS::getUserAllCourses() Copy JROOT/components/com_splms/views/courses/tmpl/default.php:44813 include Copy JROOT/components/com_splms/views/courses/tmpl/default.php Copy JROOT/libraries/fof/view/view.php:44212 FOFView->loadAnyTemplate() Copy JROOT/libraries/fof/view/form.php:7611 FOFViewForm->display() Copy JROOT/libraries/fof/controller/controller.php:112810 FOFController->display() Copy JROOT/libraries/fof/controller/controller.php:11689 FOFController->browse() Copy JROOT/libraries/fof/controller/controller.php:9708 FOFController->execute() Copy JROOT/libraries/fof/dispatcher/dispatcher.php:3287 FOFDispatcher->dispatch() Copy JROOT/components/com_splms/splms.php:356 require_once Copy JROOT/components/com_splms/splms.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2731 JApplicationCms->execute() Copy JROOT/index.php:72
Query Time: 1.33 ms After last query: 0.04 ms Query memory: 0.023 MB Memory before query: 19.076 MB Rows returned: 0
SELECT * FROM `joom_splms_course_progress ` WHERE archive_date IS NULL AND `user_id`= 0 GROUP BY user_id, course_id;EXPLAIN not possible on query: SELECT * FROM `joom_splms_course_progress` WHERE archive_date IS NULL AND `user_id`=0 GROUP BY user_id, course_id;
Status Duration starting 0.05 ms Executing hook on transaction 0.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.08 ms preparing 0.02 ms Creating tmp table 0.04 ms executing 0.05 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms
# Caller File and line number 16 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172615 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/axslibs/lms.php:334414 AxsLMS::getUserAllCourses() Copy JROOT/components/com_splms/views/courses/tmpl/default.php:44813 include Copy JROOT/components/com_splms/views/courses/tmpl/default.php Copy JROOT/libraries/fof/view/view.php:44212 FOFView->loadAnyTemplate() Copy JROOT/libraries/fof/view/form.php:7611 FOFViewForm->display() Copy JROOT/libraries/fof/controller/controller.php:112810 FOFController->display() Copy JROOT/libraries/fof/controller/controller.php:11689 FOFController->browse() Copy JROOT/libraries/fof/controller/controller.php:9708 FOFController->execute() Copy JROOT/libraries/fof/dispatcher/dispatcher.php:3287 FOFDispatcher->dispatch() Copy JROOT/components/com_splms/splms.php:356 require_once Copy JROOT/components/com_splms/splms.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2731 JApplicationCms->execute() Copy JROOT/index.php:72
Query Time: 1.13 ms After last query: 0.08 ms Query memory: 0.024 MB Memory before query: 19.083 MB Rows returned: 1
SELECT sef FROM joom_languages WHERE lang_code = 'en-GB ' LIMIT 1EXPLAIN not possible on query: SELECT sef FROM joom_languages WHERE lang_code = 'en-GB' LIMIT 1
Status Duration starting 0.04 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.01 ms executing 0.01 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms
# Caller File and line number 17 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:168716 JDatabaseDriver->loadObject() Copy JROOT/libraries/axslibs/language.php:28515 AxsLanguage::getSefByLangCode() Copy JROOT/components/com_splms/models/courses.php:122414 SplmsModelCourses::setOverrides() Copy JROOT/components/com_splms/views/courses/tmpl/default.php:45413 include Copy JROOT/components/com_splms/views/courses/tmpl/default.php Copy JROOT/libraries/fof/view/view.php:44212 FOFView->loadAnyTemplate() Copy JROOT/libraries/fof/view/form.php:7611 FOFViewForm->display() Copy JROOT/libraries/fof/controller/controller.php:112810 FOFController->display() Copy JROOT/libraries/fof/controller/controller.php:11689 FOFController->browse() Copy JROOT/libraries/fof/controller/controller.php:9708 FOFController->execute() Copy JROOT/libraries/fof/dispatcher/dispatcher.php:3287 FOFDispatcher->dispatch() Copy JROOT/components/com_splms/splms.php:356 require_once Copy JROOT/components/com_splms/splms.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2731 JApplicationCms->execute() Copy JROOT/index.php:72
Query Time: 1.53 ms After last query: 0.79 ms Query memory: 0.024 MB Memory before query: 19.126 MB Rows returned: 1
SELECT *
FROM `joom_splms_lessons `
WHERE `enabled`= '1' AND `splms_course_id`= '1' AND `language`= 'en-GB '
ORDER BY ordering ASC EXPLAIN not possible on query: SELECT *
FROM `joom_splms_lessons`
WHERE `enabled`='1' AND `splms_course_id`='1' AND `language`='en-GB'
ORDER BY ordering ASC
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.04 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.07 ms preparing 0.03 ms executing 0.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
# Caller File and line number 16 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172615 JDatabaseDriver->loadObjectList() Copy JROOT/components/com_splms/models/lessons.php:23814 SplmsModelLessons::getLessons() Copy JROOT/components/com_splms/views/courses/tmpl/default.php:46613 include Copy JROOT/components/com_splms/views/courses/tmpl/default.php Copy JROOT/libraries/fof/view/view.php:44212 FOFView->loadAnyTemplate() Copy JROOT/libraries/fof/view/form.php:7611 FOFViewForm->display() Copy JROOT/libraries/fof/controller/controller.php:112810 FOFController->display() Copy JROOT/libraries/fof/controller/controller.php:11689 FOFController->browse() Copy JROOT/libraries/fof/controller/controller.php:9708 FOFController->execute() Copy JROOT/libraries/fof/dispatcher/dispatcher.php:3287 FOFDispatcher->dispatch() Copy JROOT/components/com_splms/splms.php:356 require_once Copy JROOT/components/com_splms/splms.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2731 JApplicationCms->execute() Copy JROOT/index.php:72
Query Time: 1.27 ms After last query: 0.05 ms Query memory: 0.025 MB Memory before query: 19.139 MB Rows returned: 0
SELECT *
FROM `joom_splms_teachers `
WHERE `enabled`= '1' AND `splms_teacher_id`= '0'
ORDER BY ordering DESC EXPLAIN not possible on query: SELECT *
FROM `joom_splms_teachers`
WHERE `enabled`='1' AND `splms_teacher_id`='0'
ORDER BY ordering DESC
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.04 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 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
# Caller File and line number 17 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:168716 JDatabaseDriver->loadObject() Copy JROOT/components/com_splms/models/teachers.php:4215 SplmsModelTeachers::getTeacher() Copy JROOT/components/com_splms/models/lessons.php:24114 SplmsModelLessons::getLessons() Copy JROOT/components/com_splms/views/courses/tmpl/default.php:46613 include Copy JROOT/components/com_splms/views/courses/tmpl/default.php Copy JROOT/libraries/fof/view/view.php:44212 FOFView->loadAnyTemplate() Copy JROOT/libraries/fof/view/form.php:7611 FOFViewForm->display() Copy JROOT/libraries/fof/controller/controller.php:112810 FOFController->display() Copy JROOT/libraries/fof/controller/controller.php:11689 FOFController->browse() Copy JROOT/libraries/fof/controller/controller.php:9708 FOFController->execute() Copy JROOT/libraries/fof/dispatcher/dispatcher.php:3287 FOFDispatcher->dispatch() Copy JROOT/components/com_splms/splms.php:356 require_once Copy JROOT/components/com_splms/splms.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2731 JApplicationCms->execute() Copy JROOT/index.php:72
Query Time: 1.44 ms After last query: 0.13 ms Query memory: 0.024 MB Memory before query: 19.150 MB Rows returned: 2
SELECT `id`
FROM `joom_menu `
WHERE `link` LIKE '%option= com_splms&view= courses%' AND `published` = '1'EXPLAIN not possible on query: SELECT `id`
FROM `joom_menu`
WHERE `link` LIKE '%option=com_splms&view=courses%' AND `published` = '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.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.02 ms executing 0.35 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms
# Caller File and line number 17 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:176516 JDatabaseDriver->loadResult() Copy JROOT/components/com_splms/helpers/helper.php:2615 SplmsHelper::getItemid() Copy JROOT/components/com_splms/models/lessons.php:24314 SplmsModelLessons::getLessons() Copy JROOT/components/com_splms/views/courses/tmpl/default.php:46613 include Copy JROOT/components/com_splms/views/courses/tmpl/default.php Copy JROOT/libraries/fof/view/view.php:44212 FOFView->loadAnyTemplate() Copy JROOT/libraries/fof/view/form.php:7611 FOFViewForm->display() Copy JROOT/libraries/fof/controller/controller.php:112810 FOFController->display() Copy JROOT/libraries/fof/controller/controller.php:11689 FOFController->browse() Copy JROOT/libraries/fof/controller/controller.php:9708 FOFController->execute() Copy JROOT/libraries/fof/dispatcher/dispatcher.php:3287 FOFDispatcher->dispatch() Copy JROOT/components/com_splms/splms.php:356 require_once Copy JROOT/components/com_splms/splms.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2731 JApplicationCms->execute() Copy JROOT/index.php:72
Query Time: 1.29 ms After last query: 6.57 ms Query memory: 0.023 MB Memory before query: 20.202 MB Rows returned: 0
SELECT event_id
FROM joom_splms_courses_events ce
LEFT JOIN joom_eb_events e ON e.id = ce.event_id
WHERE ce.course_id = 1 AND e.published = 1EXPLAIN not possible on query: SELECT event_id
FROM joom_splms_courses_events ce
LEFT JOIN joom_eb_events e ON e.id = ce.event_id
WHERE ce.course_id = 1 AND e.published = 1
Status Duration starting 0.08 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.05 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.06 ms preparing 0.02 ms executing 0.02 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.00 ms
# Caller File and line number 16 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:157515 JDatabaseDriver->loadColumn() Copy JROOT/libraries/axslibs/events.php:22914 AxsEvents::getCourseEvents() Copy JROOT/components/com_splms/views/courses/tmpl/default.php:46713 include Copy JROOT/components/com_splms/views/courses/tmpl/default.php Copy JROOT/libraries/fof/view/view.php:44212 FOFView->loadAnyTemplate() Copy JROOT/libraries/fof/view/form.php:7611 FOFViewForm->display() Copy JROOT/libraries/fof/controller/controller.php:112810 FOFController->display() Copy JROOT/libraries/fof/controller/controller.php:11689 FOFController->browse() Copy JROOT/libraries/fof/controller/controller.php:9708 FOFController->execute() Copy JROOT/libraries/fof/dispatcher/dispatcher.php:3287 FOFDispatcher->dispatch() Copy JROOT/components/com_splms/splms.php:356 require_once Copy JROOT/components/com_splms/splms.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2731 JApplicationCms->execute() Copy JROOT/index.php:72
Query Time: 1.22 ms After last query: 0.04 ms Query memory: 0.025 MB Memory before query: 20.209 MB Rows returned: 1
SELECT *
FROM `joom_splms_lessons `
WHERE `splms_course_id`= 1 AND `enabled`= 1 AND `language`= 'en-GB 'EXPLAIN not possible on query: SELECT *
FROM `joom_splms_lessons`
WHERE `splms_course_id`=1 AND `enabled`= 1 AND `language`='en-GB'
Status Duration starting 0.04 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.04 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.07 ms preparing 0.02 ms executing 0.05 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.00 ms
# Caller File and line number 17 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172616 JDatabaseDriver->loadObjectList() Copy JROOT/components/com_splms/models/courses.php:99115 SplmsModelCourses->getLessons() Copy JROOT/components/com_splms/models/courses.php:62414 SplmsModelCourses->getCourseTeachers() Copy JROOT/components/com_splms/views/courses/tmpl/default.php:47313 include Copy JROOT/components/com_splms/views/courses/tmpl/default.php Copy JROOT/libraries/fof/view/view.php:44212 FOFView->loadAnyTemplate() Copy JROOT/libraries/fof/view/form.php:7611 FOFViewForm->display() Copy JROOT/libraries/fof/controller/controller.php:112810 FOFController->display() Copy JROOT/libraries/fof/controller/controller.php:11689 FOFController->browse() Copy JROOT/libraries/fof/controller/controller.php:9708 FOFController->execute() Copy JROOT/libraries/fof/dispatcher/dispatcher.php:3287 FOFDispatcher->dispatch() Copy JROOT/components/com_splms/splms.php:356 require_once Copy JROOT/components/com_splms/splms.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2731 JApplicationCms->execute() Copy JROOT/index.php:72
Query Time: 1.28 ms After last query: 1.48 ms Query memory: 0.024 MB Memory before query: 20.409 MB Rows returned: 1
SELECT *
FROM `joom_splms_lessons `
WHERE `enabled`= '1' AND `splms_course_id`= '2' AND `language`= 'en-GB '
ORDER BY ordering ASC EXPLAIN not possible on query: SELECT *
FROM `joom_splms_lessons`
WHERE `enabled`='1' AND `splms_course_id`='2' AND `language`='en-GB'
ORDER BY ordering ASC
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.02 ms statistics 0.06 ms preparing 0.03 ms executing 0.07 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms
# Caller File and line number 16 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172615 JDatabaseDriver->loadObjectList() Copy JROOT/components/com_splms/models/lessons.php:23814 SplmsModelLessons::getLessons() Copy JROOT/components/com_splms/views/courses/tmpl/default.php:46613 include Copy JROOT/components/com_splms/views/courses/tmpl/default.php Copy JROOT/libraries/fof/view/view.php:44212 FOFView->loadAnyTemplate() Copy JROOT/libraries/fof/view/form.php:7611 FOFViewForm->display() Copy JROOT/libraries/fof/controller/controller.php:112810 FOFController->display() Copy JROOT/libraries/fof/controller/controller.php:11689 FOFController->browse() Copy JROOT/libraries/fof/controller/controller.php:9708 FOFController->execute() Copy JROOT/libraries/fof/dispatcher/dispatcher.php:3287 FOFDispatcher->dispatch() Copy JROOT/components/com_splms/splms.php:356 require_once Copy JROOT/components/com_splms/splms.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2731 JApplicationCms->execute() Copy JROOT/index.php:72
Query Time: 1.14 ms After last query: 0.09 ms Query memory: 0.023 MB Memory before query: 20.417 MB Rows returned: 0
SELECT event_id
FROM joom_splms_courses_events ce
LEFT JOIN joom_eb_events e ON e.id = ce.event_id
WHERE ce.course_id = 2 AND e.published = 1EXPLAIN not possible on query: SELECT event_id
FROM joom_splms_courses_events ce
LEFT JOIN joom_eb_events e ON e.id = ce.event_id
WHERE ce.course_id = 2 AND e.published = 1
Status Duration starting 0.05 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.05 ms preparing 0.02 ms executing 0.01 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms
# Caller File and line number 16 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:157515 JDatabaseDriver->loadColumn() Copy JROOT/libraries/axslibs/events.php:22914 AxsEvents::getCourseEvents() Copy JROOT/components/com_splms/views/courses/tmpl/default.php:46713 include Copy JROOT/components/com_splms/views/courses/tmpl/default.php Copy JROOT/libraries/fof/view/view.php:44212 FOFView->loadAnyTemplate() Copy JROOT/libraries/fof/view/form.php:7611 FOFViewForm->display() Copy JROOT/libraries/fof/controller/controller.php:112810 FOFController->display() Copy JROOT/libraries/fof/controller/controller.php:11689 FOFController->browse() Copy JROOT/libraries/fof/controller/controller.php:9708 FOFController->execute() Copy JROOT/libraries/fof/dispatcher/dispatcher.php:3287 FOFDispatcher->dispatch() Copy JROOT/components/com_splms/splms.php:356 require_once Copy JROOT/components/com_splms/splms.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2731 JApplicationCms->execute() Copy JROOT/index.php:72
Query Time: 1.18 ms After last query: 0.03 ms Query memory: 0.025 MB Memory before query: 20.424 MB Rows returned: 1
SELECT *
FROM `joom_splms_lessons `
WHERE `splms_course_id`= 2 AND `enabled`= 1 AND `language`= 'en-GB 'EXPLAIN not possible on query: SELECT *
FROM `joom_splms_lessons`
WHERE `splms_course_id`=2 AND `enabled`= 1 AND `language`='en-GB'
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.06 ms preparing 0.02 ms executing 0.05 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms
# Caller File and line number 17 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172616 JDatabaseDriver->loadObjectList() Copy JROOT/components/com_splms/models/courses.php:99115 SplmsModelCourses->getLessons() Copy JROOT/components/com_splms/models/courses.php:62414 SplmsModelCourses->getCourseTeachers() Copy JROOT/components/com_splms/views/courses/tmpl/default.php:47313 include Copy JROOT/components/com_splms/views/courses/tmpl/default.php Copy JROOT/libraries/fof/view/view.php:44212 FOFView->loadAnyTemplate() Copy JROOT/libraries/fof/view/form.php:7611 FOFViewForm->display() Copy JROOT/libraries/fof/controller/controller.php:112810 FOFController->display() Copy JROOT/libraries/fof/controller/controller.php:11689 FOFController->browse() Copy JROOT/libraries/fof/controller/controller.php:9708 FOFController->execute() Copy JROOT/libraries/fof/dispatcher/dispatcher.php:3287 FOFDispatcher->dispatch() Copy JROOT/components/com_splms/splms.php:356 require_once Copy JROOT/components/com_splms/splms.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2731 JApplicationCms->execute() Copy JROOT/index.php:72
Query Time: 1.18 ms After last query: 0.34 ms Query memory: 0.023 MB Memory before query: 20.447 MB Rows returned: 0
SELECT *
FROM `joom_splms_lessons `
WHERE `enabled`= '1' AND `splms_course_id`= '4' AND `language`= 'en-GB '
ORDER BY ordering ASC EXPLAIN not possible on query: SELECT *
FROM `joom_splms_lessons`
WHERE `enabled`='1' AND `splms_course_id`='4' AND `language`='en-GB'
ORDER BY ordering ASC
Status Duration starting 0.04 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.06 ms preparing 0.03 ms executing 0.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
# Caller File and line number 16 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172615 JDatabaseDriver->loadObjectList() Copy JROOT/components/com_splms/models/lessons.php:23814 SplmsModelLessons::getLessons() Copy JROOT/components/com_splms/views/courses/tmpl/default.php:46613 include Copy JROOT/components/com_splms/views/courses/tmpl/default.php Copy JROOT/libraries/fof/view/view.php:44212 FOFView->loadAnyTemplate() Copy JROOT/libraries/fof/view/form.php:7611 FOFViewForm->display() Copy JROOT/libraries/fof/controller/controller.php:112810 FOFController->display() Copy JROOT/libraries/fof/controller/controller.php:11689 FOFController->browse() Copy JROOT/libraries/fof/controller/controller.php:9708 FOFController->execute() Copy JROOT/libraries/fof/dispatcher/dispatcher.php:3287 FOFDispatcher->dispatch() Copy JROOT/components/com_splms/splms.php:356 require_once Copy JROOT/components/com_splms/splms.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2731 JApplicationCms->execute() Copy JROOT/index.php:72
Query Time: 1.13 ms After last query: 0.03 ms Query memory: 0.023 MB Memory before query: 20.450 MB Rows returned: 0
SELECT event_id
FROM joom_splms_courses_events ce
LEFT JOIN joom_eb_events e ON e.id = ce.event_id
WHERE ce.course_id = 4 AND e.published = 1EXPLAIN not possible on query: SELECT event_id
FROM joom_splms_courses_events ce
LEFT JOIN joom_eb_events e ON e.id = ce.event_id
WHERE ce.course_id = 4 AND e.published = 1
Status Duration starting 0.04 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.04 ms preparing 0.02 ms executing 0.01 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms
# Caller File and line number 16 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:157515 JDatabaseDriver->loadColumn() Copy JROOT/libraries/axslibs/events.php:22914 AxsEvents::getCourseEvents() Copy JROOT/components/com_splms/views/courses/tmpl/default.php:46713 include Copy JROOT/components/com_splms/views/courses/tmpl/default.php Copy JROOT/libraries/fof/view/view.php:44212 FOFView->loadAnyTemplate() Copy JROOT/libraries/fof/view/form.php:7611 FOFViewForm->display() Copy JROOT/libraries/fof/controller/controller.php:112810 FOFController->display() Copy JROOT/libraries/fof/controller/controller.php:11689 FOFController->browse() Copy JROOT/libraries/fof/controller/controller.php:9708 FOFController->execute() Copy JROOT/libraries/fof/dispatcher/dispatcher.php:3287 FOFDispatcher->dispatch() Copy JROOT/components/com_splms/splms.php:356 require_once Copy JROOT/components/com_splms/splms.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2731 JApplicationCms->execute() Copy JROOT/index.php:72
Query Time: 1.12 ms After last query: 0.03 ms Query memory: 0.024 MB Memory before query: 20.457 MB Rows returned: 0
SELECT *
FROM `joom_splms_lessons `
WHERE `splms_course_id`= 4 AND `enabled`= 1 AND `language`= 'en-GB 'EXPLAIN not possible on query: SELECT *
FROM `joom_splms_lessons`
WHERE `splms_course_id`=4 AND `enabled`= 1 AND `language`='en-GB'
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.00 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.02 ms executing 0.03 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms
# Caller File and line number 17 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172616 JDatabaseDriver->loadObjectList() Copy JROOT/components/com_splms/models/courses.php:99115 SplmsModelCourses->getLessons() Copy JROOT/components/com_splms/models/courses.php:62414 SplmsModelCourses->getCourseTeachers() Copy JROOT/components/com_splms/views/courses/tmpl/default.php:47313 include Copy JROOT/components/com_splms/views/courses/tmpl/default.php Copy JROOT/libraries/fof/view/view.php:44212 FOFView->loadAnyTemplate() Copy JROOT/libraries/fof/view/form.php:7611 FOFViewForm->display() Copy JROOT/libraries/fof/controller/controller.php:112810 FOFController->display() Copy JROOT/libraries/fof/controller/controller.php:11689 FOFController->browse() Copy JROOT/libraries/fof/controller/controller.php:9708 FOFController->execute() Copy JROOT/libraries/fof/dispatcher/dispatcher.php:3287 FOFDispatcher->dispatch() Copy JROOT/components/com_splms/splms.php:356 require_once Copy JROOT/components/com_splms/splms.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2731 JApplicationCms->execute() Copy JROOT/index.php:72
Query Time: 1.22 ms After last query: 0.32 ms Query memory: 0.023 MB Memory before query: 20.480 MB Rows returned: 0
SELECT *
FROM `joom_splms_lessons `
WHERE `enabled`= '1' AND `splms_course_id`= '5' AND `language`= 'en-GB '
ORDER BY ordering ASC EXPLAIN not possible on query: SELECT *
FROM `joom_splms_lessons`
WHERE `enabled`='1' AND `splms_course_id`='5' AND `language`='en-GB'
ORDER BY ordering ASC
Status Duration starting 0.04 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.05 ms preparing 0.02 ms executing 0.03 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms
# Caller File and line number 16 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172615 JDatabaseDriver->loadObjectList() Copy JROOT/components/com_splms/models/lessons.php:23814 SplmsModelLessons::getLessons() Copy JROOT/components/com_splms/views/courses/tmpl/default.php:46613 include Copy JROOT/components/com_splms/views/courses/tmpl/default.php Copy JROOT/libraries/fof/view/view.php:44212 FOFView->loadAnyTemplate() Copy JROOT/libraries/fof/view/form.php:7611 FOFViewForm->display() Copy JROOT/libraries/fof/controller/controller.php:112810 FOFController->display() Copy JROOT/libraries/fof/controller/controller.php:11689 FOFController->browse() Copy JROOT/libraries/fof/controller/controller.php:9708 FOFController->execute() Copy JROOT/libraries/fof/dispatcher/dispatcher.php:3287 FOFDispatcher->dispatch() Copy JROOT/components/com_splms/splms.php:356 require_once Copy JROOT/components/com_splms/splms.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2731 JApplicationCms->execute() Copy JROOT/index.php:72
Query Time: 1.12 ms After last query: 0.03 ms Query memory: 0.023 MB Memory before query: 20.486 MB Rows returned: 0
SELECT event_id
FROM joom_splms_courses_events ce
LEFT JOIN joom_eb_events e ON e.id = ce.event_id
WHERE ce.course_id = 5 AND e.published = 1EXPLAIN not possible on query: SELECT event_id
FROM joom_splms_courses_events ce
LEFT JOIN joom_eb_events e ON e.id = ce.event_id
WHERE ce.course_id = 5 AND e.published = 1
Status Duration starting 0.04 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.04 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.02 ms executing 0.01 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms
# Caller File and line number 16 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:157515 JDatabaseDriver->loadColumn() Copy JROOT/libraries/axslibs/events.php:22914 AxsEvents::getCourseEvents() Copy JROOT/components/com_splms/views/courses/tmpl/default.php:46713 include Copy JROOT/components/com_splms/views/courses/tmpl/default.php Copy JROOT/libraries/fof/view/view.php:44212 FOFView->loadAnyTemplate() Copy JROOT/libraries/fof/view/form.php:7611 FOFViewForm->display() Copy JROOT/libraries/fof/controller/controller.php:112810 FOFController->display() Copy JROOT/libraries/fof/controller/controller.php:11689 FOFController->browse() Copy JROOT/libraries/fof/controller/controller.php:9708 FOFController->execute() Copy JROOT/libraries/fof/dispatcher/dispatcher.php:3287 FOFDispatcher->dispatch() Copy JROOT/components/com_splms/splms.php:356 require_once Copy JROOT/components/com_splms/splms.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2731 JApplicationCms->execute() Copy JROOT/index.php:72
Query Time: 1.13 ms After last query: 0.03 ms Query memory: 0.024 MB Memory before query: 20.493 MB Rows returned: 0
SELECT *
FROM `joom_splms_lessons `
WHERE `splms_course_id`= 5 AND `enabled`= 1 AND `language`= 'en-GB 'EXPLAIN not possible on query: SELECT *
FROM `joom_splms_lessons`
WHERE `splms_course_id`=5 AND `enabled`= 1 AND `language`='en-GB'
Status Duration starting 0.03 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.02 ms executing 0.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
# Caller File and line number 17 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172616 JDatabaseDriver->loadObjectList() Copy JROOT/components/com_splms/models/courses.php:99115 SplmsModelCourses->getLessons() Copy JROOT/components/com_splms/models/courses.php:62414 SplmsModelCourses->getCourseTeachers() Copy JROOT/components/com_splms/views/courses/tmpl/default.php:47313 include Copy JROOT/components/com_splms/views/courses/tmpl/default.php Copy JROOT/libraries/fof/view/view.php:44212 FOFView->loadAnyTemplate() Copy JROOT/libraries/fof/view/form.php:7611 FOFViewForm->display() Copy JROOT/libraries/fof/controller/controller.php:112810 FOFController->display() Copy JROOT/libraries/fof/controller/controller.php:11689 FOFController->browse() Copy JROOT/libraries/fof/controller/controller.php:9708 FOFController->execute() Copy JROOT/libraries/fof/dispatcher/dispatcher.php:3287 FOFDispatcher->dispatch() Copy JROOT/components/com_splms/splms.php:356 require_once Copy JROOT/components/com_splms/splms.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2731 JApplicationCms->execute() Copy JROOT/index.php:72
Query Time: 1.70 ms After last query: 0.32 ms Query memory: 0.023 MB Memory before query: 20.517 MB Rows returned: 0
SELECT *
FROM `joom_splms_lessons `
WHERE `enabled`= '1' AND `splms_course_id`= '6' AND `language`= 'en-GB '
ORDER BY ordering ASC EXPLAIN not possible on query: SELECT *
FROM `joom_splms_lessons`
WHERE `enabled`='1' AND `splms_course_id`='6' AND `language`='en-GB'
ORDER BY ordering ASC
Status Duration starting 0.03 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.05 ms preparing 0.02 ms executing 0.03 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms
# Caller File and line number 16 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172615 JDatabaseDriver->loadObjectList() Copy JROOT/components/com_splms/models/lessons.php:23814 SplmsModelLessons::getLessons() Copy JROOT/components/com_splms/views/courses/tmpl/default.php:46613 include Copy JROOT/components/com_splms/views/courses/tmpl/default.php Copy JROOT/libraries/fof/view/view.php:44212 FOFView->loadAnyTemplate() Copy JROOT/libraries/fof/view/form.php:7611 FOFViewForm->display() Copy JROOT/libraries/fof/controller/controller.php:112810 FOFController->display() Copy JROOT/libraries/fof/controller/controller.php:11689 FOFController->browse() Copy JROOT/libraries/fof/controller/controller.php:9708 FOFController->execute() Copy JROOT/libraries/fof/dispatcher/dispatcher.php:3287 FOFDispatcher->dispatch() Copy JROOT/components/com_splms/splms.php:356 require_once Copy JROOT/components/com_splms/splms.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2731 JApplicationCms->execute() Copy JROOT/index.php:72
Query Time: 1.15 ms After last query: 0.06 ms Query memory: 0.023 MB Memory before query: 20.523 MB Rows returned: 0
SELECT event_id
FROM joom_splms_courses_events ce
LEFT JOIN joom_eb_events e ON e.id = ce.event_id
WHERE ce.course_id = 6 AND e.published = 1EXPLAIN not possible on query: SELECT event_id
FROM joom_splms_courses_events ce
LEFT JOIN joom_eb_events e ON e.id = ce.event_id
WHERE ce.course_id = 6 AND e.published = 1
Status Duration starting 0.04 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.02 ms executing 0.01 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms
# Caller File and line number 16 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:157515 JDatabaseDriver->loadColumn() Copy JROOT/libraries/axslibs/events.php:22914 AxsEvents::getCourseEvents() Copy JROOT/components/com_splms/views/courses/tmpl/default.php:46713 include Copy JROOT/components/com_splms/views/courses/tmpl/default.php Copy JROOT/libraries/fof/view/view.php:44212 FOFView->loadAnyTemplate() Copy JROOT/libraries/fof/view/form.php:7611 FOFViewForm->display() Copy JROOT/libraries/fof/controller/controller.php:112810 FOFController->display() Copy JROOT/libraries/fof/controller/controller.php:11689 FOFController->browse() Copy JROOT/libraries/fof/controller/controller.php:9708 FOFController->execute() Copy JROOT/libraries/fof/dispatcher/dispatcher.php:3287 FOFDispatcher->dispatch() Copy JROOT/components/com_splms/splms.php:356 require_once Copy JROOT/components/com_splms/splms.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2731 JApplicationCms->execute() Copy JROOT/index.php:72
Query Time: 1.17 ms After last query: 0.08 ms Query memory: 0.024 MB Memory before query: 20.530 MB Rows returned: 0
SELECT *
FROM `joom_splms_lessons `
WHERE `splms_course_id`= 6 AND `enabled`= 1 AND `language`= 'en-GB 'EXPLAIN not possible on query: SELECT *
FROM `joom_splms_lessons`
WHERE `splms_course_id`=6 AND `enabled`= 1 AND `language`='en-GB'
Status Duration starting 0.03 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.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
# Caller File and line number 17 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172616 JDatabaseDriver->loadObjectList() Copy JROOT/components/com_splms/models/courses.php:99115 SplmsModelCourses->getLessons() Copy JROOT/components/com_splms/models/courses.php:62414 SplmsModelCourses->getCourseTeachers() Copy JROOT/components/com_splms/views/courses/tmpl/default.php:47313 include Copy JROOT/components/com_splms/views/courses/tmpl/default.php Copy JROOT/libraries/fof/view/view.php:44212 FOFView->loadAnyTemplate() Copy JROOT/libraries/fof/view/form.php:7611 FOFViewForm->display() Copy JROOT/libraries/fof/controller/controller.php:112810 FOFController->display() Copy JROOT/libraries/fof/controller/controller.php:11689 FOFController->browse() Copy JROOT/libraries/fof/controller/controller.php:9708 FOFController->execute() Copy JROOT/libraries/fof/dispatcher/dispatcher.php:3287 FOFDispatcher->dispatch() Copy JROOT/components/com_splms/splms.php:356 require_once Copy JROOT/components/com_splms/splms.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2731 JApplicationCms->execute() Copy JROOT/index.php:72
Query Time: 1.19 ms After last query: 0.53 ms Query memory: 0.023 MB Memory before query: 20.554 MB Rows returned: 0
SELECT *
FROM `joom_splms_lessons `
WHERE `enabled`= '1' AND `splms_course_id`= '7' AND `language`= 'en-GB '
ORDER BY ordering ASC EXPLAIN not possible on query: SELECT *
FROM `joom_splms_lessons`
WHERE `enabled`='1' AND `splms_course_id`='7' AND `language`='en-GB'
ORDER BY ordering ASC
Status Duration starting 0.04 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.05 ms preparing 0.02 ms executing 0.03 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms
# Caller File and line number 16 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172615 JDatabaseDriver->loadObjectList() Copy JROOT/components/com_splms/models/lessons.php:23814 SplmsModelLessons::getLessons() Copy JROOT/components/com_splms/views/courses/tmpl/default.php:46613 include Copy JROOT/components/com_splms/views/courses/tmpl/default.php Copy JROOT/libraries/fof/view/view.php:44212 FOFView->loadAnyTemplate() Copy JROOT/libraries/fof/view/form.php:7611 FOFViewForm->display() Copy JROOT/libraries/fof/controller/controller.php:112810 FOFController->display() Copy JROOT/libraries/fof/controller/controller.php:11689 FOFController->browse() Copy JROOT/libraries/fof/controller/controller.php:9708 FOFController->execute() Copy JROOT/libraries/fof/dispatcher/dispatcher.php:3287 FOFDispatcher->dispatch() Copy JROOT/components/com_splms/splms.php:356 require_once Copy JROOT/components/com_splms/splms.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2731 JApplicationCms->execute() Copy JROOT/index.php:72
Query Time: 1.21 ms After last query: 0.04 ms Query memory: 0.023 MB Memory before query: 20.560 MB Rows returned: 0
SELECT event_id
FROM joom_splms_courses_events ce
LEFT JOIN joom_eb_events e ON e.id = ce.event_id
WHERE ce.course_id = 7 AND e.published = 1EXPLAIN not possible on query: SELECT event_id
FROM joom_splms_courses_events ce
LEFT JOIN joom_eb_events e ON e.id = ce.event_id
WHERE ce.course_id = 7 AND e.published = 1
Status Duration starting 0.04 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.02 ms executing 0.01 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms
# Caller File and line number 16 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:157515 JDatabaseDriver->loadColumn() Copy JROOT/libraries/axslibs/events.php:22914 AxsEvents::getCourseEvents() Copy JROOT/components/com_splms/views/courses/tmpl/default.php:46713 include Copy JROOT/components/com_splms/views/courses/tmpl/default.php Copy JROOT/libraries/fof/view/view.php:44212 FOFView->loadAnyTemplate() Copy JROOT/libraries/fof/view/form.php:7611 FOFViewForm->display() Copy JROOT/libraries/fof/controller/controller.php:112810 FOFController->display() Copy JROOT/libraries/fof/controller/controller.php:11689 FOFController->browse() Copy JROOT/libraries/fof/controller/controller.php:9708 FOFController->execute() Copy JROOT/libraries/fof/dispatcher/dispatcher.php:3287 FOFDispatcher->dispatch() Copy JROOT/components/com_splms/splms.php:356 require_once Copy JROOT/components/com_splms/splms.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2731 JApplicationCms->execute() Copy JROOT/index.php:72
Query Time: 1.14 ms After last query: 0.08 ms Query memory: 0.024 MB Memory before query: 20.567 MB Rows returned: 0
SELECT *
FROM `joom_splms_lessons `
WHERE `splms_course_id`= 7 AND `enabled`= 1 AND `language`= 'en-GB 'EXPLAIN not possible on query: SELECT *
FROM `joom_splms_lessons`
WHERE `splms_course_id`=7 AND `enabled`= 1 AND `language`='en-GB'
Status Duration starting 0.03 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.02 ms executing 0.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
# Caller File and line number 17 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172616 JDatabaseDriver->loadObjectList() Copy JROOT/components/com_splms/models/courses.php:99115 SplmsModelCourses->getLessons() Copy JROOT/components/com_splms/models/courses.php:62414 SplmsModelCourses->getCourseTeachers() Copy JROOT/components/com_splms/views/courses/tmpl/default.php:47313 include Copy JROOT/components/com_splms/views/courses/tmpl/default.php Copy JROOT/libraries/fof/view/view.php:44212 FOFView->loadAnyTemplate() Copy JROOT/libraries/fof/view/form.php:7611 FOFViewForm->display() Copy JROOT/libraries/fof/controller/controller.php:112810 FOFController->display() Copy JROOT/libraries/fof/controller/controller.php:11689 FOFController->browse() Copy JROOT/libraries/fof/controller/controller.php:9708 FOFController->execute() Copy JROOT/libraries/fof/dispatcher/dispatcher.php:3287 FOFDispatcher->dispatch() Copy JROOT/components/com_splms/splms.php:356 require_once Copy JROOT/components/com_splms/splms.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2731 JApplicationCms->execute() Copy JROOT/index.php:72
Query Time: 1.28 ms After last query: 0.60 ms Query memory: 0.024 MB Memory before query: 20.590 MB Rows returned: 1
SELECT *
FROM `joom_splms_lessons `
WHERE `enabled`= '1' AND `splms_course_id`= '8' AND `language`= 'en-GB '
ORDER BY ordering ASC EXPLAIN not possible on query: SELECT *
FROM `joom_splms_lessons`
WHERE `enabled`='1' AND `splms_course_id`='8' AND `language`='en-GB'
ORDER BY ordering ASC
Status Duration starting 0.05 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.05 ms preparing 0.03 ms executing 0.08 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms
# Caller File and line number 16 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172615 JDatabaseDriver->loadObjectList() Copy JROOT/components/com_splms/models/lessons.php:23814 SplmsModelLessons::getLessons() Copy JROOT/components/com_splms/views/courses/tmpl/default.php:46613 include Copy JROOT/components/com_splms/views/courses/tmpl/default.php Copy JROOT/libraries/fof/view/view.php:44212 FOFView->loadAnyTemplate() Copy JROOT/libraries/fof/view/form.php:7611 FOFViewForm->display() Copy JROOT/libraries/fof/controller/controller.php:112810 FOFController->display() Copy JROOT/libraries/fof/controller/controller.php:11689 FOFController->browse() Copy JROOT/libraries/fof/controller/controller.php:9708 FOFController->execute() Copy JROOT/libraries/fof/dispatcher/dispatcher.php:3287 FOFDispatcher->dispatch() Copy JROOT/components/com_splms/splms.php:356 require_once Copy JROOT/components/com_splms/splms.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2731 JApplicationCms->execute() Copy JROOT/index.php:72
Query Time: 1.12 ms After last query: 0.14 ms Query memory: 0.023 MB Memory before query: 20.602 MB Rows returned: 0
SELECT event_id
FROM joom_splms_courses_events ce
LEFT JOIN joom_eb_events e ON e.id = ce.event_id
WHERE ce.course_id = 8 AND e.published = 1EXPLAIN not possible on query: SELECT event_id
FROM joom_splms_courses_events ce
LEFT JOIN joom_eb_events e ON e.id = ce.event_id
WHERE ce.course_id = 8 AND e.published = 1
Status Duration starting 0.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.04 ms preparing 0.02 ms executing 0.01 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms
# Caller File and line number 16 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:157515 JDatabaseDriver->loadColumn() Copy JROOT/libraries/axslibs/events.php:22914 AxsEvents::getCourseEvents() Copy JROOT/components/com_splms/views/courses/tmpl/default.php:46713 include Copy JROOT/components/com_splms/views/courses/tmpl/default.php Copy JROOT/libraries/fof/view/view.php:44212 FOFView->loadAnyTemplate() Copy JROOT/libraries/fof/view/form.php:7611 FOFViewForm->display() Copy JROOT/libraries/fof/controller/controller.php:112810 FOFController->display() Copy JROOT/libraries/fof/controller/controller.php:11689 FOFController->browse() Copy JROOT/libraries/fof/controller/controller.php:9708 FOFController->execute() Copy JROOT/libraries/fof/dispatcher/dispatcher.php:3287 FOFDispatcher->dispatch() Copy JROOT/components/com_splms/splms.php:356 require_once Copy JROOT/components/com_splms/splms.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2731 JApplicationCms->execute() Copy JROOT/index.php:72
Query Time: 1.21 ms After last query: 0.05 ms Query memory: 0.025 MB Memory before query: 20.609 MB Rows returned: 1
SELECT *
FROM `joom_splms_lessons `
WHERE `splms_course_id`= 8 AND `enabled`= 1 AND `language`= 'en-GB 'EXPLAIN not possible on query: SELECT *
FROM `joom_splms_lessons`
WHERE `splms_course_id`=8 AND `enabled`= 1 AND `language`='en-GB'
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.07 ms preparing 0.02 ms executing 0.05 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms
# Caller File and line number 17 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172616 JDatabaseDriver->loadObjectList() Copy JROOT/components/com_splms/models/courses.php:99115 SplmsModelCourses->getLessons() Copy JROOT/components/com_splms/models/courses.php:62414 SplmsModelCourses->getCourseTeachers() Copy JROOT/components/com_splms/views/courses/tmpl/default.php:47313 include Copy JROOT/components/com_splms/views/courses/tmpl/default.php Copy JROOT/libraries/fof/view/view.php:44212 FOFView->loadAnyTemplate() Copy JROOT/libraries/fof/view/form.php:7611 FOFViewForm->display() Copy JROOT/libraries/fof/controller/controller.php:112810 FOFController->display() Copy JROOT/libraries/fof/controller/controller.php:11689 FOFController->browse() Copy JROOT/libraries/fof/controller/controller.php:9708 FOFController->execute() Copy JROOT/libraries/fof/dispatcher/dispatcher.php:3287 FOFDispatcher->dispatch() Copy JROOT/components/com_splms/splms.php:356 require_once Copy JROOT/components/com_splms/splms.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2731 JApplicationCms->execute() Copy JROOT/index.php:72
Query Time: 1.44 ms After last query: 2.37 ms Query memory: 0.021 MB Memory before query: 20.694 MB Rows returned: 1
SELECT language,id
FROM `joom_menu `
WHERE home = 1 AND published = 1 AND client_id = 0EXPLAIN not possible on query: 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.05 ms preparing 0.02 ms executing 0.23 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms
# Caller File and line number 10 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:17269 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/cms/language/multilang.php:1068 JLanguageMultilang::getSiteHomePages() Copy JROOT/plugins/system/languagefilter/languagefilter.php:7297 PlgSystemLanguageFilter->onAfterDispatch() Copy JROOT/libraries/joomla/event/event.php:706 JEvent->update() Copy JROOT/libraries/joomla/event/dispatcher.php:1605 JEventDispatcher->trigger() Copy JROOT/libraries/joomla/application/base.php:1064 JApplicationBase->triggerEvent() Copy JROOT/libraries/cms/application/site.php:1963 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2731 JApplicationCms->execute() Copy JROOT/index.php:72
Query Time: 1.31 ms After last query: 0.65 ms Query memory: 0.021 MB Memory before query: 20.746 MB Rows returned: 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 = 864EXPLAIN not possible on query: SELECT `c2`.`language`,`c2`.`id`
FROM `joom_menu` AS `c`
INNER JOIN `joom_associations` AS `a` ON a.id = c.`id` AND a.context='com_menus.item'
INNER JOIN `joom_associations` AS `a2` ON a.key = a2.key
INNER JOIN `joom_menu` AS `c2` ON a2.id = c2.`id`
WHERE c.id = 864
Status Duration starting 0.09 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.05 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.08 ms executing 0.01 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms
# Caller File and line number 11 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172610 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/cms/language/associations.php:1019 JLanguageAssociations::getAssociations() Copy JROOT/administrator/components/com_menus/helpers/menus.php:3138 MenusHelper::getAssociations() Copy JROOT/plugins/system/languagefilter/languagefilter.php:7467 PlgSystemLanguageFilter->onAfterDispatch() Copy JROOT/libraries/joomla/event/event.php:706 JEvent->update() Copy JROOT/libraries/joomla/event/dispatcher.php:1605 JEventDispatcher->trigger() Copy JROOT/libraries/joomla/application/base.php:1064 JApplicationBase->triggerEvent() Copy JROOT/libraries/cms/application/site.php:1963 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2731 JApplicationCms->execute() Copy JROOT/index.php:72
Query Time: 1.41 ms After last query: 3.71 ms Query memory: 0.022 MB Memory before query: 21.081 MB Rows returned: 1
SELECT *
FROM `currency`
WHERE `base_currency`= 1 LIMIT 1EXPLAIN not possible on query: SELECT *
FROM `currency`
WHERE `base_currency`=1 LIMIT 1
Status Duration starting 0.06 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.03 ms executing 0.14 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.02 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms
# Caller File and line number 12 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:168711 JDatabaseDriver->loadObject() Copy JROOT/libraries/axslibs/currency.php:8410 AxsCurrency->getBaseCurrency() Copy JROOT/libraries/axslibs/currency.php:229 AxsCurrency->__construct() Copy JROOT/templates/axs/home.php:208 include Copy JROOT/templates/axs/home.php Copy JROOT/templates/axs/index.php:607 require Copy JROOT/templates/axs/index.php Copy JROOT/libraries/joomla/document/html.php:6536 JDocumentHtml->_loadTemplate() Copy JROOT/libraries/joomla/document/html.php:7155 JDocumentHtml->_fetchTemplate() Copy JROOT/libraries/joomla/document/html.php:5304 JDocumentHtml->parse() Copy JROOT/libraries/cms/application/cms.php:11813 JApplicationCms->render() Copy JROOT/libraries/cms/application/site.php:7822 JApplicationSite->render() Copy JROOT/libraries/cms/application/cms.php:2791 JApplicationCms->execute() Copy JROOT/index.php:72
Query Time: 1.15 ms After last query: 0.13 ms Query memory: 0.028 MB Memory before query: 21.096 MB Rows returned: 10
SELECT * FROM axs_fonts WHERE enabled = 1EXPLAIN not possible on query: SELECT * FROM axs_fonts WHERE enabled = 1
Status Duration starting 0.04 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.02 ms executing 0.04 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms
# Caller File and line number 11 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172610 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/axslibs/fonts.php:349 AxsFonts::getFonts() Copy JROOT/templates/axs/home.php:938 include Copy JROOT/templates/axs/home.php Copy JROOT/templates/axs/index.php:607 require Copy JROOT/templates/axs/index.php Copy JROOT/libraries/joomla/document/html.php:6536 JDocumentHtml->_loadTemplate() Copy JROOT/libraries/joomla/document/html.php:7155 JDocumentHtml->_fetchTemplate() Copy JROOT/libraries/joomla/document/html.php:5304 JDocumentHtml->parse() Copy JROOT/libraries/cms/application/cms.php:11813 JApplicationCms->render() Copy JROOT/libraries/cms/application/site.php:7822 JApplicationSite->render() Copy JROOT/libraries/cms/application/cms.php:2791 JApplicationCms->execute() Copy JROOT/index.php:72
Query Time: 1.17 ms After last query: 0.26 ms Query memory: 0.022 MB Memory before query: 21.137 MB Rows returned: 0
SELECT *
FROM accessibility_images
WHERE `path`= 'images/pDJC5BxLjAW4jMgmh4ZjVUqCNDU3NDQ2OTkwOTMw/graphics/blue-logo.png' AND enabled= 1EXPLAIN not possible on query: SELECT *
FROM accessibility_images
WHERE `path`='images/pDJC5BxLjAW4jMgmh4ZjVUqCNDU3NDQ2OTkwOTMw/graphics/blue-logo.png' AND enabled= 1
Status Duration starting 0.04 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.02 ms executing 0.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
# Caller File and line number 12 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:168711 JDatabaseDriver->loadObject() Copy JROOT/libraries/axslibs/accessibility.php:4210 AxsAccessibility::query() Copy JROOT/libraries/axslibs/accessibility.php:499 AxsAccessibility::image() Copy JROOT/templates/axs/home.php:7998 include Copy JROOT/templates/axs/home.php Copy JROOT/templates/axs/index.php:607 require Copy JROOT/templates/axs/index.php Copy JROOT/libraries/joomla/document/html.php:6536 JDocumentHtml->_loadTemplate() Copy JROOT/libraries/joomla/document/html.php:7155 JDocumentHtml->_fetchTemplate() Copy JROOT/libraries/joomla/document/html.php:5304 JDocumentHtml->parse() Copy JROOT/libraries/cms/application/cms.php:11813 JApplicationCms->render() Copy JROOT/libraries/cms/application/site.php:7822 JApplicationSite->render() Copy JROOT/libraries/cms/application/cms.php:2791 JApplicationCms->execute() Copy JROOT/index.php:72
Query Time: 2.41 ms After last query: 0.69 ms Query memory: 0.026 MB Memory before query: 21.220 MB Rows returned: 21
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM joom_modules AS m
LEFT JOIN joom_modules_menu AS mm ON mm.moduleid = m.id
LEFT JOIN joom_extensions AS e ON e.element = m.module AND e.client_id = m.client_id
WHERE m.published = 1 AND e.enabled = 1 AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2025-04-03 20:38:29') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2025-04-03 20:38:29') AND m.access IN (1,1) AND m.client_id = 0 AND (mm.menuid = 864 OR mm.menuid <= 0) AND m.language IN ('en-GB ','* ')
ORDER BY m.position, m.orderingEXPLAIN not possible on query: SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM joom_modules AS m
LEFT JOIN joom_modules_menu AS mm ON mm.moduleid = m.id
LEFT JOIN joom_extensions AS e ON e.element = m.module AND e.client_id = m.client_id
WHERE m.published = 1 AND e.enabled = 1 AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2025-04-03 20:38:29') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2025-04-03 20:38:29') AND m.access IN (1,1) AND m.client_id = 0 AND (mm.menuid = 864 OR mm.menuid <= 0) AND m.language IN ('en-GB','*')
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.06 ms init 0.01 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.11 ms preparing 0.05 ms executing 1.00 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.01 ms
# Caller File and line number 15 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172614 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/joomla/cache/controller/callback.php:16913 JCacheControllerCallback->get() Copy JROOT/libraries/cms/module/helper.php:42412 JModuleHelper::getModuleList() Copy JROOT/libraries/cms/module/helper.php:36011 JModuleHelper::load() Copy JROOT/libraries/cms/module/helper.php:8410 JModuleHelper::getModules() Copy JROOT/libraries/joomla/document/html.php:5769 JDocumentHtml->countModules() Copy JROOT/templates/axs/home.php:8398 include Copy JROOT/templates/axs/home.php Copy JROOT/templates/axs/index.php:607 require Copy JROOT/templates/axs/index.php Copy JROOT/libraries/joomla/document/html.php:6536 JDocumentHtml->_loadTemplate() Copy JROOT/libraries/joomla/document/html.php:7155 JDocumentHtml->_fetchTemplate() Copy JROOT/libraries/joomla/document/html.php:5304 JDocumentHtml->parse() Copy JROOT/libraries/cms/application/cms.php:11813 JApplicationCms->render() Copy JROOT/libraries/cms/application/site.php:7822 JApplicationSite->render() Copy JROOT/libraries/cms/application/cms.php:2791 JApplicationCms->execute() Copy JROOT/index.php:72
Query Time: 1.28 ms After last query: 1.61 ms Query memory: 0.022 MB Memory before query: 21.281 MB Rows returned: 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 not possible on query: SELECT * FROM axs_notifications WHERE enabled = 1 AND DATE(start_date) <= NOW() AND ( DATE(end_date) > NOW() OR end_date = 0 ) AND ( ( access_type = 'access' AND ( ( FIND_IN_SET( 1, accesslevel ) > 0 ) OR ( FIND_IN_SET( 1, accesslevel ) > 0 ) ) ) OR ( access_type = 'user' AND ( ( FIND_IN_SET( 1, usergroup ) > 0 ) ) ) OR ( access_type = 'list' AND ( FIND_IN_SET( 0, userlist ) > 0 ) ) OR ( access_type = 'none' ) )
Status Duration starting 0.08 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.05 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
# Caller File and line number 11 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172610 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/axslibs/notifications.php:199 AxsNotifications::loadNotifications() Copy JROOT/templates/axs/home.php:17888 include Copy JROOT/templates/axs/home.php Copy JROOT/templates/axs/index.php:607 require Copy JROOT/templates/axs/index.php Copy JROOT/libraries/joomla/document/html.php:6536 JDocumentHtml->_loadTemplate() Copy JROOT/libraries/joomla/document/html.php:7155 JDocumentHtml->_fetchTemplate() Copy JROOT/libraries/joomla/document/html.php:5304 JDocumentHtml->parse() Copy JROOT/libraries/cms/application/cms.php:11813 JApplicationCms->render() Copy JROOT/libraries/cms/application/site.php:7822 JApplicationSite->render() Copy JROOT/libraries/cms/application/cms.php:2791 JApplicationCms->execute() Copy JROOT/index.php:72
Query Time: 1.14 ms After last query: 4.00 ms Query memory: 0.026 MB Memory before query: 21.514 MB Rows returned: 0
SELECT *
FROM joom_easyblog_configs
WHERE `name` = 'config'EXPLAIN not possible on query: SELECT *
FROM joom_easyblog_configs
WHERE `name` = 'config'
Status Duration starting 0.05 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.02 ms executing 0.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
# Caller File and line number 22 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:149021 JDatabaseDriver->loadAssoc() Copy JROOT/libraries/joomla/table/table.php:72920 JTable->load() Copy JROOT/administrator/components/com_easyblog/includes/easyblog.php:41519 EB::config() Copy JROOT/components/com_easyblog/router.php:1918 EasyBlogBuildRoute() Copy JROOT/libraries/cms/component/router/legacy.php:6817 JComponentRouterLegacy->build() Copy JROOT/libraries/cms/router/site.php:51916 JRouterSite->buildSefRoute() Copy JROOT/libraries/cms/router/site.php:48915 JRouterSite->_buildSefRoute() Copy JROOT/libraries/cms/router/router.php:28214 JRouter->build() Copy JROOT/libraries/cms/router/site.php:14913 JRouterSite->build() Copy JROOT/libraries/joomla/application/route.php:6212 JRoute::_() Copy JROOT/modules/mod_defaultmenu/helper.php:13411 ModDefaultHelper::getList() Copy JROOT/modules/mod_defaultmenu/mod_defaultmenu.php:1510 include Copy JROOT/modules/mod_defaultmenu/mod_defaultmenu.php Copy JROOT/libraries/cms/module/helper.php:1989 JModuleHelper::renderModule() Copy JROOT/libraries/joomla/document/renderer/html/module.php:938 JDocumentRendererHtmlModule->render() Copy JROOT/libraries/joomla/document/renderer/html/modules.php:427 JDocumentRendererHtmlModules->render() Copy JROOT/libraries/joomla/document/html.php:4866 JDocumentHtml->getBuffer() Copy JROOT/libraries/joomla/document/html.php:7775 JDocumentHtml->_renderTemplate() Copy JROOT/libraries/joomla/document/html.php:5524 JDocumentHtml->render() Copy JROOT/libraries/cms/application/cms.php:11983 JApplicationCms->render() Copy JROOT/libraries/cms/application/site.php:7822 JApplicationSite->render() Copy JROOT/libraries/cms/application/cms.php:2791 JApplicationCms->execute() Copy JROOT/index.php:72
Query Time: 2.06 ms After last query: 0.11 ms Query memory: 0.027 MB Memory before query: 21.567 MB Rows returned: 1
SELECT * FROM joom_extensions WHERE name= 'com_media'EXPLAIN not possible on query: SELECT * FROM joom_extensions WHERE name='com_media'
Status Duration starting 0.03 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms executing 0.97 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms
# Caller File and line number 23 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:168722 JDatabaseDriver->loadObject() Copy JROOT/libraries/axslibs/images.php:6621 AxsImages::setSession() Copy JROOT/libraries/axslibs/images.php:1520 AxsImages::getImagesPath() Copy JROOT/administrator/components/com_easyblog/includes/easyblog.php:43019 EB::config() Copy JROOT/components/com_easyblog/router.php:1918 EasyBlogBuildRoute() Copy JROOT/libraries/cms/component/router/legacy.php:6817 JComponentRouterLegacy->build() Copy JROOT/libraries/cms/router/site.php:51916 JRouterSite->buildSefRoute() Copy JROOT/libraries/cms/router/site.php:48915 JRouterSite->_buildSefRoute() Copy JROOT/libraries/cms/router/router.php:28214 JRouter->build() Copy JROOT/libraries/cms/router/site.php:14913 JRouterSite->build() Copy JROOT/libraries/joomla/application/route.php:6212 JRoute::_() Copy JROOT/modules/mod_defaultmenu/helper.php:13411 ModDefaultHelper::getList() Copy JROOT/modules/mod_defaultmenu/mod_defaultmenu.php:1510 include Copy JROOT/modules/mod_defaultmenu/mod_defaultmenu.php Copy JROOT/libraries/cms/module/helper.php:1989 JModuleHelper::renderModule() Copy JROOT/libraries/joomla/document/renderer/html/module.php:938 JDocumentRendererHtmlModule->render() Copy JROOT/libraries/joomla/document/renderer/html/modules.php:427 JDocumentRendererHtmlModules->render() Copy JROOT/libraries/joomla/document/html.php:4866 JDocumentHtml->getBuffer() Copy JROOT/libraries/joomla/document/html.php:7775 JDocumentHtml->_renderTemplate() Copy JROOT/libraries/joomla/document/html.php:5524 JDocumentHtml->render() Copy JROOT/libraries/cms/application/cms.php:11983 JApplicationCms->render() Copy JROOT/libraries/cms/application/site.php:7822 JApplicationSite->render() Copy JROOT/libraries/cms/application/cms.php:2791 JApplicationCms->execute() Copy JROOT/index.php:72
Query Time: 1.15 ms After last query: 1.53 ms Query memory: 0.028 MB Memory before query: 21.767 MB Rows returned: 1
SELECT * FROM joom_kunena_configuration WHERE id= 1EXPLAIN not possible on query: SELECT * FROM joom_kunena_configuration WHERE id=1
Status Duration starting 0.04 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.01 ms executing 0.01 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.00 ms
# Caller File and line number 28 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:149027 JDatabaseDriver->loadAssoc() Copy JROOT/libraries/kunena/config.php:130626 KunenaConfig->load() Copy JROOT/libraries/kunena/config.php:123925 KunenaConfig::getInstance() Copy JROOT/libraries/kunena/factory.php:2824 KunenaFactory::getConfig() Copy JROOT/libraries/kunena/route/route.php:48023 KunenaRoute::initialize() Copy JROOT/libraries/kunena/route/route.php:1722 include Copy JROOT/libraries/kunena/route/route.php Copy JROOT/libraries/loader.php:71621 JLoader::_load() Copy JROOT/libraries/loader.php:67120 JLoader::_autoload() Same as call in the line below. 19 spl_autoload_call() Copy JROOT/components/com_kunena/router.php:3818 KunenaBuildRoute() Copy JROOT/libraries/cms/component/router/legacy.php:6817 JComponentRouterLegacy->build() Copy JROOT/libraries/cms/router/site.php:51916 JRouterSite->buildSefRoute() Copy JROOT/libraries/cms/router/site.php:48915 JRouterSite->_buildSefRoute() Copy JROOT/libraries/cms/router/router.php:28214 JRouter->build() Copy JROOT/libraries/cms/router/site.php:14913 JRouterSite->build() Copy JROOT/libraries/joomla/application/route.php:6212 JRoute::_() Copy JROOT/modules/mod_defaultmenu/helper.php:13411 ModDefaultHelper::getList() Copy JROOT/modules/mod_defaultmenu/mod_defaultmenu.php:1510 include Copy JROOT/modules/mod_defaultmenu/mod_defaultmenu.php Copy JROOT/libraries/cms/module/helper.php:1989 JModuleHelper::renderModule() Copy JROOT/libraries/joomla/document/renderer/html/module.php:938 JDocumentRendererHtmlModule->render() Copy JROOT/libraries/joomla/document/renderer/html/modules.php:427 JDocumentRendererHtmlModules->render() Copy JROOT/libraries/joomla/document/html.php:4866 JDocumentHtml->getBuffer() Copy JROOT/libraries/joomla/document/html.php:7775 JDocumentHtml->_renderTemplate() Copy JROOT/libraries/joomla/document/html.php:5524 JDocumentHtml->render() Copy JROOT/libraries/cms/application/cms.php:11983 JApplicationCms->render() Copy JROOT/libraries/cms/application/site.php:7822 JApplicationSite->render() Copy JROOT/libraries/cms/application/cms.php:2791 JApplicationCms->execute() Copy JROOT/index.php:72
Query Time: 1.11 ms After last query: 1.82 ms Query memory: 0.024 MB Memory before query: 22.040 MB Rows returned: 1
SELECT special_characters FROM joom_languages WHERE sef = 'en' LIMIT 1EXPLAIN not possible on query: SELECT special_characters FROM joom_languages WHERE sef = 'en' LIMIT 1
Status Duration starting 0.05 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.01 ms executing 0.01 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms
# Caller File and line number 16 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:168715 JDatabaseDriver->loadObject() Copy JROOT/libraries/axslibs/language.php:30814 AxsLanguage::getSpecialCharacters() Copy JROOT/libraries/axslibs/language.php:2613 AxsLanguage::translate() Copy JROOT/modules/mod_defaultmenu/tmpl/default_component.php:2112 require Copy JROOT/modules/mod_defaultmenu/tmpl/default_component.php Copy JROOT/modules/mod_defaultmenu/tmpl/default.php:7211 require Copy JROOT/modules/mod_defaultmenu/tmpl/default.php Copy JROOT/modules/mod_defaultmenu/mod_defaultmenu.php:2510 include Copy JROOT/modules/mod_defaultmenu/mod_defaultmenu.php Copy JROOT/libraries/cms/module/helper.php:1989 JModuleHelper::renderModule() Copy JROOT/libraries/joomla/document/renderer/html/module.php:938 JDocumentRendererHtmlModule->render() Copy JROOT/libraries/joomla/document/renderer/html/modules.php:427 JDocumentRendererHtmlModules->render() Copy JROOT/libraries/joomla/document/html.php:4866 JDocumentHtml->getBuffer() Copy JROOT/libraries/joomla/document/html.php:7775 JDocumentHtml->_renderTemplate() Copy JROOT/libraries/joomla/document/html.php:5524 JDocumentHtml->render() Copy JROOT/libraries/cms/application/cms.php:11983 JApplicationCms->render() Copy JROOT/libraries/cms/application/site.php:7822 JApplicationSite->render() Copy JROOT/libraries/cms/application/cms.php:2791 JApplicationCms->execute() Copy JROOT/index.php:72
14 × SELECT * FROM `joom_splms_lessons ` 7 × SELECT event_id FROM joom_splms_courses_events ce LEFT JOIN joom_eb_events e ON e.id = ce.event_id 2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `joom_extensions ` 2 × SELECT * FROM `joom_splms_coursescategories ` 2 × SELECT * FROM joom_languages 1 × SELECT * FROM `joom_splms_course_wishlist ` 1 × SELECT a.* FROM joom_splms_courses_groups a INNER JOIN joom_splms_assignments_users u ON u.assignment_id = a.id AND u.user_id = 0 UNION SELECT a.* FROM joom_splms_courses_groups a INNER JOIN joom_splms_assignments_usergroups u ON u.assignment_id = a.id 1 × SELECT * FROM `axs_course_purchases` 1 × SELECT * FROM `joom_splms_course_progress ` 1 × SELECT sef FROM joom_languages 1 × SELECT * FROM `joom_splms_teachers ` 1 × SELECT `id` FROM `joom_menu ` 1 × SELECT `session_id` FROM `joom_session ` 1 × SELECT id FROM axs_starred 1 × SELECT `c2`.`language`,`c2`.`id` FROM `joom_menu ` AS `c` INNER JOIN `joom_associations ` AS `a` ON a.id = c.`id` AND a.context= 'com_menus.item' INNER JOIN `joom_associations ` AS `a2` ON a.key = a2.key INNER JOIN `joom_menu ` AS `c2` ON a2.id = c2.`id` 1 × SELECT * FROM `currency` 1 × SELECT * FROM axs_fonts 1 × SELECT * FROM accessibility_images 1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid FROM joom_modules AS m LEFT JOIN joom_modules_menu AS mm ON mm.moduleid = m.id LEFT JOIN joom_extensions AS e ON e.element = m.module AND e.client_id = m.client_id 1 × SELECT * FROM axs_notifications 1 × SELECT * FROM joom_easyblog_configs 1 × SELECT * FROM joom_extensions 1 × SELECT * FROM joom_kunena_configuration 1 × SELECT language,id FROM `joom_menu ` 1 × SELECT * FROM `joom_splms_courses ` 1 × SELECT COUNT (* ) as total FROM `joom_splms_courses ` 1 × SELECT * FROM axs_email_settings 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_payment_gateways 1 × SELECT `id`,`name`,`rules`,`parent_id` FROM `joom_assets ` 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 params FROM axs_user_settings 1 × SELECT * FROM `joom_users ` 1 × SELECT id, home, template, s.params FROM joom_template_styles as s LEFT JOIN joom_extensions as e ON e.element= s.template AND e.type= 'template' AND e.client_id= s.client_id 1 × SELECT * FROM axs_lms_settings 1 × SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state FROM joom_fields AS a LEFT JOIN `joom_languages ` AS l ON l.lang_code = a.language LEFT JOIN joom_users AS uc ON uc.id= a.checked_out LEFT JOIN joom_viewlevels AS ag ON ag.id = a.access LEFT JOIN joom_users AS ua ON ua.id = a.created_user_id LEFT JOIN joom_fields_groups AS g ON g.id = a.group_id 1 × SELECT special_characters FROM joom_languages