MAN Lions Coach L, year 02/2017, 54 seats De Luxe (54+1+1), 4**** First Class
SETRA TransFairLiner, 53 seats (49+4+1)
Vivaro, 8 Passanger + Driver
Nav view search
Navigation
We use cookies on our website. Some of them are essential for the operation of the site, while others help us to improve this site and the user experience (tracking cookies). You can decide for yourself whether you want to allow cookies or not. Please note that if you reject them, you may not be able to use all the functionalities of the site.
Joomla! Debug Console
{
"__default": {
"session": {
"counter": 1,
"timer": {
"start": 1679938712,
"last": 1679938712,
"now": 1679938712
},
"client": {
"forwarded": "3.236.209.138"
},
"token": "wyFppfcjh32WC6DJbHmjln3hAKA9SSVH"
},
"registry": {
"mobilejoomla": {
"cache": "bY/NUsMwDIRfhfEJLnWSKT8j3whX4BEYETuJqV0HS6Ewnb47Mkm5wEnjb73SLkIDR4IbUNZ9+M4p8wx3oB7fHpYn1NWqR8y7eVKGoAJVRr0tph7nwC9n8RWqotSgssPwD6YuO7c/eMujMn7BzRmPzg8j/3K5M/lPFzKyT4XW628fcXB9yhGZlHkSKpGjj46/JreAa/FixqgMSt7jiUDSYrR2LUhs24BEaukv4uIluC2taMfpp+vf4ifZJRlmLGQrqG3vE+tmU11cjswTgdZdijHtu4yHsEl50D2+6yuxfgM=",
"markup": ""
}
},
"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
}
}
}
Time
Memory
Time: 11.78 ms / 11.78 ms Memory: 1.984 MB / 2.32 MB Application: afterLoad
Time: 91.35 ms / 103.13 ms Memory: 5.252 MB / 7.57 MB Application: afterInitialise
Time: 27.15 ms / 130.28 ms Memory: 1.090 MB / 8.66 MB Application: afterRoute
Time: 2.90 ms / 133.17 ms Memory: 0.031 MB / 8.70 MB Application: beforeRenderComponent com_content
Time: 3.25 ms / 136.42 ms Memory: 0.446 MB / 9.14 MB Application: Before Access::preloadComponents (all components)
Time: 3.38 ms / 139.80 ms Memory: 0.056 MB / 9.20 MB Application: After Access::preloadComponents (all components)
Time: 0.02 ms / 139.82 ms Memory: 0.059 MB / 9.26 MB Application: Before Access::preloadPermissions (com_content)
Time: 1.90 ms / 141.72 ms Memory: 0.152 MB / 9.41 MB Application: After Access::preloadPermissions (com_content)
Time: 0.02 ms / 141.74 ms Memory: -0.011 MB / 9.40 MB Application: Before Access::getAssetRules (id:256 name:com_content.article.117)
Time: 0.34 ms / 142.08 ms Memory: 0.029 MB / 9.43 MB Application: After Access::getAssetRules (id:256 name:com_content.article.117)
Time: 47.83 ms / 189.92 ms Memory: 3.974 MB / 13.40 MB Application: afterRenderComponent com_content
Time: 3.55 ms / 193.47 ms Memory: 0.052 MB / 13.45 MB Application: Before Access::getAssetRules (id:8 name:com_content)
Time: 0.04 ms / 193.51 ms Memory: 0.007 MB / 13.46 MB Application: After Access::getAssetRules (id:8 name:com_content)
Time: 3.51 ms / 197.02 ms Memory: 0.122 MB / 13.58 MB Application: afterDispatch
Time: 4.41 ms / 201.43 ms Memory: 0.247 MB / 13.83 MB Application: beforeRenderModule mod_menu (Bottom Menu Deutsch)
Time: 1.02 ms / 202.45 ms Memory: 0.078 MB / 13.91 MB Application: afterRenderModule mod_menu (Bottom Menu Deutsch)
Time: 0.02 ms / 202.47 ms Memory: -0.003 MB / 13.90 MB Application: beforeRenderModule mod_menu (Bottom Menu Englisch)
Time: 0.51 ms / 202.99 ms Memory: 0.014 MB / 13.92 MB Application: afterRenderModule mod_menu (Bottom Menu Englisch)
Time: 0.03 ms / 203.02 ms Memory: 0.009 MB / 13.93 MB Application: beforeRenderModule mod_maximenuck (DropDownMenu Deutsch)
Time: 10.71 ms / 213.73 ms Memory: 1.457 MB / 15.38 MB Application: afterRenderModule mod_maximenuck (DropDownMenu Deutsch)
Time: 0.07 ms / 213.80 ms Memory: -0.029 MB / 15.35 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)
Time: 0.67 ms / 214.47 ms Memory: 0.024 MB / 15.38 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)
Time: 0.04 ms / 214.51 ms Memory: -0.003 MB / 15.37 MB Application: beforeRenderModule mod_search (Search)
Time: 0.62 ms / 215.13 ms Memory: 0.015 MB / 15.39 MB Application: afterRenderModule mod_search (Search)
Time: 0.02 ms / 215.15 ms Memory: -0.003 MB / 15.39 MB Application: beforeRenderModule mod_languages (Sprechauswahl)
Time: 2.61 ms / 217.76 ms Memory: 0.100 MB / 15.49 MB Application: afterRenderModule mod_languages (Sprechauswahl)
Time: 0.04 ms / 217.80 ms Memory: -0.001 MB / 15.49 MB Application: beforeRenderModule mod_menu (Top Menu English)
Time: 0.91 ms / 218.71 ms Memory: 0.025 MB / 15.51 MB Application: afterRenderModule mod_menu (Top Menu English)
Time: 0.02 ms / 218.73 ms Memory: -0.002 MB / 15.51 MB Application: beforeRenderModule mod_menu (Top Menu French)
Time: 0.12 ms / 218.86 ms Memory: 0.004 MB / 15.51 MB Application: afterRenderModule mod_menu (Top Menu French)
Time: 4.03 ms / 222.88 ms Memory: 0.113 MB / 15.63 MB Application: afterRender
Database queries total: 70.13 ms
15.98 MB (16,755,808 Bytes)
32 Queries Logged 70.13 ms
- Query Time: 1.03 ms Query memory: 0.023 MB Memory before query: 4.041 MB Rows returned: 0
SELECT `data`
FROM `jom_session`
WHERE `session_id` = X'3265356233623030316532633264346635333432616631656232663364626265'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jom_session NULL const PRIMARY PRIMARY 194 const 1 100.00 NULL Status Duration starting 0.09 ms checking permissions 0.02 ms Opening tables 0.43 ms init 0.03 ms System lock 0.02 ms optimizing 0.02 ms statistics 0.06 ms executing 0.02 ms end 0.01 ms query end 0.02 ms closing tables 0.02 ms freeing items 0.08 ms cleaning up 0.03 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 15 JDatabaseDriver->loadResult() JROOT/libraries/joomla/session/storage/database.php:45 14 JSessionStorageDatabase->read() Same as call in the line below. 13 session_start() JROOT/libraries/joomla/session/handler/native.php:260 12 JSessionHandlerNative->doSessionStart() JROOT/libraries/joomla/session/handler/native.php:50 11 JSessionHandlerNative->start() JROOT/libraries/joomla/session/handler/joomla.php:88 10 JSessionHandlerJoomla->start() JROOT/libraries/src/Session/Session.php:661 9 Joomla\CMS\Session\Session->_start() JROOT/libraries/src/Session/Session.php:621 8 Joomla\CMS\Session\Session->start() JROOT/libraries/src/Session/Session.php:499 7 Joomla\CMS\Session\Session->get() JROOT/libraries/src/Session/Session.php:456 6 Joomla\CMS\Session\Session->isNew() JROOT/libraries/src/Application/CMSApplication.php:826 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:136 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:386 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Query Time: 0.53 ms After last query: 0.84 ms Query memory: 0.020 MB Memory before query: 4.149 MB Rows returned: 0
SELECT `session_id`
FROM `jom_session`
WHERE `session_id` = X'3265356233623030316532633264346635333432616631656232663364626265'
LIMIT 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jom_session NULL const PRIMARY PRIMARY 194 const 1 100.00 Using index Status Duration starting 0.06 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.02 ms System lock 0.02 ms optimizing 0.02 ms statistics 0.04 ms executing 0.02 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.07 ms cleaning up 0.02 ms # Caller File and line number 9 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 8 JDatabaseDriver->loadResult() JROOT/libraries/src/Session/MetadataManager.php:74 7 Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() JROOT/libraries/src/Application/CMSApplication.php:154 6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:828 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:136 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:386 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Query Time: 2.08 ms After last query: 0.06 ms Query memory: 0.004 MB Memory before query: 4.154 MB
INSERT INTO `jom_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'3265356233623030316532633264346635333432616631656232663364626265', 1, 1679938712, 0, '', 0)EXPLAIN not possible on query: INSERT INTO `jom_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3265356233623030316532633264346635333432616631656232663364626265', 1, 1679938712, 0, '', 0)Status Duration starting 0.07 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.03 ms System lock 0.01 ms update 0.13 ms Waiting for query cache lock 0.01 ms update 0.01 ms end 0.01 ms query end 1.41 ms closing tables 0.03 ms freeing items 0.07 ms cleaning up 0.03 ms # Caller File and line number 8 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Session/MetadataManager.php:116 7 Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() JROOT/libraries/src/Application/CMSApplication.php:154 6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:828 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:136 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:386 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Query Time: 2.02 ms After last query: 1.53 ms Query memory: 0.024 MB Memory before query: 4.424 MB Rows returned: 40
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `jom_extensions`
WHERE `type` = 'component'
AND `state` = 0
AND `enabled` = 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jom_extensions NULL ref extension extension 82 const 40 1.00 Using where Status Duration starting 0.68 ms checking permissions 0.02 ms Opening tables 0.35 ms init 0.04 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.09 ms preparing 0.02 ms executing 0.01 ms Sending data 0.32 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.11 ms cleaning up 0.02 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Component/ComponentHelper.php:445 10 Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}() Same as call in the line below. 9 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 8 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Component/ComponentHelper.php:453 7 Joomla\CMS\Component\ComponentHelper::load() JROOT/libraries/src/Component/ComponentHelper.php:519 6 Joomla\CMS\Component\ComponentHelper::getComponents() JROOT/libraries/src/Component/ComponentHelper.php:44 5 Joomla\CMS\Component\ComponentHelper::getComponent() JROOT/libraries/src/Component/ComponentHelper.php:103 4 Joomla\CMS\Component\ComponentHelper::getParams() JROOT/libraries/src/Application/SiteApplication.php:594 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.82 ms After last query: 1.43 ms Query memory: 0.021 MB Memory before query: 4.633 MB Rows returned: 4
SELECT id, rules
FROM `jom_viewlevels`id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jom_viewlevels NULL ALL NULL NO INDEX KEY COULD BE USED NULL NULL 4 100.00 NULL Status Duration starting 0.05 ms checking permissions 0.01 ms Opening tables 0.29 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.02 ms executing 0.01 ms Sending data 0.05 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.07 ms cleaning up 0.02 ms # Caller File and line number 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506 9 JDatabaseDriver->loadAssocList() JROOT/libraries/src/Access/Access.php:1063 8 Joomla\CMS\Access\Access::getAuthorisedViewLevels() JROOT/libraries/src/User/User.php:458 7 Joomla\CMS\User\User->getAuthorisedViewLevels() JROOT/libraries/src/Plugin/PluginHelper.php:318 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.98 ms After last query: 0.06 ms Query memory: 0.021 MB Memory before query: 4.644 MB Rows returned: 1
SELECT b.id
FROM jom_usergroups AS a
LEFT JOIN jom_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.08 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.32 ms init 0.03 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.09 ms preparing 0.03 ms executing 0.01 ms Sending data 0.04 ms end 0.01 ms query end 0.02 ms closing tables 0.01 ms freeing items 0.06 ms cleaning up 0.02 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 10 JDatabaseDriver->loadColumn() JROOT/libraries/src/Access/Access.php:980 9 Joomla\CMS\Access\Access::getGroupsByUser() JROOT/libraries/src/Access/Access.php:1095 8 Joomla\CMS\Access\Access::getAuthorisedViewLevels() JROOT/libraries/src/User/User.php:458 7 Joomla\CMS\User\User->getAuthorisedViewLevels() JROOT/libraries/src/Plugin/PluginHelper.php:318 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.93 ms After last query: 0.48 ms Query memory: 0.030 MB Memory before query: 4.715 MB Rows returned: 105
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM jom_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 jom_extensions NULL ref extension extension 82 const 120 0.40 Using index condition; Using where; Using filesort Status Duration starting 0.09 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.04 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.08 ms preparing 0.03 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.02 ms Creating sort index 1.11 ms end 0.01 ms query end 0.02 ms closing tables 0.01 ms freeing items 0.08 ms cleaning up 0.02 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 10 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Plugin/PluginHelper.php:351 9 Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}() Same as call in the line below. 8 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 7 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Plugin/PluginHelper.php:356 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.11 ms After last query: 0.67 ms Query memory: 0.020 MB Memory before query: 4.845 MB Rows returned: 3
SELECT *
FROM jom_languages
WHERE published=1
ORDER BY ordering ASCid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jom_languages NULL ALL NULL NO INDEX KEY COULD BE USED NULL NULL 4 25.00 Using where; Using filesort Status Duration starting 0.06 ms checking permissions 0.01 ms Opening tables 0.30 ms init 0.04 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.02 ms preparing 0.02 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.03 ms Creating sort index 0.09 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.07 ms cleaning up 0.02 ms # Caller File and line number 7 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 6 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Language/LanguageHelper.php:150 5 Joomla\CMS\Language\LanguageHelper::getLanguages() JROOT/libraries/src/Language/LanguageHelper.php:67 4 Joomla\CMS\Language\LanguageHelper::detectLanguage() JROOT/libraries/src/Application/SiteApplication.php:653 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.12 ms After last query: 6.01 ms Query memory: 0.023 MB Memory before query: 5.825 MB Rows returned: 22
SELECT `element`,`name`,`client_id`,`extension_id`
FROM `jom_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 jom_extensions NULL ref extension extension 82 const 22 1.00 Using where Status Duration starting 0.12 ms checking permissions 0.02 ms Opening tables 0.03 ms init 0.04 ms System lock 0.02 ms optimizing 0.03 ms statistics 0.10 ms preparing 0.03 ms executing 0.01 ms Sending data 0.36 ms end 0.02 ms query end 0.02 ms closing tables 0.02 ms freeing items 0.07 ms cleaning up 0.03 ms # Caller File and line number 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 9 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Language/LanguageHelper.php:209 8 Joomla\CMS\Language\LanguageHelper::getInstalledLanguages() JROOT/plugins/system/languagefilter/languagefilter.php:110 7 PlgSystemLanguageFilter->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:280 6 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 5 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/libraries/src/Application/CMSApplication.php:667 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 2.70 ms After last query: 9.05 ms Query memory: 0.069 MB Memory before query: 6.681 MB Rows returned: 37
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 jom_menu AS m
LEFT JOIN jom_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 range idx_client_id_parent_id_alias_language idx_client_id_parent_id_alias_language 5 NULL 56 10.00 Using index condition; Using where; Using filesort 1 SIMPLE e NULL eq_ref PRIMARY PRIMARY 4 1973365-1.m.component_id 1 100.00 Using where Status Duration starting 0.17 ms checking permissions 0.02 ms checking permissions 0.01 ms Opening tables 0.14 ms init 0.07 ms System lock 0.02 ms optimizing 0.03 ms statistics 0.13 ms preparing 0.04 ms Sorting result 0.02 ms executing 0.05 ms Sending data 0.04 ms Creating sort index 1.33 ms end 0.02 ms query end 0.02 ms closing tables 0.02 ms freeing items 0.07 ms cleaning up 0.03 ms # Caller File and line number 23 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 22 JDatabaseDriver->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:78 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:142 15 Joomla\CMS\Menu\AbstractMenu::getInstance() JROOT/libraries/src/Application/CMSApplication.php:417 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:533 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:668 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.04 ms After last query: 3.13 ms Query memory: 0.024 MB Memory before query: 7.161 MB Rows returned: 56
SELECT `name`,`value`
FROM jom_mj_settingsid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jom_mj_settings NULL ALL NULL NO INDEX KEY COULD BE USED NULL NULL 56 100.00 NULL Status Duration starting 0.07 ms checking permissions 0.02 ms Opening tables 0.22 ms init 0.03 ms System lock 0.02 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.02 ms executing 0.01 ms Sending data 0.10 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.10 ms cleaning up 0.02 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506 12 JDatabaseDriver->loadAssocList() JROOT/administrator/components/com_mobilejoomla/legacy/joomlawrapper-3.0.php:63 11 MjJoomlaWrapper30->dbSelectAll() JROOT/administrator/components/com_mobilejoomla/models/settings.php:30 10 MjSettingsModel->__construct() JROOT/administrator/components/com_mobilejoomla/classes/mobilejoomla.php:53 9 MobileJoomla->__construct() JROOT/plugins/system/mobilejoomla/mobilejoomla.php:60 8 plgSystemMobileJoomla->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:668 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.03 ms After last query: 1.66 ms Query memory: 0.024 MB Memory before query: 7.456 MB Rows returned: 0
SELECT `data`
FROM `jom_mj_amdd`
WHERE `ua`='CCBot/2.0 (https://commoncrawl.org/faq/)'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE NULL NULL NULL NULL NO INDEX KEY COULD BE USED NULL NULL NULL NULL no matching row in const table Status Duration starting 0.08 ms checking permissions 0.02 ms Opening tables 0.30 ms init 0.05 ms System lock 0.02 ms optimizing 0.02 ms statistics 0.11 ms executing 0.02 ms end 0.01 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.09 ms cleaning up 0.03 ms # Caller File and line number 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 16 JDatabaseDriver->loadResult() JROOT/administrator/components/com_mobilejoomla/ress/vendor/amdd/database/joomla/db.joomla.php:33 15 AmddDatabaseJoomla->getDevice() JROOT/administrator/components/com_mobilejoomla/ress/vendor/amdd/amdd.php:99 14 Amdd::getDevice() JROOT/administrator/components/com_mobilejoomla/ress/vendor/amdd/amdd.php:55 13 Amdd::getCapabilities() JROOT/plugins/mobile/amdd/amdd.php:52 12 plgMobileAmdd->onDeviceDetection() JROOT/libraries/joomla/event/event.php:70 11 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 10 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 9 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/plugins/system/mobilejoomla/mobilejoomla.php:96 8 plgSystemMobileJoomla->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:668 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 10.14 ms After last query: 34.50 ms Query memory: 0.024 MB Memory before query: 8.265 MB Rows returned: 1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `jom_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jom_extensions NULL ref element_clientid,element_folder_clientid,extension extension 484 const,const 1 100.00 NULL Status Duration starting 0.13 ms checking permissions 0.03 ms Opening tables 0.04 ms init 0.05 ms System lock 0.02 ms optimizing 0.03 ms statistics 0.23 ms preparing 0.04 ms executing 0.01 ms Sending data 0.18 ms end 0.01 ms query end 0.02 ms closing tables 8.74 ms freeing items 0.19 ms cleaning up 0.05 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 18 JDatabaseDriver->loadObject() JROOT/libraries/src/Helper/LibraryHelper.php:167 17 Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}() Same as call in the line below. 16 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 15 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/LibraryHelper.php:175 14 Joomla\CMS\Helper\LibraryHelper::loadLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:43 13 Joomla\CMS\Helper\LibraryHelper::getLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:90 12 Joomla\CMS\Helper\LibraryHelper::getParams() JROOT/libraries/src/Version.php:321 11 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 10 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 9 Joomla\CMS\Factory::getDocument() JROOT/plugins/system/mobilejoomla/mobilejoomla.php:336 8 plgSystemMobileJoomla->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:1190 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 6.12 ms After last query: 0.18 ms Query memory: 0.006 MB Memory before query: 8.258 MB
UPDATE `jom_extensions`
SET `params` = '{\"mediaversion\":\"4cc8ef701b9d0c64c3251be2724073d7\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 UPDATE jom_extensions NULL range element_clientid,element_folder_clientid,extension extension 484 const,const 1 100.00 Using where Status Duration starting 0.12 ms checking permissions 0.02 ms Opening tables 0.07 ms init 0.04 ms System lock 0.30 ms updating 0.33 ms end 0.06 ms Waiting for query cache lock 0.10 ms end 1.42 ms query end 3.04 ms closing tables 0.03 ms freeing items 0.20 ms cleaning up 0.05 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Helper/LibraryHelper.php:117 13 Joomla\CMS\Helper\LibraryHelper::saveParams() JROOT/libraries/src/Version.php:372 12 Joomla\CMS\Version->setMediaVersion() JROOT/libraries/src/Version.php:331 11 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 10 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 9 Joomla\CMS\Factory::getDocument() JROOT/plugins/system/mobilejoomla/mobilejoomla.php:336 8 plgSystemMobileJoomla->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:1190 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.95 ms After last query: 2.31 ms Query memory: 0.021 MB Memory before query: 8.658 MB Rows returned: 0
SELECT p.folder AS `type`, p.element AS `name`
FROM `jom_mj_plugins` AS mj
LEFT JOIN `jom_extensions` AS p
ON p.extension_id=mj.id
WHERE mj.device='desktop'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE NULL NULL NULL NULL NO INDEX KEY COULD BE USED NULL NULL NULL NULL no matching row in const table Status Duration starting 0.13 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.22 ms init 0.06 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.05 ms executing 0.02 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.07 ms cleaning up 0.04 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 10 JDatabaseDriver->loadObjectList() JROOT/plugins/system/mobilejoomla/mobilejoomla.php:686 9 plgSystemMobileJoomla->filterExtensions() JROOT/plugins/system/mobilejoomla/mobilejoomla.php:362 8 plgSystemMobileJoomla->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:1190 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.14 ms After last query: 0.11 ms Query memory: 0.021 MB Memory before query: 8.663 MB Rows returned: 0
SELECT m.id, m.position
FROM `jom_mj_modules` AS mj
LEFT JOIN `jom_modules` AS m
ON m.id=mj.id
WHERE mj.device='desktop'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE NULL NULL NULL NULL NO INDEX KEY COULD BE USED NULL NULL NULL NULL no matching row in const table Status Duration starting 0.06 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.53 ms init 0.03 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.03 ms executing 0.03 ms end 0.03 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.14 ms cleaning up 0.02 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 10 JDatabaseDriver->loadObjectList() JROOT/plugins/system/mobilejoomla/mobilejoomla.php:705 9 plgSystemMobileJoomla->filterExtensions() JROOT/plugins/system/mobilejoomla/mobilejoomla.php:362 8 plgSystemMobileJoomla->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:1190 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 2.28 ms After last query: 0.38 ms Query memory: 0.020 MB Memory before query: 8.684 MB Rows returned: 11
SELECT id, home, template, s.params
FROM jom_template_styles as s
LEFT JOIN jom_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 e NULL ref element_clientid,element_folder_clientid,extension extension 82 const 11 1.00 Using index condition; Using where 1 SIMPLE s NULL ref idx_template,idx_client_id,idx_client_id_home idx_template 202 1973365-1.e.element 1 80.00 Using index condition; Using where Status Duration starting 0.08 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.74 ms init 0.17 ms System lock 0.02 ms optimizing 0.05 ms statistics 0.23 ms preparing 0.08 ms executing 0.01 ms Sending data 0.30 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.13 ms cleaning up 0.03 ms # Caller File and line number 6 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 5 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Application/SiteApplication.php:486 4 Joomla\CMS\Application\SiteApplication->getTemplate() JROOT/libraries/src/Application/SiteApplication.php:168 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 3.23 ms After last query: 3.68 ms Query memory: 0.027 MB Memory before query: 9.145 MB Rows returned: 40
SELECT `id`,`name`,`rules`,`parent_id`
FROM `jom_assets`
WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_easyjoomlabackup','com_fields','com_finder','com_formmaker','com_installer','com_jce','com_joomlaupdate','com_languages','com_login','com_mailto','com_maximenuck','com_media','com_menus','com_messages','com_mobilejoomla','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_tags','com_templates','com_users','com_weblinks','com_wrapper')id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jom_assets NULL ALL idx_asset_name NO INDEX KEY COULD BE USED NULL NULL 244 16.80 Using where Status Duration starting 0.16 ms checking permissions 0.02 ms Opening tables 0.50 ms init 0.12 ms System lock 0.02 ms optimizing 0.02 ms statistics 0.32 ms preparing 0.03 ms executing 0.01 ms Sending data 1.27 ms end 0.05 ms query end 0.02 ms closing tables 0.02 ms freeing items 0.11 ms cleaning up 0.03 ms # Caller File and line number 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 17 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Access/Access.php:429 16 Joomla\CMS\Access\Access::preloadComponents() JROOT/libraries/src/Access/Access.php:213 15 Joomla\CMS\Access\Access::preload() JROOT/libraries/src/Access/Access.php:531 14 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 13 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 12 Joomla\CMS\User\User->authorise() JROOT/components/com_content/models/article.php:58 11 ContentModelArticle->populateState() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457 10 Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() JROOT/components/com_content/models/article.php:251 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.68 ms After last query: 0.12 ms Query memory: 0.054 MB Memory before query: 9.257 MB Rows returned: 146
SELECT `id`,`name`,`rules`,`parent_id`
FROM `jom_assets`
WHERE `name` LIKE 'com_content.%' OR `name` = 'com_content' OR `parent_id` = 0id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jom_assets NULL ALL idx_asset_name,idx_parent_id NO INDEX KEY COULD BE USED NULL NULL 244 22.05 Using where Status Duration starting 0.10 ms checking permissions 0.02 ms Opening tables 0.03 ms init 0.05 ms System lock 0.02 ms optimizing 0.03 ms statistics 0.13 ms preparing 0.03 ms executing 0.01 ms Sending data 0.73 ms end 0.01 ms query end 0.02 ms closing tables 0.02 ms freeing items 0.06 ms cleaning up 0.03 ms # Caller File and line number 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 17 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Access/Access.php:359 16 Joomla\CMS\Access\Access::preloadPermissions() JROOT/libraries/src/Access/Access.php:226 15 Joomla\CMS\Access\Access::preload() JROOT/libraries/src/Access/Access.php:540 14 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 13 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 12 Joomla\CMS\User\User->authorise() JROOT/components/com_content/models/article.php:58 11 ContentModelArticle->populateState() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457 10 Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() JROOT/components/com_content/models/article.php:251 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 2.60 ms After last query: 1.00 ms Query memory: 0.031 MB Memory before query: 9.474 MB Rows returned: 31
SHOW FULL COLUMNS
FROM `jom_content`EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `jom_content`Status Duration starting 0.06 ms checking permissions 0.02 ms checking permissions 0.01 ms Opening tables 0.33 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.02 ms executing 0.02 ms Opening tables 0.51 ms checking permissions 0.07 ms checking permissions 0.03 ms checking permissions 0.03 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.03 ms Sending data 0.21 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms removing tmp table 0.07 ms closing tables 0.01 ms freeing items 0.10 ms cleaning up 0.03 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 15 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:448 14 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:261 13 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:180 12 Joomla\CMS\Table\Table->__construct() JROOT/libraries/src/Table/Content.php:39 11 Joomla\CMS\Table\Content->__construct() JROOT/libraries/src/Table/Table.php:328 10 Joomla\CMS\Table\Table::getInstance() JROOT/components/com_content/models/article.php:253 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.85 ms After last query: 2.00 ms Query memory: 0.005 MB Memory before query: 9.745 MB
UPDATE jom_content
SET `hits` = (`hits` + 1)
WHERE `id` = '117'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 UPDATE jom_content NULL range PRIMARY PRIMARY 4 const 1 100.00 Using where Status Duration starting 0.07 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.03 ms System lock 0.08 ms updating 0.11 ms end 0.01 ms Waiting for query cache lock 0.01 ms end 0.02 ms query end 1.05 ms closing tables 0.03 ms freeing items 0.08 ms cleaning up 0.02 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Table/Table.php:1264 10 Joomla\CMS\Table\Table->hit() JROOT/components/com_content/models/article.php:254 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 2.16 ms After last query: 1.15 ms Query memory: 0.023 MB Memory before query: 9.881 MB Rows returned: 1
SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
FROM jom_content AS a
INNER JOIN jom_categories AS c
on c.id = a.catid
LEFT JOIN jom_users AS u
on u.id = a.created_by
LEFT JOIN jom_categories as parent
ON parent.id = c.parent_id
LEFT JOIN jom_content_rating AS v
ON a.id = v.content_id
WHERE a.id = 117
AND c.published > 0
AND a.language in ('en-GB','*')
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-03-27 17:38:33')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-03-27 17:38:33')
AND (a.state = 1 OR a.state =2)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL const PRIMARY,idx_state,idx_catid,idx_language PRIMARY 4 const 1 100.00 NULL 1 SIMPLE c NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 SIMPLE u NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 SIMPLE parent NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 SIMPLE v NULL const PRIMARY PRIMARY 4 const 0 0.00 unique row not found Status Duration starting 0.27 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 Opening tables 0.83 ms init 0.14 ms System lock 0.02 ms optimizing 0.04 ms statistics 0.20 ms preparing 0.03 ms executing 0.01 ms Sending data 0.08 ms end 0.01 ms query end 0.01 ms closing tables 0.03 ms freeing items 0.10 ms cleaning up 0.03 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 13 JDatabaseDriver->loadObject() JROOT/components/com_content/models/article.php:151 12 ContentModelArticle->getItem() JROOT/libraries/src/MVC/View/HtmlView.php:425 11 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_content/views/article/view.html.php:42 10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.46 ms After last query: 1.74 ms Query memory: 0.028 MB Memory before query: 10.108 MB Rows returned: 2
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM `jom_categories` AS `s`
INNER JOIN `jom_categories` AS `c`
ON (s.lft < c.lft
AND c.lft < s.rgt
AND c.language IN ('en-GB','*')) OR (c.lft <= s.lft
AND s.rgt <= c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id = 79
ORDER BY c.lftid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE s NULL const PRIMARY,idx_left_right PRIMARY 4 const 1 100.00 Using filesort 1 SIMPLE c NULL range cat_idx,idx_access,idx_left_right,idx_language cat_idx 207 NULL 5 44.18 Using index condition; Using where Status Duration starting 0.22 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.10 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.22 ms preparing 0.05 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.04 ms Creating sort index 0.21 ms end 0.01 ms query end 0.02 ms closing tables 0.01 ms freeing items 0.14 ms cleaning up 0.03 ms # Caller File and line number 24 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 23 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 22 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 21 Joomla\CMS\Categories\Categories->get() JROOT/components/com_content/router.php:72 20 ContentRouter->getCategorySegment() Same as call in the line below. 19 call_user_func_array() JROOT/libraries/src/Component/Router/RouterView.php:120 18 Joomla\CMS\Component\Router\RouterView->getPath() JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 17 Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() JROOT/libraries/src/Component/Router/RouterView.php:222 16 Joomla\CMS\Component\Router\RouterView->preprocess() JROOT/libraries/src/Router/SiteRouter.php:676 15 Joomla\CMS\Router\SiteRouter->processBuildRules() JROOT/libraries/src/Router/Router.php:266 14 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155 13 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 12 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 11 Joomla\CMS\Router\Route::_() JROOT/components/com_content/views/article/view.html.php:71 10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 2.12 ms After last query: 0.51 ms Query memory: 0.022 MB Memory before query: 10.161 MB Rows returned: 0
SELECT `m`.`tag_id`,`t`.*
FROM `jom_contentitem_tag_map` AS m
INNER JOIN `jom_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 117
AND `t`.`published` = 1
AND t.access IN (1,1)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL ALL idx_tag_type NO INDEX KEY COULD BE USED NULL NULL 1 100.00 Using where 1 SIMPLE t NULL eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 1973365-1.m.tag_id 1 100.00 Using where Status Duration starting 0.12 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 1.05 ms init 0.10 ms System lock 0.02 ms optimizing 0.03 ms statistics 0.14 ms preparing 0.04 ms executing 0.01 ms Sending data 0.09 ms end 0.01 ms query end 0.02 ms closing tables 0.02 ms freeing items 0.11 ms cleaning up 0.03 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 12 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Helper/TagsHelper.php:454 11 Joomla\CMS\Helper\TagsHelper->getItemTags() JROOT/components/com_content/views/article/view.html.php:184 10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 8.56 ms After last query: 16.98 ms Query memory: 0.025 MB Memory before query: 12.551 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 jom_fields AS a
LEFT JOIN `jom_languages` AS l
ON l.lang_code = a.language
LEFT JOIN jom_users AS uc
ON uc.id=a.checked_out
LEFT JOIN jom_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN jom_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN jom_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `jom_fields_categories` AS fc
ON fc.field_id = a.id
WHERE a.context = 'com_content.article'
AND (fc.category_id IS NULL OR fc.category_id IN (79,0))
AND a.access IN (1,1)
AND (a.group_id = 0 OR g.access IN (1,1))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
AND a.language in ('*','en-GB')
ORDER BY a.ordering ASCid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL ref idx_state,idx_access,idx_language,idx_context idx_state 1 const 1 100.00 Using index condition; Using where; Using temporary; Using filesort 1 SIMPLE l NULL eq_ref idx_langcode idx_langcode 28 1973365-1.a.language 1 100.00 Using where 1 SIMPLE uc NULL eq_ref PRIMARY PRIMARY 4 1973365-1.a.checked_out 1 100.00 NULL 1 SIMPLE ag NULL eq_ref PRIMARY PRIMARY 4 1973365-1.a.access 1 100.00 Using where 1 SIMPLE ua NULL eq_ref PRIMARY PRIMARY 4 1973365-1.a.created_user_id 1 100.00 Using where 1 SIMPLE g NULL eq_ref PRIMARY PRIMARY 4 1973365-1.a.group_id 1 100.00 Using where 1 SIMPLE fc NULL ref PRIMARY PRIMARY 4 1973365-1.a.id 1 100.00 Using where; Using index; Distinct Status Duration starting 0.47 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.02 ms Opening tables 2.17 ms init 0.25 ms System lock 0.03 ms optimizing 0.07 ms statistics 0.41 ms preparing 0.11 ms Creating tmp table 0.56 ms Sorting result 0.04 ms executing 0.02 ms Sending data 0.53 ms Creating sort index 0.11 ms end 0.02 ms query end 0.03 ms removing tmp table 0.10 ms query end 0.02 ms closing tables 0.11 ms freeing items 0.19 ms cleaning up 0.05 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 18 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 17 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_fields/models/fields.php:333 16 FieldsModelFields->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:194 15 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 14 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:495 13 PlgSystemFields->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_content/views/article/view.html.php:193 10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.13 ms After last query: 6.37 ms Query memory: 0.021 MB Memory before query: 13.406 MB Rows returned: 5
SELECT language,id
FROM `jom_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 jom_menu NULL ref idx_client_id_parent_id_alias_language idx_client_id_parent_id_alias_language 1 const 57 1.04 Using where Status Duration starting 0.10 ms checking permissions 0.02 ms Opening tables 0.12 ms init 0.03 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.07 ms preparing 0.03 ms executing 0.01 ms Sending data 0.29 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.09 ms cleaning up 0.02 ms # Caller File and line number 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 9 JDatabaseDriver->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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.09 ms After last query: 0.18 ms Query memory: 0.024 MB Memory before query: 13.417 MB Rows returned: 1
SELECT `alias`
FROM `jom_content`
WHERE id = '117'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jom_content NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.07 ms checking permissions 0.01 ms Opening tables 0.41 ms init 0.03 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.07 ms preparing 0.02 ms executing 0.01 ms Sending data 0.02 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.08 ms cleaning up 0.02 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 18 JDatabaseDriver->loadResult() JROOT/components/com_content/router.php:125 17 ContentRouter->getArticleSegment() Same as call in the line below. 16 call_user_func_array() JROOT/libraries/src/Component/Router/RouterView.php:120 15 Joomla\CMS\Component\Router\RouterView->getPath() JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 14 Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() JROOT/libraries/src/Component/Router/RouterView.php:222 13 Joomla\CMS\Component\Router\RouterView->preprocess() JROOT/libraries/src/Router/SiteRouter.php:676 12 Joomla\CMS\Router\SiteRouter->processBuildRules() JROOT/libraries/src/Router/Router.php:266 11 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155 10 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 9 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 8 Joomla\CMS\Router\Route::_() JROOT/plugins/system/languagefilter/languagefilter.php:763 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.61 ms After last query: 0.07 ms Query memory: 0.024 MB Memory before query: 13.425 MB Rows returned: 1
SELECT alias
FROM jom_content
WHERE id=117id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jom_content NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.06 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.02 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.06 ms preparing 0.01 ms executing 0.01 ms Sending data 0.01 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 1.09 ms cleaning up 0.03 ms # Caller File and line number 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 16 JDatabaseDriver->loadResult() JROOT/components/com_content/helpers/legacyrouter.php:140 15 ContentRouterRulesLegacy->build() JROOT/libraries/src/Component/Router/RouterView.php:244 14 Joomla\CMS\Component\Router\RouterView->build() JROOT/libraries/src/Router/SiteRouter.php:532 13 Joomla\CMS\Router\SiteRouter->buildSefRoute() JROOT/libraries/src/Router/SiteRouter.php:502 12 Joomla\CMS\Router\SiteRouter->_buildSefRoute() JROOT/libraries/src/Router/Router.php:281 11 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155 10 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 9 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 8 Joomla\CMS\Router\Route::_() JROOT/plugins/system/languagefilter/languagefilter.php:763 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 2.25 ms After last query: 0.47 ms Query memory: 0.021 MB Memory before query: 13.465 MB Rows returned: 2
SELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`,CONCAT_WS(':', ca.id, ca.alias) AS `catid`
FROM `jom_content` AS `c`
INNER JOIN `jom_associations` AS `a`
ON a.id = c.`id`
AND a.context='com_content.item'
INNER JOIN `jom_associations` AS `a2`
ON `a`.`key` = `a2`.`key`
INNER JOIN `jom_content` AS `c2`
ON a2.id = c2.`id`
INNER JOIN `jom_categories` AS `ca`
ON `c2`.`catid` = ca.id
AND ca.extension = 'com_content'
WHERE c.id = 117
AND c2.access IN (1,1)
AND c2.language != 'en-GB'
AND (c2.publish_up = '0000-00-00 00:00:00' OR c2.publish_up <= '2023-03-27 17:38:33')
AND (c2.publish_down = '0000-00-00 00:00:00' OR c2.publish_down >= '2023-03-27 17:38:33')
AND c2.state = 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE c NULL const PRIMARY PRIMARY 4 const 1 100.00 Using index 1 SIMPLE a NULL const PRIMARY,idx_key PRIMARY 206 const,const 1 100.00 NULL 1 SIMPLE a2 NULL ref idx_key idx_key 128 const 3 100.00 Using index 1 SIMPLE c2 NULL eq_ref PRIMARY,idx_access,idx_state,idx_catid,idx_language PRIMARY 4 1973365-1.a2.id 1 5.00 Using where 1 SIMPLE ca NULL eq_ref PRIMARY,cat_idx PRIMARY 4 1973365-1.c2.catid 1 41.33 Using where Status Duration starting 0.20 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 Opening tables 0.49 ms init 0.10 ms System lock 0.01 ms optimizing 0.06 ms statistics 0.38 ms preparing 0.05 ms executing 0.01 ms Sending data 0.15 ms end 0.01 ms query end 0.02 ms closing tables 0.03 ms freeing items 0.10 ms cleaning up 0.03 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 10 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Language/Associations.php:115 9 Joomla\CMS\Language\Associations::getAssociations() JROOT/components/com_content/helpers/association.php:76 8 ContentHelperAssociation::getAssociations() JROOT/plugins/system/languagefilter/languagefilter.php:783 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 2.12 ms After last query: 2.06 ms Query memory: 0.024 MB Memory before query: 13.801 MB Rows returned: 12
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM jom_modules AS m
LEFT JOIN jom_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN jom_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 <= '2023-03-27 17:38:33')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-03-27 17:38:33')
AND m.access IN (1,1)
AND m.client_id = 0
AND (mm.menuid = 476 OR mm.menuid <= 0)
AND m.language IN ('en-GB','*')
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,published,newsfeeds,idx_language published 5 NULL 51 1.49 Using index condition; Using where; Using filesort 1 SIMPLE e NULL ref element_clientid,element_folder_clientid element_clientid 403 1973365-1.m.module,const 1 10.00 Using index condition; Using where 1 SIMPLE mm NULL ref PRIMARY PRIMARY 4 1973365-1.m.id 2 40.00 Using where; Using index Status Duration starting 0.13 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.01 ms Opening tables 0.38 ms init 0.07 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.10 ms preparing 0.03 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.01 ms Creating sort index 0.89 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.05 ms cleaning up 0.02 ms # Caller File and line number 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 14 JDatabaseDriver->loadObjectList() Same as call in the line below. 13 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 12 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:441 11 Joomla\CMS\Helper\ModuleHelper::getModuleList() JROOT/libraries/src/Helper/ModuleHelper.php:371 10 Joomla\CMS\Helper\ModuleHelper::load() JROOT/libraries/src/Helper/ModuleHelper.php:87 9 Joomla\CMS\Helper\ModuleHelper::getModules() JROOT/libraries/src/Document/HtmlDocument.php:601 8 Joomla\CMS\Document\HtmlDocument->countModules() JROOT/templates/tourism_and_services/index.php:15 7 require JROOT/templates/tourism_and_services/index.php JROOT/libraries/src/Document/HtmlDocument.php:678 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:740 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:555 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1098 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:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.26 ms After last query: 8.73 ms Query memory: 0.059 MB Memory before query: 14.970 MB Rows returned: 61
SELECT *
FROM jom_modules
WHERE published=1
ORDER BY id ;id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jom_modules NULL index published PRIMARY 4 NULL 71 85.92 Using where Status Duration starting 0.07 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.04 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.06 ms preparing 0.02 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.46 ms end 0.02 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.05 ms cleaning up 0.02 ms # Caller File and line number 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 14 JDatabaseDriver->loadObjectList() JROOT/modules/mod_maximenuck/helper.php:445 13 modMaximenuckHelper::CreateModulesList() JROOT/modules/mod_maximenuck/helper.php:62 12 modMaximenuckHelper::getItems() JROOT/modules/mod_maximenuck/legacy.php:44 11 require JROOT/modules/mod_maximenuck/legacy.php JROOT/modules/mod_maximenuck/mod_maximenuck.php:746 10 include JROOT/modules/mod_maximenuck/mod_maximenuck.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:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 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:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.01 ms After last query: 5.92 ms Query memory: 0.023 MB Memory before query: 15.491 MB Rows returned: 3
SELECT `c2`.`language`,`c2`.`id`
FROM `jom_menu` AS `c`
INNER JOIN `jom_associations` AS `a`
ON a.id = c.`id`
AND a.context='com_menus.item'
INNER JOIN `jom_associations` AS `a2`
ON `a`.`key` = `a2`.`key`
INNER JOIN `jom_menu` AS `c2`
ON a2.id = c2.`id`
WHERE c.id = 476id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE c NULL const PRIMARY PRIMARY 4 const 1 100.00 Using index 1 SIMPLE a NULL const PRIMARY,idx_key PRIMARY 206 const,const 1 100.00 NULL 1 SIMPLE a2 NULL ref idx_key idx_key 128 const 3 100.00 Using index 1 SIMPLE c2 NULL eq_ref PRIMARY PRIMARY 4 1973365-1.a2.id 1 100.00 NULL Status Duration starting 0.12 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.21 ms init 0.04 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.14 ms preparing 0.02 ms executing 0.01 ms Sending data 0.05 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.06 ms cleaning up 0.02 ms # Caller File and line number 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 14 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Language/Associations.php:115 13 Joomla\CMS\Language\Associations::getAssociations() JROOT/administrator/components/com_menus/helpers/menus.php:321 12 MenusHelper::getAssociations() JROOT/modules/mod_languages/helper.php:58 11 ModLanguagesHelper::getList() JROOT/modules/mod_languages/mod_languages.php:17 10 include JROOT/modules/mod_languages/mod_languages.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:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 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:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
30 Query Types Logged, Sorted by Occurrences.
SELECT Tables:
2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `jom_extensions`2 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `jom_assets`1 × SELECT `data`
FROM `jom_session`1 × SELECT `session_id`
FROM `jom_session`1 × SELECT id, rules
FROM `jom_viewlevels1 × SELECT b.id
FROM jom_usergroups AS a
LEFT JOIN jom_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM jom_extensions1 × SELECT *
FROM jom_languages1 × SELECT `element`,`name`,`client_id`,`extension_id`
FROM `jom_extensions`1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM jom_menu AS m
LEFT JOIN jom_extensions AS e
ON m.component_id = e.extension_id1 × SELECT `name`,`value`
FROM jom_mj_setting1 × SELECT `data`
FROM `jom_mj_amdd`1 × SELECT p.folder AS `type`, p.element AS `name`
FROM `jom_mj_plugins` AS mj
LEFT JOIN `jom_extensions` AS p
ON p.extension_id=mj.id1 × SELECT m.id, m.position
FROM `jom_mj_modules` AS mj
LEFT JOIN `jom_modules` AS m
ON m.id=mj.id1 × SELECT id, home, template, s.params
FROM jom_template_styles as s
LEFT JOIN jom_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id1 × SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
FROM jom_content AS a
INNER JOIN jom_categories AS c
on c.id = a.catid
LEFT JOIN jom_users AS u
on u.id = a.created_by
LEFT JOIN jom_categories as parent
ON parent.id = c.parent_id
LEFT JOIN jom_content_rating AS v
ON a.id = v.content_id1 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM `jom_categories` AS `s`
INNER JOIN `jom_categories` AS `c`
ON (s.lft < c.lft
AND c.lft < s.rgt
AND c.language IN ('en-GB','*')) OR (c.lft <= s.lft
AND s.rgt <= c.rgt)1 × SELECT `m`.`tag_id`,`t`.*
FROM `jom_contentitem_tag_map` AS m
INNER JOIN `jom_tags` AS t
ON `m`.`tag_id` = `t`.`id`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 jom_fields AS a
LEFT JOIN `jom_languages` AS l
ON l.lang_code = a.language
LEFT JOIN jom_users AS uc
ON uc.id=a.checked_out
LEFT JOIN jom_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN jom_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN jom_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `jom_fields_categories` AS fc
ON fc.field_id = a.id1 × SELECT language,id
FROM `jom_menu`1 × SELECT `alias`
FROM `jom_content`1 × SELECT alias
FROM jom_content1 × SELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`,CONCAT_WS(':', ca.id, ca.alias) AS `catid`
FROM `jom_content` AS `c`
INNER JOIN `jom_associations` AS `a`
ON a.id = c.`id`
AND a.context='com_content.item'
INNER JOIN `jom_associations` AS `a2`
ON `a`.`key` = `a2`.`key`
INNER JOIN `jom_content` AS `c2`
ON a2.id = c2.`id`
INNER JOIN `jom_categories` AS `ca`
ON `c2`.`catid` = ca.id
AND ca.extension = 'com_content'1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM jom_modules AS m
LEFT JOIN jom_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN jom_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id1 × SELECT *
FROM jom_modules1 × SELECT `c2`.`language`,`c2`.`id`
FROM `jom_menu` AS `c`
INNER JOIN `jom_associations` AS `a`
ON a.id = c.`id`
AND a.context='com_menus.item'
INNER JOIN `jom_associations` AS `a2`
ON `a`.`key` = `a2`.`key`
INNER JOIN `jom_menu` AS `c2`
ON a2.id = c2.`id`
OTHER Tables:
1 × INSERT INTO `jom_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'3265356233623030316532633264346635333432616631656232663364626265', 1, 1679938712, 0, '', 01 × UPDATE `jom_extensions`
SET `params` = '{\"mediaversion\":\"4cc8ef701b9d0c64c3251be2724073d7\"}'1 × SHOW FULL COLUMNS
FROM `jom_content1 × UPDATE jom_content
SET `hits` = (`hits` + 1)