Query Metrics
6
Database Queries
5
Different statements
6.11 ms
Query time
7
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 0.73 ms |
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"
]
|
2 | 0.83 ms |
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:
[
"robots.txt"
]
|
3 | 1.00 ms |
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:
[
"robots.txt"
]
|
4 | 1.04 ms |
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:
[
"robots.txt"
]
|
5 | 1.60 ms |
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:
[ "robots.txt" "robots.txt" ] |
6 | 0.91 ms |
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\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\Geo\Entity\CityTranslation | No errors. |
App\Geo\Entity\CountryRequisiteTranslation | No errors. |
App\Core\Entity\Genre | No errors. |
App\Band\Entity\Album | No errors. |
App\Band\Entity\BandDocument | No errors. |
App\Band\Entity\BandAccessRestriction | No errors. |
App\Band\Entity\BandInvite | No errors. |
App\Band\Entity\BandContact | No errors. |
App\Band\Entity\BandArtist | No errors. |
App\Band\Entity\BandTranslation | No errors. |
App\User\Entity\UserRequisite | No errors. |
App\User\Entity\LabelUserTranslation | No errors. |
App\Storage\Entity\GalleryMedia |
|
App\Location\Entity\LocationContact | No errors. |
App\Location\Entity\Hall |
|
App\Location\Entity\LocationEquipment | No errors. |
App\Location\Entity\LocationStaff | No errors. |
App\Location\Entity\LocationParking | No errors. |
App\Location\Entity\LocationEventType | No errors. |
App\Location\Entity\LocationTranslation | No errors. |
App\Event\Entity\EventContact |
|
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. |