Symfony Profiler

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

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
  INNER JOIN seg_usuario_rol ON t0.id = seg_usuario_rol.rol
WHERE
  seg_usuario_rol.usuario = ?

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 INNER JOIN seg_usuario_rol ON t0.id = seg_usuario_rol.rol WHERE seg_usuario_rol.usuario = 4627;

SELECT
  t0.id AS id_1,
  t0.anno AS anno_2,
  t0.llamada AS llamada_3,
  t0.fecha_inicio_registro AS fecha_inicio_registro_4,
  t0.fecha_fin_registro AS fecha_fin_registro_5,
  t0.fecha_acuartelamiento AS fecha_acuartelamiento_6,
  t0.fecha_fin_dias AS fecha_fin_dias_7,
  t0.hora_inicio_acuartelamiento AS hora_inicio_acuartelamiento_8,
  t0.hora_fin_acuartelamiento AS hora_fin_acuartelamiento_9,
  t0.fecha_fin_dias_posteriores AS fecha_fin_dias_posteriores_10,
  t0.minutos_test AS minutos_test_11,
  t0.bajas_permitidas AS bajas_permitidas_12,
  t0.activo AS activo_13,
  t0.cant_cursos AS cant_cursos_14,
  t0.titulo_reporte_uniforme AS titulo_reporte_uniforme_15,
  t0.titulo_reporte_jockey AS titulo_reporte_jockey_16,
  t0.titulo_reporte_calzado AS titulo_reporte_calzado_17,
  t0.titulo_reporte_camiseta AS titulo_reporte_camiseta_18,
  t0.titulo_reporte_estudios AS titulo_reporte_estudios_19,
  t0.foto_uniforme AS foto_uniforme_20,
  t0.foto_jockey AS foto_jockey_21,
  t0.foto_calzado AS foto_calzado_22,
  t0.foto_camiseta AS foto_camiseta_23
FROM
  proceso_reclutamiento t0
WHERE
  t0.activo = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.anno AS anno_2, t0.llamada AS llamada_3, t0.fecha_inicio_registro AS fecha_inicio_registro_4, t0.fecha_fin_registro AS fecha_fin_registro_5, t0.fecha_acuartelamiento AS fecha_acuartelamiento_6, t0.fecha_fin_dias AS fecha_fin_dias_7, t0.hora_inicio_acuartelamiento AS hora_inicio_acuartelamiento_8, t0.hora_fin_acuartelamiento AS hora_fin_acuartelamiento_9, t0.fecha_fin_dias_posteriores AS fecha_fin_dias_posteriores_10, t0.minutos_test AS minutos_test_11, t0.bajas_permitidas AS bajas_permitidas_12, t0.activo AS activo_13, t0.cant_cursos AS cant_cursos_14, t0.titulo_reporte_uniforme AS titulo_reporte_uniforme_15, t0.titulo_reporte_jockey AS titulo_reporte_jockey_16, t0.titulo_reporte_calzado AS titulo_reporte_calzado_17, t0.titulo_reporte_camiseta AS titulo_reporte_camiseta_18, t0.titulo_reporte_estudios AS titulo_reporte_estudios_19, t0.foto_uniforme AS foto_uniforme_20, t0.foto_jockey AS foto_jockey_21, t0.foto_calzado AS foto_calzado_22, t0.foto_camiseta AS foto_camiseta_23 FROM proceso_reclutamiento t0 WHERE t0.activo = 1 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.anno AS anno_2,
  t0.llamada AS llamada_3,
  t0.fecha_inicio_registro AS fecha_inicio_registro_4,
  t0.fecha_fin_registro AS fecha_fin_registro_5,
  t0.fecha_acuartelamiento AS fecha_acuartelamiento_6,
  t0.fecha_fin_dias AS fecha_fin_dias_7,
  t0.hora_inicio_acuartelamiento AS hora_inicio_acuartelamiento_8,
  t0.hora_fin_acuartelamiento AS hora_fin_acuartelamiento_9,
  t0.fecha_fin_dias_posteriores AS fecha_fin_dias_posteriores_10,
  t0.minutos_test AS minutos_test_11,
  t0.bajas_permitidas AS bajas_permitidas_12,
  t0.activo AS activo_13,
  t0.cant_cursos AS cant_cursos_14,
  t0.titulo_reporte_uniforme AS titulo_reporte_uniforme_15,
  t0.titulo_reporte_jockey AS titulo_reporte_jockey_16,
  t0.titulo_reporte_calzado AS titulo_reporte_calzado_17,
  t0.titulo_reporte_camiseta AS titulo_reporte_camiseta_18,
  t0.titulo_reporte_estudios AS titulo_reporte_estudios_19,
  t0.foto_uniforme AS foto_uniforme_20,
  t0.foto_jockey AS foto_jockey_21,
  t0.foto_calzado AS foto_calzado_22,
  t0.foto_camiseta AS foto_camiseta_23
FROM
  proceso_reclutamiento t0
WHERE
  t0.activo = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.anno AS anno_2, t0.llamada AS llamada_3, t0.fecha_inicio_registro AS fecha_inicio_registro_4, t0.fecha_fin_registro AS fecha_fin_registro_5, t0.fecha_acuartelamiento AS fecha_acuartelamiento_6, t0.fecha_fin_dias AS fecha_fin_dias_7, t0.hora_inicio_acuartelamiento AS hora_inicio_acuartelamiento_8, t0.hora_fin_acuartelamiento AS hora_fin_acuartelamiento_9, t0.fecha_fin_dias_posteriores AS fecha_fin_dias_posteriores_10, t0.minutos_test AS minutos_test_11, t0.bajas_permitidas AS bajas_permitidas_12, t0.activo AS activo_13, t0.cant_cursos AS cant_cursos_14, t0.titulo_reporte_uniforme AS titulo_reporte_uniforme_15, t0.titulo_reporte_jockey AS titulo_reporte_jockey_16, t0.titulo_reporte_calzado AS titulo_reporte_calzado_17, t0.titulo_reporte_camiseta AS titulo_reporte_camiseta_18, t0.titulo_reporte_estudios AS titulo_reporte_estudios_19, t0.foto_uniforme AS foto_uniforme_20, t0.foto_jockey AS foto_jockey_21, t0.foto_calzado AS foto_calzado_22, t0.foto_camiseta AS foto_camiseta_23 FROM proceso_reclutamiento t0 WHERE t0.activo = 1 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.anno AS anno_2,
  t0.llamada AS llamada_3,
  t0.fecha_inicio_registro AS fecha_inicio_registro_4,
  t0.fecha_fin_registro AS fecha_fin_registro_5,
  t0.fecha_acuartelamiento AS fecha_acuartelamiento_6,
  t0.fecha_fin_dias AS fecha_fin_dias_7,
  t0.hora_inicio_acuartelamiento AS hora_inicio_acuartelamiento_8,
  t0.hora_fin_acuartelamiento AS hora_fin_acuartelamiento_9,
  t0.fecha_fin_dias_posteriores AS fecha_fin_dias_posteriores_10,
  t0.minutos_test AS minutos_test_11,
  t0.bajas_permitidas AS bajas_permitidas_12,
  t0.activo AS activo_13,
  t0.cant_cursos AS cant_cursos_14,
  t0.titulo_reporte_uniforme AS titulo_reporte_uniforme_15,
  t0.titulo_reporte_jockey AS titulo_reporte_jockey_16,
  t0.titulo_reporte_calzado AS titulo_reporte_calzado_17,
  t0.titulo_reporte_camiseta AS titulo_reporte_camiseta_18,
  t0.titulo_reporte_estudios AS titulo_reporte_estudios_19,
  t0.foto_uniforme AS foto_uniforme_20,
  t0.foto_jockey AS foto_jockey_21,
  t0.foto_calzado AS foto_calzado_22,
  t0.foto_camiseta AS foto_camiseta_23
FROM
  proceso_reclutamiento t0
WHERE
  t0.activo = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.anno AS anno_2, t0.llamada AS llamada_3, t0.fecha_inicio_registro AS fecha_inicio_registro_4, t0.fecha_fin_registro AS fecha_fin_registro_5, t0.fecha_acuartelamiento AS fecha_acuartelamiento_6, t0.fecha_fin_dias AS fecha_fin_dias_7, t0.hora_inicio_acuartelamiento AS hora_inicio_acuartelamiento_8, t0.hora_fin_acuartelamiento AS hora_fin_acuartelamiento_9, t0.fecha_fin_dias_posteriores AS fecha_fin_dias_posteriores_10, t0.minutos_test AS minutos_test_11, t0.bajas_permitidas AS bajas_permitidas_12, t0.activo AS activo_13, t0.cant_cursos AS cant_cursos_14, t0.titulo_reporte_uniforme AS titulo_reporte_uniforme_15, t0.titulo_reporte_jockey AS titulo_reporte_jockey_16, t0.titulo_reporte_calzado AS titulo_reporte_calzado_17, t0.titulo_reporte_camiseta AS titulo_reporte_camiseta_18, t0.titulo_reporte_estudios AS titulo_reporte_estudios_19, t0.foto_uniforme AS foto_uniforme_20, t0.foto_jockey AS foto_jockey_21, t0.foto_calzado AS foto_calzado_22, t0.foto_camiseta AS foto_camiseta_23 FROM proceso_reclutamiento t0 WHERE t0.activo = 1 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.anno AS anno_2,
  t0.llamada AS llamada_3,
  t0.fecha_inicio_registro AS fecha_inicio_registro_4,
  t0.fecha_fin_registro AS fecha_fin_registro_5,
  t0.fecha_acuartelamiento AS fecha_acuartelamiento_6,
  t0.fecha_fin_dias AS fecha_fin_dias_7,
  t0.hora_inicio_acuartelamiento AS hora_inicio_acuartelamiento_8,
  t0.hora_fin_acuartelamiento AS hora_fin_acuartelamiento_9,
  t0.fecha_fin_dias_posteriores AS fecha_fin_dias_posteriores_10,
  t0.minutos_test AS minutos_test_11,
  t0.bajas_permitidas AS bajas_permitidas_12,
  t0.activo AS activo_13,
  t0.cant_cursos AS cant_cursos_14,
  t0.titulo_reporte_uniforme AS titulo_reporte_uniforme_15,
  t0.titulo_reporte_jockey AS titulo_reporte_jockey_16,
  t0.titulo_reporte_calzado AS titulo_reporte_calzado_17,
  t0.titulo_reporte_camiseta AS titulo_reporte_camiseta_18,
  t0.titulo_reporte_estudios AS titulo_reporte_estudios_19,
  t0.foto_uniforme AS foto_uniforme_20,
  t0.foto_jockey AS foto_jockey_21,
  t0.foto_calzado AS foto_calzado_22,
  t0.foto_camiseta AS foto_camiseta_23
FROM
  proceso_reclutamiento t0
WHERE
  t0.activo = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.anno AS anno_2, t0.llamada AS llamada_3, t0.fecha_inicio_registro AS fecha_inicio_registro_4, t0.fecha_fin_registro AS fecha_fin_registro_5, t0.fecha_acuartelamiento AS fecha_acuartelamiento_6, t0.fecha_fin_dias AS fecha_fin_dias_7, t0.hora_inicio_acuartelamiento AS hora_inicio_acuartelamiento_8, t0.hora_fin_acuartelamiento AS hora_fin_acuartelamiento_9, t0.fecha_fin_dias_posteriores AS fecha_fin_dias_posteriores_10, t0.minutos_test AS minutos_test_11, t0.bajas_permitidas AS bajas_permitidas_12, t0.activo AS activo_13, t0.cant_cursos AS cant_cursos_14, t0.titulo_reporte_uniforme AS titulo_reporte_uniforme_15, t0.titulo_reporte_jockey AS titulo_reporte_jockey_16, t0.titulo_reporte_calzado AS titulo_reporte_calzado_17, t0.titulo_reporte_camiseta AS titulo_reporte_camiseta_18, t0.titulo_reporte_estudios AS titulo_reporte_estudios_19, t0.foto_uniforme AS foto_uniforme_20, t0.foto_jockey AS foto_jockey_21, t0.foto_calzado AS foto_calzado_22, t0.foto_camiseta AS foto_camiseta_23 FROM proceso_reclutamiento t0 WHERE t0.activo = 1 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.nombre AS nombre_2,
  t0.direccion AS direccion_3,
  t0.geometria AS geometria_4,
  t0.direccion_acuartelamiento AS direccion_acuartelamiento_5,
  t0.activo AS activo_6,
  t0.localizacion AS localizacion_7,
  t0.jefe AS jefe_8
FROM
  centro_movilizacion t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.direccion AS direccion_3, t0.geometria AS geometria_4, t0.direccion_acuartelamiento AS direccion_acuartelamiento_5, t0.activo AS activo_6, t0.localizacion AS localizacion_7, t0.jefe AS jefe_8 FROM centro_movilizacion t0 WHERE t0.id = 92;

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,
  r1_.id AS id_30,
  r1_.identificacion AS identificacion_31,
  r1_.nombres AS nombres_32,
  r1_.apellido_paterno AS apellido_paterno_33,
  r1_.apellido_materno AS apellido_materno_34,
  r1_.telefono AS telefono_35,
  r1_.telefono_emergencias AS telefono_emergencias_36,
  r1_.email AS email_37,
  r1_.fecha_registro AS fecha_registro_38,
  r1_.fecha_nacimiento AS fecha_nacimiento_39,
  r1_.sexo AS sexo_40,
  r1_.estado_civil AS estado_civil_41,
  r1_.estatura AS estatura_42,
  r1_.edad AS edad_43,
  r1_.lugar_string AS lugar_string_44,
  r1_.edad_string AS edad_string_45,
  r1_.pais_nacimiento AS pais_nacimiento_46,
  r1_.foto_cedula AS foto_cedula_47,
  c2_.id AS id_48,
  c2_.nombre AS nombre_49,
  c2_.direccion AS direccion_50,
  c2_.geometria AS geometria_51,
  c2_.direccion_acuartelamiento AS direccion_acuartelamiento_52,
  c2_.activo AS activo_53,
  r0_.proceso AS proceso_54,
  r0_.base_movilizacion AS base_movilizacion_55,
  r0_.centro_movilizacion AS centro_movilizacion_56,
  r0_.unidad_militar AS unidad_militar_57,
  r0_.recluta AS recluta_58,
  r0_.localizacion_residencia AS localizacion_residencia_59,
  r0_.unidad_militar_inicial AS unidad_militar_inicial_60,
  r1_.localizacion_nacimiento AS localizacion_nacimiento_61,
  r1_.foto AS foto_62,
  r1_.certif_covid AS certif_covid_63,
  c2_.localizacion AS localizacion_64,
  c2_.jefe AS jefe_65
FROM
  recluta_proceso r0_
  LEFT JOIN proceso_reclutamiento p3_ ON r0_.proceso = p3_.id
  LEFT JOIN unidad_militar u4_ ON r0_.unidad_militar = u4_.id
  INNER JOIN recluta r1_ ON r0_.recluta = r1_.id
  INNER JOIN centro_movilizacion c2_ ON r0_.centro_movilizacion = c2_.id
WHERE
  p3_.id = 47
  AND r0_.unidad_militar IS NOT NULL
  AND c2_.id IN (92)
  AND r0_.turno IS NOT NULL
ORDER BY
  r0_.id DESC

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, r1_.id AS id_30, r1_.identificacion AS identificacion_31, r1_.nombres AS nombres_32, r1_.apellido_paterno AS apellido_paterno_33, r1_.apellido_materno AS apellido_materno_34, r1_.telefono AS telefono_35, r1_.telefono_emergencias AS telefono_emergencias_36, r1_.email AS email_37, r1_.fecha_registro AS fecha_registro_38, r1_.fecha_nacimiento AS fecha_nacimiento_39, r1_.sexo AS sexo_40, r1_.estado_civil AS estado_civil_41, r1_.estatura AS estatura_42, r1_.edad AS edad_43, r1_.lugar_string AS lugar_string_44, r1_.edad_string AS edad_string_45, r1_.pais_nacimiento AS pais_nacimiento_46, r1_.foto_cedula AS foto_cedula_47, c2_.id AS id_48, c2_.nombre AS nombre_49, c2_.direccion AS direccion_50, c2_.geometria AS geometria_51, c2_.direccion_acuartelamiento AS direccion_acuartelamiento_52, c2_.activo AS activo_53, r0_.proceso AS proceso_54, r0_.base_movilizacion AS base_movilizacion_55, r0_.centro_movilizacion AS centro_movilizacion_56, r0_.unidad_militar AS unidad_militar_57, r0_.recluta AS recluta_58, r0_.localizacion_residencia AS localizacion_residencia_59, r0_.unidad_militar_inicial AS unidad_militar_inicial_60, r1_.localizacion_nacimiento AS localizacion_nacimiento_61, r1_.foto AS foto_62, r1_.certif_covid AS certif_covid_63, c2_.localizacion AS localizacion_64, c2_.jefe AS jefe_65 FROM recluta_proceso r0_ LEFT JOIN proceso_reclutamiento p3_ ON r0_.proceso = p3_.id LEFT JOIN unidad_militar u4_ ON r0_.unidad_militar = u4_.id INNER JOIN recluta r1_ ON r0_.recluta = r1_.id INNER JOIN centro_movilizacion c2_ ON r0_.centro_movilizacion = c2_.id WHERE p3_.id = 47 AND r0_.unidad_militar IS NOT NULL AND c2_.id IN (92) AND r0_.turno IS NOT NULL ORDER BY r0_.id DESC;

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_

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_;

SELECT
  b0_.id AS id_0,
  b0_.nombre AS nombre_1,
  b0_.direccion AS direccion_2,
  b0_.geometria AS geometria_3,
  b0_.activo AS activo_4,
  b0_.localizacion AS localizacion_5,
  b0_.jefe AS jefe_6
FROM
  base_movilizacion b0_
WHERE
  b0_.id IN (
    SELECT
      b1_.id
    FROM
      proceso_reclutamiento_bases p2_
      INNER JOIN proceso_reclutamiento p3_ ON p2_.proceso = p3_.id
      INNER JOIN base_movilizacion b1_ ON p2_.base = b1_.id
    WHERE
      p3_.id = ?
      AND (
        b1_.id IN (
          SELECT
            b4_.id
          FROM
            proceso_reclutamiento_lugar_base p5_
            INNER JOIN proceso_reclutamiento p6_ ON p5_.proceso = p6_.id
            INNER JOIN base_movilizacion b4_ ON p5_.base = b4_.id
            INNER JOIN centro_movilizacion c7_ ON p5_.lugar = c7_.id
          WHERE
            p6_.id = 47
            AND c7_.id = 92
        )
      )
  )
ORDER BY
  b0_.nombre ASC

SELECT b0_.id AS id_0, b0_.nombre AS nombre_1, b0_.direccion AS direccion_2, b0_.geometria AS geometria_3, b0_.activo AS activo_4, b0_.localizacion AS localizacion_5, b0_.jefe AS jefe_6 FROM base_movilizacion b0_ WHERE b0_.id IN (SELECT b1_.id FROM proceso_reclutamiento_bases p2_ INNER JOIN proceso_reclutamiento p3_ ON p2_.proceso = p3_.id INNER JOIN base_movilizacion b1_ ON p2_.base = b1_.id WHERE p3_.id = 47 AND (b1_.id IN (SELECT b4_.id FROM proceso_reclutamiento_lugar_base p5_ INNER JOIN proceso_reclutamiento p6_ ON p5_.proceso = p6_.id INNER JOIN base_movilizacion b4_ ON p5_.base = b4_.id INNER JOIN centro_movilizacion c7_ ON p5_.lugar = c7_.id WHERE p6_.id = 47 AND c7_.id = 92))) ORDER BY b0_.nombre ASC;

SELECT
  c0_.id AS id_0,
  c0_.nombre AS nombre_1,
  c0_.direccion AS direccion_2,
  c0_.geometria AS geometria_3,
  c0_.direccion_acuartelamiento AS direccion_acuartelamiento_4,
  c0_.activo AS activo_5,
  c0_.localizacion AS localizacion_6,
  c0_.jefe AS jefe_7
FROM
  centro_movilizacion c0_
WHERE
  c0_.id IN (
    SELECT
      c1_.id
    FROM
      proceso_reclutamiento_lugar_base p2_
      INNER JOIN proceso_reclutamiento p3_ ON p2_.proceso = p3_.id
      INNER JOIN base_movilizacion b4_ ON p2_.base = b4_.id
      INNER JOIN centro_movilizacion c1_ ON p2_.lugar = c1_.id
    WHERE
      p3_.id = 47
  )
  AND c0_.id = 92
ORDER BY
  c0_.nombre ASC

SELECT c0_.id AS id_0, c0_.nombre AS nombre_1, c0_.direccion AS direccion_2, c0_.geometria AS geometria_3, c0_.direccion_acuartelamiento AS direccion_acuartelamiento_4, c0_.activo AS activo_5, c0_.localizacion AS localizacion_6, c0_.jefe AS jefe_7 FROM centro_movilizacion c0_ WHERE c0_.id IN (SELECT c1_.id FROM proceso_reclutamiento_lugar_base p2_ INNER JOIN proceso_reclutamiento p3_ ON p2_.proceso = p3_.id INNER JOIN base_movilizacion b4_ ON p2_.base = b4_.id INNER JOIN centro_movilizacion c1_ ON p2_.lugar = c1_.id WHERE p3_.id = 47) AND c0_.id = 92 ORDER BY c0_.nombre ASC;

SELECT
  u0_.id AS id_0,
  u0_.siglas_unidad AS siglas_unidad_1,
  u0_.nombre AS nombre_2,
  u0_.fuerza AS fuerza_3,
  u0_.cupo_masculino AS cupo_masculino_4,
  u0_.adicional_masculino AS adicional_masculino_5,
  u0_.cupo_femenino AS cupo_femenino_6,
  u0_.adicional_femenino AS adicional_femenino_7,
  u0_.direccion AS direccion_8,
  u0_.geometria AS geometria_9,
  u0_.activo AS activo_10,
  u0_.centro_instruccion AS centro_instruccion_11,
  u0_.localizacion AS localizacion_12
FROM
  unidad_militar u0_
WHERE
  u0_.id IN (
    SELECT
      u1_.id
    FROM
      proceso_reclutamiento_unidad_lugar p2_
      INNER JOIN proceso_reclutamiento p3_ ON p2_.proceso = p3_.id
      INNER JOIN centro_movilizacion c4_ ON p2_.lugar = c4_.id
      INNER JOIN unidad_militar u1_ ON p2_.unidad = u1_.id
    WHERE
      p3_.id = 47
      AND c4_.id = 92
  )
ORDER BY
  u0_.nombre ASC

SELECT u0_.id AS id_0, u0_.siglas_unidad AS siglas_unidad_1, u0_.nombre AS nombre_2, u0_.fuerza AS fuerza_3, u0_.cupo_masculino AS cupo_masculino_4, u0_.adicional_masculino AS adicional_masculino_5, u0_.cupo_femenino AS cupo_femenino_6, u0_.adicional_femenino AS adicional_femenino_7, u0_.direccion AS direccion_8, u0_.geometria AS geometria_9, u0_.activo AS activo_10, u0_.centro_instruccion AS centro_instruccion_11, u0_.localizacion AS localizacion_12 FROM unidad_militar u0_ WHERE u0_.id IN (SELECT u1_.id FROM proceso_reclutamiento_unidad_lugar p2_ INNER JOIN proceso_reclutamiento p3_ ON p2_.proceso = p3_.id INNER JOIN centro_movilizacion c4_ ON p2_.lugar = c4_.id INNER JOIN unidad_militar u1_ ON p2_.unidad = u1_.id WHERE p3_.id = 47 AND c4_.id = 92) ORDER BY u0_.nombre ASC;

SELECT
  n0_.id AS id_0,
  n0_.fecha_ingreso AS fecha_ingreso_1,
  n0_.asunto AS asunto_2,
  n0_.leida AS leida_3,
  n0_.fecha_leida AS fecha_leida_4,
  n0_.texto AS texto_5,
  n0_.accion AS accion_6,
  n0_.usuario AS usuario_7
FROM
  notificacion n0_
  INNER JOIN seg_usuario s1_ ON n0_.usuario = s1_.id
WHERE
  n0_.leida = false
  AND s1_.id = 4627
ORDER BY
  n0_.asunto ASC,
  n0_.fecha_ingreso DESC

SELECT n0_.id AS id_0, n0_.fecha_ingreso AS fecha_ingreso_1, n0_.asunto AS asunto_2, n0_.leida AS leida_3, n0_.fecha_leida AS fecha_leida_4, n0_.texto AS texto_5, n0_.accion AS accion_6, n0_.usuario AS usuario_7 FROM notificacion n0_ INNER JOIN seg_usuario s1_ ON n0_.usuario = s1_.id WHERE n0_.leida = false AND s1_.id = 4627 ORDER BY n0_.asunto ASC, n0_.fecha_ingreso DESC;

SELECT
  CURRENT_DATABASE()

SELECT CURRENT_DATABASE();

SELECT
  quote_ident(table_name) AS table_name,
  table_schema AS schema_name
FROM
  information_schema.tables
WHERE
  table_catalog = ?
  AND table_schema NOT LIKE 'pg\_%'
  AND table_schema != 'information_schema'
  AND table_name != 'geometry_columns'
  AND table_name != 'spatial_ref_sys'
  AND table_type = 'BASE TABLE'

SELECT quote_ident(table_name) AS table_name,
       table_schema AS schema_name
FROM information_schema.tables
WHERE table_catalog = 'integral_produccion'
  AND table_schema NOT LIKE 'pg\_%'
  AND table_schema != 'information_schema'
  AND table_name != 'geometry_columns'
  AND table_name != 'spatial_ref_sys'
  AND table_type = 'BASE TABLE';

SELECT
  schema_name
FROM
  information_schema.schemata
WHERE
  schema_name NOT LIKE 'pg\_%'
  AND schema_name != 'information_schema'

SELECT schema_name
FROM   information_schema.schemata
WHERE  schema_name NOT LIKE 'pg\_%'
AND    schema_name != 'information_schema';

SHOW search_path

SHOW search_path;

SELECT
  CURRENT_DATABASE()

SELECT CURRENT_DATABASE();