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 
  f0_.id AS id_0, 
  f0_.scheduled_film_id AS scheduled_film_id_1, 
  f0_.cinema_id AS cinema_id_2, 
  f0_.title AS title_3, 
  f0_.age_rating AS age_rating_4, 
  f0_.age_rating_description AS age_rating_description_5, 
  f0_.opening_date AS opening_date_6, 
  f0_.duration AS duration_7, 
  f0_.trailer_link AS trailer_link_8, 
  f0_.corporate_id AS corporate_id_9, 
  f0_.hofilm_code AS hofilm_code_10, 
  f0_.advertise_advance_booking_date AS advertise_advance_booking_date_11, 
  f0_.advance_booking_date AS advance_booking_date_12, 
  f0_.film_id AS film_id_13 
FROM 
  film_scheduled f0_ 
  INNER JOIN film f1_ ON f0_.film_id = f1_.id 
WHERE 
  f0_.film_id = ? 
  OR f0_.hofilm_code = ? 
  OR f1_.short_url = ? 
  OR f0_.scheduled_film_id = ?

SELECT f0_.id AS id_0, f0_.scheduled_film_id AS scheduled_film_id_1, f0_.cinema_id AS cinema_id_2, f0_.title AS title_3, f0_.age_rating AS age_rating_4, f0_.age_rating_description AS age_rating_description_5, f0_.opening_date AS opening_date_6, f0_.duration AS duration_7, f0_.trailer_link AS trailer_link_8, f0_.corporate_id AS corporate_id_9, f0_.hofilm_code AS hofilm_code_10, f0_.advertise_advance_booking_date AS advertise_advance_booking_date_11, f0_.advance_booking_date AS advance_booking_date_12, f0_.film_id AS film_id_13 FROM film_scheduled f0_ INNER JOIN film f1_ ON f0_.film_id = f1_.id WHERE f0_.film_id = 'HO00001826' OR f0_.hofilm_code = 'HO00001826' OR f1_.short_url = 'HO00001826' OR f0_.scheduled_film_id = 'HO00001826';

SELECT 
  s0_.id AS id_0, 
  s0_.session_id AS session_id_1, 
  s0_.cinema_id AS cinema_id_2, 
  s0_.movie_id AS movie_id_3, 
  s0_.showtime AS showtime_4, 
  s0_.is_allocated_seating AS is_allocated_seating_5, 
  s0_.allow_child_admits AS allow_child_admits_6, 
  s0_.seats_available AS seats_available_7, 
  s0_.seats_total AS seats_total_8, 
  s0_.allow_complimentary_tickets AS allow_complimentary_tickets_9, 
  s0_.event_id AS event_id_10, 
  s0_.price_group_code AS price_group_code_11, 
  s0_.screen_name AS screen_name_12, 
  s0_.screen_name_alt AS screen_name_alt_13, 
  s0_.screen_number AS screen_number_14, 
  s0_.cinema_operator_code AS cinema_operator_code_15, 
  s0_.format_code AS format_code_16, 
  s0_.format_hopk AS format_hopk_17, 
  s0_.sales_channels AS sales_channels_18, 
  s0_.attributes AS attributes_19, 
  s0_.session_attributes_names AS session_attributes_names_20, 
  s0_.concept_attributes_names AS concept_attributes_names_21, 
  s0_.allow_ticket_sales AS allow_ticket_sales_22, 
  s0_.has_dynamically_priced_tickets_available AS has_dynamically_priced_tickets_available_23, 
  s0_.play_through_id AS play_through_id_24, 
  s0_.session_business_date AS session_business_date_25, 
  s0_.session_display_priority AS session_display_priority_26, 
  s0_.group_sessions_by_attribute AS group_sessions_by_attribute_27, 
  s0_.soldout_status AS soldout_status_28, 
  s0_.type_code AS type_code_29, 
  s0_.showtime_date AS showtime_date_30, 
  s0_.technologies_display_value AS technologies_display_value_31, 
  c1_.id AS id_32, 
  c1_.name AS name_33, 
  c1_.image AS image_34, 
  c1_.gallery AS gallery_35, 
  c1_.phone_number AS phone_number_36, 
  c1_.address1 AS address1_37, 
  c1_.address2 AS address2_38, 
  c1_.parking_info AS parking_info_39, 
  c1_.arrival_info AS arrival_info_40, 
  c1_.loyalty_code AS loyalty_code_41, 
  c1_.description AS description_42, 
  c1_.public_transport AS public_transport_43, 
  c1_.working_hours AS working_hours_44, 
  c1_.geo AS geo_45, 
  c1_.hint AS hint_46, 
  c1_.yellow_seats_available_percent AS yellow_seats_available_percent_47, 
  c1_.info AS info_48, 
  c1_.is_drive_in_cinema AS is_drive_in_cinema_49, 
  c1_.drive_in_host_cinema_id AS drive_in_host_cinema_id_50, 
  c1_.social AS social_51, 
  c1_.show_popup_on_purchase_tickets_screen AS show_popup_on_purchase_tickets_screen_52, 
  c1_.purchase_tickets_screen_popup_text AS purchase_tickets_screen_popup_text_53, 
  c1_.linked_hall_info AS linked_hall_info_54, 
  c1_.linked_pricelist AS linked_pricelist_55, 
  c1_.freeparking AS freeparking_56, 
  c1_.freeparking_en AS freeparking_en_57, 
  c1_.concessionsale AS concessionsale_58, 
  c1_.cinema_url_name AS cinema_url_name_59, 
  s0_._cinema_id AS _cinema_id_60, 
  s0_.scheduled_film_id AS scheduled_film_id_61 
FROM 
  session s0_ 
  INNER JOIN film_scheduled f2_ ON s0_.scheduled_film_id = f2_.id 
  INNER JOIN film f3_ ON f2_.film_id = f3_.id 
  INNER JOIN cinema c1_ ON s0_._cinema_id = c1_.id 
WHERE 
  s0_.cinema_id IN (?) 
  AND s0_.scheduled_film_id IN (?) 
  AND s0_.showtime >= ? 
  AND s0_.showtime <= ?

SELECT s0_.id AS id_0, s0_.session_id AS session_id_1, s0_.cinema_id AS cinema_id_2, s0_.movie_id AS movie_id_3, s0_.showtime AS showtime_4, s0_.is_allocated_seating AS is_allocated_seating_5, s0_.allow_child_admits AS allow_child_admits_6, s0_.seats_available AS seats_available_7, s0_.seats_total AS seats_total_8, s0_.allow_complimentary_tickets AS allow_complimentary_tickets_9, s0_.event_id AS event_id_10, s0_.price_group_code AS price_group_code_11, s0_.screen_name AS screen_name_12, s0_.screen_name_alt AS screen_name_alt_13, s0_.screen_number AS screen_number_14, s0_.cinema_operator_code AS cinema_operator_code_15, s0_.format_code AS format_code_16, s0_.format_hopk AS format_hopk_17, s0_.sales_channels AS sales_channels_18, s0_.attributes AS attributes_19, s0_.session_attributes_names AS session_attributes_names_20, s0_.concept_attributes_names AS concept_attributes_names_21, s0_.allow_ticket_sales AS allow_ticket_sales_22, s0_.has_dynamically_priced_tickets_available AS has_dynamically_priced_tickets_available_23, s0_.play_through_id AS play_through_id_24, s0_.session_business_date AS session_business_date_25, s0_.session_display_priority AS session_display_priority_26, s0_.group_sessions_by_attribute AS group_sessions_by_attribute_27, s0_.soldout_status AS soldout_status_28, s0_.type_code AS type_code_29, s0_.showtime_date AS showtime_date_30, s0_.technologies_display_value AS technologies_display_value_31, c1_.id AS id_32, c1_.name AS name_33, c1_.image AS image_34, c1_.gallery AS gallery_35, c1_.phone_number AS phone_number_36, c1_.address1 AS address1_37, c1_.address2 AS address2_38, c1_.parking_info AS parking_info_39, c1_.arrival_info AS arrival_info_40, c1_.loyalty_code AS loyalty_code_41, c1_.description AS description_42, c1_.public_transport AS public_transport_43, c1_.working_hours AS working_hours_44, c1_.geo AS geo_45, c1_.hint AS hint_46, c1_.yellow_seats_available_percent AS yellow_seats_available_percent_47, c1_.info AS info_48, c1_.is_drive_in_cinema AS is_drive_in_cinema_49, c1_.drive_in_host_cinema_id AS drive_in_host_cinema_id_50, c1_.social AS social_51, c1_.show_popup_on_purchase_tickets_screen AS show_popup_on_purchase_tickets_screen_52, c1_.purchase_tickets_screen_popup_text AS purchase_tickets_screen_popup_text_53, c1_.linked_hall_info AS linked_hall_info_54, c1_.linked_pricelist AS linked_pricelist_55, c1_.freeparking AS freeparking_56, c1_.freeparking_en AS freeparking_en_57, c1_.concessionsale AS concessionsale_58, c1_.cinema_url_name AS cinema_url_name_59, s0_._cinema_id AS _cinema_id_60, s0_.scheduled_film_id AS scheduled_film_id_61 FROM session s0_ INNER JOIN film_scheduled f2_ ON s0_.scheduled_film_id = f2_.id INNER JOIN film f3_ ON f2_.film_id = f3_.id INNER JOIN cinema c1_ ON s0_._cinema_id = c1_.id WHERE s0_.cinema_id IN (1103) AND s0_.scheduled_film_id IN ('1103-HO00001826') AND s0_.showtime >= '2025-11-05 20:31:45' AND s0_.showtime <= '2025-10-22 00:00:01';