Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.fr AS fr_2,
  t0.en AS en_3,
  t0.es AS es_4
FROM
  cal_translation t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.fr AS fr_2, t0.en AS en_3, t0.es AS es_4 FROM cal_translation t0 WHERE t0.id = 19;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.private AS private_3,
  t0.created_at AS created_at_4
FROM
  cal_media t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.private AS private_3, t0.created_at AS created_at_4 FROM cal_media t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.position AS position_2,
  t0.label_id AS label_id_3,
  t0.description_id AS description_id_4,
  t0.image_id AS image_id_5,
  t0.list_id AS list_id_6
FROM
  cal_property_list_item t0
  INNER JOIN cal_accommodation_rooms_equipments ON t0.id = cal_accommodation_rooms_equipments.property_list_item_id
WHERE
  cal_accommodation_rooms_equipments.accommodation_room_id = ?

SELECT t0.id AS id_1, t0.position AS position_2, t0.label_id AS label_id_3, t0.description_id AS description_id_4, t0.image_id AS image_id_5, t0.list_id AS list_id_6 FROM cal_property_list_item t0 INNER JOIN cal_accommodation_rooms_equipments ON t0.id = cal_accommodation_rooms_equipments.property_list_item_id WHERE cal_accommodation_rooms_equipments.accommodation_room_id = 553;

SELECT
  t0.id AS id_1,
  t0.position AS position_2,
  t0.label_id AS label_id_3,
  t0.description_id AS description_id_4,
  t0.image_id AS image_id_5,
  t0.list_id AS list_id_6
FROM
  cal_property_list_item t0
  INNER JOIN cal_accommodation_rooms_charges_details ON t0.id = cal_accommodation_rooms_charges_details.property_list_item_id
WHERE
  cal_accommodation_rooms_charges_details.accommodation_room_id = ?

SELECT t0.id AS id_1, t0.position AS position_2, t0.label_id AS label_id_3, t0.description_id AS description_id_4, t0.image_id AS image_id_5, t0.list_id AS list_id_6 FROM cal_property_list_item t0 INNER JOIN cal_accommodation_rooms_charges_details ON t0.id = cal_accommodation_rooms_charges_details.property_list_item_id WHERE cal_accommodation_rooms_charges_details.accommodation_room_id = 553;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.private AS private_3,
  t0.created_at AS created_at_4,
  t0.position AS position_5,
  t0.accommodation_id AS accommodation_id_6,
  t0.room_id AS room_id_7
FROM
  cal_accommodation_image t0
WHERE
  t0.room_id = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.private AS private_3, t0.created_at AS created_at_4, t0.position AS position_5, t0.accommodation_id AS accommodation_id_6, t0.room_id AS room_id_7 FROM cal_accommodation_image t0 WHERE t0.room_id = 553 ORDER BY t0.position ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.private AS private_3,
  t0.created_at AS created_at_4,
  t0.position AS position_5,
  t0.accommodation_id AS accommodation_id_6,
  t0.room_id AS room_id_7
FROM
  cal_accommodation_image t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.private AS private_3, t0.created_at AS created_at_4, t0.position AS position_5, t0.accommodation_id AS accommodation_id_6, t0.room_id AS room_id_7 FROM cal_accommodation_image t0 WHERE t0.id = 1505;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.virtual_tour AS virtual_tour_3,
  t0.pet_friendly AS pet_friendly_4,
  t0.girls_only AS girls_only_5,
  t0.surface AS surface_6,
  t0.type AS type_7,
  t0.construction_year AS construction_year_8,
  t0.total_bedrooms AS total_bedrooms_9,
  t0.total_bathrooms AS total_bathrooms_10,
  t0.total_kitchens AS total_kitchens_11,
  t0.total_toilets AS total_toilets_12,
  t0.garden AS garden_13,
  t0.created_at AS created_at_14,
  t0.updated_at AS updated_at_15,
  t0.disabled AS disabled_16,
  t0.owner_type AS owner_type_17,
  t0.square_meter_price AS square_meter_price_18,
  t0.majored_square_meter_price AS majored_square_meter_price_19,
  t0.address_id AS address_id_20,
  t0.description_id AS description_id_21,
  t0.cover_id AS cover_id_22,
  t0.plan_id AS plan_id_23,
  t0.access_id AS access_id_24,
  t0.district_id AS district_id_25,
  t0.owner_id AS owner_id_26,
  t0.owner_info_id AS owner_info_id_27,
  t0.info_id AS info_id_28,
  t0.cleaning_recurrence_id AS cleaning_recurrence_id_29,
  t30.id AS id_31,
  t30.created_at AS created_at_32,
  t30.updated_at AS updated_at_33,
  t30.accommodation_id AS accommodation_id_34
FROM
  cal_accommodation t0
  LEFT JOIN cal_workflow_project t30 ON t30.accommodation_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.virtual_tour AS virtual_tour_3, t0.pet_friendly AS pet_friendly_4, t0.girls_only AS girls_only_5, t0.surface AS surface_6, t0.type AS type_7, t0.construction_year AS construction_year_8, t0.total_bedrooms AS total_bedrooms_9, t0.total_bathrooms AS total_bathrooms_10, t0.total_kitchens AS total_kitchens_11, t0.total_toilets AS total_toilets_12, t0.garden AS garden_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.disabled AS disabled_16, t0.owner_type AS owner_type_17, t0.square_meter_price AS square_meter_price_18, t0.majored_square_meter_price AS majored_square_meter_price_19, t0.address_id AS address_id_20, t0.description_id AS description_id_21, t0.cover_id AS cover_id_22, t0.plan_id AS plan_id_23, t0.access_id AS access_id_24, t0.district_id AS district_id_25, t0.owner_id AS owner_id_26, t0.owner_info_id AS owner_info_id_27, t0.info_id AS info_id_28, t0.cleaning_recurrence_id AS cleaning_recurrence_id_29, t30.id AS id_31, t30.created_at AS created_at_32, t30.updated_at AS updated_at_33, t30.accommodation_id AS accommodation_id_34 FROM cal_accommodation t0 LEFT JOIN cal_workflow_project t30 ON t30.accommodation_id = t0.id WHERE t0.id = '140';

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 = 140;

SELECT
  t0.id AS id_1,
  t0.position AS position_2,
  t0.label_id AS label_id_3,
  t0.description_id AS description_id_4,
  t0.image_id AS image_id_5,
  t0.list_id AS list_id_6
FROM
  cal_property_list_item t0
  INNER JOIN cal_accommodations_transports ON t0.id = cal_accommodations_transports.property_list_item_id
WHERE
  cal_accommodations_transports.accommodation_id = ?

SELECT t0.id AS id_1, t0.position AS position_2, t0.label_id AS label_id_3, t0.description_id AS description_id_4, t0.image_id AS image_id_5, t0.list_id AS list_id_6 FROM cal_property_list_item t0 INNER JOIN cal_accommodations_transports ON t0.id = cal_accommodations_transports.property_list_item_id WHERE cal_accommodations_transports.accommodation_id = 140;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.private AS private_3,
  t0.created_at AS created_at_4,
  t0.position AS position_5,
  t0.accommodation_id AS accommodation_id_6,
  t0.room_id AS room_id_7
FROM
  cal_accommodation_image t0
WHERE
  t0.accommodation_id = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.private AS private_3, t0.created_at AS created_at_4, t0.position AS position_5, t0.accommodation_id AS accommodation_id_6, t0.room_id AS room_id_7 FROM cal_accommodation_image t0 WHERE t0.accommodation_id = 140 ORDER BY t0.position ASC;

SELECT
  t0.id AS id_1,
  t0.position AS position_2,
  t0.label_id AS label_id_3,
  t0.description_id AS description_id_4,
  t0.image_id AS image_id_5,
  t0.list_id AS list_id_6
FROM
  cal_property_list_item t0
  INNER JOIN cal_accommodations_equipments ON t0.id = cal_accommodations_equipments.property_list_item_id
WHERE
  cal_accommodations_equipments.accommodation_id = ?

SELECT t0.id AS id_1, t0.position AS position_2, t0.label_id AS label_id_3, t0.description_id AS description_id_4, t0.image_id AS image_id_5, t0.list_id AS list_id_6 FROM cal_property_list_item t0 INNER JOIN cal_accommodations_equipments ON t0.id = cal_accommodations_equipments.property_list_item_id WHERE cal_accommodations_equipments.accommodation_id = 140;

SELECT
  t0.id AS id_1,
  t0.position AS position_2,
  t0.label_id AS label_id_3,
  t0.description_id AS description_id_4,
  t0.image_id AS image_id_5,
  t0.list_id AS list_id_6
FROM
  cal_property_list_item t0
  INNER JOIN cal_accommodations_universities ON t0.id = cal_accommodations_universities.property_list_item_id
WHERE
  cal_accommodations_universities.accommodation_id = ?

SELECT t0.id AS id_1, t0.position AS position_2, t0.label_id AS label_id_3, t0.description_id AS description_id_4, t0.image_id AS image_id_5, t0.list_id AS list_id_6 FROM cal_property_list_item t0 INNER JOIN cal_accommodations_universities ON t0.id = cal_accommodations_universities.property_list_item_id WHERE cal_accommodations_universities.accommodation_id = 140;

SELECT
  t0.id AS id_1,
  t0.position AS position_2,
  t0.label_id AS label_id_3,
  t0.description_id AS description_id_4,
  t0.image_id AS image_id_5,
  t0.list_id AS list_id_6
FROM
  cal_property_list_item t0
  INNER JOIN cal_accommodations_services ON t0.id = cal_accommodations_services.property_list_item_id
WHERE
  cal_accommodations_services.accommodation_id = ?

SELECT t0.id AS id_1, t0.position AS position_2, t0.label_id AS label_id_3, t0.description_id AS description_id_4, t0.image_id AS image_id_5, t0.list_id AS list_id_6 FROM cal_property_list_item t0 INNER JOIN cal_accommodations_services ON t0.id = cal_accommodations_services.property_list_item_id WHERE cal_accommodations_services.accommodation_id = 140;

SELECT
  t0.id AS id_1,
  t0.auto_lat_lng AS auto_lat_lng_2,
  t0.alias AS alias_3,
  t0.name AS name_4,
  t0.address AS address_5,
  t0.zipcode AS zipcode_6,
  t0.city AS city_7,
  t0.country AS country_8,
  t0.informations AS informations_9,
  t0.latitude AS latitude_10,
  t0.longitude AS longitude_11
FROM
  cal_address t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.auto_lat_lng AS auto_lat_lng_2, t0.alias AS alias_3, t0.name AS name_4, t0.address AS address_5, t0.zipcode AS zipcode_6, t0.city AS city_7, t0.country AS country_8, t0.informations AS informations_9, t0.latitude AS latitude_10, t0.longitude AS longitude_11 FROM cal_address t0 WHERE t0.id = 1386;