Symfony Profiler

Query Metrics

16 Database Queries

6 Different statements

3.67 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

2.27 ms
(61.95%)

SELECT t0.id AS id_1, t0.name AS name_2 FROM subject t0 WHERE t0.id = ?

Parameters:

[
  8
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  subject t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2 FROM subject t0 WHERE t0.id = 8;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 752)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 221)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 100)
5	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 178)
6	Proxies\__CG__\App\Entity\Subject->__get (line 30)
7	App\Entity\Subject->getName (line 398)
8	Symfony\Component\PropertyAccess\PropertyAccessor->readProperty (line 99)
9	Symfony\Component\PropertyAccess\PropertyAccessor->getValue (line 142)
10	Symfony\Component\Serializer\Normalizer\ObjectNormalizer->getAttributeValue (line 192)
11	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->normalize (line 58)
12	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 159)
13	Symfony\Component\Serializer\Serializer->normalize (line 731)
14	ApiPlatform\Serializer\AbstractItemNormalizer->getAttributeValue (line 192)
15	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->normalize (line 171)
16	ApiPlatform\Serializer\AbstractItemNormalizer->normalize (line 58)
17	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 159)
18	Symfony\Component\Serializer\Serializer->normalize (line 177)
19	Symfony\Component\Serializer\Serializer->normalize (line 138)
20	Symfony\Component\Serializer\Serializer->serialize (line 47)
21	Symfony\Component\Serializer\Debug\TraceableSerializer->serialize (line 37)
22	App\Controller\GetQuestionsSubjectSchema->__invoke (line 181)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
25	Symfony\Component\HttpKernel\Kernel->handle (line 35)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
27	require_once (line 5)

0.36 ms
(9.93%)

SELECT t0.id AS id_1, t0.pdf AS pdf_2, t0.status AS status_3, t0.name AS name_4, t0.exam_duration AS exam_duration_5, t0.exam_question_number AS exam_question_number_6, t0.exam_answer_number AS exam_answer_number_7, t0.score_error AS score_error_8, t0.score_blank AS score_blank_9, t0.score_correct AS score_correct_10, t0.score_type AS score_type_11, t0.score_threshold AS score_threshold_12, t0.created_at AS created_at_13, t0.dataset_id AS dataset_id_14 FROM dataset_version t0 WHERE t0.id = ?

Parameters:

[
  "36"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.pdf AS pdf_2,
  t0.status AS status_3,
  t0.name AS name_4,
  t0.exam_duration AS exam_duration_5,
  t0.exam_question_number AS exam_question_number_6,
  t0.exam_answer_number AS exam_answer_number_7,
  t0.score_error AS score_error_8,
  t0.score_blank AS score_blank_9,
  t0.score_correct AS score_correct_10,
  t0.score_type AS score_type_11,
  t0.score_threshold AS score_threshold_12,
  t0.created_at AS created_at_13,
  t0.dataset_id AS dataset_id_14
FROM
  dataset_version t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.pdf AS pdf_2, t0.status AS status_3, t0.name AS name_4, t0.exam_duration AS exam_duration_5, t0.exam_question_number AS exam_question_number_6, t0.exam_answer_number AS exam_answer_number_7, t0.score_error AS score_error_8, t0.score_blank AS score_blank_9, t0.score_correct AS score_correct_10, t0.score_type AS score_type_11, t0.score_threshold AS score_threshold_12, t0.created_at AS created_at_13, t0.dataset_id AS dataset_id_14 FROM dataset_version t0 WHERE t0.id = '36';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 752)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 357)
4	Doctrine\ORM\EntityManager->find (line 86)
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.35 ms
(9.65%)

SELECT d0_.id AS id_0, d0_.number AS number_1, d0_.dataset_version_id AS dataset_version_id_2, d0_.subject_id AS subject_id_3 FROM dataset_version_has_subject d0_ INNER JOIN subject s1_ ON d0_.subject_id = s1_.id WHERE d0_.dataset_version_id = ?

Parameters:

[
  36
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  d0_.id AS id_0,
  d0_.number AS number_1,
  d0_.dataset_version_id AS dataset_version_id_2,
  d0_.subject_id AS subject_id_3
FROM
  dataset_version_has_subject d0_
  INNER JOIN subject s1_ ON d0_.subject_id = s1_.id
WHERE
  d0_.dataset_version_id = ?

SELECT d0_.id AS id_0, d0_.number AS number_1, d0_.dataset_version_id AS dataset_version_id_2, d0_.subject_id AS subject_id_3 FROM dataset_version_has_subject d0_ INNER JOIN subject s1_ ON d0_.subject_id = s1_.id WHERE d0_.dataset_version_id = 36;

#	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 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 127)
7	App\Repository\DatasetVersionRepository->getQuestionsSubjectsSchema (line 38)
8	App\Controller\GetQuestionsSubjectSchema->__invoke (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.24 ms
(6.41%)

SELECT d0_.id AS id_0, d0_.number AS number_1, s1_.id AS id_2, s1_.name AS name_3, d0_.dataset_version_id AS dataset_version_id_4, d0_.subject_id AS subject_id_5 FROM dataset_version_has_subject d0_ LEFT JOIN subject s1_ ON d0_.subject_id = s1_.id WHERE d0_.id = ? ORDER BY d0_.id ASC LIMIT 20

Parameters:

[
  36
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  d0_.id AS id_0,
  d0_.number AS number_1,
  s1_.id AS id_2,
  s1_.name AS name_3,
  d0_.dataset_version_id AS dataset_version_id_4,
  d0_.subject_id AS subject_id_5
FROM
  dataset_version_has_subject d0_
  LEFT JOIN subject s1_ ON d0_.subject_id = s1_.id
WHERE
  d0_.id = ?
ORDER BY
  d0_.id ASC
LIMIT
  20

SELECT d0_.id AS id_0, d0_.number AS number_1, s1_.id AS id_2, s1_.name AS name_3, d0_.dataset_version_id AS dataset_version_id_4, d0_.subject_id AS subject_id_5 FROM dataset_version_has_subject d0_ LEFT JOIN subject s1_ ON d0_.subject_id = s1_.id WHERE d0_.id = 36 ORDER BY d0_.id ASC LIMIT 20;

#	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 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 151)
7	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 69)
8	ApiPlatform\Doctrine\Orm\AbstractPaginator->getIterator (line 77)
9	ApiPlatform\Doctrine\Orm\AbstractPaginator->count (line 21)
10	App\Listener\PaginationHeadersListener->addHeaders (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 214)
15	Symfony\Component\HttpKernel\HttpKernel->filterResponse (line 202)
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)

0.22 ms
(6.11%)

SELECT SUM(d0_.number) AS sclr_0 FROM dataset_version_has_subject d0_ WHERE d0_.dataset_version_id = ?

Parameters:

[
  36
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  SUM(d0_.number) AS sclr_0
FROM
  dataset_version_has_subject d0_
WHERE
  d0_.dataset_version_id = ?

SELECT SUM(d0_.number) AS sclr_0 FROM dataset_version_has_subject d0_ WHERE d0_.dataset_version_id = 36;

#	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 773)
6	Doctrine\ORM\AbstractQuery->getSingleResult (line 802)
7	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 141)
8	App\Repository\DatasetVersionRepository->getSchemaTotalQuestionsNumber (line 43)
9	App\Controller\GetQuestionsSubjectSchema->__invoke (line 181)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

0.22 ms
(5.94%)

SELECT COUNT(DISTINCT d0_.id) AS sclr_0 FROM dataset_version_has_subject d0_ LEFT JOIN subject s1_ ON d0_.subject_id = s1_.id WHERE d0_.id = ?

Parameters:

[
  36
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(DISTINCT d0_.id) AS sclr_0
FROM
  dataset_version_has_subject d0_
  LEFT JOIN subject s1_ ON d0_.subject_id = s1_.id
WHERE
  d0_.id = ?

SELECT COUNT(DISTINCT d0_.id) AS sclr_0 FROM dataset_version_has_subject d0_ LEFT JOIN subject s1_ ON d0_.subject_id = s1_.id WHERE d0_.id = 36;

#	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 725)
6	Doctrine\ORM\AbstractQuery->getScalarResult (line 96)
7	Doctrine\ORM\Tools\Pagination\Paginator->count (line 45)
8	ApiPlatform\Doctrine\Orm\Paginator->getTotalItems (line 37)
9	ApiPlatform\Doctrine\Orm\Paginator->getLastPage (line 22)
10	App\Listener\PaginationHeadersListener->addHeaders (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 214)
15	Symfony\Component\HttpKernel\HttpKernel->filterResponse (line 202)
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)

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\DatasetVersionSubject	No errors.
App\Entity\Subject	No errors.
App\Entity\DatasetVersion	No errors.
App\Entity\Dataset	No errors.
App\Entity\Learning	No errors.
App\Entity\Question	No errors.

Symfony Profiler

GET https://api.simulatorestrategico.com/dataset-version/36/question-schema

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping