GET https://api-theatre.rassamahin.ru/api/plays/4fa389f4-0e02-41b1-9cb8-e8c1e9af8853

Query Metrics

74 Database Queries
9 Different statements
57.44 ms Query time
0 Invalid entities
106 Managed entities

Queries

Group similar statements

# Time Info
1 3.92 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:
[
  "4fa389f4-0e02-41b1-9cb8-e8c1e9af8853"
]
2 1.57 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:
[
  "66e41398-154f-45d5-a482-27a9e2af4610"
]
3 4.81 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(): "4fa389f4-0e02-41b1-9cb8-e8c1e9af8853"
  }
]
4 1.42 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(): "4fa389f4-0e02-41b1-9cb8-e8c1e9af8853"
  }
]
5 1.21 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(): "4fa389f4-0e02-41b1-9cb8-e8c1e9af8853"
  }
]
6 0.53 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:
[
  "ed10b470-dbc3-453a-89e1-da75c37733b1"
]
7 1.33 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(): "4fa389f4-0e02-41b1-9cb8-e8c1e9af8853"
  }
]
8 1.23 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:
[
  "4fa389f4-0e02-41b1-9cb8-e8c1e9af8853"
]
9 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:
[
  "afb339f7-9e14-4a04-b8b4-93af41ba92b3"
]
10 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:
[
  "9a288804-d052-4502-adaf-c975d91ef718"
]
11 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:
[
  "fc757fa0-dbaa-4512-9515-449068101d5d"
]
12 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:
[
  "2efab42d-3d29-4d58-a46c-187283da19b1"
]
13 0.52 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:
[
  "d65bbdd7-aa0b-4026-b782-6f4c6f444dfa"
]
14 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:
[
  "6a6e2f34-29a6-4e1e-9e63-234716f1a9f0"
]
15 2.05 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:
[
  "4fa389f4-0e02-41b1-9cb8-e8c1e9af8853"
]
16 1.93 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:
[
  "bb913794-fe14-41d4-9158-6682a8b3bf5e"
]
17 0.85 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"
]
18 0.53 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:
[
  "ecb3632e-af79-4cb0-a40a-f3c4fec9491d"
]
19 0.61 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"
]
20 0.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:
[
  "93faecc9-4d25-4b99-80a9-219867568340"
]
21 1.22 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:
[
  "4fa389f4-0e02-41b1-9cb8-e8c1e9af8853"
]
22 0.93 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"
]
23 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:
[
  "2ccc9afc-c6ac-4460-aa72-28bbd7719658"
]
24 0.77 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"
]
25 0.53 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"
]
26 0.49 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"
]
27 0.52 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"
]
28 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:
[
  "a067e0d0-cf52-4451-a006-298423a81214"
]
29 0.62 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"
]
30 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:
[
  "56095189-80c1-40b5-9cc5-147d429e094d"
]
31 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:
[
  "3e1b6ec5-c81a-48b1-8cef-b8a43d945474"
]
32 0.53 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:
[
  "6bafc292-11a2-4c44-91e9-ac7b9a204ee8"
]
33 0.77 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:
[
  "57fd7ba5-ddd4-4fd4-8d72-f7f84fffabf5"
]
34 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:
[
  "52dc79bc-036e-4cec-a877-ce809ac1a680"
]
35 0.45 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"
]
36 0.41 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"
]
37 0.82 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"
]
38 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:
[
  "ccaf137f-e0ee-422b-969f-22500cc9521a"
]
39 0.66 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:
[
  "cf956c07-73ce-4b13-bd26-823e414b5573"
]
40 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:
[
  "cf529341-9ee5-4189-885e-5ada2f5558ac"
]
41 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:
[
  "e85eedaf-a68a-41e0-90ef-51ea9d2b17c6"
]
42 0.38 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:
[
  "5638f5ab-c507-40af-a6cb-61b787a59289"
]
43 0.47 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"
]
44 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:
[
  "a298ba4c-0dd0-402c-994e-c268fd89f0c2"
]
45 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"
]
46 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:
[
  "dc1dde58-c9e7-435e-94b4-29217a79043f"
]
47 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:
[
  "025b6f67-3062-4a0a-b1b8-27eeac236bb0"
]
48 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:
[
  "6f0bf884-ab5c-4584-9392-852ab6d083df"
]
49 0.48 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:
[
  "935812bc-b0cc-4d77-8947-43e46c6b357b"
]
50 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:
[
  "fdc5e692-3165-4875-86e6-60731d9a1ca7"
]
51 0.61 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"
]
52 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:
[
  "a300388e-d0f9-4b35-b094-ee9c4568b986"
]
53 0.62 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:
[
  "6df5cab3-98a2-4197-915e-7506d586a0bd"
]
54 0.41 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:
[
  "30883768-3963-4e21-88e3-439b63b0c7b0"
]
55 0.49 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"
]
56 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:
[
  "9ac737a5-20fb-4ed8-8bbb-39a0e5a607cf"
]
57 0.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:
[
  "3cd06a4e-43e2-4644-85a9-e3ef37d78ef2"
]
58 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:
[
  "29d86ed6-11ea-4a9c-8ccb-bcc6bbe204b2"
]
59 0.46 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:
[
  "86b9acaa-f380-419f-9ef7-cd4370c1245d"
]
60 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:
[
  "1eecf4f4-b363-41b1-a470-11034e5cf7cf"
]
61 0.44 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:
[
  "e1a11f71-eb0a-485c-bc25-a82fdc2fafea"
]
62 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:
[
  "3a0e1afa-09bc-4615-b9bd-722c3c5526d9"
]
63 0.49 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:
[
  "d029b16a-2ebc-4129-a5dd-cf53a16d88cd"
]
64 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:
[
  "a06245ee-fcc6-45e8-9735-b2f9d5d1b479"
]
65 0.45 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:
[
  "ac2cb5f2-686b-4ad1-9f52-a51b55e72c0d"
]
66 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:
[
  "f84020fb-51c2-480a-a85d-81261add1842"
]
67 0.50 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:
[
  "bef4050f-2776-4b9c-9d98-1f27f250bb54"
]
68 0.48 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:
[
  "62db3b64-e464-42d9-b58b-72fd80d96b24"
]
69 0.46 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:
[
  "62bcf0af-4b70-4688-886f-644a14708ff2"
]
70 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:
[
  "7080adb2-9aa9-4830-ac72-03c20387e682"
]
71 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:
[
  "74a8d446-2d46-48f9-b338-fdf29cad5b47"
]
72 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:
[
  "4d6c132b-9dc4-4189-a34e-a80dcdd322c7"
]
73 1.25 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(): "4fa389f4-0e02-41b1-9cb8-e8c1e9af8853"
  }
]
74 2.85 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(): "4fa389f4-0e02-41b1-9cb8-e8c1e9af8853"
  }
]

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 38
App\Artist\Domain\Model\Artist 30
App\Play\Domain\Model\PlayCastItem 26
App\Play\Domain\Model\PlaySliderPhoto 6
App\Play\Domain\Model\PlayTeamMember 5
App\Play\Domain\Model\Play 1