Información Presupuestal y Contable

INFORMACION PRESUPUESTAL

2024

Estados Financieros

PLAN ANUAL MENSUALIZADO DE CAJA

VIGENCIA 2022

RESOLUCION 008 PLAN MENSUALIZADO DE CAJA VIGENCIA 2024

Consola de depuración de Joomla!

Sesión

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

Información de perfil

Hora

Memoria

Hora: 44.69 ms / 44.69 ms Memoria: 2.034 MB / 2.41 MB Application: afterLoad

Hora: 222.30 ms / 266.99 ms Memoria: 5.800 MB / 8.21 MB Application: afterInitialise

Hora: 65.97 ms / 332.96 ms Memoria: 2.147 MB / 10.36 MB Application: afterRoute

Hora: 18.12 ms / 351.08 ms Memoria: 0.301 MB / 10.66 MB Application: beforeRenderComponent com_content

Hora: 11.69 ms / 362.77 ms Memoria: 0.527 MB / 11.19 MB Application: Before Access::preloadComponents (all components)

Hora: 1.97 ms / 364.74 ms Memoria: 0.065 MB / 11.25 MB Application: After Access::preloadComponents (all components)

Hora: 0.06 ms / 364.80 ms Memoria: -0.003 MB / 11.25 MB Application: Before Access::preloadPermissions (com_content)

Hora: 1.65 ms / 366.46 ms Memoria: 0.044 MB / 11.29 MB Application: After Access::preloadPermissions (com_content)

Hora: 0.05 ms / 366.51 ms Memoria: -0.002 MB / 11.29 MB Application: Before Access::getAssetRules (id:68 name:com_content.article.6)

Hora: 1.07 ms / 367.58 ms Memoria: 0.028 MB / 11.32 MB Application: After Access::getAssetRules (id:68 name:com_content.article.6)

Hora: 26.26 ms / 393.84 ms Memoria: 1.194 MB / 12.51 MB Application: Before Access::getAssetRules (id:1 name:root.1)

Hora: 0.09 ms / 393.93 ms Memoria: 0.007 MB / 12.52 MB Application: After Access::getAssetRules (id:1 name:root.1)

Hora: 42.78 ms / 436.71 ms Memoria: 1.859 MB / 14.38 MB Application: afterRenderComponent com_content

Hora: 8.06 ms / 444.77 ms Memoria: 0.173 MB / 14.55 MB Application: afterDispatch

Hora: 16.23 ms / 460.99 ms Memoria: 0.189 MB / 14.74 MB Application: beforeRenderModule mod_custom (Información Contacto)

Hora: 1.76 ms / 462.75 ms Memoria: 0.024 MB / 14.76 MB Application: afterRenderModule mod_custom (Información Contacto)

Hora: 0.13 ms / 462.88 ms Memoria: -0.001 MB / 14.76 MB Application: beforeRenderModule mod_custom (Indicadores)

Hora: 0.44 ms / 463.32 ms Memoria: 0.004 MB / 14.77 MB Application: afterRenderModule mod_custom (Indicadores)

Hora: 0.13 ms / 463.45 ms Memoria: -0.001 MB / 14.77 MB Application: beforeRenderModule mod_random_image (Imagenes Aleatorias)

Hora: 2.22 ms / 465.67 ms Memoria: 0.029 MB / 14.80 MB Application: afterRenderModule mod_random_image (Imagenes Aleatorias)

Hora: 0.12 ms / 465.80 ms Memoria: -0.011 MB / 14.78 MB Application: beforeRenderModule mod_menu (Menu Lateral)

Hora: 5.97 ms / 471.77 ms Memoria: 0.091 MB / 14.87 MB Application: afterRenderModule mod_menu (Menu Lateral)

Hora: 0.12 ms / 471.89 ms Memoria: -0.004 MB / 14.87 MB Application: beforeRenderModule mod_custom (slogan)

Hora: 0.38 ms / 472.26 ms Memoria: 0.004 MB / 14.87 MB Application: afterRenderModule mod_custom (slogan)

Hora: 0.15 ms / 472.42 ms Memoria: -0.001 MB / 14.87 MB Application: beforeRenderModule mod_custom (Logos Gobierno)

Hora: 0.34 ms / 472.76 ms Memoria: 0.004 MB / 14.88 MB Application: afterRenderModule mod_custom (Logos Gobierno)

Hora: 0.09 ms / 472.86 ms Memoria: 0.012 MB / 14.89 MB Application: beforeRenderModule mod_gtranslate (GTranslate)

Hora: 2.18 ms / 475.04 ms Memoria: 0.068 MB / 14.96 MB Application: afterRenderModule mod_gtranslate (GTranslate)

Hora: 0.14 ms / 475.18 ms Memoria: -0.057 MB / 14.90 MB Application: beforeRenderModule mod_search (Buscador)

Hora: 2.85 ms / 478.02 ms Memoria: 0.056 MB / 14.96 MB Application: afterRenderModule mod_search (Buscador)

Hora: 0.12 ms / 478.14 ms Memoria: -0.004 MB / 14.95 MB Application: beforeRenderModule mod_menu (Main Menu)

Hora: 8.02 ms / 486.17 ms Memoria: 0.107 MB / 15.06 MB Application: afterRenderModule mod_menu (Main Menu)

Hora: 0.21 ms / 486.38 ms Memoria: -0.005 MB / 15.05 MB Application: beforeRenderModule mod_custom (Logo Infider Risaralda)

Hora: 0.38 ms / 486.75 ms Memoria: 0.006 MB / 15.06 MB Application: afterRenderModule mod_custom (Logo Infider Risaralda)

Hora: 31.62 ms / 518.37 ms Memoria: 0.528 MB / 15.59 MB Application: afterRender

Total de consultas de base de datos: 124.29 ms

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

#	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:826
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

Status	Duration
Starting	0.09 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.05 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.03 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.03 ms
Updating status	0.04 ms
Reset for next command	0.05 ms

#	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:828
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

Perfil

Status	Duration
Starting	0.11 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 for update	0.04 ms
Update	0.16 ms
Waiting for query cache lock	0.02 ms
Update	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	84.48 ms
Query end	0.03 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.02 ms
Updating status	0.05 ms
Reset for next command	0.03 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:828
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

Tiempo de consulta: 1.35 ms Después de la última consulta: 4.84 ms Memoria de consulta: 0.056 MB memoria antes de consulta: 4.476 MB Filas entregadas por la consulta: 43

SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`

  FROM `inf_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	inf_extensions	ref	extension	extension	82	const	43	Using index condition; Using where

Perfil

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

Tiempo de consulta: 0.82 ms Después de la última consulta: 4.67 ms Memoria de consulta: 0.021 MB memoria antes de consulta: 4.755 MB Filas entregadas por la consulta: 5

SELECT id, rules

  FROM `inf_viewlevels`

Explicar

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

Perfil

Status	Duration
Starting	0.10 ms
checking permissions	0.02 ms
Opening tables	0.05 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.05 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.09 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.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.04 ms
Logging slow query	0.07 ms
Reset for next command	0.03 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.]

Tiempo de consulta: 0.98 ms Después de la última consulta: 0.22 ms Memoria de consulta: 0.021 MB memoria antes de consulta: 4.767 MB Filas entregadas por la consulta: 2

SELECT b.id

  FROM inf_usergroups AS a

  LEFT JOIN inf_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.11 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.02 ms
init	0.04 ms
Optimizing	0.03 ms
Statistics	0.17 ms
Preparing	0.02 ms
Unlocking tables	0.01 ms
Preparing	0.04 ms
Executing	0.01 ms
Sending data	0.05 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.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.04 ms
Reset for next command	0.03 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.]

Tiempo de consulta: 2.10 ms Después de la última consulta: 1.37 ms Memoria de consulta: 0.035 MB memoria antes de consulta: 4.836 MB Filas entregadas por la consulta: 135

SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`

  FROM inf_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	inf_extensions	ALL	extension	Ninguna llave índice (INDEX KEY) pudo ser utilizada	NULL	NULL	304	Using where; Utilizando filesort

Perfil

Status	Duration
Starting	0.15 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.02 ms
init	0.05 ms
Optimizing	0.05 ms
Statistics	0.08 ms
Preparing	0.04 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	1.03 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.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.05 ms
Logging slow query	0.07 ms
Reset for next command	0.04 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.]

Tiempo de consulta: 1.83 ms Después de la última consulta: 85.51 ms Memoria de consulta: 0.068 MB memoria antes de consulta: 8.406 MB Filas entregadas por la consulta: 40

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 inf_menu AS m

  LEFT JOIN inf_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	ALL	idx_client_id_parent_id_alias_language	Ninguna llave índice (INDEX KEY) pudo ser utilizada	NULL	NULL	115	Using where; Utilizando filesort
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	cloudcitycolombi_infider.m.component_id	1	Using where

Perfil

Status	Duration
Starting	0.21 ms
checking permissions	0.02 ms
Opening tables	0.08 ms
After opening tables	0.04 ms
System lock	0.02 ms
table lock	0.03 ms
init	0.07 ms
Optimizing	0.05 ms
Statistics	0.10 ms
Preparing	0.06 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.03 ms
Creating sort index	0.66 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.02 ms
Updating status	0.04 ms
Logging slow query	0.08 ms
Reset for next command	0.03 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/Menu/SiteMenu.php:93
17	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Igual que la llamada en la línea de abajo.
16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
14	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:78
13	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
12	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:142
11	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:417
10	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
9	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:65
8	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
7	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:533
6	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
5	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/libraries/src/Application/CMSApplication.php:1141
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tiempo de consulta: 2.00 ms Después de la última consulta: 41.57 ms Memoria de consulta: 0.029 MB memoria antes de consulta: 10.040 MB Filas entregadas por la consulta: 143

SHOW TABLES

Explicar

No es posible hacer EXPLAIN en la consulta: SHOW TABLES

Perfil

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

Call Stack

#	Caller	Número de archivo y de línea
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
16	JDatabaseDriver->loadAssocList()	JROOT/plugins/system/chronog3_plg/chronog3/libs/joomla/database_adapter.php:91
15	G3\L\Joomla\DatabaseAdapter->loadAssocList()	JROOT/plugins/system/chronog3_plg/chronog3/libs/joomla/database_adapter.php:62
14	G3\L\Joomla\DatabaseAdapter->getTablesList()	JROOT/plugins/system/chronog3_plg/chronog3/libs/joomla/database_adapter.php:42
13	G3\L\Joomla\DatabaseAdapter->__construct()	JROOT/plugins/system/chronog3_plg/chronog3/libs/database_object.php:29
12	G3\L\DatabaseObject::getInstance()	JROOT/plugins/system/chronog3_plg/chronog3/libs/database.php:48
11	G3\L\Database::getInstance()	JROOT/plugins/system/chronog3_plg/chronog3/libs/model.php:38
10	G3\L\Model->__construct()	JROOT/plugins/system/chronog3_plg/chronog3/libs/extension.php:61
9	G3\L\Extension->settings()	JROOT/plugins/system/chronog3_plg/chronog3_plg.php:56
8	PlgSystemChronog3_Plg->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tiempo de consulta: 0.97 ms Después de la última consulta: 2.23 ms Memoria de consulta: 0.022 MB memoria antes de consulta: 10.065 MB Filas entregadas por la consulta: 1

SELECT `Extension`.`id` AS `Extension.id`, `Extension`.`name` AS `Extension.name`, `Extension`.`enabled` AS `Extension.enabled`, `Extension`.`ordering` AS `Extension.ordering`, `Extension`.`settings` AS `Extension.settings` 
  FROM `inf_chronog3_extensions` AS `Extension` 
  WHERE `Extension`.`name` = 'chronoforms';

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	Extension	ref	name	name	1022	const	1	Using index condition

Perfil

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

Call Stack

#	Caller	Número de archivo y de línea
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
12	JDatabaseDriver->loadAssoc()	JROOT/plugins/system/chronog3_plg/chronog3/libs/joomla/database_adapter.php:80
11	G3\L\Joomla\DatabaseAdapter->loadAssoc()	JROOT/plugins/system/chronog3_plg/chronog3/libs/model.php:1007
10	G3\L\Model->select()	JROOT/plugins/system/chronog3_plg/chronog3/libs/extension.php:62
9	G3\L\Extension->settings()	JROOT/plugins/system/chronog3_plg/chronog3_plg.php:56
8	PlgSystemChronog3_Plg->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tiempo de consulta: 1.09 ms Después de la última consulta: 13.45 ms Memoria de consulta: 0.022 MB memoria antes de consulta: 10.467 MB Filas entregadas por la consulta: 1

SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`

  FROM `inf_extensions`

  WHERE `type` = 'library' 
  AND `element` = 'joomla'

Explicar

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

Perfil

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

Tiempo de consulta: 8.47 ms Después de la última consulta: 0.48 ms Memoria de consulta: 0.005 MB memoria antes de consulta: 10.458 MB

UPDATE `inf_extensions`

  SET `params` = '{\"mediaversion\":\"494b442a1409f8f4b266d8bc597d4c03\"}'

  WHERE `type` = 'library' 
  AND `element` = 'joomla'

Explicar

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

Perfil

Status	Duration
Starting	0.12 ms
checking permissions	0.02 ms
Opening tables	0.04 ms
checking permissions	0.01 ms
After opening tables	0.01 ms
init for update	0.01 ms
init	0.03 ms
Updating main table	0.02 ms
init	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.01 ms
init for update	0.10 ms
Updating	0.15 ms
End of update loop	0.02 ms
Waiting for query cache lock	0.01 ms
End of update loop	0.03 ms
End of update loop	0.04 ms
Query end	0.01 ms
Commit	7.37 ms
Query end	0.03 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.01 ms
Updating status	0.04 ms
Reset for next command	0.03 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.]

Tiempo de consulta: 1.07 ms Después de la última consulta: 3.79 ms Memoria de consulta: 0.019 MB memoria antes de consulta: 10.642 MB Filas entregadas por la consulta: 1

SELECT *

  FROM inf_languages

  WHERE published=1

  ORDER BY ordering ASC

Explicar

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

Perfil

Status	Duration
Starting	0.11 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.02 ms
init	0.05 ms
Optimizing	0.03 ms
Statistics	0.03 ms
Preparing	0.04 ms
Sorting result	0.02 ms
Executing	0.04 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.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.03 ms
Updating status	0.04 ms
Logging slow query	0.07 ms
Reset for next command	0.03 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.]

Tiempo de consulta: 1.33 ms Después de la última consulta: 0.64 ms Memoria de consulta: 0.019 MB memoria antes de consulta: 10.654 MB Filas entregadas por la consulta: 5

SELECT id, home, template, s.params

  FROM inf_template_styles as s

  LEFT JOIN inf_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	ref	idx_template,idx_client_id,idx_client_id_home	idx_client_id	1	const	5
1	SIMPLE	e	range	element_clientid,element_folder_clientid,extension	extension	82	NULL	6	Using index condition; Using where; Using join buffer (flat, BNL join)

Perfil

Status	Duration
Starting	0.15 ms
checking permissions	0.02 ms
Opening tables	0.07 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.02 ms
init	0.05 ms
Optimizing	0.05 ms
Statistics	0.14 ms
Preparing	0.11 ms
Executing	0.02 ms
Sending data	0.21 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.02 ms
Updating status	0.05 ms
Reset for next command	0.03 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.]

Tiempo de consulta: 1.52 ms Después de la última consulta: 12.35 ms Memoria de consulta: 0.029 MB memoria antes de consulta: 11.191 MB Filas entregadas por la consulta: 43

SELECT `id`,`name`,`rules`,`parent_id`

  FROM `inf_assets`

  WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_akeeba','com_associations','com_banners','com_breezingforms','com_cache','com_categories','com_checkin','com_chronoforms6','com_config','com_contact','com_content','com_contenthistory','com_convertforms','com_cpanel','com_fields','com_finder','com_formbuilder','com_installer','com_jdownloads','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_phocadownload','com_plugins','com_postinstall','com_privacy','com_redirect','com_schuweb_sitemap','com_search','com_tags','com_templates','com_users','com_visforms','com_wrapper')

Explicar

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

Perfil

Status	Duration
Starting	0.21 ms
checking permissions	0.02 ms
Opening tables	0.07 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.02 ms
init	0.08 ms
Optimizing	0.03 ms
Statistics	0.19 ms
Preparing	0.04 ms
Executing	0.01 ms
Sending data	0.35 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.02 ms
Updating status	0.05 ms
Logging slow query	0.06 ms
Reset for next command	0.03 ms

Call Stack

#	Caller	Número de archivo y de línea
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
19	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
18	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
17	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
16	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
15	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/article.php:58
14	ContentModelArticle->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457
13	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/components/com_content/models/article.php:78
12	ContentModelArticle->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_content/views/article/view.html.php:42
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.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.]

Tiempo de consulta: 1.28 ms Después de la última consulta: 0.42 ms Memoria de consulta: 0.029 MB memoria antes de consulta: 11.249 MB Filas entregadas por la consulta: 44

SELECT `id`,`name`,`rules`,`parent_id`

  FROM `inf_assets`

  WHERE `name` LIKE 'com_content.%' OR `name` = 'com_content' OR `parent_id` = 0

Explicar

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

Perfil

Status	Duration
Starting	0.18 ms
checking permissions	0.02 ms
Opening tables	0.03 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.13 ms
Preparing	0.05 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.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.05 ms
Logging slow query	0.06 ms
Reset for next command	0.03 ms

Call Stack

#	Caller	Número de archivo y de línea
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:359
19	Joomla\CMS\Access\Access::preloadPermissions()	JROOT/libraries/src/Access/Access.php:226
18	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:540
17	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
16	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
15	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/article.php:58
14	ContentModelArticle->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457
13	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/components/com_content/models/article.php:78
12	ContentModelArticle->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_content/views/article/view.html.php:42
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.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.]

Tiempo de consulta: 1.91 ms Después de la última consulta: 2.19 ms Memoria de consulta: 0.133 MB memoria antes de consulta: 11.336 MB Filas entregadas por la consulta: 1

SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count

  FROM inf_content AS a

  INNER JOIN inf_categories AS c 
  on c.id = a.catid

  LEFT JOIN inf_users AS u 
  on u.id = a.created_by

  LEFT JOIN inf_categories as parent 
  ON parent.id = c.parent_id

  LEFT JOIN inf_content_rating AS v 
  ON a.id = v.content_id

  WHERE a.id = 6 
  AND c.published > 0 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-04-18 16:45:49') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-04-18 16:45:49') 
  AND (a.state = 1 OR a.state =2)

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	const	PRIMARY,idx_state,idx_catid	PRIMARY	4	const	1
1	SIMPLE	c	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	u	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	parent	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	v	const	PRIMARY	PRIMARY	4	const	1	Unique row not found

Perfil

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

Call Stack

#	Caller	Número de archivo y de línea
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
13	JDatabaseDriver->loadObject()	JROOT/components/com_content/models/article.php:151
12	ContentModelArticle->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_content/views/article/view.html.php:42
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.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.]

Tiempo de consulta: 1.29 ms Después de la última consulta: 7.99 ms Memoria de consulta: 0.022 MB memoria antes de consulta: 11.631 MB Filas entregadas por la consulta: 0

SELECT `m`.`tag_id`,`t`.*

  FROM `inf_contentitem_tag_map` AS m 

  INNER JOIN `inf_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

  WHERE `m`.`type_alias` = 'com_content.article' 
  AND `m`.`content_item_id` = 6 
  AND `t`.`published` = 1 
  AND t.access IN (1,1,5)

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t	range	PRIMARY,tag_idx,idx_access	tag_idx	5	NULL	1	Using index condition
1	SIMPLE	m	ref	idx_tag_type	idx_tag_type	4	cloudcitycolombi_infider.t.id	1	Using index condition; Using where

Perfil

Status	Duration
Starting	0.15 ms
checking permissions	0.02 ms
Opening tables	0.10 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.02 ms
init	0.08 ms
Optimizing	0.06 ms
Statistics	0.13 ms
Preparing	0.07 ms
Executing	0.01 ms
Sending data	0.19 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.02 ms
Updating status	0.05 ms
Reset for next command	0.03 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/Helper/TagsHelper.php:454
11	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/views/article/view.html.php:184
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.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.]

Tiempo de consulta: 1.68 ms Después de la última consulta: 26.65 ms Memoria de consulta: 0.026 MB memoria antes de consulta: 12.938 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 `inf_categories` AS `s`

  INNER JOIN `inf_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_content' OR c.extension='system') 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND s.id = 2

  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	idx_left_right	4	NULL	2	Using index condition; Using where

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.02 ms
table lock	0.02 ms
init	0.11 ms
Optimizing	0.07 ms
Statistics	0.29 ms
Preparing	0.02 ms
Unlocking tables	0.01 ms
Preparing	0.07 ms
Sorting result	0.02 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.01 ms
Freeing items	0.03 ms
Updating status	0.05 ms
Reset for next command	0.04 ms

Call Stack

#	Caller	Número de archivo y de línea
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
19	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
18	Joomla\CMS\Categories\Categories->get()	JROOT/administrator/components/com_fields/models/fields.php:203
17	FieldsModelFields->getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:140
16	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:194
15	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
14	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
13	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.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.]

Tiempo de consulta: 3.31 ms Después de la última consulta: 1.14 ms Memoria de consulta: 0.025 MB memoria antes de consulta: 13.045 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 inf_fields AS a

  LEFT JOIN `inf_languages` AS l 
  ON l.lang_code = a.language

  LEFT JOIN inf_users AS uc 
  ON uc.id=a.checked_out

  LEFT JOIN inf_viewlevels AS ag 
  ON ag.id = a.access

  LEFT JOIN inf_users AS ua 
  ON ua.id = a.created_user_id

  LEFT JOIN inf_fields_groups AS g 
  ON g.id = a.group_id

  LEFT JOIN `inf_fields_categories` AS fc 
  ON fc.field_id = a.id

  WHERE a.context = 'com_content.article' 
  AND (fc.category_id IS NULL OR fc.category_id IN (2,0)) 
  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	cloudcitycolombi_infider.a.language	1	Using where
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	cloudcitycolombi_infider.a.checked_out	1
1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	cloudcitycolombi_infider.a.access	1	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	cloudcitycolombi_infider.a.created_user_id	1	Using where
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	cloudcitycolombi_infider.a.group_id	1	Using where
1	SIMPLE	fc	ref	PRIMARY	PRIMARY	4	cloudcitycolombi_infider.a.id	1	Using where; Distinct

Perfil

Status	Duration
Starting	0.26 ms
checking permissions	0.02 ms
Opening tables	0.18 ms
After opening tables	0.03 ms
System lock	0.02 ms
table lock	0.02 ms
init	0.12 ms
Optimizing	0.09 ms
Statistics	0.33 ms
Preparing	0.10 ms
Creating tmp table	0.13 ms
Sorting result	0.03 ms
Executing	0.01 ms
Sending data	0.87 ms
Creating sort index	0.09 ms
Removing tmp table	0.13 ms
Creating sort index	0.03 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.02 ms
Updating status	0.05 ms
Reset for next command	0.03 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/MVC/Model/BaseDatabaseModel.php:322
17	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
16	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
15	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
14	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
13	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.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.]

Tiempo de consulta: 2.54 ms Después de la última consulta: 45.50 ms Memoria de consulta: 0.056 MB memoria antes de consulta: 14.704 MB Filas entregadas por la consulta: 20

SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid

  FROM inf_modules AS m

  LEFT JOIN inf_modules_menu AS mm 
  ON mm.moduleid = m.id

  LEFT JOIN inf_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 <= '2025-04-18 16:45:49') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2025-04-18 16:45:49') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 107 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	ALL	PRIMARY,published,newsfeeds	Ninguna llave índice (INDEX KEY) pudo ser utilizada	NULL	NULL	53	Using where; Utilizando filesort
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	cloudcitycolombi_infider.m.module,const	1	Using index condition; Using where
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	cloudcitycolombi_infider.m.id	2	Using where

Perfil

Status	Duration
Starting	0.40 ms
checking permissions	0.03 ms
Opening tables	0.12 ms
After opening tables	0.02 ms
System lock	0.02 ms
table lock	0.02 ms
init	0.12 ms
Optimizing	0.10 ms
Statistics	0.20 ms
Preparing	0.16 ms
Sorting result	0.03 ms
Executing	0.01 ms
Sending data	0.03 ms
Creating sort index	0.76 ms
End of update loop	0.02 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.04 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.04 ms
Logging slow query	0.07 ms
Reset for next command	0.04 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()	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/ModuleHelper.php:441
10	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:371
9	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
8	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:45
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:1112
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.]

Tiempo de consulta: 0.86 ms Después de la última consulta: 53.66 ms Memoria de consulta: 0.024 MB memoria antes de consulta: 15.571 MB Filas entregadas por la consulta: 1

SELECT `alias`

  FROM `inf_content`

  WHERE id = '24'

Explicar

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

Perfil

Status	Duration
Starting	0.14 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.02 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.10 ms
Preparing	0.02 ms
Unlocking tables	0.01 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.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.01 ms
Updating status	0.04 ms
Reset for next command	0.03 ms

Call Stack

#	Caller	Número de archivo y de línea
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
18	JDatabaseDriver->loadResult()	JROOT/components/com_content/router.php:125
17	ContentRouter->getArticleSegment()	Igual que la llamada en la línea de abajo.
16	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
15	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
14	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
13	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:676
12	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
11	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
10	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
9	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
8	Joomla\CMS\Router\Route::_()	JROOT/plugins/system/sef/sef.php:110
7	PlgSystemSef->onAfterRender()	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/CMSApplication.php:1118
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.]

Tiempo de consulta: 1.12 ms Después de la última consulta: 0.34 ms Memoria de consulta: 0.025 MB memoria antes de consulta: 15.583 MB Filas entregadas por la consulta: 0

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 `inf_categories` AS `s`

  INNER JOIN `inf_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_content' OR c.extension='system') 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND s.id = 24

  ORDER BY c.lft

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	Ninguna llave índice (INDEX KEY) pudo ser utilizada	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Perfil

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

Call Stack

#	Caller	Número de archivo y de línea
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
19	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
18	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
17	ContentRouter->getCategorySegment()	Igual que la llamada en la línea de abajo.
16	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:124
15	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
14	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
13	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:676
12	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
11	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
10	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
9	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
8	Joomla\CMS\Router\Route::_()	JROOT/plugins/system/sef/sef.php:110
7	PlgSystemSef->onAfterRender()	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/CMSApplication.php:1118
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.]

20 tipos de consulta reportadas, ordenados por ocurrencias.

SELECT Tables:

2 × SELECT `id`,`name`,`rules`,`parent_id` 
  FROM `inf_assets`

2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` 
  FROM `inf_extensions`

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 `inf_categories` AS `s` 
  INNER JOIN `inf_categories` AS `c` 
  ON (s.lft <= c.lft 
  AND c.lft < s.rgt) OR (c.lft < s.lft 
  AND s.rgt < c.rgt)

1 × SELECT `data` 
  FROM `inf_session`

1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
  FROM inf_modules AS m 
  LEFT JOIN inf_modules_menu AS mm 
  ON mm.moduleid = m.id 
  LEFT JOIN inf_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

1 × 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 inf_fields AS a 
  LEFT JOIN `inf_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN inf_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN inf_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN inf_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN inf_fields_groups AS g 
  ON g.id = a.group_id 
  LEFT JOIN `inf_fields_categories` AS fc 
  ON fc.field_id = a.id

1 × SELECT `m`.`tag_id`,`t`.* 
  FROM `inf_contentitem_tag_map` AS m  
  INNER JOIN `inf_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

1 × SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count 
  FROM inf_content AS a 
  INNER JOIN inf_categories AS c 
  on c.id = a.catid 
  LEFT JOIN inf_users AS u 
  on u.id = a.created_by 
  LEFT JOIN inf_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN inf_content_rating AS v 
  ON a.id = v.content_id

```
1 × SELECT * 
  FROM inf_languages
```

1 × SELECT id, home, template, s.params 
  FROM inf_template_styles as s 
  LEFT JOIN inf_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id

1 × SELECT `session_id` 
  FROM `inf_session`

1 × SELECT `Extension`.`id` AS `Extension.id`, `Extension`.`name` AS `Extension.name`, `Extension`.`enabled` AS `Extension.enabled`, `Extension`.`ordering` AS `Extension.ordering`, `Extension`.`settings` AS `Extension.settings` 
  FROM `inf_chronog3_extensions` AS `Extension`

1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component 
  FROM inf_menu AS m 
  LEFT JOIN inf_extensions AS e 
  ON m.component_id = e.extension_id

1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` 
  FROM inf_extensions

1 × SELECT b.id 
  FROM inf_usergroups AS a 
  LEFT JOIN inf_usergroups AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt

1 × SELECT id, rules 
  FROM `inf_viewlevels

1 × SELECT `alias` 
  FROM `inf_content`

Otras tablas:

1 × INSERT INTO `inf_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  (X'3230373165623366373436633831366532363130366334613666623361663061', 1, 1744994748, 0, '', 0

```
1 × SHOW TABLE
```

1 × UPDATE `inf_extensions` 
  SET `params` = '{\"mediaversion\":\"494b442a1409f8f4b266d8bc597d4c03\"}'

Instituto de Fomento para el Desarrollo de Risaralda