https://ial-stage.cineplexx.hr/api/v1/events

Method
GET
HTTP Status
200
IP
113.20.18.116
Profiled on
Token
72fa70

Query Metrics

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

Grouped Statements

Show all queries

Time▼ Count Info
3.29 ms
(74.41%) 		1 
SELECT CASE WHEN e0_.start_date IS NULL THEN 1 ELSE 0 END AS sclr_0, CASE WHEN e0_.start_date IS NULL THEN 1 ELSE 0 END AS sclr_1, e0_.id AS id_2, e0_.title AS title_3, e0_.title_en AS title_en_4, e0_.url AS url_5, e0_.language_id AS language_id_6, e0_.country_id AS country_id_7, e0_.picture AS picture_8, e0_.poster AS poster_9, e0_.icon AS icon_10, e0_.short_description AS short_description_11, e0_.long_description AS long_description_12, e0_.top AS top_13, e0_.flag_highlights AS flag_highlights_14, e0_.sorting_top AS sorting_top_15, e0_.sorting_date AS sorting_date_16, e0_.start_date AS start_date_17, e0_.end_date AS end_date_18, e0_.show_start_date AS show_start_date_19, e0_.show_end_date AS show_end_date_20, e0_.type AS type_21, e0_.event_center_license AS event_center_license_22, e0_.abo_ids AS abo_ids_23, e0_.is_abo AS is_abo_24, e0_.gallery AS gallery_25, e0_.position_start_site AS position_start_site_26, e0_.event_url_name AS event_url_name_27, c1_.id AS id_28, c1_.name AS name_29, c1_.image AS image_30, c1_.gallery AS gallery_31, c1_.phone_number AS phone_number_32, c1_.address1 AS address1_33, c1_.address2 AS address2_34, c1_.city AS city_35, c1_.parking_info AS parking_info_36, c1_.arrival_info AS arrival_info_37, c1_.loyalty_code AS loyalty_code_38, c1_.description AS description_39, c1_.public_transport AS public_transport_40, c1_.working_hours AS working_hours_41, c1_.geo AS geo_42, c1_.hint AS hint_43, c1_.yellow_seats_available_percent AS yellow_seats_available_percent_44, c1_.info AS info_45, c1_.is_drive_in_cinema AS is_drive_in_cinema_46, c1_.drive_in_host_cinema_id AS drive_in_host_cinema_id_47, c1_.social AS social_48, c1_.show_popup_on_purchase_tickets_screen AS show_popup_on_purchase_tickets_screen_49, c1_.purchase_tickets_screen_popup_text AS purchase_tickets_screen_popup_text_50, c1_.linked_hall_info AS linked_hall_info_51, c1_.linked_pricelist AS linked_pricelist_52, c1_.freeparking AS freeparking_53, c1_.freeparking_en AS freeparking_en_54, c1_.concessionsale AS concessionsale_55, c1_.cinema_url_name AS cinema_url_name_56, f2_.id AS id_57, f2_.short_code AS short_code_58, f2_.title AS title_59, f2_.rating AS rating_60, f2_.rating_description AS rating_description_61, f2_.all_state_ratings AS all_state_ratings_62, f2_.common_rating_picture AS common_rating_picture_63, f2_.synopsis AS synopsis_64, f2_.short_synopsis AS short_synopsis_65, f2_.hofilm_code AS hofilm_code_66, f2_.corporate_film_id AS corporate_film_id_67, f2_.run_time AS run_time_68, f2_.opening_date AS opening_date_69, f2_.graphic_url AS graphic_url_70, f2_.film_name_url AS film_name_url_71, f2_.trailer_url AS trailer_url_72, f2_.is_coming_soon AS is_coming_soon_73, f2_.is_scheduled_at_cinema AS is_scheduled_at_cinema_74, f2_.title_alt AS title_alt_75, f2_.rating_alt AS rating_alt_76, f2_.rating_description_alt AS rating_description_alt_77, f2_.synopsis_alt AS synopsis_alt_78, f2_.short_synopsis_alt AS short_synopsis_alt_79, f2_.website_url AS website_url_80, f2_.genre_id AS genre_id_81, f2_.genre_id2 AS genre_id2_82, f2_.genre_id3 AS genre_id3_83, f2_.edi_code AS edi_code_84, f2_.twitter_tag AS twitter_tag_85, f2_.title_translations AS title_translations_86, f2_.synopsis_translations AS synopsis_translations_87, f2_.short_synopsis_translations AS short_synopsis_translations_88, f2_.rating_description_translations AS rating_description_translations_89, f2_.film_web_id AS film_web_id_90, f2_.movie_xchange_code AS movie_xchange_code_91, f2_.opening_month AS opening_month_92, f2_.director AS director_93, f2_.directors AS directors_94, f2_.actors AS actors_95, f2_.rating_average_score AS rating_average_score_96, f2_.rating_count AS rating_count_97, f2_.movie_pictures AS movie_pictures_98, f2_.true_master AS true_master_99, f2_.top AS top_100, f2_.cinema_ids AS cinema_ids_101, f2_.reviews AS reviews_102, f2_.trailer_key AS trailer_key_103, f2_.trailers AS trailers_104, f2_.gallery AS gallery_105, f2_.teaching_materials AS teaching_materials_106, f2_.rating_getmesh AS rating_getmesh_107, f2_.rating_getmesh_en AS rating_getmesh_en_108, f2_.avg_rating AS avg_rating_109, f2_.nr_of_rating AS nr_of_rating_110, f2_.title_calculated AS title_calculated_111, f2_.title_original_calculated AS title_original_calculated_112, f2_.description_calculated AS description_calculated_113, f2_.description_short_calculated AS description_short_calculated_114, f2_.coming_soon AS coming_soon_115, f2_.poster_image AS poster_image_116, f2_.display AS display_117, f2_.school_movie AS school_movie_118, f2_.origin_lang_cms AS origin_lang_cms_119, f2_.available_tech_cms AS available_tech_cms_120, f2_.available_vers_cms AS available_vers_cms_121, f2_.movie_start_cms AS movie_start_cms_122, f2_.movie_country_cms AS movie_country_cms_123, f2_.keywords AS keywords_124, f2_.film_tipp AS film_tipp_125, f2_.sorting AS sorting_126, f2_.distributor_name AS distributor_name_127, f2_.short_url AS short_url_128, f2_.euYouthLogo AS euYouthLogo_129 FROM event e0_ INNER JOIN event_cinemas e3_ ON e0_.id = e3_.event_id INNER JOIN cinema c1_ ON c1_.id = e3_.cinema_id LEFT JOIN event_film e4_ ON e0_.id = e4_.event_id LEFT JOIN film f2_ ON f2_.id = e4_.film_id WHERE c1_.id IN (1103) AND (e0_.show_end_date >= ?) AND (e0_.show_start_date <= ?) ORDER BY e0_.sorting_top DESC, sclr_0 ASC, e0_.start_date ASC, sclr_0 ASC, e0_.sorting_date ASC, e0_.title ASC
Parameters: 
[
  "2026-04-03 00:00:00"
  "2026-04-03 00:00:00"
]
View formatted query    View runnable query    Explain query
1.13 ms
(25.59%) 		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
Parameters: 
[]
View formatted query    View runnable query    Explain query

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