Maquinaria Thor

Información de interés

MPK - Maquinaria e Insumos de Empaque -

PBX : + 601 527 8450
316 744 6787 - 316 744 6788
316 744 6789
Carrera 49 # 171 – 17 Bogotá DC - Colombia

Síganos en

Consola de depuración de Joomla!

Sesión

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1701592025,
                "last": 1701592025,
                "now": 1701592025
            }
        },
        "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 del perfil

Fecha y hora

Memoria

Fecha y hora: 17.54 ms / 17.54 ms Memoria: 2.091 MB / 2.47 MB Application: afterLoad

Fecha y hora: 48.64 ms / 66.18 ms Memoria: 3.869 MB / 6.34 MB Application: afterInitialise

Fecha y hora: 18.35 ms / 84.52 ms Memoria: 1.464 MB / 7.80 MB Application: afterRoute

Fecha y hora: 4.73 ms / 89.26 ms Memoria: 0.066 MB / 7.87 MB Application: beforeRenderComponent com_content

Fecha y hora: 5.78 ms / 95.04 ms Memoria: 0.687 MB / 8.55 MB Application: Before Access::preloadComponents (all components)

Fecha y hora: 1.46 ms / 96.49 ms Memoria: 0.051 MB / 8.60 MB Application: After Access::preloadComponents (all components)

Fecha y hora: 0.02 ms / 96.51 ms Memoria: -0.001 MB / 8.60 MB Application: Before Access::preloadPermissions (com_content)

Fecha y hora: 0.77 ms / 97.28 ms Memoria: 0.129 MB / 8.73 MB Application: After Access::preloadPermissions (com_content)

Fecha y hora: 0.02 ms / 97.30 ms Memoria: -0.007 MB / 8.72 MB Application: Before Access::getAssetRules (id:159 name:com_content.category.21)

Fecha y hora: 0.42 ms / 97.72 ms Memoria: 0.027 MB / 8.75 MB Application: After Access::getAssetRules (id:159 name:com_content.category.21)

Fecha y hora: 4.15 ms / 101.87 ms Memoria: 0.244 MB / 9.00 MB Application: Before Access::getAssetRules (id:8 name:com_content)

Fecha y hora: 0.04 ms / 101.91 ms Memoria: 0.007 MB / 9.00 MB Application: After Access::getAssetRules (id:8 name:com_content)

Fecha y hora: 18.84 ms / 120.75 ms Memoria: 1.268 MB / 10.27 MB Application: beforeRenderModule mod_zentools2 (Portafolio Thor)

Fecha y hora: 33.62 ms / 154.37 ms Memoria: 1.844 MB / 12.11 MB Application: afterRenderModule mod_zentools2 (Portafolio Thor)

Fecha y hora: 1.02 ms / 155.39 ms Memoria: -0.087 MB / 12.03 MB Application: afterRenderComponent com_content

Fecha y hora: 1.00 ms / 156.39 ms Memoria: 0.097 MB / 12.13 MB Application: afterDispatch

Fecha y hora: 4.42 ms / 160.80 ms Memoria: 0.213 MB / 12.34 MB Application: beforeRenderModule mod_custom (Footer)

Fecha y hora: 0.40 ms / 161.21 ms Memoria: 0.008 MB / 12.35 MB Application: afterRenderModule mod_custom (Footer)

Fecha y hora: 0.02 ms / 161.22 ms Memoria: -0.002 MB / 12.34 MB Application: beforeRenderModule mod_custom (whatsapp icono)

Fecha y hora: 0.17 ms / 161.39 ms Memoria: 0.003 MB / 12.35 MB Application: afterRenderModule mod_custom (whatsapp icono)

Fecha y hora: 0.03 ms / 161.42 ms Memoria: -0.000 MB / 12.35 MB Application: beforeRenderModule mod_custom (Informacion extra (2))

Fecha y hora: 0.17 ms / 161.59 ms Memoria: 0.003 MB / 12.35 MB Application: afterRenderModule mod_custom (Informacion extra (2))

Fecha y hora: 0.03 ms / 161.62 ms Memoria: -0.001 MB / 12.35 MB Application: beforeRenderModule mod_custom (Informacion extra)

Fecha y hora: 0.16 ms / 161.78 ms Memoria: 0.003 MB / 12.35 MB Application: afterRenderModule mod_custom (Informacion extra)

Fecha y hora: 0.03 ms / 161.81 ms Memoria: -0.001 MB / 12.35 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)

Fecha y hora: 0.71 ms / 162.52 ms Memoria: 0.023 MB / 12.38 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)

Fecha y hora: 0.04 ms / 162.56 ms Memoria: -0.003 MB / 12.37 MB Application: beforeRenderModule mod_search (Buscador)

Fecha y hora: 0.63 ms / 163.19 ms Memoria: 0.018 MB / 12.39 MB Application: afterRenderModule mod_search (Buscador)

Fecha y hora: 0.02 ms / 163.21 ms Memoria: -0.005 MB / 12.39 MB Application: beforeRenderModule mod_custom (Boton de pago)

Fecha y hora: 0.17 ms / 163.38 ms Memoria: 0.003 MB / 12.39 MB Application: afterRenderModule mod_custom (Boton de pago)

Fecha y hora: 0.03 ms / 163.41 ms Memoria: 0.000 MB / 12.39 MB Application: beforeRenderModule mod_custom (Logo)

Fecha y hora: 0.16 ms / 163.57 ms Memoria: 0.003 MB / 12.39 MB Application: afterRenderModule mod_custom (Logo)

Fecha y hora: 0.03 ms / 163.60 ms Memoria: 0.000 MB / 12.39 MB Application: beforeRenderModule mod_menu (Main Menu)

Fecha y hora: 3.26 ms / 166.86 ms Memoria: 0.147 MB / 12.54 MB Application: afterRenderModule mod_menu (Main Menu)

Fecha y hora: 21.87 ms / 188.73 ms Memoria: 1.438 MB / 13.98 MB Application: afterRender

Total de consultas a la base de datos: 46.74 ms

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	zrtco_session	NULL	const	PRIMARY	PRIMARY	602	const	1	100.00	NULL

#	Comunicador	Archivo y número 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()	Lo mismo que llamada de la línea de abajo.
13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:88
10	JSessionHandlerJoomla->start()	JROOT/libraries/src/Session/Session.php:661
9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:621
8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:499
7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:456
6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:826
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	zrtco_session	NULL	const	PRIMARY	PRIMARY	602	const	1	100.00	Using index

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

'Explicar' no es posible en la consulta: INSERT INTO `zrtco_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3164646339656135666239303066326136656435396535386130376433393965', 1, 1701592025, 0, '', 0)

Perfil

Status	Duration
starting	0.12 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
update	0.12 ms
Waiting for query cache lock	0.01 ms
update	0.00 ms
end	0.00 ms
query end	0.81 ms
closing tables	0.03 ms
freeing items	0.14 ms
cleaning up	0.01 ms

Llamada de pila

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

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 1.91 ms Después de la última consulta: 1.89 ms Consulta a la memoria: 0.006 MB memoria antes de la consulta: 4.613 MB Filas devueltas: 31

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

  FROM `zrtco_extensions`

  WHERE `type` = 'component' 
  AND `state` = 0 
  AND `enabled` = 1

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	zrtco_extensions	NULL	ref	extension	extension	62	const	31	1.00	Using where

Perfil

Status	Duration
starting	0.20 ms
checking permissions	0.01 ms
Opening tables	1.03 ms
init	0.02 ms
System lock	0.04 ms
optimizing	0.01 ms
statistics	0.08 ms
preparing	0.13 ms
executing	0.00 ms
Sending data	0.17 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.11 ms
cleaning up	0.03 ms

Llamada de pila

#	Comunicador	Archivo y número 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}()	Lo mismo que llamada de la línea de abajo.
9	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
8	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Component/ComponentHelper.php:453
7	Joomla\CMS\Component\ComponentHelper::load()	JROOT/libraries/src/Component/ComponentHelper.php:519
6	Joomla\CMS\Component\ComponentHelper::getComponents()	JROOT/libraries/src/Component/ComponentHelper.php:44
5	Joomla\CMS\Component\ComponentHelper::getComponent()	JROOT/libraries/src/Component/ComponentHelper.php:103
4	Joomla\CMS\Component\ComponentHelper::getParams()	JROOT/libraries/src/Application/SiteApplication.php:594
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 1.41 ms Después de la última consulta: 1.97 ms Consulta a la memoria: 0.005 MB memoria antes de la consulta: 4.801 MB Filas devueltas: 5

SELECT id, rules

  FROM `zrtco_viewlevels`

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	zrtco_viewlevels	NULL	ALL	NULL	No pudo usarse una clave de índice	NULL	NULL	5	100.00	NULL

Perfil

Status	Duration
starting	0.10 ms
checking permissions	0.01 ms
Opening tables	1.00 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.04 ms
executing	0.00 ms
Sending data	0.02 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.03 ms
freeing items	0.11 ms
cleaning up	0.00 ms

Llamada de pila

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

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.79 ms Después de la última consulta: 0.07 ms Consulta a la memoria: 0.005 MB memoria antes de la consulta: 4.813 MB Filas devueltas: 2

Consultas duplicadas: #22

SELECT b.id

  FROM zrtco_usergroups AS a

  LEFT JOIN zrtco_usergroups AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt

  WHERE a.id = 9

Explicar

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

Perfil

Status	Duration
starting	0.11 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.32 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.12 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.11 ms
cleaning up	0.00 ms

Llamada de pila

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

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.83 ms Después de la última consulta: 0.54 ms Consulta a la memoria: 0.005 MB memoria antes de la consulta: 4.881 MB Filas devueltas: 50

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

  FROM zrtco_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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	zrtco_extensions	NULL	ref	extension	extension	62	const	64	0.65	Using index condition; Using where; Usando 'filesort'

Perfil

Status	Duration
starting	0.13 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.01 ms
Sorting result	0.02 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.37 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
freeing items	0.11 ms
cleaning up	0.02 ms

Llamada de pila

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

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 2.01 ms Después de la última consulta: 14.49 ms Consulta a la memoria: 0.009 MB memoria antes de la consulta: 6.523 MB Filas devueltas: 20

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

  LEFT JOIN zrtco_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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	range	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	5	NULL	26	10.00	Using index condition; Using where; Usando 'filesort'
1	SIMPLE	e	NULL	eq_ref	PRIMARY	PRIMARY	4	verticep_mainpackweb.m.component_id	1	100.00	Using where

Perfil

Status	Duration
starting	0.25 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.87 ms
init	0.05 ms
System lock	0.04 ms
optimizing	0.01 ms
statistics	0.09 ms
preparing	0.02 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.36 ms
end	0.07 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.11 ms
cleaning up	0.01 ms

Llamada de pila

#	Comunicador	Archivo y número 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}()	Lo mismo que llamada de la línea de abajo.
16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
14	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:78
13	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
12	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:142
11	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:417
10	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
9	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:65
8	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
7	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:533
6	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
5	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/libraries/src/Application/CMSApplication.php:1141
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.75 ms Después de la última consulta: 5.87 ms Consulta a la memoria: 0.009 MB memoria antes de la consulta: 7.121 MB Filas devueltas: 1

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

  FROM `zrtco_extensions`

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

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	zrtco_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	extension	364	const,const	1	100.00	NULL

Perfil

Status	Duration
starting	0.19 ms
checking permissions	0.08 ms
Opening tables	0.05 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.10 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.00 ms
query end	0.03 ms
closing tables	0.05 ms
freeing items	0.10 ms
cleaning up	0.01 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
18	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
17	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Lo mismo que llamada de 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/Helper/LibraryHelper.php:175
14	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
13	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
12	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
11	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
10	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
9	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/zenshortcodes/zenshortcodes.php:30
8	plgSystemzenshortcodes->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 1.86 ms Después de la última consulta: 0.10 ms Consulta a la memoria: 0.006 MB memoria antes de la consulta: 7.114 MB

UPDATE `zrtco_extensions`

  SET `params` = '{\"mediaversion\":\"fd2bd541593f9ebd099d3c3a857189c6\"}'

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

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	UPDATE	zrtco_extensions	NULL	range	element_clientid,element_folder_clientid,extension	extension	364	const,const	1	100.00	Using where

Perfil

Status	Duration
starting	0.09 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.20 ms
updating	0.09 ms
end	0.01 ms
Waiting for query cache lock	0.00 ms
end	0.07 ms
query end	1.17 ms
closing tables	0.05 ms
freeing items	0.13 ms
cleaning up	0.01 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
13	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
12	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
11	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
10	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
9	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/zenshortcodes/zenshortcodes.php:30
8	plgSystemzenshortcodes->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 2.64 ms Después de la última consulta: 6.28 ms Consulta a la memoria: 0.003 MB memoria antes de la consulta: 7.813 MB Filas devueltas: 1

SELECT *

  FROM zrtco_languages

  WHERE published=1

  ORDER BY ordering ASC

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	zrtco_languages	NULL	ALL	NULL	No pudo usarse una clave de índice	NULL	NULL	1	100.00	Using where; Usando 'filesort'

Perfil

Status	Duration
starting	0.17 ms
checking permissions	0.01 ms
Opening tables	1.63 ms
init	0.03 ms
System lock	0.13 ms
optimizing	0.09 ms
statistics	0.02 ms
preparing	0.02 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.14 ms
end	0.03 ms
query end	0.01 ms
closing tables	0.14 ms
freeing items	0.11 ms
cleaning up	0.01 ms

Llamada de pila

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

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 1.08 ms Después de la última consulta: 0.20 ms Consulta a la memoria: 0.003 MB memoria antes de la consulta: 7.831 MB Filas devueltas: 1

SELECT id, home, template, s.params

  FROM zrtco_template_styles as s

  LEFT JOIN zrtco_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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	NULL	ALL	idx_template	No pudo usarse una clave de índice	NULL	NULL	3	33.33	Using where
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	303	verticep_mainpackweb.s.template,const	1	4.52	Using index condition; Using where

Perfil

Status	Duration
starting	0.15 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.49 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.11 ms
preparing	0.03 ms
executing	0.02 ms
Sending data	0.06 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.10 ms
cleaning up	0.01 ms

Llamada de pila

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

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 1.28 ms Después de la última consulta: 6.56 ms Consulta a la memoria: 0.009 MB memoria antes de la consulta: 8.554 MB Filas devueltas: 31

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

  FROM `zrtco_assets`

  WHERE `name` IN ('root.1','com_admin','com_ajax','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_finder','com_installer','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_redirect','com_search','com_sigpro','com_tags','com_templates','com_users','com_wrapper')

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	zrtco_assets	NULL	ALL	idx_asset_name	No pudo usarse una clave de índice	NULL	NULL	181	17.68	Using where

Perfil

Status	Duration
starting	0.17 ms
checking permissions	0.01 ms
Opening tables	0.55 ms
init	0.05 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.08 ms
preparing	0.01 ms
executing	0.02 ms
Sending data	0.15 ms
end	0.00 ms
query end	0.02 ms
closing tables	0.02 ms
freeing items	0.11 ms
cleaning up	0.00 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
18	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
17	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
16	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
15	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
14	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/category.php:139
13	ContentModelCategory->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457
12	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/libraries/src/MVC/View/CategoryView.php:116
11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.61 ms Después de la última consulta: 0.11 ms Consulta a la memoria: 0.009 MB memoria antes de la consulta: 8.603 MB Filas devueltas: 103

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

  FROM `zrtco_assets`

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

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	zrtco_assets	NULL	ALL	idx_asset_name,idx_parent_id	No pudo usarse una clave de índice	NULL	NULL	181	23.08	Using where

Perfil

Status	Duration
starting	0.10 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.10 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.15 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.12 ms
cleaning up	0.01 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:359
18	Joomla\CMS\Access\Access::preloadPermissions()	JROOT/libraries/src/Access/Access.php:226
17	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:540
16	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
15	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
14	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/category.php:139
13	ContentModelCategory->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457
12	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/libraries/src/MVC/View/CategoryView.php:116
11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 1.52 ms Después de la última consulta: 1.61 ms Consulta a la memoria: 0.008 MB memoria antes de la consulta: 8.798 MB Filas devueltas: 9

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,(
SELECT COUNT(i.`id`)

  FROM `zrtco_content` AS `i`

  WHERE i.`catid` = c.id 
  AND i.state = 1) AS numitems

  FROM `zrtco_categories` AS `s`

  INNER JOIN `zrtco_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.published = 1 
  AND s.id = 21

  ORDER BY c.lft

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	s	NULL	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	Usando 'filesort'
1	PRIMARY	c	NULL	ALL	cat_idx,idx_left_right	No pudo usarse una clave de índice	NULL	NULL	27	52.13	Using where
2	DEPENDENT SUBQUERY	i	NULL	ref	idx_state,idx_catid	idx_catid	4	verticep_mainpackweb.c.id	4	78.48	Using index condition; Using where

Perfil

Status	Duration
starting	0.17 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.02 ms
Opening tables	0.56 ms
init	0.04 ms
System lock	0.02 ms
optimizing	0.01 ms
statistics	0.10 ms
preparing	0.01 ms
Sorting result	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.02 ms
Sending data	0.01 ms
Creating sort index	0.08 ms
executing	0.00 ms
Sending data	0.04 ms
executing	0.00 ms
Sending data	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
executing	0.00 ms
Sending data	0.03 ms
executing	0.00 ms
Sending data	0.02 ms
executing	0.00 ms
Sending data	0.02 ms
executing	0.00 ms
Sending data	0.02 ms
executing	0.00 ms
Sending data	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.11 ms
cleaning up	0.01 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
15	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
14	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/models/category.php:355
13	ContentModelCategory->getCategory()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/src/MVC/View/CategoryView.php:122
11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 1.48 ms Después de la última consulta: 1.67 ms Consulta a la memoria: 0.009 MB memoria antes de la consulta: 9.002 MB Filas devueltas: 0

SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN c.published = 2 
  AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language,  LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
  CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum  / v.rating_count, 0), 0), 0) AS rating,
							COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count

  FROM zrtco_content AS a

  LEFT JOIN zrtco_categories AS c 
  ON c.id = a.catid

  LEFT JOIN zrtco_users AS ua 
  ON ua.id = a.created_by

  LEFT JOIN zrtco_users AS uam 
  ON uam.id = a.modified_by

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

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

  WHERE a.access IN (1,1,5) 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND a.state = 1 
  AND a.catid = 21 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-12-03 08:27:05') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-12-03 08:27:05')

  ORDER BY  c.lft,   
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END  DESC ,  a.created

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c	NULL	const	PRIMARY,idx_access	PRIMARY	4	const	1	100.00	Usando 'filesort'
1	SIMPLE	a	NULL	ref	idx_access,idx_state,idx_catid	idx_catid	4	const	1	12.56	Using index condition; Using where
1	SIMPLE	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	verticep_mainpackweb.a.created_by	1	100.00	Using where
1	SIMPLE	uam	NULL	eq_ref	PRIMARY	PRIMARY	4	verticep_mainpackweb.a.modified_by	1	100.00	Using where
1	SIMPLE	parent	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	Using where
1	SIMPLE	v	NULL	eq_ref	PRIMARY	PRIMARY	4	verticep_mainpackweb.a.id	1	100.00	Using where

Perfil

Status	Duration
starting	0.20 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.62 ms
init	0.10 ms
System lock	0.01 ms
optimizing	0.04 ms
statistics	0.13 ms
preparing	0.04 ms
Sorting result	0.02 ms
executing	0.00 ms
Sending data	0.02 ms
Creating sort index	0.09 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.10 ms
cleaning up	0.01 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
16	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
15	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_content/models/articles.php:576
14	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
13	ContentModelCategory->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/src/MVC/View/CategoryView.php:144
11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.50 ms Después de la última consulta: 0.94 ms Consulta a la memoria: 0.009 MB memoria antes de la consulta: 9.109 MB Filas devueltas: 1

SELECT COUNT(*)

  FROM zrtco_content AS a

  LEFT JOIN zrtco_categories AS c 
  ON c.id = a.catid

  LEFT JOIN zrtco_users AS ua 
  ON ua.id = a.created_by

  LEFT JOIN zrtco_users AS uam 
  ON uam.id = a.modified_by

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

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

  WHERE a.access IN (1,1,5) 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND a.state = 1 
  AND a.catid = 21 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-12-03 08:27:05') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-12-03 08:27:05')

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c	NULL	const	PRIMARY,idx_access	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	a	NULL	ref	idx_access,idx_state,idx_catid	idx_catid	4	const	1	12.56	Using where
1	SIMPLE	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	verticep_mainpackweb.a.created_by	1	100.00	Using where; Using index
1	SIMPLE	uam	NULL	eq_ref	PRIMARY	PRIMARY	4	verticep_mainpackweb.a.modified_by	1	100.00	Using where; Using index
1	SIMPLE	parent	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	Using where; Using index
1	SIMPLE	v	NULL	eq_ref	PRIMARY	PRIMARY	4	verticep_mainpackweb.a.id	1	100.00	Using where; Using index

Perfil

Status	Duration
starting	0.13 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.07 ms
preparing	0.02 ms
executing	0.02 ms
Sending data	0.02 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.10 ms
cleaning up	0.01 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
17	JDatabaseDriver->loadResult()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:354
16	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount()	JROOT/libraries/src/MVC/Model/ListModel.php:289
15	Joomla\CMS\MVC\Model\ListModel->getTotal()	JROOT/libraries/src/MVC/Model/ListModel.php:239
14	Joomla\CMS\MVC\Model\ListModel->getPagination()	JROOT/components/com_content/models/category.php:265
13	ContentModelCategory->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/src/MVC/View/CategoryView.php:144
11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 1.41 ms Después de la última consulta: 1.33 ms Consulta a la memoria: 0.007 MB memoria antes de la consulta: 9.305 MB Filas devueltas: 0

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

  FROM `zrtco_contentitem_tag_map` AS m 

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

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

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ALL	idx_tag_type,idx_tag	No pudo usarse una clave de índice	NULL	NULL	5	20.00	Using where
1	SIMPLE	t	NULL	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	verticep_mainpackweb.m.tag_id	1	100.00	Using where

Perfil

Status	Duration
starting	0.13 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.83 ms
init	0.08 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.10 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.11 ms
cleaning up	0.01 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
12	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/libraries/src/MVC/View/CategoryView.php:229
11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 2.82 ms Después de la última consulta: 10.16 ms Consulta a la memoria: 0.016 MB memoria antes de la consulta: 10.234 MB Filas devueltas: 10

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

  FROM zrtco_modules AS m

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

  LEFT JOIN zrtco_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-12-03 08:27:05') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-12-03 08:27:05') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 125 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	range	PRIMARY,published,newsfeeds	published	5	NULL	29	2.33	Using index condition; Using where; Usando 'filesort'
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid	element_clientid	303	verticep_mainpackweb.m.module,const	1	10.00	Using index condition; Using where
1	SIMPLE	mm	NULL	ref	PRIMARY	PRIMARY	4	verticep_mainpackweb.m.id	1	40.00	Using where; Using index

Perfil

Status	Duration
starting	0.34 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	1.22 ms
init	0.05 ms
System lock	0.01 ms
optimizing	0.04 ms
statistics	0.18 ms
preparing	0.03 ms
Sorting result	0.01 ms
executing	0.08 ms
Sending data	0.01 ms
Creating sort index	0.60 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.12 ms
cleaning up	0.03 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
34	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
33	JDatabaseDriver->loadObjectList()	Lo mismo que llamada de la línea de abajo.
32	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
31	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:441
30	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:371
29	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
28	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/plugins/system/modulesanywhere/helper.php:517
27	PlgSystemModulesAnywhereHelper->processPosition()	JROOT/plugins/system/modulesanywhere/helper.php:483
26	PlgSystemModulesAnywhereHelper->processMatch()	JROOT/plugins/system/modulesanywhere/helper.php:350
25	PlgSystemModulesAnywhereHelper->replace()	JROOT/plugins/system/modulesanywhere/helper.php:308
24	PlgSystemModulesAnywhereHelper->processModules()	JROOT/plugins/system/nnframework/helpers/helper.php:94
23	NNFrameworkHelper::processArticle()	JROOT/plugins/system/modulesanywhere/helper.php:117
22	PlgSystemModulesAnywhereHelper->onContentPrepare()	JROOT/plugins/system/modulesanywhere/modulesanywhere.php:45
21	PlgSystemModulesAnywhere->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
20	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
19	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
18	JHtmlContent::prepare()	Lo mismo que llamada de la línea de abajo.
17	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
16	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
15	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/templates/responsive2/html/com_content/category/blog.php:41
14	include JROOT/templates/responsive2/html/com_content/category/blog.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/libraries/src/MVC/View/CategoryView.php:245
11	Joomla\CMS\MVC\View\CategoryView->display()	JROOT/components/com_content/views/category/view.html.php:250
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.53 ms Después de la última consulta: 1.95 ms Consulta a la memoria: 0.016 MB memoria antes de la consulta: 10.490 MB Filas devueltas: 0

Consultas duplicadas: #21

SELECT `id`

  FROM `zrtco_users`

  WHERE `username` = '' 
  LIMIT 1

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	zrtco_users	NULL	ref	username	username	452	const	1	100.00	Using index

Perfil

Status	Duration
starting	0.19 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.12 ms
cleaning up	0.01 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
34	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
33	JDatabaseDriver->loadResult()	JROOT/libraries/src/User/UserHelper.php:297
32	Joomla\CMS\User\UserHelper::getUserId()	JROOT/modules/mod_zentools2/includes/joomla.php:93
31	joomla::getList()	JROOT/modules/mod_zentools2/mod_zentools2.php:52
30	include JROOT/modules/mod_zentools2/mod_zentools2.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
29	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
28	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/system/modulesanywhere/helper.php:519
27	PlgSystemModulesAnywhereHelper->processPosition()	JROOT/plugins/system/modulesanywhere/helper.php:483
26	PlgSystemModulesAnywhereHelper->processMatch()	JROOT/plugins/system/modulesanywhere/helper.php:350
25	PlgSystemModulesAnywhereHelper->replace()	JROOT/plugins/system/modulesanywhere/helper.php:308
24	PlgSystemModulesAnywhereHelper->processModules()	JROOT/plugins/system/nnframework/helpers/helper.php:94
23	NNFrameworkHelper::processArticle()	JROOT/plugins/system/modulesanywhere/helper.php:117
22	PlgSystemModulesAnywhereHelper->onContentPrepare()	JROOT/plugins/system/modulesanywhere/modulesanywhere.php:45
21	PlgSystemModulesAnywhere->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
20	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
19	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
18	JHtmlContent::prepare()	Lo mismo que llamada de la línea de abajo.
17	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
16	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
15	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/templates/responsive2/html/com_content/category/blog.php:41
14	include JROOT/templates/responsive2/html/com_content/category/blog.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/libraries/src/MVC/View/CategoryView.php:245
11	Joomla\CMS\MVC\View\CategoryView->display()	JROOT/components/com_content/views/category/view.html.php:250
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.33 ms Después de la última consulta: 0.07 ms Consulta a la memoria: 0.017 MB memoria antes de la consulta: 10.507 MB Filas devueltas: 0

Consultas duplicadas: #20

SELECT `id`

  FROM `zrtco_users`

  WHERE `username` = '' 
  LIMIT 1

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	zrtco_users	NULL	ref	username	username	452	const	1	100.00	Using index

Perfil

Status	Duration
starting	0.12 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.00 ms
freeing items	0.09 ms
cleaning up	0.00 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
37	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
36	JDatabaseDriver->loadResult()	JROOT/libraries/src/User/UserHelper.php:297
35	Joomla\CMS\User\UserHelper::getUserId()	JROOT/libraries/src/User/UserWrapper.php:134
34	Joomla\CMS\User\UserWrapper->getUserId()	JROOT/libraries/src/User/User.php:280
33	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Access/Access.php:1073
32	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/modules/mod_zentools2/includes/joomla.php:93
31	joomla::getList()	JROOT/modules/mod_zentools2/mod_zentools2.php:52
30	include JROOT/modules/mod_zentools2/mod_zentools2.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
29	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
28	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/system/modulesanywhere/helper.php:519
27	PlgSystemModulesAnywhereHelper->processPosition()	JROOT/plugins/system/modulesanywhere/helper.php:483
26	PlgSystemModulesAnywhereHelper->processMatch()	JROOT/plugins/system/modulesanywhere/helper.php:350
25	PlgSystemModulesAnywhereHelper->replace()	JROOT/plugins/system/modulesanywhere/helper.php:308
24	PlgSystemModulesAnywhereHelper->processModules()	JROOT/plugins/system/nnframework/helpers/helper.php:94
23	NNFrameworkHelper::processArticle()	JROOT/plugins/system/modulesanywhere/helper.php:117
22	PlgSystemModulesAnywhereHelper->onContentPrepare()	JROOT/plugins/system/modulesanywhere/modulesanywhere.php:45
21	PlgSystemModulesAnywhere->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
20	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
19	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
18	JHtmlContent::prepare()	Lo mismo que llamada de la línea de abajo.
17	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
16	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
15	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/templates/responsive2/html/com_content/category/blog.php:41
14	include JROOT/templates/responsive2/html/com_content/category/blog.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/libraries/src/MVC/View/CategoryView.php:245
11	Joomla\CMS\MVC\View\CategoryView->display()	JROOT/components/com_content/views/category/view.html.php:250
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.42 ms Después de la última consulta: 0.04 ms Consulta a la memoria: 0.017 MB memoria antes de la consulta: 10.527 MB Filas devueltas: 2

Consultas duplicadas: #6

SELECT b.id

  FROM zrtco_usergroups AS a

  LEFT JOIN zrtco_usergroups AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt

  WHERE a.id = 9

Explicar

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

Perfil

Status	Duration
starting	0.10 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.11 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.09 ms
cleaning up	0.00 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
35	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
34	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
33	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/Access/Access.php:1095
32	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/modules/mod_zentools2/includes/joomla.php:93
31	joomla::getList()	JROOT/modules/mod_zentools2/mod_zentools2.php:52
30	include JROOT/modules/mod_zentools2/mod_zentools2.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
29	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
28	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/system/modulesanywhere/helper.php:519
27	PlgSystemModulesAnywhereHelper->processPosition()	JROOT/plugins/system/modulesanywhere/helper.php:483
26	PlgSystemModulesAnywhereHelper->processMatch()	JROOT/plugins/system/modulesanywhere/helper.php:350
25	PlgSystemModulesAnywhereHelper->replace()	JROOT/plugins/system/modulesanywhere/helper.php:308
24	PlgSystemModulesAnywhereHelper->processModules()	JROOT/plugins/system/nnframework/helpers/helper.php:94
23	NNFrameworkHelper::processArticle()	JROOT/plugins/system/modulesanywhere/helper.php:117
22	PlgSystemModulesAnywhereHelper->onContentPrepare()	JROOT/plugins/system/modulesanywhere/modulesanywhere.php:45
21	PlgSystemModulesAnywhere->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
20	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
19	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
18	JHtmlContent::prepare()	Lo mismo que llamada de la línea de abajo.
17	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
16	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
15	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/templates/responsive2/html/com_content/category/blog.php:41
14	include JROOT/templates/responsive2/html/com_content/category/blog.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/libraries/src/MVC/View/CategoryView.php:245
11	Joomla\CMS\MVC\View\CategoryView->display()	JROOT/components/com_content/views/category/view.html.php:250
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 2.95 ms Después de la última consulta: 0.25 ms Consulta a la memoria: 0.016 MB memoria antes de la consulta: 10.562 MB Filas devueltas: 6

SELECT *

  FROM zrtco_content

  WHERE 1 = 0
UNION (
SELECT *

  FROM zrtco_content

  WHERE catid = 22 
  AND state = 1 
  AND access in ('1,1,5') 
  AND publish_down = '0000-00-00 00:00:00' OR publish_down >= '2023-12-03 08:27:05' 
  AND publish_up <= '2023-12-03 08:27:05'

  ORDER BY publish_up ASC 
  LIMIT 50)
UNION (
SELECT *

  FROM zrtco_content

  WHERE catid = 23 
  AND state = 1 
  AND access in ('1,1,5') 
  AND publish_down = '0000-00-00 00:00:00' OR publish_down >= '2023-12-03 08:27:05' 
  AND publish_up <= '2023-12-03 08:27:05'

  ORDER BY publish_up ASC 
  LIMIT 50)
UNION (
SELECT *

  FROM zrtco_content

  WHERE catid = 24 
  AND state = 1 
  AND access in ('1,1,5') 
  AND publish_down = '0000-00-00 00:00:00' OR publish_down >= '2023-12-03 08:27:05' 
  AND publish_up <= '2023-12-03 08:27:05'

  ORDER BY publish_up ASC 
  LIMIT 50)
UNION (
SELECT *

  FROM zrtco_content

  WHERE catid = 26 
  AND state = 1 
  AND access in ('1,1,5') 
  AND publish_down = '0000-00-00 00:00:00' OR publish_down >= '2023-12-03 08:27:05' 
  AND publish_up <= '2023-12-03 08:27:05'

  ORDER BY publish_up ASC 
  LIMIT 50)
UNION (
SELECT *

  FROM zrtco_content

  WHERE catid = 27 
  AND state = 1 
  AND access in ('1,1,5') 
  AND publish_down = '0000-00-00 00:00:00' OR publish_down >= '2023-12-03 08:27:05' 
  AND publish_up <= '2023-12-03 08:27:05'

  ORDER BY publish_up ASC 
  LIMIT 50)
UNION (
SELECT *

  FROM zrtco_content

  WHERE catid = 28 
  AND state = 1 
  AND access in ('1,1,5') 
  AND publish_down = '0000-00-00 00:00:00' OR publish_down >= '2023-12-03 08:27:05' 
  AND publish_up <= '2023-12-03 08:27:05'

  ORDER BY publish_up ASC 
  LIMIT 50) 
  ORDER BY publish_up ASC  
  LIMIT 0, 50

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	NULL	NULL	NULL	NULL	No pudo usarse una clave de índice	NULL	NULL	NULL	NULL	Impossible WHERE
2	UNION	zrtco_content	NULL	ALL	idx_access,idx_state,idx_catid	No pudo usarse una clave de índice	NULL	NULL	79	11.12	Using where; Usando 'filesort'
3	UNION	zrtco_content	NULL	ALL	idx_access,idx_state,idx_catid	No pudo usarse una clave de índice	NULL	NULL	79	11.12	Using where; Usando 'filesort'
4	UNION	zrtco_content	NULL	ALL	idx_access,idx_state,idx_catid	No pudo usarse una clave de índice	NULL	NULL	79	11.12	Using where; Usando 'filesort'
5	UNION	zrtco_content	NULL	ALL	idx_access,idx_state,idx_catid	No pudo usarse una clave de índice	NULL	NULL	79	11.12	Using where; Usando 'filesort'
6	UNION	zrtco_content	NULL	ALL	idx_access,idx_state,idx_catid	No pudo usarse una clave de índice	NULL	NULL	79	11.12	Using where; Usando 'filesort'
7	UNION	zrtco_content	NULL	ALL	idx_access,idx_state,idx_catid	No pudo usarse una clave de índice	NULL	NULL	79	11.12	Using where; Usando 'filesort'
NULL	UNION RESULT	<union1,2,3,4,5,6,7>	NULL	ALL	NULL	No pudo usarse una clave de índice	NULL	NULL	NULL	NULL	Using temporary; Usando 'filesort'

Perfil

Status	Duration
starting	0.17 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.23 ms
init	0.61 ms
System lock	0.01 ms
optimizing	0.01 ms
optimizing	0.07 ms
statistics	0.06 ms
preparing	0.01 ms
Sorting result	0.07 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.01 ms
Sorting result	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
Sorting result	0.00 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
Sorting result	0.00 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
Sorting result	0.00 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
Sorting result	0.00 ms
optimizing	0.00 ms
statistics	0.00 ms
preparing	0.00 ms
Sorting result	0.00 ms
executing	0.00 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.45 ms
executing	0.01 ms
Sending data	0.00 ms
Creating sort index	0.13 ms
executing	0.01 ms
Sending data	0.00 ms
Creating sort index	0.12 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.09 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.10 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.11 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.09 ms
end	0.01 ms
query end	0.03 ms
removing tmp table	0.09 ms
query end	0.01 ms
closing tables	0.03 ms
freeing items	0.14 ms
cleaning up	0.04 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
33	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
32	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_zentools2/includes/joomla.php:250
31	joomla::getList()	JROOT/modules/mod_zentools2/mod_zentools2.php:52
30	include JROOT/modules/mod_zentools2/mod_zentools2.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
29	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
28	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/system/modulesanywhere/helper.php:519
27	PlgSystemModulesAnywhereHelper->processPosition()	JROOT/plugins/system/modulesanywhere/helper.php:483
26	PlgSystemModulesAnywhereHelper->processMatch()	JROOT/plugins/system/modulesanywhere/helper.php:350
25	PlgSystemModulesAnywhereHelper->replace()	JROOT/plugins/system/modulesanywhere/helper.php:308
24	PlgSystemModulesAnywhereHelper->processModules()	JROOT/plugins/system/nnframework/helpers/helper.php:94
23	NNFrameworkHelper::processArticle()	JROOT/plugins/system/modulesanywhere/helper.php:117
22	PlgSystemModulesAnywhereHelper->onContentPrepare()	JROOT/plugins/system/modulesanywhere/modulesanywhere.php:45
21	PlgSystemModulesAnywhere->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
20	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
19	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
18	JHtmlContent::prepare()	Lo mismo que llamada de la línea de abajo.
17	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
16	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
15	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/templates/responsive2/html/com_content/category/blog.php:41
14	include JROOT/templates/responsive2/html/com_content/category/blog.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/libraries/src/MVC/View/CategoryView.php:245
11	Joomla\CMS\MVC\View\CategoryView->display()	JROOT/components/com_content/views/category/view.html.php:250
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.33 ms Después de la última consulta: 0.08 ms Consulta a la memoria: 0.016 MB memoria antes de la consulta: 10.613 MB Filas devueltas: 1

SELECT title,alias

  FROM `zrtco_categories`

  WHERE `id` LIKE 22 
  LIMIT 1

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	zrtco_categories	NULL	ALL	PRIMARY	No pudo usarse una clave de índice	NULL	NULL	27	11.11	Using where

Perfil

Status	Duration
starting	0.12 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.09 ms
cleaning up	0.00 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
34	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
33	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_zentools2/includes/joomla.php:517
32	joomla::get_joomla_cat()	JROOT/modules/mod_zentools2/includes/joomla.php:306
31	joomla::getList()	JROOT/modules/mod_zentools2/mod_zentools2.php:52
30	include JROOT/modules/mod_zentools2/mod_zentools2.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
29	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
28	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/system/modulesanywhere/helper.php:519
27	PlgSystemModulesAnywhereHelper->processPosition()	JROOT/plugins/system/modulesanywhere/helper.php:483
26	PlgSystemModulesAnywhereHelper->processMatch()	JROOT/plugins/system/modulesanywhere/helper.php:350
25	PlgSystemModulesAnywhereHelper->replace()	JROOT/plugins/system/modulesanywhere/helper.php:308
24	PlgSystemModulesAnywhereHelper->processModules()	JROOT/plugins/system/nnframework/helpers/helper.php:94
23	NNFrameworkHelper::processArticle()	JROOT/plugins/system/modulesanywhere/helper.php:117
22	PlgSystemModulesAnywhereHelper->onContentPrepare()	JROOT/plugins/system/modulesanywhere/modulesanywhere.php:45
21	PlgSystemModulesAnywhere->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
20	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
19	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
18	JHtmlContent::prepare()	Lo mismo que llamada de la línea de abajo.
17	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
16	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
15	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/templates/responsive2/html/com_content/category/blog.php:41
14	include JROOT/templates/responsive2/html/com_content/category/blog.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/libraries/src/MVC/View/CategoryView.php:245
11	Joomla\CMS\MVC\View\CategoryView->display()	JROOT/components/com_content/views/category/view.html.php:250
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 1.73 ms Después de la última consulta: 0.19 ms Consulta a la memoria: 0.020 MB memoria antes de la consulta: 10.638 MB Filas devueltas: 4

SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug

  FROM `zrtco_categories` AS `s`

  INNER JOIN `zrtco_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 = 22

  ORDER BY c.lft

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	NULL	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	Usando 'filesort'
1	SIMPLE	c	NULL	ALL	cat_idx,idx_access,idx_left_right	No pudo usarse una clave de índice	NULL	NULL	27	43.21	Using where

Perfil

Status	Duration
starting	0.39 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.06 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.38 ms
preparing	0.03 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
Creating sort index	0.53 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.11 ms
cleaning up	0.01 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
45	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
44	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
43	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
42	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
41	ContentRouter->getCategorySegment()	Lo mismo que llamada de la línea de abajo.
40	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
39	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
38	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
37	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:676
36	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
35	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
34	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
33	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
32	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_zentools2/includes/joomla.php:349
31	joomla::getList()	JROOT/modules/mod_zentools2/mod_zentools2.php:52
30	include JROOT/modules/mod_zentools2/mod_zentools2.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
29	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
28	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/system/modulesanywhere/helper.php:519
27	PlgSystemModulesAnywhereHelper->processPosition()	JROOT/plugins/system/modulesanywhere/helper.php:483
26	PlgSystemModulesAnywhereHelper->processMatch()	JROOT/plugins/system/modulesanywhere/helper.php:350
25	PlgSystemModulesAnywhereHelper->replace()	JROOT/plugins/system/modulesanywhere/helper.php:308
24	PlgSystemModulesAnywhereHelper->processModules()	JROOT/plugins/system/nnframework/helpers/helper.php:94
23	NNFrameworkHelper::processArticle()	JROOT/plugins/system/modulesanywhere/helper.php:117
22	PlgSystemModulesAnywhereHelper->onContentPrepare()	JROOT/plugins/system/modulesanywhere/modulesanywhere.php:45
21	PlgSystemModulesAnywhere->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
20	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
19	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
18	JHtmlContent::prepare()	Lo mismo que llamada de la línea de abajo.
17	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
16	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
15	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/templates/responsive2/html/com_content/category/blog.php:41
14	include JROOT/templates/responsive2/html/com_content/category/blog.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/libraries/src/MVC/View/CategoryView.php:245
11	Joomla\CMS\MVC\View\CategoryView->display()	JROOT/components/com_content/views/category/view.html.php:250
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.44 ms Después de la última consulta: 0.25 ms Consulta a la memoria: 0.016 MB memoria antes de la consulta: 10.672 MB Filas devueltas: 0

SELECT * 
  FROM zrtco_content_rating 
  WHERE content_id = 68

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	No pudo usarse una clave de índice	NULL	NULL	NULL	NULL	no matching row in const table

Perfil

Status	Duration
starting	0.14 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
executing	0.01 ms
end	0.03 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.12 ms
cleaning up	0.01 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
33	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
32	JDatabaseDriver->loadObject()	JROOT/modules/mod_zentools2/includes/joomla.php:426
31	joomla::getList()	JROOT/modules/mod_zentools2/mod_zentools2.php:52
30	include JROOT/modules/mod_zentools2/mod_zentools2.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
29	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
28	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/system/modulesanywhere/helper.php:519
27	PlgSystemModulesAnywhereHelper->processPosition()	JROOT/plugins/system/modulesanywhere/helper.php:483
26	PlgSystemModulesAnywhereHelper->processMatch()	JROOT/plugins/system/modulesanywhere/helper.php:350
25	PlgSystemModulesAnywhereHelper->replace()	JROOT/plugins/system/modulesanywhere/helper.php:308
24	PlgSystemModulesAnywhereHelper->processModules()	JROOT/plugins/system/nnframework/helpers/helper.php:94
23	NNFrameworkHelper::processArticle()	JROOT/plugins/system/modulesanywhere/helper.php:117
22	PlgSystemModulesAnywhereHelper->onContentPrepare()	JROOT/plugins/system/modulesanywhere/modulesanywhere.php:45
21	PlgSystemModulesAnywhere->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
20	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
19	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
18	JHtmlContent::prepare()	Lo mismo que llamada de la línea de abajo.
17	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
16	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
15	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/templates/responsive2/html/com_content/category/blog.php:41
14	include JROOT/templates/responsive2/html/com_content/category/blog.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/libraries/src/MVC/View/CategoryView.php:245
11	Joomla\CMS\MVC\View\CategoryView->display()	JROOT/components/com_content/views/category/view.html.php:250
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.55 ms Después de la última consulta: 0.07 ms Consulta a la memoria: 0.016 MB memoria antes de la consulta: 10.692 MB Filas devueltas: 0

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

  FROM `zrtco_contentitem_tag_map` AS m 

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

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

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ALL	idx_tag_type,idx_tag	No pudo usarse una clave de índice	NULL	NULL	5	20.00	Using where
1	SIMPLE	t	NULL	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	verticep_mainpackweb.m.tag_id	1	100.00	Using where

Perfil

Status	Duration
starting	0.18 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.05 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.10 ms
cleaning up	0.01 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
34	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
33	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
32	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/modules/mod_zentools2/includes/joomla.php:439
31	joomla::getList()	JROOT/modules/mod_zentools2/mod_zentools2.php:52
30	include JROOT/modules/mod_zentools2/mod_zentools2.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
29	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
28	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/system/modulesanywhere/helper.php:519
27	PlgSystemModulesAnywhereHelper->processPosition()	JROOT/plugins/system/modulesanywhere/helper.php:483
26	PlgSystemModulesAnywhereHelper->processMatch()	JROOT/plugins/system/modulesanywhere/helper.php:350
25	PlgSystemModulesAnywhereHelper->replace()	JROOT/plugins/system/modulesanywhere/helper.php:308
24	PlgSystemModulesAnywhereHelper->processModules()	JROOT/plugins/system/nnframework/helpers/helper.php:94
23	NNFrameworkHelper::processArticle()	JROOT/plugins/system/modulesanywhere/helper.php:117
22	PlgSystemModulesAnywhereHelper->onContentPrepare()	JROOT/plugins/system/modulesanywhere/modulesanywhere.php:45
21	PlgSystemModulesAnywhere->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
20	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
19	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
18	JHtmlContent::prepare()	Lo mismo que llamada de la línea de abajo.
17	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
16	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
15	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/templates/responsive2/html/com_content/category/blog.php:41
14	include JROOT/templates/responsive2/html/com_content/category/blog.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/libraries/src/MVC/View/CategoryView.php:245
11	Joomla\CMS\MVC\View\CategoryView->display()	JROOT/components/com_content/views/category/view.html.php:250
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 2.12 ms Después de la última consulta: 1.66 ms Consulta a la memoria: 0.020 MB memoria antes de la consulta: 10.836 MB Filas devueltas: 16

SHOW FULL COLUMNS 
  FROM `zrtco_users`

Explicar

'Explicar' no es posible en la consulta: SHOW FULL COLUMNS FROM `zrtco_users`

Perfil

Status	Duration
starting	0.14 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	1.05 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.09 ms
executing	0.02 ms
Opening tables	0.01 ms
checking permissions	0.22 ms
checking permissions	0.05 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.06 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Sending data	0.04 ms
end	0.03 ms
query end	0.01 ms
closing tables	0.00 ms
removing tmp table	0.09 ms
closing tables	0.01 ms
freeing items	0.12 ms
cleaning up	0.03 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
43	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
42	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
41	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
40	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
39	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/User.php:41
38	Joomla\CMS\Table\User->__construct()	JROOT/libraries/src/Table/Table.php:328
37	Joomla\CMS\Table\Table::getInstance()	JROOT/libraries/src/User/User.php:603
36	Joomla\CMS\User\User::getTable()	JROOT/libraries/src/User/User.php:877
35	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
34	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
33	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
32	Joomla\CMS\Factory::getUser()	JROOT/modules/mod_zentools2/includes/joomla.php:471
31	joomla::getList()	JROOT/modules/mod_zentools2/mod_zentools2.php:52
30	include JROOT/modules/mod_zentools2/mod_zentools2.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
29	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
28	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/system/modulesanywhere/helper.php:519
27	PlgSystemModulesAnywhereHelper->processPosition()	JROOT/plugins/system/modulesanywhere/helper.php:483
26	PlgSystemModulesAnywhereHelper->processMatch()	JROOT/plugins/system/modulesanywhere/helper.php:350
25	PlgSystemModulesAnywhereHelper->replace()	JROOT/plugins/system/modulesanywhere/helper.php:308
24	PlgSystemModulesAnywhereHelper->processModules()	JROOT/plugins/system/nnframework/helpers/helper.php:94
23	NNFrameworkHelper::processArticle()	JROOT/plugins/system/modulesanywhere/helper.php:117
22	PlgSystemModulesAnywhereHelper->onContentPrepare()	JROOT/plugins/system/modulesanywhere/modulesanywhere.php:45
21	PlgSystemModulesAnywhere->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
20	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
19	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
18	JHtmlContent::prepare()	Lo mismo que llamada de la línea de abajo.
17	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
16	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
15	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/templates/responsive2/html/com_content/category/blog.php:41
14	include JROOT/templates/responsive2/html/com_content/category/blog.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/libraries/src/MVC/View/CategoryView.php:245
11	Joomla\CMS\MVC\View\CategoryView->display()	JROOT/components/com_content/views/category/view.html.php:250
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.37 ms Después de la última consulta: 0.46 ms Consulta a la memoria: 0.018 MB memoria antes de la consulta: 10.895 MB Filas devueltas: 1

SELECT *

  FROM `zrtco_users`

  WHERE `id` = 589

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	zrtco_users	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Perfil

Status	Duration
starting	0.11 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.09 ms
cleaning up	0.01 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
38	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
37	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/User.php:87
36	Joomla\CMS\Table\User->load()	JROOT/libraries/src/User/User.php:880
35	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
34	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
33	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
32	Joomla\CMS\Factory::getUser()	JROOT/modules/mod_zentools2/includes/joomla.php:471
31	joomla::getList()	JROOT/modules/mod_zentools2/mod_zentools2.php:52
30	include JROOT/modules/mod_zentools2/mod_zentools2.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
29	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
28	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/system/modulesanywhere/helper.php:519
27	PlgSystemModulesAnywhereHelper->processPosition()	JROOT/plugins/system/modulesanywhere/helper.php:483
26	PlgSystemModulesAnywhereHelper->processMatch()	JROOT/plugins/system/modulesanywhere/helper.php:350
25	PlgSystemModulesAnywhereHelper->replace()	JROOT/plugins/system/modulesanywhere/helper.php:308
24	PlgSystemModulesAnywhereHelper->processModules()	JROOT/plugins/system/nnframework/helpers/helper.php:94
23	NNFrameworkHelper::processArticle()	JROOT/plugins/system/modulesanywhere/helper.php:117
22	PlgSystemModulesAnywhereHelper->onContentPrepare()	JROOT/plugins/system/modulesanywhere/modulesanywhere.php:45
21	PlgSystemModulesAnywhere->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
20	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
19	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
18	JHtmlContent::prepare()	Lo mismo que llamada de la línea de abajo.
17	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
16	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
15	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/templates/responsive2/html/com_content/category/blog.php:41
14	include JROOT/templates/responsive2/html/com_content/category/blog.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/libraries/src/MVC/View/CategoryView.php:245
11	Joomla\CMS\MVC\View\CategoryView->display()	JROOT/components/com_content/views/category/view.html.php:250
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 1.34 ms Después de la última consulta: 2.94 ms Consulta a la memoria: 0.018 MB memoria antes de la consulta: 11.658 MB Filas devueltas: 3

SELECT `g`.`id`,`g`.`title`

  FROM `zrtco_usergroups` AS g

  INNER JOIN `zrtco_user_usergroup_map` AS m 
  ON m.group_id = g.id

  WHERE `m`.`user_id` = 589

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ref	PRIMARY	PRIMARY	4	const	3	100.00	Using index
1	SIMPLE	g	NULL	eq_ref	PRIMARY	PRIMARY	4	verticep_mainpackweb.m.group_id	1	100.00	NULL

Perfil

Status	Duration
starting	0.15 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.86 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.07 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.10 ms
cleaning up	0.02 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
38	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
37	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Table/User.php:112
36	Joomla\CMS\Table\User->load()	JROOT/libraries/src/User/User.php:880
35	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
34	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
33	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
32	Joomla\CMS\Factory::getUser()	JROOT/modules/mod_zentools2/includes/joomla.php:471
31	joomla::getList()	JROOT/modules/mod_zentools2/mod_zentools2.php:52
30	include JROOT/modules/mod_zentools2/mod_zentools2.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
29	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
28	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/system/modulesanywhere/helper.php:519
27	PlgSystemModulesAnywhereHelper->processPosition()	JROOT/plugins/system/modulesanywhere/helper.php:483
26	PlgSystemModulesAnywhereHelper->processMatch()	JROOT/plugins/system/modulesanywhere/helper.php:350
25	PlgSystemModulesAnywhereHelper->replace()	JROOT/plugins/system/modulesanywhere/helper.php:308
24	PlgSystemModulesAnywhereHelper->processModules()	JROOT/plugins/system/nnframework/helpers/helper.php:94
23	NNFrameworkHelper::processArticle()	JROOT/plugins/system/modulesanywhere/helper.php:117
22	PlgSystemModulesAnywhereHelper->onContentPrepare()	JROOT/plugins/system/modulesanywhere/modulesanywhere.php:45
21	PlgSystemModulesAnywhere->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
20	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
19	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
18	JHtmlContent::prepare()	Lo mismo que llamada de la línea de abajo.
17	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
16	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
15	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/templates/responsive2/html/com_content/category/blog.php:41
14	include JROOT/templates/responsive2/html/com_content/category/blog.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/libraries/src/MVC/View/CategoryView.php:245
11	Joomla\CMS\MVC\View\CategoryView->display()	JROOT/components/com_content/views/category/view.html.php:250
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.43 ms Después de la última consulta: 0.16 ms Consulta a la memoria: 0.016 MB memoria antes de la consulta: 11.675 MB Filas devueltas: 1

SELECT title,alias

  FROM `zrtco_categories`

  WHERE `id` LIKE 23 
  LIMIT 1

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	zrtco_categories	NULL	ALL	PRIMARY	No pudo usarse una clave de índice	NULL	NULL	27	11.11	Using where

Perfil

Status	Duration
starting	0.09 ms
checking permissions	0.01 ms
Opening tables	0.06 ms
init	0.05 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.04 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.09 ms
cleaning up	0.00 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
34	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
33	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_zentools2/includes/joomla.php:517
32	joomla::get_joomla_cat()	JROOT/modules/mod_zentools2/includes/joomla.php:306
31	joomla::getList()	JROOT/modules/mod_zentools2/mod_zentools2.php:52
30	include JROOT/modules/mod_zentools2/mod_zentools2.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
29	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
28	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/system/modulesanywhere/helper.php:519
27	PlgSystemModulesAnywhereHelper->processPosition()	JROOT/plugins/system/modulesanywhere/helper.php:483
26	PlgSystemModulesAnywhereHelper->processMatch()	JROOT/plugins/system/modulesanywhere/helper.php:350
25	PlgSystemModulesAnywhereHelper->replace()	JROOT/plugins/system/modulesanywhere/helper.php:308
24	PlgSystemModulesAnywhereHelper->processModules()	JROOT/plugins/system/nnframework/helpers/helper.php:94
23	NNFrameworkHelper::processArticle()	JROOT/plugins/system/modulesanywhere/helper.php:117
22	PlgSystemModulesAnywhereHelper->onContentPrepare()	JROOT/plugins/system/modulesanywhere/modulesanywhere.php:45
21	PlgSystemModulesAnywhere->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
20	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
19	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
18	JHtmlContent::prepare()	Lo mismo que llamada de la línea de abajo.
17	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
16	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
15	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/templates/responsive2/html/com_content/category/blog.php:41
14	include JROOT/templates/responsive2/html/com_content/category/blog.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/libraries/src/MVC/View/CategoryView.php:245
11	Joomla\CMS\MVC\View\CategoryView->display()	JROOT/components/com_content/views/category/view.html.php:250
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.81 ms Después de la última consulta: 0.13 ms Consulta a la memoria: 0.020 MB memoria antes de la consulta: 11.698 MB Filas devueltas: 4

SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug

  FROM `zrtco_categories` AS `s`

  INNER JOIN `zrtco_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 = 23

  ORDER BY c.lft

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	NULL	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	Usando 'filesort'
1	SIMPLE	c	NULL	ALL	cat_idx,idx_access,idx_left_right	No pudo usarse una clave de índice	NULL	NULL	27	40.33	Using where

Perfil

Status	Duration
starting	0.15 ms
checking permissions	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.04 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.18 ms
preparing	0.01 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.17 ms
end	0.02 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.11 ms
cleaning up	0.01 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
45	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
44	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
43	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
42	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
41	ContentRouter->getCategorySegment()	Lo mismo que llamada de la línea de abajo.
40	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
39	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
38	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
37	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:676
36	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
35	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
34	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
33	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
32	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_zentools2/includes/joomla.php:349
31	joomla::getList()	JROOT/modules/mod_zentools2/mod_zentools2.php:52
30	include JROOT/modules/mod_zentools2/mod_zentools2.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
29	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
28	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/system/modulesanywhere/helper.php:519
27	PlgSystemModulesAnywhereHelper->processPosition()	JROOT/plugins/system/modulesanywhere/helper.php:483
26	PlgSystemModulesAnywhereHelper->processMatch()	JROOT/plugins/system/modulesanywhere/helper.php:350
25	PlgSystemModulesAnywhereHelper->replace()	JROOT/plugins/system/modulesanywhere/helper.php:308
24	PlgSystemModulesAnywhereHelper->processModules()	JROOT/plugins/system/nnframework/helpers/helper.php:94
23	NNFrameworkHelper::processArticle()	JROOT/plugins/system/modulesanywhere/helper.php:117
22	PlgSystemModulesAnywhereHelper->onContentPrepare()	JROOT/plugins/system/modulesanywhere/modulesanywhere.php:45
21	PlgSystemModulesAnywhere->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
20	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
19	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
18	JHtmlContent::prepare()	Lo mismo que llamada de la línea de abajo.
17	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
16	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
15	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/templates/responsive2/html/com_content/category/blog.php:41
14	include JROOT/templates/responsive2/html/com_content/category/blog.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/libraries/src/MVC/View/CategoryView.php:245
11	Joomla\CMS\MVC\View\CategoryView->display()	JROOT/components/com_content/views/category/view.html.php:250
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.28 ms Después de la última consulta: 0.18 ms Consulta a la memoria: 0.017 MB memoria antes de la consulta: 11.725 MB Filas devueltas: 0

SELECT * 
  FROM zrtco_content_rating 
  WHERE content_id = 66

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	No pudo usarse una clave de índice	NULL	NULL	NULL	NULL	no matching row in const table

Perfil

Status	Duration
starting	0.08 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.09 ms
cleaning up	0.01 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
33	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
32	JDatabaseDriver->loadObject()	JROOT/modules/mod_zentools2/includes/joomla.php:426
31	joomla::getList()	JROOT/modules/mod_zentools2/mod_zentools2.php:52
30	include JROOT/modules/mod_zentools2/mod_zentools2.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
29	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
28	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/system/modulesanywhere/helper.php:519
27	PlgSystemModulesAnywhereHelper->processPosition()	JROOT/plugins/system/modulesanywhere/helper.php:483
26	PlgSystemModulesAnywhereHelper->processMatch()	JROOT/plugins/system/modulesanywhere/helper.php:350
25	PlgSystemModulesAnywhereHelper->replace()	JROOT/plugins/system/modulesanywhere/helper.php:308
24	PlgSystemModulesAnywhereHelper->processModules()	JROOT/plugins/system/nnframework/helpers/helper.php:94
23	NNFrameworkHelper::processArticle()	JROOT/plugins/system/modulesanywhere/helper.php:117
22	PlgSystemModulesAnywhereHelper->onContentPrepare()	JROOT/plugins/system/modulesanywhere/modulesanywhere.php:45
21	PlgSystemModulesAnywhere->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
20	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
19	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
18	JHtmlContent::prepare()	Lo mismo que llamada de la línea de abajo.
17	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
16	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
15	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/templates/responsive2/html/com_content/category/blog.php:41
14	include JROOT/templates/responsive2/html/com_content/category/blog.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/libraries/src/MVC/View/CategoryView.php:245
11	Joomla\CMS\MVC\View\CategoryView->display()	JROOT/components/com_content/views/category/view.html.php:250
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.44 ms Después de la última consulta: 0.06 ms Consulta a la memoria: 0.016 MB memoria antes de la consulta: 11.745 MB Filas devueltas: 0

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

  FROM `zrtco_contentitem_tag_map` AS m 

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

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

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ALL	idx_tag_type,idx_tag	No pudo usarse una clave de índice	NULL	NULL	5	20.00	Using where
1	SIMPLE	t	NULL	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	verticep_mainpackweb.m.tag_id	1	100.00	Using where

Perfil

Status	Duration
starting	0.11 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.04 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.05 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.10 ms
cleaning up	0.01 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
34	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
33	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
32	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/modules/mod_zentools2/includes/joomla.php:439
31	joomla::getList()	JROOT/modules/mod_zentools2/mod_zentools2.php:52
30	include JROOT/modules/mod_zentools2/mod_zentools2.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
29	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
28	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/system/modulesanywhere/helper.php:519
27	PlgSystemModulesAnywhereHelper->processPosition()	JROOT/plugins/system/modulesanywhere/helper.php:483
26	PlgSystemModulesAnywhereHelper->processMatch()	JROOT/plugins/system/modulesanywhere/helper.php:350
25	PlgSystemModulesAnywhereHelper->replace()	JROOT/plugins/system/modulesanywhere/helper.php:308
24	PlgSystemModulesAnywhereHelper->processModules()	JROOT/plugins/system/nnframework/helpers/helper.php:94
23	NNFrameworkHelper::processArticle()	JROOT/plugins/system/modulesanywhere/helper.php:117
22	PlgSystemModulesAnywhereHelper->onContentPrepare()	JROOT/plugins/system/modulesanywhere/modulesanywhere.php:45
21	PlgSystemModulesAnywhere->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
20	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
19	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
18	JHtmlContent::prepare()	Lo mismo que llamada de la línea de abajo.
17	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
16	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
15	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/templates/responsive2/html/com_content/category/blog.php:41
14	include JROOT/templates/responsive2/html/com_content/category/blog.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/libraries/src/MVC/View/CategoryView.php:245
11	Joomla\CMS\MVC\View\CategoryView->display()	JROOT/components/com_content/views/category/view.html.php:250
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.37 ms Después de la última consulta: 0.26 ms Consulta a la memoria: 0.016 MB memoria antes de la consulta: 11.762 MB Filas devueltas: 1

SELECT title,alias

  FROM `zrtco_categories`

  WHERE `id` LIKE 24 
  LIMIT 1

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	zrtco_categories	NULL	ALL	PRIMARY	No pudo usarse una clave de índice	NULL	NULL	27	11.11	Using where

Perfil

Status	Duration
starting	0.14 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.00 ms
freeing items	0.09 ms
cleaning up	0.00 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
34	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
33	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_zentools2/includes/joomla.php:517
32	joomla::get_joomla_cat()	JROOT/modules/mod_zentools2/includes/joomla.php:306
31	joomla::getList()	JROOT/modules/mod_zentools2/mod_zentools2.php:52
30	include JROOT/modules/mod_zentools2/mod_zentools2.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
29	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
28	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/system/modulesanywhere/helper.php:519
27	PlgSystemModulesAnywhereHelper->processPosition()	JROOT/plugins/system/modulesanywhere/helper.php:483
26	PlgSystemModulesAnywhereHelper->processMatch()	JROOT/plugins/system/modulesanywhere/helper.php:350
25	PlgSystemModulesAnywhereHelper->replace()	JROOT/plugins/system/modulesanywhere/helper.php:308
24	PlgSystemModulesAnywhereHelper->processModules()	JROOT/plugins/system/nnframework/helpers/helper.php:94
23	NNFrameworkHelper::processArticle()	JROOT/plugins/system/modulesanywhere/helper.php:117
22	PlgSystemModulesAnywhereHelper->onContentPrepare()	JROOT/plugins/system/modulesanywhere/modulesanywhere.php:45
21	PlgSystemModulesAnywhere->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
20	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
19	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
18	JHtmlContent::prepare()	Lo mismo que llamada de la línea de abajo.
17	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
16	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
15	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/templates/responsive2/html/com_content/category/blog.php:41
14	include JROOT/templates/responsive2/html/com_content/category/blog.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/libraries/src/MVC/View/CategoryView.php:245
11	Joomla\CMS\MVC\View\CategoryView->display()	JROOT/components/com_content/views/category/view.html.php:250
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.58 ms Después de la última consulta: 0.30 ms Consulta a la memoria: 0.020 MB memoria antes de la consulta: 11.785 MB Filas devueltas: 4

SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug

  FROM `zrtco_categories` AS `s`

  INNER JOIN `zrtco_categories` AS `c` 
  ON (s.lft <= c.lft 
  AND c.lft < s.rgt) OR (c.lft < s.lft 
  AND s.rgt < c.rgt)

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND s.id = 24

  ORDER BY c.lft

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	NULL	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	Usando 'filesort'
1	SIMPLE	c	NULL	ALL	cat_idx,idx_access,idx_left_right	No pudo usarse una clave de índice	NULL	NULL	27	46.09	Using where

Perfil

Status	Duration
starting	0.13 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.07 ms
preparing	0.01 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.10 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.11 ms
cleaning up	0.03 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
45	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
44	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
43	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
42	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
41	ContentRouter->getCategorySegment()	Lo mismo que llamada de la línea de abajo.
40	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
39	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
38	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
37	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:676
36	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
35	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
34	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
33	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
32	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_zentools2/includes/joomla.php:349
31	joomla::getList()	JROOT/modules/mod_zentools2/mod_zentools2.php:52
30	include JROOT/modules/mod_zentools2/mod_zentools2.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
29	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
28	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/system/modulesanywhere/helper.php:519
27	PlgSystemModulesAnywhereHelper->processPosition()	JROOT/plugins/system/modulesanywhere/helper.php:483
26	PlgSystemModulesAnywhereHelper->processMatch()	JROOT/plugins/system/modulesanywhere/helper.php:350
25	PlgSystemModulesAnywhereHelper->replace()	JROOT/plugins/system/modulesanywhere/helper.php:308
24	PlgSystemModulesAnywhereHelper->processModules()	JROOT/plugins/system/nnframework/helpers/helper.php:94
23	NNFrameworkHelper::processArticle()	JROOT/plugins/system/modulesanywhere/helper.php:117
22	PlgSystemModulesAnywhereHelper->onContentPrepare()	JROOT/plugins/system/modulesanywhere/modulesanywhere.php:45
21	PlgSystemModulesAnywhere->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
20	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
19	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
18	JHtmlContent::prepare()	Lo mismo que llamada de la línea de abajo.
17	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
16	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
15	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/templates/responsive2/html/com_content/category/blog.php:41
14	include JROOT/templates/responsive2/html/com_content/category/blog.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/libraries/src/MVC/View/CategoryView.php:245
11	Joomla\CMS\MVC\View\CategoryView->display()	JROOT/components/com_content/views/category/view.html.php:250
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.33 ms Después de la última consulta: 0.14 ms Consulta a la memoria: 0.016 MB memoria antes de la consulta: 11.806 MB Filas devueltas: 0

SELECT * 
  FROM zrtco_content_rating 
  WHERE content_id = 69

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	No pudo usarse una clave de índice	NULL	NULL	NULL	NULL	no matching row in const table

Perfil

Status	Duration
starting	0.08 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.01 ms
executing	0.05 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.10 ms
cleaning up	0.00 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
33	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
32	JDatabaseDriver->loadObject()	JROOT/modules/mod_zentools2/includes/joomla.php:426
31	joomla::getList()	JROOT/modules/mod_zentools2/mod_zentools2.php:52
30	include JROOT/modules/mod_zentools2/mod_zentools2.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
29	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
28	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/system/modulesanywhere/helper.php:519
27	PlgSystemModulesAnywhereHelper->processPosition()	JROOT/plugins/system/modulesanywhere/helper.php:483
26	PlgSystemModulesAnywhereHelper->processMatch()	JROOT/plugins/system/modulesanywhere/helper.php:350
25	PlgSystemModulesAnywhereHelper->replace()	JROOT/plugins/system/modulesanywhere/helper.php:308
24	PlgSystemModulesAnywhereHelper->processModules()	JROOT/plugins/system/nnframework/helpers/helper.php:94
23	NNFrameworkHelper::processArticle()	JROOT/plugins/system/modulesanywhere/helper.php:117
22	PlgSystemModulesAnywhereHelper->onContentPrepare()	JROOT/plugins/system/modulesanywhere/modulesanywhere.php:45
21	PlgSystemModulesAnywhere->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
20	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
19	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
18	JHtmlContent::prepare()	Lo mismo que llamada de la línea de abajo.
17	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
16	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
15	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/templates/responsive2/html/com_content/category/blog.php:41
14	include JROOT/templates/responsive2/html/com_content/category/blog.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/libraries/src/MVC/View/CategoryView.php:245
11	Joomla\CMS\MVC\View\CategoryView->display()	JROOT/components/com_content/views/category/view.html.php:250
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.41 ms Después de la última consulta: 0.06 ms Consulta a la memoria: 0.016 MB memoria antes de la consulta: 11.825 MB Filas devueltas: 0

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

  FROM `zrtco_contentitem_tag_map` AS m 

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

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

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ALL	idx_tag_type,idx_tag	No pudo usarse una clave de índice	NULL	NULL	5	20.00	Using where
1	SIMPLE	t	NULL	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	verticep_mainpackweb.m.tag_id	1	100.00	Using where

Perfil

Status	Duration
starting	0.09 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.05 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.00 ms
freeing items	0.10 ms
cleaning up	0.01 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
34	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
33	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
32	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/modules/mod_zentools2/includes/joomla.php:439
31	joomla::getList()	JROOT/modules/mod_zentools2/mod_zentools2.php:52
30	include JROOT/modules/mod_zentools2/mod_zentools2.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
29	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
28	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/system/modulesanywhere/helper.php:519
27	PlgSystemModulesAnywhereHelper->processPosition()	JROOT/plugins/system/modulesanywhere/helper.php:483
26	PlgSystemModulesAnywhereHelper->processMatch()	JROOT/plugins/system/modulesanywhere/helper.php:350
25	PlgSystemModulesAnywhereHelper->replace()	JROOT/plugins/system/modulesanywhere/helper.php:308
24	PlgSystemModulesAnywhereHelper->processModules()	JROOT/plugins/system/nnframework/helpers/helper.php:94
23	NNFrameworkHelper::processArticle()	JROOT/plugins/system/modulesanywhere/helper.php:117
22	PlgSystemModulesAnywhereHelper->onContentPrepare()	JROOT/plugins/system/modulesanywhere/modulesanywhere.php:45
21	PlgSystemModulesAnywhere->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
20	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
19	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
18	JHtmlContent::prepare()	Lo mismo que llamada de la línea de abajo.
17	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
16	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
15	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/templates/responsive2/html/com_content/category/blog.php:41
14	include JROOT/templates/responsive2/html/com_content/category/blog.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/libraries/src/MVC/View/CategoryView.php:245
11	Joomla\CMS\MVC\View\CategoryView->display()	JROOT/components/com_content/views/category/view.html.php:250
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.37 ms Después de la última consulta: 0.23 ms Consulta a la memoria: 0.016 MB memoria antes de la consulta: 11.842 MB Filas devueltas: 1

SELECT title,alias

  FROM `zrtco_categories`

  WHERE `id` LIKE 26 
  LIMIT 1

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	zrtco_categories	NULL	ALL	PRIMARY	No pudo usarse una clave de índice	NULL	NULL	27	11.11	Using where

Perfil

Status	Duration
starting	0.11 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.04 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.09 ms
cleaning up	0.00 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
34	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
33	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_zentools2/includes/joomla.php:517
32	joomla::get_joomla_cat()	JROOT/modules/mod_zentools2/includes/joomla.php:306
31	joomla::getList()	JROOT/modules/mod_zentools2/mod_zentools2.php:52
30	include JROOT/modules/mod_zentools2/mod_zentools2.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
29	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
28	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/system/modulesanywhere/helper.php:519
27	PlgSystemModulesAnywhereHelper->processPosition()	JROOT/plugins/system/modulesanywhere/helper.php:483
26	PlgSystemModulesAnywhereHelper->processMatch()	JROOT/plugins/system/modulesanywhere/helper.php:350
25	PlgSystemModulesAnywhereHelper->replace()	JROOT/plugins/system/modulesanywhere/helper.php:308
24	PlgSystemModulesAnywhereHelper->processModules()	JROOT/plugins/system/nnframework/helpers/helper.php:94
23	NNFrameworkHelper::processArticle()	JROOT/plugins/system/modulesanywhere/helper.php:117
22	PlgSystemModulesAnywhereHelper->onContentPrepare()	JROOT/plugins/system/modulesanywhere/modulesanywhere.php:45
21	PlgSystemModulesAnywhere->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
20	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
19	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
18	JHtmlContent::prepare()	Lo mismo que llamada de la línea de abajo.
17	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
16	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
15	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/templates/responsive2/html/com_content/category/blog.php:41
14	include JROOT/templates/responsive2/html/com_content/category/blog.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/libraries/src/MVC/View/CategoryView.php:245
11	Joomla\CMS\MVC\View\CategoryView->display()	JROOT/components/com_content/views/category/view.html.php:250
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.63 ms Después de la última consulta: 0.10 ms Consulta a la memoria: 0.020 MB memoria antes de la consulta: 11.865 MB Filas devueltas: 4

SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug

  FROM `zrtco_categories` AS `s`

  INNER JOIN `zrtco_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 = 26

  ORDER BY c.lft

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	NULL	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	Usando 'filesort'
1	SIMPLE	c	NULL	ALL	cat_idx,idx_access,idx_left_right	No pudo usarse una clave de índice	NULL	NULL	27	51.85	Using where

Perfil

Status	Duration
starting	0.12 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.07 ms
preparing	0.01 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.06 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.10 ms
cleaning up	0.00 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
45	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
44	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
43	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
42	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
41	ContentRouter->getCategorySegment()	Lo mismo que llamada de la línea de abajo.
40	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
39	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
38	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
37	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:676
36	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
35	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
34	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
33	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
32	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_zentools2/includes/joomla.php:349
31	joomla::getList()	JROOT/modules/mod_zentools2/mod_zentools2.php:52
30	include JROOT/modules/mod_zentools2/mod_zentools2.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
29	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
28	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/system/modulesanywhere/helper.php:519
27	PlgSystemModulesAnywhereHelper->processPosition()	JROOT/plugins/system/modulesanywhere/helper.php:483
26	PlgSystemModulesAnywhereHelper->processMatch()	JROOT/plugins/system/modulesanywhere/helper.php:350
25	PlgSystemModulesAnywhereHelper->replace()	JROOT/plugins/system/modulesanywhere/helper.php:308
24	PlgSystemModulesAnywhereHelper->processModules()	JROOT/plugins/system/nnframework/helpers/helper.php:94
23	NNFrameworkHelper::processArticle()	JROOT/plugins/system/modulesanywhere/helper.php:117
22	PlgSystemModulesAnywhereHelper->onContentPrepare()	JROOT/plugins/system/modulesanywhere/modulesanywhere.php:45
21	PlgSystemModulesAnywhere->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
20	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
19	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
18	JHtmlContent::prepare()	Lo mismo que llamada de la línea de abajo.
17	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
16	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
15	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/templates/responsive2/html/com_content/category/blog.php:41
14	include JROOT/templates/responsive2/html/com_content/category/blog.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/libraries/src/MVC/View/CategoryView.php:245
11	Joomla\CMS\MVC\View\CategoryView->display()	JROOT/components/com_content/views/category/view.html.php:250
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.28 ms Después de la última consulta: 0.35 ms Consulta a la memoria: 0.016 MB memoria antes de la consulta: 11.886 MB Filas devueltas: 0

SELECT * 
  FROM zrtco_content_rating 
  WHERE content_id = 70

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	No pudo usarse una clave de índice	NULL	NULL	NULL	NULL	no matching row in const table

Perfil

Status	Duration
starting	0.09 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.01 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.09 ms
cleaning up	0.00 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
33	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
32	JDatabaseDriver->loadObject()	JROOT/modules/mod_zentools2/includes/joomla.php:426
31	joomla::getList()	JROOT/modules/mod_zentools2/mod_zentools2.php:52
30	include JROOT/modules/mod_zentools2/mod_zentools2.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
29	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
28	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/system/modulesanywhere/helper.php:519
27	PlgSystemModulesAnywhereHelper->processPosition()	JROOT/plugins/system/modulesanywhere/helper.php:483
26	PlgSystemModulesAnywhereHelper->processMatch()	JROOT/plugins/system/modulesanywhere/helper.php:350
25	PlgSystemModulesAnywhereHelper->replace()	JROOT/plugins/system/modulesanywhere/helper.php:308
24	PlgSystemModulesAnywhereHelper->processModules()	JROOT/plugins/system/nnframework/helpers/helper.php:94
23	NNFrameworkHelper::processArticle()	JROOT/plugins/system/modulesanywhere/helper.php:117
22	PlgSystemModulesAnywhereHelper->onContentPrepare()	JROOT/plugins/system/modulesanywhere/modulesanywhere.php:45
21	PlgSystemModulesAnywhere->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
20	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
19	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
18	JHtmlContent::prepare()	Lo mismo que llamada de la línea de abajo.
17	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
16	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
15	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/templates/responsive2/html/com_content/category/blog.php:41
14	include JROOT/templates/responsive2/html/com_content/category/blog.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/libraries/src/MVC/View/CategoryView.php:245
11	Joomla\CMS\MVC\View\CategoryView->display()	JROOT/components/com_content/views/category/view.html.php:250
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.37 ms Después de la última consulta: 0.06 ms Consulta a la memoria: 0.016 MB memoria antes de la consulta: 11.905 MB Filas devueltas: 0

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

  FROM `zrtco_contentitem_tag_map` AS m 

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

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

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ALL	idx_tag_type,idx_tag	No pudo usarse una clave de índice	NULL	NULL	5	20.00	Using where
1	SIMPLE	t	NULL	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	verticep_mainpackweb.m.tag_id	1	100.00	Using where

Perfil

Status	Duration
starting	0.09 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.09 ms
cleaning up	0.00 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
34	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
33	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
32	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/modules/mod_zentools2/includes/joomla.php:439
31	joomla::getList()	JROOT/modules/mod_zentools2/mod_zentools2.php:52
30	include JROOT/modules/mod_zentools2/mod_zentools2.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
29	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
28	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/system/modulesanywhere/helper.php:519
27	PlgSystemModulesAnywhereHelper->processPosition()	JROOT/plugins/system/modulesanywhere/helper.php:483
26	PlgSystemModulesAnywhereHelper->processMatch()	JROOT/plugins/system/modulesanywhere/helper.php:350
25	PlgSystemModulesAnywhereHelper->replace()	JROOT/plugins/system/modulesanywhere/helper.php:308
24	PlgSystemModulesAnywhereHelper->processModules()	JROOT/plugins/system/nnframework/helpers/helper.php:94
23	NNFrameworkHelper::processArticle()	JROOT/plugins/system/modulesanywhere/helper.php:117
22	PlgSystemModulesAnywhereHelper->onContentPrepare()	JROOT/plugins/system/modulesanywhere/modulesanywhere.php:45
21	PlgSystemModulesAnywhere->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
20	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
19	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
18	JHtmlContent::prepare()	Lo mismo que llamada de la línea de abajo.
17	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
16	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
15	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/templates/responsive2/html/com_content/category/blog.php:41
14	include JROOT/templates/responsive2/html/com_content/category/blog.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/libraries/src/MVC/View/CategoryView.php:245
11	Joomla\CMS\MVC\View\CategoryView->display()	JROOT/components/com_content/views/category/view.html.php:250
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.34 ms Después de la última consulta: 0.28 ms Consulta a la memoria: 0.016 MB memoria antes de la consulta: 11.922 MB Filas devueltas: 1

SELECT title,alias

  FROM `zrtco_categories`

  WHERE `id` LIKE 27 
  LIMIT 1

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	zrtco_categories	NULL	ALL	PRIMARY	No pudo usarse una clave de índice	NULL	NULL	27	11.11	Using where

Perfil

Status	Duration
starting	0.11 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.09 ms
cleaning up	0.00 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
34	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
33	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_zentools2/includes/joomla.php:517
32	joomla::get_joomla_cat()	JROOT/modules/mod_zentools2/includes/joomla.php:306
31	joomla::getList()	JROOT/modules/mod_zentools2/mod_zentools2.php:52
30	include JROOT/modules/mod_zentools2/mod_zentools2.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
29	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
28	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/system/modulesanywhere/helper.php:519
27	PlgSystemModulesAnywhereHelper->processPosition()	JROOT/plugins/system/modulesanywhere/helper.php:483
26	PlgSystemModulesAnywhereHelper->processMatch()	JROOT/plugins/system/modulesanywhere/helper.php:350
25	PlgSystemModulesAnywhereHelper->replace()	JROOT/plugins/system/modulesanywhere/helper.php:308
24	PlgSystemModulesAnywhereHelper->processModules()	JROOT/plugins/system/nnframework/helpers/helper.php:94
23	NNFrameworkHelper::processArticle()	JROOT/plugins/system/modulesanywhere/helper.php:117
22	PlgSystemModulesAnywhereHelper->onContentPrepare()	JROOT/plugins/system/modulesanywhere/modulesanywhere.php:45
21	PlgSystemModulesAnywhere->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
20	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
19	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
18	JHtmlContent::prepare()	Lo mismo que llamada de la línea de abajo.
17	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
16	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
15	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/templates/responsive2/html/com_content/category/blog.php:41
14	include JROOT/templates/responsive2/html/com_content/category/blog.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/libraries/src/MVC/View/CategoryView.php:245
11	Joomla\CMS\MVC\View\CategoryView->display()	JROOT/components/com_content/views/category/view.html.php:250
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.54 ms Después de la última consulta: 0.10 ms Consulta a la memoria: 0.020 MB memoria antes de la consulta: 11.945 MB Filas devueltas: 4

SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug

  FROM `zrtco_categories` AS `s`

  INNER JOIN `zrtco_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 = 27

  ORDER BY c.lft

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	NULL	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	Usando 'filesort'
1	SIMPLE	c	NULL	ALL	cat_idx,idx_access,idx_left_right	No pudo usarse una clave de índice	NULL	NULL	27	54.73	Using where

Perfil

Status	Duration
starting	0.13 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.03 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.03 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.07 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.00 ms
freeing items	0.10 ms
cleaning up	0.00 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
45	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
44	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
43	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
42	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
41	ContentRouter->getCategorySegment()	Lo mismo que llamada de la línea de abajo.
40	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
39	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
38	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
37	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:676
36	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
35	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
34	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
33	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
32	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_zentools2/includes/joomla.php:349
31	joomla::getList()	JROOT/modules/mod_zentools2/mod_zentools2.php:52
30	include JROOT/modules/mod_zentools2/mod_zentools2.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
29	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
28	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/system/modulesanywhere/helper.php:519
27	PlgSystemModulesAnywhereHelper->processPosition()	JROOT/plugins/system/modulesanywhere/helper.php:483
26	PlgSystemModulesAnywhereHelper->processMatch()	JROOT/plugins/system/modulesanywhere/helper.php:350
25	PlgSystemModulesAnywhereHelper->replace()	JROOT/plugins/system/modulesanywhere/helper.php:308
24	PlgSystemModulesAnywhereHelper->processModules()	JROOT/plugins/system/nnframework/helpers/helper.php:94
23	NNFrameworkHelper::processArticle()	JROOT/plugins/system/modulesanywhere/helper.php:117
22	PlgSystemModulesAnywhereHelper->onContentPrepare()	JROOT/plugins/system/modulesanywhere/modulesanywhere.php:45
21	PlgSystemModulesAnywhere->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
20	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
19	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
18	JHtmlContent::prepare()	Lo mismo que llamada de la línea de abajo.
17	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
16	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
15	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/templates/responsive2/html/com_content/category/blog.php:41
14	include JROOT/templates/responsive2/html/com_content/category/blog.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/libraries/src/MVC/View/CategoryView.php:245
11	Joomla\CMS\MVC\View\CategoryView->display()	JROOT/components/com_content/views/category/view.html.php:250
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.29 ms Después de la última consulta: 0.15 ms Consulta a la memoria: 0.016 MB memoria antes de la consulta: 11.966 MB Filas devueltas: 0

SELECT * 
  FROM zrtco_content_rating 
  WHERE content_id = 71

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	No pudo usarse una clave de índice	NULL	NULL	NULL	NULL	no matching row in const table

Perfil

Status	Duration
starting	0.09 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.00 ms
statistics	0.01 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.09 ms
cleaning up	0.00 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
33	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
32	JDatabaseDriver->loadObject()	JROOT/modules/mod_zentools2/includes/joomla.php:426
31	joomla::getList()	JROOT/modules/mod_zentools2/mod_zentools2.php:52
30	include JROOT/modules/mod_zentools2/mod_zentools2.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
29	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
28	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/system/modulesanywhere/helper.php:519
27	PlgSystemModulesAnywhereHelper->processPosition()	JROOT/plugins/system/modulesanywhere/helper.php:483
26	PlgSystemModulesAnywhereHelper->processMatch()	JROOT/plugins/system/modulesanywhere/helper.php:350
25	PlgSystemModulesAnywhereHelper->replace()	JROOT/plugins/system/modulesanywhere/helper.php:308
24	PlgSystemModulesAnywhereHelper->processModules()	JROOT/plugins/system/nnframework/helpers/helper.php:94
23	NNFrameworkHelper::processArticle()	JROOT/plugins/system/modulesanywhere/helper.php:117
22	PlgSystemModulesAnywhereHelper->onContentPrepare()	JROOT/plugins/system/modulesanywhere/modulesanywhere.php:45
21	PlgSystemModulesAnywhere->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
20	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
19	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
18	JHtmlContent::prepare()	Lo mismo que llamada de la línea de abajo.
17	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
16	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
15	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/templates/responsive2/html/com_content/category/blog.php:41
14	include JROOT/templates/responsive2/html/com_content/category/blog.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/libraries/src/MVC/View/CategoryView.php:245
11	Joomla\CMS\MVC\View\CategoryView->display()	JROOT/components/com_content/views/category/view.html.php:250
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.38 ms Después de la última consulta: 0.06 ms Consulta a la memoria: 0.016 MB memoria antes de la consulta: 11.984 MB Filas devueltas: 0

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

  FROM `zrtco_contentitem_tag_map` AS m 

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

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

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ALL	idx_tag_type,idx_tag	No pudo usarse una clave de índice	NULL	NULL	5	20.00	Using where
1	SIMPLE	t	NULL	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	verticep_mainpackweb.m.tag_id	1	100.00	Using where

Perfil

Status	Duration
starting	0.08 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.12 ms
cleaning up	0.00 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
34	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
33	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
32	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/modules/mod_zentools2/includes/joomla.php:439
31	joomla::getList()	JROOT/modules/mod_zentools2/mod_zentools2.php:52
30	include JROOT/modules/mod_zentools2/mod_zentools2.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
29	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
28	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/system/modulesanywhere/helper.php:519
27	PlgSystemModulesAnywhereHelper->processPosition()	JROOT/plugins/system/modulesanywhere/helper.php:483
26	PlgSystemModulesAnywhereHelper->processMatch()	JROOT/plugins/system/modulesanywhere/helper.php:350
25	PlgSystemModulesAnywhereHelper->replace()	JROOT/plugins/system/modulesanywhere/helper.php:308
24	PlgSystemModulesAnywhereHelper->processModules()	JROOT/plugins/system/nnframework/helpers/helper.php:94
23	NNFrameworkHelper::processArticle()	JROOT/plugins/system/modulesanywhere/helper.php:117
22	PlgSystemModulesAnywhereHelper->onContentPrepare()	JROOT/plugins/system/modulesanywhere/modulesanywhere.php:45
21	PlgSystemModulesAnywhere->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
20	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
19	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
18	JHtmlContent::prepare()	Lo mismo que llamada de la línea de abajo.
17	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
16	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
15	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/templates/responsive2/html/com_content/category/blog.php:41
14	include JROOT/templates/responsive2/html/com_content/category/blog.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/libraries/src/MVC/View/CategoryView.php:245
11	Joomla\CMS\MVC\View\CategoryView->display()	JROOT/components/com_content/views/category/view.html.php:250
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.31 ms Después de la última consulta: 0.23 ms Consulta a la memoria: 0.016 MB memoria antes de la consulta: 12.002 MB Filas devueltas: 1

SELECT title,alias

  FROM `zrtco_categories`

  WHERE `id` LIKE 28 
  LIMIT 1

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	zrtco_categories	NULL	ALL	PRIMARY	No pudo usarse una clave de índice	NULL	NULL	27	11.11	Using where

Perfil

Status	Duration
starting	0.09 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.08 ms
cleaning up	0.01 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
34	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
33	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_zentools2/includes/joomla.php:517
32	joomla::get_joomla_cat()	JROOT/modules/mod_zentools2/includes/joomla.php:306
31	joomla::getList()	JROOT/modules/mod_zentools2/mod_zentools2.php:52
30	include JROOT/modules/mod_zentools2/mod_zentools2.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
29	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
28	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/system/modulesanywhere/helper.php:519
27	PlgSystemModulesAnywhereHelper->processPosition()	JROOT/plugins/system/modulesanywhere/helper.php:483
26	PlgSystemModulesAnywhereHelper->processMatch()	JROOT/plugins/system/modulesanywhere/helper.php:350
25	PlgSystemModulesAnywhereHelper->replace()	JROOT/plugins/system/modulesanywhere/helper.php:308
24	PlgSystemModulesAnywhereHelper->processModules()	JROOT/plugins/system/nnframework/helpers/helper.php:94
23	NNFrameworkHelper::processArticle()	JROOT/plugins/system/modulesanywhere/helper.php:117
22	PlgSystemModulesAnywhereHelper->onContentPrepare()	JROOT/plugins/system/modulesanywhere/modulesanywhere.php:45
21	PlgSystemModulesAnywhere->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
20	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
19	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
18	JHtmlContent::prepare()	Lo mismo que llamada de la línea de abajo.
17	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
16	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
15	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/templates/responsive2/html/com_content/category/blog.php:41
14	include JROOT/templates/responsive2/html/com_content/category/blog.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/libraries/src/MVC/View/CategoryView.php:245
11	Joomla\CMS\MVC\View\CategoryView->display()	JROOT/components/com_content/views/category/view.html.php:250
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.55 ms Después de la última consulta: 0.10 ms Consulta a la memoria: 0.020 MB memoria antes de la consulta: 12.025 MB Filas devueltas: 4

SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug

  FROM `zrtco_categories` AS `s`

  INNER JOIN `zrtco_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 = 28

  ORDER BY c.lft

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	NULL	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	Usando 'filesort'
1	SIMPLE	c	NULL	ALL	cat_idx,idx_access,idx_left_right	No pudo usarse una clave de índice	NULL	NULL	27	57.61	Using where

Perfil

Status	Duration
starting	0.12 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.03 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.10 ms
preparing	0.02 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
Creating sort index	0.06 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.10 ms
cleaning up	0.01 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
45	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
44	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
43	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
42	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
41	ContentRouter->getCategorySegment()	Lo mismo que llamada de la línea de abajo.
40	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
39	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
38	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
37	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:676
36	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
35	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
34	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
33	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
32	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_zentools2/includes/joomla.php:349
31	joomla::getList()	JROOT/modules/mod_zentools2/mod_zentools2.php:52
30	include JROOT/modules/mod_zentools2/mod_zentools2.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
29	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
28	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/system/modulesanywhere/helper.php:519
27	PlgSystemModulesAnywhereHelper->processPosition()	JROOT/plugins/system/modulesanywhere/helper.php:483
26	PlgSystemModulesAnywhereHelper->processMatch()	JROOT/plugins/system/modulesanywhere/helper.php:350
25	PlgSystemModulesAnywhereHelper->replace()	JROOT/plugins/system/modulesanywhere/helper.php:308
24	PlgSystemModulesAnywhereHelper->processModules()	JROOT/plugins/system/nnframework/helpers/helper.php:94
23	NNFrameworkHelper::processArticle()	JROOT/plugins/system/modulesanywhere/helper.php:117
22	PlgSystemModulesAnywhereHelper->onContentPrepare()	JROOT/plugins/system/modulesanywhere/modulesanywhere.php:45
21	PlgSystemModulesAnywhere->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
20	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
19	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
18	JHtmlContent::prepare()	Lo mismo que llamada de la línea de abajo.
17	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
16	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
15	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/templates/responsive2/html/com_content/category/blog.php:41
14	include JROOT/templates/responsive2/html/com_content/category/blog.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/libraries/src/MVC/View/CategoryView.php:245
11	Joomla\CMS\MVC\View\CategoryView->display()	JROOT/components/com_content/views/category/view.html.php:250
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.27 ms Después de la última consulta: 0.16 ms Consulta a la memoria: 0.016 MB memoria antes de la consulta: 12.045 MB Filas devueltas: 0

SELECT * 
  FROM zrtco_content_rating 
  WHERE content_id = 72

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	No pudo usarse una clave de índice	NULL	NULL	NULL	NULL	no matching row in const table

Perfil

Status	Duration
starting	0.08 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.01 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.07 ms
cleaning up	0.00 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
33	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
32	JDatabaseDriver->loadObject()	JROOT/modules/mod_zentools2/includes/joomla.php:426
31	joomla::getList()	JROOT/modules/mod_zentools2/mod_zentools2.php:52
30	include JROOT/modules/mod_zentools2/mod_zentools2.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
29	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
28	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/system/modulesanywhere/helper.php:519
27	PlgSystemModulesAnywhereHelper->processPosition()	JROOT/plugins/system/modulesanywhere/helper.php:483
26	PlgSystemModulesAnywhereHelper->processMatch()	JROOT/plugins/system/modulesanywhere/helper.php:350
25	PlgSystemModulesAnywhereHelper->replace()	JROOT/plugins/system/modulesanywhere/helper.php:308
24	PlgSystemModulesAnywhereHelper->processModules()	JROOT/plugins/system/nnframework/helpers/helper.php:94
23	NNFrameworkHelper::processArticle()	JROOT/plugins/system/modulesanywhere/helper.php:117
22	PlgSystemModulesAnywhereHelper->onContentPrepare()	JROOT/plugins/system/modulesanywhere/modulesanywhere.php:45
21	PlgSystemModulesAnywhere->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
20	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
19	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
18	JHtmlContent::prepare()	Lo mismo que llamada de la línea de abajo.
17	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
16	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
15	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/templates/responsive2/html/com_content/category/blog.php:41
14	include JROOT/templates/responsive2/html/com_content/category/blog.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/libraries/src/MVC/View/CategoryView.php:245
11	Joomla\CMS\MVC\View\CategoryView->display()	JROOT/components/com_content/views/category/view.html.php:250
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.49 ms Después de la última consulta: 0.06 ms Consulta a la memoria: 0.016 MB memoria antes de la consulta: 12.064 MB Filas devueltas: 0

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

  FROM `zrtco_contentitem_tag_map` AS m 

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

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

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ALL	idx_tag_type,idx_tag	No pudo usarse una clave de índice	NULL	NULL	5	20.00	Using where
1	SIMPLE	t	NULL	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	verticep_mainpackweb.m.tag_id	1	100.00	Using where

Perfil

Status	Duration
starting	0.10 ms
checking permissions	0.01 ms
checking permissions	0.04 ms
Opening tables	0.01 ms
init	0.04 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.09 ms
cleaning up	0.04 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
34	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
33	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
32	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/modules/mod_zentools2/includes/joomla.php:439
31	joomla::getList()	JROOT/modules/mod_zentools2/mod_zentools2.php:52
30	include JROOT/modules/mod_zentools2/mod_zentools2.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
29	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
28	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/system/modulesanywhere/helper.php:519
27	PlgSystemModulesAnywhereHelper->processPosition()	JROOT/plugins/system/modulesanywhere/helper.php:483
26	PlgSystemModulesAnywhereHelper->processMatch()	JROOT/plugins/system/modulesanywhere/helper.php:350
25	PlgSystemModulesAnywhereHelper->replace()	JROOT/plugins/system/modulesanywhere/helper.php:308
24	PlgSystemModulesAnywhereHelper->processModules()	JROOT/plugins/system/nnframework/helpers/helper.php:94
23	NNFrameworkHelper::processArticle()	JROOT/plugins/system/modulesanywhere/helper.php:117
22	PlgSystemModulesAnywhereHelper->onContentPrepare()	JROOT/plugins/system/modulesanywhere/modulesanywhere.php:45
21	PlgSystemModulesAnywhere->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
20	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
19	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
18	JHtmlContent::prepare()	Lo mismo que llamada de la línea de abajo.
17	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
16	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
15	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/templates/responsive2/html/com_content/category/blog.php:41
14	include JROOT/templates/responsive2/html/com_content/category/blog.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/libraries/src/MVC/View/CategoryView.php:245
11	Joomla\CMS\MVC\View\CategoryView->display()	JROOT/components/com_content/views/category/view.html.php:250
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

25 tipo de consultas registradas, ordenadas por la ocurrencia

Tablas SELECCIONADAS:

7 × SELECT `m`.`tag_id`,`t`.* 
  FROM `zrtco_contentitem_tag_map` AS m  
  INNER JOIN `zrtco_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

6 × SELECT * 
  FROM zrtco_content_rating

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

6 × SELECT title,alias 
  FROM `zrtco_categories`

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

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

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

```
2 × SELECT `id` 
  FROM `zrtco_users`
```

1 × SELECT `data` 
  FROM `zrtco_session`

```
1 × SELECT * 
  FROM `zrtco_users`
```
```
1 × SELECT * 
  FROM zrtco_content
```

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

1 × SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN c.published = 2 
  AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language,  LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
  CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum  / v.rating_count, 0), 0), 0) AS rating,        COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count 
  FROM zrtco_content AS a 
  LEFT JOIN zrtco_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN zrtco_users AS ua 
  ON ua.id = a.created_by 
  LEFT JOIN zrtco_users AS uam 
  ON uam.id = a.modified_by 
  LEFT JOIN zrtco_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN zrtco_content_rating AS v 
  ON a.id = v.content_id

1 × SELECT COUNT(*) 
  FROM zrtco_content AS a 
  LEFT JOIN zrtco_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN zrtco_users AS ua 
  ON ua.id = a.created_by 
  LEFT JOIN zrtco_users AS uam 
  ON uam.id = a.modified_by 
  LEFT JOIN zrtco_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN zrtco_content_rating AS v 
  ON a.id = v.content_id

1 × SELECT `session_id` 
  FROM `zrtco_session`

1 × 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,( SELECT COUNT(i.`id`) 
  FROM `zrtco_content` AS `i`

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

```
1 × SELECT * 
  FROM zrtco_languages
```

1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component 
  FROM zrtco_menu AS m 
  LEFT JOIN zrtco_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 zrtco_extensions

1 × SELECT id, rules 
  FROM `zrtco_viewlevels

1 × SELECT `g`.`id`,`g`.`title` 
  FROM `zrtco_usergroups` AS g 
  INNER JOIN `zrtco_user_usergroup_map` AS m 
  ON m.group_id = g.id

OTRAS tablas:

1 × INSERT INTO `zrtco_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  (X'3164646339656135666239303066326136656435396535386130376433393965', 1, 1701592025, 0, '', 0

1 × UPDATE `zrtco_extensions` 
  SET `params` = '{\"mediaversion\":\"fd2bd541593f9ebd099d3c3a857189c6\"}'

1 × SHOW FULL COLUMNS 
  FROM `zrtco_users

Información de interés

MPK - Maquinaria e Insumos de Empaque -

Consola de depuración de Joomla!

Sesión

Información del perfil

Fecha y hora

Memoria

Uso de la memoria

Consultas de la base de datos

50 consultas registradas 46.74 ms

¡ 4 duplicaciones detectadas!

25 tipo de consultas registradas, ordenadas por la ocurrencia

Tablas SELECCIONADAS:

OTRAS tablas: