Licitações
Equipe da Diretoria de Gestão e Tecnologia da Informação
Publicado: Segunda, 27 Janeiro 2020 15:01
|
Última Atualização: Terça, 26 Mai 2020 15:30
|
Acessos: 4400
Console de depuração do Joomla!
{
"__default": {
"session": {
"counter": 1,
"timer": {
"start": 1792814033,
"last": 1792814033,
"now": 1792814033
},
"client": {
"forwarded": "216.73.216.41"
},
"token": "IdsLvgdmrIpKxPCajTuUgUUoHCYUDGts"
},
"registry": {
"users": {
"login": {
"form": {
"data": {
"return": null
}
}
}
}
},
"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
},
"plg_system_languagefilter": {
"language": "pt-BR"
}
}
}
Hora
Memória
Hora: 4.36 ms / 4.36 ms Memória: 0.413 MB / 0.74 MB Application: afterLoad
Hora: 125.45 ms / 129.82 ms Memória: 2.290 MB / 3.04 MB Application: afterInitialise
Hora: 4.79 ms / 134.60 ms Memória: 0.160 MB / 3.20 MB Application: afterRoute
Hora: 11.95 ms / 146.56 ms Memória: 0.044 MB / 3.24 MB Application: beforeRenderComponent com_content
Hora: 1.75 ms / 148.30 ms Memória: 0.043 MB / 3.28 MB Application: Before Access::preloadComponents (all components)
Hora: 24.71 ms / 173.02 ms Memória: 0.063 MB / 3.35 MB Application: After Access::preloadComponents (all components)
Hora: 0.04 ms / 173.05 ms Memória: -0.004 MB / 3.34 MB Application: Before Access::preloadPermissions (com_content)
Hora: 8.70 ms / 181.75 ms Memória: 0.627 MB / 3.97 MB Application: After Access::preloadPermissions (com_content)
Hora: 0.08 ms / 181.83 ms Memória: -0.034 MB / 3.93 MB Application: Before Access::getAssetRules (id:624 name:com_content.article.401)
Hora: 0.28 ms / 182.11 ms Memória: 0.009 MB / 3.94 MB Application: After Access::getAssetRules (id:624 name:com_content.article.401)
Hora: 66.73 ms / 248.84 ms Memória: 0.500 MB / 4.44 MB Application: afterRenderComponent com_content
Hora: 46.11 ms / 294.96 ms Memória: 0.026 MB / 4.47 MB Application: Before Access::getAssetRules (id:8 name:com_content)
Hora: 0.02 ms / 294.98 ms Memória: 0.002 MB / 4.47 MB Application: After Access::getAssetRules (id:8 name:com_content)
Hora: 4.20 ms / 299.18 ms Memória: 0.020 MB / 4.49 MB Application: afterDispatch
Hora: 30.04 ms / 329.22 ms Memória: 0.141 MB / 4.63 MB Application: afterRender
Total de consultas ao banco de dados: 219.49 ms
4,95 MB (5.194.736 Bytes)
23 Queries Registradas 219.49 ms
- Tempo da consulta: 15.33 ms Memória de consulta: 0.023 MB de memória antes da consulta: 1.024 MB Linhas retornadas: 0
SELECT `data`
FROM `e17c_session`
WHERE `session_id` = X'363661766b6d31616d6d706f667270616d7331616f366e306364'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE e17c_session const PRIMARY PRIMARY 194 const 1 Status Duration Starting 0.24 ms checking permissions 0.03 ms Opening tables 0.04 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.02 ms init 0.05 ms Optimizing 0.05 ms Statistics 14.07 ms Preparing 0.09 ms Executing 0.03 ms End of update loop 0.02 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.02 ms Starting cleanup 0.01 ms Freeing items 0.02 ms Updating status 0.07 ms Reset for next command 0.01 ms # Chamador Arquivo e número da linha 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 15 JDatabaseDriver->loadResult() JROOT/libraries/joomla/session/storage/database.php:45 14 JSessionStorageDatabase->read() Igual à chamada na linha abaixo. 13 session_start() JROOT/libraries/joomla/session/handler/native.php:260 12 JSessionHandlerNative->doSessionStart() JROOT/libraries/joomla/session/handler/native.php:50 11 JSessionHandlerNative->start() JROOT/libraries/joomla/session/handler/joomla.php:88 10 JSessionHandlerJoomla->start() JROOT/libraries/src/Session/Session.php:661 9 Joomla\CMS\Session\Session->_start() JROOT/libraries/src/Session/Session.php:621 8 Joomla\CMS\Session\Session->start() JROOT/libraries/src/Session/Session.php:499 7 Joomla\CMS\Session\Session->get() JROOT/libraries/src/Session/Session.php:456 6 Joomla\CMS\Session\Session->isNew() JROOT/libraries/src/Application/CMSApplication.php:826 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:136 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:386 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Tempo da consulta: 0.91 ms Após última consulta: 0.45 ms Memória de consulta: 0.020 MB de memória antes da consulta: 1.039 MB Linhas retornadas: 0
SELECT `session_id`
FROM `e17c_session`
WHERE `session_id` = X'363661766b6d31616d6d706f667270616d7331616f366e306364'
LIMIT 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE e17c_session const PRIMARY PRIMARY 194 const 1 Using index Status Duration Starting 0.10 ms checking permissions 0.02 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.02 ms init 0.04 ms Optimizing 0.03 ms Statistics 0.05 ms Preparing 0.02 ms Executing 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.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.04 ms Reset for next command 0.01 ms # Chamador Arquivo e número da linha 9 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 8 JDatabaseDriver->loadResult() JROOT/libraries/src/Session/MetadataManager.php:74 7 Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() JROOT/libraries/src/Application/CMSApplication.php:154 6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:828 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:136 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:386 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Tempo da consulta: 10.61 ms Após última consulta: 0.10 ms Memória de consulta: 0.004 MB de memória antes da consulta: 1.044 MB
INSERT INTO `e17c_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'363661766b6d31616d6d706f667270616d7331616f366e306364', 1, 1792814033, 0, '', 0)EXPLAIN não é possível na consulta: INSERT INTO `e17c_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'363661766b6d31616d6d706f667270616d7331616f366e306364', 1, 1792814033, 0, '', 0)Status Duration Starting 0.10 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 for update 0.02 ms Update 0.10 ms End of update loop 0.01 ms Query end 0.01 ms Commit 9.76 ms Query end 0.06 ms closing tables 0.02 ms Unlocking tables 0.02 ms closing tables 0.01 ms Query end 0.02 ms Starting cleanup 0.01 ms Freeing items 0.02 ms Updating status 0.06 ms Reset for next command 0.01 ms # Chamador Arquivo e número da linha 8 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Session/MetadataManager.php:116 7 Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() JROOT/libraries/src/Application/CMSApplication.php:154 6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:828 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:136 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:386 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Tempo da consulta: 4.58 ms Após última consulta: 1.90 ms Memória de consulta: 0.021 MB de memória antes da consulta: 1.132 MB Linhas retornadas: 10
SELECT id, rules
FROM `e17c_viewlevels`id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE e17c_viewlevels ALL NULL NENHUMA CHAVE DE ÍNDICE PÔDE SER USADA NULL NULL 1 Status Duration Starting 0.09 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.02 ms init 0.03 ms Optimizing 0.02 ms Statistics 0.03 ms Preparing 0.02 ms Executing 0.01 ms Sending data 3.76 ms End of update loop 0.04 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.02 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.05 ms Reset for next command 0.01 ms # Chamador Arquivo e número da linha 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506 9 JDatabaseDriver->loadAssocList() JROOT/libraries/src/Access/Access.php:1063 8 Joomla\CMS\Access\Access::getAuthorisedViewLevels() JROOT/libraries/src/User/User.php:458 7 Joomla\CMS\User\User->getAuthorisedViewLevels() JROOT/libraries/src/Plugin/PluginHelper.php:318 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo da consulta: 6.73 ms Após última consulta: 0.13 ms Memória de consulta: 0.021 MB de memória antes da consulta: 1.146 MB Linhas retornadas: 4
SELECT b.id
FROM e17c_usergroups AS a
LEFT JOIN e17c_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 1 Using where; Using index Status Duration Starting 0.09 ms checking permissions 0.01 ms Opening tables 0.04 ms After opening tables 0.02 ms System lock 0.01 ms table lock 0.02 ms init 0.04 ms Optimizing 0.03 ms Statistics 5.78 ms Preparing 0.05 ms Unlocking tables 0.01 ms Preparing 0.04 ms Executing 0.01 ms Sending data 0.12 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.01 ms Query end 0.02 ms Starting cleanup 0.01 ms Freeing items 0.02 ms Updating status 0.05 ms Reset for next command 0.01 ms # Chamador Arquivo e número da linha 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 10 JDatabaseDriver->loadColumn() JROOT/libraries/src/Access/Access.php:980 9 Joomla\CMS\Access\Access::getGroupsByUser() JROOT/libraries/src/Access/Access.php:1095 8 Joomla\CMS\Access\Access::getAuthorisedViewLevels() JROOT/libraries/src/User/User.php:458 7 Joomla\CMS\User\User->getAuthorisedViewLevels() JROOT/libraries/src/Plugin/PluginHelper.php:318 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo da consulta: 42.60 ms Após última consulta: 26.74 ms Memória de consulta: 0.021 MB de memória antes da consulta: 3.020 MB Linhas retornadas: 1
SELECT a.*,u.name AS editor,e.enabled AS enabled
FROM `e17c_externallogin_servers` as a
LEFT JOIN e17c_users AS u
ON u.id=a.checked_out
LEFT JOIN e17c_extensions AS e
ON `e`.`type`='plugin'
AND CONCAT_WS('.', `e`.`folder`, `e`.`element`)=`a`.`plugin`
WHERE a.published = 1
AND a.plugin = 'system.caslogin'
ORDER BY a.ordering ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ALL NULL NENHUMA CHAVE DE ÍNDICE PÔDE SER USADA NULL NULL 1 Using where; Using temporary; Usando filesort 1 SIMPLE u eq_ref PRIMARY PRIMARY 4 dgti_ufla_br2.a.checked_out 1 1 SIMPLE e ALL extension NENHUMA CHAVE DE ÍNDICE PÔDE SER USADA NULL NULL 251 Using where; Using join buffer (flat, BNL join) Status Duration Starting 0.22 ms checking permissions 0.03 ms Opening tables 0.06 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.02 ms init 0.06 ms Optimizing 0.04 ms Statistics 2.28 ms Preparing 0.07 ms Creating tmp table 0.05 ms Sorting result 0.03 ms Executing 0.01 ms Sending data 38.55 ms Creating sort index 0.14 ms Removing tmp table 0.15 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.02 ms Query end 0.02 ms Starting cleanup 0.01 ms Freeing items 0.03 ms Updating status 0.08 ms Reset for next command 0.02 ms # Chamador Arquivo e número da linha 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 10 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:194 9 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/plugins/system/caslogin/caslogin.php:519 8 PlgSystemCaslogin->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:668 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo da consulta: 1.51 ms Após última consulta: 0.39 ms Memória de consulta: 0.027 MB de memória antes da consulta: 3.020 MB Linhas retornadas: 163Consultas duplicadas: #22
SHOW TABLES
EXPLAIN não é possível na consulta: SHOW TABLESStatus Duration Starting 0.08 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.02 ms init 0.02 ms Optimizing 0.02 ms Statistics 0.03 ms Preparing 0.03 ms Executing 0.01 ms Filling schema table 0.01 ms checking permissions 0.51 ms Executing 0.02 ms Sending data 0.10 ms End of update loop 0.02 ms Query end 0.01 ms closing tables 0.01 ms Removing tmp table 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.01 ms Updating status 0.06 ms Reset for next command 0.01 ms # Chamador Arquivo e número da linha 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 10 JDatabaseDriver->loadColumn() JROOT/libraries/joomla/database/driver/mysqli.php:505 9 JDatabaseDriverMysqli->getTableList() JROOT/plugins/system/samlredirect/samlredirect.php:90 8 plgSystemSamlredirect->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:668 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo da consulta: 5.23 ms Após última consulta: 0.29 ms Memória de consulta: 0.022 MB de memória antes da consulta: 3.047 MB Linhas retornadas: 1
SELECT *
FROM `e17c_miniorange_saml_customer_details`
WHERE `id` = 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE e17c_miniorange_saml_customer_details const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.07 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.05 ms Optimizing 0.03 ms Statistics 4.17 ms Preparing 0.07 ms Unlocking tables 0.03 ms Preparing 0.03 ms Executing 0.01 ms Sending data 0.05 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.08 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.02 ms Updating status 0.06 ms Reset for next command 0.02 ms # Chamador Arquivo e número da linha 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 10 JDatabaseDriver->loadAssoc() JROOT/administrator/components/com_miniorange_saml/helpers/mo-saml-utility.php:65 9 Mo_saml_Local_Util->_load_db_values() JROOT/plugins/system/samlredirect/samlredirect.php:101 8 plgSystemSamlredirect->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:668 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo da consulta: 9.02 ms Após última consulta: 6.39 ms Memória de consulta: 0.005 MB de memória antes da consulta: 3.200 MB
UPDATE `e17c_extensions`
SET `params` = '{\"mediaversion\":\"d813f5edb63bf76194ade0403cd7b943\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'EXPLAIN não é possível na consulta: UPDATE `e17c_extensions` SET `params` = '{\"mediaversion\":\"d813f5edb63bf76194ade0403cd7b943\"}' WHERE `type` = 'library' AND `element` = 'joomla'Status Duration Starting 0.12 ms checking permissions 0.02 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init for update 5.90 ms Updating 0.17 ms End of update loop 0.02 ms Query end 0.01 ms Commit 2.09 ms Query end 0.06 ms closing tables 0.02 ms Unlocking tables 0.01 ms closing tables 0.03 ms Query end 0.02 ms Starting cleanup 0.01 ms Freeing items 0.02 ms Updating status 0.08 ms Reset for next command 0.02 ms # Chamador Arquivo e número da linha 10 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Helper/LibraryHelper.php:117 9 Joomla\CMS\Helper\LibraryHelper::saveParams() JROOT/libraries/src/Version.php:372 8 Joomla\CMS\Version->setMediaVersion() JROOT/libraries/src/Version.php:331 7 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 6 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 5 Joomla\CMS\Factory::getDocument() JROOT/libraries/src/Application/WebApplication.php:1137 4 Joomla\CMS\Application\WebApplication->loadDocument() JROOT/libraries/src/Application/SiteApplication.php:133 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo da consulta: 24.42 ms Após última consulta: 3.61 ms Memória de consulta: 0.028 MB de memória antes da consulta: 3.287 MB Linhas retornadas: 46
SELECT `id`,`name`,`rules`,`parent_id`
FROM `e17c_assets`
WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_agendadirigentes','com_ajax','com_associations','com_banners','com_blank','com_blankcomponent','com_cache','com_categories','com_chatbro','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_djimageslider','com_externallogin','com_fields','com_finder','com_installer','com_joomlaupdate','com_languages','com_localise','com_login','com_mailto','com_media','com_menus','com_messages','com_miniorange_saml','com_modules','com_newsfeeds','com_phocadownload','com_phocagallery','com_plugins','com_postinstall','com_privacy','com_rcteam','com_redirect','com_search','com_seftranslate','com_tags','com_templates','com_users','com_wrapper')id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE e17c_assets range idx_asset_name idx_asset_name 202 NULL 47 Using index condition Status Duration Starting 0.12 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 0.06 ms Optimizing 0.02 ms Statistics 0.14 ms Preparing 0.03 ms Executing 0.01 ms Sending data 23.14 ms End of update loop 0.08 ms Query end 0.03 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.02 ms Updating status 0.04 ms Reset for next command 0.01 ms # Chamador Arquivo e número da linha 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 17 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Access/Access.php:429 16 Joomla\CMS\Access\Access::preloadComponents() JROOT/libraries/src/Access/Access.php:213 15 Joomla\CMS\Access\Access::preload() JROOT/libraries/src/Access/Access.php:531 14 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 13 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 12 Joomla\CMS\User\User->authorise() JROOT/components/com_content/models/article.php:58 11 ContentModelArticle->populateState() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457 10 Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() JROOT/components/com_content/models/article.php:251 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo da consulta: 7.41 ms Após última consulta: 0.28 ms Memória de consulta: 0.122 MB de memória antes da consulta: 3.342 MB Linhas retornadas: 786
SELECT `id`,`name`,`rules`,`parent_id`
FROM `e17c_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 e17c_assets ALL idx_asset_name,idx_parent_id NENHUMA CHAVE DE ÍNDICE PÔDE SER USADA NULL NULL 1069 Using where Status Duration Starting 0.10 ms checking permissions 0.02 ms Opening tables 0.03 ms After opening tables 0.02 ms System lock 0.01 ms table lock 0.02 ms init 0.06 ms Optimizing 0.03 ms Statistics 4.05 ms Preparing 0.07 ms Executing 0.01 ms Sending data 2.51 ms End of update loop 0.05 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.02 ms Starting cleanup 0.01 ms Freeing items 0.02 ms Updating status 0.03 ms Reset for next command 0.01 ms # Chamador Arquivo e número da linha 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 17 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Access/Access.php:359 16 Joomla\CMS\Access\Access::preloadPermissions() JROOT/libraries/src/Access/Access.php:226 15 Joomla\CMS\Access\Access::preload() JROOT/libraries/src/Access/Access.php:540 14 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 13 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 12 Joomla\CMS\User\User->authorise() JROOT/components/com_content/models/article.php:58 11 ContentModelArticle->populateState() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457 10 Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() JROOT/components/com_content/models/article.php:251 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo da consulta: 1.63 ms Após última consulta: 1.89 ms Memória de consulta: 0.031 MB de memória antes da consulta: 3.946 MB Linhas retornadas: 31
SHOW FULL COLUMNS
FROM `e17c_content`EXPLAIN não é possível na consulta: SHOW FULL COLUMNS FROM `e17c_content`Status Duration Starting 0.08 ms checking permissions 0.02 ms closing tables 0.01 ms checking permissions 0.02 ms Opening tables 0.45 ms After opening tables 0.03 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 Executing 0.01 ms Filling schema table 0.02 ms Opening tables 0.07 ms After opening tables 0.01 ms checking permissions 0.12 ms closing tables 0.02 ms checking permissions 0.01 ms Executing 0.01 ms Sending data 0.07 ms End of update loop 0.01 ms Query end 0.01 ms closing tables 0.01 ms Removing tmp table 0.14 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.01 ms Updating status 0.05 ms Reset for next command 0.02 ms # Chamador Arquivo e número da linha 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 15 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:448 14 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:261 13 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:180 12 Joomla\CMS\Table\Table->__construct() JROOT/libraries/src/Table/Content.php:39 11 Joomla\CMS\Table\Content->__construct() JROOT/libraries/src/Table/Table.php:328 10 Joomla\CMS\Table\Table::getInstance() JROOT/components/com_content/models/article.php:253 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo da consulta: 8.31 ms Após última consulta: 1.00 ms Memória de consulta: 0.005 MB de memória antes da consulta: 3.995 MB
UPDATE e17c_content
SET `hits` = (`hits` + 1)
WHERE `id` = '401'EXPLAIN não é possível na consulta: UPDATE e17c_content SET `hits` = (`hits` + 1) WHERE `id` = '401'Status Duration Starting 0.12 ms checking permissions 0.04 ms Opening tables 0.04 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.01 ms init for update 0.08 ms Updating 5.60 ms End of update loop 0.09 ms Query end 0.02 ms Commit 1.71 ms Query end 0.03 ms closing tables 0.01 ms Unlocking tables 0.02 ms closing tables 0.03 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.02 ms Updating status 0.04 ms Reset for next command 0.01 ms # Chamador Arquivo e número da linha 11 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Table/Table.php:1264 10 Joomla\CMS\Table\Table->hit() JROOT/components/com_content/models/article.php:254 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo da consulta: 7.86 ms Após última consulta: 7.52 ms Memória de consulta: 0.039 MB de memória antes da consulta: 4.104 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 e17c_content AS a
INNER JOIN e17c_categories AS c
on c.id = a.catid
LEFT JOIN e17c_users AS u
on u.id = a.created_by
LEFT JOIN e17c_categories as parent
ON parent.id = c.parent_id
LEFT JOIN e17c_content_rating AS v
ON a.id = v.content_id
WHERE a.id = 401
AND c.published > 0
AND a.language in ('pt-BR','*')
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-10-24 03:53:53')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-10-24 03:53:53')
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,idx_language 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.22 ms checking permissions 0.02 ms Opening tables 0.10 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.02 ms init 0.09 ms Optimizing 0.05 ms Statistics 6.61 ms Preparing 0.07 ms Unlocking tables 0.02 ms Preparing 0.03 ms Executing 0.01 ms Sending data 0.13 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.02 ms Updating status 0.03 ms Reset for next command 0.02 ms # Chamador Arquivo e número da linha 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 14 JDatabaseDriver->loadObject() JROOT/components/com_content/models/article.php:151 13 ContentModelArticle->getItem() JROOT/libraries/src/MVC/View/HtmlView.php:425 12 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_content/views/article/view.html.php:42 11 ContentViewArticle->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo da consulta: 7.74 ms Após última consulta: 1.20 ms Memória de consulta: 0.028 MB de memória antes da consulta: 4.162 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 `e17c_categories` AS `s`
INNER JOIN `e17c_categories` AS `c`
ON (s.lft < c.lft
AND c.lft < s.rgt
AND c.language IN ('pt-BR','*')) OR (c.lft <= s.lft
AND s.rgt <= c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1,2,3,5,8,9,10)
AND c.published = 1
AND s.id = 8
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 range cat_idx,idx_access,idx_left_right,idx_language idx_left_right 4 NULL 9 Using index condition; Using where Status Duration Starting 0.14 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.02 ms init 0.07 ms Optimizing 0.04 ms Statistics 6.50 ms Preparing 0.06 ms Unlocking tables 0.01 ms Preparing 0.07 ms Sorting result 0.04 ms Executing 0.02 ms Sending data 0.13 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.04 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.03 ms Updating status 0.04 ms Reset for next command 0.02 ms # Chamador Arquivo e número da linha 25 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 24 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 23 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 22 Joomla\CMS\Categories\Categories->get() JROOT/components/com_content/router.php:72 21 ContentRouter->getCategorySegment() Igual à chamada na linha abaixo. 20 call_user_func_array() JROOT/libraries/src/Component/Router/RouterView.php:120 19 Joomla\CMS\Component\Router\RouterView->getPath() JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 18 Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() JROOT/libraries/src/Component/Router/RouterView.php:222 17 Joomla\CMS\Component\Router\RouterView->preprocess() JROOT/libraries/src/Router/SiteRouter.php:676 16 Joomla\CMS\Router\SiteRouter->processBuildRules() JROOT/libraries/src/Router/Router.php:266 15 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155 14 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 13 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 12 Joomla\CMS\Router\Route::_() JROOT/components/com_content/views/article/view.html.php:71 11 ContentViewArticle->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo da consulta: 6.75 ms Após última consulta: 0.63 ms Memória de consulta: 0.022 MB de memória antes da consulta: 4.204 MB Linhas retornadas: 0
SELECT `m`.`tag_id`,`t`.*
FROM `e17c_contentitem_tag_map` AS m
INNER JOIN `e17c_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 401
AND `t`.`published` = 1
AND t.access IN (1,1,2,3,5,8,9,10)id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ALL idx_tag_type NENHUMA CHAVE DE ÍNDICE PÔDE SER USADA NULL NULL 1 Using where 1 SIMPLE t eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 dgti_ufla_br2.m.tag_id 1 Using where Status Duration Starting 0.09 ms checking permissions 0.02 ms Opening tables 0.06 ms After opening tables 0.03 ms System lock 0.02 ms table lock 0.02 ms init 0.06 ms Optimizing 0.04 ms Statistics 3.87 ms Preparing 0.09 ms Executing 0.01 ms Sending data 1.95 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.03 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.02 ms Starting cleanup 0.01 ms Freeing items 0.03 ms Updating status 0.04 ms Reset for next command 0.01 ms # Chamador Arquivo e número da linha 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 13 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Helper/TagsHelper.php:454 12 Joomla\CMS\Helper\TagsHelper->getItemTags() JROOT/components/com_content/views/article/view.html.php:184 11 ContentViewArticle->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo da consulta: 7.00 ms Após última consulta: 2.14 ms Memória de consulta: 0.026 MB de memória antes da consulta: 4.252 MB Linhas retornadas: 0
SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM e17c_fields AS a
LEFT JOIN `e17c_languages` AS l
ON l.lang_code = a.language
LEFT JOIN e17c_users AS uc
ON uc.id=a.checked_out
LEFT JOIN e17c_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN e17c_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN e17c_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `e17c_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 (8,0))
AND a.access IN (1,1,2,3,5,8,9,10)
AND (a.group_id = 0 OR g.access IN (1,1,2,3,5,8,9,10))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ref idx_state,idx_access,idx_context idx_state 1 const 1 Using where; Using temporary; Usando filesort 1 SIMPLE l eq_ref idx_langcode idx_langcode 28 dgti_ufla_br2.a.language 1 Using where 1 SIMPLE uc eq_ref PRIMARY PRIMARY 4 dgti_ufla_br2.a.checked_out 1 1 SIMPLE ag eq_ref PRIMARY PRIMARY 4 dgti_ufla_br2.a.access 1 Using where 1 SIMPLE ua eq_ref PRIMARY PRIMARY 4 dgti_ufla_br2.a.created_user_id 1 Using where 1 SIMPLE g eq_ref PRIMARY PRIMARY 4 dgti_ufla_br2.a.group_id 1 Using where 1 SIMPLE fc ref PRIMARY PRIMARY 4 dgti_ufla_br2.a.id 1 Using where; Using index; Distinct Status Duration Starting 0.19 ms checking permissions 0.02 ms Opening tables 0.10 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.03 ms init 0.07 ms Optimizing 0.05 ms Statistics 5.04 ms Preparing 0.10 ms Creating tmp table 0.11 ms Sorting result 0.02 ms Executing 0.01 ms Sending data 0.51 ms Creating sort index 0.06 ms Removing tmp table 0.11 ms Creating sort index 0.02 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.02 ms Starting cleanup 0.01 ms Freeing items 0.03 ms Updating status 0.08 ms Reset for next command 0.02 ms # Chamador Arquivo e número da linha 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 19 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 18 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_fields/models/fields.php:333 17 FieldsModelFields->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:194 16 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 15 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:495 14 PlgSystemFields->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 13 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 12 JEventDispatcher->trigger() JROOT/components/com_content/views/article/view.html.php:193 11 ContentViewArticle->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo da consulta: 43.46 ms Após última consulta: 14.82 ms Memória de consulta: 0.020 MB de memória antes da consulta: 4.444 MB Linhas retornadas: 1
SELECT language,id
FROM `e17c_menu`
WHERE home = 1
AND published = 1
AND client_id = 0id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE e17c_menu ALL idx_client_id_parent_id_alias_language NENHUMA CHAVE DE ÍNDICE PÔDE SER USADA NULL NULL 399 Using where Status Duration Starting 0.15 ms checking permissions 0.02 ms Opening tables 0.04 ms After opening tables 0.02 ms System lock 0.01 ms table lock 0.02 ms init 0.04 ms Optimizing 0.07 ms Statistics 9.05 ms Preparing 0.09 ms Executing 0.04 ms Sending data 33.16 ms End of update loop 0.07 ms Query end 0.03 ms Commit 0.02 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.02 ms Freeing items 0.02 ms Updating status 0.05 ms Reset for next command 0.02 ms # Chamador Arquivo e número da linha 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 9 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Language/Multilanguage.php:107 8 Joomla\CMS\Language\Multilanguage::getSiteHomePages() JROOT/plugins/system/languagefilter/languagefilter.php:751 7 PlgSystemLanguageFilter->onAfterDispatch() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/SiteApplication.php:199 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo da consulta: 0.88 ms Após última consulta: 0.38 ms Memória de consulta: 0.024 MB de memória antes da consulta: 4.452 MB Linhas retornadas: 1
SELECT `alias`
FROM `e17c_content`
WHERE id = '401'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE e17c_content const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.06 ms checking permissions 0.01 ms Opening tables 0.04 ms After opening tables 0.01 ms System lock 0.03 ms table lock 0.02 ms init 0.03 ms Optimizing 0.02 ms Statistics 0.06 ms Preparing 0.02 ms Unlocking tables 0.02 ms Preparing 0.03 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.05 ms Unlocking tables 0.01 ms closing tables 0.02 ms Query end 0.02 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.03 ms Reset for next command 0.02 ms # Chamador Arquivo e número da linha 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 18 JDatabaseDriver->loadResult() JROOT/components/com_content/router.php:125 17 ContentRouter->getArticleSegment() Igual à chamada na linha abaixo. 16 call_user_func_array() JROOT/libraries/src/Component/Router/RouterView.php:120 15 Joomla\CMS\Component\Router\RouterView->getPath() JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 14 Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() JROOT/libraries/src/Component/Router/RouterView.php:222 13 Joomla\CMS\Component\Router\RouterView->preprocess() JROOT/libraries/src/Router/SiteRouter.php:676 12 Joomla\CMS\Router\SiteRouter->processBuildRules() JROOT/libraries/src/Router/Router.php:266 11 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155 10 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 9 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 8 Joomla\CMS\Router\Route::_() JROOT/plugins/system/languagefilter/languagefilter.php:763 7 PlgSystemLanguageFilter->onAfterDispatch() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/SiteApplication.php:199 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo da consulta: 0.67 ms Após última consulta: 0.20 ms Memória de consulta: 0.024 MB de memória antes da consulta: 4.460 MB Linhas retornadas: 1
SELECT alias
FROM e17c_content
WHERE id=401id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE e17c_content const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.05 ms checking permissions 0.03 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.04 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.02 ms Executing 0.01 ms Sending data 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.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.04 ms Reset for next command 0.02 ms # Chamador Arquivo e número da linha 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 16 JDatabaseDriver->loadResult() JROOT/components/com_content/helpers/legacyrouter.php:140 15 ContentRouterRulesLegacy->build() JROOT/libraries/src/Component/Router/RouterView.php:244 14 Joomla\CMS\Component\Router\RouterView->build() JROOT/libraries/src/Router/SiteRouter.php:532 13 Joomla\CMS\Router\SiteRouter->buildSefRoute() JROOT/libraries/src/Router/SiteRouter.php:502 12 Joomla\CMS\Router\SiteRouter->_buildSefRoute() JROOT/libraries/src/Router/Router.php:281 11 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155 10 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 9 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 8 Joomla\CMS\Router\Route::_() JROOT/plugins/system/languagefilter/languagefilter.php:763 7 PlgSystemLanguageFilter->onAfterDispatch() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/SiteApplication.php:199 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo da consulta: 2.57 ms Após última consulta: 0.55 ms Memória de consulta: 0.021 MB de memória antes da consulta: 4.476 MB Linhas retornadas: 0
SELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`,CONCAT_WS(':', ca.id, ca.alias) AS `catid`
FROM `e17c_content` AS `c`
INNER JOIN `e17c_associations` AS `a`
ON a.id = c.`id`
AND a.context='com_content.item'
INNER JOIN `e17c_associations` AS `a2`
ON `a`.`key` = `a2`.`key`
INNER JOIN `e17c_content` AS `c2`
ON a2.id = c2.`id`
INNER JOIN `e17c_categories` AS `ca`
ON `c2`.`catid` = ca.id
AND ca.extension = 'com_content'
WHERE c.id = 401
AND c2.access IN (1,1,2,3,5,8,9,10)
AND c2.language != 'pt-BR'
AND (c2.publish_up = '0000-00-00 00:00:00' OR c2.publish_up <= '2026-10-24 03:53:53')
AND (c2.publish_down = '0000-00-00 00:00:00' OR c2.publish_down >= '2026-10-24 03:53:53')
AND c2.state = 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE NULL NULL NULL NENHUMA CHAVE DE ÍNDICE PÔDE SER USADA NULL NULL NULL Impossible WHERE noticed after reading const tables Status Duration Starting 0.15 ms checking permissions 0.02 ms Opening tables 0.08 ms After opening tables 0.02 ms System lock 0.01 ms table lock 0.01 ms init 0.08 ms Optimizing 0.06 ms Statistics 1.61 ms Preparing 0.03 ms Executing 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.02 ms Query end 0.02 ms Starting cleanup 0.01 ms Freeing items 0.02 ms Updating status 0.04 ms Reset for next command 0.02 ms # Chamador Arquivo e número da linha 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 10 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Language/Associations.php:115 9 Joomla\CMS\Language\Associations::getAssociations() JROOT/components/com_content/helpers/association.php:76 8 ContentHelperAssociation::getAssociations() JROOT/plugins/system/languagefilter/languagefilter.php:783 7 PlgSystemLanguageFilter->onAfterDispatch() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/SiteApplication.php:199 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo da consulta: 2.06 ms Após última consulta: 26.38 ms Memória de consulta: 0.026 MB de memória antes da consulta: 4.620 MB Linhas retornadas: 163Consultas duplicadas: #7
SHOW TABLES
EXPLAIN não é possível na consulta: SHOW TABLESStatus Duration Starting 0.15 ms checking permissions 0.03 ms Opening tables 0.06 ms After opening tables 0.02 ms System lock 0.01 ms table lock 0.02 ms init 0.02 ms Optimizing 0.02 ms Statistics 0.04 ms Preparing 0.03 ms Executing 0.02 ms Filling schema table 0.02 ms checking permissions 0.77 ms Executing 0.05 ms Sending data 0.10 ms End of update loop 0.02 ms Query end 0.01 ms closing tables 0.01 ms Removing tmp table 0.01 ms closing tables 0.04 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.07 ms Reset for next command 0.02 ms # Chamador Arquivo e número da linha 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 9 JDatabaseDriver->loadColumn() JROOT/libraries/joomla/database/driver/mysqli.php:505 8 JDatabaseDriverMysqli->getTableList() JROOT/plugins/system/samlredirect/samlredirect.php:41 7 plgSystemSamlredirect->onAfterRender() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1118 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo da consulta: 2.21 ms Após última consulta: 0.18 ms Memória de consulta: 0.021 MB de memória antes da consulta: 4.647 MB Linhas retornadas: 1
SELECT *
FROM `e17c_miniorange_saml_config`
WHERE `id` = 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE e17c_miniorange_saml_config const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.05 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 0.04 ms Optimizing 0.02 ms Statistics 1.44 ms Preparing 0.03 ms Unlocking tables 0.02 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.03 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.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.05 ms Reset for next command 0.01 ms # Chamador Arquivo e número da linha 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 9 JDatabaseDriver->loadAssoc() JROOT/administrator/components/com_miniorange_saml/helpers/mo-saml-utility.php:65 8 Mo_saml_Local_Util->_load_db_values() JROOT/plugins/system/samlredirect/samlredirect.php:54 7 plgSystemSamlredirect->onAfterRender() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1118 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
21 tipos de query registradas, sorteadas por ocorrências DESC
SELECT Tables:
2 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `e17c_assets`1 × SELECT `data`
FROM `e17c_session`1 × SELECT `session_id`
FROM `e17c_session`1 × SELECT id, rules
FROM `e17c_viewlevels1 × SELECT b.id
FROM e17c_usergroups AS a
LEFT JOIN e17c_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt1 × SELECT a.*,u.name AS editor,e.enabled AS enabled
FROM `e17c_externallogin_servers` as a
LEFT JOIN e17c_users AS u
ON u.id=a.checked_out
LEFT JOIN e17c_extensions AS e
ON `e`.`type`='plugin'
AND CONCAT_WS('.', `e`.`folder`, `e`.`element`)=`a`.`plugin`1 × SELECT *
FROM `e17c_miniorange_saml_customer_details`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 e17c_content AS a
INNER JOIN e17c_categories AS c
on c.id = a.catid
LEFT JOIN e17c_users AS u
on u.id = a.created_by
LEFT JOIN e17c_categories as parent
ON parent.id = c.parent_id
LEFT JOIN e17c_content_rating AS v
ON a.id = v.content_id1 × 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 `e17c_categories` AS `s`
INNER JOIN `e17c_categories` AS `c`
ON (s.lft < c.lft
AND c.lft < s.rgt
AND c.language IN ('pt-BR','*')) OR (c.lft <= s.lft
AND s.rgt <= c.rgt)1 × SELECT `m`.`tag_id`,`t`.*
FROM `e17c_contentitem_tag_map` AS m
INNER JOIN `e17c_tags` AS t
ON `m`.`tag_id` = `t`.`id`1 × SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM e17c_fields AS a
LEFT JOIN `e17c_languages` AS l
ON l.lang_code = a.language
LEFT JOIN e17c_users AS uc
ON uc.id=a.checked_out
LEFT JOIN e17c_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN e17c_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN e17c_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `e17c_fields_categories` AS fc
ON fc.field_id = a.id1 × SELECT language,id
FROM `e17c_menu`1 × SELECT `alias`
FROM `e17c_content`1 × SELECT alias
FROM e17c_content1 × SELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`,CONCAT_WS(':', ca.id, ca.alias) AS `catid`
FROM `e17c_content` AS `c`
INNER JOIN `e17c_associations` AS `a`
ON a.id = c.`id`
AND a.context='com_content.item'
INNER JOIN `e17c_associations` AS `a2`
ON `a`.`key` = `a2`.`key`
INNER JOIN `e17c_content` AS `c2`
ON a2.id = c2.`id`
INNER JOIN `e17c_categories` AS `ca`
ON `c2`.`catid` = ca.id
AND ca.extension = 'com_content'1 × SELECT *
FROM `e17c_miniorange_saml_config`
Outras Tabelas:
2 × SHOW TABLE
1 × INSERT INTO `e17c_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'363661766b6d31616d6d706f667270616d7331616f366e306364', 1, 1792814033, 0, '', 01 × UPDATE `e17c_extensions`
SET `params` = '{\"mediaversion\":\"d813f5edb63bf76194ade0403cd7b943\"}'1 × SHOW FULL COLUMNS
FROM `e17c_content1 × UPDATE e17c_content
SET `hits` = (`hits` + 1)