Symfony Profiler

"COMMIT"

"COMMIT";

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

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 = '0803472893' 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.username = ?
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.username = '0803472893' LIMIT 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
  (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )

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 (23295, '0803472893', '  MURILLO CEVALLOS JOEL ENRIQUE', NULL, '0991928126', NULL, 'joelmurillocevallos@gmail.com', NULL, '2025-01-10 16:02:32', NULL, NULL, NULL, 0, NULL, 0, 1, 0, NULL, NULL, NULL, NULL, 198243, NULL, NULL, NULL, NULL);

"START TRANSACTION"

"START TRANSACTION";

SELECT
  NEXTVAL('seg_usuario_id_seq')

SELECT NEXTVAL('seg_usuario_id_seq');

SELECT
  NEXTVAL(
    'seg_codigos_activacion_id_seq'
  )

SELECT NEXTVAL('seg_codigos_activacion_id_seq');

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

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 = 'ROLE_RESERVISTA' LIMIT 1;

INSERT INTO seg_usuario_rol (usuario, rol)
VALUES
  (?, ?)

INSERT INTO seg_usuario_rol (usuario, rol) VALUES (23295, 12);

INSERT INTO seg_codigos_activacion (
  id, codigo, fecha_envio, fecha_vigencia,
  fecha_uso, usuario
)
VALUES
  (?, ?, ?, ?, ?, ?)

INSERT INTO seg_codigos_activacion (id, codigo, fecha_envio, fecha_vigencia, fecha_uso, usuario) VALUES (28327, 'eb8592621ebe740828b7a7b71f0c83ce', '2025-01-10 16:02:32', NULL, NULL, 23295);

UPDATE
  reservistas
SET
  telefono = ?,
  telefono_emergencias = ?,
  email = ?,
  estatura = ?
WHERE
  id = ?

UPDATE reservistas SET telefono = '0991928126', telefono_emergencias = '0991928126', email = 'joelmurillocevallos@gmail.com', estatura = '173' WHERE id = 50858;

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

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 = 'DEFAULT' LIMIT 1;