Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

4.66 ms Query time

0 Invalid entities

19 Managed entities

Queries

Group similar statements

#▲

Time

Info

2.22 ms

SELECT count(DISTINCT n0_.id) AS sclr_0 FROM news n0_ LEFT JOIN media m1_ ON n0_.image_id = m1_.id LEFT JOIN news_images n3_ ON n0_.id = n3_.news_id LEFT JOIN media m2_ ON m2_.id = n3_.image_id WHERE n0_.active = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  count(DISTINCT n0_.id) AS sclr_0
FROM
  news n0_
  LEFT JOIN media m1_ ON n0_.image_id = m1_.id
  LEFT JOIN news_images n3_ ON n0_.id = n3_.news_id
  LEFT JOIN media m2_ ON m2_.id = n3_.image_id
WHERE
  n0_.active = ?

SELECT count(DISTINCT n0_.id) AS sclr_0 FROM news n0_ LEFT JOIN media m1_ ON n0_.image_id = m1_.id LEFT JOIN news_images n3_ ON n0_.id = n3_.news_id LEFT JOIN media m2_ ON m2_.id = n3_.image_id WHERE n0_.active = 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 725)
6	Doctrine\ORM\AbstractQuery->getScalarResult (line 96)
7	Doctrine\ORM\Tools\Pagination\Paginator->count (line 49)
8	ApiPlatform\Doctrine\Orm\Paginator->getTotalItems (line 64)
9	ApiPlatform\Hydra\Serializer\CollectionNormalizer->getPaginationData (line 87)
10	ApiPlatform\Serializer\AbstractCollectionNormalizer->normalize (line 53)
11	ApiPlatform\Hydra\Serializer\PartialCollectionViewNormalizer->normalize (line 76)
12	ApiPlatform\Hydra\Serializer\CollectionFiltersNormalizer->normalize (line 49)
13	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 152)
14	Symfony\Component\Serializer\Serializer->normalize (line 131)
15	Symfony\Component\Serializer\Serializer->serialize (line 43)
16	Symfony\Component\Serializer\Debug\TraceableSerializer->serialize (line 74)
17	ApiPlatform\State\Processor\SerializeProcessor->process (line 65)
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 6)

0.95 ms

SELECT DISTINCT n0_.id AS id_0, n0_.published_at AS published_at_1 FROM news n0_ LEFT JOIN media m1_ ON n0_.image_id = m1_.id LEFT JOIN news_images n3_ ON n0_.id = n3_.news_id LEFT JOIN media m2_ ON m2_.id = n3_.image_id WHERE n0_.active = ? ORDER BY n0_.published_at DESC LIMIT 10

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT n0_.id AS id_0,
  n0_.published_at AS published_at_1
FROM
  news n0_
  LEFT JOIN media m1_ ON n0_.image_id = m1_.id
  LEFT JOIN news_images n3_ ON n0_.id = n3_.news_id
  LEFT JOIN media m2_ ON m2_.id = n3_.image_id
WHERE
  n0_.active = ?
ORDER BY
  n0_.published_at DESC
LIMIT
  10

SELECT DISTINCT n0_.id AS id_0, n0_.published_at AS published_at_1 FROM news n0_ LEFT JOIN media m1_ ON n0_.image_id = m1_.id LEFT JOIN news_images n3_ ON n0_.id = n3_.news_id LEFT JOIN media m2_ ON m2_.id = n3_.image_id WHERE n0_.active = 1 ORDER BY n0_.published_at DESC LIMIT 10;

#	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 127)
7	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 69)
8	ApiPlatform\Doctrine\Orm\AbstractPaginator->getIterator (line 83)
9	ApiPlatform\Hydra\Serializer\CollectionNormalizer->getItemsData (line 94)
10	ApiPlatform\Serializer\AbstractCollectionNormalizer->normalize (line 53)
11	ApiPlatform\Hydra\Serializer\PartialCollectionViewNormalizer->normalize (line 76)
12	ApiPlatform\Hydra\Serializer\CollectionFiltersNormalizer->normalize (line 49)
13	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 152)
14	Symfony\Component\Serializer\Serializer->normalize (line 131)
15	Symfony\Component\Serializer\Serializer->serialize (line 43)
16	Symfony\Component\Serializer\Debug\TraceableSerializer->serialize (line 74)
17	ApiPlatform\State\Processor\SerializeProcessor->process (line 65)
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 6)

1.49 ms

SELECT n0_.id AS id_0, n0_.updated_at AS updated_at_1, n0_.published_at AS published_at_2, n0_.active AS active_3, n0_.advertising AS advertising_4, n0_.title AS title_5, n0_.slug AS slug_6, n0_.description AS description_7, n0_.description_short AS description_short_8, n0_.video AS video_9, n0_.meta_title AS meta_title_10, n0_.meta_description AS meta_description_11, n0_.meta_keywords AS meta_keywords_12, m1_.id AS id_13, m1_.title AS title_14, m1_.private AS private_15, m1_.sort AS sort_16, m1_.file_path AS file_path_17, m2_.id AS id_18, m2_.title AS title_19, m2_.private AS private_20, m2_.sort AS sort_21, m2_.file_path AS file_path_22, n0_.help_program_id AS help_program_id_23, n0_.help_person_id AS help_person_id_24, n0_.image_id AS image_id_25 FROM news n0_ LEFT JOIN media m1_ ON n0_.image_id = m1_.id LEFT JOIN news_images n3_ ON n0_.id = n3_.news_id LEFT JOIN media m2_ ON m2_.id = n3_.image_id WHERE n0_.active = ? AND n0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY n0_.published_at DESC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  n0_.id AS id_0,
  n0_.updated_at AS updated_at_1,
  n0_.published_at AS published_at_2,
  n0_.active AS active_3,
  n0_.advertising AS advertising_4,
  n0_.title AS title_5,
  n0_.slug AS slug_6,
  n0_.description AS description_7,
  n0_.description_short AS description_short_8,
  n0_.video AS video_9,
  n0_.meta_title AS meta_title_10,
  n0_.meta_description AS meta_description_11,
  n0_.meta_keywords AS meta_keywords_12,
  m1_.id AS id_13,
  m1_.title AS title_14,
  m1_.private AS private_15,
  m1_.sort AS sort_16,
  m1_.file_path AS file_path_17,
  m2_.id AS id_18,
  m2_.title AS title_19,
  m2_.private AS private_20,
  m2_.sort AS sort_21,
  m2_.file_path AS file_path_22,
  n0_.help_program_id AS help_program_id_23,
  n0_.help_person_id AS help_person_id_24,
  n0_.image_id AS image_id_25
FROM
  news n0_
  LEFT JOIN media m1_ ON n0_.image_id = m1_.id
  LEFT JOIN news_images n3_ ON n0_.id = n3_.news_id
  LEFT JOIN media m2_ ON m2_.id = n3_.image_id
WHERE
  n0_.active = ?
  AND n0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?)
ORDER BY
  n0_.published_at DESC

SELECT n0_.id AS id_0, n0_.updated_at AS updated_at_1, n0_.published_at AS published_at_2, n0_.active AS active_3, n0_.advertising AS advertising_4, n0_.title AS title_5, n0_.slug AS slug_6, n0_.description AS description_7, n0_.description_short AS description_short_8, n0_.video AS video_9, n0_.meta_title AS meta_title_10, n0_.meta_description AS meta_description_11, n0_.meta_keywords AS meta_keywords_12, m1_.id AS id_13, m1_.title AS title_14, m1_.private AS private_15, m1_.sort AS sort_16, m1_.file_path AS file_path_17, m2_.id AS id_18, m2_.title AS title_19, m2_.private AS private_20, m2_.sort AS sort_21, m2_.file_path AS file_path_22, n0_.help_program_id AS help_program_id_23, n0_.help_person_id AS help_person_id_24, n0_.image_id AS image_id_25 FROM news n0_ LEFT JOIN media m1_ ON n0_.image_id = m1_.id LEFT JOIN news_images n3_ ON n0_.id = n3_.news_id LEFT JOIN media m2_ ON m2_.id = n3_.image_id WHERE n0_.active = 1 AND n0_.id IN (45, 44, 42, 41, 40, 39, 38, 14, 43) ORDER BY n0_.published_at DESC;

#	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 145)
7	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 69)
8	ApiPlatform\Doctrine\Orm\AbstractPaginator->getIterator (line 83)
9	ApiPlatform\Hydra\Serializer\CollectionNormalizer->getItemsData (line 94)
10	ApiPlatform\Serializer\AbstractCollectionNormalizer->normalize (line 53)
11	ApiPlatform\Hydra\Serializer\PartialCollectionViewNormalizer->normalize (line 76)
12	ApiPlatform\Hydra\Serializer\CollectionFiltersNormalizer->normalize (line 49)
13	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 152)
14	Symfony\Component\Serializer\Serializer->normalize (line 131)
15	Symfony\Component\Serializer\Serializer->serialize (line 43)
16	Symfony\Component\Serializer\Debug\TraceableSerializer->serialize (line 74)
17	ApiPlatform\State\Processor\SerializeProcessor->process (line 65)
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 6)

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.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\News	9
App\Entity\Media	7
App\Entity\HelpProgram	2
App\Entity\HelpPerson	1

Entities Mapping

Class	Mapping errors
App\Entity\News	No errors.
App\Entity\Media	No errors.
App\Entity\HelpProgram	No errors.
App\Entity\HelpPerson	No errors.

Symfony Profiler

GET https://api.fdd2.dev.nologostudio.ru/api/public/news?active=true&itemsPerPage=10&order%5BpublishedAt%5D=desc&page=1

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping