Query Metrics
6
Database Queries
6
Different statements
10.28 ms
Query time
5
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
3.37 ms (32.80%) |
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_.slug = ? OR e0_.hash = ?) AND (e0_.deleted_at IS NULL)
Parameters:
[ "letnij-vajb-28-august-2024-lissabon-portugal" "letnij-vajb-28-august-2024-lissabon-portugal" ] |
2.04 ms (19.82%) |
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:
[
120
]
|
1.96 ms (19.08%) |
1 |
SELECT l0_.id AS id_0, l0_.name AS name_1, l0_.address AS address_2, l0_.type AS type_3, l0_.places AS places_4, l0_.with_kitchen AS with_kitchen_5, l0_.with_bar AS with_bar_6, l0_.active AS active_7, l0_.social AS social_8, l0_.created_at AS created_at_9, l0_.confirm_code AS confirm_code_10, l0_.confirmed AS confirmed_11, l0_.slug AS slug_12, l0_.post_code AS post_code_13, l0_.coords AS coords_14, l0_.deleted_at AS deleted_at_15, l0_.moderation_status AS moderation_status_16, l0_.hash AS hash_17, l0_.cover_id AS cover_id_18, l0_.user_id AS user_id_19, l0_.country_id AS country_id_20, l0_.city_id AS city_id_21, l0_.gallery_id AS gallery_id_22, l0_.video_gallery_id AS video_gallery_id_23 FROM location l0_ WHERE (l0_.slug = ?) AND (l0_.deleted_at IS NULL)
Parameters:
[
"letnij-vajb-28-august-2024-lissabon-portugal"
]
|
1.41 ms (13.74%) |
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"
]
|
0.83 ms (8.09%) |
1 |
SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.type AS type_2, b0_.age_restrictions AS age_restrictions_3, b0_.social AS social_4, b0_.can_invite AS can_invite_5, b0_.can_invite_private AS can_invite_private_6, b0_.confirmed AS confirmed_7, b0_.active AS active_8, b0_.created_at AS created_at_9, b0_.confirm_code AS confirm_code_10, b0_.favorites_count AS favorites_count_11, b0_.slug AS slug_12, b0_.deleted_at AS deleted_at_13, b0_.moderation_status AS moderation_status_14, b0_.hash AS hash_15, b0_.name_image_id AS name_image_id_16, b0_.country_id AS country_id_17, b0_.city_id AS city_id_18, b0_.label_id AS label_id_19, b0_.admin_id AS admin_id_20, b0_.cover_id AS cover_id_21, b0_.gallery_id AS gallery_id_22, b0_.video_gallery_id AS video_gallery_id_23 FROM band b0_ WHERE (b0_.slug = ?) AND (b0_.deleted_at IS NULL)
Parameters:
[
"letnij-vajb-28-august-2024-lissabon-portugal"
]
|
0.66 ms (6.46%) |
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:
[
"letnij-vajb-28-august-2024-lissabon-portugal"
]
|
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\Band\Entity\Band |
|
App\Storage\Entity\File | No errors. |
App\Storage\Entity\Image | No errors. |
App\User\Entity\User | No errors. |
App\User\Entity\LabelUser | No errors. |
App\Storage\Entity\Gallery |
|
App\Location\Entity\Location | No errors. |
App\User\Entity\LocationUser | No errors. |
App\Event\Entity\Event |
|
App\User\Entity\SystemUser | No errors. |
App\User\Entity\NewUser | No errors. |
App\User\Entity\ArtistUser | No errors. |
App\User\Entity\ManagerUser | No errors. |
App\User\Entity\OrganizerUser | No errors. |
App\User\Entity\UserRequisite | No errors. |
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. |