Query Time: 0.72 ms Query memory: 0.020 MB Memory before query: 0.751 MB Rows returned: 0
SELECT `session_id`
FROM `yukn2_session`
WHERE `session_id` = X'3862313235326362626231396639663766313539393432616164373031643935'
LIMIT 1
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | yukn2_session | NULL | const | PRIMARY | PRIMARY | 194 | const | 1 | 100.00 | Using index |
| Status | Duration |
|---|
| starting | 0.06 ms |
| Executing hook on transaction | 0.01 ms |
| starting | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.39 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.03 ms |
| executing | 0.01 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| waiting for handler commit | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.01 ms |
| # | Caller | File and line number |
|---|
| 9 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
| 8 | JDatabaseDriver->loadResult() | JROOT/libraries/src/Session/MetadataManager.php:74 |
| 7 | Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() | JROOT/libraries/src/Application/CMSApplication.php:154 |
| 6 | Joomla\CMS\Application\CMSApplication->checkSession() | JROOT/libraries/src/Application/CMSApplication.php:828 |
| 5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:136 |
| 4 | Joomla\CMS\Application\CMSApplication->__construct() | JROOT/libraries/src/Application/SiteApplication.php:66 |
| 3 | Joomla\CMS\Application\SiteApplication->__construct() | JROOT/libraries/src/Application/CMSApplication.php:386 |
| 2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 |
| 1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:46 |
Query Time: 1.42 ms After last query: 0.06 ms Query memory: 0.003 MB Memory before query: 0.756 MB
INSERT INTO `yukn2_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES
(X'3862313235326362626231396639663766313539393432616164373031643935', 1, 1732696197, 0, '', 0)
EXPLAIN not possible on query: INSERT INTO `yukn2_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES
(X'3862313235326362626231396639663766313539393432616164373031643935', 1, 1732696197, 0, '', 0)
| Status | Duration |
|---|
| starting | 0.03 ms |
| Executing hook on transaction | 0.00 ms |
| starting | 0.01 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.02 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| update | 0.13 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| waiting for handler commit | 0.99 ms |
| closing tables | 0.01 ms |
| freeing items | 0.04 ms |
| cleaning up | 0.01 ms |
| # | Caller | File and line number |
|---|
| 8 | JDatabaseDriverMysqli->execute() | JROOT/libraries/src/Session/MetadataManager.php:116 |
| 7 | Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() | JROOT/libraries/src/Application/CMSApplication.php:154 |
| 6 | Joomla\CMS\Application\CMSApplication->checkSession() | JROOT/libraries/src/Application/CMSApplication.php:828 |
| 5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:136 |
| 4 | Joomla\CMS\Application\CMSApplication->__construct() | JROOT/libraries/src/Application/SiteApplication.php:66 |
| 3 | Joomla\CMS\Application\SiteApplication->__construct() | JROOT/libraries/src/Application/CMSApplication.php:386 |
| 2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 |
| 1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:46 |
Query Time: 0.89 ms After last query: 0.42 ms Query memory: 0.021 MB Memory before query: 0.785 MB Rows returned: 40
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `yukn2_extensions`
WHERE `type` = 'component'
AND `state` = 0
AND `enabled` = 1
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | yukn2_extensions | NULL | ref | extension | extension | 82 | const | 40 | 1.00 | Using where |
| Status | Duration |
|---|
| starting | 0.04 ms |
| Executing hook on transaction | 0.00 ms |
| starting | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.25 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.04 ms |
| preparing | 0.01 ms |
| executing | 0.14 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| waiting for handler commit | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number |
|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 11 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Component/ComponentHelper.php:445 |
| 10 | Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}() | Same as call in the line below. |
| 9 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 8 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Component/ComponentHelper.php:453 |
| 7 | Joomla\CMS\Component\ComponentHelper::load() | JROOT/libraries/src/Component/ComponentHelper.php:519 |
| 6 | Joomla\CMS\Component\ComponentHelper::getComponents() | JROOT/libraries/src/Component/ComponentHelper.php:44 |
| 5 | Joomla\CMS\Component\ComponentHelper::getComponent() | JROOT/libraries/src/Component/ComponentHelper.php:103 |
| 4 | Joomla\CMS\Component\ComponentHelper::getParams() | JROOT/libraries/src/Application/SiteApplication.php:594 |
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.47 ms After last query: 0.43 ms Query memory: 0.020 MB Memory before query: 0.796 MB Rows returned: 5
SELECT id, rules
FROM `yukn2_viewlevels`
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | yukn2_viewlevels | NULL | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 5 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.02 ms |
| Executing hook on transaction | 0.00 ms |
| starting | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.21 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.00 ms |
| statistics | 0.01 ms |
| preparing | 0.01 ms |
| executing | 0.03 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| waiting for handler commit | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| logging slow query | 0.03 ms |
| cleaning up | 0.01 ms |
| # | Caller | File and line number |
|---|
| 10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1506 |
| 9 | JDatabaseDriver->loadAssocList() | JROOT/libraries/src/Access/Access.php:1063 |
| 8 | Joomla\CMS\Access\Access::getAuthorisedViewLevels() | JROOT/libraries/src/User/User.php:458 |
| 7 | Joomla\CMS\User\User->getAuthorisedViewLevels() | JROOT/libraries/src/Plugin/PluginHelper.php:318 |
| 6 | Joomla\CMS\Plugin\PluginHelper::load() | JROOT/libraries/src/Plugin/PluginHelper.php:87 |
| 5 | Joomla\CMS\Plugin\PluginHelper::getPlugin() | JROOT/libraries/src/Plugin/PluginHelper.php:129 |
| 4 | Joomla\CMS\Plugin\PluginHelper::isEnabled() | JROOT/libraries/src/Application/SiteApplication.php:604 |
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.64 ms After last query: 0.06 ms Query memory: 0.020 MB Memory before query: 0.806 MB Rows returned: 2
SELECT b.id
FROM yukn2_usergroups AS a
LEFT JOIN yukn2_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 9
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | a | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| 1 | SIMPLE | b | NULL | range | idx_usergroup_nested_set_lookup | idx_usergroup_nested_set_lookup | 4 | NULL | 2 | 100.00 | Using where; Using index |
| Status | Duration |
|---|
| starting | 0.03 ms |
| Executing hook on transaction | 0.00 ms |
| starting | 0.01 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.29 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.02 ms |
| statistics | 0.05 ms |
| preparing | 0.02 ms |
| executing | 0.02 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| waiting for handler commit | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number |
|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1550 |
| 10 | JDatabaseDriver->loadColumn() | JROOT/libraries/src/Access/Access.php:980 |
| 9 | Joomla\CMS\Access\Access::getGroupsByUser() | JROOT/libraries/src/Access/Access.php:1095 |
| 8 | Joomla\CMS\Access\Access::getAuthorisedViewLevels() | JROOT/libraries/src/User/User.php:458 |
| 7 | Joomla\CMS\User\User->getAuthorisedViewLevels() | JROOT/libraries/src/Plugin/PluginHelper.php:318 |
| 6 | Joomla\CMS\Plugin\PluginHelper::load() | JROOT/libraries/src/Plugin/PluginHelper.php:87 |
| 5 | Joomla\CMS\Plugin\PluginHelper::getPlugin() | JROOT/libraries/src/Plugin/PluginHelper.php:129 |
| 4 | Joomla\CMS\Plugin\PluginHelper::isEnabled() | JROOT/libraries/src/Application/SiteApplication.php:604 |
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 1.13 ms After last query: 0.10 ms Query memory: 0.022 MB Memory before query: 0.826 MB Rows returned: 94
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM yukn2_extensions
WHERE enabled = 1
AND type = 'plugin'
AND state IN (0,1)
AND access IN (1,1,5)
ORDER BY ordering
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | yukn2_extensions | NULL | ref | extension | extension | 82 | const | 117 | 0.60 | Using where; Using filesort |
| Status | Duration |
|---|
| starting | 0.04 ms |
| Executing hook on transaction | 0.01 ms |
| starting | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.03 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.05 ms |
| preparing | 0.03 ms |
| executing | 0.68 ms |
| end | 0.01 ms |
| query end | 0.00 ms |
| waiting for handler commit | 0.01 ms |
| closing tables | 0.02 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number |
|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 10 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Plugin/PluginHelper.php:351 |
| 9 | Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}() | Same as call in the line below. |
| 8 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 7 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Plugin/PluginHelper.php:356 |
| 6 | Joomla\CMS\Plugin\PluginHelper::load() | JROOT/libraries/src/Plugin/PluginHelper.php:87 |
| 5 | Joomla\CMS\Plugin\PluginHelper::getPlugin() | JROOT/libraries/src/Plugin/PluginHelper.php:129 |
| 4 | Joomla\CMS\Plugin\PluginHelper::isEnabled() | JROOT/libraries/src/Application/SiteApplication.php:604 |
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.87 ms After last query: 4.92 ms Query memory: 0.021 MB Memory before query: 1.135 MB Rows returned: 1
SELECT `value`
FROM `yukn2_admintools_storage`
WHERE `key` = 'cparams'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | yukn2_admintools_storage | NULL | const | PRIMARY | PRIMARY | 402 | const | 1 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.04 ms |
| Executing hook on transaction | 0.00 ms |
| starting | 0.01 ms |
| checking permissions | 0.15 ms |
| Opening tables | 0.34 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.03 ms |
| preparing | 0.01 ms |
| executing | 0.01 ms |
| end | 0.01 ms |
| query end | 0.00 ms |
| waiting for handler commit | 0.02 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.01 ms |
| # | Caller | File and line number |
|---|
| 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
| 13 | JDatabaseDriver->loadResult() | JROOT/administrator/components/com_admintools/Helper/Storage.php:122 |
| 12 | Akeeba\AdminTools\Admin\Helper\Storage->load() | JROOT/administrator/components/com_admintools/Helper/Storage.php:37 |
| 11 | Akeeba\AdminTools\Admin\Helper\Storage->__construct() | JROOT/administrator/components/com_admintools/Helper/Storage.php:49 |
| 10 | Akeeba\AdminTools\Admin\Helper\Storage::getInstance() | JROOT/plugins/system/admintools/admintools/main.php:409 |
| 9 | plgSystemAdmintools->loadComponentParameters() | JROOT/plugins/system/admintools/admintools/main.php:892 |
| 8 | plgSystemAdmintools->initialize() | JROOT/plugins/system/admintools/admintools/main.php:84 |
| 7 | plgSystemAdmintools->__construct() | JROOT/libraries/src/Plugin/PluginHelper.php:280 |
| 6 | Joomla\CMS\Plugin\PluginHelper::import() | JROOT/libraries/src/Plugin/PluginHelper.php:182 |
| 5 | Joomla\CMS\Plugin\PluginHelper::importPlugin() | JROOT/libraries/src/Application/CMSApplication.php:667 |
| 4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.55 ms After last query: 0.17 ms Query memory: 0.021 MB Memory before query: 1.144 MB Rows returned: 0
SELECT *
FROM `yukn2_admintools_wafexceptions`
WHERE NOT(`option` LIKE 'com_%')
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | yukn2_admintools_wafexceptions | NULL | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 1 | 100.00 | Using where |
| Status | Duration |
|---|
| starting | 0.08 ms |
| Executing hook on transaction | 0.01 ms |
| starting | 0.01 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.21 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.01 ms |
| preparing | 0.01 ms |
| executing | 0.02 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| waiting for handler commit | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| logging slow query | 0.03 ms |
| cleaning up | 0.01 ms |
| # | Caller | File and line number |
|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1506 |
| 11 | JDatabaseDriver->loadAssocList() | JROOT/plugins/system/admintools/admintools/main.php:729 |
| 10 | plgSystemAdmintools->loadWAFExceptionsSEF() | JROOT/plugins/system/admintools/admintools/main.php:640 |
| 9 | plgSystemAdmintools->loadWAFExceptions() | JROOT/plugins/system/admintools/admintools/main.php:901 |
| 8 | plgSystemAdmintools->initialize() | JROOT/plugins/system/admintools/admintools/main.php:84 |
| 7 | plgSystemAdmintools->__construct() | JROOT/libraries/src/Plugin/PluginHelper.php:280 |
| 6 | Joomla\CMS\Plugin\PluginHelper::import() | JROOT/libraries/src/Plugin/PluginHelper.php:182 |
| 5 | Joomla\CMS\Plugin\PluginHelper::importPlugin() | JROOT/libraries/src/Application/CMSApplication.php:667 |
| 4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 1.53 ms After last query: 5.08 ms Query memory: 0.021 MB Memory before query: 1.204 MB Rows returned: 0
SELECT `source`,`keepurlparams`
FROM `yukn2_admintools_redirects`
WHERE ((`dest` = 'index.php') OR (`dest` = 'index.php?itemid=292&start=432') OR ('index.php?itemid=292&start=432' LIKE `dest`))
AND `published` = '1'
ORDER BY `ordering` DESC
LIMIT 1
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | yukn2_admintools_redirects | NULL | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 1 | 100.00 | Using where; Using filesort |
| Status | Duration |
|---|
| starting | 0.11 ms |
| Executing hook on transaction | 0.01 ms |
| starting | 0.01 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.48 ms |
| init | 0.01 ms |
| System lock | 0.02 ms |
| optimizing | 0.03 ms |
| statistics | 0.03 ms |
| preparing | 0.03 ms |
| executing | 0.03 ms |
| end | 0.01 ms |
| query end | 0.00 ms |
| waiting for handler commit | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| logging slow query | 0.05 ms |
| cleaning up | 0.01 ms |
| # | Caller | File and line number |
|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1773 |
| 11 | JDatabaseDriver->loadRow() | JROOT/plugins/system/admintools/feature/urlredir.php:91 |
| 10 | AtsystemFeatureUrlredir->onAfterInitialise() | JROOT/plugins/system/admintools/admintools/main.php:308 |
| 9 | plgSystemAdmintools->runFeature() | JROOT/plugins/system/admintools/admintools/main.php:144 |
| 8 | plgSystemAdmintools->onAfterInitialise() | JROOT/libraries/joomla/event/event.php:70 |
| 7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
| 5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:668 |
| 4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 1.33 ms After last query: 1.07 ms Query memory: 0.024 MB Memory before query: 1.309 MB Rows returned: 12
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 yukn2_menu AS m
LEFT JOIN yukn2_extensions AS e
ON m.component_id = e.extension_id
WHERE m.published = 1
AND m.parent_id > 0
AND m.client_id = 0
ORDER BY m.lft
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | m | NULL | range | idx_client_id_parent_id_alias_language | idx_client_id_parent_id_alias_language | 5 | NULL | 13 | 10.00 | Using index condition; Using where; Using filesort |
| 1 | SIMPLE | e | NULL | eq_ref | PRIMARY | PRIMARY | 4 | michaelzwilliamson_com.m.component_id | 1 | 100.00 | Using where |
| Status | Duration |
|---|
| starting | 0.10 ms |
| Executing hook on transaction | 0.01 ms |
| starting | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.47 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.02 ms |
| statistics | 0.08 ms |
| preparing | 0.03 ms |
| executing | 0.30 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| waiting for handler commit | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.04 ms |
| cleaning up | 0.01 ms |
| # | Caller | File and line number |
|---|
| 19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 18 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Menu/SiteMenu.php:93 |
| 17 | Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}() | Same as call in the line below. |
| 16 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 15 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Menu/SiteMenu.php:101 |
| 14 | Joomla\CMS\Menu\SiteMenu->load() | JROOT/libraries/src/Menu/AbstractMenu.php:78 |
| 13 | Joomla\CMS\Menu\AbstractMenu->__construct() | JROOT/libraries/src/Menu/SiteMenu.php:62 |
| 12 | Joomla\CMS\Menu\SiteMenu->__construct() | JROOT/libraries/src/Menu/AbstractMenu.php:142 |
| 11 | Joomla\CMS\Menu\AbstractMenu::getInstance() | JROOT/libraries/src/Application/CMSApplication.php:417 |
| 10 | Joomla\CMS\Application\CMSApplication->getMenu() | JROOT/libraries/src/Application/SiteApplication.php:275 |
| 9 | Joomla\CMS\Application\SiteApplication->getMenu() | JROOT/libraries/src/Router/SiteRouter.php:65 |
| 8 | Joomla\CMS\Router\SiteRouter->__construct() | JROOT/libraries/src/Router/Router.php:189 |
| 7 | Joomla\CMS\Router\Router::getInstance() | JROOT/libraries/src/Application/CMSApplication.php:533 |
| 6 | Joomla\CMS\Application\CMSApplication::getRouter() | JROOT/libraries/src/Application/SiteApplication.php:403 |
| 5 | Joomla\CMS\Application\SiteApplication::getRouter() | JROOT/libraries/src/Application/CMSApplication.php:1141 |
| 4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
| 3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.61 ms After last query: 3.10 ms Query memory: 0.023 MB Memory before query: 1.406 MB Rows returned: 1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `yukn2_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | yukn2_extensions | NULL | ref | element_clientid,element_folder_clientid,extension | extension | 484 | const,const | 1 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.09 ms |
| Executing hook on transaction | 0.01 ms |
| starting | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.05 ms |
| init | 0.02 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.10 ms |
| preparing | 0.01 ms |
| executing | 0.05 ms |
| end | 0.00 ms |
| query end | 0.01 ms |
| waiting for handler commit | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.03 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number |
|---|
| 19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
| 18 | JDatabaseDriver->loadObject() | JROOT/libraries/src/Helper/LibraryHelper.php:167 |
| 17 | Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}() | Same as call in the line below. |
| 16 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 15 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/LibraryHelper.php:175 |
| 14 | Joomla\CMS\Helper\LibraryHelper::loadLibrary() | JROOT/libraries/src/Helper/LibraryHelper.php:43 |
| 13 | Joomla\CMS\Helper\LibraryHelper::getLibrary() | JROOT/libraries/src/Helper/LibraryHelper.php:90 |
| 12 | Joomla\CMS\Helper\LibraryHelper::getParams() | JROOT/libraries/src/Version.php:321 |
| 11 | Joomla\CMS\Version->getMediaVersion() | JROOT/libraries/src/Factory.php:778 |
| 10 | Joomla\CMS\Factory::createDocument() | JROOT/libraries/src/Factory.php:234 |
| 9 | Joomla\CMS\Factory::getDocument() | JROOT/plugins/system/jcomments/jcomments.php:111 |
| 8 | plgSystemJComments->onAfterRoute() | JROOT/libraries/joomla/event/event.php:70 |
| 7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
| 5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1190 |
| 4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
| 3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 1.15 ms After last query: 0.08 ms Query memory: 0.006 MB Memory before query: 1.398 MB
UPDATE `yukn2_extensions`
SET `params` = '{\"mediaversion\":\"42b283a55c0f64945ed90edb876caed3\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'
EXPLAIN not possible on query: UPDATE `yukn2_extensions`
SET `params` = '{\"mediaversion\":\"42b283a55c0f64945ed90edb876caed3\"}'
WHERE `type` = 'library' AND `element` = 'joomla'
| Status | Duration |
|---|
| starting | 0.03 ms |
| Executing hook on transaction | 0.00 ms |
| starting | 0.01 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.02 ms |
| init | 0.01 ms |
| System lock | 0.06 ms |
| updating | 0.14 ms |
| end | 0.01 ms |
| query end | 0.00 ms |
| waiting for handler commit | 0.55 ms |
| closing tables | 0.05 ms |
| freeing items | 0.04 ms |
| cleaning up | 0.01 ms |
| # | Caller | File and line number |
|---|
| 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/src/Helper/LibraryHelper.php:117 |
| 13 | Joomla\CMS\Helper\LibraryHelper::saveParams() | JROOT/libraries/src/Version.php:372 |
| 12 | Joomla\CMS\Version->setMediaVersion() | JROOT/libraries/src/Version.php:331 |
| 11 | Joomla\CMS\Version->getMediaVersion() | JROOT/libraries/src/Factory.php:778 |
| 10 | Joomla\CMS\Factory::createDocument() | JROOT/libraries/src/Factory.php:234 |
| 9 | Joomla\CMS\Factory::getDocument() | JROOT/plugins/system/jcomments/jcomments.php:111 |
| 8 | plgSystemJComments->onAfterRoute() | JROOT/libraries/joomla/event/event.php:70 |
| 7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
| 5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1190 |
| 4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
| 3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 1.05 ms After last query: 0.68 ms Query memory: 0.024 MB Memory before query: 1.426 MB Rows returned: 91
SELECT *
FROM `yukn2_jcomments_settings`
WHERE `lang` = ''
AND `component` = ''
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | yukn2_jcomments_settings | NULL | ref | PRIMARY | PRIMARY | 214 | const,const | 91 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.05 ms |
| Executing hook on transaction | 0.01 ms |
| starting | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.37 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.07 ms |
| preparing | 0.02 ms |
| executing | 0.23 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| waiting for handler commit | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.03 ms |
| cleaning up | 0.01 ms |
| # | Caller | File and line number |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 15 | JDatabaseDriver->loadObjectList() | JROOT/components/com_jcomments/classes/config.php:140 |
| 14 | JCommentsCfg::_load() | 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/components/com_jcomments/classes/config.php:159 |
| 11 | JCommentsCfg->load() | JROOT/components/com_jcomments/classes/config.php:47 |
| 10 | JCommentsCfg::getInstance() | JROOT/components/com_jcomments/helpers/system.php:39 |
| 9 | JCommentsSystemPluginHelper::getCSS() | JROOT/plugins/system/jcomments/jcomments.php:139 |
| 8 | plgSystemJComments->onAfterRoute() | JROOT/libraries/joomla/event/event.php:70 |
| 7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
| 5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1190 |
| 4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
| 3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 1.54 ms After last query: 0.15 ms Query memory: 0.021 MB Memory before query: 1.431 MB Rows returned: 4
SELECT id, home, template, s.params
FROM yukn2_template_styles as s
LEFT JOIN yukn2_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
WHERE s.client_id = 0
AND e.enabled = 1
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | e | NULL | ref | element_clientid,element_folder_clientid,extension | extension | 82 | const | 5 | 1.00 | Using index condition; Using where |
| 1 | SIMPLE | s | NULL | ref | idx_template,idx_client_id,idx_client_id_home | idx_template | 202 | michaelzwilliamson_com.e.element | 1 | 66.67 | Using index condition; Using where |
| Status | Duration |
|---|
| starting | 0.14 ms |
| Executing hook on transaction | 0.01 ms |
| starting | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.83 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.03 ms |
| statistics | 0.11 ms |
| preparing | 0.04 ms |
| executing | 0.10 ms |
| end | 0.01 ms |
| query end | 0.00 ms |
| waiting for handler commit | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.03 ms |
| cleaning up | 0.01 ms |
| # | Caller | File and line number |
|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 11 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Application/SiteApplication.php:486 |
| 10 | Joomla\CMS\Application\SiteApplication->getTemplate() | JROOT/components/com_jcomments/helpers/system.php:46 |
| 9 | JCommentsSystemPluginHelper::getCSS() | JROOT/plugins/system/jcomments/jcomments.php:139 |
| 8 | plgSystemJComments->onAfterRoute() | JROOT/libraries/joomla/event/event.php:70 |
| 7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
| 5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1190 |
| 4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
| 3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.60 ms After last query: 0.24 ms Query memory: 0.019 MB Memory before query: 1.451 MB Rows returned: 1
SELECT *
FROM yukn2_languages
WHERE published=1
ORDER BY ordering ASC
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | yukn2_languages | NULL | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 1 | 100.00 | Using where; Using filesort |
| Status | Duration |
|---|
| starting | 0.03 ms |
| Executing hook on transaction | 0.00 ms |
| starting | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.27 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.01 ms |
| preparing | 0.02 ms |
| executing | 0.05 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| waiting for handler commit | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| logging slow query | 0.03 ms |
| cleaning up | 0.01 ms |
| # | Caller | File and line number |
|---|
| 7 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 6 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Language/LanguageHelper.php:150 |
| 5 | Joomla\CMS\Language\LanguageHelper::getLanguages() | JROOT/libraries/src/Application/SiteApplication.php:330 |
| 4 | Joomla\CMS\Application\SiteApplication->getParams() | JROOT/libraries/src/Application/SiteApplication.php:138 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 1.39 ms After last query: 1.45 ms Query memory: 0.025 MB Memory before query: 1.596 MB Rows returned: 40
SELECT `id`,`name`,`rules`,`parent_id`
FROM `yukn2_assets`
WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_admintools','com_ajax','com_akeeba','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_focontentuploader','com_installer','com_jcomments','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_securitycheck','com_tags','com_templates','com_users','com_weblinks','com_wrapper')
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | yukn2_assets | NULL | range | idx_asset_name | idx_asset_name | 202 | NULL | 41 | 100.00 | Using index condition |
| Status | Duration |
|---|
| starting | 0.05 ms |
| Executing hook on transaction | 0.00 ms |
| starting | 0.00 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.47 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.15 ms |
| preparing | 0.02 ms |
| executing | 0.36 ms |
| end | 0.01 ms |
| query end | 0.00 ms |
| waiting for handler commit | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.01 ms |
| # | Caller | File and line number |
|---|
| 20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 19 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Access/Access.php:429 |
| 18 | Joomla\CMS\Access\Access::preloadComponents() | JROOT/libraries/src/Access/Access.php:213 |
| 17 | Joomla\CMS\Access\Access::preload() | JROOT/libraries/src/Access/Access.php:531 |
| 16 | Joomla\CMS\Access\Access::getAssetRules() | JROOT/libraries/src/Access/Access.php:183 |
| 15 | Joomla\CMS\Access\Access::check() | JROOT/libraries/src/User/User.php:398 |
| 14 | Joomla\CMS\User\User->authorise() | JROOT/components/com_content/models/category.php:139 |
| 13 | ContentModelCategory->populateState() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457 |
| 12 | Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() | JROOT/libraries/src/MVC/View/CategoryView.php:116 |
| 11 | Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() | JROOT/components/com_content/views/category/view.html.php:75 |
| 10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 1.00 ms After last query: 0.09 ms Query memory: 0.052 MB Memory before query: 1.647 MB Rows returned: 531
SELECT `id`,`name`,`rules`,`parent_id`
FROM `yukn2_assets`
WHERE `name` LIKE 'com_content.%' OR `name` = 'com_content' OR `parent_id` = 0
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | yukn2_assets | NULL | ALL | idx_asset_name,idx_parent_id | NO INDEX KEY COULD BE USED | NULL | NULL | 582 | 23.20 | Using where |
| Status | Duration |
|---|
| starting | 0.03 ms |
| Executing hook on transaction | 0.00 ms |
| starting | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.02 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.06 ms |
| preparing | 0.01 ms |
| executing | 0.66 ms |
| end | 0.01 ms |
| query end | 0.00 ms |
| waiting for handler commit | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| logging slow query | 0.02 ms |
| cleaning up | 0.01 ms |
| # | Caller | File and line number |
|---|
| 20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 19 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Access/Access.php:359 |
| 18 | Joomla\CMS\Access\Access::preloadPermissions() | JROOT/libraries/src/Access/Access.php:226 |
| 17 | Joomla\CMS\Access\Access::preload() | JROOT/libraries/src/Access/Access.php:540 |
| 16 | Joomla\CMS\Access\Access::getAssetRules() | JROOT/libraries/src/Access/Access.php:183 |
| 15 | Joomla\CMS\Access\Access::check() | JROOT/libraries/src/User/User.php:398 |
| 14 | Joomla\CMS\User\User->authorise() | JROOT/components/com_content/models/category.php:139 |
| 13 | ContentModelCategory->populateState() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457 |
| 12 | Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() | JROOT/libraries/src/MVC/View/CategoryView.php:116 |
| 11 | Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() | JROOT/components/com_content/views/category/view.html.php:75 |
| 10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 2.65 ms After last query: 0.93 ms Query memory: 0.023 MB Memory before query: 2.106 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,(
SELECT COUNT(i.`id`)
FROM `yukn2_content` AS `i`
WHERE i.`catid` = c.id
AND i.state = 1) AS numitems
FROM `yukn2_categories` AS `s`
INNER JOIN `yukn2_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.published = 1
AND s.id = 9
ORDER BY c.lft
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | PRIMARY | s | NULL | const | PRIMARY,idx_left_right | PRIMARY | 4 | const | 1 | 100.00 | Using filesort |
| 1 | PRIMARY | c | NULL | ALL | cat_idx,idx_left_right | NO INDEX KEY COULD BE USED | NULL | NULL | 30 | 40.89 | Using where |
| 2 | DEPENDENT SUBQUERY | i | NULL | ref | idx_state,idx_catid | idx_catid | 4 | michaelzwilliamson_com.c.id | 23 | 100.00 | Using index condition; Using where |
| Status | Duration |
|---|
| starting | 0.10 ms |
| Executing hook on transaction | 0.01 ms |
| starting | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.39 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.07 ms |
| preparing | 0.02 ms |
| optimizing | 0.01 ms |
| statistics | 0.03 ms |
| preparing | 0.01 ms |
| executing | 0.11 ms |
| executing | 0.02 ms |
| executing | 0.15 ms |
| executing | 0.14 ms |
| executing | 0.24 ms |
| executing | 0.08 ms |
| executing | 0.12 ms |
| executing | 0.53 ms |
| executing | 0.15 ms |
| executing | 0.04 ms |
| executing | 0.03 ms |
| executing | 0.04 ms |
| executing | 0.01 ms |
| executing | 0.01 ms |
| executing | 0.02 ms |
| executing | 0.01 ms |
| executing | 0.02 ms |
| end | 0.01 ms |
| query end | 0.00 ms |
| waiting for handler commit | 0.01 ms |
| closing tables | 0.02 ms |
| freeing items | 0.03 ms |
| logging slow query | 0.03 ms |
| cleaning up | 0.01 ms |
| # | Caller | File and line number |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 16 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Categories/Categories.php:324 |
| 15 | Joomla\CMS\Categories\Categories->_load() | JROOT/libraries/src/Categories/Categories.php:184 |
| 14 | Joomla\CMS\Categories\Categories->get() | JROOT/components/com_content/models/category.php:355 |
| 13 | ContentModelCategory->getCategory() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
| 12 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/libraries/src/MVC/View/CategoryView.php:122 |
| 11 | Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() | JROOT/components/com_content/views/category/view.html.php:75 |
| 10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 25.52 ms After last query: 0.45 ms Query memory: 0.133 MB Memory before query: 2.194 MB Rows returned: 6
SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN c.published = 2
AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum / v.rating_count, 0), 0), 0) AS rating,
COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
FROM yukn2_content AS a
LEFT JOIN yukn2_categories AS c
ON c.id = a.catid
LEFT JOIN yukn2_users AS ua
ON ua.id = a.created_by
LEFT JOIN yukn2_users AS uam
ON uam.id = a.modified_by
LEFT JOIN yukn2_categories as parent
ON parent.id = c.parent_id
LEFT JOIN yukn2_content_rating AS v
ON a.id = v.content_id
WHERE a.access IN (1,1,5)
AND c.access IN (1,1,5)
AND c.published = 1
AND a.state = 1
AND (a.catid = 9 OR a.catid IN (
SELECT sub.id
FROM yukn2_categories as sub
INNER JOIN yukn2_categories as this
ON sub.lft > this.lft
AND sub.rgt < this.rgt
WHERE this.id = 9))
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-11-27 08:29:57')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-11-27 08:29:57')
ORDER BY a.created DESC , a.created
LIMIT 432, 6
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | PRIMARY | c | NULL | ALL | PRIMARY,idx_access | NO INDEX KEY COULD BE USED | NULL | NULL | 30 | 10.00 | Using where; Using temporary; Using filesort |
| 1 | PRIMARY | a | NULL | ref | idx_access,idx_state,idx_catid | idx_catid | 4 | michaelzwilliamson_com.c.id | 23 | 16.00 | Using index condition; Using where |
| 1 | PRIMARY | ua | NULL | eq_ref | PRIMARY | PRIMARY | 4 | michaelzwilliamson_com.a.created_by | 1 | 100.00 | Using where |
| 1 | PRIMARY | uam | NULL | eq_ref | PRIMARY | PRIMARY | 4 | michaelzwilliamson_com.a.modified_by | 1 | 100.00 | Using where |
| 1 | PRIMARY | parent | NULL | eq_ref | PRIMARY | PRIMARY | 4 | michaelzwilliamson_com.c.parent_id | 1 | 100.00 | Using where |
| 1 | PRIMARY | v | NULL | ALL | PRIMARY | NO INDEX KEY COULD BE USED | NULL | NULL | 1 | 100.00 | Using where; Using join buffer (hash join) |
| 2 | SUBQUERY | this | NULL | const | PRIMARY,idx_left_right | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| 2 | SUBQUERY | sub | NULL | range | PRIMARY,idx_left_right | idx_left_right | 4 | NULL | 21 | 33.33 | Using where; Using index |
| Status | Duration |
|---|
| starting | 0.17 ms |
| Executing hook on transaction | 0.01 ms |
| starting | 0.01 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.72 ms |
| init | 0.02 ms |
| System lock | 0.01 ms |
| optimizing | 0.03 ms |
| statistics | 0.08 ms |
| preparing | 0.03 ms |
| Creating tmp table | 0.08 ms |
| optimizing | 0.01 ms |
| statistics | 0.08 ms |
| preparing | 0.15 ms |
| executing | 22.44 ms |
| end | 0.06 ms |
| query end | 0.01 ms |
| waiting for handler commit | 1.18 ms |
| closing tables | 0.08 ms |
| freeing items | 0.14 ms |
| logging slow query | 0.07 ms |
| cleaning up | 0.02 ms |
| # | Caller | File and line number |
|---|
| 18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 17 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 |
| 16 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:194 |
| 15 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/components/com_content/models/articles.php:576 |
| 14 | ContentModelArticles->getItems() | JROOT/components/com_content/models/category.php:253 |
| 13 | ContentModelCategory->getItems() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
| 12 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/libraries/src/MVC/View/CategoryView.php:144 |
| 11 | Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() | JROOT/components/com_content/views/category/view.html.php:75 |
| 10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 1.32 ms After last query: 0.25 ms Query memory: 0.023 MB Memory before query: 2.316 MB Rows returned: 0
SELECT `m`.`tag_id`,`t`.*
FROM `yukn2_contentitem_tag_map` AS m
INNER JOIN `yukn2_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 217
AND `t`.`published` = 1
AND t.access IN (1,1,5)
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | m | NULL | ALL | idx_tag_type | NO INDEX KEY COULD BE USED | NULL | NULL | 1 | 100.00 | Using where |
| 1 | SIMPLE | t | NULL | eq_ref | PRIMARY,tag_idx,idx_access | PRIMARY | 4 | michaelzwilliamson_com.m.tag_id | 1 | 100.00 | Using where |
| Status | Duration |
|---|
| starting | 0.14 ms |
| Executing hook on transaction | 0.01 ms |
| starting | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.74 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.02 ms |
| statistics | 0.07 ms |
| preparing | 0.03 ms |
| executing | 0.03 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| waiting for handler commit | 0.01 ms |
| closing tables | 0.02 ms |
| freeing items | 0.03 ms |
| logging slow query | 0.03 ms |
| cleaning up | 0.01 ms |
| # | Caller | File and line number |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 16 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Helper/TagsHelper.php:454 |
| 15 | Joomla\CMS\Helper\TagsHelper->getItemTags() | JROOT/components/com_content/models/articles.php:706 |
| 14 | ContentModelArticles->getItems() | JROOT/components/com_content/models/category.php:253 |
| 13 | ContentModelCategory->getItems() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
| 12 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/libraries/src/MVC/View/CategoryView.php:144 |
| 11 | Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() | JROOT/components/com_content/views/category/view.html.php:75 |
| 10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.45 ms After last query: 0.12 ms Query memory: 0.023 MB Memory before query: 2.333 MB Rows returned: 0
SELECT `m`.`tag_id`,`t`.*
FROM `yukn2_contentitem_tag_map` AS m
INNER JOIN `yukn2_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 216
AND `t`.`published` = 1
AND t.access IN (1,1,5)
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | m | NULL | ALL | idx_tag_type | NO INDEX KEY COULD BE USED | NULL | NULL | 1 | 100.00 | Using where |
| 1 | SIMPLE | t | NULL | eq_ref | PRIMARY,tag_idx,idx_access | PRIMARY | 4 | michaelzwilliamson_com.m.tag_id | 1 | 100.00 | Using where |
| Status | Duration |
|---|
| starting | 0.05 ms |
| Executing hook on transaction | 0.00 ms |
| starting | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.05 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.05 ms |
| preparing | 0.02 ms |
| executing | 0.02 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| waiting for handler commit | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| logging slow query | 0.02 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 16 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Helper/TagsHelper.php:454 |
| 15 | Joomla\CMS\Helper\TagsHelper->getItemTags() | JROOT/components/com_content/models/articles.php:706 |
| 14 | ContentModelArticles->getItems() | JROOT/components/com_content/models/category.php:253 |
| 13 | ContentModelCategory->getItems() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
| 12 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/libraries/src/MVC/View/CategoryView.php:144 |
| 11 | Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() | JROOT/components/com_content/views/category/view.html.php:75 |
| 10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.46 ms After last query: 0.08 ms Query memory: 0.023 MB Memory before query: 2.350 MB Rows returned: 0
SELECT `m`.`tag_id`,`t`.*
FROM `yukn2_contentitem_tag_map` AS m
INNER JOIN `yukn2_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 215
AND `t`.`published` = 1
AND t.access IN (1,1,5)
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | m | NULL | ALL | idx_tag_type | NO INDEX KEY COULD BE USED | NULL | NULL | 1 | 100.00 | Using where |
| 1 | SIMPLE | t | NULL | eq_ref | PRIMARY,tag_idx,idx_access | PRIMARY | 4 | michaelzwilliamson_com.m.tag_id | 1 | 100.00 | Using where |
| Status | Duration |
|---|
| starting | 0.04 ms |
| Executing hook on transaction | 0.00 ms |
| starting | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.03 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.05 ms |
| preparing | 0.02 ms |
| executing | 0.02 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| waiting for handler commit | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| logging slow query | 0.02 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 16 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Helper/TagsHelper.php:454 |
| 15 | Joomla\CMS\Helper\TagsHelper->getItemTags() | JROOT/components/com_content/models/articles.php:706 |
| 14 | ContentModelArticles->getItems() | JROOT/components/com_content/models/category.php:253 |
| 13 | ContentModelCategory->getItems() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
| 12 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/libraries/src/MVC/View/CategoryView.php:144 |
| 11 | Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() | JROOT/components/com_content/views/category/view.html.php:75 |
| 10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.59 ms After last query: 0.08 ms Query memory: 0.023 MB Memory before query: 2.367 MB Rows returned: 0
SELECT `m`.`tag_id`,`t`.*
FROM `yukn2_contentitem_tag_map` AS m
INNER JOIN `yukn2_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 214
AND `t`.`published` = 1
AND t.access IN (1,1,5)
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | m | NULL | ALL | idx_tag_type | NO INDEX KEY COULD BE USED | NULL | NULL | 1 | 100.00 | Using where |
| 1 | SIMPLE | t | NULL | eq_ref | PRIMARY,tag_idx,idx_access | PRIMARY | 4 | michaelzwilliamson_com.m.tag_id | 1 | 100.00 | Using where |
| Status | Duration |
|---|
| starting | 0.04 ms |
| Executing hook on transaction | 0.00 ms |
| starting | 0.01 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.03 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.08 ms |
| preparing | 0.02 ms |
| executing | 0.02 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| waiting for handler commit | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.03 ms |
| logging slow query | 0.03 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 16 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Helper/TagsHelper.php:454 |
| 15 | Joomla\CMS\Helper\TagsHelper->getItemTags() | JROOT/components/com_content/models/articles.php:706 |
| 14 | ContentModelArticles->getItems() | JROOT/components/com_content/models/category.php:253 |
| 13 | ContentModelCategory->getItems() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
| 12 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/libraries/src/MVC/View/CategoryView.php:144 |
| 11 | Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() | JROOT/components/com_content/views/category/view.html.php:75 |
| 10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.76 ms After last query: 0.08 ms Query memory: 0.023 MB Memory before query: 2.385 MB Rows returned: 0
SELECT `m`.`tag_id`,`t`.*
FROM `yukn2_contentitem_tag_map` AS m
INNER JOIN `yukn2_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 213
AND `t`.`published` = 1
AND t.access IN (1,1,5)
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | m | NULL | ALL | idx_tag_type | NO INDEX KEY COULD BE USED | NULL | NULL | 1 | 100.00 | Using where |
| 1 | SIMPLE | t | NULL | eq_ref | PRIMARY,tag_idx,idx_access | PRIMARY | 4 | michaelzwilliamson_com.m.tag_id | 1 | 100.00 | Using where |
| Status | Duration |
|---|
| starting | 0.04 ms |
| Executing hook on transaction | 0.00 ms |
| starting | 0.00 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.03 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.05 ms |
| preparing | 0.02 ms |
| executing | 0.03 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| waiting for handler commit | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| logging slow query | 0.02 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 16 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Helper/TagsHelper.php:454 |
| 15 | Joomla\CMS\Helper\TagsHelper->getItemTags() | JROOT/components/com_content/models/articles.php:706 |
| 14 | ContentModelArticles->getItems() | JROOT/components/com_content/models/category.php:253 |
| 13 | ContentModelCategory->getItems() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
| 12 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/libraries/src/MVC/View/CategoryView.php:144 |
| 11 | Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() | JROOT/components/com_content/views/category/view.html.php:75 |
| 10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 1.03 ms After last query: 0.07 ms Query memory: 0.023 MB Memory before query: 2.402 MB Rows returned: 0
SELECT `m`.`tag_id`,`t`.*
FROM `yukn2_contentitem_tag_map` AS m
INNER JOIN `yukn2_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 212
AND `t`.`published` = 1
AND t.access IN (1,1,5)
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | m | NULL | ALL | idx_tag_type | NO INDEX KEY COULD BE USED | NULL | NULL | 1 | 100.00 | Using where |
| 1 | SIMPLE | t | NULL | eq_ref | PRIMARY,tag_idx,idx_access | PRIMARY | 4 | michaelzwilliamson_com.m.tag_id | 1 | 100.00 | Using where |
| Status | Duration |
|---|
| starting | 0.04 ms |
| Executing hook on transaction | 0.00 ms |
| starting | 0.01 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.03 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.02 ms |
| statistics | 0.09 ms |
| preparing | 0.02 ms |
| executing | 0.02 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| waiting for handler commit | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.03 ms |
| logging slow query | 0.02 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 16 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Helper/TagsHelper.php:454 |
| 15 | Joomla\CMS\Helper\TagsHelper->getItemTags() | JROOT/components/com_content/models/articles.php:706 |
| 14 | ContentModelArticles->getItems() | JROOT/components/com_content/models/category.php:253 |
| 13 | ContentModelCategory->getItems() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
| 12 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/libraries/src/MVC/View/CategoryView.php:144 |
| 11 | Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() | JROOT/components/com_content/views/category/view.html.php:75 |
| 10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 6.46 ms After last query: 0.20 ms Query memory: 0.023 MB Memory before query: 2.407 MB Rows returned: 1
SELECT COUNT(*)
FROM yukn2_content AS a
LEFT JOIN yukn2_categories AS c
ON c.id = a.catid
LEFT JOIN yukn2_users AS ua
ON ua.id = a.created_by
LEFT JOIN yukn2_users AS uam
ON uam.id = a.modified_by
LEFT JOIN yukn2_categories as parent
ON parent.id = c.parent_id
LEFT JOIN yukn2_content_rating AS v
ON a.id = v.content_id
WHERE a.access IN (1,1,5)
AND c.access IN (1,1,5)
AND c.published = 1
AND a.state = 1
AND (a.catid = 9 OR a.catid IN (
SELECT sub.id
FROM yukn2_categories as sub
INNER JOIN yukn2_categories as this
ON sub.lft > this.lft
AND sub.rgt < this.rgt
WHERE this.id = 9))
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-11-27 08:29:57')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-11-27 08:29:57')
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | PRIMARY | c | NULL | ALL | PRIMARY,idx_access | NO INDEX KEY COULD BE USED | NULL | NULL | 30 | 10.00 | Using where |
| 1 | PRIMARY | a | NULL | ref | idx_access,idx_state,idx_catid | idx_catid | 4 | michaelzwilliamson_com.c.id | 23 | 16.00 | Using index condition; Using where |
| 1 | PRIMARY | ua | NULL | eq_ref | PRIMARY | PRIMARY | 4 | michaelzwilliamson_com.a.created_by | 1 | 100.00 | Using where; Using index |
| 1 | PRIMARY | uam | NULL | eq_ref | PRIMARY | PRIMARY | 4 | michaelzwilliamson_com.a.modified_by | 1 | 100.00 | Using where; Using index |
| 1 | PRIMARY | parent | NULL | eq_ref | PRIMARY | PRIMARY | 4 | michaelzwilliamson_com.c.parent_id | 1 | 100.00 | Using where; Using index |
| 1 | PRIMARY | v | NULL | eq_ref | PRIMARY | PRIMARY | 4 | michaelzwilliamson_com.a.id | 1 | 100.00 | Using where; Using index |
| 2 | SUBQUERY | this | NULL | const | PRIMARY,idx_left_right | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| 2 | SUBQUERY | sub | NULL | range | PRIMARY,idx_left_right | idx_left_right | 4 | NULL | 21 | 33.33 | Using where; Using index |
| Status | Duration |
|---|
| starting | 0.11 ms |
| Executing hook on transaction | 0.01 ms |
| starting | 0.01 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.13 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.04 ms |
| statistics | 0.17 ms |
| preparing | 0.07 ms |
| optimizing | 0.01 ms |
| statistics | 0.14 ms |
| preparing | 0.04 ms |
| executing | 4.17 ms |
| end | 0.06 ms |
| query end | 0.01 ms |
| waiting for handler commit | 0.03 ms |
| closing tables | 0.03 ms |
| freeing items | 0.06 ms |
| logging slow query | 0.05 ms |
| cleaning up | 0.02 ms |
| # | Caller | File and line number |
|---|
| 18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
| 17 | JDatabaseDriver->loadResult() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:354 |
| 16 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount() | JROOT/libraries/src/MVC/Model/ListModel.php:289 |
| 15 | Joomla\CMS\MVC\Model\ListModel->getTotal() | JROOT/libraries/src/MVC/Model/ListModel.php:239 |
| 14 | Joomla\CMS\MVC\Model\ListModel->getPagination() | JROOT/components/com_content/models/category.php:265 |
| 13 | ContentModelCategory->getItems() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
| 12 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/libraries/src/MVC/View/CategoryView.php:144 |
| 11 | Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() | JROOT/components/com_content/views/category/view.html.php:75 |
| 10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.81 ms After last query: 0.09 ms Query memory: 0.022 MB Memory before query: 2.413 MB Rows returned: 0
SELECT `m`.`tag_id`,`t`.*
FROM `yukn2_contentitem_tag_map` AS m
INNER JOIN `yukn2_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.category'
AND `m`.`content_item_id` = 9
AND `t`.`published` = 1
AND t.access IN (1,1,5)
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | m | NULL | ALL | idx_tag_type | NO INDEX KEY COULD BE USED | NULL | NULL | 1 | 100.00 | Using where |
| 1 | SIMPLE | t | NULL | eq_ref | PRIMARY,tag_idx,idx_access | PRIMARY | 4 | michaelzwilliamson_com.m.tag_id | 1 | 100.00 | Using where |
| Status | Duration |
|---|
| starting | 0.07 ms |
| Executing hook on transaction | 0.01 ms |
| starting | 0.01 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.10 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.10 ms |
| preparing | 0.03 ms |
| executing | 0.04 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| waiting for handler commit | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| logging slow query | 0.03 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number |
|---|
| 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 13 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Helper/TagsHelper.php:454 |
| 12 | Joomla\CMS\Helper\TagsHelper->getItemTags() | JROOT/libraries/src/MVC/View/CategoryView.php:229 |
| 11 | Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() | JROOT/components/com_content/views/category/view.html.php:75 |
| 10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 1.41 ms After last query: 0.65 ms Query memory: 0.024 MB Memory before query: 2.445 MB Rows returned: 3
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 `yukn2_categories` AS `s`
INNER JOIN `yukn2_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1,5)
AND c.published = 1
AND s.id = 18
ORDER BY c.lft
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | s | NULL | const | PRIMARY,idx_left_right | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| 1 | SIMPLE | c | NULL | range | cat_idx,idx_access,idx_left_right | idx_left_right | 4 | NULL | 11 | 60.00 | Using index condition; Using where |
| Status | Duration |
|---|
| starting | 0.17 ms |
| Executing hook on transaction | 0.01 ms |
| starting | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.09 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.03 ms |
| statistics | 0.68 ms |
| preparing | 0.03 ms |
| executing | 0.11 ms |
| end | 0.02 ms |
| query end | 0.00 ms |
| waiting for handler commit | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.01 ms |
| # | Caller | File and line number |
|---|
| 21 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 20 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Categories/Categories.php:324 |
| 19 | Joomla\CMS\Categories\Categories->_load() | JROOT/libraries/src/Categories/Categories.php:184 |
| 18 | Joomla\CMS\Categories\Categories->get() | JROOT/administrator/components/com_fields/models/fields.php:203 |
| 17 | FieldsModelFields->getListQuery() | JROOT/libraries/src/MVC/Model/ListModel.php:140 |
| 16 | Joomla\CMS\MVC\Model\ListModel->_getListQuery() | JROOT/libraries/src/MVC/Model/ListModel.php:194 |
| 15 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/administrator/components/com_fields/helpers/fields.php:136 |
| 14 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:495 |
| 13 | PlgSystemFields->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 |
| 12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/category/view.html.php:113 |
| 10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 2.12 ms After last query: 0.08 ms Query memory: 0.024 MB Memory before query: 2.465 MB Rows returned: 0
SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM yukn2_fields AS a
LEFT JOIN `yukn2_languages` AS l
ON l.lang_code = a.language
LEFT JOIN yukn2_users AS uc
ON uc.id=a.checked_out
LEFT JOIN yukn2_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN yukn2_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN yukn2_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `yukn2_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 (18,0,9))
AND a.access IN (1,1,5)
AND (a.group_id = 0 OR g.access IN (1,1,5))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering ASC
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | a | NULL | ref | idx_state,idx_access,idx_context | idx_state | 1 | const | 1 | 100.00 | Using where; Using temporary; Using filesort |
| 1 | SIMPLE | l | NULL | eq_ref | idx_langcode | idx_langcode | 28 | michaelzwilliamson_com.a.language | 1 | 100.00 | Using where |
| 1 | SIMPLE | uc | NULL | eq_ref | PRIMARY | PRIMARY | 4 | michaelzwilliamson_com.a.checked_out | 1 | 100.00 | NULL |
| 1 | SIMPLE | ag | NULL | eq_ref | PRIMARY | PRIMARY | 4 | michaelzwilliamson_com.a.access | 1 | 100.00 | Using where |
| 1 | SIMPLE | ua | NULL | eq_ref | PRIMARY | PRIMARY | 4 | michaelzwilliamson_com.a.created_user_id | 1 | 100.00 | Using where |
| 1 | SIMPLE | g | NULL | eq_ref | PRIMARY | PRIMARY | 4 | michaelzwilliamson_com.a.group_id | 1 | 100.00 | Using where |
| 1 | SIMPLE | fc | NULL | ref | PRIMARY | PRIMARY | 4 | michaelzwilliamson_com.a.id | 1 | 100.00 | Using where; Using index; Distinct |
| Status | Duration |
|---|
| starting | 0.10 ms |
| Executing hook on transaction | 0.01 ms |
| starting | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.03 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 1.07 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.02 ms |
| statistics | 0.14 ms |
| preparing | 0.03 ms |
| Creating tmp table | 0.06 ms |
| executing | 0.04 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| waiting for handler commit | 0.01 ms |
| closing tables | 0.05 ms |
| freeing items | 0.03 ms |
| cleaning up | 0.01 ms |
| # | Caller | File and line number |
|---|
| 19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 18 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 |
| 17 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/administrator/components/com_fields/models/fields.php:333 |
| 16 | FieldsModelFields->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:194 |
| 15 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/administrator/components/com_fields/helpers/fields.php:136 |
| 14 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:495 |
| 13 | PlgSystemFields->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 |
| 12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/category/view.html.php:113 |
| 10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 1.25 ms After last query: 1.57 ms Query memory: 0.024 MB Memory before query: 2.501 MB Rows returned: 3
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 `yukn2_categories` AS `s`
INNER JOIN `yukn2_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1,5)
AND c.published = 1
AND s.id = 26
ORDER BY c.lft
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | s | NULL | const | PRIMARY,idx_left_right | PRIMARY | 4 | const | 1 | 100.00 | Using filesort |
| 1 | SIMPLE | c | NULL | ALL | cat_idx,idx_access,idx_left_right | NO INDEX KEY COULD BE USED | NULL | NULL | 30 | 38.00 | Using where |
| Status | Duration |
|---|
| starting | 0.15 ms |
| Executing hook on transaction | 0.01 ms |
| starting | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.08 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.02 ms |
| statistics | 0.21 ms |
| preparing | 0.03 ms |
| executing | 0.15 ms |
| end | 0.01 ms |
| query end | 0.00 ms |
| waiting for handler commit | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.03 ms |
| logging slow query | 0.04 ms |
| cleaning up | 0.01 ms |
| # | Caller | File and line number |
|---|
| 21 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 20 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Categories/Categories.php:324 |
| 19 | Joomla\CMS\Categories\Categories->_load() | JROOT/libraries/src/Categories/Categories.php:184 |
| 18 | Joomla\CMS\Categories\Categories->get() | JROOT/administrator/components/com_fields/models/fields.php:203 |
| 17 | FieldsModelFields->getListQuery() | JROOT/libraries/src/MVC/Model/ListModel.php:140 |
| 16 | Joomla\CMS\MVC\Model\ListModel->_getListQuery() | JROOT/libraries/src/MVC/Model/ListModel.php:194 |
| 15 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/administrator/components/com_fields/helpers/fields.php:136 |
| 14 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:495 |
| 13 | PlgSystemFields->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 |
| 12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/category/view.html.php:113 |
| 10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 1.00 ms After last query: 0.07 ms Query memory: 0.024 MB Memory before query: 2.508 MB Rows returned: 0
SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM yukn2_fields AS a
LEFT JOIN `yukn2_languages` AS l
ON l.lang_code = a.language
LEFT JOIN yukn2_users AS uc
ON uc.id=a.checked_out
LEFT JOIN yukn2_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN yukn2_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN yukn2_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `yukn2_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 (26,0,9))
AND a.access IN (1,1,5)
AND (a.group_id = 0 OR g.access IN (1,1,5))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering ASC
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | a | NULL | ref | idx_state,idx_access,idx_context | idx_state | 1 | const | 1 | 100.00 | Using where; Using temporary; Using filesort |
| 1 | SIMPLE | l | NULL | eq_ref | idx_langcode | idx_langcode | 28 | michaelzwilliamson_com.a.language | 1 | 100.00 | Using where |
| 1 | SIMPLE | uc | NULL | eq_ref | PRIMARY | PRIMARY | 4 | michaelzwilliamson_com.a.checked_out | 1 | 100.00 | NULL |
| 1 | SIMPLE | ag | NULL | eq_ref | PRIMARY | PRIMARY | 4 | michaelzwilliamson_com.a.access | 1 | 100.00 | Using where |
| 1 | SIMPLE | ua | NULL | eq_ref | PRIMARY | PRIMARY | 4 | michaelzwilliamson_com.a.created_user_id | 1 | 100.00 | Using where |
| 1 | SIMPLE | g | NULL | eq_ref | PRIMARY | PRIMARY | 4 | michaelzwilliamson_com.a.group_id | 1 | 100.00 | Using where |
| 1 | SIMPLE | fc | NULL | ref | PRIMARY | PRIMARY | 4 | michaelzwilliamson_com.a.id | 1 | 100.00 | Using where; Using index; Distinct |
| Status | Duration |
|---|
| starting | 0.10 ms |
| Executing hook on transaction | 0.01 ms |
| starting | 0.01 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.12 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.02 ms |
| statistics | 0.17 ms |
| preparing | 0.03 ms |
| Creating tmp table | 0.08 ms |
| executing | 0.05 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| waiting for handler commit | 0.01 ms |
| closing tables | 0.02 ms |
| freeing items | 0.03 ms |
| cleaning up | 0.01 ms |
| # | Caller | File and line number |
|---|
| 19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 18 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 |
| 17 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/administrator/components/com_fields/models/fields.php:333 |
| 16 | FieldsModelFields->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:194 |
| 15 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/administrator/components/com_fields/helpers/fields.php:136 |
| 14 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:495 |
| 13 | PlgSystemFields->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 |
| 12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/category/view.html.php:113 |
| 10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 1.91 ms After last query: 0.52 ms Query memory: 0.024 MB Memory before query: 2.526 MB Rows returned: 3
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 `yukn2_categories` AS `s`
INNER JOIN `yukn2_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1,5)
AND c.published = 1
AND s.id = 29
ORDER BY c.lft
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | s | NULL | const | PRIMARY,idx_left_right | PRIMARY | 4 | const | 1 | 100.00 | Using filesort |
| 1 | SIMPLE | c | NULL | ALL | cat_idx,idx_access,idx_left_right | NO INDEX KEY COULD BE USED | NULL | NULL | 30 | 44.00 | Using where |
| Status | Duration |
|---|
| starting | 0.15 ms |
| Executing hook on transaction | 0.01 ms |
| starting | 0.01 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.08 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.02 ms |
| statistics | 0.13 ms |
| preparing | 0.26 ms |
| executing | 0.21 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| waiting for handler commit | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| logging slow query | 0.04 ms |
| cleaning up | 0.01 ms |
| # | Caller | File and line number |
|---|
| 21 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 20 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Categories/Categories.php:324 |
| 19 | Joomla\CMS\Categories\Categories->_load() | JROOT/libraries/src/Categories/Categories.php:184 |
| 18 | Joomla\CMS\Categories\Categories->get() | JROOT/administrator/components/com_fields/models/fields.php:203 |
| 17 | FieldsModelFields->getListQuery() | JROOT/libraries/src/MVC/Model/ListModel.php:140 |
| 16 | Joomla\CMS\MVC\Model\ListModel->_getListQuery() | JROOT/libraries/src/MVC/Model/ListModel.php:194 |
| 15 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/administrator/components/com_fields/helpers/fields.php:136 |
| 14 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:495 |
| 13 | PlgSystemFields->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 |
| 12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/category/view.html.php:113 |
| 10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.86 ms After last query: 0.07 ms Query memory: 0.024 MB Memory before query: 2.535 MB Rows returned: 0
SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM yukn2_fields AS a
LEFT JOIN `yukn2_languages` AS l
ON l.lang_code = a.language
LEFT JOIN yukn2_users AS uc
ON uc.id=a.checked_out
LEFT JOIN yukn2_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN yukn2_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN yukn2_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `yukn2_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 (29,0,9))
AND a.access IN (1,1,5)
AND (a.group_id = 0 OR g.access IN (1,1,5))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering ASC
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | a | NULL | ref | idx_state,idx_access,idx_context | idx_state | 1 | const | 1 | 100.00 | Using where; Using temporary; Using filesort |
| 1 | SIMPLE | l | NULL | eq_ref | idx_langcode | idx_langcode | 28 | michaelzwilliamson_com.a.language | 1 | 100.00 | Using where |
| 1 | SIMPLE | uc | NULL | eq_ref | PRIMARY | PRIMARY | 4 | michaelzwilliamson_com.a.checked_out | 1 | 100.00 | NULL |
| 1 | SIMPLE | ag | NULL | eq_ref | PRIMARY | PRIMARY | 4 | michaelzwilliamson_com.a.access | 1 | 100.00 | Using where |
| 1 | SIMPLE | ua | NULL | eq_ref | PRIMARY | PRIMARY | 4 | michaelzwilliamson_com.a.created_user_id | 1 | 100.00 | Using where |
| 1 | SIMPLE | g | NULL | eq_ref | PRIMARY | PRIMARY | 4 | michaelzwilliamson_com.a.group_id | 1 | 100.00 | Using where |
| 1 | SIMPLE | fc | NULL | ref | PRIMARY | PRIMARY | 4 | michaelzwilliamson_com.a.id | 1 | 100.00 | Using where; Using index; Distinct |
| Status | Duration |
|---|
| starting | 0.10 ms |
| Executing hook on transaction | 0.01 ms |
| starting | 0.00 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.12 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.02 ms |
| statistics | 0.18 ms |
| preparing | 0.03 ms |
| Creating tmp table | 0.06 ms |
| executing | 0.05 ms |
| end | 0.01 ms |
| query end | 0.00 ms |
| waiting for handler commit | 0.03 ms |
| closing tables | 0.02 ms |
| freeing items | 0.04 ms |
| cleaning up | 0.01 ms |
| # | Caller | File and line number |
|---|
| 19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 18 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 |
| 17 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/administrator/components/com_fields/models/fields.php:333 |
| 16 | FieldsModelFields->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:194 |
| 15 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/administrator/components/com_fields/helpers/fields.php:136 |
| 14 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:495 |
| 13 | PlgSystemFields->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 |
| 12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/category/view.html.php:113 |
| 10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.75 ms After last query: 0.52 ms Query memory: 0.024 MB Memory before query: 2.553 MB Rows returned: 3
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 `yukn2_categories` AS `s`
INNER JOIN `yukn2_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1,5)
AND c.published = 1
AND s.id = 22
ORDER BY c.lft
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | s | NULL | const | PRIMARY,idx_left_right | PRIMARY | 4 | const | 1 | 100.00 | Using filesort |
| 1 | SIMPLE | c | NULL | ALL | cat_idx,idx_access,idx_left_right | NO INDEX KEY COULD BE USED | NULL | NULL | 30 | 30.00 | Using where |
| Status | Duration |
|---|
| starting | 0.11 ms |
| Executing hook on transaction | 0.01 ms |
| starting | 0.01 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.06 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.02 ms |
| statistics | 0.13 ms |
| preparing | 0.03 ms |
| executing | 0.14 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| waiting for handler commit | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.03 ms |
| logging slow query | 0.03 ms |
| cleaning up | 0.01 ms |
| # | Caller | File and line number |
|---|
| 21 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 20 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Categories/Categories.php:324 |
| 19 | Joomla\CMS\Categories\Categories->_load() | JROOT/libraries/src/Categories/Categories.php:184 |
| 18 | Joomla\CMS\Categories\Categories->get() | JROOT/administrator/components/com_fields/models/fields.php:203 |
| 17 | FieldsModelFields->getListQuery() | JROOT/libraries/src/MVC/Model/ListModel.php:140 |
| 16 | Joomla\CMS\MVC\Model\ListModel->_getListQuery() | JROOT/libraries/src/MVC/Model/ListModel.php:194 |
| 15 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/administrator/components/com_fields/helpers/fields.php:136 |
| 14 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:495 |
| 13 | PlgSystemFields->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 |
| 12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/category/view.html.php:113 |
| 10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.85 ms After last query: 0.07 ms Query memory: 0.024 MB Memory before query: 2.560 MB Rows returned: 0
SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM yukn2_fields AS a
LEFT JOIN `yukn2_languages` AS l
ON l.lang_code = a.language
LEFT JOIN yukn2_users AS uc
ON uc.id=a.checked_out
LEFT JOIN yukn2_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN yukn2_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN yukn2_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `yukn2_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 (22,0,9))
AND a.access IN (1,1,5)
AND (a.group_id = 0 OR g.access IN (1,1,5))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering ASC
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | a | NULL | ref | idx_state,idx_access,idx_context | idx_state | 1 | const | 1 | 100.00 | Using where; Using temporary; Using filesort |
| 1 | SIMPLE | l | NULL | eq_ref | idx_langcode | idx_langcode | 28 | michaelzwilliamson_com.a.language | 1 | 100.00 | Using where |
| 1 | SIMPLE | uc | NULL | eq_ref | PRIMARY | PRIMARY | 4 | michaelzwilliamson_com.a.checked_out | 1 | 100.00 | NULL |
| 1 | SIMPLE | ag | NULL | eq_ref | PRIMARY | PRIMARY | 4 | michaelzwilliamson_com.a.access | 1 | 100.00 | Using where |
| 1 | SIMPLE | ua | NULL | eq_ref | PRIMARY | PRIMARY | 4 | michaelzwilliamson_com.a.created_user_id | 1 | 100.00 | Using where |
| 1 | SIMPLE | g | NULL | eq_ref | PRIMARY | PRIMARY | 4 | michaelzwilliamson_com.a.group_id | 1 | 100.00 | Using where |
| 1 | SIMPLE | fc | NULL | ref | PRIMARY | PRIMARY | 4 | michaelzwilliamson_com.a.id | 1 | 100.00 | Using where; Using index; Distinct |
| Status | Duration |
|---|
| starting | 0.10 ms |
| Executing hook on transaction | 0.00 ms |
| starting | 0.01 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.09 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.02 ms |
| statistics | 0.16 ms |
| preparing | 0.03 ms |
| Creating tmp table | 0.06 ms |
| executing | 0.05 ms |
| end | 0.01 ms |
| query end | 0.00 ms |
| waiting for handler commit | 0.01 ms |
| closing tables | 0.02 ms |
| freeing items | 0.03 ms |
| cleaning up | 0.01 ms |
| # | Caller | File and line number |
|---|
| 19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 18 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 |
| 17 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/administrator/components/com_fields/models/fields.php:333 |
| 16 | FieldsModelFields->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:194 |
| 15 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/administrator/components/com_fields/helpers/fields.php:136 |
| 14 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:495 |
| 13 | PlgSystemFields->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 |
| 12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/category/view.html.php:113 |
| 10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 1.28 ms After last query: 3.08 ms Query memory: 0.026 MB Memory before query: 2.607 MB Rows returned: 0
SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM yukn2_fields AS a
LEFT JOIN `yukn2_languages` AS l
ON l.lang_code = a.language
LEFT JOIN yukn2_users AS uc
ON uc.id=a.checked_out
LEFT JOIN yukn2_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN yukn2_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN yukn2_fields_groups AS g
ON g.id = a.group_id
WHERE a.context = 'com_content.categories'
AND a.access IN (1,1,5)
AND (a.group_id = 0 OR g.access IN (1,1,5))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering ASC
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | a | NULL | ref | idx_state,idx_access,idx_context | idx_state | 1 | const | 1 | 100.00 | Using where; Using temporary; Using filesort |
| 1 | SIMPLE | l | NULL | eq_ref | idx_langcode | idx_langcode | 28 | michaelzwilliamson_com.a.language | 1 | 100.00 | Using where |
| 1 | SIMPLE | uc | NULL | eq_ref | PRIMARY | PRIMARY | 4 | michaelzwilliamson_com.a.checked_out | 1 | 100.00 | NULL |
| 1 | SIMPLE | ag | NULL | eq_ref | PRIMARY | PRIMARY | 4 | michaelzwilliamson_com.a.access | 1 | 100.00 | Using where |
| 1 | SIMPLE | ua | NULL | eq_ref | PRIMARY | PRIMARY | 4 | michaelzwilliamson_com.a.created_user_id | 1 | 100.00 | Using where |
| 1 | SIMPLE | g | NULL | eq_ref | PRIMARY | PRIMARY | 4 | michaelzwilliamson_com.a.group_id | 1 | 100.00 | Using where |
| Status | Duration |
|---|
| starting | 0.15 ms |
| Executing hook on transaction | 0.01 ms |
| starting | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.14 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.03 ms |
| statistics | 0.19 ms |
| preparing | 0.03 ms |
| Creating tmp table | 0.06 ms |
| executing | 0.06 ms |
| end | 0.01 ms |
| query end | 0.00 ms |
| waiting for handler commit | 0.32 ms |
| closing tables | 0.02 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.01 ms |
| # | Caller | File and line number |
|---|
| 23 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 22 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 |
| 21 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/administrator/components/com_fields/models/fields.php:333 |
| 20 | FieldsModelFields->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:194 |
| 19 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/administrator/components/com_fields/helpers/fields.php:136 |
| 18 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:495 |
| 17 | PlgSystemFields->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 |
| 16 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 15 | JEventDispatcher->trigger() | JROOT/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:701 |
| 13 | Joomla\CMS\MVC\View\HtmlView->loadTemplate() | JROOT/libraries/src/MVC/View/HtmlView.php:230 |
| 12 | Joomla\CMS\MVC\View\HtmlView->display() | JROOT/libraries/src/MVC/View/CategoryView.php:245 |
| 11 | Joomla\CMS\MVC\View\CategoryView->display() | JROOT/components/com_content/views/category/view.html.php:250 |
| 10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 1.33 ms After last query: 0.28 ms Query memory: 0.026 MB Memory before query: 2.640 MB Rows returned: 13
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM yukn2_modules AS m
LEFT JOIN yukn2_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN yukn2_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
WHERE m.published = 1
AND e.enabled = 1
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2024-11-27 08:29:57')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-11-27 08:29:57')
AND m.access IN (1,1,5)
AND m.client_id = 0
AND (mm.menuid = 101 OR mm.menuid <= 0)
ORDER BY m.position, m.ordering
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | m | NULL | ALL | PRIMARY,published,newsfeeds | NO INDEX KEY COULD BE USED | NULL | NULL | 29 | 3.45 | Using where; Using filesort |
| 1 | SIMPLE | e | NULL | ref | element_clientid,element_folder_clientid | element_clientid | 403 | michaelzwilliamson_com.m.module,const | 1 | 10.00 | Using index condition; Using where |
| 1 | SIMPLE | mm | NULL | ref | PRIMARY | PRIMARY | 4 | michaelzwilliamson_com.m.id | 1 | 40.00 | Using where; Using index |
| Status | Duration |
|---|
| starting | 0.07 ms |
| Executing hook on transaction | 0.00 ms |
| starting | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.53 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.03 ms |
| statistics | 0.08 ms |
| preparing | 0.03 ms |
| executing | 0.32 ms |
| end | 0.01 ms |
| query end | 0.00 ms |
| waiting for handler commit | 0.01 ms |
| closing tables | 0.02 ms |
| freeing items | 0.03 ms |
| logging slow query | 0.03 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number |
|---|
| 25 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 24 | JDatabaseDriver->loadObjectList() | Same as call in the line below. |
| 23 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 22 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/ModuleHelper.php:441 |
| 21 | Joomla\CMS\Helper\ModuleHelper::getModuleList() | JROOT/libraries/src/Helper/ModuleHelper.php:371 |
| 20 | Joomla\CMS\Helper\ModuleHelper::load() | JROOT/libraries/src/Helper/ModuleHelper.php:670 |
| 19 | Joomla\CMS\Helper\ModuleHelper::getModuleById() | JROOT/plugins/content/loadmodule/loadmodule.php:237 |
| 18 | PlgContentLoadmodule->_loadid() | JROOT/plugins/content/loadmodule/loadmodule.php:141 |
| 17 | PlgContentLoadmodule->onContentPrepare() | 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:701 |
| 13 | Joomla\CMS\MVC\View\HtmlView->loadTemplate() | JROOT/libraries/src/MVC/View/HtmlView.php:230 |
| 12 | Joomla\CMS\MVC\View\HtmlView->display() | JROOT/libraries/src/MVC/View/CategoryView.php:245 |
| 11 | Joomla\CMS\MVC\View\CategoryView->display() | JROOT/components/com_content/views/category/view.html.php:250 |
| 10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.76 ms After last query: 0.47 ms Query memory: 0.026 MB Memory before query: 2.653 MB Rows returned: 0
SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM yukn2_fields AS a
LEFT JOIN `yukn2_languages` AS l
ON l.lang_code = a.language
LEFT JOIN yukn2_users AS uc
ON uc.id=a.checked_out
LEFT JOIN yukn2_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN yukn2_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN yukn2_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `yukn2_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 (9,0))
AND a.access IN (1,1,5)
AND (a.group_id = 0 OR g.access IN (1,1,5))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering ASC
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | a | NULL | ref | idx_state,idx_access,idx_context | idx_state | 1 | const | 1 | 100.00 | Using where; Using temporary; Using filesort |
| 1 | SIMPLE | l | NULL | eq_ref | idx_langcode | idx_langcode | 28 | michaelzwilliamson_com.a.language | 1 | 100.00 | Using where |
| 1 | SIMPLE | uc | NULL | eq_ref | PRIMARY | PRIMARY | 4 | michaelzwilliamson_com.a.checked_out | 1 | 100.00 | NULL |
| 1 | SIMPLE | ag | NULL | eq_ref | PRIMARY | PRIMARY | 4 | michaelzwilliamson_com.a.access | 1 | 100.00 | Using where |
| 1 | SIMPLE | ua | NULL | eq_ref | PRIMARY | PRIMARY | 4 | michaelzwilliamson_com.a.created_user_id | 1 | 100.00 | Using where |
| 1 | SIMPLE | g | NULL | eq_ref | PRIMARY | PRIMARY | 4 | michaelzwilliamson_com.a.group_id | 1 | 100.00 | Using where |
| 1 | SIMPLE | fc | NULL | ref | PRIMARY | PRIMARY | 4 | michaelzwilliamson_com.a.id | 1 | 100.00 | Using where; Using index; Distinct |
| Status | Duration |
|---|
| starting | 0.10 ms |
| Executing hook on transaction | 0.00 ms |
| starting | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.08 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.02 ms |
| statistics | 0.15 ms |
| preparing | 0.04 ms |
| Creating tmp table | 0.05 ms |
| executing | 0.04 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| waiting for handler commit | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.01 ms |
| # | Caller | File and line number |
|---|
| 24 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 23 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 |
| 22 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/administrator/components/com_fields/models/fields.php:333 |
| 21 | FieldsModelFields->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:194 |
| 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:404 |
| 18 | PlgSystemFields->display() | JROOT/plugins/system/fields/fields.php:324 |
| 17 | PlgSystemFields->onContentAfterTitle() | 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:701 |
| 13 | Joomla\CMS\MVC\View\HtmlView->loadTemplate() | JROOT/libraries/src/MVC/View/HtmlView.php:230 |
| 12 | Joomla\CMS\MVC\View\HtmlView->display() | JROOT/libraries/src/MVC/View/CategoryView.php:245 |
| 11 | Joomla\CMS\MVC\View\CategoryView->display() | JROOT/components/com_content/views/category/view.html.php:250 |
| 10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.78 ms After last query: 5.25 ms Query memory: 0.028 MB Memory before query: 2.726 MB Rows returned: 3
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 `yukn2_categories` AS `s`
INNER JOIN `yukn2_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1,5)
AND c.published = 1
AND s.id = 17
ORDER BY c.lft
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | s | NULL | const | PRIMARY,idx_left_right | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| 1 | SIMPLE | c | NULL | range | cat_idx,idx_access,idx_left_right | idx_left_right | 4 | NULL | 10 | 60.00 | Using index condition; Using where |
| Status | Duration |
|---|
| starting | 0.15 ms |
| Executing hook on transaction | 0.00 ms |
| starting | 0.01 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.08 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.02 ms |
| statistics | 0.14 ms |
| preparing | 0.03 ms |
| executing | 0.10 ms |
| end | 0.01 ms |
| query end | 0.00 ms |
| waiting for handler commit | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.01 ms |
| # | Caller | File and line number |
|---|
| 30 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 29 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Categories/Categories.php:324 |
| 28 | Joomla\CMS\Categories\Categories->_load() | JROOT/libraries/src/Categories/Categories.php:184 |
| 27 | Joomla\CMS\Categories\Categories->get() | JROOT/components/com_content/router.php:72 |
| 26 | ContentRouter->getCategorySegment() | Same as call in the line below. |
| 25 | call_user_func_array() | JROOT/libraries/src/Component/Router/RouterView.php:120 |
| 24 | Joomla\CMS\Component\Router\RouterView->getPath() | JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 |
| 23 | Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() | JROOT/libraries/src/Component/Router/RouterView.php:222 |
| 22 | Joomla\CMS\Component\Router\RouterView->preprocess() | JROOT/libraries/src/Router/SiteRouter.php:676 |
| 21 | Joomla\CMS\Router\SiteRouter->processBuildRules() | JROOT/libraries/src/Router/Router.php:266 |
| 20 | Joomla\CMS\Router\Router->build() | JROOT/libraries/src/Router/SiteRouter.php:155 |
| 19 | Joomla\CMS\Router\SiteRouter->build() | JROOT/libraries/src/Router/Route.php:144 |
| 18 | Joomla\CMS\Router\Route::link() | JROOT/libraries/src/Router/Route.php:93 |
| 17 | Joomla\CMS\Router\Route::_() | JROOT/components/com_content/views/category/tmpl/blog_children.php:46 |
| 16 | include JROOT/components/com_content/views/category/tmpl/blog_children.php | JROOT/libraries/src/MVC/View/HtmlView.php:701 |
| 15 | Joomla\CMS\MVC\View\HtmlView->loadTemplate() | JROOT/components/com_content/views/category/tmpl/blog.php:128 |
| 14 | include JROOT/components/com_content/views/category/tmpl/blog.php | JROOT/libraries/src/MVC/View/HtmlView.php:701 |
| 13 | Joomla\CMS\MVC\View\HtmlView->loadTemplate() | JROOT/libraries/src/MVC/View/HtmlView.php:230 |
| 12 | Joomla\CMS\MVC\View\HtmlView->display() | JROOT/libraries/src/MVC/View/CategoryView.php:245 |
| 11 | Joomla\CMS\MVC\View\CategoryView->display() | JROOT/components/com_content/views/category/view.html.php:250 |
| 10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.85 ms After last query: 0.18 ms Query memory: 0.028 MB Memory before query: 2.745 MB Rows returned: 3
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 `yukn2_categories` AS `s`
INNER JOIN `yukn2_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1,5)
AND c.published = 1
AND s.id = 19
ORDER BY c.lft
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | s | NULL | const | PRIMARY,idx_left_right | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| 1 | SIMPLE | c | NULL | range | cat_idx,idx_access,idx_left_right | idx_left_right | 4 | NULL | 12 | 60.00 | Using index condition; Using where |
| Status | Duration |
|---|
| starting | 0.10 ms |
| Executing hook on transaction | 0.00 ms |
| starting | 0.01 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.19 ms |
| Opening tables | 0.05 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.04 ms |
| statistics | 0.12 ms |
| preparing | 0.03 ms |
| executing | 0.07 ms |
| end | 0.03 ms |
| query end | 0.00 ms |
| waiting for handler commit | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.01 ms |
| # | Caller | File and line number |
|---|
| 30 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 29 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Categories/Categories.php:324 |
| 28 | Joomla\CMS\Categories\Categories->_load() | JROOT/libraries/src/Categories/Categories.php:184 |
| 27 | Joomla\CMS\Categories\Categories->get() | JROOT/components/com_content/router.php:72 |
| 26 | ContentRouter->getCategorySegment() | Same as call in the line below. |
| 25 | call_user_func_array() | JROOT/libraries/src/Component/Router/RouterView.php:120 |
| 24 | Joomla\CMS\Component\Router\RouterView->getPath() | JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 |
| 23 | Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() | JROOT/libraries/src/Component/Router/RouterView.php:222 |
| 22 | Joomla\CMS\Component\Router\RouterView->preprocess() | JROOT/libraries/src/Router/SiteRouter.php:676 |
| 21 | Joomla\CMS\Router\SiteRouter->processBuildRules() | JROOT/libraries/src/Router/Router.php:266 |
| 20 | Joomla\CMS\Router\Router->build() | JROOT/libraries/src/Router/SiteRouter.php:155 |
| 19 | Joomla\CMS\Router\SiteRouter->build() | JROOT/libraries/src/Router/Route.php:144 |
| 18 | Joomla\CMS\Router\Route::link() | JROOT/libraries/src/Router/Route.php:93 |
| 17 | Joomla\CMS\Router\Route::_() | JROOT/components/com_content/views/category/tmpl/blog_children.php:46 |
| 16 | include JROOT/components/com_content/views/category/tmpl/blog_children.php | JROOT/libraries/src/MVC/View/HtmlView.php:701 |
| 15 | Joomla\CMS\MVC\View\HtmlView->loadTemplate() | JROOT/components/com_content/views/category/tmpl/blog.php:128 |
| 14 | include JROOT/components/com_content/views/category/tmpl/blog.php | JROOT/libraries/src/MVC/View/HtmlView.php:701 |
| 13 | Joomla\CMS\MVC\View\HtmlView->loadTemplate() | JROOT/libraries/src/MVC/View/HtmlView.php:230 |
| 12 | Joomla\CMS\MVC\View\HtmlView->display() | JROOT/libraries/src/MVC/View/CategoryView.php:245 |
| 11 | Joomla\CMS\MVC\View\CategoryView->display() | JROOT/components/com_content/views/category/view.html.php:250 |
| 10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.83 ms After last query: 0.12 ms Query memory: 0.028 MB Memory before query: 2.763 MB Rows returned: 3
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 `yukn2_categories` AS `s`
INNER JOIN `yukn2_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1,5)
AND c.published = 1
AND s.id = 20
ORDER BY c.lft
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | s | NULL | const | PRIMARY,idx_left_right | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| 1 | SIMPLE | c | NULL | range | cat_idx,idx_access,idx_left_right | idx_left_right | 4 | NULL | 13 | 60.00 | Using index condition; Using where |
| Status | Duration |
|---|
| starting | 0.32 ms |
| Executing hook on transaction | 0.01 ms |
| starting | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.06 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.02 ms |
| statistics | 0.09 ms |
| preparing | 0.02 ms |
| executing | 0.06 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| waiting for handler commit | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.01 ms |
| # | Caller | File and line number |
|---|
| 30 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 29 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Categories/Categories.php:324 |
| 28 | Joomla\CMS\Categories\Categories->_load() | JROOT/libraries/src/Categories/Categories.php:184 |
| 27 | Joomla\CMS\Categories\Categories->get() | JROOT/components/com_content/router.php:72 |
| 26 | ContentRouter->getCategorySegment() | Same as call in the line below. |
| 25 | call_user_func_array() | JROOT/libraries/src/Component/Router/RouterView.php:120 |
| 24 | Joomla\CMS\Component\Router\RouterView->getPath() | JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 |
| 23 | Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() | JROOT/libraries/src/Component/Router/RouterView.php:222 |
| 22 | Joomla\CMS\Component\Router\RouterView->preprocess() | JROOT/libraries/src/Router/SiteRouter.php:676 |
| 21 | Joomla\CMS\Router\SiteRouter->processBuildRules() | JROOT/libraries/src/Router/Router.php:266 |
| 20 | Joomla\CMS\Router\Router->build() | JROOT/libraries/src/Router/SiteRouter.php:155 |
| 19 | Joomla\CMS\Router\SiteRouter->build() | JROOT/libraries/src/Router/Route.php:144 |
| 18 | Joomla\CMS\Router\Route::link() | JROOT/libraries/src/Router/Route.php:93 |
| 17 | Joomla\CMS\Router\Route::_() | JROOT/components/com_content/views/category/tmpl/blog_children.php:46 |
| 16 | include JROOT/components/com_content/views/category/tmpl/blog_children.php | JROOT/libraries/src/MVC/View/HtmlView.php:701 |
| 15 | Joomla\CMS\MVC\View\HtmlView->loadTemplate() | JROOT/components/com_content/views/category/tmpl/blog.php:128 |
| 14 | include JROOT/components/com_content/views/category/tmpl/blog.php | JROOT/libraries/src/MVC/View/HtmlView.php:701 |
| 13 | Joomla\CMS\MVC\View\HtmlView->loadTemplate() | JROOT/libraries/src/MVC/View/HtmlView.php:230 |
| 12 | Joomla\CMS\MVC\View\HtmlView->display() | JROOT/libraries/src/MVC/View/CategoryView.php:245 |
| 11 | Joomla\CMS\MVC\View\CategoryView->display() | JROOT/components/com_content/views/category/view.html.php:250 |
| 10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.63 ms After last query: 0.12 ms Query memory: 0.028 MB Memory before query: 2.781 MB Rows returned: 3
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 `yukn2_categories` AS `s`
INNER JOIN `yukn2_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1,5)
AND c.published = 1
AND s.id = 21
ORDER BY c.lft
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | s | NULL | const | PRIMARY,idx_left_right | PRIMARY | 4 | const | 1 | 100.00 | Using filesort |
| 1 | SIMPLE | c | NULL | ALL | cat_idx,idx_access,idx_left_right | NO INDEX KEY COULD BE USED | NULL | NULL | 30 | 28.00 | Using where |
| Status | Duration |
|---|
| starting | 0.07 ms |
| Executing hook on transaction | 0.00 ms |
| starting | 0.00 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.06 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.02 ms |
| statistics | 0.09 ms |
| preparing | 0.02 ms |
| executing | 0.12 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| waiting for handler commit | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| logging slow query | 0.03 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number |
|---|
| 30 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 29 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Categories/Categories.php:324 |
| 28 | Joomla\CMS\Categories\Categories->_load() | JROOT/libraries/src/Categories/Categories.php:184 |
| 27 | Joomla\CMS\Categories\Categories->get() | JROOT/components/com_content/router.php:72 |
| 26 | ContentRouter->getCategorySegment() | Same as call in the line below. |
| 25 | call_user_func_array() | JROOT/libraries/src/Component/Router/RouterView.php:120 |
| 24 | Joomla\CMS\Component\Router\RouterView->getPath() | JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 |
| 23 | Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() | JROOT/libraries/src/Component/Router/RouterView.php:222 |
| 22 | Joomla\CMS\Component\Router\RouterView->preprocess() | JROOT/libraries/src/Router/SiteRouter.php:676 |
| 21 | Joomla\CMS\Router\SiteRouter->processBuildRules() | JROOT/libraries/src/Router/Router.php:266 |
| 20 | Joomla\CMS\Router\Router->build() | JROOT/libraries/src/Router/SiteRouter.php:155 |
| 19 | Joomla\CMS\Router\SiteRouter->build() | JROOT/libraries/src/Router/Route.php:144 |
| 18 | Joomla\CMS\Router\Route::link() | JROOT/libraries/src/Router/Route.php:93 |
| 17 | Joomla\CMS\Router\Route::_() | JROOT/components/com_content/views/category/tmpl/blog_children.php:46 |
| 16 | include JROOT/components/com_content/views/category/tmpl/blog_children.php | JROOT/libraries/src/MVC/View/HtmlView.php:701 |
| 15 | Joomla\CMS\MVC\View\HtmlView->loadTemplate() | JROOT/components/com_content/views/category/tmpl/blog.php:128 |
| 14 | include JROOT/components/com_content/views/category/tmpl/blog.php | JROOT/libraries/src/MVC/View/HtmlView.php:701 |
| 13 | Joomla\CMS\MVC\View\HtmlView->loadTemplate() | JROOT/libraries/src/MVC/View/HtmlView.php:230 |
| 12 | Joomla\CMS\MVC\View\HtmlView->display() | JROOT/libraries/src/MVC/View/CategoryView.php:245 |
| 11 | Joomla\CMS\MVC\View\CategoryView->display() | JROOT/components/com_content/views/category/view.html.php:250 |
| 10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 1.43 ms After last query: 0.15 ms Query memory: 0.028 MB Memory before query: 2.800 MB Rows returned: 3
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 `yukn2_categories` AS `s`
INNER JOIN `yukn2_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1,5)
AND c.published = 1
AND s.id = 23
ORDER BY c.lft
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | s | NULL | const | PRIMARY,idx_left_right | PRIMARY | 4 | const | 1 | 100.00 | Using filesort |
| 1 | SIMPLE | c | NULL | ALL | cat_idx,idx_access,idx_left_right | NO INDEX KEY COULD BE USED | NULL | NULL | 30 | 32.00 | Using where |
| Status | Duration |
|---|
| starting | 0.28 ms |
| Executing hook on transaction | 0.01 ms |
| starting | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.16 ms |
| init | 0.01 ms |
| System lock | 0.02 ms |
| optimizing | 0.05 ms |
| statistics | 0.24 ms |
| preparing | 0.05 ms |
| executing | 0.21 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| waiting for handler commit | 0.02 ms |
| closing tables | 0.01 ms |
| freeing items | 0.04 ms |
| logging slow query | 0.06 ms |
| cleaning up | 0.01 ms |
| # | Caller | File and line number |
|---|
| 30 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 29 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Categories/Categories.php:324 |
| 28 | Joomla\CMS\Categories\Categories->_load() | JROOT/libraries/src/Categories/Categories.php:184 |
| 27 | Joomla\CMS\Categories\Categories->get() | JROOT/components/com_content/router.php:72 |
| 26 | ContentRouter->getCategorySegment() | Same as call in the line below. |
| 25 | call_user_func_array() | JROOT/libraries/src/Component/Router/RouterView.php:120 |
| 24 | Joomla\CMS\Component\Router\RouterView->getPath() | JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 |
| 23 | Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() | JROOT/libraries/src/Component/Router/RouterView.php:222 |
| 22 | Joomla\CMS\Component\Router\RouterView->preprocess() | JROOT/libraries/src/Router/SiteRouter.php:676 |
| 21 | Joomla\CMS\Router\SiteRouter->processBuildRules() | JROOT/libraries/src/Router/Router.php:266 |
| 20 | Joomla\CMS\Router\Router->build() | JROOT/libraries/src/Router/SiteRouter.php:155 |
| 19 | Joomla\CMS\Router\SiteRouter->build() | JROOT/libraries/src/Router/Route.php:144 |
| 18 | Joomla\CMS\Router\Route::link() | JROOT/libraries/src/Router/Route.php:93 |
| 17 | Joomla\CMS\Router\Route::_() | JROOT/components/com_content/views/category/tmpl/blog_children.php:46 |
| 16 | include JROOT/components/com_content/views/category/tmpl/blog_children.php | JROOT/libraries/src/MVC/View/HtmlView.php:701 |
| 15 | Joomla\CMS\MVC\View\HtmlView->loadTemplate() | JROOT/components/com_content/views/category/tmpl/blog.php:128 |
| 14 | include JROOT/components/com_content/views/category/tmpl/blog.php | JROOT/libraries/src/MVC/View/HtmlView.php:701 |
| 13 | Joomla\CMS\MVC\View\HtmlView->loadTemplate() | JROOT/libraries/src/MVC/View/HtmlView.php:230 |
| 12 | Joomla\CMS\MVC\View\HtmlView->display() | JROOT/libraries/src/MVC/View/CategoryView.php:245 |
| 11 | Joomla\CMS\MVC\View\CategoryView->display() | JROOT/components/com_content/views/category/view.html.php:250 |
| 10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.85 ms After last query: 0.11 ms Query memory: 0.028 MB Memory before query: 2.818 MB Rows returned: 3
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 `yukn2_categories` AS `s`
INNER JOIN `yukn2_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1,5)
AND c.published = 1
AND s.id = 24
ORDER BY c.lft
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | s | NULL | const | PRIMARY,idx_left_right | PRIMARY | 4 | const | 1 | 100.00 | Using filesort |
| 1 | SIMPLE | c | NULL | ALL | cat_idx,idx_access,idx_left_right | NO INDEX KEY COULD BE USED | NULL | NULL | 30 | 34.00 | Using where |
| Status | Duration |
|---|
| starting | 0.12 ms |
| Executing hook on transaction | 0.01 ms |
| starting | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.07 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.03 ms |
| statistics | 0.15 ms |
| preparing | 0.04 ms |
| executing | 0.18 ms |
| end | 0.01 ms |
| query end | 0.00 ms |
| waiting for handler commit | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.04 ms |
| logging slow query | 0.03 ms |
| cleaning up | 0.01 ms |
| # | Caller | File and line number |
|---|
| 30 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 29 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Categories/Categories.php:324 |
| 28 | Joomla\CMS\Categories\Categories->_load() | JROOT/libraries/src/Categories/Categories.php:184 |
| 27 | Joomla\CMS\Categories\Categories->get() | JROOT/components/com_content/router.php:72 |
| 26 | ContentRouter->getCategorySegment() | Same as call in the line below. |
| 25 | call_user_func_array() | JROOT/libraries/src/Component/Router/RouterView.php:120 |
| 24 | Joomla\CMS\Component\Router\RouterView->getPath() | JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 |
| 23 | Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() | JROOT/libraries/src/Component/Router/RouterView.php:222 |
| 22 | Joomla\CMS\Component\Router\RouterView->preprocess() | JROOT/libraries/src/Router/SiteRouter.php:676 |
| 21 | Joomla\CMS\Router\SiteRouter->processBuildRules() | JROOT/libraries/src/Router/Router.php:266 |
| 20 | Joomla\CMS\Router\Router->build() | JROOT/libraries/src/Router/SiteRouter.php:155 |
| 19 | Joomla\CMS\Router\SiteRouter->build() | JROOT/libraries/src/Router/Route.php:144 |
| 18 | Joomla\CMS\Router\Route::link() | JROOT/libraries/src/Router/Route.php:93 |
| 17 | Joomla\CMS\Router\Route::_() | JROOT/components/com_content/views/category/tmpl/blog_children.php:46 |
| 16 | include JROOT/components/com_content/views/category/tmpl/blog_children.php | JROOT/libraries/src/MVC/View/HtmlView.php:701 |
| 15 | Joomla\CMS\MVC\View\HtmlView->loadTemplate() | JROOT/components/com_content/views/category/tmpl/blog.php:128 |
| 14 | include JROOT/components/com_content/views/category/tmpl/blog.php | JROOT/libraries/src/MVC/View/HtmlView.php:701 |
| 13 | Joomla\CMS\MVC\View\HtmlView->loadTemplate() | JROOT/libraries/src/MVC/View/HtmlView.php:230 |
| 12 | Joomla\CMS\MVC\View\HtmlView->display() | JROOT/libraries/src/MVC/View/CategoryView.php:245 |
| 11 | Joomla\CMS\MVC\View\CategoryView->display() | JROOT/components/com_content/views/category/view.html.php:250 |
| 10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.68 ms After last query: 0.11 ms Query memory: 0.028 MB Memory before query: 2.836 MB Rows returned: 3
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 `yukn2_categories` AS `s`
INNER JOIN `yukn2_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1,5)
AND c.published = 1
AND s.id = 25
ORDER BY c.lft
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | s | NULL | const | PRIMARY,idx_left_right | PRIMARY | 4 | const | 1 | 100.00 | Using filesort |
| 1 | SIMPLE | c | NULL | ALL | cat_idx,idx_access,idx_left_right | NO INDEX KEY COULD BE USED | NULL | NULL | 30 | 36.00 | Using where |
| Status | Duration |
|---|
| starting | 0.09 ms |
| Executing hook on transaction | 0.01 ms |
| starting | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.05 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.02 ms |
| statistics | 0.11 ms |
| preparing | 0.03 ms |
| executing | 0.14 ms |
| end | 0.01 ms |
| query end | 0.00 ms |
| waiting for handler commit | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.03 ms |
| logging slow query | 0.02 ms |
| cleaning up | 0.01 ms |
| # | Caller | File and line number |
|---|
| 30 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 29 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Categories/Categories.php:324 |
| 28 | Joomla\CMS\Categories\Categories->_load() | JROOT/libraries/src/Categories/Categories.php:184 |
| 27 | Joomla\CMS\Categories\Categories->get() | JROOT/components/com_content/router.php:72 |
| 26 | ContentRouter->getCategorySegment() | Same as call in the line below. |
| 25 | call_user_func_array() | JROOT/libraries/src/Component/Router/RouterView.php:120 |
| 24 | Joomla\CMS\Component\Router\RouterView->getPath() | JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 |
| 23 | Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() | JROOT/libraries/src/Component/Router/RouterView.php:222 |
| 22 | Joomla\CMS\Component\Router\RouterView->preprocess() | JROOT/libraries/src/Router/SiteRouter.php:676 |
| 21 | Joomla\CMS\Router\SiteRouter->processBuildRules() | JROOT/libraries/src/Router/Router.php:266 |
| 20 | Joomla\CMS\Router\Router->build() | JROOT/libraries/src/Router/SiteRouter.php:155 |
| 19 | Joomla\CMS\Router\SiteRouter->build() | JROOT/libraries/src/Router/Route.php:144 |
| 18 | Joomla\CMS\Router\Route::link() | JROOT/libraries/src/Router/Route.php:93 |
| 17 | Joomla\CMS\Router\Route::_() | JROOT/components/com_content/views/category/tmpl/blog_children.php:46 |
| 16 | include JROOT/components/com_content/views/category/tmpl/blog_children.php | JROOT/libraries/src/MVC/View/HtmlView.php:701 |
| 15 | Joomla\CMS\MVC\View\HtmlView->loadTemplate() | JROOT/components/com_content/views/category/tmpl/blog.php:128 |
| 14 | include JROOT/components/com_content/views/category/tmpl/blog.php | JROOT/libraries/src/MVC/View/HtmlView.php:701 |
| 13 | Joomla\CMS\MVC\View\HtmlView->loadTemplate() | JROOT/libraries/src/MVC/View/HtmlView.php:230 |
| 12 | Joomla\CMS\MVC\View\HtmlView->display() | JROOT/libraries/src/MVC/View/CategoryView.php:245 |
| 11 | Joomla\CMS\MVC\View\CategoryView->display() | JROOT/components/com_content/views/category/view.html.php:250 |
| 10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.69 ms After last query: 0.15 ms Query memory: 0.028 MB Memory before query: 2.856 MB Rows returned: 3
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 `yukn2_categories` AS `s`
INNER JOIN `yukn2_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1,5)
AND c.published = 1
AND s.id = 27
ORDER BY c.lft
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | s | NULL | const | PRIMARY,idx_left_right | PRIMARY | 4 | const | 1 | 100.00 | Using filesort |
| 1 | SIMPLE | c | NULL | ALL | cat_idx,idx_access,idx_left_right | NO INDEX KEY COULD BE USED | NULL | NULL | 30 | 40.00 | Using where |
| Status | Duration |
|---|
| starting | 0.09 ms |
| Executing hook on transaction | 0.00 ms |
| starting | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.05 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.02 ms |
| statistics | 0.11 ms |
| preparing | 0.03 ms |
| executing | 0.14 ms |
| end | 0.01 ms |
| query end | 0.00 ms |
| waiting for handler commit | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.03 ms |
| logging slow query | 0.02 ms |
| cleaning up | 0.01 ms |
| # | Caller | File and line number |
|---|
| 30 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 29 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Categories/Categories.php:324 |
| 28 | Joomla\CMS\Categories\Categories->_load() | JROOT/libraries/src/Categories/Categories.php:184 |
| 27 | Joomla\CMS\Categories\Categories->get() | JROOT/components/com_content/router.php:72 |
| 26 | ContentRouter->getCategorySegment() | Same as call in the line below. |
| 25 | call_user_func_array() | JROOT/libraries/src/Component/Router/RouterView.php:120 |
| 24 | Joomla\CMS\Component\Router\RouterView->getPath() | JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 |
| 23 | Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() | JROOT/libraries/src/Component/Router/RouterView.php:222 |
| 22 | Joomla\CMS\Component\Router\RouterView->preprocess() | JROOT/libraries/src/Router/SiteRouter.php:676 |
| 21 | Joomla\CMS\Router\SiteRouter->processBuildRules() | JROOT/libraries/src/Router/Router.php:266 |
| 20 | Joomla\CMS\Router\Router->build() | JROOT/libraries/src/Router/SiteRouter.php:155 |
| 19 | Joomla\CMS\Router\SiteRouter->build() | JROOT/libraries/src/Router/Route.php:144 |
| 18 | Joomla\CMS\Router\Route::link() | JROOT/libraries/src/Router/Route.php:93 |
| 17 | Joomla\CMS\Router\Route::_() | JROOT/components/com_content/views/category/tmpl/blog_children.php:46 |
| 16 | include JROOT/components/com_content/views/category/tmpl/blog_children.php | JROOT/libraries/src/MVC/View/HtmlView.php:701 |
| 15 | Joomla\CMS\MVC\View\HtmlView->loadTemplate() | JROOT/components/com_content/views/category/tmpl/blog.php:128 |
| 14 | include JROOT/components/com_content/views/category/tmpl/blog.php | JROOT/libraries/src/MVC/View/HtmlView.php:701 |
| 13 | Joomla\CMS\MVC\View\HtmlView->loadTemplate() | JROOT/libraries/src/MVC/View/HtmlView.php:230 |
| 12 | Joomla\CMS\MVC\View\HtmlView->display() | JROOT/libraries/src/MVC/View/CategoryView.php:245 |
| 11 | Joomla\CMS\MVC\View\CategoryView->display() | JROOT/components/com_content/views/category/view.html.php:250 |
| 10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 1.12 ms After last query: 0.12 ms Query memory: 0.028 MB Memory before query: 2.874 MB Rows returned: 3
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 `yukn2_categories` AS `s`
INNER JOIN `yukn2_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1,5)
AND c.published = 1
AND s.id = 28
ORDER BY c.lft
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | s | NULL | const | PRIMARY,idx_left_right | PRIMARY | 4 | const | 1 | 100.00 | Using filesort |
| 1 | SIMPLE | c | NULL | ALL | cat_idx,idx_access,idx_left_right | NO INDEX KEY COULD BE USED | NULL | NULL | 30 | 42.00 | Using where |
| Status | Duration |
|---|
| starting | 0.21 ms |
| Executing hook on transaction | 0.01 ms |
| starting | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.12 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.04 ms |
| statistics | 0.20 ms |
| preparing | 0.05 ms |
| executing | 0.21 ms |
| end | 0.01 ms |
| query end | 0.00 ms |
| waiting for handler commit | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.04 ms |
| logging slow query | 0.05 ms |
| cleaning up | 0.01 ms |
| # | Caller | File and line number |
|---|
| 30 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 29 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Categories/Categories.php:324 |
| 28 | Joomla\CMS\Categories\Categories->_load() | JROOT/libraries/src/Categories/Categories.php:184 |
| 27 | Joomla\CMS\Categories\Categories->get() | JROOT/components/com_content/router.php:72 |
| 26 | ContentRouter->getCategorySegment() | Same as call in the line below. |
| 25 | call_user_func_array() | JROOT/libraries/src/Component/Router/RouterView.php:120 |
| 24 | Joomla\CMS\Component\Router\RouterView->getPath() | JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 |
| 23 | Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() | JROOT/libraries/src/Component/Router/RouterView.php:222 |
| 22 | Joomla\CMS\Component\Router\RouterView->preprocess() | JROOT/libraries/src/Router/SiteRouter.php:676 |
| 21 | Joomla\CMS\Router\SiteRouter->processBuildRules() | JROOT/libraries/src/Router/Router.php:266 |
| 20 | Joomla\CMS\Router\Router->build() | JROOT/libraries/src/Router/SiteRouter.php:155 |
| 19 | Joomla\CMS\Router\SiteRouter->build() | JROOT/libraries/src/Router/Route.php:144 |
| 18 | Joomla\CMS\Router\Route::link() | JROOT/libraries/src/Router/Route.php:93 |
| 17 | Joomla\CMS\Router\Route::_() | JROOT/components/com_content/views/category/tmpl/blog_children.php:46 |
| 16 | include JROOT/components/com_content/views/category/tmpl/blog_children.php | JROOT/libraries/src/MVC/View/HtmlView.php:701 |
| 15 | Joomla\CMS\MVC\View\HtmlView->loadTemplate() | JROOT/components/com_content/views/category/tmpl/blog.php:128 |
| 14 | include JROOT/components/com_content/views/category/tmpl/blog.php | JROOT/libraries/src/MVC/View/HtmlView.php:701 |
| 13 | Joomla\CMS\MVC\View\HtmlView->loadTemplate() | JROOT/libraries/src/MVC/View/HtmlView.php:230 |
| 12 | Joomla\CMS\MVC\View\HtmlView->display() | JROOT/libraries/src/MVC/View/CategoryView.php:245 |
| 11 | Joomla\CMS\MVC\View\CategoryView->display() | JROOT/components/com_content/views/category/view.html.php:250 |
| 10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.66 ms After last query: 0.15 ms Query memory: 0.028 MB Memory before query: 2.893 MB Rows returned: 3
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 `yukn2_categories` AS `s`
INNER JOIN `yukn2_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1,5)
AND c.published = 1
AND s.id = 30
ORDER BY c.lft
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | s | NULL | const | PRIMARY,idx_left_right | PRIMARY | 4 | const | 1 | 100.00 | Using filesort |
| 1 | SIMPLE | c | NULL | ALL | cat_idx,idx_access,idx_left_right | NO INDEX KEY COULD BE USED | NULL | NULL | 30 | 46.00 | Using where |
| Status | Duration |
|---|
| starting | 0.08 ms |
| Executing hook on transaction | 0.00 ms |
| starting | 0.01 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.04 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.02 ms |
| statistics | 0.12 ms |
| preparing | 0.03 ms |
| executing | 0.13 ms |
| end | 0.01 ms |
| query end | 0.03 ms |
| waiting for handler commit | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| logging slow query | 0.02 ms |
| cleaning up | 0.01 ms |
| # | Caller | File and line number |
|---|
| 30 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 29 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Categories/Categories.php:324 |
| 28 | Joomla\CMS\Categories\Categories->_load() | JROOT/libraries/src/Categories/Categories.php:184 |
| 27 | Joomla\CMS\Categories\Categories->get() | JROOT/components/com_content/router.php:72 |
| 26 | ContentRouter->getCategorySegment() | Same as call in the line below. |
| 25 | call_user_func_array() | JROOT/libraries/src/Component/Router/RouterView.php:120 |
| 24 | Joomla\CMS\Component\Router\RouterView->getPath() | JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 |
| 23 | Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() | JROOT/libraries/src/Component/Router/RouterView.php:222 |
| 22 | Joomla\CMS\Component\Router\RouterView->preprocess() | JROOT/libraries/src/Router/SiteRouter.php:676 |
| 21 | Joomla\CMS\Router\SiteRouter->processBuildRules() | JROOT/libraries/src/Router/Router.php:266 |
| 20 | Joomla\CMS\Router\Router->build() | JROOT/libraries/src/Router/SiteRouter.php:155 |
| 19 | Joomla\CMS\Router\SiteRouter->build() | JROOT/libraries/src/Router/Route.php:144 |
| 18 | Joomla\CMS\Router\Route::link() | JROOT/libraries/src/Router/Route.php:93 |
| 17 | Joomla\CMS\Router\Route::_() | JROOT/components/com_content/views/category/tmpl/blog_children.php:46 |
| 16 | include JROOT/components/com_content/views/category/tmpl/blog_children.php | JROOT/libraries/src/MVC/View/HtmlView.php:701 |
| 15 | Joomla\CMS\MVC\View\HtmlView->loadTemplate() | JROOT/components/com_content/views/category/tmpl/blog.php:128 |
| 14 | include JROOT/components/com_content/views/category/tmpl/blog.php | JROOT/libraries/src/MVC/View/HtmlView.php:701 |
| 13 | Joomla\CMS\MVC\View\HtmlView->loadTemplate() | JROOT/libraries/src/MVC/View/HtmlView.php:230 |
| 12 | Joomla\CMS\MVC\View\HtmlView->display() | JROOT/libraries/src/MVC/View/CategoryView.php:245 |
| 11 | Joomla\CMS\MVC\View\CategoryView->display() | JROOT/components/com_content/views/category/view.html.php:250 |
| 10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 1.93 ms After last query: 3.39 ms Query memory: 0.022 MB Memory before query: 3.085 MB Rows returned: 0
SELECT MAX(`tag_id`) AS tag_id, COUNT(*) AS count,MAX(t.title) AS title,MAX(`t`.`access`) AS access,MAX(`t`.`alias`) AS alias,MAX(`t`.`params`) AS params
FROM `yukn2_contentitem_tag_map` AS `m`
INNER JOIN `yukn2_tags` AS `t`
ON `tag_id` = t.id
INNER JOIN `yukn2_ucm_content` AS `c`
ON `m`.`core_content_id` = `c`.`core_content_id`
WHERE `t`.`access` IN (1,1,5)
AND `t`.`published` = 1
AND `m`.`type_alias` = `c`.`core_type_alias`
AND `c`.`core_state` = 1
AND (`c`.`core_access` IN (1,1,5) OR `c`.`core_access` = 0)
AND (`c`.`core_publish_up` = '0000-00-00 00:00:00' OR `c`.`core_publish_up` <= '2024-11-27 08:29:57')
AND (`c`.`core_publish_down` = '0000-00-00 00:00:00' OR `c`.`core_publish_down` >= '2024-11-27 08:29:57')
GROUP BY `tag_id`,`title`,`access`,`alias`
ORDER BY `count` DESC
LIMIT 8
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | m | NULL | ALL | idx_tag_type,idx_core_content_id | NO INDEX KEY COULD BE USED | NULL | NULL | 1 | 100.00 | Using temporary; Using filesort |
| 1 | SIMPLE | t | NULL | eq_ref | PRIMARY,tag_idx,idx_access | PRIMARY | 4 | michaelzwilliamson_com.m.tag_id | 1 | 100.00 | Using where |
| 1 | SIMPLE | c | NULL | eq_ref | PRIMARY,tag_idx,idx_access,idx_content_type | PRIMARY | 4 | michaelzwilliamson_com.m.core_content_id | 1 | 100.00 | Using where |
| Status | Duration |
|---|
| starting | 0.67 ms |
| Executing hook on transaction | 0.01 ms |
| starting | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.66 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.04 ms |
| statistics | 0.14 ms |
| preparing | 0.03 ms |
| Creating tmp table | 0.06 ms |
| executing | 0.04 ms |
| end | 0.01 ms |
| query end | 0.00 ms |
| waiting for handler commit | 0.02 ms |
| closing tables | 0.01 ms |
| freeing items | 0.03 ms |
| logging slow query | 0.04 ms |
| cleaning up | 0.01 ms |
| # | Caller | File and line number |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 15 | JDatabaseDriver->loadObjectList() | JROOT/modules/mod_tags_popular/helper.php:134 |
| 14 | ModTagsPopularHelper::getList() | 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:595 |
| 11 | Joomla\CMS\Helper\ModuleHelper::moduleCache() | JROOT/modules/mod_tags_popular/mod_tags_popular.php:22 |
| 10 | include JROOT/modules/mod_tags_popular/mod_tags_popular.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
| 9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
| 8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
| 7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:511 |
| 6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:803 |
| 5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:577 |
| 4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1112 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 2.88 ms After last query: 0.45 ms Query memory: 0.024 MB Memory before query: 3.130 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,(
SELECT COUNT(i.`id`)
FROM `yukn2_content` AS `i`
WHERE i.`catid` = c.id
AND i.state = 1) AS numitems
FROM `yukn2_categories` AS `s`
INNER JOIN `yukn2_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1,5)
AND c.published = 1
AND s.id = 9
ORDER BY c.lft
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | PRIMARY | s | NULL | const | PRIMARY,idx_left_right | PRIMARY | 4 | const | 1 | 100.00 | Using filesort |
| 1 | PRIMARY | c | NULL | ALL | cat_idx,idx_access,idx_left_right | NO INDEX KEY COULD BE USED | NULL | NULL | 30 | 46.00 | Using where |
| 2 | DEPENDENT SUBQUERY | i | NULL | ref | idx_state,idx_catid | idx_catid | 4 | michaelzwilliamson_com.c.id | 23 | 100.00 | Using index condition; Using where |
| Status | Duration |
|---|
| starting | 0.12 ms |
| Executing hook on transaction | 0.01 ms |
| starting | 0.01 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.09 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.02 ms |
| statistics | 0.13 ms |
| preparing | 0.02 ms |
| optimizing | 0.01 ms |
| statistics | 0.04 ms |
| preparing | 0.01 ms |
| executing | 0.20 ms |
| executing | 0.03 ms |
| executing | 0.19 ms |
| executing | 0.25 ms |
| executing | 0.31 ms |
| executing | 0.06 ms |
| executing | 0.12 ms |
| executing | 0.58 ms |
| executing | 0.18 ms |
| executing | 0.04 ms |
| executing | 0.03 ms |
| executing | 0.05 ms |
| executing | 0.02 ms |
| executing | 0.02 ms |
| executing | 0.03 ms |
| executing | 0.02 ms |
| executing | 0.02 ms |
| end | 0.01 ms |
| query end | 0.02 ms |
| waiting for handler commit | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.04 ms |
| logging slow query | 0.03 ms |
| cleaning up | 0.01 ms |
| # | Caller | File and line number |
|---|
| 19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 18 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Categories/Categories.php:324 |
| 17 | Joomla\CMS\Categories\Categories->_load() | JROOT/libraries/src/Categories/Categories.php:184 |
| 16 | Joomla\CMS\Categories\Categories->get() | JROOT/components/com_content/models/categories.php:115 |
| 15 | ContentModelCategories->getItems() | JROOT/modules/mod_articles_category/helper.php:142 |
| 14 | ModArticlesCategoryHelper::getList() | 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:565 |
| 11 | Joomla\CMS\Helper\ModuleHelper::moduleCache() | JROOT/modules/mod_articles_category/mod_articles_category.php:61 |
| 10 | include JROOT/modules/mod_articles_category/mod_articles_category.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
| 9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
| 8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
| 7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:511 |
| 6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:803 |
| 5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:577 |
| 4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1112 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 25.67 ms After last query: 0.26 ms Query memory: 0.172 MB Memory before query: 3.199 MB Rows returned: 6
SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN c.published = 2
AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum / v.rating_count, 0), 0), 0) AS rating,
COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
FROM yukn2_content AS a
LEFT JOIN yukn2_categories AS c
ON c.id = a.catid
LEFT JOIN yukn2_users AS ua
ON ua.id = a.created_by
LEFT JOIN yukn2_users AS uam
ON uam.id = a.modified_by
LEFT JOIN yukn2_categories as parent
ON parent.id = c.parent_id
LEFT JOIN yukn2_content_rating AS v
ON a.id = v.content_id
WHERE a.access IN (1,1,5)
AND c.access IN (1,1,5)
AND c.published = 1
AND a.state = 1
AND a.catid IN (9,17,18,19,20,21,22,23,24,25,26,27,28,29,30)
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-11-27 08:29:57')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-11-27 08:29:57')
ORDER BY a.created DESC
LIMIT 6
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | c | NULL | ALL | PRIMARY,idx_access | NO INDEX KEY COULD BE USED | NULL | NULL | 30 | 10.00 | Using where; Using temporary; Using filesort |
| 1 | SIMPLE | a | NULL | ref | idx_access,idx_state,idx_catid | idx_catid | 4 | michaelzwilliamson_com.c.id | 23 | 16.00 | Using index condition; Using where |
| 1 | SIMPLE | ua | NULL | eq_ref | PRIMARY | PRIMARY | 4 | michaelzwilliamson_com.a.created_by | 1 | 100.00 | Using where |
| 1 | SIMPLE | uam | NULL | eq_ref | PRIMARY | PRIMARY | 4 | michaelzwilliamson_com.a.modified_by | 1 | 100.00 | Using where |
| 1 | SIMPLE | parent | NULL | eq_ref | PRIMARY | PRIMARY | 4 | michaelzwilliamson_com.c.parent_id | 1 | 100.00 | Using where |
| 1 | SIMPLE | v | NULL | ALL | PRIMARY | NO INDEX KEY COULD BE USED | NULL | NULL | 1 | 100.00 | Using where; Using join buffer (hash join) |
| Status | Duration |
|---|
| starting | 0.20 ms |
| Executing hook on transaction | 0.00 ms |
| starting | 0.01 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.14 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.03 ms |
| statistics | 0.17 ms |
| preparing | 0.04 ms |
| Creating tmp table | 0.23 ms |
| executing | 22.68 ms |
| end | 0.04 ms |
| query end | 0.01 ms |
| waiting for handler commit | 1.50 ms |
| closing tables | 0.11 ms |
| freeing items | 0.08 ms |
| logging slow query | 0.06 ms |
| cleaning up | 0.02 ms |
| # | Caller | File and line number |
|---|
| 19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 18 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 |
| 17 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:194 |
| 16 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/components/com_content/models/articles.php:576 |
| 15 | ContentModelArticles->getItems() | JROOT/modules/mod_articles_category/helper.php:224 |
| 14 | ModArticlesCategoryHelper::getList() | 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:565 |
| 11 | Joomla\CMS\Helper\ModuleHelper::moduleCache() | JROOT/modules/mod_articles_category/mod_articles_category.php:61 |
| 10 | include JROOT/modules/mod_articles_category/mod_articles_category.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
| 9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
| 8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
| 7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:511 |
| 6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:803 |
| 5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:577 |
| 4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1112 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 1.44 ms After last query: 1.08 ms Query memory: 0.022 MB Memory before query: 3.259 MB Rows returned: 0
SELECT a.*, c.description AS c_description, c.published AS c_published,
CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug,DATE_FORMAT(a.created, "%Y-%m-%d") AS created,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email
FROM `yukn2_weblinks` AS a
LEFT JOIN yukn2_categories AS c
ON c.id = a.catid
LEFT JOIN yukn2_users AS ua
ON ua.id = a.created_by
LEFT JOIN yukn2_users AS uam
ON uam.id = a.modified_by
WHERE a.access IN (1,1,5)
AND a.catid = 8
AND c.access IN (1,1,5)
AND c.published = 1
AND a.state = 1
AND a.state != -2
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-11-27 08:29:57')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-11-27 08:29:57')
ORDER BY title asc
LIMIT 5
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | NULL | NULL | NULL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | NULL | NULL | no matching row in const table |
| Status | Duration |
|---|
| starting | 0.29 ms |
| Executing hook on transaction | 0.01 ms |
| starting | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.62 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.04 ms |
| statistics | 0.10 ms |
| executing | 0.03 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| waiting for handler commit | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.04 ms |
| cleaning up | 0.01 ms |
| # | Caller | File and line number |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 15 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 |
| 14 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:194 |
| 13 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/components/com_weblinks/models/category.php:81 |
| 12 | WeblinksModelCategory->getItems() | JROOT/modules/mod_weblinks/helper.php:94 |
| 11 | ModWeblinksHelper::getList() | JROOT/modules/mod_weblinks/mod_weblinks.php:15 |
| 10 | include JROOT/modules/mod_weblinks/mod_weblinks.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
| 9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
| 8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
| 7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:511 |
| 6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:803 |
| 5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:577 |
| 4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1112 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.47 ms After last query: 0.28 ms Query memory: 0.021 MB Memory before query: 3.264 MB Rows returned: 0
SELECT MONTH(`created`) AS created_month,MIN(`created`) AS created,YEAR(`created`) AS created_year
FROM yukn2_content
WHERE state = 2
GROUP BY YEAR(`created`), MONTH(`created`)
ORDER BY YEAR(`created`) DESC, MONTH(`created`) DESC
LIMIT 10
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | yukn2_content | NULL | ref | idx_state | idx_state | 1 | const | 1 | 100.00 | Using temporary; Using filesort |
| Status | Duration |
|---|
| starting | 0.06 ms |
| Executing hook on transaction | 0.01 ms |
| starting | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.05 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.05 ms |
| preparing | 0.01 ms |
| Creating tmp table | 0.03 ms |
| executing | 0.04 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| waiting for handler commit | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number |
|---|
| 13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 12 | JDatabaseDriver->loadObjectList() | JROOT/modules/mod_articles_archive/helper.php:51 |
| 11 | ModArchiveHelper::getList() | JROOT/modules/mod_articles_archive/mod_articles_archive.php:17 |
| 10 | include JROOT/modules/mod_articles_archive/mod_articles_archive.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
| 9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
| 8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
| 7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:511 |
| 6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:803 |
| 5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:577 |
| 4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1112 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 5.21 ms After last query: 0.38 ms Query memory: 0.116 MB Memory before query: 3.281 MB Rows returned: 5
SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN c.published = 2
AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum / v.rating_count, 0), 0), 0) AS rating,
COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
FROM yukn2_content AS a
LEFT JOIN yukn2_categories AS c
ON c.id = a.catid
LEFT JOIN yukn2_users AS ua
ON ua.id = a.created_by
LEFT JOIN yukn2_users AS uam
ON uam.id = a.modified_by
LEFT JOIN yukn2_categories as parent
ON parent.id = c.parent_id
LEFT JOIN yukn2_content_rating AS v
ON a.id = v.content_id
WHERE a.access IN (1,1,5)
AND c.access IN (1,1,5)
AND c.published = 1
AND a.state = 1
AND a.catid IN (9)
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-11-27 08:29:57')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-11-27 08:29:57')
ORDER BY a.hits DESC
LIMIT 5
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | c | NULL | const | PRIMARY,idx_access | PRIMARY | 4 | const | 1 | 100.00 | Using temporary; Using filesort |
| 1 | SIMPLE | a | NULL | ref | idx_access,idx_state,idx_catid | idx_catid | 4 | const | 50 | 16.00 | Using where |
| 1 | SIMPLE | ua | NULL | eq_ref | PRIMARY | PRIMARY | 4 | michaelzwilliamson_com.a.created_by | 1 | 100.00 | Using where |
| 1 | SIMPLE | uam | NULL | eq_ref | PRIMARY | PRIMARY | 4 | michaelzwilliamson_com.a.modified_by | 1 | 100.00 | Using where |
| 1 | SIMPLE | parent | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | Using where |
| 1 | SIMPLE | v | NULL | ALL | PRIMARY | NO INDEX KEY COULD BE USED | NULL | NULL | 1 | 100.00 | Using where; Using join buffer (hash join) |
| Status | Duration |
|---|
| starting | 1.91 ms |
| Executing hook on transaction | 0.01 ms |
| starting | 0.01 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.14 ms |
| init | 0.01 ms |
| System lock | 0.10 ms |
| optimizing | 0.04 ms |
| statistics | 0.18 ms |
| preparing | 0.04 ms |
| Creating tmp table | 0.25 ms |
| executing | 1.38 ms |
| end | 0.03 ms |
| query end | 0.00 ms |
| waiting for handler commit | 0.07 ms |
| closing tables | 0.03 ms |
| freeing items | 0.06 ms |
| logging slow query | 0.06 ms |
| cleaning up | 0.02 ms |
| # | Caller | File and line number |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 15 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 |
| 14 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:194 |
| 13 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/components/com_content/models/articles.php:576 |
| 12 | ContentModelArticles->getItems() | JROOT/modules/mod_articles_popular/helper.php:77 |
| 11 | ModArticlesPopularHelper::getList() | JROOT/modules/mod_articles_popular/mod_articles_popular.php:15 |
| 10 | include JROOT/modules/mod_articles_popular/mod_articles_popular.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
| 9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
| 8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
| 7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:511 |
| 6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:803 |
| 5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:577 |
| 4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1112 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
14 × 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 `yukn2_categories` AS `s`
INNER JOIN `yukn2_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
7 × SELECT `m`.`tag_id`,`t`.*
FROM `yukn2_contentitem_tag_map` AS m
INNER JOIN `yukn2_tags` AS t
ON `m`.`tag_id` = `t`.`id`
5 × SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM yukn2_fields AS a
LEFT JOIN `yukn2_languages` AS l
ON l.lang_code = a.language
LEFT JOIN yukn2_users AS uc
ON uc.id=a.checked_out
LEFT JOIN yukn2_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN yukn2_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN yukn2_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `yukn2_fields_categories` AS fc
ON fc.field_id = a.id
3 × SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN c.published = 2
AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum / v.rating_count, 0), 0), 0) AS rating, COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
FROM yukn2_content AS a
LEFT JOIN yukn2_categories AS c
ON c.id = a.catid
LEFT JOIN yukn2_users AS ua
ON ua.id = a.created_by
LEFT JOIN yukn2_users AS uam
ON uam.id = a.modified_by
LEFT JOIN yukn2_categories as parent
ON parent.id = c.parent_id
LEFT JOIN yukn2_content_rating AS v
ON a.id = v.content_id
2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `yukn2_extensions`
2 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `yukn2_assets`
2 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,( SELECT COUNT(i.`id`)
FROM `yukn2_content` AS `i`
1 × SELECT `session_id`
FROM `yukn2_session`
1 × SELECT id, rules
FROM `yukn2_viewlevels
1 × SELECT b.id
FROM yukn2_usergroups AS a
LEFT JOIN yukn2_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM yukn2_extensions
1 × SELECT `value`
FROM `yukn2_admintools_storage`
1 × SELECT *
FROM `yukn2_admintools_wafexceptions`
1 × SELECT `source`,`keepurlparams`
FROM `yukn2_admintools_redirects`
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 yukn2_menu AS m
LEFT JOIN yukn2_extensions AS e
ON m.component_id = e.extension_id
1 × SELECT *
FROM `yukn2_jcomments_settings`
1 × SELECT id, home, template, s.params
FROM yukn2_template_styles as s
LEFT JOIN yukn2_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
1 × SELECT *
FROM yukn2_languages
1 × SELECT COUNT(*)
FROM yukn2_content AS a
LEFT JOIN yukn2_categories AS c
ON c.id = a.catid
LEFT JOIN yukn2_users AS ua
ON ua.id = a.created_by
LEFT JOIN yukn2_users AS uam
ON uam.id = a.modified_by
LEFT JOIN yukn2_categories as parent
ON parent.id = c.parent_id
LEFT JOIN yukn2_content_rating AS v
ON a.id = v.content_id
1 × SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM yukn2_fields AS a
LEFT JOIN `yukn2_languages` AS l
ON l.lang_code = a.language
LEFT JOIN yukn2_users AS uc
ON uc.id=a.checked_out
LEFT JOIN yukn2_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN yukn2_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN yukn2_fields_groups AS g
ON g.id = a.group_id
1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM yukn2_modules AS m
LEFT JOIN yukn2_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN yukn2_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
1 × SELECT MAX(`tag_id`) AS tag_id, COUNT(*) AS count,MAX(t.title) AS title,MAX(`t`.`access`) AS access,MAX(`t`.`alias`) AS alias,MAX(`t`.`params`) AS params
FROM `yukn2_contentitem_tag_map` AS `m`
INNER JOIN `yukn2_tags` AS `t`
ON `tag_id` = t.id
INNER JOIN `yukn2_ucm_content` AS `c`
ON `m`.`core_content_id` = `c`.`core_content_id`
1 × SELECT a.*, c.description AS c_description, c.published AS c_published,
CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug,DATE_FORMAT(a.created, "%Y-%m-%d") AS created,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email
FROM `yukn2_weblinks` AS a
LEFT JOIN yukn2_categories AS c
ON c.id = a.catid
LEFT JOIN yukn2_users AS ua
ON ua.id = a.created_by
LEFT JOIN yukn2_users AS uam
ON uam.id = a.modified_by
1 × SELECT MONTH(`created`) AS created_month,MIN(`created`) AS created,YEAR(`created`) AS created_year
FROM yukn2_content
Dog spelt backwards is God.
Only God can save the world.
Yes, because rather than say, "God," it's so much easier to show a dog, and hint deceptively (how, exactly?) that "god" did it. Nevermind that the band is Swedish, and in Swedish, the words are "Hund" and "gud." (Pause while the twit runs off to chant "god is gud!")
I have no problem with faith, but it is possible to ascribe way too much to it. Especially as there's nothing on the band's site to indicate any religious affiliation at all.
And then we have:
Fucking Marxist propaganda
Really? I'm afraid I'm not following that, either. Dogs are marxist? Well, if they take down criminals in pain, I'm okay with that. And it's nice to see some artists who don't push the hippie myth that criminals are just misunderstood and only need a hug. It was nice to see a beat down.
I guess I see it more as "be like a dog, not like a sheep."
Because, you know, there were DOGS in the video, representing loyalty and strength.