Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

15.38 ms Query time

0 Invalid entities

49 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

11.62 ms
(75.55%)

SELECT h0_.id AS id_0, h0_.status AS status_1, h0_.sum_collected AS sum_collected_2, h0_.sum_transmitted AS sum_transmitted_3, h0_.active AS active_4, h0_.active_home_page AS active_home_page_5, h0_.title AS title_6, h0_.slug AS slug_7, h0_.target AS target_8, h0_.start_at AS start_at_9, h0_.description AS description_10, h0_.description_short AS description_short_11, h0_.description_short_payment AS description_short_payment_12, h0_.result_description AS result_description_13, h0_.video AS video_14, h0_.sort_order AS sort_order_15, h0_.ekzeget_view_count AS ekzeget_view_count_16, h0_.meta_title AS meta_title_17, h0_.meta_description AS meta_description_18, h0_.meta_keywords AS meta_keywords_19, m1_.id AS id_20, m1_.title AS title_21, m1_.private AS private_22, m1_.sort AS sort_23, m1_.file_path AS file_path_24, m2_.id AS id_25, m2_.title AS title_26, m2_.private AS private_27, m2_.sort AS sort_28, m2_.file_path AS file_path_29, m3_.id AS id_30, m3_.title AS title_31, m3_.private AS private_32, m3_.sort AS sort_33, m3_.file_path AS file_path_34, m4_.id AS id_35, m4_.title AS title_36, m4_.private AS private_37, m4_.sort AS sort_38, m4_.file_path AS file_path_39, h0_.image_id AS image_id_40 FROM help_program h0_ LEFT JOIN media m1_ ON h0_.image_id = m1_.id LEFT JOIN help_program_images h5_ ON h0_.id = h5_.help_program_id LEFT JOIN media m2_ ON m2_.id = h5_.image_id LEFT JOIN help_program_files h6_ ON h0_.id = h6_.help_program_id LEFT JOIN media m3_ ON m3_.id = h6_.file_id LEFT JOIN help_program_report_images h7_ ON h0_.id = h7_.help_program_id LEFT JOIN media m4_ ON m4_.id = h7_.image_id WHERE h0_.active = ? AND h0_.id IN (?, ?, ?, ?, ?, ?) ORDER BY h0_.id ASC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  h0_.id AS id_0,
  h0_.status AS status_1,
  h0_.sum_collected AS sum_collected_2,
  h0_.sum_transmitted AS sum_transmitted_3,
  h0_.active AS active_4,
  h0_.active_home_page AS active_home_page_5,
  h0_.title AS title_6,
  h0_.slug AS slug_7,
  h0_.target AS target_8,
  h0_.start_at AS start_at_9,
  h0_.description AS description_10,
  h0_.description_short AS description_short_11,
  h0_.description_short_payment AS description_short_payment_12,
  h0_.result_description AS result_description_13,
  h0_.video AS video_14,
  h0_.sort_order AS sort_order_15,
  h0_.ekzeget_view_count AS ekzeget_view_count_16,
  h0_.meta_title AS meta_title_17,
  h0_.meta_description AS meta_description_18,
  h0_.meta_keywords AS meta_keywords_19,
  m1_.id AS id_20,
  m1_.title AS title_21,
  m1_.private AS private_22,
  m1_.sort AS sort_23,
  m1_.file_path AS file_path_24,
  m2_.id AS id_25,
  m2_.title AS title_26,
  m2_.private AS private_27,
  m2_.sort AS sort_28,
  m2_.file_path AS file_path_29,
  m3_.id AS id_30,
  m3_.title AS title_31,
  m3_.private AS private_32,
  m3_.sort AS sort_33,
  m3_.file_path AS file_path_34,
  m4_.id AS id_35,
  m4_.title AS title_36,
  m4_.private AS private_37,
  m4_.sort AS sort_38,
  m4_.file_path AS file_path_39,
  h0_.image_id AS image_id_40
FROM
  help_program h0_
  LEFT JOIN media m1_ ON h0_.image_id = m1_.id
  LEFT JOIN help_program_images h5_ ON h0_.id = h5_.help_program_id
  LEFT JOIN media m2_ ON m2_.id = h5_.image_id
  LEFT JOIN help_program_files h6_ ON h0_.id = h6_.help_program_id
  LEFT JOIN media m3_ ON m3_.id = h6_.file_id
  LEFT JOIN help_program_report_images h7_ ON h0_.id = h7_.help_program_id
  LEFT JOIN media m4_ ON m4_.id = h7_.image_id
WHERE
  h0_.active = ?
  AND h0_.id IN (?, ?, ?, ?, ?, ?)
ORDER BY
  h0_.id ASC

SELECT h0_.id AS id_0, h0_.status AS status_1, h0_.sum_collected AS sum_collected_2, h0_.sum_transmitted AS sum_transmitted_3, h0_.active AS active_4, h0_.active_home_page AS active_home_page_5, h0_.title AS title_6, h0_.slug AS slug_7, h0_.target AS target_8, h0_.start_at AS start_at_9, h0_.description AS description_10, h0_.description_short AS description_short_11, h0_.description_short_payment AS description_short_payment_12, h0_.result_description AS result_description_13, h0_.video AS video_14, h0_.sort_order AS sort_order_15, h0_.ekzeget_view_count AS ekzeget_view_count_16, h0_.meta_title AS meta_title_17, h0_.meta_description AS meta_description_18, h0_.meta_keywords AS meta_keywords_19, m1_.id AS id_20, m1_.title AS title_21, m1_.private AS private_22, m1_.sort AS sort_23, m1_.file_path AS file_path_24, m2_.id AS id_25, m2_.title AS title_26, m2_.private AS private_27, m2_.sort AS sort_28, m2_.file_path AS file_path_29, m3_.id AS id_30, m3_.title AS title_31, m3_.private AS private_32, m3_.sort AS sort_33, m3_.file_path AS file_path_34, m4_.id AS id_35, m4_.title AS title_36, m4_.private AS private_37, m4_.sort AS sort_38, m4_.file_path AS file_path_39, h0_.image_id AS image_id_40 FROM help_program h0_ LEFT JOIN media m1_ ON h0_.image_id = m1_.id LEFT JOIN help_program_images h5_ ON h0_.id = h5_.help_program_id LEFT JOIN media m2_ ON m2_.id = h5_.image_id LEFT JOIN help_program_files h6_ ON h0_.id = h6_.help_program_id LEFT JOIN media m3_ ON m3_.id = h6_.file_id LEFT JOIN help_program_report_images h7_ ON h0_.id = h7_.help_program_id LEFT JOIN media m4_ ON m4_.id = h7_.image_id WHERE h0_.active = 1 AND h0_.id IN (24, 26, 27, 28, 31, 32) ORDER BY h0_.id ASC;

#	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)

2.51 ms
(16.31%)

SELECT count(DISTINCT h0_.id) AS sclr_0 FROM help_program h0_ LEFT JOIN media m1_ ON h0_.image_id = m1_.id LEFT JOIN help_program_images h3_ ON h0_.id = h3_.help_program_id LEFT JOIN media m2_ ON m2_.id = h3_.image_id LEFT JOIN help_program_files h5_ ON h0_.id = h5_.help_program_id LEFT JOIN media m4_ ON m4_.id = h5_.file_id LEFT JOIN help_program_report_images h7_ ON h0_.id = h7_.help_program_id LEFT JOIN media m6_ ON m6_.id = h7_.image_id WHERE h0_.active = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  count(DISTINCT h0_.id) AS sclr_0
FROM
  help_program h0_
  LEFT JOIN media m1_ ON h0_.image_id = m1_.id
  LEFT JOIN help_program_images h3_ ON h0_.id = h3_.help_program_id
  LEFT JOIN media m2_ ON m2_.id = h3_.image_id
  LEFT JOIN help_program_files h5_ ON h0_.id = h5_.help_program_id
  LEFT JOIN media m4_ ON m4_.id = h5_.file_id
  LEFT JOIN help_program_report_images h7_ ON h0_.id = h7_.help_program_id
  LEFT JOIN media m6_ ON m6_.id = h7_.image_id
WHERE
  h0_.active = ?

SELECT count(DISTINCT h0_.id) AS sclr_0 FROM help_program h0_ LEFT JOIN media m1_ ON h0_.image_id = m1_.id LEFT JOIN help_program_images h3_ ON h0_.id = h3_.help_program_id LEFT JOIN media m2_ ON m2_.id = h3_.image_id LEFT JOIN help_program_files h5_ ON h0_.id = h5_.help_program_id LEFT JOIN media m4_ ON m4_.id = h5_.file_id LEFT JOIN help_program_report_images h7_ ON h0_.id = h7_.help_program_id LEFT JOIN media m6_ ON m6_.id = h7_.image_id WHERE h0_.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)

1.25 ms
(8.14%)

SELECT DISTINCT h0_.id AS id_0, h0_.id AS id_1 FROM help_program h0_ LEFT JOIN media m1_ ON h0_.image_id = m1_.id LEFT JOIN help_program_images h3_ ON h0_.id = h3_.help_program_id LEFT JOIN media m2_ ON m2_.id = h3_.image_id LEFT JOIN help_program_files h5_ ON h0_.id = h5_.help_program_id LEFT JOIN media m4_ ON m4_.id = h5_.file_id LEFT JOIN help_program_report_images h7_ ON h0_.id = h7_.help_program_id LEFT JOIN media m6_ ON m6_.id = h7_.image_id WHERE h0_.active = ? ORDER BY h0_.id ASC LIMIT 10000

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT h0_.id AS id_0,
  h0_.id AS id_1
FROM
  help_program h0_
  LEFT JOIN media m1_ ON h0_.image_id = m1_.id
  LEFT JOIN help_program_images h3_ ON h0_.id = h3_.help_program_id
  LEFT JOIN media m2_ ON m2_.id = h3_.image_id
  LEFT JOIN help_program_files h5_ ON h0_.id = h5_.help_program_id
  LEFT JOIN media m4_ ON m4_.id = h5_.file_id
  LEFT JOIN help_program_report_images h7_ ON h0_.id = h7_.help_program_id
  LEFT JOIN media m6_ ON m6_.id = h7_.image_id
WHERE
  h0_.active = ?
ORDER BY
  h0_.id ASC
LIMIT
  10000

SELECT DISTINCT h0_.id AS id_0, h0_.id AS id_1 FROM help_program h0_ LEFT JOIN media m1_ ON h0_.image_id = m1_.id LEFT JOIN help_program_images h3_ ON h0_.id = h3_.help_program_id LEFT JOIN media m2_ ON m2_.id = h3_.image_id LEFT JOIN help_program_files h5_ ON h0_.id = h5_.help_program_id LEFT JOIN media m4_ ON m4_.id = h5_.file_id LEFT JOIN help_program_report_images h7_ ON h0_.id = h7_.help_program_id LEFT JOIN media m6_ ON m6_.id = h7_.image_id WHERE h0_.active = 1 ORDER BY h0_.id ASC LIMIT 10000;

#	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)

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\Media	43
App\Entity\HelpProgram	6

Entities Mapping

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

Symfony Profiler

GET https://api.fdd2.dev.nologostudio.ru/api/public/help_program?active=true&itemsPerPage=10000

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping