Control interno de gestión

Informe Pormenorizado Febrero de 2015 Open or Close

La E.S.E Red de Servicios de Salud de Primer Nivel en cumplimiento de la ley 1474 de 2011, publica el informe Pormenorizado del Sistema de Control Interno correspondiente al periodo comprendido entre el 13 de noviembre del 2014 al 14 de febrero del 2015.

Ver Documento del informe

Publicado: Viernes, 09 Marzo 2015
Informe Pormenorizado Octubre de 2014 Open or Close

La E.S.E Red de Servicios de Salud de Primer Nivel en cumplimiento de la ley 1474 de 2011, publica el informe Pormenorizado del Sistema de Control Interno correspondiente al periodo comprendido entre el 14 de Junio al 13 de octubre del 2014.

Ver Documento del informe

Publicado: Viernes, 09 Marzo 2015

INFORME PORMENORIZADO MARZO A JUNIO 2016.pdf

687730

	Hoy	62
	Ayer	94
	Esta semana	176
	Este mes	2351
	Total dias	687730

DEBUG
Time:[0.076210021972656sec]

Carrera 22 # 19 -20 Bello Horizonte

Teléfono: 57(8)3183640141
Horario de Atención:
Lunes a Viernes
7:00 am a 12:00 m
2:00 pm a 6:00 pm

La E.S.E. Empresa social del estado Red de servicios de salud de primer nivel, es una entidad pública descentralizada del orden departamental.

La E.S.E. Red de Servicios de Salud de Primer Nivel, en cumplimiento dela Ley 1712 del 6 de marzo de 2014, pone a disposición de la ciudadanía la siguiente información:

CONTACTENOS:

La E.S.E. Red de Servicios de Salud de Primer Nivel, ha habilitado para dicho y único fin, el correo electrónico de "Contáctenos" Para información adicional, dudas o sugerencias escribir al correo:Esta dirección de correo electrónico está siendo protegida contra los robots de spam. Necesita tener JavaScript habilitado para poder verlo. .
La E.S.E. Red de Servicios de Salud de Primer Nivel, ha habilitado para dicho y único fin, el correo electrónico de "Notificaciones Judiciales" Para notificaciones judiciales escribir al correo:Esta dirección de correo electrónico está siendo protegida contra los robots de spam. Necesita tener JavaScript habilitado para poder verlo. .

Consola de depuración de Joomla!

Sesión

Información del perfil

Uso de la memoria

Consultas de la base de datos

34 consultas registradas 306.8 ms

¡ 6 duplicaciones detectadas!

2 duplicaciones: #7 #8

2 duplicaciones: #14 #16

2 duplicaciones: #26 #29

Tiempo de la consulta: 0.11 ms Consulta a la memoria: 0.015 MB memoria antes de la consulta: 2.687 MB Filas devueltas: 0

SELECT `data`

  FROM `y5cym_session`

  WHERE `session_id` = '1lmg0tte26bq8n04ahgeasa501'

Explicar

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

Perfil

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

Llamada de pila

JROOT/libraries/joomla/session/storage/database.php:46

JROOT/libraries/joomla/session/session.php:658

JROOT/libraries/joomla/session/session.php:596

JROOT/libraries/cms/application/cms.php:672

JROOT/libraries/cms/application/cms.php:131

JROOT/libraries/cms/application/site.php:63

JROOT/libraries/cms/application/cms.php:332

JROOT/libraries/joomla/factory.php:124

JROOT/index.php:37

[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.10 ms Después de la última consulta: 0.82 ms Consulta a la memoria: 0.008 MB memoria antes de la consulta: 2.841 MB

DELETE 

  FROM `y5cym_session`

  WHERE `time` < '1643138661'

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	DELETE	y5cym_session	NULL	range	time	time	45	const	1	100.00	Using where

Perfil

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
updating	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	0.0 ms

Llamada de pila

JROOT/libraries/cms/application/cms.php:689

JROOT/libraries/cms/application/cms.php:131

JROOT/libraries/cms/application/site.php:63

JROOT/libraries/cms/application/cms.php:332

JROOT/libraries/joomla/factory.php:124

JROOT/index.php:37

[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.08 ms Después de la última consulta: 0.06 ms Consulta a la memoria: 0.012 MB memoria antes de la consulta: 2.853 MB Filas devueltas: 0

SELECT `session_id`

  FROM `y5cym_session`

  WHERE `session_id` = '1lmg0tte26bq8n04ahgeasa501' 
  LIMIT 0, 1

Explicar

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

Perfil

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

Llamada de pila

JROOT/libraries/cms/application/cms.php:175

JROOT/libraries/cms/application/cms.php:698

JROOT/libraries/cms/application/cms.php:131

JROOT/libraries/cms/application/site.php:63

JROOT/libraries/cms/application/cms.php:332

JROOT/libraries/joomla/factory.php:124

JROOT/index.php:37

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

Tiempo de la consulta: 42.11 ms Después de la última consulta: 0.06 ms Consulta a la memoria: 0.009 MB memoria antes de la consulta: 2.866 MB

INSERT INTO `y5cym_session`
(`session_id`, `client_id`, `time`) 
  VALUES 
('1lmg0tte26bq8n04ahgeasa501', 0, '1643139561')

Explicar

'Explicar' no es posible en la consulta: INSERT INTO `y5cym_session` (`session_id`, `client_id`, `time`) VALUES ('1lmg0tte26bq8n04ahgeasa501', 0, '1643139561')

Perfil

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
update	0.0 ms
end	0.0 ms
query end	42.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	0.0 ms

Llamada de pila

JROOT/libraries/cms/application/cms.php:207

JROOT/libraries/cms/application/cms.php:698

JROOT/libraries/cms/application/cms.php:131

JROOT/libraries/cms/application/site.php:63

JROOT/libraries/cms/application/cms.php:332

JROOT/libraries/joomla/factory.php:124

JROOT/index.php:37

[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.23 ms Después de la última consulta: 2.53 ms Consulta a la memoria: 0.014 MB memoria antes de la consulta: 3.370 MB Filas devueltas: 1

SELECT b.id

  FROM y5cym_usergroups AS a

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

  WHERE a.id = 1

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	1	100.00	Using where; Using index

Perfil

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

Llamada de pila

JROOT/libraries/joomla/access/access.php:336

JROOT/libraries/joomla/access/access.php:405

JROOT/libraries/joomla/user/user.php:420

JROOT/libraries/cms/plugin/helper.php:298

JROOT/libraries/cms/plugin/helper.php:165

JROOT/libraries/cms/application/site.php:546

JROOT/libraries/cms/application/site.php:196

JROOT/libraries/cms/application/cms.php:255

JROOT/index.php:40

[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.13 ms Después de la última consulta: 0.33 ms Consulta a la memoria: 0.013 MB memoria antes de la consulta: 3.438 MB Filas devueltas: 4

SELECT id, rules

  FROM `y5cym_viewlevels`

Explicar

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

Perfil

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

Llamada de pila

JROOT/libraries/joomla/access/access.php:422

JROOT/libraries/joomla/user/user.php:420

JROOT/libraries/cms/plugin/helper.php:298

JROOT/libraries/cms/plugin/helper.php:165

JROOT/libraries/cms/application/site.php:546

JROOT/libraries/cms/application/site.php:196

JROOT/libraries/cms/application/cms.php:255

JROOT/index.php:40

[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.22 ms Después de la última consulta: 9.73 ms Consulta a la memoria: 0.019 MB memoria antes de la consulta: 5.174 MB Filas devueltas: 1

Consultas duplicadas: #8

SELECT template

  FROM y5cym_template_styles as s

  WHERE s.client_id = 0 
  AND s.home = 1

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	NULL	ALL	idx_home	No pudo usarse una clave de índice	NULL	NULL	11	9.09	Using where

Perfil

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

Llamada de pila

JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:31

JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:105

JROOT/libraries/rokcommon/RokCommon/Service.php:71

JROOT/libraries/rokcommon/include.php:38

JROOT/plugins/system/rokcommon/rokcommon.php:99

JROOT/plugins/system/rokcommon/rokcommon.php:57

JROOT/libraries/cms/plugin/helper.php:257

JROOT/libraries/cms/plugin/helper.php:172

JROOT/libraries/cms/application/cms.php:586

JROOT/libraries/cms/application/site.php:620

JROOT/libraries/cms/application/site.php:196

JROOT/libraries/cms/application/cms.php:255

JROOT/index.php:40

[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.13 ms Después de la última consulta: 0.06 ms Consulta a la memoria: 0.020 MB memoria antes de la consulta: 5.193 MB Filas devueltas: 1

Consultas duplicadas: #7

SELECT template

  FROM y5cym_template_styles as s

  WHERE s.client_id = 0 
  AND s.home = 1

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	NULL	ALL	idx_home	No pudo usarse una clave de índice	NULL	NULL	11	9.09	Using where

Perfil

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

Llamada de pila

JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:31

JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:67

JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:106

JROOT/libraries/rokcommon/RokCommon/Service.php:71

JROOT/libraries/rokcommon/include.php:38

JROOT/plugins/system/rokcommon/rokcommon.php:99

JROOT/plugins/system/rokcommon/rokcommon.php:57

JROOT/libraries/cms/plugin/helper.php:257

JROOT/libraries/cms/plugin/helper.php:172

JROOT/libraries/cms/application/cms.php:586

JROOT/libraries/cms/application/site.php:620

JROOT/libraries/cms/application/site.php:196

JROOT/libraries/cms/application/cms.php:255

JROOT/index.php:40

[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.15 ms Después de la última consulta: 2.72 ms Consulta a la memoria: 0.015 MB memoria antes de la consulta: 5.535 MB Filas devueltas: 2

SELECT extension, file, type

  FROM y5cym_rokcommon_configs

  ORDER BY priority

Explicar

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

Perfil

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
Sorting result	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
Creating sort index	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	0.0 ms

Llamada de pila

JROOT/plugins/system/rokcommon/rokcommon.php:130

JROOT/plugins/system/rokcommon/rokcommon.php:78

JROOT/libraries/cms/plugin/helper.php:257

JROOT/libraries/cms/plugin/helper.php:172

JROOT/libraries/cms/application/cms.php:586

JROOT/libraries/cms/application/site.php:620

JROOT/libraries/cms/application/site.php:196

JROOT/libraries/cms/application/cms.php:255

JROOT/index.php:40

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

Tiempo de la consulta: 75.63 ms Después de la última consulta: 8.26 ms Consulta a la memoria: 0.020 MB memoria antes de la consulta: 7.070 MB

UPDATE `y5cym_extensions`

  SET `params` = '{\"mediaversion\":\"0d1f715fd2ec803903e2e7af300ef776\"}'

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

Explicar

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

Perfil

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
updating	0.0 ms
end	0.0 ms
query end	75.3 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	0.0 ms

Llamada de pila

JROOT/libraries/cms/library/helper.php:119

JROOT/libraries/cms/version/version.php:230

JROOT/libraries/cms/version/version.php:189

JROOT/libraries/joomla/factory.php:734

JROOT/libraries/joomla/factory.php:215

JROOT/plugins/system/helix/core/helix.php:50

JROOT/plugins/system/helix/core/helix.php:36

JROOT/plugins/system/helix/helix.php:21

JROOT/libraries/joomla/event/event.php:71

JROOT/libraries/joomla/event/dispatcher.php:162

JROOT/libraries/joomla/application/base.php:106

JROOT/libraries/cms/application/cms.php:587

JROOT/libraries/cms/application/site.php:620

JROOT/libraries/cms/application/site.php:196

JROOT/libraries/cms/application/cms.php:255

JROOT/index.php:40

[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.78 ms Después de la última consulta: 1.47 ms Consulta a la memoria: 0.045 MB memoria antes de la consulta: 7.380 MB Filas devueltas: 82

SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component

  FROM y5cym_menu AS m

  LEFT JOIN y5cym_extensions AS e 
  ON m.component_id = e.extension_id

  WHERE m.published = 1 
  AND m.parent_id > 0 
  AND m.client_id = 0

  ORDER BY m.lft

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	range	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	5	NULL	171	10.00	Using index condition; Using where; Usando 'filesort'
1	SIMPLE	e	NULL	eq_ref	PRIMARY	PRIMARY	4	eseguavi_db.m.component_id	1	100.00	Using where

Perfil

Status	Duration
starting	0.1 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
Sorting result	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
Creating sort index	0.5 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	0.0 ms

Llamada de pila

JROOT/libraries/cms/menu/site.php:47

JROOT/libraries/cms/menu/menu.php:64

JROOT/libraries/cms/menu/menu.php:118

JROOT/libraries/cms/application/cms.php:357

JROOT/libraries/cms/application/site.php:250

JROOT/libraries/cms/application/site.php:411

JROOT/plugins/system/helix/core/helix.php:65

JROOT/plugins/system/helix/core/helix.php:114

JROOT/plugins/system/helix/core/helix.php:302

JROOT/plugins/system/helix/core/helix.php:290

JROOT/plugins/system/helix/core/helix.php:1592

JROOT/plugins/system/helix/helix.php:22

JROOT/libraries/joomla/event/event.php:71

JROOT/libraries/joomla/event/dispatcher.php:162

JROOT/libraries/joomla/application/base.php:106

JROOT/libraries/cms/application/cms.php:587

JROOT/libraries/cms/application/site.php:620

JROOT/libraries/cms/application/site.php:196

JROOT/libraries/cms/application/cms.php:255

JROOT/index.php:40

[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: 7.55 ms Consulta a la memoria: 0.024 MB memoria antes de la consulta: 9.292 MB Filas devueltas: 17

SHOW FULL COLUMNS 
  FROM `y5cym_extensions`

Explicar

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

Perfil

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
Opening tables	0.1 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
executing	0.0 ms
Opening tables	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
Sending data	0.1 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
removing tmp table	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	0.0 ms

Llamada de pila

JROOT/libraries/joomla/table/table.php:229

JROOT/libraries/joomla/table/table.php:150

JROOT/libraries/joomla/table/extension.php:31

JROOT/libraries/joomla/table/table.php:294

JROOT/plugins/system/roksprocket/roksprocket.php:46

JROOT/libraries/joomla/event/event.php:71

JROOT/libraries/joomla/event/dispatcher.php:162

JROOT/libraries/joomla/application/base.php:106

JROOT/libraries/cms/application/cms.php:587

JROOT/libraries/cms/application/site.php:620

JROOT/libraries/cms/application/site.php:196

JROOT/libraries/cms/application/cms.php:255

JROOT/index.php:40

[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.22 ms Después de la última consulta: 0.33 ms Consulta a la memoria: 0.016 MB memoria antes de la consulta: 9.368 MB Filas devueltas: 1

SELECT `extension_id`

  FROM `y5cym_extensions`

  WHERE type = 'component' 
  AND element = 'com_roksprocket'

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	y5cym_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	302	const	1	10.00	Using where

Perfil

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.1 ms
preparing	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	0.0 ms

Llamada de pila

JROOT/libraries/joomla/table/extension.php:108

JROOT/plugins/system/roksprocket/roksprocket.php:50

JROOT/libraries/joomla/event/event.php:71

JROOT/libraries/joomla/event/dispatcher.php:162

JROOT/libraries/joomla/application/base.php:106

JROOT/libraries/cms/application/cms.php:587

JROOT/libraries/cms/application/site.php:620

JROOT/libraries/cms/application/site.php:196

JROOT/libraries/cms/application/cms.php:255

JROOT/index.php:40

[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.18 ms Después de la última consulta: 0.10 ms Consulta a la memoria: 0.020 MB memoria antes de la consulta: 9.386 MB Filas devueltas: 1

Consultas duplicadas: #16

SELECT *

  FROM y5cym_extensions

  WHERE `extension_id` = '10041'

Explicar

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

Perfil

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

Llamada de pila

JROOT/libraries/joomla/table/table.php:705

JROOT/plugins/system/roksprocket/roksprocket.php:55

JROOT/libraries/joomla/event/event.php:71

JROOT/libraries/joomla/event/dispatcher.php:162

JROOT/libraries/joomla/application/base.php:106

JROOT/libraries/cms/application/cms.php:587

JROOT/libraries/cms/application/site.php:620

JROOT/libraries/cms/application/site.php:196

JROOT/libraries/cms/application/cms.php:255

JROOT/index.php:40

[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.18 ms Después de la última consulta: 0.10 ms Consulta a la memoria: 0.016 MB memoria antes de la consulta: 9.400 MB Filas devueltas: 1

SELECT `extension_id`

  FROM `y5cym_extensions`

  WHERE type = 'module' 
  AND element = 'mod_roksprocket'

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	y5cym_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	302	const	1	10.00	Using where

Perfil

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

Llamada de pila

JROOT/libraries/joomla/table/extension.php:108

JROOT/plugins/system/roksprocket/roksprocket.php:72

JROOT/libraries/joomla/event/event.php:71

JROOT/libraries/joomla/event/dispatcher.php:162

JROOT/libraries/joomla/application/base.php:106

JROOT/libraries/cms/application/cms.php:587

JROOT/libraries/cms/application/site.php:620

JROOT/libraries/cms/application/site.php:196

JROOT/libraries/cms/application/cms.php:255

JROOT/index.php:40

[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.12 ms Después de la última consulta: 0.09 ms Consulta a la memoria: 0.020 MB memoria antes de la consulta: 9.417 MB Filas devueltas: 1

Consultas duplicadas: #14

SELECT *

  FROM y5cym_extensions

  WHERE `extension_id` = '10041'

Explicar

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

Perfil

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

Llamada de pila

JROOT/libraries/joomla/table/table.php:705

JROOT/plugins/system/roksprocket/roksprocket.php:76

JROOT/libraries/joomla/event/event.php:71

JROOT/libraries/joomla/event/dispatcher.php:162

JROOT/libraries/joomla/application/base.php:106

JROOT/libraries/cms/application/cms.php:587

JROOT/libraries/cms/application/site.php:620

JROOT/libraries/cms/application/site.php:196

JROOT/libraries/cms/application/cms.php:255

JROOT/index.php:40

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

Tiempo de la consulta: 0.27 ms Después de la última consulta: 23.34 ms Consulta a la memoria: 0.025 MB memoria antes de la consulta: 11.866 MB Filas devueltas: 1

SELECT a.rules

  FROM y5cym_assets AS a

  WHERE (a.id = 1)

  GROUP BY a.id, a.rules, a.lft

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

Perfil

Status	Duration
starting	0.1 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	0.0 ms

Llamada de pila

JROOT/libraries/joomla/access/access.php:250

JROOT/libraries/joomla/user/user.php:356

JROOT/components/com_content/models/article.php:55

JROOT/libraries/legacy/model/legacy.php:415

JROOT/components/com_content/models/article.php:75

JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:394

JROOT/components/com_content/views/article/view.html.php:37

JROOT/libraries/joomla/cache/controller/view.php:98

JROOT/libraries/legacy/controller/legacy.php:681

JROOT/components/com_content/controller.php:79

JROOT/libraries/legacy/controller/legacy.php:722

JROOT/components/com_content/content.php:16

JROOT/libraries/cms/component/helper.php:352

JROOT/libraries/cms/component/helper.php:332

JROOT/libraries/cms/application/site.php:178

JROOT/libraries/cms/application/site.php:208

JROOT/libraries/cms/application/cms.php:255

JROOT/index.php:40

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

Tiempo de la consulta: 0.33 ms Después de la última consulta: 0.41 ms Consulta a la memoria: 0.026 MB memoria antes de la consulta: 11.926 MB Filas devueltas: 2

SELECT b.rules

  FROM y5cym_assets AS a

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

  WHERE (a.name = 'com_content')

  GROUP BY b.id, b.rules, b.lft

  ORDER BY b.lft

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	const	idx_asset_name	idx_asset_name	152	const	1	100.00	Using temporary; Usando 'filesort'
1	SIMPLE	b	NULL	range	idx_lft_rgt	idx_lft_rgt	4	NULL	11	100.00	Using where

Perfil

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.1 ms
preparing	0.0 ms
Creating tmp table	0.0 ms
Sorting result	0.0 ms
executing	0.0 ms
Sending data	0.1 ms
Creating sort index	0.0 ms
end	0.0 ms
query end	0.0 ms
removing tmp table	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	0.0 ms

Llamada de pila

JROOT/libraries/joomla/access/access.php:250

JROOT/libraries/joomla/access/access.php:110

JROOT/libraries/joomla/user/user.php:365

JROOT/components/com_content/models/article.php:55

JROOT/libraries/legacy/model/legacy.php:415

JROOT/components/com_content/models/article.php:75

JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:394

JROOT/components/com_content/views/article/view.html.php:37

JROOT/libraries/joomla/cache/controller/view.php:98

JROOT/libraries/legacy/controller/legacy.php:681

JROOT/components/com_content/controller.php:79

JROOT/libraries/legacy/controller/legacy.php:722

JROOT/components/com_content/content.php:16

JROOT/libraries/cms/component/helper.php:352

JROOT/libraries/cms/component/helper.php:332

JROOT/libraries/cms/application/site.php:178

JROOT/libraries/cms/application/site.php:208

JROOT/libraries/cms/application/cms.php:255

JROOT/index.php:40

[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.64 ms Después de la última consulta: 0.35 ms Consulta a la memoria: 0.029 MB memoria antes de la consulta: 11.976 MB Filas devueltas: 1

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

  FROM y5cym_content AS a

  LEFT JOIN y5cym_categories AS c 
  on c.id = a.catid

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

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

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

  LEFT 
  OUTER JOIN  (SELECT cat.id as id 
  FROM y5cym_categories AS cat JOIN y5cym_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt 
  WHERE parent.extension = 'com_content' 
  AND parent.published <= 0 
  GROUP BY cat.id) AS badcats 
  ON badcats.id = c.id

  WHERE a.id = 55 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2022-01-25 19:39:21') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2022-01-25 19:39:21') 
  AND (a.state = 1 OR a.state =2)

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	a	NULL	const	PRIMARY,idx_state	PRIMARY	4	const	1	100.00	NULL
1	PRIMARY	c	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	PRIMARY	u	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	PRIMARY	parent	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	PRIMARY	v	NULL	const	PRIMARY	PRIMARY	4	const	0	0.00	unique row not found
1	PRIMARY	<derived2>	NULL	ref	<auto_key0>	<auto_key0>	4	const	1	100.00	Using index
2	DERIVED	parent	NULL	range	cat_idx,idx_left_right	cat_idx	153	NULL	3	100.00	Using index condition; Using temporary; Usando 'filesort'
2	DERIVED	cat	NULL	index	PRIMARY,cat_idx,idx_access,idx_checkout,idx_path,idx_left_right,idx_alias,idx_language	idx_left_right	8	NULL	43	11.11	Using where; Using index; Using join buffer (Block Nested Loop)

Perfil

Status	Duration
starting	0.1 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.1 ms
System lock	0.0 ms
optimizing	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
Creating tmp table	0.0 ms
Sorting result	0.0 ms
statistics	0.1 ms
preparing	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
executing	0.0 ms
Sending data	0.1 ms
Creating sort index	0.0 ms
end	0.0 ms
query end	0.0 ms
removing tmp table	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
removing tmp table	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	0.0 ms

Llamada de pila

JROOT/components/com_content/models/article.php:158

JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:394

JROOT/components/com_content/views/article/view.html.php:37

JROOT/libraries/joomla/cache/controller/view.php:98

JROOT/libraries/legacy/controller/legacy.php:681

JROOT/components/com_content/controller.php:79

JROOT/libraries/legacy/controller/legacy.php:722

JROOT/components/com_content/content.php:16

JROOT/libraries/cms/component/helper.php:352

JROOT/libraries/cms/component/helper.php:332

JROOT/libraries/cms/application/site.php:178

JROOT/libraries/cms/application/site.php:208

JROOT/libraries/cms/application/cms.php:255

JROOT/index.php:40

[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.00 ms Después de la última consulta: 1.39 ms Consulta a la memoria: 0.028 MB memoria antes de la consulta: 12.214 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 y5cym_categories as c

  LEFT JOIN y5cym_categories AS s 
  ON (s.lft <= c.lft 
  AND s.rgt >= c.rgt) OR (s.lft > c.lft 
  AND s.rgt < c.rgt)

  LEFT JOIN  (SELECT cat.id as id 
  FROM y5cym_categories AS cat JOIN y5cym_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt 
  WHERE parent.extension = 'com_content' 
  AND parent.published != 1 
  GROUP BY cat.id) AS badcats 
  ON badcats.id = c.id

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1) 
  AND c.published = 1 
  AND s.id=25 
  AND badcats.id is null

  GROUP BY 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

  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	Using temporary; Usando 'filesort'
1	PRIMARY	c	NULL	ALL	cat_idx,idx_access,idx_left_right	No pudo usarse una clave de índice	NULL	NULL	43	40.05	Using where
1	PRIMARY	<derived2>	NULL	ALL	NULL	No pudo usarse una clave de índice	NULL	NULL	20	10.00	Using where; Not exists; Using join buffer (Block Nested Loop)
2	DERIVED	parent	NULL	range	cat_idx,idx_left_right	cat_idx	153	NULL	4	100.00	Using index condition; Using temporary; Usando 'filesort'
2	DERIVED	cat	NULL	index	PRIMARY,cat_idx,idx_access,idx_checkout,idx_path,idx_left_right,idx_alias,idx_language	idx_left_right	8	NULL	43	11.11	Using where; Using index; Using join buffer (Block Nested Loop)

Perfil

Status	Duration
starting	0.1 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.1 ms
System lock	0.0 ms
optimizing	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
Creating tmp table	0.0 ms
Sorting result	0.0 ms
statistics	0.1 ms
preparing	0.0 ms
Creating tmp table	0.0 ms
Sorting result	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
executing	0.0 ms
Sending data	0.1 ms
Creating sort index	0.2 ms
Creating sort index	0.0 ms
end	0.0 ms
query end	0.0 ms
removing tmp table	0.0 ms
query end	0.0 ms
removing tmp table	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
removing tmp table	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	0.0 ms

Llamada de pila

JROOT/libraries/legacy/categories/categories.php:288

JROOT/libraries/legacy/categories/categories.php:181

JROOT/components/com_content/helpers/route.php:39

JROOT/components/com_content/views/article/view.html.php:65

JROOT/libraries/joomla/cache/controller/view.php:98

JROOT/libraries/legacy/controller/legacy.php:681

JROOT/components/com_content/controller.php:79

JROOT/libraries/legacy/controller/legacy.php:722

JROOT/components/com_content/content.php:16

JROOT/libraries/cms/component/helper.php:352

JROOT/libraries/cms/component/helper.php:332

JROOT/libraries/cms/application/site.php:178

JROOT/libraries/cms/application/site.php:208

JROOT/libraries/cms/application/cms.php:255

JROOT/index.php:40

[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.23 ms Después de la última consulta: 1.53 ms Consulta a la memoria: 0.025 MB memoria antes de la consulta: 12.462 MB Filas devueltas: 0

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

  FROM `y5cym_contentitem_tag_map` AS m 

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

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

Explicar

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

Perfil

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

Llamada de pila

JROOT/libraries/cms/helper/tags.php:409

JROOT/components/com_content/views/article/view.html.php:148

JROOT/libraries/joomla/cache/controller/view.php:98

JROOT/libraries/legacy/controller/legacy.php:681

JROOT/components/com_content/controller.php:79

JROOT/libraries/legacy/controller/legacy.php:722

JROOT/components/com_content/content.php:16

JROOT/libraries/cms/component/helper.php:352

JROOT/libraries/cms/component/helper.php:332

JROOT/libraries/cms/application/site.php:178

JROOT/libraries/cms/application/site.php:208

JROOT/libraries/cms/application/cms.php:255

JROOT/index.php:40

[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.33 ms Después de la última consulta: 6.69 ms Consulta a la memoria: 0.031 MB memoria antes de la consulta: 13.341 MB Filas devueltas: 24

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

  FROM y5cym_modules AS m

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

  LEFT JOIN y5cym_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 <= '2022-01-25 19:39:21') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2022-01-25 19:39:21') 
  AND m.access IN (1,1) 
  AND m.client_id = 0 
  AND (mm.menuid = 210 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	69	1.60	Using index condition; Using where; Usando 'filesort'
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid	element_clientid	303	eseguavi_db.m.module,const	1	10.00	Using index condition; Using where
1	SIMPLE	mm	NULL	ref	PRIMARY	PRIMARY	4	eseguavi_db.m.id	3	40.00	Using where; Using index

Perfil

Status	Duration
starting	0.1 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.1 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.1 ms
preparing	0.0 ms
Sorting result	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
Creating sort index	0.9 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	0.0 ms

Llamada de pila

JROOT/libraries/cms/module/helper.php:376

JROOT/libraries/cms/module/helper.php:84

JROOT/plugins/content/loadmodule/loadmodule.php:139

JROOT/plugins/content/loadmodule/loadmodule.php:80

JROOT/libraries/joomla/event/event.php:71

JROOT/libraries/joomla/event/dispatcher.php:162

JROOT/components/com_content/views/article/view.html.php:153

JROOT/libraries/joomla/cache/controller/view.php:98

JROOT/libraries/legacy/controller/legacy.php:681

JROOT/components/com_content/controller.php:79

JROOT/libraries/legacy/controller/legacy.php:722

JROOT/components/com_content/content.php:16

JROOT/libraries/cms/component/helper.php:352

JROOT/libraries/cms/component/helper.php:332

JROOT/libraries/cms/application/site.php:178

JROOT/libraries/cms/application/site.php:208

JROOT/libraries/cms/application/cms.php:255

JROOT/index.php:40

[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.93 ms Después de la última consulta: 10.36 ms Consulta a la memoria: 0.044 MB memoria antes de la consulta: 13.829 MB Filas devueltas: 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 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, LENGTH(a.fulltext) AS readmore,
  CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
  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,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published, 
  CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published

  FROM y5cym_content AS a

  LEFT JOIN y5cym_content_frontpage AS fp 
  ON fp.content_id = a.id

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

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

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

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

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

  LEFT 
  OUTER JOIN (SELECT cat.id as id 
  FROM y5cym_categories AS cat JOIN y5cym_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt 
  WHERE parent.extension = 'com_content' 
  AND parent.published != 1 
  GROUP BY cat.id ) AS badcats 
  ON badcats.id = c.id

  WHERE a.access IN (1,1) 
  AND c.access IN (1,1) 
  AND 
  CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 
  AND a.catid IN (17) 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2022-01-25 19:39:21') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2022-01-25 19:39:21')

  ORDER BY a.ordering ASC 
  LIMIT 0, 50

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	c	NULL	const	PRIMARY,idx_access	PRIMARY	4	const	1	100.00	Usando 'filesort'
1	PRIMARY	a	NULL	ref	idx_access,idx_catid	idx_catid	4	const	2	16.00	Using index condition; Using where
1	PRIMARY	fp	NULL	eq_ref	PRIMARY	PRIMARY	4	eseguavi_db.a.id	1	100.00	Using where; Using index
1	PRIMARY	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	eseguavi_db.a.created_by	1	100.00	Using where
1	PRIMARY	uam	NULL	eq_ref	PRIMARY	PRIMARY	4	eseguavi_db.a.modified_by	1	100.00	Using where
1	PRIMARY	parent	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	Using where
1	PRIMARY	v	NULL	eq_ref	PRIMARY	PRIMARY	4	eseguavi_db.a.id	1	100.00	Using where
1	PRIMARY	<derived2>	NULL	ref	<auto_key0>	<auto_key0>	4	const	2	100.00	Using where; Using index
2	DERIVED	parent	NULL	range	cat_idx,idx_left_right	cat_idx	153	NULL	4	100.00	Using index condition; Using temporary; Usando 'filesort'
2	DERIVED	cat	NULL	index	PRIMARY,cat_idx,idx_access,idx_checkout,idx_path,idx_left_right,idx_alias,idx_language	idx_left_right	8	NULL	43	11.11	Using where; Using index; Using join buffer (Block Nested Loop)

Perfil

Status	Duration
starting	0.2 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.1 ms
System lock	0.0 ms
optimizing	0.0 ms
optimizing	0.0 ms
statistics	0.1 ms
preparing	0.0 ms
Creating tmp table	0.0 ms
Sorting result	0.0 ms
statistics	0.1 ms
preparing	0.0 ms
Sorting result	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
Creating sort index	0.1 ms
executing	0.0 ms
Sending data	0.1 ms
Creating sort index	0.0 ms
end	0.0 ms
query end	0.0 ms
removing tmp table	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
removing tmp table	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	0.0 ms

Llamada de pila

JROOT/libraries/legacy/model/legacy.php:301

JROOT/libraries/legacy/model/list.php:171

JROOT/components/com_content/models/articles.php:537

JROOT/modules/mod_fancypantsaccordion/helper.php:89

JROOT/modules/mod_fancypantsaccordion/mod_fancypantsaccordion.php:20

JROOT/libraries/cms/module/helper.php:190

JROOT/libraries/joomla/cache/controller/callback.php:158

JROOT/libraries/cms/module/helper.php:550

JROOT/libraries/joomla/document/html/renderer/module.php:100

JROOT/plugins/content/loadmodule/loadmodule.php:145

JROOT/plugins/content/loadmodule/loadmodule.php:80

JROOT/libraries/joomla/event/event.php:71

JROOT/libraries/joomla/event/dispatcher.php:162

JROOT/components/com_content/views/article/view.html.php:153

JROOT/libraries/joomla/cache/controller/view.php:98

JROOT/libraries/legacy/controller/legacy.php:681

JROOT/components/com_content/controller.php:79

JROOT/libraries/legacy/controller/legacy.php:722

JROOT/components/com_content/content.php:16

JROOT/libraries/cms/component/helper.php:352

JROOT/libraries/cms/component/helper.php:332

JROOT/libraries/cms/application/site.php:178

JROOT/libraries/cms/application/site.php:208

JROOT/libraries/cms/application/cms.php:255

JROOT/index.php:40

[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.21 ms Después de la última consulta: 0.43 ms Consulta a la memoria: 0.039 MB memoria antes de la consulta: 13.927 MB Filas devueltas: 0

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

  FROM `y5cym_contentitem_tag_map` AS m 

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

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

Explicar

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

Perfil

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

Llamada de pila

JROOT/libraries/cms/helper/tags.php:409

JROOT/components/com_content/models/articles.php:663

JROOT/modules/mod_fancypantsaccordion/helper.php:89

JROOT/modules/mod_fancypantsaccordion/mod_fancypantsaccordion.php:20

JROOT/libraries/cms/module/helper.php:190

JROOT/libraries/joomla/cache/controller/callback.php:158

JROOT/libraries/cms/module/helper.php:550

JROOT/libraries/joomla/document/html/renderer/module.php:100

JROOT/plugins/content/loadmodule/loadmodule.php:145

JROOT/plugins/content/loadmodule/loadmodule.php:80

JROOT/libraries/joomla/event/event.php:71

JROOT/libraries/joomla/event/dispatcher.php:162

JROOT/components/com_content/views/article/view.html.php:153

JROOT/libraries/joomla/cache/controller/view.php:98

JROOT/libraries/legacy/controller/legacy.php:681

JROOT/components/com_content/controller.php:79

JROOT/libraries/legacy/controller/legacy.php:722

JROOT/components/com_content/content.php:16

JROOT/libraries/cms/component/helper.php:352

JROOT/libraries/cms/component/helper.php:332

JROOT/libraries/cms/application/site.php:178

JROOT/libraries/cms/application/site.php:208

JROOT/libraries/cms/application/cms.php:255

JROOT/index.php:40

[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.19 ms Después de la última consulta: 0.25 ms Consulta a la memoria: 0.039 MB memoria antes de la consulta: 13.977 MB Filas devueltas: 0

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

  FROM `y5cym_contentitem_tag_map` AS m 

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

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

Explicar

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

Perfil

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

Llamada de pila

JROOT/libraries/cms/helper/tags.php:409

JROOT/components/com_content/models/articles.php:663

JROOT/modules/mod_fancypantsaccordion/helper.php:89

JROOT/modules/mod_fancypantsaccordion/mod_fancypantsaccordion.php:20

JROOT/libraries/cms/module/helper.php:190

JROOT/libraries/joomla/cache/controller/callback.php:158

JROOT/libraries/cms/module/helper.php:550

JROOT/libraries/joomla/document/html/renderer/module.php:100

JROOT/plugins/content/loadmodule/loadmodule.php:145

JROOT/plugins/content/loadmodule/loadmodule.php:80

JROOT/libraries/joomla/event/event.php:71

JROOT/libraries/joomla/event/dispatcher.php:162

JROOT/components/com_content/views/article/view.html.php:153

JROOT/libraries/joomla/cache/controller/view.php:98

JROOT/libraries/legacy/controller/legacy.php:681

JROOT/components/com_content/controller.php:79

JROOT/libraries/legacy/controller/legacy.php:722

JROOT/components/com_content/content.php:16

JROOT/libraries/cms/component/helper.php:352

JROOT/libraries/cms/component/helper.php:332

JROOT/libraries/cms/application/site.php:178

JROOT/libraries/cms/application/site.php:208

JROOT/libraries/cms/application/cms.php:255

JROOT/index.php:40

[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.10 ms Después de la última consulta: 0.26 ms Consulta a la memoria: 0.031 MB memoria antes de la consulta: 14.005 MB Filas devueltas: 1

Consultas duplicadas: #29

SELECT title

  FROM y5cym_categories

  WHERE id = 17

Explicar

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

Perfil

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

Llamada de pila

JROOT/modules/mod_fancypantsaccordion/tmpl/default.php:57

JROOT/modules/mod_fancypantsaccordion/mod_fancypantsaccordion.php:36

JROOT/libraries/cms/module/helper.php:190

JROOT/libraries/joomla/cache/controller/callback.php:158

JROOT/libraries/cms/module/helper.php:550

JROOT/libraries/joomla/document/html/renderer/module.php:100

JROOT/plugins/content/loadmodule/loadmodule.php:145

JROOT/plugins/content/loadmodule/loadmodule.php:80

JROOT/libraries/joomla/event/event.php:71

JROOT/libraries/joomla/event/dispatcher.php:162

JROOT/components/com_content/views/article/view.html.php:153

JROOT/libraries/joomla/cache/controller/view.php:98

JROOT/libraries/legacy/controller/legacy.php:681

JROOT/components/com_content/controller.php:79

JROOT/libraries/legacy/controller/legacy.php:722

JROOT/components/com_content/content.php:16

JROOT/libraries/cms/component/helper.php:352

JROOT/libraries/cms/component/helper.php:332

JROOT/libraries/cms/application/site.php:178

JROOT/libraries/cms/application/site.php:208

JROOT/libraries/cms/application/cms.php:255

JROOT/index.php:40

[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.91 ms Después de la última consulta: 0.10 ms Consulta a la memoria: 0.041 MB memoria antes de la consulta: 14.045 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 y5cym_categories as c

  LEFT JOIN y5cym_categories AS s 
  ON (s.lft <= c.lft 
  AND s.rgt >= c.rgt) OR (s.lft > c.lft 
  AND s.rgt < c.rgt)

  LEFT JOIN  (SELECT cat.id as id 
  FROM y5cym_categories AS cat JOIN y5cym_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt 
  WHERE parent.extension = 'com_content' 
  AND parent.published != 1 
  GROUP BY cat.id) AS badcats 
  ON badcats.id = c.id

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1) 
  AND c.published = 1 
  AND s.id=17 
  AND badcats.id is null

  GROUP BY 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

  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	Using temporary; Usando 'filesort'
1	PRIMARY	c	NULL	ALL	cat_idx,idx_access,idx_left_right	No pudo usarse una clave de índice	NULL	NULL	43	40.05	Using where
1	PRIMARY	<derived2>	NULL	ALL	NULL	No pudo usarse una clave de índice	NULL	NULL	20	10.00	Using where; Not exists; Using join buffer (Block Nested Loop)
2	DERIVED	parent	NULL	range	cat_idx,idx_left_right	cat_idx	153	NULL	4	100.00	Using index condition; Using temporary; Usando 'filesort'
2	DERIVED	cat	NULL	index	PRIMARY,cat_idx,idx_access,idx_checkout,idx_path,idx_left_right,idx_alias,idx_language	idx_left_right	8	NULL	43	11.11	Using where; Using index; Using join buffer (Block Nested Loop)

Perfil

Status	Duration
starting	0.1 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.1 ms
System lock	0.0 ms
optimizing	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
Creating tmp table	0.0 ms
Sorting result	0.0 ms
statistics	0.1 ms
preparing	0.0 ms
Creating tmp table	0.0 ms
Sorting result	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
executing	0.0 ms
Sending data	0.1 ms
Creating sort index	0.3 ms
Creating sort index	0.0 ms
end	0.0 ms
query end	0.0 ms
removing tmp table	0.0 ms
query end	0.0 ms
removing tmp table	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
removing tmp table	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	0.0 ms

Llamada de pila

JROOT/libraries/legacy/categories/categories.php:288

JROOT/libraries/legacy/categories/categories.php:181

JROOT/components/com_content/helpers/route.php:39

JROOT/modules/mod_fancypantsaccordion/tmpl/default.php:59

JROOT/modules/mod_fancypantsaccordion/mod_fancypantsaccordion.php:36

JROOT/libraries/cms/module/helper.php:190

JROOT/libraries/joomla/cache/controller/callback.php:158

JROOT/libraries/cms/module/helper.php:550

JROOT/libraries/joomla/document/html/renderer/module.php:100

JROOT/plugins/content/loadmodule/loadmodule.php:145

JROOT/plugins/content/loadmodule/loadmodule.php:80

JROOT/libraries/joomla/event/event.php:71

JROOT/libraries/joomla/event/dispatcher.php:162

JROOT/components/com_content/views/article/view.html.php:153

JROOT/libraries/joomla/cache/controller/view.php:98

JROOT/libraries/legacy/controller/legacy.php:681

JROOT/components/com_content/controller.php:79

JROOT/libraries/legacy/controller/legacy.php:722

JROOT/components/com_content/content.php:16

JROOT/libraries/cms/component/helper.php:352

JROOT/libraries/cms/component/helper.php:332

JROOT/libraries/cms/application/site.php:178

JROOT/libraries/cms/application/site.php:208

JROOT/libraries/cms/application/cms.php:255

JROOT/index.php:40

[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.11 ms Después de la última consulta: 0.21 ms Consulta a la memoria: 0.037 MB memoria antes de la consulta: 14.083 MB Filas devueltas: 1

SELECT alias

  FROM y5cym_content

  WHERE id=59

Explicar

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

Perfil

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

Llamada de pila

JROOT/components/com_content/router.php:101

JROOT/libraries/cms/router/site.php:455

JROOT/libraries/cms/router/site.php:413

JROOT/libraries/cms/router/router.php:216

JROOT/libraries/cms/router/site.php:98

JROOT/libraries/joomla/application/route.php:62

JROOT/modules/mod_fancypantsaccordion/tmpl/default.php:59

JROOT/modules/mod_fancypantsaccordion/mod_fancypantsaccordion.php:36

JROOT/libraries/cms/module/helper.php:190

JROOT/libraries/joomla/cache/controller/callback.php:158

JROOT/libraries/cms/module/helper.php:550

JROOT/libraries/joomla/document/html/renderer/module.php:100

JROOT/plugins/content/loadmodule/loadmodule.php:145

JROOT/plugins/content/loadmodule/loadmodule.php:80

JROOT/libraries/joomla/event/event.php:71

JROOT/libraries/joomla/event/dispatcher.php:162

JROOT/components/com_content/views/article/view.html.php:153

JROOT/libraries/joomla/cache/controller/view.php:98

JROOT/libraries/legacy/controller/legacy.php:681

JROOT/components/com_content/controller.php:79

JROOT/libraries/legacy/controller/legacy.php:722

JROOT/components/com_content/content.php:16

JROOT/libraries/cms/component/helper.php:352

JROOT/libraries/cms/component/helper.php:332

JROOT/libraries/cms/application/site.php:178

JROOT/libraries/cms/application/site.php:208

JROOT/libraries/cms/application/cms.php:255

JROOT/index.php:40

[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.10 ms Después de la última consulta: 0.12 ms Consulta a la memoria: 0.031 MB memoria antes de la consulta: 14.115 MB Filas devueltas: 1

Consultas duplicadas: #26

SELECT title

  FROM y5cym_categories

  WHERE id = 17

Explicar

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

Perfil

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

Llamada de pila

JROOT/modules/mod_fancypantsaccordion/tmpl/default.php:57

JROOT/modules/mod_fancypantsaccordion/mod_fancypantsaccordion.php:36

JROOT/libraries/cms/module/helper.php:190

JROOT/libraries/joomla/cache/controller/callback.php:158

JROOT/libraries/cms/module/helper.php:550

JROOT/libraries/joomla/document/html/renderer/module.php:100

JROOT/plugins/content/loadmodule/loadmodule.php:145

JROOT/plugins/content/loadmodule/loadmodule.php:80

JROOT/libraries/joomla/event/event.php:71

JROOT/libraries/joomla/event/dispatcher.php:162

JROOT/components/com_content/views/article/view.html.php:153

JROOT/libraries/joomla/cache/controller/view.php:98

JROOT/libraries/legacy/controller/legacy.php:681

JROOT/components/com_content/controller.php:79

JROOT/libraries/legacy/controller/legacy.php:722

JROOT/components/com_content/content.php:16

JROOT/libraries/cms/component/helper.php:352

JROOT/libraries/cms/component/helper.php:332

JROOT/libraries/cms/application/site.php:178

JROOT/libraries/cms/application/site.php:208

JROOT/libraries/cms/application/cms.php:255

JROOT/index.php:40

[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.10 ms Después de la última consulta: 0.13 ms Consulta a la memoria: 0.037 MB memoria antes de la consulta: 14.150 MB Filas devueltas: 1

SELECT alias

  FROM y5cym_content

  WHERE id=58

Explicar

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

Perfil

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

Llamada de pila

JROOT/components/com_content/router.php:101

JROOT/libraries/cms/router/site.php:455

JROOT/libraries/cms/router/site.php:413

JROOT/libraries/cms/router/router.php:216

JROOT/libraries/cms/router/site.php:98

JROOT/libraries/joomla/application/route.php:62

JROOT/modules/mod_fancypantsaccordion/tmpl/default.php:59

JROOT/modules/mod_fancypantsaccordion/mod_fancypantsaccordion.php:36

JROOT/libraries/cms/module/helper.php:190

JROOT/libraries/joomla/cache/controller/callback.php:158

JROOT/libraries/cms/module/helper.php:550

JROOT/libraries/joomla/document/html/renderer/module.php:100

JROOT/plugins/content/loadmodule/loadmodule.php:145

JROOT/plugins/content/loadmodule/loadmodule.php:80

JROOT/libraries/joomla/event/event.php:71

JROOT/libraries/joomla/event/dispatcher.php:162

JROOT/components/com_content/views/article/view.html.php:153

JROOT/libraries/joomla/cache/controller/view.php:98

JROOT/libraries/legacy/controller/legacy.php:681

JROOT/components/com_content/controller.php:79

JROOT/libraries/legacy/controller/legacy.php:722

JROOT/components/com_content/content.php:16

JROOT/libraries/cms/component/helper.php:352

JROOT/libraries/cms/component/helper.php:332

JROOT/libraries/cms/application/site.php:178

JROOT/libraries/cms/application/site.php:208

JROOT/libraries/cms/application/cms.php:255

JROOT/index.php:40

[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: 3.61 ms Consulta a la memoria: 0.029 MB memoria antes de la consulta: 14.643 MB Filas devueltas: 30

SHOW FULL COLUMNS 
  FROM `y5cym_content`

Explicar

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

Perfil

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
Opening tables	0.1 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
executing	0.0 ms
Opening tables	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
Sending data	0.1 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
removing tmp table	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	0.0 ms

Llamada de pila

JROOT/libraries/joomla/table/table.php:229

JROOT/libraries/joomla/table/table.php:150

JROOT/libraries/legacy/table/content.php:31

JROOT/libraries/joomla/table/table.php:294

JROOT/components/com_content/models/article.php:263

JROOT/components/com_content/views/article/view.html.php:169

JROOT/libraries/joomla/cache/controller/view.php:98

JROOT/libraries/legacy/controller/legacy.php:681

JROOT/components/com_content/controller.php:79

JROOT/libraries/legacy/controller/legacy.php:722

JROOT/components/com_content/content.php:16

JROOT/libraries/cms/component/helper.php:352

JROOT/libraries/cms/component/helper.php:332

JROOT/libraries/cms/application/site.php:178

JROOT/libraries/cms/application/site.php:208

JROOT/libraries/cms/application/cms.php:255

JROOT/index.php:40

[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.17 ms Después de la última consulta: 0.94 ms Consulta a la memoria: 0.027 MB memoria antes de la consulta: 14.827 MB Filas devueltas: 1

SELECT *

  FROM y5cym_content

  WHERE `id` = '55'

Explicar

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

Perfil

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

Llamada de pila

JROOT/libraries/joomla/table/table.php:705

JROOT/components/com_content/models/article.php:264

JROOT/components/com_content/views/article/view.html.php:169

JROOT/libraries/joomla/cache/controller/view.php:98

JROOT/libraries/legacy/controller/legacy.php:681

JROOT/components/com_content/controller.php:79

JROOT/libraries/legacy/controller/legacy.php:722

JROOT/components/com_content/content.php:16

JROOT/libraries/cms/component/helper.php:352

JROOT/libraries/cms/component/helper.php:332

JROOT/libraries/cms/application/site.php:178

JROOT/libraries/cms/application/site.php:208

JROOT/libraries/cms/application/cms.php:255

JROOT/index.php:40

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

Tiempo de la consulta: 39.22 ms Después de la última consulta: 0.12 ms Consulta a la memoria: 0.017 MB memoria antes de la consulta: 14.845 MB

UPDATE y5cym_content

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

  WHERE `id` = '55'

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	UPDATE	y5cym_content	NULL	range	PRIMARY	PRIMARY	4	const	1	100.00	Using where

Perfil

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
updating	0.0 ms
end	0.0 ms
query end	39.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	0.0 ms

Llamada de pila

JROOT/libraries/joomla/table/table.php:1215

JROOT/components/com_content/models/article.php:265

JROOT/components/com_content/views/article/view.html.php:169

JROOT/libraries/joomla/cache/controller/view.php:98

JROOT/libraries/legacy/controller/legacy.php:681

JROOT/components/com_content/controller.php:79

JROOT/libraries/legacy/controller/legacy.php:722

JROOT/components/com_content/content.php:16

JROOT/libraries/cms/component/helper.php:352

JROOT/libraries/cms/component/helper.php:332

JROOT/libraries/cms/application/site.php:178

JROOT/libraries/cms/application/site.php:208

JROOT/libraries/cms/application/cms.php:255

JROOT/index.php:40

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

Tiempo de la consulta: 139.62 ms Después de la última consulta: 1126.60 ms Consulta a la memoria: 0.003 MB memoria antes de la consulta: 17.025 MB

UPDATE `y5cym_session`

  SET `data` = '__default|a:9:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1643139561;s:18:\"session.timer.last\";i:1643139561;s:17:\"session.timer.now\";i:1643139561;s:24:\"session.client.forwarded\";s:10:\"3.87.33.97\";s:22:\"session.client.browser\";s:40:\"CCBot/2.0 (https://commoncrawl.org/faq/)\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":24:{s:9:\"\\0\\0\\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:1:{i:0;s:1:\"1\";}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:10:\"\\0\\0\\0_params\";O:9:\"JRegistry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:14:\"\\0\\0\\0_authGroups\";a:1:{i:0;i:1;}s:14:\"\\0\\0\\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\\0\\0\\0_authActions\";N;s:12:\"\\0\\0\\0_errorMsg\";N;s:10:\"\\0\\0\\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:13:\"session.token\";s:32:\"eeb5c27c017cecdbe7100a103db4ed53\";}'
	, `time` = '1643139562'

  WHERE `session_id` = '1lmg0tte26bq8n04ahgeasa501'

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	UPDATE	y5cym_session	NULL	range	PRIMARY	PRIMARY	602	const	1	100.00	Using where

Perfil

Status	Duration
starting	0.1 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
updating	0.1 ms
end	0.0 ms
query end	139.2 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	0.0 ms

Llamada de pila

JROOT/libraries/joomla/session/storage/database.php:85

[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:

3 × SELECT `m`.`tag_id`,`t`.* 
  FROM `y5cym_contentitem_tag_map` AS m  
  INNER JOIN `y5cym_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

```
2 × SELECT * 
  FROM y5cym_extensions
```

2 × SELECT template 
  FROM y5cym_template_styles as s

2 × SELECT title 
  FROM y5cym_categories

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 y5cym_categories as c 
  LEFT JOIN y5cym_categories AS s 
  ON (s.lft <= c.lft 
  AND s.rgt >= c.rgt) OR (s.lft > c.lft 
  AND s.rgt < c.rgt) 
  LEFT JOIN  (SELECT cat.id as id 
  FROM y5cym_categories AS cat JOIN y5cym_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt

2 × SELECT alias 
  FROM y5cym_content

2 × SELECT `extension_id` 
  FROM `y5cym_extensions`

1 × SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN 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, LENGTH(a.fulltext) AS readmore,
  CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
  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,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published, 
  CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published 
  FROM y5cym_content AS a 
  LEFT JOIN y5cym_content_frontpage AS fp 
  ON fp.content_id = a.id 
  LEFT JOIN y5cym_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN y5cym_users AS ua 
  ON ua.id = a.created_by 
  LEFT JOIN y5cym_users AS uam 
  ON uam.id = a.modified_by 
  LEFT JOIN y5cym_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN y5cym_content_rating AS v 
  ON a.id = v.content_id 
  LEFT 
  OUTER JOIN (SELECT cat.id as id 
  FROM y5cym_categories AS cat JOIN y5cym_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt

```
1 × SELECT * 
  FROM y5cym_content
```

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

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

1 × SELECT a.rules 
  FROM y5cym_assets AS a

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

1 × SELECT `session_id` 
  FROM `y5cym_session`

1 × SELECT id, rules 
  FROM `y5cym_viewlevels

1 × SELECT extension, file, type 
  FROM y5cym_rokcommon_configs

1 × SELECT `data` 
  FROM `y5cym_session`

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

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

OTRAS tablas:

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

1 × UPDATE `y5cym_session` 
  SET `data` = '__default|a:9:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1643139561;s:18:\"session.timer.last\";i:1643139561;s:17:\"session.timer.now\";i:1643139561;s:24:\"session.client.forwarded\";s:10:\"3.87.33.97\";s:22:\"session.client.browser\";s:40:\"CCBot/2.0 (https://commoncrawl.org/faq/)\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":24:{s:9:\"\\0\\0\\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:1:{i:0;s:1:\"1\";}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:10:\"\\0\\0\\0_params\";O:9:\"JRegistry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:14:\"\\0\\0\\0_authGroups\";a:1:{i:0;i:1;}s:14:\"\\0\\0\\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\\0\\0\\0_authActions\";N;s:12:\"\\0\\0\\0_errorMsg\";N;s:10:\"\\0\\0\\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:13:\"session.token\";s:32:\"eeb5c27c017cecdbe7100a103db4ed53\";}'  , `time` = '1643139562'

1 × SHOW FULL COLUMNS 
  FROM `y5cym_content

1 × SHOW FULL COLUMNS 
  FROM `y5cym_extensions

1 × INSERT INTO `y5cym_session` (`session_id`, `client_id`, `time`) 
  VALUES  ('1lmg0tte26bq8n04ahgeasa501', 0, '1643139561'

1 × UPDATE `y5cym_extensions` 
  SET `params` = '{\"mediaversion\":\"0d1f715fd2ec803903e2e7af300ef776\"}'

```
1 × DELETE  
  FROM `y5cym_session`
```

Control interno de gestión

Ciudadano

Contador visitas

Dirección

Ubicacion Maps

Sobre nosotros

Siguenos en Redes Sociales

Notificaciones Judiciales

Consola de depuración de Joomla!

Sesión

__default

Información del perfil

Fecha y hora

Memoria

Uso de la memoria

Consultas de la base de datos

34 consultas registradas 306.8 ms

¡ 6 duplicaciones detectadas!

26 tipo de consultas registradas, ordenadas por la ocurrencia

Tablas SELECCIONADAS:

OTRAS tablas: