Symfony Profiler

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_.opening_date > ? 
  AND f0_.coming_soon = ? 
  AND f0_.display NOT IN (?) 
  AND f0_.display IN (?) 
  AND f0_.opening_date >= ? 
ORDER BY 
  f0_.opening_date ASC, 
  f0_.title_calculated ASC, 
  f0_.opening_date 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_.opening_date > '2026-04-02 09:13:54' AND f0_.coming_soon = 1 AND f0_.display NOT IN ('none') AND f0_.display IN ('all', 'mobile') AND f0_.opening_date >= '2026-04-02 09:13:54' ORDER BY f0_.opening_date ASC, f0_.title_calculated ASC, f0_.opening_date ASC, f0_.title ASC;

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.user_session_id AS user_session_id_2, 
  t0.member_id AS member_id_3, 
  t0.first_name AS first_name_4, 
  t0.last_name AS last_name_5, 
  t0.full_name AS full_name_6, 
  t0.card_number AS card_number_7, 
  t0.mobile_phone AS mobile_phone_8, 
  t0.home_phone AS home_phone_9, 
  t0.apple_user_id AS apple_user_id_10, 
  t0.apple_email_address AS apple_email_address_11, 
  t0.email AS email_12, 
  t0.club_id AS club_id_13, 
  t0.balance_list AS balance_list_14, 
  t0.user_name AS user_name_15, 
  t0.middle_name AS middle_name_16, 
  t0.address1 AS address1_17, 
  t0.state AS state_18, 
  t0.city AS city_19, 
  t0.zip_code AS zip_code_20, 
  t0.send_newsletter AS send_newsletter_21, 
  t0.education_level AS education_level_22, 
  t0.household_income AS household_income_23, 
  t0.persons_in_household AS persons_in_household_24, 
  t0.date_of_birth AS date_of_birth_25, 
  t0.status AS status_26, 
  t0.suburb AS suburb_27, 
  t0.gender AS gender_28, 
  t0.pickup_complex AS pickup_complex_29, 
  t0.preferred_complex AS preferred_complex_30, 
  t0.preferred_complex_list AS preferred_complex_list_31, 
  t0.preference_list AS preference_list_32, 
  t0.opera AS opera_33, 
  t0.family_club_and_children_actions AS family_club_and_children_actions_34, 
  t0.remembrance_events_service AS remembrance_events_service_35, 
  t0.club_name AS club_name_36, 
  t0.contact_by_third_party AS contact_by_third_party_37, 
  t0.expiry_date AS expiry_date_38, 
  t0.wish_to_receive_sms AS wish_to_receive_sms_39, 
  t0.work_zip_code AS work_zip_code_40, 
  t0.card_list AS card_list_41, 
  t0.preferred_genres AS preferred_genres_42, 
  t0.occupation AS occupation_43, 
  t0.marital_status AS marital_status_44, 
  t0.mailing_frequency AS mailing_frequency_45, 
  t0.pin AS pin_46, 
  t0.expiry_points_list AS expiry_points_list_47, 
  t0.member_level_id AS member_level_id_48, 
  t0.member_level_name AS member_level_name_49, 
  t0.loyalty_session_expiry AS loyalty_session_expiry_50, 
  t0.loyalty_session_token AS loyalty_session_token_51, 
  t0.gift_card AS gift_card_52, 
  t0.gift_card_balance AS gift_card_balance_53, 
  t0.is_banned_from_making_unpaid_bookings_until AS is_banned_from_making_unpaid_bookings_until_54, 
  t0.membership_activated AS membership_activated_55, 
  t0.member_item_id AS member_item_id_56, 
  t0.external_id AS external_id_57, 
  t0.national_id AS national_id_58, 
  t0.is_anonymous AS is_anonymous_59, 
  t0.validated_fiscaliazion_law AS validated_fiscaliazion_law_60, 
  t0.member_language_ietfcode AS member_language_ietfcode_61, 
  t0.modified_at AS modified_at_62, 
  t0.created_at AS created_at_63, 
  t0.push_notification_subscription_platform AS push_notification_subscription_platform_64, 
  t0.push_notification_subscription_push_token AS push_notification_subscription_push_token_65 
FROM 
  user t0 
WHERE 
  t0.email = ? 
LIMIT 
  1

SELECT t0.id AS id_1, t0.user_session_id AS user_session_id_2, t0.member_id AS member_id_3, t0.first_name AS first_name_4, t0.last_name AS last_name_5, t0.full_name AS full_name_6, t0.card_number AS card_number_7, t0.mobile_phone AS mobile_phone_8, t0.home_phone AS home_phone_9, t0.apple_user_id AS apple_user_id_10, t0.apple_email_address AS apple_email_address_11, t0.email AS email_12, t0.club_id AS club_id_13, t0.balance_list AS balance_list_14, t0.user_name AS user_name_15, t0.middle_name AS middle_name_16, t0.address1 AS address1_17, t0.state AS state_18, t0.city AS city_19, t0.zip_code AS zip_code_20, t0.send_newsletter AS send_newsletter_21, t0.education_level AS education_level_22, t0.household_income AS household_income_23, t0.persons_in_household AS persons_in_household_24, t0.date_of_birth AS date_of_birth_25, t0.status AS status_26, t0.suburb AS suburb_27, t0.gender AS gender_28, t0.pickup_complex AS pickup_complex_29, t0.preferred_complex AS preferred_complex_30, t0.preferred_complex_list AS preferred_complex_list_31, t0.preference_list AS preference_list_32, t0.opera AS opera_33, t0.family_club_and_children_actions AS family_club_and_children_actions_34, t0.remembrance_events_service AS remembrance_events_service_35, t0.club_name AS club_name_36, t0.contact_by_third_party AS contact_by_third_party_37, t0.expiry_date AS expiry_date_38, t0.wish_to_receive_sms AS wish_to_receive_sms_39, t0.work_zip_code AS work_zip_code_40, t0.card_list AS card_list_41, t0.preferred_genres AS preferred_genres_42, t0.occupation AS occupation_43, t0.marital_status AS marital_status_44, t0.mailing_frequency AS mailing_frequency_45, t0.pin AS pin_46, t0.expiry_points_list AS expiry_points_list_47, t0.member_level_id AS member_level_id_48, t0.member_level_name AS member_level_name_49, t0.loyalty_session_expiry AS loyalty_session_expiry_50, t0.loyalty_session_token AS loyalty_session_token_51, t0.gift_card AS gift_card_52, t0.gift_card_balance AS gift_card_balance_53, t0.is_banned_from_making_unpaid_bookings_until AS is_banned_from_making_unpaid_bookings_until_54, t0.membership_activated AS membership_activated_55, t0.member_item_id AS member_item_id_56, t0.external_id AS external_id_57, t0.national_id AS national_id_58, t0.is_anonymous AS is_anonymous_59, t0.validated_fiscaliazion_law AS validated_fiscaliazion_law_60, t0.member_language_ietfcode AS member_language_ietfcode_61, t0.modified_at AS modified_at_62, t0.created_at AS created_at_63, t0.push_notification_subscription_platform AS push_notification_subscription_platform_64, t0.push_notification_subscription_push_token AS push_notification_subscription_push_token_65 FROM user t0 WHERE t0.email = 'bk@yopmail.com' LIMIT 1;