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 = '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 = ?
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 = 7 AND s1_.class_room_id = 1 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 = 21;

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_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; ;

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_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; ;

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 ;

SELECT
  *
FROM
  V_STUDENT_MARK_QUATER

SELECT * FROM V_STUDENT_MARK_QUATER;

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
  DATABASE()

SELECT DATABASE();

SELECT
  TABLE_NAME
FROM
  information_schema.TABLES
WHERE
  TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY
  TABLE_NAME

SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = 'bethesda'
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME;

SELECT
  DATABASE()

SELECT DATABASE();

SELECT
  TABLE_NAME
FROM
  information_schema.TABLES
WHERE
  TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY
  TABLE_NAME

SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = 'bethesda'
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME;

SELECT
  DATABASE()

SELECT DATABASE();

SELECT
  t.TABLE_NAME,
  t.ENGINE,
  t.AUTO_INCREMENT,
  t.TABLE_COMMENT,
  t.CREATE_OPTIONS,
  t.TABLE_COLLATION,
  ccsa.CHARACTER_SET_NAME
FROM
  information_schema.TABLES t
  INNER JOIN information_schema.COLLATION_CHARACTER_SET_APPLICABILITY ccsa ON ccsa.COLLATION_NAME = t.TABLE_COLLATION
WHERE
  t.TABLE_SCHEMA = ?
  AND t.TABLE_NAME = ?
  AND t.TABLE_TYPE = 'BASE TABLE'

SELECT t.TABLE_NAME,
           t.ENGINE,
           t.AUTO_INCREMENT,
           t.TABLE_COMMENT,
           t.CREATE_OPTIONS,
           t.TABLE_COLLATION,
           ccsa.CHARACTER_SET_NAME
      FROM information_schema.TABLES t
        INNER JOIN information_schema.COLLATION_CHARACTER_SET_APPLICABILITY ccsa
          ON ccsa.COLLATION_NAME = t.TABLE_COLLATION WHERE t.TABLE_SCHEMA = 'bethesda' AND t.TABLE_NAME = 'doctrine_migration_versions' AND t.TABLE_TYPE = 'BASE TABLE';

SELECT
  DATABASE()

SELECT DATABASE();

SELECT
  DISTINCT k.CONSTRAINT_NAME,
  k.COLUMN_NAME,
  k.REFERENCED_TABLE_NAME,
  k.REFERENCED_COLUMN_NAME,
  k.ORDINAL_POSITION
  /*!50116,
              c.UPDATE_RULE,
              c.DELETE_RULE */
FROM
  information_schema.key_column_usage k
  /*!50116
  INNER JOIN information_schema.referential_constraints c
  ON c.CONSTRAINT_NAME = k.CONSTRAINT_NAME
  AND c.TABLE_NAME = k.TABLE_NAME */
WHERE
  k.TABLE_SCHEMA = ?
  AND k.TABLE_NAME = ?
  AND k.REFERENCED_COLUMN_NAME IS NOT NULL
  /*!50116 AND c.CONSTRAINT_SCHEMA = 'bethesda' */
ORDER BY
  k.ORDINAL_POSITION

SELECT DISTINCT            k.CONSTRAINT_NAME,
            k.COLUMN_NAME,
            k.REFERENCED_TABLE_NAME,
            k.REFERENCED_COLUMN_NAME,
            k.ORDINAL_POSITION /*!50116,
            c.UPDATE_RULE,
            c.DELETE_RULE */
FROM information_schema.key_column_usage k /*!50116
INNER JOIN information_schema.referential_constraints c
ON c.CONSTRAINT_NAME = k.CONSTRAINT_NAME
AND c.TABLE_NAME = k.TABLE_NAME */ WHERE k.TABLE_SCHEMA = 'bethesda' AND k.TABLE_NAME = 'doctrine_migration_versions' AND k.REFERENCED_COLUMN_NAME IS NOT NULL /*!50116 AND c.CONSTRAINT_SCHEMA = 'bethesda' */ ORDER BY k.ORDINAL_POSITION;

SELECT
  c.COLUMN_NAME AS field,
  IF(
    c.COLUMN_TYPE = 'longtext'
    AND EXISTS(
      SELECT
        *
      from
        information_schema.CHECK_CONSTRAINTS i_c
      WHERE
        i_c.CONSTRAINT_SCHEMA = 'bethesda'
        AND i_c.TABLE_NAME = c.TABLE_NAME
        AND i_c.CHECK_CLAUSE = CONCAT(
          'json_valid(`', c.COLUMN_NAME, '`)'
        )
    ),
    'json',
    c.COLUMN_TYPE
  ) AS type,
  c.IS_NULLABLE AS `null`,
  c.COLUMN_KEY AS `key`,
  c.COLUMN_DEFAULT AS `default`,
  c.EXTRA,
  c.COLUMN_COMMENT AS comment,
  c.CHARACTER_SET_NAME AS characterset,
  c.COLLATION_NAME AS collation
FROM
  information_schema.COLUMNS c
  INNER JOIN information_schema.TABLES t ON t.TABLE_NAME = c.TABLE_NAME
WHERE
  c.TABLE_SCHEMA = ?
  AND t.TABLE_SCHEMA = ?
  AND t.TABLE_TYPE = 'BASE TABLE'
  AND t.TABLE_NAME = ?
ORDER BY
  ORDINAL_POSITION

SELECT       c.COLUMN_NAME        AS field,
           IF(
        c.COLUMN_TYPE = 'longtext'
        AND EXISTS(
            SELECT * from information_schema.CHECK_CONSTRAINTS i_c
            WHERE i_c.CONSTRAINT_SCHEMA = 'bethesda'
            AND i_c.TABLE_NAME = c.TABLE_NAME
            AND i_c.CHECK_CLAUSE = CONCAT(
                'json_valid(`',
                    c.COLUMN_NAME,
                '`)'
            )
        ),
        'json',
        c.COLUMN_TYPE
    )       AS type,
       c.IS_NULLABLE        AS `null`,
       c.COLUMN_KEY         AS `key`,
       c.COLUMN_DEFAULT     AS `default`,
       c.EXTRA,
       c.COLUMN_COMMENT     AS comment,
       c.CHARACTER_SET_NAME AS characterset,
       c.COLLATION_NAME     AS collation
FROM information_schema.COLUMNS c
    INNER JOIN information_schema.TABLES t
        ON t.TABLE_NAME = c.TABLE_NAME
     WHERE c.TABLE_SCHEMA = 'bethesda' AND t.TABLE_SCHEMA = 'bethesda' AND t.TABLE_TYPE = 'BASE TABLE' AND t.TABLE_NAME = 'doctrine_migration_versions' ORDER BY ORDINAL_POSITION;