Symfony Profiler

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

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.name AS name_2,
  t0.apc AS apc_3,
  t0.level_id AS level_id_4
FROM
  class_room t0
WHERE
  t0.id = ?
LIMIT
  1

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 = '12' LIMIT 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.id IS NULL
LIMIT
  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.id IS NULL 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.id IS NULL
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.id IS NULL 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.activated = ?
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.activated = 1 LIMIT 1;

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.matricule = ?
LIMIT
  1

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.matricule = '202410100049' LIMIT 1;

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.matricule = ?
LIMIT
  1

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.matricule = '202410110002' LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO evaluation (
  moyenne, competence, abscent, success_h,
  success_f, faillures_h, faillures_f,
  created_at, updated_at, sequence_id,
  course_id, class_room_id, author_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO evaluation (moyenne, competence, abscent, success_h, success_f, faillures_h, faillures_f, created_at, updated_at, sequence_id, course_id, class_room_id, author_id) VALUES (13.5, '', 0, 0, 2, 0, 0, '2024-10-30 19:11:19', '2024-10-30 19:11:19', 38, NULL, 12, 127);

"ROLLBACK"

"ROLLBACK";

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;