GET http://users-frontdwh-dev.icontextdev.ru/api/v1/user

Query Metrics

6 Database Queries
4 Different statements
12.14 ms Query time
1 Invalid entities

Queries

Group similar statements

# Time Info
1 2.16 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.updated_from_ldap_at AS updated_from_ldap_at_4, t0.using_ldap AS using_ldap_5, t0.ldap_cn AS ldap_cn_6, t0.active AS active_7 FROM "user" t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  "8"
]
2 4.88 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM permission_group t0 INNER JOIN user_permission_group ON t0.id = user_permission_group.permission_group_id WHERE user_permission_group.user_id = ?
Parameters:
[
  8
]
3 2.39 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.system AS system_3, t0.description AS description_4 FROM permission t0 INNER JOIN permission_group_permission ON t0.id = permission_group_permission.permission_id WHERE permission_group_permission.permission_group_id = ?
Parameters:
[
  4
]
4 0.57 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.system AS system_3, t0.description AS description_4 FROM permission t0 INNER JOIN permission_group_permission ON t0.id = permission_group_permission.permission_id WHERE permission_group_permission.permission_group_id = ?
Parameters:
[
  1
]
5 0.58 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.system AS system_3, t0.description AS description_4 FROM permission t0 INNER JOIN permission_group_permission ON t0.id = permission_group_permission.permission_id WHERE permission_group_permission.permission_group_id = ?
Parameters:
[
  5
]
6 1.56 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.system AS system_3, t0.description AS description_4 FROM permission t0 INNER JOIN user_permission ON t0.id = user_permission.permission_id WHERE user_permission.user_id = ?
Parameters:
[
  8
]

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\Entity\User
  • The association App\Entity\User#permissionGroups refers to the inverse side field App\Entity\PermissionGroup#users which does not exist.
App\Entity\PermissionGroup No errors.
App\Entity\Permission No errors.