Symfony Profiler

SELECT
  t0.id AS id_5,
  t0.first_name AS first_name_6,
  t0.last_name AS last_name_7,
  t0.email AS email_8,
  t0.professional_email AS professional_email_9,
  t0.birth_day AS birth_day_10,
  t0.phone AS phone_11,
  t0.main_phone AS main_phone_12,
  t0.roles AS roles_13,
  t0.password AS password_14,
  t0.last_connection AS last_connection_15,
  t0.person_type AS person_type_16,
  t0.created_at AS created_at_17,
  t0.updated_at AS updated_at_18,
  t0.address_id AS address_id_19,
  t0.gender_id AS gender_id_20,
  t0.reference_status_id AS reference_status_id_21,
  t0.reference_marital_status_id AS reference_marital_status_id_22,
  t0.type,
  t1.cin AS cin_23,
  t1.is_recommender AS is_recommender_24,
  t1.cnss AS cnss_25,
  t1.rc AS rc_26,
  t1.professional_status AS professional_status_27,
  t1.subject_to_vat AS subject_to_vat_28,
  t1.created_qualifiqaution_date AS created_qualifiqaution_date_29,
  t1.company_name AS company_name_30,
  t1.common_company_identifier AS common_company_identifier_31,
  t1.qualification_level_id AS qualification_level_id_32,
  t1.sector_id AS sector_id_33,
  t1.manager_id AS manager_id_34,
  t1.status_id AS status_id_35,
  t1.sponsor_id AS sponsor_id_36,
  t1.nationality_id AS nationality_id_37,
  t2.count_agent_assignment_number AS count_agent_assignment_number_38
FROM
  abstract_collaborator t0
  LEFT JOIN agent t1 ON t0.id = t1.id
  LEFT JOIN manager t2 ON t0.id = t2.id
  LEFT JOIN manager_back_office t3 ON t0.id = t3.id
  LEFT JOIN manager_it t4 ON t0.id = t4.id
WHERE
  t0.professional_email = ?
LIMIT
  1

SELECT t0.id AS id_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.email AS email_8, t0.professional_email AS professional_email_9, t0.birth_day AS birth_day_10, t0.phone AS phone_11, t0.main_phone AS main_phone_12, t0.roles AS roles_13, t0.password AS password_14, t0.last_connection AS last_connection_15, t0.person_type AS person_type_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.address_id AS address_id_19, t0.gender_id AS gender_id_20, t0.reference_status_id AS reference_status_id_21, t0.reference_marital_status_id AS reference_marital_status_id_22, t0.type, t1.cin AS cin_23, t1.is_recommender AS is_recommender_24, t1.cnss AS cnss_25, t1.rc AS rc_26, t1.professional_status AS professional_status_27, t1.subject_to_vat AS subject_to_vat_28, t1.created_qualifiqaution_date AS created_qualifiqaution_date_29, t1.company_name AS company_name_30, t1.common_company_identifier AS common_company_identifier_31, t1.qualification_level_id AS qualification_level_id_32, t1.sector_id AS sector_id_33, t1.manager_id AS manager_id_34, t1.status_id AS status_id_35, t1.sponsor_id AS sponsor_id_36, t1.nationality_id AS nationality_id_37, t2.count_agent_assignment_number AS count_agent_assignment_number_38 FROM abstract_collaborator t0 LEFT JOIN agent t1 ON t0.id = t1.id LEFT JOIN manager t2 ON t0.id = t2.id LEFT JOIN manager_back_office t3 ON t0.id = t3.id LEFT JOIN manager_it t4 ON t0.id = t4.id WHERE t0.professional_email = 'manager.20@milkiya.ma' LIMIT 1;

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

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

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_
WHERE
  p0_.id = ?

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_ WHERE p0_.id = 3849;

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

SELECT
  a0_.id AS id_0,
  a0_.first_name AS first_name_1,
  a0_.last_name AS last_name_2,
  a0_.email AS email_3,
  a0_.professional_email AS professional_email_4,
  a0_.birth_day AS birth_day_5,
  a0_.phone AS phone_6,
  a0_.main_phone AS main_phone_7,
  a0_.roles AS roles_8,
  a0_.password AS password_9,
  a0_.last_connection AS last_connection_10,
  a0_.person_type AS person_type_11,
  a0_.created_at AS created_at_12,
  a0_.updated_at AS updated_at_13,
  a1_.cin AS cin_14,
  a1_.is_recommender AS is_recommender_15,
  a1_.cnss AS cnss_16,
  a1_.rc AS rc_17,
  a1_.professional_status AS professional_status_18,
  a1_.subject_to_vat AS subject_to_vat_19,
  a1_.created_qualifiqaution_date AS created_qualifiqaution_date_20,
  a1_.company_name AS company_name_21,
  a1_.common_company_identifier AS common_company_identifier_22,
  a0_.type AS type_23,
  a0_.address_id AS address_id_24,
  a0_.gender_id AS gender_id_25,
  a0_.reference_status_id AS reference_status_id_26,
  a0_.reference_marital_status_id AS reference_marital_status_id_27,
  a1_.qualification_level_id AS qualification_level_id_28,
  a1_.sector_id AS sector_id_29,
  a1_.manager_id AS manager_id_30,
  a1_.status_id AS status_id_31,
  a1_.sponsor_id AS sponsor_id_32,
  a1_.nationality_id AS nationality_id_33
FROM
  agent a1_
  INNER JOIN abstract_collaborator a0_ ON a1_.id = a0_.id
WHERE
  a0_.id = ?

SELECT a0_.id AS id_0, a0_.first_name AS first_name_1, a0_.last_name AS last_name_2, a0_.email AS email_3, a0_.professional_email AS professional_email_4, a0_.birth_day AS birth_day_5, a0_.phone AS phone_6, a0_.main_phone AS main_phone_7, a0_.roles AS roles_8, a0_.password AS password_9, a0_.last_connection AS last_connection_10, a0_.person_type AS person_type_11, a0_.created_at AS created_at_12, a0_.updated_at AS updated_at_13, a1_.cin AS cin_14, a1_.is_recommender AS is_recommender_15, a1_.cnss AS cnss_16, a1_.rc AS rc_17, a1_.professional_status AS professional_status_18, a1_.subject_to_vat AS subject_to_vat_19, a1_.created_qualifiqaution_date AS created_qualifiqaution_date_20, a1_.company_name AS company_name_21, a1_.common_company_identifier AS common_company_identifier_22, a0_.type AS type_23, a0_.address_id AS address_id_24, a0_.gender_id AS gender_id_25, a0_.reference_status_id AS reference_status_id_26, a0_.reference_marital_status_id AS reference_marital_status_id_27, a1_.qualification_level_id AS qualification_level_id_28, a1_.sector_id AS sector_id_29, a1_.manager_id AS manager_id_30, a1_.status_id AS status_id_31, a1_.sponsor_id AS sponsor_id_32, a1_.nationality_id AS nationality_id_33 FROM agent a1_ INNER JOIN abstract_collaborator a0_ ON a1_.id = a0_.id WHERE a0_.id = 62;

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

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

SELECT
  r0_.id AS id_0,
  r0_.name AS name_1,
  r0_.code AS code_2,
  r0_.rank AS rank_3
FROM
  reference_property_status r0_
WHERE
  r0_.id = ?

SELECT r0_.id AS id_0, r0_.name AS name_1, r0_.code AS code_2, r0_.rank AS rank_3 FROM reference_property_status r0_ WHERE r0_.id = 37;

SELECT
  r0_.id AS id_0,
  r0_.name AS name_1,
  r0_.code AS code_2,
  r0_.rank AS rank_3
FROM
  reference_property_service_type r0_
WHERE
  r0_.id = ?

SELECT r0_.id AS id_0, r0_.name AS name_1, r0_.code AS code_2, r0_.rank AS rank_3 FROM reference_property_service_type r0_ WHERE r0_.id = 17;

SELECT
  r0_.id AS id_0,
  r0_.name AS name_1,
  r0_.code AS code_2
FROM
  reference_property_domain r0_
WHERE
  r0_.id = ?

SELECT r0_.id AS id_0, r0_.name AS name_1, r0_.code AS code_2 FROM reference_property_domain r0_ WHERE r0_.id = 12;

SELECT
  r0_.id AS id_0,
  r0_.name AS name_1,
  r0_.code AS code_2
FROM
  reference_property_destination r0_
WHERE
  r0_.id = ?

SELECT r0_.id AS id_0, r0_.name AS name_1, r0_.code AS code_2 FROM reference_property_destination r0_ WHERE r0_.id = 17;

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.latitude AS latitude_2,
  c0_.longitude AS longitude_3,
  c0_.rank AS rank_4,
  c0_.country_id AS country_id_5
FROM
  city c0_
WHERE
  c0_.id = ?

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.latitude AS latitude_2, c0_.longitude AS longitude_3, c0_.rank AS rank_4, c0_.country_id AS country_id_5 FROM city c0_ WHERE c0_.id = 816;

SELECT
  r0_.id AS id_0,
  r0_.name AS name_1,
  r0_.code AS code_2
FROM
  reference_property_construction_type r0_
WHERE
  r0_.id = ?

SELECT r0_.id AS id_0, r0_.name AS name_1, r0_.code AS code_2 FROM reference_property_construction_type r0_ WHERE r0_.id = 24;

SELECT
  r0_.id AS id_0,
  r0_.name AS name_1,
  r0_.code AS code_2
FROM
  reference_property_state r0_
WHERE
  r0_.id = ?

SELECT r0_.id AS id_0, r0_.name AS name_1, r0_.code AS code_2 FROM reference_property_state r0_ WHERE r0_.id = 33;

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.code AS code_2
FROM
  property_diffusion_mode_reference p0_
WHERE
  p0_.id = ?

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.code AS code_2 FROM property_diffusion_mode_reference p0_ WHERE p0_.id = 29;

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.code AS code_2
FROM
  property_diffusion_mode_reference p0_
WHERE
  p0_.id = ?

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.code AS code_2 FROM property_diffusion_mode_reference p0_ WHERE p0_.id = 30;

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.code AS code_2
FROM
  property_diffusion_mode_reference p0_
WHERE
  p0_.id = ?

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.code AS code_2 FROM property_diffusion_mode_reference p0_ WHERE p0_.id = 31;

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.code AS code_2
FROM
  property_diffusion_mode_reference p0_
WHERE
  p0_.id = ?

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.code AS code_2 FROM property_diffusion_mode_reference p0_ WHERE p0_.id = 32;

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.code AS code_2
FROM
  property_diffusion_mode_reference p0_
WHERE
  p0_.id = ?

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.code AS code_2 FROM property_diffusion_mode_reference p0_ WHERE p0_.id = 33;

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.code AS code_2
FROM
  property_diffusion_mode_reference p0_
WHERE
  p0_.id = ?

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.code AS code_2 FROM property_diffusion_mode_reference p0_ WHERE p0_.id = 34;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3
FROM
  property_diffusion_mode_reference t0
  INNER JOIN property_property_diffusion_mode_reference ON t0.id = property_property_diffusion_mode_reference.property_diffusion_mode_reference_id
WHERE
  property_property_diffusion_mode_reference.property_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3 FROM property_diffusion_mode_reference t0 INNER JOIN property_property_diffusion_mode_reference ON t0.id = property_property_diffusion_mode_reference.property_diffusion_mode_reference_id WHERE property_property_diffusion_mode_reference.property_id = 3849;

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

SELECT
  a0_.id AS id_0,
  a0_.first_name AS first_name_1,
  a0_.last_name AS last_name_2,
  a0_.cin AS cin_3,
  a0_.email AS email_4,
  a0_.birth_day AS birth_day_5,
  a0_.phone AS phone_6,
  a0_.main_phone AS main_phone_7,
  a0_.roles AS roles_8,
  a0_.company_name AS company_name_9,
  a0_.common_company_identifier AS common_company_identifier_10,
  a0_.rc AS rc_11,
  a0_.person_type AS person_type_12,
  a0_.created_at AS created_at_13,
  a0_.updated_at AS updated_at_14,
  c1_.is_business_indication AS is_business_indication_15,
  c1_.is_preoccupation AS is_preoccupation_16,
  a0_.type AS type_17,
  a0_.address_id AS address_id_18,
  a0_.gender_id AS gender_id_19,
  a0_.reference_marital_status_id AS reference_marital_status_id_20,
  c1_.collaborator_id AS collaborator_id_21,
  c1_.contact_type_reference_id AS contact_type_reference_id_22,
  c1_.recommender_id AS recommender_id_23,
  c1_.proxy_contact_id AS proxy_contact_id_24
FROM
  contact c1_
  INNER JOIN abstract_people a0_ ON c1_.id = a0_.id
WHERE
  a0_.id = ?

SELECT a0_.id AS id_0, a0_.first_name AS first_name_1, a0_.last_name AS last_name_2, a0_.cin AS cin_3, a0_.email AS email_4, a0_.birth_day AS birth_day_5, a0_.phone AS phone_6, a0_.main_phone AS main_phone_7, a0_.roles AS roles_8, a0_.company_name AS company_name_9, a0_.common_company_identifier AS common_company_identifier_10, a0_.rc AS rc_11, a0_.person_type AS person_type_12, a0_.created_at AS created_at_13, a0_.updated_at AS updated_at_14, c1_.is_business_indication AS is_business_indication_15, c1_.is_preoccupation AS is_preoccupation_16, a0_.type AS type_17, a0_.address_id AS address_id_18, a0_.gender_id AS gender_id_19, a0_.reference_marital_status_id AS reference_marital_status_id_20, c1_.collaborator_id AS collaborator_id_21, c1_.contact_type_reference_id AS contact_type_reference_id_22, c1_.recommender_id AS recommender_id_23, c1_.proxy_contact_id AS proxy_contact_id_24 FROM contact c1_ INNER JOIN abstract_people a0_ ON c1_.id = a0_.id WHERE a0_.id = 2592;

SELECT
  r0_.id AS id_0,
  r0_.name AS name_1,
  r0_.code AS code_2
FROM
  reference_property_type r0_
WHERE
  r0_.id = ?

SELECT r0_.id AS id_0, r0_.name AS name_1, r0_.code AS code_2 FROM reference_property_type r0_ WHERE r0_.id = 24;

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

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

SELECT
  NEXTVAL('property_address_id_seq')

SELECT NEXTVAL('property_address_id_seq');

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO property_address (
  id, first_address, second_address,
  zip_code, city_id, neighborhood_id
)
VALUES
  (?, ?, ?, ?, ?, ?)

INSERT INTO property_address (id, first_address, second_address, zip_code, city_id, neighborhood_id) VALUES (6993, 'Sidi rahal', NULL, NULL, 816, NULL);

UPDATE
  property
SET
  property_address_id = ?,
  updated_at = ?
WHERE
  id = ?

UPDATE property SET property_address_id = 6993, updated_at = '2025-01-21' WHERE id = 3849;

"COMMIT"

"COMMIT";

SELECT
  t0.id AS id_1,
  t0.maximal_area AS maximal_area_2,
  t0.minimal_area AS minimal_area_3,
  t0.minimal_price AS minimal_price_4,
  t0.maximum_price AS maximum_price_5,
  t0.rooms_number AS rooms_number_6,
  t0.is_available AS is_available_7,
  t0.date_availability AS date_availability_8,
  t0.construction_year AS construction_year_9,
  t0.floors_number AS floors_number_10,
  t0.is_furnished AS is_furnished_11,
  t0.has_guardian AS has_guardian_12,
  t0.has_intercom AS has_intercom_13,
  t0.has_elevator AS has_elevator_14,
  t0.has_terrace AS has_terrace_15,
  t0.has_balcony AS has_balcony_16,
  t0.has_garage AS has_garage_17,
  t0.has_park_car AS has_park_car_18,
  t0.has_park_car_outside AS has_park_car_outside_19,
  t0.has_cellar AS has_cellar_20,
  t0.has_basement AS has_basement_21,
  t0.has_bathroom AS has_bathroom_22,
  t0.description AS description_23,
  t0.archived_at AS archived_at_24,
  t0.property_title_number AS property_title_number_25,
  t0.booking_number AS booking_number_26,
  t0.floor AS floor_27,
  t0.bathroom_number AS bathroom_number_28,
  t0.number_of_rooms AS number_of_rooms_29,
  t0.number_of_pieces AS number_of_pieces_30,
  t0.reference AS reference_31,
  t0.is_shared AS is_shared_32,
  t0.has_titled_parking AS has_titled_parking_33,
  t0.parking_area AS parking_area_34,
  t0.has_mezzanine AS has_mezzanine_35,
  t0.mezzanine_area AS mezzanine_area_36,
  t0.description_mandate AS description_mandate_37,
  t0.is_short_term_rental AS is_short_term_rental_38,
  t0.date_start_rental AS date_start_rental_39,
  t0.date_end_rental AS date_end_rental_40,
  t0.video_link AS video_link_41,
  t0.created_at AS created_at_42,
  t0.updated_at AS updated_at_43,
  t0.property_address_id AS property_address_id_44,
  t0.collaborator_id AS collaborator_id_45,
  t0.contact_id AS contact_id_46,
  t0.prescriber_id AS prescriber_id_47,
  t0.manager_id AS manager_id_48,
  t0.reference_property_domain_id AS reference_property_domain_id_49,
  t0.refrence_property_state_id AS refrence_property_state_id_50,
  t0.reference_property_contract_type_id AS reference_property_contract_type_id_51,
  t0.reference_property_land_type_id AS reference_property_land_type_id_52,
  t0.reference_property_destination_id AS reference_property_destination_id_53,
  t0.reference_property_construction_type_id AS reference_property_construction_type_id_54,
  t0.reference_property_orientation_type_id AS reference_property_orientation_type_id_55,
  t0.reference_property_status_id AS reference_property_status_id_56,
  t0.reference_service_type_id AS reference_service_type_id_57,
  t0.reference_property_type_id AS reference_property_type_id_58,
  t0.recommendation_id AS recommendation_id_59
FROM
  property t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.maximal_area AS maximal_area_2, t0.minimal_area AS minimal_area_3, t0.minimal_price AS minimal_price_4, t0.maximum_price AS maximum_price_5, t0.rooms_number AS rooms_number_6, t0.is_available AS is_available_7, t0.date_availability AS date_availability_8, t0.construction_year AS construction_year_9, t0.floors_number AS floors_number_10, t0.is_furnished AS is_furnished_11, t0.has_guardian AS has_guardian_12, t0.has_intercom AS has_intercom_13, t0.has_elevator AS has_elevator_14, t0.has_terrace AS has_terrace_15, t0.has_balcony AS has_balcony_16, t0.has_garage AS has_garage_17, t0.has_park_car AS has_park_car_18, t0.has_park_car_outside AS has_park_car_outside_19, t0.has_cellar AS has_cellar_20, t0.has_basement AS has_basement_21, t0.has_bathroom AS has_bathroom_22, t0.description AS description_23, t0.archived_at AS archived_at_24, t0.property_title_number AS property_title_number_25, t0.booking_number AS booking_number_26, t0.floor AS floor_27, t0.bathroom_number AS bathroom_number_28, t0.number_of_rooms AS number_of_rooms_29, t0.number_of_pieces AS number_of_pieces_30, t0.reference AS reference_31, t0.is_shared AS is_shared_32, t0.has_titled_parking AS has_titled_parking_33, t0.parking_area AS parking_area_34, t0.has_mezzanine AS has_mezzanine_35, t0.mezzanine_area AS mezzanine_area_36, t0.description_mandate AS description_mandate_37, t0.is_short_term_rental AS is_short_term_rental_38, t0.date_start_rental AS date_start_rental_39, t0.date_end_rental AS date_end_rental_40, t0.video_link AS video_link_41, t0.created_at AS created_at_42, t0.updated_at AS updated_at_43, t0.property_address_id AS property_address_id_44, t0.collaborator_id AS collaborator_id_45, t0.contact_id AS contact_id_46, t0.prescriber_id AS prescriber_id_47, t0.manager_id AS manager_id_48, t0.reference_property_domain_id AS reference_property_domain_id_49, t0.refrence_property_state_id AS refrence_property_state_id_50, t0.reference_property_contract_type_id AS reference_property_contract_type_id_51, t0.reference_property_land_type_id AS reference_property_land_type_id_52, t0.reference_property_destination_id AS reference_property_destination_id_53, t0.reference_property_construction_type_id AS reference_property_construction_type_id_54, t0.reference_property_orientation_type_id AS reference_property_orientation_type_id_55, t0.reference_property_status_id AS reference_property_status_id_56, t0.reference_service_type_id AS reference_service_type_id_57, t0.reference_property_type_id AS reference_property_type_id_58, t0.recommendation_id AS recommendation_id_59 FROM property t0 WHERE t0.id = 3849;