Query Time: 1.16 ms Query memory: 0.021 MB Memory before query: 7.562 MB Rows returned: 1
SELECT * FROM `axs_brands` WHERE 1 = 1 AND language = 'en-GB ' AND (FIND_IN_SET ('k8s.intg.tovuti.io', domains) > 0) LIMIT 1EXPLAIN not possible on query: SELECT * FROM `axs_brands` WHERE 1 = 1 AND language = 'en-GB' AND (FIND_IN_SET('k8s.intg.tovuti.io', domains) > 0) LIMIT 1
Status Duration starting 0.06 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.03 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.02 ms executing 0.04 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms
# Caller File and line number 10 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:16939 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/axslibs/brands.php:6978 AxsBrands::getData() Copy JROOT/libraries/axslibs/brands.php:7647 AxsBrands::getBrandObject() Copy JROOT/libraries/axslibs/brands.php:676 AxsBrands::getBrand() Copy JROOT/libraries/tovuti/Providers/FeatureFlaggingServiceProvider.php:715 Tovuti\Providers\FeatureFlaggingServiceProvider->getClientMetadata() Copy JROOT/libraries/tovuti/Providers/FeatureFlaggingServiceProvider.php:334 Tovuti\Providers\FeatureFlaggingServiceProvider->register() Copy JROOT/libraries/tovuti/Helpers/AppBootstrapHelper.php:1153 Tovuti\Helpers\AppBootstrapHelper::registerProviderWithDependencies() Copy JROOT/libraries/tovuti/Helpers/AppBootstrapHelper.php:902 Tovuti\Helpers\AppBootstrapHelper::bootstrapServices() Copy JROOT/libraries/tovuti/Helpers/AppBootstrapHelper.php:471 Tovuti\Helpers\AppBootstrapHelper::bootstrap() Copy JROOT/index.php:75
Query Time: 2.59 ms After last query: 0.64 ms Query memory: 0.021 MB Memory before query: 7.646 MB Rows returned: 20
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.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.01 ms preparing 0.02 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.02 ms cleaning up 0.01 ms
# Caller File and line number 11 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:169310 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/axslibs/language.php:4849 AxsLanguage::getPublishedLanguages() Copy JROOT/libraries/axslibs/language.php:3938 AxsLanguage::getCurrentLanguage() Copy JROOT/libraries/axslibs/brands.php:7807 AxsBrands::getBrandObject() Copy JROOT/libraries/axslibs/brands.php:676 AxsBrands::getBrand() Copy JROOT/libraries/tovuti/Providers/FeatureFlaggingServiceProvider.php:715 Tovuti\Providers\FeatureFlaggingServiceProvider->getClientMetadata() Copy JROOT/libraries/tovuti/Providers/FeatureFlaggingServiceProvider.php:334 Tovuti\Providers\FeatureFlaggingServiceProvider->register() Copy JROOT/libraries/tovuti/Helpers/AppBootstrapHelper.php:1153 Tovuti\Helpers\AppBootstrapHelper::registerProviderWithDependencies() Copy JROOT/libraries/tovuti/Helpers/AppBootstrapHelper.php:902 Tovuti\Helpers\AppBootstrapHelper::bootstrapServices() Copy JROOT/libraries/tovuti/Helpers/AppBootstrapHelper.php:471 Tovuti\Helpers\AppBootstrapHelper::bootstrap() Copy JROOT/index.php:75
Query Time: 1.50 ms After last query: 0.06 ms Query memory: 0.020 MB Memory before query: 7.670 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.04 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms executing 0.03 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms
# Caller File and line number 11 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:165410 JDatabaseDriver->loadObject() Copy JROOT/libraries/axslibs/language.php:1959 AxsLanguage::getSubdomainDefault() Copy JROOT/libraries/axslibs/language.php:4068 AxsLanguage::getCurrentLanguage() Copy JROOT/libraries/axslibs/brands.php:7807 AxsBrands::getBrandObject() Copy JROOT/libraries/axslibs/brands.php:676 AxsBrands::getBrand() Copy JROOT/libraries/tovuti/Providers/FeatureFlaggingServiceProvider.php:715 Tovuti\Providers\FeatureFlaggingServiceProvider->getClientMetadata() Copy JROOT/libraries/tovuti/Providers/FeatureFlaggingServiceProvider.php:334 Tovuti\Providers\FeatureFlaggingServiceProvider->register() Copy JROOT/libraries/tovuti/Helpers/AppBootstrapHelper.php:1153 Tovuti\Helpers\AppBootstrapHelper::registerProviderWithDependencies() Copy JROOT/libraries/tovuti/Helpers/AppBootstrapHelper.php:902 Tovuti\Helpers\AppBootstrapHelper::bootstrapServices() Copy JROOT/libraries/tovuti/Helpers/AppBootstrapHelper.php:471 Tovuti\Helpers\AppBootstrapHelper::bootstrap() Copy JROOT/index.php:75
Query Time: 1.15 ms After last query: 0.05 ms Query memory: 0.021 MB Memory before query: 7.676 MB Rows returned: 1
SELECT language, published FROM axs_brands WHERE id = 1EXPLAIN not possible on query: SELECT language, published FROM axs_brands WHERE id = 1
Status Duration starting 0.03 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.01 ms executing 0.01 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms
# Caller File and line number 12 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:165411 JDatabaseDriver->loadObject() Copy JROOT/libraries/axslibs/language.php:29510 AxsLanguage::getBrandDefaultLanguage() Copy JROOT/libraries/axslibs/language.php:2019 AxsLanguage::getSubdomainDefault() Copy JROOT/libraries/axslibs/language.php:4068 AxsLanguage::getCurrentLanguage() Copy JROOT/libraries/axslibs/brands.php:7807 AxsBrands::getBrandObject() Copy JROOT/libraries/axslibs/brands.php:676 AxsBrands::getBrand() Copy JROOT/libraries/tovuti/Providers/FeatureFlaggingServiceProvider.php:715 Tovuti\Providers\FeatureFlaggingServiceProvider->getClientMetadata() Copy JROOT/libraries/tovuti/Providers/FeatureFlaggingServiceProvider.php:334 Tovuti\Providers\FeatureFlaggingServiceProvider->register() Copy JROOT/libraries/tovuti/Helpers/AppBootstrapHelper.php:1153 Tovuti\Helpers\AppBootstrapHelper::registerProviderWithDependencies() Copy JROOT/libraries/tovuti/Helpers/AppBootstrapHelper.php:902 Tovuti\Helpers\AppBootstrapHelper::bootstrapServices() Copy JROOT/libraries/tovuti/Helpers/AppBootstrapHelper.php:471 Tovuti\Helpers\AppBootstrapHelper::bootstrap() Copy JROOT/index.php:75
Query Time: 1.07 ms After last query: 1.24 ms Query memory: 0.020 MB Memory before query: 8.015 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.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.06 ms preparing 0.01 ms executing 0.02 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms
# Caller File and line number 10 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:16939 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/axslibs/brands.php:8438 AxsBrands::getHomepageTemplate() Copy JROOT/libraries/axslibs/brands.php:7957 AxsBrands::getBrandObject() Copy JROOT/libraries/axslibs/brands.php:676 AxsBrands::getBrand() Copy JROOT/libraries/tovuti/Providers/FeatureFlaggingServiceProvider.php:715 Tovuti\Providers\FeatureFlaggingServiceProvider->getClientMetadata() Copy JROOT/libraries/tovuti/Providers/FeatureFlaggingServiceProvider.php:334 Tovuti\Providers\FeatureFlaggingServiceProvider->register() Copy JROOT/libraries/tovuti/Helpers/AppBootstrapHelper.php:1153 Tovuti\Helpers\AppBootstrapHelper::registerProviderWithDependencies() Copy JROOT/libraries/tovuti/Helpers/AppBootstrapHelper.php:902 Tovuti\Helpers\AppBootstrapHelper::bootstrapServices() Copy JROOT/libraries/tovuti/Helpers/AppBootstrapHelper.php:471 Tovuti\Helpers\AppBootstrapHelper::bootstrap() Copy JROOT/index.php:75
Query Time: 1.64 ms After last query: 0.08 ms Query memory: 0.020 MB Memory before query: 8.054 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.03 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.01 ms executing 0.01 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.63 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:16939 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/axslibs/brands.php:8518 AxsBrands::getDashboardTemplate() Copy JROOT/libraries/axslibs/brands.php:8157 AxsBrands::getBrandObject() Copy JROOT/libraries/axslibs/brands.php:676 AxsBrands::getBrand() Copy JROOT/libraries/tovuti/Providers/FeatureFlaggingServiceProvider.php:715 Tovuti\Providers\FeatureFlaggingServiceProvider->getClientMetadata() Copy JROOT/libraries/tovuti/Providers/FeatureFlaggingServiceProvider.php:334 Tovuti\Providers\FeatureFlaggingServiceProvider->register() Copy JROOT/libraries/tovuti/Helpers/AppBootstrapHelper.php:1153 Tovuti\Helpers\AppBootstrapHelper::registerProviderWithDependencies() Copy JROOT/libraries/tovuti/Helpers/AppBootstrapHelper.php:902 Tovuti\Helpers\AppBootstrapHelper::bootstrapServices() Copy JROOT/libraries/tovuti/Helpers/AppBootstrapHelper.php:471 Tovuti\Helpers\AppBootstrapHelper::bootstrap() Copy JROOT/index.php:75
Query Time: 1.02 ms After last query: 0.99 ms Query memory: 0.020 MB Memory before query: 8.316 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.03 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.01 ms executing 0.01 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms
# Caller File and line number 10 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:16549 JDatabaseDriver->loadObject() Copy JROOT/libraries/axslibs/brands.php:11298 AxsBrands::getEmailSettingsById() Copy JROOT/libraries/axslibs/brands.php:8217 AxsBrands::getBrandObject() Copy JROOT/libraries/axslibs/brands.php:676 AxsBrands::getBrand() Copy JROOT/libraries/tovuti/Providers/FeatureFlaggingServiceProvider.php:715 Tovuti\Providers\FeatureFlaggingServiceProvider->getClientMetadata() Copy JROOT/libraries/tovuti/Providers/FeatureFlaggingServiceProvider.php:334 Tovuti\Providers\FeatureFlaggingServiceProvider->register() Copy JROOT/libraries/tovuti/Helpers/AppBootstrapHelper.php:1153 Tovuti\Helpers\AppBootstrapHelper::registerProviderWithDependencies() Copy JROOT/libraries/tovuti/Helpers/AppBootstrapHelper.php:902 Tovuti\Helpers\AppBootstrapHelper::bootstrapServices() Copy JROOT/libraries/tovuti/Helpers/AppBootstrapHelper.php:471 Tovuti\Helpers\AppBootstrapHelper::bootstrap() Copy JROOT/index.php:75
Query Time: 1.83 ms After last query: 2.99 ms Query memory: 0.039 MB Memory before query: 8.595 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.03 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.01 ms executing 0.29 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms
# Caller File and line number 16 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:169315 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/cms/component/helper.php:44714 JComponentHelper::{closure}() Copy JROOT/libraries/joomla/cache/controller/callback.php:16913 JCacheControllerCallback->get() Copy JROOT/libraries/cms/component/helper.php:45512 JComponentHelper::load() Copy JROOT/libraries/cms/component/helper.php:4311 JComponentHelper::getComponent() Copy JROOT/libraries/cms/component/helper.php:11110 JComponentHelper::getParams() Copy JROOT/libraries/joomla/access/access.php:9419 JAccess::getGroupsByUser() Copy JROOT/libraries/joomla/user/user.php:4768 JUser->getAuthorisedGroups() Copy JROOT/libraries/axslibs/brands.php:8227 AxsBrands::getBrandObject() Copy JROOT/libraries/axslibs/brands.php:676 AxsBrands::getBrand() Copy JROOT/libraries/tovuti/Providers/FeatureFlaggingServiceProvider.php:715 Tovuti\Providers\FeatureFlaggingServiceProvider->getClientMetadata() Copy JROOT/libraries/tovuti/Providers/FeatureFlaggingServiceProvider.php:334 Tovuti\Providers\FeatureFlaggingServiceProvider->register() Copy JROOT/libraries/tovuti/Helpers/AppBootstrapHelper.php:1153 Tovuti\Helpers\AppBootstrapHelper::registerProviderWithDependencies() Copy JROOT/libraries/tovuti/Helpers/AppBootstrapHelper.php:902 Tovuti\Helpers\AppBootstrapHelper::bootstrapServices() Copy JROOT/libraries/tovuti/Helpers/AppBootstrapHelper.php:471 Tovuti\Helpers\AppBootstrapHelper::bootstrap() Copy JROOT/index.php:75
Query Time: 1.31 ms After last query: 0.56 ms Query memory: 0.021 MB Memory before query: 8.653 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.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.06 ms preparing 0.03 ms executing 0.02 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms
# Caller File and line number 11 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:154210 JDatabaseDriver->loadColumn() Copy JROOT/libraries/joomla/access/access.php:9829 JAccess::getGroupsByUser() Copy JROOT/libraries/joomla/user/user.php:4768 JUser->getAuthorisedGroups() Copy JROOT/libraries/axslibs/brands.php:8227 AxsBrands::getBrandObject() Copy JROOT/libraries/axslibs/brands.php:676 AxsBrands::getBrand() Copy JROOT/libraries/tovuti/Providers/FeatureFlaggingServiceProvider.php:715 Tovuti\Providers\FeatureFlaggingServiceProvider->getClientMetadata() Copy JROOT/libraries/tovuti/Providers/FeatureFlaggingServiceProvider.php:334 Tovuti\Providers\FeatureFlaggingServiceProvider->register() Copy JROOT/libraries/tovuti/Helpers/AppBootstrapHelper.php:1153 Tovuti\Helpers\AppBootstrapHelper::registerProviderWithDependencies() Copy JROOT/libraries/tovuti/Helpers/AppBootstrapHelper.php:902 Tovuti\Helpers\AppBootstrapHelper::bootstrapServices() Copy JROOT/libraries/tovuti/Helpers/AppBootstrapHelper.php:471 Tovuti\Helpers\AppBootstrapHelper::bootstrap() Copy JROOT/index.php:75
Query Time: 1.25 ms After last query: 0.04 ms Query memory: 0.020 MB Memory before query: 8.658 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.03 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.03 ms preparing 0.01 ms executing 0.01 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms
# Caller File and line number 10 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:16549 JDatabaseDriver->loadObject() Copy JROOT/libraries/axslibs/brands.php:10778 AxsBrands::getPaymentGatewayById() Copy JROOT/libraries/axslibs/brands.php:8247 AxsBrands::getBrandObject() Copy JROOT/libraries/axslibs/brands.php:676 AxsBrands::getBrand() Copy JROOT/libraries/tovuti/Providers/FeatureFlaggingServiceProvider.php:715 Tovuti\Providers\FeatureFlaggingServiceProvider->getClientMetadata() Copy JROOT/libraries/tovuti/Providers/FeatureFlaggingServiceProvider.php:334 Tovuti\Providers\FeatureFlaggingServiceProvider->register() Copy JROOT/libraries/tovuti/Helpers/AppBootstrapHelper.php:1153 Tovuti\Helpers\AppBootstrapHelper::registerProviderWithDependencies() Copy JROOT/libraries/tovuti/Helpers/AppBootstrapHelper.php:902 Tovuti\Helpers\AppBootstrapHelper::bootstrapServices() Copy JROOT/libraries/tovuti/Helpers/AppBootstrapHelper.php:471 Tovuti\Helpers\AppBootstrapHelper::bootstrap() Copy JROOT/index.php:75
Query Time: 1.09 ms After last query: 0.08 ms Query memory: 0.020 MB Memory before query: 8.668 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.03 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.01 ms executing 0.01 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms
# Caller File and line number 10 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:16549 JDatabaseDriver->loadObject() Copy JROOT/libraries/axslibs/brands.php:11488 AxsBrands::getIntegrationById() Copy JROOT/libraries/axslibs/brands.php:8317 AxsBrands::getBrandObject() Copy JROOT/libraries/axslibs/brands.php:676 AxsBrands::getBrand() Copy JROOT/libraries/tovuti/Providers/FeatureFlaggingServiceProvider.php:715 Tovuti\Providers\FeatureFlaggingServiceProvider->getClientMetadata() Copy JROOT/libraries/tovuti/Providers/FeatureFlaggingServiceProvider.php:334 Tovuti\Providers\FeatureFlaggingServiceProvider->register() Copy JROOT/libraries/tovuti/Helpers/AppBootstrapHelper.php:1153 Tovuti\Helpers\AppBootstrapHelper::registerProviderWithDependencies() Copy JROOT/libraries/tovuti/Helpers/AppBootstrapHelper.php:902 Tovuti\Helpers\AppBootstrapHelper::bootstrapServices() Copy JROOT/libraries/tovuti/Helpers/AppBootstrapHelper.php:471 Tovuti\Helpers\AppBootstrapHelper::bootstrap() Copy JROOT/index.php:75
Query Time: 1.07 ms After last query: 15.79 ms Query memory: 0.020 MB Memory before query: 10.536 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.03 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.01 ms System lock 0.01 ms optimizing 0.00 ms statistics 0.01 ms preparing 0.01 ms executing 0.04 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms
# Caller File and line number 10 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:14989 JDatabaseDriver->loadAssocList() Copy JROOT/libraries/joomla/access/access.php:10658 JAccess::getAuthorisedViewLevels() Copy JROOT/libraries/joomla/user/user.php:4547 JUser->getAuthorisedViewLevels() Copy JROOT/libraries/cms/plugin/helper.php:2936 JPluginHelper::load() Copy JROOT/libraries/cms/plugin/helper.php:865 JPluginHelper::getPlugin() Copy JROOT/libraries/cms/plugin/helper.php:1284 JPluginHelper::isEnabled() Copy JROOT/libraries/cms/application/site.php:6083 JApplicationSite->initialiseApp() Copy JROOT/libraries/cms/application/site.php:2092 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2671 JApplicationCms->execute() Copy JROOT/index.php:78
Query Time: 2.43 ms After last query: 0.08 ms Query memory: 0.038 MB Memory before query: 10.561 MB Rows returned: 142
SELECT `folder` AS `type`,`element` AS `name`,`params`
FROM joom_extensions
WHERE enabled = 1 AND type = 'plugin' AND state IN (0,1) AND access IN (1,1)
ORDER BY 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.06 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.04 ms init 0.01 ms System lock 0.02 ms optimizing 0.02 ms statistics 0.08 ms preparing 0.03 ms executing 1.28 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms
# Caller File and line number 10 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:16939 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/cms/plugin/helper.php:3118 JPluginHelper::{closure}() Copy JROOT/libraries/joomla/cache/controller/callback.php:1697 JCacheControllerCallback->get() Copy JROOT/libraries/cms/plugin/helper.php:3166 JPluginHelper::load() Copy JROOT/libraries/cms/plugin/helper.php:865 JPluginHelper::getPlugin() Copy JROOT/libraries/cms/plugin/helper.php:1284 JPluginHelper::isEnabled() Copy JROOT/libraries/cms/application/site.php:6083 JApplicationSite->initialiseApp() Copy JROOT/libraries/cms/application/site.php:2092 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2671 JApplicationCms->execute() Copy JROOT/index.php:78
Query Time: 1.17 ms After last query: 13.73 ms Query memory: 0.023 MB Memory before query: 12.568 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.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.08 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 17 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:165416 JDatabaseDriver->loadObject() Copy JROOT/libraries/cms/library/helper.php:16615 JLibraryHelper::{closure}() Copy JROOT/libraries/joomla/cache/controller/callback.php:16914 JCacheControllerCallback->get() Copy JROOT/libraries/cms/library/helper.php:17413 JLibraryHelper::loadLibrary() Copy JROOT/libraries/cms/library/helper.php:4212 JLibraryHelper::getLibrary() Copy JROOT/libraries/cms/library/helper.php:8911 JLibraryHelper::getParams() Copy JROOT/libraries/cms/version/version.php:27010 JVersion->getMediaVersion() Copy JROOT/libraries/joomla/factory.php:8509 JFactory::createDocument() Copy JROOT/libraries/joomla/factory.php:2248 JFactory::getDocument() Copy JROOT/plugins/system/mootable/mootable.php:1007 PlgSystemMootable->__construct() Copy JROOT/libraries/cms/plugin/helper.php:2556 JPluginHelper::import() Copy JROOT/libraries/cms/plugin/helper.php:1705 JPluginHelper::importPlugin() Copy JROOT/libraries/cms/application/cms.php:7174 JApplicationCms->initialiseApp() Copy JROOT/libraries/cms/application/site.php:6903 JApplicationSite->initialiseApp() Copy JROOT/libraries/cms/application/site.php:2092 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2671 JApplicationCms->execute() Copy JROOT/index.php:78
Query Time: 1.09 ms After last query: 0.07 ms Query memory: 0.005 MB Memory before query: 12.660 MB
UPDATE `joom_extensions `
SET `params` = '{\"mediaversion\":\"a55f30393fe2a9a372277416599182f2\"}'
WHERE `type` = 'library' AND `element` = 'joomla'EXPLAIN not possible on query: UPDATE `joom_extensions`
SET `params` = '{\"mediaversion\":\"a55f30393fe2a9a372277416599182f2\"}'
WHERE `type` = 'library' AND `element` = 'joomla'
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.09 ms updating 0.05 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.01 ms cleaning up 0.01 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:8509 JFactory::createDocument() Copy JROOT/libraries/joomla/factory.php:2248 JFactory::getDocument() Copy JROOT/plugins/system/mootable/mootable.php:1007 PlgSystemMootable->__construct() Copy JROOT/libraries/cms/plugin/helper.php:2556 JPluginHelper::import() Copy JROOT/libraries/cms/plugin/helper.php:1705 JPluginHelper::importPlugin() Copy JROOT/libraries/cms/application/cms.php:7174 JApplicationCms->initialiseApp() Copy JROOT/libraries/cms/application/site.php:6903 JApplicationSite->initialiseApp() Copy JROOT/libraries/cms/application/site.php:2092 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2671 JApplicationCms->execute() Copy JROOT/index.php:78
Query Time: 1.34 ms After last query: 4.38 ms Query memory: 0.020 MB Memory before query: 13.236 MB Rows returned: 20
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.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.03 ms executing 0.14 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms
# Caller File and line number 10 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:16939 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/joomla/language/helper.php:1488 JLanguageHelper::getLanguages() Copy JROOT/plugins/system/languagefilter/languagefilter.php:1037 PlgSystemLanguageFilter->__construct() Copy JROOT/libraries/cms/plugin/helper.php:2556 JPluginHelper::import() Copy JROOT/libraries/cms/plugin/helper.php:1705 JPluginHelper::importPlugin() Copy JROOT/libraries/cms/application/cms.php:7174 JApplicationCms->initialiseApp() Copy JROOT/libraries/cms/application/site.php:6903 JApplicationSite->initialiseApp() Copy JROOT/libraries/cms/application/site.php:2092 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2671 JApplicationCms->execute() Copy JROOT/index.php:78
Query Time: 2.39 ms After last query: 0.09 ms Query memory: 0.022 MB Memory before query: 13.263 MB Rows returned: 96
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.04 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.06 ms preparing 0.02 ms executing 0.32 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms
# Caller File and line number 10 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:16939 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/joomla/language/helper.php:2078 JLanguageHelper::getInstalledLanguages() Copy JROOT/plugins/system/languagefilter/languagefilter.php:1177 PlgSystemLanguageFilter->__construct() Copy JROOT/libraries/cms/plugin/helper.php:2556 JPluginHelper::import() Copy JROOT/libraries/cms/plugin/helper.php:1705 JPluginHelper::importPlugin() Copy JROOT/libraries/cms/application/cms.php:7174 JApplicationCms->initialiseApp() Copy JROOT/libraries/cms/application/site.php:6903 JApplicationSite->initialiseApp() Copy JROOT/libraries/cms/application/site.php:2092 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2671 JApplicationCms->execute() Copy JROOT/index.php:78
Query Time: 3.87 ms After last query: 10.98 ms Query memory: 0.074 MB Memory before query: 14.865 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.09 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.06 ms init 0.01 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.07 ms preparing 0.04 ms executing 1.15 ms end 0.51 ms query end 0.01 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms
# Caller File and line number 24 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:169323 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/cms/menu/site.php:8822 JMenuSite->{closure}() Copy JROOT/libraries/joomla/cache/controller/callback.php:16921 JCacheControllerCallback->get() Copy JROOT/libraries/cms/menu/site.php:9620 JMenuSite->load() Copy JROOT/libraries/cms/menu/menu.php:7419 JMenu->__construct() Copy JROOT/libraries/cms/menu/site.php:5718 JMenuSite->__construct() Copy JROOT/libraries/cms/menu/menu.php:12917 JMenu::getInstance() Copy JROOT/libraries/cms/application/cms.php:49716 JApplicationCms->getMenu() Copy JROOT/libraries/cms/application/site.php:27715 JApplicationSite->getMenu() Copy JROOT/libraries/cms/router/site.php:5914 JRouterSite->__construct() Copy JROOT/libraries/cms/router/router.php:19813 JRouter::getInstance() Copy JROOT/libraries/cms/application/cms.php:59112 JApplicationCms::getRouter() Copy JROOT/libraries/cms/application/site.php:40711 JApplicationSite::getRouter() Copy JROOT/plugins/system/languagefilter/languagefilter.php:13810 PlgSystemLanguageFilter->onAfterInitialise() Same as call in the line below. 9 ReflectionMethod->invokeArgs() Copy JROOT/libraries/tovuti/Helpers/MethodHelper.php:588 Tovuti\Helpers\MethodHelper::call() Copy JROOT/libraries/joomla/event/event.php:727 JEvent->update() Copy JROOT/libraries/joomla/event/dispatcher.php:1606 JEventDispatcher->trigger() Copy JROOT/libraries/joomla/application/base.php:1065 JApplicationBase->triggerEvent() Copy JROOT/libraries/cms/application/cms.php:7184 JApplicationCms->initialiseApp() Copy JROOT/libraries/cms/application/site.php:6903 JApplicationSite->initialiseApp() Copy JROOT/libraries/cms/application/site.php:2092 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2671 JApplicationCms->execute() Copy JROOT/index.php:78
Query Time: 1.13 ms After last query: 23.83 ms Query memory: 0.020 MB Memory before query: 17.538 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.05 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.03 ms executing 0.01 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms
# Caller File and line number 9 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:16548 JDatabaseDriver->loadObject() Copy JROOT/libraries/axslibs/user.php:8047 AxsUser::{closure}() Copy JROOT/libraries/tovuti/Traits/Memoization.php:256 AxsUser::memoizeStatic() Copy JROOT/libraries/axslibs/user.php:7945 AxsUser::getGlobalUserSettings() Copy JROOT/libraries/axslibs/security.php:354 AxsSecurity::getSettings() Copy JROOT/libraries/cms/application/cms.php:3683 JApplicationCms->checkUserRequireTwoFactor() Copy JROOT/libraries/cms/application/site.php:2312 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2671 JApplicationCms->execute() Copy JROOT/index.php:78
Query Time: 2.66 ms After last query: 4.04 ms Query memory: 0.022 MB Memory before query: 17.929 MB Rows returned: 20
SHOW FULL COLUMNS FROM `joom_users `EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `joom_users`
Status Duration starting 0.06 ms Executing hook on transaction 0.01 ms starting 0.06 ms checking permissions 0.01 ms checking permissions 0.00 ms Opening tables 0.63 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.12 ms preparing 0.03 ms Creating tmp table 0.05 ms executing 0.09 ms checking permissions 0.07 ms checking permissions 0.03 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.03 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.03 ms checking permissions 0.02 ms checking permissions 0.03 ms checking permissions 0.02 ms checking permissions 0.03 ms checking permissions 0.02 ms checking permissions 0.03 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.03 ms checking permissions 0.01 ms checking permissions 0.06 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.02 ms closing tables 0.02 ms freeing items 0.05 ms cleaning up 0.02 ms
# Caller File and line number 14 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:169313 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/joomla/database/driver/mysqli.php:43512 JDatabaseDriverMysqli->getTableColumns() Copy JROOT/libraries/joomla/table/table.php:24411 JTable->getFields() Copy JROOT/libraries/joomla/table/table.php:16310 JTable->__construct() Copy JROOT/libraries/joomla/table/user.php:399 JTableUser->__construct() Copy JROOT/libraries/joomla/table/table.php:3118 JTable::getInstance() Copy JROOT/administrator/components/com_users/models/user.php:647 UsersModelUser->getTable() Copy JROOT/libraries/legacy/model/admin.php:9516 JModelAdmin->populateState() Copy JROOT/libraries/legacy/model/legacy.php:4405 JModelLegacy->getState() Copy JROOT/administrator/components/com_users/models/user.php:9734 UsersModelUser->getOtpConfig() Copy JROOT/libraries/cms/application/cms.php:3723 JApplicationCms->checkUserRequireTwoFactor() Copy JROOT/libraries/cms/application/site.php:2312 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2671 JApplicationCms->execute() Copy JROOT/index.php:78
Query Time: 1.28 ms After last query: 0.39 ms Query memory: 0.018 MB Memory before query: 17.969 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.06 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.05 ms executing 0.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 6 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:16545 JDatabaseDriver->loadObject() Copy JROOT/administrator/components/com_users/models/user.php:9924 UsersModelUser->getOtpConfig() Copy JROOT/libraries/cms/application/cms.php:3723 JApplicationCms->checkUserRequireTwoFactor() Copy JROOT/libraries/cms/application/site.php:2312 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2671 JApplicationCms->execute() Copy JROOT/index.php:78
Query Time: 1.30 ms After last query: 0.15 ms Query memory: 0.019 MB Memory before query: 17.980 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.06 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.04 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.07 ms preparing 0.03 ms executing 0.12 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.02 ms
# Caller File and line number 6 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:16935 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/cms/application/site.php:4904 JApplicationSite->getTemplate() Copy JROOT/libraries/cms/application/site.php:1653 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2671 JApplicationCms->execute() Copy JROOT/index.php:78
Query Time: 1.29 ms After last query: 17.96 ms Query memory: 0.023 MB Memory before query: 19.733 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.04 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.01 ms executing 0.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:165416 JDatabaseDriver->loadObject() Copy JROOT/libraries/axslibs/lms.php:256015 AxsLMS::getSettings() Copy JROOT/components/com_splms/models/courses.php:4214 SplmsModelCourses->__construct() Copy JROOT/libraries/fof/model/model.php:34913 FOFModel::getAnInstance() Copy JROOT/libraries/fof/controller/controller.php:254412 FOFController->createModel() Copy JROOT/libraries/fof/controller/controller.php:231711 FOFController->getModel() Copy JROOT/libraries/fof/controller/controller.php:227910 FOFController->getThisModel() Copy JROOT/components/com_splms/controllers/courses.php:259 SplmsControllerCourses->onBeforeBrowse() Copy JROOT/libraries/fof/controller/controller.php:9198 FOFController->execute() Copy JROOT/libraries/fof/dispatcher/dispatcher.php:3327 FOFDispatcher->dispatch() Copy JROOT/components/com_splms/splms.php:356 require_once Copy JROOT/components/com_splms/splms.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2671 JApplicationCms->execute() Copy JROOT/index.php:78
Query Time: 1.49 ms After last query: 8.58 ms Query memory: 0.027 MB Memory before query: 20.745 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.12 ms Executing hook on transaction 0.02 ms starting 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.12 ms init 0.02 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.14 ms preparing 0.05 ms executing 0.05 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.02 ms freeing items 0.03 ms cleaning up 0.02 ms
# Caller File and line number 26 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:169325 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/legacy/model/legacy.php:30724 JModelLegacy->_getList() Copy JROOT/administrator/components/com_fields/models/fields.php:32623 FieldsModelFields->_getList() Copy JROOT/libraries/legacy/model/list.php:18922 JModelList->getItems() Copy JROOT/administrator/components/com_fields/helpers/fields.php:13421 FieldsHelper::getFields() Copy JROOT/administrator/components/com_fields/helpers/fields.php:28020 FieldsHelper::prepareForm() Copy JROOT/plugins/system/fields/fields.php:23619 PlgSystemFields->onContentPrepareForm() Same as call in the line below. 18 ReflectionMethod->invokeArgs() Copy JROOT/libraries/tovuti/Helpers/MethodHelper.php:5817 Tovuti\Helpers\MethodHelper::call() Copy JROOT/libraries/joomla/event/event.php:7216 JEvent->update() Copy JROOT/libraries/joomla/event/dispatcher.php:16015 JEventDispatcher->trigger() Copy JROOT/libraries/joomla/application/base.php:10614 JApplicationBase->triggerEvent() Copy JROOT/libraries/fof/integration/joomla/platform.php:54513 FOFIntegrationJoomlaPlatform->runPlugins() Copy JROOT/libraries/fof/model/model.php:267612 FOFModel->preprocessForm() Copy JROOT/libraries/fof/model/model.php:252111 FOFModel->loadForm() Copy JROOT/libraries/fof/model/model.php:243110 FOFModel->getForm() Copy JROOT/libraries/fof/controller/controller.php:11589 FOFController->browse() Copy JROOT/libraries/fof/controller/controller.php:9678 FOFController->execute() Copy JROOT/libraries/fof/dispatcher/dispatcher.php:3327 FOFDispatcher->dispatch() Copy JROOT/components/com_splms/splms.php:356 require_once Copy JROOT/components/com_splms/splms.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2671 JApplicationCms->execute() Copy JROOT/index.php:78
Query Time: 1.80 ms After last query: 9.86 ms Query memory: 0.026 MB Memory before query: 21.323 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.12 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.07 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.22 ms preparing 0.03 ms executing 0.38 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.02 ms
# Caller File and line number 23 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:169322 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/joomla/access/access.php:43021 JAccess::preloadComponents() Copy JROOT/libraries/joomla/access/access.php:21120 JAccess::preload() Copy JROOT/libraries/joomla/access/access.php:53319 JAccess::getAssetRules() Copy JROOT/libraries/joomla/access/access.php:18118 JAccess::check() Copy JROOT/libraries/joomla/user/user.php:39417 JUser->authorise() Copy JROOT/libraries/fof/integration/joomla/platform.php:58416 FOFIntegrationJoomlaPlatform->authorise() Copy JROOT/libraries/fof/view/raw.php:8015 FOFViewRaw->__construct() Copy JROOT/libraries/fof/view/html.php:5314 FOFViewHtml->__construct() Copy JROOT/libraries/fof/controller/controller.php:280813 FOFController->createView() Copy JROOT/libraries/fof/controller/controller.php:250312 FOFController->getView() Copy JROOT/libraries/fof/controller/controller.php:240511 FOFController->getThisView() Copy JROOT/libraries/fof/controller/controller.php:102510 FOFController->display() Copy JROOT/libraries/fof/controller/controller.php:11659 FOFController->browse() Copy JROOT/libraries/fof/controller/controller.php:9678 FOFController->execute() Copy JROOT/libraries/fof/dispatcher/dispatcher.php:3327 FOFDispatcher->dispatch() Copy JROOT/components/com_splms/splms.php:356 require_once Copy JROOT/components/com_splms/splms.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2671 JApplicationCms->execute() Copy JROOT/index.php:78
Query Time: 11.55 ms After last query: 0.57 ms Query memory: 0.056 MB Memory before query: 21.442 MB Rows returned: 790
SHOW TABLES EXPLAIN not possible on query: SHOW TABLES
Status Duration 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.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.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.02 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.21 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.02 ms closing tables 0.02 ms freeing items 0.09 ms cleaning up 0.02 ms
# Caller File and line number 22 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:154221 JDatabaseDriver->loadColumn() Copy JROOT/libraries/joomla/database/driver/mysqli.php:49120 JDatabaseDriverMysqli->getTableList() Copy JROOT/libraries/fof/database/driver/joomla.php:25119 FOFDatabaseDriverJoomla->getTableList() Copy JROOT/libraries/fof/table/table.php:209618 FOFTable->getTableFields() Copy JROOT/libraries/fof/table/table.php:53617 FOFTable->__construct() Copy JROOT/libraries/fof/table/table.php:43316 FOFTable::getAnInstance() Copy JROOT/libraries/fof/model/model.php:210115 FOFModel->_createTable() Copy JROOT/libraries/fof/model/model.php:205814 FOFModel->getTable() Copy JROOT/libraries/fof/view/raw.php:19013 FOFViewRaw->onDisplay() Copy JROOT/libraries/fof/view/raw.php:16712 FOFViewRaw->onBrowse() Copy JROOT/libraries/fof/view/form.php:4711 FOFViewForm->display() Copy JROOT/libraries/fof/controller/controller.php:112510 FOFController->display() Copy JROOT/libraries/fof/controller/controller.php:11659 FOFController->browse() Copy JROOT/libraries/fof/controller/controller.php:9678 FOFController->execute() Copy JROOT/libraries/fof/dispatcher/dispatcher.php:3327 FOFDispatcher->dispatch() Copy JROOT/components/com_splms/splms.php:356 require_once Copy JROOT/components/com_splms/splms.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2671 JApplicationCms->execute() Copy JROOT/index.php:78
Query Time: 3.71 ms After last query: 0.22 ms Query memory: 0.026 MB Memory before query: 21.510 MB Rows returned: 45
SHOW FULL COLUMNS FROM `joom_splms_courses `EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `joom_splms_courses`
Status Duration starting 0.07 ms Executing hook on transaction 0.01 ms starting 0.05 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.94 ms init 0.02 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.17 ms preparing 0.04 ms Creating tmp table 0.05 ms executing 0.08 ms checking permissions 0.09 ms checking permissions 0.07 ms checking permissions 0.03 ms checking permissions 0.02 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.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.03 ms checking permissions 0.04 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.03 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.03 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.03 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.03 ms checking permissions 0.01 ms checking permissions 0.08 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.02 ms closing tables 0.02 ms freeing items 0.07 ms cleaning up 0.02 ms
# Caller File and line number 22 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:169321 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/joomla/database/driver/mysqli.php:43520 JDatabaseDriverMysqli->getTableColumns() Copy JROOT/libraries/fof/database/driver/joomla.php:22919 FOFDatabaseDriverJoomla->getTableColumns() Copy JROOT/libraries/fof/table/table.php:218118 FOFTable->getTableFields() Copy JROOT/libraries/fof/table/table.php:53617 FOFTable->__construct() Copy JROOT/libraries/fof/table/table.php:43316 FOFTable::getAnInstance() Copy JROOT/libraries/fof/model/model.php:210115 FOFModel->_createTable() Copy JROOT/libraries/fof/model/model.php:205814 FOFModel->getTable() Copy JROOT/libraries/fof/view/raw.php:19013 FOFViewRaw->onDisplay() Copy JROOT/libraries/fof/view/raw.php:16712 FOFViewRaw->onBrowse() Copy JROOT/libraries/fof/view/form.php:4711 FOFViewForm->display() Copy JROOT/libraries/fof/controller/controller.php:112510 FOFController->display() Copy JROOT/libraries/fof/controller/controller.php:11659 FOFController->browse() Copy JROOT/libraries/fof/controller/controller.php:9678 FOFController->execute() Copy JROOT/libraries/fof/dispatcher/dispatcher.php:3327 FOFDispatcher->dispatch() Copy JROOT/components/com_splms/splms.php:356 require_once Copy JROOT/components/com_splms/splms.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2671 JApplicationCms->execute() Copy JROOT/index.php:78
Query Time: 1.09 ms After last query: 1.15 ms Query memory: 0.026 MB Memory before query: 21.749 MB Rows returned: 1
SELECT params
FROM axs_lms_settings
WHERE id= 1 LIMIT 1EXPLAIN not possible on query: SELECT params
FROM axs_lms_settings
WHERE id=1 LIMIT 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.05 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.01 ms executing 0.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 25 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:165424 JDatabaseDriver->loadObject() Copy JROOT/libraries/tovuti/Services/SettingsService.php:3723 Tovuti\Services\SettingsService->Tovuti\Services\{closure}() Copy JROOT/libraries/tovuti/Traits/Memoization.php:2522 Tovuti\Services\SettingsService::memoizeStatic() Copy JROOT/libraries/tovuti/Traits/Memoization.php:4021 Tovuti\Services\SettingsService->memoize() Copy JROOT/libraries/tovuti/Services/SettingsService.php:3020 Tovuti\Services\SettingsService->getSettings() Copy JROOT/libraries/tovuti/Services/SettingsService.php:1019 Tovuti\Services\SettingsService->getSetting() Copy JROOT/libraries/tovuti/Helpers/DefaultSortHelper.php:3418 Tovuti\Helpers\DefaultSortHelper::isEnabled() Copy JROOT/libraries/tovuti/FOF/Traits/DefaultSort.php:2517 FOFModel->Tovuti\FOF\Traits\{closure}() Copy JROOT/libraries/tovuti/Traits/Memoization.php:2516 FOFModel::memoizeStatic() Copy JROOT/libraries/tovuti/Traits/Memoization.php:4015 FOFModel->memoize() Copy JROOT/libraries/tovuti/FOF/Traits/DefaultSort.php:2414 FOFModel->getAlphaSortColumn() Copy JROOT/libraries/fof/view/raw.php:19413 FOFViewRaw->onDisplay() Copy JROOT/libraries/fof/view/raw.php:16712 FOFViewRaw->onBrowse() Copy JROOT/libraries/fof/view/form.php:4711 FOFViewForm->display() Copy JROOT/libraries/fof/controller/controller.php:112510 FOFController->display() Copy JROOT/libraries/fof/controller/controller.php:11659 FOFController->browse() Copy JROOT/libraries/fof/controller/controller.php:9678 FOFController->execute() Copy JROOT/libraries/fof/dispatcher/dispatcher.php:3327 FOFDispatcher->dispatch() Copy JROOT/components/com_splms/splms.php:356 require_once Copy JROOT/components/com_splms/splms.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2671 JApplicationCms->execute() Copy JROOT/index.php:78
Query Time: 1.10 ms After last query: 5.50 ms Query memory: 0.024 MB Memory before query: 22.265 MB Rows returned: 0
SELECT 1 FROM axs_learning_paths
WHERE enabled = 1 AND restrict_course_visibility = 1
LIMIT 1EXPLAIN not possible on query: SELECT 1 FROM axs_learning_paths
WHERE enabled = 1 AND restrict_course_visibility = 1
LIMIT 1
Status Duration starting 0.06 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.02 ms executing 0.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.04 ms
# Caller File and line number 19 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:173218 JDatabaseDriver->loadResult() Copy JROOT/libraries/axslibs/learningPaths.php:18317 AxsLearningPaths::hasRestrictingLearningPaths() Copy JROOT/libraries/axslibs/learningPaths.php:22216 AxsLearningPaths::getCatalogVisibilityCondition() Copy JROOT/components/com_splms/models/courses.php:16515 SplmsModelCourses->getAllCourses() Copy JROOT/components/com_splms/models/courses.php:9014 SplmsModelCourses->getItemList() Copy JROOT/libraries/fof/view/raw.php:20213 FOFViewRaw->onDisplay() Copy JROOT/libraries/fof/view/raw.php:16712 FOFViewRaw->onBrowse() Copy JROOT/libraries/fof/view/form.php:4711 FOFViewForm->display() Copy JROOT/libraries/fof/controller/controller.php:112510 FOFController->display() Copy JROOT/libraries/fof/controller/controller.php:11659 FOFController->browse() Copy JROOT/libraries/fof/controller/controller.php:9678 FOFController->execute() Copy JROOT/libraries/fof/dispatcher/dispatcher.php:3327 FOFDispatcher->dispatch() Copy JROOT/components/com_splms/splms.php:356 require_once Copy JROOT/components/com_splms/splms.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2671 JApplicationCms->execute() Copy JROOT/index.php:78
Query Time: 1.31 ms After last query: 0.08 ms Query memory: 0.024 MB Memory before query: 22.276 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.06 ms statistics 0.03 ms preparing 0.04 ms executing 0.09 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms
# Caller File and line number 19 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:169318 JDatabaseDriver->loadObjectList() Copy JROOT/components/com_splms/models/courses.php:60717 SplmsModelCourses->getAllCategories() Copy JROOT/components/com_splms/models/courses.php:10816 SplmsModelCourses->getCategoryConditions() Copy JROOT/components/com_splms/models/courses.php:16915 SplmsModelCourses->getAllCourses() Copy JROOT/components/com_splms/models/courses.php:9014 SplmsModelCourses->getItemList() Copy JROOT/libraries/fof/view/raw.php:20213 FOFViewRaw->onDisplay() Copy JROOT/libraries/fof/view/raw.php:16712 FOFViewRaw->onBrowse() Copy JROOT/libraries/fof/view/form.php:4711 FOFViewForm->display() Copy JROOT/libraries/fof/controller/controller.php:112510 FOFController->display() Copy JROOT/libraries/fof/controller/controller.php:11659 FOFController->browse() Copy JROOT/libraries/fof/controller/controller.php:9678 FOFController->execute() Copy JROOT/libraries/fof/dispatcher/dispatcher.php:3327 FOFDispatcher->dispatch() Copy JROOT/components/com_splms/splms.php:356 require_once Copy JROOT/components/com_splms/splms.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2671 JApplicationCms->execute() Copy JROOT/index.php:78
Query Time: 1.75 ms After last query: 0.06 ms Query memory: 0.039 MB Memory before query: 22.284 MB Rows returned: 7
SELECT *
FROM `joom_splms_courses `
WHERE `enabled`= 1 AND (brand_specific = 0 OR (brand_specific = 1 AND FIND_IN_SET (1,brands))) AND (course_visible_before_open = 1 OR course_open_date IS NULL OR course_open_date = '0000-00-00' OR (DATE (NOW ()) >= course_open_date)) AND (course_visible_after_close = 1 OR course_close_date IS NULL OR course_close_date = '0000-00-00' OR (DATE (NOW ()) <= course_close_date)) AND ( ( access_type = 'access' AND ( ( FIND_IN_SET ( 1, accesslevel ) > 0 ) OR ( FIND_IN_SET ( 1, accesslevel ) > 0 ) ) ) OR ( access_type = 'user' AND ( ( FIND_IN_SET ( 1, usergroup ) > 0 ) ) ) OR ( access_type = 'list' AND ( FIND_IN_SET ( 0, userlist ) > 0 ) ) OR ( access_type = 'none' OR access_type IS NULL ) ) AND ((FIND_IN_SET ('1', splms_coursescategory_id) > 0)OR (FIND_IN_SET ('6', splms_coursescategory_id) > 0)) AND ( ( brand_specific = 1 AND FIND_IN_SET ( 1, brands ) > 0 ) OR ( brand_specific = 0 ))
ORDER BY ordering ASC LIMIT 32EXPLAIN not possible on query: SELECT *
FROM `joom_splms_courses`
WHERE `enabled`=1 AND (brand_specific = 0 OR (brand_specific = 1 AND FIND_IN_SET(1,brands))) AND (course_visible_before_open = 1 OR course_open_date IS NULL OR course_open_date = '0000-00-00' OR (DATE(NOW()) >= course_open_date)) AND (course_visible_after_close = 1 OR course_close_date IS NULL OR course_close_date = '0000-00-00' OR (DATE(NOW()) <= course_close_date)) AND ( ( access_type = 'access' AND ( ( FIND_IN_SET( 1, accesslevel ) > 0 ) OR ( FIND_IN_SET( 1, accesslevel ) > 0 ) ) ) OR ( access_type = 'user' AND ( ( FIND_IN_SET( 1, usergroup ) > 0 ) ) ) OR ( access_type = 'list' AND ( FIND_IN_SET( 0, userlist ) > 0 ) ) OR ( access_type = 'none' OR access_type IS NULL ) ) AND ((FIND_IN_SET('1', splms_coursescategory_id) > 0)OR(FIND_IN_SET('6', splms_coursescategory_id) > 0)) AND ( ( brand_specific = 1 AND FIND_IN_SET( 1, brands ) > 0 ) OR ( brand_specific = 0 ))
ORDER BY ordering ASC LIMIT 32
Status Duration starting 0.13 ms Executing hook on transaction 0.01 ms starting 0.03 ms checking permissions 0.01 ms Opening tables 0.08 ms init 0.01 ms System lock 0.01 ms optimizing 0.05 ms statistics 0.08 ms preparing 0.05 ms executing 0.20 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.02 ms
# Caller File and line number 17 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:169316 JDatabaseDriver->loadObjectList() Copy JROOT/components/com_splms/models/courses.php:18415 SplmsModelCourses->getAllCourses() Copy JROOT/components/com_splms/models/courses.php:9014 SplmsModelCourses->getItemList() Copy JROOT/libraries/fof/view/raw.php:20213 FOFViewRaw->onDisplay() Copy JROOT/libraries/fof/view/raw.php:16712 FOFViewRaw->onBrowse() Copy JROOT/libraries/fof/view/form.php:4711 FOFViewForm->display() Copy JROOT/libraries/fof/controller/controller.php:112510 FOFController->display() Copy JROOT/libraries/fof/controller/controller.php:11659 FOFController->browse() Copy JROOT/libraries/fof/controller/controller.php:9678 FOFController->execute() Copy JROOT/libraries/fof/dispatcher/dispatcher.php:3327 FOFDispatcher->dispatch() Copy JROOT/components/com_splms/splms.php:356 require_once Copy JROOT/components/com_splms/splms.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2671 JApplicationCms->execute() Copy JROOT/index.php:78
Query Time: 1.34 ms After last query: 0.06 ms Query memory: 0.023 MB Memory before query: 22.324 MB Rows returned: 1
SELECT COUNT (* ) as total
FROM `joom_splms_courses `
WHERE `enabled`= 1 AND (brand_specific = 0 OR (brand_specific = 1 AND FIND_IN_SET (1,brands))) AND (course_visible_before_open = 1 OR course_open_date IS NULL OR course_open_date = '0000-00-00' OR (DATE (NOW ()) >= course_open_date)) AND (course_visible_after_close = 1 OR course_close_date IS NULL OR course_close_date = '0000-00-00' OR (DATE (NOW ()) <= course_close_date)) AND ( ( access_type = 'access' AND ( ( FIND_IN_SET ( 1, accesslevel ) > 0 ) OR ( FIND_IN_SET ( 1, accesslevel ) > 0 ) ) ) OR ( access_type = 'user' AND ( ( FIND_IN_SET ( 1, usergroup ) > 0 ) ) ) OR ( access_type = 'list' AND ( FIND_IN_SET ( 0, userlist ) > 0 ) ) OR ( access_type = 'none' OR access_type IS NULL ) ) AND ((FIND_IN_SET ('1', splms_coursescategory_id) > 0)OR (FIND_IN_SET ('6', splms_coursescategory_id) > 0)) AND ( ( brand_specific = 1 AND FIND_IN_SET ( 1, brands ) > 0 ) OR ( brand_specific = 0 ))EXPLAIN not possible on query: SELECT COUNT(*) as total
FROM `joom_splms_courses`
WHERE `enabled`=1 AND (brand_specific = 0 OR (brand_specific = 1 AND FIND_IN_SET(1,brands))) AND (course_visible_before_open = 1 OR course_open_date IS NULL OR course_open_date = '0000-00-00' OR (DATE(NOW()) >= course_open_date)) AND (course_visible_after_close = 1 OR course_close_date IS NULL OR course_close_date = '0000-00-00' OR (DATE(NOW()) <= course_close_date)) AND ( ( access_type = 'access' AND ( ( FIND_IN_SET( 1, accesslevel ) > 0 ) OR ( FIND_IN_SET( 1, accesslevel ) > 0 ) ) ) OR ( access_type = 'user' AND ( ( FIND_IN_SET( 1, usergroup ) > 0 ) ) ) OR ( access_type = 'list' AND ( FIND_IN_SET( 0, userlist ) > 0 ) ) OR ( access_type = 'none' OR access_type IS NULL ) ) AND ((FIND_IN_SET('1', splms_coursescategory_id) > 0)OR(FIND_IN_SET('6', splms_coursescategory_id) > 0)) AND ( ( brand_specific = 1 AND FIND_IN_SET( 1, brands ) > 0 ) OR ( brand_specific = 0 ))
Status Duration starting 0.12 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.07 ms init 0.01 ms System lock 0.01 ms optimizing 0.05 ms statistics 0.07 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.03 ms cleaning up 0.01 ms
# Caller File and line number 17 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:165416 JDatabaseDriver->loadObject() Copy JROOT/components/com_splms/models/courses.php:19115 SplmsModelCourses->getAllCourses() Copy JROOT/components/com_splms/models/courses.php:9014 SplmsModelCourses->getItemList() Copy JROOT/libraries/fof/view/raw.php:20213 FOFViewRaw->onDisplay() Copy JROOT/libraries/fof/view/raw.php:16712 FOFViewRaw->onBrowse() Copy JROOT/libraries/fof/view/form.php:4711 FOFViewForm->display() Copy JROOT/libraries/fof/controller/controller.php:112510 FOFController->display() Copy JROOT/libraries/fof/controller/controller.php:11659 FOFController->browse() Copy JROOT/libraries/fof/controller/controller.php:9678 FOFController->execute() Copy JROOT/libraries/fof/dispatcher/dispatcher.php:3327 FOFDispatcher->dispatch() Copy JROOT/components/com_splms/splms.php:356 require_once Copy JROOT/components/com_splms/splms.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2671 JApplicationCms->execute() Copy JROOT/index.php:78
Query Time: 1.20 ms After last query: 6.27 ms Query memory: 0.024 MB Memory before query: 22.824 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.06 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.04 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.10 ms preparing 0.02 ms executing 0.02 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms
# Caller File and line number 18 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:165417 JDatabaseDriver->loadObject() Copy JROOT/libraries/axslibs/topbar.php:8216 AxsTopBar::getStarredId() Copy JROOT/administrator/includes/toolbar.php:5215 JToolbarHelper::title() Copy JROOT/administrator/components/com_splms/toolbar.php:6014 SplmsToolbar->onCoursesBrowse() Copy JROOT/libraries/fof/toolbar/toolbar.php:30813 FOFToolbar->renderToolbar() Copy JROOT/libraries/fof/view/html.php:7312 FOFViewHtml->preRender() Copy JROOT/libraries/fof/view/form.php:6311 FOFViewForm->display() Copy JROOT/libraries/fof/controller/controller.php:112510 FOFController->display() Copy JROOT/libraries/fof/controller/controller.php:11659 FOFController->browse() Copy JROOT/libraries/fof/controller/controller.php:9678 FOFController->execute() Copy JROOT/libraries/fof/dispatcher/dispatcher.php:3327 FOFDispatcher->dispatch() Copy JROOT/components/com_splms/splms.php:356 require_once Copy JROOT/components/com_splms/splms.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2671 JApplicationCms->execute() Copy JROOT/index.php:78
Query Time: 1.38 ms After last query: 10.67 ms Query memory: 0.023 MB Memory before query: 23.777 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.10 ms init 0.01 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.03 ms preparing 0.04 ms executing 0.09 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.02 ms
# Caller File and line number 16 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:169315 JDatabaseDriver->loadObjectList() Copy JROOT/components/com_splms/models/courses.php:60714 SplmsModelCourses->getAllCategories() Copy JROOT/components/com_splms/views/courses/tmpl/default.php:36313 include Copy JROOT/components/com_splms/views/courses/tmpl/default.php Copy JROOT/libraries/fof/view/view.php:44212 FOFView->loadAnyTemplate() Copy JROOT/libraries/fof/view/form.php:7611 FOFViewForm->display() Copy JROOT/libraries/fof/controller/controller.php:112510 FOFController->display() Copy JROOT/libraries/fof/controller/controller.php:11659 FOFController->browse() Copy JROOT/libraries/fof/controller/controller.php:9678 FOFController->execute() Copy JROOT/libraries/fof/dispatcher/dispatcher.php:3327 FOFDispatcher->dispatch() Copy JROOT/components/com_splms/splms.php:356 require_once Copy JROOT/components/com_splms/splms.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2671 JApplicationCms->execute() Copy JROOT/index.php:78
Query Time: 1.06 ms After last query: 0.36 ms Query memory: 0.023 MB Memory before query: 23.800 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.05 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.02 ms executing 0.02 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms
# Caller File and line number 16 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:169315 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/axslibs/lms.php:389114 AxsLMS::getUserAllCourses() Copy JROOT/components/com_splms/views/courses/tmpl/default.php:45613 include Copy JROOT/components/com_splms/views/courses/tmpl/default.php Copy JROOT/libraries/fof/view/view.php:44212 FOFView->loadAnyTemplate() Copy JROOT/libraries/fof/view/form.php:7611 FOFViewForm->display() Copy JROOT/libraries/fof/controller/controller.php:112510 FOFController->display() Copy JROOT/libraries/fof/controller/controller.php:11659 FOFController->browse() Copy JROOT/libraries/fof/controller/controller.php:9678 FOFController->execute() Copy JROOT/libraries/fof/dispatcher/dispatcher.php:3327 FOFDispatcher->dispatch() Copy JROOT/components/com_splms/splms.php:356 require_once Copy JROOT/components/com_splms/splms.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2671 JApplicationCms->execute() Copy JROOT/index.php:78
Query Time: 1.09 ms After last query: 0.03 ms Query memory: 0.023 MB Memory before query: 23.807 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.01 ms statistics 0.06 ms preparing 0.02 ms executing 0.02 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms
# Caller File and line number 16 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:169315 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/axslibs/lms.php:403014 AxsLMS::getUserAllCourses() Copy JROOT/components/com_splms/views/courses/tmpl/default.php:45613 include Copy JROOT/components/com_splms/views/courses/tmpl/default.php Copy JROOT/libraries/fof/view/view.php:44212 FOFView->loadAnyTemplate() Copy JROOT/libraries/fof/view/form.php:7611 FOFViewForm->display() Copy JROOT/libraries/fof/controller/controller.php:112510 FOFController->display() Copy JROOT/libraries/fof/controller/controller.php:11659 FOFController->browse() Copy JROOT/libraries/fof/controller/controller.php:9678 FOFController->execute() Copy JROOT/libraries/fof/dispatcher/dispatcher.php:3327 FOFDispatcher->dispatch() Copy JROOT/components/com_splms/splms.php:356 require_once Copy JROOT/components/com_splms/splms.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2671 JApplicationCms->execute() Copy JROOT/index.php:78
Query Time: 1.17 ms After last query: 0.03 ms Query memory: 0.023 MB Memory before query: 23.814 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.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.06 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.06 ms preparing 0.02 ms Creating tmp table 0.04 ms executing 0.04 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.06 ms cleaning up 0.01 ms
# Caller File and line number 16 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:169315 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/axslibs/lms.php:406714 AxsLMS::getUserAllCourses() Copy JROOT/components/com_splms/views/courses/tmpl/default.php:45613 include Copy JROOT/components/com_splms/views/courses/tmpl/default.php Copy JROOT/libraries/fof/view/view.php:44212 FOFView->loadAnyTemplate() Copy JROOT/libraries/fof/view/form.php:7611 FOFViewForm->display() Copy JROOT/libraries/fof/controller/controller.php:112510 FOFController->display() Copy JROOT/libraries/fof/controller/controller.php:11659 FOFController->browse() Copy JROOT/libraries/fof/controller/controller.php:9678 FOFController->execute() Copy JROOT/libraries/fof/dispatcher/dispatcher.php:3327 FOFDispatcher->dispatch() Copy JROOT/components/com_splms/splms.php:356 require_once Copy JROOT/components/com_splms/splms.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2671 JApplicationCms->execute() Copy JROOT/index.php:78
Query Time: 1.12 ms After last query: 0.78 ms Query memory: 0.023 MB Memory before query: 23.844 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.01 ms Opening tables 0.04 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.07 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:165416 JDatabaseDriver->loadObject() Copy JROOT/libraries/axslibs/language.php:42715 AxsLanguage::getSefByLangCode() Copy JROOT/components/com_splms/models/courses.php:132614 SplmsModelCourses::setOverrides() Copy JROOT/components/com_splms/views/courses/tmpl/default.php:46313 include Copy JROOT/components/com_splms/views/courses/tmpl/default.php Copy JROOT/libraries/fof/view/view.php:44212 FOFView->loadAnyTemplate() Copy JROOT/libraries/fof/view/form.php:7611 FOFViewForm->display() Copy JROOT/libraries/fof/controller/controller.php:112510 FOFController->display() Copy JROOT/libraries/fof/controller/controller.php:11659 FOFController->browse() Copy JROOT/libraries/fof/controller/controller.php:9678 FOFController->execute() Copy JROOT/libraries/fof/dispatcher/dispatcher.php:3327 FOFDispatcher->dispatch() Copy JROOT/components/com_splms/splms.php:356 require_once Copy JROOT/components/com_splms/splms.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2671 JApplicationCms->execute() Copy JROOT/index.php:78
Query Time: 1.25 ms After last query: 0.91 ms Query memory: 0.025 MB Memory before query: 23.906 MB Rows returned: 1
SELECT COUNT (* )
FROM `joom_splms_lessons `
WHERE `enabled` = 1 AND `splms_course_id` = 1 AND `language` = 'en-GB 'EXPLAIN not possible on query: SELECT COUNT(*)
FROM `joom_splms_lessons`
WHERE `enabled` = 1 AND `splms_course_id` = 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.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.07 ms preparing 0.03 ms executing 0.15 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.02 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms
# Caller File and line number 22 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:173221 JDatabaseDriver->loadResult() Copy JROOT/libraries/tovuti/Helpers/LessonLanguageHelper.php:15620 Tovuti\Helpers\LessonLanguageHelper::Tovuti\Helpers\{closure}() Copy JROOT/libraries/tovuti/Traits/Memoization.php:2519 Tovuti\Helpers\LessonLanguageHelper::memoizeStatic() Copy JROOT/libraries/tovuti/Helpers/LessonLanguageHelper.php:14618 Tovuti\Helpers\LessonLanguageHelper::hasLessonsInLanguage() Copy JROOT/libraries/tovuti/Helpers/LessonLanguageHelper.php:7517 Tovuti\Helpers\LessonLanguageHelper::Tovuti\Helpers\{closure}() Copy JROOT/libraries/tovuti/Traits/Memoization.php:2516 Tovuti\Helpers\LessonLanguageHelper::memoizeStatic() Copy JROOT/libraries/tovuti/Helpers/LessonLanguageHelper.php:7215 Tovuti\Helpers\LessonLanguageHelper::resolveEffectiveLanguage() Copy JROOT/components/com_splms/models/lessons.php:23714 SplmsModelLessons::getLessons() Copy JROOT/components/com_splms/views/courses/tmpl/default.php:47513 include Copy JROOT/components/com_splms/views/courses/tmpl/default.php Copy JROOT/libraries/fof/view/view.php:44212 FOFView->loadAnyTemplate() Copy JROOT/libraries/fof/view/form.php:7611 FOFViewForm->display() Copy JROOT/libraries/fof/controller/controller.php:112510 FOFController->display() Copy JROOT/libraries/fof/controller/controller.php:11659 FOFController->browse() Copy JROOT/libraries/fof/controller/controller.php:9678 FOFController->execute() Copy JROOT/libraries/fof/dispatcher/dispatcher.php:3327 FOFDispatcher->dispatch() Copy JROOT/components/com_splms/splms.php:356 require_once Copy JROOT/components/com_splms/splms.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2671 JApplicationCms->execute() Copy JROOT/index.php:78
Query Time: 1.33 ms After last query: 0.06 ms Query memory: 0.023 MB Memory before query: 23.914 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.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.09 ms preparing 0.03 ms executing 0.13 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 16 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:169315 JDatabaseDriver->loadObjectList() Copy JROOT/components/com_splms/models/lessons.php:25614 SplmsModelLessons::getLessons() Copy JROOT/components/com_splms/views/courses/tmpl/default.php:47513 include Copy JROOT/components/com_splms/views/courses/tmpl/default.php Copy JROOT/libraries/fof/view/view.php:44212 FOFView->loadAnyTemplate() Copy JROOT/libraries/fof/view/form.php:7611 FOFViewForm->display() Copy JROOT/libraries/fof/controller/controller.php:112510 FOFController->display() Copy JROOT/libraries/fof/controller/controller.php:11659 FOFController->browse() Copy JROOT/libraries/fof/controller/controller.php:9678 FOFController->execute() Copy JROOT/libraries/fof/dispatcher/dispatcher.php:3327 FOFDispatcher->dispatch() Copy JROOT/components/com_splms/splms.php:356 require_once Copy JROOT/components/com_splms/splms.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2671 JApplicationCms->execute() Copy JROOT/index.php:78
Query Time: 1.22 ms After last query: 0.05 ms Query memory: 0.024 MB Memory before query: 23.926 MB Rows returned: 0
SELECT *
FROM `joom_splms_teachers `
WHERE `enabled`= '1' AND `splms_teacher_id`= ''
ORDER BY ordering DESC EXPLAIN not possible on query: SELECT *
FROM `joom_splms_teachers`
WHERE `enabled`='1' AND `splms_teacher_id`=''
ORDER BY ordering DESC
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.01 ms statistics 0.03 ms executing 0.02 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms
# Caller File and line number 17 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:165416 JDatabaseDriver->loadObject() Copy JROOT/components/com_splms/models/teachers.php:4215 SplmsModelTeachers::getTeacher() Copy JROOT/components/com_splms/models/lessons.php:25914 SplmsModelLessons::getLessons() Copy JROOT/components/com_splms/views/courses/tmpl/default.php:47513 include Copy JROOT/components/com_splms/views/courses/tmpl/default.php Copy JROOT/libraries/fof/view/view.php:44212 FOFView->loadAnyTemplate() Copy JROOT/libraries/fof/view/form.php:7611 FOFViewForm->display() Copy JROOT/libraries/fof/controller/controller.php:112510 FOFController->display() Copy JROOT/libraries/fof/controller/controller.php:11659 FOFController->browse() Copy JROOT/libraries/fof/controller/controller.php:9678 FOFController->execute() Copy JROOT/libraries/fof/dispatcher/dispatcher.php:3327 FOFDispatcher->dispatch() Copy JROOT/components/com_splms/splms.php:356 require_once Copy JROOT/components/com_splms/splms.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2671 JApplicationCms->execute() Copy JROOT/index.php:78
Query Time: 1.41 ms After last query: 0.12 ms Query memory: 0.023 MB Memory before query: 23.935 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.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.39 ms 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:173216 JDatabaseDriver->loadResult() Copy JROOT/components/com_splms/helpers/helper.php:2615 SplmsHelper::getItemid() Copy JROOT/components/com_splms/models/lessons.php:26114 SplmsModelLessons::getLessons() Copy JROOT/components/com_splms/views/courses/tmpl/default.php:47513 include Copy JROOT/components/com_splms/views/courses/tmpl/default.php Copy JROOT/libraries/fof/view/view.php:44212 FOFView->loadAnyTemplate() Copy JROOT/libraries/fof/view/form.php:7611 FOFViewForm->display() Copy JROOT/libraries/fof/controller/controller.php:112510 FOFController->display() Copy JROOT/libraries/fof/controller/controller.php:11659 FOFController->browse() Copy JROOT/libraries/fof/controller/controller.php:9678 FOFController->execute() Copy JROOT/libraries/fof/dispatcher/dispatcher.php:3327 FOFDispatcher->dispatch() Copy JROOT/components/com_splms/splms.php:356 require_once Copy JROOT/components/com_splms/splms.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2671 JApplicationCms->execute() Copy JROOT/index.php:78
Query Time: 1.19 ms After last query: 9.22 ms Query memory: 0.023 MB Memory before query: 25.114 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.06 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.05 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.09 ms preparing 0.03 ms executing 0.03 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms
# Caller File and line number 16 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:154215 JDatabaseDriver->loadColumn() Copy JROOT/libraries/axslibs/events.php:25314 AxsEvents::getCourseEvents() Copy JROOT/components/com_splms/views/courses/tmpl/default.php:47613 include Copy JROOT/components/com_splms/views/courses/tmpl/default.php Copy JROOT/libraries/fof/view/view.php:44212 FOFView->loadAnyTemplate() Copy JROOT/libraries/fof/view/form.php:7611 FOFViewForm->display() Copy JROOT/libraries/fof/controller/controller.php:112510 FOFController->display() Copy JROOT/libraries/fof/controller/controller.php:11659 FOFController->browse() Copy JROOT/libraries/fof/controller/controller.php:9678 FOFController->execute() Copy JROOT/libraries/fof/dispatcher/dispatcher.php:3327 FOFDispatcher->dispatch() Copy JROOT/components/com_splms/splms.php:356 require_once Copy JROOT/components/com_splms/splms.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2671 JApplicationCms->execute() Copy JROOT/index.php:78
Query Time: 1.26 ms After last query: 0.05 ms Query memory: 0.023 MB Memory before query: 25.121 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.01 ms Opening tables 0.04 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.10 ms preparing 0.02 ms executing 0.12 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 17 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:169316 JDatabaseDriver->loadObjectList() Copy JROOT/components/com_splms/models/courses.php:109315 SplmsModelCourses->getLessons() Copy JROOT/components/com_splms/models/courses.php:70714 SplmsModelCourses->getCourseTeachers() Copy JROOT/components/com_splms/views/courses/tmpl/default.php:48213 include Copy JROOT/components/com_splms/views/courses/tmpl/default.php Copy JROOT/libraries/fof/view/view.php:44212 FOFView->loadAnyTemplate() Copy JROOT/libraries/fof/view/form.php:7611 FOFViewForm->display() Copy JROOT/libraries/fof/controller/controller.php:112510 FOFController->display() Copy JROOT/libraries/fof/controller/controller.php:11659 FOFController->browse() Copy JROOT/libraries/fof/controller/controller.php:9678 FOFController->execute() Copy JROOT/libraries/fof/dispatcher/dispatcher.php:3327 FOFDispatcher->dispatch() Copy JROOT/components/com_splms/splms.php:356 require_once Copy JROOT/components/com_splms/splms.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2671 JApplicationCms->execute() Copy JROOT/index.php:78
Query Time: 1.23 ms After last query: 2.47 ms Query memory: 0.025 MB Memory before query: 25.350 MB Rows returned: 1
SELECT COUNT (* )
FROM `joom_splms_lessons `
WHERE `enabled` = 1 AND `splms_course_id` = 2 AND `language` = 'en-GB 'EXPLAIN not possible on query: SELECT COUNT(*)
FROM `joom_splms_lessons`
WHERE `enabled` = 1 AND `splms_course_id` = 2 AND `language` = 'en-GB'
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.10 ms preparing 0.03 ms executing 0.09 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.02 ms closing tables 0.01 ms freeing items 0.61 ms cleaning up 0.01 ms
# Caller File and line number 22 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:173221 JDatabaseDriver->loadResult() Copy JROOT/libraries/tovuti/Helpers/LessonLanguageHelper.php:15620 Tovuti\Helpers\LessonLanguageHelper::Tovuti\Helpers\{closure}() Copy JROOT/libraries/tovuti/Traits/Memoization.php:2519 Tovuti\Helpers\LessonLanguageHelper::memoizeStatic() Copy JROOT/libraries/tovuti/Helpers/LessonLanguageHelper.php:14618 Tovuti\Helpers\LessonLanguageHelper::hasLessonsInLanguage() Copy JROOT/libraries/tovuti/Helpers/LessonLanguageHelper.php:7517 Tovuti\Helpers\LessonLanguageHelper::Tovuti\Helpers\{closure}() Copy JROOT/libraries/tovuti/Traits/Memoization.php:2516 Tovuti\Helpers\LessonLanguageHelper::memoizeStatic() Copy JROOT/libraries/tovuti/Helpers/LessonLanguageHelper.php:7215 Tovuti\Helpers\LessonLanguageHelper::resolveEffectiveLanguage() Copy JROOT/components/com_splms/models/lessons.php:23714 SplmsModelLessons::getLessons() Copy JROOT/components/com_splms/views/courses/tmpl/default.php:47513 include Copy JROOT/components/com_splms/views/courses/tmpl/default.php Copy JROOT/libraries/fof/view/view.php:44212 FOFView->loadAnyTemplate() Copy JROOT/libraries/fof/view/form.php:7611 FOFViewForm->display() Copy JROOT/libraries/fof/controller/controller.php:112510 FOFController->display() Copy JROOT/libraries/fof/controller/controller.php:11659 FOFController->browse() Copy JROOT/libraries/fof/controller/controller.php:9678 FOFController->execute() Copy JROOT/libraries/fof/dispatcher/dispatcher.php:3327 FOFDispatcher->dispatch() Copy JROOT/components/com_splms/splms.php:356 require_once Copy JROOT/components/com_splms/splms.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2671 JApplicationCms->execute() Copy JROOT/index.php:78
Query Time: 1.27 ms After last query: 0.04 ms Query memory: 0.023 MB Memory before query: 25.357 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.09 ms preparing 0.03 ms executing 0.13 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 16 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:169315 JDatabaseDriver->loadObjectList() Copy JROOT/components/com_splms/models/lessons.php:25614 SplmsModelLessons::getLessons() Copy JROOT/components/com_splms/views/courses/tmpl/default.php:47513 include Copy JROOT/components/com_splms/views/courses/tmpl/default.php Copy JROOT/libraries/fof/view/view.php:44212 FOFView->loadAnyTemplate() Copy JROOT/libraries/fof/view/form.php:7611 FOFViewForm->display() Copy JROOT/libraries/fof/controller/controller.php:112510 FOFController->display() Copy JROOT/libraries/fof/controller/controller.php:11659 FOFController->browse() Copy JROOT/libraries/fof/controller/controller.php:9678 FOFController->execute() Copy JROOT/libraries/fof/dispatcher/dispatcher.php:3327 FOFDispatcher->dispatch() Copy JROOT/components/com_splms/splms.php:356 require_once Copy JROOT/components/com_splms/splms.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2671 JApplicationCms->execute() Copy JROOT/index.php:78
Query Time: 1.15 ms After last query: 0.15 ms Query memory: 0.023 MB Memory before query: 25.365 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.06 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.04 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.06 ms preparing 0.02 ms executing 0.02 ms end 0.01 ms query end 0.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 16 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:154215 JDatabaseDriver->loadColumn() Copy JROOT/libraries/axslibs/events.php:25314 AxsEvents::getCourseEvents() Copy JROOT/components/com_splms/views/courses/tmpl/default.php:47613 include Copy JROOT/components/com_splms/views/courses/tmpl/default.php Copy JROOT/libraries/fof/view/view.php:44212 FOFView->loadAnyTemplate() Copy JROOT/libraries/fof/view/form.php:7611 FOFViewForm->display() Copy JROOT/libraries/fof/controller/controller.php:112510 FOFController->display() Copy JROOT/libraries/fof/controller/controller.php:11659 FOFController->browse() Copy JROOT/libraries/fof/controller/controller.php:9678 FOFController->execute() Copy JROOT/libraries/fof/dispatcher/dispatcher.php:3327 FOFDispatcher->dispatch() Copy JROOT/components/com_splms/splms.php:356 require_once Copy JROOT/components/com_splms/splms.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2671 JApplicationCms->execute() Copy JROOT/index.php:78
Query Time: 1.33 ms After last query: 0.05 ms Query memory: 0.023 MB Memory before query: 25.371 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.04 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.04 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.06 ms preparing 0.02 ms executing 0.11 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 17 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:169316 JDatabaseDriver->loadObjectList() Copy JROOT/components/com_splms/models/courses.php:109315 SplmsModelCourses->getLessons() Copy JROOT/components/com_splms/models/courses.php:70714 SplmsModelCourses->getCourseTeachers() Copy JROOT/components/com_splms/views/courses/tmpl/default.php:48213 include Copy JROOT/components/com_splms/views/courses/tmpl/default.php Copy JROOT/libraries/fof/view/view.php:44212 FOFView->loadAnyTemplate() Copy JROOT/libraries/fof/view/form.php:7611 FOFViewForm->display() Copy JROOT/libraries/fof/controller/controller.php:112510 FOFController->display() Copy JROOT/libraries/fof/controller/controller.php:11659 FOFController->browse() Copy JROOT/libraries/fof/controller/controller.php:9678 FOFController->execute() Copy JROOT/libraries/fof/dispatcher/dispatcher.php:3327 FOFDispatcher->dispatch() Copy JROOT/components/com_splms/splms.php:356 require_once Copy JROOT/components/com_splms/splms.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2671 JApplicationCms->execute() Copy JROOT/index.php:78
Query Time: 1.30 ms After last query: 0.59 ms Query memory: 0.025 MB Memory before query: 25.390 MB Rows returned: 1
SELECT COUNT (* )
FROM `joom_splms_lessons `
WHERE `enabled` = 1 AND `splms_course_id` = 4 AND `language` = 'en-GB 'EXPLAIN not possible on query: SELECT COUNT(*)
FROM `joom_splms_lessons`
WHERE `enabled` = 1 AND `splms_course_id` = 4 AND `language` = 'en-GB'
Status Duration starting 0.07 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.06 ms preparing 0.02 ms executing 0.06 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.02 ms closing tables 0.01 ms freeing items 0.05 ms cleaning up 0.01 ms
# Caller File and line number 22 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:173221 JDatabaseDriver->loadResult() Copy JROOT/libraries/tovuti/Helpers/LessonLanguageHelper.php:15620 Tovuti\Helpers\LessonLanguageHelper::Tovuti\Helpers\{closure}() Copy JROOT/libraries/tovuti/Traits/Memoization.php:2519 Tovuti\Helpers\LessonLanguageHelper::memoizeStatic() Copy JROOT/libraries/tovuti/Helpers/LessonLanguageHelper.php:14618 Tovuti\Helpers\LessonLanguageHelper::hasLessonsInLanguage() Copy JROOT/libraries/tovuti/Helpers/LessonLanguageHelper.php:7517 Tovuti\Helpers\LessonLanguageHelper::Tovuti\Helpers\{closure}() Copy JROOT/libraries/tovuti/Traits/Memoization.php:2516 Tovuti\Helpers\LessonLanguageHelper::memoizeStatic() Copy JROOT/libraries/tovuti/Helpers/LessonLanguageHelper.php:7215 Tovuti\Helpers\LessonLanguageHelper::resolveEffectiveLanguage() Copy JROOT/components/com_splms/models/lessons.php:23714 SplmsModelLessons::getLessons() Copy JROOT/components/com_splms/views/courses/tmpl/default.php:47513 include Copy JROOT/components/com_splms/views/courses/tmpl/default.php Copy JROOT/libraries/fof/view/view.php:44212 FOFView->loadAnyTemplate() Copy JROOT/libraries/fof/view/form.php:7611 FOFViewForm->display() Copy JROOT/libraries/fof/controller/controller.php:112510 FOFController->display() Copy JROOT/libraries/fof/controller/controller.php:11659 FOFController->browse() Copy JROOT/libraries/fof/controller/controller.php:9678 FOFController->execute() Copy JROOT/libraries/fof/dispatcher/dispatcher.php:3327 FOFDispatcher->dispatch() Copy JROOT/components/com_splms/splms.php:356 require_once Copy JROOT/components/com_splms/splms.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2671 JApplicationCms->execute() Copy JROOT/index.php:78
Query Time: 1.20 ms After last query: 0.09 ms Query memory: 0.023 MB Memory before query: 25.398 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.01 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.07 ms preparing 0.03 ms executing 0.08 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.02 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms
# Caller File and line number 16 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:169315 JDatabaseDriver->loadObjectList() Copy JROOT/components/com_splms/models/lessons.php:25614 SplmsModelLessons::getLessons() Copy JROOT/components/com_splms/views/courses/tmpl/default.php:47513 include Copy JROOT/components/com_splms/views/courses/tmpl/default.php Copy JROOT/libraries/fof/view/view.php:44212 FOFView->loadAnyTemplate() Copy JROOT/libraries/fof/view/form.php:7611 FOFViewForm->display() Copy JROOT/libraries/fof/controller/controller.php:112510 FOFController->display() Copy JROOT/libraries/fof/controller/controller.php:11659 FOFController->browse() Copy JROOT/libraries/fof/controller/controller.php:9678 FOFController->execute() Copy JROOT/libraries/fof/dispatcher/dispatcher.php:3327 FOFDispatcher->dispatch() Copy JROOT/components/com_splms/splms.php:356 require_once Copy JROOT/components/com_splms/splms.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2671 JApplicationCms->execute() Copy JROOT/index.php:78
Query Time: 1.08 ms After last query: 0.08 ms Query memory: 0.023 MB Memory before query: 25.400 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.05 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.04 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.02 ms executing 0.02 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms
# Caller File and line number 16 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:154215 JDatabaseDriver->loadColumn() Copy JROOT/libraries/axslibs/events.php:25314 AxsEvents::getCourseEvents() Copy JROOT/components/com_splms/views/courses/tmpl/default.php:47613 include Copy JROOT/components/com_splms/views/courses/tmpl/default.php Copy JROOT/libraries/fof/view/view.php:44212 FOFView->loadAnyTemplate() Copy JROOT/libraries/fof/view/form.php:7611 FOFViewForm->display() Copy JROOT/libraries/fof/controller/controller.php:112510 FOFController->display() Copy JROOT/libraries/fof/controller/controller.php:11659 FOFController->browse() Copy JROOT/libraries/fof/controller/controller.php:9678 FOFController->execute() Copy JROOT/libraries/fof/dispatcher/dispatcher.php:3327 FOFDispatcher->dispatch() Copy JROOT/components/com_splms/splms.php:356 require_once Copy JROOT/components/com_splms/splms.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2671 JApplicationCms->execute() Copy JROOT/index.php:78
Query Time: 1.22 ms After last query: 0.09 ms Query memory: 0.023 MB Memory before query: 25.406 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.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.06 ms preparing 0.02 ms executing 0.07 ms end 0.01 ms query end 0.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:169316 JDatabaseDriver->loadObjectList() Copy JROOT/components/com_splms/models/courses.php:109315 SplmsModelCourses->getLessons() Copy JROOT/components/com_splms/models/courses.php:70714 SplmsModelCourses->getCourseTeachers() Copy JROOT/components/com_splms/views/courses/tmpl/default.php:48213 include Copy JROOT/components/com_splms/views/courses/tmpl/default.php Copy JROOT/libraries/fof/view/view.php:44212 FOFView->loadAnyTemplate() Copy JROOT/libraries/fof/view/form.php:7611 FOFViewForm->display() Copy JROOT/libraries/fof/controller/controller.php:112510 FOFController->display() Copy JROOT/libraries/fof/controller/controller.php:11659 FOFController->browse() Copy JROOT/libraries/fof/controller/controller.php:9678 FOFController->execute() Copy JROOT/libraries/fof/dispatcher/dispatcher.php:3327 FOFDispatcher->dispatch() Copy JROOT/components/com_splms/splms.php:356 require_once Copy JROOT/components/com_splms/splms.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2671 JApplicationCms->execute() Copy JROOT/index.php:78
Query Time: 1.20 ms After last query: 0.43 ms Query memory: 0.025 MB Memory before query: 25.425 MB Rows returned: 1
SELECT COUNT (* )
FROM `joom_splms_lessons `
WHERE `enabled` = 1 AND `splms_course_id` = 5 AND `language` = 'en-GB 'EXPLAIN not possible on query: SELECT COUNT(*)
FROM `joom_splms_lessons`
WHERE `enabled` = 1 AND `splms_course_id` = 5 AND `language` = 'en-GB'
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.04 ms statistics 0.06 ms preparing 0.03 ms executing 0.08 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms
# Caller File and line number 22 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:173221 JDatabaseDriver->loadResult() Copy JROOT/libraries/tovuti/Helpers/LessonLanguageHelper.php:15620 Tovuti\Helpers\LessonLanguageHelper::Tovuti\Helpers\{closure}() Copy JROOT/libraries/tovuti/Traits/Memoization.php:2519 Tovuti\Helpers\LessonLanguageHelper::memoizeStatic() Copy JROOT/libraries/tovuti/Helpers/LessonLanguageHelper.php:14618 Tovuti\Helpers\LessonLanguageHelper::hasLessonsInLanguage() Copy JROOT/libraries/tovuti/Helpers/LessonLanguageHelper.php:7517 Tovuti\Helpers\LessonLanguageHelper::Tovuti\Helpers\{closure}() Copy JROOT/libraries/tovuti/Traits/Memoization.php:2516 Tovuti\Helpers\LessonLanguageHelper::memoizeStatic() Copy JROOT/libraries/tovuti/Helpers/LessonLanguageHelper.php:7215 Tovuti\Helpers\LessonLanguageHelper::resolveEffectiveLanguage() Copy JROOT/components/com_splms/models/lessons.php:23714 SplmsModelLessons::getLessons() Copy JROOT/components/com_splms/views/courses/tmpl/default.php:47513 include Copy JROOT/components/com_splms/views/courses/tmpl/default.php Copy JROOT/libraries/fof/view/view.php:44212 FOFView->loadAnyTemplate() Copy JROOT/libraries/fof/view/form.php:7611 FOFViewForm->display() Copy JROOT/libraries/fof/controller/controller.php:112510 FOFController->display() Copy JROOT/libraries/fof/controller/controller.php:11659 FOFController->browse() Copy JROOT/libraries/fof/controller/controller.php:9678 FOFController->execute() Copy JROOT/libraries/fof/dispatcher/dispatcher.php:3327 FOFDispatcher->dispatch() Copy JROOT/components/com_splms/splms.php:356 require_once Copy JROOT/components/com_splms/splms.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2671 JApplicationCms->execute() Copy JROOT/index.php:78
Query Time: 1.28 ms After last query: 0.06 ms Query memory: 0.023 MB Memory before query: 25.433 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.01 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.01 ms System lock 0.03 ms optimizing 0.02 ms statistics 0.06 ms preparing 0.04 ms executing 0.08 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.02 ms closing tables 0.01 ms freeing items 0.05 ms cleaning up 0.01 ms
# Caller File and line number 16 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:169315 JDatabaseDriver->loadObjectList() Copy JROOT/components/com_splms/models/lessons.php:25614 SplmsModelLessons::getLessons() Copy JROOT/components/com_splms/views/courses/tmpl/default.php:47513 include Copy JROOT/components/com_splms/views/courses/tmpl/default.php Copy JROOT/libraries/fof/view/view.php:44212 FOFView->loadAnyTemplate() Copy JROOT/libraries/fof/view/form.php:7611 FOFViewForm->display() Copy JROOT/libraries/fof/controller/controller.php:112510 FOFController->display() Copy JROOT/libraries/fof/controller/controller.php:11659 FOFController->browse() Copy JROOT/libraries/fof/controller/controller.php:9678 FOFController->execute() Copy JROOT/libraries/fof/dispatcher/dispatcher.php:3327 FOFDispatcher->dispatch() Copy JROOT/components/com_splms/splms.php:356 require_once Copy JROOT/components/com_splms/splms.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2671 JApplicationCms->execute() Copy JROOT/index.php:78
Query Time: 2.61 ms After last query: 0.04 ms Query memory: 0.023 MB Memory before query: 25.438 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.05 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.08 ms preparing 0.02 ms executing 0.02 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms
# Caller File and line number 16 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:154215 JDatabaseDriver->loadColumn() Copy JROOT/libraries/axslibs/events.php:25314 AxsEvents::getCourseEvents() Copy JROOT/components/com_splms/views/courses/tmpl/default.php:47613 include Copy JROOT/components/com_splms/views/courses/tmpl/default.php Copy JROOT/libraries/fof/view/view.php:44212 FOFView->loadAnyTemplate() Copy JROOT/libraries/fof/view/form.php:7611 FOFViewForm->display() Copy JROOT/libraries/fof/controller/controller.php:112510 FOFController->display() Copy JROOT/libraries/fof/controller/controller.php:11659 FOFController->browse() Copy JROOT/libraries/fof/controller/controller.php:9678 FOFController->execute() Copy JROOT/libraries/fof/dispatcher/dispatcher.php:3327 FOFDispatcher->dispatch() Copy JROOT/components/com_splms/splms.php:356 require_once Copy JROOT/components/com_splms/splms.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2671 JApplicationCms->execute() Copy JROOT/index.php:78
Query Time: 1.14 ms After last query: 0.06 ms Query memory: 0.023 MB Memory before query: 25.445 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.01 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.06 ms preparing 0.02 ms executing 0.08 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.02 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms
# Caller File and line number 17 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:169316 JDatabaseDriver->loadObjectList() Copy JROOT/components/com_splms/models/courses.php:109315 SplmsModelCourses->getLessons() Copy JROOT/components/com_splms/models/courses.php:70714 SplmsModelCourses->getCourseTeachers() Copy JROOT/components/com_splms/views/courses/tmpl/default.php:48213 include Copy JROOT/components/com_splms/views/courses/tmpl/default.php Copy JROOT/libraries/fof/view/view.php:44212 FOFView->loadAnyTemplate() Copy JROOT/libraries/fof/view/form.php:7611 FOFViewForm->display() Copy JROOT/libraries/fof/controller/controller.php:112510 FOFController->display() Copy JROOT/libraries/fof/controller/controller.php:11659 FOFController->browse() Copy JROOT/libraries/fof/controller/controller.php:9678 FOFController->execute() Copy JROOT/libraries/fof/dispatcher/dispatcher.php:3327 FOFDispatcher->dispatch() Copy JROOT/components/com_splms/splms.php:356 require_once Copy JROOT/components/com_splms/splms.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2671 JApplicationCms->execute() Copy JROOT/index.php:78
Query Time: 1.43 ms After last query: 0.65 ms Query memory: 0.025 MB Memory before query: 25.464 MB Rows returned: 1
SELECT COUNT (* )
FROM `joom_splms_lessons `
WHERE `enabled` = 1 AND `splms_course_id` = 6 AND `language` = 'en-GB 'EXPLAIN not possible on query: SELECT COUNT(*)
FROM `joom_splms_lessons`
WHERE `enabled` = 1 AND `splms_course_id` = 6 AND `language` = 'en-GB'
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.03 ms executing 0.26 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.02 ms cleaning up 0.01 ms
# Caller File and line number 22 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:173221 JDatabaseDriver->loadResult() Copy JROOT/libraries/tovuti/Helpers/LessonLanguageHelper.php:15620 Tovuti\Helpers\LessonLanguageHelper::Tovuti\Helpers\{closure}() Copy JROOT/libraries/tovuti/Traits/Memoization.php:2519 Tovuti\Helpers\LessonLanguageHelper::memoizeStatic() Copy JROOT/libraries/tovuti/Helpers/LessonLanguageHelper.php:14618 Tovuti\Helpers\LessonLanguageHelper::hasLessonsInLanguage() Copy JROOT/libraries/tovuti/Helpers/LessonLanguageHelper.php:7517 Tovuti\Helpers\LessonLanguageHelper::Tovuti\Helpers\{closure}() Copy JROOT/libraries/tovuti/Traits/Memoization.php:2516 Tovuti\Helpers\LessonLanguageHelper::memoizeStatic() Copy JROOT/libraries/tovuti/Helpers/LessonLanguageHelper.php:7215 Tovuti\Helpers\LessonLanguageHelper::resolveEffectiveLanguage() Copy JROOT/components/com_splms/models/lessons.php:23714 SplmsModelLessons::getLessons() Copy JROOT/components/com_splms/views/courses/tmpl/default.php:47513 include Copy JROOT/components/com_splms/views/courses/tmpl/default.php Copy JROOT/libraries/fof/view/view.php:44212 FOFView->loadAnyTemplate() Copy JROOT/libraries/fof/view/form.php:7611 FOFViewForm->display() Copy JROOT/libraries/fof/controller/controller.php:112510 FOFController->display() Copy JROOT/libraries/fof/controller/controller.php:11659 FOFController->browse() Copy JROOT/libraries/fof/controller/controller.php:9678 FOFController->execute() Copy JROOT/libraries/fof/dispatcher/dispatcher.php:3327 FOFDispatcher->dispatch() Copy JROOT/components/com_splms/splms.php:356 require_once Copy JROOT/components/com_splms/splms.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2671 JApplicationCms->execute() Copy JROOT/index.php:78
Query Time: 1.31 ms After last query: 0.05 ms Query memory: 0.023 MB Memory before query: 25.472 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.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.03 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.02 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:169315 JDatabaseDriver->loadObjectList() Copy JROOT/components/com_splms/models/lessons.php:25614 SplmsModelLessons::getLessons() Copy JROOT/components/com_splms/views/courses/tmpl/default.php:47513 include Copy JROOT/components/com_splms/views/courses/tmpl/default.php Copy JROOT/libraries/fof/view/view.php:44212 FOFView->loadAnyTemplate() Copy JROOT/libraries/fof/view/form.php:7611 FOFViewForm->display() Copy JROOT/libraries/fof/controller/controller.php:112510 FOFController->display() Copy JROOT/libraries/fof/controller/controller.php:11659 FOFController->browse() Copy JROOT/libraries/fof/controller/controller.php:9678 FOFController->execute() Copy JROOT/libraries/fof/dispatcher/dispatcher.php:3327 FOFDispatcher->dispatch() Copy JROOT/components/com_splms/splms.php:356 require_once Copy JROOT/components/com_splms/splms.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2671 JApplicationCms->execute() Copy JROOT/index.php:78
Query Time: 1.15 ms After last query: 0.11 ms Query memory: 0.023 MB Memory before query: 25.477 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.05 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.06 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.02 ms executing 0.02 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms
# Caller File and line number 16 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:154215 JDatabaseDriver->loadColumn() Copy JROOT/libraries/axslibs/events.php:25314 AxsEvents::getCourseEvents() Copy JROOT/components/com_splms/views/courses/tmpl/default.php:47613 include Copy JROOT/components/com_splms/views/courses/tmpl/default.php Copy JROOT/libraries/fof/view/view.php:44212 FOFView->loadAnyTemplate() Copy JROOT/libraries/fof/view/form.php:7611 FOFViewForm->display() Copy JROOT/libraries/fof/controller/controller.php:112510 FOFController->display() Copy JROOT/libraries/fof/controller/controller.php:11659 FOFController->browse() Copy JROOT/libraries/fof/controller/controller.php:9678 FOFController->execute() Copy JROOT/libraries/fof/dispatcher/dispatcher.php:3327 FOFDispatcher->dispatch() Copy JROOT/components/com_splms/splms.php:356 require_once Copy JROOT/components/com_splms/splms.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2671 JApplicationCms->execute() Copy JROOT/index.php:78
Query Time: 1.18 ms After last query: 0.07 ms Query memory: 0.023 MB Memory before query: 25.484 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.03 ms statistics 0.06 ms preparing 0.02 ms executing 0.08 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.02 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms
# Caller File and line number 17 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:169316 JDatabaseDriver->loadObjectList() Copy JROOT/components/com_splms/models/courses.php:109315 SplmsModelCourses->getLessons() Copy JROOT/components/com_splms/models/courses.php:70714 SplmsModelCourses->getCourseTeachers() Copy JROOT/components/com_splms/views/courses/tmpl/default.php:48213 include Copy JROOT/components/com_splms/views/courses/tmpl/default.php Copy JROOT/libraries/fof/view/view.php:44212 FOFView->loadAnyTemplate() Copy JROOT/libraries/fof/view/form.php:7611 FOFViewForm->display() Copy JROOT/libraries/fof/controller/controller.php:112510 FOFController->display() Copy JROOT/libraries/fof/controller/controller.php:11659 FOFController->browse() Copy JROOT/libraries/fof/controller/controller.php:9678 FOFController->execute() Copy JROOT/libraries/fof/dispatcher/dispatcher.php:3327 FOFDispatcher->dispatch() Copy JROOT/components/com_splms/splms.php:356 require_once Copy JROOT/components/com_splms/splms.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2671 JApplicationCms->execute() Copy JROOT/index.php:78
Query Time: 1.37 ms After last query: 0.43 ms Query memory: 0.025 MB Memory before query: 25.503 MB Rows returned: 1
SELECT COUNT (* )
FROM `joom_splms_lessons `
WHERE `enabled` = 1 AND `splms_course_id` = 7 AND `language` = 'en-GB 'EXPLAIN not possible on query: SELECT COUNT(*)
FROM `joom_splms_lessons`
WHERE `enabled` = 1 AND `splms_course_id` = 7 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.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.08 ms preparing 0.02 ms executing 0.06 ms end 0.03 ms query end 0.00 ms waiting for handler commit 0.02 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms
# Caller File and line number 22 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:173221 JDatabaseDriver->loadResult() Copy JROOT/libraries/tovuti/Helpers/LessonLanguageHelper.php:15620 Tovuti\Helpers\LessonLanguageHelper::Tovuti\Helpers\{closure}() Copy JROOT/libraries/tovuti/Traits/Memoization.php:2519 Tovuti\Helpers\LessonLanguageHelper::memoizeStatic() Copy JROOT/libraries/tovuti/Helpers/LessonLanguageHelper.php:14618 Tovuti\Helpers\LessonLanguageHelper::hasLessonsInLanguage() Copy JROOT/libraries/tovuti/Helpers/LessonLanguageHelper.php:7517 Tovuti\Helpers\LessonLanguageHelper::Tovuti\Helpers\{closure}() Copy JROOT/libraries/tovuti/Traits/Memoization.php:2516 Tovuti\Helpers\LessonLanguageHelper::memoizeStatic() Copy JROOT/libraries/tovuti/Helpers/LessonLanguageHelper.php:7215 Tovuti\Helpers\LessonLanguageHelper::resolveEffectiveLanguage() Copy JROOT/components/com_splms/models/lessons.php:23714 SplmsModelLessons::getLessons() Copy JROOT/components/com_splms/views/courses/tmpl/default.php:47513 include Copy JROOT/components/com_splms/views/courses/tmpl/default.php Copy JROOT/libraries/fof/view/view.php:44212 FOFView->loadAnyTemplate() Copy JROOT/libraries/fof/view/form.php:7611 FOFViewForm->display() Copy JROOT/libraries/fof/controller/controller.php:112510 FOFController->display() Copy JROOT/libraries/fof/controller/controller.php:11659 FOFController->browse() Copy JROOT/libraries/fof/controller/controller.php:9678 FOFController->execute() Copy JROOT/libraries/fof/dispatcher/dispatcher.php:3327 FOFDispatcher->dispatch() Copy JROOT/components/com_splms/splms.php:356 require_once Copy JROOT/components/com_splms/splms.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2671 JApplicationCms->execute() Copy JROOT/index.php:78
Query Time: 1.16 ms After last query: 0.05 ms Query memory: 0.023 MB Memory before query: 25.511 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.05 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.06 ms preparing 0.03 ms executing 0.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:169315 JDatabaseDriver->loadObjectList() Copy JROOT/components/com_splms/models/lessons.php:25614 SplmsModelLessons::getLessons() Copy JROOT/components/com_splms/views/courses/tmpl/default.php:47513 include Copy JROOT/components/com_splms/views/courses/tmpl/default.php Copy JROOT/libraries/fof/view/view.php:44212 FOFView->loadAnyTemplate() Copy JROOT/libraries/fof/view/form.php:7611 FOFViewForm->display() Copy JROOT/libraries/fof/controller/controller.php:112510 FOFController->display() Copy JROOT/libraries/fof/controller/controller.php:11659 FOFController->browse() Copy JROOT/libraries/fof/controller/controller.php:9678 FOFController->execute() Copy JROOT/libraries/fof/dispatcher/dispatcher.php:3327 FOFDispatcher->dispatch() Copy JROOT/components/com_splms/splms.php:356 require_once Copy JROOT/components/com_splms/splms.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2671 JApplicationCms->execute() Copy JROOT/index.php:78
Query Time: 1.14 ms After last query: 0.06 ms Query memory: 0.023 MB Memory before query: 25.516 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.05 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.04 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.07 ms preparing 0.02 ms executing 0.02 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms
# Caller File and line number 16 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:154215 JDatabaseDriver->loadColumn() Copy JROOT/libraries/axslibs/events.php:25314 AxsEvents::getCourseEvents() Copy JROOT/components/com_splms/views/courses/tmpl/default.php:47613 include Copy JROOT/components/com_splms/views/courses/tmpl/default.php Copy JROOT/libraries/fof/view/view.php:44212 FOFView->loadAnyTemplate() Copy JROOT/libraries/fof/view/form.php:7611 FOFViewForm->display() Copy JROOT/libraries/fof/controller/controller.php:112510 FOFController->display() Copy JROOT/libraries/fof/controller/controller.php:11659 FOFController->browse() Copy JROOT/libraries/fof/controller/controller.php:9678 FOFController->execute() Copy JROOT/libraries/fof/dispatcher/dispatcher.php:3327 FOFDispatcher->dispatch() Copy JROOT/components/com_splms/splms.php:356 require_once Copy JROOT/components/com_splms/splms.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2671 JApplicationCms->execute() Copy JROOT/index.php:78
Query Time: 1.22 ms After last query: 0.05 ms Query memory: 0.023 MB Memory before query: 25.523 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.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.06 ms preparing 0.02 ms executing 0.07 ms end 0.01 ms query end 0.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:169316 JDatabaseDriver->loadObjectList() Copy JROOT/components/com_splms/models/courses.php:109315 SplmsModelCourses->getLessons() Copy JROOT/components/com_splms/models/courses.php:70714 SplmsModelCourses->getCourseTeachers() Copy JROOT/components/com_splms/views/courses/tmpl/default.php:48213 include Copy JROOT/components/com_splms/views/courses/tmpl/default.php Copy JROOT/libraries/fof/view/view.php:44212 FOFView->loadAnyTemplate() Copy JROOT/libraries/fof/view/form.php:7611 FOFViewForm->display() Copy JROOT/libraries/fof/controller/controller.php:112510 FOFController->display() Copy JROOT/libraries/fof/controller/controller.php:11659 FOFController->browse() Copy JROOT/libraries/fof/controller/controller.php:9678 FOFController->execute() Copy JROOT/libraries/fof/dispatcher/dispatcher.php:3327 FOFDispatcher->dispatch() Copy JROOT/components/com_splms/splms.php:356 require_once Copy JROOT/components/com_splms/splms.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2671 JApplicationCms->execute() Copy JROOT/index.php:78
Query Time: 1.25 ms After last query: 0.61 ms Query memory: 0.026 MB Memory before query: 25.548 MB Rows returned: 1
SELECT COUNT (* )
FROM `joom_splms_lessons `
WHERE `enabled` = 1 AND `splms_course_id` = 8 AND `language` = 'en-GB 'EXPLAIN not possible on query: SELECT COUNT(*)
FROM `joom_splms_lessons`
WHERE `enabled` = 1 AND `splms_course_id` = 8 AND `language` = 'en-GB'
Status Duration starting 0.04 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.06 ms preparing 0.02 ms executing 0.10 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms
# Caller File and line number 22 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:173221 JDatabaseDriver->loadResult() Copy JROOT/libraries/tovuti/Helpers/LessonLanguageHelper.php:15620 Tovuti\Helpers\LessonLanguageHelper::Tovuti\Helpers\{closure}() Copy JROOT/libraries/tovuti/Traits/Memoization.php:2519 Tovuti\Helpers\LessonLanguageHelper::memoizeStatic() Copy JROOT/libraries/tovuti/Helpers/LessonLanguageHelper.php:14618 Tovuti\Helpers\LessonLanguageHelper::hasLessonsInLanguage() Copy JROOT/libraries/tovuti/Helpers/LessonLanguageHelper.php:7517 Tovuti\Helpers\LessonLanguageHelper::Tovuti\Helpers\{closure}() Copy JROOT/libraries/tovuti/Traits/Memoization.php:2516 Tovuti\Helpers\LessonLanguageHelper::memoizeStatic() Copy JROOT/libraries/tovuti/Helpers/LessonLanguageHelper.php:7215 Tovuti\Helpers\LessonLanguageHelper::resolveEffectiveLanguage() Copy JROOT/components/com_splms/models/lessons.php:23714 SplmsModelLessons::getLessons() Copy JROOT/components/com_splms/views/courses/tmpl/default.php:47513 include Copy JROOT/components/com_splms/views/courses/tmpl/default.php Copy JROOT/libraries/fof/view/view.php:44212 FOFView->loadAnyTemplate() Copy JROOT/libraries/fof/view/form.php:7611 FOFViewForm->display() Copy JROOT/libraries/fof/controller/controller.php:112510 FOFController->display() Copy JROOT/libraries/fof/controller/controller.php:11659 FOFController->browse() Copy JROOT/libraries/fof/controller/controller.php:9678 FOFController->execute() Copy JROOT/libraries/fof/dispatcher/dispatcher.php:3327 FOFDispatcher->dispatch() Copy JROOT/components/com_splms/splms.php:356 require_once Copy JROOT/components/com_splms/splms.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2671 JApplicationCms->execute() Copy JROOT/index.php:78
Query Time: 1.26 ms After last query: 0.04 ms Query memory: 0.023 MB Memory before query: 25.557 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.03 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.05 ms preparing 0.03 ms executing 0.12 ms end 0.04 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 16 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:169315 JDatabaseDriver->loadObjectList() Copy JROOT/components/com_splms/models/lessons.php:25614 SplmsModelLessons::getLessons() Copy JROOT/components/com_splms/views/courses/tmpl/default.php:47513 include Copy JROOT/components/com_splms/views/courses/tmpl/default.php Copy JROOT/libraries/fof/view/view.php:44212 FOFView->loadAnyTemplate() Copy JROOT/libraries/fof/view/form.php:7611 FOFViewForm->display() Copy JROOT/libraries/fof/controller/controller.php:112510 FOFController->display() Copy JROOT/libraries/fof/controller/controller.php:11659 FOFController->browse() Copy JROOT/libraries/fof/controller/controller.php:9678 FOFController->execute() Copy JROOT/libraries/fof/dispatcher/dispatcher.php:3327 FOFDispatcher->dispatch() Copy JROOT/components/com_splms/splms.php:356 require_once Copy JROOT/components/com_splms/splms.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2671 JApplicationCms->execute() Copy JROOT/index.php:78
Query Time: 1.37 ms After last query: 0.14 ms Query memory: 0.023 MB Memory before query: 25.568 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.01 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.02 ms executing 0.02 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms
# Caller File and line number 16 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:154215 JDatabaseDriver->loadColumn() Copy JROOT/libraries/axslibs/events.php:25314 AxsEvents::getCourseEvents() Copy JROOT/components/com_splms/views/courses/tmpl/default.php:47613 include Copy JROOT/components/com_splms/views/courses/tmpl/default.php Copy JROOT/libraries/fof/view/view.php:44212 FOFView->loadAnyTemplate() Copy JROOT/libraries/fof/view/form.php:7611 FOFViewForm->display() Copy JROOT/libraries/fof/controller/controller.php:112510 FOFController->display() Copy JROOT/libraries/fof/controller/controller.php:11659 FOFController->browse() Copy JROOT/libraries/fof/controller/controller.php:9678 FOFController->execute() Copy JROOT/libraries/fof/dispatcher/dispatcher.php:3327 FOFDispatcher->dispatch() Copy JROOT/components/com_splms/splms.php:356 require_once Copy JROOT/components/com_splms/splms.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2671 JApplicationCms->execute() Copy JROOT/index.php:78
Query Time: 1.32 ms After last query: 0.04 ms Query memory: 0.023 MB Memory before query: 25.574 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.01 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.05 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.06 ms preparing 0.02 ms executing 0.11 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 17 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:169316 JDatabaseDriver->loadObjectList() Copy JROOT/components/com_splms/models/courses.php:109315 SplmsModelCourses->getLessons() Copy JROOT/components/com_splms/models/courses.php:70714 SplmsModelCourses->getCourseTeachers() Copy JROOT/components/com_splms/views/courses/tmpl/default.php:48213 include Copy JROOT/components/com_splms/views/courses/tmpl/default.php Copy JROOT/libraries/fof/view/view.php:44212 FOFView->loadAnyTemplate() Copy JROOT/libraries/fof/view/form.php:7611 FOFViewForm->display() Copy JROOT/libraries/fof/controller/controller.php:112510 FOFController->display() Copy JROOT/libraries/fof/controller/controller.php:11659 FOFController->browse() Copy JROOT/libraries/fof/controller/controller.php:9678 FOFController->execute() Copy JROOT/libraries/fof/dispatcher/dispatcher.php:3327 FOFDispatcher->dispatch() Copy JROOT/components/com_splms/splms.php:356 require_once Copy JROOT/components/com_splms/splms.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2671 JApplicationCms->execute() Copy JROOT/index.php:78
Query Time: 1.42 ms After last query: 2.80 ms Query memory: 0.021 MB Memory before query: 25.663 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.04 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.02 ms executing 0.32 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms
# Caller File and line number 12 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:169311 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/cms/language/multilang.php:10610 JLanguageMultilang::getSiteHomePages() Copy JROOT/plugins/system/languagefilter/languagefilter.php:7419 PlgSystemLanguageFilter->onAfterDispatch() Same as call in the line below. 8 ReflectionMethod->invokeArgs() Copy JROOT/libraries/tovuti/Helpers/MethodHelper.php:587 Tovuti\Helpers\MethodHelper::call() Copy JROOT/libraries/joomla/event/event.php:726 JEvent->update() Copy JROOT/libraries/joomla/event/dispatcher.php:1605 JEventDispatcher->trigger() Copy JROOT/libraries/joomla/application/base.php:1064 JApplicationBase->triggerEvent() Copy JROOT/libraries/cms/application/site.php:1963 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2671 JApplicationCms->execute() Copy JROOT/index.php:78
Query Time: 1.64 ms After last query: 0.65 ms Query memory: 0.021 MB Memory before query: 25.715 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.08 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 Opening tables 0.05 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.08 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 13 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:169312 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/cms/language/associations.php:10111 JLanguageAssociations::getAssociations() Copy JROOT/administrator/components/com_menus/helpers/menus.php:31310 MenusHelper::getAssociations() Copy JROOT/plugins/system/languagefilter/languagefilter.php:7589 PlgSystemLanguageFilter->onAfterDispatch() Same as call in the line below. 8 ReflectionMethod->invokeArgs() Copy JROOT/libraries/tovuti/Helpers/MethodHelper.php:587 Tovuti\Helpers\MethodHelper::call() Copy JROOT/libraries/joomla/event/event.php:726 JEvent->update() Copy JROOT/libraries/joomla/event/dispatcher.php:1605 JEventDispatcher->trigger() Copy JROOT/libraries/joomla/application/base.php:1064 JApplicationBase->triggerEvent() Copy JROOT/libraries/cms/application/site.php:1963 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2671 JApplicationCms->execute() Copy JROOT/index.php:78
Query Time: 1.09 ms After last query: 31.65 ms Query memory: 0.021 MB Memory before query: 26.011 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.01 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.02 ms executing 0.07 ms end 0.01 ms query end 0.01 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 11 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:169310 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/axslibs/fonts.php:349 AxsFonts::getFonts() Copy JROOT/templates/axs/home.php:1808 include Copy JROOT/templates/axs/home.php Copy JROOT/templates/axs/index.php:807 require Copy JROOT/templates/axs/index.php Copy JROOT/libraries/joomla/document/html.php:6536 JDocumentHtml->_loadTemplate() Copy JROOT/libraries/joomla/document/html.php:7155 JDocumentHtml->_fetchTemplate() Copy JROOT/libraries/joomla/document/html.php:5304 JDocumentHtml->parse() Copy JROOT/libraries/cms/application/cms.php:11323 JApplicationCms->render() Copy JROOT/libraries/cms/application/site.php:7822 JApplicationSite->render() Copy JROOT/libraries/cms/application/cms.php:2721 JApplicationCms->execute() Copy JROOT/index.php:78
Query Time: 1.55 ms After last query: 0.28 ms Query memory: 0.021 MB Memory before query: 26.046 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.00 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.02 ms executing 0.02 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.03 ms
# Caller File and line number 12 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:165411 JDatabaseDriver->loadObject() Copy JROOT/libraries/axslibs/accessibility.php:4210 AxsAccessibility::query() Copy JROOT/libraries/axslibs/accessibility.php:499 AxsAccessibility::image() Copy JROOT/templates/axs/home.php:8818 include Copy JROOT/templates/axs/home.php Copy JROOT/templates/axs/index.php:807 require Copy JROOT/templates/axs/index.php Copy JROOT/libraries/joomla/document/html.php:6536 JDocumentHtml->_loadTemplate() Copy JROOT/libraries/joomla/document/html.php:7155 JDocumentHtml->_fetchTemplate() Copy JROOT/libraries/joomla/document/html.php:5304 JDocumentHtml->parse() Copy JROOT/libraries/cms/application/cms.php:11323 JApplicationCms->render() Copy JROOT/libraries/cms/application/site.php:7822 JApplicationSite->render() Copy JROOT/libraries/cms/application/cms.php:2721 JApplicationCms->execute() Copy JROOT/index.php:78
Query Time: 2.50 ms After last query: 0.70 ms Query memory: 0.023 MB Memory before query: 26.128 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 <= '2026-10-17 02:13:54') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-10-17 02:13:54') 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 <= '2026-10-17 02:13:54') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-10-17 02:13:54') 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.10 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.07 ms init 0.01 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.11 ms preparing 0.04 ms executing 1.17 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.04 ms
# Caller File and line number 15 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:169314 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/joomla/cache/controller/callback.php:16913 JCacheControllerCallback->get() Copy JROOT/libraries/cms/module/helper.php:42412 JModuleHelper::getModuleList() Copy JROOT/libraries/cms/module/helper.php:36011 JModuleHelper::load() Copy JROOT/libraries/cms/module/helper.php:8410 JModuleHelper::getModules() Copy JROOT/libraries/joomla/document/html.php:5769 JDocumentHtml->countModules() Copy JROOT/templates/axs/home.php:9218 include Copy JROOT/templates/axs/home.php Copy JROOT/templates/axs/index.php:807 require Copy JROOT/templates/axs/index.php Copy JROOT/libraries/joomla/document/html.php:6536 JDocumentHtml->_loadTemplate() Copy JROOT/libraries/joomla/document/html.php:7155 JDocumentHtml->_fetchTemplate() Copy JROOT/libraries/joomla/document/html.php:5304 JDocumentHtml->parse() Copy JROOT/libraries/cms/application/cms.php:11323 JApplicationCms->render() Copy JROOT/libraries/cms/application/site.php:7822 JApplicationSite->render() Copy JROOT/libraries/cms/application/cms.php:2721 JApplicationCms->execute() Copy JROOT/index.php:78
Query Time: 1.16 ms After last query: 1.66 ms Query memory: 0.021 MB Memory before query: 26.189 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.01 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.02 ms
# Caller File and line number 11 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:169310 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/axslibs/notifications.php:199 AxsNotifications::loadNotifications() Copy JROOT/templates/axs/home.php:18708 include Copy JROOT/templates/axs/home.php Copy JROOT/templates/axs/index.php:807 require Copy JROOT/templates/axs/index.php Copy JROOT/libraries/joomla/document/html.php:6536 JDocumentHtml->_loadTemplate() Copy JROOT/libraries/joomla/document/html.php:7155 JDocumentHtml->_fetchTemplate() Copy JROOT/libraries/joomla/document/html.php:5304 JDocumentHtml->parse() Copy JROOT/libraries/cms/application/cms.php:11323 JApplicationCms->render() Copy JROOT/libraries/cms/application/site.php:7822 JApplicationSite->render() Copy JROOT/libraries/cms/application/cms.php:2721 JApplicationCms->execute() Copy JROOT/index.php:78
Query Time: 1.01 ms After last query: 5.14 ms Query memory: 0.025 MB Memory before query: 26.361 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.04 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.02 ms executing 0.02 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms
# Caller File and line number 22 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:145721 JDatabaseDriver->loadAssoc() Copy JROOT/libraries/joomla/table/table.php:72920 JTable->load() Copy JROOT/administrator/components/com_easyblog/includes/easyblog.php:41519 EB::config() Copy JROOT/components/com_easyblog/router.php:1918 EasyBlogBuildRoute() Copy JROOT/libraries/cms/component/router/legacy.php:6817 JComponentRouterLegacy->build() Copy JROOT/libraries/cms/router/site.php:51916 JRouterSite->buildSefRoute() Copy JROOT/libraries/cms/router/site.php:48915 JRouterSite->_buildSefRoute() Copy JROOT/libraries/cms/router/router.php:28214 JRouter->build() Copy JROOT/libraries/cms/router/site.php:14913 JRouterSite->build() Copy JROOT/libraries/joomla/application/route.php:6212 JRoute::_() Copy JROOT/modules/mod_defaultmenu/helper.php:13411 ModDefaultHelper::getList() Copy JROOT/modules/mod_defaultmenu/mod_defaultmenu.php:1510 include Copy JROOT/modules/mod_defaultmenu/mod_defaultmenu.php Copy JROOT/libraries/cms/module/helper.php:1989 JModuleHelper::renderModule() Copy JROOT/libraries/joomla/document/renderer/html/module.php:938 JDocumentRendererHtmlModule->render() Copy JROOT/libraries/joomla/document/renderer/html/modules.php:427 JDocumentRendererHtmlModules->render() Copy JROOT/libraries/joomla/document/html.php:4866 JDocumentHtml->getBuffer() Copy JROOT/libraries/joomla/document/html.php:7775 JDocumentHtml->_renderTemplate() Copy JROOT/libraries/joomla/document/html.php:5524 JDocumentHtml->render() Copy JROOT/libraries/cms/application/cms.php:11483 JApplicationCms->render() Copy JROOT/libraries/cms/application/site.php:7822 JApplicationSite->render() Copy JROOT/libraries/cms/application/cms.php:2721 JApplicationCms->execute() Copy JROOT/index.php:78
Query Time: 1.95 ms After last query: 0.22 ms Query memory: 0.025 MB Memory before query: 26.419 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.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.02 ms executing 0.93 ms 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:165422 JDatabaseDriver->loadObject() Copy JROOT/libraries/axslibs/images.php:6621 AxsImages::setSession() Copy JROOT/libraries/axslibs/images.php:1520 AxsImages::getImagesPath() Copy JROOT/administrator/components/com_easyblog/includes/easyblog.php:43019 EB::config() Copy JROOT/components/com_easyblog/router.php:1918 EasyBlogBuildRoute() Copy JROOT/libraries/cms/component/router/legacy.php:6817 JComponentRouterLegacy->build() Copy JROOT/libraries/cms/router/site.php:51916 JRouterSite->buildSefRoute() Copy JROOT/libraries/cms/router/site.php:48915 JRouterSite->_buildSefRoute() Copy JROOT/libraries/cms/router/router.php:28214 JRouter->build() Copy JROOT/libraries/cms/router/site.php:14913 JRouterSite->build() Copy JROOT/libraries/joomla/application/route.php:6212 JRoute::_() Copy JROOT/modules/mod_defaultmenu/helper.php:13411 ModDefaultHelper::getList() Copy JROOT/modules/mod_defaultmenu/mod_defaultmenu.php:1510 include Copy JROOT/modules/mod_defaultmenu/mod_defaultmenu.php Copy JROOT/libraries/cms/module/helper.php:1989 JModuleHelper::renderModule() Copy JROOT/libraries/joomla/document/renderer/html/module.php:938 JDocumentRendererHtmlModule->render() Copy JROOT/libraries/joomla/document/renderer/html/modules.php:427 JDocumentRendererHtmlModules->render() Copy JROOT/libraries/joomla/document/html.php:4866 JDocumentHtml->getBuffer() Copy JROOT/libraries/joomla/document/html.php:7775 JDocumentHtml->_renderTemplate() Copy JROOT/libraries/joomla/document/html.php:5524 JDocumentHtml->render() Copy JROOT/libraries/cms/application/cms.php:11483 JApplicationCms->render() Copy JROOT/libraries/cms/application/site.php:7822 JApplicationSite->render() Copy JROOT/libraries/cms/application/cms.php:2721 JApplicationCms->execute() Copy JROOT/index.php:78
Query Time: 1.07 ms After last query: 1.95 ms Query memory: 0.027 MB Memory before query: 26.724 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.00 ms Opening tables 0.02 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.01 ms executing 0.01 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.01 ms
# Caller File and line number 27 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:145726 JDatabaseDriver->loadAssoc() Copy JROOT/libraries/kunena/config.php:130625 KunenaConfig->load() Copy JROOT/libraries/kunena/config.php:123924 KunenaConfig::getInstance() Copy JROOT/libraries/kunena/factory.php:2823 KunenaFactory::getConfig() Copy JROOT/libraries/kunena/route/route.php:48022 KunenaRoute::initialize() Copy JROOT/libraries/kunena/route/route.php:1721 include Copy JROOT/libraries/kunena/route/route.php Copy JROOT/libraries/loader.php:71620 JLoader::_load() Copy JROOT/libraries/loader.php:67119 JLoader::_autoload() Copy JROOT/components/com_kunena/router.php:3818 KunenaBuildRoute() Copy JROOT/libraries/cms/component/router/legacy.php:6817 JComponentRouterLegacy->build() Copy JROOT/libraries/cms/router/site.php:51916 JRouterSite->buildSefRoute() Copy JROOT/libraries/cms/router/site.php:48915 JRouterSite->_buildSefRoute() Copy JROOT/libraries/cms/router/router.php:28214 JRouter->build() Copy JROOT/libraries/cms/router/site.php:14913 JRouterSite->build() Copy JROOT/libraries/joomla/application/route.php:6212 JRoute::_() Copy JROOT/modules/mod_defaultmenu/helper.php:13411 ModDefaultHelper::getList() Copy JROOT/modules/mod_defaultmenu/mod_defaultmenu.php:1510 include Copy JROOT/modules/mod_defaultmenu/mod_defaultmenu.php Copy JROOT/libraries/cms/module/helper.php:1989 JModuleHelper::renderModule() Copy JROOT/libraries/joomla/document/renderer/html/module.php:938 JDocumentRendererHtmlModule->render() Copy JROOT/libraries/joomla/document/renderer/html/modules.php:427 JDocumentRendererHtmlModules->render() Copy JROOT/libraries/joomla/document/html.php:4866 JDocumentHtml->getBuffer() Copy JROOT/libraries/joomla/document/html.php:7775 JDocumentHtml->_renderTemplate() Copy JROOT/libraries/joomla/document/html.php:5524 JDocumentHtml->render() Copy JROOT/libraries/cms/application/cms.php:11483 JApplicationCms->render() Copy JROOT/libraries/cms/application/site.php:7822 JApplicationSite->render() Copy JROOT/libraries/cms/application/cms.php:2721 JApplicationCms->execute() Copy JROOT/index.php:78
Query Time: 1.01 ms After last query: 3.22 ms Query memory: 0.023 MB Memory before query: 26.937 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.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.02 ms cleaning up 0.01 ms
# Caller File and line number 16 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:165415 JDatabaseDriver->loadObject() Copy JROOT/libraries/axslibs/language.php:45014 AxsLanguage::getSpecialCharacters() Copy JROOT/libraries/axslibs/language.php:2713 AxsLanguage::translate() Copy JROOT/modules/mod_defaultmenu/tmpl/default_component.php:3312 require Copy JROOT/modules/mod_defaultmenu/tmpl/default_component.php Copy JROOT/modules/mod_defaultmenu/tmpl/default.php:7211 require Copy JROOT/modules/mod_defaultmenu/tmpl/default.php Copy JROOT/modules/mod_defaultmenu/mod_defaultmenu.php:2510 include Copy JROOT/modules/mod_defaultmenu/mod_defaultmenu.php Copy JROOT/libraries/cms/module/helper.php:1989 JModuleHelper::renderModule() Copy JROOT/libraries/joomla/document/renderer/html/module.php:938 JDocumentRendererHtmlModule->render() Copy JROOT/libraries/joomla/document/renderer/html/modules.php:427 JDocumentRendererHtmlModules->render() Copy JROOT/libraries/joomla/document/html.php:4866 JDocumentHtml->getBuffer() Copy JROOT/libraries/joomla/document/html.php:7775 JDocumentHtml->_renderTemplate() Copy JROOT/libraries/joomla/document/html.php:5524 JDocumentHtml->render() Copy JROOT/libraries/cms/application/cms.php:11483 JApplicationCms->render() Copy JROOT/libraries/cms/application/site.php:7822 JApplicationSite->render() Copy JROOT/libraries/cms/application/cms.php:2721 JApplicationCms->execute() Copy JROOT/index.php:78
14 × SELECT * FROM `joom_splms_lessons ` 7 × SELECT COUNT (* ) 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 * FROM joom_languages 2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `joom_extensions ` 2 × SELECT * FROM `joom_splms_coursescategories ` 1 × SELECT * FROM `axs_brands` 1 × SELECT * FROM axs_domains 1 × SELECT language, published FROM axs_brands 1 × SELECT * FROM `axs_homepage_templates` 1 × SELECT * FROM `axs_dashboard_templates` 1 × SELECT * FROM axs_email_settings 1 × SELECT b.id FROM joom_usergroups AS a LEFT JOIN joom_usergroups AS b ON b.lft <= a.lft AND b.rgt >= a.rgt 1 × SELECT * FROM axs_payment_gateways 1 × SELECT * FROM axs_integrations 1 × SELECT id, rules FROM `joom_viewlevels 1 × SELECT `folder` AS `type`,`element` AS `name`,`params` FROM joom_extensions 1 × SELECT `element`,`name`,`client_id`,`extension_id` FROM `joom_extensions ` 1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component FROM joom_menu AS m LEFT JOIN joom_extensions AS e ON m.component_id = e.extension_id 1 × SELECT 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 `id`,`name`,`rules`,`parent_id` FROM `joom_assets ` 1 × SELECT params FROM axs_lms_settings 1 × SELECT 1 FROM axs_learning_paths 1 × SELECT * FROM `joom_splms_courses ` 1 × SELECT COUNT (* ) as total FROM `joom_splms_courses ` 1 × SELECT id FROM axs_starred 1 × SELECT * FROM `joom_splms_course_wishlist ` 1 × SELECT * FROM `axs_course_purchases` 1 × SELECT * FROM `joom_splms_course_progress ` 1 × SELECT sef FROM joom_languages 1 × SELECT * FROM `joom_splms_teachers ` 1 × SELECT `id` FROM `joom_menu ` 1 × SELECT language,id FROM `joom_menu ` 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 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 special_characters FROM joom_languages