Symfony Profiler

SELECT
  p0_.id AS id_0,
  p0_.nombre_unidad AS nombre_unidad_1,
  p0_.prioridad AS prioridad_2,
  p0_.cupo_masculino AS cupo_masculino_3,
  p0_.cupo_femenino AS cupo_femenino_4,
  p0_.registrado_masculino AS registrado_masculino_5,
  p0_.registrado_femenino AS registrado_femenino_6,
  p0_.fuerza AS fuerza_7,
  p0_.organico_masculino AS organico_masculino_8,
  p0_.organico_femenino AS organico_femenino_9,
  u1_.id AS id_10,
  u1_.siglas_unidad AS siglas_unidad_11,
  u1_.nombre AS nombre_12,
  u1_.fuerza AS fuerza_13,
  u1_.cupo_masculino AS cupo_masculino_14,
  u1_.adicional_masculino AS adicional_masculino_15,
  u1_.cupo_femenino AS cupo_femenino_16,
  u1_.adicional_femenino AS adicional_femenino_17,
  u1_.direccion AS direccion_18,
  u1_.geometria AS geometria_19,
  u1_.activo AS activo_20,
  c2_.id AS id_21,
  c2_.nombre AS nombre_22,
  c2_.direccion AS direccion_23,
  c2_.geometria AS geometria_24,
  c2_.direccion_acuartelamiento AS direccion_acuartelamiento_25,
  c2_.activo AS activo_26,
  p0_.unidad AS unidad_27,
  p0_.lugar AS lugar_28,
  p0_.proceso AS proceso_29,
  u1_.centro_instruccion AS centro_instruccion_30,
  u1_.localizacion AS localizacion_31,
  c2_.localizacion AS localizacion_32,
  c2_.jefe AS jefe_33
FROM
  proceso_reclutamiento_unidad_lugar p0_
  INNER JOIN proceso_reclutamiento p3_ ON p0_.proceso = p3_.id
  INNER JOIN unidad_militar u1_ ON p0_.unidad = u1_.id
  INNER JOIN centro_movilizacion c2_ ON p0_.lugar = c2_.id
WHERE
  p3_.id = ?
  AND c2_.id = ?
ORDER BY
  p0_.nombre_unidad ASC

SELECT p0_.id AS id_0, p0_.nombre_unidad AS nombre_unidad_1, p0_.prioridad AS prioridad_2, p0_.cupo_masculino AS cupo_masculino_3, p0_.cupo_femenino AS cupo_femenino_4, p0_.registrado_masculino AS registrado_masculino_5, p0_.registrado_femenino AS registrado_femenino_6, p0_.fuerza AS fuerza_7, p0_.organico_masculino AS organico_masculino_8, p0_.organico_femenino AS organico_femenino_9, u1_.id AS id_10, u1_.siglas_unidad AS siglas_unidad_11, u1_.nombre AS nombre_12, u1_.fuerza AS fuerza_13, u1_.cupo_masculino AS cupo_masculino_14, u1_.adicional_masculino AS adicional_masculino_15, u1_.cupo_femenino AS cupo_femenino_16, u1_.adicional_femenino AS adicional_femenino_17, u1_.direccion AS direccion_18, u1_.geometria AS geometria_19, u1_.activo AS activo_20, c2_.id AS id_21, c2_.nombre AS nombre_22, c2_.direccion AS direccion_23, c2_.geometria AS geometria_24, c2_.direccion_acuartelamiento AS direccion_acuartelamiento_25, c2_.activo AS activo_26, p0_.unidad AS unidad_27, p0_.lugar AS lugar_28, p0_.proceso AS proceso_29, u1_.centro_instruccion AS centro_instruccion_30, u1_.localizacion AS localizacion_31, c2_.localizacion AS localizacion_32, c2_.jefe AS jefe_33 FROM proceso_reclutamiento_unidad_lugar p0_ INNER JOIN proceso_reclutamiento p3_ ON p0_.proceso = p3_.id INNER JOIN unidad_militar u1_ ON p0_.unidad = u1_.id INNER JOIN centro_movilizacion c2_ ON p0_.lugar = c2_.id WHERE p3_.id = 42 AND c2_.id = 32 ORDER BY p0_.nombre_unidad ASC;

SELECT
  p0_.id AS id_0,
  p0_.nombre_lugar AS nombre_lugar_1,
  p0_.jefe_cedula AS jefe_cedula_2,
  p0_.jefe_nombres AS jefe_nombres_3,
  p0_.jefe_apellidos AS jefe_apellidos_4,
  p0_.jefe_cargo AS jefe_cargo_5,
  p0_.jefe_grado AS jefe_grado_6,
  p0_.turno AS turno_7,
  p0_.cupo_masculino AS cupo_masculino_8,
  p0_.cupo_femenino AS cupo_femenino_9,
  p0_.registrado_masculino AS registrado_masculino_10,
  p0_.registrado_femenino AS registrado_femenino_11,
  p0_.organico_masculino AS organico_masculino_12,
  p0_.organico_femenino AS organico_femenino_13,
  b1_.id AS id_14,
  b1_.nombre AS nombre_15,
  b1_.direccion AS direccion_16,
  b1_.geometria AS geometria_17,
  b1_.activo AS activo_18,
  c2_.id AS id_19,
  c2_.nombre AS nombre_20,
  c2_.direccion AS direccion_21,
  c2_.geometria AS geometria_22,
  c2_.direccion_acuartelamiento AS direccion_acuartelamiento_23,
  c2_.activo AS activo_24,
  p0_.proceso AS proceso_25,
  p0_.lugar AS lugar_26,
  p0_.base AS base_27,
  p0_.psicologo AS psicologo_28,
  p0_.medico AS medico_29,
  p0_.odontologo AS odontologo_30,
  p0_.laboratorista AS laboratorista_31,
  b1_.localizacion AS localizacion_32,
  b1_.jefe AS jefe_33,
  c2_.localizacion AS localizacion_34,
  c2_.jefe AS jefe_35
FROM
  proceso_reclutamiento_lugar_base p0_
  INNER JOIN proceso_reclutamiento p3_ ON p0_.proceso = p3_.id
  INNER JOIN base_movilizacion b1_ ON p0_.base = b1_.id
  INNER JOIN centro_movilizacion c2_ ON p0_.lugar = c2_.id
WHERE
  p3_.id = ?
  AND b1_.id = ?

SELECT p0_.id AS id_0, p0_.nombre_lugar AS nombre_lugar_1, p0_.jefe_cedula AS jefe_cedula_2, p0_.jefe_nombres AS jefe_nombres_3, p0_.jefe_apellidos AS jefe_apellidos_4, p0_.jefe_cargo AS jefe_cargo_5, p0_.jefe_grado AS jefe_grado_6, p0_.turno AS turno_7, p0_.cupo_masculino AS cupo_masculino_8, p0_.cupo_femenino AS cupo_femenino_9, p0_.registrado_masculino AS registrado_masculino_10, p0_.registrado_femenino AS registrado_femenino_11, p0_.organico_masculino AS organico_masculino_12, p0_.organico_femenino AS organico_femenino_13, b1_.id AS id_14, b1_.nombre AS nombre_15, b1_.direccion AS direccion_16, b1_.geometria AS geometria_17, b1_.activo AS activo_18, c2_.id AS id_19, c2_.nombre AS nombre_20, c2_.direccion AS direccion_21, c2_.geometria AS geometria_22, c2_.direccion_acuartelamiento AS direccion_acuartelamiento_23, c2_.activo AS activo_24, p0_.proceso AS proceso_25, p0_.lugar AS lugar_26, p0_.base AS base_27, p0_.psicologo AS psicologo_28, p0_.medico AS medico_29, p0_.odontologo AS odontologo_30, p0_.laboratorista AS laboratorista_31, b1_.localizacion AS localizacion_32, b1_.jefe AS jefe_33, c2_.localizacion AS localizacion_34, c2_.jefe AS jefe_35 FROM proceso_reclutamiento_lugar_base p0_ INNER JOIN proceso_reclutamiento p3_ ON p0_.proceso = p3_.id INNER JOIN base_movilizacion b1_ ON p0_.base = b1_.id INNER JOIN centro_movilizacion c2_ ON p0_.lugar = c2_.id WHERE p3_.id = 42 AND b1_.id = 8;

SELECT
  p0_.id AS id_0,
  p0_.jefe_cedula AS jefe_cedula_1,
  p0_.jefe_nombres AS jefe_nombres_2,
  p0_.jefe_apellidos AS jefe_apellidos_3,
  p0_.jefe_cargo AS jefe_cargo_4,
  p0_.jefe_grado AS jefe_grado_5,
  p0_.nombre_base AS nombre_base_6,
  b1_.id AS id_7,
  b1_.nombre AS nombre_8,
  b1_.direccion AS direccion_9,
  b1_.geometria AS geometria_10,
  b1_.activo AS activo_11,
  p0_.proceso AS proceso_12,
  p0_.base AS base_13,
  b1_.localizacion AS localizacion_14,
  b1_.jefe AS jefe_15
FROM
  proceso_reclutamiento_bases p0_
  INNER JOIN proceso_reclutamiento p2_ ON p0_.proceso = p2_.id
  INNER JOIN base_movilizacion b1_ ON p0_.base = b1_.id
WHERE
  p2_.id = ?
ORDER BY
  p0_.nombre_base ASC

SELECT p0_.id AS id_0, p0_.jefe_cedula AS jefe_cedula_1, p0_.jefe_nombres AS jefe_nombres_2, p0_.jefe_apellidos AS jefe_apellidos_3, p0_.jefe_cargo AS jefe_cargo_4, p0_.jefe_grado AS jefe_grado_5, p0_.nombre_base AS nombre_base_6, b1_.id AS id_7, b1_.nombre AS nombre_8, b1_.direccion AS direccion_9, b1_.geometria AS geometria_10, b1_.activo AS activo_11, p0_.proceso AS proceso_12, p0_.base AS base_13, b1_.localizacion AS localizacion_14, b1_.jefe AS jefe_15 FROM proceso_reclutamiento_bases p0_ INNER JOIN proceso_reclutamiento p2_ ON p0_.proceso = p2_.id INNER JOIN base_movilizacion b1_ ON p0_.base = b1_.id WHERE p2_.id = 42 ORDER BY p0_.nombre_base ASC;

SELECT
  DISTINCT p0_.id AS id_0,
  p0_.anno AS anno_1,
  p0_.llamada AS llamada_2
FROM
  test_sistemas t1_
  INNER JOIN proceso_reclutamiento p0_ ON t1_.proceso = p0_.id
WHERE
  p0_.id <> 42

SELECT DISTINCT p0_.id AS id_0, p0_.anno AS anno_1, p0_.llamada AS llamada_2 FROM test_sistemas t1_ INNER JOIN proceso_reclutamiento p0_ ON t1_.proceso = p0_.id WHERE p0_.id <> 42;

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_.id <> 42
ORDER BY
  p0_.fecha_acuartelamiento DESC
LIMIT
  1

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_.id <> 42 ORDER BY p0_.fecha_acuartelamiento DESC LIMIT 1;

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
  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.id = ?

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.id = '42';

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_.activo = true
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_.activo = true ORDER BY u0_.nombre ASC;

SELECT
  CURRENT_DATABASE()

SELECT CURRENT_DATABASE();

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

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_.activo = true
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_.activo = true ORDER BY c0_.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_.activo = true
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_.activo = true ORDER BY b0_.nombre ASC;

SHOW search_path

SHOW search_path;