lkozien@ns3005792:/tmp/eaudyt$ tail -n 200 log.txt
        surveytemp9_.stt_name as stt_name5_25_10_,
        surveytemp9_.stt_short as stt_shor6_25_10_,
        surveytemp9_.stt_validation as stt_vali7_25_10_
    from
        ea_customer_surveys customersu0_
    left outer join
        ea_users user1_
            on customersu0_.cs_auditor2_usr_id=user1_.usr_id
    left outer join
        ea_user_authorities userauthor2_
            on user1_.usr_usra_id=userauthor2_.usra_id
    left outer join
        ea_documents document3_
            on user1_.usr_dcm_id=document3_.dcm_id
    left outer join
        ea_user_types usertype4_
            on user1_.usr_usrt_id=usertype4_.usrt_id
    left outer join
        ea_users user5_
            on customersu0_.cs_auditor_usr_id=user5_.usr_id
    left outer join
        ea_dict_report_states dictreport6_
            on customersu0_.cs_drst_id=dictreport6_.drst_id
    left outer join
        ea_dict_cs_states dictsurvey7_
            on customersu0_.cs_dcsst_id=dictsurvey7_.dcsst_id
    left outer join
        ea_survey_templates surveytemp8_
            on customersu0_.cs_st_id=surveytemp8_.st_id
    left outer join
        ea_survey_template_types surveytemp9_
            on customersu0_.cs_stt_id=surveytemp9_.stt_id
    where
        customersu0_.cs_customer_usr_id=?
Hibernate:
    select
        corporatio0_.crpusr_usr_id as crpusr_u2_4_0_,
        corporatio0_.crpusr_crp_id as crpusr_c1_4_0_,
        corporatio1_.crp_id as crp_id1_3_1_,
        corporatio1_.crp_account_number as crp_acco2_3_1_,
        corporatio1_.crp_active_flag as crp_acti3_3_1_,
        corporatio1_.crp_address as crp_addr4_3_1_,
        corporatio1_.crp_id_admin as crp_id_a5_3_1_,
        corporatio1_.crp_bank_name as crp_bank6_3_1_,
        corporatio1_.crp_city as crp_city7_3_1_,
        corporatio1_.crp_name as crp_name8_3_1_,
        corporatio1_.crp_curr_id as crp_curr9_3_1_,
        corporatio1_.crp_entered_timestamp as crp_ent10_3_1_,
        corporatio1_.crp_entered_usr_id as crp_ent11_3_1_,
        corporatio1_.crp_nip as crp_nip12_3_1_,
        corporatio1_.crp_postal_code as crp_pos13_3_1_
    from
        ea_crp_usr corporatio0_
    inner join
        ea_corporations corporatio1_
            on corporatio0_.crpusr_crp_id=corporatio1_.crp_id
    where
        corporatio0_.crpusr_usr_id=?
Hibernate:
    select
        userconnec0_.usc_id as usc_id1_2_,
        userconnec0_.usc_tkn as usc_tkn2_2_,
        userconnec0_.usc_usr_id as usc_usr_3_2_
    from
        ea_connected_users userconnec0_
    where
        userconnec0_.usc_tkn=?
Hibernate:
    select
        user0_.usr_id as usr_id1_30_0_,
        user0_.usr_accept_date as usr_acce2_30_0_,
        user0_.usr_street_address as usr_stre3_30_0_,
        user0_.usr_usra_id as usr_usr15_30_0_,
        user0_.usr_city as usr_city4_30_0_,
        user0_.usr_confirmation_code as usr_conf5_30_0_,
        user0_.usr_country as usr_coun6_30_0_,
        user0_.usr_dcm_id as usr_dcm16_30_0_,
        user0_.usr_email_address as usr_emai7_30_0_,
        user0_.usr_enabled as usr_enab8_30_0_,
        user0_.usr_session_id as usr_sess9_30_0_,
        user0_.usr_login_password as usr_log10_30_0_,
        user0_.usr_name as usr_nam11_30_0_,
        user0_.usr_postal_code as usr_pos12_30_0_,
        user0_.usr_active as usr_act13_30_0_,
        user0_.usr_surname as usr_sur14_30_0_,
        user0_.usr_usrt_id as usr_usr17_30_0_,
        userauthor1_.usra_id as usra_id1_28_1_,
        userauthor1_.usra_name as usra_nam2_28_1_,
        document2_.dcm_id as dcm_id1_13_2_,
        document2_.dcm_create_date as dcm_crea2_13_2_,
        document2_.dcm_code as dcm_code3_13_2_,
        document2_.dcm_name as dcm_name4_13_2_,
        document2_.dcm_version as dcm_vers5_13_2_,
        document2_.dcm_file as dcm_file6_13_2_,
        usertype3_.usrt_id as usrt_id1_29_3_,
        usertype3_.usrt_name as usrt_nam2_29_3_
    from
        ea_users user0_
    left outer join
        ea_user_authorities userauthor1_
            on user0_.usr_usra_id=userauthor1_.usra_id
    left outer join
        ea_documents document2_
            on user0_.usr_dcm_id=document2_.dcm_id
    left outer join
        ea_user_types usertype3_
            on user0_.usr_usrt_id=usertype3_.usrt_id
    where
        user0_.usr_id=?
Hibernate:
    select
        clientsurv0_.cs_id as cs_id1_31_,
        clientsurv0_.csprog as csprog2_31_,
        clientsurv0_.cscl_time as cscl_tim3_31_,
        clientsurv0_.drst_id as drst_id4_31_,
        clientsurv0_.drst_name as drst_nam5_31_,
        clientsurv0_.dcsst_code as dcsst_co6_31_,
        clientsurv0_.dcsst_id as dcsst_id7_31_,
        clientsurv0_.cs_number as cs_numbe8_31_,
        clientsurv0_.stt_name as stt_name9_31_,
        clientsurv0_.usr_email_address as usr_ema10_31_,
        clientsurv0_.usr_id as usr_id11_31_
    from
        v_client_surveys clientsurv0_
    where
        clientsurv0_.usr_id=?
    order by
        clientsurv0_.cs_id desc
2018-04-17 09:40:45.279 DEBUG 26974 --- [nio-8080-exec-2] c.h.e.services.CustomerSurveyService     : Lista ankiet został pobrana pomyślnie.
Hibernate:
    select
        userconnec0_.usc_id as usc_id1_2_,
        userconnec0_.usc_tkn as usc_tkn2_2_,
        userconnec0_.usc_usr_id as usc_usr_3_2_
    from
        ea_connected_users userconnec0_
    where
        userconnec0_.usc_tkn=?
Hibernate:
    select
        user0_.usr_id as usr_id1_30_0_,
        user0_.usr_accept_date as usr_acce2_30_0_,
        user0_.usr_street_address as usr_stre3_30_0_,
        user0_.usr_usra_id as usr_usr15_30_0_,
        user0_.usr_city as usr_city4_30_0_,
        user0_.usr_confirmation_code as usr_conf5_30_0_,
        user0_.usr_country as usr_coun6_30_0_,
        user0_.usr_dcm_id as usr_dcm16_30_0_,
        user0_.usr_email_address as usr_emai7_30_0_,
        user0_.usr_enabled as usr_enab8_30_0_,
        user0_.usr_session_id as usr_sess9_30_0_,
        user0_.usr_login_password as usr_log10_30_0_,
        user0_.usr_name as usr_nam11_30_0_,
        user0_.usr_postal_code as usr_pos12_30_0_,
        user0_.usr_active as usr_act13_30_0_,
        user0_.usr_surname as usr_sur14_30_0_,
        user0_.usr_usrt_id as usr_usr17_30_0_,
        userauthor1_.usra_id as usra_id1_28_1_,
        userauthor1_.usra_name as usra_nam2_28_1_,
        document2_.dcm_id as dcm_id1_13_2_,
        document2_.dcm_create_date as dcm_crea2_13_2_,
        document2_.dcm_code as dcm_code3_13_2_,
        document2_.dcm_name as dcm_name4_13_2_,
        document2_.dcm_version as dcm_vers5_13_2_,
        document2_.dcm_file as dcm_file6_13_2_,
        usertype3_.usrt_id as usrt_id1_29_3_,
        usertype3_.usrt_name as usrt_nam2_29_3_
    from
        ea_users user0_
    left outer join
        ea_user_authorities userauthor1_
            on user0_.usr_usra_id=userauthor1_.usra_id
    left outer join
        ea_documents document2_
            on user0_.usr_dcm_id=document2_.dcm_id
    left outer join
        ea_user_types usertype3_
            on user0_.usr_usrt_id=usertype3_.usrt_id
    where
        user0_.usr_id=?
Hibernate:
    select
        clientsurv0_.cs_id as cs_id1_31_,
        clientsurv0_.csprog as csprog2_31_,
        clientsurv0_.cscl_time as cscl_tim3_31_,
        clientsurv0_.drst_id as drst_id4_31_,
        clientsurv0_.drst_name as drst_nam5_31_,
        clientsurv0_.dcsst_code as dcsst_co6_31_,
        clientsurv0_.dcsst_id as dcsst_id7_31_,
        clientsurv0_.cs_number as cs_numbe8_31_,
        clientsurv0_.stt_name as stt_name9_31_,
        clientsurv0_.usr_email_address as usr_ema10_31_,
        clientsurv0_.usr_id as usr_id11_31_
    from
        v_client_surveys clientsurv0_
    where
        clientsurv0_.usr_id=?
    order by
        clientsurv0_.cs_id desc
2018-04-17 09:41:03.258 DEBUG 26974 --- [nio-8080-exec-8] c.h.e.services.CustomerSurveyService     : Lista ankiet został pobrana pomyślnie.