Design My Journey
Design Your Sri Lanka Journey
Answer a few quick questions — skip any you are unsure about — and receive a personal proposal within 24 hours. No obligation.
Answer a few quick questions — skip any you are unsure about — and receive a personal proposal within 24 hours. No obligation.
15.22ms SELECT id, code, duration_nights, type FROM tours WHERE code = ? 6.29ms SELECT c.code FROM tour_category tc JOIN tour_categories c ON c.id = tc.category_id WHERE tc.tour_id = ? 7.75ms SELECT t.slug FROM tour_destinations td JOIN destination_translations t ON t.destination_id = td.destination_id AND t.lang = 'en' WHERE td.tour_id = ? 4.03ms SELECT x.id, x.type FROM tours x WHERE x.code = ? 7.84ms SELECT x.id, x.type, x.code, x.duration_days, x.duration_nights, x.duration_hours, x.base_price_usd, x.hero_media_id, x.is_featured, x.difficulty, x.best_months, COALESCE(NULLIF(t.title, ''), e.title) AS title, COALESCE(NULLIF(t.slug, ''), e.slug) AS slug, COALESCE(NULLIF(t.summary, ''), e.summary) AS summary, COALESCE(NULLIF(t.highlights_json, ''), e.highlights_json) AS highlights_json, COALESCE(t.is_complete, 0) AS is_complete, CASE WHEN t.id IS NULL THEN 'en' END AS content_lang FROM tours x LEFT JOIN `tour_translations` t ON t.tour_id = x.id AND t.lang = 'en' JOIN `tour_translations` e ON e.tour_id = x.id AND e.lang = 'en' WHERE (x.status = 'published' OR (x.status = 'scheduled' AND x.publish_at <= UTC_TIMESTAMP())) AND x.id IN (10) ORDER BY FIELD(x.id, 10) LIMIT 1 5.86ms SELECT d.id, d.lat, d.lng, d.hero_media_id, d.is_featured, r.code AS region_code, COALESCE(NULLIF(t.name, ''), e.name) AS name, COALESCE(NULLIF(t.slug, ''), e.slug) AS slug, COALESCE(NULLIF(t.tagline, ''), e.tagline) AS tagline, COALESCE(t.is_complete, 0) AS is_complete, CASE WHEN t.id IS NULL THEN 'en' END AS content_lang, COALESCE(NULLIF(rt.name, ''), re.name) AS region_name, (SELECT COUNT(*) FROM tour_destinations td JOIN tours x ON x.id = td.tour_id WHERE td.destination_id = d.id AND (x.status = 'published' OR (x.status = 'scheduled' AND x.publish_at <= UTC_TIMESTAMP()))) AS tour_count FROM destinations d LEFT JOIN `destination_translations` t ON t.destination_id = d.id AND t.lang = 'en' JOIN `destination_translations` e ON e.destination_id = d.id AND e.lang = 'en' LEFT JOIN regions r ON r.id = d.region_id LEFT JOIN region_translations rt ON rt.region_id = r.id AND rt.lang = 'en' LEFT JOIN region_translations re ON re.region_id = r.id AND re.lang = 'en' WHERE (d.status = 'published' OR (d.status = 'scheduled' AND d.publish_at <= UTC_TIMESTAMP())) ORDER BY r.sort_order, d.sort_order 5.56ms SELECT destination_id, slug FROM destination_translations WHERE lang = 'en' 6.48ms SELECT c.id, c.code, c.icon, c.hero_media_id, c.is_mood, COALESCE(NULLIF(t.name, ''), e.name) AS name, COALESCE(NULLIF(t.slug, ''), e.slug) AS slug, COALESCE(NULLIF(t.mood_label, ''), e.mood_label) AS mood_label, COALESCE(NULLIF(t.intro, ''), e.intro) AS intro, COALESCE(t.is_complete, 0) AS is_complete, CASE WHEN t.id IS NULL THEN 'en' END AS content_lang, (SELECT COUNT(*) FROM tour_category tc JOIN tours x ON x.id = tc.tour_id WHERE tc.category_id = c.id AND (x.status = 'published' OR (x.status = 'scheduled' AND x.publish_at <= UTC_TIMESTAMP()))) AS tour_count FROM tour_categories c LEFT JOIN `tour_category_translations` t ON t.category_id = c.id AND t.lang = 'en' JOIN `tour_category_translations` e ON e.category_id = c.id AND e.lang = 'en' ORDER BY c.sort_order 7.2ms SELECT m.id, m.dir, m.basename, m.ext, m.width, m.height, m.focal_x, m.focal_y, m.version, m.dominant_color, m.is_sample, m.credit, m.credit_url, m.licence, COALESCE(NULLIF(t.alt, ''), e.alt, '') AS alt, COALESCE(t.caption, e.caption) AS caption, v.width AS v_w, v.height AS v_h, v.format AS v_format FROM media m LEFT JOIN media_translations t ON t.media_id = m.id AND t.lang = 'en' LEFT JOIN media_translations e ON e.media_id = m.id AND e.lang = 'en' LEFT JOIN media_variants v ON v.media_id = m.id WHERE m.id IN (12) ORDER BY m.id, v.width 5.47ms SELECT p.system_key, COALESCE(t.slug, e.slug) AS slug FROM pages p LEFT JOIN page_translations t ON t.page_id = p.id AND t.lang = 'en' JOIN page_translations e ON e.page_id = p.id AND e.lang = 'en' WHERE p.system_key IS NOT NULL