https://integral.dirmov.mil.ec/index.php/

Query Metrics

5 Database Queries
5 Different statements
19.00 ms Query time
1 Invalid entities

Queries

Group similar statements

# Time Info
1 3.97 ms
SELECT t0.id AS id_1, t0.username AS username_2, t0.nombres AS nombres_3, t0.apellidos AS apellidos_4, t0.telefono AS telefono_5, t0.celular AS celular_6, t0.email AS email_7, t0.direccion AS direccion_8, t0.fecha_registro AS fecha_registro_9, t0.fecha_vigencia_password AS fecha_vigencia_password_10, t0.causa_bloqueo AS causa_bloqueo_11, t0.password AS password_12, t0.eliminado AS eliminado_13, t0.fecha_eliminacion AS fecha_eliminacion_14, t0.intentos_fallidos AS intentos_fallidos_15, t0.primer_ingreso AS primer_ingreso_16, t0.activo AS activo_17, t0.conectado AS conectado_18, t0.fecha_acceso AS fecha_acceso_19, t0.cargo AS cargo_20, t0.grado AS grado_21, t0.foto AS foto_22, t0.base AS base_23, t0.centro AS centro_24, t0.unidad AS unidad_25, t0.centro_instruccion AS centro_instruccion_26 FROM seg_usuario t0 WHERE t0.id = ?
Parameters:
[
  8352
]
2 2.39 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.sistema AS sistema_3, t0.descripcion AS descripcion_4, t0.asignable AS asignable_5 FROM seg_rol t0 INNER JOIN seg_usuario_rol ON t0.id = seg_usuario_rol.rol WHERE seg_usuario_rol.usuario = ?
Parameters:
[
  8352
]
3 1.01 ms
SELECT t0.id AS id_1, t0.fecha_inicio_registro AS fecha_inicio_registro_2, t0.fecha_fin_registro AS fecha_fin_registro_3, t0.anno_desde AS anno_desde_4, t0.anno_hasta AS anno_hasta_5, t0.activo AS activo_6 FROM proceso_registro_reservistas t0 WHERE t0.activo = ? LIMIT 1
Parameters:
[
  1
]
4 9.87 ms
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:
[
  "2100727680"
]
5 1.76 ms
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.proceso = ? AND t0.reservista = ? LIMIT 1
Parameters:
[
  7
  3301
]

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\SeguridadUsuario No errors.
App\Entity\NmclCargo No errors.
App\Entity\NmclGrado No errors.
App\Entity\Adjunto No errors.
App\Entity\BaseMovilizacion No errors.
App\Entity\CentroMovilizacion No errors.
App\Entity\UnidadMilitar No errors.
App\Entity\CentroInstruccion No errors.
App\Entity\SeguridadRol No errors.
App\Entity\Notificacion No 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\NmclFuerza No errors.
App\Entity\NmclArma No errors.
App\Entity\ReservistaProceso No errors.