Symfony Profiler

Query Metrics

14 Database Queries

4 Different statements

77.93 ms Query time

0 Invalid entities

12 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

66.74 ms
(85.64%)

SELECT n0_.id AS id_0, n0_.title AS title_1, n0_.data AS data_2, n0_.created_at AS created_at_3, n0_.pinned AS pinned_4, n0_.image_id AS image_id_5 FROM news n0_ ORDER BY n0_.created_at DESC LIMIT 6

Parameters:

[]

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_.pinned AS pinned_4,
  n0_.image_id AS image_id_5
FROM
  news n0_
ORDER BY
  n0_.created_at DESC
LIMIT
  6

SELECT n0_.id AS id_0, n0_.title AS title_1, n0_.data AS data_2, n0_.created_at AS created_at_3, n0_.pinned AS pinned_4, n0_.image_id AS image_id_5 FROM news n0_ ORDER BY n0_.created_at DESC LIMIT 6;

#	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 93)
7	App\Shared\UI\Api\State\AbstractCachedPaginatedProvider->fetchPage (line 67)
8	App\Shared\UI\Api\State\AbstractCachedPaginatedProvider->{closure:App\Shared\UI\Api\State\AbstractCachedPaginatedProvider::provide():64} (line 111)
9	Symfony\Component\Cache\LockRegistry::compute (line 102)
10	Symfony\Component\Cache\Adapter\TagAwareAdapter->{closure:Symfony\Component\Cache\Traits\ContractsTrait::doGet():85} (line 64)
11	Symfony\Component\Cache\Adapter\TagAwareAdapter->contractsGet (line 85)
12	Symfony\Component\Cache\Adapter\TagAwareAdapter->doGet (line 30)
13	Symfony\Component\Cache\Adapter\TagAwareAdapter->get (line 64)
14	App\Shared\UI\Api\State\AbstractCachedPaginatedProvider->provide (line 43)
15	ApiPlatform\State\CallableProvider->provide (line 79)
16	ApiPlatform\State\Provider\ReadProvider->provide (line 50)
17	ApiPlatform\Symfony\Bundle\SwaggerUi\SwaggerUiProvider->provide (line 62)
18	ApiPlatform\Symfony\Security\State\AccessCheckerProvider->provide (line 50)
19	ApiPlatform\State\Provider\SecurityParameterProvider->provide (line 56)
20	ApiPlatform\State\Provider\DeserializeProvider->provide (line 62)
21	ApiPlatform\Symfony\Security\State\AccessCheckerProvider->provide (line 32)
22	ApiPlatform\Symfony\Validator\State\ValidateProvider->provide (line 62)
23	ApiPlatform\Symfony\Security\State\AccessCheckerProvider->provide (line 102)
24	ApiPlatform\Symfony\Validator\State\ParameterValidatorProvider->provide (line 99)
25	ApiPlatform\State\Provider\ParameterProvider->provide (line 51)
26	ApiPlatform\State\Provider\ContentNegotiationProvider->provide (line 83)
27	ApiPlatform\Symfony\Controller\MainController->__invoke (line 183)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
30	Symfony\Component\HttpKernel\Kernel->handle (line 35)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
32	require_once (line 5)

5.97 ms
(7.66%)

SELECT t0_.id AS id_0, t0_.title AS title_1, t0_.color AS color_2, t0_.created_at AS created_at_3 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 {#1165
    __toString(): "7371cf40-c847-4f9a-bea6-1f334229e3ba"
  }
]

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_.created_at AS created_at_3
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_.created_at AS created_at_3 FROM tag t0_ INNER JOIN tag_assignment t1_ ON (t1_.tag_id = t0_.id) WHERE t1_.target_type = 'news' AND t1_.target_id = '7371cf40-c847-4f9a-bea6-1f334229e3ba' 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 56)
7	App\Tag\Infrastructure\Repository\TagAssignmentRepository->findTagsByTarget (line 23)
8	App\Tag\Application\Query\TagPayloadProvider->getForTarget (line 44)
9	App\News\UI\Api\Mapper\NewsMapper->map (line 39)
10	App\Shared\Application\Mapper\ResourceMapperFactory->map (line 103)
11	App\Shared\UI\Api\State\AbstractCachedPaginatedProvider->fetchPage (line 67)
12	App\Shared\UI\Api\State\AbstractCachedPaginatedProvider->{closure:App\Shared\UI\Api\State\AbstractCachedPaginatedProvider::provide():64} (line 111)
13	Symfony\Component\Cache\LockRegistry::compute (line 102)
14	Symfony\Component\Cache\Adapter\TagAwareAdapter->{closure:Symfony\Component\Cache\Traits\ContractsTrait::doGet():85} (line 64)
15	Symfony\Component\Cache\Adapter\TagAwareAdapter->contractsGet (line 85)
16	Symfony\Component\Cache\Adapter\TagAwareAdapter->doGet (line 30)
17	Symfony\Component\Cache\Adapter\TagAwareAdapter->get (line 64)
18	App\Shared\UI\Api\State\AbstractCachedPaginatedProvider->provide (line 43)
19	ApiPlatform\State\CallableProvider->provide (line 79)
20	ApiPlatform\State\Provider\ReadProvider->provide (line 50)
21	ApiPlatform\Symfony\Bundle\SwaggerUi\SwaggerUiProvider->provide (line 62)
22	ApiPlatform\Symfony\Security\State\AccessCheckerProvider->provide (line 50)
23	ApiPlatform\State\Provider\SecurityParameterProvider->provide (line 56)
24	ApiPlatform\State\Provider\DeserializeProvider->provide (line 62)
25	ApiPlatform\Symfony\Security\State\AccessCheckerProvider->provide (line 32)
26	ApiPlatform\Symfony\Validator\State\ValidateProvider->provide (line 62)
27	ApiPlatform\Symfony\Security\State\AccessCheckerProvider->provide (line 102)
28	ApiPlatform\Symfony\Validator\State\ParameterValidatorProvider->provide (line 99)
29	ApiPlatform\State\Provider\ParameterProvider->provide (line 51)
30	ApiPlatform\State\Provider\ContentNegotiationProvider->provide (line 83)
31	ApiPlatform\Symfony\Controller\MainController->__invoke (line 183)
32	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
33	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
34	Symfony\Component\HttpKernel\Kernel->handle (line 35)
35	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
36	require_once (line 5)

3.76 ms
(4.83%)

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:

[
  "73cdf429-8a43-4661-be68-bc98733ff4e2"
]

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 = '73cdf429-8a43-4661-be68-bc98733ff4e2';

#	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 281)
4	Doctrine\ORM\Proxy\ProxyFactory::{closure:Doctrine\ORM\Proxy\ProxyFactory::createLazyInitializer():280} (line 359)
5	Proxies\__CG__\App\File\Domain\Model\File::{closure:{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxyFactory():357}:358} (line 60)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 153)
7	Proxies\__CG__\App\File\Domain\Model\File->__get (line 76)
8	App\File\Domain\Model\File->getFilename (line 26)
9	App\File\Application\Factory\CreateFileDto->make (line 38)
10	App\News\UI\Api\Mapper\NewsMapper->map (line 39)
11	App\Shared\Application\Mapper\ResourceMapperFactory->map (line 103)
12	App\Shared\UI\Api\State\AbstractCachedPaginatedProvider->fetchPage (line 67)
13	App\Shared\UI\Api\State\AbstractCachedPaginatedProvider->{closure:App\Shared\UI\Api\State\AbstractCachedPaginatedProvider::provide():64} (line 111)
14	Symfony\Component\Cache\LockRegistry::compute (line 102)
15	Symfony\Component\Cache\Adapter\TagAwareAdapter->{closure:Symfony\Component\Cache\Traits\ContractsTrait::doGet():85} (line 64)
16	Symfony\Component\Cache\Adapter\TagAwareAdapter->contractsGet (line 85)
17	Symfony\Component\Cache\Adapter\TagAwareAdapter->doGet (line 30)
18	Symfony\Component\Cache\Adapter\TagAwareAdapter->get (line 64)
19	App\Shared\UI\Api\State\AbstractCachedPaginatedProvider->provide (line 43)
20	ApiPlatform\State\CallableProvider->provide (line 79)
21	ApiPlatform\State\Provider\ReadProvider->provide (line 50)
22	ApiPlatform\Symfony\Bundle\SwaggerUi\SwaggerUiProvider->provide (line 62)
23	ApiPlatform\Symfony\Security\State\AccessCheckerProvider->provide (line 50)
24	ApiPlatform\State\Provider\SecurityParameterProvider->provide (line 56)
25	ApiPlatform\State\Provider\DeserializeProvider->provide (line 62)
26	ApiPlatform\Symfony\Security\State\AccessCheckerProvider->provide (line 32)
27	ApiPlatform\Symfony\Validator\State\ValidateProvider->provide (line 62)
28	ApiPlatform\Symfony\Security\State\AccessCheckerProvider->provide (line 102)
29	ApiPlatform\Symfony\Validator\State\ParameterValidatorProvider->provide (line 99)
30	ApiPlatform\State\Provider\ParameterProvider->provide (line 51)
31	ApiPlatform\State\Provider\ContentNegotiationProvider->provide (line 83)
32	ApiPlatform\Symfony\Controller\MainController->__invoke (line 183)
33	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
34	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
35	Symfony\Component\HttpKernel\Kernel->handle (line 35)
36	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
37	require_once (line 5)

1.46 ms
(1.87%)

SELECT COUNT(n0_.id) AS sclr_0 FROM news n0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(n0_.id) AS sclr_0
FROM
  news n0_

SELECT COUNT(n0_.id) AS sclr_0 FROM news n0_;

#	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 99)
8	App\Shared\UI\Api\State\AbstractCachedPaginatedProvider->fetchPage (line 67)
9	App\Shared\UI\Api\State\AbstractCachedPaginatedProvider->{closure:App\Shared\UI\Api\State\AbstractCachedPaginatedProvider::provide():64} (line 111)
10	Symfony\Component\Cache\LockRegistry::compute (line 102)
11	Symfony\Component\Cache\Adapter\TagAwareAdapter->{closure:Symfony\Component\Cache\Traits\ContractsTrait::doGet():85} (line 64)
12	Symfony\Component\Cache\Adapter\TagAwareAdapter->contractsGet (line 85)
13	Symfony\Component\Cache\Adapter\TagAwareAdapter->doGet (line 30)
14	Symfony\Component\Cache\Adapter\TagAwareAdapter->get (line 64)
15	App\Shared\UI\Api\State\AbstractCachedPaginatedProvider->provide (line 43)
16	ApiPlatform\State\CallableProvider->provide (line 79)
17	ApiPlatform\State\Provider\ReadProvider->provide (line 50)
18	ApiPlatform\Symfony\Bundle\SwaggerUi\SwaggerUiProvider->provide (line 62)
19	ApiPlatform\Symfony\Security\State\AccessCheckerProvider->provide (line 50)
20	ApiPlatform\State\Provider\SecurityParameterProvider->provide (line 56)
21	ApiPlatform\State\Provider\DeserializeProvider->provide (line 62)
22	ApiPlatform\Symfony\Security\State\AccessCheckerProvider->provide (line 32)
23	ApiPlatform\Symfony\Validator\State\ValidateProvider->provide (line 62)
24	ApiPlatform\Symfony\Security\State\AccessCheckerProvider->provide (line 102)
25	ApiPlatform\Symfony\Validator\State\ParameterValidatorProvider->provide (line 99)
26	ApiPlatform\State\Provider\ParameterProvider->provide (line 51)
27	ApiPlatform\State\Provider\ContentNegotiationProvider->provide (line 83)
28	ApiPlatform\Symfony\Controller\MainController->__invoke (line 183)
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 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\News\Domain\Model\News	6
App\File\Domain\Model\File	6

Entities Mapping

Class	Mapping errors
App\News\Domain\Model\News	No errors.
App\File\Domain\Model\File	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/news?itemsPerPage=6&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