Symfony Profiler

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
WHERE
  t0.id = ?

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 WHERE t0.id = '24';

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.code AS code_2,
  t0.wording AS wording_3,
  t0.start_date AS start_date_4,
  t0.end_date AS end_date_5,
  t0.activated AS activated_6,
  t0.school_year_id AS school_year_id_7
FROM
  quater t0
WHERE
  t0.activated = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.code AS code_2, t0.wording AS wording_3, t0.start_date AS start_date_4, t0.end_date AS end_date_5, t0.activated AS activated_6, t0.school_year_id AS school_year_id_7 FROM quater t0 WHERE t0.activated = 1 LIMIT 1;

SELECT
  s0_.matricule AS matricule_0,
  s0_.id AS id_1,
  s0_.lastname AS lastname_2,
  s0_.firstname AS firstname_3,
  s0_.gender AS gender_4,
  s0_.birthplace AS birthplace_5,
  s0_.birthday AS birthday_6,
  s0_.primary_contact AS primary_contact_7,
  s0_.secondary_contact AS secondary_contact_8
FROM
  student s0_
  INNER JOIN subscription s1_ ON (s1_.student_id = s0_.id)
  INNER JOIN school_year s2_ ON (s1_.school_year_id = s2_.id)
WHERE
  s1_.school_year_id = ?
  AND s1_.class_room_id = ?
ORDER BY
  s0_.lastname ASC

SELECT s0_.matricule AS matricule_0, s0_.id AS id_1, s0_.lastname AS lastname_2, s0_.firstname AS firstname_3, s0_.gender AS gender_4, s0_.birthplace AS birthplace_5, s0_.birthday AS birthday_6, s0_.primary_contact AS primary_contact_7, s0_.secondary_contact AS secondary_contact_8 FROM student s0_ INNER JOIN subscription s1_ ON (s1_.student_id = s0_.id) INNER JOIN school_year s2_ ON (s1_.school_year_id = s2_.id) WHERE s1_.school_year_id = 8 AND s1_.class_room_id = 24 ORDER BY s0_.lastname ASC;

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.validation_date AS validation_date_2,
  t0.code AS code_3,
  t0.wording AS wording_4,
  t0.start_date AS start_date_5,
  t0.end_date AS end_date_6,
  t0.activated AS activated_7,
  t0.quater_id AS quater_id_8
FROM
  sequence t0
WHERE
  t0.quater_id = ?

SELECT t0.id AS id_1, t0.validation_date AS validation_date_2, t0.code AS code_3, t0.wording AS wording_4, t0.start_date AS start_date_5, t0.end_date AS end_date_6, t0.activated AS activated_7, t0.quater_id AS quater_id_8 FROM sequence t0 WHERE t0.quater_id = 23;

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;

CREATE
OR REPLACE VIEW V_STUDENT_MARK_SEQ24_46 AS
SELECT
  DISTINCT crs.id as crs,
  crs.coefficient as coef,
  std.id as std,
  m.value as value,
  m.weight as weight,
  eval.mini as mini,
  eval.maxi as maxi
FROM
  mark m
  JOIN student std ON m.student_id = std.id
  JOIN evaluation eval ON m.evaluation_id = eval.id
  JOIN class_room room ON eval.class_room_id = room.id
  JOIN course crs ON eval.course_id = crs.id
  JOIN sequence seq ON seq.id = eval.sequence_id
WHERE
  room.id = ?
  AND eval.sequence_id = ?
ORDER BY
  std,
  crs;

CREATE OR REPLACE VIEW V_STUDENT_MARK_SEQ24_46 AS
            SELECT DISTINCT  crs.id as crs, crs.coefficient as coef, std.id as std,m.value as value, m.weight as weight, eval.mini as mini , eval.maxi as maxi
            FROM  mark  m   JOIN  student    std     ON  m.student_id        =   std.id
            JOIN  evaluation eval    ON  m.evaluation_id     =   eval.id
            JOIN  class_room room    ON   eval.class_room_id     =   room.id
            JOIN  course     crs     ON  eval.course_id      =   crs.id
            JOIN  sequence   seq     ON  seq.id     =   eval.sequence_id
            WHERE    room.id = 24 AND eval.sequence_id =46 
           
            ORDER BY  std, crs; ;