Consola de Joomla! Debug
session.client.forwarded ⇒ 34.228.52.21
session.client.browser ⇒ CCBot/2.0 (https://commoncrawl.org/faq/)
password_clear ⇒
groups ⇒
session.token ⇒ 0bb0b046eace31ce6f5938a9c8120020
Application 0.001 seconds (+0.001); 0.35 MB (+0.349) - afterLoad
Application 0.052 seconds (+0.051); 1.63 MB (+1.282) - afterInitialise
Application 0.082 seconds (+0.030); 2.25 MB (+0.622) - afterRoute
Application 0.316 seconds (+0.234); 4.36 MB (+2.105) - afterDispatch
Application 0.325 seconds (+0.009); 4.53 MB (+0.174) - beforeRenderModule mod_menufooter (Menu footer)
Application 0.332 seconds (+0.006); 4.61 MB (+0.075) - afterRenderModule mod_menufooter (Menu footer)
Application 0.332 seconds (+0.001); 4.53 MB (-0.075) - beforeRenderModule mod_zooitem (Microsites (zona globaldit))
Application 0.429 seconds (+0.096); 5.15 MB (+0.615) - afterRenderModule mod_zooitem (Microsites (zona globaldit))
Application 0.432 seconds (+0.003); 5.11 MB (-0.034) - beforeRenderModule mod_menu (Menú secundario)
Application 0.435 seconds (+0.003); 5.15 MB (+0.034) - afterRenderModule mod_menu (Menú secundario)
Application 0.437 seconds (+0.002); 5.12 MB (-0.021) - beforeRenderModule mod_menu (Menú Principal)
Application 0.439 seconds (+0.003); 5.20 MB (+0.080) - afterRenderModule mod_menu (Menú Principal)
Application 0.440 seconds (+0.001); 5.10 MB (-0.100) - beforeRenderModule mod_compartir (Compartir)
Application 0.441 seconds (+0.001); 5.11 MB (+0.009) - afterRenderModule mod_compartir (Compartir)
Application 0.443 seconds (+0.001); 5.14 MB (+0.025) - beforeRenderModule mod_search (Buscador (header))
Application 0.444 seconds (+0.001); 5.16 MB (+0.017) - afterRenderModule mod_search (Buscador (header))
Application 0.444 seconds (+0.000); 5.13 MB (-0.030) - beforeRenderModule mod_contact (Contacto)
Application 0.522 seconds (+0.078); 6.35 MB (+1.223) - afterRenderModule mod_contact (Contacto)
Application 0.528 seconds (+0.006); 6.38 MB (+0.034) - afterRender
6.41 MB (6,724,600 Bytes)
187 Registro Consultas
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 d4xh9_menu AS m
LEFT JOIN d4xh9_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.lftSELECT id
FROM d4xh9_zoo_item
WHERE alias = 'un-ovni-bajo-el-popo-2'
LIMIT 1SELECT joomlatablename,tablepkID
FROM `d4xh9_falang_tableinfo`SELECT *
FROM d4xh9_languages
ORDER BY orderingSHOW FULL COLUMNS
FROM `d4xh9_languages`SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
FROM d4xh9_falang_content AS falang_content
WHERE falang_content.language_id=3
AND falang_content.published=1
AND falang_content.reference_id IN(1745)
AND falang_content.reference_table='zoo_item'SELECT *
FROM d4xh9_zoo_item
WHERE id = 1745SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
FROM d4xh9_falang_content AS falang_content
WHERE falang_content.language_id=3
AND falang_content.published=1
AND falang_content.reference_id IN(1745)
AND falang_content.reference_table='zoo_item'SELECT *
FROM d4xh9_zoo_application
WHERE id = 17SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
FROM d4xh9_falang_content AS falang_content
WHERE falang_content.language_id=3
AND falang_content.published=1
AND falang_content.reference_id IN(17)
AND falang_content.reference_table='zoo_application'SELECT a.rules
FROM d4xh9_assets AS a
WHERE (a.id = 1)
GROUP BY a.id, a.rules, a.lftSHOW FULL COLUMNS
FROM `d4xh9_assets`SELECT id
FROM d4xh9_assets
WHERE parent_id = 0SELECT b.rules
FROM d4xh9_assets AS a
LEFT JOIN d4xh9_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE (a.id = 1 OR a.parent_id=0)
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lftSELECT *
FROM d4xh9_zoo_category
WHERE application_id = 17
AND published = 1
ORDER BY orderingSELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
FROM d4xh9_falang_content AS falang_content
WHERE falang_content.language_id=3
AND falang_content.published=1
AND falang_content.reference_id IN(47,45,44)
AND falang_content.reference_table='zoo_category'UPDATE d4xh9_zoo_item
SET hits = (hits + 1)
WHERE id = 1745SELECT id
FROM d4xh9_assets
WHERE parent_id = 0SELECT id
FROM d4xh9_assets
WHERE parent_id = 0SELECT id
FROM d4xh9_assets
WHERE parent_id = 0SELECT id
FROM d4xh9_assets
WHERE parent_id = 0SELECT id
FROM d4xh9_assets
WHERE parent_id = 0SELECT id
FROM d4xh9_assets
WHERE parent_id = 0SELECT b.id
FROM d4xh9_zoo_category_item AS a JOIN d4xh9_zoo_category AS b
ON a.category_id = b.id
WHERE a.item_id=1745
AND b.published = 1 UNION SELECT 0
FROM d4xh9_zoo_category_item AS a
WHERE a.item_id=1745
AND a.category_id = 0SELECT id
FROM d4xh9_assets
WHERE parent_id = 0SELECT id
FROM d4xh9_assets
WHERE parent_id = 0SELECT id
FROM d4xh9_assets
WHERE parent_id = 0SELECT id
FROM d4xh9_assets
WHERE parent_id = 0SELECT id
FROM d4xh9_assets
WHERE parent_id = 0SELECT id
FROM d4xh9_assets
WHERE parent_id = 0SHOW FULL COLUMNS
FROM `d4xh9_content`SELECT id
FROM d4xh9_assets
WHERE parent_id = 0SELECT *
FROM d4xh9_zoo_items_relations
WHERE name = 'Entrada-Work'
AND item1 = 1745SELECT id
FROM d4xh9_assets
WHERE parent_id = 0SELECT *
FROM d4xh9_zoo_item
WHERE id IN (1744, 1746)
AND state = 1
AND access IN (1)
AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2023-12-02 14:16:34')
AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2023-12-02 14:16:34')
ORDER BY FIELD(id,1744, 1746)SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
FROM d4xh9_falang_content AS falang_content
WHERE falang_content.language_id=3
AND falang_content.published=1
AND falang_content.reference_id IN(1744,1746)
AND falang_content.reference_table='zoo_item'SELECT id
FROM d4xh9_assets
WHERE parent_id = 0SELECT *
FROM d4xh9_zoo_items_relations
WHERE name = 'Entrada-Work'
AND item1 = 1745SELECT id
FROM d4xh9_assets
WHERE parent_id = 0SELECT *
FROM d4xh9_zoo_item
WHERE id IN (1744, 1746)
AND state = 1
AND access IN (1)
AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2023-12-02 14:16:34')
AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2023-12-02 14:16:34')
ORDER BY FIELD(id,1744, 1746)SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
FROM d4xh9_falang_content AS falang_content
WHERE falang_content.language_id=3
AND falang_content.published=1
AND falang_content.reference_id IN(1744,1746)
AND falang_content.reference_table='zoo_item'SELECT *
FROM d4xh9_zoo_items_relations
WHERE name = 'Entrada-Work'
AND item1 = 1745SELECT id
FROM d4xh9_assets
WHERE parent_id = 0SELECT *
FROM d4xh9_zoo_item
WHERE id IN (1744, 1746)
AND state = 1
AND access IN (1)
AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2023-12-02 14:16:34')
AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2023-12-02 14:16:34')
ORDER BY FIELD(id,1744, 1746)SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
FROM d4xh9_falang_content AS falang_content
WHERE falang_content.language_id=3
AND falang_content.published=1
AND falang_content.reference_id IN(1744,1746)
AND falang_content.reference_table='zoo_item'SELECT id
FROM d4xh9_assets
WHERE parent_id = 0SELECT *
FROM d4xh9_zoo_items_relations
WHERE name = 'Entrada-Etiqueta'
AND item1 = 1745SELECT id
FROM d4xh9_assets
WHERE parent_id = 0SELECT *
FROM d4xh9_zoo_items_relations
WHERE name = 'Entrada-Work'
AND item1 = 1745SELECT id
FROM d4xh9_assets
WHERE parent_id = 0SELECT *
FROM d4xh9_zoo_item
WHERE id IN (1744, 1746)
AND state = 1
AND access IN (1)
AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2023-12-02 14:16:34')
AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2023-12-02 14:16:34')
ORDER BY FIELD(id,1744, 1746)SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
FROM d4xh9_falang_content AS falang_content
WHERE falang_content.language_id=3
AND falang_content.published=1
AND falang_content.reference_id IN(1744,1746)
AND falang_content.reference_table='zoo_item'SELECT id
FROM d4xh9_assets
WHERE parent_id = 0SELECT *
FROM d4xh9_zoo_items_relations
WHERE name = 'Entrada-Etiqueta'
AND item1 = 1745SELECT et.id, et.name
FROM d4xh9_zoo_item zi1, d4xh9_zoo_item et, d4xh9_zoo_items_relations zir
WHERE et.application_id = 27
AND zi1.state = 1
AND et.state = 1
AND zi1.id = 1745
AND zir.item1= zi1.id
AND zir.item2 = et.idSELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
FROM d4xh9_falang_content AS falang_content
WHERE falang_content.language_id=3
AND falang_content.published=1
AND falang_content.reference_id IN(1673,1691,1675)
AND falang_content.reference_table='zoo_item'SELECT et2.id, et2.name
FROM d4xh9_zoo_item et1, d4xh9_zoo_item et2, d4xh9_zoo_items_relations zir
WHERE et1.application_id =27
AND et1.state = 1
AND et2.state = 1
AND et2.application_id =27
AND zir.item1 = et1.id
AND zir.item2 = et2.id
AND et1.id =1673SELECT et2.id, et2.name
FROM d4xh9_zoo_item et1, d4xh9_zoo_item et2, d4xh9_zoo_items_relations zir
WHERE et1.application_id =27
AND et1.state = 1
AND et2.state = 1
AND et2.application_id =27
AND zir.item1 = et1.id
AND zir.item2 = et2.id
AND et1.id =1691SELECT et2.id, et2.name
FROM d4xh9_zoo_item et1, d4xh9_zoo_item et2, d4xh9_zoo_items_relations zir
WHERE et1.application_id =27
AND et1.state = 1
AND et2.state = 1
AND et2.application_id =27
AND zir.item1 = et1.id
AND zir.item2 = et2.id
AND et1.id =1675SELECT zi.id as id, zi.name as name, COUNT( zi.id ) AS count
FROM d4xh9_zoo_items_relations zir, d4xh9_zoo_item zi
WHERE zi.id = zir.item1
AND zi.state = 1
AND zir.item2 IN (1673,1691,1675)
AND zi.id != 1745
AND zi.application_id != 27
GROUP BY zi.id
ORDER BY count DESC, zi.publish_up DESC
LIMIT 0, 5SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
FROM d4xh9_falang_content AS falang_content
WHERE falang_content.language_id=3
AND falang_content.published=1
AND falang_content.reference_id IN(1744,1763,1769,1764,1753)
AND falang_content.reference_table='zoo_item'SELECT *
FROM d4xh9_zoo_item
WHERE id = 1763SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
FROM d4xh9_falang_content AS falang_content
WHERE falang_content.language_id=3
AND falang_content.published=1
AND falang_content.reference_id IN(1763)
AND falang_content.reference_table='zoo_item'SELECT *
FROM d4xh9_zoo_item
WHERE id = 1769SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
FROM d4xh9_falang_content AS falang_content
WHERE falang_content.language_id=3
AND falang_content.published=1
AND falang_content.reference_id IN(1769)
AND falang_content.reference_table='zoo_item'SELECT *
FROM d4xh9_zoo_item
WHERE id = 1764SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
FROM d4xh9_falang_content AS falang_content
WHERE falang_content.language_id=3
AND falang_content.published=1
AND falang_content.reference_id IN(1764)
AND falang_content.reference_table='zoo_item'SELECT *
FROM d4xh9_zoo_item
WHERE id = 1753SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
FROM d4xh9_falang_content AS falang_content
WHERE falang_content.language_id=3
AND falang_content.published=1
AND falang_content.reference_id IN(1753)
AND falang_content.reference_table='zoo_item'SELECT id
FROM d4xh9_assets
WHERE parent_id = 0SELECT *
FROM d4xh9_zoo_items_relations
WHERE name = 'Entrada-Etiqueta'
AND item1 = 1745SELECT id
FROM d4xh9_assets
WHERE parent_id = 0SELECT *
FROM d4xh9_zoo_item
WHERE id IN (1673, 1691, 1675)
AND state = 1
AND access IN (1)
AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2023-12-02 14:16:34')
AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2023-12-02 14:16:34')
ORDER BY FIELD(id,1673, 1691, 1675)SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
FROM d4xh9_falang_content AS falang_content
WHERE falang_content.language_id=3
AND falang_content.published=1
AND falang_content.reference_id IN(1673,1691,1675)
AND falang_content.reference_table='zoo_item'SELECT id
FROM d4xh9_assets
WHERE parent_id = 0SELECT *
FROM d4xh9_zoo_items_relations
WHERE name = 'Entrada-Etiqueta'
AND item1 = 1745SELECT id
FROM d4xh9_assets
WHERE parent_id = 0SELECT *
FROM d4xh9_zoo_item
WHERE id IN (1673, 1691, 1675)
AND state = 1
AND access IN (1)
AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2023-12-02 14:16:34')
AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2023-12-02 14:16:34')
ORDER BY FIELD(id,1673, 1691, 1675)SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
FROM d4xh9_falang_content AS falang_content
WHERE falang_content.language_id=3
AND falang_content.published=1
AND falang_content.reference_id IN(1673,1691,1675)
AND falang_content.reference_table='zoo_item'SELECT *
FROM d4xh9_zoo_items_relations
WHERE name = 'Entrada-Etiqueta'
AND item1 = 1745SELECT id
FROM d4xh9_assets
WHERE parent_id = 0SELECT *
FROM d4xh9_zoo_item
WHERE id IN (1673, 1691, 1675)
AND state = 1
AND access IN (1)
AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2023-12-02 14:16:34')
AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2023-12-02 14:16:34')
ORDER BY FIELD(id,1673, 1691, 1675)SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
FROM d4xh9_falang_content AS falang_content
WHERE falang_content.language_id=3
AND falang_content.published=1
AND falang_content.reference_id IN(1673,1691,1675)
AND falang_content.reference_table='zoo_item'SELECT *
FROM d4xh9_zoo_application
WHERE id = 27SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
FROM d4xh9_falang_content AS falang_content
WHERE falang_content.language_id=3
AND falang_content.published=1
AND falang_content.reference_id IN(27)
AND falang_content.reference_table='zoo_application'SELECT *
FROM d4xh9_zoo_category
WHERE application_id = 27
AND published = 1
ORDER BY orderingSELECT b.id
FROM d4xh9_zoo_category_item AS a JOIN d4xh9_zoo_category AS b
ON a.category_id = b.id
WHERE a.item_id=1673
AND b.published = 1 UNION SELECT 0
FROM d4xh9_zoo_category_item AS a
WHERE a.item_id=1673
AND a.category_id = 0SELECT b.id
FROM d4xh9_zoo_category_item AS a JOIN d4xh9_zoo_category AS b
ON a.category_id = b.id
WHERE a.item_id=1691
AND b.published = 1 UNION SELECT 0
FROM d4xh9_zoo_category_item AS a
WHERE a.item_id=1691
AND a.category_id = 0SELECT b.id
FROM d4xh9_zoo_category_item AS a JOIN d4xh9_zoo_category AS b
ON a.category_id = b.id
WHERE a.item_id=1675
AND b.published = 1 UNION SELECT 0
FROM d4xh9_zoo_category_item AS a
WHERE a.item_id=1675
AND a.category_id = 0SELECT id
FROM d4xh9_assets
WHERE parent_id = 0SELECT id
FROM d4xh9_assets
WHERE parent_id = 0SELECT id
FROM d4xh9_assets
WHERE parent_id = 0SELECT id
FROM d4xh9_assets
WHERE parent_id = 0SELECT id
FROM d4xh9_assets
WHERE parent_id = 0SELECT ROWNUM
FROM (SELECT @rownum:= @rownum+1 ROWNUM, id
FROM (SELECT @rownum:=0) r, (SELECT id
FROM d4xh9_zoo_item AS a
LEFT JOIN d4xh9_zoo_category_item AS b
ON a.id = b.item_id
WHERE a.application_id = 17
AND b.category_id = 0
AND access IN (1)
AND a.state = 1
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-12-02 14:16:34')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-12-02 14:16:34')
GROUP BY a.id
ORDER BY a.priority DESC, a.created DESC) t1) t2
WHERE id = 1745SELECT id
FROM d4xh9_assets
WHERE parent_id = 0SELECT ROWNUM, id
FROM (SELECT @rownum:= @rownum+1 ROWNUM, id
FROM (SELECT @rownum:=0) r, (SELECT id
FROM d4xh9_zoo_item AS a
LEFT JOIN d4xh9_zoo_category_item AS b
ON a.id = b.item_id
WHERE a.application_id = 17
AND b.category_id = 0
AND access IN (1)
AND a.state = 1
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-12-02 14:16:34')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-12-02 14:16:34')
GROUP BY a.id
ORDER BY a.priority DESC, a.created DESC) t1) t2
WHERE ROWNUM = 26 OR ROWNUM = 28SELECT *
FROM d4xh9_zoo_item
WHERE id = 1749SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
FROM d4xh9_falang_content AS falang_content
WHERE falang_content.language_id=3
AND falang_content.published=1
AND falang_content.reference_id IN(1749)
AND falang_content.reference_table='zoo_item'SELECT *
FROM d4xh9_zoo_item
WHERE id = 1747SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
FROM d4xh9_falang_content AS falang_content
WHERE falang_content.language_id=3
AND falang_content.published=1
AND falang_content.reference_id IN(1747)
AND falang_content.reference_table='zoo_item'SELECT id
FROM d4xh9_assets
WHERE parent_id = 0SELECT id, title, alias, link, level, parent_id, browserNav, type, params
FROM d4xh9_menu
WHERE published = 1
AND (access = 0 || access = 1)
AND menutype = 'mainmenu'
AND home=0
AND level >=1
AND level <=2
ORDER BY parent_id, lftSELECT id, title, alias, link, level, parent_id, browserNav, type, params
FROM d4xh9_menu
WHERE published = 1
AND (access = 0 || access = 1)
AND menutype = 'secondary-menu'
AND home=0
AND level >=1
AND level <=2
ORDER BY parent_id, lftSELECT *
FROM d4xh9_zoo_application
WHERE id = 23SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
FROM d4xh9_falang_content AS falang_content
WHERE falang_content.language_id=3
AND falang_content.published=1
AND falang_content.reference_id IN(23)
AND falang_content.reference_table='zoo_application'SELECT id
FROM d4xh9_assets
WHERE parent_id = 0SELECT a.*
FROM d4xh9_zoo_item AS a
WHERE a.type = 'microsite'
AND a.application_id = 23
AND access IN (1)
AND a.state = 1
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-12-02 14:16:34')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-12-02 14:16:34')
GROUP BY a.id
ORDER BY a.priority DESC, a.name
LIMIT 0,5SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
FROM d4xh9_falang_content AS falang_content
WHERE falang_content.language_id=3
AND falang_content.published=1
AND falang_content.reference_id IN(1714,1405,1408,1406,1407)
AND falang_content.reference_table='zoo_item'SELECT id
FROM d4xh9_assets
WHERE parent_id = 0SELECT id
FROM d4xh9_assets
WHERE parent_id = 0SELECT id
FROM d4xh9_assets
WHERE parent_id = 0SELECT id
FROM d4xh9_assets
WHERE parent_id = 0SELECT id
FROM d4xh9_assets
WHERE parent_id = 0SELECT id
FROM d4xh9_assets
WHERE parent_id = 0SELECT id
FROM d4xh9_assets
WHERE parent_id = 0SELECT id
FROM d4xh9_assets
WHERE parent_id = 0SELECT id
FROM d4xh9_assets
WHERE parent_id = 0SELECT id
FROM d4xh9_assets
WHERE parent_id = 0SELECT id
FROM d4xh9_assets
WHERE parent_id = 0SELECT id
FROM d4xh9_assets
WHERE parent_id = 0SELECT id
FROM d4xh9_assets
WHERE parent_id = 0SELECT id
FROM d4xh9_assets
WHERE parent_id = 0SELECT id
FROM d4xh9_assets
WHERE parent_id = 0SELECT id
FROM d4xh9_assets
WHERE parent_id = 0SELECT id
FROM d4xh9_assets
WHERE parent_id = 0SELECT id
FROM d4xh9_assets
WHERE parent_id = 0SELECT id
FROM d4xh9_assets
WHERE parent_id = 0SELECT id
FROM d4xh9_assets
WHERE parent_id = 0SELECT id
FROM d4xh9_assets
WHERE parent_id = 0SELECT id
FROM d4xh9_assets
WHERE parent_id = 0SELECT id
FROM d4xh9_assets
WHERE parent_id = 0SELECT id
FROM d4xh9_assets
WHERE parent_id = 0SELECT id
FROM d4xh9_assets
WHERE parent_id = 0SELECT id
FROM d4xh9_assets
WHERE parent_id = 0SELECT id
FROM d4xh9_assets
WHERE parent_id = 0SELECT id
FROM d4xh9_assets
WHERE parent_id = 0SELECT id
FROM d4xh9_assets
WHERE parent_id = 0SELECT id
FROM d4xh9_assets
WHERE parent_id = 0SELECT id
FROM d4xh9_assets
WHERE parent_id = 0SELECT id
FROM d4xh9_assets
WHERE parent_id = 0SELECT id
FROM d4xh9_assets
WHERE parent_id = 0SELECT id
FROM d4xh9_assets
WHERE parent_id = 0SELECT id
FROM d4xh9_assets
WHERE parent_id = 0SELECT id
FROM d4xh9_assets
WHERE parent_id = 0SELECT id
FROM d4xh9_assets
WHERE parent_id = 0SELECT id
FROM d4xh9_assets
WHERE parent_id = 0SELECT id
FROM d4xh9_assets
WHERE parent_id = 0SELECT id
FROM d4xh9_assets
WHERE parent_id = 0SELECT id
FROM d4xh9_assets
WHERE parent_id = 0SELECT id
FROM d4xh9_assets
WHERE parent_id = 0SELECT id
FROM d4xh9_assets
WHERE parent_id = 0SELECT id
FROM d4xh9_assets
WHERE parent_id = 0SELECT id
FROM d4xh9_assets
WHERE parent_id = 0SELECT id
FROM d4xh9_assets
WHERE parent_id = 0SELECT id
FROM d4xh9_assets
WHERE parent_id = 0SELECT id
FROM d4xh9_assets
WHERE parent_id = 0SELECT
DISTINCT (zi.id) AS id,
zi.name as name,
zi.latitude as lat,
zi.longitude as lng,
zi.application_id as application_id, 0 AS distance
FROM
( d4xh9_zoo_item zi )
WHERE
(zi.publish_up = '0000-00-00 00:00:00' OR zi.publish_up <= '2023-12-02 14:16:34')
AND (zi.publish_down = '0000-00-00 00:00:00' OR zi.publish_down >= '2023-12-02 14:16:34')
AND zi.state =1
AND zi.application_id IN (26)
HAVING distance < 10
ORDER BY zi.priority DESC, zi.name ASC, zi.name ASCSELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
FROM d4xh9_falang_content AS falang_content
WHERE falang_content.language_id=3
AND falang_content.published=1
AND falang_content.reference_id IN(1411,1412,1413,1800)
AND falang_content.reference_table='zoo_item'SELECT *
FROM d4xh9_zoo_item
WHERE id = 1411SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
FROM d4xh9_falang_content AS falang_content
WHERE falang_content.language_id=3
AND falang_content.published=1
AND falang_content.reference_id IN(1411)
AND falang_content.reference_table='zoo_item'SELECT *
FROM d4xh9_zoo_item
WHERE id = 1412SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
FROM d4xh9_falang_content AS falang_content
WHERE falang_content.language_id=3
AND falang_content.published=1
AND falang_content.reference_id IN(1412)
AND falang_content.reference_table='zoo_item'SELECT *
FROM d4xh9_zoo_item
WHERE id = 1413SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
FROM d4xh9_falang_content AS falang_content
WHERE falang_content.language_id=3
AND falang_content.published=1
AND falang_content.reference_id IN(1413)
AND falang_content.reference_table='zoo_item'SELECT *
FROM d4xh9_zoo_item
WHERE id = 1800SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
FROM d4xh9_falang_content AS falang_content
WHERE falang_content.language_id=3
AND falang_content.published=1
AND falang_content.reference_id IN(1800)
AND falang_content.reference_table='zoo_item'SELECT *
FROM d4xh9_zoo_application
WHERE id = 26SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
FROM d4xh9_falang_content AS falang_content
WHERE falang_content.language_id=3
AND falang_content.published=1
AND falang_content.reference_id IN(26)
AND falang_content.reference_table='zoo_application'SELECT *
FROM d4xh9_zoo_items_relations
WHERE name = 'Sede-Contacto'
AND item1 = 1411SELECT id
FROM d4xh9_assets
WHERE parent_id = 0SELECT *
FROM d4xh9_zoo_item
WHERE id IN (1090)
AND state = 1
AND access IN (1)
AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2023-12-02 14:16:34')
AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2023-12-02 14:16:34')
ORDER BY FIELD(id,1090)SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
FROM d4xh9_falang_content AS falang_content
WHERE falang_content.language_id=3
AND falang_content.published=1
AND falang_content.reference_id IN(1090)
AND falang_content.reference_table='zoo_item'SELECT *
FROM d4xh9_zoo_application
WHERE id = 16SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
FROM d4xh9_falang_content AS falang_content
WHERE falang_content.language_id=3
AND falang_content.published=1
AND falang_content.reference_id IN(16)
AND falang_content.reference_table='zoo_application'SELECT *
FROM d4xh9_zoo_category
WHERE application_id = 16
AND published = 1
ORDER BY orderingSELECT *
FROM d4xh9_zoo_items_relations
WHERE name = 'Sede-Contacto'
AND item1 = 1412SELECT id
FROM d4xh9_assets
WHERE parent_id = 0SELECT *
FROM d4xh9_zoo_item
WHERE id IN (1091)
AND state = 1
AND access IN (1)
AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2023-12-02 14:16:34')
AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2023-12-02 14:16:34')
ORDER BY FIELD(id,1091)SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
FROM d4xh9_falang_content AS falang_content
WHERE falang_content.language_id=3
AND falang_content.published=1
AND falang_content.reference_id IN(1091)
AND falang_content.reference_table='zoo_item'SELECT *
FROM d4xh9_zoo_items_relations
WHERE name = 'Sede-Contacto'
AND item1 = 1413SELECT id
FROM d4xh9_assets
WHERE parent_id = 0SELECT *
FROM d4xh9_zoo_item
WHERE id IN (1583)
AND state = 1
AND access IN (1)
AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2023-12-02 14:16:34')
AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2023-12-02 14:16:34')
ORDER BY FIELD(id,1583)SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
FROM d4xh9_falang_content AS falang_content
WHERE falang_content.language_id=3
AND falang_content.published=1
AND falang_content.reference_id IN(1583)
AND falang_content.reference_table='zoo_item'SELECT *
FROM d4xh9_zoo_items_relations
WHERE name = 'Sede-Contacto'
AND item1 = 1800SELECT id
FROM d4xh9_assets
WHERE parent_id = 0SELECT *
FROM d4xh9_zoo_item
WHERE id IN (1089)
AND state = 1
AND access IN (1)
AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2023-12-02 14:16:34')
AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2023-12-02 14:16:34')
ORDER BY FIELD(id,1089)
25 Tipos de consultas del registro, Ordenado por acontecimientos.
SELECCIONAR Tablas:
87 × SELECT id
FROM d4xh9_assets32 × SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
FROM d4xh9_falang_content AS falang_content22 × SELECT *
FROM d4xh9_zoo_item13 × SELECT *
FROM d4xh9_zoo_items_relations5 × SELECT *
FROM d4xh9_zoo_application4 × SELECT b.id
FROM d4xh9_zoo_category_item AS a JOIN d4xh9_zoo_category AS b
ON a.category_id = b.id3 × SELECT et2.id, et2.name
FROM d4xh9_zoo_item et1, d4xh9_zoo_item et2, d4xh9_zoo_items_relations zir3 × SELECT *
FROM d4xh9_zoo_category2 × SELECT id, title, alias, link, level, parent_id, browserNav, type, params
FROM d4xh9_menu1 × SELECT ROWNUM, id
FROM (SELECT @rownum:= @rownum+1 ROWNUM, id
FROM (SELECT @rownum:=0) r, (SELECT id
FROM d4xh9_zoo_item AS a
LEFT JOIN d4xh9_zoo_category_item AS b
ON a.id = b.item_id1 × SELECT ROWNUM
FROM (SELECT @rownum:= @rownum+1 ROWNUM, id
FROM (SELECT @rownum:=0) r, (SELECT id
FROM d4xh9_zoo_item AS a
LEFT JOIN d4xh9_zoo_category_item AS b
ON a.id = b.item_id1 × SELECT a.*
FROM d4xh9_zoo_item AS a1 × SELECT DISTINCT (zi.id) AS id, zi.name as name, zi.latitude as lat, zi.longitude as lng, zi.application_id as application_id, 0 AS distance
FROM ( d4xh9_zoo_item zi )1 × SELECT zi.id as id, zi.name as name, COUNT( zi.id ) AS count
FROM d4xh9_zoo_items_relations zir, d4xh9_zoo_item zi1 × SELECT id
FROM d4xh9_zoo_item1 × 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 d4xh9_menu AS m
LEFT JOIN d4xh9_extensions AS e
ON m.component_id = e.extension_id1 × SELECT b.rules
FROM d4xh9_assets AS a
LEFT JOIN d4xh9_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt1 × SELECT *
FROM d4xh9_languages1 × SELECT joomlatablename,tablepkID
FROM `d4xh9_falang_tableinfo1 × SELECT et.id, et.name
FROM d4xh9_zoo_item zi1, d4xh9_zoo_item et, d4xh9_zoo_items_relations zir1 × SELECT a.rules
FROM d4xh9_assets AS a
OTRAS Tablas:
1 × SHOW FULL COLUMNS
FROM `d4xh9_content1 × UPDATE d4xh9_zoo_item
SET hits = (hits + 1)1 × SHOW FULL COLUMNS
FROM `d4xh9_assets1 × SHOW FULL COLUMNS
FROM `d4xh9_languages
