Casas de Madeira
Casas de Madeira de qualidade e com um design bastante moderno.
Disponível por encomenda
Departamento Executivo
Departamento Operacional
Termos e Políticas
Departamento Comercial
©
2018 - 2024
Casa Pré-Fabricada. Todos os direitos reservados.
Este site utiliza cookies. Ao continuar a navegar neste site, está a aceitar esta utilização dose cookies. Por favor consulte a nossa Política de Privacidade.
Concordo Não concordoConsola de depuração Joomla
{
"__default": {
"session": {
"counter": 1,
"timer": {
"start": 1722048386,
"last": 1722048386,
"now": 1722048386
},
"token": "SGX7vrQ74fnF7EbK2DbMtjpwlXkP2cYK"
},
"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
}
}
}
Hora
Memória
Hora: 31.49 ms / 31.49 ms Memória: 1.983 MB / 2.38 MB Application: afterLoad
Hora: 89.81 ms / 121.30 ms Memória: 6.679 MB / 9.06 MB Application: afterInitialise
Hora: 45.35 ms / 166.65 ms Memória: 3.395 MB / 12.45 MB Application: afterRoute
Hora: 1.18 ms / 167.83 ms Memória: 0.030 MB / 12.48 MB Application: beforeRenderComponent com_content
Hora: 8.74 ms / 176.57 ms Memória: 0.694 MB / 13.18 MB Application: Before Access::preloadComponents (all components)
Hora: 2.93 ms / 179.50 ms Memória: 0.063 MB / 13.24 MB Application: After Access::preloadComponents (all components)
Hora: 0.04 ms / 179.54 ms Memória: -0.005 MB / 13.23 MB Application: Before Access::preloadPermissions (com_content)
Hora: 2.51 ms / 182.05 ms Memória: 0.309 MB / 13.54 MB Application: After Access::preloadPermissions (com_content)
Hora: 0.06 ms / 182.11 ms Memória: -0.019 MB / 13.52 MB Application: Before Access::getAssetRules (id:737 name:com_content.category.18)
Hora: 0.77 ms / 182.88 ms Memória: 0.039 MB / 13.56 MB Application: After Access::getAssetRules (id:737 name:com_content.category.18)
Hora: 12.41 ms / 195.29 ms Memória: 0.209 MB / 13.77 MB Application: Before Access::getAssetRules (id:8 name:com_content)
Hora: 0.02 ms / 195.31 ms Memória: 0.002 MB / 13.77 MB Application: After Access::getAssetRules (id:8 name:com_content)
Hora: 63.33 ms / 258.64 ms Memória: 3.319 MB / 17.09 MB Application: afterRenderComponent com_content
Hora: 1.28 ms / 259.92 ms Memória: 0.038 MB / 17.13 MB Application: Before Access::getAssetRules (id:1 name:root.1)
Hora: 0.04 ms / 259.95 ms Memória: 0.007 MB / 17.14 MB Application: After Access::getAssetRules (id:1 name:root.1)
Hora: 13.76 ms / 273.72 ms Memória: 0.517 MB / 17.66 MB Application: afterDispatch
Hora: 51.22 ms / 324.94 ms Memória: 4.841 MB / 22.50 MB Application: beforeRenderModule mod_gantry5_particle ( Casas de Madeira Banner)
Hora: 2.29 ms / 327.24 ms Memória: 0.093 MB / 22.59 MB Application: afterRenderModule mod_gantry5_particle ( Casas de Madeira Banner)
Hora: 2.33 ms / 329.57 ms Memória: 0.015 MB / 22.60 MB Application: beforeRenderModule mod_gantry5_particle (Ohara Logo)
Hora: 1.19 ms / 330.76 ms Memória: 0.019 MB / 22.62 MB Application: afterRenderModule mod_gantry5_particle (Ohara Logo)
Hora: 0.23 ms / 330.99 ms Memória: -0.001 MB / 22.62 MB Application: beforeRenderModule mod_gantry5_particle (Irm Logo)
Hora: 0.72 ms / 331.71 ms Memória: 0.006 MB / 22.63 MB Application: afterRenderModule mod_gantry5_particle (Irm Logo)
Hora: 0.24 ms / 331.95 ms Memória: -0.000 MB / 22.63 MB Application: beforeRenderModule mod_gantry5_particle (FP Social)
Hora: 1.09 ms / 333.04 ms Memória: 0.036 MB / 22.66 MB Application: afterRenderModule mod_gantry5_particle (FP Social)
Hora: 0.45 ms / 333.48 ms Memória: 0.078 MB / 22.74 MB Application: beforeRenderModule mod_gantry5_particle (Copyright Sede)
Hora: 1.16 ms / 334.64 ms Memória: 0.040 MB / 22.78 MB Application: afterRenderModule mod_gantry5_particle (Copyright Sede)
Hora: 0.04 ms / 334.68 ms Memória: -0.001 MB / 22.78 MB Application: beforeRenderModule mod_gantry5_particle (Copyright Direcao)
Hora: 0.67 ms / 335.35 ms Memória: 0.008 MB / 22.79 MB Application: afterRenderModule mod_gantry5_particle (Copyright Direcao)
Hora: 0.23 ms / 335.57 ms Memória: 0.000 MB / 22.79 MB Application: beforeRenderModule mod_gantry5_particle (Copyright Horário)
Hora: 0.66 ms / 336.24 ms Memória: 0.008 MB / 22.80 MB Application: afterRenderModule mod_gantry5_particle (Copyright Horário)
Hora: 0.04 ms / 336.28 ms Memória: -0.001 MB / 22.80 MB Application: beforeRenderModule mod_gantry5_particle (Copyright Operação)
Hora: 0.69 ms / 336.97 ms Memória: 0.008 MB / 22.80 MB Application: afterRenderModule mod_gantry5_particle (Copyright Operação)
Hora: 0.21 ms / 337.19 ms Memória: 0.000 MB / 22.81 MB Application: beforeRenderModule mod_gantry5_particle (Copyright Termos)
Hora: 0.69 ms / 337.88 ms Memória: 0.011 MB / 22.82 MB Application: afterRenderModule mod_gantry5_particle (Copyright Termos)
Hora: 0.03 ms / 337.91 ms Memória: -0.001 MB / 22.82 MB Application: beforeRenderModule mod_gantry5_particle (Copyright Comercial)
Hora: 0.64 ms / 338.55 ms Memória: 0.008 MB / 22.82 MB Application: afterRenderModule mod_gantry5_particle (Copyright Comercial)
Hora: 1590.82 ms / 1929.37 ms Memória: 16.311 MB / 39.13 MB Application: afterRender
Total de consultas à base de dados: 52.28 ms
33,44 MB (35 065 088 Bytes)
34 pedidos registados 52.28 ms
- Tempo da consulta: 0.72 ms Consulta a Memória: 0.023 MB de memória antes da consulta: 4.150 MB Linhas devolvidas: 0
SELECT `data`
FROM `t6nzp_session`
WHERE `session_id` = X'6632633435653263366634393632666337616237386664303734613362323939'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE t6nzp_session const PRIMARY PRIMARY 194 const 1 Status Duration Starting 0.05 ms checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.02 ms System lock 0.01 ms table lock 0.02 ms init 0.02 ms Optimizing 0.02 ms Statistics 0.32 ms Preparing 0.01 ms Executing 0.02 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.02 ms # Chamador Ficheiro e número da linha 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 15 JDatabaseDriver->loadResult() JROOT/libraries/joomla/session/storage/database.php:45 14 JSessionStorageDatabase->read() Igual à chamada na linha abaixo. 13 session_start() JROOT/libraries/joomla/session/handler/native.php:260 12 JSessionHandlerNative->doSessionStart() JROOT/libraries/joomla/session/handler/native.php:50 11 JSessionHandlerNative->start() JROOT/libraries/joomla/session/handler/joomla.php:88 10 JSessionHandlerJoomla->start() JROOT/libraries/src/Session/Session.php:661 9 Joomla\CMS\Session\Session->_start() JROOT/libraries/src/Session/Session.php:621 8 Joomla\CMS\Session\Session->start() JROOT/libraries/src/Session/Session.php:499 7 Joomla\CMS\Session\Session->get() JROOT/libraries/src/Session/Session.php:456 6 Joomla\CMS\Session\Session->isNew() JROOT/libraries/src/Application/CMSApplication.php:826 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:136 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:386 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Tempo da consulta: 0.33 ms Após a última consulta: 1.26 ms Consulta a Memória: 0.020 MB de memória antes da consulta: 4.245 MB Linhas devolvidas: 0
SELECT `session_id`
FROM `t6nzp_session`
WHERE `session_id` = X'6632633435653263366634393632666337616237386664303734613362323939'
LIMIT 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE t6nzp_session const PRIMARY PRIMARY 194 const 1 Using index 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.03 ms Preparing 0.02 ms Executing 0.01 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Chamador Ficheiro e número da linha 9 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 8 JDatabaseDriver->loadResult() JROOT/libraries/src/Session/MetadataManager.php:74 7 Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() JROOT/libraries/src/Application/CMSApplication.php:154 6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:828 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:136 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:386 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Tempo da consulta: 0.66 ms Após a última consulta: 0.10 ms Consulta a Memória: 0.004 MB de memória antes da consulta: 4.251 MB
INSERT INTO `t6nzp_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'6632633435653263366634393632666337616237386664303734613362323939', 1, 1722048386, 0, '', 0)EXPLAIN não é possível na consulta: INSERT INTO `t6nzp_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'6632633435653263366634393632666337616237386664303734613362323939', 1, 1722048386, 0, '', 0)Status Duration Starting 0.04 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init for update 0.02 ms Update 0.28 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.13 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Chamador Ficheiro e número da linha 8 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Session/MetadataManager.php:116 7 Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() JROOT/libraries/src/Application/CMSApplication.php:154 6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:828 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:136 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:386 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Tempo da consulta: 2.37 ms Após a última consulta: 2.34 ms Consulta a Memória: 0.025 MB de memória antes da consulta: 4.501 MB Linhas devolvidas: 42
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `t6nzp_extensions`
WHERE `type` = 'component'
AND `state` = 0
AND `enabled` = 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE t6nzp_extensions ref extension extension 82 const 42 Using index condition; 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.02 ms Optimizing 0.02 ms Statistics 0.26 ms Preparing 0.03 ms Executing 0.01 ms Sending data 1.69 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Chamador Ficheiro e número da linha 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Component/ComponentHelper.php:445 10 Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}() Igual à chamada na linha abaixo. 9 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 8 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Component/ComponentHelper.php:453 7 Joomla\CMS\Component\ComponentHelper::load() JROOT/libraries/src/Component/ComponentHelper.php:519 6 Joomla\CMS\Component\ComponentHelper::getComponents() JROOT/libraries/src/Component/ComponentHelper.php:44 5 Joomla\CMS\Component\ComponentHelper::getComponent() JROOT/libraries/src/Component/ComponentHelper.php:103 4 Joomla\CMS\Component\ComponentHelper::getParams() JROOT/libraries/src/Application/SiteApplication.php:594 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo da consulta: 0.64 ms Após a última consulta: 2.30 ms Consulta a Memória: 0.021 MB de memória antes da consulta: 4.692 MB Linhas devolvidas: 5
SELECT id, rules
FROM `t6nzp_viewlevels`id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE t6nzp_viewlevels ALL NULL Nenhuma chave INDEX KEY pode ser utilizada NULL NULL 5 Status Duration Starting 0.03 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.01 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.01 ms Executing 0.01 ms Sending data 0.27 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Chamador Ficheiro e número da linha 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506 9 JDatabaseDriver->loadAssocList() JROOT/libraries/src/Access/Access.php:1063 8 Joomla\CMS\Access\Access::getAuthorisedViewLevels() JROOT/libraries/src/User/User.php:458 7 Joomla\CMS\User\User->getAuthorisedViewLevels() JROOT/libraries/src/Plugin/PluginHelper.php:318 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo da consulta: 0.79 ms Após a última consulta: 0.10 ms Consulta a Memória: 0.021 MB de memória antes da consulta: 4.704 MB Linhas devolvidas: 2
SELECT b.id
FROM t6nzp_usergroups AS a
LEFT JOIN t6nzp_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 9id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a const PRIMARY PRIMARY 4 const 1 1 SIMPLE b range idx_usergroup_nested_set_lookup idx_usergroup_nested_set_lookup 4 NULL 2 Using where; Using index Status Duration Starting 0.04 ms checking permissions 0.01 ms Opening tables 0.03 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.43 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.03 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Chamador Ficheiro e número da linha 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 10 JDatabaseDriver->loadColumn() JROOT/libraries/src/Access/Access.php:980 9 Joomla\CMS\Access\Access::getGroupsByUser() JROOT/libraries/src/Access/Access.php:1095 8 Joomla\CMS\Access\Access::getAuthorisedViewLevels() JROOT/libraries/src/User/User.php:458 7 Joomla\CMS\User\User->getAuthorisedViewLevels() JROOT/libraries/src/Plugin/PluginHelper.php:318 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo da consulta: 1.51 ms Após a última consulta: 0.68 ms Consulta a Memória: 0.035 MB de memória antes da consulta: 4.773 MB Linhas devolvidas: 177
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM t6nzp_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 t6nzp_extensions ALL extension Nenhuma chave INDEX KEY pode ser utilizada NULL NULL 324 Using where; Modo Filesort em uso Status Duration Starting 0.05 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.03 ms Optimizing 0.02 ms Statistics 0.04 ms Preparing 0.02 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.01 ms Creating sort index 1.08 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Chamador Ficheiro e número da linha 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 10 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Plugin/PluginHelper.php:351 9 Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}() Igual à chamada na linha abaixo. 8 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 7 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Plugin/PluginHelper.php:356 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo da consulta: 1.21 ms Após a última consulta: 18.22 ms Consulta a Memória: 0.022 MB de memória antes da consulta: 6.760 MB Linhas devolvidas: 1Consultas duplicadas: #9
SELECT template
FROM t6nzp_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_client_id,idx_client_id_home Nenhuma chave INDEX KEY pode ser utilizada NULL NULL 15 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.02 ms Optimizing 0.02 ms Statistics 0.52 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.27 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Chamador Ficheiro e número da linha 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 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:95 8 plgSystemRokCommon->loadCommonLib() JROOT/plugins/system/rokcommon/rokcommon.php:53 7 plgSystemRokCommon->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:280 6 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 5 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/libraries/src/Application/CMSApplication.php:667 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo da consulta: 0.35 ms Após a última consulta: 0.10 ms Consulta a Memória: 0.023 MB de memória antes da consulta: 6.768 MB Linhas devolvidas: 1Consultas duplicadas: #8
SELECT template
FROM t6nzp_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_client_id,idx_client_id_home Nenhuma chave INDEX KEY pode ser utilizada NULL NULL 15 Using where 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.04 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.03 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Chamador Ficheiro e número da linha 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 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:95 8 plgSystemRokCommon->loadCommonLib() JROOT/plugins/system/rokcommon/rokcommon.php:53 7 plgSystemRokCommon->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:280 6 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 5 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/libraries/src/Application/CMSApplication.php:667 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo da consulta: 0.33 ms Após a última consulta: 3.49 ms Consulta a Memória: 0.020 MB de memória antes da consulta: 6.998 MB Linhas devolvidas: 0
SELECT extension, file, type
FROM t6nzp_rokcommon_configs
ORDER BY priorityid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE t6nzp_rokcommon_configs system NULL Nenhuma chave INDEX KEY pode ser utilizada NULL NULL 0 Const row not found Status Duration Starting 0.04 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.02 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.01 ms Executing 0.02 ms End of update loop 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Chamador Ficheiro e número da linha 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 9 JDatabaseDriver->loadObjectList() JROOT/plugins/system/rokcommon/rokcommon.php:131 8 plgSystemRokCommon->processRegisteredConfigs() JROOT/plugins/system/rokcommon/rokcommon.php:75 7 plgSystemRokCommon->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:280 6 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 5 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/libraries/src/Application/CMSApplication.php:667 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo da consulta: 2.41 ms Após a última consulta: 33.94 ms Consulta a Memória: 0.064 MB de memória antes da consulta: 9.248 MB Linhas devolvidas: 25
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 t6nzp_menu AS m
LEFT JOIN t6nzp_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 54 Using index condition; Using where; Modo Filesort em uso 1 SIMPLE e eq_ref PRIMARY PRIMARY 4 bilharm_2020_cpf_01.m.component_id 1 Using where Status Duration Starting 0.14 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.05 ms Optimizing 0.03 ms Statistics 0.34 ms Preparing 0.05 ms Sorting result 0.02 ms Executing 0.01 ms Sending data 0.02 ms Creating sort index 1.41 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Chamador Ficheiro e número da linha 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 18 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Menu/SiteMenu.php:93 17 Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}() Igual à chamada na linha abaixo. 16 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 15 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Menu/SiteMenu.php:101 14 Joomla\CMS\Menu\SiteMenu->load() JROOT/libraries/src/Menu/AbstractMenu.php:78 13 Joomla\CMS\Menu\AbstractMenu->__construct() JROOT/libraries/src/Menu/SiteMenu.php:62 12 Joomla\CMS\Menu\SiteMenu->__construct() JROOT/libraries/src/Menu/AbstractMenu.php:142 11 Joomla\CMS\Menu\AbstractMenu::getInstance() JROOT/libraries/src/Application/CMSApplication.php:417 10 Joomla\CMS\Application\CMSApplication->getMenu() JROOT/libraries/src/Application/SiteApplication.php:275 9 Joomla\CMS\Application\SiteApplication->getMenu() JROOT/libraries/src/Router/SiteRouter.php:65 8 Joomla\CMS\Router\SiteRouter->__construct() JROOT/libraries/src/Router/Router.php:189 7 Joomla\CMS\Router\Router::getInstance() JROOT/libraries/src/Application/CMSApplication.php:533 6 Joomla\CMS\Application\CMSApplication::getRouter() JROOT/libraries/src/Application/SiteApplication.php:403 5 Joomla\CMS\Application\SiteApplication::getRouter() JROOT/libraries/src/Application/CMSApplication.php:1141 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo da consulta: 0.85 ms Após a última consulta: 12.59 ms Consulta a Memória: 0.025 MB de memória antes da consulta: 10.059 MB Linhas devolvidas: 1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `t6nzp_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE t6nzp_extensions ref element_clientid,element_folder_clientid,extension extension 484 const,const 1 Using index condition Status Duration Starting 0.05 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.03 ms Optimizing 0.02 ms Statistics 0.46 ms Preparing 0.03 ms Executing 0.01 ms Sending data 0.05 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Chamador Ficheiro e número da linha 21 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 20 JDatabaseDriver->loadObject() JROOT/libraries/src/Helper/LibraryHelper.php:167 19 Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}() Igual à chamada na linha abaixo. 18 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 17 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/LibraryHelper.php:175 16 Joomla\CMS\Helper\LibraryHelper::loadLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:43 15 Joomla\CMS\Helper\LibraryHelper::getLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:90 14 Joomla\CMS\Helper\LibraryHelper::getParams() JROOT/libraries/src/Version.php:321 13 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 12 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 11 Joomla\CMS\Factory::getDocument() JROOT/plugins/system/nrframework/NRFramework/Functions.php:336 10 NRFramework\Functions::isFeed() JROOT/plugins/system/convertforms/convertforms.php:457 9 PlgSystemConvertForms->getHelper() JROOT/plugins/system/convertforms/convertforms.php:101 8 PlgSystemConvertForms->onAfterRoute() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1190 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo da consulta: 0.52 ms Após a última consulta: 0.16 ms Consulta a Memória: 0.007 MB de memória antes da consulta: 10.052 MB
UPDATE `t6nzp_extensions`
SET `params` = '{\"mediaversion\":\"ca639fc3b419ef1c8736214771f79f13\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'EXPLAIN não é possível na consulta: UPDATE `t6nzp_extensions` SET `params` = '{\"mediaversion\":\"ca639fc3b419ef1c8736214771f79f13\"}' WHERE `type` = 'library' AND `element` = 'joomla'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 for update 0.06 ms Updating 0.09 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.17 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Chamador Ficheiro e número da linha 16 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Helper/LibraryHelper.php:117 15 Joomla\CMS\Helper\LibraryHelper::saveParams() JROOT/libraries/src/Version.php:372 14 Joomla\CMS\Version->setMediaVersion() JROOT/libraries/src/Version.php:331 13 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 12 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 11 Joomla\CMS\Factory::getDocument() JROOT/plugins/system/nrframework/NRFramework/Functions.php:336 10 NRFramework\Functions::isFeed() JROOT/plugins/system/convertforms/convertforms.php:457 9 PlgSystemConvertForms->getHelper() JROOT/plugins/system/convertforms/convertforms.php:101 8 PlgSystemConvertForms->onAfterRoute() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1190 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo da consulta: 0.89 ms Após a última consulta: 2.79 ms Consulta a Memória: 0.022 MB de memória antes da consulta: 10.370 MB Linhas devolvidas: 13
SELECT id, home, template, s.params
FROM t6nzp_template_styles as s
LEFT JOIN t6nzp_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 e ref element_clientid,element_folder_clientid,extension extension 82 const 5 Using index condition; Using where 1 SIMPLE s ref|filter idx_template,idx_client_id,idx_client_id_home idx_template|idx_client_id 202|1 bilharm_2020_cpf_01.e.element 1 (87%) Using index condition; Using where; Using rowid filter Status Duration Starting 0.06 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.02 ms Statistics 0.09 ms Preparing 0.04 ms Executing 0.01 ms Sending data 0.45 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Chamador Ficheiro e número da linha 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Application/SiteApplication.php:486 10 Joomla\CMS\Application\SiteApplication->getTemplate() JROOT/plugins/system/gantry5/gantry5.php:261 9 plgSystemGantry5->onAfterRouteSite() JROOT/plugins/system/gantry5/gantry5.php:112 8 plgSystemGantry5->onAfterRoute() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1190 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo da consulta: 0.66 ms Após a última consulta: 16.46 ms Consulta a Memória: 0.024 MB de memória antes da consulta: 11.852 MB Linhas devolvidas: 11
SELECT s.id, s.template, s.home, s.title AS long_title, s.params
FROM t6nzp_template_styles AS s
WHERE s.client_id = 0
AND s.template = 'rt_sienna'
ORDER BY s.idid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE s index idx_template,idx_client_id,idx_client_id_home PRIMARY 4 NULL 15 Using where Status Duration Starting 0.09 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.03 ms Statistics 0.10 ms Preparing 0.03 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.06 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.02 ms # Chamador Ficheiro e número da linha 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 15 JDatabaseDriver->loadObjectList() JROOT/libraries/gantry5/src/classes/Gantry/Joomla/StyleHelper.php:69 14 Gantry\Joomla\StyleHelper::loadStyles() JROOT/libraries/gantry5/src/classes/Gantry/Framework/Assignments.php:63 13 Gantry\Framework\Assignments->loadAssignments() JROOT/libraries/gantry5/src/classes/Gantry/Component/Assignments/AbstractAssignments.php:301 12 Gantry\Component\Assignments\AbstractAssignments->init() JROOT/libraries/gantry5/src/classes/Gantry/Component/Assignments/AbstractAssignments.php:99 11 Gantry\Component\Assignments\AbstractAssignments->scores() JROOT/libraries/gantry5/src/classes/Gantry/Component/Assignments/AbstractAssignments.php:86 10 Gantry\Component\Assignments\AbstractAssignments->select() JROOT/plugins/system/gantry5/gantry5.php:319 9 plgSystemGantry5->onAfterRouteSite() JROOT/plugins/system/gantry5/gantry5.php:112 8 plgSystemGantry5->onAfterRoute() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1190 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo da consulta: 0.73 ms Após a última consulta: 5.79 ms Consulta a Memória: 0.019 MB de memória antes da consulta: 12.465 MB Linhas devolvidas: 1
SELECT *
FROM t6nzp_languages
WHERE published=1
ORDER BY ordering ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE t6nzp_languages ALL NULL Nenhuma chave INDEX KEY pode ser utilizada NULL NULL 2 Using where; Modo Filesort em uso Status Duration Starting 0.04 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.01 ms Statistics 0.03 ms Preparing 0.02 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.01 ms Creating sort index 0.32 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Chamador Ficheiro e número da linha 7 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 6 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Language/LanguageHelper.php:150 5 Joomla\CMS\Language\LanguageHelper::getLanguages() JROOT/libraries/src/Application/SiteApplication.php:330 4 Joomla\CMS\Application\SiteApplication->getParams() JROOT/libraries/src/Application/SiteApplication.php:138 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo da consulta: 2.67 ms Após a última consulta: 9.12 ms Consulta a Memória: 0.029 MB de memória antes da consulta: 13.182 MB Linhas devolvidas: 42
SELECT `id`,`name`,`rules`,`parent_id`
FROM `t6nzp_assets`
WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_akeeba','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_convertforms','com_cpanel','com_creativeimageslider','com_fields','com_finder','com_gantry5','com_gsd','com_installer','com_jce','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_osmap','com_plugins','com_postinstall','com_privacy','com_redirect','com_rstbox','com_search','com_tags','com_templates','com_users','com_wrapper')id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE t6nzp_assets range idx_asset_name idx_asset_name 202 NULL 43 Using index condition Status Duration Starting 0.07 ms checking permissions 0.01 ms Opening tables 0.04 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.04 ms Optimizing 0.02 ms Statistics 0.14 ms Preparing 0.02 ms Executing 0.01 ms Sending data 2.05 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.03 ms Reset for next command 0.01 ms # Chamador Ficheiro e número da linha 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 19 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Access/Access.php:429 18 Joomla\CMS\Access\Access::preloadComponents() JROOT/libraries/src/Access/Access.php:213 17 Joomla\CMS\Access\Access::preload() JROOT/libraries/src/Access/Access.php:531 16 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 15 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 14 Joomla\CMS\User\User->authorise() JROOT/components/com_content/models/category.php:139 13 ContentModelCategory->populateState() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457 12 Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() JROOT/libraries/src/MVC/View/CategoryView.php:116 11 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:75 10 ContentViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo da consulta: 1.61 ms Após a última consulta: 0.21 ms Consulta a Memória: 0.072 MB de memória antes da consulta: 13.235 MB Linhas devolvidas: 366
SELECT `id`,`name`,`rules`,`parent_id`
FROM `t6nzp_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 t6nzp_assets ALL idx_asset_name,idx_parent_id Nenhuma chave INDEX KEY pode ser utilizada NULL NULL 842 Using where 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.24 ms Preparing 0.02 ms Executing 0.01 ms Sending data 1.00 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.03 ms Reset for next command 0.02 ms # Chamador Ficheiro e número da linha 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 19 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Access/Access.php:359 18 Joomla\CMS\Access\Access::preloadPermissions() JROOT/libraries/src/Access/Access.php:226 17 Joomla\CMS\Access\Access::preload() JROOT/libraries/src/Access/Access.php:540 16 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 15 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 14 Joomla\CMS\User\User->authorise() JROOT/components/com_content/models/category.php:139 13 ContentModelCategory->populateState() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457 12 Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() JROOT/libraries/src/MVC/View/CategoryView.php:116 11 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:75 10 ContentViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo da consulta: 8.63 ms Após a última consulta: 3.25 ms Consulta a Memória: 0.025 MB de memória antes da consulta: 13.611 MB Linhas devolvidas: 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,( SELECT COUNT(i.`id`)
FROM `t6nzp_content` AS `i`
WHERE i.`catid` = c.id
AND i.state = 1) AS numitems
FROM `t6nzp_categories` AS `s`
INNER JOIN `t6nzp_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.published = 1
AND s.id = 18
ORDER BY c.lftid select_type table type possible_keys key key_len ref rows Extra 1 PRIMARY s const PRIMARY,idx_left_right PRIMARY 4 const 1 1 PRIMARY c ALL cat_idx,idx_left_right Nenhuma chave INDEX KEY pode ser utilizada NULL NULL 21 Using where; Modo Filesort em uso 2 DEPENDENT SUBQUERY i ref idx_state,idx_catid idx_catid 4 bilharm_2020_cpf_01.c.id 8 Using index condition; Using where Status Duration Starting 0.11 ms checking permissions 0.02 ms Opening tables 0.10 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.82 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.04 ms Optimizing 0.02 ms Statistics 0.24 ms Preparing 0.04 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.02 ms Creating sort index 0.13 ms Executing 0.01 ms Sending data 0.25 ms Executing 0.01 ms Sending data 6.36 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.02 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.02 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Removing tmp table 0.01 ms Freeing items 0.02 ms Updating status 0.02 ms Reset for next command 0.01 ms # Chamador Ficheiro e número da linha 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 16 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 15 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 14 Joomla\CMS\Categories\Categories->get() JROOT/components/com_content/models/category.php:355 13 ContentModelCategory->getCategory() JROOT/libraries/src/MVC/View/HtmlView.php:425 12 Joomla\CMS\MVC\View\HtmlView->get() JROOT/libraries/src/MVC/View/CategoryView.php:122 11 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:75 10 ContentViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo da consulta: 2.60 ms Após a última consulta: 2.28 ms Consulta a Memória: 0.127 MB de memória antes da consulta: 13.773 MB Linhas devolvidas: 8
SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN c.published = 2
AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum / v.rating_count, 0), 0), 0) AS rating, COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
FROM t6nzp_content AS a
LEFT JOIN t6nzp_categories AS c
ON c.id = a.catid
LEFT JOIN t6nzp_users AS ua
ON ua.id = a.created_by
LEFT JOIN t6nzp_users AS uam
ON uam.id = a.modified_by
LEFT JOIN t6nzp_categories as parent
ON parent.id = c.parent_id
LEFT JOIN t6nzp_content_rating AS v
ON a.id = v.content_id
WHERE a.access IN (1,1,5)
AND c.access IN (1,1,5)
AND c.published = 1
AND a.state = 1
AND a.catid = 18
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-07-27 02:46:26')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-07-27 02:46:26')
ORDER BY c.lft,
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END DESC , a.created
LIMIT 9id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE c const PRIMARY,idx_access PRIMARY 4 const 1 1 SIMPLE a index_merge idx_access,idx_state,idx_catid idx_catid,idx_state 4,1 NULL 40 Using intersect(idx_catid,idx_state); Using where; Modo Filesort em uso 1 SIMPLE ua eq_ref PRIMARY PRIMARY 4 bilharm_2020_cpf_01.a.created_by 1 Using where 1 SIMPLE uam eq_ref PRIMARY PRIMARY 4 bilharm_2020_cpf_01.a.modified_by 1 Using where 1 SIMPLE parent eq_ref PRIMARY PRIMARY 4 const 1 Using where 1 SIMPLE v eq_ref PRIMARY PRIMARY 4 bilharm_2020_cpf_01.a.id 1 Using where Status Duration Starting 0.17 ms checking permissions 0.01 ms Opening tables 0.08 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.10 ms Optimizing 0.05 ms Statistics 0.35 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.07 ms Sorting result 0.02 ms Executing 0.01 ms Sending data 0.03 ms Creating sort index 1.53 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Chamador Ficheiro e número da linha 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 17 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 16 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:194 15 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/components/com_content/models/articles.php:576 14 ContentModelArticles->getItems() JROOT/components/com_content/models/category.php:253 13 ContentModelCategory->getItems() JROOT/libraries/src/MVC/View/HtmlView.php:425 12 Joomla\CMS\MVC\View\HtmlView->get() JROOT/libraries/src/MVC/View/CategoryView.php:144 11 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:75 10 ContentViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo da consulta: 0.73 ms Após a última consulta: 1.81 ms Consulta a Memória: 0.024 MB de memória antes da consulta: 14.105 MB Linhas devolvidas: 1
SELECT COUNT(*)
FROM t6nzp_content AS a
LEFT JOIN t6nzp_categories AS c
ON c.id = a.catid
LEFT JOIN t6nzp_users AS ua
ON ua.id = a.created_by
LEFT JOIN t6nzp_users AS uam
ON uam.id = a.modified_by
LEFT JOIN t6nzp_categories as parent
ON parent.id = c.parent_id
LEFT JOIN t6nzp_content_rating AS v
ON a.id = v.content_id
WHERE a.access IN (1,1,5)
AND c.access IN (1,1,5)
AND c.published = 1
AND a.state = 1
AND a.catid = 18
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-07-27 02:46:26')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-07-27 02:46:26')id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE c const PRIMARY,idx_access PRIMARY 4 const 1 1 SIMPLE a index_merge idx_access,idx_state,idx_catid idx_catid,idx_state 4,1 NULL 40 Using intersect(idx_catid,idx_state); Using where 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.02 ms table lock 0.01 ms init 0.03 ms Optimizing 0.03 ms Statistics 0.10 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.03 ms Executing 0.01 ms Sending data 0.16 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.03 ms # Chamador Ficheiro e número da linha 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 17 JDatabaseDriver->loadResult() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:354 16 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount() JROOT/libraries/src/MVC/Model/ListModel.php:289 15 Joomla\CMS\MVC\Model\ListModel->getTotal() JROOT/libraries/src/MVC/Model/ListModel.php:239 14 Joomla\CMS\MVC\Model\ListModel->getPagination() JROOT/components/com_content/models/category.php:265 13 ContentModelCategory->getItems() JROOT/libraries/src/MVC/View/HtmlView.php:425 12 Joomla\CMS\MVC\View\HtmlView->get() JROOT/libraries/src/MVC/View/CategoryView.php:144 11 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:75 10 ContentViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo da consulta: 1.52 ms Após a última consulta: 1.73 ms Consulta a Memória: 0.022 MB de memória antes da consulta: 14.237 MB Linhas devolvidas: 0
SELECT `m`.`tag_id`,`t`.*
FROM `t6nzp_contentitem_tag_map` AS m
INNER JOIN `t6nzp_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.category'
AND `m`.`content_item_id` = 18
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 INDEX KEY pode ser utilizada NULL NULL 14 Using where 1 SIMPLE m ref idx_tag_type idx_tag_type 4 bilharm_2020_cpf_01.t.id 34 Using index condition; Using where Status Duration Starting 0.04 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.04 ms Optimizing 0.05 ms Statistics 0.42 ms Preparing 0.03 ms Executing 0.01 ms Sending data 0.65 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Chamador Ficheiro e número da linha 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 13 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Helper/TagsHelper.php:454 12 Joomla\CMS\Helper\TagsHelper->getItemTags() JROOT/libraries/src/MVC/View/CategoryView.php:229 11 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:75 10 ContentViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo da consulta: 2.62 ms Após a última consulta: 16.19 ms Consulta a Memória: 0.026 MB de memória antes da consulta: 16.030 MB Linhas devolvidas: 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 `t6nzp_categories` AS `s`
INNER JOIN `t6nzp_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1,5)
AND c.published = 1
AND s.id = 18
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 INDEX KEY pode ser utilizada NULL NULL 21 Using where; Modo Filesort em uso Status Duration Starting 0.11 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.03 ms Statistics 2.03 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.03 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.02 ms Creating sort index 0.09 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.02 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Chamador Ficheiro e número da linha 21 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 20 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 19 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 18 Joomla\CMS\Categories\Categories->get() JROOT/administrator/components/com_fields/models/fields.php:203 17 FieldsModelFields->getListQuery() JROOT/libraries/src/MVC/Model/ListModel.php:140 16 Joomla\CMS\MVC\Model\ListModel->_getListQuery() JROOT/libraries/src/MVC/Model/ListModel.php:194 15 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 14 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:495 13 PlgSystemFields->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_content/views/category/view.html.php:113 10 ContentViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo da consulta: 2.33 ms Após a última consulta: 0.14 ms Consulta a Memória: 0.025 MB de memória antes da consulta: 16.046 MB Linhas devolvidas: 0
SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM t6nzp_fields AS a
LEFT JOIN `t6nzp_languages` AS l
ON l.lang_code = a.language
LEFT JOIN t6nzp_users AS uc
ON uc.id=a.checked_out
LEFT JOIN t6nzp_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN t6nzp_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN t6nzp_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `t6nzp_fields_categories` AS fc
ON fc.field_id = a.id
WHERE a.context = 'com_content.article'
AND (fc.category_id IS NULL OR fc.category_id IN (18,0))
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; Using temporary; Modo Filesort em uso 1 SIMPLE l eq_ref idx_langcode idx_langcode 28 bilharm_2020_cpf_01.a.language 1 Using where 1 SIMPLE uc eq_ref PRIMARY PRIMARY 4 bilharm_2020_cpf_01.a.checked_out 1 1 SIMPLE ag eq_ref PRIMARY PRIMARY 4 bilharm_2020_cpf_01.a.access 1 Using where 1 SIMPLE ua eq_ref PRIMARY PRIMARY 4 bilharm_2020_cpf_01.a.created_user_id 1 Using where 1 SIMPLE g eq_ref PRIMARY PRIMARY 4 bilharm_2020_cpf_01.a.group_id 1 Using where 1 SIMPLE fc ref PRIMARY PRIMARY 4 bilharm_2020_cpf_01.a.id 1 Using where; Using index; Distinct Status Duration Starting 0.11 ms checking permissions 0.01 ms Opening tables 0.09 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.06 ms Optimizing 0.03 ms Statistics 1.17 ms Preparing 0.05 ms Creating tmp table 0.07 ms Sorting result 0.02 ms Executing 0.01 ms Sending data 0.36 ms Creating sort index 0.04 ms Removing tmp table 0.09 ms Creating sort index 0.01 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.02 ms # Chamador Ficheiro e número da linha 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 18 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 17 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_fields/models/fields.php:333 16 FieldsModelFields->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:194 15 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 14 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:495 13 PlgSystemFields->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_content/views/category/view.html.php:113 10 ContentViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo da consulta: 1.21 ms Após a última consulta: 23.01 ms Consulta a Memória: 0.026 MB de memória antes da consulta: 16.818 MB Linhas devolvidas: 0
SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM t6nzp_fields AS a
LEFT JOIN `t6nzp_languages` AS l
ON l.lang_code = a.language
LEFT JOIN t6nzp_users AS uc
ON uc.id=a.checked_out
LEFT JOIN t6nzp_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN t6nzp_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN t6nzp_fields_groups AS g
ON g.id = a.group_id
WHERE a.context = 'com_content.categories'
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; Using temporary; Modo Filesort em uso 1 SIMPLE l eq_ref idx_langcode idx_langcode 28 bilharm_2020_cpf_01.a.language 1 Using where 1 SIMPLE uc eq_ref PRIMARY PRIMARY 4 bilharm_2020_cpf_01.a.checked_out 1 1 SIMPLE ag eq_ref PRIMARY PRIMARY 4 bilharm_2020_cpf_01.a.access 1 Using where 1 SIMPLE ua eq_ref PRIMARY PRIMARY 4 bilharm_2020_cpf_01.a.created_user_id 1 Using where 1 SIMPLE g eq_ref PRIMARY PRIMARY 4 bilharm_2020_cpf_01.a.group_id 1 Using where Status Duration Starting 0.14 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.05 ms Optimizing 0.04 ms Statistics 0.16 ms Preparing 0.05 ms Creating tmp table 0.06 ms Sorting result 0.02 ms Executing 0.01 ms Sending data 0.28 ms Creating sort index 0.03 ms Removing tmp table 0.09 ms Creating sort index 0.01 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.02 ms # Chamador Ficheiro e número da linha 23 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 22 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 21 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_fields/models/fields.php:333 20 FieldsModelFields->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:194 19 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 18 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:495 17 PlgSystemFields->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 16 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 15 JEventDispatcher->trigger() JROOT/components/com_content/views/category/tmpl/blog.php:19 14 include JROOT/components/com_content/views/category/tmpl/blog.php JROOT/libraries/src/MVC/View/HtmlView.php:701 13 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/libraries/src/MVC/View/HtmlView.php:230 12 Joomla\CMS\MVC\View\HtmlView->display() JROOT/libraries/src/MVC/View/CategoryView.php:245 11 Joomla\CMS\MVC\View\CategoryView->display() JROOT/components/com_content/views/category/view.html.php:250 10 ContentViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo da consulta: 0.96 ms Após a última consulta: 0.32 ms Consulta a Memória: 0.027 MB de memória antes da consulta: 16.831 MB Linhas devolvidas: 0
SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM t6nzp_fields AS a
LEFT JOIN `t6nzp_languages` AS l
ON l.lang_code = a.language
LEFT JOIN t6nzp_users AS uc
ON uc.id=a.checked_out
LEFT JOIN t6nzp_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN t6nzp_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN t6nzp_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `t6nzp_fields_categories` AS fc
ON fc.field_id = a.id
WHERE a.context = 'com_content.categories'
AND (fc.category_id IS NULL OR fc.category_id IN (18,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; Using temporary; Modo Filesort em uso 1 SIMPLE l eq_ref idx_langcode idx_langcode 28 bilharm_2020_cpf_01.a.language 1 Using where 1 SIMPLE uc eq_ref PRIMARY PRIMARY 4 bilharm_2020_cpf_01.a.checked_out 1 1 SIMPLE ag eq_ref PRIMARY PRIMARY 4 bilharm_2020_cpf_01.a.access 1 Using where 1 SIMPLE ua eq_ref PRIMARY PRIMARY 4 bilharm_2020_cpf_01.a.created_user_id 1 Using where 1 SIMPLE g eq_ref PRIMARY PRIMARY 4 bilharm_2020_cpf_01.a.group_id 1 Using where 1 SIMPLE fc ref PRIMARY PRIMARY 4 bilharm_2020_cpf_01.a.id 1 Using where; Using index; Distinct Status Duration Starting 0.09 ms checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.02 ms init 0.04 ms Optimizing 0.05 ms Statistics 0.10 ms Preparing 0.04 ms Creating tmp table 0.05 ms Sorting result 0.02 ms Executing 0.01 ms Sending data 0.23 ms Creating sort index 0.02 ms Removing tmp table 0.07 ms Creating sort index 0.01 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 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 # Chamador Ficheiro e número da linha 24 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 23 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 22 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_fields/models/fields.php:333 21 FieldsModelFields->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:194 20 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 19 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:404 18 PlgSystemFields->display() JROOT/plugins/system/fields/fields.php:324 17 PlgSystemFields->onContentAfterTitle() JROOT/libraries/joomla/event/event.php:70 16 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 15 JEventDispatcher->trigger() JROOT/components/com_content/views/category/tmpl/blog.php:22 14 include JROOT/components/com_content/views/category/tmpl/blog.php JROOT/libraries/src/MVC/View/HtmlView.php:701 13 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/libraries/src/MVC/View/HtmlView.php:230 12 Joomla\CMS\MVC\View\HtmlView->display() JROOT/libraries/src/MVC/View/CategoryView.php:245 11 Joomla\CMS\MVC\View\CategoryView->display() JROOT/components/com_content/views/category/view.html.php:250 10 ContentViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo da consulta: 1.09 ms Após a última consulta: 9.43 ms Consulta a Memória: 0.020 MB de memória antes da consulta: 17.139 MB Linhas devolvidas: 1
SELECT `id`
FROM `t6nzp_rstbox`
WHERE `published` = 1
AND `testmode` = 0id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE t6nzp_rstbox ALL NULL Nenhuma chave INDEX KEY pode ser utilizada NULL NULL 5 Using where Status Duration Starting 0.03 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.77 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Chamador Ficheiro e número da linha 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 9 JDatabaseDriver->loadColumn() JROOT/administrator/components/com_rstbox/EngageBox/Boxes.php:41 8 EngageBox\Boxes::render() JROOT/plugins/system/rstbox/rstbox.php:68 7 PlgSystemRstBox->onAfterDispatch() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/SiteApplication.php:199 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo da consulta: 0.30 ms Após a última consulta: 0.99 ms Consulta a Memória: 0.021 MB de memória antes da consulta: 17.209 MB Linhas devolvidas: 1
SELECT *
FROM `t6nzp_rstbox`
WHERE `id` = 2id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE t6nzp_rstbox const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.02 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 Unlocking tables 0.01 ms Preparing 0.01 ms Executing 0.01 ms Sending data 0.02 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Chamador Ficheiro e número da linha 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 10 JDatabaseDriver->loadObject() JROOT/administrator/components/com_rstbox/EngageBox/Box.php:190 9 EngageBox\Box::get() JROOT/administrator/components/com_rstbox/EngageBox/Boxes.php:51 8 EngageBox\Boxes::render() JROOT/plugins/system/rstbox/rstbox.php:68 7 PlgSystemRstBox->onAfterDispatch() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/SiteApplication.php:199 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo da consulta: 0.80 ms Após a última consulta: 47.84 ms Consulta a Memória: 0.036 MB de memória antes da consulta: 21.879 MB Linhas devolvidas: 1
SELECT `a`.`menutype`,`a`.`title`
FROM `t6nzp_menu_types` AS `a`
WHERE `a`.`client_id` = 0id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ALL NULL Nenhuma chave INDEX KEY pode ser utilizada NULL NULL 1 Using where Status Duration Starting 0.09 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.04 ms Optimizing 0.04 ms Statistics 0.03 ms Preparing 0.03 ms Executing 0.01 ms Sending data 0.28 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.02 ms # Chamador Ficheiro e número da linha 47 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506 46 JDatabaseDriver->loadAssocList() JROOT/libraries/gantry5/src/classes/Gantry/Framework/Menu.php:138 45 Gantry\Framework\Menu->getMenuOptions() JROOT/libraries/gantry5/src/classes/Gantry/Framework/Menu.php:115 44 Gantry\Framework\Menu->getMenus() JROOT/libraries/gantry5/src/classes/Gantry/Component/Menu/AbstractMenu.php:274 43 Gantry\Component\Menu\AbstractMenu->instance() JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:702 42 Twig\Template->getAttribute() JROOT/cache/gantry5/rt_sienna/twig/3e/3ed9bd796a8f92aa06d5f3adc2cf8038c8785a420dcd0ba2f17a76ed8ce0187f.php:32 41 __TwigTemplate_6cfcf7a985df56323cb14301b4c3bdffb79fecf9d1c6fe6c0f3a9845dbbc47de->doDisplay() JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:453 40 Twig\Template->displayWithErrorHandling() JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:420 39 Twig\Template->display() JROOT/cache/gantry5/rt_sienna/twig/f6/f668f3905a6cb86b775c4f8d8812bd7e397f759943f01d3b314fa56a8efbd80b.php:85 38 __TwigTemplate_615ea204325e8dbd78f2a16703f8bc907eb33b5f5688e7b12ecc041fdb80d225->doDisplay() JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:453 37 Twig\Template->displayWithErrorHandling() JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:420 36 Twig\Template->display() JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:432 35 Twig\Template->render() JROOT/libraries/gantry5/compat/vendor/twig/twig/src/TemplateWrapper.php:47 34 Twig\TemplateWrapper->render() JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Environment.php:384 33 Twig\Environment->render() JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/AbstractTheme.php:176 32 Gantry\Component\Theme\AbstractTheme->render() JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:825 31 Gantry\Framework\Theme->getContent() JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:718 30 Gantry\Framework\Theme->renderContent() JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:643 29 Gantry\Framework\Theme->prepareLayout() JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:627 28 Gantry\Framework\Theme->prepareLayout() JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:627 27 Gantry\Framework\Theme->prepareLayout() JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:627 26 Gantry\Framework\Theme->prepareLayout() JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:627 25 Gantry\Framework\Theme->prepareLayout() JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:627 24 Gantry\Framework\Theme->prepareLayout() JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:627 23 Gantry\Framework\Theme->prepareLayout() JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:468 22 Gantry\Framework\Theme->segments() JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:700 21 Twig\Template->getAttribute() JROOT/cache/gantry5/rt_sienna/twig/11/11703f6ead5fa339f2cba2926e9288254d851574f9b6501e7eb9728a351c7400.php:47 20 __TwigTemplate_3366ff40a79ffa91ff47bcb6e338d24b4c25fa4c9ff702cff238ae8e4b221d22->doDisplay() JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:453 19 Twig\Template->displayWithErrorHandling() JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:420 18 Twig\Template->display() JROOT/cache/gantry5/rt_sienna/twig/6d/6de4e826f80077bb2657d8b4d1f6e93ae383ebc5f2ce0151ffe024cf0d30e9d2.php:35 17 __TwigTemplate_41553573cad379f5b0af28f0276bcd2863e23d26432a44afd5487ebacf19ea49->doDisplay() JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:453 16 Twig\Template->displayWithErrorHandling() JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:420 15 Twig\Template->display() JROOT/cache/gantry5/rt_sienna/twig/33/3302ecc9fa01f86763355c8f1c3dba4415b58562491378eecef3cbb21807db86.php:35 14 __TwigTemplate_0b84560a9839732b838620abd35689c055169b33eebd3f6ad9d224e497eba3b5->doDisplay() JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:453 13 Twig\Template->displayWithErrorHandling() JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:420 12 Twig\Template->display() JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:432 11 Twig\Template->render() JROOT/libraries/gantry5/compat/vendor/twig/twig/src/TemplateWrapper.php:47 10 Twig\TemplateWrapper->render() JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Environment.php:384 9 Twig\Environment->render() JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/AbstractTheme.php:176 8 Gantry\Component\Theme\AbstractTheme->render() JROOT/templates/rt_sienna/index.php:23 7 require JROOT/templates/rt_sienna/index.php JROOT/libraries/src/Document/HtmlDocument.php:678 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:740 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:555 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1098 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo da consulta: 1.09 ms Após a última consulta: 0.95 ms Consulta a Memória: 0.045 MB de memória antes da consulta: 21.980 MB Linhas devolvidas: 53
SELECT m.id, m.alias, m.path AS route, m.level, m.parent_id
FROM t6nzp_menu AS m
WHERE m.menutype = 'mainmenu'
AND m.parent_id > 0
AND m.client_id = 0
AND m.published >= 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_menutype idx_client_id_parent_id_alias_language 1 const 54 Using index condition; Using where; Modo Filesort em uso Status Duration Starting 0.05 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.03 ms Optimizing 0.03 ms Statistics 0.28 ms Preparing 0.03 ms Sorting result 0.03 ms Executing 0.02 ms Sending data 0.01 ms Creating sort index 0.40 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.02 ms # Chamador Ficheiro e número da linha 48 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506 47 JDatabaseDriver->loadAssocList() JROOT/libraries/gantry5/src/classes/Gantry/Framework/Menu.php:791 46 Gantry\Framework\Menu->getMenuItemIds() JROOT/libraries/gantry5/src/classes/Gantry/Framework/Menu.php:310 45 Gantry\Framework\Menu->getItemsFromPlatform() JROOT/libraries/gantry5/src/classes/Gantry/Framework/Menu.php:753 44 Gantry\Framework\Menu->getList() JROOT/libraries/gantry5/src/classes/Gantry/Component/Menu/AbstractMenu.php:316 43 Gantry\Component\Menu\AbstractMenu->instance() JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:702 42 Twig\Template->getAttribute() JROOT/cache/gantry5/rt_sienna/twig/3e/3ed9bd796a8f92aa06d5f3adc2cf8038c8785a420dcd0ba2f17a76ed8ce0187f.php:32 41 __TwigTemplate_6cfcf7a985df56323cb14301b4c3bdffb79fecf9d1c6fe6c0f3a9845dbbc47de->doDisplay() JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:453 40 Twig\Template->displayWithErrorHandling() JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:420 39 Twig\Template->display() JROOT/cache/gantry5/rt_sienna/twig/f6/f668f3905a6cb86b775c4f8d8812bd7e397f759943f01d3b314fa56a8efbd80b.php:85 38 __TwigTemplate_615ea204325e8dbd78f2a16703f8bc907eb33b5f5688e7b12ecc041fdb80d225->doDisplay() JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:453 37 Twig\Template->displayWithErrorHandling() JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:420 36 Twig\Template->display() JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:432 35 Twig\Template->render() JROOT/libraries/gantry5/compat/vendor/twig/twig/src/TemplateWrapper.php:47 34 Twig\TemplateWrapper->render() JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Environment.php:384 33 Twig\Environment->render() JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/AbstractTheme.php:176 32 Gantry\Component\Theme\AbstractTheme->render() JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:825 31 Gantry\Framework\Theme->getContent() JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:718 30 Gantry\Framework\Theme->renderContent() JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:643 29 Gantry\Framework\Theme->prepareLayout() JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:627 28 Gantry\Framework\Theme->prepareLayout() JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:627 27 Gantry\Framework\Theme->prepareLayout() JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:627 26 Gantry\Framework\Theme->prepareLayout() JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:627 25 Gantry\Framework\Theme->prepareLayout() JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:627 24 Gantry\Framework\Theme->prepareLayout() JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:627 23 Gantry\Framework\Theme->prepareLayout() JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:468 22 Gantry\Framework\Theme->segments() JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:700 21 Twig\Template->getAttribute() JROOT/cache/gantry5/rt_sienna/twig/11/11703f6ead5fa339f2cba2926e9288254d851574f9b6501e7eb9728a351c7400.php:47 20 __TwigTemplate_3366ff40a79ffa91ff47bcb6e338d24b4c25fa4c9ff702cff238ae8e4b221d22->doDisplay() JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:453 19 Twig\Template->displayWithErrorHandling() JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:420 18 Twig\Template->display() JROOT/cache/gantry5/rt_sienna/twig/6d/6de4e826f80077bb2657d8b4d1f6e93ae383ebc5f2ce0151ffe024cf0d30e9d2.php:35 17 __TwigTemplate_41553573cad379f5b0af28f0276bcd2863e23d26432a44afd5487ebacf19ea49->doDisplay() JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:453 16 Twig\Template->displayWithErrorHandling() JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:420 15 Twig\Template->display() JROOT/cache/gantry5/rt_sienna/twig/33/3302ecc9fa01f86763355c8f1c3dba4415b58562491378eecef3cbb21807db86.php:35 14 __TwigTemplate_0b84560a9839732b838620abd35689c055169b33eebd3f6ad9d224e497eba3b5->doDisplay() JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:453 13 Twig\Template->displayWithErrorHandling() JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:420 12 Twig\Template->display() JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:432 11 Twig\Template->render() JROOT/libraries/gantry5/compat/vendor/twig/twig/src/TemplateWrapper.php:47 10 Twig\TemplateWrapper->render() JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Environment.php:384 9 Twig\Environment->render() JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/AbstractTheme.php:176 8 Gantry\Component\Theme\AbstractTheme->render() JROOT/templates/rt_sienna/index.php:23 7 require JROOT/templates/rt_sienna/index.php JROOT/libraries/src/Document/HtmlDocument.php:678 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:740 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:555 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1098 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo da consulta: 3.74 ms Após a última consulta: 7.20 ms Consulta a Memória: 0.040 MB de memória antes da consulta: 22.452 MB Linhas devolvidas: 11
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM t6nzp_modules AS m
LEFT JOIN t6nzp_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN t6nzp_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-07-27 02:46:26')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-07-27 02:46:26')
AND m.access IN (1,1,5)
AND m.client_id = 0
AND (mm.menuid = 256 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 60 Using index condition; Using where; Modo Filesort em uso 1 SIMPLE mm ref PRIMARY PRIMARY 4 bilharm_2020_cpf_01.m.id 1 Using where; Using index 1 SIMPLE e ref element_clientid,element_folder_clientid element_clientid 403 bilharm_2020_cpf_01.m.module,const 1 Using index condition; Using where Status Duration Starting 0.09 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.05 ms Optimizing 0.04 ms Statistics 0.26 ms Preparing 0.06 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.01 ms Creating sort index 2.85 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.02 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.04 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.02 ms # Chamador Ficheiro e número da linha 55 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 54 JDatabaseDriver->loadObjectList() Igual à chamada na linha abaixo. 53 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 52 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:441 51 Joomla\CMS\Helper\ModuleHelper::getModuleList() JROOT/libraries/src/Helper/ModuleHelper.php:371 50 Joomla\CMS\Helper\ModuleHelper::load() JROOT/libraries/src/Helper/ModuleHelper.php:87 49 Joomla\CMS\Helper\ModuleHelper::getModules() JROOT/libraries/gantry5/src/classes/Gantry/Framework/Platform.php:341 48 Gantry\Framework\Platform->displayModules() JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:702 47 Twig\Template->getAttribute() JROOT/cache/gantry5/rt_sienna/twig/49/4902bfefb9860cebb07714c9b8c373e524b1a0501f928beb7863efc28f1735a8.php:43 46 __TwigTemplate_7559b1a3ff9b9a57f571e92eb20539da2dcb74adef216059a9ccdabc17211656->block_particle() JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:214 45 Twig\Template->displayBlock() JROOT/cache/gantry5/rt_sienna/twig/3f/3fec7bcada9e30df3f2683a6c69df5cd6e36f8eb169ff6399bed0fa604043b96.php:73 44 __TwigTemplate_ecbc2419e547921db037a691b11788c2031030e5e31f28e4bdabc86868c2756e->doDisplay() JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:453 43 Twig\Template->displayWithErrorHandling() JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:420 42 Twig\Template->display() JROOT/cache/gantry5/rt_sienna/twig/49/4902bfefb9860cebb07714c9b8c373e524b1a0501f928beb7863efc28f1735a8.php:35 41 __TwigTemplate_7559b1a3ff9b9a57f571e92eb20539da2dcb74adef216059a9ccdabc17211656->doDisplay() JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:453 40 Twig\Template->displayWithErrorHandling() JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:420 39 Twig\Template->display() JROOT/cache/gantry5/rt_sienna/twig/6b/6bea59e36a6e531ec59e420025fd37dda0de452427c265203d2874a42388a2a8.php:53 38 __TwigTemplate_6003ab24ae80fc3a798eeec3e10cdef4107ebb11cae05f3c740d5db4c9cbb35e->doDisplay() JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:453 37 Twig\Template->displayWithErrorHandling() JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:420 36 Twig\Template->display() JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:432 35 Twig\Template->render() JROOT/libraries/gantry5/compat/vendor/twig/twig/src/TemplateWrapper.php:47 34 Twig\TemplateWrapper->render() JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Environment.php:384 33 Twig\Environment->render() JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/AbstractTheme.php:176 32 Gantry\Component\Theme\AbstractTheme->render() JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:825 31 Gantry\Framework\Theme->getContent() JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:718 30 Gantry\Framework\Theme->renderContent() JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:643 29 Gantry\Framework\Theme->prepareLayout() JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:627 28 Gantry\Framework\Theme->prepareLayout() JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:627 27 Gantry\Framework\Theme->prepareLayout() JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:627 26 Gantry\Framework\Theme->prepareLayout() JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:627 25 Gantry\Framework\Theme->prepareLayout() JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:627 24 Gantry\Framework\Theme->prepareLayout() JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:627 23 Gantry\Framework\Theme->prepareLayout() JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:468 22 Gantry\Framework\Theme->segments() JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:700 21 Twig\Template->getAttribute() JROOT/cache/gantry5/rt_sienna/twig/11/11703f6ead5fa339f2cba2926e9288254d851574f9b6501e7eb9728a351c7400.php:47 20 __TwigTemplate_3366ff40a79ffa91ff47bcb6e338d24b4c25fa4c9ff702cff238ae8e4b221d22->doDisplay() JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:453 19 Twig\Template->displayWithErrorHandling() JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:420 18 Twig\Template->display() JROOT/cache/gantry5/rt_sienna/twig/6d/6de4e826f80077bb2657d8b4d1f6e93ae383ebc5f2ce0151ffe024cf0d30e9d2.php:35 17 __TwigTemplate_41553573cad379f5b0af28f0276bcd2863e23d26432a44afd5487ebacf19ea49->doDisplay() JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:453 16 Twig\Template->displayWithErrorHandling() JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:420 15 Twig\Template->display() JROOT/cache/gantry5/rt_sienna/twig/33/3302ecc9fa01f86763355c8f1c3dba4415b58562491378eecef3cbb21807db86.php:35 14 __TwigTemplate_0b84560a9839732b838620abd35689c055169b33eebd3f6ad9d224e497eba3b5->doDisplay() JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:453 13 Twig\Template->displayWithErrorHandling() JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:420 12 Twig\Template->display() JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:432 11 Twig\Template->render() JROOT/libraries/gantry5/compat/vendor/twig/twig/src/TemplateWrapper.php:47 10 Twig\TemplateWrapper->render() JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Environment.php:384 9 Twig\Environment->render() JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/AbstractTheme.php:176 8 Gantry\Component\Theme\AbstractTheme->render() JROOT/templates/rt_sienna/index.php:23 7 require JROOT/templates/rt_sienna/index.php JROOT/libraries/src/Document/HtmlDocument.php:678 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:740 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:555 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1098 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo da consulta: 0.95 ms Após a última consulta: 1570.31 ms Consulta a Memória: 0.025 MB de memória antes da consulta: 38.615 MB Linhas devolvidas: 1
SELECT *
FROM `t6nzp_extensions`
WHERE `element` = 'com_gsd'
AND `type` = 'component'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE t6nzp_extensions ref element_clientid,element_folder_clientid,extension element_clientid 402 const 1 Using index condition; Using where Status Duration Starting 0.14 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.02 ms init 0.07 ms Optimizing 0.04 ms Statistics 0.15 ms Preparing 0.07 ms Executing 0.01 ms Sending data 0.12 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.02 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Chamador Ficheiro e número da linha 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 18 JDatabaseDriver->loadAssoc() JROOT/plugins/system/nrframework/NRFramework/Extension.php:124 17 NRFramework\Extension::get() JROOT/plugins/system/nrframework/NRFramework/Extension.php:176 16 NRFramework\Extension::isEnabled() JROOT/plugins/system/nrframework/NRFramework/Extension.php:159 15 NRFramework\Extension::componentIsEnabled() JROOT/plugins/system/gsd/gsd.php:387 14 plgSystemGSD->setup() JROOT/plugins/system/gsd/gsd.php:430 13 plgSystemGSD->getHelper() JROOT/plugins/system/gsd/gsd.php:56 12 plgSystemGSD->onBeforeCompileHead() JROOT/libraries/joomla/event/event.php:70 11 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 10 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 9 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67 8 Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead() JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38 7 Joomla\CMS\Document\Renderer\Html\HeadRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo da consulta: 4.01 ms Após a última consulta: 1.12 ms Consulta a Memória: 0.027 MB de memória antes da consulta: 38.690 MB Linhas devolvidas: 2
SHOW FULL COLUMNS
FROM `t6nzp_gsd_config`EXPLAIN não é possível na consulta: SHOW FULL COLUMNS FROM `t6nzp_gsd_config`Status Duration Starting 0.04 ms checking permissions 0.01 ms closing tables 0.01 ms checking permissions 0.02 ms Opening tables 0.33 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.01 ms Preparing 0.02 ms Executing 0.01 ms Filling schema table 0.02 ms Opening tables 0.08 ms After opening tables 0.03 ms checking permissions 0.07 ms closing tables 0.01 ms checking permissions 0.02 ms Executing 0.01 ms Sending data 0.06 ms End of update loop 0.02 ms Query end 0.01 ms closing tables 0.01 ms Removing tmp table 0.19 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.02 ms Updating status 2.81 ms Reset for next command 0.01 ms # Chamador Ficheiro e número da linha 22 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 21 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:448 20 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:261 19 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:180 18 Joomla\CMS\Table\Table->__construct() JROOT/administrator/components/com_gsd/tables/config.php:26 17 GSDTableConfig->__construct() JROOT/libraries/src/Table/Table.php:328 16 Joomla\CMS\Table\Table::getInstance() JROOT/administrator/components/com_gsd/GSD/Helper.php:415 15 GSD\Helper::getParams() JROOT/plugins/system/gsd/gsd.php:399 14 plgSystemGSD->setup() JROOT/plugins/system/gsd/gsd.php:430 13 plgSystemGSD->getHelper() JROOT/plugins/system/gsd/gsd.php:56 12 plgSystemGSD->onBeforeCompileHead() JROOT/libraries/joomla/event/event.php:70 11 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 10 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 9 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67 8 Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead() JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38 7 Joomla\CMS\Document\Renderer\Html\HeadRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo da consulta: 0.46 ms Após a última consulta: 0.80 ms Consulta a Memória: 0.024 MB de memória antes da consulta: 38.729 MB Linhas devolvidas: 1
SELECT *
FROM t6nzp_gsd_config
WHERE `name` = 'config'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE t6nzp_gsd_config system NULL Nenhuma chave INDEX KEY pode ser utilizada NULL NULL 1 Status Duration Starting 0.07 ms checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.03 ms Optimizing 0.02 ms Statistics 0.03 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.05 ms Executing 0.01 ms Sending data 0.01 ms End of update loop 0.02 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Chamador Ficheiro e número da linha 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 17 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/Table.php:747 16 Joomla\CMS\Table\Table->load() JROOT/administrator/components/com_gsd/GSD/Helper.php:416 15 GSD\Helper::getParams() JROOT/plugins/system/gsd/gsd.php:399 14 plgSystemGSD->setup() JROOT/plugins/system/gsd/gsd.php:430 13 plgSystemGSD->getHelper() JROOT/plugins/system/gsd/gsd.php:56 12 plgSystemGSD->onBeforeCompileHead() JROOT/libraries/joomla/event/event.php:70 11 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 10 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 9 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67 8 Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead() JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38 7 Joomla\CMS\Document\Renderer\Html\HeadRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
30 tipos de pedidos registados, ordenados por ocorrências.
ESCOLHER tabelas:
2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `t6nzp_extensions`2 × SELECT template
FROM t6nzp_template_styles as s2 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `t6nzp_assets`2 × SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM t6nzp_fields AS a
LEFT JOIN `t6nzp_languages` AS l
ON l.lang_code = a.language
LEFT JOIN t6nzp_users AS uc
ON uc.id=a.checked_out
LEFT JOIN t6nzp_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN t6nzp_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN t6nzp_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `t6nzp_fields_categories` AS fc
ON fc.field_id = a.id1 × SELECT `data`
FROM `t6nzp_session`1 × SELECT `session_id`
FROM `t6nzp_session`1 × SELECT id, rules
FROM `t6nzp_viewlevels1 × SELECT b.id
FROM t6nzp_usergroups AS a
LEFT JOIN t6nzp_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM t6nzp_extensions1 × SELECT extension, file, type
FROM t6nzp_rokcommon_configs1 × 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 t6nzp_menu AS m
LEFT JOIN t6nzp_extensions AS e
ON m.component_id = e.extension_id1 × SELECT id, home, template, s.params
FROM t6nzp_template_styles as s
LEFT JOIN t6nzp_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id1 × SELECT s.id, s.template, s.home, s.title AS long_title, s.params
FROM t6nzp_template_styles AS s1 × SELECT *
FROM t6nzp_languages1 × 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,( SELECT COUNT(i.`id`)
FROM `t6nzp_content` AS `i`1 × SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN c.published = 2
AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum / v.rating_count, 0), 0), 0) AS rating, COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
FROM t6nzp_content AS a
LEFT JOIN t6nzp_categories AS c
ON c.id = a.catid
LEFT JOIN t6nzp_users AS ua
ON ua.id = a.created_by
LEFT JOIN t6nzp_users AS uam
ON uam.id = a.modified_by
LEFT JOIN t6nzp_categories as parent
ON parent.id = c.parent_id
LEFT JOIN t6nzp_content_rating AS v
ON a.id = v.content_id1 × SELECT COUNT(*)
FROM t6nzp_content AS a
LEFT JOIN t6nzp_categories AS c
ON c.id = a.catid
LEFT JOIN t6nzp_users AS ua
ON ua.id = a.created_by
LEFT JOIN t6nzp_users AS uam
ON uam.id = a.modified_by
LEFT JOIN t6nzp_categories as parent
ON parent.id = c.parent_id
LEFT JOIN t6nzp_content_rating AS v
ON a.id = v.content_id1 × SELECT `m`.`tag_id`,`t`.*
FROM `t6nzp_contentitem_tag_map` AS m
INNER JOIN `t6nzp_tags` AS t
ON `m`.`tag_id` = `t`.`id`1 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM `t6nzp_categories` AS `s`
INNER JOIN `t6nzp_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)1 × SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM t6nzp_fields AS a
LEFT JOIN `t6nzp_languages` AS l
ON l.lang_code = a.language
LEFT JOIN t6nzp_users AS uc
ON uc.id=a.checked_out
LEFT JOIN t6nzp_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN t6nzp_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN t6nzp_fields_groups AS g
ON g.id = a.group_id1 × SELECT `id`
FROM `t6nzp_rstbox`1 × SELECT *
FROM `t6nzp_rstbox`1 × SELECT `a`.`menutype`,`a`.`title`
FROM `t6nzp_menu_types` AS `a`1 × SELECT m.id, m.alias, m.path AS route, m.level, m.parent_id
FROM t6nzp_menu AS m1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM t6nzp_modules AS m
LEFT JOIN t6nzp_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN t6nzp_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id1 × SELECT *
FROM `t6nzp_extensions`1 × SELECT *
FROM t6nzp_gsd_config
OUTRAS tabelas:
1 × INSERT INTO `t6nzp_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'6632633435653263366634393632666337616237386664303734613362323939', 1, 1722048386, 0, '', 01 × UPDATE `t6nzp_extensions`
SET `params` = '{\"mediaversion\":\"ca639fc3b419ef1c8736214771f79f13\"}'1 × SHOW FULL COLUMNS
FROM `t6nzp_gsd_config