https://integral.dirmov.mil.ec/index.php/reservistas/salvar/reservista Return to referer URL

Query Metrics

16 Database Queries
12 Different statements
81.63 ms Query time
1 Invalid entities

Grouped Statements

Show all queries

Time Count Info
25.38 ms
(31.09%)
1
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.username = ? LIMIT 1
Parameters:
[
  "1401094717"
]
21.08 ms
(25.83%)
1
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:
[
  "1401094717"
]
14.20 ms
(17.40%)
3
"COMMIT"
Parameters:
[]
7.32 ms
(8.97%)
1
INSERT INTO seg_usuario_rol (usuario, rol) VALUES (?, ?)
Parameters:
[
  23294
  12
]
2.73 ms
(3.35%)
1
INSERT INTO seg_usuario (id, username, nombres, apellidos, telefono, celular, email, direccion, fecha_registro, fecha_vigencia_password, causa_bloqueo, password, eliminado, fecha_eliminacion, intentos_fallidos, primer_ingreso, activo, conectado, fecha_acceso, cargo, grado, foto, base, centro, unidad, centro_instruccion) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  23294
  "1401094717"
  "  JUANGA SHIMPIUKAT ANGEL ALBERTO"
  null
  "0989976850"
  null
  "angeljuanga@hotmail.com"
  null
  "2025-01-10 15:00:34"
  null
  null
  null
  0
  null
  0
  1
  0
  null
  null
  null
  null
  198241
  null
  null
  null
  null
]
2.10 ms
(2.57%)
1
SELECT NEXTVAL('seg_codigos_activacion_id_seq')
Parameters:
[]
1.99 ms
(2.44%)
1
SELECT NEXTVAL('seg_usuario_id_seq')
Parameters:
[]
1.52 ms
(1.87%)
3
"START TRANSACTION"
Parameters:
[]
1.50 ms
(1.83%)
1
UPDATE reservistas SET telefono = ?, telefono_emergencias = ?, email = ?, estatura = ? WHERE id = ?
Parameters:
[
  "0989976850"
  "0989976850"
  "angeljuanga@hotmail.com"
  "159"
  50855
]
1.44 ms
(1.77%)
1
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 WHERE t0.nombre = ? LIMIT 1
Parameters:
[
  "ROLE_RESERVISTA"
]
1.18 ms
(1.45%)
1
INSERT INTO seg_codigos_activacion (id, codigo, fecha_envio, fecha_vigencia, fecha_uso, usuario) VALUES (?, ?, ?, ?, ?, ?)
Parameters:
[
  28326
  "e8ed1152bec20c358ee1263c01435b96"
  "2025-01-10 15:00:34"
  null
  null
  23294
]
1.18 ms
(1.44%)
1
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.codigo_activacion AS codigo_activacion_3, t0.vigencia_codigo AS vigencia_codigo_4, t0.default_contrasena AS default_contrasena_5, t0.vigencia_contrasena AS vigencia_contrasena_6, t0.contrasenas_viejas AS contrasenas_viejas_7, t0.accesos_fallidos AS accesos_fallidos_8, t0.fortaleza_contrasena AS fortaleza_contrasena_9 FROM seg_configuracion t0 WHERE t0.nombre = ? LIMIT 1
Parameters:
[
  "DEFAULT"
]

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\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\ProcesoRegistroReservistas No errors.
App\Entity\NmclNivelLocalizacion No errors.
App\Entity\NmclLocalizacion No errors.
App\Entity\SeguridadUsuario No errors.
App\Entity\NmclCargo 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\SeguridadConfiguracion No errors.
App\Entity\SeguridadFortalezaContrasena No errors.
App\Entity\SeguridadCodigoActivacion No errors.