Red de Investigadores de Juegos de Rol

6to Coloquio Internacional de Estudios sobre Juegos de Rol

De la Simulación a la Inclusión Social

Convocatoria

La Red de Investigadores de Juegos de Rol (RIJR) y la Universidad Autónoma de Yucatán (UADY), invitan a participar al 6^o Coloquio Internacional de Estudios sobre Juegos de Rol.

Fechas importantes:

1.- Fecha límite de registro de propuesta: 20 de mayo de 2022

2.- Envío de dictamen: 22 de Julio de 2022

3.- Fecha límite de recepción de ponencia en formato artículo: 9 de Septiembre de 2022

4.- Presentación oral y/o virtual de ponencias: 17 y 18 de noviembre de 2022 en la Facultad de Ciencias Antropológicas de la Universidad Autónoma de Yucatán, Mérida, México.

1.Proceso de aceptación y presentación de propuesta:

A) Puede participar toda persona interesada en el tema.
B) La propuesta deberá someterse, a más tardar, el 20 de mayo del 2022 en https://academiadelrol.org.mx/index.php/coloquio-2022/registro2022 previamente deberá registrarse como investigador en la misma página de la Red en el apartado “Únete” o bajo la dirección: https://academiadelrol.org.mx/index.php/unete. En caso de dudas, contactar al correo academiadelrol@gmail.com. Solo una propuesta puede ser sometida por autor principal
C) La propuesta deberá contener:
Título de la ponencia.
Autor(es).

III. Universidad, institución o grupo de adscripción, por autor.

Correo electrónico de contacto, por autor.
Teléfono de contacto.
País.

VII. Estado.

VIII. Un resumen de 300 a 500 palabras.

Línea de investigación (ver apartado D).
Palabras claves (3 a 5).
D) La propuesta deberá explicitar la línea de investigación a la que está encuadrada:
Antropología y Sociología
Estudios Culturales
Psicología y Pedagogía
Arte y Filosofía
Literatura y Narrativa
Comunicación y Gestión Cultural
Diseño y Desarrollo de Contenido
Historia de los Juegos de Rol en México y el Mundo
Otra línea

E) A partir del 22 de julio de 2022 se comunicará, vía electrónica, el dictamen de la propuesta a cada interesado(a).
F) De ser aceptada la propuesta, se participará con una ponencia en formato artículo y una presentación oral/virtual de dicha ponencia (17 y 18 de noviembre 2022).
G) Tanto el artículo como la ponencia deberán corresponder a la propuesta registrada e incluir –en este orden- las siguientes secciones:
Introducción (concisa, planteando los objetivos de la investigación),
Aproximación teórica y/o metodológica (breve y que permita conocer los supuestos teóricos que guían la investigación, así como herramientas metodológicas y categorías de análisis),

iii. Resultados (explicación detallada de los hallazgos fundamentales y exposición de alcances y límites de la investigación),

Conclusiones (breve y con las consideraciones finales).
H) Las normas de estilo, citas y referencias serán acordes a las estipuladas en el Manual de estilo de publicaciones APA (7ª edición), en archivos de Word (versión 97 o posteriores) con una extensión de 4000 a 6000 palabras (sin considerar referencias y anexos), en un formato de letra Arial a 12 puntos con interlineado de 1.5 líneas
I) La presentación oral de la ponencia deberá centrarse en las secciones mencionadas en el apartado G y tener una duración máxima de 20 minutos. La presentación oral estará acompañada de un breve espacio de preguntas y respuestas.

Aspectos generales:
J) La recepción de propuestas no implica la aceptación de estas.
K) La evaluación de la propuesta, se realizará por personas reconocidas en el ámbito académico con grado de Doctor y conocimiento en juegos de rol en formato doble ciego.
L) Las investigaciones y trabajos en equipo pueden dar lugar a más de una comunicación. No obstante, no cabe fragmentarla sin responder a los apartados señalados en los puntos anteriores.
M) Cuando una comunicación lleve la firma de varios investigadores(as) aparecerá en las actas del coloquio con el orden de autoría que se haya propuesto en la ponencia y artículo.
N) Únicamente se expedirán constancias a aquellas personas que hayan sido aceptadas en el coloquio, efectuado la presentación y enviado su artículo completo en la fecha límite.
O) Únicamente se aceptará la presentación de una ponencia como primer firmante, pero una misma persona podrá firmar como segundo o tercer firmante hasta un máximo de tres ponencias.
P) La propuesta de las ponencias que se presentarán en el 6º Coloquio Internacional de Estudios sobre Juegos de Rol se enviará con anticipación vía correo electrónico a sus participantes y se dará a conocer la programación final al público.
Q) Para mayor información sobre el coloquio pueden consultar las páginas web https://academiadelrol.org.mx, facebook.com/academiadelrol o al correo electrónico academiadelrol@gmail.com

Lanzando los dados

Nos enorgullece presentar Lanzando los dados, publicación derivada del Primer Coloquio de Estudios sobre Juegos de Rol (2016) en la Universidad Iberoamericana.

Por ahora se encuentra a la venta en:

Formato físico:

Librería Virtual | LANZANDO LOS DADOS: APROXIMACIONES ACADÉMICAS A LOS JUEGOS DE ROL. (uia.mx)

Lanzando los dados. Aproximaciones académicas a los juegos de rol. RANGEL JIMENEZ MAURICIO. Libro en papel. 9786074176957 Librería El Sótano (elsotano.com)

Formato virtual:

Lanzando los dados: aproximaciones académicas a los juegos de rol.: Mauricio Rangel Jiménez: Amazon.com.mx: Libros

Lanzando los dados: aproximaciones académicas a los juegos de rol de Mauricio Rangel Jiménez en Gandhi

Apple Books:

https://books.apple.com/us/book/id1563451755?id=1563451755

Amazon:

https://www.amazon.com/dp/B093BDCY95/

Google Play:

https://play.google.com/store/books/details?id=S-grEAAAQBAJ

Kobo:

https://www.kobo.com/mx/es/ebook/lanzando-los-dados-aproximaciones-academicas-a-los-juegos-de-rol

Bookmate:

https://es.bookmate.com/books/jtGg4P0b?dscvr=top_result

: Visto: 49

Memorias del 3er. Coloquio de Estudios sobre Juegos de Rol

https://digitalcommons.njit.edu/stemresources/21/

: Visto: 519

: Visto: 375

Consola de depuración de Joomla!

Sesión

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1675756072,
                "last": 1675756072,
                "now": 1675756072
            },
            "token": "5V9Rg14Wtz9zVbRDVsYNAPf435X8VTOa"
        },
        "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: 25.65 ms / 25.65 ms Memoria: 1.817 MB / 2.20 MB Application: afterLoad

Fecha y hora: 82.83 ms / 108.48 ms Memoria: 4.883 MB / 7.09 MB Application: afterInitialise

Fecha y hora: 16.95 ms / 125.44 ms Memoria: 0.875 MB / 7.96 MB Application: afterRoute

Fecha y hora: 1.29 ms / 126.72 ms Memoria: 0.100 MB / 8.06 MB Application: beforeRenderComponent com_content

Fecha y hora: 9.46 ms / 136.18 ms Memoria: 0.594 MB / 8.66 MB Application: Before Access::preloadComponents (all components)

Fecha y hora: 1.92 ms / 138.10 ms Memoria: 0.063 MB / 8.72 MB Application: After Access::preloadComponents (all components)

Fecha y hora: 0.03 ms / 138.13 ms Memoria: -0.003 MB / 8.72 MB Application: Before Access::preloadPermissions (com_content)

Fecha y hora: 1.06 ms / 139.19 ms Memoria: 0.053 MB / 8.77 MB Application: After Access::preloadPermissions (com_content)

Fecha y hora: 0.03 ms / 139.23 ms Memoria: -0.002 MB / 8.77 MB Application: Before Access::getAssetRules (id:131 name:com_content.category.20)

Fecha y hora: 0.70 ms / 139.93 ms Memoria: 0.027 MB / 8.79 MB Application: After Access::getAssetRules (id:131 name:com_content.category.20)

Fecha y hora: 7.01 ms / 146.93 ms Memoria: 0.273 MB / 9.07 MB Application: Before Access::getAssetRules (id:8 name:com_content)

Fecha y hora: 0.03 ms / 146.96 ms Memoria: 0.002 MB / 9.07 MB Application: After Access::getAssetRules (id:8 name:com_content)

Fecha y hora: 55.74 ms / 202.70 ms Memoria: 2.188 MB / 11.26 MB Application: afterRenderComponent com_content

Fecha y hora: 0.49 ms / 203.19 ms Memoria: 0.006 MB / 11.26 MB Application: afterDispatch

Fecha y hora: 403.55 ms / 606.74 ms Memoria: 1.721 MB / 12.98 MB Application: beforeRenderModule mod_cblogin (Ingresa o regístrate)

Fecha y hora: 100.79 ms / 707.53 ms Memoria: 7.584 MB / 20.57 MB Application: afterRenderModule mod_cblogin (Ingresa o regístrate)

Fecha y hora: 1.29 ms / 708.82 ms Memoria: 0.011 MB / 20.58 MB Application: beforeRenderModule mod_menu (User Menu)

Fecha y hora: 2.30 ms / 711.12 ms Memoria: 0.036 MB / 20.61 MB Application: afterRenderModule mod_menu (User Menu)

Fecha y hora: 282.02 ms / 993.13 ms Memoria: -0.002 MB / 20.61 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)

Fecha y hora: 1.73 ms / 994.86 ms Memoria: 0.026 MB / 20.64 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)

Fecha y hora: 568.04 ms / 1562.90 ms Memoria: 0.022 MB / 20.66 MB Application: beforeRenderModule mod_klixo_articles_slider (Klixo Articles Slider)

Fecha y hora: 8.89 ms / 1571.80 ms Memoria: 0.787 MB / 21.45 MB Application: afterRenderModule mod_klixo_articles_slider (Klixo Articles Slider)

Fecha y hora: 773.97 ms / 2345.77 ms Memoria: 0.010 MB / 21.46 MB Application: beforeRenderModule mod_menu (Main Menu)

Fecha y hora: 12.50 ms / 2358.27 ms Memoria: 0.354 MB / 21.81 MB Application: afterRenderModule mod_menu (Main Menu)

Fecha y hora: 16.59 ms / 2374.86 ms Memoria: 0.028 MB / 21.84 MB Application: beforeRenderModule mod_search (Search)

Fecha y hora: 1.73 ms / 2376.58 ms Memoria: 0.022 MB / 21.86 MB Application: afterRenderModule mod_search (Search)

Fecha y hora: 514.69 ms / 2891.28 ms Memoria: -0.888 MB / 20.97 MB Application: afterRender

Total de consultas a la base de datos: 45.01 ms

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

Status	Duration
starting	0.37 ms
checking permissions	0.05 ms
Opening tables	0.12 ms
init	0.05 ms
System lock	0.03 ms
optimizing	0.03 ms
statistics	0.18 ms
executing	0.03 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.02 ms
freeing items	0.13 ms
cleaning up	0.03 ms

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jos_session	NULL	const	PRIMARY	PRIMARY	194	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:834
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:392
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 `jos_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3865373931663566363063653137376134306538353732396134666634316361', 1, 1675756072, 0, '', 0)

Perfil

Status	Duration
starting	0.14 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.01 ms
update	0.46 ms
Waiting for query cache lock	0.01 ms
update	0.02 ms
end	0.01 ms
query end	1.51 ms
closing tables	0.04 ms
freeing items	0.11 ms
cleaning up	0.03 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:834
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:392
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: 0.87 ms Después de la última consulta: 8.61 ms Consulta a la memoria: 0.021 MB memoria antes de la consulta: 4.608 MB Filas devueltas: 5

SELECT id, rules

  FROM `jos_viewlevels`

Explicar

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

Perfil

Status	Duration
starting	0.21 ms
checking permissions	0.02 ms
Opening tables	0.07 ms
init	0.03 ms
System lock	0.04 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.17 ms
end	0.01 ms
query end	0.02 ms
closing tables	0.02 ms
freeing items	0.09 ms
cleaning up	0.05 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:203
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.87 ms Después de la última consulta: 0.15 ms Consulta a la memoria: 0.021 MB memoria antes de la consulta: 4.621 MB Filas devueltas: 2

SELECT b.id

  FROM jos_usergroups AS a

  LEFT JOIN jos_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.16 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
Opening tables	0.10 ms
init	0.04 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.23 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.05 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.09 ms
cleaning up	0.03 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:203
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: 25.30 ms Consulta a la memoria: 0.020 MB memoria antes de la consulta: 6.506 MB Filas devueltas: 1

SELECT count(*)

  FROM `jos_cwgears_schedule`

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	Select tables optimized away

Perfil

Status	Duration
starting	0.20 ms
checking permissions	0.03 ms
Opening tables	0.06 ms
init	0.02 ms
System lock	0.05 ms
optimizing	0.01 ms
executing	0.01 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.03 ms
freeing items	0.08 ms
cleaning up	0.02 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
9	JDatabaseDriver->loadResult()	JROOT/plugins/system/cwgears/cwgears.php:102
8	plgSystemCwgears->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:674
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
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.07 ms Consulta a la memoria: 0.020 MB memoria antes de la consulta: 6.511 MB Filas devueltas: 1

SELECT count(*)

  FROM `jos_cwgears_schedule`

  WHERE time + '86400'<'1675756072'

Explicar

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

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
9	JDatabaseDriver->loadResult()	JROOT/plugins/system/cwgears/cwgears.php:145
8	plgSystemCwgears->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:674
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
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: 17.68 ms Consulta a la memoria: 0.006 MB memoria antes de la consulta: 7.790 MB

UPDATE `jos_extensions`

  SET `params` = '{\"mediaversion\":\"09f536d9243679f58228e284b8a4dc60\"}'

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

Explicar

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

Perfil

Status	Duration
starting	0.23 ms
checking permissions	0.01 ms
Opening tables	0.06 ms
init	0.06 ms
System lock	0.23 ms
updating	0.21 ms
end	0.01 ms
Waiting for query cache lock	0.01 ms
end	0.02 ms
query end	0.99 ms
closing tables	0.03 ms
freeing items	0.11 ms
cleaning up	0.04 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/cwgears/cwgears.php:200
8	plgSystemCwgears->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:1196
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:203
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.62 ms Después de la última consulta: 13.52 ms Consulta a la memoria: 0.029 MB memoria antes de la consulta: 8.662 MB Filas devueltas: 39

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

  FROM `jos_assets`

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

Explicar

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

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
19	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
18	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
17	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
16	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
15	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/category.php:139
14	ContentModelCategory->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:440
13	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/libraries/src/MVC/View/CategoryView.php:116
12	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
11	ContentViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
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:203
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.25 ms Consulta a la memoria: 0.030 MB memoria antes de la consulta: 8.717 MB Filas devueltas: 61

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

  FROM `jos_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	jos_assets	NULL	ALL	idx_asset_name,idx_parent_id	No pudo usarse una clave de índice	NULL	NULL	252	22.67	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.12 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.24 ms
end	0.01 ms
query end	0.02 ms
closing tables	0.01 ms
freeing items	0.08 ms
cleaning up	0.04 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:359
19	Joomla\CMS\Access\Access::preloadPermissions()	JROOT/libraries/src/Access/Access.php:226
18	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:540
17	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
16	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
15	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/category.php:139
14	ContentModelCategory->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:440
13	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/libraries/src/MVC/View/CategoryView.php:116
12	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
11	ContentViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
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:203
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.38 ms Después de la última consulta: 2.71 ms Consulta a la memoria: 0.026 MB memoria antes de la consulta: 8.902 MB Filas devueltas: 3

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

  FROM `jos_content` AS `i`

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

  FROM `jos_categories` AS `s`

  INNER JOIN `jos_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 = 20

  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	24	35.42	Using where
2	DEPENDENT SUBQUERY	i	NULL	ref	idx_state,idx_catid	idx_catid	4	academ36_jos1.c.id	2	100.00	Using index condition; Using where

Perfil

Status	Duration
starting	0.36 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.17 ms
init	0.12 ms
System lock	0.04 ms
optimizing	0.02 ms
statistics	0.40 ms
preparing	0.03 ms
Sorting result	0.01 ms
optimizing	0.02 ms
statistics	0.09 ms
preparing	0.05 ms
executing	0.01 ms
Sending data	0.03 ms
Creating sort index	0.22 ms
executing	0.01 ms
Sending data	0.07 ms
executing	0.01 ms
Sending data	0.02 ms
executing	0.01 ms
Sending data	0.22 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.03 ms
freeing items	0.21 ms
cleaning up	0.07 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/Categories/Categories.php:324
16	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
15	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/models/category.php:355
14	ContentModelCategory->getCategory()	JROOT/libraries/src/MVC/View/HtmlView.php:425
13	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/src/MVC/View/CategoryView.php:122
12	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
11	ContentViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
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:203
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.77 ms Después de la última consulta: 2.91 ms Consulta a la memoria: 0.028 MB memoria antes de la consulta: 9.068 MB Filas devueltas: 3

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

  FROM jos_content AS a

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

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

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

  LEFT JOIN jos_categories as parent 
  ON parent.id = c.parent_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 = 20 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-02-07 07:47:52') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-02-07 07:47:52')

  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   
  LIMIT 9

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	3	16.00	Using index condition; Using where
1	SIMPLE	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	academ36_jos1.a.created_by	1	100.00	Using where
1	SIMPLE	uam	NULL	eq_ref	PRIMARY	PRIMARY	4	academ36_jos1.a.modified_by	1	100.00	Using where
1	SIMPLE	parent	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	Using where

Perfil

Status	Duration
starting	0.34 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
Opening tables	0.09 ms
init	0.11 ms
System lock	0.07 ms
optimizing	0.05 ms
statistics	0.23 ms
preparing	0.06 ms
Sorting result	0.03 ms
executing	0.01 ms
Sending data	0.04 ms
Creating sort index	0.37 ms
end	0.02 ms
query end	0.01 ms
closing tables	0.03 ms
freeing items	0.12 ms
cleaning up	0.03 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/MVC/Model/BaseDatabaseModel.php:308
17	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
16	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_content/models/articles.php:576
15	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
14	ContentModelCategory->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
13	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/src/MVC/View/CategoryView.php:144
12	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
11	ContentViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
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:203
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.90 ms Después de la última consulta: 1.86 ms Consulta a la memoria: 0.025 MB memoria antes de la consulta: 9.213 MB Filas devueltas: 1

SELECT COUNT(*)

  FROM jos_content AS a

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

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

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

  LEFT JOIN jos_categories as parent 
  ON parent.id = c.parent_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 = 20 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-02-07 07:47:52') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-02-07 07:47:52')

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	3	16.00	Using where
1	SIMPLE	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	academ36_jos1.a.created_by	1	100.00	Using where; Using index
1	SIMPLE	uam	NULL	eq_ref	PRIMARY	PRIMARY	4	academ36_jos1.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

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
18	JDatabaseDriver->loadResult()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:340
17	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount()	JROOT/libraries/src/MVC/Model/ListModel.php:282
16	Joomla\CMS\MVC\Model\ListModel->getTotal()	JROOT/libraries/src/MVC/Model/ListModel.php:232
15	Joomla\CMS\MVC\Model\ListModel->getPagination()	JROOT/components/com_content/models/category.php:265
14	ContentModelCategory->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
13	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/src/MVC/View/CategoryView.php:144
12	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
11	ContentViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
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:203
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.03 ms Después de la última consulta: 2.05 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 9.351 MB Filas devueltas: 0

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

  FROM `jos_contentitem_tag_map` AS m 

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

  WHERE `m`.`type_alias` = 'com_content.category' 
  AND `m`.`content_item_id` = 20 
  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	No pudo usarse una clave de índice	NULL	NULL	1	100.00	Using where
1	SIMPLE	t	NULL	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	academ36_jos1.m.tag_id	1	100.00	Using where

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
13	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/libraries/src/MVC/View/CategoryView.php:229
12	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
11	ContentViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
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:203
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: 10.53 ms Consulta a la memoria: 0.027 MB memoria antes de la consulta: 10.069 MB Filas devueltas: 3

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

  FROM `jos_categories` AS `s`

  INNER JOIN `jos_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 = 20

  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	24	39.58	Using where

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
21	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
20	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
19	Joomla\CMS\Categories\Categories->get()	JROOT/administrator/components/com_fields/models/fields.php:203
18	FieldsModelFields->getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:133
17	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:187
16	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
15	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
14	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:113
11	ContentViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
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:203
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.72 ms Después de la última consulta: 0.24 ms Consulta a la memoria: 0.025 MB memoria antes de la consulta: 10.091 MB Filas devueltas: 0

SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note

  FROM jos_fields AS a

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

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

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

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

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

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

  WHERE a.context = 'com_content.article' 
  AND (fc.category_id IS NULL OR fc.category_id IN (20,0,10)) 
  AND a.access IN (1,1,5) 
  AND (a.group_id = 0 OR g.access IN (1,1,5)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ref	idx_state,idx_access,idx_context	idx_context	766	const	1	100.00	Using where; Using temporary; Usando 'filesort'
1	SIMPLE	l	NULL	eq_ref	idx_langcode	idx_langcode	28	academ36_jos1.a.language	1	100.00	Using where
1	SIMPLE	uc	NULL	eq_ref	PRIMARY	PRIMARY	4	academ36_jos1.a.checked_out	1	100.00	NULL
1	SIMPLE	ag	NULL	eq_ref	PRIMARY	PRIMARY	4	academ36_jos1.a.access	1	100.00	Using where
1	SIMPLE	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	academ36_jos1.a.created_user_id	1	100.00	Using where
1	SIMPLE	g	NULL	eq_ref	PRIMARY	PRIMARY	4	academ36_jos1.a.group_id	1	100.00	Using where
1	SIMPLE	fc	NULL	ref	PRIMARY	PRIMARY	4	academ36_jos1.a.id	1	100.00	Using where; Using index; Distinct

Perfil

Status	Duration
starting	0.20 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.02 ms
Opening tables	0.18 ms
init	0.07 ms
System lock	0.05 ms
optimizing	0.03 ms
statistics	0.25 ms
preparing	0.05 ms
Creating tmp table	0.12 ms
Sorting result	0.02 ms
executing	0.01 ms
Sending data	0.32 ms
Creating sort index	0.05 ms
end	0.02 ms
query end	0.01 ms
removing tmp table	0.07 ms
query end	0.01 ms
closing tables	0.03 ms
freeing items	0.10 ms
cleaning up	0.02 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/MVC/Model/BaseDatabaseModel.php:308
18	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
17	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
16	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
15	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
14	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:113
11	ContentViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
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:203
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.74 ms Después de la última consulta: 4.98 ms Consulta a la memoria: 0.028 MB memoria antes de la consulta: 10.415 MB Filas devueltas: 1

SELECT `alias`

  FROM `jos_content`

  WHERE id = '40'

Explicar

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

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
28	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
27	JDatabaseDriver->loadResult()	JROOT/components/com_content/router.php:125
26	ContentRouter->getArticleSegment()	Lo mismo que llamada de la línea de abajo.
25	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
24	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
23	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
22	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:676
21	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
20	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
19	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
18	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
17	Joomla\CMS\Router\Route::_()	JROOT/plugins/content/addtoany/addtoany.php:315
16	plgContentAddToAny->getArticleUrl()	JROOT/plugins/content/addtoany/addtoany.php:108
15	plgContentAddToAny->createAddToAny()	JROOT/plugins/content/addtoany/addtoany.php:51
14	plgContentAddToAny->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:113
11	ContentViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
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:203
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: 0.79 ms Consulta a la memoria: 0.028 MB memoria antes de la consulta: 10.432 MB Filas devueltas: 1

SELECT `alias`

  FROM `jos_content`

  WHERE id = '12'

Explicar

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

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
28	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
27	JDatabaseDriver->loadResult()	JROOT/components/com_content/router.php:125
26	ContentRouter->getArticleSegment()	Lo mismo que llamada de la línea de abajo.
25	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
24	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
23	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
22	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:676
21	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
20	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
19	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
18	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
17	Joomla\CMS\Router\Route::_()	JROOT/plugins/content/addtoany/addtoany.php:315
16	plgContentAddToAny->getArticleUrl()	JROOT/plugins/content/addtoany/addtoany.php:108
15	plgContentAddToAny->createAddToAny()	JROOT/plugins/content/addtoany/addtoany.php:51
14	plgContentAddToAny->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:113
11	ContentViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
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:203
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.46 ms Después de la última consulta: 0.12 ms Consulta a la memoria: 0.027 MB memoria antes de la consulta: 10.443 MB Filas devueltas: 1

SELECT alias

  FROM jos_content

  WHERE id=12

Explicar

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

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
25	JDatabaseDriver->loadResult()	JROOT/components/com_content/helpers/legacyrouter.php:140
24	ContentRouterRulesLegacy->build()	JROOT/libraries/src/Component/Router/RouterView.php:244
23	Joomla\CMS\Component\Router\RouterView->build()	JROOT/libraries/src/Router/SiteRouter.php:532
22	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
21	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
20	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
19	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
18	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
17	Joomla\CMS\Router\Route::_()	JROOT/plugins/content/addtoany/addtoany.php:315
16	plgContentAddToAny->getArticleUrl()	JROOT/plugins/content/addtoany/addtoany.php:108
15	plgContentAddToAny->createAddToAny()	JROOT/plugins/content/addtoany/addtoany.php:51
14	plgContentAddToAny->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:113
11	ContentViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
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:203
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.48 ms Después de la última consulta: 0.45 ms Consulta a la memoria: 0.028 MB memoria antes de la consulta: 10.458 MB Filas devueltas: 1

SELECT `alias`

  FROM `jos_content`

  WHERE id = '11'

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jos_content	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.02 ms
System lock	0.03 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.08 ms
cleaning up	0.02 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
28	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
27	JDatabaseDriver->loadResult()	JROOT/components/com_content/router.php:125
26	ContentRouter->getArticleSegment()	Lo mismo que llamada de la línea de abajo.
25	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
24	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
23	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
22	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:676
21	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
20	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
19	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
18	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
17	Joomla\CMS\Router\Route::_()	JROOT/plugins/content/addtoany/addtoany.php:315
16	plgContentAddToAny->getArticleUrl()	JROOT/plugins/content/addtoany/addtoany.php:108
15	plgContentAddToAny->createAddToAny()	JROOT/plugins/content/addtoany/addtoany.php:51
14	plgContentAddToAny->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:113
11	ContentViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
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:203
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.52 ms Después de la última consulta: 0.11 ms Consulta a la memoria: 0.027 MB memoria antes de la consulta: 10.469 MB Filas devueltas: 1

SELECT alias

  FROM jos_content

  WHERE id=11

Explicar

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

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
25	JDatabaseDriver->loadResult()	JROOT/components/com_content/helpers/legacyrouter.php:140
24	ContentRouterRulesLegacy->build()	JROOT/libraries/src/Component/Router/RouterView.php:244
23	Joomla\CMS\Component\Router\RouterView->build()	JROOT/libraries/src/Router/SiteRouter.php:532
22	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
21	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
20	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
19	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
18	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
17	Joomla\CMS\Router\Route::_()	JROOT/plugins/content/addtoany/addtoany.php:315
16	plgContentAddToAny->getArticleUrl()	JROOT/plugins/content/addtoany/addtoany.php:108
15	plgContentAddToAny->createAddToAny()	JROOT/plugins/content/addtoany/addtoany.php:51
14	plgContentAddToAny->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:113
11	ContentViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
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:203
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.84 ms Después de la última consulta: 9.88 ms Consulta a la memoria: 0.027 MB memoria antes de la consulta: 11.061 MB Filas devueltas: 0

SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note

  FROM jos_fields AS a

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

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

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

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

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

  WHERE a.context = 'com_content.categories' 
  AND a.access IN (1,1,5) 
  AND (a.group_id = 0 OR g.access IN (1,1,5)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ref	idx_state,idx_access,idx_context	idx_context	766	const	1	100.00	Using where; Using temporary; Usando 'filesort'
1	SIMPLE	l	NULL	eq_ref	idx_langcode	idx_langcode	28	academ36_jos1.a.language	1	100.00	Using where
1	SIMPLE	uc	NULL	eq_ref	PRIMARY	PRIMARY	4	academ36_jos1.a.checked_out	1	100.00	NULL
1	SIMPLE	ag	NULL	eq_ref	PRIMARY	PRIMARY	4	academ36_jos1.a.access	1	100.00	Using where
1	SIMPLE	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	academ36_jos1.a.created_user_id	1	100.00	Using where
1	SIMPLE	g	NULL	eq_ref	PRIMARY	PRIMARY	4	academ36_jos1.a.group_id	1	100.00	Using where

Perfil

Status	Duration
starting	0.36 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.03 ms
checking permissions	0.01 ms
checking permissions	0.05 ms
Opening tables	0.08 ms
init	0.10 ms
System lock	0.02 ms
optimizing	0.03 ms
statistics	0.20 ms
preparing	0.04 ms
Creating tmp table	0.07 ms
Sorting result	0.02 ms
executing	0.01 ms
Sending data	0.28 ms
Creating sort index	0.06 ms
end	0.02 ms
query end	0.02 ms
removing tmp table	0.06 ms
query end	0.02 ms
closing tables	0.03 ms
freeing items	0.15 ms
cleaning up	0.04 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
23	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
22	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
21	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
20	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
19	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
18	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
17	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
16	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/tmpl/blog.php:19
15	include JROOT/components/com_content/views/category/tmpl/blog.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/libraries/src/MVC/View/CategoryView.php:245
12	Joomla\CMS\MVC\View\CategoryView->display()	JROOT/components/com_content/views/category/view.html.php:250
11	ContentViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
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:203
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: 0.49 ms Consulta a la memoria: 0.027 MB memoria antes de la consulta: 11.075 MB Filas devueltas: 0

SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note

  FROM jos_fields AS a

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

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

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

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

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

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

  WHERE a.context = 'com_content.categories' 
  AND (fc.category_id IS NULL OR fc.category_id IN (20,0,10)) 
  AND a.access IN (1,1,5) 
  AND (a.group_id = 0 OR g.access IN (1,1,5)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ref	idx_state,idx_access,idx_context	idx_context	766	const	1	100.00	Using where; Using temporary; Usando 'filesort'
1	SIMPLE	l	NULL	eq_ref	idx_langcode	idx_langcode	28	academ36_jos1.a.language	1	100.00	Using where
1	SIMPLE	uc	NULL	eq_ref	PRIMARY	PRIMARY	4	academ36_jos1.a.checked_out	1	100.00	NULL
1	SIMPLE	ag	NULL	eq_ref	PRIMARY	PRIMARY	4	academ36_jos1.a.access	1	100.00	Using where
1	SIMPLE	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	academ36_jos1.a.created_user_id	1	100.00	Using where
1	SIMPLE	g	NULL	eq_ref	PRIMARY	PRIMARY	4	academ36_jos1.a.group_id	1	100.00	Using where
1	SIMPLE	fc	NULL	ref	PRIMARY	PRIMARY	4	academ36_jos1.a.id	1	100.00	Using where; Using index; Distinct

Perfil

Status	Duration
starting	0.28 ms
checking permissions	0.03 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.02 ms
Opening tables	0.06 ms
init	0.09 ms
System lock	0.02 ms
optimizing	0.04 ms
statistics	0.18 ms
preparing	0.06 ms
Creating tmp table	0.07 ms
Sorting result	0.02 ms
executing	0.01 ms
Sending data	0.22 ms
Creating sort index	0.06 ms
end	0.02 ms
query end	0.02 ms
removing tmp table	0.06 ms
query end	0.03 ms
closing tables	0.02 ms
freeing items	0.09 ms
cleaning up	0.02 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
24	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
23	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
22	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
21	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
20	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:404
19	PlgSystemFields->display()	JROOT/plugins/system/fields/fields.php:324
18	PlgSystemFields->onContentAfterTitle()	JROOT/libraries/joomla/event/event.php:70
17	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
16	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/tmpl/blog.php:22
15	include JROOT/components/com_content/views/category/tmpl/blog.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/libraries/src/MVC/View/CategoryView.php:245
12	Joomla\CMS\MVC\View\CategoryView->display()	JROOT/components/com_content/views/category/view.html.php:250
11	ContentViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
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:203
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.66 ms Después de la última consulta: 14.78 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 11.404 MB Filas devueltas: 6

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

  FROM jos_modules AS m

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

  LEFT JOIN jos_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-02-07 07:47:52') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-02-07 07:47:52') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 187 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	16	2.44	Using index condition; Using where; Usando 'filesort'
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid	element_clientid	403	academ36_jos1.m.module,const	1	10.00	Using index condition; Using where
1	SIMPLE	mm	NULL	ref	PRIMARY	PRIMARY	4	academ36_jos1.m.id	3	40.00	Using where; Using index

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	Lo mismo que llamada de la línea de abajo.
13	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
12	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:441
11	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:371
10	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
9	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:591
8	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/templates/protostar/index.php:100
7	require JROOT/templates/protostar/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1104
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:209
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.92 ms Después de la última consulta: 424.33 ms Consulta a la memoria: 0.028 MB memoria antes de la consulta: 15.317 MB Filas devueltas: 1

SELECT `params`
 
  FROM `jos_comprofiler_plugin`
 
  WHERE `id` = 1

Explicar

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

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
28	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
27	JDatabaseDriver->loadResult()	JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:353
26	CBLib\Database\Driver\CmsDatabaseDriver->loadResult()	JROOT/libraries/CBLib/CB/Application/CBConfig.php:43
25	CB\Application\CBConfig::getConfig()	JROOT/libraries/CBLib/CB/Application/CBApplication.php:47
24	CB\Application\CBApplication::CB\Application\{closure}()	Lo mismo que llamada de la línea de abajo.
23	call_user_func_array()	JROOT/libraries/CBLib/CBLib/Application/Config.php:38
22	CBLib\Application\Config::setMainConfig()	JROOT/libraries/CBLib/CBLib/Core/CBLib.php:78
21	CBLib\Core\CBLib::CBLib\Core\{closure}()	JROOT/libraries/CBLib/CBLib/DependencyInjection/Container.php:607
20	CBLib\DependencyInjection\Container->build()	JROOT/libraries/CBLib/CBLib/DependencyInjection/Container.php:498
19	CBLib\DependencyInjection\Container->make()	JROOT/libraries/CBLib/CBLib/Application/Application.php:212
18	CBLib\Application\Application::__callStatic()	JROOT/libraries/CBLib/CB/Application/CBConfig.php:77
17	CB\Application\CBConfig::loadLegacyCBueConfig()	JROOT/libraries/CBLib/CB/Legacy/LegacyFoundationFunctions.php:102
16	CB\Legacy\LegacyFoundationFunctions->__construct()	Lo mismo que llamada de la línea de abajo.
15	ReflectionClass->newInstanceArgs()	JROOT/libraries/CBLib/CBLib/DependencyInjection/Container.php:645
14	CBLib\DependencyInjection\Container->build()	JROOT/libraries/CBLib/CBLib/DependencyInjection/Container.php:498
13	CBLib\DependencyInjection\Container->make()	JROOT/libraries/CBLib/CBLib/DependencyInjection/Container.php:134
12	CBLib\DependencyInjection\Container->get()	JROOT/administrator/components/com_comprofiler/plugin.foundation.php:34
11	include_once JROOT/administrator/components/com_comprofiler/plugin.foundation.php	JROOT/modules/mod_cblogin/mod_cblogin.php:22
10	include JROOT/modules/mod_cblogin/mod_cblogin.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:489
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1118
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:209
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.30 ms Después de la última consulta: 17.57 ms Consulta a la memoria: 0.029 MB memoria antes de la consulta: 16.911 MB Filas devueltas: 16

SHOW FULL COLUMNS 
  FROM `jos_users`

Explicar

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

Perfil

Status	Duration
starting	0.22 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.26 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.01 ms
Opening tables	0.04 ms
checking permissions	0.05 ms
checking permissions	0.02 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.02 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.02 ms
Sending data	0.07 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
removing tmp table	0.04 ms
closing tables	0.01 ms
freeing items	0.09 ms
cleaning up	0.03 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
21	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
20	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
19	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/User.php:41
18	Joomla\CMS\Table\User->__construct()	JROOT/libraries/src/Table/Table.php:312
17	Joomla\CMS\Table\Table::getInstance()	JROOT/libraries/src/User/User.php:603
16	Joomla\CMS\User\User::getTable()	JROOT/libraries/CBLib/CB/Database/Table/UserTable.php:181
15	CB\Database\Table\UserTable->_reinitNonComprofileVars()	JROOT/libraries/CBLib/CB/Database/Table/UserTable.php:121
14	CB\Database\Table\UserTable->__construct()	JROOT/libraries/CBLib/CB/Legacy/CBuser.php:194
13	CBuser::_getOrSetInstance()	JROOT/libraries/CBLib/CB/Legacy/CBuser.php:84
12	CBuser::getInstance()	JROOT/libraries/CBLib/CB/Legacy/CBuser.php:68
11	CBuser::getMyInstance()	JROOT/modules/mod_cblogin/mod_cblogin.php:68
10	include JROOT/modules/mod_cblogin/mod_cblogin.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:489
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1118
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:209
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.96 ms Después de la última consulta: 3.68 ms Consulta a la memoria: 0.053 MB memoria antes de la consulta: 17.184 MB Filas devueltas: 28

SELECT f.* 
  FROM jos_comprofiler_fields f
 
  INNER JOIN jos_comprofiler_tabs AS t 
  ON (f.tabid = t.tabid)
 
  WHERE f.published = 1
 
  ORDER BY t.position, t.ordering, f.ordering

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	f	NULL	ref	tabid_pub_prof_order,published_ordering	published_ordering	1	const	28	100.00	Using where; Using temporary; Usando 'filesort'
1	SIMPLE	t	NULL	eq_ref	PRIMARY	PRIMARY	4	academ36_jos1.f.tabid	1	100.00	NULL

Perfil

Status	Duration
starting	0.17 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.09 ms
init	0.08 ms
System lock	0.03 ms
optimizing	0.02 ms
statistics	0.15 ms
preparing	0.03 ms
Creating tmp table	0.06 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.60 ms
Creating sort index	0.37 ms
end	0.02 ms
query end	0.01 ms
removing tmp table	0.05 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.10 ms
cleaning up	0.03 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
19	JDatabaseDriver->loadAssocList()	JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:402
18	CBLib\Database\Driver\CmsDatabaseDriver->loadAssocList()	JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:454
17	CBLib\Database\Driver\CmsDatabaseDriver->loadObjectList()	JROOT/libraries/CBLib/CB/Legacy/cbTabs.php:1037
16	cbTabs->_getTabFieldsDb()	JROOT/libraries/CBLib/CB/Legacy/CBuser.php:332
15	CBuser->getField()	JROOT/libraries/CBLib/CB/Legacy/CBuser.php:1121
14	CBuser->{closure}()	Lo mismo que llamada de la línea de abajo.
13	preg_replace_callback()	JROOT/libraries/CBLib/CB/Legacy/CBuser.php:1172
12	CBuser->evaluateFields()	JROOT/libraries/CBLib/CB/Legacy/CBuser.php:648
11	CBuser->replaceUserVars()	JROOT/modules/mod_cblogin/mod_cblogin.php:134
10	include JROOT/modules/mod_cblogin/mod_cblogin.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:489
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1118
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:209
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.92 ms Después de la última consulta: 0.57 ms Consulta a la memoria: 0.027 MB memoria antes de la consulta: 17.284 MB Filas devueltas: 6

SELECT *, CONCAT_WS( "/", `folder`, `element` ) AS lookup
 
  FROM `jos_comprofiler_plugin`
 
  WHERE `published` = 1
 
  AND `viewaccesslevel` IN (1,5)
 
  AND `type` = 'user'
 
  ORDER BY `ordering`

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jos_comprofiler_plugin	NULL	ALL	idx_folder,type_pub_order,published_ordering	No pudo usarse una clave de índice	NULL	NULL	10	10.00	Using where; Usando 'filesort'

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
20	JDatabaseDriver->loadAssocList()	JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:402
19	CBLib\Database\Driver\CmsDatabaseDriver->loadAssocList()	JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:454
18	CBLib\Database\Driver\CmsDatabaseDriver->loadObjectList()	JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:181
17	cbPluginHandler->loadPluginGroup()	JROOT/libraries/CBLib/CB/Legacy/cbTabs.php:1083
16	cbTabs->_getTabFieldsDb()	JROOT/libraries/CBLib/CB/Legacy/CBuser.php:332
15	CBuser->getField()	JROOT/libraries/CBLib/CB/Legacy/CBuser.php:1121
14	CBuser->{closure}()	Lo mismo que llamada de la línea de abajo.
13	preg_replace_callback()	JROOT/libraries/CBLib/CB/Legacy/CBuser.php:1172
12	CBuser->evaluateFields()	JROOT/libraries/CBLib/CB/Legacy/CBuser.php:648
11	CBuser->replaceUserVars()	JROOT/modules/mod_cblogin/mod_cblogin.php:134
10	include JROOT/modules/mod_cblogin/mod_cblogin.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:489
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1118
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:209
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.04 ms Después de la última consulta: 32.98 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 20.027 MB Filas devueltas: 1

SELECT `id`
 
  FROM `jos_menu`
 
  WHERE ( `link` = 'index.php?option=com_comprofiler&view=userprofile' OR `link` = 'index.php?option=com_comprofiler&task=userprofile' OR `link` = 'index.php?option=com_comprofiler' )
 
  AND `published` = 1
 
  AND `access` IN ( 1,5 )
 
  AND `language` IN ( 'es-ES', '*', '' )
 
  AND `client_id` = 0

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jos_menu	NULL	ref	idx_client_id_parent_id_alias_language,idx_language	idx_client_id_parent_id_alias_language	1	const	81	0.69	Using index condition; Using where

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:353
14	CBLib\Database\Driver\CmsDatabaseDriver->loadResult()	JROOT/libraries/CBLib/CB/Legacy/LegacyFoundationFunctions.php:235
13	getCBprofileItemid()	JROOT/libraries/CBLib/CB/Legacy/CBframework.php:993
12	CBframework->viewUrl()	JROOT/libraries/CBLib/CB/Legacy/CBframework.php:852
11	CBframework->userProfileUrl()	JROOT/modules/mod_cblogin/mod_cblogin.php:208
10	include JROOT/modules/mod_cblogin/mod_cblogin.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:489
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1118
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:209
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.32 ms Después de la última consulta: 7.87 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 20.499 MB Filas devueltas: 1

SELECT `id`
 
  FROM `jos_menu`
 
  WHERE ( `link` LIKE 'index.php?option=com_comprofiler&view=login%' OR `link` LIKE 'index.php?option=com_comprofiler&task=login%' )
 
  AND `published` = 1
 
  AND `access` IN ( 1,5 )
 
  AND `language` IN ( 'es-ES', '*', '' )
 
  AND `client_id` = 0

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jos_menu	NULL	ref	idx_client_id_parent_id_alias_language,idx_language	idx_client_id_parent_id_alias_language	1	const	81	0.69	Using index condition; Using where

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:353
14	CBLib\Database\Driver\CmsDatabaseDriver->loadResult()	JROOT/libraries/CBLib/CB/Legacy/LegacyFoundationFunctions.php:215
13	getCBprofileItemid()	JROOT/libraries/CBLib/CB/Legacy/CBframework.php:993
12	CBframework->viewUrl()	JROOT/modules/mod_cblogin/tmpl/default.php:15
11	require JROOT/modules/mod_cblogin/tmpl/default.php	JROOT/modules/mod_cblogin/mod_cblogin.php:233
10	include JROOT/modules/mod_cblogin/mod_cblogin.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:489
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1118
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:209
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.02 ms Después de la última consulta: 1.51 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 20.603 MB Filas devueltas: 1

SELECT `id`
 
  FROM `jos_menu`
 
  WHERE ( `link` LIKE 'index.php?option=com_comprofiler&view=lostpassword%' OR `link` LIKE 'index.php?option=com_comprofiler&task=lostpassword%' )
 
  AND `published` = 1
 
  AND `access` IN ( 1,5 )
 
  AND `language` IN ( 'es-ES', '*', '' )
 
  AND `client_id` = 0

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jos_menu	NULL	ref	idx_client_id_parent_id_alias_language,idx_language	idx_client_id_parent_id_alias_language	1	const	81	0.69	Using index condition; Using where

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:353
14	CBLib\Database\Driver\CmsDatabaseDriver->loadResult()	JROOT/libraries/CBLib/CB/Legacy/LegacyFoundationFunctions.php:215
13	getCBprofileItemid()	JROOT/libraries/CBLib/CB/Legacy/CBframework.php:993
12	CBframework->viewUrl()	JROOT/modules/mod_cblogin/tmpl/default.php:126
11	require JROOT/modules/mod_cblogin/tmpl/default.php	JROOT/modules/mod_cblogin/mod_cblogin.php:233
10	include JROOT/modules/mod_cblogin/mod_cblogin.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:489
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1118
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:209
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.24 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 20.612 MB Filas devueltas: 2

SELECT `id`
 
  FROM `jos_menu`
 
  WHERE ( `link` LIKE 'index.php?option=com_comprofiler&view=registers%' OR `link` LIKE 'index.php?option=com_comprofiler&task=registers%' )
 
  AND `published` = 1
 
  AND `access` IN ( 1,5 )
 
  AND `language` IN ( 'es-ES', '*', '' )
 
  AND `client_id` = 0

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jos_menu	NULL	ref	idx_client_id_parent_id_alias_language,idx_language	idx_client_id_parent_id_alias_language	1	const	81	0.69	Using index condition; Using where

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:353
14	CBLib\Database\Driver\CmsDatabaseDriver->loadResult()	JROOT/libraries/CBLib/CB/Legacy/LegacyFoundationFunctions.php:215
13	getCBprofileItemid()	JROOT/libraries/CBLib/CB/Legacy/CBframework.php:993
12	CBframework->viewUrl()	JROOT/modules/mod_cblogin/tmpl/default.php:140
11	require JROOT/modules/mod_cblogin/tmpl/default.php	JROOT/modules/mod_cblogin/mod_cblogin.php:233
10	include JROOT/modules/mod_cblogin/mod_cblogin.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:489
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1118
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:209
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: 3.15 ms Después de la última consulta: 858.04 ms Consulta a la memoria: 0.659 MB memoria antes de la consulta: 20.758 MB Filas devueltas: 3

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

  FROM jos_content AS a

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

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

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

  LEFT JOIN jos_categories as parent 
  ON parent.id = c.parent_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.featured = 1 
  AND a.catid IN (8,26) 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-02-07 07:47:52') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-02-07 07:47:52')

  ORDER BY a.created DESC 
  LIMIT 6

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	range	idx_access,idx_state,idx_catid,idx_featured_catid	idx_featured_catid	5	NULL	3	16.00	Using index condition; Using where; Usando 'filesort'
1	SIMPLE	c	NULL	eq_ref	PRIMARY,idx_access	PRIMARY	4	academ36_jos1.a.catid	1	10.00	Using where
1	SIMPLE	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	academ36_jos1.a.created_by	1	100.00	Using where
1	SIMPLE	uam	NULL	eq_ref	PRIMARY	PRIMARY	4	academ36_jos1.a.modified_by	1	100.00	Using where
1	SIMPLE	parent	NULL	eq_ref	PRIMARY	PRIMARY	4	academ36_jos1.c.parent_id	1	100.00	Using where

Perfil

Status	Duration
starting	0.43 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
Opening tables	0.05 ms
init	0.13 ms
System lock	0.02 ms
optimizing	0.03 ms
statistics	0.22 ms
preparing	0.05 ms
Sorting result	0.02 ms
executing	0.01 ms
Sending data	0.03 ms
Creating sort index	1.86 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.03 ms
freeing items	0.10 ms
cleaning up	0.04 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
14	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
13	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_content/models/articles.php:576
12	ContentModelArticles->getItems()	JROOT/modules/mod_klixo_articles_slider/helper.php:57
11	modKlixoArticlesSliderHelper::getContentList()	JROOT/modules/mod_klixo_articles_slider/mod_klixo_articles_slider.php:100
10	include JROOT/modules/mod_klixo_articles_slider/mod_klixo_articles_slider.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:489
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1118
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:209
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.95 ms Después de la última consulta: 0.63 ms Consulta a la memoria: 0.028 MB memoria antes de la consulta: 21.131 MB Filas devueltas: 2

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

  FROM `jos_categories` AS `s`

  INNER JOIN `jos_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 = 8

  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	24	23.09	Using where

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
24	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
23	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
22	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
21	ContentRouter->getCategorySegment()	Lo mismo que llamada de la línea de abajo.
20	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
19	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
18	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
17	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:676
16	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
15	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
14	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
13	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
12	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_klixo_articles_slider/helper.php:66
11	modKlixoArticlesSliderHelper::getContentList()	JROOT/modules/mod_klixo_articles_slider/mod_klixo_articles_slider.php:100
10	include JROOT/modules/mod_klixo_articles_slider/mod_klixo_articles_slider.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:489
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1118
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:209
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.87 ms Después de la última consulta: 0.32 ms Consulta a la memoria: 0.028 MB memoria antes de la consulta: 21.148 MB Filas devueltas: 3

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

  FROM `jos_categories` AS `s`

  INNER JOIN `jos_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	24	49.48	Using where

Perfil

Status	Duration
starting	0.17 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.06 ms
System lock	0.02 ms
optimizing	0.03 ms
statistics	0.13 ms
preparing	0.03 ms
Sorting result	0.01 ms
executing	0.01 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.02 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
24	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
23	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
22	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
21	ContentRouter->getCategorySegment()	Lo mismo que llamada de la línea de abajo.
20	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
19	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
18	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
17	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:676
16	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
15	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
14	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
13	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
12	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_klixo_articles_slider/helper.php:66
11	modKlixoArticlesSliderHelper::getContentList()	JROOT/modules/mod_klixo_articles_slider/mod_klixo_articles_slider.php:100
10	include JROOT/modules/mod_klixo_articles_slider/mod_klixo_articles_slider.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:489
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1118
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:209
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.77 ms Después de la última consulta: 1315.30 ms Consulta a la memoria: 0.022 MB memoria antes de la consulta: 19.931 MB Filas devueltas: 0

SELECT uikit

  FROM `jos_cwgears`

  WHERE url = 'https://academiadelrol.org.mx/index.php/coloquio/2018'

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.21 ms
checking permissions	0.02 ms
Opening tables	0.07 ms
init	0.04 ms
System lock	0.03 ms
optimizing	0.02 ms
statistics	0.02 ms
executing	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.09 ms
cleaning up	0.05 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
14	JDatabaseDriver->loadResult()	JROOT/plugins/system/cwgears/helpers/loadcount.php:64
13	CwGearsHelperLoadcount::getCounts()	JROOT/plugins/system/cwgears/cwgears.php:337
12	plgSystemCwgears->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1118
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:209
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.24 ms Consulta a la memoria: 0.022 MB memoria antes de la consulta: 19.938 MB Filas devueltas: 0

SELECT uikit_plus

  FROM `jos_cwgears`

  WHERE url = 'https://academiadelrol.org.mx/index.php/coloquio/2018'

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.10 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.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.08 ms
cleaning up	0.02 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
14	JDatabaseDriver->loadResult()	JROOT/plugins/system/cwgears/helpers/loadcount.php:64
13	CwGearsHelperLoadcount::getCounts()	JROOT/plugins/system/cwgears/cwgears.php:346
12	plgSystemCwgears->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1118
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:209
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.]

26 tipo de consultas registradas, ordenadas por la ocurrencia

Tablas SELECCIONADAS:

```
4 × SELECT `id`  
  FROM `jos_menu`
```

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

3 × SELECT `alias` 
  FROM `jos_content`

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

2 × 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 
  FROM jos_content AS a 
  LEFT JOIN jos_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN jos_users AS ua 
  ON ua.id = a.created_by 
  LEFT JOIN jos_users AS uam 
  ON uam.id = a.modified_by 
  LEFT JOIN jos_categories as parent 
  ON parent.id = c.parent_id

```
2 × SELECT alias 
  FROM jos_content
```

2 × SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note 
  FROM jos_fields AS a 
  LEFT JOIN `jos_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN jos_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN jos_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN jos_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN jos_fields_groups AS g 
  ON g.id = a.group_id 
  LEFT JOIN `jos_fields_categories` AS fc 
  ON fc.field_id = a.id

1 × SELECT uikit 
  FROM `jos_cwgears`

1 × SELECT *, CONCAT_WS( "/", `folder`, `element` ) AS lookup  
  FROM `jos_comprofiler_plugin`

1 × SELECT f.* 
  FROM jos_comprofiler_fields f  
  INNER JOIN jos_comprofiler_tabs AS t 
  ON (f.tabid = t.tabid)

1 × SELECT `params`  
  FROM `jos_comprofiler_plugin`

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

1 × SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note 
  FROM jos_fields AS a 
  LEFT JOIN `jos_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN jos_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN jos_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN jos_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN jos_fields_groups AS g 
  ON g.id = a.group_id

1 × SELECT `data` 
  FROM `jos_session`

1 × SELECT `session_id` 
  FROM `jos_session`

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

1 × SELECT COUNT(*) 
  FROM jos_content AS a 
  LEFT JOIN jos_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN jos_users AS ua 
  ON ua.id = a.created_by 
  LEFT JOIN jos_users AS uam 
  ON uam.id = a.modified_by 
  LEFT JOIN jos_categories as parent 
  ON parent.id = c.parent_id

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 `jos_content` AS `i`

1 × SELECT count(*) 
  FROM `jos_cwgears_schedule`

1 × SELECT count(*) 
  FROM `jos_cwgears_schedule

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

1 × SELECT id, rules 
  FROM `jos_viewlevels

1 × SELECT uikit_plus 
  FROM `jos_cwgears`

OTRAS tablas:

1 × INSERT INTO `jos_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  (X'3865373931663566363063653137376134306538353732396134666634316361', 1, 1675756072, 0, '', 0

1 × UPDATE `jos_extensions` 
  SET `params` = '{\"mediaversion\":\"09f536d9243679f58228e284b8a4dc60\"}'

1 × SHOW FULL COLUMNS 
  FROM `jos_users

Journal of Roleplaying [...]

Convocatoria 2022

Lanzando los dados

Memorias del 3er. Coloquio de Estudios sobre Juegos de Rol

Programa 2018

Convocatoria 2018

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

37 consultas registradas 45.01 ms

26 tipo de consultas registradas, ordenadas por la ocurrencia

Tablas SELECCIONADAS:

OTRAS tablas: