Notícias Recentes
-
Eleição dos Representantes dos Alunos do Ensino Secundário ao Conselho Geral do Agrupamento de Escolas Vieira de Araújo – 2023-2025
Comunicado do Conselho Geral do AEVA -
COMUNICADO DO CONSELHO GERAL DO AEVA
Processo eleitoral para a eleição dos representantes dos Pais e Encarregados de Educação -
ENTREGA DOS COMPUTADORES
AVISO - Entrega de Kits da Escola Digital -
Turmas 2023-2024
Turmas do Agrupamento de Escolas Vieira de Araújo - Ano Letivo 2023-2024
Contratações
-
Contratação de Escola - Horário 50 (Grupo recrutamento 120)
Eis que se publica o aviso de abertura para um horário, de 14 horas, para desempenho de funções no Agrupamento de Escolas Vieira de Araújo, em Vieira do Minho, no ano letivo 2023/2024. -
Contratação de Escola - Horário 49 (Grupo recrutamento 910)
Eis que se publica o aviso de abertura para um horário, de 14 horas, para desempenho de funções no Agrupamento de Escolas Vieira de Araújo, em Vieira do Minho, no ano letivo 2023/2024. -
Contratação de Escola - Horário 47 (Grupo recrutamento 320)
Eis que se publica o aviso de abertura para um horário, de 18 horas, para desempenho de funções no Agrupamento de Escolas Vieira de Araújo, em Vieira do Minho, no ano letivo 2023/2024. -
Contratação de Escola - Horário 42 (Grupo recrutamento 110)
Eis que se publica o aviso de abertura para um horário, de 20 horas, para desempenho de funções no Agrupamento de Escolas Vieira de Araújo, em Vieira do Minho, no ano letivo 2023/2024.
Informações sobre Exames e Provas 2020
Não publicadoDisponibilizam-se algumas informações gerais sobre as provas finais, provas de aferição e exames nacionais para o ano de 2020.
Contratação de Escola - Horário 50 (Grupo recrutamento 120)
Eis que se publica o aviso de abertura para um horário, de 14 horas, para desempenho de funções no Agrupamento de Escolas Vieira de Araújo, em Vieira do Minho, no ano letivo 2023/2024.
Contratação de Escola - Horário 49 (Grupo recrutamento 910)
Eis que se publica o aviso de abertura para um horário, de 14 horas, para desempenho de funções no Agrupamento de Escolas Vieira de Araújo, em Vieira do Minho, no ano letivo 2023/2024.
© 2024 AEVA
Consola de depuração Joomla
{
"__default": {
"session": {
"counter": 1,
"timer": {
"start": 1713587055,
"last": 1713587055,
"now": 1713587055
},
"token": "kPpaaln0DNB0c3KYaCyVZRIZzX1YLe6n"
},
"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
},
"plg_system_languagefilter": {
"language": "pt-PT"
}
},
"__easycalccheckplus": {
"redirect_url": null,
"ecc_loaded": null
}
}
Hora
Memória
Hora: 9.65 ms / 9.65 ms Memória: 1.778 MB / 2.15 MB Application: afterLoad
Hora: 35.53 ms / 45.18 ms Memória: 4.690 MB / 6.84 MB Application: afterInitialise
Hora: 10.51 ms / 55.69 ms Memória: 1.217 MB / 8.06 MB Application: afterRoute
Hora: 0.81 ms / 56.50 ms Memória: 0.173 MB / 8.23 MB Application: beforeRenderComponent com_content
Hora: 3.88 ms / 60.38 ms Memória: 0.613 MB / 8.84 MB Application: Before Access::preloadComponents (all components)
Hora: 1.04 ms / 61.42 ms Memória: 0.061 MB / 8.91 MB Application: After Access::preloadComponents (all components)
Hora: 0.04 ms / 61.45 ms Memória: 0.000 MB / 8.90 MB Application: Before Access::getAssetRules (id:8 name:com_content)
Hora: 0.36 ms / 61.81 ms Memória: 0.026 MB / 8.93 MB Application: After Access::getAssetRules (id:8 name:com_content)
Hora: 28.12 ms / 89.94 ms Memória: 1.621 MB / 10.55 MB Application: afterRenderComponent com_content
Hora: 0.82 ms / 90.75 ms Memória: 0.098 MB / 10.65 MB Application: afterDispatch
Hora: 4.14 ms / 94.89 ms Memória: 0.306 MB / 10.95 MB Application: beforeRenderModule mod_favsocial (Social)
Hora: 0.52 ms / 95.41 ms Memória: 0.048 MB / 11.00 MB Application: afterRenderModule mod_favsocial (Social)
Hora: 0.06 ms / 95.47 ms Memória: 0.000 MB / 11.00 MB Application: beforeRenderModule mod_latestnewsenhanced (Contratações)
Hora: 30.68 ms / 126.16 ms Memória: 1.089 MB / 12.08 MB Application: afterRenderModule mod_latestnewsenhanced (Contratações)
Hora: 0.12 ms / 126.28 ms Memória: 0.000 MB / 12.03 MB Application: beforeRenderModule mod_latestnewsenhanced (Notícias Recentes)
Hora: 17.62 ms / 143.89 ms Memória: 0.120 MB / 12.15 MB Application: afterRenderModule mod_latestnewsenhanced (Notícias Recentes)
Hora: 0.08 ms / 143.97 ms Memória: 0.000 MB / 12.09 MB Application: beforeRenderModule mod_favslider (Slide)
Hora: 0.79 ms / 144.76 ms Memória: 0.058 MB / 12.15 MB Application: afterRenderModule mod_favslider (Slide)
Hora: 0.04 ms / 144.81 ms Memória: 0.000 MB / 12.13 MB Application: beforeRenderModule mod_menu (Main Menu)
Hora: 3.93 ms / 148.73 ms Memória: 0.208 MB / 12.34 MB Application: afterRenderModule mod_menu (Main Menu)
Hora: 0.02 ms / 148.76 ms Memória: 0.001 MB / 12.34 MB Application: beforeRenderModule mod_sclogin (SCLogin)
Hora: 3.03 ms / 151.78 ms Memória: 0.722 MB / 13.06 MB Application: afterRenderModule mod_sclogin (SCLogin)
Hora: 29.91 ms / 181.69 ms Memória: 0.176 MB / 13.23 MB Application: afterRender
Total de consultas à base de dados: 38.47 ms
13,98 MB (14 662 688 Bytes)
35 pedidos registados 38.47 ms
- Tempo da consulta: 0.38 ms Consulta a Memória: 0.007 MB de memória antes da consulta: 3.894 MB Linhas devolvidas: 0
SELECT `data`
FROM `site2_session`
WHERE `session_id` = '197fec5b75cc9c0363cb45a4d3e2e049'id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE site2_session const PRIMARY PRIMARY 194 const 1 100.00 Status Duration Starting 0.08 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.01 ms Executing 0.01 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.03 ms Updating status 0.03 ms Reset for next command 0.01 ms # Chamador Ficheiro e número da linha 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1734 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:660 9 Joomla\CMS\Session\Session->_start() JROOT/libraries/src/Session/Session.php:620 8 Joomla\CMS\Session\Session->start() JROOT/libraries/src/Session/Session.php:498 7 Joomla\CMS\Session\Session->get() JROOT/libraries/src/Session/Session.php:455 6 Joomla\CMS\Session\Session->isNew() JROOT/libraries/src/Application/CMSApplication.php:758 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:135 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:344 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.34 ms Após a última consulta: 0.96 ms Consulta a Memória: 0.004 MB de memória antes da consulta: 3.997 MB Linhas devolvidas: 0
SELECT `session_id`
FROM `site2_session`
WHERE `session_id` = '197fec5b75cc9c0363cb45a4d3e2e049'
LIMIT 1id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE site2_session const PRIMARY PRIMARY 194 const 1 100.00 Using index Status Duration Starting 0.11 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.01 ms Executing 0.01 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.05 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:1734 8 JDatabaseDriver->loadResult() JROOT/libraries/src/Session/MetadataManager.php:74 7 Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() JROOT/libraries/src/Application/CMSApplication.php:153 6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:760 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:135 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:344 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.54 ms Após a última consulta: 0.06 ms Consulta a Memória: 0.004 MB de memória antes da consulta: 4.002 MB
INSERT INTO `site2_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES ('197fec5b75cc9c0363cb45a4d3e2e049', 1, 1713587055, 0, '', 0)EXPLAIN não é possível na consulta: INSERT INTO `site2_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('197fec5b75cc9c0363cb45a4d3e2e049', 1, 1713587055, 0, '', 0)Status Duration Starting 0.07 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.01 ms Update 0.05 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.22 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.04 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:153 6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:760 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:135 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:344 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.50 ms Após a última consulta: 1.75 ms Consulta a Memória: 0.006 MB de memória antes da consulta: 4.213 MB Linhas devolvidas: 36
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `site2_extensions`
WHERE `type` = 'component'
AND `state` = 0
AND `enabled` = 1id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE site2_extensions ref extension extension 82 const 36 100.00 Using index condition; Using where Status Duration Starting 0.06 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.03 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.12 ms End of update loop 0.01 ms Query end 0.02 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.05 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:1695 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo da consulta: 0.33 ms Após a última consulta: 1.45 ms Consulta a Memória: 0.005 MB de memória antes da consulta: 4.413 MB Linhas devolvidas: 5
SELECT id, rules
FROM `site2_viewlevels`id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE site2_viewlevels ALL NULL Nehnuma INDEX KEY pode ser utilizada NULL NULL 5 100.00 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.01 ms Optimizing 0.01 ms Statistics 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 closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.06 ms Updating status 0.01 ms Reset for next command 0.01 ms # Chamador Ficheiro e número da linha 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1500 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:321 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo da consulta: 0.40 ms Após a última consulta: 0.06 ms Consulta a Memória: 0.005 MB de memória antes da consulta: 4.425 MB Linhas devolvidas: 2
SELECT b.id
FROM site2_usergroups AS a
LEFT JOIN site2_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 filtered Extra 1 SIMPLE a const PRIMARY PRIMARY 4 const 1 100.00 1 SIMPLE b range idx_usergroup_nested_set_lookup idx_usergroup_nested_set_lookup 4 NULL 2 100.00 Using where; Using index Status Duration Starting 0.07 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.01 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 closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.04 ms Updating status 0.03 ms Reset for next command 0.02 ms # Chamador Ficheiro e número da linha 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1544 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:321 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo da consulta: 0.69 ms Após a última consulta: 0.43 ms Consulta a Memória: 0.005 MB de memória antes da consulta: 4.554 MB Linhas devolvidas: 89
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM site2_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 filtered Extra 1 SIMPLE site2_extensions ALL extension Nehnuma INDEX KEY pode ser utilizada NULL NULL 225 48.44 Using where; Filesort em utilização Status Duration Starting 0.06 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.03 ms Sorting result 0.01 ms Executing 0.02 ms Sending data 0.01 ms Creating sort index 0.22 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.02 ms closing tables 0.01 ms Starting cleanup 0.02 ms Freeing items 0.06 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:1695 10 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Plugin/PluginHelper.php:354 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:359 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo da consulta: 0.45 ms Após a última consulta: 7.75 ms Consulta a Memória: 0.005 MB de memória antes da consulta: 5.655 MB Linhas devolvidas: 1
SELECT *
FROM site2_languages
WHERE published=1
ORDER BY ordering ASCid select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE site2_languages ALL NULL Nehnuma INDEX KEY pode ser utilizada NULL NULL 2 100.00 Using where; Filesort em utilização Status Duration Starting 0.08 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.01 ms Preparing 0.01 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.01 ms Creating sort index 0.04 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.04 ms Updating status 0.01 ms Reset for next command 0.02 ms # Chamador Ficheiro e número da linha 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 9 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Language/LanguageHelper.php:150 8 Joomla\CMS\Language\LanguageHelper::getLanguages() JROOT/plugins/system/languagefilter/languagefilter.php:96 7 PlgSystemLanguageFilter->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:283 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:625 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo da consulta: 0.40 ms Após a última consulta: 0.07 ms Consulta a Memória: 0.005 MB de memória antes da consulta: 5.664 MB Linhas devolvidas: 6
SELECT `element`,`name`,`client_id`,`extension_id`
FROM `site2_extensions`
WHERE `type` = 'language'
AND `state` = 0
AND `enabled` = 1id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE site2_extensions ref extension extension 82 const 6 100.00 Using index condition; Using where Status Duration Starting 0.06 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.01 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.02 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 closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.05 ms Updating status 0.01 ms Reset for next command 0.01 ms # Chamador Ficheiro e número da linha 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 9 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Language/LanguageHelper.php:209 8 Joomla\CMS\Language\LanguageHelper::getInstalledLanguages() JROOT/plugins/system/languagefilter/languagefilter.php:110 7 PlgSystemLanguageFilter->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:283 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:625 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo da consulta: 0.77 ms Após a última consulta: 6.01 ms Consulta a Memória: 0.010 MB de memória antes da consulta: 6.624 MB Linhas devolvidas: 32
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 site2_menu AS m
LEFT JOIN site2_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 filtered Extra 1 SIMPLE m ref idx_client_id_parent_id_alias_language idx_client_id_parent_id_alias_language 1 const 102 73.91 Using index condition; Using where; Filesort em utilização 1 SIMPLE e eq_ref PRIMARY PRIMARY 4 aevapt_site2.m.component_id 1 100.00 Using where Status Duration Starting 0.09 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.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.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.04 ms Starting cleanup 0.01 ms Freeing items 0.04 ms Updating status 0.01 ms Reset for next command 0.01 ms # Chamador Ficheiro e número da linha 23 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 22 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Menu/SiteMenu.php:93 21 Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}() Igual à chamada na linha abaixo. 20 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 19 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Menu/SiteMenu.php:101 18 Joomla\CMS\Menu\SiteMenu->load() JROOT/libraries/src/Menu/AbstractMenu.php:76 17 Joomla\CMS\Menu\AbstractMenu->__construct() JROOT/libraries/src/Menu/SiteMenu.php:62 16 Joomla\CMS\Menu\SiteMenu->__construct() JROOT/libraries/src/Menu/AbstractMenu.php:131 15 Joomla\CMS\Menu\AbstractMenu::getInstance() JROOT/libraries/src/Application/CMSApplication.php:375 14 Joomla\CMS\Application\CMSApplication->getMenu() JROOT/libraries/src/Application/SiteApplication.php:275 13 Joomla\CMS\Application\SiteApplication->getMenu() JROOT/libraries/src/Router/SiteRouter.php:64 12 Joomla\CMS\Router\SiteRouter->__construct() JROOT/libraries/src/Router/Router.php:189 11 Joomla\CMS\Router\Router::getInstance() JROOT/libraries/src/Application/CMSApplication.php:491 10 Joomla\CMS\Application\CMSApplication::getRouter() JROOT/libraries/src/Application/SiteApplication.php:403 9 Joomla\CMS\Application\SiteApplication::getRouter() JROOT/plugins/system/languagefilter/languagefilter.php:145 8 PlgSystemLanguageFilter->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:626 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo da consulta: 0.42 ms Após a última consulta: 5.42 ms Consulta a Memória: 0.009 MB de memória antes da consulta: 7.389 MB Linhas devolvidas: 1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `site2_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE site2_extensions ref element_clientid,element_folder_clientid,extension extension 484 const,const 1 100.00 Using index condition Status Duration Starting 0.08 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.05 ms Preparing 0.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 closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.04 ms Updating status 0.03 ms Reset for next command 0.01 ms # Chamador Ficheiro e número da linha 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1656 18 JDatabaseDriver->loadObject() JROOT/libraries/src/Helper/LibraryHelper.php:167 17 Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{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/Helper/LibraryHelper.php:175 14 Joomla\CMS\Helper\LibraryHelper::loadLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:43 13 Joomla\CMS\Helper\LibraryHelper::getLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:90 12 Joomla\CMS\Helper\LibraryHelper::getParams() JROOT/libraries/src/Version.php:321 11 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 10 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 9 Joomla\CMS\Factory::getDocument() JROOT/plugins/system/k2/k2.php:388 8 plgSystemK2->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:1122 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo da consulta: 0.62 ms Após a última consulta: 0.10 ms Consulta a Memória: 0.006 MB de memória antes da consulta: 7.381 MB
UPDATE `site2_extensions`
SET `params` = '{\"mediaversion\":\"e516f7eaaf3fc8d7557b0022696869da\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE site2_extensions range element_clientid,element_folder_clientid,extension extension 484 NULL 1 100.00 Using where Status Duration Starting 0.05 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init for update 0.03 ms Updating 0.04 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.23 ms closing tables 0.01 ms Unlocking tables 0.02 ms closing tables 0.03 ms Starting cleanup 0.01 ms Freeing items 0.05 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/src/Helper/LibraryHelper.php:117 13 Joomla\CMS\Helper\LibraryHelper::saveParams() JROOT/libraries/src/Version.php:372 12 Joomla\CMS\Version->setMediaVersion() JROOT/libraries/src/Version.php:331 11 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 10 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 9 Joomla\CMS\Factory::getDocument() JROOT/plugins/system/k2/k2.php:388 8 plgSystemK2->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:1122 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo da consulta: 0.46 ms Após a última consulta: 3.97 ms Consulta a Memória: 0.009 MB de memória antes da consulta: 8.020 MB Linhas devolvidas: 2
SELECT id, home, template, s.params
FROM site2_template_styles as s
LEFT JOIN site2_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 filtered Extra 1 SIMPLE s ALL idx_template Nehnuma INDEX KEY pode ser utilizada NULL NULL 4 100.00 Using where 1 SIMPLE e ref element_clientid,element_folder_clientid,extension element_clientid 403 aevapt_site2.s.template,const 1 2.67 Using index condition; Using where Status Duration Starting 0.07 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.02 ms Statistics 0.04 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.05 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.06 ms Updating status 0.01 ms Reset for next command 0.01 ms # Chamador Ficheiro e número da linha 21 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 20 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Application/SiteApplication.php:486 19 Joomla\CMS\Application\SiteApplication->getTemplate() JROOT/libraries/src/HTML/HTMLHelper.php:365 18 Joomla\CMS\HTML\HTMLHelper::includeRelativeFiles() JROOT/libraries/src/HTML/HTMLHelper.php:712 17 Joomla\CMS\HTML\HTMLHelper::script() Igual à chamada na linha abaixo. 16 call_user_func_array() JROOT/libraries/src/HTML/HTMLHelper.php:239 15 Joomla\CMS\HTML\HTMLHelper::call() JROOT/libraries/src/HTML/HTMLHelper.php:146 14 Joomla\CMS\HTML\HTMLHelper::_() JROOT/libraries/cms/html/jquery.php:52 13 JHtmlJquery::framework() Igual à chamada na linha abaixo. 12 call_user_func_array() JROOT/libraries/src/HTML/HTMLHelper.php:239 11 Joomla\CMS\HTML\HTMLHelper::call() JROOT/libraries/src/HTML/HTMLHelper.php:146 10 Joomla\CMS\HTML\HTMLHelper::_() JROOT/administrator/components/com_k2/helpers/html.php:71 9 K2HelperHTML::loadHeadIncludes() JROOT/plugins/system/k2/k2.php:404 8 plgSystemK2->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:1122 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo da consulta: 0.86 ms Após a última consulta: 5.37 ms Consulta a Memória: 0.010 MB de memória antes da consulta: 8.849 MB Linhas devolvidas: 36
SELECT `id`,`name`,`rules`,`parent_id`
FROM `site2_assets`
WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_installer','com_jce','com_joomlaupdate','com_k2','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_tags','com_templates','com_users','com_wrapper')id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE site2_assets range idx_asset_name idx_asset_name 202 NULL 37 100.00 Using index condition Status Duration Starting 0.13 ms checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.05 ms Optimizing 0.01 ms Statistics 0.08 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.29 ms End of update loop 0.01 ms Query end 0.02 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.05 ms Updating status 0.01 ms Reset for next command 0.02 ms # Chamador Ficheiro e número da linha 21 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 20 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Access/Access.php:429 19 Joomla\CMS\Access\Access::preloadComponents() JROOT/libraries/src/Access/Access.php:213 18 Joomla\CMS\Access\Access::preload() JROOT/libraries/src/Access/Access.php:531 17 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 16 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 15 Joomla\CMS\User\User->authorise() JROOT/components/com_content/models/articles.php:115 14 ContentModelArticles->populateState() JROOT/components/com_content/models/featured.php:44 13 ContentModelFeatured->populateState() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:440 12 Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() JROOT/libraries/src/MVC/View/HtmlView.php:425 11 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_content/views/featured/view.html.php:55 10 ContentViewFeatured->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo da consulta: 4.18 ms Após a última consulta: 1.23 ms Consulta a Memória: 0.008 MB de memória antes da consulta: 8.987 MB Linhas devolvidas: 4
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 site2_content AS a
LEFT JOIN site2_categories AS c
ON c.id = a.catid
LEFT JOIN site2_users AS ua
ON ua.id = a.created_by
LEFT JOIN site2_users AS uam
ON uam.id = a.modified_by
LEFT JOIN site2_categories as parent
ON parent.id = c.parent_id
LEFT JOIN site2_content_rating AS v
ON a.id = v.content_id
WHERE a.featured = 1
AND a.access IN (1,1,5)
AND c.access IN (1,1,5)
AND c.published = 1
AND a.state IN (0,1,2)
AND a.language IN ('pt-PT','*')
ORDER BY c.lft, a.ordering, a.created DESC
LIMIT 36, 4id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a range idx_access,idx_state,idx_catid,idx_featured_catid,idx_language idx_featured_catid 1 NULL 151 100.00 Using index condition; Using where; Using temporary; Filesort em utilização 1 SIMPLE c eq_ref PRIMARY,idx_access PRIMARY 4 aevapt_site2.a.catid 1 100.00 Using where 1 SIMPLE ua eq_ref PRIMARY PRIMARY 4 aevapt_site2.a.created_by 1 100.00 Using where 1 SIMPLE uam eq_ref PRIMARY PRIMARY 4 aevapt_site2.a.modified_by 1 100.00 Using where 1 SIMPLE parent eq_ref PRIMARY PRIMARY 4 aevapt_site2.c.parent_id 1 100.00 Using where 1 SIMPLE v eq_ref PRIMARY PRIMARY 4 aevapt_site2.a.id 1 100.00 Using where Status Duration Starting 0.24 ms checking permissions 0.02 ms Opening tables 0.05 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.02 ms init 0.09 ms Optimizing 0.03 ms Statistics 0.19 ms Preparing 0.06 ms Creating tmp table 0.11 ms Sorting result 0.02 ms Executing 0.01 ms Sending data 1.98 ms Creating sort index 0.35 ms Removing tmp table 0.67 ms Creating sort index 0.02 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.02 ms Starting cleanup 0.02 ms Freeing items 0.10 ms Updating status 0.01 ms Reset for next command 0.01 ms # Chamador Ficheiro e número da linha 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 16 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 15 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:187 14 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/components/com_content/models/articles.php:576 13 ContentModelArticles->getItems() JROOT/components/com_content/models/featured.php:125 12 ContentModelFeatured->getItems() JROOT/libraries/src/MVC/View/HtmlView.php:425 11 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_content/views/featured/view.html.php:56 10 ContentViewFeatured->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo da consulta: 0.65 ms Após a última consulta: 2.09 ms Consulta a Memória: 0.007 MB de memória antes da consulta: 9.246 MB Linhas devolvidas: 0
SELECT `m`.`tag_id`,`t`.*
FROM `site2_contentitem_tag_map` AS m
INNER JOIN `site2_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 105
AND `t`.`published` = 1
AND t.access IN (1,1,5)id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m ALL idx_tag_type Nehnuma INDEX KEY pode ser utilizada NULL NULL 1 100.00 Using where 1 SIMPLE t eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 aevapt_site2.m.tag_id 1 100.00 Using where Status Duration Starting 0.14 ms checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.04 ms Optimizing 0.03 ms Statistics 0.11 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 closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.04 ms Updating status 0.02 ms Reset for next command 0.01 ms # Chamador Ficheiro e número da linha 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 15 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Helper/TagsHelper.php:454 14 Joomla\CMS\Helper\TagsHelper->getItemTags() JROOT/components/com_content/models/articles.php:706 13 ContentModelArticles->getItems() JROOT/components/com_content/models/featured.php:125 12 ContentModelFeatured->getItems() JROOT/libraries/src/MVC/View/HtmlView.php:425 11 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_content/views/featured/view.html.php:56 10 ContentViewFeatured->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo da consulta: 0.48 ms Após a última consulta: 0.15 ms Consulta a Memória: 0.008 MB de memória antes da consulta: 9.269 MB Linhas devolvidas: 0Consultas duplicadas: #26
SELECT `m`.`tag_id`,`t`.*
FROM `site2_contentitem_tag_map` AS m
INNER JOIN `site2_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 277
AND `t`.`published` = 1
AND t.access IN (1,1,5)id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m ALL idx_tag_type Nehnuma INDEX KEY pode ser utilizada NULL NULL 1 100.00 Using where 1 SIMPLE t eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 aevapt_site2.m.tag_id 1 100.00 Using where Status Duration Starting 0.08 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 Executing 0.01 ms Sending data 0.02 ms End of update loop 0.01 ms Query end 0.04 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.04 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/joomla/database/driver.php:1695 15 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Helper/TagsHelper.php:454 14 Joomla\CMS\Helper\TagsHelper->getItemTags() JROOT/components/com_content/models/articles.php:706 13 ContentModelArticles->getItems() JROOT/components/com_content/models/featured.php:125 12 ContentModelFeatured->getItems() JROOT/libraries/src/MVC/View/HtmlView.php:425 11 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_content/views/featured/view.html.php:56 10 ContentViewFeatured->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo da consulta: 0.41 ms Após a última consulta: 0.18 ms Consulta a Memória: 0.007 MB de memória antes da consulta: 9.290 MB Linhas devolvidas: 0Consultas duplicadas: #27
SELECT `m`.`tag_id`,`t`.*
FROM `site2_contentitem_tag_map` AS m
INNER JOIN `site2_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 276
AND `t`.`published` = 1
AND t.access IN (1,1,5)id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m ALL idx_tag_type Nehnuma INDEX KEY pode ser utilizada NULL NULL 1 100.00 Using where 1 SIMPLE t eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 aevapt_site2.m.tag_id 1 100.00 Using where Status Duration Starting 0.07 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.03 ms Optimizing 0.02 ms Statistics 0.04 ms Preparing 0.02 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 closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.04 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/joomla/database/driver.php:1695 15 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Helper/TagsHelper.php:454 14 Joomla\CMS\Helper\TagsHelper->getItemTags() JROOT/components/com_content/models/articles.php:706 13 ContentModelArticles->getItems() JROOT/components/com_content/models/featured.php:125 12 ContentModelFeatured->getItems() JROOT/libraries/src/MVC/View/HtmlView.php:425 11 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_content/views/featured/view.html.php:56 10 ContentViewFeatured->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo da consulta: 0.60 ms Após a última consulta: 0.13 ms Consulta a Memória: 0.007 MB de memória antes da consulta: 9.311 MB Linhas devolvidas: 0Consultas duplicadas: #28
SELECT `m`.`tag_id`,`t`.*
FROM `site2_contentitem_tag_map` AS m
INNER JOIN `site2_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 275
AND `t`.`published` = 1
AND t.access IN (1,1,5)id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m ALL idx_tag_type Nehnuma INDEX KEY pode ser utilizada NULL NULL 1 100.00 Using where 1 SIMPLE t eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 aevapt_site2.m.tag_id 1 100.00 Using where Status Duration Starting 0.19 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.04 ms Optimizing 0.03 ms Statistics 0.06 ms Preparing 0.02 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 closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.03 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/joomla/database/driver.php:1695 15 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Helper/TagsHelper.php:454 14 Joomla\CMS\Helper\TagsHelper->getItemTags() JROOT/components/com_content/models/articles.php:706 13 ContentModelArticles->getItems() JROOT/components/com_content/models/featured.php:125 12 ContentModelFeatured->getItems() JROOT/libraries/src/MVC/View/HtmlView.php:425 11 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_content/views/featured/view.html.php:56 10 ContentViewFeatured->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo da consulta: 1.28 ms Após a última consulta: 1.28 ms Consulta a Memória: 0.007 MB de memória antes da consulta: 9.384 MB Linhas devolvidas: 1
SELECT COUNT(*)
FROM site2_content AS a
LEFT JOIN site2_categories AS c
ON c.id = a.catid
LEFT JOIN site2_users AS ua
ON ua.id = a.created_by
LEFT JOIN site2_users AS uam
ON uam.id = a.modified_by
LEFT JOIN site2_categories as parent
ON parent.id = c.parent_id
LEFT JOIN site2_content_rating AS v
ON a.id = v.content_id
WHERE a.featured = 1
AND a.access IN (1,1,5)
AND c.access IN (1,1,5)
AND c.published = 1
AND a.state IN (0,1,2)
AND a.language IN ('pt-PT','*')id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a ALL idx_access,idx_state,idx_catid,idx_featured_catid,idx_language Nehnuma INDEX KEY pode ser utilizada NULL NULL 236 63.98 Using where 1 SIMPLE c eq_ref PRIMARY,idx_access PRIMARY 4 aevapt_site2.a.catid 1 100.00 Using where Status Duration Starting 0.15 ms checking permissions 0.02 ms Opening tables 0.05 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.05 ms Optimizing 0.07 ms Statistics 0.16 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.08 ms Executing 0.01 ms Sending data 0.40 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.04 ms closing tables 0.02 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.06 ms Updating status 0.02 ms Reset for next command 0.01 ms # Chamador Ficheiro e número da linha 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1734 15 JDatabaseDriver->loadResult() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:340 14 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount() JROOT/libraries/src/MVC/Model/ListModel.php:282 13 Joomla\CMS\MVC\Model\ListModel->getTotal() JROOT/libraries/src/MVC/Model/ListModel.php:232 12 Joomla\CMS\MVC\Model\ListModel->getPagination() JROOT/libraries/src/MVC/View/HtmlView.php:425 11 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_content/views/featured/view.html.php:57 10 ContentViewFeatured->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo da consulta: 0.83 ms Após a última consulta: 5.09 ms Consulta a Memória: 0.010 MB de memória antes da consulta: 9.884 MB Linhas devolvidas: 3
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 `site2_categories` AS `s`
INNER JOIN `site2_categories` AS `c`
ON (s.lft < c.lft
AND c.lft < s.rgt
AND c.language IN ('pt-PT','*')) 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 = 26
ORDER BY c.lftid select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE s const PRIMARY,idx_left_right PRIMARY 4 const 1 100.00 1 SIMPLE c ALL cat_idx,idx_access,idx_left_right,idx_language Nehnuma INDEX KEY pode ser utilizada NULL NULL 27 28.53 Using where; Filesort em utilização Status Duration Starting 0.20 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.06 ms Optimizing 0.04 ms Statistics 0.12 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.10 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.07 ms Updating status 0.01 ms Reset for next command 0.01 ms # Chamador Ficheiro e número da linha 21 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 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:133 16 Joomla\CMS\MVC\Model\ListModel->_getListQuery() JROOT/libraries/src/MVC/Model/ListModel.php:187 15 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:135 14 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:488 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/featured/view.html.php:102 10 ContentViewFeatured->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo da consulta: 1.10 ms Após a última consulta: 0.43 ms Consulta a Memória: 0.009 MB de memória antes da consulta: 9.935 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 site2_fields AS a
LEFT JOIN `site2_languages` AS l
ON l.lang_code = a.language
LEFT JOIN site2_users AS uc
ON uc.id=a.checked_out
LEFT JOIN site2_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN site2_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN site2_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `site2_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 (26,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 filtered Extra 1 SIMPLE a ref idx_state,idx_access,idx_context idx_state 1 const 1 100.00 Using where; Using temporary; Filesort em utilização 1 SIMPLE l eq_ref idx_langcode idx_langcode 28 aevapt_site2.a.language 1 100.00 Using where 1 SIMPLE uc eq_ref PRIMARY PRIMARY 4 aevapt_site2.a.checked_out 1 100.00 1 SIMPLE ag eq_ref PRIMARY PRIMARY 4 aevapt_site2.a.access 1 100.00 Using where 1 SIMPLE ua eq_ref PRIMARY PRIMARY 4 aevapt_site2.a.created_user_id 1 100.00 Using where 1 SIMPLE g eq_ref PRIMARY PRIMARY 4 aevapt_site2.a.group_id 1 100.00 Using where 1 SIMPLE fc ref PRIMARY PRIMARY 4 aevapt_site2.a.id 1 100.00 Using where; Using index; Distinct Status Duration Starting 0.13 ms checking permissions 0.01 ms Opening tables 0.04 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.06 ms Optimizing 0.04 ms Statistics 0.17 ms Preparing 0.04 ms Creating tmp table 0.05 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.24 ms Creating sort index 0.03 ms Removing tmp table 0.07 ms Creating sort index 0.02 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.06 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:1695 18 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 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:187 15 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:135 14 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:488 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/featured/view.html.php:102 10 ContentViewFeatured->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo da consulta: 0.83 ms Após a última consulta: 2.09 ms Consulta a Memória: 0.009 MB de memória antes da consulta: 10.211 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 site2_fields AS a
LEFT JOIN `site2_languages` AS l
ON l.lang_code = a.language
LEFT JOIN site2_users AS uc
ON uc.id=a.checked_out
LEFT JOIN site2_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN site2_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN site2_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `site2_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 (27,0,26))
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 filtered Extra 1 SIMPLE a ref idx_state,idx_access,idx_context idx_state 1 const 1 100.00 Using where; Using temporary; Filesort em utilização 1 SIMPLE l eq_ref idx_langcode idx_langcode 28 aevapt_site2.a.language 1 100.00 Using where 1 SIMPLE uc eq_ref PRIMARY PRIMARY 4 aevapt_site2.a.checked_out 1 100.00 1 SIMPLE ag eq_ref PRIMARY PRIMARY 4 aevapt_site2.a.access 1 100.00 Using where 1 SIMPLE ua eq_ref PRIMARY PRIMARY 4 aevapt_site2.a.created_user_id 1 100.00 Using where 1 SIMPLE g eq_ref PRIMARY PRIMARY 4 aevapt_site2.a.group_id 1 100.00 Using where 1 SIMPLE fc ref PRIMARY PRIMARY 4 aevapt_site2.a.id 1 100.00 Using where; Using index; Distinct Status Duration Starting 0.10 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.06 ms Preparing 0.03 ms Creating tmp table 0.03 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.20 ms Creating sort index 0.02 ms Removing tmp table 0.04 ms Creating sort index 0.01 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.03 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.02 ms Starting cleanup 0.01 ms Freeing items 0.08 ms Updating status 0.01 ms Reset for next command 0.01 ms # Chamador Ficheiro e número da linha 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 18 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 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:187 15 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:135 14 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:488 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/featured/view.html.php:102 10 ContentViewFeatured->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo da consulta: 0.89 ms Após a última consulta: 8.73 ms Consulta a Memória: 0.007 MB de memória antes da consulta: 10.961 MB Linhas devolvidas: 6
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM site2_modules AS m
LEFT JOIN site2_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN site2_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-04-20 04:24:15')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-04-20 04:24:15')
AND m.access IN (1,1,5)
AND m.client_id = 0
AND (mm.menuid = 101 OR mm.menuid <= 0)
AND m.language IN ('pt-PT','*')
ORDER BY m.position, m.orderingid select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m range PRIMARY,published,newsfeeds,idx_language published 5 NULL 11 100.00 Using index condition; Using where; Filesort em utilização 1 SIMPLE e ref element_clientid,element_folder_clientid element_clientid 403 aevapt_site2.m.module,const 1 100.00 Using index condition; Using where 1 SIMPLE mm ref PRIMARY PRIMARY 4 aevapt_site2.m.id 1 100.00 Using where; Using index Status Duration Starting 0.19 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.05 ms Optimizing 0.05 ms Statistics 0.08 ms Preparing 0.05 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.01 ms Creating sort index 0.18 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.07 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:1695 14 JDatabaseDriver->loadObjectList() Igual à chamada na linha abaixo. 13 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 12 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:432 11 Joomla\CMS\Helper\ModuleHelper::getModuleList() JROOT/libraries/src/Helper/ModuleHelper.php:362 10 Joomla\CMS\Helper\ModuleHelper::load() JROOT/libraries/src/Helper/ModuleHelper.php:87 9 Joomla\CMS\Helper\ModuleHelper::getModules() JROOT/libraries/src/Document/HtmlDocument.php:581 8 Joomla\CMS\Document\HtmlDocument->countModules() JROOT/templates/favourite/index.php:158 7 require JROOT/templates/favourite/index.php JROOT/libraries/src/Document/HtmlDocument.php:658 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:720 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:535 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1030 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:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo da consulta: 11.03 ms Após a última consulta: 7.33 ms Consulta a Memória: 0.006 MB de memória antes da consulta: 11.990 MB Linhas devolvidas: 4
SELECT DISTINCT a.id, a.title, a.alias, a.introtext, a.fulltext,
CASE WHEN a.fulltext IS NULL OR a.fulltext = '' THEN 0 ELSE 1 END AS fulltexthascontent, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, 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.featured, a.language,
CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,
CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END AS slug,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END AS cat_slug,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
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,ROUND(v.rating_sum / v.rating_count, 1) AS rating, v.rating_count as rating_count,c.published,
CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published,`a`.`publish_up` AS `date`
FROM site2_content AS a
LEFT JOIN site2_categories AS c
ON c.id = a.catid
LEFT JOIN site2_users AS ua
ON ua.id = a.created_by
LEFT JOIN site2_users AS uam
ON uam.id = a.modified_by
LEFT JOIN site2_categories as parent
ON parent.id = c.parent_id
LEFT JOIN site2_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM site2_categories AS cat JOIN site2_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id ) AS badcats
ON badcats.id = c.id
WHERE
CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1
AND a.access IN (1,1,5)
AND c.access IN (1,1,5)
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-04-20 04:24:15')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-20 04:24:15')
AND a.catid IN (27)
AND a.language IN ('pt-PT','*')
ORDER BY a.publish_up DESC
LIMIT 4id select_type table type possible_keys key key_len ref rows filtered Extra 1 PRIMARY c const PRIMARY,idx_access PRIMARY 4 const 1 100.00 Using temporary; Filesort em utilização 1 PRIMARY a range idx_access,idx_catid,idx_language idx_catid 4 NULL 167 100.00 Using index condition; Using where 1 PRIMARY ua eq_ref PRIMARY PRIMARY 4 aevapt_site2.a.created_by 1 100.00 Using where 1 PRIMARY uam eq_ref PRIMARY PRIMARY 4 aevapt_site2.a.modified_by 1 100.00 Using where 1 PRIMARY parent eq_ref PRIMARY PRIMARY 4 const 1 100.00 Using where 1 PRIMARY v eq_ref PRIMARY PRIMARY 4 aevapt_site2.a.id 1 100.00 Using where 1 PRIMARY <derived2> ref key0 key0 5 const 0 0.00 Using where 2 LATERAL DERIVED cat const PRIMARY,idx_left_right PRIMARY 4 const 1 100.00 2 LATERAL DERIVED parent ALL cat_idx,idx_left_right Nehnuma INDEX KEY pode ser utilizada NULL NULL 27 62.96 Using where; Using join buffer (flat, BNL join) Status Duration Sending data 0.05 ms Executing 0.01 ms Sending data 0.05 ms Executing 0.01 ms Sending data 0.04 ms Executing 0.01 ms Sending data 0.05 ms Executing 0.01 ms Sending data 0.04 ms Executing 0.01 ms Sending data 0.04 ms Executing 0.01 ms Sending data 0.05 ms Executing 0.01 ms Sending data 0.04 ms Executing 0.01 ms Sending data 0.05 ms Executing 0.01 ms Sending data 0.04 ms Executing 0.01 ms Sending data 0.05 ms Executing 0.01 ms Sending data 0.04 ms Executing 0.01 ms Sending data 0.05 ms Executing 0.01 ms Sending data 0.05 ms Executing 0.01 ms Sending data 0.05 ms Executing 0.01 ms Sending data 0.04 ms Executing 0.01 ms Sending data 0.04 ms Executing 0.01 ms Sending data 0.05 ms Executing 0.01 ms Sending data 0.04 ms Executing 0.01 ms Sending data 0.05 ms Executing 0.01 ms Sending data 0.05 ms Executing 0.01 ms Sending data 0.05 ms Executing 0.01 ms Sending data 0.05 ms Executing 0.01 ms Sending data 0.05 ms Executing 0.01 ms Sending data 0.04 ms Executing 0.01 ms Sending data 0.05 ms Executing 0.01 ms Sending data 0.05 ms Executing 0.01 ms Sending data 0.07 ms Executing 0.01 ms Sending data 0.07 ms Executing 0.01 ms Sending data 0.07 ms Executing 0.01 ms Sending data 0.08 ms Executing 0.01 ms Sending data 0.08 ms Executing 0.01 ms Sending data 0.05 ms Executing 0.01 ms Sending data 0.05 ms Executing 0.01 ms Sending data 0.05 ms Executing 0.01 ms Sending data 0.04 ms Executing 0.01 ms Sending data 0.05 ms Executing 0.01 ms Sending data 0.04 ms Executing 0.01 ms Sending data 0.05 ms Executing 0.01 ms Sending data 0.04 ms Executing 0.01 ms Sending data 0.04 ms Executing 0.01 ms Sending data 0.05 ms Executing 0.01 ms Sending data 0.04 ms Creating sort index 0.17 ms Removing tmp table 0.12 ms Creating sort index 0.01 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Removing tmp table 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.02 ms Starting cleanup 0.01 ms Freeing items 0.09 ms Updating status 0.01 ms Reset for next command 0.01 ms # Chamador Ficheiro e número da linha 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 12 JDatabaseDriver->loadObjectList() JROOT/modules/mod_latestnewsenhanced/helpers/helper_standard.php:739 11 modLatestNewsEnhancedExtendedHelperStandard::getList() JROOT/modules/mod_latestnewsenhanced/mod_latestnewsenhanced.php:39 10 include JROOT/modules/mod_latestnewsenhanced/mod_latestnewsenhanced.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1044 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:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo da consulta: 0.42 ms Após a última consulta: 0.26 ms Consulta a Memória: 0.007 MB de memória antes da consulta: 12.031 MB Linhas devolvidas: 0Consultas duplicadas: #17
SELECT `m`.`tag_id`,`t`.*
FROM `site2_contentitem_tag_map` AS m
INNER JOIN `site2_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 277
AND `t`.`published` = 1
AND t.access IN (1,1,5)id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m ALL idx_tag_type Nehnuma INDEX KEY pode ser utilizada NULL NULL 1 100.00 Using where 1 SIMPLE t eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 aevapt_site2.m.tag_id 1 100.00 Using where Status Duration Starting 0.08 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 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 closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.06 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:1695 13 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Helper/TagsHelper.php:454 12 Joomla\CMS\Helper\TagsHelper->getItemTags() JROOT/modules/mod_latestnewsenhanced/helpers/helper_standard.php:966 11 modLatestNewsEnhancedExtendedHelperStandard::getList() JROOT/modules/mod_latestnewsenhanced/mod_latestnewsenhanced.php:39 10 include JROOT/modules/mod_latestnewsenhanced/mod_latestnewsenhanced.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1044 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:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo da consulta: 0.36 ms Após a última consulta: 0.22 ms Consulta a Memória: 0.007 MB de memória antes da consulta: 12.040 MB Linhas devolvidas: 0Consultas duplicadas: #18
SELECT `m`.`tag_id`,`t`.*
FROM `site2_contentitem_tag_map` AS m
INNER JOIN `site2_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 276
AND `t`.`published` = 1
AND t.access IN (1,1,5)id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m ALL idx_tag_type Nehnuma INDEX KEY pode ser utilizada NULL NULL 1 100.00 Using where 1 SIMPLE t eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 aevapt_site2.m.tag_id 1 100.00 Using where Status Duration Starting 0.06 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.03 ms Preparing 0.02 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 closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.07 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:1695 13 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Helper/TagsHelper.php:454 12 Joomla\CMS\Helper\TagsHelper->getItemTags() JROOT/modules/mod_latestnewsenhanced/helpers/helper_standard.php:966 11 modLatestNewsEnhancedExtendedHelperStandard::getList() JROOT/modules/mod_latestnewsenhanced/mod_latestnewsenhanced.php:39 10 include JROOT/modules/mod_latestnewsenhanced/mod_latestnewsenhanced.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1044 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:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo da consulta: 0.41 ms Após a última consulta: 0.14 ms Consulta a Memória: 0.007 MB de memória antes da consulta: 12.048 MB Linhas devolvidas: 0Consultas duplicadas: #19
SELECT `m`.`tag_id`,`t`.*
FROM `site2_contentitem_tag_map` AS m
INNER JOIN `site2_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 275
AND `t`.`published` = 1
AND t.access IN (1,1,5)id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m ALL idx_tag_type Nehnuma INDEX KEY pode ser utilizada NULL NULL 1 100.00 Using where 1 SIMPLE t eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 aevapt_site2.m.tag_id 1 100.00 Using where Status Duration Starting 0.06 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.03 ms Optimizing 0.02 ms Statistics 0.04 ms Preparing 0.02 ms 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 closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.06 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:1695 13 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Helper/TagsHelper.php:454 12 Joomla\CMS\Helper\TagsHelper->getItemTags() JROOT/modules/mod_latestnewsenhanced/helpers/helper_standard.php:966 11 modLatestNewsEnhancedExtendedHelperStandard::getList() JROOT/modules/mod_latestnewsenhanced/mod_latestnewsenhanced.php:39 10 include JROOT/modules/mod_latestnewsenhanced/mod_latestnewsenhanced.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1044 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:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo da consulta: 0.37 ms Após a última consulta: 0.17 ms Consulta a Memória: 0.007 MB de memória antes da consulta: 12.056 MB Linhas devolvidas: 0
SELECT `m`.`tag_id`,`t`.*
FROM `site2_contentitem_tag_map` AS m
INNER JOIN `site2_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 274
AND `t`.`published` = 1
AND t.access IN (1,1,5)id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m ALL idx_tag_type Nehnuma INDEX KEY pode ser utilizada NULL NULL 1 100.00 Using where 1 SIMPLE t eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 aevapt_site2.m.tag_id 1 100.00 Using where Status Duration Starting 0.06 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.03 ms Preparing 0.02 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 closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.06 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:1695 13 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Helper/TagsHelper.php:454 12 Joomla\CMS\Helper\TagsHelper->getItemTags() JROOT/modules/mod_latestnewsenhanced/helpers/helper_standard.php:966 11 modLatestNewsEnhancedExtendedHelperStandard::getList() JROOT/modules/mod_latestnewsenhanced/mod_latestnewsenhanced.php:39 10 include JROOT/modules/mod_latestnewsenhanced/mod_latestnewsenhanced.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1044 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:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo da consulta: 5.27 ms Após a última consulta: 12.25 ms Consulta a Memória: 0.006 MB de memória antes da consulta: 12.146 MB Linhas devolvidas: 4
SELECT DISTINCT a.id, a.title, a.alias, a.introtext, a.fulltext,
CASE WHEN a.fulltext IS NULL OR a.fulltext = '' THEN 0 ELSE 1 END AS fulltexthascontent, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, 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.featured, a.language,
CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,
CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END AS slug,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END AS cat_slug,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
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,ROUND(v.rating_sum / v.rating_count, 1) AS rating, v.rating_count as rating_count,c.published,
CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published,`a`.`publish_up` AS `date`
FROM site2_content AS a
LEFT JOIN site2_categories AS c
ON c.id = a.catid
LEFT JOIN site2_users AS ua
ON ua.id = a.created_by
LEFT JOIN site2_users AS uam
ON uam.id = a.modified_by
LEFT JOIN site2_categories as parent
ON parent.id = c.parent_id
LEFT JOIN site2_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM site2_categories AS cat JOIN site2_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id ) AS badcats
ON badcats.id = c.id
WHERE
CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1
AND a.access IN (1,1,5)
AND c.access IN (1,1,5)
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-04-20 04:24:15')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-20 04:24:15')
AND a.catid IN (26)
AND a.language IN ('pt-PT','*')
ORDER BY a.publish_up DESC
LIMIT 4id select_type table type possible_keys key key_len ref rows filtered Extra 1 PRIMARY c const PRIMARY,idx_access PRIMARY 4 const 1 100.00 Using temporary; Filesort em utilização 1 PRIMARY a ref idx_access,idx_catid,idx_language idx_catid 4 const 70 100.00 Using where 1 PRIMARY ua eq_ref PRIMARY PRIMARY 4 aevapt_site2.a.created_by 1 100.00 Using where 1 PRIMARY uam eq_ref PRIMARY PRIMARY 4 aevapt_site2.a.modified_by 1 100.00 Using where 1 PRIMARY parent eq_ref PRIMARY PRIMARY 4 const 1 100.00 Using where 1 PRIMARY v eq_ref PRIMARY PRIMARY 4 aevapt_site2.a.id 1 100.00 Using where 1 PRIMARY <derived2> ref key0 key0 5 const 0 0.00 Using where 2 LATERAL DERIVED cat const PRIMARY,idx_left_right PRIMARY 4 const 1 100.00 2 LATERAL DERIVED parent ALL cat_idx,idx_left_right Nehnuma INDEX KEY pode ser utilizada NULL NULL 27 62.96 Using where; Using join buffer (flat, BNL join) Status Duration Sending data 0.07 ms Executing 0.01 ms Sending data 0.03 ms Executing 0.01 ms Sending data 0.02 ms Executing 0.01 ms Sending data 0.02 ms Executing 0.01 ms Sending data 0.05 ms Executing 0.01 ms Sending data 0.02 ms Executing 0.01 ms Sending data 0.04 ms Executing 0.01 ms Sending data 0.02 ms Executing 0.01 ms Sending data 0.07 ms Executing 0.01 ms Sending data 0.07 ms Executing 0.01 ms Sending data 0.04 ms Executing 0.01 ms Sending data 0.07 ms Executing 0.01 ms Sending data 0.10 ms Executing 0.01 ms Sending data 0.06 ms Executing 0.01 ms Sending data 0.05 ms Executing 0.01 ms Sending data 0.04 ms Executing 0.01 ms Sending data 0.05 ms Executing 0.01 ms Sending data 0.04 ms Executing 0.01 ms Sending data 0.04 ms Executing 0.01 ms Sending data 0.04 ms Executing 0.01 ms Sending data 0.04 ms Executing 0.01 ms Sending data 0.05 ms Executing 0.01 ms Sending data 0.04 ms Executing 0.01 ms Sending data 0.04 ms Executing 0.01 ms Sending data 0.05 ms Executing 0.01 ms Sending data 0.03 ms Executing 0.01 ms Sending data 0.04 ms Executing 0.01 ms Sending data 0.05 ms Executing 0.01 ms Sending data 0.05 ms Executing 0.01 ms Sending data 0.05 ms Executing 0.01 ms Sending data 0.04 ms Executing 0.01 ms Sending data 0.05 ms Executing 0.01 ms Sending data 0.05 ms Executing 0.01 ms Sending data 0.04 ms Executing 0.01 ms Sending data 0.04 ms Executing 0.01 ms Sending data 0.06 ms Executing 0.01 ms Sending data 0.04 ms Executing 0.01 ms Sending data 0.05 ms Executing 0.01 ms Sending data 0.05 ms Executing 0.01 ms Sending data 0.04 ms Executing 0.01 ms Sending data 0.04 ms Executing 0.01 ms Sending data 0.05 ms Executing 0.01 ms Sending data 0.05 ms Creating sort index 0.11 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 closing tables 0.01 ms Removing tmp table 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.06 ms Starting cleanup 0.01 ms Freeing items 0.06 ms Updating status 0.01 ms Reset for next command 0.01 ms # Chamador Ficheiro e número da linha 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 12 JDatabaseDriver->loadObjectList() JROOT/modules/mod_latestnewsenhanced/helpers/helper_standard.php:739 11 modLatestNewsEnhancedExtendedHelperStandard::getList() JROOT/modules/mod_latestnewsenhanced/mod_latestnewsenhanced.php:39 10 include JROOT/modules/mod_latestnewsenhanced/mod_latestnewsenhanced.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1044 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:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo da consulta: 0.48 ms Após a última consulta: 0.32 ms Consulta a Memória: 0.007 MB de memória antes da consulta: 12.190 MB Linhas devolvidas: 0
SELECT `m`.`tag_id`,`t`.*
FROM `site2_contentitem_tag_map` AS m
INNER JOIN `site2_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 263
AND `t`.`published` = 1
AND t.access IN (1,1,5)id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m ALL idx_tag_type Nehnuma INDEX KEY pode ser utilizada NULL NULL 1 100.00 Using where 1 SIMPLE t eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 aevapt_site2.m.tag_id 1 100.00 Using where Status Duration Starting 0.08 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 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 closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.06 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:1695 13 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Helper/TagsHelper.php:454 12 Joomla\CMS\Helper\TagsHelper->getItemTags() JROOT/modules/mod_latestnewsenhanced/helpers/helper_standard.php:966 11 modLatestNewsEnhancedExtendedHelperStandard::getList() JROOT/modules/mod_latestnewsenhanced/mod_latestnewsenhanced.php:39 10 include JROOT/modules/mod_latestnewsenhanced/mod_latestnewsenhanced.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1044 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:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo da consulta: 0.40 ms Após a última consulta: 0.17 ms Consulta a Memória: 0.007 MB de memória antes da consulta: 12.198 MB Linhas devolvidas: 0
SELECT `m`.`tag_id`,`t`.*
FROM `site2_contentitem_tag_map` AS m
INNER JOIN `site2_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 262
AND `t`.`published` = 1
AND t.access IN (1,1,5)id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m ALL idx_tag_type Nehnuma INDEX KEY pode ser utilizada NULL NULL 1 100.00 Using where 1 SIMPLE t eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 aevapt_site2.m.tag_id 1 100.00 Using where Status Duration Starting 0.05 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.02 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 closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.06 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:1695 13 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Helper/TagsHelper.php:454 12 Joomla\CMS\Helper\TagsHelper->getItemTags() JROOT/modules/mod_latestnewsenhanced/helpers/helper_standard.php:966 11 modLatestNewsEnhancedExtendedHelperStandard::getList() JROOT/modules/mod_latestnewsenhanced/mod_latestnewsenhanced.php:39 10 include JROOT/modules/mod_latestnewsenhanced/mod_latestnewsenhanced.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1044 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:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo da consulta: 0.39 ms Após a última consulta: 0.13 ms Consulta a Memória: 0.008 MB de memória antes da consulta: 12.213 MB Linhas devolvidas: 0
SELECT `m`.`tag_id`,`t`.*
FROM `site2_contentitem_tag_map` AS m
INNER JOIN `site2_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 237
AND `t`.`published` = 1
AND t.access IN (1,1,5)id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m ALL idx_tag_type Nehnuma INDEX KEY pode ser utilizada NULL NULL 1 100.00 Using where 1 SIMPLE t eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 aevapt_site2.m.tag_id 1 100.00 Using where Status Duration Starting 0.06 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.03 ms Preparing 0.02 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 closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.06 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:1695 13 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Helper/TagsHelper.php:454 12 Joomla\CMS\Helper\TagsHelper->getItemTags() JROOT/modules/mod_latestnewsenhanced/helpers/helper_standard.php:966 11 modLatestNewsEnhancedExtendedHelperStandard::getList() JROOT/modules/mod_latestnewsenhanced/mod_latestnewsenhanced.php:39 10 include JROOT/modules/mod_latestnewsenhanced/mod_latestnewsenhanced.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1044 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:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo da consulta: 0.40 ms Após a última consulta: 0.17 ms Consulta a Memória: 0.007 MB de memória antes da consulta: 12.222 MB Linhas devolvidas: 0
SELECT `m`.`tag_id`,`t`.*
FROM `site2_contentitem_tag_map` AS m
INNER JOIN `site2_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 226
AND `t`.`published` = 1
AND t.access IN (1,1,5)id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m ALL idx_tag_type Nehnuma INDEX KEY pode ser utilizada NULL NULL 1 100.00 Using where 1 SIMPLE t eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 aevapt_site2.m.tag_id 1 100.00 Using where Status Duration Starting 0.06 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.03 ms Preparing 0.02 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 closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.06 ms Updating status 0.01 ms Reset for next command 0.02 ms # Chamador Ficheiro e número da linha 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 13 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Helper/TagsHelper.php:454 12 Joomla\CMS\Helper\TagsHelper->getItemTags() JROOT/modules/mod_latestnewsenhanced/helpers/helper_standard.php:966 11 modLatestNewsEnhancedExtendedHelperStandard::getList() JROOT/modules/mod_latestnewsenhanced/mod_latestnewsenhanced.php:39 10 include JROOT/modules/mod_latestnewsenhanced/mod_latestnewsenhanced.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1044 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:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo da consulta: 0.53 ms Após a última consulta: 15.79 ms Consulta a Memória: 0.006 MB de memória antes da consulta: 13.038 MB Linhas devolvidas: 1
SELECT *
FROM site2_menu
WHERE id='101'id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE site2_menu const PRIMARY PRIMARY 4 const 1 100.00 Status Duration Starting 0.11 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.03 ms Optimizing 0.01 ms Statistics 0.04 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.01 ms Executing 0.01 ms Sending data 0.02 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.03 ms Starting cleanup 0.01 ms Freeing items 0.05 ms Updating status 0.01 ms Reset for next command 0.01 ms # Chamador Ficheiro e número da linha 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1656 12 JDatabaseDriver->loadObject() JROOT/modules/mod_sclogin/helper.php:286 11 modSCLoginHelper->getLoginRedirect() JROOT/modules/mod_sclogin/mod_sclogin.php:25 10 include JROOT/modules/mod_sclogin/mod_sclogin.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1044 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:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
21 tipos de pedidos registados, ordenados por ocorrências.
ESCOLHER tabelas:
12 × SELECT `m`.`tag_id`,`t`.*
FROM `site2_contentitem_tag_map` AS m
INNER JOIN `site2_tags` AS t
ON `m`.`tag_id` = `t`.`id`2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `site2_extensions`2 × SELECT DISTINCT a.id, a.title, a.alias, a.introtext, a.fulltext,
CASE WHEN a.fulltext IS NULL OR a.fulltext = '' THEN 0 ELSE 1 END AS fulltexthascontent, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, 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.featured, a.language,
CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,
CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END AS slug,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END AS cat_slug,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
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,ROUND(v.rating_sum / v.rating_count, 1) AS rating, v.rating_count as rating_count,c.published,
CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published,`a`.`publish_up` AS `date`
FROM site2_content AS a
LEFT JOIN site2_categories AS c
ON c.id = a.catid
LEFT JOIN site2_users AS ua
ON ua.id = a.created_by
LEFT JOIN site2_users AS uam
ON uam.id = a.modified_by
LEFT JOIN site2_categories as parent
ON parent.id = c.parent_id
LEFT JOIN site2_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM site2_categories AS cat JOIN site2_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt2 × 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 site2_fields AS a
LEFT JOIN `site2_languages` AS l
ON l.lang_code = a.language
LEFT JOIN site2_users AS uc
ON uc.id=a.checked_out
LEFT JOIN site2_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN site2_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN site2_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `site2_fields_categories` AS fc
ON fc.field_id = a.id1 × SELECT `data`
FROM `site2_session`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 site2_content AS a
LEFT JOIN site2_categories AS c
ON c.id = a.catid
LEFT JOIN site2_users AS ua
ON ua.id = a.created_by
LEFT JOIN site2_users AS uam
ON uam.id = a.modified_by
LEFT JOIN site2_categories as parent
ON parent.id = c.parent_id
LEFT JOIN site2_content_rating AS v
ON a.id = v.content_id1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM site2_modules AS m
LEFT JOIN site2_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN site2_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id1 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM `site2_categories` AS `s`
INNER JOIN `site2_categories` AS `c`
ON (s.lft < c.lft
AND c.lft < s.rgt
AND c.language IN ('pt-PT','*')) OR (c.lft <= s.lft
AND s.rgt <= c.rgt)1 × SELECT COUNT(*)
FROM site2_content AS a
LEFT JOIN site2_categories AS c
ON c.id = a.catid
LEFT JOIN site2_users AS ua
ON ua.id = a.created_by
LEFT JOIN site2_users AS uam
ON uam.id = a.modified_by
LEFT JOIN site2_categories as parent
ON parent.id = c.parent_id
LEFT JOIN site2_content_rating AS v
ON a.id = v.content_id1 × SELECT id, home, template, s.params
FROM site2_template_styles as s
LEFT JOIN site2_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id1 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `site2_assets`1 × SELECT `session_id`
FROM `site2_session`1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM site2_menu AS m
LEFT JOIN site2_extensions AS e
ON m.component_id = e.extension_id1 × SELECT `element`,`name`,`client_id`,`extension_id`
FROM `site2_extensions`1 × SELECT *
FROM site2_languages1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM site2_extensions1 × SELECT b.id
FROM site2_usergroups AS a
LEFT JOIN site2_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt1 × SELECT id, rules
FROM `site2_viewlevels1 × SELECT *
FROM site2_menu
OUTRAS tabelas:
1 × INSERT INTO `site2_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES ('197fec5b75cc9c0363cb45a4d3e2e049', 1, 1713587055, 0, '', 01 × UPDATE `site2_extensions`
SET `params` = '{\"mediaversion\":\"e516f7eaaf3fc8d7557b0022696869da\"}'