Tempo da consulta: 2.41 ms Consulta a Memória: 0.007 MB de memória antes da consulta: 3.852 MB Linhas devolvidas: 0
SELECT `data`
FROM `pl_session`
WHERE `session_id` = '77e94327647968cb6284f28a64c5a9f6'
| 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.58 ms |
| checking permissions | 0.05 ms |
| Opening tables | 0.09 ms |
| After opening tables | 0.06 ms |
| System lock | 0.04 ms |
| table lock | 0.05 ms |
| init | 0.10 ms |
| Optimizing | 0.11 ms |
| Statistics | 0.22 ms |
| Preparing | 0.05 ms |
| Executing | 0.06 ms |
| End of update loop | 0.04 ms |
| Query end | 0.03 ms |
| Commit | 0.04 ms |
| Query end | 0.03 ms |
| closing tables | 0.03 ms |
| Unlocking tables | 0.03 ms |
| closing tables | 0.04 ms |
| Query end | 0.04 ms |
| Starting cleanup | 0.06 ms |
| Freeing items | 0.28 ms |
| Updating status | 0.08 ms |
| Reset for next command | 0.10 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.92 ms Após a última consulta: 3.22 ms Consulta a Memória: 0.004 MB de memória antes da consulta: 4.010 MB Linhas devolvidas: 0
SELECT `session_id`
FROM `pl_session`
WHERE `session_id` = '77e94327647968cb6284f28a64c5a9f6'
LIMIT 1
| 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 | Using index |
| Status | Duration |
|---|
| Starting | 0.37 ms |
| checking permissions | 0.05 ms |
| Opening tables | 0.11 ms |
| After opening tables | 0.04 ms |
| System lock | 0.04 ms |
| table lock | 0.07 ms |
| init | 0.08 ms |
| Optimizing | 0.06 ms |
| Statistics | 0.15 ms |
| Preparing | 0.05 ms |
| Executing | 0.06 ms |
| End of update loop | 0.04 ms |
| Query end | 0.03 ms |
| Commit | 0.04 ms |
| Query end | 0.03 ms |
| closing tables | 0.03 ms |
| Unlocking tables | 0.03 ms |
| closing tables | 0.04 ms |
| Query end | 0.04 ms |
| Starting cleanup | 0.04 ms |
| Freeing items | 0.30 ms |
| Updating status | 0.08 ms |
| Reset for next command | 0.07 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: 3.09 ms Após a última consulta: 0.20 ms Consulta a Memória: 0.004 MB de memória antes da consulta: 4.015 MB
INSERT INTO `pl_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES
('77e94327647968cb6284f28a64c5a9f6', 1, 1725763920, 0, '', 0)
EXPLAIN não é possível na consulta: INSERT INTO `pl_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES
('77e94327647968cb6284f28a64c5a9f6', 1, 1725763920, 0, '', 0)
| Status | Duration |
|---|
| Starting | 0.39 ms |
| checking permissions | 0.05 ms |
| Opening tables | 0.10 ms |
| After opening tables | 0.05 ms |
| System lock | 0.04 ms |
| table lock | 0.04 ms |
| init for update | 0.07 ms |
| Update | 0.27 ms |
| Waiting for query cache lock | 0.04 ms |
| Update | 0.04 ms |
| End of update loop | 0.04 ms |
| Query end | 0.03 ms |
| Commit | 1.27 ms |
| Query end | 0.03 ms |
| closing tables | 0.02 ms |
| Unlocking tables | 0.03 ms |
| closing tables | 0.05 ms |
| Query end | 0.03 ms |
| Starting cleanup | 0.03 ms |
| Freeing items | 0.16 ms |
| Updating status | 0.05 ms |
| Reset for next command | 0.05 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: 2.33 ms Após a última consulta: 5.90 ms Consulta a Memória: 0.006 MB de memória antes da consulta: 4.230 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` = 1
| id | 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.36 ms |
| checking permissions | 0.06 ms |
| Opening tables | 0.07 ms |
| After opening tables | 0.03 ms |
| System lock | 0.05 ms |
| table lock | 0.03 ms |
| init | 0.09 ms |
| Optimizing | 0.07 ms |
| Statistics | 0.18 ms |
| Preparing | 0.09 ms |
| Executing | 0.03 ms |
| Sending data | 0.49 ms |
| End of update loop | 0.03 ms |
| Query end | 0.03 ms |
| Commit | 0.03 ms |
| Query end | 0.02 ms |
| closing tables | 0.02 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.03 ms |
| Query end | 0.03 ms |
| Starting cleanup | 0.03 ms |
| Freeing items | 0.16 ms |
| Updating status | 0.05 ms |
| Reset for next command | 0.05 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.62 ms Após a última consulta: 5.10 ms Consulta a Memória: 0.005 MB de memória antes da consulta: 4.433 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.32 ms |
| checking permissions | 0.03 ms |
| Opening tables | 0.08 ms |
| After opening tables | 0.03 ms |
| System lock | 0.03 ms |
| table lock | 0.03 ms |
| init | 0.05 ms |
| Optimizing | 0.04 ms |
| Statistics | 0.05 ms |
| Preparing | 0.05 ms |
| Executing | 0.02 ms |
| Sending data | 0.10 ms |
| End of update loop | 0.03 ms |
| Query end | 0.02 ms |
| Commit | 0.05 ms |
| Query end | 0.03 ms |
| closing tables | 0.02 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.03 ms |
| Query end | 0.05 ms |
| Starting cleanup | 0.03 ms |
| Freeing items | 0.14 ms |
| Updating status | 0.04 ms |
| Reset for next command | 0.05 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.55 ms Após a última consulta: 0.22 ms Consulta a Memória: 0.005 MB de memória antes da consulta: 4.444 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 = 1
| id | 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.26 ms |
| checking permissions | 0.03 ms |
| Opening tables | 0.07 ms |
| After opening tables | 0.03 ms |
| System lock | 0.02 ms |
| table lock | 0.03 ms |
| init | 0.06 ms |
| Optimizing | 0.06 ms |
| Statistics | 0.18 ms |
| Preparing | 0.03 ms |
| Unlocking tables | 0.02 ms |
| Preparing | 0.06 ms |
| Executing | 0.03 ms |
| Sending data | 0.07 ms |
| End of update loop | 0.02 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| Query end | 0.02 ms |
| closing tables | 0.02 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.02 ms |
| Query end | 0.03 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.16 ms |
| Updating status | 0.05 ms |
| Reset for next command | 0.04 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.58 ms Após a última consulta: 1.40 ms Consulta a Memória: 0.005 MB de memória antes da consulta: 4.513 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 ordering
| id | 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.31 ms |
| checking permissions | 0.03 ms |
| Opening tables | 0.07 ms |
| After opening tables | 0.03 ms |
| System lock | 0.03 ms |
| table lock | 0.03 ms |
| init | 0.09 ms |
| Optimizing | 0.07 ms |
| Statistics | 0.14 ms |
| Preparing | 0.06 ms |
| Sorting result | 0.04 ms |
| Executing | 0.02 ms |
| Sending data | 0.03 ms |
| Creating sort index | 0.97 ms |
| End of update loop | 0.03 ms |
| Query end | 0.02 ms |
| Commit | 0.03 ms |
| Query end | 0.02 ms |
| closing tables | 0.02 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.03 ms |
| Query end | 0.03 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.16 ms |
| Updating status | 0.08 ms |
| Reset for next command | 0.04 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.31 ms Após a última consulta: 55.66 ms Consulta a Memória: 0.009 MB de memória antes da consulta: 6.668 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.lft
| id | 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.42 ms |
| checking permissions | 0.03 ms |
| Opening tables | 0.09 ms |
| After opening tables | 0.03 ms |
| System lock | 0.03 ms |
| table lock | 0.04 ms |
| init | 0.10 ms |
| Optimizing | 0.06 ms |
| Statistics | 0.24 ms |
| Preparing | 0.08 ms |
| Sorting result | 0.04 ms |
| Executing | 0.02 ms |
| Sending data | 0.04 ms |
| Creating sort index | 1.32 ms |
| End of update loop | 0.03 ms |
| Query end | 0.02 ms |
| Commit | 0.03 ms |
| Query end | 0.03 ms |
| closing tables | 0.02 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.03 ms |
| Query end | 0.04 ms |
| Starting cleanup | 0.04 ms |
| Freeing items | 0.23 ms |
| Updating status | 0.05 ms |
| Reset for next command | 0.05 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: 2.26 ms Após a última consulta: 13.36 ms Consulta a Memória: 0.009 MB de memória antes da consulta: 7.661 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.50 ms |
| checking permissions | 0.04 ms |
| Opening tables | 0.08 ms |
| After opening tables | 0.04 ms |
| System lock | 0.03 ms |
| table lock | 0.04 ms |
| init | 0.09 ms |
| Optimizing | 0.07 ms |
| Statistics | 0.25 ms |
| Preparing | 0.14 ms |
| Executing | 0.03 ms |
| Sending data | 0.18 ms |
| End of update loop | 0.04 ms |
| Query end | 0.03 ms |
| Commit | 0.03 ms |
| Query end | 0.03 ms |
| closing tables | 0.03 ms |
| Unlocking tables | 0.03 ms |
| closing tables | 0.04 ms |
| Query end | 0.03 ms |
| Starting cleanup | 0.03 ms |
| Freeing items | 0.18 ms |
| Updating status | 0.07 ms |
| Reset for next command | 0.06 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: 2.32 ms Após a última consulta: 0.48 ms Consulta a Memória: 0.006 MB de memória antes da consulta: 7.654 MB
UPDATE `pl_extensions`
SET `params` = '{\"mediaversion\":\"285ef797040ed62b2d3942b537528beb\"}'
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.25 ms |
| checking permissions | 0.03 ms |
| Opening tables | 0.05 ms |
| After opening tables | 0.03 ms |
| System lock | 0.03 ms |
| table lock | 0.03 ms |
| init for update | 0.22 ms |
| Updating | 0.22 ms |
| End of update loop | 0.03 ms |
| Waiting for query cache lock | 0.03 ms |
| End of update loop | 0.03 ms |
| Query end | 0.03 ms |
| Commit | 0.81 ms |
| Query end | 0.03 ms |
| closing tables | 0.02 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.03 ms |
| Query end | 0.02 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 |
|---|
| 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: 2.27 ms Após a última consulta: 9.31 ms Consulta a Memória: 0.006 MB de memória antes da consulta: 7.990 MB Linhas devolvidas: 1
SELECT *
FROM pl_languages
WHERE published=1
ORDER BY ordering ASC
| id | 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.43 ms |
| checking permissions | 0.04 ms |
| Opening tables | 0.09 ms |
| After opening tables | 0.04 ms |
| System lock | 0.03 ms |
| table lock | 0.04 ms |
| init | 0.17 ms |
| Optimizing | 0.07 ms |
| Statistics | 0.10 ms |
| Preparing | 0.08 ms |
| Sorting result | 0.05 ms |
| Executing | 0.03 ms |
| Sending data | 0.06 ms |
| Creating sort index | 0.20 ms |
| End of update loop | 0.04 ms |
| Query end | 0.03 ms |
| Commit | 0.03 ms |
| Query end | 0.03 ms |
| closing tables | 0.03 ms |
| Unlocking tables | 0.03 ms |
| closing tables | 0.04 ms |
| Query end | 0.04 ms |
| Starting cleanup | 0.03 ms |
| Freeing items | 0.23 ms |
| Updating status | 0.07 ms |
| Reset for next command | 0.06 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: 2.36 ms Após a última consulta: 5.38 ms Consulta a Memória: 0.009 MB de memória antes da consulta: 8.293 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 = 1
| id | 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.44 ms |
| checking permissions | 0.04 ms |
| Opening tables | 0.09 ms |
| After opening tables | 0.04 ms |
| System lock | 0.03 ms |
| table lock | 0.04 ms |
| init | 0.10 ms |
| Optimizing | 0.09 ms |
| Statistics | 0.23 ms |
| Preparing | 0.17 ms |
| Executing | 0.03 ms |
| Sending data | 0.29 ms |
| End of update loop | 0.04 ms |
| Query end | 0.03 ms |
| Commit | 0.03 ms |
| Query end | 0.03 ms |
| closing tables | 0.03 ms |
| Unlocking tables | 0.03 ms |
| closing tables | 0.04 ms |
| Query end | 0.04 ms |
| Starting cleanup | 0.03 ms |
| Freeing items | 0.18 ms |
| Updating status | 0.07 ms |
| Reset for next command | 0.08 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.82 ms Após a última consulta: 5.25 ms Consulta a Memória: 0.006 MB de memória antes da consulta: 8.423 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.39 ms |
| checking permissions | 0.03 ms |
| Opening tables | 0.07 ms |
| After opening tables | 0.04 ms |
| System lock | 0.03 ms |
| table lock | 0.06 ms |
| init | 0.20 ms |
| Optimizing | 0.06 ms |
| Statistics | 0.31 ms |
| Preparing | 0.06 ms |
| Executing | 0.03 ms |
| Sending data | 0.69 ms |
| End of update loop | 0.04 ms |
| Query end | 0.03 ms |
| Commit | 0.03 ms |
| Query end | 0.03 ms |
| closing tables | 0.03 ms |
| Unlocking tables | 0.03 ms |
| closing tables | 0.03 ms |
| Query end | 0.03 ms |
| Starting cleanup | 0.03 ms |
| Freeing items | 0.20 ms |
| Updating status | 0.07 ms |
| Reset for next command | 0.05 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.76 ms Após a última consulta: 27.33 ms Consulta a Memória: 0.007 MB de memória antes da consulta: 9.421 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.26 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.05 ms |
| After opening tables | 0.03 ms |
| System lock | 0.03 ms |
| table lock | 0.06 ms |
| init | 0.06 ms |
| Optimizing | 0.04 ms |
| Statistics | 0.19 ms |
| Preparing | 0.08 ms |
| Executing | 0.02 ms |
| Sending data | 0.37 ms |
| End of update loop | 0.03 ms |
| Query end | 0.02 ms |
| closing tables | 0.02 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.02 ms |
| Query end | 0.02 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.16 ms |
| Updating status | 0.04 ms |
| Reset for next command | 0.05 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.46 ms Após a última consulta: 1.54 ms Consulta a Memória: 0.010 MB de memória antes da consulta: 9.493 MB Linhas devolvidas: 15
SHOW FULL COLUMNS
FROM `pl_users`
EXPLAIN não é possível na consulta: SHOW FULL COLUMNS FROM `pl_users`
| Status | Duration |
|---|
| Starting | 0.20 ms |
| checking permissions | 0.02 ms |
| closing tables | 0.02 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.73 ms |
| After opening tables | 0.02 ms |
| System lock | 0.02 ms |
| table lock | 0.02 ms |
| init | 0.03 ms |
| Optimizing | 0.03 ms |
| Statistics | 0.04 ms |
| Preparing | 0.05 ms |
| Executing | 0.02 ms |
| Filling schema table | 0.02 ms |
| Opening tables | 0.04 ms |
| After opening tables | 0.02 ms |
| checking permissions | 0.17 ms |
| closing tables | 0.03 ms |
| checking permissions | 0.03 ms |
| Executing | 0.02 ms |
| Sending data | 0.07 ms |
| End of update loop | 0.02 ms |
| Query end | 0.03 ms |
| closing tables | 0.02 ms |
| Removing tmp table | 0.31 ms |
| closing tables | 0.02 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.02 ms |
| Query end | 0.02 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.15 ms |
| Updating status | 0.04 ms |
| Reset for next command | 0.05 ms |
| # | Chamador | Ficheiro e número da linha |
|---|
| 23 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
| 22 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:445 |
| 21 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/src/Table/Table.php:245 |
| 20 | Joomla\CMS\Table\Table->getFields() | JROOT/libraries/src/Table/Table.php:164 |
| 19 | Joomla\CMS\Table\Table->__construct() | JROOT/libraries/src/Table/User.php:40 |
| 18 | Joomla\CMS\Table\User->__construct() | JROOT/libraries/src/Table/Table.php:312 |
| 17 | Joomla\CMS\Table\Table::getInstance() | JROOT/libraries/src/User/User.php:603 |
| 16 | Joomla\CMS\User\User::getTable() | JROOT/libraries/src/User/User.php:880 |
| 15 | Joomla\CMS\User\User->load() | JROOT/libraries/src/User/User.php:248 |
| 14 | Joomla\CMS\User\User->__construct() | JROOT/libraries/src/User/User.php:301 |
| 13 | Joomla\CMS\User\User::getInstance() | JROOT/libraries/src/Factory.php:266 |
| 12 | Joomla\CMS\Factory::getUser() | JROOT/components/com_k2/views/itemlist/view.html.php:193 |
| 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.94 ms Após a última consulta: 1.25 ms Consulta a Memória: 0.009 MB de memória antes da consulta: 9.541 MB Linhas devolvidas: 1
SELECT *
FROM `pl_users`
WHERE `id` = 44
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | pl_users | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | |
| Status | Duration |
|---|
| Starting | 0.20 ms |
| checking permissions | 0.03 ms |
| Opening tables | 0.05 ms |
| After opening tables | 0.03 ms |
| System lock | 0.03 ms |
| table lock | 0.02 ms |
| init | 0.06 ms |
| Optimizing | 0.06 ms |
| Statistics | 0.65 ms |
| Preparing | 0.03 ms |
| Unlocking tables | 0.03 ms |
| Preparing | 0.04 ms |
| Executing | 0.03 ms |
| Sending data | 0.05 ms |
| End of update loop | 0.03 ms |
| Query end | 0.02 ms |
| Commit | 0.03 ms |
| Query end | 0.02 ms |
| closing tables | 0.02 ms |
| Unlocking tables | 0.05 ms |
| closing tables | 0.03 ms |
| Query end | 0.03 ms |
| Starting cleanup | 0.03 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 |
|---|
| 18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1459 |
| 17 | JDatabaseDriver->loadAssoc() | JROOT/libraries/src/Table/User.php:86 |
| 16 | Joomla\CMS\Table\User->load() | JROOT/libraries/src/User/User.php:883 |
| 15 | Joomla\CMS\User\User->load() | JROOT/libraries/src/User/User.php:248 |
| 14 | Joomla\CMS\User\User->__construct() | JROOT/libraries/src/User/User.php:301 |
| 13 | Joomla\CMS\User\User::getInstance() | JROOT/libraries/src/Factory.php:266 |
| 12 | Joomla\CMS\Factory::getUser() | JROOT/components/com_k2/views/itemlist/view.html.php:193 |
| 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: 5.12 ms Após a última consulta: 6.93 ms Consulta a Memória: 0.009 MB de memória antes da consulta: 10.297 MB Linhas devolvidas: 1
SELECT `g`.`id`,`g`.`title`
FROM `pl_usergroups` AS g
INNER JOIN `pl_user_usergroup_map` AS m
ON m.group_id = g.id
WHERE `m`.`user_id` = 44
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | m | ref | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | Using index |
| 1 | SIMPLE | g | eq_ref | PRIMARY | PRIMARY | 4 | plurales_2015.m.group_id | 1 | 100.00 | |
| Status | Duration |
|---|
| Starting | 3.61 ms |
| checking permissions | 0.04 ms |
| Opening tables | 0.07 ms |
| After opening tables | 0.03 ms |
| System lock | 0.03 ms |
| table lock | 0.03 ms |
| init | 0.05 ms |
| Optimizing | 0.05 ms |
| Statistics | 0.13 ms |
| Preparing | 0.07 ms |
| Executing | 0.03 ms |
| Sending data | 0.10 ms |
| End of update loop | 0.03 ms |
| Query end | 0.02 ms |
| Commit | 0.03 ms |
| Query end | 0.02 ms |
| closing tables | 0.02 ms |
| Unlocking tables | 0.06 ms |
| closing tables | 0.03 ms |
| Query end | 0.04 ms |
| Starting cleanup | 0.03 ms |
| Freeing items | 0.17 ms |
| Updating status | 0.06 ms |
| Reset for next command | 0.04 ms |
| # | Chamador | Ficheiro e número da linha |
|---|
| 18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1500 |
| 17 | JDatabaseDriver->loadAssocList() | JROOT/libraries/src/Table/User.php:111 |
| 16 | Joomla\CMS\Table\User->load() | JROOT/libraries/src/User/User.php:883 |
| 15 | Joomla\CMS\User\User->load() | JROOT/libraries/src/User/User.php:248 |
| 14 | Joomla\CMS\User\User->__construct() | JROOT/libraries/src/User/User.php:301 |
| 13 | Joomla\CMS\User\User::getInstance() | JROOT/libraries/src/Factory.php:266 |
| 12 | Joomla\CMS\Factory::getUser() | JROOT/components/com_k2/views/itemlist/view.html.php:193 |
| 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.48 ms Após a última consulta: 0.28 ms Consulta a Memória: 0.007 MB de memória antes da consulta: 10.303 MB Linhas devolvidas: 1
Consultas duplicadas:
#19SELECT id, gender, description, image, url, `
group`, plugins
FROM pl_k2_users
WHERE userID=44
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | pl_k2_users | ref | userID | userID | 4 | const | 1 | 100.00 | |
| Status | Duration |
|---|
| Starting | 0.32 ms |
| checking permissions | 0.03 ms |
| Opening tables | 0.06 ms |
| After opening tables | 0.02 ms |
| System lock | 0.02 ms |
| table lock | 0.03 ms |
| init | 0.05 ms |
| Optimizing | 0.05 ms |
| Statistics | 0.12 ms |
| Preparing | 0.06 ms |
| Executing | 0.02 ms |
| Sending data | 0.10 ms |
| End of update loop | 0.03 ms |
| Query end | 0.02 ms |
| closing tables | 0.02 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.02 ms |
| Query end | 0.03 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.17 ms |
| Updating status | 0.06 ms |
| Reset for next command | 0.06 ms |
| # | Chamador | Ficheiro e número da linha |
|---|
| 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1656 |
| 13 | JDatabaseDriver->loadObject() | JROOT/components/com_k2/models/itemlist.php:707 |
| 12 | K2ModelItemlist->getUserProfile() | JROOT/components/com_k2/views/itemlist/view.html.php:202 |
| 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.43 ms Após a última consulta: 0.39 ms Consulta a Memória: 0.007 MB de memória antes da consulta: 10.310 MB Linhas devolvidas: 1
Consultas duplicadas:
#18SELECT id, gender, description, image, url, `
group`, plugins
FROM pl_k2_users
WHERE userID=44
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | pl_k2_users | ref | userID | userID | 4 | const | 1 | 100.00 | |
| Status | Duration |
|---|
| Starting | 0.24 ms |
| checking permissions | 0.03 ms |
| Opening tables | 0.10 ms |
| After opening tables | 0.03 ms |
| System lock | 0.03 ms |
| table lock | 0.05 ms |
| init | 0.05 ms |
| Optimizing | 0.04 ms |
| Statistics | 0.09 ms |
| Preparing | 0.06 ms |
| Executing | 0.03 ms |
| Sending data | 0.09 ms |
| End of update loop | 0.03 ms |
| Query end | 0.03 ms |
| closing tables | 0.03 ms |
| Unlocking tables | 0.03 ms |
| closing tables | 0.03 ms |
| Query end | 0.03 ms |
| Starting cleanup | 0.03 ms |
| Freeing items | 0.15 ms |
| Updating status | 0.06 ms |
| Reset for next command | 0.08 ms |
| # | Chamador | Ficheiro e número da linha |
|---|
| 15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1656 |
| 14 | JDatabaseDriver->loadObject() | JROOT/components/com_k2/models/item.php:1550 |
| 13 | K2ModelItem->getUserProfile() | JROOT/components/com_k2/helpers/utilities.php:45 |
| 12 | K2HelperUtilities::getAvatar() | JROOT/components/com_k2/views/itemlist/view.html.php:205 |
| 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: 136.78 ms Após a última consulta: 2.43 ms Consulta a Memória: 0.007 MB de memória antes da consulta: 10.350 MB Linhas devolvidas: 4
SELECT i.*, c.name as categoryname,c.id as categoryid, c.alias as categoryalias, c.params as categoryparams
FROM pl_k2_items as i RIGHT JOIN pl_k2_categories AS c
ON c.id = i.catid
WHERE i.published = 1
AND i.access IN(1,1)
AND i.trash = 0
AND c.published = 1
AND c.access IN(1,1)
AND c.trash = 0
AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2024-09-08 02:52:01' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-09-08 02:52:01' )
AND i.created_by=44
AND i.created_by_alias=''
ORDER BY i.id DESC
LIMIT 728, 4
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | i | ref | item,catid,created_by | item | 2 | const | 2085 | 35.22 | Using index condition; Using where; Filesort em utilização |
| 1 | SIMPLE | c | eq_ref | PRIMARY,category,published,access,trash | PRIMARY | 4 | plurales_2015.i.catid | 1 | 78.15 | Using index condition; Using where |
| Status | Duration |
|---|
| Starting | 0.70 ms |
| checking permissions | 0.05 ms |
| Opening tables | 0.10 ms |
| After opening tables | 0.04 ms |
| System lock | 0.04 ms |
| table lock | 0.05 ms |
| init | 0.20 ms |
| Optimizing | 0.16 ms |
| Statistics | 0.51 ms |
| Preparing | 0.19 ms |
| Sorting result | 0.06 ms |
| Executing | 0.04 ms |
| Sending data | 0.09 ms |
| Creating sort index | 133.62 ms |
| End of update loop | 0.09 ms |
| Query end | 0.04 ms |
| closing tables | 0.03 ms |
| Unlocking tables | 0.03 ms |
| closing tables | 0.06 ms |
| Query end | 0.05 ms |
| Starting cleanup | 0.04 ms |
| Freeing items | 0.32 ms |
| Updating status | 0.10 ms |
| Reset for next command | 0.07 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:322 |
| 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: 35.22 ms Após a última consulta: 0.47 ms Consulta a Memória: 0.007 MB de memória antes da consulta: 10.405 MB Linhas devolvidas: 1
SELECT COUNT(*)
FROM pl_k2_items as i RIGHT JOIN pl_k2_categories c
ON c.id = i.catid
WHERE i.published = 1
AND i.access IN(1,1)
AND i.trash = 0
AND c.published = 1
AND c.access IN(1,1)
AND c.trash = 0
AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2024-09-08 02:52:01' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-09-08 02:52:01' )
AND i.created_by=44
AND i.created_by_alias=''
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | c | ALL | PRIMARY,category,published,access,trash | Nehnuma INDEX KEY pode ser utilizada | NULL | NULL | 119 | 78.15 | Using where |
| 1 | SIMPLE | i | ref|filter | item,catid,created_by | catid|created_by | 4|4 | plurales_2015.c.id | 25 (35%) | 35.22 | Using index condition; Using where; Using rowid filter |
| Status | Duration |
|---|
| Starting | 0.80 ms |
| checking permissions | 0.04 ms |
| Opening tables | 0.09 ms |
| After opening tables | 0.03 ms |
| System lock | 0.04 ms |
| table lock | 0.04 ms |
| init | 0.17 ms |
| Optimizing | 0.15 ms |
| Statistics | 0.40 ms |
| Preparing | 0.15 ms |
| Executing | 0.03 ms |
| Sending data | 32.22 ms |
| End of update loop | 0.10 ms |
| Query end | 0.03 ms |
| closing tables | 0.03 ms |
| Unlocking tables | 0.03 ms |
| closing tables | 0.05 ms |
| Query end | 0.13 ms |
| Starting cleanup | 0.04 ms |
| Freeing items | 0.32 ms |
| Updating status | 0.08 ms |
| Reset for next command | 0.06 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:521 |
| 12 | K2ModelItemlist->getTotal() | JROOT/components/com_k2/views/itemlist/view.html.php:375 |
| 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: 4.03 ms Após a última consulta: 3.59 ms Consulta a Memória: 0.009 MB de memória antes da consulta: 10.528 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.45 ms |
| checking permissions | 0.06 ms |
| closing tables | 0.02 ms |
| checking permissions | 0.03 ms |
| Opening tables | 1.22 ms |
| After opening tables | 0.03 ms |
| System lock | 0.02 ms |
| table lock | 0.03 ms |
| init | 0.05 ms |
| Optimizing | 0.04 ms |
| Statistics | 0.06 ms |
| Preparing | 0.07 ms |
| Executing | 0.03 ms |
| Filling schema table | 0.04 ms |
| Opening tables | 0.08 ms |
| After opening tables | 0.03 ms |
| checking permissions | 0.31 ms |
| closing tables | 0.04 ms |
| checking permissions | 0.04 ms |
| Executing | 0.03 ms |
| Sending data | 0.12 ms |
| End of update loop | 0.03 ms |
| Query end | 0.03 ms |
| closing tables | 0.02 ms |
| Removing tmp table | 0.49 ms |
| closing tables | 0.03 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.05 ms |
| Query end | 0.03 ms |
| Starting cleanup | 0.04 ms |
| Freeing items | 0.21 ms |
| Updating status | 0.06 ms |
| Reset for next command | 0.06 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:417 |
| 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.04 ms Após a última consulta: 0.53 ms Consulta a Memória: 0.009 MB de memória antes da consulta: 10.572 MB Linhas devolvidas: 1
SELECT *
FROM pl_k2_categories
WHERE id = '39'
| 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.32 ms |
| checking permissions | 0.04 ms |
| Opening tables | 0.07 ms |
| After opening tables | 0.03 ms |
| System lock | 0.03 ms |
| table lock | 0.04 ms |
| init | 0.14 ms |
| Optimizing | 0.08 ms |
| Statistics | 0.20 ms |
| Preparing | 0.03 ms |
| Unlocking tables | 0.03 ms |
| Preparing | 0.06 ms |
| Executing | 0.03 ms |
| Sending data | 0.07 ms |
| End of update loop | 0.03 ms |
| Query end | 0.03 ms |
| closing tables | 0.03 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.03 ms |
| Query end | 0.03 ms |
| Starting cleanup | 0.03 ms |
| Freeing items | 0.18 ms |
| Updating status | 0.10 ms |
| Reset for next command | 0.06 ms |
| # | Chamador | Ficheiro e número da linha |
|---|
| 18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1459 |
| 17 | JDatabaseDriver->loadAssoc() | JROOT/administrator/components/com_k2/tables/k2category.php:67 |
| 16 | TableK2Category->load() | JROOT/components/com_k2/models/item.php:65 |
| 15 | K2ModelItem->prepareItem() | Igual à chamada na linha abaixo. |
| 14 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 13 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Cache/Controller/CallbackController.php:45 |
| 12 | Joomla\CMS\Cache\Controller\CallbackController->call() | JROOT/components/com_k2/views/itemlist/view.html.php:419 |
| 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.49 ms Após a última consulta: 3.23 ms Consulta a Memória: 0.009 MB de memória antes da consulta: 10.727 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 parent
| 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; Filesort em utilização |
| Status | Duration |
|---|
| Starting | 0.40 ms |
| checking permissions | 0.04 ms |
| Opening tables | 0.11 ms |
| After opening tables | 0.03 ms |
| System lock | 0.03 ms |
| table lock | 0.05 ms |
| init | 0.09 ms |
| Optimizing | 0.07 ms |
| Statistics | 0.20 ms |
| Preparing | 0.07 ms |
| Sorting result | 0.04 ms |
| Executing | 0.03 ms |
| Sending data | 0.04 ms |
| Creating sort index | 0.62 ms |
| End of update loop | 0.03 ms |
| Query end | 0.03 ms |
| closing tables | 0.02 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.03 ms |
| Query end | 0.03 ms |
| Starting cleanup | 0.03 ms |
| Freeing items | 0.16 ms |
| Updating status | 0.06 ms |
| Reset for next command | 0.05 ms |
| # | Chamador | Ficheiro e número da linha |
|---|
| 20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
| 19 | JDatabaseDriver->loadObjectList() | JROOT/components/com_k2/models/itemlist.php:1077 |
| 18 | K2ModelItemlist->getCategoriesTree() | JROOT/components/com_k2/helpers/route.php:314 |
| 17 | K2HelperRoute::_findItem() | JROOT/components/com_k2/helpers/route.php:58 |
| 16 | K2HelperRoute::getCategoryRoute() | JROOT/components/com_k2/models/item.php:68 |
| 15 | K2ModelItem->prepareItem() | Igual à chamada na linha abaixo. |
| 14 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 13 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Cache/Controller/CallbackController.php:45 |
| 12 | Joomla\CMS\Cache\Controller\CallbackController->call() | JROOT/components/com_k2/views/itemlist/view.html.php:419 |
| 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.71 ms Após a última consulta: 4.85 ms Consulta a Memória: 0.009 MB de memória antes da consulta: 10.834 MB Linhas devolvidas: 1
SELECT *
FROM pl_k2_categories
WHERE id = '15'
| 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.44 ms |
| checking permissions | 0.04 ms |
| Opening tables | 0.06 ms |
| After opening tables | 0.03 ms |
| System lock | 0.03 ms |
| table lock | 0.03 ms |
| init | 0.07 ms |
| Optimizing | 0.04 ms |
| Statistics | 0.14 ms |
| Preparing | 0.03 ms |
| Unlocking tables | 0.02 ms |
| Preparing | 0.04 ms |
| Executing | 0.02 ms |
| Sending data | 0.07 ms |
| End of update loop | 0.04 ms |
| Query end | 0.03 ms |
| closing tables | 0.02 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.07 ms |
| Query end | 0.04 ms |
| Starting cleanup | 0.04 ms |
| Freeing items | 0.18 ms |
| Updating status | 0.05 ms |
| Reset for next command | 0.04 ms |
| # | Chamador | Ficheiro e número da linha |
|---|
| 18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1459 |
| 17 | JDatabaseDriver->loadAssoc() | JROOT/administrator/components/com_k2/tables/k2category.php:67 |
| 16 | TableK2Category->load() | JROOT/components/com_k2/models/item.php:85 |
| 15 | K2ModelItem->prepareItem() | Igual à chamada na linha abaixo. |
| 14 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 13 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Cache/Controller/CallbackController.php:45 |
| 12 | Joomla\CMS\Cache\Controller\CallbackController->call() | JROOT/components/com_k2/views/itemlist/view.html.php:419 |
| 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.72 ms Após a última consulta: 0.77 ms Consulta a Memória: 0.009 MB de memória antes da consulta: 10.857 MB Linhas devolvidas: 0
SELECT tag.*
FROM pl_k2_tags AS tag
JOIN pl_k2_tags_xref AS xref
ON tag.id = xref.tagID
WHERE tag.published=1
AND xref.itemID = 422
ORDER BY xref.id ASC| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | xref | ref | tagID,itemID | itemID | 4 | const | 1 | 100.00 | Using where; Filesort em utilização |
| 1 | SIMPLE | tag | eq_ref | PRIMARY,published | PRIMARY | 4 | plurales_2015.xref.tagID | 1 | 100.00 | Using where |
| Status | Duration |
|---|
| Starting | 0.29 ms |
| checking permissions | 0.03 ms |
| Opening tables | 0.06 ms |
| After opening tables | 0.03 ms |
| System lock | 0.03 ms |
| table lock | 0.03 ms |
| init | 0.06 ms |
| Optimizing | 0.30 ms |
| Statistics | 0.16 ms |
| Preparing | 0.08 ms |
| Sorting result | 0.04 ms |
| Executing | 0.02 ms |
| Sending data | 0.03 ms |
| Creating sort index | 0.07 ms |
| End of update loop | 0.03 ms |
| Query end | 0.02 ms |
| closing tables | 0.02 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.02 ms |
| Query end | 0.03 ms |
| Starting cleanup | 0.03 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 |
|---|
| 18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
| 17 | JDatabaseDriver->loadObjectList() | JROOT/components/com_k2/models/item.php:1174 |
| 16 | K2ModelItem->getItemTags() | JROOT/components/com_k2/models/item.php:98 |
| 15 | K2ModelItem->prepareItem() | Igual à chamada na linha abaixo. |
| 14 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 13 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Cache/Controller/CallbackController.php:45 |
| 12 | Joomla\CMS\Cache\Controller\CallbackController->call() | JROOT/components/com_k2/views/itemlist/view.html.php:419 |
| 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.66 ms Após a última consulta: 20.40 ms Consulta a Memória: 0.010 MB de memória antes da consulta: 11.352 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
LEFT JOIN `pl_fields_categories` AS fc
ON fc.field_id = a.id
WHERE a.context = 'com_k2.itemlist'
AND (fc.category_id IS NULL OR fc.category_id IN (39,0))
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 ASC
| id | 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 |
| 1 | SIMPLE | fc | ref | PRIMARY | PRIMARY | 4 | plurales_2015.a.id | 1 | 100.00 | Using where; Using index |
| Status | Duration |
|---|
| Starting | 0.55 ms |
| checking permissions | 0.06 ms |
| Opening tables | 0.18 ms |
| After opening tables | 0.04 ms |
| System lock | 0.04 ms |
| table lock | 0.04 ms |
| init | 0.17 ms |
| Optimizing | 0.12 ms |
| Statistics | 0.26 ms |
| Preparing | 0.17 ms |
| Sorting result | 0.08 ms |
| Executing | 0.05 ms |
| Sending data | 0.06 ms |
| Creating sort index | 0.12 ms |
| End of update loop | 0.03 ms |
| Query end | 0.03 ms |
| Commit | 0.03 ms |
| Query end | 0.02 ms |
| closing tables | 0.03 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.03 ms |
| Query end | 0.04 ms |
| Starting cleanup | 0.03 ms |
| Freeing items | 0.20 ms |
| Updating status | 0.06 ms |
| Reset for next command | 0.05 ms |
| # | Chamador | Ficheiro e número da linha |
|---|
| 21 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
| 20 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 |
| 19 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/administrator/components/com_fields/models/fields.php:333 |
| 18 | FieldsModelFields->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:187 |
| 17 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/administrator/components/com_fields/helpers/fields.php:135 |
| 16 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:488 |
| 15 | PlgSystemFields->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 |
| 14 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 13 | JEventDispatcher->trigger() | JROOT/components/com_k2/models/item.php:634 |
| 12 | K2ModelItem->execPlugins() | JROOT/components/com_k2/views/itemlist/view.html.php:428 |
| 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.55 ms Após a última consulta: 10.89 ms Consulta a Memória: 0.009 MB de memória antes da consulta: 11.781 MB Linhas devolvidas: 0
SELECT tag.*
FROM pl_k2_tags AS tag
JOIN pl_k2_tags_xref AS xref
ON tag.id = xref.tagID
WHERE tag.published=1
AND xref.itemID = 393
ORDER BY xref.id ASC| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | xref | ref | tagID,itemID | itemID | 4 | const | 1 | 100.00 | Using where; Filesort em utilização |
| 1 | SIMPLE | tag | eq_ref | PRIMARY,published | PRIMARY | 4 | plurales_2015.xref.tagID | 1 | 100.00 | Using where |
| Status | Duration |
|---|
| Starting | 0.34 ms |
| checking permissions | 0.03 ms |
| Opening tables | 0.07 ms |
| After opening tables | 0.02 ms |
| System lock | 0.02 ms |
| table lock | 0.03 ms |
| init | 0.08 ms |
| Optimizing | 0.06 ms |
| Statistics | 0.14 ms |
| Preparing | 0.08 ms |
| Sorting result | 0.04 ms |
| Executing | 0.02 ms |
| Sending data | 0.03 ms |
| Creating sort index | 0.06 ms |
| End of update loop | 0.04 ms |
| Query end | 0.02 ms |
| closing tables | 0.02 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.02 ms |
| Query end | 0.03 ms |
| Starting cleanup | 0.04 ms |
| Freeing items | 0.13 ms |
| Updating status | 0.05 ms |
| Reset for next command | 0.04 ms |
| # | Chamador | Ficheiro e número da linha |
|---|
| 18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
| 17 | JDatabaseDriver->loadObjectList() | JROOT/components/com_k2/models/item.php:1174 |
| 16 | K2ModelItem->getItemTags() | JROOT/components/com_k2/models/item.php:98 |
| 15 | K2ModelItem->prepareItem() | Igual à chamada na linha abaixo. |
| 14 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 13 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Cache/Controller/CallbackController.php:45 |
| 12 | Joomla\CMS\Cache\Controller\CallbackController->call() | JROOT/components/com_k2/views/itemlist/view.html.php:419 |
| 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.37 ms Após a última consulta: 6.65 ms Consulta a Memória: 0.009 MB de memória antes da consulta: 11.832 MB Linhas devolvidas: 0
SELECT tag.*
FROM pl_k2_tags AS tag
JOIN pl_k2_tags_xref AS xref
ON tag.id = xref.tagID
WHERE tag.published=1
AND xref.itemID = 387
ORDER BY xref.id ASC| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | xref | ref | tagID,itemID | itemID | 4 | const | 1 | 100.00 | Using where; Filesort em utilização |
| 1 | SIMPLE | tag | eq_ref | PRIMARY,published | PRIMARY | 4 | plurales_2015.xref.tagID | 1 | 100.00 | Using where |
| Status | Duration |
|---|
| Starting | 0.28 ms |
| checking permissions | 0.03 ms |
| Opening tables | 0.08 ms |
| After opening tables | 0.02 ms |
| System lock | 0.02 ms |
| table lock | 0.03 ms |
| init | 0.07 ms |
| Optimizing | 0.05 ms |
| Statistics | 0.12 ms |
| Preparing | 0.06 ms |
| Sorting result | 0.03 ms |
| Executing | 0.02 ms |
| Sending data | 0.04 ms |
| Creating sort index | 0.07 ms |
| End of update loop | 0.02 ms |
| Query end | 0.02 ms |
| closing tables | 0.02 ms |
| Unlocking tables | 0.03 ms |
| closing tables | 0.02 ms |
| Query end | 0.02 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.10 ms |
| Updating status | 0.04 ms |
| Reset for next command | 0.04 ms |
| # | Chamador | Ficheiro e número da linha |
|---|
| 18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
| 17 | JDatabaseDriver->loadObjectList() | JROOT/components/com_k2/models/item.php:1174 |
| 16 | K2ModelItem->getItemTags() | JROOT/components/com_k2/models/item.php:98 |
| 15 | K2ModelItem->prepareItem() | Igual à chamada na linha abaixo. |
| 14 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 13 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Cache/Controller/CallbackController.php:45 |
| 12 | Joomla\CMS\Cache\Controller\CallbackController->call() | JROOT/components/com_k2/views/itemlist/view.html.php:419 |
| 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: 3.85 ms Consulta a Memória: 0.009 MB de memória antes da consulta: 11.820 MB Linhas devolvidas: 1
SELECT *
FROM pl_k2_categories
WHERE id = '42'
| 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.22 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.03 ms |
| init | 0.09 ms |
| Optimizing | 0.04 ms |
| Statistics | 0.12 ms |
| Preparing | 0.02 ms |
| Unlocking tables | 0.04 ms |
| Preparing | 0.04 ms |
| Executing | 0.02 ms |
| Sending data | 0.04 ms |
| End of update loop | 0.02 ms |
| Query end | 0.03 ms |
| closing tables | 0.02 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.02 ms |
| Query end | 0.02 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.11 ms |
| Updating status | 0.05 ms |
| Reset for next command | 0.04 ms |
| # | Chamador | Ficheiro e número da linha |
|---|
| 18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1459 |
| 17 | JDatabaseDriver->loadAssoc() | JROOT/administrator/components/com_k2/tables/k2category.php:67 |
| 16 | TableK2Category->load() | JROOT/components/com_k2/models/item.php:65 |
| 15 | K2ModelItem->prepareItem() | Igual à chamada na linha abaixo. |
| 14 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 13 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Cache/Controller/CallbackController.php:45 |
| 12 | Joomla\CMS\Cache\Controller\CallbackController->call() | JROOT/components/com_k2/views/itemlist/view.html.php:419 |
| 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.75 ms Após a última consulta: 2.71 ms Consulta a Memória: 0.009 MB de memória antes da consulta: 11.878 MB Linhas devolvidas: 1
SELECT *
FROM pl_k2_categories
WHERE id = '41'
| 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.32 ms |
| checking permissions | 0.04 ms |
| Opening tables | 0.06 ms |
| After opening tables | 0.03 ms |
| System lock | 0.03 ms |
| table lock | 0.05 ms |
| init | 0.09 ms |
| Optimizing | 0.09 ms |
| Statistics | 0.19 ms |
| Preparing | 0.03 ms |
| Unlocking tables | 0.03 ms |
| Preparing | 0.05 ms |
| Executing | 0.03 ms |
| Sending data | 0.06 ms |
| End of update loop | 0.03 ms |
| Query end | 0.03 ms |
| closing tables | 0.03 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.03 ms |
| Query end | 0.04 ms |
| Starting cleanup | 0.03 ms |
| Freeing items | 0.18 ms |
| Updating status | 0.07 ms |
| Reset for next command | 0.05 ms |
| # | Chamador | Ficheiro e número da linha |
|---|
| 18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1459 |
| 17 | JDatabaseDriver->loadAssoc() | JROOT/administrator/components/com_k2/tables/k2category.php:67 |
| 16 | TableK2Category->load() | JROOT/components/com_k2/models/item.php:85 |
| 15 | K2ModelItem->prepareItem() | Igual à chamada na linha abaixo. |
| 14 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 13 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Cache/Controller/CallbackController.php:45 |
| 12 | Joomla\CMS\Cache\Controller\CallbackController->call() | JROOT/components/com_k2/views/itemlist/view.html.php:419 |
| 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.25 ms Após a última consulta: 0.64 ms Consulta a Memória: 0.009 MB de memória antes da consulta: 11.901 MB Linhas devolvidas: 1
SELECT tag.*
FROM pl_k2_tags AS tag
JOIN pl_k2_tags_xref AS xref
ON tag.id = xref.tagID
WHERE tag.published=1
AND xref.itemID = 181
ORDER BY xref.id ASC| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | xref | ref | tagID,itemID | itemID | 4 | const | 1 | 100.00 | Using where; Filesort em utilização |
| 1 | SIMPLE | tag | eq_ref | PRIMARY,published | PRIMARY | 4 | plurales_2015.xref.tagID | 1 | 100.00 | Using where |
| Status | Duration |
|---|
| Starting | 0.19 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.06 ms |
| After opening tables | 0.02 ms |
| System lock | 0.04 ms |
| table lock | 0.03 ms |
| init | 0.05 ms |
| Optimizing | 0.04 ms |
| Statistics | 0.13 ms |
| Preparing | 0.06 ms |
| Sorting result | 0.03 ms |
| Executing | 0.02 ms |
| Sending data | 0.02 ms |
| Creating sort index | 0.12 ms |
| End of update loop | 0.02 ms |
| Query end | 0.02 ms |
| closing tables | 0.02 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.02 ms |
| Query end | 0.02 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.11 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/components/com_k2/models/item.php:1174 |
| 16 | K2ModelItem->getItemTags() | JROOT/components/com_k2/models/item.php:98 |
| 15 | K2ModelItem->prepareItem() | Igual à chamada na linha abaixo. |
| 14 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 13 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Cache/Controller/CallbackController.php:45 |
| 12 | Joomla\CMS\Cache\Controller\CallbackController->call() | JROOT/components/com_k2/views/itemlist/view.html.php:419 |
| 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.89 ms Após a última consulta: 5.00 ms Consulta a Memória: 0.011 MB de memória antes da consulta: 11.883 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
LEFT JOIN `pl_fields_categories` AS fc
ON fc.field_id = a.id
WHERE a.context = 'com_k2.itemlist'
AND (fc.category_id IS NULL OR fc.category_id IN (42,0))
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 ASC
| id | 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 |
| 1 | SIMPLE | fc | ref | PRIMARY | PRIMARY | 4 | plurales_2015.a.id | 1 | 100.00 | Using where; Using index |
| Status | Duration |
|---|
| Starting | 0.43 ms |
| checking permissions | 0.03 ms |
| Opening tables | 0.11 ms |
| After opening tables | 0.03 ms |
| System lock | 0.02 ms |
| table lock | 0.03 ms |
| init | 0.11 ms |
| Optimizing | 0.08 ms |
| Statistics | 0.22 ms |
| Preparing | 0.09 ms |
| Sorting result | 0.06 ms |
| Executing | 0.02 ms |
| Sending data | 0.04 ms |
| Creating sort index | 0.08 ms |
| End of update loop | 0.02 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| Query end | 0.02 ms |
| closing tables | 0.02 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.03 ms |
| Query end | 0.03 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.12 ms |
| Updating status | 0.04 ms |
| Reset for next command | 0.04 ms |
| # | Chamador | Ficheiro e número da linha |
|---|
| 21 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
| 20 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 |
| 19 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/administrator/components/com_fields/models/fields.php:333 |
| 18 | FieldsModelFields->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:187 |
| 17 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/administrator/components/com_fields/helpers/fields.php:135 |
| 16 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:488 |
| 15 | PlgSystemFields->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 |
| 14 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 13 | JEventDispatcher->trigger() | JROOT/components/com_k2/models/item.php:634 |
| 12 | K2ModelItem->execPlugins() | JROOT/components/com_k2/views/itemlist/view.html.php:428 |
| 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: 5.19 ms Após a última consulta: 36.89 ms Consulta a Memória: 0.010 MB de memória antes da consulta: 12.854 MB Linhas devolvidas: 7
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM pl_modules AS m
LEFT JOIN pl_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN pl_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
WHERE m.published = 1
AND e.enabled = 1
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2024-09-08 02:52:01')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-09-08 02:52:01')
AND m.access IN (1,1)
AND m.client_id = 0
AND (mm.menuid = 974 OR mm.menuid <= 0)
ORDER BY m.position, m.ordering
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | m | ALL | PRIMARY,published,newsfeeds | Nehnuma INDEX KEY pode ser utilizada | NULL | NULL | 99 | 44.44 | Using where; Filesort em utilização |
| 1 | SIMPLE | e | ref | element_clientid,element_folder_clientid | element_clientid | 403 | plurales_2015.m.module,const | 1 | 100.00 | Using index condition; Using where |
| 1 | SIMPLE | mm | ref | PRIMARY | PRIMARY | 4 | plurales_2015.m.id | 2 | 100.00 | Using where; Using index |
| Status | Duration |
|---|
| Starting | 0.56 ms |
| checking permissions | 0.04 ms |
| Opening tables | 0.10 ms |
| After opening tables | 0.04 ms |
| System lock | 0.04 ms |
| table lock | 0.03 ms |
| init | 0.11 ms |
| Optimizing | 0.14 ms |
| Statistics | 0.28 ms |
| Preparing | 0.15 ms |
| Sorting result | 0.06 ms |
| Executing | 0.03 ms |
| Sending data | 0.03 ms |
| Creating sort index | 1.86 ms |
| End of update loop | 0.03 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| Query end | 0.02 ms |
| closing tables | 0.02 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.03 ms |
| Query end | 0.04 ms |
| Starting cleanup | 0.04 ms |
| Freeing items | 0.20 ms |
| Updating status | 0.07 ms |
| Reset for next command | 0.05 ms |
| # | Chamador | Ficheiro e número da linha |
|---|
| 20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
| 19 | JDatabaseDriver->loadObjectList() | Igual à chamada na linha abaixo. |
| 18 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 17 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/ModuleHelper.php:432 |
| 16 | Joomla\CMS\Helper\ModuleHelper::getModuleList() | JROOT/libraries/src/Helper/ModuleHelper.php:362 |
| 15 | Joomla\CMS\Helper\ModuleHelper::load() | JROOT/libraries/src/Helper/ModuleHelper.php:87 |
| 14 | Joomla\CMS\Helper\ModuleHelper::getModules() | JROOT/libraries/src/Document/HtmlDocument.php:581 |
| 13 | Joomla\CMS\Document\HtmlDocument->countModules() | JROOT/templates/gk_news2/lib/framework/helper.api.php:36 |
| 12 | GKTemplateAPI->modules() | JROOT/templates/gk_news2/lib/framework/helper.layout.php:61 |
| 11 | GKTemplateLayout->generateLayoutWidths() | JROOT/templates/gk_news2/layouts/default.php:56 |
| 10 | include JROOT/templates/gk_news2/layouts/default.php | JROOT/templates/gk_news2/lib/gk.framework.php:148 |
| 9 | GKTemplate->getLayout() | JROOT/templates/gk_news2/lib/gk.framework.php:92 |
| 8 | GKTemplate->__construct() | JROOT/templates/gk_news2/index.php:25 |
| 7 | require JROOT/templates/gk_news2/index.php | JROOT/libraries/src/Document/HtmlDocument.php:658 |
| 6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:720 |
| 5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:535 |
| 4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1030 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:202 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tempo da consulta: 2.53 ms Após a última consulta: 17.77 ms Consulta a Memória: 0.008 MB de memória antes da consulta: 13.117 MB Linhas devolvidas: 1
SELECT created
FROM pl_content
WHERE state = 1
ORDER BY created DESC
LIMIT 1;
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | pl_content | ref | idx_state | idx_state | 1 | const | 1 | 100.00 | Using where; Filesort em utilização |
| Status | Duration |
|---|
| Starting | 0.36 ms |
| checking permissions | 0.04 ms |
| Opening tables | 0.08 ms |
| After opening tables | 0.04 ms |
| System lock | 0.03 ms |
| table lock | 0.04 ms |
| init | 0.08 ms |
| Optimizing | 0.09 ms |
| Statistics | 0.18 ms |
| Preparing | 0.08 ms |
| Sorting result | 0.05 ms |
| Executing | 0.03 ms |
| Sending data | 0.04 ms |
| Creating sort index | 0.16 ms |
| End of update loop | 0.04 ms |
| Query end | 0.03 ms |
| Commit | 0.03 ms |
| Query end | 0.03 ms |
| closing tables | 0.03 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.03 ms |
| Query end | 0.03 ms |
| Starting cleanup | 0.03 ms |
| Freeing items | 0.19 ms |
| Updating status | 0.06 ms |
| Reset for next command | 0.05 ms |
| # | Chamador | Ficheiro e número da linha |
|---|
| 15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1500 |
| 14 | JDatabaseDriver->loadAssocList() | JROOT/templates/gk_news2/layouts/blocks/updates.php:12 |
| 13 | gk_get_last_update() | JROOT/templates/gk_news2/layouts/blocks/updates.php:25 |
| 12 | include JROOT/templates/gk_news2/layouts/blocks/updates.php | JROOT/templates/gk_news2/lib/framework/helper.layout.php:39 |
| 11 | GKTemplateLayout->loadBlock() | JROOT/templates/gk_news2/layouts/default.php:118 |
| 10 | include JROOT/templates/gk_news2/layouts/default.php | JROOT/templates/gk_news2/lib/gk.framework.php:148 |
| 9 | GKTemplate->getLayout() | JROOT/templates/gk_news2/lib/gk.framework.php:92 |
| 8 | GKTemplate->__construct() | JROOT/templates/gk_news2/index.php:25 |
| 7 | require JROOT/templates/gk_news2/index.php | JROOT/libraries/src/Document/HtmlDocument.php:658 |
| 6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:720 |
| 5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:535 |
| 4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1030 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:202 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tempo da consulta: 1.80 ms Após a última consulta: 0.17 ms Consulta a Memória: 0.008 MB de memória antes da consulta: 13.125 MB Linhas devolvidas: 1
SELECT modified
FROM pl_content
WHERE state = 1
ORDER BY modified DESC
LIMIT 1;
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | pl_content | ref | idx_state | idx_state | 1 | const | 1 | 100.00 | Using where; Filesort em utilização |
| Status | Duration |
|---|
| Starting | 0.23 ms |
| checking permissions | 0.03 ms |
| Opening tables | 0.05 ms |
| After opening tables | 0.03 ms |
| System lock | 0.03 ms |
| table lock | 0.03 ms |
| init | 0.05 ms |
| Optimizing | 0.05 ms |
| Statistics | 0.23 ms |
| Preparing | 0.10 ms |
| Sorting result | 0.04 ms |
| Executing | 0.08 ms |
| Sending data | 0.04 ms |
| Creating sort index | 0.18 ms |
| End of update loop | 0.03 ms |
| Query end | 0.03 ms |
| Commit | 0.03 ms |
| Query end | 0.03 ms |
| closing tables | 0.03 ms |
| Unlocking tables | 0.03 ms |
| closing tables | 0.03 ms |
| Query end | 0.04 ms |
| Starting cleanup | 0.03 ms |
| Freeing items | 0.16 ms |
| Updating status | 0.11 ms |
| Reset for next command | 0.05 ms |
| # | Chamador | Ficheiro e número da linha |
|---|
| 15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1500 |
| 14 | JDatabaseDriver->loadAssocList() | JROOT/templates/gk_news2/layouts/blocks/updates.php:12 |
| 13 | gk_get_last_update() | JROOT/templates/gk_news2/layouts/blocks/updates.php:27 |
| 12 | include JROOT/templates/gk_news2/layouts/blocks/updates.php | JROOT/templates/gk_news2/lib/framework/helper.layout.php:39 |
| 11 | GKTemplateLayout->loadBlock() | JROOT/templates/gk_news2/layouts/default.php:118 |
| 10 | include JROOT/templates/gk_news2/layouts/default.php | JROOT/templates/gk_news2/lib/gk.framework.php:148 |
| 9 | GKTemplate->getLayout() | JROOT/templates/gk_news2/lib/gk.framework.php:92 |
| 8 | GKTemplate->__construct() | JROOT/templates/gk_news2/index.php:25 |
| 7 | require JROOT/templates/gk_news2/index.php | JROOT/libraries/src/Document/HtmlDocument.php:658 |
| 6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:720 |
| 5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:535 |
| 4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1030 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:202 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tempo da consulta: 1.62 ms Após a última consulta: 0.19 ms Consulta a Memória: 0.008 MB de memória antes da consulta: 13.132 MB Linhas devolvidas: 1
SELECT created
FROM pl_k2_items
WHERE published = 1
ORDER BY created DESC
LIMIT 1;
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | pl_k2_items | index | item | created | 5 | NULL | 1 | 100.00 | Using where |
| Status | Duration |
|---|
| Starting | 0.27 ms |
| checking permissions | 0.04 ms |
| Opening tables | 0.06 ms |
| After opening tables | 0.03 ms |
| System lock | 0.05 ms |
| table lock | 0.04 ms |
| init | 0.06 ms |
| Optimizing | 0.05 ms |
| Statistics | 0.16 ms |
| Preparing | 0.09 ms |
| Sorting result | 0.04 ms |
| Executing | 0.03 ms |
| Sending data | 0.13 ms |
| End of update loop | 0.03 ms |
| Query end | 0.03 ms |
| closing tables | 0.03 ms |
| Unlocking tables | 0.03 ms |
| closing tables | 0.03 ms |
| Query end | 0.03 ms |
| Starting cleanup | 0.03 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 |
|---|
| 15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1500 |
| 14 | JDatabaseDriver->loadAssocList() | JROOT/templates/gk_news2/layouts/blocks/updates.php:12 |
| 13 | gk_get_last_update() | JROOT/templates/gk_news2/layouts/blocks/updates.php:31 |
| 12 | include JROOT/templates/gk_news2/layouts/blocks/updates.php | JROOT/templates/gk_news2/lib/framework/helper.layout.php:39 |
| 11 | GKTemplateLayout->loadBlock() | JROOT/templates/gk_news2/layouts/default.php:118 |
| 10 | include JROOT/templates/gk_news2/layouts/default.php | JROOT/templates/gk_news2/lib/gk.framework.php:148 |
| 9 | GKTemplate->getLayout() | JROOT/templates/gk_news2/lib/gk.framework.php:92 |
| 8 | GKTemplate->__construct() | JROOT/templates/gk_news2/index.php:25 |
| 7 | require JROOT/templates/gk_news2/index.php | JROOT/libraries/src/Document/HtmlDocument.php:658 |
| 6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:720 |
| 5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:535 |
| 4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1030 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:202 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tempo da consulta: 69.12 ms Após a última consulta: 0.17 ms Consulta a Memória: 0.008 MB de memória antes da consulta: 13.140 MB Linhas devolvidas: 1
SELECT modified
FROM pl_k2_items
WHERE published = 1
ORDER BY modified DESC
LIMIT 1;
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | pl_k2_items | ref | item | item | 2 | const | 2085 | 100.00 | Using where; Filesort em utilização |
| Status | Duration |
|---|
| Starting | 0.26 ms |
| checking permissions | 0.03 ms |
| Opening tables | 0.05 ms |
| After opening tables | 0.03 ms |
| System lock | 0.03 ms |
| table lock | 0.03 ms |
| init | 0.05 ms |
| Optimizing | 0.05 ms |
| Statistics | 0.11 ms |
| Preparing | 0.06 ms |
| Sorting result | 0.04 ms |
| Executing | 0.03 ms |
| Sending data | 0.03 ms |
| Creating sort index | 66.99 ms |
| End of update loop | 0.11 ms |
| Query end | 0.03 ms |
| closing tables | 0.03 ms |
| Unlocking tables | 0.03 ms |
| closing tables | 0.06 ms |
| Query end | 0.05 ms |
| Starting cleanup | 0.05 ms |
| Freeing items | 0.24 ms |
| Updating status | 0.07 ms |
| Reset for next command | 0.06 ms |
| # | Chamador | Ficheiro e número da linha |
|---|
| 15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1500 |
| 14 | JDatabaseDriver->loadAssocList() | JROOT/templates/gk_news2/layouts/blocks/updates.php:12 |
| 13 | gk_get_last_update() | JROOT/templates/gk_news2/layouts/blocks/updates.php:34 |
| 12 | include JROOT/templates/gk_news2/layouts/blocks/updates.php | JROOT/templates/gk_news2/lib/framework/helper.layout.php:39 |
| 11 | GKTemplateLayout->loadBlock() | JROOT/templates/gk_news2/layouts/default.php:118 |
| 10 | include JROOT/templates/gk_news2/layouts/default.php | JROOT/templates/gk_news2/lib/gk.framework.php:148 |
| 9 | GKTemplate->getLayout() | JROOT/templates/gk_news2/lib/gk.framework.php:92 |
| 8 | GKTemplate->__construct() | JROOT/templates/gk_news2/index.php:25 |
| 7 | require JROOT/templates/gk_news2/index.php | JROOT/libraries/src/Document/HtmlDocument.php:658 |
| 6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:720 |
| 5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:535 |
| 4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1030 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:202 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tempo da consulta: 6.34 ms Após a última consulta: 34.69 ms Consulta a Memória: 0.007 MB de memória antes da consulta: 13.538 MB Linhas devolvidas: 1
SELECT
c.id AS CID
FROM
pl_k2_categories AS c
LEFT JOIN
pl_k2_items AS content
ON
c.id = content.catid
WHERE
( c.id = 107 )
AND
c.published = 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | c | const | PRIMARY,category,published | PRIMARY | 4 | const | 1 | 100.00 | |
| 1 | SIMPLE | content | ref | catid | catid | 4 | const | 2 | 100.00 | Using index |
| Status | Duration |
|---|
| Starting | 0.77 ms |
| checking permissions | 0.03 ms |
| Opening tables | 0.08 ms |
| After opening tables | 0.03 ms |
| System lock | 3.40 ms |
| table lock | 0.06 ms |
| init | 0.31 ms |
| Optimizing | 0.06 ms |
| Statistics | 0.23 ms |
| Preparing | 0.03 ms |
| Unlocking tables | 0.03 ms |
| Preparing | 0.06 ms |
| Executing | 0.04 ms |
| Sending data | 0.26 ms |
| End of update loop | 0.03 ms |
| Query end | 0.02 ms |
| closing tables | 0.02 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.03 ms |
| Query end | 0.03 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.22 ms |
| Updating status | 0.08 ms |
| Reset for next command | 0.05 ms |
| # | Chamador | Ficheiro e número da linha |
|---|
| 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
| 13 | JDatabaseDriver->loadObjectList() | JROOT/modules/mod_highlighter_gk5/gk_classes/gk.source.k2.php:76 |
| 12 | NH_GK5_K2_Source::getSources() | JROOT/modules/mod_highlighter_gk5/helper.php:102 |
| 11 | NH_GK5_Helper->getDatas() | JROOT/modules/mod_highlighter_gk5/mod_highlighter_gk5.php:21 |
| 10 | include JROOT/modules/mod_highlighter_gk5/mod_highlighter_gk5.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
| 9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
| 8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
| 7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:491 |
| 6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:783 |
| 5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
| 4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1044 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:202 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tempo da consulta: 2.16 ms Após a última consulta: 0.32 ms Consulta a Memória: 0.007 MB de memória antes da consulta: 13.547 MB Linhas devolvidas: 1
SELECT
content.id AS id,
content.alias AS alias,
content.title AS title,
content.introtext AS text,
content.created AS date,
content.publish_up AS date_publish,
content.hits AS hits,
content.featured AS frontpage
FROM
pl_k2_items AS content
WHERE
content.published = 1
AND
content.trash = 0
AND content.access IN (1,1)
AND ( content.publish_up = '0000-00-00 00:00:00' OR content.publish_up <= '2024-09-08 02:52:01' )
AND ( content.publish_down = '0000-00-00 00:00:00' OR content.publish_down >= '2024-09-08 02:52:01' )
AND ( content.catid = 107 )
ORDER BY
content.created DESC
LIMIT
0,1;
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | content | ref | item,catid | catid | 4 | const | 2 | 99.62 | Using where; Filesort em utilização |
| Status | Duration |
|---|
| Starting | 0.45 ms |
| checking permissions | 0.04 ms |
| Opening tables | 0.08 ms |
| After opening tables | 0.03 ms |
| System lock | 0.02 ms |
| table lock | 0.03 ms |
| init | 0.09 ms |
| Optimizing | 0.09 ms |
| Statistics | 0.18 ms |
| Preparing | 0.10 ms |
| Sorting result | 0.05 ms |
| Executing | 0.03 ms |
| Sending data | 0.04 ms |
| Creating sort index | 0.23 ms |
| End of update loop | 0.03 ms |
| Query end | 0.02 ms |
| closing tables | 0.05 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.03 ms |
| Query end | 0.03 ms |
| Starting cleanup | 0.03 ms |
| Freeing items | 0.18 ms |
| Updating status | 0.07 ms |
| Reset for next command | 0.05 ms |
| # | Chamador | Ficheiro e número da linha |
|---|
| 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1500 |
| 13 | JDatabaseDriver->loadAssocList() | JROOT/modules/mod_highlighter_gk5/gk_classes/gk.source.k2.php:211 |
| 12 | NH_GK5_K2_Source::getArticles() | JROOT/modules/mod_highlighter_gk5/helper.php:104 |
| 11 | NH_GK5_Helper->getDatas() | JROOT/modules/mod_highlighter_gk5/mod_highlighter_gk5.php:21 |
| 10 | include JROOT/modules/mod_highlighter_gk5/mod_highlighter_gk5.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
| 9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
| 8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
| 7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:491 |
| 6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:783 |
| 5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
| 4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1044 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:202 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tempo da consulta: 1.95 ms Após a última consulta: 0.14 ms Consulta a Memória: 0.007 MB de memória antes da consulta: 13.557 MB Linhas devolvidas: 1
SELECT
content.id AS id,
content.access AS access,
content.catid AS cid,
categories.name AS catname,
categories.alias AS cat_alias,
users.email AS author_email,
content.created_by_alias AS author_alias,
content.created_by AS author_id,
content_rating.rating_sum AS rating_sum,
content_rating.rating_count AS rating_count
FROM
pl_k2_items AS content
LEFT JOIN
pl_k2_categories AS categories
ON categories.id = content.catid
LEFT JOIN
pl_users AS users
ON users.id = content.created_by
LEFT JOIN
pl_k2_rating AS content_rating
ON content_rating.itemID = content.id
WHERE
content.id = 2747
ORDER BY
content.created DESC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | content | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | |
| 1 | SIMPLE | categories | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | |
| 1 | SIMPLE | users | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | |
| 1 | SIMPLE | content_rating | const | PRIMARY | PRIMARY | 4 | const | 0 | 0.00 | Unique row not found |
| Status | Duration |
|---|
| Starting | 0.35 ms |
| checking permissions | 0.03 ms |
| Opening tables | 0.09 ms |
| After opening tables | 0.03 ms |
| System lock | 0.03 ms |
| table lock | 0.04 ms |
| init | 0.08 ms |
| Optimizing | 0.07 ms |
| Statistics | 0.29 ms |
| Preparing | 0.03 ms |
| Unlocking tables | 0.08 ms |
| Preparing | 0.05 ms |
| Executing | 0.03 ms |
| Sending data | 0.08 ms |
| End of update loop | 0.03 ms |
| Query end | 0.03 ms |
| Commit | 0.03 ms |
| Query end | 0.03 ms |
| closing tables | 0.03 ms |
| Unlocking tables | 0.03 ms |
| closing tables | 0.04 ms |
| Query end | 0.04 ms |
| Starting cleanup | 0.03 ms |
| Freeing items | 0.16 ms |
| Updating status | 20.99 ms |
| Reset for next command | 0.09 ms |
| # | Chamador | Ficheiro e número da linha |
|---|
| 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1500 |
| 13 | JDatabaseDriver->loadAssocList() | JROOT/modules/mod_highlighter_gk5/gk_classes/gk.source.k2.php:255 |
| 12 | NH_GK5_K2_Source::getArticles() | JROOT/modules/mod_highlighter_gk5/helper.php:104 |
| 11 | NH_GK5_Helper->getDatas() | JROOT/modules/mod_highlighter_gk5/mod_highlighter_gk5.php:21 |
| 10 | include JROOT/modules/mod_highlighter_gk5/mod_highlighter_gk5.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
| 9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
| 8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
| 7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:491 |
| 6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:783 |
| 5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
| 4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1044 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:202 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
4 × SELECT *
FROM pl_k2_categories
4 × SELECT tag.*
FROM pl_k2_tags AS tag JOIN pl_k2_tags_xref AS xref
ON tag.id = xref.tagID
2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `pl_extensions`
2 × 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
LEFT JOIN `pl_fields_categories` AS fc
ON fc.field_id = a.id
2 × SELECT id, gender, description, image, url, `
group`, plugins
FROM pl_k2_users
1 × SELECT `data`
FROM `pl_session`
1 × SELECT content.id AS id, content.alias AS alias, content.title AS title, content.introtext AS text, content.created AS date, content.publish_up AS date_publish, content.hits AS hits, content.featured AS frontpage
FROM pl_k2_items AS content
1 × SELECT c.id AS CID
FROM pl_k2_categories AS c
LEFT JOIN pl_k2_items AS content
ON c.id = content.catid
1 × SELECT modified
FROM pl_k2_items
1 × SELECT created
FROM pl_k2_items
1 × SELECT modified
FROM pl_content
1 × SELECT created
FROM pl_content
1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM pl_modules AS m
LEFT JOIN pl_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN pl_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
1 × SELECT id, name, parent
FROM pl_k2_categories
1 × SELECT i.*, c.name as categoryname,c.id as categoryid, c.alias as categoryalias, c.params as categoryparams
FROM pl_k2_items as i RIGHT JOIN pl_k2_categories AS c
ON c.id = i.catid
1 × SELECT COUNT(*)
FROM pl_k2_items as i RIGHT JOIN pl_k2_categories c
ON c.id = i.catid
1 × SELECT `session_id`
FROM `pl_session`
1 × SELECT `g`.`id`,`g`.`title`
FROM `pl_usergroups` AS g
INNER JOIN `pl_user_usergroup_map` AS m
ON m.group_id = g.id
1 × SELECT *
FROM `pl_users`
1 × SELECT id
FROM pl_k2_categories
1 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `pl_assets`
1 × 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
1 × SELECT *
FROM pl_languages
1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM pl_menu AS m
LEFT JOIN pl_extensions AS e
ON m.component_id = e.extension_id
1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM pl_extensions
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
1 × SELECT id, rules
FROM `pl_viewlevels
1 × SELECT content.id AS id, content.access AS access, content.catid AS cid, categories.name AS catname, categories.alias AS cat_alias, users.email AS author_email, content.created_by_alias AS author_alias, content.created_by AS author_id, content_rating.rating_sum AS rating_sum, content_rating.rating_count AS rating_count
FROM pl_k2_items AS content
LEFT JOIN pl_k2_categories AS categories
ON categories.id = content.catid
LEFT JOIN pl_users AS users
ON users.id = content.created_by
LEFT JOIN pl_k2_rating AS content_rating
ON content_rating.itemID = content.id
O programa “Beato Solidário”, da Junta de Freguesia do Beato, em Lisboa, já com mais de uma centena de inscritos no serviço de transporte, sendo que também visa apoiar pessoas com deficiência.
“Caminhar Ajuda” é o nome da ação agendada para amanhã no Parque de Monsanto, em Lisboa, promovida pelo IPAM e que visa apoiar a CERCI Lisboa.
A Associação de Pais e Amigos de Deficientes Profundos da Amadora vai levar a cabo segunda-feira, a 1.ª Corrida “Amorama em Marcha” que visa uma recolha de fundos.
