Console de depuração do Joomla!
{
"__default": {
"session": {
"counter": 1,
"timer": {
"start": 1716191924,
"last": 1716191924,
"now": 1716191924
}
},
"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: 4.69 ms / 4.69 ms Memória: 0.065 MB / 0.43 MB Application: afterLoad
Tempo: 23.61 ms / 28.30 ms Memória: 0.879 MB / 1.31 MB Application: afterInitialise
Tempo: 4.32 ms / 32.62 ms Memória: 0.400 MB / 1.71 MB Application: afterRoute
Tempo: 7.66 ms / 40.28 ms Memória: 0.065 MB / 1.78 MB Application: beforeRenderComponent com_content
Tempo: 1.24 ms / 41.52 ms Memória: 0.114 MB / 1.89 MB Application: Before JAccess::preloadComponents (all components)
Tempo: 0.99 ms / 42.51 ms Memória: 0.053 MB / 1.94 MB Application: After JAccess::preloadComponents (all components)
Tempo: 0.04 ms / 42.55 ms Memória: 0.000 MB / 1.94 MB Application: Before JAccess::getAssetRules (id:8 name:com_content)
Tempo: 0.21 ms / 42.77 ms Memória: 0.009 MB / 1.95 MB Application: After JAccess::getAssetRules (id:8 name:com_content)
Tempo: 15.71 ms / 58.48 ms Memória: 0.488 MB / 2.44 MB Application: afterRenderComponent com_content
Tempo: 0.86 ms / 59.34 ms Memória: 0.031 MB / 2.47 MB Application: afterDispatch
Tempo: 2.89 ms / 62.24 ms Memória: 0.073 MB / 2.54 MB Application: beforeRenderModule mod_custom (address)
Tempo: 0.64 ms / 62.87 ms Memória: 0.046 MB / 2.59 MB Application: afterRenderModule mod_custom (address)
Tempo: 0.07 ms / 62.94 ms Memória: 0.000 MB / 2.56 MB Application: beforeRenderModule mod_bt_googlemaps (google-map)
Tempo: 1.28 ms / 64.22 ms Memória: 0.095 MB / 2.66 MB Application: afterRenderModule mod_bt_googlemaps (google-map)
Tempo: 0.06 ms / 64.29 ms Memória: 0.000 MB / 2.62 MB Application: beforeRenderModule mod_footer (site-map)
Tempo: 0.77 ms / 65.05 ms Memória: 0.050 MB / 2.67 MB Application: afterRenderModule mod_footer (site-map)
Tempo: 0.10 ms / 65.15 ms Memória: 0.000 MB / 2.65 MB Application: beforeRenderModule mod_ariextmenu (menu-div)
Tempo: 10.48 ms / 75.64 ms Memória: 0.431 MB / 3.08 MB Application: afterRenderModule mod_ariextmenu (menu-div)
Tempo: 0.04 ms / 75.68 ms Memória: 0.000 MB / 3.05 MB Application: beforeRenderModule mod_je_accordionmenu (menu-mobile)
Tempo: 9.61 ms / 85.29 ms Memória: 0.493 MB / 3.54 MB Application: afterRenderModule mod_je_accordionmenu (menu-mobile)
Tempo: 0.07 ms / 85.36 ms Memória: 0.000 MB / 3.51 MB Application: beforeRenderModule mod_jfontsize (jFontSize)
Tempo: 0.45 ms / 85.80 ms Memória: 0.007 MB / 3.51 MB Application: afterRenderModule mod_jfontsize (jFontSize)
Tempo: 0.06 ms / 85.86 ms Memória: 0.000 MB / 3.51 MB Application: beforeRenderModule mod_bt_smartsearch (BT Smart Search)
Tempo: 4.70 ms / 90.56 ms Memória: 0.116 MB / 3.63 MB Application: afterRenderModule mod_bt_smartsearch (BT Smart Search)
Tempo: 4.12 ms / 94.68 ms Memória: 0.231 MB / 3.86 MB Application: afterRender
Total de consultas ao banco de dados: 29.16 ms
4,23 MB (4.430.560 Bytes)
25 Queries Registradas 29.16 ms
- Tempo da consulta: 0.51 ms Memória de consulta: 0.025 MB de memória antes da consulta: 0.758 MB Linhas retornadas: 0
SELECT `data`
FROM `sap_session`
WHERE `session_id` = 'on76agj11qn0jpt7j0hm8sg7do'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.06 ms checking permissions 0.01 ms Opening tables 0.06 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.11 ms Preparing 0.01 ms Executing 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.02 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 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.27 ms Após última consulta: 0.41 ms Memória de consulta: 0.021 MB de memória antes da consulta: 0.774 MB Linhas retornadas: 0
SELECT `session_id`
FROM `sap_session`
WHERE `session_id` = 'on76agj11qn0jpt7j0hm8sg7do'
LIMIT 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE sap_session const PRIMARY PRIMARY 766 const 1 Using index 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.03 ms Preparing 0.01 ms Executing 0.02 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 8 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1720 7 JDatabaseDriver->loadResult() JROOT/libraries/cms/application/cms.php:176 6 JApplicationCms->checkSession() JROOT/libraries/cms/application/cms.php:831 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: 5.85 ms Após última consulta: 0.10 ms Memória de consulta: 0.003 MB de memória antes da consulta: 0.778 MB
INSERT INTO `sap_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES ('on76agj11qn0jpt7j0hm8sg7do', 1, '1716191924', 0, '', 0)EXPLAIN não é possível na consulta: INSERT INTO `sap_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('on76agj11qn0jpt7j0hm8sg7do', 1, '1716191924', 0, '', 0)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 for update 0.03 ms Update 0.12 ms End of update loop 0.01 ms Query end 0.00 ms Commit 5.48 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 7 JDatabaseDriverMysqli->execute() JROOT/libraries/cms/application/cms.php:216 6 JApplicationCms->checkSession() JROOT/libraries/cms/application/cms.php:831 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.71 ms Após última consulta: 0.57 ms Memória de consulta: 0.034 MB de memória antes da consulta: 0.867 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.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.01 ms Statistics 0.09 ms Preparing 0.03 ms Executing 0.01 ms Sending data 0.25 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.03 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.32 ms Após última consulta: 0.71 ms Memória de consulta: 0.023 MB de memória antes da consulta: 0.910 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.03 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.02 ms Preparing 0.01 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 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.47 ms Após última consulta: 0.12 ms Memória de consulta: 0.022 MB de memória antes da consulta: 0.922 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.05 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.02 ms System lock 0.01 ms table lock 0.01 ms init 0.03 ms Optimizing 0.03 ms Statistics 0.07 ms Preparing 0.01 ms Unlocking tables 0.00 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 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.79 ms Após última consulta: 0.21 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.03 ms Statistics 0.04 ms Preparing 0.03 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.01 ms Creating sort index 0.37 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/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.28 ms Após última consulta: 6.07 ms Memória de consulta: 0.091 MB de memória antes da consulta: 1.341 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.06 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.03 ms Optimizing 0.02 ms Statistics 0.06 ms Preparing 0.04 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.02 ms Creating sort index 0.73 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/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.37 ms Após última consulta: 2.87 ms Memória de consulta: 0.025 MB de memória antes da consulta: 1.731 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.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.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.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: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: 5.16 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\":\"a336d5b5ab451d1ddcbb6e3b1dabc706\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'EXPLAIN não é possível na consulta: UPDATE `sap_extensions` SET `params` = '{\"mediaversion\":\"a336d5b5ab451d1ddcbb6e3b1dabc706\"}' WHERE `type` = 'library' AND `element` = 'joomla'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.00 ms init for update 0.07 ms Updating 0.09 ms End of update loop 0.02 ms Query end 0.00 ms Commit 4.79 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/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.37 ms Após última consulta: 0.39 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.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.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.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 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.50 ms Após última consulta: 0.23 ms Memória de consulta: 0.021 MB de memória antes da consulta: 1.770 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.03 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.09 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 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.77 ms Após última consulta: 1.62 ms Memória de consulta: 0.030 MB de memória antes da consulta: 1.894 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.03 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.13 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.30 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.30 ms Após última consulta: 0.58 ms Memória de consulta: 0.035 MB de memória antes da consulta: 1.953 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.04 ms checking permissions 0.01 ms closing tables 0.01 ms Opening tables 0.49 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.00 ms Filling schema table 0.01 ms Opening tables 0.05 ms After opening tables 0.01 ms checking permissions 0.21 ms closing tables 0.02 ms Executing 0.00 ms Sending data 0.07 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.19 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.44 ms Após última consulta: 0.78 ms Memória de consulta: 0.070 MB de memória antes da consulta: 2.025 MB Linhas retornadas: 1
SELECT *
FROM sap_content
WHERE `id` = '101'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.08 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.05 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 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: 4.85 ms Após última consulta: 0.14 ms Memória de consulta: 0.005 MB de memória antes da consulta: 2.063 MB
UPDATE sap_content
SET `hits` = (`hits` + 1)
WHERE `id` = '101'EXPLAIN não é possível na consulta: UPDATE sap_content SET `hits` = (`hits` + 1) WHERE `id` = '101'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 for update 0.05 ms Updating 0.09 ms End of update loop 0.01 ms Query end 0.00 ms Commit 4.53 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 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.79 ms Após última consulta: 0.51 ms Memória de consulta: 0.056 MB de memória antes da consulta: 2.152 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 = 101
AND c.published > 0
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-05-20 07:58:44')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-05-20 07:58:44')
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.16 ms checking permissions 0.01 ms Opening tables 0.06 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.07 ms Optimizing 0.06 ms Statistics 0.14 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.06 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 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.70 ms Após última consulta: 0.90 ms Memória de consulta: 0.039 MB de memória antes da consulta: 2.213 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.12 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.58 ms Após última consulta: 0.37 ms Memória de consulta: 0.034 MB de memória antes da consulta: 2.245 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` = 101
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.01 ms Opening tables 0.05 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.12 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.03 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 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: 1.13 ms Após última consulta: 5.60 ms Memória de consulta: 0.027 MB de memória antes da consulta: 2.552 MB Linhas retornadas: 9
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 07:58:44')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-05-20 07:58:44')
AND m.access IN (1,1,5)
AND m.client_id = 0
AND (mm.menuid = 107 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.08 ms Optimizing 0.04 ms Statistics 0.08 ms Preparing 0.05 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.01 ms Creating sort index 0.56 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.33 ms Após última consulta: 0.18 ms Memória de consulta: 0.042 MB de memória antes da consulta: 2.553 MB Linhas retornadas: 1
SELECT `urls`,`images`,`title`,`introtext`
FROM `sap_content`
WHERE id = '101'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.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.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 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.52 ms Após última consulta: 24.77 ms Memória de consulta: 0.025 MB de memória antes da consulta: 3.540 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.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.06 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.40 ms Após última consulta: 2.22 ms Memória de consulta: 0.025 MB de memória antes da consulta: 3.631 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.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.02 ms Statistics 0.08 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.02 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 - Tempo da consulta: 0.29 ms Após última consulta: 3.47 ms Memória de consulta: 0.025 MB de memória antes da consulta: 3.820 MB Linhas retornadas: 1
SELECT `alias`
FROM `sap_content`
WHERE id = '101'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.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.04 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.01 ms Executing 0.00 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 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1720 16 JDatabaseDriver->loadResult() JROOT/components/com_content/router.php:125 15 ContentRouter->getArticleSegment() JROOT/libraries/cms/component/router/view.php:117 14 JComponentRouterView->getPath() JROOT/libraries/cms/component/router/rules/menu.php:82 13 JComponentRouterRulesMenu->preprocess() JROOT/libraries/cms/component/router/view.php:219 12 JComponentRouterView->preprocess() JROOT/libraries/cms/router/site.php:660 11 JRouterSite->processBuildRules() JROOT/libraries/cms/router/router.php:267 10 JRouter->build() JROOT/libraries/cms/router/site.php:149 9 JRouterSite->build() JROOT/libraries/joomla/application/route.php:62 8 JRoute::_() JROOT/plugins/system/sef/sef.php:110 7 PlgSystemSef->onAfterRender() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/joomla/application/base.php:106 4 JApplicationBase->triggerEvent() JROOT/libraries/cms/application/cms.php:1122 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.46 ms Após última consulta: 0.13 ms Memória de consulta: 0.036 MB de memória antes da consulta: 3.830 MB Linhas retornadas: 0
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=101
ORDER BY c.lftid 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.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.05 ms Optimizing 0.03 ms Statistics 0.04 ms Preparing 0.01 ms Executing 0.03 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 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1681 18 JDatabaseDriver->loadObjectList() JROOT/libraries/legacy/categories/categories.php:304 17 JCategories->_load() JROOT/libraries/legacy/categories/categories.php:184 16 JCategories->get() JROOT/components/com_content/router.php:72 15 ContentRouter->getCategorySegment() JROOT/libraries/cms/component/router/view.php:121 14 JComponentRouterView->getPath() JROOT/libraries/cms/component/router/rules/menu.php:82 13 JComponentRouterRulesMenu->preprocess() JROOT/libraries/cms/component/router/view.php:219 12 JComponentRouterView->preprocess() JROOT/libraries/cms/router/site.php:660 11 JRouterSite->processBuildRules() JROOT/libraries/cms/router/router.php:267 10 JRouter->build() JROOT/libraries/cms/router/site.php:149 9 JRouterSite->build() JROOT/libraries/joomla/application/route.php:62 8 JRoute::_() JROOT/plugins/system/sef/sef.php:110 7 PlgSystemSef->onAfterRender() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/joomla/application/base.php:106 4 JApplicationBase->triggerEvent() JROOT/libraries/cms/application/cms.php:1122 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
23 tipos de query registradas, sorteadas por ocorrências DESC
SELECT Tables:
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)2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `sap_extensions`1 × SELECT `data`
FROM `sap_session`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_id1 × SELECT `title`
FROM `sap_finder_taxonomy`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 `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 `id`,`name`,`rules`,`parent_id`
FROM `sap_assets`1 × SELECT *
FROM sap_content1 × SELECT `session_id`
FROM `sap_session`1 × 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 `alias`
FROM `sap_content`
Outras Tabelas:
1 × INSERT INTO `sap_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES ('on76agj11qn0jpt7j0hm8sg7do', 1, '1716191924', 0, '', 01 × UPDATE `sap_extensions`
SET `params` = '{\"mediaversion\":\"a336d5b5ab451d1ddcbb6e3b1dabc706\"}'1 × SHOW FULL COLUMNS
FROM `sap_content1 × UPDATE sap_content
SET `hits` = (`hits` + 1)