Consola de depuración de Joomla!

Fecha y hora

Memoria

28 consultas registradas 16.9 ms

1. Tiempo de la consulta: 0.34 ms Consulta a la memoria: 0.015 MB memoria antes de la consulta: 0.822 MB Filas devueltas: 0

   SELECT `data`
   
     FROM `gzm4h_session`
   
     WHERE `session_id` = '80ml52d2vd235rst14sdt6rkn4'

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

   ---

2. Tiempo de la consulta: 0.16 ms Después de la última consulta: 0.94 ms Consulta a la memoria: 0.008 MB memoria antes de la consulta: 0.877 MB

   DELETE 
   
     FROM `gzm4h_session`
   
     WHERE `time` < '1732368699'

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

   ---

3. Tiempo de la consulta: 0.11 ms Después de la última consulta: 0.09 ms Consulta a la memoria: 0.012 MB memoria antes de la consulta: 0.888 MB Filas devueltas: 0

   SELECT `session_id`
   
     FROM `gzm4h_session`
   
     WHERE `session_id` = '80ml52d2vd235rst14sdt6rkn4' 
     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.]

   ---

4. Tiempo de la consulta: 0.21 ms Después de la última consulta: 0.09 ms Consulta a la memoria: 0.009 MB memoria antes de la consulta: 0.901 MB

   INSERT INTO `gzm4h_session`
   (`session_id`, `client_id`, `time`) 
     VALUES 
   ('80ml52d2vd235rst14sdt6rkn4', 0, '1732369599')

   Explicar

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

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

   ---

5. Tiempo de la consulta: 0.42 ms Después de la última consulta: 0.73 ms Consulta a la memoria: 0.018 MB memoria antes de la consulta: 0.979 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.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.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.]

   ---

6. Tiempo de la consulta: 0.35 ms Después de la última consulta: 0.52 ms Consulta a la memoria: 0.014 MB memoria antes de la consulta: 1.037 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.]

   ---

7. Tiempo de la consulta: 0.21 ms Después de la última consulta: 0.15 ms Consulta a la memoria: 0.013 MB memoria antes de la consulta: 1.057 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.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/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.]

   ---

8. Tiempo de la consulta: 0.42 ms Después de la última consulta: 0.16 ms Consulta a la memoria: 0.013 MB memoria antes de la consulta: 1.076 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.]

   ---

9. Tiempo de la consulta: 0.68 ms Después de la última consulta: 6.94 ms Consulta a la memoria: 0.028 MB memoria antes de la consulta: 1.595 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.0 ms
   checking permissions	0.0 ms
   checking permissions	0.0 ms
   Opening tables	0.2 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.]

   ---

10. Tiempo de la consulta: 0.69 ms Después de la última consulta: 2.38 ms Consulta a la memoria: 0.024 MB memoria antes de la consulta: 2.009 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=1294 
      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.2 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
    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.]

    ---

11. Tiempo de la consulta: 0.30 ms Después de la última consulta: 0.09 ms Consulta a la memoria: 0.015 MB memoria antes de la consulta: 2.022 MB Filas devueltas: 1

    SELECT `alias`,`catid`
    
      FROM `gzm4h_content`
    
      WHERE `id` = 1294

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

    ---

12. Tiempo de la consulta: 0.18 ms Después de la última consulta: 0.27 ms Consulta a la memoria: 0.024 MB memoria antes de la consulta: 2.057 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.]

    ---

13. Tiempo de la consulta: 0.21 ms Después de la última consulta: 0.19 ms Consulta a la memoria: 0.017 MB memoria antes de la consulta: 2.065 MB

    UPDATE `gzm4h_extensions`
    
      SET `params` = '{\"mediaversion\":\"c910026467ff0666d048d65493cf7c28\"}'
    
      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.]

    ---

14. Tiempo de la consulta: 0.12 ms Después de la última consulta: 0.52 ms Consulta a la memoria: 0.022 MB memoria antes de la consulta: 2.147 MB Filas devueltas: 1

    SELECT alias
    
      FROM gzm4h_content
    
      WHERE id=1294

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

    ---

15. Tiempo de la consulta: 0.99 ms Después de la última consulta: 0.15 ms Consulta a la memoria: 0.031 MB memoria antes de la consulta: 2.176 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.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: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.]

    ---

16. Tiempo de la consulta: 0.31 ms Después de la última consulta: 0.60 ms Consulta a la memoria: 0.014 MB memoria antes de la consulta: 2.234 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.]

    ---

17. Tiempo de la consulta: 0.39 ms Después de la última consulta: 0.44 ms Consulta a la memoria: 0.010 MB memoria antes de la consulta: 2.256 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.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/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.]

    ---

18. Tiempo de la consulta: 0.27 ms Después de la última consulta: 2.74 ms Consulta a la memoria: 0.024 MB memoria antes de la consulta: 2.478 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.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/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.]

    ---

19. Tiempo de la consulta: 0.37 ms Después de la última consulta: 0.31 ms Consulta a la memoria: 0.025 MB memoria antes de la consulta: 2.510 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.]

    ---

20. Tiempo de la consulta: 0.79 ms Después de la última consulta: 0.29 ms Consulta a la memoria: 0.034 MB memoria antes de la consulta: 2.547 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 = 1294 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-11-23 13:46:39') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-11-23 13:46:39') 
      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.2 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.]

    ---

21. Tiempo de la consulta: 0.46 ms Después de la última consulta: 1.36 ms Consulta a la memoria: 0.024 MB memoria antes de la consulta: 2.667 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` = 1294 
      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.2 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/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.]

    ---

22. Tiempo de la consulta: 0.44 ms Después de la última consulta: 2.17 ms Consulta a la memoria: 0.028 MB memoria antes de la consulta: 2.784 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.]

    ---

23. Tiempo de la consulta: 0.18 ms Después de la última consulta: 0.92 ms Consulta a la memoria: 0.026 MB memoria antes de la consulta: 2.912 MB Filas devueltas: 1

    SELECT *
    
      FROM gzm4h_content
    
      WHERE `id` = '1294'

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

    ---

24. Tiempo de la consulta: 0.18 ms Después de la última consulta: 0.17 ms Consulta a la memoria: 0.016 MB memoria antes de la consulta: 2.933 MB

    UPDATE gzm4h_content
    
      SET `hits` = (`hits` + 1)
    
      WHERE `id` = '1294'

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

    ---

25. Tiempo de la consulta: 0.68 ms Después de la última consulta: 4.33 ms Consulta a la memoria: 0.021 MB memoria antes de la consulta: 3.193 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 13:46:39') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-11-23 13:46:39') 
      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.2 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/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.]

    ---

26. Tiempo de la consulta: 6.74 ms Después de la última consulta: 3.11 ms Consulta a la memoria: 0.031 MB memoria antes de la consulta: 3.356 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 13:46:39') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-11-23 13:46:39') 
      AND a.created >= DATE_SUB('2024-11-23 13:46:39', 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.0 ms
    Sorting result	0.0 ms
    executing	0.0 ms
    Sending data	6.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
    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.]

    ---

27. Tiempo de la consulta: 0.45 ms Después de la última consulta: 8.00 ms Consulta a la memoria: 0.019 MB memoria antes de la consulta: 3.785 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.2 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.]

    ---

28. Tiempo de la consulta: 0.27 ms Después de la última consulta: 1.60 ms Consulta a la memoria: 0.003 MB memoria antes de la consulta: 3.903 MB

    UPDATE `gzm4h_session`
    
      SET `data` = '__default|a:8:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1732369599;s:18:\"session.timer.last\";i:1732369599;s:17:\"session.timer.now\";i:1732369599;s:24:\"session.client.forwarded\";s:12:\"13.59.87.145\";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` = '1732369599'
    
      WHERE `session_id` = '80ml52d2vd235rst14sdt6rkn4'

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

1. 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. 2 × SELECT extension_id AS id, element AS "option", params, enabled 
     FROM gzm4h_extensions

3. 1 × SELECT a.rules 
     FROM gzm4h_assets AS a

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

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

6. 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`

7. 1 × SELECT * 
     FROM gzm4h_content

8. 1 × SELECT * 
     FROM gzm4h_acymailing_confi

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

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

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

12. 1 × SELECT alias 
      FROM gzm4h_content

13. 1 × SELECT id, rules 
      FROM `gzm4h_viewlevels

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

15. 1 × SELECT `session_id` 
      FROM `gzm4h_session`

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

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

18. 1 × SELECT `data` 
      FROM `gzm4h_session`

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

20. 1 × SELECT * 
      FROM gzm4h_languages

OTRAS tablas:

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

2. 1 × UPDATE `gzm4h_session` 
     SET `data` = '__default|a:8:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1732369599;s:18:\"session.timer.last\";i:1732369599;s:17:\"session.timer.now\";i:1732369599;s:24:\"session.client.forwarded\";s:12:\"13.59.87.145\";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` = '1732369599'

3. 1 × SHOW FULL COLUMNS 
     FROM `gzm4h_content

4. 1 × UPDATE `gzm4h_extensions` 
     SET `params` = '{\"mediaversion\":\"c910026467ff0666d048d65493cf7c28\"}'

5. 1 × INSERT INTO `gzm4h_session` (`session_id`, `client_id`, `time`) 
     VALUES  ('80ml52d2vd235rst14sdt6rkn4', 0, '1732369599'

6. 1 × DELETE  
     FROM `gzm4h_session`