POST https://webapp-dev.swisskustomfaktory.ch/admin/notifications

Query Metrics

2 Database Queries
2 Different statements
2.58 ms Query time
0 Invalid entities
1 Managed entities

Grouped Statements

Show all queries

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