Query Metrics
3
Database Queries
3
Different statements
3.91 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 0.88 ms |
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
Parameters:
[] |
2 | 1.10 ms |
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
Parameters:
[
"emirherton@gmail.com"
]
|
3 | 1.93 ms |
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
Parameters:
[ [ 1103 ] "2025-08-07 12:41:11" ] |
Database Connections
Name | Service |
---|---|
default | doctrine.dbal.default_connection |
Entity Managers
Name | Service |
---|---|
default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
Class | Mapping errors |
---|---|
App\Entity\Local\ClientKeys | No errors. |
App\Entity\Local\Restrictions | No errors. |
App\Entity\Local\PushNotificationSubscription | No errors. |
App\Entity\Vista\LoyaltyMember | No errors. |
App\Entity\Vista\Film | No errors. |
App\Entity\Getmesh\Event | No errors. |
App\Entity\Vista\Session | No errors. |
App\Entity\Vista\ScheduledFilm | No errors. |