Query Metrics
24
Database Queries
12
Different statements
6.64 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
3.28 ms (49.41%) |
13 |
DELETE FROM respuesta WHERE id = ?
Parameters:
[
937
]
|
0.55 ms (8.25%) |
1 |
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"
]
|
0.42 ms (6.28%) |
1 |
"COMMIT"
Parameters:
[] |
0.41 ms (6.19%) |
1 |
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
]
|
0.35 ms (5.27%) |
1 |
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"
]
|
0.34 ms (5.11%) |
1 |
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" ] |
0.28 ms (4.16%) |
1 |
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
]
|
0.23 ms (3.51%) |
1 |
UPDATE afectado SET meta_id = ? WHERE id = ?
Parameters:
[ null 72 ] |
0.23 ms (3.51%) |
1 |
DELETE FROM evaluacion WHERE id = ?
Parameters:
[
203
]
|
0.23 ms (3.47%) |
1 |
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
]
|
0.17 ms (2.64%) |
1 |
DELETE FROM evaluacion_meta WHERE id = ?
Parameters:
[
26
]
|
0.15 ms (2.22%) |
1 |
"START TRANSACTION"
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\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. |