82.1 ms · 10.7 MB · 6 queries
40.35ms SELECT hotel_id FROM `hotel_translations` WHERE lang = ? AND slug = ?
10.64ms SELECT h.*, COALESCE(NULLIF(t.name, ''), e.name) AS name, COALESCE(NULLIF(t.slug, ''), e.slug) AS slug, COALESCE(NULLIF(t.summary, ''), e.summary) AS summary, COALESCE(NULLIF(t.body, ''), e.body) AS body, 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, COALESCE(NULLIF(dt.name, ''), de.name) AS destination_name, COALESCE(dt.slug, de.slug) AS destination_slug, (SELECT GROUP_CONCAT(CONCAT(sm.lang, ':', sm.slug) SEPARATOR '|') FROM `hotel_translations` sm WHERE sm.hotel_id = h.id AND sm.is_complete = 1 AND sm.noindex = 0 AND sm.canonical_url IS NULL) AS slug_map, (SELECT GROUP_CONCAT(media_id ORDER BY sort_order) FROM hotel_media WHERE hotel_id = h.id) AS gallery_ids FROM hotels h LEFT JOIN `hotel_translations` t ON t.hotel_id = h.id AND t.lang = 'en' JOIN `hotel_translations` e ON e.hotel_id = h.id AND e.lang = 'en' LEFT JOIN destination_translations dt ON dt.destination_id = h.destination_id AND dt.lang = 'en' LEFT JOIN destination_translations de ON de.destination_id = h.destination_id AND de.lang = 'en' WHERE h.id = ? AND (h.status = 'published' OR (h.status = 'scheduled' AND h.publish_at <= UTC_TIMESTAMP()))
7.72ms 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 (28) ORDER BY m.id, v.width
0.86ms 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
2.1ms 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 tour_destinations td ON td.tour_id = x.id AND td.destination_id = ? WHERE (x.status = 'published' OR (x.status = 'scheduled' AND x.publish_at <= UTC_TIMESTAMP())) ORDER BY x.type = 'day', x.is_featured DESC, x.sort_order LIMIT 3
1.73ms 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,23,43) ORDER BY m.id, v.width