Symfony Profiler

SELECT
  p.id,
  p.hosting_id as hosting_id,
  p.start_date,
  p.end_date,
  p.date_last_update AS datelastupdate,
  p.description,
  p.ical_url_id,
  ical.title as ical_title,
  ps.value as planning_state_value,
  ps.id as planning_state_id,
  pr.value as planning_reason_value,
  pr.id as planning_reason_id
FROM
  planning p
  LEFT JOIN planning_state ps ON p.planning_state_id = ps.id
  LEFT JOIN planning_reason pr ON p.planning_reason_id = pr.id
  LEFT JOIN ical_urls ical ON p.ical_url_id = ical.id
WHERE
  p.hosting_id = ?
  AND p.start_date <= ?
  AND p.end_date >= ?
ORDER BY
  p.start_date ASC

SELECT
                p.id,
                p.hosting_id as hosting_id,
                p.start_date,
                p.end_date,
                p.date_last_update AS datelastupdate,
                p.description,
                p.ical_url_id,
                ical.title as ical_title,
                ps.value as planning_state_value,
                ps.id as planning_state_id,
                pr.value as planning_reason_value,
                pr.id as planning_reason_id
            FROM planning p
            LEFT JOIN planning_state ps ON p.planning_state_id = ps.id
            LEFT JOIN planning_reason pr ON p.planning_reason_id = pr.id
            LEFT JOIN ical_urls ical ON p.ical_url_id = ical.id
            WHERE p.hosting_id = 12523
              AND p.start_date <= '2028-06-01' AND p.end_date >= '2026-06-01'
            ORDER BY p.start_date ASC
        ;

SELECT
  ps.*
FROM
  pricing_schedule ps
WHERE
  ps.hosting_id = ?
  AND ps.base_price IS NOT NULL
  AND ps.base_price > 0
  AND (
    ps.starting_date IS NULL
    OR ps.starting_date <= NOW()
  )
  AND (
    -- Week prices: strict 7-day slot, only future
    (
      ps.min_nb_of_nights = 7
      AND DATEDIFF(ps.end_date, ps.start_date) = 7
      AND ps.start_date >= ?
    )
    OR -- Advanced prices: period != strict week, show while enough nights remain
    (
      (
        DATEDIFF(ps.end_date, ps.start_date) != 7
        OR COALESCE(ps.min_nb_of_nights, 7) != 7
      )
      AND ps.end_date >= ?
      AND DATEDIFF(ps.end_date, ?) >= COALESCE(ps.min_nb_of_nights, 1)
    )
  )
ORDER BY
  ps.start_date ASC

SELECT ps.*
            FROM pricing_schedule ps
            WHERE ps.hosting_id = 12523
              AND ps.base_price IS NOT NULL
              AND ps.base_price > 0
              AND (ps.starting_date IS NULL OR ps.starting_date <= NOW())
              AND (
                  -- Week prices: strict 7-day slot, only future
                  (
                      ps.min_nb_of_nights = 7
                      AND DATEDIFF(ps.end_date, ps.start_date) = 7
                      AND ps.start_date >= '2026-06-10'
                  )
                  OR
                  -- Advanced prices: period != strict week, show while enough nights remain
                  (
                      (DATEDIFF(ps.end_date, ps.start_date) != 7 OR COALESCE(ps.min_nb_of_nights, 7) != 7)
                      AND ps.end_date >= '2026-06-10'
                      AND DATEDIFF(ps.end_date, '2026-06-10') >= COALESCE(ps.min_nb_of_nights, 1)
                  )
              )
            ORDER BY ps.start_date ASC
        ;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.surface AS surface_3,
  t0.nb_places AS nb_places_4,
  t0.max_nb_places_with_baby AS max_nb_places_with_baby_5,
  t0.nb_confortable_places AS nb_confortable_places_6,
  t0.nb_double_bed AS nb_double_bed_7,
  t0.nb_simple_bed AS nb_simple_bed_8,
  t0.nb_sofa_bed AS nb_sofa_bed_9,
  t0.nb_rooms AS nb_rooms_10,
  t0.sanitary AS sanitary_11,
  t0.independent_sanitary AS independent_sanitary_12,
  t0.shower AS shower_13,
  t0.bathrooms AS bathrooms_14,
  t0.energetic_performance_diag_ce AS energetic_performance_diag_ce_15,
  t0.energetic_performance_diag_ges AS energetic_performance_diag_ges_16,
  t0.surface_under1_m80_height AS surface_under1_m80_height_17,
  t0.points AS points_18,
  t0.classification_registration_number AS classification_registration_number_19,
  t0.classification_registration_date AS classification_registration_date_20,
  t0.external_gateway_id AS external_gateway_id_21,
  t0.created_at AS created_at_22,
  t0.deleted_at AS deleted_at_23,
  t0.is_on_operational_tour_website AS is_on_operational_tour_website_24,
  t0.internet_incoming_flow AS internet_incoming_flow_25,
  t0.internet_outcoming_flow AS internet_outcoming_flow_26,
  t0.internet_gsm_infos AS internet_gsm_infos_27,
  t0.translations_local_source AS translations_local_source_28,
  t0.optimisation_page_consulting_date AS optimisation_page_consulting_date_29,
  t0.is_hosting_primary_house AS is_hosting_primary_house_30,
  t0.is_hosting_secondary_house AS is_hosting_secondary_house_31,
  t0.is_city_hall_declared AS is_city_hall_declared_32,
  t0.sunday_hosting_preference AS sunday_hosting_preference_33,
  t0.is_city_hall_simple_declaration AS is_city_hall_simple_declaration_34,
  t0.is_owner AS is_owner_35,
  t0.city_hall_declaration_number AS city_hall_declaration_number_36,
  t0.city_hall_declaration_date AS city_hall_declaration_date_37,
  t0.city_hall_declaration_date_signature AS city_hall_declaration_date_signature_38,
  t0.latitude AS latitude_39,
  t0.longitude AS longitude_40,
  t0.sea_view_angle AS sea_view_angle_41,
  t0.km_distance_from_sea AS km_distance_from_sea_42,
  t0.address AS address_43,
  t0.zip AS zip_44,
  t0.city AS city_45,
  t0.optional_address_info AS optional_address_info_46,
  t0.is_address_valid AS is_address_valid_47,
  t0.nb_pieces AS nb_pieces_48,
  t0.reference AS reference_49,
  t0.alur_target_charge_value AS alur_target_charge_value_50,
  t0.alur_corpo_value AS alur_corpo_value_51,
  t0.is_on_personal_website_welcome_page AS is_on_personal_website_welcome_page_52,
  t0.insurance_link_fr AS insurance_link_fr_53,
  t0.insurance_link_en AS insurance_link_en_54,
  t0.is_on_website_to AS is_on_website_to_55,
  t0.charges AS charges_56,
  t0.only_for_sale AS only_for_sale_57,
  t0.sunday_for_rent AS sunday_for_rent_58,
  t0.saturday_for_rent AS saturday_for_rent_59,
  t0.has_short_stay AS has_short_stay_60,
  t0.end_date AS end_date_61,
  t0.website_url AS website_url_62,
  t0.video_code AS video_code_63,
  t0.hosting_type_id AS hosting_type_id_64,
  t0.distance_from_station_km_id AS distance_from_station_km_id_65,
  t0.distance_from_ski_lift_id AS distance_from_ski_lift_id_66,
  t0.tag_id AS tag_id_67,
  t0.hosting_class_id AS hosting_class_id_68,
  t0.spot_id AS spot_id_69,
  t0.sale_id AS sale_id_70,
  t0.rental_id AS rental_id_71,
  t0.floor_id AS floor_id_72,
  t0.lessor_id AS lessor_id_73,
  t0.country_id AS country_id_74,
  t0.geo_ville_id AS geo_ville_id_75,
  t0.distance_from_station_km2_id AS distance_from_station_km2_id_76,
  t0.distance_from_ski_lift2_id AS distance_from_ski_lift2_id_77,
  t0.main_station_id AS main_station_id_78,
  t0.secondary_station_id AS secondary_station_id_79
FROM
  hosting t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.surface AS surface_3, t0.nb_places AS nb_places_4, t0.max_nb_places_with_baby AS max_nb_places_with_baby_5, t0.nb_confortable_places AS nb_confortable_places_6, t0.nb_double_bed AS nb_double_bed_7, t0.nb_simple_bed AS nb_simple_bed_8, t0.nb_sofa_bed AS nb_sofa_bed_9, t0.nb_rooms AS nb_rooms_10, t0.sanitary AS sanitary_11, t0.independent_sanitary AS independent_sanitary_12, t0.shower AS shower_13, t0.bathrooms AS bathrooms_14, t0.energetic_performance_diag_ce AS energetic_performance_diag_ce_15, t0.energetic_performance_diag_ges AS energetic_performance_diag_ges_16, t0.surface_under1_m80_height AS surface_under1_m80_height_17, t0.points AS points_18, t0.classification_registration_number AS classification_registration_number_19, t0.classification_registration_date AS classification_registration_date_20, t0.external_gateway_id AS external_gateway_id_21, t0.created_at AS created_at_22, t0.deleted_at AS deleted_at_23, t0.is_on_operational_tour_website AS is_on_operational_tour_website_24, t0.internet_incoming_flow AS internet_incoming_flow_25, t0.internet_outcoming_flow AS internet_outcoming_flow_26, t0.internet_gsm_infos AS internet_gsm_infos_27, t0.translations_local_source AS translations_local_source_28, t0.optimisation_page_consulting_date AS optimisation_page_consulting_date_29, t0.is_hosting_primary_house AS is_hosting_primary_house_30, t0.is_hosting_secondary_house AS is_hosting_secondary_house_31, t0.is_city_hall_declared AS is_city_hall_declared_32, t0.sunday_hosting_preference AS sunday_hosting_preference_33, t0.is_city_hall_simple_declaration AS is_city_hall_simple_declaration_34, t0.is_owner AS is_owner_35, t0.city_hall_declaration_number AS city_hall_declaration_number_36, t0.city_hall_declaration_date AS city_hall_declaration_date_37, t0.city_hall_declaration_date_signature AS city_hall_declaration_date_signature_38, t0.latitude AS latitude_39, t0.longitude AS longitude_40, t0.sea_view_angle AS sea_view_angle_41, t0.km_distance_from_sea AS km_distance_from_sea_42, t0.address AS address_43, t0.zip AS zip_44, t0.city AS city_45, t0.optional_address_info AS optional_address_info_46, t0.is_address_valid AS is_address_valid_47, t0.nb_pieces AS nb_pieces_48, t0.reference AS reference_49, t0.alur_target_charge_value AS alur_target_charge_value_50, t0.alur_corpo_value AS alur_corpo_value_51, t0.is_on_personal_website_welcome_page AS is_on_personal_website_welcome_page_52, t0.insurance_link_fr AS insurance_link_fr_53, t0.insurance_link_en AS insurance_link_en_54, t0.is_on_website_to AS is_on_website_to_55, t0.charges AS charges_56, t0.only_for_sale AS only_for_sale_57, t0.sunday_for_rent AS sunday_for_rent_58, t0.saturday_for_rent AS saturday_for_rent_59, t0.has_short_stay AS has_short_stay_60, t0.end_date AS end_date_61, t0.website_url AS website_url_62, t0.video_code AS video_code_63, t0.hosting_type_id AS hosting_type_id_64, t0.distance_from_station_km_id AS distance_from_station_km_id_65, t0.distance_from_ski_lift_id AS distance_from_ski_lift_id_66, t0.tag_id AS tag_id_67, t0.hosting_class_id AS hosting_class_id_68, t0.spot_id AS spot_id_69, t0.sale_id AS sale_id_70, t0.rental_id AS rental_id_71, t0.floor_id AS floor_id_72, t0.lessor_id AS lessor_id_73, t0.country_id AS country_id_74, t0.geo_ville_id AS geo_ville_id_75, t0.distance_from_station_km2_id AS distance_from_station_km2_id_76, t0.distance_from_ski_lift2_id AS distance_from_ski_lift2_id_77, t0.main_station_id AS main_station_id_78, t0.secondary_station_id AS secondary_station_id_79 FROM hosting t0 WHERE t0.id = 12523;

SELECT
  p0_.id AS id_0,
  p0_.start_date AS start_date_1,
  p0_.end_date AS end_date_2,
  p0_.week_price AS week_price_3,
  p0_.comment AS comment_4,
  p0_.base_price AS base_price_5,
  p0_.additional_night_price AS additional_night_price_6,
  p0_.min_nb_of_nights AS min_nb_of_nights_7,
  p0_.starting_date AS starting_date_8,
  p0_.discount_percentage AS discount_percentage_9,
  p0_.arrival_day AS arrival_day_10,
  p0_.hosting_id AS hosting_id_11
FROM
  pricing_schedule p0_
WHERE
  p0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )
ORDER BY
  p0_.start_date ASC

SELECT p0_.id AS id_0, p0_.start_date AS start_date_1, p0_.end_date AS end_date_2, p0_.week_price AS week_price_3, p0_.comment AS comment_4, p0_.base_price AS base_price_5, p0_.additional_night_price AS additional_night_price_6, p0_.min_nb_of_nights AS min_nb_of_nights_7, p0_.starting_date AS starting_date_8, p0_.discount_percentage AS discount_percentage_9, p0_.arrival_day AS arrival_day_10, p0_.hosting_id AS hosting_id_11 FROM pricing_schedule p0_ WHERE p0_.id IN (71248939, 70873017, 70873052, 70873018, 70873053, 70873019, 70873054, 70873020, 70873055, 70873021, 70873056, 70873022, 70873057, 70873023, 70873058, 70873024, 70873059, 70873025, 70873060, 70873026, 70873061, 70873027, 70873062, 70873028, 70873067, 71248940, 70873029, 70873063, 70873030, 70873064, 70873031, 70873065, 70873032, 70873066, 70873033, 70873068, 70873034, 70873069, 70873035, 70873070, 70873036, 70873071, 70873037, 70873072, 70873038, 70873073, 70873039, 70873074, 70873040, 75227871, 75227905, 75227872, 75227906, 75227873, 75227907, 75227874, 75227908, 75227875, 75227909, 75227876, 75227910, 75227877, 75227911, 75227878, 75227912, 75227879, 75227913, 75227880, 75227914, 75227881, 75227915, 75227882, 75227916, 75227883, 75227917, 75227884, 75227918, 75227885, 75227919, 75227886, 75227920, 75227887, 75227921, 75227888, 75227922, 75227889, 75227923, 75227890, 75227924, 75227891, 75227925, 75227892, 75227926, 75227893, 75227927, 75227894, 75227928, 75227895, 75227929, 75227896, 75227930, 75227897, 75227931, 75227898, 75227932, 75227899, 75227933, 75227900, 75227934, 75227901, 75227935, 75227902, 75227936, 75227903, 75227937, 75227904) ORDER BY p0_.start_date ASC;