Consola de depuración de Joomla!

Fecha y hora

Memoria

34 consultas registradas 666.3 ms

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

   SELECT `data`
   
     FROM `gzm4h_session`
   
     WHERE `session_id` = 'rcm5rjuh726s481md7abf3rcr0'

   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	1.0 ms
   init	0.0 ms
   System lock	0.0 ms
   optimizing	0.0 ms
   statistics	0.8 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.14 ms Después de la última consulta: 5.00 ms Consulta a la memoria: 0.012 MB memoria antes de la consulta: 0.900 MB Filas devueltas: 0

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

   ---

3. Tiempo de la consulta: 0.89 ms Después de la última consulta: 0.17 ms Consulta a la memoria: 0.009 MB memoria antes de la consulta: 0.913 MB

   INSERT INTO `gzm4h_session`
   (`session_id`, `client_id`, `time`) 
     VALUES 
   ('rcm5rjuh726s481md7abf3rcr0', 0, '1714089240')

   Explicar

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

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

   ---

4. Tiempo de la consulta: 2.81 ms Después de la última consulta: 8.11 ms Consulta a la memoria: 0.018 MB memoria antes de la consulta: 0.996 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.5 ms
   init	0.0 ms
   System lock	0.0 ms
   optimizing	0.0 ms
   statistics	0.7 ms
   preparing	0.0 ms
   executing	0.0 ms
   Sending data	1.4 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.]

   ---

5. Tiempo de la consulta: 1.79 ms Después de la última consulta: 3.13 ms Consulta a la memoria: 0.014 MB memoria antes de la consulta: 1.056 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.5 ms
   init	0.0 ms
   System lock	0.0 ms
   optimizing	0.0 ms
   statistics	1.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.]

   ---

6. Tiempo de la consulta: 1.27 ms Después de la última consulta: 1.59 ms Consulta a la memoria: 0.013 MB memoria antes de la consulta: 1.075 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.4 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.7 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.]

   ---

7. Tiempo de la consulta: 1.16 ms Después de la última consulta: 0.28 ms Consulta a la memoria: 0.013 MB memoria antes de la consulta: 1.094 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.9 ms
   end	0.0 ms
   query end	0.0 ms
   closing tables	0.0 ms
   freeing items	0.0 ms
   cleaning up	0.0 ms

   Llamada de pila

   JROOT/libraries/cms/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.]

   ---

8. Tiempo de la consulta: 3.74 ms Después de la última consulta: 36.43 ms Consulta a la memoria: 0.028 MB memoria antes de la consulta: 1.626 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.6 ms
   init	0.0 ms
   System lock	0.0 ms
   optimizing	0.0 ms
   statistics	0.6 ms
   preparing	0.0 ms
   Sorting result	0.0 ms
   executing	0.0 ms
   Sending data	0.0 ms
   Creating sort index	1.9 ms
   end	0.0 ms
   query end	0.0 ms
   closing tables	0.0 ms
   freeing items	0.0 ms
   cleaning up	0.0 ms

   Llamada de pila

   JROOT/libraries/cms/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.]

   ---

9. Tiempo de la consulta: 0.78 ms Después de la última consulta: 4.54 ms Consulta a la memoria: 0.024 MB memoria antes de la consulta: 2.000 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.6 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.]

   ---

10. Tiempo de la consulta: 0.23 ms Después de la última consulta: 0.24 ms Consulta a la memoria: 0.018 MB memoria antes de la consulta: 2.007 MB

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

    ---

11. Tiempo de la consulta: 1.05 ms Después de la última consulta: 6.66 ms Consulta a la memoria: 0.014 MB memoria antes de la consulta: 2.136 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.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.7 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.]

    ---

12. Tiempo de la consulta: 1.22 ms Después de la última consulta: 0.49 ms Consulta a la memoria: 0.010 MB memoria antes de la consulta: 2.157 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.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.9 ms
    end	0.0 ms
    query end	0.0 ms
    closing tables	0.0 ms
    freeing items	0.0 ms
    cleaning up	0.0 ms

    Llamada de pila

    JROOT/libraries/cms/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.]

    ---

13. Tiempo de la consulta: 1.68 ms Después de la última consulta: 18.60 ms Consulta a la memoria: 0.024 MB memoria antes de la consulta: 2.475 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.5 ms
    init	0.0 ms
    System lock	0.0 ms
    optimizing	0.0 ms
    statistics	1.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/category.php:141

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

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

    JROOT/libraries/legacy/view/category.php:105

    JROOT/components/com_content/views/category/view.html.php:72

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

    ---

14. Tiempo de la consulta: 10.43 ms Después de la última consulta: 1.27 ms Consulta a la memoria: 0.025 MB memoria antes de la consulta: 2.508 MB Filas devueltas: 4

    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.category.65')
    
      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	ALL	idx_lft_rgt	No pudo usarse una clave de índice	NULL	NULL	2146	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	2.2 ms
    preparing	0.0 ms
    Creating tmp table	0.0 ms
    Sorting result	0.0 ms
    executing	0.0 ms
    Sending data	7.9 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/category.php:141

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

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

    JROOT/libraries/legacy/view/category.php:105

    JROOT/components/com_content/views/category/view.html.php:72

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

    ---

15. Tiempo de la consulta: 216.62 ms Después de la última consulta: 2.41 ms Consulta a la memoria: 0.031 MB memoria antes de la consulta: 2.573 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,COUNT(i.`id`) AS numitems
    
      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
    
      LEFT JOIN `gzm4h_content` AS i 
      ON i.`catid` = c.id 
      AND i.state = 1
    
      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
    1	PRIMARY	i	NULL	ref	idx_state,idx_catid	idx_catid	4	tryit_tumeser1_new.c.id	105	100.00	Using where
    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
    Opening tables	1.0 ms
    init	0.1 ms
    System lock	0.0 ms
    optimizing	0.0 ms
    optimizing	0.0 ms
    statistics	0.7 ms
    preparing	0.0 ms
    Creating tmp table	0.0 ms
    Sorting result	0.0 ms
    statistics	3.0 ms
    preparing	0.0 ms
    Creating tmp table	0.0 ms
    Sorting result	0.0 ms
    executing	0.0 ms
    Sending data	0.0 ms
    executing	0.0 ms
    Sending data	0.1 ms
    Creating sort index	210.9 ms
    Creating sort index	0.2 ms
    end	0.0 ms
    query end	0.0 ms
    removing tmp table	0.1 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/models/category.php:357

    JROOT/components/com_content/models/category.php:234

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

    JROOT/libraries/legacy/view/category.php:106

    JROOT/components/com_content/views/category/view.html.php:72

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

    ---

16. Tiempo de la consulta: 0.79 ms Después de la última consulta: 2.49 ms Consulta a la memoria: 0.029 MB memoria antes de la consulta: 2.660 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.4 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/articles.php:449

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

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

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

    JROOT/components/com_content/models/category.php:256

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

    JROOT/libraries/legacy/view/category.php:106

    JROOT/components/com_content/views/category/view.html.php:72

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

    ---

17. Tiempo de la consulta: 203.71 ms Después de la última consulta: 0.26 ms Consulta a la memoria: 0.071 MB memoria antes de la consulta: 2.692 MB Filas devueltas: 10

    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.catid = 65 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-04-25 23:54:00') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-25 23:54:00')
    
      ORDER BY    
      CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END  DESC ,  a.created   
      LIMIT 90, 10

    Explicar

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	PRIMARY	a	NULL	ref	idx_catid	idx_catid	4	const	1173	16.00	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	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
    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.5 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	4.3 ms
    executing	0.0 ms
    Sending data	0.1 ms
    Creating sort index	196.0 ms
    Creating sort index	1.6 ms
    end	0.0 ms
    query end	0.0 ms
    removing tmp table	0.5 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.1 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/components/com_content/models/category.php:256

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

    JROOT/libraries/legacy/view/category.php:106

    JROOT/components/com_content/views/category/view.html.php:72

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

    ---

18. Tiempo de la consulta: 3.71 ms Después de la última consulta: 3.50 ms Consulta a la memoria: 0.030 MB memoria antes de la consulta: 2.973 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` = 2012 
      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.3 ms
    init	0.0 ms
    System lock	0.0 ms
    optimizing	0.0 ms
    statistics	1.1 ms
    preparing	0.0 ms
    executing	0.0 ms
    Sending data	1.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/models/articles.php:663

    JROOT/components/com_content/models/category.php:256

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

    JROOT/libraries/legacy/view/category.php:106

    JROOT/components/com_content/views/category/view.html.php:72

    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.21 ms Después de la última consulta: 0.47 ms Consulta a la memoria: 0.029 MB memoria antes de la consulta: 3.013 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` = 2011 
      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.0 ms
    init	0.0 ms
    System lock	0.0 ms
    optimizing	0.0 ms
    statistics	0.0 ms
    preparing	0.0 ms
    executing	0.0 ms
    Sending data	0.0 ms
    end	0.0 ms
    query end	0.0 ms
    closing tables	0.0 ms
    freeing items	0.0 ms
    cleaning up	0.0 ms

    Llamada de pila

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

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

    JROOT/components/com_content/models/category.php:256

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

    JROOT/libraries/legacy/view/category.php:106

    JROOT/components/com_content/views/category/view.html.php:72

    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.21 ms Después de la última consulta: 0.36 ms Consulta a la memoria: 0.029 MB memoria antes de la consulta: 3.052 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` = 2010 
      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.0 ms
    init	0.0 ms
    System lock	0.0 ms
    optimizing	0.0 ms
    statistics	0.0 ms
    preparing	0.0 ms
    executing	0.0 ms
    Sending data	0.0 ms
    end	0.0 ms
    query end	0.0 ms
    closing tables	0.0 ms
    freeing items	0.0 ms
    cleaning up	0.0 ms

    Llamada de pila

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

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

    JROOT/components/com_content/models/category.php:256

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

    JROOT/libraries/legacy/view/category.php:106

    JROOT/components/com_content/views/category/view.html.php:72

    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: 3.41 ms Después de la última consulta: 0.32 ms Consulta a la memoria: 0.029 MB memoria antes de la consulta: 3.091 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` = 2009 
      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.0 ms
    init	0.0 ms
    System lock	0.0 ms
    optimizing	0.0 ms
    statistics	0.0 ms
    preparing	0.0 ms
    executing	0.0 ms
    Sending data	0.0 ms
    end	0.0 ms
    query end	0.0 ms
    closing tables	0.0 ms
    freeing items	0.0 ms
    cleaning up	0.0 ms

    Llamada de pila

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

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

    JROOT/components/com_content/models/category.php:256

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

    JROOT/libraries/legacy/view/category.php:106

    JROOT/components/com_content/views/category/view.html.php:72

    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.18 ms Después de la última consulta: 0.37 ms Consulta a la memoria: 0.029 MB memoria antes de la consulta: 3.131 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` = 2008 
      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.0 ms
    init	0.0 ms
    System lock	0.0 ms
    optimizing	0.0 ms
    statistics	0.0 ms
    preparing	0.0 ms
    executing	0.0 ms
    Sending data	0.0 ms
    end	0.0 ms
    query end	0.0 ms
    closing tables	0.0 ms
    freeing items	0.0 ms
    cleaning up	0.0 ms

    Llamada de pila

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

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

    JROOT/components/com_content/models/category.php:256

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

    JROOT/libraries/legacy/view/category.php:106

    JROOT/components/com_content/views/category/view.html.php:72

    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.31 ms Consulta a la memoria: 0.029 MB memoria antes de la consulta: 3.170 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` = 2007 
      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.0 ms
    init	0.0 ms
    System lock	0.0 ms
    optimizing	0.0 ms
    statistics	0.0 ms
    preparing	0.0 ms
    executing	0.0 ms
    Sending data	0.0 ms
    end	0.0 ms
    query end	0.0 ms
    closing tables	0.0 ms
    freeing items	0.0 ms
    cleaning up	0.0 ms

    Llamada de pila

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

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

    JROOT/components/com_content/models/category.php:256

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

    JROOT/libraries/legacy/view/category.php:106

    JROOT/components/com_content/views/category/view.html.php:72

    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.16 ms Después de la última consulta: 0.34 ms Consulta a la memoria: 0.029 MB memoria antes de la consulta: 3.209 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` = 2006 
      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.0 ms
    init	0.0 ms
    System lock	0.0 ms
    optimizing	0.0 ms
    statistics	0.0 ms
    preparing	0.0 ms
    executing	0.0 ms
    Sending data	0.0 ms
    end	0.0 ms
    query end	0.0 ms
    closing tables	0.0 ms
    freeing items	0.0 ms
    cleaning up	0.0 ms

    Llamada de pila

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

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

    JROOT/components/com_content/models/category.php:256

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

    JROOT/libraries/legacy/view/category.php:106

    JROOT/components/com_content/views/category/view.html.php:72

    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.17 ms Después de la última consulta: 0.30 ms Consulta a la memoria: 0.029 MB memoria antes de la consulta: 3.248 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` = 2005 
      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.0 ms
    init	0.0 ms
    System lock	0.0 ms
    optimizing	0.0 ms
    statistics	0.0 ms
    preparing	0.0 ms
    executing	0.0 ms
    Sending data	0.0 ms
    end	0.0 ms
    query end	0.0 ms
    closing tables	0.0 ms
    freeing items	0.0 ms
    cleaning up	0.0 ms

    Llamada de pila

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

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

    JROOT/components/com_content/models/category.php:256

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

    JROOT/libraries/legacy/view/category.php:106

    JROOT/components/com_content/views/category/view.html.php:72

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

    ---

26. Tiempo de la consulta: 3.63 ms Después de la última consulta: 0.33 ms Consulta a la memoria: 0.029 MB memoria antes de la consulta: 3.287 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` = 2003 
      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.0 ms
    init	0.0 ms
    System lock	0.0 ms
    optimizing	0.0 ms
    statistics	0.0 ms
    preparing	0.0 ms
    executing	0.0 ms
    Sending data	0.0 ms
    end	0.0 ms
    query end	0.0 ms
    closing tables	0.0 ms
    freeing items	0.0 ms
    cleaning up	0.0 ms

    Llamada de pila

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

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

    JROOT/components/com_content/models/category.php:256

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

    JROOT/libraries/legacy/view/category.php:106

    JROOT/components/com_content/views/category/view.html.php:72

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

    ---

27. Tiempo de la consulta: 0.19 ms Después de la última consulta: 0.37 ms Consulta a la memoria: 0.029 MB memoria antes de la consulta: 3.326 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` = 2002 
      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.0 ms
    init	0.0 ms
    System lock	0.0 ms
    optimizing	0.0 ms
    statistics	0.0 ms
    preparing	0.0 ms
    executing	0.0 ms
    Sending data	0.0 ms
    end	0.0 ms
    query end	0.0 ms
    closing tables	0.0 ms
    freeing items	0.0 ms
    cleaning up	0.0 ms

    Llamada de pila

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

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

    JROOT/components/com_content/models/category.php:256

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

    JROOT/libraries/legacy/view/category.php:106

    JROOT/components/com_content/views/category/view.html.php:72

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

    ---

28. Tiempo de la consulta: 18.17 ms Después de la última consulta: 2.06 ms Consulta a la memoria: 0.024 MB memoria antes de la consulta: 3.364 MB Filas devueltas: 1

    SELECT COUNT(*)
    
      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.catid = 65 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-04-25 23:54:00') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-25 23:54:00')

    Explicar

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	PRIMARY	a	NULL	ref	idx_catid	idx_catid	4	const	1173	16.00	Using where
    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	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
    1	PRIMARY	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	tryit_tumeser1_new.a.created_by	1	100.00	Using where; Using index
    1	PRIMARY	uam	NULL	eq_ref	PRIMARY	PRIMARY	4	tryit_tumeser1_new.a.modified_by	1	100.00	Using where; Using index
    1	PRIMARY	parent	NULL	eq_ref	PRIMARY	PRIMARY	4	tryit_tumeser1_new.c.parent_id	1	100.00	Using where; Using index
    1	PRIMARY	v	NULL	eq_ref	PRIMARY	PRIMARY	4	tryit_tumeser1_new.a.id	1	100.00	Using where; Using index
    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.0 ms
    init	0.1 ms
    System lock	0.0 ms
    optimizing	0.0 ms
    optimizing	0.0 ms
    statistics	0.0 ms
    preparing	0.0 ms
    Creating tmp table	0.0 ms
    Sorting result	0.0 ms
    statistics	0.1 ms
    preparing	0.0 ms
    executing	0.0 ms
    Sending data	0.1 ms
    executing	0.0 ms
    Sending data	0.1 ms
    Creating sort index	17.4 ms
    end	0.0 ms
    query end	0.1 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:333

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

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

    JROOT/components/com_content/models/category.php:268

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

    JROOT/libraries/legacy/view/category.php:106

    JROOT/components/com_content/views/category/view.html.php:72

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

    ---

29. Tiempo de la consulta: 0.35 ms Después de la última consulta: 0.50 ms Consulta a la memoria: 0.026 MB memoria antes de la consulta: 3.371 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.category' 
      AND `m`.`content_item_id` = 65 
      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.0 ms
    init	0.0 ms
    System lock	0.0 ms
    optimizing	0.0 ms
    statistics	0.1 ms
    preparing	0.0 ms
    executing	0.0 ms
    Sending data	0.0 ms
    end	0.0 ms
    query end	0.0 ms
    closing tables	0.0 ms
    freeing items	0.0 ms
    cleaning up	0.0 ms

    Llamada de pila

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

    JROOT/libraries/legacy/view/category.php:177

    JROOT/components/com_content/views/category/view.html.php:72

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

    ---

30. Tiempo de la consulta: 1.06 ms Después de la última consulta: 38.16 ms Consulta a la memoria: 0.038 MB memoria antes de la consulta: 3.736 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/helpers/route.php:44

    JROOT/templates/plantilla_tumeser_01/library/Artx/Content/ListItem.php:15

    JROOT/templates/plantilla_tumeser_01/library/Artx/Content/CategoryArticle.php:12

    JROOT/templates/plantilla_tumeser_01/library/Artx/Content.php:47

    JROOT/templates/plantilla_tumeser_01/html/com_content/category/blog_item.php:16

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

    JROOT/templates/plantilla_tumeser_01/html/com_content/category/blog.php:49

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

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

    JROOT/libraries/legacy/view/category.php:193

    JROOT/components/com_content/views/category/view.html.php:258

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

    ---

31. Tiempo de la consulta: 3.04 ms Después de la última consulta: 15.40 ms Consulta a la memoria: 0.021 MB memoria antes de la consulta: 3.885 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-04-25 23:54:00') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-04-25 23:54:00') 
      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.3 ms
    init	0.0 ms
    System lock	0.0 ms
    optimizing	0.0 ms
    statistics	0.6 ms
    preparing	0.0 ms
    Sorting result	0.0 ms
    executing	0.0 ms
    Sending data	0.0 ms
    Creating sort index	1.8 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.]

    ---

32. Tiempo de la consulta: 174.53 ms Después de la última consulta: 9.12 ms Consulta a la memoria: 0.031 MB memoria antes de la consulta: 4.007 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-04-25 23:54:00') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-25 23:54:00') 
      AND a.created >= DATE_SUB('2024-04-25 23:54:00', 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.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.0 ms
    preparing	0.0 ms
    Creating tmp table	0.0 ms
    Sorting result	0.0 ms
    executing	0.0 ms
    Sending data	173.8 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.]

    ---

33. Tiempo de la consulta: 4.67 ms Después de la última consulta: 28.98 ms Consulta a la memoria: 0.019 MB memoria antes de la consulta: 4.460 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	2.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	1.5 ms
    end	0.0 ms
    query end	0.0 ms
    closing tables	0.0 ms
    freeing items	0.0 ms
    cleaning up	0.0 ms

    Llamada de pila

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

    ---

34. Tiempo de la consulta: 2.24 ms Después de la última consulta: 3.93 ms Consulta a la memoria: 0.003 MB memoria antes de la consulta: 4.590 MB

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

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

    ---