Query Time: 1.48 ms Query memory: 0.008 MB Memory before query: 1.469 MB
DELETE
FROM `jo362_session`
WHERE `time` < '1788150769'
EXPLAIN not possible on query: DELETE
FROM `jo362_session`
WHERE `time` < '1788150769'
| Status | Duration |
|---|
| Starting | 0.06 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| table lock | 0.01 ms |
| init for update | 0.07 ms |
| Updating | 0.04 ms |
| End of update loop | 0.01 ms |
| Query end | 0.00 ms |
| Commit | 0.01 ms |
| Query end | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Query end | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.01 ms |
| Updating status | 0.03 ms |
| Reset for next command | 0.00 ms |
| # | Caller | File and line number |
|---|
| 6 | JDatabaseDriverMysqli->execute() | JROOT/libraries/src/Application/CMSApplication.php:824 |
| 5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:133 |
| 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:415 |
| 2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 |
| 1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:49 |
Query Time: 1.43 ms After last query: 0.31 ms Query memory: 0.025 MB Memory before query: 1.492 MB Rows returned: 1
SELECT `data`
FROM `jo362_session`
WHERE `session_id` = 'm9qg6mq7ilr6ed471ovikclnr1'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | jo362_session | const | PRIMARY | PRIMARY | 766 | const | 1 | |
| Status | Duration |
|---|
| Starting | 0.07 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| After opening tables | 0.01 ms |
| System lock | 0.00 ms |
| table lock | 0.01 ms |
| init | 0.02 ms |
| Optimizing | 0.02 ms |
| Statistics | 0.05 ms |
| Preparing | 0.00 ms |
| Unlocking tables | 0.01 ms |
| Preparing | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.01 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| Query end | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.01 ms |
| Query end | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.01 ms |
| Updating status | 0.03 ms |
| Reset for next command | 0.00 ms |
| # | Caller | File and line number |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1730 |
| 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:660 |
| 9 | Joomla\CMS\Session\Session->_start() | JROOT/libraries/src/Session/Session.php:620 |
| 8 | Joomla\CMS\Session\Session->start() | JROOT/libraries/src/Session/Session.php:498 |
| 7 | Joomla\CMS\Session\Session->get() | JROOT/libraries/src/Session/Session.php:455 |
| 6 | Joomla\CMS\Session\Session->isNew() | JROOT/libraries/src/Application/CMSApplication.php:831 |
| 5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:133 |
| 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:415 |
| 2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 |
| 1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:49 |
Query Time: 1.71 ms After last query: 1.07 ms Query memory: 0.021 MB Memory before query: 1.629 MB Rows returned: 102
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `jo362_extensions`
WHERE `type` = 'component'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | jo362_extensions | ALL | extension | NO INDEX KEY COULD BE USED | NULL | NULL | 300 | Using where |
| Status | Duration |
|---|
| Starting | 0.06 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| After opening tables | 0.01 ms |
| System lock | 0.00 ms |
| table lock | 0.01 ms |
| init | 0.03 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.05 ms |
| Preparing | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.24 ms |
| End of update loop | 0.01 ms |
| Query end | 0.01 ms |
| Commit | 0.01 ms |
| Query end | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Query end | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.01 ms |
| Updating status | 0.03 ms |
| Reset for next command | 0.00 ms |
| # | Caller | File and line number |
|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 11 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Component/ComponentHelper.php:422 |
| 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:430 |
| 7 | Joomla\CMS\Component\ComponentHelper::load() | JROOT/libraries/src/Component/ComponentHelper.php:496 |
| 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:596 |
| 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:267 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:52 |
Query Time: 1.54 ms After last query: 0.79 ms Query memory: 0.015 MB Memory before query: 1.728 MB Rows returned: 5
SELECT id, rules
FROM `jo362_viewlevels`
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | jo362_viewlevels | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 5 | |
| Status | Duration |
|---|
| Starting | 0.08 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.07 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| table lock | 0.01 ms |
| init | 0.02 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.02 ms |
| Preparing | 0.08 ms |
| Executing | 0.01 ms |
| Sending data | 0.05 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| Query end | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.01 ms |
| Query end | 0.01 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.00 ms |
| Updating status | 0.03 ms |
| Reset for next command | 0.00 ms |
| # | Caller | File and line number |
|---|
| 10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1496 |
| 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:310 |
| 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:606 |
| 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:267 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:52 |
Query Time: 1.57 ms After last query: 0.23 ms Query memory: 0.015 MB Memory before query: 1.752 MB Rows returned: 1
SELECT b.id
FROM jo362_usergroups AS a
LEFT JOIN jo362_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 1
| 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 | 1 | Using where; Using index |
| Status | Duration |
|---|
| Starting | 0.07 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| After opening tables | 0.01 ms |
| System lock | 0.00 ms |
| table lock | 0.01 ms |
| init | 0.03 ms |
| Optimizing | 0.02 ms |
| Statistics | 0.08 ms |
| Preparing | 0.01 ms |
| Unlocking tables | 0.00 ms |
| Preparing | 0.02 ms |
| Executing | 0.00 ms |
| Sending data | 0.02 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| Query end | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Query end | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.01 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.00 ms |
| # | Caller | File and line number |
|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1540 |
| 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:310 |
| 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:606 |
| 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:267 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:52 |
Query Time: 1.89 ms After last query: 0.35 ms Query memory: 0.018 MB Memory before query: 1.790 MB Rows returned: 74
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM jo362_extensions
WHERE enabled = 1
AND type = 'plugin'
AND state IN (0,1)
AND access IN (1,1)
ORDER BY ordering
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | jo362_extensions | ALL | extension | NO INDEX KEY COULD BE USED | NULL | NULL | 300 | Using where; Using filesort |
| Status | Duration |
|---|
| Starting | 0.08 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| After opening tables | 0.01 ms |
| System lock | 0.00 ms |
| table lock | 0.01 ms |
| init | 0.04 ms |
| Optimizing | 0.02 ms |
| Statistics | 0.06 ms |
| Preparing | 0.02 ms |
| Sorting result | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.01 ms |
| Creating sort index | 0.33 ms |
| End of update loop | 0.01 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| Query end | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.01 ms |
| Query end | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.01 ms |
| Updating status | 0.03 ms |
| Reset for next command | 0.00 ms |
| # | Caller | File and line number |
|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 10 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Plugin/PluginHelper.php:343 |
| 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:348 |
| 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:606 |
| 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:267 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:52 |
Query Time: 3.12 ms After last query: 14.36 ms Query memory: 0.036 MB Memory before query: 2.452 MB Rows returned: 51
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 jo362_menu AS m
LEFT JOIN jo362_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 | 62 | Using index condition; Using where; Using filesort |
| 1 | SIMPLE | e | eq_ref | PRIMARY | PRIMARY | 4 | sudmerik_samerik.m.component_id | 1 | Using where |
| Status | Duration |
|---|
| Starting | 0.13 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.04 ms |
| Optimizing | 0.03 ms |
| Statistics | 0.07 ms |
| Preparing | 0.03 ms |
| Sorting result | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.02 ms |
| Creating sort index | 0.42 ms |
| End of update loop | 0.01 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| Query end | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.01 ms |
| Query end | 0.01 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.01 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.00 ms |
| # | Caller | File and line number |
|---|
| 19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 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:76 |
| 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:131 |
| 11 | Joomla\CMS\Menu\AbstractMenu::getInstance() | JROOT/libraries/src/Application/CMSApplication.php:446 |
| 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:64 |
| 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:551 |
| 6 | Joomla\CMS\Application\CMSApplication::getRouter() | JROOT/libraries/src/Application/SiteApplication.php:405 |
| 5 | Joomla\CMS\Application\SiteApplication::getRouter() | JROOT/libraries/src/Application/CMSApplication.php:1146 |
| 4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:798 |
| 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:267 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:52 |
Query Time: 1.51 ms After last query: 4.69 ms Query memory: 0.020 MB Memory before query: 3.019 MB Rows returned: 1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `jo362_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | jo362_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.01 ms |
| Opening tables | 0.02 ms |
| After opening tables | 0.01 ms |
| System lock | 0.00 ms |
| table lock | 0.01 ms |
| init | 0.03 ms |
| Optimizing | 0.02 ms |
| Statistics | 0.08 ms |
| Preparing | 0.02 ms |
| Executing | 0.00 ms |
| Sending data | 0.06 ms |
| End of update loop | 0.01 ms |
| Query end | 0.00 ms |
| Commit | 0.01 ms |
| Query end | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.01 ms |
| Query end | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.01 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.00 ms |
| # | Caller | File and line number |
|---|
| 15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1652 |
| 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:1116 |
| 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:267 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:52 |
Query Time: 2.44 ms After last query: 0.23 ms Query memory: 0.013 MB Memory before query: 3.021 MB
UPDATE `jo362_extensions`
SET `params` = '{\"mediaversion\":\"ba8e81e188809f21859c62128d6c4502\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'
EXPLAIN not possible on query: UPDATE `jo362_extensions`
SET `params` = '{\"mediaversion\":\"ba8e81e188809f21859c62128d6c4502\"}'
WHERE `type` = 'library' AND `element` = 'joomla'
| Status | Duration |
|---|
| Starting | 0.05 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| After opening tables | 0.01 ms |
| System lock | 0.00 ms |
| table lock | 0.00 ms |
| init for update | 0.08 ms |
| Updating | 0.07 ms |
| End of update loop | 0.01 ms |
| Query end | 0.00 ms |
| Commit | 1.02 ms |
| Query end | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.01 ms |
| Query end | 0.01 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.01 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.00 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:1116 |
| 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:267 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:52 |
Query Time: 1.36 ms After last query: 0.64 ms Query memory: 0.014 MB Memory before query: 3.115 MB Rows returned: 3
SELECT *
FROM jo362_languages
WHERE published=1
ORDER BY ordering ASC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | jo362_languages | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 3 | Using where; Using filesort |
| Status | Duration |
|---|
| Starting | 0.05 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.02 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| table lock | 0.01 ms |
| init | 0.02 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.01 ms |
| Preparing | 0.01 ms |
| Sorting result | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.01 ms |
| Creating sort index | 0.06 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| Query end | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Query end | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.01 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.00 ms |
| # | Caller | File and line number |
|---|
| 7 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 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:267 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:52 |
Query Time: 1.53 ms After last query: 0.44 ms Query memory: 0.010 MB Memory before query: 3.152 MB Rows returned: 5
SELECT id, home, template, s.params
FROM jo362_template_styles as s
LEFT JOIN jo362_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 | NO INDEX KEY COULD BE USED | NULL | NULL | 7 | Using where |
| 1 | SIMPLE | e | ref | element_clientid,element_folder_clientid,extension | element_clientid | 403 | sudmerik_samerik.s.template,const | 1 | Using index condition; Using where |
| Status | Duration |
|---|
| Starting | 0.09 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| After opening tables | 0.01 ms |
| System lock | 0.00 ms |
| table lock | 0.00 ms |
| init | 0.03 ms |
| Optimizing | 0.03 ms |
| Statistics | 0.07 ms |
| Preparing | 0.02 ms |
| Executing | 0.00 ms |
| Sending data | 0.07 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| Query end | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Query end | 0.01 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.01 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.00 ms |
| # | Caller | File and line number |
|---|
| 6 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 5 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Application/SiteApplication.php:488 |
| 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:267 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:52 |
Query Time: 1.79 ms After last query: 2.68 ms Query memory: 0.029 MB Memory before query: 3.455 MB Rows returned: 53
SELECT `id`,`name`,`rules`,`parent_id`
FROM `jo362_assets`
WHERE `name` IN ('root.1','com_mailto','com_wrapper','com_admin','com_banners','com_cache','com_categories','com_checkin','com_contact','com_cpanel','com_installer','com_languages','com_login','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_search','com_templates','com_content','com_config','com_redirect','com_users','com_finder','com_joomlaupdate','com_tags','com_contenthistory','com_ajax','com_postinstall','com_fields','com_activities','com_jcomments','com_ruralistas','com_dialogues','com_explorations','com_acymailing','com_links_pages','com_countries','com_iso_languages','com_on_paper','com_interv1ews','com_gallery_ipdrs','com_opinion_articles','com_chronoforms','com_printed','com_multimedia','com_landvoc','com_license','com_publication_type','com_memorias','com_associations','com_calendar')
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | jo362_assets | range | idx_asset_name | idx_asset_name | 202 | NULL | 54 | Using index condition |
| Status | Duration |
|---|
| Starting | 0.08 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| After opening tables | 0.01 ms |
| System lock | 0.00 ms |
| table lock | 0.01 ms |
| init | 0.05 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.10 ms |
| Preparing | 0.02 ms |
| Executing | 0.00 ms |
| Sending data | 0.31 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| Query end | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Query end | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.01 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.00 ms |
| # | Caller | File and line number |
|---|
| 20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 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:435 |
| 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:72 |
| 10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:42 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:381 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:356 |
| 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:267 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:52 |
Query Time: 4.16 ms After last query: 0.42 ms Query memory: 0.106 MB Memory before query: 3.562 MB Rows returned: 2063
SELECT `id`,`name`,`rules`,`parent_id`
FROM `jo362_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 | jo362_assets | ALL | idx_asset_name,idx_parent_id | NO INDEX KEY COULD BE USED | NULL | NULL | 3315 | Using where |
| Status | Duration |
|---|
| Starting | 0.05 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.02 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| table lock | 0.01 ms |
| init | 0.02 ms |
| Optimizing | 0.02 ms |
| Statistics | 0.07 ms |
| Preparing | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 2.53 ms |
| End of update loop | 0.01 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| Query end | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.01 ms |
| Query end | 0.01 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.01 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.00 ms |
| # | Caller | File and line number |
|---|
| 20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 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:435 |
| 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:72 |
| 10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:42 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:381 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:356 |
| 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:267 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:52 |
Query Time: 1.80 ms After last query: 8.66 ms Query memory: 0.033 MB Memory before query: 7.112 MB Rows returned: 8
SHOW FULL COLUMNS
FROM `jo362_assets`
EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `jo362_assets`
| Status | Duration |
|---|
| Starting | 0.03 ms |
| checking permissions | 0.01 ms |
| closing tables | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.27 ms |
| After opening tables | 0.01 ms |
| System lock | 0.00 ms |
| table lock | 0.01 ms |
| init | 0.01 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.01 ms |
| Preparing | 0.01 ms |
| Executing | 0.00 ms |
| Filling schema table | 0.01 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.01 ms |
| checking permissions | 0.07 ms |
| closing tables | 0.01 ms |
| checking permissions | 0.00 ms |
| Executing | 0.00 ms |
| Sending data | 0.03 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| closing tables | 0.00 ms |
| Removing tmp table | 0.07 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Query end | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.00 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.00 ms |
| # | Caller | File and line number |
|---|
| 23 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 22 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:430 |
| 21 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/src/Table/Table.php:245 |
| 20 | Joomla\CMS\Table\Table->getFields() | JROOT/libraries/src/Table/Table.php:164 |
| 19 | Joomla\CMS\Table\Table->__construct() | JROOT/libraries/src/Table/Asset.php:61 |
| 18 | Joomla\CMS\Table\Asset->__construct() | JROOT/libraries/src/Access/Access.php:783 |
| 17 | Joomla\CMS\Access\Access::getAssetId() | JROOT/libraries/src/Access/Access.php:544 |
| 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:435 |
| 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:72 |
| 10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:42 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:381 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:356 |
| 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:267 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:52 |
Query Time: 1.41 ms After last query: 0.49 ms Query memory: 0.028 MB Memory before query: 7.173 MB Rows returned: 0
SELECT *
FROM jo362_assets
WHERE `name` = 'com_content.category.4'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | NULL | NULL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
| Status | Duration |
|---|
| Starting | 0.06 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| table lock | 0.01 ms |
| init | 0.04 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.05 ms |
| Preparing | 0.00 ms |
| Executing | 0.01 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.01 ms |
| Query end | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Query end | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.00 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.00 ms |
| # | Caller | File and line number |
|---|
| 20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1455 |
| 19 | JDatabaseDriver->loadAssoc() | JROOT/libraries/src/Table/Table.php:730 |
| 18 | Joomla\CMS\Table\Table->load() | JROOT/libraries/src/Access/Access.php:784 |
| 17 | Joomla\CMS\Access\Access::getAssetId() | JROOT/libraries/src/Access/Access.php:544 |
| 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:435 |
| 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:72 |
| 10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:42 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:381 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:356 |
| 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:267 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:52 |
Query Time: 1.32 ms After last query: 1.42 ms Query memory: 0.028 MB Memory before query: 7.220 MB Rows returned: 0
SELECT *
FROM jo362_assets
WHERE `name` = 'com_content.category.4'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | NULL | NULL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
| Status | Duration |
|---|
| Starting | 0.05 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| After opening tables | 0.01 ms |
| System lock | 0.00 ms |
| table lock | 0.01 ms |
| init | 0.02 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.04 ms |
| Preparing | 0.00 ms |
| Executing | 0.01 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| Query end | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Query end | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.00 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.00 ms |
| # | Caller | File and line number |
|---|
| 20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1455 |
| 19 | JDatabaseDriver->loadAssoc() | JROOT/libraries/src/Table/Table.php:730 |
| 18 | Joomla\CMS\Table\Table->load() | JROOT/libraries/src/Access/Access.php:784 |
| 17 | Joomla\CMS\Access\Access::getAssetId() | JROOT/libraries/src/Access/Access.php:544 |
| 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:435 |
| 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:72 |
| 10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:42 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:381 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:356 |
| 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:267 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:52 |
Query Time: 34.51 ms After last query: 0.87 ms Query memory: 0.033 MB Memory before query: 6.886 MB Rows returned: 16
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,COUNT(i.`id`) AS numitems
FROM jo362_categories as c
LEFT JOIN jo362_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
LEFT JOIN `jo362_content` AS i
ON i.`catid` = c.id
AND i.state = 1
WHERE (c.extension='com_content' OR c.extension='system')
AND c.published = 1
AND s.id=4
GROUP BY 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
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 | Using temporary; Using filesort |
| 1 | SIMPLE | c | ALL | cat_idx,idx_left_right | NO INDEX KEY COULD BE USED | NULL | NULL | 98 | Using where |
| 1 | SIMPLE | i | ref | idx_state,idx_catid | idx_catid | 4 | sudmerik_samerik.c.id | 42 | Using where |
| Status | Duration |
|---|
| Starting | 0.16 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.04 ms |
| After opening tables | 0.01 ms |
| System lock | 0.00 ms |
| table lock | 0.00 ms |
| init | 0.07 ms |
| Optimizing | 0.03 ms |
| Statistics | 0.13 ms |
| Preparing | 0.01 ms |
| Unlocking tables | 0.00 ms |
| Preparing | 0.03 ms |
| Creating tmp table | 0.06 ms |
| Sorting result | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 32.49 ms |
| Creating sort index | 0.10 ms |
| Removing tmp table | 0.11 ms |
| Creating sort index | 0.01 ms |
| End of update loop | 0.01 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| Query end | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.01 ms |
| Query end | 0.01 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.02 ms |
| Updating status | 0.03 ms |
| Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 16 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Categories/Categories.php:305 |
| 15 | Joomla\CMS\Categories\Categories->_load() | JROOT/libraries/src/Categories/Categories.php:186 |
| 14 | Joomla\CMS\Categories\Categories->get() | JROOT/components/com_content/models/category.php:355 |
| 13 | ContentModelCategory->getCategory() | JROOT/libraries/src/MVC/View/HtmlView.php:423 |
| 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:72 |
| 10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:42 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:381 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:356 |
| 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:267 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:52 |
Query Time: 1.33 ms After last query: 1.66 ms Query memory: 0.028 MB Memory before query: 7.419 MB Rows returned: 0
SELECT *
FROM jo362_assets
WHERE `name` = 'com_content.category.4'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | NULL | NULL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
| Status | Duration |
|---|
| Starting | 0.04 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.02 ms |
| After opening tables | 0.01 ms |
| System lock | 0.00 ms |
| table lock | 0.01 ms |
| init | 0.02 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.04 ms |
| Preparing | 0.00 ms |
| Executing | 0.01 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| Query end | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Query end | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.00 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.00 ms |
| # | Caller | File and line number |
|---|
| 20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1455 |
| 19 | JDatabaseDriver->loadAssoc() | JROOT/libraries/src/Table/Table.php:730 |
| 18 | Joomla\CMS\Table\Table->load() | JROOT/libraries/src/Access/Access.php:784 |
| 17 | Joomla\CMS\Access\Access::getAssetId() | JROOT/libraries/src/Access/Access.php:544 |
| 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:364 |
| 13 | ContentModelCategory->getCategory() | JROOT/libraries/src/MVC/View/HtmlView.php:423 |
| 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:72 |
| 10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:42 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:381 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:356 |
| 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:267 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:52 |
Query Time: 253.25 ms After last query: 1.20 ms Query memory: 0.045 MB Memory before query: 7.120 MB Rows returned: 9
SELECT DISTINCT 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 jo362_content AS a
LEFT JOIN jo362_categories AS c
ON c.id = a.catid
LEFT JOIN jo362_users AS ua
ON ua.id = a.created_by
LEFT JOIN jo362_users AS uam
ON uam.id = a.modified_by
LEFT JOIN jo362_categories as parent
ON parent.id = c.parent_id
LEFT JOIN jo362_content_rating AS v
ON a.id = v.content_id
WHERE a.access IN (1,1)
AND c.access IN (1,1)
AND c.published = 1
AND a.state = 1
AND (a.catid = 4 OR a.catid IN (
SELECT sub.id
FROM jo362_categories as sub
INNER JOIN jo362_categories as this
ON sub.lft > this.lft
AND sub.rgt < this.rgt
WHERE this.id = 4))
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-08-31 04:47:49')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-08-31 04:47:49')
ORDER BY
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END DESC , a.created
LIMIT 2460, 9
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | PRIMARY | c | ALL | PRIMARY,idx_access | NO INDEX KEY COULD BE USED | NULL | NULL | 98 | Using where; Using temporary; Using filesort |
| 1 | PRIMARY | a | ref | idx_access,idx_state,idx_catid | idx_catid | 4 | sudmerik_samerik.c.id | 42 | Using index condition; Using where |
| 1 | PRIMARY | ua | eq_ref | PRIMARY | PRIMARY | 4 | sudmerik_samerik.a.created_by | 1 | Using where |
| 1 | PRIMARY | uam | eq_ref | PRIMARY | PRIMARY | 4 | sudmerik_samerik.a.modified_by | 1 | Using where |
| 1 | PRIMARY | parent | eq_ref | PRIMARY | PRIMARY | 4 | sudmerik_samerik.c.parent_id | 1 | Using where |
| 1 | PRIMARY | v | eq_ref | PRIMARY | PRIMARY | 4 | sudmerik_samerik.a.id | 1 | Using where |
| 2 | MATERIALIZED | this | const | PRIMARY,idx_left_right | PRIMARY | 4 | const | 1 | |
| 2 | MATERIALIZED | sub | range | PRIMARY,idx_left_right | idx_left_right | 4 | NULL | 93 | Using where; Using index |
| Status | Duration |
|---|
| Starting | 0.20 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.07 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| table lock | 0.01 ms |
| init | 0.10 ms |
| Optimizing | 0.08 ms |
| Statistics | 0.16 ms |
| Preparing | 0.03 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.07 ms |
| Preparing | 0.02 ms |
| Creating tmp table | 0.06 ms |
| Sorting result | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.08 ms |
| Executing | 0.00 ms |
| Sending data | 230.34 ms |
| Creating sort index | 15.37 ms |
| Removing tmp table | 5.24 ms |
| Creating sort index | 0.03 ms |
| End of update loop | 0.02 ms |
| Query end | 0.01 ms |
| Commit | 0.01 ms |
| Query end | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.01 ms |
| Query end | 0.01 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.01 ms |
| Removing tmp table | 0.01 ms |
| Freeing items | 0.02 ms |
| Removing tmp table | 0.00 ms |
| Freeing items | 0.02 ms |
| Updating status | 0.03 ms |
| Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 17 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 |
| 16 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:187 |
| 15 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/components/com_content/models/articles.php:556 |
| 14 | ContentModelArticles->getItems() | JROOT/components/com_content/models/category.php:253 |
| 13 | ContentModelCategory->getItems() | JROOT/libraries/src/MVC/View/HtmlView.php:423 |
| 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:72 |
| 10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:42 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:381 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:356 |
| 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:267 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:52 |
Query Time: 23.45 ms After last query: 2.48 ms Query memory: 0.024 MB Memory before query: 7.488 MB Rows returned: 1
SELECT COUNT(*)
FROM jo362_content AS a
LEFT JOIN jo362_categories AS c
ON c.id = a.catid
LEFT JOIN jo362_users AS ua
ON ua.id = a.created_by
LEFT JOIN jo362_users AS uam
ON uam.id = a.modified_by
LEFT JOIN jo362_categories as parent
ON parent.id = c.parent_id
LEFT JOIN jo362_content_rating AS v
ON a.id = v.content_id
WHERE a.access IN (1,1)
AND c.access IN (1,1)
AND c.published = 1
AND a.state = 1
AND (a.catid = 4 OR a.catid IN (
SELECT sub.id
FROM jo362_categories as sub
INNER JOIN jo362_categories as this
ON sub.lft > this.lft
AND sub.rgt < this.rgt
WHERE this.id = 4))
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-08-31 04:47:49')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-08-31 04:47:49')
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | PRIMARY | c | ALL | PRIMARY,idx_access | NO INDEX KEY COULD BE USED | NULL | NULL | 98 | Using where |
| 1 | PRIMARY | a | ref | idx_access,idx_state,idx_catid | idx_catid | 4 | sudmerik_samerik.c.id | 42 | Using index condition; Using where |
| 2 | MATERIALIZED | this | const | PRIMARY,idx_left_right | PRIMARY | 4 | const | 1 | |
| 2 | MATERIALIZED | sub | range | PRIMARY,idx_left_right | idx_left_right | 4 | NULL | 93 | Using where; Using index |
| Status | Duration |
|---|
| Starting | 0.09 ms |
| checking permissions | 0.05 ms |
| Opening tables | 0.05 ms |
| After opening tables | 0.01 ms |
| System lock | 0.00 ms |
| table lock | 0.01 ms |
| init | 0.04 ms |
| Optimizing | 0.03 ms |
| Statistics | 0.08 ms |
| Preparing | 0.01 ms |
| Unlocking tables | 0.00 ms |
| Preparing | 0.03 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.07 ms |
| Preparing | 0.02 ms |
| Executing | 0.00 ms |
| Sending data | 0.10 ms |
| Executing | 0.00 ms |
| Sending data | 21.60 ms |
| End of update loop | 0.03 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| Query end | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.01 ms |
| Query end | 0.01 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.01 ms |
| Removing tmp table | 0.01 ms |
| Freeing items | 0.01 ms |
| Removing tmp table | 0.00 ms |
| Freeing items | 0.01 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1730 |
| 17 | JDatabaseDriver->loadResult() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:335 |
| 16 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount() | JROOT/libraries/src/MVC/Model/ListModel.php:282 |
| 15 | Joomla\CMS\MVC\Model\ListModel->getTotal() | JROOT/libraries/src/MVC/Model/ListModel.php:232 |
| 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:423 |
| 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:72 |
| 10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:42 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:381 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:356 |
| 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:267 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:52 |
Query Time: 2.62 ms After last query: 0.81 ms Query memory: 0.027 MB Memory before query: 7.516 MB Rows returned: 0
SELECT `m`.`tag_id`,`t`.*
FROM `jo362_contentitem_tag_map` AS m
INNER JOIN `jo362_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.category'
AND `m`.`content_item_id` = 4
AND `t`.`published` = 1
AND t.access IN (1,1)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | t | ALL | PRIMARY,tag_idx,idx_access | NO INDEX KEY COULD BE USED | NULL | NULL | 360 | Using where |
| 1 | SIMPLE | m | ref | idx_tag_type | idx_tag_type | 4 | sudmerik_samerik.t.id | 8 | Using index condition; Using where |
| Status | Duration |
|---|
| Starting | 0.06 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| After opening tables | 0.01 ms |
| System lock | 0.00 ms |
| table lock | 0.01 ms |
| init | 0.04 ms |
| Optimizing | 0.02 ms |
| Statistics | 0.06 ms |
| Preparing | 0.02 ms |
| Executing | 0.00 ms |
| Sending data | 1.19 ms |
| End of update loop | 0.02 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| Query end | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.01 ms |
| Query end | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.01 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.00 ms |
| # | Caller | File and line number |
|---|
| 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 13 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Helper/TagsHelper.php:454 |
| 12 | Joomla\CMS\Helper\TagsHelper->getItemTags() | JROOT/libraries/src/MVC/View/CategoryView.php:226 |
| 11 | Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() | JROOT/components/com_content/views/category/view.html.php:72 |
| 10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:42 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:381 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:356 |
| 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:267 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:52 |
Query Time: 1.63 ms After last query: 1.76 ms Query memory: 0.036 MB Memory before query: 7.740 MB Rows returned: 8
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 jo362_categories as c
LEFT JOIN jo362_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id=14
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 | ALL | cat_idx,idx_access,idx_left_right | NO INDEX KEY COULD BE USED | NULL | NULL | 98 | Using where; Using filesort |
| Status | Duration |
|---|
| Starting | 0.11 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| After opening tables | 0.01 ms |
| System lock | 0.00 ms |
| table lock | 0.00 ms |
| init | 0.04 ms |
| Optimizing | 0.02 ms |
| Statistics | 0.07 ms |
| Preparing | 0.00 ms |
| Unlocking tables | 0.00 ms |
| Preparing | 0.02 ms |
| Sorting result | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.02 ms |
| Creating sort index | 0.12 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| Query end | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Query end | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.01 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.00 ms |
| # | Caller | File and line number |
|---|
| 22 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 21 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Categories/Categories.php:305 |
| 20 | Joomla\CMS\Categories\Categories->_load() | JROOT/libraries/src/Categories/Categories.php:186 |
| 19 | Joomla\CMS\Categories\Categories->get() | JROOT/administrator/components/com_fields/models/fields.php:197 |
| 18 | FieldsModelFields->getListQuery() | JROOT/libraries/src/MVC/Model/ListModel.php:133 |
| 17 | Joomla\CMS\MVC\Model\ListModel->_getListQuery() | JROOT/libraries/src/MVC/Model/ListModel.php:187 |
| 16 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/administrator/components/com_fields/helpers/fields.php:136 |
| 15 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:378 |
| 14 | PlgSystemFields->onContentPrepare() | Same as call in the line below. |
| 13 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:70 |
| 12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/category/view.html.php:108 |
| 10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:42 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:381 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:356 |
| 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:267 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:52 |
Query Time: 1.69 ms After last query: 0.51 ms Query memory: 0.032 MB Memory before query: 7.793 MB Rows returned: 1
SELECT 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
FROM jo362_fields AS a
LEFT JOIN `jo362_languages` AS l
ON l.lang_code = a.language
LEFT JOIN jo362_users AS uc
ON uc.id=a.checked_out
LEFT JOIN jo362_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN jo362_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN jo362_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `jo362_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 (14,0,4,3))
AND a.access IN (1,1)
AND (a.group_id = 0 OR g.access IN (1,1))
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 filesort |
| 1 | SIMPLE | l | eq_ref | idx_langcode | idx_langcode | 28 | sudmerik_samerik.a.language | 1 | Using where |
| 1 | SIMPLE | uc | eq_ref | PRIMARY | PRIMARY | 4 | sudmerik_samerik.a.checked_out | 1 | |
| 1 | SIMPLE | ag | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| 1 | SIMPLE | ua | eq_ref | PRIMARY | PRIMARY | 4 | sudmerik_samerik.a.created_user_id | 1 | Using where |
| 1 | SIMPLE | g | eq_ref | PRIMARY | PRIMARY | 4 | sudmerik_samerik.a.group_id | 1 | Using where |
| 1 | SIMPLE | fc | ref | PRIMARY | PRIMARY | 4 | sudmerik_samerik.a.id | 1 | Using where; Using index |
| Status | Duration |
|---|
| Starting | 0.10 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.05 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| table lock | 0.01 ms |
| init | 0.05 ms |
| Optimizing | 0.03 ms |
| Statistics | 0.07 ms |
| Preparing | 0.03 ms |
| Sorting result | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.01 ms |
| Creating sort index | 0.07 ms |
| End of update loop | 0.01 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| Query end | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.01 ms |
| Query end | 0.01 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.01 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.00 ms |
| # | Caller | File and line number |
|---|
| 20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 19 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 |
| 18 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/administrator/components/com_fields/models/fields.php:327 |
| 17 | FieldsModelFields->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:187 |
| 16 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/administrator/components/com_fields/helpers/fields.php:136 |
| 15 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:378 |
| 14 | PlgSystemFields->onContentPrepare() | Same as call in the line below. |
| 13 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:70 |
| 12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/category/view.html.php:108 |
| 10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:42 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:381 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:356 |
| 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:267 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:52 |
Query Time: 1.27 ms After last query: 0.61 ms Query memory: 0.024 MB Memory before query: 7.910 MB Rows returned: 0
SELECT `field_id`,`value`
FROM `jo362_fields_values`
WHERE `field_id` IN (1)
AND `item_id` = '3098'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | jo362_fields_values | ref | idx_field_id,idx_item_id | idx_field_id | 4 | const | 1 | Using where |
| Status | Duration |
|---|
| Starting | 0.03 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| table lock | 0.01 ms |
| init | 0.01 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.03 ms |
| Preparing | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.01 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| Query end | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Query end | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.00 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.00 ms |
| # | Caller | File and line number |
|---|
| 18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 17 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_fields/models/field.php:708 |
| 16 | FieldsModelField->getFieldValues() | JROOT/administrator/components/com_fields/helpers/fields.php:158 |
| 15 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:378 |
| 14 | PlgSystemFields->onContentPrepare() | Same as call in the line below. |
| 13 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:70 |
| 12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/category/view.html.php:108 |
| 10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:42 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:381 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:356 |
| 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:267 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:52 |
Query Time: 1.28 ms After last query: 5.61 ms Query memory: 0.032 MB Memory before query: 8.234 MB Rows returned: 1
SELECT `alias`
FROM `jo362_content`
WHERE id = '3098'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | jo362_content | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| Status | Duration |
|---|
| Starting | 0.04 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.01 ms |
| System lock | 0.00 ms |
| table lock | 0.00 ms |
| init | 0.01 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.05 ms |
| Preparing | 0.00 ms |
| Unlocking tables | 0.00 ms |
| Preparing | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.01 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| Query end | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Query end | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.00 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.00 ms |
| # | Caller | File and line number |
|---|
| 26 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1730 |
| 25 | JDatabaseDriver->loadResult() | JROOT/components/com_content/router.php:125 |
| 24 | ContentRouter->getArticleSegment() | Same as call in the line below. |
| 23 | call_user_func_array() | JROOT/libraries/src/Component/Router/RouterView.php:120 |
| 22 | Joomla\CMS\Component\Router\RouterView->getPath() | JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 |
| 21 | Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() | JROOT/libraries/src/Component/Router/RouterView.php:222 |
| 20 | Joomla\CMS\Component\Router\RouterView->preprocess() | JROOT/libraries/src/Router/SiteRouter.php:669 |
| 19 | Joomla\CMS\Router\SiteRouter->processBuildRules() | JROOT/libraries/src/Router/Router.php:266 |
| 18 | Joomla\CMS\Router\Router->build() | JROOT/libraries/src/Router/SiteRouter.php:154 |
| 17 | Joomla\CMS\Router\SiteRouter->build() | JROOT/libraries/src/Router/Route.php:66 |
| 16 | Joomla\CMS\Router\Route::_() | JROOT/plugins/content/bt_socialshare/bt_socialshare.php:93 |
| 15 | plgContentBt_socialshare->buildHTML() | JROOT/plugins/content/bt_socialshare/bt_socialshare.php:350 |
| 14 | plgContentBt_socialshare->onContentAfterTitle() | Same as call in the line below. |
| 13 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:70 |
| 12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/category/view.html.php:113 |
| 10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:42 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:381 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:356 |
| 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:267 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:52 |
Query Time: 1.24 ms After last query: 0.25 ms Query memory: 0.031 MB Memory before query: 8.264 MB Rows returned: 1
SELECT alias
FROM jo362_content
WHERE id=3098
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | jo362_content | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| Status | Duration |
|---|
| Starting | 0.03 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| table lock | 0.00 ms |
| init | 0.01 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.02 ms |
| Preparing | 0.00 ms |
| Unlocking tables | 0.00 ms |
| Preparing | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.01 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| Query end | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Query end | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.00 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.00 ms |
| # | Caller | File and line number |
|---|
| 24 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1730 |
| 23 | JDatabaseDriver->loadResult() | JROOT/components/com_content/helpers/legacyrouter.php:140 |
| 22 | ContentRouterRulesLegacy->build() | JROOT/libraries/src/Component/Router/RouterView.php:244 |
| 21 | Joomla\CMS\Component\Router\RouterView->build() | JROOT/libraries/src/Router/SiteRouter.php:528 |
| 20 | Joomla\CMS\Router\SiteRouter->buildSefRoute() | JROOT/libraries/src/Router/SiteRouter.php:498 |
| 19 | Joomla\CMS\Router\SiteRouter->_buildSefRoute() | JROOT/libraries/src/Router/Router.php:281 |
| 18 | Joomla\CMS\Router\Router->build() | JROOT/libraries/src/Router/SiteRouter.php:154 |
| 17 | Joomla\CMS\Router\SiteRouter->build() | JROOT/libraries/src/Router/Route.php:66 |
| 16 | Joomla\CMS\Router\Route::_() | JROOT/plugins/content/bt_socialshare/bt_socialshare.php:93 |
| 15 | plgContentBt_socialshare->buildHTML() | JROOT/plugins/content/bt_socialshare/bt_socialshare.php:350 |
| 14 | plgContentBt_socialshare->onContentAfterTitle() | Same as call in the line below. |
| 13 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:70 |
| 12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/category/view.html.php:113 |
| 10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:42 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:381 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:356 |
| 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:267 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:52 |
Query Time: 1.70 ms After last query: 1.75 ms Query memory: 0.036 MB Memory before query: 8.345 MB Rows returned: 8
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 jo362_categories as c
LEFT JOIN jo362_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id=17
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 | ALL | cat_idx,idx_access,idx_left_right | NO INDEX KEY COULD BE USED | NULL | NULL | 98 | Using where; Using filesort |
| Status | Duration |
|---|
| Starting | 0.10 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| After opening tables | 0.01 ms |
| System lock | 0.00 ms |
| table lock | 0.00 ms |
| init | 0.05 ms |
| Optimizing | 0.04 ms |
| Statistics | 0.08 ms |
| Preparing | 0.00 ms |
| Unlocking tables | 0.00 ms |
| Preparing | 0.02 ms |
| Sorting result | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.02 ms |
| Creating sort index | 0.12 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| Query end | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Query end | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.01 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.00 ms |
| # | Caller | File and line number |
|---|
| 22 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 21 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Categories/Categories.php:305 |
| 20 | Joomla\CMS\Categories\Categories->_load() | JROOT/libraries/src/Categories/Categories.php:186 |
| 19 | Joomla\CMS\Categories\Categories->get() | JROOT/administrator/components/com_fields/models/fields.php:197 |
| 18 | FieldsModelFields->getListQuery() | JROOT/libraries/src/MVC/Model/ListModel.php:133 |
| 17 | Joomla\CMS\MVC\Model\ListModel->_getListQuery() | JROOT/libraries/src/MVC/Model/ListModel.php:187 |
| 16 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/administrator/components/com_fields/helpers/fields.php:136 |
| 15 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:378 |
| 14 | PlgSystemFields->onContentPrepare() | Same as call in the line below. |
| 13 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:70 |
| 12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/category/view.html.php:108 |
| 10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:42 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:381 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:356 |
| 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:267 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:52 |
Query Time: 1.62 ms After last query: 0.44 ms Query memory: 0.032 MB Memory before query: 8.369 MB Rows returned: 1
SELECT 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
FROM jo362_fields AS a
LEFT JOIN `jo362_languages` AS l
ON l.lang_code = a.language
LEFT JOIN jo362_users AS uc
ON uc.id=a.checked_out
LEFT JOIN jo362_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN jo362_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN jo362_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `jo362_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 (17,0,4,3))
AND a.access IN (1,1)
AND (a.group_id = 0 OR g.access IN (1,1))
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 filesort |
| 1 | SIMPLE | l | eq_ref | idx_langcode | idx_langcode | 28 | sudmerik_samerik.a.language | 1 | Using where |
| 1 | SIMPLE | uc | eq_ref | PRIMARY | PRIMARY | 4 | sudmerik_samerik.a.checked_out | 1 | |
| 1 | SIMPLE | ag | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| 1 | SIMPLE | ua | eq_ref | PRIMARY | PRIMARY | 4 | sudmerik_samerik.a.created_user_id | 1 | Using where |
| 1 | SIMPLE | g | eq_ref | PRIMARY | PRIMARY | 4 | sudmerik_samerik.a.group_id | 1 | Using where |
| 1 | SIMPLE | fc | ref | PRIMARY | PRIMARY | 4 | sudmerik_samerik.a.id | 1 | Using where; Using index |
| Status | Duration |
|---|
| Starting | 0.10 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.04 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| table lock | 0.00 ms |
| init | 0.04 ms |
| Optimizing | 0.03 ms |
| Statistics | 0.07 ms |
| Preparing | 0.03 ms |
| Sorting result | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.01 ms |
| Creating sort index | 0.07 ms |
| End of update loop | 0.01 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| Query end | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Query end | 0.01 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.01 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.00 ms |
| # | Caller | File and line number |
|---|
| 20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 19 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 |
| 18 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/administrator/components/com_fields/models/fields.php:327 |
| 17 | FieldsModelFields->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:187 |
| 16 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/administrator/components/com_fields/helpers/fields.php:136 |
| 15 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:378 |
| 14 | PlgSystemFields->onContentPrepare() | Same as call in the line below. |
| 13 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:70 |
| 12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/category/view.html.php:108 |
| 10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:42 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:381 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:356 |
| 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:267 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:52 |
Query Time: 1.29 ms After last query: 0.23 ms Query memory: 0.024 MB Memory before query: 8.404 MB Rows returned: 0
SELECT `field_id`,`value`
FROM `jo362_fields_values`
WHERE `field_id` IN (1)
AND `item_id` = '3097'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | jo362_fields_values | ref | idx_field_id,idx_item_id | idx_field_id | 4 | const | 1 | Using where |
| Status | Duration |
|---|
| Starting | 0.03 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.01 ms |
| System lock | 0.00 ms |
| table lock | 0.00 ms |
| init | 0.01 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.03 ms |
| Preparing | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.01 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| Query end | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Query end | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.00 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.00 ms |
| # | Caller | File and line number |
|---|
| 18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 17 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_fields/models/field.php:708 |
| 16 | FieldsModelField->getFieldValues() | JROOT/administrator/components/com_fields/helpers/fields.php:158 |
| 15 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:378 |
| 14 | PlgSystemFields->onContentPrepare() | Same as call in the line below. |
| 13 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:70 |
| 12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/category/view.html.php:108 |
| 10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:42 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:381 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:356 |
| 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:267 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:52 |
Query Time: 1.31 ms After last query: 0.81 ms Query memory: 0.032 MB Memory before query: 8.437 MB Rows returned: 1
SELECT `alias`
FROM `jo362_content`
WHERE id = '3097'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | jo362_content | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| Status | Duration |
|---|
| Starting | 0.03 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.02 ms |
| After opening tables | 0.01 ms |
| System lock | 0.00 ms |
| table lock | 0.00 ms |
| init | 0.01 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.03 ms |
| Preparing | 0.00 ms |
| Unlocking tables | 0.00 ms |
| Preparing | 0.03 ms |
| Executing | 0.00 ms |
| Sending data | 0.01 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| Query end | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Query end | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.00 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.00 ms |
| # | Caller | File and line number |
|---|
| 26 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1730 |
| 25 | JDatabaseDriver->loadResult() | JROOT/components/com_content/router.php:125 |
| 24 | ContentRouter->getArticleSegment() | Same as call in the line below. |
| 23 | call_user_func_array() | JROOT/libraries/src/Component/Router/RouterView.php:120 |
| 22 | Joomla\CMS\Component\Router\RouterView->getPath() | JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 |
| 21 | Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() | JROOT/libraries/src/Component/Router/RouterView.php:222 |
| 20 | Joomla\CMS\Component\Router\RouterView->preprocess() | JROOT/libraries/src/Router/SiteRouter.php:669 |
| 19 | Joomla\CMS\Router\SiteRouter->processBuildRules() | JROOT/libraries/src/Router/Router.php:266 |
| 18 | Joomla\CMS\Router\Router->build() | JROOT/libraries/src/Router/SiteRouter.php:154 |
| 17 | Joomla\CMS\Router\SiteRouter->build() | JROOT/libraries/src/Router/Route.php:66 |
| 16 | Joomla\CMS\Router\Route::_() | JROOT/plugins/content/bt_socialshare/bt_socialshare.php:93 |
| 15 | plgContentBt_socialshare->buildHTML() | JROOT/plugins/content/bt_socialshare/bt_socialshare.php:350 |
| 14 | plgContentBt_socialshare->onContentAfterTitle() | Same as call in the line below. |
| 13 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:70 |
| 12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/category/view.html.php:113 |
| 10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:42 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:381 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:356 |
| 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:267 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:52 |
Query Time: 1.27 ms After last query: 0.34 ms Query memory: 0.031 MB Memory before query: 8.466 MB Rows returned: 1
SELECT alias
FROM jo362_content
WHERE id=3097
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | jo362_content | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| Status | Duration |
|---|
| Starting | 0.03 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| table lock | 0.00 ms |
| init | 0.01 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.03 ms |
| Preparing | 0.00 ms |
| Unlocking tables | 0.00 ms |
| Preparing | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.01 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| Query end | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Query end | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.00 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.00 ms |
| # | Caller | File and line number |
|---|
| 24 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1730 |
| 23 | JDatabaseDriver->loadResult() | JROOT/components/com_content/helpers/legacyrouter.php:140 |
| 22 | ContentRouterRulesLegacy->build() | JROOT/libraries/src/Component/Router/RouterView.php:244 |
| 21 | Joomla\CMS\Component\Router\RouterView->build() | JROOT/libraries/src/Router/SiteRouter.php:528 |
| 20 | Joomla\CMS\Router\SiteRouter->buildSefRoute() | JROOT/libraries/src/Router/SiteRouter.php:498 |
| 19 | Joomla\CMS\Router\SiteRouter->_buildSefRoute() | JROOT/libraries/src/Router/Router.php:281 |
| 18 | Joomla\CMS\Router\Router->build() | JROOT/libraries/src/Router/SiteRouter.php:154 |
| 17 | Joomla\CMS\Router\SiteRouter->build() | JROOT/libraries/src/Router/Route.php:66 |
| 16 | Joomla\CMS\Router\Route::_() | JROOT/plugins/content/bt_socialshare/bt_socialshare.php:93 |
| 15 | plgContentBt_socialshare->buildHTML() | JROOT/plugins/content/bt_socialshare/bt_socialshare.php:350 |
| 14 | plgContentBt_socialshare->onContentAfterTitle() | Same as call in the line below. |
| 13 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:70 |
| 12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/category/view.html.php:113 |
| 10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:42 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:381 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:356 |
| 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:267 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:52 |
Query Time: 1.74 ms After last query: 1.77 ms Query memory: 0.036 MB Memory before query: 8.510 MB Rows returned: 6
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 jo362_categories as c
LEFT JOIN jo362_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id=6
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 | ALL | cat_idx,idx_access,idx_left_right | NO INDEX KEY COULD BE USED | NULL | NULL | 98 | Using where; Using filesort |
| Status | Duration |
|---|
| Starting | 0.10 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.01 ms |
| System lock | 0.00 ms |
| table lock | 0.00 ms |
| init | 0.05 ms |
| Optimizing | 0.03 ms |
| Statistics | 0.09 ms |
| Preparing | 0.00 ms |
| Unlocking tables | 0.00 ms |
| Preparing | 0.02 ms |
| Sorting result | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.02 ms |
| Creating sort index | 0.14 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| Query end | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Query end | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.01 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.00 ms |
| # | Caller | File and line number |
|---|
| 22 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 21 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Categories/Categories.php:305 |
| 20 | Joomla\CMS\Categories\Categories->_load() | JROOT/libraries/src/Categories/Categories.php:186 |
| 19 | Joomla\CMS\Categories\Categories->get() | JROOT/administrator/components/com_fields/models/fields.php:197 |
| 18 | FieldsModelFields->getListQuery() | JROOT/libraries/src/MVC/Model/ListModel.php:133 |
| 17 | Joomla\CMS\MVC\Model\ListModel->_getListQuery() | JROOT/libraries/src/MVC/Model/ListModel.php:187 |
| 16 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/administrator/components/com_fields/helpers/fields.php:136 |
| 15 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:378 |
| 14 | PlgSystemFields->onContentPrepare() | Same as call in the line below. |
| 13 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:70 |
| 12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/category/view.html.php:108 |
| 10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:42 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:381 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:356 |
| 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:267 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:52 |
Query Time: 1.74 ms After last query: 0.50 ms Query memory: 0.033 MB Memory before query: 8.534 MB Rows returned: 1
SELECT 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
FROM jo362_fields AS a
LEFT JOIN `jo362_languages` AS l
ON l.lang_code = a.language
LEFT JOIN jo362_users AS uc
ON uc.id=a.checked_out
LEFT JOIN jo362_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN jo362_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN jo362_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `jo362_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 (6,0,4,3))
AND a.access IN (1,1)
AND (a.group_id = 0 OR g.access IN (1,1))
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 filesort |
| 1 | SIMPLE | l | eq_ref | idx_langcode | idx_langcode | 28 | sudmerik_samerik.a.language | 1 | Using where |
| 1 | SIMPLE | uc | eq_ref | PRIMARY | PRIMARY | 4 | sudmerik_samerik.a.checked_out | 1 | |
| 1 | SIMPLE | ag | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| 1 | SIMPLE | ua | eq_ref | PRIMARY | PRIMARY | 4 | sudmerik_samerik.a.created_user_id | 1 | Using where |
| 1 | SIMPLE | g | eq_ref | PRIMARY | PRIMARY | 4 | sudmerik_samerik.a.group_id | 1 | Using where |
| 1 | SIMPLE | fc | ref | PRIMARY | PRIMARY | 4 | sudmerik_samerik.a.id | 1 | Using where; Using index |
| Status | Duration |
|---|
| Starting | 0.10 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.05 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| table lock | 0.01 ms |
| init | 0.07 ms |
| Optimizing | 0.03 ms |
| Statistics | 0.09 ms |
| Preparing | 0.04 ms |
| Sorting result | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.02 ms |
| Creating sort index | 0.07 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| Query end | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.01 ms |
| Query end | 0.01 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.01 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.00 ms |
| # | Caller | File and line number |
|---|
| 20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 19 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 |
| 18 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/administrator/components/com_fields/models/fields.php:327 |
| 17 | FieldsModelFields->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:187 |
| 16 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/administrator/components/com_fields/helpers/fields.php:136 |
| 15 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:378 |
| 14 | PlgSystemFields->onContentPrepare() | Same as call in the line below. |
| 13 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:70 |
| 12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/category/view.html.php:108 |
| 10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:42 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:381 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:356 |
| 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:267 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:52 |
Query Time: 1.31 ms After last query: 0.29 ms Query memory: 0.024 MB Memory before query: 8.570 MB Rows returned: 0
SELECT `field_id`,`value`
FROM `jo362_fields_values`
WHERE `field_id` IN (1)
AND `item_id` = '3095'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | jo362_fields_values | ref | idx_field_id,idx_item_id | idx_field_id | 4 | const | 1 | Using where |
| Status | Duration |
|---|
| Starting | 0.04 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.02 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| table lock | 0.01 ms |
| init | 0.02 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.03 ms |
| Preparing | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.01 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| Query end | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.02 ms |
| Query end | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.00 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.00 ms |
| # | Caller | File and line number |
|---|
| 18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 17 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_fields/models/field.php:708 |
| 16 | FieldsModelField->getFieldValues() | JROOT/administrator/components/com_fields/helpers/fields.php:158 |
| 15 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:378 |
| 14 | PlgSystemFields->onContentPrepare() | Same as call in the line below. |
| 13 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:70 |
| 12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/category/view.html.php:108 |
| 10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:42 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:381 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:356 |
| 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:267 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:52 |
Query Time: 1.36 ms After last query: 0.99 ms Query memory: 0.032 MB Memory before query: 8.602 MB Rows returned: 1
SELECT `alias`
FROM `jo362_content`
WHERE id = '3095'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | jo362_content | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| Status | Duration |
|---|
| Starting | 0.04 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.02 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| table lock | 0.01 ms |
| init | 0.01 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.04 ms |
| Preparing | 0.00 ms |
| Unlocking tables | 0.00 ms |
| Preparing | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.01 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| Query end | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Query end | 0.04 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.00 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.00 ms |
| # | Caller | File and line number |
|---|
| 26 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1730 |
| 25 | JDatabaseDriver->loadResult() | JROOT/components/com_content/router.php:125 |
| 24 | ContentRouter->getArticleSegment() | Same as call in the line below. |
| 23 | call_user_func_array() | JROOT/libraries/src/Component/Router/RouterView.php:120 |
| 22 | Joomla\CMS\Component\Router\RouterView->getPath() | JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 |
| 21 | Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() | JROOT/libraries/src/Component/Router/RouterView.php:222 |
| 20 | Joomla\CMS\Component\Router\RouterView->preprocess() | JROOT/libraries/src/Router/SiteRouter.php:669 |
| 19 | Joomla\CMS\Router\SiteRouter->processBuildRules() | JROOT/libraries/src/Router/Router.php:266 |
| 18 | Joomla\CMS\Router\Router->build() | JROOT/libraries/src/Router/SiteRouter.php:154 |
| 17 | Joomla\CMS\Router\SiteRouter->build() | JROOT/libraries/src/Router/Route.php:66 |
| 16 | Joomla\CMS\Router\Route::_() | JROOT/plugins/content/bt_socialshare/bt_socialshare.php:93 |
| 15 | plgContentBt_socialshare->buildHTML() | JROOT/plugins/content/bt_socialshare/bt_socialshare.php:350 |
| 14 | plgContentBt_socialshare->onContentAfterTitle() | Same as call in the line below. |
| 13 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:70 |
| 12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/category/view.html.php:113 |
| 10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:42 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:381 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:356 |
| 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:267 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:52 |
Query Time: 1.30 ms After last query: 0.28 ms Query memory: 0.031 MB Memory before query: 8.631 MB Rows returned: 1
SELECT alias
FROM jo362_content
WHERE id=3095
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | jo362_content | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| Status | Duration |
|---|
| Starting | 0.03 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.02 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| table lock | 0.00 ms |
| init | 0.01 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.03 ms |
| Preparing | 0.00 ms |
| Unlocking tables | 0.00 ms |
| Preparing | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.01 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| Query end | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Query end | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.00 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.00 ms |
| # | Caller | File and line number |
|---|
| 24 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1730 |
| 23 | JDatabaseDriver->loadResult() | JROOT/components/com_content/helpers/legacyrouter.php:140 |
| 22 | ContentRouterRulesLegacy->build() | JROOT/libraries/src/Component/Router/RouterView.php:244 |
| 21 | Joomla\CMS\Component\Router\RouterView->build() | JROOT/libraries/src/Router/SiteRouter.php:528 |
| 20 | Joomla\CMS\Router\SiteRouter->buildSefRoute() | JROOT/libraries/src/Router/SiteRouter.php:498 |
| 19 | Joomla\CMS\Router\SiteRouter->_buildSefRoute() | JROOT/libraries/src/Router/Router.php:281 |
| 18 | Joomla\CMS\Router\Router->build() | JROOT/libraries/src/Router/SiteRouter.php:154 |
| 17 | Joomla\CMS\Router\SiteRouter->build() | JROOT/libraries/src/Router/Route.php:66 |
| 16 | Joomla\CMS\Router\Route::_() | JROOT/plugins/content/bt_socialshare/bt_socialshare.php:93 |
| 15 | plgContentBt_socialshare->buildHTML() | JROOT/plugins/content/bt_socialshare/bt_socialshare.php:350 |
| 14 | plgContentBt_socialshare->onContentAfterTitle() | Same as call in the line below. |
| 13 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:70 |
| 12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/category/view.html.php:113 |
| 10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:42 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:381 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:356 |
| 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:267 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:52 |
Query Time: 1.72 ms After last query: 1.31 ms Query memory: 0.036 MB Memory before query: 8.674 MB Rows returned: 8
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 jo362_categories as c
LEFT JOIN jo362_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id=8
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 | ALL | cat_idx,idx_access,idx_left_right | NO INDEX KEY COULD BE USED | NULL | NULL | 98 | Using where; Using filesort |
| Status | Duration |
|---|
| Starting | 0.12 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.01 ms |
| System lock | 0.00 ms |
| table lock | 0.00 ms |
| init | 0.05 ms |
| Optimizing | 0.03 ms |
| Statistics | 0.08 ms |
| Preparing | 0.00 ms |
| Unlocking tables | 0.00 ms |
| Preparing | 0.02 ms |
| Sorting result | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.02 ms |
| Creating sort index | 0.12 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| Query end | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Query end | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.01 ms |
| Updating status | 0.03 ms |
| Reset for next command | 0.00 ms |
| # | Caller | File and line number |
|---|
| 22 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 21 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Categories/Categories.php:305 |
| 20 | Joomla\CMS\Categories\Categories->_load() | JROOT/libraries/src/Categories/Categories.php:186 |
| 19 | Joomla\CMS\Categories\Categories->get() | JROOT/administrator/components/com_fields/models/fields.php:197 |
| 18 | FieldsModelFields->getListQuery() | JROOT/libraries/src/MVC/Model/ListModel.php:133 |
| 17 | Joomla\CMS\MVC\Model\ListModel->_getListQuery() | JROOT/libraries/src/MVC/Model/ListModel.php:187 |
| 16 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/administrator/components/com_fields/helpers/fields.php:136 |
| 15 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:378 |
| 14 | PlgSystemFields->onContentPrepare() | Same as call in the line below. |
| 13 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:70 |
| 12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/category/view.html.php:108 |
| 10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:42 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:381 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:356 |
| 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:267 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:52 |
Query Time: 1.72 ms After last query: 0.46 ms Query memory: 0.032 MB Memory before query: 8.697 MB Rows returned: 1
SELECT 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
FROM jo362_fields AS a
LEFT JOIN `jo362_languages` AS l
ON l.lang_code = a.language
LEFT JOIN jo362_users AS uc
ON uc.id=a.checked_out
LEFT JOIN jo362_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN jo362_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN jo362_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `jo362_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 (8,0,4,3))
AND a.access IN (1,1)
AND (a.group_id = 0 OR g.access IN (1,1))
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 filesort |
| 1 | SIMPLE | l | eq_ref | idx_langcode | idx_langcode | 28 | sudmerik_samerik.a.language | 1 | Using where |
| 1 | SIMPLE | uc | eq_ref | PRIMARY | PRIMARY | 4 | sudmerik_samerik.a.checked_out | 1 | |
| 1 | SIMPLE | ag | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| 1 | SIMPLE | ua | eq_ref | PRIMARY | PRIMARY | 4 | sudmerik_samerik.a.created_user_id | 1 | Using where |
| 1 | SIMPLE | g | eq_ref | PRIMARY | PRIMARY | 4 | sudmerik_samerik.a.group_id | 1 | Using where |
| 1 | SIMPLE | fc | ref | PRIMARY | PRIMARY | 4 | sudmerik_samerik.a.id | 1 | Using where; Using index |
| Status | Duration |
|---|
| Starting | 0.11 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.05 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| table lock | 0.01 ms |
| init | 0.05 ms |
| Optimizing | 0.03 ms |
| Statistics | 0.09 ms |
| Preparing | 0.03 ms |
| Sorting result | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.02 ms |
| Creating sort index | 0.10 ms |
| End of update loop | 0.01 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| Query end | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.01 ms |
| Query end | 0.01 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.01 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.00 ms |
| # | Caller | File and line number |
|---|
| 20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 19 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 |
| 18 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/administrator/components/com_fields/models/fields.php:327 |
| 17 | FieldsModelFields->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:187 |
| 16 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/administrator/components/com_fields/helpers/fields.php:136 |
| 15 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:378 |
| 14 | PlgSystemFields->onContentPrepare() | Same as call in the line below. |
| 13 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:70 |
| 12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/category/view.html.php:108 |
| 10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:42 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:381 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:356 |
| 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:267 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:52 |
Query Time: 1.27 ms After last query: 0.20 ms Query memory: 0.024 MB Memory before query: 8.733 MB Rows returned: 0
SELECT `field_id`,`value`
FROM `jo362_fields_values`
WHERE `field_id` IN (1)
AND `item_id` = '3094'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | jo362_fields_values | ref | idx_field_id,idx_item_id | idx_field_id | 4 | const | 1 | Using where |
| Status | Duration |
|---|
| Starting | 0.03 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| table lock | 0.00 ms |
| init | 0.02 ms |
| Optimizing | 0.02 ms |
| Statistics | 0.03 ms |
| Preparing | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.01 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| Query end | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Query end | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.00 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.00 ms |
| # | Caller | File and line number |
|---|
| 18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 17 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_fields/models/field.php:708 |
| 16 | FieldsModelField->getFieldValues() | JROOT/administrator/components/com_fields/helpers/fields.php:158 |
| 15 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:378 |
| 14 | PlgSystemFields->onContentPrepare() | Same as call in the line below. |
| 13 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:70 |
| 12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/category/view.html.php:108 |
| 10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:42 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:381 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:356 |
| 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:267 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:52 |
Query Time: 1.29 ms After last query: 0.74 ms Query memory: 0.032 MB Memory before query: 8.765 MB Rows returned: 1
SELECT `alias`
FROM `jo362_content`
WHERE id = '3094'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | jo362_content | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| Status | Duration |
|---|
| Starting | 0.03 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.02 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| table lock | 0.00 ms |
| init | 0.01 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.03 ms |
| Preparing | 0.00 ms |
| Unlocking tables | 0.00 ms |
| Preparing | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.01 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| Query end | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Query end | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.00 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.00 ms |
| # | Caller | File and line number |
|---|
| 26 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1730 |
| 25 | JDatabaseDriver->loadResult() | JROOT/components/com_content/router.php:125 |
| 24 | ContentRouter->getArticleSegment() | Same as call in the line below. |
| 23 | call_user_func_array() | JROOT/libraries/src/Component/Router/RouterView.php:120 |
| 22 | Joomla\CMS\Component\Router\RouterView->getPath() | JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 |
| 21 | Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() | JROOT/libraries/src/Component/Router/RouterView.php:222 |
| 20 | Joomla\CMS\Component\Router\RouterView->preprocess() | JROOT/libraries/src/Router/SiteRouter.php:669 |
| 19 | Joomla\CMS\Router\SiteRouter->processBuildRules() | JROOT/libraries/src/Router/Router.php:266 |
| 18 | Joomla\CMS\Router\Router->build() | JROOT/libraries/src/Router/SiteRouter.php:154 |
| 17 | Joomla\CMS\Router\SiteRouter->build() | JROOT/libraries/src/Router/Route.php:66 |
| 16 | Joomla\CMS\Router\Route::_() | JROOT/plugins/content/bt_socialshare/bt_socialshare.php:93 |
| 15 | plgContentBt_socialshare->buildHTML() | JROOT/plugins/content/bt_socialshare/bt_socialshare.php:350 |
| 14 | plgContentBt_socialshare->onContentAfterTitle() | Same as call in the line below. |
| 13 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:70 |
| 12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/category/view.html.php:113 |
| 10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:42 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:381 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:356 |
| 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:267 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:52 |
Query Time: 1.27 ms After last query: 0.23 ms Query memory: 0.031 MB Memory before query: 8.794 MB Rows returned: 1
SELECT alias
FROM jo362_content
WHERE id=3094
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | jo362_content | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| Status | Duration |
|---|
| Starting | 0.03 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| table lock | 0.00 ms |
| init | 0.01 ms |
| Optimizing | 0.02 ms |
| Statistics | 0.03 ms |
| Preparing | 0.00 ms |
| Unlocking tables | 0.00 ms |
| Preparing | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.01 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| Query end | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Query end | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.00 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.00 ms |
| # | Caller | File and line number |
|---|
| 24 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1730 |
| 23 | JDatabaseDriver->loadResult() | JROOT/components/com_content/helpers/legacyrouter.php:140 |
| 22 | ContentRouterRulesLegacy->build() | JROOT/libraries/src/Component/Router/RouterView.php:244 |
| 21 | Joomla\CMS\Component\Router\RouterView->build() | JROOT/libraries/src/Router/SiteRouter.php:528 |
| 20 | Joomla\CMS\Router\SiteRouter->buildSefRoute() | JROOT/libraries/src/Router/SiteRouter.php:498 |
| 19 | Joomla\CMS\Router\SiteRouter->_buildSefRoute() | JROOT/libraries/src/Router/Router.php:281 |
| 18 | Joomla\CMS\Router\Router->build() | JROOT/libraries/src/Router/SiteRouter.php:154 |
| 17 | Joomla\CMS\Router\SiteRouter->build() | JROOT/libraries/src/Router/Route.php:66 |
| 16 | Joomla\CMS\Router\Route::_() | JROOT/plugins/content/bt_socialshare/bt_socialshare.php:93 |
| 15 | plgContentBt_socialshare->buildHTML() | JROOT/plugins/content/bt_socialshare/bt_socialshare.php:350 |
| 14 | plgContentBt_socialshare->onContentAfterTitle() | Same as call in the line below. |
| 13 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:70 |
| 12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/category/view.html.php:113 |
| 10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:42 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:381 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:356 |
| 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:267 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:52 |
Query Time: 1.37 ms After last query: 1.28 ms Query memory: 0.024 MB Memory before query: 8.828 MB Rows returned: 0
SELECT `field_id`,`value`
FROM `jo362_fields_values`
WHERE `field_id` IN (1)
AND `item_id` = '3093'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | jo362_fields_values | ref | idx_field_id,idx_item_id | idx_field_id | 4 | const | 1 | Using where |
| Status | Duration |
|---|
| Starting | 0.03 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| table lock | 0.00 ms |
| init | 0.02 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.04 ms |
| Preparing | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.01 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| Query end | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Query end | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.00 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.00 ms |
| # | Caller | File and line number |
|---|
| 18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 17 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_fields/models/field.php:708 |
| 16 | FieldsModelField->getFieldValues() | JROOT/administrator/components/com_fields/helpers/fields.php:158 |
| 15 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:378 |
| 14 | PlgSystemFields->onContentPrepare() | Same as call in the line below. |
| 13 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:70 |
| 12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/category/view.html.php:108 |
| 10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:42 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:381 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:356 |
| 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:267 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:52 |
Query Time: 1.28 ms After last query: 0.71 ms Query memory: 0.032 MB Memory before query: 8.860 MB Rows returned: 1
SELECT `alias`
FROM `jo362_content`
WHERE id = '3093'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | jo362_content | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| Status | Duration |
|---|
| Starting | 0.04 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| table lock | 0.00 ms |
| init | 0.01 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.03 ms |
| Preparing | 0.00 ms |
| Unlocking tables | 0.00 ms |
| Preparing | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.01 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| Query end | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Query end | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.00 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.00 ms |
| # | Caller | File and line number |
|---|
| 26 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1730 |
| 25 | JDatabaseDriver->loadResult() | JROOT/components/com_content/router.php:125 |
| 24 | ContentRouter->getArticleSegment() | Same as call in the line below. |
| 23 | call_user_func_array() | JROOT/libraries/src/Component/Router/RouterView.php:120 |
| 22 | Joomla\CMS\Component\Router\RouterView->getPath() | JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 |
| 21 | Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() | JROOT/libraries/src/Component/Router/RouterView.php:222 |
| 20 | Joomla\CMS\Component\Router\RouterView->preprocess() | JROOT/libraries/src/Router/SiteRouter.php:669 |
| 19 | Joomla\CMS\Router\SiteRouter->processBuildRules() | JROOT/libraries/src/Router/Router.php:266 |
| 18 | Joomla\CMS\Router\Router->build() | JROOT/libraries/src/Router/SiteRouter.php:154 |
| 17 | Joomla\CMS\Router\SiteRouter->build() | JROOT/libraries/src/Router/Route.php:66 |
| 16 | Joomla\CMS\Router\Route::_() | JROOT/plugins/content/bt_socialshare/bt_socialshare.php:93 |
| 15 | plgContentBt_socialshare->buildHTML() | JROOT/plugins/content/bt_socialshare/bt_socialshare.php:350 |
| 14 | plgContentBt_socialshare->onContentAfterTitle() | Same as call in the line below. |
| 13 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:70 |
| 12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/category/view.html.php:113 |
| 10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:42 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:381 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:356 |
| 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:267 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:52 |
Query Time: 1.26 ms After last query: 0.20 ms Query memory: 0.031 MB Memory before query: 8.889 MB Rows returned: 1
SELECT alias
FROM jo362_content
WHERE id=3093
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | jo362_content | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| Status | Duration |
|---|
| Starting | 0.03 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| table lock | 0.00 ms |
| init | 0.01 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.02 ms |
| Preparing | 0.00 ms |
| Unlocking tables | 0.00 ms |
| Preparing | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.01 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| Query end | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Query end | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.00 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.00 ms |
| # | Caller | File and line number |
|---|
| 24 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1730 |
| 23 | JDatabaseDriver->loadResult() | JROOT/components/com_content/helpers/legacyrouter.php:140 |
| 22 | ContentRouterRulesLegacy->build() | JROOT/libraries/src/Component/Router/RouterView.php:244 |
| 21 | Joomla\CMS\Component\Router\RouterView->build() | JROOT/libraries/src/Router/SiteRouter.php:528 |
| 20 | Joomla\CMS\Router\SiteRouter->buildSefRoute() | JROOT/libraries/src/Router/SiteRouter.php:498 |
| 19 | Joomla\CMS\Router\SiteRouter->_buildSefRoute() | JROOT/libraries/src/Router/Router.php:281 |
| 18 | Joomla\CMS\Router\Router->build() | JROOT/libraries/src/Router/SiteRouter.php:154 |
| 17 | Joomla\CMS\Router\SiteRouter->build() | JROOT/libraries/src/Router/Route.php:66 |
| 16 | Joomla\CMS\Router\Route::_() | JROOT/plugins/content/bt_socialshare/bt_socialshare.php:93 |
| 15 | plgContentBt_socialshare->buildHTML() | JROOT/plugins/content/bt_socialshare/bt_socialshare.php:350 |
| 14 | plgContentBt_socialshare->onContentAfterTitle() | Same as call in the line below. |
| 13 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:70 |
| 12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/category/view.html.php:113 |
| 10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:42 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:381 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:356 |
| 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:267 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:52 |
Query Time: 1.80 ms After last query: 1.23 ms Query memory: 0.036 MB Memory before query: 8.933 MB Rows returned: 8
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 jo362_categories as c
LEFT JOIN jo362_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id=13
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 | ALL | cat_idx,idx_access,idx_left_right | NO INDEX KEY COULD BE USED | NULL | NULL | 98 | Using where; Using filesort |
| Status | Duration |
|---|
| Starting | 0.12 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.01 ms |
| System lock | 0.00 ms |
| table lock | 0.01 ms |
| init | 0.05 ms |
| Optimizing | 0.03 ms |
| Statistics | 0.12 ms |
| Preparing | 0.01 ms |
| Unlocking tables | 0.00 ms |
| Preparing | 0.02 ms |
| Sorting result | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.02 ms |
| Creating sort index | 0.14 ms |
| End of update loop | 0.01 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| Query end | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.01 ms |
| Query end | 0.01 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.01 ms |
| Updating status | 0.03 ms |
| Reset for next command | 0.00 ms |
| # | Caller | File and line number |
|---|
| 22 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 21 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Categories/Categories.php:305 |
| 20 | Joomla\CMS\Categories\Categories->_load() | JROOT/libraries/src/Categories/Categories.php:186 |
| 19 | Joomla\CMS\Categories\Categories->get() | JROOT/administrator/components/com_fields/models/fields.php:197 |
| 18 | FieldsModelFields->getListQuery() | JROOT/libraries/src/MVC/Model/ListModel.php:133 |
| 17 | Joomla\CMS\MVC\Model\ListModel->_getListQuery() | JROOT/libraries/src/MVC/Model/ListModel.php:187 |
| 16 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/administrator/components/com_fields/helpers/fields.php:136 |
| 15 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:378 |
| 14 | PlgSystemFields->onContentPrepare() | Same as call in the line below. |
| 13 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:70 |
| 12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/category/view.html.php:108 |
| 10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:42 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:381 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:356 |
| 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:267 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:52 |
Query Time: 1.77 ms After last query: 0.45 ms Query memory: 0.032 MB Memory before query: 8.956 MB Rows returned: 1
SELECT 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
FROM jo362_fields AS a
LEFT JOIN `jo362_languages` AS l
ON l.lang_code = a.language
LEFT JOIN jo362_users AS uc
ON uc.id=a.checked_out
LEFT JOIN jo362_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN jo362_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN jo362_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `jo362_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 (13,0,4,3))
AND a.access IN (1,1)
AND (a.group_id = 0 OR g.access IN (1,1))
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 filesort |
| 1 | SIMPLE | l | eq_ref | idx_langcode | idx_langcode | 28 | sudmerik_samerik.a.language | 1 | Using where |
| 1 | SIMPLE | uc | eq_ref | PRIMARY | PRIMARY | 4 | sudmerik_samerik.a.checked_out | 1 | |
| 1 | SIMPLE | ag | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| 1 | SIMPLE | ua | eq_ref | PRIMARY | PRIMARY | 4 | sudmerik_samerik.a.created_user_id | 1 | Using where |
| 1 | SIMPLE | g | eq_ref | PRIMARY | PRIMARY | 4 | sudmerik_samerik.a.group_id | 1 | Using where |
| 1 | SIMPLE | fc | ref | PRIMARY | PRIMARY | 4 | sudmerik_samerik.a.id | 1 | Using where; Using index |
| Status | Duration |
|---|
| Starting | 0.12 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.08 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| table lock | 0.01 ms |
| init | 0.05 ms |
| Optimizing | 0.04 ms |
| Statistics | 0.10 ms |
| Preparing | 0.04 ms |
| Sorting result | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.02 ms |
| Creating sort index | 0.08 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| Query end | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.01 ms |
| Query end | 0.01 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.01 ms |
| Updating status | 0.03 ms |
| Reset for next command | 0.00 ms |
| # | Caller | File and line number |
|---|
| 20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 19 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 |
| 18 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/administrator/components/com_fields/models/fields.php:327 |
| 17 | FieldsModelFields->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:187 |
| 16 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/administrator/components/com_fields/helpers/fields.php:136 |
| 15 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:378 |
| 14 | PlgSystemFields->onContentPrepare() | Same as call in the line below. |
| 13 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:70 |
| 12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/category/view.html.php:108 |
| 10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:42 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:381 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:356 |
| 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:267 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:52 |
Query Time: 1.27 ms After last query: 0.19 ms Query memory: 0.024 MB Memory before query: 8.992 MB Rows returned: 0
SELECT `field_id`,`value`
FROM `jo362_fields_values`
WHERE `field_id` IN (1)
AND `item_id` = '3092'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | jo362_fields_values | ref | idx_field_id,idx_item_id | idx_field_id | 4 | const | 1 | Using where |
| Status | Duration |
|---|
| Starting | 0.03 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| table lock | 0.00 ms |
| init | 0.02 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.03 ms |
| Preparing | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.01 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| Query end | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Query end | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.00 ms |
| Updating status | 0.03 ms |
| Reset for next command | 0.00 ms |
| # | Caller | File and line number |
|---|
| 18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 17 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_fields/models/field.php:708 |
| 16 | FieldsModelField->getFieldValues() | JROOT/administrator/components/com_fields/helpers/fields.php:158 |
| 15 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:378 |
| 14 | PlgSystemFields->onContentPrepare() | Same as call in the line below. |
| 13 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:70 |
| 12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/category/view.html.php:108 |
| 10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:42 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:381 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:356 |
| 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:267 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:52 |
Query Time: 1.36 ms After last query: 0.81 ms Query memory: 0.032 MB Memory before query: 9.024 MB Rows returned: 1
SELECT `alias`
FROM `jo362_content`
WHERE id = '3092'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | jo362_content | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| Status | Duration |
|---|
| Starting | 0.04 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.04 ms |
| After opening tables | 0.01 ms |
| System lock | 0.00 ms |
| table lock | 0.01 ms |
| init | 0.02 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.05 ms |
| Preparing | 0.00 ms |
| Unlocking tables | 0.00 ms |
| Preparing | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.01 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| Query end | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Query end | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.01 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.00 ms |
| # | Caller | File and line number |
|---|
| 26 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1730 |
| 25 | JDatabaseDriver->loadResult() | JROOT/components/com_content/router.php:125 |
| 24 | ContentRouter->getArticleSegment() | Same as call in the line below. |
| 23 | call_user_func_array() | JROOT/libraries/src/Component/Router/RouterView.php:120 |
| 22 | Joomla\CMS\Component\Router\RouterView->getPath() | JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 |
| 21 | Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() | JROOT/libraries/src/Component/Router/RouterView.php:222 |
| 20 | Joomla\CMS\Component\Router\RouterView->preprocess() | JROOT/libraries/src/Router/SiteRouter.php:669 |
| 19 | Joomla\CMS\Router\SiteRouter->processBuildRules() | JROOT/libraries/src/Router/Router.php:266 |
| 18 | Joomla\CMS\Router\Router->build() | JROOT/libraries/src/Router/SiteRouter.php:154 |
| 17 | Joomla\CMS\Router\SiteRouter->build() | JROOT/libraries/src/Router/Route.php:66 |
| 16 | Joomla\CMS\Router\Route::_() | JROOT/plugins/content/bt_socialshare/bt_socialshare.php:93 |
| 15 | plgContentBt_socialshare->buildHTML() | JROOT/plugins/content/bt_socialshare/bt_socialshare.php:350 |
| 14 | plgContentBt_socialshare->onContentAfterTitle() | Same as call in the line below. |
| 13 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:70 |
| 12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/category/view.html.php:113 |
| 10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:42 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:381 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:356 |
| 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:267 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:52 |
Query Time: 1.34 ms After last query: 0.22 ms Query memory: 0.031 MB Memory before query: 9.053 MB Rows returned: 1
SELECT alias
FROM jo362_content
WHERE id=3092
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | jo362_content | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| Status | Duration |
|---|
| Starting | 0.04 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.02 ms |
| After opening tables | 0.01 ms |
| System lock | 0.00 ms |
| table lock | 0.01 ms |
| init | 0.01 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.03 ms |
| Preparing | 0.00 ms |
| Unlocking tables | 0.00 ms |
| Preparing | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.01 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| Query end | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Query end | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.00 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.00 ms |
| # | Caller | File and line number |
|---|
| 24 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1730 |
| 23 | JDatabaseDriver->loadResult() | JROOT/components/com_content/helpers/legacyrouter.php:140 |
| 22 | ContentRouterRulesLegacy->build() | JROOT/libraries/src/Component/Router/RouterView.php:244 |
| 21 | Joomla\CMS\Component\Router\RouterView->build() | JROOT/libraries/src/Router/SiteRouter.php:528 |
| 20 | Joomla\CMS\Router\SiteRouter->buildSefRoute() | JROOT/libraries/src/Router/SiteRouter.php:498 |
| 19 | Joomla\CMS\Router\SiteRouter->_buildSefRoute() | JROOT/libraries/src/Router/Router.php:281 |
| 18 | Joomla\CMS\Router\Router->build() | JROOT/libraries/src/Router/SiteRouter.php:154 |
| 17 | Joomla\CMS\Router\SiteRouter->build() | JROOT/libraries/src/Router/Route.php:66 |
| 16 | Joomla\CMS\Router\Route::_() | JROOT/plugins/content/bt_socialshare/bt_socialshare.php:93 |
| 15 | plgContentBt_socialshare->buildHTML() | JROOT/plugins/content/bt_socialshare/bt_socialshare.php:350 |
| 14 | plgContentBt_socialshare->onContentAfterTitle() | Same as call in the line below. |
| 13 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:70 |
| 12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/category/view.html.php:113 |
| 10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:42 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:381 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:356 |
| 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:267 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:52 |
Query Time: 1.83 ms After last query: 1.45 ms Query memory: 0.036 MB Memory before query: 9.096 MB Rows returned: 8
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 jo362_categories as c
LEFT JOIN jo362_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id=7
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 | ALL | cat_idx,idx_access,idx_left_right | NO INDEX KEY COULD BE USED | NULL | NULL | 98 | Using where; Using filesort |
| Status | Duration |
|---|
| Starting | 0.13 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.01 ms |
| System lock | 0.00 ms |
| table lock | 0.01 ms |
| init | 0.06 ms |
| Optimizing | 0.03 ms |
| Statistics | 0.10 ms |
| Preparing | 0.00 ms |
| Unlocking tables | 0.00 ms |
| Preparing | 0.02 ms |
| Sorting result | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.02 ms |
| Creating sort index | 0.12 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| Query end | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Query end | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.01 ms |
| Updating status | 0.03 ms |
| Reset for next command | 0.00 ms |
| # | Caller | File and line number |
|---|
| 22 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 21 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Categories/Categories.php:305 |
| 20 | Joomla\CMS\Categories\Categories->_load() | JROOT/libraries/src/Categories/Categories.php:186 |
| 19 | Joomla\CMS\Categories\Categories->get() | JROOT/administrator/components/com_fields/models/fields.php:197 |
| 18 | FieldsModelFields->getListQuery() | JROOT/libraries/src/MVC/Model/ListModel.php:133 |
| 17 | Joomla\CMS\MVC\Model\ListModel->_getListQuery() | JROOT/libraries/src/MVC/Model/ListModel.php:187 |
| 16 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/administrator/components/com_fields/helpers/fields.php:136 |
| 15 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:378 |
| 14 | PlgSystemFields->onContentPrepare() | Same as call in the line below. |
| 13 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:70 |
| 12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/category/view.html.php:108 |
| 10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:42 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:381 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:356 |
| 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:267 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:52 |
Query Time: 1.71 ms After last query: 0.41 ms Query memory: 0.032 MB Memory before query: 9.119 MB Rows returned: 1
SELECT 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
FROM jo362_fields AS a
LEFT JOIN `jo362_languages` AS l
ON l.lang_code = a.language
LEFT JOIN jo362_users AS uc
ON uc.id=a.checked_out
LEFT JOIN jo362_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN jo362_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN jo362_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `jo362_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 (7,0,4,3))
AND a.access IN (1,1)
AND (a.group_id = 0 OR g.access IN (1,1))
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 filesort |
| 1 | SIMPLE | l | eq_ref | idx_langcode | idx_langcode | 28 | sudmerik_samerik.a.language | 1 | Using where |
| 1 | SIMPLE | uc | eq_ref | PRIMARY | PRIMARY | 4 | sudmerik_samerik.a.checked_out | 1 | |
| 1 | SIMPLE | ag | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| 1 | SIMPLE | ua | eq_ref | PRIMARY | PRIMARY | 4 | sudmerik_samerik.a.created_user_id | 1 | Using where |
| 1 | SIMPLE | g | eq_ref | PRIMARY | PRIMARY | 4 | sudmerik_samerik.a.group_id | 1 | Using where |
| 1 | SIMPLE | fc | ref | PRIMARY | PRIMARY | 4 | sudmerik_samerik.a.id | 1 | Using where; Using index |
| Status | Duration |
|---|
| Starting | 0.11 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.06 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| table lock | 0.01 ms |
| init | 0.05 ms |
| Optimizing | 0.04 ms |
| Statistics | 0.09 ms |
| Preparing | 0.04 ms |
| Sorting result | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.02 ms |
| Creating sort index | 0.10 ms |
| End of update loop | 0.01 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| Query end | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.01 ms |
| Query end | 0.01 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.01 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.00 ms |
| # | Caller | File and line number |
|---|
| 20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 19 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 |
| 18 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/administrator/components/com_fields/models/fields.php:327 |
| 17 | FieldsModelFields->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:187 |
| 16 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/administrator/components/com_fields/helpers/fields.php:136 |
| 15 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:378 |
| 14 | PlgSystemFields->onContentPrepare() | Same as call in the line below. |
| 13 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:70 |
| 12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/category/view.html.php:108 |
| 10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:42 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:381 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:356 |
| 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:267 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:52 |
Query Time: 1.31 ms After last query: 0.21 ms Query memory: 0.024 MB Memory before query: 9.155 MB Rows returned: 0
SELECT `field_id`,`value`
FROM `jo362_fields_values`
WHERE `field_id` IN (1)
AND `item_id` = '3091'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | jo362_fields_values | ref | idx_field_id,idx_item_id | idx_field_id | 4 | const | 1 | Using where |
| Status | Duration |
|---|
| Starting | 0.04 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| table lock | 0.00 ms |
| init | 0.02 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.03 ms |
| Preparing | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.01 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.01 ms |
| Query end | 0.01 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Query end | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.01 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.00 ms |
| # | Caller | File and line number |
|---|
| 18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 17 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_fields/models/field.php:708 |
| 16 | FieldsModelField->getFieldValues() | JROOT/administrator/components/com_fields/helpers/fields.php:158 |
| 15 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:378 |
| 14 | PlgSystemFields->onContentPrepare() | Same as call in the line below. |
| 13 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:70 |
| 12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/category/view.html.php:108 |
| 10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:42 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:381 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:356 |
| 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:267 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:52 |
Query Time: 1.33 ms After last query: 0.73 ms Query memory: 0.032 MB Memory before query: 9.187 MB Rows returned: 1
SELECT `alias`
FROM `jo362_content`
WHERE id = '3091'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | jo362_content | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| Status | Duration |
|---|
| Starting | 0.04 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.02 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| table lock | 0.00 ms |
| init | 0.02 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.04 ms |
| Preparing | 0.00 ms |
| Unlocking tables | 0.00 ms |
| Preparing | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.01 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| Query end | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Query end | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.00 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.00 ms |
| # | Caller | File and line number |
|---|
| 26 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1730 |
| 25 | JDatabaseDriver->loadResult() | JROOT/components/com_content/router.php:125 |
| 24 | ContentRouter->getArticleSegment() | Same as call in the line below. |
| 23 | call_user_func_array() | JROOT/libraries/src/Component/Router/RouterView.php:120 |
| 22 | Joomla\CMS\Component\Router\RouterView->getPath() | JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 |
| 21 | Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() | JROOT/libraries/src/Component/Router/RouterView.php:222 |
| 20 | Joomla\CMS\Component\Router\RouterView->preprocess() | JROOT/libraries/src/Router/SiteRouter.php:669 |
| 19 | Joomla\CMS\Router\SiteRouter->processBuildRules() | JROOT/libraries/src/Router/Router.php:266 |
| 18 | Joomla\CMS\Router\Router->build() | JROOT/libraries/src/Router/SiteRouter.php:154 |
| 17 | Joomla\CMS\Router\SiteRouter->build() | JROOT/libraries/src/Router/Route.php:66 |
| 16 | Joomla\CMS\Router\Route::_() | JROOT/plugins/content/bt_socialshare/bt_socialshare.php:93 |
| 15 | plgContentBt_socialshare->buildHTML() | JROOT/plugins/content/bt_socialshare/bt_socialshare.php:350 |
| 14 | plgContentBt_socialshare->onContentAfterTitle() | Same as call in the line below. |
| 13 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:70 |
| 12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/category/view.html.php:113 |
| 10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:42 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:381 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:356 |
| 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:267 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:52 |
Query Time: 1.26 ms After last query: 0.22 ms Query memory: 0.031 MB Memory before query: 9.216 MB Rows returned: 1
SELECT alias
FROM jo362_content
WHERE id=3091
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | jo362_content | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| Status | Duration |
|---|
| Starting | 0.03 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.02 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| table lock | 0.00 ms |
| init | 0.01 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.03 ms |
| Preparing | 0.00 ms |
| Unlocking tables | 0.00 ms |
| Preparing | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.01 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| Query end | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Query end | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.01 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.00 ms |
| # | Caller | File and line number |
|---|
| 24 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1730 |
| 23 | JDatabaseDriver->loadResult() | JROOT/components/com_content/helpers/legacyrouter.php:140 |
| 22 | ContentRouterRulesLegacy->build() | JROOT/libraries/src/Component/Router/RouterView.php:244 |
| 21 | Joomla\CMS\Component\Router\RouterView->build() | JROOT/libraries/src/Router/SiteRouter.php:528 |
| 20 | Joomla\CMS\Router\SiteRouter->buildSefRoute() | JROOT/libraries/src/Router/SiteRouter.php:498 |
| 19 | Joomla\CMS\Router\SiteRouter->_buildSefRoute() | JROOT/libraries/src/Router/Router.php:281 |
| 18 | Joomla\CMS\Router\Router->build() | JROOT/libraries/src/Router/SiteRouter.php:154 |
| 17 | Joomla\CMS\Router\SiteRouter->build() | JROOT/libraries/src/Router/Route.php:66 |
| 16 | Joomla\CMS\Router\Route::_() | JROOT/plugins/content/bt_socialshare/bt_socialshare.php:93 |
| 15 | plgContentBt_socialshare->buildHTML() | JROOT/plugins/content/bt_socialshare/bt_socialshare.php:350 |
| 14 | plgContentBt_socialshare->onContentAfterTitle() | Same as call in the line below. |
| 13 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:70 |
| 12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/category/view.html.php:113 |
| 10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:42 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:381 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:356 |
| 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:267 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:52 |
Query Time: 1.38 ms After last query: 1.18 ms Query memory: 0.024 MB Memory before query: 9.250 MB Rows returned: 0
SELECT `field_id`,`value`
FROM `jo362_fields_values`
WHERE `field_id` IN (1)
AND `item_id` = '3090'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | jo362_fields_values | ref | idx_field_id,idx_item_id | idx_field_id | 4 | const | 1 | Using where |
| Status | Duration |
|---|
| Starting | 0.04 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| table lock | 0.00 ms |
| init | 0.02 ms |
| Optimizing | 0.02 ms |
| Statistics | 0.05 ms |
| Preparing | 0.02 ms |
| Executing | 0.00 ms |
| Sending data | 0.01 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| Query end | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Query end | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.01 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.00 ms |
| # | Caller | File and line number |
|---|
| 18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 17 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_fields/models/field.php:708 |
| 16 | FieldsModelField->getFieldValues() | JROOT/administrator/components/com_fields/helpers/fields.php:158 |
| 15 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:378 |
| 14 | PlgSystemFields->onContentPrepare() | Same as call in the line below. |
| 13 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:70 |
| 12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/category/view.html.php:108 |
| 10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:42 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:381 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:356 |
| 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:267 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:52 |
Query Time: 1.35 ms After last query: 0.64 ms Query memory: 0.032 MB Memory before query: 9.282 MB Rows returned: 1
SELECT `alias`
FROM `jo362_content`
WHERE id = '3090'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | jo362_content | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| Status | Duration |
|---|
| Starting | 0.04 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.01 ms |
| System lock | 0.00 ms |
| table lock | 0.01 ms |
| init | 0.01 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.04 ms |
| Preparing | 0.00 ms |
| Unlocking tables | 0.00 ms |
| Preparing | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.01 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| Query end | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Query end | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.01 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.00 ms |
| # | Caller | File and line number |
|---|
| 26 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1730 |
| 25 | JDatabaseDriver->loadResult() | JROOT/components/com_content/router.php:125 |
| 24 | ContentRouter->getArticleSegment() | Same as call in the line below. |
| 23 | call_user_func_array() | JROOT/libraries/src/Component/Router/RouterView.php:120 |
| 22 | Joomla\CMS\Component\Router\RouterView->getPath() | JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 |
| 21 | Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() | JROOT/libraries/src/Component/Router/RouterView.php:222 |
| 20 | Joomla\CMS\Component\Router\RouterView->preprocess() | JROOT/libraries/src/Router/SiteRouter.php:669 |
| 19 | Joomla\CMS\Router\SiteRouter->processBuildRules() | JROOT/libraries/src/Router/Router.php:266 |
| 18 | Joomla\CMS\Router\Router->build() | JROOT/libraries/src/Router/SiteRouter.php:154 |
| 17 | Joomla\CMS\Router\SiteRouter->build() | JROOT/libraries/src/Router/Route.php:66 |
| 16 | Joomla\CMS\Router\Route::_() | JROOT/plugins/content/bt_socialshare/bt_socialshare.php:93 |
| 15 | plgContentBt_socialshare->buildHTML() | JROOT/plugins/content/bt_socialshare/bt_socialshare.php:350 |
| 14 | plgContentBt_socialshare->onContentAfterTitle() | Same as call in the line below. |
| 13 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:70 |
| 12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/category/view.html.php:113 |
| 10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:42 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:381 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:356 |
| 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:267 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:52 |
Query Time: 1.26 ms After last query: 0.21 ms Query memory: 0.031 MB Memory before query: 9.311 MB Rows returned: 1
SELECT alias
FROM jo362_content
WHERE id=3090
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | jo362_content | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| Status | Duration |
|---|
| Starting | 0.03 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| table lock | 0.00 ms |
| init | 0.01 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.03 ms |
| Preparing | 0.00 ms |
| Unlocking tables | 0.00 ms |
| Preparing | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.01 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| Query end | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Query end | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.00 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.00 ms |
| # | Caller | File and line number |
|---|
| 24 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1730 |
| 23 | JDatabaseDriver->loadResult() | JROOT/components/com_content/helpers/legacyrouter.php:140 |
| 22 | ContentRouterRulesLegacy->build() | JROOT/libraries/src/Component/Router/RouterView.php:244 |
| 21 | Joomla\CMS\Component\Router\RouterView->build() | JROOT/libraries/src/Router/SiteRouter.php:528 |
| 20 | Joomla\CMS\Router\SiteRouter->buildSefRoute() | JROOT/libraries/src/Router/SiteRouter.php:498 |
| 19 | Joomla\CMS\Router\SiteRouter->_buildSefRoute() | JROOT/libraries/src/Router/Router.php:281 |
| 18 | Joomla\CMS\Router\Router->build() | JROOT/libraries/src/Router/SiteRouter.php:154 |
| 17 | Joomla\CMS\Router\SiteRouter->build() | JROOT/libraries/src/Router/Route.php:66 |
| 16 | Joomla\CMS\Router\Route::_() | JROOT/plugins/content/bt_socialshare/bt_socialshare.php:93 |
| 15 | plgContentBt_socialshare->buildHTML() | JROOT/plugins/content/bt_socialshare/bt_socialshare.php:350 |
| 14 | plgContentBt_socialshare->onContentAfterTitle() | Same as call in the line below. |
| 13 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:70 |
| 12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/category/view.html.php:113 |
| 10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:42 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:381 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:356 |
| 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:267 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:52 |
Query Time: 1.36 ms After last query: 1.11 ms Query memory: 0.024 MB Memory before query: 9.344 MB Rows returned: 0
SELECT `field_id`,`value`
FROM `jo362_fields_values`
WHERE `field_id` IN (1)
AND `item_id` = '3087'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | jo362_fields_values | ref | idx_field_id,idx_item_id | idx_field_id | 4 | const | 1 | Using where |
| Status | Duration |
|---|
| Starting | 0.04 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| table lock | 0.00 ms |
| init | 0.02 ms |
| Optimizing | 0.02 ms |
| Statistics | 0.04 ms |
| Preparing | 0.02 ms |
| Executing | 0.00 ms |
| Sending data | 0.01 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| Query end | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Query end | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.01 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.00 ms |
| # | Caller | File and line number |
|---|
| 18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 17 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_fields/models/field.php:708 |
| 16 | FieldsModelField->getFieldValues() | JROOT/administrator/components/com_fields/helpers/fields.php:158 |
| 15 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:378 |
| 14 | PlgSystemFields->onContentPrepare() | Same as call in the line below. |
| 13 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:70 |
| 12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/category/view.html.php:108 |
| 10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:42 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:381 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:356 |
| 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:267 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:52 |
Query Time: 1.31 ms After last query: 0.62 ms Query memory: 0.032 MB Memory before query: 9.376 MB Rows returned: 1
SELECT `alias`
FROM `jo362_content`
WHERE id = '3087'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | jo362_content | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| Status | Duration |
|---|
| Starting | 0.03 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| table lock | 0.01 ms |
| init | 0.01 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.03 ms |
| Preparing | 0.00 ms |
| Unlocking tables | 0.00 ms |
| Preparing | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.01 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| Query end | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Query end | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.00 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.00 ms |
| # | Caller | File and line number |
|---|
| 26 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1730 |
| 25 | JDatabaseDriver->loadResult() | JROOT/components/com_content/router.php:125 |
| 24 | ContentRouter->getArticleSegment() | Same as call in the line below. |
| 23 | call_user_func_array() | JROOT/libraries/src/Component/Router/RouterView.php:120 |
| 22 | Joomla\CMS\Component\Router\RouterView->getPath() | JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 |
| 21 | Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() | JROOT/libraries/src/Component/Router/RouterView.php:222 |
| 20 | Joomla\CMS\Component\Router\RouterView->preprocess() | JROOT/libraries/src/Router/SiteRouter.php:669 |
| 19 | Joomla\CMS\Router\SiteRouter->processBuildRules() | JROOT/libraries/src/Router/Router.php:266 |
| 18 | Joomla\CMS\Router\Router->build() | JROOT/libraries/src/Router/SiteRouter.php:154 |
| 17 | Joomla\CMS\Router\SiteRouter->build() | JROOT/libraries/src/Router/Route.php:66 |
| 16 | Joomla\CMS\Router\Route::_() | JROOT/plugins/content/bt_socialshare/bt_socialshare.php:93 |
| 15 | plgContentBt_socialshare->buildHTML() | JROOT/plugins/content/bt_socialshare/bt_socialshare.php:350 |
| 14 | plgContentBt_socialshare->onContentAfterTitle() | Same as call in the line below. |
| 13 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:70 |
| 12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/category/view.html.php:113 |
| 10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:42 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:381 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:356 |
| 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:267 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:52 |
Query Time: 1.27 ms After last query: 0.22 ms Query memory: 0.031 MB Memory before query: 9.405 MB Rows returned: 1
SELECT alias
FROM jo362_content
WHERE id=3087
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | jo362_content | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| Status | Duration |
|---|
| Starting | 0.03 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| After opening tables | 0.01 ms |
| System lock | 0.00 ms |
| table lock | 0.00 ms |
| init | 0.01 ms |
| Optimizing | 0.03 ms |
| Statistics | 0.03 ms |
| Preparing | 0.00 ms |
| Unlocking tables | 0.00 ms |
| Preparing | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.01 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| Query end | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Query end | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.00 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.00 ms |
| # | Caller | File and line number |
|---|
| 24 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1730 |
| 23 | JDatabaseDriver->loadResult() | JROOT/components/com_content/helpers/legacyrouter.php:140 |
| 22 | ContentRouterRulesLegacy->build() | JROOT/libraries/src/Component/Router/RouterView.php:244 |
| 21 | Joomla\CMS\Component\Router\RouterView->build() | JROOT/libraries/src/Router/SiteRouter.php:528 |
| 20 | Joomla\CMS\Router\SiteRouter->buildSefRoute() | JROOT/libraries/src/Router/SiteRouter.php:498 |
| 19 | Joomla\CMS\Router\SiteRouter->_buildSefRoute() | JROOT/libraries/src/Router/Router.php:281 |
| 18 | Joomla\CMS\Router\Router->build() | JROOT/libraries/src/Router/SiteRouter.php:154 |
| 17 | Joomla\CMS\Router\SiteRouter->build() | JROOT/libraries/src/Router/Route.php:66 |
| 16 | Joomla\CMS\Router\Route::_() | JROOT/plugins/content/bt_socialshare/bt_socialshare.php:93 |
| 15 | plgContentBt_socialshare->buildHTML() | JROOT/plugins/content/bt_socialshare/bt_socialshare.php:350 |
| 14 | plgContentBt_socialshare->onContentAfterTitle() | Same as call in the line below. |
| 13 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:70 |
| 12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/category/view.html.php:113 |
| 10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:42 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:381 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:356 |
| 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:267 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:52 |
Query Time: 1.67 ms After last query: 2.92 ms Query memory: 0.037 MB Memory before query: 9.540 MB Rows returned: 0
SELECT 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
FROM jo362_fields AS a
LEFT JOIN `jo362_languages` AS l
ON l.lang_code = a.language
LEFT JOIN jo362_users AS uc
ON uc.id=a.checked_out
LEFT JOIN jo362_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN jo362_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN jo362_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `jo362_fields_categories` AS fc
ON fc.field_id = a.id
WHERE a.context = 'com_content.categories'
AND (fc.category_id IS NULL OR fc.category_id IN (17,0,4,3))
AND a.access IN (1,1)
AND (a.group_id = 0 OR g.access IN (1,1))
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 filesort |
| 1 | SIMPLE | l | eq_ref | idx_langcode | idx_langcode | 28 | sudmerik_samerik.a.language | 1 | Using where |
| 1 | SIMPLE | uc | eq_ref | PRIMARY | PRIMARY | 4 | sudmerik_samerik.a.checked_out | 1 | |
| 1 | SIMPLE | ag | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| 1 | SIMPLE | ua | eq_ref | PRIMARY | PRIMARY | 4 | sudmerik_samerik.a.created_user_id | 1 | Using where |
| 1 | SIMPLE | g | eq_ref | PRIMARY | PRIMARY | 4 | sudmerik_samerik.a.group_id | 1 | Using where |
| 1 | SIMPLE | fc | ref | PRIMARY | PRIMARY | 4 | sudmerik_samerik.a.id | 1 | Using where; Using index |
| Status | Duration |
|---|
| Starting | 0.11 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.05 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| table lock | 0.01 ms |
| init | 0.05 ms |
| Optimizing | 0.04 ms |
| Statistics | 0.09 ms |
| Preparing | 0.04 ms |
| Sorting result | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.02 ms |
| Creating sort index | 0.04 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| Query end | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.01 ms |
| Query end | 0.01 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.01 ms |
| Updating status | 0.03 ms |
| Reset for next command | 0.00 ms |
| # | Caller | File and line number |
|---|
| 24 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 23 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 |
| 22 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/administrator/components/com_fields/models/fields.php:327 |
| 21 | FieldsModelFields->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:187 |
| 20 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/administrator/components/com_fields/helpers/fields.php:136 |
| 19 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:378 |
| 18 | PlgSystemFields->onContentPrepare() | Same as call in the line below. |
| 17 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:70 |
| 16 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 15 | JEventDispatcher->trigger() | JROOT/components/com_content/views/category/tmpl/blog.php:19 |
| 14 | include JROOT/components/com_content/views/category/tmpl/blog.php | JROOT/libraries/src/MVC/View/HtmlView.php:695 |
| 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:242 |
| 11 | Joomla\CMS\MVC\View\CategoryView->display() | JROOT/components/com_content/views/category/view.html.php:260 |
| 10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:42 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:381 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:356 |
| 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:267 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:52 |
Query Time: 1.63 ms After last query: 0.39 ms Query memory: 0.038 MB Memory before query: 9.571 MB Rows returned: 0
SELECT 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
FROM jo362_fields AS a
LEFT JOIN `jo362_languages` AS l
ON l.lang_code = a.language
LEFT JOIN jo362_users AS uc
ON uc.id=a.checked_out
LEFT JOIN jo362_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN jo362_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN jo362_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `jo362_fields_categories` AS fc
ON fc.field_id = a.id
WHERE a.context = 'com_content.categories'
AND (fc.category_id IS NULL OR fc.category_id IN (4,0,3))
AND a.access IN (1,1)
AND (a.group_id = 0 OR g.access IN (1,1))
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 filesort |
| 1 | SIMPLE | l | eq_ref | idx_langcode | idx_langcode | 28 | sudmerik_samerik.a.language | 1 | Using where |
| 1 | SIMPLE | uc | eq_ref | PRIMARY | PRIMARY | 4 | sudmerik_samerik.a.checked_out | 1 | |
| 1 | SIMPLE | ag | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| 1 | SIMPLE | ua | eq_ref | PRIMARY | PRIMARY | 4 | sudmerik_samerik.a.created_user_id | 1 | Using where |
| 1 | SIMPLE | g | eq_ref | PRIMARY | PRIMARY | 4 | sudmerik_samerik.a.group_id | 1 | Using where |
| 1 | SIMPLE | fc | ref | PRIMARY | PRIMARY | 4 | sudmerik_samerik.a.id | 1 | Using where; Using index |
| Status | Duration |
|---|
| Starting | 0.10 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.04 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| table lock | 0.00 ms |
| init | 0.05 ms |
| Optimizing | 0.03 ms |
| Statistics | 0.08 ms |
| Preparing | 0.03 ms |
| Sorting result | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.02 ms |
| Creating sort index | 0.03 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| Query end | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.01 ms |
| Query end | 0.01 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.01 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.00 ms |
| # | Caller | File and line number |
|---|
| 25 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 24 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 |
| 23 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/administrator/components/com_fields/models/fields.php:327 |
| 22 | FieldsModelFields->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:187 |
| 21 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/administrator/components/com_fields/helpers/fields.php:136 |
| 20 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:326 |
| 19 | PlgSystemFields->display() | JROOT/plugins/system/fields/fields.php:255 |
| 18 | PlgSystemFields->onContentAfterTitle() | Same as call in the line below. |
| 17 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:70 |
| 16 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 15 | JEventDispatcher->trigger() | JROOT/components/com_content/views/category/tmpl/blog.php:22 |
| 14 | include JROOT/components/com_content/views/category/tmpl/blog.php | JROOT/libraries/src/MVC/View/HtmlView.php:695 |
| 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:242 |
| 11 | Joomla\CMS\MVC\View\CategoryView->display() | JROOT/components/com_content/views/category/view.html.php:260 |
| 10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:42 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:381 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:356 |
| 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:267 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:52 |
Query Time: 2.26 ms After last query: 22.96 ms Query memory: 0.023 MB Memory before query: 9.812 MB Rows returned: 19
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM jo362_modules AS m
LEFT JOIN jo362_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN jo362_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-08-31 04:47:49')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-08-31 04:47:49')
AND m.access IN (1,1)
AND m.client_id = 0
AND (mm.menuid = 117 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 | ALL | PRIMARY,published,newsfeeds | NO INDEX KEY COULD BE USED | NULL | NULL | 64 | Using where; Using filesort |
| 1 | SIMPLE | mm | ref | PRIMARY | PRIMARY | 4 | sudmerik_samerik.m.id | 1 | Using where; Using index |
| 1 | SIMPLE | e | ref | element_clientid,element_folder_clientid | element_clientid | 403 | sudmerik_samerik.m.module,const | 1 | Using index condition; Using where |
| Status | Duration |
|---|
| Starting | 0.09 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.04 ms |
| Optimizing | 0.06 ms |
| Statistics | 0.07 ms |
| Preparing | 0.03 ms |
| Sorting result | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.01 ms |
| Creating sort index | 0.47 ms |
| End of update loop | 0.01 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| Query end | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.01 ms |
| Query end | 0.01 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.01 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 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:433 |
| 11 | Joomla\CMS\Helper\ModuleHelper::getModuleList() | JROOT/libraries/src/Helper/ModuleHelper.php:363 |
| 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:581 |
| 8 | Joomla\CMS\Document\HtmlDocument->countModules() | JROOT/templates/ipdrs21/index.php:181 |
| 7 | require JROOT/templates/ipdrs21/index.php | JROOT/libraries/src/Document/HtmlDocument.php:658 |
| 6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:720 |
| 5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:535 |
| 4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1103 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:780 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:273 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:52 |
Query Time: 1.62 ms After last query: 18.80 ms Query memory: 0.021 MB Memory before query: 11.025 MB Rows returned: 134
SELECT *
FROM jo362_acymailing_config
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | jo362_acymailing_config | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 134 | |
| Status | Duration |
|---|
| Starting | 0.06 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.04 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| table lock | 0.01 ms |
| init | 0.02 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.02 ms |
| Preparing | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.11 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| Query end | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Query end | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.00 ms |
| Updating status | 0.04 ms |
| Reset for next command | 0.00 ms |
| # | Caller | File and line number |
|---|
| 13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 12 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_acymailing/classes/cpanel.php:17 |
| 11 | cpanelClass->load() | JROOT/administrator/components/com_acymailing/helpers/helper.php:461 |
| 10 | acymailing_config() | JROOT/administrator/components/com_acymailing/helpers/helper.php:1183 |
| 9 | include_once JROOT/administrator/components/com_acymailing/helpers/helper.php | JROOT/plugins/system/regacymailing/regacymailing.php:139 |
| 8 | plgSystemRegacymailing->onAfterRender() | Same as call in the line below. |
| 7 | call_user_func_array() | 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/CMSApplication.php:1123 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:780 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:273 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:52 |
9 × SELECT `field_id`,`value`
FROM `jo362_fields_values`
9 × SELECT alias
FROM jo362_content
9 × SELECT `alias`
FROM `jo362_content`
8 × SELECT 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
FROM jo362_fields AS a
LEFT JOIN `jo362_languages` AS l
ON l.lang_code = a.language
LEFT JOIN jo362_users AS uc
ON uc.id=a.checked_out
LEFT JOIN jo362_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN jo362_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN jo362_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `jo362_fields_categories` AS fc
ON fc.field_id = a.id
6 × 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 jo362_categories as c
LEFT JOIN jo362_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
3 × SELECT *
FROM jo362_assets
2 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `jo362_assets`
2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `jo362_extensions`
1 × SELECT `m`.`tag_id`,`t`.*
FROM `jo362_contentitem_tag_map` AS m
INNER JOIN `jo362_tags` AS t
ON `m`.`tag_id` = `t`.`id`
1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM jo362_modules AS m
LEFT JOIN jo362_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN jo362_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
1 × SELECT COUNT(*)
FROM jo362_content AS a
LEFT JOIN jo362_categories AS c
ON c.id = a.catid
LEFT JOIN jo362_users AS ua
ON ua.id = a.created_by
LEFT JOIN jo362_users AS uam
ON uam.id = a.modified_by
LEFT JOIN jo362_categories as parent
ON parent.id = c.parent_id
LEFT JOIN jo362_content_rating AS v
ON a.id = v.content_id
1 × SELECT *
FROM jo362_acymailing_confi
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,COUNT(i.`id`) AS numitems
FROM jo362_categories as c
LEFT JOIN jo362_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
LEFT JOIN `jo362_content` AS i
ON i.`catid` = c.id
AND i.state = 1
1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM jo362_extensions
1 × SELECT b.id
FROM jo362_usergroups AS a
LEFT JOIN jo362_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
1 × SELECT id, rules
FROM `jo362_viewlevels
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 jo362_menu AS m
LEFT JOIN jo362_extensions AS e
ON m.component_id = e.extension_id
1 × SELECT *
FROM jo362_languages
1 × SELECT `data`
FROM `jo362_session`
1 × SELECT id, home, template, s.params
FROM jo362_template_styles as s
LEFT JOIN jo362_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
1 × SELECT DISTINCT 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 jo362_content AS a
LEFT JOIN jo362_categories AS c
ON c.id = a.catid
LEFT JOIN jo362_users AS ua
ON ua.id = a.created_by
LEFT JOIN jo362_users AS uam
ON uam.id = a.modified_by
LEFT JOIN jo362_categories as parent
ON parent.id = c.parent_id
LEFT JOIN jo362_content_rating AS v
ON a.id = v.content_id
El director general del IICA, Víctor M. Villalobos, destacó el desafío que enfrenta la agricultura
La Asamblea del Consejo de Derechos Humanos ha votado a favor de una resolución que autoriza la continuación del proceso en vista de redactar una declaración internacional sobre los derechos de los campesinos y otras personas que trabajan en zona rural.
En el año 2004, el gobierno colombiano estableció lineamientos para promover la participación privada en la prestación de servicios ecoturísticos dentro del sistema de Parques Nacionales Naturales. A través de estos lineamientos, formalmente, se buscaba promover el desarrollo sostenible en las regiones del país, con especial énfasis en la situación de comunidades y organizaciones de base, así como conservar ecosistemas particularmente frágiles. Sin embargo, diez años después, el balance de los acuerdos público-privados en torno al turismo pone en cuestión si realmente se trata de iniciativas que persiguen el desarrollo sostenible a escala comunitaria y, mucho menos, la conservación ecológica.
Grupos madereros amenazan con invadir, en cualquier momento, dos aldeas de la tierra indígena Ka’apor, en el Estado de Maranhão. La agresión sería una represalia por el accionar de los indígenas Ka’apor que, en actividades de etno-mapeo del territorio tradicional, durante la última semana, confiscaron tractores de surco, armas, motosierras, camiones y motocicletas. Los ka’apor detuvieron también a un grupo de hombres que manejaba los equipos de retiro ilegal de madera y, de acuerdo con informaciones, hasta el momento, no tuvieron apoyo de las fuerzas federales.
Representes de las principales organizaciones indígenas y campesinas de la región sudamericana (Argentina, Bolivia, Brasil, Colombia, Venezuela, Paraguay, Perú, Ecuador, Uruguay), se reunieron, el pasado viernes, en la Cumbre Sudamericana sobre Reforma Agraria y Soberanía Alimentaria organizada por la CLOC Vía Campesina Sudamérica y otras organizaciones de base de Bolivia.
