Symfony Profiler

Query Metrics

59 Database Queries

9 Different statements

48.55 ms Query time

0 Invalid entities

87 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

14.69 ms
(30.27%)

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:

[
  "d891ee0d-f4c9-43bb-9c66-fc84669b0ab2"
]

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 = 'd891ee0d-f4c9-43bb-9c66-fc84669b0ab2';

#	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 94)
8	App\File\Domain\Model\File->getExtension (line 24)
9	App\File\Application\Factory\CreateFileDto->make (line 46)
10	App\Play\UI\Api\Mapper\PlayMapper->map (line 42)
11	App\Shared\Application\Mapper\ResourceMapperFactory->map (line 70)
12	App\Shared\UI\Api\State\AbstractCachedItemProvider->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)

14.43 ms
(29.72%)

SELECT t0.id AS id_1, t0.full_name AS full_name_2, t0.full_name_sort_key AS full_name_sort_key_3, t0.position AS position_4, t0.general_group AS general_group_5, t0.sort_order AS sort_order_6, t0.info AS info_7, t0.about_artist AS about_artist_8, t0.instrument AS instrument_9, t0.timbre AS timbre_10, t0.video_url AS video_url_11, t0.created_at AS created_at_12, t0.card_image_id AS card_image_id_13, t0.description_photo_id AS description_photo_id_14, t0.rank_id AS rank_id_15 FROM artist t0 WHERE t0.id = ?

Parameters:

[
  "209e6644-1805-4925-a77c-00ca6d12a8b7"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.full_name AS full_name_2,
  t0.full_name_sort_key AS full_name_sort_key_3,
  t0.position AS position_4,
  t0.general_group AS general_group_5,
  t0.sort_order AS sort_order_6,
  t0.info AS info_7,
  t0.about_artist AS about_artist_8,
  t0.instrument AS instrument_9,
  t0.timbre AS timbre_10,
  t0.video_url AS video_url_11,
  t0.created_at AS created_at_12,
  t0.card_image_id AS card_image_id_13,
  t0.description_photo_id AS description_photo_id_14,
  t0.rank_id AS rank_id_15
FROM
  artist t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.full_name AS full_name_2, t0.full_name_sort_key AS full_name_sort_key_3, t0.position AS position_4, t0.general_group AS general_group_5, t0.sort_order AS sort_order_6, t0.info AS info_7, t0.about_artist AS about_artist_8, t0.instrument AS instrument_9, t0.timbre AS timbre_10, t0.video_url AS video_url_11, t0.created_at AS created_at_12, t0.card_image_id AS card_image_id_13, t0.description_photo_id AS description_photo_id_14, t0.rank_id AS rank_id_15 FROM artist t0 WHERE t0.id = '209e6644-1805-4925-a77c-00ca6d12a8b7';

#	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\Artist\Domain\Model\Artist::{closure:{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxyFactory():357}:358} (line 60)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 153)
7	Proxies\__CG__\App\Artist\Domain\Model\Artist->__get (line 91)
8	App\Artist\Domain\Model\Artist->getFullName (line 98)
9	App\Play\UI\Api\Mapper\PlayMapper->map (line 42)
10	App\Shared\Application\Mapper\ResourceMapperFactory->map (line 70)
11	App\Shared\UI\Api\State\AbstractCachedItemProvider->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)

8.79 ms
(18.10%)

SELECT p0_.id AS id_0, p0_.is_premiere AS is_premiere_1, p0_.is_pushkin_card AS is_pushkin_card_2, p0_.is_tour AS is_tour_3, p0_.widget_url AS widget_url_4, p0_.widget_code AS widget_code_5, p0_.cast_mode AS cast_mode_6, p1_.id AS id_7, p1_.starts_at AS starts_at_8, p1_.widget_url AS widget_url_9, p1_.widget_code AS widget_code_10, s2_.id AS id_11, s2_.title AS title_12, s2_.city AS city_13, s2_.created_at AS created_at_14, p3_.id AS id_15, p3_.title AS title_16, p3_.description AS description_17, p3_.active_from AS active_from_18, p3_.active_to AS active_to_19, p3_.created_at AS created_at_20, p0_.play_id AS play_id_21, p0_.stage_id AS stage_id_22, p0_.action_id AS action_id_23, p1_.performance_id AS performance_id_24, p1_.stage_id AS stage_id_25 FROM performance p0_ LEFT JOIN performance_date p1_ ON p0_.id = p1_.performance_id LEFT JOIN stage s2_ ON p0_.stage_id = s2_.id LEFT JOIN promotion_action p3_ ON p0_.action_id = p3_.id WHERE p0_.play_id = ? ORDER BY p1_.starts_at ASC

Parameters:

[
  Symfony\Component\Uid\UuidV4 {#1176
    __toString(): "f42229f0-d52e-441e-9bc2-678453caf9f1"
  }
]

View formatted query View runnable query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.is_premiere AS is_premiere_1,
  p0_.is_pushkin_card AS is_pushkin_card_2,
  p0_.is_tour AS is_tour_3,
  p0_.widget_url AS widget_url_4,
  p0_.widget_code AS widget_code_5,
  p0_.cast_mode AS cast_mode_6,
  p1_.id AS id_7,
  p1_.starts_at AS starts_at_8,
  p1_.widget_url AS widget_url_9,
  p1_.widget_code AS widget_code_10,
  s2_.id AS id_11,
  s2_.title AS title_12,
  s2_.city AS city_13,
  s2_.created_at AS created_at_14,
  p3_.id AS id_15,
  p3_.title AS title_16,
  p3_.description AS description_17,
  p3_.active_from AS active_from_18,
  p3_.active_to AS active_to_19,
  p3_.created_at AS created_at_20,
  p0_.play_id AS play_id_21,
  p0_.stage_id AS stage_id_22,
  p0_.action_id AS action_id_23,
  p1_.performance_id AS performance_id_24,
  p1_.stage_id AS stage_id_25
FROM
  performance p0_
  LEFT JOIN performance_date p1_ ON p0_.id = p1_.performance_id
  LEFT JOIN stage s2_ ON p0_.stage_id = s2_.id
  LEFT JOIN promotion_action p3_ ON p0_.action_id = p3_.id
WHERE
  p0_.play_id = ?
ORDER BY
  p1_.starts_at ASC

SELECT p0_.id AS id_0, p0_.is_premiere AS is_premiere_1, p0_.is_pushkin_card AS is_pushkin_card_2, p0_.is_tour AS is_tour_3, p0_.widget_url AS widget_url_4, p0_.widget_code AS widget_code_5, p0_.cast_mode AS cast_mode_6, p1_.id AS id_7, p1_.starts_at AS starts_at_8, p1_.widget_url AS widget_url_9, p1_.widget_code AS widget_code_10, s2_.id AS id_11, s2_.title AS title_12, s2_.city AS city_13, s2_.created_at AS created_at_14, p3_.id AS id_15, p3_.title AS title_16, p3_.description AS description_17, p3_.active_from AS active_from_18, p3_.active_to AS active_to_19, p3_.created_at AS created_at_20, p0_.play_id AS play_id_21, p0_.stage_id AS stage_id_22, p0_.action_id AS action_id_23, p1_.performance_id AS performance_id_24, p1_.stage_id AS stage_id_25 FROM performance p0_ LEFT JOIN performance_date p1_ ON p0_.id = p1_.performance_id LEFT JOIN stage s2_ ON p0_.stage_id = s2_.id LEFT JOIN promotion_action p3_ ON p0_.action_id = p3_.id WHERE p0_.play_id = 'f42229f0-d52e-441e-9bc2-678453caf9f1' ORDER BY p1_.starts_at 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 38)
7	App\Play\Infrastructure\Repository\PerformanceRepository->findByPlayWithDates (line 180)
8	App\Play\UI\Api\Mapper\PlayMapper->mapWidgetUrls (line 62)
9	App\Play\UI\Api\Mapper\PlayMapper->map (line 42)
10	App\Shared\Application\Mapper\ResourceMapperFactory->map (line 70)
11	App\Shared\UI\Api\State\AbstractCachedItemProvider->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)

2.85 ms
(5.87%)

SELECT t0.id AS id_1, t0.status AS status_2, t0.genre AS genre_3, t0.title AS title_4, t0.description AS description_5, t0.author_genre AS author_genre_6, t0.short_description AS short_description_7, t0.season AS season_8, t0.duration_minutes AS duration_minutes_9, t0.intermission_minutes AS intermission_minutes_10, t0.without_intermission AS without_intermission_11, t0.age_restriction AS age_restriction_12, t0.audience_category AS audience_category_13, t0.author AS author_14, t0.video_url AS video_url_15, t0.created_at AS created_at_16, t0.poster_id AS poster_id_17, t0.card_image_id AS card_image_id_18 FROM play t0 WHERE t0.id = ?

Parameters:

[
  "f42229f0-d52e-441e-9bc2-678453caf9f1"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.status AS status_2,
  t0.genre AS genre_3,
  t0.title AS title_4,
  t0.description AS description_5,
  t0.author_genre AS author_genre_6,
  t0.short_description AS short_description_7,
  t0.season AS season_8,
  t0.duration_minutes AS duration_minutes_9,
  t0.intermission_minutes AS intermission_minutes_10,
  t0.without_intermission AS without_intermission_11,
  t0.age_restriction AS age_restriction_12,
  t0.audience_category AS audience_category_13,
  t0.author AS author_14,
  t0.video_url AS video_url_15,
  t0.created_at AS created_at_16,
  t0.poster_id AS poster_id_17,
  t0.card_image_id AS card_image_id_18
FROM
  play t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.status AS status_2, t0.genre AS genre_3, t0.title AS title_4, t0.description AS description_5, t0.author_genre AS author_genre_6, t0.short_description AS short_description_7, t0.season AS season_8, t0.duration_minutes AS duration_minutes_9, t0.intermission_minutes AS intermission_minutes_10, t0.without_intermission AS without_intermission_11, t0.age_restriction AS age_restriction_12, t0.audience_category AS audience_category_13, t0.author AS author_14, t0.video_url AS video_url_15, t0.created_at AS created_at_16, t0.poster_id AS poster_id_17, t0.card_image_id AS card_image_id_18 FROM play t0 WHERE t0.id = 'f42229f0-d52e-441e-9bc2-678453caf9f1';

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

2.55 ms
(5.26%)

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:

[
  "play"
  Symfony\Component\Uid\UuidV4 {#1176
    __toString(): "f42229f0-d52e-441e-9bc2-678453caf9f1"
  }
]

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 = 'play' AND t1_.target_id = 'f42229f0-d52e-441e-9bc2-678453caf9f1' 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 126)
9	App\Play\UI\Api\Mapper\PlayMapper->map (line 42)
10	App\Shared\Application\Mapper\ResourceMapperFactory->map (line 70)
11	App\Shared\UI\Api\State\AbstractCachedItemProvider->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.85 ms
(3.81%)

SELECT t0.id AS id_1, t0.position AS position_2, t0.sort_order AS sort_order_3, t0.play_id AS play_id_4, t0.artist_id AS artist_id_5 FROM play_team_member t0 WHERE t0.play_id = ? ORDER BY t0.sort_order ASC, t0.id ASC

Parameters:

[
  "f42229f0-d52e-441e-9bc2-678453caf9f1"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.position AS position_2,
  t0.sort_order AS sort_order_3,
  t0.play_id AS play_id_4,
  t0.artist_id AS artist_id_5
FROM
  play_team_member t0
WHERE
  t0.play_id = ?
ORDER BY
  t0.sort_order ASC,
  t0.id ASC

SELECT t0.id AS id_1, t0.position AS position_2, t0.sort_order AS sort_order_3, t0.play_id AS play_id_4, t0.artist_id AS artist_id_5 FROM play_team_member t0 WHERE t0.play_id = 'f42229f0-d52e-441e-9bc2-678453caf9f1' ORDER BY t0.sort_order ASC, t0.id 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 159)
7	Doctrine\Common\Collections\AbstractLazyCollection->toArray (line 91)
8	App\Play\UI\Api\Mapper\PlayMapper->map (line 42)
9	App\Shared\Application\Mapper\ResourceMapperFactory->map (line 70)
10	App\Shared\UI\Api\State\AbstractCachedItemProvider->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)

1.26 ms
(2.60%)

SELECT t0.id AS id_1, t0.role AS role_2, t0.sort_order AS sort_order_3, t0.play_id AS play_id_4, t0.artist_id AS artist_id_5 FROM play_cast_item t0 WHERE t0.play_id = ? ORDER BY t0.sort_order ASC, t0.id ASC

Parameters:

[
  "f42229f0-d52e-441e-9bc2-678453caf9f1"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.role AS role_2,
  t0.sort_order AS sort_order_3,
  t0.play_id AS play_id_4,
  t0.artist_id AS artist_id_5
FROM
  play_cast_item t0
WHERE
  t0.play_id = ?
ORDER BY
  t0.sort_order ASC,
  t0.id ASC

SELECT t0.id AS id_1, t0.role AS role_2, t0.sort_order AS sort_order_3, t0.play_id AS play_id_4, t0.artist_id AS artist_id_5 FROM play_cast_item t0 WHERE t0.play_id = 'f42229f0-d52e-441e-9bc2-678453caf9f1' ORDER BY t0.sort_order ASC, t0.id 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 159)
7	Doctrine\Common\Collections\AbstractLazyCollection->toArray (line 108)
8	App\Play\UI\Api\Mapper\PlayMapper->map (line 42)
9	App\Shared\Application\Mapper\ResourceMapperFactory->map (line 70)
10	App\Shared\UI\Api\State\AbstractCachedItemProvider->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)

1.11 ms
(2.28%)

SELECT p0_.id AS id_0, p0_.is_premiere AS is_premiere_1, p0_.is_pushkin_card AS is_pushkin_card_2, p0_.is_tour AS is_tour_3, p0_.widget_url AS widget_url_4, p0_.widget_code AS widget_code_5, p0_.cast_mode AS cast_mode_6, s1_.id AS id_7, s1_.title AS title_8, s1_.city AS city_9, s1_.created_at AS created_at_10, p2_.id AS id_11, p2_.starts_at AS starts_at_12, p2_.widget_url AS widget_url_13, p2_.widget_code AS widget_code_14, p0_.play_id AS play_id_15, p0_.stage_id AS stage_id_16, p0_.action_id AS action_id_17, p2_.performance_id AS performance_id_18, p2_.stage_id AS stage_id_19 FROM performance p0_ LEFT JOIN stage s1_ ON p0_.stage_id = s1_.id LEFT JOIN performance_date p2_ ON p0_.id = p2_.performance_id WHERE p0_.play_id = ? ORDER BY p2_.starts_at ASC, p0_.id ASC LIMIT 1

Parameters:

[
  Symfony\Component\Uid\UuidV4 {#1176
    __toString(): "f42229f0-d52e-441e-9bc2-678453caf9f1"
  }
]

View formatted query View runnable query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.is_premiere AS is_premiere_1,
  p0_.is_pushkin_card AS is_pushkin_card_2,
  p0_.is_tour AS is_tour_3,
  p0_.widget_url AS widget_url_4,
  p0_.widget_code AS widget_code_5,
  p0_.cast_mode AS cast_mode_6,
  s1_.id AS id_7,
  s1_.title AS title_8,
  s1_.city AS city_9,
  s1_.created_at AS created_at_10,
  p2_.id AS id_11,
  p2_.starts_at AS starts_at_12,
  p2_.widget_url AS widget_url_13,
  p2_.widget_code AS widget_code_14,
  p0_.play_id AS play_id_15,
  p0_.stage_id AS stage_id_16,
  p0_.action_id AS action_id_17,
  p2_.performance_id AS performance_id_18,
  p2_.stage_id AS stage_id_19
FROM
  performance p0_
  LEFT JOIN stage s1_ ON p0_.stage_id = s1_.id
  LEFT JOIN performance_date p2_ ON p0_.id = p2_.performance_id
WHERE
  p0_.play_id = ?
ORDER BY
  p2_.starts_at ASC,
  p0_.id ASC
LIMIT
  1

SELECT p0_.id AS id_0, p0_.is_premiere AS is_premiere_1, p0_.is_pushkin_card AS is_pushkin_card_2, p0_.is_tour AS is_tour_3, p0_.widget_url AS widget_url_4, p0_.widget_code AS widget_code_5, p0_.cast_mode AS cast_mode_6, s1_.id AS id_7, s1_.title AS title_8, s1_.city AS city_9, s1_.created_at AS created_at_10, p2_.id AS id_11, p2_.starts_at AS starts_at_12, p2_.widget_url AS widget_url_13, p2_.widget_code AS widget_code_14, p0_.play_id AS play_id_15, p0_.stage_id AS stage_id_16, p0_.action_id AS action_id_17, p2_.performance_id AS performance_id_18, p2_.stage_id AS stage_id_19 FROM performance p0_ LEFT JOIN stage s1_ ON p0_.stage_id = s1_.id LEFT JOIN performance_date p2_ ON p0_.id = p2_.performance_id WHERE p0_.play_id = 'f42229f0-d52e-441e-9bc2-678453caf9f1' ORDER BY p2_.starts_at ASC, p0_.id ASC LIMIT 1;

#	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 738)
6	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 69)
7	App\Play\Infrastructure\Repository\PerformanceRepository->findFirstStageByPlay (line 73)
8	App\Play\UI\Api\Mapper\PlayMapper->map (line 42)
9	App\Shared\Application\Mapper\ResourceMapperFactory->map (line 70)
10	App\Shared\UI\Api\State\AbstractCachedItemProvider->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)

1.02 ms
(2.10%)

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.play_id AS play_id_3, t0.file_id AS file_id_4 FROM play_slider_photo t0 WHERE t0.play_id = ?

Parameters:

[
  "f42229f0-d52e-441e-9bc2-678453caf9f1"
]

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.play_id AS play_id_3,
  t0.file_id AS file_id_4
FROM
  play_slider_photo t0
WHERE
  t0.play_id = ?

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.play_id AS play_id_3, t0.file_id AS file_id_4 FROM play_slider_photo t0 WHERE t0.play_id = 'f42229f0-d52e-441e-9bc2-678453caf9f1';

#	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 82)
8	App\Play\UI\Api\Mapper\PlayMapper->map (line 42)
9	App\Shared\Application\Mapper\ResourceMapperFactory->map (line 70)
10	App\Shared\UI\Api\State\AbstractCachedItemProvider->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)

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	33
App\Artist\Domain\Model\Artist	21
App\Play\Domain\Model\PlayCastItem	16
App\Play\Domain\Model\PlaySliderPhoto	10
App\Play\Domain\Model\PlayTeamMember	5
App\Play\Domain\Model\Play	1
App\Artist\Domain\Model\ArtistGroup	1

Entities Mapping

Class	Mapping errors
App\Play\Domain\Model\Play	No errors.
App\File\Domain\Model\File	No errors.
App\Play\Domain\Model\PlayTeamMember	No errors.
App\Play\Domain\Model\PlayCastItem	No errors.
App\Play\Domain\Model\PlaySliderPhoto	No errors.
App\Play\Domain\Model\Performance	No errors.
App\Play\Domain\Model\PerformanceDate	No errors.
App\Stage\Domain\Model\Stage	No errors.
App\Action\Domain\Model\Action	No errors.
App\Artist\Domain\Model\Artist	No errors.
App\Artist\Domain\Model\ArtistGroup	No errors.
App\Artist\Domain\Model\ArtistSliderPhoto	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/plays/f42229f0-d52e-441e-9bc2-678453caf9f1

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping