97.4 ms · 10.7 MB · 10 queries
20.41ms SELECT tour_id FROM `tour_translations` WHERE lang = ? AND slug = ?
5.11ms SELECT x.*, 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(NULLIF(t.body, ''), e.body) AS body, COALESCE(NULLIF(t.inclusions, ''), e.inclusions) AS inclusions, COALESCE(NULLIF(t.exclusions, ''), e.exclusions) AS exclusions, COALESCE(NULLIF(t.start_end_note, ''), e.start_end_note) AS start_end_note, 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 `tour_translations` sm WHERE sm.tour_id = x.id AND sm.is_complete = 1 AND sm.noindex = 0 AND sm.canonical_url IS NULL) AS slug_map, (SELECT GROUP_CONCAT(CONCAT(tier, ':', price_usd) ORDER BY FIELD(tier, 'standard', 'luxury', 'boutique') SEPARATOR '|') FROM tour_price_tiers WHERE tour_id = x.id) AS tier_map, (SELECT GROUP_CONCAT(media_id ORDER BY sort_order) FROM tour_media WHERE tour_id = x.id) AS gallery_ids, (SELECT COUNT(*) FROM reviews r WHERE r.tour_id = x.id AND r.is_published = 1 AND r.is_sample = 0) AS review_count, (SELECT AVG(r.rating) FROM reviews r WHERE r.tour_id = x.id AND r.is_published = 1 AND r.is_sample = 0) AS review_avg, (SELECT COALESCE(NULLIF(pt.name, ''), pe.name) FROM destination_translations pe LEFT JOIN destination_translations pt ON pt.destination_id = pe.destination_id AND pt.lang = 'en' WHERE pe.destination_id = x.start_destination_id AND pe.lang = 'en') AS start_name, (SELECT COALESCE(NULLIF(pt.name, ''), pe.name) FROM destination_translations pe LEFT JOIN destination_translations pt ON pt.destination_id = pe.destination_id AND pt.lang = 'en' WHERE pe.destination_id = x.end_destination_id AND pe.lang = 'en') AS end_name 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.id = ? AND x.type = ? AND (x.status = 'published' OR (x.status = 'scheduled' AND x.publish_at <= UTC_TIMESTAMP()))
5.04ms SELECT d.id, d.day_no, d.meals, d.overnight_destination_id, COALESCE(NULLIF(t.title, ''), e.title) AS title, COALESCE(NULLIF(t.description, ''), e.description) AS description, COALESCE(NULLIF(t.activities, ''), e.activities) AS activities, COALESCE(NULLIF(t.overnight_note, ''), e.overnight_note) AS overnight_note, COALESCE(t.is_complete, 0) AS is_complete, CASE WHEN t.id IS NULL THEN 'en' END AS content_lang, COALESCE(NULLIF(ot.name, ''), oe.name) AS overnight_name FROM tour_days d LEFT JOIN `tour_day_translations` t ON t.tour_day_id = d.id AND t.lang = 'en' JOIN `tour_day_translations` e ON e.tour_day_id = d.id AND e.lang = 'en' LEFT JOIN destination_translations ot ON ot.destination_id = d.overnight_destination_id AND ot.lang = 'en' LEFT JOIN destination_translations oe ON oe.destination_id = d.overnight_destination_id AND oe.lang = 'en' WHERE d.tour_id = ? ORDER BY d.sort_order, d.day_no
3.67ms SELECT dd.tour_day_id, dest.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 tour_day_destinations dd JOIN destinations dest ON dest.id = dd.destination_id LEFT JOIN `destination_translations` t ON t.destination_id = dest.id AND t.lang = 'en' JOIN `destination_translations` e ON e.destination_id = dest.id AND e.lang = 'en' WHERE dd.tour_day_id IN (1,2,3,4,5,6,7,8) AND (dest.status = 'published' OR (dest.status = 'scheduled' AND dest.publish_at <= UTC_TIMESTAMP())) ORDER BY dd.sort_order
2.36ms SELECT dest.id, dest.lat, dest.lng, 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 tour_destinations td JOIN destinations dest ON dest.id = td.destination_id LEFT JOIN `destination_translations` t ON t.destination_id = dest.id AND t.lang = 'en' JOIN `destination_translations` e ON e.destination_id = dest.id AND e.lang = 'en' WHERE td.tour_id = ? AND (dest.status = 'published' OR (dest.status = 'scheduled' AND dest.publish_at <= UTC_TIMESTAMP())) ORDER BY td.sort_order
2ms SELECT c.id, c.code, 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 tour_category tc JOIN tour_categories c ON c.id = tc.category_id LEFT JOIN `tour_category_translations` t ON t.category_id = c.id AND t.lang = 'en' JOIN `tour_category_translations` e ON e.category_id = c.id AND e.lang = 'en' WHERE tc.tour_id = ? ORDER BY c.sort_order
3.53ms 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' JOIN ( SELECT id, MIN(pri) AS pri, MIN(so) AS so FROM ( SELECT related_id AS id, 0 AS pri, sort_order AS so FROM tour_related WHERE tour_id = ? UNION ALL SELECT tc2.tour_id, 1, 0 FROM tour_category tc1 JOIN tour_category tc2 ON tc2.category_id = tc1.category_id AND tc2.tour_id <> tc1.tour_id WHERE tc1.tour_id = ? ) c GROUP BY id ) rel ON rel.id = x.id WHERE (x.status = 'published' OR (x.status = 'scheduled' AND x.publish_at <= UTC_TIMESTAMP())) ORDER BY rel.pri, rel.so, x.sort_order LIMIT 3
3.69ms SELECT f.id, COALESCE(NULLIF(t.question, ''), e.question) AS question, COALESCE(NULLIF(t.answer, ''), e.answer) AS answer, COALESCE(t.is_complete, 0) AS is_complete, CASE WHEN t.id IS NULL THEN 'en' END AS content_lang FROM faqs f LEFT JOIN `faq_translations` t ON t.faq_id = f.id AND t.lang = 'en' JOIN `faq_translations` e ON e.faq_id = f.id AND e.lang = 'en' WHERE f.owner_type = ? AND f.owner_id = 1 ORDER BY f.sort_order
4.01ms 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' JOIN `post_tours` pv ON pv.post_id = p.id AND pv.tour_id = ? WHERE (p.status = 'published' OR (p.status = 'scheduled' AND p.publish_at <= UTC_TIMESTAMP())) ORDER BY p.publish_at DESC LIMIT 3
7.66ms 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 (33,27,18,37,9,23,12,16,11) ORDER BY m.id, v.width