Query Metrics
6
Database Queries
6
Different statements
26.45 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 11.44 ms |
SELECT t0.id AS id_1, t0.codigo AS codigo_2, t0.fecha_envio AS fecha_envio_3, t0.fecha_vigencia AS fecha_vigencia_4, t0.fecha_uso AS fecha_uso_5, t0.usuario AS usuario_6 FROM seg_codigos_activacion t0 WHERE t0.codigo = ? LIMIT 1
Parameters:
[
"10ef4c8618dce76273547852c5b86549"
]
|
2 | 2.80 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:
[
18475
]
|
3 | 0.86 ms |
"START TRANSACTION"
Parameters:
[] |
4 | 1.57 ms |
UPDATE seg_usuario SET intentos_fallidos = ? WHERE id = ?
Parameters:
[ 0 18475 ] |
5 | 0.77 ms |
UPDATE seg_codigos_activacion SET fecha_uso = ? WHERE id = ?
Parameters:
[ "2024-11-24 03:12:21" 18952 ] |
6 | 9.02 ms |
"COMMIT"
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\SeguridadCodigoActivacion | No 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\NmclDominioLocalizacion | No errors. |
App\Entity\NmclNivelLocalizacion | No errors. |
App\Entity\NmclLocalizacion | No errors. |