Symfony Profiler

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.localizacion_nacimiento AS localizacion_nacimiento_19,
  t0.foto AS foto_20,
  t0.certif_covid AS certif_covid_21
FROM
  recluta 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.localizacion_nacimiento AS localizacion_nacimiento_19, t0.foto AS foto_20, t0.certif_covid AS certif_covid_21 FROM recluta t0 WHERE t0.identificacion = '0951487271' LIMIT 1;

"COMMIT"

"COMMIT";

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) = 'BOLIVAR (SAGRARIO)' AND UPPER(n3_.valor) = 'GUAYAQUIL';

SELECT
  p0_.id AS id_0,
  p0_.anno AS anno_1,
  p0_.llamada AS llamada_2,
  p0_.fecha_inicio_registro AS fecha_inicio_registro_3,
  p0_.fecha_fin_registro AS fecha_fin_registro_4,
  p0_.fecha_acuartelamiento AS fecha_acuartelamiento_5,
  p0_.fecha_fin_dias AS fecha_fin_dias_6,
  p0_.hora_inicio_acuartelamiento AS hora_inicio_acuartelamiento_7,
  p0_.hora_fin_acuartelamiento AS hora_fin_acuartelamiento_8,
  p0_.fecha_fin_dias_posteriores AS fecha_fin_dias_posteriores_9,
  p0_.minutos_test AS minutos_test_10,
  p0_.bajas_permitidas AS bajas_permitidas_11,
  p0_.activo AS activo_12,
  p0_.cant_cursos AS cant_cursos_13,
  p0_.titulo_reporte_uniforme AS titulo_reporte_uniforme_14,
  p0_.titulo_reporte_jockey AS titulo_reporte_jockey_15,
  p0_.titulo_reporte_calzado AS titulo_reporte_calzado_16,
  p0_.titulo_reporte_camiseta AS titulo_reporte_camiseta_17,
  p0_.titulo_reporte_estudios AS titulo_reporte_estudios_18,
  p0_.foto_uniforme AS foto_uniforme_19,
  p0_.foto_jockey AS foto_jockey_20,
  p0_.foto_calzado AS foto_calzado_21,
  p0_.foto_camiseta AS foto_camiseta_22
FROM
  proceso_reclutamiento p0_
WHERE
  p0_.activo = true

SELECT p0_.id AS id_0, p0_.anno AS anno_1, p0_.llamada AS llamada_2, p0_.fecha_inicio_registro AS fecha_inicio_registro_3, p0_.fecha_fin_registro AS fecha_fin_registro_4, p0_.fecha_acuartelamiento AS fecha_acuartelamiento_5, p0_.fecha_fin_dias AS fecha_fin_dias_6, p0_.hora_inicio_acuartelamiento AS hora_inicio_acuartelamiento_7, p0_.hora_fin_acuartelamiento AS hora_fin_acuartelamiento_8, p0_.fecha_fin_dias_posteriores AS fecha_fin_dias_posteriores_9, p0_.minutos_test AS minutos_test_10, p0_.bajas_permitidas AS bajas_permitidas_11, p0_.activo AS activo_12, p0_.cant_cursos AS cant_cursos_13, p0_.titulo_reporte_uniforme AS titulo_reporte_uniforme_14, p0_.titulo_reporte_jockey AS titulo_reporte_jockey_15, p0_.titulo_reporte_calzado AS titulo_reporte_calzado_16, p0_.titulo_reporte_camiseta AS titulo_reporte_camiseta_17, p0_.titulo_reporte_estudios AS titulo_reporte_estudios_18, p0_.foto_uniforme AS foto_uniforme_19, p0_.foto_jockey AS foto_jockey_20, p0_.foto_calzado AS foto_calzado_21, p0_.foto_camiseta AS foto_camiseta_22 FROM proceso_reclutamiento p0_ WHERE p0_.activo = true;

SELECT
  r0_.id AS id_0,
  r0_.fecha_registro AS fecha_registro_1,
  r0_.pais_residencia AS pais_residencia_2,
  r0_.calle_principal_residencia AS calle_principal_residencia_3,
  r0_.calle_secundaria_residencia AS calle_secundaria_residencia_4,
  r0_.num_casa AS num_casa_5,
  r0_.referencias AS referencias_6,
  r0_.geometria AS geometria_7,
  r0_.fecha_consulta_antecedentes AS fecha_consulta_antecedentes_8,
  r0_.resultados_antecedentes AS resultados_antecedentes_9,
  r0_.fecha_consulta_estudios AS fecha_consulta_estudios_10,
  r0_.resultados_estudios AS resultados_estudios_11,
  r0_.idoneo AS idoneo_12,
  r0_.fecha_resultado AS fecha_resultado_13,
  r0_.fecha_asignacion AS fecha_asignacion_14,
  r0_.causa_rechazo AS causa_rechazo_15,
  r0_.observaciones AS observaciones_16,
  r0_.volver_presentarse AS volver_presentarse_17,
  r0_.intentos AS intentos_18,
  r0_.fecha_intento1 AS fecha_intento1_19,
  r0_.fecha_intento2 AS fecha_intento2_20,
  r0_.fecha_intento3 AS fecha_intento3_21,
  r0_.turno AS turno_22,
  r0_.fecha_baja AS fecha_baja_23,
  r0_.certificado_vacunacion_ok AS certificado_vacunacion_ok_24,
  r0_.talla_uniforme AS talla_uniforme_25,
  r0_.talla_jockey AS talla_jockey_26,
  r0_.talla_calzado AS talla_calzado_27,
  r0_.talla_camiseta AS talla_camiseta_28,
  r0_.estudio AS estudio_29,
  r0_.proceso AS proceso_30,
  r0_.base_movilizacion AS base_movilizacion_31,
  r0_.centro_movilizacion AS centro_movilizacion_32,
  r0_.unidad_militar AS unidad_militar_33,
  r0_.recluta AS recluta_34,
  r0_.localizacion_residencia AS localizacion_residencia_35,
  r0_.unidad_militar_inicial AS unidad_militar_inicial_36
FROM
  recluta_proceso r0_
  LEFT JOIN recluta r1_ ON r0_.recluta = r1_.id
WHERE
  r1_.id = ?
  AND r0_.idoneo = false
  AND r0_.volver_presentarse = ?

SELECT r0_.id AS id_0, r0_.fecha_registro AS fecha_registro_1, r0_.pais_residencia AS pais_residencia_2, r0_.calle_principal_residencia AS calle_principal_residencia_3, r0_.calle_secundaria_residencia AS calle_secundaria_residencia_4, r0_.num_casa AS num_casa_5, r0_.referencias AS referencias_6, r0_.geometria AS geometria_7, r0_.fecha_consulta_antecedentes AS fecha_consulta_antecedentes_8, r0_.resultados_antecedentes AS resultados_antecedentes_9, r0_.fecha_consulta_estudios AS fecha_consulta_estudios_10, r0_.resultados_estudios AS resultados_estudios_11, r0_.idoneo AS idoneo_12, r0_.fecha_resultado AS fecha_resultado_13, r0_.fecha_asignacion AS fecha_asignacion_14, r0_.causa_rechazo AS causa_rechazo_15, r0_.observaciones AS observaciones_16, r0_.volver_presentarse AS volver_presentarse_17, r0_.intentos AS intentos_18, r0_.fecha_intento1 AS fecha_intento1_19, r0_.fecha_intento2 AS fecha_intento2_20, r0_.fecha_intento3 AS fecha_intento3_21, r0_.turno AS turno_22, r0_.fecha_baja AS fecha_baja_23, r0_.certificado_vacunacion_ok AS certificado_vacunacion_ok_24, r0_.talla_uniforme AS talla_uniforme_25, r0_.talla_jockey AS talla_jockey_26, r0_.talla_calzado AS talla_calzado_27, r0_.talla_camiseta AS talla_camiseta_28, r0_.estudio AS estudio_29, r0_.proceso AS proceso_30, r0_.base_movilizacion AS base_movilizacion_31, r0_.centro_movilizacion AS centro_movilizacion_32, r0_.unidad_militar AS unidad_militar_33, r0_.recluta AS recluta_34, r0_.localizacion_residencia AS localizacion_residencia_35, r0_.unidad_militar_inicial AS unidad_militar_inicial_36 FROM recluta_proceso r0_ LEFT JOIN recluta r1_ ON r0_.recluta = r1_.id WHERE r1_.id = 154168 AND r0_.idoneo = false AND r0_.volver_presentarse = 'NUNCA';

SELECT
  r0_.id AS id_0,
  r0_.fecha_registro AS fecha_registro_1,
  r0_.pais_residencia AS pais_residencia_2,
  r0_.calle_principal_residencia AS calle_principal_residencia_3,
  r0_.calle_secundaria_residencia AS calle_secundaria_residencia_4,
  r0_.num_casa AS num_casa_5,
  r0_.referencias AS referencias_6,
  r0_.geometria AS geometria_7,
  r0_.fecha_consulta_antecedentes AS fecha_consulta_antecedentes_8,
  r0_.resultados_antecedentes AS resultados_antecedentes_9,
  r0_.fecha_consulta_estudios AS fecha_consulta_estudios_10,
  r0_.resultados_estudios AS resultados_estudios_11,
  r0_.idoneo AS idoneo_12,
  r0_.fecha_resultado AS fecha_resultado_13,
  r0_.fecha_asignacion AS fecha_asignacion_14,
  r0_.causa_rechazo AS causa_rechazo_15,
  r0_.observaciones AS observaciones_16,
  r0_.volver_presentarse AS volver_presentarse_17,
  r0_.intentos AS intentos_18,
  r0_.fecha_intento1 AS fecha_intento1_19,
  r0_.fecha_intento2 AS fecha_intento2_20,
  r0_.fecha_intento3 AS fecha_intento3_21,
  r0_.turno AS turno_22,
  r0_.fecha_baja AS fecha_baja_23,
  r0_.certificado_vacunacion_ok AS certificado_vacunacion_ok_24,
  r0_.talla_uniforme AS talla_uniforme_25,
  r0_.talla_jockey AS talla_jockey_26,
  r0_.talla_calzado AS talla_calzado_27,
  r0_.talla_camiseta AS talla_camiseta_28,
  r0_.estudio AS estudio_29,
  r0_.proceso AS proceso_30,
  r0_.base_movilizacion AS base_movilizacion_31,
  r0_.centro_movilizacion AS centro_movilizacion_32,
  r0_.unidad_militar AS unidad_militar_33,
  r0_.recluta AS recluta_34,
  r0_.localizacion_residencia AS localizacion_residencia_35,
  r0_.unidad_militar_inicial AS unidad_militar_inicial_36
FROM
  recluta_proceso r0_
  LEFT JOIN proceso_reclutamiento p1_ ON r0_.proceso = p1_.id
  LEFT JOIN recluta r2_ ON r0_.recluta = r2_.id
WHERE
  r2_.id = ?
  AND p1_.activo = true

SELECT r0_.id AS id_0, r0_.fecha_registro AS fecha_registro_1, r0_.pais_residencia AS pais_residencia_2, r0_.calle_principal_residencia AS calle_principal_residencia_3, r0_.calle_secundaria_residencia AS calle_secundaria_residencia_4, r0_.num_casa AS num_casa_5, r0_.referencias AS referencias_6, r0_.geometria AS geometria_7, r0_.fecha_consulta_antecedentes AS fecha_consulta_antecedentes_8, r0_.resultados_antecedentes AS resultados_antecedentes_9, r0_.fecha_consulta_estudios AS fecha_consulta_estudios_10, r0_.resultados_estudios AS resultados_estudios_11, r0_.idoneo AS idoneo_12, r0_.fecha_resultado AS fecha_resultado_13, r0_.fecha_asignacion AS fecha_asignacion_14, r0_.causa_rechazo AS causa_rechazo_15, r0_.observaciones AS observaciones_16, r0_.volver_presentarse AS volver_presentarse_17, r0_.intentos AS intentos_18, r0_.fecha_intento1 AS fecha_intento1_19, r0_.fecha_intento2 AS fecha_intento2_20, r0_.fecha_intento3 AS fecha_intento3_21, r0_.turno AS turno_22, r0_.fecha_baja AS fecha_baja_23, r0_.certificado_vacunacion_ok AS certificado_vacunacion_ok_24, r0_.talla_uniforme AS talla_uniforme_25, r0_.talla_jockey AS talla_jockey_26, r0_.talla_calzado AS talla_calzado_27, r0_.talla_camiseta AS talla_camiseta_28, r0_.estudio AS estudio_29, r0_.proceso AS proceso_30, r0_.base_movilizacion AS base_movilizacion_31, r0_.centro_movilizacion AS centro_movilizacion_32, r0_.unidad_militar AS unidad_militar_33, r0_.recluta AS recluta_34, r0_.localizacion_residencia AS localizacion_residencia_35, r0_.unidad_militar_inicial AS unidad_militar_inicial_36 FROM recluta_proceso r0_ LEFT JOIN proceso_reclutamiento p1_ ON r0_.proceso = p1_.id LEFT JOIN recluta r2_ ON r0_.recluta = r2_.id WHERE r2_.id = 154168 AND p1_.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.fecha_asignacion AS fecha_asignacion_15,
  t0.causa_rechazo AS causa_rechazo_16,
  t0.observaciones AS observaciones_17,
  t0.volver_presentarse AS volver_presentarse_18,
  t0.intentos AS intentos_19,
  t0.fecha_intento1 AS fecha_intento1_20,
  t0.fecha_intento2 AS fecha_intento2_21,
  t0.fecha_intento3 AS fecha_intento3_22,
  t0.turno AS turno_23,
  t0.fecha_baja AS fecha_baja_24,
  t0.certificado_vacunacion_ok AS certificado_vacunacion_ok_25,
  t0.talla_uniforme AS talla_uniforme_26,
  t0.talla_jockey AS talla_jockey_27,
  t0.talla_calzado AS talla_calzado_28,
  t0.talla_camiseta AS talla_camiseta_29,
  t0.estudio AS estudio_30,
  t0.proceso AS proceso_31,
  t0.base_movilizacion AS base_movilizacion_32,
  t0.centro_movilizacion AS centro_movilizacion_33,
  t0.unidad_militar AS unidad_militar_34,
  t0.recluta AS recluta_35,
  t0.localizacion_residencia AS localizacion_residencia_36,
  t0.unidad_militar_inicial AS unidad_militar_inicial_37
FROM
  recluta_proceso t0
WHERE
  t0.recluta = ?
  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.fecha_asignacion AS fecha_asignacion_15, t0.causa_rechazo AS causa_rechazo_16, t0.observaciones AS observaciones_17, t0.volver_presentarse AS volver_presentarse_18, t0.intentos AS intentos_19, t0.fecha_intento1 AS fecha_intento1_20, t0.fecha_intento2 AS fecha_intento2_21, t0.fecha_intento3 AS fecha_intento3_22, t0.turno AS turno_23, t0.fecha_baja AS fecha_baja_24, t0.certificado_vacunacion_ok AS certificado_vacunacion_ok_25, t0.talla_uniforme AS talla_uniforme_26, t0.talla_jockey AS talla_jockey_27, t0.talla_calzado AS talla_calzado_28, t0.talla_camiseta AS talla_camiseta_29, t0.estudio AS estudio_30, t0.proceso AS proceso_31, t0.base_movilizacion AS base_movilizacion_32, t0.centro_movilizacion AS centro_movilizacion_33, t0.unidad_militar AS unidad_militar_34, t0.recluta AS recluta_35, t0.localizacion_residencia AS localizacion_residencia_36, t0.unidad_militar_inicial AS unidad_militar_inicial_37 FROM recluta_proceso t0 WHERE t0.recluta = 154168 AND t0.proceso = 47 LIMIT 1;

UPDATE
  recluta
SET
  edad = ?
WHERE
  id = ?

UPDATE recluta SET edad = '18' WHERE id = 154168;

"START TRANSACTION"

"START TRANSACTION";