Symfony Profiler

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
                )
              )
            )
        )
      )
  ) 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
        )
    )
)
    )
)
) collapsed
WHERE collapsed.rn = 1;

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
                )
              )
            )
        )
      )
  ) 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
        )
    )
)
    )
)
) collapsed
WHERE collapsed.rn = 1
ORDER BY collapsed.title ASC
LIMIT 24 OFFSET 96;

SELECT
  t0_.id AS id_0,
  t0_.offer_code AS offer_code_1,
  t0_.offer_type AS offer_type_2,
  t0_.unique_price AS unique_price_3,
  t0_.unique_city AS unique_city_4,
  t0_.unique_description AS unique_description_5,
  t0_.unique_division AS unique_division_6,
  t0_.variant_label AS variant_label_7,
  t0_.canonical AS canonical_8,
  t0_.title AS title_9,
  t0_.teaser AS teaser_10,
  t0_.description AS description_11,
  t0_.intro AS intro_12,
  t0_.chapeau1 AS chapeau1_13,
  t0_.chapeau2 AS chapeau2_14,
  t0_.qualite_leo AS qualite_leo_15,
  t0_.entree_site AS entree_site_16,
  t0_.price_comment AS price_comment_17,
  t0_.gifts AS gifts_18,
  t0_.good_to_know AS good_to_know_19,
  t0_.important_info AS important_info_20,
  t0_.duration AS duration_21,
  t0_.duration_only_on_web AS duration_only_on_web_22,
  t0_.minimum_length AS minimum_length_23,
  t0_.is_stay AS is_stay_24,
  t0_.published AS published_25,
  t0_.special_offer_enabled AS special_offer_enabled_26,
  t0_.special_offer_url AS special_offer_url_27,
  t0_.not_in_brochure AS not_in_brochure_28,
  t0_.brochure_page AS brochure_page_29,
  t0_.brochure_column AS brochure_column_30,
  t0_.print_title AS print_title_31,
  t0_.print_intro AS print_intro_32,
  t0_.print_schedule AS print_schedule_33,
  t0_.print_starting_price AS print_starting_price_34,
  t0_.print_price_notes AS print_price_notes_35,
  t0_.print_date AS print_date_36,
  t0_.created_at AS created_at_37,
  t0_.updated_at AS updated_at_38,
  t0_.stay_services AS stay_services_39,
  t0_.stay_room AS stay_room_40,
  t0_.stay_catering AS stay_catering_41,
  t0_.stay_animation AS stay_animation_42,
  t0_.eco_impact_formula AS eco_impact_formula_43,
  t0_.eco_impact_type AS eco_impact_type_44,
  t0_.eco_impact_distance AS eco_impact_distance_45,
  t0_.eco_impact_emissions AS eco_impact_emissions_46,
  t0_.eco_impact_contribution AS eco_impact_contribution_47,
  t0_.seo_title AS seo_title_48,
  t0_.seo_description AS seo_description_49,
  t0_.seo_keywords AS seo_keywords_50,
  t0_.seo_canonical AS seo_canonical_51,
  t0_.seo_key AS seo_key_52,
  t0_.seo_robots AS seo_robots_53,
  t0_.seo_sitemap AS seo_sitemap_54,
  t0_.variant_group_id AS variant_group_id_55,
  t0_.type_id AS type_id_56,
  t0_.brochure_id AS brochure_id_57,
  t0_.print_thematique_id AS print_thematique_id_58
FROM
  travel_description t0_
WHERE
  t0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?
  )

SELECT t0_.id AS id_0, t0_.offer_code AS offer_code_1, t0_.offer_type AS offer_type_2, t0_.unique_price AS unique_price_3, t0_.unique_city AS unique_city_4, t0_.unique_description AS unique_description_5, t0_.unique_division AS unique_division_6, t0_.variant_label AS variant_label_7, t0_.canonical AS canonical_8, t0_.title AS title_9, t0_.teaser AS teaser_10, t0_.description AS description_11, t0_.intro AS intro_12, t0_.chapeau1 AS chapeau1_13, t0_.chapeau2 AS chapeau2_14, t0_.qualite_leo AS qualite_leo_15, t0_.entree_site AS entree_site_16, t0_.price_comment AS price_comment_17, t0_.gifts AS gifts_18, t0_.good_to_know AS good_to_know_19, t0_.important_info AS important_info_20, t0_.duration AS duration_21, t0_.duration_only_on_web AS duration_only_on_web_22, t0_.minimum_length AS minimum_length_23, t0_.is_stay AS is_stay_24, t0_.published AS published_25, t0_.special_offer_enabled AS special_offer_enabled_26, t0_.special_offer_url AS special_offer_url_27, t0_.not_in_brochure AS not_in_brochure_28, t0_.brochure_page AS brochure_page_29, t0_.brochure_column AS brochure_column_30, t0_.print_title AS print_title_31, t0_.print_intro AS print_intro_32, t0_.print_schedule AS print_schedule_33, t0_.print_starting_price AS print_starting_price_34, t0_.print_price_notes AS print_price_notes_35, t0_.print_date AS print_date_36, t0_.created_at AS created_at_37, t0_.updated_at AS updated_at_38, t0_.stay_services AS stay_services_39, t0_.stay_room AS stay_room_40, t0_.stay_catering AS stay_catering_41, t0_.stay_animation AS stay_animation_42, t0_.eco_impact_formula AS eco_impact_formula_43, t0_.eco_impact_type AS eco_impact_type_44, t0_.eco_impact_distance AS eco_impact_distance_45, t0_.eco_impact_emissions AS eco_impact_emissions_46, t0_.eco_impact_contribution AS eco_impact_contribution_47, t0_.seo_title AS seo_title_48, t0_.seo_description AS seo_description_49, t0_.seo_keywords AS seo_keywords_50, t0_.seo_canonical AS seo_canonical_51, t0_.seo_key AS seo_key_52, t0_.seo_robots AS seo_robots_53, t0_.seo_sitemap AS seo_sitemap_54, t0_.variant_group_id AS variant_group_id_55, t0_.type_id AS type_id_56, t0_.brochure_id AS brochure_id_57, t0_.print_thematique_id AS print_thematique_id_58 FROM travel_description t0_ WHERE t0_.id IN (7412, 7518, 7989, 7926, 7617, 7693, 7571, 8027, 7960, 7367, 7952, 7823, 7428, 7407, 7673, 7340, 7404, 8095, 7389, 7933, 7541, 7699, 7450, 7648);

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 = 7340;

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 = 'travel-description' AND t0.entity_id = 7340 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 = 7367;

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 = 'travel-description' AND t0.entity_id = 7367 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 = 7389;

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 = 'travel-description' AND t0.entity_id = 7389 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 = 7404;

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 = 'travel-description' AND t0.entity_id = 7404 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 = 7407;

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 = 'travel-description' AND t0.entity_id = 7407 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 = 7412;

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 = 'travel-description' AND t0.entity_id = 7412 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 = 7428;

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 = 'travel-description' AND t0.entity_id = 7428 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 = 7450;

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