32.6 ms · 10.7 MB · 13 queries
1.28ms SELECT page_id FROM `page_translations` WHERE lang = ? AND slug = ?
1.06ms SELECT x.*, COALESCE(NULLIF(t.title, ''), e.title) AS title, 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, (SELECT GROUP_CONCAT(CONCAT(sm.lang, ':', sm.slug) SEPARATOR '|') FROM `page_translations` sm WHERE sm.page_id = x.id AND sm.is_complete = 1 AND sm.noindex = 0 AND sm.canonical_url IS NULL) AS slug_map FROM pages x LEFT JOIN `page_translations` t ON t.page_id = x.id AND t.lang = 'en' JOIN `page_translations` e ON e.page_id = x.id AND e.lang = 'en' WHERE x.id = ? AND (x.status = 'published' OR (x.status = 'scheduled' AND x.publish_at <= UTC_TIMESTAMP()))
0.61ms SELECT b.id, b.type, b.settings, t.data AS tdata, e.data AS edata FROM page_blocks b LEFT JOIN page_block_translations t ON t.block_id = b.id AND t.lang = 'en' LEFT JOIN page_block_translations e ON e.block_id = b.id AND e.lang = 'en' WHERE b.page_id = ? AND b.is_visible = 1 ORDER BY b.sort_order
0.52ms SELECT COUNT(*) FROM tours x WHERE (x.status = 'published' OR (x.status = 'scheduled' AND x.publish_at <= UTC_TIMESTAMP())) AND x.type = ?
0.99ms 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.type = ? ORDER BY x.is_featured DESC, x.sort_order, x.id LIMIT 200 OFFSET 0
0.51ms SELECT COUNT(*) FROM tours x WHERE (x.status = 'published' OR (x.status = 'scheduled' AND x.publish_at <= UTC_TIMESTAMP())) AND x.type = ?
0.94ms 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.type = ? ORDER BY x.is_featured DESC, x.sort_order, x.id LIMIT 200 OFFSET 0
1.95ms 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
0.97ms SELECT x.id, x.icon, x.hero_media_id, x.best_months, x.is_featured, 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.when_note, ''), e.when_note) AS when_note, COALESCE(t.is_complete, 0) AS is_complete, CASE WHEN t.id IS NULL THEN 'en' END AS content_lang FROM experiences x LEFT JOIN `experience_translations` t ON t.experience_id = x.id AND t.lang = 'en' JOIN `experience_translations` e ON e.experience_id = x.id AND e.lang = 'en' WHERE (x.status = 'published' OR (x.status = 'scheduled' AND x.publish_at <= UTC_TIMESTAMP())) ORDER BY x.sort_order
0.49ms SELECT COUNT(*) FROM posts p WHERE (p.status = 'published' OR (p.status = 'scheduled' AND p.publish_at <= UTC_TIMESTAMP())) AND p.type = ?
4.49ms 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 100 OFFSET 0
0.54ms SELECT COUNT(*) FROM posts p WHERE (p.status = 'published' OR (p.status = 'scheduled' AND p.publish_at <= UTC_TIMESTAMP())) AND p.type = ?
1.51ms 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 200 OFFSET 0