Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

2 Database Queries

2 Different statements

7.86 ms Query time

0 Invalid entities

Queries

Group similar statements

#▲	Time	Info
1	1.15 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: [] View formatted query View runnable query Explain query 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;
2	6.71 ms	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 Parameters: [`"1103-21997"`] View formatted query View runnable query Explain query 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-21997' LIMIT 1;

#▲

Time

Info

1.15 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:

[]

View formatted query View runnable query Explain query

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;

6.71 ms

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

Parameters:

[
  "1103-21997"
]

View formatted query View runnable query Explain query

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-21997' LIMIT 1;

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\Session	No errors.
App\Entity\Vista\Film	No errors.
App\Entity\Local\PoolGiftCard	No errors.
App\Entity\Local\GiftCard	No errors.
App\Entity\Local\GiftCardAnonym	No errors.
App\Entity\Local\MPay24OrderPaymentTransaction	No errors.
App\Entity\Local\PushNotificationSubscription	No errors.
App\Entity\Vista\LoyaltyMember	No errors.
App\Entity\Vista\Cinema	No errors.
App\Entity\Vista\ScheduledFilm	No errors.

Symfony Profiler

https://ial-stage.cineplexx.hr/api/v1/sessions/1103-21997

Configuration Settings

Theme