Joomla! Debug Console
{
"__default": {
"session": {
"counter": 1,
"timer": {
"start": 1728777631,
"last": 1728777631,
"now": 1728777631
},
"token": "QInBWQTOVQmlnkD1bEdemPmwzi4bAI8w"
},
"registry": {
"com_contact": {
"contact": {
"data": {
"catid": "4"
}
}
}
},
"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.17 ms / 5.17 ms Memory: 0.504 MB / 0.88 MB Application: afterLoad
Time: 30.58 ms / 35.75 ms Memory: 1.351 MB / 2.23 MB Application: afterInitialise
Time: 15.64 ms / 51.39 ms Memory: 0.587 MB / 2.82 MB Application: afterRoute
Time: 0.76 ms / 52.15 ms Memory: 0.016 MB / 2.84 MB Application: beforeRenderComponent com_contact
Time: 1.84 ms / 53.99 ms Memory: 0.123 MB / 2.96 MB Application: Before Access::preloadComponents (all components)
Time: 1.32 ms / 55.31 ms Memory: 0.031 MB / 2.99 MB Application: After Access::preloadComponents (all components)
Time: 0.04 ms / 55.35 ms Memory: -0.001 MB / 2.99 MB Application: Before Access::getAssetRules (id:7 name:com_contact)
Time: 0.32 ms / 55.67 ms Memory: 0.009 MB / 3.00 MB Application: After Access::getAssetRules (id:7 name:com_contact)
Time: 10.96 ms / 66.63 ms Memory: 0.265 MB / 3.26 MB Application: Before Access::getAssetRules (id:1 name:root.1)
Time: 0.12 ms / 66.75 ms Memory: 0.008 MB / 3.27 MB Application: After Access::getAssetRules (id:1 name:root.1)
Time: 14.54 ms / 81.29 ms Memory: 0.317 MB / 3.59 MB Application: Before Access::getAssetRules (id:1 name:root.1)
Time: 0.04 ms / 81.33 ms Memory: 0.002 MB / 3.59 MB Application: After Access::getAssetRules (id:1 name:root.1)
Time: 22.89 ms / 104.22 ms Memory: 0.399 MB / 3.99 MB Application: afterRenderComponent com_contact
Time: 0.43 ms / 104.65 ms Memory: 0.006 MB / 4.00 MB Application: afterDispatch
Time: 42.88 ms / 147.53 ms Memory: 4.410 MB / 8.41 MB Application: beforeRenderModule mod_languages_custom (Languages Custom)
Time: 3.63 ms / 151.16 ms Memory: 0.089 MB / 8.49 MB Application: afterRenderModule mod_languages_custom (Languages Custom)
Time: 0.05 ms / 151.21 ms Memory: -0.000 MB / 8.49 MB Application: Before Access::getAssetRules (id:16 name:com_menus)
Time: 0.07 ms / 151.28 ms Memory: 0.009 MB / 8.50 MB Application: After Access::getAssetRules (id:16 name:com_menus)
Time: 0.89 ms / 152.17 ms Memory: -0.061 MB / 8.44 MB Application: beforeRenderModule mod_user_dashboard_mini (User Dashboard Mini)
Time: 8.34 ms / 160.51 ms Memory: 0.082 MB / 8.52 MB Application: afterRenderModule mod_user_dashboard_mini (User Dashboard Mini)
Time: 3.05 ms / 163.57 ms Memory: 0.084 MB / 8.61 MB Application: beforeRenderModule mod_user_dashboard_mini (User Dashboard Mini)
Time: 4.62 ms / 168.19 ms Memory: 0.072 MB / 8.68 MB Application: afterRenderModule mod_user_dashboard_mini (User Dashboard Mini)
Time: 12.60 ms / 180.79 ms Memory: 0.596 MB / 9.28 MB Application: afterRender
Database queries total: 39.01 ms
9.94 MB (10,425,944 Bytes)
50 Queries Logged 39.01 ms
14 duplicate found!
- Query Time: 0.36 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'3536353663343661653239616130633964386662613764353137336232373035'
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.04 ms checking permissions 0.01 ms Opening tables 0.10 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.03 ms executing 0.02 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.35 ms After last query: 0.12 ms Query memory: 0.004 MB Memory before query: 1.265 MB
INSERT INTO `joom_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'3536353663343661653239616130633964386662613764353137336232373035', 1, 1728777631, 0, '', 0)EXPLAIN not possible on query: INSERT INTO `joom_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3536353663343661653239616130633964386662613764353137336232373035', 1, 1728777631, 0, '', 0)Status Duration starting 0.05 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.02 ms System lock 0.00 ms update 0.11 ms end 0.00 ms query end 0.05 ms closing tables 0.02 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.97 ms After last query: 1.16 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.06 ms checking permissions 0.01 ms Opening tables 0.10 ms init 0.03 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.07 ms preparing 0.02 ms executing 0.00 ms Sending data 0.40 ms end 0.00 ms query end 0.01 ms closing tables 0.03 ms freeing items 0.04 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.43 ms After last query: 1.01 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.04 ms checking permissions 0.01 ms Opening tables 0.10 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.06 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 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.57 ms After last query: 0.11 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.06 ms checking permissions 0.01 ms checking permissions 0.00 ms Opening tables 0.18 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.08 ms preparing 0.02 ms executing 0.00 ms Sending data 0.03 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 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.57 ms After last query: 0.38 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.07 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.03 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.07 ms preparing 0.03 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.01 ms Creating sort index 1.15 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 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.42 ms After last query: 0.56 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.09 ms init 0.01 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms Sorting result 0.00 ms executing 0.00 ms Sending data 0.01 ms Creating sort index 0.05 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms # Caller File and line number 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.54 ms After last query: 6.34 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.06 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.03 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.08 ms preparing 0.02 ms executing 0.00 ms Sending data 0.09 ms end 0.01 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.03 ms cleaning up 0.01 ms # Caller File and line number 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 9 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Language/LanguageHelper.php:209 8 Joomla\CMS\Language\LanguageHelper::getInstalledLanguages() JROOT/plugins/system/languagefilter/languagefilter.php:110 7 PlgSystemLanguageFilter->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:283 6 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 5 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/libraries/src/Application/CMSApplication.php:625 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:51 - Query Time: 1.58 ms After last query: 3.68 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.11 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.13 ms init 0.04 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.07 ms preparing 0.02 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.03 ms Creating sort index 0.94 ms end 0.01 ms query end 0.01 ms closing tables 0.03 ms freeing items 0.05 ms cleaning up 0.02 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.78 ms After last query: 4.65 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.05 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.07 ms init 0.03 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.08 ms preparing 0.03 ms executing 0.00 ms Sending data 0.33 ms end 0.01 ms query end 0.01 ms closing tables 0.03 ms freeing items 0.02 ms cleaning up 0.01 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.37 ms After last query: 5.80 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.05 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.07 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.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.36 ms After last query: 0.17 ms Query memory: 0.009 MB Memory before query: 2.669 MB
UPDATE `joom_extensions`
SET `params` = '{\"mediaversion\":\"fd745c5fcec9f03420495cec7a9ae55c\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 UPDATE joom_extensions NULL range element_clientid,element_folder_clientid,extension extension 484 const,const 1 100.00 Using where Status Duration starting 0.03 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.01 ms System lock 0.06 ms updating 0.07 ms end 0.01 ms query end 0.07 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms # Caller File and line number 20 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Helper/LibraryHelper.php:117 19 Joomla\CMS\Helper\LibraryHelper::saveParams() JROOT/libraries/src/Version.php:372 18 Joomla\CMS\Version->setMediaVersion() JROOT/libraries/src/Version.php:331 17 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 16 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 15 Joomla\CMS\Factory::getDocument() JROOT/libraries/gantry5/classes/Gantry/Framework/Theme.php:163 14 Gantry\Framework\Theme->init() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:67 13 Gantry\Component\Theme\AbstractTheme->__construct() JROOT/templates/g5_helium/includes/theme.php:28 12 plgSystemGantry5->{closure}() JROOT/libraries/gantry5/vendor/pimple/pimple/src/Pimple/Container.php:118 11 Pimple\Container->offsetGet() JROOT/plugins/system/gantry5/gantry5.php:234 10 plgSystemGantry5->onAfterRouteSite() JROOT/plugins/system/gantry5/gantry5.php:57 9 plgSystemGantry5->onAfterRoute() Same as call in the line below. 8 call_user_func_array() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1122 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:51 - Query Time: 0.48 ms After last query: 2.83 ms Query memory: 0.027 MB Memory before query: 2.818 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.07 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.06 ms preparing 0.02 ms Sorting result 0.00 ms executing 0.00 ms Sending data 0.13 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 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: 1.15 ms After last query: 3.74 ms Query memory: 0.027 MB Memory before query: 2.963 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.09 ms checking permissions 0.01 ms Opening tables 0.09 ms init 0.07 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.27 ms preparing 0.02 ms executing 0.00 ms Sending data 0.46 ms end 0.01 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 21 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 20 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Access/Access.php:429 19 Joomla\CMS\Access\Access::preloadComponents() JROOT/libraries/src/Access/Access.php:213 18 Joomla\CMS\Access\Access::preload() JROOT/libraries/src/Access/Access.php:531 17 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 16 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 15 Joomla\CMS\User\User->authorise() JROOT/components/com_contact/models/contact.php:62 14 ContactModelContact->populateState() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:440 13 Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() JROOT/components/com_contact/models/contact.php:165 12 ContactModelContact->getItem() JROOT/libraries/src/MVC/View/HtmlView.php:425 11 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_contact/views/contact/view.html.php:72 10 ContactViewContact->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_contact/controller.php:68 8 ContactController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_contact/contact.php:29 6 require_once JROOT/components/com_contact/contact.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:51 - Query Time: 1.19 ms After last query: 0.59 ms Query memory: 0.023 MB Memory before query: 3.003 MB Rows returned: 1
SELECT a.*,
CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias
FROM joom_contact_details AS a
LEFT JOIN joom_categories AS c
on c.id = a.catid
LEFT JOIN joom_categories as parent
ON parent.id = c.parent_id
WHERE a.id = 1
AND (a.published = 1 OR a.published =2)
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-10-13 00:00:31')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-10-13 00:00:31')id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL const PRIMARY,idx_state PRIMARY 4 const 1 100.00 NULL 1 SIMPLE c NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 SIMPLE parent NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.14 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.24 ms init 0.10 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.13 ms preparing 0.02 ms executing 0.00 ms Sending data 0.06 ms end 0.00 ms query end 0.01 ms closing tables 0.03 ms freeing items 0.04 ms cleaning up 0.01 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 13 JDatabaseDriver->loadObject() JROOT/components/com_contact/models/contact.php:225 12 ContactModelContact->getItem() JROOT/libraries/src/MVC/View/HtmlView.php:425 11 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_contact/views/contact/view.html.php:72 10 ContactViewContact->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_contact/controller.php:68 8 ContactController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_contact/contact.php:29 6 require_once JROOT/components/com_contact/contact.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:51 - Query Time: 0.97 ms After last query: 0.89 ms Query memory: 0.023 MB Memory before query: 3.032 MB Rows returned: 0Duplicate queries: #37
SELECT `m`.`tag_id`,`t`.*
FROM `joom_contentitem_tag_map` AS m
INNER JOIN `joom_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_contact.contact'
AND `m`.`content_item_id` = 1
AND `t`.`published` = 1
AND t.access IN (1,1,5)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL ALL idx_tag_type NO INDEX KEY COULD BE USED NULL NULL 667 1.00 Using where 1 SIMPLE t NULL eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 baycik_diyar.m.tag_id 1 81.25 Using where Status Duration starting 0.06 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.18 ms init 0.04 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.09 ms preparing 0.02 ms executing 0.00 ms Sending data 0.32 ms end 0.00 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.02 ms cleaning up 0.01 ms # Caller File and line number 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 14 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Helper/TagsHelper.php:454 13 Joomla\CMS\Helper\TagsHelper->getItemTags() JROOT/components/com_contact/models/contact.php:255 12 ContactModelContact->getItem() JROOT/libraries/src/MVC/View/HtmlView.php:425 11 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_contact/views/contact/view.html.php:72 10 ContactViewContact->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_contact/controller.php:68 8 ContactController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_contact/contact.php:29 6 require_once JROOT/components/com_contact/contact.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:51 - Query Time: 0.79 ms After last query: 1.06 ms Query memory: 0.029 MB Memory before query: 3.064 MB Rows returned: 16
SHOW FULL COLUMNS
FROM `joom_users`EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `joom_users`Status Duration starting 0.03 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.18 ms init 0.01 ms System lock 0.00 ms optimizing 0.00 ms statistics 0.01 ms preparing 0.01 ms executing 0.01 ms Opening tables 0.08 ms checking permissions 0.04 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Sending data 0.06 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms removing tmp table 0.05 ms closing tables 0.00 ms freeing items 0.02 ms cleaning up 0.00 ms # Caller File and line number 23 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 22 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:445 21 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:245 20 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:164 19 Joomla\CMS\Table\Table->__construct() JROOT/libraries/src/Table/User.php:41 18 Joomla\CMS\Table\User->__construct() JROOT/libraries/src/Table/Table.php:312 17 Joomla\CMS\Table\Table::getInstance() JROOT/administrator/components/com_users/models/user.php:64 16 UsersModelUser->getTable() JROOT/libraries/src/MVC/Model/AdminModel.php:969 15 Joomla\CMS\MVC\Model\AdminModel->getItem() JROOT/administrator/components/com_users/models/user.php:89 14 UsersModelUser->getItem() JROOT/components/com_contact/models/contact.php:395 13 ContactModelContact->buildContactExtendedData() JROOT/components/com_contact/models/contact.php:291 12 ContactModelContact->getItem() JROOT/libraries/src/MVC/View/HtmlView.php:425 11 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_contact/views/contact/view.html.php:72 10 ContactViewContact->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_contact/controller.php:68 8 ContactController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_contact/contact.php:29 6 require_once JROOT/components/com_contact/contact.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:51 - Query Time: 0.33 ms After last query: 0.87 ms Query memory: 0.025 MB Memory before query: 3.095 MB Rows returned: 1Duplicate queries: #29
SELECT *
FROM `joom_users`
WHERE `id` = 366id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE joom_users NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.02 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.01 ms executing 0.00 ms Sending data 0.02 ms end 0.00 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.02 ms cleaning up 0.00 ms # Caller File and line number 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 17 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/User.php:87 16 Joomla\CMS\Table\User->load() JROOT/libraries/src/MVC/Model/AdminModel.php:974 15 Joomla\CMS\MVC\Model\AdminModel->getItem() JROOT/administrator/components/com_users/models/user.php:89 14 UsersModelUser->getItem() JROOT/components/com_contact/models/contact.php:395 13 ContactModelContact->buildContactExtendedData() JROOT/components/com_contact/models/contact.php:291 12 ContactModelContact->getItem() JROOT/libraries/src/MVC/View/HtmlView.php:425 11 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_contact/views/contact/view.html.php:72 10 ContactViewContact->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_contact/controller.php:68 8 ContactController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_contact/contact.php:29 6 require_once JROOT/components/com_contact/contact.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:51 - Query Time: 0.36 ms After last query: 0.77 ms Query memory: 0.024 MB Memory before query: 3.109 MB Rows returned: 3Duplicate queries: #30
SELECT `g`.`id`,`g`.`title`
FROM `joom_usergroups` AS g
INNER JOIN `joom_user_usergroup_map` AS m
ON m.group_id = g.id
WHERE `m`.`user_id` = 366id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL ref PRIMARY PRIMARY 4 const 3 100.00 Using index 1 SIMPLE g NULL eq_ref PRIMARY PRIMARY 4 baycik_diyar.m.group_id 1 100.00 NULL Status Duration starting 0.03 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.07 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.04 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 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506 17 JDatabaseDriver->loadAssocList() JROOT/libraries/src/Table/User.php:112 16 Joomla\CMS\Table\User->load() JROOT/libraries/src/MVC/Model/AdminModel.php:974 15 Joomla\CMS\MVC\Model\AdminModel->getItem() JROOT/administrator/components/com_users/models/user.php:89 14 UsersModelUser->getItem() JROOT/components/com_contact/models/contact.php:395 13 ContactModelContact->buildContactExtendedData() JROOT/components/com_contact/models/contact.php:291 12 ContactModelContact->getItem() JROOT/libraries/src/MVC/View/HtmlView.php:425 11 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_contact/views/contact/view.html.php:72 10 ContactViewContact->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_contact/controller.php:68 8 ContactController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_contact/contact.php:29 6 require_once JROOT/components/com_contact/contact.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:51 - Query Time: 0.70 ms After last query: 2.13 ms Query memory: 0.031 MB Memory before query: 3.218 MB Rows returned: 24
SHOW FULL COLUMNS
FROM `joom_menu`EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `joom_menu`Status Duration starting 0.03 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.14 ms init 0.01 ms System lock 0.00 ms optimizing 0.00 ms statistics 0.01 ms preparing 0.01 ms executing 0.01 ms Opening tables 0.02 ms checking permissions 0.03 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Sending data 0.09 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms removing tmp table 0.04 ms closing tables 0.00 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/joomla/database/driver/mysqli.php:445 22 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:245 21 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:164 20 Joomla\CMS\Table\Table->__construct() JROOT/libraries/src/Table/Menu.php:33 19 Joomla\CMS\Table\Menu->__construct() JROOT/libraries/src/Table/Table.php:312 18 Joomla\CMS\Table\Table::getInstance() JROOT/plugins/system/sociallogin/Features/UserFields.php:129 17 plgSystemSociallogin->onContentPrepareForm() Same as call in the line below. 16 call_user_func_array() JROOT/libraries/joomla/event/event.php:70 15 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 14 JEventDispatcher->trigger() JROOT/components/com_contact/models/contact.php:411 13 ContactModelContact->buildContactExtendedData() JROOT/components/com_contact/models/contact.php:291 12 ContactModelContact->getItem() JROOT/libraries/src/MVC/View/HtmlView.php:425 11 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_contact/views/contact/view.html.php:72 10 ContactViewContact->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_contact/controller.php:68 8 ContactController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_contact/contact.php:29 6 require_once JROOT/components/com_contact/contact.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:51 - Query Time: 0.27 ms After last query: 0.27 ms Query memory: 0.025 MB Memory before query: 3.259 MB Rows returned: 1
SELECT *
FROM joom_menu
WHERE `id` = '185'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE joom_menu NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.03 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.05 ms preparing 0.01 ms executing 0.00 ms Sending data 0.02 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 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 19 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/Table.php:731 18 Joomla\CMS\Table\Table->load() JROOT/plugins/system/sociallogin/Features/UserFields.php:130 17 plgSystemSociallogin->onContentPrepareForm() Same as call in the line below. 16 call_user_func_array() JROOT/libraries/joomla/event/event.php:70 15 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 14 JEventDispatcher->trigger() JROOT/components/com_contact/models/contact.php:411 13 ContactModelContact->buildContactExtendedData() JROOT/components/com_contact/models/contact.php:291 12 ContactModelContact->getItem() JROOT/libraries/src/MVC/View/HtmlView.php:425 11 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_contact/views/contact/view.html.php:72 10 ContactViewContact->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_contact/controller.php:68 8 ContactController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_contact/contact.php:29 6 require_once JROOT/components/com_contact/contact.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:51 - Query Time: 1.24 ms After last query: 1.64 ms Query memory: 0.028 MB Memory before query: 3.289 MB Rows returned: 3
SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM joom_fields AS a
LEFT JOIN `joom_languages` AS l
ON l.lang_code = a.language
LEFT JOIN joom_users AS uc
ON uc.id=a.checked_out
LEFT JOIN joom_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN joom_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN joom_fields_groups AS g
ON g.id = a.group_id
WHERE a.context = 'com_users.user'
AND a.access IN (1,1,5)
AND (a.group_id = 0 OR g.access IN (1,1,5))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering ASCid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL ALL idx_state,idx_access,idx_context NO INDEX KEY COULD BE USED NULL NULL 6 55.56 Using where; Using temporary; Using filesort 1 SIMPLE l NULL ALL idx_langcode NO INDEX KEY COULD BE USED NULL NULL 3 100.00 Using where; Using join buffer (Block Nested Loop) 1 SIMPLE uc NULL eq_ref PRIMARY PRIMARY 4 baycik_diyar.a.checked_out 1 100.00 NULL 1 SIMPLE ag NULL eq_ref PRIMARY PRIMARY 4 baycik_diyar.a.access 1 100.00 Using where 1 SIMPLE ua NULL eq_ref PRIMARY PRIMARY 4 baycik_diyar.a.created_user_id 1 100.00 Using where 1 SIMPLE g NULL ALL PRIMARY NO INDEX KEY COULD BE USED NULL NULL 1 100.00 Using where; Using join buffer (Block Nested Loop) Status Duration starting 0.10 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.17 ms init 0.04 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.11 ms preparing 0.05 ms Creating tmp table 0.05 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.30 ms Creating sort index 0.06 ms end 0.00 ms query end 0.01 ms removing tmp table 0.04 ms query end 0.00 ms closing tables 0.04 ms freeing items 0.02 ms cleaning up 0.01 ms # Caller File and line number 24 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 23 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 22 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_fields/models/fields.php:333 21 FieldsModelFields->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:187 20 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 19 FieldsHelper::getFields() JROOT/administrator/components/com_fields/helpers/fields.php:286 18 FieldsHelper::prepareForm() JROOT/plugins/system/fields/fields.php:305 17 PlgSystemFields->onContentPrepareForm() Same as call in the line below. 16 call_user_func_array() JROOT/libraries/joomla/event/event.php:70 15 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 14 JEventDispatcher->trigger() JROOT/components/com_contact/models/contact.php:411 13 ContactModelContact->buildContactExtendedData() JROOT/components/com_contact/models/contact.php:291 12 ContactModelContact->getItem() JROOT/libraries/src/MVC/View/HtmlView.php:425 11 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_contact/views/contact/view.html.php:72 10 ContactViewContact->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_contact/controller.php:68 8 ContactController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_contact/contact.php:29 6 require_once JROOT/components/com_contact/contact.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:51 - Query Time: 0.31 ms After last query: 0.61 ms Query memory: 0.026 MB Memory before query: 3.325 MB Rows returned: 2
SELECT `field_id`,`value`
FROM `joom_fields_values`
WHERE `field_id` IN (2,5,6)
AND `item_id` = '366'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE joom_fields_values NULL ref idx_field_id,idx_item_id idx_item_id 766 const 4 15.02 Using where Status Duration starting 0.03 ms checking permissions 0.00 ms Opening tables 0.07 ms init 0.01 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.01 ms executing 0.00 ms Sending data 0.04 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 22 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 21 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_fields/models/field.php:680 20 FieldsModelField->getFieldValues() JROOT/administrator/components/com_fields/helpers/fields.php:158 19 FieldsHelper::getFields() JROOT/administrator/components/com_fields/helpers/fields.php:350 18 FieldsHelper::prepareForm() JROOT/plugins/system/fields/fields.php:305 17 PlgSystemFields->onContentPrepareForm() Same as call in the line below. 16 call_user_func_array() JROOT/libraries/joomla/event/event.php:70 15 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 14 JEventDispatcher->trigger() JROOT/components/com_contact/models/contact.php:411 13 ContactModelContact->buildContactExtendedData() JROOT/components/com_contact/models/contact.php:291 12 ContactModelContact->getItem() JROOT/libraries/src/MVC/View/HtmlView.php:425 11 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_contact/views/contact/view.html.php:72 10 ContactViewContact->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_contact/controller.php:68 8 ContactController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_contact/contact.php:29 6 require_once JROOT/components/com_contact/contact.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:51 - Query Time: 0.37 ms After last query: 4.72 ms Query memory: 0.026 MB Memory before query: 3.518 MB Rows returned: 0
SELECT a.*,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name
FROM joom_fields_groups AS a
LEFT JOIN `joom_languages` AS l
ON l.lang_code = a.language
LEFT JOIN joom_users AS uc
ON uc.id=a.checked_out
LEFT JOIN joom_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN joom_users AS ua
ON ua.id = a.created_by
WHERE a.context = 'com_users.user'
AND a.access IN (1,1,5)
AND a.state IN (0, 1)
ORDER BY a.ordering ASCid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL ref idx_state,idx_access,idx_context idx_context 766 const 1 100.00 Using where; Using filesort 1 SIMPLE l NULL eq_ref idx_langcode idx_langcode 28 baycik_diyar.a.language 1 100.00 Using where 1 SIMPLE uc NULL eq_ref PRIMARY PRIMARY 4 baycik_diyar.a.checked_out 1 100.00 NULL 1 SIMPLE ag NULL eq_ref PRIMARY PRIMARY 4 baycik_diyar.a.access 1 100.00 Using where 1 SIMPLE ua NULL eq_ref PRIMARY PRIMARY 4 baycik_diyar.a.created_by 1 100.00 Using where Status Duration starting 0.05 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.03 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.06 ms preparing 0.02 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.01 ms Creating sort index 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.01 ms # Caller File and line number 23 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 22 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 21 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_fields/models/groups.php:232 20 FieldsModelGroups->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:187 19 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:410 18 FieldsHelper::prepareForm() JROOT/plugins/system/fields/fields.php:305 17 PlgSystemFields->onContentPrepareForm() Same as call in the line below. 16 call_user_func_array() JROOT/libraries/joomla/event/event.php:70 15 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 14 JEventDispatcher->trigger() JROOT/components/com_contact/models/contact.php:411 13 ContactModelContact->buildContactExtendedData() JROOT/components/com_contact/models/contact.php:291 12 ContactModelContact->getItem() JROOT/libraries/src/MVC/View/HtmlView.php:425 11 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_contact/views/contact/view.html.php:72 10 ContactViewContact->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_contact/controller.php:68 8 ContactController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_contact/contact.php:29 6 require_once JROOT/components/com_contact/contact.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:51 - Query Time: 0.24 ms After last query: 0.44 ms Query memory: 0.026 MB Memory before query: 3.526 MB Rows returned: 1
SELECT `field_id`,`value`
FROM `joom_fields_values`
WHERE `field_id` IN (2)
AND `item_id` = '366'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE joom_fields_values NULL ref idx_field_id,idx_item_id idx_item_id 766 const 4 7.51 Using where 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.04 ms preparing 0.01 ms executing 0.00 ms Sending data 0.03 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms # Caller File and line number 22 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 21 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_fields/models/field.php:680 20 FieldsModelField->getFieldValues() JROOT/administrator/components/com_fields/models/field.php:638 19 FieldsModelField->getFieldValue() JROOT/administrator/components/com_fields/helpers/fields.php:504 18 FieldsHelper::prepareForm() JROOT/plugins/system/fields/fields.php:305 17 PlgSystemFields->onContentPrepareForm() Same as call in the line below. 16 call_user_func_array() JROOT/libraries/joomla/event/event.php:70 15 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 14 JEventDispatcher->trigger() JROOT/components/com_contact/models/contact.php:411 13 ContactModelContact->buildContactExtendedData() JROOT/components/com_contact/models/contact.php:291 12 ContactModelContact->getItem() JROOT/libraries/src/MVC/View/HtmlView.php:425 11 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_contact/views/contact/view.html.php:72 10 ContactViewContact->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_contact/controller.php:68 8 ContactController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_contact/contact.php:29 6 require_once JROOT/components/com_contact/contact.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:51 - Query Time: 0.33 ms After last query: 0.16 ms Query memory: 0.026 MB Memory before query: 3.537 MB Rows returned: 1
SELECT `field_id`,`value`
FROM `joom_fields_values`
WHERE `field_id` IN (5)
AND `item_id` = '366'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE joom_fields_values NULL ref idx_field_id,idx_item_id idx_item_id 766 const 4 7.21 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.06 ms preparing 0.01 ms executing 0.00 ms Sending data 0.05 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 22 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 21 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_fields/models/field.php:680 20 FieldsModelField->getFieldValues() JROOT/administrator/components/com_fields/models/field.php:638 19 FieldsModelField->getFieldValue() JROOT/administrator/components/com_fields/helpers/fields.php:504 18 FieldsHelper::prepareForm() JROOT/plugins/system/fields/fields.php:305 17 PlgSystemFields->onContentPrepareForm() Same as call in the line below. 16 call_user_func_array() JROOT/libraries/joomla/event/event.php:70 15 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 14 JEventDispatcher->trigger() JROOT/components/com_contact/models/contact.php:411 13 ContactModelContact->buildContactExtendedData() JROOT/components/com_contact/models/contact.php:291 12 ContactModelContact->getItem() JROOT/libraries/src/MVC/View/HtmlView.php:425 11 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_contact/views/contact/view.html.php:72 10 ContactViewContact->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_contact/controller.php:68 8 ContactController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_contact/contact.php:29 6 require_once JROOT/components/com_contact/contact.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:51 - Query Time: 0.26 ms After last query: 0.16 ms Query memory: 0.026 MB Memory before query: 3.547 MB Rows returned: 0
SELECT `field_id`,`value`
FROM `joom_fields_values`
WHERE `field_id` IN (6)
AND `item_id` = '366'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE joom_fields_values NULL ref idx_field_id,idx_item_id idx_field_id 4 const 1 5.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.06 ms preparing 0.01 ms executing 0.00 ms Sending data 0.02 ms end 0.00 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.00 ms # Caller File and line number 22 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 21 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_fields/models/field.php:680 20 FieldsModelField->getFieldValues() JROOT/administrator/components/com_fields/models/field.php:638 19 FieldsModelField->getFieldValue() JROOT/administrator/components/com_fields/helpers/fields.php:504 18 FieldsHelper::prepareForm() JROOT/plugins/system/fields/fields.php:305 17 PlgSystemFields->onContentPrepareForm() Same as call in the line below. 16 call_user_func_array() JROOT/libraries/joomla/event/event.php:70 15 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 14 JEventDispatcher->trigger() JROOT/components/com_contact/models/contact.php:411 13 ContactModelContact->buildContactExtendedData() JROOT/components/com_contact/models/contact.php:291 12 ContactModelContact->getItem() JROOT/libraries/src/MVC/View/HtmlView.php:425 11 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_contact/views/contact/view.html.php:72 10 ContactViewContact->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_contact/controller.php:68 8 ContactController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_contact/contact.php:29 6 require_once JROOT/components/com_contact/contact.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:51 - Query Time: 0.34 ms After last query: 2.97 ms Query memory: 0.025 MB Memory before query: 3.541 MB Rows returned: 2
SELECT `profile_key`,`profile_value`
FROM `joom_user_profiles`
WHERE `user_id` = '366'
AND `profile_key` LIKE 'sociallogin.%'
ORDER BY `ordering`id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE joom_user_profiles NULL range idx_user_id_profile_key idx_user_id_profile_key 406 NULL 2 100.00 Using where; Using filesort Status Duration starting 0.03 ms checking permissions 0.00 ms Opening tables 0.07 ms init 0.01 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.01 ms Sorting result 0.00 ms executing 0.00 ms Sending data 0.01 ms Creating sort index 0.05 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.00 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1811 18 JDatabaseDriver->loadRowList() JROOT/plugins/system/sociallogin/Features/UserFields.php:67 17 plgSystemSociallogin->onContentPrepareData() Same as call in the line below. 16 call_user_func_array() JROOT/libraries/joomla/event/event.php:70 15 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 14 JEventDispatcher->trigger() JROOT/components/com_contact/models/contact.php:414 13 ContactModelContact->buildContactExtendedData() JROOT/components/com_contact/models/contact.php:291 12 ContactModelContact->getItem() JROOT/libraries/src/MVC/View/HtmlView.php:425 11 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_contact/views/contact/view.html.php:72 10 ContactViewContact->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_contact/controller.php:68 8 ContactController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_contact/contact.php:29 6 require_once JROOT/components/com_contact/contact.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:51 - Query Time: 0.17 ms After last query: 0.15 ms Query memory: 0.026 MB Memory before query: 3.555 MB Rows returned: 1Duplicate queries: #18
SELECT *
FROM `joom_users`
WHERE `id` = 366id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE joom_users NULL const PRIMARY PRIMARY 4 const 1 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.00 ms optimizing 0.00 ms statistics 0.03 ms preparing 0.00 ms executing 0.00 ms Sending data 0.01 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.00 ms # Caller File and line number 23 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 22 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/User.php:87 21 Joomla\CMS\Table\User->load() JROOT/libraries/src/User/User.php:880 20 Joomla\CMS\User\User->load() JROOT/libraries/src/User/User.php:248 19 Joomla\CMS\User\User->__construct() JROOT/libraries/src/User/User.php:301 18 Joomla\CMS\User\User::getInstance() JROOT/plugins/system/actionlogs/actionlogs.php:168 17 PlgSystemActionLogs->onContentPrepareData() Same as call in the line below. 16 call_user_func_array() JROOT/libraries/joomla/event/event.php:70 15 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 14 JEventDispatcher->trigger() JROOT/components/com_contact/models/contact.php:414 13 ContactModelContact->buildContactExtendedData() JROOT/components/com_contact/models/contact.php:291 12 ContactModelContact->getItem() JROOT/libraries/src/MVC/View/HtmlView.php:425 11 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_contact/views/contact/view.html.php:72 10 ContactViewContact->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_contact/controller.php:68 8 ContactController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_contact/contact.php:29 6 require_once JROOT/components/com_contact/contact.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:51 - Query Time: 0.21 ms After last query: 0.13 ms Query memory: 0.026 MB Memory before query: 3.567 MB Rows returned: 3Duplicate queries: #19
SELECT `g`.`id`,`g`.`title`
FROM `joom_usergroups` AS g
INNER JOIN `joom_user_usergroup_map` AS m
ON m.group_id = g.id
WHERE `m`.`user_id` = 366id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL ref PRIMARY PRIMARY 4 const 3 100.00 Using index 1 SIMPLE g NULL eq_ref PRIMARY PRIMARY 4 baycik_diyar.m.group_id 1 100.00 NULL Status Duration starting 0.03 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.01 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.01 ms executing 0.00 ms Sending data 0.03 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.00 ms # Caller File and line number 23 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506 22 JDatabaseDriver->loadAssocList() JROOT/libraries/src/Table/User.php:112 21 Joomla\CMS\Table\User->load() JROOT/libraries/src/User/User.php:880 20 Joomla\CMS\User\User->load() JROOT/libraries/src/User/User.php:248 19 Joomla\CMS\User\User->__construct() JROOT/libraries/src/User/User.php:301 18 Joomla\CMS\User\User::getInstance() JROOT/plugins/system/actionlogs/actionlogs.php:168 17 PlgSystemActionLogs->onContentPrepareData() Same as call in the line below. 16 call_user_func_array() JROOT/libraries/joomla/event/event.php:70 15 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 14 JEventDispatcher->trigger() JROOT/components/com_contact/models/contact.php:414 13 ContactModelContact->buildContactExtendedData() JROOT/components/com_contact/models/contact.php:291 12 ContactModelContact->getItem() JROOT/libraries/src/MVC/View/HtmlView.php:425 11 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_contact/views/contact/view.html.php:72 10 ContactViewContact->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_contact/controller.php:68 8 ContactController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_contact/contact.php:29 6 require_once JROOT/components/com_contact/contact.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:51 - Query Time: 0.23 ms After last query: 0.13 ms Query memory: 0.026 MB Memory before query: 3.578 MB Rows returned: 8
SELECT b.id
FROM joom_user_usergroup_map AS map
LEFT JOIN joom_usergroups AS a
ON a.id = map.group_id
LEFT JOIN joom_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE map.user_id = 366id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE map NULL ref PRIMARY PRIMARY 4 const 3 100.00 Using index 1 SIMPLE a NULL eq_ref PRIMARY PRIMARY 4 baycik_diyar.map.group_id 1 100.00 NULL 1 SIMPLE b NULL ALL idx_usergroup_nested_set_lookup NO INDEX KEY COULD BE USED NULL NULL 14 100.00 Range checked for each record (index map: 0x10) Status Duration starting 0.03 ms checking permissions 0.00 ms checking permissions 0.00 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.03 ms preparing 0.01 ms executing 0.00 ms Sending data 0.06 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.00 ms # Caller File and line number 22 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 21 JDatabaseDriver->loadColumn() JROOT/libraries/src/Access/Access.php:978 20 Joomla\CMS\Access\Access::getGroupsByUser() JROOT/libraries/src/User/User.php:480 19 Joomla\CMS\User\User->getAuthorisedGroups() JROOT/libraries/src/User/User.php:386 18 Joomla\CMS\User\User->authorise() JROOT/plugins/system/actionlogs/actionlogs.php:168 17 PlgSystemActionLogs->onContentPrepareData() Same as call in the line below. 16 call_user_func_array() JROOT/libraries/joomla/event/event.php:70 15 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 14 JEventDispatcher->trigger() JROOT/components/com_contact/models/contact.php:414 13 ContactModelContact->buildContactExtendedData() JROOT/components/com_contact/models/contact.php:291 12 ContactModelContact->getItem() JROOT/libraries/src/MVC/View/HtmlView.php:425 11 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_contact/views/contact/view.html.php:72 10 ContactViewContact->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_contact/controller.php:68 8 ContactController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_contact/contact.php:29 6 require_once JROOT/components/com_contact/contact.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:51 - Query Time: 0.18 ms After last query: 0.15 ms Query memory: 0.025 MB Memory before query: 3.589 MB Rows returned: 1
SELECT `notify`,`extensions`
FROM `joom_action_logs_users`
WHERE `user_id` = 366id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE joom_action_logs_users NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.02 ms checking permissions 0.00 ms Opening tables 0.06 ms init 0.01 ms System lock 0.00 ms optimizing 0.00 ms statistics 0.02 ms preparing 0.00 ms executing 0.00 ms Sending data 0.01 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.00 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 18 JDatabaseDriver->loadObject() JROOT/plugins/system/actionlogs/actionlogs.php:180 17 PlgSystemActionLogs->onContentPrepareData() Same as call in the line below. 16 call_user_func_array() JROOT/libraries/joomla/event/event.php:70 15 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 14 JEventDispatcher->trigger() JROOT/components/com_contact/models/contact.php:414 13 ContactModelContact->buildContactExtendedData() JROOT/components/com_contact/models/contact.php:291 12 ContactModelContact->getItem() JROOT/libraries/src/MVC/View/HtmlView.php:425 11 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_contact/views/contact/view.html.php:72 10 ContactViewContact->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_contact/controller.php:68 8 ContactController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_contact/contact.php:29 6 require_once JROOT/components/com_contact/contact.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:51 - Query Time: 0.34 ms After last query: 0.33 ms Query memory: 0.026 MB Memory before query: 3.611 MB Rows returned: 11
SELECT profile_key, profile_value
FROM joom_user_profiles
WHERE user_id = 366
AND profile_key LIKE 'profile.%'
ORDER BY orderingid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE joom_user_profiles NULL range idx_user_id_profile_key idx_user_id_profile_key 406 NULL 11 100.00 Using where; Using filesort 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.03 ms preparing 0.01 ms Sorting result 0.00 ms executing 0.00 ms Sending data 0.00 ms Creating sort index 0.08 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 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1811 18 JDatabaseDriver->loadRowList() JROOT/plugins/user/profile/profile.php:92 17 PlgUserProfile->onContentPrepareData() Same as call in the line below. 16 call_user_func_array() JROOT/libraries/joomla/event/event.php:70 15 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 14 JEventDispatcher->trigger() JROOT/components/com_contact/models/contact.php:414 13 ContactModelContact->buildContactExtendedData() JROOT/components/com_contact/models/contact.php:291 12 ContactModelContact->getItem() JROOT/libraries/src/MVC/View/HtmlView.php:425 11 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_contact/views/contact/view.html.php:72 10 ContactViewContact->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_contact/controller.php:68 8 ContactController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_contact/contact.php:29 6 require_once JROOT/components/com_contact/contact.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:51 - Query Time: 1.08 ms After last query: 1.86 ms Query memory: 0.027 MB Memory before query: 3.630 MB Rows returned: 0
SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM joom_fields AS a
LEFT JOIN `joom_languages` AS l
ON l.lang_code = a.language
LEFT JOIN joom_users AS uc
ON uc.id=a.checked_out
LEFT JOIN joom_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN joom_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN joom_fields_groups AS g
ON g.id = a.group_id
WHERE a.context = 'com_contact.mail'
AND a.access IN (1,1,5)
AND (a.group_id = 0 OR g.access IN (1,1,5))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering ASCid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL ref idx_state,idx_access,idx_context idx_context 766 const 1 83.33 Using where; Using temporary; Using filesort 1 SIMPLE l NULL eq_ref idx_langcode idx_langcode 28 baycik_diyar.a.language 1 100.00 Using where 1 SIMPLE uc NULL eq_ref PRIMARY PRIMARY 4 baycik_diyar.a.checked_out 1 100.00 NULL 1 SIMPLE ag NULL eq_ref PRIMARY PRIMARY 4 baycik_diyar.a.access 1 100.00 Using where 1 SIMPLE ua NULL eq_ref PRIMARY PRIMARY 4 baycik_diyar.a.created_user_id 1 100.00 Using where 1 SIMPLE g NULL eq_ref PRIMARY PRIMARY 4 baycik_diyar.a.group_id 1 100.00 Using where Status Duration starting 0.09 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.02 ms init 0.05 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.12 ms preparing 0.05 ms Creating tmp table 0.08 ms Sorting result 0.05 ms executing 0.01 ms Sending data 0.27 ms Creating sort index 0.05 ms end 0.01 ms query end 0.01 ms removing tmp table 0.06 ms query end 0.01 ms closing tables 0.03 ms freeing items 0.03 ms cleaning up 0.01 ms # Caller File and line number 25 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 24 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 23 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_fields/models/fields.php:333 22 FieldsModelFields->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:187 21 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 20 FieldsHelper::getFields() JROOT/administrator/components/com_fields/helpers/fields.php:286 19 FieldsHelper::prepareForm() JROOT/plugins/system/fields/fields.php:305 18 PlgSystemFields->onContentPrepareForm() Same as call in the line below. 17 call_user_func_array() JROOT/libraries/joomla/event/event.php:70 16 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 15 JEventDispatcher->trigger() JROOT/libraries/src/MVC/Model/FormModel.php:321 14 Joomla\CMS\MVC\Model\FormModel->preprocessForm() JROOT/libraries/src/MVC/Model/FormModel.php:242 13 Joomla\CMS\MVC\Model\FormModel->loadForm() JROOT/components/com_contact/models/contact.php:82 12 ContactModelContact->getForm() JROOT/libraries/src/MVC/View/HtmlView.php:425 11 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_contact/views/contact/view.html.php:84 10 ContactViewContact->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_contact/controller.php:68 8 ContactController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_contact/contact.php:29 6 require_once JROOT/components/com_contact/contact.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:51 - Query Time: 0.52 ms After last query: 1.41 ms Query memory: 0.027 MB Memory before query: 3.673 MB Rows returned: 2
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM `joom_categories` AS `s`
INNER JOIN `joom_categories` AS `c`
ON (s.lft < c.lft
AND c.lft < s.rgt
AND c.language IN ('en-GB','*')) OR (c.lft <= s.lft
AND s.rgt <= c.rgt)
WHERE (c.extension='com_contact' OR c.extension='system')
AND c.access IN (1,1,5)
AND c.published = 1
AND s.id = 4
ORDER BY c.lftid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE s NULL const PRIMARY,idx_left_right PRIMARY 4 const 1 100.00 NULL 1 SIMPLE c NULL range cat_idx,idx_access,idx_left_right,idx_language idx_left_right 4 NULL 4 6.44 Using index condition; Using where Status Duration starting 0.09 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.05 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.11 ms preparing 0.02 ms Sorting result 0.00 ms executing 0.00 ms Sending data 0.07 ms end 0.00 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.02 ms cleaning up 0.01 ms # Caller File and line number 22 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 21 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 20 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 19 Joomla\CMS\Categories\Categories->get() JROOT/administrator/components/com_fields/models/fields.php:203 18 FieldsModelFields->getListQuery() JROOT/libraries/src/MVC/Model/ListModel.php:133 17 Joomla\CMS\MVC\Model\ListModel->_getListQuery() JROOT/libraries/src/MVC/Model/ListModel.php:187 16 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 15 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:495 14 PlgSystemFields->onContentPrepare() Same as call in the line below. 13 call_user_func_array() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_contact/views/contact/view.html.php:306 10 ContactViewContact->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_contact/controller.php:68 8 ContactController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_contact/contact.php:29 6 require_once JROOT/components/com_contact/contact.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:51 - Query Time: 1.45 ms After last query: 0.33 ms Query memory: 0.025 MB Memory before query: 3.688 MB Rows returned: 0
SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM joom_fields AS a
LEFT JOIN `joom_languages` AS l
ON l.lang_code = a.language
LEFT JOIN joom_users AS uc
ON uc.id=a.checked_out
LEFT JOIN joom_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN joom_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN joom_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `joom_fields_categories` AS fc
ON fc.field_id = a.id
WHERE a.context = 'com_contact.contact'
AND (fc.category_id IS NULL OR fc.category_id IN (4,0))
AND a.access IN (1,1,5)
AND (a.group_id = 0 OR g.access IN (1,1,5))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
AND a.language in ('*','en-GB')
ORDER BY a.ordering ASCid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL ref idx_state,idx_access,idx_language,idx_context idx_context 766 const 1 83.33 Using where; Using temporary; Using filesort 1 SIMPLE l NULL eq_ref idx_langcode idx_langcode 28 baycik_diyar.a.language 1 100.00 Using where 1 SIMPLE uc NULL eq_ref PRIMARY PRIMARY 4 baycik_diyar.a.checked_out 1 100.00 NULL 1 SIMPLE ag NULL eq_ref PRIMARY PRIMARY 4 baycik_diyar.a.access 1 100.00 Using where 1 SIMPLE ua NULL eq_ref PRIMARY PRIMARY 4 baycik_diyar.a.created_user_id 1 100.00 Using where 1 SIMPLE g NULL eq_ref PRIMARY PRIMARY 4 baycik_diyar.a.group_id 1 100.00 Using where 1 SIMPLE fc NULL ref PRIMARY PRIMARY 4 baycik_diyar.a.id 1 100.00 Using where; Using index; Distinct Status Duration starting 0.18 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.01 ms Opening tables 0.15 ms init 0.14 ms System lock 0.01 ms optimizing 0.04 ms statistics 0.22 ms preparing 0.05 ms Creating tmp table 0.07 ms Sorting result 0.02 ms executing 0.00 ms Sending data 0.24 ms Creating sort index 0.05 ms end 0.01 ms query end 0.01 ms removing tmp table 0.06 ms query end 0.01 ms closing tables 0.03 ms freeing items 0.04 ms cleaning up 0.01 ms # Caller File and line number 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 19 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 18 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_fields/models/fields.php:333 17 FieldsModelFields->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:187 16 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 15 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:495 14 PlgSystemFields->onContentPrepare() Same as call in the line below. 13 call_user_func_array() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_contact/views/contact/view.html.php:306 10 ContactViewContact->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_contact/controller.php:68 8 ContactController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_contact/contact.php:29 6 require_once JROOT/components/com_contact/contact.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:51 - Query Time: 0.62 ms After last query: 0.35 ms Query memory: 0.022 MB Memory before query: 3.700 MB Rows returned: 0Duplicate queries: #16
SELECT `m`.`tag_id`,`t`.*
FROM `joom_contentitem_tag_map` AS m
INNER JOIN `joom_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_contact.contact'
AND `m`.`content_item_id` = 1
AND `t`.`published` = 1
AND t.access IN (1,1,5)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL ALL idx_tag_type NO INDEX KEY COULD BE USED NULL NULL 667 1.00 Using where 1 SIMPLE t NULL eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 baycik_diyar.m.tag_id 1 81.25 Using where Status Duration starting 0.05 ms checking permissions 0.00 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.07 ms preparing 0.01 ms executing 0.00 ms Sending data 0.26 ms end 0.00 ms query end 0.00 ms closing tables 0.04 ms freeing items 0.02 ms cleaning up 0.01 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 12 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Helper/TagsHelper.php:454 11 Joomla\CMS\Helper\TagsHelper->getItemTags() JROOT/components/com_contact/views/contact/view.html.php:352 10 ContactViewContact->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_contact/controller.php:68 8 ContactController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_contact/contact.php:29 6 require_once JROOT/components/com_contact/contact.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:51 - Query Time: 0.77 ms After last query: 0.30 ms Query memory: 0.033 MB Memory before query: 3.708 MB Rows returned: 43
SHOW FULL COLUMNS
FROM `joom_contact_details`EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `joom_contact_details`Status Duration starting 0.03 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.12 ms init 0.01 ms System lock 0.00 ms optimizing 0.00 ms statistics 0.01 ms preparing 0.01 ms executing 0.01 ms Opening tables 0.02 ms checking permissions 0.03 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Sending data 0.10 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms removing tmp table 0.03 ms closing tables 0.00 ms freeing items 0.02 ms cleaning up 0.00 ms # Caller File and line number 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 17 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:445 16 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:245 15 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:164 14 Joomla\CMS\Table\Table->__construct() JROOT/administrator/components/com_contact/tables/contact.php:39 13 ContactTableContact->__construct() JROOT/libraries/src/Table/Table.php:312 12 Joomla\CMS\Table\Table::getInstance() JROOT/components/com_contact/models/contact.php:628 11 ContactModelContact->hit() JROOT/components/com_contact/views/contact/view.html.php:370 10 ContactViewContact->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_contact/controller.php:68 8 ContactController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_contact/contact.php:29 6 require_once JROOT/components/com_contact/contact.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:51 - Query Time: 0.29 ms After last query: 1.03 ms Query memory: 0.006 MB Memory before query: 3.830 MB
UPDATE joom_contact_details
SET `hits` = (`hits` + 1)
WHERE `id` = '1'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 UPDATE joom_contact_details NULL range PRIMARY PRIMARY 4 const 1 100.00 Using where Status Duration starting 0.03 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.02 ms System lock 0.03 ms updating 0.08 ms end 0.01 ms query end 0.05 ms closing tables 0.02 ms freeing items 0.02 ms cleaning up 0.00 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Table/Table.php:1245 12 Joomla\CMS\Table\Table->hit() JROOT/components/com_contact/models/contact.php:629 11 ContactModelContact->hit() JROOT/components/com_contact/views/contact/view.html.php:370 10 ContactViewContact->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_contact/controller.php:68 8 ContactController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_contact/contact.php:29 6 require_once JROOT/components/com_contact/contact.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:51 - Query Time: 0.42 ms After last query: 44.37 ms Query memory: 0.035 MB Memory before query: 7.777 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.05 ms checking permissions 0.01 ms Opening tables 0.10 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.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.03 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.83 ms After last query: 8.28 ms Query memory: 0.046 MB Memory before query: 8.371 MB Rows returned: 29Duplicate queries: #47
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM joom_modules AS m
LEFT JOIN joom_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN joom_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
WHERE m.published = 1
AND e.enabled = 1
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2024-10-13 00:00:31')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-10-13 00:00:31')
AND m.access IN (1,1,5)
AND m.client_id = 0
AND (mm.menuid = 185 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.11 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.17 ms init 0.08 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.17 ms preparing 0.04 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.01 ms Creating sort index 0.98 ms end 0.01 ms query end 0.01 ms closing tables 0.03 ms freeing items 0.04 ms cleaning up 0.02 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.43 ms After last query: 1.14 ms Query memory: 0.042 MB Memory before query: 8.436 MB Rows returned: 0
SELECT `c2`.`language`,`c2`.`id`
FROM `joom_menu` AS `c`
INNER JOIN `joom_associations` AS `a`
ON a.id = c.`id`
AND a.context='com_menus.item'
INNER JOIN `joom_associations` AS `a2`
ON `a`.`key` = `a2`.`key`
INNER JOIN `joom_menu` AS `c2`
ON a2.id = c2.`id`
WHERE c.id = 185id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE NULL NULL NULL NULL NO INDEX KEY COULD BE USED NULL NULL NULL NULL no matching row in const table Status Duration starting 0.05 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.14 ms init 0.03 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.07 ms executing 0.01 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 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.84 ms After last query: 0.36 ms Query memory: 0.048 MB Memory before query: 8.466 MB Rows returned: 2
SELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`,CONCAT_WS(':', ca.id, ca.alias) AS `catid`
FROM `joom_contact_details` AS `c`
INNER JOIN `joom_associations` AS `a`
ON a.id = c.`id`
AND a.context='com_contact.item'
INNER JOIN `joom_associations` AS `a2`
ON `a`.`key` = `a2`.`key`
INNER JOIN `joom_contact_details` AS `c2`
ON a2.id = c2.`id`
INNER JOIN `joom_categories` AS `ca`
ON `c2`.`catid` = ca.id
AND ca.extension = 'com_contact'
WHERE c.id = 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE c NULL const PRIMARY PRIMARY 4 const 1 100.00 Using index 1 SIMPLE a NULL const PRIMARY,idx_key PRIMARY 206 const,const 1 100.00 NULL 1 SIMPLE ca NULL ref PRIMARY,cat_idx cat_idx 202 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 ALL PRIMARY,idx_catid NO INDEX KEY COULD BE USED NULL NULL 2 50.00 Using where; Using join buffer (Block Nested Loop) Status Duration starting 0.12 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.13 ms init 0.05 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.19 ms preparing 0.04 ms executing 0.00 ms Sending data 0.10 ms end 0.01 ms query end 0.01 ms closing tables 0.05 ms freeing items 0.03 ms cleaning up 0.01 ms # Caller File and line number 65 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 64 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Language/Associations.php:115 63 Joomla\CMS\Language\Associations::getAssociations() JROOT/components/com_contact/helpers/association.php:43 62 ContactHelperAssociation::getAssociations() Same as call in the line below. 61 call_user_func() JROOT/modules/mod_languages_custom/helper.php:68 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.55 ms After last query: 2.84 ms Query memory: 0.038 MB Memory before query: 8.464 MB Rows returned: 0Duplicate queries: #48
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.10 ms init 0.03 ms System lock 0.01 ms optimizing 0.00 ms statistics 0.06 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.01 ms end 0.00 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Caller File and line number 53 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 52 JDatabaseDriver->loadAssoc() JROOT/components/com_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.53 ms After last query: 0.08 ms Query memory: 0.038 MB Memory before query: 8.491 MB Rows returned: 1Duplicate queries: #49
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.25 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.30 ms init 0.14 ms System lock 0.01 ms optimizing 0.01 ms optimizing 0.03 ms statistics 0.25 ms preparing 0.04 ms Creating tmp table 0.02 ms Sorting result 0.01 ms optimizing 0.03 ms statistics 0.17 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.96 ms Creating sort index 0.05 ms end 0.00 ms query end 0.01 ms removing tmp table 0.00 ms query end 0.00 ms closing tables 0.00 ms removing tmp table 0.00 ms closing tables 0.03 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: 3.98 ms After last query: 0.09 ms Query memory: 0.038 MB Memory before query: 8.513 MB Rows returned: 0Duplicate queries: #50
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.12 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.10 ms init 0.16 ms System lock 0.01 ms optimizing 0.01 ms optimizing 0.02 ms statistics 0.26 ms preparing 0.03 ms Creating tmp table 0.07 ms statistics 0.04 ms preparing 0.02 ms Sorting result 0.01 ms executing 0.20 ms Sending data 0.03 ms Creating sort index 0.22 ms executing 0.00 ms Sending data 2.34 ms end 0.01 ms query end 0.01 ms removing tmp table 0.07 ms query end 0.01 ms closing tables 0.00 ms removing tmp table 0.06 ms closing tables 0.05 ms freeing items 0.04 ms cleaning up 0.01 ms # Caller File and line number 52 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506 51 JDatabaseDriver->loadAssocList() JROOT/modules/mod_user_dashboard_mini/helper.php:92 50 ModUserDashboardMiniHelper::getUserMenuTree() JROOT/modules/mod_user_dashboard_mini/mod_user_dashboard_mini.php:24 49 include JROOT/modules/mod_user_dashboard_mini/mod_user_dashboard_mini.php JROOT/libraries/src/Helper/ModuleHelper.php:200 48 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 47 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:195 46 Gantry\Framework\Platform->displayModule() Same as call in the line below. 45 call_user_func_array() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:704 44 Twig\Template->getAttribute() JROOT/cache/gantry5/g5_helium/twig/f3/f33e020a7c995c3091226ca5bf2951dd75aa163487741287c6ac4232bb3ab724.php:43 43 __TwigTemplate_fa24ad7ba18b08a067dfafc88f8f31a8672f91eab329b460a51c1786e9023d78->block_particle() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:216 42 Twig\Template->displayBlock() JROOT/cache/gantry5/g5_helium/twig/72/72fe691d71be39d50030851067d8119b7647bba7855e0d1db5389a5d2ee3b093.php:73 41 __TwigTemplate_65b2adc0b8fc17c3166ffc5b2c534f81cd1ec81c50d53706d96ed2bd3d2c3700->doDisplay() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 40 Twig\Template->displayWithErrorHandling() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 39 Twig\Template->display() JROOT/cache/gantry5/g5_helium/twig/f3/f33e020a7c995c3091226ca5bf2951dd75aa163487741287c6ac4232bb3ab724.php:35 38 __TwigTemplate_fa24ad7ba18b08a067dfafc88f8f31a8672f91eab329b460a51c1786e9023d78->doDisplay() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 37 Twig\Template->displayWithErrorHandling() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 36 Twig\Template->display() JROOT/cache/gantry5/g5_helium/twig/40/40a68c93f9fa61bdbf6a23e309fe06cf50b144274eb149d4c92319eba9049b3f.php:53 35 __TwigTemplate_e3ac87ee957206f0e3e7a15f8428ebb8943621df7c8387192aaaad3239284aa2->doDisplay() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 34 Twig\Template->displayWithErrorHandling() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 33 Twig\Template->display() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:434 32 Twig\Template->render() JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47 31 Twig\TemplateWrapper->render() JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384 30 Twig\Environment->render() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163 29 Gantry\Component\Theme\AbstractTheme->render() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:766 28 Gantry\Framework\Theme->getContent() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:666 27 Gantry\Framework\Theme->renderContent() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:593 26 Gantry\Framework\Theme->prepareLayout() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579 25 Gantry\Framework\Theme->prepareLayout() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579 24 Gantry\Framework\Theme->prepareLayout() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579 23 Gantry\Framework\Theme->prepareLayout() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:422 22 Gantry\Framework\Theme->segments() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:702 21 Twig\Template->getAttribute() JROOT/cache/gantry5/g5_helium/twig/33/338d1ce3e48aeca3c38dcaa34b84b0db9f26e4cdc7d62420ac1e48e9522c3306.php:47 20 __TwigTemplate_11b94903ac9c38de4bb2105a5066ee742973b4957d19cccc6fa09167e85a5546->doDisplay() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 19 Twig\Template->displayWithErrorHandling() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 18 Twig\Template->display() JROOT/cache/gantry5/g5_helium/twig/5a/5a9c061f91d7ca9e615210fa73ebddac3d62aa7de47b8be54b4a5f3517f4cab8.php:35 17 __TwigTemplate_277af7fe659c06d904eb257d5eb4bd19d8ee1919fab0c34eba6f071815650844->doDisplay() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 16 Twig\Template->displayWithErrorHandling() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 15 Twig\Template->display() JROOT/cache/gantry5/g5_helium/twig/54/546c22eede2b41fbdf4f134b6757afffe7a54ce26a7295501abc0a81a19bdbb9.php:35 14 __TwigTemplate_97f532d943bf881f0138e74af281e2606c8525f3ee65d2e711ad60e46a5eb82e->doDisplay() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 13 Twig\Template->displayWithErrorHandling() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 12 Twig\Template->display() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:434 11 Twig\Template->render() JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47 10 Twig\TemplateWrapper->render() JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384 9 Twig\Environment->render() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163 8 Gantry\Component\Theme\AbstractTheme->render() JROOT/templates/g5_helium/index.php:23 7 require JROOT/templates/g5_helium/index.php JROOT/libraries/src/Document/HtmlDocument.php:668 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:730 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:545 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1030 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:51 - Query Time: 0.88 ms After last query: 1.36 ms Query memory: 0.043 MB Memory before query: 8.554 MB Rows returned: 29Duplicate queries: #41
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM joom_modules AS m
LEFT JOIN joom_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN joom_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
WHERE m.published = 1
AND e.enabled = 1
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2024-10-13 00:00:31')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-10-13 00:00:31')
AND m.access IN (1,1,5)
AND m.client_id = 0
AND (mm.menuid = 185 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.06 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.04 ms System lock 0.00 ms optimizing 0.02 ms statistics 0.10 ms preparing 0.02 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.01 ms Creating sort index 0.45 ms end 0.00 ms query end 0.00 ms closing tables 0.04 ms freeing items 0.02 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.25 ms After last query: 1.50 ms Query memory: 0.038 MB Memory before query: 8.623 MB Rows returned: 0Duplicate queries: #44
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.05 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.03 ms System lock 0.01 ms optimizing 0.00 ms statistics 0.02 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms executing 0.01 ms end 0.00 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Caller File and line number 53 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 52 JDatabaseDriver->loadAssoc() JROOT/components/com_user_dashboard/models/Dashboard.php:39 51 UserDashboardModelDashboard::userGetDashboard() JROOT/components/com_user_dashboard/models/Dashboard.php:10 50 UserDashboardModelDashboard::userCompose() JROOT/modules/mod_user_dashboard_mini/mod_user_dashboard_mini.php:22 49 include JROOT/modules/mod_user_dashboard_mini/mod_user_dashboard_mini.php JROOT/libraries/src/Helper/ModuleHelper.php:200 48 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 47 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:195 46 Gantry\Framework\Platform->displayModule() Same as call in the line below. 45 call_user_func_array() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:704 44 Twig\Template->getAttribute() JROOT/cache/gantry5/g5_helium/twig/f3/f33e020a7c995c3091226ca5bf2951dd75aa163487741287c6ac4232bb3ab724.php:43 43 __TwigTemplate_fa24ad7ba18b08a067dfafc88f8f31a8672f91eab329b460a51c1786e9023d78->block_particle() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:216 42 Twig\Template->displayBlock() JROOT/cache/gantry5/g5_helium/twig/72/72fe691d71be39d50030851067d8119b7647bba7855e0d1db5389a5d2ee3b093.php:73 41 __TwigTemplate_65b2adc0b8fc17c3166ffc5b2c534f81cd1ec81c50d53706d96ed2bd3d2c3700->doDisplay() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 40 Twig\Template->displayWithErrorHandling() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 39 Twig\Template->display() JROOT/cache/gantry5/g5_helium/twig/f3/f33e020a7c995c3091226ca5bf2951dd75aa163487741287c6ac4232bb3ab724.php:35 38 __TwigTemplate_fa24ad7ba18b08a067dfafc88f8f31a8672f91eab329b460a51c1786e9023d78->doDisplay() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 37 Twig\Template->displayWithErrorHandling() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 36 Twig\Template->display() JROOT/cache/gantry5/g5_helium/twig/40/40a68c93f9fa61bdbf6a23e309fe06cf50b144274eb149d4c92319eba9049b3f.php:53 35 __TwigTemplate_e3ac87ee957206f0e3e7a15f8428ebb8943621df7c8387192aaaad3239284aa2->doDisplay() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 34 Twig\Template->displayWithErrorHandling() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 33 Twig\Template->display() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:434 32 Twig\Template->render() JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47 31 Twig\TemplateWrapper->render() JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384 30 Twig\Environment->render() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163 29 Gantry\Component\Theme\AbstractTheme->render() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:766 28 Gantry\Framework\Theme->getContent() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:666 27 Gantry\Framework\Theme->renderContent() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:593 26 Gantry\Framework\Theme->prepareLayout() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579 25 Gantry\Framework\Theme->prepareLayout() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579 24 Gantry\Framework\Theme->prepareLayout() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579 23 Gantry\Framework\Theme->prepareLayout() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:422 22 Gantry\Framework\Theme->segments() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:702 21 Twig\Template->getAttribute() JROOT/cache/gantry5/g5_helium/twig/33/338d1ce3e48aeca3c38dcaa34b84b0db9f26e4cdc7d62420ac1e48e9522c3306.php:47 20 __TwigTemplate_11b94903ac9c38de4bb2105a5066ee742973b4957d19cccc6fa09167e85a5546->doDisplay() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 19 Twig\Template->displayWithErrorHandling() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 18 Twig\Template->display() JROOT/cache/gantry5/g5_helium/twig/5a/5a9c061f91d7ca9e615210fa73ebddac3d62aa7de47b8be54b4a5f3517f4cab8.php:35 17 __TwigTemplate_277af7fe659c06d904eb257d5eb4bd19d8ee1919fab0c34eba6f071815650844->doDisplay() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 16 Twig\Template->displayWithErrorHandling() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 15 Twig\Template->display() JROOT/cache/gantry5/g5_helium/twig/54/546c22eede2b41fbdf4f134b6757afffe7a54ce26a7295501abc0a81a19bdbb9.php:35 14 __TwigTemplate_97f532d943bf881f0138e74af281e2606c8525f3ee65d2e711ad60e46a5eb82e->doDisplay() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 13 Twig\Template->displayWithErrorHandling() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 12 Twig\Template->display() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:434 11 Twig\Template->render() JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47 10 Twig\TemplateWrapper->render() JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384 9 Twig\Environment->render() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163 8 Gantry\Component\Theme\AbstractTheme->render() JROOT/templates/g5_helium/index.php:23 7 require JROOT/templates/g5_helium/index.php JROOT/libraries/src/Document/HtmlDocument.php:668 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:730 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:545 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1030 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:51 - Query Time: 1.54 ms After last query: 0.06 ms Query memory: 0.038 MB Memory before query: 8.650 MB Rows returned: 1Duplicate queries: #45
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.11 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.07 ms System lock 0.01 ms optimizing 0.00 ms optimizing 0.01 ms statistics 0.11 ms preparing 0.02 ms Creating tmp table 0.01 ms Sorting result 0.00 ms optimizing 0.01 ms statistics 0.07 ms preparing 0.02 ms statistics 0.01 ms preparing 0.01 ms executing 0.01 ms Sending data 0.01 ms executing 0.01 ms Sending data 0.85 ms Creating sort index 0.03 ms end 0.00 ms query end 0.01 ms removing tmp table 0.00 ms query end 0.00 ms closing tables 0.00 ms removing tmp table 0.00 ms closing tables 0.04 ms freeing items 0.03 ms cleaning up 0.00 ms # Caller File and line number 53 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 52 JDatabaseDriver->loadAssoc() JROOT/components/com_education/models/ExerciseStatistic.php:293 51 EducationModelExerciseStatistic::userStatisticGetByFilter() JROOT/components/com_user_dashboard/models/Dashboard.php:19 50 UserDashboardModelDashboard::userCompose() JROOT/modules/mod_user_dashboard_mini/mod_user_dashboard_mini.php:22 49 include JROOT/modules/mod_user_dashboard_mini/mod_user_dashboard_mini.php JROOT/libraries/src/Helper/ModuleHelper.php:200 48 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 47 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:195 46 Gantry\Framework\Platform->displayModule() Same as call in the line below. 45 call_user_func_array() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:704 44 Twig\Template->getAttribute() JROOT/cache/gantry5/g5_helium/twig/f3/f33e020a7c995c3091226ca5bf2951dd75aa163487741287c6ac4232bb3ab724.php:43 43 __TwigTemplate_fa24ad7ba18b08a067dfafc88f8f31a8672f91eab329b460a51c1786e9023d78->block_particle() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:216 42 Twig\Template->displayBlock() JROOT/cache/gantry5/g5_helium/twig/72/72fe691d71be39d50030851067d8119b7647bba7855e0d1db5389a5d2ee3b093.php:73 41 __TwigTemplate_65b2adc0b8fc17c3166ffc5b2c534f81cd1ec81c50d53706d96ed2bd3d2c3700->doDisplay() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 40 Twig\Template->displayWithErrorHandling() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 39 Twig\Template->display() JROOT/cache/gantry5/g5_helium/twig/f3/f33e020a7c995c3091226ca5bf2951dd75aa163487741287c6ac4232bb3ab724.php:35 38 __TwigTemplate_fa24ad7ba18b08a067dfafc88f8f31a8672f91eab329b460a51c1786e9023d78->doDisplay() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 37 Twig\Template->displayWithErrorHandling() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 36 Twig\Template->display() JROOT/cache/gantry5/g5_helium/twig/40/40a68c93f9fa61bdbf6a23e309fe06cf50b144274eb149d4c92319eba9049b3f.php:53 35 __TwigTemplate_e3ac87ee957206f0e3e7a15f8428ebb8943621df7c8387192aaaad3239284aa2->doDisplay() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 34 Twig\Template->displayWithErrorHandling() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 33 Twig\Template->display() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:434 32 Twig\Template->render() JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47 31 Twig\TemplateWrapper->render() JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384 30 Twig\Environment->render() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163 29 Gantry\Component\Theme\AbstractTheme->render() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:766 28 Gantry\Framework\Theme->getContent() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:666 27 Gantry\Framework\Theme->renderContent() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:593 26 Gantry\Framework\Theme->prepareLayout() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579 25 Gantry\Framework\Theme->prepareLayout() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579 24 Gantry\Framework\Theme->prepareLayout() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579 23 Gantry\Framework\Theme->prepareLayout() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:422 22 Gantry\Framework\Theme->segments() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:702 21 Twig\Template->getAttribute() JROOT/cache/gantry5/g5_helium/twig/33/338d1ce3e48aeca3c38dcaa34b84b0db9f26e4cdc7d62420ac1e48e9522c3306.php:47 20 __TwigTemplate_11b94903ac9c38de4bb2105a5066ee742973b4957d19cccc6fa09167e85a5546->doDisplay() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 19 Twig\Template->displayWithErrorHandling() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 18 Twig\Template->display() JROOT/cache/gantry5/g5_helium/twig/5a/5a9c061f91d7ca9e615210fa73ebddac3d62aa7de47b8be54b4a5f3517f4cab8.php:35 17 __TwigTemplate_277af7fe659c06d904eb257d5eb4bd19d8ee1919fab0c34eba6f071815650844->doDisplay() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 16 Twig\Template->displayWithErrorHandling() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 15 Twig\Template->display() JROOT/cache/gantry5/g5_helium/twig/54/546c22eede2b41fbdf4f134b6757afffe7a54ce26a7295501abc0a81a19bdbb9.php:35 14 __TwigTemplate_97f532d943bf881f0138e74af281e2606c8525f3ee65d2e711ad60e46a5eb82e->doDisplay() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 13 Twig\Template->displayWithErrorHandling() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 12 Twig\Template->display() JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:434 11 Twig\Template->render() JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47 10 Twig\TemplateWrapper->render() JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384 9 Twig\Environment->render() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163 8 Gantry\Component\Theme\AbstractTheme->render() JROOT/templates/g5_helium/index.php:23 7 require JROOT/templates/g5_helium/index.php JROOT/libraries/src/Document/HtmlDocument.php:668 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:730 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:545 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1030 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:51 - Query Time: 2.24 ms After last query: 0.09 ms Query memory: 0.038 MB Memory before query: 8.672 MB Rows returned: 0Duplicate queries: #46
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.05 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.07 ms System lock 0.01 ms optimizing 0.00 ms optimizing 0.01 ms statistics 0.16 ms preparing 0.02 ms Creating tmp table 0.04 ms statistics 0.03 ms preparing 0.01 ms Sorting result 0.00 ms executing 0.12 ms Sending data 0.02 ms Creating sort index 0.10 ms executing 0.00 ms Sending data 1.34 ms end 0.01 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.03 ms closing tables 0.04 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
38 Query Types Logged, Sorted by Occurrences.
SELECT Tables:
4 × SELECT `field_id`,`value`
FROM `joom_fields_values`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 `m`.`tag_id`,`t`.*
FROM `joom_contentitem_tag_map` AS m
INNER JOIN `joom_tags` AS t
ON `m`.`tag_id` = `t`.`id`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_id2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `joom_extensions`2 × SELECT `g`.`id`,`g`.`title`
FROM `joom_usergroups` AS g
INNER JOIN `joom_user_usergroup_map` AS m
ON m.group_id = g.id2 × SELECT *
FROM `joom_users`2 × SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM joom_fields AS a
LEFT JOIN `joom_languages` AS l
ON l.lang_code = a.language
LEFT JOIN joom_users AS uc
ON uc.id=a.checked_out
LEFT JOIN joom_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN joom_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN joom_fields_groups AS g
ON g.id = a.group_id1 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `joom_assets`1 × SELECT profile_key, profile_value
FROM joom_user_profiles1 × SELECT id, rules
FROM `joom_viewlevels1 × 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 `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`,CONCAT_WS(':', ca.id, ca.alias) AS `catid`
FROM `joom_contact_details` AS `c`
INNER JOIN `joom_associations` AS `a`
ON a.id = c.`id`
AND a.context='com_contact.item'
INNER JOIN `joom_associations` AS `a2`
ON `a`.`key` = `a2`.`key`
INNER JOIN `joom_contact_details` AS `c2`
ON a2.id = c2.`id`
INNER JOIN `joom_categories` AS `ca`
ON `c2`.`catid` = ca.id
AND ca.extension = 'com_contact'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 `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM joom_extensions1 × SELECT a.menutype
FROM joom_menu_types AS a1 × SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM joom_fields AS a
LEFT JOIN `joom_languages` AS l
ON l.lang_code = a.language
LEFT JOIN joom_users AS uc
ON uc.id=a.checked_out
LEFT JOIN joom_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN joom_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN joom_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `joom_fields_categories` AS fc
ON fc.field_id = a.id1 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM `joom_categories` AS `s`
INNER JOIN `joom_categories` AS `c`
ON (s.lft < c.lft
AND c.lft < s.rgt
AND c.language IN ('en-GB','*')) OR (c.lft <= s.lft
AND s.rgt <= c.rgt)1 × SELECT `notify`,`extensions`
FROM `joom_action_logs_users`1 × SELECT a.*,
CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias
FROM joom_contact_details AS a
LEFT JOIN joom_categories AS c
on c.id = a.catid
LEFT JOIN joom_categories as parent
ON parent.id = c.parent_id1 × SELECT b.id
FROM joom_user_usergroup_map AS map
LEFT JOIN joom_usergroups AS a
ON a.id = map.group_id
LEFT JOIN joom_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt1 × SELECT `profile_key`,`profile_value`
FROM `joom_user_profiles`1 × SELECT a.*,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name
FROM joom_fields_groups AS a
LEFT JOIN `joom_languages` AS l
ON l.lang_code = a.language
LEFT JOIN joom_users AS uc
ON uc.id=a.checked_out
LEFT JOIN joom_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN joom_users AS ua
ON ua.id = a.created_by1 × SELECT *
FROM joom_languages1 × SELECT `element`,`name`,`client_id`,`extension_id`
FROM `joom_extensions`1 × SELECT *
FROM joom_menu1 × 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 id, home, template, s.params
FROM joom_template_styles as s
LEFT JOIN joom_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id1 × SELECT s.id, s.template, s.home, s.title AS long_title, s.params
FROM joom_template_styles AS s1 × SELECT `session_id`
FROM `joom_session`
OTHER Tables:
1 × INSERT INTO `joom_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'3536353663343661653239616130633964386662613764353137336232373035', 1, 1728777631, 0, '', 01 × UPDATE `joom_extensions`
SET `params` = '{\"mediaversion\":\"fd745c5fcec9f03420495cec7a9ae55c\"}'1 × SHOW FULL COLUMNS
FROM `joom_users1 × SHOW FULL COLUMNS
FROM `joom_menu1 × SHOW FULL COLUMNS
FROM `joom_contact_details1 × UPDATE joom_contact_details
SET `hits` = (`hits` + 1)