Symfony Profiler

SELECT
  *
FROM
  V_STUDENT_MARK_QUATER

SELECT * FROM V_STUDENT_MARK_QUATER;

CREATE
OR REPLACE VIEW V_STUDENT_MARK_SEQ1_42 AS
SELECT
  DISTINCT crs.id as crs,
  crs.coefficient as coef,
  std.id as std,
  m.value as value,
  m.weight as weight
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_SEQ1_42 AS
            SELECT DISTINCT  crs.id as crs, crs.coefficient as coef, std.id as std,m.value as value, m.weight as weight
            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 = 1 AND eval.sequence_id =42 
            ORDER BY  std, crs; ;

CREATE
OR REPLACE VIEW V_STUDENT_MARK_QUATER AS
SELECT
  DISTINCT seq1.std as std,
  seq1.crs as crs,
  seq1.coef as coef,
  seq1.value as value1,
  seq1.weight as weight1,
  seq2.value as value2,
  seq2.weight as weight2,
  (
    seq1.value * seq1.weight + seq2.value * seq2.weight
  )/(seq1.weight + seq2.weight) as value,
  greatest(seq1.weight, seq2.weight) as weight
FROM
  V_STUDENT_MARK_SEQ1_42 seq1
  JOIN V_STUDENT_MARK_SEQ1_43 seq2 ON (
    seq1.std = seq2.std
    AND seq1.crs = seq2.crs
  )
ORDER BY
  std

CREATE OR REPLACE VIEW V_STUDENT_MARK_QUATER AS
            SELECT DISTINCT   seq1.std as std , seq1.crs as crs , seq1.coef as coef,  seq1.value as value1, seq1.weight as weight1,seq2.value as value2, seq2.weight as weight2,    (seq1.value*seq1.weight + seq2.value*seq2.weight)/(seq1.weight+seq2.weight)  as value, greatest(seq1.weight , seq2.weight ) as weight 
            FROM V_STUDENT_MARK_SEQ1_42 seq1
            JOIN  V_STUDENT_MARK_SEQ1_43 seq2  ON  (seq1.std    =   seq2.std  AND seq1.crs = seq2.crs )
            ORDER BY std ;

CREATE
OR REPLACE VIEW V_STUDENT_MARK_SEQ1_43 AS
SELECT
  DISTINCT crs.id as crs,
  crs.coefficient as coef,
  std.id as std,
  m.value as value,
  m.weight as weight
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_SEQ1_43 AS
            SELECT DISTINCT  crs.id as crs, crs.coefficient as coef, std.id as std,m.value as value, m.weight as weight
            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 = 1 AND eval.sequence_id =43 
            ORDER BY  std, crs; ;

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
  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 = 7 AND s1_.class_room_id = 1 ORDER BY s0_.lastname ASC;

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

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

SELECT
  t0.id AS id_1,
  t0.wording AS wording_2,
  t0.coefficient AS coefficient_3,
  t0.code AS code_4,
  t0.domain_id AS domain_id_5,
  t0.module_id AS module_id_6
FROM
  course t0
WHERE
  t0.module_id = ?

SELECT t0.id AS id_1, t0.wording AS wording_2, t0.coefficient AS coefficient_3, t0.code AS code_4, t0.domain_id AS domain_id_5, t0.module_id AS module_id_6 FROM course t0 WHERE t0.module_id = 18;

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