Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

5.65 ms Query time

0 Invalid entities

0 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

3.73 ms
(66.01%)

SELECT t0_.id AS id_0, t0_.title AS title_1 FROM tag_assignment t1_ INNER JOIN tag t0_ ON t1_.tag_id = t0_.id INNER JOIN play p2_ ON (t1_.target_id = p2_.id) WHERE t1_.target_type = ? ORDER BY t0_.title ASC

Parameters:

[
  "play"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0_.id AS id_0,
  t0_.title AS title_1
FROM
  tag_assignment t1_
  INNER JOIN tag t0_ ON t1_.tag_id = t0_.id
  INNER JOIN play p2_ ON (t1_.target_id = p2_.id)
WHERE
  t1_.target_type = ?
ORDER BY
  t0_.title ASC

SELECT t0_.id AS id_0, t0_.title AS title_1 FROM tag_assignment t1_ INNER JOIN tag t0_ ON t1_.tag_id = t0_.id INNER JOIN play p2_ ON (t1_.target_id = p2_.id) WHERE t1_.target_type = 'play' 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 701)
6	Doctrine\ORM\AbstractQuery->getArrayResult (line 99)
7	App\Play\UI\Api\State\PlayAfishaFiltersProvider->availableTags (line 53)
8	App\Play\UI\Api\State\PlayAfishaFiltersProvider->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)

1.92 ms
(33.99%)

SELECT s0_.id AS id_0, s0_.title AS title_1 FROM stage s0_ ORDER BY s0_.title ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.id AS id_0,
  s0_.title AS title_1
FROM
  stage s0_
ORDER BY
  s0_.title ASC

SELECT s0_.id AS id_0, s0_.title AS title_1 FROM stage s0_ ORDER BY s0_.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 701)
6	Doctrine\ORM\AbstractQuery->getArrayResult (line 70)
7	App\Play\UI\Api\State\PlayAfishaFiltersProvider->availableStages (line 52)
8	App\Play\UI\Api\State\PlayAfishaFiltersProvider->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)

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

Entities Mapping

Class	Mapping errors
App\Stage\Domain\Model\Stage	No errors.
App\Tag\Domain\Model\TagAssignment	No errors.
App\Tag\Domain\Model\Tag	No errors.
App\Play\Domain\Model\Play	No errors.

Symfony Profiler

GET https://api-theatre.rassamahin.ru/api/plays/afisha/filters

Configuration Settings

Theme

Page Width