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
  m0_.id AS id_0,
  m0_.maximum_price AS maximum_price_1,
  m0_.minimal_area AS minimal_area_2,
  m0_.maximal_area AS maximal_area_3,
  m0_.key AS key_4,
  m0_.commission AS commission_5,
  m0_.is_free_entry AS is_free_entry_6,
  m0_.commission_percent AS commission_percent_7,
  m0_.duration AS duration_8,
  m0_.exclusive_duration AS exclusive_duration_9,
  m0_.is_additional_property AS is_additional_property_10,
  m0_.reference_vat AS reference_vat_11,
  m0_.commission_recommender_percent AS commission_recommender_percent_12,
  m0_.esign AS esign_13,
  m0_.created_at AS created_at_14,
  m0_.updated_at AS updated_at_15,
  m0_.property_id AS property_id_16,
  m0_.reference_mandate_type_id AS reference_mandate_type_id_17,
  m0_.reference_mandate_status_id AS reference_mandate_status_id_18,
  m0_.reference_property_type_id AS reference_property_type_id_19
FROM
  mandate m0_
WHERE
  m0_.id = ?

SELECT m0_.id AS id_0, m0_.maximum_price AS maximum_price_1, m0_.minimal_area AS minimal_area_2, m0_.maximal_area AS maximal_area_3, m0_.key AS key_4, m0_.commission AS commission_5, m0_.is_free_entry AS is_free_entry_6, m0_.commission_percent AS commission_percent_7, m0_.duration AS duration_8, m0_.exclusive_duration AS exclusive_duration_9, m0_.is_additional_property AS is_additional_property_10, m0_.reference_vat AS reference_vat_11, m0_.commission_recommender_percent AS commission_recommender_percent_12, m0_.esign AS esign_13, m0_.created_at AS created_at_14, m0_.updated_at AS updated_at_15, m0_.property_id AS property_id_16, m0_.reference_mandate_type_id AS reference_mandate_type_id_17, m0_.reference_mandate_status_id AS reference_mandate_status_id_18, m0_.reference_property_type_id AS reference_property_type_id_19 FROM mandate m0_ WHERE m0_.id = 611;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3,
  t0.rank AS rank_4
FROM
  reference_mandate_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_mandate_status t0 WHERE t0.id = 46;

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

SELECT
  t1.id AS id_2,
  t1.first_name AS first_name_3,
  t1.last_name AS last_name_4,
  t1.cin AS cin_5,
  t1.email AS 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.company_name AS company_name_11,
  t1.common_company_identifier AS common_company_identifier_12,
  t1.rc AS rc_13,
  t1.person_type AS person_type_14,
  t1.created_at AS created_at_15,
  t1.updated_at AS updated_at_16,
  t0.is_business_indication AS is_business_indication_17,
  t0.is_preoccupation AS is_preoccupation_18,
  t1.address_id AS address_id_19,
  t1.gender_id AS gender_id_20,
  t1.reference_marital_status_id AS reference_marital_status_id_21,
  t0.collaborator_id AS collaborator_id_22,
  t0.contact_type_reference_id AS contact_type_reference_id_23,
  t0.recommender_id AS recommender_id_24,
  t0.proxy_contact_id AS proxy_contact_id_25,
  t1.type
FROM
  contact t0
  INNER JOIN abstract_people 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.cin AS cin_5, t1.email AS 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.company_name AS company_name_11, t1.common_company_identifier AS common_company_identifier_12, t1.rc AS rc_13, t1.person_type AS person_type_14, t1.created_at AS created_at_15, t1.updated_at AS updated_at_16, t0.is_business_indication AS is_business_indication_17, t0.is_preoccupation AS is_preoccupation_18, t1.address_id AS address_id_19, t1.gender_id AS gender_id_20, t1.reference_marital_status_id AS reference_marital_status_id_21, t0.collaborator_id AS collaborator_id_22, t0.contact_type_reference_id AS contact_type_reference_id_23, t0.recommender_id AS recommender_id_24, t0.proxy_contact_id AS proxy_contact_id_25, t1.type FROM contact t0 INNER JOIN abstract_people t1 ON t0.id = t1.id WHERE t1.id = 2832;

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

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

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

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
  INNER JOIN mandate_property ON t0.id = mandate_property.property_id
WHERE
  mandate_property.mandate_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 INNER JOIN mandate_property ON t0.id = mandate_property.property_id WHERE mandate_property.mandate_id = 611;

SELECT
  t1.id AS id_2,
  t1.first_name AS first_name_3,
  t1.last_name AS last_name_4,
  t1.cin AS cin_5,
  t1.email AS 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.company_name AS company_name_11,
  t1.common_company_identifier AS common_company_identifier_12,
  t1.rc AS rc_13,
  t1.person_type AS person_type_14,
  t1.created_at AS created_at_15,
  t1.updated_at AS updated_at_16,
  t0.is_business_indication AS is_business_indication_17,
  t0.is_preoccupation AS is_preoccupation_18,
  t1.address_id AS address_id_19,
  t1.gender_id AS gender_id_20,
  t1.reference_marital_status_id AS reference_marital_status_id_21,
  t0.collaborator_id AS collaborator_id_22,
  t0.contact_type_reference_id AS contact_type_reference_id_23,
  t0.recommender_id AS recommender_id_24,
  t0.proxy_contact_id AS proxy_contact_id_25,
  t1.type
FROM
  contact t0
  INNER JOIN abstract_people t1 ON t0.id = t1.id
  INNER JOIN mandate_contact ON t0.id = mandate_contact.contact_id
WHERE
  mandate_contact.mandate_id = ?

SELECT t1.id AS id_2, t1.first_name AS first_name_3, t1.last_name AS last_name_4, t1.cin AS cin_5, t1.email AS 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.company_name AS company_name_11, t1.common_company_identifier AS common_company_identifier_12, t1.rc AS rc_13, t1.person_type AS person_type_14, t1.created_at AS created_at_15, t1.updated_at AS updated_at_16, t0.is_business_indication AS is_business_indication_17, t0.is_preoccupation AS is_preoccupation_18, t1.address_id AS address_id_19, t1.gender_id AS gender_id_20, t1.reference_marital_status_id AS reference_marital_status_id_21, t0.collaborator_id AS collaborator_id_22, t0.contact_type_reference_id AS contact_type_reference_id_23, t0.recommender_id AS recommender_id_24, t0.proxy_contact_id AS proxy_contact_id_25, t1.type FROM contact t0 INNER JOIN abstract_people t1 ON t0.id = t1.id INNER JOIN mandate_contact ON t0.id = mandate_contact.contact_id WHERE mandate_contact.mandate_id = 611;

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

SELECT
  t0.id AS id_1,
  t0.maximum_price AS maximum_price_2,
  t0.minimal_area AS minimal_area_3,
  t0.maximal_area AS maximal_area_4,
  t0.key AS key_5,
  t0.commission AS commission_6,
  t0.is_free_entry AS is_free_entry_7,
  t0.commission_percent AS commission_percent_8,
  t0.duration AS duration_9,
  t0.exclusive_duration AS exclusive_duration_10,
  t0.is_additional_property AS is_additional_property_11,
  t0.reference_vat AS reference_vat_12,
  t0.commission_recommender_percent AS commission_recommender_percent_13,
  t0.esign AS esign_14,
  t0.created_at AS created_at_15,
  t0.updated_at AS updated_at_16,
  t0.property_id AS property_id_17,
  t0.reference_mandate_type_id AS reference_mandate_type_id_18,
  t0.reference_mandate_status_id AS reference_mandate_status_id_19,
  t0.reference_property_type_id AS reference_property_type_id_20
FROM
  mandate t0
WHERE
  t0.property_id = ?

SELECT t0.id AS id_1, t0.maximum_price AS maximum_price_2, t0.minimal_area AS minimal_area_3, t0.maximal_area AS maximal_area_4, t0.key AS key_5, t0.commission AS commission_6, t0.is_free_entry AS is_free_entry_7, t0.commission_percent AS commission_percent_8, t0.duration AS duration_9, t0.exclusive_duration AS exclusive_duration_10, t0.is_additional_property AS is_additional_property_11, t0.reference_vat AS reference_vat_12, t0.commission_recommender_percent AS commission_recommender_percent_13, t0.esign AS esign_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.property_id AS property_id_17, t0.reference_mandate_type_id AS reference_mandate_type_id_18, t0.reference_mandate_status_id AS reference_mandate_status_id_19, t0.reference_property_type_id AS reference_property_type_id_20 FROM mandate t0 WHERE t0.property_id = 4127;

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  mandate
SET
  commission = ?,
  reference_vat = ?,
  commission_recommender_percent = ?,
  updated_at = ?
WHERE
  id = ?

UPDATE mandate SET commission = 18062.5, reference_vat = 'NONE', commission_recommender_percent = 12, updated_at = '2025-02-05' WHERE id = 611;

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

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.rank AS rank_4 FROM reference_mandate_status t0 WHERE t0.code = 'ARCHIVED' LIMIT 1;

INSERT INTO mandate_property (mandate_id, property_id)
VALUES
  (?, ?)

INSERT INTO mandate_property (mandate_id, property_id) VALUES (611, 4127);

"COMMIT"

"COMMIT";

SELECT
  t0.id AS id_1,
  t0.maximum_price AS maximum_price_2,
  t0.minimal_area AS minimal_area_3,
  t0.maximal_area AS maximal_area_4,
  t0.key AS key_5,
  t0.commission AS commission_6,
  t0.is_free_entry AS is_free_entry_7,
  t0.commission_percent AS commission_percent_8,
  t0.duration AS duration_9,
  t0.exclusive_duration AS exclusive_duration_10,
  t0.is_additional_property AS is_additional_property_11,
  t0.reference_vat AS reference_vat_12,
  t0.commission_recommender_percent AS commission_recommender_percent_13,
  t0.esign AS esign_14,
  t0.created_at AS created_at_15,
  t0.updated_at AS updated_at_16,
  t0.property_id AS property_id_17,
  t0.reference_mandate_type_id AS reference_mandate_type_id_18,
  t0.reference_mandate_status_id AS reference_mandate_status_id_19,
  t0.reference_property_type_id AS reference_property_type_id_20
FROM
  mandate t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.maximum_price AS maximum_price_2, t0.minimal_area AS minimal_area_3, t0.maximal_area AS maximal_area_4, t0.key AS key_5, t0.commission AS commission_6, t0.is_free_entry AS is_free_entry_7, t0.commission_percent AS commission_percent_8, t0.duration AS duration_9, t0.exclusive_duration AS exclusive_duration_10, t0.is_additional_property AS is_additional_property_11, t0.reference_vat AS reference_vat_12, t0.commission_recommender_percent AS commission_recommender_percent_13, t0.esign AS esign_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.property_id AS property_id_17, t0.reference_mandate_type_id AS reference_mandate_type_id_18, t0.reference_mandate_status_id AS reference_mandate_status_id_19, t0.reference_property_type_id AS reference_property_type_id_20 FROM mandate t0 WHERE t0.id = 611;