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

Hora

Memoria

34 consultas reportadas 96.79 ms

1. Tiempo de consulta: 1.59 ms Memoria de consulta: 0.023 MB memoria antes de consulta: 1.254 MB Filas entregadas por la consulta: 0

   SELECT `data`
   
     FROM `agua_session`
   
     WHERE `session_id` = X'3737643363323938663663613839633136373762643639313739306263623139'

   Explicar

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	agua_session	const	PRIMARY	PRIMARY	194	const	1

   Perfil

   Status	Duration
   Starting	0.28 ms
   checking permissions	0.02 ms
   Opening tables	0.06 ms
   After opening tables	0.02 ms
   System lock	0.01 ms
   table lock	0.01 ms
   init	0.04 ms
   Optimizing	0.02 ms
   Statistics	0.07 ms
   Preparing	0.02 ms
   Executing	0.02 ms
   End of update loop	0.01 ms
   Query end	0.01 ms
   Commit	0.01 ms
   Query end	0.01 ms
   closing tables	0.01 ms
   Unlocking tables	0.01 ms
   closing tables	0.01 ms
   Query end	0.02 ms
   Starting cleanup	0.01 ms
   Freeing items	0.13 ms
   Updating status	0.02 ms
   Reset for next command	0.01 ms

   Call Stack

   #	Caller	Número de archivo y de línea
   16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
   15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
   14	JSessionStorageDatabase->read()	Igual que la llamada en la línea de abajo.
   13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
   12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
   11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:88
   10	JSessionHandlerJoomla->start()	JROOT/libraries/src/Session/Session.php:661
   9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:621
   8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:499
   7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:456
   6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:854
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
   4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
   3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:414
   2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
   1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

   [Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

   ---

2. Tiempo de consulta: 1.40 ms Después de la última consulta: 0.84 ms Memoria de consulta: 0.020 MB memoria antes de consulta: 1.270 MB Filas entregadas por la consulta: 0

   SELECT `session_id`
   
     FROM `agua_session`
   
     WHERE `session_id` = X'3737643363323938663663613839633136373762643639313739306263623139' 
     LIMIT 1

   Explicar

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	agua_session	const	PRIMARY	PRIMARY	194	const	1	Using index

   Perfil

   Status	Duration
   Starting	0.17 ms
   checking permissions	0.02 ms
   Opening tables	0.02 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   table lock	0.01 ms
   init	0.02 ms
   Optimizing	0.01 ms
   Statistics	0.03 ms
   Preparing	0.01 ms
   Executing	0.01 ms
   End of update loop	0.01 ms
   Query end	0.01 ms
   Commit	0.01 ms
   Query end	0.01 ms
   closing tables	0.01 ms
   Unlocking tables	0.01 ms
   closing tables	0.01 ms
   Query end	0.01 ms
   Starting cleanup	0.01 ms
   Freeing items	0.13 ms
   Updating status	0.69 ms
   Reset for next command	0.02 ms

   Call Stack

   #	Caller	Número de archivo y de línea
   9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
   8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
   7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
   6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:856
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
   4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
   3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:414
   2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
   1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

   [Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

   ---

3. Tiempo de consulta: 5.57 ms Después de la última consulta: 0.37 ms Memoria de consulta: 0.004 MB memoria antes de consulta: 1.276 MB

   INSERT INTO `agua_session`
   (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES 
   (X'3737643363323938663663613839633136373762643639313739306263623139', 1, 1773927182, 0, '', 0)

   Explicar

   No es posible hacer EXPLAIN en la consulta: INSERT INTO `agua_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3737643363323938663663613839633136373762643639313739306263623139', 1, 1773927182, 0, '', 0)

   Perfil

   Status	Duration
   Starting	0.21 ms
   checking permissions	0.02 ms
   Opening tables	0.04 ms
   After opening tables	0.02 ms
   System lock	0.01 ms
   table lock	0.01 ms
   init for update	0.02 ms
   Update	0.17 ms
   Waiting for query cache lock	0.01 ms
   Update	0.01 ms
   End of update loop	0.03 ms
   Query end	0.01 ms
   Commit	2.81 ms
   Query end	0.10 ms
   closing tables	0.03 ms
   Unlocking tables	0.01 ms
   closing tables	0.03 ms
   Query end	0.02 ms
   Starting cleanup	0.01 ms
   Freeing items	0.18 ms
   Updating status	0.03 ms
   Reset for next command	0.01 ms

   Call Stack

   #	Caller	Número de archivo y de línea
   8	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
   7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
   6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:856
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
   4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
   3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:414
   2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
   1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

   [Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

   ---

4. Tiempo de consulta: 2.64 ms Después de la última consulta: 1.44 ms Memoria de consulta: 0.073 MB memoria antes de consulta: 1.373 MB Filas entregadas por la consulta: 50

   SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
   
     FROM `agua_extensions`
   
     WHERE `type` = 'component' 
     AND `state` = 0 
     AND `enabled` = 1

   Explicar

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	agua_extensions	ref	extension	extension	82	const	50	Using index condition; Using where

   Perfil

   Status	Duration
   Starting	0.38 ms
   checking permissions	0.04 ms
   Opening tables	0.04 ms
   After opening tables	0.02 ms
   System lock	0.01 ms
   table lock	0.01 ms
   init	0.05 ms
   Optimizing	0.04 ms
   Statistics	0.11 ms
   Preparing	0.05 ms
   Executing	0.01 ms
   Sending data	0.52 ms
   End of update loop	0.02 ms
   Query end	0.01 ms
   Commit	0.01 ms
   Query end	0.01 ms
   closing tables	0.01 ms
   Unlocking tables	0.01 ms
   closing tables	0.01 ms
   Query end	0.01 ms
   Starting cleanup	0.01 ms
   Freeing items	0.13 ms
   Updating status	0.02 ms
   Reset for next command	0.01 ms

   Call Stack

   #	Caller	Número de archivo y de línea
   12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
   11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Component/ComponentHelper.php:445
   10	Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}()	Igual que la llamada en la línea de abajo.
   9	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
   8	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Component/ComponentHelper.php:453
   7	Joomla\CMS\Component\ComponentHelper::load()	JROOT/libraries/src/Component/ComponentHelper.php:519
   6	Joomla\CMS\Component\ComponentHelper::getComponents()	JROOT/libraries/src/Component/ComponentHelper.php:44
   5	Joomla\CMS\Component\ComponentHelper::getComponent()	JROOT/libraries/src/Component/ComponentHelper.php:103
   4	Joomla\CMS\Component\ComponentHelper::getParams()	JROOT/libraries/src/Application/SiteApplication.php:594
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

   [Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

   ---

5. Tiempo de consulta: 1.36 ms Después de la última consulta: 1.50 ms Memoria de consulta: 0.021 MB memoria antes de consulta: 1.443 MB Filas entregadas por la consulta: 5

   SELECT id, rules
   
     FROM `agua_viewlevels`

   Explicar

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	agua_viewlevels	ALL	NULL	Ninguna llave índice (INDEX KEY) pudo ser utilizada	NULL	NULL	5

   Perfil

   Status	Duration
   Starting	0.42 ms
   checking permissions	0.02 ms
   Opening tables	0.06 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   table lock	0.02 ms
   init	0.03 ms
   Optimizing	0.02 ms
   Statistics	0.03 ms
   Preparing	0.06 ms
   Executing	0.03 ms
   Sending data	0.08 ms
   End of update loop	0.02 ms
   Query end	0.01 ms
   Commit	0.01 ms
   Query end	0.01 ms
   closing tables	0.01 ms
   Unlocking tables	0.02 ms
   closing tables	0.01 ms
   Query end	0.01 ms
   Starting cleanup	0.01 ms
   Freeing items	0.18 ms
   Updating status	0.03 ms
   Reset for next command	0.02 ms

   Call Stack

   #	Caller	Número de archivo y de línea
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
   9	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Access/Access.php:1063
   8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
   7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:318
   6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
   5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
   4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

   [Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

   ---

6. Tiempo de consulta: 4.84 ms Después de la última consulta: 0.21 ms Memoria de consulta: 0.021 MB memoria antes de consulta: 1.455 MB Filas entregadas por la consulta: 2

   SELECT b.id
   
     FROM agua_usergroups AS a
   
     LEFT JOIN agua_usergroups AS b 
     ON b.lft <= a.lft 
     AND b.rgt >= a.rgt
   
     WHERE a.id = 9

   Explicar

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	a	const	PRIMARY	PRIMARY	4	const	1
   1	SIMPLE	b	range	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	4	NULL	2	Using where; Using index

   Perfil

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

   Call Stack

   #	Caller	Número de archivo y de línea
   11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
   10	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
   9	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/Access/Access.php:1095
   8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
   7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:318
   6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
   5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
   4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

   [Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

   ---

7. Tiempo de consulta: 2.62 ms Después de la última consulta: 0.65 ms Memoria de consulta: 0.035 MB memoria antes de consulta: 1.477 MB Filas entregadas por la consulta: 145

   SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
   
     FROM agua_extensions
   
     WHERE enabled = 1 
     AND type = 'plugin' 
     AND state IN (0,1) 
     AND access IN (1,1,5)
   
     ORDER BY ordering

   Explicar

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	agua_extensions	ALL	extension	Ninguna llave índice (INDEX KEY) pudo ser utilizada	NULL	NULL	336	Using where; Utilizando filesort

   Perfil

   Status	Duration
   Starting	0.35 ms
   checking permissions	0.02 ms
   Opening tables	0.04 ms
   After opening tables	0.03 ms
   System lock	0.01 ms
   table lock	0.02 ms
   init	0.07 ms
   Optimizing	0.05 ms
   Statistics	0.11 ms
   Preparing	0.08 ms
   Sorting result	0.02 ms
   Executing	0.02 ms
   Sending data	0.02 ms
   Creating sort index	0.83 ms
   End of update loop	0.02 ms
   Query end	0.01 ms
   Commit	0.01 ms
   Query end	0.01 ms
   closing tables	0.08 ms
   Unlocking tables	0.01 ms
   closing tables	0.02 ms
   Query end	0.01 ms
   Starting cleanup	0.01 ms
   Freeing items	0.17 ms
   Updating status	0.05 ms
   Reset for next command	0.01 ms

   Call Stack

   #	Caller	Número de archivo y de línea
   11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
   10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:351
   9	Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()	Igual que la llamada en la línea de abajo.
   8	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
   7	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Plugin/PluginHelper.php:356
   6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
   5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
   4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

   [Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

   ---

8. Tiempo de consulta: 2.83 ms Después de la última consulta: 24.08 ms Memoria de consulta: 0.117 MB memoria antes de consulta: 2.486 MB Filas entregadas por la consulta: 86

   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 agua_menu AS m
   
     LEFT JOIN agua_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

   Explicar

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	m	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	126	Using index condition; Using where; Utilizando filesort
   1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	gel_aguasbca.m.component_id	1	Using where

   Perfil

   Status	Duration
   Starting	0.55 ms
   checking permissions	0.04 ms
   Opening tables	0.07 ms
   After opening tables	0.06 ms
   System lock	0.01 ms
   table lock	0.02 ms
   init	0.16 ms
   Optimizing	0.05 ms
   Statistics	0.13 ms
   Preparing	0.05 ms
   Sorting result	0.02 ms
   Executing	0.01 ms
   Sending data	0.03 ms
   Creating sort index	1.00 ms
   End of update loop	0.05 ms
   Query end	0.01 ms
   Commit	0.01 ms
   Query end	0.01 ms
   closing tables	0.01 ms
   Unlocking tables	0.01 ms
   closing tables	0.02 ms
   Query end	0.02 ms
   Starting cleanup	0.01 ms
   Freeing items	0.24 ms
   Updating status	0.04 ms
   Reset for next command	0.01 ms

   Call Stack

   #	Caller	Número de archivo y de línea
   23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
   22	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
   21	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Igual que la llamada en la línea de abajo.
   20	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
   19	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
   18	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:78
   17	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
   16	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:142
   15	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:445
   14	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
   13	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:65
   12	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
   11	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:561
   10	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
   9	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/plugins/system/dropfiles/dropfiles.php:37
   8	PlgSystemDropfiles->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
   7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
   6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
   5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:696
   4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

   [Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

   ---

9. Tiempo de consulta: 2.64 ms Después de la última consulta: 14.83 ms Memoria de consulta: 0.027 MB memoria antes de consulta: 3.236 MB Filas entregadas por la consulta: 45

   SELECT `id`,`name`,`rules`,`parent_id`
   
     FROM `agua_assets`
   
     WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_admintools','com_aimysitemap','com_ajax','com_associations','com_banners','com_cache','com_categories','com_checkin','com_cincopa','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_dpcalendar','com_dropfiles','com_easygcalendar','com_extplorer','com_fields','com_finder','com_flmngr','com_installer','com_jevents','com_joomdoc','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_osmap','com_plugins','com_postinstall','com_privacy','com_profiles','com_redirect','com_rstbox','com_search','com_sppolls','com_tags','com_templates','com_users','com_weblinks','com_wrapper','com_xmap')

   Explicar

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	agua_assets	range	idx_asset_name	idx_asset_name	202	NULL	51	Using index condition

   Perfil

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

   Call Stack

   #	Caller	Número de archivo y de línea
   16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
   15	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
   14	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
   13	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
   12	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
   11	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
   10	Joomla\CMS\User\User->authorise()	JROOT/plugins/system/sourcerer/helper.php:56
   9	plgSystemSourcererHelper->__construct()	JROOT/plugins/system/sourcerer/sourcerer.php:96
   8	plgSystemSourcerer->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:1218
   4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
   3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

   [Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

   ---

10. Tiempo de consulta: 5.38 ms Después de la última consulta: 4.85 ms Memoria de consulta: 0.026 MB memoria antes de consulta: 3.308 MB Filas entregadas por la consulta: 8

    SHOW FULL COLUMNS 
      FROM `agua_assets`

    Explicar

    No es posible hacer EXPLAIN en la consulta: SHOW FULL COLUMNS FROM `agua_assets`

    Perfil

    Status	Duration
    Starting	0.56 ms
    checking permissions	0.02 ms
    closing tables	0.01 ms
    checking permissions	0.01 ms
    Opening tables	1.26 ms
    After opening tables	0.14 ms
    System lock	0.01 ms
    table lock	0.02 ms
    init	0.03 ms
    Optimizing	0.02 ms
    Statistics	0.04 ms
    Preparing	0.04 ms
    Executing	0.01 ms
    Filling schema table	0.03 ms
    Opening tables	0.06 ms
    After opening tables	0.01 ms
    checking permissions	0.10 ms
    closing tables	0.02 ms
    checking permissions	0.11 ms
    Executing	0.01 ms
    Sending data	0.07 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Removing tmp table	0.29 ms
    closing tables	0.02 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.14 ms
    Freeing items	0.19 ms
    Updating status	0.04 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	Número de archivo y de línea
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    19	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
    18	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
    17	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
    16	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/Asset.php:61
    15	Joomla\CMS\Table\Asset->__construct()	JROOT/libraries/src/Access/Access.php:827
    14	Joomla\CMS\Access\Access::getAssetName()	JROOT/libraries/src/Access/Access.php:884
    13	Joomla\CMS\Access\Access::getAssetType()	JROOT/libraries/src/Access/Access.php:540
    12	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
    11	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
    10	Joomla\CMS\User\User->authorise()	JROOT/plugins/system/sourcerer/helper.php:56
    9	plgSystemSourcererHelper->__construct()	JROOT/plugins/system/sourcerer/sourcerer.php:96
    8	plgSystemSourcerer->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:1218
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
    3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

    ---

11. Tiempo de consulta: 3.23 ms Después de la última consulta: 0.97 ms Memoria de consulta: 0.024 MB memoria antes de consulta: 3.332 MB Filas entregadas por la consulta: 1

    SELECT *
    
      FROM agua_assets
    
      WHERE `id` = '1'

    Explicar

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	agua_assets	const	PRIMARY	PRIMARY	4	const	1

    Perfil

    Status	Duration
    Starting	0.40 ms
    checking permissions	0.02 ms
    Opening tables	0.18 ms
    After opening tables	0.02 ms
    System lock	0.01 ms
    table lock	0.02 ms
    init	0.07 ms
    Optimizing	0.03 ms
    Statistics	0.33 ms
    Preparing	0.02 ms
    Unlocking tables	0.01 ms
    Preparing	0.03 ms
    Executing	0.01 ms
    Sending data	0.03 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.17 ms
    Updating status	0.03 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	Número de archivo y de línea
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
    16	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
    15	Joomla\CMS\Table\Table->load()	JROOT/libraries/src/Access/Access.php:828
    14	Joomla\CMS\Access\Access::getAssetName()	JROOT/libraries/src/Access/Access.php:884
    13	Joomla\CMS\Access\Access::getAssetType()	JROOT/libraries/src/Access/Access.php:540
    12	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
    11	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
    10	Joomla\CMS\User\User->authorise()	JROOT/plugins/system/sourcerer/helper.php:56
    9	plgSystemSourcererHelper->__construct()	JROOT/plugins/system/sourcerer/sourcerer.php:96
    8	plgSystemSourcerer->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:1218
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
    3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

    ---

12. Tiempo de consulta: 8.66 ms Después de la última consulta: 0.36 ms Memoria de consulta: 0.022 MB memoria antes de consulta: 3.339 MB Filas entregadas por la consulta: 1
    Consultas duplicadas: #30  #32

    SELECT `a`.`rules` AS `rules`,`a`.`id`,`a`.`name`,`a`.`parent_id`
    
      FROM `agua_assets` AS `a`
    
      WHERE (`a`.`id` = 1 OR `a`.`name` = 'root')

    Explicar

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a	index_merge	PRIMARY,idx_asset_name	PRIMARY,idx_asset_name	4,202	NULL	2	Using union(PRIMARY,idx_asset_name); Using where

    Perfil

    Status	Duration
    Starting	0.44 ms
    checking permissions	0.03 ms
    Opening tables	0.06 ms
    After opening tables	0.02 ms
    System lock	0.01 ms
    table lock	0.02 ms
    init	0.09 ms
    Optimizing	0.04 ms
    Statistics	0.10 ms
    Preparing	0.04 ms
    Executing	0.01 ms
    Sending data	0.24 ms
    End of update loop	0.02 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.49 ms
    Updating status	0.03 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	Número de archivo y de línea
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    13	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:685
    12	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
    11	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
    10	Joomla\CMS\User\User->authorise()	JROOT/plugins/system/sourcerer/helper.php:56
    9	plgSystemSourcererHelper->__construct()	JROOT/plugins/system/sourcerer/sourcerer.php:96
    8	plgSystemSourcerer->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:1218
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
    3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

    ---

13. Tiempo de consulta: 2.12 ms Después de la última consulta: 2.65 ms Memoria de consulta: 0.022 MB memoria antes de consulta: 3.376 MB Filas entregadas por la consulta: 1

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

    Explicar

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	agua_extensions	ref	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	Using index condition

    Perfil

    Status	Duration
    Starting	0.52 ms
    checking permissions	0.03 ms
    Opening tables	0.05 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.02 ms
    init	0.06 ms
    Optimizing	0.04 ms
    Statistics	0.16 ms
    Preparing	0.06 ms
    Executing	0.01 ms
    Sending data	0.07 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.02 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.14 ms
    Updating status	0.03 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	Número de archivo y de línea
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    14	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
    13	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Igual que la llamada en la línea de abajo.
    12	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    11	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
    10	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
    9	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
    8	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
    7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
    6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
    5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1137
    4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

    ---

14. Tiempo de consulta: 1.84 ms Después de la última consulta: 0.60 ms Memoria de consulta: 0.005 MB memoria antes de consulta: 3.367 MB

    UPDATE `agua_extensions`
    
      SET `params` = '{\"mediaversion\":\"7c41ce3e813156af2d454fa42725704f\"}'
    
      WHERE `type` = 'library' 
      AND `element` = 'joomla'

    Explicar

    No es posible hacer EXPLAIN en la consulta: UPDATE `agua_extensions` SET `params` = '{\"mediaversion\":\"7c41ce3e813156af2d454fa42725704f\"}' WHERE `type` = 'library' AND `element` = 'joomla'

    Perfil

    Status	Duration
    Starting	0.68 ms
    checking permissions	0.03 ms
    Opening tables	0.05 ms
    After opening tables	0.02 ms
    System lock	0.05 ms
    table lock	0.02 ms
    init for update	0.40 ms
    Updating	0.10 ms
    End of update loop	0.02 ms
    Query end	0.02 ms
    Commit	0.02 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.02 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.15 ms
    Updating status	0.03 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	Número de archivo y de línea
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
    9	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
    8	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
    7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
    6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
    5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1137
    4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

    ---

15. Tiempo de consulta: 1.83 ms Después de la última consulta: 1.52 ms Memoria de consulta: 0.019 MB memoria antes de consulta: 3.518 MB Filas entregadas por la consulta: 2

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

    Explicar

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	agua_languages	ALL	NULL	Ninguna llave índice (INDEX KEY) pudo ser utilizada	NULL	NULL	4	Using where; Utilizando filesort

    Perfil

    Status	Duration
    Starting	0.28 ms
    checking permissions	0.02 ms
    Opening tables	0.38 ms
    After opening tables	0.04 ms
    System lock	0.01 ms
    table lock	0.02 ms
    init	0.06 ms
    Optimizing	0.03 ms
    Statistics	0.04 ms
    Preparing	0.05 ms
    Sorting result	0.02 ms
    Executing	0.01 ms
    Sending data	0.03 ms
    Creating sort index	0.12 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.14 ms
    Updating status	0.03 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	Número de archivo y de línea
    7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    6	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
    5	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/libraries/src/Application/SiteApplication.php:330
    4	Joomla\CMS\Application\SiteApplication->getParams()	JROOT/libraries/src/Application/SiteApplication.php:138
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

    ---

16. Tiempo de consulta: 2.24 ms Después de la última consulta: 1.00 ms Memoria de consulta: 0.019 MB memoria antes de consulta: 3.527 MB Filas entregadas por la consulta: 7

    SELECT id, home, template, s.params
    
      FROM agua_template_styles as s
    
      LEFT JOIN agua_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

    Explicar

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	s	ALL	idx_template,idx_client_id,idx_client_id_home	Ninguna llave índice (INDEX KEY) pudo ser utilizada	NULL	NULL	9	Using where
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	gel_aguasbca.s.template,const	1	Using index condition; Using where

    Perfil

    Status	Duration
    Starting	0.37 ms
    checking permissions	0.03 ms
    Opening tables	0.06 ms
    After opening tables	0.07 ms
    System lock	0.01 ms
    table lock	0.02 ms
    init	0.07 ms
    Optimizing	0.06 ms
    Statistics	0.19 ms
    Preparing	0.07 ms
    Executing	0.01 ms
    Sending data	0.17 ms
    End of update loop	0.02 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.02 ms
    Query end	0.01 ms
    Starting cleanup	0.02 ms
    Freeing items	0.14 ms
    Updating status	0.03 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	Número de archivo y de línea
    6	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    5	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
    4	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/libraries/src/Application/SiteApplication.php:168
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

    ---

17. Tiempo de consulta: 3.31 ms Después de la última consulta: 29.67 ms Memoria de consulta: 0.059 MB memoria antes de consulta: 4.198 MB Filas entregadas por la consulta: 11
    Consultas duplicadas: #18

    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM agua_modules AS m
    
      LEFT JOIN agua_modules_menu AS mm 
      ON mm.moduleid = m.id
    
      LEFT JOIN agua_extensions AS e 
      ON e.element = m.module 
      AND e.client_id = m.client_id
    
      WHERE m.published = 1 
      AND e.enabled = 1 
      AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2026-03-19 13:33:02') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-03-19 13:33:02') 
      AND m.access IN (1,1,5) 
      AND m.client_id = 0 
      AND (mm.menuid = 1 OR mm.menuid <= 0)
    
      ORDER BY m.position, m.ordering

    Explicar

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	m	ref	PRIMARY,published,newsfeeds	published	1	const	37	Using index condition; Using where; Utilizando filesort
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	gel_aguasbca.m.module,const	1	Using index condition; Using where
    1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	gel_aguasbca.m.id	8	Using where; Using index

    Perfil

    Status	Duration
    Starting	0.65 ms
    checking permissions	0.03 ms
    Opening tables	0.09 ms
    After opening tables	0.02 ms
    System lock	0.01 ms
    table lock	0.02 ms
    init	0.14 ms
    Optimizing	0.09 ms
    Statistics	0.19 ms
    Preparing	0.08 ms
    Sorting result	0.03 ms
    Executing	0.01 ms
    Sending data	0.03 ms
    Creating sort index	1.10 ms
    End of update loop	0.03 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.03 ms
    Query end	0.02 ms
    Starting cleanup	0.01 ms
    Freeing items	0.21 ms
    Updating status	0.05 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	Número de archivo y de línea
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    21	JDatabaseDriver->loadObjectList()	Igual que la llamada en la línea de abajo.
    20	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    19	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:441
    18	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:371
    17	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/components/com_jevents/libraries/jevmodulehelper.php:25
    16	JevModuleHelper::getVisibleModules()	JROOT/components/com_jevents/libraries/filters.php:67
    15	jevFilterProcessing->__construct()	JROOT/components/com_jevents/libraries/filters.php:257
    14	jevFilterProcessing::getInstance()	JROOT/components/com_jevents/libraries/dbmodel.php:3013
    13	JEventsDBModel->listIcalEvents()	JROOT/components/com_jevents/libraries/dbmodel.php:3384
    12	JEventsDBModel->listIcalEventsByMonth()	JROOT/components/com_jevents/libraries/datamodel.php:285
    11	JEventsDataModel->getCalendarData()	JROOT/components/com_jevents/views/flat/month/view.html.php:39
    10	flatViewMonth->calendar()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:94
    9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/month.php:82
    8	MonthController->calendar()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jevents/jevents.php:365
    6	require_once JROOT/components/com_jevents/jevents.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

    ---

18. Tiempo de consulta: 2.57 ms Después de la última consulta: 0.94 ms Memoria de consulta: 0.059 MB memoria antes de consulta: 4.249 MB Filas entregadas por la consulta: 11
    Consultas duplicadas: #17

    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM agua_modules AS m
    
      LEFT JOIN agua_modules_menu AS mm 
      ON mm.moduleid = m.id
    
      LEFT JOIN agua_extensions AS e 
      ON e.element = m.module 
      AND e.client_id = m.client_id
    
      WHERE m.published = 1 
      AND e.enabled = 1 
      AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2026-03-19 13:33:02') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-03-19 13:33:02') 
      AND m.access IN (1,1,5) 
      AND m.client_id = 0 
      AND (mm.menuid = 1 OR mm.menuid <= 0)
    
      ORDER BY m.position, m.ordering

    Explicar

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	m	ref	PRIMARY,published,newsfeeds	published	1	const	37	Using index condition; Using where; Utilizando filesort
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	gel_aguasbca.m.module,const	1	Using index condition; Using where
    1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	gel_aguasbca.m.id	8	Using where; Using index

    Perfil

    Status	Duration
    Starting	0.37 ms
    checking permissions	0.02 ms
    Opening tables	0.06 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.02 ms
    init	0.11 ms
    Optimizing	0.07 ms
    Statistics	0.18 ms
    Preparing	0.08 ms
    Sorting result	0.03 ms
    Executing	0.01 ms
    Sending data	0.02 ms
    Creating sort index	0.97 ms
    End of update loop	0.03 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.02 ms
    Query end	0.03 ms
    Starting cleanup	0.01 ms
    Freeing items	0.24 ms
    Updating status	0.03 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	Número de archivo y de línea
    24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    23	JDatabaseDriver->loadObjectList()	Igual que la llamada en la línea de abajo.
    22	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    21	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:441
    20	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:371
    19	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:37
    18	Joomla\CMS\Helper\ModuleHelper::getModule()	JROOT/components/com_jevents/libraries/filters.php:453
    17	jevFilter->__construct()	JROOT/components/com_jevents/libraries/filters/Published.php:83
    16	jevPublishedFilter->__construct()	JROOT/components/com_jevents/libraries/filters.php:186
    15	jevFilterProcessing->__construct()	JROOT/components/com_jevents/libraries/filters.php:257
    14	jevFilterProcessing::getInstance()	JROOT/components/com_jevents/libraries/dbmodel.php:3013
    13	JEventsDBModel->listIcalEvents()	JROOT/components/com_jevents/libraries/dbmodel.php:3384
    12	JEventsDBModel->listIcalEventsByMonth()	JROOT/components/com_jevents/libraries/datamodel.php:285
    11	JEventsDataModel->getCalendarData()	JROOT/components/com_jevents/views/flat/month/view.html.php:39
    10	flatViewMonth->calendar()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:94
    9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/month.php:82
    8	MonthController->calendar()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jevents/jevents.php:365
    6	require_once JROOT/components/com_jevents/jevents.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

    ---

19. Tiempo de consulta: 3.81 ms Después de la última consulta: 0.64 ms Memoria de consulta: 0.030 MB memoria antes de consulta: 4.283 MB Filas entregadas por la consulta: 18

    SHOW FULL COLUMNS 
      FROM `agua_jev_users`

    Explicar

    No es posible hacer EXPLAIN en la consulta: SHOW FULL COLUMNS FROM `agua_jev_users`

    Perfil

    Status	Duration
    Starting	0.24 ms
    checking permissions	0.01 ms
    closing tables	0.01 ms
    checking permissions	0.02 ms
    Opening tables	0.98 ms
    After opening tables	0.03 ms
    System lock	0.01 ms
    table lock	0.02 ms
    init	0.04 ms
    Optimizing	0.02 ms
    Statistics	0.03 ms
    Preparing	0.04 ms
    Executing	0.01 ms
    Filling schema table	0.02 ms
    Opening tables	0.04 ms
    After opening tables	0.01 ms
    checking permissions	0.15 ms
    closing tables	0.01 ms
    checking permissions	0.01 ms
    Executing	0.01 ms
    Sending data	0.07 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Removing tmp table	1.31 ms
    closing tables	0.05 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.24 ms
    Updating status	0.03 ms
    Reset for next command	0.02 ms

    Call Stack

    #	Caller	Número de archivo y de línea
    24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    23	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
    22	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
    21	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
    20	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_jevents/tables/jevuser.php:75
    19	TableUser->__construct()	JROOT/components/com_jevents/libraries/helper.php:1851
    18	JEVHelper::getAuthorisedUser()	JROOT/components/com_jevents/libraries/helper.php:1706
    17	JEVHelper::isEventCreator()	JROOT/components/com_jevents/libraries/filters/Published.php:86
    16	jevPublishedFilter->__construct()	JROOT/components/com_jevents/libraries/filters.php:186
    15	jevFilterProcessing->__construct()	JROOT/components/com_jevents/libraries/filters.php:257
    14	jevFilterProcessing::getInstance()	JROOT/components/com_jevents/libraries/dbmodel.php:3013
    13	JEventsDBModel->listIcalEvents()	JROOT/components/com_jevents/libraries/dbmodel.php:3384
    12	JEventsDBModel->listIcalEventsByMonth()	JROOT/components/com_jevents/libraries/datamodel.php:285
    11	JEventsDataModel->getCalendarData()	JROOT/components/com_jevents/views/flat/month/view.html.php:39
    10	flatViewMonth->calendar()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:94
    9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/month.php:82
    8	MonthController->calendar()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jevents/jevents.php:365
    6	require_once JROOT/components/com_jevents/jevents.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

    ---

20. Tiempo de consulta: 2.23 ms Después de la última consulta: 2.13 ms Memoria de consulta: 0.028 MB memoria antes de consulta: 4.334 MB Filas entregadas por la consulta: 4

    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
    
      FROM `agua_categories` AS `c`
    
      WHERE (c.extension='com_jevents' OR c.extension='system') 
      AND c.access IN (1,1,5) 
      AND c.published = 1
    
      ORDER BY c.lft

    Explicar

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	c	range	cat_idx,idx_access	cat_idx	207	NULL	6	Using index condition; Utilizando filesort

    Perfil

    Status	Duration
    Starting	0.47 ms
    checking permissions	0.02 ms
    Opening tables	0.08 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.02 ms
    init	0.12 ms
    Optimizing	0.06 ms
    Statistics	0.19 ms
    Preparing	0.06 ms
    Sorting result	0.02 ms
    Executing	0.01 ms
    Sending data	0.04 ms
    Creating sort index	0.20 ms
    End of update loop	0.02 ms
    Query end	0.01 ms
    Commit	0.02 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.02 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.19 ms
    Updating status	0.03 ms
    Reset for next command	0.02 ms

    Call Stack

    #	Caller	Número de archivo y de línea
    23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    22	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
    21	Joomla\CMS\Categories\Categories->_load()	JROOT/components/com_jevents/helpers/category.php:53
    20	JEventsCategories->_load()	JROOT/libraries/src/Categories/Categories.php:184
    19	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_jevents/libraries/dbmodel.php:427
    18	JEventsDBModel->accessibleCategoryList()	JROOT/components/com_jevents/libraries/datamodel.php:1021
    17	JEventsDataModel->accessibleCategoryList()	JROOT/components/com_jevents/libraries/filters/Category.php:47
    16	jevCategoryFilter->__construct()	JROOT/components/com_jevents/libraries/filters.php:186
    15	jevFilterProcessing->__construct()	JROOT/components/com_jevents/libraries/filters.php:257
    14	jevFilterProcessing::getInstance()	JROOT/components/com_jevents/libraries/dbmodel.php:3013
    13	JEventsDBModel->listIcalEvents()	JROOT/components/com_jevents/libraries/dbmodel.php:3384
    12	JEventsDBModel->listIcalEventsByMonth()	JROOT/components/com_jevents/libraries/datamodel.php:285
    11	JEventsDataModel->getCalendarData()	JROOT/components/com_jevents/views/flat/month/view.html.php:39
    10	flatViewMonth->calendar()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:94
    9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/month.php:82
    8	MonthController->calendar()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jevents/jevents.php:365
    6	require_once JROOT/components/com_jevents/jevents.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

    ---

21. Tiempo de consulta: 1.45 ms Después de la última consulta: 0.60 ms Memoria de consulta: 0.025 MB memoria antes de consulta: 4.366 MB Filas entregadas por la consulta: 3

    SELECT c.id
    
      FROM agua_categories AS c
    
      WHERE c.access   IN (1,1,5)
     
      AND c.published = 1
      
      AND c.language in ('es-CO','*')
     
      AND c.extension = 'com_jevents'
     
    
      ORDER BY c.lft asc

    Explicar

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	c	range	cat_idx,idx_access,idx_language	cat_idx	207	NULL	4	Using index condition; Using where; Utilizando filesort

    Perfil

    Status	Duration
    Starting	0.24 ms
    checking permissions	0.02 ms
    Opening tables	0.03 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.05 ms
    Optimizing	0.04 ms
    Statistics	0.13 ms
    Preparing	0.06 ms
    Sorting result	0.02 ms
    Executing	0.01 ms
    Sending data	0.01 ms
    Creating sort index	0.10 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.18 ms
    Updating status	0.02 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	Número de archivo y de línea
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    19	JDatabaseDriver->loadColumn()	JROOT/components/com_jevents/libraries/dbmodel.php:563
    18	JEventsDBModel->accessibleCategoryList()	JROOT/components/com_jevents/libraries/datamodel.php:1021
    17	JEventsDataModel->accessibleCategoryList()	JROOT/components/com_jevents/libraries/filters/Category.php:47
    16	jevCategoryFilter->__construct()	JROOT/components/com_jevents/libraries/filters.php:186
    15	jevFilterProcessing->__construct()	JROOT/components/com_jevents/libraries/filters.php:257
    14	jevFilterProcessing::getInstance()	JROOT/components/com_jevents/libraries/dbmodel.php:3013
    13	JEventsDBModel->listIcalEvents()	JROOT/components/com_jevents/libraries/dbmodel.php:3384
    12	JEventsDBModel->listIcalEventsByMonth()	JROOT/components/com_jevents/libraries/datamodel.php:285
    11	JEventsDataModel->getCalendarData()	JROOT/components/com_jevents/views/flat/month/view.html.php:39
    10	flatViewMonth->calendar()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:94
    9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/month.php:82
    8	MonthController->calendar()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jevents/jevents.php:365
    6	require_once JROOT/components/com_jevents/jevents.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

    ---

22. Tiempo de consulta: 2.27 ms Después de la última consulta: 0.70 ms Memoria de consulta: 0.023 MB memoria antes de consulta: 4.386 MB Filas entregadas por la consulta: 1

    SELECT c.id
    
      FROM agua_categories AS c
    
      WHERE c.access   IN (1,1,5)
     
      AND c.published = 1
      
      AND c.language in ('es-CO','*')
     
      AND c.extension = 'com_jevents'
     
      AND ((c.lft>=169 
      AND c.rgt<=170 ))
    
      ORDER BY c.lft asc

    Explicar

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	c	ref|filter	cat_idx,idx_access,idx_left_right,idx_language	cat_idx|idx_left_right	203|4	const,const	4 (4%)	Using index condition; Using where; Utilizando filesort; Using rowid filter

    Perfil

    Status	Duration
    Starting	0.29 ms
    checking permissions	0.02 ms
    Opening tables	0.04 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.05 ms
    Optimizing	0.04 ms
    Statistics	0.17 ms
    Preparing	0.06 ms
    Sorting result	0.03 ms
    Executing	0.01 ms
    Sending data	0.07 ms
    Creating sort index	0.08 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.02 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.02 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.17 ms
    Updating status	0.03 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	Número de archivo y de línea
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    15	JDatabaseDriver->loadColumn()	JROOT/components/com_jevents/libraries/dbmodel.php:563
    14	JEventsDBModel->accessibleCategoryList()	JROOT/components/com_jevents/libraries/dbmodel.php:3044
    13	JEventsDBModel->listIcalEvents()	JROOT/components/com_jevents/libraries/dbmodel.php:3384
    12	JEventsDBModel->listIcalEventsByMonth()	JROOT/components/com_jevents/libraries/datamodel.php:285
    11	JEventsDataModel->getCalendarData()	JROOT/components/com_jevents/views/flat/month/view.html.php:39
    10	flatViewMonth->calendar()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:94
    9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/month.php:82
    8	MonthController->calendar()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jevents/jevents.php:365
    6	require_once JROOT/components/com_jevents/jevents.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

    ---

23. Tiempo de consulta: 2.03 ms Después de la última consulta: 0.32 ms Memoria de consulta: 0.039 MB memoria antes de consulta: 4.392 MB Filas entregadas por la consulta: 0

    SELECT det.evdet_id as detailid, rpt.*, ev.*, rr.*, det.* , ev.rawdata as evrawdata,  ev.state as published, ev.created as created 
     , YEAR(rpt.startrepeat) as yup, MONTH(rpt.startrepeat ) as mup, DAYOFMONTH(rpt.startrepeat ) as dup
     , YEAR(rpt.endrepeat  ) as ydn, MONTH(rpt.endrepeat   ) as mdn, DAYOFMONTH(rpt.endrepeat   ) as ddn
     , HOUR(rpt.startrepeat) as hup, MINUTE(rpt.startrepeat ) as minup, SECOND(rpt.startrepeat ) as sup
     , HOUR(rpt.endrepeat  ) as hdn, MINUTE(rpt.endrepeat   ) as mindn, SECOND(rpt.endrepeat   ) as sdn
     
      FROM agua_jevents_repetition as rpt
     
      INNER JOIN agua_jevents_vevent as ev 
      ON rpt.eventid = ev.ev_id
     
      INNER JOIN agua_jevents_icsfile as icsf 
      ON icsf.ics_id=ev.icsid 
     
      INNER JOIN agua_jevents_vevdetail as det 
      ON det.evdet_id = rpt.eventdetail_id
     
      LEFT JOIN agua_jevents_rrule as rr 
      ON rr.eventid = rpt.eventid
     
      WHERE ev.catid IN(-1,142)
     
      AND rpt.endrepeat >= '2019-03-01 00:00:00' 
      AND rpt.startrepeat <= '2019-03-31 23:59:59' 
     
      AND NOT (rpt.startrepeat < '2019-03-01 00:00:00' 
      AND det.multiday=0)  
      AND ev.state=1
     
      AND ev.access IN (1,1,5)  
      AND icsf.state=1 
      AND icsf.access IN (1,1,5)

    Explicar

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	icsf	ref	PRIMARY,stateidx	stateidx	1	const	1	Using where
    1	SIMPLE	ev	ref	PRIMARY,icsid,stateidx,evaccess	icsid	4	gel_aguasbca.icsf.ics_id	73	Using where
    1	SIMPLE	rpt	ref|filter	eventid,eventstart,eventend,eventdetail,startrepeat,startend,endrepeat	eventid|startrepeat	4|5	gel_aguasbca.ev.ev_id	1 (40%)	Using where; Using rowid filter
    1	SIMPLE	det	eq_ref	PRIMARY,multiday	PRIMARY	4	gel_aguasbca.rpt.eventdetail_id	1	Using where
    1	SIMPLE	rr	ref	eventid	eventid	4	gel_aguasbca.ev.ev_id	1

    Perfil

    Status	Duration
    Starting	0.34 ms
    checking permissions	0.01 ms
    Opening tables	0.08 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.14 ms
    Optimizing	0.06 ms
    Statistics	0.23 ms
    Preparing	0.09 ms
    Executing	0.01 ms
    Sending data	0.56 ms
    End of update loop	0.02 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.02 ms
    Query end	0.02 ms
    Starting cleanup	0.01 ms
    Freeing items	0.16 ms
    Updating status	0.03 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	Número de archivo y de línea
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    15	JDatabaseDriver->loadObjectList()	JROOT/components/com_jevents/libraries/dbmodel.php:3305
    14	JEventsDBModel->_cachedlistIcalEvents()	JROOT/components/com_jevents/libraries/dbmodel.php:3236
    13	JEventsDBModel->listIcalEvents()	JROOT/components/com_jevents/libraries/dbmodel.php:3384
    12	JEventsDBModel->listIcalEventsByMonth()	JROOT/components/com_jevents/libraries/datamodel.php:285
    11	JEventsDataModel->getCalendarData()	JROOT/components/com_jevents/views/flat/month/view.html.php:39
    10	flatViewMonth->calendar()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:94
    9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/month.php:82
    8	MonthController->calendar()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jevents/jevents.php:365
    6	require_once JROOT/components/com_jevents/jevents.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

    ---

24. Tiempo de consulta: 4.35 ms Después de la última consulta: 6.57 ms Memoria de consulta: 0.036 MB memoria antes de consulta: 4.593 MB Filas entregadas por la consulta: 31

    SHOW FULL COLUMNS 
      FROM `agua_content`

    Explicar

    No es posible hacer EXPLAIN en la consulta: SHOW FULL COLUMNS FROM `agua_content`

    Perfil

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

    Call Stack

    #	Caller	Número de archivo y de línea
    25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    24	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
    23	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
    22	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
    21	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/Content.php:39
    20	Joomla\CMS\Table\Content->__construct()	JROOT/libraries/src/Table/Table.php:328
    19	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_jevents/views/default/helpers/defaultloadmodules.php:15
    18	DefaultLoadModules()	JROOT/components/com_jevents/views/default/abstract/abstract.php:187
    17	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/flat/helpers/flatviewhelperheader16.php:17
    16	FlatViewHelperHeader16()	JROOT/components/com_jevents/views/default/abstract/abstract.php:187
    15	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/flat/helpers/flatviewhelperheader.php:7
    14	FlatViewHelperHeader()	JROOT/components/com_jevents/views/default/abstract/abstract.php:187
    13	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/flat/month/tmpl/calendar.php:4
    12	include JROOT/components/com_jevents/views/flat/month/tmpl/calendar.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    10	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:133
    9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/month.php:82
    8	MonthController->calendar()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jevents/jevents.php:365
    6	require_once JROOT/components/com_jevents/jevents.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

    ---

25. Tiempo de consulta: 8.17 ms Después de la última consulta: 2.54 ms Memoria de consulta: 0.012 MB memoria antes de consulta: 4.671 MB

    CREATE TABLE IF NOT EXISTS `agua_powr` ( `data_type` VARCHAR(50) NOT NULL, `value` VARCHAR(50) NOT NULL, PRIMARY KEY (`data_type`)) ENGINE=InnoDB DEFAULT CHARSET=utf8;

    Explicar

    No es posible hacer EXPLAIN en la consulta: CREATE TABLE IF NOT EXISTS `agua_powr` ( `data_type` VARCHAR(50) NOT NULL, `value` VARCHAR(50) NOT NULL, PRIMARY KEY (`data_type`)) ENGINE=InnoDB DEFAULT CHARSET=utf8;

    Perfil

    Status	Duration
    Starting	0.58 ms
    checking permissions	0.03 ms
    Opening tables	0.06 ms
    After opening tables	0.01 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.12 ms
    Updating status	0.02 ms
    Reset for next command	0.02 ms

    Call Stack

    #	Caller	Número de archivo y de línea
    25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
    24	JDatabase->query()	JROOT/plugins/content/powrshortcodes/powrshortcodes.php:114
    23	PowrHelper->get_powr_token()	JROOT/plugins/content/powrshortcodes/powrshortcodes.php:90
    22	PowrHelper->__construct()	JROOT/plugins/content/powrshortcodes/powrshortcodes.php:168
    21	require_once JROOT/plugins/content/powrshortcodes/powrshortcodes.php	JROOT/libraries/src/Plugin/PluginHelper.php:251
    20	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
    19	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/components/com_jevents/views/default/helpers/defaultloadmodules.php:21
    18	DefaultLoadModules()	JROOT/components/com_jevents/views/default/abstract/abstract.php:187
    17	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/flat/helpers/flatviewhelperheader16.php:17
    16	FlatViewHelperHeader16()	JROOT/components/com_jevents/views/default/abstract/abstract.php:187
    15	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/flat/helpers/flatviewhelperheader.php:7
    14	FlatViewHelperHeader()	JROOT/components/com_jevents/views/default/abstract/abstract.php:187
    13	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/flat/month/tmpl/calendar.php:4
    12	include JROOT/components/com_jevents/views/flat/month/tmpl/calendar.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    10	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:133
    9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/month.php:82
    8	MonthController->calendar()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jevents/jevents.php:365
    6	require_once JROOT/components/com_jevents/jevents.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

    ---

26. Tiempo de consulta: 1.31 ms Después de la última consulta: 0.28 ms Memoria de consulta: 0.028 MB memoria antes de consulta: 4.683 MB Filas entregadas por la consulta: 1

    SELECT value 
      FROM agua_powr 
      WHERE data_type = 'powr_token'

    Explicar

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	agua_powr	const	PRIMARY	PRIMARY	152	const	1

    Perfil

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

    Call Stack

    #	Caller	Número de archivo y de línea
    25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
    24	JDatabaseDriver->loadAssoc()	JROOT/plugins/content/powrshortcodes/powrshortcodes.php:122
    23	PowrHelper->get_powr_token()	JROOT/plugins/content/powrshortcodes/powrshortcodes.php:90
    22	PowrHelper->__construct()	JROOT/plugins/content/powrshortcodes/powrshortcodes.php:168
    21	require_once JROOT/plugins/content/powrshortcodes/powrshortcodes.php	JROOT/libraries/src/Plugin/PluginHelper.php:251
    20	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
    19	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/components/com_jevents/views/default/helpers/defaultloadmodules.php:21
    18	DefaultLoadModules()	JROOT/components/com_jevents/views/default/abstract/abstract.php:187
    17	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/flat/helpers/flatviewhelperheader16.php:17
    16	FlatViewHelperHeader16()	JROOT/components/com_jevents/views/default/abstract/abstract.php:187
    15	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/flat/helpers/flatviewhelperheader.php:7
    14	FlatViewHelperHeader()	JROOT/components/com_jevents/views/default/abstract/abstract.php:187
    13	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/flat/month/tmpl/calendar.php:4
    12	include JROOT/components/com_jevents/views/flat/month/tmpl/calendar.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    10	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:133
    9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/month.php:82
    8	MonthController->calendar()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jevents/jevents.php:365
    6	require_once JROOT/components/com_jevents/jevents.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

    ---

27. Tiempo de consulta: 4.56 ms Después de la última consulta: 8.56 ms Memoria de consulta: 0.028 MB memoria antes de consulta: 4.898 MB Filas entregadas por la consulta: 0

    SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
    
      FROM agua_fields AS a
    
      LEFT JOIN `agua_languages` AS l 
      ON l.lang_code = a.language
    
      LEFT JOIN agua_users AS uc 
      ON uc.id=a.checked_out
    
      LEFT JOIN agua_viewlevels AS ag 
      ON ag.id = a.access
    
      LEFT JOIN agua_users AS ua 
      ON ua.id = a.created_user_id
    
      LEFT JOIN agua_fields_groups AS g 
      ON g.id = a.group_id
    
      WHERE a.context = 'com_content.article' 
      AND a.access IN (1,1,5) 
      AND (a.group_id = 0 OR g.access IN (1,1,5)) 
      AND a.state = 1 
      AND (a.group_id = 0 OR g.state = 1)
    
      ORDER BY a.ordering ASC

    Explicar

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	Using where; Using temporary; Utilizando filesort
    1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	gel_aguasbca.a.language	1	Using where
    1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	gel_aguasbca.a.checked_out	1
    1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	gel_aguasbca.a.access	1	Using where
    1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	gel_aguasbca.a.created_user_id	1	Using where
    1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	gel_aguasbca.a.group_id	1	Using where

    Perfil

    Status	Duration
    Starting	0.76 ms
    checking permissions	0.06 ms
    Opening tables	0.14 ms
    After opening tables	0.02 ms
    System lock	0.02 ms
    table lock	0.02 ms
    init	0.15 ms
    Optimizing	0.13 ms
    Statistics	0.21 ms
    Preparing	0.07 ms
    Creating tmp table	0.09 ms
    Sorting result	0.03 ms
    Executing	0.01 ms
    Sending data	1.10 ms
    Creating sort index	0.10 ms
    Removing tmp table	0.24 ms
    Creating sort index	0.03 ms
    End of update loop	0.03 ms
    Query end	0.01 ms
    Commit	0.03 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.02 ms
    Query end	0.02 ms
    Starting cleanup	0.01 ms
    Freeing items	0.19 ms
    Updating status	0.04 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	Número de archivo y de línea
    28	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    27	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
    26	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
    25	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
    24	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
    23	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
    22	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    21	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    20	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    19	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/components/com_jevents/views/default/helpers/defaultloadmodules.php:23
    18	DefaultLoadModules()	JROOT/components/com_jevents/views/default/abstract/abstract.php:187
    17	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/flat/helpers/flatviewhelperheader16.php:17
    16	FlatViewHelperHeader16()	JROOT/components/com_jevents/views/default/abstract/abstract.php:187
    15	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/flat/helpers/flatviewhelperheader.php:7
    14	FlatViewHelperHeader()	JROOT/components/com_jevents/views/default/abstract/abstract.php:187
    13	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/flat/month/tmpl/calendar.php:4
    12	include JROOT/components/com_jevents/views/flat/month/tmpl/calendar.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    10	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:133
    9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/month.php:82
    8	MonthController->calendar()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jevents/jevents.php:365
    6	require_once JROOT/components/com_jevents/jevents.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

    ---

28. Tiempo de consulta: 1.87 ms Después de la última consulta: 18.52 ms Memoria de consulta: 0.027 MB memoria antes de consulta: 5.007 MB Filas entregadas por la consulta: 3

    SELECT c.* 
      FROM agua_categories as c 
      WHERE extension='com_jevents' 
      AND  c.access   IN (1,1,5)
      
      AND c.language in ('es-CO','*') 
      AND c.published = 1
     
      ORDER BY c.lft

    Explicar

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	c	range	cat_idx,idx_access,idx_language	cat_idx	207	NULL	4	Using index condition; Using where; Utilizando filesort

    Perfil

    Status	Duration
    Starting	0.40 ms
    checking permissions	0.02 ms
    Opening tables	0.04 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.02 ms
    init	0.07 ms
    Optimizing	0.04 ms
    Statistics	0.16 ms
    Preparing	0.04 ms
    Sorting result	0.02 ms
    Executing	0.01 ms
    Sending data	0.03 ms
    Creating sort index	0.14 ms
    End of update loop	0.02 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.02 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.53 ms
    Updating status	0.04 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	Número de archivo y de línea
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    19	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_jevents_legend/tmpl/default/legend.php:277
    18	DefaultModLegendView->getCategoryHierarchy()	JROOT/modules/mod_jevents_legend/tmpl/flat/legend.php:109
    17	FlatModLegendView->displayCalendarLegend()	JROOT/components/com_jevents/views/default/helpers/defaulteventslegend.php:30
    16	DefaultEventsLegend()	JROOT/components/com_jevents/views/default/abstract/abstract.php:187
    15	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/flat/month/tmpl/calendar_body.php:121
    14	include JROOT/components/com_jevents/views/flat/month/tmpl/calendar_body.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_jevents/views/flat/month/tmpl/calendar.php:7
    12	include JROOT/components/com_jevents/views/flat/month/tmpl/calendar.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    10	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:133
    9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/month.php:82
    8	MonthController->calendar()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jevents/jevents.php:365
    6	require_once JROOT/components/com_jevents/jevents.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

    ---

29. Tiempo de consulta: 1.38 ms Después de la última consulta: 14.38 ms Memoria de consulta: 0.022 MB memoria antes de consulta: 5.111 MB Filas entregadas por la consulta: 1

    SELECT id
    
      FROM agua_assets
    
      WHERE parent_id = 0

    Explicar

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	agua_assets	ref	idx_parent_id	idx_parent_id	4	const	1	Using index

    Perfil

    Status	Duration
    Starting	0.42 ms
    checking permissions	0.02 ms
    Opening tables	0.06 ms
    After opening tables	0.02 ms
    System lock	0.01 ms
    table lock	0.02 ms
    init	0.05 ms
    Optimizing	0.04 ms
    Statistics	0.12 ms
    Preparing	0.05 ms
    Executing	0.01 ms
    Sending data	0.06 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Query end	0.09 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.14 ms
    Updating status	0.02 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	Número de archivo y de línea
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    14	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Table/Nested.php:1219
    13	Joomla\CMS\Table\Nested->getRootId()	JROOT/libraries/src/Access/Access.php:742
    12	Joomla\CMS\Access\Access::cleanAssetKey()	JROOT/libraries/src/Access/Access.php:535
    11	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
    10	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
    9	Joomla\CMS\User\User->authorise()	JROOT/administrator/components/com_rstbox/helpers/helper.php:228
    8	EBHelper::getBoxes()	JROOT/plugins/system/rstbox/rstbox.php:78
    7	PlgSystemRstBox->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

    ---

30. Tiempo de consulta: 0.95 ms Después de la última consulta: 0.21 ms Memoria de consulta: 0.022 MB memoria antes de consulta: 5.118 MB Filas entregadas por la consulta: 1
    Consultas duplicadas: #12  #32

    SELECT `a`.`rules` AS `rules`,`a`.`id`,`a`.`name`,`a`.`parent_id`
    
      FROM `agua_assets` AS `a`
    
      WHERE (`a`.`id` = 1 OR `a`.`name` = 'root')

    Explicar

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a	index_merge	PRIMARY,idx_asset_name	PRIMARY,idx_asset_name	4,202	NULL	2	Using union(PRIMARY,idx_asset_name); Using where

    Perfil

    Status	Duration
    Starting	0.21 ms
    checking permissions	0.02 ms
    Opening tables	0.03 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.03 ms
    Optimizing	0.02 ms
    Statistics	0.09 ms
    Preparing	0.03 ms
    Executing	0.01 ms
    Sending data	0.17 ms
    End of update loop	0.02 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.13 ms
    Updating status	0.02 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	Número de archivo y de línea
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    12	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:685
    11	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
    10	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
    9	Joomla\CMS\User\User->authorise()	JROOT/administrator/components/com_rstbox/helpers/helper.php:228
    8	EBHelper::getBoxes()	JROOT/plugins/system/rstbox/rstbox.php:78
    7	PlgSystemRstBox->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

    ---

31. Tiempo de consulta: 0.80 ms Después de la última consulta: 0.14 ms Memoria de consulta: 0.021 MB memoria antes de consulta: 5.122 MB Filas entregadas por la consulta: 1

    select b.* 
      from agua_rstbox b 
      where b.published = 1  
      AND b.testmode=0

    Explicar

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	b	ALL	NULL	Ninguna llave índice (INDEX KEY) pudo ser utilizada	NULL	NULL	3	Using where

    Perfil

    Status	Duration
    Starting	0.19 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.03 ms
    Optimizing	0.04 ms
    Statistics	0.02 ms
    Preparing	0.02 ms
    Executing	0.01 ms
    Sending data	0.08 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.02 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.14 ms
    Updating status	0.02 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	Número de archivo y de línea
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    9	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_rstbox/helpers/helper.php:242
    8	EBHelper::getBoxes()	JROOT/plugins/system/rstbox/rstbox.php:78
    7	PlgSystemRstBox->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

    ---

32. Tiempo de consulta: 0.92 ms Después de la última consulta: 0.66 ms Memoria de consulta: 0.023 MB memoria antes de consulta: 5.153 MB Filas entregadas por la consulta: 1
    Consultas duplicadas: #12  #30

    SELECT `a`.`rules` AS `rules`,`a`.`id`,`a`.`name`,`a`.`parent_id`
    
      FROM `agua_assets` AS `a`
    
      WHERE (`a`.`id` = 1 OR `a`.`name` = 'root')

    Explicar

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a	index_merge	PRIMARY,idx_asset_name	PRIMARY,idx_asset_name	4,202	NULL	2	Using union(PRIMARY,idx_asset_name); Using where

    Perfil

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

    Call Stack

    #	Caller	Número de archivo y de línea
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    15	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:685
    14	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
    13	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
    12	Joomla\CMS\User\User->authorise()	JROOT/administrator/components/com_rstbox/helpers/assignments.php:139
    11	ebAssignments->passCookie()	JROOT/administrator/components/com_rstbox/helpers/assignments.php:99
    10	ebAssignments->passAll()	JROOT/administrator/components/com_rstbox/helpers/helper.php:203
    9	EBHelper::checkPublishingAssignments()	JROOT/administrator/components/com_rstbox/helpers/helper.php:245
    8	EBHelper::getBoxes()	JROOT/plugins/system/rstbox/rstbox.php:78
    7	PlgSystemRstBox->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

    ---

33. Tiempo de consulta: 2.37 ms Después de la última consulta: 28.63 ms Memoria de consulta: 0.025 MB memoria antes de consulta: 5.554 MB Filas entregadas por la consulta: 2

    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
    
      FROM `agua_categories` AS `s`
    
      INNER JOIN `agua_categories` AS `c` 
      ON (s.lft <= c.lft 
      AND c.lft < s.rgt) OR (c.lft < s.lft 
      AND s.rgt < c.rgt)
    
      WHERE (c.extension='com_dpcalendar' OR c.extension='system') 
      AND c.access IN (1,1,5) 
      AND c.published = 1 
      AND s.id = 146
    
      ORDER BY c.lft

    Explicar

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1
    1	SIMPLE	c	range	cat_idx,idx_access,idx_left_right	cat_idx	207	NULL	4	Using index condition; Using where; Utilizando filesort

    Perfil

    Status	Duration
    Starting	0.82 ms
    checking permissions	0.03 ms
    Opening tables	0.07 ms
    After opening tables	0.02 ms
    System lock	0.01 ms
    table lock	0.02 ms
    init	0.12 ms
    Optimizing	0.06 ms
    Statistics	0.32 ms
    Preparing	0.02 ms
    Unlocking tables	0.01 ms
    Preparing	0.05 ms
    Sorting result	0.02 ms
    Executing	0.01 ms
    Sending data	0.03 ms
    Creating sort index	0.13 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.06 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.18 ms
    Updating status	0.03 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	Número de archivo y de línea
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    15	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
    14	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
    13	Joomla\CMS\Categories\Categories->get()	JROOT/administrator/components/com_dpcalendar/libraries/dpcalendar/DPCalendar/Helper/DPCalendarHelper.php:42
    12	DPCalendar\Helper\DPCalendarHelper::getCalendar()	JROOT/components/com_dpcalendar/models/calendar.php:68
    11	DPCalendarModelCalendar->getItems()	JROOT/modules/mod_dpcalendar_mini/mod_dpcalendar_mini.php:42
    10	include JROOT/modules/mod_dpcalendar_mini/mod_dpcalendar_mini.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:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1140
    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:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

    ---

34. Tiempo de consulta: 1.67 ms Después de la última consulta: 0.37 ms Memoria de consulta: 0.025 MB memoria antes de consulta: 5.572 MB Filas entregadas por la consulta: 3

    SELECT `id`,`name`,`rules`,`parent_id`
    
      FROM `agua_assets`
    
      WHERE `name` LIKE 'com_dpcalendar.%' OR `name` = 'com_dpcalendar' OR `parent_id` = 0

    Explicar

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	agua_assets	ALL	idx_asset_name,idx_parent_id	Ninguna llave índice (INDEX KEY) pudo ser utilizada	NULL	NULL	586	Using where

    Perfil

    Status	Duration
    Starting	0.27 ms
    checking permissions	0.02 ms
    Opening tables	0.04 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.04 ms
    Optimizing	0.02 ms
    Statistics	0.27 ms
    Preparing	0.03 ms
    Executing	0.01 ms
    Sending data	0.48 ms
    End of update loop	0.02 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.18 ms
    Updating status	0.04 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	Número de archivo y de línea
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:359
    17	Joomla\CMS\Access\Access::preloadPermissions()	JROOT/libraries/src/Access/Access.php:226
    16	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:540
    15	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
    14	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
    13	Joomla\CMS\User\User->authorise()	JROOT/administrator/components/com_dpcalendar/libraries/dpcalendar/DPCalendar/Helper/DPCalendarHelper.php:54
    12	DPCalendar\Helper\DPCalendarHelper::getCalendar()	JROOT/components/com_dpcalendar/models/calendar.php:68
    11	DPCalendarModelCalendar->getItems()	JROOT/modules/mod_dpcalendar_mini/mod_dpcalendar_mini.php:42
    10	include JROOT/modules/mod_dpcalendar_mini/mod_dpcalendar_mini.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:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1140
    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:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

    ---