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

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

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

SELECT
  q0_.id AS id_0,
  q0_.level AS level_1,
  q0_.recurrence AS recurrence_2,
  q0_.label AS label_3,
  q0_.qualification_level_goal AS qualification_level_goal_4,
  q0_.max_sponsorship_request AS max_sponsorship_request_5
FROM
  qualification_level q0_
WHERE
  q0_.id = ?

SELECT q0_.id AS id_0, q0_.level AS level_1, q0_.recurrence AS recurrence_2, q0_.label AS label_3, q0_.qualification_level_goal AS qualification_level_goal_4, q0_.max_sponsorship_request AS max_sponsorship_request_5 FROM qualification_level q0_ WHERE q0_.id = 27;

SELECT
  g0_.id AS id_0,
  g0_.name AS name_1,
  g0_.code AS code_2
FROM
  gender g0_
WHERE
  g0_.id = ?

SELECT g0_.id AS id_0, g0_.name AS name_1, g0_.code AS code_2 FROM gender g0_ WHERE g0_.id = 13;

SELECT
  r0_.id AS id_0,
  r0_.name AS name_1,
  r0_.code AS code_2,
  r0_.rank AS rank_3
FROM
  reference_person_marital_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_person_marital_status r0_ WHERE r0_.id = 26;

SELECT
  n0_.id AS id_0,
  n0_.name AS name_1,
  n0_.code AS code_2
FROM
  nationality n0_
WHERE
  n0_.id = ?

SELECT n0_.id AS id_0, n0_.name AS name_1, n0_.code AS code_2 FROM nationality n0_ WHERE n0_.id = 1155;

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

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

SELECT
  n0_.id AS id_0,
  n0_.name AS name_1,
  n0_.latitude AS latitude_2,
  n0_.longitude AS longitude_3,
  n0_.city_id AS city_id_4
FROM
  neighborhood n0_
WHERE
  n0_.id = ?

SELECT n0_.id AS id_0, n0_.name AS name_1, n0_.latitude AS latitude_2, n0_.longitude AS longitude_3, n0_.city_id AS city_id_4 FROM neighborhood n0_ WHERE n0_.id = 1217;

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

SELECT
  r0_.id AS id_0,
  r0_.code AS code_1,
  r0_.name AS name_2,
  r0_.rank AS rank_3
FROM
  reference_collaborator_state r0_
WHERE
  r0_.id = ?

SELECT r0_.id AS id_0, r0_.code AS code_1, r0_.name AS name_2, r0_.rank AS rank_3 FROM reference_collaborator_state r0_ WHERE r0_.id = 18;

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
  t0.cin = ?
LIMIT
  2

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 t0.cin = 'BJ01657D' LIMIT 2;

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.email = ?
LIMIT
  2

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.email = 'agent.59@milkiya.ma' LIMIT 2;

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.main_phone = ?
LIMIT
  2

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.main_phone = '+212 5900-00000' LIMIT 2;

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.email = ?
LIMIT
  2

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.email = 'agent.59@milkiya.ma' LIMIT 2;

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.professional_email = ?
LIMIT
  2

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.professional_email = 'agent.59@milkiya.ma' LIMIT 2;

SELECT
  NEXTVAL('address_id_seq')

SELECT NEXTVAL('address_id_seq');

SELECT
  NEXTVAL('sector_id_seq')

SELECT NEXTVAL('sector_id_seq');

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO address (
  id, first_address, second_address,
  contact_city, zip_code, city_id,
  country_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?)

INSERT INTO address (id, first_address, second_address, contact_city, zip_code, city_id, country_id) VALUES (12992, 'LOT SALIMA RUE 3 NR 19 SIDI MAAROUF AIN CHOCK CASA', NULL, NULL, NULL, 649, NULL);

INSERT INTO sector (id, main_city_id)
VALUES
  (?, ?)

INSERT INTO sector (id, main_city_id) VALUES (3300, 649);

UPDATE
  abstract_collaborator
SET
  birth_day = ?,
  phone = ?,
  main_phone = ?,
  address_id = ?,
  updated_at = ?
WHERE
  id = ?

UPDATE abstract_collaborator SET birth_day = '1965-12-29', phone = '+212 5900-00000', main_phone = '+212 5900-00000', address_id = 12992, updated_at = '2025-04-02' WHERE id = 59;

UPDATE
  agent
SET
  sector_id = ?
WHERE
  id = ?

UPDATE agent SET sector_id = 3300 WHERE id = 59;

INSERT INTO sector_city (sector_id, city_id)
VALUES
  (?, ?)

INSERT INTO sector_city (sector_id, city_id) VALUES (3300, 649);

INSERT INTO sector_neighborhood (sector_id, neighborhood_id)
VALUES
  (?, ?)

INSERT INTO sector_neighborhood (sector_id, neighborhood_id) VALUES (3300, 1217);

"COMMIT"

"COMMIT";

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 = ?