POST https://uprim-madagascar.com/student/examen/etude-dimpact-environnemental-sem-2/236

Query Metrics

41 Database Queries
12 Different statements
36.28 ms Query time
3 Invalid entities

Queries

Group similar statements

# Time Info
1 0.74 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.activate AS activate_7, t0.avatar AS avatar_8, t0.matricule AS matricule_9, t0.lastname AS lastname_10, t0.firstname AS firstname_11, t0.is_eligible AS is_eligible_12, t0.created_by_id AS created_by_id_13, t0.updated_by_id AS updated_by_id_14, t0.review_level_id AS review_level_id_15, t0.student_group_id AS student_group_id_16 FROM user t0 WHERE t0.id = ?
Parameters:
[
  268
]
2 0.64 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.review_id AS review_id_3, t0.level_id AS level_id_4 FROM review_level t0 WHERE t0.id = ?
Parameters:
[
  "236"
]
3 0.73 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.visible AS visible_3, t0.enable AS enable_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.start_at AS start_at_7, t0.end_at AS end_at_8, t0.created_by_id AS created_by_id_9, t0.updated_by_id AS updated_by_id_10 FROM review t0 WHERE t0.id = ?
Parameters:
[
  13
]
4 1.64 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.slug AS slug_6, t0.duration AS duration_7, t0.created_by_id AS created_by_id_8, t0.updated_by_id AS updated_by_id_9, t0.course_id AS course_id_10, t0.user_id AS user_id_11 FROM subject t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "etude-dimpact-environnemental-sem-2"
]
5 1.31 ms
SELECT t0.id AS id_1, t0.start_at AS start_at_2, t0.status AS status_3, t0.updated_at AS updated_at_4, t0.student_group AS student_group_5, t0.current_question_index AS current_question_index_6, t0.student_id AS student_id_7, t0.subject_id AS subject_id_8, t0.review_level_id AS review_level_id_9 FROM do_subject t0 WHERE t0.student_id = ? AND t0.subject_id = ? AND t0.review_level_id = ? LIMIT 1
Parameters:
[
  268
  619
  236
]
6 0.50 ms
SELECT t0.id AS id_1, t0.response AS response_2, t0.score AS score_3, t0.is_responded AS is_responded_4, t0.logs AS logs_5, t0.started_at AS started_at_6, t0.question_id AS question_id_7, t0.student_id AS student_id_8, t0.do_subject_id AS do_subject_id_9 FROM subject_response t0 WHERE t0.id = ?
Parameters:
[
  "373500"
]
7 0.52 ms
SELECT t0.id AS id_1, t0.content AS content_2, t0.type AS type_3, t0.point AS point_4, t0.duration AS duration_5, t0.created_by_id AS created_by_id_6, t0.updated_by_id AS updated_by_id_7 FROM question t0 WHERE t0.id = ?
Parameters:
[
  9152
]
8 0.36 ms
SELECT t0.id AS id_1, t0.content AS content_2, t0.height AS height_3, t0.question_id AS question_id_4 FROM answer t0 WHERE t0.id = ?
Parameters:
[
  27195
]
9 0.56 ms
SELECT t0.id AS id_1, t0.response AS response_2, t0.score AS score_3, t0.is_responded AS is_responded_4, t0.logs AS logs_5, t0.started_at AS started_at_6, t0.question_id AS question_id_7, t0.student_id AS student_id_8, t0.do_subject_id AS do_subject_id_9 FROM subject_response t0 WHERE t0.id = ?
Parameters:
[
  "373501"
]
10 0.47 ms
SELECT t0.id AS id_1, t0.content AS content_2, t0.type AS type_3, t0.point AS point_4, t0.duration AS duration_5, t0.created_by_id AS created_by_id_6, t0.updated_by_id AS updated_by_id_7 FROM question t0 WHERE t0.id = ?
Parameters:
[
  15662
]
11 0.39 ms
SELECT t0.id AS id_1, t0.content AS content_2, t0.height AS height_3, t0.question_id AS question_id_4 FROM answer t0 WHERE t0.id = ?
Parameters:
[
  41808
]
12 9.56 ms
SELECT t0.id AS id_1, t0.response AS response_2, t0.score AS score_3, t0.is_responded AS is_responded_4, t0.logs AS logs_5, t0.started_at AS started_at_6, t0.question_id AS question_id_7, t0.student_id AS student_id_8, t0.do_subject_id AS do_subject_id_9 FROM subject_response t0 WHERE t0.id = ?
Parameters:
[
  "373502"
]
13 0.64 ms
SELECT t0.id AS id_1, t0.content AS content_2, t0.type AS type_3, t0.point AS point_4, t0.duration AS duration_5, t0.created_by_id AS created_by_id_6, t0.updated_by_id AS updated_by_id_7 FROM question t0 WHERE t0.id = ?
Parameters:
[
  15656
]
14 0.40 ms
SELECT t0.id AS id_1, t0.response AS response_2, t0.score AS score_3, t0.is_responded AS is_responded_4, t0.logs AS logs_5, t0.started_at AS started_at_6, t0.question_id AS question_id_7, t0.student_id AS student_id_8, t0.do_subject_id AS do_subject_id_9 FROM subject_response t0 WHERE t0.id = ?
Parameters:
[
  "373503"
]
15 0.29 ms
SELECT t0.id AS id_1, t0.content AS content_2, t0.type AS type_3, t0.point AS point_4, t0.duration AS duration_5, t0.created_by_id AS created_by_id_6, t0.updated_by_id AS updated_by_id_7 FROM question t0 WHERE t0.id = ?
Parameters:
[
  9141
]
16 0.27 ms
SELECT t0.id AS id_1, t0.content AS content_2, t0.height AS height_3, t0.question_id AS question_id_4 FROM answer t0 WHERE t0.id = ?
Parameters:
[
  27162
]
17 0.29 ms
SELECT t0.id AS id_1, t0.response AS response_2, t0.score AS score_3, t0.is_responded AS is_responded_4, t0.logs AS logs_5, t0.started_at AS started_at_6, t0.question_id AS question_id_7, t0.student_id AS student_id_8, t0.do_subject_id AS do_subject_id_9 FROM subject_response t0 WHERE t0.id = ?
Parameters:
[
  "373504"
]
18 0.38 ms
SELECT t0.id AS id_1, t0.content AS content_2, t0.type AS type_3, t0.point AS point_4, t0.duration AS duration_5, t0.created_by_id AS created_by_id_6, t0.updated_by_id AS updated_by_id_7 FROM question t0 WHERE t0.id = ?
Parameters:
[
  9142
]
19 0.26 ms
SELECT t0.id AS id_1, t0.content AS content_2, t0.height AS height_3, t0.question_id AS question_id_4 FROM answer t0 WHERE t0.id = ?
Parameters:
[
  27165
]
20 0.24 ms
SELECT t0.id AS id_1, t0.response AS response_2, t0.score AS score_3, t0.is_responded AS is_responded_4, t0.logs AS logs_5, t0.started_at AS started_at_6, t0.question_id AS question_id_7, t0.student_id AS student_id_8, t0.do_subject_id AS do_subject_id_9 FROM subject_response t0 WHERE t0.id = ?
Parameters:
[
  "373505"
]
21 0.23 ms
SELECT t0.id AS id_1, t0.content AS content_2, t0.type AS type_3, t0.point AS point_4, t0.duration AS duration_5, t0.created_by_id AS created_by_id_6, t0.updated_by_id AS updated_by_id_7 FROM question t0 WHERE t0.id = ?
Parameters:
[
  15655
]
22 0.27 ms
SELECT t0.id AS id_1, t0.response AS response_2, t0.score AS score_3, t0.is_responded AS is_responded_4, t0.logs AS logs_5, t0.started_at AS started_at_6, t0.question_id AS question_id_7, t0.student_id AS student_id_8, t0.do_subject_id AS do_subject_id_9 FROM subject_response t0 WHERE t0.id = ?
Parameters:
[
  "373506"
]
23 0.69 ms
SELECT t0.id AS id_1, t0.response AS response_2, t0.score AS score_3, t0.is_responded AS is_responded_4, t0.logs AS logs_5, t0.started_at AS started_at_6, t0.question_id AS question_id_7, t0.student_id AS student_id_8, t0.do_subject_id AS do_subject_id_9 FROM subject_response t0 WHERE t0.id = ?
Parameters:
[
  "373507"
]
24 0.56 ms
SELECT t0.id AS id_1, t0.response AS response_2, t0.score AS score_3, t0.is_responded AS is_responded_4, t0.logs AS logs_5, t0.started_at AS started_at_6, t0.question_id AS question_id_7, t0.student_id AS student_id_8, t0.do_subject_id AS do_subject_id_9 FROM subject_response t0 WHERE t0.id = ?
Parameters:
[
  "373508"
]
25 0.43 ms
SELECT t0.id AS id_1, t0.response AS response_2, t0.score AS score_3, t0.is_responded AS is_responded_4, t0.logs AS logs_5, t0.started_at AS started_at_6, t0.question_id AS question_id_7, t0.student_id AS student_id_8, t0.do_subject_id AS do_subject_id_9 FROM subject_response t0 WHERE t0.id = ?
Parameters:
[
  "373509"
]
26 0.39 ms
SELECT t0.id AS id_1, t0.response AS response_2, t0.score AS score_3, t0.is_responded AS is_responded_4, t0.logs AS logs_5, t0.started_at AS started_at_6, t0.question_id AS question_id_7, t0.student_id AS student_id_8, t0.do_subject_id AS do_subject_id_9 FROM subject_response t0 WHERE t0.id = ?
Parameters:
[
  "373510"
]
27 0.48 ms
SELECT t0.id AS id_1, t0.response AS response_2, t0.score AS score_3, t0.is_responded AS is_responded_4, t0.logs AS logs_5, t0.started_at AS started_at_6, t0.question_id AS question_id_7, t0.student_id AS student_id_8, t0.do_subject_id AS do_subject_id_9 FROM subject_response t0 WHERE t0.id = ?
Parameters:
[
  "373511"
]
28 0.52 ms
SELECT t0.id AS id_1, t0.response AS response_2, t0.score AS score_3, t0.is_responded AS is_responded_4, t0.logs AS logs_5, t0.started_at AS started_at_6, t0.question_id AS question_id_7, t0.student_id AS student_id_8, t0.do_subject_id AS do_subject_id_9 FROM subject_response t0 WHERE t0.id = ?
Parameters:
[
  "373512"
]
29 0.38 ms
SELECT t0.id AS id_1, t0.response AS response_2, t0.score AS score_3, t0.is_responded AS is_responded_4, t0.logs AS logs_5, t0.started_at AS started_at_6, t0.question_id AS question_id_7, t0.student_id AS student_id_8, t0.do_subject_id AS do_subject_id_9 FROM subject_response t0 WHERE t0.id = ?
Parameters:
[
  "373513"
]
30 0.33 ms
SELECT t0.id AS id_1, t0.response AS response_2, t0.score AS score_3, t0.is_responded AS is_responded_4, t0.logs AS logs_5, t0.started_at AS started_at_6, t0.question_id AS question_id_7, t0.student_id AS student_id_8, t0.do_subject_id AS do_subject_id_9 FROM subject_response t0 WHERE t0.id = ?
Parameters:
[
  "373514"
]
31 0.31 ms
SELECT t0.id AS id_1, t0.response AS response_2, t0.score AS score_3, t0.is_responded AS is_responded_4, t0.logs AS logs_5, t0.started_at AS started_at_6, t0.question_id AS question_id_7, t0.student_id AS student_id_8, t0.do_subject_id AS do_subject_id_9 FROM subject_response t0 WHERE t0.id = ?
Parameters:
[
  "373515"
]
32 0.30 ms
SELECT t0.id AS id_1, t0.response AS response_2, t0.score AS score_3, t0.is_responded AS is_responded_4, t0.logs AS logs_5, t0.started_at AS started_at_6, t0.question_id AS question_id_7, t0.student_id AS student_id_8, t0.do_subject_id AS do_subject_id_9 FROM subject_response t0 WHERE t0.id = ?
Parameters:
[
  "373516"
]
33 0.49 ms
SELECT t0.id AS id_1, t0.response AS response_2, t0.score AS score_3, t0.is_responded AS is_responded_4, t0.logs AS logs_5, t0.started_at AS started_at_6, t0.question_id AS question_id_7, t0.student_id AS student_id_8, t0.do_subject_id AS do_subject_id_9 FROM subject_response t0 WHERE t0.id = ?
Parameters:
[
  "373517"
]
34 0.57 ms
SELECT t0.id AS id_1, t0.response AS response_2, t0.score AS score_3, t0.is_responded AS is_responded_4, t0.logs AS logs_5, t0.started_at AS started_at_6, t0.question_id AS question_id_7, t0.student_id AS student_id_8, t0.do_subject_id AS do_subject_id_9 FROM subject_response t0 WHERE t0.id = ?
Parameters:
[
  "373518"
]
35 0.39 ms
SELECT t0.id AS id_1, t0.response AS response_2, t0.score AS score_3, t0.is_responded AS is_responded_4, t0.logs AS logs_5, t0.started_at AS started_at_6, t0.question_id AS question_id_7, t0.student_id AS student_id_8, t0.do_subject_id AS do_subject_id_9 FROM subject_response t0 WHERE t0.id = ?
Parameters:
[
  "373519"
]
36 0.37 ms
SELECT t0.id AS id_1, t0.response AS response_2, t0.score AS score_3, t0.is_responded AS is_responded_4, t0.logs AS logs_5, t0.started_at AS started_at_6, t0.question_id AS question_id_7, t0.student_id AS student_id_8, t0.do_subject_id AS do_subject_id_9 FROM subject_response t0 WHERE t0.id = ?
Parameters:
[
  "373520"
]
37 0.43 ms
SELECT t0.id AS id_1, t0.response AS response_2, t0.score AS score_3, t0.is_responded AS is_responded_4, t0.logs AS logs_5, t0.started_at AS started_at_6, t0.question_id AS question_id_7, t0.student_id AS student_id_8, t0.do_subject_id AS do_subject_id_9 FROM subject_response t0 WHERE t0.id = ?
Parameters:
[
  "373521"
]
38 0.30 ms
"START TRANSACTION"
Parameters:
[]
39 0.69 ms
UPDATE subject_response SET response = ?, score = ?, is_responded = ?, logs = ? WHERE id = ?
Parameters:
[
  "27165"
  0.5
  1
  "[{"event":"autosaveSuccess","details":"Sauvegarde r\u00e9ussie.","timestamp":"2025-12-29T08:27:46.048Z"},{"event":"questionValidated","details":"Question valid\u00e9e pour l'index 4","timestamp":"2025-12-29T08:28:28.579Z"},{"event":"resetAllTimers","details":"R\u00e9initialisation de tous les timers","timestamp":"2025-12-29T08:28:28.579Z"},{"event":"nextQuestion","details":"Passage \u00e0 la question suivante depuis l'index 4","timestamp":"2025-12-29T08:28:28.579Z"},{"event":"autosave","details":"Autosave d\u00e9clench\u00e9.","timestamp":"2025-12-29T08:28:28.579Z"},{"event":"editorContent","details":"Contenu de tinymce-373505 mis \u00e0 jour : ","timestamp":"2025-12-29T08:28:28.582Z"}]"
  373504
]
40 0.33 ms
"COMMIT"
Parameters:
[]
41 7.61 ms
SELECT t0.id AS id_1, t0.response AS response_2, t0.score AS score_3, t0.is_responded AS is_responded_4, t0.logs AS logs_5, t0.started_at AS started_at_6, t0.question_id AS question_id_7, t0.student_id AS student_id_8, t0.do_subject_id AS do_subject_id_9 FROM subject_response t0 WHERE t0.do_subject_id = ?
Parameters:
[
  17047
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class Mapping errors
App\Entity\User No errors.
App\Entity\ReviewLevel No errors.
App\Entity\Group No errors.
App\Entity\Subject No errors.
App\Entity\SubjectResponse
  • The association App\Entity\SubjectResponse#question refers to the inverse side field App\Entity\Question#student which does not exist.
App\Entity\DoSubject No errors.
App\Entity\StudentHistoryCour No errors.
App\Entity\UserBook No errors.
App\Entity\StudentReviewResult No errors.
App\Entity\Review No errors.
App\Entity\Level No errors.
App\Entity\Course No errors.
App\Entity\Question
  • The mappings App\Entity\Question#subjectResponses and App\Entity\SubjectResponse#question are inconsistent with each other.
App\Entity\Category
  • The field App\Entity\Category#question is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\Question#categories does not contain the required 'mappedBy="question"' attribute.
  • If association App\Entity\Category#question is many-to-one, then the inversed side App\Entity\Question#categories has to be one-to-many.
  • The association App\Entity\Category#answer refers to the inverse side field App\Entity\Answer#categories which does not exist.
App\Entity\Answer No errors.