Query Metrics
5
Database Queries
5
Different statements
4.56 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
1.33 ms (29.12%) |
1 |
SELECT COUNT(DISTINCT u0_.id) AS sclr_0 FROM user u0_ LEFT JOIN user_region u2_ ON u0_.id = u2_.user_id LEFT JOIN region r1_ ON r1_.id = u2_.region_id WHERE u0_.id <> ?
Parameters:
[
150
]
|
1.27 ms (27.95%) |
1 |
SELECT DISTINCT u0_.id AS id_0, u0_.id AS id_1 FROM user u0_ LEFT JOIN user_region u2_ ON u0_.id = u2_.user_id LEFT JOIN region r1_ ON r1_.id = u2_.region_id WHERE u0_.id <> ? ORDER BY u0_.id ASC LIMIT 10
Parameters:
[
150
]
|
0.82 ms (17.95%) |
1 |
SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.nombres AS nombres_4, u0_.activo AS activo_5, u0_.super_admin AS super_admin_6, r1_.id AS id_7, r1_.nombre AS nombre_8, r1_.orden AS orden_9, u0_.region_id AS region_id_10 FROM user u0_ LEFT JOIN user_region u2_ ON u0_.id = u2_.user_id LEFT JOIN region r1_ ON r1_.id = u2_.region_id WHERE u0_.id <> ? AND u0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY u0_.id ASC
Parameters:
[ 150 1 2 3 4 5 6 7 8 9 10 ] |
0.66 ms (14.50%) |
1 |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.nombres AS nombres_5, t0.activo AS activo_6, t0.super_admin AS super_admin_7, t0.region_id AS region_id_8 FROM user t0 WHERE t0.id = ?
Parameters:
[
150
]
|
0.48 ms (10.47%) |
1 |
SELECT r0_.id AS id_0, r0_.nombre AS nombre_1, r0_.orden AS orden_2 FROM region r0_ ORDER BY r0_.orden ASC
Parameters:
[] |
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 | No errors. |
App\Entity\Region | No errors. |