Symfony Profiler

Query Metrics

10 Database Queries

5 Different statements

17.17 ms Query time

0 Invalid entities

10 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

5.49 ms
(31.98%)

SELECT n0_.id AS id_0, n0_.title AS title_1, n0_.data AS data_2, n0_.created_at AS created_at_3, n0_.published_at AS published_at_4, n0_.pinned AS pinned_5, n0_.status AS status_6, n0_.source AS source_7, n0_.vk_owner_id AS vk_owner_id_8, n0_.vk_post_id AS vk_post_id_9, n0_.vk_post_url AS vk_post_url_10, n0_.vk_auto_sync_enabled AS vk_auto_sync_enabled_11, n0_.vk_last_synced_at AS vk_last_synced_at_12, n0_.vk_unavailable_at AS vk_unavailable_at_13, CASE WHEN n0_.published_at IS NULL THEN 1 ELSE 0 END AS sclr_14, n0_.image_id AS image_id_15 FROM news n0_ WHERE n0_.pinned = true AND n0_.status = ? ORDER BY sclr_14 ASC, n0_.published_at DESC, n0_.created_at DESC, n0_.id DESC LIMIT 2

Parameters:

[
  "PUBLISHED"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  n0_.id AS id_0,
  n0_.title AS title_1,
  n0_.data AS data_2,
  n0_.created_at AS created_at_3,
  n0_.published_at AS published_at_4,
  n0_.pinned AS pinned_5,
  n0_.status AS status_6,
  n0_.source AS source_7,
  n0_.vk_owner_id AS vk_owner_id_8,
  n0_.vk_post_id AS vk_post_id_9,
  n0_.vk_post_url AS vk_post_url_10,
  n0_.vk_auto_sync_enabled AS vk_auto_sync_enabled_11,
  n0_.vk_last_synced_at AS vk_last_synced_at_12,
  n0_.vk_unavailable_at AS vk_unavailable_at_13,
  CASE WHEN n0_.published_at IS NULL THEN
    1
  ELSE
    0
  END AS sclr_14,
  n0_.image_id AS image_id_15
FROM
  news n0_
WHERE
  n0_.pinned = true
  AND n0_.status = ?
ORDER BY
  sclr_14 ASC,
  n0_.published_at DESC,
  n0_.created_at DESC,
  n0_.id DESC
LIMIT
  2

SELECT n0_.id AS id_0, n0_.title AS title_1, n0_.data AS data_2, n0_.created_at AS created_at_3, n0_.published_at AS published_at_4, n0_.pinned AS pinned_5, n0_.status AS status_6, n0_.source AS source_7, n0_.vk_owner_id AS vk_owner_id_8, n0_.vk_post_id AS vk_post_id_9, n0_.vk_post_url AS vk_post_url_10, n0_.vk_auto_sync_enabled AS vk_auto_sync_enabled_11, n0_.vk_last_synced_at AS vk_last_synced_at_12, n0_.vk_unavailable_at AS vk_unavailable_at_13, CASE WHEN n0_.published_at IS NULL THEN 1 ELSE 0 END AS sclr_14, n0_.image_id AS image_id_15 FROM news n0_ WHERE n0_.pinned = true AND n0_.status = 'PUBLISHED' ORDER BY sclr_14 ASC, n0_.published_at DESC, n0_.created_at DESC, n0_.id DESC LIMIT 2;

#	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 105)
7	App\Shared\UI\Api\State\AbstractCachedPaginatedProvider->fetchPage (line 61)
8	App\Shared\UI\Api\State\AbstractCachedPaginatedProvider->provide (line 43)
9	ApiPlatform\State\CallableProvider->provide (line 79)
10	ApiPlatform\State\Provider\ReadProvider->provide (line 50)
11	ApiPlatform\Symfony\Bundle\SwaggerUi\SwaggerUiProvider->provide (line 62)
12	ApiPlatform\Symfony\Security\State\AccessCheckerProvider->provide (line 50)
13	ApiPlatform\State\Provider\SecurityParameterProvider->provide (line 56)
14	ApiPlatform\State\Provider\DeserializeProvider->provide (line 62)
15	ApiPlatform\Symfony\Security\State\AccessCheckerProvider->provide (line 32)
16	ApiPlatform\Symfony\Validator\State\ValidateProvider->provide (line 62)
17	ApiPlatform\Symfony\Security\State\AccessCheckerProvider->provide (line 102)
18	ApiPlatform\Symfony\Validator\State\ParameterValidatorProvider->provide (line 99)
19	ApiPlatform\State\Provider\ParameterProvider->provide (line 51)
20	ApiPlatform\State\Provider\ContentNegotiationProvider->provide (line 83)
21	ApiPlatform\Symfony\Controller\MainController->__invoke (line 183)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 193)
24	Symfony\Component\HttpKernel\Kernel->handle (line 35)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 32)
26	require_once (line 5)

4.14 ms
(24.13%)

SELECT t0.id AS id_1, t0.url AS url_2, t0.filename AS filename_3, t0.s3_filename AS s3_filename_4, t0.extension AS extension_5, t0.size AS size_6, t0.created_at AS created_at_7 FROM file t0 WHERE t0.id = ?

Parameters:

[
  "c563eeb9-f21c-45d3-b915-30982849ea38"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.url AS url_2,
  t0.filename AS filename_3,
  t0.s3_filename AS s3_filename_4,
  t0.extension AS extension_5,
  t0.size AS size_6,
  t0.created_at AS created_at_7
FROM
  file t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.url AS url_2, t0.filename AS filename_3, t0.s3_filename AS s3_filename_4, t0.extension AS extension_5, t0.size AS size_6, t0.created_at AS created_at_7 FROM file t0 WHERE t0.id = 'c563eeb9-f21c-45d3-b915-30982849ea38';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 746)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 764)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 209)
4	Doctrine\ORM\Proxy\ProxyFactory::{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxy():203} (line 94)
5	App\File\Domain\Model\File->getExtension (line 24)
6	App\File\Application\Factory\CreateFileDto->make (line 38)
7	App\News\UI\Api\Mapper\NewsMapper->map (line 42)
8	App\Shared\Application\Mapper\ResourceMapperFactory->map (line 115)
9	App\Shared\UI\Api\State\AbstractCachedPaginatedProvider->fetchPage (line 61)
10	App\Shared\UI\Api\State\AbstractCachedPaginatedProvider->provide (line 43)
11	ApiPlatform\State\CallableProvider->provide (line 79)
12	ApiPlatform\State\Provider\ReadProvider->provide (line 50)
13	ApiPlatform\Symfony\Bundle\SwaggerUi\SwaggerUiProvider->provide (line 62)
14	ApiPlatform\Symfony\Security\State\AccessCheckerProvider->provide (line 50)
15	ApiPlatform\State\Provider\SecurityParameterProvider->provide (line 56)
16	ApiPlatform\State\Provider\DeserializeProvider->provide (line 62)
17	ApiPlatform\Symfony\Security\State\AccessCheckerProvider->provide (line 32)
18	ApiPlatform\Symfony\Validator\State\ValidateProvider->provide (line 62)
19	ApiPlatform\Symfony\Security\State\AccessCheckerProvider->provide (line 102)
20	ApiPlatform\Symfony\Validator\State\ParameterValidatorProvider->provide (line 99)
21	ApiPlatform\State\Provider\ParameterProvider->provide (line 51)
22	ApiPlatform\State\Provider\ContentNegotiationProvider->provide (line 83)
23	ApiPlatform\Symfony\Controller\MainController->__invoke (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 193)
26	Symfony\Component\HttpKernel\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 32)
28	require_once (line 5)

3.69 ms
(21.47%)

SELECT t0_.id AS id_0, t0_.title AS title_1, t0_.color AS color_2, t0_.url AS url_3, t0_.created_at AS created_at_4 FROM tag t0_ INNER JOIN tag_assignment t1_ ON (t1_.tag_id = t0_.id) WHERE t1_.target_type = ? AND t1_.target_id = ? ORDER BY t0_.title ASC

Parameters:

[
  "news"
  Symfony\Component\Uid\UuidV4 {#1257
    __toString(): "d2ccc8b3-d8d1-4be7-ad56-494890097f7c"
  }
]

View formatted query View runnable query View query backtrace

SELECT
  t0_.id AS id_0,
  t0_.title AS title_1,
  t0_.color AS color_2,
  t0_.url AS url_3,
  t0_.created_at AS created_at_4
FROM
  tag t0_
  INNER JOIN tag_assignment t1_ ON (t1_.tag_id = t0_.id)
WHERE
  t1_.target_type = ?
  AND t1_.target_id = ?
ORDER BY
  t0_.title ASC

SELECT t0_.id AS id_0, t0_.title AS title_1, t0_.color AS color_2, t0_.url AS url_3, t0_.created_at AS created_at_4 FROM tag t0_ INNER JOIN tag_assignment t1_ ON (t1_.tag_id = t0_.id) WHERE t1_.target_type = 'news' AND t1_.target_id = 'd2ccc8b3-d8d1-4be7-ad56-494890097f7c' ORDER BY t0_.title 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 60)
7	App\Tag\Infrastructure\Repository\TagAssignmentRepository->findTagsByTarget (line 22)
8	App\Tag\Application\Query\TagPayloadProvider->getForTarget (line 52)
9	App\News\UI\Api\Mapper\NewsMapper->map (line 42)
10	App\Shared\Application\Mapper\ResourceMapperFactory->map (line 115)
11	App\Shared\UI\Api\State\AbstractCachedPaginatedProvider->fetchPage (line 61)
12	App\Shared\UI\Api\State\AbstractCachedPaginatedProvider->provide (line 43)
13	ApiPlatform\State\CallableProvider->provide (line 79)
14	ApiPlatform\State\Provider\ReadProvider->provide (line 50)
15	ApiPlatform\Symfony\Bundle\SwaggerUi\SwaggerUiProvider->provide (line 62)
16	ApiPlatform\Symfony\Security\State\AccessCheckerProvider->provide (line 50)
17	ApiPlatform\State\Provider\SecurityParameterProvider->provide (line 56)
18	ApiPlatform\State\Provider\DeserializeProvider->provide (line 62)
19	ApiPlatform\Symfony\Security\State\AccessCheckerProvider->provide (line 32)
20	ApiPlatform\Symfony\Validator\State\ValidateProvider->provide (line 62)
21	ApiPlatform\Symfony\Security\State\AccessCheckerProvider->provide (line 102)
22	ApiPlatform\Symfony\Validator\State\ParameterValidatorProvider->provide (line 99)
23	ApiPlatform\State\Provider\ParameterProvider->provide (line 51)
24	ApiPlatform\State\Provider\ContentNegotiationProvider->provide (line 83)
25	ApiPlatform\Symfony\Controller\MainController->__invoke (line 183)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 193)
28	Symfony\Component\HttpKernel\Kernel->handle (line 35)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 32)
30	require_once (line 5)

2.39 ms
(13.94%)

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.news_id AS news_id_3, t0.file_id AS file_id_4 FROM news_slider_photo t0 WHERE t0.news_id = ? ORDER BY t0.created_at ASC

Parameters:

[
  "d2ccc8b3-d8d1-4be7-ad56-494890097f7c"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.news_id AS news_id_3,
  t0.file_id AS file_id_4
FROM
  news_slider_photo t0
WHERE
  t0.news_id = ?
ORDER BY
  t0.created_at ASC

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.news_id AS news_id_3, t0.file_id AS file_id_4 FROM news_slider_photo t0 WHERE t0.news_id = 'd2ccc8b3-d8d1-4be7-ad56-494890097f7c' ORDER BY t0.created_at ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1858)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1803)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2720)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 315)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 46)
8	App\News\UI\Api\Mapper\NewsMapper->map (line 42)
9	App\Shared\Application\Mapper\ResourceMapperFactory->map (line 115)
10	App\Shared\UI\Api\State\AbstractCachedPaginatedProvider->fetchPage (line 61)
11	App\Shared\UI\Api\State\AbstractCachedPaginatedProvider->provide (line 43)
12	ApiPlatform\State\CallableProvider->provide (line 79)
13	ApiPlatform\State\Provider\ReadProvider->provide (line 50)
14	ApiPlatform\Symfony\Bundle\SwaggerUi\SwaggerUiProvider->provide (line 62)
15	ApiPlatform\Symfony\Security\State\AccessCheckerProvider->provide (line 50)
16	ApiPlatform\State\Provider\SecurityParameterProvider->provide (line 56)
17	ApiPlatform\State\Provider\DeserializeProvider->provide (line 62)
18	ApiPlatform\Symfony\Security\State\AccessCheckerProvider->provide (line 32)
19	ApiPlatform\Symfony\Validator\State\ValidateProvider->provide (line 62)
20	ApiPlatform\Symfony\Security\State\AccessCheckerProvider->provide (line 102)
21	ApiPlatform\Symfony\Validator\State\ParameterValidatorProvider->provide (line 99)
22	ApiPlatform\State\Provider\ParameterProvider->provide (line 51)
23	ApiPlatform\State\Provider\ContentNegotiationProvider->provide (line 83)
24	ApiPlatform\Symfony\Controller\MainController->__invoke (line 183)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 193)
27	Symfony\Component\HttpKernel\Kernel->handle (line 35)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 32)
29	require_once (line 5)

1.46 ms
(8.49%)

SELECT COUNT(DISTINCT n0_.id) AS sclr_0 FROM news n0_ WHERE n0_.pinned = true AND n0_.status = ?

Parameters:

[
  "PUBLISHED"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(DISTINCT n0_.id) AS sclr_0
FROM
  news n0_
WHERE
  n0_.pinned = true
  AND n0_.status = ?

SELECT COUNT(DISTINCT n0_.id) AS sclr_0 FROM news n0_ WHERE n0_.pinned = true AND n0_.status = 'PUBLISHED';

#	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 111)
8	App\Shared\UI\Api\State\AbstractCachedPaginatedProvider->fetchPage (line 61)
9	App\Shared\UI\Api\State\AbstractCachedPaginatedProvider->provide (line 43)
10	ApiPlatform\State\CallableProvider->provide (line 79)
11	ApiPlatform\State\Provider\ReadProvider->provide (line 50)
12	ApiPlatform\Symfony\Bundle\SwaggerUi\SwaggerUiProvider->provide (line 62)
13	ApiPlatform\Symfony\Security\State\AccessCheckerProvider->provide (line 50)
14	ApiPlatform\State\Provider\SecurityParameterProvider->provide (line 56)
15	ApiPlatform\State\Provider\DeserializeProvider->provide (line 62)
16	ApiPlatform\Symfony\Security\State\AccessCheckerProvider->provide (line 32)
17	ApiPlatform\Symfony\Validator\State\ValidateProvider->provide (line 62)
18	ApiPlatform\Symfony\Security\State\AccessCheckerProvider->provide (line 102)
19	ApiPlatform\Symfony\Validator\State\ParameterValidatorProvider->provide (line 99)
20	ApiPlatform\State\Provider\ParameterProvider->provide (line 51)
21	ApiPlatform\State\Provider\ContentNegotiationProvider->provide (line 83)
22	ApiPlatform\Symfony\Controller\MainController->__invoke (line 183)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 193)
25	Symfony\Component\HttpKernel\Kernel->handle (line 35)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 32)
27	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.

Managed Entities

default entity manager

Class	Amount of managed objects
App\File\Domain\Model\File	4
App\News\Domain\Model\News	2
App\News\Domain\Model\NewsSliderPhoto	2
App\Tag\Domain\Model\Tag	2

Entities Mapping

Class	Mapping errors
App\News\Domain\Model\News	No errors.
App\File\Domain\Model\File	No errors.
App\News\Domain\Model\NewsSliderPhoto	No errors.
App\Tag\Domain\Model\TagAssignment	No errors.
App\Tag\Domain\Model\Tag	No errors.

Symfony Profiler

GET https://api-theatre.rassamahin.ru/api/pinned-news?itemsPerPage=2&page=1

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping