92.7 ms · 10.7 MB · 2 queries
22.85ms SELECT o.id, o.tour_id, o.valid_from, o.valid_to, o.price_usd, o.was_price_usd, o.hero_media_id, COALESCE(NULLIF(t.title, ''), e.title) AS title, COALESCE(NULLIF(t.slug, ''), e.slug) AS slug, COALESCE(NULLIF(t.badge, ''), e.badge) AS badge, COALESCE(NULLIF(t.summary, ''), e.summary) AS summary, COALESCE(NULLIF(t.body, ''), e.body) AS body, COALESCE(NULLIF(t.terms, ''), e.terms) AS terms, COALESCE(t.is_complete, 0) AS is_complete, CASE WHEN t.id IS NULL THEN 'en' END AS content_lang, tr.type AS tour_type, COALESCE(tt.slug, te.slug) AS tour_slug FROM offers o LEFT JOIN `offer_translations` t ON t.offer_id = o.id AND t.lang = 'en' JOIN `offer_translations` e ON e.offer_id = o.id AND e.lang = 'en' LEFT JOIN tours tr ON tr.id = o.tour_id AND (tr.status = 'published' OR (tr.status = 'scheduled' AND tr.publish_at <= UTC_TIMESTAMP())) LEFT JOIN tour_translations tt ON tt.tour_id = tr.id AND tt.lang = 'en' LEFT JOIN tour_translations te ON te.tour_id = tr.id AND te.lang = 'en' WHERE (o.status = 'published' OR (o.status = 'scheduled' AND o.publish_at <= UTC_TIMESTAMP())) AND (o.valid_from IS NULL OR o.valid_from <= UTC_DATE()) AND (o.valid_to IS NULL OR o.valid_to >= UTC_DATE()) ORDER BY o.sort_order
2.11ms 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 (26,13) ORDER BY m.id, v.width