https://ial-stage.cineplexx.hr/api/v2/movies/filters/dates/list?location=all

Query Metrics

3 Database Queries
3 Different statements
3.91 ms Query time
0 Invalid entities

Queries

Group similar statements

# 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.