GET https://api-theatre.rassamahin.ru/api/plays/f42229f0-d52e-441e-9bc2-678453caf9f1

Query Metrics

59 Database Queries
9 Different statements
48.55 ms Query time
0 Invalid entities
87 Managed entities

Queries

Group similar statements

# Time Info
1 2.85 ms
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"
]
2 1.31 ms
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"
]
3 4.56 ms
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"
  }
]
4 1.75 ms
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"
  }
]
5 1.13 ms
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"
  }
]
6 0.45 ms
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:
[
  "bdd62a08-f93e-4066-a0aa-fb6c02fd9a6e"
]
7 1.11 ms
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"
  }
]
8 1.02 ms
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"
]
9 0.46 ms
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:
[
  "fe2df13f-878f-4798-9655-e1cf3e320b71"
]
10 0.46 ms
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:
[
  "f60a06b9-05f4-4e88-89a7-4e2055f4de7a"
]
11 0.43 ms
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:
[
  "7f005ecf-b03c-4d2f-bd31-148210b985b9"
]
12 0.45 ms
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:
[
  "4e691f2b-443b-492d-8f59-4da75aa4e144"
]
13 0.47 ms
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:
[
  "4bf9d80b-e260-4415-ba15-116e61f10b51"
]
14 0.42 ms
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:
[
  "7e6e7621-97f8-4006-9586-138ef4816042"
]
15 0.42 ms
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:
[
  "2ca01c92-1330-4498-a089-b836dc70988c"
]
16 0.42 ms
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:
[
  "5e32233a-1bb8-4955-b60c-aa7dd9c3d56f"
]
17 0.40 ms
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:
[
  "836a08b2-f9c2-4b90-a3e8-a0abe0031990"
]
18 0.39 ms
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:
[
  "fc009a20-5d89-409c-93ca-775351201fef"
]
19 1.85 ms
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"
]
20 1.71 ms
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"
]
21 0.92 ms
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:
[
  "74eac4e8-5647-42b4-a612-4e12cb9061d8"
]
22 0.63 ms
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:
[
  "4d30f997-be1e-464c-a154-84d54f4c7868"
]
23 0.59 ms
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:
[
  "c7692aa8-3ce8-4a91-8df4-0abec77b2db4"
]
24 0.79 ms
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:
[
  "93faecc9-4d25-4b99-80a9-219867568340"
]
25 1.26 ms
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"
]
26 0.67 ms
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:
[
  "fe4d3502-de71-43d8-83fd-300e9048c798"
]
27 0.91 ms
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:
[
  "56095189-80c1-40b5-9cc5-147d429e094d"
]
28 0.69 ms
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:
[
  "41105859-65ef-4be3-b1b6-c9600cdf164f"
]
29 0.63 ms
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:
[
  "06959bd0-2ecb-4d70-929f-7f12de802798"
]
30 0.58 ms
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:
[
  "57a25f79-6093-46b3-bc3f-20fc1d08f63a"
]
31 0.60 ms
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:
[
  "9ac737a5-20fb-4ed8-8bbb-39a0e5a607cf"
]
32 0.63 ms
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:
[
  "332e1921-27b6-4fb4-afef-75056c487e8b"
]
33 0.54 ms
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:
[
  "ccaf137f-e0ee-422b-969f-22500cc9521a"
]
34 0.84 ms
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:
[
  "41c1fe65-d68d-4a58-9b2d-407ffc710ac0"
]
35 0.65 ms
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:
[
  "6a25aba4-1fc3-466f-8372-9a1d03350291"
]
36 0.69 ms
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:
[
  "76e4a8cb-e390-4088-821e-7a448f5e0185"
]
37 0.45 ms
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:
[
  "dc1dde58-c9e7-435e-94b4-29217a79043f"
]
38 0.54 ms
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:
[
  "cf5b30f3-e7fd-4e19-97e7-56451a40916c"
]
39 0.58 ms
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:
[
  "9ef5e07f-6c27-40b1-8cf6-346df7f865a0"
]
40 0.54 ms
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:
[
  "7e7406b7-98e6-449a-885e-087409806941"
]
41 0.46 ms
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:
[
  "d16c19e5-c321-40c0-9eb7-2950ed3cfc97"
]
42 0.58 ms
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:
[
  "382ec5bc-9d7d-4128-823f-91b7d9f144a7"
]
43 0.56 ms
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:
[
  "dd0b59fa-015b-450f-a598-c8619fbfb242"
]
44 0.60 ms
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:
[
  "90730944-2031-40ca-bfe5-08c42cd75e22"
]
45 0.42 ms
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:
[
  "2ccc9afc-c6ac-4460-aa72-28bbd7719658"
]
46 0.63 ms
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:
[
  "3cd06a4e-43e2-4644-85a9-e3ef37d78ef2"
]
47 0.51 ms
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:
[
  "29d86ed6-11ea-4a9c-8ccb-bcc6bbe204b2"
]
48 0.51 ms
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:
[
  "7b6f50b8-d0d2-4e23-ac14-ca19dd927261"
]
49 0.45 ms
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:
[
  "a298ba4c-0dd0-402c-994e-c268fd89f0c2"
]
50 0.54 ms
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:
[
  "6b2e7e91-0073-4d41-a208-ae86cf42149e"
]
51 0.50 ms
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:
[
  "0568a913-03e2-4e2e-95dc-a9bfad2cf860"
]
52 0.59 ms
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:
[
  "45367b32-30bb-4019-b265-6e7d32849c47"
]
53 0.45 ms
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:
[
  "a300388e-d0f9-4b35-b094-ee9c4568b986"
]
54 0.58 ms
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:
[
  "7468ee30-4a95-4f8c-8db6-ec2580f6da87"
]
55 0.46 ms
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:
[
  "96ae0635-e18c-4f8a-86ec-96235311cbcf"
]
56 0.58 ms
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:
[
  "84a10744-80a5-4309-a94b-00e4cd3ce3d4"
]
57 0.44 ms
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:
[
  "2af6e558-ddb6-4368-93c4-ec744ded7318"
]
58 1.35 ms
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"
  }
]
59 2.55 ms
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"
  }
]

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