Ya se cumplieron dos semanas desde el secuestro de los jovencitos israelíes, Gil-Ad Shaer (16), Naftali Fraenkel (16) y Eyal Ifrah (19). Israel continúa buscándolos, entrando en casas particulares, rastreando todo tipo de potenciales escondites, vaciando pozos de agua..y por ahora...nada. Ni vivos..ni muertos.
Este hecho y varios más de los últimos días, requerirían ríos de tinta para decir todo lo que debe ser dicho. Pues trataremos aquí, con puntos muy concretos, de resumir lo que nos aprieta el corazón y la mente.
• El secuestro fue un atentado terrorista contra civiles inocentes, por más que haya sido cometido en una zona en disputa, que Israel sostiene que es suya y los palestinos afirman que les corresponde a ellos. Fue un atentado por más que uno de los chicos viva en un asentamiento, tema de discusión no sólo afuera sino, lo más importante, dentro de Israel. Sería un acto terrorista también si los tres secuestrados fueran colonos, tal cual se llama a los judíos residentes en los asentamientos.
• Lo que puede ser discutido a nivel político, y en la mesa de negociaciones, es si es legítimo, legal, sabio, lógico, que haya asentamientos y que allí viva población israelí. La mitad de la población de Israel piensa que sí. La otra, a grandes rasgos, considera que no. Pero lo que no hay derecho a discutir, es si alguien tiene derecho a matarlos o atentar contra ellos por estar allí. Pues no. Eso , en un mundo normal, es terrorismo.
• Hablando de mundo normal...¿dónde está? ¿Dónde está la empatía con las tres madres que fueron al Consejo de Derechos Humanos de la ONU a pedir por sus hijos? Estaban todos preocupados por el operativo militar israelí lanzado para buscar a los chicos...
• Tampoco a nosotros nos gusta el operativo. Nos preocupa que se haya vuelto a esa dinámica. Muy especialmente, nos preocupa el hecho que hayan muerto cinco palestinos en estas dos semanas de rastreos, durante incidentes con el ejército, entre ellos un niño.
• Y nos preguntamos si existe acaso una fórmula sabia que permita lidiar con el terrorismo, sin arriesgar a no involucrados.
• Y pensamos que las tropas no habían entrado a territorio controlado por la Autoridad Palestina, si no hubieran sido secuestrados los muchachos. ¿Qué esperaba el mundo? ¿Que los busquen a larga distancia?
• Continúa el fenómeno de "los tres dedos", esas imágenes de palestinos fotografiándose orgullosos haciendo una señal con tres dedos, por el "logro" de haber secuestrado a tres israelíes. La semana pasada publicamos una serie de esas fotos. Luego la periodista Anat Saragusti de "Haaretz" aclaró en Facebook que parte de las fotos tomadas de las redes sociales, se habían originado cuando el famoso cantante de Gaza Muhammad Assaf, estaba compitiendo en el concurso de la canción "The Arab Idol" y era el número 3, por el que todos sus connacionales, como es lógico, votaban. Pues nuestras disculpas si intercalamos imágenes equivocadas que databan de aquella competencia .La intención, evidentemente, no era difamar injustamente a nadie. Lamentablemente, el fenómeno de los palestinos sonrientes con la señal de los tres dedos, no ha desaparecido. Hasta estudiantes recién graduados en la universidad A Najah en Nablus, hace pocos días, se fotografiaron felices, junto a banderas de Hamas, haciendo esa señal.
• Al pasar dos semanas del secuestro, es inevitable pensar en Guilad Shalit que recuperó su libertad cinco años después de caer en manos de Hamas...y tuvo la suerte de quedar con vida. Su nombre volvió a resonar esta semana en un marco especialmente problemático, al revelarse que había sido encontrada la célula terrorista que en la víspera de la noche de Pesaj, en abril, había dado muerte a Baruj Mizraji, un policía israelí, no en misión de asalto a ningún lado, sino cuando viajaba junto a su familia , su esposa y cuatro de sus cinco hijos, a la cena del Seder.La esposa resultó herida pero logró alejar el auto del lugar y así se salvó y salvó a sus hijos.
El asesino, según se reveló, había sido liberado de prisión como uno de los 1027 excarcelados a cambio de Guilad Shalit.
• El terrorista , Ziad Awad de Hamas, de la aldea Idna, que había sido encarcelado por el asesinato de palestinos sospechosos de colaborar con Israel, volvió poco después de salir de prisión en octubre del 2011, al terrorismo. Con la ayuda de su hijo de 18 años, al que enseñó: "El Islam nos indica que quien mate a un judío, va al paraíso".Y cuando le preguntaron por qué disparó al coche de Mizraji cuando aún no había oscurecido, en lugar de cometer un ataque de noche, respondió: "Quería estar seguro de que disparaba a judíos".
• Bien saben los lectores de estas páginas, que defendemos la necesidad de hallar una solución negociada con los palestinos, que incluya retiradas , a fin de hacer posible una separación entre israelíes y palestinos.Pero aún así, no podemos dejar de preguntarnos si acaso a terroristas como ese, con la cita que acabamos de reproducir, le cambia algo dónde esté el judío de turno.
• Ahora, que no le salten a Guilad Shalit. Claro que sus padres presionaron para que se acepte una transacción, un intercambio, a fin de salvar a su hijo.¿Algún padre haría otra cosa? Al mismo tiempo, es responsabilidad de los gobernantes decidir.Y en la balanza, tanto entonces como ahora o en el futuro, estarán dos intereses y valores contradictorios: por un lado, la responsabilidad de devolver a los hijos a casa, y por otro, la responsabilidad de no crear la situación que incentive, en el futuro, nuevos secuestros, al ver que funcionan y con ellos se logra liberar terroristas. Es fácil criticar...no sabemos qué haríamos si estuviéramos en los difíciles zapatos de quienes deben decidir.
• Otra figura a quien no envidiamos estos días, cuando de decisiones se trata, es el Presidente de la Autoridad Nacional Palestina. Actuó con valentía al hablar en Arabia Saudita hace una semana, contra el secuestro y acusando a los responsables de querer destruir a los palestinos. Exigió devolver a los chicos a sus casas. Eso le hizo "merecer" una ola de ataques de sus propios connacionales. La Autoridad Palestina merece por cierto no pocas críticas de la población. A nuestro criterio, este no debería ser uno de los casos. ¿Sería acaso mucho pedir que los palestinos mismos comprendan que el secuestro u otro tipo de atentados, los perjudican a ellos mismos, no sólo a Israel? Abbas lo comprendió hace rato y por eso se opone al terrorismo.Que no sea por amor a Israel.Que sea simplemente por comprender que no sirve a los intereses palestinos. Y ahora, es vilipendiado por su gente. Mala elección.
• A todo ésto...continúan cayendo cohetes en Israel. Todos los días, alarmas en el sur. Y si varios fueron interceptados por la batería anti misiles Cúpula de Hierro, quiere decir que el radar captó que estaban encaminándose a zonas pobladas..No iban a caer en zonas descampadas, sino en casas de gente. De lo contrario, la batería no funciona. Así lo determina su "cerebro".Israel responde atacando objetivos de los grupos radicales en Gaza.
• El significado de los cohetes lo captó en carne propia, esta vez, una familia palestina, cuya pequeña de tres años murió por un mortero que por error, no alcanzó a cruzar a Israel y cayó antes de pasar la frontera, sobre la localidad palestina de Bet Lahia.
• Lo central es la muerte de la pequeña Khun al-Danaf. Otros cinco miembros de su misma familia resultaron heridos.Pero también nos resulta inevitable preguntarnos cómo habría reaccionado el mundo si el proyectil hubiese sido disparado por Israel.Es que no nos parece reprobable en absoluto que se critique y condene la muerte de inocentes . Lo que repugna es que eso dependa de la cédula de identidad de quien disparó.
• Esto nos hizo acordar del caso de George Khoury, un estudiante palestino, árabe cristiano de Jerusalem, que fue asesinado un viernes por la noche cuando corría por el barrio Guiva Tsarfatit de la ciudad, por terroristas que luego lo quisieron declarar "mártir" y dijeron "perdón, pensamos que era judío".
Fuente: Semanario Hebreo
SELECT `data`
FROM `gzm4h_session`
WHERE `session_id` = 'iklpph4d6jspjeid47vnjdfku0'
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 |
DELETE
FROM `gzm4h_session`
WHERE `time` < '1732300443'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | DELETE | gzm4h_session | NULL | range | time | time | 45 | const | 1 | 100.00 | Using where |
Status | Duration |
---|---|
starting | 0.0 ms |
checking permissions | 0.0 ms |
Opening tables | 0.0 ms |
init | 0.0 ms |
System lock | 0.0 ms |
updating | 0.1 ms |
end | 0.0 ms |
query end | 0.1 ms |
closing tables | 0.0 ms |
freeing items | 0.0 ms |
cleaning up | 0.0 ms |
SELECT `session_id`
FROM `gzm4h_session`
WHERE `session_id` = 'iklpph4d6jspjeid47vnjdfku0'
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 |
INSERT INTO `gzm4h_session` (`session_id`, `client_id`, `time`)
VALUES ('iklpph4d6jspjeid47vnjdfku0', 0, '1732301343')
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.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 |
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 |
SELECT b.id
FROM gzm4h_usergroups AS a
LEFT JOIN gzm4h_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 9
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | a | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
1 | SIMPLE | b | NULL | range | idx_usergroup_nested_set_lookup | idx_usergroup_nested_set_lookup | 4 | NULL | 2 | 100.00 | Using where; Using index |
Status | Duration |
---|---|
starting | 0.0 ms |
checking permissions | 0.0 ms |
checking permissions | 0.0 ms |
Opening tables | 0.1 ms |
init | 0.0 ms |
System lock | 0.0 ms |
optimizing | 0.0 ms |
statistics | 0.0 ms |
preparing | 0.0 ms |
executing | 0.0 ms |
Sending data | 0.0 ms |
end | 0.0 ms |
query end | 0.0 ms |
closing tables | 0.0 ms |
freeing items | 0.0 ms |
cleaning up | 0.0 ms |
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 |
SELECT folder AS type, element AS name, params
FROM gzm4h_extensions
WHERE enabled = 1
AND type ='plugin'
AND state IN (0,1)
AND access IN (1,1,5)
ORDER BY ordering
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | gzm4h_extensions | NULL | ref | extension | extension | 62 | const | 68 | 0.60 | Using index condition; Using where; Usando 'filesort' |
Status | Duration |
---|---|
starting | 0.0 ms |
checking permissions | 0.0 ms |
Opening tables | 0.0 ms |
init | 0.0 ms |
System lock | 0.0 ms |
optimizing | 0.0 ms |
statistics | 0.0 ms |
preparing | 0.0 ms |
Sorting result | 0.0 ms |
executing | 0.0 ms |
Sending data | 0.0 ms |
Creating sort index | 0.2 ms |
end | 0.0 ms |
query end | 0.0 ms |
closing tables | 0.0 ms |
freeing items | 0.0 ms |
cleaning up | 0.0 ms |
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.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 |
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 |
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=1793
AND badcats.id is null
GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version
ORDER BY c.lft
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | PRIMARY | NULL | NULL | NULL | NULL | No pudo usarse una clave de índice | NULL | NULL | NULL | NULL | no matching row in const table |
2 | DERIVED | parent | NULL | range | cat_idx,idx_left_right | cat_idx | 153 | NULL | 5 | 100.00 | Using index condition; Using temporary; Usando 'filesort' |
2 | DERIVED | cat | NULL | index | PRIMARY,cat_idx,idx_access,idx_checkout,idx_path,idx_left_right,idx_alias,idx_language | idx_left_right | 8 | NULL | 37 | 11.11 | Using where; Using index; Using join buffer (Block Nested Loop) |
Status | Duration |
---|---|
starting | 0.1 ms |
checking permissions | 0.0 ms |
checking permissions | 0.0 ms |
checking permissions | 0.0 ms |
checking permissions | 0.0 ms |
Opening tables | 0.3 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 |
executing | 0.0 ms |
end | 0.0 ms |
query end | 0.0 ms |
removing tmp table | 0.0 ms |
query end | 0.0 ms |
closing tables | 0.0 ms |
removing tmp table | 0.0 ms |
closing tables | 0.0 ms |
freeing items | 0.0 ms |
cleaning up | 0.0 ms |
SELECT `alias`,`catid`
FROM `gzm4h_content`
WHERE `id` = 1793
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | gzm4h_content | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
Status | Duration |
---|---|
starting | 0.0 ms |
checking permissions | 0.0 ms |
Opening tables | 0.1 ms |
init | 0.0 ms |
System lock | 0.0 ms |
optimizing | 0.0 ms |
statistics | 0.0 ms |
preparing | 0.0 ms |
executing | 0.0 ms |
Sending data | 0.0 ms |
end | 0.0 ms |
query end | 0.0 ms |
closing tables | 0.0 ms |
freeing items | 0.0 ms |
cleaning up | 0.0 ms |
SELECT extension_id AS id, element AS "option", params, enabled
FROM gzm4h_extensions
WHERE `type` = 'library'
AND `element` = 'joomla'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | gzm4h_extensions | NULL | ref | element_clientid,element_folder_clientid,extension | extension | 364 | const,const | 1 | 100.00 | NULL |
Status | Duration |
---|---|
starting | 0.0 ms |
checking permissions | 0.0 ms |
Opening tables | 0.0 ms |
init | 0.0 ms |
System lock | 0.0 ms |
optimizing | 0.0 ms |
statistics | 0.0 ms |
preparing | 0.0 ms |
executing | 0.0 ms |
Sending data | 0.0 ms |
end | 0.0 ms |
query end | 0.0 ms |
closing tables | 0.0 ms |
freeing items | 0.0 ms |
cleaning up | 0.0 ms |
UPDATE `gzm4h_extensions`
SET `params` = '{\"mediaversion\":\"512e788d192518e4fb7ea76359a60353\"}'
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 |
SELECT alias
FROM gzm4h_content
WHERE id=1793
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | gzm4h_content | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
Status | Duration |
---|---|
starting | 0.0 ms |
checking permissions | 0.0 ms |
Opening tables | 0.0 ms |
init | 0.0 ms |
System lock | 0.0 ms |
optimizing | 0.0 ms |
statistics | 0.0 ms |
preparing | 0.0 ms |
executing | 0.0 ms |
Sending data | 0.0 ms |
end | 0.0 ms |
query end | 0.0 ms |
closing tables | 0.0 ms |
freeing items | 0.0 ms |
cleaning up | 0.0 ms |
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 |
SELECT *
FROM gzm4h_languages
WHERE published=1
ORDER BY ordering ASC
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | gzm4h_languages | NULL | ALL | NULL | No pudo usarse una clave de índice | NULL | NULL | 1 | 100.00 | Using where; Usando 'filesort' |
Status | Duration |
---|---|
starting | 0.0 ms |
checking permissions | 0.0 ms |
Opening tables | 0.1 ms |
init | 0.0 ms |
System lock | 0.0 ms |
optimizing | 0.0 ms |
statistics | 0.0 ms |
preparing | 0.0 ms |
Sorting result | 0.0 ms |
executing | 0.0 ms |
Sending data | 0.0 ms |
Creating sort index | 0.0 ms |
end | 0.0 ms |
query end | 0.0 ms |
closing tables | 0.0 ms |
freeing items | 0.0 ms |
cleaning up | 0.0 ms |
SELECT id, home, template, s.params
FROM gzm4h_template_styles as s
LEFT JOIN gzm4h_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
WHERE s.client_id = 0
AND e.enabled = 1
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | s | NULL | ALL | idx_template | No pudo usarse una clave de índice | NULL | NULL | 5 | 20.00 | Using where |
1 | SIMPLE | e | NULL | ref | element_clientid,element_folder_clientid,extension | element_clientid | 303 | tryit_tumeser1_new.s.template,const | 1 | 4.67 | Using index condition; Using where |
Status | Duration |
---|---|
starting | 0.0 ms |
checking permissions | 0.0 ms |
checking permissions | 0.0 ms |
Opening tables | 0.1 ms |
init | 0.0 ms |
System lock | 0.0 ms |
optimizing | 0.0 ms |
statistics | 0.0 ms |
preparing | 0.0 ms |
executing | 0.0 ms |
Sending data | 0.1 ms |
end | 0.0 ms |
query end | 0.0 ms |
closing tables | 0.0 ms |
freeing items | 0.0 ms |
cleaning up | 0.0 ms |
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.1 ms |
init | 0.0 ms |
System lock | 0.0 ms |
optimizing | 0.0 ms |
statistics | 0.0 ms |
preparing | 0.5 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 |
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.0 ms |
preparing | 0.0 ms |
Creating tmp table | 0.0 ms |
Sorting result | 0.0 ms |
executing | 0.0 ms |
Sending data | 0.1 ms |
Creating sort index | 0.0 ms |
end | 0.0 ms |
query end | 0.0 ms |
removing tmp table | 0.0 ms |
query end | 0.0 ms |
closing tables | 0.0 ms |
freeing items | 0.0 ms |
cleaning up | 0.0 ms |
SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext,
CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
FROM gzm4h_content AS a
LEFT JOIN gzm4h_categories AS c
on c.id = a.catid
LEFT JOIN gzm4h_users AS u
on u.id = a.created_by
LEFT JOIN gzm4h_categories as parent
ON parent.id = c.parent_id
LEFT JOIN gzm4h_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM gzm4h_categories AS cat JOIN gzm4h_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published <= 0
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
WHERE a.id = 1793
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-11-22 18:49:03')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-11-22 18:49:03')
AND (a.state = 1 OR a.state =2)
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | PRIMARY | a | NULL | const | PRIMARY,idx_state | PRIMARY | 4 | const | 1 | 100.00 | NULL |
1 | PRIMARY | c | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
1 | PRIMARY | u | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
1 | PRIMARY | parent | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
1 | PRIMARY | v | NULL | const | PRIMARY | PRIMARY | 4 | const | 0 | 0.00 | unique row not found |
1 | PRIMARY | <derived2> | NULL | ref | <auto_key0> | <auto_key0> | 4 | const | 1 | 100.00 | Using index |
2 | DERIVED | parent | NULL | range | cat_idx,idx_left_right | cat_idx | 153 | NULL | 4 | 100.00 | Using index condition; Using temporary; Usando 'filesort' |
2 | DERIVED | cat | NULL | index | PRIMARY,cat_idx,idx_access,idx_checkout,idx_path,idx_left_right,idx_alias,idx_language | idx_left_right | 8 | NULL | 37 | 11.11 | Using where; Using index; Using join buffer (Block Nested Loop) |
Status | Duration |
---|---|
starting | 0.1 ms |
checking permissions | 0.0 ms |
checking permissions | 0.0 ms |
checking permissions | 0.0 ms |
checking permissions | 0.0 ms |
checking permissions | 0.0 ms |
checking permissions | 0.0 ms |
checking permissions | 0.0 ms |
Opening tables | 0.2 ms |
init | 0.1 ms |
System lock | 0.0 ms |
optimizing | 0.0 ms |
optimizing | 0.0 ms |
statistics | 0.0 ms |
preparing | 0.0 ms |
Creating tmp table | 0.0 ms |
Sorting result | 0.0 ms |
statistics | 0.1 ms |
preparing | 0.0 ms |
executing | 0.0 ms |
Sending data | 0.0 ms |
executing | 0.0 ms |
Sending data | 0.1 ms |
Creating sort index | 0.0 ms |
end | 0.0 ms |
query end | 0.0 ms |
removing tmp table | 0.0 ms |
query end | 0.0 ms |
closing tables | 0.0 ms |
removing tmp table | 0.0 ms |
closing tables | 0.0 ms |
freeing items | 0.0 ms |
cleaning up | 0.0 ms |
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` = 1793
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 |
SHOW FULL COLUMNS
FROM `gzm4h_content`
Status | Duration |
---|---|
starting | 0.0 ms |
checking permissions | 0.0 ms |
checking permissions | 0.0 ms |
Opening tables | 0.1 ms |
init | 0.0 ms |
System lock | 0.0 ms |
optimizing | 0.0 ms |
statistics | 0.0 ms |
preparing | 0.0 ms |
executing | 0.0 ms |
Opening tables | 0.0 ms |
checking permissions | 0.0 ms |
checking permissions | 0.0 ms |
checking permissions | 0.0 ms |
checking permissions | 0.0 ms |
checking permissions | 0.0 ms |
checking permissions | 0.0 ms |
checking permissions | 0.0 ms |
checking permissions | 0.0 ms |
checking permissions | 0.0 ms |
checking permissions | 0.0 ms |
checking permissions | 0.0 ms |
checking permissions | 0.0 ms |
checking permissions | 0.0 ms |
checking permissions | 0.0 ms |
checking permissions | 0.0 ms |
checking permissions | 0.0 ms |
checking permissions | 0.0 ms |
checking permissions | 0.0 ms |
checking permissions | 0.0 ms |
checking permissions | 0.0 ms |
checking permissions | 0.0 ms |
checking permissions | 0.0 ms |
checking permissions | 0.0 ms |
checking permissions | 0.0 ms |
checking permissions | 0.0 ms |
checking permissions | 0.0 ms |
checking permissions | 0.0 ms |
checking permissions | 0.0 ms |
checking permissions | 0.0 ms |
checking permissions | 0.0 ms |
Sending data | 0.1 ms |
end | 0.0 ms |
query end | 0.0 ms |
closing tables | 0.0 ms |
removing tmp table | 0.0 ms |
closing tables | 0.0 ms |
freeing items | 0.0 ms |
cleaning up | 0.0 ms |
SELECT *
FROM gzm4h_content
WHERE `id` = '1793'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | gzm4h_content | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
Status | Duration |
---|---|
starting | 0.0 ms |
checking permissions | 0.0 ms |
Opening tables | 0.0 ms |
init | 0.0 ms |
System lock | 0.0 ms |
optimizing | 0.0 ms |
statistics | 0.0 ms |
preparing | 0.0 ms |
executing | 0.0 ms |
Sending data | 0.0 ms |
end | 0.0 ms |
query end | 0.0 ms |
closing tables | 0.0 ms |
freeing items | 0.0 ms |
cleaning up | 0.0 ms |
UPDATE gzm4h_content
SET `hits` = (`hits` + 1)
WHERE `id` = '1793'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | UPDATE | gzm4h_content | NULL | range | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | Using where |
Status | Duration |
---|---|
starting | 0.0 ms |
checking permissions | 0.0 ms |
Opening tables | 0.0 ms |
init | 0.0 ms |
System lock | 0.0 ms |
updating | 0.0 ms |
end | 0.0 ms |
query end | 0.0 ms |
closing tables | 0.0 ms |
freeing items | 0.0 ms |
cleaning up | 0.0 ms |
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-22 18:49:03')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-11-22 18:49:03')
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.2 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.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 |
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-22 18:49:03')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-11-22 18:49:03')
AND a.created >= DATE_SUB('2024-11-22 18:49:03', 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.2 ms |
init | 0.1 ms |
System lock | 0.0 ms |
optimizing | 0.0 ms |
optimizing | 0.0 ms |
statistics | 0.0 ms |
preparing | 0.0 ms |
Creating tmp table | 0.0 ms |
Sorting result | 0.0 ms |
statistics | 0.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 |
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 |
UPDATE `gzm4h_session`
SET `data` = '__default|a:8:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1732301343;s:18:\"session.timer.last\";i:1732301343;s:17:\"session.timer.now\";i:1732301343;s:24:\"session.client.forwarded\";s:10:\"3.16.47.89\";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` = '1732301343'
WHERE `session_id` = 'iklpph4d6jspjeid47vnjdfku0'
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 |
2 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM gzm4h_categories as c
LEFT JOIN gzm4h_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM gzm4h_categories AS cat JOIN gzm4h_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
2 × SELECT extension_id AS id, element AS "option", params, enabled
FROM gzm4h_extensions
1 × SELECT a.rules
FROM gzm4h_assets AS a
1 × SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext,
CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
FROM gzm4h_content AS a
LEFT JOIN gzm4h_categories AS c
on c.id = a.catid
LEFT JOIN gzm4h_users AS u
on u.id = a.created_by
LEFT JOIN gzm4h_categories as parent
ON parent.id = c.parent_id
LEFT JOIN gzm4h_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM gzm4h_categories AS cat JOIN gzm4h_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
1 × SELECT b.rules
FROM gzm4h_assets AS a
LEFT JOIN gzm4h_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
1 × SELECT `m`.`tag_id`,`t`.*
FROM `gzm4h_contentitem_tag_map` AS m
INNER JOIN `gzm4h_tags` AS t
ON `m`.`tag_id` = `t`.`id`
1 × SELECT *
FROM gzm4h_content
1 × SELECT *
FROM gzm4h_acymailing_confi
1 × SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore,
CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published,
CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
FROM gzm4h_content AS a
LEFT JOIN gzm4h_content_frontpage AS fp
ON fp.content_id = a.id
LEFT JOIN gzm4h_categories AS c
ON c.id = a.catid
LEFT JOIN gzm4h_users AS ua
ON ua.id = a.created_by
LEFT JOIN gzm4h_users AS uam
ON uam.id = a.modified_by
LEFT JOIN gzm4h_categories as parent
ON parent.id = c.parent_id
LEFT JOIN gzm4h_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM gzm4h_categories AS cat JOIN gzm4h_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM gzm4h_modules AS m
LEFT JOIN gzm4h_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN gzm4h_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
1 × SELECT id, 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 alias
FROM gzm4h_content
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 `alias`,`catid`
FROM `gzm4h_content`
1 × SELECT *
FROM gzm4h_languages
1 × UPDATE gzm4h_content
SET `hits` = (`hits` + 1)
1 × UPDATE `gzm4h_session`
SET `data` = '__default|a:8:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1732301343;s:18:\"session.timer.last\";i:1732301343;s:17:\"session.timer.now\";i:1732301343;s:24:\"session.client.forwarded\";s:10:\"3.16.47.89\";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` = '1732301343'
1 × SHOW FULL COLUMNS
FROM `gzm4h_content
1 × UPDATE `gzm4h_extensions`
SET `params` = '{\"mediaversion\":\"512e788d192518e4fb7ea76359a60353\"}'
1 × INSERT INTO `gzm4h_session` (`session_id`, `client_id`, `time`)
VALUES ('iklpph4d6jspjeid47vnjdfku0', 0, '1732301343'
1 × DELETE
FROM `gzm4h_session`