|
|
|
|
|
|
|
|
||
| Por ano | Por mês | Pesquisar | Ir para o mês | ||||||
|
|
|||||||||
- Competições
- Formação
- Informações
- Material
- a ATMP
- Contactos
-
Competições
- Calendários
- Campeonatos Distritais
- Campeonatos Nacionais
- Torneios Abertos
- Challenge
- Provas Internacionais
- Formação
- Informações
- Material
- a ATMP
- Está em...
-
Início
- Material
© 2026, Associação de Ténis de Mesa do Porto (Instituição de Utilidade Pública).
Dinamizado por Evolua.pt
Rua António Pinto Machado, 60, 2º 4100-068 Porto +351 226 090 762 +351 931 766 352 secretaria@atmporto.com
Warning: unlink(/home/atmporto/public_html/templates/astroid_template_zero/css/astroid-2f9e6fdc6eac0f0cfbd38eecf3209479.css): No such file or directory in /home/atmporto/public_html/libraries/astroid/framework/template.php on line 681
Consola de depuração Joomla
{ "__default": { "session": { "counter": 11, "timer": { "start": 1784880916, "last": 1784880971, "now": 1784880976 }, "token": "KJrdDxjwmDZ0KuraYsx5ADUkHGInAYjt" }, "registry": { "published_fv_ses": "0", "justmine_fv_ses": "0" }, "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 }, "com_mailto": { "links": { "3b1101f53af6d9557d4ca9002e677b3ff99d7d5c": { "link": "https://www.atmporto.com/index.php/material/calendariosemanal/2027/1/25/163", "expiry": 1784880917 }, "b4083a579af0d3dcbfca643cf70d7f5f5c4cdac2": { "link": "https://www.atmporto.com/index.php/material/eventospordia/2029/11/19/180", "expiry": 1784880921 }, "ccc56a34f8946f87f40de918c2ebbaf7d0d7c92d": { "link": "https://www.atmporto.com/index.php/material/eventospordia/2028/12/26/157", "expiry": 1784880926 }, "fc9b5b612a70e4b0e66162b41330e02092065f12": { "link": "https://www.atmporto.com/index.php/material/eventospordia/2031/5/16/164", "expiry": 1784880931 }, "f19fc778ea616f45580e6ae9d0998ab8fbf813a5": { "link": "https://www.atmporto.com/index.php/material/eventospordia/2030/12/11/186", "expiry": 1784880941 }, "2ce3382af81d506779969cbab65bcf7b3630ddc6": { "link": "https://www.atmporto.com/index.php/material/eventospordia/2025/1/30/184", "expiry": 1784880946 }, "9a7d270213cb6d641d379b6e72d5dc6e165b9c37": { "link": "https://www.atmporto.com/index.php/material/eventospordia/2030/11/5/184", "expiry": 1784880951 }, "e3b00cc0f2dbd617dac20a77f6f8ce1713ce42de": { "link": "https://www.atmporto.com/index.php/material/eventospordia/2030/11/9/184", "expiry": 1784880956 }, "7a9310f633c3d735f78ec86c5ae3368f5d2d105c": { "link": "https://www.atmporto.com/index.php/material/eventospordia/2025/7/26/180", "expiry": 1784880962 }, "84b9b2936fec1295bf2dfb2918d7c13362213eba": { "link": "https://www.atmporto.com/index.php/material/eventospordia/2031/3/17/177", "expiry": 1784880971 }, "e3747d99f5ebbaa1b15295310d26724b02f138fd": { "link": "https://www.atmporto.com/index.php/material/eventospordia/2029/1/26/186", "expiry": 1784880976 } } } } }Hora
Memória
Hora: 24.07 ms / 24.07 ms Memória: 2.022 MB / 2.42 MB Application: afterLoadHora: 68.79 ms / 92.86 ms Memória: 4.423 MB / 6.84 MB Application: afterInitialiseHora: 23.05 ms / 115.91 ms Memória: 1.607 MB / 8.45 MB Application: afterRouteHora: 5.41 ms / 121.32 ms Memória: 0.232 MB / 8.68 MB Application: beforeRenderComponent com_jeventsHora: 41.75 ms / 163.07 ms Memória: 2.500 MB / 11.18 MB Application: Before Access::preloadComponents (all components)Hora: 1.33 ms / 164.41 ms Memória: 0.067 MB / 11.25 MB Application: After Access::preloadComponents (all components)Hora: 0.06 ms / 164.46 ms Memória: -0.005 MB / 11.24 MB Application: Before Access::getAssetRules (id:1278 name:com_jevents)Hora: 0.67 ms / 165.13 ms Memória: 0.027 MB / 11.27 MB Application: After Access::getAssetRules (id:1278 name:com_jevents)Hora: 66.65 ms / 231.78 ms Memória: 3.700 MB / 14.97 MB Application: afterRenderComponent com_jeventsHora: 0.49 ms / 232.28 ms Memória: 0.006 MB / 14.98 MB Application: afterDispatchHora: 614.92 ms / 847.20 ms Memória: 2.114 MB / 17.09 MB Application: beforeRenderModule mod_custom (Parceiros)Hora: 1.67 ms / 848.87 ms Memória: 0.042 MB / 17.13 MB Application: afterRenderModule mod_custom (Parceiros)Hora: 0.10 ms / 848.96 ms Memória: -0.002 MB / 17.13 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)Hora: 2.13 ms / 851.09 ms Memória: 0.045 MB / 17.18 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)Hora: 0.09 ms / 851.18 ms Memória: -0.003 MB / 17.17 MB Application: beforeRenderModule mod_search (Pesquisa)Hora: 1.64 ms / 852.82 ms Memória: 0.082 MB / 17.25 MB Application: afterRenderModule mod_search (Pesquisa)Hora: 0.07 ms / 852.89 ms Memória: -0.005 MB / 17.25 MB Application: beforeRenderModule mod_custom (Nome Associação)Hora: 0.29 ms / 853.18 ms Memória: 0.004 MB / 17.25 MB Application: afterRenderModule mod_custom (Nome Associação)Hora: 3.80 ms / 856.99 ms Memória: 0.344 MB / 17.60 MB Application: afterRenderTotal de consultas à base de dados: 16.41 ms18,17 MB (19 051 872 Bytes)21 pedidos registados 16.41 ms
- Tempo da consulta: 0.59 ms Consulta a Memória: 0.007 MB de memória antes da consulta: 4.153 MB Linhas devolvidas: 1
SELECT `data`
FROM `j25_session`
WHERE `session_id` = X'3035663434633638386265393136613931623564363264326433643162363235'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE j25_session const PRIMARY PRIMARY 194 const 1 Status Duration Starting 0.09 ms checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.06 ms Optimizing 0.02 ms Statistics 0.06 ms Preparing 0.00 ms Unlocking tables 0.01 ms Preparing 0.02 ms Executing 0.00 ms Sending data 0.02 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.00 ms # Chamador Ficheiro e número da linha 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 15 JDatabaseDriver->loadResult() JROOT/libraries/joomla/session/storage/database.php:45 14 JSessionStorageDatabase->read() Igual à chamada na linha abaixo. 13 session_start() JROOT/libraries/joomla/session/handler/native.php:260 12 JSessionHandlerNative->doSessionStart() JROOT/libraries/joomla/session/handler/native.php:50 11 JSessionHandlerNative->start() JROOT/libraries/joomla/session/handler/joomla.php:88 10 JSessionHandlerJoomla->start() JROOT/libraries/src/Session/Session.php:661 9 Joomla\CMS\Session\Session->_start() JROOT/libraries/src/Session/Session.php:621 8 Joomla\CMS\Session\Session->start() JROOT/libraries/src/Session/Session.php:499 7 Joomla\CMS\Session\Session->get() JROOT/libraries/src/Session/Session.php:456 6 Joomla\CMS\Session\Session->isNew() JROOT/libraries/src/Application/CMSApplication.php:826 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:136 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:386 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Tempo da consulta: 0.74 ms Após a última consulta: 4.60 ms Consulta a Memória: 0.006 MB de memória antes da consulta: 4.436 MB Linhas devolvidas: 41
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `j25_extensions`
WHERE `type` = 'component'
AND `state` = 0
AND `enabled` = 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE j25_extensions ref extension extension 82 const 41 Using index condition; Using where 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.05 ms Optimizing 0.03 ms Statistics 0.09 ms Preparing 0.04 ms Executing 0.01 ms Sending data 0.20 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Chamador Ficheiro e número da linha 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Component/ComponentHelper.php:445 10 Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}() Igual à chamada na linha abaixo. 9 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 8 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Component/ComponentHelper.php:453 7 Joomla\CMS\Component\ComponentHelper::load() JROOT/libraries/src/Component/ComponentHelper.php:519 6 Joomla\CMS\Component\ComponentHelper::getComponents() JROOT/libraries/src/Component/ComponentHelper.php:44 5 Joomla\CMS\Component\ComponentHelper::getComponent() JROOT/libraries/src/Component/ComponentHelper.php:103 4 Joomla\CMS\Component\ComponentHelper::getParams() JROOT/libraries/src/Application/SiteApplication.php:594 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo da consulta: 0.47 ms Após a última consulta: 4.15 ms Consulta a Memória: 0.005 MB de memória antes da consulta: 4.707 MB Linhas devolvidas: 3
SELECT id, rules
FROM `j25_viewlevels`id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE j25_viewlevels ALL NULL Nenhuma chave INDEX KEY pode ser utilizada NULL NULL 3 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.02 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.02 ms Executing 0.00 ms Sending data 0.05 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.01 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.00 ms # Chamador Ficheiro e número da linha 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506 9 JDatabaseDriver->loadAssocList() JROOT/libraries/src/Access/Access.php:1063 8 Joomla\CMS\Access\Access::getAuthorisedViewLevels() JROOT/libraries/src/User/User.php:458 7 Joomla\CMS\User\User->getAuthorisedViewLevels() JROOT/libraries/src/Plugin/PluginHelper.php:318 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo da consulta: 0.77 ms Após a última consulta: 0.16 ms Consulta a Memória: 0.005 MB de memória antes da consulta: 4.718 MB Linhas devolvidas: 1
SELECT b.id
FROM j25_usergroups AS a
LEFT JOIN j25_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a const PRIMARY PRIMARY 4 const 1 1 SIMPLE b range idx_usergroup_nested_set_lookup idx_usergroup_nested_set_lookup 4 NULL 1 Using where; Using index Status Duration Starting 0.15 ms checking permissions 0.02 ms Opening tables 0.06 ms After opening tables 0.05 ms System lock 0.02 ms table lock 0.02 ms init 0.04 ms Optimizing 0.03 ms Statistics 0.10 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.03 ms Executing 0.01 ms Sending data 0.03 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.01 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Chamador Ficheiro e número da linha 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 10 JDatabaseDriver->loadColumn() JROOT/libraries/src/Access/Access.php:980 9 Joomla\CMS\Access\Access::getGroupsByUser() JROOT/libraries/src/Access/Access.php:1095 8 Joomla\CMS\Access\Access::getAuthorisedViewLevels() JROOT/libraries/src/User/User.php:458 7 Joomla\CMS\User\User->getAuthorisedViewLevels() JROOT/libraries/src/Plugin/PluginHelper.php:318 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo da consulta: 0.96 ms Após a última consulta: 1.20 ms Consulta a Memória: 0.005 MB de memória antes da consulta: 4.787 MB Linhas devolvidas: 95
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM j25_extensions
WHERE enabled = 1
AND type = 'plugin'
AND state IN (0,1)
AND access IN (1,1)
ORDER BY orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE j25_extensions ALL extension Nenhuma chave INDEX KEY pode ser utilizada NULL NULL 262 Using where; Modo Filesort em uso Status Duration Starting 0.12 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.00 ms table lock 0.01 ms init 0.05 ms Optimizing 0.04 ms Statistics 0.10 ms Preparing 0.02 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.01 ms Creating sort index 0.36 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.03 ms Reset for next command 0.00 ms # Chamador Ficheiro e número da linha 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 10 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Plugin/PluginHelper.php:351 9 Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}() Igual à chamada na linha abaixo. 8 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 7 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Plugin/PluginHelper.php:356 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo da consulta: 1.81 ms Após a última consulta: 33.68 ms Consulta a Memória: 0.009 MB de memória antes da consulta: 7.028 MB Linhas devolvidas: 107
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 j25_menu AS m
LEFT JOIN j25_extensions AS e
ON m.component_id = e.extension_id
WHERE m.published = 1
AND m.parent_id > 0
AND m.client_id = 0
ORDER BY m.lftid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ref idx_client_id_parent_id_alias_language idx_client_id_parent_id_alias_language 1 const 205 Using index condition; Using where; Modo Filesort em uso 1 SIMPLE e eq_ref PRIMARY PRIMARY 4 atmporto_jo151.m.component_id 1 Using where Status Duration Starting 0.12 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.03 ms Statistics 0.08 ms Preparing 0.03 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.02 ms Creating sort index 1.17 ms End of update loop 0.02 ms Query end 0.00 ms Commit 0.01 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.07 ms Query end 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Chamador Ficheiro e número da linha 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 18 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Menu/SiteMenu.php:93 17 Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}() Igual à chamada na linha abaixo. 16 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 15 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Menu/SiteMenu.php:101 14 Joomla\CMS\Menu\SiteMenu->load() JROOT/libraries/src/Menu/AbstractMenu.php:78 13 Joomla\CMS\Menu\AbstractMenu->__construct() JROOT/libraries/src/Menu/SiteMenu.php:62 12 Joomla\CMS\Menu\SiteMenu->__construct() JROOT/libraries/src/Menu/AbstractMenu.php:142 11 Joomla\CMS\Menu\AbstractMenu::getInstance() JROOT/libraries/src/Application/CMSApplication.php:417 10 Joomla\CMS\Application\CMSApplication->getMenu() JROOT/libraries/src/Application/SiteApplication.php:275 9 Joomla\CMS\Application\SiteApplication->getMenu() JROOT/libraries/src/Router/SiteRouter.php:65 8 Joomla\CMS\Router\SiteRouter->__construct() JROOT/libraries/src/Router/Router.php:189 7 Joomla\CMS\Router\Router::getInstance() JROOT/libraries/src/Application/CMSApplication.php:533 6 Joomla\CMS\Application\CMSApplication::getRouter() JROOT/libraries/src/Application/SiteApplication.php:403 5 Joomla\CMS\Application\SiteApplication::getRouter() JROOT/libraries/src/Application/CMSApplication.php:1141 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo da consulta: 0.65 ms Após a última consulta: 17.08 ms Consulta a Memória: 0.006 MB de memória antes da consulta: 8.444 MB Linhas devolvidas: 18
SELECT id, home, template, s.params
FROM j25_template_styles as s
LEFT JOIN j25_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
WHERE s.client_id = 0
AND e.enabled = 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE s ALL idx_template,idx_client_id,idx_client_id_home Nenhuma chave INDEX KEY pode ser utilizada NULL NULL 21 Using where 1 SIMPLE e ref element_clientid,element_folder_clientid,extension element_clientid 403 atmporto_jo151.s.template,const 1 Using index condition; Using where Status Duration Starting 0.08 ms checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.03 ms Optimizing 0.03 ms Statistics 0.09 ms Preparing 0.03 ms Executing 0.00 ms Sending data 0.14 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Chamador Ficheiro e número da linha 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Application/SiteApplication.php:486 10 Joomla\CMS\Application\SiteApplication->getTemplate() JROOT/plugins/system/gantry5/gantry5.php:195 9 plgSystemGantry5->onAfterRouteSite() JROOT/plugins/system/gantry5/gantry5.php:57 8 plgSystemGantry5->onAfterRoute() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1190 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo da consulta: 0.41 ms Após a última consulta: 0.96 ms Consulta a Memória: 0.007 MB de memória antes da consulta: 8.484 MB Linhas devolvidas: 1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `j25_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE j25_extensions ref element_clientid,element_folder_clientid,extension extension 484 const,const 1 Using index condition Status Duration Starting 0.05 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.01 ms init 0.02 ms Optimizing 0.02 ms Statistics 0.08 ms Preparing 0.03 ms Executing 0.01 ms Sending data 0.04 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.00 ms # Chamador Ficheiro e número da linha 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 14 JDatabaseDriver->loadObject() JROOT/libraries/src/Helper/LibraryHelper.php:167 13 Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}() Igual à chamada na linha abaixo. 12 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 11 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/LibraryHelper.php:175 10 Joomla\CMS\Helper\LibraryHelper::loadLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:43 9 Joomla\CMS\Helper\LibraryHelper::getLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:90 8 Joomla\CMS\Helper\LibraryHelper::getParams() JROOT/libraries/src/Version.php:321 7 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 6 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 5 Joomla\CMS\Factory::getDocument() JROOT/libraries/src/Application/WebApplication.php:1137 4 Joomla\CMS\Application\WebApplication->loadDocument() JROOT/libraries/src/Application/SiteApplication.php:133 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo da consulta: 0.24 ms Após a última consulta: 0.20 ms Consulta a Memória: 0.005 MB de memória antes da consulta: 8.476 MB
UPDATE `j25_extensions`
SET `params` = '{\"mediaversion\":\"0094e9e6f0249877196a0e944f5d52c6\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'EXPLAIN não é possível na consulta: UPDATE `j25_extensions` SET `params` = '{\"mediaversion\":\"0094e9e6f0249877196a0e944f5d52c6\"}' WHERE `type` = 'library' AND `element` = 'joomla'Status Duration Starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.00 ms table lock 0.00 ms init for update 0.05 ms Updating 0.03 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.01 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.01 ms Reset for next command 0.00 ms # Chamador Ficheiro e número da linha 10 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Helper/LibraryHelper.php:117 9 Joomla\CMS\Helper\LibraryHelper::saveParams() JROOT/libraries/src/Version.php:372 8 Joomla\CMS\Version->setMediaVersion() JROOT/libraries/src/Version.php:331 7 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 6 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 5 Joomla\CMS\Factory::getDocument() JROOT/libraries/src/Application/WebApplication.php:1137 4 Joomla\CMS\Application\WebApplication->loadDocument() JROOT/libraries/src/Application/SiteApplication.php:133 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo da consulta: 0.46 ms Após a última consulta: 2.80 ms Consulta a Memória: 0.003 MB de memória antes da consulta: 8.668 MB Linhas devolvidas: 1
SELECT *
FROM j25_languages
WHERE published=1
ORDER BY ordering ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE j25_languages ALL NULL Nenhuma chave INDEX KEY pode ser utilizada NULL NULL 1 Using where; Modo Filesort em uso 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.00 ms table lock 0.01 ms init 0.03 ms Optimizing 0.02 ms Statistics 0.02 ms Preparing 0.02 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.01 ms Creating sort index 0.06 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.00 ms # Chamador Ficheiro e número da linha 7 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 6 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Language/LanguageHelper.php:150 5 Joomla\CMS\Language\LanguageHelper::getLanguages() JROOT/libraries/src/Application/SiteApplication.php:330 4 Joomla\CMS\Application\SiteApplication->getParams() JROOT/libraries/src/Application/SiteApplication.php:138 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo da consulta: 0.96 ms Após a última consulta: 42.74 ms Consulta a Memória: 0.010 MB de memória antes da consulta: 11.186 MB Linhas devolvidas: 40
SELECT `id`,`name`,`rules`,`parent_id`
FROM `j25_assets`
WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_akeeba','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_gantry5','com_installer','com_jce','com_jevents','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_phocadownload','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_simplifiedsocialshare','com_tags','com_templates','com_users','com_weblinks','com_wrapper')id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE j25_assets range idx_asset_name idx_asset_name 202 NULL 42 Using index condition Status Duration Starting 0.12 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.09 ms Optimizing 0.06 ms Statistics 0.14 ms Preparing 0.03 ms Executing 0.00 ms Sending data 0.26 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.00 ms closing tables 0.01 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Chamador Ficheiro e número da linha 23 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 22 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Access/Access.php:429 21 Joomla\CMS\Access\Access::preloadComponents() JROOT/libraries/src/Access/Access.php:213 20 Joomla\CMS\Access\Access::preload() JROOT/libraries/src/Access/Access.php:531 19 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 18 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 17 Joomla\CMS\User\User->authorise() JROOT/components/com_jevents/libraries/helper.php:1428 16 JEVHelper::isAdminUser() JROOT/components/com_jevents/libraries/helper.php:1386 15 JEVHelper::getAid() JROOT/components/com_jevents/libraries/datamodel.php:50 14 JEventsDataModel->__construct() JROOT/components/com_jevents/views/default/abstract/abstract.php:65 13 JEventsDefaultView->__construct() JROOT/components/com_jevents/views/geraint/abstract/abstract.php:32 12 JEventsGeraintView->__construct() JROOT/libraries/src/MVC/Factory/LegacyFactory.php:89 11 Joomla\CMS\MVC\Factory\LegacyFactory->createView() JROOT/libraries/src/MVC/Controller/BaseController.php:590 10 Joomla\CMS\MVC\Controller\BaseController->createView() JROOT/libraries/src/MVC/Controller/BaseController.php:833 9 Joomla\CMS\MVC\Controller\BaseController->getView() JROOT/components/com_jevents/controllers/day.php:71 8 DayController->listevents() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jevents/jevents.php:365 6 require_once JROOT/components/com_jevents/jevents.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo da consulta: 1.07 ms Após a última consulta: 16.71 ms Consulta a Memória: 0.012 MB de memória antes da consulta: 12.078 MB Linhas devolvidas: 31
SHOW FULL COLUMNS
FROM `j25_content`EXPLAIN não é possível na consulta: SHOW FULL COLUMNS FROM `j25_content`Status Duration Starting 0.05 ms checking permissions 0.01 ms closing tables 0.00 ms checking permissions 0.00 ms Opening tables 0.31 ms After opening tables 0.01 ms System lock 0.00 ms table lock 0.01 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Executing 0.00 ms Filling schema table 0.01 ms Opening tables 0.03 ms After opening tables 0.00 ms checking permissions 0.10 ms closing tables 0.01 ms checking permissions 0.01 ms Executing 0.00 ms Sending data 0.15 ms End of update loop 0.02 ms Query end 0.01 ms closing tables 0.00 ms Removing tmp table 0.14 ms closing tables 0.01 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Chamador Ficheiro e número da linha 26 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 25 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:448 24 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:261 23 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:180 22 Joomla\CMS\Table\Table->__construct() JROOT/libraries/src/Table/Content.php:39 21 Joomla\CMS\Table\Content->__construct() JROOT/libraries/src/Table/Table.php:328 20 Joomla\CMS\Table\Table::getInstance() JROOT/components/com_jevents/views/default/helpers/defaultloadmodules.php:15 19 DefaultLoadModules() JROOT/components/com_jevents/views/default/abstract/abstract.php:187 18 JEventsDefaultView->__call() JROOT/components/com_jevents/views/default/helpers/defaultviewhelperheader16.php:19 17 DefaultViewHelperHeader16() JROOT/components/com_jevents/views/default/abstract/abstract.php:187 16 JEventsDefaultView->__call() JROOT/components/com_jevents/views/default/helpers/defaultviewhelperheader.php:7 15 DefaultViewHelperHeader() JROOT/components/com_jevents/views/default/abstract/abstract.php:187 14 JEventsDefaultView->__call() JROOT/components/com_jevents/views/default/day/tmpl/listevents.php:4 13 include JROOT/components/com_jevents/views/default/day/tmpl/listevents.php JROOT/components/com_jevents/views/geraint/day/tmpl/listevents.php:4 12 include JROOT/components/com_jevents/views/geraint/day/tmpl/listevents.php JROOT/libraries/src/MVC/View/HtmlView.php:701 11 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/libraries/src/MVC/View/HtmlView.php:230 10 Joomla\CMS\MVC\View\HtmlView->display() JROOT/administrator/components/com_jevents/views/abstract/abstract.php:133 9 JEventsAbstractView->display() JROOT/components/com_jevents/controllers/day.php:89 8 DayController->listevents() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jevents/jevents.php:365 6 require_once JROOT/components/com_jevents/jevents.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo da consulta: 0.37 ms Após a última consulta: 4.81 ms Consulta a Memória: 0.012 MB de memória antes da consulta: 12.454 MB Linhas devolvidas: 30
SELECT *
FROM j25_oss_share_settingsid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE j25_oss_share_settings ALL NULL Nenhuma chave INDEX KEY pode ser utilizada NULL NULL 30 Status Duration Starting 0.06 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.04 ms End of update loop 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.00 ms # Chamador Ficheiro e número da linha 25 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506 24 JDatabaseDriver->loadAssocList() JROOT/plugins/content/simplifiedsocialshare/simplifiedsocialshare.php:81 23 plgContentSimplifiedSocialShare->getSettings() JROOT/plugins/content/simplifiedsocialshare/simplifiedsocialshare.php:27 22 plgContentSimplifiedSocialShare->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:280 21 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 20 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/components/com_jevents/views/default/helpers/defaultloadmodules.php:21 19 DefaultLoadModules() JROOT/components/com_jevents/views/default/abstract/abstract.php:187 18 JEventsDefaultView->__call() JROOT/components/com_jevents/views/default/helpers/defaultviewhelperheader16.php:19 17 DefaultViewHelperHeader16() JROOT/components/com_jevents/views/default/abstract/abstract.php:187 16 JEventsDefaultView->__call() JROOT/components/com_jevents/views/default/helpers/defaultviewhelperheader.php:7 15 DefaultViewHelperHeader() JROOT/components/com_jevents/views/default/abstract/abstract.php:187 14 JEventsDefaultView->__call() JROOT/components/com_jevents/views/default/day/tmpl/listevents.php:4 13 include JROOT/components/com_jevents/views/default/day/tmpl/listevents.php JROOT/components/com_jevents/views/geraint/day/tmpl/listevents.php:4 12 include JROOT/components/com_jevents/views/geraint/day/tmpl/listevents.php JROOT/libraries/src/MVC/View/HtmlView.php:701 11 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/libraries/src/MVC/View/HtmlView.php:230 10 Joomla\CMS\MVC\View\HtmlView->display() JROOT/administrator/components/com_jevents/views/abstract/abstract.php:133 9 JEventsAbstractView->display() JROOT/components/com_jevents/controllers/day.php:89 8 DayController->listevents() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jevents/jevents.php:365 6 require_once JROOT/components/com_jevents/jevents.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo da consulta: 0.51 ms Após a última consulta: 3.31 ms Consulta a Memória: 0.014 MB de memória antes da consulta: 12.679 MB Linhas devolvidas: 1
SELECT `extension_id`,`name`,`enabled`,`params`
FROM j25_extensions
WHERE `type` = 'plugin'
AND `element` = 'osyoutube'
AND `folder` = 'content'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE j25_extensions ref element_clientid,element_folder_clientid,extension element_clientid 402 const 1 Using index condition; Using where Status Duration Starting 0.09 ms checking permissions 0.01 ms Opening tables 0.04 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.03 ms Optimizing 0.02 ms Statistics 0.09 ms Preparing 0.02 ms Executing 0.00 ms Sending data 0.04 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.01 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.00 ms # Chamador Ficheiro e número da linha 30 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 29 JDatabaseDriver->loadObject() JROOT/libraries/allediaframework/Framework/Joomla/Extension/Generic.php:152 28 Alledia\Framework\Joomla\Extension\Generic->getDataFromDatabase() JROOT/libraries/allediaframework/Framework/Joomla/Extension/Generic.php:122 27 Alledia\Framework\Joomla\Extension\Generic->__construct() JROOT/libraries/allediaframework/Framework/Joomla/Extension/Licensed.php:51 26 Alledia\Framework\Joomla\Extension\Licensed->__construct() JROOT/libraries/allediaframework/Framework/Factory.php:38 25 Alledia\Framework\Factory::getExtension() JROOT/libraries/allediaframework/Framework/Joomla/Extension/AbstractPlugin.php:73 24 Alledia\Framework\Joomla\Extension\AbstractPlugin->loadExtension() JROOT/libraries/allediaframework/Framework/Joomla/Extension/AbstractPlugin.php:44 23 Alledia\Framework\Joomla\Extension\AbstractPlugin->init() JROOT/plugins/content/osyoutube/library/BasePlugin.php:56 22 Alledia\OSYouTube\BasePlugin->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:280 21 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 20 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/components/com_jevents/views/default/helpers/defaultloadmodules.php:21 19 DefaultLoadModules() JROOT/components/com_jevents/views/default/abstract/abstract.php:187 18 JEventsDefaultView->__call() JROOT/components/com_jevents/views/default/helpers/defaultviewhelperheader16.php:19 17 DefaultViewHelperHeader16() JROOT/components/com_jevents/views/default/abstract/abstract.php:187 16 JEventsDefaultView->__call() JROOT/components/com_jevents/views/default/helpers/defaultviewhelperheader.php:7 15 DefaultViewHelperHeader() JROOT/components/com_jevents/views/default/abstract/abstract.php:187 14 JEventsDefaultView->__call() JROOT/components/com_jevents/views/default/day/tmpl/listevents.php:4 13 include JROOT/components/com_jevents/views/default/day/tmpl/listevents.php JROOT/components/com_jevents/views/geraint/day/tmpl/listevents.php:4 12 include JROOT/components/com_jevents/views/geraint/day/tmpl/listevents.php JROOT/libraries/src/MVC/View/HtmlView.php:701 11 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/libraries/src/MVC/View/HtmlView.php:230 10 Joomla\CMS\MVC\View\HtmlView->display() JROOT/administrator/components/com_jevents/views/abstract/abstract.php:133 9 JEventsAbstractView->display() JROOT/components/com_jevents/controllers/day.php:89 8 DayController->listevents() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jevents/jevents.php:365 6 require_once JROOT/components/com_jevents/jevents.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo da consulta: 1.35 ms Após a última consulta: 7.69 ms Consulta a Memória: 0.013 MB de memória antes da consulta: 13.245 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 j25_fields AS a
LEFT JOIN `j25_languages` AS l
ON l.lang_code = a.language
LEFT JOIN j25_users AS uc
ON uc.id=a.checked_out
LEFT JOIN j25_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN j25_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN j25_fields_groups AS g
ON g.id = a.group_id
WHERE a.context = 'com_content.article'
AND a.access IN (1,1)
AND (a.group_id = 0 OR g.access IN (1,1))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ref idx_state,idx_access,idx_context idx_state 1 const 1 Using where; Using temporary; Modo Filesort em uso 1 SIMPLE l eq_ref idx_langcode idx_langcode 28 atmporto_jo151.a.language 1 Using where 1 SIMPLE uc eq_ref PRIMARY PRIMARY 4 atmporto_jo151.a.checked_out 1 1 SIMPLE ag const PRIMARY PRIMARY 4 const 1 1 SIMPLE ua eq_ref PRIMARY PRIMARY 4 atmporto_jo151.a.created_user_id 1 Using where 1 SIMPLE g eq_ref PRIMARY PRIMARY 4 atmporto_jo151.a.group_id 1 Using where Status Duration Starting 0.16 ms checking permissions 0.02 ms Opening tables 0.10 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.07 ms Optimizing 0.04 ms Statistics 0.12 ms Preparing 0.05 ms Creating tmp table 0.06 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.30 ms Creating sort index 0.05 ms Removing tmp table 0.09 ms Creating sort index 0.02 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.00 ms closing tables 0.01 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.00 ms Freeing items 0.02 ms Updating status 0.02 ms Reset for next command 0.01 ms # Chamador Ficheiro e número da linha 29 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 28 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 27 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_fields/models/fields.php:333 26 FieldsModelFields->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:194 25 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 24 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:495 23 PlgSystemFields->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 22 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 21 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 20 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/components/com_jevents/views/default/helpers/defaultloadmodules.php:23 19 DefaultLoadModules() JROOT/components/com_jevents/views/default/abstract/abstract.php:187 18 JEventsDefaultView->__call() JROOT/components/com_jevents/views/default/helpers/defaultviewhelperheader16.php:19 17 DefaultViewHelperHeader16() JROOT/components/com_jevents/views/default/abstract/abstract.php:187 16 JEventsDefaultView->__call() JROOT/components/com_jevents/views/default/helpers/defaultviewhelperheader.php:7 15 DefaultViewHelperHeader() JROOT/components/com_jevents/views/default/abstract/abstract.php:187 14 JEventsDefaultView->__call() JROOT/components/com_jevents/views/default/day/tmpl/listevents.php:4 13 include JROOT/components/com_jevents/views/default/day/tmpl/listevents.php JROOT/components/com_jevents/views/geraint/day/tmpl/listevents.php:4 12 include JROOT/components/com_jevents/views/geraint/day/tmpl/listevents.php JROOT/libraries/src/MVC/View/HtmlView.php:701 11 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/libraries/src/MVC/View/HtmlView.php:230 10 Joomla\CMS\MVC\View\HtmlView->display() JROOT/administrator/components/com_jevents/views/abstract/abstract.php:133 9 JEventsAbstractView->display() JROOT/components/com_jevents/controllers/day.php:89 8 DayController->listevents() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jevents/jevents.php:365 6 require_once JROOT/components/com_jevents/jevents.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo da consulta: 0.94 ms Após a última consulta: 2.02 ms Consulta a Memória: 0.014 MB de memória antes da consulta: 13.367 MB Linhas devolvidas: 8
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM j25_modules AS m
LEFT JOIN j25_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN j25_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 <= '2026-07-24 08:16:16')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-07-24 08:16:16')
AND m.access IN (1,1)
AND m.client_id = 0
AND (mm.menuid = 273 OR mm.menuid <= 0)
ORDER BY m.position, m.orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ALL PRIMARY,published,newsfeeds Nenhuma chave INDEX KEY pode ser utilizada NULL NULL 44 Using where; Modo Filesort em uso 1 SIMPLE mm ref PRIMARY PRIMARY 4 atmporto_jo151.m.id 1 Using where; Using index 1 SIMPLE e ref element_clientid,element_folder_clientid element_clientid 403 atmporto_jo151.m.module,const 1 Using index condition; Using where Status Duration Starting 0.14 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.05 ms Statistics 0.09 ms Preparing 0.05 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.02 ms Creating sort index 0.25 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.02 ms # Chamador Ficheiro e número da linha 31 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 30 JDatabaseDriver->loadObjectList() Igual à chamada na linha abaixo. 29 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 28 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:441 27 Joomla\CMS\Helper\ModuleHelper::getModuleList() JROOT/libraries/src/Helper/ModuleHelper.php:371 26 Joomla\CMS\Helper\ModuleHelper::load() JROOT/libraries/src/Helper/ModuleHelper.php:87 25 Joomla\CMS\Helper\ModuleHelper::getModules() JROOT/plugins/content/loadmodule/loadmodule.php:169 24 PlgContentLoadmodule->_load() JROOT/plugins/content/loadmodule/loadmodule.php:81 23 PlgContentLoadmodule->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 22 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 21 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 20 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/components/com_jevents/views/default/helpers/defaultloadmodules.php:23 19 DefaultLoadModules() JROOT/components/com_jevents/views/default/abstract/abstract.php:187 18 JEventsDefaultView->__call() JROOT/components/com_jevents/views/default/helpers/defaultviewhelperheader16.php:19 17 DefaultViewHelperHeader16() JROOT/components/com_jevents/views/default/abstract/abstract.php:187 16 JEventsDefaultView->__call() JROOT/components/com_jevents/views/default/helpers/defaultviewhelperheader.php:7 15 DefaultViewHelperHeader() JROOT/components/com_jevents/views/default/abstract/abstract.php:187 14 JEventsDefaultView->__call() JROOT/components/com_jevents/views/default/day/tmpl/listevents.php:4 13 include JROOT/components/com_jevents/views/default/day/tmpl/listevents.php JROOT/components/com_jevents/views/geraint/day/tmpl/listevents.php:4 12 include JROOT/components/com_jevents/views/geraint/day/tmpl/listevents.php JROOT/libraries/src/MVC/View/HtmlView.php:701 11 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/libraries/src/MVC/View/HtmlView.php:230 10 Joomla\CMS\MVC\View\HtmlView->display() JROOT/administrator/components/com_jevents/views/abstract/abstract.php:133 9 JEventsAbstractView->display() JROOT/components/com_jevents/controllers/day.php:89 8 DayController->listevents() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jevents/jevents.php:365 6 require_once JROOT/components/com_jevents/jevents.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo da consulta: 0.95 ms Após a última consulta: 16.53 ms Consulta a Memória: 0.015 MB de memória antes da consulta: 14.683 MB Linhas devolvidas: 18
SHOW FULL COLUMNS
FROM `j25_jev_users`EXPLAIN não é possível na consulta: SHOW FULL COLUMNS FROM `j25_jev_users`Status Duration Starting 0.09 ms checking permissions 0.01 ms closing tables 0.00 ms checking permissions 0.00 ms Opening tables 0.30 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.02 ms Executing 0.00 ms Filling schema table 0.01 ms Opening tables 0.02 ms After opening tables 0.00 ms checking permissions 0.07 ms closing tables 0.01 ms checking permissions 0.01 ms Executing 0.00 ms Sending data 0.04 ms End of update loop 0.00 ms Query end 0.00 ms closing tables 0.00 ms Removing tmp table 0.09 ms closing tables 0.01 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.03 ms Reset for next command 0.01 ms # Chamador Ficheiro e número da linha 30 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 29 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:448 28 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:261 27 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:180 26 Joomla\CMS\Table\Table->__construct() JROOT/administrator/components/com_jevents/tables/jevuser.php:75 25 TableUser->__construct() JROOT/components/com_jevents/libraries/helper.php:1851 24 JEVHelper::getAuthorisedUser() JROOT/components/com_jevents/libraries/helper.php:1706 23 JEVHelper::isEventCreator() JROOT/components/com_jevents/libraries/filters/Published.php:86 22 jevPublishedFilter->__construct() JROOT/components/com_jevents/libraries/filters.php:186 21 jevFilterProcessing->__construct() JROOT/components/com_jevents/libraries/filters.php:257 20 jevFilterProcessing::getInstance() JROOT/components/com_jevents/libraries/dbmodel.php:3013 19 JEventsDBModel->listIcalEvents() JROOT/components/com_jevents/libraries/dbmodel.php:2960 18 JEventsDBModel->listIcalEventsByDay() JROOT/components/com_jevents/libraries/datamodel.php:814 17 JEventsDataModel->getDayData() JROOT/components/com_jevents/views/default/day/tmpl/listevents_body.php:9 16 include JROOT/components/com_jevents/views/default/day/tmpl/listevents_body.php JROOT/components/com_jevents/views/geraint/day/tmpl/listevents_body.php:4 15 include JROOT/components/com_jevents/views/geraint/day/tmpl/listevents_body.php JROOT/libraries/src/MVC/View/HtmlView.php:701 14 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/components/com_jevents/views/default/day/tmpl/listevents.php:7 13 include JROOT/components/com_jevents/views/default/day/tmpl/listevents.php JROOT/components/com_jevents/views/geraint/day/tmpl/listevents.php:4 12 include JROOT/components/com_jevents/views/geraint/day/tmpl/listevents.php JROOT/libraries/src/MVC/View/HtmlView.php:701 11 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/libraries/src/MVC/View/HtmlView.php:230 10 Joomla\CMS\MVC\View\HtmlView->display() JROOT/administrator/components/com_jevents/views/abstract/abstract.php:133 9 JEventsAbstractView->display() JROOT/components/com_jevents/controllers/day.php:89 8 DayController->listevents() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jevents/jevents.php:365 6 require_once JROOT/components/com_jevents/jevents.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo da consulta: 1.11 ms Após a última consulta: 2.61 ms Consulta a Memória: 0.014 MB de memória antes da consulta: 14.837 MB Linhas devolvidas: 18
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 `j25_categories` AS `c`
WHERE (c.extension='com_jevents' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
ORDER BY c.lftid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE c range cat_idx,idx_access cat_idx 207 NULL 18 Using index condition; Modo Filesort em uso Status Duration Starting 0.16 ms checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.08 ms Optimizing 0.03 ms Statistics 0.12 ms Preparing 0.05 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.03 ms Creating sort index 0.31 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.01 ms Query end 0.00 ms closing tables 0.01 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.03 ms Reset for next command 0.01 ms # Chamador Ficheiro e número da linha 29 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 28 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 27 Joomla\CMS\Categories\Categories->_load() JROOT/components/com_jevents/helpers/category.php:53 26 JEventsCategories->_load() JROOT/libraries/src/Categories/Categories.php:184 25 Joomla\CMS\Categories\Categories->get() JROOT/components/com_jevents/libraries/dbmodel.php:427 24 JEventsDBModel->accessibleCategoryList() JROOT/components/com_jevents/libraries/datamodel.php:1021 23 JEventsDataModel->accessibleCategoryList() JROOT/components/com_jevents/libraries/filters/Category.php:47 22 jevCategoryFilter->__construct() JROOT/components/com_jevents/libraries/filters.php:186 21 jevFilterProcessing->__construct() JROOT/components/com_jevents/libraries/filters.php:257 20 jevFilterProcessing::getInstance() JROOT/components/com_jevents/libraries/dbmodel.php:3013 19 JEventsDBModel->listIcalEvents() JROOT/components/com_jevents/libraries/dbmodel.php:2960 18 JEventsDBModel->listIcalEventsByDay() JROOT/components/com_jevents/libraries/datamodel.php:814 17 JEventsDataModel->getDayData() JROOT/components/com_jevents/views/default/day/tmpl/listevents_body.php:9 16 include JROOT/components/com_jevents/views/default/day/tmpl/listevents_body.php JROOT/components/com_jevents/views/geraint/day/tmpl/listevents_body.php:4 15 include JROOT/components/com_jevents/views/geraint/day/tmpl/listevents_body.php JROOT/libraries/src/MVC/View/HtmlView.php:701 14 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/components/com_jevents/views/default/day/tmpl/listevents.php:7 13 include JROOT/components/com_jevents/views/default/day/tmpl/listevents.php JROOT/components/com_jevents/views/geraint/day/tmpl/listevents.php:4 12 include JROOT/components/com_jevents/views/geraint/day/tmpl/listevents.php JROOT/libraries/src/MVC/View/HtmlView.php:701 11 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/libraries/src/MVC/View/HtmlView.php:230 10 Joomla\CMS\MVC\View\HtmlView->display() JROOT/administrator/components/com_jevents/views/abstract/abstract.php:133 9 JEventsAbstractView->display() JROOT/components/com_jevents/controllers/day.php:89 8 DayController->listevents() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jevents/jevents.php:365 6 require_once JROOT/components/com_jevents/jevents.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo da consulta: 0.73 ms Após a última consulta: 1.09 ms Consulta a Memória: 0.013 MB de memória antes da consulta: 14.967 MB Linhas devolvidas: 17
SELECT c.id
FROM j25_categories AS c
WHERE c.access IN (1,1)
AND c.published = 1
AND c.language in ('pt-PT','*')
AND c.extension = 'com_jevents'
ORDER BY c.lft ascid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE c ref cat_idx,idx_access,idx_language cat_idx 207 const,const,const 17 Using index condition; Using where; Modo Filesort em uso Status Duration Starting 0.12 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.04 ms Statistics 0.11 ms Preparing 0.03 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.01 ms Creating sort index 0.14 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.01 ms closing tables 0.00 ms Query end 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Chamador Ficheiro e número da linha 26 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 25 JDatabaseDriver->loadColumn() JROOT/components/com_jevents/libraries/dbmodel.php:563 24 JEventsDBModel->accessibleCategoryList() JROOT/components/com_jevents/libraries/datamodel.php:1021 23 JEventsDataModel->accessibleCategoryList() JROOT/components/com_jevents/libraries/filters/Category.php:47 22 jevCategoryFilter->__construct() JROOT/components/com_jevents/libraries/filters.php:186 21 jevFilterProcessing->__construct() JROOT/components/com_jevents/libraries/filters.php:257 20 jevFilterProcessing::getInstance() JROOT/components/com_jevents/libraries/dbmodel.php:3013 19 JEventsDBModel->listIcalEvents() JROOT/components/com_jevents/libraries/dbmodel.php:2960 18 JEventsDBModel->listIcalEventsByDay() JROOT/components/com_jevents/libraries/datamodel.php:814 17 JEventsDataModel->getDayData() JROOT/components/com_jevents/views/default/day/tmpl/listevents_body.php:9 16 include JROOT/components/com_jevents/views/default/day/tmpl/listevents_body.php JROOT/components/com_jevents/views/geraint/day/tmpl/listevents_body.php:4 15 include JROOT/components/com_jevents/views/geraint/day/tmpl/listevents_body.php JROOT/libraries/src/MVC/View/HtmlView.php:701 14 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/components/com_jevents/views/default/day/tmpl/listevents.php:7 13 include JROOT/components/com_jevents/views/default/day/tmpl/listevents.php JROOT/components/com_jevents/views/geraint/day/tmpl/listevents.php:4 12 include JROOT/components/com_jevents/views/geraint/day/tmpl/listevents.php JROOT/libraries/src/MVC/View/HtmlView.php:701 11 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/libraries/src/MVC/View/HtmlView.php:230 10 Joomla\CMS\MVC\View\HtmlView->display() JROOT/administrator/components/com_jevents/views/abstract/abstract.php:133 9 JEventsAbstractView->display() JROOT/components/com_jevents/controllers/day.php:89 8 DayController->listevents() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jevents/jevents.php:365 6 require_once JROOT/components/com_jevents/jevents.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo da consulta: 0.46 ms Após a última consulta: 0.79 ms Consulta a Memória: 0.011 MB de memória antes da consulta: 15.000 MB Linhas devolvidas: 1
SELECT c.id
FROM j25_categories AS c
WHERE c.access IN (1,1)
AND c.published = 1
AND c.language in ('pt-PT','*')
AND c.extension = 'com_jevents'
AND ((c.lft>=359
AND c.rgt<=360 ))
ORDER BY c.lft ascid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE c range|filter cat_idx,idx_access,idx_left_right,idx_language idx_left_right|cat_idx 4|207 NULL 3 (9%) Using index condition; Using where; Using rowid filter 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.09 ms Preparing 0.02 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.05 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Chamador Ficheiro e número da linha 22 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 21 JDatabaseDriver->loadColumn() JROOT/components/com_jevents/libraries/dbmodel.php:563 20 JEventsDBModel->accessibleCategoryList() JROOT/components/com_jevents/libraries/dbmodel.php:3044 19 JEventsDBModel->listIcalEvents() JROOT/components/com_jevents/libraries/dbmodel.php:2960 18 JEventsDBModel->listIcalEventsByDay() JROOT/components/com_jevents/libraries/datamodel.php:814 17 JEventsDataModel->getDayData() JROOT/components/com_jevents/views/default/day/tmpl/listevents_body.php:9 16 include JROOT/components/com_jevents/views/default/day/tmpl/listevents_body.php JROOT/components/com_jevents/views/geraint/day/tmpl/listevents_body.php:4 15 include JROOT/components/com_jevents/views/geraint/day/tmpl/listevents_body.php JROOT/libraries/src/MVC/View/HtmlView.php:701 14 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/components/com_jevents/views/default/day/tmpl/listevents.php:7 13 include JROOT/components/com_jevents/views/default/day/tmpl/listevents.php JROOT/components/com_jevents/views/geraint/day/tmpl/listevents.php:4 12 include JROOT/components/com_jevents/views/geraint/day/tmpl/listevents.php JROOT/libraries/src/MVC/View/HtmlView.php:701 11 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/libraries/src/MVC/View/HtmlView.php:230 10 Joomla\CMS\MVC\View\HtmlView->display() JROOT/administrator/components/com_jevents/views/abstract/abstract.php:133 9 JEventsAbstractView->display() JROOT/components/com_jevents/controllers/day.php:89 8 DayController->listevents() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jevents/jevents.php:365 6 require_once JROOT/components/com_jevents/jevents.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo da consulta: 0.86 ms Após a última consulta: 0.15 ms Consulta a Memória: 0.011 MB de memória antes da consulta: 15.011 MB Linhas devolvidas: 0
SELECT det.evdet_id as detailid, rpt.*, ev.*, rr.*, det.* , ev.rawdata as evrawdata, ev.state as published, ev.created as created , GROUP_CONCAT(DISTINCT catmapcat.id
ORDER BY catmapcat.lft ASC SEPARATOR ',' ) as catids , YEAR(rpt.startrepeat) as yup, MONTH(rpt.startrepeat ) as mup, DAYOFMONTH(rpt.startrepeat ) as dup , YEAR(rpt.endrepeat ) as ydn, MONTH(rpt.endrepeat ) as mdn, DAYOFMONTH(rpt.endrepeat ) as ddn , HOUR(rpt.startrepeat) as hup, MINUTE(rpt.startrepeat ) as minup, SECOND(rpt.startrepeat ) as sup , HOUR(rpt.endrepeat ) as hdn, MINUTE(rpt.endrepeat ) as mindn, SECOND(rpt.endrepeat ) as sdn
FROM j25_jevents_repetition as rpt
INNER JOIN j25_jevents_vevent as ev
ON rpt.eventid = ev.ev_id
INNER JOIN j25_jevents_icsfile as icsf
ON icsf.ics_id=ev.icsid
INNER JOIN j25_jevents_vevdetail as det
ON det.evdet_id = rpt.eventdetail_id
LEFT JOIN j25_jevents_rrule as rr
ON rr.eventid = rpt.eventid
LEFT JOIN j25_jevents_catmap as catmap
ON catmap.evid = rpt.eventid
LEFT JOIN j25_categories AS catmapcat
ON catmap.catid = catmapcat.id
WHERE 1
AND rpt.endrepeat >= '2029-01-26 00:00:00'
AND rpt.startrepeat <= '2029-01-26 23:59:59'
AND NOT (rpt.startrepeat < '2029-01-26 00:00:00'
AND det.multiday=0)
AND ev.state=1
AND catmap.catid IN(-1,186)
AND ev.access IN (1,1)
AND icsf.state=1
AND icsf.access IN (1,1)
GROUP BY rpt.rp_idid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE icsf system PRIMARY,stateidx Nenhuma chave INDEX KEY pode ser utilizada NULL NULL 1 1 SIMPLE rpt range eventid,eventstart,eventend,eventdetail,startrepeat,startend,endrepeat endrepeat 5 NULL 1 Using index condition; Using where; Modo Filesort em uso 1 SIMPLE ev eq_ref PRIMARY,icsid,stateidx,evaccess PRIMARY 4 atmporto_jo151.rpt.eventid 1 Using where 1 SIMPLE det eq_ref PRIMARY,multiday PRIMARY 4 atmporto_jo151.rpt.eventdetail_id 1 Using where 1 SIMPLE rr ref eventid eventid 4 atmporto_jo151.rpt.eventid 1 1 SIMPLE catmap ref key_event_category,key_evid key_event_category 4 atmporto_jo151.rpt.eventid 1 Using where; Using index 1 SIMPLE catmapcat eq_ref PRIMARY PRIMARY 4 atmporto_jo151.catmap.catid 1 Status Duration Starting 0.12 ms checking permissions 0.01 ms Opening tables 0.12 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.08 ms Optimizing 0.04 ms Statistics 0.13 ms Preparing 0.00 ms Unlocking tables 0.00 ms Preparing 0.09 ms Sorting result 0.02 ms Executing 0.00 ms Sending data 0.03 ms Creating sort index 0.02 ms End of update loop 0.01 ms Removing tmp table 0.01 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.01 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.02 ms # Chamador Ficheiro e número da linha 22 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 21 JDatabaseDriver->loadObjectList() JROOT/components/com_jevents/libraries/dbmodel.php:3305 20 JEventsDBModel->_cachedlistIcalEvents() JROOT/components/com_jevents/libraries/dbmodel.php:3236 19 JEventsDBModel->listIcalEvents() JROOT/components/com_jevents/libraries/dbmodel.php:2960 18 JEventsDBModel->listIcalEventsByDay() JROOT/components/com_jevents/libraries/datamodel.php:814 17 JEventsDataModel->getDayData() JROOT/components/com_jevents/views/default/day/tmpl/listevents_body.php:9 16 include JROOT/components/com_jevents/views/default/day/tmpl/listevents_body.php JROOT/components/com_jevents/views/geraint/day/tmpl/listevents_body.php:4 15 include JROOT/components/com_jevents/views/geraint/day/tmpl/listevents_body.php JROOT/libraries/src/MVC/View/HtmlView.php:701 14 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/components/com_jevents/views/default/day/tmpl/listevents.php:7 13 include JROOT/components/com_jevents/views/default/day/tmpl/listevents.php JROOT/components/com_jevents/views/geraint/day/tmpl/listevents.php:4 12 include JROOT/components/com_jevents/views/geraint/day/tmpl/listevents.php JROOT/libraries/src/MVC/View/HtmlView.php:701 11 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/libraries/src/MVC/View/HtmlView.php:230 10 Joomla\CMS\MVC\View\HtmlView->display() JROOT/administrator/components/com_jevents/views/abstract/abstract.php:133 9 JEventsAbstractView->display() JROOT/components/com_jevents/controllers/day.php:89 8 DayController->listevents() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jevents/jevents.php:365 6 require_once JROOT/components/com_jevents/jevents.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
19 tipos de pedidos registados, ordenados por ocorrências.
ESCOLHER tabelas:
2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `j25_extensions`2 × SELECT c.id
FROM j25_categories AS c1 × SELECT `data`
FROM `j25_session`1 × SELECT id, rules
FROM `j25_viewlevels1 × SELECT b.id
FROM j25_usergroups AS a
LEFT JOIN j25_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM j25_extensions1 × 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 j25_menu AS m
LEFT JOIN j25_extensions AS e
ON m.component_id = e.extension_id1 × SELECT id, home, template, s.params
FROM j25_template_styles as s
LEFT JOIN j25_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id1 × SELECT *
FROM j25_languages1 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `j25_assets`1 × SELECT *
FROM j25_oss_share_setting1 × SELECT `extension_id`,`name`,`enabled`,`params`
FROM j25_extensions1 × 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 j25_fields AS a
LEFT JOIN `j25_languages` AS l
ON l.lang_code = a.language
LEFT JOIN j25_users AS uc
ON uc.id=a.checked_out
LEFT JOIN j25_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN j25_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN j25_fields_groups AS g
ON g.id = a.group_id1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM j25_modules AS m
LEFT JOIN j25_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN j25_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 `j25_categories` AS `c`1 × SELECT det.evdet_id as detailid, rpt.*, ev.*, rr.*, det.* , ev.rawdata as evrawdata, ev.state as published, ev.created as created , GROUP_CONCAT(DISTINCT catmapcat.id
ORDER BY catmapcat.lft ASC SEPARATOR ',' ) as catids , YEAR(rpt.startrepeat) as yup, MONTH(rpt.startrepeat ) as mup, DAYOFMONTH(rpt.startrepeat ) as dup , YEAR(rpt.endrepeat ) as ydn, MONTH(rpt.endrepeat ) as mdn, DAYOFMONTH(rpt.endrepeat ) as ddn , HOUR(rpt.startrepeat) as hup, MINUTE(rpt.startrepeat ) as minup, SECOND(rpt.startrepeat ) as sup , HOUR(rpt.endrepeat ) as hdn, MINUTE(rpt.endrepeat ) as mindn, SECOND(rpt.endrepeat ) as sdn
FROM j25_jevents_repetition as rpt
INNER JOIN j25_jevents_vevent as ev
ON rpt.eventid = ev.ev_id
INNER JOIN j25_jevents_icsfile as icsf
ON icsf.ics_id=ev.icsid
INNER JOIN j25_jevents_vevdetail as det
ON det.evdet_id = rpt.eventdetail_id
LEFT JOIN j25_jevents_rrule as rr
ON rr.eventid = rpt.eventid
LEFT JOIN j25_jevents_catmap as catmap
ON catmap.evid = rpt.eventid
LEFT JOIN j25_categories AS catmapcat
ON catmap.catid = catmapcat.id
OUTRAS tabelas:
1 × UPDATE `j25_extensions`
SET `params` = '{\"mediaversion\":\"0094e9e6f0249877196a0e944f5d52c6\"}'1 × SHOW FULL COLUMNS
FROM `j25_content1 × SHOW FULL COLUMNS
FROM `j25_jev_users