|
RELATÓRIO DE ATENDIMENTOS AO CIDADÃO (PROTOCOLOS) |
||
| 2018 | 2019 | 2020 |
1º Trimestre |
1º Trimestre |
|
| 2º Trimestre |
2º Trimestre |
|
| 3º Trimestre |
3º Trimestre |
|
| 4º Trimestre |
4º Trimestre |
|
Relatórios de Atendimento
- Detalhes
Console de depuração do Joomla!
{
"__default": {
"session": {
"counter": 2,
"timer": {
"start": 1716177700,
"last": 1716177700,
"now": 1716177701
}
},
"registry": {},
"user": {
"id": 0,
"name": null,
"username": null,
"email": null,
"password": null,
"password_clear": "",
"block": null,
"sendEmail": 0,
"registerDate": null,
"lastvisitDate": null,
"activation": null,
"params": null,
"groups": [],
"guest": 1,
"lastResetTime": null,
"resetCount": null,
"requireReset": null,
"aid": 0
}
}
}
Tempo
Memória
Tempo: 2.43 ms / 2.43 ms Memória: 0.066 MB / 0.43 MB Application: afterLoad
Tempo: 20.92 ms / 23.35 ms Memória: 0.877 MB / 1.31 MB Application: afterInitialise
Tempo: 3.86 ms / 27.21 ms Memória: 0.400 MB / 1.71 MB Application: afterRoute
Tempo: 5.88 ms / 33.09 ms Memória: 0.064 MB / 1.78 MB Application: beforeRenderComponent com_content
Tempo: 1.05 ms / 34.14 ms Memória: 0.114 MB / 1.89 MB Application: Before JAccess::preloadComponents (all components)
Tempo: 0.96 ms / 35.10 ms Memória: 0.053 MB / 1.94 MB Application: After JAccess::preloadComponents (all components)
Tempo: 0.04 ms / 35.14 ms Memória: 0.000 MB / 1.94 MB Application: Before JAccess::getAssetRules (id:8 name:com_content)
Tempo: 0.14 ms / 35.28 ms Memória: 0.009 MB / 1.95 MB Application: After JAccess::getAssetRules (id:8 name:com_content)
Tempo: 13.02 ms / 48.31 ms Memória: 0.352 MB / 2.30 MB Application: Before JAccess::preloadPermissions (com_content)
Tempo: 9.95 ms / 58.26 ms Memória: 2.655 MB / 4.96 MB Application: After JAccess::preloadPermissions (com_content)
Tempo: 0.13 ms / 58.39 ms Memória: 0.000 MB / 4.83 MB Application: Before JAccess::getAssetRules (id:1559 name:com_content.article.1380)
Tempo: 0.07 ms / 58.46 ms Memória: 0.007 MB / 4.83 MB Application: After JAccess::getAssetRules (id:1559 name:com_content.article.1380)
Tempo: 5.44 ms / 63.90 ms Memória: 0.094 MB / 4.93 MB Application: afterRenderComponent com_content
Tempo: 0.86 ms / 64.76 ms Memória: 0.031 MB / 4.96 MB Application: afterDispatch
Tempo: 2.70 ms / 67.47 ms Memória: 0.067 MB / 5.03 MB Application: beforeRenderModule mod_footer (site-map)
Tempo: 0.91 ms / 68.38 ms Memória: 0.061 MB / 5.09 MB Application: afterRenderModule mod_footer (site-map)
Tempo: 0.10 ms / 68.48 ms Memória: 0.000 MB / 5.07 MB Application: beforeRenderModule mod_ariextmenu (menu-div)
Tempo: 11.28 ms / 79.76 ms Memória: 0.431 MB / 5.50 MB Application: afterRenderModule mod_ariextmenu (menu-div)
Tempo: 0.06 ms / 79.82 ms Memória: 0.000 MB / 5.46 MB Application: beforeRenderModule mod_jfontsize (jFontSize)
Tempo: 0.55 ms / 80.37 ms Memória: 0.007 MB / 5.47 MB Application: afterRenderModule mod_jfontsize (jFontSize)
Tempo: 0.06 ms / 80.43 ms Memória: 0.000 MB / 5.47 MB Application: beforeRenderModule mod_bt_smartsearch (BT Smart Search)
Tempo: 4.69 ms / 85.11 ms Memória: 0.054 MB / 5.52 MB Application: afterRenderModule mod_bt_smartsearch (BT Smart Search)
Tempo: 2.68 ms / 87.80 ms Memória: 0.130 MB / 5.65 MB Application: afterRender
Total de consultas ao banco de dados: 32.62 ms
6,06 MB (6.351.408 Bytes)
24 Queries Registradas 32.62 ms
- Tempo da consulta: 5.83 ms Memória de consulta: 0.003 MB de memória antes da consulta: 0.756 MB
DELETE
FROM `sap_session`
WHERE `time` < '1716176801'EXPLAIN não é possível na consulta: DELETE FROM `sap_session` WHERE `time` < '1716176801'Status Duration Starting 0.07 ms checking permissions 0.02 ms Opening tables 0.05 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init for update 0.11 ms Updating 0.16 ms End of update loop 0.02 ms Query end 0.01 ms Commit 5.21 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Caller File and line number 6 JDatabaseDriverMysqli->execute() JROOT/libraries/cms/application/cms.php:822 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:413 2 JApplicationCms::getInstance() JROOT/libraries/joomla/factory.php:125 1 JFactory::getApplication() JROOT/index.php:46 - Tempo da consulta: 0.33 ms Após última consulta: 0.18 ms Memória de consulta: 0.025 MB de memória antes da consulta: 0.764 MB Linhas retornadas: 1
SELECT `data`
FROM `sap_session`
WHERE `session_id` = 'm7dhjvlicnjll2l0d30o591ta4'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE sap_session const PRIMARY PRIMARY 766 const 1 Status Duration Starting 0.04 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.02 ms Statistics 0.04 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.01 ms Executing 0.01 ms Sending data 0.01 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.01 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.01 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:829 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:413 2 JApplicationCms::getInstance() JROOT/libraries/joomla/factory.php:125 1 JFactory::getApplication() JROOT/index.php:46 - Tempo da consulta: 0.58 ms Após última consulta: 0.57 ms Memória de consulta: 0.033 MB de memória antes da consulta: 0.868 MB Linhas retornadas: 40
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `sap_extensions`
WHERE `type` = 'component'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE sap_extensions ref extension extension 82 const 40 Using index condition Status Duration Starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.05 ms Preparing 0.03 ms Executing 0.01 ms Sending data 0.21 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.00 ms closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Caller File and line number 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1681 9 JDatabaseDriver->loadObjectList() JROOT/libraries/cms/component/helper.php:447 8 JComponentHelper::{closure}() JROOT/libraries/joomla/cache/controller/callback.php:169 7 JCacheControllerCallback->get() JROOT/libraries/cms/component/helper.php:455 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 - Tempo da consulta: 0.28 ms Após última consulta: 0.51 ms Memória de consulta: 0.023 MB de memória antes da consulta: 0.909 MB Linhas retornadas: 5
SELECT id, rules
FROM `sap_viewlevels`id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE sap_viewlevels ALL NULL NENHUMA CHAVE DE ÍNDICE PÔDE SER USADA NULL NULL 5 Status Duration Starting 0.03 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Executing 0.01 ms Sending data 0.03 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.00 ms closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.01 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:1061 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 - Tempo da consulta: 0.40 ms Após última consulta: 0.11 ms Memória de consulta: 0.022 MB de memória antes da consulta: 0.921 MB Linhas retornadas: 2
SELECT b.id
FROM sap_usergroups AS a
LEFT JOIN sap_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 9id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a const PRIMARY PRIMARY 4 const 1 1 SIMPLE b range idx_usergroup_nested_set_lookup idx_usergroup_nested_set_lookup 4 NULL 2 Using where; Using index Status Duration Starting 0.04 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.02 ms Statistics 0.06 ms Preparing 0.01 ms Unlocking tables 0.00 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.03 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.00 ms closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 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:1093 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 - Tempo da consulta: 0.71 ms Após última consulta: 0.17 ms Memória de consulta: 0.027 MB de memória antes da consulta: 0.943 MB Linhas retornadas: 57
SELECT `folder` AS `type`,`element` AS `name`,`params`
FROM sap_extensions
WHERE enabled = 1
AND type = 'plugin'
AND state IN (0,1)
AND access IN (1,1,5)
ORDER BY orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE sap_extensions ALL extension NENHUMA CHAVE DE ÍNDICE PÔDE SER USADA NULL NULL 218 Using where; Usando filesort Status Duration Starting 0.05 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.03 ms Optimizing 0.02 ms Statistics 0.04 ms Preparing 0.02 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.01 ms Creating sort index 0.33 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.01 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Caller File and line number 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 - Tempo da consulta: 1.16 ms Após última consulta: 4.88 ms Memória de consulta: 0.091 MB de memória antes da consulta: 1.340 MB Linhas retornadas: 60
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 sap_menu AS m
LEFT JOIN sap_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.lftid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ref idx_client_id_parent_id_alias_language idx_client_id_parent_id_alias_language 1 const 79 Using index condition; Using where; Usando filesort 1 SIMPLE e eq_ref PRIMARY PRIMARY 4 c0camsap_db.m.component_id 1 Using where Status Duration Starting 0.07 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.03 ms Optimizing 0.02 ms Statistics 0.05 ms Preparing 0.04 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.02 ms Creating sort index 0.65 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.00 ms closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Caller File and line number 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:444 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:549 6 JApplicationCms::getRouter() JROOT/libraries/cms/application/site.php:402 5 JApplicationSite::getRouter() JROOT/libraries/cms/application/cms.php:1145 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 - Tempo da consulta: 0.38 ms Após última consulta: 2.58 ms Memória de consulta: 0.024 MB de memória antes da consulta: 1.729 MB Linhas retornadas: 1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `sap_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE sap_extensions ref element_clientid,element_folder_clientid,extension extension 484 const,const 1 Using index condition Status Duration Starting 0.04 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.02 ms Statistics 0.06 ms Preparing 0.03 ms Executing 0.01 ms Sending data 0.04 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.01 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:760 6 JFactory::createDocument() JROOT/libraries/joomla/factory.php:216 5 JFactory::getDocument() JROOT/libraries/joomla/application/web.php:1023 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 - Tempo da consulta: 3.58 ms Após última consulta: 0.18 ms Memória de consulta: 0.005 MB de memória antes da consulta: 1.721 MB
UPDATE `sap_extensions`
SET `params` = '{\"mediaversion\":\"1e233ea0066bbae176f9e3aa5c678712\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'EXPLAIN não é possível na consulta: UPDATE `sap_extensions` SET `params` = '{\"mediaversion\":\"1e233ea0066bbae176f9e3aa5c678712\"}' WHERE `type` = 'library' AND `element` = 'joomla'Status Duration Starting 0.04 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init for update 0.06 ms Updating 0.07 ms End of update loop 0.01 ms Query end 0.00 ms Commit 3.24 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Caller File and line number 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:760 6 JFactory::createDocument() JROOT/libraries/joomla/factory.php:216 5 JFactory::getDocument() JROOT/libraries/joomla/application/web.php:1023 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 - Tempo da consulta: 0.35 ms Após última consulta: 0.33 ms Memória de consulta: 0.025 MB de memória antes da consulta: 1.757 MB Linhas retornadas: 1
SELECT *
FROM sap_languages
WHERE published=1
ORDER BY ordering ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE sap_languages ALL NULL NENHUMA CHAVE DE ÍNDICE PÔDE SER USADA NULL NULL 1 Using where; Usando filesort Status Duration Starting 0.03 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.02 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.01 ms Creating sort index 0.05 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.00 ms closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 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 - Tempo da consulta: 0.46 ms Após última consulta: 0.22 ms Memória de consulta: 0.021 MB de memória antes da consulta: 1.769 MB Linhas retornadas: 4
SELECT id, home, template, s.params
FROM sap_template_styles as s
LEFT JOIN sap_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 = 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE s ALL idx_template NENHUMA CHAVE DE ÍNDICE PÔDE SER USADA NULL NULL 6 Using where 1 SIMPLE e ref element_clientid,element_folder_clientid,extension element_clientid 403 c0camsap_db.s.template,const 1 Using index condition; Using where Status Duration Starting 0.05 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.03 ms Optimizing 0.03 ms Statistics 0.06 ms Preparing 0.03 ms Executing 0.01 ms Sending data 0.08 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.01 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 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 - Tempo da consulta: 0.74 ms Após última consulta: 1.38 ms Memória de consulta: 0.030 MB de memória antes da consulta: 1.893 MB Linhas retornadas: 36
SELECT `id`,`name`,`rules`,`parent_id`
FROM `sap_assets`
WHERE `name` IN ('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_docindexer','com_fields','com_finder','com_fjrelated','com_flexicontactplus','com_icagenda','com_installer','com_issuetracker','com_jce','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_pagination','com_plugins','com_postinstall','com_redirect','com_search','com_sliderck','com_tags','com_templates','com_users','com_wrapper') OR `parent_id` = 0id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE sap_assets index_merge idx_asset_name,idx_parent_id idx_asset_name,idx_parent_id 202,4 NULL 40 Using sort_union(idx_asset_name,idx_parent_id); Using where Status Duration Starting 0.06 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.04 ms Optimizing 0.02 ms Statistics 0.12 ms Preparing 0.03 ms Executing 0.01 ms Sending data 0.28 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.01 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Caller File and line number 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1681 17 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/access/access.php:427 16 JAccess::preloadComponents() JROOT/libraries/joomla/access/access.php:211 15 JAccess::preload() JROOT/libraries/joomla/access/access.php:529 14 JAccess::getAssetRules() JROOT/libraries/joomla/access/access.php:181 13 JAccess::check() JROOT/libraries/joomla/user/user.php:393 12 JUser->authorise() JROOT/components/com_content/models/article.php:55 11 ContentModelArticle->populateState() JROOT/libraries/legacy/model/legacy.php:434 10 JModelLegacy->getState() JROOT/components/com_content/models/article.php:248 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:109 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:389 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:364 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 - Tempo da consulta: 1.03 ms Após última consulta: 0.46 ms Memória de consulta: 0.035 MB de memória antes da consulta: 1.952 MB Linhas retornadas: 30
SHOW FULL COLUMNS
FROM `sap_content`EXPLAIN não é possível na consulta: SHOW FULL COLUMNS FROM `sap_content`Status Duration Starting 0.03 ms checking permissions 0.01 ms closing tables 0.01 ms Opening tables 0.37 ms After opening tables 0.01 ms System lock 0.00 ms table lock 0.01 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Executing 0.01 ms Filling schema table 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms checking permissions 0.15 ms closing tables 0.01 ms Executing 0.00 ms Sending data 0.06 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.00 ms closing tables 0.00 ms Removing tmp table 0.15 ms closing tables 0.01 ms Unlocking tables 0.00 ms closing tables 0.00 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 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/joomla/database/driver/mysqli.php:440 14 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/joomla/table/table.php:244 13 JTable->getFields() JROOT/libraries/joomla/table/table.php:163 12 JTable->__construct() JROOT/libraries/legacy/table/content.php:33 11 JTableContent->__construct() JROOT/libraries/joomla/table/table.php:311 10 JTable::getInstance() JROOT/components/com_content/models/article.php:250 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:109 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:389 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:364 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 - Tempo da consulta: 0.38 ms Após última consulta: 0.56 ms Memória de consulta: 0.035 MB de memória antes da consulta: 2.025 MB Linhas retornadas: 1
SELECT *
FROM sap_content
WHERE `id` = '1380'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE sap_content const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.03 ms Optimizing 0.01 ms Statistics 0.07 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.03 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.00 ms closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1445 11 JDatabaseDriver->loadAssoc() JROOT/libraries/joomla/table/table.php:729 10 JTable->load() JROOT/components/com_content/models/article.php:251 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:109 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:389 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:364 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 - Tempo da consulta: 5.24 ms Após última consulta: 0.13 ms Memória de consulta: 0.005 MB de memória antes da consulta: 2.035 MB
UPDATE sap_content
SET `hits` = (`hits` + 1)
WHERE `id` = '1380'EXPLAIN não é possível na consulta: UPDATE sap_content SET `hits` = (`hits` + 1) WHERE `id` = '1380'Status Duration Starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init for update 0.04 ms Updating 0.07 ms End of update loop 0.01 ms Query end 0.00 ms Commit 4.93 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/table/table.php:1240 10 JTable->hit() JROOT/components/com_content/models/article.php:252 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:109 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:389 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:364 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 - Tempo da consulta: 0.70 ms Após última consulta: 0.46 ms Memória de consulta: 0.036 MB de memória antes da consulta: 2.059 MB Linhas retornadas: 1
SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
FROM sap_content AS a
INNER JOIN sap_categories AS c
on c.id = a.catid
LEFT JOIN sap_users AS u
on u.id = a.created_by
LEFT JOIN sap_categories as parent
ON parent.id = c.parent_id
LEFT JOIN sap_content_rating AS v
ON a.id = v.content_id
WHERE a.id = 1380
AND c.published > 0
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-05-20 04:01:41')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-05-20 04:01:41')
AND (a.state = 1 OR a.state =2)id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a const PRIMARY,idx_state,idx_catid PRIMARY 4 const 1 1 SIMPLE c const PRIMARY PRIMARY 4 const 1 1 SIMPLE u const PRIMARY PRIMARY 4 const 1 1 SIMPLE parent const PRIMARY PRIMARY 4 const 1 1 SIMPLE v const PRIMARY PRIMARY 4 const 0 Unique row not found Status Duration Starting 0.14 ms checking permissions 0.01 ms Opening tables 0.04 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.06 ms Optimizing 0.04 ms Statistics 0.12 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.04 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.00 ms closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1642 13 JDatabaseDriver->loadObject() JROOT/components/com_content/models/article.php:148 12 ContentModelArticle->getItem() JROOT/libraries/legacy/view/legacy.php:422 11 JViewLegacy->get() JROOT/components/com_content/views/article/view.html.php:42 10 ContentViewArticle->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:389 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:364 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 - Tempo da consulta: 0.68 ms Após última consulta: 0.77 ms Memória de consulta: 0.039 MB de memória antes da consulta: 2.173 MB Linhas retornadas: 2
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM sap_categories as c
LEFT JOIN sap_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,5)
AND c.published = 1
AND s.id=16
ORDER BY c.lftid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE s const PRIMARY,idx_left_right PRIMARY 4 const 1 1 SIMPLE c ALL cat_idx,idx_access,idx_left_right NENHUMA CHAVE DE ÍNDICE PÔDE SER USADA NULL NULL 22 Using where; Usando filesort Status Duration Starting 0.11 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.06 ms Optimizing 0.03 ms Statistics 0.10 ms Preparing 0.01 ms Unlocking tables 0.00 ms Preparing 0.03 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.02 ms Creating sort index 0.11 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.01 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Caller File and line number 22 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1681 21 JDatabaseDriver->loadObjectList() JROOT/libraries/legacy/categories/categories.php:304 20 JCategories->_load() JROOT/libraries/legacy/categories/categories.php:184 19 JCategories->get() JROOT/components/com_content/router.php:72 18 ContentRouter->getCategorySegment() JROOT/libraries/cms/component/router/view.php:117 17 JComponentRouterView->getPath() JROOT/libraries/cms/component/router/rules/menu.php:82 16 JComponentRouterRulesMenu->preprocess() JROOT/libraries/cms/component/router/view.php:219 15 JComponentRouterView->preprocess() JROOT/libraries/cms/router/site.php:660 14 JRouterSite->processBuildRules() JROOT/libraries/cms/router/router.php:267 13 JRouter->build() JROOT/libraries/cms/router/site.php:149 12 JRouterSite->build() JROOT/libraries/joomla/application/route.php:62 11 JRoute::_() JROOT/components/com_content/views/article/view.html.php:71 10 ContentViewArticle->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:389 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:364 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 - Tempo da consulta: 0.59 ms Após última consulta: 0.35 ms Memória de consulta: 0.034 MB de memória antes da consulta: 2.210 MB Linhas retornadas: 0
SELECT `m`.`tag_id`,`t`.*
FROM `sap_contentitem_tag_map` AS m
INNER JOIN `sap_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 1380
AND `t`.`published` = 1
AND t.access IN (1,1,5)id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE t ALL PRIMARY,tag_idx,idx_access NENHUMA CHAVE DE ÍNDICE PÔDE SER USADA NULL NULL 16 Using where 1 SIMPLE m ref idx_tag_type idx_tag_type 4 c0camsap_db.t.id 1 Using index condition; Using where Status Duration Starting 0.05 ms checking permissions 0.04 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.04 ms Optimizing 0.03 ms Statistics 0.06 ms Preparing 0.04 ms Executing 0.01 ms Sending data 0.13 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.01 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1681 12 JDatabaseDriver->loadObjectList() JROOT/libraries/cms/helper/tags.php:450 11 JHelperTags->getItemTags() JROOT/components/com_content/views/article/view.html.php:180 10 ContentViewArticle->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:389 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:364 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 - Tempo da consulta: 4.99 ms Após última consulta: 2.05 ms Memória de consulta: 0.572 MB de memória antes da consulta: 2.302 MB Linhas retornadas: 3393
SELECT `id`,`name`,`rules`,`parent_id`
FROM `sap_assets`
WHERE `name` LIKE 'com_content.%' OR `name` = 'com_content' OR `parent_id` = 0id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE sap_assets ALL idx_asset_name,idx_parent_id NENHUMA CHAVE DE ÍNDICE PÔDE SER USADA NULL NULL 3453 Using where Status Duration Starting 0.04 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.02 ms Statistics 0.07 ms Preparing 0.02 ms Executing 0.01 ms Sending data 4.42 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Caller File and line number 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1681 19 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/access/access.php:357 18 JAccess::preloadPermissions() JROOT/libraries/joomla/access/access.php:224 17 JAccess::preload() JROOT/libraries/joomla/access/access.php:538 16 JAccess::getAssetRules() JROOT/libraries/joomla/access/access.php:181 15 JAccess::check() JROOT/libraries/joomla/user/user.php:393 14 JUser->authorise() JROOT/plugins/content/pagenavigation/pagenavigation.php:54 13 PlgContentPagenavigation->onContentBeforeDisplay() 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/article/view.html.php:196 10 ContentViewArticle->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:389 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:364 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 - Tempo da consulta: 1.88 ms Após última consulta: 5.21 ms Memória de consulta: 0.030 MB de memória antes da consulta: 4.845 MB Linhas retornadas: 37
SELECT a.id, a.title, a.catid, a.language,
CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug,
CASE WHEN CHAR_LENGTH(cc.alias) != 0 THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as catslug
FROM sap_content AS a
LEFT JOIN sap_categories AS cc
ON cc.id = a.catid
WHERE a.catid = 16
AND a.state = 1
AND a.access IN (1,1,5)
AND (a.state = 1 OR a.state = -1)
AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2024-05-20 04:01:41')
AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2024-05-20 04:01:41')
ORDER BY
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END DESCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a index_merge idx_access,idx_state,idx_catid idx_catid,idx_state 4,1 NULL 31 Using intersect(idx_catid,idx_state); Using where; Usando filesort 1 SIMPLE cc const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.12 ms checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.05 ms Optimizing 0.05 ms Statistics 0.13 ms Preparing 0.04 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.01 ms Creating sort index 1.26 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.01 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Caller File and line number 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1681 14 JDatabaseDriver->loadObjectList() JROOT/plugins/content/pagenavigation/pagenavigation.php:159 13 PlgContentPagenavigation->onContentBeforeDisplay() 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/article/view.html.php:196 10 ContentViewArticle->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:389 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:364 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 - Tempo da consulta: 1.13 ms Após última consulta: 4.85 ms Memória de consulta: 0.027 MB de memória antes da consulta: 5.042 MB Linhas retornadas: 6
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM sap_modules AS m
LEFT JOIN sap_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN sap_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
WHERE m.published = 1
AND e.enabled = 1
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2024-05-20 04:01:41')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-05-20 04:01:41')
AND m.access IN (1,1,5)
AND m.client_id = 0
AND (mm.menuid = 228 OR mm.menuid <= 0)
ORDER BY m.position, m.orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ref PRIMARY,published,newsfeeds published 1 const 27 Using index condition; Using where; Usando filesort 1 SIMPLE e ref element_clientid,element_folder_clientid element_clientid 403 c0camsap_db.m.module,const 1 Using index condition; Using where 1 SIMPLE mm ref PRIMARY PRIMARY 4 c0camsap_db.m.id 3 Using where; Using index Status Duration Starting 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 init 0.04 ms Optimizing 0.04 ms Statistics 0.07 ms Preparing 0.06 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.01 ms Creating sort index 0.59 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.01 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Caller File and line number 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/sap/index.php:55 7 require JROOT/templates/sap/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:1102 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 - Tempo da consulta: 0.31 ms Após última consulta: 0.17 ms Memória de consulta: 0.023 MB de memória antes da consulta: 5.037 MB Linhas retornadas: 1
SELECT `urls`,`images`,`title`,`introtext`
FROM `sap_content`
WHERE id = '1380'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE sap_content const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.04 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.01 ms Executing 0.01 ms Sending data 0.01 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.01 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Caller File and line number 9 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1681 8 JDatabaseDriver->loadObjectList() JROOT/templates/sap/index.php:97 7 require JROOT/templates/sap/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:1102 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 - Tempo da consulta: 0.51 ms Após última consulta: 13.96 ms Memória de consulta: 0.025 MB de memória antes da consulta: 5.498 MB Linhas retornadas: 6
SELECT `name`,`element`
FROM `sap_extensions`
WHERE `type` = 'plugin'
AND `folder` = 'finder'
AND `enabled` = 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE sap_extensions ALL extension NENHUMA CHAVE DE ÍNDICE PÔDE SER USADA NULL NULL 218 Using where Status Duration Starting 0.04 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.02 ms Statistics 0.05 ms Preparing 0.03 ms Executing 0.01 ms Sending data 0.17 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.01 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1681 13 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_finder/helpers/language.php:125 12 FinderHelperLanguage::loadPluginLanguage() JROOT/modules/mod_bt_smartsearch/helper.php:15 11 require_once JROOT/modules/mod_bt_smartsearch/helper.php JROOT/modules/mod_bt_smartsearch/mod_bt_smartsearch.php:16 10 include JROOT/modules/mod_bt_smartsearch/mod_bt_smartsearch.php JROOT/libraries/cms/module/helper.php:198 9 JModuleHelper::renderModule() JROOT/libraries/joomla/document/renderer/html/module.php:93 8 JDocumentRendererHtmlModule->render() JROOT/libraries/joomla/document/renderer/html/modules.php:42 7 JDocumentRendererHtmlModules->render() JROOT/libraries/joomla/document/html.php:486 6 JDocumentHtml->getBuffer() JROOT/libraries/joomla/document/html.php:777 5 JDocumentHtml->_renderTemplate() JROOT/libraries/joomla/document/html.php:552 4 JDocumentHtml->render() JROOT/libraries/cms/application/cms.php:1116 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 - Tempo da consulta: 0.39 ms Após última consulta: 2.22 ms Memória de consulta: 0.025 MB de memória antes da consulta: 5.526 MB Linhas retornadas: 6
SELECT `title`
FROM `sap_finder_taxonomy`
WHERE `parent_id` = 1
AND `state` = 1
AND `access` IN (1,1,5)id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE sap_finder_taxonomy ref parent_id,state,access,idx_parent_published idx_parent_published 5 const,const 7 Using index condition Status Duration Starting 0.04 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.02 ms Statistics 0.07 ms Preparing 0.03 ms Executing 0.01 ms Sending data 0.04 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.01 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1530 15 JDatabaseDriver->loadColumn() JROOT/administrator/components/com_finder/helpers/indexer/taxonomy.php:258 14 FinderIndexerTaxonomy::getBranchTitles() JROOT/administrator/components/com_finder/helpers/indexer/query.php:750 13 FinderIndexerQuery->processString() JROOT/administrator/components/com_finder/helpers/indexer/query.php:236 12 FinderIndexerQuery->__construct() JROOT/modules/mod_bt_smartsearch/helper.php:143 11 ModBtSmartsearchHelper::getQuery() JROOT/modules/mod_bt_smartsearch/mod_bt_smartsearch.php:41 10 include JROOT/modules/mod_bt_smartsearch/mod_bt_smartsearch.php JROOT/libraries/cms/module/helper.php:198 9 JModuleHelper::renderModule() JROOT/libraries/joomla/document/renderer/html/module.php:93 8 JDocumentRendererHtmlModule->render() JROOT/libraries/joomla/document/renderer/html/modules.php:42 7 JDocumentRendererHtmlModules->render() JROOT/libraries/joomla/document/html.php:486 6 JDocumentHtml->getBuffer() JROOT/libraries/joomla/document/html.php:777 5 JDocumentHtml->_renderTemplate() JROOT/libraries/joomla/document/html.php:552 4 JDocumentHtml->render() JROOT/libraries/cms/application/cms.php:1116 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
22 tipos de query registradas, sorteadas por ocorrências DESC
SELECT Tables:
2 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `sap_assets`2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `sap_extensions`1 × SELECT `data`
FROM `sap_session`1 × SELECT `name`,`element`
FROM `sap_extensions`1 × SELECT `urls`,`images`,`title`,`introtext`
FROM `sap_content`1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM sap_modules AS m
LEFT JOIN sap_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN sap_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id1 × SELECT a.id, a.title, a.catid, a.language,
CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug,
CASE WHEN CHAR_LENGTH(cc.alias) != 0 THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as catslug
FROM sap_content AS a
LEFT JOIN sap_categories AS cc
ON cc.id = a.catid1 × SELECT `m`.`tag_id`,`t`.*
FROM `sap_contentitem_tag_map` AS m
INNER JOIN `sap_tags` AS t
ON `m`.`tag_id` = `t`.`id`1 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM sap_categories as c
LEFT JOIN sap_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)1 × SELECT *
FROM sap_content1 × SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
FROM sap_content AS a
INNER JOIN sap_categories AS c
on c.id = a.catid
LEFT JOIN sap_users AS u
on u.id = a.created_by
LEFT JOIN sap_categories as parent
ON parent.id = c.parent_id
LEFT JOIN sap_content_rating AS v
ON a.id = v.content_id1 × SELECT id, home, template, s.params
FROM sap_template_styles as s
LEFT JOIN sap_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id1 × SELECT *
FROM sap_languages1 × 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 sap_menu AS m
LEFT JOIN sap_extensions AS e
ON m.component_id = e.extension_id1 × SELECT `folder` AS `type`,`element` AS `name`,`params`
FROM sap_extensions1 × SELECT b.id
FROM sap_usergroups AS a
LEFT JOIN sap_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt1 × SELECT id, rules
FROM `sap_viewlevels1 × SELECT `title`
FROM `sap_finder_taxonomy`
Outras Tabelas:
1 × DELETE
FROM `sap_session`1 × UPDATE `sap_extensions`
SET `params` = '{\"mediaversion\":\"1e233ea0066bbae176f9e3aa5c678712\"}'1 × SHOW FULL COLUMNS
FROM `sap_content1 × UPDATE sap_content
SET `hits` = (`hits` + 1)