Symfony Profiler

Query Metrics

9 Database Queries

3 Different statements

7.34 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

6.09 ms
(82.88%)

SELECT COUNT(DISTINCT t0_.id) AS sclr_0 FROM teacher t0_ INNER JOIN teaching_language t1_ ON t0_.id = t1_.teacher_id WHERE t1_.language_id = ? AND t0_.is_active = ? AND t0_.is_verified = ?

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(DISTINCT t0_.id) AS sclr_0
FROM
  teacher t0_
  INNER JOIN teaching_language t1_ ON t0_.id = t1_.teacher_id
WHERE
  t1_.language_id = ?
  AND t0_.is_active = ?
  AND t0_.is_verified = ?

SELECT COUNT(DISTINCT t0_.id) AS sclr_0 FROM teacher t0_ INNER JOIN teaching_language t1_ ON t0_.id = t1_.teacher_id WHERE t1_.language_id = 1 AND t0_.is_active = 1 AND t0_.is_verified = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
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 103)
8	App\Repository\TeacherRepository->countTeachersByTeachingLanguage (line 28)
9	App\Serializer\Normalizer\LanguageNormalizer->normalize (line 49)
10	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 150)
11	Symfony\Component\Serializer\Serializer->normalize (line 94)
12	ApiPlatform\Hydra\Serializer\CollectionNormalizer->getItemsData (line 109)
13	ApiPlatform\Serializer\AbstractCollectionNormalizer->normalize (line 56)
14	ApiPlatform\Hydra\Serializer\PartialCollectionViewNormalizer->normalize (line 95)
15	ApiPlatform\Hydra\Serializer\CollectionFiltersNormalizer->normalize (line 49)
16	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 150)
17	Symfony\Component\Serializer\Serializer->normalize (line 129)
18	Symfony\Component\Serializer\Serializer->serialize (line 43)
19	Symfony\Component\Serializer\Debug\TraceableSerializer->serialize (line 79)
20	ApiPlatform\State\Processor\SerializeProcessor->process (line 102)
21	ApiPlatform\Symfony\EventListener\SerializeListener->onKernelView (line 115)
22	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
23	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
24	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
25	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 188)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
28	Symfony\Component\HttpKernel\Kernel->handle (line 35)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
30	require_once (line 10)

0.79 ms
(10.74%)

SELECT count(*) AS sclr_0 FROM language l0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  count(*) AS sclr_0
FROM
  language l0_

SELECT count(*) AS sclr_0 FROM language l0_;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
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 49)
8	ApiPlatform\Doctrine\Orm\Paginator->getTotalItems (line 71)
9	ApiPlatform\Hydra\Serializer\CollectionNormalizer->getPaginationData (line 102)
10	ApiPlatform\Serializer\AbstractCollectionNormalizer->normalize (line 56)
11	ApiPlatform\Hydra\Serializer\PartialCollectionViewNormalizer->normalize (line 95)
12	ApiPlatform\Hydra\Serializer\CollectionFiltersNormalizer->normalize (line 49)
13	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 150)
14	Symfony\Component\Serializer\Serializer->normalize (line 129)
15	Symfony\Component\Serializer\Serializer->serialize (line 43)
16	Symfony\Component\Serializer\Debug\TraceableSerializer->serialize (line 79)
17	ApiPlatform\State\Processor\SerializeProcessor->process (line 102)
18	ApiPlatform\Symfony\EventListener\SerializeListener->onKernelView (line 115)
19	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
20	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
21	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
22	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 188)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
25	Symfony\Component\HttpKernel\Kernel->handle (line 35)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
27	require_once (line 10)

0.47 ms
(6.37%)

SELECT l0_.id AS id_0, l0_.name AS name_1, l0_.flag AS flag_2, l0_.locale AS locale_3, l0_.is_active AS is_active_4, l0_.is_public AS is_public_5, l0_.teachers AS teachers_6 FROM language l0_ ORDER BY l0_.id ASC LIMIT 30

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  l0_.id AS id_0,
  l0_.name AS name_1,
  l0_.flag AS flag_2,
  l0_.locale AS locale_3,
  l0_.is_active AS is_active_4,
  l0_.is_public AS is_public_5,
  l0_.teachers AS teachers_6
FROM
  language l0_
ORDER BY
  l0_.id ASC
LIMIT
  30

SELECT l0_.id AS id_0, l0_.name AS name_1, l0_.flag AS flag_2, l0_.locale AS locale_3, l0_.is_active AS is_active_4, l0_.is_public AS is_public_5, l0_.teachers AS teachers_6 FROM language l0_ ORDER BY l0_.id ASC LIMIT 30;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
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 90)
9	ApiPlatform\Hydra\Serializer\CollectionNormalizer->getItemsData (line 109)
10	ApiPlatform\Serializer\AbstractCollectionNormalizer->normalize (line 56)
11	ApiPlatform\Hydra\Serializer\PartialCollectionViewNormalizer->normalize (line 95)
12	ApiPlatform\Hydra\Serializer\CollectionFiltersNormalizer->normalize (line 49)
13	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 150)
14	Symfony\Component\Serializer\Serializer->normalize (line 129)
15	Symfony\Component\Serializer\Serializer->serialize (line 43)
16	Symfony\Component\Serializer\Debug\TraceableSerializer->serialize (line 79)
17	ApiPlatform\State\Processor\SerializeProcessor->process (line 102)
18	ApiPlatform\Symfony\EventListener\SerializeListener->onKernelView (line 115)
19	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
20	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
21	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
22	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 188)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
25	Symfony\Component\HttpKernel\Kernel->handle (line 35)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
27	require_once (line 10)

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\Language	No errors.
App\Entity\Course	No errors.
App\Entity\Teacher	No errors.
App\Entity\TeachingLanguage	No errors.

Symfony Profiler

GET https://api.idioma.international/api/languages

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping