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 
  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 = 'pvictor.dev+stagehr@gmail.com' 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 = 'HO00001782' OR f0_.hofilm_code = 'HO00001782' OR f1_.short_url = 'HO00001782' OR f0_.scheduled_film_id = 'HO00001782';

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-HO00001782') AND s0_.showtime >= '2025-11-04 00:00:01' AND s0_.showtime <= '2025-11-05 00:00:01';