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 = '698441122' LIMIT 1;

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

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.content AS content_3,
  t0.type AS type_4,
  t0.data_id AS data_id_5,
  t0.data AS data_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.user_id AS user_id_9
FROM
  user_notification t0
WHERE
  t0.user_id = ?
ORDER BY
  t0.created_at DESC

SELECT t0.id AS id_1, t0.title AS title_2, t0.content AS content_3, t0.type AS type_4, t0.data_id AS data_id_5, t0.data AS data_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.user_id AS user_id_9 FROM user_notification t0 WHERE t0.user_id = 4 ORDER BY t0.created_at DESC;

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

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 = 4 OR u2_.id = 4) AND s3_.active = 1 ORDER BY m4_.created_at 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

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;