https://test-api.komkom.com.ua/api/users/39

Query Metrics

5 Database Queries
5 Different statements
130.56 ms Query time
1 Invalid entities

Queries

Group similar statements

default connection

# Time Info
1 26.54 ms
SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.phone AS phone_7, t0.address AS address_8, t0.status AS status_9, t0.email AS email_10, t0.work_schedule AS work_schedule_11, t0.telegram AS telegram_12, t0.viber AS viber_13, t0.hash_date AS hash_date_14, t0.device_id AS device_id_15, t0.active_code AS active_code_16, t0.deleted AS deleted_17, t0.debug AS debug_18, t0.dev AS dev_19, t0.date_entered AS date_entered_20, t0.notification_status AS notification_status_21, t0.email_status AS email_status_22, t0.os_type AS os_type_23, t0.manager_id AS manager_id_24 FROM users t0 WHERE t0.username = ? LIMIT 1
Parameters:
[
  "+380975868117"
]
2 25.83 ms
SELECT t0.id AS id_1, t0.users_id AS users_id_2, t0.role_id AS role_id_3 FROM user_role t0 WHERE t0.users_id = ?
Parameters:
[
  39
]
3 25.78 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.label AS label_3, t0.description AS description_4, t0.login_admin_panel AS login_admin_panel_5 FROM role t0 WHERE t0.id = ?
Parameters:
[
  5
]
4 26.42 ms
SELECT u0_.id AS id_0, u0_.username AS username_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.first_name AS first_name_4, u0_.last_name AS last_name_5, u0_.phone AS phone_6, u0_.address AS address_7, u0_.status AS status_8, u0_.email AS email_9, u0_.work_schedule AS work_schedule_10, u0_.telegram AS telegram_11, u0_.viber AS viber_12, u0_.hash_date AS hash_date_13, u0_.device_id AS device_id_14, u0_.active_code AS active_code_15, u0_.deleted AS deleted_16, u0_.debug AS debug_17, u0_.dev AS dev_18, u0_.date_entered AS date_entered_19, u0_.notification_status AS notification_status_20, u0_.email_status AS email_status_21, u0_.os_type AS os_type_22, m1_.id AS id_23, m1_.file_path AS file_path_24, m1_.type AS type_25, m1_.name AS name_26, m1_.upload_timestamp AS upload_timestamp_27, u2_.id AS id_28, u0_.manager_id AS manager_id_29, m1_.users_id AS users_id_30, u2_.users_id AS users_id_31, u2_.role_id AS role_id_32 FROM users u0_ LEFT JOIN media_object m1_ ON u0_.id = m1_.users_id LEFT JOIN user_role u2_ ON u0_.id = u2_.users_id WHERE u0_.id = ?
Parameters:
[
  39
]
5 26.00 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3 FROM menu t0 INNER JOIN menu_role ON t0.id = menu_role.menu_id WHERE menu_role.role_id = ?
Parameters:
[
  5
]

Database Connections

Name Service
default doctrine.dbal.default_connection
loe doctrine.dbal.loe_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager
loe doctrine.orm.loe_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

default entity manager

Class Mapping errors
App\Entity\User
  • The association App\Entity\User#manager refers to the inverse side field App\Entity\User#firstName which is not defined as association.
  • The association App\Entity\User#manager refers to the inverse side field App\Entity\User#firstName which does not exist.
App\Entity\MediaObject No errors.
App\Entity\UserToken No errors.
App\Entity\AppPersonalAccount No errors.
App\Entity\Notification No errors.
App\Entity\MassiveNotification No errors.
App\Entity\UserRole No errors.
App\Entity\Role No errors.
App\Entity\Permission No errors.
App\Entity\Menu No errors.
App\Entity\MenuItems No errors.

loe entity manager

No loaded entities.