Symfony Profiler

"COMMIT"

"COMMIT";

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.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
  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 = 6946;

SELECT
  t0.id AS id_1,
  t0.first_address AS first_address_2,
  t0.second_address AS second_address_3,
  t0.contact_city AS contact_city_4,
  t0.zip_code AS zip_code_5,
  t0.city_id AS city_id_6,
  t0.country_id AS country_id_7
FROM
  address t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.first_address AS first_address_2, t0.second_address AS second_address_3, t0.contact_city AS contact_city_4, t0.zip_code AS zip_code_5, t0.city_id AS city_id_6, t0.country_id AS country_id_7 FROM address t0 WHERE t0.id = 12409;

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

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
  t0.id AS id_2,
  t0.buyer_commission AS buyer_commission_3,
  t0.total AS total_4,
  t0.sell_price_with_tax AS sell_price_with_tax_5,
  t0.fees_with_tax AS fees_with_tax_6,
  t0.fees_without_tax AS fees_without_tax_7,
  t0.under_comprise_at AS under_comprise_at_8,
  t0.valide_at AS valide_at_9,
  t0.recorded_at AS recorded_at_10,
  t0.paid_at AS paid_at_11,
  t0.canceled_at AS canceled_at_12,
  t0.expected_date_of_compromise AS expected_date_of_compromise_13,
  t0.invoice_number AS invoice_number_14,
  t0.invoice_date AS invoice_date_15,
  t0.property_value AS property_value_16,
  t0.advance AS advance_17,
  t0.apport AS apport_18,
  t0.created_at AS created_at_19,
  t0.updated_at AS updated_at_20,
  t1.seller_commission AS seller_commission_21,
  t1.rental_start_date AS rental_start_date_22,
  t1.signature_act_date AS signature_act_date_23,
  t1.payment_date AS payment_date_24,
  t1.disbursement_date AS disbursement_date_25,
  t1.cancellation_date AS cancellation_date_26,
  t1.edit_rental_contract_date AS edit_rental_contract_date_27,
  t1.signature_rental_contract_date AS signature_rental_contract_date_28,
  t1.refusal_date AS refusal_date_29,
  t1.rental_end_date AS rental_end_date_30,
  t1.rental_price AS rental_price_31,
  t0.mandate_id AS mandate_id_32,
  t0.reference_transaction_status_id AS reference_transaction_status_id_33,
  t0.reference_commission_paid_by_id AS reference_commission_paid_by_id_34,
  t0.input_agent_id AS input_agent_id_35,
  t0.output_agent_id AS output_agent_id_36,
  t0.vat_id AS vat_id_37,
  t0.contact_id AS contact_id_38,
  t0.reference_financing_mode_id AS reference_financing_mode_id_39,
  t0.reference_payment_method_id AS reference_payment_method_id_40,
  t1.input_prescriber_id AS input_prescriber_id_41,
  t1.output_prescriber_id AS output_prescriber_id_42,
  t1.output_recommendation_id AS output_recommendation_id_43,
  t1.input_recommendation_id AS input_recommendation_id_44,
  t1.reference_rental_type_id AS reference_rental_type_id_45,
  t0.type
FROM
  transaction t1
  INNER JOIN abstract_transaction t0 ON t1.id = t0.id
WHERE
  t0.mandate_id = ?

SELECT t0.id AS id_2, t0.buyer_commission AS buyer_commission_3, t0.total AS total_4, t0.sell_price_with_tax AS sell_price_with_tax_5, t0.fees_with_tax AS fees_with_tax_6, t0.fees_without_tax AS fees_without_tax_7, t0.under_comprise_at AS under_comprise_at_8, t0.valide_at AS valide_at_9, t0.recorded_at AS recorded_at_10, t0.paid_at AS paid_at_11, t0.canceled_at AS canceled_at_12, t0.expected_date_of_compromise AS expected_date_of_compromise_13, t0.invoice_number AS invoice_number_14, t0.invoice_date AS invoice_date_15, t0.property_value AS property_value_16, t0.advance AS advance_17, t0.apport AS apport_18, t0.created_at AS created_at_19, t0.updated_at AS updated_at_20, t1.seller_commission AS seller_commission_21, t1.rental_start_date AS rental_start_date_22, t1.signature_act_date AS signature_act_date_23, t1.payment_date AS payment_date_24, t1.disbursement_date AS disbursement_date_25, t1.cancellation_date AS cancellation_date_26, t1.edit_rental_contract_date AS edit_rental_contract_date_27, t1.signature_rental_contract_date AS signature_rental_contract_date_28, t1.refusal_date AS refusal_date_29, t1.rental_end_date AS rental_end_date_30, t1.rental_price AS rental_price_31, t0.mandate_id AS mandate_id_32, t0.reference_transaction_status_id AS reference_transaction_status_id_33, t0.reference_commission_paid_by_id AS reference_commission_paid_by_id_34, t0.input_agent_id AS input_agent_id_35, t0.output_agent_id AS output_agent_id_36, t0.vat_id AS vat_id_37, t0.contact_id AS contact_id_38, t0.reference_financing_mode_id AS reference_financing_mode_id_39, t0.reference_payment_method_id AS reference_payment_method_id_40, t1.input_prescriber_id AS input_prescriber_id_41, t1.output_prescriber_id AS output_prescriber_id_42, t1.output_recommendation_id AS output_recommendation_id_43, t1.input_recommendation_id AS input_recommendation_id_44, t1.reference_rental_type_id AS reference_rental_type_id_45, t0.type FROM transaction t1 INNER JOIN abstract_transaction t0 ON t1.id = t0.id WHERE t0.mandate_id = 611;

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.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;

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;