Symfony Profiler

Query Metrics

41 Database Queries

12 Different statements

36.28 ms Query time

3 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

18.48 ms
(50.92%)

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"
]

View formatted query View runnable query Explain query View query backtrace

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 = ?

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 = '373500';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 789)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 807)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 530)
4	Doctrine\ORM\EntityManager->find (line 196)
5	Doctrine\ORM\EntityRepository->find (line 54)
6	App\Service\ResponseProcessorService->processResponses (line 138)
7	App\Controller\StudentController->doReview (line 181)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	require_once (line 5)

7.61 ms
(20.97%)

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
]

View formatted query View runnable query Explain query View query backtrace

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 = ?

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

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1944)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1885)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 3307)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 218)
6	Doctrine\ORM\PersistentCollection->initialize (line 157)
7	Doctrine\Common\Collections\AbstractLazyCollection->toArray (line 148)
8	App\Controller\StudentController->doReview (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

2.53 ms
(6.97%)

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
]

View formatted query View runnable query Explain query View query backtrace

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 = ?

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

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 789)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 807)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 365)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 472)
5	Proxies\__CG__\App\Entity\Question::Doctrine\ORM\Proxy\{closure} (line 100)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 185)
7	Proxies\__CG__\App\Entity\Question->__get (line 93)
8	App\Entity\Question->getType (line 117)
9	App\Service\ResponseProcessorService->calculateScore (line 82)
10	App\Service\ResponseProcessorService->processResponses (line 138)
11	App\Controller\StudentController->doReview (line 181)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
14	Symfony\Component\HttpKernel\Kernel->handle (line 35)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
16	require_once (line 5)

1.64 ms
(4.53%)

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"
]

View formatted query View runnable query Explain query View query backtrace

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

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 = 'etude-dimpact-environnemental-sem-2' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 789)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 240)
3	Doctrine\ORM\EntityRepository->findOneBy (line 108)
4	App\Controller\StudentController->doReview (line 181)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
7	Symfony\Component\HttpKernel\Kernel->handle (line 35)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
9	require_once (line 5)

1.31 ms
(3.62%)

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:

View formatted query View runnable query Explain query View query backtrace

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

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 = 268 AND t0.subject_id = 619 AND t0.review_level_id = 236 LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 789)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 240)
3	Doctrine\ORM\EntityRepository->findOneBy (line 35)
4	App\Service\ExamSessionService->getOrCreateExamSession (line 115)
5	App\Controller\StudentController->doReview (line 181)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

1.28 ms
(3.53%)

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
]

View formatted query View runnable query Explain query View query backtrace

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 = ?

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

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 789)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 807)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 530)
4	Doctrine\ORM\EntityManager->find (line 196)
5	Doctrine\ORM\EntityRepository->find (line 127)
6	App\Service\ResponseProcessorService->calculateScore (line 82)
7	App\Service\ResponseProcessorService->processResponses (line 138)
8	App\Controller\StudentController->doReview (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

0.74 ms
(2.04%)

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
]

View formatted query View runnable query Explain query View query backtrace

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 = ?

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

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 789)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 807)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 530)
4	Doctrine\ORM\EntityManager->find (line 196)
5	Doctrine\ORM\EntityRepository->find (line 92)
6	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 207)
7	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 127)
8	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 46)
9	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 26)
10	Symfony\Component\Security\Http\Firewall\AbstractListener->__invoke (line 60)
11	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->__invoke (line 80)
12	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 95)
13	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 116)
14	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
15	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
16	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
17	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 157)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
20	Symfony\Component\HttpKernel\Kernel->handle (line 35)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
22	require_once (line 5)

0.73 ms
(2.02%)

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
]

View formatted query View runnable query Explain query View query backtrace

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 = ?

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

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 789)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 807)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 365)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 472)
5	Proxies\__CG__\App\Entity\Review::Doctrine\ORM\Proxy\{closure} (line 100)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 185)
7	Proxies\__CG__\App\Entity\Review->__get (line 75)
8	App\Entity\Review->isVisible (line 13)
9	App\Service\ExamValidatorService->canAccessExam (line 104)
10	App\Controller\StudentController->doReview (line 181)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
13	Symfony\Component\HttpKernel\Kernel->handle (line 35)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
15	require_once (line 5)

0.69 ms
(1.90%)

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
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  subject_response
SET
  response = ?,
  score = ?,
  is_responded = ?,
  logs = ?
WHERE
  id = ?

UPDATE subject_response SET response = '27165', score = 0.5, is_responded = 1, logs = '[{\"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\"}]' WHERE id = 373504;

#	File/Call
1	Doctrine\DBAL\Connection->executeStatement (line 546)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->updateTable (line 432)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->update (line 1278)
4	Doctrine\ORM\UnitOfWork->executeUpdates (line 453)
5	Doctrine\ORM\UnitOfWork->commit (line 414)
6	Doctrine\ORM\EntityManager->flush (line 101)
7	App\Service\ResponseProcessorService->processResponses (line 138)
8	App\Controller\StudentController->doReview (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

0.64 ms
(1.77%)

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"
]

View formatted query View runnable query Explain query View query backtrace

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 = ?

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 = '236';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 789)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 807)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 530)
4	Doctrine\ORM\EntityManager->find (line 196)
5	Doctrine\ORM\EntityRepository->find (line 116)
6	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->find (line 63)
7	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 60)
8	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 91)
9	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 40)
10	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 173)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
13	Symfony\Component\HttpKernel\Kernel->handle (line 35)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
15	require_once (line 5)

0.33 ms
(0.91%)

"COMMIT"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"COMMIT"

"COMMIT";

#	File/Call
1	Doctrine\DBAL\Connection->doCommit (line 1454)
2	Doctrine\DBAL\Connection->commit (line 477)
3	Doctrine\ORM\UnitOfWork->commit (line 414)
4	Doctrine\ORM\EntityManager->flush (line 101)
5	App\Service\ResponseProcessorService->processResponses (line 138)
6	App\Controller\StudentController->doReview (line 181)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
9	Symfony\Component\HttpKernel\Kernel->handle (line 35)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
11	require_once (line 5)

0.30 ms
(0.82%)

"START TRANSACTION"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"START TRANSACTION"

"START TRANSACTION";

#	File/Call
1	Doctrine\DBAL\Connection->beginTransaction (line 427)
2	Doctrine\ORM\UnitOfWork->commit (line 414)
3	Doctrine\ORM\EntityManager->flush (line 101)
4	App\Service\ResponseProcessorService->processResponses (line 138)
5	App\Controller\StudentController->doReview (line 181)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

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.

Symfony Profiler

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

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping