Symfony Profiler

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.contact_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.contact_id = 2808;

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

SELECT
  t0.id AS id_1,
  t0.created_by AS created_by_2,
  t0.min_price AS min_price_3,
  t0.max_price AS max_price_4,
  t0.min_area AS min_area_5,
  t0.max_area AS max_area_6,
  t0.notes AS notes_7,
  t0.start_at AS start_at_8,
  t0.end_at AS end_at_9,
  t0.visit_date AS visit_date_10,
  t0.fees AS fees_11,
  t0.created_at AS created_at_12,
  t0.updated_at AS updated_at_13,
  t0.contact_id AS contact_id_14,
  t0.reference_property_destination_id AS reference_property_destination_id_15,
  t0.reference_property_type_id AS reference_property_type_id_16
FROM
  property_visit_voucher t0
WHERE
  t0.contact_id = ?

SELECT t0.id AS id_1, t0.created_by AS created_by_2, t0.min_price AS min_price_3, t0.max_price AS max_price_4, t0.min_area AS min_area_5, t0.max_area AS max_area_6, t0.notes AS notes_7, t0.start_at AS start_at_8, t0.end_at AS end_at_9, t0.visit_date AS visit_date_10, t0.fees AS fees_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.contact_id AS contact_id_14, t0.reference_property_destination_id AS reference_property_destination_id_15, t0.reference_property_type_id AS reference_property_type_id_16 FROM property_visit_voucher t0 WHERE t0.contact_id = 2808;

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 = 'agent.21@milkiya.ma' LIMIT 1;

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
  (
    c1_.collaborator_id = ?
    OR c1_.recommender_id = ?
  )
  AND c1_.is_business_indication = ?
ORDER BY
  a0_.id DESC

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 (c1_.collaborator_id = 21 OR c1_.recommender_id = 21) AND c1_.is_business_indication = 0 ORDER BY a0_.id DESC;

SELECT
  t0.id AS id_1,
  t0.total_commission AS total_commission_2,
  t0.paid_at AS paid_at_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.transaction_id AS transaction_id_6
FROM
  margin_check_list t0
WHERE
  t0.transaction_id = ?

SELECT t0.id AS id_1, t0.total_commission AS total_commission_2, t0.paid_at AS paid_at_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.transaction_id AS transaction_id_6 FROM margin_check_list t0 WHERE t0.transaction_id = 18;

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

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

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

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

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

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

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3 FROM reference_contact_type t0 WHERE t0.id = 21;

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

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

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

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

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

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

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

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

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

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

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.symbol AS symbol_3
FROM
  currency t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.symbol AS symbol_3 FROM currency t0 WHERE t0.id = 6;