Joomla! Debug Console
{
"__default": {
"session": {
"counter": 1,
"timer": {
"start": 1776512065,
"last": 1776512065,
"now": 1776512065
},
"token": "HA1prUK0xtraL906QNBOz3eY9JWii6sQ"
},
"registry": {},
"user": {
"id": 0,
"name": null,
"username": null,
"email": null,
"password": null,
"password_clear": "",
"block": null,
"sendEmail": 0,
"registerDate": null,
"lastvisitDate": null,
"activation": null,
"params": null,
"groups": [],
"guest": 1,
"lastResetTime": null,
"resetCount": null,
"requireReset": null,
"aid": 0
},
"plg_system_languagefilter": {
"language": "en-GB"
}
}
}
Time
Memory
Time: 8.91 ms / 8.91 ms Memory: 1.789 MB / 2.17 MB Application: afterLoad
Time: 40.48 ms / 49.39 ms Memory: 5.798 MB / 7.96 MB Application: afterInitialise
Time: 5.56 ms / 54.95 ms Memory: 0.645 MB / 8.61 MB Application: afterRoute
Time: 2.36 ms / 57.31 ms Memory: 0.268 MB / 8.88 MB Application: beforeRenderComponent com_users
Time: 16.07 ms / 73.38 ms Memory: 1.705 MB / 10.58 MB Application: afterRenderComponent com_users
Time: 0.86 ms / 74.24 ms Memory: 0.027 MB / 10.61 MB Application: afterDispatch
Time: 2.16 ms / 76.39 ms Memory: 0.250 MB / 10.86 MB Application: beforeRenderModule mod_vikwallimage (Vik Wall Image)
Time: 0.41 ms / 76.80 ms Memory: 0.040 MB / 10.90 MB Application: afterRenderModule mod_vikwallimage (Vik Wall Image)
Time: 0.05 ms / 76.85 ms Memory: -0.004 MB / 10.89 MB Application: beforeRenderModule mod_vikrentcar_confirmationnumber (CONFIRMATION NUMBER)
Time: 1.05 ms / 77.90 ms Memory: 0.018 MB / 10.91 MB Application: afterRenderModule mod_vikrentcar_confirmationnumber (CONFIRMATION NUMBER)
Time: 2.27 ms / 80.17 ms Memory: 0.103 MB / 11.02 MB Application: afterRender
Database queries total: 4.05 ms
11.06 MB (11,595,664 Bytes)
14 Queries Logged 4.05 ms
- Query Time: 0.65 ms Query memory: 0.011 MB Memory before query: 7.307 MB Rows returned: 12
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 jos4c_menu AS m
LEFT JOIN jos4c_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 type possible_keys key key_len ref rows Extra 1 SIMPLE m range idx_client_id_parent_id_alias_language idx_client_id_parent_id_alias_language 5 NULL 13 Using index condition; Using where; Using filesort 1 SIMPLE e eq_ref PRIMARY PRIMARY 4 sfakiato_cartour.m.component_id 1 Using where No SHOW PROFILE (maybe because there are more than 100 queries)# Caller File and line number 25 JDatabaseDriverMysqli->execute() JROOT/plugins/system/falangdriver/falang_database.php:105 24 JFalangDatabase->execute() JROOT/libraries/joomla/database/driver.php:1701 23 JDatabaseDriver->loadObjectList() JROOT/plugins/system/falangdriver/falang_database.php:282 22 JFalangDatabase->loadObjectList() JROOT/libraries/src/Menu/SiteMenu.php:93 21 Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}() Same as call in the line below. 20 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 19 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Menu/SiteMenu.php:101 18 Joomla\CMS\Menu\SiteMenu->load() JROOT/libraries/src/Menu/AbstractMenu.php:76 17 Joomla\CMS\Menu\AbstractMenu->__construct() JROOT/libraries/src/Menu/SiteMenu.php:62 16 Joomla\CMS\Menu\SiteMenu->__construct() JROOT/libraries/src/Menu/AbstractMenu.php:131 15 Joomla\CMS\Menu\AbstractMenu::getInstance() JROOT/libraries/src/Application/CMSApplication.php:395 14 Joomla\CMS\Application\CMSApplication->getMenu() JROOT/libraries/src/Application/SiteApplication.php:275 13 Joomla\CMS\Application\SiteApplication->getMenu() JROOT/libraries/src/Router/SiteRouter.php:65 12 Joomla\CMS\Router\SiteRouter->__construct() JROOT/libraries/src/Router/Router.php:189 11 Joomla\CMS\Router\Router::getInstance() JROOT/libraries/src/Application/CMSApplication.php:511 10 Joomla\CMS\Application\CMSApplication::getRouter() JROOT/libraries/src/Application/SiteApplication.php:403 9 Joomla\CMS\Application\SiteApplication::getRouter() JROOT/plugins/system/languagefilter/languagefilter.php:145 8 PlgSystemLanguageFilter->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:646 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.07 ms After last query: 0.83 ms Query memory: 0.013 MB Memory before query: 7.444 MB Rows returned: 10
SELECT joomlatablename,tablepkID
FROM `jos4c_falang_tableinfo`id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE jos4c_falang_tableinfo ALL NULL NO INDEX KEY COULD BE USED NULL NULL 10 No SHOW PROFILE (maybe because there are more than 100 queries)# Caller File and line number 30 JDatabaseDriverMysqli->execute() JROOT/plugins/system/falangdriver/falang_database.php:105 29 JFalangDatabase->execute() JROOT/libraries/joomla/database/driver.php:1701 28 JDatabaseDriver->loadObjectList() JROOT/plugins/system/falangdriver/falang_database.php:282 27 JFalangDatabase->loadObjectList() JROOT/administrator/components/com_falang/classes/FalangManager.class.php:138 26 FalangManager->_loadPrimaryKeyData() JROOT/administrator/components/com_falang/classes/FalangManager.class.php:57 25 FalangManager->__construct() JROOT/administrator/components/com_falang/classes/FalangManager.class.php:85 24 FalangManager::getInstance() JROOT/components/com_falang/helpers/falang.class.php:35 23 Falang::translateList() JROOT/plugins/system/falangdriver/falang_database.php:334 22 JFalangDatabase->loadObjectList() JROOT/libraries/src/Menu/SiteMenu.php:93 21 Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}() Same as call in the line below. 20 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 19 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Menu/SiteMenu.php:101 18 Joomla\CMS\Menu\SiteMenu->load() JROOT/libraries/src/Menu/AbstractMenu.php:76 17 Joomla\CMS\Menu\AbstractMenu->__construct() JROOT/libraries/src/Menu/SiteMenu.php:62 16 Joomla\CMS\Menu\SiteMenu->__construct() JROOT/libraries/src/Menu/AbstractMenu.php:131 15 Joomla\CMS\Menu\AbstractMenu::getInstance() JROOT/libraries/src/Application/CMSApplication.php:395 14 Joomla\CMS\Application\CMSApplication->getMenu() JROOT/libraries/src/Application/SiteApplication.php:275 13 Joomla\CMS\Application\SiteApplication->getMenu() JROOT/libraries/src/Router/SiteRouter.php:65 12 Joomla\CMS\Router\SiteRouter->__construct() JROOT/libraries/src/Router/Router.php:189 11 Joomla\CMS\Router\Router::getInstance() JROOT/libraries/src/Application/CMSApplication.php:511 10 Joomla\CMS\Application\CMSApplication::getRouter() JROOT/libraries/src/Application/SiteApplication.php:403 9 Joomla\CMS\Application\SiteApplication::getRouter() JROOT/plugins/system/languagefilter/languagefilter.php:145 8 PlgSystemLanguageFilter->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:646 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.06 ms After last query: 0.06 ms Query memory: 0.013 MB Memory before query: 7.458 MB Rows returned: 6
SELECT *
FROM jos4c_languages
ORDER BY orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE jos4c_languages ALL NULL NO INDEX KEY COULD BE USED NULL NULL 6 Using filesort No SHOW PROFILE (maybe because there are more than 100 queries)# Caller File and line number 30 JDatabaseDriverMysqli->execute() JROOT/plugins/system/falangdriver/falang_database.php:105 29 JFalangDatabase->execute() JROOT/libraries/joomla/database/driver.php:1701 28 JDatabaseDriver->loadObjectList() JROOT/plugins/system/falangdriver/falang_database.php:282 27 JFalangDatabase->loadObjectList() JROOT/administrator/components/com_falang/classes/FalangManager.class.php:313 26 FalangManager->getLanguages() JROOT/administrator/components/com_falang/classes/FalangManager.class.php:63 25 FalangManager->__construct() JROOT/administrator/components/com_falang/classes/FalangManager.class.php:85 24 FalangManager::getInstance() JROOT/components/com_falang/helpers/falang.class.php:35 23 Falang::translateList() JROOT/plugins/system/falangdriver/falang_database.php:334 22 JFalangDatabase->loadObjectList() JROOT/libraries/src/Menu/SiteMenu.php:93 21 Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}() Same as call in the line below. 20 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 19 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Menu/SiteMenu.php:101 18 Joomla\CMS\Menu\SiteMenu->load() JROOT/libraries/src/Menu/AbstractMenu.php:76 17 Joomla\CMS\Menu\AbstractMenu->__construct() JROOT/libraries/src/Menu/SiteMenu.php:62 16 Joomla\CMS\Menu\SiteMenu->__construct() JROOT/libraries/src/Menu/AbstractMenu.php:131 15 Joomla\CMS\Menu\AbstractMenu::getInstance() JROOT/libraries/src/Application/CMSApplication.php:395 14 Joomla\CMS\Application\CMSApplication->getMenu() JROOT/libraries/src/Application/SiteApplication.php:275 13 Joomla\CMS\Application\SiteApplication->getMenu() JROOT/libraries/src/Router/SiteRouter.php:65 12 Joomla\CMS\Router\SiteRouter->__construct() JROOT/libraries/src/Router/Router.php:189 11 Joomla\CMS\Router\Router::getInstance() JROOT/libraries/src/Application/CMSApplication.php:511 10 Joomla\CMS\Application\CMSApplication::getRouter() JROOT/libraries/src/Application/SiteApplication.php:403 9 Joomla\CMS\Application\SiteApplication::getRouter() JROOT/plugins/system/languagefilter/languagefilter.php:145 8 PlgSystemLanguageFilter->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:646 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.47 ms After last query: 1.03 ms Query memory: 0.015 MB Memory before query: 7.647 MB Rows returned: 14
SHOW FULL COLUMNS
FROM `jos4c_languages`EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `jos4c_languages`No SHOW PROFILE (maybe because there are more than 100 queries)# Caller File and line number 34 JDatabaseDriverMysqli->execute() JROOT/plugins/system/falangdriver/falang_database.php:105 33 JFalangDatabase->execute() JROOT/libraries/joomla/database/driver.php:1701 32 JDatabaseDriver->loadObjectList() JROOT/plugins/system/falangdriver/falang_database.php:282 31 JFalangDatabase->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:448 30 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:245 29 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:164 28 Joomla\CMS\Table\Table->__construct() JROOT/administrator/components/com_falang/tables/JFLanguage.php:54 27 TableJFLanguage->__construct() JROOT/administrator/components/com_falang/classes/FalangManager.class.php:319 26 FalangManager->getLanguages() JROOT/administrator/components/com_falang/classes/FalangManager.class.php:63 25 FalangManager->__construct() JROOT/administrator/components/com_falang/classes/FalangManager.class.php:85 24 FalangManager::getInstance() JROOT/components/com_falang/helpers/falang.class.php:35 23 Falang::translateList() JROOT/plugins/system/falangdriver/falang_database.php:334 22 JFalangDatabase->loadObjectList() JROOT/libraries/src/Menu/SiteMenu.php:93 21 Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}() Same as call in the line below. 20 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 19 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Menu/SiteMenu.php:101 18 Joomla\CMS\Menu\SiteMenu->load() JROOT/libraries/src/Menu/AbstractMenu.php:76 17 Joomla\CMS\Menu\AbstractMenu->__construct() JROOT/libraries/src/Menu/SiteMenu.php:62 16 Joomla\CMS\Menu\SiteMenu->__construct() JROOT/libraries/src/Menu/AbstractMenu.php:131 15 Joomla\CMS\Menu\AbstractMenu::getInstance() JROOT/libraries/src/Application/CMSApplication.php:395 14 Joomla\CMS\Application\CMSApplication->getMenu() JROOT/libraries/src/Application/SiteApplication.php:275 13 Joomla\CMS\Application\SiteApplication->getMenu() JROOT/libraries/src/Router/SiteRouter.php:65 12 Joomla\CMS\Router\SiteRouter->__construct() JROOT/libraries/src/Router/Router.php:189 11 Joomla\CMS\Router\Router::getInstance() JROOT/libraries/src/Application/CMSApplication.php:511 10 Joomla\CMS\Application\CMSApplication::getRouter() JROOT/libraries/src/Application/SiteApplication.php:403 9 Joomla\CMS\Application\SiteApplication::getRouter() JROOT/plugins/system/languagefilter/languagefilter.php:145 8 PlgSystemLanguageFilter->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:646 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.80 ms After last query: 0.37 ms Query memory: 0.012 MB Memory before query: 7.714 MB Rows returned: 0
SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
FROM jos4c_falang_content AS falang_content
WHERE falang_content.language_id=1
AND falang_content.published=1
AND falang_content.reference_id IN(101,109,157,158,159,134,160,161,162,155,167,235)
AND falang_content.reference_table='menu'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE falang_content ref idxFalang1,falangContent,falangContentLanguage,reference_id,language_id,reference_table language_id 4 const 1 Using where No SHOW PROFILE (maybe because there are more than 100 queries)# Caller File and line number 28 JDatabaseDriverMysqli->execute() JROOT/plugins/system/falangdriver/falang_database.php:105 27 JFalangDatabase->execute() JROOT/libraries/joomla/database/driver.php:1701 26 JDatabaseDriver->loadObjectList() JROOT/plugins/system/falangdriver/falang_database.php:277 25 JFalangDatabase->loadObjectList() JROOT/components/com_falang/helpers/falang.class.php:235 24 Falang::translateListWithIDs() JROOT/components/com_falang/helpers/falang.class.php:108 23 Falang::translateList() JROOT/plugins/system/falangdriver/falang_database.php:334 22 JFalangDatabase->loadObjectList() JROOT/libraries/src/Menu/SiteMenu.php:93 21 Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}() Same as call in the line below. 20 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 19 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Menu/SiteMenu.php:101 18 Joomla\CMS\Menu\SiteMenu->load() JROOT/libraries/src/Menu/AbstractMenu.php:76 17 Joomla\CMS\Menu\AbstractMenu->__construct() JROOT/libraries/src/Menu/SiteMenu.php:62 16 Joomla\CMS\Menu\SiteMenu->__construct() JROOT/libraries/src/Menu/AbstractMenu.php:131 15 Joomla\CMS\Menu\AbstractMenu::getInstance() JROOT/libraries/src/Application/CMSApplication.php:395 14 Joomla\CMS\Application\CMSApplication->getMenu() JROOT/libraries/src/Application/SiteApplication.php:275 13 Joomla\CMS\Application\SiteApplication->getMenu() JROOT/libraries/src/Router/SiteRouter.php:65 12 Joomla\CMS\Router\SiteRouter->__construct() JROOT/libraries/src/Router/Router.php:189 11 Joomla\CMS\Router\Router::getInstance() JROOT/libraries/src/Application/CMSApplication.php:511 10 Joomla\CMS\Application\CMSApplication::getRouter() JROOT/libraries/src/Application/SiteApplication.php:403 9 Joomla\CMS\Application\SiteApplication::getRouter() JROOT/plugins/system/languagefilter/languagefilter.php:145 8 PlgSystemLanguageFilter->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:646 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.32 ms After last query: 5.72 ms Query memory: 0.007 MB Memory before query: 8.585 MB Rows returned: 4
SELECT id, home, template, s.params
FROM jos4c_template_styles as s
LEFT JOIN jos4c_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 type possible_keys key key_len ref rows Extra 1 SIMPLE s ALL idx_template,idx_client_id,idx_client_id_home NO INDEX KEY COULD BE USED NULL NULL 6 Using where 1 SIMPLE e ref element_clientid,element_folder_clientid,extension element_clientid 403 sfakiato_cartour.s.template,const 1 Using index condition; Using where No SHOW PROFILE (maybe because there are more than 100 queries)# Caller File and line number 15 JDatabaseDriverMysqli->execute() JROOT/plugins/system/falangdriver/falang_database.php:105 14 JFalangDatabase->execute() JROOT/libraries/joomla/database/driver.php:1701 13 JDatabaseDriver->loadObjectList() JROOT/plugins/system/falangdriver/falang_database.php:282 12 JFalangDatabase->loadObjectList() JROOT/libraries/src/Application/SiteApplication.php:486 11 Joomla\CMS\Application\SiteApplication->getTemplate() JROOT/plugins/system/jsntplframework/libraries/joomlashine/loader.php:33 10 jsn_template_framework_class_loader() Same as call in the line below. 9 spl_autoload_call() JROOT/plugins/system/jsntplframework/jsntplframework.php:187 8 PlgSystemJSNTPLFramework->onAfterRoute() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1168 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.17 ms After last query: 0.94 ms Query memory: 0.008 MB Memory before query: 8.643 MB Rows returned: 1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `jos4c_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE jos4c_extensions ref element_clientid,element_folder_clientid,extension extension 484 const,const 1 Using index condition No SHOW PROFILE (maybe because there are more than 100 queries)# Caller File and line number 18 JDatabaseDriverMysqli->execute() JROOT/plugins/system/falangdriver/falang_database.php:105 17 JFalangDatabase->execute() JROOT/libraries/joomla/database/driver.php:1701 16 JDatabaseDriver->loadObjectList() JROOT/plugins/system/falangdriver/falang_database.php:282 15 JFalangDatabase->loadObjectList() JROOT/plugins/system/falangdriver/falang_database.php:416 14 JFalangDatabase->loadObject() JROOT/libraries/src/Helper/LibraryHelper.php:167 13 Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}() Same as call in the line below. 12 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 11 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/LibraryHelper.php:175 10 Joomla\CMS\Helper\LibraryHelper::loadLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:43 9 Joomla\CMS\Helper\LibraryHelper::getLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:90 8 Joomla\CMS\Helper\LibraryHelper::getParams() JROOT/libraries/src/Version.php:321 7 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 6 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 5 Joomla\CMS\Factory::getDocument() JROOT/libraries/src/Application/WebApplication.php:1131 4 Joomla\CMS\Application\WebApplication->loadDocument() JROOT/libraries/src/Application/SiteApplication.php:133 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.53 ms After last query: 0.20 ms Query memory: 0.005 MB Memory before query: 8.635 MB
UPDATE `jos4c_extensions`
SET `params` = '{\"mediaversion\":\"f9eb41eba7148b0e5474dec2ab6ac838\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'EXPLAIN not possible on query: UPDATE `jos4c_extensions` SET `params` = '{\"mediaversion\":\"f9eb41eba7148b0e5474dec2ab6ac838\"}' WHERE `type` = 'library' AND `element` = 'joomla'No SHOW PROFILE (maybe because there are more than 100 queries)# Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/plugins/system/falangdriver/falang_database.php:105 10 JFalangDatabase->execute() JROOT/libraries/src/Helper/LibraryHelper.php:117 9 Joomla\CMS\Helper\LibraryHelper::saveParams() JROOT/libraries/src/Version.php:372 8 Joomla\CMS\Version->setMediaVersion() JROOT/libraries/src/Version.php:331 7 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 6 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 5 Joomla\CMS\Factory::getDocument() JROOT/libraries/src/Application/WebApplication.php:1131 4 Joomla\CMS\Application\WebApplication->loadDocument() JROOT/libraries/src/Application/SiteApplication.php:133 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.68 ms After last query: 6.61 ms Query memory: 0.012 MB Memory before query: 9.699 MB Rows returned: 0
SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM jos4c_fields AS a
LEFT JOIN `jos4c_languages` AS l
ON l.lang_code = a.language
LEFT JOIN jos4c_users AS uc
ON uc.id=a.checked_out
LEFT JOIN jos4c_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN jos4c_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN jos4c_fields_groups AS g
ON g.id = a.group_id
WHERE a.context = 'com_users.remind'
AND a.access IN (1,1,5)
AND (a.group_id = 0 OR g.access IN (1,1,5))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ref idx_state,idx_access,idx_context idx_state 1 const 1 Using where; Using temporary; Using filesort 1 SIMPLE l eq_ref idx_langcode idx_langcode 28 sfakiato_cartour.a.language 1 Using where 1 SIMPLE uc eq_ref PRIMARY PRIMARY 4 sfakiato_cartour.a.checked_out 1 1 SIMPLE ag eq_ref PRIMARY PRIMARY 4 sfakiato_cartour.a.access 1 Using where 1 SIMPLE ua eq_ref PRIMARY PRIMARY 4 sfakiato_cartour.a.created_user_id 1 Using where 1 SIMPLE g eq_ref PRIMARY PRIMARY 4 sfakiato_cartour.a.group_id 1 Using where No SHOW PROFILE (maybe because there are more than 100 queries)# Caller File and line number 26 JDatabaseDriverMysqli->execute() JROOT/plugins/system/falangdriver/falang_database.php:105 25 JFalangDatabase->execute() JROOT/libraries/joomla/database/driver.php:1701 24 JDatabaseDriver->loadObjectList() JROOT/plugins/system/falangdriver/falang_database.php:282 23 JFalangDatabase->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 22 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_fields/models/fields.php:333 21 FieldsModelFields->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:187 20 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 19 FieldsHelper::getFields() JROOT/administrator/components/com_fields/helpers/fields.php:286 18 FieldsHelper::prepareForm() JROOT/plugins/system/fields/fields.php:305 17 PlgSystemFields->onContentPrepareForm() JROOT/libraries/joomla/event/event.php:70 16 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 15 JEventDispatcher->trigger() JROOT/libraries/src/MVC/Model/FormModel.php:321 14 Joomla\CMS\MVC\Model\FormModel->preprocessForm() JROOT/components/com_users/models/remind.php:59 13 UsersModelRemind->preprocessForm() JROOT/libraries/src/MVC/Model/FormModel.php:242 12 Joomla\CMS\MVC\Model\FormModel->loadForm() JROOT/components/com_users/models/remind.php:34 11 UsersModelRemind->getForm() JROOT/libraries/src/MVC/View/HtmlView.php:425 10 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_users/views/remind/view.html.php:37 9 UsersViewRemind->display() JROOT/components/com_users/controller.php:139 8 UsersController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_users/users.php:15 6 require_once JROOT/components/com_users/users.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.08 ms After last query: 10.02 ms Query memory: 0.006 MB Memory before query: 10.587 MB Rows returned: 1
SELECT language,id
FROM `jos4c_menu`
WHERE home = 1
AND published = 1
AND client_id = 0id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE jos4c_menu ref idx_client_id_parent_id_alias_language idx_client_id_parent_id_alias_language 1 const 14 Using where No SHOW PROFILE (maybe because there are more than 100 queries)# Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/plugins/system/falangdriver/falang_database.php:105 11 JFalangDatabase->execute() JROOT/libraries/joomla/database/driver.php:1701 10 JDatabaseDriver->loadObjectList() JROOT/plugins/system/falangdriver/falang_database.php:282 9 JFalangDatabase->loadObjectList() JROOT/libraries/src/Language/Multilanguage.php:107 8 Joomla\CMS\Language\Multilanguage::getSiteHomePages() JROOT/plugins/system/languagefilter/languagefilter.php:751 7 PlgSystemLanguageFilter->onAfterDispatch() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/SiteApplication.php:199 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.06 ms After last query: 0.08 ms Query memory: 0.007 MB Memory before query: 10.598 MB Rows returned: 0
SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
FROM jos4c_falang_content AS falang_content
WHERE falang_content.language_id=1
AND falang_content.published=1
AND falang_content.reference_id IN(101)
AND falang_content.reference_table='menu'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE falang_content ref idxFalang1,falangContent,falangContentLanguage,reference_id,language_id,reference_table language_id 4 const 1 Using where No SHOW PROFILE (maybe because there are more than 100 queries)# Caller File and line number 15 JDatabaseDriverMysqli->execute() JROOT/plugins/system/falangdriver/falang_database.php:105 14 JFalangDatabase->execute() JROOT/libraries/joomla/database/driver.php:1701 13 JDatabaseDriver->loadObjectList() JROOT/plugins/system/falangdriver/falang_database.php:277 12 JFalangDatabase->loadObjectList() JROOT/components/com_falang/helpers/falang.class.php:235 11 Falang::translateListWithIDs() JROOT/components/com_falang/helpers/falang.class.php:108 10 Falang::translateList() JROOT/plugins/system/falangdriver/falang_database.php:334 9 JFalangDatabase->loadObjectList() JROOT/libraries/src/Language/Multilanguage.php:107 8 Joomla\CMS\Language\Multilanguage::getSiteHomePages() JROOT/plugins/system/languagefilter/languagefilter.php:751 7 PlgSystemLanguageFilter->onAfterDispatch() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/SiteApplication.php:199 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.11 ms After last query: 3.43 ms Query memory: 0.006 MB Memory before query: 10.917 MB Rows returned: 1Duplicate queries: #13
SELECT `setting`
FROM `jos4c_vikrentcar_config`
WHERE `param`='dateformat';id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE jos4c_vikrentcar_config ALL NULL NO INDEX KEY COULD BE USED NULL NULL 113 Using where No SHOW PROFILE (maybe because there are more than 100 queries)# Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/plugins/system/falangdriver/falang_database.php:105 12 JFalangDatabase->execute() JROOT/modules/mod_vikrentcar_confirmationnumber/helper.php:21 11 modVikrentcarConfirmationNumberHelper::getDateFormat() JROOT/modules/mod_vikrentcar_confirmationnumber/mod_vikrentcar_confirmationnumber.php:21 10 include JROOT/modules/mod_vikrentcar_confirmationnumber/mod_vikrentcar_confirmationnumber.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:501 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:793 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:567 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1090 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:209 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.07 ms After last query: 0.24 ms Query memory: 0.007 MB Memory before query: 10.920 MB Rows returned: 1Duplicate queries: #12
SELECT `setting`
FROM `jos4c_vikrentcar_config`
WHERE `param`='dateformat';id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE jos4c_vikrentcar_config ALL NULL NO INDEX KEY COULD BE USED NULL NULL 113 Using where No SHOW PROFILE (maybe because there are more than 100 queries)# Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/plugins/system/falangdriver/falang_database.php:105 15 JFalangDatabase->execute() JROOT/libraries/joomla/database/driver.php:1701 14 JDatabaseDriver->loadObjectList() JROOT/plugins/system/falangdriver/falang_database.php:282 13 JFalangDatabase->loadObjectList() JROOT/plugins/system/falangdriver/falang_database.php:459 12 JFalangDatabase->loadAssocList() JROOT/modules/mod_vikrentcar_confirmationnumber/helper.php:22 11 modVikrentcarConfirmationNumberHelper::getDateFormat() JROOT/modules/mod_vikrentcar_confirmationnumber/mod_vikrentcar_confirmationnumber.php:21 10 include JROOT/modules/mod_vikrentcar_confirmationnumber/mod_vikrentcar_confirmationnumber.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:501 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:793 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:567 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1090 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:209 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
11 Query Types Logged, Sorted by Occurrences.
SELECT Tables:
2 × SELECT `setting`
FROM `jos4c_vikrentcar_config`2 × SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
FROM jos4c_falang_content AS falang_content1 × 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 jos4c_menu AS m
LEFT JOIN jos4c_extensions AS e
ON m.component_id = e.extension_id1 × SELECT joomlatablename,tablepkID
FROM `jos4c_falang_tableinfo1 × SELECT *
FROM jos4c_languages1 × SELECT id, home, template, s.params
FROM jos4c_template_styles as s
LEFT JOIN jos4c_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id1 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `jos4c_extensions`1 × SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM jos4c_fields AS a
LEFT JOIN `jos4c_languages` AS l
ON l.lang_code = a.language
LEFT JOIN jos4c_users AS uc
ON uc.id=a.checked_out
LEFT JOIN jos4c_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN jos4c_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN jos4c_fields_groups AS g
ON g.id = a.group_id1 × SELECT language,id
FROM `jos4c_menu`
OTHER Tables:
1 × SHOW FULL COLUMNS
FROM `jos4c_languages1 × UPDATE `jos4c_extensions`
SET `params` = '{\"mediaversion\":\"f9eb41eba7148b0e5474dec2ab6ac838\"}'