Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.slug AS slug_3,
  t0.value AS value_4
FROM
  cal_option t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.label AS label_2, t0.slug AS slug_3, t0.value AS value_4 FROM cal_option t0 WHERE t0.slug = 'homepage_version' LIMIT 1;

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.virtual_tour AS virtual_tour_2,
  c0_.pet_friendly AS pet_friendly_3,
  c0_.girls_only AS girls_only_4,
  c0_.surface AS surface_5,
  c0_.type AS type_6,
  c0_.construction_year AS construction_year_7,
  c0_.total_bedrooms AS total_bedrooms_8,
  c0_.total_bathrooms AS total_bathrooms_9,
  c0_.total_kitchens AS total_kitchens_10,
  c0_.total_toilets AS total_toilets_11,
  c0_.garden AS garden_12,
  c0_.created_at AS created_at_13,
  c0_.updated_at AS updated_at_14,
  c0_.disabled AS disabled_15,
  c0_.owner_type AS owner_type_16,
  c0_.square_meter_price AS square_meter_price_17,
  c0_.majored_square_meter_price AS majored_square_meter_price_18,
  c1_.id AS id_19,
  c1_.auto_lat_lng AS auto_lat_lng_20,
  c1_.alias AS alias_21,
  c1_.name AS name_22,
  c1_.address AS address_23,
  c1_.zipcode AS zipcode_24,
  c1_.city AS city_25,
  c1_.country AS country_26,
  c1_.informations AS informations_27,
  c1_.latitude AS latitude_28,
  c1_.longitude AS longitude_29,
  c2_.id AS id_30,
  c2_.name AS name_31,
  c2_.private AS private_32,
  c2_.created_at AS created_at_33,
  c2_.position AS position_34,
  c3_.id AS id_35,
  c3_.fr AS fr_36,
  c3_.en AS en_37,
  c3_.es AS es_38,
  c0_.address_id AS address_id_39,
  c0_.description_id AS description_id_40,
  c0_.cover_id AS cover_id_41,
  c0_.plan_id AS plan_id_42,
  c0_.access_id AS access_id_43,
  c0_.district_id AS district_id_44,
  c0_.owner_id AS owner_id_45,
  c0_.owner_info_id AS owner_info_id_46,
  c0_.info_id AS info_id_47,
  c0_.cleaning_recurrence_id AS cleaning_recurrence_id_48,
  c2_.accommodation_id AS accommodation_id_49,
  c2_.room_id AS room_id_50
FROM
  cal_accommodation c0_
  LEFT JOIN cal_address c1_ ON c0_.address_id = c1_.id
  LEFT JOIN cal_accommodation_image c2_ ON c0_.cover_id = c2_.id
  LEFT JOIN cal_translation c3_ ON c0_.access_id = c3_.id
  LEFT JOIN cal_accommodation_room c4_ ON c0_.id = c4_.accommodation_id
WHERE
  c0_.disabled = 0
  OR c0_.disabled IS NULL
GROUP BY
  c0_.id
LIMIT
  9

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.virtual_tour AS virtual_tour_2, c0_.pet_friendly AS pet_friendly_3, c0_.girls_only AS girls_only_4, c0_.surface AS surface_5, c0_.type AS type_6, c0_.construction_year AS construction_year_7, c0_.total_bedrooms AS total_bedrooms_8, c0_.total_bathrooms AS total_bathrooms_9, c0_.total_kitchens AS total_kitchens_10, c0_.total_toilets AS total_toilets_11, c0_.garden AS garden_12, c0_.created_at AS created_at_13, c0_.updated_at AS updated_at_14, c0_.disabled AS disabled_15, c0_.owner_type AS owner_type_16, c0_.square_meter_price AS square_meter_price_17, c0_.majored_square_meter_price AS majored_square_meter_price_18, c1_.id AS id_19, c1_.auto_lat_lng AS auto_lat_lng_20, c1_.alias AS alias_21, c1_.name AS name_22, c1_.address AS address_23, c1_.zipcode AS zipcode_24, c1_.city AS city_25, c1_.country AS country_26, c1_.informations AS informations_27, c1_.latitude AS latitude_28, c1_.longitude AS longitude_29, c2_.id AS id_30, c2_.name AS name_31, c2_.private AS private_32, c2_.created_at AS created_at_33, c2_.position AS position_34, c3_.id AS id_35, c3_.fr AS fr_36, c3_.en AS en_37, c3_.es AS es_38, c0_.address_id AS address_id_39, c0_.description_id AS description_id_40, c0_.cover_id AS cover_id_41, c0_.plan_id AS plan_id_42, c0_.access_id AS access_id_43, c0_.district_id AS district_id_44, c0_.owner_id AS owner_id_45, c0_.owner_info_id AS owner_info_id_46, c0_.info_id AS info_id_47, c0_.cleaning_recurrence_id AS cleaning_recurrence_id_48, c2_.accommodation_id AS accommodation_id_49, c2_.room_id AS room_id_50 FROM cal_accommodation c0_ LEFT JOIN cal_address c1_ ON c0_.address_id = c1_.id LEFT JOIN cal_accommodation_image c2_ ON c0_.cover_id = c2_.id LEFT JOIN cal_translation c3_ ON c0_.access_id = c3_.id LEFT JOIN cal_accommodation_room c4_ ON c0_.id = c4_.accommodation_id WHERE c0_.disabled = 0 OR c0_.disabled IS NULL GROUP BY c0_.id LIMIT 9;

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.accommodation_id AS accommodation_id_4
FROM
  cal_workflow_project t0
WHERE
  t0.accommodation_id = ?

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.accommodation_id AS accommodation_id_4 FROM cal_workflow_project t0 WHERE t0.accommodation_id = 18;

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.accommodation_id AS accommodation_id_4
FROM
  cal_workflow_project t0
WHERE
  t0.accommodation_id = ?

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.accommodation_id AS accommodation_id_4 FROM cal_workflow_project t0 WHERE t0.accommodation_id = 19;

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.accommodation_id AS accommodation_id_4
FROM
  cal_workflow_project t0
WHERE
  t0.accommodation_id = ?

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.accommodation_id AS accommodation_id_4 FROM cal_workflow_project t0 WHERE t0.accommodation_id = 20;

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.accommodation_id AS accommodation_id_4
FROM
  cal_workflow_project t0
WHERE
  t0.accommodation_id = ?

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.accommodation_id AS accommodation_id_4 FROM cal_workflow_project t0 WHERE t0.accommodation_id = 21;

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.accommodation_id AS accommodation_id_4
FROM
  cal_workflow_project t0
WHERE
  t0.accommodation_id = ?

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.accommodation_id AS accommodation_id_4 FROM cal_workflow_project t0 WHERE t0.accommodation_id = 22;

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.accommodation_id AS accommodation_id_4
FROM
  cal_workflow_project t0
WHERE
  t0.accommodation_id = ?

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.accommodation_id AS accommodation_id_4 FROM cal_workflow_project t0 WHERE t0.accommodation_id = 23;

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.accommodation_id AS accommodation_id_4
FROM
  cal_workflow_project t0
WHERE
  t0.accommodation_id = ?

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.accommodation_id AS accommodation_id_4 FROM cal_workflow_project t0 WHERE t0.accommodation_id = 24;

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.accommodation_id AS accommodation_id_4
FROM
  cal_workflow_project t0
WHERE
  t0.accommodation_id = ?

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.accommodation_id AS accommodation_id_4 FROM cal_workflow_project t0 WHERE t0.accommodation_id = 25;

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.accommodation_id AS accommodation_id_4
FROM
  cal_workflow_project t0
WHERE
  t0.accommodation_id = ?

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.accommodation_id AS accommodation_id_4 FROM cal_workflow_project t0 WHERE t0.accommodation_id = 26;

SELECT
  COUNT(DISTINCT c0_.id) AS sclr_0
FROM
  cal_accommodation c0_
  LEFT JOIN cal_address c1_ ON c0_.address_id = c1_.id
  LEFT JOIN cal_accommodation_image c2_ ON c0_.cover_id = c2_.id
  LEFT JOIN cal_translation c3_ ON c0_.access_id = c3_.id
  LEFT JOIN cal_accommodation_room c4_ ON c0_.id = c4_.accommodation_id
  LEFT JOIN cal_accommodations_equipments c6_ ON c0_.id = c6_.accommodation_id
  LEFT JOIN cal_property_list_item c5_ ON c5_.id = c6_.property_list_item_id
WHERE
  c0_.disabled = 0
  OR c0_.disabled IS NULL

SELECT COUNT(DISTINCT c0_.id) AS sclr_0 FROM cal_accommodation c0_ LEFT JOIN cal_address c1_ ON c0_.address_id = c1_.id LEFT JOIN cal_accommodation_image c2_ ON c0_.cover_id = c2_.id LEFT JOIN cal_translation c3_ ON c0_.access_id = c3_.id LEFT JOIN cal_accommodation_room c4_ ON c0_.id = c4_.accommodation_id LEFT JOIN cal_accommodations_equipments c6_ ON c0_.id = c6_.accommodation_id LEFT JOIN cal_property_list_item c5_ ON c5_.id = c6_.property_list_item_id WHERE c0_.disabled = 0 OR c0_.disabled IS NULL;

SELECT
  t0.id AS id_1,
  t0.surface AS surface_2,
  t0.private_bathroom AS private_bathroom_3,
  t0.private_toilet AS private_toilet_4,
  t0.private_kitchen AS private_kitchen_5,
  t0.max_housing_assistance AS max_housing_assistance_6,
  t0.rent AS rent_7,
  t0.additional_rent AS additional_rent_8,
  t0.additional_rent_details AS additional_rent_details_9,
  t0.entrance_fees AS entrance_fees_10,
  t0.charges_fees AS charges_fees_11,
  t0.services_fees AS services_fees_12,
  t0.cleaning_fees AS cleaning_fees_13,
  t0.created_at AS created_at_14,
  t0.updated_at AS updated_at_15,
  t0.disabled AS disabled_16,
  t0.ongoing_booking AS ongoing_booking_17,
  t0.accommodation_id AS accommodation_id_18,
  t0.name_id AS name_id_19,
  t0.description_id AS description_id_20,
  t0.occupancy_id AS occupancy_id_21,
  t0.stats_id AS stats_id_22
FROM
  cal_accommodation_room t0
WHERE
  t0.accommodation_id = ?

SELECT t0.id AS id_1, t0.surface AS surface_2, t0.private_bathroom AS private_bathroom_3, t0.private_toilet AS private_toilet_4, t0.private_kitchen AS private_kitchen_5, t0.max_housing_assistance AS max_housing_assistance_6, t0.rent AS rent_7, t0.additional_rent AS additional_rent_8, t0.additional_rent_details AS additional_rent_details_9, t0.entrance_fees AS entrance_fees_10, t0.charges_fees AS charges_fees_11, t0.services_fees AS services_fees_12, t0.cleaning_fees AS cleaning_fees_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.disabled AS disabled_16, t0.ongoing_booking AS ongoing_booking_17, t0.accommodation_id AS accommodation_id_18, t0.name_id AS name_id_19, t0.description_id AS description_id_20, t0.occupancy_id AS occupancy_id_21, t0.stats_id AS stats_id_22 FROM cal_accommodation_room t0 WHERE t0.accommodation_id = 18;

SELECT
  t0.id AS id_1,
  t0.surface AS surface_2,
  t0.private_bathroom AS private_bathroom_3,
  t0.private_toilet AS private_toilet_4,
  t0.private_kitchen AS private_kitchen_5,
  t0.max_housing_assistance AS max_housing_assistance_6,
  t0.rent AS rent_7,
  t0.additional_rent AS additional_rent_8,
  t0.additional_rent_details AS additional_rent_details_9,
  t0.entrance_fees AS entrance_fees_10,
  t0.charges_fees AS charges_fees_11,
  t0.services_fees AS services_fees_12,
  t0.cleaning_fees AS cleaning_fees_13,
  t0.created_at AS created_at_14,
  t0.updated_at AS updated_at_15,
  t0.disabled AS disabled_16,
  t0.ongoing_booking AS ongoing_booking_17,
  t0.accommodation_id AS accommodation_id_18,
  t0.name_id AS name_id_19,
  t0.description_id AS description_id_20,
  t0.occupancy_id AS occupancy_id_21,
  t0.stats_id AS stats_id_22
FROM
  cal_accommodation_room t0
WHERE
  t0.accommodation_id = ?

SELECT t0.id AS id_1, t0.surface AS surface_2, t0.private_bathroom AS private_bathroom_3, t0.private_toilet AS private_toilet_4, t0.private_kitchen AS private_kitchen_5, t0.max_housing_assistance AS max_housing_assistance_6, t0.rent AS rent_7, t0.additional_rent AS additional_rent_8, t0.additional_rent_details AS additional_rent_details_9, t0.entrance_fees AS entrance_fees_10, t0.charges_fees AS charges_fees_11, t0.services_fees AS services_fees_12, t0.cleaning_fees AS cleaning_fees_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.disabled AS disabled_16, t0.ongoing_booking AS ongoing_booking_17, t0.accommodation_id AS accommodation_id_18, t0.name_id AS name_id_19, t0.description_id AS description_id_20, t0.occupancy_id AS occupancy_id_21, t0.stats_id AS stats_id_22 FROM cal_accommodation_room t0 WHERE t0.accommodation_id = 19;

SELECT
  t0.id AS id_1,
  t0.surface AS surface_2,
  t0.private_bathroom AS private_bathroom_3,
  t0.private_toilet AS private_toilet_4,
  t0.private_kitchen AS private_kitchen_5,
  t0.max_housing_assistance AS max_housing_assistance_6,
  t0.rent AS rent_7,
  t0.additional_rent AS additional_rent_8,
  t0.additional_rent_details AS additional_rent_details_9,
  t0.entrance_fees AS entrance_fees_10,
  t0.charges_fees AS charges_fees_11,
  t0.services_fees AS services_fees_12,
  t0.cleaning_fees AS cleaning_fees_13,
  t0.created_at AS created_at_14,
  t0.updated_at AS updated_at_15,
  t0.disabled AS disabled_16,
  t0.ongoing_booking AS ongoing_booking_17,
  t0.accommodation_id AS accommodation_id_18,
  t0.name_id AS name_id_19,
  t0.description_id AS description_id_20,
  t0.occupancy_id AS occupancy_id_21,
  t0.stats_id AS stats_id_22
FROM
  cal_accommodation_room t0
WHERE
  t0.accommodation_id = ?

SELECT t0.id AS id_1, t0.surface AS surface_2, t0.private_bathroom AS private_bathroom_3, t0.private_toilet AS private_toilet_4, t0.private_kitchen AS private_kitchen_5, t0.max_housing_assistance AS max_housing_assistance_6, t0.rent AS rent_7, t0.additional_rent AS additional_rent_8, t0.additional_rent_details AS additional_rent_details_9, t0.entrance_fees AS entrance_fees_10, t0.charges_fees AS charges_fees_11, t0.services_fees AS services_fees_12, t0.cleaning_fees AS cleaning_fees_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.disabled AS disabled_16, t0.ongoing_booking AS ongoing_booking_17, t0.accommodation_id AS accommodation_id_18, t0.name_id AS name_id_19, t0.description_id AS description_id_20, t0.occupancy_id AS occupancy_id_21, t0.stats_id AS stats_id_22 FROM cal_accommodation_room t0 WHERE t0.accommodation_id = 20;

SELECT
  t0.id AS id_1,
  t0.surface AS surface_2,
  t0.private_bathroom AS private_bathroom_3,
  t0.private_toilet AS private_toilet_4,
  t0.private_kitchen AS private_kitchen_5,
  t0.max_housing_assistance AS max_housing_assistance_6,
  t0.rent AS rent_7,
  t0.additional_rent AS additional_rent_8,
  t0.additional_rent_details AS additional_rent_details_9,
  t0.entrance_fees AS entrance_fees_10,
  t0.charges_fees AS charges_fees_11,
  t0.services_fees AS services_fees_12,
  t0.cleaning_fees AS cleaning_fees_13,
  t0.created_at AS created_at_14,
  t0.updated_at AS updated_at_15,
  t0.disabled AS disabled_16,
  t0.ongoing_booking AS ongoing_booking_17,
  t0.accommodation_id AS accommodation_id_18,
  t0.name_id AS name_id_19,
  t0.description_id AS description_id_20,
  t0.occupancy_id AS occupancy_id_21,
  t0.stats_id AS stats_id_22
FROM
  cal_accommodation_room t0
WHERE
  t0.accommodation_id = ?

SELECT t0.id AS id_1, t0.surface AS surface_2, t0.private_bathroom AS private_bathroom_3, t0.private_toilet AS private_toilet_4, t0.private_kitchen AS private_kitchen_5, t0.max_housing_assistance AS max_housing_assistance_6, t0.rent AS rent_7, t0.additional_rent AS additional_rent_8, t0.additional_rent_details AS additional_rent_details_9, t0.entrance_fees AS entrance_fees_10, t0.charges_fees AS charges_fees_11, t0.services_fees AS services_fees_12, t0.cleaning_fees AS cleaning_fees_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.disabled AS disabled_16, t0.ongoing_booking AS ongoing_booking_17, t0.accommodation_id AS accommodation_id_18, t0.name_id AS name_id_19, t0.description_id AS description_id_20, t0.occupancy_id AS occupancy_id_21, t0.stats_id AS stats_id_22 FROM cal_accommodation_room t0 WHERE t0.accommodation_id = 21;

SELECT
  t0.id AS id_1,
  t0.surface AS surface_2,
  t0.private_bathroom AS private_bathroom_3,
  t0.private_toilet AS private_toilet_4,
  t0.private_kitchen AS private_kitchen_5,
  t0.max_housing_assistance AS max_housing_assistance_6,
  t0.rent AS rent_7,
  t0.additional_rent AS additional_rent_8,
  t0.additional_rent_details AS additional_rent_details_9,
  t0.entrance_fees AS entrance_fees_10,
  t0.charges_fees AS charges_fees_11,
  t0.services_fees AS services_fees_12,
  t0.cleaning_fees AS cleaning_fees_13,
  t0.created_at AS created_at_14,
  t0.updated_at AS updated_at_15,
  t0.disabled AS disabled_16,
  t0.ongoing_booking AS ongoing_booking_17,
  t0.accommodation_id AS accommodation_id_18,
  t0.name_id AS name_id_19,
  t0.description_id AS description_id_20,
  t0.occupancy_id AS occupancy_id_21,
  t0.stats_id AS stats_id_22
FROM
  cal_accommodation_room t0
WHERE
  t0.accommodation_id = ?

SELECT t0.id AS id_1, t0.surface AS surface_2, t0.private_bathroom AS private_bathroom_3, t0.private_toilet AS private_toilet_4, t0.private_kitchen AS private_kitchen_5, t0.max_housing_assistance AS max_housing_assistance_6, t0.rent AS rent_7, t0.additional_rent AS additional_rent_8, t0.additional_rent_details AS additional_rent_details_9, t0.entrance_fees AS entrance_fees_10, t0.charges_fees AS charges_fees_11, t0.services_fees AS services_fees_12, t0.cleaning_fees AS cleaning_fees_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.disabled AS disabled_16, t0.ongoing_booking AS ongoing_booking_17, t0.accommodation_id AS accommodation_id_18, t0.name_id AS name_id_19, t0.description_id AS description_id_20, t0.occupancy_id AS occupancy_id_21, t0.stats_id AS stats_id_22 FROM cal_accommodation_room t0 WHERE t0.accommodation_id = 22;

SELECT
  t0.id AS id_1,
  t0.surface AS surface_2,
  t0.private_bathroom AS private_bathroom_3,
  t0.private_toilet AS private_toilet_4,
  t0.private_kitchen AS private_kitchen_5,
  t0.max_housing_assistance AS max_housing_assistance_6,
  t0.rent AS rent_7,
  t0.additional_rent AS additional_rent_8,
  t0.additional_rent_details AS additional_rent_details_9,
  t0.entrance_fees AS entrance_fees_10,
  t0.charges_fees AS charges_fees_11,
  t0.services_fees AS services_fees_12,
  t0.cleaning_fees AS cleaning_fees_13,
  t0.created_at AS created_at_14,
  t0.updated_at AS updated_at_15,
  t0.disabled AS disabled_16,
  t0.ongoing_booking AS ongoing_booking_17,
  t0.accommodation_id AS accommodation_id_18,
  t0.name_id AS name_id_19,
  t0.description_id AS description_id_20,
  t0.occupancy_id AS occupancy_id_21,
  t0.stats_id AS stats_id_22
FROM
  cal_accommodation_room t0
WHERE
  t0.accommodation_id = ?

SELECT t0.id AS id_1, t0.surface AS surface_2, t0.private_bathroom AS private_bathroom_3, t0.private_toilet AS private_toilet_4, t0.private_kitchen AS private_kitchen_5, t0.max_housing_assistance AS max_housing_assistance_6, t0.rent AS rent_7, t0.additional_rent AS additional_rent_8, t0.additional_rent_details AS additional_rent_details_9, t0.entrance_fees AS entrance_fees_10, t0.charges_fees AS charges_fees_11, t0.services_fees AS services_fees_12, t0.cleaning_fees AS cleaning_fees_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.disabled AS disabled_16, t0.ongoing_booking AS ongoing_booking_17, t0.accommodation_id AS accommodation_id_18, t0.name_id AS name_id_19, t0.description_id AS description_id_20, t0.occupancy_id AS occupancy_id_21, t0.stats_id AS stats_id_22 FROM cal_accommodation_room t0 WHERE t0.accommodation_id = 23;

SELECT
  t0.id AS id_1,
  t0.surface AS surface_2,
  t0.private_bathroom AS private_bathroom_3,
  t0.private_toilet AS private_toilet_4,
  t0.private_kitchen AS private_kitchen_5,
  t0.max_housing_assistance AS max_housing_assistance_6,
  t0.rent AS rent_7,
  t0.additional_rent AS additional_rent_8,
  t0.additional_rent_details AS additional_rent_details_9,
  t0.entrance_fees AS entrance_fees_10,
  t0.charges_fees AS charges_fees_11,
  t0.services_fees AS services_fees_12,
  t0.cleaning_fees AS cleaning_fees_13,
  t0.created_at AS created_at_14,
  t0.updated_at AS updated_at_15,
  t0.disabled AS disabled_16,
  t0.ongoing_booking AS ongoing_booking_17,
  t0.accommodation_id AS accommodation_id_18,
  t0.name_id AS name_id_19,
  t0.description_id AS description_id_20,
  t0.occupancy_id AS occupancy_id_21,
  t0.stats_id AS stats_id_22
FROM
  cal_accommodation_room t0
WHERE
  t0.accommodation_id = ?

SELECT t0.id AS id_1, t0.surface AS surface_2, t0.private_bathroom AS private_bathroom_3, t0.private_toilet AS private_toilet_4, t0.private_kitchen AS private_kitchen_5, t0.max_housing_assistance AS max_housing_assistance_6, t0.rent AS rent_7, t0.additional_rent AS additional_rent_8, t0.additional_rent_details AS additional_rent_details_9, t0.entrance_fees AS entrance_fees_10, t0.charges_fees AS charges_fees_11, t0.services_fees AS services_fees_12, t0.cleaning_fees AS cleaning_fees_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.disabled AS disabled_16, t0.ongoing_booking AS ongoing_booking_17, t0.accommodation_id AS accommodation_id_18, t0.name_id AS name_id_19, t0.description_id AS description_id_20, t0.occupancy_id AS occupancy_id_21, t0.stats_id AS stats_id_22 FROM cal_accommodation_room t0 WHERE t0.accommodation_id = 24;

SELECT
  t0.id AS id_1,
  t0.surface AS surface_2,
  t0.private_bathroom AS private_bathroom_3,
  t0.private_toilet AS private_toilet_4,
  t0.private_kitchen AS private_kitchen_5,
  t0.max_housing_assistance AS max_housing_assistance_6,
  t0.rent AS rent_7,
  t0.additional_rent AS additional_rent_8,
  t0.additional_rent_details AS additional_rent_details_9,
  t0.entrance_fees AS entrance_fees_10,
  t0.charges_fees AS charges_fees_11,
  t0.services_fees AS services_fees_12,
  t0.cleaning_fees AS cleaning_fees_13,
  t0.created_at AS created_at_14,
  t0.updated_at AS updated_at_15,
  t0.disabled AS disabled_16,
  t0.ongoing_booking AS ongoing_booking_17,
  t0.accommodation_id AS accommodation_id_18,
  t0.name_id AS name_id_19,
  t0.description_id AS description_id_20,
  t0.occupancy_id AS occupancy_id_21,
  t0.stats_id AS stats_id_22
FROM
  cal_accommodation_room t0
WHERE
  t0.accommodation_id = ?

SELECT t0.id AS id_1, t0.surface AS surface_2, t0.private_bathroom AS private_bathroom_3, t0.private_toilet AS private_toilet_4, t0.private_kitchen AS private_kitchen_5, t0.max_housing_assistance AS max_housing_assistance_6, t0.rent AS rent_7, t0.additional_rent AS additional_rent_8, t0.additional_rent_details AS additional_rent_details_9, t0.entrance_fees AS entrance_fees_10, t0.charges_fees AS charges_fees_11, t0.services_fees AS services_fees_12, t0.cleaning_fees AS cleaning_fees_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.disabled AS disabled_16, t0.ongoing_booking AS ongoing_booking_17, t0.accommodation_id AS accommodation_id_18, t0.name_id AS name_id_19, t0.description_id AS description_id_20, t0.occupancy_id AS occupancy_id_21, t0.stats_id AS stats_id_22 FROM cal_accommodation_room t0 WHERE t0.accommodation_id = 25;

SELECT
  t0.id AS id_1,
  t0.surface AS surface_2,
  t0.private_bathroom AS private_bathroom_3,
  t0.private_toilet AS private_toilet_4,
  t0.private_kitchen AS private_kitchen_5,
  t0.max_housing_assistance AS max_housing_assistance_6,
  t0.rent AS rent_7,
  t0.additional_rent AS additional_rent_8,
  t0.additional_rent_details AS additional_rent_details_9,
  t0.entrance_fees AS entrance_fees_10,
  t0.charges_fees AS charges_fees_11,
  t0.services_fees AS services_fees_12,
  t0.cleaning_fees AS cleaning_fees_13,
  t0.created_at AS created_at_14,
  t0.updated_at AS updated_at_15,
  t0.disabled AS disabled_16,
  t0.ongoing_booking AS ongoing_booking_17,
  t0.accommodation_id AS accommodation_id_18,
  t0.name_id AS name_id_19,
  t0.description_id AS description_id_20,
  t0.occupancy_id AS occupancy_id_21,
  t0.stats_id AS stats_id_22
FROM
  cal_accommodation_room t0
WHERE
  t0.accommodation_id = ?

SELECT t0.id AS id_1, t0.surface AS surface_2, t0.private_bathroom AS private_bathroom_3, t0.private_toilet AS private_toilet_4, t0.private_kitchen AS private_kitchen_5, t0.max_housing_assistance AS max_housing_assistance_6, t0.rent AS rent_7, t0.additional_rent AS additional_rent_8, t0.additional_rent_details AS additional_rent_details_9, t0.entrance_fees AS entrance_fees_10, t0.charges_fees AS charges_fees_11, t0.services_fees AS services_fees_12, t0.cleaning_fees AS cleaning_fees_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.disabled AS disabled_16, t0.ongoing_booking AS ongoing_booking_17, t0.accommodation_id AS accommodation_id_18, t0.name_id AS name_id_19, t0.description_id AS description_id_20, t0.occupancy_id AS occupancy_id_21, t0.stats_id AS stats_id_22 FROM cal_accommodation_room t0 WHERE t0.accommodation_id = 26;