Symfony Profiler

SELECT
  p0_.id AS id_0,
  p0_.fecha_inicio_registro AS fecha_inicio_registro_1,
  p0_.fecha_fin_registro AS fecha_fin_registro_2,
  p0_.anno_desde AS anno_desde_3,
  p0_.anno_hasta AS anno_hasta_4,
  p0_.activo AS activo_5
FROM
  proceso_registro_reservistas p0_
WHERE
  p0_.activo = true

SELECT p0_.id AS id_0, p0_.fecha_inicio_registro AS fecha_inicio_registro_1, p0_.fecha_fin_registro AS fecha_fin_registro_2, p0_.anno_desde AS anno_desde_3, p0_.anno_hasta AS anno_hasta_4, p0_.activo AS activo_5 FROM proceso_registro_reservistas p0_ WHERE p0_.activo = true;

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

SELECT
  p0_.id AS id_0,
  p0_.fecha_inicio_registro AS fecha_inicio_registro_1,
  p0_.fecha_fin_registro AS fecha_fin_registro_2,
  p0_.anno_desde AS anno_desde_3,
  p0_.anno_hasta AS anno_hasta_4,
  p0_.activo AS activo_5
FROM
  proceso_registro_reservistas p0_
WHERE
  p0_.activo = true

SELECT p0_.id AS id_0, p0_.fecha_inicio_registro AS fecha_inicio_registro_1, p0_.fecha_fin_registro AS fecha_fin_registro_2, p0_.anno_desde AS anno_desde_3, p0_.anno_hasta AS anno_hasta_4, p0_.activo AS activo_5 FROM proceso_registro_reservistas p0_ WHERE p0_.activo = true;

SELECT
  t0.id AS id_1,
  t0.fecha_registro AS fecha_registro_2,
  t0.pais_residencia AS pais_residencia_3,
  t0.calle_principal_residencia AS calle_principal_residencia_4,
  t0.calle_secundaria_residencia AS calle_secundaria_residencia_5,
  t0.num_casa AS num_casa_6,
  t0.referencias AS referencias_7,
  t0.geometria AS geometria_8,
  t0.fecha_consulta_antecedentes AS fecha_consulta_antecedentes_9,
  t0.resultados_antecedentes AS resultados_antecedentes_10,
  t0.fecha_consulta_estudios AS fecha_consulta_estudios_11,
  t0.resultados_estudios AS resultados_estudios_12,
  t0.idoneo AS idoneo_13,
  t0.fecha_resultado AS fecha_resultado_14,
  t0.causa_rechazo AS causa_rechazo_15,
  t0.observaciones AS observaciones_16,
  t0.volver_presentarse AS volver_presentarse_17,
  t0.fecha_baja AS fecha_baja_18,
  t0.certificado_vacunacion_ok AS certificado_vacunacion_ok_19,
  t0.disponibilidad AS disponibilidad_20,
  t0.actividad AS actividad_21,
  t0.error_registro AS error_registro_22,
  t0.proceso AS proceso_23,
  t0.reservista AS reservista_24,
  t0.localizacion_residencia AS localizacion_residencia_25,
  t0.centro_movilizacion AS centro_movilizacion_26
FROM
  reservista_proceso t0
WHERE
  t0.reservista = ?
  AND t0.proceso = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.fecha_registro AS fecha_registro_2, t0.pais_residencia AS pais_residencia_3, t0.calle_principal_residencia AS calle_principal_residencia_4, t0.calle_secundaria_residencia AS calle_secundaria_residencia_5, t0.num_casa AS num_casa_6, t0.referencias AS referencias_7, t0.geometria AS geometria_8, t0.fecha_consulta_antecedentes AS fecha_consulta_antecedentes_9, t0.resultados_antecedentes AS resultados_antecedentes_10, t0.fecha_consulta_estudios AS fecha_consulta_estudios_11, t0.resultados_estudios AS resultados_estudios_12, t0.idoneo AS idoneo_13, t0.fecha_resultado AS fecha_resultado_14, t0.causa_rechazo AS causa_rechazo_15, t0.observaciones AS observaciones_16, t0.volver_presentarse AS volver_presentarse_17, t0.fecha_baja AS fecha_baja_18, t0.certificado_vacunacion_ok AS certificado_vacunacion_ok_19, t0.disponibilidad AS disponibilidad_20, t0.actividad AS actividad_21, t0.error_registro AS error_registro_22, t0.proceso AS proceso_23, t0.reservista AS reservista_24, t0.localizacion_residencia AS localizacion_residencia_25, t0.centro_movilizacion AS centro_movilizacion_26 FROM reservista_proceso t0 WHERE t0.reservista = 10937 AND t0.proceso = 7 LIMIT 1;

SELECT
  n0_.id AS id_0,
  n0_.valor AS valor_1,
  n0_.nivel_localizacion AS nivel_localizacion_2,
  n0_.padre AS padre_3
FROM
  nmcl_dominio_localizacion n0_
  LEFT JOIN nmcl_nivel_localizacion n1_ ON n0_.nivel_localizacion = n1_.id
  LEFT JOIN nmcl_localizacion n2_ ON n1_.localizacion = n2_.id
  LEFT JOIN nmcl_dominio_localizacion n3_ ON n0_.padre = n3_.id
WHERE
  n2_.id = 1
  AND n1_.nivel = 4
  AND UPPER(n0_.valor) = ?
  AND UPPER(n3_.valor) = ?

SELECT n0_.id AS id_0, n0_.valor AS valor_1, n0_.nivel_localizacion AS nivel_localizacion_2, n0_.padre AS padre_3 FROM nmcl_dominio_localizacion n0_ LEFT JOIN nmcl_nivel_localizacion n1_ ON n0_.nivel_localizacion = n1_.id LEFT JOIN nmcl_localizacion n2_ ON n1_.localizacion = n2_.id LEFT JOIN nmcl_dominio_localizacion n3_ ON n0_.padre = n3_.id WHERE n2_.id = 1 AND n1_.nivel = 4 AND UPPER(n0_.valor) = 'NUEVA LOJA' AND UPPER(n3_.valor) = 'LAGO AGRIO';

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

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  reservistas
SET
  edad = ?
WHERE
  id = ?

UPDATE reservistas SET edad = '23' WHERE id = 10937;

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

SELECT
  p0_.id AS id_0,
  p0_.fecha_inicio_registro AS fecha_inicio_registro_1,
  p0_.fecha_fin_registro AS fecha_fin_registro_2,
  p0_.anno_desde AS anno_desde_3,
  p0_.anno_hasta AS anno_hasta_4,
  p0_.activo AS activo_5
FROM
  proceso_registro_reservistas p0_
WHERE
  p0_.activo = true

SELECT p0_.id AS id_0, p0_.fecha_inicio_registro AS fecha_inicio_registro_1, p0_.fecha_fin_registro AS fecha_fin_registro_2, p0_.anno_desde AS anno_desde_3, p0_.anno_hasta AS anno_hasta_4, p0_.activo AS activo_5 FROM proceso_registro_reservistas p0_ WHERE p0_.activo = true;

SELECT
  t0.id AS id_1,
  t0.fecha_registro AS fecha_registro_2,
  t0.pais_residencia AS pais_residencia_3,
  t0.calle_principal_residencia AS calle_principal_residencia_4,
  t0.calle_secundaria_residencia AS calle_secundaria_residencia_5,
  t0.num_casa AS num_casa_6,
  t0.referencias AS referencias_7,
  t0.geometria AS geometria_8,
  t0.fecha_consulta_antecedentes AS fecha_consulta_antecedentes_9,
  t0.resultados_antecedentes AS resultados_antecedentes_10,
  t0.fecha_consulta_estudios AS fecha_consulta_estudios_11,
  t0.resultados_estudios AS resultados_estudios_12,
  t0.idoneo AS idoneo_13,
  t0.fecha_resultado AS fecha_resultado_14,
  t0.causa_rechazo AS causa_rechazo_15,
  t0.observaciones AS observaciones_16,
  t0.volver_presentarse AS volver_presentarse_17,
  t0.fecha_baja AS fecha_baja_18,
  t0.certificado_vacunacion_ok AS certificado_vacunacion_ok_19,
  t0.disponibilidad AS disponibilidad_20,
  t0.actividad AS actividad_21,
  t0.error_registro AS error_registro_22,
  t0.proceso AS proceso_23,
  t0.reservista AS reservista_24,
  t0.localizacion_residencia AS localizacion_residencia_25,
  t0.centro_movilizacion AS centro_movilizacion_26
FROM
  reservista_proceso t0
WHERE
  t0.reservista = ?
  AND t0.proceso = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.fecha_registro AS fecha_registro_2, t0.pais_residencia AS pais_residencia_3, t0.calle_principal_residencia AS calle_principal_residencia_4, t0.calle_secundaria_residencia AS calle_secundaria_residencia_5, t0.num_casa AS num_casa_6, t0.referencias AS referencias_7, t0.geometria AS geometria_8, t0.fecha_consulta_antecedentes AS fecha_consulta_antecedentes_9, t0.resultados_antecedentes AS resultados_antecedentes_10, t0.fecha_consulta_estudios AS fecha_consulta_estudios_11, t0.resultados_estudios AS resultados_estudios_12, t0.idoneo AS idoneo_13, t0.fecha_resultado AS fecha_resultado_14, t0.causa_rechazo AS causa_rechazo_15, t0.observaciones AS observaciones_16, t0.volver_presentarse AS volver_presentarse_17, t0.fecha_baja AS fecha_baja_18, t0.certificado_vacunacion_ok AS certificado_vacunacion_ok_19, t0.disponibilidad AS disponibilidad_20, t0.actividad AS actividad_21, t0.error_registro AS error_registro_22, t0.proceso AS proceso_23, t0.reservista AS reservista_24, t0.localizacion_residencia AS localizacion_residencia_25, t0.centro_movilizacion AS centro_movilizacion_26 FROM reservista_proceso t0 WHERE t0.reservista = 10937 AND t0.proceso = 7 LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  reservista_proceso
SET
  fecha_resultado = ?
WHERE
  id = ?

UPDATE reservista_proceso SET fecha_resultado = '2024-11-28 22:53:00' WHERE id = 56608;

"COMMIT"

"COMMIT";