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 
  DISTINCT f0_.id AS id_0 
FROM 
  session s1_ 
  LEFT JOIN film_scheduled f2_ ON s1_.scheduled_film_id = f2_.id 
  LEFT JOIN film f0_ ON f2_.film_id = f0_.id 
WHERE 
  f2_.cinema_id IN (?) 
  AND (
    s1_.showtime BETWEEN ? 
    AND ?
  )

SELECT DISTINCT f0_.id AS id_0 FROM session s1_ LEFT JOIN film_scheduled f2_ ON s1_.scheduled_film_id = f2_.id LEFT JOIN film f0_ ON f2_.film_id = f0_.id WHERE f2_.cinema_id IN (1103) AND (s1_.showtime BETWEEN '2026-04-02 11:56:27' AND '2026-02-26 00:01:00');

SELECT 
  f0_.id AS id_0, 
  f0_.short_code AS short_code_1, 
  f0_.title AS title_2, 
  f0_.rating AS rating_3, 
  f0_.rating_description AS rating_description_4, 
  f0_.all_state_ratings AS all_state_ratings_5, 
  f0_.common_rating_picture AS common_rating_picture_6, 
  f0_.synopsis AS synopsis_7, 
  f0_.short_synopsis AS short_synopsis_8, 
  f0_.hofilm_code AS hofilm_code_9, 
  f0_.corporate_film_id AS corporate_film_id_10, 
  f0_.run_time AS run_time_11, 
  f0_.opening_date AS opening_date_12, 
  f0_.graphic_url AS graphic_url_13, 
  f0_.film_name_url AS film_name_url_14, 
  f0_.trailer_url AS trailer_url_15, 
  f0_.is_coming_soon AS is_coming_soon_16, 
  f0_.is_scheduled_at_cinema AS is_scheduled_at_cinema_17, 
  f0_.title_alt AS title_alt_18, 
  f0_.rating_alt AS rating_alt_19, 
  f0_.rating_description_alt AS rating_description_alt_20, 
  f0_.synopsis_alt AS synopsis_alt_21, 
  f0_.short_synopsis_alt AS short_synopsis_alt_22, 
  f0_.website_url AS website_url_23, 
  f0_.genre_id AS genre_id_24, 
  f0_.genre_id2 AS genre_id2_25, 
  f0_.genre_id3 AS genre_id3_26, 
  f0_.edi_code AS edi_code_27, 
  f0_.twitter_tag AS twitter_tag_28, 
  f0_.title_translations AS title_translations_29, 
  f0_.synopsis_translations AS synopsis_translations_30, 
  f0_.short_synopsis_translations AS short_synopsis_translations_31, 
  f0_.rating_description_translations AS rating_description_translations_32, 
  f0_.film_web_id AS film_web_id_33, 
  f0_.movie_xchange_code AS movie_xchange_code_34, 
  f0_.opening_month AS opening_month_35, 
  f0_.director AS director_36, 
  f0_.directors AS directors_37, 
  f0_.actors AS actors_38, 
  f0_.rating_average_score AS rating_average_score_39, 
  f0_.rating_count AS rating_count_40, 
  f0_.movie_pictures AS movie_pictures_41, 
  f0_.true_master AS true_master_42, 
  f0_.top AS top_43, 
  f0_.cinema_ids AS cinema_ids_44, 
  f0_.reviews AS reviews_45, 
  f0_.trailer_key AS trailer_key_46, 
  f0_.trailers AS trailers_47, 
  f0_.gallery AS gallery_48, 
  f0_.teaching_materials AS teaching_materials_49, 
  f0_.rating_getmesh AS rating_getmesh_50, 
  f0_.rating_getmesh_en AS rating_getmesh_en_51, 
  f0_.avg_rating AS avg_rating_52, 
  f0_.nr_of_rating AS nr_of_rating_53, 
  f0_.title_calculated AS title_calculated_54, 
  f0_.title_original_calculated AS title_original_calculated_55, 
  f0_.description_calculated AS description_calculated_56, 
  f0_.description_short_calculated AS description_short_calculated_57, 
  f0_.coming_soon AS coming_soon_58, 
  f0_.poster_image AS poster_image_59, 
  f0_.display AS display_60, 
  f0_.school_movie AS school_movie_61, 
  f0_.origin_lang_cms AS origin_lang_cms_62, 
  f0_.available_tech_cms AS available_tech_cms_63, 
  f0_.available_vers_cms AS available_vers_cms_64, 
  f0_.movie_start_cms AS movie_start_cms_65, 
  f0_.movie_country_cms AS movie_country_cms_66, 
  f0_.keywords AS keywords_67, 
  f0_.film_tipp AS film_tipp_68, 
  f0_.sorting AS sorting_69, 
  f0_.distributor_name AS distributor_name_70, 
  f0_.short_url AS short_url_71, 
  f0_.euYouthLogo AS euYouthLogo_72, 
  f1_.id AS id_73, 
  f1_.name AS name_74, 
  f1_.name_translations AS name_translations_75, 
  f1_.description AS description_76, 
  f1_.description_translations AS description_translations_77 
FROM 
  film f0_ 
  LEFT JOIN film_genres f2_ ON f0_.id = f2_.movie_id 
  LEFT JOIN film_genre f1_ ON f1_.id = f2_.genre_id 
WHERE 
  f0_.display NOT IN (?) 
  AND f0_.display IN (?) 
  AND f0_.id IN (?) 
  AND f0_.top = ? 
ORDER BY 
  f0_.title_calculated ASC, 
  f0_.title ASC

SELECT f0_.id AS id_0, f0_.short_code AS short_code_1, f0_.title AS title_2, f0_.rating AS rating_3, f0_.rating_description AS rating_description_4, f0_.all_state_ratings AS all_state_ratings_5, f0_.common_rating_picture AS common_rating_picture_6, f0_.synopsis AS synopsis_7, f0_.short_synopsis AS short_synopsis_8, f0_.hofilm_code AS hofilm_code_9, f0_.corporate_film_id AS corporate_film_id_10, f0_.run_time AS run_time_11, f0_.opening_date AS opening_date_12, f0_.graphic_url AS graphic_url_13, f0_.film_name_url AS film_name_url_14, f0_.trailer_url AS trailer_url_15, f0_.is_coming_soon AS is_coming_soon_16, f0_.is_scheduled_at_cinema AS is_scheduled_at_cinema_17, f0_.title_alt AS title_alt_18, f0_.rating_alt AS rating_alt_19, f0_.rating_description_alt AS rating_description_alt_20, f0_.synopsis_alt AS synopsis_alt_21, f0_.short_synopsis_alt AS short_synopsis_alt_22, f0_.website_url AS website_url_23, f0_.genre_id AS genre_id_24, f0_.genre_id2 AS genre_id2_25, f0_.genre_id3 AS genre_id3_26, f0_.edi_code AS edi_code_27, f0_.twitter_tag AS twitter_tag_28, f0_.title_translations AS title_translations_29, f0_.synopsis_translations AS synopsis_translations_30, f0_.short_synopsis_translations AS short_synopsis_translations_31, f0_.rating_description_translations AS rating_description_translations_32, f0_.film_web_id AS film_web_id_33, f0_.movie_xchange_code AS movie_xchange_code_34, f0_.opening_month AS opening_month_35, f0_.director AS director_36, f0_.directors AS directors_37, f0_.actors AS actors_38, f0_.rating_average_score AS rating_average_score_39, f0_.rating_count AS rating_count_40, f0_.movie_pictures AS movie_pictures_41, f0_.true_master AS true_master_42, f0_.top AS top_43, f0_.cinema_ids AS cinema_ids_44, f0_.reviews AS reviews_45, f0_.trailer_key AS trailer_key_46, f0_.trailers AS trailers_47, f0_.gallery AS gallery_48, f0_.teaching_materials AS teaching_materials_49, f0_.rating_getmesh AS rating_getmesh_50, f0_.rating_getmesh_en AS rating_getmesh_en_51, f0_.avg_rating AS avg_rating_52, f0_.nr_of_rating AS nr_of_rating_53, f0_.title_calculated AS title_calculated_54, f0_.title_original_calculated AS title_original_calculated_55, f0_.description_calculated AS description_calculated_56, f0_.description_short_calculated AS description_short_calculated_57, f0_.coming_soon AS coming_soon_58, f0_.poster_image AS poster_image_59, f0_.display AS display_60, f0_.school_movie AS school_movie_61, f0_.origin_lang_cms AS origin_lang_cms_62, f0_.available_tech_cms AS available_tech_cms_63, f0_.available_vers_cms AS available_vers_cms_64, f0_.movie_start_cms AS movie_start_cms_65, f0_.movie_country_cms AS movie_country_cms_66, f0_.keywords AS keywords_67, f0_.film_tipp AS film_tipp_68, f0_.sorting AS sorting_69, f0_.distributor_name AS distributor_name_70, f0_.short_url AS short_url_71, f0_.euYouthLogo AS euYouthLogo_72, f1_.id AS id_73, f1_.name AS name_74, f1_.name_translations AS name_translations_75, f1_.description AS description_76, f1_.description_translations AS description_translations_77 FROM film f0_ LEFT JOIN film_genres f2_ ON f0_.id = f2_.movie_id LEFT JOIN film_genre f1_ ON f1_.id = f2_.genre_id WHERE f0_.display NOT IN ('none') AND f0_.display IN ('all', 'mobile') AND f0_.id IN () AND f0_.top = 1 ORDER BY f0_.title_calculated ASC, f0_.title ASC;

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, 
  f1_.id AS id_13 
FROM 
  film_scheduled f0_ 
  LEFT JOIN film f1_ ON f0_.film_id = f1_.id 
WHERE 
  f0_.film_id IN (?)

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, f1_.id AS id_13 FROM film_scheduled f0_ LEFT JOIN film f1_ ON f0_.film_id = f1_.id WHERE f0_.film_id IN ();

SELECT 
  DISTINCT s0_.cinema_id AS cinema_id_0, 
  s0_.movie_id AS movie_id_1, 
  s0_.technologies_display_value AS technologies_display_value_2 
FROM 
  session s0_ 
  LEFT JOIN film_scheduled f1_ ON s0_.scheduled_film_id = f1_.id 
  LEFT JOIN film f2_ ON f1_.film_id = f2_.id 
WHERE 
  f1_.cinema_id IN (?) 
  AND (
    s0_.showtime BETWEEN ? 
    AND ?
  ) 
  AND s0_.scheduled_film_id IN (?)

SELECT DISTINCT s0_.cinema_id AS cinema_id_0, s0_.movie_id AS movie_id_1, s0_.technologies_display_value AS technologies_display_value_2 FROM session s0_ LEFT JOIN film_scheduled f1_ ON s0_.scheduled_film_id = f1_.id LEFT JOIN film f2_ ON f1_.film_id = f2_.id WHERE f1_.cinema_id IN (1103) AND (s0_.showtime BETWEEN '2026-04-02 11:56:27' AND '2026-02-26 00:01:00') AND s0_.scheduled_film_id IN ();