Tiempo de la consulta: 0.23 ms Consulta a la memoria: 0.016 MB memoria antes de la consulta: 0.823 MB Filas devueltas: 1
SELECT `data`
FROM `gzm4h_session`
WHERE `session_id` = '6csieprr4eh0tefmmjm7002li4'
| 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 |
| 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 |
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
Tiempo de la consulta: 0.14 ms Después de la última consulta: 0.35 ms Consulta a la memoria: 0.008 MB memoria antes de la consulta: 0.873 MB
DELETE
FROM `gzm4h_session`
WHERE `time` < '1716024073'
| 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 |
| 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 |
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
Tiempo de la consulta: 0.37 ms Después de la última consulta: 0.53 ms Consulta a la memoria: 0.017 MB memoria antes de la consulta: 0.953 MB Filas devueltas: 33
SELECT extension_id AS id, element AS "option", params, enabled
FROM gzm4h_extensions
WHERE `type` = 'component'
| 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 |
| 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 |
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
Tiempo de la consulta: 0.44 ms Después de la última consulta: 0.50 ms Consulta a la memoria: 0.013 MB memoria antes de la consulta: 1.010 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
| 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' |
| 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 |
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
Tiempo de la consulta: 0.62 ms Después de la última consulta: 5.62 ms Consulta a la memoria: 0.028 MB memoria antes de la consulta: 1.533 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
| 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 |
| Status | Duration |
|---|
| starting | 0.1 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| Opening tables | 0.1 ms |
| init | 0.0 ms |
| System lock | 0.0 ms |
| optimizing | 0.0 ms |
| statistics | 0.0 ms |
| preparing | 0.0 ms |
| Sorting result | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 0.0 ms |
| Creating sort index | 0.3 ms |
| end | 0.0 ms |
| query end | 0.0 ms |
| closing tables | 0.0 ms |
| freeing items | 0.0 ms |
| cleaning up | 0.0 ms |
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
Tiempo de la consulta: 0.67 ms Después de la última consulta: 2.13 ms Consulta a la memoria: 0.024 MB memoria antes de la consulta: 1.947 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=204
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
| 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) |
| Status | Duration |
|---|
| starting | 0.1 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| Opening tables | 0.1 ms |
| init | 0.1 ms |
| System lock | 0.0 ms |
| optimizing | 0.0 ms |
| optimizing | 0.0 ms |
| statistics | 0.0 ms |
| preparing | 0.0 ms |
| Creating tmp table | 0.0 ms |
| Sorting result | 0.0 ms |
| statistics | 0.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 |
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
Tiempo de la consulta: 0.22 ms Después de la última consulta: 0.12 ms Consulta a la memoria: 0.015 MB memoria antes de la consulta: 1.960 MB Filas devueltas: 1
SELECT `alias`,`catid`
FROM `gzm4h_content`
WHERE `id` = 204
| 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 |
| 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 |
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
Tiempo de la consulta: 0.21 ms Después de la última consulta: 0.29 ms Consulta a la memoria: 0.024 MB memoria antes de la consulta: 1.995 MB Filas devueltas: 1
SELECT extension_id AS id, element AS "option", params, enabled
FROM gzm4h_extensions
WHERE `type` = 'library'
AND `element` = 'joomla'
| 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 |
| 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 |
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
Tiempo de la consulta: 0.25 ms Después de la última consulta: 0.24 ms Consulta a la memoria: 0.018 MB memoria antes de la consulta: 2.003 MB
UPDATE `gzm4h_extensions`
SET `params` = '{\"mediaversion\":\"d39f697901abc2abff71aa8708cebbd5\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'
| 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 |
| 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 |
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
Tiempo de la consulta: 0.16 ms Después de la última consulta: 0.48 ms Consulta a la memoria: 0.022 MB memoria antes de la consulta: 2.085 MB Filas devueltas: 1
SELECT alias
FROM gzm4h_content
WHERE id=204
| 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 |
| 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 |
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
Tiempo de la consulta: 1.03 ms Después de la última consulta: 0.16 ms Consulta a la memoria: 0.031 MB memoria antes de la consulta: 2.114 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
| 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) |
| Status | Duration |
|---|
| starting | 0.1 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| Opening tables | 0.0 ms |
| init | 0.1 ms |
| System lock | 0.0 ms |
| optimizing | 0.0 ms |
| optimizing | 0.0 ms |
| statistics | 0.0 ms |
| preparing | 0.0 ms |
| Creating tmp table | 0.0 ms |
| Sorting result | 0.0 ms |
| statistics | 0.1 ms |
| preparing | 0.0 ms |
| Creating tmp table | 0.0 ms |
| Sorting result | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 0.1 ms |
| Creating sort index | 0.3 ms |
| Creating sort index | 0.1 ms |
| end | 0.0 ms |
| query end | 0.0 ms |
| removing tmp table | 0.0 ms |
| query end | 0.0 ms |
| removing tmp table | 0.0 ms |
| query end | 0.0 ms |
| closing tables | 0.0 ms |
| removing tmp table | 0.0 ms |
| closing tables | 0.0 ms |
| freeing items | 0.0 ms |
| cleaning up | 0.0 ms |
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
Tiempo de la consulta: 0.28 ms Después de la última consulta: 0.58 ms Consulta a la memoria: 0.014 MB memoria antes de la consulta: 2.173 MB Filas devueltas: 1
SELECT *
FROM gzm4h_languages
WHERE published=1
ORDER BY ordering ASC
| 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' |
| 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 |
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
Tiempo de la consulta: 0.35 ms Después de la última consulta: 0.46 ms Consulta a la memoria: 0.010 MB memoria antes de la consulta: 2.194 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
| 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 |
| 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.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 |
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
Tiempo de la consulta: 0.45 ms Después de la última consulta: 2.41 ms Consulta a la memoria: 0.025 MB memoria antes de la consulta: 2.424 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
| 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 |
| 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 |
| 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 |
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
Tiempo de la consulta: 0.26 ms Después de la última consulta: 0.32 ms Consulta a la memoria: 0.025 MB memoria antes de la consulta: 2.462 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
| 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 |
| 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 |
JROOT/libraries/joomla/access/access.php:332
JROOT/libraries/joomla/access/access.php:111
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
Tiempo de la consulta: 0.78 ms Después de la última consulta: 0.32 ms Consulta a la memoria: 0.032 MB memoria antes de la consulta: 2.502 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 = 204
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-05-18 09:36:13')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-05-18 09:36:13')
AND (a.state = 1 OR a.state =2)
| 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) |
| Status | Duration |
|---|
| starting | 0.1 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| Opening tables | 0.1 ms |
| init | 0.1 ms |
| System lock | 0.0 ms |
| optimizing | 0.0 ms |
| optimizing | 0.0 ms |
| statistics | 0.0 ms |
| preparing | 0.0 ms |
| Creating tmp table | 0.0 ms |
| Sorting result | 0.0 ms |
| statistics | 0.1 ms |
| preparing | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 0.1 ms |
| Creating sort index | 0.0 ms |
| end | 0.0 ms |
| query end | 0.0 ms |
| removing tmp table | 0.0 ms |
| query end | 0.0 ms |
| closing tables | 0.0 ms |
| removing tmp table | 0.0 ms |
| closing tables | 0.0 ms |
| freeing items | 0.0 ms |
| cleaning up | 0.0 ms |
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
Tiempo de la consulta: 0.37 ms Después de la última consulta: 1.45 ms Consulta a la memoria: 0.025 MB memoria antes de la consulta: 2.616 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` = 204
AND `t`.`published` = 1
AND t.access IN (1,1,5)
| 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 |
| 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 |
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
Tiempo de la consulta: 0.45 ms Después de la última consulta: 1.85 ms Consulta a la memoria: 0.028 MB memoria antes de la consulta: 2.733 MB Filas devueltas: 30
SHOW FULL COLUMNS
FROM `gzm4h_content`
'Explicar' no es posible en la consulta: SHOW FULL COLUMNS FROM `gzm4h_content`
| 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 |
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
Tiempo de la consulta: 0.17 ms Después de la última consulta: 0.67 ms Consulta a la memoria: 0.026 MB memoria antes de la consulta: 2.861 MB Filas devueltas: 1
SELECT *
FROM gzm4h_content
WHERE `id` = '204'
| 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 |
| 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 |
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
Tiempo de la consulta: 0.17 ms Después de la última consulta: 0.17 ms Consulta a la memoria: 0.016 MB memoria antes de la consulta: 2.880 MB
UPDATE gzm4h_content
SET `hits` = (`hits` + 1)
WHERE `id` = '204'
| 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 |
| 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 |
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
Tiempo de la consulta: 0.59 ms Después de la última consulta: 3.73 ms Consulta a la memoria: 0.021 MB memoria antes de la consulta: 3.134 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-05-18 09:36:13')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-05-18 09:36:13')
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
| 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 |
| Status | Duration |
|---|
| starting | 0.1 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| Opening tables | 0.1 ms |
| init | 0.0 ms |
| System lock | 0.0 ms |
| optimizing | 0.0 ms |
| statistics | 0.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 |
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
Tiempo de la consulta: 0.19 ms Después de la última consulta: 3.27 ms Consulta a la memoria: 0.019 MB memoria antes de la consulta: 3.282 MB Filas devueltas: 5
SELECT id, rules
FROM `gzm4h_viewlevels`
| 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 |
| 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 |
JROOT/libraries/joomla/access/access.php:418
JROOT/modules/mod_articles_popular/helper.php:51
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
Tiempo de la consulta: 6.60 ms Después de la última consulta: 0.30 ms Consulta a la memoria: 0.031 MB memoria antes de la consulta: 3.318 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-05-18 09:36:13')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-05-18 09:36:13')
AND a.created >= DATE_SUB('2024-05-18 09:36:13', INTERVAL 30 DAY)
ORDER BY a.hits DESC
LIMIT 0, 10
| 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) |
| 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 | 5.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 |
| 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 |
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
Tiempo de la consulta: 0.31 ms Después de la última consulta: 7.48 ms Consulta a la memoria: 0.019 MB memoria antes de la consulta: 3.744 MB Filas devueltas: 84
SELECT *
FROM gzm4h_acymailing_config
| 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 |
| 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 |
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
Tiempo de la consulta: 0.26 ms Después de la última consulta: 1.45 ms Consulta a la memoria: 0.003 MB memoria antes de la consulta: 3.864 MB
UPDATE `gzm4h_session`
SET `data` = '__default|a:8:{s:15:\"session.counter\";i:2;s:19:\"session.timer.start\";i:1716024973;s:18:\"session.timer.last\";i:1716024973;s:17:\"session.timer.now\";i:1716024973;s:24:\"session.client.forwarded\";s:14:\"18.188.174.246\";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` = '1716024973'
WHERE `session_id` = '6csieprr4eh0tefmmjm7002li4'
| 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 |
| 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 |
JROOT/libraries/joomla/session/storage/database.php:84
2 × SELECT extension_id AS id, element AS "option", params, enabled
FROM gzm4h_extensions
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
1 × SELECT *
FROM gzm4h_content
1 × SELECT `m`.`tag_id`,`t`.*
FROM `gzm4h_contentitem_tag_map` AS m
INNER JOIN `gzm4h_tags` AS t
ON `m`.`tag_id` = `t`.`id`
1 × SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext,
CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
FROM gzm4h_content AS a
LEFT JOIN gzm4h_categories AS c
on c.id = a.catid
LEFT JOIN gzm4h_users AS u
on u.id = a.created_by
LEFT JOIN gzm4h_categories as parent
ON parent.id = c.parent_id
LEFT JOIN gzm4h_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM gzm4h_categories AS cat JOIN gzm4h_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM gzm4h_modules AS m
LEFT JOIN gzm4h_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN gzm4h_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
1 × SELECT id, rules
FROM `gzm4h_viewlevels
1 × SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore,
CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published,
CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
FROM gzm4h_content AS a
LEFT JOIN gzm4h_content_frontpage AS fp
ON fp.content_id = a.id
LEFT JOIN gzm4h_categories AS c
ON c.id = a.catid
LEFT JOIN gzm4h_users AS ua
ON ua.id = a.created_by
LEFT JOIN gzm4h_users AS uam
ON uam.id = a.modified_by
LEFT JOIN gzm4h_categories as parent
ON parent.id = c.parent_id
LEFT JOIN gzm4h_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM gzm4h_categories AS cat JOIN gzm4h_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
1 × SELECT b.id
FROM gzm4h_usergroups AS a
LEFT JOIN gzm4h_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
1 × SELECT *
FROM gzm4h_acymailing_confi
1 × SELECT id, home, template, s.params
FROM gzm4h_template_styles as s
LEFT JOIN gzm4h_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM gzm4h_menu AS m
LEFT JOIN gzm4h_extensions AS e
ON m.component_id = e.extension_id
1 × SELECT folder AS type, element AS name, params
FROM gzm4h_extensions
1 × SELECT `alias`,`catid`
FROM `gzm4h_content`
1 × SELECT alias
FROM gzm4h_content
1 × SELECT `data`
FROM `gzm4h_session`
1 × SELECT *
FROM gzm4h_languages
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
Este espectáculo aniversario, que está inspirado en los 25 años de carrera del grupo, comienza en tono ceremonioso, con un Jorge Esmoris muy protocolar, que lee un discurso a diplomáticos y las autoridades nacionales. La pieza oratoria, llena de contrasentidos, estalla inmediatamente en una locura general, en la que no falta el clásico recorrido por las contradicciones del Uruguay, lo que el país quiere ser y no es, los mitos y los problemas que parecen insuperables.