Symfony Profiler

SELECT
  t0.id AS id_5,
  t0.email AS email_6,
  t0.roles AS roles_7,
  t0.password AS password_8,
  t0.family_name AS family_name_9,
  t0.first_name AS first_name_10,
  t0.country AS country_11,
  t0.city AS city_12,
  t0.phone_number AS phone_number_13,
  t0.enrollment_at AS enrollment_at_14,
  t0.confirmed AS confirmed_15,
  t0.verification_token AS verification_token_16,
  t0.google_id AS google_id_17,
  t0.verification_code_oauth_token AS verification_code_oauth_token_18,
  t0.verification_code_oauth_refresh_token AS verification_code_oauth_refresh_token_19,
  t0.google_token_expires_at AS google_token_expires_at_20,
  t0.google_refresh_token_expires_at AS google_refresh_token_expires_at_21,
  t0.state_oauth_token AS state_oauth_token_22,
  t0.email_sended AS email_sended_23,
  t0.token_created_at AS token_created_at_24,
  t0.discriminator,
  t1.google_id AS google_id_25,
  t2.department AS department_26,
  t2.google_id AS google_id_27
FROM
  user t0
  LEFT JOIN student t1 ON t0.id = t1.id
  LEFT JOIN teacher t2 ON t0.id = t2.id
  LEFT JOIN `admin` t3 ON t0.id = t3.id
  LEFT JOIN super_admin t4 ON t0.id = t4.id
WHERE
  t0.email = ?
LIMIT
  1

SELECT t0.id AS id_5, t0.email AS email_6, t0.roles AS roles_7, t0.password AS password_8, t0.family_name AS family_name_9, t0.first_name AS first_name_10, t0.country AS country_11, t0.city AS city_12, t0.phone_number AS phone_number_13, t0.enrollment_at AS enrollment_at_14, t0.confirmed AS confirmed_15, t0.verification_token AS verification_token_16, t0.google_id AS google_id_17, t0.verification_code_oauth_token AS verification_code_oauth_token_18, t0.verification_code_oauth_refresh_token AS verification_code_oauth_refresh_token_19, t0.google_token_expires_at AS google_token_expires_at_20, t0.google_refresh_token_expires_at AS google_refresh_token_expires_at_21, t0.state_oauth_token AS state_oauth_token_22, t0.email_sended AS email_sended_23, t0.token_created_at AS token_created_at_24, t0.discriminator, t1.google_id AS google_id_25, t2.department AS department_26, t2.google_id AS google_id_27 FROM user t0 LEFT JOIN student t1 ON t0.id = t1.id LEFT JOIN teacher t2 ON t0.id = t2.id LEFT JOIN `admin` t3 ON t0.id = t3.id LEFT JOIN super_admin t4 ON t0.id = t4.id WHERE t0.email = 'nezha@monarkit.net' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3,
  t0.is_default_organisation AS is_default_organisation_4,
  t0.created_at AS created_at_5,
  t0.owner_id AS owner_id_6
FROM
  organisation t0
WHERE
  t0.owner_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.is_default_organisation AS is_default_organisation_4, t0.created_at AS created_at_5, t0.owner_id AS owner_id_6 FROM organisation t0 WHERE t0.owner_id = 322;

SELECT
  c0_.id AS id_0,
  c0_.title AS title_1,
  c0_.description AS description_2,
  c0_.state AS state_3,
  c0_.created_at AS created_at_4,
  c0_.updated_at AS updated_at_5,
  c0_.type AS type_6,
  c0_.deleted_at AS deleted_at_7,
  c0_.writing_assistance AS writing_assistance_8,
  c0_.allow_hand_writing AS allow_hand_writing_9,
  c0_.allow_upload_file AS allow_upload_file_10,
  c0_.due_date AS due_date_11,
  c0_.id_google_course_work AS id_google_course_work_12,
  c0_.max_points AS max_points_13,
  c0_.is_practice_mode AS is_practice_mode_14,
  c0_.rubric_id AS rubric_id_15,
  c0_.image_id AS image_id_16,
  c0_.teacher_id AS teacher_id_17,
  c0_.classroom_id AS classroom_id_18,
  c0_.quiz_id AS quiz_id_19,
  c0_.google_id AS google_id_20,
  c0_.setting_id AS setting_id_21
FROM
  coursework c0_
  LEFT JOIN classroom c1_ ON c0_.classroom_id = c1_.id
  AND (c1_.deleted_at IS NULL)
WHERE
  (
    c0_.id = ?
    AND c1_.teacher_id = ?
  )
  AND (c0_.deleted_at IS NULL)
ORDER BY
  c1_.id ASC

SELECT c0_.id AS id_0, c0_.title AS title_1, c0_.description AS description_2, c0_.state AS state_3, c0_.created_at AS created_at_4, c0_.updated_at AS updated_at_5, c0_.type AS type_6, c0_.deleted_at AS deleted_at_7, c0_.writing_assistance AS writing_assistance_8, c0_.allow_hand_writing AS allow_hand_writing_9, c0_.allow_upload_file AS allow_upload_file_10, c0_.due_date AS due_date_11, c0_.id_google_course_work AS id_google_course_work_12, c0_.max_points AS max_points_13, c0_.is_practice_mode AS is_practice_mode_14, c0_.rubric_id AS rubric_id_15, c0_.image_id AS image_id_16, c0_.teacher_id AS teacher_id_17, c0_.classroom_id AS classroom_id_18, c0_.quiz_id AS quiz_id_19, c0_.google_id AS google_id_20, c0_.setting_id AS setting_id_21 FROM coursework c0_ LEFT JOIN classroom c1_ ON c0_.classroom_id = c1_.id AND (c1_.deleted_at IS NULL) WHERE (c0_.id = 576 AND c1_.teacher_id = 322) AND (c0_.deleted_at IS NULL) ORDER BY c1_.id ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.language AS language_3,
  t0.code AS code_4,
  t0.created_at AS created_at_5,
  t0.deleted_at AS deleted_at_6,
  t0.id_google_classroom AS id_google_classroom_7,
  t0.teacher_id AS teacher_id_8,
  t0.teacher_id AS teacher_id_9,
  t0.organisation_id AS organisation_id_10,
  t0.organisation_id AS organisation_id_11,
  t0.subject_id AS subject_id_12,
  t0.grade_id AS grade_id_13
FROM
  classroom t0
WHERE
  t0.id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.name AS name_2, t0.language AS language_3, t0.code AS code_4, t0.created_at AS created_at_5, t0.deleted_at AS deleted_at_6, t0.id_google_classroom AS id_google_classroom_7, t0.teacher_id AS teacher_id_8, t0.teacher_id AS teacher_id_9, t0.organisation_id AS organisation_id_10, t0.organisation_id AS organisation_id_11, t0.subject_id AS subject_id_12, t0.grade_id AS grade_id_13 FROM classroom t0 WHERE t0.id = 163 AND ((t0.deleted_at IS NULL));

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.description AS description_3,
  t0.state AS state_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.type AS type_7,
  t0.deleted_at AS deleted_at_8,
  t0.writing_assistance AS writing_assistance_9,
  t0.allow_hand_writing AS allow_hand_writing_10,
  t0.allow_upload_file AS allow_upload_file_11,
  t0.due_date AS due_date_12,
  t0.id_google_course_work AS id_google_course_work_13,
  t0.max_points AS max_points_14,
  t0.is_practice_mode AS is_practice_mode_15,
  t0.rubric_id AS rubric_id_16,
  t0.image_id AS image_id_17,
  t0.teacher_id AS teacher_id_18,
  t0.classroom_id AS classroom_id_19,
  t0.quiz_id AS quiz_id_20,
  t0.google_id AS google_id_21,
  t0.setting_id AS setting_id_22
FROM
  coursework t0
WHERE
  t0.classroom_id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.state AS state_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.type AS type_7, t0.deleted_at AS deleted_at_8, t0.writing_assistance AS writing_assistance_9, t0.allow_hand_writing AS allow_hand_writing_10, t0.allow_upload_file AS allow_upload_file_11, t0.due_date AS due_date_12, t0.id_google_course_work AS id_google_course_work_13, t0.max_points AS max_points_14, t0.is_practice_mode AS is_practice_mode_15, t0.rubric_id AS rubric_id_16, t0.image_id AS image_id_17, t0.teacher_id AS teacher_id_18, t0.classroom_id AS classroom_id_19, t0.quiz_id AS quiz_id_20, t0.google_id AS google_id_21, t0.setting_id AS setting_id_22 FROM coursework t0 WHERE t0.classroom_id = 163 AND ((t0.deleted_at IS NULL));

SELECT
  t0.id AS id_1,
  t2.id AS id_3,
  t2.title AS title_4,
  t2.description AS description_5,
  t2.state AS state_6,
  t2.created_at AS created_at_7,
  t2.updated_at AS updated_at_8,
  t2.type AS type_9,
  t2.deleted_at AS deleted_at_10,
  t2.writing_assistance AS writing_assistance_11,
  t2.allow_hand_writing AS allow_hand_writing_12,
  t2.allow_upload_file AS allow_upload_file_13,
  t2.due_date AS due_date_14,
  t2.id_google_course_work AS id_google_course_work_15,
  t2.max_points AS max_points_16,
  t2.is_practice_mode AS is_practice_mode_17,
  t2.rubric_id AS rubric_id_18,
  t2.image_id AS image_id_19,
  t2.teacher_id AS teacher_id_20,
  t2.classroom_id AS classroom_id_21,
  t2.quiz_id AS quiz_id_22,
  t2.google_id AS google_id_23,
  t2.setting_id AS setting_id_24
FROM
  quiz t0
  LEFT JOIN coursework t2 ON t2.quiz_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t2.id AS id_3, t2.title AS title_4, t2.description AS description_5, t2.state AS state_6, t2.created_at AS created_at_7, t2.updated_at AS updated_at_8, t2.type AS type_9, t2.deleted_at AS deleted_at_10, t2.writing_assistance AS writing_assistance_11, t2.allow_hand_writing AS allow_hand_writing_12, t2.allow_upload_file AS allow_upload_file_13, t2.due_date AS due_date_14, t2.id_google_course_work AS id_google_course_work_15, t2.max_points AS max_points_16, t2.is_practice_mode AS is_practice_mode_17, t2.rubric_id AS rubric_id_18, t2.image_id AS image_id_19, t2.teacher_id AS teacher_id_20, t2.classroom_id AS classroom_id_21, t2.quiz_id AS quiz_id_22, t2.google_id AS google_id_23, t2.setting_id AS setting_id_24 FROM quiz t0 LEFT JOIN coursework t2 ON t2.quiz_id = t0.id WHERE t0.id = 712;

SELECT
  t0.id AS id_1,
  t0.question_text AS question_text_2,
  t0.is_justification AS is_justification_3,
  t0.context AS context_4,
  t0.type AS type_5,
  t0.links AS links_6,
  t0.grade AS grade_7,
  t0.rubric_id AS rubric_id_8,
  t0.google_id AS google_id_9
FROM
  question t0
  INNER JOIN quiz_questions ON t0.id = quiz_questions.question_id
WHERE
  quiz_questions.quiz_id = ?

SELECT t0.id AS id_1, t0.question_text AS question_text_2, t0.is_justification AS is_justification_3, t0.context AS context_4, t0.type AS type_5, t0.links AS links_6, t0.grade AS grade_7, t0.rubric_id AS rubric_id_8, t0.google_id AS google_id_9 FROM question t0 INNER JOIN quiz_questions ON t0.id = quiz_questions.question_id WHERE quiz_questions.quiz_id = 712;

SELECT
  t0.id AS id_1,
  t0.file_size AS file_size_2,
  t0.file_path AS file_path_3
FROM
  media_object t0
  INNER JOIN coursework_media_objects ON t0.id = coursework_media_objects.media_object_id
WHERE
  coursework_media_objects.question_id = ?

SELECT t0.id AS id_1, t0.file_size AS file_size_2, t0.file_path AS file_path_3 FROM media_object t0 INNER JOIN coursework_media_objects ON t0.id = coursework_media_objects.media_object_id WHERE coursework_media_objects.question_id = 2398;

SELECT
  t0.id AS id_1,
  t0.text AS text_2,
  t0.is_correct AS is_correct_3
FROM
  `option` t0
  INNER JOIN options_question ON t0.id = options_question.option_id
WHERE
  options_question.question_id = ?

SELECT t0.id AS id_1, t0.text AS text_2, t0.is_correct AS is_correct_3 FROM `option` t0 INNER JOIN options_question ON t0.id = options_question.option_id WHERE options_question.question_id = 2398;

SELECT
  t0.id AS id_1,
  t0.time_limit AS time_limit_2,
  t0.has_time_limit AS has_time_limit_3,
  t0.attempts AS attempts_4,
  t0.has_attempts AS has_attempts_5,
  t0.allow_paste AS allow_paste_6,
  t0.has_rubric AS has_rubric_7,
  t0.anonymous_grading AS anonymous_grading_8,
  t0.severity AS severity_9
FROM
  setting t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.time_limit AS time_limit_2, t0.has_time_limit AS has_time_limit_3, t0.attempts AS attempts_4, t0.has_attempts AS has_attempts_5, t0.allow_paste AS allow_paste_6, t0.has_rubric AS has_rubric_7, t0.anonymous_grading AS anonymous_grading_8, t0.severity AS severity_9 FROM setting t0 WHERE t0.id = 576;