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

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.name AS name_2,
  t0.virtual_tour AS virtual_tour_3,
  t0.eco AS eco_4,
  t0.pet_friendly AS pet_friendly_5,
  t0.girls_only AS girls_only_6,
  t0.surface AS surface_7,
  t0.type AS type_8,
  t0.construction_year AS construction_year_9,
  t0.total_bedrooms AS total_bedrooms_10,
  t0.total_bathrooms AS total_bathrooms_11,
  t0.total_kitchens AS total_kitchens_12,
  t0.total_toilets AS total_toilets_13,
  t0.garden AS garden_14,
  t0.availability_date AS availability_date_15,
  t0.created_at AS created_at_16,
  t0.updated_at AS updated_at_17,
  t0.disabled AS disabled_18,
  t0.deleted AS deleted_19,
  t0.owner_type AS owner_type_20,
  t0.square_meter_price AS square_meter_price_21,
  t0.majored_square_meter_price AS majored_square_meter_price_22,
  t0.address_id AS address_id_23,
  t0.description_id AS description_id_24,
  t0.cover_id AS cover_id_25,
  t0.plan_id AS plan_id_26,
  t0.access_id AS access_id_27,
  t0.address_area_id AS address_area_id_28,
  t0.district_id AS district_id_29,
  t0.owner_id AS owner_id_30,
  t0.owner_info_id AS owner_info_id_31,
  t0.info_id AS info_id_32,
  t0.cleaning_recurrence_id AS cleaning_recurrence_id_33,
  t34.id AS id_35,
  t34.created_at AS created_at_36,
  t34.updated_at AS updated_at_37,
  t34.accommodation_id AS accommodation_id_38
FROM
  cal_accommodation t0
  LEFT JOIN cal_workflow_project t34 ON t34.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.eco AS eco_4, t0.pet_friendly AS pet_friendly_5, t0.girls_only AS girls_only_6, t0.surface AS surface_7, t0.type AS type_8, t0.construction_year AS construction_year_9, t0.total_bedrooms AS total_bedrooms_10, t0.total_bathrooms AS total_bathrooms_11, t0.total_kitchens AS total_kitchens_12, t0.total_toilets AS total_toilets_13, t0.garden AS garden_14, t0.availability_date AS availability_date_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.disabled AS disabled_18, t0.deleted AS deleted_19, t0.owner_type AS owner_type_20, t0.square_meter_price AS square_meter_price_21, t0.majored_square_meter_price AS majored_square_meter_price_22, t0.address_id AS address_id_23, t0.description_id AS description_id_24, t0.cover_id AS cover_id_25, t0.plan_id AS plan_id_26, t0.access_id AS access_id_27, t0.address_area_id AS address_area_id_28, t0.district_id AS district_id_29, t0.owner_id AS owner_id_30, t0.owner_info_id AS owner_info_id_31, t0.info_id AS info_id_32, t0.cleaning_recurrence_id AS cleaning_recurrence_id_33, t34.id AS id_35, t34.created_at AS created_at_36, t34.updated_at AS updated_at_37, t34.accommodation_id AS accommodation_id_38 FROM cal_accommodation t0 LEFT JOIN cal_workflow_project t34 ON t34.accommodation_id = t0.id WHERE t0.id = '24';

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

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

SELECT
  t0.id AS id_1,
  t0.`from` AS from_2,
  t0.`to` AS to_3,
  t0.status AS status_4,
  t0.created_at AS created_at_5,
  t0.booking_id AS booking_id_6,
  t0.room_id AS room_id_7,
  t0.user_id AS user_id_8,
  t0.leaving_inventory_id AS leaving_inventory_id_9,
  t0.leaving_document_id AS leaving_document_id_10
FROM
  cal_accommodation_occupancy t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.`from` AS from_2, t0.`to` AS to_3, t0.status AS status_4, t0.created_at AS created_at_5, t0.booking_id AS booking_id_6, t0.room_id AS room_id_7, t0.user_id AS user_id_8, t0.leaving_inventory_id AS leaving_inventory_id_9, t0.leaving_document_id AS leaving_document_id_10 FROM cal_accommodation_occupancy t0 WHERE t0.id = 100;

SELECT
  t0.id AS id_1,
  t0.civility AS civility_2,
  t0.firstname AS firstname_3,
  t0.lastname AS lastname_4,
  t0.phone AS phone_5,
  t0.birthday AS birthday_6,
  t0.birthplace AS birthplace_7,
  t0.job AS job_8,
  t0.hobbies AS hobbies_9,
  t0.email AS email_10,
  t0.password AS password_11,
  t0.reset_password_token AS reset_password_token_12,
  t0.reset_password_token_expire AS reset_password_token_expire_13,
  t0.roles AS roles_14,
  t0.notification_groups AS notification_groups_15,
  t0.created_at AS created_at_16,
  t0.updated_at AS updated_at_17,
  t0.register_token AS register_token_18,
  t0.active AS active_19,
  t0.deleted AS deleted_20,
  t0.x14 AS x14_21,
  t0.nationality AS nationality_22,
  t0.language AS language_23,
  t0.financial_situation AS financial_situation_24,
  t0.guarantor_email AS guarantor_email_25,
  t0.guarantor_firstname AS guarantor_firstname_26,
  t0.guarantor_lastname AS guarantor_lastname_27,
  t0.parents_phone AS parents_phone_28,
  t0.bank_name AS bank_name_29,
  t0.bank_bic AS bank_bic_30,
  t0.bank_iban AS bank_iban_31,
  t0.stripe_id AS stripe_id_32,
  t0.onboarding_email AS onboarding_email_33,
  t0.optin AS optin_34,
  t0.address_id AS address_id_35,
  t0.parent_id AS parent_id_36,
  t0.parents_address_id AS parents_address_id_37,
  t0.avatar_id AS avatar_id_38,
  t39.id AS id_40,
  t39.google_token AS google_token_41,
  t39.selected_calendar AS selected_calendar_42,
  t39.user_id AS user_id_43,
  t0.owner_info_id AS owner_info_id_44,
  t0.service_provider_info_id AS service_provider_info_id_45
FROM
  cal_user t0
  LEFT JOIN cal_calendar t39 ON t39.user_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.civility AS civility_2, t0.firstname AS firstname_3, t0.lastname AS lastname_4, t0.phone AS phone_5, t0.birthday AS birthday_6, t0.birthplace AS birthplace_7, t0.job AS job_8, t0.hobbies AS hobbies_9, t0.email AS email_10, t0.password AS password_11, t0.reset_password_token AS reset_password_token_12, t0.reset_password_token_expire AS reset_password_token_expire_13, t0.roles AS roles_14, t0.notification_groups AS notification_groups_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.register_token AS register_token_18, t0.active AS active_19, t0.deleted AS deleted_20, t0.x14 AS x14_21, t0.nationality AS nationality_22, t0.language AS language_23, t0.financial_situation AS financial_situation_24, t0.guarantor_email AS guarantor_email_25, t0.guarantor_firstname AS guarantor_firstname_26, t0.guarantor_lastname AS guarantor_lastname_27, t0.parents_phone AS parents_phone_28, t0.bank_name AS bank_name_29, t0.bank_bic AS bank_bic_30, t0.bank_iban AS bank_iban_31, t0.stripe_id AS stripe_id_32, t0.onboarding_email AS onboarding_email_33, t0.optin AS optin_34, t0.address_id AS address_id_35, t0.parent_id AS parent_id_36, t0.parents_address_id AS parents_address_id_37, t0.avatar_id AS avatar_id_38, t39.id AS id_40, t39.google_token AS google_token_41, t39.selected_calendar AS selected_calendar_42, t39.user_id AS user_id_43, t0.owner_info_id AS owner_info_id_44, t0.service_provider_info_id AS service_provider_info_id_45 FROM cal_user t0 LEFT JOIN cal_calendar t39 ON t39.user_id = t0.id WHERE t0.id = 131;

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

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

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 = 53 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 = ?
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 = 24 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_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 = 24;

SELECT
  t0.id AS id_1,
  t0.eco AS eco_2,
  t0.external_url AS external_url_3,
  t0.surface AS surface_4,
  t0.private_bathroom AS private_bathroom_5,
  t0.private_toilet AS private_toilet_6,
  t0.private_kitchen AS private_kitchen_7,
  t0.max_housing_assistance AS max_housing_assistance_8,
  t0.rent AS rent_9,
  t0.additional_rent AS additional_rent_10,
  t0.additional_rent_details AS additional_rent_details_11,
  t0.entrance_fees AS entrance_fees_12,
  t0.charges_fees AS charges_fees_13,
  t0.services_fees AS services_fees_14,
  t0.cleaning_fees AS cleaning_fees_15,
  t0.created_at AS created_at_16,
  t0.updated_at AS updated_at_17,
  t0.disabled AS disabled_18,
  t0.booking_disabled AS booking_disabled_19,
  t0.booking_date_from AS booking_date_from_20,
  t0.ongoing_booking AS ongoing_booking_21,
  t0.accommodation_id AS accommodation_id_22,
  t0.name_id AS name_id_23,
  t0.description_id AS description_id_24,
  t0.occupancy_id AS occupancy_id_25,
  t0.stats_id AS stats_id_26
FROM
  cal_accommodation_room t0
WHERE
  t0.accommodation_id = ?

SELECT t0.id AS id_1, t0.eco AS eco_2, t0.external_url AS external_url_3, t0.surface AS surface_4, t0.private_bathroom AS private_bathroom_5, t0.private_toilet AS private_toilet_6, t0.private_kitchen AS private_kitchen_7, t0.max_housing_assistance AS max_housing_assistance_8, t0.rent AS rent_9, t0.additional_rent AS additional_rent_10, t0.additional_rent_details AS additional_rent_details_11, t0.entrance_fees AS entrance_fees_12, t0.charges_fees AS charges_fees_13, t0.services_fees AS services_fees_14, t0.cleaning_fees AS cleaning_fees_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.disabled AS disabled_18, t0.booking_disabled AS booking_disabled_19, t0.booking_date_from AS booking_date_from_20, t0.ongoing_booking AS ongoing_booking_21, t0.accommodation_id AS accommodation_id_22, t0.name_id AS name_id_23, t0.description_id AS description_id_24, t0.occupancy_id AS occupancy_id_25, t0.stats_id AS stats_id_26 FROM cal_accommodation_room t0 WHERE t0.accommodation_id = 24;

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

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