Tiempo de la consulta: 3.23 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` = 'e9o2rjm2dhf432s8b02qdamnl7'
| 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 | 2.6 ms |
| init | 0.0 ms |
| System lock | 0.0 ms |
| optimizing | 0.0 ms |
| statistics | 0.5 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 |
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: 4.85 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` = 'e9o2rjm2dhf432s8b02qdamnl7'
LIMIT 0, 1
| 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 |
| 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 |
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
Tiempo de la consulta: 0.68 ms Después de la última consulta: 0.10 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
('e9o2rjm2dhf432s8b02qdamnl7', 0, '1713953086')
'Explicar' no es posible en la consulta: INSERT INTO `gzm4h_session`
(`session_id`, `client_id`, `time`) VALUES
('e9o2rjm2dhf432s8b02qdamnl7', 0, '1713953086')
| 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.6 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: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
Tiempo de la consulta: 4.59 ms Después de la última consulta: 8.83 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'
| 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 | 1.8 ms |
| init | 0.0 ms |
| System lock | 0.0 ms |
| optimizing | 0.0 ms |
| statistics | 0.9 ms |
| preparing | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 1.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 |
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: 1.82 ms Después de la última consulta: 2.86 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
| 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.7 ms |
| init | 0.0 ms |
| System lock | 0.0 ms |
| optimizing | 0.0 ms |
| statistics | 0.9 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: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
Tiempo de la consulta: 1.63 ms Después de la última consulta: 1.11 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`
| 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.9 ms |
| init | 0.0 ms |
| System lock | 0.0 ms |
| optimizing | 0.0 ms |
| statistics | 0.0 ms |
| preparing | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 0.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 |
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
Tiempo de la consulta: 1.09 ms Después de la última consulta: 0.18 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
| 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.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 |
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: 4.28 ms Después de la última consulta: 29.91 ms Consulta a la memoria: 0.028 MB memoria antes de la consulta: 1.625 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 | 1.5 ms |
| init | 0.0 ms |
| System lock | 0.0 ms |
| optimizing | 0.0 ms |
| statistics | 0.9 ms |
| preparing | 0.0 ms |
| Sorting result | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 0.0 ms |
| Creating sort index | 1.6 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.80 ms Después de la última consulta: 5.87 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'
| 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.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 |
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.22 ms Después de la última consulta: 0.23 ms Consulta a la memoria: 0.018 MB memoria antes de la consulta: 2.008 MB
UPDATE `gzm4h_extensions`
SET `params` = '{\"mediaversion\":\"99863057f1e3753e332d9a2300a3aaeb\"}'
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: 1.98 ms Después de la última consulta: 6.61 ms Consulta a la memoria: 0.013 MB memoria antes de la consulta: 2.136 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 | 1.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.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 |
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: 1.55 ms Después de la última consulta: 0.46 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
| 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.5 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.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 |
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: 2.34 ms Después de la última consulta: 18.35 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
| 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 |
| Status | Duration |
|---|
| starting | 0.0 ms |
| checking permissions | 0.0 ms |
| Opening tables | 1.2 ms |
| init | 0.0 ms |
| System lock | 0.0 ms |
| optimizing | 0.0 ms |
| statistics | 0.9 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: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
Tiempo de la consulta: 9.97 ms Después de la última consulta: 0.97 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
| 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 |
| 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.1 ms |
| preparing | 0.0 ms |
| Creating tmp table | 0.0 ms |
| Sorting result | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 7.6 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/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
Tiempo de la consulta: 210.33 ms Después de la última consulta: 2.58 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
| 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) |
| 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 | 2.0 ms |
| init | 0.1 ms |
| System lock | 0.0 ms |
| optimizing | 0.0 ms |
| optimizing | 0.0 ms |
| statistics | 0.8 ms |
| preparing | 0.0 ms |
| Creating tmp table | 0.0 ms |
| Sorting result | 0.0 ms |
| statistics | 2.4 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 | 204.2 ms |
| Creating sort index | 0.1 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 |
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
Tiempo de la consulta: 0.73 ms Después de la última consulta: 2.51 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
| 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.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 |
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
Tiempo de la consulta: 195.39 ms Después de la última consulta: 0.24 ms Consulta a la memoria: 0.067 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-24 10:04:46')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-24 10:04:46')
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 50, 10
| 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) |
| 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 | 2.6 ms |
| init | 0.1 ms |
| System lock | 0.0 ms |
| optimizing | 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 |
| 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 | 7.6 ms |
| executing | 0.0 ms |
| Sending data | 0.1 ms |
| Creating sort index | 182.6 ms |
| Creating sort index | 1.3 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 |
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
Tiempo de la consulta: 3.98 ms Después de la última consulta: 3.79 ms Consulta a la memoria: 0.030 MB memoria antes de la consulta: 2.967 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` = 2071
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 | 1.8 ms |
| init | 0.0 ms |
| System lock | 0.0 ms |
| optimizing | 0.0 ms |
| statistics | 1.3 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 |
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
Tiempo de la consulta: 0.21 ms Después de la última consulta: 0.42 ms Consulta a la memoria: 0.029 MB memoria antes de la consulta: 3.007 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` = 2070
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.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/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
Tiempo de la consulta: 0.17 ms Después de la última consulta: 0.35 ms Consulta a la memoria: 0.029 MB memoria antes de la consulta: 3.046 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` = 2069
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.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/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
Tiempo de la consulta: 0.18 ms Después de la última consulta: 0.32 ms Consulta a la memoria: 0.029 MB memoria antes de la consulta: 3.085 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` = 2068
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.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/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
Tiempo de la consulta: 0.17 ms Después de la última consulta: 0.31 ms Consulta a la memoria: 0.029 MB memoria antes de la consulta: 3.124 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` = 2066
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.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/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
Tiempo de la consulta: 0.16 ms Después de la última consulta: 0.29 ms Consulta a la memoria: 0.029 MB memoria antes de la consulta: 3.163 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` = 2065
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.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/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
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.203 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` = 2064
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.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/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
Tiempo de la consulta: 0.15 ms Después de la última consulta: 0.29 ms Consulta a la memoria: 0.029 MB memoria antes de la consulta: 3.242 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` = 2063
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.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/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
Tiempo de la consulta: 0.15 ms Después de la última consulta: 0.36 ms Consulta a la memoria: 0.029 MB memoria antes de la consulta: 3.281 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` = 2062
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.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/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
Tiempo de la consulta: 0.15 ms Después de la última consulta: 0.31 ms Consulta a la memoria: 0.029 MB memoria antes de la consulta: 3.320 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` = 2060
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.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/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
Tiempo de la consulta: 10.79 ms Después de la última consulta: 1.99 ms Consulta a la memoria: 0.024 MB memoria antes de la consulta: 3.358 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-24 10:04:46')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-24 10:04:46')
| 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) |
| 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.1 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 | 10.1 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/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
Tiempo de la consulta: 0.34 ms Después de la última consulta: 0.37 ms Consulta a la memoria: 0.026 MB memoria antes de la consulta: 3.364 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)
| 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.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/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
Tiempo de la consulta: 1.59 ms Después de la última consulta: 29.33 ms Consulta a la memoria: 0.038 MB memoria antes de la consulta: 3.729 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/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
Tiempo de la consulta: 6.34 ms Después de la última consulta: 16.79 ms Consulta a la memoria: 0.021 MB memoria antes de la consulta: 3.871 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-24 10:04:46')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-04-24 10:04:46')
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 | 1.3 ms |
| init | 0.0 ms |
| System lock | 0.0 ms |
| optimizing | 0.0 ms |
| statistics | 1.0 ms |
| preparing | 0.0 ms |
| Sorting result | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 0.0 ms |
| Creating sort index | 2.3 ms |
| end | 0.0 ms |
| query end | 0.0 ms |
| closing tables | 0.0 ms |
| freeing items | 0.0 ms |
| cleaning up | 0.0 ms |
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: 162.31 ms Después de la última consulta: 9.82 ms Consulta a la memoria: 0.031 MB memoria antes de la consulta: 3.993 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-24 10:04:46')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-24 10:04:46')
AND a.created >= DATE_SUB('2024-04-24 10:04:46', 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.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.1 ms |
| Sorting result | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 161.6 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: 1.19 ms Después de la última consulta: 19.07 ms Consulta a la memoria: 0.019 MB memoria antes de la consulta: 4.443 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.7 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.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/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.71 ms Después de la última consulta: 3.66 ms Consulta a la memoria: 0.003 MB memoria antes de la consulta: 4.575 MB
UPDATE `gzm4h_session`
SET `data` = '__default|a:8:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1713953086;s:18:\"session.timer.last\";i:1713953086;s:17:\"session.timer.now\";i:1713953086;s:24:\"session.client.forwarded\";s:14:\"18.117.196.217\";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` = '1713953087'
WHERE `session_id` = 'e9o2rjm2dhf432s8b02qdamnl7'
| 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.0 ms |
| closing tables | 0.0 ms |
| freeing items | 0.0 ms |
| cleaning up | 0.0 ms |
JROOT/libraries/joomla/session/storage/database.php:84
11 × SELECT `m`.`tag_id`,`t`.*
FROM `gzm4h_contentitem_tag_map` AS m
INNER JOIN `gzm4h_tags` AS t
ON `m`.`tag_id` = `t`.`id`
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
2 × 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
2 × SELECT extension_id AS id, element AS "option", params, enabled
FROM gzm4h_extensions
1 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,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
1 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM 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_acymailing_confi
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 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
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 id, rules
FROM `gzm4h_viewlevels
1 × SELECT b.id
FROM gzm4h_usergroups AS a
LEFT JOIN gzm4h_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
1 × SELECT `session_id`
FROM `gzm4h_session`
1 × SELECT folder AS type, element AS name, params
FROM gzm4h_extensions
1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM gzm4h_menu AS m
LEFT JOIN gzm4h_extensions AS e
ON m.component_id = e.extension_id
1 × SELECT `data`
FROM `gzm4h_session`
1 × SELECT *
FROM gzm4h_languages
1 × SELECT a.rules
FROM gzm4h_assets AS a
—Cuéntame un cuento —me ordena el hombre con barba que está sentado en el sofá de mi sala. Reconozco que la situación me resulta bastante incómoda, porque yo escribo cuentos, pero no soy un cuenta cuentos.
Además del mío, hay un único casamiento que nunca olvidaré: tuvo lugar en mi sala de estar. Sveta y Mark (no son sus nombres reales) vinieron una tarde, nerviosos y emocionados, solamente con su familia inmediata y la mía rodeándolos.
Siguiendo las contribuciones de Rabbi Sacks en la Conferencia de Herzliya de la semana pasada, el Jerusalem Post publicó un artículo el viernes en el que resume sus perspectivas sobre las amenazas crecientes generadas por el movimiento BDS.
Recuerdos de la visita del místico literario argentino a la Tierra Santa, y de su grado de sionismo.
Amenazas existenciales hace tiempo unieron a la diáspora e Israel. Ahora, cada vez más, son las amenazas existenciales –o las percepciones opuestas sobre las amenazas a la existencia – que nos separan profundamente.
La sombra del extremismo religioso se cierne sobre los debates acerca del código de vestimenta en las escuelas.
En una habitación en la Calle de los Alquimistas del barrio judío de Praga, un muchacho sentado en una silla se lleva un revólver al corazón.
Una cantante judía superviviente de los campos de concentración nazis que sale de ese tormento con el rostro desfigurado. Al acabar la guerra, la mujer se somete a una operación para que le reconstruyan el rostro.
Mientras las instituciones judías reciben una inusitada andanada, ¿qué pasa con la propia comunidad, con los propios judíos? ¿Qué procesos internos pudieron haber ayudado a la vulnerabilidad?
Vivimos en un mundo nuevo.