Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.external_url AS external_url_3,
  t0.target AS target_4,
  t0.position AS position_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.parent_id AS parent_id_8,
  t0.menu_id AS menu_id_9,
  t0.url_alias_id AS url_alias_id_10
FROM
  menu_link t0
WHERE
  t0.parent_id = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.label AS label_2, t0.external_url AS external_url_3, t0.target AS target_4, t0.position AS position_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.parent_id AS parent_id_8, t0.menu_id AS menu_id_9, t0.url_alias_id AS url_alias_id_10 FROM menu_link t0 WHERE t0.parent_id = 676 ORDER BY t0.position ASC;

SELECT
  t0.id AS id_1,
  t0.slug AS slug_2,
  t0.path AS path_3,
  t0.entity_type AS entity_type_4,
  t0.entity_id AS entity_id_5,
  t0.route_name AS route_name_6,
  t0.pathauto AS pathauto_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.parent_id AS parent_id_10
FROM
  url_alias t0
WHERE
  t0.entity_type = ?
  AND t0.entity_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.path AS path_3, t0.entity_type AS entity_type_4, t0.entity_id AS entity_id_5, t0.route_name AS route_name_6, t0.pathauto AS pathauto_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.parent_id AS parent_id_10 FROM url_alias t0 WHERE t0.entity_type = 'thematique' AND t0.entity_id = 532 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.length AS length_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.travel_description_id AS travel_description_id_5
FROM
  travel_length t0
WHERE
  t0.travel_description_id = ?

SELECT t0.id AS id_1, t0.length AS length_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.travel_description_id AS travel_description_id_5 FROM travel_length t0 WHERE t0.travel_description_id = 7549;

SELECT
  t0.id AS id_1,
  t0.date_start AS date_start_2,
  t0.date_end AS date_end_3,
  t0.length AS length_4,
  t0.price AS price_5,
  t0.price_full AS price_full_6,
  t0.price_type AS price_type_7,
  t0.promo_price AS promo_price_8,
  t0.available AS available_9,
  t0.length_unit AS length_unit_10,
  t0.seat_code AS seat_code_11,
  t0.transport_code AS transport_code_12,
  t0.imported_at AS imported_at_13,
  t0.travel_offer_id AS travel_offer_id_14
FROM
  price_entry t0
WHERE
  t0.travel_offer_id = ?

SELECT t0.id AS id_1, t0.date_start AS date_start_2, t0.date_end AS date_end_3, t0.length AS length_4, t0.price AS price_5, t0.price_full AS price_full_6, t0.price_type AS price_type_7, t0.promo_price AS promo_price_8, t0.available AS available_9, t0.length_unit AS length_unit_10, t0.seat_code AS seat_code_11, t0.transport_code AS transport_code_12, t0.imported_at AS imported_at_13, t0.travel_offer_id AS travel_offer_id_14 FROM price_entry t0 WHERE t0.travel_offer_id = 2096;

SELECT
  t0_.id AS id_0,
  t0_.name AS name_1,
  t0_.subtitle AS subtitle_2,
  t0_.intro AS intro_3,
  t0_.thumb_label AS thumb_label_4,
  t0_.image AS image_5,
  t0_.image_header AS image_header_6,
  t0_.tooltip AS tooltip_7,
  t0_.tooltip_link AS tooltip_link_8,
  t0_.highlighted AS highlighted_9,
  t0_.active AS active_10,
  t0_.position AS position_11,
  t0_.created_at AS created_at_12,
  t0_.updated_at AS updated_at_13,
  t0_.seo_title AS seo_title_14,
  t0_.seo_description AS seo_description_15,
  t0_.seo_keywords AS seo_keywords_16,
  t0_.seo_canonical AS seo_canonical_17,
  t0_.seo_key AS seo_key_18,
  t0_.seo_robots AS seo_robots_19,
  t0_.seo_sitemap AS seo_sitemap_20,
  t0_.taxonomy_id AS taxonomy_id_21,
  t0_.logo_id AS logo_id_22
FROM
  travel_term t0_
WHERE
  EXISTS (
    SELECT
      1
    FROM
      travel_description_travel_term t1_
    WHERE
      t1_.travel_term_id = t0_.id
      AND t1_.travel_description_id IN (?)
  )
  AND t0_.active = 1
ORDER BY
  t0_.position ASC
LIMIT
  3

SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.subtitle AS subtitle_2, t0_.intro AS intro_3, t0_.thumb_label AS thumb_label_4, t0_.image AS image_5, t0_.image_header AS image_header_6, t0_.tooltip AS tooltip_7, t0_.tooltip_link AS tooltip_link_8, t0_.highlighted AS highlighted_9, t0_.active AS active_10, t0_.position AS position_11, t0_.created_at AS created_at_12, t0_.updated_at AS updated_at_13, t0_.seo_title AS seo_title_14, t0_.seo_description AS seo_description_15, t0_.seo_keywords AS seo_keywords_16, t0_.seo_canonical AS seo_canonical_17, t0_.seo_key AS seo_key_18, t0_.seo_robots AS seo_robots_19, t0_.seo_sitemap AS seo_sitemap_20, t0_.taxonomy_id AS taxonomy_id_21, t0_.logo_id AS logo_id_22 FROM travel_term t0_ WHERE EXISTS (SELECT 1 FROM travel_description_travel_term t1_ WHERE t1_.travel_term_id = t0_.id AND t1_.travel_description_id IN (7648)) AND t0_.active = 1 ORDER BY t0_.position ASC LIMIT 3;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.label AS label_3,
  t0.width AS width_4,
  t0.height AS height_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7
FROM
  image_style t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.label AS label_3, t0.width AS width_4, t0.height AS height_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM image_style t0 WHERE t0.name = 'header-small' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.filename AS filename_2,
  t0.caption AS caption_3,
  t0.type AS type_4,
  t0.position AS position_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.travel_description_id AS travel_description_id_8
FROM
  travel_image t0
WHERE
  t0.travel_description_id = ?

SELECT t0.id AS id_1, t0.filename AS filename_2, t0.caption AS caption_3, t0.type AS type_4, t0.position AS position_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.travel_description_id AS travel_description_id_8 FROM travel_image t0 WHERE t0.travel_description_id = 7648;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.title_h1 AS title_h1_3,
  t0.image AS image_4,
  t0.content AS content_5,
  t0.published AS published_6,
  t0.archived AS archived_7,
  t0.filter_calendar AS filter_calendar_8,
  t0.on_homepage AS on_homepage_9,
  t0.highlighted AS highlighted_10,
  t0.promoted AS promoted_11,
  t0.print_tab AS print_tab_12,
  t0.created_at AS created_at_13,
  t0.updated_at AS updated_at_14,
  t0.seo_title AS seo_title_15,
  t0.seo_description AS seo_description_16,
  t0.seo_keywords AS seo_keywords_17,
  t0.seo_canonical AS seo_canonical_18,
  t0.seo_key AS seo_key_19,
  t0.seo_robots AS seo_robots_20,
  t0.seo_sitemap AS seo_sitemap_21
FROM
  thematique t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.title_h1 AS title_h1_3, t0.image AS image_4, t0.content AS content_5, t0.published AS published_6, t0.archived AS archived_7, t0.filter_calendar AS filter_calendar_8, t0.on_homepage AS on_homepage_9, t0.highlighted AS highlighted_10, t0.promoted AS promoted_11, t0.print_tab AS print_tab_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.seo_title AS seo_title_15, t0.seo_description AS seo_description_16, t0.seo_keywords AS seo_keywords_17, t0.seo_canonical AS seo_canonical_18, t0.seo_key AS seo_key_19, t0.seo_robots AS seo_robots_20, t0.seo_sitemap AS seo_sitemap_21 FROM thematique t0 WHERE t0.id = 532;

SELECT
  collapsed.id
FROM
  (
    SELECT
      td.id,
      td.title,
      ROW_NUMBER() OVER (
        PARTITION BY
          COALESCE(td.variant_group_id, td.id)
        ORDER BY
          td.canonical DESC,
          td.id ASC
      ) AS rn
    FROM
      travel_description td
    WHERE
      td.published = 1
      AND (
        (
          td.offer_type = 'unique'
          AND td.unique_price > 0
        )
        OR EXISTS (
          SELECT
            1
          FROM
            travel_offer o
            INNER JOIN price_entry pe ON pe.travel_offer_id = o.id
          WHERE
            o.code = td.offer_code
            AND (
              (
                pe.price_type != 'transport'
                AND pe.price_full > 0
              )
              OR (
                pe.price_type = 'transport'
                AND pe.price_full > 0
                AND NOT EXISTS (
                  SELECT
                    1
                  FROM
                    price_entry pe2
                  WHERE
                    pe2.travel_offer_id = pe.travel_offer_id
                    AND pe2.price_type != 'transport'
                    AND pe2.price_full > 0
                )
              )
            )
        )
      )
      AND EXISTS (
        SELECT
          1
        FROM
          travel_thematique tt
        WHERE
          tt.travel_description_id = td.id
          AND tt.thematique_id = ?
      )
  ) collapsed
WHERE
  collapsed.rn = 1
ORDER BY
  collapsed.title ASC
LIMIT
  ?
OFFSET
  ?

SELECT collapsed.id FROM (
    SELECT
        td.id,
                    td.title,
                    ROW_NUMBER() OVER (
    PARTITION BY COALESCE(td.variant_group_id, td.id)
    ORDER BY td.canonical DESC, td.id ASC
) AS rn
    FROM travel_description td
    WHERE td.published = 1 AND (
    (td.offer_type = 'unique' AND td.unique_price > 0)
    OR EXISTS (
        SELECT 1 FROM travel_offer o
        INNER JOIN price_entry pe ON pe.travel_offer_id = o.id
        WHERE o.code = td.offer_code AND (
    (pe.price_type != 'transport' AND pe.price_full > 0)
    OR (
        pe.price_type = 'transport' AND pe.price_full > 0
        AND NOT EXISTS (
            SELECT 1 FROM price_entry pe2
            WHERE pe2.travel_offer_id = pe.travel_offer_id
                AND pe2.price_type != 'transport' AND pe2.price_full > 0
        )
    )
)
    )
) AND EXISTS (SELECT 1 FROM travel_thematique tt WHERE tt.travel_description_id = td.id AND tt.thematique_id = 532)
) collapsed
WHERE collapsed.rn = 1
ORDER BY collapsed.title ASC
LIMIT 24 OFFSET 48;

SELECT
  t0.id AS id_1,
  t0.slug AS slug_2,
  t0.path AS path_3,
  t0.entity_type AS entity_type_4,
  t0.entity_id AS entity_id_5,
  t0.route_name AS route_name_6,
  t0.pathauto AS pathauto_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.parent_id AS parent_id_10
FROM
  url_alias t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.path AS path_3, t0.entity_type AS entity_type_4, t0.entity_id AS entity_id_5, t0.route_name AS route_name_6, t0.pathauto AS pathauto_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.parent_id AS parent_id_10 FROM url_alias t0 WHERE t0.id = 8806;

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.code AS code_3,
  t0.description AS description_4,
  t0.division AS division_5,
  t0.imported_at AS imported_at_6
FROM
  travel_offer t0
WHERE
  t0.code = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.type AS type_2, t0.code AS code_3, t0.description AS description_4, t0.division AS division_5, t0.imported_at AS imported_at_6 FROM travel_offer t0 WHERE t0.code = 'ESPI1001' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.label AS label_3,
  t0.min_width AS min_width_4
FROM
  breakpoint t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.label AS label_3, t0.min_width AS min_width_4 FROM breakpoint t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.title_h1 AS title_h1_3,
  t0.body AS body_4,
  t0.image AS image_5,
  t0.show_header_image AS show_header_image_6,
  t0.layout AS layout_7,
  t0.pinned AS pinned_8,
  t0.created_at AS created_at_9,
  t0.published_at AS published_at_10,
  t0.updated_at AS updated_at_11,
  t0.published AS published_12,
  t0.archived AS archived_13,
  t0.exclude_from_search AS exclude_from_search_14,
  t0.seo_title AS seo_title_15,
  t0.seo_description AS seo_description_16,
  t0.seo_keywords AS seo_keywords_17,
  t0.seo_canonical AS seo_canonical_18,
  t0.seo_key AS seo_key_19,
  t0.seo_robots AS seo_robots_20,
  t0.seo_sitemap AS seo_sitemap_21
FROM
  content t0
WHERE
  t0.title = ?
  AND t0.published = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.title_h1 AS title_h1_3, t0.body AS body_4, t0.image AS image_5, t0.show_header_image AS show_header_image_6, t0.layout AS layout_7, t0.pinned AS pinned_8, t0.created_at AS created_at_9, t0.published_at AS published_at_10, t0.updated_at AS updated_at_11, t0.published AS published_12, t0.archived AS archived_13, t0.exclude_from_search AS exclude_from_search_14, t0.seo_title AS seo_title_15, t0.seo_description AS seo_description_16, t0.seo_keywords AS seo_keywords_17, t0.seo_canonical AS seo_canonical_18, t0.seo_key AS seo_key_19, t0.seo_robots AS seo_robots_20, t0.seo_sitemap AS seo_sitemap_21 FROM content t0 WHERE t0.title = 'Politique de Cookies' AND t0.published = 1 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.external_url AS external_url_3,
  t0.target AS target_4,
  t0.position AS position_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.parent_id AS parent_id_8,
  t0.menu_id AS menu_id_9,
  t0.url_alias_id AS url_alias_id_10
FROM
  menu_link t0
WHERE
  t0.menu_id = ?
  AND t0.parent_id IS NULL
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.label AS label_2, t0.external_url AS external_url_3, t0.target AS target_4, t0.position AS position_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.parent_id AS parent_id_8, t0.menu_id AS menu_id_9, t0.url_alias_id AS url_alias_id_10 FROM menu_link t0 WHERE t0.menu_id = 4 AND t0.parent_id IS NULL ORDER BY t0.position ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.label AS label_3
FROM
  menu t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.label AS label_3 FROM menu t0 WHERE t0.name = 'topbar' LIMIT 1;

SELECT
  COUNT(*)
FROM
  (
    SELECT
      ROW_NUMBER() OVER (
        PARTITION BY
          COALESCE(td.variant_group_id, td.id)
        ORDER BY
          td.canonical DESC,
          td.id ASC
      ) AS rn
    FROM
      travel_description td
    WHERE
      td.published = 1
      AND (
        (
          td.offer_type = 'unique'
          AND td.unique_price > 0
        )
        OR EXISTS (
          SELECT
            1
          FROM
            travel_offer o
            INNER JOIN price_entry pe ON pe.travel_offer_id = o.id
          WHERE
            o.code = td.offer_code
            AND (
              (
                pe.price_type != 'transport'
                AND pe.price_full > 0
              )
              OR (
                pe.price_type = 'transport'
                AND pe.price_full > 0
                AND NOT EXISTS (
                  SELECT
                    1
                  FROM
                    price_entry pe2
                  WHERE
                    pe2.travel_offer_id = pe.travel_offer_id
                    AND pe2.price_type != 'transport'
                    AND pe2.price_full > 0
                )
              )
            )
        )
      )
      AND EXISTS (
        SELECT
          1
        FROM
          travel_thematique tt
        WHERE
          tt.travel_description_id = td.id
          AND tt.thematique_id = ?
      )
  ) collapsed
WHERE
  collapsed.rn = 1

SELECT COUNT(*) FROM (
    SELECT ROW_NUMBER() OVER (
        PARTITION BY COALESCE(td.variant_group_id, td.id)
        ORDER BY td.canonical DESC, td.id ASC
    ) AS rn
    FROM travel_description td
    WHERE td.published = 1 AND (
    (td.offer_type = 'unique' AND td.unique_price > 0)
    OR EXISTS (
        SELECT 1 FROM travel_offer o
        INNER JOIN price_entry pe ON pe.travel_offer_id = o.id
        WHERE o.code = td.offer_code AND (
    (pe.price_type != 'transport' AND pe.price_full > 0)
    OR (
        pe.price_type = 'transport' AND pe.price_full > 0
        AND NOT EXISTS (
            SELECT 1 FROM price_entry pe2
            WHERE pe2.travel_offer_id = pe.travel_offer_id
                AND pe2.price_type != 'transport' AND pe2.price_full > 0
        )
    )
)
    )
) AND EXISTS (SELECT 1 FROM travel_thematique tt WHERE tt.travel_description_id = td.id AND tt.thematique_id = 532)
) collapsed
WHERE collapsed.rn = 1;