Query Metrics
24
Database Queries
12
Different statements
6.64 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 0.55 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.nombre AS nombre_3, t0.apellidos AS apellidos_4, t0.roles AS roles_5, t0.password AS password_6 FROM user t0 WHERE t0.email = ? LIMIT 1
Parameters:
[
"admin@arsinnovatio.com"
]
|
2 | 0.35 ms |
SELECT t0.id AS id_1, t0.codigo AS codigo_2, t0.fecha_creacion AS fecha_creacion_3, t0.fecha_update AS fecha_update_4, t0.incidente_id AS incidente_id_5, t0.inicial_id AS inicial_id_6, t0.start_id AS start_id_7, t0.meta_id AS meta_id_8, t0.evacuacion_id AS evacuacion_id_9 FROM afectado t0 WHERE t0.id = ?
Parameters:
[
"72"
]
|
3 | 0.34 ms |
SELECT t0.id AS id_1, t0.fecha_creacion AS fecha_creacion_2, t0.fecha_update AS fecha_update_3, t0.tiempos AS tiempos_4, t0.valoracion AS valoracion_5, t0.afectado_id AS afectado_id_6, t0.evaluacion_id AS evaluacion_id_7 FROM evaluacion_meta t0 WHERE t0.afectado_id = ? AND t0.evaluacion_id = ?
Parameters:
[ "72" "203" ] |
4 | 0.41 ms |
SELECT t0.id AS id_1, t0.tipo AS tipo_2, t3.id AS id_4, t3.fecha_creacion AS fecha_creacion_5, t3.fecha_update AS fecha_update_6, t3.tiempos AS tiempos_7, t3.valoracion AS valoracion_8, t3.afectado_id AS afectado_id_9, t3.evaluacion_id AS evaluacion_id_10, t11.id AS id_12, t11.fecha_creacion AS fecha_creacion_13, t11.fecha_update AS fecha_update_14, t11.tiempos AS tiempos_15, t11.valoracion AS valoracion_16, t11.afectado_id AS afectado_id_17, t11.evaluacion_id AS evaluacion_id_18, t19.id AS id_20, t19.fecha_creacion AS fecha_creacion_21, t19.fecha_update AS fecha_update_22, t19.tiempos AS tiempos_23, t19.valoracion AS valoracion_24, t19.afectado_id AS afectado_id_25, t19.evaluacion_id AS evaluacion_id_26, t27.id AS id_28, t27.fecha_creacion AS fecha_creacion_29, t27.fecha_update AS fecha_update_30, t27.tiempos AS tiempos_31, t27.valoracion AS valoracion_32, t27.afectado_id AS afectado_id_33, t27.evaluacion_id AS evaluacion_id_34 FROM evaluacion t0 LEFT JOIN evaluacion_inicial t3 ON t3.evaluacion_id = t0.id LEFT JOIN evaluacion_start t11 ON t11.evaluacion_id = t0.id LEFT JOIN evaluacion_meta t19 ON t19.evaluacion_id = t0.id LEFT JOIN evaluacion_evacuacion t27 ON t27.evaluacion_id = t0.id WHERE t0.id = ?
Parameters:
[
203
]
|
5 | 0.28 ms |
SELECT t0.id AS id_1, t0.propiedades AS propiedades_2, t0.pregunta_id AS pregunta_id_3, t0.evaluacion_id AS evaluacion_id_4 FROM respuesta t0 WHERE t0.evaluacion_id = ?
Parameters:
[
203
]
|
6 | 0.15 ms |
"START TRANSACTION"
Parameters:
[] |
7 | 0.23 ms |
UPDATE afectado SET meta_id = ? WHERE id = ?
Parameters:
[ null 72 ] |
8 | 0.17 ms |
DELETE FROM evaluacion_meta WHERE id = ?
Parameters:
[
26
]
|
9 | 1.20 ms |
DELETE FROM respuesta WHERE id = ?
Parameters:
[
937
]
|
10 | 0.17 ms |
DELETE FROM respuesta WHERE id = ?
Parameters:
[
938
]
|
11 | 0.16 ms |
DELETE FROM respuesta WHERE id = ?
Parameters:
[
939
]
|
12 | 0.14 ms |
DELETE FROM respuesta WHERE id = ?
Parameters:
[
940
]
|
13 | 0.15 ms |
DELETE FROM respuesta WHERE id = ?
Parameters:
[
941
]
|
14 | 0.18 ms |
DELETE FROM respuesta WHERE id = ?
Parameters:
[
942
]
|
15 | 0.12 ms |
DELETE FROM respuesta WHERE id = ?
Parameters:
[
943
]
|
16 | 0.10 ms |
DELETE FROM respuesta WHERE id = ?
Parameters:
[
944
]
|
17 | 0.10 ms |
DELETE FROM respuesta WHERE id = ?
Parameters:
[
945
]
|
18 | 0.09 ms |
DELETE FROM respuesta WHERE id = ?
Parameters:
[
946
]
|
19 | 0.12 ms |
DELETE FROM respuesta WHERE id = ?
Parameters:
[
947
]
|
20 | 0.09 ms |
DELETE FROM respuesta WHERE id = ?
Parameters:
[
948
]
|
21 | 0.66 ms |
DELETE FROM respuesta WHERE id = ?
Parameters:
[
949
]
|
22 | 0.23 ms |
DELETE FROM evaluacion WHERE id = ?
Parameters:
[
203
]
|
23 | 0.42 ms |
"COMMIT"
Parameters:
[] |
24 | 0.23 ms |
SELECT t0.id AS id_1, t0.codigo AS codigo_2, t0.ubicacion AS ubicacion_3, t0.tipo AS tipo_4, t0.gravedad AS gravedad_5, t0.descripcion AS descripcion_6, t0.fecha_creacion AS fecha_creacion_7, t0.fecha_update AS fecha_update_8, t0.afectado_id AS afectado_id_9 FROM herida t0 WHERE t0.afectado_id = ? ORDER BY t0.id DESC
Parameters:
[
72
]
|
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\Afectado | No errors. |
App\Entity\Incidente | No errors. |
App\Entity\EvaluacionInicial | No errors. |
App\Entity\EvaluacionStart | No errors. |
App\Entity\EvaluacionMeta | No errors. |
App\Entity\EvaluacionEvacuacion | No errors. |
App\Entity\Herida | No errors. |
App\Entity\Evaluacion | No errors. |
App\Entity\Respuesta | No errors. |
App\Entity\Pregunta | No errors. |
App\Entity\Bloque | No errors. |
App\Entity\Triage | No errors. |