POST https://uprim-madagascar.com/student/examen/redaction-de-presse-sem1-dup-68eac1-dup-d2506f/222

Query Metrics

59 Database Queries
12 Different statements
15.64 ms Query time
3 Invalid entities

Grouped Statements

Show all queries

Time Count Info
5.82 ms
(37.20%)
22
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:
[
  "273077"
]
3.20 ms
(20.48%)
1
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:
[
  12486
]
1.95 ms
(12.50%)
15
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:
[
  4037
]
1.49 ms
(9.52%)
13
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:
[
  12582
]
1.08 ms
(6.87%)
1
UPDATE subject_response SET is_responded = ?, logs = ? WHERE id = ?
Parameters:
[
  1
  "[{"event":"autosaveSuccess","details":"Sauvegarde r\u00e9ussie.","timestamp":"2025-07-16T03:46:25.769Z"},{"event":"audioRecordingStarted","details":"Enregistrement audio d\u00e9marr\u00e9 pour la question 273092","timestamp":"2025-07-16T03:49:25.694Z"},{"event":"audioRecordingStopped","details":"Arr\u00eat de l'enregistrement pour la question 273092","timestamp":"2025-07-16T03:51:25.096Z"},{"event":"autosave","details":"Autosave d\u00e9clench\u00e9.","timestamp":"2025-07-16T03:51:25.151Z"},{"event":"editorContent","details":"Contenu de tinymce-273083 mis \u00e0 jour : <p>La citation de JEAN LOUIS DUMORTIER met en lumi&egrave;re les conditions essentielles de l'&eacute;nnonciation c'est&nbsp; a dire l'acte de produire un message compr&eacute;hensible dans une situation donn&eacute;e :<\/p>\n<p>il nous rappelle que l'&eacute;nonciation est un acte complexe d&eacute;pandant de plusieurs conditions:l'un c'est que l'&eacute;metteur et le recepteurs sont clairement identifi&eacute;s et l'autre c'est que il y a un luangage commun qui permet l'echange et que la contexte est important;l'auteur met donc les &eacute;l&eacute;ments essentiels &agrave; l'&eacute;nonciation:ils permettent de garantir la r&eacute;ussite de l'acte de la communication;toutefois la communication humaine &eacute;volue dans le domaine de la technologie ainsi que les formes expressives ou artistiques et les diff&eacute;rences culturelles; le mod&egrave;le traditionnelde l'&eacute;nonciation reste &agrave; adapter aux r&eacute;alit&eacute;s contemporaines<\/p>","timestamp":"2025-07-16T03:51:25.159Z"},{"event":"audioRecordingSaved","details":"Enregistrement audio sauvegard\u00e9 pour la question 273092","timestamp":"2025-07-16T03:51:25.218Z"},{"event":"autosaveSuccess","details":"Sauvegarde r\u00e9ussie.","timestamp":"2025-07-16T03:51:27.213Z"},{"event":"questionValidated","details":"Question valid\u00e9e pour l'index 15","timestamp":"2025-07-16T03:51:28.130Z"},{"event":"resetAllTimers","details":"R\u00e9initialisation de tous les timers","timestamp":"2025-07-16T03:51:28.130Z"},{"event":"nextQuestion","details":"Passage \u00e0 la question suivante depuis l'index 15","timestamp":"2025-07-16T03:51:28.130Z"},{"event":"autosave","details":"Autosave d\u00e9clench\u00e9.","timestamp":"2025-07-16T03:51:28.130Z"},{"event":"editorContent","details":"Contenu de tinymce-273083 mis \u00e0 jour : <p>La citation de JEAN LOUIS DUMORTIER met en lumi&egrave;re les conditions essentielles de l'&eacute;nnonciation c'est&nbsp; a dire l'acte de produire un message compr&eacute;hensible dans une situation donn&eacute;e :<\/p>\n<p>il nous rappelle que l'&eacute;nonciation est un acte complexe d&eacute;pandant de plusieurs conditions:l'un c'est que l'&eacute;metteur et le recepteurs sont clairement identifi&eacute;s et l'autre c'est que il y a un luangage commun qui permet l'echange et que la contexte est important;l'auteur met donc les &eacute;l&eacute;ments essentiels &agrave; l'&eacute;nonciation:ils permettent de garantir la r&eacute;ussite de l'acte de la communication;toutefois la communication humaine &eacute;volue dans le domaine de la technologie ainsi que les formes expressives ou artistiques et les diff&eacute;rences culturelles; le mod&egrave;le traditionnelde l'&eacute;nonciation reste &agrave; adapter aux r&eacute;alit&eacute;s contemporaines<\/p>","timestamp":"2025-07-16T03:51:28.139Z"}]"
  273092
]
0.49 ms
(3.16%)
1
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:
[
  "redaction-de-presse-sem1-dup-68eac1-dup-d2506f"
]
0.37 ms
(2.38%)
1
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:
[
  "222"
]
0.34 ms
(2.17%)
1
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:
[
  948
]
0.33 ms
(2.09%)
1
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:
[
  948
  998
  222
]
0.29 ms
(1.88%)
1
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:
[
  12
]
0.16 ms
(1.03%)
1
"COMMIT"
Parameters:
[]
0.11 ms
(0.71%)
1
"START TRANSACTION"
Parameters:
[]

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.