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 
  e0_.id AS id_0, 
  e0_.title AS title_1, 
  e0_.title_en AS title_en_2, 
  e0_.url AS url_3, 
  e0_.language_id AS language_id_4, 
  e0_.country_id AS country_id_5, 
  e0_.picture AS picture_6, 
  e0_.poster AS poster_7, 
  e0_.icon AS icon_8, 
  e0_.short_description AS short_description_9, 
  e0_.long_description AS long_description_10, 
  e0_.top AS top_11, 
  e0_.flag_highlights AS flag_highlights_12, 
  e0_.sorting_top AS sorting_top_13, 
  e0_.sorting_date AS sorting_date_14, 
  e0_.start_date AS start_date_15, 
  e0_.end_date AS end_date_16, 
  e0_.show_start_date AS show_start_date_17, 
  e0_.show_end_date AS show_end_date_18, 
  e0_.type AS type_19, 
  e0_.event_center_license AS event_center_license_20, 
  e0_.abo_ids AS abo_ids_21, 
  e0_.is_abo AS is_abo_22, 
  e0_.gallery AS gallery_23, 
  e0_.position_start_site AS position_start_site_24, 
  e0_.event_url_name AS event_url_name_25 
FROM 
  event e0_ 
WHERE 
  e0_.position_start_site IS NOT NULL 
ORDER BY 
  e0_.position_start_site ASC, 
  e0_.title ASC

SELECT e0_.id AS id_0, e0_.title AS title_1, e0_.title_en AS title_en_2, e0_.url AS url_3, e0_.language_id AS language_id_4, e0_.country_id AS country_id_5, e0_.picture AS picture_6, e0_.poster AS poster_7, e0_.icon AS icon_8, e0_.short_description AS short_description_9, e0_.long_description AS long_description_10, e0_.top AS top_11, e0_.flag_highlights AS flag_highlights_12, e0_.sorting_top AS sorting_top_13, e0_.sorting_date AS sorting_date_14, e0_.start_date AS start_date_15, e0_.end_date AS end_date_16, e0_.show_start_date AS show_start_date_17, e0_.show_end_date AS show_end_date_18, e0_.type AS type_19, e0_.event_center_license AS event_center_license_20, e0_.abo_ids AS abo_ids_21, e0_.is_abo AS is_abo_22, e0_.gallery AS gallery_23, e0_.position_start_site AS position_start_site_24, e0_.event_url_name AS event_url_name_25 FROM event e0_ WHERE e0_.position_start_site IS NOT NULL ORDER BY e0_.position_start_site ASC, e0_.title ASC;

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 '2025-10-02 22:30:27' AND '2025-10-01 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_.synopsis AS synopsis_6, 
  f0_.short_synopsis AS short_synopsis_7, 
  f0_.hofilm_code AS hofilm_code_8, 
  f0_.corporate_film_id AS corporate_film_id_9, 
  f0_.run_time AS run_time_10, 
  f0_.opening_date AS opening_date_11, 
  f0_.graphic_url AS graphic_url_12, 
  f0_.film_name_url AS film_name_url_13, 
  f0_.trailer_url AS trailer_url_14, 
  f0_.is_coming_soon AS is_coming_soon_15, 
  f0_.is_scheduled_at_cinema AS is_scheduled_at_cinema_16, 
  f0_.title_alt AS title_alt_17, 
  f0_.rating_alt AS rating_alt_18, 
  f0_.rating_description_alt AS rating_description_alt_19, 
  f0_.synopsis_alt AS synopsis_alt_20, 
  f0_.short_synopsis_alt AS short_synopsis_alt_21, 
  f0_.website_url AS website_url_22, 
  f0_.genre_id AS genre_id_23, 
  f0_.genre_id2 AS genre_id2_24, 
  f0_.genre_id3 AS genre_id3_25, 
  f0_.edi_code AS edi_code_26, 
  f0_.twitter_tag AS twitter_tag_27, 
  f0_.title_translations AS title_translations_28, 
  f0_.synopsis_translations AS synopsis_translations_29, 
  f0_.short_synopsis_translations AS short_synopsis_translations_30, 
  f0_.rating_description_translations AS rating_description_translations_31, 
  f0_.film_web_id AS film_web_id_32, 
  f0_.movie_xchange_code AS movie_xchange_code_33, 
  f0_.opening_month AS opening_month_34, 
  f0_.director AS director_35, 
  f0_.directors AS directors_36, 
  f0_.actors AS actors_37, 
  f0_.rating_average_score AS rating_average_score_38, 
  f0_.rating_count AS rating_count_39, 
  f0_.movie_pictures AS movie_pictures_40, 
  f0_.true_master AS true_master_41, 
  f0_.top AS top_42, 
  f0_.cinema_ids AS cinema_ids_43, 
  f0_.reviews AS reviews_44, 
  f0_.trailer_key AS trailer_key_45, 
  f0_.trailers AS trailers_46, 
  f0_.gallery AS gallery_47, 
  f0_.teaching_materials AS teaching_materials_48, 
  f0_.rating_getmesh AS rating_getmesh_49, 
  f0_.rating_getmesh_en AS rating_getmesh_en_50, 
  f0_.avg_rating AS avg_rating_51, 
  f0_.nr_of_rating AS nr_of_rating_52, 
  f0_.title_calculated AS title_calculated_53, 
  f0_.title_original_calculated AS title_original_calculated_54, 
  f0_.description_calculated AS description_calculated_55, 
  f0_.description_short_calculated AS description_short_calculated_56, 
  f0_.coming_soon AS coming_soon_57, 
  f0_.poster_image AS poster_image_58, 
  f0_.display AS display_59, 
  f0_.school_movie AS school_movie_60, 
  f0_.origin_lang_cms AS origin_lang_cms_61, 
  f0_.available_tech_cms AS available_tech_cms_62, 
  f0_.available_vers_cms AS available_vers_cms_63, 
  f0_.movie_start_cms AS movie_start_cms_64, 
  f0_.movie_country_cms AS movie_country_cms_65, 
  f0_.keywords AS keywords_66, 
  f0_.film_tipp AS film_tipp_67, 
  f0_.sorting AS sorting_68, 
  f0_.distributor_name AS distributor_name_69, 
  f0_.short_url AS short_url_70, 
  f0_.euYouthLogo AS euYouthLogo_71, 
  f1_.id AS id_72, 
  f1_.name AS name_73, 
  f1_.name_translations AS name_translations_74, 
  f1_.description AS description_75, 
  f1_.description_translations AS description_translations_76 
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 (?) 
ORDER BY 
  f0_.title_calculated 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_.synopsis AS synopsis_6, f0_.short_synopsis AS short_synopsis_7, f0_.hofilm_code AS hofilm_code_8, f0_.corporate_film_id AS corporate_film_id_9, f0_.run_time AS run_time_10, f0_.opening_date AS opening_date_11, f0_.graphic_url AS graphic_url_12, f0_.film_name_url AS film_name_url_13, f0_.trailer_url AS trailer_url_14, f0_.is_coming_soon AS is_coming_soon_15, f0_.is_scheduled_at_cinema AS is_scheduled_at_cinema_16, f0_.title_alt AS title_alt_17, f0_.rating_alt AS rating_alt_18, f0_.rating_description_alt AS rating_description_alt_19, f0_.synopsis_alt AS synopsis_alt_20, f0_.short_synopsis_alt AS short_synopsis_alt_21, f0_.website_url AS website_url_22, f0_.genre_id AS genre_id_23, f0_.genre_id2 AS genre_id2_24, f0_.genre_id3 AS genre_id3_25, f0_.edi_code AS edi_code_26, f0_.twitter_tag AS twitter_tag_27, f0_.title_translations AS title_translations_28, f0_.synopsis_translations AS synopsis_translations_29, f0_.short_synopsis_translations AS short_synopsis_translations_30, f0_.rating_description_translations AS rating_description_translations_31, f0_.film_web_id AS film_web_id_32, f0_.movie_xchange_code AS movie_xchange_code_33, f0_.opening_month AS opening_month_34, f0_.director AS director_35, f0_.directors AS directors_36, f0_.actors AS actors_37, f0_.rating_average_score AS rating_average_score_38, f0_.rating_count AS rating_count_39, f0_.movie_pictures AS movie_pictures_40, f0_.true_master AS true_master_41, f0_.top AS top_42, f0_.cinema_ids AS cinema_ids_43, f0_.reviews AS reviews_44, f0_.trailer_key AS trailer_key_45, f0_.trailers AS trailers_46, f0_.gallery AS gallery_47, f0_.teaching_materials AS teaching_materials_48, f0_.rating_getmesh AS rating_getmesh_49, f0_.rating_getmesh_en AS rating_getmesh_en_50, f0_.avg_rating AS avg_rating_51, f0_.nr_of_rating AS nr_of_rating_52, f0_.title_calculated AS title_calculated_53, f0_.title_original_calculated AS title_original_calculated_54, f0_.description_calculated AS description_calculated_55, f0_.description_short_calculated AS description_short_calculated_56, f0_.coming_soon AS coming_soon_57, f0_.poster_image AS poster_image_58, f0_.display AS display_59, f0_.school_movie AS school_movie_60, f0_.origin_lang_cms AS origin_lang_cms_61, f0_.available_tech_cms AS available_tech_cms_62, f0_.available_vers_cms AS available_vers_cms_63, f0_.movie_start_cms AS movie_start_cms_64, f0_.movie_country_cms AS movie_country_cms_65, f0_.keywords AS keywords_66, f0_.film_tipp AS film_tipp_67, f0_.sorting AS sorting_68, f0_.distributor_name AS distributor_name_69, f0_.short_url AS short_url_70, f0_.euYouthLogo AS euYouthLogo_71, f1_.id AS id_72, f1_.name AS name_73, f1_.name_translations AS name_translations_74, f1_.description AS description_75, f1_.description_translations AS description_translations_76 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 () ORDER BY f0_.title_calculated 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 '2025-10-02 22:30:27' AND '2025-10-01 00:01:00') AND s0_.scheduled_film_id IN ();