Related articles
Unfortunately, nothing is found
Add new article!
If you have some content, that you would like to share with all crimean tatars, you can share it here easily!
Joomla! Debug Console
{
"__default": {
"session": {
"counter": 1,
"timer": {
"start": 1713889318,
"last": 1713889318,
"now": 1713889318
}
},
"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: 6.25 ms / 6.25 ms Memory: 0.504 MB / 0.89 MB Application: afterLoad
Time: 31.98 ms / 38.23 ms Memory: 1.354 MB / 2.24 MB Application: afterInitialise
Time: 15.72 ms / 53.95 ms Memory: 0.587 MB / 2.83 MB Application: afterRoute
Time: 0.22 ms / 54.17 ms Memory: 0.005 MB / 2.83 MB Application: beforeRenderComponent com_gantry5
Time: 0.20 ms / 54.36 ms Memory: 0.002 MB / 2.83 MB Application: afterRenderComponent com_gantry5
Time: 2.71 ms / 57.07 ms Memory: 0.021 MB / 2.85 MB Application: afterDispatch
Time: 46.08 ms / 103.15 ms Memory: 4.696 MB / 7.55 MB Application: beforeRenderModule mod_languages_custom (Languages Custom)
Time: 2.64 ms / 105.79 ms Memory: 0.119 MB / 7.67 MB Application: afterRenderModule mod_languages_custom (Languages Custom)
Time: 0.08 ms / 105.87 ms Memory: 0.001 MB / 7.67 MB Application: Before Access::preloadComponents (all components)
Time: 1.17 ms / 107.03 ms Memory: 0.049 MB / 7.72 MB Application: After Access::preloadComponents (all components)
Time: 0.07 ms / 107.10 ms Memory: -0.001 MB / 7.72 MB Application: Before Access::getAssetRules (id:16 name:com_menus)
Time: 0.52 ms / 107.62 ms Memory: 0.009 MB / 7.73 MB Application: After Access::getAssetRules (id:16 name:com_menus)
Time: 0.74 ms / 108.36 ms Memory: -0.081 MB / 7.65 MB Application: beforeRenderModule mod_user_dashboard_mini (User Dashboard Mini)
Time: 6.43 ms / 114.78 ms Memory: 0.081 MB / 7.73 MB Application: afterRenderModule mod_user_dashboard_mini (User Dashboard Mini)
Time: 0.35 ms / 115.13 ms Memory: -0.000 MB / 7.73 MB Application: beforeRenderModule mod_ilimhane (Ilimhane)
Time: 4.93 ms / 120.06 ms Memory: 0.139 MB / 7.87 MB Application: afterRenderModule mod_ilimhane (Ilimhane)
Time: 1.08 ms / 121.14 ms Memory: 0.010 MB / 7.88 MB Application: beforeRenderModule mod_user_dashboard_mini (User Dashboard Mini)
Time: 5.31 ms / 126.46 ms Memory: 0.076 MB / 7.95 MB Application: afterRenderModule mod_user_dashboard_mini (User Dashboard Mini)
Time: 16.31 ms / 142.77 ms Memory: 0.740 MB / 8.69 MB Application: afterRender
Database queries total: 24.00 ms
9.04 MB (9,483,200 Bytes)
26 Queries Logged 24.00 ms
8 duplicate found!
- Query Time: 0.30 ms Query memory: 0.020 MB Memory before query: 1.263 MB Rows returned: 0
SELECT `session_id`
FROM `joom_session`
WHERE `session_id` = X'3535613063373164643862623338623335333164623034613839623237336264'
LIMIT 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE joom_session NULL const PRIMARY PRIMARY 194 const 1 100.00 Using index Status Duration starting 0.03 ms checking permissions 0.00 ms Opening tables 0.09 ms init 0.01 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.03 ms executing 0.01 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.02 ms cleaning up 0.00 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:153 6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:760 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:135 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:344 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:47 - Query Time: 0.24 ms After last query: 0.12 ms Query memory: 0.004 MB Memory before query: 1.269 MB
INSERT INTO `joom_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'3535613063373164643862623338623335333164623034613839623237336264', 1, 1713889318, 0, '', 0)EXPLAIN not possible on query: INSERT INTO `joom_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3535613063373164643862623338623335333164623034613839623237336264', 1, 1713889318, 0, '', 0)Status Duration starting 0.04 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.01 ms System lock 0.00 ms update 0.08 ms end 0.00 ms query end 0.04 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 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:153 6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:760 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:135 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:344 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:47 - Query Time: 0.64 ms After last query: 1.53 ms Query memory: 0.024 MB Memory before query: 1.305 MB Rows returned: 40
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `joom_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 joom_extensions NULL ref extension extension 82 const 40 1.00 Using where Status Duration starting 0.04 ms checking permissions 0.01 ms Opening tables 0.08 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.01 ms executing 0.00 ms Sending data 0.21 ms end 0.00 ms query end 0.00 ms closing tables 0.02 ms freeing items 0.02 ms cleaning up 0.00 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:51 - Query Time: 0.30 ms After last query: 1.34 ms Query memory: 0.021 MB Memory before query: 1.337 MB Rows returned: 7
SELECT id, rules
FROM `joom_viewlevels`id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE joom_viewlevels NULL ALL NULL NO INDEX KEY COULD BE USED NULL NULL 7 100.00 NULL Status Duration starting 0.03 ms checking permissions 0.00 ms Opening tables 0.09 ms init 0.01 ms System lock 0.02 ms optimizing 0.00 ms statistics 0.01 ms preparing 0.01 ms executing 0.00 ms Sending data 0.03 ms end 0.00 ms query end 0.00 ms closing tables 0.02 ms freeing items 0.02 ms cleaning up 0.00 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:1061 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:321 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:51 - Query Time: 0.34 ms After last query: 0.13 ms Query memory: 0.021 MB Memory before query: 1.350 MB Rows returned: 2
SELECT b.id
FROM joom_usergroups AS a
LEFT JOIN joom_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 9id 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 2 100.00 Using where; Using index Status Duration starting 0.03 ms checking permissions 0.01 ms checking permissions 0.00 ms Opening tables 0.09 ms init 0.02 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.06 ms preparing 0.01 ms executing 0.00 ms Sending data 0.02 ms end 0.00 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.02 ms cleaning up 0.00 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:978 9 Joomla\CMS\Access\Access::getGroupsByUser() JROOT/libraries/src/Access/Access.php:1093 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:321 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:51 - Query Time: 1.21 ms After last query: 0.33 ms Query memory: 0.030 MB Memory before query: 1.373 MB Rows returned: 104
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM joom_extensions
WHERE enabled = 1
AND type = 'plugin'
AND state IN (0,1)
AND access IN (1,1,5)
ORDER BY orderingid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE joom_extensions NULL ref extension extension 82 const 150 0.60 Using index condition; Using where; Using filesort Status Duration starting 0.04 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.02 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.01 ms Creating sort index 0.90 ms end 0.00 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.00 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:354 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:359 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:51 - Query Time: 0.56 ms After last query: 10.03 ms Query memory: 0.021 MB Memory before query: 1.900 MB Rows returned: 2
SELECT *
FROM joom_languages
WHERE published=1
ORDER BY ordering ASCid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE joom_languages NULL ALL NULL NO INDEX KEY COULD BE USED NULL NULL 3 33.33 Using where; Using filesort Status Duration starting 0.04 ms checking permissions 0.01 ms Opening tables 0.17 ms init 0.02 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms Sorting result 0.00 ms executing 0.01 ms Sending data 0.01 ms Creating sort index 0.07 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 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:150 8 Joomla\CMS\Language\LanguageHelper::getLanguages() JROOT/plugins/system/languagefilter/languagefilter.php:96 7 PlgSystemLanguageFilter->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:283 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:625 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:51 - Query Time: 0.27 ms After last query: 0.11 ms Query memory: 0.021 MB Memory before query: 1.908 MB Rows returned: 6
SELECT `element`,`name`,`client_id`,`extension_id`
FROM `joom_extensions`
WHERE `type` = 'language'
AND `state` = 0
AND `enabled` = 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE joom_extensions NULL ref extension extension 82 const 6 1.00 Using where Status Duration starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.01 ms executing 0.00 ms Sending data 0.05 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 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:283 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:625 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:51 - Query Time: 1.64 ms After last query: 3.54 ms Query memory: 0.078 MB Memory before query: 2.053 MB Rows returned: 56
SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM joom_menu AS m
LEFT JOIN joom_extensions AS e
ON m.component_id = e.extension_id
WHERE m.published = 1
AND m.parent_id > 0
AND m.client_id = 0
ORDER BY m.lftid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL ALL idx_client_id_parent_id_alias_language NO INDEX KEY COULD BE USED NULL NULL 150 8.27 Using where; Using filesort 1 SIMPLE e NULL eq_ref PRIMARY PRIMARY 4 baycik_diyar.m.component_id 1 100.00 Using where Status Duration starting 0.16 ms checking permissions 0.01 ms checking permissions 0.00 ms Opening tables 0.10 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.00 ms Sending data 0.02 ms Creating sort index 1.02 ms end 0.01 ms query end 0.01 ms closing tables 0.04 ms freeing items 0.03 ms cleaning up 0.00 ms # Caller File and line number 24 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 23 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Menu/SiteMenu.php:93 22 Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}() Same as call in the line below. 21 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 20 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Menu/SiteMenu.php:101 19 Joomla\CMS\Menu\SiteMenu->load() JROOT/libraries/src/Menu/AbstractMenu.php:76 18 Joomla\CMS\Menu\AbstractMenu->__construct() JROOT/libraries/src/Menu/SiteMenu.php:62 17 Joomla\CMS\Menu\SiteMenu->__construct() JROOT/libraries/src/Menu/AbstractMenu.php:131 16 Joomla\CMS\Menu\AbstractMenu::getInstance() JROOT/libraries/src/Application/CMSApplication.php:375 15 Joomla\CMS\Application\CMSApplication->getMenu() JROOT/libraries/src/Application/SiteApplication.php:275 14 Joomla\CMS\Application\SiteApplication->getMenu() JROOT/libraries/src/Router/SiteRouter.php:65 13 Joomla\CMS\Router\SiteRouter->__construct() JROOT/libraries/src/Router/Router.php:189 12 Joomla\CMS\Router\Router::getInstance() JROOT/libraries/src/Application/CMSApplication.php:491 11 Joomla\CMS\Application\CMSApplication::getRouter() JROOT/libraries/src/Application/SiteApplication.php:403 10 Joomla\CMS\Application\SiteApplication::getRouter() JROOT/plugins/system/languagefilter/languagefilter.php:145 9 PlgSystemLanguageFilter->onAfterInitialise() Same as call in the line below. 8 call_user_func_array() 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:626 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:51 - Query Time: 0.83 ms After last query: 4.64 ms Query memory: 0.025 MB Memory before query: 2.334 MB Rows returned: 37
SELECT id, home, template, s.params
FROM joom_template_styles as s
LEFT JOIN joom_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
WHERE s.client_id = 0
AND e.enabled = 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE e NULL ref element_clientid,element_folder_clientid,extension extension 82 const 6 1.00 Using index condition; Using where 1 SIMPLE s NULL ref idx_template,idx_client_id,idx_client_id_home idx_template 202 baycik_diyar.e.element 6 94.87 Using index condition; Using where Status Duration starting 0.06 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.08 ms init 0.03 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.10 ms preparing 0.05 ms executing 0.00 ms Sending data 0.32 ms end 0.01 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.03 ms cleaning up 0.00 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 12 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Application/SiteApplication.php:486 11 Joomla\CMS\Application\SiteApplication->getTemplate() JROOT/plugins/system/gantry5/gantry5.php:195 10 plgSystemGantry5->onAfterRouteSite() JROOT/plugins/system/gantry5/gantry5.php:57 9 plgSystemGantry5->onAfterRoute() Same as call in the line below. 8 call_user_func_array() 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:1122 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:51 - Query Time: 0.36 ms After last query: 5.94 ms Query memory: 0.026 MB Memory before query: 2.681 MB Rows returned: 1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `joom_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE joom_extensions NULL ref element_clientid,element_folder_clientid,extension extension 484 const,const 1 100.00 NULL Status Duration starting 0.05 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.08 ms preparing 0.01 ms executing 0.00 ms Sending data 0.08 ms end 0.00 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.00 ms # Caller File and line number 25 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 24 JDatabaseDriver->loadObject() JROOT/libraries/src/Helper/LibraryHelper.php:167 23 Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}() Same as call in the line below. 22 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 21 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/LibraryHelper.php:175 20 Joomla\CMS\Helper\LibraryHelper::loadLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:43 19 Joomla\CMS\Helper\LibraryHelper::getLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:90 18 Joomla\CMS\Helper\LibraryHelper::getParams() JROOT/libraries/src/Version.php:321 17 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 16 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 15 Joomla\CMS\Factory::getDocument() JROOT/libraries/gantry5/classes/Gantry/Framework/Theme.php:163 14 Gantry\Framework\Theme->init() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:67 13 Gantry\Component\Theme\AbstractTheme->__construct() JROOT/templates/g5_helium/includes/theme.php:28 12 plgSystemGantry5->{closure}() JROOT/libraries/gantry5/vendor/pimple/pimple/src/Pimple/Container.php:118 11 Pimple\Container->offsetGet() JROOT/plugins/system/gantry5/gantry5.php:234 10 plgSystemGantry5->onAfterRouteSite() JROOT/plugins/system/gantry5/gantry5.php:57 9 plgSystemGantry5->onAfterRoute() Same as call in the line below. 8 call_user_func_array() 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:1122 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:51 - Query Time: 0.36 ms After last query: 0.14 ms Query memory: 0.009 MB Memory before query: 2.675 MB
UPDATE `joom_extensions`
SET `params` = '{\"mediaversion\":\"75c9e577e0f17ee3941e9698290a263c\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 UPDATE joom_extensions NULL range element_clientid,element_folder_clientid,extension extension 484 const,const 1 100.00 Using where Status Duration starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.03 ms System lock 0.07 ms updating 0.07 ms end 0.01 ms query end 0.06 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms # Caller File and line number 20 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Helper/LibraryHelper.php:117 19 Joomla\CMS\Helper\LibraryHelper::saveParams() JROOT/libraries/src/Version.php:372 18 Joomla\CMS\Version->setMediaVersion() JROOT/libraries/src/Version.php:331 17 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 16 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 15 Joomla\CMS\Factory::getDocument() JROOT/libraries/gantry5/classes/Gantry/Framework/Theme.php:163 14 Gantry\Framework\Theme->init() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:67 13 Gantry\Component\Theme\AbstractTheme->__construct() JROOT/templates/g5_helium/includes/theme.php:28 12 plgSystemGantry5->{closure}() JROOT/libraries/gantry5/vendor/pimple/pimple/src/Pimple/Container.php:118 11 Pimple\Container->offsetGet() JROOT/plugins/system/gantry5/gantry5.php:234 10 plgSystemGantry5->onAfterRouteSite() JROOT/plugins/system/gantry5/gantry5.php:57 9 plgSystemGantry5->onAfterRoute() Same as call in the line below. 8 call_user_func_array() 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:1122 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:51 - Query Time: 0.50 ms After last query: 2.80 ms Query memory: 0.027 MB Memory before query: 2.824 MB Rows returned: 33
SELECT s.id, s.template, s.home, s.title AS long_title, s.params
FROM joom_template_styles AS s
WHERE s.client_id = 0
AND s.template = 'g5_helium'
ORDER BY s.idid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE s NULL index idx_template,idx_client_id,idx_client_id_home PRIMARY 4 NULL 39 80.28 Using where Status Duration starting 0.05 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.07 ms preparing 0.02 ms Sorting result 0.00 ms executing 0.00 ms Sending data 0.18 ms end 0.00 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.03 ms cleaning up 0.01 ms # Caller File and line number 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 16 JDatabaseDriver->loadObjectList() JROOT/libraries/gantry5/classes/Gantry/Joomla/StyleHelper.php:46 15 Gantry\Joomla\StyleHelper::loadStyles() JROOT/libraries/gantry5/classes/Gantry/Framework/Assignments.php:50 14 Gantry\Framework\Assignments->loadAssignments() JROOT/libraries/gantry5/classes/Gantry/Component/Assignments/AbstractAssignments.php:303 13 Gantry\Component\Assignments\AbstractAssignments->init() JROOT/libraries/gantry5/classes/Gantry/Component/Assignments/AbstractAssignments.php:104 12 Gantry\Component\Assignments\AbstractAssignments->scores() JROOT/libraries/gantry5/classes/Gantry/Component/Assignments/AbstractAssignments.php:91 11 Gantry\Component\Assignments\AbstractAssignments->select() JROOT/plugins/system/gantry5/gantry5.php:246 10 plgSystemGantry5->onAfterRouteSite() JROOT/plugins/system/gantry5/gantry5.php:57 9 plgSystemGantry5->onAfterRoute() Same as call in the line below. 8 call_user_func_array() 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:1122 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:51 - Query Time: 0.41 ms After last query: 40.99 ms Query memory: 0.035 MB Memory before query: 6.981 MB Rows returned: 4
SELECT a.menutype
FROM joom_menu_types AS a
WHERE a.client_id = 0id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL ALL NULL NO INDEX KEY COULD BE USED NULL NULL 4 25.00 Using where Status Duration starting 0.06 ms checking permissions 0.01 ms Opening tables 0.10 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.01 ms executing 0.00 ms Sending data 0.04 ms end 0.00 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.04 ms cleaning up 0.01 ms # Caller File and line number 45 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 44 JDatabaseDriver->loadColumn() JROOT/administrator/components/com_menus/helpers/menus.php:154 43 MenusHelper::getMenuTypes() JROOT/libraries/gantry5/classes/Gantry/Framework/Menu.php:71 42 Gantry\Framework\Menu->getMenus() JROOT/libraries/gantry5/classes/Gantry/Component/Menu/AbstractMenu.php:115 41 Gantry\Component\Menu\AbstractMenu->instance() Same as call in the line below. 40 call_user_func_array() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:704 39 Twig\Template->getAttribute() JROOT/cache/gantry5/g5_helium/twig/6f/6f6efd2cbae7b8a2f3ef2d9fcdd2994778476ec2582eb564f90b19871344036e.php:31 38 __TwigTemplate_d263f579c8fe48262eca10b688e33707f3c6d7b5cff39596469a169893690e33->doDisplay() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 37 Twig\Template->displayWithErrorHandling() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 36 Twig\Template->display() JROOT/cache/gantry5/g5_helium/twig/43/4381d28d64cd975d4bbc65ccd08fd905efb17597742fa402c881bea16f41ff5f.php:71 35 __TwigTemplate_31abb5d75caeb3e91290b7b0ef453a194196eae94181655d9fe5baf108036a80->doDisplay() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 34 Twig\Template->displayWithErrorHandling() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 33 Twig\Template->display() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:434 32 Twig\Template->render() JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47 31 Twig\TemplateWrapper->render() JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384 30 Twig\Environment->render() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163 29 Gantry\Component\Theme\AbstractTheme->render() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:766 28 Gantry\Framework\Theme->getContent() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:666 27 Gantry\Framework\Theme->renderContent() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:593 26 Gantry\Framework\Theme->prepareLayout() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579 25 Gantry\Framework\Theme->prepareLayout() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579 24 Gantry\Framework\Theme->prepareLayout() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579 23 Gantry\Framework\Theme->prepareLayout() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:422 22 Gantry\Framework\Theme->segments() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:702 21 Twig\Template->getAttribute() JROOT/cache/gantry5/g5_helium/twig/33/338d1ce3e48aeca3c38dcaa34b84b0db9f26e4cdc7d62420ac1e48e9522c3306.php:47 20 __TwigTemplate_11b94903ac9c38de4bb2105a5066ee742973b4957d19cccc6fa09167e85a5546->doDisplay() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 19 Twig\Template->displayWithErrorHandling() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 18 Twig\Template->display() JROOT/cache/gantry5/g5_helium/twig/5a/5a9c061f91d7ca9e615210fa73ebddac3d62aa7de47b8be54b4a5f3517f4cab8.php:35 17 __TwigTemplate_277af7fe659c06d904eb257d5eb4bd19d8ee1919fab0c34eba6f071815650844->doDisplay() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 16 Twig\Template->displayWithErrorHandling() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 15 Twig\Template->display() JROOT/cache/gantry5/g5_helium/twig/54/546c22eede2b41fbdf4f134b6757afffe7a54ce26a7295501abc0a81a19bdbb9.php:35 14 __TwigTemplate_97f532d943bf881f0138e74af281e2606c8525f3ee65d2e711ad60e46a5eb82e->doDisplay() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 13 Twig\Template->displayWithErrorHandling() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 12 Twig\Template->display() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:434 11 Twig\Template->render() JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47 10 Twig\TemplateWrapper->render() JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384 9 Twig\Environment->render() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163 8 Gantry\Component\Theme\AbstractTheme->render() JROOT/templates/g5_helium/index.php:23 7 require JROOT/templates/g5_helium/index.php JROOT/libraries/src/Document/HtmlDocument.php:668 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:730 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:545 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1030 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:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:51 - Query Time: 1.21 ms After last query: 7.08 ms Query memory: 0.046 MB Memory before query: 7.514 MB Rows returned: 29Duplicate queries: #26
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM joom_modules AS m
LEFT JOIN joom_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN joom_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
WHERE m.published = 1
AND e.enabled = 1
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2024-04-23 16:21:58')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-04-23 16:21:58')
AND m.access IN (1,1,5)
AND m.client_id = 0
AND (mm.menuid = 227 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 ALL PRIMARY,published,newsfeeds,idx_language NO INDEX KEY COULD BE USED NULL NULL 46 2.17 Using where; Using filesort 1 SIMPLE e NULL ref element_clientid,element_folder_clientid element_clientid 403 baycik_diyar.m.module,const 1 10.00 Using index condition; Using where 1 SIMPLE mm NULL ref PRIMARY PRIMARY 4 baycik_diyar.m.id 1 40.00 Using where; Using index Status Duration starting 0.09 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.12 ms init 0.05 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.61 ms end 0.01 ms query end 0.01 ms closing tables 0.04 ms freeing items 0.04 ms cleaning up 0.00 ms # Caller File and line number 63 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 62 JDatabaseDriver->loadObjectList() Same as call in the line below. 61 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 60 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:432 59 Joomla\CMS\Helper\ModuleHelper::getModuleList() JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:276 58 Gantry\Framework\Platform->getModuleList() JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:269 57 Gantry\Framework\Platform->getModule() JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:183 56 Gantry\Framework\Platform->displayModule() Same as call in the line below. 55 call_user_func_array() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:704 54 Twig\Template->getAttribute() JROOT/cache/gantry5/g5_helium/twig/f3/f33e020a7c995c3091226ca5bf2951dd75aa163487741287c6ac4232bb3ab724.php:43 53 __TwigTemplate_fa24ad7ba18b08a067dfafc88f8f31a8672f91eab329b460a51c1786e9023d78->block_particle() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:216 52 Twig\Template->displayBlock() JROOT/cache/gantry5/g5_helium/twig/72/72fe691d71be39d50030851067d8119b7647bba7855e0d1db5389a5d2ee3b093.php:73 51 __TwigTemplate_65b2adc0b8fc17c3166ffc5b2c534f81cd1ec81c50d53706d96ed2bd3d2c3700->doDisplay() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 50 Twig\Template->displayWithErrorHandling() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 49 Twig\Template->display() JROOT/cache/gantry5/g5_helium/twig/f3/f33e020a7c995c3091226ca5bf2951dd75aa163487741287c6ac4232bb3ab724.php:35 48 __TwigTemplate_fa24ad7ba18b08a067dfafc88f8f31a8672f91eab329b460a51c1786e9023d78->doDisplay() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 47 Twig\Template->displayWithErrorHandling() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 46 Twig\Template->display() JROOT/cache/gantry5/g5_helium/twig/6f/6f6efd2cbae7b8a2f3ef2d9fcdd2994778476ec2582eb564f90b19871344036e.php:165 45 __TwigTemplate_d263f579c8fe48262eca10b688e33707f3c6d7b5cff39596469a169893690e33->getdisplayParticle() JROOT/cache/gantry5/g5_helium/twig/6f/6f6efd2cbae7b8a2f3ef2d9fcdd2994778476ec2582eb564f90b19871344036e.php:371 44 __TwigTemplate_d263f579c8fe48262eca10b688e33707f3c6d7b5cff39596469a169893690e33->getdisplayItem() JROOT/cache/gantry5/g5_helium/twig/6f/6f6efd2cbae7b8a2f3ef2d9fcdd2994778476ec2582eb564f90b19871344036e.php:529 43 __TwigTemplate_d263f579c8fe48262eca10b688e33707f3c6d7b5cff39596469a169893690e33->getdisplayItems() JROOT/cache/gantry5/g5_helium/twig/6f/6f6efd2cbae7b8a2f3ef2d9fcdd2994778476ec2582eb564f90b19871344036e.php:474 42 __TwigTemplate_d263f579c8fe48262eca10b688e33707f3c6d7b5cff39596469a169893690e33->getdisplayContainers() JROOT/cache/gantry5/g5_helium/twig/6f/6f6efd2cbae7b8a2f3ef2d9fcdd2994778476ec2582eb564f90b19871344036e.php:589 41 __TwigTemplate_d263f579c8fe48262eca10b688e33707f3c6d7b5cff39596469a169893690e33->getdisplaySubmenu() JROOT/cache/gantry5/g5_helium/twig/6f/6f6efd2cbae7b8a2f3ef2d9fcdd2994778476ec2582eb564f90b19871344036e.php:414 40 __TwigTemplate_d263f579c8fe48262eca10b688e33707f3c6d7b5cff39596469a169893690e33->getdisplayItem() JROOT/cache/gantry5/g5_helium/twig/6f/6f6efd2cbae7b8a2f3ef2d9fcdd2994778476ec2582eb564f90b19871344036e.php:529 39 __TwigTemplate_d263f579c8fe48262eca10b688e33707f3c6d7b5cff39596469a169893690e33->getdisplayItems() JROOT/cache/gantry5/g5_helium/twig/6f/6f6efd2cbae7b8a2f3ef2d9fcdd2994778476ec2582eb564f90b19871344036e.php:82 38 __TwigTemplate_d263f579c8fe48262eca10b688e33707f3c6d7b5cff39596469a169893690e33->doDisplay() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 37 Twig\Template->displayWithErrorHandling() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 36 Twig\Template->display() JROOT/cache/gantry5/g5_helium/twig/43/4381d28d64cd975d4bbc65ccd08fd905efb17597742fa402c881bea16f41ff5f.php:71 35 __TwigTemplate_31abb5d75caeb3e91290b7b0ef453a194196eae94181655d9fe5baf108036a80->doDisplay() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 34 Twig\Template->displayWithErrorHandling() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 33 Twig\Template->display() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:434 32 Twig\Template->render() JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47 31 Twig\TemplateWrapper->render() JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384 30 Twig\Environment->render() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163 29 Gantry\Component\Theme\AbstractTheme->render() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:766 28 Gantry\Framework\Theme->getContent() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:666 27 Gantry\Framework\Theme->renderContent() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:593 26 Gantry\Framework\Theme->prepareLayout() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579 25 Gantry\Framework\Theme->prepareLayout() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579 24 Gantry\Framework\Theme->prepareLayout() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579 23 Gantry\Framework\Theme->prepareLayout() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:422 22 Gantry\Framework\Theme->segments() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:702 21 Twig\Template->getAttribute() JROOT/cache/gantry5/g5_helium/twig/33/338d1ce3e48aeca3c38dcaa34b84b0db9f26e4cdc7d62420ac1e48e9522c3306.php:47 20 __TwigTemplate_11b94903ac9c38de4bb2105a5066ee742973b4957d19cccc6fa09167e85a5546->doDisplay() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 19 Twig\Template->displayWithErrorHandling() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 18 Twig\Template->display() JROOT/cache/gantry5/g5_helium/twig/5a/5a9c061f91d7ca9e615210fa73ebddac3d62aa7de47b8be54b4a5f3517f4cab8.php:35 17 __TwigTemplate_277af7fe659c06d904eb257d5eb4bd19d8ee1919fab0c34eba6f071815650844->doDisplay() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 16 Twig\Template->displayWithErrorHandling() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 15 Twig\Template->display() JROOT/cache/gantry5/g5_helium/twig/54/546c22eede2b41fbdf4f134b6757afffe7a54ce26a7295501abc0a81a19bdbb9.php:35 14 __TwigTemplate_97f532d943bf881f0138e74af281e2606c8525f3ee65d2e711ad60e46a5eb82e->doDisplay() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 13 Twig\Template->displayWithErrorHandling() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 12 Twig\Template->display() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:434 11 Twig\Template->render() JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47 10 Twig\TemplateWrapper->render() JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384 9 Twig\Environment->render() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163 8 Gantry\Component\Theme\AbstractTheme->render() JROOT/templates/g5_helium/index.php:23 7 require JROOT/templates/g5_helium/index.php JROOT/libraries/src/Document/HtmlDocument.php:668 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:730 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:545 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1030 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:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:51 - Query Time: 0.50 ms After last query: 1.27 ms Query memory: 0.042 MB Memory before query: 7.583 MB Rows returned: 2
SELECT `c2`.`language`,`c2`.`id`
FROM `joom_menu` AS `c`
INNER JOIN `joom_associations` AS `a`
ON a.id = c.`id`
AND a.context='com_menus.item'
INNER JOIN `joom_associations` AS `a2`
ON `a`.`key` = `a2`.`key`
INNER JOIN `joom_menu` AS `c2`
ON a2.id = c2.`id`
WHERE c.id = 227id 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 2 100.00 Using index 1 SIMPLE c2 NULL eq_ref PRIMARY PRIMARY 4 baycik_diyar.a2.id 1 100.00 NULL Status Duration starting 0.04 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.14 ms init 0.02 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.11 ms preparing 0.01 ms executing 0.00 ms Sending data 0.03 ms end 0.00 ms query end 0.00 ms closing tables 0.03 ms freeing items 0.02 ms cleaning up 0.00 ms # Caller File and line number 64 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 63 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Language/Associations.php:115 62 Joomla\CMS\Language\Associations::getAssociations() JROOT/administrator/components/com_menus/helpers/menus.php:321 61 MenusHelper::getAssociations() JROOT/modules/mod_languages_custom/helper.php:58 60 ModLanguagesCustomHelper::getList() JROOT/modules/mod_languages_custom/mod_languages_custom.php:17 59 include JROOT/modules/mod_languages_custom/mod_languages_custom.php JROOT/libraries/src/Helper/ModuleHelper.php:200 58 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 57 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:195 56 Gantry\Framework\Platform->displayModule() Same as call in the line below. 55 call_user_func_array() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:704 54 Twig\Template->getAttribute() JROOT/cache/gantry5/g5_helium/twig/f3/f33e020a7c995c3091226ca5bf2951dd75aa163487741287c6ac4232bb3ab724.php:43 53 __TwigTemplate_fa24ad7ba18b08a067dfafc88f8f31a8672f91eab329b460a51c1786e9023d78->block_particle() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:216 52 Twig\Template->displayBlock() JROOT/cache/gantry5/g5_helium/twig/72/72fe691d71be39d50030851067d8119b7647bba7855e0d1db5389a5d2ee3b093.php:73 51 __TwigTemplate_65b2adc0b8fc17c3166ffc5b2c534f81cd1ec81c50d53706d96ed2bd3d2c3700->doDisplay() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 50 Twig\Template->displayWithErrorHandling() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 49 Twig\Template->display() JROOT/cache/gantry5/g5_helium/twig/f3/f33e020a7c995c3091226ca5bf2951dd75aa163487741287c6ac4232bb3ab724.php:35 48 __TwigTemplate_fa24ad7ba18b08a067dfafc88f8f31a8672f91eab329b460a51c1786e9023d78->doDisplay() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 47 Twig\Template->displayWithErrorHandling() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 46 Twig\Template->display() JROOT/cache/gantry5/g5_helium/twig/6f/6f6efd2cbae7b8a2f3ef2d9fcdd2994778476ec2582eb564f90b19871344036e.php:165 45 __TwigTemplate_d263f579c8fe48262eca10b688e33707f3c6d7b5cff39596469a169893690e33->getdisplayParticle() JROOT/cache/gantry5/g5_helium/twig/6f/6f6efd2cbae7b8a2f3ef2d9fcdd2994778476ec2582eb564f90b19871344036e.php:371 44 __TwigTemplate_d263f579c8fe48262eca10b688e33707f3c6d7b5cff39596469a169893690e33->getdisplayItem() JROOT/cache/gantry5/g5_helium/twig/6f/6f6efd2cbae7b8a2f3ef2d9fcdd2994778476ec2582eb564f90b19871344036e.php:529 43 __TwigTemplate_d263f579c8fe48262eca10b688e33707f3c6d7b5cff39596469a169893690e33->getdisplayItems() JROOT/cache/gantry5/g5_helium/twig/6f/6f6efd2cbae7b8a2f3ef2d9fcdd2994778476ec2582eb564f90b19871344036e.php:474 42 __TwigTemplate_d263f579c8fe48262eca10b688e33707f3c6d7b5cff39596469a169893690e33->getdisplayContainers() JROOT/cache/gantry5/g5_helium/twig/6f/6f6efd2cbae7b8a2f3ef2d9fcdd2994778476ec2582eb564f90b19871344036e.php:589 41 __TwigTemplate_d263f579c8fe48262eca10b688e33707f3c6d7b5cff39596469a169893690e33->getdisplaySubmenu() JROOT/cache/gantry5/g5_helium/twig/6f/6f6efd2cbae7b8a2f3ef2d9fcdd2994778476ec2582eb564f90b19871344036e.php:414 40 __TwigTemplate_d263f579c8fe48262eca10b688e33707f3c6d7b5cff39596469a169893690e33->getdisplayItem() JROOT/cache/gantry5/g5_helium/twig/6f/6f6efd2cbae7b8a2f3ef2d9fcdd2994778476ec2582eb564f90b19871344036e.php:529 39 __TwigTemplate_d263f579c8fe48262eca10b688e33707f3c6d7b5cff39596469a169893690e33->getdisplayItems() JROOT/cache/gantry5/g5_helium/twig/6f/6f6efd2cbae7b8a2f3ef2d9fcdd2994778476ec2582eb564f90b19871344036e.php:82 38 __TwigTemplate_d263f579c8fe48262eca10b688e33707f3c6d7b5cff39596469a169893690e33->doDisplay() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 37 Twig\Template->displayWithErrorHandling() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 36 Twig\Template->display() JROOT/cache/gantry5/g5_helium/twig/43/4381d28d64cd975d4bbc65ccd08fd905efb17597742fa402c881bea16f41ff5f.php:71 35 __TwigTemplate_31abb5d75caeb3e91290b7b0ef453a194196eae94181655d9fe5baf108036a80->doDisplay() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 34 Twig\Template->displayWithErrorHandling() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 33 Twig\Template->display() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:434 32 Twig\Template->render() JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47 31 Twig\TemplateWrapper->render() JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384 30 Twig\Environment->render() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163 29 Gantry\Component\Theme\AbstractTheme->render() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:766 28 Gantry\Framework\Theme->getContent() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:666 27 Gantry\Framework\Theme->renderContent() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:593 26 Gantry\Framework\Theme->prepareLayout() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579 25 Gantry\Framework\Theme->prepareLayout() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579 24 Gantry\Framework\Theme->prepareLayout() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579 23 Gantry\Framework\Theme->prepareLayout() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:422 22 Gantry\Framework\Theme->segments() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:702 21 Twig\Template->getAttribute() JROOT/cache/gantry5/g5_helium/twig/33/338d1ce3e48aeca3c38dcaa34b84b0db9f26e4cdc7d62420ac1e48e9522c3306.php:47 20 __TwigTemplate_11b94903ac9c38de4bb2105a5066ee742973b4957d19cccc6fa09167e85a5546->doDisplay() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 19 Twig\Template->displayWithErrorHandling() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 18 Twig\Template->display() JROOT/cache/gantry5/g5_helium/twig/5a/5a9c061f91d7ca9e615210fa73ebddac3d62aa7de47b8be54b4a5f3517f4cab8.php:35 17 __TwigTemplate_277af7fe659c06d904eb257d5eb4bd19d8ee1919fab0c34eba6f071815650844->doDisplay() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 16 Twig\Template->displayWithErrorHandling() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 15 Twig\Template->display() JROOT/cache/gantry5/g5_helium/twig/54/546c22eede2b41fbdf4f134b6757afffe7a54ce26a7295501abc0a81a19bdbb9.php:35 14 __TwigTemplate_97f532d943bf881f0138e74af281e2606c8525f3ee65d2e711ad60e46a5eb82e->doDisplay() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 13 Twig\Template->displayWithErrorHandling() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 12 Twig\Template->display() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:434 11 Twig\Template->render() JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47 10 Twig\TemplateWrapper->render() JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384 9 Twig\Environment->render() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163 8 Gantry\Component\Theme\AbstractTheme->render() JROOT/templates/g5_helium/index.php:23 7 require JROOT/templates/g5_helium/index.php JROOT/libraries/src/Document/HtmlDocument.php:668 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:730 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:545 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1030 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:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:51 - Query Time: 0.91 ms After last query: 1.55 ms Query memory: 0.043 MB Memory before query: 7.675 MB Rows returned: 16
SELECT `id`,`name`,`rules`,`parent_id`
FROM `joom_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_elek','com_fields','com_finder','com_gantry5','com_installer','com_jch_optimize','com_joomlaupdate','com_languages','com_login','com_lugat_editor','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_osmap','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_slogin','com_tags','com_templates','com_users','com_wrapper')id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE joom_assets NULL range idx_asset_name idx_asset_name 202 NULL 41 100.00 Using index condition Status Duration starting 0.06 ms checking permissions 0.00 ms Opening tables 0.08 ms init 0.06 ms System lock 0.02 ms optimizing 0.01 ms statistics 0.17 ms preparing 0.01 ms executing 0.00 ms Sending data 0.33 ms end 0.00 ms query end 0.01 ms closing tables 0.03 ms freeing items 0.02 ms cleaning up 0.00 ms # Caller File and line number 63 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 62 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Access/Access.php:429 61 Joomla\CMS\Access\Access::preloadComponents() JROOT/libraries/src/Access/Access.php:213 60 Joomla\CMS\Access\Access::preload() JROOT/libraries/src/Access/Access.php:531 59 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 58 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 57 Joomla\CMS\User\User->authorise() JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:202 56 Gantry\Framework\Platform->displayModule() Same as call in the line below. 55 call_user_func_array() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:704 54 Twig\Template->getAttribute() JROOT/cache/gantry5/g5_helium/twig/f3/f33e020a7c995c3091226ca5bf2951dd75aa163487741287c6ac4232bb3ab724.php:43 53 __TwigTemplate_fa24ad7ba18b08a067dfafc88f8f31a8672f91eab329b460a51c1786e9023d78->block_particle() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:216 52 Twig\Template->displayBlock() JROOT/cache/gantry5/g5_helium/twig/72/72fe691d71be39d50030851067d8119b7647bba7855e0d1db5389a5d2ee3b093.php:73 51 __TwigTemplate_65b2adc0b8fc17c3166ffc5b2c534f81cd1ec81c50d53706d96ed2bd3d2c3700->doDisplay() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 50 Twig\Template->displayWithErrorHandling() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 49 Twig\Template->display() JROOT/cache/gantry5/g5_helium/twig/f3/f33e020a7c995c3091226ca5bf2951dd75aa163487741287c6ac4232bb3ab724.php:35 48 __TwigTemplate_fa24ad7ba18b08a067dfafc88f8f31a8672f91eab329b460a51c1786e9023d78->doDisplay() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 47 Twig\Template->displayWithErrorHandling() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 46 Twig\Template->display() JROOT/cache/gantry5/g5_helium/twig/6f/6f6efd2cbae7b8a2f3ef2d9fcdd2994778476ec2582eb564f90b19871344036e.php:165 45 __TwigTemplate_d263f579c8fe48262eca10b688e33707f3c6d7b5cff39596469a169893690e33->getdisplayParticle() JROOT/cache/gantry5/g5_helium/twig/6f/6f6efd2cbae7b8a2f3ef2d9fcdd2994778476ec2582eb564f90b19871344036e.php:371 44 __TwigTemplate_d263f579c8fe48262eca10b688e33707f3c6d7b5cff39596469a169893690e33->getdisplayItem() JROOT/cache/gantry5/g5_helium/twig/6f/6f6efd2cbae7b8a2f3ef2d9fcdd2994778476ec2582eb564f90b19871344036e.php:529 43 __TwigTemplate_d263f579c8fe48262eca10b688e33707f3c6d7b5cff39596469a169893690e33->getdisplayItems() JROOT/cache/gantry5/g5_helium/twig/6f/6f6efd2cbae7b8a2f3ef2d9fcdd2994778476ec2582eb564f90b19871344036e.php:474 42 __TwigTemplate_d263f579c8fe48262eca10b688e33707f3c6d7b5cff39596469a169893690e33->getdisplayContainers() JROOT/cache/gantry5/g5_helium/twig/6f/6f6efd2cbae7b8a2f3ef2d9fcdd2994778476ec2582eb564f90b19871344036e.php:589 41 __TwigTemplate_d263f579c8fe48262eca10b688e33707f3c6d7b5cff39596469a169893690e33->getdisplaySubmenu() JROOT/cache/gantry5/g5_helium/twig/6f/6f6efd2cbae7b8a2f3ef2d9fcdd2994778476ec2582eb564f90b19871344036e.php:414 40 __TwigTemplate_d263f579c8fe48262eca10b688e33707f3c6d7b5cff39596469a169893690e33->getdisplayItem() JROOT/cache/gantry5/g5_helium/twig/6f/6f6efd2cbae7b8a2f3ef2d9fcdd2994778476ec2582eb564f90b19871344036e.php:529 39 __TwigTemplate_d263f579c8fe48262eca10b688e33707f3c6d7b5cff39596469a169893690e33->getdisplayItems() JROOT/cache/gantry5/g5_helium/twig/6f/6f6efd2cbae7b8a2f3ef2d9fcdd2994778476ec2582eb564f90b19871344036e.php:82 38 __TwigTemplate_d263f579c8fe48262eca10b688e33707f3c6d7b5cff39596469a169893690e33->doDisplay() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 37 Twig\Template->displayWithErrorHandling() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 36 Twig\Template->display() JROOT/cache/gantry5/g5_helium/twig/43/4381d28d64cd975d4bbc65ccd08fd905efb17597742fa402c881bea16f41ff5f.php:71 35 __TwigTemplate_31abb5d75caeb3e91290b7b0ef453a194196eae94181655d9fe5baf108036a80->doDisplay() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 34 Twig\Template->displayWithErrorHandling() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 33 Twig\Template->display() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:434 32 Twig\Template->render() JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47 31 Twig\TemplateWrapper->render() JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384 30 Twig\Environment->render() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163 29 Gantry\Component\Theme\AbstractTheme->render() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:766 28 Gantry\Framework\Theme->getContent() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:666 27 Gantry\Framework\Theme->renderContent() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:593 26 Gantry\Framework\Theme->prepareLayout() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579 25 Gantry\Framework\Theme->prepareLayout() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579 24 Gantry\Framework\Theme->prepareLayout() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579 23 Gantry\Framework\Theme->prepareLayout() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:422 22 Gantry\Framework\Theme->segments() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:702 21 Twig\Template->getAttribute() JROOT/cache/gantry5/g5_helium/twig/33/338d1ce3e48aeca3c38dcaa34b84b0db9f26e4cdc7d62420ac1e48e9522c3306.php:47 20 __TwigTemplate_11b94903ac9c38de4bb2105a5066ee742973b4957d19cccc6fa09167e85a5546->doDisplay() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 19 Twig\Template->displayWithErrorHandling() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 18 Twig\Template->display() JROOT/cache/gantry5/g5_helium/twig/5a/5a9c061f91d7ca9e615210fa73ebddac3d62aa7de47b8be54b4a5f3517f4cab8.php:35 17 __TwigTemplate_277af7fe659c06d904eb257d5eb4bd19d8ee1919fab0c34eba6f071815650844->doDisplay() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 16 Twig\Template->displayWithErrorHandling() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 15 Twig\Template->display() JROOT/cache/gantry5/g5_helium/twig/54/546c22eede2b41fbdf4f134b6757afffe7a54ce26a7295501abc0a81a19bdbb9.php:35 14 __TwigTemplate_97f532d943bf881f0138e74af281e2606c8525f3ee65d2e711ad60e46a5eb82e->doDisplay() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 13 Twig\Template->displayWithErrorHandling() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 12 Twig\Template->display() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:434 11 Twig\Template->render() JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47 10 Twig\TemplateWrapper->render() JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384 9 Twig\Environment->render() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163 8 Gantry\Component\Theme\AbstractTheme->render() JROOT/templates/g5_helium/index.php:23 7 require JROOT/templates/g5_helium/index.php JROOT/libraries/src/Document/HtmlDocument.php:668 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:730 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:545 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1030 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:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:51 - Query Time: 0.70 ms After last query: 2.07 ms Query memory: 0.038 MB Memory before query: 7.668 MB Rows returned: 0Duplicate queries: #23
SELECT users.id, COALESCE( (SELECT user_images.`value`
FROM joom_fields_values user_images JOIN joom_fields image_fields
ON user_images.field_id = image_fields.id
WHERE user_images.item_id = users.id
AND image_fields.`name` = 'user-image'), 'images/users/user_placeholder.png') avatar_link, COALESCE( (SELECT user_images.`value`
FROM joom_fields_values user_images JOIN joom_fields image_fields
ON user_images.field_id = image_fields.id
WHERE user_images.item_id = users.id
AND image_fields.`name` = 'background-user-image'), 'images/users/user_placeholder.png') background_link, users.name
FROM joom_users users
WHERE users.id = '0'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 PRIMARY NULL NULL NULL NULL NO INDEX KEY COULD BE USED NULL NULL NULL NULL no matching row in const table 3 DEPENDENT SUBQUERY image_fields NULL ALL PRIMARY NO INDEX KEY COULD BE USED NULL NULL 6 16.67 Using where 3 DEPENDENT SUBQUERY user_images NULL ref idx_field_id,idx_item_id idx_field_id 4 baycik_diyar.image_fields.id 83 10.00 Using where 2 DEPENDENT SUBQUERY image_fields NULL ALL PRIMARY NO INDEX KEY COULD BE USED NULL NULL 6 16.67 Using where 2 DEPENDENT SUBQUERY user_images NULL ref idx_field_id,idx_item_id idx_field_id 4 baycik_diyar.image_fields.id 83 10.00 Using where Status Duration starting 0.12 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.23 ms init 0.04 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.07 ms optimizing 0.02 ms statistics 0.03 ms preparing 0.01 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.01 ms executing 0.01 ms end 0.00 ms query end 0.01 ms closing tables 0.03 ms freeing items 0.02 ms cleaning up 0.00 ms # Caller File and line number 53 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 52 JDatabaseDriver->loadAssoc() JROOT/components/com_user_dashboard/models/Dashboard.php:39 51 UserDashboardModelDashboard::userGetDashboard() JROOT/components/com_user_dashboard/models/Dashboard.php:10 50 UserDashboardModelDashboard::userCompose() JROOT/modules/mod_user_dashboard_mini/mod_user_dashboard_mini.php:22 49 include JROOT/modules/mod_user_dashboard_mini/mod_user_dashboard_mini.php JROOT/libraries/src/Helper/ModuleHelper.php:200 48 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 47 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:195 46 Gantry\Framework\Platform->displayModule() Same as call in the line below. 45 call_user_func_array() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:704 44 Twig\Template->getAttribute() JROOT/cache/gantry5/g5_helium/twig/f3/f33e020a7c995c3091226ca5bf2951dd75aa163487741287c6ac4232bb3ab724.php:43 43 __TwigTemplate_fa24ad7ba18b08a067dfafc88f8f31a8672f91eab329b460a51c1786e9023d78->block_particle() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:216 42 Twig\Template->displayBlock() JROOT/cache/gantry5/g5_helium/twig/72/72fe691d71be39d50030851067d8119b7647bba7855e0d1db5389a5d2ee3b093.php:73 41 __TwigTemplate_65b2adc0b8fc17c3166ffc5b2c534f81cd1ec81c50d53706d96ed2bd3d2c3700->doDisplay() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 40 Twig\Template->displayWithErrorHandling() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 39 Twig\Template->display() JROOT/cache/gantry5/g5_helium/twig/f3/f33e020a7c995c3091226ca5bf2951dd75aa163487741287c6ac4232bb3ab724.php:35 38 __TwigTemplate_fa24ad7ba18b08a067dfafc88f8f31a8672f91eab329b460a51c1786e9023d78->doDisplay() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 37 Twig\Template->displayWithErrorHandling() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 36 Twig\Template->display() JROOT/cache/gantry5/g5_helium/twig/40/40a68c93f9fa61bdbf6a23e309fe06cf50b144274eb149d4c92319eba9049b3f.php:53 35 __TwigTemplate_e3ac87ee957206f0e3e7a15f8428ebb8943621df7c8387192aaaad3239284aa2->doDisplay() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 34 Twig\Template->displayWithErrorHandling() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 33 Twig\Template->display() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:434 32 Twig\Template->render() JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47 31 Twig\TemplateWrapper->render() JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384 30 Twig\Environment->render() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163 29 Gantry\Component\Theme\AbstractTheme->render() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:766 28 Gantry\Framework\Theme->getContent() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:666 27 Gantry\Framework\Theme->renderContent() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:593 26 Gantry\Framework\Theme->prepareLayout() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579 25 Gantry\Framework\Theme->prepareLayout() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579 24 Gantry\Framework\Theme->prepareLayout() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579 23 Gantry\Framework\Theme->prepareLayout() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:422 22 Gantry\Framework\Theme->segments() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:702 21 Twig\Template->getAttribute() JROOT/cache/gantry5/g5_helium/twig/33/338d1ce3e48aeca3c38dcaa34b84b0db9f26e4cdc7d62420ac1e48e9522c3306.php:47 20 __TwigTemplate_11b94903ac9c38de4bb2105a5066ee742973b4957d19cccc6fa09167e85a5546->doDisplay() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 19 Twig\Template->displayWithErrorHandling() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 18 Twig\Template->display() JROOT/cache/gantry5/g5_helium/twig/5a/5a9c061f91d7ca9e615210fa73ebddac3d62aa7de47b8be54b4a5f3517f4cab8.php:35 17 __TwigTemplate_277af7fe659c06d904eb257d5eb4bd19d8ee1919fab0c34eba6f071815650844->doDisplay() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 16 Twig\Template->displayWithErrorHandling() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 15 Twig\Template->display() JROOT/cache/gantry5/g5_helium/twig/54/546c22eede2b41fbdf4f134b6757afffe7a54ce26a7295501abc0a81a19bdbb9.php:35 14 __TwigTemplate_97f532d943bf881f0138e74af281e2606c8525f3ee65d2e711ad60e46a5eb82e->doDisplay() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 13 Twig\Template->displayWithErrorHandling() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 12 Twig\Template->display() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:434 11 Twig\Template->render() JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47 10 Twig\TemplateWrapper->render() JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384 9 Twig\Environment->render() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163 8 Gantry\Component\Theme\AbstractTheme->render() JROOT/templates/g5_helium/index.php:23 7 require JROOT/templates/g5_helium/index.php JROOT/libraries/src/Document/HtmlDocument.php:668 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:730 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:545 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1030 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:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:51 - Query Time: 2.27 ms After last query: 0.07 ms Query memory: 0.038 MB Memory before query: 7.695 MB Rows returned: 1Duplicate queries: #24
SELECT COALESCE(SUM(t.points),0) total_points, COALESCE(COUNT(t.points), 0) total_exercises, COALESCE(COUNT(t.id), 0) total_lessons
FROM ( SELECT statistic.points, content.id
FROM joom_content content
LEFT JOIN joom_exercise_statistic statistic
ON content.id = ( SELECT content.id
FROM joom_content content JOIN joom_associations associations
ON associations.id = content.id
AND associations.`context` = 'com_content.item' JOIN joom_associations associations1
ON associations.`key` = associations1.`key`
AND associations.id != associations1.id
AND associations.`context` = 'com_content.item' JOIN joom_content content_assoc
ON content_assoc.id = associations1.id
WHERE (content.id = statistic.exercise_id OR content_assoc.id = statistic.exercise_id)
AND content.language = 'en-GB' )
AND statistic.points > 0
AND user_id = 0 JOIN joom_fields_values content_fields
ON content.id = content_fields.item_id JOIN joom_fields fields
ON fields.id = content_fields.field_id
LEFT JOIN joom_categories category
ON content.catid = category.id
LEFT JOIN joom_categories category_titles
ON category_titles.path = SUBSTRING_INDEX(category.path, '/', 1)
WHERE content.access IN (1,9)
AND content.state = 1
AND content_fields.`value` != 'article'
AND content_fields.`value` != 'challenge'
AND content.language = 'en-GB'
AND fields.`name` = 'item-type'
GROUP BY content.id)tid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 PRIMARY <derived2> NULL ALL NULL NO INDEX KEY COULD BE USED NULL NULL 5 100.00 NULL 2 DERIVED fields NULL ALL PRIMARY NO INDEX KEY COULD BE USED NULL NULL 6 16.67 Using where; Using temporary; Using filesort 2 DERIVED content_fields NULL ref idx_field_id,idx_item_id idx_field_id 4 baycik_diyar.fields.id 83 81.00 Using where 2 DERIVED content NULL eq_ref PRIMARY,idx_access,idx_checkout,idx_state,idx_catid,idx_createdby,idx_featured_catid,idx_language,idx_xreference,idx_alias PRIMARY 4 baycik_diyar.content_fields.item_id 1 6.78 Using where 2 DERIVED statistic NULL ref user_id user_id 5 const 1 100.00 Using where 2 DERIVED category NULL eq_ref PRIMARY PRIMARY 4 baycik_diyar.content.catid 1 100.00 Using where 2 DERIVED category_titles NULL ref idx_path idx_path 402 func 1 100.00 Using where 3 DEPENDENT SUBQUERY associations NULL ref PRIMARY,idx_key PRIMARY 202 const 32 100.00 NULL 3 DEPENDENT SUBQUERY content NULL eq_ref PRIMARY,idx_language PRIMARY 4 baycik_diyar.associations.id 1 6.78 Using where 3 DEPENDENT SUBQUERY associations1 NULL ref idx_key idx_key 128 baycik_diyar.associations.key 2 90.00 Using where; Using index 3 DEPENDENT SUBQUERY content_assoc NULL eq_ref PRIMARY PRIMARY 4 baycik_diyar.associations1.id 1 100.00 Using where; Using index Status Duration starting 0.16 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.32 ms init 0.09 ms System lock 0.01 ms optimizing 0.00 ms optimizing 0.02 ms statistics 0.14 ms preparing 0.03 ms Creating tmp table 0.02 ms Sorting result 0.01 ms optimizing 0.02 ms statistics 0.09 ms preparing 0.02 ms statistics 0.01 ms preparing 0.01 ms executing 0.01 ms Sending data 0.01 ms executing 0.00 ms Sending data 1.07 ms Creating sort index 0.08 ms end 0.00 ms query end 0.01 ms removing tmp table 0.00 ms query end 0.00 ms closing tables 0.00 ms removing tmp table 0.00 ms closing tables 0.04 ms freeing items 0.03 ms cleaning up 0.00 ms # Caller File and line number 53 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 52 JDatabaseDriver->loadAssoc() JROOT/components/com_education/models/ExerciseStatistic.php:293 51 EducationModelExerciseStatistic::userStatisticGetByFilter() JROOT/components/com_user_dashboard/models/Dashboard.php:19 50 UserDashboardModelDashboard::userCompose() JROOT/modules/mod_user_dashboard_mini/mod_user_dashboard_mini.php:22 49 include JROOT/modules/mod_user_dashboard_mini/mod_user_dashboard_mini.php JROOT/libraries/src/Helper/ModuleHelper.php:200 48 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 47 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:195 46 Gantry\Framework\Platform->displayModule() Same as call in the line below. 45 call_user_func_array() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:704 44 Twig\Template->getAttribute() JROOT/cache/gantry5/g5_helium/twig/f3/f33e020a7c995c3091226ca5bf2951dd75aa163487741287c6ac4232bb3ab724.php:43 43 __TwigTemplate_fa24ad7ba18b08a067dfafc88f8f31a8672f91eab329b460a51c1786e9023d78->block_particle() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:216 42 Twig\Template->displayBlock() JROOT/cache/gantry5/g5_helium/twig/72/72fe691d71be39d50030851067d8119b7647bba7855e0d1db5389a5d2ee3b093.php:73 41 __TwigTemplate_65b2adc0b8fc17c3166ffc5b2c534f81cd1ec81c50d53706d96ed2bd3d2c3700->doDisplay() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 40 Twig\Template->displayWithErrorHandling() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 39 Twig\Template->display() JROOT/cache/gantry5/g5_helium/twig/f3/f33e020a7c995c3091226ca5bf2951dd75aa163487741287c6ac4232bb3ab724.php:35 38 __TwigTemplate_fa24ad7ba18b08a067dfafc88f8f31a8672f91eab329b460a51c1786e9023d78->doDisplay() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 37 Twig\Template->displayWithErrorHandling() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 36 Twig\Template->display() JROOT/cache/gantry5/g5_helium/twig/40/40a68c93f9fa61bdbf6a23e309fe06cf50b144274eb149d4c92319eba9049b3f.php:53 35 __TwigTemplate_e3ac87ee957206f0e3e7a15f8428ebb8943621df7c8387192aaaad3239284aa2->doDisplay() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 34 Twig\Template->displayWithErrorHandling() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 33 Twig\Template->display() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:434 32 Twig\Template->render() JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47 31 Twig\TemplateWrapper->render() JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384 30 Twig\Environment->render() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163 29 Gantry\Component\Theme\AbstractTheme->render() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:766 28 Gantry\Framework\Theme->getContent() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:666 27 Gantry\Framework\Theme->renderContent() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:593 26 Gantry\Framework\Theme->prepareLayout() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579 25 Gantry\Framework\Theme->prepareLayout() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579 24 Gantry\Framework\Theme->prepareLayout() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579 23 Gantry\Framework\Theme->prepareLayout() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:422 22 Gantry\Framework\Theme->segments() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:702 21 Twig\Template->getAttribute() JROOT/cache/gantry5/g5_helium/twig/33/338d1ce3e48aeca3c38dcaa34b84b0db9f26e4cdc7d62420ac1e48e9522c3306.php:47 20 __TwigTemplate_11b94903ac9c38de4bb2105a5066ee742973b4957d19cccc6fa09167e85a5546->doDisplay() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 19 Twig\Template->displayWithErrorHandling() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 18 Twig\Template->display() JROOT/cache/gantry5/g5_helium/twig/5a/5a9c061f91d7ca9e615210fa73ebddac3d62aa7de47b8be54b4a5f3517f4cab8.php:35 17 __TwigTemplate_277af7fe659c06d904eb257d5eb4bd19d8ee1919fab0c34eba6f071815650844->doDisplay() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 16 Twig\Template->displayWithErrorHandling() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 15 Twig\Template->display() JROOT/cache/gantry5/g5_helium/twig/54/546c22eede2b41fbdf4f134b6757afffe7a54ce26a7295501abc0a81a19bdbb9.php:35 14 __TwigTemplate_97f532d943bf881f0138e74af281e2606c8525f3ee65d2e711ad60e46a5eb82e->doDisplay() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 13 Twig\Template->displayWithErrorHandling() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 12 Twig\Template->display() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:434 11 Twig\Template->render() JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47 10 Twig\TemplateWrapper->render() JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384 9 Twig\Environment->render() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163 8 Gantry\Component\Theme\AbstractTheme->render() JROOT/templates/g5_helium/index.php:23 7 require JROOT/templates/g5_helium/index.php JROOT/libraries/src/Document/HtmlDocument.php:668 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:730 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:545 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1030 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:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:51 - Query Time: 2.32 ms After last query: 0.06 ms Query memory: 0.038 MB Memory before query: 7.718 MB Rows returned: 0Duplicate queries: #25
SELECT menu.*
FROM (SELECT DISTINCT parent_menu.*
FROM joom_menu parent_menu JOIN joom_associations assoc1
ON assoc1.`context` = 'com_menus.item'
AND parent_menu.id = assoc1.id JOIN joom_associations assoc2
ON assoc2.`context` = 'com_menus.item'
AND assoc1.`key` = assoc2.`key` JOIN joom_menu parent_menu_assoc
ON parent_menu_assoc.id = assoc2.id
WHERE (parent_menu.alias = 'мой-профиль' OR parent_menu_assoc.alias = 'мой-профиль')
AND parent_menu.language = 'en-GB' ) parent_menu JOIN joom_menu menu
ON menu.parent_id = parent_menu.id
WHERE menu.published = 1
AND menu.access IN (1,9)
ORDER BY menu.lft ASCid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 PRIMARY menu NULL ALL NULL NO INDEX KEY COULD BE USED NULL NULL 150 2.00 Using where; Using filesort 1 PRIMARY <derived2> NULL ref <auto_key0> <auto_key0> 4 baycik_diyar.menu.parent_id 6 100.00 Using where 2 DERIVED assoc1 NULL ref PRIMARY,idx_key PRIMARY 202 const 86 100.00 Using temporary 2 DERIVED parent_menu NULL eq_ref PRIMARY,idx_alias,idx_language PRIMARY 4 baycik_diyar.assoc1.id 1 36.00 Using where 2 DERIVED assoc2 NULL ref PRIMARY,idx_key idx_key 330 baycik_diyar.assoc1.key,const 2 100.00 Using index; Distinct 2 DERIVED parent_menu_assoc NULL eq_ref PRIMARY,idx_alias PRIMARY 4 baycik_diyar.assoc2.id 1 100.00 Using where; Distinct Status Duration starting 0.07 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.07 ms init 0.10 ms System lock 0.02 ms optimizing 0.00 ms optimizing 0.01 ms statistics 0.17 ms preparing 0.02 ms Creating tmp table 0.05 ms statistics 0.03 ms preparing 0.01 ms Sorting result 0.00 ms executing 0.12 ms Sending data 0.02 ms Creating sort index 0.13 ms executing 0.00 ms Sending data 1.28 ms end 0.00 ms query end 0.01 ms removing tmp table 0.04 ms query end 0.00 ms closing tables 0.00 ms removing tmp table 0.02 ms closing tables 0.03 ms freeing items 0.03 ms cleaning up 0.00 ms # Caller File and line number 52 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506 51 JDatabaseDriver->loadAssocList() JROOT/modules/mod_user_dashboard_mini/helper.php:92 50 ModUserDashboardMiniHelper::getUserMenuTree() JROOT/modules/mod_user_dashboard_mini/mod_user_dashboard_mini.php:24 49 include JROOT/modules/mod_user_dashboard_mini/mod_user_dashboard_mini.php JROOT/libraries/src/Helper/ModuleHelper.php:200 48 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 47 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:195 46 Gantry\Framework\Platform->displayModule() Same as call in the line below. 45 call_user_func_array() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:704 44 Twig\Template->getAttribute() JROOT/cache/gantry5/g5_helium/twig/f3/f33e020a7c995c3091226ca5bf2951dd75aa163487741287c6ac4232bb3ab724.php:43 43 __TwigTemplate_fa24ad7ba18b08a067dfafc88f8f31a8672f91eab329b460a51c1786e9023d78->block_particle() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:216 42 Twig\Template->displayBlock() JROOT/cache/gantry5/g5_helium/twig/72/72fe691d71be39d50030851067d8119b7647bba7855e0d1db5389a5d2ee3b093.php:73 41 __TwigTemplate_65b2adc0b8fc17c3166ffc5b2c534f81cd1ec81c50d53706d96ed2bd3d2c3700->doDisplay() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 40 Twig\Template->displayWithErrorHandling() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 39 Twig\Template->display() JROOT/cache/gantry5/g5_helium/twig/f3/f33e020a7c995c3091226ca5bf2951dd75aa163487741287c6ac4232bb3ab724.php:35 38 __TwigTemplate_fa24ad7ba18b08a067dfafc88f8f31a8672f91eab329b460a51c1786e9023d78->doDisplay() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 37 Twig\Template->displayWithErrorHandling() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 36 Twig\Template->display() JROOT/cache/gantry5/g5_helium/twig/40/40a68c93f9fa61bdbf6a23e309fe06cf50b144274eb149d4c92319eba9049b3f.php:53 35 __TwigTemplate_e3ac87ee957206f0e3e7a15f8428ebb8943621df7c8387192aaaad3239284aa2->doDisplay() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 34 Twig\Template->displayWithErrorHandling() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 33 Twig\Template->display() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:434 32 Twig\Template->render() JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47 31 Twig\TemplateWrapper->render() JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384 30 Twig\Environment->render() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163 29 Gantry\Component\Theme\AbstractTheme->render() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:766 28 Gantry\Framework\Theme->getContent() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:666 27 Gantry\Framework\Theme->renderContent() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:593 26 Gantry\Framework\Theme->prepareLayout() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579 25 Gantry\Framework\Theme->prepareLayout() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579 24 Gantry\Framework\Theme->prepareLayout() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579 23 Gantry\Framework\Theme->prepareLayout() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:422 22 Gantry\Framework\Theme->segments() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:702 21 Twig\Template->getAttribute() JROOT/cache/gantry5/g5_helium/twig/33/338d1ce3e48aeca3c38dcaa34b84b0db9f26e4cdc7d62420ac1e48e9522c3306.php:47 20 __TwigTemplate_11b94903ac9c38de4bb2105a5066ee742973b4957d19cccc6fa09167e85a5546->doDisplay() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 19 Twig\Template->displayWithErrorHandling() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 18 Twig\Template->display() JROOT/cache/gantry5/g5_helium/twig/5a/5a9c061f91d7ca9e615210fa73ebddac3d62aa7de47b8be54b4a5f3517f4cab8.php:35 17 __TwigTemplate_277af7fe659c06d904eb257d5eb4bd19d8ee1919fab0c34eba6f071815650844->doDisplay() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 16 Twig\Template->displayWithErrorHandling() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 15 Twig\Template->display() JROOT/cache/gantry5/g5_helium/twig/54/546c22eede2b41fbdf4f134b6757afffe7a54ce26a7295501abc0a81a19bdbb9.php:35 14 __TwigTemplate_97f532d943bf881f0138e74af281e2606c8525f3ee65d2e711ad60e46a5eb82e->doDisplay() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 13 Twig\Template->displayWithErrorHandling() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 12 Twig\Template->display() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:434 11 Twig\Template->render() JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47 10 Twig\TemplateWrapper->render() JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384 9 Twig\Environment->render() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163 8 Gantry\Component\Theme\AbstractTheme->render() JROOT/templates/g5_helium/index.php:23 7 require JROOT/templates/g5_helium/index.php JROOT/libraries/src/Document/HtmlDocument.php:668 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:730 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:545 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1030 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:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:51 - Query Time: 0.52 ms After last query: 2.71 ms Query memory: 0.038 MB Memory before query: 7.800 MB Rows returned: 0
SELECT content_assoc.title
FROM joom_content content JOIN joom_associations associations
ON associations.id = content.id
AND associations.`context` = 'com_content.item' JOIN joom_associations associations1
ON associations.`key` = associations1.`key`
AND associations.id != associations1.id
AND associations.`context` = 'com_content.item' JOIN joom_content content_assoc
ON content_assoc.id = associations1.id
WHERE content.title = 'Version 1.9.0'
AND content_assoc.language = 'en-GB'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE associations NULL ref PRIMARY,idx_key PRIMARY 202 const 32 100.00 NULL 1 SIMPLE content NULL eq_ref PRIMARY PRIMARY 4 baycik_diyar.associations.id 1 10.00 Using where 1 SIMPLE associations1 NULL ref idx_key idx_key 128 baycik_diyar.associations.key 2 90.00 Using where; Using index 1 SIMPLE content_assoc NULL eq_ref PRIMARY,idx_language PRIMARY 4 baycik_diyar.associations1.id 1 6.78 Using where Status Duration starting 0.06 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.03 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.11 ms preparing 0.02 ms executing 0.00 ms Sending data 0.14 ms end 0.00 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.02 ms cleaning up 0.00 ms # Caller File and line number 52 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 51 JDatabaseDriver->loadResult() JROOT/components/com_ilimhane/models/Item.php:387 50 IlimhaneModelItem::itemAssociationGet() JROOT/modules/mod_ilimhane/mod_ilimhane.php:110 49 include JROOT/modules/mod_ilimhane/mod_ilimhane.php JROOT/libraries/src/Helper/ModuleHelper.php:200 48 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 47 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:195 46 Gantry\Framework\Platform->displayModule() Same as call in the line below. 45 call_user_func_array() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:704 44 Twig\Template->getAttribute() JROOT/cache/gantry5/g5_helium/twig/f3/f33e020a7c995c3091226ca5bf2951dd75aa163487741287c6ac4232bb3ab724.php:43 43 __TwigTemplate_fa24ad7ba18b08a067dfafc88f8f31a8672f91eab329b460a51c1786e9023d78->block_particle() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:216 42 Twig\Template->displayBlock() JROOT/cache/gantry5/g5_helium/twig/72/72fe691d71be39d50030851067d8119b7647bba7855e0d1db5389a5d2ee3b093.php:73 41 __TwigTemplate_65b2adc0b8fc17c3166ffc5b2c534f81cd1ec81c50d53706d96ed2bd3d2c3700->doDisplay() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 40 Twig\Template->displayWithErrorHandling() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 39 Twig\Template->display() JROOT/cache/gantry5/g5_helium/twig/f3/f33e020a7c995c3091226ca5bf2951dd75aa163487741287c6ac4232bb3ab724.php:35 38 __TwigTemplate_fa24ad7ba18b08a067dfafc88f8f31a8672f91eab329b460a51c1786e9023d78->doDisplay() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 37 Twig\Template->displayWithErrorHandling() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 36 Twig\Template->display() JROOT/cache/gantry5/g5_helium/twig/40/40a68c93f9fa61bdbf6a23e309fe06cf50b144274eb149d4c92319eba9049b3f.php:53 35 __TwigTemplate_e3ac87ee957206f0e3e7a15f8428ebb8943621df7c8387192aaaad3239284aa2->doDisplay() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 34 Twig\Template->displayWithErrorHandling() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 33 Twig\Template->display() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:434 32 Twig\Template->render() JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47 31 Twig\TemplateWrapper->render() JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384 30 Twig\Environment->render() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163 29 Gantry\Component\Theme\AbstractTheme->render() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:766 28 Gantry\Framework\Theme->getContent() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:666 27 Gantry\Framework\Theme->renderContent() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:593 26 Gantry\Framework\Theme->prepareLayout() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579 25 Gantry\Framework\Theme->prepareLayout() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579 24 Gantry\Framework\Theme->prepareLayout() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579 23 Gantry\Framework\Theme->prepareLayout() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:422 22 Gantry\Framework\Theme->segments() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:702 21 Twig\Template->getAttribute() JROOT/cache/gantry5/g5_helium/twig/33/338d1ce3e48aeca3c38dcaa34b84b0db9f26e4cdc7d62420ac1e48e9522c3306.php:47 20 __TwigTemplate_11b94903ac9c38de4bb2105a5066ee742973b4957d19cccc6fa09167e85a5546->doDisplay() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 19 Twig\Template->displayWithErrorHandling() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 18 Twig\Template->display() JROOT/cache/gantry5/g5_helium/twig/5a/5a9c061f91d7ca9e615210fa73ebddac3d62aa7de47b8be54b4a5f3517f4cab8.php:35 17 __TwigTemplate_277af7fe659c06d904eb257d5eb4bd19d8ee1919fab0c34eba6f071815650844->doDisplay() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 16 Twig\Template->displayWithErrorHandling() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 15 Twig\Template->display() JROOT/cache/gantry5/g5_helium/twig/54/546c22eede2b41fbdf4f134b6757afffe7a54ce26a7295501abc0a81a19bdbb9.php:35 14 __TwigTemplate_97f532d943bf881f0138e74af281e2606c8525f3ee65d2e711ad60e46a5eb82e->doDisplay() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 13 Twig\Template->displayWithErrorHandling() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 12 Twig\Template->display() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:434 11 Twig\Template->render() JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47 10 Twig\TemplateWrapper->render() JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384 9 Twig\Environment->render() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163 8 Gantry\Component\Theme\AbstractTheme->render() JROOT/templates/g5_helium/index.php:23 7 require JROOT/templates/g5_helium/index.php JROOT/libraries/src/Document/HtmlDocument.php:668 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:730 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:545 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1030 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:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:51 - Query Time: 1.29 ms After last query: 0.08 ms Query memory: 0.038 MB Memory before query: 7.825 MB Rows returned: 0
SELECT content.id, content.title, content.alias, content.introtext, content.fulltext, content.state, COALESCE(category.title) as parent_title, COALESCE(category.id) as parent_id, content.images, content.created, author.name as creator_name, author_dashboard.avatar_link as creator_image, content.modified, content.access, content.hits, content.language, content.checked_out, content_fields.value as item_type
FROM joom_content content
LEFT JOIN joom_categories category
ON content.catid = category.id
LEFT JOIN joom_contentitem_tag_map tag_to_article
ON tag_to_article.content_item_id = content.id
LEFT JOIN joom_content_authors content_authors
ON content_authors.tag_id = tag_to_article.tag_id
LEFT JOIN joom_users author
ON author.id = content.created_by
LEFT JOIN joom_user_dashboard author_dashboard
ON author.id = author_dashboard.user_id
LEFT JOIN joom_tags tag
ON tag.id = tag_to_article.tag_id
LEFT JOIN joom_fields_values content_fields
ON content.id = content_fields.item_id
WHERE ( content.title LIKE 'Version 1.9.0%' )
AND content.access IN (1,9)
AND (content.language = 'en-GB' OR content.language = '*' )
AND content.catid NOT IN (1,2,3,4,5,7,8,9,10,11,13,14,48,49)
AND content.state = 1
GROUP BY content.id
ORDER BY content.created DESC
LIMIT 0, 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE content NULL range PRIMARY,idx_access,idx_checkout,idx_state,idx_catid,idx_createdby,idx_featured_catid,idx_language,idx_xreference,idx_alias idx_language 28 NULL 17 11.11 Using index condition; Using where; Using temporary; Using filesort 1 SIMPLE category NULL eq_ref PRIMARY PRIMARY 4 baycik_diyar.content.catid 1 100.00 Using where 1 SIMPLE tag_to_article NULL index NULL idx_core_content_id 4 NULL 667 100.00 Using where; Using index; Using join buffer (Block Nested Loop) 1 SIMPLE content_authors NULL ALL NULL NO INDEX KEY COULD BE USED NULL NULL 28 100.00 Using where; Using join buffer (Block Nested Loop) 1 SIMPLE author NULL eq_ref PRIMARY PRIMARY 4 baycik_diyar.content.created_by 1 100.00 Using where 1 SIMPLE author_dashboard NULL eq_ref PRIMARY PRIMARY 4 baycik_diyar.author.id 1 100.00 NULL 1 SIMPLE tag NULL eq_ref PRIMARY PRIMARY 4 baycik_diyar.tag_to_article.tag_id 1 100.00 Using index 1 SIMPLE content_fields NULL ALL idx_item_id NO INDEX KEY COULD BE USED NULL NULL 333 100.00 Using where; Using join buffer (Block Nested Loop) Status Duration starting 0.11 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.23 ms init 0.05 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.15 ms preparing 0.04 ms Creating tmp table 0.04 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.40 ms Creating sort index 0.03 ms end 0.00 ms query end 0.01 ms removing tmp table 0.03 ms query end 0.00 ms closing tables 0.03 ms freeing items 0.02 ms cleaning up 0.00 ms # Caller File and line number 53 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506 52 JDatabaseDriver->loadAssocList() JROOT/components/com_ilimhane/models/Item.php:146 51 IlimhaneModelItem::itemByNameGet() JROOT/components/com_ilimhane/models/Item.php:39 50 IlimhaneModelItem::itemObjectGet() JROOT/modules/mod_ilimhane/mod_ilimhane.php:116 49 include JROOT/modules/mod_ilimhane/mod_ilimhane.php JROOT/libraries/src/Helper/ModuleHelper.php:200 48 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 47 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:195 46 Gantry\Framework\Platform->displayModule() Same as call in the line below. 45 call_user_func_array() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:704 44 Twig\Template->getAttribute() JROOT/cache/gantry5/g5_helium/twig/f3/f33e020a7c995c3091226ca5bf2951dd75aa163487741287c6ac4232bb3ab724.php:43 43 __TwigTemplate_fa24ad7ba18b08a067dfafc88f8f31a8672f91eab329b460a51c1786e9023d78->block_particle() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:216 42 Twig\Template->displayBlock() JROOT/cache/gantry5/g5_helium/twig/72/72fe691d71be39d50030851067d8119b7647bba7855e0d1db5389a5d2ee3b093.php:73 41 __TwigTemplate_65b2adc0b8fc17c3166ffc5b2c534f81cd1ec81c50d53706d96ed2bd3d2c3700->doDisplay() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 40 Twig\Template->displayWithErrorHandling() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 39 Twig\Template->display() JROOT/cache/gantry5/g5_helium/twig/f3/f33e020a7c995c3091226ca5bf2951dd75aa163487741287c6ac4232bb3ab724.php:35 38 __TwigTemplate_fa24ad7ba18b08a067dfafc88f8f31a8672f91eab329b460a51c1786e9023d78->doDisplay() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 37 Twig\Template->displayWithErrorHandling() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 36 Twig\Template->display() JROOT/cache/gantry5/g5_helium/twig/40/40a68c93f9fa61bdbf6a23e309fe06cf50b144274eb149d4c92319eba9049b3f.php:53 35 __TwigTemplate_e3ac87ee957206f0e3e7a15f8428ebb8943621df7c8387192aaaad3239284aa2->doDisplay() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 34 Twig\Template->displayWithErrorHandling() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 33 Twig\Template->display() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:434 32 Twig\Template->render() JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47 31 Twig\TemplateWrapper->render() JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384 30 Twig\Environment->render() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163 29 Gantry\Component\Theme\AbstractTheme->render() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:766 28 Gantry\Framework\Theme->getContent() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:666 27 Gantry\Framework\Theme->renderContent() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:593 26 Gantry\Framework\Theme->prepareLayout() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579 25 Gantry\Framework\Theme->prepareLayout() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579 24 Gantry\Framework\Theme->prepareLayout() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579 23 Gantry\Framework\Theme->prepareLayout() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:422 22 Gantry\Framework\Theme->segments() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:702 21 Twig\Template->getAttribute() JROOT/cache/gantry5/g5_helium/twig/33/338d1ce3e48aeca3c38dcaa34b84b0db9f26e4cdc7d62420ac1e48e9522c3306.php:47 20 __TwigTemplate_11b94903ac9c38de4bb2105a5066ee742973b4957d19cccc6fa09167e85a5546->doDisplay() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 19 Twig\Template->displayWithErrorHandling() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 18 Twig\Template->display() JROOT/cache/gantry5/g5_helium/twig/5a/5a9c061f91d7ca9e615210fa73ebddac3d62aa7de47b8be54b4a5f3517f4cab8.php:35 17 __TwigTemplate_277af7fe659c06d904eb257d5eb4bd19d8ee1919fab0c34eba6f071815650844->doDisplay() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 16 Twig\Template->displayWithErrorHandling() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 15 Twig\Template->display() JROOT/cache/gantry5/g5_helium/twig/54/546c22eede2b41fbdf4f134b6757afffe7a54ce26a7295501abc0a81a19bdbb9.php:35 14 __TwigTemplate_97f532d943bf881f0138e74af281e2606c8525f3ee65d2e711ad60e46a5eb82e->doDisplay() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 13 Twig\Template->displayWithErrorHandling() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 12 Twig\Template->display() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:434 11 Twig\Template->render() JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47 10 Twig\TemplateWrapper->render() JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384 9 Twig\Environment->render() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163 8 Gantry\Component\Theme\AbstractTheme->render() JROOT/templates/g5_helium/index.php:23 7 require JROOT/templates/g5_helium/index.php JROOT/libraries/src/Document/HtmlDocument.php:668 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:730 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:545 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1030 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:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:51 - Query Time: 0.36 ms After last query: 2.40 ms Query memory: 0.038 MB Memory before query: 7.896 MB Rows returned: 0Duplicate queries: #18
SELECT users.id, COALESCE( (SELECT user_images.`value`
FROM joom_fields_values user_images JOIN joom_fields image_fields
ON user_images.field_id = image_fields.id
WHERE user_images.item_id = users.id
AND image_fields.`name` = 'user-image'), 'images/users/user_placeholder.png') avatar_link, COALESCE( (SELECT user_images.`value`
FROM joom_fields_values user_images JOIN joom_fields image_fields
ON user_images.field_id = image_fields.id
WHERE user_images.item_id = users.id
AND image_fields.`name` = 'background-user-image'), 'images/users/user_placeholder.png') background_link, users.name
FROM joom_users users
WHERE users.id = '0'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 PRIMARY NULL NULL NULL NULL NO INDEX KEY COULD BE USED NULL NULL NULL NULL no matching row in const table 3 DEPENDENT SUBQUERY image_fields NULL ALL PRIMARY NO INDEX KEY COULD BE USED NULL NULL 6 16.67 Using where 3 DEPENDENT SUBQUERY user_images NULL ref idx_field_id,idx_item_id idx_field_id 4 baycik_diyar.image_fields.id 83 10.00 Using where 2 DEPENDENT SUBQUERY image_fields NULL ALL PRIMARY NO INDEX KEY COULD BE USED NULL NULL 6 16.67 Using where 2 DEPENDENT SUBQUERY user_images NULL ref idx_field_id,idx_item_id idx_field_id 4 baycik_diyar.image_fields.id 83 10.00 Using where Status Duration starting 0.07 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.03 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.03 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms executing 0.01 ms end 0.00 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Caller File and line number 53 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 52 JDatabaseDriver->loadAssoc() JROOT/components/com_user_dashboard/models/Dashboard.php:39 51 UserDashboardModelDashboard::userGetDashboard() JROOT/components/com_user_dashboard/models/Dashboard.php:10 50 UserDashboardModelDashboard::userCompose() JROOT/modules/mod_user_dashboard_mini/mod_user_dashboard_mini.php:22 49 include JROOT/modules/mod_user_dashboard_mini/mod_user_dashboard_mini.php JROOT/libraries/src/Helper/ModuleHelper.php:200 48 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 47 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:195 46 Gantry\Framework\Platform->displayModule() Same as call in the line below. 45 call_user_func_array() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:704 44 Twig\Template->getAttribute() JROOT/cache/gantry5/g5_helium/twig/f3/f33e020a7c995c3091226ca5bf2951dd75aa163487741287c6ac4232bb3ab724.php:43 43 __TwigTemplate_fa24ad7ba18b08a067dfafc88f8f31a8672f91eab329b460a51c1786e9023d78->block_particle() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:216 42 Twig\Template->displayBlock() JROOT/cache/gantry5/g5_helium/twig/72/72fe691d71be39d50030851067d8119b7647bba7855e0d1db5389a5d2ee3b093.php:73 41 __TwigTemplate_65b2adc0b8fc17c3166ffc5b2c534f81cd1ec81c50d53706d96ed2bd3d2c3700->doDisplay() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 40 Twig\Template->displayWithErrorHandling() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 39 Twig\Template->display() JROOT/cache/gantry5/g5_helium/twig/f3/f33e020a7c995c3091226ca5bf2951dd75aa163487741287c6ac4232bb3ab724.php:35 38 __TwigTemplate_fa24ad7ba18b08a067dfafc88f8f31a8672f91eab329b460a51c1786e9023d78->doDisplay() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 37 Twig\Template->displayWithErrorHandling() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 36 Twig\Template->display() JROOT/cache/gantry5/g5_helium/twig/40/40a68c93f9fa61bdbf6a23e309fe06cf50b144274eb149d4c92319eba9049b3f.php:53 35 __TwigTemplate_e3ac87ee957206f0e3e7a15f8428ebb8943621df7c8387192aaaad3239284aa2->doDisplay() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 34 Twig\Template->displayWithErrorHandling() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 33 Twig\Template->display() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:434 32 Twig\Template->render() JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47 31 Twig\TemplateWrapper->render() JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384 30 Twig\Environment->render() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163 29 Gantry\Component\Theme\AbstractTheme->render() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:766 28 Gantry\Framework\Theme->getContent() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:666 27 Gantry\Framework\Theme->renderContent() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:593 26 Gantry\Framework\Theme->prepareLayout() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579 25 Gantry\Framework\Theme->prepareLayout() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579 24 Gantry\Framework\Theme->prepareLayout() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579 23 Gantry\Framework\Theme->prepareLayout() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:422 22 Gantry\Framework\Theme->segments() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:702 21 Twig\Template->getAttribute() JROOT/cache/gantry5/g5_helium/twig/33/338d1ce3e48aeca3c38dcaa34b84b0db9f26e4cdc7d62420ac1e48e9522c3306.php:47 20 __TwigTemplate_11b94903ac9c38de4bb2105a5066ee742973b4957d19cccc6fa09167e85a5546->doDisplay() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 19 Twig\Template->displayWithErrorHandling() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 18 Twig\Template->display() JROOT/cache/gantry5/g5_helium/twig/5a/5a9c061f91d7ca9e615210fa73ebddac3d62aa7de47b8be54b4a5f3517f4cab8.php:35 17 __TwigTemplate_277af7fe659c06d904eb257d5eb4bd19d8ee1919fab0c34eba6f071815650844->doDisplay() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 16 Twig\Template->displayWithErrorHandling() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 15 Twig\Template->display() JROOT/cache/gantry5/g5_helium/twig/54/546c22eede2b41fbdf4f134b6757afffe7a54ce26a7295501abc0a81a19bdbb9.php:35 14 __TwigTemplate_97f532d943bf881f0138e74af281e2606c8525f3ee65d2e711ad60e46a5eb82e->doDisplay() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 13 Twig\Template->displayWithErrorHandling() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 12 Twig\Template->display() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:434 11 Twig\Template->render() JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47 10 Twig\TemplateWrapper->render() JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384 9 Twig\Environment->render() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163 8 Gantry\Component\Theme\AbstractTheme->render() JROOT/templates/g5_helium/index.php:23 7 require JROOT/templates/g5_helium/index.php JROOT/libraries/src/Document/HtmlDocument.php:668 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:730 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:545 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1030 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:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:51 - Query Time: 2.06 ms After last query: 0.07 ms Query memory: 0.038 MB Memory before query: 7.923 MB Rows returned: 1Duplicate queries: #19
SELECT COALESCE(SUM(t.points),0) total_points, COALESCE(COUNT(t.points), 0) total_exercises, COALESCE(COUNT(t.id), 0) total_lessons
FROM ( SELECT statistic.points, content.id
FROM joom_content content
LEFT JOIN joom_exercise_statistic statistic
ON content.id = ( SELECT content.id
FROM joom_content content JOIN joom_associations associations
ON associations.id = content.id
AND associations.`context` = 'com_content.item' JOIN joom_associations associations1
ON associations.`key` = associations1.`key`
AND associations.id != associations1.id
AND associations.`context` = 'com_content.item' JOIN joom_content content_assoc
ON content_assoc.id = associations1.id
WHERE (content.id = statistic.exercise_id OR content_assoc.id = statistic.exercise_id)
AND content.language = 'en-GB' )
AND statistic.points > 0
AND user_id = 0 JOIN joom_fields_values content_fields
ON content.id = content_fields.item_id JOIN joom_fields fields
ON fields.id = content_fields.field_id
LEFT JOIN joom_categories category
ON content.catid = category.id
LEFT JOIN joom_categories category_titles
ON category_titles.path = SUBSTRING_INDEX(category.path, '/', 1)
WHERE content.access IN (1,9)
AND content.state = 1
AND content_fields.`value` != 'article'
AND content_fields.`value` != 'challenge'
AND content.language = 'en-GB'
AND fields.`name` = 'item-type'
GROUP BY content.id)tid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 PRIMARY <derived2> NULL ALL NULL NO INDEX KEY COULD BE USED NULL NULL 5 100.00 NULL 2 DERIVED fields NULL ALL PRIMARY NO INDEX KEY COULD BE USED NULL NULL 6 16.67 Using where; Using temporary; Using filesort 2 DERIVED content_fields NULL ref idx_field_id,idx_item_id idx_field_id 4 baycik_diyar.fields.id 83 81.00 Using where 2 DERIVED content NULL eq_ref PRIMARY,idx_access,idx_checkout,idx_state,idx_catid,idx_createdby,idx_featured_catid,idx_language,idx_xreference,idx_alias PRIMARY 4 baycik_diyar.content_fields.item_id 1 6.78 Using where 2 DERIVED statistic NULL ref user_id user_id 5 const 1 100.00 Using where 2 DERIVED category NULL eq_ref PRIMARY PRIMARY 4 baycik_diyar.content.catid 1 100.00 Using where 2 DERIVED category_titles NULL ref idx_path idx_path 402 func 1 100.00 Using where 3 DEPENDENT SUBQUERY associations NULL ref PRIMARY,idx_key PRIMARY 202 const 32 100.00 NULL 3 DEPENDENT SUBQUERY content NULL eq_ref PRIMARY,idx_language PRIMARY 4 baycik_diyar.associations.id 1 6.78 Using where 3 DEPENDENT SUBQUERY associations1 NULL ref idx_key idx_key 128 baycik_diyar.associations.key 2 90.00 Using where; Using index 3 DEPENDENT SUBQUERY content_assoc NULL eq_ref PRIMARY PRIMARY 4 baycik_diyar.associations1.id 1 100.00 Using where; Using index Status Duration starting 0.23 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.13 ms System lock 0.01 ms optimizing 0.01 ms optimizing 0.03 ms statistics 0.21 ms preparing 0.02 ms Creating tmp table 0.01 ms Sorting result 0.01 ms optimizing 0.02 ms statistics 0.09 ms preparing 0.02 ms statistics 0.01 ms preparing 0.01 ms executing 0.01 ms Sending data 0.01 ms executing 0.00 ms Sending data 1.00 ms Creating sort index 0.09 ms end 0.00 ms query end 0.01 ms removing tmp table 0.01 ms query end 0.00 ms closing tables 0.00 ms removing tmp table 0.00 ms closing tables 0.03 ms freeing items 0.03 ms cleaning up 0.01 ms # Caller File and line number 53 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 52 JDatabaseDriver->loadAssoc() JROOT/components/com_education/models/ExerciseStatistic.php:293 51 EducationModelExerciseStatistic::userStatisticGetByFilter() JROOT/components/com_user_dashboard/models/Dashboard.php:19 50 UserDashboardModelDashboard::userCompose() JROOT/modules/mod_user_dashboard_mini/mod_user_dashboard_mini.php:22 49 include JROOT/modules/mod_user_dashboard_mini/mod_user_dashboard_mini.php JROOT/libraries/src/Helper/ModuleHelper.php:200 48 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 47 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:195 46 Gantry\Framework\Platform->displayModule() Same as call in the line below. 45 call_user_func_array() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:704 44 Twig\Template->getAttribute() JROOT/cache/gantry5/g5_helium/twig/f3/f33e020a7c995c3091226ca5bf2951dd75aa163487741287c6ac4232bb3ab724.php:43 43 __TwigTemplate_fa24ad7ba18b08a067dfafc88f8f31a8672f91eab329b460a51c1786e9023d78->block_particle() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:216 42 Twig\Template->displayBlock() JROOT/cache/gantry5/g5_helium/twig/72/72fe691d71be39d50030851067d8119b7647bba7855e0d1db5389a5d2ee3b093.php:73 41 __TwigTemplate_65b2adc0b8fc17c3166ffc5b2c534f81cd1ec81c50d53706d96ed2bd3d2c3700->doDisplay() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 40 Twig\Template->displayWithErrorHandling() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 39 Twig\Template->display() JROOT/cache/gantry5/g5_helium/twig/f3/f33e020a7c995c3091226ca5bf2951dd75aa163487741287c6ac4232bb3ab724.php:35 38 __TwigTemplate_fa24ad7ba18b08a067dfafc88f8f31a8672f91eab329b460a51c1786e9023d78->doDisplay() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 37 Twig\Template->displayWithErrorHandling() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 36 Twig\Template->display() JROOT/cache/gantry5/g5_helium/twig/40/40a68c93f9fa61bdbf6a23e309fe06cf50b144274eb149d4c92319eba9049b3f.php:53 35 __TwigTemplate_e3ac87ee957206f0e3e7a15f8428ebb8943621df7c8387192aaaad3239284aa2->doDisplay() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 34 Twig\Template->displayWithErrorHandling() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 33 Twig\Template->display() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:434 32 Twig\Template->render() JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47 31 Twig\TemplateWrapper->render() JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384 30 Twig\Environment->render() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163 29 Gantry\Component\Theme\AbstractTheme->render() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:766 28 Gantry\Framework\Theme->getContent() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:666 27 Gantry\Framework\Theme->renderContent() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:593 26 Gantry\Framework\Theme->prepareLayout() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579 25 Gantry\Framework\Theme->prepareLayout() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579 24 Gantry\Framework\Theme->prepareLayout() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579 23 Gantry\Framework\Theme->prepareLayout() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:422 22 Gantry\Framework\Theme->segments() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:702 21 Twig\Template->getAttribute() JROOT/cache/gantry5/g5_helium/twig/33/338d1ce3e48aeca3c38dcaa34b84b0db9f26e4cdc7d62420ac1e48e9522c3306.php:47 20 __TwigTemplate_11b94903ac9c38de4bb2105a5066ee742973b4957d19cccc6fa09167e85a5546->doDisplay() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 19 Twig\Template->displayWithErrorHandling() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 18 Twig\Template->display() JROOT/cache/gantry5/g5_helium/twig/5a/5a9c061f91d7ca9e615210fa73ebddac3d62aa7de47b8be54b4a5f3517f4cab8.php:35 17 __TwigTemplate_277af7fe659c06d904eb257d5eb4bd19d8ee1919fab0c34eba6f071815650844->doDisplay() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 16 Twig\Template->displayWithErrorHandling() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 15 Twig\Template->display() JROOT/cache/gantry5/g5_helium/twig/54/546c22eede2b41fbdf4f134b6757afffe7a54ce26a7295501abc0a81a19bdbb9.php:35 14 __TwigTemplate_97f532d943bf881f0138e74af281e2606c8525f3ee65d2e711ad60e46a5eb82e->doDisplay() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 13 Twig\Template->displayWithErrorHandling() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 12 Twig\Template->display() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:434 11 Twig\Template->render() JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47 10 Twig\TemplateWrapper->render() JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384 9 Twig\Environment->render() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163 8 Gantry\Component\Theme\AbstractTheme->render() JROOT/templates/g5_helium/index.php:23 7 require JROOT/templates/g5_helium/index.php JROOT/libraries/src/Document/HtmlDocument.php:668 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:730 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:545 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1030 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:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:51 - Query Time: 2.26 ms After last query: 0.09 ms Query memory: 0.038 MB Memory before query: 7.945 MB Rows returned: 0Duplicate queries: #20
SELECT menu.*
FROM (SELECT DISTINCT parent_menu.*
FROM joom_menu parent_menu JOIN joom_associations assoc1
ON assoc1.`context` = 'com_menus.item'
AND parent_menu.id = assoc1.id JOIN joom_associations assoc2
ON assoc2.`context` = 'com_menus.item'
AND assoc1.`key` = assoc2.`key` JOIN joom_menu parent_menu_assoc
ON parent_menu_assoc.id = assoc2.id
WHERE (parent_menu.alias = 'мой-профиль' OR parent_menu_assoc.alias = 'мой-профиль')
AND parent_menu.language = 'en-GB' ) parent_menu JOIN joom_menu menu
ON menu.parent_id = parent_menu.id
WHERE menu.published = 1
AND menu.access IN (1,9)
ORDER BY menu.lft ASCid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 PRIMARY menu NULL ALL NULL NO INDEX KEY COULD BE USED NULL NULL 150 2.00 Using where; Using filesort 1 PRIMARY <derived2> NULL ref <auto_key0> <auto_key0> 4 baycik_diyar.menu.parent_id 6 100.00 Using where 2 DERIVED assoc1 NULL ref PRIMARY,idx_key PRIMARY 202 const 86 100.00 Using temporary 2 DERIVED parent_menu NULL eq_ref PRIMARY,idx_alias,idx_language PRIMARY 4 baycik_diyar.assoc1.id 1 36.00 Using where 2 DERIVED assoc2 NULL ref PRIMARY,idx_key idx_key 330 baycik_diyar.assoc1.key,const 2 100.00 Using index; Distinct 2 DERIVED parent_menu_assoc NULL eq_ref PRIMARY,idx_alias PRIMARY 4 baycik_diyar.assoc2.id 1 100.00 Using where; Distinct Status Duration starting 0.07 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.09 ms System lock 0.01 ms optimizing 0.00 ms optimizing 0.02 ms statistics 0.14 ms preparing 0.01 ms Creating tmp table 0.04 ms statistics 0.02 ms preparing 0.01 ms Sorting result 0.00 ms executing 0.11 ms Sending data 0.02 ms Creating sort index 0.12 ms executing 0.00 ms Sending data 1.30 ms end 0.01 ms query end 0.01 ms removing tmp table 0.07 ms query end 0.01 ms closing tables 0.00 ms removing tmp table 0.04 ms closing tables 0.04 ms freeing items 0.03 ms cleaning up 0.01 ms # Caller File and line number 52 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506 51 JDatabaseDriver->loadAssocList() JROOT/modules/mod_user_dashboard_mini/helper.php:92 50 ModUserDashboardMiniHelper::getUserMenuTree() JROOT/modules/mod_user_dashboard_mini/mod_user_dashboard_mini.php:24 49 include JROOT/modules/mod_user_dashboard_mini/mod_user_dashboard_mini.php JROOT/libraries/src/Helper/ModuleHelper.php:200 48 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 47 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:195 46 Gantry\Framework\Platform->displayModule() Same as call in the line below. 45 call_user_func_array() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:704 44 Twig\Template->getAttribute() JROOT/cache/gantry5/g5_helium/twig/f3/f33e020a7c995c3091226ca5bf2951dd75aa163487741287c6ac4232bb3ab724.php:43 43 __TwigTemplate_fa24ad7ba18b08a067dfafc88f8f31a8672f91eab329b460a51c1786e9023d78->block_particle() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:216 42 Twig\Template->displayBlock() JROOT/cache/gantry5/g5_helium/twig/72/72fe691d71be39d50030851067d8119b7647bba7855e0d1db5389a5d2ee3b093.php:73 41 __TwigTemplate_65b2adc0b8fc17c3166ffc5b2c534f81cd1ec81c50d53706d96ed2bd3d2c3700->doDisplay() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 40 Twig\Template->displayWithErrorHandling() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 39 Twig\Template->display() JROOT/cache/gantry5/g5_helium/twig/f3/f33e020a7c995c3091226ca5bf2951dd75aa163487741287c6ac4232bb3ab724.php:35 38 __TwigTemplate_fa24ad7ba18b08a067dfafc88f8f31a8672f91eab329b460a51c1786e9023d78->doDisplay() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 37 Twig\Template->displayWithErrorHandling() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 36 Twig\Template->display() JROOT/cache/gantry5/g5_helium/twig/40/40a68c93f9fa61bdbf6a23e309fe06cf50b144274eb149d4c92319eba9049b3f.php:53 35 __TwigTemplate_e3ac87ee957206f0e3e7a15f8428ebb8943621df7c8387192aaaad3239284aa2->doDisplay() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 34 Twig\Template->displayWithErrorHandling() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 33 Twig\Template->display() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:434 32 Twig\Template->render() JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47 31 Twig\TemplateWrapper->render() JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384 30 Twig\Environment->render() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163 29 Gantry\Component\Theme\AbstractTheme->render() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:766 28 Gantry\Framework\Theme->getContent() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:666 27 Gantry\Framework\Theme->renderContent() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:593 26 Gantry\Framework\Theme->prepareLayout() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579 25 Gantry\Framework\Theme->prepareLayout() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579 24 Gantry\Framework\Theme->prepareLayout() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579 23 Gantry\Framework\Theme->prepareLayout() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:422 22 Gantry\Framework\Theme->segments() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:702 21 Twig\Template->getAttribute() JROOT/cache/gantry5/g5_helium/twig/33/338d1ce3e48aeca3c38dcaa34b84b0db9f26e4cdc7d62420ac1e48e9522c3306.php:47 20 __TwigTemplate_11b94903ac9c38de4bb2105a5066ee742973b4957d19cccc6fa09167e85a5546->doDisplay() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 19 Twig\Template->displayWithErrorHandling() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 18 Twig\Template->display() JROOT/cache/gantry5/g5_helium/twig/5a/5a9c061f91d7ca9e615210fa73ebddac3d62aa7de47b8be54b4a5f3517f4cab8.php:35 17 __TwigTemplate_277af7fe659c06d904eb257d5eb4bd19d8ee1919fab0c34eba6f071815650844->doDisplay() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 16 Twig\Template->displayWithErrorHandling() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 15 Twig\Template->display() JROOT/cache/gantry5/g5_helium/twig/54/546c22eede2b41fbdf4f134b6757afffe7a54ce26a7295501abc0a81a19bdbb9.php:35 14 __TwigTemplate_97f532d943bf881f0138e74af281e2606c8525f3ee65d2e711ad60e46a5eb82e->doDisplay() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 13 Twig\Template->displayWithErrorHandling() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 12 Twig\Template->display() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:434 11 Twig\Template->render() JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47 10 Twig\TemplateWrapper->render() JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384 9 Twig\Environment->render() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163 8 Gantry\Component\Theme\AbstractTheme->render() JROOT/templates/g5_helium/index.php:23 7 require JROOT/templates/g5_helium/index.php JROOT/libraries/src/Document/HtmlDocument.php:668 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:730 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:545 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1030 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:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:51 - Query Time: 1.65 ms After last query: 9.65 ms Query memory: 0.026 MB Memory before query: 8.448 MB Rows returned: 29Duplicate queries: #15
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM joom_modules AS m
LEFT JOIN joom_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN joom_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
WHERE m.published = 1
AND e.enabled = 1
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2024-04-23 16:21:58')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-04-23 16:21:58')
AND m.access IN (1,1,5)
AND m.client_id = 0
AND (mm.menuid = 227 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 ALL PRIMARY,published,newsfeeds,idx_language NO INDEX KEY COULD BE USED NULL NULL 46 2.17 Using where; Using filesort 1 SIMPLE e NULL ref element_clientid,element_folder_clientid element_clientid 403 baycik_diyar.m.module,const 1 10.00 Using index condition; Using where 1 SIMPLE mm NULL ref PRIMARY PRIMARY 4 baycik_diyar.m.id 1 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.02 ms init 0.08 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.17 ms preparing 0.04 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.02 ms Creating sort index 0.93 ms end 0.01 ms query end 0.01 ms closing tables 0.05 ms freeing items 0.05 ms cleaning up 0.01 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 13 JDatabaseDriver->loadObjectList() 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/ModuleHelper.php:432 10 Joomla\CMS\Helper\ModuleHelper::getModuleList() JROOT/libraries/src/Helper/ModuleHelper.php:362 9 Joomla\CMS\Helper\ModuleHelper::load() JROOT/libraries/src/Helper/ModuleHelper.php:87 8 Joomla\CMS\Helper\ModuleHelper::getModules() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:45 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:1044 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:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:51
21 Query Types Logged, Sorted by Occurrences.
SELECT Tables:
2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `joom_extensions`2 × SELECT menu.*
FROM (SELECT DISTINCT parent_menu.*
FROM joom_menu parent_menu JOIN joom_associations assoc1
ON assoc1.`context` = 'com_menus.item'
AND parent_menu.id = assoc1.id JOIN joom_associations assoc2
ON assoc2.`context` = 'com_menus.item'
AND assoc1.`key` = assoc2.`key` JOIN joom_menu parent_menu_assoc
ON parent_menu_assoc.id = assoc2.id2 × SELECT COALESCE(SUM(t.points),0) total_points, COALESCE(COUNT(t.points), 0) total_exercises, COALESCE(COUNT(t.id), 0) total_lessons
FROM ( SELECT statistic.points, content.id
FROM joom_content content
LEFT JOIN joom_exercise_statistic statistic
ON content.id = ( SELECT content.id
FROM joom_content content JOIN joom_associations associations
ON associations.id = content.id
AND associations.`context` = 'com_content.item' JOIN joom_associations associations1
ON associations.`key` = associations1.`key`
AND associations.id != associations1.id
AND associations.`context` = 'com_content.item' JOIN joom_content content_assoc
ON content_assoc.id = associations1.id2 × SELECT users.id, COALESCE( (SELECT user_images.`value`
FROM joom_fields_values user_images JOIN joom_fields image_fields
ON user_images.field_id = image_fields.id2 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM joom_modules AS m
LEFT JOIN joom_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN joom_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id1 × SELECT `session_id`
FROM `joom_session`1 × SELECT content_assoc.title
FROM joom_content content JOIN joom_associations associations
ON associations.id = content.id
AND associations.`context` = 'com_content.item' JOIN joom_associations associations1
ON associations.`key` = associations1.`key`
AND associations.id != associations1.id
AND associations.`context` = 'com_content.item' JOIN joom_content content_assoc
ON content_assoc.id = associations1.id1 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `joom_assets`1 × SELECT `c2`.`language`,`c2`.`id`
FROM `joom_menu` AS `c`
INNER JOIN `joom_associations` AS `a`
ON a.id = c.`id`
AND a.context='com_menus.item'
INNER JOIN `joom_associations` AS `a2`
ON `a`.`key` = `a2`.`key`
INNER JOIN `joom_menu` AS `c2`
ON a2.id = c2.`id`1 × SELECT s.id, s.template, s.home, s.title AS long_title, s.params
FROM joom_template_styles AS s1 × SELECT a.menutype
FROM joom_menu_types AS a1 × SELECT id, home, template, s.params
FROM joom_template_styles as s
LEFT JOIN joom_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM joom_menu AS m
LEFT JOIN joom_extensions AS e
ON m.component_id = e.extension_id1 × SELECT `element`,`name`,`client_id`,`extension_id`
FROM `joom_extensions`1 × SELECT *
FROM joom_languages1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM joom_extensions1 × SELECT b.id
FROM joom_usergroups AS a
LEFT JOIN joom_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt1 × SELECT id, rules
FROM `joom_viewlevels1 × SELECT content.id, content.title, content.alias, content.introtext, content.fulltext, content.state, COALESCE(category.title) as parent_title, COALESCE(category.id) as parent_id, content.images, content.created, author.name as creator_name, author_dashboard.avatar_link as creator_image, content.modified, content.access, content.hits, content.language, content.checked_out, content_fields.value as item_type
FROM joom_content content
LEFT JOIN joom_categories category
ON content.catid = category.id
LEFT JOIN joom_contentitem_tag_map tag_to_article
ON tag_to_article.content_item_id = content.id
LEFT JOIN joom_content_authors content_authors
ON content_authors.tag_id = tag_to_article.tag_id
LEFT JOIN joom_users author
ON author.id = content.created_by
LEFT JOIN joom_user_dashboard author_dashboard
ON author.id = author_dashboard.user_id
LEFT JOIN joom_tags tag
ON tag.id = tag_to_article.tag_id
LEFT JOIN joom_fields_values content_fields
ON content.id = content_fields.item_id
OTHER Tables:
1 × INSERT INTO `joom_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'3535613063373164643862623338623335333164623034613839623237336264', 1, 1713889318, 0, '', 01 × UPDATE `joom_extensions`
SET `params` = '{\"mediaversion\":\"75c9e577e0f17ee3941e9698290a263c\"}'