Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.matricule AS matricule_2,
  t0.firstname AS firstname_3,
  t0.lastname AS lastname_4,
  t0.particular_disease AS particular_disease_5,
  t0.father_name AS father_name_6,
  t0.mother_name AS mother_name_7,
  t0.primary_contact AS primary_contact_8,
  t0.residence AS residence_9,
  t0.secondary_contact AS secondary_contact_10,
  t0.other_informations AS other_informations_11,
  t0.birthday AS birthday_12,
  t0.gender AS gender_13,
  t0.birthplace AS birthplace_14,
  t0.enrolled AS enrolled_15,
  t0.created_at AS created_at_16,
  t0.updated_at AS updated_at_17,
  t0.image_name AS image_name_18,
  t0.entry_class_id AS entry_class_id_19
FROM
  student t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.matricule AS matricule_2, t0.firstname AS firstname_3, t0.lastname AS lastname_4, t0.particular_disease AS particular_disease_5, t0.father_name AS father_name_6, t0.mother_name AS mother_name_7, t0.primary_contact AS primary_contact_8, t0.residence AS residence_9, t0.secondary_contact AS secondary_contact_10, t0.other_informations AS other_informations_11, t0.birthday AS birthday_12, t0.gender AS gender_13, t0.birthplace AS birthplace_14, t0.enrolled AS enrolled_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.image_name AS image_name_18, t0.entry_class_id AS entry_class_id_19 FROM student t0 WHERE t0.id = 878;

SELECT
  s0_.id AS id_0,
  s0_.officialExamResult AS officialExamResult_1,
  s0_.finance_holder AS finance_holder_2,
  s0_.created_at AS created_at_3,
  s0_.updated_at AS updated_at_4,
  s0_.student_id AS student_id_5,
  s0_.class_room_id AS class_room_id_6,
  s0_.school_year_id AS school_year_id_7
FROM
  subscription s0_
  LEFT JOIN school_year s1_ ON s0_.school_year_id = s1_.id
  INNER JOIN student s2_ ON s0_.student_id = s2_.id
WHERE
  s1_.id = ?
  AND s2_.id IS NOT NULL
ORDER BY
  s0_.class_room_id ASC

SELECT s0_.id AS id_0, s0_.officialExamResult AS officialExamResult_1, s0_.finance_holder AS finance_holder_2, s0_.created_at AS created_at_3, s0_.updated_at AS updated_at_4, s0_.student_id AS student_id_5, s0_.class_room_id AS class_room_id_6, s0_.school_year_id AS school_year_id_7 FROM subscription s0_ LEFT JOIN school_year s1_ ON s0_.school_year_id = s1_.id INNER JOIN student s2_ ON s0_.student_id = s2_.id WHERE s1_.id = 6 AND s2_.id IS NOT NULL ORDER BY s0_.class_room_id ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3,
  t0.room_id AS room_id_4
FROM
  module t0
WHERE
  t0.room_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.room_id AS room_id_4 FROM module t0 WHERE t0.room_id = 23;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.apc AS apc_3,
  t0.level_id AS level_id_4
FROM
  class_room t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.apc AS apc_3, t0.level_id AS level_id_4 FROM class_room t0;

SELECT
  t0.id AS id_1,
  t0.registration_deadline AS registration_deadline_2,
  t0.rate AS rate_3,
  t0.code AS code_4,
  t0.wording AS wording_5,
  t0.start_date AS start_date_6,
  t0.end_date AS end_date_7,
  t0.activated AS activated_8,
  t9.id AS id_10,
  t9.weight AS weight_11,
  t9.school_year_id AS school_year_id_12
FROM
  school_year t0
  LEFT JOIN payment_plan t9 ON t9.school_year_id = t0.id
WHERE
  t0.activated = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.registration_deadline AS registration_deadline_2, t0.rate AS rate_3, t0.code AS code_4, t0.wording AS wording_5, t0.start_date AS start_date_6, t0.end_date AS end_date_7, t0.activated AS activated_8, t9.id AS id_10, t9.weight AS weight_11, t9.school_year_id AS school_year_id_12 FROM school_year t0 LEFT JOIN payment_plan t9 ON t9.school_year_id = t0.id WHERE t0.activated = 1 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.teacher_id AS teacher_id_4,
  t0.class_room_id AS class_room_id_5,
  t0.school_year_id AS school_year_id_6
FROM
  main_teacher t0
WHERE
  t0.school_year_id = ?

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.teacher_id AS teacher_id_4, t0.class_room_id AS class_room_id_5, t0.school_year_id AS school_year_id_6 FROM main_teacher t0 WHERE t0.school_year_id = 6;

SELECT
  t0.id AS id_1,
  t0.registration_deadline AS registration_deadline_2,
  t0.rate AS rate_3,
  t0.code AS code_4,
  t0.wording AS wording_5,
  t0.start_date AS start_date_6,
  t0.end_date AS end_date_7,
  t0.activated AS activated_8,
  t9.id AS id_10,
  t9.weight AS weight_11,
  t9.school_year_id AS school_year_id_12
FROM
  school_year t0
  LEFT JOIN payment_plan t9 ON t9.school_year_id = t0.id
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.registration_deadline AS registration_deadline_2, t0.rate AS rate_3, t0.code AS code_4, t0.wording AS wording_5, t0.start_date AS start_date_6, t0.end_date AS end_date_7, t0.activated AS activated_8, t9.id AS id_10, t9.weight AS weight_11, t9.school_year_id AS school_year_id_12 FROM school_year t0 LEFT JOIN payment_plan t9 ON t9.school_year_id = t0.id WHERE t0.id = 6 LIMIT 1;