Kyselyaika: 1.23 ms Kyselymuisti: 0.020 MB Muisti ennen kyselyä: 4.118 MB Palautetut rivit: 0
SELECT `session_id`
FROM `joom_session `
WHERE `session_id` = '02kudtqj5liijd040id3k6gcft' LIMIT 1EXPLAIN ei ole mahdollista kyselyssä: SELECT `session_id`
FROM `joom_session`
WHERE `session_id` = '02kudtqj5liijd040id3k6gcft' LIMIT 1
Status Duration starting 0.08 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.04 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.06 ms executing 0.01 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms
# Soittaja Tiedoston ja rivin numero 8 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:17607 JDatabaseDriver->loadResult() Copy JROOT/libraries/cms/application/cms.php:1766 JApplicationCms->checkSession() Copy JROOT/libraries/cms/application/cms.php:8885 JApplicationCms->loadSession() Copy JROOT/libraries/cms/application/cms.php:1314 JApplicationCms->__construct() Copy JROOT/libraries/cms/application/site.php:633 JApplicationSite->__construct() Copy JROOT/libraries/cms/application/cms.php:4692 JApplicationCms::getInstance() Copy JROOT/libraries/joomla/factory.php:1251 JFactory::getApplication() Copy JROOT/index.php:50
Kyselyaika: 2.85 ms Viimeisen kyselyn jälkeen: 0.04 ms Kyselymuisti: 0.003 MB Muisti ennen kyselyä: 4.185 MB
INSERT INTO `joom_session `
(`session_id`,`guest`,`time`,`userid`,`username`) VALUES
('02kudtqj5liijd040id3k6gcft', 1, '1728138427', 0, '')EXPLAIN ei ole mahdollista kyselyssä: INSERT INTO `joom_session`
(`session_id`,`guest`,`time`,`userid`,`username`) VALUES
('02kudtqj5liijd040id3k6gcft', 1, '1728138427', 0, '')
Status Duration starting 0.06 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms update 0.10 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.02 ms closing tables 0.01 ms freeing items 0.01 ms async commit 1.65 ms cleaning up 0.01 ms
# Soittaja Tiedoston ja rivin numero 7 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/cms/application/cms.php:2166 JApplicationCms->checkSession() Copy JROOT/libraries/cms/application/cms.php:8885 JApplicationCms->loadSession() Copy JROOT/libraries/cms/application/cms.php:1314 JApplicationCms->__construct() Copy JROOT/libraries/cms/application/site.php:633 JApplicationSite->__construct() Copy JROOT/libraries/cms/application/cms.php:4692 JApplicationCms::getInstance() Copy JROOT/libraries/joomla/factory.php:1251 JFactory::getApplication() Copy JROOT/index.php:50
Kyselyaika: 1.57 ms Viimeisen kyselyn jälkeen: 1.18 ms Kyselymuisti: 0.045 MB Muisti ennen kyselyä: 4.356 MB Palautetut rivit: 80
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `joom_extensions `
WHERE `type` = 'component'EXPLAIN ei ole mahdollista kyselyssä: SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `joom_extensions`
WHERE `type` = 'component'
Status Duration starting 0.06 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.04 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.07 ms preparing 0.02 ms executing 0.31 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms
# Soittaja Tiedoston ja rivin numero 10 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:17219 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/cms/component/helper.php:4478 JComponentHelper::{closure}() Copy JROOT/libraries/joomla/cache/controller/callback.php:1697 JCacheControllerCallback->get() Copy JROOT/libraries/cms/component/helper.php:4556 JComponentHelper::load() Copy JROOT/libraries/cms/component/helper.php:435 JComponentHelper::getComponent() Copy JROOT/libraries/cms/component/helper.php:1114 JComponentHelper::getParams() Copy JROOT/libraries/cms/application/site.php:5983 JApplicationSite->initialiseApp() Copy JROOT/libraries/cms/application/site.php:2092 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
Kyselyaika: 1.16 ms Viimeisen kyselyn jälkeen: 1.20 ms Kyselymuisti: 0.021 MB Muisti ennen kyselyä: 4.567 MB Palautetut rivit: 7
SELECT id, rules
FROM `joom_viewlevels `EXPLAIN ei ole mahdollista kyselyssä: SELECT id, rules
FROM `joom_viewlevels`
Status Duration starting 0.05 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.00 ms statistics 0.02 ms preparing 0.02 ms executing 0.05 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms
# Soittaja Tiedoston ja rivin numero 10 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:15269 JDatabaseDriver->loadAssocList() Copy JROOT/libraries/joomla/access/access.php:10628 JAccess::getAuthorisedViewLevels() Copy JROOT/libraries/joomla/user/user.php:4537 JUser->getAuthorisedViewLevels() Copy JROOT/libraries/cms/plugin/helper.php:2936 JPluginHelper::load() Copy JROOT/libraries/cms/plugin/helper.php:865 JPluginHelper::getPlugin() Copy JROOT/libraries/cms/plugin/helper.php:1284 JPluginHelper::isEnabled() Copy JROOT/libraries/cms/application/site.php:6083 JApplicationSite->initialiseApp() Copy JROOT/libraries/cms/application/site.php:2092 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
Kyselyaika: 1.19 ms Viimeisen kyselyn jälkeen: 0.04 ms Kyselymuisti: 0.021 MB Muisti ennen kyselyä: 4.579 MB Palautetut rivit: 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 ei ole mahdollista kyselyssä: 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.06 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.07 ms preparing 0.03 ms executing 0.02 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms
# Soittaja Tiedoston ja rivin numero 11 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:157010 JDatabaseDriver->loadColumn() Copy JROOT/libraries/joomla/access/access.php:9799 JAccess::getGroupsByUser() Copy JROOT/libraries/joomla/access/access.php:10948 JAccess::getAuthorisedViewLevels() Copy JROOT/libraries/joomla/user/user.php:4537 JUser->getAuthorisedViewLevels() Copy JROOT/libraries/cms/plugin/helper.php:2936 JPluginHelper::load() Copy JROOT/libraries/cms/plugin/helper.php:865 JPluginHelper::getPlugin() Copy JROOT/libraries/cms/plugin/helper.php:1284 JPluginHelper::isEnabled() Copy JROOT/libraries/cms/application/site.php:6083 JApplicationSite->initialiseApp() Copy JROOT/libraries/cms/application/site.php:2092 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
Kyselyaika: 2.41 ms Viimeisen kyselyn jälkeen: 0.36 ms Kyselymuisti: 0.046 MB Muisti ennen kyselyä: 4.641 MB Palautetut rivit: 143
SELECT `folder` AS `type`,`element` AS `name`,`params`
FROM joom_extensions
WHERE enabled = 1 AND type = 'plugin' AND state IN (0,1) AND access IN (1,1)
ORDER BY orderingEXPLAIN ei ole mahdollista kyselyssä: SELECT `folder` AS `type`,`element` AS `name`,`params`
FROM joom_extensions
WHERE enabled = 1 AND type = 'plugin' AND state IN (0,1) AND access IN (1,1)
ORDER BY ordering
Status Duration starting 0.07 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.04 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.06 ms preparing 0.03 ms executing 1.15 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms
# Soittaja Tiedoston ja rivin numero 10 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:17219 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/cms/plugin/helper.php:3118 JPluginHelper::{closure}() Copy JROOT/libraries/joomla/cache/controller/callback.php:1697 JCacheControllerCallback->get() Copy JROOT/libraries/cms/plugin/helper.php:3166 JPluginHelper::load() Copy JROOT/libraries/cms/plugin/helper.php:865 JPluginHelper::getPlugin() Copy JROOT/libraries/cms/plugin/helper.php:1284 JPluginHelper::isEnabled() Copy JROOT/libraries/cms/application/site.php:6083 JApplicationSite->initialiseApp() Copy JROOT/libraries/cms/application/site.php:2092 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
Kyselyaika: 1.40 ms Viimeisen kyselyn jälkeen: 16.78 ms Kyselymuisti: 0.024 MB Muisti ennen kyselyä: 7.102 MB Palautetut rivit: 1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `joom_extensions `
WHERE `type` = 'library' AND `element` = 'joomla'EXPLAIN ei ole mahdollista kyselyssä: SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `joom_extensions`
WHERE `type` = 'library' AND `element` = 'joomla'
Status Duration starting 0.08 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.04 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.10 ms preparing 0.02 ms executing 0.05 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.00 ms
# Soittaja Tiedoston ja rivin numero 17 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:168216 JDatabaseDriver->loadObject() Copy JROOT/libraries/cms/library/helper.php:16615 JLibraryHelper::{closure}() Copy JROOT/libraries/joomla/cache/controller/callback.php:16914 JCacheControllerCallback->get() Copy JROOT/libraries/cms/library/helper.php:17413 JLibraryHelper::loadLibrary() Copy JROOT/libraries/cms/library/helper.php:4212 JLibraryHelper::getLibrary() Copy JROOT/libraries/cms/library/helper.php:8911 JLibraryHelper::getParams() Copy JROOT/libraries/cms/version/version.php:27010 JVersion->getMediaVersion() Copy JROOT/libraries/joomla/factory.php:7779 JFactory::createDocument() Copy JROOT/libraries/joomla/factory.php:2168 JFactory::getDocument() Copy JROOT/plugins/system/mootable/mootable.php:1007 PlgSystemMootable->__construct() Copy JROOT/libraries/cms/plugin/helper.php:2556 JPluginHelper::import() Copy JROOT/libraries/cms/plugin/helper.php:1705 JPluginHelper::importPlugin() Copy JROOT/libraries/cms/application/cms.php:7394 JApplicationCms->initialiseApp() Copy JROOT/libraries/cms/application/site.php:6903 JApplicationSite->initialiseApp() Copy JROOT/libraries/cms/application/site.php:2092 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
Kyselyaika: 7.59 ms Viimeisen kyselyn jälkeen: 0.07 ms Kyselymuisti: 0.006 MB Muisti ennen kyselyä: 7.094 MB
UPDATE `joom_extensions `
SET `params` = '{\"mediaversion\":\"0fa52fd1442b0b0394371ae00184f190\"}'
WHERE `type` = 'library' AND `element` = 'joomla'EXPLAIN ei ole mahdollista kyselyssä: UPDATE `joom_extensions`
SET `params` = '{\"mediaversion\":\"0fa52fd1442b0b0394371ae00184f190\"}'
WHERE `type` = 'library' AND `element` = 'joomla'
Status Duration starting 0.06 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.04 ms init 0.01 ms System lock 0.09 ms updating 0.09 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.05 ms closing tables 0.01 ms freeing items 0.01 ms async commit 6.21 ms cleaning up 0.02 ms
# Soittaja Tiedoston ja rivin numero 13 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/cms/library/helper.php:11612 JLibraryHelper::saveParams() Copy JROOT/libraries/cms/version/version.php:32111 JVersion->setMediaVersion() Copy JROOT/libraries/cms/version/version.php:28010 JVersion->getMediaVersion() Copy JROOT/libraries/joomla/factory.php:7779 JFactory::createDocument() Copy JROOT/libraries/joomla/factory.php:2168 JFactory::getDocument() Copy JROOT/plugins/system/mootable/mootable.php:1007 PlgSystemMootable->__construct() Copy JROOT/libraries/cms/plugin/helper.php:2556 JPluginHelper::import() Copy JROOT/libraries/cms/plugin/helper.php:1705 JPluginHelper::importPlugin() Copy JROOT/libraries/cms/application/cms.php:7394 JApplicationCms->initialiseApp() Copy JROOT/libraries/cms/application/site.php:6903 JApplicationSite->initialiseApp() Copy JROOT/libraries/cms/application/site.php:2092 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
Kyselyaika: 1.43 ms Viimeisen kyselyn jälkeen: 4.42 ms Kyselymuisti: 0.029 MB Muisti ennen kyselyä: 8.035 MB Palautetut rivit: 19
SELECT *
FROM joom_languages
WHERE published= 1
ORDER BY ordering ASC EXPLAIN ei ole mahdollista kyselyssä: SELECT *
FROM joom_languages
WHERE published=1
ORDER BY ordering ASC
Status Duration starting 0.07 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.05 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.03 ms executing 0.15 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
# Soittaja Tiedoston ja rivin numero 10 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:17219 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/joomla/language/helper.php:1488 JLanguageHelper::getLanguages() Copy JROOT/plugins/system/languagefilter/languagefilter.php:997 PlgSystemLanguageFilter->__construct() Copy JROOT/libraries/cms/plugin/helper.php:2556 JPluginHelper::import() Copy JROOT/libraries/cms/plugin/helper.php:1705 JPluginHelper::importPlugin() Copy JROOT/libraries/cms/application/cms.php:7394 JApplicationCms->initialiseApp() Copy JROOT/libraries/cms/application/site.php:6903 JApplicationSite->initialiseApp() Copy JROOT/libraries/cms/application/site.php:2092 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
Kyselyaika: 1.21 ms Viimeisen kyselyn jälkeen: 0.52 ms Kyselymuisti: 0.021 MB Muisti ennen kyselyä: 8.106 MB Palautetut rivit: 1
SELECT * FROM axs_domains WHERE domain = 'k8s.intg.tovuti.io'EXPLAIN ei ole mahdollista kyselyssä: SELECT * FROM axs_domains WHERE domain = 'k8s.intg.tovuti.io'
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.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
# Soittaja Tiedoston ja rivin numero 10 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:16829 JDatabaseDriver->loadObject() Copy JROOT/libraries/axslibs/language.php:1838 AxsLanguage::getSubdomainDefault() Copy JROOT/plugins/system/languagefilter/languagefilter.php:1037 PlgSystemLanguageFilter->__construct() Copy JROOT/libraries/cms/plugin/helper.php:2556 JPluginHelper::import() Copy JROOT/libraries/cms/plugin/helper.php:1705 JPluginHelper::importPlugin() Copy JROOT/libraries/cms/application/cms.php:7394 JApplicationCms->initialiseApp() Copy JROOT/libraries/cms/application/site.php:6903 JApplicationSite->initialiseApp() Copy JROOT/libraries/cms/application/site.php:2092 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
Kyselyaika: 1.56 ms Viimeisen kyselyn jälkeen: 0.10 ms Kyselymuisti: 0.030 MB Muisti ennen kyselyä: 8.114 MB Palautetut rivit: 94
SELECT `element`,`name`,`client_id`,`extension_id`
FROM `joom_extensions `
WHERE `type` = 'language' AND `state` = 0 AND `enabled` = 1EXPLAIN ei ole mahdollista kyselyssä: SELECT `element`,`name`,`client_id`,`extension_id`
FROM `joom_extensions`
WHERE `type` = 'language' AND `state` = 0 AND `enabled` = 1
Status Duration starting 0.06 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.07 ms preparing 0.02 ms executing 0.34 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms
# Soittaja Tiedoston ja rivin numero 10 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:17219 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/joomla/language/helper.php:2078 JLanguageHelper::getInstalledLanguages() Copy JROOT/plugins/system/languagefilter/languagefilter.php:1137 PlgSystemLanguageFilter->__construct() Copy JROOT/libraries/cms/plugin/helper.php:2556 JPluginHelper::import() Copy JROOT/libraries/cms/plugin/helper.php:1705 JPluginHelper::importPlugin() Copy JROOT/libraries/cms/application/cms.php:7394 JApplicationCms->initialiseApp() Copy JROOT/libraries/cms/application/site.php:6903 JApplicationSite->initialiseApp() Copy JROOT/libraries/cms/application/site.php:2092 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
Kyselyaika: 1.26 ms Viimeisen kyselyn jälkeen: 0.91 ms Kyselymuisti: 0.022 MB Muisti ennen kyselyä: 8.245 MB Palautetut rivit: 1
SELECT * FROM `axs_brands` WHERE language = 'en-GB ' AND (FIND_IN_SET ('k8s.intg.tovuti.io', domains) > 0) LIMIT 1EXPLAIN ei ole mahdollista kyselyssä: SELECT * FROM `axs_brands` WHERE language = 'en-GB' AND (FIND_IN_SET('k8s.intg.tovuti.io', domains) > 0) LIMIT 1
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.04 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.02 ms executing 0.05 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms
# Soittaja Tiedoston ja rivin numero 13 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172112 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/axslibs/brands.php:29011 AxsBrands::getData() Copy JROOT/libraries/axslibs/brands.php:35510 AxsBrands::getBrandObject() Copy JROOT/libraries/axslibs/brands.php:559 AxsBrands::getBrand() Copy JROOT/plugins/system/axslibs/axslibs.php:358 plgSystemAxslibs->onAfterInitialise() Copy JROOT/libraries/joomla/event/event.php:707 JEvent->update() Copy JROOT/libraries/joomla/event/dispatcher.php:1606 JEventDispatcher->trigger() Copy JROOT/libraries/joomla/application/base.php:1065 JApplicationBase->triggerEvent() Copy JROOT/libraries/cms/application/cms.php:7404 JApplicationCms->initialiseApp() Copy JROOT/libraries/cms/application/site.php:6903 JApplicationSite->initialiseApp() Copy JROOT/libraries/cms/application/site.php:2092 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
Kyselyaika: 1.29 ms Viimeisen kyselyn jälkeen: 0.05 ms Kyselymuisti: 0.030 MB Muisti ennen kyselyä: 8.267 MB Palautetut rivit: 19
SELECT * FROM joom_languages WHERE published = 1 ORDER BY `title`EXPLAIN ei ole mahdollista kyselyssä: SELECT * FROM joom_languages WHERE published = 1 ORDER BY `title`
Status Duration starting 0.04 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.02 ms executing 0.15 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms
# Soittaja Tiedoston ja rivin numero 14 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172113 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/axslibs/language.php:34212 AxsLanguage::getPublishedLanguages() Copy JROOT/libraries/axslibs/language.php:25111 AxsLanguage::getCurrentLanguage() Copy JROOT/libraries/axslibs/brands.php:37110 AxsBrands::getBrandObject() Copy JROOT/libraries/axslibs/brands.php:559 AxsBrands::getBrand() Copy JROOT/plugins/system/axslibs/axslibs.php:358 plgSystemAxslibs->onAfterInitialise() Copy JROOT/libraries/joomla/event/event.php:707 JEvent->update() Copy JROOT/libraries/joomla/event/dispatcher.php:1606 JEventDispatcher->trigger() Copy JROOT/libraries/joomla/application/base.php:1065 JApplicationBase->triggerEvent() Copy JROOT/libraries/cms/application/cms.php:7404 JApplicationCms->initialiseApp() Copy JROOT/libraries/cms/application/site.php:6903 JApplicationSite->initialiseApp() Copy JROOT/libraries/cms/application/site.php:2092 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
Kyselyaika: 1.16 ms Viimeisen kyselyn jälkeen: 1.05 ms Kyselymuisti: 0.021 MB Muisti ennen kyselyä: 8.545 MB Palautetut rivit: 1
SELECT * FROM `axs_homepage_templates` WHERE id= '1'EXPLAIN ei ole mahdollista kyselyssä: SELECT * FROM `axs_homepage_templates` WHERE id='1'
Status Duration starting 0.05 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.04 ms preparing 0.01 ms executing 0.02 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms
# Soittaja Tiedoston ja rivin numero 12 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172111 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/axslibs/brands.php:38810 AxsBrands::getBrandObject() Copy JROOT/libraries/axslibs/brands.php:559 AxsBrands::getBrand() Copy JROOT/plugins/system/axslibs/axslibs.php:358 plgSystemAxslibs->onAfterInitialise() Copy JROOT/libraries/joomla/event/event.php:707 JEvent->update() Copy JROOT/libraries/joomla/event/dispatcher.php:1606 JEventDispatcher->trigger() Copy JROOT/libraries/joomla/application/base.php:1065 JApplicationBase->triggerEvent() Copy JROOT/libraries/cms/application/cms.php:7404 JApplicationCms->initialiseApp() Copy JROOT/libraries/cms/application/site.php:6903 JApplicationSite->initialiseApp() Copy JROOT/libraries/cms/application/site.php:2092 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
Kyselyaika: 1.15 ms Viimeisen kyselyn jälkeen: 0.07 ms Kyselymuisti: 0.021 MB Muisti ennen kyselyä: 8.586 MB Palautetut rivit: 1
SELECT * FROM `axs_dashboard_templates` WHERE id= '2'EXPLAIN ei ole mahdollista kyselyssä: SELECT * FROM `axs_dashboard_templates` WHERE id='2'
Status Duration starting 0.04 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.01 ms executing 0.02 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms
# Soittaja Tiedoston ja rivin numero 12 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172111 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/axslibs/brands.php:40610 AxsBrands::getBrandObject() Copy JROOT/libraries/axslibs/brands.php:559 AxsBrands::getBrand() Copy JROOT/plugins/system/axslibs/axslibs.php:358 plgSystemAxslibs->onAfterInitialise() Copy JROOT/libraries/joomla/event/event.php:707 JEvent->update() Copy JROOT/libraries/joomla/event/dispatcher.php:1606 JEventDispatcher->trigger() Copy JROOT/libraries/joomla/application/base.php:1065 JApplicationBase->triggerEvent() Copy JROOT/libraries/cms/application/cms.php:7404 JApplicationCms->initialiseApp() Copy JROOT/libraries/cms/application/site.php:6903 JApplicationSite->initialiseApp() Copy JROOT/libraries/cms/application/site.php:2092 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
Kyselyaika: 1.08 ms Viimeisen kyselyn jälkeen: 0.06 ms Kyselymuisti: 0.022 MB Muisti ennen kyselyä: 8.606 MB Palautetut rivit: 1
SELECT *
FROM axs_email_settings
WHERE id = '1'EXPLAIN ei ole mahdollista kyselyssä: SELECT *
FROM axs_email_settings
WHERE id = '1'
Status Duration starting 0.03 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.00 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.01 ms executing 0.01 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms
# Soittaja Tiedoston ja rivin numero 13 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:168212 JDatabaseDriver->loadObject() Copy JROOT/libraries/axslibs/brands.php:63211 AxsBrands::getEmailSettingsById() Copy JROOT/libraries/axslibs/brands.php:40910 AxsBrands::getBrandObject() Copy JROOT/libraries/axslibs/brands.php:559 AxsBrands::getBrand() Copy JROOT/plugins/system/axslibs/axslibs.php:358 plgSystemAxslibs->onAfterInitialise() Copy JROOT/libraries/joomla/event/event.php:707 JEvent->update() Copy JROOT/libraries/joomla/event/dispatcher.php:1606 JEventDispatcher->trigger() Copy JROOT/libraries/joomla/application/base.php:1065 JApplicationBase->triggerEvent() Copy JROOT/libraries/cms/application/cms.php:7404 JApplicationCms->initialiseApp() Copy JROOT/libraries/cms/application/site.php:6903 JApplicationSite->initialiseApp() Copy JROOT/libraries/cms/application/site.php:2092 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
Kyselyaika: 1.07 ms Viimeisen kyselyn jälkeen: 0.04 ms Kyselymuisti: 0.022 MB Muisti ennen kyselyä: 8.615 MB Palautetut rivit: 1
SELECT *
FROM axs_payment_gateways
WHERE id = '1'EXPLAIN ei ole mahdollista kyselyssä: SELECT *
FROM axs_payment_gateways
WHERE id = '1'
Status Duration starting 0.03 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.01 ms executing 0.01 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms
# Soittaja Tiedoston ja rivin numero 13 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:168212 JDatabaseDriver->loadObject() Copy JROOT/libraries/axslibs/brands.php:58211 AxsBrands::getPaymentGatewayById() Copy JROOT/libraries/axslibs/brands.php:41210 AxsBrands::getBrandObject() Copy JROOT/libraries/axslibs/brands.php:559 AxsBrands::getBrand() Copy JROOT/plugins/system/axslibs/axslibs.php:358 plgSystemAxslibs->onAfterInitialise() Copy JROOT/libraries/joomla/event/event.php:707 JEvent->update() Copy JROOT/libraries/joomla/event/dispatcher.php:1606 JEventDispatcher->trigger() Copy JROOT/libraries/joomla/application/base.php:1065 JApplicationBase->triggerEvent() Copy JROOT/libraries/cms/application/cms.php:7404 JApplicationCms->initialiseApp() Copy JROOT/libraries/cms/application/site.php:6903 JApplicationSite->initialiseApp() Copy JROOT/libraries/cms/application/site.php:2092 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
Kyselyaika: 1.10 ms Viimeisen kyselyn jälkeen: 0.05 ms Kyselymuisti: 0.022 MB Muisti ennen kyselyä: 8.627 MB Palautetut rivit: 1
SELECT *
FROM axs_integrations
WHERE id = '1'EXPLAIN ei ole mahdollista kyselyssä: SELECT *
FROM axs_integrations
WHERE id = '1'
Status Duration starting 0.05 ms Executing hook on transaction 0.01 ms starting 0.00 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.01 ms executing 0.01 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms
# Soittaja Tiedoston ja rivin numero 13 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:168212 JDatabaseDriver->loadObject() Copy JROOT/libraries/axslibs/brands.php:65911 AxsBrands::getIntegrationById() Copy JROOT/libraries/axslibs/brands.php:41810 AxsBrands::getBrandObject() Copy JROOT/libraries/axslibs/brands.php:559 AxsBrands::getBrand() Copy JROOT/plugins/system/axslibs/axslibs.php:358 plgSystemAxslibs->onAfterInitialise() Copy JROOT/libraries/joomla/event/event.php:707 JEvent->update() Copy JROOT/libraries/joomla/event/dispatcher.php:1606 JEventDispatcher->trigger() Copy JROOT/libraries/joomla/application/base.php:1065 JApplicationBase->triggerEvent() Copy JROOT/libraries/cms/application/cms.php:7404 JApplicationCms->initialiseApp() Copy JROOT/libraries/cms/application/site.php:6903 JApplicationSite->initialiseApp() Copy JROOT/libraries/cms/application/site.php:2092 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
Kyselyaika: 2.34 ms Viimeisen kyselyn jälkeen: 11.47 ms Kyselymuisti: 0.101 MB Muisti ennen kyselyä: 10.339 MB Palautetut rivit: 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 ei ole mahdollista kyselyssä: 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.11 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.06 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.08 ms preparing 0.05 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.02 ms cleaning up 0.01 ms
# Soittaja Tiedoston ja rivin numero 22 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172121 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/cms/menu/site.php:8820 JMenuSite->{closure}() Copy JROOT/libraries/joomla/cache/controller/callback.php:16919 JCacheControllerCallback->get() Copy JROOT/libraries/cms/menu/site.php:9618 JMenuSite->load() Copy JROOT/libraries/cms/menu/menu.php:7417 JMenu->__construct() Copy JROOT/libraries/cms/menu/site.php:5716 JMenuSite->__construct() Copy JROOT/libraries/cms/menu/menu.php:12915 JMenu::getInstance() Copy JROOT/libraries/cms/application/cms.php:50014 JApplicationCms->getMenu() Copy JROOT/libraries/cms/application/site.php:27713 JApplicationSite->getMenu() Copy JROOT/libraries/cms/router/site.php:5912 JRouterSite->__construct() Copy JROOT/libraries/cms/router/router.php:19811 JRouter::getInstance() Copy JROOT/libraries/cms/application/cms.php:60510 JApplicationCms::getRouter() Copy JROOT/libraries/cms/application/site.php:4079 JApplicationSite::getRouter() Copy JROOT/plugins/system/languagefilter/languagefilter.php:1348 PlgSystemLanguageFilter->onAfterInitialise() Copy JROOT/libraries/joomla/event/event.php:707 JEvent->update() Copy JROOT/libraries/joomla/event/dispatcher.php:1606 JEventDispatcher->trigger() Copy JROOT/libraries/joomla/application/base.php:1065 JApplicationBase->triggerEvent() Copy JROOT/libraries/cms/application/cms.php:7404 JApplicationCms->initialiseApp() Copy JROOT/libraries/cms/application/site.php:6903 JApplicationSite->initialiseApp() Copy JROOT/libraries/cms/application/site.php:2092 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
Kyselyaika: 2.65 ms Viimeisen kyselyn jälkeen: 13.56 ms Kyselymuisti: 0.028 MB Muisti ennen kyselyä: 12.559 MB Palautetut rivit: 17
SHOW FULL COLUMNS FROM `joom_users `EXPLAIN ei ole mahdollista kyselyssä: SHOW FULL COLUMNS FROM `joom_users`
Status Duration starting 0.08 ms Executing hook on transaction 0.01 ms starting 0.06 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.50 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.12 ms preparing 0.04 ms Creating tmp table 0.06 ms executing 0.10 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.03 ms checking permissions 0.03 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.09 ms end 0.01 ms query end 0.02 ms waiting for handler commit 0.02 ms closing tables 0.02 ms freeing items 0.06 ms cleaning up 0.02 ms
# Soittaja Tiedoston ja rivin numero 20 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172119 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/joomla/database/driver/mysqli.php:42118 JDatabaseDriverMysqli->getTableColumns() Copy JROOT/libraries/joomla/table/table.php:24417 JTable->getFields() Copy JROOT/libraries/joomla/table/table.php:16316 JTable->__construct() Copy JROOT/libraries/joomla/table/user.php:3915 JTableUser->__construct() Copy JROOT/libraries/joomla/table/table.php:31114 JTable::getInstance() Copy JROOT/libraries/joomla/user/user.php:59813 JUser::getTable() Copy JROOT/libraries/joomla/user/user.php:78212 JUser->save() Copy JROOT/plugins/system/languagefilter/languagefilter.php:84811 PlgSystemLanguageFilter->setPreferredLanguage() Copy JROOT/plugins/system/languagefilter/languagefilter.php:51210 PlgSystemLanguageFilter->parseRule() Copy JROOT/libraries/cms/router/router.php:5979 JRouter->processParseRules() Copy JROOT/libraries/cms/router/site.php:5848 JRouterSite->processParseRules() Copy JROOT/libraries/cms/router/router.php:5717 JRouter->_processParseRules() Copy JROOT/libraries/cms/router/router.php:2256 JRouter->parse() Copy JROOT/libraries/cms/router/site.php:1335 JRouterSite->parse() Copy JROOT/libraries/cms/application/cms.php:12204 JApplicationCms->route() Copy JROOT/libraries/cms/application/site.php:8003 JApplicationSite->route() Copy JROOT/libraries/cms/application/site.php:2152 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
Kyselyaika: 1.19 ms Viimeisen kyselyn jälkeen: 0.27 ms Kyselymuisti: 0.022 MB Muisti ennen kyselyä: 12.603 MB Palautetut rivit: 1
SELECT `id`,`title`
FROM `joom_usergroups `
WHERE `id` = 1EXPLAIN ei ole mahdollista kyselyssä: SELECT `id`,`title`
FROM `joom_usergroups`
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.05 ms preparing 0.01 ms executing 0.01 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms
# Soittaja Tiedoston ja rivin numero 15 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:152614 JDatabaseDriver->loadAssocList() Copy JROOT/libraries/joomla/table/user.php:15213 JTableUser->bind() Copy JROOT/libraries/joomla/user/user.php:78412 JUser->save() Copy JROOT/plugins/system/languagefilter/languagefilter.php:84811 PlgSystemLanguageFilter->setPreferredLanguage() Copy JROOT/plugins/system/languagefilter/languagefilter.php:51210 PlgSystemLanguageFilter->parseRule() Copy JROOT/libraries/cms/router/router.php:5979 JRouter->processParseRules() Copy JROOT/libraries/cms/router/site.php:5848 JRouterSite->processParseRules() Copy JROOT/libraries/cms/router/router.php:5717 JRouter->_processParseRules() Copy JROOT/libraries/cms/router/router.php:2256 JRouter->parse() Copy JROOT/libraries/cms/router/site.php:1335 JRouterSite->parse() Copy JROOT/libraries/cms/application/cms.php:12204 JApplicationCms->route() Copy JROOT/libraries/cms/application/site.php:8003 JApplicationSite->route() Copy JROOT/libraries/cms/application/site.php:2152 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
Kyselyaika: 1.15 ms Viimeisen kyselyn jälkeen: 0.77 ms Kyselymuisti: 0.021 MB Muisti ennen kyselyä: 12.763 MB Palautetut rivit: 1
SELECT `splms_course_id`
FROM joom_splms_courses
WHERE `slug`= '5'EXPLAIN ei ole mahdollista kyselyssä: SELECT `splms_course_id`
FROM joom_splms_courses
WHERE `slug`='5'
Status Duration starting 0.04 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.02 ms executing 0.05 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms
# Soittaja Tiedoston ja rivin numero 12 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:176011 JDatabaseDriver->loadResult() Copy JROOT/components/com_splms/router.php:16810 SplmsParseRoute() Copy JROOT/libraries/cms/component/router/legacy.php:1049 JComponentRouterLegacy->parse() Copy JROOT/libraries/cms/router/site.php:4328 JRouterSite->parseSefRoute() Copy JROOT/libraries/cms/router/router.php:4837 JRouter->_parseSefRoute() Copy JROOT/libraries/cms/router/router.php:2366 JRouter->parse() Copy JROOT/libraries/cms/router/site.php:1335 JRouterSite->parse() Copy JROOT/libraries/cms/application/cms.php:12204 JApplicationCms->route() Copy JROOT/libraries/cms/application/site.php:8003 JApplicationSite->route() Copy JROOT/libraries/cms/application/site.php:2152 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
Kyselyaika: 1.21 ms Viimeisen kyselyn jälkeen: 11.41 ms Kyselymuisti: 0.019 MB Muisti ennen kyselyä: 13.215 MB Palautetut rivit: 0
SELECT params
FROM axs_user_settings
WHERE id = 1EXPLAIN ei ole mahdollista kyselyssä: SELECT params
FROM axs_user_settings
WHERE id = 1
Status Duration starting 0.07 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.04 ms executing 0.01 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms
# Soittaja Tiedoston ja rivin numero 7 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:16826 JDatabaseDriver->loadObject() Copy JROOT/libraries/axslibs/user.php:6735 AxsUser::getGlobalUserSettings() Copy JROOT/libraries/axslibs/security.php:354 AxsSecurity::getSettings() Copy JROOT/libraries/cms/application/cms.php:3773 JApplicationCms->checkUserRequireTwoFactor() Copy JROOT/libraries/cms/application/site.php:2312 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
Kyselyaika: 1.17 ms Viimeisen kyselyn jälkeen: 2.05 ms Kyselymuisti: 0.019 MB Muisti ennen kyselyä: 13.605 MB Palautetut rivit: 0
SELECT *
FROM `joom_users `
WHERE `id` = 7EXPLAIN ei ole mahdollista kyselyssä: SELECT *
FROM `joom_users`
WHERE `id` = 7
Status Duration starting 0.05 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.04 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.04 ms executing 0.02 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms
# Soittaja Tiedoston ja rivin numero 6 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:16825 JDatabaseDriver->loadObject() Copy JROOT/administrator/components/com_users/models/user.php:9924 UsersModelUser->getOtpConfig() Copy JROOT/libraries/cms/application/cms.php:3813 JApplicationCms->checkUserRequireTwoFactor() Copy JROOT/libraries/cms/application/site.php:2312 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
Kyselyaika: 1.38 ms Viimeisen kyselyn jälkeen: 0.13 ms Kyselymuisti: 0.019 MB Muisti ennen kyselyä: 13.615 MB Palautetut rivit: 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 ei ole mahdollista kyselyssä: 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.01 ms statistics 0.08 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.01 ms
# Soittaja Tiedoston ja rivin numero 6 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:17215 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/cms/application/site.php:4904 JApplicationSite->getTemplate() Copy JROOT/libraries/cms/application/site.php:1653 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
Kyselyaika: 1.32 ms Viimeisen kyselyn jälkeen: 18.05 ms Kyselymuisti: 0.024 MB Muisti ennen kyselyä: 16.054 MB Palautetut rivit: 1
SELECT *
FROM axs_lms_settings
WHERE id= 1 LIMIT 1EXPLAIN ei ole mahdollista kyselyssä: SELECT *
FROM axs_lms_settings
WHERE id=1 LIMIT 1
Status Duration starting 0.09 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.04 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.02 ms executing 0.01 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.00 ms
# Soittaja Tiedoston ja rivin numero 17 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:168216 JDatabaseDriver->loadObject() Copy JROOT/libraries/axslibs/lms.php:178915 AxsLMS::getSettings() Copy JROOT/components/com_splms/models/courses.php:3514 SplmsModelCourses->__construct() Copy JROOT/libraries/fof/model/model.php:34713 FOFModel::getAnInstance() Copy JROOT/libraries/fof/controller/controller.php:254712 FOFController->createModel() Copy JROOT/libraries/fof/controller/controller.php:232011 FOFController->getModel() Copy JROOT/libraries/fof/controller/controller.php:228210 FOFController->getThisModel() Copy JROOT/libraries/fof/controller/controller.php:11829 FOFController->read() Copy JROOT/libraries/fof/controller/controller.php:9708 FOFController->execute() Copy JROOT/libraries/fof/dispatcher/dispatcher.php:3287 FOFDispatcher->dispatch() Copy JROOT/components/com_splms/splms.php:356 require_once Copy JROOT/components/com_splms/splms.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
Kyselyaika: 9.24 ms Viimeisen kyselyn jälkeen: 3.63 ms Kyselymuisti: 0.064 MB Muisti ennen kyselyä: 16.616 MB Palautetut rivit: 713
SHOW TABLES EXPLAIN ei ole mahdollista kyselyssä: 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.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.05 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.05 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.20 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.08 ms cleaning up 0.01 ms
# Soittaja Tiedoston ja rivin numero 19 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:157018 JDatabaseDriver->loadColumn() Copy JROOT/libraries/joomla/database/driver/mysqli.php:47717 JDatabaseDriverMysqli->getTableList() Copy JROOT/libraries/fof/database/driver/joomla.php:25116 FOFDatabaseDriverJoomla->getTableList() Copy JROOT/libraries/fof/table/table.php:208715 FOFTable->getTableFields() Copy JROOT/libraries/fof/table/table.php:53614 FOFTable->__construct() Copy JROOT/libraries/fof/table/table.php:43313 FOFTable::getAnInstance() Copy JROOT/libraries/fof/model/model.php:209812 FOFModel->_createTable() Copy JROOT/libraries/fof/model/model.php:205511 FOFModel->getTable() Copy JROOT/libraries/fof/model/model.php:117310 FOFModel->getItem() Copy JROOT/libraries/fof/controller/controller.php:11989 FOFController->read() Copy JROOT/libraries/fof/controller/controller.php:9708 FOFController->execute() Copy JROOT/libraries/fof/dispatcher/dispatcher.php:3287 FOFDispatcher->dispatch() Copy JROOT/components/com_splms/splms.php:356 require_once Copy JROOT/components/com_splms/splms.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
Kyselyaika: 2.98 ms Viimeisen kyselyn jälkeen: 0.16 ms Kyselymuisti: 0.033 MB Muisti ennen kyselyä: 16.696 MB Palautetut rivit: 40
SHOW FULL COLUMNS FROM `joom_splms_courses `EXPLAIN ei ole mahdollista kyselyssä: SHOW FULL COLUMNS FROM `joom_splms_courses`
Status Duration starting 0.06 ms Executing hook on transaction 0.01 ms starting 0.05 ms checking permissions 0.01 ms checking permissions 0.00 ms Opening tables 0.49 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.09 ms preparing 0.04 ms Creating tmp table 0.05 ms executing 0.09 ms checking permissions 0.06 ms checking permissions 0.03 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.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.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.05 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.08 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.02 ms closing tables 0.02 ms freeing items 0.06 ms cleaning up 0.01 ms
# Soittaja Tiedoston ja rivin numero 19 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172118 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/joomla/database/driver/mysqli.php:42117 JDatabaseDriverMysqli->getTableColumns() Copy JROOT/libraries/fof/database/driver/joomla.php:22916 FOFDatabaseDriverJoomla->getTableColumns() Copy JROOT/libraries/fof/table/table.php:217215 FOFTable->getTableFields() Copy JROOT/libraries/fof/table/table.php:53614 FOFTable->__construct() Copy JROOT/libraries/fof/table/table.php:43313 FOFTable::getAnInstance() Copy JROOT/libraries/fof/model/model.php:209812 FOFModel->_createTable() Copy JROOT/libraries/fof/model/model.php:205511 FOFModel->getTable() Copy JROOT/libraries/fof/model/model.php:117310 FOFModel->getItem() Copy JROOT/libraries/fof/controller/controller.php:11989 FOFController->read() Copy JROOT/libraries/fof/controller/controller.php:9708 FOFController->execute() Copy JROOT/libraries/fof/dispatcher/dispatcher.php:3287 FOFDispatcher->dispatch() Copy JROOT/components/com_splms/splms.php:356 require_once Copy JROOT/components/com_splms/splms.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
Kyselyaika: 1.21 ms Viimeisen kyselyn jälkeen: 0.49 ms Kyselymuisti: 0.023 MB Muisti ennen kyselyä: 16.802 MB Palautetut rivit: 1
SELECT joom_splms_courses .*
FROM joom_splms_courses
WHERE `joom_splms_courses `.`splms_course_id` = '7'EXPLAIN ei ole mahdollista kyselyssä: SELECT joom_splms_courses.*
FROM joom_splms_courses
WHERE `joom_splms_courses`.`splms_course_id` = '7'
Status Duration starting 0.06 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.05 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.01 ms executing 0.03 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms
# Soittaja Tiedoston ja rivin numero 14 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:148513 JDatabaseDriver->loadAssoc() Copy JROOT/libraries/fof/database/driver/joomla.php:29112 FOFDatabaseDriverJoomla->loadAssoc() Copy JROOT/libraries/fof/table/table.php:94911 FOFTable->load() Copy JROOT/libraries/fof/model/model.php:117410 FOFModel->getItem() Copy JROOT/libraries/fof/controller/controller.php:11989 FOFController->read() Copy JROOT/libraries/fof/controller/controller.php:9708 FOFController->execute() Copy JROOT/libraries/fof/dispatcher/dispatcher.php:3287 FOFDispatcher->dispatch() Copy JROOT/components/com_splms/splms.php:356 require_once Copy JROOT/components/com_splms/splms.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
Kyselyaika: 1.82 ms Viimeisen kyselyn jälkeen: 2.75 ms Kyselymuisti: 0.032 MB Muisti ennen kyselyä: 17.610 MB Palautetut rivit: 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 ei ole mahdollista kyselyssä: SELECT `id`,`name`,`rules`,`parent_id`
FROM `joom_assets`
WHERE `name` IN ('com_accessibility','com_admin','com_advpoll','com_affiliate','com_ajax','com_associations','com_award','com_axs','com_banners','com_bigbluebutton','com_board','com_cache','com_categories','com_checkin','com_community','com_config','com_contact','com_contactpage','com_content','com_contenthistory','com_contracts','com_converge','com_cpanel','com_dashboard','com_dbmanager','com_demo','com_domains','com_dump','com_easyblog','com_eshop','com_eventbooking','com_fields','com_finder','com_improved_ajax_login','com_installer','com_interactivecontent','com_invitex','com_jbusinessdirectory','com_jce','com_joomlaupdate','com_jumi','com_kunena','com_languages','com_lifeboard','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_notifications','com_offlajn_installer','com_osmembership','com_permissioning','com_plugins','com_postinstall','com_redirect','com_reports','com_rsticketspro','com_saas','com_scheduler','com_search','com_splms','com_tags','com_templates','com_uniterevolution','com_uniterevolution2','com_uniteshowbiz','com_user_view','com_users','com_weblinks','com_wrapper') OR `parent_id` = 0
Status Duration starting 0.09 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.00 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.37 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms
# Soittaja Tiedoston ja rivin numero 23 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172122 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/joomla/access/access.php:42721 JAccess::preloadComponents() Copy JROOT/libraries/joomla/access/access.php:21120 JAccess::preload() Copy JROOT/libraries/joomla/access/access.php:53019 JAccess::getAssetRules() Copy JROOT/libraries/joomla/access/access.php:18118 JAccess::check() Copy JROOT/libraries/joomla/user/user.php:39317 JUser->authorise() Copy JROOT/libraries/fof/integration/joomla/platform.php:58416 FOFIntegrationJoomlaPlatform->authorise() Copy JROOT/libraries/fof/view/raw.php:8015 FOFViewRaw->__construct() Copy JROOT/libraries/fof/view/html.php:5314 FOFViewHtml->__construct() Copy JROOT/libraries/fof/controller/controller.php:281113 FOFController->createView() Copy JROOT/libraries/fof/controller/controller.php:250612 FOFController->getView() Copy JROOT/libraries/fof/controller/controller.php:240811 FOFController->getThisView() Copy JROOT/libraries/fof/controller/controller.php:102810 FOFController->display() Copy JROOT/libraries/fof/controller/controller.php:12219 FOFController->read() Copy JROOT/libraries/fof/controller/controller.php:9708 FOFController->execute() Copy JROOT/libraries/fof/dispatcher/dispatcher.php:3287 FOFDispatcher->dispatch() Copy JROOT/components/com_splms/splms.php:356 require_once Copy JROOT/components/com_splms/splms.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
Kyselyaika: 1.34 ms Viimeisen kyselyn jälkeen: 1.76 ms Kyselymuisti: 0.022 MB Muisti ennen kyselyä: 17.973 MB Palautetut rivit: 0
SELECT *
FROM `joom_splms_lessons `
WHERE `enabled`= '1' AND `splms_course_id`= '7' AND `language`= 'fi-FI '
ORDER BY ordering ASC EXPLAIN ei ole mahdollista kyselyssä: SELECT *
FROM `joom_splms_lessons`
WHERE `enabled`='1' AND `splms_course_id`='7' AND `language`='fi-FI'
ORDER BY ordering ASC
Status Duration starting 0.06 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.05 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.01 ms closing tables 0.02 ms freeing items 0.03 ms cleaning up 0.01 ms
# Soittaja Tiedoston ja rivin numero 14 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172113 JDatabaseDriver->loadObjectList() Copy JROOT/components/com_splms/models/lessons.php:23812 SplmsModelLessons::getLessons() Copy JROOT/components/com_splms/views/course/view.html.php:3811 SplmsViewCourse->display() Copy JROOT/libraries/fof/controller/controller.php:112810 FOFController->display() Copy JROOT/libraries/fof/controller/controller.php:12219 FOFController->read() Copy JROOT/libraries/fof/controller/controller.php:9708 FOFController->execute() Copy JROOT/libraries/fof/dispatcher/dispatcher.php:3287 FOFDispatcher->dispatch() Copy JROOT/components/com_splms/splms.php:356 require_once Copy JROOT/components/com_splms/splms.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
Kyselyaika: 1.25 ms Viimeisen kyselyn jälkeen: 0.04 ms Kyselymuisti: 0.022 MB Muisti ennen kyselyä: 17.980 MB Palautetut rivit: 0
SELECT *
FROM `joom_splms_lessons `
WHERE `enabled`= '1' AND `lesson_type`= '0' AND `splms_course_id`= '7' AND `language`= 'fi-FI '
ORDER BY ordering ASC LIMIT 1EXPLAIN ei ole mahdollista kyselyssä: SELECT *
FROM `joom_splms_lessons`
WHERE `enabled`='1' AND `lesson_type`='0' AND `splms_course_id`='7' AND `language`='fi-FI'
ORDER BY ordering ASC 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.04 ms init 0.00 ms System lock 0.01 ms optimizing 0.02 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.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms
# Soittaja Tiedoston ja rivin numero 14 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172113 JDatabaseDriver->loadObjectList() Copy JROOT/components/com_splms/models/lessons.php:39912 SplmsModelLessons::getCourseFreeLesson() Copy JROOT/components/com_splms/views/course/view.html.php:3911 SplmsViewCourse->display() Copy JROOT/libraries/fof/controller/controller.php:112810 FOFController->display() Copy JROOT/libraries/fof/controller/controller.php:12219 FOFController->read() Copy JROOT/libraries/fof/controller/controller.php:9708 FOFController->execute() Copy JROOT/libraries/fof/dispatcher/dispatcher.php:3287 FOFDispatcher->dispatch() Copy JROOT/components/com_splms/splms.php:356 require_once Copy JROOT/components/com_splms/splms.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
Kyselyaika: 1.16 ms Viimeisen kyselyn jälkeen: 0.04 ms Kyselymuisti: 0.024 MB Muisti ennen kyselyä: 17.993 MB Palautetut rivit: 0
SELECT *
FROM `cctransactions`
WHERE `user_id`= 0 AND `type`= 0 AND `item_id`= 7 AND (`status`= 'STL ' OR `status`= 'SUC ')EXPLAIN ei ole mahdollista kyselyssä: SELECT *
FROM `cctransactions`
WHERE `user_id`=0 AND `type`=0 AND `item_id`=7 AND (`status`='STL' OR `status`='SUC')
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.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
# Soittaja Tiedoston ja rivin numero 15 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:168214 JDatabaseDriver->loadObject() Copy JROOT/libraries/axslibs/extra.php:63913 AxsExtra::hasBoughtItem() Copy JROOT/components/com_splms/models/courses.php:72712 SplmsModelCourses::getIsbuycourse() Copy JROOT/components/com_splms/views/course/view.html.php:4011 SplmsViewCourse->display() Copy JROOT/libraries/fof/controller/controller.php:112810 FOFController->display() Copy JROOT/libraries/fof/controller/controller.php:12219 FOFController->read() Copy JROOT/libraries/fof/controller/controller.php:9708 FOFController->execute() Copy JROOT/libraries/fof/dispatcher/dispatcher.php:3287 FOFDispatcher->dispatch() Copy JROOT/components/com_splms/splms.php:356 require_once Copy JROOT/components/com_splms/splms.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
Kyselyaika: 1.31 ms Viimeisen kyselyn jälkeen: 6.95 ms Kyselymuisti: 0.022 MB Muisti ennen kyselyä: 18.981 MB Palautetut rivit: 0
SELECT event_id
FROM joom_splms_courses_events ce
LEFT JOIN joom_eb_events e ON e.id = ce.event_id
WHERE ce.course_id = 7 AND e.published = 1
ORDER BY event_date ASC EXPLAIN ei ole mahdollista kyselyssä: 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
ORDER BY event_date ASC
Status Duration starting 0.08 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms 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 Creating tmp table 0.04 ms executing 0.03 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.00 ms
# Soittaja Tiedoston ja rivin numero 14 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:157013 JDatabaseDriver->loadColumn() Copy JROOT/libraries/axslibs/events.php:22712 AxsEvents::getCourseEvents() Copy JROOT/components/com_splms/views/course/view.html.php:4111 SplmsViewCourse->display() Copy JROOT/libraries/fof/controller/controller.php:112810 FOFController->display() Copy JROOT/libraries/fof/controller/controller.php:12219 FOFController->read() Copy JROOT/libraries/fof/controller/controller.php:9708 FOFController->execute() Copy JROOT/libraries/fof/dispatcher/dispatcher.php:3287 FOFDispatcher->dispatch() Copy JROOT/components/com_splms/splms.php:356 require_once Copy JROOT/components/com_splms/splms.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
Kyselyaika: 1.13 ms Viimeisen kyselyn jälkeen: 0.03 ms Kyselymuisti: 0.022 MB Muisti ennen kyselyä: 18.987 MB Palautetut rivit: 0
SELECT *
FROM joom_splms_quizquestions
WHERE `splms_course_id`= '7'EXPLAIN ei ole mahdollista kyselyssä: SELECT *
FROM joom_splms_quizquestions
WHERE `splms_course_id`='7'
Status Duration starting 0.04 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.02 ms executing 0.06 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms
# Soittaja Tiedoston ja rivin numero 14 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172113 JDatabaseDriver->loadObjectList() Copy JROOT/components/com_splms/models/quizquestions.php:6012 SplmsModelQuizquestions::getCourseQuizzes() Copy JROOT/components/com_splms/views/course/view.html.php:4311 SplmsViewCourse->display() Copy JROOT/libraries/fof/controller/controller.php:112810 FOFController->display() Copy JROOT/libraries/fof/controller/controller.php:12219 FOFController->read() Copy JROOT/libraries/fof/controller/controller.php:9708 FOFController->execute() Copy JROOT/libraries/fof/dispatcher/dispatcher.php:3287 FOFDispatcher->dispatch() Copy JROOT/components/com_splms/splms.php:356 require_once Copy JROOT/components/com_splms/splms.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
Kyselyaika: 1.21 ms Viimeisen kyselyn jälkeen: 0.05 ms Kyselymuisti: 0.022 MB Muisti ennen kyselyä: 18.996 MB Palautetut rivit: 0
SELECT `a`.`splms_quizresult_id`,`a`.`point`,`a`.`total_marks`,`a`.`splms_quizquestion_id`,`a`.`splms_course_id`,`b`.`title` AS `quiz_name`,`c`.`title` AS `course_name`,`c`.`slug` AS `course_slug`
FROM `joom_splms_quizresults ` AS `a`
LEFT JOIN `joom_splms_quizquestions ` AS `b` ON (`a`.`splms_quizquestion_id` = `b`.`splms_quizquestion_id`)
LEFT JOIN `joom_splms_courses ` AS `c` ON (`a`.`splms_course_id` = `c`.`splms_course_id`)
WHERE `a`.`user_id` = '0' AND `a`.`enabled` = 1 AND a.archive_date IS NULL EXPLAIN ei ole mahdollista kyselyssä: SELECT `a`.`splms_quizresult_id`,`a`.`point`,`a`.`total_marks`,`a`.`splms_quizquestion_id`,`a`.`splms_course_id`,`b`.`title` AS `quiz_name`,`c`.`title` AS `course_name`,`c`.`slug` AS `course_slug`
FROM `joom_splms_quizresults` AS `a`
LEFT JOIN `joom_splms_quizquestions` AS `b` ON (`a`.`splms_quizquestion_id` = `b`.`splms_quizquestion_id`)
LEFT JOIN `joom_splms_courses` AS `c` ON (`a`.`splms_course_id` = `c`.`splms_course_id`)
WHERE `a`.`user_id` = '0' AND `a`.`enabled` = 1 AND a.archive_date IS NULL
Status Duration starting 0.06 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.04 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.04 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
# Soittaja Tiedoston ja rivin numero 14 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172113 JDatabaseDriver->loadObjectList() Copy JROOT/components/com_splms/models/quizquestions.php:3512 SplmsModelQuizquestions->getQuizResult() Copy JROOT/components/com_splms/views/course/view.html.php:4411 SplmsViewCourse->display() Copy JROOT/libraries/fof/controller/controller.php:112810 FOFController->display() Copy JROOT/libraries/fof/controller/controller.php:12219 FOFController->read() Copy JROOT/libraries/fof/controller/controller.php:9708 FOFController->execute() Copy JROOT/libraries/fof/dispatcher/dispatcher.php:3287 FOFDispatcher->dispatch() Copy JROOT/components/com_splms/splms.php:356 require_once Copy JROOT/components/com_splms/splms.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
Kyselyaika: 1.14 ms Viimeisen kyselyn jälkeen: 0.03 ms Kyselymuisti: 0.022 MB Muisti ennen kyselyä: 19.000 MB Palautetut rivit: 0
SELECT *
FROM `joom_splms_accuratethoughts `
WHERE `course_id`= '7' AND `user_id`= '0'EXPLAIN ei ole mahdollista kyselyssä: SELECT *
FROM `joom_splms_accuratethoughts`
WHERE `course_id`='7' AND `user_id`='0'
Status Duration starting 0.04 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.01 ms executing 0.02 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.01 ms
# Soittaja Tiedoston ja rivin numero 14 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172113 JDatabaseDriver->loadObjectList() Copy JROOT/components/com_splms/models/accuratethoughts.php:2912 SplmsModelAccuratethoughts::getAccurateThoughts() Copy JROOT/components/com_splms/views/course/view.html.php:4511 SplmsViewCourse->display() Copy JROOT/libraries/fof/controller/controller.php:112810 FOFController->display() Copy JROOT/libraries/fof/controller/controller.php:12219 FOFController->read() Copy JROOT/libraries/fof/controller/controller.php:9708 FOFController->execute() Copy JROOT/libraries/fof/dispatcher/dispatcher.php:3287 FOFDispatcher->dispatch() Copy JROOT/components/com_splms/splms.php:356 require_once Copy JROOT/components/com_splms/splms.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
Kyselyaika: 1.21 ms Viimeisen kyselyn jälkeen: 0.04 ms Kyselymuisti: 0.023 MB Muisti ennen kyselyä: 19.007 MB Palautetut rivit: 0
Päällekkäiset kyselyt:
#46 SELECT *
FROM `joom_splms_lessons `
WHERE `splms_course_id`= 7 AND `enabled`= 1 AND `language`= 'fi-FI 'EXPLAIN ei ole mahdollista kyselyssä: SELECT *
FROM `joom_splms_lessons`
WHERE `splms_course_id`=7 AND `enabled`= 1 AND `language`='fi-FI'
Status Duration starting 0.03 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.06 ms preparing 0.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
# Soittaja Tiedoston ja rivin numero 15 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172114 JDatabaseDriver->loadObjectList() Copy JROOT/components/com_splms/models/courses.php:110813 SplmsModelCourses->getLessons() Copy JROOT/components/com_splms/models/courses.php:62312 SplmsModelCourses->getCourseTeachers() Copy JROOT/components/com_splms/views/course/view.html.php:4811 SplmsViewCourse->display() Copy JROOT/libraries/fof/controller/controller.php:112810 FOFController->display() Copy JROOT/libraries/fof/controller/controller.php:12219 FOFController->read() Copy JROOT/libraries/fof/controller/controller.php:9708 FOFController->execute() Copy JROOT/libraries/fof/dispatcher/dispatcher.php:3287 FOFDispatcher->dispatch() Copy JROOT/components/com_splms/splms.php:356 require_once Copy JROOT/components/com_splms/splms.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
Kyselyaika: 1.21 ms Viimeisen kyselyn jälkeen: 6.73 ms Kyselymuisti: 0.025 MB Muisti ennen kyselyä: 19.775 MB Palautetut rivit: 1
SELECT sef FROM joom_languages WHERE lang_code = 'fi-FI ' LIMIT 1EXPLAIN ei ole mahdollista kyselyssä: SELECT sef FROM joom_languages WHERE lang_code = 'fi-FI' LIMIT 1
Status Duration starting 0.06 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.01 ms executing 0.01 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms
# Soittaja Tiedoston ja rivin numero 20 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:168219 JDatabaseDriver->loadObject() Copy JROOT/libraries/axslibs/language.php:28518 AxsLanguage::getSefByLangCode() Copy JROOT/components/com_splms/models/courses.php:134517 SplmsModelCourses::setOverrides() Copy JROOT/components/com_splms/views/course/tmpl/default.php:816 include Copy JROOT/components/com_splms/views/course/tmpl/default.php Copy JROOT/libraries/fof/view/view.php:44215 FOFView->loadAnyTemplate() Copy JROOT/libraries/fof/view/view.php:84314 FOFView->loadTemplate() Copy JROOT/libraries/fof/view/view.php:47413 FOFView->display() Copy JROOT/libraries/fof/view/raw.php:12812 FOFViewRaw->display() Copy JROOT/components/com_splms/views/course/view.html.php:6911 SplmsViewCourse->display() Copy JROOT/libraries/fof/controller/controller.php:112810 FOFController->display() Copy JROOT/libraries/fof/controller/controller.php:12219 FOFController->read() Copy JROOT/libraries/fof/controller/controller.php:9708 FOFController->execute() Copy JROOT/libraries/fof/dispatcher/dispatcher.php:3287 FOFDispatcher->dispatch() Copy JROOT/components/com_splms/splms.php:356 require_once Copy JROOT/components/com_splms/splms.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
Kyselyaika: 1.16 ms Viimeisen kyselyn jälkeen: 0.40 ms Kyselymuisti: 0.026 MB Muisti ennen kyselyä: 19.835 MB Palautetut rivit: 1
SELECT *
FROM `joom_splms_courses `
WHERE `splms_course_id`= 7EXPLAIN ei ole mahdollista kyselyssä: SELECT *
FROM `joom_splms_courses`
WHERE `splms_course_id`=7
Status Duration starting 0.04 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.04 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.01 ms executing 0.03 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms
# Soittaja Tiedoston ja rivin numero 20 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:168219 JDatabaseDriver->loadObject() Copy JROOT/libraries/axslibs/pricingmodifiers.php:3118 AxsPricingModifiers::getUserCoursePrice() Copy JROOT/components/com_splms/models/courses.php:133317 SplmsModelCourses::overridePrice() Copy JROOT/components/com_splms/views/course/tmpl/default.php:916 include Copy JROOT/components/com_splms/views/course/tmpl/default.php Copy JROOT/libraries/fof/view/view.php:44215 FOFView->loadAnyTemplate() Copy JROOT/libraries/fof/view/view.php:84314 FOFView->loadTemplate() Copy JROOT/libraries/fof/view/view.php:47413 FOFView->display() Copy JROOT/libraries/fof/view/raw.php:12812 FOFViewRaw->display() Copy JROOT/components/com_splms/views/course/view.html.php:6911 SplmsViewCourse->display() Copy JROOT/libraries/fof/controller/controller.php:112810 FOFController->display() Copy JROOT/libraries/fof/controller/controller.php:12219 FOFController->read() Copy JROOT/libraries/fof/controller/controller.php:9708 FOFController->execute() Copy JROOT/libraries/fof/dispatcher/dispatcher.php:3287 FOFDispatcher->dispatch() Copy JROOT/components/com_splms/splms.php:356 require_once Copy JROOT/components/com_splms/splms.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
Kyselyaika: 1.20 ms Viimeisen kyselyn jälkeen: 0.03 ms Kyselymuisti: 0.026 MB Muisti ennen kyselyä: 19.852 MB Palautetut rivit: 0
Päällekkäiset kyselyt:
#54 #57 SELECT m.*
FROM `axs_pay_pricing_modifiers` m
LEFT JOIN `axs_pay_pricing_modifiers_segments` s ON m.id = s.modifier_id
WHERE segment = 'individual' AND user_id = 0 AND enabled = 1EXPLAIN ei ole mahdollista kyselyssä: SELECT m.*
FROM `axs_pay_pricing_modifiers` m
LEFT JOIN `axs_pay_pricing_modifiers_segments` s ON m.id = s.modifier_id
WHERE segment = 'individual' AND user_id = 0 AND 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.01 ms statistics 0.06 ms preparing 0.03 ms executing 0.02 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms
# Soittaja Tiedoston ja rivin numero 21 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172120 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/axslibs/pricingmodifiers.php:34519 AxsPricingModifiers::getUsersPricingModifiers() Copy JROOT/libraries/axslibs/pricingmodifiers.php:3618 AxsPricingModifiers::getUserCoursePrice() Copy JROOT/components/com_splms/models/courses.php:133317 SplmsModelCourses::overridePrice() Copy JROOT/components/com_splms/views/course/tmpl/default.php:916 include Copy JROOT/components/com_splms/views/course/tmpl/default.php Copy JROOT/libraries/fof/view/view.php:44215 FOFView->loadAnyTemplate() Copy JROOT/libraries/fof/view/view.php:84314 FOFView->loadTemplate() Copy JROOT/libraries/fof/view/view.php:47413 FOFView->display() Copy JROOT/libraries/fof/view/raw.php:12812 FOFViewRaw->display() Copy JROOT/components/com_splms/views/course/view.html.php:6911 SplmsViewCourse->display() Copy JROOT/libraries/fof/controller/controller.php:112810 FOFController->display() Copy JROOT/libraries/fof/controller/controller.php:12219 FOFController->read() Copy JROOT/libraries/fof/controller/controller.php:9708 FOFController->execute() Copy JROOT/libraries/fof/dispatcher/dispatcher.php:3287 FOFDispatcher->dispatch() Copy JROOT/components/com_splms/splms.php:356 require_once Copy JROOT/components/com_splms/splms.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
Kyselyaika: 1.14 ms Viimeisen kyselyn jälkeen: 0.03 ms Kyselymuisti: 0.026 MB Muisti ennen kyselyä: 19.862 MB Palautetut rivit: 0
Päällekkäiset kyselyt:
#55 #58 SELECT m.*
FROM `axs_pay_pricing_modifiers` m
LEFT JOIN `axs_pay_pricing_modifiers_segments` s ON m.id = s.modifier_id
WHERE segment = 'groups' AND group_id in (1) AND enabled = 1EXPLAIN ei ole mahdollista kyselyssä: SELECT m.*
FROM `axs_pay_pricing_modifiers` m
LEFT JOIN `axs_pay_pricing_modifiers_segments` s ON m.id = s.modifier_id
WHERE segment = 'groups' AND group_id in (1) AND enabled = 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.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
# Soittaja Tiedoston ja rivin numero 21 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172120 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/axslibs/pricingmodifiers.php:35919 AxsPricingModifiers::getUsersPricingModifiers() Copy JROOT/libraries/axslibs/pricingmodifiers.php:3618 AxsPricingModifiers::getUserCoursePrice() Copy JROOT/components/com_splms/models/courses.php:133317 SplmsModelCourses::overridePrice() Copy JROOT/components/com_splms/views/course/tmpl/default.php:916 include Copy JROOT/components/com_splms/views/course/tmpl/default.php Copy JROOT/libraries/fof/view/view.php:44215 FOFView->loadAnyTemplate() Copy JROOT/libraries/fof/view/view.php:84314 FOFView->loadTemplate() Copy JROOT/libraries/fof/view/view.php:47413 FOFView->display() Copy JROOT/libraries/fof/view/raw.php:12812 FOFViewRaw->display() Copy JROOT/components/com_splms/views/course/view.html.php:6911 SplmsViewCourse->display() Copy JROOT/libraries/fof/controller/controller.php:112810 FOFController->display() Copy JROOT/libraries/fof/controller/controller.php:12219 FOFController->read() Copy JROOT/libraries/fof/controller/controller.php:9708 FOFController->execute() Copy JROOT/libraries/fof/dispatcher/dispatcher.php:3287 FOFDispatcher->dispatch() Copy JROOT/components/com_splms/splms.php:356 require_once Copy JROOT/components/com_splms/splms.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
Kyselyaika: 2.42 ms Viimeisen kyselyn jälkeen: 1.91 ms Kyselymuisti: 0.031 MB Muisti ennen kyselyä: 20.148 MB Palautetut rivit: 21
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM joom_modules AS m
LEFT JOIN joom_modules_menu AS mm ON mm.moduleid = m.id
LEFT JOIN joom_extensions AS e ON e.element = m.module AND e.client_id = m.client_id
WHERE m.published = 1 AND e.enabled = 1 AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2024-10-05 14:27:07') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-10-05 14:27:07') AND m.access IN (1,1) AND m.client_id = 0 AND (mm.menuid = 864 OR mm.menuid <= 0) AND m.language IN ('fi-FI ','* ')
ORDER BY m.position, m.orderingEXPLAIN ei ole mahdollista kyselyssä: SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM joom_modules AS m
LEFT JOIN joom_modules_menu AS mm ON mm.moduleid = m.id
LEFT JOIN joom_extensions AS e ON e.element = m.module AND e.client_id = m.client_id
WHERE m.published = 1 AND e.enabled = 1 AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2024-10-05 14:27:07') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-10-05 14:27:07') AND m.access IN (1,1) AND m.client_id = 0 AND (mm.menuid = 864 OR mm.menuid <= 0) AND m.language IN ('fi-FI','*')
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.01 ms checking permissions 0.00 ms checking permissions 0.01 ms Opening tables 0.07 ms init 0.01 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.11 ms preparing 0.05 ms executing 1.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
# Soittaja Tiedoston ja rivin numero 24 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172123 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/joomla/cache/controller/callback.php:16922 JCacheControllerCallback->get() Copy JROOT/libraries/cms/module/helper.php:42421 JModuleHelper::getModuleList() Copy JROOT/libraries/cms/module/helper.php:36020 JModuleHelper::load() Copy JROOT/libraries/cms/module/helper.php:3419 JModuleHelper::getModule() Copy JROOT/components/shared/controllers/comments.php:618 require_once Copy JROOT/components/shared/controllers/comments.php Copy JROOT/components/com_splms/views/course/tmpl/dual.php:917 include_once Copy JROOT/components/com_splms/views/course/tmpl/dual.php Copy JROOT/components/com_splms/views/course/tmpl/default.php:1616 include Copy JROOT/components/com_splms/views/course/tmpl/default.php Copy JROOT/libraries/fof/view/view.php:44215 FOFView->loadAnyTemplate() Copy JROOT/libraries/fof/view/view.php:84314 FOFView->loadTemplate() Copy JROOT/libraries/fof/view/view.php:47413 FOFView->display() Copy JROOT/libraries/fof/view/raw.php:12812 FOFViewRaw->display() Copy JROOT/components/com_splms/views/course/view.html.php:6911 SplmsViewCourse->display() Copy JROOT/libraries/fof/controller/controller.php:112810 FOFController->display() Copy JROOT/libraries/fof/controller/controller.php:12219 FOFController->read() Copy JROOT/libraries/fof/controller/controller.php:9708 FOFController->execute() Copy JROOT/libraries/fof/dispatcher/dispatcher.php:3287 FOFDispatcher->dispatch() Copy JROOT/components/com_splms/splms.php:356 require_once Copy JROOT/components/com_splms/splms.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
Kyselyaika: 1.33 ms Viimeisen kyselyn jälkeen: 1.95 ms Kyselymuisti: 0.026 MB Muisti ennen kyselyä: 20.415 MB Palautetut rivit: 0
SELECT *
FROM `axs_course_purchases`
WHERE `user_id`= 0 AND `course_id`= 7 AND (status = 'PAID ' OR status = 'PART ' OR (status = 'REF ' AND access_retained = 1))EXPLAIN ei ole mahdollista kyselyssä: SELECT *
FROM `axs_course_purchases`
WHERE `user_id`=0 AND `course_id`=7 AND (status = 'PAID' OR status = 'PART' OR (status = 'REF' AND access_retained = 1))
Status Duration starting 0.08 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.04 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.08 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
# Soittaja Tiedoston ja rivin numero 20 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:168219 JDatabaseDriver->loadObject() Copy JROOT/libraries/axslibs/payment.php:28518 AxsPayment::hasUserPurchasedCourse() Copy JROOT/components/com_splms/views/course/tmpl/dual.php:3917 include_once Copy JROOT/components/com_splms/views/course/tmpl/dual.php Copy JROOT/components/com_splms/views/course/tmpl/default.php:1616 include Copy JROOT/components/com_splms/views/course/tmpl/default.php Copy JROOT/libraries/fof/view/view.php:44215 FOFView->loadAnyTemplate() Copy JROOT/libraries/fof/view/view.php:84314 FOFView->loadTemplate() Copy JROOT/libraries/fof/view/view.php:47413 FOFView->display() Copy JROOT/libraries/fof/view/raw.php:12812 FOFViewRaw->display() Copy JROOT/components/com_splms/views/course/view.html.php:6911 SplmsViewCourse->display() Copy JROOT/libraries/fof/controller/controller.php:112810 FOFController->display() Copy JROOT/libraries/fof/controller/controller.php:12219 FOFController->read() Copy JROOT/libraries/fof/controller/controller.php:9708 FOFController->execute() Copy JROOT/libraries/fof/dispatcher/dispatcher.php:3287 FOFDispatcher->dispatch() Copy JROOT/components/com_splms/splms.php:356 require_once Copy JROOT/components/com_splms/splms.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
Kyselyaika: 1.11 ms Viimeisen kyselyn jälkeen: 0.03 ms Kyselymuisti: 0.026 MB Muisti ennen kyselyä: 20.425 MB Palautetut rivit: 0
SELECT `id`
FROM `axs_pay_subscriptions`
WHERE `user_id`= 0EXPLAIN ei ole mahdollista kyselyssä: SELECT `id`
FROM `axs_pay_subscriptions`
WHERE `user_id`=0
Status Duration starting 0.04 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.01 ms executing 0.02 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms
# Soittaja Tiedoston ja rivin numero 20 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172119 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/axslibs/payment.php:47518 AxsPayment::getUserSubscriptions() Copy JROOT/components/com_splms/views/course/tmpl/dual.php:4017 include_once Copy JROOT/components/com_splms/views/course/tmpl/dual.php Copy JROOT/components/com_splms/views/course/tmpl/default.php:1616 include Copy JROOT/components/com_splms/views/course/tmpl/default.php Copy JROOT/libraries/fof/view/view.php:44215 FOFView->loadAnyTemplate() Copy JROOT/libraries/fof/view/view.php:84314 FOFView->loadTemplate() Copy JROOT/libraries/fof/view/view.php:47413 FOFView->display() Copy JROOT/libraries/fof/view/raw.php:12812 FOFViewRaw->display() Copy JROOT/components/com_splms/views/course/view.html.php:6911 SplmsViewCourse->display() Copy JROOT/libraries/fof/controller/controller.php:112810 FOFController->display() Copy JROOT/libraries/fof/controller/controller.php:12219 FOFController->read() Copy JROOT/libraries/fof/controller/controller.php:9708 FOFController->execute() Copy JROOT/libraries/fof/dispatcher/dispatcher.php:3287 FOFDispatcher->dispatch() Copy JROOT/components/com_splms/splms.php:356 require_once Copy JROOT/components/com_splms/splms.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
Kyselyaika: 1.28 ms Viimeisen kyselyn jälkeen: 4.45 ms Kyselymuisti: 0.026 MB Muisti ennen kyselyä: 20.435 MB Palautetut rivit: 0
Päällekkäiset kyselyt:
#38 SELECT *
FROM `joom_splms_lessons `
WHERE `splms_course_id`= 7 AND `enabled`= 1 AND `language`= 'fi-FI 'EXPLAIN ei ole mahdollista kyselyssä: SELECT *
FROM `joom_splms_lessons`
WHERE `splms_course_id`=7 AND `enabled`= 1 AND `language`='fi-FI'
Status Duration starting 0.04 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.07 ms preparing 0.02 ms executing 0.10 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.02 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.02 ms
# Soittaja Tiedoston ja rivin numero 20 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172119 JDatabaseDriver->loadObjectList() Copy JROOT/components/com_splms/models/courses.php:110818 SplmsModelCourses->getLessons() Copy JROOT/components/com_splms/views/course/tmpl/dual.php:12717 include_once Copy JROOT/components/com_splms/views/course/tmpl/dual.php Copy JROOT/components/com_splms/views/course/tmpl/default.php:1616 include Copy JROOT/components/com_splms/views/course/tmpl/default.php Copy JROOT/libraries/fof/view/view.php:44215 FOFView->loadAnyTemplate() Copy JROOT/libraries/fof/view/view.php:84314 FOFView->loadTemplate() Copy JROOT/libraries/fof/view/view.php:47413 FOFView->display() Copy JROOT/libraries/fof/view/raw.php:12812 FOFViewRaw->display() Copy JROOT/components/com_splms/views/course/view.html.php:6911 SplmsViewCourse->display() Copy JROOT/libraries/fof/controller/controller.php:112810 FOFController->display() Copy JROOT/libraries/fof/controller/controller.php:12219 FOFController->read() Copy JROOT/libraries/fof/controller/controller.php:9708 FOFController->execute() Copy JROOT/libraries/fof/dispatcher/dispatcher.php:3287 FOFDispatcher->dispatch() Copy JROOT/components/com_splms/splms.php:356 require_once Copy JROOT/components/com_splms/splms.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
Kyselyaika: 1.31 ms Viimeisen kyselyn jälkeen: 0.05 ms Kyselymuisti: 0.026 MB Muisti ennen kyselyä: 20.448 MB Palautetut rivit: 0
SELECT *
FROM `joom_splms_lesson_status ` AS s
INNER JOIN `joom_splms_lessons `AS l ON l.splms_lesson_id = s.lesson_id
WHERE `course_id`= 7 AND `status`= 'completed' AND s.archive_date IS NULL AND `s`.`user_id`= 0 AND `s`.`language`= 'fi-FI '
GROUP BY `s`.`user_id`,`s`.`course_id`,`s`.`lesson_id`
ORDER BY `l`.`ordering`ASC EXPLAIN ei ole mahdollista kyselyssä: SELECT *
FROM `joom_splms_lesson_status` AS s
INNER JOIN `joom_splms_lessons`AS l ON l.splms_lesson_id = s.lesson_id
WHERE `course_id`=7 AND `status`='completed' AND s.archive_date IS NULL AND `s`.`user_id`=0 AND `s`.`language`='fi-FI'
GROUP BY `s`.`user_id`,`s`.`course_id`,`s`.`lesson_id`
ORDER BY `l`.`ordering`ASC
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.08 ms preparing 0.02 ms Creating tmp table 0.06 ms executing 0.05 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms
# Soittaja Tiedoston ja rivin numero 20 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172119 JDatabaseDriver->loadObjectList() Copy JROOT/components/com_splms/models/courses.php:114918 SplmsModelCourses->getProgress() Copy JROOT/components/com_splms/views/course/tmpl/dual.php:14317 include_once Copy JROOT/components/com_splms/views/course/tmpl/dual.php Copy JROOT/components/com_splms/views/course/tmpl/default.php:1616 include Copy JROOT/components/com_splms/views/course/tmpl/default.php Copy JROOT/libraries/fof/view/view.php:44215 FOFView->loadAnyTemplate() Copy JROOT/libraries/fof/view/view.php:84314 FOFView->loadTemplate() Copy JROOT/libraries/fof/view/view.php:47413 FOFView->display() Copy JROOT/libraries/fof/view/raw.php:12812 FOFViewRaw->display() Copy JROOT/components/com_splms/views/course/view.html.php:6911 SplmsViewCourse->display() Copy JROOT/libraries/fof/controller/controller.php:112810 FOFController->display() Copy JROOT/libraries/fof/controller/controller.php:12219 FOFController->read() Copy JROOT/libraries/fof/controller/controller.php:9708 FOFController->execute() Copy JROOT/libraries/fof/dispatcher/dispatcher.php:3287 FOFDispatcher->dispatch() Copy JROOT/components/com_splms/splms.php:356 require_once Copy JROOT/components/com_splms/splms.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
Kyselyaika: 1.29 ms Viimeisen kyselyn jälkeen: 0.04 ms Kyselymuisti: 0.026 MB Muisti ennen kyselyä: 20.466 MB Palautetut rivit: 0
SELECT *
FROM `joom_splms_lesson_status ` AS s
INNER JOIN `joom_splms_lessons `AS l ON l.splms_lesson_id = s.lesson_id
WHERE `course_id`= 7 AND s.archive_date IS NULL AND `s`.`user_id`= 0 AND `s`.`language`= 'fi-FI '
GROUP BY `s`.`user_id`,`s`.`course_id`,`s`.`lesson_id`
ORDER BY `l`.`ordering`ASC EXPLAIN ei ole mahdollista kyselyssä: SELECT *
FROM `joom_splms_lesson_status` AS s
INNER JOIN `joom_splms_lessons`AS l ON l.splms_lesson_id = s.lesson_id
WHERE `course_id`=7 AND s.archive_date IS NULL AND `s`.`user_id`=0 AND `s`.`language`='fi-FI'
GROUP BY `s`.`user_id`,`s`.`course_id`,`s`.`lesson_id`
ORDER BY `l`.`ordering`ASC
Status Duration starting 0.05 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.02 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 Creating tmp table 0.05 ms executing 0.04 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms
# Soittaja Tiedoston ja rivin numero 20 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172119 JDatabaseDriver->loadObjectList() Copy JROOT/components/com_splms/models/courses.php:114918 SplmsModelCourses->getProgress() Copy JROOT/components/com_splms/views/course/tmpl/dual.php:14417 include_once Copy JROOT/components/com_splms/views/course/tmpl/dual.php Copy JROOT/components/com_splms/views/course/tmpl/default.php:1616 include Copy JROOT/components/com_splms/views/course/tmpl/default.php Copy JROOT/libraries/fof/view/view.php:44215 FOFView->loadAnyTemplate() Copy JROOT/libraries/fof/view/view.php:84314 FOFView->loadTemplate() Copy JROOT/libraries/fof/view/view.php:47413 FOFView->display() Copy JROOT/libraries/fof/view/raw.php:12812 FOFViewRaw->display() Copy JROOT/components/com_splms/views/course/view.html.php:6911 SplmsViewCourse->display() Copy JROOT/libraries/fof/controller/controller.php:112810 FOFController->display() Copy JROOT/libraries/fof/controller/controller.php:12219 FOFController->read() Copy JROOT/libraries/fof/controller/controller.php:9708 FOFController->execute() Copy JROOT/libraries/fof/dispatcher/dispatcher.php:3287 FOFDispatcher->dispatch() Copy JROOT/components/com_splms/splms.php:356 require_once Copy JROOT/components/com_splms/splms.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
Kyselyaika: 1.12 ms Viimeisen kyselyn jälkeen: 0.02 ms Kyselymuisti: 0.026 MB Muisti ennen kyselyä: 20.473 MB Palautetut rivit: 1
SELECT *
FROM `joom_splms_courses `
WHERE `splms_course_id`= 7EXPLAIN ei ole mahdollista kyselyssä: SELECT *
FROM `joom_splms_courses`
WHERE `splms_course_id`=7
Status Duration starting 0.03 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.01 ms executing 0.03 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms
# Soittaja Tiedoston ja rivin numero 20 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:168219 JDatabaseDriver->loadObject() Copy JROOT/components/com_splms/models/courses.php:56218 SplmsModelCourses::getCourseStudents() Copy JROOT/components/com_splms/views/course/tmpl/dual.php:15617 include_once Copy JROOT/components/com_splms/views/course/tmpl/dual.php Copy JROOT/components/com_splms/views/course/tmpl/default.php:1616 include Copy JROOT/components/com_splms/views/course/tmpl/default.php Copy JROOT/libraries/fof/view/view.php:44215 FOFView->loadAnyTemplate() Copy JROOT/libraries/fof/view/view.php:84314 FOFView->loadTemplate() Copy JROOT/libraries/fof/view/view.php:47413 FOFView->display() Copy JROOT/libraries/fof/view/raw.php:12812 FOFViewRaw->display() Copy JROOT/components/com_splms/views/course/view.html.php:6911 SplmsViewCourse->display() Copy JROOT/libraries/fof/controller/controller.php:112810 FOFController->display() Copy JROOT/libraries/fof/controller/controller.php:12219 FOFController->read() Copy JROOT/libraries/fof/controller/controller.php:9708 FOFController->execute() Copy JROOT/libraries/fof/dispatcher/dispatcher.php:3287 FOFDispatcher->dispatch() Copy JROOT/components/com_splms/splms.php:356 require_once Copy JROOT/components/com_splms/splms.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
Kyselyaika: 1.33 ms Viimeisen kyselyn jälkeen: 0.04 ms Kyselymuisti: 0.026 MB Muisti ennen kyselyä: 20.491 MB Palautetut rivit: 0
SELECT progress.user_id
FROM `joom_splms_course_progress ` AS `progress`
LEFT JOIN `joom_community_fields_values ` AS ` values` ON (`progress`.`user_id`= ` values`.`user_id`)
RIGHT JOIN `joom_users ` AS `user` ON (`progress`.`user_id`= `user`.`id`)
WHERE `progress`.`course_id`= 7 AND ` values`.`field_id`= 20 AND progress.archive_date IS NULL
GROUP BY `progress`.`user_id`
ORDER BY ` values`.`value` ASC EXPLAIN ei ole mahdollista kyselyssä: SELECT progress.user_id
FROM `joom_splms_course_progress` AS `progress`
LEFT JOIN `joom_community_fields_values` AS `values` ON (`progress`.`user_id`=`values`.`user_id`)
RIGHT JOIN `joom_users` AS `user` ON (`progress`.`user_id`=`user`.`id`)
WHERE `progress`.`course_id`=7 AND `values`.`field_id`= 20 AND progress.archive_date IS NULL
GROUP BY `progress`.`user_id`
ORDER BY `values`.`value` ASC
Status Duration starting 0.06 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms 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.10 ms preparing 0.02 ms Creating tmp table 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.02 ms cleaning up 0.01 ms
# Soittaja Tiedoston ja rivin numero 20 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172119 JDatabaseDriver->loadObjectList() Copy JROOT/components/com_splms/models/courses.php:61218 SplmsModelCourses::getCourseStudents() Copy JROOT/components/com_splms/views/course/tmpl/dual.php:15617 include_once Copy JROOT/components/com_splms/views/course/tmpl/dual.php Copy JROOT/components/com_splms/views/course/tmpl/default.php:1616 include Copy JROOT/components/com_splms/views/course/tmpl/default.php Copy JROOT/libraries/fof/view/view.php:44215 FOFView->loadAnyTemplate() Copy JROOT/libraries/fof/view/view.php:84314 FOFView->loadTemplate() Copy JROOT/libraries/fof/view/view.php:47413 FOFView->display() Copy JROOT/libraries/fof/view/raw.php:12812 FOFViewRaw->display() Copy JROOT/components/com_splms/views/course/view.html.php:6911 SplmsViewCourse->display() Copy JROOT/libraries/fof/controller/controller.php:112810 FOFController->display() Copy JROOT/libraries/fof/controller/controller.php:12219 FOFController->read() Copy JROOT/libraries/fof/controller/controller.php:9708 FOFController->execute() Copy JROOT/libraries/fof/dispatcher/dispatcher.php:3287 FOFDispatcher->dispatch() Copy JROOT/components/com_splms/splms.php:356 require_once Copy JROOT/components/com_splms/splms.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
Kyselyaika: 1.23 ms Viimeisen kyselyn jälkeen: 0.28 ms Kyselymuisti: 0.026 MB Muisti ennen kyselyä: 20.583 MB Palautetut rivit: 1
SELECT *
FROM `joom_splms_courses `
WHERE `enabled`= 1 AND `splms_course_id`= 7 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 ei ole mahdollista kyselyssä: SELECT *
FROM `joom_splms_courses`
WHERE `enabled`=1 AND `splms_course_id`=7 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.07 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.02 ms statistics 0.05 ms preparing 0.02 ms executing 0.03 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms
# Soittaja Tiedoston ja rivin numero 20 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:168219 JDatabaseDriver->loadObject() Copy JROOT/libraries/axslibs/contentAccess.php:11918 AxsContentAccess::checkVisibilityAccess() Copy JROOT/components/com_splms/views/course/tmpl/dual.php:16717 include_once Copy JROOT/components/com_splms/views/course/tmpl/dual.php Copy JROOT/components/com_splms/views/course/tmpl/default.php:1616 include Copy JROOT/components/com_splms/views/course/tmpl/default.php Copy JROOT/libraries/fof/view/view.php:44215 FOFView->loadAnyTemplate() Copy JROOT/libraries/fof/view/view.php:84314 FOFView->loadTemplate() Copy JROOT/libraries/fof/view/view.php:47413 FOFView->display() Copy JROOT/libraries/fof/view/raw.php:12812 FOFViewRaw->display() Copy JROOT/components/com_splms/views/course/view.html.php:6911 SplmsViewCourse->display() Copy JROOT/libraries/fof/controller/controller.php:112810 FOFController->display() Copy JROOT/libraries/fof/controller/controller.php:12219 FOFController->read() Copy JROOT/libraries/fof/controller/controller.php:9708 FOFController->execute() Copy JROOT/libraries/fof/dispatcher/dispatcher.php:3287 FOFDispatcher->dispatch() Copy JROOT/components/com_splms/splms.php:356 require_once Copy JROOT/components/com_splms/splms.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
Kyselyaika: 1.16 ms Viimeisen kyselyn jälkeen: 0.05 ms Kyselymuisti: 0.026 MB Muisti ennen kyselyä: 20.594 MB Palautetut rivit: 1
SELECT *
FROM `joom_splms_coursescategories `
WHERE `enabled`= 1 AND `splms_coursescategory_id`= 1 AND ( ( access_type = 'access' AND ( ( FIND_IN_SET ( 1, accesslevel ) > 0 ) OR ( FIND_IN_SET ( 1, accesslevel ) > 0 ) ) ) OR ( access_type = 'user' AND ( ( FIND_IN_SET ( 1, usergroup ) > 0 ) ) ) OR ( access_type = 'list' AND ( FIND_IN_SET ( 0, userlist ) > 0 ) ) OR ( access_type = 'none' OR access_type IS NULL ) )
ORDER BY ordering ASC EXPLAIN ei ole mahdollista kyselyssä: SELECT *
FROM `joom_splms_coursescategories`
WHERE `enabled`=1 AND `splms_coursescategory_id`=1 AND ( ( access_type = 'access' AND ( ( FIND_IN_SET( 1, accesslevel ) > 0 ) OR ( FIND_IN_SET( 1, accesslevel ) > 0 ) ) ) OR ( access_type = 'user' AND ( ( FIND_IN_SET( 1, usergroup ) > 0 ) ) ) OR ( access_type = 'list' AND ( FIND_IN_SET( 0, userlist ) > 0 ) ) OR ( access_type = 'none' OR access_type IS NULL ) )
ORDER BY ordering ASC
Status Duration starting 0.06 ms Executing hook on transaction 0.01 ms starting 0.00 ms checking permissions 0.00 ms Opening tables 0.04 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.04 ms preparing 0.01 ms executing 0.02 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms
# Soittaja Tiedoston ja rivin numero 20 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:168219 JDatabaseDriver->loadObject() Copy JROOT/libraries/axslibs/contentAccess.php:7418 AxsContentAccess::checkCategoryAccess() Copy JROOT/components/com_splms/views/course/tmpl/dual.php:17017 include_once Copy JROOT/components/com_splms/views/course/tmpl/dual.php Copy JROOT/components/com_splms/views/course/tmpl/default.php:1616 include Copy JROOT/components/com_splms/views/course/tmpl/default.php Copy JROOT/libraries/fof/view/view.php:44215 FOFView->loadAnyTemplate() Copy JROOT/libraries/fof/view/view.php:84314 FOFView->loadTemplate() Copy JROOT/libraries/fof/view/view.php:47413 FOFView->display() Copy JROOT/libraries/fof/view/raw.php:12812 FOFViewRaw->display() Copy JROOT/components/com_splms/views/course/view.html.php:6911 SplmsViewCourse->display() Copy JROOT/libraries/fof/controller/controller.php:112810 FOFController->display() Copy JROOT/libraries/fof/controller/controller.php:12219 FOFController->read() Copy JROOT/libraries/fof/controller/controller.php:9708 FOFController->execute() Copy JROOT/libraries/fof/dispatcher/dispatcher.php:3287 FOFDispatcher->dispatch() Copy JROOT/components/com_splms/splms.php:356 require_once Copy JROOT/components/com_splms/splms.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
Kyselyaika: 1.14 ms Viimeisen kyselyn jälkeen: 0.05 ms Kyselymuisti: 0.026 MB Muisti ennen kyselyä: 20.603 MB Palautetut rivit: 1
SELECT *
FROM `joom_splms_courses `
WHERE `splms_course_id`= 7EXPLAIN ei ole mahdollista kyselyssä: SELECT *
FROM `joom_splms_courses`
WHERE `splms_course_id`=7
Status Duration starting 0.03 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.01 ms executing 0.02 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms
# Soittaja Tiedoston ja rivin numero 20 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:168219 JDatabaseDriver->loadObject() Copy JROOT/libraries/axslibs/pricingmodifiers.php:3118 AxsPricingModifiers::getUserCoursePrice() Copy JROOT/components/com_splms/views/course/tmpl/dual.php:20917 include_once Copy JROOT/components/com_splms/views/course/tmpl/dual.php Copy JROOT/components/com_splms/views/course/tmpl/default.php:1616 include Copy JROOT/components/com_splms/views/course/tmpl/default.php Copy JROOT/libraries/fof/view/view.php:44215 FOFView->loadAnyTemplate() Copy JROOT/libraries/fof/view/view.php:84314 FOFView->loadTemplate() Copy JROOT/libraries/fof/view/view.php:47413 FOFView->display() Copy JROOT/libraries/fof/view/raw.php:12812 FOFViewRaw->display() Copy JROOT/components/com_splms/views/course/view.html.php:6911 SplmsViewCourse->display() Copy JROOT/libraries/fof/controller/controller.php:112810 FOFController->display() Copy JROOT/libraries/fof/controller/controller.php:12219 FOFController->read() Copy JROOT/libraries/fof/controller/controller.php:9708 FOFController->execute() Copy JROOT/libraries/fof/dispatcher/dispatcher.php:3287 FOFDispatcher->dispatch() Copy JROOT/components/com_splms/splms.php:356 require_once Copy JROOT/components/com_splms/splms.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
Kyselyaika: 1.19 ms Viimeisen kyselyn jälkeen: 0.05 ms Kyselymuisti: 0.026 MB Muisti ennen kyselyä: 20.620 MB Palautetut rivit: 0
Päällekkäiset kyselyt:
#41 #57 SELECT m.*
FROM `axs_pay_pricing_modifiers` m
LEFT JOIN `axs_pay_pricing_modifiers_segments` s ON m.id = s.modifier_id
WHERE segment = 'individual' AND user_id = 0 AND enabled = 1EXPLAIN ei ole mahdollista kyselyssä: SELECT m.*
FROM `axs_pay_pricing_modifiers` m
LEFT JOIN `axs_pay_pricing_modifiers_segments` s ON m.id = s.modifier_id
WHERE segment = 'individual' AND user_id = 0 AND 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.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.05 ms preparing 0.02 ms executing 0.02 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms
# Soittaja Tiedoston ja rivin numero 21 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172120 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/axslibs/pricingmodifiers.php:34519 AxsPricingModifiers::getUsersPricingModifiers() Copy JROOT/libraries/axslibs/pricingmodifiers.php:3618 AxsPricingModifiers::getUserCoursePrice() Copy JROOT/components/com_splms/views/course/tmpl/dual.php:20917 include_once Copy JROOT/components/com_splms/views/course/tmpl/dual.php Copy JROOT/components/com_splms/views/course/tmpl/default.php:1616 include Copy JROOT/components/com_splms/views/course/tmpl/default.php Copy JROOT/libraries/fof/view/view.php:44215 FOFView->loadAnyTemplate() Copy JROOT/libraries/fof/view/view.php:84314 FOFView->loadTemplate() Copy JROOT/libraries/fof/view/view.php:47413 FOFView->display() Copy JROOT/libraries/fof/view/raw.php:12812 FOFViewRaw->display() Copy JROOT/components/com_splms/views/course/view.html.php:6911 SplmsViewCourse->display() Copy JROOT/libraries/fof/controller/controller.php:112810 FOFController->display() Copy JROOT/libraries/fof/controller/controller.php:12219 FOFController->read() Copy JROOT/libraries/fof/controller/controller.php:9708 FOFController->execute() Copy JROOT/libraries/fof/dispatcher/dispatcher.php:3287 FOFDispatcher->dispatch() Copy JROOT/components/com_splms/splms.php:356 require_once Copy JROOT/components/com_splms/splms.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
Kyselyaika: 1.15 ms Viimeisen kyselyn jälkeen: 0.05 ms Kyselymuisti: 0.026 MB Muisti ennen kyselyä: 20.631 MB Palautetut rivit: 0
Päällekkäiset kyselyt:
#42 #58 SELECT m.*
FROM `axs_pay_pricing_modifiers` m
LEFT JOIN `axs_pay_pricing_modifiers_segments` s ON m.id = s.modifier_id
WHERE segment = 'groups' AND group_id in (1) AND enabled = 1EXPLAIN ei ole mahdollista kyselyssä: SELECT m.*
FROM `axs_pay_pricing_modifiers` m
LEFT JOIN `axs_pay_pricing_modifiers_segments` s ON m.id = s.modifier_id
WHERE segment = 'groups' AND group_id in (1) AND enabled = 1
Status Duration starting 0.04 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.02 ms executing 0.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
# Soittaja Tiedoston ja rivin numero 21 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172120 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/axslibs/pricingmodifiers.php:35919 AxsPricingModifiers::getUsersPricingModifiers() Copy JROOT/libraries/axslibs/pricingmodifiers.php:3618 AxsPricingModifiers::getUserCoursePrice() Copy JROOT/components/com_splms/views/course/tmpl/dual.php:20917 include_once Copy JROOT/components/com_splms/views/course/tmpl/dual.php Copy JROOT/components/com_splms/views/course/tmpl/default.php:1616 include Copy JROOT/components/com_splms/views/course/tmpl/default.php Copy JROOT/libraries/fof/view/view.php:44215 FOFView->loadAnyTemplate() Copy JROOT/libraries/fof/view/view.php:84314 FOFView->loadTemplate() Copy JROOT/libraries/fof/view/view.php:47413 FOFView->display() Copy JROOT/libraries/fof/view/raw.php:12812 FOFViewRaw->display() Copy JROOT/components/com_splms/views/course/view.html.php:6911 SplmsViewCourse->display() Copy JROOT/libraries/fof/controller/controller.php:112810 FOFController->display() Copy JROOT/libraries/fof/controller/controller.php:12219 FOFController->read() Copy JROOT/libraries/fof/controller/controller.php:9708 FOFController->execute() Copy JROOT/libraries/fof/dispatcher/dispatcher.php:3287 FOFDispatcher->dispatch() Copy JROOT/components/com_splms/splms.php:356 require_once Copy JROOT/components/com_splms/splms.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
Kyselyaika: 1.12 ms Viimeisen kyselyn jälkeen: 0.07 ms Kyselymuisti: 0.026 MB Muisti ennen kyselyä: 20.634 MB Palautetut rivit: 1
SELECT *
FROM `joom_splms_courses `
WHERE `splms_course_id`= 7EXPLAIN ei ole mahdollista kyselyssä: SELECT *
FROM `joom_splms_courses`
WHERE `splms_course_id`=7
Status Duration starting 0.02 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.01 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.01 ms executing 0.02 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms
# Soittaja Tiedoston ja rivin numero 20 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:168219 JDatabaseDriver->loadObject() Copy JROOT/libraries/axslibs/pricingmodifiers.php:7918 AxsPricingModifiers::getUserCourseModifiers() Copy JROOT/components/com_splms/views/course/tmpl/dual.php:20917 include_once Copy JROOT/components/com_splms/views/course/tmpl/dual.php Copy JROOT/components/com_splms/views/course/tmpl/default.php:1616 include Copy JROOT/components/com_splms/views/course/tmpl/default.php Copy JROOT/libraries/fof/view/view.php:44215 FOFView->loadAnyTemplate() Copy JROOT/libraries/fof/view/view.php:84314 FOFView->loadTemplate() Copy JROOT/libraries/fof/view/view.php:47413 FOFView->display() Copy JROOT/libraries/fof/view/raw.php:12812 FOFViewRaw->display() Copy JROOT/components/com_splms/views/course/view.html.php:6911 SplmsViewCourse->display() Copy JROOT/libraries/fof/controller/controller.php:112810 FOFController->display() Copy JROOT/libraries/fof/controller/controller.php:12219 FOFController->read() Copy JROOT/libraries/fof/controller/controller.php:9708 FOFController->execute() Copy JROOT/libraries/fof/dispatcher/dispatcher.php:3287 FOFDispatcher->dispatch() Copy JROOT/components/com_splms/splms.php:356 require_once Copy JROOT/components/com_splms/splms.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
Kyselyaika: 1.11 ms Viimeisen kyselyn jälkeen: 0.04 ms Kyselymuisti: 0.026 MB Muisti ennen kyselyä: 20.651 MB Palautetut rivit: 0
Päällekkäiset kyselyt:
#41 #54 SELECT m.*
FROM `axs_pay_pricing_modifiers` m
LEFT JOIN `axs_pay_pricing_modifiers_segments` s ON m.id = s.modifier_id
WHERE segment = 'individual' AND user_id = 0 AND enabled = 1EXPLAIN ei ole mahdollista kyselyssä: SELECT m.*
FROM `axs_pay_pricing_modifiers` m
LEFT JOIN `axs_pay_pricing_modifiers_segments` s ON m.id = s.modifier_id
WHERE segment = 'individual' AND user_id = 0 AND enabled = 1
Status Duration starting 0.04 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms 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.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms
# Soittaja Tiedoston ja rivin numero 21 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172120 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/axslibs/pricingmodifiers.php:34519 AxsPricingModifiers::getUsersPricingModifiers() Copy JROOT/libraries/axslibs/pricingmodifiers.php:8118 AxsPricingModifiers::getUserCourseModifiers() Copy JROOT/components/com_splms/views/course/tmpl/dual.php:20917 include_once Copy JROOT/components/com_splms/views/course/tmpl/dual.php Copy JROOT/components/com_splms/views/course/tmpl/default.php:1616 include Copy JROOT/components/com_splms/views/course/tmpl/default.php Copy JROOT/libraries/fof/view/view.php:44215 FOFView->loadAnyTemplate() Copy JROOT/libraries/fof/view/view.php:84314 FOFView->loadTemplate() Copy JROOT/libraries/fof/view/view.php:47413 FOFView->display() Copy JROOT/libraries/fof/view/raw.php:12812 FOFViewRaw->display() Copy JROOT/components/com_splms/views/course/view.html.php:6911 SplmsViewCourse->display() Copy JROOT/libraries/fof/controller/controller.php:112810 FOFController->display() Copy JROOT/libraries/fof/controller/controller.php:12219 FOFController->read() Copy JROOT/libraries/fof/controller/controller.php:9708 FOFController->execute() Copy JROOT/libraries/fof/dispatcher/dispatcher.php:3287 FOFDispatcher->dispatch() Copy JROOT/components/com_splms/splms.php:356 require_once Copy JROOT/components/com_splms/splms.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
Kyselyaika: 1.10 ms Viimeisen kyselyn jälkeen: 0.03 ms Kyselymuisti: 0.026 MB Muisti ennen kyselyä: 20.662 MB Palautetut rivit: 0
Päällekkäiset kyselyt:
#42 #55 SELECT m.*
FROM `axs_pay_pricing_modifiers` m
LEFT JOIN `axs_pay_pricing_modifiers_segments` s ON m.id = s.modifier_id
WHERE segment = 'groups' AND group_id in (1) AND enabled = 1EXPLAIN ei ole mahdollista kyselyssä: SELECT m.*
FROM `axs_pay_pricing_modifiers` m
LEFT JOIN `axs_pay_pricing_modifiers_segments` s ON m.id = s.modifier_id
WHERE segment = 'groups' AND group_id in (1) AND enabled = 1
Status Duration starting 0.04 ms Executing hook on transaction 0.01 ms starting 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.01 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.02 ms executing 0.02 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms
# Soittaja Tiedoston ja rivin numero 21 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172120 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/axslibs/pricingmodifiers.php:35919 AxsPricingModifiers::getUsersPricingModifiers() Copy JROOT/libraries/axslibs/pricingmodifiers.php:8118 AxsPricingModifiers::getUserCourseModifiers() Copy JROOT/components/com_splms/views/course/tmpl/dual.php:20917 include_once Copy JROOT/components/com_splms/views/course/tmpl/dual.php Copy JROOT/components/com_splms/views/course/tmpl/default.php:1616 include Copy JROOT/components/com_splms/views/course/tmpl/default.php Copy JROOT/libraries/fof/view/view.php:44215 FOFView->loadAnyTemplate() Copy JROOT/libraries/fof/view/view.php:84314 FOFView->loadTemplate() Copy JROOT/libraries/fof/view/view.php:47413 FOFView->display() Copy JROOT/libraries/fof/view/raw.php:12812 FOFViewRaw->display() Copy JROOT/components/com_splms/views/course/view.html.php:6911 SplmsViewCourse->display() Copy JROOT/libraries/fof/controller/controller.php:112810 FOFController->display() Copy JROOT/libraries/fof/controller/controller.php:12219 FOFController->read() Copy JROOT/libraries/fof/controller/controller.php:9708 FOFController->execute() Copy JROOT/libraries/fof/dispatcher/dispatcher.php:3287 FOFDispatcher->dispatch() Copy JROOT/components/com_splms/splms.php:356 require_once Copy JROOT/components/com_splms/splms.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
Kyselyaika: 1.08 ms Viimeisen kyselyn jälkeen: 1.40 ms Kyselymuisti: 0.026 MB Muisti ennen kyselyä: 20.667 MB Palautetut rivit: 0
SELECT *
FROM `ratings_post`
WHERE `rating_id`= 'course_7'EXPLAIN ei ole mahdollista kyselyssä: SELECT *
FROM `ratings_post`
WHERE `rating_id`='course_7'
Status Duration starting 0.03 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.01 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.01 ms executing 0.02 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms
# Soittaja Tiedoston ja rivin numero 20 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172119 JDatabaseDriver->loadObjectList() Copy JROOT/components/shared/controllers/rating.php:2918 display_ratings() Copy JROOT/components/com_splms/views/course/tmpl/dual.php:41017 include_once Copy JROOT/components/com_splms/views/course/tmpl/dual.php Copy JROOT/components/com_splms/views/course/tmpl/default.php:1616 include Copy JROOT/components/com_splms/views/course/tmpl/default.php Copy JROOT/libraries/fof/view/view.php:44215 FOFView->loadAnyTemplate() Copy JROOT/libraries/fof/view/view.php:84314 FOFView->loadTemplate() Copy JROOT/libraries/fof/view/view.php:47413 FOFView->display() Copy JROOT/libraries/fof/view/raw.php:12812 FOFViewRaw->display() Copy JROOT/components/com_splms/views/course/view.html.php:6911 SplmsViewCourse->display() Copy JROOT/libraries/fof/controller/controller.php:112810 FOFController->display() Copy JROOT/libraries/fof/controller/controller.php:12219 FOFController->read() Copy JROOT/libraries/fof/controller/controller.php:9708 FOFController->execute() Copy JROOT/libraries/fof/dispatcher/dispatcher.php:3287 FOFDispatcher->dispatch() Copy JROOT/components/com_splms/splms.php:356 require_once Copy JROOT/components/com_splms/splms.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
Kyselyaika: 1.12 ms Viimeisen kyselyn jälkeen: 1.84 ms Kyselymuisti: 0.026 MB Muisti ennen kyselyä: 20.913 MB Palautetut rivit: 0
SELECT parent_id
FROM axs_learning_path_map
WHERE item_id = 7 AND item_type = 'course'EXPLAIN ei ole mahdollista kyselyssä: SELECT parent_id
FROM axs_learning_path_map
WHERE item_id = 7 AND item_type = 'course'
Status Duration starting 0.03 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.00 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.02 ms executing 0.02 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms
# Soittaja Tiedoston ja rivin numero 20 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:157019 JDatabaseDriver->loadColumn() Copy JROOT/libraries/axslibs/learningPaths.php:87218 AxsLearningPaths::getLearningPathsByCourseID() Copy JROOT/components/com_splms/views/course/tmpl/dual.php:140217 include_once Copy JROOT/components/com_splms/views/course/tmpl/dual.php Copy JROOT/components/com_splms/views/course/tmpl/default.php:1616 include Copy JROOT/components/com_splms/views/course/tmpl/default.php Copy JROOT/libraries/fof/view/view.php:44215 FOFView->loadAnyTemplate() Copy JROOT/libraries/fof/view/view.php:84314 FOFView->loadTemplate() Copy JROOT/libraries/fof/view/view.php:47413 FOFView->display() Copy JROOT/libraries/fof/view/raw.php:12812 FOFViewRaw->display() Copy JROOT/components/com_splms/views/course/view.html.php:6911 SplmsViewCourse->display() Copy JROOT/libraries/fof/controller/controller.php:112810 FOFController->display() Copy JROOT/libraries/fof/controller/controller.php:12219 FOFController->read() Copy JROOT/libraries/fof/controller/controller.php:9708 FOFController->execute() Copy JROOT/libraries/fof/dispatcher/dispatcher.php:3287 FOFDispatcher->dispatch() Copy JROOT/components/com_splms/splms.php:356 require_once Copy JROOT/components/com_splms/splms.php Copy JROOT/libraries/cms/component/helper.php:3895 JComponentHelper::executeComponent() Copy JROOT/libraries/cms/component/helper.php:3644 JComponentHelper::renderComponent() Copy JROOT/libraries/cms/application/site.php:1913 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
Kyselyaika: 1.41 ms Viimeisen kyselyn jälkeen: 2.30 ms Kyselymuisti: 0.021 MB Muisti ennen kyselyä: 20.861 MB Palautetut rivit: 1
SELECT language,id
FROM `joom_menu `
WHERE home = 1 AND published = 1 AND client_id = 0EXPLAIN ei ole mahdollista kyselyssä: 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.00 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.00 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.02 ms executing 0.29 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms
# Soittaja Tiedoston ja rivin numero 10 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:17219 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/cms/language/multilang.php:1068 JLanguageMultilang::getSiteHomePages() Copy JROOT/plugins/system/languagefilter/languagefilter.php:7297 PlgSystemLanguageFilter->onAfterDispatch() Copy JROOT/libraries/joomla/event/event.php:706 JEvent->update() Copy JROOT/libraries/joomla/event/dispatcher.php:1605 JEventDispatcher->trigger() Copy JROOT/libraries/joomla/application/base.php:1064 JApplicationBase->triggerEvent() Copy JROOT/libraries/cms/application/site.php:1963 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
Kyselyaika: 1.25 ms Viimeisen kyselyn jälkeen: 2.67 ms Kyselymuisti: 0.022 MB Muisti ennen kyselyä: 21.157 MB Palautetut rivit: 1
SELECT *
FROM `currency`
WHERE `base_currency`= 1 LIMIT 1EXPLAIN ei ole mahdollista kyselyssä: SELECT *
FROM `currency`
WHERE `base_currency`=1 LIMIT 1
Status Duration starting 0.05 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.02 ms executing 0.13 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms
# Soittaja Tiedoston ja rivin numero 12 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:168211 JDatabaseDriver->loadObject() Copy JROOT/libraries/axslibs/currency.php:8410 AxsCurrency->getBaseCurrency() Copy JROOT/libraries/axslibs/currency.php:229 AxsCurrency->__construct() Copy JROOT/templates/axs/home.php:208 include Copy JROOT/templates/axs/home.php Copy JROOT/templates/axs/index.php:597 require Copy JROOT/templates/axs/index.php Copy JROOT/libraries/joomla/document/html.php:6536 JDocumentHtml->_loadTemplate() Copy JROOT/libraries/joomla/document/html.php:7155 JDocumentHtml->_fetchTemplate() Copy JROOT/libraries/joomla/document/html.php:5304 JDocumentHtml->parse() Copy JROOT/libraries/cms/application/cms.php:11733 JApplicationCms->render() Copy JROOT/libraries/cms/application/site.php:7822 JApplicationSite->render() Copy JROOT/libraries/cms/application/cms.php:2711 JApplicationCms->execute() Copy JROOT/index.php:72
Kyselyaika: 1.09 ms Viimeisen kyselyn jälkeen: 0.10 ms Kyselymuisti: 0.023 MB Muisti ennen kyselyä: 21.163 MB Palautetut rivit: 10
SELECT * FROM axs_fonts WHERE enabled = 1EXPLAIN ei ole mahdollista kyselyssä: SELECT * FROM axs_fonts WHERE enabled = 1
Status Duration starting 0.03 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms executing 0.04 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms
# Soittaja Tiedoston ja rivin numero 11 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172110 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/axslibs/fonts.php:349 AxsFonts::getFonts() Copy JROOT/templates/axs/home.php:938 include Copy JROOT/templates/axs/home.php Copy JROOT/templates/axs/index.php:597 require Copy JROOT/templates/axs/index.php Copy JROOT/libraries/joomla/document/html.php:6536 JDocumentHtml->_loadTemplate() Copy JROOT/libraries/joomla/document/html.php:7155 JDocumentHtml->_fetchTemplate() Copy JROOT/libraries/joomla/document/html.php:5304 JDocumentHtml->parse() Copy JROOT/libraries/cms/application/cms.php:11733 JApplicationCms->render() Copy JROOT/libraries/cms/application/site.php:7822 JApplicationSite->render() Copy JROOT/libraries/cms/application/cms.php:2711 JApplicationCms->execute() Copy JROOT/index.php:72
Kyselyaika: 1.08 ms Viimeisen kyselyn jälkeen: 0.19 ms Kyselymuisti: 0.022 MB Muisti ennen kyselyä: 21.199 MB Palautetut rivit: 0
SELECT *
FROM accessibility_images
WHERE `path`= 'images/pDJC5BxLjAW4jMgmh4ZjVUqCNDU3NDQ2OTkwOTMw/graphics/blue-logo.png' AND enabled= 1EXPLAIN ei ole mahdollista kyselyssä: SELECT *
FROM accessibility_images
WHERE `path`='images/pDJC5BxLjAW4jMgmh4ZjVUqCNDU3NDQ2OTkwOTMw/graphics/blue-logo.png' AND enabled= 1
Status Duration starting 0.03 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.01 ms System lock 0.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
# Soittaja Tiedoston ja rivin numero 12 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:168211 JDatabaseDriver->loadObject() Copy JROOT/libraries/axslibs/accessibility.php:4210 AxsAccessibility::query() Copy JROOT/libraries/axslibs/accessibility.php:499 AxsAccessibility::image() Copy JROOT/templates/axs/home.php:7998 include Copy JROOT/templates/axs/home.php Copy JROOT/templates/axs/index.php:597 require Copy JROOT/templates/axs/index.php Copy JROOT/libraries/joomla/document/html.php:6536 JDocumentHtml->_loadTemplate() Copy JROOT/libraries/joomla/document/html.php:7155 JDocumentHtml->_fetchTemplate() Copy JROOT/libraries/joomla/document/html.php:5304 JDocumentHtml->parse() Copy JROOT/libraries/cms/application/cms.php:11733 JApplicationCms->render() Copy JROOT/libraries/cms/application/site.php:7822 JApplicationSite->render() Copy JROOT/libraries/cms/application/cms.php:2711 JApplicationCms->execute() Copy JROOT/index.php:72
Kyselyaika: 1.20 ms Viimeisen kyselyn jälkeen: 1.57 ms Kyselymuisti: 0.027 MB Muisti ennen kyselyä: 21.260 MB Palautetut rivit: 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 ei ole mahdollista kyselyssä: 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.07 ms Executing hook on transaction 0.01 ms starting 0.00 ms checking permissions 0.00 ms Opening tables 0.05 ms init 0.01 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.02 ms preparing 0.02 ms executing 0.03 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms
# Soittaja Tiedoston ja rivin numero 11 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172110 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/axslibs/notifications.php:179 AxsNotifications::loadNotifications() Copy JROOT/templates/axs/home.php:17888 include Copy JROOT/templates/axs/home.php Copy JROOT/templates/axs/index.php:597 require Copy JROOT/templates/axs/index.php Copy JROOT/libraries/joomla/document/html.php:6536 JDocumentHtml->_loadTemplate() Copy JROOT/libraries/joomla/document/html.php:7155 JDocumentHtml->_fetchTemplate() Copy JROOT/libraries/joomla/document/html.php:5304 JDocumentHtml->parse() Copy JROOT/libraries/cms/application/cms.php:11733 JApplicationCms->render() Copy JROOT/libraries/cms/application/site.php:7822 JApplicationSite->render() Copy JROOT/libraries/cms/application/cms.php:2711 JApplicationCms->execute() Copy JROOT/index.php:72
Kyselyaika: 1.10 ms Viimeisen kyselyn jälkeen: 4.12 ms Kyselymuisti: 0.026 MB Muisti ennen kyselyä: 21.477 MB Palautetut rivit: 0
SELECT *
FROM joom_easyblog_configs
WHERE `name` = 'config'EXPLAIN ei ole mahdollista kyselyssä: SELECT *
FROM joom_easyblog_configs
WHERE `name` = 'config'
Status Duration starting 0.04 ms Executing hook on transaction 0.01 ms starting 0.00 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.02 ms executing 0.02 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms
# Soittaja Tiedoston ja rivin numero 22 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:148521 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:11903 JApplicationCms->render() Copy JROOT/libraries/cms/application/site.php:7822 JApplicationSite->render() Copy JROOT/libraries/cms/application/cms.php:2711 JApplicationCms->execute() Copy JROOT/index.php:72
Kyselyaika: 2.03 ms Viimeisen kyselyn jälkeen: 0.16 ms Kyselymuisti: 0.027 MB Muisti ennen kyselyä: 21.530 MB Palautetut rivit: 1
SELECT * FROM joom_extensions WHERE name= 'com_media'EXPLAIN ei ole mahdollista kyselyssä: SELECT * FROM joom_extensions WHERE name='com_media'
Status Duration starting 0.03 ms Executing hook on transaction 0.01 ms starting 0.00 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.01 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms executing 0.96 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms
# Soittaja Tiedoston ja rivin numero 23 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:168222 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:11903 JApplicationCms->render() Copy JROOT/libraries/cms/application/site.php:7822 JApplicationSite->render() Copy JROOT/libraries/cms/application/cms.php:2711 JApplicationCms->execute() Copy JROOT/index.php:72
Kyselyaika: 1.12 ms Viimeisen kyselyn jälkeen: 1.65 ms Kyselymuisti: 0.028 MB Muisti ennen kyselyä: 21.730 MB Palautetut rivit: 1
SELECT * FROM joom_kunena_configuration WHERE id= 1EXPLAIN ei ole mahdollista kyselyssä: SELECT * FROM joom_kunena_configuration WHERE id=1
Status Duration starting 0.03 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.01 ms executing 0.01 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms
# Soittaja Tiedoston ja rivin numero 28 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:148527 JDatabaseDriver->loadAssoc() Copy JROOT/libraries/kunena/config.php:130626 KunenaConfig->load() Copy JROOT/libraries/kunena/config.php:123925 KunenaConfig::getInstance() Copy JROOT/libraries/kunena/factory.php:2824 KunenaFactory::getConfig() Copy JROOT/libraries/kunena/route/route.php:48023 KunenaRoute::initialize() Copy JROOT/libraries/kunena/route/route.php:1722 include Copy JROOT/libraries/kunena/route/route.php Copy JROOT/libraries/loader.php:71621 JLoader::_load() Copy JROOT/libraries/loader.php:67120 JLoader::_autoload() Sama kuin soitto alla olevalla rivillä. 19 spl_autoload_call() Copy JROOT/components/com_kunena/router.php:3818 KunenaBuildRoute() Copy JROOT/libraries/cms/component/router/legacy.php:6817 JComponentRouterLegacy->build() Copy JROOT/libraries/cms/router/site.php:51916 JRouterSite->buildSefRoute() Copy JROOT/libraries/cms/router/site.php:48915 JRouterSite->_buildSefRoute() Copy JROOT/libraries/cms/router/router.php:28214 JRouter->build() Copy JROOT/libraries/cms/router/site.php:14913 JRouterSite->build() Copy JROOT/libraries/joomla/application/route.php:6212 JRoute::_() Copy JROOT/modules/mod_defaultmenu/helper.php:13411 ModDefaultHelper::getList() Copy JROOT/modules/mod_defaultmenu/mod_defaultmenu.php:1510 include Copy JROOT/modules/mod_defaultmenu/mod_defaultmenu.php Copy JROOT/libraries/cms/module/helper.php:1989 JModuleHelper::renderModule() Copy JROOT/libraries/joomla/document/renderer/html/module.php:938 JDocumentRendererHtmlModule->render() Copy JROOT/libraries/joomla/document/renderer/html/modules.php:427 JDocumentRendererHtmlModules->render() Copy JROOT/libraries/joomla/document/html.php:4866 JDocumentHtml->getBuffer() Copy JROOT/libraries/joomla/document/html.php:7775 JDocumentHtml->_renderTemplate() Copy JROOT/libraries/joomla/document/html.php:5524 JDocumentHtml->render() Copy JROOT/libraries/cms/application/cms.php:11903 JApplicationCms->render() Copy JROOT/libraries/cms/application/site.php:7822 JApplicationSite->render() Copy JROOT/libraries/cms/application/cms.php:2711 JApplicationCms->execute() Copy JROOT/index.php:72
Kyselyaika: 1.13 ms Viimeisen kyselyn jälkeen: 2.83 ms Kyselymuisti: 0.024 MB Muisti ennen kyselyä: 21.941 MB Palautetut rivit: 1
SELECT special_characters FROM joom_languages WHERE sef = 'fi' LIMIT 1EXPLAIN ei ole mahdollista kyselyssä: SELECT special_characters FROM joom_languages WHERE sef = 'fi' LIMIT 1
Status Duration starting 0.04 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.01 ms executing 0.01 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms
# Soittaja Tiedoston ja rivin numero 16 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:168215 JDatabaseDriver->loadObject() Copy JROOT/libraries/axslibs/language.php:30814 AxsLanguage::getSpecialCharacters() Copy JROOT/libraries/axslibs/language.php:2613 AxsLanguage::translate() Copy JROOT/modules/mod_defaultmenu/tmpl/default_component.php:2112 require Copy JROOT/modules/mod_defaultmenu/tmpl/default_component.php Copy JROOT/modules/mod_defaultmenu/tmpl/default.php:7211 require Copy JROOT/modules/mod_defaultmenu/tmpl/default.php Copy JROOT/modules/mod_defaultmenu/mod_defaultmenu.php:2510 include Copy JROOT/modules/mod_defaultmenu/mod_defaultmenu.php Copy JROOT/libraries/cms/module/helper.php:1989 JModuleHelper::renderModule() Copy JROOT/libraries/joomla/document/renderer/html/module.php:938 JDocumentRendererHtmlModule->render() Copy JROOT/libraries/joomla/document/renderer/html/modules.php:427 JDocumentRendererHtmlModules->render() Copy JROOT/libraries/joomla/document/html.php:4866 JDocumentHtml->getBuffer() Copy JROOT/libraries/joomla/document/html.php:7775 JDocumentHtml->_renderTemplate() Copy JROOT/libraries/joomla/document/html.php:5524 JDocumentHtml->render() Copy JROOT/libraries/cms/application/cms.php:11903 JApplicationCms->render() Copy JROOT/libraries/cms/application/site.php:7822 JApplicationSite->render() Copy JROOT/libraries/cms/application/cms.php:2711 JApplicationCms->execute() Copy JROOT/index.php:72
Kyselyaika: 1.16 ms Viimeisen kyselyn jälkeen: 0.04 ms Kyselymuisti: 0.025 MB Muisti ennen kyselyä: 21.951 MB Palautetut rivit: 13
SELECT *
FROM axs_translations
WHERE language_tag = 'fi'EXPLAIN ei ole mahdollista kyselyssä: SELECT *
FROM axs_translations
WHERE language_tag = 'fi'
Status Duration starting 0.03 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.02 ms executing 0.06 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms
# Soittaja Tiedoston ja rivin numero 16 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:152615 JDatabaseDriver->loadAssocList() Copy JROOT/libraries/axslibs/language.php:15014 AxsLanguage::getTranslationMap() Copy JROOT/libraries/axslibs/language.php:3913 AxsLanguage::translate() Copy JROOT/modules/mod_defaultmenu/tmpl/default_component.php:2112 require Copy JROOT/modules/mod_defaultmenu/tmpl/default_component.php Copy JROOT/modules/mod_defaultmenu/tmpl/default.php:7211 require Copy JROOT/modules/mod_defaultmenu/tmpl/default.php Copy JROOT/modules/mod_defaultmenu/mod_defaultmenu.php:2510 include Copy JROOT/modules/mod_defaultmenu/mod_defaultmenu.php Copy JROOT/libraries/cms/module/helper.php:1989 JModuleHelper::renderModule() Copy JROOT/libraries/joomla/document/renderer/html/module.php:938 JDocumentRendererHtmlModule->render() Copy JROOT/libraries/joomla/document/renderer/html/modules.php:427 JDocumentRendererHtmlModules->render() Copy JROOT/libraries/joomla/document/html.php:4866 JDocumentHtml->getBuffer() Copy JROOT/libraries/joomla/document/html.php:7775 JDocumentHtml->_renderTemplate() Copy JROOT/libraries/joomla/document/html.php:5524 JDocumentHtml->render() Copy JROOT/libraries/cms/application/cms.php:11903 JApplicationCms->render() Copy JROOT/libraries/cms/application/site.php:7822 JApplicationSite->render() Copy JROOT/libraries/cms/application/cms.php:2711 JApplicationCms->execute() Copy JROOT/index.php:72
Kyselyaika: 1.20 ms Viimeisen kyselyn jälkeen: 2.38 ms Kyselymuisti: 0.023 MB Muisti ennen kyselyä: 22.009 MB Palautetut rivit: 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 ei ole mahdollista kyselyssä: SELECT `c2`.`language`,`c2`.`id`
FROM `joom_menu` AS `c`
INNER JOIN `joom_associations` AS `a` ON a.id = c.`id` AND a.context='com_menus.item'
INNER JOIN `joom_associations` AS `a2` ON a.key = a2.key
INNER JOIN `joom_menu` AS `c2` ON a2.id = c2.`id`
WHERE c.id = 864
Status Duration starting 0.06 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.04 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.09 ms executing 0.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
# Soittaja Tiedoston ja rivin numero 15 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172114 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/cms/language/associations.php:10113 JLanguageAssociations::getAssociations() Copy JROOT/administrator/components/com_menus/helpers/menus.php:31312 MenusHelper::getAssociations() Copy JROOT/modules/mod_language_selector/tmpl/default.php:9111 require Copy JROOT/modules/mod_language_selector/tmpl/default.php Copy JROOT/modules/mod_language_selector/mod_language_selector.php:410 include Copy JROOT/modules/mod_language_selector/mod_language_selector.php Copy JROOT/libraries/cms/module/helper.php:1989 JModuleHelper::renderModule() Copy JROOT/libraries/joomla/document/renderer/html/module.php:938 JDocumentRendererHtmlModule->render() Copy JROOT/libraries/joomla/document/renderer/html/modules.php:427 JDocumentRendererHtmlModules->render() Copy JROOT/libraries/joomla/document/html.php:4866 JDocumentHtml->getBuffer() Copy JROOT/libraries/joomla/document/html.php:7775 JDocumentHtml->_renderTemplate() Copy JROOT/libraries/joomla/document/html.php:5524 JDocumentHtml->render() Copy JROOT/libraries/cms/application/cms.php:11903 JApplicationCms->render() Copy JROOT/libraries/cms/application/site.php:7822 JApplicationSite->render() Copy JROOT/libraries/cms/application/cms.php:2711 JApplicationCms->execute() Copy JROOT/index.php:72
6 × SELECT m.* FROM `axs_pay_pricing_modifiers` m LEFT JOIN `axs_pay_pricing_modifiers_segments` s ON m.id = s.modifier_id 5 × SELECT * FROM `joom_splms_courses ` 4 × SELECT * FROM `joom_splms_lessons ` 2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `joom_extensions ` 2 × SELECT * FROM joom_languages 2 × SELECT * FROM `joom_splms_lesson_status ` AS s INNER JOIN `joom_splms_lessons `AS l ON l.splms_lesson_id = s.lesson_id 1 × SELECT * FROM `ratings_post` 1 × SELECT sef FROM joom_languages 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_course_purchases` 1 × SELECT `id` FROM `axs_pay_subscriptions` 1 × SELECT progress.user_id FROM `joom_splms_course_progress ` AS `progress` LEFT JOIN `joom_community_fields_values ` AS ` values` ON (`progress`.`user_id`= ` values`.`user_id`) RIGHT JOIN `joom_users ` AS `user` ON (`progress`.`user_id`= `user`.`id`) 1 × SELECT * FROM `joom_splms_coursescategories ` 1 × SELECT `session_id` FROM `joom_session ` 1 × SELECT * FROM `joom_splms_accuratethoughts ` 1 × SELECT language,id FROM `joom_menu ` 1 × SELECT * FROM `currency` 1 × SELECT * FROM axs_fonts 1 × SELECT * FROM accessibility_images 1 × SELECT * FROM axs_notifications 1 × SELECT * FROM joom_easyblog_configs 1 × SELECT * FROM joom_extensions 1 × SELECT * FROM joom_kunena_configuration 1 × SELECT special_characters FROM joom_languages 1 × SELECT * FROM axs_translations 1 × SELECT parent_id FROM axs_learning_path_map 1 × SELECT event_id FROM joom_splms_courses_events ce LEFT JOIN joom_eb_events e ON e.id = ce.event_id 1 × SELECT `a`.`splms_quizresult_id`,`a`.`point`,`a`.`total_marks`,`a`.`splms_quizquestion_id`,`a`.`splms_course_id`,`b`.`title` AS `quiz_name`,`c`.`title` AS `course_name`,`c`.`slug` AS `course_slug` FROM `joom_splms_quizresults ` AS `a` LEFT JOIN `joom_splms_quizquestions ` AS `b` ON (`a`.`splms_quizquestion_id` = `b`.`splms_quizquestion_id`) LEFT JOIN `joom_splms_courses ` AS `c` ON (`a`.`splms_course_id` = `c`.`splms_course_id`) 1 × SELECT * FROM axs_payment_gateways 1 × SELECT id, rules FROM `joom_viewlevels 1 × SELECT b.id FROM joom_usergroups AS a LEFT JOIN joom_usergroups AS b ON b.lft <= a.lft AND b.rgt >= a.rgt 1 × SELECT `folder` AS `type`,`element` AS `name`,`params` FROM joom_extensions 1 × SELECT * FROM axs_domains 1 × SELECT `element`,`name`,`client_id`,`extension_id` FROM `joom_extensions ` 1 × SELECT * FROM `axs_brands` 1 × SELECT * FROM `axs_homepage_templates` 1 × SELECT * FROM `axs_dashboard_templates` 1 × SELECT * FROM axs_email_settings 1 × SELECT * FROM axs_integrations 1 × SELECT * FROM joom_splms_quizquestions 1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component FROM joom_menu AS m LEFT JOIN joom_extensions AS e ON m.component_id = e.extension_id 1 × SELECT `id`,`title` FROM `joom_usergroups ` 1 × SELECT `splms_course_id` FROM joom_splms_courses 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 joom_splms_courses .* FROM joom_splms_courses 1 × SELECT `id`,`name`,`rules`,`parent_id` FROM `joom_assets ` 1 × SELECT * FROM `cctransactions` 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`