Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.first_name AS first_name_5,
  t0.last_name AS last_name_6,
  t0.phone AS phone_7,
  t0.user_type AS user_type_8,
  t0.is_verified AS is_verified_9,
  t0.matricule AS matricule_10,
  t0.full_name AS full_name_11,
  t0.last_request_ts AS last_request_ts_12,
  t0.theme AS theme_13,
  t0.picture AS picture_14,
  t0.sexe AS sexe_15,
  t0.local_phone_lang AS local_phone_lang_16,
  t0.user_token AS user_token_17,
  t0.created_at AS created_at_18,
  t0.updated_at AS updated_at_19,
  t0.author_id AS author_id_20,
  t0.editor_id AS editor_id_21,
  t0.school_id AS school_id_22
FROM
  `user` t0
WHERE
  t0.phone = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.phone AS phone_7, t0.user_type AS user_type_8, t0.is_verified AS is_verified_9, t0.matricule AS matricule_10, t0.full_name AS full_name_11, t0.last_request_ts AS last_request_ts_12, t0.theme AS theme_13, t0.picture AS picture_14, t0.sexe AS sexe_15, t0.local_phone_lang AS local_phone_lang_16, t0.user_token AS user_token_17, t0.created_at AS created_at_18, t0.updated_at AS updated_at_19, t0.author_id AS author_id_20, t0.editor_id AS editor_id_21, t0.school_id AS school_id_22 FROM `user` t0 WHERE t0.phone = '661788095' LIMIT 1;

SELECT
  s0_.id AS id_0,
  s0_.amount AS amount_1,
  s0_.date_paid AS date_paid_2,
  s0_.student_id AS student_id_3,
  s0_.scolarity_id AS scolarity_id_4
FROM
  student_scolarity s0_
  LEFT JOIN student_year s1_ ON s0_.student_id = s1_.id
  LEFT JOIN school_year s2_ ON s1_.year_id = s2_.id
  LEFT JOIN scolarity s3_ ON s0_.scolarity_id = s3_.id
WHERE
  s1_.id = ?
  AND s2_.active = ?
ORDER BY
  s3_.end_at ASC

SELECT s0_.id AS id_0, s0_.amount AS amount_1, s0_.date_paid AS date_paid_2, s0_.student_id AS student_id_3, s0_.scolarity_id AS scolarity_id_4 FROM student_scolarity s0_ LEFT JOIN student_year s1_ ON s0_.student_id = s1_.id LEFT JOIN school_year s2_ ON s1_.year_id = s2_.id LEFT JOIN scolarity s3_ ON s0_.scolarity_id = s3_.id WHERE s1_.id = 2707 AND s2_.active = 1 ORDER BY s3_.end_at ASC;

SELECT
  SUM(s0_.amount) AS sclr_0
FROM
  student_scolarity s0_
  LEFT JOIN student_year s1_ ON s0_.student_id = s1_.id
WHERE
  s1_.id = ?

SELECT SUM(s0_.amount) AS sclr_0 FROM student_scolarity s0_ LEFT JOIN student_year s1_ ON s0_.student_id = s1_.id WHERE s1_.id = 2707;

SELECT
  s0_.id AS id_0,
  s0_.image_name AS image_name_1,
  s0_.slug AS slug_2,
  s0_.last_school_name AS last_school_name_3,
  s0_.repeater AS repeater_4,
  s0_.active AS active_5,
  s0_.created_at AS created_at_6,
  s0_.updated_at AS updated_at_7,
  s0_.year_id AS year_id_8,
  s0_.student_id AS student_id_9,
  s0_.classe_id AS classe_id_10,
  s0_.school_id AS school_id_11,
  s0_.scolarity_id AS scolarity_id_12
FROM
  student_year s0_
  LEFT JOIN student s1_ ON s0_.student_id = s1_.id
  LEFT JOIN school_year s2_ ON s0_.year_id = s2_.id
  LEFT JOIN school s3_ ON s0_.school_id = s3_.id
  LEFT JOIN `user` u4_ ON s1_.parent_id = u4_.id
WHERE
  u4_.id = ?
  AND s2_.active = ?
  AND s0_.active = ?
  AND s3_.id = ?

SELECT s0_.id AS id_0, s0_.image_name AS image_name_1, s0_.slug AS slug_2, s0_.last_school_name AS last_school_name_3, s0_.repeater AS repeater_4, s0_.active AS active_5, s0_.created_at AS created_at_6, s0_.updated_at AS updated_at_7, s0_.year_id AS year_id_8, s0_.student_id AS student_id_9, s0_.classe_id AS classe_id_10, s0_.school_id AS school_id_11, s0_.scolarity_id AS scolarity_id_12 FROM student_year s0_ LEFT JOIN student s1_ ON s0_.student_id = s1_.id LEFT JOIN school_year s2_ ON s0_.year_id = s2_.id LEFT JOIN school s3_ ON s0_.school_id = s3_.id LEFT JOIN `user` u4_ ON s1_.parent_id = u4_.id WHERE u4_.id = 4082 AND s2_.active = 1 AND s0_.active = 1 AND s3_.id = 2;

SELECT
  DISTINCT t0_.id AS id_0
FROM
  subject s1_
  LEFT JOIN `user` u2_ ON s1_.prof_id = u2_.id
  LEFT JOIN the_class t0_ ON s1_.classe_id = t0_.id
WHERE
  u2_.id = ?

SELECT DISTINCT t0_.id AS id_0 FROM subject s1_ LEFT JOIN `user` u2_ ON s1_.prof_id = u2_.id LEFT JOIN the_class t0_ ON s1_.classe_id = t0_.id WHERE u2_.id = 4082;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.end_at AS end_at_3,
  t0.is_exams AS is_exams_4,
  t0.amount AS amount_5,
  t0.classe_id AS classe_id_6,
  t0.year_id AS year_id_7,
  t0.author_id AS author_id_8,
  t0.school_id AS school_id_9
FROM
  scolarity t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.end_at AS end_at_3, t0.is_exams AS is_exams_4, t0.amount AS amount_5, t0.classe_id AS classe_id_6, t0.year_id AS year_id_7, t0.author_id AS author_id_8, t0.school_id AS school_id_9 FROM scolarity t0 WHERE t0.id = 181;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.active AS active_3,
  t0.name_en AS name_en_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.author_id AS author_id_7,
  t0.editor_id AS editor_id_8,
  t9.id AS id_10,
  t9.time AS time_11,
  t9.school_id AS school_id_12,
  t9.year_id AS year_id_13,
  t9.author_id AS author_id_14
FROM
  school_year t0
  LEFT JOIN agenda_time_convertion t9 ON t9.year_id = t0.id
WHERE
  t0.active = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.active AS active_3, t0.name_en AS name_en_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.author_id AS author_id_7, t0.editor_id AS editor_id_8, t9.id AS id_10, t9.time AS time_11, t9.school_id AS school_id_12, t9.year_id AS year_id_13, t9.author_id AS author_id_14 FROM school_year t0 LEFT JOIN agenda_time_convertion t9 ON t9.year_id = t0.id WHERE t0.active = 1 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.first_name AS first_name_2,
  t0.last_name AS last_name_3,
  t0.matricule AS matricule_4,
  t0.born_location AS born_location_5,
  t0.full_name AS full_name_6,
  t0.sexe AS sexe_7,
  t0.picture AS picture_8,
  t0.born_arrondissement AS born_arrondissement_9,
  t0.born_departement AS born_departement_10,
  t0.father AS father_11,
  t0.mother AS mother_12,
  t0.born_day AS born_day_13,
  t0.gov_matricule AS gov_matricule_14,
  t0.created_at AS created_at_15,
  t0.updated_at AS updated_at_16,
  t0.parent_id AS parent_id_17,
  t0.editor_id AS editor_id_18,
  t0.author_id AS author_id_19,
  t0.school_id AS school_id_20,
  t21.id AS id_22,
  t21.details AS details_23,
  t21.student_id AS student_id_24,
  t21.school_id AS school_id_25,
  t21.year_id AS year_id_26
FROM
  student t0
  LEFT JOIN definitive_exclusion t21 ON t21.student_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.matricule AS matricule_4, t0.born_location AS born_location_5, t0.full_name AS full_name_6, t0.sexe AS sexe_7, t0.picture AS picture_8, t0.born_arrondissement AS born_arrondissement_9, t0.born_departement AS born_departement_10, t0.father AS father_11, t0.mother AS mother_12, t0.born_day AS born_day_13, t0.gov_matricule AS gov_matricule_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.parent_id AS parent_id_17, t0.editor_id AS editor_id_18, t0.author_id AS author_id_19, t0.school_id AS school_id_20, t21.id AS id_22, t21.details AS details_23, t21.student_id AS student_id_24, t21.school_id AS school_id_25, t21.year_id AS year_id_26 FROM student t0 LEFT JOIN definitive_exclusion t21 ON t21.student_id = t0.id WHERE t0.id = 2707;

SELECT
  c0_.id AS id_0,
  c0_.created_at AS created_at_1,
  c0_.updated_at AS updated_at_2,
  c0_.initiator_id AS initiator_id_3,
  c0_.recipient_id AS recipient_id_4,
  c0_.year_id AS year_id_5
FROM
  chat c0_
  LEFT JOIN `user` u1_ ON c0_.initiator_id = u1_.id
  LEFT JOIN `user` u2_ ON c0_.recipient_id = u2_.id
  LEFT JOIN school_year s3_ ON c0_.year_id = s3_.id
  LEFT JOIN message m4_ ON c0_.id = m4_.chat_id
WHERE
  (
    u1_.id = ?
    OR u2_.id = ?
  )
  AND s3_.active = ?
ORDER BY
  m4_.created_at DESC

SELECT c0_.id AS id_0, c0_.created_at AS created_at_1, c0_.updated_at AS updated_at_2, c0_.initiator_id AS initiator_id_3, c0_.recipient_id AS recipient_id_4, c0_.year_id AS year_id_5 FROM chat c0_ LEFT JOIN `user` u1_ ON c0_.initiator_id = u1_.id LEFT JOIN `user` u2_ ON c0_.recipient_id = u2_.id LEFT JOIN school_year s3_ ON c0_.year_id = s3_.id LEFT JOIN message m4_ ON c0_.id = m4_.chat_id WHERE (u1_.id = 4082 OR u2_.id = 4082) AND s3_.active = 1 ORDER BY m4_.created_at DESC;

SELECT
  SUM(s0_.amount) AS sclr_0
FROM
  scolarity s0_
  LEFT JOIN the_class t1_ ON s0_.classe_id = t1_.id
  LEFT JOIN school_year s2_ ON s0_.year_id = s2_.id
WHERE
  t1_.id = ?
  AND s2_.active = ?

SELECT SUM(s0_.amount) AS sclr_0 FROM scolarity s0_ LEFT JOIN the_class t1_ ON s0_.classe_id = t1_.id LEFT JOIN school_year s2_ ON s0_.year_id = s2_.id WHERE t1_.id = 46 AND s2_.active = 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.active AS active_3,
  t0.slug AS slug_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.section_id AS section_id_7,
  t0.author_id AS author_id_8,
  t0.editor_id AS editor_id_9,
  t0.school_id AS school_id_10,
  t0.prof_id AS prof_id_11,
  t0.principal_prof_id AS principal_prof_id_12
FROM
  the_class t0
WHERE
  t0.school_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.active AS active_3, t0.slug AS slug_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.section_id AS section_id_7, t0.author_id AS author_id_8, t0.editor_id AS editor_id_9, t0.school_id AS school_id_10, t0.prof_id AS prof_id_11, t0.principal_prof_id AS principal_prof_id_12 FROM the_class t0 WHERE t0.school_id = 2;

SELECT
  t0_.id AS id_0,
  t0_.name AS name_1,
  t0_.active AS active_2,
  t0_.slug AS slug_3,
  t0_.created_at AS created_at_4,
  t0_.updated_at AS updated_at_5,
  s1_.id AS id_6,
  s1_.name AS name_7,
  s1_.created_at AS created_at_8,
  s1_.updated_at AS updated_at_9,
  t0_.section_id AS section_id_10,
  t0_.author_id AS author_id_11,
  t0_.editor_id AS editor_id_12,
  t0_.school_id AS school_id_13,
  t0_.prof_id AS prof_id_14,
  t0_.principal_prof_id AS principal_prof_id_15,
  s1_.author_id AS author_id_16,
  s1_.editor_id AS editor_id_17,
  s1_.school_id AS school_id_18
FROM
  the_class t0_
  LEFT JOIN school_section s1_ ON t0_.section_id = s1_.id
ORDER BY
  t0_.name DESC

SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.active AS active_2, t0_.slug AS slug_3, t0_.created_at AS created_at_4, t0_.updated_at AS updated_at_5, s1_.id AS id_6, s1_.name AS name_7, s1_.created_at AS created_at_8, s1_.updated_at AS updated_at_9, t0_.section_id AS section_id_10, t0_.author_id AS author_id_11, t0_.editor_id AS editor_id_12, t0_.school_id AS school_id_13, t0_.prof_id AS prof_id_14, t0_.principal_prof_id AS principal_prof_id_15, s1_.author_id AS author_id_16, s1_.editor_id AS editor_id_17, s1_.school_id AS school_id_18 FROM the_class t0_ LEFT JOIN school_section s1_ ON t0_.section_id = s1_.id ORDER BY t0_.name DESC;