Query Metrics
16
Database Queries
12
Different statements
66.57 ms
Query time
1
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
42.73 ms (64.19%) |
3 |
"COMMIT"
Parameters:
[] |
9.43 ms (14.17%) |
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:
[
"2100420070"
]
|
2.29 ms (3.44%) |
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:
[ 24369 "2100420070" " FLORES CORDERO MARCO ANTONIO" null "0994373483" null "mariaisabelflores1903@gmail.com" null "2025-01-16 08:09:36" null null null 0 null 0 1 0 null null null null 199405 null null null null ] |
2.23 ms (3.36%) |
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:
[
"2100420070"
]
|
1.45 ms (2.18%) |
1 |
SELECT NEXTVAL('seg_codigos_activacion_id_seq')
Parameters:
[] |
1.43 ms (2.15%) |
1 |
SELECT NEXTVAL('seg_usuario_id_seq')
Parameters:
[] |
1.38 ms (2.07%) |
3 |
"START TRANSACTION"
Parameters:
[] |
1.33 ms (2.00%) |
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.30 ms (1.95%) |
1 |
INSERT INTO seg_usuario_rol (usuario, rol) VALUES (?, ?)
Parameters:
[ 24369 12 ] |
1.19 ms (1.79%) |
1 |
UPDATE reservistas SET telefono = ?, telefono_emergencias = ?, email = ?, estatura = ? WHERE id = ?
Parameters:
[ "0994373483" "0994373483" "mariaisabelflores1903@gmail.com" "1.65" 52495 ] |
0.92 ms (1.39%) |
1 |
INSERT INTO seg_codigos_activacion (id, codigo, fecha_envio, fecha_vigencia, fecha_uso, usuario) VALUES (?, ?, ?, ?, ?, ?)
Parameters:
[ 29413 "87b7b5457ba85ab052e032f42a1a96bc" "2025-01-16 08:09:36" null null 24369 ] |
0.88 ms (1.33%) |
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 |
|
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. |