Query Metrics
2
Database Queries
2
Different statements
1.55 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
0.82 ms (53.03%) |
1 |
SELECT t0.user_session_id AS user_session_id_1, t0.created_at AS created_at_2, t0.member_id AS member_id_3, t0.external_id AS external_id_4, t0.email AS email_5, t0.cinema_id AS cinema_id_6, t0.concession_item_id AS concession_item_id_7, t0.vista_booking_id AS vista_booking_id_8, t0.vista_booking_number AS vista_booking_number_9, t0.vista_trans_number AS vista_trans_number_10, t0.reservation AS reservation_11, t0.payment_has_been_started AS payment_has_been_started_12, t0.bonus_card_recharge_bound AS bonus_card_recharge_bound_13, t0.vista_only AS vista_only_14, t0.error_occurred AS error_occurred_15, t0.error_description AS error_description_16, t0.tid AS tid_17, t0.hash AS hash_18, t0.result AS result_19, t0.update_data AS update_data_20, t0.already_received AS already_received_21, t0.headers AS headers_22 FROM transaction_mpay24 t0 WHERE t0.user_session_id = ?
Parameters:
[
"54ea141e99f247cc95c1f0dd0be2b281"
]
|
|
0.73 ms (46.97%) |
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:
[] |
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\PoolGiftCard | No errors. |
| App\Entity\Local\GiftCard | No errors. |
| App\Entity\Local\GiftCardAnonym | No errors. |
| App\Entity\Vista\Session | 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\Order | No errors. |
| App\Entity\Vista\OrderSession | No errors. |