Query Metrics
2
Database Queries
2
Different statements
2.58 ms
Query time
0
Invalid entities
1
Managed entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
1.90 ms (73.72%) |
1 |
SELECT u0_.username AS username_0, u0_.email AS email_1, u0_.password AS password_2, u0_.firstname AS firstname_3, u0_.lastname AS lastname_4, u0_.gender AS gender_5, u0_.birthdate AS birthdate_6, u0_.origin_place AS origin_place_7, u0_.phone AS phone_8, u0_.phone_alternate AS phone_alternate_9, u0_.telegram_chat_id AS telegram_chat_id_10, u0_.avatar_name AS avatar_name_11, u0_.fonction AS fonction_12, u0_.roles AS roles_13, u0_.privileges AS privileges_14, u0_.locale AS locale_15, u0_.timezone AS timezone_16, u0_.authenticator_name AS authenticator_name_17, u0_.authenticator_user_id AS authenticator_user_id_18, u0_.confirmation_token AS confirmation_token_19, u0_.newsletter_subscribed AS newsletter_subscribed_20, u0_.observation AS observation_21, u0_.motorcycles AS motorcycles_22, u0_.password_updated_at AS password_updated_at_23, u0_.must_change_password AS must_change_password_24, u0_.logged_in_at AS logged_in_at_25, u0_.bad_customer AS bad_customer_26, u0_.disabled AS disabled_27, u0_.id AS id_28, u0_.created_at AS created_at_29, u0_.updated_at AS updated_at_30, u0_.deleted_at AS deleted_at_31, u0_.creator_id AS creator_id_32, u0_.modifier_id AS modifier_id_33, u0_.e_shop_id AS e_shop_id_34, a1_.id AS id_35, a1_.name AS name_36, a1_.type AS type_37, a1_.email AS email_38, a1_.phone AS phone_39, a1_.phone_alternate AS phone_alternate_40, a1_.url AS url_41, a1_.image AS image_42, a1_.locale AS locale_43, a1_.timezone AS timezone_44, a1_.observation AS observation_45, a1_.bad_customer AS bad_customer_46, a1_.disabled AS disabled_47, a1_.created_at AS created_at_48, a1_.updated_at AS updated_at_49, a1_.deleted_at AS deleted_at_50, a1_.creator_id AS creator_id_51, a1_.modifier_id AS modifier_id_52, u2_.id AS id_53, u2_.name AS name_54, u2_.description AS description_55, u2_.disabled AS disabled_56, u2_.created_at AS created_at_57, u2_.updated_at AS updated_at_58, u2_.deleted_at AS deleted_at_59, u2_.creator_id AS creator_id_60, u2_.modifier_id AS modifier_id_61, u2_.e_shop_id AS e_shop_id_62, t3_.name AS name_63, t3_.text_color AS text_color_64, t3_.background_color AS background_color_65, t3_.icon AS icon_66, t3_.id AS id_67, t3_.created_at AS created_at_68, t3_.updated_at AS updated_at_69, t3_.deleted_at AS deleted_at_70, t3_.creator_id AS creator_id_71, t3_.modifier_id AS modifier_id_72, u0_.account_id AS account_id_73, a1_.address_invoice_id AS address_invoice_id_74, a1_.address_delivery_id AS address_delivery_id_75 FROM `user` u0_ LEFT JOIN account a1_ ON u0_.account_id = a1_.id AND (a1_.deleted_at IS NULL) LEFT JOIN user_user_group u4_ ON u0_.id = u4_.user_id LEFT JOIN user_group u2_ ON u2_.id = u4_.user_group_id AND (u2_.deleted_at IS NULL) LEFT JOIN user_tag u5_ ON u0_.id = u5_.user_id LEFT JOIN tag t3_ ON t3_.id = u5_.tag_id AND (t3_.deleted_at IS NULL) WHERE (u0_.id = ?) AND (u0_.deleted_at IS NULL) ORDER BY u0_.lastname ASC, u0_.firstname ASC, u2_.name ASC
Parameters:
[
1
]
|
0.68 ms (26.28%) |
1 |
SELECT n0_.id AS id_0, n0_.date AS date_1, n0_.subject AS subject_2, n0_.content AS content_3, n0_.unread AS unread_4, n0_.user_id AS user_id_5 FROM notification n0_ WHERE n0_.user_id = ? ORDER BY n0_.date DESC
Parameters:
[
1
]
|
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.
Managed Entities
default entity manager
Class | Amount of managed objects |
---|---|
App\Entity\User | 1 |
Entities Mapping
Class | Mapping errors |
---|---|
App\Entity\User | No errors. |
App\Entity\Account | No errors. |
App\Entity\UserGroup | No errors. |
App\Entity\Tag | No errors. |
App\Entity\Address | No errors. |
App\Entity\UserDrivingLicense | No errors. |
App\Entity\Motorcycle | No errors. |
App\Entity\Signature | No errors. |
App\Entity\Order | No errors. |
App\Entity\OrderHistory | No errors. |
App\Entity\Voucher | No errors. |
App\Entity\Quote | No errors. |
App\Entity\Invoice | No errors. |
App\Entity\Deposit | No errors. |
App\Entity\CreditorInvoice | No errors. |
App\Entity\DeliveryNote | No errors. |
App\Entity\ServiceRecord | No errors. |
App\Entity\Sale | No errors. |
App\Entity\Buyback | No errors. |
App\Entity\Leasing | No errors. |
App\Entity\OverWintering | No errors. |
App\Entity\Rental | No errors. |
App\Entity\TestRideRequest | No errors. |
App\Entity\TestRide | No errors. |
App\Entity\Email | No errors. |
App\Entity\Notification | No errors. |