Consola de Joomla! Debug
session.client.forwarded ⇒ 44.220.251.236
session.client.browser ⇒ CCBot/2.0 (https://commoncrawl.org/faq/)
password_clear ⇒
groups ⇒
session.token ⇒ 1d92dad82e4bedbe1e1e5fb7b1a5626b
Application 0.000 seconds (+0.000); 0.34 MB (+0.340) - afterLoad
Application 0.037 seconds (+0.037); 1.59 MB (+1.249) - afterInitialise
Application 0.056 seconds (+0.019); 2.22 MB (+0.627) - afterRoute
Application 0.210 seconds (+0.154); 4.41 MB (+2.198) - afterDispatch
Application 0.214 seconds (+0.004); 4.59 MB (+0.174) - beforeRenderModule mod_menufooter (Menu footer)
Application 0.218 seconds (+0.003); 4.67 MB (+0.078) - afterRenderModule mod_menufooter (Menu footer)
Application 0.218 seconds (+0.000); 4.59 MB (-0.077) - beforeRenderModule mod_zooitem (Microsites (zona globaldit))
Application 0.266 seconds (+0.048); 5.18 MB (+0.594) - afterRenderModule mod_zooitem (Microsites (zona globaldit))
Application 0.268 seconds (+0.002); 5.15 MB (-0.035) - beforeRenderModule mod_menu (Menú secundario)
Application 0.270 seconds (+0.002); 5.18 MB (+0.034) - afterRenderModule mod_menu (Menú secundario)
Application 0.271 seconds (+0.001); 5.16 MB (-0.021) - beforeRenderModule mod_menu (Menú Principal)
Application 0.273 seconds (+0.002); 5.24 MB (+0.080) - afterRenderModule mod_menu (Menú Principal)
Application 0.274 seconds (+0.001); 5.14 MB (-0.100) - beforeRenderModule mod_compartir (Compartir)
Application 0.274 seconds (+0.001); 5.15 MB (+0.009) - afterRenderModule mod_compartir (Compartir)
Application 0.275 seconds (+0.001); 5.18 MB (+0.025) - beforeRenderModule mod_search (Buscador (header))
Application 0.276 seconds (+0.001); 5.19 MB (+0.017) - afterRenderModule mod_search (Buscador (header))
Application 0.277 seconds (+0.000); 5.16 MB (-0.030) - beforeRenderModule mod_contact (Contacto)
Application 0.335 seconds (+0.059); 6.28 MB (+1.115) - afterRenderModule mod_contact (Contacto)
Application 0.339 seconds (+0.004); 6.31 MB (+0.033) - afterRender
6.34 MB (6,649,136 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.lft
SELECT id
FROM d4xh9_zoo_item
WHERE alias = 'del-petroleo-al-turismo'
LIMIT 1
SELECT joomlatablename,tablepkID
FROM `d4xh9_falang_tableinfo`
SELECT *
FROM d4xh9_languages
ORDER BY ordering
SHOW 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(983)
AND falang_content.reference_table='zoo_item'
SELECT *
FROM d4xh9_zoo_item
WHERE id = 983
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(983)
AND falang_content.reference_table='zoo_item'
SELECT *
FROM d4xh9_zoo_application
WHERE id = 14
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(14)
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.lft
SHOW FULL COLUMNS
FROM `d4xh9_assets`
SELECT id
FROM d4xh9_assets
WHERE parent_id = 0
SELECT 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.lft
SELECT *
FROM d4xh9_zoo_category
WHERE application_id = 14
AND published = 1
ORDER BY ordering
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(54,53,56)
AND falang_content.reference_table='zoo_category'
SELECT 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=983
AND b.published = 1 UNION SELECT 0
FROM d4xh9_zoo_category_item AS a
WHERE a.item_id=983
AND a.category_id = 0
UPDATE d4xh9_zoo_item
SET hits = (hits + 1)
WHERE id = 983
SELECT id
FROM d4xh9_assets
WHERE parent_id = 0
SELECT *
FROM d4xh9_zoo_items_relations
WHERE name = 'Artículo-Proyecto'
AND item2 = 983
SELECT id
FROM d4xh9_assets
WHERE parent_id = 0
SELECT *
FROM d4xh9_zoo_item
WHERE id IN (1716, 1717, 1722)
AND state = 1
AND access IN (1)
AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2024-10-14 21:41:02')
AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2024-10-14 21:41:02')
ORDER BY FIELD(id,1716, 1717, 1722)
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(1716,1717,1722)
AND falang_content.reference_table='zoo_item'
SELECT id
FROM d4xh9_assets
WHERE parent_id = 0
SELECT id
FROM d4xh9_assets
WHERE parent_id = 0
SELECT id
FROM d4xh9_assets
WHERE parent_id = 0
SELECT id
FROM d4xh9_assets
WHERE parent_id = 0
SELECT id
FROM d4xh9_assets
WHERE parent_id = 0
SELECT id
FROM d4xh9_assets
WHERE parent_id = 0
SELECT id
FROM d4xh9_assets
WHERE parent_id = 0
SELECT id
FROM d4xh9_assets
WHERE parent_id = 0
SELECT id
FROM d4xh9_assets
WHERE parent_id = 0
SHOW FULL COLUMNS
FROM `d4xh9_content`
SELECT id
FROM d4xh9_assets
WHERE parent_id = 0
SELECT *
FROM d4xh9_zoo_items_relations
WHERE name = 'Proyecto-Cliente'
AND item1 = 983
SELECT id
FROM d4xh9_assets
WHERE parent_id = 0
SELECT *
FROM d4xh9_zoo_item
WHERE id IN (874)
AND state = 1
AND access IN (1)
AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2024-10-14 21:41:02')
AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2024-10-14 21:41:02')
ORDER BY FIELD(id,874)
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(874)
AND falang_content.reference_table='zoo_item'
SELECT id
FROM d4xh9_assets
WHERE parent_id = 0
SELECT *
FROM d4xh9_zoo_items_relations
WHERE name = 'Proyecto-Cliente'
AND item1 = 983
SELECT id
FROM d4xh9_assets
WHERE parent_id = 0
SELECT *
FROM d4xh9_zoo_item
WHERE id IN (874)
AND state = 1
AND access IN (1)
AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2024-10-14 21:41:02')
AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2024-10-14 21:41:02')
ORDER BY FIELD(id,874)
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(874)
AND falang_content.reference_table='zoo_item'
SELECT *
FROM d4xh9_zoo_items_relations
WHERE name = 'Proyecto-Cliente'
AND item1 = 983
SELECT id
FROM d4xh9_assets
WHERE parent_id = 0
SELECT *
FROM d4xh9_zoo_item
WHERE id IN (874)
AND state = 1
AND access IN (1)
AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2024-10-14 21:41:02')
AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2024-10-14 21:41:02')
ORDER BY FIELD(id,874)
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(874)
AND falang_content.reference_table='zoo_item'
SELECT *
FROM d4xh9_zoo_application
WHERE id = 15
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(15)
AND falang_content.reference_table='zoo_application'
SELECT *
FROM d4xh9_zoo_category
WHERE application_id = 15
AND published = 1
ORDER BY ordering
SELECT *
FROM d4xh9_zoo_category
WHERE id = 14
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(14)
AND falang_content.reference_table='zoo_category'
SELECT 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=874
AND b.published = 1 UNION SELECT 0
FROM d4xh9_zoo_category_item AS a
WHERE a.item_id=874
AND a.category_id = 0
SELECT id
FROM d4xh9_assets
WHERE parent_id = 0
SELECT id
FROM d4xh9_assets
WHERE parent_id = 0
SELECT id
FROM d4xh9_assets
WHERE parent_id = 0
SELECT *
FROM d4xh9_zoo_items_relations
WHERE name = 'Proyecto-Responsable'
AND item1 = 983
SELECT id
FROM d4xh9_assets
WHERE parent_id = 0
SELECT id
FROM d4xh9_assets
WHERE parent_id = 0
SELECT id
FROM d4xh9_assets
WHERE parent_id = 0
SELECT *
FROM d4xh9_zoo_items_relations
WHERE name = 'Proyecto-Especialidad'
AND item1 = 983
SELECT id
FROM d4xh9_assets
WHERE parent_id = 0
SELECT *
FROM d4xh9_zoo_item
WHERE id IN (1395, 1397, 1398, 1399)
AND state = 1
AND access IN (1)
AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2024-10-14 21:41:02')
AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2024-10-14 21:41:02')
ORDER BY FIELD(id,1395, 1397, 1398, 1399)
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(1395,1397,1398,1399)
AND falang_content.reference_table='zoo_item'
SELECT id
FROM d4xh9_assets
WHERE parent_id = 0
SELECT *
FROM d4xh9_zoo_items_relations
WHERE name = 'Proyecto-Especialidad'
AND item1 = 983
SELECT id
FROM d4xh9_assets
WHERE parent_id = 0
SELECT *
FROM d4xh9_zoo_item
WHERE id IN (1395, 1397, 1398, 1399)
AND state = 1
AND access IN (1)
AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2024-10-14 21:41:02')
AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2024-10-14 21:41:02')
ORDER BY FIELD(id,1395, 1397, 1398, 1399)
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(1395,1397,1398,1399)
AND falang_content.reference_table='zoo_item'
SELECT *
FROM d4xh9_zoo_items_relations
WHERE name = 'Proyecto-Especialidad'
AND item1 = 983
SELECT id
FROM d4xh9_assets
WHERE parent_id = 0
SELECT *
FROM d4xh9_zoo_item
WHERE id IN (1395, 1397, 1398, 1399)
AND state = 1
AND access IN (1)
AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2024-10-14 21:41:02')
AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2024-10-14 21:41:02')
ORDER BY FIELD(id,1395, 1397, 1398, 1399)
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(1395,1397,1398,1399)
AND falang_content.reference_table='zoo_item'
SELECT *
FROM d4xh9_zoo_application
WHERE id = 22
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(22)
AND falang_content.reference_table='zoo_application'
SELECT *
FROM d4xh9_zoo_category
WHERE application_id = 22
AND published = 1
ORDER BY ordering
SELECT 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=1395
AND b.published = 1 UNION SELECT 0
FROM d4xh9_zoo_category_item AS a
WHERE a.item_id=1395
AND a.category_id = 0
SELECT 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=1397
AND b.published = 1 UNION SELECT 0
FROM d4xh9_zoo_category_item AS a
WHERE a.item_id=1397
AND a.category_id = 0
SELECT 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=1398
AND b.published = 1 UNION SELECT 0
FROM d4xh9_zoo_category_item AS a
WHERE a.item_id=1398
AND a.category_id = 0
SELECT 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=1399
AND b.published = 1 UNION SELECT 0
FROM d4xh9_zoo_category_item AS a
WHERE a.item_id=1399
AND a.category_id = 0
SELECT id
FROM d4xh9_assets
WHERE parent_id = 0
SELECT id
FROM d4xh9_assets
WHERE parent_id = 0
SELECT id
FROM d4xh9_assets
WHERE parent_id = 0
SELECT id
FROM d4xh9_assets
WHERE parent_id = 0
SELECT id
FROM d4xh9_assets
WHERE parent_id = 0
SELECT id
FROM d4xh9_assets
WHERE parent_id = 0
SELECT id
FROM d4xh9_assets
WHERE parent_id = 0
SELECT id
FROM d4xh9_assets
WHERE parent_id = 0
SELECT id
FROM d4xh9_assets
WHERE parent_id = 0
SELECT id
FROM d4xh9_assets
WHERE parent_id = 0
SELECT *
FROM d4xh9_zoo_category
WHERE id = 0
SELECT id
FROM d4xh9_assets
WHERE parent_id = 0
SELECT ROWNUM
FROM (SELECT @rownum:= @rownum+1 ROWNUM, id
FROM (SELECT @rownum:=0) r, (SELECT id
FROM d4xh9_zoo_item AS a
WHERE a.application_id = 14
AND access IN (1)
AND a.state = 1
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-10-14 21:41:02')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-10-14 21:41:02')
AND a.highlight = 1
GROUP BY a.id
ORDER BY a.priority DESC, a.name) t1) t2
WHERE id = 983
SELECT id
FROM d4xh9_assets
WHERE parent_id = 0
SELECT ROWNUM, id
FROM (SELECT @rownum:= @rownum+1 ROWNUM, id
FROM (SELECT @rownum:=0) r, (SELECT id
FROM d4xh9_zoo_item AS a
WHERE a.application_id = 14
AND access IN (1)
AND a.state = 1
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-10-14 21:41:02')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-10-14 21:41:02')
AND a.highlight = 1
GROUP BY a.id
ORDER BY a.priority DESC, a.name) t1) t2
WHERE ROWNUM = 16 OR ROWNUM = 18
SELECT *
FROM d4xh9_zoo_item
WHERE id = 1082
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(1082)
AND falang_content.reference_table='zoo_item'
SELECT *
FROM d4xh9_zoo_item
WHERE id = 1727
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(1727)
AND falang_content.reference_table='zoo_item'
SELECT id
FROM d4xh9_assets
WHERE parent_id = 0
SELECT 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=1082
AND b.published = 1 UNION SELECT 0
FROM d4xh9_zoo_category_item AS a
WHERE a.item_id=1082
AND a.category_id = 0
SELECT 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=1727
AND b.published = 1 UNION SELECT 0
FROM d4xh9_zoo_category_item AS a
WHERE a.item_id=1727
AND a.category_id = 0
SELECT 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, lft
SELECT 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, lft
SELECT *
FROM d4xh9_zoo_application
WHERE id = 23
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(23)
AND falang_content.reference_table='zoo_application'
SELECT id
FROM d4xh9_assets
WHERE parent_id = 0
SELECT 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 <= '2024-10-14 21:41:02')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-10-14 21:41:02')
GROUP BY a.id
ORDER BY a.priority DESC, a.name
LIMIT 0,5
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(1714,1405,1408,1406,1407)
AND falang_content.reference_table='zoo_item'
SELECT id
FROM d4xh9_assets
WHERE parent_id = 0
SELECT id
FROM d4xh9_assets
WHERE parent_id = 0
SELECT id
FROM d4xh9_assets
WHERE parent_id = 0
SELECT id
FROM d4xh9_assets
WHERE parent_id = 0
SELECT id
FROM d4xh9_assets
WHERE parent_id = 0
SELECT id
FROM d4xh9_assets
WHERE parent_id = 0
SELECT id
FROM d4xh9_assets
WHERE parent_id = 0
SELECT id
FROM d4xh9_assets
WHERE parent_id = 0
SELECT id
FROM d4xh9_assets
WHERE parent_id = 0
SELECT id
FROM d4xh9_assets
WHERE parent_id = 0
SELECT id
FROM d4xh9_assets
WHERE parent_id = 0
SELECT id
FROM d4xh9_assets
WHERE parent_id = 0
SELECT id
FROM d4xh9_assets
WHERE parent_id = 0
SELECT id
FROM d4xh9_assets
WHERE parent_id = 0
SELECT id
FROM d4xh9_assets
WHERE parent_id = 0
SELECT id
FROM d4xh9_assets
WHERE parent_id = 0
SELECT id
FROM d4xh9_assets
WHERE parent_id = 0
SELECT id
FROM d4xh9_assets
WHERE parent_id = 0
SELECT id
FROM d4xh9_assets
WHERE parent_id = 0
SELECT id
FROM d4xh9_assets
WHERE parent_id = 0
SELECT id
FROM d4xh9_assets
WHERE parent_id = 0
SELECT id
FROM d4xh9_assets
WHERE parent_id = 0
SELECT id
FROM d4xh9_assets
WHERE parent_id = 0
SELECT id
FROM d4xh9_assets
WHERE parent_id = 0
SELECT id
FROM d4xh9_assets
WHERE parent_id = 0
SELECT id
FROM d4xh9_assets
WHERE parent_id = 0
SELECT id
FROM d4xh9_assets
WHERE parent_id = 0
SELECT id
FROM d4xh9_assets
WHERE parent_id = 0
SELECT id
FROM d4xh9_assets
WHERE parent_id = 0
SELECT id
FROM d4xh9_assets
WHERE parent_id = 0
SELECT id
FROM d4xh9_assets
WHERE parent_id = 0
SELECT id
FROM d4xh9_assets
WHERE parent_id = 0
SELECT id
FROM d4xh9_assets
WHERE parent_id = 0
SELECT id
FROM d4xh9_assets
WHERE parent_id = 0
SELECT id
FROM d4xh9_assets
WHERE parent_id = 0
SELECT id
FROM d4xh9_assets
WHERE parent_id = 0
SELECT id
FROM d4xh9_assets
WHERE parent_id = 0
SELECT id
FROM d4xh9_assets
WHERE parent_id = 0
SELECT id
FROM d4xh9_assets
WHERE parent_id = 0
SELECT id
FROM d4xh9_assets
WHERE parent_id = 0
SELECT id
FROM d4xh9_assets
WHERE parent_id = 0
SELECT id
FROM d4xh9_assets
WHERE parent_id = 0
SELECT id
FROM d4xh9_assets
WHERE parent_id = 0
SELECT id
FROM d4xh9_assets
WHERE parent_id = 0
SELECT id
FROM d4xh9_assets
WHERE parent_id = 0
SELECT id
FROM d4xh9_assets
WHERE parent_id = 0
SELECT id
FROM d4xh9_assets
WHERE parent_id = 0
SELECT id
FROM d4xh9_assets
WHERE parent_id = 0
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 )
WHERE
(zi.publish_up = '0000-00-00 00:00:00' OR zi.publish_up <= '2024-10-14 21:41:02')
AND (zi.publish_down = '0000-00-00 00:00:00' OR zi.publish_down >= '2024-10-14 21:41:02')
AND zi.state =1
AND zi.application_id IN (26)
HAVING distance < 10
ORDER BY zi.priority DESC, zi.name ASC, zi.name ASC
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(1411,1412,1413,1800)
AND falang_content.reference_table='zoo_item'
SELECT *
FROM d4xh9_zoo_item
WHERE id = 1411
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(1411)
AND falang_content.reference_table='zoo_item'
SELECT *
FROM d4xh9_zoo_item
WHERE id = 1412
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(1412)
AND falang_content.reference_table='zoo_item'
SELECT *
FROM d4xh9_zoo_item
WHERE id = 1413
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(1413)
AND falang_content.reference_table='zoo_item'
SELECT *
FROM d4xh9_zoo_item
WHERE id = 1800
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(1800)
AND falang_content.reference_table='zoo_item'
SELECT *
FROM d4xh9_zoo_application
WHERE id = 26
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(26)
AND falang_content.reference_table='zoo_application'
SELECT *
FROM d4xh9_zoo_items_relations
WHERE name = 'Sede-Contacto'
AND item1 = 1411
SELECT id
FROM d4xh9_assets
WHERE parent_id = 0
SELECT *
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 <= '2024-10-14 21:41:02')
AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2024-10-14 21:41:02')
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 = 16
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(16)
AND falang_content.reference_table='zoo_application'
SELECT *
FROM d4xh9_zoo_category
WHERE application_id = 16
AND published = 1
ORDER BY ordering
SELECT *
FROM d4xh9_zoo_items_relations
WHERE name = 'Sede-Contacto'
AND item1 = 1412
SELECT id
FROM d4xh9_assets
WHERE parent_id = 0
SELECT *
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 <= '2024-10-14 21:41:02')
AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2024-10-14 21:41:02')
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 = 1413
SELECT id
FROM d4xh9_assets
WHERE parent_id = 0
SELECT *
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 <= '2024-10-14 21:41:02')
AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2024-10-14 21:41:02')
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 = 1800
SELECT id
FROM d4xh9_assets
WHERE parent_id = 0
SELECT *
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 <= '2024-10-14 21:41:02')
AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2024-10-14 21:41:02')
ORDER BY FIELD(id,1089)
22 Tipos de consultas del registro, Ordenado por acontecimientos.
SELECCIONAR Tablas:
93 × SELECT id
FROM d4xh9_assets
28 × SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
FROM d4xh9_falang_content AS falang_content
18 × SELECT *
FROM d4xh9_zoo_item
12 × SELECT *
FROM d4xh9_zoo_items_relations
8 × SELECT b.id
FROM d4xh9_zoo_category_item AS a JOIN d4xh9_zoo_category AS b
ON a.category_id = b.id
6 × SELECT *
FROM d4xh9_zoo_category
6 × SELECT *
FROM d4xh9_zoo_application
2 × SELECT id, title, alias, link, level, parent_id, browserNav, type, params
FROM d4xh9_menu
1 × 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 a.*
FROM d4xh9_zoo_item AS a
1 × SELECT ROWNUM
FROM (SELECT @rownum:= @rownum+1 ROWNUM, id
FROM (SELECT @rownum:=0) r, (SELECT id
FROM d4xh9_zoo_item AS a
1 × SELECT ROWNUM, id
FROM (SELECT @rownum:= @rownum+1 ROWNUM, id
FROM (SELECT @rownum:=0) r, (SELECT id
FROM d4xh9_zoo_item AS a
1 × SELECT b.rules
FROM d4xh9_assets AS a
LEFT JOIN d4xh9_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
1 × SELECT joomlatablename,tablepkID
FROM `d4xh9_falang_tableinfo
1 × SELECT *
FROM d4xh9_languages
1 × SELECT a.rules
FROM d4xh9_assets AS a
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 d4xh9_menu AS m
LEFT JOIN d4xh9_extensions AS e
ON m.component_id = e.extension_id
1 × SELECT id
FROM d4xh9_zoo_item
OTRAS Tablas:
1 × SHOW FULL COLUMNS
FROM `d4xh9_content
1 × UPDATE d4xh9_zoo_item
SET hits = (hits + 1)
1 × SHOW FULL COLUMNS
FROM `d4xh9_assets
1 × SHOW FULL COLUMNS
FROM `d4xh9_languages