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"
]
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 = '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"
]
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 = '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
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 = '5570fd31-b4f7-4c8e-aaee-b2b7de031c45' ORDER BY p1_.starts_at ASC;
|
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
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 = '5570fd31-b4f7-4c8e-aaee-b2b7de031c45' ORDER BY p2_.starts_at ASC, p0_.id ASC LIMIT 1;
|
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"
]
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 = '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
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 = 'play' AND t1_.target_id = '5570fd31-b4f7-4c8e-aaee-b2b7de031c45' ORDER BY t0_.title ASC;
|
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"
]
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 = '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"
]
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 = '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"
]
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 = '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
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 = 'master' ORDER BY t0.created_at DESC LIMIT 1;
|
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"
]
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 = '00000000-0000-0000-0000-000000000150' ORDER BY t0.position ASC, t0.created_at ASC;
|