{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1725786643,
                "last": 1725786643,
                "now": 1725786643
            },
            "token": "NzjYXTZEF0S5nsxifN6VpK9xrWdRnbtt"
        },
        "registry": {},
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        }
    }
}

Hora

Memória

47 pedidos registados 150.06 ms

1. Tempo da consulta: 1.88 ms Consulta a Memória: 0.007 MB de memória antes da consulta: 3.851 MB Linhas devolvidas: 0

   SELECT `data`
   
     FROM `pl_session`
   
     WHERE `session_id` = '739228aa44434cc7ff9c65704923025c'

   Explica

   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

   Perfil

   Status	Duration
   Starting	0.41 ms
   checking permissions	0.04 ms
   Opening tables	0.07 ms
   After opening tables	0.05 ms
   System lock	0.03 ms
   table lock	0.06 ms
   init	0.08 ms
   Optimizing	0.05 ms
   Statistics	0.17 ms
   Preparing	0.04 ms
   Executing	0.05 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.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.10 ms

   Chamada de dados

   #	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

   [Adiciona a diretiva xdebug.file_link_format ao teu ficheiro php.ini para ter ligações para ficheiros]

   ---

2. Tempo da consulta: 1.80 ms Após a última consulta: 3.93 ms Consulta a Memória: 0.004 MB de memória antes da consulta: 4.009 MB Linhas devolvidas: 0

   SELECT `session_id`
   
     FROM `pl_session`
   
     WHERE `session_id` = '739228aa44434cc7ff9c65704923025c' 
     LIMIT 1

   Explica

   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

   Perfil

   Status	Duration
   Starting	0.39 ms
   checking permissions	0.04 ms
   Opening tables	0.07 ms
   After opening tables	0.03 ms
   System lock	0.04 ms
   table lock	0.04 ms
   init	0.07 ms
   Optimizing	0.05 ms
   Statistics	0.18 ms
   Preparing	0.04 ms
   Executing	0.05 ms
   End of update loop	0.03 ms
   Query end	0.03 ms
   Commit	0.04 ms
   Query end	0.05 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.17 ms
   Updating status	0.07 ms
   Reset for next command	0.05 ms

   Chamada de dados

   #	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

   [Adiciona a diretiva xdebug.file_link_format ao teu ficheiro php.ini para ter ligações para ficheiros]

   ---

3. Tempo da consulta: 3.74 ms Após a última consulta: 0.30 ms Consulta a Memória: 0.004 MB de memória antes da consulta: 4.014 MB

   INSERT INTO `pl_session`
   (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES 
   ('739228aa44434cc7ff9c65704923025c', 1, 1725786643, 0, '', 0)

   Explica

   EXPLAIN não é possível na consulta: INSERT INTO `pl_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('739228aa44434cc7ff9c65704923025c', 1, 1725786643, 0, '', 0)

   Perfil

   Status	Duration
   Starting	0.52 ms
   checking permissions	0.05 ms
   Opening tables	1.05 ms
   After opening tables	0.03 ms
   System lock	0.03 ms
   table lock	0.03 ms
   init for update	0.05 ms
   Update	0.20 ms
   Waiting for query cache lock	0.03 ms
   Update	0.06 ms
   End of update loop	0.03 ms
   Query end	0.03 ms
   Commit	1.05 ms
   Query end	0.03 ms
   closing tables	0.02 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

   Chamada de dados

   #	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

   [Adiciona a diretiva xdebug.file_link_format ao teu ficheiro php.ini para ter ligações para ficheiros]

   ---

4. Tempo da consulta: 2.41 ms Após a última consulta: 8.11 ms Consulta a Memória: 0.006 MB de memória antes da consulta: 4.229 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

   Explica

   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

   Perfil

   Status	Duration
   Starting	0.43 ms
   checking permissions	0.04 ms
   Opening tables	0.08 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.20 ms
   Preparing	0.09 ms
   Executing	0.03 ms
   Sending data	0.41 ms
   End of update loop	0.04 ms
   Query end	0.05 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.04 ms
   Starting cleanup	0.03 ms
   Freeing items	0.20 ms
   Updating status	0.08 ms
   Reset for next command	0.06 ms

   Chamada de dados

   #	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

   [Adiciona a diretiva xdebug.file_link_format ao teu ficheiro php.ini para ter ligações para ficheiros]

   ---

5. Tempo da consulta: 2.28 ms Após a última consulta: 7.43 ms Consulta a Memória: 0.005 MB de memória antes da consulta: 4.432 MB Linhas devolvidas: 3

   SELECT id, rules
   
     FROM `pl_viewlevels`

   Explica

   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

   Perfil

   Status	Duration
   Starting	0.51 ms
   checking permissions	0.05 ms
   Opening tables	0.09 ms
   After opening tables	0.05 ms
   System lock	0.04 ms
   table lock	0.05 ms
   init	0.09 ms
   Optimizing	0.05 ms
   Statistics	0.07 ms
   Preparing	0.11 ms
   Executing	0.04 ms
   Sending data	0.15 ms
   End of update loop	0.09 ms
   Query end	0.04 ms
   Commit	0.04 ms
   Query end	0.04 ms
   closing tables	0.04 ms
   Unlocking tables	0.03 ms
   closing tables	0.04 ms
   Query end	0.04 ms
   Starting cleanup	0.05 ms
   Freeing items	0.23 ms
   Updating status	0.09 ms
   Reset for next command	0.11 ms

   Chamada de dados

   #	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

   [Adiciona a diretiva xdebug.file_link_format ao teu ficheiro php.ini para ter ligações para ficheiros]

   ---

6. Tempo da consulta: 2.29 ms Após a última consulta: 0.27 ms Consulta a Memória: 0.005 MB de memória antes da consulta: 4.443 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

   Explica

   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

   Perfil

   Status	Duration
   Starting	0.36 ms
   checking permissions	0.04 ms
   Opening tables	0.07 ms
   After opening tables	0.05 ms
   System lock	0.04 ms
   table lock	0.09 ms
   init	0.09 ms
   Optimizing	0.08 ms
   Statistics	0.24 ms
   Preparing	0.04 ms
   Unlocking tables	0.04 ms
   Preparing	0.09 ms
   Executing	0.04 ms
   Sending data	0.11 ms
   End of update loop	0.05 ms
   Query end	0.04 ms
   Commit	0.04 ms
   Query end	0.04 ms
   closing tables	0.07 ms
   Unlocking tables	0.03 ms
   closing tables	0.04 ms
   Query end	0.05 ms
   Starting cleanup	0.04 ms
   Freeing items	0.26 ms
   Updating status	0.09 ms
   Reset for next command	0.06 ms

   Chamada de dados

   #	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

   [Adiciona a diretiva xdebug.file_link_format ao teu ficheiro php.ini para ter ligações para ficheiros]

   ---

7. Tempo da consulta: 2.96 ms Após a última consulta: 1.96 ms Consulta a Memória: 0.005 MB de memória antes da consulta: 4.512 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

   Explica

   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

   Perfil

   Status	Duration
   Starting	0.42 ms
   checking permissions	0.05 ms
   Opening tables	0.07 ms
   After opening tables	0.07 ms
   System lock	0.04 ms
   table lock	0.04 ms
   init	0.11 ms
   Optimizing	0.09 ms
   Statistics	0.12 ms
   Preparing	0.06 ms
   Sorting result	0.03 ms
   Executing	0.03 ms
   Sending data	0.04 ms
   Creating sort index	0.99 ms
   End of update loop	0.04 ms
   Query end	0.03 ms
   Commit	0.03 ms
   Query end	0.02 ms
   closing tables	0.03 ms
   Unlocking tables	0.06 ms
   closing tables	0.04 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.04 ms

   Chamada de dados

   #	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

   [Adiciona a diretiva xdebug.file_link_format ao teu ficheiro php.ini para ter ligações para ficheiros]

   ---

8. Tempo da consulta: 2.65 ms Após a última consulta: 53.32 ms Consulta a Memória: 0.009 MB de memória antes da consulta: 6.667 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

   Explica

   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

   Perfil

   Status	Duration
   Starting	0.39 ms
   checking permissions	0.03 ms
   Opening tables	0.08 ms
   After opening tables	0.03 ms
   System lock	0.02 ms
   table lock	0.03 ms
   init	0.08 ms
   Optimizing	0.07 ms
   Statistics	0.14 ms
   Preparing	0.06 ms
   Sorting result	0.03 ms
   Executing	0.02 ms
   Sending data	0.04 ms
   Creating sort index	1.06 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.02 ms
   Query end	0.03 ms
   Starting cleanup	0.02 ms
   Freeing items	0.13 ms
   Updating status	0.05 ms
   Reset for next command	0.04 ms

   Chamada de dados

   #	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

   [Adiciona a diretiva xdebug.file_link_format ao teu ficheiro php.ini para ter ligações para ficheiros]

   ---

9. Tempo da consulta: 2.07 ms Após a última consulta: 26.14 ms Consulta a Memória: 0.009 MB de memória antes da consulta: 7.660 MB Linhas devolvidas: 1

   SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
   
     FROM `pl_extensions`
   
     WHERE `type` = 'library' 
     AND `element` = 'joomla'

   Explica

   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

   Perfil

   Status	Duration
   Starting	0.44 ms
   checking permissions	0.06 ms
   Opening tables	0.07 ms
   After opening tables	0.03 ms
   System lock	0.03 ms
   table lock	0.04 ms
   init	0.09 ms
   Optimizing	0.06 ms
   Statistics	0.21 ms
   Preparing	0.10 ms
   Executing	0.03 ms
   Sending data	0.17 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.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.17 ms
   Updating status	0.06 ms
   Reset for next command	0.05 ms

   Chamada de dados

   #	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

   [Adiciona a diretiva xdebug.file_link_format ao teu ficheiro php.ini para ter ligações para ficheiros]

   ---

10. Tempo da consulta: 2.60 ms Após a última consulta: 0.48 ms Consulta a Memória: 0.006 MB de memória antes da consulta: 7.653 MB

    UPDATE `pl_extensions`
    
      SET `params` = '{\"mediaversion\":\"9d31f1c3ae549ab4e5236466bd3f1d4d\"}'
    
      WHERE `type` = 'library' 
      AND `element` = 'joomla'

    Explica

    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

    Perfil

    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 for update	0.15 ms
    Updating	0.27 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	1.11 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.17 ms
    Updating status	0.06 ms
    Reset for next command	0.04 ms

    Chamada de dados

    #	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

    [Adiciona a diretiva xdebug.file_link_format ao teu ficheiro php.ini para ter ligações para ficheiros]

    ---

11. Tempo da consulta: 1.26 ms Após a última consulta: 8.33 ms Consulta a Memória: 0.006 MB de memória antes da consulta: 7.989 MB Linhas devolvidas: 1

    SELECT *
    
      FROM pl_languages
    
      WHERE published=1
    
      ORDER BY ordering ASC

    Explica

    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

    Perfil

    Status	Duration
    Starting	0.24 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.02 ms
    init	0.06 ms
    Optimizing	0.04 ms
    Statistics	0.05 ms
    Preparing	0.04 ms
    Sorting result	0.03 ms
    Executing	0.02 ms
    Sending data	0.03 ms
    Creating sort index	0.10 ms
    End of update loop	0.02 ms
    Query end	0.02 ms
    Commit	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.02 ms
    Starting cleanup	0.02 ms
    Freeing items	0.10 ms
    Updating status	0.07 ms
    Reset for next command	0.03 ms

    Chamada de dados

    #	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

    [Adiciona a diretiva xdebug.file_link_format ao teu ficheiro php.ini para ter ligações para ficheiros]

    ---

12. Tempo da consulta: 2.87 ms Após a última consulta: 5.26 ms Consulta a Memória: 0.009 MB de memória antes da consulta: 8.292 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

    Explica

    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)

    Perfil

    Status	Duration
    Starting	0.52 ms
    checking permissions	0.05 ms
    Opening tables	0.10 ms
    After opening tables	0.05 ms
    System lock	0.05 ms
    table lock	0.05 ms
    init	0.12 ms
    Optimizing	0.11 ms
    Statistics	0.30 ms
    Preparing	0.18 ms
    Executing	0.04 ms
    Sending data	0.30 ms
    End of update loop	0.05 ms
    Query end	0.04 ms
    Commit	0.04 ms
    Query end	0.04 ms
    closing tables	0.04 ms
    Unlocking tables	0.04 ms
    closing tables	0.05 ms
    Query end	0.05 ms
    Starting cleanup	0.08 ms
    Freeing items	0.28 ms
    Updating status	0.09 ms
    Reset for next command	0.07 ms

    Chamada de dados

    #	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

    [Adiciona a diretiva xdebug.file_link_format ao teu ficheiro php.ini para ter ligações para ficheiros]

    ---

13. Tempo da consulta: 2.65 ms Após a última consulta: 6.21 ms Consulta a Memória: 0.006 MB de memória antes da consulta: 8.422 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')

    Explica

    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

    Perfil

    Status	Duration
    Starting	0.43 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.18 ms
    Optimizing	0.12 ms
    Statistics	0.26 ms
    Preparing	0.06 ms
    Executing	0.03 ms
    Sending data	0.57 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.06 ms
    Starting cleanup	0.03 ms
    Freeing items	0.15 ms
    Updating status	0.07 ms
    Reset for next command	0.04 ms

    Chamada de dados

    #	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

    [Adiciona a diretiva xdebug.file_link_format ao teu ficheiro php.ini para ter ligações para ficheiros]

    ---

14. Tempo da consulta: 2.10 ms Após a última consulta: 21.32 ms Consulta a Memória: 0.007 MB de memória antes da consulta: 9.420 MB Linhas devolvidas: 98

    SELECT id 
      FROM pl_k2_categories 
      WHERE published=1 
      AND trash=0 
      AND access IN(1,1)

    Explica

    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

    Perfil

    Status	Duration
    Starting	0.37 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.07 ms
    Optimizing	0.06 ms
    Statistics	0.16 ms
    Preparing	0.07 ms
    Executing	0.02 ms
    Sending data	0.46 ms
    End of update loop	0.06 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.15 ms
    Updating status	0.05 ms
    Reset for next command	0.04 ms

    Chamada de dados

    #	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

    [Adiciona a diretiva xdebug.file_link_format ao teu ficheiro php.ini para ter ligações para ficheiros]

    ---

15. Tempo da consulta: 3.24 ms Após a última consulta: 1.77 ms Consulta a Memória: 0.009 MB de memória antes da consulta: 9.460 MB Linhas devolvidas: 14

    SHOW FULL COLUMNS 
      FROM `pl_k2_categories`

    Explica

    EXPLAIN não é possível na consulta: SHOW FULL COLUMNS FROM `pl_k2_categories`

    Perfil

    Status	Duration
    Starting	0.21 ms
    checking permissions	0.03 ms
    closing tables	0.02 ms
    checking permissions	0.02 ms
    Opening tables	1.04 ms
    After opening tables	0.06 ms
    System lock	0.03 ms
    table lock	0.03 ms
    init	0.04 ms
    Optimizing	0.03 ms
    Statistics	0.04 ms
    Preparing	0.06 ms
    Executing	0.03 ms
    Filling schema table	0.03 ms
    Opening tables	0.05 ms
    After opening tables	0.02 ms
    checking permissions	0.18 ms
    closing tables	0.03 ms
    checking permissions	0.03 ms
    Executing	0.02 ms
    Sending data	0.08 ms
    End of update loop	0.03 ms
    Query end	0.02 ms
    closing tables	0.11 ms
    Removing tmp table	0.52 ms
    closing tables	0.03 ms
    Unlocking tables	0.02 ms
    closing tables	0.02 ms
    Query end	0.02 ms
    Starting cleanup	0.03 ms
    Freeing items	0.14 ms
    Updating status	0.06 ms
    Reset for next command	0.04 ms

    Chamada de dados

    #	Chamador	Ficheiro e número da linha
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    17	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
    16	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
    15	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
    14	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_k2/tables/k2category.php:36
    13	TableK2Category->__construct()	JROOT/libraries/src/Table/Table.php:312
    12	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_k2/views/itemlist/view.html.php:40
    11	K2ViewItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:19
    9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:45
    8	K2ControllerItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
    6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Adiciona a diretiva xdebug.file_link_format ao teu ficheiro php.ini para ter ligações para ficheiros]

    ---

16. Tempo da consulta: 2.24 ms Após a última consulta: 1.57 ms Consulta a Memória: 0.007 MB de memória antes da consulta: 9.502 MB Linhas devolvidas: 1

    SELECT * 
      FROM pl_k2_categories 
      WHERE id = '38'

    Explica

    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

    Perfil

    Status	Duration
    Starting	0.83 ms
    checking permissions	0.04 ms
    Opening tables	0.06 ms
    After opening tables	0.04 ms
    System lock	0.03 ms
    table lock	0.04 ms
    init	0.10 ms
    Optimizing	0.06 ms
    Statistics	0.16 ms
    Preparing	0.03 ms
    Unlocking tables	0.04 ms
    Preparing	0.05 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.04 ms
    Query end	0.06 ms
    Starting cleanup	0.04 ms
    Freeing items	0.17 ms
    Updating status	0.07 ms
    Reset for next command	0.06 ms

    Chamada de dados

    #	Chamador	Ficheiro e número da linha
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1459
    13	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_k2/tables/k2category.php:67
    12	TableK2Category->load()	JROOT/components/com_k2/views/itemlist/view.html.php:41
    11	K2ViewItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:19
    9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:45
    8	K2ControllerItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
    6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Adiciona a diretiva xdebug.file_link_format ao teu ficheiro php.ini para ter ligações para ficheiros]

    ---

17. Tempo da consulta: 2.40 ms Após a última consulta: 16.72 ms Consulta a Memória: 0.010 MB de memória antes da consulta: 10.114 MB Linhas devolvidas: 0

    SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
    
      FROM pl_fields AS a
    
      LEFT JOIN `pl_languages` AS l 
      ON l.lang_code = a.language
    
      LEFT JOIN pl_users AS uc 
      ON uc.id=a.checked_out
    
      LEFT JOIN pl_viewlevels AS ag 
      ON ag.id = a.access
    
      LEFT JOIN pl_users AS ua 
      ON ua.id = a.created_user_id
    
      LEFT JOIN pl_fields_groups AS g 
      ON g.id = a.group_id
    
      WHERE a.context = 'com_k2.category' 
      AND a.access IN (1,1) 
      AND (a.group_id = 0 OR g.access IN (1,1)) 
      AND a.state = 1 
      AND (a.group_id = 0 OR g.state = 1)
    
      ORDER BY a.ordering ASC

    Explica

    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

    Perfil

    Status	Duration
    Starting	0.53 ms
    checking permissions	0.03 ms
    Opening tables	0.16 ms
    After opening tables	0.03 ms
    System lock	0.03 ms
    table lock	0.03 ms
    init	0.13 ms
    Optimizing	0.10 ms
    Statistics	0.23 ms
    Preparing	0.10 ms
    Sorting result	0.07 ms
    Executing	0.02 ms
    Sending data	0.05 ms
    Creating sort index	0.10 ms
    End of update loop	0.03 ms
    Query end	0.02 ms
    Commit	0.04 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.15 ms
    Updating status	0.05 ms
    Reset for next command	0.06 ms

    Chamada de dados

    #	Chamador	Ficheiro e número da linha
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    19	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    18	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
    17	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
    16	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:135
    15	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:488
    14	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    12	JEventDispatcher->trigger()	JROOT/components/com_k2/views/itemlist/view.html.php:118
    11	K2ViewItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:19
    9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:45
    8	K2ControllerItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
    6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Adiciona a diretiva xdebug.file_link_format ao teu ficheiro php.ini para ter ligações para ficheiros]

    ---

18. Tempo da consulta: 3.27 ms Após a última consulta: 9.55 ms Consulta a Memória: 0.007 MB de memória antes da consulta: 10.434 MB Linhas devolvidas: 6

    SELECT * 
      FROM pl_k2_categories 
      WHERE parent=38 
      AND published=1 
      AND trash=0 
      AND access IN(1,1)  
      ORDER BY  id ASC

    Explica

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	pl_k2_categories	ref	category,parent,published,access,trash	parent	5	const	5	78.15	Using where; Filesort em utilização

    Perfil

    Status	Duration
    Starting	0.49 ms
    checking permissions	0.04 ms
    Opening tables	0.11 ms
    After opening tables	0.04 ms
    System lock	0.04 ms
    table lock	0.05 ms
    init	0.15 ms
    Optimizing	0.09 ms
    Statistics	0.30 ms
    Preparing	0.12 ms
    Sorting result	0.06 ms
    Executing	0.04 ms
    Sending data	0.12 ms
    Creating sort index	0.73 ms
    End of update loop	0.04 ms
    Query end	0.03 ms
    closing tables	0.03 ms
    Unlocking tables	0.03 ms
    closing tables	0.08 ms
    Query end	0.04 ms
    Starting cleanup	0.04 ms
    Freeing items	0.26 ms
    Updating status	0.08 ms
    Reset for next command	0.07 ms

    Chamada de dados

    #	Chamador	Ficheiro e número da linha
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    13	JDatabaseDriver->loadObjectList()	JROOT/components/com_k2/models/itemlist.php:657
    12	K2ModelItemlist->getCategoryFirstChildren()	JROOT/components/com_k2/views/itemlist/view.html.php:152
    11	K2ViewItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:19
    9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:45
    8	K2ControllerItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
    6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Adiciona a diretiva xdebug.file_link_format ao teu ficheiro php.ini para ter ligações para ficheiros]

    ---

19. Tempo da consulta: 2.40 ms Após a última consulta: 3.98 ms Consulta a Memória: 0.007 MB de memória antes da consulta: 10.522 MB Linhas devolvidas: 6

    SELECT id
                            
      FROM pl_k2_categories
                            
      WHERE parent IN (38)
                            
      AND id NOT IN (38) 
                                    
      AND published=1
                                    
      AND trash=0 
      AND access IN(1,1)

    Explica

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	pl_k2_categories	ref	PRIMARY,category,parent,published,access,trash	parent	5	const	5	78.15	Using where

    Perfil

    Status	Duration
    Starting	0.45 ms
    checking permissions	0.05 ms
    Opening tables	0.08 ms
    After opening tables	0.07 ms
    System lock	0.04 ms
    table lock	0.05 ms
    init	0.09 ms
    Optimizing	0.09 ms
    Statistics	0.27 ms
    Preparing	0.11 ms
    Executing	0.03 ms
    Sending data	0.37 ms
    End of update loop	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.21 ms
    Updating status	0.07 ms
    Reset for next command	0.06 ms

    Chamada de dados

    #	Chamador	Ficheiro e número da linha
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1544
    14	JDatabaseDriver->loadColumn()	JROOT/components/com_k2/models/itemlist.php:563
    13	K2ModelItemlist->getCategoryTree()	JROOT/components/com_k2/models/itemlist.php:109
    12	K2ModelItemlist->getData()	JROOT/components/com_k2/views/itemlist/view.html.php:351
    11	K2ViewItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:19
    9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:45
    8	K2ControllerItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
    6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Adiciona a diretiva xdebug.file_link_format ao teu ficheiro php.ini para ter ligações para ficheiros]

    ---

20. Tempo da consulta: 2.15 ms Após a última consulta: 0.15 ms Consulta a Memória: 0.007 MB de memória antes da consulta: 10.529 MB Linhas devolvidas: 0

    SELECT id
                            
      FROM pl_k2_categories
                            
      WHERE parent IN (5,6,7,32,33,34)
                            
      AND id NOT IN (5,6,7,32,33,34) 
                                    
      AND published=1
                                    
      AND trash=0 
      AND access IN(1,1)

    Explica

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	pl_k2_categories	range	PRIMARY,category,parent,published,access,trash	parent	5	NULL	6	78.15	Using index condition; Using where

    Perfil

    Status	Duration
    Starting	0.36 ms
    checking permissions	0.04 ms
    Opening tables	0.06 ms
    After opening tables	0.04 ms
    System lock	0.04 ms
    table lock	0.04 ms
    init	0.08 ms
    Optimizing	0.08 ms
    Statistics	0.45 ms
    Preparing	0.11 ms
    Executing	0.04 ms
    Sending data	0.11 ms
    End of update loop	0.04 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.04 ms
    Freeing items	0.25 ms
    Updating status	0.07 ms
    Reset for next command	0.09 ms

    Chamada de dados

    #	Chamador	Ficheiro e número da linha
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1544
    14	JDatabaseDriver->loadColumn()	JROOT/components/com_k2/models/itemlist.php:563
    13	K2ModelItemlist->getCategoryTree()	JROOT/components/com_k2/models/itemlist.php:109
    12	K2ModelItemlist->getData()	JROOT/components/com_k2/views/itemlist/view.html.php:351
    11	K2ViewItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:19
    9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:45
    8	K2ControllerItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
    6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Adiciona a diretiva xdebug.file_link_format ao teu ficheiro php.ini para ter ligações para ficheiros]

    ---

21. Tempo da consulta: 18.35 ms Após a última consulta: 0.19 ms Consulta a Memória: 0.007 MB de memória antes da consulta: 10.537 MB Linhas devolvidas: 26

    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 09:10:43' ) 
      AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-09-08 09:10:43' ) 
      AND c.id IN (38,5,6,7,32,33,34) 
      ORDER BY i.id DESC 
      LIMIT 34, 34

    Explica

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	c	range	PRIMARY,category,published,access,trash	PRIMARY	4	NULL	7	78.15	Using index condition; Using where; Using temporary; Filesort em utilização
    1	SIMPLE	i	ref	item,catid	catid	4	plurales_2015.c.id	25	99.62	Using index condition; Using where

    Perfil

    Status	Duration
    Starting	0.44 ms
    checking permissions	0.07 ms
    Opening tables	0.07 ms
    After opening tables	0.04 ms
    System lock	0.03 ms
    table lock	0.04 ms
    init	0.25 ms
    Optimizing	0.14 ms
    Statistics	0.33 ms
    Preparing	0.19 ms
    Creating tmp table	0.23 ms
    Sorting result	0.06 ms
    Executing	0.04 ms
    Sending data	7.45 ms
    Creating sort index	3.00 ms
    Removing tmp table	4.91 ms
    Creating sort index	0.07 ms
    End of update loop	0.05 ms
    Query end	0.04 ms
    closing tables	0.07 ms
    Unlocking tables	0.03 ms
    closing tables	0.05 ms
    Query end	0.05 ms
    Starting cleanup	0.04 ms
    Freeing items	0.35 ms
    Updating status	0.09 ms
    Reset for next command	0.08 ms

    Chamada de dados

    #	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

    [Adiciona a diretiva xdebug.file_link_format ao teu ficheiro php.ini para ter ligações para ficheiros]

    ---

22. Tempo da consulta: 5.99 ms Após a última consulta: 2.06 ms Consulta a Memória: 0.007 MB de memória antes da consulta: 11.013 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 09:10:43' ) 
      AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-09-08 09:10:43' ) 
      AND c.id IN (38,5,6,7,32,33,34)

    Explica

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	c	range	PRIMARY,category,published,access,trash	PRIMARY	4	NULL	7	78.15	Using index condition; Using where
    1	SIMPLE	i	ref	item,catid	catid	4	plurales_2015.c.id	25	99.62	Using index condition; Using where

    Perfil

    Status	Duration
    Starting	0.57 ms
    checking permissions	0.05 ms
    Opening tables	0.09 ms
    After opening tables	0.04 ms
    System lock	0.04 ms
    table lock	0.05 ms
    init	0.16 ms
    Optimizing	0.19 ms
    Statistics	0.43 ms
    Preparing	0.19 ms
    Executing	0.04 ms
    Sending data	3.27 ms
    End of update loop	0.05 ms
    Query end	0.03 ms
    closing tables	0.03 ms
    Unlocking tables	0.03 ms
    closing tables	0.07 ms
    Query end	0.05 ms
    Starting cleanup	0.04 ms
    Freeing items	0.28 ms
    Updating status	0.07 ms
    Reset for next command	0.07 ms

    Chamada de dados

    #	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

    [Adiciona a diretiva xdebug.file_link_format ao teu ficheiro php.ini para ter ligações para ficheiros]

    ---

23. Tempo da consulta: 1.49 ms Após a última consulta: 2.83 ms Consulta a Memória: 0.009 MB de memória antes da consulta: 11.102 MB Linhas devolvidas: 1

    SELECT * 
      FROM pl_k2_categories 
      WHERE id = '7'

    Explica

    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

    Perfil

    Status	Duration
    Starting	0.32 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.09 ms
    Optimizing	0.04 ms
    Statistics	0.11 ms
    Preparing	0.02 ms
    Unlocking tables	0.02 ms
    Preparing	0.04 ms
    Executing	0.02 ms
    Sending data	0.05 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.03 ms
    Query end	0.03 ms
    Starting cleanup	0.03 ms
    Freeing items	0.14 ms
    Updating status	0.08 ms
    Reset for next command	0.05 ms

    Chamada de dados

    #	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

    [Adiciona a diretiva xdebug.file_link_format ao teu ficheiro php.ini para ter ligações para ficheiros]

    ---

24. Tempo da consulta: 1.40 ms Após a última consulta: 1.77 ms Consulta a Memória: 0.009 MB de memória antes da consulta: 11.177 MB Linhas devolvidas: 1

    SELECT * 
      FROM pl_k2_categories 
      WHERE id = '15'

    Explica

    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

    Perfil

    Status	Duration
    Starting	0.22 ms
    checking permissions	0.06 ms
    Opening tables	0.04 ms
    After opening tables	0.02 ms
    System lock	0.02 ms
    table lock	0.03 ms
    init	0.06 ms
    Optimizing	0.04 ms
    Statistics	0.09 ms
    Preparing	0.02 ms
    Unlocking tables	0.02 ms
    Preparing	0.03 ms
    Executing	0.02 ms
    Sending data	0.05 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.03 ms
    Query end	0.03 ms
    Starting cleanup	0.03 ms
    Freeing items	0.22 ms
    Updating status	0.06 ms
    Reset for next command	0.04 ms

    Chamada de dados

    #	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

    [Adiciona a diretiva xdebug.file_link_format ao teu ficheiro php.ini para ter ligações para ficheiros]

    ---

25. Tempo da consulta: 3.10 ms Após a última consulta: 2.33 ms Consulta a Memória: 0.012 MB de memória antes da consulta: 11.258 MB Linhas devolvidas: 15

    SHOW FULL COLUMNS 
      FROM `pl_users`

    Explica

    EXPLAIN não é possível na consulta: SHOW FULL COLUMNS FROM `pl_users`

    Perfil

    Status	Duration
    Starting	0.22 ms
    checking permissions	0.03 ms
    closing tables	0.05 ms
    checking permissions	0.03 ms
    Opening tables	1.00 ms
    After opening tables	0.04 ms
    System lock	0.03 ms
    table lock	0.03 ms
    init	0.03 ms
    Optimizing	0.03 ms
    Statistics	0.06 ms
    Preparing	0.05 ms
    Executing	0.02 ms
    Filling schema table	0.03 ms
    Opening tables	0.05 ms
    After opening tables	0.02 ms
    checking permissions	0.19 ms
    closing tables	0.03 ms
    checking permissions	0.03 ms
    Executing	0.02 ms
    Sending data	0.09 ms
    End of update loop	0.03 ms
    Query end	0.02 ms
    closing tables	0.02 ms
    Removing tmp table	0.38 ms
    closing tables	0.05 ms
    Unlocking tables	0.02 ms
    closing tables	0.02 ms
    Query end	0.02 ms
    Starting cleanup	0.03 ms
    Freeing items	0.18 ms
    Updating status	0.06 ms
    Reset for next command	0.04 ms

    Chamada de dados

    #	Chamador	Ficheiro e número da linha
    27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    26	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
    25	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
    24	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
    23	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/User.php:40
    22	Joomla\CMS\Table\User->__construct()	JROOT/libraries/src/Table/Table.php:312
    21	Joomla\CMS\Table\Table::getInstance()	JROOT/libraries/src/User/User.php:603
    20	Joomla\CMS\User\User::getTable()	JROOT/libraries/src/User/User.php:880
    19	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
    18	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
    17	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
    16	Joomla\CMS\Factory::getUser()	JROOT/components/com_k2/models/item.php:211
    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

    [Adiciona a diretiva xdebug.file_link_format ao teu ficheiro php.ini para ter ligações para ficheiros]

    ---

26. Tempo da consulta: 1.37 ms Após a última consulta: 0.23 ms Consulta a Memória: 0.010 MB de memória antes da consulta: 11.293 MB Linhas devolvidas: 1

    SELECT *
    
      FROM `pl_users`
    
      WHERE `id` = 43

    Explica

    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

    Perfil

    Status	Duration
    Starting	0.24 ms
    checking permissions	0.03 ms
    Opening tables	0.05 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.10 ms
    Preparing	0.03 ms
    Unlocking tables	0.03 ms
    Preparing	0.03 ms
    Executing	0.02 ms
    Sending data	0.04 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.06 ms
    Freeing items	0.15 ms
    Updating status	0.06 ms
    Reset for next command	0.06 ms

    Chamada de dados

    #	Chamador	Ficheiro e número da linha
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1459
    21	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/User.php:86
    20	Joomla\CMS\Table\User->load()	JROOT/libraries/src/User/User.php:883
    19	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
    18	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
    17	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
    16	Joomla\CMS\Factory::getUser()	JROOT/components/com_k2/models/item.php:211
    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

    [Adiciona a diretiva xdebug.file_link_format ao teu ficheiro php.ini para ter ligações para ficheiros]

    ---

27. Tempo da consulta: 1.76 ms Após a última consulta: 6.58 ms Consulta a Memória: 0.010 MB de memória antes da consulta: 12.110 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` = 43

    Explica

    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

    Perfil

    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.05 ms
    Optimizing	0.05 ms
    Statistics	0.16 ms
    Preparing	0.07 ms
    Executing	0.02 ms
    Sending data	0.15 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.05 ms
    Query end	0.03 ms
    Starting cleanup	0.03 ms
    Freeing items	0.15 ms
    Updating status	0.07 ms
    Reset for next command	0.05 ms

    Chamada de dados

    #	Chamador	Ficheiro e número da linha
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1500
    21	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Table/User.php:111
    20	Joomla\CMS\Table\User->load()	JROOT/libraries/src/User/User.php:883
    19	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
    18	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
    17	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
    16	Joomla\CMS\Factory::getUser()	JROOT/components/com_k2/models/item.php:211
    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

    [Adiciona a diretiva xdebug.file_link_format ao teu ficheiro php.ini para ter ligações para ficheiros]

    ---

28. Tempo da consulta: 1.33 ms Após a última consulta: 1.08 ms Consulta a Memória: 0.009 MB de memória antes da consulta: 12.119 MB Linhas devolvidas: 1

    SELECT id, gender, description, image, url, `
      group`, plugins 
      FROM pl_k2_users 
      WHERE userID=43

    Explica

    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

    Perfil

    Status	Duration
    Starting	0.26 ms
    checking permissions	0.03 ms
    Opening tables	0.05 ms
    After opening tables	0.02 ms
    System lock	0.02 ms
    table lock	0.05 ms
    init	0.05 ms
    Optimizing	0.04 ms
    Statistics	0.09 ms
    Preparing	0.05 ms
    Executing	0.02 ms
    Sending data	0.09 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.13 ms
    Updating status	0.06 ms
    Reset for next command	0.07 ms

    Chamada de dados

    #	Chamador	Ficheiro e número da linha
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
    17	JDatabaseDriver->loadObject()	JROOT/components/com_k2/models/item.php:1550
    16	K2ModelItem->getUserProfile()	JROOT/components/com_k2/models/item.php:214
    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

    [Adiciona a diretiva xdebug.file_link_format ao teu ficheiro php.ini para ter ligações para ficheiros]

    ---

29. Tempo da consulta: 2.28 ms Após a última consulta: 5.08 ms Consulta a Memória: 0.010 MB de memória antes da consulta: 12.170 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 (7,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

    Explica

    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

    Perfil

    Status	Duration
    Starting	0.44 ms
    checking permissions	0.03 ms
    Opening tables	0.13 ms
    After opening tables	0.03 ms
    System lock	0.03 ms
    table lock	0.03 ms
    init	0.18 ms
    Optimizing	0.12 ms
    Statistics	0.20 ms
    Preparing	0.13 ms
    Sorting result	0.05 ms
    Executing	0.02 ms
    Sending data	0.05 ms
    Creating sort index	0.10 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.07 ms
    Starting cleanup	0.03 ms
    Freeing items	0.15 ms
    Updating status	0.15 ms
    Reset for next command	0.06 ms

    Chamada de dados

    #	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

    [Adiciona a diretiva xdebug.file_link_format ao teu ficheiro php.ini para ter ligações para ficheiros]

    ---

30. Tempo da consulta: 1.44 ms Após a última consulta: 0.91 ms Consulta a Memória: 0.009 MB de memória antes da consulta: 12.198 MB Linhas devolvidas: 1

    SELECT * 
      FROM pl_k2_categories 
      WHERE id = '34'

    Explica

    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

    Perfil

    Status	Duration
    Starting	0.21 ms
    checking permissions	0.03 ms
    Opening tables	0.05 ms
    After opening tables	0.02 ms
    System lock	0.02 ms
    table lock	0.03 ms
    init	0.06 ms
    Optimizing	0.04 ms
    Statistics	0.15 ms
    Preparing	0.03 ms
    Unlocking tables	0.02 ms
    Preparing	0.03 ms
    Executing	0.02 ms
    Sending data	0.05 ms
    End of update loop	0.02 ms
    Query end	0.04 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.23 ms
    Updating status	0.06 ms
    Reset for next command	0.04 ms

    Chamada de dados

    #	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

    [Adiciona a diretiva xdebug.file_link_format ao teu ficheiro php.ini para ter ligações para ficheiros]

    ---

31. Tempo da consulta: 1.44 ms Após a última consulta: 2.31 ms Consulta a Memória: 0.010 MB de memória antes da consulta: 12.271 MB Linhas devolvidas: 1

    SELECT *
    
      FROM `pl_users`
    
      WHERE `id` = 44

    Explica

    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

    Perfil

    Status	Duration
    Starting	0.24 ms
    checking permissions	0.03 ms
    Opening tables	0.06 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.14 ms
    Preparing	0.03 ms
    Unlocking tables	0.03 ms
    Preparing	0.03 ms
    Executing	0.02 ms
    Sending data	0.05 ms
    End of update loop	0.06 ms
    Query end	0.03 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.03 ms
    Freeing items	0.16 ms
    Updating status	0.09 ms
    Reset for next command	0.04 ms

    Chamada de dados

    #	Chamador	Ficheiro e número da linha
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1459
    21	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/User.php:86
    20	Joomla\CMS\Table\User->load()	JROOT/libraries/src/User/User.php:883
    19	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
    18	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
    17	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
    16	Joomla\CMS\Factory::getUser()	JROOT/components/com_k2/models/item.php:211
    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

    [Adiciona a diretiva xdebug.file_link_format ao teu ficheiro php.ini para ter ligações para ficheiros]

    ---

32. Tempo da consulta: 1.37 ms Após a última consulta: 0.24 ms Consulta a Memória: 0.010 MB de memória antes da consulta: 12.284 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

    Explica

    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

    Perfil

    Status	Duration
    Starting	0.26 ms
    checking permissions	0.03 ms
    Opening tables	0.05 ms
    After opening tables	0.02 ms
    System lock	0.02 ms
    table lock	0.05 ms
    init	0.04 ms
    Optimizing	0.04 ms
    Statistics	0.11 ms
    Preparing	0.06 ms
    Executing	0.02 ms
    Sending data	0.08 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.02 ms
    Query end	0.03 ms
    Starting cleanup	0.03 ms
    Freeing items	0.19 ms
    Updating status	0.05 ms
    Reset for next command	0.04 ms

    Chamada de dados

    #	Chamador	Ficheiro e número da linha
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1500
    21	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Table/User.php:111
    20	Joomla\CMS\Table\User->load()	JROOT/libraries/src/User/User.php:883
    19	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
    18	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
    17	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
    16	Joomla\CMS\Factory::getUser()	JROOT/components/com_k2/models/item.php:211
    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

    [Adiciona a diretiva xdebug.file_link_format ao teu ficheiro php.ini para ter ligações para ficheiros]

    ---

33. Tempo da consulta: 1.32 ms Após a última consulta: 0.90 ms Consulta a Memória: 0.010 MB de memória antes da consulta: 12.298 MB Linhas devolvidas: 1

    SELECT id, gender, description, image, url, `
      group`, plugins 
      FROM pl_k2_users 
      WHERE userID=44

    Explica

    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

    Perfil

    Status	Duration
    Starting	0.26 ms
    checking permissions	0.03 ms
    Opening tables	0.05 ms
    After opening tables	0.02 ms
    System lock	0.02 ms
    table lock	0.03 ms
    init	0.04 ms
    Optimizing	0.03 ms
    Statistics	0.09 ms
    Preparing	0.05 ms
    Executing	0.02 ms
    Sending data	0.09 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.06 ms
    Starting cleanup	0.03 ms
    Freeing items	0.13 ms
    Updating status	0.07 ms
    Reset for next command	0.04 ms

    Chamada de dados

    #	Chamador	Ficheiro e número da linha
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
    17	JDatabaseDriver->loadObject()	JROOT/components/com_k2/models/item.php:1550
    16	K2ModelItem->getUserProfile()	JROOT/components/com_k2/models/item.php:214
    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

    [Adiciona a diretiva xdebug.file_link_format ao teu ficheiro php.ini para ter ligações para ficheiros]

    ---

34. Tempo da consulta: 2.16 ms Após a última consulta: 3.15 ms Consulta a Memória: 0.010 MB de memória antes da consulta: 12.266 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 (34,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

    Explica

    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

    Perfil

    Status	Duration
    Starting	0.44 ms
    checking permissions	0.03 ms
    Opening tables	0.12 ms
    After opening tables	0.03 ms
    System lock	0.05 ms
    table lock	0.03 ms
    init	0.11 ms
    Optimizing	0.09 ms
    Statistics	0.19 ms
    Preparing	0.10 ms
    Sorting result	0.04 ms
    Executing	0.02 ms
    Sending data	0.05 ms
    Creating sort index	0.20 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.05 ms
    Query end	0.04 ms
    Starting cleanup	0.03 ms
    Freeing items	0.15 ms
    Updating status	0.06 ms
    Reset for next command	0.05 ms

    Chamada de dados

    #	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

    [Adiciona a diretiva xdebug.file_link_format ao teu ficheiro php.ini para ter ligações para ficheiros]

    ---

35. Tempo da consulta: 1.45 ms Após a última consulta: 0.91 ms Consulta a Memória: 0.009 MB de memória antes da consulta: 12.294 MB Linhas devolvidas: 1

    SELECT * 
      FROM pl_k2_categories 
      WHERE id = '32'

    Explica

    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

    Perfil

    Status	Duration
    Starting	0.22 ms
    checking permissions	0.03 ms
    Opening tables	0.05 ms
    After opening tables	0.06 ms
    System lock	0.07 ms
    table lock	0.03 ms
    init	0.05 ms
    Optimizing	0.03 ms
    Statistics	0.12 ms
    Preparing	0.03 ms
    Unlocking tables	0.02 ms
    Preparing	0.03 ms
    Executing	0.02 ms
    Sending data	0.04 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.03 ms
    Query end	0.09 ms
    Starting cleanup	0.03 ms
    Freeing items	0.13 ms
    Updating status	0.06 ms
    Reset for next command	0.04 ms

    Chamada de dados

    #	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

    [Adiciona a diretiva xdebug.file_link_format ao teu ficheiro php.ini para ter ligações para ficheiros]

    ---

36. Tempo da consulta: 2.25 ms Após a última consulta: 4.73 ms Consulta a Memória: 0.010 MB de memória antes da consulta: 12.321 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 (32,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

    Explica

    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

    Perfil

    Status	Duration
    Starting	0.47 ms
    checking permissions	0.03 ms
    Opening tables	0.11 ms
    After opening tables	0.03 ms
    System lock	0.03 ms
    table lock	0.03 ms
    init	0.12 ms
    Optimizing	0.09 ms
    Statistics	0.19 ms
    Preparing	0.15 ms
    Sorting result	0.05 ms
    Executing	0.02 ms
    Sending data	0.05 ms
    Creating sort index	0.12 ms
    End of update loop	0.03 ms
    Query end	0.12 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.03 ms
    Freeing items	0.15 ms
    Updating status	0.06 ms
    Reset for next command	0.05 ms

    Chamada de dados

    #	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

    [Adiciona a diretiva xdebug.file_link_format ao teu ficheiro php.ini para ter ligações para ficheiros]

    ---

37. Tempo da consulta: 1.34 ms Após a última consulta: 0.70 ms Consulta a Memória: 0.009 MB de memória antes da consulta: 12.348 MB Linhas devolvidas: 1

    SELECT * 
      FROM pl_k2_categories 
      WHERE id = '6'

    Explica

    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

    Perfil

    Status	Duration
    Starting	0.24 ms
    checking permissions	0.03 ms
    Opening tables	0.05 ms
    After opening tables	0.02 ms
    System lock	0.02 ms
    table lock	0.03 ms
    init	0.07 ms
    Optimizing	0.04 ms
    Statistics	0.11 ms
    Preparing	0.02 ms
    Unlocking tables	0.02 ms
    Preparing	0.03 ms
    Executing	0.02 ms
    Sending data	0.05 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.03 ms
    Query end	0.03 ms
    Starting cleanup	0.04 ms
    Freeing items	0.14 ms
    Updating status	0.06 ms
    Reset for next command	0.04 ms

    Chamada de dados

    #	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

    [Adiciona a diretiva xdebug.file_link_format ao teu ficheiro php.ini para ter ligações para ficheiros]

    ---

38. Tempo da consulta: 2.31 ms Após a última consulta: 4.93 ms Consulta a Memória: 0.010 MB de memória antes da consulta: 12.375 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 (6,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

    Explica

    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

    Perfil

    Status	Duration
    Starting	0.44 ms
    checking permissions	0.03 ms
    Opening tables	0.11 ms
    After opening tables	0.03 ms
    System lock	0.03 ms
    table lock	0.03 ms
    init	0.12 ms
    Optimizing	0.09 ms
    Statistics	0.32 ms
    Preparing	0.11 ms
    Sorting result	0.05 ms
    Executing	0.02 ms
    Sending data	0.05 ms
    Creating sort index	0.09 ms
    End of update loop	0.03 ms
    Query end	0.09 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.04 ms
    Starting cleanup	0.03 ms
    Freeing items	0.20 ms
    Updating status	0.06 ms
    Reset for next command	0.05 ms

    Chamada de dados

    #	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

    [Adiciona a diretiva xdebug.file_link_format ao teu ficheiro php.ini para ter ligações para ficheiros]

    ---

39. Tempo da consulta: 4.12 ms Após a última consulta: 183.11 ms Consulta a Memória: 0.010 MB de memória antes da consulta: 14.089 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 09:10:43') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-09-08 09:10:43') 
      AND m.access IN (1,1) 
      AND m.client_id = 0 
      AND (mm.menuid = 939 OR mm.menuid <= 0)
    
      ORDER BY m.position, m.ordering

    Explica

    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

    Perfil

    Status	Duration
    Starting	0.54 ms
    checking permissions	0.03 ms
    Opening tables	0.09 ms
    After opening tables	0.06 ms
    System lock	0.03 ms
    table lock	0.04 ms
    init	0.12 ms
    Optimizing	0.12 ms
    Statistics	0.20 ms
    Preparing	0.10 ms
    Sorting result	0.04 ms
    Executing	0.03 ms
    Sending data	0.08 ms
    Creating sort index	1.71 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.04 ms
    Query end	0.09 ms
    Starting cleanup	0.04 ms
    Freeing items	0.23 ms
    Updating status	0.09 ms
    Reset for next command	0.06 ms

    Chamada de dados

    #	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

    [Adiciona a diretiva xdebug.file_link_format ao teu ficheiro php.ini para ter ligações para ficheiros]

    ---

40. Tempo da consulta: 1.56 ms Após a última consulta: 20.08 ms Consulta a Memória: 0.008 MB de memória antes da consulta: 14.359 MB Linhas devolvidas: 1

    SELECT created 
      FROM pl_content 
      WHERE state = 1 
      ORDER BY created DESC 
      LIMIT 1;

    Explica

    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

    Perfil

    Status	Duration
    Starting	0.33 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.02 ms
    init	0.10 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.05 ms
    Creating sort index	0.11 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.01 ms
    closing tables	0.02 ms
    Query end	0.02 ms
    Starting cleanup	0.02 ms
    Freeing items	0.13 ms
    Updating status	0.04 ms
    Reset for next command	0.04 ms

    Chamada de dados

    #	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

    [Adiciona a diretiva xdebug.file_link_format ao teu ficheiro php.ini para ter ligações para ficheiros]

    ---

41. Tempo da consulta: 0.93 ms Após a última consulta: 0.18 ms Consulta a Memória: 0.008 MB de memória antes da consulta: 14.366 MB Linhas devolvidas: 1

    SELECT modified 
      FROM pl_content 
      WHERE state = 1 
      ORDER BY modified DESC 
      LIMIT 1;

    Explica

    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

    Perfil

    Status	Duration
    Starting	0.13 ms
    checking permissions	0.02 ms
    Opening tables	0.03 ms
    After opening tables	0.02 ms
    System lock	0.02 ms
    table lock	0.02 ms
    init	0.03 ms
    Optimizing	0.03 ms
    Statistics	0.06 ms
    Preparing	0.04 ms
    Sorting result	0.02 ms
    Executing	0.02 ms
    Sending data	0.02 ms
    Creating sort index	0.06 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.03 ms
    Unlocking tables	0.02 ms
    closing tables	0.02 ms
    Query end	0.02 ms
    Starting cleanup	0.02 ms
    Freeing items	0.09 ms
    Updating status	0.03 ms
    Reset for next command	0.03 ms

    Chamada de dados

    #	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

    [Adiciona a diretiva xdebug.file_link_format ao teu ficheiro php.ini para ter ligações para ficheiros]

    ---

42. Tempo da consulta: 0.92 ms Após a última consulta: 0.19 ms Consulta a Memória: 0.008 MB de memória antes da consulta: 14.374 MB Linhas devolvidas: 1

    SELECT created 
      FROM pl_k2_items 
      WHERE published = 1 
      ORDER BY created DESC 
      LIMIT 1;

    Explica

    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

    Perfil

    Status	Duration
    Starting	0.12 ms
    checking permissions	0.02 ms
    Opening tables	0.03 ms
    After opening tables	0.02 ms
    System lock	0.02 ms
    table lock	0.02 ms
    init	0.03 ms
    Optimizing	0.02 ms
    Statistics	0.08 ms
    Preparing	0.04 ms
    Sorting result	0.02 ms
    Executing	0.02 ms
    Sending data	0.11 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.10 ms
    Updating status	0.03 ms
    Reset for next command	0.03 ms

    Chamada de dados

    #	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

    [Adiciona a diretiva xdebug.file_link_format ao teu ficheiro php.ini para ter ligações para ficheiros]

    ---

43. Tempo da consulta: 32.36 ms Após a última consulta: 0.11 ms Consulta a Memória: 0.008 MB de memória antes da consulta: 14.381 MB Linhas devolvidas: 1

    SELECT modified 
      FROM pl_k2_items 
      WHERE published = 1 
      ORDER BY modified DESC 
      LIMIT 1;

    Explica

    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

    Perfil

    Status	Duration
    Starting	0.12 ms
    checking permissions	0.02 ms
    Opening tables	0.04 ms
    After opening tables	0.02 ms
    System lock	0.02 ms
    table lock	0.03 ms
    init	0.03 ms
    Optimizing	0.03 ms
    Statistics	0.06 ms
    Preparing	0.03 ms
    Sorting result	0.02 ms
    Executing	0.03 ms
    Sending data	0.02 ms
    Creating sort index	31.30 ms
    End of update loop	0.05 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.04 ms

    Chamada de dados

    #	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

    [Adiciona a diretiva xdebug.file_link_format ao teu ficheiro php.ini para ter ligações para ficheiros]

    ---

44. Tempo da consulta: 2.27 ms Após a última consulta: 31.98 ms Consulta a Memória: 0.007 MB de memória antes da consulta: 14.759 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

    Explica

    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

    Perfil

    Status	Duration
    Starting	0.47 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.04 ms
    init	0.11 ms
    Optimizing	0.11 ms
    Statistics	0.29 ms
    Preparing	0.04 ms
    Unlocking tables	0.03 ms
    Preparing	0.08 ms
    Executing	0.03 ms
    Sending data	0.08 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.04 ms
    Query end	0.04 ms
    Starting cleanup	0.03 ms
    Freeing items	0.18 ms
    Updating status	0.09 ms
    Reset for next command	0.06 ms

    Chamada de dados

    #	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

    [Adiciona a diretiva xdebug.file_link_format ao teu ficheiro php.ini para ter ligações para ficheiros]

    ---

45. Tempo da consulta: 2.12 ms Após a última consulta: 0.32 ms Consulta a Memória: 0.007 MB de memória antes da consulta: 14.767 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 09:10:43' )
    				
      AND ( content.publish_down = '0000-00-00 00:00:00' OR content.publish_down >= '2024-09-08 09:10:43' )
    			 
      AND (  content.catid = 107 ) 
    			
    			 
    			
    		
      ORDER BY 
    			 content.created DESC 
    		
      LIMIT
    			0,1;

    Explica

    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

    Perfil

    Status	Duration
    Starting	0.34 ms
    checking permissions	0.03 ms
    Opening tables	0.05 ms
    After opening tables	0.03 ms
    System lock	0.07 ms
    table lock	0.04 ms
    init	0.10 ms
    Optimizing	0.12 ms
    Statistics	0.23 ms
    Preparing	0.12 ms
    Sorting result	0.04 ms
    Executing	0.03 ms
    Sending data	0.04 ms
    Creating sort index	0.19 ms
    End of update loop	0.07 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.22 ms
    Updating status	0.07 ms
    Reset for next command	0.05 ms

    Chamada de dados

    #	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

    [Adiciona a diretiva xdebug.file_link_format ao teu ficheiro php.ini para ter ligações para ficheiros]

    ---

46. Tempo da consulta: 2.10 ms Após a última consulta: 0.12 ms Consulta a Memória: 0.007 MB de memória antes da consulta: 14.777 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

    Explica

    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

    Perfil

    Status	Duration
    Starting	0.37 ms
    checking permissions	0.03 ms
    Opening tables	0.13 ms
    After opening tables	0.04 ms
    System lock	0.04 ms
    table lock	0.04 ms
    init	0.08 ms
    Optimizing	0.07 ms
    Statistics	0.28 ms
    Preparing	0.04 ms
    Unlocking tables	0.05 ms
    Preparing	0.05 ms
    Executing	0.06 ms
    Sending data	0.05 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.05 ms
    closing tables	0.04 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

    Chamada de dados

    #	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

    [Adiciona a diretiva xdebug.file_link_format ao teu ficheiro php.ini para ter ligações para ficheiros]

    ---

47. Tempo da consulta: 2.28 ms Após a última consulta: 0.86 ms Consulta a Memória: 0.007 MB de memória antes da consulta: 14.791 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

    Explica

    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

    Perfil

    Status	Duration
    Starting	0.31 ms
    checking permissions	0.04 ms
    Opening tables	0.05 ms
    After opening tables	0.03 ms
    System lock	0.03 ms
    table lock	0.03 ms
    init	0.08 ms
    Optimizing	0.06 ms
    Statistics	0.16 ms
    Preparing	0.06 ms
    Sorting result	0.04 ms
    Executing	0.03 ms
    Sending data	0.03 ms
    Creating sort index	0.67 ms
    End of update loop	0.04 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.17 ms
    Updating status	0.06 ms
    Reset for next command	0.05 ms

    Chamada de dados

    #	Chamador	Ficheiro e número da linha
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    15	JDatabaseDriver->loadObjectList()	JROOT/components/com_k2/models/itemlist.php:1077
    14	K2ModelItemlist->getCategoriesTree()	JROOT/components/com_k2/helpers/route.php:314
    13	K2HelperRoute::_findItem()	JROOT/components/com_k2/helpers/route.php:41
    12	K2HelperRoute::getItemRoute()	JROOT/modules/mod_highlighter_gk5/helper.php:148
    11	NH_GK5_Helper->renderLayout()	JROOT/modules/mod_highlighter_gk5/mod_highlighter_gk5.php:22
    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

    [Adiciona a diretiva xdebug.file_link_format ao teu ficheiro php.ini para ter ligações para ficheiros]

    ---