GLOBALDIT Y SU FILIAL MEXICANA IDT ES UNA EMPRESA INTERNACIONAL DE ASESORAMIENTO EXPERTO EN EL SECTOR VIAJES, TURISMO Y OCIO. SOMOS UNA FIRMA DE REFERENCIA PARA PROYECTOS DE DESARROLLO INCLUSIVO Y TECNOLOGÍAS APLICADAS AL TURISMO. EN NUESTRO NEW BOOK 2019 TE CONTAMOS CÓMO TRABAJAMOS.
BOOK 2020Aceptar
session.client.forwarded ⇒ 35.171.164.77
session.client.browser ⇒ CCBot/2.0 (https://commoncrawl.org/faq/)
password_clear ⇒
groups ⇒
session.token ⇒ 1502cfe85d0c05e343c1205d6df456b0
Application 0.000 seconds (+0.000); 0.34 MB (+0.341) - afterLoad
Application 0.056 seconds (+0.056); 1.59 MB (+1.248) - afterInitialise
Application 0.076 seconds (+0.020); 2.01 MB (+0.422) - afterRoute
Application 0.441 seconds (+0.364); 5.36 MB (+3.348) - afterDispatch
Application 0.444 seconds (+0.004); 5.52 MB (+0.159) - beforeRenderModule mod_zooitem (Microsites (zona globaldit))
Application 0.512 seconds (+0.068); 6.17 MB (+0.657) - afterRenderModule mod_zooitem (Microsites (zona globaldit))
Application 0.515 seconds (+0.002); 6.12 MB (-0.056) - beforeRenderModule mod_compartir (Compartir)
Application 0.515 seconds (+0.001); 6.13 MB (+0.008) - afterRenderModule mod_compartir (Compartir)
Application 0.516 seconds (+0.001); 6.13 MB (+0.002) - beforeRenderModule mod_contact (Contacto)
Application 0.568 seconds (+0.051); 7.46 MB (+1.327) - afterRenderModule mod_contact (Contacto)
Application 0.574 seconds (+0.006); 7.49 MB (+0.037) - afterRender
7.53 MB (7,892,280 Bytes)
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 *
FROM d4xh9_zoo_application
WHERE id = 17
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(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.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
SET SESSION group_concat_max_len = 1048576
SELECT c.*, GROUP_CONCAT(DISTINCT i.id) as item_ids
FROM d4xh9_zoo_category as c USE INDEX (APPLICATIONID_ID_INDEX)
LEFT JOIN d4xh9_zoo_category_item as ci
ON ci.category_id = c.id
LEFT JOIN d4xh9_zoo_item AS i USE INDEX (MULTI_INDEX2)
ON ci.item_id = i.id
AND i.access IN (1)
AND i.state = 1
AND (i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2024-10-13 08:28:14')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-10-13 08:28:14')
WHERE c.application_id = 17
AND c.published = 1
GROUP BY c.id
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(44,45,47)
AND falang_content.reference_table='zoo_category'
SELECT id
FROM d4xh9_assets
WHERE parent_id = 0
SELECT a.*
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 <= '2024-10-13 08:28:14')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-10-13 08:28:14')
GROUP BY a.id
ORDER BY a.priority DESC, a.created DESC
LIMIT 120,20
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(1284,1283,1335,1282,1281,1280,1279,1338,1340,1337,1339,1341,1331)
AND falang_content.reference_table='zoo_item'
SELECT id
FROM d4xh9_assets
WHERE parent_id = 0
SELECT a.*
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 <= '2024-10-13 08:28:14')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-10-13 08:28:14')
GROUP BY a.id
ORDER BY a.priority DESC, a.created DESC
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(1811,1810,1791,1789,1790,1792,1788,1782,1770,1781,1773,1780,1778,1769,1768,1766,1765,1764,1763,1753,1752,1754,1751,1743,1744,1749,1745,1747,1391,1257,1296,1748,1390,1255,1389,1750,1388,1746,1387,1381,1256,1294,1347,1345,1346,1348,1250,1258,1259,1293,1343,1344,1323,1386,1385,1326,1384,1383,1249,1252,1253,1382,1328,1254,1174,1325,1260,1261,1199,1173,1262,1263,1264,1324,1182,1327,1172,1265,1329,1180,1266,1267,1269,1179,1178,1198,1177,1330,1197,1196,1195,1176,1268,1175,1274,1194,1193,1273,1333,1271,1270,1272,1334,1191,1192,1342,1276,1275,1278,1277,1332,1292,1290,1291,1289,1288,1336,1287,1286,1285,1284,1283,1335,1282,1281,1280,1279,1338,1340,1337,1339,1341,1331)
AND falang_content.reference_table='zoo_item'
SHOW FULL COLUMNS
FROM `d4xh9_content`
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 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=1284
AND b.published = 1 UNION SELECT 0
FROM d4xh9_zoo_category_item AS a
WHERE a.item_id=1284
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 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=1283
AND b.published = 1 UNION SELECT 0
FROM d4xh9_zoo_category_item AS a
WHERE a.item_id=1283
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 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 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=1282
AND b.published = 1 UNION SELECT 0
FROM d4xh9_zoo_category_item AS a
WHERE a.item_id=1282
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 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=1281
AND b.published = 1 UNION SELECT 0
FROM d4xh9_zoo_category_item AS a
WHERE a.item_id=1281
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 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=1280
AND b.published = 1 UNION SELECT 0
FROM d4xh9_zoo_category_item AS a
WHERE a.item_id=1280
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 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=1279
AND b.published = 1 UNION SELECT 0
FROM d4xh9_zoo_category_item AS a
WHERE a.item_id=1279
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 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=1338
AND b.published = 1 UNION SELECT 0
FROM d4xh9_zoo_category_item AS a
WHERE a.item_id=1338
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 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=1340
AND b.published = 1 UNION SELECT 0
FROM d4xh9_zoo_category_item AS a
WHERE a.item_id=1340
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 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=1337
AND b.published = 1 UNION SELECT 0
FROM d4xh9_zoo_category_item AS a
WHERE a.item_id=1337
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 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=1339
AND b.published = 1 UNION SELECT 0
FROM d4xh9_zoo_category_item AS a
WHERE a.item_id=1339
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 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=1341
AND b.published = 1 UNION SELECT 0
FROM d4xh9_zoo_category_item AS a
WHERE a.item_id=1341
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 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=1331
AND b.published = 1 UNION SELECT 0
FROM d4xh9_zoo_category_item AS a
WHERE a.item_id=1331
AND a.category_id = 0
SELECT id
FROM d4xh9_assets
WHERE parent_id = 0
SELECT id
FROM d4xh9_assets
WHERE parent_id = 0
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-13 08:28:14')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-10-13 08:28:14')
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-13 08:28:15')
AND (zi.publish_down = '0000-00-00 00:00:00' OR zi.publish_down >= '2024-10-13 08:28:15')
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-13 08:28:14')
AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2024-10-13 08:28:14')
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-13 08:28:14')
AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2024-10-13 08:28:14')
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-13 08:28:14')
AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2024-10-13 08:28:14')
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-13 08:28:14')
AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2024-10-13 08:28:14')
ORDER BY FIELD(id,1089)
160 × SELECT id
FROM d4xh9_assets
16 × SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
FROM d4xh9_falang_content AS falang_content
12 × SELECT b.id
FROM d4xh9_zoo_category_item AS a JOIN d4xh9_zoo_category AS b
ON a.category_id = b.id
8 × SELECT *
FROM d4xh9_zoo_item
4 × SELECT *
FROM d4xh9_zoo_items_relations
4 × SELECT *
FROM d4xh9_zoo_application
2 × SELECT a.*
FROM d4xh9_zoo_item AS a
LEFT JOIN d4xh9_zoo_category_item AS b
ON a.id = b.item_id
1 × SELECT a.*
FROM d4xh9_zoo_item AS a
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 *
FROM d4xh9_zoo_category
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 c.*, GROUP_CONCAT(DISTINCT i.id) as item_ids
FROM d4xh9_zoo_category as c USE INDEX (APPLICATIONID_ID_INDEX)
LEFT JOIN d4xh9_zoo_category_item as ci
ON ci.category_id = c.id
LEFT JOIN d4xh9_zoo_item AS i USE INDEX (MULTI_INDEX2)
ON ci.item_id = i.id
AND i.access IN (1)
AND i.state = 1
AND (i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2024-10-13 08:28:14')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-10-13 08:28:14')
1 × SHOW FULL COLUMNS
FROM `d4xh9_content
1 ×
SET SESSION group_concat_max_len = 104857
1 × SHOW FULL COLUMNS
FROM `d4xh9_assets
1 × SHOW FULL COLUMNS
FROM `d4xh9_languages