Symfony Profiler

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.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 = 5367;

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

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

SELECT
  t0.id AS id_1,
  t0.valor AS valor_2,
  t0.nivel_localizacion AS nivel_localizacion_3,
  t0.padre AS padre_4
FROM
  nmcl_dominio_localizacion t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.valor AS valor_2, t0.nivel_localizacion AS nivel_localizacion_3, t0.padre AS padre_4 FROM nmcl_dominio_localizacion t0 WHERE t0.id = 443;

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 = 5367
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 = 5367 ORDER BY n0_.asunto ASC, n0_.fecha_ingreso DESC;

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

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

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

SELECT
  t0.id AS id_1,
  t0.nombre_lugar AS nombre_lugar_2,
  t0.jefe_cedula AS jefe_cedula_3,
  t0.jefe_nombres AS jefe_nombres_4,
  t0.jefe_apellidos AS jefe_apellidos_5,
  t0.jefe_cargo AS jefe_cargo_6,
  t0.jefe_grado AS jefe_grado_7,
  t0.turno AS turno_8,
  t0.cupo_masculino AS cupo_masculino_9,
  t0.cupo_femenino AS cupo_femenino_10,
  t0.registrado_masculino AS registrado_masculino_11,
  t0.registrado_femenino AS registrado_femenino_12,
  t0.organico_masculino AS organico_masculino_13,
  t0.organico_femenino AS organico_femenino_14,
  t0.proceso AS proceso_15,
  t0.lugar AS lugar_16,
  t0.base AS base_17,
  t0.psicologo AS psicologo_18,
  t0.medico AS medico_19,
  t0.odontologo AS odontologo_20,
  t0.laboratorista AS laboratorista_21
FROM
  proceso_reclutamiento_lugar_base t0
WHERE
  t0.proceso = ?
  AND t0.lugar = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.nombre_lugar AS nombre_lugar_2, t0.jefe_cedula AS jefe_cedula_3, t0.jefe_nombres AS jefe_nombres_4, t0.jefe_apellidos AS jefe_apellidos_5, t0.jefe_cargo AS jefe_cargo_6, t0.jefe_grado AS jefe_grado_7, t0.turno AS turno_8, t0.cupo_masculino AS cupo_masculino_9, t0.cupo_femenino AS cupo_femenino_10, t0.registrado_masculino AS registrado_masculino_11, t0.registrado_femenino AS registrado_femenino_12, t0.organico_masculino AS organico_masculino_13, t0.organico_femenino AS organico_femenino_14, t0.proceso AS proceso_15, t0.lugar AS lugar_16, t0.base AS base_17, t0.psicologo AS psicologo_18, t0.medico AS medico_19, t0.odontologo AS odontologo_20, t0.laboratorista AS laboratorista_21 FROM proceso_reclutamiento_lugar_base t0 WHERE t0.proceso = 47 AND t0.lugar = 46 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.archivo AS archivo_2,
  t0.ruta AS ruta_3,
  t0.archivo_hash AS archivo_hash_4,
  t0.size AS size_5,
  t0.contenido AS contenido_6
FROM
  adjunto t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.archivo AS archivo_2, t0.ruta AS ruta_3, t0.archivo_hash AS archivo_hash_4, t0.size AS size_5, t0.contenido AS contenido_6 FROM adjunto t0 WHERE t0.id = 186322;

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
  CURRENT_DATABASE()

SELECT CURRENT_DATABASE();

SELECT
  t0.id AS id_1,
  t0.siglas_unidad AS siglas_unidad_2,
  t0.nombre AS nombre_3,
  t0.fuerza AS fuerza_4,
  t0.cupo_masculino AS cupo_masculino_5,
  t0.adicional_masculino AS adicional_masculino_6,
  t0.cupo_femenino AS cupo_femenino_7,
  t0.adicional_femenino AS adicional_femenino_8,
  t0.direccion AS direccion_9,
  t0.geometria AS geometria_10,
  t0.activo AS activo_11,
  t0.centro_instruccion AS centro_instruccion_12,
  t0.localizacion AS localizacion_13
FROM
  unidad_militar t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.siglas_unidad AS siglas_unidad_2, t0.nombre AS nombre_3, t0.fuerza AS fuerza_4, t0.cupo_masculino AS cupo_masculino_5, t0.adicional_masculino AS adicional_masculino_6, t0.cupo_femenino AS cupo_femenino_7, t0.adicional_femenino AS adicional_femenino_8, t0.direccion AS direccion_9, t0.geometria AS geometria_10, t0.activo AS activo_11, t0.centro_instruccion AS centro_instruccion_12, t0.localizacion AS localizacion_13 FROM unidad_militar t0 WHERE t0.id = 103;

SELECT
  t0.id AS id_1,
  t0.nombre AS nombre_2,
  t0.fuerza AS fuerza_3,
  t0.direccion AS direccion_4,
  t0.geometria AS geometria_5,
  t0.localizacion AS localizacion_6
FROM
  centro_instruccion t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.fuerza AS fuerza_3, t0.direccion AS direccion_4, t0.geometria AS geometria_5, t0.localizacion AS localizacion_6 FROM centro_instruccion t0 WHERE t0.id = 14;

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

SHOW search_path

SHOW search_path;