Symfony Profiler

Query Metrics

8 Database Queries

3 Different statements

172.22 ms Query time

0 Invalid entities

12 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

146.22 ms
(84.90%)

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 89)
7	App\Shared\UI\Api\State\AbstractCachedPaginatedProvider->fetchPage (line 65)
8	App\Shared\UI\Api\State\AbstractCachedPaginatedProvider->{closure:App\Shared\UI\Api\State\AbstractCachedPaginatedProvider::provide():62} (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 62)
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)

22.83 ms
(13.26%)

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:

[
  "d70f5773-5429-4ba9-8089-cafb42f4ec58"
]

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 = 'd70f5773-5429-4ba9-8089-cafb42f4ec58';

#	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 35)
10	App\News\UI\Api\Mapper\NewsMapper->map (line 39)
11	App\Shared\Application\Mapper\ResourceMapperFactory->map (line 99)
12	App\Shared\UI\Api\State\AbstractCachedPaginatedProvider->fetchPage (line 65)
13	App\Shared\UI\Api\State\AbstractCachedPaginatedProvider->{closure:App\Shared\UI\Api\State\AbstractCachedPaginatedProvider::provide():62} (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 62)
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)

3.17 ms
(1.84%)

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 95)
8	App\Shared\UI\Api\State\AbstractCachedPaginatedProvider->fetchPage (line 65)
9	App\Shared\UI\Api\State\AbstractCachedPaginatedProvider->{closure:App\Shared\UI\Api\State\AbstractCachedPaginatedProvider::provide():62} (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 62)
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.

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