Symfony Profiler

SELECT
  c0_.id AS id_0,
  c0_.fare_code AS fare_code_1,
  c0_.description AS description_2,
  c0_.price_family AS price_family_3,
  c0_.price_family_normalized AS price_family_normalized_4,
  c0_.flight_possible AS flight_possible_5,
  c0_.flight_included AS flight_included_6,
  c0_.base_cost_double AS base_cost_double_7,
  c0_.code AS code_8,
  c0_.created_at AS created_at_9,
  c0_.created_by AS created_by_10,
  c0_.updated_at AS updated_at_11,
  c0_.updated_by AS updated_by_12,
  c0_.currency AS currency_13,
  c0_.cruise_id AS cruise_id_14,
  c0_.cabin_category_id AS cabin_category_id_15,
  c0_.offer_id AS offer_id_16
FROM
  common_price c0_
  INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id
WHERE
  c0_.cruise_id = ?
  AND c1_.cabin_sub_type_id = ?
  AND c0_.base_cost_double > 0
ORDER BY
  c0_.base_cost_double ASC
LIMIT
  1

SELECT c0_.id AS id_0, c0_.fare_code AS fare_code_1, c0_.description AS description_2, c0_.price_family AS price_family_3, c0_.price_family_normalized AS price_family_normalized_4, c0_.flight_possible AS flight_possible_5, c0_.flight_included AS flight_included_6, c0_.base_cost_double AS base_cost_double_7, c0_.code AS code_8, c0_.created_at AS created_at_9, c0_.created_by AS created_by_10, c0_.updated_at AS updated_at_11, c0_.updated_by AS updated_by_12, c0_.currency AS currency_13, c0_.cruise_id AS cruise_id_14, c0_.cabin_category_id AS cabin_category_id_15, c0_.offer_id AS offer_id_16 FROM common_price c0_ INNER JOIN common_cabin_category c1_ ON c0_.cabin_category_id = c1_.id WHERE c0_.cruise_id = 403 AND c1_.cabin_sub_type_id = 71 AND c0_.base_cost_double > 0 ORDER BY c0_.base_cost_double ASC LIMIT 1;

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.short_name AS short_name_2,
  c0_.slug AS slug_3,
  c0_.description AS description_4,
  c0_.cabin_area_min AS cabin_area_min_5,
  c0_.cabin_area_max AS cabin_area_max_6,
  c0_.balcony_area_min AS balcony_area_min_7,
  c0_.balcony_area_max AS balcony_area_max_8,
  c0_.active AS active_9,
  c0_.list_order AS list_order_10,
  c0_.created_at AS created_at_11,
  c0_.created_by AS created_by_12,
  c0_.updated_at AS updated_at_13,
  c0_.updated_by AS updated_by_14,
  c0_.key_value_pairs AS key_value_pairs_15,
  c0_.cabin_type_id AS cabin_type_id_16,
  c0_.company_id AS company_id_17
FROM
  common_cabin_sub_type c0_
  INNER JOIN common_cabin_type c1_ ON c0_.cabin_type_id = c1_.id
  INNER JOIN common_cabin_category c2_ ON c0_.id = c2_.cabin_sub_type_id
  INNER JOIN common_price c3_ ON c2_.id = c3_.cabin_category_id
WHERE
  c3_.cruise_id = ?
ORDER BY
  c0_.list_order ASC,
  c0_.name ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.short_name AS short_name_2, c0_.slug AS slug_3, c0_.description AS description_4, c0_.cabin_area_min AS cabin_area_min_5, c0_.cabin_area_max AS cabin_area_max_6, c0_.balcony_area_min AS balcony_area_min_7, c0_.balcony_area_max AS balcony_area_max_8, c0_.active AS active_9, c0_.list_order AS list_order_10, c0_.created_at AS created_at_11, c0_.created_by AS created_by_12, c0_.updated_at AS updated_at_13, c0_.updated_by AS updated_by_14, c0_.key_value_pairs AS key_value_pairs_15, c0_.cabin_type_id AS cabin_type_id_16, c0_.company_id AS company_id_17 FROM common_cabin_sub_type c0_ INNER JOIN common_cabin_type c1_ ON c0_.cabin_type_id = c1_.id INNER JOIN common_cabin_category c2_ ON c0_.id = c2_.cabin_sub_type_id INNER JOIN common_price c3_ ON c2_.id = c3_.cabin_category_id WHERE c3_.cruise_id = 403 ORDER BY c0_.list_order ASC, c0_.name ASC;

SELECT
  MIN(c0_.base_cost_double) AS sclr_0
FROM
  common_price c0_
WHERE
  c0_.cruise_id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?
  )

SELECT MIN(c0_.base_cost_double) AS sclr_0 FROM common_price c0_ WHERE c0_.cruise_id IN (403, 409, 463, 469, 475, 481, 487, 493, 499, 506, 513, 519, 525, 532, 538, 544, 550, 556, 562, 568, 574, 580, 586, 592, 598, 605, 612, 619, 626, 632, 638, 644, 29490, 29496, 29502, 29508, 29514, 29520, 29526, 29532, 29538, 29544, 29550, 29556, 29562, 29568, 29574, 29580, 29586, 29592, 29598, 29604, 29610, 29616, 29622, 29628, 29634, 29640, 29646, 29652, 29658, 29663);

SELECT
  DISTINCT c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.short_name AS short_name_2,
  c0_.slug AS slug_3,
  c0_.description AS description_4,
  c0_.cabin_area_min AS cabin_area_min_5,
  c0_.cabin_area_max AS cabin_area_max_6,
  c0_.balcony_area_min AS balcony_area_min_7,
  c0_.balcony_area_max AS balcony_area_max_8,
  c0_.active AS active_9,
  c0_.list_order AS list_order_10,
  c0_.created_at AS created_at_11,
  c0_.created_by AS created_by_12,
  c0_.updated_at AS updated_at_13,
  c0_.updated_by AS updated_by_14,
  c0_.key_value_pairs AS key_value_pairs_15,
  c0_.cabin_type_id AS cabin_type_id_16,
  c0_.company_id AS company_id_17
FROM
  common_cabin_sub_type c0_
  INNER JOIN common_cabin_category c1_ ON c0_.id = c1_.cabin_sub_type_id
WHERE
  c1_.ship_id = ?
ORDER BY
  c0_.list_order ASC,
  c0_.name ASC

SELECT DISTINCT c0_.id AS id_0, c0_.name AS name_1, c0_.short_name AS short_name_2, c0_.slug AS slug_3, c0_.description AS description_4, c0_.cabin_area_min AS cabin_area_min_5, c0_.cabin_area_max AS cabin_area_max_6, c0_.balcony_area_min AS balcony_area_min_7, c0_.balcony_area_max AS balcony_area_max_8, c0_.active AS active_9, c0_.list_order AS list_order_10, c0_.created_at AS created_at_11, c0_.created_by AS created_by_12, c0_.updated_at AS updated_at_13, c0_.updated_by AS updated_by_14, c0_.key_value_pairs AS key_value_pairs_15, c0_.cabin_type_id AS cabin_type_id_16, c0_.company_id AS company_id_17 FROM common_cabin_sub_type c0_ INNER JOIN common_cabin_category c1_ ON c0_.id = c1_.cabin_sub_type_id WHERE c1_.ship_id = 448 ORDER BY c0_.list_order ASC, c0_.name ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3,
  t0.crush AS crush_4,
  t0.slug AS slug_5,
  t0.flat_file_description AS flat_file_description_6,
  t0.flat_file_immediate_confirm AS flat_file_immediate_confirm_7,
  t0.manually_created AS manually_created_8,
  t0.departure_date AS departure_date_9,
  t0.arrival_date AS arrival_date_10,
  t0.is_erp_itinerary_history_up_to_date AS is_erp_itinerary_history_up_to_date_11,
  t0.active AS active_12,
  t0.visible AS visible_13,
  t0.created_at AS created_at_14,
  t0.created_by AS created_by_15,
  t0.updated_at AS updated_at_16,
  t0.updated_by AS updated_by_17,
  t0.module_order AS module_order_18,
  t0.included AS included_19,
  t0.excluded AS excluded_20,
  t0.ship_id AS ship_id_21,
  t0.best_price_id AS best_price_id_22,
  t0.best_price_with_flight_id AS best_price_with_flight_id_23,
  t0.best_group_price_id AS best_group_price_id_24,
  t0.best_group_price_with_flight_id AS best_group_price_with_flight_id_25,
  t0.itinerary_id AS itinerary_id_26,
  t0.origin_id AS origin_id_27
FROM
  common_cruise t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.crush AS crush_4, t0.slug AS slug_5, t0.flat_file_description AS flat_file_description_6, t0.flat_file_immediate_confirm AS flat_file_immediate_confirm_7, t0.manually_created AS manually_created_8, t0.departure_date AS departure_date_9, t0.arrival_date AS arrival_date_10, t0.is_erp_itinerary_history_up_to_date AS is_erp_itinerary_history_up_to_date_11, t0.active AS active_12, t0.visible AS visible_13, t0.created_at AS created_at_14, t0.created_by AS created_by_15, t0.updated_at AS updated_at_16, t0.updated_by AS updated_by_17, t0.module_order AS module_order_18, t0.included AS included_19, t0.excluded AS excluded_20, t0.ship_id AS ship_id_21, t0.best_price_id AS best_price_id_22, t0.best_price_with_flight_id AS best_price_with_flight_id_23, t0.best_group_price_id AS best_group_price_id_24, t0.best_group_price_with_flight_id AS best_group_price_with_flight_id_25, t0.itinerary_id AS itinerary_id_26, t0.origin_id AS origin_id_27 FROM common_cruise t0 WHERE t0.id = 532;

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.code AS code_2,
  c0_.crush AS crush_3,
  c0_.slug AS slug_4,
  c0_.flat_file_description AS flat_file_description_5,
  c0_.flat_file_immediate_confirm AS flat_file_immediate_confirm_6,
  c0_.manually_created AS manually_created_7,
  c0_.departure_date AS departure_date_8,
  c0_.arrival_date AS arrival_date_9,
  c0_.is_erp_itinerary_history_up_to_date AS is_erp_itinerary_history_up_to_date_10,
  c0_.active AS active_11,
  c0_.visible AS visible_12,
  c0_.created_at AS created_at_13,
  c0_.created_by AS created_by_14,
  c0_.updated_at AS updated_at_15,
  c0_.updated_by AS updated_by_16,
  c0_.module_order AS module_order_17,
  c0_.included AS included_18,
  c0_.excluded AS excluded_19,
  c0_.ship_id AS ship_id_20,
  c0_.best_price_id AS best_price_id_21,
  c0_.best_price_with_flight_id AS best_price_with_flight_id_22,
  c0_.best_group_price_id AS best_group_price_id_23,
  c0_.best_group_price_with_flight_id AS best_group_price_with_flight_id_24,
  c0_.itinerary_id AS itinerary_id_25,
  c0_.origin_id AS origin_id_26
FROM
  common_cruise c0_
WHERE
  c0_.itinerary_id = ?
  AND c0_.departure_date > ?
  AND c0_.active = 1
  AND c0_.visible = 1
ORDER BY
  c0_.departure_date ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.code AS code_2, c0_.crush AS crush_3, c0_.slug AS slug_4, c0_.flat_file_description AS flat_file_description_5, c0_.flat_file_immediate_confirm AS flat_file_immediate_confirm_6, c0_.manually_created AS manually_created_7, c0_.departure_date AS departure_date_8, c0_.arrival_date AS arrival_date_9, c0_.is_erp_itinerary_history_up_to_date AS is_erp_itinerary_history_up_to_date_10, c0_.active AS active_11, c0_.visible AS visible_12, c0_.created_at AS created_at_13, c0_.created_by AS created_by_14, c0_.updated_at AS updated_at_15, c0_.updated_by AS updated_by_16, c0_.module_order AS module_order_17, c0_.included AS included_18, c0_.excluded AS excluded_19, c0_.ship_id AS ship_id_20, c0_.best_price_id AS best_price_id_21, c0_.best_price_with_flight_id AS best_price_with_flight_id_22, c0_.best_group_price_id AS best_group_price_id_23, c0_.best_group_price_with_flight_id AS best_group_price_with_flight_id_24, c0_.itinerary_id AS itinerary_id_25, c0_.origin_id AS origin_id_26 FROM common_cruise c0_ WHERE c0_.itinerary_id = 109 AND c0_.departure_date > '2026-10-10 22:26:18' AND c0_.active = 1 AND c0_.visible = 1 ORDER BY c0_.departure_date ASC;

SELECT
  c0_.id AS id_0
FROM
  common_cruise c0_
WHERE
  c0_.itinerary_id = ?
  AND c0_.departure_date > ?
  AND c0_.active = 1
  AND c0_.visible = 1
ORDER BY
  c0_.departure_date ASC

SELECT c0_.id AS id_0 FROM common_cruise c0_ WHERE c0_.itinerary_id = 109 AND c0_.departure_date > '2026-10-10 22:26:18' AND c0_.active = 1 AND c0_.visible = 1 ORDER BY c0_.departure_date ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.short_name AS short_name_3,
  t0.slug AS slug_4,
  t0.description AS description_5,
  t0.cabin_area_min AS cabin_area_min_6,
  t0.cabin_area_max AS cabin_area_max_7,
  t0.balcony_area_min AS balcony_area_min_8,
  t0.balcony_area_max AS balcony_area_max_9,
  t0.active AS active_10,
  t0.list_order AS list_order_11,
  t0.created_at AS created_at_12,
  t0.created_by AS created_by_13,
  t0.updated_at AS updated_at_14,
  t0.updated_by AS updated_by_15,
  t0.key_value_pairs AS key_value_pairs_16,
  t0.cabin_type_id AS cabin_type_id_17,
  t0.company_id AS company_id_18
FROM
  common_cabin_sub_type t0
WHERE
  t0.cabin_type_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.short_name AS short_name_3, t0.slug AS slug_4, t0.description AS description_5, t0.cabin_area_min AS cabin_area_min_6, t0.cabin_area_max AS cabin_area_max_7, t0.balcony_area_min AS balcony_area_min_8, t0.balcony_area_max AS balcony_area_max_9, t0.active AS active_10, t0.list_order AS list_order_11, t0.created_at AS created_at_12, t0.created_by AS created_by_13, t0.updated_at AS updated_at_14, t0.updated_by AS updated_by_15, t0.key_value_pairs AS key_value_pairs_16, t0.cabin_type_id AS cabin_type_id_17, t0.company_id AS company_id_18 FROM common_cabin_sub_type t0 WHERE t0.cabin_type_id = 1;

SELECT
  s0_.title AS title_0,
  s0_.webspace_key AS webspace_key_1,
  s0_.all_domains AS all_domains_2,
  s0_.content AS content_3,
  s0_.type AS type_4,
  s0_.id AS id_5,
  s1_.url AS url_6,
  s1_.environment AS environment_7,
  s1_.id AS id_8
FROM
  sulu_we_analytics s0_
  LEFT JOIN sulu_we_analytics_domains s2_ ON s0_.id = s2_.analytics
  LEFT JOIN sulu_we_domains s1_ ON s1_.id = s2_.domain
WHERE
  (
    s0_.all_domains = 1
    OR (
      s1_.url = ?
      AND s1_.environment = ?
    )
  )
  AND s0_.webspace_key = ?
ORDER BY
  s0_.id ASC

SELECT s0_.title AS title_0, s0_.webspace_key AS webspace_key_1, s0_.all_domains AS all_domains_2, s0_.content AS content_3, s0_.type AS type_4, s0_.id AS id_5, s1_.url AS url_6, s1_.environment AS environment_7, s1_.id AS id_8 FROM sulu_we_analytics s0_ LEFT JOIN sulu_we_analytics_domains s2_ ON s0_.id = s2_.analytics LEFT JOIN sulu_we_domains s1_ ON s1_.id = s2_.domain WHERE (s0_.all_domains = 1 OR (s1_.url = 'preprod-croisiland.dev' AND s1_.environment = 'dev')) AND s0_.webspace_key = 'main-website' ORDER BY s0_.id ASC;

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.short_name AS short_name_2,
  c0_.slug AS slug_3,
  c0_.active AS active_4,
  c0_.list_order AS list_order_5,
  c0_.created_at AS created_at_6,
  c0_.created_by AS created_by_7,
  c0_.updated_at AS updated_at_8,
  c0_.updated_by AS updated_by_9,
  c0_.key_value_pairs AS key_value_pairs_10
FROM
  common_cabin_type c0_
  INNER JOIN common_cabin_sub_type c1_ ON c0_.id = c1_.cabin_type_id
  INNER JOIN common_cabin_category c2_ ON c1_.id = c2_.cabin_sub_type_id
  INNER JOIN common_price c3_ ON c2_.id = c3_.cabin_category_id
WHERE
  c3_.cruise_id = ?

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.short_name AS short_name_2, c0_.slug AS slug_3, c0_.active AS active_4, c0_.list_order AS list_order_5, c0_.created_at AS created_at_6, c0_.created_by AS created_by_7, c0_.updated_at AS updated_at_8, c0_.updated_by AS updated_by_9, c0_.key_value_pairs AS key_value_pairs_10 FROM common_cabin_type c0_ INNER JOIN common_cabin_sub_type c1_ ON c0_.id = c1_.cabin_type_id INNER JOIN common_cabin_category c2_ ON c1_.id = c2_.cabin_sub_type_id INNER JOIN common_price c3_ ON c2_.id = c3_.cabin_category_id WHERE c3_.cruise_id = 532;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3,
  t0.slug AS slug_4,
  t0.description AS description_5,
  t0.short_description AS short_description_6,
  t0.long_description AS long_description_7,
  t0.number_of_members AS number_of_members_8,
  t0.number_of_decks AS number_of_decks_9,
  t0.number_of_cabins AS number_of_cabins_10,
  t0.number_of_passengers AS number_of_passengers_11,
  t0.speed AS speed_12,
  t0.width AS width_13,
  t0.length AS length_14,
  t0.tonnage AS tonnage_15,
  t0.renovation_year AS renovation_year_16,
  t0.construction_year AS construction_year_17,
  t0.additional_informations AS additional_informations_18,
  t0.active AS active_19,
  t0.created_at AS created_at_20,
  t0.created_by AS created_by_21,
  t0.updated_at AS updated_at_22,
  t0.updated_by AS updated_by_23,
  t0.list_order AS list_order_24,
  t0.company_id AS company_id_25,
  t0.fuel_id AS fuel_id_26
FROM
  common_ship t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.slug AS slug_4, t0.description AS description_5, t0.short_description AS short_description_6, t0.long_description AS long_description_7, t0.number_of_members AS number_of_members_8, t0.number_of_decks AS number_of_decks_9, t0.number_of_cabins AS number_of_cabins_10, t0.number_of_passengers AS number_of_passengers_11, t0.speed AS speed_12, t0.width AS width_13, t0.length AS length_14, t0.tonnage AS tonnage_15, t0.renovation_year AS renovation_year_16, t0.construction_year AS construction_year_17, t0.additional_informations AS additional_informations_18, t0.active AS active_19, t0.created_at AS created_at_20, t0.created_by AS created_by_21, t0.updated_at AS updated_at_22, t0.updated_by AS updated_by_23, t0.list_order AS list_order_24, t0.company_id AS company_id_25, t0.fuel_id AS fuel_id_26 FROM common_ship t0 WHERE t0.id = 448;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.`lead` AS lead_3,
  t0.description AS description_4,
  t0.list_description AS list_description_5,
  t0.mid_description AS mid_description_6,
  t0.useful_informations AS useful_informations_7,
  t0.additional_informations AS additional_informations_8,
  t0.code AS code_9,
  t0.slug AS slug_10,
  t0.list_order AS list_order_11,
  t0.active AS active_12,
  t0.created_at AS created_at_13,
  t0.created_by AS created_by_14,
  t0.updated_at AS updated_at_15,
  t0.updated_by AS updated_by_16,
  t0.included AS included_17,
  t0.excluded AS excluded_18
FROM
  common_company t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.`lead` AS lead_3, t0.description AS description_4, t0.list_description AS list_description_5, t0.mid_description AS mid_description_6, t0.useful_informations AS useful_informations_7, t0.additional_informations AS additional_informations_8, t0.code AS code_9, t0.slug AS slug_10, t0.list_order AS list_order_11, t0.active AS active_12, t0.created_at AS created_at_13, t0.created_by AS created_by_14, t0.updated_at AS updated_at_15, t0.updated_by AS updated_by_16, t0.included AS included_17, t0.excluded AS excluded_18 FROM common_company t0 WHERE t0.id = 32;