Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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.
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement