UEN CALAMAR GUAVIARE

Nuestra Unidad Estratégica de Negocios (UEN) del municipio de Calamar, presta los servicios de promoción de la salud y prevención
de la enfermedad a través del HOSPITAL MARIA CRISTINA COBO MAHECHA, ubicado en el perímetro urbano del municipio.

Él HOSPITAL MARIA CRISTINA COBO MAHECHA Presta servicios como:

Medicina General
Odontología
Enfermería
Servicio farmacéutico y procedimientos menores
Consulta externa
Urgencias
Transporte Asistencial Básico
Tamización de Cáncer de Cuello Uterino
Hospitalización
Sala de partos y procedimientos menores

Así mismo se presta el servicio de atención primario en salud en la zona rural del municipio a través de 3 Micropuestos de salud ubicados en (La Unión – Las Damas y La Ceiba), dos de ellos cuentan con vías de acceso terrestre y el Micropuesto de La Unión está ubicado a 5 horas de la cabecera municipal y se llega solo por vía fluvial.

687733

	Hoy	65
	Ayer	94
	Esta semana	179
	Este mes	2354
	Total dias	687733

DEBUG
Time:[0.090289831161499sec]

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

25 consultas registradas 1842.6 ms

¡ 4 duplicaciones detectadas!

2 duplicaciones: #6 #7

2 duplicaciones: #13 #15

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` = 'cu976d24uid9bnmv607gvdfn03'

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

SELECT `session_id`

  FROM `y5cym_session`

  WHERE `session_id` = 'cu976d24uid9bnmv607gvdfn03' 
  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: 1284.69 ms Después de la última consulta: 0.08 ms Consulta a la memoria: 0.009 MB memoria antes de la consulta: 2.855 MB

INSERT INTO `y5cym_session`
(`session_id`, `client_id`, `time`) 
  VALUES 
('cu976d24uid9bnmv607gvdfn03', 0, '1643142620')

Explicar

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

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	1284.5 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.17 ms Después de la última consulta: 6.20 ms Consulta a la memoria: 0.014 MB memoria antes de la consulta: 3.362 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.11 ms Después de la última consulta: 0.35 ms Consulta a la memoria: 0.013 MB memoria antes de la consulta: 3.429 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.14 ms Después de la última consulta: 11.09 ms Consulta a la memoria: 0.019 MB memoria antes de la consulta: 5.165 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: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.11 ms Después de la última consulta: 0.07 ms Consulta a la memoria: 0.020 MB memoria antes de la consulta: 5.184 MB Filas devueltas: 1

Consultas duplicadas: #6

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.14 ms Después de la última consulta: 3.00 ms Consulta a la memoria: 0.015 MB memoria antes de la consulta: 5.526 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: 375.44 ms Después de la última consulta: 8.72 ms Consulta a la memoria: 0.020 MB memoria antes de la consulta: 7.062 MB

UPDATE `y5cym_extensions`

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

  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	375.1 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: 3.08 ms Después de la última consulta: 5.47 ms Consulta a la memoria: 0.045 MB memoria antes de la consulta: 7.372 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.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	2.3 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.54 ms Después de la última consulta: 19.98 ms Consulta a la memoria: 0.024 MB memoria antes de la consulta: 9.284 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.0 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.25 ms Después de la última consulta: 0.54 ms Consulta a la memoria: 0.016 MB memoria antes de la consulta: 9.359 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.15 ms Consulta a la memoria: 0.020 MB memoria antes de la consulta: 9.377 MB Filas devueltas: 1

Consultas duplicadas: #15

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.19 ms Después de la última consulta: 0.14 ms Consulta a la memoria: 0.016 MB memoria antes de la consulta: 9.392 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.18 ms Después de la última consulta: 0.13 ms Consulta a la memoria: 0.020 MB memoria antes de la consulta: 9.408 MB Filas devueltas: 1

Consultas duplicadas: #13

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.20 ms Después de la última consulta: 27.58 ms Consulta a la memoria: 0.025 MB memoria antes de la consulta: 11.857 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.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: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.24 ms Después de la última consulta: 0.46 ms Consulta a la memoria: 0.026 MB memoria antes de la consulta: 11.918 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.0 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
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.49 ms Después de la última consulta: 0.36 ms Consulta a la memoria: 0.032 MB memoria antes de la consulta: 11.967 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 = 70 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2022-01-25 20:30:22') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2022-01-25 20:30:22') 
  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.0 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: 0.72 ms Después de la última consulta: 1.40 ms Consulta a la memoria: 0.028 MB memoria antes de la consulta: 12.210 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=33 
  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.0 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.21 ms Después de la última consulta: 1.60 ms Consulta a la memoria: 0.025 MB memoria antes de la consulta: 12.460 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` = 70 
  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: 0.55 ms Después de la última consulta: 9.73 ms Consulta a la memoria: 0.029 MB memoria antes de la consulta: 13.819 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.19 ms Después de la última consulta: 1.10 ms Consulta a la memoria: 0.027 MB memoria antes de la consulta: 14.004 MB Filas devueltas: 1

SELECT *

  FROM y5cym_content

  WHERE `id` = '70'

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: 81.90 ms Después de la última consulta: 0.15 ms Consulta a la memoria: 0.017 MB memoria antes de la consulta: 14.023 MB

UPDATE y5cym_content

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

  WHERE `id` = '70'

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	81.7 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: 0.85 ms Después de la última consulta: 32.21 ms Consulta a la memoria: 0.024 MB memoria antes de la consulta: 15.756 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 20:30:22') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2022-01-25 20:30:22') 
  AND m.access IN (1,1) 
  AND m.client_id = 0 
  AND (mm.menuid = 243 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.0 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.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/module/helper.php:376

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

JROOT/libraries/joomla/document/html/html.php:502

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

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

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

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

JROOT/templates/theme-org/index.php:49

JROOT/libraries/joomla/document/html/html.php:570

JROOT/libraries/joomla/document/html/html.php:628

JROOT/libraries/joomla/document/html/html.php:452

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

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

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

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: 91.83 ms Después de la última consulta: 44.33 ms Consulta a la memoria: 0.003 MB memoria antes de la consulta: 16.399 MB

UPDATE `y5cym_session`

  SET `data` = '__default|a:9:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1643142620;s:18:\"session.timer.last\";i:1643142620;s:17:\"session.timer.now\";i:1643142620;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:\"3a5bc29c62945bf4f640ffbc6a2ba9d1\";}'
	, `time` = '1643142622'

  WHERE `session_id` = 'cu976d24uid9bnmv607gvdfn03'

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	91.5 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.]

22 tipo de consultas registradas, ordenadas por la ocurrencia

Tablas SELECCIONADAS:

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

2 × SELECT template 
  FROM y5cym_template_styles as s

2 × SELECT `extension_id` 
  FROM `y5cym_extensions`

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

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`.`tag_id`,`t`.* 
  FROM `y5cym_contentitem_tag_map` AS m  
  INNER JOIN `y5cym_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

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

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 b.rules 
  FROM y5cym_assets AS a 
  LEFT JOIN y5cym_assets AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt

1 × SELECT a.rules 
  FROM y5cym_assets AS a

1 × SELECT extension, file, type 
  FROM y5cym_rokcommon_configs

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 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 `data` 
  FROM `y5cym_session`

1 × SELECT `session_id` 
  FROM `y5cym_session`

1 × SELECT id, rules 
  FROM `y5cym_viewlevels

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:1643142620;s:18:\"session.timer.last\";i:1643142620;s:17:\"session.timer.now\";i:1643142620;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:\"3a5bc29c62945bf4f640ffbc6a2ba9d1\";}'  , `time` = '1643142622'

1 × SHOW FULL COLUMNS 
  FROM `y5cym_content

1 × SHOW FULL COLUMNS 
  FROM `y5cym_extensions

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

1 × INSERT INTO `y5cym_session` (`session_id`, `client_id`, `time`) 
  VALUES  ('cu976d24uid9bnmv607gvdfn03', 0, '1643142620'

UEN CALAMAR GUAVIARE

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

25 consultas registradas 1842.6 ms

¡ 4 duplicaciones detectadas!

22 tipo de consultas registradas, ordenadas por la ocurrencia

Tablas SELECCIONADAS:

OTRAS tablas: