Query Metrics
5
Database Queries
2
Different statements
6.25 ms
Query time
0
Invalid entities
9
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.89 ms |
SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.role AS role_2, u0_.created_at AS created_at_3, u0_.updated_at AS updated_at_4, u0_.created_by AS created_by_5, u0_.updated_by AS updated_by_6 FROM user_role u0_ WHERE u0_.role IN (?, ?, ?, ?)
Parameters:
[ "ROLE_RELEASE" "ROLE_SORTING" "ROLE_REGISTRATION" "ROLE_RECEPTION" ] |
| 2 | 0.43 ms |
SELECT t0.id AS id_1, t0.permissions AS permissions_2, t0.role_id AS role_id_3 FROM role_permission t0 WHERE t0.role_id = ?
Parameters:
[
5
]
|
| 3 | 0.67 ms |
SELECT t0.id AS id_1, t0.permissions AS permissions_2, t0.role_id AS role_id_3 FROM role_permission t0 WHERE t0.role_id = ?
Parameters:
[
8
]
|
| 4 | 3.56 ms |
SELECT t0.id AS id_1, t0.permissions AS permissions_2, t0.role_id AS role_id_3 FROM role_permission t0 WHERE t0.role_id = ?
Parameters:
[
10
]
|
| 5 | 0.70 ms |
SELECT t0.id AS id_1, t0.permissions AS permissions_2, t0.role_id AS role_id_3 FROM role_permission t0 WHERE t0.role_id = ?
Parameters:
[
9
]
|
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\UserRole | 4 |
| App\Entity\RolePermission | 4 |
| App\Entity\User | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\UserRole | No errors. |
| App\Entity\User | No errors. |
| App\Entity\RolePermission | No errors. |