2.3ms 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.9ms 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
19.21ms SELECT r.car_usd, r.van_usd, r.duration_minutes, d.id AS destination_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 FROM transfer_routes r JOIN destinations d ON d.id = r.destination_id 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' ORDER BY r.sort_order
4.24ms 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 (7) ORDER BY m.id, v.width