Travel Journal

Stories, ideas and practical tips from our team in Sri Lanka.

Green ridges and valleys seen from Little Adam's Peak, Ella

Travel tips

How to Plan Your First Trip to Sri Lanka

How many days you need, which regions to combine, when to go and how to get around — a practical guide to planning a first visit.

2 min read

74.6 ms · 10.7 MB · 4 queries
11.65ms  SELECT COUNT(*) FROM posts p WHERE (p.status = 'published' OR (p.status = 'scheduled' AND p.publish_at <= UTC_TIMESTAMP())) AND p.type = ?
4.36ms  SELECT p.id, p.type, p.guide_key, p.hero_media_id, p.is_featured, p.publish_at, p.created_at, p.updated_at, p.category_id, p.author_id, COALESCE(NULLIF(t.title, ''), e.title) AS title, COALESCE(NULLIF(t.slug, ''), e.slug) AS slug, COALESCE(NULLIF(t.excerpt, ''), e.excerpt) AS excerpt, COALESCE(NULLIF(t.reading_minutes, ''), e.reading_minutes) AS reading_minutes, COALESCE(t.is_complete, 0) AS is_complete, CASE WHEN t.id IS NULL THEN 'en' END AS content_lang, COALESCE(NULLIF(ct.name, ''), ce.name) AS category_name, COALESCE(ct.slug, ce.slug) AS category_slug FROM posts p LEFT JOIN `post_translations` t ON t.post_id = p.id AND t.lang = 'en' JOIN `post_translations` e ON e.post_id = p.id AND e.lang = 'en' LEFT JOIN post_category_translations ct ON ct.category_id = p.category_id AND ct.lang = 'en' LEFT JOIN post_category_translations ce ON ce.category_id = p.category_id AND ce.lang = 'en' WHERE (p.status = 'published' OR (p.status = 'scheduled' AND p.publish_at <= UTC_TIMESTAMP())) AND p.type = ? ORDER BY COALESCE(p.publish_at, p.created_at) DESC LIMIT 9 OFFSET 0
5.47ms  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 (11,23,43,30,33,39) ORDER BY m.id, v.width
17.89ms  SELECT c.id, COALESCE(NULLIF(t.name, ''), e.name) AS name, COALESCE(NULLIF(t.slug, ''), e.slug) AS slug, COALESCE(t.is_complete, 0) AS is_complete, CASE WHEN t.id IS NULL THEN 'en' END AS content_lang, (SELECT COUNT(*) FROM posts p WHERE p.category_id = c.id AND p.type = 'blog' AND (p.status = 'published' OR (p.status = 'scheduled' AND p.publish_at <= UTC_TIMESTAMP()))) AS n FROM post_categories c LEFT JOIN `post_category_translations` t ON t.category_id = c.id AND t.lang = 'en' JOIN `post_category_translations` e ON e.category_id = c.id AND e.lang = 'en' ORDER BY c.sort_order