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.cinema_id AS cinema_id_2, 
  t0.user_session_id AS user_session_id_3, 
  t0.order_total_value_in_cents AS order_total_value_in_cents_4, 
  t0.state AS state_5, 
  t0.booking_date AS booking_date_6, 
  t0.created_at AS created_at_7, 
  t0.modified_at AS modified_at_8, 
  t0.selection AS selection_9, 
  t0.concession_item AS concession_item_10, 
  t0.cinema_name AS cinema_name_11, 
  t0.session_guid AS session_guid_12, 
  t0.user_id AS user_id_13 
FROM 
  orders t0 
WHERE 
  t0.user_session_id = ? 
  AND t0.state = ? 
LIMIT 
  1

SELECT t0.id AS id_1, t0.cinema_id AS cinema_id_2, t0.user_session_id AS user_session_id_3, t0.order_total_value_in_cents AS order_total_value_in_cents_4, t0.state AS state_5, t0.booking_date AS booking_date_6, t0.created_at AS created_at_7, t0.modified_at AS modified_at_8, t0.selection AS selection_9, t0.concession_item AS concession_item_10, t0.cinema_name AS cinema_name_11, t0.session_guid AS session_guid_12, t0.user_id AS user_id_13 FROM orders t0 WHERE t0.user_session_id = 'e2537b375ebe4500ad175e878b3cf918' AND t0.state = 'payment_started' 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.id = ?

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.id = '90187e22-107d-11f0-b632-00505681f22f';

SELECT 
  t0.user_session_id AS user_session_id_1, 
  t0.created_at AS created_at_2, 
  t0.member_id AS member_id_3, 
  t0.external_id AS external_id_4, 
  t0.email AS email_5, 
  t0.cinema_id AS cinema_id_6, 
  t0.concession_item_id AS concession_item_id_7, 
  t0.vista_booking_id AS vista_booking_id_8, 
  t0.vista_booking_number AS vista_booking_number_9, 
  t0.vista_trans_number AS vista_trans_number_10, 
  t0.reservation AS reservation_11, 
  t0.payment_has_been_started AS payment_has_been_started_12, 
  t0.bonus_card_recharge_bound AS bonus_card_recharge_bound_13, 
  t0.vista_only AS vista_only_14, 
  t0.error_occurred AS error_occurred_15, 
  t0.error_description AS error_description_16, 
  t0.tid AS tid_17, 
  t0.hash AS hash_18, 
  t0.result AS result_19, 
  t0.update_data AS update_data_20, 
  t0.already_received AS already_received_21, 
  t0.headers AS headers_22 
FROM 
  transaction_mpay24 t0 
WHERE 
  t0.user_session_id = ?

SELECT t0.user_session_id AS user_session_id_1, t0.created_at AS created_at_2, t0.member_id AS member_id_3, t0.external_id AS external_id_4, t0.email AS email_5, t0.cinema_id AS cinema_id_6, t0.concession_item_id AS concession_item_id_7, t0.vista_booking_id AS vista_booking_id_8, t0.vista_booking_number AS vista_booking_number_9, t0.vista_trans_number AS vista_trans_number_10, t0.reservation AS reservation_11, t0.payment_has_been_started AS payment_has_been_started_12, t0.bonus_card_recharge_bound AS bonus_card_recharge_bound_13, t0.vista_only AS vista_only_14, t0.error_occurred AS error_occurred_15, t0.error_description AS error_description_16, t0.tid AS tid_17, t0.hash AS hash_18, t0.result AS result_19, t0.update_data AS update_data_20, t0.already_received AS already_received_21, t0.headers AS headers_22 FROM transaction_mpay24 t0 WHERE t0.user_session_id = 'e2537b375ebe4500ad175e878b3cf918';

"START TRANSACTION"

"START TRANSACTION";

UPDATE 
  transaction_mpay24 
SET 
  result = ?, 
  update_data = ? 
WHERE 
  user_session_id = ?

UPDATE transaction_mpay24 SET result = 'BILLED', update_data = 'a:20:{s:9:\"OPERATION\";s:12:\"CONFIRMATION\";s:3:\"TID\";s:32:\"35f2e0497c3845a193ef4421e0e4a725\";s:6:\"STATUS\";s:6:\"BILLED\";s:5:\"PRICE\";s:3:\"637\";s:8:\"CURRENCY\";s:3:\"EUR\";s:6:\"P_TYPE\";s:2:\"CC\";s:5:\"BRAND\";s:10:\"MASTERCARD\";s:7:\"MPAYTID\";s:8:\"14743082\";s:10:\"USER_FIELD\";s:0:\"\";s:9:\"ORDERDESC\";s:53:\"Cineplexx Split, 07.11., 1 * Duck Duck Goose HR Title\";s:8:\"CUSTOMER\";s:9:\"test test\";s:14:\"CUSTOMER_EMAIL\";s:20:\"emirherton@gmail.com\";s:8:\"LANGUAGE\";s:2:\"HR\";s:7:\"ERRTEXT\";s:0:\"\";s:11:\"CUSTOMER_ID\";s:13:\"CROLM5T9JGSSS\";s:10:\"PROFILE_ID\";s:0:\"\";s:14:\"PROFILE_STATUS\";s:7:\"UPDATED\";s:13:\"FILTER_STATUS\";s:0:\"\";s:9:\"APPR_CODE\";s:6:\"-test-\";s:10:\"IDENTIFIER\";s:16:\"************0107\";}' WHERE user_session_id = 'e2537b375ebe4500ad175e878b3cf918';

"COMMIT"

"COMMIT";

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.member_id = ? 
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.member_id = 'CROLM5T9JGSSS' 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 = 'emirherton@gmail.com' LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

UPDATE 
  user 
SET 
  user_session_id = ?, 
  loyalty_session_expiry = ?, 
  loyalty_session_token = ?, 
  modified_at = ? 
WHERE 
  id = ?

UPDATE user SET user_session_id = 'VpzPQ26vYy91Og7ltXPIaA==', loyalty_session_expiry = '2025-11-07 11:26:24', loyalty_session_token = 'eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJzdWIiOiIiLCJ1bmlxdWVfbmFtZSI6IiIsInZpc3RhX2xveWFsdHlfbWVtYmVyc2hpcF9pZCI6IkNST0xNNVQ5SkdTU1MiLCJ2aXN0YV9tZW1iZXJfbG9nZ2VkX2luX3NlY3VyZWx5IjoiRmFsc2UiLCJuYmYiOjE3NjI1MDk5ODQsImV4cCI6MTc2MjUxMTE4NCwiaXNzIjoiQ29ubmVjdCBWYWxpZGF0ZU1lbWJlciBpc3N1ZXIiLCJhdWQiOiJhbGwifQ.aC5IEdvrXJ2VimUEfVaKBS8sXqnyEga7tx-hwrXnObs', modified_at = '2025-11-07 11:06:25' WHERE id = '90187e22-107d-11f0-b632-00505681f22f';

"COMMIT"

"COMMIT";

"START TRANSACTION"

"START TRANSACTION";

UPDATE 
  transaction_mpay24 
SET 
  vista_booking_id = ?, 
  vista_booking_number = ?, 
  vista_trans_number = ? 
WHERE 
  user_session_id = ?

UPDATE transaction_mpay24 SET vista_booking_id = 'WLJZHZM', vista_booking_number = '1078', vista_trans_number = '2305' WHERE user_session_id = 'e2537b375ebe4500ad175e878b3cf918';

"COMMIT"

"COMMIT";

"START TRANSACTION"

"START TRANSACTION";

UPDATE 
  transaction_mpay24 
SET 
  already_received = ? 
WHERE 
  user_session_id = ?

UPDATE transaction_mpay24 SET already_received = 1 WHERE user_session_id = 'e2537b375ebe4500ad175e878b3cf918';

"COMMIT"

"COMMIT";

SELECT 
  t0.id AS id_1, 
  t0.session_id AS session_id_2, 
  t0.cinema_id AS cinema_id_3, 
  t0.movie_id AS movie_id_4, 
  t0.showtime AS showtime_5, 
  t0.is_allocated_seating AS is_allocated_seating_6, 
  t0.allow_child_admits AS allow_child_admits_7, 
  t0.seats_available AS seats_available_8, 
  t0.seats_total AS seats_total_9, 
  t0.allow_complimentary_tickets AS allow_complimentary_tickets_10, 
  t0.event_id AS event_id_11, 
  t0.price_group_code AS price_group_code_12, 
  t0.screen_name AS screen_name_13, 
  t0.screen_name_alt AS screen_name_alt_14, 
  t0.screen_number AS screen_number_15, 
  t0.cinema_operator_code AS cinema_operator_code_16, 
  t0.format_code AS format_code_17, 
  t0.format_hopk AS format_hopk_18, 
  t0.sales_channels AS sales_channels_19, 
  t0.attributes AS attributes_20, 
  t0.session_attributes_names AS session_attributes_names_21, 
  t0.concept_attributes_names AS concept_attributes_names_22, 
  t0.allow_ticket_sales AS allow_ticket_sales_23, 
  t0.has_dynamically_priced_tickets_available AS has_dynamically_priced_tickets_available_24, 
  t0.play_through_id AS play_through_id_25, 
  t0.session_business_date AS session_business_date_26, 
  t0.session_display_priority AS session_display_priority_27, 
  t0.group_sessions_by_attribute AS group_sessions_by_attribute_28, 
  t0.soldout_status AS soldout_status_29, 
  t0.type_code AS type_code_30, 
  t0.showtime_date AS showtime_date_31, 
  t0.technologies_display_value AS technologies_display_value_32, 
  t0._cinema_id AS _cinema_id_33, 
  t0.scheduled_film_id AS scheduled_film_id_34 
FROM 
  session t0 
WHERE 
  t0.id = ? 
LIMIT 
  1

SELECT t0.id AS id_1, t0.session_id AS session_id_2, t0.cinema_id AS cinema_id_3, t0.movie_id AS movie_id_4, t0.showtime AS showtime_5, t0.is_allocated_seating AS is_allocated_seating_6, t0.allow_child_admits AS allow_child_admits_7, t0.seats_available AS seats_available_8, t0.seats_total AS seats_total_9, t0.allow_complimentary_tickets AS allow_complimentary_tickets_10, t0.event_id AS event_id_11, t0.price_group_code AS price_group_code_12, t0.screen_name AS screen_name_13, t0.screen_name_alt AS screen_name_alt_14, t0.screen_number AS screen_number_15, t0.cinema_operator_code AS cinema_operator_code_16, t0.format_code AS format_code_17, t0.format_hopk AS format_hopk_18, t0.sales_channels AS sales_channels_19, t0.attributes AS attributes_20, t0.session_attributes_names AS session_attributes_names_21, t0.concept_attributes_names AS concept_attributes_names_22, t0.allow_ticket_sales AS allow_ticket_sales_23, t0.has_dynamically_priced_tickets_available AS has_dynamically_priced_tickets_available_24, t0.play_through_id AS play_through_id_25, t0.session_business_date AS session_business_date_26, t0.session_display_priority AS session_display_priority_27, t0.group_sessions_by_attribute AS group_sessions_by_attribute_28, t0.soldout_status AS soldout_status_29, t0.type_code AS type_code_30, t0.showtime_date AS showtime_date_31, t0.technologies_display_value AS technologies_display_value_32, t0._cinema_id AS _cinema_id_33, t0.scheduled_film_id AS scheduled_film_id_34 FROM session t0 WHERE t0.id = '1103-22277' LIMIT 1;

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.parking_info AS parking_info_8, 
  t0.arrival_info AS arrival_info_9, 
  t0.loyalty_code AS loyalty_code_10, 
  t0.description AS description_11, 
  t0.public_transport AS public_transport_12, 
  t0.working_hours AS working_hours_13, 
  t0.geo AS geo_14, 
  t0.hint AS hint_15, 
  t0.yellow_seats_available_percent AS yellow_seats_available_percent_16, 
  t0.info AS info_17, 
  t0.is_drive_in_cinema AS is_drive_in_cinema_18, 
  t0.drive_in_host_cinema_id AS drive_in_host_cinema_id_19, 
  t0.social AS social_20, 
  t0.show_popup_on_purchase_tickets_screen AS show_popup_on_purchase_tickets_screen_21, 
  t0.purchase_tickets_screen_popup_text AS purchase_tickets_screen_popup_text_22, 
  t0.linked_hall_info AS linked_hall_info_23, 
  t0.linked_pricelist AS linked_pricelist_24, 
  t0.freeparking AS freeparking_25, 
  t0.freeparking_en AS freeparking_en_26, 
  t0.concessionsale AS concessionsale_27, 
  t0.cinema_url_name AS cinema_url_name_28 
FROM 
  cinema t0 
WHERE 
  t0.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.parking_info AS parking_info_8, t0.arrival_info AS arrival_info_9, t0.loyalty_code AS loyalty_code_10, t0.description AS description_11, t0.public_transport AS public_transport_12, t0.working_hours AS working_hours_13, t0.geo AS geo_14, t0.hint AS hint_15, t0.yellow_seats_available_percent AS yellow_seats_available_percent_16, t0.info AS info_17, t0.is_drive_in_cinema AS is_drive_in_cinema_18, t0.drive_in_host_cinema_id AS drive_in_host_cinema_id_19, t0.social AS social_20, t0.show_popup_on_purchase_tickets_screen AS show_popup_on_purchase_tickets_screen_21, t0.purchase_tickets_screen_popup_text AS purchase_tickets_screen_popup_text_22, t0.linked_hall_info AS linked_hall_info_23, t0.linked_pricelist AS linked_pricelist_24, t0.freeparking AS freeparking_25, t0.freeparking_en AS freeparking_en_26, t0.concessionsale AS concessionsale_27, t0.cinema_url_name AS cinema_url_name_28 FROM cinema t0 WHERE t0.id = '1103';

SELECT 
  t0.id AS id_1, 
  t0.scheduled_film_id AS scheduled_film_id_2, 
  t0.cinema_id AS cinema_id_3, 
  t0.title AS title_4, 
  t0.age_rating AS age_rating_5, 
  t0.age_rating_description AS age_rating_description_6, 
  t0.opening_date AS opening_date_7, 
  t0.duration AS duration_8, 
  t0.trailer_link AS trailer_link_9, 
  t0.corporate_id AS corporate_id_10, 
  t0.hofilm_code AS hofilm_code_11, 
  t0.advertise_advance_booking_date AS advertise_advance_booking_date_12, 
  t0.advance_booking_date AS advance_booking_date_13, 
  t0.film_id AS film_id_14 
FROM 
  film_scheduled t0 
WHERE 
  t0.id = ?

SELECT t0.id AS id_1, t0.scheduled_film_id AS scheduled_film_id_2, t0.cinema_id AS cinema_id_3, t0.title AS title_4, t0.age_rating AS age_rating_5, t0.age_rating_description AS age_rating_description_6, t0.opening_date AS opening_date_7, t0.duration AS duration_8, t0.trailer_link AS trailer_link_9, t0.corporate_id AS corporate_id_10, t0.hofilm_code AS hofilm_code_11, t0.advertise_advance_booking_date AS advertise_advance_booking_date_12, t0.advance_booking_date AS advance_booking_date_13, t0.film_id AS film_id_14 FROM film_scheduled t0 WHERE t0.id = '1103-HO00001826';

SELECT 
  t0.id AS id_1, 
  t0.session_id AS session_id_2, 
  t0.cinema_id AS cinema_id_3, 
  t0.movie_id AS movie_id_4, 
  t0.showtime AS showtime_5, 
  t0.is_allocated_seating AS is_allocated_seating_6, 
  t0.allow_child_admits AS allow_child_admits_7, 
  t0.seats_available AS seats_available_8, 
  t0.seats_total AS seats_total_9, 
  t0.allow_complimentary_tickets AS allow_complimentary_tickets_10, 
  t0.event_id AS event_id_11, 
  t0.price_group_code AS price_group_code_12, 
  t0.screen_name AS screen_name_13, 
  t0.screen_name_alt AS screen_name_alt_14, 
  t0.screen_number AS screen_number_15, 
  t0.cinema_operator_code AS cinema_operator_code_16, 
  t0.format_code AS format_code_17, 
  t0.format_hopk AS format_hopk_18, 
  t0.sales_channels AS sales_channels_19, 
  t0.attributes AS attributes_20, 
  t0.session_attributes_names AS session_attributes_names_21, 
  t0.concept_attributes_names AS concept_attributes_names_22, 
  t0.allow_ticket_sales AS allow_ticket_sales_23, 
  t0.has_dynamically_priced_tickets_available AS has_dynamically_priced_tickets_available_24, 
  t0.play_through_id AS play_through_id_25, 
  t0.session_business_date AS session_business_date_26, 
  t0.session_display_priority AS session_display_priority_27, 
  t0.group_sessions_by_attribute AS group_sessions_by_attribute_28, 
  t0.soldout_status AS soldout_status_29, 
  t0.type_code AS type_code_30, 
  t0.showtime_date AS showtime_date_31, 
  t0.technologies_display_value AS technologies_display_value_32, 
  t0._cinema_id AS _cinema_id_33, 
  t0.scheduled_film_id AS scheduled_film_id_34 
FROM 
  session t0 
WHERE 
  t0.cinema_id = ? 
  AND t0.session_id = ? 
LIMIT 
  1

SELECT t0.id AS id_1, t0.session_id AS session_id_2, t0.cinema_id AS cinema_id_3, t0.movie_id AS movie_id_4, t0.showtime AS showtime_5, t0.is_allocated_seating AS is_allocated_seating_6, t0.allow_child_admits AS allow_child_admits_7, t0.seats_available AS seats_available_8, t0.seats_total AS seats_total_9, t0.allow_complimentary_tickets AS allow_complimentary_tickets_10, t0.event_id AS event_id_11, t0.price_group_code AS price_group_code_12, t0.screen_name AS screen_name_13, t0.screen_name_alt AS screen_name_alt_14, t0.screen_number AS screen_number_15, t0.cinema_operator_code AS cinema_operator_code_16, t0.format_code AS format_code_17, t0.format_hopk AS format_hopk_18, t0.sales_channels AS sales_channels_19, t0.attributes AS attributes_20, t0.session_attributes_names AS session_attributes_names_21, t0.concept_attributes_names AS concept_attributes_names_22, t0.allow_ticket_sales AS allow_ticket_sales_23, t0.has_dynamically_priced_tickets_available AS has_dynamically_priced_tickets_available_24, t0.play_through_id AS play_through_id_25, t0.session_business_date AS session_business_date_26, t0.session_display_priority AS session_display_priority_27, t0.group_sessions_by_attribute AS group_sessions_by_attribute_28, t0.soldout_status AS soldout_status_29, t0.type_code AS type_code_30, t0.showtime_date AS showtime_date_31, t0.technologies_display_value AS technologies_display_value_32, t0._cinema_id AS _cinema_id_33, t0.scheduled_film_id AS scheduled_film_id_34 FROM session t0 WHERE t0.cinema_id = '1103' AND t0.session_id = 22277 LIMIT 1;