Query Time: 0.64 ms Query memory: 0.020 MB Memory before query: 0.752 MB Rows returned: 0
SELECT `session_id`
FROM `yukn2_session`
WHERE `session_id` = X'3536643935626662313136663564646535316434313435353262643963613162'
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.17 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.03 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.39 ms After last query: 0.06 ms Query memory: 0.003 MB Memory before query: 0.757 MB
INSERT INTO `yukn2_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES
(X'3536643935626662313136663564646535316434313435353262643963613162', 1, 1734850002, 0, '', 0)
EXPLAIN not possible on query: INSERT INTO `yukn2_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES
(X'3536643935626662313136663564646535316434313435353262643963613162', 1, 1734850002, 0, '', 0)
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.02 ms |
init | 0.01 ms |
System lock | 0.01 ms |
update | 0.18 ms |
end | 0.01 ms |
query end | 0.01 ms |
waiting for handler commit | 0.82 ms |
closing tables | 0.01 ms |
freeing items | 0.02 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.91 ms After last query: 0.24 ms Query memory: 0.021 MB Memory before query: 0.786 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.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.13 ms |
init | 0.01 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.05 ms |
preparing | 0.02 ms |
executing | 0.19 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 |
---|
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.48 ms After last query: 0.30 ms Query memory: 0.020 MB Memory before query: 0.797 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.03 ms |
Executing hook on transaction | 0.01 ms |
starting | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.15 ms |
init | 0.01 ms |
System lock | 0.01 ms |
optimizing | 0.00 ms |
statistics | 0.01 ms |
preparing | 0.02 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 |
---|
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.78 ms After last query: 0.04 ms Query memory: 0.020 MB Memory before query: 0.807 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.04 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.16 ms |
init | 0.01 ms |
System lock | 0.01 ms |
optimizing | 0.02 ms |
statistics | 0.07 ms |
preparing | 0.03 ms |
executing | 0.08 ms |
end | 0.01 ms |
query end | 0.01 ms |
waiting for handler commit | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.03 ms |
cleaning up | 0.01 ms |
# | Caller | File and line number |
---|
11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1550 |
10 | JDatabaseDriver->loadColumn() | JROOT/libraries/src/Access/Access.php:980 |
9 | Joomla\CMS\Access\Access::getGroupsByUser() | JROOT/libraries/src/Access/Access.php:1095 |
8 | Joomla\CMS\Access\Access::getAuthorisedViewLevels() | JROOT/libraries/src/User/User.php:458 |
7 | Joomla\CMS\User\User->getAuthorisedViewLevels() | JROOT/libraries/src/Plugin/PluginHelper.php:318 |
6 | Joomla\CMS\Plugin\PluginHelper::load() | JROOT/libraries/src/Plugin/PluginHelper.php:87 |
5 | Joomla\CMS\Plugin\PluginHelper::getPlugin() | JROOT/libraries/src/Plugin/PluginHelper.php:129 |
4 | Joomla\CMS\Plugin\PluginHelper::isEnabled() | JROOT/libraries/src/Application/SiteApplication.php:604 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 1.36 ms After last query: 0.06 ms Query memory: 0.022 MB Memory before query: 0.827 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.06 ms |
Executing hook on transaction | 0.01 ms |
starting | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.01 ms |
System lock | 0.01 ms |
optimizing | 0.03 ms |
statistics | 0.08 ms |
preparing | 0.03 ms |
executing | 0.85 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 |
---|
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.70 ms After last query: 3.27 ms Query memory: 0.021 MB Memory before query: 1.136 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.08 ms |
Executing hook on transaction | 0.01 ms |
starting | 0.02 ms |
checking permissions | 0.01 ms |
Opening tables | 0.20 ms |
init | 0.01 ms |
System lock | 0.01 ms |
optimizing | 0.02 ms |
statistics | 0.05 ms |
preparing | 0.01 ms |
executing | 0.01 ms |
end | 0.01 ms |
query end | 0.01 ms |
waiting for handler commit | 0.01 ms |
closing tables | 0.03 ms |
freeing items | 0.03 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.48 ms After last query: 0.12 ms Query memory: 0.021 MB Memory before query: 1.145 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.04 ms |
Executing hook on transaction | 0.01 ms |
starting | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.14 ms |
init | 0.01 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.02 ms |
preparing | 0.02 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: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: 0.58 ms After last query: 3.65 ms Query memory: 0.021 MB Memory before query: 1.205 MB Rows returned: 0
SELECT `source`,`keepurlparams`
FROM `yukn2_admintools_redirects`
WHERE ((`dest` = 'index.php') OR (`dest` = 'index.php?itemid=543&start=432') OR ('index.php?itemid=543&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.08 ms |
Executing hook on transaction | 0.01 ms |
starting | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.17 ms |
init | 0.01 ms |
System lock | 0.01 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.04 ms |
cleaning up | 0.00 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: 0.84 ms After last query: 0.91 ms Query memory: 0.024 MB Memory before query: 1.310 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.05 ms |
Executing hook on transaction | 0.00 ms |
starting | 0.02 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
Opening tables | 0.19 ms |
init | 0.01 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.07 ms |
preparing | 0.03 ms |
executing | 0.17 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.00 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.50 ms After last query: 2.17 ms Query memory: 0.023 MB Memory before query: 1.407 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.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.09 ms |
preparing | 0.03 ms |
executing | 0.05 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.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.26 ms After last query: 0.07 ms Query memory: 0.006 MB Memory before query: 1.399 MB
UPDATE `yukn2_extensions`
SET `params` = '{\"mediaversion\":\"ead6db12ca293a5d1fd40008082935f1\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'
EXPLAIN not possible on query: UPDATE `yukn2_extensions`
SET `params` = '{\"mediaversion\":\"ead6db12ca293a5d1fd40008082935f1\"}'
WHERE `type` = 'library' AND `element` = 'joomla'
Status | Duration |
---|
starting | 0.03 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.06 ms |
updating | 0.11 ms |
end | 0.01 ms |
query end | 0.00 ms |
waiting for handler commit | 0.73 ms |
closing tables | 0.01 ms |
freeing items | 0.03 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: 0.65 ms After last query: 0.35 ms Query memory: 0.024 MB Memory before query: 1.427 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.03 ms |
Executing hook on transaction | 0.00 ms |
starting | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.14 ms |
init | 0.01 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.05 ms |
preparing | 0.02 ms |
executing | 0.19 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 |
---|
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: 0.62 ms After last query: 0.23 ms Query memory: 0.021 MB Memory before query: 1.432 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.05 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.14 ms |
init | 0.01 ms |
System lock | 0.01 ms |
optimizing | 0.02 ms |
statistics | 0.07 ms |
preparing | 0.03 ms |
executing | 0.08 ms |
end | 0.01 ms |
query end | 0.01 ms |
waiting for handler commit | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 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.62 ms After last query: 0.20 ms Query memory: 0.019 MB Memory before query: 1.452 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.17 ms |
init | 0.01 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.04 ms |
preparing | 0.05 ms |
executing | 0.06 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 |
---|
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.46 ms After last query: 1.19 ms Query memory: 0.025 MB Memory before query: 1.597 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.08 ms |
Executing hook on transaction | 0.01 ms |
starting | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.19 ms |
init | 0.01 ms |
System lock | 0.01 ms |
optimizing | 0.02 ms |
statistics | 0.21 ms |
preparing | 0.03 ms |
executing | 0.54 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 |
---|
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.26 ms After last query: 0.09 ms Query memory: 0.052 MB Memory before query: 1.648 MB Rows returned: 533
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 | 584 | 23.20 | Using where |
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.06 ms |
preparing | 0.02 ms |
executing | 0.85 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.03 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: 4.04 ms After last query: 0.85 ms Query memory: 0.023 MB Memory before query: 2.108 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.16 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.01 ms |
Opening tables | 0.46 ms |
init | 0.01 ms |
System lock | 0.01 ms |
optimizing | 0.02 ms |
statistics | 0.11 ms |
preparing | 0.03 ms |
optimizing | 0.01 ms |
statistics | 0.03 ms |
preparing | 0.02 ms |
executing | 0.14 ms |
executing | 0.04 ms |
executing | 0.24 ms |
executing | 0.21 ms |
executing | 0.36 ms |
executing | 0.08 ms |
executing | 0.17 ms |
executing | 0.81 ms |
executing | 0.25 ms |
executing | 0.07 ms |
executing | 0.08 ms |
executing | 0.11 ms |
executing | 0.04 ms |
executing | 0.04 ms |
executing | 0.06 ms |
executing | 0.05 ms |
executing | 0.05 ms |
end | 0.01 ms |
query end | 0.01 ms |
waiting for handler commit | 0.02 ms |
closing tables | 0.02 ms |
freeing items | 0.06 ms |
logging slow query | 0.07 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: 19.83 ms After last query: 0.42 ms Query memory: 0.149 MB Memory before query: 2.196 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-12-22 06:46:42')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-12-22 06:46:42')
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.35 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.01 ms |
checking permissions | 0.00 ms |
checking permissions | 0.01 ms |
checking permissions | 0.00 ms |
checking permissions | 0.01 ms |
Opening tables | 0.87 ms |
init | 0.05 ms |
System lock | 0.01 ms |
optimizing | 0.05 ms |
statistics | 0.19 ms |
preparing | 0.07 ms |
Creating tmp table | 0.13 ms |
optimizing | 0.02 ms |
statistics | 0.17 ms |
preparing | 0.21 ms |
executing | 15.99 ms |
end | 0.05 ms |
query end | 0.01 ms |
waiting for handler commit | 0.89 ms |
closing tables | 0.05 ms |
freeing items | 0.06 ms |
logging slow query | 0.04 ms |
cleaning up | 0.01 ms |
# | Caller | File and line number |
---|
18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
17 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 |
16 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:194 |
15 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/components/com_content/models/articles.php:576 |
14 | ContentModelArticles->getItems() | JROOT/components/com_content/models/category.php:253 |
13 | ContentModelCategory->getItems() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
12 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/libraries/src/MVC/View/CategoryView.php:144 |
11 | Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() | JROOT/components/com_content/views/category/view.html.php:75 |
10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 1.15 ms After last query: 0.28 ms Query memory: 0.023 MB Memory before query: 2.326 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` = 219
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.01 ms |
starting | 0.01 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
Opening tables | 0.24 ms |
init | 0.01 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.06 ms |
preparing | 0.02 ms |
executing | 0.03 ms |
end | 0.00 ms |
query end | 0.00 ms |
waiting for handler commit | 0.00 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 |
---|
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.95 ms After last query: 0.09 ms Query memory: 0.023 MB Memory before query: 2.343 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` = 218
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.03 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.02 ms |
init | 0.00 ms |
System lock | 0.00 ms |
optimizing | 0.01 ms |
statistics | 0.04 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.01 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.86 ms After last query: 0.08 ms Query memory: 0.023 MB Memory before query: 2.361 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.03 ms |
Executing hook on transaction | 0.00 ms |
starting | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.02 ms |
Opening tables | 0.03 ms |
init | 0.00 ms |
System lock | 0.00 ms |
optimizing | 0.01 ms |
statistics | 0.04 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.45 ms After last query: 0.07 ms Query memory: 0.023 MB Memory before query: 2.378 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.02 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.02 ms |
init | 0.00 ms |
System lock | 0.00 ms |
optimizing | 0.03 ms |
statistics | 0.04 ms |
preparing | 0.02 ms |
executing | 0.02 ms |
end | 0.00 ms |
query end | 0.00 ms |
waiting for handler commit | 0.00 ms |
closing tables | 0.01 ms |
freeing items | 0.02 ms |
logging slow query | 0.01 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.79 ms After last query: 0.07 ms Query memory: 0.023 MB Memory before query: 2.395 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.02 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.04 ms |
init | 0.00 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.04 ms |
preparing | 0.02 ms |
executing | 0.02 ms |
end | 0.00 ms |
query end | 0.00 ms |
waiting for handler commit | 0.00 ms |
closing tables | 0.01 ms |
freeing items | 0.02 ms |
logging slow query | 0.01 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.79 ms After last query: 0.07 ms Query memory: 0.023 MB Memory before query: 2.412 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.02 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.02 ms |
init | 0.00 ms |
System lock | 0.00 ms |
optimizing | 0.01 ms |
statistics | 0.07 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: 3.74 ms After last query: 0.19 ms Query memory: 0.023 MB Memory before query: 2.418 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-12-22 06:46:42')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-12-22 06:46:42')
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.09 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.08 ms |
init | 0.01 ms |
System lock | 0.01 ms |
optimizing | 0.03 ms |
statistics | 0.10 ms |
preparing | 0.04 ms |
optimizing | 0.01 ms |
statistics | 0.08 ms |
preparing | 0.03 ms |
executing | 2.96 ms |
end | 0.02 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 |
---|
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.59 ms After last query: 0.11 ms Query memory: 0.022 MB Memory before query: 2.424 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.05 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.05 ms |
init | 0.01 ms |
System lock | 0.01 ms |
optimizing | 0.02 ms |
statistics | 0.10 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.01 ms |
freeing items | 0.03 ms |
logging slow query | 0.03 ms |
cleaning up | 0.01 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: 0.89 ms After last query: 1.01 ms Query memory: 0.024 MB Memory before query: 2.455 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.13 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.17 ms |
preparing | 0.04 ms |
executing | 0.18 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 |
logging slow query | 0.06 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.34 ms After last query: 0.10 ms Query memory: 0.024 MB Memory before query: 2.476 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.15 ms |
Executing hook on transaction | 0.01 ms |
starting | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.01 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.01 ms |
Opening tables | 0.68 ms |
init | 0.01 ms |
System lock | 0.01 ms |
optimizing | 0.05 ms |
statistics | 0.46 ms |
preparing | 0.08 ms |
Creating tmp table | 0.26 ms |
executing | 0.17 ms |
end | 0.01 ms |
query end | 0.01 ms |
waiting for handler commit | 0.02 ms |
closing tables | 0.02 ms |
freeing items | 0.05 ms |
cleaning up | 0.03 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.32 ms After last query: 0.99 ms Query memory: 0.024 MB Memory before query: 2.508 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.16 ms |
Executing hook on transaction | 0.01 ms |
starting | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.06 ms |
init | 0.01 ms |
System lock | 0.07 ms |
optimizing | 0.03 ms |
statistics | 0.18 ms |
preparing | 0.05 ms |
executing | 0.21 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 |
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.39 ms After last query: 0.07 ms Query memory: 0.024 MB Memory before query: 2.516 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 (21,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.14 ms |
Executing hook on transaction | 0.01 ms |
starting | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.01 ms |
checking permissions | 0.00 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.10 ms |
init | 0.01 ms |
System lock | 0.03 ms |
optimizing | 0.05 ms |
statistics | 0.33 ms |
preparing | 0.04 ms |
Creating tmp table | 0.06 ms |
executing | 0.05 ms |
end | 0.01 ms |
query end | 0.03 ms |
waiting for handler commit | 0.02 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: 0.74 ms After last query: 0.54 ms Query memory: 0.024 MB Memory before query: 2.533 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.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.06 ms |
init | 0.01 ms |
System lock | 0.01 ms |
optimizing | 0.02 ms |
statistics | 0.12 ms |
preparing | 0.03 ms |
executing | 0.09 ms |
end | 0.01 ms |
query end | 0.01 ms |
waiting for handler commit | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.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: 1.20 ms After last query: 0.07 ms Query memory: 0.024 MB Memory before query: 2.542 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.13 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.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.00 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.05 ms |
statistics | 0.39 ms |
preparing | 0.03 ms |
Creating tmp table | 0.06 ms |
executing | 0.06 ms |
end | 0.01 ms |
query end | 0.01 ms |
waiting for handler commit | 0.01 ms |
closing tables | 0.02 ms |
freeing items | 0.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: 0.81 ms After last query: 1.24 ms Query memory: 0.024 MB Memory before query: 2.564 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.10 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.02 ms |
optimizing | 0.02 ms |
statistics | 0.17 ms |
preparing | 0.03 ms |
executing | 0.15 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 |
logging slow query | 0.06 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.36 ms After last query: 0.07 ms Query memory: 0.024 MB Memory before query: 2.571 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.16 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.01 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.01 ms |
Opening tables | 0.10 ms |
init | 0.01 ms |
System lock | 0.01 ms |
optimizing | 0.04 ms |
statistics | 0.40 ms |
preparing | 0.04 ms |
Creating tmp table | 0.09 ms |
executing | 0.07 ms |
end | 0.01 ms |
query end | 0.06 ms |
waiting for handler commit | 0.02 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: 1.02 ms After last query: 0.91 ms Query memory: 0.024 MB Memory before query: 2.591 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.16 ms |
Executing hook on transaction | 0.01 ms |
starting | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.08 ms |
init | 0.01 ms |
System lock | 0.01 ms |
optimizing | 0.03 ms |
statistics | 0.19 ms |
preparing | 0.04 ms |
executing | 0.20 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.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.10 ms After last query: 0.07 ms Query memory: 0.024 MB Memory before query: 2.599 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.12 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.01 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.01 ms |
Opening tables | 0.12 ms |
init | 0.01 ms |
System lock | 0.01 ms |
optimizing | 0.03 ms |
statistics | 0.34 ms |
preparing | 0.04 ms |
Creating tmp table | 0.06 ms |
executing | 0.05 ms |
end | 0.02 ms |
query end | 0.00 ms |
waiting for handler commit | 0.02 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.22 ms After last query: 2.30 ms Query memory: 0.026 MB Memory before query: 2.641 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.11 ms |
Executing hook on transaction | 0.01 ms |
starting | 0.01 ms |
checking permissions | 0.02 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 |
Opening tables | 0.09 ms |
init | 0.01 ms |
System lock | 0.01 ms |
optimizing | 0.03 ms |
statistics | 0.39 ms |
preparing | 0.03 ms |
Creating tmp table | 0.06 ms |
executing | 0.09 ms |
end | 0.01 ms |
query end | 0.01 ms |
waiting for handler commit | 0.02 ms |
closing tables | 0.02 ms |
freeing items | 0.04 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.24 ms Query memory: 0.026 MB Memory before query: 2.674 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-12-22 06:46:42')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-12-22 06:46:42')
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.11 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.01 ms |
Opening tables | 0.32 ms |
init | 0.01 ms |
System lock | 0.01 ms |
optimizing | 0.04 ms |
statistics | 0.09 ms |
preparing | 0.06 ms |
executing | 0.42 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 |
logging slow query | 0.06 ms |
cleaning up | 0.01 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: 1.32 ms After last query: 0.39 ms Query memory: 0.026 MB Memory before query: 2.687 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.13 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.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.01 ms |
Opening tables | 0.11 ms |
init | 0.01 ms |
System lock | 0.01 ms |
optimizing | 0.03 ms |
statistics | 0.47 ms |
preparing | 0.04 ms |
Creating tmp table | 0.08 ms |
executing | 0.10 ms |
end | 0.01 ms |
query end | 0.01 ms |
waiting for handler commit | 0.02 ms |
closing tables | 0.03 ms |
freeing items | 0.03 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: 1.14 ms After last query: 5.38 ms Query memory: 0.028 MB Memory before query: 2.760 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.20 ms |
Executing hook on transaction | 0.01 ms |
starting | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.12 ms |
init | 0.01 ms |
System lock | 0.01 ms |
optimizing | 0.03 ms |
statistics | 0.23 ms |
preparing | 0.04 ms |
executing | 0.09 ms |
end | 0.01 ms |
query end | 0.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 |
---|
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.80 ms After last query: 0.17 ms Query memory: 0.028 MB Memory before query: 2.779 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.09 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.05 ms |
init | 0.01 ms |
System lock | 0.01 ms |
optimizing | 0.02 ms |
statistics | 0.12 ms |
preparing | 0.05 ms |
executing | 0.07 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 |
---|
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.67 ms After last query: 0.12 ms Query memory: 0.028 MB Memory before query: 2.797 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.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.12 ms |
preparing | 0.03 ms |
executing | 0.08 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 |
---|
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.96 ms After last query: 0.20 ms Query memory: 0.028 MB Memory before query: 2.817 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.09 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.08 ms |
init | 0.01 ms |
System lock | 0.01 ms |
optimizing | 0.03 ms |
statistics | 0.13 ms |
preparing | 0.04 ms |
executing | 0.14 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 |
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.89 ms After last query: 0.11 ms Query memory: 0.028 MB Memory before query: 2.835 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.09 ms |
Executing hook on transaction | 0.00 ms |
starting | 0.01 ms |
checking permissions | 0.00 ms |
checking permissions | 0.01 ms |
Opening tables | 0.06 ms |
init | 0.03 ms |
System lock | 0.01 ms |
optimizing | 0.03 ms |
statistics | 0.14 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.79 ms After last query: 0.11 ms Query memory: 0.028 MB Memory before query: 2.853 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.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.06 ms |
init | 0.01 ms |
System lock | 0.01 ms |
optimizing | 0.03 ms |
statistics | 0.12 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.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: 1.01 ms After last query: 0.16 ms Query memory: 0.028 MB Memory before query: 2.873 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.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.14 ms |
preparing | 0.04 ms |
executing | 0.22 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 |
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.91 ms After last query: 0.11 ms Query memory: 0.028 MB Memory before query: 2.891 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.11 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.06 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.01 ms |
waiting for handler commit | 0.02 ms |
closing tables | 0.01 ms |
freeing items | 0.04 ms |
logging slow query | 0.04 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.98 ms After last query: 0.15 ms Query memory: 0.028 MB Memory before query: 2.909 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.20 ms |
Executing hook on transaction | 0.01 ms |
starting | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.06 ms |
init | 0.01 ms |
System lock | 0.01 ms |
optimizing | 0.03 ms |
statistics | 0.15 ms |
preparing | 0.04 ms |
executing | 0.16 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.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: 1.30 ms After last query: 3.34 ms Query memory: 0.022 MB Memory before query: 3.078 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-12-22 06:46:42')
AND (`c`.`core_publish_down` = '0000-00-00 00:00:00' OR `c`.`core_publish_down` >= '2024-12-22 06:46:42')
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.21 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.01 ms |
Opening tables | 0.35 ms |
init | 0.01 ms |
System lock | 0.01 ms |
optimizing | 0.03 ms |
statistics | 0.12 ms |
preparing | 0.03 ms |
Creating tmp table | 0.07 ms |
executing | 0.04 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.05 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.57 ms After last query: 0.51 ms Query memory: 0.024 MB Memory before query: 3.123 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.13 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 |
Opening tables | 0.08 ms |
init | 0.01 ms |
System lock | 0.01 ms |
optimizing | 0.02 ms |
statistics | 0.12 ms |
preparing | 0.03 ms |
optimizing | 0.01 ms |
statistics | 0.03 ms |
preparing | 0.01 ms |
executing | 0.10 ms |
executing | 0.02 ms |
executing | 0.36 ms |
executing | 0.16 ms |
executing | 0.21 ms |
executing | 0.08 ms |
executing | 0.10 ms |
executing | 0.45 ms |
executing | 0.15 ms |
executing | 0.03 ms |
executing | 0.04 ms |
executing | 0.03 ms |
executing | 0.02 ms |
executing | 0.02 ms |
executing | 0.02 ms |
executing | 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.02 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: 14.45 ms After last query: 0.26 ms Query memory: 0.243 MB Memory before query: 3.192 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-12-22 06:46:42')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-12-22 06:46:42')
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.13 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 |
Opening tables | 0.09 ms |
init | 0.01 ms |
System lock | 0.01 ms |
optimizing | 0.02 ms |
statistics | 0.13 ms |
preparing | 0.03 ms |
Creating tmp table | 0.14 ms |
executing | 12.82 ms |
end | 0.04 ms |
query end | 0.01 ms |
waiting for handler commit | 0.76 ms |
closing tables | 0.03 ms |
freeing items | 0.05 ms |
logging slow query | 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/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: 0.68 ms After last query: 1.12 ms Query memory: 0.022 MB Memory before query: 3.252 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-12-22 06:46:42')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-12-22 06:46:42')
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.12 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 |
Opening tables | 0.20 ms |
init | 0.01 ms |
System lock | 0.01 ms |
optimizing | 0.03 ms |
statistics | 0.07 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.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.40 ms After last query: 0.21 ms Query memory: 0.021 MB Memory before query: 3.257 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.05 ms |
Executing hook on transaction | 0.00 ms |
starting | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.00 ms |
System lock | 0.00 ms |
optimizing | 0.01 ms |
statistics | 0.04 ms |
preparing | 0.01 ms |
Creating tmp table | 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 |
---|
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: 1.71 ms After last query: 0.36 ms Query memory: 0.116 MB Memory before query: 3.274 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-12-22 06:46:42')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-12-22 06:46:42')
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 | 52 | 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 | 0.14 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.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
Opening tables | 0.07 ms |
init | 0.01 ms |
System lock | 0.01 ms |
optimizing | 0.02 ms |
statistics | 0.11 ms |
preparing | 0.03 ms |
Creating tmp table | 0.12 ms |
executing | 0.93 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.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/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`
6 × 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.