Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.old_path AS old_path_2,
  t0.target_url AS target_url_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.target_alias_id AS target_alias_id_6
FROM
  url_redirect t0
WHERE
  t0.old_path = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.old_path AS old_path_2, t0.target_url AS target_url_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.target_alias_id AS target_alias_id_6 FROM url_redirect t0 WHERE t0.old_path = 'voyager/voyages-leroy/honfleur-temps-libre-2' 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.path = ?
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.path = 'voyager/voyages-leroy/honfleur-temps-libre-2' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.offer_code AS offer_code_2,
  t0.offer_type AS offer_type_3,
  t0.unique_price AS unique_price_4,
  t0.unique_city AS unique_city_5,
  t0.unique_description AS unique_description_6,
  t0.unique_division AS unique_division_7,
  t0.variant_label AS variant_label_8,
  t0.canonical AS canonical_9,
  t0.title AS title_10,
  t0.teaser AS teaser_11,
  t0.description AS description_12,
  t0.intro AS intro_13,
  t0.chapeau1 AS chapeau1_14,
  t0.chapeau2 AS chapeau2_15,
  t0.qualite_leo AS qualite_leo_16,
  t0.entree_site AS entree_site_17,
  t0.price_comment AS price_comment_18,
  t0.gifts AS gifts_19,
  t0.good_to_know AS good_to_know_20,
  t0.important_info AS important_info_21,
  t0.duration AS duration_22,
  t0.duration_only_on_web AS duration_only_on_web_23,
  t0.minimum_length AS minimum_length_24,
  t0.is_stay AS is_stay_25,
  t0.published AS published_26,
  t0.special_offer_enabled AS special_offer_enabled_27,
  t0.special_offer_url AS special_offer_url_28,
  t0.not_in_brochure AS not_in_brochure_29,
  t0.brochure_page AS brochure_page_30,
  t0.brochure_column AS brochure_column_31,
  t0.print_title AS print_title_32,
  t0.print_intro AS print_intro_33,
  t0.print_schedule AS print_schedule_34,
  t0.print_starting_price AS print_starting_price_35,
  t0.print_price_notes AS print_price_notes_36,
  t0.print_date AS print_date_37,
  t0.created_at AS created_at_38,
  t0.updated_at AS updated_at_39,
  t0.stay_services AS stay_services_40,
  t0.stay_room AS stay_room_41,
  t0.stay_catering AS stay_catering_42,
  t0.stay_animation AS stay_animation_43,
  t0.eco_impact_formula AS eco_impact_formula_44,
  t0.eco_impact_type AS eco_impact_type_45,
  t0.eco_impact_distance AS eco_impact_distance_46,
  t0.eco_impact_emissions AS eco_impact_emissions_47,
  t0.eco_impact_contribution AS eco_impact_contribution_48,
  t0.seo_title AS seo_title_49,
  t0.seo_description AS seo_description_50,
  t0.seo_keywords AS seo_keywords_51,
  t0.seo_canonical AS seo_canonical_52,
  t0.seo_key AS seo_key_53,
  t0.seo_robots AS seo_robots_54,
  t0.seo_sitemap AS seo_sitemap_55,
  t0.variant_group_id AS variant_group_id_56,
  t0.type_id AS type_id_57,
  t0.brochure_id AS brochure_id_58,
  t0.print_thematique_id AS print_thematique_id_59
FROM
  travel_description t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.offer_code AS offer_code_2, t0.offer_type AS offer_type_3, t0.unique_price AS unique_price_4, t0.unique_city AS unique_city_5, t0.unique_description AS unique_description_6, t0.unique_division AS unique_division_7, t0.variant_label AS variant_label_8, t0.canonical AS canonical_9, t0.title AS title_10, t0.teaser AS teaser_11, t0.description AS description_12, t0.intro AS intro_13, t0.chapeau1 AS chapeau1_14, t0.chapeau2 AS chapeau2_15, t0.qualite_leo AS qualite_leo_16, t0.entree_site AS entree_site_17, t0.price_comment AS price_comment_18, t0.gifts AS gifts_19, t0.good_to_know AS good_to_know_20, t0.important_info AS important_info_21, t0.duration AS duration_22, t0.duration_only_on_web AS duration_only_on_web_23, t0.minimum_length AS minimum_length_24, t0.is_stay AS is_stay_25, t0.published AS published_26, t0.special_offer_enabled AS special_offer_enabled_27, t0.special_offer_url AS special_offer_url_28, t0.not_in_brochure AS not_in_brochure_29, t0.brochure_page AS brochure_page_30, t0.brochure_column AS brochure_column_31, t0.print_title AS print_title_32, t0.print_intro AS print_intro_33, t0.print_schedule AS print_schedule_34, t0.print_starting_price AS print_starting_price_35, t0.print_price_notes AS print_price_notes_36, t0.print_date AS print_date_37, t0.created_at AS created_at_38, t0.updated_at AS updated_at_39, t0.stay_services AS stay_services_40, t0.stay_room AS stay_room_41, t0.stay_catering AS stay_catering_42, t0.stay_animation AS stay_animation_43, t0.eco_impact_formula AS eco_impact_formula_44, t0.eco_impact_type AS eco_impact_type_45, t0.eco_impact_distance AS eco_impact_distance_46, t0.eco_impact_emissions AS eco_impact_emissions_47, t0.eco_impact_contribution AS eco_impact_contribution_48, t0.seo_title AS seo_title_49, t0.seo_description AS seo_description_50, t0.seo_keywords AS seo_keywords_51, t0.seo_canonical AS seo_canonical_52, t0.seo_key AS seo_key_53, t0.seo_robots AS seo_robots_54, t0.seo_sitemap AS seo_sitemap_55, t0.variant_group_id AS variant_group_id_56, t0.type_id AS type_id_57, t0.brochure_id AS brochure_id_58, t0.print_thematique_id AS print_thematique_id_59 FROM travel_description t0 WHERE t0.id = 7532;

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

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 = 7532 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 = ?
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 = 'FRHONFL1' 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 = 7532;

SELECT
  r0_.id AS id_0,
  r0_.code AS code_1,
  r0_.name AS name_2,
  r0_.title_h1 AS title_h1_3,
  r0_.period AS period_4,
  r0_.time_difference AS time_difference_5,
  r0_.currency AS currency_6,
  r0_.formalities AS formalities_7,
  r0_.good_to_know AS good_to_know_8,
  r0_.body AS body_9,
  r0_.intro AS intro_10,
  r0_.image_content AS image_content_11,
  r0_.image AS image_12,
  r0_.main_menu AS main_menu_13,
  r0_.favorite AS favorite_14,
  r0_.active AS active_15,
  r0_.created_at AS created_at_16,
  r0_.updated_at AS updated_at_17,
  r0_.seo_title AS seo_title_18,
  r0_.seo_description AS seo_description_19,
  r0_.seo_keywords AS seo_keywords_20,
  r0_.seo_canonical AS seo_canonical_21,
  r0_.seo_key AS seo_key_22,
  r0_.seo_robots AS seo_robots_23,
  r0_.seo_sitemap AS seo_sitemap_24
FROM
  region r0_
WHERE
  EXISTS (
    SELECT
      1
    FROM
      travel_description_region t1_
    WHERE
      t1_.region_id = r0_.id
      AND t1_.travel_description_id IN (?)
  )
LIMIT
  1

SELECT r0_.id AS id_0, r0_.code AS code_1, r0_.name AS name_2, r0_.title_h1 AS title_h1_3, r0_.period AS period_4, r0_.time_difference AS time_difference_5, r0_.currency AS currency_6, r0_.formalities AS formalities_7, r0_.good_to_know AS good_to_know_8, r0_.body AS body_9, r0_.intro AS intro_10, r0_.image_content AS image_content_11, r0_.image AS image_12, r0_.main_menu AS main_menu_13, r0_.favorite AS favorite_14, r0_.active AS active_15, r0_.created_at AS created_at_16, r0_.updated_at AS updated_at_17, r0_.seo_title AS seo_title_18, r0_.seo_description AS seo_description_19, r0_.seo_keywords AS seo_keywords_20, r0_.seo_canonical AS seo_canonical_21, r0_.seo_key AS seo_key_22, r0_.seo_robots AS seo_robots_23, r0_.seo_sitemap AS seo_sitemap_24 FROM region r0_ WHERE EXISTS (SELECT 1 FROM travel_description_region t1_ WHERE t1_.region_id = r0_.id AND t1_.travel_description_id IN (7532)) 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 = ?
  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 = 'region' AND t0.entity_id = 2454 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.name AS name_3,
  t0.title_h1 AS title_h1_4,
  t0.body AS body_5,
  t0.intro AS intro_6,
  t0.image_content AS image_content_7,
  t0.image AS image_8,
  t0.main_menu AS main_menu_9,
  t0.active AS active_10,
  t0.created_at AS created_at_11,
  t0.updated_at AS updated_at_12,
  t0.position AS position_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.continent_id AS continent_id_21
FROM
  country t0
  INNER JOIN region_country ON t0.id = region_country.country_id
WHERE
  region_country.region_id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.title_h1 AS title_h1_4, t0.body AS body_5, t0.intro AS intro_6, t0.image_content AS image_content_7, t0.image AS image_8, t0.main_menu AS main_menu_9, t0.active AS active_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.position AS position_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.continent_id AS continent_id_21 FROM country t0 INNER JOIN region_country ON t0.id = region_country.country_id WHERE region_country.region_id = 2454;

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 = 'country' AND t0.entity_id = 326 LIMIT 1;

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
  4

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 (7532)) AND t0_.active = 1 ORDER BY t0_.position ASC LIMIT 4;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.body AS body_3,
  t0.cta_label AS cta_label_4,
  t0.external_url AS external_url_5,
  t0.image AS image_6,
  t0.mobile_image AS mobile_image_7,
  t0.slot AS slot_8,
  t0.published AS published_9,
  t0.archived AS archived_10,
  t0.position AS position_11,
  t0.created_at AS created_at_12,
  t0.updated_at AS updated_at_13,
  t0.url_alias_id AS url_alias_id_14
FROM
  block_content t0
WHERE
  t0.slot = ?
  AND t0.published = ?
  AND t0.archived = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.body AS body_3, t0.cta_label AS cta_label_4, t0.external_url AS external_url_5, t0.image AS image_6, t0.mobile_image AS mobile_image_7, t0.slot AS slot_8, t0.published AS published_9, t0.archived AS archived_10, t0.position AS position_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.url_alias_id AS url_alias_id_14 FROM block_content t0 WHERE t0.slot = 3 AND t0.published = 1 AND t0.archived = 0 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 = ?
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 = 'FRHONFL1' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.stage AS stage_2,
  t0.title AS title_3,
  t0.content AS content_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_programme_item t0
WHERE
  t0.travel_description_id = ?

SELECT t0.id AS id_1, t0.stage AS stage_2, t0.title AS title_3, t0.content AS content_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_programme_item t0 WHERE t0.travel_description_id = 7532;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.subtitle AS subtitle_3,
  t0.content AS content_4,
  t0.web_only AS web_only_5,
  t0.position AS position_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.travel_description_id AS travel_description_id_9
FROM
  travel_content_tab t0
WHERE
  t0.travel_description_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.subtitle AS subtitle_3, t0.content AS content_4, t0.web_only AS web_only_5, t0.position AS position_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.travel_description_id AS travel_description_id_9 FROM travel_content_tab t0 WHERE t0.travel_description_id = 7532;

SELECT
  r0_.id AS id_0,
  r0_.code AS code_1,
  r0_.name AS name_2,
  r0_.title_h1 AS title_h1_3,
  r0_.period AS period_4,
  r0_.time_difference AS time_difference_5,
  r0_.currency AS currency_6,
  r0_.formalities AS formalities_7,
  r0_.good_to_know AS good_to_know_8,
  r0_.body AS body_9,
  r0_.intro AS intro_10,
  r0_.image_content AS image_content_11,
  r0_.image AS image_12,
  r0_.main_menu AS main_menu_13,
  r0_.favorite AS favorite_14,
  r0_.active AS active_15,
  r0_.created_at AS created_at_16,
  r0_.updated_at AS updated_at_17,
  r0_.seo_title AS seo_title_18,
  r0_.seo_description AS seo_description_19,
  r0_.seo_keywords AS seo_keywords_20,
  r0_.seo_canonical AS seo_canonical_21,
  r0_.seo_key AS seo_key_22,
  r0_.seo_robots AS seo_robots_23,
  r0_.seo_sitemap AS seo_sitemap_24
FROM
  region r0_
WHERE
  EXISTS (
    SELECT
      1
    FROM
      travel_description_region t1_
    WHERE
      t1_.region_id = r0_.id
      AND t1_.travel_description_id IN (?)
  )

SELECT r0_.id AS id_0, r0_.code AS code_1, r0_.name AS name_2, r0_.title_h1 AS title_h1_3, r0_.period AS period_4, r0_.time_difference AS time_difference_5, r0_.currency AS currency_6, r0_.formalities AS formalities_7, r0_.good_to_know AS good_to_know_8, r0_.body AS body_9, r0_.intro AS intro_10, r0_.image_content AS image_content_11, r0_.image AS image_12, r0_.main_menu AS main_menu_13, r0_.favorite AS favorite_14, r0_.active AS active_15, r0_.created_at AS created_at_16, r0_.updated_at AS updated_at_17, r0_.seo_title AS seo_title_18, r0_.seo_description AS seo_description_19, r0_.seo_keywords AS seo_keywords_20, r0_.seo_canonical AS seo_canonical_21, r0_.seo_key AS seo_key_22, r0_.seo_robots AS seo_robots_23, r0_.seo_sitemap AS seo_sitemap_24 FROM region r0_ WHERE EXISTS (SELECT 1 FROM travel_description_region t1_ WHERE t1_.region_id = r0_.id AND t1_.travel_description_id IN (7532));