Tiempo de la consulta: 0.39 ms Consulta a la memoria: 0.015 MB memoria antes de la consulta: 0.823 MB Filas devueltas: 0
SELECT `data`
FROM `gzm4h_session`
WHERE `session_id` = '3lqqon1iujte9uv0tjm2599mp7'
| 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.2 ms |
| init | 0.0 ms |
| System lock | 0.0 ms |
| optimizing | 0.0 ms |
| statistics | 0.0 ms |
| executing | 0.0 ms |
| end | 0.0 ms |
| query end | 0.0 ms |
| closing tables | 0.0 ms |
| freeing items | 0.0 ms |
| cleaning up | 0.0 ms |
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.30 ms Después de la última consulta: 0.98 ms Consulta a la memoria: 0.008 MB memoria antes de la consulta: 0.878 MB
DELETE
FROM `gzm4h_session`
WHERE `time` < '1732344937'
| 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.1 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/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.16 ms Después de la última consulta: 0.13 ms Consulta a la memoria: 0.012 MB memoria antes de la consulta: 0.890 MB Filas devueltas: 0
SELECT `session_id`
FROM `gzm4h_session`
WHERE `session_id` = '3lqqon1iujte9uv0tjm2599mp7'
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.17 ms Después de la última consulta: 0.11 ms Consulta a la memoria: 0.009 MB memoria antes de la consulta: 0.902 MB
INSERT INTO `gzm4h_session`
(`session_id`, `client_id`, `time`)
VALUES
('3lqqon1iujte9uv0tjm2599mp7', 0, '1732345837')
'Explicar' no es posible en la consulta: INSERT INTO `gzm4h_session`
(`session_id`, `client_id`, `time`) VALUES
('3lqqon1iujte9uv0tjm2599mp7', 0, '1732345837')
| Status | Duration |
|---|
| starting | 0.0 ms |
| checking permissions | 0.0 ms |
| Opening tables | 0.0 ms |
| init | 0.0 ms |
| System lock | 0.0 ms |
| update | 0.1 ms |
| end | 0.0 ms |
| query end | 0.0 ms |
| closing tables | 0.0 ms |
| freeing items | 0.0 ms |
| cleaning up | 0.0 ms |
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: 0.50 ms Después de la última consulta: 0.77 ms Consulta a la memoria: 0.018 MB memoria antes de la consulta: 0.980 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.2 ms |
| init | 0.0 ms |
| System lock | 0.0 ms |
| optimizing | 0.0 ms |
| statistics | 0.0 ms |
| preparing | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 0.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.42 ms Después de la última consulta: 0.56 ms Consulta a la memoria: 0.014 MB memoria antes de la consulta: 1.038 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.2 ms |
| init | 0.0 ms |
| System lock | 0.0 ms |
| optimizing | 0.0 ms |
| statistics | 0.0 ms |
| preparing | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 0.0 ms |
| end | 0.0 ms |
| query end | 0.0 ms |
| closing tables | 0.0 ms |
| freeing items | 0.0 ms |
| cleaning up | 0.0 ms |
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: 0.27 ms Después de la última consulta: 0.22 ms Consulta a la memoria: 0.013 MB memoria antes de la consulta: 1.058 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.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: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: 0.43 ms Después de la última consulta: 0.19 ms Consulta a la memoria: 0.013 MB memoria antes de la consulta: 1.077 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.1 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.80 ms Después de la última consulta: 6.96 ms Consulta a la memoria: 0.028 MB memoria antes de la consulta: 1.597 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.2 ms |
| init | 0.0 ms |
| System lock | 0.0 ms |
| optimizing | 0.0 ms |
| statistics | 0.0 ms |
| preparing | 0.0 ms |
| Sorting result | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 0.0 ms |
| Creating sort index | 0.3 ms |
| end | 0.0 ms |
| query end | 0.0 ms |
| closing tables | 0.0 ms |
| freeing items | 0.0 ms |
| cleaning up | 0.0 ms |
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.21 ms Después de la última consulta: 1.91 ms Consulta a la memoria: 0.024 MB memoria antes de la consulta: 1.967 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.1 ms |
| preparing | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 0.0 ms |
| end | 0.0 ms |
| query end | 0.0 ms |
| closing tables | 0.0 ms |
| freeing items | 0.0 ms |
| cleaning up | 0.0 ms |
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.26 ms Después de la última consulta: 0.23 ms Consulta a la memoria: 0.017 MB memoria antes de la consulta: 1.974 MB
UPDATE `gzm4h_extensions`
SET `params` = '{\"mediaversion\":\"506ff843d94866d3dcf69f0dac6148f7\"}'
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.40 ms Después de la última consulta: 1.15 ms Consulta a la memoria: 0.013 MB memoria antes de la consulta: 2.100 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.2 ms |
| init | 0.0 ms |
| System lock | 0.0 ms |
| optimizing | 0.0 ms |
| statistics | 0.0 ms |
| preparing | 0.0 ms |
| Sorting result | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 0.0 ms |
| Creating sort index | 0.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.47 ms Después de la última consulta: 0.49 ms Consulta a la memoria: 0.010 MB memoria antes de la consulta: 2.121 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.2 ms |
| init | 0.0 ms |
| System lock | 0.0 ms |
| optimizing | 0.0 ms |
| statistics | 0.0 ms |
| preparing | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 0.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.40 ms Después de la última consulta: 8.74 ms Consulta a la memoria: 0.024 MB memoria antes de la consulta: 2.434 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 | 0.2 ms |
| init | 0.0 ms |
| System lock | 0.0 ms |
| optimizing | 0.0 ms |
| statistics | 0.0 ms |
| preparing | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 0.0 ms |
| end | 0.0 ms |
| query end | 0.0 ms |
| closing tables | 0.0 ms |
| freeing items | 0.0 ms |
| cleaning up | 0.0 ms |
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: 15.09 ms Después de la última consulta: 0.37 ms Consulta a la memoria: 0.025 MB memoria antes de la consulta: 2.467 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.1 ms |
| init | 0.0 ms |
| System lock | 0.0 ms |
| optimizing | 0.0 ms |
| statistics | 1.8 ms |
| preparing | 0.0 ms |
| Creating tmp table | 0.0 ms |
| Sorting result | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 13.0 ms |
| Creating sort index | 0.0 ms |
| end | 0.0 ms |
| query end | 0.0 ms |
| removing tmp table | 0.0 ms |
| query end | 0.0 ms |
| 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: 31.74 ms Después de la última consulta: 0.80 ms Consulta a la memoria: 0.031 MB memoria antes de la consulta: 2.530 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 | 0.4 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 | 3.0 ms |
| preparing | 0.0 ms |
| Creating tmp table | 0.0 ms |
| Sorting result | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 0.1 ms |
| Creating sort index | 27.3 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.61 ms Después de la última consulta: 0.81 ms Consulta a la memoria: 0.029 MB memoria antes de la consulta: 2.617 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.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/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: 44.02 ms Después de la última consulta: 0.28 ms Consulta a la memoria: 0.053 MB memoria antes de la consulta: 2.649 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-11-23 07:10:37')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-11-23 07:10:37')
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 420, 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 | 0.4 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.1 ms |
| Sorting result | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 3.4 ms |
| executing | 0.0 ms |
| Sending data | 0.1 ms |
| Creating sort index | 35.6 ms |
| Creating sort index | 3.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: 0.69 ms Después de la última consulta: 1.00 ms Consulta a la memoria: 0.029 MB memoria antes de la consulta: 2.892 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` = 1592
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.3 ms |
| init | 0.0 ms |
| System lock | 0.0 ms |
| optimizing | 0.0 ms |
| statistics | 0.1 ms |
| preparing | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 0.0 ms |
| end | 0.0 ms |
| query end | 0.0 ms |
| closing tables | 0.0 ms |
| freeing items | 0.0 ms |
| cleaning up | 0.0 ms |
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.23 ms Después de la última consulta: 0.45 ms Consulta a la memoria: 0.029 MB memoria antes de la consulta: 2.931 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` = 1591
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.23 ms Después de la última consulta: 0.39 ms Consulta a la memoria: 0.029 MB memoria antes de la consulta: 2.970 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` = 1590
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.1 ms |
| preparing | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 0.0 ms |
| end | 0.0 ms |
| query end | 0.0 ms |
| closing tables | 0.0 ms |
| freeing items | 0.0 ms |
| cleaning up | 0.0 ms |
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.22 ms Después de la última consulta: 0.36 ms Consulta a la memoria: 0.029 MB memoria antes de la consulta: 3.009 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` = 1587
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.20 ms Después de la última consulta: 0.38 ms Consulta a la memoria: 0.029 MB memoria antes de la consulta: 3.048 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` = 1586
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.20 ms Después de la última consulta: 0.35 ms Consulta a la memoria: 0.029 MB memoria antes de la consulta: 3.087 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` = 1585
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.19 ms Después de la última consulta: 0.39 ms Consulta a la memoria: 0.029 MB memoria antes de la consulta: 3.127 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` = 1584
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.20 ms Después de la última consulta: 0.35 ms Consulta a la memoria: 0.029 MB memoria antes de la consulta: 3.166 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` = 1582
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.19 ms Después de la última consulta: 0.35 ms Consulta a la memoria: 0.029 MB memoria antes de la consulta: 3.205 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` = 1581
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.21 ms Después de la última consulta: 0.34 ms Consulta a la memoria: 0.029 MB memoria antes de la consulta: 3.244 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` = 1579
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.44 ms Después de la última consulta: 6.12 ms Consulta a la memoria: 0.024 MB memoria antes de la consulta: 3.281 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-11-23 07:10:37')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-11-23 07:10:37')
| 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.0 ms |
| preparing | 0.0 ms |
| Creating tmp table | 0.0 ms |
| Sorting result | 0.0 ms |
| statistics | 0.1 ms |
| preparing | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 0.1 ms |
| executing | 0.0 ms |
| Sending data | 0.1 ms |
| Creating sort index | 9.7 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.25 ms Después de la última consulta: 0.33 ms Consulta a la memoria: 0.026 MB memoria antes de la consulta: 3.288 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.02 ms Después de la última consulta: 7.12 ms Consulta a la memoria: 0.038 MB memoria antes de la consulta: 3.641 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.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 | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 0.1 ms |
| Creating sort index | 0.3 ms |
| Creating sort index | 0.0 ms |
| end | 0.0 ms |
| query end | 0.0 ms |
| removing tmp table | 0.0 ms |
| query end | 0.0 ms |
| removing tmp table | 0.0 ms |
| query end | 0.0 ms |
| closing tables | 0.0 ms |
| removing tmp table | 0.0 ms |
| closing tables | 0.0 ms |
| freeing items | 0.0 ms |
| cleaning up | 0.0 ms |
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: 0.92 ms Después de la última consulta: 11.12 ms Consulta a la memoria: 0.021 MB memoria antes de la consulta: 3.785 MB Filas devueltas: 4
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM gzm4h_modules AS m
LEFT JOIN gzm4h_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN gzm4h_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
WHERE m.published = 1
AND e.enabled = 1
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2024-11-23 07:10:37')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-11-23 07:10:37')
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.3 ms |
| init | 0.0 ms |
| System lock | 0.0 ms |
| optimizing | 0.0 ms |
| statistics | 0.1 ms |
| preparing | 0.0 ms |
| Sorting result | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 0.0 ms |
| Creating sort index | 0.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: 11.66 ms Después de la última consulta: 3.87 ms Consulta a la memoria: 0.031 MB memoria antes de la consulta: 3.905 MB Filas devueltas: 0
SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore,
CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published,
CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
FROM gzm4h_content AS a
LEFT JOIN gzm4h_content_frontpage AS fp
ON fp.content_id = a.id
LEFT JOIN gzm4h_categories AS c
ON c.id = a.catid
LEFT JOIN gzm4h_users AS ua
ON ua.id = a.created_by
LEFT JOIN gzm4h_users AS uam
ON uam.id = a.modified_by
LEFT JOIN gzm4h_categories as parent
ON parent.id = c.parent_id
LEFT JOIN gzm4h_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM gzm4h_categories AS cat JOIN gzm4h_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id ) AS badcats
ON badcats.id = c.id
WHERE
CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-11-23 07:10:37')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-11-23 07:10:37')
AND a.created >= DATE_SUB('2024-11-23 07:10:37', 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 | 2.3 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| Opening tables | 0.0 ms |
| init | 0.1 ms |
| System lock | 0.0 ms |
| optimizing | 0.0 ms |
| optimizing | 0.0 ms |
| statistics | 0.0 ms |
| preparing | 0.0 ms |
| Creating tmp table | 0.0 ms |
| Sorting result | 0.0 ms |
| statistics | 0.0 ms |
| preparing | 0.0 ms |
| Creating tmp table | 0.0 ms |
| Sorting result | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 6.7 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.41 ms Después de la última consulta: 11.22 ms Consulta a la memoria: 0.019 MB memoria antes de la consulta: 4.354 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.2 ms |
| init | 0.0 ms |
| System lock | 0.0 ms |
| optimizing | 0.0 ms |
| statistics | 0.0 ms |
| preparing | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 0.0 ms |
| end | 0.0 ms |
| query end | 0.0 ms |
| closing tables | 0.0 ms |
| freeing items | 0.0 ms |
| cleaning up | 0.0 ms |
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.52 ms Después de la última consulta: 5.04 ms Consulta a la memoria: 0.003 MB memoria antes de la consulta: 4.478 MB
UPDATE `gzm4h_session`
SET `data` = '__default|a:8:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1732345837;s:18:\"session.timer.last\";i:1732345837;s:17:\"session.timer.now\";i:1732345837;s:24:\"session.client.forwarded\";s:12:\"18.189.143.1\";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` = '1732345837'
WHERE `session_id` = '3lqqon1iujte9uv0tjm2599mp7'
| 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
Las festividades judías se acercan. Significa que sé que te voy a ver en la sinagoga pronto. Vamos a decir "Hola, ¿cómo estás? O saludar a la distancia. Vas a comentar sobre lo altos que están mis hijos y te voy a preguntar cómo le va a tu hija en la facultad. Luego nos vamos a volver a ver el año que viene.
Elul se asoma, y este mes nos presenta enormes posibilidades de teshuva, o arrepentimiento.
Las historias minimalistas y comics de Etgar Keret han ganado muchos lectores en Israel, Polonia, Hungría, China, Estados Unidos y otra docena de países. En Octubre de 2012, Keret visitó Riga, donde conoció a los lectores de su libro de cuentos "El conductor de Ómnibus que quería ser Dios y Otras Historias". Luego visitó la residencia del embajador israelí.
¿Por qué los judíos de la Diáspora quieren más al Judaísmo que los judíos de Israel?
La idea de un "pueblo elegido" es uno de los conceptos más controversiales del judaísmo, y también uno de los más básicos. Es articulado claramente en la Tora y repetido incontables veces en nuestras plegarias. Probablemente el ejemplo más conocido es lo que se recita cuando una persona hace "alia" a la Tora: "...nos eligió de entre todos los pueblos y nos entregó la Tora."
Carlo Strenger dice que Netanyahu cree que Israel está en el medio de un choque de civilizaciones entre el Occidente y el Islam.
Dice Parashat Shoftim, en uno de sus párrafos más destacados:
Escritor y Director, 77; nueva York
Los dos nuevos Rabinos Jefes del Rabinato, David Lau y Yizhak Yosef, han prometido ser los representantes espirituales de todos los judíos israelíes. No puedo hablar por los demás, pero le puedo decir a los honorables rabinos: Ustedes no me representan. No tengo Rabino Jefe.