Query Metrics
13
Database Queries
3
Different statements
35.74 ms
Query time
7
Invalid entities
Grouped Statements
Time▼ | Count | Info | ||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
28.52 ms (79.80%) |
10 |
SELECT t0.id AS id_1, t0.legal_status AS legal_status_2, t0.email AS email_3, t0.roles AS roles_4, t0.password AS password_5, t0.name AS name_6, t0.yandex AS yandex_7, t0.last_name AS last_name_8, t0.phone AS phone_9, t0.bank_account AS bank_account_10, t0.created_at AS created_at_11, t0.active AS active_12, t0.verified AS verified_13, t0.locale AS locale_14, t0.payment_account_id AS payment_account_id_15, t0.deleted_at AS deleted_at_16, t0.hash AS hash_17, t0.photo_id AS photo_id_18, t0.city_id AS city_id_19, t0.country_id AS country_id_20, t0.type, t0.artist_role AS artist_role_21, t0.age AS age_22, t0.social AS social_23, t0.social AS social_24 FROM user t0 WHERE t0.id = ? AND t0.type IN ('system', 'new', 'artist', 'location', 'manager', 'organizer', 'label') AND ((t0.deleted_at IS NULL))
Parameters:
[
64
]
|
||||||||||||||||||||||||||||||
5.58 ms (15.62%) |
2 |
SELECT c0_.id AS id_0, c0_.slug AS slug_1, c0_.locales AS locales_2, c0_.active AS active_3, c0_.enable AS enable_4, c0_.code AS code_5, c0_.commission AS commission_6, c0_.deleted_at AS deleted_at_7, c0_.currency_id AS currency_id_8 FROM country c0_ WHERE (c0_.slug = ?) AND (c0_.deleted_at IS NULL)
Parameters:
[
"RU"
]
|
||||||||||||||||||||||||||||||
1.64 ms (4.59%) |
1 |
SELECT e0_.id AS id_0, e0_.hash AS hash_1, e0_.location_confirm AS location_confirm_2, e0_.split_type AS split_type_3, e0_.commission AS commission_4, e0_.type AS type_5, e0_.count_artists AS count_artists_6, e0_.count_musicians AS count_musicians_7, e0_.live AS live_8, e0_.pre_sale AS pre_sale_9, e0_.duration AS duration_10, e0_.status AS status_11, e0_.sell_status AS sell_status_12, e0_.recommended_age AS recommended_age_13, e0_.age_restrictions AS age_restrictions_14, e0_.social AS social_15, e0_.locale AS locale_16, e0_.tax AS tax_17, e0_.free_places AS free_places_18, e0_.buyed_tickets AS buyed_tickets_19, e0_.favorites_count AS favorites_count_20, e0_.min_sell_goal AS min_sell_goal_21, e0_.max_sell_goal AS max_sell_goal_22, e0_.active AS active_23, e0_.sell AS sell_24, e0_.date AS date_25, e0_.start_date AS start_date_26, e0_.end_date AS end_date_27, e0_.doors AS doors_28, e0_.start_sale_at AS start_sale_at_29, e0_.end_sale_at AS end_sale_at_30, e0_.created_at AS created_at_31, e0_.slug AS slug_32, e0_.deleted_at AS deleted_at_33, e0_.moderation_status AS moderation_status_34, e0_.creator_id AS creator_id_35, e0_.location_id AS location_id_36, e0_.country_id AS country_id_37, e0_.city_id AS city_id_38, e0_.currency_id AS currency_id_39, e0_.cover_id AS cover_id_40, e0_.gallery_id AS gallery_id_41, e0_.video_gallery_id AS video_gallery_id_42 FROM event e0_ WHERE (e0_.deleted_at IS NULL) ORDER BY e0_.id DESC
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.