https://innovatio.iuii.ua.es/emergencias/api/v1/afectados/72/evaluacion/203/tipo/meta Return to referer URL

Query Metrics

24 Database Queries
12 Different statements
6.64 ms Query time
0 Invalid entities

Queries

Group similar statements

# 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.