Query Metrics
4
Database Queries
4
Different statements
3.01 ms
Query time
5
Invalid entities
Grouped Statements
Time▼ | Count | Info | ||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0.97 ms (32.23%) |
1 |
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:
[
143
]
|
||||||||||||||||||||||||||||||||
0.80 ms (26.60%) |
1 |
SELECT t0.id AS id_1, t0.hash AS hash_2, t0.location_confirm AS location_confirm_3, t0.split_type AS split_type_4, t0.commission AS commission_5, t0.type AS type_6, t0.count_artists AS count_artists_7, t0.count_musicians AS count_musicians_8, t0.live AS live_9, t0.pre_sale AS pre_sale_10, t0.duration AS duration_11, t0.status AS status_12, t0.sell_status AS sell_status_13, t0.recommended_age AS recommended_age_14, t0.age_restrictions AS age_restrictions_15, t0.social AS social_16, t0.locale AS locale_17, t0.tax AS tax_18, t0.free_places AS free_places_19, t0.buyed_tickets AS buyed_tickets_20, t0.favorites_count AS favorites_count_21, t0.min_sell_goal AS min_sell_goal_22, t0.max_sell_goal AS max_sell_goal_23, t0.active AS active_24, t0.sell AS sell_25, t0.date AS date_26, t0.start_date AS start_date_27, t0.end_date AS end_date_28, t0.doors AS doors_29, t0.start_sale_at AS start_sale_at_30, t0.end_sale_at AS end_sale_at_31, t0.created_at AS created_at_32, t0.slug AS slug_33, t0.deleted_at AS deleted_at_34, t0.moderation_status AS moderation_status_35, t0.creator_id AS creator_id_36, t0.location_id AS location_id_37, t0.country_id AS country_id_38, t0.city_id AS city_id_39, t0.currency_id AS currency_id_40, t0.cover_id AS cover_id_41, t0.gallery_id AS gallery_id_42, t0.video_gallery_id AS video_gallery_id_43 FROM event t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
"62"
]
|
||||||||||||||||||||||||||||||||
0.63 ms (20.85%) |
1 |
SELECT s0_.id AS id_0, s0_.value AS value_1, s0_.entity AS entity_2, s0_.entity_id AS entity_id_3, s0_.created_at AS created_at_4 FROM slug s0_ WHERE s0_.value = ?
Parameters:
[
"werwer-29-august-2024"
]
|
||||||||||||||||||||||||||||||||
0.61 ms (20.32%) |
1 |
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"
]
|
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\Geo\Entity\Country |
|
App\Price\Entity\Currency | No errors. |
App\Geo\Entity\City | No errors. |
App\Geo\Entity\CountryRequisite | No errors. |
App\Geo\Entity\CountryTranslation | No errors. |
App\Core\Entity\Slug | No errors. |
App\Event\Entity\Event |
|
App\User\Entity\User | No errors. |
App\Location\Entity\Location | No errors. |
App\Storage\Entity\File | No errors. |
App\Storage\Entity\Image | No errors. |
App\Storage\Entity\Gallery |
|
App\User\Entity\SystemUser | No errors. |
App\User\Entity\NewUser | No errors. |
App\User\Entity\ArtistUser | No errors. |
App\User\Entity\LocationUser | No errors. |
App\User\Entity\ManagerUser | No errors. |
App\User\Entity\OrganizerUser | No errors. |
App\User\Entity\LabelUser | No errors. |
App\User\Entity\UserRequisite | No errors. |
App\Band\Entity\Band |
|
App\Band\Entity\BandInvite | No errors. |
App\Band\Entity\BandArtist | No errors. |
App\User\Entity\ArtistUserTranslation | No errors. |
App\Event\Entity\EventContact |
|
App\Core\Entity\Genre | No errors. |
App\Event\Entity\EventBand | No errors. |
App\Event\Entity\EventManager | No errors. |
App\Event\Entity\EventInvite | No errors. |
App\Event\Entity\EventSplit | No errors. |
App\Event\Entity\EventPartner | No errors. |
App\Event\Entity\EventHall | No errors. |
App\Event\Entity\EventZone | No errors. |
App\Event\Entity\EventPrice | No errors. |
App\Payment\Entity\UserPayment | No errors. |
App\Review\Entity\Review | No errors. |
App\Event\Entity\EventTicketType | No errors. |
App\Event\Entity\EventTranslation | No errors. |