Symfony Profiler

[
  "route" => "api_public_front_hostings_availability"
  "route_parameters" => [
    "_route" => "api_public_front_hostings_availability"
    "_controller" => "App\Controller\Api\PublicFront\PublicHostingHomeController::availability"
    "hostingId" => "12523"
  ]
  "request_uri" => "https://backend.chalet-montagne.com/api/public-front/hostings/12523/availability?count=4&from=2026-10"
  "method" => "GET"
]

[
  "firewall_name" => "api"
  "authenticators" => 1
]

[
  "firewall_name" => "api"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "firewall_name" => "api"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "params" => [
    "use_savepoints" => true
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "localhost"
    "port" => 3306
    "user" => "chaletmont2026"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "chaletmont2026"
    "serverVersion" => "8.0.33"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 12523
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => """
    \n
                SELECT ps.*\n
                FROM pricing_schedule ps\n
                WHERE ps.hosting_id = ?\n
                  AND ps.base_price IS NOT NULL\n
                  AND ps.base_price > 0\n
                  AND (ps.starting_date IS NULL OR ps.starting_date <= NOW())\n
                  AND (\n
                      -- Week prices: strict 7-day slot, only future\n
                      (\n
                          ps.min_nb_of_nights = 7\n
                          AND DATEDIFF(ps.end_date, ps.start_date) = 7\n
                          AND ps.start_date >= ?\n
                      )\n
                      OR\n
                      -- Advanced prices: period != strict week, show while enough nights remain\n
                      (\n
                          (DATEDIFF(ps.end_date, ps.start_date) != 7 OR COALESCE(ps.min_nb_of_nights, 7) != 7)\n
                          AND ps.end_date >= ?\n
                          AND DATEDIFF(ps.end_date, ?) >= COALESCE(ps.min_nb_of_nights, 1)\n
                      )\n
                  )\n
                ORDER BY ps.start_date ASC\n
            
    """
  "params" => [
    1 => 12523
    2 => "2026-06-10"
    3 => "2026-06-10"
    4 => "2026-06-10"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 71248939
    2 => 70873017
    3 => 70873052
    4 => 70873018
    5 => 70873053
    6 => 70873019
    7 => 70873054
    8 => 70873020
    9 => 70873055
    10 => 70873021
    11 => 70873056
    12 => 70873022
    13 => 70873057
    14 => 70873023
    15 => 70873058
    16 => 70873024
    17 => 70873059
    18 => 70873025
    19 => 70873060
    20 => 70873026
    21 => 70873061
    22 => 70873027
    23 => 70873062
    24 => 70873028
    25 => 70873067
    26 => 71248940
    27 => 70873029
    28 => 70873063
    29 => 70873030
    30 => 70873064
    31 => 70873031
    32 => 70873065
    33 => 70873032
    34 => 70873066
    35 => 70873033
    36 => 70873068
    37 => 70873034
    38 => 70873069
    39 => 70873035
    40 => 70873070
    41 => 70873036
    42 => 70873071
    43 => 70873037
    44 => 70873072
    45 => 70873038
    46 => 70873073
    47 => 70873039
    48 => 70873074
    49 => 70873040
    50 => 75227871
    51 => 75227905
    52 => 75227872
    53 => 75227906
    54 => 75227873
    55 => 75227907
    56 => 75227874
    57 => 75227908
    58 => 75227875
    59 => 75227909
    60 => 75227876
    61 => 75227910
    62 => 75227877
    63 => 75227911
    64 => 75227878
    65 => 75227912
    66 => 75227879
    67 => 75227913
    68 => 75227880
    69 => 75227914
    70 => 75227881
    71 => 75227915
    72 => 75227882
    73 => 75227916
    74 => 75227883
    75 => 75227917
    76 => 75227884
    77 => 75227918
    78 => 75227885
    79 => 75227919
    80 => 75227886
    81 => 75227920
    82 => 75227887
    83 => 75227921
    84 => 75227888
    85 => 75227922
    86 => 75227889
    87 => 75227923
    88 => 75227890
    89 => 75227924
    90 => 75227891
    91 => 75227925
    92 => 75227892
    93 => 75227926
    94 => 75227893
    95 => 75227927
    96 => 75227894
    97 => 75227928
    98 => 75227895
    99 => 75227929
    100 => 75227896
    101 => 75227930
    102 => 75227897
    103 => 75227931
    104 => 75227898
    105 => 75227932
    106 => 75227899
    107 => 75227933
    108 => 75227900
    109 => 75227934
    110 => 75227901
    111 => 75227935
    112 => 75227902
    113 => 75227936
    114 => 75227903
    115 => 75227937
    116 => 75227904
  ]
  "types" => [
    1 => 1
    2 => 1
    3 => 1
    4 => 1
    5 => 1
    6 => 1
    7 => 1
    8 => 1
    9 => 1
    10 => 1
    11 => 1
    12 => 1
    13 => 1
    14 => 1
    15 => 1
    16 => 1
    17 => 1
    18 => 1
    19 => 1
    20 => 1
    21 => 1
    22 => 1
    23 => 1
    24 => 1
    25 => 1
    26 => 1
    27 => 1
    28 => 1
    29 => 1
    30 => 1
    31 => 1
    32 => 1
    33 => 1
    34 => 1
    35 => 1
    36 => 1
    37 => 1
    38 => 1
    39 => 1
    40 => 1
    41 => 1
    42 => 1
    43 => 1
    44 => 1
    45 => 1
    46 => 1
    47 => 1
    48 => 1
    49 => 1
    50 => 1
    51 => 1
    52 => 1
    53 => 1
    54 => 1
    55 => 1
    56 => 1
    57 => 1
    58 => 1
    59 => 1
    60 => 1
    61 => 1
    62 => 1
    63 => 1
    64 => 1
    65 => 1
    66 => 1
    67 => 1
    68 => 1
    69 => 1
    70 => 1
    71 => 1
    72 => 1
    73 => 1
    74 => 1
    75 => 1
    76 => 1
    77 => 1
    78 => 1
    79 => 1
    80 => 1
    81 => 1
    82 => 1
    83 => 1
    84 => 1
    85 => 1
    86 => 1
    87 => 1
    88 => 1
    89 => 1
    90 => 1
    91 => 1
    92 => 1
    93 => 1
    94 => 1
    95 => 1
    96 => 1
    97 => 1
    98 => 1
    99 => 1
    100 => 1
    101 => 1
    102 => 1
    103 => 1
    104 => 1
    105 => 1
    106 => 1
    107 => 1
    108 => 1
    109 => 1
    110 => 1
    111 => 1
    112 => 1
    113 => 1
    114 => 1
    115 => 1
    116 => 1
  ]
]

[
  "sql" => """
    \n
                SELECT\n
                    p.id,\n
                    p.hosting_id as hosting_id,\n
                    p.start_date,\n
                    p.end_date,\n
                    p.date_last_update AS datelastupdate,\n
                    p.description,\n
                    p.ical_url_id,\n
                    ical.title as ical_title,\n
                    ps.value as planning_state_value,\n
                    ps.id as planning_state_id,\n
                    pr.value as planning_reason_value,\n
                    pr.id as planning_reason_id\n
                FROM planning p\n
                LEFT JOIN planning_state ps ON p.planning_state_id = ps.id\n
                LEFT JOIN planning_reason pr ON p.planning_reason_id = pr.id\n
                LEFT JOIN ical_urls ical ON p.ical_url_id = ical.id\n
                WHERE p.hosting_id = ?\n
                  AND p.start_date <= ? AND p.end_date >= ?\n
                ORDER BY p.start_date ASC\n
            
    """
  "params" => [
    1 => 12523
    2 => "2028-06-01"
    3 => "2026-06-01"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
  ]
]