Symfony Profiler

SELECT
  t0.id AS id_6,
  t0.email AS email_7,
  t0.roles AS roles_8,
  t0.password AS password_9,
  t0.first_name AS first_name_10,
  t0.last_name AS last_name_11,
  t0.is_active AS is_active_12,
  t0.created_at AS created_at_13,
  t0.updated_at AS updated_at_14,
  t0.auth_token AS auth_token_15,
  t0.auth_token_expires_at AS auth_token_expires_at_16,
  t0.discriminator,
  t1.specialization AS specialization_17,
  t2.family_id AS family_id_18,
  t3.pseudo AS pseudo_19,
  t3.class AS class_20,
  t3.school_name AS school_name_21,
  t3.points AS points_22,
  t3.need_tags AS need_tags_23,
  t3.family_id AS family_id_24,
  t4.specializations AS specializations_25
FROM
  `user` t0
  LEFT JOIN coach t1 ON t0.id = t1.id
  LEFT JOIN parent_user t2 ON t0.id = t2.id
  LEFT JOIN student t3 ON t0.id = t3.id
  LEFT JOIN specialist t4 ON t0.id = t4.id
  LEFT JOIN admin t5 ON t0.id = t5.id
WHERE
  t0.id = ?

SELECT t0.id AS id_6, t0.email AS email_7, t0.roles AS roles_8, t0.password AS password_9, t0.first_name AS first_name_10, t0.last_name AS last_name_11, t0.is_active AS is_active_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.auth_token AS auth_token_15, t0.auth_token_expires_at AS auth_token_expires_at_16, t0.discriminator, t1.specialization AS specialization_17, t2.family_id AS family_id_18, t3.pseudo AS pseudo_19, t3.class AS class_20, t3.school_name AS school_name_21, t3.points AS points_22, t3.need_tags AS need_tags_23, t3.family_id AS family_id_24, t4.specializations AS specializations_25 FROM `user` t0 LEFT JOIN coach t1 ON t0.id = t1.id LEFT JOIN parent_user t2 ON t0.id = t2.id LEFT JOIN student t3 ON t0.id = t3.id LEFT JOIN specialist t4 ON t0.id = t4.id LEFT JOIN admin t5 ON t0.id = t5.id WHERE t0.id = 2;

SELECT
  f0_.id AS id_0,
  f0_.family_identifier AS family_identifier_1,
  f0_.type AS type_2,
  f0_.is_active AS is_active_3,
  f0_.created_at AS created_at_4,
  f0_.updated_at AS updated_at_5,
  f0_.location AS location_6,
  u1_.id AS id_7,
  u1_.email AS email_8,
  u1_.roles AS roles_9,
  u1_.password AS password_10,
  u1_.first_name AS first_name_11,
  u1_.last_name AS last_name_12,
  u1_.is_active AS is_active_13,
  u1_.created_at AS created_at_14,
  u1_.updated_at AS updated_at_15,
  u1_.auth_token AS auth_token_16,
  u1_.auth_token_expires_at AS auth_token_expires_at_17,
  u2_.id AS id_18,
  u2_.email AS email_19,
  u2_.roles AS roles_20,
  u2_.password AS password_21,
  u2_.first_name AS first_name_22,
  u2_.last_name AS last_name_23,
  u2_.is_active AS is_active_24,
  u2_.created_at AS created_at_25,
  u2_.updated_at AS updated_at_26,
  u2_.auth_token AS auth_token_27,
  u2_.auth_token_expires_at AS auth_token_expires_at_28,
  s3_.pseudo AS pseudo_29,
  s3_.class AS class_30,
  s3_.school_name AS school_name_31,
  s3_.points AS points_32,
  s3_.need_tags AS need_tags_33,
  f0_.coach_id AS coach_id_34,
  u1_.discriminator AS discriminator_35,
  p4_.family_id AS family_id_36,
  u2_.discriminator AS discriminator_37,
  s3_.family_id AS family_id_38
FROM
  family f0_
  LEFT JOIN parent_user p4_ ON f0_.id = p4_.family_id
  LEFT JOIN `user` u1_ ON p4_.id = u1_.id
  LEFT JOIN student s3_ ON f0_.id = s3_.family_id
  LEFT JOIN `user` u2_ ON s3_.id = u2_.id
WHERE
  f0_.coach_id = ?
ORDER BY
  f0_.created_at DESC

SELECT f0_.id AS id_0, f0_.family_identifier AS family_identifier_1, f0_.type AS type_2, f0_.is_active AS is_active_3, f0_.created_at AS created_at_4, f0_.updated_at AS updated_at_5, f0_.location AS location_6, u1_.id AS id_7, u1_.email AS email_8, u1_.roles AS roles_9, u1_.password AS password_10, u1_.first_name AS first_name_11, u1_.last_name AS last_name_12, u1_.is_active AS is_active_13, u1_.created_at AS created_at_14, u1_.updated_at AS updated_at_15, u1_.auth_token AS auth_token_16, u1_.auth_token_expires_at AS auth_token_expires_at_17, u2_.id AS id_18, u2_.email AS email_19, u2_.roles AS roles_20, u2_.password AS password_21, u2_.first_name AS first_name_22, u2_.last_name AS last_name_23, u2_.is_active AS is_active_24, u2_.created_at AS created_at_25, u2_.updated_at AS updated_at_26, u2_.auth_token AS auth_token_27, u2_.auth_token_expires_at AS auth_token_expires_at_28, s3_.pseudo AS pseudo_29, s3_.class AS class_30, s3_.school_name AS school_name_31, s3_.points AS points_32, s3_.need_tags AS need_tags_33, f0_.coach_id AS coach_id_34, u1_.discriminator AS discriminator_35, p4_.family_id AS family_id_36, u2_.discriminator AS discriminator_37, s3_.family_id AS family_id_38 FROM family f0_ LEFT JOIN parent_user p4_ ON f0_.id = p4_.family_id LEFT JOIN `user` u1_ ON p4_.id = u1_.id LEFT JOIN student s3_ ON f0_.id = s3_.family_id LEFT JOIN `user` u2_ ON s3_.id = u2_.id WHERE f0_.coach_id = 2 ORDER BY f0_.created_at DESC;

SELECT
  t1.id AS id_2,
  t1.email AS email_3,
  t1.roles AS roles_4,
  t1.password AS password_5,
  t1.first_name AS first_name_6,
  t1.last_name AS last_name_7,
  t1.is_active AS is_active_8,
  t1.created_at AS created_at_9,
  t1.updated_at AS updated_at_10,
  t1.auth_token AS auth_token_11,
  t1.auth_token_expires_at AS auth_token_expires_at_12,
  t0.specializations AS specializations_13,
  t1.discriminator
FROM
  specialist t0
  INNER JOIN `user` t1 ON t0.id = t1.id
  INNER JOIN family_specialists ON t0.id = family_specialists.specialist_id
WHERE
  family_specialists.family_id = ?

SELECT t1.id AS id_2, t1.email AS email_3, t1.roles AS roles_4, t1.password AS password_5, t1.first_name AS first_name_6, t1.last_name AS last_name_7, t1.is_active AS is_active_8, t1.created_at AS created_at_9, t1.updated_at AS updated_at_10, t1.auth_token AS auth_token_11, t1.auth_token_expires_at AS auth_token_expires_at_12, t0.specializations AS specializations_13, t1.discriminator FROM specialist t0 INNER JOIN `user` t1 ON t0.id = t1.id INNER JOIN family_specialists ON t0.id = family_specialists.specialist_id WHERE family_specialists.family_id = 11;

SELECT
  COUNT(*)
FROM
  objective t0
WHERE
  t0.student_id = ?

SELECT COUNT(*) FROM objective t0 WHERE t0.student_id = 102;

SELECT
  COUNT(*)
FROM
  request t0
WHERE
  t0.student_id = ?

SELECT COUNT(*) FROM request t0 WHERE t0.student_id = 102;

SELECT
  t1.id AS id_2,
  t1.email AS email_3,
  t1.roles AS roles_4,
  t1.password AS password_5,
  t1.first_name AS first_name_6,
  t1.last_name AS last_name_7,
  t1.is_active AS is_active_8,
  t1.created_at AS created_at_9,
  t1.updated_at AS updated_at_10,
  t1.auth_token AS auth_token_11,
  t1.auth_token_expires_at AS auth_token_expires_at_12,
  t0.specializations AS specializations_13,
  t1.discriminator
FROM
  specialist t0
  INNER JOIN `user` t1 ON t0.id = t1.id
  INNER JOIN specialist_student ON t0.id = specialist_student.specialist_id
WHERE
  specialist_student.student_id = ?

SELECT t1.id AS id_2, t1.email AS email_3, t1.roles AS roles_4, t1.password AS password_5, t1.first_name AS first_name_6, t1.last_name AS last_name_7, t1.is_active AS is_active_8, t1.created_at AS created_at_9, t1.updated_at AS updated_at_10, t1.auth_token AS auth_token_11, t1.auth_token_expires_at AS auth_token_expires_at_12, t0.specializations AS specializations_13, t1.discriminator FROM specialist t0 INNER JOIN `user` t1 ON t0.id = t1.id INNER JOIN specialist_student ON t0.id = specialist_student.specialist_id WHERE specialist_student.student_id = 102;

SELECT
  COUNT(p0_.id) AS sclr_0
FROM
  planning p0_
WHERE
  p0_.user_id = ?

SELECT COUNT(p0_.id) AS sclr_0 FROM planning p0_ WHERE p0_.user_id = 102;

SELECT
  t1.id AS id_2,
  t1.email AS email_3,
  t1.roles AS roles_4,
  t1.password AS password_5,
  t1.first_name AS first_name_6,
  t1.last_name AS last_name_7,
  t1.is_active AS is_active_8,
  t1.created_at AS created_at_9,
  t1.updated_at AS updated_at_10,
  t1.auth_token AS auth_token_11,
  t1.auth_token_expires_at AS auth_token_expires_at_12,
  t0.specializations AS specializations_13,
  t1.discriminator
FROM
  specialist t0
  INNER JOIN `user` t1 ON t0.id = t1.id
  INNER JOIN family_specialists ON t0.id = family_specialists.specialist_id
WHERE
  family_specialists.family_id = ?

SELECT t1.id AS id_2, t1.email AS email_3, t1.roles AS roles_4, t1.password AS password_5, t1.first_name AS first_name_6, t1.last_name AS last_name_7, t1.is_active AS is_active_8, t1.created_at AS created_at_9, t1.updated_at AS updated_at_10, t1.auth_token AS auth_token_11, t1.auth_token_expires_at AS auth_token_expires_at_12, t0.specializations AS specializations_13, t1.discriminator FROM specialist t0 INNER JOIN `user` t1 ON t0.id = t1.id INNER JOIN family_specialists ON t0.id = family_specialists.specialist_id WHERE family_specialists.family_id = 10;

SELECT
  COUNT(*)
FROM
  objective t0
WHERE
  t0.student_id = ?

SELECT COUNT(*) FROM objective t0 WHERE t0.student_id = 95;

SELECT
  COUNT(*)
FROM
  request t0
WHERE
  t0.student_id = ?

SELECT COUNT(*) FROM request t0 WHERE t0.student_id = 95;

SELECT
  t1.id AS id_2,
  t1.email AS email_3,
  t1.roles AS roles_4,
  t1.password AS password_5,
  t1.first_name AS first_name_6,
  t1.last_name AS last_name_7,
  t1.is_active AS is_active_8,
  t1.created_at AS created_at_9,
  t1.updated_at AS updated_at_10,
  t1.auth_token AS auth_token_11,
  t1.auth_token_expires_at AS auth_token_expires_at_12,
  t0.specializations AS specializations_13,
  t1.discriminator
FROM
  specialist t0
  INNER JOIN `user` t1 ON t0.id = t1.id
  INNER JOIN specialist_student ON t0.id = specialist_student.specialist_id
WHERE
  specialist_student.student_id = ?

SELECT t1.id AS id_2, t1.email AS email_3, t1.roles AS roles_4, t1.password AS password_5, t1.first_name AS first_name_6, t1.last_name AS last_name_7, t1.is_active AS is_active_8, t1.created_at AS created_at_9, t1.updated_at AS updated_at_10, t1.auth_token AS auth_token_11, t1.auth_token_expires_at AS auth_token_expires_at_12, t0.specializations AS specializations_13, t1.discriminator FROM specialist t0 INNER JOIN `user` t1 ON t0.id = t1.id INNER JOIN specialist_student ON t0.id = specialist_student.specialist_id WHERE specialist_student.student_id = 95;

SELECT
  COUNT(*)
FROM
  objective t0
WHERE
  t0.student_id = ?

SELECT COUNT(*) FROM objective t0 WHERE t0.student_id = 96;

SELECT
  COUNT(*)
FROM
  request t0
WHERE
  t0.student_id = ?

SELECT COUNT(*) FROM request t0 WHERE t0.student_id = 96;

SELECT
  t1.id AS id_2,
  t1.email AS email_3,
  t1.roles AS roles_4,
  t1.password AS password_5,
  t1.first_name AS first_name_6,
  t1.last_name AS last_name_7,
  t1.is_active AS is_active_8,
  t1.created_at AS created_at_9,
  t1.updated_at AS updated_at_10,
  t1.auth_token AS auth_token_11,
  t1.auth_token_expires_at AS auth_token_expires_at_12,
  t0.specializations AS specializations_13,
  t1.discriminator
FROM
  specialist t0
  INNER JOIN `user` t1 ON t0.id = t1.id
  INNER JOIN specialist_student ON t0.id = specialist_student.specialist_id
WHERE
  specialist_student.student_id = ?

SELECT t1.id AS id_2, t1.email AS email_3, t1.roles AS roles_4, t1.password AS password_5, t1.first_name AS first_name_6, t1.last_name AS last_name_7, t1.is_active AS is_active_8, t1.created_at AS created_at_9, t1.updated_at AS updated_at_10, t1.auth_token AS auth_token_11, t1.auth_token_expires_at AS auth_token_expires_at_12, t0.specializations AS specializations_13, t1.discriminator FROM specialist t0 INNER JOIN `user` t1 ON t0.id = t1.id INNER JOIN specialist_student ON t0.id = specialist_student.specialist_id WHERE specialist_student.student_id = 96;

SELECT
  COUNT(*)
FROM
  objective t0
WHERE
  t0.student_id = ?

SELECT COUNT(*) FROM objective t0 WHERE t0.student_id = 97;

SELECT
  COUNT(*)
FROM
  request t0
WHERE
  t0.student_id = ?

SELECT COUNT(*) FROM request t0 WHERE t0.student_id = 97;

SELECT
  t1.id AS id_2,
  t1.email AS email_3,
  t1.roles AS roles_4,
  t1.password AS password_5,
  t1.first_name AS first_name_6,
  t1.last_name AS last_name_7,
  t1.is_active AS is_active_8,
  t1.created_at AS created_at_9,
  t1.updated_at AS updated_at_10,
  t1.auth_token AS auth_token_11,
  t1.auth_token_expires_at AS auth_token_expires_at_12,
  t0.specializations AS specializations_13,
  t1.discriminator
FROM
  specialist t0
  INNER JOIN `user` t1 ON t0.id = t1.id
  INNER JOIN specialist_student ON t0.id = specialist_student.specialist_id
WHERE
  specialist_student.student_id = ?

SELECT t1.id AS id_2, t1.email AS email_3, t1.roles AS roles_4, t1.password AS password_5, t1.first_name AS first_name_6, t1.last_name AS last_name_7, t1.is_active AS is_active_8, t1.created_at AS created_at_9, t1.updated_at AS updated_at_10, t1.auth_token AS auth_token_11, t1.auth_token_expires_at AS auth_token_expires_at_12, t0.specializations AS specializations_13, t1.discriminator FROM specialist t0 INNER JOIN `user` t1 ON t0.id = t1.id INNER JOIN specialist_student ON t0.id = specialist_student.specialist_id WHERE specialist_student.student_id = 97;

SELECT
  COUNT(*)
FROM
  objective t0
WHERE
  t0.student_id = ?

SELECT COUNT(*) FROM objective t0 WHERE t0.student_id = 98;

SELECT
  COUNT(*)
FROM
  request t0
WHERE
  t0.student_id = ?

SELECT COUNT(*) FROM request t0 WHERE t0.student_id = 98;

SELECT
  t1.id AS id_2,
  t1.email AS email_3,
  t1.roles AS roles_4,
  t1.password AS password_5,
  t1.first_name AS first_name_6,
  t1.last_name AS last_name_7,
  t1.is_active AS is_active_8,
  t1.created_at AS created_at_9,
  t1.updated_at AS updated_at_10,
  t1.auth_token AS auth_token_11,
  t1.auth_token_expires_at AS auth_token_expires_at_12,
  t0.specializations AS specializations_13,
  t1.discriminator
FROM
  specialist t0
  INNER JOIN `user` t1 ON t0.id = t1.id
  INNER JOIN specialist_student ON t0.id = specialist_student.specialist_id
WHERE
  specialist_student.student_id = ?

SELECT t1.id AS id_2, t1.email AS email_3, t1.roles AS roles_4, t1.password AS password_5, t1.first_name AS first_name_6, t1.last_name AS last_name_7, t1.is_active AS is_active_8, t1.created_at AS created_at_9, t1.updated_at AS updated_at_10, t1.auth_token AS auth_token_11, t1.auth_token_expires_at AS auth_token_expires_at_12, t0.specializations AS specializations_13, t1.discriminator FROM specialist t0 INNER JOIN `user` t1 ON t0.id = t1.id INNER JOIN specialist_student ON t0.id = specialist_student.specialist_id WHERE specialist_student.student_id = 98;

SELECT
  COUNT(*)
FROM
  objective t0
WHERE
  t0.student_id = ?

SELECT COUNT(*) FROM objective t0 WHERE t0.student_id = 99;

SELECT
  COUNT(*)
FROM
  request t0
WHERE
  t0.student_id = ?

SELECT COUNT(*) FROM request t0 WHERE t0.student_id = 99;

SELECT
  t1.id AS id_2,
  t1.email AS email_3,
  t1.roles AS roles_4,
  t1.password AS password_5,
  t1.first_name AS first_name_6,
  t1.last_name AS last_name_7,
  t1.is_active AS is_active_8,
  t1.created_at AS created_at_9,
  t1.updated_at AS updated_at_10,
  t1.auth_token AS auth_token_11,
  t1.auth_token_expires_at AS auth_token_expires_at_12,
  t0.specializations AS specializations_13,
  t1.discriminator
FROM
  specialist t0
  INNER JOIN `user` t1 ON t0.id = t1.id
  INNER JOIN specialist_student ON t0.id = specialist_student.specialist_id
WHERE
  specialist_student.student_id = ?

SELECT t1.id AS id_2, t1.email AS email_3, t1.roles AS roles_4, t1.password AS password_5, t1.first_name AS first_name_6, t1.last_name AS last_name_7, t1.is_active AS is_active_8, t1.created_at AS created_at_9, t1.updated_at AS updated_at_10, t1.auth_token AS auth_token_11, t1.auth_token_expires_at AS auth_token_expires_at_12, t0.specializations AS specializations_13, t1.discriminator FROM specialist t0 INNER JOIN `user` t1 ON t0.id = t1.id INNER JOIN specialist_student ON t0.id = specialist_student.specialist_id WHERE specialist_student.student_id = 99;

SELECT
  COUNT(*)
FROM
  objective t0
WHERE
  t0.student_id = ?

SELECT COUNT(*) FROM objective t0 WHERE t0.student_id = 100;

SELECT
  COUNT(*)
FROM
  request t0
WHERE
  t0.student_id = ?

SELECT COUNT(*) FROM request t0 WHERE t0.student_id = 100;