Symfony Profiler

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

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 = '7c7f33cd0b98ee12238d33219e192728' LIMIT 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 = ?

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 = 7844;

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  seg_usuario
SET
  intentos_fallidos = ?
WHERE
  id = ?

UPDATE seg_usuario SET intentos_fallidos = 0 WHERE id = 7844;

UPDATE
  seg_codigos_activacion
SET
  fecha_uso = ?
WHERE
  id = ?

UPDATE seg_codigos_activacion SET fecha_uso = '2024-11-23 18:50:42' WHERE id = 8289;

"COMMIT"

"COMMIT";