GET https://api-theatre.rassamahin.ru/api/plays/slider

Query Metrics

76 Database Queries
11 Different statements
156.99 ms Query time
0 Invalid entities
118 Managed entities

Grouped Statements

Show all queries

Time Count Info
40.93 ms
(26.07%)
23
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:
[
  "235fdb82-4737-42fc-8b03-8739e8d7e43c"
]
35.06 ms
(22.33%)
19
SELECT t0.id AS id_1, t0.full_name AS full_name_2, t0.position AS position_3, t0.general_group AS general_group_4, t0.sort_order AS sort_order_5, t0.info AS info_6, t0.about_artist AS about_artist_7, t0.video_url AS video_url_8, t0.created_at AS created_at_9, t0.card_image_id AS card_image_id_10, t0.description_photo_id AS description_photo_id_11, t0.rank_id AS rank_id_12 FROM artist t0 WHERE t0.id = ?
Parameters:
[
  "d361ba49-84db-49c7-80ac-91497c83f4b8"
]
23.98 ms
(15.27%)
8
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_.cast_mode AS cast_mode_5, p1_.id AS id_6, p1_.starts_at AS starts_at_7, p1_.widget_url AS widget_url_8, s2_.id AS id_9, s2_.title AS title_10, s2_.city AS city_11, s2_.created_at AS created_at_12, p3_.id AS id_13, p3_.title AS title_14, p3_.data AS data_15, p3_.created_at AS created_at_16, p0_.play_id AS play_id_17, p0_.stage_id AS stage_id_18, p0_.promotion_id AS promotion_id_19, p1_.performance_id AS performance_id_20, p1_.stage_id AS stage_id_21, p3_.image_id AS image_id_22 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 p3_ ON p0_.promotion_id = p3_.id WHERE p0_.play_id = ? ORDER BY p1_.starts_at ASC
Parameters:
[
  Symfony\Component\Uid\UuidV4 {#1276
    __toString(): "5570fd31-b4f7-4c8e-aaee-b2b7de031c45"
  }
]
11.63 ms
(7.41%)
4
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_.cast_mode AS cast_mode_5, s1_.id AS id_6, s1_.title AS title_7, s1_.city AS city_8, s1_.created_at AS created_at_9, p2_.id AS id_10, p2_.starts_at AS starts_at_11, p2_.widget_url AS widget_url_12, p0_.play_id AS play_id_13, p0_.stage_id AS stage_id_14, p0_.promotion_id AS promotion_id_15, p2_.performance_id AS performance_id_16, p2_.stage_id AS stage_id_17 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 {#1276
    __toString(): "5570fd31-b4f7-4c8e-aaee-b2b7de031c45"
  }
]
8.97 ms
(5.71%)
4
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:
[
  "5570fd31-b4f7-4c8e-aaee-b2b7de031c45"
]
8.84 ms
(5.63%)
4
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:
[
  "play"
  Symfony\Component\Uid\UuidV4 {#1410
    __toString(): "5570fd31-b4f7-4c8e-aaee-b2b7de031c45"
  }
]
8.59 ms
(5.47%)
4
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.duration_minutes AS duration_minutes_6, t0.intermission_minutes AS intermission_minutes_7, t0.age_restriction AS age_restriction_8, t0.audience_category AS audience_category_9, t0.author AS author_10, t0.video_url AS video_url_11, t0.created_at AS created_at_12, t0.poster_id AS poster_id_13, t0.card_image_id AS card_image_id_14 FROM play t0 WHERE t0.id = ?
Parameters:
[
  "5570fd31-b4f7-4c8e-aaee-b2b7de031c45"
]
6.02 ms
(3.84%)
4
SELECT t0.id AS id_1, t0.role AS role_2, t0.play_id AS play_id_3, t0.artist_id AS artist_id_4 FROM play_cast_item t0 WHERE t0.play_id = ?
Parameters:
[
  "5570fd31-b4f7-4c8e-aaee-b2b7de031c45"
]
5.51 ms
(3.51%)
4
SELECT t0.id AS id_1, t0.position AS position_2, t0.play_id AS play_id_3, t0.artist_id AS artist_id_4 FROM play_team_member t0 WHERE t0.play_id = ?
Parameters:
[
  "5570fd31-b4f7-4c8e-aaee-b2b7de031c45"
]
4.37 ms
(2.78%)
1
SELECT t0.id AS id_1, t0.singleton_key AS singleton_key_2, t0.video_url AS video_url_3, t0.afisha_mode AS afisha_mode_4, t0.afisha_week_from AS afisha_week_from_5, t0.afisha_week_to AS afisha_week_to_6, t0.afisha_month AS afisha_month_7, t0.afisha_range_from AS afisha_range_from_8, t0.afisha_range_to AS afisha_range_to_9, t0.banner_code AS banner_code_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12 FROM homepage_settings t0 WHERE t0.singleton_key = ? ORDER BY t0.created_at DESC LIMIT 1
Parameters:
[
  "master"
]
3.10 ms
(1.97%)
1
SELECT t0.id AS id_1, t0.position AS position_2, t0.enabled AS enabled_3, t0.created_at AS created_at_4, t0.settings_id AS settings_id_5, t0.play_id AS play_id_6 FROM homepage_play_item t0 WHERE t0.settings_id = ? ORDER BY t0.position ASC, t0.created_at ASC
Parameters:
[
  "00000000-0000-0000-0000-000000000150"
]

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 19
App\Play\Domain\Model\PlayTeamMember 14
App\Play\Domain\Model\PlayCastItem 12
App\Artist\Domain\Model\ArtistGroup 12
App\Play\Domain\Model\PlaySliderPhoto 7
App\Play\Domain\Model\PerformanceDate 5
App\Homepage\Domain\Model\HomepagePlayItem 4
App\Play\Domain\Model\Play 4
App\Play\Domain\Model\Performance 4
App\Stage\Domain\Model\Stage 2
App\Homepage\Domain\Model\HomepageSettings 1
App\Promotion\Domain\Model\Promotion 1