https://integral.dirmov.mil.ec/reservistas/verifica/identidad/1753759040?p=reservistas%2Fverifica%2Fidentidad%2F1753759040

Query Metrics

15 Database Queries
8 Different statements
57.74 ms Query time
1 Invalid entities

Grouped Statements

Show all queries

Time Count Info
26.63 ms
(46.12%)
3
SELECT t0.id AS id_1, t0.identificacion AS identificacion_2, t0.nombres AS nombres_3, t0.apellido_paterno AS apellido_paterno_4, t0.apellido_materno AS apellido_materno_5, t0.telefono AS telefono_6, t0.telefono_emergencias AS telefono_emergencias_7, t0.email AS email_8, t0.fecha_registro AS fecha_registro_9, t0.fecha_nacimiento AS fecha_nacimiento_10, t0.sexo AS sexo_11, t0.estado_civil AS estado_civil_12, t0.estatura AS estatura_13, t0.edad AS edad_14, t0.lugar_string AS lugar_string_15, t0.edad_string AS edad_string_16, t0.pais_nacimiento AS pais_nacimiento_17, t0.foto_cedula AS foto_cedula_18, t0.instruccion AS instruccion_19, t0.localizacion_nacimiento AS localizacion_nacimiento_20, t0.foto AS foto_21, t0.certif_covid AS certif_covid_22, t0.grado AS grado_23, t0.fuerza AS fuerza_24, t0.arma AS arma_25 FROM reservistas t0 WHERE t0.identificacion = ? LIMIT 1
Parameters:
[
  "1753759040"
]
13.99 ms
(24.22%)
1
"COMMIT"
Parameters:
[]
6.46 ms
(11.19%)
1
SELECT n0_.id AS id_0, n0_.valor AS valor_1, n0_.nivel_localizacion AS nivel_localizacion_2, n0_.padre AS padre_3 FROM nmcl_dominio_localizacion n0_ LEFT JOIN nmcl_nivel_localizacion n1_ ON n0_.nivel_localizacion = n1_.id LEFT JOIN nmcl_localizacion n2_ ON n1_.localizacion = n2_.id LEFT JOIN nmcl_dominio_localizacion n3_ ON n0_.padre = n3_.id WHERE n2_.id = 1 AND n1_.nivel = 4 AND UPPER(n0_.valor) = ? AND UPPER(n3_.valor) = ?
Parameters:
[
  "CHIMBACALLE"
  "QUITO"
]
3.82 ms
(6.62%)
3
SELECT p0_.id AS id_0, p0_.fecha_inicio_registro AS fecha_inicio_registro_1, p0_.fecha_fin_registro AS fecha_fin_registro_2, p0_.anno_desde AS anno_desde_3, p0_.anno_hasta AS anno_hasta_4, p0_.activo AS activo_5 FROM proceso_registro_reservistas p0_ WHERE p0_.activo = true
Parameters:
[]
2.50 ms
(4.33%)
3
SELECT t0.id AS id_1, t0.valor AS valor_2, t0.nivel_localizacion AS nivel_localizacion_3, t0.padre AS padre_4 FROM nmcl_dominio_localizacion t0 WHERE t0.id = ?
Parameters:
[
  229
]
2.47 ms
(4.28%)
2
SELECT t0.id AS id_1, t0.fecha_registro AS fecha_registro_2, t0.pais_residencia AS pais_residencia_3, t0.calle_principal_residencia AS calle_principal_residencia_4, t0.calle_secundaria_residencia AS calle_secundaria_residencia_5, t0.num_casa AS num_casa_6, t0.referencias AS referencias_7, t0.geometria AS geometria_8, t0.fecha_consulta_antecedentes AS fecha_consulta_antecedentes_9, t0.resultados_antecedentes AS resultados_antecedentes_10, t0.fecha_consulta_estudios AS fecha_consulta_estudios_11, t0.resultados_estudios AS resultados_estudios_12, t0.idoneo AS idoneo_13, t0.fecha_resultado AS fecha_resultado_14, t0.causa_rechazo AS causa_rechazo_15, t0.observaciones AS observaciones_16, t0.volver_presentarse AS volver_presentarse_17, t0.fecha_baja AS fecha_baja_18, t0.certificado_vacunacion_ok AS certificado_vacunacion_ok_19, t0.disponibilidad AS disponibilidad_20, t0.actividad AS actividad_21, t0.error_registro AS error_registro_22, t0.proceso AS proceso_23, t0.reservista AS reservista_24, t0.localizacion_residencia AS localizacion_residencia_25, t0.centro_movilizacion AS centro_movilizacion_26 FROM reservista_proceso t0 WHERE t0.reservista = ? AND t0.proceso = ? LIMIT 1
Parameters:
[
  12896
  7
]
1.24 ms
(2.14%)
1
UPDATE reservistas SET edad = ? WHERE id = ?
Parameters:
[
  "21"
  12896
]
0.63 ms
(1.09%)
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\ProcesoRegistroReservistas No errors.
App\Entity\Reservista
  • The association App\Entity\Reservista#procesos refers to the owning side field App\Entity\ProcesoRegistroReservistas#reservista which does not exist.
App\Entity\NmclDominioLocalizacion No errors.
App\Entity\Adjunto No errors.
App\Entity\NmclGrado No errors.
App\Entity\NmclFuerza No errors.
App\Entity\NmclArma No errors.
App\Entity\ReservistaProceso No errors.
App\Entity\CentroMovilizacion No errors.
App\Entity\NmclNivelLocalizacion No errors.
App\Entity\NmclLocalizacion No errors.