Query Time: 0.67 ms Query memory: 0.023 MB Memory before query: 1.017 MB Rows returned: 0
SELECT `data`
FROM `joom_session`
WHERE `session_id` = X'6164373561613434646365313731623336313763656461303333623061353932'
| 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 | NULL |
| Status | Duration |
|---|
| starting | 0.09 ms |
| Executing hook on transaction | 0.02 ms |
| starting | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.11 ms |
| init | 0.02 ms |
| System lock | 0.03 ms |
| optimizing | 0.01 ms |
| statistics | 0.16 ms |
| executing | 0.02 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| waiting for handler commit | 0.01 ms |
| closing tables | 0.02 ms |
| freeing items | 0.52 ms |
| cleaning up | 0.03 ms |
| # | Caller | File and line number |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
| 15 | JDatabaseDriver->loadResult() | JROOT/libraries/joomla/session/storage/database.php:45 |
| 14 | JSessionStorageDatabase->read() | Same as call in the line below. |
| 13 | session_start() | JROOT/libraries/joomla/session/handler/native.php:260 |
| 12 | JSessionHandlerNative->doSessionStart() | JROOT/libraries/joomla/session/handler/native.php:50 |
| 11 | JSessionHandlerNative->start() | JROOT/libraries/joomla/session/handler/joomla.php:88 |
| 10 | JSessionHandlerJoomla->start() | JROOT/libraries/src/Session/Session.php:661 |
| 9 | Joomla\CMS\Session\Session->_start() | JROOT/libraries/src/Session/Session.php:621 |
| 8 | Joomla\CMS\Session\Session->start() | JROOT/libraries/src/Session/Session.php:499 |
| 7 | Joomla\CMS\Session\Session->get() | JROOT/libraries/src/Session/Session.php:456 |
| 6 | Joomla\CMS\Session\Session->isNew() | JROOT/libraries/src/Application/CMSApplication.php:826 |
| 5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:136 |
| 4 | Joomla\CMS\Application\CMSApplication->__construct() | JROOT/libraries/src/Application/SiteApplication.php:66 |
| 3 | Joomla\CMS\Application\SiteApplication->__construct() | JROOT/libraries/src/Application/CMSApplication.php:386 |
| 2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 |
| 1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:51 |
Query Time: 0.46 ms After last query: 0.40 ms Query memory: 0.020 MB Memory before query: 1.031 MB Rows returned: 0
SELECT `session_id`
FROM `joom_session`
WHERE `session_id` = X'6164373561613434646365313731623336313763656461303333623061353932'
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.04 ms |
| Executing hook on transaction | 0.01 ms |
| starting | 0.01 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.02 ms |
| init | 0.03 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.07 ms |
| executing | 0.06 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| waiting for handler commit | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.21 ms |
| cleaning up | 0.03 ms |
| # | Caller | File and line number |
|---|
| 9 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
| 8 | JDatabaseDriver->loadResult() | JROOT/libraries/src/Session/MetadataManager.php:74 |
| 7 | Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() | JROOT/libraries/src/Application/CMSApplication.php:154 |
| 6 | Joomla\CMS\Application\CMSApplication->checkSession() | JROOT/libraries/src/Application/CMSApplication.php:828 |
| 5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:136 |
| 4 | Joomla\CMS\Application\CMSApplication->__construct() | JROOT/libraries/src/Application/SiteApplication.php:66 |
| 3 | Joomla\CMS\Application\SiteApplication->__construct() | JROOT/libraries/src/Application/CMSApplication.php:386 |
| 2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 |
| 1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:51 |
Query Time: 7.86 ms After last query: 0.09 ms Query memory: 0.004 MB Memory before query: 1.036 MB
INSERT INTO `joom_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES
(X'6164373561613434646365313731623336313763656461303333623061353932', 1, 1781039800, 0, '', 0)
EXPLAIN not possible on query: INSERT INTO `joom_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES
(X'6164373561613434646365313731623336313763656461303333623061353932', 1, 1781039800, 0, '', 0)
| Status | Duration |
|---|
| starting | 0.06 ms |
| Executing hook on transaction | 0.01 ms |
| starting | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.05 ms |
| init | 0.01 ms |
| System lock | 0.02 ms |
| update | 0.51 ms |
| end | 0.02 ms |
| query end | 0.01 ms |
| waiting for handler commit | 6.94 ms |
| closing tables | 0.03 ms |
| freeing items | 0.52 ms |
| cleaning up | 0.04 ms |
| # | Caller | File and line number |
|---|
| 8 | JDatabaseDriverMysqli->execute() | JROOT/libraries/src/Session/MetadataManager.php:116 |
| 7 | Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() | JROOT/libraries/src/Application/CMSApplication.php:154 |
| 6 | Joomla\CMS\Application\CMSApplication->checkSession() | JROOT/libraries/src/Application/CMSApplication.php:828 |
| 5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:136 |
| 4 | Joomla\CMS\Application\CMSApplication->__construct() | JROOT/libraries/src/Application/SiteApplication.php:66 |
| 3 | Joomla\CMS\Application\SiteApplication->__construct() | JROOT/libraries/src/Application/CMSApplication.php:386 |
| 2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 |
| 1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:51 |
Query Time: 0.86 ms After last query: 0.35 ms Query memory: 0.017 MB Memory before query: 1.042 MB Rows returned: 1
SELECT id, published
FROM `joom_menu`
WHERE `path` = 'get-russian-visa/russian-visa-invitation/business-visa-invitation-for-foreigners'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | joom_menu | NULL | ref | idx_path | idx_path | 402 | const | 1 | 100.00 | Using where |
| Status | Duration |
|---|
| starting | 0.11 ms |
| Executing hook on transaction | 0.01 ms |
| starting | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.12 ms |
| init | 0.02 ms |
| System lock | 0.02 ms |
| optimizing | 0.02 ms |
| statistics | 0.17 ms |
| preparing | 0.09 ms |
| executing | 0.08 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| waiting for handler commit | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 2.35 ms |
| cleaning up | 0.05 ms |
| # | Caller | File and line number |
|---|
| 2 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 1 | JDatabaseDriver->loadObjectList() | JROOT/index.php:66 |
Query Time: 1.32 ms After last query: 13.32 ms Query memory: 0.024 MB Memory before query: 2.185 MB Rows returned: 37
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 | 41 | 1.00 | Using where |
| Status | Duration |
|---|
| starting | 0.15 ms |
| Executing hook on transaction | 0.01 ms |
| starting | 0.02 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.11 ms |
| init | 0.02 ms |
| System lock | 0.02 ms |
| optimizing | 0.02 ms |
| statistics | 0.14 ms |
| preparing | 0.04 ms |
| executing | 0.34 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| waiting for handler commit | 0.02 ms |
| closing tables | 0.02 ms |
| freeing items | 0.10 ms |
| cleaning up | 0.03 ms |
| # | Caller | File and line number |
|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 11 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Component/ComponentHelper.php:445 |
| 10 | Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}() | Same as call in the line below. |
| 9 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 8 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Component/ComponentHelper.php:453 |
| 7 | Joomla\CMS\Component\ComponentHelper::load() | JROOT/libraries/src/Component/ComponentHelper.php:519 |
| 6 | Joomla\CMS\Component\ComponentHelper::getComponents() | JROOT/libraries/src/Component/ComponentHelper.php:44 |
| 5 | Joomla\CMS\Component\ComponentHelper::getComponent() | JROOT/libraries/src/Component/ComponentHelper.php:103 |
| 4 | Joomla\CMS\Component\ComponentHelper::getParams() | JROOT/libraries/src/Application/SiteApplication.php:594 |
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:90 |
Query Time: 0.82 ms After last query: 0.71 ms Query memory: 0.021 MB Memory before query: 2.212 MB Rows returned: 6
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 | 6 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.07 ms |
| Executing hook on transaction | 0.01 ms |
| starting | 0.01 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.06 ms |
| init | 0.01 ms |
| System lock | 0.02 ms |
| optimizing | 0.01 ms |
| statistics | 0.02 ms |
| preparing | 0.02 ms |
| executing | 0.21 ms |
| end | 0.01 ms |
| query end | 0.00 ms |
| waiting for handler commit | 0.02 ms |
| closing tables | 0.18 ms |
| freeing items | 0.05 ms |
| cleaning up | 0.04 ms |
| # | Caller | File and line number |
|---|
| 10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1506 |
| 9 | JDatabaseDriver->loadAssocList() | JROOT/libraries/src/Access/Access.php:1063 |
| 8 | Joomla\CMS\Access\Access::getAuthorisedViewLevels() | JROOT/libraries/src/User/User.php:458 |
| 7 | Joomla\CMS\User\User->getAuthorisedViewLevels() | JROOT/libraries/src/Plugin/PluginHelper.php:318 |
| 6 | Joomla\CMS\Plugin\PluginHelper::load() | JROOT/libraries/src/Plugin/PluginHelper.php:87 |
| 5 | Joomla\CMS\Plugin\PluginHelper::getPlugin() | JROOT/libraries/src/Plugin/PluginHelper.php:129 |
| 4 | Joomla\CMS\Plugin\PluginHelper::isEnabled() | JROOT/libraries/src/Application/SiteApplication.php:604 |
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:90 |
Query Time: 1.05 ms After last query: 0.12 ms Query memory: 0.021 MB Memory before query: 2.224 MB Rows returned: 3
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 = 7
| 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 | 4 | 100.00 | Using where; Using index |
| Status | Duration |
|---|
| starting | 0.11 ms |
| Executing hook on transaction | 0.01 ms |
| starting | 0.01 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.09 ms |
| init | 0.01 ms |
| System lock | 0.02 ms |
| optimizing | 0.01 ms |
| statistics | 0.11 ms |
| preparing | 0.07 ms |
| executing | 0.31 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| waiting for handler commit | 0.01 ms |
| closing tables | 0.02 ms |
| freeing items | 0.05 ms |
| cleaning up | 0.02 ms |
| # | Caller | File and line number |
|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1550 |
| 10 | JDatabaseDriver->loadColumn() | JROOT/libraries/src/Access/Access.php:980 |
| 9 | Joomla\CMS\Access\Access::getGroupsByUser() | JROOT/libraries/src/Access/Access.php:1095 |
| 8 | Joomla\CMS\Access\Access::getAuthorisedViewLevels() | JROOT/libraries/src/User/User.php:458 |
| 7 | Joomla\CMS\User\User->getAuthorisedViewLevels() | JROOT/libraries/src/Plugin/PluginHelper.php:318 |
| 6 | Joomla\CMS\Plugin\PluginHelper::load() | JROOT/libraries/src/Plugin/PluginHelper.php:87 |
| 5 | Joomla\CMS\Plugin\PluginHelper::getPlugin() | JROOT/libraries/src/Plugin/PluginHelper.php:129 |
| 4 | Joomla\CMS\Plugin\PluginHelper::isEnabled() | JROOT/libraries/src/Application/SiteApplication.php:604 |
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:90 |
Query Time: 2.42 ms After last query: 0.24 ms Query memory: 0.026 MB Memory before query: 2.245 MB Rows returned: 58
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,2,3)
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 | 122 | 0.80 | Using where; Using filesort |
| Status | Duration |
|---|
| starting | 0.09 ms |
| Executing hook on transaction | 0.01 ms |
| starting | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.04 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.02 ms |
| statistics | 0.08 ms |
| preparing | 0.18 ms |
| executing | 0.64 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| waiting for handler commit | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.15 ms |
| cleaning up | 0.03 ms |
| # | Caller | File and line number |
|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 10 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Plugin/PluginHelper.php:351 |
| 9 | Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}() | Same as call in the line below. |
| 8 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 7 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Plugin/PluginHelper.php:356 |
| 6 | Joomla\CMS\Plugin\PluginHelper::load() | JROOT/libraries/src/Plugin/PluginHelper.php:87 |
| 5 | Joomla\CMS\Plugin\PluginHelper::getPlugin() | JROOT/libraries/src/Plugin/PluginHelper.php:129 |
| 4 | Joomla\CMS\Plugin\PluginHelper::isEnabled() | JROOT/libraries/src/Application/SiteApplication.php:604 |
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:90 |
Query Time: 1.04 ms After last query: 11.93 ms Query memory: 0.023 MB Memory before query: 2.688 MB Rows returned: 8
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 | 8 | 12.50 | Using where; Using filesort |
| Status | Duration |
|---|
| starting | 0.11 ms |
| Executing hook on transaction | 0.01 ms |
| starting | 0.02 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.10 ms |
| init | 0.01 ms |
| System lock | 0.02 ms |
| optimizing | 0.02 ms |
| statistics | 0.06 ms |
| preparing | 0.04 ms |
| executing | 0.17 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| waiting for handler commit | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.14 ms |
| cleaning up | 0.03 ms |
| # | Caller | File and line number |
|---|
| 10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 9 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Language/LanguageHelper.php:150 |
| 8 | Joomla\CMS\Language\LanguageHelper::getLanguages() | JROOT/plugins/system/languagefilter/languagefilter.php:96 |
| 7 | PlgSystemLanguageFilter->__construct() | JROOT/libraries/src/Plugin/PluginHelper.php:280 |
| 6 | Joomla\CMS\Plugin\PluginHelper::import() | JROOT/libraries/src/Plugin/PluginHelper.php:182 |
| 5 | Joomla\CMS\Plugin\PluginHelper::importPlugin() | JROOT/libraries/src/Application/CMSApplication.php:667 |
| 4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:90 |
Query Time: 0.53 ms After last query: 0.16 ms Query memory: 0.022 MB Memory before query: 2.702 MB Rows returned: 16
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 | 16 | 1.00 | Using where |
| Status | Duration |
|---|
| starting | 0.06 ms |
| Executing hook on transaction | 0.01 ms |
| starting | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.03 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.02 ms |
| statistics | 0.07 ms |
| preparing | 0.02 ms |
| executing | 0.09 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| waiting for handler commit | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.05 ms |
| cleaning up | 0.02 ms |
| # | Caller | File and line number |
|---|
| 10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 9 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Language/LanguageHelper.php:209 |
| 8 | Joomla\CMS\Language\LanguageHelper::getInstalledLanguages() | JROOT/plugins/system/languagefilter/languagefilter.php:110 |
| 7 | PlgSystemLanguageFilter->__construct() | JROOT/libraries/src/Plugin/PluginHelper.php:280 |
| 6 | Joomla\CMS\Plugin\PluginHelper::import() | JROOT/libraries/src/Plugin/PluginHelper.php:182 |
| 5 | Joomla\CMS\Plugin\PluginHelper::importPlugin() | JROOT/libraries/src/Application/CMSApplication.php:667 |
| 4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:90 |
Query Time: 15.10 ms After last query: 6.15 ms Query memory: 0.951 MB Memory before query: 2.802 MB Rows returned: 613
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 | 771 | 10.00 | Using where; Using filesort |
| 1 | SIMPLE | e | NULL | eq_ref | PRIMARY | PRIMARY | 4 | goingrus_joomla.m.component_id | 1 | 100.00 | Using where |
| Status | Duration |
|---|
| starting | 0.17 ms |
| Executing hook on transaction | 0.01 ms |
| starting | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.19 ms |
| init | 0.02 ms |
| System lock | 0.01 ms |
| optimizing | 0.05 ms |
| statistics | 0.15 ms |
| preparing | 0.05 ms |
| executing | 10.87 ms |
| end | 0.03 ms |
| query end | 0.01 ms |
| waiting for handler commit | 0.02 ms |
| closing tables | 0.02 ms |
| freeing items | 0.09 ms |
| cleaning up | 0.04 ms |
| # | Caller | File and line number |
|---|
| 23 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 22 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Menu/SiteMenu.php:93 |
| 21 | Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}() | Same as call in the line below. |
| 20 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 19 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Menu/SiteMenu.php:101 |
| 18 | Joomla\CMS\Menu\SiteMenu->load() | JROOT/libraries/src/Menu/AbstractMenu.php:78 |
| 17 | Joomla\CMS\Menu\AbstractMenu->__construct() | JROOT/libraries/src/Menu/SiteMenu.php:62 |
| 16 | Joomla\CMS\Menu\SiteMenu->__construct() | JROOT/libraries/src/Menu/AbstractMenu.php:142 |
| 15 | Joomla\CMS\Menu\AbstractMenu::getInstance() | JROOT/libraries/src/Application/CMSApplication.php:417 |
| 14 | Joomla\CMS\Application\CMSApplication->getMenu() | JROOT/libraries/src/Application/SiteApplication.php:275 |
| 13 | Joomla\CMS\Application\SiteApplication->getMenu() | JROOT/libraries/src/Router/SiteRouter.php:65 |
| 12 | Joomla\CMS\Router\SiteRouter->__construct() | JROOT/libraries/src/Router/Router.php:189 |
| 11 | Joomla\CMS\Router\Router::getInstance() | JROOT/libraries/src/Application/CMSApplication.php:533 |
| 10 | Joomla\CMS\Application\CMSApplication::getRouter() | JROOT/libraries/src/Application/SiteApplication.php:403 |
| 9 | Joomla\CMS\Application\SiteApplication::getRouter() | JROOT/plugins/system/languagefilter/languagefilter.php:145 |
| 8 | PlgSystemLanguageFilter->onAfterInitialise() | JROOT/libraries/joomla/event/event.php:70 |
| 7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
| 5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:668 |
| 4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:90 |
Query Time: 1.93 ms After last query: 10.10 ms Query memory: 0.021 MB Memory before query: 5.507 MB Rows returned: 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
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 | goingrus_joomla.e.element | 1 | 66.67 | Using index condition; Using where |
| Status | Duration |
|---|
| starting | 0.20 ms |
| Executing hook on transaction | 0.01 ms |
| starting | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.15 ms |
| init | 0.01 ms |
| System lock | 0.02 ms |
| optimizing | 0.03 ms |
| statistics | 0.29 ms |
| preparing | 0.06 ms |
| executing | 0.68 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| waiting for handler commit | 0.02 ms |
| closing tables | 0.02 ms |
| freeing items | 0.24 ms |
| cleaning up | 0.04 ms |
| # | Caller | File and line number |
|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 11 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Application/SiteApplication.php:486 |
| 10 | Joomla\CMS\Application\SiteApplication->getTemplate() | JROOT/plugins/system/t3/includes/core/t3.php:348 |
| 9 | T3::detect() | JROOT/plugins/system/t3/t3.php:81 |
| 8 | plgSystemT3->onAfterRoute() | JROOT/libraries/joomla/event/event.php:70 |
| 7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
| 5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1190 |
| 4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
| 3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:90 |
Query Time: 0.83 ms After last query: 2.25 ms Query memory: 0.024 MB Memory before query: 5.724 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.10 ms |
| Executing hook on transaction | 0.01 ms |
| starting | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.05 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.12 ms |
| preparing | 0.09 ms |
| executing | 0.05 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| waiting for handler commit | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.06 ms |
| cleaning up | 0.04 ms |
| # | Caller | File and line number |
|---|
| 19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
| 18 | JDatabaseDriver->loadObject() | JROOT/libraries/src/Helper/LibraryHelper.php:167 |
| 17 | Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}() | Same as call in the line below. |
| 16 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 15 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/LibraryHelper.php:175 |
| 14 | Joomla\CMS\Helper\LibraryHelper::loadLibrary() | JROOT/libraries/src/Helper/LibraryHelper.php:43 |
| 13 | Joomla\CMS\Helper\LibraryHelper::getLibrary() | JROOT/libraries/src/Helper/LibraryHelper.php:90 |
| 12 | Joomla\CMS\Helper\LibraryHelper::getParams() | JROOT/libraries/src/Version.php:321 |
| 11 | Joomla\CMS\Version->getMediaVersion() | JROOT/libraries/src/Factory.php:778 |
| 10 | Joomla\CMS\Factory::createDocument() | JROOT/libraries/src/Factory.php:234 |
| 9 | Joomla\CMS\Factory::getDocument() | JROOT/plugins/system/jcomments/jcomments.php:111 |
| 8 | plgSystemJComments->onAfterRoute() | JROOT/libraries/joomla/event/event.php:70 |
| 7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
| 5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1190 |
| 4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
| 3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:90 |
Query Time: 7.95 ms After last query: 0.15 ms Query memory: 0.006 MB Memory before query: 5.716 MB
UPDATE `joom_extensions`
SET `params` = '{\"mediaversion\":\"fc94bce8610e6e403f76e93c6944c9bc\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'
EXPLAIN not possible on query: UPDATE `joom_extensions`
SET `params` = '{\"mediaversion\":\"fc94bce8610e6e403f76e93c6944c9bc\"}'
WHERE `type` = 'library' AND `element` = 'joomla'
| Status | Duration |
|---|
| starting | 0.06 ms |
| Executing hook on transaction | 0.01 ms |
| starting | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.03 ms |
| init | 0.01 ms |
| System lock | 0.60 ms |
| updating | 0.36 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| waiting for handler commit | 6.60 ms |
| closing tables | 0.04 ms |
| freeing items | 0.09 ms |
| cleaning up | 0.03 ms |
| # | Caller | File and line number |
|---|
| 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/src/Helper/LibraryHelper.php:117 |
| 13 | Joomla\CMS\Helper\LibraryHelper::saveParams() | JROOT/libraries/src/Version.php:372 |
| 12 | Joomla\CMS\Version->setMediaVersion() | JROOT/libraries/src/Version.php:331 |
| 11 | Joomla\CMS\Version->getMediaVersion() | JROOT/libraries/src/Factory.php:778 |
| 10 | Joomla\CMS\Factory::createDocument() | JROOT/libraries/src/Factory.php:234 |
| 9 | Joomla\CMS\Factory::getDocument() | JROOT/plugins/system/jcomments/jcomments.php:111 |
| 8 | plgSystemJComments->onAfterRoute() | JROOT/libraries/joomla/event/event.php:70 |
| 7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
| 5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1190 |
| 4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
| 3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:90 |
Query Time: 1.20 ms After last query: 1.45 ms Query memory: 0.033 MB Memory before query: 5.758 MB Rows returned: 88
SELECT *
FROM `joom_jcomments_settings`
WHERE `lang` = 'en-GB'
AND `component` = ''
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | joom_jcomments_settings | NULL | ref | PRIMARY | PRIMARY | 214 | const,const | 88 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.09 ms |
| Executing hook on transaction | 0.02 ms |
| starting | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.14 ms |
| init | 0.01 ms |
| System lock | 0.02 ms |
| optimizing | 0.02 ms |
| statistics | 0.13 ms |
| preparing | 0.02 ms |
| executing | 0.42 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| waiting for handler commit | 0.02 ms |
| closing tables | 0.01 ms |
| freeing items | 0.10 ms |
| cleaning up | 0.01 ms |
| # | Caller | File and line number |
|---|
| 19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 18 | JDatabaseDriver->loadObjectList() | JROOT/components/com_jcomments/classes/config.php:140 |
| 17 | JCommentsCfg::_load() | Same as call in the line below. |
| 16 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 15 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/components/com_jcomments/classes/config.php:159 |
| 14 | JCommentsCfg->load() | JROOT/components/com_jcomments/classes/config.php:47 |
| 13 | JCommentsCfg::getInstance() | JROOT/components/com_jcomments/classes/factory.php:188 |
| 12 | JCommentsFactory::getConfig() | JROOT/components/com_jcomments/classes/multilingual.php:45 |
| 11 | JCommentsMultilingual::isEnabled() | JROOT/components/com_jcomments/classes/config.php:41 |
| 10 | JCommentsCfg::getInstance() | JROOT/components/com_jcomments/helpers/system.php:39 |
| 9 | JCommentsSystemPluginHelper::getCSS() | JROOT/plugins/system/jcomments/jcomments.php:139 |
| 8 | plgSystemJComments->onAfterRoute() | JROOT/libraries/joomla/event/event.php:70 |
| 7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
| 5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1190 |
| 4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
| 3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:90 |
Query Time: 1.31 ms After last query: 3.67 ms Query memory: 0.027 MB Memory before query: 5.913 MB Rows returned: 37
SELECT `id`,`name`,`rules`,`parent_id`
FROM `joom_assets`
WHERE `name` IN ('root.1','com_admin','com_ajax','com_akeeba','com_banners','com_cache','com_categories','com_checkin','com_ckeditor','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_dbreplacer','com_fastphoto','com_fastpost','com_finder','com_installer','com_jcomments','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_osmap','com_plugins','com_postinstall','com_redirect','com_search','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 | 38 | 100.00 | Using index condition |
| Status | Duration |
|---|
| starting | 0.12 ms |
| Executing hook on transaction | 0.01 ms |
| starting | 0.04 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.12 ms |
| init | 0.01 ms |
| System lock | 0.03 ms |
| optimizing | 0.02 ms |
| statistics | 0.12 ms |
| preparing | 0.02 ms |
| executing | 0.57 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| waiting for handler commit | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.06 ms |
| cleaning up | 0.03 ms |
| # | Caller | File and line number |
|---|
| 18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 17 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Access/Access.php:429 |
| 16 | Joomla\CMS\Access\Access::preloadComponents() | JROOT/libraries/src/Access/Access.php:213 |
| 15 | Joomla\CMS\Access\Access::preload() | JROOT/libraries/src/Access/Access.php:531 |
| 14 | Joomla\CMS\Access\Access::getAssetRules() | JROOT/libraries/src/Access/Access.php:183 |
| 13 | Joomla\CMS\Access\Access::check() | JROOT/libraries/src/User/User.php:398 |
| 12 | Joomla\CMS\User\User->authorise() | JROOT/components/com_content/models/article.php:58 |
| 11 | ContentModelArticle->populateState() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457 |
| 10 | Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() | JROOT/components/com_content/models/article.php:251 |
| 9 | ContentModelArticle->hit() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:90 |
Query Time: 3.28 ms After last query: 0.50 ms Query memory: 0.302 MB Memory before query: 5.963 MB Rows returned: 1150
SELECT `id`,`name`,`rules`,`parent_id`
FROM `joom_assets`
WHERE `name` LIKE 'com_content.%' OR `name` = 'com_content' OR `parent_id` = 0
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | joom_assets | NULL | ALL | idx_asset_name,idx_parent_id | NO INDEX KEY COULD BE USED | NULL | NULL | 1271 | 25.71 | Using where |
| Status | Duration |
|---|
| starting | 0.05 ms |
| Executing hook on transaction | 0.01 ms |
| starting | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.10 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.14 ms |
| preparing | 0.02 ms |
| executing | 2.38 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| waiting for handler commit | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.06 ms |
| cleaning up | 0.03 ms |
| # | Caller | File and line number |
|---|
| 18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 17 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Access/Access.php:359 |
| 16 | Joomla\CMS\Access\Access::preloadPermissions() | JROOT/libraries/src/Access/Access.php:226 |
| 15 | Joomla\CMS\Access\Access::preload() | JROOT/libraries/src/Access/Access.php:540 |
| 14 | Joomla\CMS\Access\Access::getAssetRules() | JROOT/libraries/src/Access/Access.php:183 |
| 13 | Joomla\CMS\Access\Access::check() | JROOT/libraries/src/User/User.php:398 |
| 12 | Joomla\CMS\User\User->authorise() | JROOT/components/com_content/models/article.php:58 |
| 11 | ContentModelArticle->populateState() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457 |
| 10 | Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() | JROOT/components/com_content/models/article.php:251 |
| 9 | ContentModelArticle->hit() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:90 |
Query Time: 4.22 ms After last query: 2.67 ms Query memory: 0.031 MB Memory before query: 7.075 MB Rows returned: 31
SHOW FULL COLUMNS
FROM `joom_content`
EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `joom_content`
| Status | Duration |
|---|
| starting | 0.20 ms |
| Executing hook on transaction | 0.01 ms |
| starting | 0.09 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 1.07 ms |
| init | 0.09 ms |
| System lock | 0.02 ms |
| optimizing | 0.05 ms |
| statistics | 0.23 ms |
| preparing | 0.06 ms |
| Creating tmp table | 0.11 ms |
| executing | 0.15 ms |
| checking permissions | 0.25 ms |
| checking permissions | 0.06 ms |
| checking permissions | 0.03 ms |
| checking permissions | 0.03 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.03 ms |
| checking permissions | 0.04 ms |
| checking permissions | 0.03 ms |
| checking permissions | 0.03 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.05 ms |
| checking permissions | 0.03 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.03 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.03 ms |
| checking permissions | 0.03 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.03 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.08 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| waiting for handler commit | 0.02 ms |
| closing tables | 0.02 ms |
| freeing items | 0.21 ms |
| cleaning up | 0.15 ms |
| # | Caller | File and line number |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 15 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:448 |
| 14 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/src/Table/Table.php:261 |
| 13 | Joomla\CMS\Table\Table->getFields() | JROOT/libraries/src/Table/Table.php:180 |
| 12 | Joomla\CMS\Table\Table->__construct() | JROOT/libraries/src/Table/Content.php:39 |
| 11 | Joomla\CMS\Table\Content->__construct() | JROOT/libraries/src/Table/Table.php:328 |
| 10 | Joomla\CMS\Table\Table::getInstance() | JROOT/components/com_content/models/article.php:253 |
| 9 | ContentModelArticle->hit() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:90 |
Query Time: 10.05 ms After last query: 1.17 ms Query memory: 0.005 MB Memory before query: 7.135 MB
UPDATE joom_content
SET `hits` = (`hits` + 1)
WHERE `id` = '553'
EXPLAIN not possible on query: UPDATE joom_content
SET `hits` = (`hits` + 1)
WHERE `id` = '553'
| Status | Duration |
|---|
| starting | 0.09 ms |
| Executing hook on transaction | 0.01 ms |
| starting | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.11 ms |
| init | 0.01 ms |
| System lock | 0.12 ms |
| updating | 1.08 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| waiting for handler commit | 8.25 ms |
| closing tables | 0.04 ms |
| freeing items | 0.10 ms |
| cleaning up | 0.04 ms |
| # | Caller | File and line number |
|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/src/Table/Table.php:1264 |
| 10 | Joomla\CMS\Table\Table->hit() | JROOT/components/com_content/models/article.php:254 |
| 9 | ContentModelArticle->hit() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:90 |
Query Time: 2.61 ms After last query: 4.05 ms Query memory: 0.085 MB Memory before query: 7.277 MB Rows returned: 1
SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
FROM joom_content AS a
INNER JOIN joom_categories AS c
on c.id = a.catid
LEFT JOIN joom_users AS u
on u.id = a.created_by
LEFT JOIN joom_categories as parent
ON parent.id = c.parent_id
LEFT JOIN joom_content_rating AS v
ON a.id = v.content_id
WHERE a.id = 553
AND c.published > 0
AND a.language in ('en-GB','*')
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | a | NULL | const | PRIMARY,idx_catid,idx_language | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| 1 | SIMPLE | c | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| 1 | SIMPLE | u | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| 1 | SIMPLE | parent | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| 1 | SIMPLE | v | NULL | const | PRIMARY | PRIMARY | 4 | const | 0 | 0.00 | unique row not found |
| Status | Duration |
|---|
| starting | 0.51 ms |
| Executing hook on transaction | 0.01 ms |
| starting | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.50 ms |
| init | 0.02 ms |
| System lock | 0.02 ms |
| optimizing | 0.12 ms |
| statistics | 0.83 ms |
| preparing | 0.03 ms |
| executing | 0.20 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| waiting for handler commit | 0.02 ms |
| closing tables | 0.02 ms |
| freeing items | 0.08 ms |
| cleaning up | 0.03 ms |
| # | Caller | File and line number |
|---|
| 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
| 13 | JDatabaseDriver->loadObject() | JROOT/components/com_content/models/article.php:151 |
| 12 | ContentModelArticle->getItem() | JROOT/plugins/system/t3/includes/core/t3.php(528) : eval()'d code:425 |
| 11 | Joomla\CMS\MVC\View\_JHtmlView->get() | JROOT/components/com_content/views/article/view.html.php:42 |
| 10 | ContentViewArticle->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:90 |
Query Time: 1.23 ms After last query: 4.21 ms Query memory: 0.022 MB Memory before query: 7.395 MB Rows returned: 0
SELECT `m`.`tag_id`,`t`.*
FROM `joom_contentitem_tag_map` AS m
INNER JOIN `joom_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 553
AND `t`.`published` = 1
AND t.access IN (1,1,2,3)
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | m | NULL | ALL | idx_tag_type | NO INDEX KEY COULD BE USED | NULL | NULL | 1 | 100.00 | Using where |
| 1 | SIMPLE | t | NULL | eq_ref | PRIMARY,tag_idx,idx_access | PRIMARY | 4 | goingrus_joomla.m.tag_id | 1 | 100.00 | Using where |
| Status | Duration |
|---|
| starting | 0.31 ms |
| Executing hook on transaction | 0.03 ms |
| starting | 0.02 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.22 ms |
| init | 0.02 ms |
| System lock | 0.01 ms |
| optimizing | 0.02 ms |
| statistics | 0.16 ms |
| preparing | 0.06 ms |
| executing | 0.07 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| waiting for handler commit | 0.02 ms |
| closing tables | 0.01 ms |
| freeing items | 0.06 ms |
| cleaning up | 0.02 ms |
| # | Caller | File and line number |
|---|
| 13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 12 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Helper/TagsHelper.php:454 |
| 11 | Joomla\CMS\Helper\TagsHelper->getItemTags() | JROOT/components/com_content/views/article/view.html.php:184 |
| 10 | ContentViewArticle->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:90 |
Query Time: 0.66 ms After last query: 2.84 ms Query memory: 0.027 MB Memory before query: 7.513 MB Rows returned: 1
SELECT *
FROM `joom_jcomments_objects`
WHERE `object_id` = '553'
AND `object_group` = 'com_content'
AND `lang` = 'en-GB'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | joom_jcomments_objects | NULL | ref | idx_object | idx_object | 833 | const,const,const | 1 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.07 ms |
| Executing hook on transaction | 0.01 ms |
| starting | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.09 ms |
| init | 0.01 ms |
| System lock | 0.02 ms |
| optimizing | 0.04 ms |
| statistics | 0.11 ms |
| preparing | 0.03 ms |
| executing | 0.10 ms |
| end | 0.01 ms |
| query end | 0.00 ms |
| waiting for handler commit | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.05 ms |
| cleaning up | 0.02 ms |
| # | Caller | File and line number |
|---|
| 24 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
| 23 | JDatabaseDriver->loadObject() | JROOT/components/com_jcomments/models/object.php:28 |
| 22 | JCommentsModelObject::getObjectInfo() | JROOT/components/com_jcomments/helpers/object.php:117 |
| 21 | JCommentsObjectHelper::fetchObjectInfo() | Same as call in the line below. |
| 20 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 19 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/components/com_jcomments/helpers/object.php:159 |
| 18 | JCommentsObjectHelper::getObjectInfo() | JROOT/components/com_jcomments/helpers/object.php:46 |
| 17 | JCommentsObjectHelper::getLink() | JROOT/components/com_jcomments/classes/factory.php:255 |
| 16 | JCommentsFactory::getTemplate() | JROOT/components/com_jcomments/jcomments.php:194 |
| 15 | JComments::show() | JROOT/plugins/content/jcomments/jcomments.php:280 |
| 14 | plgContentJComments->onAfterDisplayContent() | JROOT/plugins/content/jcomments/jcomments.php:337 |
| 13 | plgContentJComments->onContentAfterDisplay() | JROOT/libraries/joomla/event/event.php:70 |
| 12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/article/view.html.php:202 |
| 10 | ContentViewArticle->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:90 |
Query Time: 1.99 ms After last query: 0.20 ms Query memory: 0.025 MB Memory before query: 7.494 MB Rows returned: 1
SELECT count(*)
FROM joom_jcomments AS c
WHERE c.object_id = 553
AND c.object_group = 'com_content'
AND c.published = 1
AND c.lang = 'en-GB'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | c | NULL | ref | idx_lang,idx_object | idx_object | 772 | const,const,const | 2 | 2.50 | Using where |
| Status | Duration |
|---|
| starting | 0.08 ms |
| Executing hook on transaction | 0.01 ms |
| starting | 0.01 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.16 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.02 ms |
| statistics | 0.33 ms |
| preparing | 0.03 ms |
| executing | 0.07 ms |
| end | 0.01 ms |
| query end | 0.00 ms |
| waiting for handler commit | 0.01 ms |
| closing tables | 0.02 ms |
| freeing items | 0.05 ms |
| cleaning up | 0.02 ms |
| # | Caller | File and line number |
|---|
| 19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
| 18 | JDatabaseDriver->loadResult() | JROOT/components/com_jcomments/models/jcomments.php:35 |
| 17 | JCommentsModel::getCommentsCount() | JROOT/components/com_jcomments/jcomments.php:1306 |
| 16 | JComments::getCommentsCount() | JROOT/components/com_jcomments/jcomments.php:224 |
| 15 | JComments::show() | JROOT/plugins/content/jcomments/jcomments.php:280 |
| 14 | plgContentJComments->onAfterDisplayContent() | JROOT/plugins/content/jcomments/jcomments.php:337 |
| 13 | plgContentJComments->onContentAfterDisplay() | JROOT/libraries/joomla/event/event.php:70 |
| 12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/article/view.html.php:202 |
| 10 | ContentViewArticle->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:90 |
Query Time: 1.17 ms After last query: 0.21 ms Query memory: 0.026 MB Memory before query: 7.506 MB Rows returned: 2
SELECT c.id, c.parent, c.object_id, c.object_group, c.userid, c.name, c.username, c.title, c.comment
, c.email, c.homepage, c.date, c.date as datetime, c.ip, c.published, c.deleted, c.checked_out, c.checked_out_time
, c.isgood, c.ispoor
, 1 as voted
,
case when c.parent = 0 then unix_timestamp(c.date) else 0 end as threaddate, '' AS object_title, '' AS object_link, 0 AS object_access, 0 AS object_owner
FROM joom_jcomments AS c
WHERE c.object_id = 553
AND c.object_group = 'com_content'
AND c.published = 1
AND c.lang = 'en-GB'
ORDER BY c.parent, c.date ASC
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | c | NULL | ref | idx_lang,idx_object | idx_object | 772 | const,const,const | 2 | 2.50 | Using where; Using filesort |
| Status | Duration |
|---|
| starting | 0.62 ms |
| Executing hook on transaction | 0.01 ms |
| starting | 0.02 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.05 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.02 ms |
| statistics | 0.07 ms |
| preparing | 0.03 ms |
| executing | 0.12 ms |
| end | 0.01 ms |
| query end | 0.00 ms |
| waiting for handler commit | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.05 ms |
| cleaning up | 0.02 ms |
| # | Caller | File and line number |
|---|
| 19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 18 | JDatabaseDriver->loadObjectList() | JROOT/components/com_jcomments/models/jcomments.php:80 |
| 17 | JCommentsModel::getCommentsList() | JROOT/components/com_jcomments/jcomments.php:792 |
| 16 | JComments::getCommentsTree() | JROOT/components/com_jcomments/jcomments.php:269 |
| 15 | JComments::show() | JROOT/plugins/content/jcomments/jcomments.php:280 |
| 14 | plgContentJComments->onAfterDisplayContent() | JROOT/plugins/content/jcomments/jcomments.php:337 |
| 13 | plgContentJComments->onContentAfterDisplay() | JROOT/libraries/joomla/event/event.php:70 |
| 12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/article/view.html.php:202 |
| 10 | ContentViewArticle->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:90 |
Query Time: 4.12 ms After last query: 7.12 ms Query memory: 0.021 MB Memory before query: 7.628 MB Rows returned: 9
SELECT language,id
FROM `joom_menu`
WHERE home = 1
AND published = 1
AND client_id = 0
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | joom_menu | NULL | ref | idx_client_id_parent_id_alias_language | idx_client_id_parent_id_alias_language | 1 | const | 788 | 1.00 | Using where |
| Status | Duration |
|---|
| starting | 0.11 ms |
| Executing hook on transaction | 0.01 ms |
| starting | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.05 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.02 ms |
| statistics | 0.10 ms |
| preparing | 0.04 ms |
| executing | 2.35 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| waiting for handler commit | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.07 ms |
| cleaning up | 0.04 ms |
| # | Caller | File and line number |
|---|
| 10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 9 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Language/Multilanguage.php:107 |
| 8 | Joomla\CMS\Language\Multilanguage::getSiteHomePages() | JROOT/plugins/system/languagefilter/languagefilter.php:751 |
| 7 | PlgSystemLanguageFilter->onAfterDispatch() | JROOT/libraries/joomla/event/event.php:70 |
| 6 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 5 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
| 4 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/SiteApplication.php:199 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:90 |
Query Time: 0.93 ms After last query: 0.50 ms Query memory: 0.021 MB Memory before query: 7.643 MB Rows returned: 5
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 = 449
| 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 | 5 | 100.00 | Using index |
| 1 | SIMPLE | c2 | NULL | eq_ref | PRIMARY | PRIMARY | 4 | goingrus_joomla.a2.id | 1 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.10 ms |
| Executing hook on transaction | 0.01 ms |
| starting | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.11 ms |
| init | 0.09 ms |
| System lock | 0.01 ms |
| optimizing | 0.02 ms |
| statistics | 0.22 ms |
| preparing | 0.02 ms |
| executing | 0.07 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| waiting for handler commit | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.05 ms |
| cleaning up | 0.03 ms |
| # | Caller | File and line number |
|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 10 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Language/Associations.php:115 |
| 9 | Joomla\CMS\Language\Associations::getAssociations() | JROOT/administrator/components/com_menus/helpers/menus.php:321 |
| 8 | MenusHelper::getAssociations() | JROOT/plugins/system/languagefilter/languagefilter.php:768 |
| 7 | PlgSystemLanguageFilter->onAfterDispatch() | JROOT/libraries/joomla/event/event.php:70 |
| 6 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 5 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
| 4 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/SiteApplication.php:199 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:90 |
Query Time: 3.19 ms After last query: 0.62 ms Query memory: 0.021 MB Memory before query: 7.669 MB Rows returned: 1
SELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`,CONCAT_WS(':', ca.id, ca.alias) AS `catid`
FROM `joom_content` AS `c`
INNER JOIN `joom_associations` AS `a`
ON a.id = c.`id`
AND a.context='com_content.item'
INNER JOIN `joom_associations` AS `a2`
ON `a`.`key` = `a2`.`key`
INNER JOIN `joom_content` AS `c2`
ON a2.id = c2.`id`
INNER JOIN `joom_categories` AS `ca`
ON `c2`.`catid` = ca.id
AND ca.extension = 'com_content'
WHERE c.id = 553
AND c2.access IN (1,1,2,3)
AND c2.language != 'en-GB'| 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,idx_access,idx_catid,idx_language | PRIMARY | 4 | goingrus_joomla.a2.id | 1 | 74.20 | Using where |
| 1 | SIMPLE | ca | NULL | eq_ref | PRIMARY,cat_idx | PRIMARY | 4 | goingrus_joomla.c2.catid | 1 | 58.33 | Using where |
| Status | Duration |
|---|
| starting | 0.24 ms |
| Executing hook on transaction | 0.01 ms |
| starting | 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.02 ms |
| Opening tables | 0.10 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.02 ms |
| statistics | 0.35 ms |
| preparing | 0.03 ms |
| executing | 0.12 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| waiting for handler commit | 0.01 ms |
| closing tables | 0.02 ms |
| freeing items | 0.04 ms |
| cleaning up | 0.03 ms |
| # | Caller | File and line number |
|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 10 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Language/Associations.php:115 |
| 9 | Joomla\CMS\Language\Associations::getAssociations() | JROOT/components/com_content/helpers/association.php:76 |
| 8 | ContentHelperAssociation::getAssociations() | JROOT/plugins/system/languagefilter/languagefilter.php:783 |
| 7 | PlgSystemLanguageFilter->onAfterDispatch() | JROOT/libraries/joomla/event/event.php:70 |
| 6 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 5 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
| 4 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/SiteApplication.php:199 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:90 |
Query Time: 0.95 ms After last query: 1.30 ms Query memory: 0.026 MB Memory before query: 7.693 MB Rows returned: 2
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM `joom_categories` AS `s`
INNER JOIN `joom_categories` AS `c`
ON (s.lft < c.lft
AND c.lft < s.rgt
AND c.language IN ('en-GB','*')) OR (c.lft <= s.lft
AND s.rgt <= c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1,2,3)
AND c.published = 1
AND s.id = 2
ORDER BY c.lft
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | s | NULL | const | PRIMARY,idx_left_right | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| 1 | SIMPLE | c | NULL | range | cat_idx,idx_access,idx_left_right,idx_language | idx_left_right | 4 | NULL | 3 | 23.33 | Using index condition; Using where |
| Status | Duration |
|---|
| starting | 0.16 ms |
| Executing hook on transaction | 0.01 ms |
| starting | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.07 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.03 ms |
| statistics | 0.23 ms |
| preparing | 0.04 ms |
| executing | 0.09 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| waiting for handler commit | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.09 ms |
| cleaning up | 0.04 ms |
| # | Caller | File and line number |
|---|
| 21 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 20 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Categories/Categories.php:324 |
| 19 | Joomla\CMS\Categories\Categories->_load() | JROOT/libraries/src/Categories/Categories.php:184 |
| 18 | Joomla\CMS\Categories\Categories->get() | JROOT/components/com_content/router.php:72 |
| 17 | ContentRouter->getCategorySegment() | Same as call in the line below. |
| 16 | call_user_func_array() | JROOT/libraries/src/Component/Router/RouterView.php:120 |
| 15 | Joomla\CMS\Component\Router\RouterView->getPath() | JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 |
| 14 | Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() | JROOT/libraries/src/Component/Router/RouterView.php:222 |
| 13 | Joomla\CMS\Component\Router\RouterView->preprocess() | JROOT/libraries/src/Router/SiteRouter.php:676 |
| 12 | Joomla\CMS\Router\SiteRouter->processBuildRules() | JROOT/libraries/src/Router/Router.php:266 |
| 11 | Joomla\CMS\Router\Router->build() | JROOT/libraries/src/Router/SiteRouter.php:155 |
| 10 | Joomla\CMS\Router\SiteRouter->build() | JROOT/libraries/src/Router/Route.php:144 |
| 9 | Joomla\CMS\Router\Route::link() | JROOT/libraries/src/Router/Route.php:93 |
| 8 | Joomla\CMS\Router\Route::_() | JROOT/plugins/system/languagefilter/languagefilter.php:810 |
| 7 | PlgSystemLanguageFilter->onAfterDispatch() | JROOT/libraries/joomla/event/event.php:70 |
| 6 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 5 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
| 4 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/SiteApplication.php:199 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:90 |
Query Time: 1.86 ms After last query: 5.14 ms Query memory: 0.027 MB Memory before query: 8.103 MB Rows returned: 8
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 <= '2026-06-09 21:16:40')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-06-09 21:16:40')
AND m.access IN (1,1,2,3)
AND m.client_id = 0
AND (mm.menuid = 449 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 | range | PRIMARY,published,newsfeeds,idx_language | idx_language | 28 | NULL | 26 | 1.45 | Using index condition; Using where; Using filesort |
| 1 | SIMPLE | e | NULL | ref | element_clientid,element_folder_clientid | element_clientid | 403 | goingrus_joomla.m.module,const | 1 | 10.00 | Using index condition; Using where |
| 1 | SIMPLE | mm | NULL | ref | PRIMARY | PRIMARY | 4 | goingrus_joomla.m.id | 1 | 40.00 | Using where; Using index |
| Status | Duration |
|---|
| starting | 0.18 ms |
| Executing hook on transaction | 0.01 ms |
| starting | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.15 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.06 ms |
| statistics | 0.23 ms |
| preparing | 0.06 ms |
| executing | 0.84 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| waiting for handler commit | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.08 ms |
| cleaning up | 0.03 ms |
| # | Caller | File and line number |
|---|
| 20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 19 | JDatabaseDriver->loadObjectList() | Same as call in the line below. |
| 18 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 17 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/plugins/system/t3/includes/core/t3.php(528) : eval()'d code:441 |
| 16 | Joomla\CMS\Helper\_ModuleHelper::getModuleList() | JROOT/plugins/system/t3/includes/core/t3.php(528) : eval()'d code:371 |
| 15 | Joomla\CMS\Helper\_ModuleHelper::load() | JROOT/plugins/system/t3/includes/core/t3.php(528) : eval()'d code:87 |
| 14 | Joomla\CMS\Helper\_ModuleHelper::getModules() | JROOT/libraries/src/Document/HtmlDocument.php:601 |
| 13 | Joomla\CMS\Document\HtmlDocument->countModules() | JROOT/plugins/system/t3/includes/core/template.php:686 |
| 12 | T3Template->checkSpotlight() | JROOT/templates/t3_bs3_blank/tpls/blocks/spotlight-1.php:11 |
| 11 | include JROOT/templates/t3_bs3_blank/tpls/blocks/spotlight-1.php | JROOT/plugins/system/t3/includes/core/template.php:200 |
| 10 | T3Template->loadBlock() | JROOT/templates/t3_bs3_blank/local/tpls/default-goingrus.php:34 |
| 9 | include JROOT/templates/t3_bs3_blank/local/tpls/default-goingrus.php | JROOT/plugins/system/t3/includes/core/template.php:226 |
| 8 | T3Template->loadLayout() | JROOT/templates/t3_bs3_blank/index.php:34 |
| 7 | require JROOT/templates/t3_bs3_blank/index.php | JROOT/libraries/src/Document/HtmlDocument.php:678 |
| 6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:740 |
| 5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:555 |
| 4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1098 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:90 |
2 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `joom_assets`
2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `joom_extensions`
1 × SELECT `data`
FROM `joom_session`
1 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM `joom_categories` AS `s`
INNER JOIN `joom_categories` AS `c`
ON (s.lft < c.lft
AND c.lft < s.rgt
AND c.language IN ('en-GB','*')) OR (c.lft <= s.lft
AND s.rgt <= c.rgt)
1 × SELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`,CONCAT_WS(':', ca.id, ca.alias) AS `catid`
FROM `joom_content` AS `c`
INNER JOIN `joom_associations` AS `a`
ON a.id = c.`id`
AND a.context='com_content.item'
INNER JOIN `joom_associations` AS `a2`
ON `a`.`key` = `a2`.`key`
INNER JOIN `joom_content` AS `c2`
ON a2.id = c2.`id`
INNER JOIN `joom_categories` AS `ca`
ON `c2`.`catid` = ca.id
AND ca.extension = 'com_content'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 language,id
FROM `joom_menu`
1 × SELECT c.id, c.parent, c.object_id, c.object_group, c.userid, c.name, c.username, c.title, c.comment , c.email, c.homepage, c.date, c.date as datetime, c.ip, c.published, c.deleted, c.checked_out, c.checked_out_time , c.isgood, c.ispoor , 1 as voted ,
case when c.parent = 0 then unix_timestamp(c.date) else 0 end as threaddate, '' AS object_title, '' AS object_link, 0 AS object_access, 0 AS object_owner
FROM joom_jcomments AS c
1 × SELECT count(*)
FROM joom_jcomments AS c
1 × SELECT *
FROM `joom_jcomments_objects`
1 × SELECT `m`.`tag_id`,`t`.*
FROM `joom_contentitem_tag_map` AS m
INNER JOIN `joom_tags` AS t
ON `m`.`tag_id` = `t`.`id`
1 × SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
FROM joom_content AS a
INNER JOIN joom_categories AS c
on c.id = a.catid
LEFT JOIN joom_users AS u
on u.id = a.created_by
LEFT JOIN joom_categories as parent
ON parent.id = c.parent_id
LEFT JOIN joom_content_rating AS v
ON a.id = v.content_id
1 × SELECT *
FROM `joom_jcomments_settings`
1 × SELECT `session_id`
FROM `joom_session`
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 id, published
FROM `joom_menu`
1 × 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
Comments
Can you arrange such visa invitations so that we may get them from you.
Please update us with the latest
Good day Sir,
Thank you for your message and request.
Could you please let me know your citizenship?
--
Sincerely yours