Query Time: 0.68 ms Query memory: 0.023 MB Memory before query: 1.024 MB Rows returned: 1
SELECT `data`
FROM `j256_session`
WHERE `session_id` = X'6a64646d646f6c6e6f6f7334746c6c6831716d76336d6a743164'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | j256_session | const | PRIMARY | PRIMARY | 194 | const | 1 | |
| Status | Duration |
|---|
| starting | 0.06 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.02 ms |
| System lock | 0.01 ms |
| Table lock | 0.01 ms |
| init | 0.03 ms |
| optimizing | 0.02 ms |
| statistics | 0.06 ms |
| preparing | 0.02 ms |
| Unlocking tables | 0.03 ms |
| executing | 0.01 ms |
| Sending data | 0.02 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.05 ms |
| freeing items | 0.02 ms |
| updating status | 0.04 ms |
| cleaning up | 0.01 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:46 |
Query Time: 1.11 ms After last query: 1.14 ms Query memory: 0.024 MB Memory before query: 1.071 MB Rows returned: 39
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `j256_extensions`
WHERE `type` = 'component'
AND `state` = 0
AND `enabled` = 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | j256_extensions | ref | extension | extension | 82 | const | 41 | Using index condition; Using where |
| Status | Duration |
|---|
| starting | 0.06 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| Table lock | 0.01 ms |
| init | 0.03 ms |
| optimizing | 0.03 ms |
| statistics | 0.07 ms |
| preparing | 0.05 ms |
| executing | 0.01 ms |
| Sending data | 0.33 ms |
| end | 0.02 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.02 ms |
| freeing items | 0.02 ms |
| updating status | 0.05 ms |
| cleaning up | 0.01 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:49 |
Query Time: 0.62 ms After last query: 0.88 ms Query memory: 0.021 MB Memory before query: 1.097 MB Rows returned: 4
SELECT id, rules
FROM `j256_viewlevels`
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | j256_viewlevels | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 4 | |
| Status | Duration |
|---|
| starting | 0.05 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.02 ms |
| System lock | 0.01 ms |
| Table lock | 0.01 ms |
| init | 0.02 ms |
| optimizing | 0.02 ms |
| statistics | 0.02 ms |
| preparing | 0.02 ms |
| executing | 0.01 ms |
| Sending data | 0.06 ms |
| end | 0.02 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.02 ms |
| freeing items | 0.01 ms |
| updating status | 0.04 ms |
| cleaning up | 0.01 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:49 |
Query Time: 0.72 ms After last query: 0.24 ms Query memory: 0.021 MB Memory before query: 1.109 MB Rows returned: 5
SELECT b.id
FROM j256_usergroups AS a
LEFT JOIN j256_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 5
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | a | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| 1 | SIMPLE | b | range | idx_usergroup_nested_set_lookup | idx_usergroup_nested_set_lookup | 4 | NULL | 9 | Using where; Using index |
| Status | Duration |
|---|
| starting | 0.06 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| Table lock | 0.01 ms |
| init | 0.03 ms |
| optimizing | 0.03 ms |
| statistics | 0.08 ms |
| preparing | 0.02 ms |
| Unlocking tables | 0.04 ms |
| executing | 0.01 ms |
| Sending data | 0.06 ms |
| end | 0.02 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.02 ms |
| freeing items | 0.02 ms |
| updating status | 0.04 ms |
| cleaning up | 0.01 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:49 |
Query Time: 1.69 ms After last query: 0.32 ms Query memory: 0.030 MB Memory before query: 1.130 MB Rows returned: 77
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM j256_extensions
WHERE enabled = 1
AND type = 'plugin'
AND state IN (0,1)
AND access IN (1,1,2,3,4)
ORDER BY ordering
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | j256_extensions | ref | extension | extension | 82 | const | 113 | Using index condition; Using where; Using filesort |
| Status | Duration |
|---|
| starting | 0.07 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.02 ms |
| After opening tables | 0.01 ms |
| System lock | 0.04 ms |
| Table lock | 0.01 ms |
| init | 0.04 ms |
| optimizing | 0.04 ms |
| statistics | 0.07 ms |
| preparing | 0.05 ms |
| executing | 0.01 ms |
| Sorting result | 0.70 ms |
| Sending data | 0.25 ms |
| end | 0.02 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.02 ms |
| freeing items | 0.02 ms |
| updating status | 0.05 ms |
| cleaning up | 0.01 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:49 |
Query Time: 2.48 ms After last query: 31.95 ms Query memory: 0.151 MB Memory before query: 1.558 MB Rows returned: 99
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 j256_menu AS m
LEFT JOIN j256_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 | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | m | ref | idx_client_id_parent_id_alias_language | idx_client_id_parent_id_alias_language | 1 | const | 123 | Using index condition; Using where; Using filesort |
| 1 | SIMPLE | e | eq_ref | PRIMARY | PRIMARY | 4 | igeopat.m.component_id | 1 | Using where |
| Status | Duration |
|---|
| starting | 0.12 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.04 ms |
| After opening tables | 0.02 ms |
| System lock | 0.01 ms |
| Table lock | 0.01 ms |
| init | 0.05 ms |
| optimizing | 0.04 ms |
| statistics | 0.08 ms |
| preparing | 0.06 ms |
| executing | 0.01 ms |
| Sorting result | 0.70 ms |
| Sending data | 0.99 ms |
| end | 0.02 ms |
| query end | 0.02 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.02 ms |
| freeing items | 0.02 ms |
| updating status | 0.04 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/libraries/src/Menu/SiteMenu.php:93 |
| 17 | Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{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/Menu/SiteMenu.php:101 |
| 14 | Joomla\CMS\Menu\SiteMenu->load() | JROOT/libraries/src/Menu/AbstractMenu.php:78 |
| 13 | Joomla\CMS\Menu\AbstractMenu->__construct() | JROOT/libraries/src/Menu/SiteMenu.php:62 |
| 12 | Joomla\CMS\Menu\SiteMenu->__construct() | JROOT/libraries/src/Menu/AbstractMenu.php:142 |
| 11 | Joomla\CMS\Menu\AbstractMenu::getInstance() | JROOT/libraries/src/Application/CMSApplication.php:417 |
| 10 | Joomla\CMS\Application\CMSApplication->getMenu() | JROOT/libraries/src/Application/SiteApplication.php:275 |
| 9 | Joomla\CMS\Application\SiteApplication->getMenu() | JROOT/libraries/src/Router/SiteRouter.php:65 |
| 8 | Joomla\CMS\Router\SiteRouter->__construct() | JROOT/libraries/src/Router/Router.php:189 |
| 7 | Joomla\CMS\Router\Router::getInstance() | JROOT/libraries/src/Application/CMSApplication.php:533 |
| 6 | Joomla\CMS\Application\CMSApplication::getRouter() | JROOT/libraries/src/Application/SiteApplication.php:403 |
| 5 | Joomla\CMS\Application\SiteApplication::getRouter() | JROOT/libraries/src/Application/CMSApplication.php:1141 |
| 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:49 |
Query Time: 0.80 ms After last query: 5.73 ms Query memory: 0.022 MB Memory before query: 2.097 MB Rows returned: 1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `j256_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | j256_extensions | ref | element_clientid,element_folder_clientid,extension | extension | 484 | const,const | 1 | Using index condition |
| Status | Duration |
|---|
| starting | 0.06 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| Table lock | 0.01 ms |
| init | 0.03 ms |
| optimizing | 0.03 ms |
| statistics | 0.10 ms |
| preparing | 0.04 ms |
| executing | 0.01 ms |
| Sending data | 0.08 ms |
| end | 0.02 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.02 ms |
| freeing items | 0.01 ms |
| updating status | 0.04 ms |
| cleaning up | 0.01 ms |
| # | Caller | File and line number |
|---|
| 15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
| 14 | JDatabaseDriver->loadObject() | JROOT/libraries/src/Helper/LibraryHelper.php:167 |
| 13 | Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}() | 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/LibraryHelper.php:175 |
| 10 | Joomla\CMS\Helper\LibraryHelper::loadLibrary() | JROOT/libraries/src/Helper/LibraryHelper.php:43 |
| 9 | Joomla\CMS\Helper\LibraryHelper::getLibrary() | JROOT/libraries/src/Helper/LibraryHelper.php:90 |
| 8 | Joomla\CMS\Helper\LibraryHelper::getParams() | JROOT/libraries/src/Version.php:321 |
| 7 | Joomla\CMS\Version->getMediaVersion() | JROOT/libraries/src/Factory.php:778 |
| 6 | Joomla\CMS\Factory::createDocument() | JROOT/libraries/src/Factory.php:234 |
| 5 | Joomla\CMS\Factory::getDocument() | JROOT/libraries/src/Application/WebApplication.php:1137 |
| 4 | Joomla\CMS\Application\WebApplication->loadDocument() | JROOT/libraries/src/Application/SiteApplication.php:133 |
| 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:49 |
Query Time: 31.03 ms After last query: 0.38 ms Query memory: 0.005 MB Memory before query: 2.087 MB
UPDATE `j256_extensions`
SET `params` = '{\"mediaversion\":\"019d98d81c68ca626e71d054648dbdb1\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'
EXPLAIN not possible on query: UPDATE `j256_extensions`
SET `params` = '{\"mediaversion\":\"019d98d81c68ca626e71d054648dbdb1\"}'
WHERE `type` = 'library' AND `element` = 'joomla'
| Status | Duration |
|---|
| starting | 0.06 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.02 ms |
| System lock | 0.01 ms |
| Table lock | 0.01 ms |
| init | 0.11 ms |
| updating | 0.10 ms |
| end | 0.02 ms |
| query end | 30.37 ms |
| closing tables | 0.02 ms |
| Unlocking tables | 0.02 ms |
| freeing items | 0.02 ms |
| updating status | 0.04 ms |
| cleaning up | 0.01 ms |
| # | Caller | File and line number |
|---|
| 10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/src/Helper/LibraryHelper.php:117 |
| 9 | Joomla\CMS\Helper\LibraryHelper::saveParams() | JROOT/libraries/src/Version.php:372 |
| 8 | Joomla\CMS\Version->setMediaVersion() | JROOT/libraries/src/Version.php:331 |
| 7 | Joomla\CMS\Version->getMediaVersion() | JROOT/libraries/src/Factory.php:778 |
| 6 | Joomla\CMS\Factory::createDocument() | JROOT/libraries/src/Factory.php:234 |
| 5 | Joomla\CMS\Factory::getDocument() | JROOT/libraries/src/Application/WebApplication.php:1137 |
| 4 | Joomla\CMS\Application\WebApplication->loadDocument() | JROOT/libraries/src/Application/SiteApplication.php:133 |
| 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:49 |
Query Time: 0.75 ms After last query: 0.77 ms Query memory: 0.020 MB Memory before query: 2.117 MB Rows returned: 2
SELECT *
FROM j256_languages
WHERE published=1
ORDER BY ordering ASC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | j256_languages | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 2 | Using where; Using filesort |
| Status | Duration |
|---|
| starting | 0.05 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| Table lock | 0.01 ms |
| init | 0.04 ms |
| optimizing | 0.02 ms |
| statistics | 0.03 ms |
| preparing | 0.03 ms |
| executing | 0.01 ms |
| Sorting result | 0.06 ms |
| Sending data | 0.07 ms |
| end | 0.02 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.02 ms |
| freeing items | 0.01 ms |
| updating status | 0.04 ms |
| cleaning up | 0.01 ms |
| # | Caller | File and line number |
|---|
| 7 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 6 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Language/LanguageHelper.php:150 |
| 5 | Joomla\CMS\Language\LanguageHelper::getLanguages() | JROOT/libraries/src/Application/SiteApplication.php:330 |
| 4 | Joomla\CMS\Application\SiteApplication->getParams() | JROOT/libraries/src/Application/SiteApplication.php:138 |
| 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:49 |
Query Time: 1.12 ms After last query: 0.52 ms Query memory: 0.019 MB Memory before query: 2.136 MB Rows returned: 9
SELECT id, home, template, s.params
FROM j256_template_styles as s
LEFT JOIN j256_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 | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | s | ALL | idx_template,idx_client_id,idx_client_id_home | NO INDEX KEY COULD BE USED | NULL | NULL | 12 | Using where |
| 1 | SIMPLE | e | ref | element_clientid,element_folder_clientid,extension | element_clientid | 403 | igeopat.s.template,const | 1 | Using index condition; Using where |
| Status | Duration |
|---|
| starting | 0.08 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.02 ms |
| System lock | 0.01 ms |
| Table lock | 0.01 ms |
| init | 0.04 ms |
| optimizing | 0.04 ms |
| statistics | 0.11 ms |
| preparing | 0.06 ms |
| executing | 0.01 ms |
| Sending data | 0.26 ms |
| end | 0.02 ms |
| query end | 0.02 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.02 ms |
| freeing items | 0.02 ms |
| updating status | 0.05 ms |
| cleaning up | 0.01 ms |
| # | Caller | File and line number |
|---|
| 6 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 5 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Application/SiteApplication.php:486 |
| 4 | Joomla\CMS\Application\SiteApplication->getTemplate() | JROOT/libraries/src/Application/SiteApplication.php:168 |
| 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:49 |
Query Time: 1.78 ms After last query: 4.36 ms Query memory: 0.028 MB Memory before query: 2.309 MB Rows returned: 39
SELECT `id`,`name`,`rules`,`parent_id`
FROM `j256_assets`
WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_akeeba','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_instajoom','com_installer','com_jmedia','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_sppagebuilder','com_tags','com_templates','com_users','com_weblinks','com_wrapper')
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | j256_assets | range | idx_asset_name | idx_asset_name | 202 | NULL | 40 | Using index condition |
| Status | Duration |
|---|
| starting | 0.09 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.06 ms |
| After opening tables | 0.02 ms |
| System lock | 0.02 ms |
| Table lock | 0.01 ms |
| init | 0.11 ms |
| optimizing | 0.03 ms |
| statistics | 0.24 ms |
| preparing | 0.06 ms |
| executing | 0.01 ms |
| Sending data | 0.75 ms |
| end | 0.02 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.02 ms |
| freeing items | 0.02 ms |
| updating status | 0.04 ms |
| cleaning up | 0.01 ms |
| # | Caller | File and line number |
|---|
| 20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 19 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Access/Access.php:429 |
| 18 | Joomla\CMS\Access\Access::preloadComponents() | JROOT/libraries/src/Access/Access.php:213 |
| 17 | Joomla\CMS\Access\Access::preload() | JROOT/libraries/src/Access/Access.php:531 |
| 16 | Joomla\CMS\Access\Access::getAssetRules() | JROOT/libraries/src/Access/Access.php:183 |
| 15 | Joomla\CMS\Access\Access::check() | JROOT/libraries/src/User/User.php:398 |
| 14 | Joomla\CMS\User\User->authorise() | JROOT/components/com_content/models/category.php:139 |
| 13 | ContentModelCategory->populateState() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457 |
| 12 | Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() | JROOT/libraries/src/MVC/View/CategoryView.php:116 |
| 11 | Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() | JROOT/components/com_content/views/category/view.html.php:75 |
| 10 | ContentViewCategory->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:49 |
Query Time: 1.85 ms After last query: 0.36 ms Query memory: 0.072 MB Memory before query: 2.359 MB Rows returned: 380
SELECT `id`,`name`,`rules`,`parent_id`
FROM `j256_assets`
WHERE `name` LIKE 'com_content.%' OR `name` = 'com_content' OR `parent_id` = 0
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | j256_assets | ALL | idx_asset_name,idx_parent_id | NO INDEX KEY COULD BE USED | NULL | NULL | 522 | Using where |
| Status | Duration |
|---|
| starting | 0.06 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| Table lock | 0.01 ms |
| init | 0.03 ms |
| optimizing | 0.03 ms |
| statistics | 0.10 ms |
| preparing | 0.07 ms |
| executing | 0.01 ms |
| Sending data | 1.02 ms |
| end | 0.02 ms |
| query end | 0.01 ms |
| closing tables | 0.02 ms |
| Unlocking tables | 0.02 ms |
| freeing items | 0.02 ms |
| updating status | 0.04 ms |
| cleaning up | 0.01 ms |
| # | Caller | File and line number |
|---|
| 20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 19 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Access/Access.php:359 |
| 18 | Joomla\CMS\Access\Access::preloadPermissions() | JROOT/libraries/src/Access/Access.php:226 |
| 17 | Joomla\CMS\Access\Access::preload() | JROOT/libraries/src/Access/Access.php:540 |
| 16 | Joomla\CMS\Access\Access::getAssetRules() | JROOT/libraries/src/Access/Access.php:183 |
| 15 | Joomla\CMS\Access\Access::check() | JROOT/libraries/src/User/User.php:398 |
| 14 | Joomla\CMS\User\User->authorise() | JROOT/components/com_content/models/category.php:139 |
| 13 | ContentModelCategory->populateState() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457 |
| 12 | Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() | JROOT/libraries/src/MVC/View/CategoryView.php:116 |
| 11 | Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() | JROOT/components/com_content/views/category/view.html.php:75 |
| 10 | ContentViewCategory->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:49 |
Query Time: 3.97 ms After last query: 2.07 ms Query memory: 0.048 MB Memory before query: 2.667 MB Rows returned: 17
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,(
SELECT COUNT(i.`id`)
FROM `j256_content` AS `i`
WHERE i.`catid` = c.id
AND i.state = 1) AS numitems
FROM `j256_categories` AS `s`
INNER JOIN `j256_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.published = 1
AND s.id = 19
ORDER BY c.lft
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | PRIMARY | s | const | PRIMARY,idx_left_right | PRIMARY | 4 | const | 1 | |
| 1 | PRIMARY | c | range | cat_idx,idx_left_right | idx_left_right | 4 | NULL | 20 | Using index condition; Using where |
| 2 | DEPENDENT SUBQUERY | i | ref | idx_state,idx_catid | idx_catid | 4 | igeopat.c.id | 2 | Using index condition; Using where |
| Status | Duration |
|---|
| starting | 0.19 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.05 ms |
| After opening tables | 0.02 ms |
| System lock | 0.01 ms |
| Table lock | 0.02 ms |
| init | 0.10 ms |
| optimizing | 0.09 ms |
| statistics | 0.17 ms |
| preparing | 0.02 ms |
| Unlocking tables | 0.05 ms |
| optimizing | 0.03 ms |
| statistics | 0.06 ms |
| preparing | 0.05 ms |
| executing | 0.01 ms |
| Sorting result | 0.01 ms |
| Sending data | 0.17 ms |
| executing | 0.02 ms |
| Sending data | 0.11 ms |
| executing | 0.02 ms |
| Sending data | 0.56 ms |
| executing | 0.02 ms |
| Sending data | 0.47 ms |
| executing | 0.02 ms |
| Sending data | 0.05 ms |
| executing | 0.01 ms |
| Sending data | 0.11 ms |
| executing | 0.02 ms |
| Sending data | 0.05 ms |
| executing | 0.01 ms |
| Sending data | 0.09 ms |
| executing | 0.02 ms |
| Sending data | 0.07 ms |
| executing | 0.02 ms |
| Sending data | 0.09 ms |
| executing | 0.02 ms |
| Sending data | 0.10 ms |
| executing | 0.02 ms |
| Sending data | 0.08 ms |
| executing | 0.02 ms |
| Sending data | 0.06 ms |
| executing | 0.02 ms |
| Sending data | 0.05 ms |
| executing | 0.01 ms |
| Sending data | 0.05 ms |
| executing | 0.01 ms |
| Sending data | 0.05 ms |
| executing | 0.01 ms |
| Sending data | 0.05 ms |
| executing | 0.01 ms |
| Sending data | 0.11 ms |
| end | 0.02 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.02 ms |
| freeing items | 0.02 ms |
| removing tmp table | 0.02 ms |
| freeing items | 0.02 ms |
| updating status | 0.05 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/src/Categories/Categories.php:324 |
| 15 | Joomla\CMS\Categories\Categories->_load() | JROOT/libraries/src/Categories/Categories.php:184 |
| 14 | Joomla\CMS\Categories\Categories->get() | JROOT/components/com_content/models/category.php:355 |
| 13 | ContentModelCategory->getCategory() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
| 12 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/libraries/src/MVC/View/CategoryView.php:122 |
| 11 | Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() | JROOT/components/com_content/views/category/view.html.php:75 |
| 10 | ContentViewCategory->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:49 |
Query Time: 2.38 ms After last query: 1.46 ms Query memory: 0.064 MB Memory before query: 2.780 MB Rows returned: 10
SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN c.published = 2
AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum / v.rating_count, 0), 0), 0) AS rating,
COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
FROM j256_content AS a
LEFT JOIN j256_categories AS c
ON c.id = a.catid
LEFT JOIN j256_users AS ua
ON ua.id = a.created_by
LEFT JOIN j256_users AS uam
ON uam.id = a.modified_by
LEFT JOIN j256_categories as parent
ON parent.id = c.parent_id
LEFT JOIN j256_content_rating AS v
ON a.id = v.content_id
WHERE c.published = 1
AND a.state IN (0,1,2)
AND a.catid = 19
ORDER BY c.lft, a.ordering, a.created
LIMIT 40, 10
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | c | const | PRIMARY | PRIMARY | 4 | const | 1 | Using filesort |
| 1 | SIMPLE | a | ref | idx_state,idx_catid | idx_catid | 4 | const | 56 | Using where |
| 1 | SIMPLE | ua | eq_ref | PRIMARY | PRIMARY | 4 | igeopat.a.created_by | 1 | Using where |
| 1 | SIMPLE | uam | eq_ref | PRIMARY | PRIMARY | 4 | igeopat.a.modified_by | 1 | Using where |
| 1 | SIMPLE | parent | eq_ref | PRIMARY | PRIMARY | 4 | const | 1 | Using where |
| 1 | SIMPLE | v | eq_ref | PRIMARY | PRIMARY | 4 | igeopat.a.id | 1 | Using where |
| Status | Duration |
|---|
| starting | 0.24 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.07 ms |
| After opening tables | 0.02 ms |
| System lock | 0.01 ms |
| Table lock | 0.02 ms |
| init | 0.13 ms |
| optimizing | 0.10 ms |
| statistics | 0.17 ms |
| preparing | 0.02 ms |
| Unlocking tables | 0.07 ms |
| executing | 0.01 ms |
| Sorting result | 0.38 ms |
| Sending data | 0.75 ms |
| end | 0.02 ms |
| query end | 0.02 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.03 ms |
| freeing items | 0.03 ms |
| updating status | 0.04 ms |
| cleaning up | 0.01 ms |
| # | Caller | File and line number |
|---|
| 18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 17 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 |
| 16 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:194 |
| 15 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/components/com_content/models/articles.php:576 |
| 14 | ContentModelArticles->getItems() | JROOT/components/com_content/models/category.php:253 |
| 13 | ContentModelCategory->getItems() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
| 12 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/libraries/src/MVC/View/CategoryView.php:144 |
| 11 | Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() | JROOT/components/com_content/views/category/view.html.php:75 |
| 10 | ContentViewCategory->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:49 |
Query Time: 1.29 ms After last query: 1.55 ms Query memory: 0.024 MB Memory before query: 2.953 MB Rows returned: 1
SELECT COUNT(*)
FROM j256_content AS a
LEFT JOIN j256_categories AS c
ON c.id = a.catid
LEFT JOIN j256_users AS ua
ON ua.id = a.created_by
LEFT JOIN j256_users AS uam
ON uam.id = a.modified_by
LEFT JOIN j256_categories as parent
ON parent.id = c.parent_id
LEFT JOIN j256_content_rating AS v
ON a.id = v.content_id
WHERE c.published = 1
AND a.state IN (0,1,2)
AND a.catid = 19
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | c | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| 1 | SIMPLE | a | ref | idx_state,idx_catid | idx_catid | 4 | const | 56 | Using where |
| Status | Duration |
|---|
| starting | 0.12 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.06 ms |
| After opening tables | 0.02 ms |
| System lock | 0.01 ms |
| Table lock | 0.02 ms |
| init | 0.05 ms |
| optimizing | 0.05 ms |
| statistics | 0.15 ms |
| preparing | 0.02 ms |
| Unlocking tables | 0.05 ms |
| executing | 0.02 ms |
| Sending data | 0.25 ms |
| end | 0.02 ms |
| query end | 0.02 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.03 ms |
| freeing items | 0.02 ms |
| updating status | 0.04 ms |
| cleaning up | 0.01 ms |
| # | Caller | File and line number |
|---|
| 18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
| 17 | JDatabaseDriver->loadResult() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:354 |
| 16 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount() | JROOT/libraries/src/MVC/Model/ListModel.php:289 |
| 15 | Joomla\CMS\MVC\Model\ListModel->getTotal() | JROOT/libraries/src/MVC/Model/ListModel.php:239 |
| 14 | Joomla\CMS\MVC\Model\ListModel->getPagination() | JROOT/components/com_content/models/category.php:265 |
| 13 | ContentModelCategory->getItems() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
| 12 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/libraries/src/MVC/View/CategoryView.php:144 |
| 11 | Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() | JROOT/components/com_content/views/category/view.html.php:75 |
| 10 | ContentViewCategory->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:49 |
Query Time: 0.94 ms After last query: 0.69 ms Query memory: 0.022 MB Memory before query: 2.957 MB Rows returned: 0
SELECT `m`.`tag_id`,`t`.*
FROM `j256_contentitem_tag_map` AS m
INNER JOIN `j256_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.category'
AND `m`.`content_item_id` = 19
AND `t`.`published` = 1
AND t.access IN (1,1,2,3,4)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | m | ALL | idx_tag_type | NO INDEX KEY COULD BE USED | NULL | NULL | 1 | Using where |
| 1 | SIMPLE | t | eq_ref | PRIMARY,tag_idx,idx_access | PRIMARY | 4 | igeopat.m.tag_id | 1 | Using where |
| Status | Duration |
|---|
| starting | 0.08 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.04 ms |
| After opening tables | 0.02 ms |
| System lock | 0.01 ms |
| Table lock | 0.01 ms |
| init | 0.06 ms |
| optimizing | 0.05 ms |
| statistics | 0.11 ms |
| preparing | 0.05 ms |
| executing | 0.01 ms |
| Sending data | 0.07 ms |
| end | 0.02 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.02 ms |
| freeing items | 0.02 ms |
| updating status | 0.07 ms |
| cleaning up | 0.02 ms |
| # | Caller | File and line number |
|---|
| 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 13 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Helper/TagsHelper.php:454 |
| 12 | Joomla\CMS\Helper\TagsHelper->getItemTags() | JROOT/libraries/src/MVC/View/CategoryView.php:229 |
| 11 | Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() | JROOT/components/com_content/views/category/view.html.php:75 |
| 10 | ContentViewCategory->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:49 |
Query Time: 1.60 ms After last query: 1.69 ms Query memory: 0.050 MB Memory before query: 2.998 MB Rows returned: 17
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 `j256_categories` AS `s`
INNER JOIN `j256_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) 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,4)
AND c.published = 1
AND s.id = 19
ORDER BY c.lft
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | s | const | PRIMARY,idx_left_right | PRIMARY | 4 | const | 1 | |
| 1 | SIMPLE | c | range | cat_idx,idx_access,idx_left_right | idx_left_right | 4 | NULL | 20 | Using index condition; Using where |
| Status | Duration |
|---|
| starting | 0.17 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.02 ms |
| System lock | 0.01 ms |
| Table lock | 0.01 ms |
| init | 0.08 ms |
| optimizing | 0.06 ms |
| statistics | 0.26 ms |
| preparing | 0.03 ms |
| Unlocking tables | 0.06 ms |
| executing | 0.01 ms |
| Sorting result | 0.01 ms |
| Sending data | 0.35 ms |
| end | 0.02 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.02 ms |
| freeing items | 0.02 ms |
| updating status | 0.05 ms |
| cleaning up | 0.01 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/administrator/components/com_fields/models/fields.php:203 |
| 17 | FieldsModelFields->getListQuery() | JROOT/libraries/src/MVC/Model/ListModel.php:140 |
| 16 | Joomla\CMS\MVC\Model\ListModel->_getListQuery() | JROOT/libraries/src/MVC/Model/ListModel.php:194 |
| 15 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/administrator/components/com_fields/helpers/fields.php:136 |
| 14 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:495 |
| 13 | PlgSystemFields->onContentPrepare() | 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/category/view.html.php:113 |
| 10 | ContentViewCategory->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:49 |
Query Time: 2.94 ms After last query: 0.51 ms Query memory: 0.025 MB Memory before query: 3.089 MB Rows returned: 0
SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM j256_fields AS a
LEFT JOIN `j256_languages` AS l
ON l.lang_code = a.language
LEFT JOIN j256_users AS uc
ON uc.id=a.checked_out
LEFT JOIN j256_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN j256_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN j256_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `j256_fields_categories` AS fc
ON fc.field_id = a.id
WHERE a.context = 'com_content.article'
AND (fc.category_id IS NULL OR fc.category_id IN (19,0,14))
AND a.access IN (1,1,2,3,4)
AND (a.group_id = 0 OR g.access IN (1,1,2,3,4))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering ASC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | a | ref | idx_state,idx_access,idx_context | idx_state | 1 | const | 1 | Using where; Using temporary; Using filesort |
| 1 | SIMPLE | l | eq_ref | idx_langcode | idx_langcode | 28 | igeopat.a.language | 1 | Using where |
| 1 | SIMPLE | uc | eq_ref | PRIMARY | PRIMARY | 4 | igeopat.a.checked_out | 1 | |
| 1 | SIMPLE | ag | eq_ref | PRIMARY | PRIMARY | 4 | igeopat.a.access | 1 | Using where |
| 1 | SIMPLE | ua | eq_ref | PRIMARY | PRIMARY | 4 | igeopat.a.created_user_id | 1 | Using where |
| 1 | SIMPLE | g | eq_ref | PRIMARY | PRIMARY | 4 | igeopat.a.group_id | 1 | Using where |
| 1 | SIMPLE | fc | ref | PRIMARY | PRIMARY | 4 | igeopat.a.id | 1 | Using where; Using index; Distinct |
| Status | Duration |
|---|
| starting | 0.17 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.07 ms |
| After opening tables | 0.02 ms |
| System lock | 0.02 ms |
| Table lock | 0.06 ms |
| init | 0.10 ms |
| optimizing | 0.07 ms |
| statistics | 0.18 ms |
| preparing | 0.10 ms |
| executing | 0.02 ms |
| Creating tmp table | 1.26 ms |
| Copying to tmp table | 0.07 ms |
| Sorting result | 0.05 ms |
| Sending data | 0.08 ms |
| end | 0.02 ms |
| removing tmp table | 0.19 ms |
| end | 0.02 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.03 ms |
| freeing items | 0.03 ms |
| updating status | 0.05 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/libraries/src/MVC/Model/BaseDatabaseModel.php:322 |
| 17 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/administrator/components/com_fields/models/fields.php:333 |
| 16 | FieldsModelFields->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:194 |
| 15 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/administrator/components/com_fields/helpers/fields.php:136 |
| 14 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:495 |
| 13 | PlgSystemFields->onContentPrepare() | 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/category/view.html.php:113 |
| 10 | ContentViewCategory->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:49 |
Query Time: 2.77 ms After last query: 11.78 ms Query memory: 0.029 MB Memory before query: 3.258 MB Rows returned: 0
SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM j256_fields AS a
LEFT JOIN `j256_languages` AS l
ON l.lang_code = a.language
LEFT JOIN j256_users AS uc
ON uc.id=a.checked_out
LEFT JOIN j256_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN j256_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN j256_fields_groups AS g
ON g.id = a.group_id
WHERE a.context = 'com_content.article'
AND a.access IN (1,1,2,3,4)
AND (a.group_id = 0 OR g.access IN (1,1,2,3,4))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering ASC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | a | ref | idx_state,idx_access,idx_context | idx_state | 1 | const | 1 | Using where; Using temporary; Using filesort |
| 1 | SIMPLE | l | eq_ref | idx_langcode | idx_langcode | 28 | igeopat.a.language | 1 | Using where |
| 1 | SIMPLE | uc | eq_ref | PRIMARY | PRIMARY | 4 | igeopat.a.checked_out | 1 | |
| 1 | SIMPLE | ag | eq_ref | PRIMARY | PRIMARY | 4 | igeopat.a.access | 1 | Using where |
| 1 | SIMPLE | ua | eq_ref | PRIMARY | PRIMARY | 4 | igeopat.a.created_user_id | 1 | Using where |
| 1 | SIMPLE | g | eq_ref | PRIMARY | PRIMARY | 4 | igeopat.a.group_id | 1 | Using where |
| Status | Duration |
|---|
| starting | 0.17 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.04 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.06 ms |
| After opening tables | 0.02 ms |
| System lock | 0.01 ms |
| Table lock | 0.02 ms |
| init | 0.09 ms |
| optimizing | 0.06 ms |
| statistics | 0.17 ms |
| preparing | 0.09 ms |
| executing | 0.02 ms |
| Creating tmp table | 1.15 ms |
| Copying to tmp table | 0.07 ms |
| Sorting result | 0.04 ms |
| Sending data | 0.07 ms |
| end | 0.02 ms |
| removing tmp table | 0.21 ms |
| end | 0.02 ms |
| query end | 0.02 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.03 ms |
| freeing items | 0.02 ms |
| updating status | 0.05 ms |
| cleaning up | 0.01 ms |
| # | Caller | File and line number |
|---|
| 29 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 28 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 |
| 27 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/administrator/components/com_fields/models/fields.php:333 |
| 26 | FieldsModelFields->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:194 |
| 25 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/administrator/components/com_fields/helpers/fields.php:136 |
| 24 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:495 |
| 23 | PlgSystemFields->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 |
| 22 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 21 | JEventDispatcher->trigger() | JROOT/libraries/cms/html/content.php:41 |
| 20 | JHtmlContent::prepare() | Same as call in the line below. |
| 19 | call_user_func_array() | JROOT/libraries/src/HTML/HTMLHelper.php:239 |
| 18 | Joomla\CMS\HTML\HTMLHelper::call() | JROOT/libraries/src/HTML/HTMLHelper.php:146 |
| 17 | Joomla\CMS\HTML\HTMLHelper::_() | JROOT/templates/beez3/html/com_content/category/blog_children.php:41 |
| 16 | include JROOT/templates/beez3/html/com_content/category/blog_children.php | JROOT/libraries/src/MVC/View/HtmlView.php:701 |
| 15 | Joomla\CMS\MVC\View\HtmlView->loadTemplate() | JROOT/templates/beez3/html/com_content/category/blog.php:104 |
| 14 | include JROOT/templates/beez3/html/com_content/category/blog.php | JROOT/libraries/src/MVC/View/HtmlView.php:701 |
| 13 | Joomla\CMS\MVC\View\HtmlView->loadTemplate() | JROOT/libraries/src/MVC/View/HtmlView.php:230 |
| 12 | Joomla\CMS\MVC\View\HtmlView->display() | JROOT/libraries/src/MVC/View/CategoryView.php:245 |
| 11 | Joomla\CMS\MVC\View\CategoryView->display() | JROOT/components/com_content/views/category/view.html.php:250 |
| 10 | ContentViewCategory->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:49 |
Query Time: 1.90 ms After last query: 5.19 ms Query memory: 0.024 MB Memory before query: 3.326 MB Rows returned: 9
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM j256_modules AS m
LEFT JOIN j256_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN j256_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-05-20 18:02:53')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-05-20 18:02:53')
AND m.access IN (1,1,2,3,4)
AND m.client_id = 0
AND (mm.menuid = 290 OR mm.menuid <= 0)
ORDER BY m.position, m.ordering
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | m | ref | PRIMARY,published,newsfeeds | published | 1 | const | 36 | Using index condition; Using where; Using filesort |
| 1 | SIMPLE | mm | ref | PRIMARY | PRIMARY | 4 | igeopat.m.id | 1 | Using where; Using index |
| 1 | SIMPLE | e | ref | element_clientid,element_folder_clientid | element_clientid | 403 | igeopat.m.module,const | 1 | Using index condition; Using where |
| Status | Duration |
|---|
| starting | 0.12 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.04 ms |
| After opening tables | 0.02 ms |
| System lock | 0.01 ms |
| Table lock | 0.01 ms |
| init | 0.09 ms |
| optimizing | 0.07 ms |
| statistics | 0.13 ms |
| preparing | 0.10 ms |
| executing | 0.01 ms |
| Sorting result | 0.42 ms |
| Sending data | 0.43 ms |
| end | 0.02 ms |
| query end | 0.02 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.02 ms |
| freeing items | 0.02 ms |
| updating status | 0.05 ms |
| cleaning up | 0.01 ms |
| # | Caller | File and line number |
|---|
| 15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 14 | JDatabaseDriver->loadObjectList() | Same as call in the line below. |
| 13 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 12 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/ModuleHelper.php:441 |
| 11 | Joomla\CMS\Helper\ModuleHelper::getModuleList() | JROOT/libraries/src/Helper/ModuleHelper.php:371 |
| 10 | Joomla\CMS\Helper\ModuleHelper::load() | JROOT/libraries/src/Helper/ModuleHelper.php:87 |
| 9 | Joomla\CMS\Helper\ModuleHelper::getModules() | JROOT/libraries/src/Document/HtmlDocument.php:601 |
| 8 | Joomla\CMS\Document\HtmlDocument->countModules() | JROOT/templates/beez3/index.php:18 |
| 7 | require JROOT/templates/beez3/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:49 |
Query Time: 2.83 ms After last query: 5.82 ms Query memory: 0.026 MB Memory before query: 3.373 MB Rows returned: 0
SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM j256_fields AS a
LEFT JOIN `j256_languages` AS l
ON l.lang_code = a.language
LEFT JOIN j256_users AS uc
ON uc.id=a.checked_out
LEFT JOIN j256_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN j256_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN j256_fields_groups AS g
ON g.id = a.group_id
WHERE a.context = 'mod_custom.content'
AND a.access IN (1,1,2,3,4)
AND (a.group_id = 0 OR g.access IN (1,1,2,3,4))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering ASC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | a | ref | idx_state,idx_access,idx_context | idx_state | 1 | const | 1 | Using where; Using temporary; Using filesort |
| 1 | SIMPLE | l | eq_ref | idx_langcode | idx_langcode | 28 | igeopat.a.language | 1 | Using where |
| 1 | SIMPLE | uc | eq_ref | PRIMARY | PRIMARY | 4 | igeopat.a.checked_out | 1 | |
| 1 | SIMPLE | ag | eq_ref | PRIMARY | PRIMARY | 4 | igeopat.a.access | 1 | Using where |
| 1 | SIMPLE | ua | eq_ref | PRIMARY | PRIMARY | 4 | igeopat.a.created_user_id | 1 | Using where |
| 1 | SIMPLE | g | eq_ref | PRIMARY | PRIMARY | 4 | igeopat.a.group_id | 1 | Using where |
| Status | Duration |
|---|
| starting | 0.17 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.06 ms |
| After opening tables | 0.02 ms |
| System lock | 0.01 ms |
| Table lock | 0.02 ms |
| init | 0.09 ms |
| optimizing | 0.06 ms |
| statistics | 0.20 ms |
| preparing | 0.09 ms |
| executing | 0.02 ms |
| Creating tmp table | 1.21 ms |
| Copying to tmp table | 0.07 ms |
| Sorting result | 0.05 ms |
| Sending data | 0.08 ms |
| end | 0.02 ms |
| removing tmp table | 0.18 ms |
| end | 0.02 ms |
| query end | 0.02 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.03 ms |
| freeing items | 0.02 ms |
| updating status | 0.07 ms |
| cleaning up | 0.02 ms |
| # | Caller | File and line number |
|---|
| 23 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 22 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 |
| 21 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/administrator/components/com_fields/models/fields.php:333 |
| 20 | FieldsModelFields->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:194 |
| 19 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/administrator/components/com_fields/helpers/fields.php:136 |
| 18 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:495 |
| 17 | PlgSystemFields->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 |
| 16 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 15 | JEventDispatcher->trigger() | JROOT/libraries/cms/html/content.php:41 |
| 14 | JHtmlContent::prepare() | Same as call in the line below. |
| 13 | call_user_func_array() | JROOT/libraries/src/HTML/HTMLHelper.php:239 |
| 12 | Joomla\CMS\HTML\HTMLHelper::call() | JROOT/libraries/src/HTML/HTMLHelper.php:111 |
| 11 | Joomla\CMS\HTML\HTMLHelper::_() | JROOT/modules/mod_custom/mod_custom.php:15 |
| 10 | include JROOT/modules/mod_custom/mod_custom.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
| 9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
| 8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
| 7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:511 |
| 6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:803 |
| 5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:577 |
| 4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1112 |
| 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:49 |
2 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `j256_assets`
2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `j256_extensions`
2 × SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM j256_fields AS a
LEFT JOIN `j256_languages` AS l
ON l.lang_code = a.language
LEFT JOIN j256_users AS uc
ON uc.id=a.checked_out
LEFT JOIN j256_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN j256_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN j256_fields_groups AS g
ON g.id = a.group_id
1 × SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM j256_fields AS a
LEFT JOIN `j256_languages` AS l
ON l.lang_code = a.language
LEFT JOIN j256_users AS uc
ON uc.id=a.checked_out
LEFT JOIN j256_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN j256_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN j256_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `j256_fields_categories` AS fc
ON fc.field_id = a.id
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 `j256_categories` AS `s`
INNER JOIN `j256_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
1 × SELECT `m`.`tag_id`,`t`.*
FROM `j256_contentitem_tag_map` AS m
INNER JOIN `j256_tags` AS t
ON `m`.`tag_id` = `t`.`id`
1 × SELECT COUNT(*)
FROM j256_content AS a
LEFT JOIN j256_categories AS c
ON c.id = a.catid
LEFT JOIN j256_users AS ua
ON ua.id = a.created_by
LEFT JOIN j256_users AS uam
ON uam.id = a.modified_by
LEFT JOIN j256_categories as parent
ON parent.id = c.parent_id
LEFT JOIN j256_content_rating AS v
ON a.id = v.content_id
1 × SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN c.published = 2
AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum / v.rating_count, 0), 0), 0) AS rating, COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
FROM j256_content AS a
LEFT JOIN j256_categories AS c
ON c.id = a.catid
LEFT JOIN j256_users AS ua
ON ua.id = a.created_by
LEFT JOIN j256_users AS uam
ON uam.id = a.modified_by
LEFT JOIN j256_categories as parent
ON parent.id = c.parent_id
LEFT JOIN j256_content_rating AS v
ON a.id = v.content_id
1 × SELECT `data`
FROM `j256_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,( SELECT COUNT(i.`id`)
FROM `j256_content` AS `i`
1 × SELECT id, home, template, s.params
FROM j256_template_styles as s
LEFT JOIN j256_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
1 × SELECT *
FROM j256_languages
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 j256_menu AS m
LEFT JOIN j256_extensions AS e
ON m.component_id = e.extension_id
1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM j256_extensions
1 × SELECT b.id
FROM j256_usergroups AS a
LEFT JOIN j256_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
1 × SELECT id, rules
FROM `j256_viewlevels
1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM j256_modules AS m
LEFT JOIN j256_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN j256_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
Los módulos son pequeños bloques de contenido que se pueden mostrar en las posiciones de una página web. Los menús del sitio se muestran en los módulos. El núcleo de Joomla! incluye 17 módulos independientes que van desde el acceso hasta la búsqueda de imágenes aleatorias. Cada módulo tiene un nombre que comienza mod_ pero cuando se muestra tiene un título. En las descripciones de esta sección, los títulos son los mismos que los nombres.
Plantillas de darle una apariencia a su sitio. Estas determinan el diseño, colores, tipos de letra, gráficos y otros aspectos del diseño que hacen que su sitio sea único. La instalación de Joomla! viene con cuatro plantillas empaquetadas previamente.