Symfony Profiler

"COMMIT"

"COMMIT";

SELECT
  s0_.id AS id_0,
  s0_.matricule AS matricule_1,
  s0_.firstname AS firstname_2,
  s0_.lastname AS lastname_3,
  s0_.particular_disease AS particular_disease_4,
  s0_.father_name AS father_name_5,
  s0_.mother_name AS mother_name_6,
  s0_.primary_contact AS primary_contact_7,
  s0_.residence AS residence_8,
  s0_.secondary_contact AS secondary_contact_9,
  s0_.other_informations AS other_informations_10,
  s0_.birthday AS birthday_11,
  s0_.gender AS gender_12,
  s0_.birthplace AS birthplace_13,
  s0_.enrolled AS enrolled_14,
  s0_.created_at AS created_at_15,
  s0_.updated_at AS updated_at_16,
  s0_.image_name AS image_name_17,
  s0_.entry_class_id AS entry_class_id_18
FROM
  student s0_
  LEFT JOIN subscription s1_ ON s0_.id = s1_.student_id
  LEFT JOIN class_room c2_ ON s1_.class_room_id = c2_.id
WHERE
  s1_.school_year_id = ?
  AND c2_.id = ?
ORDER BY
  s0_.lastname ASC

SELECT s0_.id AS id_0, s0_.matricule AS matricule_1, s0_.firstname AS firstname_2, s0_.lastname AS lastname_3, s0_.particular_disease AS particular_disease_4, s0_.father_name AS father_name_5, s0_.mother_name AS mother_name_6, s0_.primary_contact AS primary_contact_7, s0_.residence AS residence_8, s0_.secondary_contact AS secondary_contact_9, s0_.other_informations AS other_informations_10, s0_.birthday AS birthday_11, s0_.gender AS gender_12, s0_.birthplace AS birthplace_13, s0_.enrolled AS enrolled_14, s0_.created_at AS created_at_15, s0_.updated_at AS updated_at_16, s0_.image_name AS image_name_17, s0_.entry_class_id AS entry_class_id_18 FROM student s0_ LEFT JOIN subscription s1_ ON s0_.id = s1_.student_id LEFT JOIN class_room c2_ ON s1_.class_room_id = c2_.id WHERE s1_.school_year_id = 7 AND c2_.id = 26 ORDER BY s0_.lastname ASC;

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

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

SELECT
  t0.id AS id_1,
  t0.value AS value_2,
  t0.weight AS weight_3,
  t0.rank2 AS rank2_4,
  t0.appreciation AS appreciation_5,
  t0.student_id AS student_id_6,
  t0.evaluation_id AS evaluation_id_7
FROM
  mark t0
WHERE
  t0.evaluation_id = ?

SELECT t0.id AS id_1, t0.value AS value_2, t0.weight AS weight_3, t0.rank2 AS rank2_4, t0.appreciation AS appreciation_5, t0.student_id AS student_id_6, t0.evaluation_id AS evaluation_id_7 FROM mark t0 WHERE t0.evaluation_id = 12057;

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
  t0.id AS id_1,
  t0.email AS email_2,
  t0.github_id AS github_id_3,
  t0.github_access_token AS github_access_token_4,
  t0.facebook_id AS facebook_id_5,
  t0.facebook_access_token AS facebook_access_token_6,
  t0.google_id AS google_id_7,
  t0.google_access_token AS google_access_token_8,
  t0.linkedin_id AS linkedin_id_9,
  t0.linkedin_access_token AS linkedin_access_token_10,
  t0.twitter_id AS twitter_id_11,
  t0.twitter_access_token AS twitter_access_token_12,
  t0.yahoo_id AS yahoo_id_13,
  t0.yahoo_access_token AS yahoo_access_token_14,
  t0.password AS password_15,
  t0.is_verified AS is_verified_16,
  t0.avatarPath AS avatarPath_17,
  t0.phoneNumber AS phoneNumber_18,
  t0.gender AS gender_19,
  t0.birthday AS birthday_20,
  t0.birthplace AS birthplace_21,
  t0.nationality AS nationality_22,
  t0.location AS location_23,
  t0.region AS region_24,
  t0.department AS department_25,
  t0.academicLevel AS academicLevel_26,
  t0.numCni AS numCni_27,
  t0.status AS status_28,
  t0.full_name AS full_name_29,
  t0.security_question AS security_question_30,
  t0.security_answer AS security_answer_31,
  t0.created_at AS created_at_32,
  t0.updated_at AS updated_at_33,
  t0.image_name AS image_name_34,
  t0.domain_id AS domain_id_35
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.github_id AS github_id_3, t0.github_access_token AS github_access_token_4, t0.facebook_id AS facebook_id_5, t0.facebook_access_token AS facebook_access_token_6, t0.google_id AS google_id_7, t0.google_access_token AS google_access_token_8, t0.linkedin_id AS linkedin_id_9, t0.linkedin_access_token AS linkedin_access_token_10, t0.twitter_id AS twitter_id_11, t0.twitter_access_token AS twitter_access_token_12, t0.yahoo_id AS yahoo_id_13, t0.yahoo_access_token AS yahoo_access_token_14, t0.password AS password_15, t0.is_verified AS is_verified_16, t0.avatarPath AS avatarPath_17, t0.phoneNumber AS phoneNumber_18, t0.gender AS gender_19, t0.birthday AS birthday_20, t0.birthplace AS birthplace_21, t0.nationality AS nationality_22, t0.location AS location_23, t0.region AS region_24, t0.department AS department_25, t0.academicLevel AS academicLevel_26, t0.numCni AS numCni_27, t0.status AS status_28, t0.full_name AS full_name_29, t0.security_question AS security_question_30, t0.security_answer AS security_answer_31, t0.created_at AS created_at_32, t0.updated_at AS updated_at_33, t0.image_name AS image_name_34, t0.domain_id AS domain_id_35 FROM user t0 WHERE t0.id = 120;

UPDATE
  evaluation
SET
  success_f = ?,
  faillures_f = ?
WHERE
  id = ?

UPDATE evaluation SET success_f = 0, faillures_f = 0 WHERE id = 12057;

UPDATE
  evaluation
SET
  faillures_h = ?
WHERE
  id = ?

UPDATE evaluation SET faillures_h = 1 WHERE id = 12057;

SELECT
  t0.id AS id_1,
  t0.moyenne AS moyenne_2,
  t0.competence AS competence_3,
  t0.abscent AS abscent_4,
  t0.success_h AS success_h_5,
  t0.success_f AS success_f_6,
  t0.faillures_h AS faillures_h_7,
  t0.faillures_f AS faillures_f_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.sequence_id AS sequence_id_11,
  t0.course_id AS course_id_12,
  t0.class_room_id AS class_room_id_13,
  t0.author_id AS author_id_14
FROM
  evaluation t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.moyenne AS moyenne_2, t0.competence AS competence_3, t0.abscent AS abscent_4, t0.success_h AS success_h_5, t0.success_f AS success_f_6, t0.faillures_h AS faillures_h_7, t0.faillures_f AS faillures_f_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.sequence_id AS sequence_id_11, t0.course_id AS course_id_12, t0.class_room_id AS class_room_id_13, t0.author_id AS author_id_14 FROM evaluation t0 WHERE t0.id = '12057';

"START TRANSACTION"

"START TRANSACTION";