Query Time: 11.81 ms
SELECT `data`
FROM `jos_session`
WHERE `session_id` = X'6372703863686a6e6c6a34317161717038756769343563396336'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | jos_session | const | PRIMARY | PRIMARY | 194 | const | 1 | 100.00 | NULL |
Status | Duration |
---|
starting | 0.16 ms |
checking permissions | 0.08 ms |
Opening tables | 0.05 ms |
init | 0.16 ms |
System lock | 0.03 ms |
optimizing | 0.02 ms |
statistics | 10.63 ms |
executing | 0.04 ms |
end | 0.02 ms |
query end | 0.02 ms |
closing tables | 0.03 ms |
freeing items | 0.13 ms |
cleaning up | 0.03 ms |
# | Caller | File and line number |
---|
16 | JDatabaseDriverMysql->execute() | JROOT\libraries\joomla\database\driver.php:1740 |
15 | JDatabaseDriver->loadResult() | JROOT\libraries\joomla\session\storage\database.php:45 |
14 | JSessionStorageDatabase->read() | Same as call in the line below. |
13 | session_start() | JROOT\libraries\joomla\session\handler\native.php:260 |
12 | JSessionHandlerNative->doSessionStart() | JROOT\libraries\joomla\session\handler\native.php:50 |
11 | JSessionHandlerNative->start() | JROOT\libraries\joomla\session\handler\joomla.php:88 |
10 | JSessionHandlerJoomla->start() | JROOT\libraries\src\Session\Session.php:660 |
9 | Joomla\CMS\Session\Session->_start() | JROOT\libraries\src\Session\Session.php:620 |
8 | Joomla\CMS\Session\Session->start() | JROOT\libraries\src\Session\Session.php:498 |
7 | Joomla\CMS\Session\Session->get() | JROOT\libraries\src\Session\Session.php:455 |
6 | Joomla\CMS\Session\Session->isNew() | JROOT\libraries\src\Application\CMSApplication.php:758 |
5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT\libraries\src\Application\CMSApplication.php:135 |
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:344 |
2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT\libraries\src\Factory.php:140 |
1 | Joomla\CMS\Factory::getApplication() | JROOT\index.php:46 |
Query Time: 0.94 ms After last query: 33.76 ms
SELECT `session_id`
FROM `jos_session`
WHERE `session_id` = X'6372703863686a6e6c6a34317161717038756769343563396336'
LIMIT 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | jos_session | const | PRIMARY | PRIMARY | 194 | const | 1 | 100.00 | Using index |
Status | Duration |
---|
starting | 0.09 ms |
checking permissions | 0.02 ms |
Opening tables | 0.04 ms |
init | 0.04 ms |
System lock | 0.02 ms |
optimizing | 0.19 ms |
statistics | 0.07 ms |
executing | 0.02 ms |
end | 0.01 ms |
query end | 0.02 ms |
closing tables | 0.02 ms |
freeing items | 0.08 ms |
cleaning up | 0.04 ms |
# | Caller | File and line number |
---|
9 | JDatabaseDriverMysql->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:153 |
6 | Joomla\CMS\Application\CMSApplication->checkSession() | JROOT\libraries\src\Application\CMSApplication.php:760 |
5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT\libraries\src\Application\CMSApplication.php:135 |
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:344 |
2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT\libraries\src\Factory.php:140 |
1 | Joomla\CMS\Factory::getApplication() | JROOT\index.php:46 |
Query Time: 124.92 ms After last query: 0.52 ms
INSERT INTO `jos_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES
(X'6372703863686a6e6c6a34317161717038756769343563396336', 1, 1660022399, 0, '', 0)
EXPLAIN not possible on query: INSERT INTO `jos_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES
(X'6372703863686a6e6c6a34317161717038756769343563396336', 1, 1660022399, 0, '', 0)
Status | Duration |
---|
starting | 0.13 ms |
checking permissions | 0.02 ms |
Opening tables | 0.03 ms |
init | 0.09 ms |
System lock | 0.02 ms |
update | 52.48 ms |
end | 0.03 ms |
query end | 71.64 ms |
closing tables | 0.06 ms |
freeing items | 0.12 ms |
cleaning up | 0.04 ms |
# | Caller | File and line number |
---|
8 | JDatabaseDriverMysql->execute() | JROOT\libraries\src\Session\MetadataManager.php:116 |
7 | Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() | JROOT\libraries\src\Application\CMSApplication.php:153 |
6 | Joomla\CMS\Application\CMSApplication->checkSession() | JROOT\libraries\src\Application\CMSApplication.php:760 |
5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT\libraries\src\Application\CMSApplication.php:135 |
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:344 |
2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT\libraries\src\Factory.php:140 |
1 | Joomla\CMS\Factory::getApplication() | JROOT\index.php:46 |
Query Time: 2.42 ms After last query: 74.07 ms
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `jos_extensions`
WHERE `type` = 'component'
AND `state` = 0
AND `enabled` = 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | jos_extensions | ref | extension | extension | 82 | const | 44 | 100.00 | Using index condition; Using where |
Status | Duration |
---|
starting | 0.08 ms |
checking permissions | 0.02 ms |
Opening tables | 0.04 ms |
init | 0.05 ms |
System lock | 0.02 ms |
optimizing | 0.04 ms |
statistics | 0.15 ms |
preparing | 0.04 ms |
executing | 0.01 ms |
Sending data | 1.40 ms |
end | 0.02 ms |
query end | 0.02 ms |
closing tables | 0.03 ms |
freeing items | 0.05 ms |
cleaning up | 0.03 ms |
# | Caller | File and line number |
---|
12 | JDatabaseDriverMysql->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:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT\index.php:49 |
Query Time: 1.17 ms After last query: 40.14 ms
SELECT id, rules
FROM `jos_viewlevels`
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | jos_viewlevels | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 6 | 100.00 | NULL |
Status | Duration |
---|
starting | 0.05 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.02 ms |
System lock | 0.02 ms |
optimizing | 0.01 ms |
statistics | 0.02 ms |
preparing | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.54 ms |
end | 0.02 ms |
query end | 0.02 ms |
closing tables | 0.02 ms |
freeing items | 0.09 ms |
cleaning up | 0.03 ms |
# | Caller | File and line number |
---|
10 | JDatabaseDriverMysql->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:321 |
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:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT\index.php:49 |
Query Time: 1.05 ms After last query: 0.44 ms
SELECT b.id
FROM jos_usergroups AS a
LEFT JOIN jos_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 9
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | a | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
1 | SIMPLE | b | range | idx_usergroup_nested_set_lookup | idx_usergroup_nested_set_lookup | 4 | NULL | 4 | 100.00 | Using where; Using index |
Status | Duration |
---|
starting | 0.08 ms |
checking permissions | 0.02 ms |
checking permissions | 0.02 ms |
Opening tables | 0.03 ms |
init | 0.03 ms |
System lock | 0.02 ms |
optimizing | 0.03 ms |
statistics | 0.10 ms |
preparing | 0.03 ms |
executing | 0.01 ms |
Sending data | 0.05 ms |
end | 0.02 ms |
query end | 0.02 ms |
closing tables | 0.02 ms |
freeing items | 0.07 ms |
cleaning up | 0.03 ms |
# | Caller | File and line number |
---|
11 | JDatabaseDriverMysql->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:321 |
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:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT\index.php:49 |
Query Time: 2.96 ms After last query: 3.81 ms
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM jos_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 | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | jos_extensions | ref | extension | extension | 82 | const | 131 | 100.00 | Using index condition; Using where; Using filesort |
Status | Duration |
---|
starting | 0.07 ms |
checking permissions | 0.02 ms |
Opening tables | 0.03 ms |
init | 0.04 ms |
System lock | 0.02 ms |
optimizing | 0.02 ms |
statistics | 0.10 ms |
preparing | 0.03 ms |
Sorting result | 0.01 ms |
executing | 0.01 ms |
Sending data | 0.02 ms |
Creating sort index | 1.69 ms |
end | 0.02 ms |
query end | 0.02 ms |
closing tables | 0.03 ms |
freeing items | 0.18 ms |
cleaning up | 0.09 ms |
# | Caller | File and line number |
---|
11 | JDatabaseDriverMysql->execute() | JROOT\libraries\joomla\database\driver.php:1701 |
10 | JDatabaseDriver->loadObjectList() | JROOT\libraries\src\Plugin\PluginHelper.php:354 |
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:359 |
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:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT\index.php:49 |
Query Time: 1.64 ms After last query: 188.18 ms
SELECT `enabled`
FROM `jos_extensions`
WHERE `element` = 'com_akeeba'
AND `type` = 'component'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | jos_extensions | ref | element_clientid,element_folder_clientid,extension | element_clientid | 402 | const | 1 | 100.00 | Using index condition; Using where |
Status | Duration |
---|
starting | 0.09 ms |
checking permissions | 0.02 ms |
Opening tables | 0.05 ms |
init | 0.04 ms |
System lock | 0.02 ms |
optimizing | 0.05 ms |
statistics | 0.18 ms |
preparing | 0.05 ms |
executing | 0.01 ms |
Sending data | 0.11 ms |
end | 0.02 ms |
query end | 0.02 ms |
closing tables | 0.02 ms |
freeing items | 0.11 ms |
cleaning up | 0.03 ms |
# | Caller | File and line number |
---|
9 | JDatabaseDriverMysql->execute() | JROOT\libraries\joomla\database\driver.php:1740 |
8 | JDatabaseDriver->loadResult() | JROOT\plugins\system\backuponupdate\backuponupdate.php:79 |
7 | require_once JROOT\plugins\system\backuponupdate\backuponupdate.php | JROOT\libraries\src\Plugin\PluginHelper.php:253 |
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:625 |
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:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT\index.php:49 |
Query Time: 7.93 ms After last query: 240.27 ms
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 jos_menu AS m
LEFT JOIN jos_extensions AS e
ON m.component_id = e.extension_id
WHERE m.published = 1
AND m.parent_id > 0
AND m.client_id = 0
ORDER BY m.lft
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | m | ALL | idx_client_id_parent_id_alias_language | NO INDEX KEY COULD BE USED | NULL | NULL | 208 | 77.40 | Using where; Using filesort |
1 | SIMPLE | e | eq_ref | PRIMARY | PRIMARY | 4 | phubbard_joomla_e.m.component_id | 1 | 100.00 | Using where |
Status | Duration |
---|
starting | 0.16 ms |
checking permissions | 0.02 ms |
checking permissions | 0.02 ms |
Opening tables | 0.07 ms |
init | 0.08 ms |
System lock | 0.05 ms |
optimizing | 0.07 ms |
statistics | 0.13 ms |
preparing | 0.09 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.05 ms |
Creating sort index | 4.62 ms |
end | 0.05 ms |
query end | 0.03 ms |
closing tables | 0.06 ms |
freeing items | 0.23 ms |
cleaning up | 0.05 ms |
# | Caller | File and line number |
---|
19 | JDatabaseDriverMysql->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:76 |
13 | Joomla\CMS\Menu\AbstractMenu->__construct() | JROOT\libraries\src\Menu\SiteMenu.php:62 |
12 | Joomla\CMS\Menu\SiteMenu->__construct() | JROOT\libraries\src\Menu\AbstractMenu.php:131 |
11 | Joomla\CMS\Menu\AbstractMenu::getInstance() | JROOT\libraries\src\Application\CMSApplication.php:375 |
10 | Joomla\CMS\Application\CMSApplication->getMenu() | JROOT\libraries\src\Application\SiteApplication.php:275 |
9 | Joomla\CMS\Application\SiteApplication->getMenu() | JROOT\libraries\src\Router\SiteRouter.php:64 |
8 | Joomla\CMS\Router\SiteRouter->__construct() | JROOT\libraries\src\Router\Router.php:189 |
7 | Joomla\CMS\Router\Router::getInstance() | JROOT\libraries\src\Application\CMSApplication.php:491 |
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:1073 |
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:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT\index.php:49 |
Query Time: 0.82 ms After last query: 241.64 ms
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `jos_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | jos_extensions | ref | element_clientid,element_folder_clientid,extension | extension | 484 | const,const | 1 | 100.00 | Using index condition |
Status | Duration |
---|
starting | 0.06 ms |
checking permissions | 0.02 ms |
Opening tables | 0.03 ms |
init | 0.03 ms |
System lock | 0.02 ms |
optimizing | 0.02 ms |
statistics | 0.12 ms |
preparing | 0.03 ms |
executing | 0.01 ms |
Sending data | 0.07 ms |
end | 0.02 ms |
query end | 0.02 ms |
closing tables | 0.04 ms |
freeing items | 0.07 ms |
cleaning up | 0.03 ms |
# | Caller | File and line number |
---|
15 | JDatabaseDriverMysql->execute() | JROOT\libraries\joomla\database\driver.php:1662 |
14 | JDatabaseDriver->loadObject() | JROOT\libraries\src\Helper\LibraryHelper.php:167 |
13 | Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}() | Same as call in the line below. |
12 | call_user_func_array() | JROOT\libraries\src\Cache\Controller\CallbackController.php:173 |
11 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT\libraries\src\Helper\LibraryHelper.php:175 |
10 | Joomla\CMS\Helper\LibraryHelper::loadLibrary() | JROOT\libraries\src\Helper\LibraryHelper.php:43 |
9 | Joomla\CMS\Helper\LibraryHelper::getLibrary() | JROOT\libraries\src\Helper\LibraryHelper.php:90 |
8 | Joomla\CMS\Helper\LibraryHelper::getParams() | JROOT\libraries\src\Version.php:321 |
7 | Joomla\CMS\Version->getMediaVersion() | JROOT\libraries\src\Factory.php:778 |
6 | Joomla\CMS\Factory::createDocument() | JROOT\libraries\src\Factory.php:234 |
5 | Joomla\CMS\Factory::getDocument() | JROOT\libraries\src\Application\WebApplication.php:1130 |
4 | Joomla\CMS\Application\WebApplication->loadDocument() | JROOT\libraries\src\Application\SiteApplication.php:133 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT\libraries\src\Application\SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT\libraries\src\Application\CMSApplication.php:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT\index.php:49 |
Query Time: 11.51 ms After last query: 0.59 ms
UPDATE `jos_extensions`
SET `params` = '{\"mediaversion\":\"216da1a5cc689b6c8e10b62fe7c05469\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | jos_extensions | range | element_clientid,element_folder_clientid,extension | extension | 484 | const,const | 1 | 100.00 | Using where |
Status | Duration |
---|
starting | 0.07 ms |
checking permissions | 0.02 ms |
Opening tables | 0.04 ms |
init | 0.05 ms |
System lock | 0.14 ms |
updating | 0.65 ms |
end | 0.03 ms |
query end | 10.12 ms |
closing tables | 0.03 ms |
freeing items | 0.03 ms |
cleaning up | 0.03 ms |
# | Caller | File and line number |
---|
10 | JDatabaseDriverMysql->execute() | JROOT\libraries\src\Helper\LibraryHelper.php:117 |
9 | Joomla\CMS\Helper\LibraryHelper::saveParams() | JROOT\libraries\src\Version.php:372 |
8 | Joomla\CMS\Version->setMediaVersion() | JROOT\libraries\src\Version.php:331 |
7 | Joomla\CMS\Version->getMediaVersion() | JROOT\libraries\src\Factory.php:778 |
6 | Joomla\CMS\Factory::createDocument() | JROOT\libraries\src\Factory.php:234 |
5 | Joomla\CMS\Factory::getDocument() | JROOT\libraries\src\Application\WebApplication.php:1130 |
4 | Joomla\CMS\Application\WebApplication->loadDocument() | JROOT\libraries\src\Application\SiteApplication.php:133 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT\libraries\src\Application\SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT\libraries\src\Application\CMSApplication.php:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT\index.php:49 |
Query Time: 0.72 ms After last query: 32.53 ms
SELECT *
FROM jos_languages
WHERE published=1
ORDER BY ordering ASC
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | jos_languages | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 1 | 100.00 | Using where; Using filesort |
Status | Duration |
---|
starting | 0.07 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.04 ms |
System lock | 0.02 ms |
optimizing | 0.02 ms |
statistics | 0.02 ms |
preparing | 0.02 ms |
Sorting result | 0.01 ms |
executing | 0.01 ms |
Sending data | 0.02 ms |
Creating sort index | 0.09 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.08 ms |
cleaning up | 0.07 ms |
# | Caller | File and line number |
---|
7 | JDatabaseDriverMysql->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:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT\index.php:49 |
Query Time: 1.39 ms After last query: 2.05 ms
SELECT id, home, template, s.params
FROM jos_template_styles as s
LEFT JOIN jos_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
WHERE s.client_id = 0
AND e.enabled = 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | s | ALL | idx_template,idx_client_id,idx_client_id_home | NO INDEX KEY COULD BE USED | NULL | NULL | 7 | 71.43 | Using where |
1 | SIMPLE | e | ref | element_clientid,element_folder_clientid,extension | element_clientid | 403 | phubbard_joomla_e.s.template,const | 1 | 100.00 | Using index condition; Using where |
Status | Duration |
---|
starting | 0.18 ms |
checking permissions | 0.02 ms |
checking permissions | 0.01 ms |
Opening tables | 0.06 ms |
init | 0.04 ms |
System lock | 0.02 ms |
optimizing | 0.03 ms |
statistics | 0.21 ms |
preparing | 0.05 ms |
executing | 0.01 ms |
Sending data | 0.28 ms |
end | 0.01 ms |
query end | 0.02 ms |
closing tables | 0.03 ms |
freeing items | 0.19 ms |
cleaning up | 0.06 ms |
# | Caller | File and line number |
---|
6 | JDatabaseDriverMysql->execute() | JROOT\libraries\joomla\database\driver.php:1701 |
5 | JDatabaseDriver->loadObjectList() | JROOT\libraries\src\Application\SiteApplication.php:486 |
4 | Joomla\CMS\Application\SiteApplication->getTemplate() | JROOT\libraries\src\Application\SiteApplication.php:168 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT\libraries\src\Application\SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT\libraries\src\Application\CMSApplication.php:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT\index.php:49 |
Query Time: 2.70 ms After last query: 131.92 ms
SELECT `id`,`name`,`rules`,`parent_id`
FROM `jos_assets`
WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_akeeba','com_arilayerslider','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_djimageslider','com_edocman','com_extplorer','com_fields','com_finder','com_gantry','com_installer','com_jce','com_jevents','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_smartcountdown3','com_tags','com_templates','com_uniterevolution2','com_users','com_wrapper')
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | jos_assets | range | idx_asset_name | idx_asset_name | 202 | NULL | 45 | 100.00 | Using index condition |
Status | Duration |
---|
starting | 0.11 ms |
checking permissions | 0.02 ms |
Opening tables | 0.21 ms |
init | 0.11 ms |
System lock | 0.02 ms |
optimizing | 0.02 ms |
statistics | 0.35 ms |
preparing | 0.05 ms |
executing | 0.01 ms |
Sending data | 1.22 ms |
end | 0.03 ms |
query end | 0.02 ms |
closing tables | 0.02 ms |
freeing items | 0.20 ms |
cleaning up | 0.08 ms |
# | Caller | File and line number |
---|
20 | JDatabaseDriverMysql->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:440 |
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:672 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT\components\com_content\controller.php:118 |
8 | ContentController->display() | JROOT\libraries\src\MVC\Controller\BaseController.php:710 |
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:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT\index.php:49 |
Query Time: 4.89 ms After last query: 1.03 ms
SELECT `id`,`name`,`rules`,`parent_id`
FROM `jos_assets`
WHERE `name` LIKE 'com_content.%' OR `name` = 'com_content' OR `parent_id` = 0
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | jos_assets | ALL | idx_asset_name,idx_parent_id | NO INDEX KEY COULD BE USED | NULL | NULL | 2427 | 100.00 | Using where |
Status | Duration |
---|
starting | 0.05 ms |
checking permissions | 0.02 ms |
Opening tables | 0.04 ms |
init | 0.05 ms |
System lock | 0.02 ms |
optimizing | 0.03 ms |
statistics | 0.13 ms |
preparing | 0.04 ms |
executing | 0.01 ms |
Sending data | 4.03 ms |
end | 0.02 ms |
query end | 0.02 ms |
closing tables | 0.02 ms |
freeing items | 0.12 ms |
cleaning up | 0.03 ms |
# | Caller | File and line number |
---|
20 | JDatabaseDriverMysql->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:440 |
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:672 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT\components\com_content\controller.php:118 |
8 | ContentController->display() | JROOT\libraries\src\MVC\Controller\BaseController.php:710 |
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:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT\index.php:49 |
Query Time: 144.95 ms After last query: 41.90 ms
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 `jos_content` AS `i`
WHERE i.`catid` = c.id
AND i.state = 1) AS numitems
FROM `jos_categories` AS `s`
INNER JOIN `jos_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 = 225
ORDER BY c.lft
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | PRIMARY | s | const | PRIMARY,idx_left_right | PRIMARY | 4 | const | 1 | 100.00 | Using filesort |
1 | PRIMARY | c | ALL | cat_idx,idx_left_right | NO INDEX KEY COULD BE USED | NULL | NULL | 227 | 25.55 | Using where |
2 | DEPENDENT SUBQUERY | i | ref | idx_state,idx_catid | idx_catid | 4 | phubbard_joomla_e.c.id | 1 | 100.00 | Using index condition; Using where |
Status | Duration |
---|
starting | 0.18 ms |
checking permissions | 0.02 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.05 ms |
init | 0.08 ms |
System lock | 0.02 ms |
optimizing | 0.02 ms |
statistics | 0.20 ms |
preparing | 0.04 ms |
Sorting result | 0.01 ms |
executing | 0.01 ms |
Sending data | 0.03 ms |
Creating sort index | 32.70 ms |
optimizing | 0.05 ms |
statistics | 43.70 ms |
preparing | 0.02 ms |
executing | 0.01 ms |
Sending data | 11.48 ms |
executing | 0.02 ms |
Sending data | 33.00 ms |
executing | 0.02 ms |
Sending data | 11.67 ms |
executing | 0.03 ms |
Sending data | 0.08 ms |
executing | 0.02 ms |
Sending data | 0.97 ms |
executing | 0.03 ms |
Sending data | 9.53 ms |
executing | 0.03 ms |
Sending data | 0.08 ms |
end | 0.03 ms |
query end | 0.03 ms |
closing tables | 0.04 ms |
freeing items | 0.26 ms |
cleaning up | 0.10 ms |
# | Caller | File and line number |
---|
17 | JDatabaseDriverMysql->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:672 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT\components\com_content\controller.php:118 |
8 | ContentController->display() | JROOT\libraries\src\MVC\Controller\BaseController.php:710 |
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:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT\index.php:49 |
Query Time: 51.53 ms After last query: 14.24 ms
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 jos_content AS a
LEFT JOIN jos_categories AS c
ON c.id = a.catid
LEFT JOIN jos_users AS ua
ON ua.id = a.created_by
LEFT JOIN jos_users AS uam
ON uam.id = a.modified_by
LEFT JOIN jos_categories as parent
ON parent.id = c.parent_id
LEFT JOIN jos_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 = 225
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2022-08-09 05:20:01')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2022-08-09 05:20:01')
ORDER BY c.lft, a.ordering, a.created
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | c | const | PRIMARY,idx_access | PRIMARY | 4 | const | 1 | 100.00 | Using filesort |
1 | SIMPLE | a | ref | idx_access,idx_state,idx_catid | idx_catid | 4 | const | 1 | 100.00 | Using where |
1 | SIMPLE | ua | eq_ref | PRIMARY | PRIMARY | 4 | phubbard_joomla_e.a.created_by | 1 | 100.00 | Using where |
1 | SIMPLE | uam | eq_ref | PRIMARY | PRIMARY | 4 | phubbard_joomla_e.a.modified_by | 1 | 100.00 | Using where |
1 | SIMPLE | parent | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | Using where |
1 | SIMPLE | v | eq_ref | PRIMARY | PRIMARY | 4 | phubbard_joomla_e.a.id | 1 | 100.00 | Using where |
Status | Duration |
---|
starting | 0.18 ms |
checking permissions | 0.03 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.04 ms |
init | 0.09 ms |
System lock | 0.02 ms |
optimizing | 0.03 ms |
statistics | 17.64 ms |
preparing | 0.05 ms |
Sorting result | 0.01 ms |
executing | 0.01 ms |
Sending data | 0.04 ms |
Creating sort index | 32.84 ms |
end | 0.02 ms |
query end | 0.01 ms |
closing tables | 0.03 ms |
freeing items | 0.16 ms |
cleaning up | 0.04 ms |
# | Caller | File and line number |
---|
18 | JDatabaseDriverMysql->execute() | JROOT\libraries\joomla\database\driver.php:1701 |
17 | JDatabaseDriver->loadObjectList() | JROOT\libraries\src\MVC\Model\BaseDatabaseModel.php:308 |
16 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT\libraries\src\MVC\Model\ListModel.php:187 |
15 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT\components\com_content\models\articles.php: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:672 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT\components\com_content\controller.php:118 |
8 | ContentController->display() | JROOT\libraries\src\MVC\Controller\BaseController.php:710 |
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:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT\index.php:49 |
Query Time: 29.85 ms After last query: 11.07 ms
SELECT `m`.`tag_id`,`t`.*
FROM `jos_contentitem_tag_map` AS m
INNER JOIN `jos_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 425
AND `t`.`published` = 1
AND t.access IN (1,1,5)
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | m | ALL | idx_tag_type | NO INDEX KEY COULD BE USED | NULL | NULL | 2 | 100.00 | Using where |
1 | SIMPLE | t | eq_ref | PRIMARY,tag_idx,idx_access | PRIMARY | 4 | phubbard_joomla_e.m.tag_id | 1 | 100.00 | Using where |
Status | Duration |
---|
starting | 0.08 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.05 ms |
System lock | 0.02 ms |
optimizing | 0.02 ms |
statistics | 19.72 ms |
preparing | 0.03 ms |
executing | 0.01 ms |
Sending data | 9.44 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.02 ms |
freeing items | 0.10 ms |
cleaning up | 0.05 ms |
# | Caller | File and line number |
---|
17 | JDatabaseDriverMysql->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:672 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT\components\com_content\controller.php:118 |
8 | ContentController->display() | JROOT\libraries\src\MVC\Controller\BaseController.php:710 |
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:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT\index.php:49 |
Query Time: 1.68 ms After last query: 18.57 ms
SELECT COUNT(*)
FROM jos_content AS a
LEFT JOIN jos_categories AS c
ON c.id = a.catid
LEFT JOIN jos_users AS ua
ON ua.id = a.created_by
LEFT JOIN jos_users AS uam
ON uam.id = a.modified_by
LEFT JOIN jos_categories as parent
ON parent.id = c.parent_id
LEFT JOIN jos_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 = 225
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2022-08-09 05:20:01')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2022-08-09 05:20:01')
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | c | const | PRIMARY,idx_access | PRIMARY | 4 | const | 1 | 100.00 | NULL |
1 | SIMPLE | a | ref | idx_access,idx_state,idx_catid | idx_catid | 4 | const | 1 | 100.00 | Using where |
1 | SIMPLE | ua | eq_ref | PRIMARY | PRIMARY | 4 | phubbard_joomla_e.a.created_by | 1 | 100.00 | Using where; Using index |
1 | SIMPLE | uam | eq_ref | PRIMARY | PRIMARY | 4 | phubbard_joomla_e.a.modified_by | 1 | 100.00 | Using where; Using index |
1 | SIMPLE | parent | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | Using where; Using index |
1 | SIMPLE | v | eq_ref | PRIMARY | PRIMARY | 4 | phubbard_joomla_e.a.id | 1 | 100.00 | Using where; Using index |
Status | Duration |
---|
starting | 0.16 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.08 ms |
init | 0.09 ms |
System lock | 0.03 ms |
optimizing | 0.04 ms |
statistics | 0.22 ms |
preparing | 0.13 ms |
executing | 0.01 ms |
Sending data | 0.17 ms |
end | 0.05 ms |
query end | 0.02 ms |
closing tables | 0.05 ms |
freeing items | 0.18 ms |
cleaning up | 0.06 ms |
# | Caller | File and line number |
---|
18 | JDatabaseDriverMysql->execute() | JROOT\libraries\joomla\database\driver.php:1740 |
17 | JDatabaseDriver->loadResult() | JROOT\libraries\src\MVC\Model\BaseDatabaseModel.php:340 |
16 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount() | JROOT\libraries\src\MVC\Model\ListModel.php:282 |
15 | Joomla\CMS\MVC\Model\ListModel->getTotal() | JROOT\libraries\src\MVC\Model\ListModel.php:232 |
14 | Joomla\CMS\MVC\Model\ListModel->getPagination() | JROOT\components\com_content\models\category.php:265 |
13 | ContentModelCategory->getItems() | JROOT\libraries\src\MVC\View\HtmlView.php: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:672 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT\components\com_content\controller.php:118 |
8 | ContentController->display() | JROOT\libraries\src\MVC\Controller\BaseController.php:710 |
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:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT\index.php:49 |
Query Time: 2.01 ms After last query: 0.85 ms
SELECT `m`.`tag_id`,`t`.*
FROM `jos_contentitem_tag_map` AS m
INNER JOIN `jos_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.category'
AND `m`.`content_item_id` = 225
AND `t`.`published` = 1
AND t.access IN (1,1,5)
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | m | ALL | idx_tag_type | NO INDEX KEY COULD BE USED | NULL | NULL | 2 | 100.00 | Using where |
1 | SIMPLE | t | eq_ref | PRIMARY,tag_idx,idx_access | PRIMARY | 4 | phubbard_joomla_e.m.tag_id | 1 | 100.00 | Using where |
Status | Duration |
---|
starting | 0.11 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.16 ms |
init | 0.18 ms |
System lock | 0.03 ms |
optimizing | 0.03 ms |
statistics | 0.54 ms |
preparing | 0.13 ms |
executing | 0.01 ms |
Sending data | 0.09 ms |
end | 0.01 ms |
query end | 0.02 ms |
closing tables | 0.02 ms |
freeing items | 0.25 ms |
cleaning up | 0.36 ms |
# | Caller | File and line number |
---|
14 | JDatabaseDriverMysql->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:672 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT\components\com_content\controller.php:118 |
8 | ContentController->display() | JROOT\libraries\src\MVC\Controller\BaseController.php:710 |
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:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT\index.php:49 |
Query Time: 6.14 ms After last query: 128.98 ms
SELECT MAX(ordering)
FROM `jos_extensions`
WHERE `type` = 'plugin'
AND `folder` = 'content'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | jos_extensions | ref | extension | extension | 82 | const | 131 | 100.00 | Using index condition |
Status | Duration |
---|
starting | 0.09 ms |
checking permissions | 0.02 ms |
Opening tables | 0.04 ms |
init | 0.05 ms |
System lock | 0.02 ms |
optimizing | 0.03 ms |
statistics | 0.10 ms |
preparing | 0.03 ms |
executing | 0.01 ms |
Sending data | 0.33 ms |
end | 0.02 ms |
query end | 0.02 ms |
closing tables | 0.02 ms |
freeing items | 0.14 ms |
cleaning up | 0.03 ms |
# | Caller | File and line number |
---|
15 | JDatabaseDriverMysql->execute() | JROOT\libraries\joomla\database\driver.php:1740 |
14 | JDatabaseDriver->loadResult() | JROOT\plugins\content\perfect_everything_in_everyway\perfect_everything_in_everyway.php:54 |
13 | PlgContentPerfect_everything_in_everyway->__construct() | JROOT\libraries\src\Plugin\PluginHelper.php:283 |
12 | Joomla\CMS\Plugin\PluginHelper::import() | JROOT\libraries\src\Plugin\PluginHelper.php:182 |
11 | Joomla\CMS\Plugin\PluginHelper::importPlugin() | JROOT\components\com_content\views\category\view.html.php:88 |
10 | ContentViewCategory->display() | JROOT\libraries\src\MVC\Controller\BaseController.php:672 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT\components\com_content\controller.php:118 |
8 | ContentController->display() | JROOT\libraries\src\MVC\Controller\BaseController.php:710 |
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:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT\index.php:49 |
Query Time: 9.16 ms After last query: 0.41 ms
SELECT `ordering`
FROM `jos_extensions`
WHERE `type` = 'plugin'
AND `folder` = 'content'
AND `element` = 'perfect_everything_in_everyway'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | jos_extensions | ref | element_clientid,element_folder_clientid,extension | element_folder_clientid | 804 | const,const | 1 | 100.00 | Using index condition; Using where |
Status | Duration |
---|
starting | 0.09 ms |
checking permissions | 0.02 ms |
Opening tables | 0.03 ms |
init | 0.04 ms |
System lock | 0.02 ms |
optimizing | 0.03 ms |
statistics | 0.15 ms |
preparing | 0.03 ms |
executing | 0.01 ms |
Sending data | 0.08 ms |
end | 0.01 ms |
query end | 0.02 ms |
closing tables | 0.02 ms |
freeing items | 0.04 ms |
cleaning up | 0.03 ms |
# | Caller | File and line number |
---|
15 | JDatabaseDriverMysql->execute() | JROOT\libraries\joomla\database\driver.php:1740 |
14 | JDatabaseDriver->loadResult() | JROOT\plugins\content\perfect_everything_in_everyway\perfect_everything_in_everyway.php:73 |
13 | PlgContentPerfect_everything_in_everyway->__construct() | JROOT\libraries\src\Plugin\PluginHelper.php:283 |
12 | Joomla\CMS\Plugin\PluginHelper::import() | JROOT\libraries\src\Plugin\PluginHelper.php:182 |
11 | Joomla\CMS\Plugin\PluginHelper::importPlugin() | JROOT\components\com_content\views\category\view.html.php:88 |
10 | ContentViewCategory->display() | JROOT\libraries\src\MVC\Controller\BaseController.php:672 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT\components\com_content\controller.php:118 |
8 | ContentController->display() | JROOT\libraries\src\MVC\Controller\BaseController.php:710 |
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:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT\index.php:49 |
Query Time: 1.85 ms After last query: 36.27 ms
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 `jos_categories` AS `s`
INNER JOIN `jos_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 = 225
ORDER BY c.lft
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | s | const | PRIMARY,idx_left_right | PRIMARY | 4 | const | 1 | 100.00 | Using filesort |
1 | SIMPLE | c | ALL | cat_idx,idx_access,idx_left_right | NO INDEX KEY COULD BE USED | NULL | NULL | 227 | 25.55 | Using where |
Status | Duration |
---|
starting | 0.13 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.06 ms |
System lock | 0.02 ms |
optimizing | 0.03 ms |
statistics | 0.22 ms |
preparing | 0.03 ms |
Sorting result | 0.01 ms |
executing | 0.01 ms |
Sending data | 0.04 ms |
Creating sort index | 0.45 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.02 ms |
freeing items | 0.11 ms |
cleaning up | 0.03 ms |
# | Caller | File and line number |
---|
22 | JDatabaseDriverMysql->execute() | JROOT\libraries\joomla\database\driver.php:1701 |
21 | JDatabaseDriver->loadObjectList() | JROOT\libraries\src\Categories\Categories.php:324 |
20 | Joomla\CMS\Categories\Categories->_load() | JROOT\libraries\src\Categories\Categories.php:184 |
19 | Joomla\CMS\Categories\Categories->get() | JROOT\administrator\components\com_fields\models\fields.php:203 |
18 | FieldsModelFields->getListQuery() | JROOT\libraries\src\MVC\Model\ListModel.php:133 |
17 | Joomla\CMS\MVC\Model\ListModel->_getListQuery() | JROOT\libraries\src\MVC\Model\ListModel.php:187 |
16 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT\administrator\components\com_fields\helpers\fields.php:135 |
15 | FieldsHelper::getFields() | JROOT\plugins\system\fields\fields.php:495 |
14 | PlgSystemFields->onContentPrepare() | Same as call in the line below. |
13 | call_user_func_array() | JROOT\libraries\joomla\event\event.php:70 |
12 | JEvent->update() | JROOT\libraries\joomla\event\dispatcher.php:160 |
11 | JEventDispatcher->trigger() | JROOT\components\com_content\views\category\view.html.php:113 |
10 | ContentViewCategory->display() | JROOT\libraries\src\MVC\Controller\BaseController.php:672 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT\components\com_content\controller.php:118 |
8 | ContentController->display() | JROOT\libraries\src\MVC\Controller\BaseController.php:710 |
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:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT\index.php:49 |
Query Time: 10.26 ms After last query: 1.21 ms
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 jos_fields AS a
LEFT JOIN `jos_languages` AS l
ON l.lang_code = a.language
LEFT JOIN jos_users AS uc
ON uc.id=a.checked_out
LEFT JOIN jos_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN jos_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN jos_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `jos_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 (225,0,164,60,17,15,16))
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 | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | a | ref | idx_state,idx_access,idx_context | idx_state | 1 | const | 1 | 100.00 | Using where; Using temporary; Using filesort |
1 | SIMPLE | l | eq_ref | idx_langcode | idx_langcode | 28 | phubbard_joomla_e.a.language | 1 | 100.00 | Using where |
1 | SIMPLE | uc | eq_ref | PRIMARY | PRIMARY | 4 | phubbard_joomla_e.a.checked_out | 1 | 100.00 | NULL |
1 | SIMPLE | ag | eq_ref | PRIMARY | PRIMARY | 4 | phubbard_joomla_e.a.access | 1 | 100.00 | Using where |
1 | SIMPLE | ua | eq_ref | PRIMARY | PRIMARY | 4 | phubbard_joomla_e.a.created_user_id | 1 | 100.00 | Using where |
1 | SIMPLE | g | eq_ref | PRIMARY | PRIMARY | 4 | phubbard_joomla_e.a.group_id | 1 | 100.00 | Using where |
1 | SIMPLE | fc | ref | PRIMARY | PRIMARY | 4 | phubbard_joomla_e.a.id | 1 | 100.00 | Using where; Using index; Distinct |
Status | Duration |
---|
starting | 0.17 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.06 ms |
init | 0.07 ms |
System lock | 0.03 ms |
optimizing | 0.04 ms |
statistics | 0.14 ms |
preparing | 0.05 ms |
Creating tmp table | 0.11 ms |
Sorting result | 0.01 ms |
executing | 0.01 ms |
Sending data | 1.45 ms |
Creating sort index | 0.07 ms |
end | 0.02 ms |
removing tmp table | 0.46 ms |
end | 0.02 ms |
query end | 0.02 ms |
closing tables | 0.04 ms |
freeing items | 0.15 ms |
cleaning up | 0.04 ms |
# | Caller | File and line number |
---|
20 | JDatabaseDriverMysql->execute() | JROOT\libraries\joomla\database\driver.php:1701 |
19 | JDatabaseDriver->loadObjectList() | JROOT\libraries\src\MVC\Model\BaseDatabaseModel.php:308 |
18 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT\administrator\components\com_fields\models\fields.php:333 |
17 | FieldsModelFields->_getList() | JROOT\libraries\src\MVC\Model\ListModel.php:187 |
16 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT\administrator\components\com_fields\helpers\fields.php:135 |
15 | FieldsHelper::getFields() | JROOT\plugins\system\fields\fields.php:495 |
14 | PlgSystemFields->onContentPrepare() | Same as call in the line below. |
13 | call_user_func_array() | JROOT\libraries\joomla\event\event.php:70 |
12 | JEvent->update() | JROOT\libraries\joomla\event\dispatcher.php:160 |
11 | JEventDispatcher->trigger() | JROOT\components\com_content\views\category\view.html.php:113 |
10 | ContentViewCategory->display() | JROOT\libraries\src\MVC\Controller\BaseController.php:672 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT\components\com_content\controller.php:118 |
8 | ContentController->display() | JROOT\libraries\src\MVC\Controller\BaseController.php:710 |
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:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT\index.php:49 |
Query Time: 0.65 ms After last query: 40.96 ms
SELECT `alias`
FROM `jos_content`
WHERE id = '425'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | jos_content | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
Status | Duration |
---|
starting | 0.06 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.03 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.09 ms |
preparing | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.02 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.09 ms |
cleaning up | 0.03 ms |
# | Caller | File and line number |
---|
28 | JDatabaseDriverMysql->execute() | JROOT\libraries\joomla\database\driver.php:1740 |
27 | JDatabaseDriver->loadResult() | JROOT\components\com_content\router.php:125 |
26 | ContentRouter->getArticleSegment() | 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:672 |
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:154 |
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\plugins\content\addtoany\addtoany.php:310 |
16 | plgContentAddToAny->getArticleUrl() | JROOT\plugins\content\addtoany\addtoany.php:106 |
15 | plgContentAddToAny->createAddToAny() | JROOT\plugins\content\addtoany\addtoany.php:51 |
14 | plgContentAddToAny->onContentPrepare() | Same as call in the line below. |
13 | call_user_func_array() | JROOT\libraries\joomla\event\event.php:70 |
12 | JEvent->update() | JROOT\libraries\joomla\event\dispatcher.php:160 |
11 | JEventDispatcher->trigger() | JROOT\components\com_content\views\category\view.html.php:113 |
10 | ContentViewCategory->display() | JROOT\libraries\src\MVC\Controller\BaseController.php:672 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT\components\com_content\controller.php:118 |
8 | ContentController->display() | JROOT\libraries\src\MVC\Controller\BaseController.php:710 |
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:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT\index.php:49 |
Query Time: 0.97 ms After last query: 191.80 ms
SELECT id, home, template, s.params
FROM jos_template_styles as s
LEFT JOIN jos_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
WHERE s.client_id = 0
AND e.enabled = 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | s | ALL | idx_template,idx_client_id,idx_client_id_home | NO INDEX KEY COULD BE USED | NULL | NULL | 7 | 71.43 | Using where |
1 | SIMPLE | e | ref | element_clientid,element_folder_clientid,extension | element_clientid | 403 | phubbard_joomla_e.s.template,const | 1 | 100.00 | Using index condition; Using where |
Status | Duration |
---|
starting | 0.09 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.04 ms |
System lock | 0.02 ms |
optimizing | 0.03 ms |
statistics | 0.11 ms |
preparing | 0.03 ms |
executing | 0.01 ms |
Sending data | 0.15 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.02 ms |
freeing items | 0.14 ms |
cleaning up | 0.06 ms |
# | Caller | File and line number |
---|
24 | JDatabaseDriverMysql->execute() | JROOT\libraries\joomla\database\driver.php:1701 |
23 | JDatabaseDriver->loadObjectList() | JROOT\libraries\gantry\core\gantrytemplate.class.php:638 |
22 | GantryTemplate::getAllTemplates() | JROOT\libraries\gantry\core\gantrytemplate.class.php:590 |
21 | GantryTemplate::getTemplateParams() | JROOT\libraries\gantry\core\params\overrides\gantrymenuitemparamoverride.class.php:69 |
20 | GantryMenuItemParamOverride::_populateSingleItem() | JROOT\libraries\gantry\core\params\overrides\gantrymenuitemparamoverride.class.php:36 |
19 | GantryMenuItemParamOverride::populate() | JROOT\libraries\gantry\core\gantry.class.php:1843 |
18 | Gantry->populateParams() | JROOT\libraries\gantry\core\gantry.class.php:392 |
17 | Gantry->init() | JROOT\libraries\gantry\gantry.php:275 |
16 | gantry_setup() | JROOT\libraries\gantry\gantry.php:432 |
15 | include JROOT\libraries\gantry\gantry.php | JROOT\templates\rt_reflex\html\com_content\category\blog.php:14 |
14 | include JROOT\templates\rt_reflex\html\com_content\category\blog.php | JROOT\libraries\src\MVC\View\HtmlView.php:697 |
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:672 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT\components\com_content\controller.php:118 |
8 | ContentController->display() | JROOT\libraries\src\MVC\Controller\BaseController.php:710 |
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:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT\index.php:49 |
Query Time: 0.89 ms After last query: 6.13 ms
SELECT id, home, template, s.params
FROM jos_template_styles as s
LEFT JOIN jos_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
WHERE s.client_id = 0
AND e.enabled = 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | s | ALL | idx_template,idx_client_id,idx_client_id_home | NO INDEX KEY COULD BE USED | NULL | NULL | 7 | 71.43 | Using where |
1 | SIMPLE | e | ref | element_clientid,element_folder_clientid,extension | element_clientid | 403 | phubbard_joomla_e.s.template,const | 1 | 100.00 | Using index condition; Using where |
Status | Duration |
---|
starting | 0.08 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.04 ms |
System lock | 0.01 ms |
optimizing | 0.02 ms |
statistics | 0.11 ms |
preparing | 0.03 ms |
executing | 0.01 ms |
Sending data | 0.15 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.02 ms |
freeing items | 0.14 ms |
cleaning up | 0.06 ms |
# | Caller | File and line number |
---|
23 | JDatabaseDriverMysql->execute() | JROOT\libraries\joomla\database\driver.php:1701 |
22 | JDatabaseDriver->loadObjectList() | JROOT\libraries\gantry\core\gantrytemplate.class.php:638 |
21 | GantryTemplate::getAllTemplates() | JROOT\libraries\gantry\core\params\overrides\gantrymenuitemparamoverride.class.php:65 |
20 | GantryMenuItemParamOverride::_populateSingleItem() | JROOT\libraries\gantry\core\params\overrides\gantrymenuitemparamoverride.class.php:36 |
19 | GantryMenuItemParamOverride::populate() | JROOT\libraries\gantry\core\gantry.class.php:1843 |
18 | Gantry->populateParams() | JROOT\libraries\gantry\core\gantry.class.php:392 |
17 | Gantry->init() | JROOT\libraries\gantry\gantry.php:275 |
16 | gantry_setup() | JROOT\libraries\gantry\gantry.php:432 |
15 | include JROOT\libraries\gantry\gantry.php | JROOT\templates\rt_reflex\html\com_content\category\blog.php:14 |
14 | include JROOT\templates\rt_reflex\html\com_content\category\blog.php | JROOT\libraries\src\MVC\View\HtmlView.php:697 |
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:672 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT\components\com_content\controller.php:118 |
8 | ContentController->display() | JROOT\libraries\src\MVC\Controller\BaseController.php:710 |
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:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT\index.php:49 |
Query Time: 1.37 ms After last query: 1.17 ms
SELECT id, home, template, s.params
FROM jos_template_styles as s
LEFT JOIN jos_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
WHERE s.client_id = 0
AND e.enabled = 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | s | ALL | idx_template,idx_client_id,idx_client_id_home | NO INDEX KEY COULD BE USED | NULL | NULL | 7 | 71.43 | Using where |
1 | SIMPLE | e | ref | element_clientid,element_folder_clientid,extension | element_clientid | 403 | phubbard_joomla_e.s.template,const | 1 | 100.00 | Using index condition; Using where |
Status | Duration |
---|
starting | 0.09 ms |
checking permissions | 0.02 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.04 ms |
System lock | 0.02 ms |
optimizing | 0.03 ms |
statistics | 0.20 ms |
preparing | 0.04 ms |
executing | 0.01 ms |
Sending data | 0.34 ms |
end | 0.02 ms |
query end | 0.02 ms |
closing tables | 0.02 ms |
freeing items | 0.32 ms |
cleaning up | 0.17 ms |
# | Caller | File and line number |
---|
24 | JDatabaseDriverMysql->execute() | JROOT\libraries\joomla\database\driver.php:1701 |
23 | JDatabaseDriver->loadObjectList() | JROOT\libraries\gantry\core\gantrytemplate.class.php:638 |
22 | GantryTemplate::getAllTemplates() | JROOT\libraries\gantry\core\gantrytemplate.class.php:590 |
21 | GantryTemplate::getTemplateParams() | JROOT\libraries\gantry\core\params\overrides\gantrymenuitemparamoverride.class.php:69 |
20 | GantryMenuItemParamOverride::_populateSingleItem() | JROOT\libraries\gantry\core\params\overrides\gantrymenuitemparamoverride.class.php:36 |
19 | GantryMenuItemParamOverride::populate() | JROOT\libraries\gantry\core\gantry.class.php:1843 |
18 | Gantry->populateParams() | JROOT\libraries\gantry\core\gantry.class.php:392 |
17 | Gantry->init() | JROOT\libraries\gantry\gantry.php:275 |
16 | gantry_setup() | JROOT\libraries\gantry\gantry.php:432 |
15 | include JROOT\libraries\gantry\gantry.php | JROOT\templates\rt_reflex\html\com_content\category\blog.php:14 |
14 | include JROOT\templates\rt_reflex\html\com_content\category\blog.php | JROOT\libraries\src\MVC\View\HtmlView.php:697 |
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:672 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT\components\com_content\controller.php:118 |
8 | ContentController->display() | JROOT\libraries\src\MVC\Controller\BaseController.php:710 |
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:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT\index.php:49 |
Query Time: 0.84 ms After last query: 2.30 ms
SELECT id, home, template, s.params
FROM jos_template_styles as s
LEFT JOIN jos_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
WHERE s.client_id = 0
AND e.enabled = 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | s | ALL | idx_template,idx_client_id,idx_client_id_home | NO INDEX KEY COULD BE USED | NULL | NULL | 7 | 71.43 | Using where |
1 | SIMPLE | e | ref | element_clientid,element_folder_clientid,extension | element_clientid | 403 | phubbard_joomla_e.s.template,const | 1 | 100.00 | Using index condition; Using where |
Status | Duration |
---|
starting | 0.06 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.03 ms |
System lock | 0.01 ms |
optimizing | 0.02 ms |
statistics | 0.11 ms |
preparing | 0.03 ms |
executing | 0.07 ms |
Sending data | 0.13 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.02 ms |
freeing items | 0.04 ms |
cleaning up | 0.06 ms |
# | Caller | File and line number |
---|
23 | JDatabaseDriverMysql->execute() | JROOT\libraries\joomla\database\driver.php:1701 |
22 | JDatabaseDriver->loadObjectList() | JROOT\libraries\gantry\core\gantrytemplate.class.php:638 |
21 | GantryTemplate::getAllTemplates() | JROOT\libraries\gantry\core\params\overrides\gantrymenuitemparamoverride.class.php:65 |
20 | GantryMenuItemParamOverride::_populateSingleItem() | JROOT\libraries\gantry\core\params\overrides\gantrymenuitemparamoverride.class.php:36 |
19 | GantryMenuItemParamOverride::populate() | JROOT\libraries\gantry\core\gantry.class.php:1843 |
18 | Gantry->populateParams() | JROOT\libraries\gantry\core\gantry.class.php:392 |
17 | Gantry->init() | JROOT\libraries\gantry\gantry.php:275 |
16 | gantry_setup() | JROOT\libraries\gantry\gantry.php:432 |
15 | include JROOT\libraries\gantry\gantry.php | JROOT\templates\rt_reflex\html\com_content\category\blog.php:14 |
14 | include JROOT\templates\rt_reflex\html\com_content\category\blog.php | JROOT\libraries\src\MVC\View\HtmlView.php:697 |
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:672 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT\components\com_content\controller.php:118 |
8 | ContentController->display() | JROOT\libraries\src\MVC\Controller\BaseController.php:710 |
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:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT\index.php:49 |
Query Time: 0.86 ms After last query: 1.52 ms
SELECT id, home, template, s.params
FROM jos_template_styles as s
LEFT JOIN jos_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
WHERE s.client_id = 0
AND e.enabled = 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | s | ALL | idx_template,idx_client_id,idx_client_id_home | NO INDEX KEY COULD BE USED | NULL | NULL | 7 | 71.43 | Using where |
1 | SIMPLE | e | ref | element_clientid,element_folder_clientid,extension | element_clientid | 403 | phubbard_joomla_e.s.template,const | 1 | 100.00 | Using index condition; Using where |
Status | Duration |
---|
starting | 0.07 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.03 ms |
System lock | 0.01 ms |
optimizing | 0.02 ms |
statistics | 0.09 ms |
preparing | 0.03 ms |
executing | 0.01 ms |
Sending data | 0.20 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.02 ms |
freeing items | 0.10 ms |
cleaning up | 0.06 ms |
# | Caller | File and line number |
---|
24 | JDatabaseDriverMysql->execute() | JROOT\libraries\joomla\database\driver.php:1701 |
23 | JDatabaseDriver->loadObjectList() | JROOT\libraries\gantry\core\gantrytemplate.class.php:638 |
22 | GantryTemplate::getAllTemplates() | JROOT\libraries\gantry\core\gantrytemplate.class.php:590 |
21 | GantryTemplate::getTemplateParams() | JROOT\libraries\gantry\core\params\overrides\gantrymenuitemparamoverride.class.php:69 |
20 | GantryMenuItemParamOverride::_populateSingleItem() | JROOT\libraries\gantry\core\params\overrides\gantrymenuitemparamoverride.class.php:36 |
19 | GantryMenuItemParamOverride::populate() | JROOT\libraries\gantry\core\gantry.class.php:1843 |
18 | Gantry->populateParams() | JROOT\libraries\gantry\core\gantry.class.php:392 |
17 | Gantry->init() | JROOT\libraries\gantry\gantry.php:275 |
16 | gantry_setup() | JROOT\libraries\gantry\gantry.php:432 |
15 | include JROOT\libraries\gantry\gantry.php | JROOT\templates\rt_reflex\html\com_content\category\blog.php:14 |
14 | include JROOT\templates\rt_reflex\html\com_content\category\blog.php | JROOT\libraries\src\MVC\View\HtmlView.php:697 |
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:672 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT\components\com_content\controller.php:118 |
8 | ContentController->display() | JROOT\libraries\src\MVC\Controller\BaseController.php:710 |
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:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT\index.php:49 |
Query Time: 0.79 ms After last query: 1.46 ms
SELECT id, home, template, s.params
FROM jos_template_styles as s
LEFT JOIN jos_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
WHERE s.client_id = 0
AND e.enabled = 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | s | ALL | idx_template,idx_client_id,idx_client_id_home | NO INDEX KEY COULD BE USED | NULL | NULL | 7 | 71.43 | Using where |
1 | SIMPLE | e | ref | element_clientid,element_folder_clientid,extension | element_clientid | 403 | phubbard_joomla_e.s.template,const | 1 | 100.00 | Using index condition; Using where |
Status | Duration |
---|
starting | 0.07 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.03 ms |
System lock | 0.01 ms |
optimizing | 0.02 ms |
statistics | 0.09 ms |
preparing | 0.03 ms |
executing | 0.01 ms |
Sending data | 0.13 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.02 ms |
freeing items | 0.11 ms |
cleaning up | 0.06 ms |
# | Caller | File and line number |
---|
23 | JDatabaseDriverMysql->execute() | JROOT\libraries\joomla\database\driver.php:1701 |
22 | JDatabaseDriver->loadObjectList() | JROOT\libraries\gantry\core\gantrytemplate.class.php:638 |
21 | GantryTemplate::getAllTemplates() | JROOT\libraries\gantry\core\params\overrides\gantrymenuitemparamoverride.class.php:65 |
20 | GantryMenuItemParamOverride::_populateSingleItem() | JROOT\libraries\gantry\core\params\overrides\gantrymenuitemparamoverride.class.php:36 |
19 | GantryMenuItemParamOverride::populate() | JROOT\libraries\gantry\core\gantry.class.php:1843 |
18 | Gantry->populateParams() | JROOT\libraries\gantry\core\gantry.class.php:392 |
17 | Gantry->init() | JROOT\libraries\gantry\gantry.php:275 |
16 | gantry_setup() | JROOT\libraries\gantry\gantry.php:432 |
15 | include JROOT\libraries\gantry\gantry.php | JROOT\templates\rt_reflex\html\com_content\category\blog.php:14 |
14 | include JROOT\templates\rt_reflex\html\com_content\category\blog.php | JROOT\libraries\src\MVC\View\HtmlView.php:697 |
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:672 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT\components\com_content\controller.php:118 |
8 | ContentController->display() | JROOT\libraries\src\MVC\Controller\BaseController.php:710 |
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:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT\index.php:49 |
Query Time: 0.78 ms After last query: 0.95 ms
SELECT id, home, template, s.params
FROM jos_template_styles as s
LEFT JOIN jos_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
WHERE s.client_id = 0
AND e.enabled = 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | s | ALL | idx_template,idx_client_id,idx_client_id_home | NO INDEX KEY COULD BE USED | NULL | NULL | 7 | 71.43 | Using where |
1 | SIMPLE | e | ref | element_clientid,element_folder_clientid,extension | element_clientid | 403 | phubbard_joomla_e.s.template,const | 1 | 100.00 | Using index condition; Using where |
Status | Duration |
---|
starting | 0.07 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.03 ms |
System lock | 0.01 ms |
optimizing | 0.02 ms |
statistics | 0.09 ms |
preparing | 0.03 ms |
executing | 0.01 ms |
Sending data | 0.12 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.02 ms |
freeing items | 0.10 ms |
cleaning up | 0.06 ms |
# | Caller | File and line number |
---|
24 | JDatabaseDriverMysql->execute() | JROOT\libraries\joomla\database\driver.php:1701 |
23 | JDatabaseDriver->loadObjectList() | JROOT\libraries\gantry\core\gantrytemplate.class.php:638 |
22 | GantryTemplate::getAllTemplates() | JROOT\libraries\gantry\core\gantrytemplate.class.php:590 |
21 | GantryTemplate::getTemplateParams() | JROOT\libraries\gantry\core\params\overrides\gantrymenuitemparamoverride.class.php:69 |
20 | GantryMenuItemParamOverride::_populateSingleItem() | JROOT\libraries\gantry\core\params\overrides\gantrymenuitemparamoverride.class.php:36 |
19 | GantryMenuItemParamOverride::populate() | JROOT\libraries\gantry\core\gantry.class.php:1843 |
18 | Gantry->populateParams() | JROOT\libraries\gantry\core\gantry.class.php:392 |
17 | Gantry->init() | JROOT\libraries\gantry\gantry.php:275 |
16 | gantry_setup() | JROOT\libraries\gantry\gantry.php:432 |
15 | include JROOT\libraries\gantry\gantry.php | JROOT\templates\rt_reflex\html\com_content\category\blog.php:14 |
14 | include JROOT\templates\rt_reflex\html\com_content\category\blog.php | JROOT\libraries\src\MVC\View\HtmlView.php:697 |
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:672 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT\components\com_content\controller.php:118 |
8 | ContentController->display() | JROOT\libraries\src\MVC\Controller\BaseController.php:710 |
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:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT\index.php:49 |
Query Time: 98.67 ms After last query: 2289.67 ms
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM jos_modules AS m
LEFT JOIN jos_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN jos_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 <= '2022-08-09 05:20:01')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2022-08-09 05:20:01')
AND m.access IN (1,1,5)
AND m.client_id = 0
AND (mm.menuid = 160 OR mm.menuid <= 0)
ORDER BY m.position, m.ordering
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | m | ref | PRIMARY,published,newsfeeds | published | 1 | const | 98 | 100.00 | Using index condition; Using where; Using filesort |
1 | SIMPLE | e | ref | element_clientid,element_folder_clientid | element_clientid | 403 | phubbard_joomla_e.m.module,const | 1 | 100.00 | Using index condition; Using where |
1 | SIMPLE | mm | ref | PRIMARY | PRIMARY | 4 | phubbard_joomla_e.m.id | 2 | 100.00 | Using where; Using index |
Status | Duration |
---|
starting | 0.15 ms |
checking permissions | 0.09 ms |
checking permissions | 0.01 ms |
checking permissions | 0.02 ms |
Opening tables | 0.11 ms |
init | 0.15 ms |
System lock | 0.03 ms |
optimizing | 0.04 ms |
statistics | 0.14 ms |
preparing | 0.06 ms |
Sorting result | 0.01 ms |
executing | 0.01 ms |
Sending data | 0.02 ms |
Creating sort index | 97.24 ms |
end | 0.02 ms |
query end | 0.02 ms |
closing tables | 0.03 ms |
freeing items | 0.19 ms |
cleaning up | 0.03 ms |
# | Caller | File and line number |
---|
17 | JDatabaseDriverMysql->execute() | JROOT\libraries\joomla\database\driver.php:1701 |
16 | JDatabaseDriver->loadObjectList() | Same as call in the line below. |
15 | call_user_func_array() | JROOT\libraries\src\Cache\Controller\CallbackController.php:173 |
14 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT\libraries\src\Helper\ModuleHelper.php:432 |
13 | Joomla\CMS\Helper\ModuleHelper::getModuleList() | JROOT\libraries\src\Helper\ModuleHelper.php:362 |
12 | Joomla\CMS\Helper\ModuleHelper::load() | JROOT\libraries\src\Helper\ModuleHelper.php:87 |
11 | Joomla\CMS\Helper\ModuleHelper::getModules() | JROOT\libraries\src\Document\HtmlDocument.php:581 |
10 | Joomla\CMS\Document\HtmlDocument->countModules() | JROOT\libraries\gantry\core\gantry.class.php:804 |
9 | Gantry->getJoomlaModuleCount() | JROOT\libraries\gantry\core\gantry.class.php:757 |
8 | Gantry->countModules() | JROOT\templates\rt_reflex\index.php:57 |
7 | require JROOT\templates\rt_reflex\index.php | JROOT\libraries\src\Document\HtmlDocument.php:658 |
6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT\libraries\src\Document\HtmlDocument.php:720 |
5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT\libraries\src\Document\HtmlDocument.php:535 |
4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT\libraries\src\Application\CMSApplication.php:1030 |
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:202 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT\index.php:49 |
Query Time: 22.94 ms After last query: 179.66 ms
SELECT ts.template
FROM jos_template_styles AS ts
INNER JOIN jos_menu AS m
ON ts.id=m.template_style_id
WHERE m.id = 160
AND m.template_style_id != 0
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | m | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
1 | SIMPLE | ts | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
Status | Duration |
---|
starting | 0.10 ms |
checking permissions | 0.02 ms |
checking permissions | 0.02 ms |
Opening tables | 0.05 ms |
init | 0.05 ms |
System lock | 0.02 ms |
optimizing | 0.03 ms |
statistics | 22.06 ms |
preparing | 0.03 ms |
executing | 0.01 ms |
Sending data | 0.03 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.03 ms |
freeing items | 0.11 ms |
cleaning up | 0.05 ms |
# | Caller | File and line number |
---|
18 | JDatabaseDriverMysql->execute() | JROOT\libraries\joomla\database\driver.php:1550 |
17 | JDatabaseDriver->loadColumn() | JROOT\modules\mod_roknavmenu\lib\RokNavMenu.php:98 |
16 | RokNavMenu::getTemplates() | JROOT\modules\mod_roknavmenu\lib\RokNavMenu.php:71 |
15 | RokNavMenu::loadCatalogs() | JROOT\modules\mod_roknavmenu\lib\RokNavMenu.php:22 |
14 | RokNavMenu->__construct() | JROOT\modules\mod_roknavmenu\mod_roknavmenu.php:21 |
13 | include JROOT\modules\mod_roknavmenu\mod_roknavmenu.php | JROOT\libraries\src\Helper\ModuleHelper.php:200 |
12 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT\libraries\src\Document\Renderer\Html\ModuleRenderer.php:98 |
11 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT\templates\rt_reflex\features\fusionmenu.php:65 |
10 | GantryFeatureFusionMenu->render() | JROOT\libraries\gantry\core\renderers\gantrymodulesrenderer.class.php:70 |
9 | GantryModulesRenderer::display() | JROOT\libraries\gantry\core\gantry.class.php:867 |
8 | Gantry->displayModules() | JROOT\templates\rt_reflex\index.php:79 |
7 | require JROOT\templates\rt_reflex\index.php | JROOT\libraries\src\Document\HtmlDocument.php:658 |
6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT\libraries\src\Document\HtmlDocument.php:720 |
5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT\libraries\src\Document\HtmlDocument.php:535 |
4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT\libraries\src\Application\CMSApplication.php:1030 |
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:202 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT\index.php:49 |
Query Time: 1.97 ms After last query: 868.89 ms
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 `jos_categories` AS `s`
INNER JOIN `jos_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 = 60
ORDER BY c.lft
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | s | const | PRIMARY,idx_left_right | PRIMARY | 4 | const | 1 | 100.00 | Using filesort |
1 | SIMPLE | c | ALL | cat_idx,idx_access,idx_left_right | NO INDEX KEY COULD BE USED | NULL | NULL | 227 | 27.75 | Using where |
Status | Duration |
---|
starting | 0.18 ms |
checking permissions | 0.02 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.08 ms |
System lock | 0.02 ms |
optimizing | 0.03 ms |
statistics | 0.23 ms |
preparing | 0.04 ms |
Sorting result | 0.01 ms |
executing | 0.01 ms |
Sending data | 0.04 ms |
Creating sort index | 0.72 ms |
end | 0.01 ms |
query end | 0.02 ms |
closing tables | 0.02 ms |
freeing items | 0.13 ms |
cleaning up | 0.03 ms |
# | Caller | File and line number |
---|
18 | JDatabaseDriverMysql->execute() | JROOT\libraries\joomla\database\driver.php:1701 |
17 | JDatabaseDriver->loadObjectList() | JROOT\libraries\src\Categories\Categories.php:324 |
16 | Joomla\CMS\Categories\Categories->_load() | JROOT\libraries\src\Categories\Categories.php:184 |
15 | Joomla\CMS\Categories\Categories->get() | JROOT\modules\mod_articles_categories\helper.php:34 |
14 | ModArticlesCategoriesHelper::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:562 |
11 | Joomla\CMS\Helper\ModuleHelper::moduleCache() | JROOT\modules\mod_articles_categories\mod_articles_categories.php:28 |
10 | include JROOT\modules\mod_articles_categories\mod_articles_categories.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:491 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT\libraries\src\Document\HtmlDocument.php:783 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT\libraries\src\Document\HtmlDocument.php:557 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT\libraries\src\Application\CMSApplication.php:1044 |
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:202 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT\index.php:49 |
Query Time: 1.71 ms After last query: 17.95 ms
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 `jos_categories` AS `s`
INNER JOIN `jos_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 = 65
ORDER BY c.lft
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | s | const | PRIMARY,idx_left_right | PRIMARY | 4 | const | 1 | 100.00 | Using filesort |
1 | SIMPLE | c | ALL | cat_idx,idx_access,idx_left_right | NO INDEX KEY COULD BE USED | NULL | NULL | 227 | 21.59 | Using where |
Status | Duration |
---|
starting | 0.18 ms |
checking permissions | 0.02 ms |
checking permissions | 0.01 ms |
Opening tables | 0.04 ms |
init | 0.08 ms |
System lock | 0.02 ms |
optimizing | 0.03 ms |
statistics | 0.23 ms |
preparing | 0.03 ms |
Sorting result | 0.01 ms |
executing | 0.01 ms |
Sending data | 0.03 ms |
Creating sort index | 0.52 ms |
end | 0.02 ms |
query end | 0.02 ms |
closing tables | 0.02 ms |
freeing items | 0.12 ms |
cleaning up | 0.03 ms |
# | Caller | File and line number |
---|
26 | JDatabaseDriverMysql->execute() | JROOT\libraries\joomla\database\driver.php:1701 |
25 | JDatabaseDriver->loadObjectList() | JROOT\libraries\src\Categories\Categories.php:324 |
24 | Joomla\CMS\Categories\Categories->_load() | JROOT\libraries\src\Categories\Categories.php:184 |
23 | Joomla\CMS\Categories\Categories->get() | JROOT\components\com_content\router.php:72 |
22 | ContentRouter->getCategorySegment() | Same as call in the line below. |
21 | call_user_func_array() | JROOT\libraries\src\Component\Router\RouterView.php:120 |
20 | Joomla\CMS\Component\Router\RouterView->getPath() | JROOT\libraries\src\Component\Router\Rules\MenuRules.php:111 |
19 | Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() | JROOT\libraries\src\Component\Router\RouterView.php:222 |
18 | Joomla\CMS\Component\Router\RouterView->preprocess() | JROOT\libraries\src\Router\SiteRouter.php:672 |
17 | Joomla\CMS\Router\SiteRouter->processBuildRules() | JROOT\libraries\src\Router\Router.php:266 |
16 | Joomla\CMS\Router\Router->build() | JROOT\libraries\src\Router\SiteRouter.php:154 |
15 | Joomla\CMS\Router\SiteRouter->build() | JROOT\libraries\src\Router\Route.php:144 |
14 | Joomla\CMS\Router\Route::link() | JROOT\libraries\src\Router\Route.php:93 |
13 | Joomla\CMS\Router\Route::_() | JROOT\modules\mod_articles_categories\tmpl\default_items.php:20 |
12 | require JROOT\modules\mod_articles_categories\tmpl\default_items.php | JROOT\modules\mod_articles_categories\tmpl\default.php:13 |
11 | require JROOT\modules\mod_articles_categories\tmpl\default.php | JROOT\modules\mod_articles_categories\mod_articles_categories.php:35 |
10 | include JROOT\modules\mod_articles_categories\mod_articles_categories.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:491 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT\libraries\src\Document\HtmlDocument.php:783 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT\libraries\src\Document\HtmlDocument.php:557 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT\libraries\src\Application\CMSApplication.php:1044 |
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:202 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT\index.php:49 |
Query Time: 1.73 ms After last query: 1.13 ms
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 `jos_categories` AS `s`
INNER JOIN `jos_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 = 63
ORDER BY c.lft
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | s | const | PRIMARY,idx_left_right | PRIMARY | 4 | const | 1 | 100.00 | Using filesort |
1 | SIMPLE | c | ALL | cat_idx,idx_access,idx_left_right | NO INDEX KEY COULD BE USED | NULL | NULL | 227 | 22.03 | Using where |
Status | Duration |
---|
starting | 0.17 ms |
checking permissions | 0.02 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.08 ms |
System lock | 0.02 ms |
optimizing | 0.03 ms |
statistics | 0.22 ms |
preparing | 0.04 ms |
Sorting result | 0.01 ms |
executing | 0.01 ms |
Sending data | 0.03 ms |
Creating sort index | 0.55 ms |
end | 0.02 ms |
query end | 0.02 ms |
closing tables | 0.02 ms |
freeing items | 0.11 ms |
cleaning up | 0.03 ms |
# | Caller | File and line number |
---|
26 | JDatabaseDriverMysql->execute() | JROOT\libraries\joomla\database\driver.php:1701 |
25 | JDatabaseDriver->loadObjectList() | JROOT\libraries\src\Categories\Categories.php:324 |
24 | Joomla\CMS\Categories\Categories->_load() | JROOT\libraries\src\Categories\Categories.php:184 |
23 | Joomla\CMS\Categories\Categories->get() | JROOT\components\com_content\router.php:72 |
22 | ContentRouter->getCategorySegment() | Same as call in the line below. |
21 | call_user_func_array() | JROOT\libraries\src\Component\Router\RouterView.php:120 |
20 | Joomla\CMS\Component\Router\RouterView->getPath() | JROOT\libraries\src\Component\Router\Rules\MenuRules.php:111 |
19 | Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() | JROOT\libraries\src\Component\Router\RouterView.php:222 |
18 | Joomla\CMS\Component\Router\RouterView->preprocess() | JROOT\libraries\src\Router\SiteRouter.php:672 |
17 | Joomla\CMS\Router\SiteRouter->processBuildRules() | JROOT\libraries\src\Router\Router.php:266 |
16 | Joomla\CMS\Router\Router->build() | JROOT\libraries\src\Router\SiteRouter.php:154 |
15 | Joomla\CMS\Router\SiteRouter->build() | JROOT\libraries\src\Router\Route.php:144 |
14 | Joomla\CMS\Router\Route::link() | JROOT\libraries\src\Router\Route.php:93 |
13 | Joomla\CMS\Router\Route::_() | JROOT\modules\mod_articles_categories\tmpl\default_items.php:20 |
12 | require JROOT\modules\mod_articles_categories\tmpl\default_items.php | JROOT\modules\mod_articles_categories\tmpl\default.php:13 |
11 | require JROOT\modules\mod_articles_categories\tmpl\default.php | JROOT\modules\mod_articles_categories\mod_articles_categories.php:35 |
10 | include JROOT\modules\mod_articles_categories\mod_articles_categories.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:491 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT\libraries\src\Document\HtmlDocument.php:783 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT\libraries\src\Document\HtmlDocument.php:557 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT\libraries\src\Application\CMSApplication.php:1044 |
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:202 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT\index.php:49 |
Query Time: 2.06 ms After last query: 9.30 ms
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 `jos_categories` AS `s`
INNER JOIN `jos_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 = 219
ORDER BY c.lft
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | s | const | PRIMARY,idx_left_right | PRIMARY | 4 | const | 1 | 100.00 | Using filesort |
1 | SIMPLE | c | ALL | cat_idx,idx_access,idx_left_right | NO INDEX KEY COULD BE USED | NULL | NULL | 227 | 22.91 | Using where |
Status | Duration |
---|
starting | 0.24 ms |
checking permissions | 0.03 ms |
checking permissions | 0.02 ms |
Opening tables | 0.05 ms |
init | 0.12 ms |
System lock | 0.03 ms |
optimizing | 0.05 ms |
statistics | 0.45 ms |
preparing | 0.04 ms |
Sorting result | 0.01 ms |
executing | 0.03 ms |
Sending data | 0.06 ms |
Creating sort index | 0.49 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.02 ms |
freeing items | 0.14 ms |
cleaning up | 0.04 ms |
# | Caller | File and line number |
---|
27 | JDatabaseDriverMysql->execute() | JROOT\libraries\joomla\database\driver.php:1701 |
26 | JDatabaseDriver->loadObjectList() | JROOT\libraries\src\Categories\Categories.php:324 |
25 | Joomla\CMS\Categories\Categories->_load() | JROOT\libraries\src\Categories\Categories.php:184 |
24 | Joomla\CMS\Categories\Categories->get() | JROOT\components\com_content\router.php:72 |
23 | ContentRouter->getCategorySegment() | Same as call in the line below. |
22 | call_user_func_array() | JROOT\libraries\src\Component\Router\RouterView.php:120 |
21 | Joomla\CMS\Component\Router\RouterView->getPath() | JROOT\libraries\src\Component\Router\Rules\MenuRules.php:111 |
20 | Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() | JROOT\libraries\src\Component\Router\RouterView.php:222 |
19 | Joomla\CMS\Component\Router\RouterView->preprocess() | JROOT\libraries\src\Router\SiteRouter.php:672 |
18 | Joomla\CMS\Router\SiteRouter->processBuildRules() | JROOT\libraries\src\Router\Router.php:266 |
17 | Joomla\CMS\Router\Router->build() | JROOT\libraries\src\Router\SiteRouter.php:154 |
16 | Joomla\CMS\Router\SiteRouter->build() | JROOT\libraries\src\Router\Route.php:144 |
15 | Joomla\CMS\Router\Route::link() | JROOT\libraries\src\Router\Route.php:93 |
14 | Joomla\CMS\Router\Route::_() | JROOT\modules\mod_articles_categories\tmpl\default_items.php:20 |
13 | require JROOT\modules\mod_articles_categories\tmpl\default_items.php | JROOT\modules\mod_articles_categories\tmpl\default_items.php:37 |
12 | require JROOT\modules\mod_articles_categories\tmpl\default_items.php | JROOT\modules\mod_articles_categories\tmpl\default.php:13 |
11 | require JROOT\modules\mod_articles_categories\tmpl\default.php | JROOT\modules\mod_articles_categories\mod_articles_categories.php:35 |
10 | include JROOT\modules\mod_articles_categories\mod_articles_categories.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:491 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT\libraries\src\Document\HtmlDocument.php:783 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT\libraries\src\Document\HtmlDocument.php:557 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT\libraries\src\Application\CMSApplication.php:1044 |
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:202 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT\index.php:49 |
Query Time: 1.66 ms After last query: 1.19 ms
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 `jos_categories` AS `s`
INNER JOIN `jos_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 = 220
ORDER BY c.lft
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | s | const | PRIMARY,idx_left_right | PRIMARY | 4 | const | 1 | 100.00 | Using filesort |
1 | SIMPLE | c | ALL | cat_idx,idx_access,idx_left_right | NO INDEX KEY COULD BE USED | NULL | NULL | 227 | 23.35 | Using where |
Status | Duration |
---|
starting | 0.16 ms |
checking permissions | 0.02 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.08 ms |
System lock | 0.03 ms |
optimizing | 0.03 ms |
statistics | 0.24 ms |
preparing | 0.04 ms |
Sorting result | 0.01 ms |
executing | 0.01 ms |
Sending data | 0.05 ms |
Creating sort index | 0.52 ms |
end | 0.02 ms |
query end | 0.01 ms |
closing tables | 0.02 ms |
freeing items | 0.12 ms |
cleaning up | 0.04 ms |
# | Caller | File and line number |
---|
27 | JDatabaseDriverMysql->execute() | JROOT\libraries\joomla\database\driver.php:1701 |
26 | JDatabaseDriver->loadObjectList() | JROOT\libraries\src\Categories\Categories.php:324 |
25 | Joomla\CMS\Categories\Categories->_load() | JROOT\libraries\src\Categories\Categories.php:184 |
24 | Joomla\CMS\Categories\Categories->get() | JROOT\components\com_content\router.php:72 |
23 | ContentRouter->getCategorySegment() | Same as call in the line below. |
22 | call_user_func_array() | JROOT\libraries\src\Component\Router\RouterView.php:120 |
21 | Joomla\CMS\Component\Router\RouterView->getPath() | JROOT\libraries\src\Component\Router\Rules\MenuRules.php:111 |
20 | Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() | JROOT\libraries\src\Component\Router\RouterView.php:222 |
19 | Joomla\CMS\Component\Router\RouterView->preprocess() | JROOT\libraries\src\Router\SiteRouter.php:672 |
18 | Joomla\CMS\Router\SiteRouter->processBuildRules() | JROOT\libraries\src\Router\Router.php:266 |
17 | Joomla\CMS\Router\Router->build() | JROOT\libraries\src\Router\SiteRouter.php:154 |
16 | Joomla\CMS\Router\SiteRouter->build() | JROOT\libraries\src\Router\Route.php:144 |
15 | Joomla\CMS\Router\Route::link() | JROOT\libraries\src\Router\Route.php:93 |
14 | Joomla\CMS\Router\Route::_() | JROOT\modules\mod_articles_categories\tmpl\default_items.php:20 |
13 | require JROOT\modules\mod_articles_categories\tmpl\default_items.php | JROOT\modules\mod_articles_categories\tmpl\default_items.php:37 |
12 | require JROOT\modules\mod_articles_categories\tmpl\default_items.php | JROOT\modules\mod_articles_categories\tmpl\default.php:13 |
11 | require JROOT\modules\mod_articles_categories\tmpl\default.php | JROOT\modules\mod_articles_categories\mod_articles_categories.php:35 |
10 | include JROOT\modules\mod_articles_categories\mod_articles_categories.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:491 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT\libraries\src\Document\HtmlDocument.php:783 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT\libraries\src\Document\HtmlDocument.php:557 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT\libraries\src\Application\CMSApplication.php:1044 |
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:202 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT\index.php:49 |
Query Time: 1.98 ms After last query: 1.21 ms
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 `jos_categories` AS `s`
INNER JOIN `jos_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 = 221
ORDER BY c.lft
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | s | const | PRIMARY,idx_left_right | PRIMARY | 4 | const | 1 | 100.00 | Using filesort |
1 | SIMPLE | c | ALL | cat_idx,idx_access,idx_left_right | NO INDEX KEY COULD BE USED | NULL | NULL | 227 | 23.79 | Using where |
Status | Duration |
---|
starting | 0.18 ms |
checking permissions | 0.02 ms |
checking permissions | 0.01 ms |
Opening tables | 0.04 ms |
init | 0.09 ms |
System lock | 0.02 ms |
optimizing | 0.03 ms |
statistics | 0.28 ms |
preparing | 0.04 ms |
Sorting result | 0.01 ms |
executing | 0.01 ms |
Sending data | 0.04 ms |
Creating sort index | 0.62 ms |
end | 0.02 ms |
query end | 0.02 ms |
closing tables | 0.02 ms |
freeing items | 0.12 ms |
cleaning up | 0.03 ms |
# | Caller | File and line number |
---|
27 | JDatabaseDriverMysql->execute() | JROOT\libraries\joomla\database\driver.php:1701 |
26 | JDatabaseDriver->loadObjectList() | JROOT\libraries\src\Categories\Categories.php:324 |
25 | Joomla\CMS\Categories\Categories->_load() | JROOT\libraries\src\Categories\Categories.php:184 |
24 | Joomla\CMS\Categories\Categories->get() | JROOT\components\com_content\router.php:72 |
23 | ContentRouter->getCategorySegment() | Same as call in the line below. |
22 | call_user_func_array() | JROOT\libraries\src\Component\Router\RouterView.php:120 |
21 | Joomla\CMS\Component\Router\RouterView->getPath() | JROOT\libraries\src\Component\Router\Rules\MenuRules.php:111 |
20 | Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() | JROOT\libraries\src\Component\Router\RouterView.php:222 |
19 | Joomla\CMS\Component\Router\RouterView->preprocess() | JROOT\libraries\src\Router\SiteRouter.php:672 |
18 | Joomla\CMS\Router\SiteRouter->processBuildRules() | JROOT\libraries\src\Router\Router.php:266 |
17 | Joomla\CMS\Router\Router->build() | JROOT\libraries\src\Router\SiteRouter.php:154 |
16 | Joomla\CMS\Router\SiteRouter->build() | JROOT\libraries\src\Router\Route.php:144 |
15 | Joomla\CMS\Router\Route::link() | JROOT\libraries\src\Router\Route.php:93 |
14 | Joomla\CMS\Router\Route::_() | JROOT\modules\mod_articles_categories\tmpl\default_items.php:20 |
13 | require JROOT\modules\mod_articles_categories\tmpl\default_items.php | JROOT\modules\mod_articles_categories\tmpl\default_items.php:37 |
12 | require JROOT\modules\mod_articles_categories\tmpl\default_items.php | JROOT\modules\mod_articles_categories\tmpl\default.php:13 |
11 | require JROOT\modules\mod_articles_categories\tmpl\default.php | JROOT\modules\mod_articles_categories\mod_articles_categories.php:35 |
10 | include JROOT\modules\mod_articles_categories\mod_articles_categories.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:491 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT\libraries\src\Document\HtmlDocument.php:783 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT\libraries\src\Document\HtmlDocument.php:557 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT\libraries\src\Application\CMSApplication.php:1044 |
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:202 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT\index.php:49 |
Query Time: 1.88 ms After last query: 1.19 ms
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 `jos_categories` AS `s`
INNER JOIN `jos_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 = 222
ORDER BY c.lft
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | s | const | PRIMARY,idx_left_right | PRIMARY | 4 | const | 1 | 100.00 | Using filesort |
1 | SIMPLE | c | ALL | cat_idx,idx_access,idx_left_right | NO INDEX KEY COULD BE USED | NULL | NULL | 227 | 24.23 | Using where |
Status | Duration |
---|
starting | 0.17 ms |
checking permissions | 0.02 ms |
checking permissions | 0.02 ms |
Opening tables | 0.03 ms |
init | 0.16 ms |
System lock | 0.02 ms |
optimizing | 0.03 ms |
statistics | 0.23 ms |
preparing | 0.04 ms |
Sorting result | 0.01 ms |
executing | 0.01 ms |
Sending data | 0.04 ms |
Creating sort index | 0.60 ms |
end | 0.02 ms |
query end | 0.02 ms |
closing tables | 0.02 ms |
freeing items | 0.12 ms |
cleaning up | 0.03 ms |
# | Caller | File and line number |
---|
27 | JDatabaseDriverMysql->execute() | JROOT\libraries\joomla\database\driver.php:1701 |
26 | JDatabaseDriver->loadObjectList() | JROOT\libraries\src\Categories\Categories.php:324 |
25 | Joomla\CMS\Categories\Categories->_load() | JROOT\libraries\src\Categories\Categories.php:184 |
24 | Joomla\CMS\Categories\Categories->get() | JROOT\components\com_content\router.php:72 |
23 | ContentRouter->getCategorySegment() | Same as call in the line below. |
22 | call_user_func_array() | JROOT\libraries\src\Component\Router\RouterView.php:120 |
21 | Joomla\CMS\Component\Router\RouterView->getPath() | JROOT\libraries\src\Component\Router\Rules\MenuRules.php:111 |
20 | Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() | JROOT\libraries\src\Component\Router\RouterView.php:222 |
19 | Joomla\CMS\Component\Router\RouterView->preprocess() | JROOT\libraries\src\Router\SiteRouter.php:672 |
18 | Joomla\CMS\Router\SiteRouter->processBuildRules() | JROOT\libraries\src\Router\Router.php:266 |
17 | Joomla\CMS\Router\Router->build() | JROOT\libraries\src\Router\SiteRouter.php:154 |
16 | Joomla\CMS\Router\SiteRouter->build() | JROOT\libraries\src\Router\Route.php:144 |
15 | Joomla\CMS\Router\Route::link() | JROOT\libraries\src\Router\Route.php:93 |
14 | Joomla\CMS\Router\Route::_() | JROOT\modules\mod_articles_categories\tmpl\default_items.php:20 |
13 | require JROOT\modules\mod_articles_categories\tmpl\default_items.php | JROOT\modules\mod_articles_categories\tmpl\default_items.php:37 |
12 | require JROOT\modules\mod_articles_categories\tmpl\default_items.php | JROOT\modules\mod_articles_categories\tmpl\default.php:13 |
11 | require JROOT\modules\mod_articles_categories\tmpl\default.php | JROOT\modules\mod_articles_categories\mod_articles_categories.php:35 |
10 | include JROOT\modules\mod_articles_categories\mod_articles_categories.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:491 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT\libraries\src\Document\HtmlDocument.php:783 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT\libraries\src\Document\HtmlDocument.php:557 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT\libraries\src\Application\CMSApplication.php:1044 |
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:202 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT\index.php:49 |
Query Time: 1.74 ms After last query: 1.28 ms
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 `jos_categories` AS `s`
INNER JOIN `jos_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 = 223
ORDER BY c.lft
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | s | const | PRIMARY,idx_left_right | PRIMARY | 4 | const | 1 | 100.00 | Using filesort |
1 | SIMPLE | c | ALL | cat_idx,idx_access,idx_left_right | NO INDEX KEY COULD BE USED | NULL | NULL | 227 | 24.67 | Using where |
Status | Duration |
---|
starting | 0.19 ms |
checking permissions | 0.02 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.08 ms |
System lock | 0.02 ms |
optimizing | 0.03 ms |
statistics | 0.22 ms |
preparing | 0.04 ms |
Sorting result | 0.01 ms |
executing | 0.01 ms |
Sending data | 0.04 ms |
Creating sort index | 0.57 ms |
end | 0.02 ms |
query end | 0.02 ms |
closing tables | 0.02 ms |
freeing items | 0.11 ms |
cleaning up | 0.03 ms |
# | Caller | File and line number |
---|
27 | JDatabaseDriverMysql->execute() | JROOT\libraries\joomla\database\driver.php:1701 |
26 | JDatabaseDriver->loadObjectList() | JROOT\libraries\src\Categories\Categories.php:324 |
25 | Joomla\CMS\Categories\Categories->_load() | JROOT\libraries\src\Categories\Categories.php:184 |
24 | Joomla\CMS\Categories\Categories->get() | JROOT\components\com_content\router.php:72 |
23 | ContentRouter->getCategorySegment() | Same as call in the line below. |
22 | call_user_func_array() | JROOT\libraries\src\Component\Router\RouterView.php:120 |
21 | Joomla\CMS\Component\Router\RouterView->getPath() | JROOT\libraries\src\Component\Router\Rules\MenuRules.php:111 |
20 | Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() | JROOT\libraries\src\Component\Router\RouterView.php:222 |
19 | Joomla\CMS\Component\Router\RouterView->preprocess() | JROOT\libraries\src\Router\SiteRouter.php:672 |
18 | Joomla\CMS\Router\SiteRouter->processBuildRules() | JROOT\libraries\src\Router\Router.php:266 |
17 | Joomla\CMS\Router\Router->build() | JROOT\libraries\src\Router\SiteRouter.php:154 |
16 | Joomla\CMS\Router\SiteRouter->build() | JROOT\libraries\src\Router\Route.php:144 |
15 | Joomla\CMS\Router\Route::link() | JROOT\libraries\src\Router\Route.php:93 |
14 | Joomla\CMS\Router\Route::_() | JROOT\modules\mod_articles_categories\tmpl\default_items.php:20 |
13 | require JROOT\modules\mod_articles_categories\tmpl\default_items.php | JROOT\modules\mod_articles_categories\tmpl\default_items.php:37 |
12 | require JROOT\modules\mod_articles_categories\tmpl\default_items.php | JROOT\modules\mod_articles_categories\tmpl\default.php:13 |
11 | require JROOT\modules\mod_articles_categories\tmpl\default.php | JROOT\modules\mod_articles_categories\mod_articles_categories.php:35 |
10 | include JROOT\modules\mod_articles_categories\mod_articles_categories.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:491 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT\libraries\src\Document\HtmlDocument.php:783 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT\libraries\src\Document\HtmlDocument.php:557 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT\libraries\src\Application\CMSApplication.php:1044 |
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:202 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT\index.php:49 |
Query Time: 2.10 ms After last query: 1.31 ms
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 `jos_categories` AS `s`
INNER JOIN `jos_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 = 224
ORDER BY c.lft
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | s | const | PRIMARY,idx_left_right | PRIMARY | 4 | const | 1 | 100.00 | Using filesort |
1 | SIMPLE | c | ALL | cat_idx,idx_access,idx_left_right | NO INDEX KEY COULD BE USED | NULL | NULL | 227 | 25.11 | Using where |
Status | Duration |
---|
starting | 0.17 ms |
checking permissions | 0.02 ms |
checking permissions | 0.02 ms |
Opening tables | 0.03 ms |
init | 0.08 ms |
System lock | 0.02 ms |
optimizing | 0.03 ms |
statistics | 0.23 ms |
preparing | 0.04 ms |
Sorting result | 0.01 ms |
executing | 0.01 ms |
Sending data | 0.04 ms |
Creating sort index | 0.77 ms |
end | 0.02 ms |
query end | 0.02 ms |
closing tables | 0.03 ms |
freeing items | 0.13 ms |
cleaning up | 0.04 ms |
# | Caller | File and line number |
---|
27 | JDatabaseDriverMysql->execute() | JROOT\libraries\joomla\database\driver.php:1701 |
26 | JDatabaseDriver->loadObjectList() | JROOT\libraries\src\Categories\Categories.php:324 |
25 | Joomla\CMS\Categories\Categories->_load() | JROOT\libraries\src\Categories\Categories.php:184 |
24 | Joomla\CMS\Categories\Categories->get() | JROOT\components\com_content\router.php:72 |
23 | ContentRouter->getCategorySegment() | Same as call in the line below. |
22 | call_user_func_array() | JROOT\libraries\src\Component\Router\RouterView.php:120 |
21 | Joomla\CMS\Component\Router\RouterView->getPath() | JROOT\libraries\src\Component\Router\Rules\MenuRules.php:111 |
20 | Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() | JROOT\libraries\src\Component\Router\RouterView.php:222 |
19 | Joomla\CMS\Component\Router\RouterView->preprocess() | JROOT\libraries\src\Router\SiteRouter.php:672 |
18 | Joomla\CMS\Router\SiteRouter->processBuildRules() | JROOT\libraries\src\Router\Router.php:266 |
17 | Joomla\CMS\Router\Router->build() | JROOT\libraries\src\Router\SiteRouter.php:154 |
16 | Joomla\CMS\Router\SiteRouter->build() | JROOT\libraries\src\Router\Route.php:144 |
15 | Joomla\CMS\Router\Route::link() | JROOT\libraries\src\Router\Route.php:93 |
14 | Joomla\CMS\Router\Route::_() | JROOT\modules\mod_articles_categories\tmpl\default_items.php:20 |
13 | require JROOT\modules\mod_articles_categories\tmpl\default_items.php | JROOT\modules\mod_articles_categories\tmpl\default_items.php:37 |
12 | require JROOT\modules\mod_articles_categories\tmpl\default_items.php | JROOT\modules\mod_articles_categories\tmpl\default.php:13 |
11 | require JROOT\modules\mod_articles_categories\tmpl\default.php | JROOT\modules\mod_articles_categories\mod_articles_categories.php:35 |
10 | include JROOT\modules\mod_articles_categories\mod_articles_categories.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:491 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT\libraries\src\Document\HtmlDocument.php:783 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT\libraries\src\Document\HtmlDocument.php:557 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT\libraries\src\Application\CMSApplication.php:1044 |
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:202 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT\index.php:49 |
Query Time: 1.73 ms After last query: 1.51 ms
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 `jos_categories` AS `s`
INNER JOIN `jos_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 = 163
ORDER BY c.lft
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | s | const | PRIMARY,idx_left_right | PRIMARY | 4 | const | 1 | 100.00 | Using filesort |
1 | SIMPLE | c | ALL | cat_idx,idx_access,idx_left_right | NO INDEX KEY COULD BE USED | NULL | NULL | 227 | 25.99 | Using where |
Status | Duration |
---|
starting | 0.17 ms |
checking permissions | 0.02 ms |
checking permissions | 0.02 ms |
Opening tables | 0.03 ms |
init | 0.08 ms |
System lock | 0.02 ms |
optimizing | 0.04 ms |
statistics | 0.23 ms |
preparing | 0.04 ms |
Sorting result | 0.01 ms |
executing | 0.01 ms |
Sending data | 0.04 ms |
Creating sort index | 0.57 ms |
end | 0.02 ms |
query end | 0.02 ms |
closing tables | 0.02 ms |
freeing items | 0.12 ms |
cleaning up | 0.03 ms |
# | Caller | File and line number |
---|
26 | JDatabaseDriverMysql->execute() | JROOT\libraries\joomla\database\driver.php:1701 |
25 | JDatabaseDriver->loadObjectList() | JROOT\libraries\src\Categories\Categories.php:324 |
24 | Joomla\CMS\Categories\Categories->_load() | JROOT\libraries\src\Categories\Categories.php:184 |
23 | Joomla\CMS\Categories\Categories->get() | JROOT\components\com_content\router.php:72 |
22 | ContentRouter->getCategorySegment() | Same as call in the line below. |
21 | call_user_func_array() | JROOT\libraries\src\Component\Router\RouterView.php:120 |
20 | Joomla\CMS\Component\Router\RouterView->getPath() | JROOT\libraries\src\Component\Router\Rules\MenuRules.php:111 |
19 | Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() | JROOT\libraries\src\Component\Router\RouterView.php:222 |
18 | Joomla\CMS\Component\Router\RouterView->preprocess() | JROOT\libraries\src\Router\SiteRouter.php:672 |
17 | Joomla\CMS\Router\SiteRouter->processBuildRules() | JROOT\libraries\src\Router\Router.php:266 |
16 | Joomla\CMS\Router\Router->build() | JROOT\libraries\src\Router\SiteRouter.php:154 |
15 | Joomla\CMS\Router\SiteRouter->build() | JROOT\libraries\src\Router\Route.php:144 |
14 | Joomla\CMS\Router\Route::link() | JROOT\libraries\src\Router\Route.php:93 |
13 | Joomla\CMS\Router\Route::_() | JROOT\modules\mod_articles_categories\tmpl\default_items.php:20 |
12 | require JROOT\modules\mod_articles_categories\tmpl\default_items.php | JROOT\modules\mod_articles_categories\tmpl\default.php:13 |
11 | require JROOT\modules\mod_articles_categories\tmpl\default.php | JROOT\modules\mod_articles_categories\mod_articles_categories.php:35 |
10 | include JROOT\modules\mod_articles_categories\mod_articles_categories.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:491 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT\libraries\src\Document\HtmlDocument.php:783 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT\libraries\src\Document\HtmlDocument.php:557 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT\libraries\src\Application\CMSApplication.php:1044 |
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:202 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT\index.php:49 |
Query Time: 1.87 ms After last query: 2.47 ms
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 `jos_categories` AS `s`
INNER JOIN `jos_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 = 199
ORDER BY c.lft
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | s | const | PRIMARY,idx_left_right | PRIMARY | 4 | const | 1 | 100.00 | Using filesort |
1 | SIMPLE | c | ALL | cat_idx,idx_access,idx_left_right | NO INDEX KEY COULD BE USED | NULL | NULL | 227 | 26.43 | Using where |
Status | Duration |
---|
starting | 0.16 ms |
checking permissions | 0.03 ms |
checking permissions | 0.02 ms |
Opening tables | 0.03 ms |
init | 0.07 ms |
System lock | 0.02 ms |
optimizing | 0.03 ms |
statistics | 0.22 ms |
preparing | 0.03 ms |
Sorting result | 0.01 ms |
executing | 0.01 ms |
Sending data | 0.03 ms |
Creating sort index | 0.58 ms |
end | 0.02 ms |
query end | 0.02 ms |
closing tables | 0.02 ms |
freeing items | 0.13 ms |
cleaning up | 0.03 ms |
# | Caller | File and line number |
---|
26 | JDatabaseDriverMysql->execute() | JROOT\libraries\joomla\database\driver.php:1701 |
25 | JDatabaseDriver->loadObjectList() | JROOT\libraries\src\Categories\Categories.php:324 |
24 | Joomla\CMS\Categories\Categories->_load() | JROOT\libraries\src\Categories\Categories.php:184 |
23 | Joomla\CMS\Categories\Categories->get() | JROOT\components\com_content\router.php:72 |
22 | ContentRouter->getCategorySegment() | Same as call in the line below. |
21 | call_user_func_array() | JROOT\libraries\src\Component\Router\RouterView.php:120 |
20 | Joomla\CMS\Component\Router\RouterView->getPath() | JROOT\libraries\src\Component\Router\Rules\MenuRules.php:111 |
19 | Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() | JROOT\libraries\src\Component\Router\RouterView.php:222 |
18 | Joomla\CMS\Component\Router\RouterView->preprocess() | JROOT\libraries\src\Router\SiteRouter.php:672 |
17 | Joomla\CMS\Router\SiteRouter->processBuildRules() | JROOT\libraries\src\Router\Router.php:266 |
16 | Joomla\CMS\Router\Router->build() | JROOT\libraries\src\Router\SiteRouter.php:154 |
15 | Joomla\CMS\Router\SiteRouter->build() | JROOT\libraries\src\Router\Route.php:144 |
14 | Joomla\CMS\Router\Route::link() | JROOT\libraries\src\Router\Route.php:93 |
13 | Joomla\CMS\Router\Route::_() | JROOT\modules\mod_articles_categories\tmpl\default_items.php:20 |
12 | require JROOT\modules\mod_articles_categories\tmpl\default_items.php | JROOT\modules\mod_articles_categories\tmpl\default.php:13 |
11 | require JROOT\modules\mod_articles_categories\tmpl\default.php | JROOT\modules\mod_articles_categories\mod_articles_categories.php:35 |
10 | include JROOT\modules\mod_articles_categories\mod_articles_categories.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:491 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT\libraries\src\Document\HtmlDocument.php:783 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT\libraries\src\Document\HtmlDocument.php:557 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT\libraries\src\Application\CMSApplication.php:1044 |
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:202 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT\index.php:49 |
Query Time: 1.98 ms After last query: 1.21 ms
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 `jos_categories` AS `s`
INNER JOIN `jos_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 = 165
ORDER BY c.lft
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | s | const | PRIMARY,idx_left_right | PRIMARY | 4 | const | 1 | 100.00 | Using filesort |
1 | SIMPLE | c | ALL | cat_idx,idx_access,idx_left_right | NO INDEX KEY COULD BE USED | NULL | NULL | 227 | 26.87 | Using where |
Status | Duration |
---|
starting | 0.18 ms |
checking permissions | 0.02 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.08 ms |
System lock | 0.02 ms |
optimizing | 0.03 ms |
statistics | 0.23 ms |
preparing | 0.04 ms |
Sorting result | 0.01 ms |
executing | 0.01 ms |
Sending data | 0.04 ms |
Creating sort index | 0.68 ms |
end | 0.02 ms |
query end | 0.02 ms |
closing tables | 0.02 ms |
freeing items | 0.12 ms |
cleaning up | 0.03 ms |
# | Caller | File and line number |
---|
26 | JDatabaseDriverMysql->execute() | JROOT\libraries\joomla\database\driver.php:1701 |
25 | JDatabaseDriver->loadObjectList() | JROOT\libraries\src\Categories\Categories.php:324 |
24 | Joomla\CMS\Categories\Categories->_load() | JROOT\libraries\src\Categories\Categories.php:184 |
23 | Joomla\CMS\Categories\Categories->get() | JROOT\components\com_content\router.php:72 |
22 | ContentRouter->getCategorySegment() | Same as call in the line below. |
21 | call_user_func_array() | JROOT\libraries\src\Component\Router\RouterView.php:120 |
20 | Joomla\CMS\Component\Router\RouterView->getPath() | JROOT\libraries\src\Component\Router\Rules\MenuRules.php:111 |
19 | Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() | JROOT\libraries\src\Component\Router\RouterView.php:222 |
18 | Joomla\CMS\Component\Router\RouterView->preprocess() | JROOT\libraries\src\Router\SiteRouter.php:672 |
17 | Joomla\CMS\Router\SiteRouter->processBuildRules() | JROOT\libraries\src\Router\Router.php:266 |
16 | Joomla\CMS\Router\Router->build() | JROOT\libraries\src\Router\SiteRouter.php:154 |
15 | Joomla\CMS\Router\SiteRouter->build() | JROOT\libraries\src\Router\Route.php:144 |
14 | Joomla\CMS\Router\Route::link() | JROOT\libraries\src\Router\Route.php:93 |
13 | Joomla\CMS\Router\Route::_() | JROOT\modules\mod_articles_categories\tmpl\default_items.php:20 |
12 | require JROOT\modules\mod_articles_categories\tmpl\default_items.php | JROOT\modules\mod_articles_categories\tmpl\default.php:13 |
11 | require JROOT\modules\mod_articles_categories\tmpl\default.php | JROOT\modules\mod_articles_categories\mod_articles_categories.php:35 |
10 | include JROOT\modules\mod_articles_categories\mod_articles_categories.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:491 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT\libraries\src\Document\HtmlDocument.php:783 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT\libraries\src\Document\HtmlDocument.php:557 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT\libraries\src\Application\CMSApplication.php:1044 |
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:202 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT\index.php:49 |
Query Time: 1.85 ms After last query: 1.19 ms
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 `jos_categories` AS `s`
INNER JOIN `jos_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 = 61
ORDER BY c.lft
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | s | const | PRIMARY,idx_left_right | PRIMARY | 4 | const | 1 | 100.00 | Using filesort |
1 | SIMPLE | c | ALL | cat_idx,idx_access,idx_left_right | NO INDEX KEY COULD BE USED | NULL | NULL | 227 | 27.31 | Using where |
Status | Duration |
---|
starting | 0.18 ms |
checking permissions | 0.02 ms |
checking permissions | 0.01 ms |
Opening tables | 0.04 ms |
init | 0.08 ms |
System lock | 0.02 ms |
optimizing | 0.03 ms |
statistics | 0.23 ms |
preparing | 0.04 ms |
Sorting result | 0.01 ms |
executing | 0.01 ms |
Sending data | 0.04 ms |
Creating sort index | 0.59 ms |
end | 0.02 ms |
query end | 0.02 ms |
closing tables | 0.02 ms |
freeing items | 0.12 ms |
cleaning up | 0.03 ms |
# | Caller | File and line number |
---|
26 | JDatabaseDriverMysql->execute() | JROOT\libraries\joomla\database\driver.php:1701 |
25 | JDatabaseDriver->loadObjectList() | JROOT\libraries\src\Categories\Categories.php:324 |
24 | Joomla\CMS\Categories\Categories->_load() | JROOT\libraries\src\Categories\Categories.php:184 |
23 | Joomla\CMS\Categories\Categories->get() | JROOT\components\com_content\router.php:72 |
22 | ContentRouter->getCategorySegment() | Same as call in the line below. |
21 | call_user_func_array() | JROOT\libraries\src\Component\Router\RouterView.php:120 |
20 | Joomla\CMS\Component\Router\RouterView->getPath() | JROOT\libraries\src\Component\Router\Rules\MenuRules.php:111 |
19 | Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() | JROOT\libraries\src\Component\Router\RouterView.php:222 |
18 | Joomla\CMS\Component\Router\RouterView->preprocess() | JROOT\libraries\src\Router\SiteRouter.php:672 |
17 | Joomla\CMS\Router\SiteRouter->processBuildRules() | JROOT\libraries\src\Router\Router.php:266 |
16 | Joomla\CMS\Router\Router->build() | JROOT\libraries\src\Router\SiteRouter.php:154 |
15 | Joomla\CMS\Router\SiteRouter->build() | JROOT\libraries\src\Router\Route.php:144 |
14 | Joomla\CMS\Router\Route::link() | JROOT\libraries\src\Router\Route.php:93 |
13 | Joomla\CMS\Router\Route::_() | JROOT\modules\mod_articles_categories\tmpl\default_items.php:20 |
12 | require JROOT\modules\mod_articles_categories\tmpl\default_items.php | JROOT\modules\mod_articles_categories\tmpl\default.php:13 |
11 | require JROOT\modules\mod_articles_categories\tmpl\default.php | JROOT\modules\mod_articles_categories\mod_articles_categories.php:35 |
10 | include JROOT\modules\mod_articles_categories\mod_articles_categories.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:491 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT\libraries\src\Document\HtmlDocument.php:783 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT\libraries\src\Document\HtmlDocument.php:557 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT\libraries\src\Application\CMSApplication.php:1044 |
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:202 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT\index.php:49 |
Query Time: 1.76 ms After last query: 1.24 ms
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 `jos_categories` AS `s`
INNER JOIN `jos_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 = 162
ORDER BY c.lft
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | s | const | PRIMARY,idx_left_right | PRIMARY | 4 | const | 1 | 100.00 | Using filesort |
1 | SIMPLE | c | ALL | cat_idx,idx_access,idx_left_right | NO INDEX KEY COULD BE USED | NULL | NULL | 227 | 27.75 | Using where |
Status | Duration |
---|
starting | 0.18 ms |
checking permissions | 0.02 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.08 ms |
System lock | 0.02 ms |
optimizing | 0.03 ms |
statistics | 0.24 ms |
preparing | 0.04 ms |
Sorting result | 0.01 ms |
executing | 0.01 ms |
Sending data | 0.04 ms |
Creating sort index | 0.58 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.02 ms |
freeing items | 0.12 ms |
cleaning up | 0.04 ms |
# | Caller | File and line number |
---|
26 | JDatabaseDriverMysql->execute() | JROOT\libraries\joomla\database\driver.php:1701 |
25 | JDatabaseDriver->loadObjectList() | JROOT\libraries\src\Categories\Categories.php:324 |
24 | Joomla\CMS\Categories\Categories->_load() | JROOT\libraries\src\Categories\Categories.php:184 |
23 | Joomla\CMS\Categories\Categories->get() | JROOT\components\com_content\router.php:72 |
22 | ContentRouter->getCategorySegment() | Same as call in the line below. |
21 | call_user_func_array() | JROOT\libraries\src\Component\Router\RouterView.php:120 |
20 | Joomla\CMS\Component\Router\RouterView->getPath() | JROOT\libraries\src\Component\Router\Rules\MenuRules.php:111 |
19 | Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() | JROOT\libraries\src\Component\Router\RouterView.php:222 |
18 | Joomla\CMS\Component\Router\RouterView->preprocess() | JROOT\libraries\src\Router\SiteRouter.php:672 |
17 | Joomla\CMS\Router\SiteRouter->processBuildRules() | JROOT\libraries\src\Router\Router.php:266 |
16 | Joomla\CMS\Router\Router->build() | JROOT\libraries\src\Router\SiteRouter.php:154 |
15 | Joomla\CMS\Router\SiteRouter->build() | JROOT\libraries\src\Router\Route.php:144 |
14 | Joomla\CMS\Router\Route::link() | JROOT\libraries\src\Router\Route.php:93 |
13 | Joomla\CMS\Router\Route::_() | JROOT\modules\mod_articles_categories\tmpl\default_items.php:20 |
12 | require JROOT\modules\mod_articles_categories\tmpl\default_items.php | JROOT\modules\mod_articles_categories\tmpl\default.php:13 |
11 | require JROOT\modules\mod_articles_categories\tmpl\default.php | JROOT\modules\mod_articles_categories\mod_articles_categories.php:35 |
10 | include JROOT\modules\mod_articles_categories\mod_articles_categories.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:491 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT\libraries\src\Document\HtmlDocument.php:783 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT\libraries\src\Document\HtmlDocument.php:557 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT\libraries\src\Application\CMSApplication.php:1044 |
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:202 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT\index.php:49 |
Query Time: 1.83 ms After last query: 1.28 ms
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 `jos_categories` AS `s`
INNER JOIN `jos_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 = 64
ORDER BY c.lft
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | s | const | PRIMARY,idx_left_right | PRIMARY | 4 | const | 1 | 100.00 | Using filesort |
1 | SIMPLE | c | ALL | cat_idx,idx_access,idx_left_right | NO INDEX KEY COULD BE USED | NULL | NULL | 227 | 28.19 | Using where |
Status | Duration |
---|
starting | 0.17 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.08 ms |
System lock | 0.02 ms |
optimizing | 0.03 ms |
statistics | 0.24 ms |
preparing | 0.04 ms |
Sorting result | 0.01 ms |
executing | 0.01 ms |
Sending data | 0.03 ms |
Creating sort index | 0.60 ms |
end | 0.02 ms |
query end | 0.02 ms |
closing tables | 0.03 ms |
freeing items | 0.12 ms |
cleaning up | 0.03 ms |
# | Caller | File and line number |
---|
26 | JDatabaseDriverMysql->execute() | JROOT\libraries\joomla\database\driver.php:1701 |
25 | JDatabaseDriver->loadObjectList() | JROOT\libraries\src\Categories\Categories.php:324 |
24 | Joomla\CMS\Categories\Categories->_load() | JROOT\libraries\src\Categories\Categories.php:184 |
23 | Joomla\CMS\Categories\Categories->get() | JROOT\components\com_content\router.php:72 |
22 | ContentRouter->getCategorySegment() | Same as call in the line below. |
21 | call_user_func_array() | JROOT\libraries\src\Component\Router\RouterView.php:120 |
20 | Joomla\CMS\Component\Router\RouterView->getPath() | JROOT\libraries\src\Component\Router\Rules\MenuRules.php:111 |
19 | Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() | JROOT\libraries\src\Component\Router\RouterView.php:222 |
18 | Joomla\CMS\Component\Router\RouterView->preprocess() | JROOT\libraries\src\Router\SiteRouter.php:672 |
17 | Joomla\CMS\Router\SiteRouter->processBuildRules() | JROOT\libraries\src\Router\Router.php:266 |
16 | Joomla\CMS\Router\Router->build() | JROOT\libraries\src\Router\SiteRouter.php:154 |
15 | Joomla\CMS\Router\SiteRouter->build() | JROOT\libraries\src\Router\Route.php:144 |
14 | Joomla\CMS\Router\Route::link() | JROOT\libraries\src\Router\Route.php:93 |
13 | Joomla\CMS\Router\Route::_() | JROOT\modules\mod_articles_categories\tmpl\default_items.php:20 |
12 | require JROOT\modules\mod_articles_categories\tmpl\default_items.php | JROOT\modules\mod_articles_categories\tmpl\default.php:13 |
11 | require JROOT\modules\mod_articles_categories\tmpl\default.php | JROOT\modules\mod_articles_categories\mod_articles_categories.php:35 |
10 | include JROOT\modules\mod_articles_categories\mod_articles_categories.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:491 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT\libraries\src\Document\HtmlDocument.php:783 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT\libraries\src\Document\HtmlDocument.php:557 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT\libraries\src\Application\CMSApplication.php:1044 |
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:202 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT\index.php:49 |
Query Time: 3.54 ms After last query: 224.21 ms
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 jos_fields AS a
LEFT JOIN `jos_languages` AS l
ON l.lang_code = a.language
LEFT JOIN jos_users AS uc
ON uc.id=a.checked_out
LEFT JOIN jos_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN jos_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN jos_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `jos_fields_categories` AS fc
ON fc.field_id = a.id
WHERE a.context = 'mod_custom.content'
AND (fc.category_id IS NULL OR fc.category_id IN (225,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 | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | a | ref | idx_state,idx_access,idx_context | idx_state | 1 | const | 1 | 100.00 | Using where; Using temporary; Using filesort |
1 | SIMPLE | l | eq_ref | idx_langcode | idx_langcode | 28 | phubbard_joomla_e.a.language | 1 | 100.00 | Using where |
1 | SIMPLE | uc | eq_ref | PRIMARY | PRIMARY | 4 | phubbard_joomla_e.a.checked_out | 1 | 100.00 | NULL |
1 | SIMPLE | ag | eq_ref | PRIMARY | PRIMARY | 4 | phubbard_joomla_e.a.access | 1 | 100.00 | Using where |
1 | SIMPLE | ua | eq_ref | PRIMARY | PRIMARY | 4 | phubbard_joomla_e.a.created_user_id | 1 | 100.00 | Using where |
1 | SIMPLE | g | eq_ref | PRIMARY | PRIMARY | 4 | phubbard_joomla_e.a.group_id | 1 | 100.00 | Using where |
1 | SIMPLE | fc | ref | PRIMARY | PRIMARY | 4 | phubbard_joomla_e.a.id | 1 | 100.00 | Using where; Using index; Distinct |
Status | Duration |
---|
starting | 0.18 ms |
checking permissions | 0.02 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.06 ms |
init | 0.10 ms |
System lock | 0.03 ms |
optimizing | 0.04 ms |
statistics | 0.25 ms |
preparing | 0.09 ms |
Creating tmp table | 0.11 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 1.43 ms |
Creating sort index | 0.07 ms |
end | 0.02 ms |
removing tmp table | 0.50 ms |
end | 0.02 ms |
query end | 0.02 ms |
closing tables | 0.04 ms |
freeing items | 0.10 ms |
cleaning up | 0.04 ms |
# | Caller | File and line number |
---|
24 | JDatabaseDriverMysql->execute() | JROOT\libraries\joomla\database\driver.php:1701 |
23 | JDatabaseDriver->loadObjectList() | JROOT\libraries\src\MVC\Model\BaseDatabaseModel.php:308 |
22 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT\administrator\components\com_fields\models\fields.php:333 |
21 | FieldsModelFields->_getList() | JROOT\libraries\src\MVC\Model\ListModel.php:187 |
20 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT\administrator\components\com_fields\helpers\fields.php:135 |
19 | FieldsHelper::getFields() | JROOT\plugins\system\fields\fields.php:495 |
18 | PlgSystemFields->onContentPrepare() | Same as call in the line below. |
17 | call_user_func_array() | JROOT\libraries\joomla\event\event.php:70 |
16 | JEvent->update() | JROOT\libraries\joomla\event\dispatcher.php:160 |
15 | JEventDispatcher->trigger() | JROOT\libraries\cms\html\content.php:41 |
14 | JHtmlContent::prepare() | Same as call in the line below. |
13 | call_user_func_array() | JROOT\libraries\src\HTML\HTMLHelper.php:239 |
12 | Joomla\CMS\HTML\HTMLHelper::call() | JROOT\libraries\src\HTML\HTMLHelper.php:146 |
11 | Joomla\CMS\HTML\HTMLHelper::_() | JROOT\modules\mod_custom\mod_custom.php:15 |
10 | include JROOT\modules\mod_custom\mod_custom.php | JROOT\libraries\src\Helper\ModuleHelper.php:200 |
9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT\libraries\src\Document\Renderer\Html\ModuleRenderer.php:98 |
8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT\libraries\src\Document\Renderer\Html\ModulesRenderer.php:47 |
7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT\libraries\src\Document\HtmlDocument.php:491 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT\libraries\src\Document\HtmlDocument.php:783 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT\libraries\src\Document\HtmlDocument.php:557 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT\libraries\src\Application\CMSApplication.php:1044 |
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:202 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT\index.php:49 |
Query Time: 2.81 ms After last query: 111.54 ms
SHOW FULL COLUMNS
FROM `jos_template_styles`
EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `jos_template_styles`
Status | Duration |
---|
starting | 0.06 ms |
checking permissions | 0.02 ms |
checking permissions | 0.01 ms |
Opening tables | 1.20 ms |
init | 0.02 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.02 ms |
preparing | 0.02 ms |
executing | 0.02 ms |
Opening tables | 0.03 ms |
checking permissions | 0.09 ms |
checking permissions | 0.05 ms |
checking permissions | 0.04 ms |
checking permissions | 0.08 ms |
checking permissions | 0.03 ms |
checking permissions | 0.03 ms |
Sending data | 0.06 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
removing tmp table | 0.51 ms |
closing tables | 0.02 ms |
freeing items | 0.09 ms |
cleaning up | 0.03 ms |
# | Caller | File and line number |
---|
22 | JDatabaseDriverMysql->execute() | JROOT\libraries\joomla\database\driver.php:1701 |
21 | JDatabaseDriver->loadObjectList() | JROOT\libraries\joomla\database\driver\mysqli.php:445 |
20 | JDatabaseDriverMysqli->getTableColumns() | JROOT\libraries\src\Table\Table.php:245 |
19 | Joomla\CMS\Table\Table->getFields() | JROOT\libraries\src\Table\Table.php:164 |
18 | Joomla\CMS\Table\Table->__construct() | JROOT\administrator\components\com_templates\tables\style.php:30 |
17 | TemplatesTableStyle->__construct() | JROOT\libraries\src\Table\Table.php:312 |
16 | Joomla\CMS\Table\Table::getInstance() | JROOT\plugins\system\gantry\gantry.php:194 |
15 | plgSystemGantry->getTable() | JROOT\plugins\system\gantry\gantry.php:165 |
14 | plgSystemGantry->isGantryTemplate() | JROOT\plugins\system\gantry\gantry.php:234 |
13 | plgSystemGantry->onBeforeCompileHead() | Same as call in the line below. |
12 | call_user_func_array() | JROOT\libraries\joomla\event\event.php:70 |
11 | JEvent->update() | JROOT\libraries\joomla\event\dispatcher.php:160 |
10 | JEventDispatcher->trigger() | JROOT\libraries\src\Application\BaseApplication.php:108 |
9 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT\libraries\src\Document\Renderer\Html\HeadRenderer.php:67 |
8 | Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead() | JROOT\libraries\src\Document\Renderer\Html\HeadRenderer.php:38 |
7 | Joomla\CMS\Document\Renderer\Html\HeadRenderer->render() | JROOT\libraries\src\Document\HtmlDocument.php:491 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT\libraries\src\Document\HtmlDocument.php:783 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT\libraries\src\Document\HtmlDocument.php:557 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT\libraries\src\Application\CMSApplication.php:1044 |
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:202 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT\index.php:49 |
Query Time: 0.82 ms After last query: 45.25 ms
SELECT *
FROM jos_template_styles
WHERE `id` = '11'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | jos_template_styles | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
Status | Duration |
---|
starting | 0.07 ms |
checking permissions | 0.02 ms |
Opening tables | 0.03 ms |
init | 0.04 ms |
System lock | 0.02 ms |
optimizing | 0.02 ms |
statistics | 0.08 ms |
preparing | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.02 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.02 ms |
freeing items | 0.12 ms |
cleaning up | 0.06 ms |
# | Caller | File and line number |
---|
17 | JDatabaseDriverMysql->execute() | JROOT\libraries\joomla\database\driver.php:1465 |
16 | JDatabaseDriver->loadAssoc() | JROOT\libraries\src\Table\Table.php:731 |
15 | Joomla\CMS\Table\Table->load() | JROOT\plugins\system\gantry\gantry.php:168 |
14 | plgSystemGantry->isGantryTemplate() | JROOT\plugins\system\gantry\gantry.php:234 |
13 | plgSystemGantry->onBeforeCompileHead() | Same as call in the line below. |
12 | call_user_func_array() | JROOT\libraries\joomla\event\event.php:70 |
11 | JEvent->update() | JROOT\libraries\joomla\event\dispatcher.php:160 |
10 | JEventDispatcher->trigger() | JROOT\libraries\src\Application\BaseApplication.php:108 |
9 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT\libraries\src\Document\Renderer\Html\HeadRenderer.php:67 |
8 | Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead() | JROOT\libraries\src\Document\Renderer\Html\HeadRenderer.php:38 |
7 | Joomla\CMS\Document\Renderer\Html\HeadRenderer->render() | JROOT\libraries\src\Document\HtmlDocument.php:491 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT\libraries\src\Document\HtmlDocument.php:783 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT\libraries\src\Document\HtmlDocument.php:557 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT\libraries\src\Application\CMSApplication.php:1044 |
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:202 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT\index.php:49 |
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
FROM `jos_categories` AS `s`
INNER JOIN `jos_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
8 × SELECT id, home, template, s.params
FROM jos_template_styles as s
LEFT JOIN jos_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
2 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `jos_assets`
2 × SELECT `m`.`tag_id`,`t`.*
FROM `jos_contentitem_tag_map` AS m
INNER JOIN `jos_tags` AS t
ON `m`.`tag_id` = `t`.`id`
2 × SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM jos_fields AS a
LEFT JOIN `jos_languages` AS l
ON l.lang_code = a.language
LEFT JOIN jos_users AS uc
ON uc.id=a.checked_out
LEFT JOIN jos_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN jos_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN jos_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `jos_fields_categories` AS fc
ON fc.field_id = a.id
2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `jos_extensions`
1 × SELECT *
FROM jos_template_styles
1 × SELECT COUNT(*)
FROM jos_content AS a
LEFT JOIN jos_categories AS c
ON c.id = a.catid
LEFT JOIN jos_users AS ua
ON ua.id = a.created_by
LEFT JOIN jos_users AS uam
ON uam.id = a.modified_by
LEFT JOIN jos_categories as parent
ON parent.id = c.parent_id
LEFT JOIN jos_content_rating AS v
ON a.id = v.content_id
1 × SELECT MAX(ordering)
FROM `jos_extensions`
1 × SELECT `ordering`
FROM `jos_extensions`
1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM jos_modules AS m
LEFT JOIN jos_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN jos_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
1 × SELECT ts.template
FROM jos_template_styles AS ts
INNER JOIN jos_menu AS m
ON ts.id=m.template_style_id
1 × SELECT `alias`
FROM `jos_content`
1 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,(
SELECT COUNT(i.`id`)
FROM `jos_content` AS `i`
1 × SELECT b.id
FROM jos_usergroups AS a
LEFT JOIN jos_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
1 × SELECT id, rules
FROM `jos_viewlevels
1 × SELECT `session_id`
FROM `jos_session`
1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM jos_extensions
1 × SELECT `enabled`
FROM `jos_extensions`
1 × SELECT `data`
FROM `jos_session`
1 × SELECT *
FROM jos_languages
1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM jos_menu AS m
LEFT JOIN jos_extensions AS e
ON m.component_id = e.extension_id
1 × SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN c.published = 2
AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum / v.rating_count, 0), 0), 0) AS rating, COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
FROM jos_content AS a
LEFT JOIN jos_categories AS c
ON c.id = a.catid
LEFT JOIN jos_users AS ua
ON ua.id = a.created_by
LEFT JOIN jos_users AS uam
ON uam.id = a.modified_by
LEFT JOIN jos_categories as parent
ON parent.id = c.parent_id
LEFT JOIN jos_content_rating AS v
ON a.id = v.content_id
Election Results
View election results here.
Election FAQs
The County Clerk is the chief election authority administering elections throughout Randolph County. The County Clerk is responsible for providing a variety of services to the voters including; voter registration and outreach programs, absentee, early and grace period voting, recruitment, training and scheduling of election judges, and election night tabulation of results. Our office also provides candidates, political parties, media, local units of government and the general public with election information including precinct lists, maps of political subdivisions, pollwatcher credentials and election results.