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 DATE(s0_.showtime) AS sclr_0 
FROM 
  session s0_ 
  INNER JOIN film_scheduled f1_ ON s0_.scheduled_film_id = f1_.id 
  INNER JOIN film f2_ ON f1_.film_id = f2_.id 
WHERE 
  s0_.cinema_id IN (?) 
  AND s0_.showtime >= ? 
ORDER BY 
  DATE(s0_.showtime) ASC

SELECT DISTINCT DATE(s0_.showtime) AS sclr_0 FROM session s0_ INNER JOIN film_scheduled f1_ ON s0_.scheduled_film_id = f1_.id INNER JOIN film f2_ ON f1_.film_id = f2_.id WHERE s0_.cinema_id IN (1103) AND s0_.showtime >= '2026-01-21 07:33:48' ORDER BY DATE(s0_.showtime) 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 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 '2026-01-21 07:34:48' AND '2026-01-22 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 (?) 
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_.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', 'web') AND f0_.id IN ('HO00001782', 'HO00001805', 'HO00001810', 'HO00001826', 'HO00001989', 'HO00001991', 'HO00002091') 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 ('HO00001810', 'HO00001989', 'HO00001826', 'HO00001782', 'HO00002091', 'HO00001805', 'HO00001991');

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-01-21 07:34:48' AND '2026-01-22 00:01:00') AND s0_.scheduled_film_id IN ('1103-HO00001782', '1103-HO00001805', '1103-HO00001810', '1103-HO00001826', '1103-HO00001989', '1103-HO00001991', '1103-HO00002091');

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.city AS city_8, 
  t0.parking_info AS parking_info_9, 
  t0.arrival_info AS arrival_info_10, 
  t0.loyalty_code AS loyalty_code_11, 
  t0.description AS description_12, 
  t0.public_transport AS public_transport_13, 
  t0.working_hours AS working_hours_14, 
  t0.geo AS geo_15, 
  t0.hint AS hint_16, 
  t0.yellow_seats_available_percent AS yellow_seats_available_percent_17, 
  t0.info AS info_18, 
  t0.is_drive_in_cinema AS is_drive_in_cinema_19, 
  t0.drive_in_host_cinema_id AS drive_in_host_cinema_id_20, 
  t0.social AS social_21, 
  t0.show_popup_on_purchase_tickets_screen AS show_popup_on_purchase_tickets_screen_22, 
  t0.purchase_tickets_screen_popup_text AS purchase_tickets_screen_popup_text_23, 
  t0.linked_hall_info AS linked_hall_info_24, 
  t0.linked_pricelist AS linked_pricelist_25, 
  t0.freeparking AS freeparking_26, 
  t0.freeparking_en AS freeparking_en_27, 
  t0.concessionsale AS concessionsale_28, 
  t0.cinema_url_name AS cinema_url_name_29 
FROM 
  cinema t0 
  INNER JOIN event_cinemas ON t0.id = event_cinemas.cinema_id 
WHERE 
  event_cinemas.event_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.city AS city_8, t0.parking_info AS parking_info_9, t0.arrival_info AS arrival_info_10, t0.loyalty_code AS loyalty_code_11, t0.description AS description_12, t0.public_transport AS public_transport_13, t0.working_hours AS working_hours_14, t0.geo AS geo_15, t0.hint AS hint_16, t0.yellow_seats_available_percent AS yellow_seats_available_percent_17, t0.info AS info_18, t0.is_drive_in_cinema AS is_drive_in_cinema_19, t0.drive_in_host_cinema_id AS drive_in_host_cinema_id_20, t0.social AS social_21, t0.show_popup_on_purchase_tickets_screen AS show_popup_on_purchase_tickets_screen_22, t0.purchase_tickets_screen_popup_text AS purchase_tickets_screen_popup_text_23, t0.linked_hall_info AS linked_hall_info_24, t0.linked_pricelist AS linked_pricelist_25, t0.freeparking AS freeparking_26, t0.freeparking_en AS freeparking_en_27, t0.concessionsale AS concessionsale_28, t0.cinema_url_name AS cinema_url_name_29 FROM cinema t0 INNER JOIN event_cinemas ON t0.id = event_cinemas.cinema_id WHERE event_cinemas.event_id = 424;

SELECT 
  t0.id AS id_1, 
  t0.short_code AS short_code_2, 
  t0.title AS title_3, 
  t0.rating AS rating_4, 
  t0.rating_description AS rating_description_5, 
  t0.all_state_ratings AS all_state_ratings_6, 
  t0.common_rating_picture AS common_rating_picture_7, 
  t0.synopsis AS synopsis_8, 
  t0.short_synopsis AS short_synopsis_9, 
  t0.hofilm_code AS hofilm_code_10, 
  t0.corporate_film_id AS corporate_film_id_11, 
  t0.run_time AS run_time_12, 
  t0.opening_date AS opening_date_13, 
  t0.graphic_url AS graphic_url_14, 
  t0.film_name_url AS film_name_url_15, 
  t0.trailer_url AS trailer_url_16, 
  t0.is_coming_soon AS is_coming_soon_17, 
  t0.is_scheduled_at_cinema AS is_scheduled_at_cinema_18, 
  t0.title_alt AS title_alt_19, 
  t0.rating_alt AS rating_alt_20, 
  t0.rating_description_alt AS rating_description_alt_21, 
  t0.synopsis_alt AS synopsis_alt_22, 
  t0.short_synopsis_alt AS short_synopsis_alt_23, 
  t0.website_url AS website_url_24, 
  t0.genre_id AS genre_id_25, 
  t0.genre_id2 AS genre_id2_26, 
  t0.genre_id3 AS genre_id3_27, 
  t0.edi_code AS edi_code_28, 
  t0.twitter_tag AS twitter_tag_29, 
  t0.title_translations AS title_translations_30, 
  t0.synopsis_translations AS synopsis_translations_31, 
  t0.short_synopsis_translations AS short_synopsis_translations_32, 
  t0.rating_description_translations AS rating_description_translations_33, 
  t0.film_web_id AS film_web_id_34, 
  t0.movie_xchange_code AS movie_xchange_code_35, 
  t0.opening_month AS opening_month_36, 
  t0.director AS director_37, 
  t0.directors AS directors_38, 
  t0.actors AS actors_39, 
  t0.rating_average_score AS rating_average_score_40, 
  t0.rating_count AS rating_count_41, 
  t0.movie_pictures AS movie_pictures_42, 
  t0.true_master AS true_master_43, 
  t0.top AS top_44, 
  t0.cinema_ids AS cinema_ids_45, 
  t0.reviews AS reviews_46, 
  t0.trailer_key AS trailer_key_47, 
  t0.trailers AS trailers_48, 
  t0.gallery AS gallery_49, 
  t0.teaching_materials AS teaching_materials_50, 
  t0.rating_getmesh AS rating_getmesh_51, 
  t0.rating_getmesh_en AS rating_getmesh_en_52, 
  t0.avg_rating AS avg_rating_53, 
  t0.nr_of_rating AS nr_of_rating_54, 
  t0.title_calculated AS title_calculated_55, 
  t0.title_original_calculated AS title_original_calculated_56, 
  t0.description_calculated AS description_calculated_57, 
  t0.description_short_calculated AS description_short_calculated_58, 
  t0.coming_soon AS coming_soon_59, 
  t0.poster_image AS poster_image_60, 
  t0.display AS display_61, 
  t0.school_movie AS school_movie_62, 
  t0.origin_lang_cms AS origin_lang_cms_63, 
  t0.available_tech_cms AS available_tech_cms_64, 
  t0.available_vers_cms AS available_vers_cms_65, 
  t0.movie_start_cms AS movie_start_cms_66, 
  t0.movie_country_cms AS movie_country_cms_67, 
  t0.keywords AS keywords_68, 
  t0.film_tipp AS film_tipp_69, 
  t0.sorting AS sorting_70, 
  t0.distributor_name AS distributor_name_71, 
  t0.short_url AS short_url_72, 
  t0.euYouthLogo AS euYouthLogo_73 
FROM 
  film t0 
  INNER JOIN event_film ON t0.id = event_film.film_id 
WHERE 
  event_film.event_id = ?

SELECT t0.id AS id_1, t0.short_code AS short_code_2, t0.title AS title_3, t0.rating AS rating_4, t0.rating_description AS rating_description_5, t0.all_state_ratings AS all_state_ratings_6, t0.common_rating_picture AS common_rating_picture_7, t0.synopsis AS synopsis_8, t0.short_synopsis AS short_synopsis_9, t0.hofilm_code AS hofilm_code_10, t0.corporate_film_id AS corporate_film_id_11, t0.run_time AS run_time_12, t0.opening_date AS opening_date_13, t0.graphic_url AS graphic_url_14, t0.film_name_url AS film_name_url_15, t0.trailer_url AS trailer_url_16, t0.is_coming_soon AS is_coming_soon_17, t0.is_scheduled_at_cinema AS is_scheduled_at_cinema_18, t0.title_alt AS title_alt_19, t0.rating_alt AS rating_alt_20, t0.rating_description_alt AS rating_description_alt_21, t0.synopsis_alt AS synopsis_alt_22, t0.short_synopsis_alt AS short_synopsis_alt_23, t0.website_url AS website_url_24, t0.genre_id AS genre_id_25, t0.genre_id2 AS genre_id2_26, t0.genre_id3 AS genre_id3_27, t0.edi_code AS edi_code_28, t0.twitter_tag AS twitter_tag_29, t0.title_translations AS title_translations_30, t0.synopsis_translations AS synopsis_translations_31, t0.short_synopsis_translations AS short_synopsis_translations_32, t0.rating_description_translations AS rating_description_translations_33, t0.film_web_id AS film_web_id_34, t0.movie_xchange_code AS movie_xchange_code_35, t0.opening_month AS opening_month_36, t0.director AS director_37, t0.directors AS directors_38, t0.actors AS actors_39, t0.rating_average_score AS rating_average_score_40, t0.rating_count AS rating_count_41, t0.movie_pictures AS movie_pictures_42, t0.true_master AS true_master_43, t0.top AS top_44, t0.cinema_ids AS cinema_ids_45, t0.reviews AS reviews_46, t0.trailer_key AS trailer_key_47, t0.trailers AS trailers_48, t0.gallery AS gallery_49, t0.teaching_materials AS teaching_materials_50, t0.rating_getmesh AS rating_getmesh_51, t0.rating_getmesh_en AS rating_getmesh_en_52, t0.avg_rating AS avg_rating_53, t0.nr_of_rating AS nr_of_rating_54, t0.title_calculated AS title_calculated_55, t0.title_original_calculated AS title_original_calculated_56, t0.description_calculated AS description_calculated_57, t0.description_short_calculated AS description_short_calculated_58, t0.coming_soon AS coming_soon_59, t0.poster_image AS poster_image_60, t0.display AS display_61, t0.school_movie AS school_movie_62, t0.origin_lang_cms AS origin_lang_cms_63, t0.available_tech_cms AS available_tech_cms_64, t0.available_vers_cms AS available_vers_cms_65, t0.movie_start_cms AS movie_start_cms_66, t0.movie_country_cms AS movie_country_cms_67, t0.keywords AS keywords_68, t0.film_tipp AS film_tipp_69, t0.sorting AS sorting_70, t0.distributor_name AS distributor_name_71, t0.short_url AS short_url_72, t0.euYouthLogo AS euYouthLogo_73 FROM film t0 INNER JOIN event_film ON t0.id = event_film.film_id WHERE event_film.event_id = 424;