Kyselyaika: 1.99 ms Kyselymuisti: 0.046 MB Muisti ennen kyselyä: 4.324 MB Palautetut rivit: 80
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `joom_extensions `
WHERE `type` = 'component'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE joom_extensions NULL ref extension extension 82 const 80 100.00 NULL
Status Duration starting 0.03 ms checking query cache for query 0.01 ms checking privileges on cached 0.00 ms checking permissions 0.10 ms checking permissions 0.02 ms Opening tables 0.02 ms init 0.03 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.09 ms preparing 0.02 ms executing 0.00 ms Sending data 0.28 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.04 ms cleaned up 0.01 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: 0.44 ms Viimeisen kyselyn jälkeen: 1.50 ms Kyselymuisti: 0.021 MB Muisti ennen kyselyä: 4.535 MB Palautetut rivit: 7
SELECT id, rules
FROM `joom_viewlevels `id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE joom_viewlevels NULL ALL NULL EI VOI KÄYTTÄÄ INDEKSIAVAinta NULL NULL 7 100.00 NULL
Status Duration starting 0.02 ms checking query cache for query 0.01 ms checking privileges on cached 0.00 ms checking permissions 0.02 ms sending cached result to clien 0.03 ms cleaned up 0.02 ms cleaning up 0.00 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: 0.36 ms Viimeisen kyselyn jälkeen: 0.05 ms Kyselymuisti: 0.021 MB Muisti ennen kyselyä: 4.547 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 = 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 SIMPLE b NULL range idx_usergroup_nested_set_lookup idx_usergroup_nested_set_lookup 4 NULL 1 100.00 Using where; Using index
Status Duration starting 0.01 ms checking query cache for query 0.01 ms checking privileges on cached 0.00 ms checking permissions 0.01 ms checking permissions 0.00 ms sending cached result to clien 0.02 ms cleaned up 0.01 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: 1.78 ms Viimeisen kyselyn jälkeen: 0.41 ms Kyselymuisti: 0.046 MB Muisti ennen kyselyä: 4.609 MB Palautetut rivit: 142
SELECT `folder` AS `type`,`element` AS `name`,`params`
FROM joom_extensions
WHERE enabled = 1 AND type = 'plugin' AND state IN (0,1) AND access IN (1,1)
ORDER BY orderingid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE joom_extensions NULL ref extension extension 82 const 277 0.40 Using index condition; Using where; Tiedostolajittelun käyttäminen
Status Duration starting 0.01 ms checking query cache for query 0.01 ms checking privileges on cached 0.00 ms checking permissions 0.09 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.04 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.07 ms preparing 0.02 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.01 ms Creating sort index 1.04 ms end 0.02 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.05 ms cleaned up 0.01 ms cleaning up 0.02 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: 0.82 ms Viimeisen kyselyn jälkeen: 9.04 ms Kyselymuisti: 0.024 MB Muisti ennen kyselyä: 5.517 MB Palautetut rivit: 1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `joom_extensions `
WHERE `type` = 'library' AND `element` = 'joomla'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE joom_extensions NULL ref element_clientid,element_folder_clientid,extension extension 484 const,const 1 100.00 NULL
Status Duration starting 0.03 ms checking query cache for query 0.01 ms checking privileges on cached 0.01 ms checking permissions 0.09 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.03 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.08 ms preparing 0.02 ms executing 0.00 ms Sending data 0.04 ms end 0.01 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.03 ms cleaned up 0.01 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:7619 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: 3.32 ms Viimeisen kyselyn jälkeen: 0.12 ms Kyselymuisti: 0.006 MB Muisti ennen kyselyä: 5.509 MB
UPDATE `joom_extensions `
SET `params` = '{\"mediaversion\":\"25cc93e55b08b76b3bb5c42536c20397\"}'
WHERE `type` = 'library' AND `element` = 'joomla'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 UPDATE joom_extensions NULL range element_clientid,element_folder_clientid,extension extension 484 const,const 1 100.00 Using where
Status Duration starting 0.06 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.02 ms System lock 0.06 ms updating 0.09 ms end 0.01 ms query end 0.05 ms closing tables 0.01 ms freeing items 0.01 ms delayed commit ok initiated 2.68 ms delayed commit ok done 0.03 ms cleaning up 0.01 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:7619 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: 0.52 ms Viimeisen kyselyn jälkeen: 13.36 ms Kyselymuisti: 0.029 MB Muisti ennen kyselyä: 8.001 MB Palautetut rivit: 19
SELECT *
FROM joom_languages
WHERE published= 1
ORDER BY ordering ASC id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE joom_languages NULL ALL NULL EI VOI KÄYTTÄÄ INDEKSIAVAinta NULL NULL 19 10.00 Using where; Tiedostolajittelun käyttäminen
Status Duration starting 0.04 ms checking query cache for query 0.01 ms checking privileges on cached 0.01 ms checking permissions 0.02 ms sending cached result to clien 0.03 ms cleaned up 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/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: 0.34 ms Viimeisen kyselyn jälkeen: 0.38 ms Kyselymuisti: 0.021 MB Muisti ennen kyselyä: 8.068 MB Palautetut rivit: 1
SELECT * FROM axs_domains WHERE domain = 'k8s.intg.tovuti.io'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE axs_domains NULL ALL NULL EI VOI KÄYTTÄÄ INDEKSIAVAinta NULL NULL 1 100.00 Using where
Status Duration starting 0.01 ms checking query cache for query 0.01 ms checking privileges on cached 0.00 ms checking permissions 0.01 ms sending cached result to clien 0.02 ms cleaned up 0.01 ms cleaning up 0.02 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:1538 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: 0.91 ms Viimeisen kyselyn jälkeen: 0.05 ms Kyselymuisti: 0.030 MB Muisti ennen kyselyä: 8.076 MB Palautetut rivit: 94
SELECT `element`,`name`,`client_id`,`extension_id`
FROM `joom_extensions `
WHERE `type` = 'language' AND `state` = 0 AND `enabled` = 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE joom_extensions NULL ref extension extension 82 const 98 1.00 Using where
Status Duration starting 0.01 ms checking query cache for query 0.08 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.03 ms System lock 0.02 ms optimizing 0.02 ms statistics 0.07 ms preparing 0.03 ms executing 0.00 ms Sending data 0.28 ms end 0.02 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaned up 0.01 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: 0.48 ms Viimeisen kyselyn jälkeen: 0.97 ms Kyselymuisti: 0.022 MB Muisti ennen kyselyä: 8.208 MB Palautetut rivit: 1
SELECT * FROM `axs_brands` WHERE language = 'en-GB ' AND (FIND_IN_SET ('k8s.intg.tovuti.io', domains) > 0) LIMIT 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE axs_brands NULL ALL NULL EI VOI KÄYTTÄÄ INDEKSIAVAinta NULL NULL 3 33.33 Using where
Status Duration starting 0.03 ms checking query cache for query 0.01 ms checking privileges on cached 0.01 ms checking permissions 0.02 ms sending cached result to clien 0.03 ms cleaned up 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: 0.39 ms Viimeisen kyselyn jälkeen: 0.05 ms Kyselymuisti: 0.030 MB Muisti ennen kyselyä: 8.230 MB Palautetut rivit: 19
SELECT * FROM joom_languages WHERE published = 1 ORDER BY `title`id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE joom_languages NULL ALL NULL EI VOI KÄYTTÄÄ INDEKSIAVAinta NULL NULL 19 10.00 Using where; Tiedostolajittelun käyttäminen
Status Duration starting 0.02 ms checking query cache for query 0.01 ms checking privileges on cached 0.00 ms checking permissions 0.02 ms sending cached result to clien 0.03 ms cleaned up 0.01 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:31212 AxsLanguage::getPublishedLanguages() Copy JROOT/libraries/axslibs/language.php:22111 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: 0.48 ms Viimeisen kyselyn jälkeen: 1.18 ms Kyselymuisti: 0.021 MB Muisti ennen kyselyä: 8.507 MB Palautetut rivit: 1
SELECT * FROM `axs_homepage_templates` WHERE id= '1'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE axs_homepage_templates NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL
Status Duration starting 0.02 ms checking query cache for query 0.01 ms checking privileges on cached 0.02 ms checking permissions 0.02 ms sending cached result to clien 0.03 ms cleaned up 0.01 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: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: 0.40 ms Viimeisen kyselyn jälkeen: 0.07 ms Kyselymuisti: 0.021 MB Muisti ennen kyselyä: 8.548 MB Palautetut rivit: 1
SELECT * FROM `axs_dashboard_templates` WHERE id= '2'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE axs_dashboard_templates NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL
Status Duration starting 0.02 ms checking query cache for query 0.01 ms checking privileges on cached 0.00 ms checking permissions 0.01 ms sending cached result to clien 0.04 ms cleaned up 0.01 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: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: 0.40 ms Viimeisen kyselyn jälkeen: 0.05 ms Kyselymuisti: 0.022 MB Muisti ennen kyselyä: 8.568 MB Palautetut rivit: 1
SELECT *
FROM axs_email_settings
WHERE id = '1'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE axs_email_settings NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL
Status Duration starting 0.02 ms checking query cache for query 0.01 ms checking privileges on cached 0.00 ms checking permissions 0.01 ms sending cached result to clien 0.03 ms cleaned up 0.01 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: 0.65 ms Viimeisen kyselyn jälkeen: 0.04 ms Kyselymuisti: 0.022 MB Muisti ennen kyselyä: 8.575 MB Palautetut rivit: 1
SELECT *
FROM axs_payment_gateways
WHERE id = '1'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE axs_payment_gateways NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL
Status Duration starting 0.02 ms checking query cache for query 0.01 ms checking privileges on cached 0.00 ms checking permissions 0.01 ms sending cached result to clien 0.03 ms cleaned up 0.01 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: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: 0.38 ms Viimeisen kyselyn jälkeen: 0.06 ms Kyselymuisti: 0.022 MB Muisti ennen kyselyä: 8.587 MB Palautetut rivit: 1
SELECT *
FROM axs_integrations
WHERE id = '1'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE axs_integrations NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL
Status Duration starting 0.02 ms checking query cache for query 0.02 ms checking privileges on cached 0.00 ms checking permissions 0.01 ms sending cached result to clien 0.02 ms cleaned up 0.01 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: 1.75 ms Viimeisen kyselyn jälkeen: 9.97 ms Kyselymuisti: 0.102 MB Muisti ennen kyselyä: 10.091 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.lftid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL ref idx_client_id_parent_id_alias_language idx_client_id_parent_id_alias_language 1 const 128 3.33 Using index condition; Using where; Tiedostolajittelun käyttäminen 1 SIMPLE e NULL eq_ref PRIMARY PRIMARY 4 root_db.m.component_id 1 100.00 Using where
Status Duration starting 0.03 ms checking query cache for query 0.10 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.04 ms System lock 0.02 ms optimizing 0.02 ms statistics 0.07 ms preparing 0.03 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.01 ms Creating sort index 0.90 ms end 0.06 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaned up 0.01 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: 1.03 ms Viimeisen kyselyn jälkeen: 14.72 ms Kyselymuisti: 0.028 MB Muisti ennen kyselyä: 12.375 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.06 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.18 ms init 0.01 ms System lock 0.01 ms optimizing 0.00 ms statistics 0.01 ms preparing 0.02 ms executing 0.01 ms Opening tables 0.02 ms checking permissions 0.03 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.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 Sending data 0.05 ms end 0.00 ms query end 0.01 ms closing tables 0.00 ms removing tmp table 0.03 ms closing tables 0.01 ms freeing items 0.03 ms cleaned up 0.01 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/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: 0.37 ms Viimeisen kyselyn jälkeen: 0.28 ms Kyselymuisti: 0.022 MB Muisti ennen kyselyä: 12.419 MB Palautetut rivit: 1
SELECT `id`,`title`
FROM `joom_usergroups `
WHERE `id` = 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE joom_usergroups NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL
Status Duration starting 0.01 ms checking query cache for query 0.01 ms checking privileges on cached 0.00 ms checking permissions 0.02 ms sending cached result to clien 0.02 ms cleaned up 0.01 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: 0.41 ms Viimeisen kyselyn jälkeen: 3.85 ms Kyselymuisti: 0.019 MB Muisti ennen kyselyä: 12.986 MB Palautetut rivit: 0
SELECT params
FROM axs_user_settings
WHERE id = 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE NULL NULL NULL NULL EI VOI KÄYTTÄÄ INDEKSIAVAinta NULL NULL NULL NULL no matching row in const table
Status Duration starting 0.02 ms checking query cache for query 0.01 ms checking privileges on cached 0.00 ms checking permissions 0.02 ms sending cached result to clien 0.03 ms cleaned up 0.02 ms cleaning up 0.00 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:6665 AxsUser::getGlobalUserSettings() Copy JROOT/libraries/axslibs/security.php:334 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: 0.41 ms Viimeisen kyselyn jälkeen: 2.00 ms Kyselymuisti: 0.019 MB Muisti ennen kyselyä: 13.314 MB Palautetut rivit: 0
SELECT *
FROM `joom_users `
WHERE `id` = 0id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE NULL NULL NULL NULL EI VOI KÄYTTÄÄ INDEKSIAVAinta NULL NULL NULL NULL no matching row in const table
Status Duration starting 0.02 ms checking query cache for query 0.01 ms checking privileges on cached 0.00 ms checking permissions 0.02 ms sending cached result to clien 0.02 ms cleaned up 0.02 ms cleaning up 0.00 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: 0.86 ms Viimeisen kyselyn jälkeen: 0.15 ms Kyselymuisti: 0.019 MB Muisti ennen kyselyä: 13.341 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 = 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE s NULL ALL idx_template EI VOI KÄYTTÄÄ INDEKSIAVAinta NULL NULL 9 11.11 Using where 1 SIMPLE e NULL ref element_clientid,element_folder_clientid,extension element_clientid 403 root_db.s.template,const 1 4.07 Using index condition; Using where
Status Duration starting 0.02 ms checking query cache for query 0.08 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.03 ms System lock 0.02 ms optimizing 0.02 ms statistics 0.08 ms preparing 0.03 ms executing 0.00 ms Sending data 0.14 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaned up 0.01 ms cleaning up 0.00 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: 0.45 ms Viimeisen kyselyn jälkeen: 3.07 ms Kyselymuisti: 0.030 MB Muisti ennen kyselyä: 13.796 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` = 0id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE joom_assets NULL ALL idx_asset_name,idx_parent_id EI VOI KÄYTTÄÄ INDEKSIAVAinta NULL NULL 264 54.55 Using where
Status Duration starting 0.02 ms checking query cache for query 0.01 ms checking privileges on cached 0.00 ms checking permissions 0.02 ms sending cached result to clien 0.03 ms cleaned up 0.01 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/joomla/access/access.php:42719 JAccess::preloadComponents() Copy JROOT/libraries/joomla/access/access.php:21118 JAccess::preload() Copy JROOT/libraries/joomla/access/access.php:53017 JAccess::getAssetRules() Copy JROOT/libraries/joomla/access/access.php:18116 JAccess::check() Copy JROOT/libraries/joomla/user/user.php:39315 JUser->authorise() Copy JROOT/components/com_content/models/articles.php:11114 ContentModelArticles->populateState() Copy JROOT/components/com_content/models/featured.php:4213 ContentModelFeatured->populateState() Copy JROOT/libraries/legacy/model/legacy.php:44012 JModelLegacy->getState() Copy JROOT/libraries/legacy/view/legacy.php:42211 JViewLegacy->get() Copy JROOT/components/com_content/views/featured/view.html.php:5410 ContentViewFeatured->display() Copy JROOT/libraries/legacy/controller/legacy.php:6719 JControllerLegacy->display() Copy JROOT/components/com_content/controller.php:1138 ContentController->display() Copy JROOT/libraries/legacy/controller/legacy.php:7097 JControllerLegacy->execute() Copy JROOT/components/com_content/content.php:396 require_once Copy JROOT/components/com_content/content.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.36 ms Viimeisen kyselyn jälkeen: 0.71 ms Kyselymuisti: 0.024 MB Muisti ennen kyselyä: 13.942 MB Palautetut rivit: 0
SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.catid, a.created, a.created_by, a.created_by_alias, CASE WHEN c.published = 2 AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state, CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name, CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH (a.fulltext) AS readmore,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE (NULLIF (ROUND (v.rating_sum / v.rating_count, 0), 0), 0) AS rating,
COALESCE (NULLIF (v.rating_count, 0), 0) as rating_count
FROM joom_content AS a
LEFT JOIN joom_categories AS c ON c.id = a.catid
LEFT JOIN joom_users AS ua ON ua.id = a.created_by
LEFT JOIN joom_users AS uam ON uam.id = a.modified_by
LEFT JOIN joom_categories as parent ON parent.id = c.parent_id
LEFT JOIN joom_content_rating AS v ON a.id = v.content_id
WHERE a.featured = 1 AND a.access IN (1,1) AND c.access IN (1,1) AND c.published = 1 AND a.state = 1 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-07-06 23:04:56') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-07-06 23:04:56') AND a.language in ('fi-FI ','* ')
ORDER BY c.lft, CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END DESC , a.created DESC LIMIT 9id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL ref idx_access,idx_catid,idx_featured_catid,idx_language,idx_state idx_featured_catid 1 const 1 100.00 Using where; Using temporary; Tiedostolajittelun käyttäminen 1 SIMPLE c NULL eq_ref PRIMARY,idx_access PRIMARY 4 root_db.a.catid 1 10.00 Using where 1 SIMPLE ua NULL eq_ref PRIMARY PRIMARY 4 root_db.a.created_by 1 100.00 Using where 1 SIMPLE uam NULL eq_ref PRIMARY PRIMARY 4 root_db.a.modified_by 1 100.00 Using where 1 SIMPLE parent NULL eq_ref PRIMARY PRIMARY 4 root_db.c.parent_id 1 100.00 Using where 1 SIMPLE v NULL eq_ref PRIMARY PRIMARY 4 root_db.a.id 1 100.00 Using where
Status Duration starting 0.02 ms checking query cache for query 0.20 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.10 ms System lock 0.04 ms optimizing 0.03 ms statistics 0.13 ms preparing 0.04 ms Creating tmp table 0.06 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.18 ms Creating sort index 0.04 ms end 0.01 ms query end 0.01 ms removing tmp table 0.03 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.05 ms storing result in query cache 0.01 ms cleaned up 0.01 ms cleaning up 0.01 ms
# Soittaja Tiedoston ja rivin numero 17 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172116 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/legacy/model/legacy.php:30715 JModelLegacy->_getList() Copy JROOT/libraries/legacy/model/list.php:18914 JModelList->getItems() Copy JROOT/components/com_content/models/articles.php:53313 ContentModelArticles->getItems() Copy JROOT/components/com_content/models/featured.php:10012 ContentModelFeatured->getItems() Copy JROOT/libraries/legacy/view/legacy.php:42211 JViewLegacy->get() Copy JROOT/components/com_content/views/featured/view.html.php:5510 ContentViewFeatured->display() Copy JROOT/libraries/legacy/controller/legacy.php:6719 JControllerLegacy->display() Copy JROOT/components/com_content/controller.php:1138 ContentController->display() Copy JROOT/libraries/legacy/controller/legacy.php:7097 JControllerLegacy->execute() Copy JROOT/components/com_content/content.php:396 require_once Copy JROOT/components/com_content/content.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: 0.78 ms Viimeisen kyselyn jälkeen: 0.59 ms Kyselymuisti: 0.023 MB Muisti ennen kyselyä: 14.035 MB Palautetut rivit: 1
SELECT COUNT (* )
FROM joom_content AS a
LEFT JOIN joom_categories AS c ON c.id = a.catid
LEFT JOIN joom_users AS ua ON ua.id = a.created_by
LEFT JOIN joom_users AS uam ON uam.id = a.modified_by
LEFT JOIN joom_categories as parent ON parent.id = c.parent_id
LEFT JOIN joom_content_rating AS v ON a.id = v.content_id
WHERE a.featured = 1 AND a.access IN (1,1) AND c.access IN (1,1) AND c.published = 1 AND a.state = 1 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-07-06 23:04:56') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-07-06 23:04:56') AND a.language in ('fi-FI ','* ')id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL ref idx_access,idx_catid,idx_featured_catid,idx_language,idx_state idx_featured_catid 1 const 1 100.00 Using where 1 SIMPLE c NULL eq_ref PRIMARY,idx_access PRIMARY 4 root_db.a.catid 1 10.00 Using where 1 SIMPLE ua NULL eq_ref PRIMARY PRIMARY 4 root_db.a.created_by 1 100.00 Using where; Using index 1 SIMPLE uam NULL eq_ref PRIMARY PRIMARY 4 root_db.a.modified_by 1 100.00 Using where; Using index 1 SIMPLE parent NULL eq_ref PRIMARY PRIMARY 4 root_db.c.parent_id 1 100.00 Using where; Using index 1 SIMPLE v NULL eq_ref PRIMARY PRIMARY 4 root_db.a.id 1 100.00 Using where; Using index
Status Duration starting 0.01 ms checking query cache for query 0.09 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.02 ms Opening tables 0.03 ms init 0.05 ms System lock 0.02 ms optimizing 0.02 ms statistics 0.10 ms preparing 0.03 ms executing 0.00 ms Sending data 0.02 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms storing result in query cache 0.01 ms cleaned up 0.01 ms cleaning up 0.01 ms
# Soittaja Tiedoston ja rivin numero 16 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:176015 JDatabaseDriver->loadResult() Copy JROOT/libraries/legacy/model/legacy.php:34014 JModelLegacy->_getListCount() Copy JROOT/libraries/legacy/model/list.php:28413 JModelList->getTotal() Copy JROOT/libraries/legacy/model/list.php:23412 JModelList->getPagination() Copy JROOT/libraries/legacy/view/legacy.php:42211 JViewLegacy->get() Copy JROOT/components/com_content/views/featured/view.html.php:5610 ContentViewFeatured->display() Copy JROOT/libraries/legacy/controller/legacy.php:6719 JControllerLegacy->display() Copy JROOT/components/com_content/controller.php:1138 ContentController->display() Copy JROOT/libraries/legacy/controller/legacy.php:7097 JControllerLegacy->execute() Copy JROOT/components/com_content/content.php:396 require_once Copy JROOT/components/com_content/content.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: 0.45 ms Viimeisen kyselyn jälkeen: 5.85 ms Kyselymuisti: 0.021 MB Muisti ennen kyselyä: 14.597 MB Palautetut rivit: 1
SELECT language,id
FROM `joom_menu `
WHERE home = 1 AND published = 1 AND client_id = 0id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE joom_menu NULL ref idx_client_id_parent_id_alias_language idx_client_id_parent_id_alias_language 1 const 104 1.00 Using where
Status Duration starting 0.03 ms checking query cache for query 0.01 ms checking privileges on cached 0.00 ms checking permissions 0.02 ms sending cached result to clien 0.03 ms cleaned up 0.01 ms cleaning up 0.00 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: 0.40 ms Viimeisen kyselyn jälkeen: 0.44 ms Kyselymuisti: 0.021 MB Muisti ennen kyselyä: 14.649 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 = 101id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE NULL NULL NULL NULL EI VOI KÄYTTÄÄ INDEKSIAVAinta NULL NULL NULL NULL no matching row in const table
Status Duration starting 0.02 ms checking query cache for query 0.01 ms checking privileges on cached 0.00 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.02 ms checking permissions 0.01 ms sending cached result to clien 0.02 ms cleaned up 0.01 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/cms/language/associations.php:1019 JLanguageAssociations::getAssociations() Copy JROOT/administrator/components/com_menus/helpers/menus.php:3138 MenusHelper::getAssociations() Copy JROOT/plugins/system/languagefilter/languagefilter.php:7467 PlgSystemLanguageFilter->onAfterDispatch() Copy JROOT/libraries/joomla/event/event.php:706 JEvent->update() Copy JROOT/libraries/joomla/event/dispatcher.php:1605 JEventDispatcher->trigger() Copy JROOT/libraries/joomla/application/base.php:1064 JApplicationBase->triggerEvent() Copy JROOT/libraries/cms/application/site.php:1963 JApplicationSite->dispatch() Copy JROOT/libraries/cms/application/site.php:2352 JApplicationSite->doExecute() Copy JROOT/libraries/cms/application/cms.php:2651 JApplicationCms->execute() Copy JROOT/index.php:72
Kyselyaika: 0.41 ms Viimeisen kyselyn jälkeen: 3.06 ms Kyselymuisti: 0.022 MB Muisti ennen kyselyä: 14.996 MB Palautetut rivit: 1
SELECT *
FROM `currency`
WHERE `base_currency`= 1 LIMIT 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE currency NULL ALL NULL EI VOI KÄYTTÄÄ INDEKSIAVAinta NULL NULL 136 10.00 Using where
Status Duration starting 0.03 ms checking query cache for query 0.01 ms checking privileges on cached 0.00 ms checking permissions 0.02 ms sending cached result to clien 0.03 ms cleaned up 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:587 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: 0.32 ms Viimeisen kyselyn jälkeen: 0.11 ms Kyselymuisti: 0.023 MB Muisti ennen kyselyä: 15.003 MB Palautetut rivit: 10
SELECT * FROM axs_fonts WHERE enabled = 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE axs_fonts NULL ALL NULL EI VOI KÄYTTÄÄ INDEKSIAVAinta NULL NULL 10 10.00 Using where
Status Duration starting 0.01 ms checking query cache for query 0.00 ms checking privileges on cached 0.00 ms checking permissions 0.01 ms sending cached result to clien 0.02 ms cleaned up 0.00 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/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:587 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: 0.33 ms Viimeisen kyselyn jälkeen: 0.20 ms Kyselymuisti: 0.022 MB Muisti ennen kyselyä: 15.054 MB Palautetut rivit: 0
SELECT *
FROM accessibility_images
WHERE `path`= 'images/pDJC5BxLjAW4jMgmh4ZjVUqCNDU3NDQ2OTkwOTMw/graphics/blue-logo.png' AND enabled= 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE accessibility_images NULL ALL NULL EI VOI KÄYTTÄÄ INDEKSIAVAinta NULL NULL 1 100.00 Using where
Status Duration starting 0.01 ms checking query cache for query 0.01 ms checking privileges on cached 0.00 ms checking permissions 0.01 ms sending cached result to clien 0.02 ms cleaned up 0.01 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:8068 include Copy JROOT/templates/axs/home.php Copy JROOT/templates/axs/index.php:587 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.72 ms Viimeisen kyselyn jälkeen: 0.50 ms Kyselymuisti: 0.027 MB Muisti ennen kyselyä: 15.136 MB Palautetut rivit: 31
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-07-06 23:04:56') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-07-06 23:04:56') AND m.access IN (1,1) AND m.client_id = 0 AND (mm.menuid = 101 OR mm.menuid <= 0) AND m.language IN ('fi-FI ','* ')
ORDER BY m.position, m.orderingid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL range PRIMARY,idx_language,newsfeeds,published published 5 NULL 58 1.56 Using index condition; Using where; Tiedostolajittelun käyttäminen 1 SIMPLE e NULL ref element_clientid,element_folder_clientid element_clientid 403 root_db.m.module,const 1 10.00 Using index condition; Using where 1 SIMPLE mm NULL ref PRIMARY PRIMARY 4 root_db.m.id 3 40.00 Using where; Using index
Status Duration starting 0.02 ms checking query cache for query 0.13 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.06 ms System lock 0.02 ms optimizing 0.03 ms statistics 0.12 ms preparing 0.04 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.02 ms Creating sort index 0.82 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.05 ms cleaned up 0.01 ms cleaning up 0.02 ms
# Soittaja Tiedoston ja rivin numero 15 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:172114 JDatabaseDriver->loadObjectList() Copy JROOT/libraries/joomla/cache/controller/callback.php:16913 JCacheControllerCallback->get() Copy JROOT/libraries/cms/module/helper.php:42412 JModuleHelper::getModuleList() Copy JROOT/libraries/cms/module/helper.php:36011 JModuleHelper::load() Copy JROOT/libraries/cms/module/helper.php:8410 JModuleHelper::getModules() Copy JROOT/libraries/joomla/document/html.php:5769 JDocumentHtml->countModules() Copy JROOT/templates/axs/home.php:8468 include Copy JROOT/templates/axs/home.php Copy JROOT/templates/axs/index.php:587 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: 0.39 ms Viimeisen kyselyn jälkeen: 1.76 ms Kyselymuisti: 0.022 MB Muisti ennen kyselyä: 15.166 MB Palautetut rivit: 0
SELECT *
FROM accessibility_images
WHERE `path`= 'images/pDJC5BxLjAW4jMgmh4ZjVUqCNDU3NDQ2OTkwOTMw/graphics/desk-with-computer-fullscreen.jpg' AND enabled= 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE accessibility_images NULL ALL NULL EI VOI KÄYTTÄÄ INDEKSIAVAinta NULL NULL 1 100.00 Using where
Status Duration starting 0.02 ms checking query cache for query 0.01 ms checking privileges on cached 0.00 ms checking permissions 0.01 ms sending cached result to clien 0.03 ms cleaned up 0.01 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/accessibility.php:4210 AxsAccessibility::query() Copy JROOT/libraries/axslibs/accessibility.php:499 AxsAccessibility::image() Copy JROOT/templates/axs/home.php:11198 include Copy JROOT/templates/axs/home.php Copy JROOT/templates/axs/index.php:587 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: 0.70 ms Viimeisen kyselyn jälkeen: 5.76 ms Kyselymuisti: 0.023 MB Muisti ennen kyselyä: 15.242 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' ) )id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE axs_notifications NULL ALL NULL EI VOI KÄYTTÄÄ INDEKSIAVAinta NULL NULL 1 100.00 Using where
Status Duration starting 0.02 ms checking query cache for query 0.09 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.05 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.04 ms preparing 0.03 ms executing 0.00 ms Sending data 0.03 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaned up 0.01 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/notifications.php:179 AxsNotifications::loadNotifications() Copy JROOT/templates/axs/home.php:17958 include Copy JROOT/templates/axs/home.php Copy JROOT/templates/axs/index.php:587 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: 0.38 ms Viimeisen kyselyn jälkeen: 0.65 ms Kyselymuisti: 0.023 MB Muisti ennen kyselyä: 15.211 MB Palautetut rivit: 1
SELECT sef FROM joom_languages WHERE lang_code = 'fi-FI ' LIMIT 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE joom_languages NULL const idx_langcode idx_langcode 28 const 1 100.00 NULL
Status Duration starting 0.02 ms checking query cache for query 0.01 ms checking privileges on cached 0.01 ms checking permissions 0.01 ms sending cached result to clien 0.03 ms cleaned up 0.01 ms cleaning up 0.00 ms
# Soittaja Tiedoston ja rivin numero 14 JDatabaseDriverMysqli->execute() Copy JROOT/libraries/joomla/database/driver.php:168213 JDatabaseDriver->loadObject() Copy JROOT/libraries/axslibs/language.php:25512 AxsLanguage::getSefByLangCode() Copy JROOT/modules/mod_mediamodal/tmpl/default.php:811 require Copy JROOT/modules/mod_mediamodal/tmpl/default.php Copy JROOT/modules/mod_mediamodal/mod_mediamodal.php:910 include Copy JROOT/modules/mod_mediamodal/mod_mediamodal.php Copy JROOT/libraries/cms/module/helper.php:1989 JModuleHelper::renderModule() Copy JROOT/libraries/joomla/document/renderer/html/module.php:938 JDocumentRendererHtmlModule->render() Copy JROOT/libraries/joomla/document/renderer/html/modules.php:427 JDocumentRendererHtmlModules->render() Copy JROOT/libraries/joomla/document/html.php:4866 JDocumentHtml->getBuffer() Copy JROOT/libraries/joomla/document/html.php:7775 JDocumentHtml->_renderTemplate() Copy JROOT/libraries/joomla/document/html.php:5524 JDocumentHtml->render() Copy JROOT/libraries/cms/application/cms.php:11903 JApplicationCms->render() Copy JROOT/libraries/cms/application/site.php:7822 JApplicationSite->render() Copy JROOT/libraries/cms/application/cms.php:2711 JApplicationCms->execute() Copy JROOT/index.php:72
Kyselyaika: 0.41 ms Viimeisen kyselyn jälkeen: 2.95 ms Kyselymuisti: 0.026 MB Muisti ennen kyselyä: 15.478 MB Palautetut rivit: 0
SELECT *
FROM joom_easyblog_configs
WHERE `name` = 'config'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE joom_easyblog_configs NULL ALL NULL EI VOI KÄYTTÄÄ INDEKSIAVAinta NULL NULL 1 100.00 Using where
Status Duration starting 0.02 ms checking query cache for query 0.01 ms checking privileges on cached 0.00 ms checking permissions 0.02 ms sending cached result to clien 0.03 ms cleaned up 0.01 ms cleaning up 0.01 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: 0.43 ms Viimeisen kyselyn jälkeen: 1.71 ms Kyselymuisti: 0.028 MB Muisti ennen kyselyä: 15.720 MB Palautetut rivit: 1
SELECT * FROM joom_kunena_configuration WHERE id= 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE joom_kunena_configuration NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL
Status Duration starting 0.03 ms checking query cache for query 0.01 ms checking privileges on cached 0.00 ms checking permissions 0.02 ms sending cached result to clien 0.03 ms cleaned up 0.01 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: 0.40 ms Viimeisen kyselyn jälkeen: 2.78 ms Kyselymuisti: 0.024 MB Muisti ennen kyselyä: 16.556 MB Palautetut rivit: 1
SELECT special_characters FROM joom_languages WHERE sef = 'fi' LIMIT 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE joom_languages NULL const idx_sef idx_sef 202 const 1 100.00 NULL
Status Duration starting 0.02 ms checking query cache for query 0.01 ms checking privileges on cached 0.00 ms checking permissions 0.02 ms sending cached result to clien 0.03 ms cleaned up 0.02 ms cleaning up 0.00 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:27814 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: 0.31 ms Viimeisen kyselyn jälkeen: 0.03 ms Kyselymuisti: 0.025 MB Muisti ennen kyselyä: 16.566 MB Palautetut rivit: 13
SELECT *
FROM axs_translations
WHERE language_tag = 'fi'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE axs_translations NULL ref language_tag language_tag 13 const 13 100.00 NULL
Status Duration starting 0.01 ms checking query cache for query 0.00 ms checking privileges on cached 0.00 ms checking permissions 0.01 ms sending cached result to clien 0.01 ms cleaned up 0.01 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:12014 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
2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `joom_extensions ` 2 × SELECT * FROM joom_languages 2 × SELECT * FROM accessibility_images 1 × SELECT `id`,`name`,`rules`,`parent_id` FROM `joom_assets ` 1 × SELECT special_characters FROM joom_languages 1 × SELECT * FROM joom_kunena_configuration 1 × SELECT * FROM joom_easyblog_configs 1 × SELECT sef FROM joom_languages 1 × SELECT * FROM axs_notifications 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_fonts 1 × SELECT * FROM `currency` 1 × SELECT `c2`.`language`,`c2`.`id` FROM `joom_menu ` AS `c` INNER JOIN `joom_associations ` AS `a` ON a.id = c.`id` AND a.context= 'com_menus.item' INNER JOIN `joom_associations ` AS `a2` ON a.key = a2.key INNER JOIN `joom_menu ` AS `c2` ON a2.id = c2.`id` 1 × SELECT language,id FROM `joom_menu ` 1 × SELECT COUNT (* ) FROM joom_content AS a LEFT JOIN joom_categories AS c ON c.id = a.catid LEFT JOIN joom_users AS ua ON ua.id = a.created_by LEFT JOIN joom_users AS uam ON uam.id = a.modified_by LEFT JOIN joom_categories as parent ON parent.id = c.parent_id LEFT JOIN joom_content_rating AS v ON a.id = v.content_id 1 × SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.catid, a.created, a.created_by, a.created_by_alias, CASE WHEN c.published = 2 AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state, CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name, CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH (a.fulltext) AS readmore,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE (NULLIF (ROUND (v.rating_sum / v.rating_count, 0), 0), 0) AS rating, COALESCE (NULLIF (v.rating_count, 0), 0) as rating_count FROM joom_content AS a LEFT JOIN joom_categories AS c ON c.id = a.catid LEFT JOIN joom_users AS ua ON ua.id = a.created_by LEFT JOIN joom_users AS uam ON uam.id = a.modified_by LEFT JOIN joom_categories as parent ON parent.id = c.parent_id LEFT JOIN joom_content_rating AS v ON a.id = v.content_id 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 id, rules FROM `joom_viewlevels 1 × SELECT params FROM axs_user_settings 1 × SELECT `id`,`title` FROM `joom_usergroups ` 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 * FROM axs_integrations 1 × SELECT * FROM axs_payment_gateways 1 × SELECT * FROM axs_email_settings 1 × SELECT * FROM `axs_dashboard_templates` 1 × SELECT * FROM `axs_homepage_templates` 1 × SELECT * FROM `axs_brands` 1 × SELECT `element`,`name`,`client_id`,`extension_id` FROM `joom_extensions ` 1 × SELECT * FROM axs_domains 1 × SELECT `folder` AS `type`,`element` AS `name`,`params` FROM joom_extensions 1 × SELECT b.id FROM joom_usergroups AS a LEFT JOIN joom_usergroups AS b ON b.lft <= a.lft AND b.rgt >= a.rgt 1 × SELECT * FROM axs_translations