Desplazamiento,

Los Talleres del Ferrocarril serán un escenario para las artes y la educación.

Hidroituango: ¿Un proyecto de Paz?

Entrevista ha Inty Maleywa

A Chocó no le llego la paz

Zona Gráfica

Liberen los pájaros

Por: Valentina González
1 Mayo prohibido olvidar

Por: Valentina González
Dorothea Medellín

Por:Valentina González
Sketch

Por: Valentina González
Sketch

Por: Valentina González
Código de Policia

Por:Valentina González
La calle de color

Por: Valentina González

A La Calle Edición 11

Consola de depuración de Joomla!

Sesión

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1701228183,
                "last": 1701228183,
                "now": 1701228183
            },
            "token": "vuVBkMsFv2RUM7TuTuIwhHUaRizKqzjF"
        },
        "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: 19.81 ms / 19.81 ms Memoria: 1.572 MB / 1.96 MB Application: afterLoad

Hora: 63.46 ms / 83.27 ms Memoria: 3.938 MB / 5.90 MB Application: afterInitialise

Hora: 24.17 ms / 107.44 ms Memoria: 1.240 MB / 7.14 MB Application: afterRoute

Hora: 8.84 ms / 116.28 ms Memoria: 0.259 MB / 7.40 MB Application: beforeRenderComponent com_tags

Hora: 192.43 ms / 308.71 ms Memoria: 4.415 MB / 11.81 MB Application: Before Access::preloadComponents (all components)

Hora: 1.44 ms / 310.16 ms Memoria: 0.060 MB / 11.87 MB Application: After Access::preloadComponents (all components)

Hora: 0.03 ms / 310.19 ms Memoria: 0.000 MB / 11.87 MB Application: Before Access::getAssetRules (id:35 name:com_tags)

Hora: 0.42 ms / 310.61 ms Memoria: 0.028 MB / 11.90 MB Application: After Access::getAssetRules (id:35 name:com_tags)

Hora: 3.48 ms / 314.10 ms Memoria: 0.114 MB / 12.01 MB Application: afterRenderComponent com_tags

Hora: 1.49 ms / 315.59 ms Memoria: 0.142 MB / 12.15 MB Application: afterDispatch

Hora: 13.91 ms / 329.50 ms Memoria: 0.388 MB / 12.54 MB Application: beforeRenderModule mod_favslider (Zona Gráfica )

Hora: 1.39 ms / 330.89 ms Memoria: 0.092 MB / 12.63 MB Application: afterRenderModule mod_favslider (Zona Gráfica )

Hora: 0.04 ms / 330.92 ms Memoria: 0.000 MB / 12.60 MB Application: beforeRenderModule mod_custom (A La Calle Edición 11)

Hora: 0.31 ms / 331.24 ms Memoria: 0.006 MB / 12.60 MB Application: afterRenderModule mod_custom (A La Calle Edición 11)

Hora: 0.09 ms / 331.33 ms Memoria: 0.031 MB / 12.63 MB Application: beforeRenderModule mod_slideshowck (slidrdevideos)

Hora: 31.15 ms / 362.48 ms Memoria: 0.641 MB / 13.28 MB Application: afterRenderModule mod_slideshowck (slidrdevideos)

Hora: 0.13 ms / 362.61 ms Memoria: 0.000 MB / 13.22 MB Application: beforeRenderModule mod_as_superfish_menu (AS Superfish Menu)

Hora: 8.83 ms / 371.44 ms Memoria: 0.350 MB / 13.57 MB Application: afterRenderModule mod_as_superfish_menu (AS Superfish Menu)

Hora: 9.69 ms / 381.12 ms Memoria: 0.264 MB / 13.83 MB Application: afterRender

Total de consultas de base de datos: 53.87 ms

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	ama_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:660
9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:620
8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:498
7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:455
6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:758
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:344
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:48

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

#	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:153
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:760
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:344
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:48

No es posible hacer EXPLAIN en la consulta: INSERT INTO `ama_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'636e316a3064716f34316576703766713474656e6e6f646b6b6b', 1, 1701228183, 0, '', 0)

Perfil

Status	Duration
Starting	0.06 ms
Checking permissions	0.03 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.03 ms
Table lock	0.02 ms
Init for update	0.04 ms
Update	0.13 ms
Waiting for query cache lock	0.02 ms
Update	0.03 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	2.42 ms
Closing tables	0.09 ms
Unlocking tables	0.06 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.05 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:153
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:760
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:344
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:48

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

Tiempo de consulta: 1.10 ms Después de la última consulta: 3.82 ms Memoria de consulta: 0.024 MB memoria antes de consulta: 4.105 MB Filas entregadas por la consulta: 40

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

  FROM `ama_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	ama_extensions	ref	extension	extension	82	const	40	Using index condition; Using where

Perfil

Status	Duration
Starting	0.08 ms
Checking permissions	0.03 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.02 ms
Init	0.03 ms
Optimizing	0.04 ms
Statistics	0.07 ms
Preparing	0.04 ms
Executing	0.01 ms
Sending data	0.30 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.06 ms
Reset for next command	0.02 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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:51

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

Tiempo de consulta: 0.48 ms Después de la última consulta: 2.80 ms Memoria de consulta: 0.021 MB memoria antes de consulta: 4.314 MB Filas entregadas por la consulta: 5

SELECT id, rules

  FROM `ama_viewlevels`

Explicar

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

Perfil

Status	Duration
Starting	0.03 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.01 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.06 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.01 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/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:321
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:51

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

Tiempo de consulta: 0.61 ms Después de la última consulta: 0.13 ms Memoria de consulta: 0.021 MB memoria antes de consulta: 4.326 MB Filas entregadas por la consulta: 2

SELECT b.id

  FROM ama_usergroups AS a

  LEFT JOIN ama_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	index	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	8	NULL	9	Using where; Using index

Perfil

Status	Duration
Starting	0.05 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.02 ms
Statistics	0.06 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.03 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
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.02 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:321
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:51

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

Tiempo de consulta: 3.80 ms Después de la última consulta: 0.92 ms Memoria de consulta: 0.030 MB memoria antes de consulta: 4.396 MB Filas entregadas por la consulta: 89

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

  FROM ama_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	ama_extensions	ref	extension	extension	82	const	117	Using index condition; Using where; Utilizando filesort

Perfil

Status	Duration
Starting	0.15 ms
Checking permissions	0.03 ms
Opening tables	0.04 ms
After opening tables	0.04 ms
System lock	0.03 ms
Table lock	0.14 ms
Init	0.08 ms
Optimizing	0.08 ms
Statistics	0.22 ms
Preparing	0.06 ms
Sorting result	0.05 ms
Executing	0.02 ms
Sending data	0.03 ms
Creating sort index	2.27 ms
End of update loop	0.06 ms
Query end	0.04 ms
Commit	0.03 ms
Closing tables	0.04 ms
Unlocking tables	0.02 ms
Closing tables	0.04 ms
Starting cleanup	0.03 ms
Freeing items	0.04 ms
Updating status	0.10 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:354
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:359
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:51

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

Tiempo de consulta: 4.35 ms Después de la última consulta: 27.04 ms Memoria de consulta: 0.068 MB memoria antes de consulta: 6.169 MB Filas entregadas por la consulta: 38

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

  LEFT JOIN ama_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	50	Using index condition; Using where; Utilizando filesort
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	amajoomla.m.component_id	1	Using where

Perfil

Status	Duration
Starting	0.44 ms
Checking permissions	0.03 ms
Opening tables	0.08 ms
After opening tables	0.05 ms
System lock	0.03 ms
Table lock	0.04 ms
Init	0.11 ms
Optimizing	0.08 ms
Statistics	0.15 ms
Preparing	0.10 ms
Sorting result	0.06 ms
Executing	0.10 ms
Sending data	0.23 ms
Creating sort index	1.98 ms
End of update loop	0.05 ms
Query end	0.03 ms
Commit	0.04 ms
Closing tables	0.03 ms
Unlocking tables	0.04 ms
Closing tables	0.04 ms
Starting cleanup	0.04 ms
Freeing items	0.03 ms
Updating status	0.10 ms
Reset for next command	0.04 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:76
13	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
12	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:131
11	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:375
10	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
9	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:64
8	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
7	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:491
6	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
5	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/libraries/src/Application/CMSApplication.php:1073
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:51

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

Tiempo de consulta: 2.62 ms Después de la última consulta: 11.95 ms Memoria de consulta: 0.021 MB memoria antes de consulta: 6.963 MB Filas entregadas por la consulta: 1

SELECT id

  FROM `ama_tags`

  WHERE `alias` = 'desplazamiento'

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	ama_tags	ref	idx_alias	idx_alias	402	const	1	Using where

Perfil

Status	Duration
Starting	0.20 ms
Checking permissions	0.04 ms
Opening tables	0.08 ms
After opening tables	0.03 ms
System lock	0.03 ms
Table lock	0.05 ms
Init	0.07 ms
Optimizing	0.06 ms
Statistics	0.40 ms
Preparing	0.09 ms
Executing	0.03 ms
Sending data	0.36 ms
End of update loop	0.31 ms
Query end	0.17 ms
Commit	0.03 ms
Closing tables	0.06 ms
Unlocking tables	0.04 ms
Closing tables	0.03 ms
Starting cleanup	0.03 ms
Freeing items	0.06 ms
Updating status	0.08 ms
Reset for next command	0.05 ms

Call Stack

#	Caller	Número de archivo y de línea
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
11	JDatabaseDriver->loadResult()	JROOT/components/com_tags/router.php:179
10	TagsRouter->fixSegment()	JROOT/components/com_tags/router.php:147
9	TagsRouter->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:138
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:51

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

Tiempo de consulta: 0.68 ms Después de la última consulta: 3.62 ms Memoria de consulta: 0.022 MB memoria antes de consulta: 7.176 MB Filas entregadas por la consulta: 1

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

  FROM `ama_extensions`

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

Explicar

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

Perfil

Status	Duration
Starting	0.06 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.02 ms
Init	0.03 ms
Optimizing	0.03 ms
Statistics	0.08 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.08 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.02 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 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:1130
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:51

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

Tiempo de consulta: 2.24 ms Después de la última consulta: 0.23 ms Memoria de consulta: 0.005 MB memoria antes de consulta: 7.167 MB

UPDATE `ama_extensions`

  SET `params` = '{\"mediaversion\":\"57b06799f852840ec43c7bc51da88f62\"}'

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

Explicar

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

Perfil

Status	Duration
Starting	0.04 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init for update	0.07 ms
Updating	0.08 ms
End of update loop	0.02 ms
Waiting for query cache lock	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	1.62 ms
Closing tables	0.02 ms
Unlocking tables	0.02 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.04 ms
Reset for next command	0.09 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:1130
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:51

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

Tiempo de consulta: 0.63 ms Después de la última consulta: 2.69 ms Memoria de consulta: 0.019 MB memoria antes de consulta: 7.366 MB Filas entregadas por la consulta: 1

SELECT *

  FROM ama_languages

  WHERE published=1

  ORDER BY ordering ASC

Explicar

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

Perfil

Status	Duration
Starting	0.04 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.03 ms
Optimizing	0.02 ms
Statistics	0.02 ms
Preparing	0.03 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.08 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.04 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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:51

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

Tiempo de consulta: 0.83 ms Después de la última consulta: 0.30 ms Memoria de consulta: 0.019 MB memoria antes de consulta: 7.376 MB Filas entregadas por la consulta: 4

SELECT id, home, template, s.params

  FROM ama_template_styles as s

  LEFT JOIN ama_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	6	Using where
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	amajoomla.s.template,const	1	Using index condition; Using where

Perfil

Status	Duration
Starting	0.06 ms
Checking permissions	0.01 ms
Opening tables	0.02 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.14 ms
Preparing	0.04 ms
Executing	0.01 ms
Sending data	0.13 ms
End of update loop	0.01 ms
Query end	0.02 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.09 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.04 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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:51

[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: 55.07 ms Memoria de consulta: 0.042 MB memoria antes de consulta: 8.198 MB Filas entregadas por la consulta: 13

SELECT *

  FROM `ama_content_types`

Explicar

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

Perfil

Status	Duration
Starting	0.11 ms
Checking permissions	0.02 ms
Opening tables	0.05 ms
After opening tables	0.02 ms
System lock	0.03 ms
Table lock	0.10 ms
Init	0.05 ms
Optimizing	0.02 ms
Statistics	0.03 ms
Preparing	0.04 ms
Executing	0.02 ms
Sending data	0.70 ms
End of update loop	0.03 ms
Query end	0.02 ms
Commit	0.13 ms
Closing tables	0.02 ms
Unlocking tables	0.02 ms
Closing tables	0.03 ms
Starting cleanup	0.02 ms
Freeing items	0.02 ms
Updating status	0.06 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	Número de archivo y de línea
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
18	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Helper/TagsHelper.php:794
17	Joomla\CMS\Helper\TagsHelper::getTypes()	JROOT/libraries/src/Helper/TagsHelper.php:628
16	Joomla\CMS\Helper\TagsHelper->getTagItemsQuery()	JROOT/components/com_tags/models/tag.php:149
15	TagsModelTag->getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:133
14	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:187
13	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_tags/models/tag.php:86
12	TagsModelTag->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_tags/views/tag/view.html.php:93
10	TagsViewTag->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_tags/controller.php:52
8	TagsController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tags/tags.php:15
6	require_once JROOT/components/com_tags/tags.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:51

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

Tiempo de consulta: 3.95 ms Después de la última consulta: 0.13 ms Memoria de consulta: 0.043 MB memoria antes de consulta: 8.209 MB Filas entregadas por la consulta: 8

SELECT m.type_alias, m.content_item_id, m.core_content_id, count(m.tag_id) AS match_count, MAX(m.tag_date) as tag_date, MAX(c.core_title) AS core_title, MAX(c.core_params) AS core_params,MAX(c.core_alias) AS core_alias, MAX(c.core_body) AS core_body, MAX(c.core_state) AS core_state, MAX(c.core_access) AS core_access,MAX(c.core_metadata) AS core_metadata, MAX(c.core_created_user_id) AS core_created_user_id, MAX(c.core_created_by_alias) AS core_created_by_alias,MAX(c.core_created_time) as core_created_time, MAX(c.core_images) as core_images,
  CASE WHEN c.core_modified_time = '0000-00-00 00:00:00' THEN c.core_created_time ELSE c.core_modified_time END as core_modified_time,MAX(c.core_language) AS core_language, MAX(c.core_catid) AS core_catid,MAX(c.core_publish_up) AS core_publish_up, MAX(c.core_publish_down) as core_publish_down,MAX(ct.type_title) AS content_type_title, MAX(ct.router) AS router,
  CASE WHEN c.core_created_by_alias > ' ' THEN c.core_created_by_alias ELSE ua.name END AS author,ua.email AS author_email

  FROM ama_contentitem_tag_map AS m

  INNER JOIN ama_ucm_content AS c 
  ON m.type_alias = c.core_type_alias 
  AND m.core_content_id = c.core_content_id 
  AND c.core_state IN (1) 
  AND (c.core_publish_up = '0000-00-00 00:00:00' OR c.core_publish_up <= '2023-11-29 03:23:03')  
  AND (c.core_publish_down = '0000-00-00 00:00:00' OR  c.core_publish_down >= '2023-11-29 03:23:03')

  INNER JOIN ama_content_types AS ct 
  ON ct.type_alias = m.type_alias

  LEFT JOIN ama_categories AS tc 
  ON tc.id = c.core_catid

  LEFT JOIN ama_users AS ua 
  ON ua.id = c.core_created_user_id

  WHERE m.tag_id IN (11) 
  AND (c.core_catid = 0 OR tc.published = 1) 
  AND m.type_alias IN ('com_content.article','com_contact.contact','com_newsfeeds.newsfeed','com_users.user','com_content.category','com_contact.category','com_newsfeeds.category','com_tags.tag','com_banners.banner','com_banners.category','com_banners.client','com_users.note','com_users.category') 
  AND c.core_access IN (0,1,5)

  GROUP BY m.type_alias, m.content_item_id, m.core_content_id, core_modified_time, core_created_time, core_created_by_alias, author, author_email

  ORDER BY MAX(`c`.`core_title`) ASC 
  LIMIT 20

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	idx_tag_type,idx_core_content_id	idx_tag_type	4	const	8	Using where; Using temporary; Utilizando filesort
1	SIMPLE	ct	ref	idx_alias	idx_alias	402	amajoomla.m.type_alias	1	Using where
1	SIMPLE	c	eq_ref	PRIMARY,tag_idx,idx_access,idx_content_type	PRIMARY	4	amajoomla.m.core_content_id	1	Using where
1	SIMPLE	tc	eq_ref	PRIMARY	PRIMARY	4	amajoomla.c.core_catid	1	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	amajoomla.c.core_created_user_id	1	Using where

Perfil

Status	Duration
Starting	0.37 ms
Checking permissions	0.02 ms
Opening tables	0.09 ms
After opening tables	0.02 ms
System lock	0.03 ms
Table lock	0.02 ms
Init	0.23 ms
Optimizing	0.10 ms
Statistics	0.48 ms
Preparing	0.12 ms
Creating tmp table	0.11 ms
Sorting result	0.04 ms
Executing	0.02 ms
Sending data	1.66 ms
Creating sort index	0.12 ms
Removing tmp table	0.14 ms
Creating sort index	0.04 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.08 ms
Unlocking tables	0.01 ms
Closing tables	0.03 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.05 ms
Reset for next command	0.02 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/MVC/Model/BaseDatabaseModel.php:308
14	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
13	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_tags/models/tag.php:86
12	TagsModelTag->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_tags/views/tag/view.html.php:93
10	TagsViewTag->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_tags/controller.php:52
8	TagsController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tags/tags.php:15
6	require_once JROOT/components/com_tags/tags.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:51

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

Tiempo de consulta: 1.63 ms Después de la última consulta: 24.83 ms Memoria de consulta: 0.033 MB memoria antes de consulta: 8.531 MB Filas entregadas por la consulta: 30

SHOW FULL COLUMNS 
  FROM `ama_tags`

Explicar

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

Perfil

Status	Duration
Starting	0.07 ms
Checking permissions	0.02 ms
Closing tables	0.01 ms
Opening tables	0.35 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.02 ms
Init	0.02 ms
Optimizing	0.02 ms
Statistics	0.02 ms
Preparing	0.03 ms
Executing	0.01 ms
Filling schema table	0.02 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
Checking permissions	0.20 ms
Closing tables	0.02 ms
Executing	0.01 ms
Sending data	0.10 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Removing tmp table	0.12 ms
Closing tables	0.02 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.05 ms
Reset for next command	0.02 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/joomla/database/driver/mysqli.php:445
17	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
16	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
15	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_tags/tables/tag.php:29
14	TagsTableTag->__construct()	JROOT/libraries/src/Table/Table.php:312
13	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_tags/models/tag.php:279
12	TagsModelTag->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_tags/views/tag/view.html.php:94
10	TagsViewTag->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_tags/controller.php:52
8	TagsController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tags/tags.php:15
6	require_once JROOT/components/com_tags/tags.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:51

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

Tiempo de consulta: 1.75 ms Después de la última consulta: 2.54 ms Memoria de consulta: 0.024 MB memoria antes de consulta: 8.696 MB Filas entregadas por la consulta: 1

Consultas duplicadas: #26

SELECT *

  FROM ama_tags

  WHERE `id` = '11'

Explicar

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

Perfil

Status	Duration
Starting	0.15 ms
Checking permissions	0.04 ms
Opening tables	0.07 ms
After opening tables	0.03 ms
System lock	0.03 ms
Table lock	0.05 ms
Init	0.09 ms
Optimizing	0.06 ms
Statistics	0.14 ms
Preparing	0.03 ms
Unlocking tables	0.08 ms
Preparing	0.08 ms
Executing	0.15 ms
Sending data	0.10 ms
End of update loop	0.03 ms
Query end	0.04 ms
Commit	0.03 ms
Closing tables	0.03 ms
Unlocking tables	0.02 ms
Closing tables	0.03 ms
Starting cleanup	0.03 ms
Freeing items	0.03 ms
Updating status	0.22 ms
Reset for next command	0.04 ms

Call Stack

#	Caller	Número de archivo y de línea
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
14	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
13	Joomla\CMS\Table\Table->load()	JROOT/components/com_tags/models/tag.php:288
12	TagsModelTag->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_tags/views/tag/view.html.php:94
10	TagsViewTag->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_tags/controller.php:52
8	TagsController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tags/tags.php:15
6	require_once JROOT/components/com_tags/tags.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:51

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

Tiempo de consulta: 6.65 ms Después de la última consulta: 1.31 ms Memoria de consulta: 0.043 MB memoria antes de consulta: 8.814 MB Filas entregadas por la consulta: 8

SELECT m.type_alias, m.content_item_id, m.core_content_id, count(m.tag_id) AS match_count, MAX(m.tag_date) as tag_date, MAX(c.core_title) AS core_title, MAX(c.core_params) AS core_params,MAX(c.core_alias) AS core_alias, MAX(c.core_body) AS core_body, MAX(c.core_state) AS core_state, MAX(c.core_access) AS core_access,MAX(c.core_metadata) AS core_metadata, MAX(c.core_created_user_id) AS core_created_user_id, MAX(c.core_created_by_alias) AS core_created_by_alias,MAX(c.core_created_time) as core_created_time, MAX(c.core_images) as core_images,
  CASE WHEN c.core_modified_time = '0000-00-00 00:00:00' THEN c.core_created_time ELSE c.core_modified_time END as core_modified_time,MAX(c.core_language) AS core_language, MAX(c.core_catid) AS core_catid,MAX(c.core_publish_up) AS core_publish_up, MAX(c.core_publish_down) as core_publish_down,MAX(ct.type_title) AS content_type_title, MAX(ct.router) AS router,
  CASE WHEN c.core_created_by_alias > ' ' THEN c.core_created_by_alias ELSE ua.name END AS author,ua.email AS author_email

  FROM ama_contentitem_tag_map AS m

  INNER JOIN ama_ucm_content AS c 
  ON m.type_alias = c.core_type_alias 
  AND m.core_content_id = c.core_content_id 
  AND c.core_state IN (1) 
  AND (c.core_publish_up = '0000-00-00 00:00:00' OR c.core_publish_up <= '2023-11-29 03:23:03')  
  AND (c.core_publish_down = '0000-00-00 00:00:00' OR  c.core_publish_down >= '2023-11-29 03:23:03')

  INNER JOIN ama_content_types AS ct 
  ON ct.type_alias = m.type_alias

  LEFT JOIN ama_categories AS tc 
  ON tc.id = c.core_catid

  LEFT JOIN ama_users AS ua 
  ON ua.id = c.core_created_user_id

  WHERE m.tag_id IN (11) 
  AND (c.core_catid = 0 OR tc.published = 1) 
  AND m.type_alias IN ('com_content.article','com_contact.contact','com_newsfeeds.newsfeed','com_users.user','com_content.category','com_contact.category','com_newsfeeds.category','com_tags.tag','com_banners.banner','com_banners.category','com_banners.client','com_users.note','com_users.category') 
  AND c.core_access IN (0,1,5)

  GROUP BY m.type_alias, m.content_item_id, m.core_content_id, core_modified_time, core_created_time, core_created_by_alias, author, author_email

  ORDER BY MAX(`c`.`core_title`) ASC

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	idx_tag_type,idx_core_content_id	idx_tag_type	4	const	8	Using where; Using temporary; Utilizando filesort
1	SIMPLE	ct	ref	idx_alias	idx_alias	402	amajoomla.m.type_alias	1	Using where
1	SIMPLE	c	eq_ref	PRIMARY,tag_idx,idx_access,idx_content_type	PRIMARY	4	amajoomla.m.core_content_id	1	Using where
1	SIMPLE	tc	eq_ref	PRIMARY	PRIMARY	4	amajoomla.c.core_catid	1	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	amajoomla.c.core_created_user_id	1	Using where

Perfil

Status	Duration
Starting	0.55 ms
Checking permissions	0.03 ms
Opening tables	0.14 ms
After opening tables	0.03 ms
System lock	0.05 ms
Table lock	0.04 ms
Init	0.50 ms
Optimizing	0.19 ms
Statistics	0.53 ms
Preparing	0.24 ms
Creating tmp table	0.27 ms
Sorting result	0.06 ms
Executing	0.03 ms
Sending data	3.33 ms
Creating sort index	0.11 ms
Removing tmp table	0.12 ms
Creating sort index	0.03 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.03 ms
Starting cleanup	0.01 ms
Freeing items	0.02 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/src/MVC/Model/BaseDatabaseModel.php:353
14	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount()	JROOT/libraries/src/MVC/Model/ListModel.php:282
13	Joomla\CMS\MVC\Model\ListModel->getTotal()	JROOT/libraries/src/MVC/Model/ListModel.php:232
12	Joomla\CMS\MVC\Model\ListModel->getPagination()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_tags/views/tag/view.html.php:97
10	TagsViewTag->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_tags/controller.php:52
8	TagsController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tags/tags.php:15
6	require_once JROOT/components/com_tags/tags.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:51

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

Tiempo de consulta: 1.66 ms Después de la última consulta: 19.56 ms Memoria de consulta: 0.027 MB memoria antes de consulta: 10.589 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 `ama_categories` AS `s`

  INNER JOIN `ama_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.31 ms
Checking permissions	0.03 ms
Opening tables	0.06 ms
After opening tables	0.02 ms
System lock	0.02 ms
Table lock	0.02 ms
Init	0.20 ms
Optimizing	0.07 ms
Statistics	0.25 ms
Preparing	0.02 ms
Unlocking tables	0.02 ms
Preparing	0.05 ms
Sorting result	0.03 ms
Executing	0.01 ms
Sending data	0.16 ms
End of update loop	0.03 ms
Query end	0.01 ms
Commit	0.02 ms
Closing tables	0.01 ms
Unlocking tables	0.02 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.03 ms
Updating status	0.05 ms
Reset for next command	0.02 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:133
16	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:187
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_tags/views/tag/view.html.php:140
10	TagsViewTag->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_tags/controller.php:52
8	TagsController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tags/tags.php:15
6	require_once JROOT/components/com_tags/tags.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:51

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

Tiempo de consulta: 1.80 ms Después de la última consulta: 0.48 ms Memoria de consulta: 0.025 MB memoria antes de consulta: 10.637 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 ama_fields AS a

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

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

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

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

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

  LEFT JOIN `ama_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	amajoomla.a.language	1	Using where
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	amajoomla.a.checked_out	1
1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	amajoomla.a.access	1	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	amajoomla.a.created_user_id	1	Using where
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	amajoomla.a.group_id	1	Using where
1	SIMPLE	fc	ref	PRIMARY	PRIMARY	4	amajoomla.a.id	1	Using where; Using index; Distinct

Perfil

Status	Duration
Starting	0.18 ms
Checking permissions	0.02 ms
Opening tables	0.08 ms
After opening tables	0.02 ms
System lock	0.02 ms
Table lock	0.02 ms
Init	0.07 ms
Optimizing	0.06 ms
Statistics	0.15 ms
Preparing	0.06 ms
Creating tmp table	0.09 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.50 ms
Creating sort index	0.05 ms
Removing tmp table	0.09 ms
Creating sort index	0.05 ms
End of update loop	0.02 ms
Query end	0.03 ms
Commit	0.02 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.03 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.05 ms
Reset for next command	0.02 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:308
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:187
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_tags/views/tag/view.html.php:140
10	TagsViewTag->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_tags/controller.php:52
8	TagsController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tags/tags.php:15
6	require_once JROOT/components/com_tags/tags.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:51

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

Tiempo de consulta: 1.16 ms Después de la última consulta: 3.63 ms Memoria de consulta: 0.027 MB memoria antes de consulta: 10.997 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 `ama_categories` AS `s`

  INNER JOIN `ama_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 = 10

  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	ALL	cat_idx,idx_access,idx_left_right	Ninguna llave índice (INDEX KEY) pudo ser utilizada	NULL	NULL	23	Using where; Utilizando filesort

Perfil

Status	Duration
Starting	0.15 ms
Checking permissions	0.01 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.03 ms
Init	0.06 ms
Optimizing	0.04 ms
Statistics	0.15 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.04 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.04 ms
Creating sort index	0.21 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.02 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.03 ms
Updating status	0.05 ms
Reset for next command	0.02 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:133
16	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:187
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_tags/views/tag/view.html.php:140
10	TagsViewTag->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_tags/controller.php:52
8	TagsController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tags/tags.php:15
6	require_once JROOT/components/com_tags/tags.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:51

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

Tiempo de consulta: 1.64 ms Después de la última consulta: 0.11 ms Memoria de consulta: 0.025 MB memoria antes de consulta: 11.003 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 ama_fields AS a

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

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

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

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

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

  LEFT JOIN `ama_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 (10,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	amajoomla.a.language	1	Using where
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	amajoomla.a.checked_out	1
1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	amajoomla.a.access	1	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	amajoomla.a.created_user_id	1	Using where
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	amajoomla.a.group_id	1	Using where
1	SIMPLE	fc	ref	PRIMARY	PRIMARY	4	amajoomla.a.id	1	Using where; Using index; Distinct

Perfil

Status	Duration
Starting	0.15 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.07 ms
Optimizing	0.05 ms
Statistics	0.13 ms
Preparing	0.06 ms
Creating tmp table	0.07 ms
Sorting result	0.03 ms
Executing	0.01 ms
Sending data	0.46 ms
Creating sort index	0.04 ms
Removing tmp table	0.08 ms
Creating sort index	0.05 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.03 ms
Closing tables	0.02 ms
Unlocking tables	0.02 ms
Closing tables	0.03 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.05 ms
Reset for next command	0.02 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:308
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:187
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_tags/views/tag/view.html.php:140
10	TagsViewTag->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_tags/controller.php:52
8	TagsController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tags/tags.php:15
6	require_once JROOT/components/com_tags/tags.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:51

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

Tiempo de consulta: 1.19 ms Después de la última consulta: 0.61 ms Memoria de consulta: 0.027 MB memoria antes de consulta: 11.025 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 `ama_categories` AS `s`

  INNER JOIN `ama_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 = 14

  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	ALL	cat_idx,idx_access,idx_left_right	Ninguna llave índice (INDEX KEY) pudo ser utilizada	NULL	NULL	23	Using where; Utilizando filesort

Perfil

Status	Duration
Starting	0.13 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.02 ms
Init	0.09 ms
Optimizing	0.04 ms
Statistics	0.14 ms
Preparing	0.02 ms
Unlocking tables	0.01 ms
Preparing	0.03 ms
Sorting result	0.11 ms
Executing	0.01 ms
Sending data	0.04 ms
Creating sort index	0.15 ms
End of update loop	0.03 ms
Query end	0.02 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.02 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.03 ms
Updating status	0.05 ms
Reset for next command	0.02 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:133
16	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:187
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_tags/views/tag/view.html.php:140
10	TagsViewTag->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_tags/controller.php:52
8	TagsController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tags/tags.php:15
6	require_once JROOT/components/com_tags/tags.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:51

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

Tiempo de consulta: 1.71 ms Después de la última consulta: 0.32 ms Memoria de consulta: 0.025 MB memoria antes de consulta: 11.031 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 ama_fields AS a

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

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

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

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

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

  LEFT JOIN `ama_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 (14,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	amajoomla.a.language	1	Using where
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	amajoomla.a.checked_out	1
1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	amajoomla.a.access	1	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	amajoomla.a.created_user_id	1	Using where
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	amajoomla.a.group_id	1	Using where
1	SIMPLE	fc	ref	PRIMARY	PRIMARY	4	amajoomla.a.id	1	Using where; Using index; Distinct

Perfil

Status	Duration
Starting	0.17 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.07 ms
Optimizing	0.06 ms
Statistics	0.12 ms
Preparing	0.06 ms
Creating tmp table	0.09 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.49 ms
Creating sort index	0.05 ms
Removing tmp table	0.08 ms
Creating sort index	0.05 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.02 ms
Closing tables	0.02 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.03 ms
Updating status	0.05 ms
Reset for next command	0.02 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:308
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:187
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_tags/views/tag/view.html.php:140
10	TagsViewTag->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_tags/controller.php:52
8	TagsController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tags/tags.php:15
6	require_once JROOT/components/com_tags/tags.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:51

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

Tiempo de consulta: 2.41 ms Después de la última consulta: 1.86 ms Memoria de consulta: 0.006 MB memoria antes de consulta: 11.062 MB

UPDATE ama_tags

  SET `hits` = (`hits` + 1)

  WHERE `id` = '11'

Explicar

No es posible hacer EXPLAIN en la consulta: UPDATE ama_tags SET `hits` = (`hits` + 1) WHERE `id` = '11'

Perfil

Status	Duration
Starting	0.06 ms
Checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.08 ms
System lock	0.01 ms
Table lock	0.02 ms
Init for update	0.06 ms
Updating	0.12 ms
End of update loop	0.01 ms
Waiting for query cache lock	0.02 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	1.65 ms
Closing tables	0.04 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.02 ms
Updating status	0.05 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	Número de archivo y de línea
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Table/Table.php:1245
12	Joomla\CMS\Table\Table->hit()	JROOT/components/com_tags/models/tag.php:343
11	TagsModelTag->hit()	JROOT/components/com_tags/views/tag/view.html.php:239
10	TagsViewTag->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_tags/controller.php:52
8	TagsController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tags/tags.php:15
6	require_once JROOT/components/com_tags/tags.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:51

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

Tiempo de consulta: 1.00 ms Después de la última consulta: 0.22 ms Memoria de consulta: 0.023 MB memoria antes de consulta: 11.069 MB Filas entregadas por la consulta: 1

Consultas duplicadas: #17

SELECT *

  FROM ama_tags

  WHERE `id` = '11'

Explicar

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

Perfil

Status	Duration
Starting	0.06 ms
Checking permissions	0.03 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.02 ms
Init	0.04 ms
Optimizing	0.02 ms
Statistics	0.06 ms
Preparing	0.01 ms
Unlocking tables	0.05 ms
Preparing	0.02 ms
Executing	0.02 ms
Sending data	0.09 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.11 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	Número de archivo y de línea
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
13	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
12	Joomla\CMS\Table\Table->load()	JROOT/components/com_tags/models/tag.php:346
11	TagsModelTag->hit()	JROOT/components/com_tags/views/tag/view.html.php:239
10	TagsViewTag->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_tags/controller.php:52
8	TagsController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tags/tags.php:15
6	require_once JROOT/components/com_tags/tags.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:51

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

Tiempo de consulta: 1.24 ms Después de la última consulta: 54.37 ms Memoria de consulta: 0.029 MB memoria antes de consulta: 11.818 MB Filas entregadas por la consulta: 40

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

  FROM `ama_assets`

  WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_allvideoshare','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_djimageslider','com_fields','com_finder','com_installer','com_j2xml','com_jce','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_slideshowck','com_tags','com_templates','com_tz_portfolio_plus','com_users','com_wrapper')

Explicar

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

Perfil

Status	Duration
Starting	0.12 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.02 ms
Init	0.06 ms
Optimizing	0.02 ms
Statistics	0.15 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.47 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.06 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.05 ms
Reset for next command	0.02 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()	JROOT/libraries/src/Access/Access.php:429
20	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
19	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
18	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
17	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
16	Joomla\CMS\User\User->authorise()	JROOT/templates/as002070free/html/com_tags/tag/default_items.php:22
15	include JROOT/templates/as002070free/html/com_tags/tag/default_items.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/templates/as002070free/html/com_tags/tag/default.php:50
13	include JROOT/templates/as002070free/html/com_tags/tag/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_tags/views/tag/view.html.php:243
10	TagsViewTag->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_tags/controller.php:52
8	TagsController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tags/tags.php:15
6	require_once JROOT/components/com_tags/tags.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:51

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

Tiempo de consulta: 0.69 ms Después de la última consulta: 6.50 ms Memoria de consulta: 0.021 MB memoria antes de consulta: 12.244 MB Filas entregadas por la consulta: 1

SELECT template 
  FROM ama_template_styles 
  WHERE client_id = 1 
  AND home = 1

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	ama_template_styles	ref	idx_client_id,idx_client_id_home	idx_client_id	1	const	2	Using where

Perfil

Status	Duration
Starting	0.04 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.03 ms
Statistics	0.05 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.05 ms
End of update loop	0.01 ms
Query end	0.03 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.11 ms
Closing tables	0.01 ms
Starting cleanup	0.02 ms
Freeing items	0.01 ms
Updating status	0.05 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:1740
9	JDatabaseDriver->loadResult()	JROOT/templates/as002070free/includes/includes.php:31
8	include_once JROOT/templates/as002070free/includes/includes.php	JROOT/templates/as002070free/index.php:15
7	require JROOT/templates/as002070free/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:51

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

Tiempo de consulta: 1.57 ms Después de la última consulta: 1.65 ms Memoria de consulta: 0.074 MB memoria antes de consulta: 12.362 MB Filas entregadas por la consulta: 22

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

  FROM ama_modules AS m

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

  LEFT JOIN ama_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 <= '2023-11-29 03:23:03') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-11-29 03:23:03') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 0 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	36	Using index condition; Using where; Utilizando filesort
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	amajoomla.m.id	1	Using where; Using index
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	amajoomla.m.module,const	1	Using index condition; Using where

Perfil

Status	Duration
Starting	0.09 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.04 ms
Optimizing	0.04 ms
Statistics	0.06 ms
Preparing	0.05 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.76 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.04 ms
Closing tables	0.01 ms
Starting cleanup	0.02 ms
Freeing items	0.01 ms
Updating status	0.05 ms
Reset for next command	0.02 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()	Igual que la llamada en la línea de abajo.
14	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
13	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:432
12	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:362
11	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
10	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:591
9	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/templates/as002070free/includes/includes.php:90
8	include_once JROOT/templates/as002070free/includes/includes.php	JROOT/templates/as002070free/index.php:15
7	require JROOT/templates/as002070free/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:51

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

22 tipos de consulta reportadas, ordenados por ocurrencias.

SELECT Tables:

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

3 × 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 ama_fields AS a 
  LEFT JOIN `ama_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN ama_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN ama_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN ama_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN ama_fields_groups AS g 
  ON g.id = a.group_id 
  LEFT JOIN `ama_fields_categories` AS fc 
  ON fc.field_id = a.id

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

```
2 × SELECT * 
  FROM ama_tags
```

2 × SELECT m.type_alias, m.content_item_id, m.core_content_id, count(m.tag_id) AS match_count, MAX(m.tag_date) as tag_date, MAX(c.core_title) AS core_title, MAX(c.core_params) AS core_params,MAX(c.core_alias) AS core_alias, MAX(c.core_body) AS core_body, MAX(c.core_state) AS core_state, MAX(c.core_access) AS core_access,MAX(c.core_metadata) AS core_metadata, MAX(c.core_created_user_id) AS core_created_user_id, MAX(c.core_created_by_alias) AS core_created_by_alias,MAX(c.core_created_time) as core_created_time, MAX(c.core_images) as core_images,
  CASE WHEN c.core_modified_time = '0000-00-00 00:00:00' THEN c.core_created_time ELSE c.core_modified_time END as core_modified_time,MAX(c.core_language) AS core_language, MAX(c.core_catid) AS core_catid,MAX(c.core_publish_up) AS core_publish_up, MAX(c.core_publish_down) as core_publish_down,MAX(ct.type_title) AS content_type_title, MAX(ct.router) AS router,
  CASE WHEN c.core_created_by_alias > ' ' THEN c.core_created_by_alias ELSE ua.name END AS author,ua.email AS author_email 
  FROM ama_contentitem_tag_map AS m 
  INNER JOIN ama_ucm_content AS c 
  ON m.type_alias = c.core_type_alias 
  AND m.core_content_id = c.core_content_id 
  AND c.core_state IN (1) 
  AND (c.core_publish_up = '0000-00-00 00:00:00' OR c.core_publish_up <= '2023-11-29 03:23:03')  
  AND (c.core_publish_down = '0000-00-00 00:00:00' OR  c.core_publish_down >= '2023-11-29 03:23:03') 
  INNER JOIN ama_content_types AS ct 
  ON ct.type_alias = m.type_alias 
  LEFT JOIN ama_categories AS tc 
  ON tc.id = c.core_catid 
  LEFT JOIN ama_users AS ua 
  ON ua.id = c.core_created_user_id

1 × SELECT `data` 
  FROM `ama_session`

1 × SELECT * 
  FROM `ama_content_types

1 × SELECT template 
  FROM ama_template_styles

1 × SELECT `id`,`name`,`rules`,`parent_id` 
  FROM `ama_assets`

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

1 × SELECT `session_id` 
  FROM `ama_session`

```
1 × SELECT * 
  FROM ama_languages
```
```
1 × SELECT id 
  FROM `ama_tags`
```

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 ama_menu AS m 
  LEFT JOIN ama_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 ama_extensions

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

1 × SELECT id, rules 
  FROM `ama_viewlevels

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

Otras tablas:

1 × INSERT INTO `ama_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  (X'636e316a3064716f34316576703766713474656e6e6f646b6b6b', 1, 1701228183, 0, '', 0

1 × UPDATE `ama_extensions` 
  SET `params` = '{\"mediaversion\":\"57b06799f852840ec43c7bc51da88f62\"}'

1 × SHOW FULL COLUMNS 
  FROM `ama_tags

1 × UPDATE ama_tags 
  SET `hits` = (`hits` + 1)

Operación Orión: 18 años Resistiendo a la violencia y construyendo la paz

De Ituango a Mutatá: crónica de un desplazamiento anunciado.

Comunicado desde el Barrio La Nueva Jerusalén ante la emergencia por el Covid-19

En Tarazá se cansaron de las promesas del Estado

Indígenas Embera Katío son desalojados de sus hogares en plena pandemia en Medellín

La represa que ahoga la vida

Sobreviviendo en la cuarentena: crónica de un venezolano sin trabajo en Colombia

Zona Nororiental de Medellín pide atención especial por Covid-19

Zona Gráfica

Liberen los pájaros

1 Mayo prohibido olvidar

Dorothea Medellín

Sketch

Sketch

Código de Policia

La calle de color

A La Calle Edición 11

Consola de depuración de Joomla!

Sesión

Información de perfil

Hora

Memoria

Uso de la memoria

Consultas de base de datos

29 consultas reportadas 53.87 ms

2 duplicado encontrado!

22 tipos de consulta reportadas, ordenados por ocurrencias.

SELECT Tables:

Otras tablas: