Query Time: 0.37 ms Query memory: 0.020 MB Memory before query: 1.267 MB Rows returned: 0
SELECT `session_id`
FROM `joom_session`
WHERE `session_id` = X'6336393935643665306636343235313134386532663330306434373031376537'
LIMIT 1
id | 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.07 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.03 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.06 ms |
executing | 0.02 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 |
---|
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.31 ms After last query: 0.15 ms Query memory: 0.004 MB Memory before query: 1.273 MB
INSERT INTO `joom_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES
(X'6336393935643665306636343235313134386532663330306434373031376537', 1, 1733934971, 0, '', 0)
EXPLAIN not possible on query: INSERT INTO `joom_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES
(X'6336393935643665306636343235313134386532663330306434373031376537', 1, 1733934971, 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.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 |
---|
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.68 ms After last query: 1.30 ms Query memory: 0.024 MB Memory before query: 1.308 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` = 1
id | 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.05 ms |
checking permissions | 0.00 ms |
Opening tables | 0.01 ms |
init | 0.02 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.06 ms |
preparing | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.34 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 |
---|
12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
11 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Component/ComponentHelper.php:445 |
10 | Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}() | Same as call in the line below. |
9 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
8 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Component/ComponentHelper.php:453 |
7 | Joomla\CMS\Component\ComponentHelper::load() | JROOT/libraries/src/Component/ComponentHelper.php:519 |
6 | Joomla\CMS\Component\ComponentHelper::getComponents() | JROOT/libraries/src/Component/ComponentHelper.php:44 |
5 | Joomla\CMS\Component\ComponentHelper::getComponent() | JROOT/libraries/src/Component/ComponentHelper.php:103 |
4 | Joomla\CMS\Component\ComponentHelper::getParams() | JROOT/libraries/src/Application/SiteApplication.php:594 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:51 |
Query Time: 0.21 ms After last query: 0.78 ms Query memory: 0.021 MB Memory before query: 1.341 MB Rows returned: 7
SELECT id, rules
FROM `joom_viewlevels`
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | joom_viewlevels | NULL | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 7 | 100.00 | NULL |
Status | Duration |
---|
starting | 0.03 ms |
checking permissions | 0.00 ms |
Opening tables | 0.01 ms |
init | 0.01 ms |
System lock | 0.01 ms |
optimizing | 0.00 ms |
statistics | 0.01 ms |
preparing | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.04 ms |
end | 0.00 ms |
query end | 0.00 ms |
closing tables | 0.02 ms |
freeing items | 0.02 ms |
cleaning up | 0.00 ms |
# | Caller | File and line number |
---|
10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1506 |
9 | JDatabaseDriver->loadAssocList() | JROOT/libraries/src/Access/Access.php:1061 |
8 | Joomla\CMS\Access\Access::getAuthorisedViewLevels() | JROOT/libraries/src/User/User.php:458 |
7 | Joomla\CMS\User\User->getAuthorisedViewLevels() | JROOT/libraries/src/Plugin/PluginHelper.php:321 |
6 | Joomla\CMS\Plugin\PluginHelper::load() | JROOT/libraries/src/Plugin/PluginHelper.php:87 |
5 | Joomla\CMS\Plugin\PluginHelper::getPlugin() | JROOT/libraries/src/Plugin/PluginHelper.php:129 |
4 | Joomla\CMS\Plugin\PluginHelper::isEnabled() | JROOT/libraries/src/Application/SiteApplication.php:604 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:51 |
Query Time: 0.34 ms After last query: 0.07 ms Query memory: 0.021 MB Memory before query: 1.354 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 = 9
id | 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.05 ms |
checking permissions | 0.00 ms |
checking permissions | 0.01 ms |
Opening tables | 0.01 ms |
init | 0.03 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.07 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.02 ms |
cleaning up | 0.00 ms |
# | Caller | File and line number |
---|
11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1550 |
10 | JDatabaseDriver->loadColumn() | JROOT/libraries/src/Access/Access.php:978 |
9 | Joomla\CMS\Access\Access::getGroupsByUser() | JROOT/libraries/src/Access/Access.php:1093 |
8 | Joomla\CMS\Access\Access::getAuthorisedViewLevels() | JROOT/libraries/src/User/User.php:458 |
7 | Joomla\CMS\User\User->getAuthorisedViewLevels() | JROOT/libraries/src/Plugin/PluginHelper.php:321 |
6 | Joomla\CMS\Plugin\PluginHelper::load() | JROOT/libraries/src/Plugin/PluginHelper.php:87 |
5 | Joomla\CMS\Plugin\PluginHelper::getPlugin() | JROOT/libraries/src/Plugin/PluginHelper.php:129 |
4 | Joomla\CMS\Plugin\PluginHelper::isEnabled() | JROOT/libraries/src/Application/SiteApplication.php:604 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:51 |
Query Time: 1.81 ms After last query: 0.24 ms Query memory: 0.030 MB Memory before query: 1.377 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 ordering
id | 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.06 ms |
checking permissions | 0.01 ms |
Opening tables | 0.01 ms |
init | 0.03 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.05 ms |
preparing | 0.03 ms |
Sorting result | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.01 ms |
Creating sort index | 1.42 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: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.38 ms After last query: 0.64 ms Query memory: 0.019 MB Memory before query: 1.436 MB Rows returned: 2
SELECT *
FROM joom_languages
WHERE published=1
ORDER BY ordering ASC
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | joom_languages | NULL | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 3 | 33.33 | Using where; Using filesort |
Status | Duration |
---|
starting | 0.04 ms |
checking permissions | 0.01 ms |
Opening tables | 0.01 ms |
init | 0.03 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.01 ms |
preparing | 0.02 ms |
Sorting result | 0.00 ms |
executing | 0.00 ms |
Sending data | 0.02 ms |
Creating sort index | 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 |
---|
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.44 ms After last query: 5.27 ms Query memory: 0.021 MB Memory before query: 1.910 MB Rows returned: 6
SELECT `element`,`name`,`client_id`,`extension_id`
FROM `joom_extensions`
WHERE `type` = 'language'
AND `state` = 0
AND `enabled` = 1
id | 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.05 ms |
checking permissions | 0.01 ms |
Opening tables | 0.01 ms |
init | 0.02 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.07 ms |
preparing | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.08 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 |
---|
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.44 ms After last query: 3.05 ms Query memory: 0.078 MB Memory before query: 2.055 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.lft
id | 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.00 ms |
Opening tables | 0.02 ms |
init | 0.04 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.06 ms |
preparing | 0.02 ms |
Sorting result | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.02 ms |
Creating sort index | 0.98 ms |
end | 0.00 ms |
query end | 0.01 ms |
closing tables | 0.04 ms |
freeing items | 0.03 ms |
cleaning up | 0.00 ms |
# | Caller | File and line number |
---|
24 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
23 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Menu/SiteMenu.php:93 |
22 | Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}() | Same as call in the line below. |
21 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
20 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Menu/SiteMenu.php:101 |
19 | Joomla\CMS\Menu\SiteMenu->load() | JROOT/libraries/src/Menu/AbstractMenu.php:76 |
18 | Joomla\CMS\Menu\AbstractMenu->__construct() | JROOT/libraries/src/Menu/SiteMenu.php:62 |
17 | Joomla\CMS\Menu\SiteMenu->__construct() | JROOT/libraries/src/Menu/AbstractMenu.php:131 |
16 | Joomla\CMS\Menu\AbstractMenu::getInstance() | JROOT/libraries/src/Application/CMSApplication.php:375 |
15 | Joomla\CMS\Application\CMSApplication->getMenu() | JROOT/libraries/src/Application/SiteApplication.php:275 |
14 | Joomla\CMS\Application\SiteApplication->getMenu() | JROOT/libraries/src/Router/SiteRouter.php:65 |
13 | Joomla\CMS\Router\SiteRouter->__construct() | JROOT/libraries/src/Router/Router.php:189 |
12 | Joomla\CMS\Router\Router::getInstance() | JROOT/libraries/src/Application/CMSApplication.php:491 |
11 | Joomla\CMS\Application\CMSApplication::getRouter() | JROOT/libraries/src/Application/SiteApplication.php:403 |
10 | Joomla\CMS\Application\SiteApplication::getRouter() | JROOT/plugins/system/languagefilter/languagefilter.php:145 |
9 | PlgSystemLanguageFilter->onAfterInitialise() | Same as call in the line below. |
8 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:70 |
7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:626 |
4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:51 |
Query Time: 0.78 ms After last query: 3.85 ms Query memory: 0.025 MB Memory before query: 2.337 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 = 1
id | 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.08 ms |
checking permissions | 0.01 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.10 ms |
preparing | 0.03 ms |
executing | 0.00 ms |
Sending data | 0.34 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.03 ms |
freeing items | 0.02 ms |
cleaning up | 0.00 ms |
# | Caller | File and line number |
---|
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.48 ms After last query: 4.91 ms Query memory: 0.026 MB Memory before query: 2.683 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.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.12 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.07 ms |
cleaning up | 0.01 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.43 ms After last query: 0.13 ms Query memory: 0.009 MB Memory before query: 2.678 MB
UPDATE `joom_extensions`
SET `params` = '{\"mediaversion\":\"d9fbc12f0852c7a896a1ceb37f5f339f\"}'
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.05 ms |
checking permissions | 0.01 ms |
Opening tables | 0.01 ms |
init | 0.02 ms |
System lock | 0.11 ms |
updating | 0.09 ms |
end | 0.01 ms |
query end | 0.06 ms |
closing tables | 0.02 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.58 ms After last query: 2.33 ms Query memory: 0.027 MB Memory before query: 2.826 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.id
id | 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.06 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.09 ms |
preparing | 0.02 ms |
Sorting result | 0.00 ms |
executing | 0.00 ms |
Sending data | 0.19 ms |
end | 0.00 ms |
query end | 0.01 ms |
closing tables | 0.02 ms |
freeing items | 0.03 ms |
cleaning up | 0.01 ms |
# | Caller | File and line number |
---|
17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
16 | JDatabaseDriver->loadObjectList() | JROOT/libraries/gantry5/classes/Gantry/Joomla/StyleHelper.php:46 |
15 | Gantry\Joomla\StyleHelper::loadStyles() | JROOT/libraries/gantry5/classes/Gantry/Framework/Assignments.php:50 |
14 | Gantry\Framework\Assignments->loadAssignments() | JROOT/libraries/gantry5/classes/Gantry/Component/Assignments/AbstractAssignments.php:303 |
13 | Gantry\Component\Assignments\AbstractAssignments->init() | JROOT/libraries/gantry5/classes/Gantry/Component/Assignments/AbstractAssignments.php:104 |
12 | Gantry\Component\Assignments\AbstractAssignments->scores() | JROOT/libraries/gantry5/classes/Gantry/Component/Assignments/AbstractAssignments.php:91 |
11 | Gantry\Component\Assignments\AbstractAssignments->select() | JROOT/plugins/system/gantry5/gantry5.php:246 |
10 | plgSystemGantry5->onAfterRouteSite() | JROOT/plugins/system/gantry5/gantry5.php:57 |
9 | plgSystemGantry5->onAfterRoute() | Same as call in the line below. |
8 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:70 |
7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1122 |
4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:51 |
Query Time: 0.30 ms After last query: 32.70 ms Query memory: 0.035 MB Memory before query: 6.984 MB Rows returned: 4
SELECT a.menutype
FROM joom_menu_types AS a
WHERE a.client_id = 0
id | 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.03 ms |
checking permissions | 0.00 ms |
Opening tables | 0.08 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.03 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 |
---|
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.95 ms After last query: 7.23 ms Query memory: 0.046 MB Memory before query: 7.517 MB Rows returned: 29
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-12-11 16:36:11')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-12-11 16:36:11')
AND m.access IN (1,1,5)
AND m.client_id = 0
AND (mm.menuid = 227 OR mm.menuid <= 0)
AND m.language IN ('en-GB','*')
ORDER BY m.position, m.ordering
id | 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.16 ms |
checking permissions | 0.01 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
Opening tables | 0.16 ms |
init | 0.09 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.01 ms |
Sending data | 0.01 ms |
Creating sort index | 1.05 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.04 ms |
freeing items | 0.04 ms |
cleaning up | 0.00 ms |
# | Caller | File and line number |
---|
63 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
62 | JDatabaseDriver->loadObjectList() | Same as call in the line below. |
61 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
60 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/ModuleHelper.php:432 |
59 | Joomla\CMS\Helper\ModuleHelper::getModuleList() | JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:276 |
58 | Gantry\Framework\Platform->getModuleList() | JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:269 |
57 | Gantry\Framework\Platform->getModule() | JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:183 |
56 | Gantry\Framework\Platform->displayModule() | Same as call in the line below. |
55 | call_user_func_array() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:704 |
54 | Twig\Template->getAttribute() | JROOT/cache/gantry5/g5_helium/twig/f3/f33e020a7c995c3091226ca5bf2951dd75aa163487741287c6ac4232bb3ab724.php:43 |
53 | __TwigTemplate_fa24ad7ba18b08a067dfafc88f8f31a8672f91eab329b460a51c1786e9023d78->block_particle() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:216 |
52 | Twig\Template->displayBlock() | JROOT/cache/gantry5/g5_helium/twig/72/72fe691d71be39d50030851067d8119b7647bba7855e0d1db5389a5d2ee3b093.php:73 |
51 | __TwigTemplate_65b2adc0b8fc17c3166ffc5b2c534f81cd1ec81c50d53706d96ed2bd3d2c3700->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 |
50 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 |
49 | Twig\Template->display() | JROOT/cache/gantry5/g5_helium/twig/f3/f33e020a7c995c3091226ca5bf2951dd75aa163487741287c6ac4232bb3ab724.php:35 |
48 | __TwigTemplate_fa24ad7ba18b08a067dfafc88f8f31a8672f91eab329b460a51c1786e9023d78->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 |
47 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 |
46 | Twig\Template->display() | JROOT/cache/gantry5/g5_helium/twig/6f/6f6efd2cbae7b8a2f3ef2d9fcdd2994778476ec2582eb564f90b19871344036e.php:165 |
45 | __TwigTemplate_d263f579c8fe48262eca10b688e33707f3c6d7b5cff39596469a169893690e33->getdisplayParticle() | JROOT/cache/gantry5/g5_helium/twig/6f/6f6efd2cbae7b8a2f3ef2d9fcdd2994778476ec2582eb564f90b19871344036e.php:371 |
44 | __TwigTemplate_d263f579c8fe48262eca10b688e33707f3c6d7b5cff39596469a169893690e33->getdisplayItem() | JROOT/cache/gantry5/g5_helium/twig/6f/6f6efd2cbae7b8a2f3ef2d9fcdd2994778476ec2582eb564f90b19871344036e.php:529 |
43 | __TwigTemplate_d263f579c8fe48262eca10b688e33707f3c6d7b5cff39596469a169893690e33->getdisplayItems() | JROOT/cache/gantry5/g5_helium/twig/6f/6f6efd2cbae7b8a2f3ef2d9fcdd2994778476ec2582eb564f90b19871344036e.php:474 |
42 | __TwigTemplate_d263f579c8fe48262eca10b688e33707f3c6d7b5cff39596469a169893690e33->getdisplayContainers() | JROOT/cache/gantry5/g5_helium/twig/6f/6f6efd2cbae7b8a2f3ef2d9fcdd2994778476ec2582eb564f90b19871344036e.php:589 |
41 | __TwigTemplate_d263f579c8fe48262eca10b688e33707f3c6d7b5cff39596469a169893690e33->getdisplaySubmenu() | JROOT/cache/gantry5/g5_helium/twig/6f/6f6efd2cbae7b8a2f3ef2d9fcdd2994778476ec2582eb564f90b19871344036e.php:414 |
40 | __TwigTemplate_d263f579c8fe48262eca10b688e33707f3c6d7b5cff39596469a169893690e33->getdisplayItem() | JROOT/cache/gantry5/g5_helium/twig/6f/6f6efd2cbae7b8a2f3ef2d9fcdd2994778476ec2582eb564f90b19871344036e.php:529 |
39 | __TwigTemplate_d263f579c8fe48262eca10b688e33707f3c6d7b5cff39596469a169893690e33->getdisplayItems() | JROOT/cache/gantry5/g5_helium/twig/6f/6f6efd2cbae7b8a2f3ef2d9fcdd2994778476ec2582eb564f90b19871344036e.php:82 |
38 | __TwigTemplate_d263f579c8fe48262eca10b688e33707f3c6d7b5cff39596469a169893690e33->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 |
37 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 |
36 | Twig\Template->display() | JROOT/cache/gantry5/g5_helium/twig/43/4381d28d64cd975d4bbc65ccd08fd905efb17597742fa402c881bea16f41ff5f.php:71 |
35 | __TwigTemplate_31abb5d75caeb3e91290b7b0ef453a194196eae94181655d9fe5baf108036a80->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 |
34 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 |
33 | Twig\Template->display() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:434 |
32 | Twig\Template->render() | JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47 |
31 | Twig\TemplateWrapper->render() | JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384 |
30 | Twig\Environment->render() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163 |
29 | Gantry\Component\Theme\AbstractTheme->render() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:766 |
28 | Gantry\Framework\Theme->getContent() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:666 |
27 | Gantry\Framework\Theme->renderContent() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:593 |
26 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579 |
25 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579 |
24 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579 |
23 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:422 |
22 | Gantry\Framework\Theme->segments() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:702 |
21 | Twig\Template->getAttribute() | JROOT/cache/gantry5/g5_helium/twig/33/338d1ce3e48aeca3c38dcaa34b84b0db9f26e4cdc7d62420ac1e48e9522c3306.php:47 |
20 | __TwigTemplate_11b94903ac9c38de4bb2105a5066ee742973b4957d19cccc6fa09167e85a5546->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 |
19 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 |
18 | Twig\Template->display() | JROOT/cache/gantry5/g5_helium/twig/5a/5a9c061f91d7ca9e615210fa73ebddac3d62aa7de47b8be54b4a5f3517f4cab8.php:35 |
17 | __TwigTemplate_277af7fe659c06d904eb257d5eb4bd19d8ee1919fab0c34eba6f071815650844->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 |
16 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 |
15 | Twig\Template->display() | JROOT/cache/gantry5/g5_helium/twig/54/546c22eede2b41fbdf4f134b6757afffe7a54ce26a7295501abc0a81a19bdbb9.php:35 |
14 | __TwigTemplate_97f532d943bf881f0138e74af281e2606c8525f3ee65d2e711ad60e46a5eb82e->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 |
13 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 |
12 | Twig\Template->display() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:434 |
11 | Twig\Template->render() | JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47 |
10 | Twig\TemplateWrapper->render() | JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384 |
9 | Twig\Environment->render() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163 |
8 | Gantry\Component\Theme\AbstractTheme->render() | JROOT/templates/g5_helium/index.php:23 |
7 | require JROOT/templates/g5_helium/index.php | JROOT/libraries/src/Document/HtmlDocument.php:668 |
6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:730 |
5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:545 |
4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1030 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:202 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:51 |
Query Time: 0.73 ms After last query: 0.91 ms Query memory: 0.042 MB Memory before query: 7.586 MB Rows returned: 2
SELECT `c2`.`language`,`c2`.`id`
FROM `joom_menu` AS `c`
INNER JOIN `joom_associations` AS `a`
ON a.id = c.`id`
AND a.context='com_menus.item'
INNER JOIN `joom_associations` AS `a2`
ON `a`.`key` = `a2`.`key`
INNER JOIN `joom_menu` AS `c2`
ON a2.id = c2.`id`
WHERE c.id = 227
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | c | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | Using index |
1 | SIMPLE | a | NULL | const | PRIMARY,idx_key | PRIMARY | 206 | const,const | 1 | 100.00 | NULL |
1 | SIMPLE | a2 | NULL | ref | idx_key | idx_key | 128 | const | 2 | 100.00 | Using index |
1 | SIMPLE | c2 | NULL | eq_ref | PRIMARY | PRIMARY | 4 | baycik_diyar.a2.id | 1 | 100.00 | NULL |
Status | Duration |
---|
starting | 0.08 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.18 ms |
preparing | 0.03 ms |
executing | 0.01 ms |
Sending data | 0.07 ms |
end | 0.00 ms |
query end | 0.01 ms |
closing tables | 0.04 ms |
freeing items | 0.03 ms |
cleaning up | 0.00 ms |
# | Caller | File and line number |
---|
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: 1.17 ms After last query: 1.13 ms Query memory: 0.043 MB Memory before query: 7.678 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.08 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.28 ms |
preparing | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.47 ms |
end | 0.00 ms |
query end | 0.01 ms |
closing tables | 0.03 ms |
freeing items | 0.03 ms |
cleaning up | 0.00 ms |
# | Caller | File and line number |
---|
63 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
62 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Access/Access.php:429 |
61 | Joomla\CMS\Access\Access::preloadComponents() | JROOT/libraries/src/Access/Access.php:213 |
60 | Joomla\CMS\Access\Access::preload() | JROOT/libraries/src/Access/Access.php:531 |
59 | Joomla\CMS\Access\Access::getAssetRules() | JROOT/libraries/src/Access/Access.php:183 |
58 | Joomla\CMS\Access\Access::check() | JROOT/libraries/src/User/User.php:398 |
57 | Joomla\CMS\User\User->authorise() | JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:202 |
56 | Gantry\Framework\Platform->displayModule() | Same as call in the line below. |
55 | call_user_func_array() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:704 |
54 | Twig\Template->getAttribute() | JROOT/cache/gantry5/g5_helium/twig/f3/f33e020a7c995c3091226ca5bf2951dd75aa163487741287c6ac4232bb3ab724.php:43 |
53 | __TwigTemplate_fa24ad7ba18b08a067dfafc88f8f31a8672f91eab329b460a51c1786e9023d78->block_particle() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:216 |
52 | Twig\Template->displayBlock() | JROOT/cache/gantry5/g5_helium/twig/72/72fe691d71be39d50030851067d8119b7647bba7855e0d1db5389a5d2ee3b093.php:73 |
51 | __TwigTemplate_65b2adc0b8fc17c3166ffc5b2c534f81cd1ec81c50d53706d96ed2bd3d2c3700->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 |
50 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 |
49 | Twig\Template->display() | JROOT/cache/gantry5/g5_helium/twig/f3/f33e020a7c995c3091226ca5bf2951dd75aa163487741287c6ac4232bb3ab724.php:35 |
48 | __TwigTemplate_fa24ad7ba18b08a067dfafc88f8f31a8672f91eab329b460a51c1786e9023d78->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 |
47 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 |
46 | Twig\Template->display() | JROOT/cache/gantry5/g5_helium/twig/6f/6f6efd2cbae7b8a2f3ef2d9fcdd2994778476ec2582eb564f90b19871344036e.php:165 |
45 | __TwigTemplate_d263f579c8fe48262eca10b688e33707f3c6d7b5cff39596469a169893690e33->getdisplayParticle() | JROOT/cache/gantry5/g5_helium/twig/6f/6f6efd2cbae7b8a2f3ef2d9fcdd2994778476ec2582eb564f90b19871344036e.php:371 |
44 | __TwigTemplate_d263f579c8fe48262eca10b688e33707f3c6d7b5cff39596469a169893690e33->getdisplayItem() | JROOT/cache/gantry5/g5_helium/twig/6f/6f6efd2cbae7b8a2f3ef2d9fcdd2994778476ec2582eb564f90b19871344036e.php:529 |
43 | __TwigTemplate_d263f579c8fe48262eca10b688e33707f3c6d7b5cff39596469a169893690e33->getdisplayItems() | JROOT/cache/gantry5/g5_helium/twig/6f/6f6efd2cbae7b8a2f3ef2d9fcdd2994778476ec2582eb564f90b19871344036e.php:474 |
42 | __TwigTemplate_d263f579c8fe48262eca10b688e33707f3c6d7b5cff39596469a169893690e33->getdisplayContainers() | JROOT/cache/gantry5/g5_helium/twig/6f/6f6efd2cbae7b8a2f3ef2d9fcdd2994778476ec2582eb564f90b19871344036e.php:589 |
41 | __TwigTemplate_d263f579c8fe48262eca10b688e33707f3c6d7b5cff39596469a169893690e33->getdisplaySubmenu() | JROOT/cache/gantry5/g5_helium/twig/6f/6f6efd2cbae7b8a2f3ef2d9fcdd2994778476ec2582eb564f90b19871344036e.php:414 |
40 | __TwigTemplate_d263f579c8fe48262eca10b688e33707f3c6d7b5cff39596469a169893690e33->getdisplayItem() | JROOT/cache/gantry5/g5_helium/twig/6f/6f6efd2cbae7b8a2f3ef2d9fcdd2994778476ec2582eb564f90b19871344036e.php:529 |
39 | __TwigTemplate_d263f579c8fe48262eca10b688e33707f3c6d7b5cff39596469a169893690e33->getdisplayItems() | JROOT/cache/gantry5/g5_helium/twig/6f/6f6efd2cbae7b8a2f3ef2d9fcdd2994778476ec2582eb564f90b19871344036e.php:82 |
38 | __TwigTemplate_d263f579c8fe48262eca10b688e33707f3c6d7b5cff39596469a169893690e33->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 |
37 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 |
36 | Twig\Template->display() | JROOT/cache/gantry5/g5_helium/twig/43/4381d28d64cd975d4bbc65ccd08fd905efb17597742fa402c881bea16f41ff5f.php:71 |
35 | __TwigTemplate_31abb5d75caeb3e91290b7b0ef453a194196eae94181655d9fe5baf108036a80->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 |
34 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 |
33 | Twig\Template->display() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:434 |
32 | Twig\Template->render() | JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47 |
31 | Twig\TemplateWrapper->render() | JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384 |
30 | Twig\Environment->render() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163 |
29 | Gantry\Component\Theme\AbstractTheme->render() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:766 |
28 | Gantry\Framework\Theme->getContent() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:666 |
27 | Gantry\Framework\Theme->renderContent() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:593 |
26 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579 |
25 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579 |
24 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579 |
23 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:422 |
22 | Gantry\Framework\Theme->segments() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:702 |
21 | Twig\Template->getAttribute() | JROOT/cache/gantry5/g5_helium/twig/33/338d1ce3e48aeca3c38dcaa34b84b0db9f26e4cdc7d62420ac1e48e9522c3306.php:47 |
20 | __TwigTemplate_11b94903ac9c38de4bb2105a5066ee742973b4957d19cccc6fa09167e85a5546->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 |
19 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 |
18 | Twig\Template->display() | JROOT/cache/gantry5/g5_helium/twig/5a/5a9c061f91d7ca9e615210fa73ebddac3d62aa7de47b8be54b4a5f3517f4cab8.php:35 |
17 | __TwigTemplate_277af7fe659c06d904eb257d5eb4bd19d8ee1919fab0c34eba6f071815650844->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 |
16 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 |
15 | Twig\Template->display() | JROOT/cache/gantry5/g5_helium/twig/54/546c22eede2b41fbdf4f134b6757afffe7a54ce26a7295501abc0a81a19bdbb9.php:35 |
14 | __TwigTemplate_97f532d943bf881f0138e74af281e2606c8525f3ee65d2e711ad60e46a5eb82e->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 |
13 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 |
12 | Twig\Template->display() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:434 |
11 | Twig\Template->render() | JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47 |
10 | Twig\TemplateWrapper->render() | JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384 |
9 | Twig\Environment->render() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163 |
8 | Gantry\Component\Theme\AbstractTheme->render() | JROOT/templates/g5_helium/index.php:23 |
7 | require JROOT/templates/g5_helium/index.php | JROOT/libraries/src/Document/HtmlDocument.php:668 |
6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:730 |
5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:545 |
4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1030 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:202 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:51 |
Query Time: 0.57 ms After last query: 1.66 ms Query memory: 0.038 MB Memory before query: 7.671 MB Rows returned: 0
SELECT
users.id,
COALESCE( (SELECT user_images.`value`
FROM joom_fields_values user_images JOIN joom_fields image_fields
ON user_images.field_id = image_fields.id
WHERE user_images.item_id = users.id
AND image_fields.`name` = 'user-image'), 'images/users/user_placeholder.png') avatar_link,
COALESCE( (SELECT user_images.`value`
FROM joom_fields_values user_images JOIN joom_fields image_fields
ON user_images.field_id = image_fields.id
WHERE user_images.item_id = users.id
AND image_fields.`name` = 'background-user-image'), 'images/users/user_placeholder.png') background_link,
users.name
FROM
joom_users users
WHERE
users.id = '0'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | PRIMARY | NULL | NULL | NULL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | NULL | NULL | no matching row in const table |
3 | DEPENDENT SUBQUERY | image_fields | NULL | ALL | PRIMARY | NO INDEX KEY COULD BE USED | NULL | NULL | 6 | 16.67 | Using where |
3 | DEPENDENT SUBQUERY | user_images | NULL | ref | idx_field_id,idx_item_id | idx_field_id | 4 | baycik_diyar.image_fields.id | 83 | 10.00 | Using where |
2 | DEPENDENT SUBQUERY | image_fields | NULL | ALL | PRIMARY | NO INDEX KEY COULD BE USED | NULL | NULL | 6 | 16.67 | Using where |
2 | DEPENDENT SUBQUERY | user_images | NULL | ref | idx_field_id,idx_item_id | idx_field_id | 4 | baycik_diyar.image_fields.id | 83 | 10.00 | Using where |
Status | Duration |
---|
starting | 0.07 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
Opening tables | 0.20 ms |
init | 0.03 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.03 ms |
optimizing | 0.01 ms |
statistics | 0.02 ms |
preparing | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.02 ms |
preparing | 0.01 ms |
executing | 0.01 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 |
---|
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.30 ms After last query: 0.07 ms Query memory: 0.038 MB Memory before query: 7.698 MB Rows returned: 1
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)t
id | 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.13 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.28 ms |
init | 0.09 ms |
System lock | 0.01 ms |
optimizing | 0.00 ms |
optimizing | 0.02 ms |
statistics | 0.14 ms |
preparing | 0.03 ms |
Creating tmp table | 0.01 ms |
Sorting result | 0.01 ms |
optimizing | 0.02 ms |
statistics | 0.09 ms |
preparing | 0.02 ms |
statistics | 0.01 ms |
preparing | 0.01 ms |
executing | 0.01 ms |
Sending data | 0.01 ms |
executing | 0.00 ms |
Sending data | 1.16 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.06 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: 3.04 ms After last query: 0.07 ms Query memory: 0.038 MB Memory before query: 7.721 MB Rows returned: 0
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 ASC
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | PRIMARY | menu | NULL | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 150 | 2.00 | Using where; Using filesort |
1 | PRIMARY | <derived2> | NULL | ref | <auto_key0> | <auto_key0> | 4 | baycik_diyar.menu.parent_id | 6 | 100.00 | Using where |
2 | DERIVED | assoc1 | NULL | ref | PRIMARY,idx_key | PRIMARY | 202 | const | 86 | 100.00 | Using temporary |
2 | DERIVED | parent_menu | NULL | eq_ref | PRIMARY,idx_alias,idx_language | PRIMARY | 4 | baycik_diyar.assoc1.id | 1 | 36.00 | Using where |
2 | DERIVED | assoc2 | NULL | ref | PRIMARY,idx_key | idx_key | 330 | baycik_diyar.assoc1.key,const | 2 | 100.00 | Using index; Distinct |
2 | DERIVED | parent_menu_assoc | NULL | eq_ref | PRIMARY,idx_alias | PRIMARY | 4 | baycik_diyar.assoc2.id | 1 | 100.00 | Using where; Distinct |
Status | Duration |
---|
starting | 0.07 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
Opening tables | 0.08 ms |
init | 0.10 ms |
System lock | 0.01 ms |
optimizing | 0.00 ms |
optimizing | 0.01 ms |
statistics | 0.14 ms |
preparing | 0.02 ms |
Creating tmp table | 0.05 ms |
statistics | 0.02 ms |
preparing | 0.01 ms |
Sorting result | 0.00 ms |
executing | 0.14 ms |
Sending data | 0.02 ms |
Creating sort index | 0.13 ms |
executing | 0.00 ms |
Sending data | 1.95 ms |
end | 0.01 ms |
query end | 0.01 ms |
removing tmp table | 0.06 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
removing tmp table | 0.05 ms |
closing tables | 0.04 ms |
freeing items | 0.03 ms |
cleaning up | 0.00 ms |
# | Caller | File and line number |
---|
52 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1506 |
51 | JDatabaseDriver->loadAssocList() | JROOT/modules/mod_user_dashboard_mini/helper.php:92 |
50 | ModUserDashboardMiniHelper::getUserMenuTree() | JROOT/modules/mod_user_dashboard_mini/mod_user_dashboard_mini.php:24 |
49 | include JROOT/modules/mod_user_dashboard_mini/mod_user_dashboard_mini.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
48 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
47 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:195 |
46 | Gantry\Framework\Platform->displayModule() | Same as call in the line below. |
45 | call_user_func_array() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:704 |
44 | Twig\Template->getAttribute() | JROOT/cache/gantry5/g5_helium/twig/f3/f33e020a7c995c3091226ca5bf2951dd75aa163487741287c6ac4232bb3ab724.php:43 |
43 | __TwigTemplate_fa24ad7ba18b08a067dfafc88f8f31a8672f91eab329b460a51c1786e9023d78->block_particle() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:216 |
42 | Twig\Template->displayBlock() | JROOT/cache/gantry5/g5_helium/twig/72/72fe691d71be39d50030851067d8119b7647bba7855e0d1db5389a5d2ee3b093.php:73 |
41 | __TwigTemplate_65b2adc0b8fc17c3166ffc5b2c534f81cd1ec81c50d53706d96ed2bd3d2c3700->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 |
40 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 |
39 | Twig\Template->display() | JROOT/cache/gantry5/g5_helium/twig/f3/f33e020a7c995c3091226ca5bf2951dd75aa163487741287c6ac4232bb3ab724.php:35 |
38 | __TwigTemplate_fa24ad7ba18b08a067dfafc88f8f31a8672f91eab329b460a51c1786e9023d78->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 |
37 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 |
36 | Twig\Template->display() | JROOT/cache/gantry5/g5_helium/twig/40/40a68c93f9fa61bdbf6a23e309fe06cf50b144274eb149d4c92319eba9049b3f.php:53 |
35 | __TwigTemplate_e3ac87ee957206f0e3e7a15f8428ebb8943621df7c8387192aaaad3239284aa2->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 |
34 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 |
33 | Twig\Template->display() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:434 |
32 | Twig\Template->render() | JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47 |
31 | Twig\TemplateWrapper->render() | JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384 |
30 | Twig\Environment->render() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163 |
29 | Gantry\Component\Theme\AbstractTheme->render() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:766 |
28 | Gantry\Framework\Theme->getContent() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:666 |
27 | Gantry\Framework\Theme->renderContent() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:593 |
26 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579 |
25 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579 |
24 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579 |
23 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:422 |
22 | Gantry\Framework\Theme->segments() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:702 |
21 | Twig\Template->getAttribute() | JROOT/cache/gantry5/g5_helium/twig/33/338d1ce3e48aeca3c38dcaa34b84b0db9f26e4cdc7d62420ac1e48e9522c3306.php:47 |
20 | __TwigTemplate_11b94903ac9c38de4bb2105a5066ee742973b4957d19cccc6fa09167e85a5546->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 |
19 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 |
18 | Twig\Template->display() | JROOT/cache/gantry5/g5_helium/twig/5a/5a9c061f91d7ca9e615210fa73ebddac3d62aa7de47b8be54b4a5f3517f4cab8.php:35 |
17 | __TwigTemplate_277af7fe659c06d904eb257d5eb4bd19d8ee1919fab0c34eba6f071815650844->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 |
16 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 |
15 | Twig\Template->display() | JROOT/cache/gantry5/g5_helium/twig/54/546c22eede2b41fbdf4f134b6757afffe7a54ce26a7295501abc0a81a19bdbb9.php:35 |
14 | __TwigTemplate_97f532d943bf881f0138e74af281e2606c8525f3ee65d2e711ad60e46a5eb82e->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 |
13 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 |
12 | Twig\Template->display() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:434 |
11 | Twig\Template->render() | JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47 |
10 | Twig\TemplateWrapper->render() | JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384 |
9 | Twig\Environment->render() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163 |
8 | Gantry\Component\Theme\AbstractTheme->render() | JROOT/templates/g5_helium/index.php:23 |
7 | require JROOT/templates/g5_helium/index.php | JROOT/libraries/src/Document/HtmlDocument.php:668 |
6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:730 |
5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:545 |
4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1030 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:202 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:51 |
Query Time: 3.34 ms After last query: 2.01 ms Query memory: 0.039 MB Memory before query: 7.808 MB Rows returned: 1
SELECT
category_titles.id,
category_titles.title,
category_titles.description,
count(DISTINCT content.id) as article_count
FROM
joom_content content
JOIN
joom_categories categories
ON content.catid = categories.id
JOIN
joom_categories category_titles
ON category_titles.path = SUBSTRING_INDEX(categories.path, '/', 1)
LEFT JOIN
joom_fields_values content_fields
ON content.id = content_fields.item_id
WHERE
content.access IN (1,9)
AND content.title LIKE '%'
AND (content.language = 'en-GB' OR content.language = '*' )
AND content.catid NOT IN (2,3,4,5,7,8,9,10,11,13,14,48,49)
AND content.state = 1
AND (content_fields.`value` = 'article' OR content_fields.`value` IS NULL)
GROUP BY category_titles.title
ORDER BY article_count DESC
LIMIT 0, 25
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | content | NULL | range | idx_access,idx_state,idx_catid,idx_language | idx_language | 28 | NULL | 17 | 11.11 | Using index condition; Using where; Using temporary; Using filesort |
1 | SIMPLE | categories | NULL | eq_ref | PRIMARY | PRIMARY | 4 | baycik_diyar.content.catid | 1 | 100.00 | Using where |
1 | SIMPLE | category_titles | NULL | ref | idx_path | idx_path | 402 | func | 1 | 100.00 | Using where |
1 | SIMPLE | content_fields | NULL | ALL | idx_item_id | NO INDEX KEY COULD BE USED | NULL | NULL | 333 | 19.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 |
Opening tables | 0.02 ms |
init | 0.04 ms |
System lock | 0.01 ms |
optimizing | 0.02 ms |
statistics | 0.15 ms |
preparing | 0.04 ms |
Creating tmp table | 0.05 ms |
Creating tmp table | 0.02 ms |
Sorting result | 0.00 ms |
executing | 0.00 ms |
Sending data | 2.45 ms |
Creating sort index | 0.12 ms |
Creating sort index | 0.02 ms |
end | 0.00 ms |
query end | 0.01 ms |
removing tmp table | 0.03 ms |
query end | 0.01 ms |
removing tmp table | 0.02 ms |
query end | 0.07 ms |
removing tmp table | 0.00 ms |
query end | 0.00 ms |
closing tables | 0.04 ms |
freeing items | 0.01 ms |
removing tmp table | 0.00 ms |
freeing items | 0.02 ms |
cleaning up | 0.00 ms |
# | Caller | File and line number |
---|
54 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1506 |
53 | JDatabaseDriver->loadAssocList() | JROOT/components/com_ilimhane/models/ItemArticle.php:59 |
52 | IlimhaneModelItemArticle::itemListGetGroups() | JROOT/components/com_ilimhane/models/ItemArticle.php:72 |
51 | IlimhaneModelItemArticle::itemListGetByFilter() | JROOT/components/com_ilimhane/models/Item.php:26 |
50 | IlimhaneModelItem::itemListGet() | JROOT/modules/mod_ilimhane/mod_ilimhane.php:197 |
49 | include JROOT/modules/mod_ilimhane/mod_ilimhane.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
48 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
47 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:195 |
46 | Gantry\Framework\Platform->displayModule() | Same as call in the line below. |
45 | call_user_func_array() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:704 |
44 | Twig\Template->getAttribute() | JROOT/cache/gantry5/g5_helium/twig/f3/f33e020a7c995c3091226ca5bf2951dd75aa163487741287c6ac4232bb3ab724.php:43 |
43 | __TwigTemplate_fa24ad7ba18b08a067dfafc88f8f31a8672f91eab329b460a51c1786e9023d78->block_particle() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:216 |
42 | Twig\Template->displayBlock() | JROOT/cache/gantry5/g5_helium/twig/72/72fe691d71be39d50030851067d8119b7647bba7855e0d1db5389a5d2ee3b093.php:73 |
41 | __TwigTemplate_65b2adc0b8fc17c3166ffc5b2c534f81cd1ec81c50d53706d96ed2bd3d2c3700->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 |
40 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 |
39 | Twig\Template->display() | JROOT/cache/gantry5/g5_helium/twig/f3/f33e020a7c995c3091226ca5bf2951dd75aa163487741287c6ac4232bb3ab724.php:35 |
38 | __TwigTemplate_fa24ad7ba18b08a067dfafc88f8f31a8672f91eab329b460a51c1786e9023d78->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 |
37 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 |
36 | Twig\Template->display() | JROOT/cache/gantry5/g5_helium/twig/40/40a68c93f9fa61bdbf6a23e309fe06cf50b144274eb149d4c92319eba9049b3f.php:53 |
35 | __TwigTemplate_e3ac87ee957206f0e3e7a15f8428ebb8943621df7c8387192aaaad3239284aa2->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 |
34 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 |
33 | Twig\Template->display() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:434 |
32 | Twig\Template->render() | JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47 |
31 | Twig\TemplateWrapper->render() | JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384 |
30 | Twig\Environment->render() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163 |
29 | Gantry\Component\Theme\AbstractTheme->render() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:766 |
28 | Gantry\Framework\Theme->getContent() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:666 |
27 | Gantry\Framework\Theme->renderContent() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:593 |
26 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579 |
25 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579 |
24 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579 |
23 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:422 |
22 | Gantry\Framework\Theme->segments() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:702 |
21 | Twig\Template->getAttribute() | JROOT/cache/gantry5/g5_helium/twig/33/338d1ce3e48aeca3c38dcaa34b84b0db9f26e4cdc7d62420ac1e48e9522c3306.php:47 |
20 | __TwigTemplate_11b94903ac9c38de4bb2105a5066ee742973b4957d19cccc6fa09167e85a5546->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 |
19 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 |
18 | Twig\Template->display() | JROOT/cache/gantry5/g5_helium/twig/5a/5a9c061f91d7ca9e615210fa73ebddac3d62aa7de47b8be54b4a5f3517f4cab8.php:35 |
17 | __TwigTemplate_277af7fe659c06d904eb257d5eb4bd19d8ee1919fab0c34eba6f071815650844->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 |
16 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 |
15 | Twig\Template->display() | JROOT/cache/gantry5/g5_helium/twig/54/546c22eede2b41fbdf4f134b6757afffe7a54ce26a7295501abc0a81a19bdbb9.php:35 |
14 | __TwigTemplate_97f532d943bf881f0138e74af281e2606c8525f3ee65d2e711ad60e46a5eb82e->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 |
13 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 |
12 | Twig\Template->display() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:434 |
11 | Twig\Template->render() | JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47 |
10 | Twig\TemplateWrapper->render() | JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384 |
9 | Twig\Environment->render() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163 |
8 | Gantry\Component\Theme\AbstractTheme->render() | JROOT/templates/g5_helium/index.php:23 |
7 | require JROOT/templates/g5_helium/index.php | JROOT/libraries/src/Document/HtmlDocument.php:668 |
6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:730 |
5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:545 |
4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1030 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:202 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:51 |
Query Time: 2.94 ms After last query: 0.10 ms Query memory: 0.055 MB Memory before query: 7.835 MB Rows returned: 2
SELECT
content.id,
content.title,
content.alias,
content.introtext,
content.fulltext,
content.state,
COALESCE(category.title) as parent_title,
COALESCE(category.id) as parent_id,
content.images,
content.created,
author.name as creator_name,
author_dashboard.avatar_link as creator_image,
content.modified,
content.access,
content.hits,
content.language,
content.checked_out,
content_fields.value as item_type
FROM
joom_content content
LEFT JOIN
joom_categories category
ON content.catid = category.id
LEFT JOIN
joom_contentitem_tag_map tag_to_article
ON tag_to_article.content_item_id = content.id
LEFT JOIN
joom_content_authors content_authors
ON content_authors.tag_id = tag_to_article.tag_id
LEFT JOIN
joom_users author
ON author.id = content.created_by
LEFT JOIN
joom_user_dashboard author_dashboard
ON author.id = author_dashboard.user_id
LEFT JOIN
joom_tags tag
ON tag.id = tag_to_article.tag_id
LEFT JOIN
joom_fields_values content_fields
ON content.id = content_fields.item_id
WHERE
( category.title LIKE 'Язык%' OR category.path LIKE '%язык%' )
AND content.access IN (1,9)
AND (content.language = 'en-GB' OR content.language = '*' )
AND content.catid NOT IN (1,2,3,4,5,7,8,9,10,11,13,14,48,49)
AND (content_fields.`value` = 'article' OR content_fields.`value` IS NULL)
AND content.state = 1
GROUP BY content.id
ORDER BY content.created DESC
LIMIT 0, 6
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | content | NULL | range | PRIMARY,idx_access,idx_checkout,idx_state,idx_catid,idx_createdby,idx_featured_catid,idx_language,idx_xreference,idx_alias | idx_language | 28 | NULL | 17 | 100.00 | Using index condition; Using where; Using temporary; Using filesort |
1 | SIMPLE | category | NULL | eq_ref | PRIMARY | PRIMARY | 4 | baycik_diyar.content.catid | 1 | 20.99 | Using where |
1 | SIMPLE | tag_to_article | NULL | index | NULL | idx_core_content_id | 4 | NULL | 667 | 100.00 | Using where; Using index; Using join buffer (Block Nested Loop) |
1 | SIMPLE | content_authors | NULL | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 28 | 100.00 | Using where; Using join buffer (Block Nested Loop) |
1 | SIMPLE | author | NULL | eq_ref | PRIMARY | PRIMARY | 4 | baycik_diyar.content.created_by | 1 | 100.00 | Using where |
1 | SIMPLE | author_dashboard | NULL | eq_ref | PRIMARY | PRIMARY | 4 | baycik_diyar.author.id | 1 | 100.00 | NULL |
1 | SIMPLE | tag | NULL | eq_ref | PRIMARY | PRIMARY | 4 | baycik_diyar.tag_to_article.tag_id | 1 | 100.00 | Using index |
1 | SIMPLE | content_fields | NULL | ALL | idx_item_id | NO INDEX KEY COULD BE USED | NULL | NULL | 333 | 19.00 | Using where; Using join buffer (Block Nested Loop) |
Status | Duration |
---|
starting | 0.16 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
Opening tables | 0.25 ms |
init | 0.06 ms |
System lock | 0.01 ms |
optimizing | 0.02 ms |
statistics | 0.16 ms |
preparing | 0.05 ms |
Creating tmp table | 0.04 ms |
Sorting result | 0.00 ms |
executing | 0.00 ms |
Sending data | 1.87 ms |
Creating sort index | 0.05 ms |
end | 0.00 ms |
query end | 0.01 ms |
removing tmp table | 0.03 ms |
query end | 0.01 ms |
closing tables | 0.06 ms |
freeing items | 0.04 ms |
cleaning up | 0.00 ms |
# | Caller | File and line number |
---|
54 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1506 |
53 | JDatabaseDriver->loadAssocList() | JROOT/components/com_ilimhane/models/Item.php:146 |
52 | IlimhaneModelItem::itemByNameGet() | JROOT/components/com_ilimhane/models/ItemArticle.php:86 |
51 | IlimhaneModelItemArticle::itemListGetByFilter() | JROOT/components/com_ilimhane/models/Item.php:26 |
50 | IlimhaneModelItem::itemListGet() | JROOT/modules/mod_ilimhane/mod_ilimhane.php:197 |
49 | include JROOT/modules/mod_ilimhane/mod_ilimhane.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
48 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
47 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:195 |
46 | Gantry\Framework\Platform->displayModule() | Same as call in the line below. |
45 | call_user_func_array() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:704 |
44 | Twig\Template->getAttribute() | JROOT/cache/gantry5/g5_helium/twig/f3/f33e020a7c995c3091226ca5bf2951dd75aa163487741287c6ac4232bb3ab724.php:43 |
43 | __TwigTemplate_fa24ad7ba18b08a067dfafc88f8f31a8672f91eab329b460a51c1786e9023d78->block_particle() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:216 |
42 | Twig\Template->displayBlock() | JROOT/cache/gantry5/g5_helium/twig/72/72fe691d71be39d50030851067d8119b7647bba7855e0d1db5389a5d2ee3b093.php:73 |
41 | __TwigTemplate_65b2adc0b8fc17c3166ffc5b2c534f81cd1ec81c50d53706d96ed2bd3d2c3700->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 |
40 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 |
39 | Twig\Template->display() | JROOT/cache/gantry5/g5_helium/twig/f3/f33e020a7c995c3091226ca5bf2951dd75aa163487741287c6ac4232bb3ab724.php:35 |
38 | __TwigTemplate_fa24ad7ba18b08a067dfafc88f8f31a8672f91eab329b460a51c1786e9023d78->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 |
37 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 |
36 | Twig\Template->display() | JROOT/cache/gantry5/g5_helium/twig/40/40a68c93f9fa61bdbf6a23e309fe06cf50b144274eb149d4c92319eba9049b3f.php:53 |
35 | __TwigTemplate_e3ac87ee957206f0e3e7a15f8428ebb8943621df7c8387192aaaad3239284aa2->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 |
34 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 |
33 | Twig\Template->display() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:434 |
32 | Twig\Template->render() | JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47 |
31 | Twig\TemplateWrapper->render() | JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384 |
30 | Twig\Environment->render() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163 |
29 | Gantry\Component\Theme\AbstractTheme->render() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:766 |
28 | Gantry\Framework\Theme->getContent() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:666 |
27 | Gantry\Framework\Theme->renderContent() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:593 |
26 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579 |
25 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579 |
24 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579 |
23 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:422 |
22 | Gantry\Framework\Theme->segments() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:702 |
21 | Twig\Template->getAttribute() | JROOT/cache/gantry5/g5_helium/twig/33/338d1ce3e48aeca3c38dcaa34b84b0db9f26e4cdc7d62420ac1e48e9522c3306.php:47 |
20 | __TwigTemplate_11b94903ac9c38de4bb2105a5066ee742973b4957d19cccc6fa09167e85a5546->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 |
19 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 |
18 | Twig\Template->display() | JROOT/cache/gantry5/g5_helium/twig/5a/5a9c061f91d7ca9e615210fa73ebddac3d62aa7de47b8be54b4a5f3517f4cab8.php:35 |
17 | __TwigTemplate_277af7fe659c06d904eb257d5eb4bd19d8ee1919fab0c34eba6f071815650844->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 |
16 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 |
15 | Twig\Template->display() | JROOT/cache/gantry5/g5_helium/twig/54/546c22eede2b41fbdf4f134b6757afffe7a54ce26a7295501abc0a81a19bdbb9.php:35 |
14 | __TwigTemplate_97f532d943bf881f0138e74af281e2606c8525f3ee65d2e711ad60e46a5eb82e->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 |
13 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 |
12 | Twig\Template->display() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:434 |
11 | Twig\Template->render() | JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47 |
10 | Twig\TemplateWrapper->render() | JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384 |
9 | Twig\Environment->render() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163 |
8 | Gantry\Component\Theme\AbstractTheme->render() | JROOT/templates/g5_helium/index.php:23 |
7 | require JROOT/templates/g5_helium/index.php | JROOT/libraries/src/Document/HtmlDocument.php:668 |
6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:730 |
5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:545 |
4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1030 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:202 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:51 |
Query Time: 0.86 ms After last query: 0.16 ms Query memory: 0.039 MB Memory before query: 7.874 MB Rows returned: 0
SELECT DISTINCT
tags.title,
REPLACE(JSON_EXTRACT(tags.params,'$.tag_link_class'), '"','') as tag_link_class
FROM
joom_content content
JOIN
joom_fields_values content_fields
ON content.id = content_fields.item_id
JOIN
joom_contentitem_tag_map tag_to_article
ON tag_to_article.content_item_id = content.id
JOIN
joom_tags tags
ON tags.id = tag_to_article.tag_id
WHERE
content.id = 129
AND tags.note != 'challenge'
AND tags.note != 'author'
AND tags.access IN (1,9)
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | content | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | Using index; Using temporary |
1 | SIMPLE | content_fields | NULL | ALL | idx_item_id | NO INDEX KEY COULD BE USED | NULL | NULL | 333 | 10.00 | Using where |
1 | SIMPLE | tag_to_article | NULL | index | idx_tag_type | idx_core_content_id | 4 | NULL | 667 | 10.00 | Using where; Using index; Using join buffer (Block Nested Loop) |
1 | SIMPLE | tags | NULL | eq_ref | PRIMARY,idx_access | PRIMARY | 4 | baycik_diyar.tag_to_article.tag_id | 1 | 81.00 | Using where |
Status | Duration |
---|
starting | 0.07 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
Opening tables | 0.01 ms |
init | 0.03 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.09 ms |
preparing | 0.02 ms |
Creating tmp table | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.43 ms |
end | 0.00 ms |
query end | 0.01 ms |
removing tmp table | 0.03 ms |
query end | 0.01 ms |
closing tables | 0.03 ms |
freeing items | 0.02 ms |
cleaning up | 0.00 ms |
# | Caller | File and line number |
---|
55 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1506 |
54 | JDatabaseDriver->loadAssocList() | JROOT/components/com_ilimhane/models/Item.php:345 |
53 | IlimhaneModelItem::itemTagListGet() | JROOT/components/com_ilimhane/models/ItemArticle.php:115 |
52 | IlimhaneModelItemArticle::itemListCompose() | JROOT/components/com_ilimhane/models/ItemArticle.php:87 |
51 | IlimhaneModelItemArticle::itemListGetByFilter() | JROOT/components/com_ilimhane/models/Item.php:26 |
50 | IlimhaneModelItem::itemListGet() | JROOT/modules/mod_ilimhane/mod_ilimhane.php:197 |
49 | include JROOT/modules/mod_ilimhane/mod_ilimhane.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
48 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
47 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:195 |
46 | Gantry\Framework\Platform->displayModule() | Same as call in the line below. |
45 | call_user_func_array() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:704 |
44 | Twig\Template->getAttribute() | JROOT/cache/gantry5/g5_helium/twig/f3/f33e020a7c995c3091226ca5bf2951dd75aa163487741287c6ac4232bb3ab724.php:43 |
43 | __TwigTemplate_fa24ad7ba18b08a067dfafc88f8f31a8672f91eab329b460a51c1786e9023d78->block_particle() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:216 |
42 | Twig\Template->displayBlock() | JROOT/cache/gantry5/g5_helium/twig/72/72fe691d71be39d50030851067d8119b7647bba7855e0d1db5389a5d2ee3b093.php:73 |
41 | __TwigTemplate_65b2adc0b8fc17c3166ffc5b2c534f81cd1ec81c50d53706d96ed2bd3d2c3700->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 |
40 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 |
39 | Twig\Template->display() | JROOT/cache/gantry5/g5_helium/twig/f3/f33e020a7c995c3091226ca5bf2951dd75aa163487741287c6ac4232bb3ab724.php:35 |
38 | __TwigTemplate_fa24ad7ba18b08a067dfafc88f8f31a8672f91eab329b460a51c1786e9023d78->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 |
37 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 |
36 | Twig\Template->display() | JROOT/cache/gantry5/g5_helium/twig/40/40a68c93f9fa61bdbf6a23e309fe06cf50b144274eb149d4c92319eba9049b3f.php:53 |
35 | __TwigTemplate_e3ac87ee957206f0e3e7a15f8428ebb8943621df7c8387192aaaad3239284aa2->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 |
34 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 |
33 | Twig\Template->display() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:434 |
32 | Twig\Template->render() | JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47 |
31 | Twig\TemplateWrapper->render() | JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384 |
30 | Twig\Environment->render() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163 |
29 | Gantry\Component\Theme\AbstractTheme->render() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:766 |
28 | Gantry\Framework\Theme->getContent() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:666 |
27 | Gantry\Framework\Theme->renderContent() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:593 |
26 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579 |
25 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579 |
24 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579 |
23 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:422 |
22 | Gantry\Framework\Theme->segments() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:702 |
21 | Twig\Template->getAttribute() | JROOT/cache/gantry5/g5_helium/twig/33/338d1ce3e48aeca3c38dcaa34b84b0db9f26e4cdc7d62420ac1e48e9522c3306.php:47 |
20 | __TwigTemplate_11b94903ac9c38de4bb2105a5066ee742973b4957d19cccc6fa09167e85a5546->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 |
19 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 |
18 | Twig\Template->display() | JROOT/cache/gantry5/g5_helium/twig/5a/5a9c061f91d7ca9e615210fa73ebddac3d62aa7de47b8be54b4a5f3517f4cab8.php:35 |
17 | __TwigTemplate_277af7fe659c06d904eb257d5eb4bd19d8ee1919fab0c34eba6f071815650844->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 |
16 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 |
15 | Twig\Template->display() | JROOT/cache/gantry5/g5_helium/twig/54/546c22eede2b41fbdf4f134b6757afffe7a54ce26a7295501abc0a81a19bdbb9.php:35 |
14 | __TwigTemplate_97f532d943bf881f0138e74af281e2606c8525f3ee65d2e711ad60e46a5eb82e->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 |
13 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 |
12 | Twig\Template->display() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:434 |
11 | Twig\Template->render() | JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47 |
10 | Twig\TemplateWrapper->render() | JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384 |
9 | Twig\Environment->render() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163 |
8 | Gantry\Component\Theme\AbstractTheme->render() | JROOT/templates/g5_helium/index.php:23 |
7 | require JROOT/templates/g5_helium/index.php | JROOT/libraries/src/Document/HtmlDocument.php:668 |
6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:730 |
5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:545 |
4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1030 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:202 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:51 |
Query Time: 0.80 ms After last query: 0.10 ms Query memory: 0.039 MB Memory before query: 7.900 MB Rows returned: 0
SELECT DISTINCT
tags.title,
REPLACE(JSON_EXTRACT(tags.params,'$.tag_link_class'), '"','') as tag_link_class
FROM
joom_content content
JOIN
joom_fields_values content_fields
ON content.id = content_fields.item_id
JOIN
joom_contentitem_tag_map tag_to_article
ON tag_to_article.content_item_id = content.id
JOIN
joom_tags tags
ON tags.id = tag_to_article.tag_id
WHERE
content.id = 128
AND tags.note != 'challenge'
AND tags.note != 'author'
AND tags.access IN (1,9)
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | content | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | Using index; Using temporary |
1 | SIMPLE | content_fields | NULL | ALL | idx_item_id | NO INDEX KEY COULD BE USED | NULL | NULL | 333 | 10.00 | Using where |
1 | SIMPLE | tag_to_article | NULL | index | idx_tag_type | idx_core_content_id | 4 | NULL | 667 | 10.00 | Using where; Using index; Using join buffer (Block Nested Loop) |
1 | SIMPLE | tags | NULL | eq_ref | PRIMARY,idx_access | PRIMARY | 4 | baycik_diyar.tag_to_article.tag_id | 1 | 81.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 |
Opening tables | 0.01 ms |
init | 0.02 ms |
System lock | 0.00 ms |
optimizing | 0.01 ms |
statistics | 0.09 ms |
preparing | 0.02 ms |
Creating tmp table | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.42 ms |
end | 0.00 ms |
query end | 0.01 ms |
removing tmp table | 0.02 ms |
query end | 0.00 ms |
closing tables | 0.02 ms |
freeing items | 0.02 ms |
cleaning up | 0.00 ms |
# | Caller | File and line number |
---|
55 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1506 |
54 | JDatabaseDriver->loadAssocList() | JROOT/components/com_ilimhane/models/Item.php:345 |
53 | IlimhaneModelItem::itemTagListGet() | JROOT/components/com_ilimhane/models/ItemArticle.php:115 |
52 | IlimhaneModelItemArticle::itemListCompose() | JROOT/components/com_ilimhane/models/ItemArticle.php:87 |
51 | IlimhaneModelItemArticle::itemListGetByFilter() | JROOT/components/com_ilimhane/models/Item.php:26 |
50 | IlimhaneModelItem::itemListGet() | JROOT/modules/mod_ilimhane/mod_ilimhane.php:197 |
49 | include JROOT/modules/mod_ilimhane/mod_ilimhane.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
48 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
47 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:195 |
46 | Gantry\Framework\Platform->displayModule() | Same as call in the line below. |
45 | call_user_func_array() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:704 |
44 | Twig\Template->getAttribute() | JROOT/cache/gantry5/g5_helium/twig/f3/f33e020a7c995c3091226ca5bf2951dd75aa163487741287c6ac4232bb3ab724.php:43 |
43 | __TwigTemplate_fa24ad7ba18b08a067dfafc88f8f31a8672f91eab329b460a51c1786e9023d78->block_particle() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:216 |
42 | Twig\Template->displayBlock() | JROOT/cache/gantry5/g5_helium/twig/72/72fe691d71be39d50030851067d8119b7647bba7855e0d1db5389a5d2ee3b093.php:73 |
41 | __TwigTemplate_65b2adc0b8fc17c3166ffc5b2c534f81cd1ec81c50d53706d96ed2bd3d2c3700->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 |
40 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 |
39 | Twig\Template->display() | JROOT/cache/gantry5/g5_helium/twig/f3/f33e020a7c995c3091226ca5bf2951dd75aa163487741287c6ac4232bb3ab724.php:35 |
38 | __TwigTemplate_fa24ad7ba18b08a067dfafc88f8f31a8672f91eab329b460a51c1786e9023d78->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 |
37 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 |
36 | Twig\Template->display() | JROOT/cache/gantry5/g5_helium/twig/40/40a68c93f9fa61bdbf6a23e309fe06cf50b144274eb149d4c92319eba9049b3f.php:53 |
35 | __TwigTemplate_e3ac87ee957206f0e3e7a15f8428ebb8943621df7c8387192aaaad3239284aa2->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 |
34 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 |
33 | Twig\Template->display() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:434 |
32 | Twig\Template->render() | JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47 |
31 | Twig\TemplateWrapper->render() | JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384 |
30 | Twig\Environment->render() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163 |
29 | Gantry\Component\Theme\AbstractTheme->render() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:766 |
28 | Gantry\Framework\Theme->getContent() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:666 |
27 | Gantry\Framework\Theme->renderContent() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:593 |
26 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579 |
25 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579 |
24 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579 |
23 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:422 |
22 | Gantry\Framework\Theme->segments() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:702 |
21 | Twig\Template->getAttribute() | JROOT/cache/gantry5/g5_helium/twig/33/338d1ce3e48aeca3c38dcaa34b84b0db9f26e4cdc7d62420ac1e48e9522c3306.php:47 |
20 | __TwigTemplate_11b94903ac9c38de4bb2105a5066ee742973b4957d19cccc6fa09167e85a5546->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 |
19 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 |
18 | Twig\Template->display() | JROOT/cache/gantry5/g5_helium/twig/5a/5a9c061f91d7ca9e615210fa73ebddac3d62aa7de47b8be54b4a5f3517f4cab8.php:35 |
17 | __TwigTemplate_277af7fe659c06d904eb257d5eb4bd19d8ee1919fab0c34eba6f071815650844->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 |
16 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 |
15 | Twig\Template->display() | JROOT/cache/gantry5/g5_helium/twig/54/546c22eede2b41fbdf4f134b6757afffe7a54ce26a7295501abc0a81a19bdbb9.php:35 |
14 | __TwigTemplate_97f532d943bf881f0138e74af281e2606c8525f3ee65d2e711ad60e46a5eb82e->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 |
13 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 |
12 | Twig\Template->display() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:434 |
11 | Twig\Template->render() | JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47 |
10 | Twig\TemplateWrapper->render() | JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384 |
9 | Twig\Environment->render() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163 |
8 | Gantry\Component\Theme\AbstractTheme->render() | JROOT/templates/g5_helium/index.php:23 |
7 | require JROOT/templates/g5_helium/index.php | JROOT/libraries/src/Document/HtmlDocument.php:668 |
6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:730 |
5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:545 |
4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1030 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:202 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:51 |
Query Time: 3.57 ms After last query: 0.10 ms Query memory: 0.039 MB Memory before query: 7.926 MB Rows returned: 0
SELECT
categories.id,
COUNT(tag.id) AS tag_count,
tag.title,
REPLACE(JSON_EXTRACT(tag.params,'$.tag_link_class'), '"','') as tag_link_class
FROM
joom_content content
JOIN
joom_categories categories
ON content.catid = categories.id
JOIN
joom_categories category_titles
ON category_titles.path = SUBSTRING_INDEX(categories.path, '/', 1)
LEFT JOIN
joom_contentitem_tag_map tag_to_article
ON tag_to_article.content_item_id = content.id
LEFT JOIN
joom_tags tag
ON tag.id = tag_to_article.tag_id
WHERE
(category_titles.id = 127 OR categories.id = 127)
AND tag.title IS NOT NULL
AND tag.published = 1
AND tag.note != 'challenge'
AND tag.note != 'author'
GROUP BY tag.id
ORDER BY tag_count DESC
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | tag | NULL | ref | PRIMARY,tag_idx,idx_access,idx_checkout,idx_left_right,idx_language,idx_path,idx_alias | tag_idx | 1 | const | 38 | 72.90 | Using index condition; Using where; Using temporary; Using filesort |
1 | SIMPLE | tag_to_article | NULL | ref | idx_tag_type | idx_tag_type | 4 | baycik_diyar.tag.id | 7 | 100.00 | Using where; Using index |
1 | SIMPLE | content | NULL | eq_ref | PRIMARY,idx_catid | PRIMARY | 4 | baycik_diyar.tag_to_article.content_item_id | 1 | 100.00 | Using where |
1 | SIMPLE | categories | NULL | eq_ref | PRIMARY | PRIMARY | 4 | baycik_diyar.content.catid | 1 | 100.00 | Using where |
1 | SIMPLE | category_titles | NULL | ref | PRIMARY,idx_path | idx_path | 402 | func | 1 | 100.00 | Using index condition; Using where |
Status | Duration |
---|
starting | 0.08 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.04 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.11 ms |
preparing | 0.03 ms |
Creating tmp table | 0.02 ms |
Sorting result | 0.00 ms |
executing | 0.00 ms |
Sending data | 3.08 ms |
Creating sort index | 0.02 ms |
end | 0.00 ms |
query end | 0.01 ms |
removing tmp table | 0.02 ms |
query end | 0.01 ms |
closing tables | 0.04 ms |
freeing items | 0.03 ms |
cleaning up | 0.01 ms |
# | Caller | File and line number |
---|
54 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1506 |
53 | JDatabaseDriver->loadAssocList() | JROOT/components/com_ilimhane/models/Category.php:231 |
52 | IlimhaneModelCategory::categoryGetMostRatedTags() | JROOT/components/com_ilimhane/models/ItemArticle.php:91 |
51 | IlimhaneModelItemArticle::itemListGetByFilter() | JROOT/components/com_ilimhane/models/Item.php:26 |
50 | IlimhaneModelItem::itemListGet() | JROOT/modules/mod_ilimhane/mod_ilimhane.php:197 |
49 | include JROOT/modules/mod_ilimhane/mod_ilimhane.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
48 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
47 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:195 |
46 | Gantry\Framework\Platform->displayModule() | Same as call in the line below. |
45 | call_user_func_array() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:704 |
44 | Twig\Template->getAttribute() | JROOT/cache/gantry5/g5_helium/twig/f3/f33e020a7c995c3091226ca5bf2951dd75aa163487741287c6ac4232bb3ab724.php:43 |
43 | __TwigTemplate_fa24ad7ba18b08a067dfafc88f8f31a8672f91eab329b460a51c1786e9023d78->block_particle() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:216 |
42 | Twig\Template->displayBlock() | JROOT/cache/gantry5/g5_helium/twig/72/72fe691d71be39d50030851067d8119b7647bba7855e0d1db5389a5d2ee3b093.php:73 |
41 | __TwigTemplate_65b2adc0b8fc17c3166ffc5b2c534f81cd1ec81c50d53706d96ed2bd3d2c3700->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 |
40 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 |
39 | Twig\Template->display() | JROOT/cache/gantry5/g5_helium/twig/f3/f33e020a7c995c3091226ca5bf2951dd75aa163487741287c6ac4232bb3ab724.php:35 |
38 | __TwigTemplate_fa24ad7ba18b08a067dfafc88f8f31a8672f91eab329b460a51c1786e9023d78->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 |
37 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 |
36 | Twig\Template->display() | JROOT/cache/gantry5/g5_helium/twig/40/40a68c93f9fa61bdbf6a23e309fe06cf50b144274eb149d4c92319eba9049b3f.php:53 |
35 | __TwigTemplate_e3ac87ee957206f0e3e7a15f8428ebb8943621df7c8387192aaaad3239284aa2->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 |
34 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 |
33 | Twig\Template->display() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:434 |
32 | Twig\Template->render() | JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47 |
31 | Twig\TemplateWrapper->render() | JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384 |
30 | Twig\Environment->render() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163 |
29 | Gantry\Component\Theme\AbstractTheme->render() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:766 |
28 | Gantry\Framework\Theme->getContent() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:666 |
27 | Gantry\Framework\Theme->renderContent() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:593 |
26 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579 |
25 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579 |
24 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579 |
23 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:422 |
22 | Gantry\Framework\Theme->segments() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:702 |
21 | Twig\Template->getAttribute() | JROOT/cache/gantry5/g5_helium/twig/33/338d1ce3e48aeca3c38dcaa34b84b0db9f26e4cdc7d62420ac1e48e9522c3306.php:47 |
20 | __TwigTemplate_11b94903ac9c38de4bb2105a5066ee742973b4957d19cccc6fa09167e85a5546->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 |
19 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 |
18 | Twig\Template->display() | JROOT/cache/gantry5/g5_helium/twig/5a/5a9c061f91d7ca9e615210fa73ebddac3d62aa7de47b8be54b4a5f3517f4cab8.php:35 |
17 | __TwigTemplate_277af7fe659c06d904eb257d5eb4bd19d8ee1919fab0c34eba6f071815650844->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 |
16 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 |
15 | Twig\Template->display() | JROOT/cache/gantry5/g5_helium/twig/54/546c22eede2b41fbdf4f134b6757afffe7a54ce26a7295501abc0a81a19bdbb9.php:35 |
14 | __TwigTemplate_97f532d943bf881f0138e74af281e2606c8525f3ee65d2e711ad60e46a5eb82e->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 |
13 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 |
12 | Twig\Template->display() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:434 |
11 | Twig\Template->render() | JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47 |
10 | Twig\TemplateWrapper->render() | JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384 |
9 | Twig\Environment->render() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163 |
8 | Gantry\Component\Theme\AbstractTheme->render() | JROOT/templates/g5_helium/index.php:23 |
7 | require JROOT/templates/g5_helium/index.php | JROOT/libraries/src/Document/HtmlDocument.php:668 |
6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:730 |
5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:545 |
4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1030 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:202 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:51 |
Query Time: 1.10 ms After last query: 0.07 ms Query memory: 0.039 MB Memory before query: 7.949 MB Rows returned: 1
SELECT
categories.id,
COUNT(users.id) AS users_count,
users.name
FROM
joom_content content
JOIN
joom_categories categories
ON content.catid = categories.id
JOIN
joom_categories category_titles
ON category_titles.path = SUBSTRING_INDEX(categories.path, '/', 1)
LEFT JOIN
joom_users users
ON users.id = content.created_by
WHERE
category_titles.id = 127
AND users.name IS NOT NULL
GROUP BY users.id
ORDER BY users_count DESC
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | category_titles | NULL | const | PRIMARY,idx_path | PRIMARY | 4 | const | 1 | 100.00 | Using temporary; Using filesort |
1 | SIMPLE | content | NULL | ALL | idx_catid,idx_createdby | NO INDEX KEY COULD BE USED | NULL | NULL | 236 | 100.00 | NULL |
1 | SIMPLE | categories | NULL | eq_ref | PRIMARY | PRIMARY | 4 | baycik_diyar.content.catid | 1 | 100.00 | Using where |
1 | SIMPLE | users | NULL | eq_ref | PRIMARY,idx_username,idx_block,email,idx_name | PRIMARY | 4 | baycik_diyar.content.created_by | 1 | 90.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 |
Opening tables | 0.01 ms |
init | 0.03 ms |
System lock | 0.01 ms |
optimizing | 0.02 ms |
statistics | 0.06 ms |
preparing | 0.02 ms |
Creating tmp table | 0.02 ms |
Sorting result | 0.00 ms |
executing | 0.00 ms |
Sending data | 0.69 ms |
Creating sort index | 0.02 ms |
end | 0.00 ms |
query end | 0.00 ms |
removing tmp table | 0.06 ms |
query end | 0.01 ms |
closing tables | 0.03 ms |
freeing items | 0.02 ms |
cleaning up | 0.00 ms |
# | Caller | File and line number |
---|
54 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1506 |
53 | JDatabaseDriver->loadAssocList() | JROOT/components/com_ilimhane/models/Category.php:254 |
52 | IlimhaneModelCategory::categoryGetMostRatedUsers() | JROOT/components/com_ilimhane/models/ItemArticle.php:92 |
51 | IlimhaneModelItemArticle::itemListGetByFilter() | JROOT/components/com_ilimhane/models/Item.php:26 |
50 | IlimhaneModelItem::itemListGet() | JROOT/modules/mod_ilimhane/mod_ilimhane.php:197 |
49 | include JROOT/modules/mod_ilimhane/mod_ilimhane.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
48 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
47 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:195 |
46 | Gantry\Framework\Platform->displayModule() | Same as call in the line below. |
45 | call_user_func_array() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:704 |
44 | Twig\Template->getAttribute() | JROOT/cache/gantry5/g5_helium/twig/f3/f33e020a7c995c3091226ca5bf2951dd75aa163487741287c6ac4232bb3ab724.php:43 |
43 | __TwigTemplate_fa24ad7ba18b08a067dfafc88f8f31a8672f91eab329b460a51c1786e9023d78->block_particle() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:216 |
42 | Twig\Template->displayBlock() | JROOT/cache/gantry5/g5_helium/twig/72/72fe691d71be39d50030851067d8119b7647bba7855e0d1db5389a5d2ee3b093.php:73 |
41 | __TwigTemplate_65b2adc0b8fc17c3166ffc5b2c534f81cd1ec81c50d53706d96ed2bd3d2c3700->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 |
40 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 |
39 | Twig\Template->display() | JROOT/cache/gantry5/g5_helium/twig/f3/f33e020a7c995c3091226ca5bf2951dd75aa163487741287c6ac4232bb3ab724.php:35 |
38 | __TwigTemplate_fa24ad7ba18b08a067dfafc88f8f31a8672f91eab329b460a51c1786e9023d78->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 |
37 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 |
36 | Twig\Template->display() | JROOT/cache/gantry5/g5_helium/twig/40/40a68c93f9fa61bdbf6a23e309fe06cf50b144274eb149d4c92319eba9049b3f.php:53 |
35 | __TwigTemplate_e3ac87ee957206f0e3e7a15f8428ebb8943621df7c8387192aaaad3239284aa2->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 |
34 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 |
33 | Twig\Template->display() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:434 |
32 | Twig\Template->render() | JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47 |
31 | Twig\TemplateWrapper->render() | JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384 |
30 | Twig\Environment->render() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163 |
29 | Gantry\Component\Theme\AbstractTheme->render() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:766 |
28 | Gantry\Framework\Theme->getContent() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:666 |
27 | Gantry\Framework\Theme->renderContent() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:593 |
26 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579 |
25 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579 |
24 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579 |
23 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:422 |
22 | Gantry\Framework\Theme->segments() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:702 |
21 | Twig\Template->getAttribute() | JROOT/cache/gantry5/g5_helium/twig/33/338d1ce3e48aeca3c38dcaa34b84b0db9f26e4cdc7d62420ac1e48e9522c3306.php:47 |
20 | __TwigTemplate_11b94903ac9c38de4bb2105a5066ee742973b4957d19cccc6fa09167e85a5546->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 |
19 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 |
18 | Twig\Template->display() | JROOT/cache/gantry5/g5_helium/twig/5a/5a9c061f91d7ca9e615210fa73ebddac3d62aa7de47b8be54b4a5f3517f4cab8.php:35 |
17 | __TwigTemplate_277af7fe659c06d904eb257d5eb4bd19d8ee1919fab0c34eba6f071815650844->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 |
16 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 |
15 | Twig\Template->display() | JROOT/cache/gantry5/g5_helium/twig/54/546c22eede2b41fbdf4f134b6757afffe7a54ce26a7295501abc0a81a19bdbb9.php:35 |
14 | __TwigTemplate_97f532d943bf881f0138e74af281e2606c8525f3ee65d2e711ad60e46a5eb82e->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 |
13 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 |
12 | Twig\Template->display() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:434 |
11 | Twig\Template->render() | JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47 |
10 | Twig\TemplateWrapper->render() | JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384 |
9 | Twig\Environment->render() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163 |
8 | Gantry\Component\Theme\AbstractTheme->render() | JROOT/templates/g5_helium/index.php:23 |
7 | require JROOT/templates/g5_helium/index.php | JROOT/libraries/src/Document/HtmlDocument.php:668 |
6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:730 |
5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:545 |
4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1030 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:202 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:51 |
Query Time: 22.48 ms After last query: 0.13 ms Query memory: 0.089 MB Memory before query: 7.960 MB Rows returned: 5
SELECT
content.*,
user_editor.name as author_name,
user_editor_dashboard.avatar_link as author_image,
GROUP_CONCAT(tag.title SEPARATOR '|') AS tag_list
FROM
joom_content content
LEFT JOIN
joom_contentitem_tag_map tag_to_article
ON tag_to_article.content_item_id = content.id
LEFT JOIN
joom_tags tag
ON tag.id = tag_to_article.tag_id
LEFT JOIN
joom_users user_editor
ON user_editor.id = content.created_by
LEFT JOIN
joom_user_dashboard user_editor_dashboard
ON user_editor.id = user_editor_dashboard.user_id
LEFT JOIN
joom_fields_values content_fields
ON content.id = content_fields.item_id
WHERE
content.access IN (1,9)
AND (content.language = 'en-GB' OR content.language = '*' )
AND content.state = 1
AND (content_fields.`value` = 'article' OR content_fields.`value` IS NULL)
GROUP BY content.id
ORDER BY modified DESC
LIMIT 5
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | content | NULL | range | PRIMARY,idx_access,idx_checkout,idx_state,idx_catid,idx_createdby,idx_featured_catid,idx_language,idx_xreference,idx_alias | idx_language | 28 | NULL | 17 | 100.00 | Using index condition; Using where; Using temporary; Using filesort |
1 | SIMPLE | tag_to_article | NULL | index | NULL | idx_core_content_id | 4 | NULL | 667 | 100.00 | Using where; Using index; Using join buffer (Block Nested Loop) |
1 | SIMPLE | tag | NULL | eq_ref | PRIMARY | PRIMARY | 4 | baycik_diyar.tag_to_article.tag_id | 1 | 100.00 | NULL |
1 | SIMPLE | user_editor | NULL | eq_ref | PRIMARY | PRIMARY | 4 | baycik_diyar.content.created_by | 1 | 100.00 | Using where |
1 | SIMPLE | user_editor_dashboard | NULL | eq_ref | PRIMARY | PRIMARY | 4 | baycik_diyar.user_editor.id | 1 | 100.00 | NULL |
1 | SIMPLE | content_fields | NULL | ALL | idx_item_id | NO INDEX KEY COULD BE USED | NULL | NULL | 333 | 19.00 | Using where; Using join buffer (Block Nested Loop) |
Status | Duration |
---|
starting | 0.08 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.03 ms |
init | 0.05 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.09 ms |
preparing | 0.04 ms |
Creating tmp table | 0.08 ms |
Creating tmp table | 0.05 ms |
Sorting result | 0.01 ms |
executing | 0.00 ms |
Sending data | 21.06 ms |
Creating sort index | 0.52 ms |
Creating sort index | 0.13 ms |
end | 0.00 ms |
query end | 0.01 ms |
removing tmp table | 0.08 ms |
query end | 0.01 ms |
removing tmp table | 0.04 ms |
query end | 0.01 ms |
closing tables | 0.08 ms |
freeing items | 0.03 ms |
removing tmp table | 0.01 ms |
freeing items | 0.02 ms |
cleaning up | 0.01 ms |
# | Caller | File and line number |
---|
54 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1506 |
53 | JDatabaseDriver->loadAssocList() | JROOT/components/com_ilimhane/models/ItemArticle.php:227 |
52 | IlimhaneModelItemArticle::itemGetLatest() | JROOT/components/com_ilimhane/models/Item.php:236 |
51 | IlimhaneModelItem::itemGetLatest() | JROOT/components/com_ilimhane/models/Item.php:219 |
50 | IlimhaneModelItem::itemComposeLatest() | JROOT/modules/mod_ilimhane/mod_ilimhane.php:205 |
49 | include JROOT/modules/mod_ilimhane/mod_ilimhane.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
48 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
47 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:195 |
46 | Gantry\Framework\Platform->displayModule() | Same as call in the line below. |
45 | call_user_func_array() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:704 |
44 | Twig\Template->getAttribute() | JROOT/cache/gantry5/g5_helium/twig/f3/f33e020a7c995c3091226ca5bf2951dd75aa163487741287c6ac4232bb3ab724.php:43 |
43 | __TwigTemplate_fa24ad7ba18b08a067dfafc88f8f31a8672f91eab329b460a51c1786e9023d78->block_particle() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:216 |
42 | Twig\Template->displayBlock() | JROOT/cache/gantry5/g5_helium/twig/72/72fe691d71be39d50030851067d8119b7647bba7855e0d1db5389a5d2ee3b093.php:73 |
41 | __TwigTemplate_65b2adc0b8fc17c3166ffc5b2c534f81cd1ec81c50d53706d96ed2bd3d2c3700->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 |
40 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 |
39 | Twig\Template->display() | JROOT/cache/gantry5/g5_helium/twig/f3/f33e020a7c995c3091226ca5bf2951dd75aa163487741287c6ac4232bb3ab724.php:35 |
38 | __TwigTemplate_fa24ad7ba18b08a067dfafc88f8f31a8672f91eab329b460a51c1786e9023d78->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 |
37 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 |
36 | Twig\Template->display() | JROOT/cache/gantry5/g5_helium/twig/40/40a68c93f9fa61bdbf6a23e309fe06cf50b144274eb149d4c92319eba9049b3f.php:53 |
35 | __TwigTemplate_e3ac87ee957206f0e3e7a15f8428ebb8943621df7c8387192aaaad3239284aa2->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 |
34 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 |
33 | Twig\Template->display() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:434 |
32 | Twig\Template->render() | JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47 |
31 | Twig\TemplateWrapper->render() | JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384 |
30 | Twig\Environment->render() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163 |
29 | Gantry\Component\Theme\AbstractTheme->render() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:766 |
28 | Gantry\Framework\Theme->getContent() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:666 |
27 | Gantry\Framework\Theme->renderContent() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:593 |
26 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579 |
25 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579 |
24 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579 |
23 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:422 |
22 | Gantry\Framework\Theme->segments() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:702 |
21 | Twig\Template->getAttribute() | JROOT/cache/gantry5/g5_helium/twig/33/338d1ce3e48aeca3c38dcaa34b84b0db9f26e4cdc7d62420ac1e48e9522c3306.php:47 |
20 | __TwigTemplate_11b94903ac9c38de4bb2105a5066ee742973b4957d19cccc6fa09167e85a5546->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 |
19 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 |
18 | Twig\Template->display() | JROOT/cache/gantry5/g5_helium/twig/5a/5a9c061f91d7ca9e615210fa73ebddac3d62aa7de47b8be54b4a5f3517f4cab8.php:35 |
17 | __TwigTemplate_277af7fe659c06d904eb257d5eb4bd19d8ee1919fab0c34eba6f071815650844->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 |
16 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 |
15 | Twig\Template->display() | JROOT/cache/gantry5/g5_helium/twig/54/546c22eede2b41fbdf4f134b6757afffe7a54ce26a7295501abc0a81a19bdbb9.php:35 |
14 | __TwigTemplate_97f532d943bf881f0138e74af281e2606c8525f3ee65d2e711ad60e46a5eb82e->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 |
13 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 |
12 | Twig\Template->display() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:434 |
11 | Twig\Template->render() | JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47 |
10 | Twig\TemplateWrapper->render() | JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384 |
9 | Twig\Environment->render() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163 |
8 | Gantry\Component\Theme\AbstractTheme->render() | JROOT/templates/g5_helium/index.php:23 |
7 | require JROOT/templates/g5_helium/index.php | JROOT/libraries/src/Document/HtmlDocument.php:668 |
6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:730 |
5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:545 |
4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1030 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:202 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:51 |
Query Time: 3.38 ms After last query: 0.36 ms Query memory: 0.038 MB Memory before query: 8.044 MB Rows returned: 1
SELECT
category_titles.id,
category_titles.title,
category_titles.description,
count(DISTINCT content.id) as article_count
FROM
joom_content content
JOIN
joom_categories categories
ON content.catid = categories.id
JOIN
joom_categories category_titles
ON category_titles.path = SUBSTRING_INDEX(categories.path, '/', 1)
LEFT JOIN
joom_fields_values content_fields
ON content.id = content_fields.item_id
WHERE
content.access IN (1,9)
AND content.title LIKE '%'
AND (content.language = 'en-GB' OR content.language = '*' )
AND content.catid NOT IN (2,3,4,5,7,8,9,10,11,13,14,48,49)
AND content.state = 1
AND (content_fields.`value` = 'article' OR content_fields.`value` IS NULL)
GROUP BY category_titles.title
ORDER BY article_count DESC
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | content | NULL | range | idx_access,idx_state,idx_catid,idx_language | idx_language | 28 | NULL | 17 | 11.11 | Using index condition; Using where; Using temporary; Using filesort |
1 | SIMPLE | categories | NULL | eq_ref | PRIMARY | PRIMARY | 4 | baycik_diyar.content.catid | 1 | 100.00 | Using where |
1 | SIMPLE | category_titles | NULL | ref | idx_path | idx_path | 402 | func | 1 | 100.00 | Using where |
1 | SIMPLE | content_fields | NULL | ALL | idx_item_id | NO INDEX KEY COULD BE USED | NULL | NULL | 333 | 19.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 |
Opening tables | 0.02 ms |
init | 0.05 ms |
System lock | 0.01 ms |
optimizing | 0.02 ms |
statistics | 0.17 ms |
preparing | 0.04 ms |
Creating tmp table | 0.04 ms |
Creating tmp table | 0.03 ms |
Sorting result | 0.01 ms |
executing | 0.00 ms |
Sending data | 2.49 ms |
Creating sort index | 0.12 ms |
Creating sort index | 0.02 ms |
end | 0.00 ms |
query end | 0.01 ms |
removing tmp table | 0.03 ms |
query end | 0.00 ms |
removing tmp table | 0.02 ms |
query end | 0.06 ms |
removing tmp table | 0.01 ms |
query end | 0.00 ms |
closing tables | 0.03 ms |
freeing items | 0.01 ms |
removing tmp table | 0.00 ms |
freeing items | 0.02 ms |
cleaning up | 0.00 ms |
# | Caller | File and line number |
---|
53 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1506 |
52 | JDatabaseDriver->loadAssocList() | JROOT/components/com_ilimhane/models/ItemArticle.php:59 |
51 | IlimhaneModelItemArticle::itemListGetGroups() | JROOT/components/com_ilimhane/models/Item.php:155 |
50 | IlimhaneModelItem::itemListGetTotalByFilter() | JROOT/modules/mod_ilimhane/mod_ilimhane.php:233 |
49 | include JROOT/modules/mod_ilimhane/mod_ilimhane.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
48 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
47 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:195 |
46 | Gantry\Framework\Platform->displayModule() | Same as call in the line below. |
45 | call_user_func_array() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:704 |
44 | Twig\Template->getAttribute() | JROOT/cache/gantry5/g5_helium/twig/f3/f33e020a7c995c3091226ca5bf2951dd75aa163487741287c6ac4232bb3ab724.php:43 |
43 | __TwigTemplate_fa24ad7ba18b08a067dfafc88f8f31a8672f91eab329b460a51c1786e9023d78->block_particle() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:216 |
42 | Twig\Template->displayBlock() | JROOT/cache/gantry5/g5_helium/twig/72/72fe691d71be39d50030851067d8119b7647bba7855e0d1db5389a5d2ee3b093.php:73 |
41 | __TwigTemplate_65b2adc0b8fc17c3166ffc5b2c534f81cd1ec81c50d53706d96ed2bd3d2c3700->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 |
40 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 |
39 | Twig\Template->display() | JROOT/cache/gantry5/g5_helium/twig/f3/f33e020a7c995c3091226ca5bf2951dd75aa163487741287c6ac4232bb3ab724.php:35 |
38 | __TwigTemplate_fa24ad7ba18b08a067dfafc88f8f31a8672f91eab329b460a51c1786e9023d78->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 |
37 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 |
36 | Twig\Template->display() | JROOT/cache/gantry5/g5_helium/twig/40/40a68c93f9fa61bdbf6a23e309fe06cf50b144274eb149d4c92319eba9049b3f.php:53 |
35 | __TwigTemplate_e3ac87ee957206f0e3e7a15f8428ebb8943621df7c8387192aaaad3239284aa2->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 |
34 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 |
33 | Twig\Template->display() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:434 |
32 | Twig\Template->render() | JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47 |
31 | Twig\TemplateWrapper->render() | JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384 |
30 | Twig\Environment->render() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163 |
29 | Gantry\Component\Theme\AbstractTheme->render() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:766 |
28 | Gantry\Framework\Theme->getContent() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:666 |
27 | Gantry\Framework\Theme->renderContent() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:593 |
26 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579 |
25 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579 |
24 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579 |
23 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:422 |
22 | Gantry\Framework\Theme->segments() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:702 |
21 | Twig\Template->getAttribute() | JROOT/cache/gantry5/g5_helium/twig/33/338d1ce3e48aeca3c38dcaa34b84b0db9f26e4cdc7d62420ac1e48e9522c3306.php:47 |
20 | __TwigTemplate_11b94903ac9c38de4bb2105a5066ee742973b4957d19cccc6fa09167e85a5546->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 |
19 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 |
18 | Twig\Template->display() | JROOT/cache/gantry5/g5_helium/twig/5a/5a9c061f91d7ca9e615210fa73ebddac3d62aa7de47b8be54b4a5f3517f4cab8.php:35 |
17 | __TwigTemplate_277af7fe659c06d904eb257d5eb4bd19d8ee1919fab0c34eba6f071815650844->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 |
16 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 |
15 | Twig\Template->display() | JROOT/cache/gantry5/g5_helium/twig/54/546c22eede2b41fbdf4f134b6757afffe7a54ce26a7295501abc0a81a19bdbb9.php:35 |
14 | __TwigTemplate_97f532d943bf881f0138e74af281e2606c8525f3ee65d2e711ad60e46a5eb82e->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 |
13 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 |
12 | Twig\Template->display() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:434 |
11 | Twig\Template->render() | JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47 |
10 | Twig\TemplateWrapper->render() | JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384 |
9 | Twig\Environment->render() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163 |
8 | Gantry\Component\Theme\AbstractTheme->render() | JROOT/templates/g5_helium/index.php:23 |
7 | require JROOT/templates/g5_helium/index.php | JROOT/libraries/src/Document/HtmlDocument.php:668 |
6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:730 |
5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:545 |
4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1030 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:202 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:51 |
Query Time: 0.51 ms After last query: 0.07 ms Query memory: 0.038 MB Memory before query: 8.065 MB Rows returned: 0
SELECT
*
FROM
joom_content_missed_links
WHERE target_article_id IS NULL
GROUP BY title
ORDER BY date_created DESC
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | joom_content_missed_links | NULL | index | title | title | 738 | NULL | 1 | 100.00 | Using where; Using temporary; Using filesort |
Status | Duration |
---|
starting | 0.03 ms |
checking permissions | 0.00 ms |
Opening tables | 0.23 ms |
init | 0.02 ms |
System lock | 0.02 ms |
optimizing | 0.00 ms |
statistics | 0.02 ms |
preparing | 0.01 ms |
Creating tmp table | 0.02 ms |
Sorting for group | 0.00 ms |
Sorting result | 0.00 ms |
executing | 0.00 ms |
Sending data | 0.02 ms |
Creating sort index | 0.01 ms |
end | 0.00 ms |
query end | 0.01 ms |
removing tmp table | 0.00 ms |
query end | 0.00 ms |
closing tables | 0.02 ms |
freeing items | 0.02 ms |
cleaning up | 0.00 ms |
# | Caller | File and line number |
---|
53 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1506 |
52 | JDatabaseDriver->loadAssocList() | JROOT/components/com_ilimhane/models/Item.php:367 |
51 | IlimhaneModelItem::missedLinksGet() | JROOT/components/com_ilimhane/models/Item.php:349 |
50 | IlimhaneModelItem::missedLinksCompose() | JROOT/modules/mod_ilimhane/mod_ilimhane.php:234 |
49 | include JROOT/modules/mod_ilimhane/mod_ilimhane.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
48 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
47 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:195 |
46 | Gantry\Framework\Platform->displayModule() | Same as call in the line below. |
45 | call_user_func_array() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:704 |
44 | Twig\Template->getAttribute() | JROOT/cache/gantry5/g5_helium/twig/f3/f33e020a7c995c3091226ca5bf2951dd75aa163487741287c6ac4232bb3ab724.php:43 |
43 | __TwigTemplate_fa24ad7ba18b08a067dfafc88f8f31a8672f91eab329b460a51c1786e9023d78->block_particle() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:216 |
42 | Twig\Template->displayBlock() | JROOT/cache/gantry5/g5_helium/twig/72/72fe691d71be39d50030851067d8119b7647bba7855e0d1db5389a5d2ee3b093.php:73 |
41 | __TwigTemplate_65b2adc0b8fc17c3166ffc5b2c534f81cd1ec81c50d53706d96ed2bd3d2c3700->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 |
40 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 |
39 | Twig\Template->display() | JROOT/cache/gantry5/g5_helium/twig/f3/f33e020a7c995c3091226ca5bf2951dd75aa163487741287c6ac4232bb3ab724.php:35 |
38 | __TwigTemplate_fa24ad7ba18b08a067dfafc88f8f31a8672f91eab329b460a51c1786e9023d78->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 |
37 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 |
36 | Twig\Template->display() | JROOT/cache/gantry5/g5_helium/twig/40/40a68c93f9fa61bdbf6a23e309fe06cf50b144274eb149d4c92319eba9049b3f.php:53 |
35 | __TwigTemplate_e3ac87ee957206f0e3e7a15f8428ebb8943621df7c8387192aaaad3239284aa2->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 |
34 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 |
33 | Twig\Template->display() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:434 |
32 | Twig\Template->render() | JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47 |
31 | Twig\TemplateWrapper->render() | JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384 |
30 | Twig\Environment->render() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163 |
29 | Gantry\Component\Theme\AbstractTheme->render() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:766 |
28 | Gantry\Framework\Theme->getContent() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:666 |
27 | Gantry\Framework\Theme->renderContent() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:593 |
26 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579 |
25 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579 |
24 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579 |
23 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:422 |
22 | Gantry\Framework\Theme->segments() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:702 |
21 | Twig\Template->getAttribute() | JROOT/cache/gantry5/g5_helium/twig/33/338d1ce3e48aeca3c38dcaa34b84b0db9f26e4cdc7d62420ac1e48e9522c3306.php:47 |
20 | __TwigTemplate_11b94903ac9c38de4bb2105a5066ee742973b4957d19cccc6fa09167e85a5546->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 |
19 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 |
18 | Twig\Template->display() | JROOT/cache/gantry5/g5_helium/twig/5a/5a9c061f91d7ca9e615210fa73ebddac3d62aa7de47b8be54b4a5f3517f4cab8.php:35 |
17 | __TwigTemplate_277af7fe659c06d904eb257d5eb4bd19d8ee1919fab0c34eba6f071815650844->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 |
16 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 |
15 | Twig\Template->display() | JROOT/cache/gantry5/g5_helium/twig/54/546c22eede2b41fbdf4f134b6757afffe7a54ce26a7295501abc0a81a19bdbb9.php:35 |
14 | __TwigTemplate_97f532d943bf881f0138e74af281e2606c8525f3ee65d2e711ad60e46a5eb82e->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 |
13 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 |
12 | Twig\Template->display() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:434 |
11 | Twig\Template->render() | JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47 |
10 | Twig\TemplateWrapper->render() | JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384 |
9 | Twig\Environment->render() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163 |
8 | Gantry\Component\Theme\AbstractTheme->render() | JROOT/templates/g5_helium/index.php:23 |
7 | require JROOT/templates/g5_helium/index.php | JROOT/libraries/src/Document/HtmlDocument.php:668 |
6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:730 |
5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:545 |
4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1030 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:202 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:51 |
Query Time: 0.43 ms After last query: 2.54 ms Query memory: 0.038 MB Memory before query: 8.082 MB Rows returned: 0
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.08 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.04 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.03 ms |
optimizing | 0.01 ms |
statistics | 0.03 ms |
preparing | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.02 ms |
preparing | 0.01 ms |
executing | 0.01 ms |
end | 0.00 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.02 ms |
cleaning up | 0.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.38 ms After last query: 0.08 ms Query memory: 0.038 MB Memory before query: 8.109 MB Rows returned: 1
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)t
id | 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.22 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.01 ms |
Opening tables | 0.04 ms |
init | 0.14 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
optimizing | 0.04 ms |
statistics | 0.24 ms |
preparing | 0.04 ms |
Creating tmp table | 0.02 ms |
Sorting result | 0.01 ms |
optimizing | 0.03 ms |
statistics | 0.15 ms |
preparing | 0.03 ms |
statistics | 0.01 ms |
preparing | 0.01 ms |
executing | 0.01 ms |
Sending data | 0.01 ms |
executing | 0.00 ms |
Sending data | 1.08 ms |
Creating sort index | 0.04 ms |
end | 0.00 ms |
query end | 0.01 ms |
removing tmp table | 0.01 ms |
query end | 0.00 ms |
closing tables | 0.00 ms |
removing tmp table | 0.06 ms |
closing tables | 0.04 ms |
freeing items | 0.03 ms |
cleaning up | 0.01 ms |
# | Caller | File and line number |
---|
53 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1465 |
52 | JDatabaseDriver->loadAssoc() | JROOT/components/com_education/models/ExerciseStatistic.php:293 |
51 | EducationModelExerciseStatistic::userStatisticGetByFilter() | JROOT/components/com_user_dashboard/models/Dashboard.php:19 |
50 | UserDashboardModelDashboard::userCompose() | JROOT/modules/mod_user_dashboard_mini/mod_user_dashboard_mini.php:22 |
49 | include JROOT/modules/mod_user_dashboard_mini/mod_user_dashboard_mini.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
48 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
47 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:195 |
46 | Gantry\Framework\Platform->displayModule() | Same as call in the line below. |
45 | call_user_func_array() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:704 |
44 | Twig\Template->getAttribute() | JROOT/cache/gantry5/g5_helium/twig/f3/f33e020a7c995c3091226ca5bf2951dd75aa163487741287c6ac4232bb3ab724.php:43 |
43 | __TwigTemplate_fa24ad7ba18b08a067dfafc88f8f31a8672f91eab329b460a51c1786e9023d78->block_particle() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:216 |
42 | Twig\Template->displayBlock() | JROOT/cache/gantry5/g5_helium/twig/72/72fe691d71be39d50030851067d8119b7647bba7855e0d1db5389a5d2ee3b093.php:73 |
41 | __TwigTemplate_65b2adc0b8fc17c3166ffc5b2c534f81cd1ec81c50d53706d96ed2bd3d2c3700->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 |
40 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 |
39 | Twig\Template->display() | JROOT/cache/gantry5/g5_helium/twig/f3/f33e020a7c995c3091226ca5bf2951dd75aa163487741287c6ac4232bb3ab724.php:35 |
38 | __TwigTemplate_fa24ad7ba18b08a067dfafc88f8f31a8672f91eab329b460a51c1786e9023d78->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 |
37 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 |
36 | Twig\Template->display() | JROOT/cache/gantry5/g5_helium/twig/40/40a68c93f9fa61bdbf6a23e309fe06cf50b144274eb149d4c92319eba9049b3f.php:53 |
35 | __TwigTemplate_e3ac87ee957206f0e3e7a15f8428ebb8943621df7c8387192aaaad3239284aa2->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 |
34 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 |
33 | Twig\Template->display() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:434 |
32 | Twig\Template->render() | JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47 |
31 | Twig\TemplateWrapper->render() | JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384 |
30 | Twig\Environment->render() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163 |
29 | Gantry\Component\Theme\AbstractTheme->render() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:766 |
28 | Gantry\Framework\Theme->getContent() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:666 |
27 | Gantry\Framework\Theme->renderContent() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:593 |
26 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579 |
25 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579 |
24 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579 |
23 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:422 |
22 | Gantry\Framework\Theme->segments() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:702 |
21 | Twig\Template->getAttribute() | JROOT/cache/gantry5/g5_helium/twig/33/338d1ce3e48aeca3c38dcaa34b84b0db9f26e4cdc7d62420ac1e48e9522c3306.php:47 |
20 | __TwigTemplate_11b94903ac9c38de4bb2105a5066ee742973b4957d19cccc6fa09167e85a5546->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 |
19 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 |
18 | Twig\Template->display() | JROOT/cache/gantry5/g5_helium/twig/5a/5a9c061f91d7ca9e615210fa73ebddac3d62aa7de47b8be54b4a5f3517f4cab8.php:35 |
17 | __TwigTemplate_277af7fe659c06d904eb257d5eb4bd19d8ee1919fab0c34eba6f071815650844->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 |
16 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 |
15 | Twig\Template->display() | JROOT/cache/gantry5/g5_helium/twig/54/546c22eede2b41fbdf4f134b6757afffe7a54ce26a7295501abc0a81a19bdbb9.php:35 |
14 | __TwigTemplate_97f532d943bf881f0138e74af281e2606c8525f3ee65d2e711ad60e46a5eb82e->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 |
13 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 |
12 | Twig\Template->display() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:434 |
11 | Twig\Template->render() | JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47 |
10 | Twig\TemplateWrapper->render() | JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384 |
9 | Twig\Environment->render() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163 |
8 | Gantry\Component\Theme\AbstractTheme->render() | JROOT/templates/g5_helium/index.php:23 |
7 | require JROOT/templates/g5_helium/index.php | JROOT/libraries/src/Document/HtmlDocument.php:668 |
6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:730 |
5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:545 |
4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1030 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:202 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:51 |
Query Time: 3.42 ms After last query: 0.07 ms Query memory: 0.038 MB Memory before query: 8.131 MB Rows returned: 0
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 ASC
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | PRIMARY | menu | NULL | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 150 | 2.00 | Using where; Using filesort |
1 | PRIMARY | <derived2> | NULL | ref | <auto_key0> | <auto_key0> | 4 | baycik_diyar.menu.parent_id | 6 | 100.00 | Using where |
2 | DERIVED | assoc1 | NULL | ref | PRIMARY,idx_key | PRIMARY | 202 | const | 86 | 100.00 | Using temporary |
2 | DERIVED | parent_menu | NULL | eq_ref | PRIMARY,idx_alias,idx_language | PRIMARY | 4 | baycik_diyar.assoc1.id | 1 | 36.00 | Using where |
2 | DERIVED | assoc2 | NULL | ref | PRIMARY,idx_key | idx_key | 330 | baycik_diyar.assoc1.key,const | 2 | 100.00 | Using index; Distinct |
2 | DERIVED | parent_menu_assoc | NULL | eq_ref | PRIMARY,idx_alias | PRIMARY | 4 | baycik_diyar.assoc2.id | 1 | 100.00 | Using where; Distinct |
Status | Duration |
---|
starting | 0.07 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
Opening tables | 0.02 ms |
init | 0.11 ms |
System lock | 0.01 ms |
optimizing | 0.00 ms |
optimizing | 0.01 ms |
statistics | 0.15 ms |
preparing | 0.02 ms |
Creating tmp table | 0.05 ms |
statistics | 0.03 ms |
preparing | 0.01 ms |
Sorting result | 0.00 ms |
executing | 0.18 ms |
Sending data | 0.02 ms |
Creating sort index | 0.17 ms |
executing | 0.00 ms |
Sending data | 2.27 ms |
end | 0.01 ms |
query end | 0.01 ms |
removing tmp table | 0.09 ms |
query end | 0.01 ms |
closing tables | 0.00 ms |
removing tmp table | 0.05 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: 1.96 ms After last query: 10.66 ms Query memory: 0.027 MB Memory before query: 8.649 MB Rows returned: 29
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-12-11 16:36:11')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-12-11 16:36:11')
AND m.access IN (1,1,5)
AND m.client_id = 0
AND (mm.menuid = 227 OR mm.menuid <= 0)
AND m.language IN ('en-GB','*')
ORDER BY m.position, m.ordering
id | 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.19 ms |
checking permissions | 0.01 ms |
checking permissions | 0.00 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.10 ms |
System lock | 0.01 ms |
optimizing | 0.04 ms |
statistics | 0.20 ms |
preparing | 0.05 ms |
Sorting result | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.02 ms |
Creating sort index | 1.02 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.07 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:1701 |
13 | JDatabaseDriver->loadObjectList() | Same as call in the line below. |
12 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
11 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/ModuleHelper.php:432 |
10 | Joomla\CMS\Helper\ModuleHelper::getModuleList() | JROOT/libraries/src/Helper/ModuleHelper.php:362 |
9 | Joomla\CMS\Helper\ModuleHelper::load() | JROOT/libraries/src/Helper/ModuleHelper.php:87 |
8 | Joomla\CMS\Helper\ModuleHelper::getModules() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:45 |
7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:501 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:793 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:567 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1044 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:202 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:51 |
2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `joom_extensions`
2 × SELECT DISTINCT tags.title, REPLACE(JSON_EXTRACT(tags.params,'$.tag_link_class'), '"','') as tag_link_class
FROM joom_content content JOIN joom_fields_values content_fields
ON content.id = content_fields.item_id JOIN joom_contentitem_tag_map tag_to_article
ON tag_to_article.content_item_id = content.id JOIN joom_tags tags
ON tags.id = tag_to_article.tag_id
2 × SELECT category_titles.id, category_titles.title, category_titles.description, count(DISTINCT content.id) as article_count
FROM joom_content content JOIN joom_categories categories
ON content.catid = categories.id JOIN joom_categories category_titles
ON category_titles.path = SUBSTRING_INDEX(categories.path, '/', 1)
LEFT JOIN joom_fields_values content_fields
ON content.id = content_fields.item_id
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.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.id
2 × 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
2 × 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
1 × SELECT `session_id`
FROM `joom_session`
1 × SELECT content.*, user_editor.name as author_name, user_editor_dashboard.avatar_link as author_image, GROUP_CONCAT(tag.title SEPARATOR '|') AS tag_list
FROM joom_content content
LEFT JOIN joom_contentitem_tag_map tag_to_article
ON tag_to_article.content_item_id = content.id
LEFT JOIN joom_tags tag
ON tag.id = tag_to_article.tag_id
LEFT JOIN joom_users user_editor
ON user_editor.id = content.created_by
LEFT JOIN joom_user_dashboard user_editor_dashboard
ON user_editor.id = user_editor_dashboard.user_id
LEFT JOIN joom_fields_values content_fields
ON content.id = content_fields.item_id
1 × SELECT categories.id, COUNT(users.id) AS users_count, users.name
FROM joom_content content JOIN joom_categories categories
ON content.catid = categories.id JOIN joom_categories category_titles
ON category_titles.path = SUBSTRING_INDEX(categories.path, '/', 1)
LEFT JOIN joom_users users
ON users.id = content.created_by
1 × SELECT categories.id, COUNT(tag.id) AS tag_count, tag.title, REPLACE(JSON_EXTRACT(tag.params,'$.tag_link_class'), '"','') as tag_link_class
FROM joom_content content JOIN joom_categories categories
ON content.catid = categories.id JOIN joom_categories category_titles
ON category_titles.path = SUBSTRING_INDEX(categories.path, '/', 1)
LEFT JOIN joom_contentitem_tag_map tag_to_article
ON tag_to_article.content_item_id = content.id
LEFT JOIN joom_tags tag
ON tag.id = tag_to_article.tag_id
1 × SELECT content.id, content.title, content.alias, content.introtext, content.fulltext, content.state, COALESCE(category.title) as parent_title, COALESCE(category.id) as parent_id, content.images, content.created, author.name as creator_name, author_dashboard.avatar_link as creator_image, content.modified, content.access, content.hits, content.language, content.checked_out, content_fields.value as item_type
FROM joom_content content
LEFT JOIN joom_categories category
ON content.catid = category.id
LEFT JOIN joom_contentitem_tag_map tag_to_article
ON tag_to_article.content_item_id = content.id
LEFT JOIN joom_content_authors content_authors
ON content_authors.tag_id = tag_to_article.tag_id
LEFT JOIN joom_users author
ON author.id = content.created_by
LEFT JOIN joom_user_dashboard author_dashboard
ON author.id = author_dashboard.user_id
LEFT JOIN joom_tags tag
ON tag.id = tag_to_article.tag_id
LEFT JOIN joom_fields_values content_fields
ON content.id = content_fields.item_id
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 `id`,`name`,`rules`,`parent_id`
FROM `joom_assets`
1 × SELECT a.menutype
FROM joom_menu_types AS a
1 × SELECT s.id, s.template, s.home, s.title AS long_title, s.params
FROM joom_template_styles AS s
1 × 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
1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM joom_menu AS m
LEFT JOIN joom_extensions AS e
ON m.component_id = e.extension_id
1 × SELECT `element`,`name`,`client_id`,`extension_id`
FROM `joom_extensions`
1 × SELECT *
FROM joom_languages
1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM joom_extensions
1 × SELECT b.id
FROM joom_usergroups AS a
LEFT JOIN joom_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
1 × SELECT id, rules
FROM `joom_viewlevels
1 × SELECT *
FROM joom_content_missed_links