Travel journal

Travel tips

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

78.8 ms · 10.7 MB · 7 queries
11.34ms  SELECT category_id FROM `post_category_translations` WHERE lang = ? AND slug = ?
5.22ms  SELECT c.id, COALESCE(NULLIF(t.name, ''), e.name) AS name, COALESCE(NULLIF(t.slug, ''), e.slug) AS slug, COALESCE(NULLIF(t.intro, ''), e.intro) AS intro, COALESCE(NULLIF(t.meta_title, ''), e.meta_title) AS meta_title, COALESCE(NULLIF(t.meta_description, ''), e.meta_description) AS meta_description, COALESCE(t.is_complete, 0) AS is_complete, CASE WHEN t.id IS NULL THEN 'en' END AS content_lang, COALESCE(t.og_image_id, e.og_image_id) AS og_image_id, t.canonical_url AS canonical_url, COALESCE(t.noindex, 0) AS seo_noindex 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' WHERE c.id = ?
1.37ms  SELECT lang, slug FROM `post_category_translations` WHERE category_id = ? AND is_complete = 1 AND noindex = 0 AND canonical_url IS NULL
5.43ms  SELECT COUNT(*) FROM posts p WHERE (p.status = 'published' OR (p.status = 'scheduled' AND p.publish_at <= UTC_TIMESTAMP())) AND p.type = ? AND p.category_id = 1
5.78ms  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 = ? AND p.category_id = 1 ORDER BY COALESCE(p.publish_at, p.created_at) DESC LIMIT 9 OFFSET 0
5.59ms  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,39) ORDER BY m.id, v.width
2.43ms  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