Symfony Profiler

SELECT
  p0_.id AS id_0,
  p0_.maximal_area AS maximal_area_1,
  p0_.minimal_area AS minimal_area_2,
  p0_.minimal_price AS minimal_price_3,
  p0_.maximum_price AS maximum_price_4,
  p0_.rooms_number AS rooms_number_5,
  p0_.is_available AS is_available_6,
  p0_.date_availability AS date_availability_7,
  p0_.construction_year AS construction_year_8,
  p0_.floors_number AS floors_number_9,
  p0_.is_furnished AS is_furnished_10,
  p0_.has_guardian AS has_guardian_11,
  p0_.has_intercom AS has_intercom_12,
  p0_.has_elevator AS has_elevator_13,
  p0_.has_terrace AS has_terrace_14,
  p0_.has_balcony AS has_balcony_15,
  p0_.has_garage AS has_garage_16,
  p0_.has_park_car AS has_park_car_17,
  p0_.has_park_car_outside AS has_park_car_outside_18,
  p0_.has_cellar AS has_cellar_19,
  p0_.has_basement AS has_basement_20,
  p0_.has_bathroom AS has_bathroom_21,
  p0_.description AS description_22,
  p0_.archived_at AS archived_at_23,
  p0_.property_title_number AS property_title_number_24,
  p0_.booking_number AS booking_number_25,
  p0_.floor AS floor_26,
  p0_.bathroom_number AS bathroom_number_27,
  p0_.number_of_rooms AS number_of_rooms_28,
  p0_.number_of_pieces AS number_of_pieces_29,
  p0_.reference AS reference_30,
  p0_.is_shared AS is_shared_31,
  p0_.has_titled_parking AS has_titled_parking_32,
  p0_.parking_area AS parking_area_33,
  p0_.has_mezzanine AS has_mezzanine_34,
  p0_.mezzanine_area AS mezzanine_area_35,
  p0_.description_mandate AS description_mandate_36,
  p0_.is_short_term_rental AS is_short_term_rental_37,
  p0_.date_start_rental AS date_start_rental_38,
  p0_.date_end_rental AS date_end_rental_39,
  p0_.video_link AS video_link_40,
  p0_.created_at AS created_at_41,
  p0_.updated_at AS updated_at_42,
  p0_.property_address_id AS property_address_id_43,
  p0_.collaborator_id AS collaborator_id_44,
  p0_.contact_id AS contact_id_45,
  p0_.prescriber_id AS prescriber_id_46,
  p0_.manager_id AS manager_id_47,
  p0_.reference_property_domain_id AS reference_property_domain_id_48,
  p0_.refrence_property_state_id AS refrence_property_state_id_49,
  p0_.reference_property_contract_type_id AS reference_property_contract_type_id_50,
  p0_.reference_property_land_type_id AS reference_property_land_type_id_51,
  p0_.reference_property_destination_id AS reference_property_destination_id_52,
  p0_.reference_property_construction_type_id AS reference_property_construction_type_id_53,
  p0_.reference_property_orientation_type_id AS reference_property_orientation_type_id_54,
  p0_.reference_property_status_id AS reference_property_status_id_55,
  p0_.reference_service_type_id AS reference_service_type_id_56,
  p0_.reference_property_type_id AS reference_property_type_id_57,
  p0_.recommendation_id AS recommendation_id_58
FROM
  property p0_
  INNER JOIN reference_property_status r1_ ON p0_.reference_property_status_id = r1_.id
  LEFT JOIN property_property_diffusion_mode_reference p3_ ON p0_.id = p3_.property_id
  LEFT JOIN property_diffusion_mode_reference p2_ ON p2_.id = p3_.property_diffusion_mode_reference_id
  LEFT JOIN reference_property_service_type r4_ ON p0_.reference_service_type_id = r4_.id
WHERE
  r1_.code IN (?, ?, ?)
  AND p2_.code IS NOT NULL
  AND p2_.code NOT LIKE ?
  AND r4_.code IN (?, ?)
ORDER BY
  p0_.id DESC

SELECT p0_.id AS id_0, p0_.maximal_area AS maximal_area_1, p0_.minimal_area AS minimal_area_2, p0_.minimal_price AS minimal_price_3, p0_.maximum_price AS maximum_price_4, p0_.rooms_number AS rooms_number_5, p0_.is_available AS is_available_6, p0_.date_availability AS date_availability_7, p0_.construction_year AS construction_year_8, p0_.floors_number AS floors_number_9, p0_.is_furnished AS is_furnished_10, p0_.has_guardian AS has_guardian_11, p0_.has_intercom AS has_intercom_12, p0_.has_elevator AS has_elevator_13, p0_.has_terrace AS has_terrace_14, p0_.has_balcony AS has_balcony_15, p0_.has_garage AS has_garage_16, p0_.has_park_car AS has_park_car_17, p0_.has_park_car_outside AS has_park_car_outside_18, p0_.has_cellar AS has_cellar_19, p0_.has_basement AS has_basement_20, p0_.has_bathroom AS has_bathroom_21, p0_.description AS description_22, p0_.archived_at AS archived_at_23, p0_.property_title_number AS property_title_number_24, p0_.booking_number AS booking_number_25, p0_.floor AS floor_26, p0_.bathroom_number AS bathroom_number_27, p0_.number_of_rooms AS number_of_rooms_28, p0_.number_of_pieces AS number_of_pieces_29, p0_.reference AS reference_30, p0_.is_shared AS is_shared_31, p0_.has_titled_parking AS has_titled_parking_32, p0_.parking_area AS parking_area_33, p0_.has_mezzanine AS has_mezzanine_34, p0_.mezzanine_area AS mezzanine_area_35, p0_.description_mandate AS description_mandate_36, p0_.is_short_term_rental AS is_short_term_rental_37, p0_.date_start_rental AS date_start_rental_38, p0_.date_end_rental AS date_end_rental_39, p0_.video_link AS video_link_40, p0_.created_at AS created_at_41, p0_.updated_at AS updated_at_42, p0_.property_address_id AS property_address_id_43, p0_.collaborator_id AS collaborator_id_44, p0_.contact_id AS contact_id_45, p0_.prescriber_id AS prescriber_id_46, p0_.manager_id AS manager_id_47, p0_.reference_property_domain_id AS reference_property_domain_id_48, p0_.refrence_property_state_id AS refrence_property_state_id_49, p0_.reference_property_contract_type_id AS reference_property_contract_type_id_50, p0_.reference_property_land_type_id AS reference_property_land_type_id_51, p0_.reference_property_destination_id AS reference_property_destination_id_52, p0_.reference_property_construction_type_id AS reference_property_construction_type_id_53, p0_.reference_property_orientation_type_id AS reference_property_orientation_type_id_54, p0_.reference_property_status_id AS reference_property_status_id_55, p0_.reference_service_type_id AS reference_service_type_id_56, p0_.reference_property_type_id AS reference_property_type_id_57, p0_.recommendation_id AS recommendation_id_58 FROM property p0_ INNER JOIN reference_property_status r1_ ON p0_.reference_property_status_id = r1_.id LEFT JOIN property_property_diffusion_mode_reference p3_ ON p0_.id = p3_.property_id LEFT JOIN property_diffusion_mode_reference p2_ ON p2_.id = p3_.property_diffusion_mode_reference_id LEFT JOIN reference_property_service_type r4_ ON p0_.reference_service_type_id = r4_.id WHERE r1_.code IN ('10', '0', '2') AND p2_.code IS NOT NULL AND p2_.code NOT LIKE 'NONE' AND r4_.code IN ('2', '3') ORDER BY p0_.id DESC;

SELECT
  t0.id AS id_1,
  t0.first_address AS first_address_2,
  t0.second_address AS second_address_3,
  t0.zip_code AS zip_code_4,
  t0.city_id AS city_id_5,
  t6.id AS id_7,
  t6.maximal_area AS maximal_area_8,
  t6.minimal_area AS minimal_area_9,
  t6.minimal_price AS minimal_price_10,
  t6.maximum_price AS maximum_price_11,
  t6.rooms_number AS rooms_number_12,
  t6.is_available AS is_available_13,
  t6.date_availability AS date_availability_14,
  t6.construction_year AS construction_year_15,
  t6.floors_number AS floors_number_16,
  t6.is_furnished AS is_furnished_17,
  t6.has_guardian AS has_guardian_18,
  t6.has_intercom AS has_intercom_19,
  t6.has_elevator AS has_elevator_20,
  t6.has_terrace AS has_terrace_21,
  t6.has_balcony AS has_balcony_22,
  t6.has_garage AS has_garage_23,
  t6.has_park_car AS has_park_car_24,
  t6.has_park_car_outside AS has_park_car_outside_25,
  t6.has_cellar AS has_cellar_26,
  t6.has_basement AS has_basement_27,
  t6.has_bathroom AS has_bathroom_28,
  t6.description AS description_29,
  t6.archived_at AS archived_at_30,
  t6.property_title_number AS property_title_number_31,
  t6.booking_number AS booking_number_32,
  t6.floor AS floor_33,
  t6.bathroom_number AS bathroom_number_34,
  t6.number_of_rooms AS number_of_rooms_35,
  t6.number_of_pieces AS number_of_pieces_36,
  t6.reference AS reference_37,
  t6.is_shared AS is_shared_38,
  t6.has_titled_parking AS has_titled_parking_39,
  t6.parking_area AS parking_area_40,
  t6.has_mezzanine AS has_mezzanine_41,
  t6.mezzanine_area AS mezzanine_area_42,
  t6.description_mandate AS description_mandate_43,
  t6.is_short_term_rental AS is_short_term_rental_44,
  t6.date_start_rental AS date_start_rental_45,
  t6.date_end_rental AS date_end_rental_46,
  t6.video_link AS video_link_47,
  t6.created_at AS created_at_48,
  t6.updated_at AS updated_at_49,
  t6.property_address_id AS property_address_id_50,
  t6.collaborator_id AS collaborator_id_51,
  t6.contact_id AS contact_id_52,
  t6.prescriber_id AS prescriber_id_53,
  t6.manager_id AS manager_id_54,
  t6.reference_property_domain_id AS reference_property_domain_id_55,
  t6.refrence_property_state_id AS refrence_property_state_id_56,
  t6.reference_property_contract_type_id AS reference_property_contract_type_id_57,
  t6.reference_property_land_type_id AS reference_property_land_type_id_58,
  t6.reference_property_destination_id AS reference_property_destination_id_59,
  t6.reference_property_construction_type_id AS reference_property_construction_type_id_60,
  t6.reference_property_orientation_type_id AS reference_property_orientation_type_id_61,
  t6.reference_property_status_id AS reference_property_status_id_62,
  t6.reference_service_type_id AS reference_service_type_id_63,
  t6.reference_property_type_id AS reference_property_type_id_64,
  t6.recommendation_id AS recommendation_id_65,
  t0.neighborhood_id AS neighborhood_id_66
FROM
  property_address t0
  LEFT JOIN property t6 ON t6.property_address_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.first_address AS first_address_2, t0.second_address AS second_address_3, t0.zip_code AS zip_code_4, t0.city_id AS city_id_5, t6.id AS id_7, t6.maximal_area AS maximal_area_8, t6.minimal_area AS minimal_area_9, t6.minimal_price AS minimal_price_10, t6.maximum_price AS maximum_price_11, t6.rooms_number AS rooms_number_12, t6.is_available AS is_available_13, t6.date_availability AS date_availability_14, t6.construction_year AS construction_year_15, t6.floors_number AS floors_number_16, t6.is_furnished AS is_furnished_17, t6.has_guardian AS has_guardian_18, t6.has_intercom AS has_intercom_19, t6.has_elevator AS has_elevator_20, t6.has_terrace AS has_terrace_21, t6.has_balcony AS has_balcony_22, t6.has_garage AS has_garage_23, t6.has_park_car AS has_park_car_24, t6.has_park_car_outside AS has_park_car_outside_25, t6.has_cellar AS has_cellar_26, t6.has_basement AS has_basement_27, t6.has_bathroom AS has_bathroom_28, t6.description AS description_29, t6.archived_at AS archived_at_30, t6.property_title_number AS property_title_number_31, t6.booking_number AS booking_number_32, t6.floor AS floor_33, t6.bathroom_number AS bathroom_number_34, t6.number_of_rooms AS number_of_rooms_35, t6.number_of_pieces AS number_of_pieces_36, t6.reference AS reference_37, t6.is_shared AS is_shared_38, t6.has_titled_parking AS has_titled_parking_39, t6.parking_area AS parking_area_40, t6.has_mezzanine AS has_mezzanine_41, t6.mezzanine_area AS mezzanine_area_42, t6.description_mandate AS description_mandate_43, t6.is_short_term_rental AS is_short_term_rental_44, t6.date_start_rental AS date_start_rental_45, t6.date_end_rental AS date_end_rental_46, t6.video_link AS video_link_47, t6.created_at AS created_at_48, t6.updated_at AS updated_at_49, t6.property_address_id AS property_address_id_50, t6.collaborator_id AS collaborator_id_51, t6.contact_id AS contact_id_52, t6.prescriber_id AS prescriber_id_53, t6.manager_id AS manager_id_54, t6.reference_property_domain_id AS reference_property_domain_id_55, t6.refrence_property_state_id AS refrence_property_state_id_56, t6.reference_property_contract_type_id AS reference_property_contract_type_id_57, t6.reference_property_land_type_id AS reference_property_land_type_id_58, t6.reference_property_destination_id AS reference_property_destination_id_59, t6.reference_property_construction_type_id AS reference_property_construction_type_id_60, t6.reference_property_orientation_type_id AS reference_property_orientation_type_id_61, t6.reference_property_status_id AS reference_property_status_id_62, t6.reference_service_type_id AS reference_service_type_id_63, t6.reference_property_type_id AS reference_property_type_id_64, t6.recommendation_id AS recommendation_id_65, t0.neighborhood_id AS neighborhood_id_66 FROM property_address t0 LEFT JOIN property t6 ON t6.property_address_id = t0.id WHERE t0.id = 11359;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.latitude AS latitude_3,
  t0.longitude AS longitude_4,
  t0.rank AS rank_5,
  t0.country_id AS country_id_6
FROM
  city t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.latitude AS latitude_3, t0.longitude AS longitude_4, t0.rank AS rank_5, t0.country_id AS country_id_6 FROM city t0 WHERE t0.id = 2087;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.language_id AS language_id_3,
  t0.currency_id AS currency_id_4
FROM
  country t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.language_id AS language_id_3, t0.currency_id AS currency_id_4 FROM country t0 WHERE t0.id = 2365;

SELECT
  t1.id AS id_2,
  t1.first_name AS first_name_3,
  t1.last_name AS last_name_4,
  t1.email AS email_5,
  t1.professional_email AS professional_email_6,
  t1.birth_day AS birth_day_7,
  t1.phone AS phone_8,
  t1.main_phone AS main_phone_9,
  t1.roles AS roles_10,
  t1.password AS password_11,
  t1.last_connection AS last_connection_12,
  t1.person_type AS person_type_13,
  t1.created_at AS created_at_14,
  t1.updated_at AS updated_at_15,
  t0.cin AS cin_16,
  t0.is_recommender AS is_recommender_17,
  t0.cnss AS cnss_18,
  t0.rc AS rc_19,
  t0.professional_status AS professional_status_20,
  t0.subject_to_vat AS subject_to_vat_21,
  t0.created_qualifiqaution_date AS created_qualifiqaution_date_22,
  t0.company_name AS company_name_23,
  t0.common_company_identifier AS common_company_identifier_24,
  t1.address_id AS address_id_25,
  t1.gender_id AS gender_id_26,
  t1.reference_status_id AS reference_status_id_27,
  t1.reference_marital_status_id AS reference_marital_status_id_28,
  t0.qualification_level_id AS qualification_level_id_29,
  t0.sector_id AS sector_id_30,
  t0.manager_id AS manager_id_31,
  t0.status_id AS status_id_32,
  t0.sponsor_id AS sponsor_id_33,
  t0.nationality_id AS nationality_id_34,
  t1.type
FROM
  agent t0
  INNER JOIN abstract_collaborator t1 ON t0.id = t1.id
WHERE
  t1.id = ?

SELECT t1.id AS id_2, t1.first_name AS first_name_3, t1.last_name AS last_name_4, t1.email AS email_5, t1.professional_email AS professional_email_6, t1.birth_day AS birth_day_7, t1.phone AS phone_8, t1.main_phone AS main_phone_9, t1.roles AS roles_10, t1.password AS password_11, t1.last_connection AS last_connection_12, t1.person_type AS person_type_13, t1.created_at AS created_at_14, t1.updated_at AS updated_at_15, t0.cin AS cin_16, t0.is_recommender AS is_recommender_17, t0.cnss AS cnss_18, t0.rc AS rc_19, t0.professional_status AS professional_status_20, t0.subject_to_vat AS subject_to_vat_21, t0.created_qualifiqaution_date AS created_qualifiqaution_date_22, t0.company_name AS company_name_23, t0.common_company_identifier AS common_company_identifier_24, t1.address_id AS address_id_25, t1.gender_id AS gender_id_26, t1.reference_status_id AS reference_status_id_27, t1.reference_marital_status_id AS reference_marital_status_id_28, t0.qualification_level_id AS qualification_level_id_29, t0.sector_id AS sector_id_30, t0.manager_id AS manager_id_31, t0.status_id AS status_id_32, t0.sponsor_id AS sponsor_id_33, t0.nationality_id AS nationality_id_34, t1.type FROM agent t0 INNER JOIN abstract_collaborator t1 ON t0.id = t1.id WHERE t1.id = 3093;

SELECT
  t0.id AS id_1,
  t0.file_path AS file_path_2,
  t0.collaborator_id AS collaborator_id_3
FROM
  avatar t0
WHERE
  t0.collaborator_id = ?

SELECT t0.id AS id_1, t0.file_path AS file_path_2, t0.collaborator_id AS collaborator_id_3 FROM avatar t0 WHERE t0.collaborator_id = 3093;

SELECT
  t0.id AS id_1,
  t0.ip_address AS ip_address_2,
  t0.browser AS browser_3,
  t0.is_accepted AS is_accepted_4,
  t0.accepted_at AS accepted_at_5,
  t0.collaborator_id AS collaborator_id_6
FROM
  cgu t0
WHERE
  t0.collaborator_id = ?

SELECT t0.id AS id_1, t0.ip_address AS ip_address_2, t0.browser AS browser_3, t0.is_accepted AS is_accepted_4, t0.accepted_at AS accepted_at_5, t0.collaborator_id AS collaborator_id_6 FROM cgu t0 WHERE t0.collaborator_id = 3093;

SELECT
  t0.id AS id_1,
  t0.main_city_id AS main_city_id_2
FROM
  sector t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.main_city_id AS main_city_id_2 FROM sector t0 WHERE t0.id = 10357;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.latitude AS latitude_3,
  t0.longitude AS longitude_4,
  t0.rank AS rank_5,
  t0.country_id AS country_id_6
FROM
  city t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.latitude AS latitude_3, t0.longitude AS longitude_4, t0.rank AS rank_5, t0.country_id AS country_id_6 FROM city t0 WHERE t0.id = 1945;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.latitude AS latitude_3,
  t0.longitude AS longitude_4,
  t0.rank AS rank_5,
  t0.country_id AS country_id_6
FROM
  city t0
  INNER JOIN sector_city ON t0.id = sector_city.city_id
WHERE
  sector_city.sector_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.latitude AS latitude_3, t0.longitude AS longitude_4, t0.rank AS rank_5, t0.country_id AS country_id_6 FROM city t0 INNER JOIN sector_city ON t0.id = sector_city.city_id WHERE sector_city.sector_id = 10357;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.latitude AS latitude_3,
  t0.longitude AS longitude_4,
  t0.city_id AS city_id_5
FROM
  neighborhood t0
WHERE
  t0.city_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.latitude AS latitude_3, t0.longitude AS longitude_4, t0.city_id AS city_id_5 FROM neighborhood t0 WHERE t0.city_id = 1945;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.latitude AS latitude_3,
  t0.longitude AS longitude_4,
  t0.city_id AS city_id_5
FROM
  neighborhood t0
  INNER JOIN sector_neighborhood ON t0.id = sector_neighborhood.neighborhood_id
WHERE
  sector_neighborhood.sector_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.latitude AS latitude_3, t0.longitude AS longitude_4, t0.city_id AS city_id_5 FROM neighborhood t0 INNER JOIN sector_neighborhood ON t0.id = sector_neighborhood.neighborhood_id WHERE sector_neighborhood.sector_id = 10357;

SELECT
  t0.id AS id_1,
  t0.level AS level_2,
  t0.recurrence AS recurrence_3,
  t0.label AS label_4,
  t0.qualification_level_goal AS qualification_level_goal_5,
  t0.max_sponsorship_request AS max_sponsorship_request_6
FROM
  qualification_level t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.level AS level_2, t0.recurrence AS recurrence_3, t0.label AS label_4, t0.qualification_level_goal AS qualification_level_goal_5, t0.max_sponsorship_request AS max_sponsorship_request_6 FROM qualification_level t0 WHERE t0.id = 76;

SELECT
  t0.id AS id_1,
  t0.option_value AS option_value_2,
  t0.agent_id AS agent_id_3,
  t0.option_id AS option_id_4
FROM
  agents_options t0
WHERE
  t0.agent_id = ?

SELECT t0.id AS id_1, t0.option_value AS option_value_2, t0.agent_id AS agent_id_3, t0.option_id AS option_id_4 FROM agents_options t0 WHERE t0.agent_id = 3093;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.type AS type_3,
  t0.values AS values_4,
  t0.default_value AS default_value_5,
  t0.code AS code_6
FROM
  OPTION t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.values AS values_4, t0.default_value AS default_value_5, t0.code AS code_6 FROM OPTION t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.type AS type_3,
  t0.values AS values_4,
  t0.default_value AS default_value_5,
  t0.code AS code_6
FROM
  OPTION t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.values AS values_4, t0.default_value AS default_value_5, t0.code AS code_6 FROM OPTION t0 WHERE t0.id = 4;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.type AS type_3,
  t0.values AS values_4,
  t0.default_value AS default_value_5,
  t0.code AS code_6
FROM
  OPTION t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.values AS values_4, t0.default_value AS default_value_5, t0.code AS code_6 FROM OPTION t0 WHERE t0.id = 2;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.type AS type_3,
  t0.values AS values_4,
  t0.default_value AS default_value_5,
  t0.code AS code_6
FROM
  OPTION t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.values AS values_4, t0.default_value AS default_value_5, t0.code AS code_6 FROM OPTION t0 WHERE t0.id = 3;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3
FROM
  gender t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3 FROM gender t0 WHERE t0.id = 37;

SELECT
  t0.id AS id_1,
  t0.file_path AS file_path_2,
  t0.archived AS archived_3,
  t0.position AS position_4,
  t0.property_id AS property_id_5
FROM
  property_images t0
WHERE
  t0.property_id = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.file_path AS file_path_2, t0.archived AS archived_3, t0.position AS position_4, t0.property_id AS property_id_5 FROM property_images t0 WHERE t0.property_id = 10787 ORDER BY t0.position ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3
FROM
  reference_property_domain t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3 FROM reference_property_domain t0 WHERE t0.id = 27;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3
FROM
  reference_property_destination t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3 FROM reference_property_destination t0 WHERE t0.id = 41;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3,
  t0.rank AS rank_4
FROM
  reference_property_status t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.rank AS rank_4 FROM reference_property_status t0 WHERE t0.id = 107;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3,
  t0.rank AS rank_4
FROM
  reference_property_service_type t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.rank AS rank_4 FROM reference_property_service_type t0 WHERE t0.id = 43;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3
FROM
  reference_property_type t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3 FROM reference_property_type t0 WHERE t0.id = 53;

SELECT
  t0.id AS id_1,
  t0.local AS local_2,
  t0.content AS content_3,
  t0.property_id AS property_id_4
FROM
  property_description t0
WHERE
  t0.property_id = ?

SELECT t0.id AS id_1, t0.local AS local_2, t0.content AS content_3, t0.property_id AS property_id_4 FROM property_description t0 WHERE t0.property_id = 10787;

SELECT
  t1.id AS id_2,
  t1.first_name AS first_name_3,
  t1.last_name AS last_name_4,
  t1.email AS email_5,
  t1.professional_email AS professional_email_6,
  t1.birth_day AS birth_day_7,
  t1.phone AS phone_8,
  t1.main_phone AS main_phone_9,
  t1.roles AS roles_10,
  t1.password AS password_11,
  t1.last_connection AS last_connection_12,
  t1.person_type AS person_type_13,
  t1.created_at AS created_at_14,
  t1.updated_at AS updated_at_15,
  t0.cin AS cin_16,
  t0.is_recommender AS is_recommender_17,
  t0.cnss AS cnss_18,
  t0.rc AS rc_19,
  t0.professional_status AS professional_status_20,
  t0.subject_to_vat AS subject_to_vat_21,
  t0.created_qualifiqaution_date AS created_qualifiqaution_date_22,
  t0.company_name AS company_name_23,
  t0.common_company_identifier AS common_company_identifier_24,
  t1.address_id AS address_id_25,
  t1.gender_id AS gender_id_26,
  t1.reference_status_id AS reference_status_id_27,
  t1.reference_marital_status_id AS reference_marital_status_id_28,
  t0.qualification_level_id AS qualification_level_id_29,
  t0.sector_id AS sector_id_30,
  t0.manager_id AS manager_id_31,
  t0.status_id AS status_id_32,
  t0.sponsor_id AS sponsor_id_33,
  t0.nationality_id AS nationality_id_34,
  t1.type
FROM
  agent t0
  INNER JOIN abstract_collaborator t1 ON t0.id = t1.id
  INNER JOIN property_agent ON t0.id = property_agent.agent_id
WHERE
  property_agent.property_id = ?

SELECT t1.id AS id_2, t1.first_name AS first_name_3, t1.last_name AS last_name_4, t1.email AS email_5, t1.professional_email AS professional_email_6, t1.birth_day AS birth_day_7, t1.phone AS phone_8, t1.main_phone AS main_phone_9, t1.roles AS roles_10, t1.password AS password_11, t1.last_connection AS last_connection_12, t1.person_type AS person_type_13, t1.created_at AS created_at_14, t1.updated_at AS updated_at_15, t0.cin AS cin_16, t0.is_recommender AS is_recommender_17, t0.cnss AS cnss_18, t0.rc AS rc_19, t0.professional_status AS professional_status_20, t0.subject_to_vat AS subject_to_vat_21, t0.created_qualifiqaution_date AS created_qualifiqaution_date_22, t0.company_name AS company_name_23, t0.common_company_identifier AS common_company_identifier_24, t1.address_id AS address_id_25, t1.gender_id AS gender_id_26, t1.reference_status_id AS reference_status_id_27, t1.reference_marital_status_id AS reference_marital_status_id_28, t0.qualification_level_id AS qualification_level_id_29, t0.sector_id AS sector_id_30, t0.manager_id AS manager_id_31, t0.status_id AS status_id_32, t0.sponsor_id AS sponsor_id_33, t0.nationality_id AS nationality_id_34, t1.type FROM agent t0 INNER JOIN abstract_collaborator t1 ON t0.id = t1.id INNER JOIN property_agent ON t0.id = property_agent.agent_id WHERE property_agent.property_id = 10787;

SELECT
  t0.id AS id_1,
  t0.first_address AS first_address_2,
  t0.second_address AS second_address_3,
  t0.zip_code AS zip_code_4,
  t0.city_id AS city_id_5,
  t6.id AS id_7,
  t6.maximal_area AS maximal_area_8,
  t6.minimal_area AS minimal_area_9,
  t6.minimal_price AS minimal_price_10,
  t6.maximum_price AS maximum_price_11,
  t6.rooms_number AS rooms_number_12,
  t6.is_available AS is_available_13,
  t6.date_availability AS date_availability_14,
  t6.construction_year AS construction_year_15,
  t6.floors_number AS floors_number_16,
  t6.is_furnished AS is_furnished_17,
  t6.has_guardian AS has_guardian_18,
  t6.has_intercom AS has_intercom_19,
  t6.has_elevator AS has_elevator_20,
  t6.has_terrace AS has_terrace_21,
  t6.has_balcony AS has_balcony_22,
  t6.has_garage AS has_garage_23,
  t6.has_park_car AS has_park_car_24,
  t6.has_park_car_outside AS has_park_car_outside_25,
  t6.has_cellar AS has_cellar_26,
  t6.has_basement AS has_basement_27,
  t6.has_bathroom AS has_bathroom_28,
  t6.description AS description_29,
  t6.archived_at AS archived_at_30,
  t6.property_title_number AS property_title_number_31,
  t6.booking_number AS booking_number_32,
  t6.floor AS floor_33,
  t6.bathroom_number AS bathroom_number_34,
  t6.number_of_rooms AS number_of_rooms_35,
  t6.number_of_pieces AS number_of_pieces_36,
  t6.reference AS reference_37,
  t6.is_shared AS is_shared_38,
  t6.has_titled_parking AS has_titled_parking_39,
  t6.parking_area AS parking_area_40,
  t6.has_mezzanine AS has_mezzanine_41,
  t6.mezzanine_area AS mezzanine_area_42,
  t6.description_mandate AS description_mandate_43,
  t6.is_short_term_rental AS is_short_term_rental_44,
  t6.date_start_rental AS date_start_rental_45,
  t6.date_end_rental AS date_end_rental_46,
  t6.video_link AS video_link_47,
  t6.created_at AS created_at_48,
  t6.updated_at AS updated_at_49,
  t6.property_address_id AS property_address_id_50,
  t6.collaborator_id AS collaborator_id_51,
  t6.contact_id AS contact_id_52,
  t6.prescriber_id AS prescriber_id_53,
  t6.manager_id AS manager_id_54,
  t6.reference_property_domain_id AS reference_property_domain_id_55,
  t6.refrence_property_state_id AS refrence_property_state_id_56,
  t6.reference_property_contract_type_id AS reference_property_contract_type_id_57,
  t6.reference_property_land_type_id AS reference_property_land_type_id_58,
  t6.reference_property_destination_id AS reference_property_destination_id_59,
  t6.reference_property_construction_type_id AS reference_property_construction_type_id_60,
  t6.reference_property_orientation_type_id AS reference_property_orientation_type_id_61,
  t6.reference_property_status_id AS reference_property_status_id_62,
  t6.reference_service_type_id AS reference_service_type_id_63,
  t6.reference_property_type_id AS reference_property_type_id_64,
  t6.recommendation_id AS recommendation_id_65,
  t0.neighborhood_id AS neighborhood_id_66
FROM
  property_address t0
  LEFT JOIN property t6 ON t6.property_address_id = t0.id
WHERE
  t0.id = ?