Symfony Profiler

SELECT 
  t0.id AS id_1, 
  t0.max_bonus_card_tickets AS max_bonus_card_tickets_2, 
  t0.apply_corona_distance AS apply_corona_distance_3, 
  t0.allow_booking_splitting AS allow_booking_splitting_4, 
  t0.max_tickets AS max_tickets_5, 
  t0.max_reserved_tickets AS max_reserved_tickets_6, 
  t0.max_reserved_bonus_tickets AS max_reserved_bonus_tickets_7, 
  t0.order_ttl AS order_ttl_8, 
  t0.refund_timespan AS refund_timespan_9, 
  t0.order_payment_ttl AS order_payment_ttl_10, 
  t0.yellow_session_ttl AS yellow_session_ttl_11, 
  t0.yellow_seats_available_percent AS yellow_seats_available_percent_12, 
  t0.red_session_ttl AS red_session_ttl_13, 
  t0.grey_session_ttl AS grey_session_ttl_14, 
  t0.bought_ticket_ttl AS bought_ticket_ttl_15, 
  t0.pickup_time_limit AS pickup_time_limit_16, 
  t0.pickup_time_limit_vip AS pickup_time_limit_vip_17, 
  t0.black_status_count AS black_status_count_18, 
  t0.number_of_retries AS number_of_retries_19, 
  t0.retry_timeout AS retry_timeout_20, 
  t0.throttling AS throttling_21, 
  t0.timeout AS timeout_22, 
  t0.show_popup_on_purchase_tickets_screen AS show_popup_on_purchase_tickets_screen_23, 
  t0.purchase_tickets_screen_popup_text AS purchase_tickets_screen_popup_text_24, 
  t0.allowed_gift_card_number AS allowed_gift_card_number_25, 
  t0.is_allow_gift_card_number AS is_allow_gift_card_number_26, 
  t0.currency_code_one AS currency_code_one_27, 
  t0.currency_code_two AS currency_code_two_28, 
  t0.activate_currency_two AS activate_currency_two_29, 
  t0.currency_conversion_factor AS currency_conversion_factor_30, 
  t0.movie_import_back_days AS movie_import_back_days_31, 
  t0.client_key_needed AS client_key_needed_32, 
  t0.member_password AS member_password_33 
FROM 
  restrictions t0 
LIMIT 
  1

SELECT t0.id AS id_1, t0.max_bonus_card_tickets AS max_bonus_card_tickets_2, t0.apply_corona_distance AS apply_corona_distance_3, t0.allow_booking_splitting AS allow_booking_splitting_4, t0.max_tickets AS max_tickets_5, t0.max_reserved_tickets AS max_reserved_tickets_6, t0.max_reserved_bonus_tickets AS max_reserved_bonus_tickets_7, t0.order_ttl AS order_ttl_8, t0.refund_timespan AS refund_timespan_9, t0.order_payment_ttl AS order_payment_ttl_10, t0.yellow_session_ttl AS yellow_session_ttl_11, t0.yellow_seats_available_percent AS yellow_seats_available_percent_12, t0.red_session_ttl AS red_session_ttl_13, t0.grey_session_ttl AS grey_session_ttl_14, t0.bought_ticket_ttl AS bought_ticket_ttl_15, t0.pickup_time_limit AS pickup_time_limit_16, t0.pickup_time_limit_vip AS pickup_time_limit_vip_17, t0.black_status_count AS black_status_count_18, t0.number_of_retries AS number_of_retries_19, t0.retry_timeout AS retry_timeout_20, t0.throttling AS throttling_21, t0.timeout AS timeout_22, t0.show_popup_on_purchase_tickets_screen AS show_popup_on_purchase_tickets_screen_23, t0.purchase_tickets_screen_popup_text AS purchase_tickets_screen_popup_text_24, t0.allowed_gift_card_number AS allowed_gift_card_number_25, t0.is_allow_gift_card_number AS is_allow_gift_card_number_26, t0.currency_code_one AS currency_code_one_27, t0.currency_code_two AS currency_code_two_28, t0.activate_currency_two AS activate_currency_two_29, t0.currency_conversion_factor AS currency_conversion_factor_30, t0.movie_import_back_days AS movie_import_back_days_31, t0.client_key_needed AS client_key_needed_32, t0.member_password AS member_password_33 FROM restrictions t0 LIMIT 1;

SELECT 
  t0.id AS id_1, 
  t0.cinema_id AS cinema_id_2, 
  t0.user_session_id AS user_session_id_3, 
  t0.order_total_value_in_cents AS order_total_value_in_cents_4, 
  t0.state AS state_5, 
  t0.booking_date AS booking_date_6, 
  t0.created_at AS created_at_7, 
  t0.modified_at AS modified_at_8, 
  t0.selection AS selection_9, 
  t0.concession_item AS concession_item_10, 
  t0.cinema_name AS cinema_name_11, 
  t0.session_guid AS session_guid_12, 
  t0.user_id AS user_id_13 
FROM 
  orders t0 
WHERE 
  t0.user_session_id = ? 
  AND t0.state = ? 
LIMIT 
  1

SELECT t0.id AS id_1, t0.cinema_id AS cinema_id_2, t0.user_session_id AS user_session_id_3, t0.order_total_value_in_cents AS order_total_value_in_cents_4, t0.state AS state_5, t0.booking_date AS booking_date_6, t0.created_at AS created_at_7, t0.modified_at AS modified_at_8, t0.selection AS selection_9, t0.concession_item AS concession_item_10, t0.cinema_name AS cinema_name_11, t0.session_guid AS session_guid_12, t0.user_id AS user_id_13 FROM orders t0 WHERE t0.user_session_id = 'a87c4ceb82ae488ba12a8c3391e26f1c' AND t0.state = 'new' LIMIT 1;

SELECT 
  t0.id AS id_1, 
  t0.session_id AS session_id_2, 
  t0.cinema_id AS cinema_id_3, 
  t0.movie_id AS movie_id_4, 
  t0.showtime AS showtime_5, 
  t0.is_allocated_seating AS is_allocated_seating_6, 
  t0.allow_child_admits AS allow_child_admits_7, 
  t0.seats_available AS seats_available_8, 
  t0.seats_total AS seats_total_9, 
  t0.allow_complimentary_tickets AS allow_complimentary_tickets_10, 
  t0.event_id AS event_id_11, 
  t0.price_group_code AS price_group_code_12, 
  t0.screen_name AS screen_name_13, 
  t0.screen_name_alt AS screen_name_alt_14, 
  t0.screen_number AS screen_number_15, 
  t0.cinema_operator_code AS cinema_operator_code_16, 
  t0.format_code AS format_code_17, 
  t0.format_hopk AS format_hopk_18, 
  t0.sales_channels AS sales_channels_19, 
  t0.attributes AS attributes_20, 
  t0.session_attributes_names AS session_attributes_names_21, 
  t0.concept_attributes_names AS concept_attributes_names_22, 
  t0.allow_ticket_sales AS allow_ticket_sales_23, 
  t0.has_dynamically_priced_tickets_available AS has_dynamically_priced_tickets_available_24, 
  t0.play_through_id AS play_through_id_25, 
  t0.session_business_date AS session_business_date_26, 
  t0.session_display_priority AS session_display_priority_27, 
  t0.group_sessions_by_attribute AS group_sessions_by_attribute_28, 
  t0.soldout_status AS soldout_status_29, 
  t0.type_code AS type_code_30, 
  t0.showtime_date AS showtime_date_31, 
  t0.technologies_display_value AS technologies_display_value_32, 
  t0._cinema_id AS _cinema_id_33, 
  t0.scheduled_film_id AS scheduled_film_id_34 
FROM 
  session t0 
WHERE 
  t0.session_id = ? 
  AND t0.cinema_id = ? 
LIMIT 
  1

SELECT t0.id AS id_1, t0.session_id AS session_id_2, t0.cinema_id AS cinema_id_3, t0.movie_id AS movie_id_4, t0.showtime AS showtime_5, t0.is_allocated_seating AS is_allocated_seating_6, t0.allow_child_admits AS allow_child_admits_7, t0.seats_available AS seats_available_8, t0.seats_total AS seats_total_9, t0.allow_complimentary_tickets AS allow_complimentary_tickets_10, t0.event_id AS event_id_11, t0.price_group_code AS price_group_code_12, t0.screen_name AS screen_name_13, t0.screen_name_alt AS screen_name_alt_14, t0.screen_number AS screen_number_15, t0.cinema_operator_code AS cinema_operator_code_16, t0.format_code AS format_code_17, t0.format_hopk AS format_hopk_18, t0.sales_channels AS sales_channels_19, t0.attributes AS attributes_20, t0.session_attributes_names AS session_attributes_names_21, t0.concept_attributes_names AS concept_attributes_names_22, t0.allow_ticket_sales AS allow_ticket_sales_23, t0.has_dynamically_priced_tickets_available AS has_dynamically_priced_tickets_available_24, t0.play_through_id AS play_through_id_25, t0.session_business_date AS session_business_date_26, t0.session_display_priority AS session_display_priority_27, t0.group_sessions_by_attribute AS group_sessions_by_attribute_28, t0.soldout_status AS soldout_status_29, t0.type_code AS type_code_30, t0.showtime_date AS showtime_date_31, t0.technologies_display_value AS technologies_display_value_32, t0._cinema_id AS _cinema_id_33, t0.scheduled_film_id AS scheduled_film_id_34 FROM session t0 WHERE t0.session_id = '21295' AND t0.cinema_id = '1103' LIMIT 1;

SELECT 
  t0.id AS id_1, 
  t0.name AS name_2, 
  t0.image AS image_3, 
  t0.gallery AS gallery_4, 
  t0.phone_number AS phone_number_5, 
  t0.address1 AS address1_6, 
  t0.address2 AS address2_7, 
  t0.parking_info AS parking_info_8, 
  t0.arrival_info AS arrival_info_9, 
  t0.loyalty_code AS loyalty_code_10, 
  t0.description AS description_11, 
  t0.public_transport AS public_transport_12, 
  t0.working_hours AS working_hours_13, 
  t0.geo AS geo_14, 
  t0.hint AS hint_15, 
  t0.yellow_seats_available_percent AS yellow_seats_available_percent_16, 
  t0.info AS info_17, 
  t0.is_drive_in_cinema AS is_drive_in_cinema_18, 
  t0.drive_in_host_cinema_id AS drive_in_host_cinema_id_19, 
  t0.social AS social_20, 
  t0.show_popup_on_purchase_tickets_screen AS show_popup_on_purchase_tickets_screen_21, 
  t0.purchase_tickets_screen_popup_text AS purchase_tickets_screen_popup_text_22, 
  t0.linked_hall_info AS linked_hall_info_23, 
  t0.linked_pricelist AS linked_pricelist_24, 
  t0.freeparking AS freeparking_25, 
  t0.freeparking_en AS freeparking_en_26, 
  t0.concessionsale AS concessionsale_27, 
  t0.cinema_url_name AS cinema_url_name_28 
FROM 
  cinema t0 
WHERE 
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.image AS image_3, t0.gallery AS gallery_4, t0.phone_number AS phone_number_5, t0.address1 AS address1_6, t0.address2 AS address2_7, t0.parking_info AS parking_info_8, t0.arrival_info AS arrival_info_9, t0.loyalty_code AS loyalty_code_10, t0.description AS description_11, t0.public_transport AS public_transport_12, t0.working_hours AS working_hours_13, t0.geo AS geo_14, t0.hint AS hint_15, t0.yellow_seats_available_percent AS yellow_seats_available_percent_16, t0.info AS info_17, t0.is_drive_in_cinema AS is_drive_in_cinema_18, t0.drive_in_host_cinema_id AS drive_in_host_cinema_id_19, t0.social AS social_20, t0.show_popup_on_purchase_tickets_screen AS show_popup_on_purchase_tickets_screen_21, t0.purchase_tickets_screen_popup_text AS purchase_tickets_screen_popup_text_22, t0.linked_hall_info AS linked_hall_info_23, t0.linked_pricelist AS linked_pricelist_24, t0.freeparking AS freeparking_25, t0.freeparking_en AS freeparking_en_26, t0.concessionsale AS concessionsale_27, t0.cinema_url_name AS cinema_url_name_28 FROM cinema t0 WHERE t0.id = '1103';

SELECT 
  t0.id AS id_1, 
  t0.scheduled_film_id AS scheduled_film_id_2, 
  t0.cinema_id AS cinema_id_3, 
  t0.title AS title_4, 
  t0.age_rating AS age_rating_5, 
  t0.age_rating_description AS age_rating_description_6, 
  t0.opening_date AS opening_date_7, 
  t0.duration AS duration_8, 
  t0.trailer_link AS trailer_link_9, 
  t0.corporate_id AS corporate_id_10, 
  t0.hofilm_code AS hofilm_code_11, 
  t0.advertise_advance_booking_date AS advertise_advance_booking_date_12, 
  t0.advance_booking_date AS advance_booking_date_13, 
  t0.film_id AS film_id_14 
FROM 
  film_scheduled t0 
WHERE 
  t0.id = ?

SELECT t0.id AS id_1, t0.scheduled_film_id AS scheduled_film_id_2, t0.cinema_id AS cinema_id_3, t0.title AS title_4, t0.age_rating AS age_rating_5, t0.age_rating_description AS age_rating_description_6, t0.opening_date AS opening_date_7, t0.duration AS duration_8, t0.trailer_link AS trailer_link_9, t0.corporate_id AS corporate_id_10, t0.hofilm_code AS hofilm_code_11, t0.advertise_advance_booking_date AS advertise_advance_booking_date_12, t0.advance_booking_date AS advance_booking_date_13, t0.film_id AS film_id_14 FROM film_scheduled t0 WHERE t0.id = '1103-HO00001810';

SELECT 
  t0.id AS id_1, 
  t0.cinema_id AS cinema_id_2, 
  t0.screen_number AS screen_number_3, 
  t0.seat_plan_json AS seat_plan_json_4, 
  t0.created_at AS created_at_5, 
  t0.modified_at AS modified_at_6 
FROM 
  seat_plan t0 
WHERE 
  t0.cinema_id = ? 
  AND t0.screen_number = ? 
LIMIT 
  1

SELECT t0.id AS id_1, t0.cinema_id AS cinema_id_2, t0.screen_number AS screen_number_3, t0.seat_plan_json AS seat_plan_json_4, t0.created_at AS created_at_5, t0.modified_at AS modified_at_6 FROM seat_plan t0 WHERE t0.cinema_id = '1103' AND t0.screen_number = 2 LIMIT 1;

SELECT 
  t0.id AS id_1, 
  t0.cinema_id AS cinema_id_2, 
  t0.screen_number AS screen_number_3, 
  t0.seat_plan_json AS seat_plan_json_4, 
  t0.created_at AS created_at_5, 
  t0.modified_at AS modified_at_6 
FROM 
  seat_plan t0 
WHERE 
  t0.cinema_id = ? 
  AND t0.screen_number = ? 
LIMIT 
  1

SELECT t0.id AS id_1, t0.cinema_id AS cinema_id_2, t0.screen_number AS screen_number_3, t0.seat_plan_json AS seat_plan_json_4, t0.created_at AS created_at_5, t0.modified_at AS modified_at_6 FROM seat_plan t0 WHERE t0.cinema_id = '1103' AND t0.screen_number = 2 LIMIT 1;

SELECT 
  t0.id AS id_1, 
  t0.ticket_details_ticket_type_code AS ticket_details_ticket_type_code_2, 
  t0.ticket_details_final_price_in_cents AS ticket_details_final_price_in_cents_3, 
  t0.ticket_details_voucher_barcode AS ticket_details_voucher_barcode_4, 
  t0.ticket_details_loyalty_recognition_id AS ticket_details_loyalty_recognition_id_5, 
  t0.ticket_details_loyalty_recognition_sequence AS ticket_details_loyalty_recognition_sequence_6, 
  t0.ticket_details_is_loyalty_ticket AS ticket_details_is_loyalty_ticket_7, 
  t0.ticket_details_is_child_only_ticket AS ticket_details_is_child_only_ticket_8, 
  t0.ticket_details_description AS ticket_details_description_9, 
  t0.ticket_details_price_in_cents AS ticket_details_price_in_cents_10, 
  t0.ticket_details_voucher_barcode_plan AS ticket_details_voucher_barcode_plan_11, 
  t0.ticket_details_voucher_area_category_code AS ticket_details_voucher_area_category_code_12, 
  t0.ticket_details_booking_fee_override_in_cents AS ticket_details_booking_fee_override_in_cents_13, 
  t0.ticket_details_third_party_member_scheme_member_card AS ticket_details_third_party_member_scheme_member_card_14, 
  t0.ticket_details_third_party_member_scheme_member_date_of_birth AS icket_details_third_party_member_scheme_member_date_of_birth_15, 
  t0.order_id AS order_id_16 
FROM 
  ticket t0 
WHERE 
  t0.order_id = ?

SELECT t0.id AS id_1, t0.ticket_details_ticket_type_code AS ticket_details_ticket_type_code_2, t0.ticket_details_final_price_in_cents AS ticket_details_final_price_in_cents_3, t0.ticket_details_voucher_barcode AS ticket_details_voucher_barcode_4, t0.ticket_details_loyalty_recognition_id AS ticket_details_loyalty_recognition_id_5, t0.ticket_details_loyalty_recognition_sequence AS ticket_details_loyalty_recognition_sequence_6, t0.ticket_details_is_loyalty_ticket AS ticket_details_is_loyalty_ticket_7, t0.ticket_details_is_child_only_ticket AS ticket_details_is_child_only_ticket_8, t0.ticket_details_description AS ticket_details_description_9, t0.ticket_details_price_in_cents AS ticket_details_price_in_cents_10, t0.ticket_details_voucher_barcode_plan AS ticket_details_voucher_barcode_plan_11, t0.ticket_details_voucher_area_category_code AS ticket_details_voucher_area_category_code_12, t0.ticket_details_booking_fee_override_in_cents AS ticket_details_booking_fee_override_in_cents_13, t0.ticket_details_third_party_member_scheme_member_card AS ticket_details_third_party_member_scheme_member_card_14, t0.ticket_details_third_party_member_scheme_member_date_of_birth AS icket_details_third_party_member_scheme_member_date_of_birth_15, t0.order_id AS order_id_16 FROM ticket t0 WHERE t0.order_id = '3695e23b-8d5b-11f0-b5d5-00505681f22f';

SELECT 
  t0.uuid AS uuid_1, 
  t0.id AS id_2, 
  t0.item_id AS item_id_3, 
  t0.description AS description_4, 
  t0.quantity AS quantity_5, 
  t0.final_price_in_cents AS final_price_in_cents_6, 
  t0.order_id AS order_id_7 
FROM 
  order_concession_item t0 
WHERE 
  t0.order_id = ?

SELECT t0.uuid AS uuid_1, t0.id AS id_2, t0.item_id AS item_id_3, t0.description AS description_4, t0.quantity AS quantity_5, t0.final_price_in_cents AS final_price_in_cents_6, t0.order_id AS order_id_7 FROM order_concession_item t0 WHERE t0.order_id = '3695e23b-8d5b-11f0-b5d5-00505681f22f';