Query Time: 0.97 ms Query memory: 0.003 MB Memory before query: 2.459 MB
DELETE
FROM `jos_session`
WHERE `time` < '1746763535'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | jos_session | range | time | time | 4 | NULL | 1 | 100.00 | Using where |
| Status | Duration |
|---|
| Starting | 0.25 ms |
| checking permissions | 0.08 ms |
| Opening tables | 0.06 ms |
| After opening tables | 0.02 ms |
| System lock | 0.02 ms |
| table lock | 0.02 ms |
| init for update | 0.14 ms |
| Updating | 0.07 ms |
| End of update loop | 0.01 ms |
| Query end | 0.01 ms |
| Commit | 0.02 ms |
| Query end | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.02 ms |
| Query end | 0.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.10 ms |
| Updating status | 0.03 ms |
| Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 6 | JDatabaseDriverMysqli->execute() | JROOT/libraries/cms/application/cms.php:818 |
| 5 | JApplicationCms->loadSession() | JROOT/libraries/cms/application/cms.php:131 |
| 4 | JApplicationCms->__construct() | JROOT/libraries/cms/application/site.php:63 |
| 3 | JApplicationSite->__construct() | JROOT/libraries/cms/application/cms.php:412 |
| 2 | JApplicationCms::getInstance() | JROOT/libraries/joomla/factory.php:125 |
| 1 | JFactory::getApplication() | JROOT/index.php:46 |
Query Time: 2.46 ms After last query: 0.47 ms Query memory: 0.007 MB Memory before query: 2.475 MB Rows returned: 1
SELECT `data`
FROM `jos_session`
WHERE `session_id` = '5ce6e67a555017ffc8fd8efed22ac84a'
| 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 | |
| Status | Duration |
|---|
| Starting | 0.12 ms |
| Waiting for query cache lock | 0.01 ms |
| starting | 0.01 ms |
| Checking query cache for query | 0.07 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| table lock | 0.01 ms |
| Waiting for query cache lock | 0.03 ms |
| init | 0.03 ms |
| Optimizing | 0.03 ms |
| Statistics | 0.06 ms |
| Preparing | 0.01 ms |
| Unlocking tables | 0.01 ms |
| Preparing | 0.02 ms |
| Executing | 0.01 ms |
| Sending data | 0.02 ms |
| End of update loop | 0.01 ms |
| Query end | 0.01 ms |
| Commit | 0.01 ms |
| Query end | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.02 ms |
| Query end | 0.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.09 ms |
| Updating status | 0.01 ms |
| Waiting for query cache lock | 0.01 ms |
| Updating status | 0.38 ms |
| Waiting for query cache lock | 0.02 ms |
| Updating status | 0.01 ms |
| Storing result in query cache | 0.02 ms |
| Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1720 |
| 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:82 |
| 10 | JSessionHandlerJoomla->start() | JROOT/libraries/joomla/session/session.php:648 |
| 9 | JSession->_start() | JROOT/libraries/joomla/session/session.php:608 |
| 8 | JSession->start() | JROOT/libraries/joomla/session/session.php:486 |
| 7 | JSession->get() | JROOT/libraries/joomla/session/session.php:443 |
| 6 | JSession->isNew() | JROOT/libraries/cms/application/cms.php:825 |
| 5 | JApplicationCms->loadSession() | JROOT/libraries/cms/application/cms.php:131 |
| 4 | JApplicationCms->__construct() | JROOT/libraries/cms/application/site.php:63 |
| 3 | JApplicationSite->__construct() | JROOT/libraries/cms/application/cms.php:412 |
| 2 | JApplicationCms::getInstance() | JROOT/libraries/joomla/factory.php:125 |
| 1 | JFactory::getApplication() | JROOT/index.php:46 |
Query Time: 2.30 ms After last query: 6.85 ms Query memory: 0.005 MB Memory before query: 2.720 MB Rows returned: 38
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `jos_extensions`
WHERE `type` = 'component'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | jos_extensions | ref | extension | extension | 82 | const | 38 | 100.00 | Using index condition |
| Status | Duration |
|---|
| Starting | 0.18 ms |
| Waiting for query cache lock | 0.02 ms |
| starting | 0.01 ms |
| Checking query cache for query | 0.02 ms |
| checking privileges on cached | 0.01 ms |
| checking permissions | 0.02 ms |
| Sending cached result to clien | 0.14 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 9 | JDatabaseDriver->loadObjectList() | JROOT/libraries/cms/component/helper.php:452 |
| 8 | JComponentHelper::{closure}() | JROOT/libraries/joomla/cache/controller/callback.php:169 |
| 7 | JCacheControllerCallback->get() | JROOT/libraries/cms/component/helper.php:460 |
| 6 | JComponentHelper::load() | JROOT/libraries/cms/component/helper.php:43 |
| 5 | JComponentHelper::getComponent() | JROOT/libraries/cms/component/helper.php:111 |
| 4 | JComponentHelper::getParams() | JROOT/libraries/cms/application/site.php:593 |
| 3 | JApplicationSite->initialiseApp() | JROOT/libraries/cms/application/site.php:209 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Query Time: 0.38 ms After last query: 4.38 ms Query memory: 0.005 MB Memory before query: 2.960 MB Rows returned: 3
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 = 7
| 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 | |
| 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.18 ms |
| Waiting for query cache lock | 0.02 ms |
| starting | 0.01 ms |
| Checking query cache for query | 0.02 ms |
| checking privileges on cached | 0.01 ms |
| checking permissions | 0.02 ms |
| Sending cached result to clien | 0.13 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.02 ms |
| # | Caller | File and line number |
|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1530 |
| 10 | JDatabaseDriver->loadColumn() | JROOT/libraries/joomla/access/access.php:978 |
| 9 | JAccess::getGroupsByUser() | JROOT/libraries/joomla/access/access.php:1047 |
| 8 | JAccess::getAuthorisedViewLevels() | JROOT/libraries/joomla/user/user.php:453 |
| 7 | JUser->getAuthorisedViewLevels() | JROOT/libraries/cms/plugin/helper.php:293 |
| 6 | JPluginHelper::load() | JROOT/libraries/cms/plugin/helper.php:86 |
| 5 | JPluginHelper::getPlugin() | JROOT/libraries/cms/plugin/helper.php:128 |
| 4 | JPluginHelper::isEnabled() | JROOT/libraries/cms/application/site.php:603 |
| 3 | JApplicationSite->initialiseApp() | JROOT/libraries/cms/application/site.php:209 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Query Time: 0.31 ms After last query: 1.07 ms Query memory: 0.005 MB Memory before query: 3.005 MB Rows returned: 5
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 | 5 | 100.00 | |
| Status | Duration |
|---|
| Starting | 0.14 ms |
| Waiting for query cache lock | 0.01 ms |
| starting | 0.01 ms |
| Checking query cache for query | 0.02 ms |
| checking privileges on cached | 0.01 ms |
| checking permissions | 0.02 ms |
| Sending cached result to clien | 0.12 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1486 |
| 9 | JDatabaseDriver->loadAssocList() | JROOT/libraries/joomla/access/access.php:1064 |
| 8 | JAccess::getAuthorisedViewLevels() | JROOT/libraries/joomla/user/user.php:453 |
| 7 | JUser->getAuthorisedViewLevels() | JROOT/libraries/cms/plugin/helper.php:293 |
| 6 | JPluginHelper::load() | JROOT/libraries/cms/plugin/helper.php:86 |
| 5 | JPluginHelper::getPlugin() | JROOT/libraries/cms/plugin/helper.php:128 |
| 4 | JPluginHelper::isEnabled() | JROOT/libraries/cms/application/site.php:603 |
| 3 | JApplicationSite->initialiseApp() | JROOT/libraries/cms/application/site.php:209 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Query Time: 0.46 ms After last query: 0.18 ms Query memory: 0.005 MB Memory before query: 3.032 MB Rows returned: 91
SELECT `folder` AS `type`,`element` AS `name`,`params`
FROM jos_extensions
WHERE enabled = 1
AND type = 'plugin'
AND state IN (0,1)
AND access IN (1,1,2,3,6)
ORDER BY ordering
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | jos_extensions | ALL | extension | NO INDEX KEY COULD BE USED | NULL | NULL | 245 | 50.61 | Using where; Using filesort |
| Status | Duration |
|---|
| Starting | 0.11 ms |
| Waiting for query cache lock | 0.01 ms |
| starting | 0.01 ms |
| Checking query cache for query | 0.01 ms |
| checking privileges on cached | 0.01 ms |
| checking permissions | 0.06 ms |
| Sending cached result to clien | 0.17 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 9 | JDatabaseDriver->loadObjectList() | JROOT/libraries/cms/plugin/helper.php:311 |
| 8 | JPluginHelper::{closure}() | JROOT/libraries/joomla/cache/controller/callback.php:169 |
| 7 | JCacheControllerCallback->get() | JROOT/libraries/cms/plugin/helper.php:316 |
| 6 | JPluginHelper::load() | JROOT/libraries/cms/plugin/helper.php:86 |
| 5 | JPluginHelper::getPlugin() | JROOT/libraries/cms/plugin/helper.php:128 |
| 4 | JPluginHelper::isEnabled() | JROOT/libraries/cms/application/site.php:603 |
| 3 | JApplicationSite->initialiseApp() | JROOT/libraries/cms/application/site.php:209 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Query Time: 0.48 ms After last query: 25.21 ms Query memory: 0.008 MB Memory before query: 4.169 MB Rows returned: 24
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 | ref | idx_client_id_parent_id_alias_language | idx_client_id_parent_id_alias_language | 1 | const | 51 | 57.95 | Using index condition; Using where; Using filesort |
| 1 | SIMPLE | e | eq_ref | PRIMARY | PRIMARY | 4 | elzenzo_2.m.component_id | 1 | 100.00 | Using where |
| Status | Duration |
|---|
| Starting | 0.20 ms |
| Waiting for query cache lock | 0.01 ms |
| starting | 0.01 ms |
| Checking query cache for query | 0.02 ms |
| checking privileges on cached | 0.01 ms |
| checking permissions | 0.02 ms |
| Sending cached result to clien | 0.12 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 17 | JDatabaseDriver->loadObjectList() | JROOT/libraries/cms/menu/site.php:88 |
| 16 | JMenuSite->{closure}() | JROOT/libraries/joomla/cache/controller/callback.php:169 |
| 15 | JCacheControllerCallback->get() | JROOT/libraries/cms/menu/site.php:96 |
| 14 | JMenuSite->load() | JROOT/libraries/cms/menu/menu.php:74 |
| 13 | JMenu->__construct() | JROOT/libraries/cms/menu/site.php:57 |
| 12 | JMenuSite->__construct() | JROOT/libraries/cms/menu/menu.php:129 |
| 11 | JMenu::getInstance() | JROOT/libraries/cms/application/cms.php:443 |
| 10 | JApplicationCms->getMenu() | JROOT/libraries/cms/application/site.php:272 |
| 9 | JApplicationSite->getMenu() | JROOT/libraries/cms/router/site.php:59 |
| 8 | JRouterSite->__construct() | JROOT/libraries/cms/router/router.php:198 |
| 7 | JRouter::getInstance() | JROOT/libraries/cms/application/cms.php:548 |
| 6 | JApplicationCms::getRouter() | JROOT/libraries/cms/application/site.php:402 |
| 5 | JApplicationSite::getRouter() | JROOT/libraries/cms/application/cms.php:1141 |
| 4 | JApplicationCms->route() | JROOT/libraries/cms/application/site.php:795 |
| 3 | JApplicationSite->route() | JROOT/libraries/cms/application/site.php:215 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Query Time: 0.37 ms After last query: 9.78 ms Query memory: 0.006 MB Memory before query: 4.640 MB Rows returned: 1
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.16 ms |
| Waiting for query cache lock | 0.01 ms |
| starting | 0.01 ms |
| Checking query cache for query | 0.01 ms |
| checking privileges on cached | 0.01 ms |
| checking permissions | 0.05 ms |
| Sending cached result to clien | 0.10 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1642 |
| 13 | JDatabaseDriver->loadObject() | JROOT/libraries/cms/library/helper.php:166 |
| 12 | JLibraryHelper::{closure}() | JROOT/libraries/joomla/cache/controller/callback.php:169 |
| 11 | JCacheControllerCallback->get() | JROOT/libraries/cms/library/helper.php:174 |
| 10 | JLibraryHelper::loadLibrary() | JROOT/libraries/cms/library/helper.php:42 |
| 9 | JLibraryHelper::getLibrary() | JROOT/libraries/cms/library/helper.php:89 |
| 8 | JLibraryHelper::getParams() | JROOT/libraries/cms/version/version.php:270 |
| 7 | JVersion->getMediaVersion() | JROOT/libraries/joomla/factory.php:755 |
| 6 | JFactory::createDocument() | JROOT/libraries/joomla/factory.php:216 |
| 5 | JFactory::getDocument() | JROOT/libraries/joomla/application/web.php:1022 |
| 4 | JApplicationWeb->loadDocument() | JROOT/libraries/cms/application/site.php:130 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Query Time: 4.38 ms After last query: 0.25 ms Query memory: 0.005 MB Memory before query: 4.632 MB
UPDATE `jos_extensions`
SET `params` = '{\"mediaversion\":\"2dfb468b9dd89d073e20a89044d5896f\"}'
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 | NULL | 1 | 100.00 | Using where |
| Status | Duration |
|---|
| Starting | 0.19 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.04 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| table lock | 0.01 ms |
| init for update | 0.16 ms |
| Updating | 0.13 ms |
| End of update loop | 0.01 ms |
| Waiting for query cache lock | 0.01 ms |
| End of update loop | 0.08 ms |
| Query end | 0.01 ms |
| Commit | 3.38 ms |
| Query end | 0.03 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.02 ms |
| Query end | 0.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.11 ms |
| Updating status | 0.03 ms |
| Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/cms/library/helper.php:116 |
| 9 | JLibraryHelper::saveParams() | JROOT/libraries/cms/version/version.php:321 |
| 8 | JVersion->setMediaVersion() | JROOT/libraries/cms/version/version.php:280 |
| 7 | JVersion->getMediaVersion() | JROOT/libraries/joomla/factory.php:755 |
| 6 | JFactory::createDocument() | JROOT/libraries/joomla/factory.php:216 |
| 5 | JFactory::getDocument() | JROOT/libraries/joomla/application/web.php:1022 |
| 4 | JApplicationWeb->loadDocument() | JROOT/libraries/cms/application/site.php:130 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Query Time: 0.29 ms After last query: 3.56 ms Query memory: 0.003 MB Memory before query: 4.857 MB Rows returned: 1
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 | 2 | 100.00 | Using where; Using filesort |
| Status | Duration |
|---|
| Starting | 0.13 ms |
| Waiting for query cache lock | 0.01 ms |
| starting | 0.01 ms |
| Checking query cache for query | 0.01 ms |
| checking privileges on cached | 0.01 ms |
| checking permissions | 0.01 ms |
| Sending cached result to clien | 0.07 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 7 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 6 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/language/helper.php:148 |
| 5 | JLanguageHelper::getLanguages() | JROOT/libraries/cms/application/site.php:327 |
| 4 | JApplicationSite->getParams() | JROOT/libraries/cms/application/site.php:135 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Query Time: 1.14 ms After last query: 0.31 ms Query memory: 0.003 MB Memory before query: 4.871 MB Rows returned: 3
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 | ref | idx_template,idx_client_id,idx_client_id_home | idx_client_id | 1 | const | 3 | 100.00 | |
| 1 | SIMPLE | e | ref | element_clientid,element_folder_clientid,extension | element_clientid | 403 | elzenzo_2.s.template,const | 1 | 2.45 | Using index condition; Using where |
| Status | Duration |
|---|
| Starting | 0.10 ms |
| Waiting for query cache lock | 0.01 ms |
| starting | 0.01 ms |
| Checking query cache for query | 0.10 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.04 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| table lock | 0.01 ms |
| Waiting for query cache lock | 0.04 ms |
| init | 0.06 ms |
| Optimizing | 0.05 ms |
| Statistics | 0.14 ms |
| Preparing | 0.06 ms |
| Executing | 0.01 ms |
| Sending data | 0.12 ms |
| End of update loop | 0.01 ms |
| Query end | 0.01 ms |
| Commit | 0.01 ms |
| Query end | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.02 ms |
| Query end | 0.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.08 ms |
| Updating status | 0.01 ms |
| Waiting for query cache lock | 0.01 ms |
| Updating status | 0.02 ms |
| Waiting for query cache lock | 0.01 ms |
| Updating status | 0.01 ms |
| Storing result in query cache | 0.01 ms |
| Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 6 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 5 | JDatabaseDriver->loadObjectList() | JROOT/libraries/cms/application/site.php:485 |
| 4 | JApplicationSite->getTemplate() | JROOT/libraries/cms/application/site.php:165 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Query Time: 0.35 ms After last query: 12.38 ms Query memory: 0.010 MB Memory before query: 5.431 MB Rows returned: 37
SELECT `id`,`name`,`rules`,`parent_id`
FROM `jos_assets`
WHERE `name` IN ('com_actionlogs','com_admin','com_ajax','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_installer','com_jce','com_jckman','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_tags','com_templates','com_users','com_weblinks','com_wrapper') OR `parent_id` = 0
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | jos_assets | index_merge | idx_asset_name,idx_parent_id | idx_asset_name,idx_parent_id | 202,4 | NULL | 38 | 100.00 | Using sort_union(idx_asset_name,idx_parent_id); Using where |
| Status | Duration |
|---|
| Starting | 0.15 ms |
| Waiting for query cache lock | 0.01 ms |
| starting | 0.01 ms |
| Checking query cache for query | 0.02 ms |
| checking privileges on cached | 0.01 ms |
| checking permissions | 0.01 ms |
| Sending cached result to clien | 0.08 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 21 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 20 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/access/access.php:427 |
| 19 | JAccess::preloadComponents() | JROOT/libraries/joomla/access/access.php:211 |
| 18 | JAccess::preload() | JROOT/libraries/joomla/access/access.php:529 |
| 17 | JAccess::getAssetRules() | JROOT/libraries/joomla/access/access.php:181 |
| 16 | JAccess::check() | JROOT/libraries/joomla/user/user.php:393 |
| 15 | JUser->authorise() | JROOT/components/com_content/models/articles.php:113 |
| 14 | ContentModelArticles->populateState() | JROOT/components/com_content/models/featured.php:42 |
| 13 | ContentModelFeatured->populateState() | JROOT/libraries/legacy/model/legacy.php:434 |
| 12 | JModelLegacy->getState() | JROOT/libraries/legacy/view/legacy.php:422 |
| 11 | JViewLegacy->get() | JROOT/components/com_content/views/featured/view.html.php:54 |
| 10 | ContentViewFeatured->display() | JROOT/libraries/legacy/controller/legacy.php:671 |
| 9 | JControllerLegacy->display() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/legacy/controller/legacy.php:709 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_content/content.php:39 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/cms/component/helper.php:394 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:369 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Query Time: 7.49 ms After last query: 2.42 ms Query memory: 0.008 MB Memory before query: 5.619 MB Rows returned: 11
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,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,
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.featured = 1
AND a.access IN (1,1,2,3,6)
AND c.access IN (1,1,2,3,6)
AND c.published = 1
AND a.state IN (0,1,2)
ORDER BY c.lft,
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END DESC , a.created DESC
LIMIT 15, 11
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | a | ref | idx_access,idx_state,idx_catid,idx_featured_catid | idx_featured_catid | 1 | const | 130 | 67.76 | Using where; Using temporary; Using filesort |
| 1 | SIMPLE | c | eq_ref | PRIMARY,idx_access | PRIMARY | 4 | elzenzo_2.a.catid | 1 | 100.00 | Using where |
| 1 | SIMPLE | ua | eq_ref | PRIMARY | PRIMARY | 4 | elzenzo_2.a.created_by | 1 | 100.00 | Using where |
| 1 | SIMPLE | uam | eq_ref | PRIMARY | PRIMARY | 4 | elzenzo_2.a.modified_by | 1 | 100.00 | Using where |
| 1 | SIMPLE | parent | eq_ref | PRIMARY | PRIMARY | 4 | elzenzo_2.c.parent_id | 1 | 100.00 | Using where |
| 1 | SIMPLE | v | eq_ref | PRIMARY | PRIMARY | 4 | elzenzo_2.a.id | 1 | 100.00 | Using where |
| Status | Duration |
|---|
| Starting | 0.09 ms |
| Waiting for query cache lock | 0.01 ms |
| starting | 0.01 ms |
| Checking query cache for query | 0.34 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.09 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| table lock | 0.01 ms |
| Waiting for query cache lock | 0.05 ms |
| init | 0.18 ms |
| Optimizing | 0.07 ms |
| Statistics | 0.22 ms |
| Preparing | 0.06 ms |
| Creating tmp table | 0.12 ms |
| Sorting result | 0.02 ms |
| Executing | 0.01 ms |
| Sending data | 4.00 ms |
| Creating sort index | 0.80 ms |
| Waiting for query cache lock | 0.02 ms |
| Creating sort index | 0.10 ms |
| Waiting for query cache lock | 0.01 ms |
| Creating sort index | 0.08 ms |
| Waiting for query cache lock | 0.01 ms |
| Creating sort index | 0.05 ms |
| Waiting for query cache lock | 0.01 ms |
| Creating sort index | 0.10 ms |
| Waiting for query cache lock | 0.01 ms |
| Creating sort index | 0.03 ms |
| Waiting for query cache lock | 0.01 ms |
| Creating sort index | 0.08 ms |
| Waiting for query cache lock | 0.02 ms |
| Creating sort index | 0.23 ms |
| Waiting for query cache lock | 0.02 ms |
| Creating sort index | 0.04 ms |
| Removing tmp table | 0.12 ms |
| Creating sort index | 0.03 ms |
| End of update loop | 0.02 ms |
| Query end | 0.01 ms |
| Commit | 0.01 ms |
| Query end | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.03 ms |
| Query end | 0.02 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.15 ms |
| Updating status | 0.01 ms |
| Waiting for query cache lock | 0.01 ms |
| Updating status | 0.03 ms |
| Waiting for query cache lock | 0.01 ms |
| Updating status | 0.01 ms |
| Storing result in query cache | 0.02 ms |
| Reset for next command | 0.02 ms |
| # | Caller | File and line number |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 16 | JDatabaseDriver->loadObjectList() | JROOT/libraries/legacy/model/legacy.php:307 |
| 15 | JModelLegacy->_getList() | JROOT/libraries/legacy/model/list.php:186 |
| 14 | JModelList->getItems() | JROOT/components/com_content/models/articles.php:536 |
| 13 | ContentModelArticles->getItems() | JROOT/components/com_content/models/featured.php:100 |
| 12 | ContentModelFeatured->getItems() | JROOT/libraries/legacy/view/legacy.php:422 |
| 11 | JViewLegacy->get() | JROOT/components/com_content/views/featured/view.html.php:55 |
| 10 | ContentViewFeatured->display() | JROOT/libraries/legacy/controller/legacy.php:671 |
| 9 | JControllerLegacy->display() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/legacy/controller/legacy.php:709 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_content/content.php:39 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/cms/component/helper.php:394 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:369 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Query Time: 0.44 ms After last query: 10.29 ms Query memory: 0.007 MB Memory before query: 6.051 MB Rows returned: 0
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` = 1500
AND `t`.`published` = 1
AND t.access IN (1,1,2,3,6)
| 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 | 22 | 100.00 | Using where |
| 1 | SIMPLE | t | eq_ref | PRIMARY,tag_idx,idx_access | PRIMARY | 4 | elzenzo_2.m.tag_id | 1 | 100.00 | Using where |
| Status | Duration |
|---|
| Starting | 0.19 ms |
| Waiting for query cache lock | 0.01 ms |
| starting | 0.01 ms |
| Checking query cache for query | 0.01 ms |
| checking privileges on cached | 0.01 ms |
| checking permissions | 0.02 ms |
| Sending cached result to clien | 0.14 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 15 | JDatabaseDriver->loadObjectList() | JROOT/libraries/cms/helper/tags.php:450 |
| 14 | JHelperTags->getItemTags() | JROOT/components/com_content/models/articles.php:662 |
| 13 | ContentModelArticles->getItems() | JROOT/components/com_content/models/featured.php:100 |
| 12 | ContentModelFeatured->getItems() | JROOT/libraries/legacy/view/legacy.php:422 |
| 11 | JViewLegacy->get() | JROOT/components/com_content/views/featured/view.html.php:55 |
| 10 | ContentViewFeatured->display() | JROOT/libraries/legacy/controller/legacy.php:671 |
| 9 | JControllerLegacy->display() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/legacy/controller/legacy.php:709 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_content/content.php:39 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/cms/component/helper.php:394 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:369 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Query Time: 2.11 ms After last query: 0.35 ms Query memory: 0.007 MB Memory before query: 6.073 MB Rows returned: 0
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` = 1499
AND `t`.`published` = 1
AND t.access IN (1,1,2,3,6)
| 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 | 22 | 100.00 | Using where |
| 1 | SIMPLE | t | eq_ref | PRIMARY,tag_idx,idx_access | PRIMARY | 4 | elzenzo_2.m.tag_id | 1 | 100.00 | Using where |
| Status | Duration |
|---|
| Starting | 0.27 ms |
| Waiting for query cache lock | 0.02 ms |
| starting | 0.01 ms |
| Checking query cache for query | 0.12 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.06 ms |
| After opening tables | 0.02 ms |
| System lock | 0.02 ms |
| table lock | 0.01 ms |
| Waiting for query cache lock | 0.04 ms |
| init | 0.10 ms |
| Optimizing | 0.07 ms |
| Statistics | 0.16 ms |
| Preparing | 0.06 ms |
| Executing | 0.01 ms |
| Sending data | 0.09 ms |
| End of update loop | 0.01 ms |
| Query end | 0.01 ms |
| Commit | 0.01 ms |
| Query end | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.01 ms |
| Query end | 0.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.20 ms |
| Updating status | 0.02 ms |
| Waiting for query cache lock | 0.01 ms |
| Updating status | 0.03 ms |
| Waiting for query cache lock | 0.01 ms |
| Updating status | 0.01 ms |
| Storing result in query cache | 0.02 ms |
| Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 15 | JDatabaseDriver->loadObjectList() | JROOT/libraries/cms/helper/tags.php:450 |
| 14 | JHelperTags->getItemTags() | JROOT/components/com_content/models/articles.php:662 |
| 13 | ContentModelArticles->getItems() | JROOT/components/com_content/models/featured.php:100 |
| 12 | ContentModelFeatured->getItems() | JROOT/libraries/legacy/view/legacy.php:422 |
| 11 | JViewLegacy->get() | JROOT/components/com_content/views/featured/view.html.php:55 |
| 10 | ContentViewFeatured->display() | JROOT/libraries/legacy/controller/legacy.php:671 |
| 9 | JControllerLegacy->display() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/legacy/controller/legacy.php:709 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_content/content.php:39 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/cms/component/helper.php:394 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:369 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Query Time: 1.04 ms After last query: 0.43 ms Query memory: 0.007 MB Memory before query: 6.095 MB Rows returned: 0
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` = 1580
AND `t`.`published` = 1
AND t.access IN (1,1,2,3,6)
| 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 | 22 | 100.00 | Using where |
| 1 | SIMPLE | t | eq_ref | PRIMARY,tag_idx,idx_access | PRIMARY | 4 | elzenzo_2.m.tag_id | 1 | 100.00 | Using where |
| Status | Duration |
|---|
| Starting | 0.13 ms |
| Waiting for query cache lock | 0.01 ms |
| starting | 0.01 ms |
| Checking query cache for query | 0.08 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| table lock | 0.01 ms |
| Waiting for query cache lock | 0.02 ms |
| init | 0.06 ms |
| Optimizing | 0.04 ms |
| Statistics | 0.10 ms |
| Preparing | 0.04 ms |
| Executing | 0.01 ms |
| Sending data | 0.06 ms |
| End of update loop | 0.01 ms |
| Query end | 0.04 ms |
| Commit | 0.01 ms |
| Query end | 0.01 ms |
| closing tables | 0.02 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.01 ms |
| Query end | 0.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.11 ms |
| Updating status | 0.02 ms |
| Waiting for query cache lock | 0.01 ms |
| Updating status | 0.02 ms |
| Waiting for query cache lock | 0.01 ms |
| Updating status | 0.01 ms |
| Storing result in query cache | 0.02 ms |
| Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 15 | JDatabaseDriver->loadObjectList() | JROOT/libraries/cms/helper/tags.php:450 |
| 14 | JHelperTags->getItemTags() | JROOT/components/com_content/models/articles.php:662 |
| 13 | ContentModelArticles->getItems() | JROOT/components/com_content/models/featured.php:100 |
| 12 | ContentModelFeatured->getItems() | JROOT/libraries/legacy/view/legacy.php:422 |
| 11 | JViewLegacy->get() | JROOT/components/com_content/views/featured/view.html.php:55 |
| 10 | ContentViewFeatured->display() | JROOT/libraries/legacy/controller/legacy.php:671 |
| 9 | JControllerLegacy->display() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/legacy/controller/legacy.php:709 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_content/content.php:39 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/cms/component/helper.php:394 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:369 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Query Time: 1.00 ms After last query: 0.32 ms Query memory: 0.008 MB Memory before query: 6.119 MB Rows returned: 0
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` = 1403
AND `t`.`published` = 1
AND t.access IN (1,1,2,3,6)
| 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 | 22 | 100.00 | Using where |
| 1 | SIMPLE | t | eq_ref | PRIMARY,tag_idx,idx_access | PRIMARY | 4 | elzenzo_2.m.tag_id | 1 | 100.00 | Using where |
| Status | Duration |
|---|
| Starting | 0.14 ms |
| Waiting for query cache lock | 0.01 ms |
| starting | 0.01 ms |
| Checking query cache for query | 0.07 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.01 ms |
| System lock | 0.06 ms |
| table lock | 0.01 ms |
| Waiting for query cache lock | 0.02 ms |
| init | 0.05 ms |
| Optimizing | 0.04 ms |
| Statistics | 0.10 ms |
| Preparing | 0.04 ms |
| Executing | 0.01 ms |
| Sending data | 0.06 ms |
| End of update loop | 0.01 ms |
| Query end | 0.01 ms |
| Commit | 0.01 ms |
| Query end | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.01 ms |
| Query end | 0.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.10 ms |
| Updating status | 0.01 ms |
| Waiting for query cache lock | 0.01 ms |
| Updating status | 0.02 ms |
| Waiting for query cache lock | 0.01 ms |
| Updating status | 0.01 ms |
| Storing result in query cache | 0.01 ms |
| Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 15 | JDatabaseDriver->loadObjectList() | JROOT/libraries/cms/helper/tags.php:450 |
| 14 | JHelperTags->getItemTags() | JROOT/components/com_content/models/articles.php:662 |
| 13 | ContentModelArticles->getItems() | JROOT/components/com_content/models/featured.php:100 |
| 12 | ContentModelFeatured->getItems() | JROOT/libraries/legacy/view/legacy.php:422 |
| 11 | JViewLegacy->get() | JROOT/components/com_content/views/featured/view.html.php:55 |
| 10 | ContentViewFeatured->display() | JROOT/libraries/legacy/controller/legacy.php:671 |
| 9 | JControllerLegacy->display() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/legacy/controller/legacy.php:709 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_content/content.php:39 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/cms/component/helper.php:394 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:369 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Query Time: 0.92 ms After last query: 0.31 ms Query memory: 0.007 MB Memory before query: 6.141 MB Rows returned: 0
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` = 1503
AND `t`.`published` = 1
AND t.access IN (1,1,2,3,6)
| 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 | 22 | 100.00 | Using where |
| 1 | SIMPLE | t | eq_ref | PRIMARY,tag_idx,idx_access | PRIMARY | 4 | elzenzo_2.m.tag_id | 1 | 100.00 | Using where |
| Status | Duration |
|---|
| Starting | 0.11 ms |
| Waiting for query cache lock | 0.01 ms |
| starting | 0.01 ms |
| Checking query cache for query | 0.07 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| table lock | 0.01 ms |
| Waiting for query cache lock | 0.02 ms |
| init | 0.05 ms |
| Optimizing | 0.04 ms |
| Statistics | 0.10 ms |
| Preparing | 0.03 ms |
| Executing | 0.01 ms |
| Sending data | 0.06 ms |
| End of update loop | 0.01 ms |
| Query end | 0.01 ms |
| Commit | 0.01 ms |
| Query end | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.01 ms |
| Query end | 0.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.10 ms |
| Updating status | 0.01 ms |
| Waiting for query cache lock | 0.01 ms |
| Updating status | 0.02 ms |
| Waiting for query cache lock | 0.01 ms |
| Updating status | 0.01 ms |
| Storing result in query cache | 0.02 ms |
| Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 15 | JDatabaseDriver->loadObjectList() | JROOT/libraries/cms/helper/tags.php:450 |
| 14 | JHelperTags->getItemTags() | JROOT/components/com_content/models/articles.php:662 |
| 13 | ContentModelArticles->getItems() | JROOT/components/com_content/models/featured.php:100 |
| 12 | ContentModelFeatured->getItems() | JROOT/libraries/legacy/view/legacy.php:422 |
| 11 | JViewLegacy->get() | JROOT/components/com_content/views/featured/view.html.php:55 |
| 10 | ContentViewFeatured->display() | JROOT/libraries/legacy/controller/legacy.php:671 |
| 9 | JControllerLegacy->display() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/legacy/controller/legacy.php:709 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_content/content.php:39 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/cms/component/helper.php:394 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:369 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Query Time: 0.32 ms After last query: 0.38 ms Query memory: 0.007 MB Memory before query: 6.163 MB Rows returned: 0
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` = 1135
AND `t`.`published` = 1
AND t.access IN (1,1,2,3,6)
| 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 | 22 | 100.00 | Using where |
| 1 | SIMPLE | t | eq_ref | PRIMARY,tag_idx,idx_access | PRIMARY | 4 | elzenzo_2.m.tag_id | 1 | 100.00 | Using where |
| Status | Duration |
|---|
| Starting | 0.12 ms |
| Waiting for query cache lock | 0.01 ms |
| starting | 0.01 ms |
| Checking query cache for query | 0.01 ms |
| checking privileges on cached | 0.01 ms |
| checking permissions | 0.01 ms |
| Sending cached result to clien | 0.13 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 15 | JDatabaseDriver->loadObjectList() | JROOT/libraries/cms/helper/tags.php:450 |
| 14 | JHelperTags->getItemTags() | JROOT/components/com_content/models/articles.php:662 |
| 13 | ContentModelArticles->getItems() | JROOT/components/com_content/models/featured.php:100 |
| 12 | ContentModelFeatured->getItems() | JROOT/libraries/legacy/view/legacy.php:422 |
| 11 | JViewLegacy->get() | JROOT/components/com_content/views/featured/view.html.php:55 |
| 10 | ContentViewFeatured->display() | JROOT/libraries/legacy/controller/legacy.php:671 |
| 9 | JControllerLegacy->display() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/legacy/controller/legacy.php:709 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_content/content.php:39 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/cms/component/helper.php:394 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:369 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Query Time: 0.36 ms After last query: 0.31 ms Query memory: 0.007 MB Memory before query: 6.185 MB Rows returned: 0
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` = 1031
AND `t`.`published` = 1
AND t.access IN (1,1,2,3,6)
| 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 | 22 | 100.00 | Using where |
| 1 | SIMPLE | t | eq_ref | PRIMARY,tag_idx,idx_access | PRIMARY | 4 | elzenzo_2.m.tag_id | 1 | 100.00 | Using where |
| Status | Duration |
|---|
| Starting | 0.16 ms |
| Waiting for query cache lock | 0.01 ms |
| starting | 0.01 ms |
| Checking query cache for query | 0.01 ms |
| checking privileges on cached | 0.01 ms |
| checking permissions | 0.01 ms |
| Sending cached result to clien | 0.13 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 15 | JDatabaseDriver->loadObjectList() | JROOT/libraries/cms/helper/tags.php:450 |
| 14 | JHelperTags->getItemTags() | JROOT/components/com_content/models/articles.php:662 |
| 13 | ContentModelArticles->getItems() | JROOT/components/com_content/models/featured.php:100 |
| 12 | ContentModelFeatured->getItems() | JROOT/libraries/legacy/view/legacy.php:422 |
| 11 | JViewLegacy->get() | JROOT/components/com_content/views/featured/view.html.php:55 |
| 10 | ContentViewFeatured->display() | JROOT/libraries/legacy/controller/legacy.php:671 |
| 9 | JControllerLegacy->display() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/legacy/controller/legacy.php:709 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_content/content.php:39 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/cms/component/helper.php:394 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:369 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Query Time: 1.00 ms After last query: 0.33 ms Query memory: 0.007 MB Memory before query: 6.207 MB Rows returned: 0
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` = 585
AND `t`.`published` = 1
AND t.access IN (1,1,2,3,6)
| 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 | 22 | 100.00 | Using where |
| 1 | SIMPLE | t | eq_ref | PRIMARY,tag_idx,idx_access | PRIMARY | 4 | elzenzo_2.m.tag_id | 1 | 100.00 | Using where |
| Status | Duration |
|---|
| Starting | 0.16 ms |
| Waiting for query cache lock | 0.01 ms |
| starting | 0.01 ms |
| Checking query cache for query | 0.07 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| table lock | 0.01 ms |
| Waiting for query cache lock | 0.02 ms |
| init | 0.08 ms |
| Optimizing | 0.04 ms |
| Statistics | 0.10 ms |
| Preparing | 0.03 ms |
| Executing | 0.01 ms |
| Sending data | 0.06 ms |
| End of update loop | 0.01 ms |
| Query end | 0.01 ms |
| Commit | 0.01 ms |
| Query end | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.01 ms |
| Query end | 0.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.10 ms |
| Updating status | 0.01 ms |
| Waiting for query cache lock | 0.01 ms |
| Updating status | 0.02 ms |
| Waiting for query cache lock | 0.01 ms |
| Updating status | 0.01 ms |
| Storing result in query cache | 0.02 ms |
| Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 15 | JDatabaseDriver->loadObjectList() | JROOT/libraries/cms/helper/tags.php:450 |
| 14 | JHelperTags->getItemTags() | JROOT/components/com_content/models/articles.php:662 |
| 13 | ContentModelArticles->getItems() | JROOT/components/com_content/models/featured.php:100 |
| 12 | ContentModelFeatured->getItems() | JROOT/libraries/legacy/view/legacy.php:422 |
| 11 | JViewLegacy->get() | JROOT/components/com_content/views/featured/view.html.php:55 |
| 10 | ContentViewFeatured->display() | JROOT/libraries/legacy/controller/legacy.php:671 |
| 9 | JControllerLegacy->display() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/legacy/controller/legacy.php:709 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_content/content.php:39 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/cms/component/helper.php:394 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:369 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Query Time: 0.92 ms After last query: 0.31 ms Query memory: 0.007 MB Memory before query: 6.229 MB Rows returned: 0
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` = 1339
AND `t`.`published` = 1
AND t.access IN (1,1,2,3,6)
| 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 | 22 | 100.00 | Using where |
| 1 | SIMPLE | t | eq_ref | PRIMARY,tag_idx,idx_access | PRIMARY | 4 | elzenzo_2.m.tag_id | 1 | 100.00 | Using where |
| Status | Duration |
|---|
| Starting | 0.13 ms |
| Waiting for query cache lock | 0.01 ms |
| starting | 0.01 ms |
| Checking query cache for query | 0.07 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| table lock | 0.01 ms |
| Waiting for query cache lock | 0.02 ms |
| init | 0.05 ms |
| Optimizing | 0.04 ms |
| Statistics | 0.10 ms |
| Preparing | 0.03 ms |
| Executing | 0.01 ms |
| Sending data | 0.06 ms |
| End of update loop | 0.01 ms |
| Query end | 0.01 ms |
| Commit | 0.01 ms |
| Query end | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.01 ms |
| Query end | 0.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.10 ms |
| Updating status | 0.01 ms |
| Waiting for query cache lock | 0.01 ms |
| Updating status | 0.02 ms |
| Waiting for query cache lock | 0.01 ms |
| Updating status | 0.01 ms |
| Storing result in query cache | 0.01 ms |
| Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 15 | JDatabaseDriver->loadObjectList() | JROOT/libraries/cms/helper/tags.php:450 |
| 14 | JHelperTags->getItemTags() | JROOT/components/com_content/models/articles.php:662 |
| 13 | ContentModelArticles->getItems() | JROOT/components/com_content/models/featured.php:100 |
| 12 | ContentModelFeatured->getItems() | JROOT/libraries/legacy/view/legacy.php:422 |
| 11 | JViewLegacy->get() | JROOT/components/com_content/views/featured/view.html.php:55 |
| 10 | ContentViewFeatured->display() | JROOT/libraries/legacy/controller/legacy.php:671 |
| 9 | JControllerLegacy->display() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/legacy/controller/legacy.php:709 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_content/content.php:39 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/cms/component/helper.php:394 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:369 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Query Time: 0.89 ms After last query: 0.35 ms Query memory: 0.007 MB Memory before query: 6.251 MB Rows returned: 0
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` = 1136
AND `t`.`published` = 1
AND t.access IN (1,1,2,3,6)
| 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 | 22 | 100.00 | Using where |
| 1 | SIMPLE | t | eq_ref | PRIMARY,tag_idx,idx_access | PRIMARY | 4 | elzenzo_2.m.tag_id | 1 | 100.00 | Using where |
| Status | Duration |
|---|
| Starting | 0.11 ms |
| Waiting for query cache lock | 0.01 ms |
| starting | 0.01 ms |
| Checking query cache for query | 0.07 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| table lock | 0.01 ms |
| Waiting for query cache lock | 0.02 ms |
| init | 0.05 ms |
| Optimizing | 0.04 ms |
| Statistics | 0.10 ms |
| Preparing | 0.03 ms |
| Executing | 0.01 ms |
| Sending data | 0.06 ms |
| End of update loop | 0.01 ms |
| Query end | 0.01 ms |
| Commit | 0.01 ms |
| Query end | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.01 ms |
| Query end | 0.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.10 ms |
| Updating status | 0.01 ms |
| Waiting for query cache lock | 0.01 ms |
| Updating status | 0.03 ms |
| Waiting for query cache lock | 0.01 ms |
| Updating status | 0.01 ms |
| Storing result in query cache | 0.02 ms |
| Reset for next command | 0.03 ms |
| # | Caller | File and line number |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 15 | JDatabaseDriver->loadObjectList() | JROOT/libraries/cms/helper/tags.php:450 |
| 14 | JHelperTags->getItemTags() | JROOT/components/com_content/models/articles.php:662 |
| 13 | ContentModelArticles->getItems() | JROOT/components/com_content/models/featured.php:100 |
| 12 | ContentModelFeatured->getItems() | JROOT/libraries/legacy/view/legacy.php:422 |
| 11 | JViewLegacy->get() | JROOT/components/com_content/views/featured/view.html.php:55 |
| 10 | ContentViewFeatured->display() | JROOT/libraries/legacy/controller/legacy.php:671 |
| 9 | JControllerLegacy->display() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/legacy/controller/legacy.php:709 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_content/content.php:39 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/cms/component/helper.php:394 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:369 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Query Time: 0.37 ms After last query: 0.33 ms Query memory: 0.007 MB Memory before query: 6.273 MB Rows returned: 0
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` = 1907
AND `t`.`published` = 1
AND t.access IN (1,1,2,3,6)
| 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 | 22 | 100.00 | Using where |
| 1 | SIMPLE | t | eq_ref | PRIMARY,tag_idx,idx_access | PRIMARY | 4 | elzenzo_2.m.tag_id | 1 | 100.00 | Using where |
| Status | Duration |
|---|
| Starting | 0.12 ms |
| Waiting for query cache lock | 0.01 ms |
| starting | 0.01 ms |
| Checking query cache for query | 0.01 ms |
| checking privileges on cached | 0.01 ms |
| checking permissions | 0.01 ms |
| Sending cached result to clien | 0.16 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 15 | JDatabaseDriver->loadObjectList() | JROOT/libraries/cms/helper/tags.php:450 |
| 14 | JHelperTags->getItemTags() | JROOT/components/com_content/models/articles.php:662 |
| 13 | ContentModelArticles->getItems() | JROOT/components/com_content/models/featured.php:100 |
| 12 | ContentModelFeatured->getItems() | JROOT/libraries/legacy/view/legacy.php:422 |
| 11 | JViewLegacy->get() | JROOT/components/com_content/views/featured/view.html.php:55 |
| 10 | ContentViewFeatured->display() | JROOT/libraries/legacy/controller/legacy.php:671 |
| 9 | JControllerLegacy->display() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/legacy/controller/legacy.php:709 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_content/content.php:39 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/cms/component/helper.php:394 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:369 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Query Time: 1.90 ms After last query: 1.93 ms Query memory: 0.007 MB Memory before query: 6.340 MB Rows returned: 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
WHERE a.featured = 1
AND a.access IN (1,1,2,3,6)
AND c.access IN (1,1,2,3,6)
AND c.published = 1
AND a.state IN (0,1,2)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | a | ref | idx_access,idx_state,idx_catid,idx_featured_catid | idx_featured_catid | 1 | const | 130 | 67.76 | Using where |
| 1 | SIMPLE | c | eq_ref | PRIMARY,idx_access | PRIMARY | 4 | elzenzo_2.a.catid | 1 | 100.00 | Using where |
| Status | Duration |
|---|
| Starting | 0.12 ms |
| Waiting for query cache lock | 0.01 ms |
| starting | 0.01 ms |
| Checking query cache for query | 0.12 ms |
| checking permissions | 0.04 ms |
| Opening tables | 0.09 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| table lock | 0.01 ms |
| Waiting for query cache lock | 0.03 ms |
| init | 0.05 ms |
| Optimizing | 0.05 ms |
| Statistics | 0.20 ms |
| Preparing | 0.01 ms |
| Unlocking tables | 0.01 ms |
| Preparing | 0.04 ms |
| Executing | 0.01 ms |
| Sending data | 0.76 ms |
| End of update loop | 0.02 ms |
| Query end | 0.01 ms |
| Commit | 0.01 ms |
| Query end | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.02 ms |
| Query end | 0.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.11 ms |
| Updating status | 0.01 ms |
| Waiting for query cache lock | 0.01 ms |
| Updating status | 0.02 ms |
| Waiting for query cache lock | 0.01 ms |
| Updating status | 0.01 ms |
| Storing result in query cache | 0.02 ms |
| Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1720 |
| 15 | JDatabaseDriver->loadResult() | JROOT/libraries/legacy/model/legacy.php:334 |
| 14 | JModelLegacy->_getListCount() | JROOT/libraries/legacy/model/list.php:281 |
| 13 | JModelList->getTotal() | JROOT/libraries/legacy/model/list.php:231 |
| 12 | JModelList->getPagination() | JROOT/libraries/legacy/view/legacy.php:422 |
| 11 | JViewLegacy->get() | JROOT/components/com_content/views/featured/view.html.php:56 |
| 10 | ContentViewFeatured->display() | JROOT/libraries/legacy/controller/legacy.php:671 |
| 9 | JControllerLegacy->display() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/legacy/controller/legacy.php:709 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_content/content.php:39 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/cms/component/helper.php:394 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:369 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Query Time: 1.00 ms After last query: 9.87 ms Query memory: 0.010 MB Memory before query: 6.780 MB Rows returned: 3
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM jos_categories as c
LEFT JOIN jos_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1,2,3,6)
AND c.published = 1
AND s.id=17
GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version
ORDER BY c.lft
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | s | const | PRIMARY,idx_left_right | PRIMARY | 4 | const | 1 | 100.00 | |
| 1 | SIMPLE | c | ALL | cat_idx,idx_access,idx_left_right | NO INDEX KEY COULD BE USED | NULL | NULL | 51 | 90.20 | Using where; Using filesort |
| Status | Duration |
|---|
| Starting | 0.14 ms |
| Waiting for query cache lock | 0.01 ms |
| starting | 0.01 ms |
| Checking query cache for query | 0.02 ms |
| checking privileges on cached | 0.01 ms |
| checking permissions | 0.01 ms |
| Sending cached result to clien | 0.51 ms |
| Updating status | 0.03 ms |
| Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 21 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 20 | JDatabaseDriver->loadObjectList() | JROOT/libraries/legacy/categories/categories.php:301 |
| 19 | JCategories->_load() | JROOT/libraries/legacy/categories/categories.php:182 |
| 18 | JCategories->get() | JROOT/administrator/components/com_fields/models/fields.php:197 |
| 17 | FieldsModelFields->getListQuery() | JROOT/libraries/legacy/model/list.php:132 |
| 16 | JModelList->_getListQuery() | JROOT/libraries/legacy/model/list.php:186 |
| 15 | JModelList->getItems() | JROOT/administrator/components/com_fields/helpers/fields.php:134 |
| 14 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:378 |
| 13 | PlgSystemFields->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 |
| 12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/featured/view.html.php:98 |
| 10 | ContentViewFeatured->display() | JROOT/libraries/legacy/controller/legacy.php:671 |
| 9 | JControllerLegacy->display() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/legacy/controller/legacy.php:709 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_content/content.php:39 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/cms/component/helper.php:394 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:369 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Query Time: 0.31 ms After last query: 0.67 ms Query memory: 0.009 MB Memory before query: 7.057 MB Rows returned: 0
SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state
FROM 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 (17,0,12))
AND a.access IN (1,1,2,3,6)
AND (a.group_id = 0 OR g.access IN (1,1,2,3,6))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
GROUP BY a.id, l.title, l.image, uc.name, ag.title, ua.name, g.title, g.access, g.state
ORDER BY a.ordering
| 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 | elzenzo_2.a.language | 1 | 100.00 | Using where |
| 1 | SIMPLE | uc | eq_ref | PRIMARY | PRIMARY | 4 | elzenzo_2.a.checked_out | 1 | 100.00 | |
| 1 | SIMPLE | ag | eq_ref | PRIMARY | PRIMARY | 4 | elzenzo_2.a.access | 1 | 100.00 | Using where |
| 1 | SIMPLE | ua | eq_ref | PRIMARY | PRIMARY | 4 | elzenzo_2.a.created_user_id | 1 | 100.00 | Using where |
| 1 | SIMPLE | g | eq_ref | PRIMARY | PRIMARY | 4 | elzenzo_2.a.group_id | 1 | 100.00 | Using where |
| 1 | SIMPLE | fc | ref | PRIMARY | PRIMARY | 4 | elzenzo_2.a.id | 1 | 100.00 | Using where; Using index |
| Status | Duration |
|---|
| Starting | 0.12 ms |
| Waiting for query cache lock | 0.01 ms |
| starting | 0.01 ms |
| Checking query cache for query | 0.02 ms |
| checking privileges on cached | 0.01 ms |
| checking permissions | 0.02 ms |
| Sending cached result to clien | 0.11 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 18 | JDatabaseDriver->loadObjectList() | JROOT/libraries/legacy/model/legacy.php:307 |
| 17 | JModelLegacy->_getList() | JROOT/administrator/components/com_fields/models/fields.php:333 |
| 16 | FieldsModelFields->_getList() | JROOT/libraries/legacy/model/list.php:186 |
| 15 | JModelList->getItems() | JROOT/administrator/components/com_fields/helpers/fields.php:134 |
| 14 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:378 |
| 13 | PlgSystemFields->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 |
| 12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/featured/view.html.php:98 |
| 10 | ContentViewFeatured->display() | JROOT/libraries/legacy/controller/legacy.php:671 |
| 9 | JControllerLegacy->display() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/legacy/controller/legacy.php:709 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_content/content.php:39 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/cms/component/helper.php:394 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:369 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Query Time: 0.61 ms After last query: 6.12 ms Query memory: 0.010 MB Memory before query: 7.389 MB Rows returned: 3
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM jos_categories as c
LEFT JOIN jos_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1,2,3,6)
AND c.published = 1
AND s.id=18
GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version
ORDER BY c.lft
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | s | const | PRIMARY,idx_left_right | PRIMARY | 4 | const | 1 | 100.00 | |
| 1 | SIMPLE | c | ALL | cat_idx,idx_access,idx_left_right | NO INDEX KEY COULD BE USED | NULL | NULL | 51 | 90.20 | Using where; Using filesort |
| Status | Duration |
|---|
| Starting | 0.12 ms |
| Waiting for query cache lock | 0.01 ms |
| starting | 0.01 ms |
| Checking query cache for query | 0.02 ms |
| checking privileges on cached | 0.01 ms |
| checking permissions | 0.01 ms |
| Sending cached result to clien | 0.42 ms |
| Updating status | 0.03 ms |
| Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 21 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 20 | JDatabaseDriver->loadObjectList() | JROOT/libraries/legacy/categories/categories.php:301 |
| 19 | JCategories->_load() | JROOT/libraries/legacy/categories/categories.php:182 |
| 18 | JCategories->get() | JROOT/administrator/components/com_fields/models/fields.php:197 |
| 17 | FieldsModelFields->getListQuery() | JROOT/libraries/legacy/model/list.php:132 |
| 16 | JModelList->_getListQuery() | JROOT/libraries/legacy/model/list.php:186 |
| 15 | JModelList->getItems() | JROOT/administrator/components/com_fields/helpers/fields.php:134 |
| 14 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:378 |
| 13 | PlgSystemFields->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 |
| 12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/featured/view.html.php:98 |
| 10 | ContentViewFeatured->display() | JROOT/libraries/legacy/controller/legacy.php:671 |
| 9 | JControllerLegacy->display() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/legacy/controller/legacy.php:709 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_content/content.php:39 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/cms/component/helper.php:394 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:369 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Query Time: 0.39 ms After last query: 1.32 ms Query memory: 0.009 MB Memory before query: 7.395 MB Rows returned: 0
SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state
FROM 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 (18,0,12))
AND a.access IN (1,1,2,3,6)
AND (a.group_id = 0 OR g.access IN (1,1,2,3,6))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
GROUP BY a.id, l.title, l.image, uc.name, ag.title, ua.name, g.title, g.access, g.state
ORDER BY a.ordering
| 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 | elzenzo_2.a.language | 1 | 100.00 | Using where |
| 1 | SIMPLE | uc | eq_ref | PRIMARY | PRIMARY | 4 | elzenzo_2.a.checked_out | 1 | 100.00 | |
| 1 | SIMPLE | ag | eq_ref | PRIMARY | PRIMARY | 4 | elzenzo_2.a.access | 1 | 100.00 | Using where |
| 1 | SIMPLE | ua | eq_ref | PRIMARY | PRIMARY | 4 | elzenzo_2.a.created_user_id | 1 | 100.00 | Using where |
| 1 | SIMPLE | g | eq_ref | PRIMARY | PRIMARY | 4 | elzenzo_2.a.group_id | 1 | 100.00 | Using where |
| 1 | SIMPLE | fc | ref | PRIMARY | PRIMARY | 4 | elzenzo_2.a.id | 1 | 100.00 | Using where; Using index |
| Status | Duration |
|---|
| Starting | 0.13 ms |
| Waiting for query cache lock | 0.05 ms |
| starting | 0.01 ms |
| Checking query cache for query | 0.02 ms |
| checking privileges on cached | 0.01 ms |
| checking permissions | 0.02 ms |
| Sending cached result to clien | 0.15 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 18 | JDatabaseDriver->loadObjectList() | JROOT/libraries/legacy/model/legacy.php:307 |
| 17 | JModelLegacy->_getList() | JROOT/administrator/components/com_fields/models/fields.php:333 |
| 16 | FieldsModelFields->_getList() | JROOT/libraries/legacy/model/list.php:186 |
| 15 | JModelList->getItems() | JROOT/administrator/components/com_fields/helpers/fields.php:134 |
| 14 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:378 |
| 13 | PlgSystemFields->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 |
| 12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/featured/view.html.php:98 |
| 10 | ContentViewFeatured->display() | JROOT/libraries/legacy/controller/legacy.php:671 |
| 9 | JControllerLegacy->display() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/legacy/controller/legacy.php:709 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_content/content.php:39 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/cms/component/helper.php:394 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:369 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Query Time: 0.59 ms After last query: 0.80 ms Query memory: 0.010 MB Memory before query: 7.416 MB Rows returned: 3
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM jos_categories as c
LEFT JOIN jos_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1,2,3,6)
AND c.published = 1
AND s.id=44
GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version
ORDER BY c.lft
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | s | const | PRIMARY,idx_left_right | PRIMARY | 4 | const | 1 | 100.00 | |
| 1 | SIMPLE | c | ALL | cat_idx,idx_access,idx_left_right | NO INDEX KEY COULD BE USED | NULL | NULL | 51 | 90.20 | Using where; Using filesort |
| Status | Duration |
|---|
| Starting | 0.11 ms |
| Waiting for query cache lock | 0.01 ms |
| starting | 0.01 ms |
| Checking query cache for query | 0.01 ms |
| checking privileges on cached | 0.01 ms |
| checking permissions | 0.01 ms |
| Sending cached result to clien | 0.41 ms |
| Updating status | 0.03 ms |
| Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 21 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 20 | JDatabaseDriver->loadObjectList() | JROOT/libraries/legacy/categories/categories.php:301 |
| 19 | JCategories->_load() | JROOT/libraries/legacy/categories/categories.php:182 |
| 18 | JCategories->get() | JROOT/administrator/components/com_fields/models/fields.php:197 |
| 17 | FieldsModelFields->getListQuery() | JROOT/libraries/legacy/model/list.php:132 |
| 16 | JModelList->_getListQuery() | JROOT/libraries/legacy/model/list.php:186 |
| 15 | JModelList->getItems() | JROOT/administrator/components/com_fields/helpers/fields.php:134 |
| 14 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:378 |
| 13 | PlgSystemFields->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 |
| 12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/featured/view.html.php:98 |
| 10 | ContentViewFeatured->display() | JROOT/libraries/legacy/controller/legacy.php:671 |
| 9 | JControllerLegacy->display() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/legacy/controller/legacy.php:709 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_content/content.php:39 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/cms/component/helper.php:394 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:369 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Query Time: 0.29 ms After last query: 0.31 ms Query memory: 0.009 MB Memory before query: 7.422 MB Rows returned: 0
SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state
FROM 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 (44,0,12))
AND a.access IN (1,1,2,3,6)
AND (a.group_id = 0 OR g.access IN (1,1,2,3,6))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
GROUP BY a.id, l.title, l.image, uc.name, ag.title, ua.name, g.title, g.access, g.state
ORDER BY a.ordering
| 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 | elzenzo_2.a.language | 1 | 100.00 | Using where |
| 1 | SIMPLE | uc | eq_ref | PRIMARY | PRIMARY | 4 | elzenzo_2.a.checked_out | 1 | 100.00 | |
| 1 | SIMPLE | ag | eq_ref | PRIMARY | PRIMARY | 4 | elzenzo_2.a.access | 1 | 100.00 | Using where |
| 1 | SIMPLE | ua | eq_ref | PRIMARY | PRIMARY | 4 | elzenzo_2.a.created_user_id | 1 | 100.00 | Using where |
| 1 | SIMPLE | g | eq_ref | PRIMARY | PRIMARY | 4 | elzenzo_2.a.group_id | 1 | 100.00 | Using where |
| 1 | SIMPLE | fc | ref | PRIMARY | PRIMARY | 4 | elzenzo_2.a.id | 1 | 100.00 | Using where; Using index |
| Status | Duration |
|---|
| Starting | 0.11 ms |
| Waiting for query cache lock | 0.01 ms |
| starting | 0.01 ms |
| Checking query cache for query | 0.02 ms |
| checking privileges on cached | 0.01 ms |
| checking permissions | 0.02 ms |
| Sending cached result to clien | 0.11 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 18 | JDatabaseDriver->loadObjectList() | JROOT/libraries/legacy/model/legacy.php:307 |
| 17 | JModelLegacy->_getList() | JROOT/administrator/components/com_fields/models/fields.php:333 |
| 16 | FieldsModelFields->_getList() | JROOT/libraries/legacy/model/list.php:186 |
| 15 | JModelList->getItems() | JROOT/administrator/components/com_fields/helpers/fields.php:134 |
| 14 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:378 |
| 13 | PlgSystemFields->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 |
| 12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/featured/view.html.php:98 |
| 10 | ContentViewFeatured->display() | JROOT/libraries/legacy/controller/legacy.php:671 |
| 9 | JControllerLegacy->display() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/legacy/controller/legacy.php:709 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_content/content.php:39 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/cms/component/helper.php:394 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:369 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Query Time: 0.29 ms After last query: 0.56 ms Query memory: 0.010 MB Memory before query: 7.442 MB Rows returned: 10
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 c
LEFT JOIN jos_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1,2,3,6)
AND c.published = 1
AND s.id=20
GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version
ORDER BY c.lft
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | s | const | PRIMARY,idx_left_right | PRIMARY | 4 | const | 1 | 100.00 | |
| 1 | SIMPLE | c | ALL | cat_idx,idx_access,idx_left_right | NO INDEX KEY COULD BE USED | NULL | NULL | 51 | 90.20 | Using where; Using filesort |
| Status | Duration |
|---|
| Starting | 0.10 ms |
| Waiting for query cache lock | 0.01 ms |
| starting | 0.01 ms |
| Checking query cache for query | 0.01 ms |
| checking privileges on cached | 0.01 ms |
| checking permissions | 0.01 ms |
| Sending cached result to clien | 0.11 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 21 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 20 | JDatabaseDriver->loadObjectList() | JROOT/libraries/legacy/categories/categories.php:301 |
| 19 | JCategories->_load() | JROOT/libraries/legacy/categories/categories.php:182 |
| 18 | JCategories->get() | JROOT/administrator/components/com_fields/models/fields.php:197 |
| 17 | FieldsModelFields->getListQuery() | JROOT/libraries/legacy/model/list.php:132 |
| 16 | JModelList->_getListQuery() | JROOT/libraries/legacy/model/list.php:186 |
| 15 | JModelList->getItems() | JROOT/administrator/components/com_fields/helpers/fields.php:134 |
| 14 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:378 |
| 13 | PlgSystemFields->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 |
| 12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/featured/view.html.php:98 |
| 10 | ContentViewFeatured->display() | JROOT/libraries/legacy/controller/legacy.php:671 |
| 9 | JControllerLegacy->display() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/legacy/controller/legacy.php:709 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_content/content.php:39 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/cms/component/helper.php:394 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:369 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Query Time: 0.30 ms After last query: 1.12 ms Query memory: 0.010 MB Memory before query: 7.493 MB Rows returned: 0
SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state
FROM 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 (20,0))
AND a.access IN (1,1,2,3,6)
AND (a.group_id = 0 OR g.access IN (1,1,2,3,6))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
GROUP BY a.id, l.title, l.image, uc.name, ag.title, ua.name, g.title, g.access, g.state
ORDER BY a.ordering
| 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 | elzenzo_2.a.language | 1 | 100.00 | Using where |
| 1 | SIMPLE | uc | eq_ref | PRIMARY | PRIMARY | 4 | elzenzo_2.a.checked_out | 1 | 100.00 | |
| 1 | SIMPLE | ag | eq_ref | PRIMARY | PRIMARY | 4 | elzenzo_2.a.access | 1 | 100.00 | Using where |
| 1 | SIMPLE | ua | eq_ref | PRIMARY | PRIMARY | 4 | elzenzo_2.a.created_user_id | 1 | 100.00 | Using where |
| 1 | SIMPLE | g | eq_ref | PRIMARY | PRIMARY | 4 | elzenzo_2.a.group_id | 1 | 100.00 | Using where |
| 1 | SIMPLE | fc | ref | PRIMARY | PRIMARY | 4 | elzenzo_2.a.id | 1 | 100.00 | Using where; Using index |
| Status | Duration |
|---|
| Starting | 0.10 ms |
| Waiting for query cache lock | 0.03 ms |
| starting | 0.01 ms |
| Checking query cache for query | 0.02 ms |
| checking privileges on cached | 0.01 ms |
| checking permissions | 0.01 ms |
| Sending cached result to clien | 0.11 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 18 | JDatabaseDriver->loadObjectList() | JROOT/libraries/legacy/model/legacy.php:307 |
| 17 | JModelLegacy->_getList() | JROOT/administrator/components/com_fields/models/fields.php:333 |
| 16 | FieldsModelFields->_getList() | JROOT/libraries/legacy/model/list.php:186 |
| 15 | JModelList->getItems() | JROOT/administrator/components/com_fields/helpers/fields.php:134 |
| 14 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:378 |
| 13 | PlgSystemFields->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 |
| 12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/featured/view.html.php:98 |
| 10 | ContentViewFeatured->display() | JROOT/libraries/legacy/controller/legacy.php:671 |
| 9 | JControllerLegacy->display() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/legacy/controller/legacy.php:709 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_content/content.php:39 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/cms/component/helper.php:394 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:369 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Query Time: 0.38 ms After last query: 0.86 ms Query memory: 0.009 MB Memory before query: 7.506 MB Rows returned: 0
SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state
FROM 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 (25,0,21,20))
AND a.access IN (1,1,2,3,6)
AND (a.group_id = 0 OR g.access IN (1,1,2,3,6))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
GROUP BY a.id, l.title, l.image, uc.name, ag.title, ua.name, g.title, g.access, g.state
ORDER BY a.ordering
| 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 | elzenzo_2.a.language | 1 | 100.00 | Using where |
| 1 | SIMPLE | uc | eq_ref | PRIMARY | PRIMARY | 4 | elzenzo_2.a.checked_out | 1 | 100.00 | |
| 1 | SIMPLE | ag | eq_ref | PRIMARY | PRIMARY | 4 | elzenzo_2.a.access | 1 | 100.00 | Using where |
| 1 | SIMPLE | ua | eq_ref | PRIMARY | PRIMARY | 4 | elzenzo_2.a.created_user_id | 1 | 100.00 | Using where |
| 1 | SIMPLE | g | eq_ref | PRIMARY | PRIMARY | 4 | elzenzo_2.a.group_id | 1 | 100.00 | Using where |
| 1 | SIMPLE | fc | ref | PRIMARY | PRIMARY | 4 | elzenzo_2.a.id | 1 | 100.00 | Using where; Using index |
| Status | Duration |
|---|
| Starting | 0.12 ms |
| Waiting for query cache lock | 0.01 ms |
| starting | 0.01 ms |
| Checking query cache for query | 0.02 ms |
| checking privileges on cached | 0.01 ms |
| checking permissions | 0.02 ms |
| Sending cached result to clien | 0.13 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 18 | JDatabaseDriver->loadObjectList() | JROOT/libraries/legacy/model/legacy.php:307 |
| 17 | JModelLegacy->_getList() | JROOT/administrator/components/com_fields/models/fields.php:333 |
| 16 | FieldsModelFields->_getList() | JROOT/libraries/legacy/model/list.php:186 |
| 15 | JModelList->getItems() | JROOT/administrator/components/com_fields/helpers/fields.php:134 |
| 14 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:378 |
| 13 | PlgSystemFields->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 |
| 12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/featured/view.html.php:98 |
| 10 | ContentViewFeatured->display() | JROOT/libraries/legacy/controller/legacy.php:671 |
| 9 | JControllerLegacy->display() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/legacy/controller/legacy.php:709 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_content/content.php:39 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/cms/component/helper.php:394 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:369 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Query Time: 0.29 ms After last query: 2.85 ms Query memory: 0.009 MB Memory before query: 7.517 MB Rows returned: 0
SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state
FROM 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 (26,0,21,20))
AND a.access IN (1,1,2,3,6)
AND (a.group_id = 0 OR g.access IN (1,1,2,3,6))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
GROUP BY a.id, l.title, l.image, uc.name, ag.title, ua.name, g.title, g.access, g.state
ORDER BY a.ordering
| 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 | elzenzo_2.a.language | 1 | 100.00 | Using where |
| 1 | SIMPLE | uc | eq_ref | PRIMARY | PRIMARY | 4 | elzenzo_2.a.checked_out | 1 | 100.00 | |
| 1 | SIMPLE | ag | eq_ref | PRIMARY | PRIMARY | 4 | elzenzo_2.a.access | 1 | 100.00 | Using where |
| 1 | SIMPLE | ua | eq_ref | PRIMARY | PRIMARY | 4 | elzenzo_2.a.created_user_id | 1 | 100.00 | Using where |
| 1 | SIMPLE | g | eq_ref | PRIMARY | PRIMARY | 4 | elzenzo_2.a.group_id | 1 | 100.00 | Using where |
| 1 | SIMPLE | fc | ref | PRIMARY | PRIMARY | 4 | elzenzo_2.a.id | 1 | 100.00 | Using where; Using index |
| Status | Duration |
|---|
| Starting | 0.11 ms |
| Waiting for query cache lock | 0.01 ms |
| starting | 0.01 ms |
| Checking query cache for query | 0.01 ms |
| checking privileges on cached | 0.01 ms |
| checking permissions | 0.01 ms |
| Sending cached result to clien | 0.11 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 18 | JDatabaseDriver->loadObjectList() | JROOT/libraries/legacy/model/legacy.php:307 |
| 17 | JModelLegacy->_getList() | JROOT/administrator/components/com_fields/models/fields.php:333 |
| 16 | FieldsModelFields->_getList() | JROOT/libraries/legacy/model/list.php:186 |
| 15 | JModelList->getItems() | JROOT/administrator/components/com_fields/helpers/fields.php:134 |
| 14 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:378 |
| 13 | PlgSystemFields->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 |
| 12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/featured/view.html.php:98 |
| 10 | ContentViewFeatured->display() | JROOT/libraries/legacy/controller/legacy.php:671 |
| 9 | JControllerLegacy->display() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/legacy/controller/legacy.php:709 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_content/content.php:39 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/cms/component/helper.php:394 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:369 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Query Time: 0.32 ms After last query: 0.77 ms Query memory: 0.009 MB Memory before query: 7.528 MB Rows returned: 0
SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state
FROM 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 (27,0,21,20))
AND a.access IN (1,1,2,3,6)
AND (a.group_id = 0 OR g.access IN (1,1,2,3,6))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
GROUP BY a.id, l.title, l.image, uc.name, ag.title, ua.name, g.title, g.access, g.state
ORDER BY a.ordering
| 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 | elzenzo_2.a.language | 1 | 100.00 | Using where |
| 1 | SIMPLE | uc | eq_ref | PRIMARY | PRIMARY | 4 | elzenzo_2.a.checked_out | 1 | 100.00 | |
| 1 | SIMPLE | ag | eq_ref | PRIMARY | PRIMARY | 4 | elzenzo_2.a.access | 1 | 100.00 | Using where |
| 1 | SIMPLE | ua | eq_ref | PRIMARY | PRIMARY | 4 | elzenzo_2.a.created_user_id | 1 | 100.00 | Using where |
| 1 | SIMPLE | g | eq_ref | PRIMARY | PRIMARY | 4 | elzenzo_2.a.group_id | 1 | 100.00 | Using where |
| 1 | SIMPLE | fc | ref | PRIMARY | PRIMARY | 4 | elzenzo_2.a.id | 1 | 100.00 | Using where; Using index |
| Status | Duration |
|---|
| Starting | 0.10 ms |
| Waiting for query cache lock | 0.01 ms |
| starting | 0.01 ms |
| Checking query cache for query | 0.02 ms |
| checking privileges on cached | 0.01 ms |
| checking permissions | 0.01 ms |
| Sending cached result to clien | 0.11 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 18 | JDatabaseDriver->loadObjectList() | JROOT/libraries/legacy/model/legacy.php:307 |
| 17 | JModelLegacy->_getList() | JROOT/administrator/components/com_fields/models/fields.php:333 |
| 16 | FieldsModelFields->_getList() | JROOT/libraries/legacy/model/list.php:186 |
| 15 | JModelList->getItems() | JROOT/administrator/components/com_fields/helpers/fields.php:134 |
| 14 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:378 |
| 13 | PlgSystemFields->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 |
| 12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/featured/view.html.php:98 |
| 10 | ContentViewFeatured->display() | JROOT/libraries/legacy/controller/legacy.php:671 |
| 9 | JControllerLegacy->display() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/legacy/controller/legacy.php:709 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_content/content.php:39 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/cms/component/helper.php:394 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:369 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Query Time: 1.91 ms After last query: 68.93 ms Query memory: 0.007 MB Memory before query: 8.478 MB Rows returned: 2
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 <= '2025-05-09 04:20:36')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2025-05-09 04:20:36')
AND m.access IN (1,1,2,3,6)
AND m.client_id = 0
AND (mm.menuid = 101 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 | mm | index | PRIMARY | PRIMARY | 8 | NULL | 22 | 100.00 | Using where; Using index; Using temporary; Using filesort |
| 1 | SIMPLE | m | eq_ref | PRIMARY,published,newsfeeds | PRIMARY | 4 | elzenzo_2.mm.moduleid | 1 | 83.33 | Using where |
| 1 | SIMPLE | e | ref | element_clientid,element_folder_clientid | element_clientid | 403 | elzenzo_2.m.module,const | 1 | 100.00 | Using index condition; Using where |
| Status | Duration |
|---|
| Starting | 0.17 ms |
| Waiting for query cache lock | 0.01 ms |
| starting | 0.01 ms |
| Checking query cache for query | 0.17 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.08 ms |
| After opening tables | 0.02 ms |
| System lock | 0.01 ms |
| table lock | 0.01 ms |
| Waiting for query cache lock | 0.04 ms |
| init | 0.09 ms |
| Optimizing | 0.07 ms |
| Statistics | 0.14 ms |
| Preparing | 0.07 ms |
| Creating tmp table | 0.05 ms |
| Sorting result | 0.02 ms |
| Executing | 0.01 ms |
| Sending data | 0.43 ms |
| Creating sort index | 0.10 ms |
| Removing tmp table | 0.08 ms |
| Creating sort index | 0.01 ms |
| End of update loop | 0.01 ms |
| Query end | 0.01 ms |
| Commit | 0.01 ms |
| Query end | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.02 ms |
| Query end | 0.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.09 ms |
| Updating status | 0.01 ms |
| Waiting for query cache lock | 0.01 ms |
| Updating status | 0.02 ms |
| Waiting for query cache lock | 0.01 ms |
| Updating status | 0.01 ms |
| Storing result in query cache | 0.01 ms |
| Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 13 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/cache/controller/callback.php:169 |
| 12 | JCacheControllerCallback->get() | JROOT/libraries/cms/module/helper.php:424 |
| 11 | JModuleHelper::getModuleList() | JROOT/libraries/cms/module/helper.php:360 |
| 10 | JModuleHelper::load() | JROOT/libraries/cms/module/helper.php:84 |
| 9 | JModuleHelper::getModules() | JROOT/libraries/joomla/document/html.php:576 |
| 8 | JDocumentHtml->countModules() | JROOT/templates/protostar/index.php:95 |
| 7 | require JROOT/templates/protostar/index.php | JROOT/libraries/joomla/document/html.php:653 |
| 6 | JDocumentHtml->_loadTemplate() | JROOT/libraries/joomla/document/html.php:715 |
| 5 | JDocumentHtml->_fetchTemplate() | JROOT/libraries/joomla/document/html.php:530 |
| 4 | JDocumentHtml->parse() | JROOT/libraries/cms/application/cms.php:1098 |
| 3 | JApplicationCms->render() | JROOT/libraries/cms/application/site.php:777 |
| 2 | JApplicationSite->render() | JROOT/libraries/cms/application/cms.php:271 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Voz de compañero 1: Hola, soy integrante de la brigada de salud comunitaria. Acá en Guerrero, les queremos comentar que es un estado donde ha habido muchos casos de Covid 19. Actualmente, en casi todas las regiones hay focos rojos, en los municipios sobre todo de Acapulco hay muchos casos, en los municipios de Taxco, en los municipios de Tlapa, en la región centro, en nuestro municipio también ha habido casos. Entonces como ustedes saben, es una enfermedad que a nivel global está afectando sobre todo las dinámicas de los trabajadores, de la gente más pobre porque ha venido a paralizar muchos sectores económicos y hay muchas tiendas cerradas, los mercados, algunos puestos de que no son necesidades básicas están cerrados, en el transporte también les ha bajado mucho el pasaje, la gente como son albañiles y otros sectores salen a la ciudad ,pero tampoco les quieren dar trabajo por lo mismo. Esto nos hace ver que en Guerrero como en otros estados pues quienes están sufriendo más feo ahorita es la gente que tiene menos recursos, porque esa idea de “quédate en casa” o “no salgas” pues hay gente que lo puede cumplir, pero acá nosotros vemos que hay gente que se ven obligados a salir de sus casas no por gusto sino porque tienen que salir a trabajar y sobre todo para llevar el sustento a su familia. 
A Don Samuel no era necesario mostrarle las injusticias patronales o las del gobierno, el reconocía todo perfectamente. 
Por otra parte, no cabe olvidar que el imaginario de una sociedad sin clases incluye la extinción del Estado. En teoría, el proceso revolucionario iría avanzando en la medida que el pueblo vaya organizando su poder y sustituyendo con organismos de poder popular las instituciones del Estado burgués, incluyendo sus fuerzas armadas. Los esfuerzos que fortalecen la institución armada contradicen el precepto teórico e internan el proceso revolucionario en un laberinto sin salida. Es un contrasentido apuntalar los cimientos del Estado, mientras se sostiene que se lo quiere demoler. 13 Ver Max Weber “El político y el científico”. Alianza Editorial. Madrid. 1967.