Query Metrics
7
Database Queries
7
Different statements
44.29 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 4.12 ms |
SELECT t0.id AS id_1, t0.password AS password_2, t0.email AS email_3, t0.nombre AS nombre_4, t0.apellidos AS apellidos_5, t0.permisos AS permisos_6, t0.fecha_creacion AS fecha_creacion_7, t0.usuario_creo AS usuario_creo_8, t0.fecha_actualizacion AS fecha_actualizacion_9, t0.usuario_actualizo AS usuario_actualizo_10, t0.ultima_conexion AS ultima_conexion_11 FROM "user" t0 WHERE t0.email = ? LIMIT 1
Parameters:
[
"oscar.bernabe.cortez@gmail.com"
]
|
| 2 | 3.81 ms |
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.descripcion AS descripcion_3, t0.roles AS roles_4 FROM grupo t0 INNER JOIN user_grupo ON t0.id = user_grupo.grupo_id WHERE user_grupo.user_id = ?
Parameters:
[
9
]
|
| 3 | 13.96 ms |
SELECT NEXTVAL('bitacora_id_seq')
Parameters:
[] |
| 4 | 0.60 ms |
"START TRANSACTION"
Parameters:
[] |
| 5 | 16.29 ms |
INSERT INTO bitacora (id, entidad, fecha_movimiento, cambio, accion, observaciones, usuario, ip, entidad_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 2120 "App\Entity\Main\User" "2025-12-08 11:00:04" "{"ultimaConexion":{"anterior":"2025-11-19 05:06:32","actual":"2025-12-08 11:00:04"}}" "ACTUALIZACIÓN" null 9 "10.51.250.118" 9 ] |
| 6 | 1.45 ms |
UPDATE "user" SET ultima_conexion = ?, fecha_actualizacion = ? WHERE id = ?
Parameters:
[ "2025-12-08 11:00:04" "2025-12-08 11:00:04" 9 ] |
| 7 | 4.06 ms |
"COMMIT"
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\Main\User | No errors. |
| App\Entity\Main\Grupo | No errors. |
| App\Entity\Main\Bitacora | No errors. |