updated 3:22 PM UTC, Aug 11, 2023
Informação:
ESTEJA ATENTO: a Plural&Singular faz 10 anos e vai lançar a 28.ª edição da revista digital semestral que dá voz às questões da deficiência e inclusão
Consola de depuração Joomla
{
"__default": {
"session": {
"counter": 1,
"timer": {
"start": 1701905599,
"last": 1701905599,
"now": 1701905599
},
"token": "B3Fk4icwq1k5Oh1QV01xoUDLXYGHZ0Vg"
},
"registry": {},
"user": {
"id": 0,
"name": null,
"username": null,
"email": null,
"password": null,
"password_clear": "",
"block": null,
"sendEmail": 0,
"registerDate": null,
"lastvisitDate": null,
"activation": null,
"params": null,
"groups": [],
"guest": 1,
"lastResetTime": null,
"resetCount": null,
"requireReset": null,
"aid": 0
}
}
}
Hora
Memória
Hora: 18.27 ms / 18.27 ms Memória: 1.780 MB / 2.17 MB Application: afterLoad
Hora: 100.27 ms / 118.54 ms Memória: 4.317 MB / 6.48 MB Application: afterInitialise
Hora: 43.95 ms / 162.49 ms Memória: 1.834 MB / 8.32 MB Application: afterRoute
Hora: 3.58 ms / 166.07 ms Memória: 0.072 MB / 8.39 MB Application: beforeRenderComponent com_k2
Hora: 0.66 ms / 166.72 ms Memória: 0.027 MB / 8.42 MB Application: Before Access::preloadComponents (all components)
Hora: 2.81 ms / 169.54 ms Memória: 0.062 MB / 8.48 MB Application: After Access::preloadComponents (all components)
Hora: 0.10 ms / 169.64 ms Memória: 0.000 MB / 8.48 MB Application: Before Access::getAssetRules (id:142 name:com_k2)
Hora: 1.53 ms / 171.17 ms Memória: 0.026 MB / 8.50 MB Application: After Access::getAssetRules (id:142 name:com_k2)
Hora: 386.59 ms / 557.76 ms Memória: 5.175 MB / 13.68 MB Application: afterRenderComponent com_k2
Hora: 3.05 ms / 560.81 ms Memória: 0.098 MB / 13.77 MB Application: afterDispatch
Hora: 116.38 ms / 677.19 ms Memória: 1.058 MB / 14.83 MB Application: beforeRenderModule mod_menu (Footer menu)
Hora: 9.39 ms / 686.58 ms Memória: 0.187 MB / 15.02 MB Application: afterRenderModule mod_menu (Footer menu)
Hora: 0.19 ms / 686.77 ms Memória: 0.000 MB / 15.01 MB Application: beforeRenderModule mod_custom (Newsletter from embedded)
Hora: 1.32 ms / 688.09 ms Memória: 0.006 MB / 15.02 MB Application: afterRenderModule mod_custom (Newsletter from embedded)
Hora: 0.19 ms / 688.28 ms Memória: 0.000 MB / 15.02 MB Application: beforeRenderModule mod_search (Search)
Hora: 2.24 ms / 690.52 ms Memória: 0.015 MB / 15.04 MB Application: afterRenderModule mod_search (Search)
Hora: 0.21 ms / 690.74 ms Memória: 0.000 MB / 15.04 MB Application: beforeRenderModule mod_highlighter_gk5 (Texto rolante)
Hora: 11.82 ms / 702.55 ms Memória: 0.139 MB / 15.17 MB Application: afterRenderModule mod_highlighter_gk5 (Texto rolante)
Hora: 0.19 ms / 702.74 ms Memória: 0.000 MB / 15.16 MB Application: beforeRenderModule mod_custom (Lema)
Hora: 0.73 ms / 703.47 ms Memória: 0.003 MB / 15.16 MB Application: afterRenderModule mod_custom (Lema)
Hora: 25.13 ms / 728.60 ms Memória: 0.165 MB / 15.33 MB Application: afterRender
Total de consultas à base de dados: 214.49 ms
16,94 MB (17 760 688 Bytes)
88 pedidos registados 214.49 ms
- Tempo da consulta: 1.18 ms Consulta a Memória: 0.007 MB de memória antes da consulta: 3.850 MB Linhas devolvidas: 0
SELECT `data`
FROM `pl_session`
WHERE `session_id` = '291d779425f5d72d8fcbee53475912fa'id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE pl_session const PRIMARY PRIMARY 194 const 1 100.00 Status Duration Starting 0.24 ms checking permissions 0.02 ms Opening tables 0.06 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.02 ms init 0.05 ms Optimizing 0.04 ms Statistics 0.11 ms Preparing 0.02 ms Executing 0.06 ms End of update loop 0.02 ms Query end 0.02 ms Commit 0.02 ms closing tables 0.02 ms Unlocking tables 0.01 ms closing tables 0.03 ms Starting cleanup 0.02 ms Freeing items 0.14 ms Updating status 0.04 ms Reset for next command 0.03 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: 1.02 ms Após a última consulta: 2.78 ms Consulta a Memória: 0.004 MB de memória antes da consulta: 4.008 MB Linhas devolvidas: 0
SELECT `session_id`
FROM `pl_session`
WHERE `session_id` = '291d779425f5d72d8fcbee53475912fa'
LIMIT 1id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE pl_session const PRIMARY PRIMARY 194 const 1 100.00 Using index Status Duration Starting 0.24 ms checking permissions 0.02 ms Opening tables 0.04 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.02 ms init 0.04 ms Optimizing 0.03 ms Statistics 0.07 ms Preparing 0.02 ms Executing 0.03 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.02 ms closing tables 0.02 ms Unlocking tables 0.01 ms closing tables 0.03 ms Starting cleanup 0.02 ms Freeing items 0.17 ms Updating status 0.04 ms Reset for next command 0.03 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: 2.28 ms Após a última consulta: 0.25 ms Consulta a Memória: 0.004 MB de memória antes da consulta: 4.013 MB
INSERT INTO `pl_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES ('291d779425f5d72d8fcbee53475912fa', 1, 1701905599, 0, '', 0)EXPLAIN não é possível na consulta: INSERT INTO `pl_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('291d779425f5d72d8fcbee53475912fa', 1, 1701905599, 0, '', 0)Status Duration Starting 0.21 ms checking permissions 0.02 ms Opening tables 0.04 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.02 ms init for update 0.04 ms Update 0.22 ms Waiting for query cache lock 0.02 ms Update 0.02 ms End of update loop 0.02 ms Query end 0.02 ms Commit 1.05 ms closing tables 0.03 ms Unlocking tables 0.03 ms closing tables 0.04 ms Starting cleanup 0.03 ms Freeing items 0.28 ms Updating status 0.06 ms Reset for next command 0.04 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: 1.61 ms Após a última consulta: 6.33 ms Consulta a Memória: 0.006 MB de memória antes da consulta: 4.227 MB Linhas devolvidas: 41
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `pl_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 pl_extensions ref extension extension 82 const 41 100.00 Using index condition; Using where Status Duration Starting 0.24 ms checking permissions 0.02 ms Opening tables 0.04 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.02 ms init 0.06 ms Optimizing 0.05 ms Statistics 0.13 ms Preparing 0.07 ms Executing 0.02 ms Sending data 0.44 ms End of update loop 0.02 ms Query end 0.02 ms Commit 0.02 ms closing tables 0.02 ms Unlocking tables 0.01 ms closing tables 0.03 ms Starting cleanup 0.02 ms Freeing items 0.15 ms Updating status 0.05 ms Reset for next command 0.03 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: 1.11 ms Após a última consulta: 4.71 ms Consulta a Memória: 0.005 MB de memória antes da consulta: 4.430 MB Linhas devolvidas: 3
SELECT id, rules
FROM `pl_viewlevels`id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE pl_viewlevels ALL NULL Nehnuma INDEX KEY pode ser utilizada NULL NULL 3 100.00 Status Duration Starting 0.21 ms checking permissions 0.02 ms Opening tables 0.05 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.02 ms init 0.03 ms Optimizing 0.02 ms Statistics 0.04 ms Preparing 0.06 ms Executing 0.02 ms Sending data 0.08 ms End of update loop 0.02 ms Query end 0.02 ms Commit 0.02 ms closing tables 0.02 ms Unlocking tables 0.01 ms closing tables 0.03 ms Starting cleanup 0.02 ms Freeing items 0.14 ms Updating status 0.04 ms Reset for next command 0.03 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: 1.32 ms Após a última consulta: 0.18 ms Consulta a Memória: 0.005 MB de memória antes da consulta: 4.442 MB Linhas devolvidas: 1
SELECT b.id
FROM pl_usergroups AS a
LEFT JOIN pl_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 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 1 100.00 Using where; Using index Status Duration Starting 0.24 ms checking permissions 0.02 ms Opening tables 0.04 ms After opening tables 0.02 ms System lock 0.03 ms table lock 0.02 ms init 0.04 ms Optimizing 0.04 ms Statistics 0.17 ms Preparing 0.02 ms Unlocking tables 0.02 ms Preparing 0.05 ms Executing 0.02 ms Sending data 0.07 ms End of update loop 0.05 ms Query end 0.01 ms Commit 0.02 ms closing tables 0.02 ms Unlocking tables 0.01 ms closing tables 0.03 ms Starting cleanup 0.02 ms Freeing items 0.14 ms Updating status 0.04 ms Reset for next command 0.03 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: 2.27 ms Após a última consulta: 1.35 ms Consulta a Memória: 0.005 MB de memória antes da consulta: 4.510 MB Linhas devolvidas: 106
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM pl_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 filtered Extra 1 SIMPLE pl_extensions ALL extension Nehnuma INDEX KEY pode ser utilizada NULL NULL 257 50.58 Using where; Filesort em utilização Status Duration Starting 0.25 ms checking permissions 0.02 ms Opening tables 0.04 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.02 ms init 0.06 ms Optimizing 0.08 ms Statistics 0.11 ms Preparing 0.05 ms Sorting result 0.03 ms Executing 0.02 ms Sending data 0.03 ms Creating sort index 0.95 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.02 ms closing tables 0.02 ms Unlocking tables 0.01 ms closing tables 0.03 ms Starting cleanup 0.02 ms Freeing items 0.15 ms Updating status 0.05 ms Reset for next command 0.03 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: 3.24 ms Após a última consulta: 45.65 ms Consulta a Memória: 0.009 MB de memória antes da consulta: 6.665 MB Linhas devolvidas: 108
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 pl_menu AS m
LEFT JOIN pl_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 ALL idx_client_id_parent_id_alias_language Nehnuma INDEX KEY pode ser utilizada NULL NULL 217 81.57 Using where; Filesort em utilização 1 SIMPLE e eq_ref PRIMARY PRIMARY 4 plurales_2015.m.component_id 1 100.00 Using where Status Duration Starting 0.36 ms checking permissions 0.02 ms Opening tables 0.09 ms After opening tables 0.03 ms System lock 0.02 ms table lock 0.02 ms init 0.08 ms Optimizing 0.06 ms Statistics 0.15 ms Preparing 0.09 ms Sorting result 0.03 ms Executing 0.02 ms Sending data 0.04 ms Creating sort index 1.76 ms End of update loop 0.03 ms Query end 0.02 ms Commit 0.02 ms closing tables 0.02 ms Unlocking tables 0.01 ms closing tables 0.03 ms Starting cleanup 0.02 ms Freeing items 0.15 ms Updating status 0.05 ms Reset for next command 0.04 ms # Chamador Ficheiro e número da linha 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 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:76 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:131 11 Joomla\CMS\Menu\AbstractMenu::getInstance() JROOT/libraries/src/Application/CMSApplication.php:375 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:64 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:491 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:1073 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: 1.46 ms Após a última consulta: 11.19 ms Consulta a Memória: 0.009 MB de memória antes da consulta: 7.658 MB Linhas devolvidas: 1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `pl_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE pl_extensions ref element_clientid,element_folder_clientid,extension extension 484 const,const 1 100.00 Using index condition Status Duration Starting 0.28 ms checking permissions 0.02 ms Opening tables 0.05 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.02 ms init 0.06 ms Optimizing 0.05 ms Statistics 0.17 ms Preparing 0.12 ms Executing 0.02 ms Sending data 0.14 ms End of update loop 0.02 ms Query end 0.02 ms Commit 0.02 ms closing tables 0.02 ms Unlocking tables 0.01 ms closing tables 0.03 ms Starting cleanup 0.02 ms Freeing items 0.17 ms Updating status 0.07 ms Reset for next command 0.03 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: 3.60 ms Após a última consulta: 0.18 ms Consulta a Memória: 0.006 MB de memória antes da consulta: 7.651 MB
UPDATE `pl_extensions`
SET `params` = '{\"mediaversion\":\"e10ad436ed1d3b4bcbc4b1c312a12ee6\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE pl_extensions range element_clientid,element_folder_clientid,extension extension 484 NULL 1 100.00 Using where Status Duration Starting 0.23 ms checking permissions 0.02 ms Opening tables 0.04 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.02 ms init for update 0.14 ms Updating 0.16 ms End of update loop 0.02 ms Waiting for query cache lock 0.01 ms End of update loop 0.02 ms Query end 0.02 ms Commit 2.55 ms closing tables 0.02 ms Unlocking tables 0.02 ms closing tables 0.03 ms Starting cleanup 0.02 ms Freeing items 0.14 ms Updating status 0.04 ms Reset for next command 0.03 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: 1.36 ms Após a última consulta: 7.43 ms Consulta a Memória: 0.006 MB de memória antes da consulta: 7.987 MB Linhas devolvidas: 1
SELECT *
FROM pl_languages
WHERE published=1
ORDER BY ordering ASCid select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE pl_languages ALL NULL Nehnuma INDEX KEY pode ser utilizada NULL NULL 1 100.00 Using where; Filesort em utilização Status Duration Starting 0.29 ms checking permissions 0.03 ms Opening tables 0.05 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.02 ms init 0.06 ms Optimizing 0.04 ms Statistics 0.05 ms Preparing 0.07 ms Sorting result 0.03 ms Executing 0.01 ms Sending data 0.03 ms Creating sort index 0.14 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.02 ms closing tables 0.02 ms Unlocking tables 0.01 ms closing tables 0.03 ms Starting cleanup 0.02 ms Freeing items 0.17 ms Updating status 0.04 ms Reset for next command 0.03 ms # Chamador Ficheiro e número da linha 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 13 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Language/LanguageHelper.php:150 12 Joomla\CMS\Language\LanguageHelper::getLanguages() JROOT/libraries/src/Application/SiteApplication.php:330 11 Joomla\CMS\Application\SiteApplication->getParams() JROOT/components/com_k2/helpers/utilities.php:243 10 K2HelperUtilities::getParams() JROOT/administrator/components/com_k2/helpers/html.php:53 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: 1.65 ms Após a última consulta: 4.38 ms Consulta a Memória: 0.009 MB de memória antes da consulta: 8.290 MB Linhas devolvidas: 3
SELECT id, home, template, s.params
FROM pl_template_styles as s
LEFT JOIN pl_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 e ref element_clientid,element_folder_clientid,extension extension 82 const 5 100.00 Using index condition; Using where 1 SIMPLE s ALL idx_template Nehnuma INDEX KEY pode ser utilizada NULL NULL 5 100.00 Using where; Using join buffer (flat, BNL join) Status Duration Starting 0.26 ms checking permissions 0.02 ms Opening tables 0.12 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.02 ms init 0.06 ms Optimizing 0.06 ms Statistics 0.15 ms Preparing 0.10 ms Executing 0.02 ms Sending data 0.18 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.02 ms closing tables 0.02 ms Unlocking tables 0.01 ms closing tables 0.03 ms Starting cleanup 0.02 ms Freeing items 0.17 ms Updating status 0.05 ms Reset for next command 0.03 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: 2.17 ms Após a última consulta: 8.02 ms Consulta a Memória: 0.006 MB de memória antes da consulta: 8.421 MB Linhas devolvidas: 41
SELECT `id`,`name`,`rules`,`parent_id`
FROM `pl_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_cincopa','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_installer','com_joomailermailchimpintegration','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_sigpro','com_smartcountdown3','com_tags','com_templates','com_users','com_weblinks','com_wrapper')id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE pl_assets ALL idx_asset_name Nehnuma INDEX KEY pode ser utilizada NULL NULL 155 27.10 Using where Status Duration Starting 0.28 ms checking permissions 0.02 ms Opening tables 0.05 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.02 ms init 0.12 ms Optimizing 0.04 ms Statistics 0.28 ms Preparing 0.04 ms Executing 0.02 ms Sending data 0.63 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.02 ms closing tables 0.02 ms Unlocking tables 0.01 ms closing tables 0.02 ms Starting cleanup 0.02 ms Freeing items 0.17 ms Updating status 0.15 ms Reset for next command 0.03 ms # Chamador Ficheiro e número da linha 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 12 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Access/Access.php:429 11 Joomla\CMS\Access\Access::preloadComponents() JROOT/libraries/src/Access/Access.php:213 10 Joomla\CMS\Access\Access::preload() JROOT/libraries/src/Access/Access.php:531 9 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 8 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 7 Joomla\CMS\User\User->authorise() JROOT/components/com_k2/k2.php:16 6 require_once JROOT/components/com_k2/k2.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.81 ms Após a última consulta: 29.04 ms Consulta a Memória: 0.007 MB de memória antes da consulta: 9.417 MB Linhas devolvidas: 98
SELECT id
FROM pl_k2_categories
WHERE published=1
AND trash=0
AND access IN(1,1)id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE pl_k2_categories ALL category,published,access,trash Nehnuma INDEX KEY pode ser utilizada NULL NULL 119 78.15 Using where Status Duration Starting 0.28 ms checking permissions 0.02 ms Opening tables 0.04 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.02 ms init 0.05 ms Optimizing 0.05 ms Statistics 0.21 ms Preparing 0.06 ms Executing 0.02 ms Sending data 0.49 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.03 ms Starting cleanup 0.02 ms Freeing items 0.15 ms Updating status 0.07 ms Reset for next command 0.03 ms # Chamador Ficheiro e número da linha 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1544 13 JDatabaseDriver->loadColumn() JROOT/components/com_k2/helpers/permissions.php:274 12 K2HelperPermissions::canAddItem() JROOT/components/com_k2/views/itemlist/view.html.php:28 11 K2ViewItemlist->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:19 9 K2Controller->display() JROOT/components/com_k2/controllers/itemlist.php:45 8 K2ControllerItemlist->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:64 6 require_once JROOT/components/com_k2/k2.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: 2.68 ms Após a última consulta: 1.44 ms Consulta a Memória: 0.009 MB de memória antes da consulta: 9.458 MB Linhas devolvidas: 14
SHOW FULL COLUMNS
FROM `pl_k2_categories`EXPLAIN não é possível na consulta: SHOW FULL COLUMNS FROM `pl_k2_categories`Status Duration Starting 0.21 ms checking permissions 0.02 ms closing tables 0.02 ms Opening tables 0.94 ms After opening tables 0.02 ms System lock 0.01 ms table lock 0.02 ms init 0.03 ms Optimizing 0.02 ms Statistics 0.06 ms Preparing 0.04 ms Executing 0.02 ms Filling schema table 0.02 ms Opening tables 0.03 ms After opening tables 0.02 ms checking permissions 0.19 ms closing tables 0.05 ms Executing 0.02 ms Sending data 0.09 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Removing tmp table 0.38 ms closing tables 0.02 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.04 ms Freeing items 0.14 ms Updating status 0.04 ms Reset for next command 0.03 ms # Chamador Ficheiro e número da linha 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 17 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:445 16 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:245 15 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:164 14 Joomla\CMS\Table\Table->__construct() JROOT/administrator/components/com_k2/tables/k2category.php:36 13 TableK2Category->__construct() JROOT/libraries/src/Table/Table.php:312 12 Joomla\CMS\Table\Table::getInstance() JROOT/components/com_k2/views/itemlist/view.html.php:40 11 K2ViewItemlist->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:19 9 K2Controller->display() JROOT/components/com_k2/controllers/itemlist.php:45 8 K2ControllerItemlist->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:64 6 require_once JROOT/components/com_k2/k2.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.05 ms Após a última consulta: 0.71 ms Consulta a Memória: 0.007 MB de memória antes da consulta: 9.500 MB Linhas devolvidas: 1
SELECT *
FROM pl_k2_categories
WHERE id = '40'id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE pl_k2_categories const PRIMARY PRIMARY 4 const 1 100.00 Status Duration Starting 0.19 ms checking permissions 0.02 ms Opening tables 0.03 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.02 ms init 0.05 ms Optimizing 0.03 ms Statistics 0.11 ms Preparing 0.02 ms Unlocking tables 0.02 ms Preparing 0.03 ms Executing 0.01 ms Sending data 0.04 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.03 ms Starting cleanup 0.02 ms Freeing items 0.14 ms Updating status 0.04 ms Reset for next command 0.03 ms # Chamador Ficheiro e número da linha 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1459 13 JDatabaseDriver->loadAssoc() JROOT/administrator/components/com_k2/tables/k2category.php:67 12 TableK2Category->load() JROOT/components/com_k2/views/itemlist/view.html.php:41 11 K2ViewItemlist->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:19 9 K2Controller->display() JROOT/components/com_k2/controllers/itemlist.php:45 8 K2ControllerItemlist->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:64 6 require_once JROOT/components/com_k2/k2.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.85 ms Após a última consulta: 9.23 ms Consulta a Memória: 0.010 MB de memória antes da consulta: 10.118 MB Linhas devolvidas: 0
SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM pl_fields AS a
LEFT JOIN `pl_languages` AS l
ON l.lang_code = a.language
LEFT JOIN pl_users AS uc
ON uc.id=a.checked_out
LEFT JOIN pl_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN pl_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN pl_fields_groups AS g
ON g.id = a.group_id
WHERE a.context = 'com_k2.category'
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 filtered Extra 1 SIMPLE a ref idx_state,idx_access,idx_context idx_state 1 const 1 100.00 Using where; Filesort em utilização 1 SIMPLE l eq_ref idx_langcode idx_langcode 28 plurales_2015.a.language 1 100.00 Using where 1 SIMPLE uc eq_ref PRIMARY PRIMARY 4 plurales_2015.a.checked_out 1 100.00 1 SIMPLE ag const PRIMARY PRIMARY 4 const 1 100.00 1 SIMPLE ua eq_ref PRIMARY PRIMARY 4 plurales_2015.a.created_user_id 1 100.00 Using where 1 SIMPLE g eq_ref PRIMARY PRIMARY 4 plurales_2015.a.group_id 1 100.00 Using where Status Duration Starting 0.37 ms checking permissions 0.02 ms Opening tables 0.11 ms After opening tables 0.02 ms System lock 0.03 ms table lock 0.02 ms init 0.15 ms Optimizing 0.09 ms Statistics 0.20 ms Preparing 0.12 ms Sorting result 0.04 ms Executing 0.02 ms Sending data 0.05 ms Creating sort index 0.09 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.02 ms closing tables 0.02 ms Unlocking tables 0.01 ms closing tables 0.04 ms Starting cleanup 0.02 ms Freeing items 0.16 ms Updating status 0.06 ms Reset for next command 0.04 ms # Chamador Ficheiro e número da linha 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 19 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 18 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_fields/models/fields.php:333 17 FieldsModelFields->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:187 16 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:135 15 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:488 14 PlgSystemFields->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 13 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 12 JEventDispatcher->trigger() JROOT/components/com_k2/views/itemlist/view.html.php:118 11 K2ViewItemlist->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:19 9 K2Controller->display() JROOT/components/com_k2/controllers/itemlist.php:45 8 K2ControllerItemlist->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:64 6 require_once JROOT/components/com_k2/k2.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: 3.94 ms Após a última consulta: 4.55 ms Consulta a Memória: 0.007 MB de memória antes da consulta: 10.438 MB Linhas devolvidas: 11
SELECT *
FROM pl_k2_categories
WHERE parent=40
AND published=1
AND trash=0
AND access IN(1,1)
ORDER BY id ASCid select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE pl_k2_categories index_merge category,parent,published,access,trash parent,trash 5,2 NULL 5 100.00 Using intersect(parent,trash); Using where; Filesort em utilização Status Duration Starting 0.24 ms checking permissions 0.05 ms Opening tables 0.04 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.02 ms init 0.06 ms Optimizing 0.05 ms Statistics 0.20 ms Preparing 0.05 ms Sorting result 0.03 ms Executing 0.02 ms Sending data 0.03 ms Creating sort index 2.65 ms End of update loop 0.02 ms Query end 0.02 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.03 ms Starting cleanup 0.02 ms Freeing items 0.14 ms Updating status 0.05 ms Reset for next command 0.03 ms # Chamador Ficheiro e número da linha 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 13 JDatabaseDriver->loadObjectList() JROOT/components/com_k2/models/itemlist.php:657 12 K2ModelItemlist->getCategoryFirstChildren() JROOT/components/com_k2/views/itemlist/view.html.php:152 11 K2ViewItemlist->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:19 9 K2Controller->display() JROOT/components/com_k2/controllers/itemlist.php:45 8 K2ControllerItemlist->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:64 6 require_once JROOT/components/com_k2/k2.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.30 ms Após a última consulta: 0.76 ms Consulta a Memória: 0.007 MB de memória antes da consulta: 10.522 MB Linhas devolvidas: 0
SELECT id
FROM pl_k2_categories
WHERE parent IN (41)
AND id NOT IN (41)
AND published=1
AND trash=0
AND access IN(1,1)id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE pl_k2_categories ref PRIMARY,category,parent,published,access,trash parent 5 const 1 78.15 Using where Status Duration Starting 0.25 ms checking permissions 0.02 ms Opening tables 0.04 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.02 ms init 0.05 ms Optimizing 0.05 ms Statistics 0.23 ms Preparing 0.06 ms Executing 0.02 ms Sending data 0.05 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.03 ms Starting cleanup 0.02 ms Freeing items 0.15 ms Updating status 0.04 ms Reset for next command 0.03 ms # Chamador Ficheiro e número da linha 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1544 14 JDatabaseDriver->loadColumn() JROOT/components/com_k2/models/itemlist.php:563 13 K2ModelItemlist->getCategoryTree() JROOT/components/com_k2/models/itemlist.php:678 12 K2ModelItemlist->countCategoryItems() JROOT/components/com_k2/views/itemlist/view.html.php:156 11 K2ViewItemlist->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:19 9 K2Controller->display() JROOT/components/com_k2/controllers/itemlist.php:45 8 K2ControllerItemlist->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:64 6 require_once JROOT/components/com_k2/k2.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.46 ms Após a última consulta: 0.09 ms Consulta a Memória: 0.007 MB de memória antes da consulta: 10.529 MB Linhas devolvidas: 1
SELECT COUNT(*)
FROM pl_k2_items
WHERE catid IN (41)
AND published=1
AND trash=0
AND access IN(1,1)
AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2023-12-06 23:33:20' )
AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2023-12-06 23:33:20' )id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE pl_k2_items ref item,catid catid 4 const 1 99.62 Using where Status Duration Starting 0.38 ms checking permissions 0.02 ms Opening tables 0.04 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.02 ms init 0.06 ms Optimizing 0.09 ms Statistics 0.15 ms Preparing 0.07 ms Executing 0.02 ms Sending data 0.11 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.17 ms Updating status 0.04 ms Reset for next command 0.03 ms # Chamador Ficheiro e número da linha 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1734 13 JDatabaseDriver->loadResult() JROOT/components/com_k2/models/itemlist.php:693 12 K2ModelItemlist->countCategoryItems() JROOT/components/com_k2/views/itemlist/view.html.php:156 11 K2ViewItemlist->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:19 9 K2Controller->display() JROOT/components/com_k2/controllers/itemlist.php:45 8 K2ControllerItemlist->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:64 6 require_once JROOT/components/com_k2/k2.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.70 ms Após a última consulta: 0.46 ms Consulta a Memória: 0.007 MB de memória antes da consulta: 10.544 MB Linhas devolvidas: 98
SELECT id, name, parent
FROM pl_k2_categories
WHERE published=1
AND trash=0
AND access IN(1,1)
ORDER BY parentid select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE pl_k2_categories ALL category,published,access,trash Nehnuma INDEX KEY pode ser utilizada NULL NULL 119 78.15 Using where; Filesort em utilização Status Duration Starting 0.27 ms checking permissions 0.02 ms Opening tables 0.04 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.02 ms init 0.05 ms Optimizing 0.04 ms Statistics 0.13 ms Preparing 0.05 ms Sorting result 0.03 ms Executing 0.02 ms Sending data 0.02 ms Creating sort index 0.49 ms End of update loop 0.05 ms Query end 0.02 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.14 ms Updating status 0.04 ms Reset for next command 0.03 ms # Chamador Ficheiro e número da linha 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 15 JDatabaseDriver->loadObjectList() JROOT/components/com_k2/models/itemlist.php:1077 14 K2ModelItemlist->getCategoriesTree() JROOT/components/com_k2/helpers/route.php:314 13 K2HelperRoute::_findItem() JROOT/components/com_k2/helpers/route.php:58 12 K2HelperRoute::getCategoryRoute() JROOT/components/com_k2/views/itemlist/view.html.php:160 11 K2ViewItemlist->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:19 9 K2Controller->display() JROOT/components/com_k2/controllers/itemlist.php:45 8 K2ControllerItemlist->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:64 6 require_once JROOT/components/com_k2/k2.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.14 ms Após a última consulta: 1.46 ms Consulta a Memória: 0.007 MB de memória antes da consulta: 10.612 MB Linhas devolvidas: 0
SELECT id
FROM pl_k2_categories
WHERE parent IN (42)
AND id NOT IN (42)
AND published=1
AND trash=0
AND access IN(1,1)id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE pl_k2_categories ref PRIMARY,category,parent,published,access,trash parent 5 const 1 78.15 Using where Status Duration Starting 0.24 ms checking permissions 0.02 ms Opening tables 0.04 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.02 ms init 0.05 ms Optimizing 0.04 ms Statistics 0.16 ms Preparing 0.06 ms Executing 0.02 ms Sending data 0.05 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.03 ms Starting cleanup 0.02 ms Freeing items 0.14 ms Updating status 0.04 ms Reset for next command 0.03 ms # Chamador Ficheiro e número da linha 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1544 14 JDatabaseDriver->loadColumn() JROOT/components/com_k2/models/itemlist.php:563 13 K2ModelItemlist->getCategoryTree() JROOT/components/com_k2/models/itemlist.php:678 12 K2ModelItemlist->countCategoryItems() JROOT/components/com_k2/views/itemlist/view.html.php:156 11 K2ViewItemlist->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:19 9 K2Controller->display() JROOT/components/com_k2/controllers/itemlist.php:45 8 K2ControllerItemlist->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:64 6 require_once JROOT/components/com_k2/k2.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: 0.08 ms Consulta a Memória: 0.007 MB de memória antes da consulta: 10.619 MB Linhas devolvidas: 1
SELECT COUNT(*)
FROM pl_k2_items
WHERE catid IN (42)
AND published=1
AND trash=0
AND access IN(1,1)
AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2023-12-06 23:33:20' )
AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2023-12-06 23:33:20' )id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE pl_k2_items ref item,catid catid 4 const 4 99.62 Using where Status Duration Starting 0.22 ms checking permissions 0.02 ms Opening tables 0.03 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.02 ms init 0.06 ms Optimizing 0.06 ms Statistics 0.14 ms Preparing 0.07 ms Executing 0.02 ms Sending data 0.19 ms End of update loop 0.02 ms Query end 0.04 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.14 ms Updating status 0.04 ms Reset for next command 0.03 ms # Chamador Ficheiro e número da linha 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1734 13 JDatabaseDriver->loadResult() JROOT/components/com_k2/models/itemlist.php:693 12 K2ModelItemlist->countCategoryItems() JROOT/components/com_k2/views/itemlist/view.html.php:156 11 K2ViewItemlist->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:19 9 K2Controller->display() JROOT/components/com_k2/controllers/itemlist.php:45 8 K2ControllerItemlist->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:64 6 require_once JROOT/components/com_k2/k2.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.13 ms Após a última consulta: 0.54 ms Consulta a Memória: 0.007 MB de memória antes da consulta: 10.627 MB Linhas devolvidas: 0
SELECT id
FROM pl_k2_categories
WHERE parent IN (43)
AND id NOT IN (43)
AND published=1
AND trash=0
AND access IN(1,1)id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE pl_k2_categories ref PRIMARY,category,parent,published,access,trash parent 5 const 1 78.15 Using where Status Duration Starting 0.22 ms checking permissions 0.02 ms Opening tables 0.03 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.02 ms init 0.04 ms Optimizing 0.04 ms Statistics 0.17 ms Preparing 0.06 ms Executing 0.02 ms Sending data 0.05 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.14 ms Updating status 0.04 ms Reset for next command 0.03 ms # Chamador Ficheiro e número da linha 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1544 14 JDatabaseDriver->loadColumn() JROOT/components/com_k2/models/itemlist.php:563 13 K2ModelItemlist->getCategoryTree() JROOT/components/com_k2/models/itemlist.php:678 12 K2ModelItemlist->countCategoryItems() JROOT/components/com_k2/views/itemlist/view.html.php:156 11 K2ViewItemlist->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:19 9 K2Controller->display() JROOT/components/com_k2/controllers/itemlist.php:45 8 K2ControllerItemlist->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:64 6 require_once JROOT/components/com_k2/k2.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.26 ms Após a última consulta: 0.08 ms Consulta a Memória: 0.007 MB de memória antes da consulta: 10.634 MB Linhas devolvidas: 1
SELECT COUNT(*)
FROM pl_k2_items
WHERE catid IN (43)
AND published=1
AND trash=0
AND access IN(1,1)
AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2023-12-06 23:33:20' )
AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2023-12-06 23:33:20' )id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE pl_k2_items ref item,catid catid 4 const 4 99.62 Using where Status Duration Starting 0.22 ms checking permissions 0.02 ms Opening tables 0.03 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.02 ms init 0.06 ms Optimizing 0.06 ms Statistics 0.13 ms Preparing 0.07 ms Executing 0.02 ms Sending data 0.20 ms End of update loop 0.05 ms Query end 0.02 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.03 ms Starting cleanup 0.02 ms Freeing items 0.14 ms Updating status 0.04 ms Reset for next command 0.03 ms # Chamador Ficheiro e número da linha 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1734 13 JDatabaseDriver->loadResult() JROOT/components/com_k2/models/itemlist.php:693 12 K2ModelItemlist->countCategoryItems() JROOT/components/com_k2/views/itemlist/view.html.php:156 11 K2ViewItemlist->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:19 9 K2Controller->display() JROOT/components/com_k2/controllers/itemlist.php:45 8 K2ControllerItemlist->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:64 6 require_once JROOT/components/com_k2/k2.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.07 ms Após a última consulta: 0.53 ms Consulta a Memória: 0.007 MB de memória antes da consulta: 10.642 MB Linhas devolvidas: 0
SELECT id
FROM pl_k2_categories
WHERE parent IN (44)
AND id NOT IN (44)
AND published=1
AND trash=0
AND access IN(1,1)id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE pl_k2_categories ref PRIMARY,category,parent,published,access,trash parent 5 const 1 78.15 Using where Status Duration Starting 0.22 ms checking permissions 0.02 ms Opening tables 0.03 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.02 ms init 0.04 ms Optimizing 0.04 ms Statistics 0.15 ms Preparing 0.06 ms Executing 0.02 ms Sending data 0.05 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.14 ms Updating status 0.04 ms Reset for next command 0.03 ms # Chamador Ficheiro e número da linha 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1544 14 JDatabaseDriver->loadColumn() JROOT/components/com_k2/models/itemlist.php:563 13 K2ModelItemlist->getCategoryTree() JROOT/components/com_k2/models/itemlist.php:678 12 K2ModelItemlist->countCategoryItems() JROOT/components/com_k2/views/itemlist/view.html.php:156 11 K2ViewItemlist->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:19 9 K2Controller->display() JROOT/components/com_k2/controllers/itemlist.php:45 8 K2ControllerItemlist->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:64 6 require_once JROOT/components/com_k2/k2.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.30 ms Após a última consulta: 0.07 ms Consulta a Memória: 0.007 MB de memória antes da consulta: 10.649 MB Linhas devolvidas: 1
SELECT COUNT(*)
FROM pl_k2_items
WHERE catid IN (44)
AND published=1
AND trash=0
AND access IN(1,1)
AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2023-12-06 23:33:20' )
AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2023-12-06 23:33:20' )id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE pl_k2_items ref item,catid catid 4 const 4 99.62 Using where Status Duration Starting 0.21 ms checking permissions 0.02 ms Opening tables 0.04 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.02 ms init 0.08 ms Optimizing 0.06 ms Statistics 0.13 ms Preparing 0.07 ms Executing 0.02 ms Sending data 0.22 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.03 ms Starting cleanup 0.02 ms Freeing items 0.14 ms Updating status 0.04 ms Reset for next command 0.03 ms # Chamador Ficheiro e número da linha 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1734 13 JDatabaseDriver->loadResult() JROOT/components/com_k2/models/itemlist.php:693 12 K2ModelItemlist->countCategoryItems() JROOT/components/com_k2/views/itemlist/view.html.php:156 11 K2ViewItemlist->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:19 9 K2Controller->display() JROOT/components/com_k2/controllers/itemlist.php:45 8 K2ControllerItemlist->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:64 6 require_once JROOT/components/com_k2/k2.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.50 ms Consulta a Memória: 0.007 MB de memória antes da consulta: 10.657 MB Linhas devolvidas: 0
SELECT id
FROM pl_k2_categories
WHERE parent IN (45)
AND id NOT IN (45)
AND published=1
AND trash=0
AND access IN(1,1)id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE pl_k2_categories ref PRIMARY,category,parent,published,access,trash parent 5 const 1 78.15 Using where Status Duration Starting 0.22 ms checking permissions 0.02 ms Opening tables 0.03 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.02 ms init 0.04 ms Optimizing 0.04 ms Statistics 0.15 ms Preparing 0.06 ms Executing 0.02 ms Sending data 0.05 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.14 ms Updating status 0.04 ms Reset for next command 0.03 ms # Chamador Ficheiro e número da linha 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1544 14 JDatabaseDriver->loadColumn() JROOT/components/com_k2/models/itemlist.php:563 13 K2ModelItemlist->getCategoryTree() JROOT/components/com_k2/models/itemlist.php:678 12 K2ModelItemlist->countCategoryItems() JROOT/components/com_k2/views/itemlist/view.html.php:156 11 K2ViewItemlist->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:19 9 K2Controller->display() JROOT/components/com_k2/controllers/itemlist.php:45 8 K2ControllerItemlist->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:64 6 require_once JROOT/components/com_k2/k2.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.27 ms Após a última consulta: 0.08 ms Consulta a Memória: 0.007 MB de memória antes da consulta: 10.664 MB Linhas devolvidas: 1
SELECT COUNT(*)
FROM pl_k2_items
WHERE catid IN (45)
AND published=1
AND trash=0
AND access IN(1,1)
AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2023-12-06 23:33:20' )
AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2023-12-06 23:33:20' )id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE pl_k2_items ref item,catid catid 4 const 4 99.62 Using where Status Duration Starting 0.21 ms checking permissions 0.02 ms Opening tables 0.03 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.02 ms init 0.06 ms Optimizing 0.06 ms Statistics 0.13 ms Preparing 0.07 ms Executing 0.02 ms Sending data 0.20 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.05 ms Starting cleanup 0.02 ms Freeing items 0.14 ms Updating status 0.04 ms Reset for next command 0.03 ms # Chamador Ficheiro e número da linha 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1734 13 JDatabaseDriver->loadResult() JROOT/components/com_k2/models/itemlist.php:693 12 K2ModelItemlist->countCategoryItems() JROOT/components/com_k2/views/itemlist/view.html.php:156 11 K2ViewItemlist->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:19 9 K2Controller->display() JROOT/components/com_k2/controllers/itemlist.php:45 8 K2ControllerItemlist->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:64 6 require_once JROOT/components/com_k2/k2.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.63 ms Consulta a Memória: 0.007 MB de memória antes da consulta: 10.672 MB Linhas devolvidas: 0
SELECT id
FROM pl_k2_categories
WHERE parent IN (134)
AND id NOT IN (134)
AND published=1
AND trash=0
AND access IN(1,1)id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE pl_k2_categories ref PRIMARY,category,parent,published,access,trash parent 5 const 1 78.15 Using where Status Duration Starting 0.23 ms checking permissions 0.02 ms Opening tables 0.03 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.02 ms init 0.04 ms Optimizing 0.04 ms Statistics 0.14 ms Preparing 0.06 ms Executing 0.02 ms Sending data 0.05 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.14 ms Updating status 0.04 ms Reset for next command 0.03 ms # Chamador Ficheiro e número da linha 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1544 14 JDatabaseDriver->loadColumn() JROOT/components/com_k2/models/itemlist.php:563 13 K2ModelItemlist->getCategoryTree() JROOT/components/com_k2/models/itemlist.php:678 12 K2ModelItemlist->countCategoryItems() JROOT/components/com_k2/views/itemlist/view.html.php:156 11 K2ViewItemlist->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:19 9 K2Controller->display() JROOT/components/com_k2/controllers/itemlist.php:45 8 K2ControllerItemlist->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:64 6 require_once JROOT/components/com_k2/k2.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.19 ms Após a última consulta: 0.08 ms Consulta a Memória: 0.007 MB de memória antes da consulta: 10.679 MB Linhas devolvidas: 1
SELECT COUNT(*)
FROM pl_k2_items
WHERE catid IN (134)
AND published=1
AND trash=0
AND access IN(1,1)
AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2023-12-06 23:33:20' )
AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2023-12-06 23:33:20' )id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE pl_k2_items ref item,catid catid 4 const 4 99.62 Using where Status Duration Starting 0.21 ms checking permissions 0.02 ms Opening tables 0.04 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.02 ms init 0.06 ms Optimizing 0.06 ms Statistics 0.13 ms Preparing 0.07 ms Executing 0.02 ms Sending data 0.14 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.03 ms Starting cleanup 0.04 ms Freeing items 0.14 ms Updating status 0.04 ms Reset for next command 0.03 ms # Chamador Ficheiro e número da linha 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1734 13 JDatabaseDriver->loadResult() JROOT/components/com_k2/models/itemlist.php:693 12 K2ModelItemlist->countCategoryItems() JROOT/components/com_k2/views/itemlist/view.html.php:156 11 K2ViewItemlist->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:19 9 K2Controller->display() JROOT/components/com_k2/controllers/itemlist.php:45 8 K2ControllerItemlist->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:64 6 require_once JROOT/components/com_k2/k2.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.12 ms Após a última consulta: 0.36 ms Consulta a Memória: 0.007 MB de memória antes da consulta: 10.687 MB Linhas devolvidas: 0
SELECT id
FROM pl_k2_categories
WHERE parent IN (135)
AND id NOT IN (135)
AND published=1
AND trash=0
AND access IN(1,1)id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE pl_k2_categories ref PRIMARY,category,parent,published,access,trash parent 5 const 1 78.15 Using where Status Duration Starting 0.20 ms checking permissions 0.02 ms Opening tables 0.03 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.02 ms init 0.07 ms Optimizing 0.04 ms Statistics 0.14 ms Preparing 0.06 ms Executing 0.02 ms Sending data 0.05 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.04 ms Unlocking tables 0.01 ms closing tables 0.03 ms Starting cleanup 0.02 ms Freeing items 0.13 ms Updating status 0.04 ms Reset for next command 0.03 ms # Chamador Ficheiro e número da linha 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1544 14 JDatabaseDriver->loadColumn() JROOT/components/com_k2/models/itemlist.php:563 13 K2ModelItemlist->getCategoryTree() JROOT/components/com_k2/models/itemlist.php:678 12 K2ModelItemlist->countCategoryItems() JROOT/components/com_k2/views/itemlist/view.html.php:156 11 K2ViewItemlist->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:19 9 K2Controller->display() JROOT/components/com_k2/controllers/itemlist.php:45 8 K2ControllerItemlist->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:64 6 require_once JROOT/components/com_k2/k2.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.23 ms Após a última consulta: 0.08 ms Consulta a Memória: 0.008 MB de memória antes da consulta: 10.701 MB Linhas devolvidas: 1
SELECT COUNT(*)
FROM pl_k2_items
WHERE catid IN (135)
AND published=1
AND trash=0
AND access IN(1,1)
AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2023-12-06 23:33:20' )
AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2023-12-06 23:33:20' )id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE pl_k2_items ref item,catid catid 4 const 6 99.62 Using where Status Duration Starting 0.24 ms checking permissions 0.02 ms Opening tables 0.03 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.02 ms init 0.06 ms Optimizing 0.06 ms Statistics 0.12 ms Preparing 0.07 ms Executing 0.02 ms Sending data 0.16 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.03 ms Starting cleanup 0.02 ms Freeing items 0.14 ms Updating status 0.06 ms Reset for next command 0.03 ms # Chamador Ficheiro e número da linha 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1734 13 JDatabaseDriver->loadResult() JROOT/components/com_k2/models/itemlist.php:693 12 K2ModelItemlist->countCategoryItems() JROOT/components/com_k2/views/itemlist/view.html.php:156 11 K2ViewItemlist->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:19 9 K2Controller->display() JROOT/components/com_k2/controllers/itemlist.php:45 8 K2ControllerItemlist->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:64 6 require_once JROOT/components/com_k2/k2.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.42 ms Consulta a Memória: 0.007 MB de memória antes da consulta: 10.710 MB Linhas devolvidas: 0
SELECT id
FROM pl_k2_categories
WHERE parent IN (136)
AND id NOT IN (136)
AND published=1
AND trash=0
AND access IN(1,1)id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE pl_k2_categories ref PRIMARY,category,parent,published,access,trash parent 5 const 1 78.15 Using where Status Duration Starting 0.20 ms checking permissions 0.02 ms Opening tables 0.03 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.02 ms init 0.04 ms Optimizing 0.04 ms Statistics 0.19 ms Preparing 0.06 ms Executing 0.02 ms Sending data 0.05 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.13 ms Updating status 0.04 ms Reset for next command 0.03 ms # Chamador Ficheiro e número da linha 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1544 14 JDatabaseDriver->loadColumn() JROOT/components/com_k2/models/itemlist.php:563 13 K2ModelItemlist->getCategoryTree() JROOT/components/com_k2/models/itemlist.php:678 12 K2ModelItemlist->countCategoryItems() JROOT/components/com_k2/views/itemlist/view.html.php:156 11 K2ViewItemlist->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:19 9 K2Controller->display() JROOT/components/com_k2/controllers/itemlist.php:45 8 K2ControllerItemlist->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:64 6 require_once JROOT/components/com_k2/k2.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.24 ms Após a última consulta: 0.08 ms Consulta a Memória: 0.007 MB de memória antes da consulta: 10.717 MB Linhas devolvidas: 1
SELECT COUNT(*)
FROM pl_k2_items
WHERE catid IN (136)
AND published=1
AND trash=0
AND access IN(1,1)
AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2023-12-06 23:33:20' )
AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2023-12-06 23:33:20' )id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE pl_k2_items ref item,catid catid 4 const 4 99.62 Using where Status Duration Starting 0.21 ms checking permissions 0.02 ms Opening tables 0.03 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.04 ms init 0.06 ms Optimizing 0.06 ms Statistics 0.12 ms Preparing 0.07 ms Executing 0.02 ms Sending data 0.16 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.03 ms Starting cleanup 0.02 ms Freeing items 0.14 ms Updating status 0.04 ms Reset for next command 0.03 ms # Chamador Ficheiro e número da linha 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1734 13 JDatabaseDriver->loadResult() JROOT/components/com_k2/models/itemlist.php:693 12 K2ModelItemlist->countCategoryItems() JROOT/components/com_k2/views/itemlist/view.html.php:156 11 K2ViewItemlist->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:19 9 K2Controller->display() JROOT/components/com_k2/controllers/itemlist.php:45 8 K2ControllerItemlist->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:64 6 require_once JROOT/components/com_k2/k2.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.18 ms Após a última consulta: 0.42 ms Consulta a Memória: 0.007 MB de memória antes da consulta: 10.726 MB Linhas devolvidas: 0
SELECT id
FROM pl_k2_categories
WHERE parent IN (137)
AND id NOT IN (137)
AND published=1
AND trash=0
AND access IN(1,1)id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE pl_k2_categories ref PRIMARY,category,parent,published,access,trash parent 5 const 1 78.15 Using where Status Duration Starting 0.23 ms checking permissions 0.02 ms Opening tables 0.03 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.02 ms init 0.05 ms Optimizing 0.04 ms Statistics 0.18 ms Preparing 0.06 ms Executing 0.02 ms Sending data 0.05 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.14 ms Updating status 0.04 ms Reset for next command 0.03 ms # Chamador Ficheiro e número da linha 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1544 14 JDatabaseDriver->loadColumn() JROOT/components/com_k2/models/itemlist.php:563 13 K2ModelItemlist->getCategoryTree() JROOT/components/com_k2/models/itemlist.php:678 12 K2ModelItemlist->countCategoryItems() JROOT/components/com_k2/views/itemlist/view.html.php:156 11 K2ViewItemlist->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:19 9 K2Controller->display() JROOT/components/com_k2/controllers/itemlist.php:45 8 K2ControllerItemlist->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:64 6 require_once JROOT/components/com_k2/k2.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.21 ms Após a última consulta: 0.08 ms Consulta a Memória: 0.007 MB de memória antes da consulta: 10.733 MB Linhas devolvidas: 1
SELECT COUNT(*)
FROM pl_k2_items
WHERE catid IN (137)
AND published=1
AND trash=0
AND access IN(1,1)
AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2023-12-06 23:33:20' )
AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2023-12-06 23:33:20' )id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE pl_k2_items ref item,catid catid 4 const 4 99.62 Using where Status Duration Starting 0.22 ms checking permissions 0.02 ms Opening tables 0.04 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.02 ms init 0.08 ms Optimizing 0.06 ms Statistics 0.13 ms Preparing 0.07 ms Executing 0.02 ms Sending data 0.14 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.03 ms Starting cleanup 0.02 ms Freeing items 0.14 ms Updating status 0.04 ms Reset for next command 0.03 ms # Chamador Ficheiro e número da linha 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1734 13 JDatabaseDriver->loadResult() JROOT/components/com_k2/models/itemlist.php:693 12 K2ModelItemlist->countCategoryItems() JROOT/components/com_k2/views/itemlist/view.html.php:156 11 K2ViewItemlist->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:19 9 K2Controller->display() JROOT/components/com_k2/controllers/itemlist.php:45 8 K2ControllerItemlist->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:64 6 require_once JROOT/components/com_k2/k2.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.08 ms Após a última consulta: 0.39 ms Consulta a Memória: 0.007 MB de memória antes da consulta: 10.742 MB Linhas devolvidas: 0
SELECT id
FROM pl_k2_categories
WHERE parent IN (138)
AND id NOT IN (138)
AND published=1
AND trash=0
AND access IN(1,1)id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE pl_k2_categories ref PRIMARY,category,parent,published,access,trash parent 5 const 1 78.15 Using where Status Duration Starting 0.22 ms checking permissions 0.02 ms Opening tables 0.03 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.02 ms init 0.05 ms Optimizing 0.04 ms Statistics 0.15 ms Preparing 0.06 ms Executing 0.02 ms Sending data 0.05 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.05 ms Freeing items 0.14 ms Updating status 0.04 ms Reset for next command 0.03 ms # Chamador Ficheiro e número da linha 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1544 14 JDatabaseDriver->loadColumn() JROOT/components/com_k2/models/itemlist.php:563 13 K2ModelItemlist->getCategoryTree() JROOT/components/com_k2/models/itemlist.php:678 12 K2ModelItemlist->countCategoryItems() JROOT/components/com_k2/views/itemlist/view.html.php:156 11 K2ViewItemlist->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:19 9 K2Controller->display() JROOT/components/com_k2/controllers/itemlist.php:45 8 K2ControllerItemlist->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:64 6 require_once JROOT/components/com_k2/k2.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.17 ms Após a última consulta: 0.07 ms Consulta a Memória: 0.007 MB de memória antes da consulta: 10.749 MB Linhas devolvidas: 1
SELECT COUNT(*)
FROM pl_k2_items
WHERE catid IN (138)
AND published=1
AND trash=0
AND access IN(1,1)
AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2023-12-06 23:33:20' )
AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2023-12-06 23:33:20' )id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE pl_k2_items ref item,catid catid 4 const 2 99.62 Using where Status Duration Starting 0.21 ms checking permissions 0.02 ms Opening tables 0.03 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.02 ms init 0.06 ms Optimizing 0.06 ms Statistics 0.13 ms Preparing 0.07 ms Executing 0.06 ms Sending data 0.11 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.03 ms Starting cleanup 0.02 ms Freeing items 0.14 ms Updating status 0.04 ms Reset for next command 0.03 ms # Chamador Ficheiro e número da linha 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1734 13 JDatabaseDriver->loadResult() JROOT/components/com_k2/models/itemlist.php:693 12 K2ModelItemlist->countCategoryItems() JROOT/components/com_k2/views/itemlist/view.html.php:156 11 K2ViewItemlist->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:19 9 K2Controller->display() JROOT/components/com_k2/controllers/itemlist.php:45 8 K2ControllerItemlist->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:64 6 require_once JROOT/components/com_k2/k2.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.09 ms Após a última consulta: 0.36 ms Consulta a Memória: 0.007 MB de memória antes da consulta: 10.757 MB Linhas devolvidas: 0
SELECT id
FROM pl_k2_categories
WHERE parent IN (139)
AND id NOT IN (139)
AND published=1
AND trash=0
AND access IN(1,1)id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE pl_k2_categories ref PRIMARY,category,parent,published,access,trash parent 5 const 1 78.15 Using where Status Duration Starting 0.22 ms checking permissions 0.02 ms Opening tables 0.03 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.02 ms init 0.04 ms Optimizing 0.04 ms Statistics 0.14 ms Preparing 0.06 ms Executing 0.02 ms Sending data 0.05 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.08 ms Starting cleanup 0.02 ms Freeing items 0.13 ms Updating status 0.04 ms Reset for next command 0.03 ms # Chamador Ficheiro e número da linha 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1544 14 JDatabaseDriver->loadColumn() JROOT/components/com_k2/models/itemlist.php:563 13 K2ModelItemlist->getCategoryTree() JROOT/components/com_k2/models/itemlist.php:678 12 K2ModelItemlist->countCategoryItems() JROOT/components/com_k2/views/itemlist/view.html.php:156 11 K2ViewItemlist->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:19 9 K2Controller->display() JROOT/components/com_k2/controllers/itemlist.php:45 8 K2ControllerItemlist->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:64 6 require_once JROOT/components/com_k2/k2.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.22 ms Após a última consulta: 0.07 ms Consulta a Memória: 0.007 MB de memória antes da consulta: 10.764 MB Linhas devolvidas: 1
SELECT COUNT(*)
FROM pl_k2_items
WHERE catid IN (139)
AND published=1
AND trash=0
AND access IN(1,1)
AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2023-12-06 23:33:20' )
AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2023-12-06 23:33:20' )id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE pl_k2_items ref item,catid catid 4 const 3 99.62 Using where Status Duration Starting 0.21 ms checking permissions 0.02 ms Opening tables 0.03 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.02 ms init 0.07 ms Optimizing 0.06 ms Statistics 0.12 ms Preparing 0.07 ms Executing 0.02 ms Sending data 0.15 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.03 ms Starting cleanup 0.02 ms Freeing items 0.16 ms Updating status 0.04 ms Reset for next command 0.03 ms # Chamador Ficheiro e número da linha 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1734 13 JDatabaseDriver->loadResult() JROOT/components/com_k2/models/itemlist.php:693 12 K2ModelItemlist->countCategoryItems() JROOT/components/com_k2/views/itemlist/view.html.php:156 11 K2ViewItemlist->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:19 9 K2Controller->display() JROOT/components/com_k2/controllers/itemlist.php:45 8 K2ControllerItemlist->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:64 6 require_once JROOT/components/com_k2/k2.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: 2.02 ms Após a última consulta: 0.79 ms Consulta a Memória: 0.007 MB de memória antes da consulta: 10.792 MB Linhas devolvidas: 11
SELECT id
FROM pl_k2_categories
WHERE parent IN (40)
AND id NOT IN (40)
AND published=1
AND trash=0
AND access IN(1,1)id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE pl_k2_categories index_merge PRIMARY,category,parent,published,access,trash parent,trash 5,2 NULL 5 100.00 Using intersect(parent,trash); Using where Status Duration Starting 0.20 ms checking permissions 0.02 ms Opening tables 0.03 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.02 ms init 0.04 ms Optimizing 0.04 ms Statistics 0.16 ms Preparing 0.06 ms Executing 0.02 ms Sending data 0.99 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.13 ms Updating status 0.04 ms Reset for next command 0.03 ms # Chamador Ficheiro e número da linha 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1544 14 JDatabaseDriver->loadColumn() JROOT/components/com_k2/models/itemlist.php:563 13 K2ModelItemlist->getCategoryTree() JROOT/components/com_k2/models/itemlist.php:109 12 K2ModelItemlist->getData() JROOT/components/com_k2/views/itemlist/view.html.php:351 11 K2ViewItemlist->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:19 9 K2Controller->display() JROOT/components/com_k2/controllers/itemlist.php:45 8 K2ControllerItemlist->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:64 6 require_once JROOT/components/com_k2/k2.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.34 ms Após a última consulta: 0.07 ms Consulta a Memória: 0.007 MB de memória antes da consulta: 10.801 MB Linhas devolvidas: 0
SELECT id
FROM pl_k2_categories
WHERE parent IN (41,42,43,44,45,134,135,136,137,138,139)
AND id NOT IN (41,42,43,44,45,134,135,136,137,138,139)
AND published=1
AND trash=0
AND access IN(1,1)id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE pl_k2_categories range PRIMARY,category,parent,published,access,trash parent 5 NULL 11 78.15 Using index condition; Using where Status Duration Starting 0.22 ms checking permissions 0.04 ms Opening tables 0.04 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.02 ms init 0.06 ms Optimizing 0.05 ms Statistics 0.29 ms Preparing 0.06 ms Executing 0.02 ms Sending data 0.14 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.14 ms Updating status 0.04 ms Reset for next command 0.04 ms # Chamador Ficheiro e número da linha 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1544 14 JDatabaseDriver->loadColumn() JROOT/components/com_k2/models/itemlist.php:563 13 K2ModelItemlist->getCategoryTree() JROOT/components/com_k2/models/itemlist.php:109 12 K2ModelItemlist->getData() JROOT/components/com_k2/views/itemlist/view.html.php:351 11 K2ViewItemlist->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:19 9 K2Controller->display() JROOT/components/com_k2/controllers/itemlist.php:45 8 K2ControllerItemlist->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:64 6 require_once JROOT/components/com_k2/k2.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: 7.07 ms Após a última consulta: 0.13 ms Consulta a Memória: 0.007 MB de memória antes da consulta: 10.807 MB Linhas devolvidas: 28