Hay virus que matan

Publicado: 08 Agosto 2012 | Escrito por Alberto Mazor

Las consecuencias de una guerra cibernética entre Israel e Irán, y en general, podrían ser tan destructivas como las de una misma guerra nuclear, advirtieron científicos en un artículo publicado en el Boletín de Científicos Atómicos de la Agencia Internacional de Energía Atómica (AIEA).

Especialistas afirmaron que entre una bomba atómica y una ciberarma hay mucho en común. Así, por ejemplo, señalaron que cuando EE.UU lanzó las bombas atómicas a Hirosima y Nagasaki en 1945 no sabía cuántas víctimas mortales provocarían a largo plazo.

«Aunque los programas dañinos no necesariamente causarían el mismo efecto que las bombas de Hiroshima y Nagasaki, el caos provocado, por ejemplo, por el colapso mundial del tráfico aéreo, el estancamiento de las centrales eléctricas o de los mercados financieros, sí que provocarían numerosos daños e incluso podrían causar muertes», señaló un veterano científico israelí en el boletín.

El mundo ya conoce los nombres de las primeras armas cibernéticas aplicadas contra las instalaciones nucleares iraníes. Son el virus «Stuxnet», que atacó a la planta de enriquecimiento de uranio en Natanz en 2010, y «Flame», un programa espía descubierto recientemente.

Los expertos señalan que estos programas maliciosos podrían haber sido elaborados por especialistas estadounidenses e israelíes. Y a pesar de que ambos países nunca reconocieron la autoría de estos virus, sí confirma que se están elaborando tecnologías cibernéticas ofensivas.

Ante el inminente peligro, los especialistas apuntan que, al igual que en el caso de loss armamentos nucleares, es necesario instituir normas legales aprobadas a nivel internacional que reglamenten y limiten el uso de armas cibernéticas.

No obstante, como siempre los políticos hacen caso omiso a estas advertencias.

Desgraciadamente, habrá que esperar que sean otra vez los desastres quienes determinen las pautas y las normativas. Y como siempre, sera demasiado tarde.

· Más leídos ·

Consola de depuración de Joomla!

Sesión

Información del perfil

Uso de la memoria

Consultas de la base de datos

28 consultas registradas 17.9 ms

Tiempo de la consulta: 0.23 ms Consulta a la memoria: 0.015 MB memoria antes de la consulta: 0.825 MB Filas devueltas: 0

SELECT `data`

  FROM `gzm4h_session`

  WHERE `session_id` = 'lbbfdbm0drenimcodnqeii6tv4'

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	gzm4h_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.1 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:44

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

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

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

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

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

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

JROOT/libraries/joomla/factory.php:125

JROOT/index.php:42

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

Tiempo de la consulta: 0.95 ms Después de la última consulta: 0.94 ms Consulta a la memoria: 0.008 MB memoria antes de la consulta: 0.879 MB

DELETE 

  FROM `gzm4h_session`

  WHERE `time` < '1732376225'

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	DELETE	gzm4h_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:756

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

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

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

JROOT/libraries/joomla/factory.php:125

JROOT/index.php:42

[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.13 ms Consulta a la memoria: 0.012 MB memoria antes de la consulta: 0.891 MB Filas devueltas: 0

SELECT `session_id`

  FROM `gzm4h_session`

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

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	gzm4h_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:176

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

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

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

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

JROOT/libraries/joomla/factory.php:125

JROOT/index.php:42

[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: 0.09 ms Consulta a la memoria: 0.009 MB memoria antes de la consulta: 0.903 MB

INSERT INTO `gzm4h_session`
(`session_id`, `client_id`, `time`) 
  VALUES 
('lbbfdbm0drenimcodnqeii6tv4', 0, '1732377125')

Explicar

'Explicar' no es posible en la consulta: INSERT INTO `gzm4h_session` (`session_id`, `client_id`, `time`) VALUES ('lbbfdbm0drenimcodnqeii6tv4', 0, '1732377125')

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.1 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:208

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

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

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

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

JROOT/libraries/joomla/factory.php:125

JROOT/index.php:42

[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.16 ms Después de la última consulta: 0.75 ms Consulta a la memoria: 0.018 MB memoria antes de la consulta: 0.981 MB Filas devueltas: 33

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

  FROM gzm4h_extensions

  WHERE `type` = 'component'

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	gzm4h_extensions	NULL	ref	extension	extension	62	const	33	100.00	NULL

Perfil

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
Opening tables	0.9 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.1 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/cache/controller/callback.php:157

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

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

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

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

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

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

JROOT/index.php:45

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

Tiempo de la consulta: 0.28 ms Después de la última consulta: 0.58 ms Consulta a la memoria: 0.014 MB memoria antes de la consulta: 1.040 MB Filas devueltas: 2

SELECT b.id

  FROM gzm4h_usergroups AS a

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

  WHERE a.id = 9

Explicar

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

Perfil

Status	Duration
starting	0.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.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/access/access.php:332

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

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

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

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

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

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

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

JROOT/index.php:45

[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.18 ms Consulta a la memoria: 0.013 MB memoria antes de la consulta: 1.059 MB Filas devueltas: 5

SELECT id, rules

  FROM `gzm4h_viewlevels`

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	gzm4h_viewlevels	NULL	ALL	NULL	No pudo usarse una clave de índice	NULL	NULL	5	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:418

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

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

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

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

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

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

JROOT/index.php:45

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

Tiempo de la consulta: 0.42 ms Después de la última consulta: 0.15 ms Consulta a la memoria: 0.013 MB memoria antes de la consulta: 1.078 MB Filas devueltas: 52

SELECT folder AS type, element AS name, params

  FROM gzm4h_extensions

  WHERE enabled = 1 
  AND type ='plugin' 
  AND state IN (0,1) 
  AND access IN (1,1,5)

  ORDER BY ordering

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	gzm4h_extensions	NULL	ref	extension	extension	62	const	68	0.60	Using index condition; Using where; 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.2 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/plugin/helper.php:310

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

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

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

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

JROOT/index.php:45

[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.62 ms Después de la última consulta: 8.15 ms Consulta a la memoria: 0.028 MB memoria antes de la consulta: 1.598 MB Filas devueltas: 28

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

  LEFT JOIN gzm4h_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	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	59	3.33	Using index condition; Using where; Usando 'filesort'
1	SIMPLE	e	NULL	eq_ref	PRIMARY	PRIMARY	4	tryit_tumeser1_new.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.1 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.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:45

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

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

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

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

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

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

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

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

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

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

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

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

JROOT/index.php:45

[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.59 ms Después de la última consulta: 2.44 ms Consulta a la memoria: 0.024 MB memoria antes de la consulta: 2.012 MB Filas devueltas: 0

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 gzm4h_categories as c

  LEFT JOIN gzm4h_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 gzm4h_categories AS cat JOIN gzm4h_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,5) 
  AND c.published = 1 
  AND s.id=1185 
  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	NULL	NULL	NULL	NULL	No pudo usarse una clave de índice	NULL	NULL	NULL	NULL	no matching row in const table
2	DERIVED	parent	NULL	range	cat_idx,idx_left_right	cat_idx	153	NULL	5	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	37	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.1 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.0 ms
executing	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/categories/categories.php:292

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

JROOT/components/com_content/router.php:324

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

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

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

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

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

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

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

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

JROOT/index.php:45

[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: 0.09 ms Consulta a la memoria: 0.015 MB memoria antes de la consulta: 2.025 MB Filas devueltas: 1

SELECT `alias`,`catid`

  FROM `gzm4h_content`

  WHERE `id` = 1185

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	gzm4h_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.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
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:340

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

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

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

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

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

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

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

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

JROOT/index.php:45

[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: 0.26 ms Consulta a la memoria: 0.024 MB memoria antes de la consulta: 2.060 MB Filas devueltas: 1

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

  FROM gzm4h_extensions

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

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	gzm4h_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	extension	364	const,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/cache/controller/callback.php:157

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

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

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

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

JROOT/libraries/joomla/factory.php:736

JROOT/libraries/joomla/factory.php:216

JROOT/plugins/system/sef/sef.php:29

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

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

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

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

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

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

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

JROOT/index.php:45

[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.20 ms Consulta a la memoria: 0.017 MB memoria antes de la consulta: 2.067 MB

UPDATE `gzm4h_extensions`

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

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

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	UPDATE	gzm4h_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	0.0 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:240

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

JROOT/libraries/joomla/factory.php:736

JROOT/libraries/joomla/factory.php:216

JROOT/plugins/system/sef/sef.php:29

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

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

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

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

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

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

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

JROOT/index.php:45

[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.55 ms Consulta a la memoria: 0.022 MB memoria antes de la consulta: 2.150 MB Filas devueltas: 1

SELECT alias

  FROM gzm4h_content

  WHERE id=1185

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	gzm4h_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:112

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

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

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

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

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

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

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

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

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

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

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

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

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

JROOT/index.php:45

[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.01 ms Después de la última consulta: 0.14 ms Consulta a la memoria: 0.031 MB memoria antes de la consulta: 2.179 MB Filas devueltas: 3

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

  FROM gzm4h_categories as c

  LEFT JOIN gzm4h_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 gzm4h_categories AS cat JOIN gzm4h_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,5) 
  AND c.published = 1 
  AND s.id=65 
  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	37	33.03	Using where
1	PRIMARY	<derived2>	NULL	ref	<auto_key0>	<auto_key0>	4	tryit_tumeser1_new.c.id	2	100.00	Using where; Not exists; Using index
2	DERIVED	parent	NULL	range	cat_idx,idx_left_right	cat_idx	153	NULL	5	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	37	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.1 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:292

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

JROOT/components/com_content/router.php:145

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

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

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

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

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

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

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

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

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

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

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

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

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

JROOT/index.php:45

[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.60 ms Consulta a la memoria: 0.014 MB memoria antes de la consulta: 2.237 MB Filas devueltas: 1

SELECT *

  FROM gzm4h_languages

  WHERE published=1

  ORDER BY ordering ASC

Explicar

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

Perfil

Status	Duration
starting	0.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
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/libraries/joomla/language/helper.php:164

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

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

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

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

JROOT/index.php:45

[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.30 ms Después de la última consulta: 0.43 ms Consulta a la memoria: 0.010 MB memoria antes de la consulta: 2.259 MB Filas devueltas: 3

SELECT id, home, template, s.params

  FROM gzm4h_template_styles as s

  LEFT JOIN gzm4h_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id

  WHERE s.client_id = 0 
  AND e.enabled = 1

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	NULL	ALL	idx_template	No pudo usarse una clave de índice	NULL	NULL	5	20.00	Using where
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	303	tryit_tumeser1_new.s.template,const	1	4.67	Using index condition; 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/application/site.php:484

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

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

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

JROOT/index.php:45

[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: 3.11 ms Consulta a la memoria: 0.024 MB memoria antes de la consulta: 2.480 MB Filas devueltas: 1

SELECT a.rules

  FROM gzm4h_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:246

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

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

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

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

JROOT/libraries/legacy/view/legacy.php:401

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

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

JROOT/components/com_content/controller.php:104

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

JROOT/components/com_content/content.php:16

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

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

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

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

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

JROOT/index.php:45

[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.36 ms Después de la última consulta: 0.31 ms Consulta a la memoria: 0.025 MB memoria antes de la consulta: 2.513 MB Filas devueltas: 2

SELECT b.rules

  FROM gzm4h_assets AS a

  LEFT JOIN gzm4h_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	14	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.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:246

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

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

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

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

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

JROOT/libraries/legacy/view/legacy.php:401

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

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

JROOT/components/com_content/controller.php:104

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

JROOT/components/com_content/content.php:16

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

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

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

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

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

JROOT/index.php:45

[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.69 ms Después de la última consulta: 0.33 ms Consulta a la memoria: 0.031 MB memoria antes de la consulta: 2.550 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 gzm4h_content AS a

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

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

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

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

  LEFT 
  OUTER JOIN  (SELECT cat.id as id 
  FROM gzm4h_categories AS cat JOIN gzm4h_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 = 1185 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-11-23 15:52:05') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-11-23 15:52:05') 
  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	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	37	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.1 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:159

JROOT/libraries/legacy/view/legacy.php:401

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

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

JROOT/components/com_content/controller.php:104

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

JROOT/components/com_content/content.php:16

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

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

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

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

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

JROOT/index.php:45

[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.32 ms Después de la última consulta: 1.52 ms Consulta a la memoria: 0.024 MB memoria antes de la consulta: 2.664 MB Filas devueltas: 0

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

  FROM `gzm4h_contentitem_tag_map` AS m 

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

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

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ALL	idx_tag_type,idx_tag	No pudo usarse una clave de índice	NULL	NULL	1	100.00	Using where
1	SIMPLE	t	NULL	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	tryit_tumeser1_new.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.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
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:426

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

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

JROOT/components/com_content/controller.php:104

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

JROOT/components/com_content/content.php:16

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

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

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

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

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

JROOT/index.php:45

[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: 2.14 ms Consulta a la memoria: 0.028 MB memoria antes de la consulta: 2.780 MB Filas devueltas: 30

SHOW FULL COLUMNS 
  FROM `gzm4h_content`

Explicar

'Explicar' no es posible en la consulta: SHOW FULL COLUMNS FROM `gzm4h_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:241

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

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

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

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

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

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

JROOT/components/com_content/controller.php:104

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

JROOT/components/com_content/content.php:16

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

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

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

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

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

JROOT/index.php:45

[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.04 ms Consulta a la memoria: 0.026 MB memoria antes de la consulta: 2.909 MB Filas devueltas: 1

SELECT *

  FROM gzm4h_content

  WHERE `id` = '1185'

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	gzm4h_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:728

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

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

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

JROOT/components/com_content/controller.php:104

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

JROOT/components/com_content/content.php:16

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

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

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

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

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

JROOT/index.php:45

[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.17 ms Consulta a la memoria: 0.016 MB memoria antes de la consulta: 2.927 MB

UPDATE gzm4h_content

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

  WHERE `id` = '1185'

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	UPDATE	gzm4h_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	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:1239

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

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

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

JROOT/components/com_content/controller.php:104

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

JROOT/components/com_content/content.php:16

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

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

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

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

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

JROOT/index.php:45

[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.73 ms Después de la última consulta: 4.93 ms Consulta a la memoria: 0.021 MB memoria antes de la consulta: 3.181 MB Filas devueltas: 4

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

  FROM gzm4h_modules AS m

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

  LEFT JOIN gzm4h_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 <= '2024-11-23 15:52:05') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-11-23 15:52:05') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 84 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	ref	PRIMARY,published,newsfeeds	published	1	const	14	3.57	Using index condition; Using where; Usando 'filesort'
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid	element_clientid	303	tryit_tumeser1_new.m.module,const	1	10.00	Using index condition; Using where
1	SIMPLE	mm	NULL	ref	PRIMARY	PRIMARY	4	tryit_tumeser1_new.m.id	1	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.1 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.2 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:408

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

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

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

JROOT/templates/plantilla_tumeser_01/library/Artx/Page.php:46

JROOT/templates/plantilla_tumeser_01/index.php:83

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

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

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

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

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

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

JROOT/index.php:45

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

Tiempo de la consulta: 7.02 ms Después de la última consulta: 3.80 ms Consulta a la memoria: 0.031 MB memoria antes de la consulta: 3.343 MB Filas devueltas: 0

SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language,  LENGTH(a.fulltext) AS readmore,
  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 gzm4h_content AS a

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

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

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

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

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

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

  LEFT 
  OUTER JOIN (SELECT cat.id as id 
  FROM gzm4h_categories AS cat JOIN gzm4h_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 
  CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-11-23 15:52:05') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-11-23 15:52:05') 
  AND a.created >= DATE_SUB('2024-11-23 15:52:05', INTERVAL 30 DAY)

  ORDER BY a.hits DESC 
  LIMIT 0, 10

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	a	NULL	ALL	NULL	No pudo usarse una clave de índice	NULL	NULL	1374	5.33	Using where; Using temporary; Usando 'filesort'
1	PRIMARY	fp	NULL	eq_ref	PRIMARY	PRIMARY	4	tryit_tumeser1_new.a.id	1	100.00	Using where; Using index
1	PRIMARY	c	NULL	eq_ref	PRIMARY	PRIMARY	4	tryit_tumeser1_new.a.catid	1	100.00	Using where
1	PRIMARY	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	tryit_tumeser1_new.a.created_by	1	100.00	Using where
1	PRIMARY	uam	NULL	eq_ref	PRIMARY	PRIMARY	4	tryit_tumeser1_new.a.modified_by	1	100.00	Using where
1	PRIMARY	parent	NULL	eq_ref	PRIMARY	PRIMARY	4	tryit_tumeser1_new.c.parent_id	1	100.00	Using where
1	PRIMARY	v	NULL	ALL	PRIMARY	No pudo usarse una clave de índice	NULL	NULL	1	100.00	Using where; Using join buffer (Block Nested Loop)
1	PRIMARY	<derived2>	NULL	ref	<auto_key0>	<auto_key0>	4	tryit_tumeser1_new.c.id	2	100.00	Using where; Using index
2	DERIVED	parent	NULL	range	cat_idx,idx_left_right	cat_idx	153	NULL	5	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	37	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
checking permissions	0.0 ms
checking permissions	0.0 ms
Opening tables	0.1 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.0 ms
preparing	0.0 ms
Creating tmp table	0.1 ms
Sorting result	0.0 ms
executing	0.0 ms
Sending data	6.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/model/legacy.php:304

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

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

JROOT/modules/mod_articles_popular/helper.php:76

JROOT/modules/mod_articles_popular/mod_articles_popular.php:15

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

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

JROOT/libraries/joomla/document/html/renderer/modules.php:43

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

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

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

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

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

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

JROOT/index.php:45

[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.32 ms Después de la última consulta: 9.56 ms Consulta a la memoria: 0.019 MB memoria antes de la consulta: 3.768 MB Filas devueltas: 84

SELECT * 
  FROM gzm4h_acymailing_config

Explicar

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

Perfil

Status	Duration
starting	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
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/administrator/components/com_acymailing/classes/cpanel.php:17

JROOT/administrator/components/com_acymailing/helpers/helper.php:451

JROOT/administrator/components/com_acymailing/helpers/helper.php:958

JROOT/plugins/system/regacymailing/regacymailing.php:140

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

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

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

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

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

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

JROOT/index.php:45

[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.30 ms Después de la última consulta: 1.58 ms Consulta a la memoria: 0.003 MB memoria antes de la consulta: 3.889 MB

UPDATE `gzm4h_session`

  SET `data` = '__default|a:8:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1732377125;s:18:\"session.timer.last\";i:1732377125;s:17:\"session.timer.now\";i:1732377125;s:24:\"session.client.forwarded\";s:13:\"13.58.188.166\";s:22:\"session.client.browser\";s:103:\"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)\";s:8:\"registry\";O:24:\"Joomla\\Registry\\Registry\":2:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}s:9:\"separator\";s:1:\".\";}s:4:\"user\";O:5:\"JUser\":26:{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:\"9\";}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:12:\"requireReset\";N;s:10:\"\\0\\0\\0_params\";O:24:\"Joomla\\Registry\\Registry\":2:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}s:9:\"separator\";s:1:\".\";}s:14:\"\\0\\0\\0_authGroups\";a:2:{i:0;i:1;i:1;i:9;}s:14:\"\\0\\0\\0_authLevels\";a:3:{i:0;i:1;i:1;i:1;i:2;i:5;}s:15:\"\\0\\0\\0_authActions\";N;s:12:\"\\0\\0\\0_errorMsg\";N;s:13:\"\\0\\0\\0userHelper\";O:18:\"JUserWrapperHelper\":0:{}s:10:\"\\0\\0\\0_errors\";a:0:{}s:3:\"aid\";i:0;}}'
	, `time` = '1732377125'

  WHERE `session_id` = 'lbbfdbm0drenimcodnqeii6tv4'

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	UPDATE	gzm4h_session	NULL	range	PRIMARY	PRIMARY	602	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.1 ms
end	0.0 ms
query end	0.1 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:84

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

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 gzm4h_categories as c 
  LEFT JOIN gzm4h_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 gzm4h_categories AS cat JOIN gzm4h_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt

2 × SELECT extension_id AS id, element AS "option", params, enabled 
  FROM gzm4h_extensions

1 × SELECT a.rules 
  FROM gzm4h_assets AS a

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 gzm4h_content AS a 
  LEFT JOIN gzm4h_categories AS c 
  on c.id = a.catid 
  LEFT JOIN gzm4h_users AS u 
  on u.id = a.created_by 
  LEFT JOIN gzm4h_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN gzm4h_content_rating AS v 
  ON a.id = v.content_id 
  LEFT 
  OUTER JOIN  (SELECT cat.id as id 
  FROM gzm4h_categories AS cat JOIN gzm4h_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt

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

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

```
1 × SELECT * 
  FROM gzm4h_content
```

1 × SELECT * 
  FROM gzm4h_acymailing_confi

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, a.language,  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 gzm4h_content AS a 
  LEFT JOIN gzm4h_content_frontpage AS fp 
  ON fp.content_id = a.id 
  LEFT JOIN gzm4h_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN gzm4h_users AS ua 
  ON ua.id = a.created_by 
  LEFT JOIN gzm4h_users AS uam 
  ON uam.id = a.modified_by 
  LEFT JOIN gzm4h_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN gzm4h_content_rating AS v 
  ON a.id = v.content_id 
  LEFT 
  OUTER JOIN (SELECT cat.id as id 
  FROM gzm4h_categories AS cat JOIN gzm4h_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 gzm4h_modules AS m 
  LEFT JOIN gzm4h_modules_menu AS mm 
  ON mm.moduleid = m.id 
  LEFT JOIN gzm4h_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

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

1 × SELECT alias 
  FROM gzm4h_content

1 × SELECT id, rules 
  FROM `gzm4h_viewlevels

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

1 × SELECT `session_id` 
  FROM `gzm4h_session`

1 × SELECT folder AS type, element AS name, params 
  FROM gzm4h_extensions

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 gzm4h_menu AS m 
  LEFT JOIN gzm4h_extensions AS e 
  ON m.component_id = e.extension_id

1 × SELECT `data` 
  FROM `gzm4h_session`

1 × SELECT `alias`,`catid` 
  FROM `gzm4h_content`

```
1 × SELECT * 
  FROM gzm4h_languages
```

OTRAS tablas:

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

1 × UPDATE `gzm4h_session` 
  SET `data` = '__default|a:8:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1732377125;s:18:\"session.timer.last\";i:1732377125;s:17:\"session.timer.now\";i:1732377125;s:24:\"session.client.forwarded\";s:13:\"13.58.188.166\";s:22:\"session.client.browser\";s:103:\"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)\";s:8:\"registry\";O:24:\"Joomla\\Registry\\Registry\":2:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}s:9:\"separator\";s:1:\".\";}s:4:\"user\";O:5:\"JUser\":26:{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:\"9\";}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:12:\"requireReset\";N;s:10:\"\\0\\0\\0_params\";O:24:\"Joomla\\Registry\\Registry\":2:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}s:9:\"separator\";s:1:\".\";}s:14:\"\\0\\0\\0_authGroups\";a:2:{i:0;i:1;i:1;i:9;}s:14:\"\\0\\0\\0_authLevels\";a:3:{i:0;i:1;i:1;i:1;i:2;i:5;}s:15:\"\\0\\0\\0_authActions\";N;s:12:\"\\0\\0\\0_errorMsg\";N;s:13:\"\\0\\0\\0userHelper\";O:18:\"JUserWrapperHelper\":0:{}s:10:\"\\0\\0\\0_errors\";a:0:{}s:3:\"aid\";i:0;}}'  , `time` = '1732377125'

1 × SHOW FULL COLUMNS 
  FROM `gzm4h_content

1 × UPDATE `gzm4h_extensions` 
  SET `params` = '{\"mediaversion\":\"ddb44c60f65787601bd29ffea3c18a92\"}'

1 × INSERT INTO `gzm4h_session` (`session_id`, `client_id`, `time`) 
  VALUES  ('lbbfdbm0drenimcodnqeii6tv4', 0, '1732377125'

```
1 × DELETE  
  FROM `gzm4h_session`
```

Hay virus que matan

· Más leídos ·

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

28 consultas registradas 17.9 ms

26 tipo de consultas registradas, ordenadas por la ocurrencia

Tablas SELECCIONADAS:

OTRAS tablas: