Endereço Repositório
Universidade Federal de Lavras
Campus Universitário
Biblioteca Universitária / Repositório Institucional
Caixa Postal: 3037
CEP:37200-900
Lavras - MG
- Você está aqui:
- Biblioteca
- Trâmites Pós-defesa
- Uncategorised
- Endereço Repositório
InÃcio do menu principal
Fim do menu principal
2017 - ( Biblioteca) Universidade Federal de Lavras
Console de depuração do Joomla!
{
"__default": {
"session": {
"counter": 1,
"timer": {
"start": 1579569481,
"last": 1579569481,
"now": 1579569481
}
},
"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: 13.41 ms / 13.41 ms Memória: 0.743 MB / 0.96 MB Application: afterLoad
Tempo: 193.21 ms / 206.62 ms Memória: 7.476 MB / 8.43 MB Application: afterInitialise
Tempo: 57.88 ms / 264.50 ms Memória: 1.781 MB / 10.22 MB Application: afterRoute
Tempo: 4.43 ms / 268.93 ms Memória: 0.066 MB / 10.28 MB Application: beforeRenderComponent com_content
Tempo: 10.08 ms / 279.01 ms Memória: 0.385 MB / 10.67 MB Application: Before JAccess::preloadComponents (all components)
Tempo: 8.18 ms / 287.19 ms Memória: 0.096 MB / 10.76 MB Application: After JAccess::preloadComponents (all components)
Tempo: 0.10 ms / 287.29 ms Memória: 0.000 MB / 10.76 MB Application: Before JAccess::getAssetRules (id:8 name:com_content)
Tempo: 1.91 ms / 289.20 ms Memória: 0.044 MB / 10.80 MB Application: After JAccess::getAssetRules (id:8 name:com_content)
Tempo: 101.13 ms / 390.33 ms Memória: 3.830 MB / 14.63 MB Application: Before JAccess::getAssetRules (id:1 name:root.1)
Tempo: 0.20 ms / 390.53 ms Memória: 0.009 MB / 14.64 MB Application: After JAccess::getAssetRules (id:1 name:root.1)
Tempo: 28.11 ms / 418.64 ms Memória: 1.248 MB / 15.89 MB Application: Before JAccess::preloadPermissions (com_content)
Tempo: 2.74 ms / 421.38 ms Memória: 0.196 MB / 16.08 MB Application: After JAccess::preloadPermissions (com_content)
Tempo: 0.17 ms / 421.56 ms Memória: 0.000 MB / 16.07 MB Application: Before JAccess::getAssetRules (id:228 name:com_content.article.101)
Tempo: 0.06 ms / 421.62 ms Memória: 0.003 MB / 16.08 MB Application: After JAccess::getAssetRules (id:228 name:com_content.article.101)
Tempo: 15.77 ms / 437.39 ms Memória: 0.471 MB / 16.55 MB Application: afterRenderComponent com_content
Tempo: 45.94 ms / 483.33 ms Memória: 1.374 MB / 17.92 MB Application: afterDispatch
Tempo: 6.11 ms / 489.44 ms Memória: 0.094 MB / 18.02 MB Application: beforeRenderModule mod_menu (Principais Serviços)
Tempo: 16.22 ms / 505.67 ms Memória: 0.331 MB / 18.35 MB Application: afterRenderModule mod_menu (Principais Serviços)
Tempo: 0.38 ms / 506.04 ms Memória: 0.000 MB / 18.34 MB Application: beforeRenderModule mod_menu (Principal)
Tempo: 9.96 ms / 516.01 ms Memória: 0.133 MB / 18.47 MB Application: afterRenderModule mod_menu (Principal)
Tempo: 0.15 ms / 516.16 ms Memória: 0.000 MB / 18.47 MB Application: beforeRenderModule mod_menu (Serviços)
Tempo: 7.84 ms / 523.99 ms Memória: 0.128 MB / 18.60 MB Application: afterRenderModule mod_menu (Serviços)
Tempo: 0.15 ms / 524.14 ms Memória: 0.000 MB / 18.59 MB Application: beforeRenderModule mod_menu (Recursos Tecnológicos)
Tempo: 6.18 ms / 530.32 ms Memória: 0.103 MB / 18.69 MB Application: afterRenderModule mod_menu (Recursos Tecnológicos)
Tempo: 0.29 ms / 530.61 ms Memória: 0.000 MB / 18.68 MB Application: beforeRenderModule mod_custom (logo-biblioteca)
Tempo: 1.58 ms / 532.19 ms Memória: 0.012 MB / 18.70 MB Application: afterRenderModule mod_custom (logo-biblioteca)
Tempo: 0.13 ms / 532.32 ms Memória: 0.000 MB / 18.69 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)
Tempo: 3.34 ms / 535.67 ms Memória: 0.091 MB / 18.78 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)
Tempo: 0.19 ms / 535.86 ms Memória: 0.000 MB / 18.77 MB Application: beforeRenderModule mod_menu (mod_header-menu-pt)
Tempo: 2.99 ms / 538.84 ms Memória: 0.073 MB / 18.85 MB Application: afterRenderModule mod_menu (mod_header-menu-pt)
Tempo: 0.13 ms / 538.98 ms Memória: 0.000 MB / 18.84 MB Application: beforeRenderModule mod_univers (Mostra ícones redes sociais)
Tempo: 0.68 ms / 539.65 ms Memória: 0.022 MB / 18.86 MB Application: afterRenderModule mod_univers (Mostra ícones redes sociais)
Tempo: 0.20 ms / 539.86 ms Memória: 0.000 MB / 18.85 MB Application: beforeRenderModule mod_search (Busca principal)
Tempo: 3.34 ms / 543.19 ms Memória: 0.058 MB / 18.91 MB Application: afterRenderModule mod_search (Busca principal)
Tempo: 0.18 ms / 543.37 ms Memória: 0.000 MB / 18.90 MB Application: beforeRenderModule mod_menu (mod-menu-acessibilidade)
Tempo: 2.17 ms / 545.54 ms Memória: 0.034 MB / 18.94 MB Application: afterRenderModule mod_menu (mod-menu-acessibilidade)
Tempo: 58.68 ms / 604.22 ms Memória: 0.375 MB / 19.31 MB Application: afterRender
Total de consultas ao banco de dados: 79.26 ms
19,48 MB (20.425.936 Bytes)
44 Queries Registradas 79.26 ms
- Tempo da consulta: 12.78 ms Memória de consulta: 0.008 MB de memória antes da consulta: 3.027 MB
DELETE
FROM `x17x_session`
WHERE `time` < '1579568581'EXPLAIN não é possível na consulta: DELETE FROM `x17x_session` WHERE `time` < '1579568581'Error MySql have_profiling = off # Chamador Arquivo e número da linha 6 JDatabaseDriverMysqli->execute() JROOT/libraries/cms/application/cms.php:822 5 JApplicationCms->loadSession() JROOT/libraries/cms/application/cms.php:131 4 JApplicationCms->__construct() JROOT/libraries/cms/application/site.php:63 3 JApplicationSite->__construct() JROOT/libraries/cms/application/cms.php:413 2 JApplicationCms::getInstance() JROOT/libraries/joomla/factory.php:125 1 JFactory::getApplication() JROOT/index.php:46 - Tempo da consulta: 0.32 ms Após última consulta: 1.15 ms Memória de consulta: 0.020 MB de memória antes da consulta: 3.057 MB Linhas retornadas: 0
SELECT `data`
FROM `x17x_session`
WHERE `session_id` = 'qivvsc0s601e3aoaod8um184q4'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE x17x_session const PRIMARY PRIMARY 575 const 1 Nenhum SHOW PROFILE (talvez porque existam mais de 100 consultas)# Chamador Arquivo e número da linha 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1720 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: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.44 ms Após última consulta: 3.10 ms Memória de consulta: 0.012 MB de memória antes da consulta: 3.200 MB Linhas retornadas: 0
SELECT `session_id`
FROM `x17x_session`
WHERE `session_id` = 'qivvsc0s601e3aoaod8um184q4'
LIMIT 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE x17x_session const PRIMARY PRIMARY 575 const 1 Using index Nenhum SHOW PROFILE (talvez porque existam mais de 100 consultas)# Chamador Arquivo e número da linha 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: 10.13 ms Após última consulta: 0.32 ms Memória de consulta: 0.009 MB de memória antes da consulta: 3.215 MB
INSERT INTO `x17x_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES ('qivvsc0s601e3aoaod8um184q4', 1, '1579569481', 0, '', 0)EXPLAIN não é possível na consulta: INSERT INTO `x17x_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('qivvsc0s601e3aoaod8um184q4', 1, '1579569481', 0, '', 0)Nenhum SHOW PROFILE (talvez porque existam mais de 100 consultas)# Chamador Arquivo e número da linha 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.60 ms Após última consulta: 4.51 ms Memória de consulta: 0.019 MB de memória antes da consulta: 3.463 MB Linhas retornadas: 41
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `x17x_extensions`
WHERE `type` = 'component'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE x17x_extensions ref extension extension 62 const 41 Using where Nenhum SHOW PROFILE (talvez porque existam mais de 100 consultas)# Chamador Arquivo e número da linha 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1681 10 JDatabaseDriver->loadObjectList() JROOT/libraries/cms/component/helper.php:447 9 JComponentHelper::{closure}() Igual à chamada na linha abaixo. 8 call_user_func_array() 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.29 ms Após última consulta: 4.05 ms Memória de consulta: 0.014 MB de memória antes da consulta: 3.749 MB Linhas retornadas: 5
SELECT id, rules
FROM `x17x_viewlevels`id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE x17x_viewlevels ALL NULL NENHUMA CHAVE DE ÍNDICE PÔDE SER USADA NULL NULL 5 Nenhum SHOW PROFILE (talvez porque existam mais de 100 consultas)# Chamador Arquivo e número da linha 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:309 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.25 ms Após última consulta: 0.22 ms Memória de consulta: 0.015 MB de memória antes da consulta: 3.773 MB Linhas retornadas: 2
SELECT b.id
FROM x17x_usergroups AS a
LEFT JOIN x17x_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 3 Using where; Using index Nenhum SHOW PROFILE (talvez porque existam mais de 100 consultas)# Chamador Arquivo e número da linha 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:309 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.48 ms Após última consulta: 1.20 ms Memória de consulta: 0.021 MB de memória antes da consulta: 3.867 MB Linhas retornadas: 95
SELECT `folder` AS `type`,`element` AS `name`,`params`
FROM x17x_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 x17x_extensions ref extension extension 62 const 108 Using where; Usando filesort Nenhum SHOW PROFILE (talvez porque existam mais de 100 consultas)# Chamador Arquivo e número da linha 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1681 10 JDatabaseDriver->loadObjectList() JROOT/libraries/cms/plugin/helper.php:327 9 JPluginHelper::{closure}() Igual à chamada na linha abaixo. 8 call_user_func_array() JROOT/libraries/joomla/cache/controller/callback.php:169 7 JCacheControllerCallback->get() JROOT/libraries/cms/plugin/helper.php:332 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.35 ms Após última consulta: 31.13 ms Memória de consulta: 0.019 MB de memória antes da consulta: 5.548 MB Linhas retornadas: 1Consultas duplicadas: #10
SELECT template
FROM x17x_template_styles as s
WHERE s.client_id = 0
AND s.home = 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE s ALL idx_home NENHUMA CHAVE DE ÍNDICE PÔDE SER USADA NULL NULL 5 Using where Nenhum SHOW PROFILE (talvez porque existam mais de 100 consultas)# Chamador Arquivo e número da linha 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1720 13 JDatabaseDriver->loadResult() JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:31 12 RokCommon_PlatformInfo_Joomla->getDefaultTemplate() JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:105 11 RokCommon_PlatformInfo_Joomla->setPlatformParameters() JROOT/libraries/rokcommon/RokCommon/Service.php:71 10 RokCommon_Service::getContainer() JROOT/libraries/rokcommon/include.php:38 9 require_once JROOT/libraries/rokcommon/include.php JROOT/plugins/system/rokcommon/rokcommon.php:96 8 plgSystemRokCommon->loadCommonLib() JROOT/plugins/system/rokcommon/rokcommon.php:54 7 plgSystemRokCommon->__construct() JROOT/libraries/cms/plugin/helper.php:271 6 JPluginHelper::import() JROOT/libraries/cms/plugin/helper.php:181 5 JPluginHelper::importPlugin() JROOT/libraries/cms/application/cms.php:683 4 JApplicationCms->initialiseApp() JROOT/libraries/cms/application/site.php:685 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.16 ms Após última consulta: 0.19 ms Memória de consulta: 0.020 MB de memória antes da consulta: 5.567 MB Linhas retornadas: 1Consultas duplicadas: #9
SELECT template
FROM x17x_template_styles as s
WHERE s.client_id = 0
AND s.home = 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE s ALL idx_home NENHUMA CHAVE DE ÍNDICE PÔDE SER USADA NULL NULL 5 Using where Nenhum SHOW PROFILE (talvez porque existam mais de 100 consultas)# Chamador Arquivo e número da linha 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1720 14 JDatabaseDriver->loadResult() JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:31 13 RokCommon_PlatformInfo_Joomla->getDefaultTemplate() JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:67 12 RokCommon_PlatformInfo_Joomla->getDefaultTemplatePath() JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:106 11 RokCommon_PlatformInfo_Joomla->setPlatformParameters() JROOT/libraries/rokcommon/RokCommon/Service.php:71 10 RokCommon_Service::getContainer() JROOT/libraries/rokcommon/include.php:38 9 require_once JROOT/libraries/rokcommon/include.php JROOT/plugins/system/rokcommon/rokcommon.php:96 8 plgSystemRokCommon->loadCommonLib() JROOT/plugins/system/rokcommon/rokcommon.php:54 7 plgSystemRokCommon->__construct() JROOT/libraries/cms/plugin/helper.php:271 6 JPluginHelper::import() JROOT/libraries/cms/plugin/helper.php:181 5 JPluginHelper::importPlugin() JROOT/libraries/cms/application/cms.php:683 4 JApplicationCms->initialiseApp() JROOT/libraries/cms/application/site.php:685 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.36 ms Após última consulta: 8.04 ms Memória de consulta: 0.015 MB de memória antes da consulta: 5.875 MB Linhas retornadas: 2
SELECT extension, file, type
FROM x17x_rokcommon_configs
ORDER BY priorityid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE x17x_rokcommon_configs ALL NULL NENHUMA CHAVE DE ÍNDICE PÔDE SER USADA NULL NULL 2 Usando filesort Nenhum SHOW PROFILE (talvez porque existam mais de 100 consultas)# Chamador Arquivo e número da linha 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1681 9 JDatabaseDriver->loadObjectList() JROOT/plugins/system/rokcommon/rokcommon.php:132 8 plgSystemRokCommon->processRegisteredConfigs() JROOT/plugins/system/rokcommon/rokcommon.php:76 7 plgSystemRokCommon->__construct() JROOT/libraries/cms/plugin/helper.php:271 6 JPluginHelper::import() JROOT/libraries/cms/plugin/helper.php:181 5 JPluginHelper::importPlugin() JROOT/libraries/cms/application/cms.php:683 4 JApplicationCms->initialiseApp() JROOT/libraries/cms/application/site.php:685 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.26 ms Após última consulta: 36.53 ms Memória de consulta: 0.014 MB de memória antes da consulta: 7.368 MB Linhas retornadas: 1
SELECT count(*)
FROM `x17x_cwgears_schedule`id 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 Select tables optimized away Nenhum SHOW PROFILE (talvez porque existam mais de 100 consultas)# Chamador Arquivo e número da linha 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1720 10 JDatabaseDriver->loadResult() JROOT/plugins/system/cwgears/cwgears.php:85 9 plgSystemCwgears->onAfterInitialise() Igual à chamada na linha abaixo. 8 call_user_func_array() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/joomla/application/base.php:106 5 JApplicationBase->triggerEvent() JROOT/libraries/cms/application/cms.php:684 4 JApplicationCms->initialiseApp() JROOT/libraries/cms/application/site.php:685 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.14 ms Após última consulta: 0.16 ms Memória de consulta: 0.014 MB de memória antes da consulta: 7.382 MB Linhas retornadas: 1
SELECT count(*)
FROM `x17x_cwgears_schedule`
WHERE time + '86400'<'1579569481'id 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 Nenhum SHOW PROFILE (talvez porque existam mais de 100 consultas)# Chamador Arquivo e número da linha 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1720 10 JDatabaseDriver->loadResult() JROOT/plugins/system/cwgears/cwgears.php:128 9 plgSystemCwgears->onAfterInitialise() Igual à chamada na linha abaixo. 8 call_user_func_array() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/joomla/application/base.php:106 5 JApplicationBase->triggerEvent() JROOT/libraries/cms/application/cms.php:684 4 JApplicationCms->initialiseApp() JROOT/libraries/cms/application/site.php:685 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.02 ms Após última consulta: 4.89 ms Memória de consulta: 0.023 MB de memória antes da consulta: 7.645 MB Linhas retornadas: 18
SHOW FULL COLUMNS
FROM `x17x_extensions`EXPLAIN não é possível na consulta: SHOW FULL COLUMNS FROM `x17x_extensions`Nenhum SHOW PROFILE (talvez porque existam mais de 100 consultas)# Chamador Arquivo e número da linha 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/joomla/table/extension.php:31 11 JTableExtension->__construct() JROOT/libraries/joomla/table/table.php:311 10 JTable::getInstance() JROOT/plugins/system/roksprocket/roksprocket.php:45 9 plgSystemRokSprocket->onAfterInitialise() Igual à chamada na linha abaixo. 8 call_user_func_array() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/joomla/application/base.php:106 5 JApplicationBase->triggerEvent() JROOT/libraries/cms/application/cms.php:684 4 JApplicationCms->initialiseApp() JROOT/libraries/cms/application/site.php:685 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.29 ms Após última consulta: 1.32 ms Memória de consulta: 0.016 MB de memória antes da consulta: 7.731 MB Linhas retornadas: 1
SELECT `extension_id`
FROM `x17x_extensions`
WHERE type = 'component'
AND element = 'com_roksprocket'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE x17x_extensions ref element_clientid,element_folder_clientid,extension element_clientid 302 const 1 Using where Nenhum SHOW PROFILE (talvez porque existam mais de 100 consultas)# Chamador Arquivo e número da linha 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1720 11 JDatabaseDriver->loadResult() JROOT/libraries/joomla/table/extension.php:120 10 JTableExtension->find() JROOT/plugins/system/roksprocket/roksprocket.php:49 9 plgSystemRokSprocket->onAfterInitialise() Igual à chamada na linha abaixo. 8 call_user_func_array() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/joomla/application/base.php:106 5 JApplicationBase->triggerEvent() JROOT/libraries/cms/application/cms.php:684 4 JApplicationCms->initialiseApp() JROOT/libraries/cms/application/site.php:685 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.17 ms Após última consulta: 0.24 ms Memória de consulta: 0.020 MB de memória antes da consulta: 7.749 MB Linhas retornadas: 1Consultas duplicadas: #18
SELECT *
FROM x17x_extensions
WHERE `extension_id` = '10040'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE x17x_extensions const PRIMARY PRIMARY 4 const 1 Nenhum SHOW PROFILE (talvez porque existam mais de 100 consultas)# Chamador Arquivo e número da linha 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1445 11 JDatabaseDriver->loadAssoc() JROOT/libraries/joomla/table/table.php:729 10 JTable->load() JROOT/plugins/system/roksprocket/roksprocket.php:54 9 plgSystemRokSprocket->onAfterInitialise() Igual à chamada na linha abaixo. 8 call_user_func_array() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/joomla/application/base.php:106 5 JApplicationBase->triggerEvent() JROOT/libraries/cms/application/cms.php:684 4 JApplicationCms->initialiseApp() JROOT/libraries/cms/application/site.php:685 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.21 ms Após última consulta: 0.22 ms Memória de consulta: 0.016 MB de memória antes da consulta: 7.763 MB Linhas retornadas: 1
SELECT `extension_id`
FROM `x17x_extensions`
WHERE type = 'module'
AND element = 'mod_roksprocket'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE x17x_extensions ref element_clientid,element_folder_clientid,extension element_clientid 302 const 1 Using where Nenhum SHOW PROFILE (talvez porque existam mais de 100 consultas)# Chamador Arquivo e número da linha 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1720 11 JDatabaseDriver->loadResult() JROOT/libraries/joomla/table/extension.php:120 10 JTableExtension->find() JROOT/plugins/system/roksprocket/roksprocket.php:72 9 plgSystemRokSprocket->onAfterInitialise() Igual à chamada na linha abaixo. 8 call_user_func_array() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/joomla/application/base.php:106 5 JApplicationBase->triggerEvent() JROOT/libraries/cms/application/cms.php:684 4 JApplicationCms->initialiseApp() JROOT/libraries/cms/application/site.php:685 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.18 ms Após última consulta: 0.27 ms Memória de consulta: 0.020 MB de memória antes da consulta: 7.779 MB Linhas retornadas: 1Consultas duplicadas: #16
SELECT *
FROM x17x_extensions
WHERE `extension_id` = '10040'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE x17x_extensions const PRIMARY PRIMARY 4 const 1 Nenhum SHOW PROFILE (talvez porque existam mais de 100 consultas)# Chamador Arquivo e número da linha 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1445 11 JDatabaseDriver->loadAssoc() JROOT/libraries/joomla/table/table.php:729 10 JTable->load() JROOT/plugins/system/roksprocket/roksprocket.php:76 9 plgSystemRokSprocket->onAfterInitialise() Igual à chamada na linha abaixo. 8 call_user_func_array() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/joomla/application/base.php:106 5 JApplicationBase->triggerEvent() JROOT/libraries/cms/application/cms.php:684 4 JApplicationCms->initialiseApp() JROOT/libraries/cms/application/site.php:685 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: 2.24 ms Após última consulta: 39.26 ms Memória de consulta: 0.035 MB de memória antes da consulta: 8.713 MB Linhas retornadas: 48
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 x17x_menu AS m
LEFT JOIN x17x_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 60 Using where; Usando filesort 1 SIMPLE e eq_ref PRIMARY PRIMARY 4 sitebiblioteca.m.component_id 1 Nenhum SHOW PROFILE (talvez porque existam mais de 100 consultas)# Chamador Arquivo e número da linha 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1681 18 JDatabaseDriver->loadObjectList() JROOT/libraries/cms/menu/site.php:88 17 JMenuSite->{closure}() Igual à chamada na linha abaixo. 16 call_user_func_array() 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.48 ms Após última consulta: 25.31 ms Memória de consulta: 0.025 MB de memória antes da consulta: 9.935 MB Linhas retornadas: 1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `x17x_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE x17x_extensions ref element_clientid,element_folder_clientid,extension extension 364 const,const 1 Using where Nenhum SHOW PROFILE (talvez porque existam mais de 100 consultas)# Chamador Arquivo e número da linha 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1642 19 JDatabaseDriver->loadObject() JROOT/libraries/cms/library/helper.php:166 18 JLibraryHelper::{closure}() Igual à chamada na linha abaixo. 17 call_user_func_array() JROOT/libraries/joomla/cache/controller/callback.php:169 16 JCacheControllerCallback->get() JROOT/libraries/cms/library/helper.php:174 15 JLibraryHelper::loadLibrary() JROOT/libraries/cms/library/helper.php:42 14 JLibraryHelper::getLibrary() JROOT/libraries/cms/library/helper.php:89 13 JLibraryHelper::getParams() JROOT/libraries/cms/version/version.php:270 12 JVersion->getMediaVersion() JROOT/libraries/joomla/factory.php:760 11 JFactory::createDocument() JROOT/libraries/joomla/factory.php:216 10 JFactory::getDocument() JROOT/plugins/system/cwgears/cwgears.php:181 9 plgSystemCwgears->onAfterRoute() Igual à chamada na linha abaixo. 8 call_user_func_array() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/joomla/application/base.php:106 5 JApplicationBase->triggerEvent() JROOT/libraries/cms/application/cms.php:1155 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: 18.05 ms Após última consulta: 0.46 ms Memória de consulta: 0.017 MB de memória antes da consulta: 9.942 MB
UPDATE `x17x_extensions`
SET `params` = '{\"mediaversion\":\"ae4d9ecf6feaef2dc8ddc29d7552c3c2\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'EXPLAIN não é possível na consulta: UPDATE `x17x_extensions` SET `params` = '{\"mediaversion\":\"ae4d9ecf6feaef2dc8ddc29d7552c3c2\"}' WHERE `type` = 'library' AND `element` = 'joomla'Nenhum SHOW PROFILE (talvez porque existam mais de 100 consultas)# Chamador Arquivo e número da linha 15 JDatabaseDriverMysqli->execute() JROOT/libraries/cms/library/helper.php:116 14 JLibraryHelper::saveParams() JROOT/libraries/cms/version/version.php:321 13 JVersion->setMediaVersion() JROOT/libraries/cms/version/version.php:280 12 JVersion->getMediaVersion() JROOT/libraries/joomla/factory.php:760 11 JFactory::createDocument() JROOT/libraries/joomla/factory.php:216 10 JFactory::getDocument() JROOT/plugins/system/cwgears/cwgears.php:181 9 plgSystemCwgears->onAfterRoute() Igual à chamada na linha abaixo. 8 call_user_func_array() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/joomla/application/base.php:106 5 JApplicationBase->triggerEvent() JROOT/libraries/cms/application/cms.php:1155 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.35 ms Após última consulta: 5.25 ms Memória de consulta: 0.015 MB de memória antes da consulta: 10.204 MB Linhas retornadas: 1
SELECT count(*)
FROM `x17x_extensions`
WHERE `element` = 'cwgears'
AND `extension_id` = ''id 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 Nenhum SHOW PROFILE (talvez porque existam mais de 100 consultas)# Chamador Arquivo e número da linha 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1720 11 JDatabaseDriver->loadResult() JROOT/plugins/system/cwgears/cwgears.php:971 10 plgSystemCwgears->updateDownloadKeySub() JROOT/plugins/system/cwgears/cwgears.php:188 9 plgSystemCwgears->onAfterRoute() Igual à chamada na linha abaixo. 8 call_user_func_array() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/joomla/application/base.php:106 5 JApplicationBase->triggerEvent() JROOT/libraries/cms/application/cms.php:1155 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.30 ms Após última consulta: 0.77 ms Memória de consulta: 0.014 MB de memória antes da consulta: 10.238 MB Linhas retornadas: 2
SELECT *
FROM x17x_languages
WHERE published=1
ORDER BY ordering ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE x17x_languages ALL NULL NENHUMA CHAVE DE ÍNDICE PÔDE SER USADA NULL NULL 2 Using where; Usando filesort Nenhum SHOW PROFILE (talvez porque existam mais de 100 consultas)# Chamador Arquivo e número da linha 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.64 ms Após última consulta: 0.78 ms Memória de consulta: 0.010 MB de memória antes da consulta: 10.268 MB Linhas retornadas: 3
SELECT id, home, template, s.params
FROM x17x_template_styles as s
LEFT JOIN x17x_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 5 Using where 1 SIMPLE e ref element_clientid,element_folder_clientid,extension element_clientid 303 sitebiblioteca.s.template,const 1 Using where Nenhum SHOW PROFILE (talvez porque existam mais de 100 consultas)# Chamador Arquivo e número da linha 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: 6.78 ms Após última consulta: 12.90 ms Memória de consulta: 0.026 MB de memória antes da consulta: 10.673 MB Linhas retornadas: 41
SELECT `id`,`name`,`rules`,`parent_id`
FROM `x17x_assets`
WHERE `name` IN ('root.1','com_admin','com_ajax','com_allvideoshare','com_associations','com_banners','com_blankcomponent','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_djimageslider','com_fields','com_finder','com_installer','com_jce','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_phocadownload','com_phocagallery','com_plugins','com_postinstall','com_redirect','com_roksprocket','com_search','com_tags','com_templates','com_users','com_widgetkit','com_wrapper','com_yendifvideoshare')id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE x17x_assets ALL idx_asset_name NENHUMA CHAVE DE ÍNDICE PÔDE SER USADA NULL NULL 345 Using where Nenhum SHOW PROFILE (talvez porque existam mais de 100 consultas)# Chamador Arquivo e número da linha 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.75 ms Após última consulta: 4.69 ms Memória de consulta: 0.025 MB de memória antes da consulta: 10.878 MB Linhas retornadas: 30
SHOW FULL COLUMNS
FROM `x17x_content`EXPLAIN não é possível na consulta: SHOW FULL COLUMNS FROM `x17x_content`Nenhum SHOW PROFILE (talvez porque existam mais de 100 consultas)# Chamador Arquivo e número da linha 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.47 ms Após última consulta: 6.27 ms Memória de consulta: 0.023 MB de memória antes da consulta: 11.241 MB Linhas retornadas: 1
SELECT *
FROM x17x_content
WHERE `id` = '101'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE x17x_content const PRIMARY PRIMARY 4 const 1 Nenhum SHOW PROFILE (talvez porque existam mais de 100 consultas)# Chamador Arquivo e número da linha 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: 9.59 ms Após última consulta: 0.60 ms Memória de consulta: 0.014 MB de memória antes da consulta: 11.255 MB
UPDATE x17x_content
SET `hits` = (`hits` + 1)
WHERE `id` = '101'EXPLAIN não é possível na consulta: UPDATE x17x_content SET `hits` = (`hits` + 1) WHERE `id` = '101'Nenhum SHOW PROFILE (talvez porque existam mais de 100 consultas)# Chamador Arquivo e número da linha 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.68 ms Após última consulta: 4.09 ms Memória de consulta: 0.028 MB de memória antes da consulta: 11.459 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 x17x_content AS a
INNER JOIN x17x_categories AS c
on c.id = a.catid
LEFT JOIN x17x_users AS u
on u.id = a.created_by
LEFT JOIN x17x_categories as parent
ON parent.id = c.parent_id
LEFT JOIN x17x_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 <= '2020-01-21 01:18:02')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-01-21 01:18:02')
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 Nenhum SHOW PROFILE (talvez porque existam mais de 100 consultas)# Chamador Arquivo e número da linha 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.69 ms Após última consulta: 5.28 ms Memória de consulta: 0.035 MB de memória antes da consulta: 11.751 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 x17x_categories as c
LEFT JOIN x17x_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=2
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 Usando filesort 1 SIMPLE c ALL cat_idx,idx_access,idx_left_right NENHUMA CHAVE DE ÍNDICE PÔDE SER USADA NULL NULL 10 Using where Nenhum SHOW PROFILE (talvez porque existam mais de 100 consultas)# Chamador Arquivo e número da linha 23 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1681 22 JDatabaseDriver->loadObjectList() JROOT/libraries/legacy/categories/categories.php:304 21 JCategories->_load() JROOT/libraries/legacy/categories/categories.php:184 20 JCategories->get() JROOT/components/com_content/router.php:72 19 ContentRouter->getCategorySegment() Igual à chamada na linha abaixo. 18 call_user_func_array() 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.56 ms Após última consulta: 1.42 ms Memória de consulta: 0.024 MB de memória antes da consulta: 11.797 MB Linhas retornadas: 0
SELECT `m`.`tag_id`,`t`.*
FROM `x17x_contentitem_tag_map` AS m
INNER JOIN `x17x_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 10 Using where 1 SIMPLE m ref idx_tag_type idx_tag_type 4 sitebiblioteca.t.id 1 Using where Nenhum SHOW PROFILE (talvez porque existam mais de 100 consultas)# Chamador Arquivo e número da linha 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: 0.89 ms Após última consulta: 81.84 ms Memória de consulta: 0.031 MB de memória antes da consulta: 15.269 MB Linhas retornadas: 0
SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state
FROM x17x_fields AS a
LEFT JOIN `x17x_languages` AS l
ON l.lang_code = a.language
LEFT JOIN x17x_users AS uc
ON uc.id=a.checked_out
LEFT JOIN x17x_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN x17x_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN x17x_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `x17x_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 (2,0))
AND a.access IN (1,1,5)
AND (a.group_id = 0 OR g.access IN (1,1,5))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering 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; Usando filesort 1 SIMPLE l eq_ref idx_langcode idx_langcode 21 sitebiblioteca.a.language 1 1 SIMPLE uc eq_ref PRIMARY PRIMARY 4 sitebiblioteca.a.checked_out 1 1 SIMPLE ag eq_ref PRIMARY PRIMARY 4 sitebiblioteca.a.access 1 1 SIMPLE ua eq_ref PRIMARY PRIMARY 4 sitebiblioteca.a.created_user_id 1 1 SIMPLE g eq_ref PRIMARY PRIMARY 4 sitebiblioteca.a.group_id 1 Using where 1 SIMPLE fc ref PRIMARY PRIMARY 4 sitebiblioteca.a.id 1 Using where; Using index Nenhum SHOW PROFILE (talvez porque existam mais de 100 consultas)# Chamador Arquivo e número da linha 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1681 19 JDatabaseDriver->loadObjectList() JROOT/libraries/legacy/model/legacy.php:307 18 JModelLegacy->_getList() JROOT/administrator/components/com_fields/models/fields.php:326 17 FieldsModelFields->_getList() JROOT/libraries/legacy/model/list.php:186 16 JModelList->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:134 15 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:378 14 PlgSystemFields->onContentPrepare() Igual à chamada na linha abaixo. 13 call_user_func_array() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_content/views/article/view.html.php:190 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.03 ms Após última consulta: 13.84 ms Memória de consulta: 0.032 MB de memória antes da consulta: 15.894 MB Linhas retornadas: 115
SELECT `id`,`name`,`rules`,`parent_id`
FROM `x17x_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 x17x_assets ALL idx_asset_name,idx_parent_id NENHUMA CHAVE DE ÍNDICE PÔDE SER USADA NULL NULL 345 Using where Nenhum SHOW PROFILE (talvez porque existam mais de 100 consultas)# Chamador Arquivo e número da linha 21 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1681 20 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/access/access.php:357 19 JAccess::preloadPermissions() JROOT/libraries/joomla/access/access.php:224 18 JAccess::preload() JROOT/libraries/joomla/access/access.php:538 17 JAccess::getAssetRules() JROOT/libraries/joomla/access/access.php:181 16 JAccess::check() JROOT/libraries/joomla/user/user.php:393 15 JUser->authorise() JROOT/plugins/content/pagenavigation/pagenavigation.php:54 14 PlgContentPagenavigation->onContentBeforeDisplay() Igual à chamada na linha abaixo. 13 call_user_func_array() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_content/views/article/view.html.php:196 10 ContentViewArticle->display() JROOT/libraries/legacy/controller/legacy.php:671 9 JControllerLegacy->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:709 7 JControllerLegacy->execute() JROOT/components/com_content/content.php:39 6 require_once JROOT/components/com_content/content.php JROOT/libraries/cms/component/helper.php:389 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:364 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:265 1 JApplicationCms->execute() JROOT/index.php:49 - Tempo da consulta: 1.14 ms Após última consulta: 2.20 ms Memória de consulta: 0.022 MB de memória antes da consulta: 16.153 MB Linhas retornadas: 8
SELECT a.id, a.title, a.catid, a.language,
CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug,
CASE WHEN CHAR_LENGTH(cc.alias) != 0 THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as catslug
FROM x17x_content AS a
LEFT JOIN x17x_categories AS cc
ON cc.id = a.catid
WHERE a.catid = 2
AND a.state = 1
AND a.access IN (1,1,5)
AND (a.state = 1 OR a.state = -1)
AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2020-01-21 01:18:02')
AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2020-01-21 01:18:02')
ORDER BY
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END DESCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a index_merge idx_access,idx_state,idx_catid idx_catid,idx_state 4,1 NULL 4 Using intersect(idx_catid,idx_state); Using where; Usando filesort 1 SIMPLE cc const PRIMARY PRIMARY 4 const 1 Nenhum SHOW PROFILE (talvez porque existam mais de 100 consultas)# Chamador Arquivo e número da linha 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1681 15 JDatabaseDriver->loadObjectList() JROOT/plugins/content/pagenavigation/pagenavigation.php:159 14 PlgContentPagenavigation->onContentBeforeDisplay() Igual à chamada na linha abaixo. 13 call_user_func_array() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_content/views/article/view.html.php:196 10 ContentViewArticle->display() JROOT/libraries/legacy/controller/legacy.php:671 9 JControllerLegacy->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:709 7 JControllerLegacy->execute() JROOT/components/com_content/content.php:39 6 require_once JROOT/components/com_content/content.php JROOT/libraries/cms/component/helper.php:389 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:364 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:265 1 JApplicationCms->execute() JROOT/index.php:49 - Tempo da consulta: 1.42 ms Após última consulta: 11.89 ms Memória de consulta: 0.029 MB de memória antes da consulta: 16.641 MB Linhas retornadas: 11
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM x17x_modules AS m
LEFT JOIN x17x_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN x17x_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 <= '2020-01-21 01:18:02')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2020-01-21 01:18:02')
AND m.access IN (1,1,5)
AND m.client_id = 0
AND (mm.menuid = 197 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 17 Using where; Usando filesort 1 SIMPLE mm ref PRIMARY PRIMARY 4 sitebiblioteca.m.id 1 Using where; Using index 1 SIMPLE e ref element_clientid,element_folder_clientid element_clientid 303 sitebiblioteca.m.module,const 1 Using where Nenhum SHOW PROFILE (talvez porque existam mais de 100 consultas)# Chamador Arquivo e número da linha 21 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1681 20 JDatabaseDriver->loadObjectList() Igual à chamada na linha abaixo. 19 call_user_func_array() JROOT/libraries/joomla/cache/controller/callback.php:169 18 JCacheControllerCallback->get() JROOT/libraries/cms/module/helper.php:424 17 JModuleHelper::getModuleList() JROOT/libraries/cms/module/helper.php:360 16 JModuleHelper::load() JROOT/libraries/cms/module/helper.php:84 15 JModuleHelper::getModules() JROOT/templates/portalufla/html/com_content/article/default_.php:136 14 require JROOT/templates/portalufla/html/com_content/article/default_.php JROOT/templates/portalufla/html/com_content/article/default.php:22 13 include JROOT/templates/portalufla/html/com_content/article/default.php JROOT/libraries/legacy/view/legacy.php:694 12 JViewLegacy->loadTemplate() JROOT/libraries/legacy/view/legacy.php:229 11 JViewLegacy->display() JROOT/components/com_content/views/article/view.html.php:207 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.44 ms Após última consulta: 23.85 ms Memória de consulta: 0.020 MB de memória antes da consulta: 17.279 MB Linhas retornadas: 1
SELECT params
FROM x17x_extensions AS e
WHERE e.element='com_widgetkit'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE e ref element_clientid,element_folder_clientid element_clientid 302 const 1 Using where Nenhum SHOW PROFILE (talvez porque existam mais de 100 consultas)# Chamador Arquivo e número da linha 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1720 15 JDatabaseDriver->loadResult() JROOT/administrator/components/com_widgetkit/helpers/system.php:278 14 SystemWidgetkitHelper->_getParams() JROOT/administrator/components/com_widgetkit/helpers/system.php:54 13 SystemWidgetkitHelper->__construct() JROOT/administrator/components/com_widgetkit/classes/widgetkit.php:129 12 Widgetkit->loadHelper() JROOT/administrator/components/com_widgetkit/classes/widgetkit.php:76 11 Widgetkit->getHelper() JROOT/administrator/components/com_widgetkit/classes/widgetkit.php:137 10 Widgetkit->offsetGet() JROOT/administrator/components/com_widgetkit/widgetkit.php:17 9 require_once JROOT/administrator/components/com_widgetkit/widgetkit.php JROOT/plugins/system/widgetkit_system/widgetkit_system.php:20 8 plgSystemWidgetkit_System->onAfterDispatch() Igual à chamada na linha abaixo. 7 call_user_func_array() 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/site.php:196 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.31 ms Após última consulta: 1.86 ms Memória de consulta: 0.016 MB de memória antes da consulta: 17.318 MB Linhas retornadas: 1
SELECT id,template
FROM x17x_template_styles
WHERE client_id=0
AND home=1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE x17x_template_styles ALL idx_home NENHUMA CHAVE DE ÍNDICE PÔDE SER USADA NULL NULL 5 Using where Nenhum SHOW PROFILE (talvez porque existam mais de 100 consultas)# Chamador Arquivo e número da linha 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1642 11 JDatabaseDriver->loadObject() JROOT/administrator/components/com_widgetkit/helpers/system.php:78 10 SystemWidgetkitHelper->init() JROOT/administrator/components/com_widgetkit/widgetkit.php:17 9 require_once JROOT/administrator/components/com_widgetkit/widgetkit.php JROOT/plugins/system/widgetkit_system/widgetkit_system.php:20 8 plgSystemWidgetkit_System->onAfterDispatch() Igual à chamada na linha abaixo. 7 call_user_func_array() 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/site.php:196 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.36 ms Após última consulta: 31.60 ms Memória de consulta: 0.029 MB de memória antes da consulta: 18.152 MB Linhas retornadas: 1
SELECT `alias`
FROM `x17x_content`
WHERE id = '21'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE x17x_content const PRIMARY PRIMARY 4 const 1 Nenhum SHOW PROFILE (talvez porque existam mais de 100 consultas)# Chamador Arquivo e número da linha 23 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1720 22 JDatabaseDriver->loadResult() JROOT/components/com_content/router.php:125 21 ContentRouter->getArticleSegment() Igual à chamada na linha abaixo. 20 call_user_func_array() JROOT/libraries/cms/component/router/view.php:117 19 JComponentRouterView->getPath() JROOT/libraries/cms/component/router/rules/menu.php:82 18 JComponentRouterRulesMenu->preprocess() JROOT/libraries/cms/component/router/view.php:219 17 JComponentRouterView->preprocess() JROOT/libraries/cms/router/site.php:471 16 JRouterSite->buildRawRoute() JROOT/libraries/cms/router/router.php:513 15 JRouter->_buildRawRoute() JROOT/libraries/cms/router/router.php:276 14 JRouter->build() JROOT/libraries/cms/router/site.php:149 13 JRouterSite->build() JROOT/libraries/joomla/application/route.php:62 12 JRoute::_() JROOT/modules/mod_menu/helper.php:129 11 ModMenuHelper::getList() JROOT/modules/mod_menu/mod_menu.php:15 10 include JROOT/modules/mod_menu/mod_menu.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.45 ms Após última consulta: 0.50 ms Memória de consulta: 0.037 MB de memória antes da consulta: 18.184 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 x17x_categories as c
LEFT JOIN x17x_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=21
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 Nenhum SHOW PROFILE (talvez porque existam mais de 100 consultas)# Chamador Arquivo e número da linha 25 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1681 24 JDatabaseDriver->loadObjectList() JROOT/libraries/legacy/categories/categories.php:304 23 JCategories->_load() JROOT/libraries/legacy/categories/categories.php:184 22 JCategories->get() JROOT/components/com_content/router.php:72 21 ContentRouter->getCategorySegment() Igual à chamada na linha abaixo. 20 call_user_func_array() JROOT/libraries/cms/component/router/view.php:121 19 JComponentRouterView->getPath() JROOT/libraries/cms/component/router/rules/menu.php:82 18 JComponentRouterRulesMenu->preprocess() JROOT/libraries/cms/component/router/view.php:219 17 JComponentRouterView->preprocess() JROOT/libraries/cms/router/site.php:471 16 JRouterSite->buildRawRoute() JROOT/libraries/cms/router/router.php:513 15 JRouter->_buildRawRoute() JROOT/libraries/cms/router/router.php:276 14 JRouter->build() JROOT/libraries/cms/router/site.php:149 13 JRouterSite->build() JROOT/libraries/joomla/application/route.php:62 12 JRoute::_() JROOT/modules/mod_menu/helper.php:129 11 ModMenuHelper::getList() JROOT/modules/mod_menu/mod_menu.php:15 10 include JROOT/modules/mod_menu/mod_menu.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.31 ms Após última consulta: 37.91 ms Memória de consulta: 0.028 MB de memória antes da consulta: 18.745 MB Linhas retornadas: 1
SELECT `alias`
FROM `x17x_content`
WHERE id = '21'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE x17x_content const PRIMARY PRIMARY 4 const 1 Nenhum SHOW PROFILE (talvez porque existam mais de 100 consultas)# Chamador Arquivo e número da linha 22 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1720 21 JDatabaseDriver->loadResult() JROOT/components/com_content/router.php:125 20 ContentRouter->getArticleSegment() Igual à chamada na linha abaixo. 19 call_user_func_array() JROOT/libraries/cms/component/router/view.php:117 18 JComponentRouterView->getPath() JROOT/libraries/cms/component/router/rules/menu.php:82 17 JComponentRouterRulesMenu->preprocess() JROOT/libraries/cms/component/router/view.php:219 16 JComponentRouterView->preprocess() JROOT/libraries/cms/router/site.php:660 15 JRouterSite->processBuildRules() JROOT/libraries/cms/router/router.php:267 14 JRouter->build() JROOT/libraries/cms/router/site.php:149 13 JRouterSite->build() JROOT/libraries/joomla/application/route.php:62 12 JRoute::_() JROOT/modules/mod_breadcrumbs/helper.php:56 11 ModBreadCrumbsHelper::getList() JROOT/modules/mod_breadcrumbs/mod_breadcrumbs.php:16 10 include JROOT/modules/mod_breadcrumbs/mod_breadcrumbs.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.13 ms Após última consulta: 0.32 ms Memória de consulta: 0.029 MB de memória antes da consulta: 18.771 MB Linhas retornadas: 1
SELECT `alias`
FROM `x17x_content`
WHERE id = '21'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE x17x_content const PRIMARY PRIMARY 4 const 1 Nenhum SHOW PROFILE (talvez porque existam mais de 100 consultas)# Chamador Arquivo e número da linha 23 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1720 22 JDatabaseDriver->loadResult() JROOT/components/com_content/router.php:125 21 ContentRouter->getArticleSegment() Igual à chamada na linha abaixo. 20 call_user_func_array() JROOT/libraries/cms/component/router/view.php:117 19 JComponentRouterView->getPath() JROOT/libraries/cms/component/router/rules/menu.php:82 18 JComponentRouterRulesMenu->preprocess() JROOT/libraries/cms/component/router/view.php:219 17 JComponentRouterView->preprocess() JROOT/libraries/cms/router/site.php:471 16 JRouterSite->buildRawRoute() JROOT/libraries/cms/router/router.php:513 15 JRouter->_buildRawRoute() JROOT/libraries/cms/router/router.php:276 14 JRouter->build() JROOT/libraries/cms/router/site.php:149 13 JRouterSite->build() JROOT/libraries/joomla/application/route.php:62 12 JRoute::_() JROOT/modules/mod_breadcrumbs/helper.php:56 11 ModBreadCrumbsHelper::getList() JROOT/modules/mod_breadcrumbs/mod_breadcrumbs.php:16 10 include JROOT/modules/mod_breadcrumbs/mod_breadcrumbs.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.30 ms Após última consulta: 7.81 ms Memória de consulta: 0.029 MB de memória antes da consulta: 18.926 MB Linhas retornadas: 1
SELECT `alias`
FROM `x17x_content`
WHERE id = '21'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE x17x_content const PRIMARY PRIMARY 4 const 1 Nenhum SHOW PROFILE (talvez porque existam mais de 100 consultas)# Chamador Arquivo e número da linha 23 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1720 22 JDatabaseDriver->loadResult() JROOT/components/com_content/router.php:125 21 ContentRouter->getArticleSegment() Igual à chamada na linha abaixo. 20 call_user_func_array() JROOT/libraries/cms/component/router/view.php:117 19 JComponentRouterView->getPath() JROOT/libraries/cms/component/router/rules/menu.php:82 18 JComponentRouterRulesMenu->preprocess() JROOT/libraries/cms/component/router/view.php:219 17 JComponentRouterView->preprocess() JROOT/libraries/cms/router/site.php:471 16 JRouterSite->buildRawRoute() JROOT/libraries/cms/router/router.php:513 15 JRouter->_buildRawRoute() JROOT/libraries/cms/router/router.php:276 14 JRouter->build() JROOT/libraries/cms/router/site.php:149 13 JRouterSite->build() JROOT/libraries/joomla/application/route.php:62 12 JRoute::_() JROOT/templates/portalufla/html/mod_search/mod-ufla.php:31 11 require JROOT/templates/portalufla/html/mod_search/mod-ufla.php JROOT/modules/mod_search/mod_search.php:51 10 include JROOT/modules/mod_search/mod_search.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.33 ms Após última consulta: 7.45 ms Memória de consulta: 0.020 MB de memória antes da consulta: 19.144 MB Linhas retornadas: 0
SELECT uikit
FROM `x17x_cwgears`
WHERE url = 'http://www.biblioteca.ufla.br/site/index.php?option=com_content&view=article&id=101&catid=2&Itemid=197'id 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 Nenhum SHOW PROFILE (talvez porque existam mais de 100 consultas)# Chamador Arquivo e número da linha 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1720 15 JDatabaseDriver->loadResult() JROOT/plugins/system/cwgears/helpers/loadcount.php:65 14 CwGearsHelperLoadcount::getCounts() JROOT/plugins/system/cwgears/cwgears.php:398 13 plgSystemCwgears->onBeforeCompileHead() Igual à chamada na linha abaixo. 12 call_user_func_array() JROOT/libraries/joomla/event/event.php:70 11 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 10 JEventDispatcher->trigger() JROOT/libraries/joomla/application/base.php:106 9 JApplicationBase->triggerEvent() JROOT/libraries/joomla/document/renderer/html/head.php:63 8 JDocumentRendererHtmlHead->fetchHead() JROOT/libraries/joomla/document/renderer/html/head.php:34 7 JDocumentRendererHtmlHead->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.15 ms Após última consulta: 0.34 ms Memória de consulta: 0.020 MB de memória antes da consulta: 19.164 MB Linhas retornadas: 0
SELECT uikit_plus
FROM `x17x_cwgears`
WHERE url = 'http://www.biblioteca.ufla.br/site/index.php?option=com_content&view=article&id=101&catid=2&Itemid=197'id 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 Nenhum SHOW PROFILE (talvez porque existam mais de 100 consultas)# Chamador Arquivo e número da linha 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1720 15 JDatabaseDriver->loadResult() JROOT/plugins/system/cwgears/helpers/loadcount.php:65 14 CwGearsHelperLoadcount::getCounts() JROOT/plugins/system/cwgears/cwgears.php:407 13 plgSystemCwgears->onBeforeCompileHead() Igual à chamada na linha abaixo. 12 call_user_func_array() JROOT/libraries/joomla/event/event.php:70 11 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 10 JEventDispatcher->trigger() JROOT/libraries/joomla/application/base.php:106 9 JApplicationBase->triggerEvent() JROOT/libraries/joomla/document/renderer/html/head.php:63 8 JDocumentRendererHtmlHead->fetchHead() JROOT/libraries/joomla/document/renderer/html/head.php:34 7 JDocumentRendererHtmlHead->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
35 tipos de query registradas, sorteadas por ocorrências DESC
SELECT Tables:
4 × SELECT `alias`
FROM `x17x_content`2 × SELECT template
FROM x17x_template_styles as s2 × SELECT *
FROM x17x_extensions2 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `x17x_assets`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 x17x_categories as c
LEFT JOIN x17x_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`
FROM `x17x_extensions`2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `x17x_extensions`1 × SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state
FROM x17x_fields AS a
LEFT JOIN `x17x_languages` AS l
ON l.lang_code = a.language
LEFT JOIN x17x_users AS uc
ON uc.id=a.checked_out
LEFT JOIN x17x_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN x17x_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN x17x_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `x17x_fields_categories` AS fc
ON fc.field_id = a.id1 × SELECT `m`.`tag_id`,`t`.*
FROM `x17x_contentitem_tag_map` AS m
INNER JOIN `x17x_tags` AS t
ON `m`.`tag_id` = `t`.`id`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 x17x_content AS a
INNER JOIN x17x_categories AS c
on c.id = a.catid
LEFT JOIN x17x_users AS u
on u.id = a.created_by
LEFT JOIN x17x_categories as parent
ON parent.id = c.parent_id
LEFT JOIN x17x_content_rating AS v
ON a.id = v.content_id1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM x17x_modules AS m
LEFT JOIN x17x_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN x17x_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id1 × SELECT uikit
FROM `x17x_cwgears`1 × SELECT uikit_plus
FROM `x17x_cwgears`1 × SELECT id,template
FROM x17x_template_styles1 × SELECT params
FROM x17x_extensions AS e1 × SELECT *
FROM x17x_content1 × SELECT a.id, a.title, a.catid, a.language,
CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug,
CASE WHEN CHAR_LENGTH(cc.alias) != 0 THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as catslug
FROM x17x_content AS a
LEFT JOIN x17x_categories AS cc
ON cc.id = a.catid1 × SELECT *
FROM x17x_languages1 × SELECT `folder` AS `type`,`element` AS `name`,`params`
FROM x17x_extensions1 × SELECT b.id
FROM x17x_usergroups AS a
LEFT JOIN x17x_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt1 × SELECT id, rules
FROM `x17x_viewlevels1 × SELECT `session_id`
FROM `x17x_session`1 × SELECT extension, file, type
FROM x17x_rokcommon_configs1 × SELECT count(*)
FROM `x17x_cwgears_schedule1 × SELECT `data`
FROM `x17x_session`1 × SELECT count(*)
FROM `x17x_extensions`1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM x17x_menu AS m
LEFT JOIN x17x_extensions AS e
ON m.component_id = e.extension_id1 × SELECT count(*)
FROM `x17x_cwgears_schedule`1 × SELECT id, home, template, s.params
FROM x17x_template_styles as s
LEFT JOIN x17x_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
Outras Tabelas:
1 × SHOW FULL COLUMNS
FROM `x17x_content1 × UPDATE x17x_content
SET `hits` = (`hits` + 1)1 × UPDATE `x17x_extensions`
SET `params` = '{\"mediaversion\":\"ae4d9ecf6feaef2dc8ddc29d7552c3c2\"}'1 × SHOW FULL COLUMNS
FROM `x17x_extensions1 × INSERT INTO `x17x_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES ('qivvsc0s601e3aoaod8um184q4', 1, '1579569481', 0, '', 01 × DELETE
FROM `x17x_session`