Symfony Profiler

Query Metrics

425 Database Queries

11 Different statements

161.74 ms Query time

2 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

64.72 ms
(40.02%)

101

SELECT c0_.id AS id_0, c0_.correct_times AS correct_times_1, c0_.question_id AS question_id_2, c0_.user_id AS user_id_3 FROM critical_question c0_ WHERE c0_.user_id = ? AND c0_.question_id = ?

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.correct_times AS correct_times_1,
  c0_.question_id AS question_id_2,
  c0_.user_id AS user_id_3
FROM
  critical_question c0_
WHERE
  c0_.user_id = ?
  AND c0_.question_id = ?

SELECT c0_.id AS id_0, c0_.correct_times AS correct_times_1, c0_.question_id AS question_id_2, c0_.user_id AS user_id_3 FROM critical_question c0_ WHERE c0_.user_id = 41 AND c0_.question_id = 471289;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 29)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 284)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 738)
6	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 74)
7	App\Repository\CriticalQuestionsRepository->getOneByUserAndQuestion (line 70)
8	App\EventSubscriber\CriticalQuestionSubscriber->onCorrectAnswer (line 116)
9	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
10	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
11	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 72)
13	App\Processor\PostAnswerProcessor->processAnswer (line 44)
14	App\Processor\PostAnswerProcessor->process (line 52)
15	ApiPlatform\State\CallableProcessor->process (line 54)
16	ApiPlatform\State\Processor\WriteProcessor->process (line 111)
17	ApiPlatform\Symfony\Controller\MainController->__invoke (line 181)
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)

29.47 ms
(18.22%)

101

SELECT q0_.id AS id_0, q0_.title AS title_1, q0_.url_image AS url_image_2, q0_.dataset_question_id AS dataset_question_id_3, q0_.answers AS answers_4, q0_.subject_id AS subject_id_5 FROM question q0_ WHERE q0_.id = ?

Parameters:

[
  471289
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  q0_.id AS id_0,
  q0_.title AS title_1,
  q0_.url_image AS url_image_2,
  q0_.dataset_question_id AS dataset_question_id_3,
  q0_.answers AS answers_4,
  q0_.subject_id AS subject_id_5
FROM
  question q0_
WHERE
  q0_.id = ?

SELECT q0_.id AS id_0, q0_.title AS title_1, q0_.url_image AS url_image_2, q0_.dataset_question_id AS dataset_question_id_3, q0_.answers AS answers_4, q0_.subject_id AS subject_id_5 FROM question q0_ WHERE q0_.id = 471289;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 29)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 284)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 738)
6	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 84)
7	ApiPlatform\Doctrine\Orm\State\ItemProvider->provide (line 43)
8	ApiPlatform\State\CallableProvider->provide (line 98)
9	ApiPlatform\Symfony\Routing\IriConverter->getResourceFromIri (line 554)
10	ApiPlatform\Serializer\AbstractItemNormalizer->denormalizeRelation (line 875)
11	ApiPlatform\Serializer\AbstractItemNormalizer->createAndValidateAttributeValue (line 825)
12	ApiPlatform\Serializer\AbstractItemNormalizer->createAttributeValue (line 478)
13	ApiPlatform\Serializer\AbstractItemNormalizer->setAttributeValue (line 395)
14	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->denormalize (line 241)
15	ApiPlatform\Serializer\AbstractItemNormalizer->denormalize (line 72)
16	ApiPlatform\Serializer\ItemNormalizer->denormalize (line 32)
17	App\Serializer\PlainIdentifierDenormalizer->denormalize (line 84)
18	Symfony\Component\Serializer\Debug\TraceableNormalizer->denormalize (line 247)
19	Symfony\Component\Serializer\Serializer->denormalize (line 23)
20	App\Serializer\ArrayToCollectionDenormalizer->denormalize (line 84)
21	Symfony\Component\Serializer\Debug\TraceableNormalizer->denormalize (line 247)
22	Symfony\Component\Serializer\Serializer->denormalize (line 152)
23	Symfony\Component\Serializer\Serializer->deserialize (line 62)
24	Symfony\Component\Serializer\Debug\TraceableSerializer->deserialize (line 88)
25	ApiPlatform\State\Provider\DeserializeProvider->provide (line 53)
26	ApiPlatform\Symfony\Security\State\AccessCheckerProvider->provide (line 38)
27	ApiPlatform\Symfony\Validator\State\QueryParameterValidateProvider->provide (line 32)
28	ApiPlatform\Symfony\Validator\State\ValidateProvider->provide (line 53)
29	ApiPlatform\Symfony\Security\State\AccessCheckerProvider->provide (line 56)
30	ApiPlatform\State\Provider\ContentNegotiationProvider->provide (line 82)
31	ApiPlatform\Symfony\Controller\MainController->__invoke (line 181)
32	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
33	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
34	Symfony\Component\HttpKernel\Kernel->handle (line 35)
35	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
36	require_once (line 5)

28.11 ms
(17.38%)

101

SELECT l0_.id AS id_0, l0_.day AS day_1, l0_.mode AS mode_2, l0_.score AS score_3, l0_.start_at AS start_at_4, l0_.end_at AS end_at_5, l0_.created_at AS created_at_6, l0_.scheduled_at AS scheduled_at_7, l0_.status AS status_8, l0_.options AS options_9, l0_.admin_note AS admin_note_10, l0_.user_id AS user_id_11, l0_.dataset_version_id AS dataset_version_id_12, l0_.scheduled_learning_id AS scheduled_learning_id_13 FROM learning l0_ WHERE l0_.id = ? AND l0_.user_id = ?

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  l0_.id AS id_0,
  l0_.day AS day_1,
  l0_.mode AS mode_2,
  l0_.score AS score_3,
  l0_.start_at AS start_at_4,
  l0_.end_at AS end_at_5,
  l0_.created_at AS created_at_6,
  l0_.scheduled_at AS scheduled_at_7,
  l0_.status AS status_8,
  l0_.options AS options_9,
  l0_.admin_note AS admin_note_10,
  l0_.user_id AS user_id_11,
  l0_.dataset_version_id AS dataset_version_id_12,
  l0_.scheduled_learning_id AS scheduled_learning_id_13
FROM
  learning l0_
WHERE
  l0_.id = ?
  AND l0_.user_id = ?

SELECT l0_.id AS id_0, l0_.day AS day_1, l0_.mode AS mode_2, l0_.score AS score_3, l0_.start_at AS start_at_4, l0_.end_at AS end_at_5, l0_.created_at AS created_at_6, l0_.scheduled_at AS scheduled_at_7, l0_.status AS status_8, l0_.options AS options_9, l0_.admin_note AS admin_note_10, l0_.user_id AS user_id_11, l0_.dataset_version_id AS dataset_version_id_12, l0_.scheduled_learning_id AS scheduled_learning_id_13 FROM learning l0_ WHERE l0_.id = 80249 AND l0_.user_id = 41;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 29)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 284)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 738)
6	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 84)
7	ApiPlatform\Doctrine\Orm\State\ItemProvider->provide (line 43)
8	ApiPlatform\State\CallableProvider->provide (line 98)
9	ApiPlatform\Symfony\Routing\IriConverter->getResourceFromIri (line 554)
10	ApiPlatform\Serializer\AbstractItemNormalizer->denormalizeRelation (line 875)
11	ApiPlatform\Serializer\AbstractItemNormalizer->createAndValidateAttributeValue (line 825)
12	ApiPlatform\Serializer\AbstractItemNormalizer->createAttributeValue (line 478)
13	ApiPlatform\Serializer\AbstractItemNormalizer->setAttributeValue (line 395)
14	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->denormalize (line 241)
15	ApiPlatform\Serializer\AbstractItemNormalizer->denormalize (line 72)
16	ApiPlatform\Serializer\ItemNormalizer->denormalize (line 32)
17	App\Serializer\PlainIdentifierDenormalizer->denormalize (line 84)
18	Symfony\Component\Serializer\Debug\TraceableNormalizer->denormalize (line 247)
19	Symfony\Component\Serializer\Serializer->denormalize (line 23)
20	App\Serializer\ArrayToCollectionDenormalizer->denormalize (line 84)
21	Symfony\Component\Serializer\Debug\TraceableNormalizer->denormalize (line 247)
22	Symfony\Component\Serializer\Serializer->denormalize (line 152)
23	Symfony\Component\Serializer\Serializer->deserialize (line 62)
24	Symfony\Component\Serializer\Debug\TraceableSerializer->deserialize (line 88)
25	ApiPlatform\State\Provider\DeserializeProvider->provide (line 53)
26	ApiPlatform\Symfony\Security\State\AccessCheckerProvider->provide (line 38)
27	ApiPlatform\Symfony\Validator\State\QueryParameterValidateProvider->provide (line 32)
28	ApiPlatform\Symfony\Validator\State\ValidateProvider->provide (line 53)
29	ApiPlatform\Symfony\Security\State\AccessCheckerProvider->provide (line 56)
30	ApiPlatform\State\Provider\ContentNegotiationProvider->provide (line 82)
31	ApiPlatform\Symfony\Controller\MainController->__invoke (line 181)
32	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
33	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
34	Symfony\Component\HttpKernel\Kernel->handle (line 35)
35	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
36	require_once (line 5)

24.83 ms
(15.35%)

101

SELECT t0.id AS id_1, t0.content AS content_2, t0.question_id AS question_id_3, t0.user_id AS user_id_4 FROM notes t0 WHERE t0.question_id = ?

Parameters:

[
  471289
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.content AS content_2,
  t0.question_id AS question_id_3,
  t0.user_id AS user_id_4
FROM
  notes t0
WHERE
  t0.question_id = ?

SELECT t0.id AS id_1, t0.content AS content_2, t0.question_id AS question_id_3, t0.user_id AS user_id_4 FROM notes t0 WHERE t0.question_id = 471289;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 808)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToOneEntity (line 2440)
4	Doctrine\ORM\UnitOfWork->createEntity (line 264)
5	Doctrine\ORM\Internal\Hydration\ObjectHydrator->getEntity (line 487)
6	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateRowData (line 143)
7	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateAllData (line 168)
8	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 948)
9	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
10	Doctrine\ORM\AbstractQuery->execute (line 738)
11	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 84)
12	ApiPlatform\Doctrine\Orm\State\ItemProvider->provide (line 43)
13	ApiPlatform\State\CallableProvider->provide (line 98)
14	ApiPlatform\Symfony\Routing\IriConverter->getResourceFromIri (line 554)
15	ApiPlatform\Serializer\AbstractItemNormalizer->denormalizeRelation (line 875)
16	ApiPlatform\Serializer\AbstractItemNormalizer->createAndValidateAttributeValue (line 825)
17	ApiPlatform\Serializer\AbstractItemNormalizer->createAttributeValue (line 478)
18	ApiPlatform\Serializer\AbstractItemNormalizer->setAttributeValue (line 395)
19	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->denormalize (line 241)
20	ApiPlatform\Serializer\AbstractItemNormalizer->denormalize (line 72)
21	ApiPlatform\Serializer\ItemNormalizer->denormalize (line 32)
22	App\Serializer\PlainIdentifierDenormalizer->denormalize (line 84)
23	Symfony\Component\Serializer\Debug\TraceableNormalizer->denormalize (line 247)
24	Symfony\Component\Serializer\Serializer->denormalize (line 23)
25	App\Serializer\ArrayToCollectionDenormalizer->denormalize (line 84)
26	Symfony\Component\Serializer\Debug\TraceableNormalizer->denormalize (line 247)
27	Symfony\Component\Serializer\Serializer->denormalize (line 152)
28	Symfony\Component\Serializer\Serializer->deserialize (line 62)
29	Symfony\Component\Serializer\Debug\TraceableSerializer->deserialize (line 88)
30	ApiPlatform\State\Provider\DeserializeProvider->provide (line 53)
31	ApiPlatform\Symfony\Security\State\AccessCheckerProvider->provide (line 38)
32	ApiPlatform\Symfony\Validator\State\QueryParameterValidateProvider->provide (line 32)
33	ApiPlatform\Symfony\Validator\State\ValidateProvider->provide (line 53)
34	ApiPlatform\Symfony\Security\State\AccessCheckerProvider->provide (line 56)
35	ApiPlatform\State\Provider\ContentNegotiationProvider->provide (line 82)
36	ApiPlatform\Symfony\Controller\MainController->__invoke (line 181)
37	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
38	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
39	Symfony\Component\HttpKernel\Kernel->handle (line 35)
40	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
41	require_once (line 5)

8.92 ms
(5.52%)

"COMMIT"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"COMMIT"

"COMMIT";

#	File/Call
1	Doctrine\DBAL\Connection->doCommit (line 1427)
2	Doctrine\DBAL\Connection->commit (line 429)
3	Doctrine\ORM\UnitOfWork->commit (line 259)
4	Doctrine\ORM\EntityManager->flush (line 91)
5	App\Repository\CriticalQuestionsRepository->remove (line 79)
6	App\EventSubscriber\CriticalQuestionSubscriber->onCorrectAnswer (line 116)
7	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
8	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
9	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
10	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 72)
11	App\Processor\PostAnswerProcessor->processAnswer (line 44)
12	App\Processor\PostAnswerProcessor->process (line 52)
13	ApiPlatform\State\CallableProcessor->process (line 54)
14	ApiPlatform\State\Processor\WriteProcessor->process (line 111)
15	ApiPlatform\Symfony\Controller\MainController->__invoke (line 181)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
18	Symfony\Component\HttpKernel\Kernel->handle (line 35)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
20	require_once (line 5)

1.80 ms
(1.11%)

UPDATE critical_question SET correct_times = ? WHERE id = ?

Parameters:

View formatted query View runnable query Explain query View query backtrace

UPDATE
  critical_question
SET
  correct_times = ?
WHERE
  id = ?

UPDATE critical_question SET correct_times = 3 WHERE id = 399679;

#	File/Call
1	Doctrine\DBAL\Connection->executeStatement (line 490)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->updateTable (line 374)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->update (line 1126)
4	Doctrine\ORM\UnitOfWork->executeUpdates (line 404)
5	Doctrine\ORM\UnitOfWork->commit (line 259)
6	Doctrine\ORM\EntityManager->flush (line 82)
7	App\EventSubscriber\CriticalQuestionSubscriber->onCorrectAnswer (line 116)
8	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
9	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
10	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
11	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 72)
12	App\Processor\PostAnswerProcessor->processAnswer (line 44)
13	App\Processor\PostAnswerProcessor->process (line 52)
14	ApiPlatform\State\CallableProcessor->process (line 54)
15	ApiPlatform\State\Processor\WriteProcessor->process (line 111)
16	ApiPlatform\Symfony\Controller\MainController->__invoke (line 181)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
19	Symfony\Component\HttpKernel\Kernel->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
21	require_once (line 5)

1.57 ms
(0.97%)

"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 380)
2	Doctrine\ORM\UnitOfWork->commit (line 259)
3	Doctrine\ORM\EntityManager->flush (line 91)
4	App\Repository\CriticalQuestionsRepository->remove (line 79)
5	App\EventSubscriber\CriticalQuestionSubscriber->onCorrectAnswer (line 116)
6	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
7	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
8	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
9	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 72)
10	App\Processor\PostAnswerProcessor->processAnswer (line 44)
11	App\Processor\PostAnswerProcessor->process (line 52)
12	ApiPlatform\State\CallableProcessor->process (line 54)
13	ApiPlatform\State\Processor\WriteProcessor->process (line 111)
14	ApiPlatform\Symfony\Controller\MainController->__invoke (line 181)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
17	Symfony\Component\HttpKernel\Kernel->handle (line 35)
18	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
19	require_once (line 5)

1.45 ms
(0.89%)

DELETE FROM critical_question WHERE id = ?

Parameters:

[
  348769
]

View formatted query View runnable query Explain query View query backtrace

DELETE FROM
  critical_question
WHERE
  id = ?

DELETE FROM critical_question WHERE id = 348769;

#	File/Call
1	Doctrine\DBAL\Connection->executeStatement (line 698)
2	Doctrine\DBAL\Connection->delete (line 563)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->delete (line 1153)
4	Doctrine\ORM\UnitOfWork->executeDeletions (line 424)
5	Doctrine\ORM\UnitOfWork->commit (line 259)
6	Doctrine\ORM\EntityManager->flush (line 91)
7	App\Repository\CriticalQuestionsRepository->remove (line 79)
8	App\EventSubscriber\CriticalQuestionSubscriber->onCorrectAnswer (line 116)
9	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
10	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
11	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 72)
13	App\Processor\PostAnswerProcessor->processAnswer (line 44)
14	App\Processor\PostAnswerProcessor->process (line 52)
15	ApiPlatform\State\CallableProcessor->process (line 54)
16	ApiPlatform\State\Processor\WriteProcessor->process (line 111)
17	ApiPlatform\Symfony\Controller\MainController->__invoke (line 181)
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.36 ms
(0.23%)

SELECT t0.price_payed AS price_payed_1, t0.currency AS currency_2, t0.gateway AS gateway_3, t0.gateway_identifier AS gateway_identifier_4, t0.billing_address AS billing_address_5, t0.created_at AS created_at_6, t0.payed_at AS payed_at_7, t0.is_invoiced AS is_invoiced_8, t0.membership_id AS membership_id_9 FROM transaction t0 WHERE t0.membership_id = ?

Parameters:

[
  839
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.price_payed AS price_payed_1,
  t0.currency AS currency_2,
  t0.gateway AS gateway_3,
  t0.gateway_identifier AS gateway_identifier_4,
  t0.billing_address AS billing_address_5,
  t0.created_at AS created_at_6,
  t0.payed_at AS payed_at_7,
  t0.is_invoiced AS is_invoiced_8,
  t0.membership_id AS membership_id_9
FROM
  transaction t0
WHERE
  t0.membership_id = ?

SELECT t0.price_payed AS price_payed_1, t0.currency AS currency_2, t0.gateway AS gateway_3, t0.gateway_identifier AS gateway_identifier_4, t0.billing_address AS billing_address_5, t0.created_at AS created_at_6, t0.payed_at AS payed_at_7, t0.is_invoiced AS is_invoiced_8, t0.membership_id AS membership_id_9 FROM transaction t0 WHERE t0.membership_id = 839;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 808)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToOneEntity (line 2440)
4	Doctrine\ORM\UnitOfWork->createEntity (line 264)
5	Doctrine\ORM\Internal\Hydration\ObjectHydrator->getEntity (line 487)
6	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateRowData (line 143)
7	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateAllData (line 168)
8	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 948)
9	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
10	Doctrine\ORM\AbstractQuery->execute (line 738)
11	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 61)
12	App\Repository\MembershipRepository->getLastActiveByUser (line 38)
13	App\EventSubscriber\CheckMembershipIsValidSubscriber->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.26 ms
(0.16%)

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.name AS name_5, t0.last_name AS last_name_6, t0.tax_id AS tax_id_7 FROM `user` t0 WHERE t0.email = ? LIMIT 1

Parameters:

[
  "dominich20033@gmail.com"
]

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.name AS name_5,
  t0.last_name AS last_name_6,
  t0.tax_id AS tax_id_7
FROM
  `user` t0
WHERE
  t0.email = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.name AS name_5, t0.last_name AS last_name_6, t0.tax_id AS tax_id_7 FROM `user` t0 WHERE t0.email = 'dominich20033@gmail.com' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 80)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 54)
5	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->loadUserByIdentifier (line 251)
6	Lexik\Bundle\JWTAuthenticationBundle\Security\Authenticator\JWTAuthenticator->loadUser (line 132)
7	Lexik\Bundle\JWTAuthenticationBundle\Security\Authenticator\JWTAuthenticator->Lexik\Bundle\JWTAuthenticationBundle\Security\Authenticator\{closure} (line 87)
8	Symfony\Component\Security\Http\Authenticator\Passport\Badge\UserBadge->getUser (line 56)
9	Symfony\Component\Security\Http\Authenticator\Passport\Passport->getUser (line 42)
10	Symfony\Component\Security\Http\EventListener\UserCheckerListener->preCheckCredentials (line 116)
11	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
12	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
13	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
14	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 180)
15	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 158)
16	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 140)
17	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 40)
18	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 68)
19	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 46)
20	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 26)
21	Symfony\Component\Security\Http\Firewall\AbstractListener->__invoke (line 60)
22	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->__invoke (line 80)
23	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 95)
24	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 116)
25	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
26	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
27	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
28	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 157)
29	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
30	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
31	Symfony\Component\HttpKernel\Kernel->handle (line 35)
32	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
33	require_once (line 5)

0.24 ms
(0.15%)

SELECT m0_.id AS id_0, m0_.uuid AS uuid_1, m0_.expire_at AS expire_at_2, m0_.created_at AS created_at_3, m0_.license_id AS license_id_4, m0_.user_id AS user_id_5 FROM membership m0_ WHERE m0_.user_id = ? ORDER BY m0_.id DESC LIMIT 1

Parameters:

[
  41
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  m0_.id AS id_0,
  m0_.uuid AS uuid_1,
  m0_.expire_at AS expire_at_2,
  m0_.created_at AS created_at_3,
  m0_.license_id AS license_id_4,
  m0_.user_id AS user_id_5
FROM
  membership m0_
WHERE
  m0_.user_id = ?
ORDER BY
  m0_.id DESC
LIMIT
  1

SELECT m0_.id AS id_0, m0_.uuid AS uuid_1, m0_.expire_at AS expire_at_2, m0_.created_at AS created_at_3, m0_.license_id AS license_id_4, m0_.user_id AS user_id_5 FROM membership m0_ WHERE m0_.user_id = 41 ORDER BY m0_.id DESC LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 29)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 284)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 738)
6	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 61)
7	App\Repository\MembershipRepository->getLastActiveByUser (line 38)
8	App\EventSubscriber\CheckMembershipIsValidSubscriber->onKernelRequest (line 116)
9	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
10	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
11	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 157)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
15	Symfony\Component\HttpKernel\Kernel->handle (line 35)
16	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
17	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
Gesdinet\JWTRefreshTokenBundle\Entity\RefreshToken	No errors.
App\Entity\RefreshToken	No errors.
App\Entity\User	No errors.
App\Entity\Dataset	No errors.
App\Entity\Membership	No errors.
App\Entity\License	No errors.
App\Entity\Transaction	No errors.
App\Entity\Question	No errors.
App\Entity\Subject	No errors.
App\Entity\Note	No errors.
App\Entity\DatasetVersion	No errors.
App\Entity\Tag	No errors.
App\Entity\Suggestions	No errors.
App\Entity\Highlight	The association App\Entity\Highlight#owner refers to the inverse side field App\Entity\User#highlights which does not exist.
App\Entity\Learning	No errors.
App\Entity\ScheduledLearning	The field App\Entity\ScheduledLearning#learnings is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Learning#scheduledLearning does not contain the required 'inversedBy="learnings"' attribute.
App\Entity\UserAnswer	No errors.
App\Entity\CriticalQuestion	No errors.

Symfony Profiler

POST https://api.simulatorestrategico.com/answers

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping