Travel journal

Food & drink

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

93.3 ms · 10.7 MB · 7 queries
12.31ms  SELECT category_id FROM `post_category_translations` WHERE lang = ? AND slug = ?
8.03ms  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 = ?
5.8ms  SELECT lang, slug FROM `post_category_translations` WHERE category_id = ? AND is_complete = 1 AND noindex = 0 AND canonical_url IS NULL
7.95ms  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 = 4
11.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 = ? AND p.category_id = 4 ORDER BY COALESCE(p.publish_at, p.created_at) DESC LIMIT 9 OFFSET 0
6.06ms  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 (30) ORDER BY m.id, v.width
8.46ms  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