Symfony Profiler

[
  "route" => "home"
  "route_parameters" => [
    "_route" => "home"
    "_controller" => "App\Controller\HomeController::index"
  ]
  "request_uri" => "https://av.p4y.pt/"
  "method" => "GET"
]

[
  "firewall_name" => "main"
  "authenticators" => 0
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\DebugHandlersListener::configure"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\UX\Turbo\Request\RequestListener::__invoke"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ValidateRequestListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Bridge\Doctrine\Middleware\IdleConnection\Listener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::setDefaultLocale"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\AssetMapper\AssetMapperDevServerSubscriber::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::configureLogoutUrlGenerator"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelRequest"
]

[
  "event" => "kernel.controller"
  "listener" => "Symfony\Bundle\FrameworkBundle\DataCollector\RouterDataCollector::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelController"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\Security\Http\EventListener\IsCsrfTokenValidAttributeListener::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\Security\Http\EventListener\IsGrantedAttributeListener::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\HttpKernel\EventListener\CacheAttributeListener::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "ContainerIu3zw7S\RequestPayloadValueResolverGhost01ca9cc::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ErrorListener::onControllerArguments"
]

[
  "params" => [
    "use_savepoints" => true
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "localhost"
    "port" => 3306
    "user" => "admin_vacation"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "admin_av"
    "serverVersion" => "10.3.39-MariaDB"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "SELECT l0_.code AS code_0, l0_.name AS name_1, COUNT(a1_.id) AS sclr_2 FROM location l0_ LEFT JOIN accommodation a1_ ON (a1_.location_id = l0_.id) GROUP BY l0_.id ORDER BY l0_.name ASC"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.accommodation_id AS accommodation_id_2, t0.user_id AS user_id_3, t0.company AS company_4, t0.company_id AS company_id_5, t0.accommodation_name AS accommodation_name_6, t0.id_gallery AS id_gallery_7, t0.occupational_rule_id AS occupational_rule_id_8, t0.price_modifier_id AS price_modifier_id_9, t0.purpose AS purpose_10, t0.kind_id AS kind_id_11, t0.latitude AS latitude_12, t0.longitude AS longitude_13, t0.accommodation_units AS accommodation_units_14, t0.currency AS currency_15, t0.vat_included AS vat_included_16, t0.touristic_registration_number AS touristic_registration_number_17, t0.location_id AS location_id_18, t19.id AS id_20, t19.people_capacity AS people_capacity_21, t19.minimum_occupation AS minimum_occupation_22, t19.accept_youngsters AS accept_youngsters_23, t19.occupation_without_supplement AS occupation_without_supplement_24, t19.bedrooms AS bedrooms_25, t19.double_beds AS double_beds_26, t19.individual_beds AS individual_beds_27, t19.individual_sofa_bed AS individual_sofa_bed_28, t19.double_sofa_bed AS double_sofa_bed_29, t19.queen_beds AS queen_beds_30, t19.king_beds AS king_beds_31, t19.toilets AS toilets_32, t19.bathroom_with_bathtub AS bathroom_with_bathtub_33, t19.bathroom_with_shower AS bathroom_with_shower_34, t19.berths AS berths_35, t19.area_housing AS area_housing_36, t19.area_housing_unit AS area_housing_unit_37, t19.area_plot AS area_plot_38, t19.area_plot_unit AS area_plot_unit_39, t19.adults_capacity AS adults_capacity_40, t19.accommodation_id AS accommodation_id_41, t42.id AS id_43, t42.tv AS tv_44, t42.garden AS garden_45, t42.garden_furniture AS garden_furniture_46, t42.iron AS iron_47, t42.fire_place AS fire_place_48, t42.barbacue AS barbacue_49, t42.radio AS radio_50, t42.mini_bar AS mini_bar_51, t42.terrace AS terrace_52, t42.fenced_plot AS fenced_plot_53, t42.security_box AS security_box_54, t42.elevator AS elevator_55, t42.dvd AS dvd_56, t42.balcony AS balcony_57, t42.juice_squeezer AS juice_squeezer_58, t42.electric_kettle AS electric_kettle_59, t42.hair_dryer AS hair_dryer_60, t42.children_area AS children_area_61, t42.gym AS gym_62, t42.alarm AS alarm_63, t42.tennis AS tennis_64, t42.squash AS squash_65, t42.paddel AS paddel_66, t42.sauna AS sauna_67, t42.handicapped_facilities AS handicapped_facilities_68, t42.jacuzzi AS jacuzzi_69, t42.smoking_allowed AS smoking_allowed_70, t42.num_of_televisions AS num_of_televisions_71, t42.num_of_fans AS num_of_fans_72, t42.num_of_electronic_mosquito_repeller AS num_of_electronic_mosquito_repeller_73, t42.window_screens AS window_screens_74, t42.acswimming_pool_id AS acswimming_pool_id_75, t42.tv_satellite_id AS tv_satellite_id_76, t42.ackitchen_id AS ackitchen_id_77, t42.accommodation_id AS accommodation_id_78, t79.id AS id_80, t79.name AS name_81, t79.video AS video_82, t79.code AS code_83, t79.accommodation_id AS accommodation_id_84 FROM accommodation t0 LEFT JOIN ac_distribution t19 ON t19.accommodation_id = t0.id LEFT JOIN ac_house_characteristics t42 ON t42.accommodation_id = t0.id LEFT JOIN video t79 ON t79.accommodation_id = t0.id WHERE t0.accommodation_id = ? LIMIT 1"
  "params" => [
    1 => 164637
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT r0_.id AS id_0, r0_.capacity AS capacity_1, r0_.start_date AS start_date_2, r0_.end_date AS end_date_3, r0_.type AS type_4, r0_.price AS price_5, r0_.applicable_from_number_people AS applicable_from_number_people_6, r0_.supplement AS supplement_7, r0_.accommodation_id AS accommodation_id_8 FROM rate r0_ WHERE r0_.accommodation_id = ? AND (? BETWEEN r0_.start_date AND r0_.end_date) ORDER BY r0_.start_date ASC LIMIT 1"
  "params" => [
    1 => 1
    2 => "2026-05-06 14:29:58"
  ]
  "types" => [
    1 => 1
    2 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.code AS code_2, t0.locale AS locale_3, t0.text AS text_4 FROM kind t0 WHERE t0.code = ? AND t0.locale = ? LIMIT 1"
  "params" => [
    1 => 2
    2 => "en"
  ]
  "types" => [
    1 => 1
    2 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.people_capacity AS people_capacity_2, t0.minimum_occupation AS minimum_occupation_3, t0.accept_youngsters AS accept_youngsters_4, t0.occupation_without_supplement AS occupation_without_supplement_5, t0.bedrooms AS bedrooms_6, t0.double_beds AS double_beds_7, t0.individual_beds AS individual_beds_8, t0.individual_sofa_bed AS individual_sofa_bed_9, t0.double_sofa_bed AS double_sofa_bed_10, t0.queen_beds AS queen_beds_11, t0.king_beds AS king_beds_12, t0.toilets AS toilets_13, t0.bathroom_with_bathtub AS bathroom_with_bathtub_14, t0.bathroom_with_shower AS bathroom_with_shower_15, t0.berths AS berths_16, t0.area_housing AS area_housing_17, t0.area_housing_unit AS area_housing_unit_18, t0.area_plot AS area_plot_19, t0.area_plot_unit AS area_plot_unit_20, t0.adults_capacity AS adults_capacity_21, t0.accommodation_id AS accommodation_id_22 FROM ac_distribution t0 WHERE t0.accommodation_id = ? LIMIT 1"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.is_airport AS is_airport_3, t0.is_active AS is_active_4, t0.is_online AS is_online_5, t0.is_deleted AS is_deleted_6, t0.is_transfer AS is_transfer_7, t0.traveltime AS traveltime_8, t0.gps AS gps_9, t0.code AS code_10, t0.transferarea_id AS transferarea_id_11 FROM location t0 WHERE t0.id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.accommodation_id AS accommodation_id_2, t0.user_id AS user_id_3, t0.company AS company_4, t0.company_id AS company_id_5, t0.accommodation_name AS accommodation_name_6, t0.id_gallery AS id_gallery_7, t0.occupational_rule_id AS occupational_rule_id_8, t0.price_modifier_id AS price_modifier_id_9, t0.purpose AS purpose_10, t0.kind_id AS kind_id_11, t0.latitude AS latitude_12, t0.longitude AS longitude_13, t0.accommodation_units AS accommodation_units_14, t0.currency AS currency_15, t0.vat_included AS vat_included_16, t0.touristic_registration_number AS touristic_registration_number_17, t0.location_id AS location_id_18, t19.id AS id_20, t19.people_capacity AS people_capacity_21, t19.minimum_occupation AS minimum_occupation_22, t19.accept_youngsters AS accept_youngsters_23, t19.occupation_without_supplement AS occupation_without_supplement_24, t19.bedrooms AS bedrooms_25, t19.double_beds AS double_beds_26, t19.individual_beds AS individual_beds_27, t19.individual_sofa_bed AS individual_sofa_bed_28, t19.double_sofa_bed AS double_sofa_bed_29, t19.queen_beds AS queen_beds_30, t19.king_beds AS king_beds_31, t19.toilets AS toilets_32, t19.bathroom_with_bathtub AS bathroom_with_bathtub_33, t19.bathroom_with_shower AS bathroom_with_shower_34, t19.berths AS berths_35, t19.area_housing AS area_housing_36, t19.area_housing_unit AS area_housing_unit_37, t19.area_plot AS area_plot_38, t19.area_plot_unit AS area_plot_unit_39, t19.adults_capacity AS adults_capacity_40, t19.accommodation_id AS accommodation_id_41, t42.id AS id_43, t42.tv AS tv_44, t42.garden AS garden_45, t42.garden_furniture AS garden_furniture_46, t42.iron AS iron_47, t42.fire_place AS fire_place_48, t42.barbacue AS barbacue_49, t42.radio AS radio_50, t42.mini_bar AS mini_bar_51, t42.terrace AS terrace_52, t42.fenced_plot AS fenced_plot_53, t42.security_box AS security_box_54, t42.elevator AS elevator_55, t42.dvd AS dvd_56, t42.balcony AS balcony_57, t42.juice_squeezer AS juice_squeezer_58, t42.electric_kettle AS electric_kettle_59, t42.hair_dryer AS hair_dryer_60, t42.children_area AS children_area_61, t42.gym AS gym_62, t42.alarm AS alarm_63, t42.tennis AS tennis_64, t42.squash AS squash_65, t42.paddel AS paddel_66, t42.sauna AS sauna_67, t42.handicapped_facilities AS handicapped_facilities_68, t42.jacuzzi AS jacuzzi_69, t42.smoking_allowed AS smoking_allowed_70, t42.num_of_televisions AS num_of_televisions_71, t42.num_of_fans AS num_of_fans_72, t42.num_of_electronic_mosquito_repeller AS num_of_electronic_mosquito_repeller_73, t42.window_screens AS window_screens_74, t42.acswimming_pool_id AS acswimming_pool_id_75, t42.tv_satellite_id AS tv_satellite_id_76, t42.ackitchen_id AS ackitchen_id_77, t42.accommodation_id AS accommodation_id_78, t79.id AS id_80, t79.name AS name_81, t79.video AS video_82, t79.code AS code_83, t79.accommodation_id AS accommodation_id_84 FROM accommodation t0 LEFT JOIN ac_distribution t19 ON t19.accommodation_id = t0.id LEFT JOIN ac_house_characteristics t42 ON t42.accommodation_id = t0.id LEFT JOIN video t79 ON t79.accommodation_id = t0.id WHERE t0.accommodation_id = ? LIMIT 1"
  "params" => [
    1 => 354243
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT r0_.id AS id_0, r0_.capacity AS capacity_1, r0_.start_date AS start_date_2, r0_.end_date AS end_date_3, r0_.type AS type_4, r0_.price AS price_5, r0_.applicable_from_number_people AS applicable_from_number_people_6, r0_.supplement AS supplement_7, r0_.accommodation_id AS accommodation_id_8 FROM rate r0_ WHERE r0_.accommodation_id = ? AND (? BETWEEN r0_.start_date AND r0_.end_date) ORDER BY r0_.start_date ASC LIMIT 1"
  "params" => [
    1 => 40
    2 => "2026-05-06 14:29:58"
  ]
  "types" => [
    1 => 1
    2 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.code AS code_2, t0.locale AS locale_3, t0.text AS text_4 FROM kind t0 WHERE t0.code = ? AND t0.locale = ? LIMIT 1"
  "params" => [
    1 => 2
    2 => "en"
  ]
  "types" => [
    1 => 1
    2 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.people_capacity AS people_capacity_2, t0.minimum_occupation AS minimum_occupation_3, t0.accept_youngsters AS accept_youngsters_4, t0.occupation_without_supplement AS occupation_without_supplement_5, t0.bedrooms AS bedrooms_6, t0.double_beds AS double_beds_7, t0.individual_beds AS individual_beds_8, t0.individual_sofa_bed AS individual_sofa_bed_9, t0.double_sofa_bed AS double_sofa_bed_10, t0.queen_beds AS queen_beds_11, t0.king_beds AS king_beds_12, t0.toilets AS toilets_13, t0.bathroom_with_bathtub AS bathroom_with_bathtub_14, t0.bathroom_with_shower AS bathroom_with_shower_15, t0.berths AS berths_16, t0.area_housing AS area_housing_17, t0.area_housing_unit AS area_housing_unit_18, t0.area_plot AS area_plot_19, t0.area_plot_unit AS area_plot_unit_20, t0.adults_capacity AS adults_capacity_21, t0.accommodation_id AS accommodation_id_22 FROM ac_distribution t0 WHERE t0.accommodation_id = ? LIMIT 1"
  "params" => [
    1 => 40
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.is_airport AS is_airport_3, t0.is_active AS is_active_4, t0.is_online AS is_online_5, t0.is_deleted AS is_deleted_6, t0.is_transfer AS is_transfer_7, t0.traveltime AS traveltime_8, t0.gps AS gps_9, t0.code AS code_10, t0.transferarea_id AS transferarea_id_11 FROM location t0 WHERE t0.id = ?"
  "params" => [
    1 => 8
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.accommodation_id AS accommodation_id_2, t0.user_id AS user_id_3, t0.company AS company_4, t0.company_id AS company_id_5, t0.accommodation_name AS accommodation_name_6, t0.id_gallery AS id_gallery_7, t0.occupational_rule_id AS occupational_rule_id_8, t0.price_modifier_id AS price_modifier_id_9, t0.purpose AS purpose_10, t0.kind_id AS kind_id_11, t0.latitude AS latitude_12, t0.longitude AS longitude_13, t0.accommodation_units AS accommodation_units_14, t0.currency AS currency_15, t0.vat_included AS vat_included_16, t0.touristic_registration_number AS touristic_registration_number_17, t0.location_id AS location_id_18, t19.id AS id_20, t19.people_capacity AS people_capacity_21, t19.minimum_occupation AS minimum_occupation_22, t19.accept_youngsters AS accept_youngsters_23, t19.occupation_without_supplement AS occupation_without_supplement_24, t19.bedrooms AS bedrooms_25, t19.double_beds AS double_beds_26, t19.individual_beds AS individual_beds_27, t19.individual_sofa_bed AS individual_sofa_bed_28, t19.double_sofa_bed AS double_sofa_bed_29, t19.queen_beds AS queen_beds_30, t19.king_beds AS king_beds_31, t19.toilets AS toilets_32, t19.bathroom_with_bathtub AS bathroom_with_bathtub_33, t19.bathroom_with_shower AS bathroom_with_shower_34, t19.berths AS berths_35, t19.area_housing AS area_housing_36, t19.area_housing_unit AS area_housing_unit_37, t19.area_plot AS area_plot_38, t19.area_plot_unit AS area_plot_unit_39, t19.adults_capacity AS adults_capacity_40, t19.accommodation_id AS accommodation_id_41, t42.id AS id_43, t42.tv AS tv_44, t42.garden AS garden_45, t42.garden_furniture AS garden_furniture_46, t42.iron AS iron_47, t42.fire_place AS fire_place_48, t42.barbacue AS barbacue_49, t42.radio AS radio_50, t42.mini_bar AS mini_bar_51, t42.terrace AS terrace_52, t42.fenced_plot AS fenced_plot_53, t42.security_box AS security_box_54, t42.elevator AS elevator_55, t42.dvd AS dvd_56, t42.balcony AS balcony_57, t42.juice_squeezer AS juice_squeezer_58, t42.electric_kettle AS electric_kettle_59, t42.hair_dryer AS hair_dryer_60, t42.children_area AS children_area_61, t42.gym AS gym_62, t42.alarm AS alarm_63, t42.tennis AS tennis_64, t42.squash AS squash_65, t42.paddel AS paddel_66, t42.sauna AS sauna_67, t42.handicapped_facilities AS handicapped_facilities_68, t42.jacuzzi AS jacuzzi_69, t42.smoking_allowed AS smoking_allowed_70, t42.num_of_televisions AS num_of_televisions_71, t42.num_of_fans AS num_of_fans_72, t42.num_of_electronic_mosquito_repeller AS num_of_electronic_mosquito_repeller_73, t42.window_screens AS window_screens_74, t42.acswimming_pool_id AS acswimming_pool_id_75, t42.tv_satellite_id AS tv_satellite_id_76, t42.ackitchen_id AS ackitchen_id_77, t42.accommodation_id AS accommodation_id_78, t79.id AS id_80, t79.name AS name_81, t79.video AS video_82, t79.code AS code_83, t79.accommodation_id AS accommodation_id_84 FROM accommodation t0 LEFT JOIN ac_distribution t19 ON t19.accommodation_id = t0.id LEFT JOIN ac_house_characteristics t42 ON t42.accommodation_id = t0.id LEFT JOIN video t79 ON t79.accommodation_id = t0.id WHERE t0.accommodation_id = ? LIMIT 1"
  "params" => [
    1 => 165242
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT r0_.id AS id_0, r0_.capacity AS capacity_1, r0_.start_date AS start_date_2, r0_.end_date AS end_date_3, r0_.type AS type_4, r0_.price AS price_5, r0_.applicable_from_number_people AS applicable_from_number_people_6, r0_.supplement AS supplement_7, r0_.accommodation_id AS accommodation_id_8 FROM rate r0_ WHERE r0_.accommodation_id = ? AND (? BETWEEN r0_.start_date AND r0_.end_date) ORDER BY r0_.start_date ASC LIMIT 1"
  "params" => [
    1 => 8
    2 => "2026-05-06 14:29:58"
  ]
  "types" => [
    1 => 1
    2 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.code AS code_2, t0.locale AS locale_3, t0.text AS text_4 FROM kind t0 WHERE t0.code = ? AND t0.locale = ? LIMIT 1"
  "params" => [
    1 => 2
    2 => "en"
  ]
  "types" => [
    1 => 1
    2 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.people_capacity AS people_capacity_2, t0.minimum_occupation AS minimum_occupation_3, t0.accept_youngsters AS accept_youngsters_4, t0.occupation_without_supplement AS occupation_without_supplement_5, t0.bedrooms AS bedrooms_6, t0.double_beds AS double_beds_7, t0.individual_beds AS individual_beds_8, t0.individual_sofa_bed AS individual_sofa_bed_9, t0.double_sofa_bed AS double_sofa_bed_10, t0.queen_beds AS queen_beds_11, t0.king_beds AS king_beds_12, t0.toilets AS toilets_13, t0.bathroom_with_bathtub AS bathroom_with_bathtub_14, t0.bathroom_with_shower AS bathroom_with_shower_15, t0.berths AS berths_16, t0.area_housing AS area_housing_17, t0.area_housing_unit AS area_housing_unit_18, t0.area_plot AS area_plot_19, t0.area_plot_unit AS area_plot_unit_20, t0.adults_capacity AS adults_capacity_21, t0.accommodation_id AS accommodation_id_22 FROM ac_distribution t0 WHERE t0.accommodation_id = ? LIMIT 1"
  "params" => [
    1 => 8
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.is_airport AS is_airport_3, t0.is_active AS is_active_4, t0.is_online AS is_online_5, t0.is_deleted AS is_deleted_6, t0.is_transfer AS is_transfer_7, t0.traveltime AS traveltime_8, t0.gps AS gps_9, t0.code AS code_10, t0.transferarea_id AS transferarea_id_11 FROM location t0 WHERE t0.id = ?"
  "params" => [
    1 => 4
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.accommodation_id AS accommodation_id_2, t0.user_id AS user_id_3, t0.company AS company_4, t0.company_id AS company_id_5, t0.accommodation_name AS accommodation_name_6, t0.id_gallery AS id_gallery_7, t0.occupational_rule_id AS occupational_rule_id_8, t0.price_modifier_id AS price_modifier_id_9, t0.purpose AS purpose_10, t0.kind_id AS kind_id_11, t0.latitude AS latitude_12, t0.longitude AS longitude_13, t0.accommodation_units AS accommodation_units_14, t0.currency AS currency_15, t0.vat_included AS vat_included_16, t0.touristic_registration_number AS touristic_registration_number_17, t0.location_id AS location_id_18, t19.id AS id_20, t19.people_capacity AS people_capacity_21, t19.minimum_occupation AS minimum_occupation_22, t19.accept_youngsters AS accept_youngsters_23, t19.occupation_without_supplement AS occupation_without_supplement_24, t19.bedrooms AS bedrooms_25, t19.double_beds AS double_beds_26, t19.individual_beds AS individual_beds_27, t19.individual_sofa_bed AS individual_sofa_bed_28, t19.double_sofa_bed AS double_sofa_bed_29, t19.queen_beds AS queen_beds_30, t19.king_beds AS king_beds_31, t19.toilets AS toilets_32, t19.bathroom_with_bathtub AS bathroom_with_bathtub_33, t19.bathroom_with_shower AS bathroom_with_shower_34, t19.berths AS berths_35, t19.area_housing AS area_housing_36, t19.area_housing_unit AS area_housing_unit_37, t19.area_plot AS area_plot_38, t19.area_plot_unit AS area_plot_unit_39, t19.adults_capacity AS adults_capacity_40, t19.accommodation_id AS accommodation_id_41, t42.id AS id_43, t42.tv AS tv_44, t42.garden AS garden_45, t42.garden_furniture AS garden_furniture_46, t42.iron AS iron_47, t42.fire_place AS fire_place_48, t42.barbacue AS barbacue_49, t42.radio AS radio_50, t42.mini_bar AS mini_bar_51, t42.terrace AS terrace_52, t42.fenced_plot AS fenced_plot_53, t42.security_box AS security_box_54, t42.elevator AS elevator_55, t42.dvd AS dvd_56, t42.balcony AS balcony_57, t42.juice_squeezer AS juice_squeezer_58, t42.electric_kettle AS electric_kettle_59, t42.hair_dryer AS hair_dryer_60, t42.children_area AS children_area_61, t42.gym AS gym_62, t42.alarm AS alarm_63, t42.tennis AS tennis_64, t42.squash AS squash_65, t42.paddel AS paddel_66, t42.sauna AS sauna_67, t42.handicapped_facilities AS handicapped_facilities_68, t42.jacuzzi AS jacuzzi_69, t42.smoking_allowed AS smoking_allowed_70, t42.num_of_televisions AS num_of_televisions_71, t42.num_of_fans AS num_of_fans_72, t42.num_of_electronic_mosquito_repeller AS num_of_electronic_mosquito_repeller_73, t42.window_screens AS window_screens_74, t42.acswimming_pool_id AS acswimming_pool_id_75, t42.tv_satellite_id AS tv_satellite_id_76, t42.ackitchen_id AS ackitchen_id_77, t42.accommodation_id AS accommodation_id_78, t79.id AS id_80, t79.name AS name_81, t79.video AS video_82, t79.code AS code_83, t79.accommodation_id AS accommodation_id_84 FROM accommodation t0 LEFT JOIN ac_distribution t19 ON t19.accommodation_id = t0.id LEFT JOIN ac_house_characteristics t42 ON t42.accommodation_id = t0.id LEFT JOIN video t79 ON t79.accommodation_id = t0.id WHERE t0.accommodation_id = ? LIMIT 1"
  "params" => [
    1 => 165371
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.accommodation_id AS accommodation_id_2, t0.user_id AS user_id_3, t0.company AS company_4, t0.company_id AS company_id_5, t0.accommodation_name AS accommodation_name_6, t0.id_gallery AS id_gallery_7, t0.occupational_rule_id AS occupational_rule_id_8, t0.price_modifier_id AS price_modifier_id_9, t0.purpose AS purpose_10, t0.kind_id AS kind_id_11, t0.latitude AS latitude_12, t0.longitude AS longitude_13, t0.accommodation_units AS accommodation_units_14, t0.currency AS currency_15, t0.vat_included AS vat_included_16, t0.touristic_registration_number AS touristic_registration_number_17, t0.location_id AS location_id_18, t19.id AS id_20, t19.people_capacity AS people_capacity_21, t19.minimum_occupation AS minimum_occupation_22, t19.accept_youngsters AS accept_youngsters_23, t19.occupation_without_supplement AS occupation_without_supplement_24, t19.bedrooms AS bedrooms_25, t19.double_beds AS double_beds_26, t19.individual_beds AS individual_beds_27, t19.individual_sofa_bed AS individual_sofa_bed_28, t19.double_sofa_bed AS double_sofa_bed_29, t19.queen_beds AS queen_beds_30, t19.king_beds AS king_beds_31, t19.toilets AS toilets_32, t19.bathroom_with_bathtub AS bathroom_with_bathtub_33, t19.bathroom_with_shower AS bathroom_with_shower_34, t19.berths AS berths_35, t19.area_housing AS area_housing_36, t19.area_housing_unit AS area_housing_unit_37, t19.area_plot AS area_plot_38, t19.area_plot_unit AS area_plot_unit_39, t19.adults_capacity AS adults_capacity_40, t19.accommodation_id AS accommodation_id_41, t42.id AS id_43, t42.tv AS tv_44, t42.garden AS garden_45, t42.garden_furniture AS garden_furniture_46, t42.iron AS iron_47, t42.fire_place AS fire_place_48, t42.barbacue AS barbacue_49, t42.radio AS radio_50, t42.mini_bar AS mini_bar_51, t42.terrace AS terrace_52, t42.fenced_plot AS fenced_plot_53, t42.security_box AS security_box_54, t42.elevator AS elevator_55, t42.dvd AS dvd_56, t42.balcony AS balcony_57, t42.juice_squeezer AS juice_squeezer_58, t42.electric_kettle AS electric_kettle_59, t42.hair_dryer AS hair_dryer_60, t42.children_area AS children_area_61, t42.gym AS gym_62, t42.alarm AS alarm_63, t42.tennis AS tennis_64, t42.squash AS squash_65, t42.paddel AS paddel_66, t42.sauna AS sauna_67, t42.handicapped_facilities AS handicapped_facilities_68, t42.jacuzzi AS jacuzzi_69, t42.smoking_allowed AS smoking_allowed_70, t42.num_of_televisions AS num_of_televisions_71, t42.num_of_fans AS num_of_fans_72, t42.num_of_electronic_mosquito_repeller AS num_of_electronic_mosquito_repeller_73, t42.window_screens AS window_screens_74, t42.acswimming_pool_id AS acswimming_pool_id_75, t42.tv_satellite_id AS tv_satellite_id_76, t42.ackitchen_id AS ackitchen_id_77, t42.accommodation_id AS accommodation_id_78, t79.id AS id_80, t79.name AS name_81, t79.video AS video_82, t79.code AS code_83, t79.accommodation_id AS accommodation_id_84 FROM accommodation t0 LEFT JOIN ac_distribution t19 ON t19.accommodation_id = t0.id LEFT JOIN ac_house_characteristics t42 ON t42.accommodation_id = t0.id LEFT JOIN video t79 ON t79.accommodation_id = t0.id WHERE t0.accommodation_id = ? LIMIT 1"
  "params" => [
    1 => 165099
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT r0_.id AS id_0, r0_.capacity AS capacity_1, r0_.start_date AS start_date_2, r0_.end_date AS end_date_3, r0_.type AS type_4, r0_.price AS price_5, r0_.applicable_from_number_people AS applicable_from_number_people_6, r0_.supplement AS supplement_7, r0_.accommodation_id AS accommodation_id_8 FROM rate r0_ WHERE r0_.accommodation_id = ? AND (? BETWEEN r0_.start_date AND r0_.end_date) ORDER BY r0_.start_date ASC LIMIT 1"
  "params" => [
    1 => 255
    2 => "2026-05-06 14:29:58"
  ]
  "types" => [
    1 => 1
    2 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.code AS code_2, t0.locale AS locale_3, t0.text AS text_4 FROM kind t0 WHERE t0.code = ? AND t0.locale = ? LIMIT 1"
  "params" => [
    1 => 2
    2 => "en"
  ]
  "types" => [
    1 => 1
    2 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.people_capacity AS people_capacity_2, t0.minimum_occupation AS minimum_occupation_3, t0.accept_youngsters AS accept_youngsters_4, t0.occupation_without_supplement AS occupation_without_supplement_5, t0.bedrooms AS bedrooms_6, t0.double_beds AS double_beds_7, t0.individual_beds AS individual_beds_8, t0.individual_sofa_bed AS individual_sofa_bed_9, t0.double_sofa_bed AS double_sofa_bed_10, t0.queen_beds AS queen_beds_11, t0.king_beds AS king_beds_12, t0.toilets AS toilets_13, t0.bathroom_with_bathtub AS bathroom_with_bathtub_14, t0.bathroom_with_shower AS bathroom_with_shower_15, t0.berths AS berths_16, t0.area_housing AS area_housing_17, t0.area_housing_unit AS area_housing_unit_18, t0.area_plot AS area_plot_19, t0.area_plot_unit AS area_plot_unit_20, t0.adults_capacity AS adults_capacity_21, t0.accommodation_id AS accommodation_id_22 FROM ac_distribution t0 WHERE t0.accommodation_id = ? LIMIT 1"
  "params" => [
    1 => 255
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.type AS type_4, t0.timestamp AS timestamp_5, t0.accommodation_id AS accommodation_id_6 FROM pictures t0 WHERE t0.accommodation_id = ?"
  "params" => [
    1 => 255
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.is_airport AS is_airport_3, t0.is_active AS is_active_4, t0.is_online AS is_online_5, t0.is_deleted AS is_deleted_6, t0.is_transfer AS is_transfer_7, t0.traveltime AS traveltime_8, t0.gps AS gps_9, t0.code AS code_10, t0.transferarea_id AS transferarea_id_11 FROM location t0 WHERE t0.id = ?"
  "params" => [
    1 => 5
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.accommodation_id AS accommodation_id_2, t0.user_id AS user_id_3, t0.company AS company_4, t0.company_id AS company_id_5, t0.accommodation_name AS accommodation_name_6, t0.id_gallery AS id_gallery_7, t0.occupational_rule_id AS occupational_rule_id_8, t0.price_modifier_id AS price_modifier_id_9, t0.purpose AS purpose_10, t0.kind_id AS kind_id_11, t0.latitude AS latitude_12, t0.longitude AS longitude_13, t0.accommodation_units AS accommodation_units_14, t0.currency AS currency_15, t0.vat_included AS vat_included_16, t0.touristic_registration_number AS touristic_registration_number_17, t0.location_id AS location_id_18, t19.id AS id_20, t19.people_capacity AS people_capacity_21, t19.minimum_occupation AS minimum_occupation_22, t19.accept_youngsters AS accept_youngsters_23, t19.occupation_without_supplement AS occupation_without_supplement_24, t19.bedrooms AS bedrooms_25, t19.double_beds AS double_beds_26, t19.individual_beds AS individual_beds_27, t19.individual_sofa_bed AS individual_sofa_bed_28, t19.double_sofa_bed AS double_sofa_bed_29, t19.queen_beds AS queen_beds_30, t19.king_beds AS king_beds_31, t19.toilets AS toilets_32, t19.bathroom_with_bathtub AS bathroom_with_bathtub_33, t19.bathroom_with_shower AS bathroom_with_shower_34, t19.berths AS berths_35, t19.area_housing AS area_housing_36, t19.area_housing_unit AS area_housing_unit_37, t19.area_plot AS area_plot_38, t19.area_plot_unit AS area_plot_unit_39, t19.adults_capacity AS adults_capacity_40, t19.accommodation_id AS accommodation_id_41, t42.id AS id_43, t42.tv AS tv_44, t42.garden AS garden_45, t42.garden_furniture AS garden_furniture_46, t42.iron AS iron_47, t42.fire_place AS fire_place_48, t42.barbacue AS barbacue_49, t42.radio AS radio_50, t42.mini_bar AS mini_bar_51, t42.terrace AS terrace_52, t42.fenced_plot AS fenced_plot_53, t42.security_box AS security_box_54, t42.elevator AS elevator_55, t42.dvd AS dvd_56, t42.balcony AS balcony_57, t42.juice_squeezer AS juice_squeezer_58, t42.electric_kettle AS electric_kettle_59, t42.hair_dryer AS hair_dryer_60, t42.children_area AS children_area_61, t42.gym AS gym_62, t42.alarm AS alarm_63, t42.tennis AS tennis_64, t42.squash AS squash_65, t42.paddel AS paddel_66, t42.sauna AS sauna_67, t42.handicapped_facilities AS handicapped_facilities_68, t42.jacuzzi AS jacuzzi_69, t42.smoking_allowed AS smoking_allowed_70, t42.num_of_televisions AS num_of_televisions_71, t42.num_of_fans AS num_of_fans_72, t42.num_of_electronic_mosquito_repeller AS num_of_electronic_mosquito_repeller_73, t42.window_screens AS window_screens_74, t42.acswimming_pool_id AS acswimming_pool_id_75, t42.tv_satellite_id AS tv_satellite_id_76, t42.ackitchen_id AS ackitchen_id_77, t42.accommodation_id AS accommodation_id_78, t79.id AS id_80, t79.name AS name_81, t79.video AS video_82, t79.code AS code_83, t79.accommodation_id AS accommodation_id_84 FROM accommodation t0 LEFT JOIN ac_distribution t19 ON t19.accommodation_id = t0.id LEFT JOIN ac_house_characteristics t42 ON t42.accommodation_id = t0.id LEFT JOIN video t79 ON t79.accommodation_id = t0.id WHERE t0.accommodation_id = ? LIMIT 1"
  "params" => [
    1 => 164762
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.accommodation_id AS accommodation_id_2, t0.user_id AS user_id_3, t0.company AS company_4, t0.company_id AS company_id_5, t0.accommodation_name AS accommodation_name_6, t0.id_gallery AS id_gallery_7, t0.occupational_rule_id AS occupational_rule_id_8, t0.price_modifier_id AS price_modifier_id_9, t0.purpose AS purpose_10, t0.kind_id AS kind_id_11, t0.latitude AS latitude_12, t0.longitude AS longitude_13, t0.accommodation_units AS accommodation_units_14, t0.currency AS currency_15, t0.vat_included AS vat_included_16, t0.touristic_registration_number AS touristic_registration_number_17, t0.location_id AS location_id_18, t19.id AS id_20, t19.people_capacity AS people_capacity_21, t19.minimum_occupation AS minimum_occupation_22, t19.accept_youngsters AS accept_youngsters_23, t19.occupation_without_supplement AS occupation_without_supplement_24, t19.bedrooms AS bedrooms_25, t19.double_beds AS double_beds_26, t19.individual_beds AS individual_beds_27, t19.individual_sofa_bed AS individual_sofa_bed_28, t19.double_sofa_bed AS double_sofa_bed_29, t19.queen_beds AS queen_beds_30, t19.king_beds AS king_beds_31, t19.toilets AS toilets_32, t19.bathroom_with_bathtub AS bathroom_with_bathtub_33, t19.bathroom_with_shower AS bathroom_with_shower_34, t19.berths AS berths_35, t19.area_housing AS area_housing_36, t19.area_housing_unit AS area_housing_unit_37, t19.area_plot AS area_plot_38, t19.area_plot_unit AS area_plot_unit_39, t19.adults_capacity AS adults_capacity_40, t19.accommodation_id AS accommodation_id_41, t42.id AS id_43, t42.tv AS tv_44, t42.garden AS garden_45, t42.garden_furniture AS garden_furniture_46, t42.iron AS iron_47, t42.fire_place AS fire_place_48, t42.barbacue AS barbacue_49, t42.radio AS radio_50, t42.mini_bar AS mini_bar_51, t42.terrace AS terrace_52, t42.fenced_plot AS fenced_plot_53, t42.security_box AS security_box_54, t42.elevator AS elevator_55, t42.dvd AS dvd_56, t42.balcony AS balcony_57, t42.juice_squeezer AS juice_squeezer_58, t42.electric_kettle AS electric_kettle_59, t42.hair_dryer AS hair_dryer_60, t42.children_area AS children_area_61, t42.gym AS gym_62, t42.alarm AS alarm_63, t42.tennis AS tennis_64, t42.squash AS squash_65, t42.paddel AS paddel_66, t42.sauna AS sauna_67, t42.handicapped_facilities AS handicapped_facilities_68, t42.jacuzzi AS jacuzzi_69, t42.smoking_allowed AS smoking_allowed_70, t42.num_of_televisions AS num_of_televisions_71, t42.num_of_fans AS num_of_fans_72, t42.num_of_electronic_mosquito_repeller AS num_of_electronic_mosquito_repeller_73, t42.window_screens AS window_screens_74, t42.acswimming_pool_id AS acswimming_pool_id_75, t42.tv_satellite_id AS tv_satellite_id_76, t42.ackitchen_id AS ackitchen_id_77, t42.accommodation_id AS accommodation_id_78, t79.id AS id_80, t79.name AS name_81, t79.video AS video_82, t79.code AS code_83, t79.accommodation_id AS accommodation_id_84 FROM accommodation t0 LEFT JOIN ac_distribution t19 ON t19.accommodation_id = t0.id LEFT JOIN ac_house_characteristics t42 ON t42.accommodation_id = t0.id LEFT JOIN video t79 ON t79.accommodation_id = t0.id WHERE t0.accommodation_id = ? LIMIT 1"
  "params" => [
    1 => 301524
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT r0_.id AS id_0, r0_.capacity AS capacity_1, r0_.start_date AS start_date_2, r0_.end_date AS end_date_3, r0_.type AS type_4, r0_.price AS price_5, r0_.applicable_from_number_people AS applicable_from_number_people_6, r0_.supplement AS supplement_7, r0_.accommodation_id AS accommodation_id_8 FROM rate r0_ WHERE r0_.accommodation_id = ? AND (? BETWEEN r0_.start_date AND r0_.end_date) ORDER BY r0_.start_date ASC LIMIT 1"
  "params" => [
    1 => 28
    2 => "2026-05-06 14:29:58"
  ]
  "types" => [
    1 => 1
    2 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.code AS code_2, t0.locale AS locale_3, t0.text AS text_4 FROM kind t0 WHERE t0.code = ? AND t0.locale = ? LIMIT 1"
  "params" => [
    1 => 1
    2 => "en"
  ]
  "types" => [
    1 => 1
    2 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.people_capacity AS people_capacity_2, t0.minimum_occupation AS minimum_occupation_3, t0.accept_youngsters AS accept_youngsters_4, t0.occupation_without_supplement AS occupation_without_supplement_5, t0.bedrooms AS bedrooms_6, t0.double_beds AS double_beds_7, t0.individual_beds AS individual_beds_8, t0.individual_sofa_bed AS individual_sofa_bed_9, t0.double_sofa_bed AS double_sofa_bed_10, t0.queen_beds AS queen_beds_11, t0.king_beds AS king_beds_12, t0.toilets AS toilets_13, t0.bathroom_with_bathtub AS bathroom_with_bathtub_14, t0.bathroom_with_shower AS bathroom_with_shower_15, t0.berths AS berths_16, t0.area_housing AS area_housing_17, t0.area_housing_unit AS area_housing_unit_18, t0.area_plot AS area_plot_19, t0.area_plot_unit AS area_plot_unit_20, t0.adults_capacity AS adults_capacity_21, t0.accommodation_id AS accommodation_id_22 FROM ac_distribution t0 WHERE t0.accommodation_id = ? LIMIT 1"
  "params" => [
    1 => 28
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.accommodation_id AS accommodation_id_2, t0.user_id AS user_id_3, t0.company AS company_4, t0.company_id AS company_id_5, t0.accommodation_name AS accommodation_name_6, t0.id_gallery AS id_gallery_7, t0.occupational_rule_id AS occupational_rule_id_8, t0.price_modifier_id AS price_modifier_id_9, t0.purpose AS purpose_10, t0.kind_id AS kind_id_11, t0.latitude AS latitude_12, t0.longitude AS longitude_13, t0.accommodation_units AS accommodation_units_14, t0.currency AS currency_15, t0.vat_included AS vat_included_16, t0.touristic_registration_number AS touristic_registration_number_17, t0.location_id AS location_id_18, t19.id AS id_20, t19.people_capacity AS people_capacity_21, t19.minimum_occupation AS minimum_occupation_22, t19.accept_youngsters AS accept_youngsters_23, t19.occupation_without_supplement AS occupation_without_supplement_24, t19.bedrooms AS bedrooms_25, t19.double_beds AS double_beds_26, t19.individual_beds AS individual_beds_27, t19.individual_sofa_bed AS individual_sofa_bed_28, t19.double_sofa_bed AS double_sofa_bed_29, t19.queen_beds AS queen_beds_30, t19.king_beds AS king_beds_31, t19.toilets AS toilets_32, t19.bathroom_with_bathtub AS bathroom_with_bathtub_33, t19.bathroom_with_shower AS bathroom_with_shower_34, t19.berths AS berths_35, t19.area_housing AS area_housing_36, t19.area_housing_unit AS area_housing_unit_37, t19.area_plot AS area_plot_38, t19.area_plot_unit AS area_plot_unit_39, t19.adults_capacity AS adults_capacity_40, t19.accommodation_id AS accommodation_id_41, t42.id AS id_43, t42.tv AS tv_44, t42.garden AS garden_45, t42.garden_furniture AS garden_furniture_46, t42.iron AS iron_47, t42.fire_place AS fire_place_48, t42.barbacue AS barbacue_49, t42.radio AS radio_50, t42.mini_bar AS mini_bar_51, t42.terrace AS terrace_52, t42.fenced_plot AS fenced_plot_53, t42.security_box AS security_box_54, t42.elevator AS elevator_55, t42.dvd AS dvd_56, t42.balcony AS balcony_57, t42.juice_squeezer AS juice_squeezer_58, t42.electric_kettle AS electric_kettle_59, t42.hair_dryer AS hair_dryer_60, t42.children_area AS children_area_61, t42.gym AS gym_62, t42.alarm AS alarm_63, t42.tennis AS tennis_64, t42.squash AS squash_65, t42.paddel AS paddel_66, t42.sauna AS sauna_67, t42.handicapped_facilities AS handicapped_facilities_68, t42.jacuzzi AS jacuzzi_69, t42.smoking_allowed AS smoking_allowed_70, t42.num_of_televisions AS num_of_televisions_71, t42.num_of_fans AS num_of_fans_72, t42.num_of_electronic_mosquito_repeller AS num_of_electronic_mosquito_repeller_73, t42.window_screens AS window_screens_74, t42.acswimming_pool_id AS acswimming_pool_id_75, t42.tv_satellite_id AS tv_satellite_id_76, t42.ackitchen_id AS ackitchen_id_77, t42.accommodation_id AS accommodation_id_78, t79.id AS id_80, t79.name AS name_81, t79.video AS video_82, t79.code AS code_83, t79.accommodation_id AS accommodation_id_84 FROM accommodation t0 LEFT JOIN ac_distribution t19 ON t19.accommodation_id = t0.id LEFT JOIN ac_house_characteristics t42 ON t42.accommodation_id = t0.id LEFT JOIN video t79 ON t79.accommodation_id = t0.id WHERE t0.accommodation_id = ? LIMIT 1"
  "params" => [
    1 => 165031
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT r0_.id AS id_0, r0_.capacity AS capacity_1, r0_.start_date AS start_date_2, r0_.end_date AS end_date_3, r0_.type AS type_4, r0_.price AS price_5, r0_.applicable_from_number_people AS applicable_from_number_people_6, r0_.supplement AS supplement_7, r0_.accommodation_id AS accommodation_id_8 FROM rate r0_ WHERE r0_.accommodation_id = ? AND (? BETWEEN r0_.start_date AND r0_.end_date) ORDER BY r0_.start_date ASC LIMIT 1"
  "params" => [
    1 => 4
    2 => "2026-05-06 14:29:58"
  ]
  "types" => [
    1 => 1
    2 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.code AS code_2, t0.locale AS locale_3, t0.text AS text_4 FROM kind t0 WHERE t0.code = ? AND t0.locale = ? LIMIT 1"
  "params" => [
    1 => 2
    2 => "en"
  ]
  "types" => [
    1 => 1
    2 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.people_capacity AS people_capacity_2, t0.minimum_occupation AS minimum_occupation_3, t0.accept_youngsters AS accept_youngsters_4, t0.occupation_without_supplement AS occupation_without_supplement_5, t0.bedrooms AS bedrooms_6, t0.double_beds AS double_beds_7, t0.individual_beds AS individual_beds_8, t0.individual_sofa_bed AS individual_sofa_bed_9, t0.double_sofa_bed AS double_sofa_bed_10, t0.queen_beds AS queen_beds_11, t0.king_beds AS king_beds_12, t0.toilets AS toilets_13, t0.bathroom_with_bathtub AS bathroom_with_bathtub_14, t0.bathroom_with_shower AS bathroom_with_shower_15, t0.berths AS berths_16, t0.area_housing AS area_housing_17, t0.area_housing_unit AS area_housing_unit_18, t0.area_plot AS area_plot_19, t0.area_plot_unit AS area_plot_unit_20, t0.adults_capacity AS adults_capacity_21, t0.accommodation_id AS accommodation_id_22 FROM ac_distribution t0 WHERE t0.accommodation_id = ? LIMIT 1"
  "params" => [
    1 => 4
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.accommodation_id AS accommodation_id_2, t0.user_id AS user_id_3, t0.company AS company_4, t0.company_id AS company_id_5, t0.accommodation_name AS accommodation_name_6, t0.id_gallery AS id_gallery_7, t0.occupational_rule_id AS occupational_rule_id_8, t0.price_modifier_id AS price_modifier_id_9, t0.purpose AS purpose_10, t0.kind_id AS kind_id_11, t0.latitude AS latitude_12, t0.longitude AS longitude_13, t0.accommodation_units AS accommodation_units_14, t0.currency AS currency_15, t0.vat_included AS vat_included_16, t0.touristic_registration_number AS touristic_registration_number_17, t0.location_id AS location_id_18, t19.id AS id_20, t19.people_capacity AS people_capacity_21, t19.minimum_occupation AS minimum_occupation_22, t19.accept_youngsters AS accept_youngsters_23, t19.occupation_without_supplement AS occupation_without_supplement_24, t19.bedrooms AS bedrooms_25, t19.double_beds AS double_beds_26, t19.individual_beds AS individual_beds_27, t19.individual_sofa_bed AS individual_sofa_bed_28, t19.double_sofa_bed AS double_sofa_bed_29, t19.queen_beds AS queen_beds_30, t19.king_beds AS king_beds_31, t19.toilets AS toilets_32, t19.bathroom_with_bathtub AS bathroom_with_bathtub_33, t19.bathroom_with_shower AS bathroom_with_shower_34, t19.berths AS berths_35, t19.area_housing AS area_housing_36, t19.area_housing_unit AS area_housing_unit_37, t19.area_plot AS area_plot_38, t19.area_plot_unit AS area_plot_unit_39, t19.adults_capacity AS adults_capacity_40, t19.accommodation_id AS accommodation_id_41, t42.id AS id_43, t42.tv AS tv_44, t42.garden AS garden_45, t42.garden_furniture AS garden_furniture_46, t42.iron AS iron_47, t42.fire_place AS fire_place_48, t42.barbacue AS barbacue_49, t42.radio AS radio_50, t42.mini_bar AS mini_bar_51, t42.terrace AS terrace_52, t42.fenced_plot AS fenced_plot_53, t42.security_box AS security_box_54, t42.elevator AS elevator_55, t42.dvd AS dvd_56, t42.balcony AS balcony_57, t42.juice_squeezer AS juice_squeezer_58, t42.electric_kettle AS electric_kettle_59, t42.hair_dryer AS hair_dryer_60, t42.children_area AS children_area_61, t42.gym AS gym_62, t42.alarm AS alarm_63, t42.tennis AS tennis_64, t42.squash AS squash_65, t42.paddel AS paddel_66, t42.sauna AS sauna_67, t42.handicapped_facilities AS handicapped_facilities_68, t42.jacuzzi AS jacuzzi_69, t42.smoking_allowed AS smoking_allowed_70, t42.num_of_televisions AS num_of_televisions_71, t42.num_of_fans AS num_of_fans_72, t42.num_of_electronic_mosquito_repeller AS num_of_electronic_mosquito_repeller_73, t42.window_screens AS window_screens_74, t42.acswimming_pool_id AS acswimming_pool_id_75, t42.tv_satellite_id AS tv_satellite_id_76, t42.ackitchen_id AS ackitchen_id_77, t42.accommodation_id AS accommodation_id_78, t79.id AS id_80, t79.name AS name_81, t79.video AS video_82, t79.code AS code_83, t79.accommodation_id AS accommodation_id_84 FROM accommodation t0 LEFT JOIN ac_distribution t19 ON t19.accommodation_id = t0.id LEFT JOIN ac_house_characteristics t42 ON t42.accommodation_id = t0.id LEFT JOIN video t79 ON t79.accommodation_id = t0.id WHERE t0.accommodation_id = ? LIMIT 1"
  "params" => [
    1 => 164759
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT r0_.id AS id_0, r0_.capacity AS capacity_1, r0_.start_date AS start_date_2, r0_.end_date AS end_date_3, r0_.type AS type_4, r0_.price AS price_5, r0_.applicable_from_number_people AS applicable_from_number_people_6, r0_.supplement AS supplement_7, r0_.accommodation_id AS accommodation_id_8 FROM rate r0_ WHERE r0_.accommodation_id = ? AND (? BETWEEN r0_.start_date AND r0_.end_date) ORDER BY r0_.start_date ASC LIMIT 1"
  "params" => [
    1 => 2
    2 => "2026-05-06 14:29:58"
  ]
  "types" => [
    1 => 1
    2 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.code AS code_2, t0.locale AS locale_3, t0.text AS text_4 FROM kind t0 WHERE t0.code = ? AND t0.locale = ? LIMIT 1"
  "params" => [
    1 => 2
    2 => "en"
  ]
  "types" => [
    1 => 1
    2 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.people_capacity AS people_capacity_2, t0.minimum_occupation AS minimum_occupation_3, t0.accept_youngsters AS accept_youngsters_4, t0.occupation_without_supplement AS occupation_without_supplement_5, t0.bedrooms AS bedrooms_6, t0.double_beds AS double_beds_7, t0.individual_beds AS individual_beds_8, t0.individual_sofa_bed AS individual_sofa_bed_9, t0.double_sofa_bed AS double_sofa_bed_10, t0.queen_beds AS queen_beds_11, t0.king_beds AS king_beds_12, t0.toilets AS toilets_13, t0.bathroom_with_bathtub AS bathroom_with_bathtub_14, t0.bathroom_with_shower AS bathroom_with_shower_15, t0.berths AS berths_16, t0.area_housing AS area_housing_17, t0.area_housing_unit AS area_housing_unit_18, t0.area_plot AS area_plot_19, t0.area_plot_unit AS area_plot_unit_20, t0.adults_capacity AS adults_capacity_21, t0.accommodation_id AS accommodation_id_22 FROM ac_distribution t0 WHERE t0.accommodation_id = ? LIMIT 1"
  "params" => [
    1 => 2
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.is_airport AS is_airport_3, t0.is_active AS is_active_4, t0.is_online AS is_online_5, t0.is_deleted AS is_deleted_6, t0.is_transfer AS is_transfer_7, t0.traveltime AS traveltime_8, t0.gps AS gps_9, t0.code AS code_10, t0.transferarea_id AS transferarea_id_11 FROM location t0 WHERE t0.id = ?"
  "params" => [
    1 => 2
  ]
  "types" => [
    1 => 1
  ]
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\AssetMapper\AssetMapperDevServerSubscriber::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\Security\Csrf\SameOriginCsrfTokenManager::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\Security\Http\Firewall\ContextListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ResponseListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\WebLink\EventListener\AddLinkHeaderListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\CacheAttributeListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ProfilerListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ErrorListener::removeCspHeader"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Bundle\WebProfilerBundle\EventListener\WebDebugToolbarListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\DisallowRobotsIndexingListener::onResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelResponse"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelFinishRequest"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelFinishRequest"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelFinishRequest"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelFinishRequest"
]