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

Query Metrics

2 Database Queries
2 Different statements
20.00 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 1.60 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 18.39 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-09-30 10:09:41"
]

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\Vista\Film No errors.
App\Entity\Getmesh\Event No errors.
App\Entity\Vista\Session No errors.
App\Entity\Vista\ScheduledFilm No errors.