daily pastebin goal
11%
SHARE
TWEET

Untitled

a guest Apr 17th, 2018 55 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1.  
  2. lkozien@ns3005792:/tmp/eaudyt$ tail -n 200 log.txt
  3.         surveytemp9_.stt_name as stt_name5_25_10_,
  4.         surveytemp9_.stt_short as stt_shor6_25_10_,
  5.         surveytemp9_.stt_validation as stt_vali7_25_10_
  6.     from
  7.         ea_customer_surveys customersu0_
  8.     left outer join
  9.         ea_users user1_
  10.             on customersu0_.cs_auditor2_usr_id=user1_.usr_id
  11.     left outer join
  12.         ea_user_authorities userauthor2_
  13.             on user1_.usr_usra_id=userauthor2_.usra_id
  14.     left outer join
  15.         ea_documents document3_
  16.             on user1_.usr_dcm_id=document3_.dcm_id
  17.     left outer join
  18.         ea_user_types usertype4_
  19.             on user1_.usr_usrt_id=usertype4_.usrt_id
  20.     left outer join
  21.         ea_users user5_
  22.             on customersu0_.cs_auditor_usr_id=user5_.usr_id
  23.     left outer join
  24.         ea_dict_report_states dictreport6_
  25.             on customersu0_.cs_drst_id=dictreport6_.drst_id
  26.     left outer join
  27.         ea_dict_cs_states dictsurvey7_
  28.             on customersu0_.cs_dcsst_id=dictsurvey7_.dcsst_id
  29.     left outer join
  30.         ea_survey_templates surveytemp8_
  31.             on customersu0_.cs_st_id=surveytemp8_.st_id
  32.     left outer join
  33.         ea_survey_template_types surveytemp9_
  34.             on customersu0_.cs_stt_id=surveytemp9_.stt_id
  35.     where
  36.         customersu0_.cs_customer_usr_id=?
  37. Hibernate:
  38.     select
  39.         corporatio0_.crpusr_usr_id as crpusr_u2_4_0_,
  40.         corporatio0_.crpusr_crp_id as crpusr_c1_4_0_,
  41.         corporatio1_.crp_id as crp_id1_3_1_,
  42.         corporatio1_.crp_account_number as crp_acco2_3_1_,
  43.         corporatio1_.crp_active_flag as crp_acti3_3_1_,
  44.         corporatio1_.crp_address as crp_addr4_3_1_,
  45.         corporatio1_.crp_id_admin as crp_id_a5_3_1_,
  46.         corporatio1_.crp_bank_name as crp_bank6_3_1_,
  47.         corporatio1_.crp_city as crp_city7_3_1_,
  48.         corporatio1_.crp_name as crp_name8_3_1_,
  49.         corporatio1_.crp_curr_id as crp_curr9_3_1_,
  50.         corporatio1_.crp_entered_timestamp as crp_ent10_3_1_,
  51.         corporatio1_.crp_entered_usr_id as crp_ent11_3_1_,
  52.         corporatio1_.crp_nip as crp_nip12_3_1_,
  53.         corporatio1_.crp_postal_code as crp_pos13_3_1_
  54.     from
  55.         ea_crp_usr corporatio0_
  56.     inner join
  57.         ea_corporations corporatio1_
  58.             on corporatio0_.crpusr_crp_id=corporatio1_.crp_id
  59.     where
  60.         corporatio0_.crpusr_usr_id=?
  61. Hibernate:
  62.     select
  63.         userconnec0_.usc_id as usc_id1_2_,
  64.         userconnec0_.usc_tkn as usc_tkn2_2_,
  65.         userconnec0_.usc_usr_id as usc_usr_3_2_
  66.     from
  67.         ea_connected_users userconnec0_
  68.     where
  69.         userconnec0_.usc_tkn=?
  70. Hibernate:
  71.     select
  72.         user0_.usr_id as usr_id1_30_0_,
  73.         user0_.usr_accept_date as usr_acce2_30_0_,
  74.         user0_.usr_street_address as usr_stre3_30_0_,
  75.         user0_.usr_usra_id as usr_usr15_30_0_,
  76.         user0_.usr_city as usr_city4_30_0_,
  77.         user0_.usr_confirmation_code as usr_conf5_30_0_,
  78.         user0_.usr_country as usr_coun6_30_0_,
  79.         user0_.usr_dcm_id as usr_dcm16_30_0_,
  80.         user0_.usr_email_address as usr_emai7_30_0_,
  81.         user0_.usr_enabled as usr_enab8_30_0_,
  82.         user0_.usr_session_id as usr_sess9_30_0_,
  83.         user0_.usr_login_password as usr_log10_30_0_,
  84.         user0_.usr_name as usr_nam11_30_0_,
  85.         user0_.usr_postal_code as usr_pos12_30_0_,
  86.         user0_.usr_active as usr_act13_30_0_,
  87.         user0_.usr_surname as usr_sur14_30_0_,
  88.         user0_.usr_usrt_id as usr_usr17_30_0_,
  89.         userauthor1_.usra_id as usra_id1_28_1_,
  90.         userauthor1_.usra_name as usra_nam2_28_1_,
  91.         document2_.dcm_id as dcm_id1_13_2_,
  92.         document2_.dcm_create_date as dcm_crea2_13_2_,
  93.         document2_.dcm_code as dcm_code3_13_2_,
  94.         document2_.dcm_name as dcm_name4_13_2_,
  95.         document2_.dcm_version as dcm_vers5_13_2_,
  96.         document2_.dcm_file as dcm_file6_13_2_,
  97.         usertype3_.usrt_id as usrt_id1_29_3_,
  98.         usertype3_.usrt_name as usrt_nam2_29_3_
  99.     from
  100.         ea_users user0_
  101.     left outer join
  102.         ea_user_authorities userauthor1_
  103.             on user0_.usr_usra_id=userauthor1_.usra_id
  104.     left outer join
  105.         ea_documents document2_
  106.             on user0_.usr_dcm_id=document2_.dcm_id
  107.     left outer join
  108.         ea_user_types usertype3_
  109.             on user0_.usr_usrt_id=usertype3_.usrt_id
  110.     where
  111.         user0_.usr_id=?
  112. Hibernate:
  113.     select
  114.         clientsurv0_.cs_id as cs_id1_31_,
  115.         clientsurv0_.csprog as csprog2_31_,
  116.         clientsurv0_.cscl_time as cscl_tim3_31_,
  117.         clientsurv0_.drst_id as drst_id4_31_,
  118.         clientsurv0_.drst_name as drst_nam5_31_,
  119.         clientsurv0_.dcsst_code as dcsst_co6_31_,
  120.         clientsurv0_.dcsst_id as dcsst_id7_31_,
  121.         clientsurv0_.cs_number as cs_numbe8_31_,
  122.         clientsurv0_.stt_name as stt_name9_31_,
  123.         clientsurv0_.usr_email_address as usr_ema10_31_,
  124.         clientsurv0_.usr_id as usr_id11_31_
  125.     from
  126.         v_client_surveys clientsurv0_
  127.     where
  128.         clientsurv0_.usr_id=?
  129.     order by
  130.         clientsurv0_.cs_id desc
  131. 2018-04-17 09:40:45.279 DEBUG 26974 --- [nio-8080-exec-2] c.h.e.services.CustomerSurveyService     : Lista ankiet został pobrana pomyślnie.
  132. Hibernate:
  133.     select
  134.         userconnec0_.usc_id as usc_id1_2_,
  135.         userconnec0_.usc_tkn as usc_tkn2_2_,
  136.         userconnec0_.usc_usr_id as usc_usr_3_2_
  137.     from
  138.         ea_connected_users userconnec0_
  139.     where
  140.         userconnec0_.usc_tkn=?
  141. Hibernate:
  142.     select
  143.         user0_.usr_id as usr_id1_30_0_,
  144.         user0_.usr_accept_date as usr_acce2_30_0_,
  145.         user0_.usr_street_address as usr_stre3_30_0_,
  146.         user0_.usr_usra_id as usr_usr15_30_0_,
  147.         user0_.usr_city as usr_city4_30_0_,
  148.         user0_.usr_confirmation_code as usr_conf5_30_0_,
  149.         user0_.usr_country as usr_coun6_30_0_,
  150.         user0_.usr_dcm_id as usr_dcm16_30_0_,
  151.         user0_.usr_email_address as usr_emai7_30_0_,
  152.         user0_.usr_enabled as usr_enab8_30_0_,
  153.         user0_.usr_session_id as usr_sess9_30_0_,
  154.         user0_.usr_login_password as usr_log10_30_0_,
  155.         user0_.usr_name as usr_nam11_30_0_,
  156.         user0_.usr_postal_code as usr_pos12_30_0_,
  157.         user0_.usr_active as usr_act13_30_0_,
  158.         user0_.usr_surname as usr_sur14_30_0_,
  159.         user0_.usr_usrt_id as usr_usr17_30_0_,
  160.         userauthor1_.usra_id as usra_id1_28_1_,
  161.         userauthor1_.usra_name as usra_nam2_28_1_,
  162.         document2_.dcm_id as dcm_id1_13_2_,
  163.         document2_.dcm_create_date as dcm_crea2_13_2_,
  164.         document2_.dcm_code as dcm_code3_13_2_,
  165.         document2_.dcm_name as dcm_name4_13_2_,
  166.         document2_.dcm_version as dcm_vers5_13_2_,
  167.         document2_.dcm_file as dcm_file6_13_2_,
  168.         usertype3_.usrt_id as usrt_id1_29_3_,
  169.         usertype3_.usrt_name as usrt_nam2_29_3_
  170.     from
  171.         ea_users user0_
  172.     left outer join
  173.         ea_user_authorities userauthor1_
  174.             on user0_.usr_usra_id=userauthor1_.usra_id
  175.     left outer join
  176.         ea_documents document2_
  177.             on user0_.usr_dcm_id=document2_.dcm_id
  178.     left outer join
  179.         ea_user_types usertype3_
  180.             on user0_.usr_usrt_id=usertype3_.usrt_id
  181.     where
  182.         user0_.usr_id=?
  183. Hibernate:
  184.     select
  185.         clientsurv0_.cs_id as cs_id1_31_,
  186.         clientsurv0_.csprog as csprog2_31_,
  187.         clientsurv0_.cscl_time as cscl_tim3_31_,
  188.         clientsurv0_.drst_id as drst_id4_31_,
  189.         clientsurv0_.drst_name as drst_nam5_31_,
  190.         clientsurv0_.dcsst_code as dcsst_co6_31_,
  191.         clientsurv0_.dcsst_id as dcsst_id7_31_,
  192.         clientsurv0_.cs_number as cs_numbe8_31_,
  193.         clientsurv0_.stt_name as stt_name9_31_,
  194.         clientsurv0_.usr_email_address as usr_ema10_31_,
  195.         clientsurv0_.usr_id as usr_id11_31_
  196.     from
  197.         v_client_surveys clientsurv0_
  198.     where
  199.         clientsurv0_.usr_id=?
  200.     order by
  201.         clientsurv0_.cs_id desc
  202. 2018-04-17 09:41:03.258 DEBUG 26974 --- [nio-8080-exec-8] c.h.e.services.CustomerSurveyService     : Lista ankiet został pobrana pomyślnie.
RAW Paste Data
Top