Symfony Profiler

Query Metrics

64 Database Queries

12 Different statements

36.71 ms Query time

1 Invalid entities

99 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

8.11 ms
(22.09%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.private AS private_3, t0.sort AS sort_4, t0.file_path AS file_path_5 FROM media t0 INNER JOIN transaction_files ON t0.id = transaction_files.file_id WHERE transaction_files.transaction_id = ?

Parameters:

[
  1523
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.private AS private_3,
  t0.sort AS sort_4,
  t0.file_path AS file_path_5
FROM
  media t0
  INNER JOIN transaction_files ON t0.id = transaction_files.file_id
WHERE
  transaction_files.transaction_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.private AS private_3, t0.sort AS sort_4, t0.file_path AS file_path_5 FROM media t0 INNER JOIN transaction_files ON t0.id = transaction_files.file_id WHERE transaction_files.transaction_id = 1523;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1081)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1010)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 2713)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 797)
8	ApiPlatform\Serializer\AbstractItemNormalizer->normalizeCollectionOfRelations (line 695)
9	ApiPlatform\Serializer\AbstractItemNormalizer->getAttributeValue (line 197)
10	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->normalize (line 154)
11	ApiPlatform\Serializer\AbstractItemNormalizer->normalize (line 134)
12	ApiPlatform\JsonLd\Serializer\ItemNormalizer->normalize (line 49)
13	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 152)
14	Symfony\Component\Serializer\Serializer->normalize (line 87)
15	ApiPlatform\Hydra\Serializer\CollectionNormalizer->getItemsData (line 94)
16	ApiPlatform\Serializer\AbstractCollectionNormalizer->normalize (line 53)
17	ApiPlatform\Hydra\Serializer\PartialCollectionViewNormalizer->normalize (line 76)
18	ApiPlatform\Hydra\Serializer\CollectionFiltersNormalizer->normalize (line 49)
19	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 152)
20	Symfony\Component\Serializer\Serializer->normalize (line 131)
21	Symfony\Component\Serializer\Serializer->serialize (line 43)
22	Symfony\Component\Serializer\Debug\TraceableSerializer->serialize (line 74)
23	ApiPlatform\State\Processor\SerializeProcessor->process (line 65)
24	ApiPlatform\Symfony\EventListener\SerializeListener->onKernelView (line 115)
25	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
26	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
27	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
28	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 188)
29	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
30	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
31	Symfony\Component\HttpKernel\Kernel->handle (line 35)
32	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
33	require_once (line 6)

7.20 ms
(19.62%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.private AS private_3, t0.sort AS sort_4, t0.file_path AS file_path_5 FROM media t0 INNER JOIN help_program_images ON t0.id = help_program_images.image_id WHERE help_program_images.help_program_id = ?

Parameters:

[
  31
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.private AS private_3,
  t0.sort AS sort_4,
  t0.file_path AS file_path_5
FROM
  media t0
  INNER JOIN help_program_images ON t0.id = help_program_images.image_id
WHERE
  help_program_images.help_program_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.private AS private_3, t0.sort AS sort_4, t0.file_path AS file_path_5 FROM media t0 INNER JOIN help_program_images ON t0.id = help_program_images.image_id WHERE help_program_images.help_program_id = 31;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1081)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1010)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 2713)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 797)
8	ApiPlatform\Serializer\AbstractItemNormalizer->normalizeCollectionOfRelations (line 695)
9	ApiPlatform\Serializer\AbstractItemNormalizer->getAttributeValue (line 197)
10	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->normalize (line 154)
11	ApiPlatform\Serializer\AbstractItemNormalizer->normalize (line 134)
12	ApiPlatform\JsonLd\Serializer\ItemNormalizer->normalize (line 49)
13	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 152)
14	Symfony\Component\Serializer\Serializer->normalize (line 829)
15	ApiPlatform\Serializer\AbstractItemNormalizer->normalizeRelation (line 729)
16	ApiPlatform\Serializer\AbstractItemNormalizer->getAttributeValue (line 197)
17	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->normalize (line 154)
18	ApiPlatform\Serializer\AbstractItemNormalizer->normalize (line 134)
19	ApiPlatform\JsonLd\Serializer\ItemNormalizer->normalize (line 49)
20	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 152)
21	Symfony\Component\Serializer\Serializer->normalize (line 829)
22	ApiPlatform\Serializer\AbstractItemNormalizer->normalizeRelation (line 729)
23	ApiPlatform\Serializer\AbstractItemNormalizer->getAttributeValue (line 197)
24	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->normalize (line 154)
25	ApiPlatform\Serializer\AbstractItemNormalizer->normalize (line 134)
26	ApiPlatform\JsonLd\Serializer\ItemNormalizer->normalize (line 49)
27	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 152)
28	Symfony\Component\Serializer\Serializer->normalize (line 87)
29	ApiPlatform\Hydra\Serializer\CollectionNormalizer->getItemsData (line 94)
30	ApiPlatform\Serializer\AbstractCollectionNormalizer->normalize (line 53)
31	ApiPlatform\Hydra\Serializer\PartialCollectionViewNormalizer->normalize (line 76)
32	ApiPlatform\Hydra\Serializer\CollectionFiltersNormalizer->normalize (line 49)
33	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 152)
34	Symfony\Component\Serializer\Serializer->normalize (line 131)
35	Symfony\Component\Serializer\Serializer->serialize (line 43)
36	Symfony\Component\Serializer\Debug\TraceableSerializer->serialize (line 74)
37	ApiPlatform\State\Processor\SerializeProcessor->process (line 65)
38	ApiPlatform\Symfony\EventListener\SerializeListener->onKernelView (line 115)
39	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
40	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
41	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
42	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 188)
43	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
44	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
45	Symfony\Component\HttpKernel\Kernel->handle (line 35)
46	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
47	require_once (line 6)

5.39 ms
(14.68%)

SELECT t0.id AS id_1, t0.sum AS sum_2, t0.transaction_id AS transaction_id_3, t0.help_person_id AS help_person_id_4 FROM sub_transaction t0 WHERE t0.transaction_id = ?

Parameters:

[
  1523
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.sum AS sum_2,
  t0.transaction_id AS transaction_id_3,
  t0.help_person_id AS help_person_id_4
FROM
  sub_transaction t0
WHERE
  t0.transaction_id = ?

SELECT t0.id AS id_1, t0.sum AS sum_2, t0.transaction_id AS transaction_id_3, t0.help_person_id AS help_person_id_4 FROM sub_transaction t0 WHERE t0.transaction_id = 1523;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1848)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1793)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2709)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 109)
8	ApiPlatform\Serializer\AbstractCollectionNormalizer->normalizeRawCollection (line 81)
9	ApiPlatform\Serializer\AbstractCollectionNormalizer->normalize (line 53)
10	ApiPlatform\Hydra\Serializer\PartialCollectionViewNormalizer->normalize (line 76)
11	ApiPlatform\Hydra\Serializer\CollectionFiltersNormalizer->normalize (line 49)
12	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 152)
13	Symfony\Component\Serializer\Serializer->normalize (line 757)
14	ApiPlatform\Serializer\AbstractItemNormalizer->getAttributeValue (line 197)
15	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->normalize (line 154)
16	ApiPlatform\Serializer\AbstractItemNormalizer->normalize (line 134)
17	ApiPlatform\JsonLd\Serializer\ItemNormalizer->normalize (line 49)
18	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 152)
19	Symfony\Component\Serializer\Serializer->normalize (line 87)
20	ApiPlatform\Hydra\Serializer\CollectionNormalizer->getItemsData (line 94)
21	ApiPlatform\Serializer\AbstractCollectionNormalizer->normalize (line 53)
22	ApiPlatform\Hydra\Serializer\PartialCollectionViewNormalizer->normalize (line 76)
23	ApiPlatform\Hydra\Serializer\CollectionFiltersNormalizer->normalize (line 49)
24	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 152)
25	Symfony\Component\Serializer\Serializer->normalize (line 131)
26	Symfony\Component\Serializer\Serializer->serialize (line 43)
27	Symfony\Component\Serializer\Debug\TraceableSerializer->serialize (line 74)
28	ApiPlatform\State\Processor\SerializeProcessor->process (line 65)
29	ApiPlatform\Symfony\EventListener\SerializeListener->onKernelView (line 115)
30	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
31	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
32	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
33	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 188)
34	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
35	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
36	Symfony\Component\HttpKernel\Kernel->handle (line 35)
37	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
38	require_once (line 6)

2.41 ms
(6.56%)

SELECT t0.id AS id_1, t0.status AS status_2, t0.sum_collected AS sum_collected_3, t0.sum_transmitted AS sum_transmitted_4, t0.active AS active_5, t0.active_home_page AS active_home_page_6, t0.title AS title_7, t0.slug AS slug_8, t0.target AS target_9, t0.start_at AS start_at_10, t0.description AS description_11, t0.description_short AS description_short_12, t0.description_short_payment AS description_short_payment_13, t0.result_description AS result_description_14, t0.video AS video_15, t0.sort_order AS sort_order_16, t0.ekzeget_view_count AS ekzeget_view_count_17, t0.meta_title AS meta_title_18, t0.meta_description AS meta_description_19, t0.meta_keywords AS meta_keywords_20, t0.image_id AS image_id_21 FROM help_program t0 WHERE t0.id = ?

Parameters:

[
  31
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.status AS status_2,
  t0.sum_collected AS sum_collected_3,
  t0.sum_transmitted AS sum_transmitted_4,
  t0.active AS active_5,
  t0.active_home_page AS active_home_page_6,
  t0.title AS title_7,
  t0.slug AS slug_8,
  t0.target AS target_9,
  t0.start_at AS start_at_10,
  t0.description AS description_11,
  t0.description_short AS description_short_12,
  t0.description_short_payment AS description_short_payment_13,
  t0.result_description AS result_description_14,
  t0.video AS video_15,
  t0.sort_order AS sort_order_16,
  t0.ekzeget_view_count AS ekzeget_view_count_17,
  t0.meta_title AS meta_title_18,
  t0.meta_description AS meta_description_19,
  t0.meta_keywords AS meta_keywords_20,
  t0.image_id AS image_id_21
FROM
  help_program t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.status AS status_2, t0.sum_collected AS sum_collected_3, t0.sum_transmitted AS sum_transmitted_4, t0.active AS active_5, t0.active_home_page AS active_home_page_6, t0.title AS title_7, t0.slug AS slug_8, t0.target AS target_9, t0.start_at AS start_at_10, t0.description AS description_11, t0.description_short AS description_short_12, t0.description_short_payment AS description_short_payment_13, t0.result_description AS result_description_14, t0.video AS video_15, t0.sort_order AS sort_order_16, t0.ekzeget_view_count AS ekzeget_view_count_17, t0.meta_title AS meta_title_18, t0.meta_description AS meta_description_19, t0.meta_keywords AS meta_keywords_20, t0.image_id AS image_id_21 FROM help_program t0 WHERE t0.id = 31;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 754)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 220)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 286)
5	Proxies\__CG__\App\Entity\HelpProgram::Doctrine\ORM\Proxy\{closure} (line 59)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 129)
7	Proxies\__CG__\App\Entity\HelpProgram->__get (line 190)
8	App\Entity\HelpProgram->getSlug (line 401)
9	Symfony\Component\PropertyAccess\PropertyAccessor->readProperty (line 102)
10	Symfony\Component\PropertyAccess\PropertyAccessor->getValue (line 99)
11	ApiPlatform\Metadata\IdentifiersExtractor->getIdentifierValue (line 86)
12	ApiPlatform\Metadata\IdentifiersExtractor->getIdentifiersFromOperation (line 56)
13	ApiPlatform\Metadata\IdentifiersExtractor->getIdentifiersFromItem (line 187)
14	ApiPlatform\Symfony\Routing\IriConverter->generateSymfonyRoute (line 168)
15	ApiPlatform\Symfony\Routing\IriConverter->getIriFromResource (line 127)
16	ApiPlatform\JsonLd\Serializer\ItemNormalizer->normalize (line 49)
17	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 152)
18	Symfony\Component\Serializer\Serializer->normalize (line 829)
19	ApiPlatform\Serializer\AbstractItemNormalizer->normalizeRelation (line 729)
20	ApiPlatform\Serializer\AbstractItemNormalizer->getAttributeValue (line 197)
21	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->normalize (line 154)
22	ApiPlatform\Serializer\AbstractItemNormalizer->normalize (line 134)
23	ApiPlatform\JsonLd\Serializer\ItemNormalizer->normalize (line 49)
24	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 152)
25	Symfony\Component\Serializer\Serializer->normalize (line 829)
26	ApiPlatform\Serializer\AbstractItemNormalizer->normalizeRelation (line 729)
27	ApiPlatform\Serializer\AbstractItemNormalizer->getAttributeValue (line 197)
28	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->normalize (line 154)
29	ApiPlatform\Serializer\AbstractItemNormalizer->normalize (line 134)
30	ApiPlatform\JsonLd\Serializer\ItemNormalizer->normalize (line 49)
31	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 152)
32	Symfony\Component\Serializer\Serializer->normalize (line 87)
33	ApiPlatform\Hydra\Serializer\CollectionNormalizer->getItemsData (line 94)
34	ApiPlatform\Serializer\AbstractCollectionNormalizer->normalize (line 53)
35	ApiPlatform\Hydra\Serializer\PartialCollectionViewNormalizer->normalize (line 76)
36	ApiPlatform\Hydra\Serializer\CollectionFiltersNormalizer->normalize (line 49)
37	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 152)
38	Symfony\Component\Serializer\Serializer->normalize (line 131)
39	Symfony\Component\Serializer\Serializer->serialize (line 43)
40	Symfony\Component\Serializer\Debug\TraceableSerializer->serialize (line 74)
41	ApiPlatform\State\Processor\SerializeProcessor->process (line 65)
42	ApiPlatform\Symfony\EventListener\SerializeListener->onKernelView (line 115)
43	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
44	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
45	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
46	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 188)
47	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
48	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
49	Symfony\Component\HttpKernel\Kernel->handle (line 35)
50	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
51	require_once (line 6)

2.38 ms
(6.48%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.private AS private_3, t0.sort AS sort_4, t0.file_path AS file_path_5 FROM media t0 INNER JOIN help_program_files ON t0.id = help_program_files.file_id WHERE help_program_files.help_program_id = ?

Parameters:

[
  31
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.private AS private_3,
  t0.sort AS sort_4,
  t0.file_path AS file_path_5
FROM
  media t0
  INNER JOIN help_program_files ON t0.id = help_program_files.file_id
WHERE
  help_program_files.help_program_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.private AS private_3, t0.sort AS sort_4, t0.file_path AS file_path_5 FROM media t0 INNER JOIN help_program_files ON t0.id = help_program_files.file_id WHERE help_program_files.help_program_id = 31;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1081)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1010)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 2713)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 797)
8	ApiPlatform\Serializer\AbstractItemNormalizer->normalizeCollectionOfRelations (line 695)
9	ApiPlatform\Serializer\AbstractItemNormalizer->getAttributeValue (line 197)
10	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->normalize (line 154)
11	ApiPlatform\Serializer\AbstractItemNormalizer->normalize (line 134)
12	ApiPlatform\JsonLd\Serializer\ItemNormalizer->normalize (line 49)
13	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 152)
14	Symfony\Component\Serializer\Serializer->normalize (line 829)
15	ApiPlatform\Serializer\AbstractItemNormalizer->normalizeRelation (line 729)
16	ApiPlatform\Serializer\AbstractItemNormalizer->getAttributeValue (line 197)
17	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->normalize (line 154)
18	ApiPlatform\Serializer\AbstractItemNormalizer->normalize (line 134)
19	ApiPlatform\JsonLd\Serializer\ItemNormalizer->normalize (line 49)
20	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 152)
21	Symfony\Component\Serializer\Serializer->normalize (line 829)
22	ApiPlatform\Serializer\AbstractItemNormalizer->normalizeRelation (line 729)
23	ApiPlatform\Serializer\AbstractItemNormalizer->getAttributeValue (line 197)
24	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->normalize (line 154)
25	ApiPlatform\Serializer\AbstractItemNormalizer->normalize (line 134)
26	ApiPlatform\JsonLd\Serializer\ItemNormalizer->normalize (line 49)
27	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 152)
28	Symfony\Component\Serializer\Serializer->normalize (line 87)
29	ApiPlatform\Hydra\Serializer\CollectionNormalizer->getItemsData (line 94)
30	ApiPlatform\Serializer\AbstractCollectionNormalizer->normalize (line 53)
31	ApiPlatform\Hydra\Serializer\PartialCollectionViewNormalizer->normalize (line 76)
32	ApiPlatform\Hydra\Serializer\CollectionFiltersNormalizer->normalize (line 49)
33	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 152)
34	Symfony\Component\Serializer\Serializer->normalize (line 131)
35	Symfony\Component\Serializer\Serializer->serialize (line 43)
36	Symfony\Component\Serializer\Debug\TraceableSerializer->serialize (line 74)
37	ApiPlatform\State\Processor\SerializeProcessor->process (line 65)
38	ApiPlatform\Symfony\EventListener\SerializeListener->onKernelView (line 115)
39	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
40	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
41	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
42	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 188)
43	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
44	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
45	Symfony\Component\HttpKernel\Kernel->handle (line 35)
46	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
47	require_once (line 6)

2.14 ms
(5.83%)

SELECT count(*) AS sclr_0 FROM transactions t0_ WHERE t0_.payment_status = ? AND t0_.type IN (?, ?, ?) AND t0_.is_hidden = ?

Parameters:

[
  "succeeded"
  "yoomoney"
  "income"
  "consumption"
  "false"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  count(*) AS sclr_0
FROM
  transactions t0_
WHERE
  t0_.payment_status = ?
  AND t0_.type IN (?, ?, ?)
  AND t0_.is_hidden = ?

SELECT count(*) AS sclr_0 FROM transactions t0_ WHERE t0_.payment_status = 'succeeded' AND t0_.type IN ('yoomoney', 'income', 'consumption') AND t0_.is_hidden = 'false';

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

2.02 ms
(5.51%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.private AS private_3, t0.sort AS sort_4, t0.file_path AS file_path_5 FROM media t0 INNER JOIN help_program_report_images ON t0.id = help_program_report_images.image_id WHERE help_program_report_images.help_program_id = ?

Parameters:

[
  31
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.private AS private_3,
  t0.sort AS sort_4,
  t0.file_path AS file_path_5
FROM
  media t0
  INNER JOIN help_program_report_images ON t0.id = help_program_report_images.image_id
WHERE
  help_program_report_images.help_program_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.private AS private_3, t0.sort AS sort_4, t0.file_path AS file_path_5 FROM media t0 INNER JOIN help_program_report_images ON t0.id = help_program_report_images.image_id WHERE help_program_report_images.help_program_id = 31;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1081)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1010)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 2713)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 797)
8	ApiPlatform\Serializer\AbstractItemNormalizer->normalizeCollectionOfRelations (line 695)
9	ApiPlatform\Serializer\AbstractItemNormalizer->getAttributeValue (line 197)
10	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->normalize (line 154)
11	ApiPlatform\Serializer\AbstractItemNormalizer->normalize (line 134)
12	ApiPlatform\JsonLd\Serializer\ItemNormalizer->normalize (line 49)
13	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 152)
14	Symfony\Component\Serializer\Serializer->normalize (line 829)
15	ApiPlatform\Serializer\AbstractItemNormalizer->normalizeRelation (line 729)
16	ApiPlatform\Serializer\AbstractItemNormalizer->getAttributeValue (line 197)
17	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->normalize (line 154)
18	ApiPlatform\Serializer\AbstractItemNormalizer->normalize (line 134)
19	ApiPlatform\JsonLd\Serializer\ItemNormalizer->normalize (line 49)
20	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 152)
21	Symfony\Component\Serializer\Serializer->normalize (line 829)
22	ApiPlatform\Serializer\AbstractItemNormalizer->normalizeRelation (line 729)
23	ApiPlatform\Serializer\AbstractItemNormalizer->getAttributeValue (line 197)
24	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->normalize (line 154)
25	ApiPlatform\Serializer\AbstractItemNormalizer->normalize (line 134)
26	ApiPlatform\JsonLd\Serializer\ItemNormalizer->normalize (line 49)
27	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 152)
28	Symfony\Component\Serializer\Serializer->normalize (line 87)
29	ApiPlatform\Hydra\Serializer\CollectionNormalizer->getItemsData (line 94)
30	ApiPlatform\Serializer\AbstractCollectionNormalizer->normalize (line 53)
31	ApiPlatform\Hydra\Serializer\PartialCollectionViewNormalizer->normalize (line 76)
32	ApiPlatform\Hydra\Serializer\CollectionFiltersNormalizer->normalize (line 49)
33	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 152)
34	Symfony\Component\Serializer\Serializer->normalize (line 131)
35	Symfony\Component\Serializer\Serializer->serialize (line 43)
36	Symfony\Component\Serializer\Debug\TraceableSerializer->serialize (line 74)
37	ApiPlatform\State\Processor\SerializeProcessor->process (line 65)
38	ApiPlatform\Symfony\EventListener\SerializeListener->onKernelView (line 115)
39	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
40	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
41	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
42	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 188)
43	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
44	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
45	Symfony\Component\HttpKernel\Kernel->handle (line 35)
46	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
47	require_once (line 6)

1.78 ms
(4.84%)

SELECT t0.id AS id_1, t0.sort_order AS sort_order_2, t0.status AS status_3, t0.sum_necessary AS sum_necessary_4, t0.sum_collected AS sum_collected_5, t0.sum_transmitted AS sum_transmitted_6, t0.start_at AS start_at_7, t0.end_at AS end_at_8, t0.active AS active_9, t0.finished AS finished_10, t0.active_photo_block AS active_photo_block_11, t0.active_home_page AS active_home_page_12, t0.title AS title_13, t0.slug AS slug_14, t0.age AS age_15, t0.sub_title AS sub_title_16, t0.person_count AS person_count_17, t0.target AS target_18, t0.description_short AS description_short_19, t0.description_short_payment AS description_short_payment_20, t0.description AS description_21, t0.result_description AS result_description_22, t0.video AS video_23, t0.ekzeget_view_count AS ekzeget_view_count_24, t0.meta_title AS meta_title_25, t0.meta_description AS meta_description_26, t0.meta_keywords AS meta_keywords_27, t0.trustee_id AS trustee_id_28, t0.help_program_id AS help_program_id_29, t0.image_id AS image_id_30 FROM help_person t0 WHERE t0.id = ?

Parameters:

[
  60
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.sort_order AS sort_order_2,
  t0.status AS status_3,
  t0.sum_necessary AS sum_necessary_4,
  t0.sum_collected AS sum_collected_5,
  t0.sum_transmitted AS sum_transmitted_6,
  t0.start_at AS start_at_7,
  t0.end_at AS end_at_8,
  t0.active AS active_9,
  t0.finished AS finished_10,
  t0.active_photo_block AS active_photo_block_11,
  t0.active_home_page AS active_home_page_12,
  t0.title AS title_13,
  t0.slug AS slug_14,
  t0.age AS age_15,
  t0.sub_title AS sub_title_16,
  t0.person_count AS person_count_17,
  t0.target AS target_18,
  t0.description_short AS description_short_19,
  t0.description_short_payment AS description_short_payment_20,
  t0.description AS description_21,
  t0.result_description AS result_description_22,
  t0.video AS video_23,
  t0.ekzeget_view_count AS ekzeget_view_count_24,
  t0.meta_title AS meta_title_25,
  t0.meta_description AS meta_description_26,
  t0.meta_keywords AS meta_keywords_27,
  t0.trustee_id AS trustee_id_28,
  t0.help_program_id AS help_program_id_29,
  t0.image_id AS image_id_30
FROM
  help_person t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.sort_order AS sort_order_2, t0.status AS status_3, t0.sum_necessary AS sum_necessary_4, t0.sum_collected AS sum_collected_5, t0.sum_transmitted AS sum_transmitted_6, t0.start_at AS start_at_7, t0.end_at AS end_at_8, t0.active AS active_9, t0.finished AS finished_10, t0.active_photo_block AS active_photo_block_11, t0.active_home_page AS active_home_page_12, t0.title AS title_13, t0.slug AS slug_14, t0.age AS age_15, t0.sub_title AS sub_title_16, t0.person_count AS person_count_17, t0.target AS target_18, t0.description_short AS description_short_19, t0.description_short_payment AS description_short_payment_20, t0.description AS description_21, t0.result_description AS result_description_22, t0.video AS video_23, t0.ekzeget_view_count AS ekzeget_view_count_24, t0.meta_title AS meta_title_25, t0.meta_description AS meta_description_26, t0.meta_keywords AS meta_keywords_27, t0.trustee_id AS trustee_id_28, t0.help_program_id AS help_program_id_29, t0.image_id AS image_id_30 FROM help_person t0 WHERE t0.id = 60;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 754)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 220)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 286)
5	Proxies\__CG__\App\Entity\HelpPerson::Doctrine\ORM\Proxy\{closure} (line 59)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 129)
7	Proxies\__CG__\App\Entity\HelpPerson->__get (line 338)
8	App\Entity\HelpPerson->getSlug (line 401)
9	Symfony\Component\PropertyAccess\PropertyAccessor->readProperty (line 102)
10	Symfony\Component\PropertyAccess\PropertyAccessor->getValue (line 99)
11	ApiPlatform\Metadata\IdentifiersExtractor->getIdentifierValue (line 86)
12	ApiPlatform\Metadata\IdentifiersExtractor->getIdentifiersFromOperation (line 56)
13	ApiPlatform\Metadata\IdentifiersExtractor->getIdentifiersFromItem (line 187)
14	ApiPlatform\Symfony\Routing\IriConverter->generateSymfonyRoute (line 168)
15	ApiPlatform\Symfony\Routing\IriConverter->getIriFromResource (line 127)
16	ApiPlatform\JsonLd\Serializer\ItemNormalizer->normalize (line 49)
17	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 152)
18	Symfony\Component\Serializer\Serializer->normalize (line 829)
19	ApiPlatform\Serializer\AbstractItemNormalizer->normalizeRelation (line 729)
20	ApiPlatform\Serializer\AbstractItemNormalizer->getAttributeValue (line 197)
21	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->normalize (line 154)
22	ApiPlatform\Serializer\AbstractItemNormalizer->normalize (line 134)
23	ApiPlatform\JsonLd\Serializer\ItemNormalizer->normalize (line 49)
24	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 152)
25	Symfony\Component\Serializer\Serializer->normalize (line 87)
26	ApiPlatform\Hydra\Serializer\CollectionNormalizer->getItemsData (line 94)
27	ApiPlatform\Serializer\AbstractCollectionNormalizer->normalize (line 53)
28	ApiPlatform\Hydra\Serializer\PartialCollectionViewNormalizer->normalize (line 76)
29	ApiPlatform\Hydra\Serializer\CollectionFiltersNormalizer->normalize (line 49)
30	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 152)
31	Symfony\Component\Serializer\Serializer->normalize (line 131)
32	Symfony\Component\Serializer\Serializer->serialize (line 43)
33	Symfony\Component\Serializer\Debug\TraceableSerializer->serialize (line 74)
34	ApiPlatform\State\Processor\SerializeProcessor->process (line 65)
35	ApiPlatform\Symfony\EventListener\SerializeListener->onKernelView (line 115)
36	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
37	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
38	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
39	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 188)
40	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
41	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
42	Symfony\Component\HttpKernel\Kernel->handle (line 35)
43	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
44	require_once (line 6)

1.46 ms
(3.97%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.private AS private_3, t0.sort AS sort_4, t0.file_path AS file_path_5 FROM media t0 INNER JOIN help_person_report_images ON t0.id = help_person_report_images.image_id WHERE help_person_report_images.help_person_id = ?

Parameters:

[
  60
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.private AS private_3,
  t0.sort AS sort_4,
  t0.file_path AS file_path_5
FROM
  media t0
  INNER JOIN help_person_report_images ON t0.id = help_person_report_images.image_id
WHERE
  help_person_report_images.help_person_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.private AS private_3, t0.sort AS sort_4, t0.file_path AS file_path_5 FROM media t0 INNER JOIN help_person_report_images ON t0.id = help_person_report_images.image_id WHERE help_person_report_images.help_person_id = 60;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1081)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1010)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 2713)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 797)
8	ApiPlatform\Serializer\AbstractItemNormalizer->normalizeCollectionOfRelations (line 695)
9	ApiPlatform\Serializer\AbstractItemNormalizer->getAttributeValue (line 197)
10	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->normalize (line 154)
11	ApiPlatform\Serializer\AbstractItemNormalizer->normalize (line 134)
12	ApiPlatform\JsonLd\Serializer\ItemNormalizer->normalize (line 49)
13	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 152)
14	Symfony\Component\Serializer\Serializer->normalize (line 829)
15	ApiPlatform\Serializer\AbstractItemNormalizer->normalizeRelation (line 729)
16	ApiPlatform\Serializer\AbstractItemNormalizer->getAttributeValue (line 197)
17	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->normalize (line 154)
18	ApiPlatform\Serializer\AbstractItemNormalizer->normalize (line 134)
19	ApiPlatform\JsonLd\Serializer\ItemNormalizer->normalize (line 49)
20	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 152)
21	Symfony\Component\Serializer\Serializer->normalize (line 87)
22	ApiPlatform\Hydra\Serializer\CollectionNormalizer->getItemsData (line 94)
23	ApiPlatform\Serializer\AbstractCollectionNormalizer->normalize (line 53)
24	ApiPlatform\Hydra\Serializer\PartialCollectionViewNormalizer->normalize (line 76)
25	ApiPlatform\Hydra\Serializer\CollectionFiltersNormalizer->normalize (line 49)
26	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 152)
27	Symfony\Component\Serializer\Serializer->normalize (line 131)
28	Symfony\Component\Serializer\Serializer->serialize (line 43)
29	Symfony\Component\Serializer\Debug\TraceableSerializer->serialize (line 74)
30	ApiPlatform\State\Processor\SerializeProcessor->process (line 65)
31	ApiPlatform\Symfony\EventListener\SerializeListener->onKernelView (line 115)
32	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
33	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
34	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
35	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 188)
36	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
37	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
38	Symfony\Component\HttpKernel\Kernel->handle (line 35)
39	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
40	require_once (line 6)

1.42 ms
(3.87%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.private AS private_3, t0.sort AS sort_4, t0.file_path AS file_path_5 FROM media t0 INNER JOIN help_person_images ON t0.id = help_person_images.image_id WHERE help_person_images.help_person_id = ?

Parameters:

[
  60
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.private AS private_3,
  t0.sort AS sort_4,
  t0.file_path AS file_path_5
FROM
  media t0
  INNER JOIN help_person_images ON t0.id = help_person_images.image_id
WHERE
  help_person_images.help_person_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.private AS private_3, t0.sort AS sort_4, t0.file_path AS file_path_5 FROM media t0 INNER JOIN help_person_images ON t0.id = help_person_images.image_id WHERE help_person_images.help_person_id = 60;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1081)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1010)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 2713)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 797)
8	ApiPlatform\Serializer\AbstractItemNormalizer->normalizeCollectionOfRelations (line 695)
9	ApiPlatform\Serializer\AbstractItemNormalizer->getAttributeValue (line 197)
10	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->normalize (line 154)
11	ApiPlatform\Serializer\AbstractItemNormalizer->normalize (line 134)
12	ApiPlatform\JsonLd\Serializer\ItemNormalizer->normalize (line 49)
13	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 152)
14	Symfony\Component\Serializer\Serializer->normalize (line 829)
15	ApiPlatform\Serializer\AbstractItemNormalizer->normalizeRelation (line 729)
16	ApiPlatform\Serializer\AbstractItemNormalizer->getAttributeValue (line 197)
17	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->normalize (line 154)
18	ApiPlatform\Serializer\AbstractItemNormalizer->normalize (line 134)
19	ApiPlatform\JsonLd\Serializer\ItemNormalizer->normalize (line 49)
20	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 152)
21	Symfony\Component\Serializer\Serializer->normalize (line 87)
22	ApiPlatform\Hydra\Serializer\CollectionNormalizer->getItemsData (line 94)
23	ApiPlatform\Serializer\AbstractCollectionNormalizer->normalize (line 53)
24	ApiPlatform\Hydra\Serializer\PartialCollectionViewNormalizer->normalize (line 76)
25	ApiPlatform\Hydra\Serializer\CollectionFiltersNormalizer->normalize (line 49)
26	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 152)
27	Symfony\Component\Serializer\Serializer->normalize (line 131)
28	Symfony\Component\Serializer\Serializer->serialize (line 43)
29	Symfony\Component\Serializer\Debug\TraceableSerializer->serialize (line 74)
30	ApiPlatform\State\Processor\SerializeProcessor->process (line 65)
31	ApiPlatform\Symfony\EventListener\SerializeListener->onKernelView (line 115)
32	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
33	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
34	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
35	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 188)
36	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
37	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
38	Symfony\Component\HttpKernel\Kernel->handle (line 35)
39	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
40	require_once (line 6)

1.32 ms
(3.58%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.private AS private_3, t0.sort AS sort_4, t0.file_path AS file_path_5 FROM media t0 INNER JOIN help_person_files ON t0.id = help_person_files.file_id WHERE help_person_files.help_person_id = ?

Parameters:

[
  60
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.private AS private_3,
  t0.sort AS sort_4,
  t0.file_path AS file_path_5
FROM
  media t0
  INNER JOIN help_person_files ON t0.id = help_person_files.file_id
WHERE
  help_person_files.help_person_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.private AS private_3, t0.sort AS sort_4, t0.file_path AS file_path_5 FROM media t0 INNER JOIN help_person_files ON t0.id = help_person_files.file_id WHERE help_person_files.help_person_id = 60;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1081)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1010)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 2713)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 797)
8	ApiPlatform\Serializer\AbstractItemNormalizer->normalizeCollectionOfRelations (line 695)
9	ApiPlatform\Serializer\AbstractItemNormalizer->getAttributeValue (line 197)
10	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->normalize (line 154)
11	ApiPlatform\Serializer\AbstractItemNormalizer->normalize (line 134)
12	ApiPlatform\JsonLd\Serializer\ItemNormalizer->normalize (line 49)
13	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 152)
14	Symfony\Component\Serializer\Serializer->normalize (line 829)
15	ApiPlatform\Serializer\AbstractItemNormalizer->normalizeRelation (line 729)
16	ApiPlatform\Serializer\AbstractItemNormalizer->getAttributeValue (line 197)
17	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->normalize (line 154)
18	ApiPlatform\Serializer\AbstractItemNormalizer->normalize (line 134)
19	ApiPlatform\JsonLd\Serializer\ItemNormalizer->normalize (line 49)
20	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 152)
21	Symfony\Component\Serializer\Serializer->normalize (line 87)
22	ApiPlatform\Hydra\Serializer\CollectionNormalizer->getItemsData (line 94)
23	ApiPlatform\Serializer\AbstractCollectionNormalizer->normalize (line 53)
24	ApiPlatform\Hydra\Serializer\PartialCollectionViewNormalizer->normalize (line 76)
25	ApiPlatform\Hydra\Serializer\CollectionFiltersNormalizer->normalize (line 49)
26	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 152)
27	Symfony\Component\Serializer\Serializer->normalize (line 131)
28	Symfony\Component\Serializer\Serializer->serialize (line 43)
29	Symfony\Component\Serializer\Debug\TraceableSerializer->serialize (line 74)
30	ApiPlatform\State\Processor\SerializeProcessor->process (line 65)
31	ApiPlatform\Symfony\EventListener\SerializeListener->onKernelView (line 115)
32	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
33	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
34	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
35	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 188)
36	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
37	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
38	Symfony\Component\HttpKernel\Kernel->handle (line 35)
39	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
40	require_once (line 6)

1.09 ms
(2.96%)

SELECT t0_.id AS id_0, t0_.for_everyone AS for_everyone_1, t0_.created_at AS created_at_2, t0_.updated_at AS updated_at_3, t0_.payment_method_id AS payment_method_id_4, t0_.source AS source_5, t0_.type AS type_6, t0_.status AS status_7, t0_.period AS period_8, t0_.sum AS sum_9, t0_.from_full_name AS from_full_name_10, t0_.email AS email_11, t0_.comment AS comment_12, t0_.payment_data_json AS payment_data_json_13, t0_.payment_id AS payment_id_14, t0_.payment_status AS payment_status_15, t0_.is_hidden AS is_hidden_16, t0_.is_return AS is_return_17, t0_.hide_from_statistics AS hide_from_statistics_18, t0_.commission_percent AS commission_percent_19, t0_.commission_text AS commission_text_20, t0_.parent_id AS parent_id_21, t0_.from_user_id AS from_user_id_22, t0_.help_person_id AS help_person_id_23, t0_.from_help_person_id AS from_help_person_id_24, t0_.help_program_id AS help_program_id_25, t0_.transaction_every_period_id AS transaction_every_period_id_26 FROM transactions t0_ WHERE t0_.payment_status = ? AND t0_.type IN (?, ?, ?) AND t0_.is_hidden = ? ORDER BY t0_.id DESC LIMIT 15

Parameters:

[
  "succeeded"
  "yoomoney"
  "income"
  "consumption"
  "false"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0_.id AS id_0,
  t0_.for_everyone AS for_everyone_1,
  t0_.created_at AS created_at_2,
  t0_.updated_at AS updated_at_3,
  t0_.payment_method_id AS payment_method_id_4,
  t0_.source AS source_5,
  t0_.type AS type_6,
  t0_.status AS status_7,
  t0_.period AS period_8,
  t0_.sum AS sum_9,
  t0_.from_full_name AS from_full_name_10,
  t0_.email AS email_11,
  t0_.comment AS comment_12,
  t0_.payment_data_json AS payment_data_json_13,
  t0_.payment_id AS payment_id_14,
  t0_.payment_status AS payment_status_15,
  t0_.is_hidden AS is_hidden_16,
  t0_.is_return AS is_return_17,
  t0_.hide_from_statistics AS hide_from_statistics_18,
  t0_.commission_percent AS commission_percent_19,
  t0_.commission_text AS commission_text_20,
  t0_.parent_id AS parent_id_21,
  t0_.from_user_id AS from_user_id_22,
  t0_.help_person_id AS help_person_id_23,
  t0_.from_help_person_id AS from_help_person_id_24,
  t0_.help_program_id AS help_program_id_25,
  t0_.transaction_every_period_id AS transaction_every_period_id_26
FROM
  transactions t0_
WHERE
  t0_.payment_status = ?
  AND t0_.type IN (?, ?, ?)
  AND t0_.is_hidden = ?
ORDER BY
  t0_.id DESC
LIMIT
  15

SELECT t0_.id AS id_0, t0_.for_everyone AS for_everyone_1, t0_.created_at AS created_at_2, t0_.updated_at AS updated_at_3, t0_.payment_method_id AS payment_method_id_4, t0_.source AS source_5, t0_.type AS type_6, t0_.status AS status_7, t0_.period AS period_8, t0_.sum AS sum_9, t0_.from_full_name AS from_full_name_10, t0_.email AS email_11, t0_.comment AS comment_12, t0_.payment_data_json AS payment_data_json_13, t0_.payment_id AS payment_id_14, t0_.payment_status AS payment_status_15, t0_.is_hidden AS is_hidden_16, t0_.is_return AS is_return_17, t0_.hide_from_statistics AS hide_from_statistics_18, t0_.commission_percent AS commission_percent_19, t0_.commission_text AS commission_text_20, t0_.parent_id AS parent_id_21, t0_.from_user_id AS from_user_id_22, t0_.help_person_id AS help_person_id_23, t0_.from_help_person_id AS from_help_person_id_24, t0_.help_program_id AS help_program_id_25, t0_.transaction_every_period_id AS transaction_every_period_id_26 FROM transactions t0_ WHERE t0_.payment_status = 'succeeded' AND t0_.type IN ('yoomoney', 'income', 'consumption') AND t0_.is_hidden = 'false' ORDER BY t0_.id DESC LIMIT 15;

#	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 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	57
App\Entity\Transaction	15
App\Entity\SubTransaction	12
App\Entity\User	5
App\Entity\HelpProgram	5
App\Entity\HelpPerson	3
App\Entity\Trustee	2

Entities Mapping

Class	Mapping errors
App\Entity\Transaction	No errors.
App\Entity\SubTransaction	No errors.
App\Entity\HelpPerson	No errors.
App\Entity\Trustee	No errors.
App\Entity\Media	No errors.
App\Entity\HelpProgram	No errors.
App\Entity\User	The field App\Entity\User#transactions is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Transaction#fromUser does not contain the required 'inversedBy="transactions"' attribute.
App\Entity\TransactionEveryPeriod	No errors.

Symfony Profiler

GET https://api.fdd2.dev.nologostudio.ru/api/public/transaction?isHidden=false&itemsPerPage=15&order%5Bid%5D=desc&paymentStatus=succeeded&type%5B0%5D=yoomoney&type%…

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping