Join us!
Diyar is daily developing and expanding extensively. And this process has no end, because we constantly have new ideas concerning to various useful features. Let's invent new features and extend Diyar with us!
I'm with you!
diyar.ım is a modern educational platform. Our main purpose is to make an education for Crimean Tatar more available and free.
But we don't want to talk about that idea a lot. We just implement that idea to life.
If you have the opportunity to help develop our idea, please contact us, and if you want to learn more about our activities and our plans tap here. Any of your contributions is very valuable to us.
Read More
Dictionary
Here is crimean tatar to russian and vice versa Luğatçıq dictionary, that is constantly expanded with new words and functions.
Open the dictionary
Knowledge Base
Learn more and more new and intersting stuff from in our knowledge base! Also you can extend it and add your own articles!
Go to the knowledge base
Courses
Here you can take lessons, discover new knowledge, participate in challenges and get points for all this! "Knowledge is the key to development". And we want everyone to be able to get this key.
Open courses
Our purposes
Education
We do our best to make the content as useful and informative as possible, because knowledge is the engine of progress.
Progress
We are always working on expanding of the functionality, gathering and adding of a new content and don't even think to slow down.
Unity
We believe that our work will help many Crimean Tatars learn more about who they are and about the importance of unity in their future.
Joomla! Debug Console
{
"__default": {
"session": {
"counter": 1,
"timer": {
"start": 1675159283,
"last": 1675159283,
"now": 1675159283
}
},
"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: 5.51 ms / 5.51 ms Memory: 0.504 MB / 0.88 MB Application: afterLoad
Time: 29.38 ms / 34.89 ms Memory: 1.351 MB / 2.23 MB Application: afterInitialise
Time: 15.29 ms / 50.19 ms Memory: 0.587 MB / 2.82 MB Application: afterRoute
Time: 0.23 ms / 50.42 ms Memory: 0.005 MB / 2.82 MB Application: beforeRenderComponent com_gantry5
Time: 0.18 ms / 50.60 ms Memory: 0.002 MB / 2.83 MB Application: afterRenderComponent com_gantry5
Time: 2.53 ms / 53.13 ms Memory: 0.021 MB / 2.85 MB Application: afterDispatch
Time: 52.17 ms / 105.30 ms Memory: 4.236 MB / 7.08 MB Application: beforeRenderModule mod_languages_custom (Languages Custom)
Time: 3.44 ms / 108.75 ms Memory: 0.119 MB / 7.20 MB Application: afterRenderModule mod_languages_custom (Languages Custom)
Time: 0.13 ms / 108.88 ms Memory: 0.001 MB / 7.20 MB Application: Before Access::preloadComponents (all components)
Time: 1.12 ms / 110.00 ms Memory: 0.049 MB / 7.25 MB Application: After Access::preloadComponents (all components)
Time: 0.04 ms / 110.04 ms Memory: -0.001 MB / 7.25 MB Application: Before Access::getAssetRules (id:16 name:com_menus)
Time: 0.42 ms / 110.46 ms Memory: 0.009 MB / 7.26 MB Application: After Access::getAssetRules (id:16 name:com_menus)
Time: 1.23 ms / 111.69 ms Memory: -0.081 MB / 7.18 MB Application: beforeRenderModule mod_user_dashboard_mini (User Dashboard Mini)
Time: 7.86 ms / 119.55 ms Memory: 0.081 MB / 7.26 MB Application: afterRenderModule mod_user_dashboard_mini (User Dashboard Mini)
Time: 1.00 ms / 120.55 ms Memory: 0.004 MB / 7.26 MB Application: beforeRenderModule mod_home_complex_header (Complex Header)
Time: 0.49 ms / 121.04 ms Memory: 0.013 MB / 7.28 MB Application: afterRenderModule mod_home_complex_header (Complex Header)
Time: 1.30 ms / 122.34 ms Memory: 0.008 MB / 7.29 MB Application: beforeRenderModule mod_home_sections (Home Sections)
Time: 0.51 ms / 122.85 ms Memory: 0.013 MB / 7.30 MB Application: afterRenderModule mod_home_sections (Home Sections)
Time: 0.91 ms / 123.76 ms Memory: 0.007 MB / 7.31 MB Application: beforeRenderModule mod_home_join_us (Home Join Us)
Time: 0.54 ms / 124.30 ms Memory: 0.010 MB / 7.32 MB Application: afterRenderModule mod_home_join_us (Home Join Us)
Time: 4.27 ms / 128.57 ms Memory: 0.091 MB / 7.41 MB Application: beforeRenderModule mod_user_dashboard_mini (User Dashboard Mini)
Time: 6.76 ms / 135.33 ms Memory: 0.072 MB / 7.48 MB Application: afterRenderModule mod_user_dashboard_mini (User Dashboard Mini)
Time: 18.78 ms / 154.12 ms Memory: 0.580 MB / 8.06 MB Application: afterRender
Database queries total: 22.76 ms
8.38 MB (8,787,784 Bytes)
24 Queries Logged 22.76 ms
8 duplicate found!
- Query Time: 0.33 ms Query memory: 0.020 MB Memory before query: 1.259 MB Rows returned: 0
SELECT `session_id`
FROM `joom_session`
WHERE `session_id` = X'3166353331363435363963366135386130623338633438356134313139316165'
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.06 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.05 ms executing 0.01 ms end 0.00 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.04 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.23 ms After last query: 0.20 ms Query memory: 0.004 MB Memory before query: 1.264 MB
INSERT INTO `joom_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'3166353331363435363963366135386130623338633438356134313139316165', 1, 1675159283, 0, '', 0)EXPLAIN not possible on query: INSERT INTO `joom_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3166353331363435363963366135386130623338633438356134313139316165', 1, 1675159283, 0, '', 0)Status Duration starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.01 ms System lock 0.00 ms update 0.09 ms end 0.01 ms query end 0.02 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.67 ms After last query: 1.76 ms Query memory: 0.024 MB Memory before query: 1.300 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.00 ms Opening tables 0.01 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.06 ms preparing 0.02 ms executing 0.00 ms Sending data 0.24 ms end 0.00 ms query end 0.01 ms closing tables 0.01 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.21 ms After last query: 1.64 ms Query memory: 0.021 MB Memory before query: 1.333 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.02 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.01 ms System lock 0.01 ms optimizing 0.00 ms statistics 0.01 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.01 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.28 ms After last query: 0.13 ms Query memory: 0.021 MB Memory before query: 1.346 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.04 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.02 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.07 ms preparing 0.01 ms executing 0.00 ms Sending data 0.02 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.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.37 ms After last query: 0.31 ms Query memory: 0.030 MB Memory before query: 1.368 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.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.04 ms preparing 0.02 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.01 ms Creating sort index 1.03 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 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.41 ms After last query: 0.73 ms Query memory: 0.019 MB Memory before query: 1.428 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.03 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.04 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.01 ms Creating sort index 0.06 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 7 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 6 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Language/LanguageHelper.php:150 5 Joomla\CMS\Language\LanguageHelper::getLanguages() JROOT/libraries/src/Language/LanguageHelper.php:67 4 Joomla\CMS\Language\LanguageHelper::detectLanguage() JROOT/libraries/src/Application/SiteApplication.php:653 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:51 - Query Time: 0.31 ms After last query: 6.80 ms Query memory: 0.021 MB Memory before query: 1.902 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.04 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.05 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.03 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: 0.76 ms After last query: 3.59 ms Query memory: 0.078 MB Memory before query: 2.047 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.06 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.02 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.01 ms Sorting result 0.00 ms executing 0.00 ms Sending data 0.01 ms Creating sort index 0.43 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 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.79 ms After last query: 4.64 ms Query memory: 0.025 MB Memory before query: 2.328 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.04 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.04 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.12 ms preparing 0.03 ms executing 0.01 ms Sending data 0.31 ms end 0.01 ms query end 0.01 ms closing tables 0.03 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.22 ms After last query: 5.94 ms Query memory: 0.026 MB Memory before query: 2.675 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.03 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.01 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.03 ms end 0.00 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 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.19 ms After last query: 0.15 ms Query memory: 0.009 MB Memory before query: 2.669 MB
UPDATE `joom_extensions`
SET `params` = '{\"mediaversion\":\"f5e2823d98db9fff9546033ba778f20f\"}'
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.02 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.01 ms System lock 0.04 ms updating 0.04 ms end 0.01 ms query end 0.02 ms closing tables 0.01 ms freeing items 0.01 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.37 ms After last query: 2.83 ms Query memory: 0.027 MB Memory before query: 2.817 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.04 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.02 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.06 ms preparing 0.02 ms Sorting result 0.00 ms executing 0.00 ms Sending data 0.10 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 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.50 ms After last query: 40.28 ms Query memory: 0.035 MB Memory before query: 6.506 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.04 ms checking permissions 0.01 ms Opening tables 0.28 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 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.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 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.37 ms After last query: 13.38 ms Query memory: 0.046 MB Memory before query: 7.048 MB Rows returned: 29Duplicate queries: #21
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM joom_modules AS m
LEFT JOIN joom_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN joom_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
WHERE m.published = 1
AND e.enabled = 1
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2023-01-31 10:01:23')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-01-31 10:01:23')
AND m.access IN (1,1,5)
AND m.client_id = 0
AND (mm.menuid = 109 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.14 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.01 ms Opening tables 0.15 ms init 0.05 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.11 ms preparing 0.04 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.01 ms Creating sort index 0.67 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 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.70 ms After last query: 1.58 ms Query memory: 0.042 MB Memory before query: 7.117 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 = 109id 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.34 ms init 0.03 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.10 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.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.86 ms After last query: 2.07 ms Query memory: 0.043 MB Memory before query: 7.208 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.07 ms checking permissions 0.00 ms Opening tables 0.09 ms init 0.04 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.16 ms preparing 0.01 ms executing 0.00 ms Sending data 0.38 ms end 0.01 ms query end 0.01 ms closing tables 0.01 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.73 ms After last query: 2.73 ms Query memory: 0.038 MB Memory before query: 7.202 MB Rows returned: 0Duplicate queries: #22
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.06 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.42 ms init 0.03 ms System lock 0.00 ms optimizing 0.00 ms statistics 0.03 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.02 ms optimizing 0.01 ms statistics 0.02 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.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.80 ms After last query: 0.10 ms Query memory: 0.038 MB Memory before query: 7.229 MB Rows returned: 1Duplicate queries: #23
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.19 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.74 ms init 0.10 ms System lock 0.01 ms optimizing 0.00 ms optimizing 0.02 ms statistics 0.18 ms preparing 0.03 ms Creating tmp table 0.02 ms Sorting result 0.02 ms optimizing 0.02 ms statistics 0.12 ms preparing 0.03 ms statistics 0.01 ms preparing 0.01 ms executing 0.01 ms Sending data 0.01 ms executing 0.00 ms Sending data 0.99 ms Creating sort index 0.13 ms end 0.01 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.04 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_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.55 ms After last query: 0.08 ms Query memory: 0.038 MB Memory before query: 7.251 MB Rows returned: 0Duplicate queries: #24
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.12 ms System lock 0.01 ms optimizing 0.00 ms optimizing 0.02 ms statistics 0.17 ms preparing 0.02 ms Creating tmp table 0.05 ms statistics 0.02 ms preparing 0.01 ms Sorting result 0.00 ms executing 0.15 ms Sending data 0.01 ms Creating sort index 0.11 ms executing 0.00 ms Sending data 1.49 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.04 ms closing tables 0.03 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: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.07 ms After last query: 6.91 ms Query memory: 0.043 MB Memory before query: 7.352 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 <= '2023-01-31 10:01:23')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-01-31 10:01:23')
AND m.access IN (1,1,5)
AND m.client_id = 0
AND (mm.menuid = 109 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.08 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.05 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.09 ms preparing 0.02 ms Sorting result 0.00 ms executing 0.00 ms Sending data 0.01 ms Creating sort index 0.65 ms end 0.00 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 56 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 55 JDatabaseDriver->loadObjectList() Same as call in the line below. 54 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 53 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:432 52 Joomla\CMS\Helper\ModuleHelper::getModuleList() JROOT/libraries/src/Helper/ModuleHelper.php:362 51 Joomla\CMS\Helper\ModuleHelper::load() JROOT/libraries/src/Helper/ModuleHelper.php:87 50 Joomla\CMS\Helper\ModuleHelper::getModules() JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:233 49 Gantry\Framework\Platform->displayModules() Same as call in the line below. 48 call_user_func_array() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:704 47 Twig\Template->getAttribute() JROOT/cache/gantry5/g5_helium/twig/8a/8a66d7c05d9feae46ef6ac49576f2cab47dd6d5853859b31aa701d0f92d2935b.php:43 46 __TwigTemplate_018acdaeb33e219624f5668247d3c674c9283377a726b4c771e369f0d31b74fe->block_particle() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:216 45 Twig\Template->displayBlock() JROOT/cache/gantry5/g5_helium/twig/72/72fe691d71be39d50030851067d8119b7647bba7855e0d1db5389a5d2ee3b093.php:73 44 __TwigTemplate_65b2adc0b8fc17c3166ffc5b2c534f81cd1ec81c50d53706d96ed2bd3d2c3700->doDisplay() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 43 Twig\Template->displayWithErrorHandling() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 42 Twig\Template->display() JROOT/cache/gantry5/g5_helium/twig/8a/8a66d7c05d9feae46ef6ac49576f2cab47dd6d5853859b31aa701d0f92d2935b.php:35 41 __TwigTemplate_018acdaeb33e219624f5668247d3c674c9283377a726b4c771e369f0d31b74fe->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/40/40a68c93f9fa61bdbf6a23e309fe06cf50b144274eb149d4c92319eba9049b3f.php:53 38 __TwigTemplate_e3ac87ee957206f0e3e7a15f8428ebb8943621df7c8387192aaaad3239284aa2->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/libraries/gantry5/vendor/twig/twig/src/Template.php:434 35 Twig\Template->render() JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47 34 Twig\TemplateWrapper->render() JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384 33 Twig\Environment->render() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163 32 Gantry\Component\Theme\AbstractTheme->render() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:766 31 Gantry\Framework\Theme->getContent() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:666 30 Gantry\Framework\Theme->renderContent() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:593 29 Gantry\Framework\Theme->prepareLayout() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579 28 Gantry\Framework\Theme->prepareLayout() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579 27 Gantry\Framework\Theme->prepareLayout() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579 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.59 ms After last query: 1.97 ms Query memory: 0.038 MB Memory before query: 7.422 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.12 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.07 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.04 ms optimizing 0.02 ms statistics 0.04 ms preparing 0.02 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.01 ms executing 0.02 ms end 0.01 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.05 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.96 ms After last query: 0.08 ms Query memory: 0.038 MB Memory before query: 7.449 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.34 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.01 ms Opening tables 0.05 ms init 0.17 ms System lock 0.01 ms optimizing 0.01 ms optimizing 0.03 ms statistics 0.30 ms preparing 0.04 ms Creating tmp table 0.02 ms Sorting result 0.01 ms optimizing 0.03 ms statistics 0.15 ms preparing 0.03 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.42 ms Creating sort index 0.12 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.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_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.48 ms After last query: 0.08 ms Query memory: 0.038 MB Memory before query: 7.472 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.06 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.01 ms init 0.08 ms System lock 0.01 ms optimizing 0.00 ms optimizing 0.02 ms statistics 0.19 ms preparing 0.02 ms Creating tmp table 0.06 ms statistics 0.03 ms preparing 0.01 ms Sorting result 0.01 ms executing 0.12 ms Sending data 0.01 ms Creating sort index 0.15 ms executing 0.00 ms Sending data 1.47 ms end 0.00 ms query end 0.01 ms removing tmp table 0.05 ms query end 0.00 ms closing tables 0.00 ms removing tmp table 0.04 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
19 Query Types Logged, Sorted by Occurrences.
SELECT Tables:
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 `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `joom_extensions`2 × 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 `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 a.menutype
FROM joom_menu_types AS a1 × SELECT `session_id`
FROM `joom_session`1 × SELECT s.id, s.template, s.home, s.title AS long_title, s.params
FROM joom_template_styles AS s1 × 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 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
OTHER Tables:
1 × INSERT INTO `joom_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'3166353331363435363963366135386130623338633438356134313139316165', 1, 1675159283, 0, '', 01 × UPDATE `joom_extensions`
SET `params` = '{\"mediaversion\":\"f5e2823d98db9fff9546033ba778f20f\"}'