Query Metrics

5 Database Queries
5 Different statements
76.28 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
61.76 ms
(80.97%)
1
"COMMIT"
Parameters:
[]
11.59 ms
(15.20%)
1
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:
[
  "d4b43df9a57bc4a65a5dbdcf3fbc7c09"
]
1.65 ms
(2.16%)
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.id = ?
Parameters:
[
  215
]
0.85 ms
(1.11%)
1
UPDATE seg_codigos_activacion SET fecha_uso = ? WHERE id = ?
Parameters:
[
  "2024-12-27 14:55:33"
  27638
]
0.43 ms
(0.57%)
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\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.