API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Aug 2nd, 2018
170
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 53.11 KB | None | 0 0
raw download clone embed print report
  1. 17:14:17,000 [getList] DEBUG ==> Parameters: 00000000000002358587(String)
  2. 17:14:17,001 [getList] DEBUG <== Total: 1
  3. 17:14:17,001 [getList] DEBUG ==> Preparing: SELECT * FROM AS_FIN_ACCOUNT WHERE MEMBER_ID = ?
  4. 17:14:17,001 [getList] DEBUG ==> Parameters: 00000000000002358587(String)
  5. 17:14:17,003 [getList] DEBUG <== Total: 1
  6. 17:14:17,003 [getList] DEBUG ==> Preparing: SELECT * FROM AS_INVEST_ACCOUNT WHERE MEMBER_ID = ?
  7. 17:14:17,003 [getList] DEBUG ==> Parameters: 00000000000002358587(String)
  8. 17:14:17,004 [getList] DEBUG <== Total: 1
  9. 17:14:17,005 [getList] DEBUG ==> Preparing: SELECT * FROM FU_BANK_BIND WHERE FUND_ACCOUNT_ID = ? AND STATE = ?
  10. 17:14:17,005 [getList] DEBUG ==> Parameters: 00000000000002358593(String), 1(String)
  11. 17:14:17,006 [getList] DEBUG <== Total: 1
  12. 17:14:17,006 [get] DEBUG ==> Preparing: SELECT * FROM FU_BANK_BIND WHERE BANK_BIND_ID = ?
  13. 17:14:17,006 [get] DEBUG ==> Parameters: 00000000000002359455(String)
  14. 17:14:17,007 [get] DEBUG <== Total: 1
  15. 17:14:17,007 [remove] DEBUG ==> Preparing: DELETE FROM FU_BANK_BIND WHERE BANK_BIND_ID = ?
  16. 17:14:17,007 [remove] DEBUG ==> Parameters: 00000000000002359455(String)
  17. 17:14:17,014 [remove] DEBUG <== Updates: 1
  18. 17:14:17,014 [get] DEBUG ==> Preparing: SELECT * FROM FU_FUND_ACCOUNT WHERE FUND_ACCOUNT_ID = ?
  19. 17:14:17,015 [get] DEBUG ==> Parameters: 00000000000002358593(String)
  20. 17:14:17,018 [get] DEBUG <== Total: 1
  21. 17:14:17,018 [get] DEBUG ==> Preparing: SELECT * FROM FU_FUND_ACCOUNT WHERE FUND_ACCOUNT_ID = ?
  22. 17:14:17,018 [get] DEBUG ==> Parameters: 00000000000002358593(String)
  23. 17:14:17,019 [get] DEBUG <== Total: 1
  24. 17:14:17,019 [update] DEBUG ==> Preparing: UPDATE FU_FUND_ACCOUNT SET MEMBER_ID = ?, BANK_CODE = ?, DEPOSIT_BANK = ?, PARENT_FUND_ACCOUNT_ID = ?, ACCT_TYPE = ?, ACCT_BAL = ?, USABLE_BAL = ?, IS_FREZ = ?, FREZ_AMT = ?, TRANSIT_AMT = ?, SECRET_COMPRESSION = ?, CREATE_TIME = ?, MODIFY_TIME = ? WHERE FUND_ACCOUNT_ID = ?
  25. 17:14:17,020 [update] DEBUG ==> Parameters: 00000000000002358587(String), (String), (String), (String), 0(String), 0(BigDecimal), 0(BigDecimal), (String), 0(BigDecimal), 0(BigDecimal), 000000000000023585930.000.00(String), 2018-08-01 16:33:34.157(Timestamp), 2018-08-02 17:14:17.014(Timestamp), 00000000000002358593(String)
  26. 17:14:17,028 [update] DEBUG <== Updates: 1
  27. 17:14:17,029 [get] DEBUG ==> Preparing: SELECT * FROM PM_COMMON_LOG WHERE COMMONLOG_ID = ?
  28. 17:14:17,029 [get] DEBUG ==> Parameters: (String)
  29. 17:14:17,030 [get] DEBUG <== Total: 0
  30. 17:14:17,030 [add!selectKey] DEBUG ==> Preparing: SELECT SUBSTR(TO_CHAR(seq_common.nextval,'00000000000000000000'),2,21) FROM DUAL
  31. 17:14:17,030 [add!selectKey] DEBUG ==> Parameters:
  32. 17:14:17,031 [add!selectKey] DEBUG <== Total: 1
  33. 17:14:17,031 [add] DEBUG ==> Preparing: INSERT INTO PM_COMMON_LOG ( COMMONLOG_ID, MEMBER_ID, LOG_TYPE, OPER_DESCRIBE, OPERATOR_IP, OPERATOR, OPER_CHANNEL, MODIFY_TIME, CREATE_TIME ) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ? )
  34. 17:14:17,031 [add] DEBUG ==> Parameters: 00000000000002359487(String), 00000000000002358587(String), 2(String), 解除绑定银行卡，解除与尾号|8602的银行卡的绑定(String), (String), B13780(String), 1(String), 2018-08-02 17:14:17.029(Timestamp), 2018-08-02 17:14:17.029(Timestamp)
  35. 17:14:17,037 [add] DEBUG <== Updates: 1
  36. 17:14:17,360 [AccessMonitorFilter] INFO Time[1533201257360] Id[2305] ThreadId[http-bio-8080-exec-8] Type[begin] RequestURI[/ts/xcom/rbac/logoutAction.do] params[logout=1]
  37. 17:14:17,363 [AccessMonitorFilter] INFO Time[1533201257363] Id[2305] ThreadId[http-bio-8080-exec-8] Type[end] Message[交易执行 0 秒。]
  38. 17:14:18,673 [TcpNetConnection] ERROR Read exception 192.168.93.50:9108:55461:6858b90f-b5fc-49fc-a9d9-af635fe938af SocketException:Connection reset
  39. 17:14:22,091 [AccessMonitorFilter] INFO Time[1533201262091] Id[2306] ThreadId[http-bio-8080-exec-21] Type[begin] RequestURI[/ts/xcom/rbac/loginAction.do] params[groupId=&loginName=weifei&flag=true]
  40. 17:14:22,094 [AccessMonitorFilter] INFO Time[1533201262094] Id[2306] ThreadId[http-bio-8080-exec-21] Type[end] Message[交易执行 0 秒。]
  41. 17:14:22,117 [AccessMonitorFilter] INFO Time[1533201262117] Id[2307] ThreadId[http-bio-8080-exec-4] Type[begin] RequestURI[/ts/xcom/rbac/loginAction.do] params[password=511B0D5F341BDDBD9A5348923B48D14C&groupId=&signCode=&loginName=weifei&passwordA=1&attachCode=&showAttachCode=0&rmbUser=on]
  42. 17:14:22,142 [AccessMonitorFilter] INFO Time[1533201262142] Id[2307] ThreadId[http-bio-8080-exec-4] Type[end] Message[交易执行 0 秒。]
  43. 17:14:22,147 [AccessMonitorFilter] INFO Time[1533201262147] Id[2308] ThreadId[http-bio-8080-exec-20] Type[begin] RequestURI[/ts/skins/index/desktopLR.jsp] params[]
  44. 17:14:22,148 [AccessMonitorFilter] INFO Time[1533201262148] Id[2308] ThreadId[http-bio-8080-exec-20] Type[end] Message[交易执行 0 秒。]
  45. 17:14:22,779 [AccessMonitorFilter] INFO Time[1533201262779] Id[2309] ThreadId[http-bio-8080-exec-2] Type[begin] RequestURI[/ts/skins/index/menu.jsp] params[1533201305592=]
  46. 17:14:22,840 [AccessMonitorFilter] INFO Time[1533201262840] Id[2309] ThreadId[http-bio-8080-exec-2] Type[end] Message[交易执行 0 秒。]
  47. 17:14:23,024 [AccessMonitorFilter] INFO Time[1533201263024] Id[2310] ThreadId[http-bio-8080-exec-30] Type[begin] RequestURI[/ts/skins/normal/index.jsp] params[]
  48. 17:14:23,026 [AccessMonitorFilter] INFO Time[1533201263026] Id[2310] ThreadId[http-bio-8080-exec-30] Type[end] Message[交易执行 0 秒。]
  49. 17:14:23,060 [AccessMonitorFilter] INFO Time[1533201263060] Id[2311] ThreadId[http-bio-8080-exec-24] Type[begin] RequestURI[/ts/skins/normal/common.jsp] params[]
  50. 17:14:23,060 [AccessMonitorFilter] INFO Time[1533201263060] Id[2311] ThreadId[http-bio-8080-exec-24] Type[end] Message[交易执行 0 秒。]
  51. 17:14:23,483 [AccessMonitorFilter] INFO Time[1533201263483] Id[2312] ThreadId[http-bio-8080-exec-5] Type[begin] RequestURI[/ts/pm/individualNavLoad.do] params[operAtt=init&1533201306104=]
  52. 17:14:23,486 [JDao] DEBUG [SQL]:SELECT USERID,MENUID,ICONCLASS,NAVCLASS,OPENTYPE,EXT1,EXT2,EXT3,EXT4 FROM RBAC_INDIVIDUAL_VIEW_EXT WHERE userId=? AND menuId=?
  53. 17:14:23,487 [JDao] DEBUG [Params]:[00000100002, 00000001180]
  54. 17:14:23,488 [JDao] DEBUG [SQL]:SELECT USERID,MENUID,ICONCLASS,NAVCLASS,OPENTYPE,EXT1,EXT2,EXT3,EXT4 FROM RBAC_INDIVIDUAL_VIEW_EXT WHERE userId=? AND menuId=?
  55. 17:14:23,488 [JDao] DEBUG [Params]:[00000100002, 00000001267]
  56. 17:14:23,490 [JDao] DEBUG [SQL]:SELECT USERID,MENUID,ICONCLASS,NAVCLASS,OPENTYPE,EXT1,EXT2,EXT3,EXT4 FROM RBAC_INDIVIDUAL_VIEW_EXT WHERE userId=? AND menuId=?
  57. 17:14:23,490 [JDao] DEBUG [Params]:[00000100002, 00000001371]
  58. 17:14:23,491 [JDao] DEBUG [SQL]:SELECT USERID,MENUID,ICONCLASS,NAVCLASS,OPENTYPE,EXT1,EXT2,EXT3,EXT4 FROM RBAC_INDIVIDUAL_VIEW_EXT WHERE userId=? AND menuId=?
  59. 17:14:23,491 [JDao] DEBUG [Params]:[00000100002, 00000001372]
  60. 17:14:23,493 [JDao] DEBUG [SQL]:SELECT USERID,MENUID,ICONCLASS,NAVCLASS,OPENTYPE,EXT1,EXT2,EXT3,EXT4 FROM RBAC_INDIVIDUAL_VIEW_EXT WHERE userId=? AND menuId=?
  61. 17:14:23,493 [JDao] DEBUG [Params]:[00000100002, 00000001391]
  62. 17:14:23,494 [JDao] DEBUG [SQL]:SELECT USERID,MENUID,ICONCLASS,NAVCLASS,OPENTYPE,EXT1,EXT2,EXT3,EXT4 FROM RBAC_INDIVIDUAL_VIEW_EXT WHERE userId=? AND menuId=?
  63. 17:14:23,494 [JDao] DEBUG [Params]:[00000100002, 00000001393]
  64. 17:14:23,496 [AccessMonitorFilter] INFO Time[1533201263496] Id[2312] ThreadId[http-bio-8080-exec-5] Type[end] Message[交易执行 0 秒。]
  65. 17:14:26,400 [get] DEBUG ==> Preparing: SELECT * FROM ME_MEMBER WHERE MEMBER_ID = ?
  66. 17:14:26,400 [get] DEBUG ==> Parameters: 00000000000002358587(String)
  67. 17:14:26,402 [get] DEBUG <== Total: 1
  68. 17:14:26,402 [getList] DEBUG ==> Preparing: SELECT * FROM ME_MEMBER_PERSON WHERE MEMBER_ID = ?
  69. 17:14:26,402 [getList] DEBUG ==> Parameters: 00000000000002358587(String)
  70. 17:14:26,403 [getList] DEBUG <== Total: 1
  71. 17:14:26,411 [getList] DEBUG ==> Preparing: SELECT * FROM FU_FUND_ACCOUNT WHERE MEMBER_ID = ?
  72. 17:14:26,411 [getList] DEBUG ==> Parameters: 00000000000002358587(String)
  73. 17:14:26,412 [getList] DEBUG <== Total: 1
  74. 17:14:26,419 [getList] DEBUG ==> Preparing: SELECT * FROM FU_FUND_ACCOUNT WHERE MEMBER_ID = ?
  75. 17:14:26,419 [getList] DEBUG ==> Parameters: 00000000000002358587(String)
  76. 17:14:26,420 [getList] DEBUG <== Total: 1
  77. 17:14:30,391 [AccessMonitorFilter] INFO Time[1533201270391] Id[2313] ThreadId[http-bio-8080-exec-21] Type[begin] RequestURI[/ts/xcom/rbac/logoutAction.do] params[logout=1]
  78. 17:14:30,395 [AccessMonitorFilter] INFO Time[1533201270395] Id[2313] ThreadId[http-bio-8080-exec-21] Type[end] Message[交易执行 0 秒。]
  79. 17:14:37,464 [count] DEBUG ==> Preparing: SELECT COUNT(*) FROM MESS_MESSAGE m join MESS_RECIEVER r on m.ID=r.MESSAGEID WHERE r.STATUS != '2' AND r.USERID=? AND m.ISSDATE >= ? AND ? >= m.ISSDATE
  80. 17:14:37,464 [count] DEBUG ==> Parameters: 00000000000002358587(String), 2018-05-02 17:14:37.464(Timestamp), 2018-08-02 17:14:37.464(Timestamp)
  81. 17:14:37,467 [count] DEBUG <== Total: 1
  82. 17:14:37,468 [getPageList] DEBUG ==> Preparing: SELECT * FROM (SELECT t.*, ROWNUM RN FROM (SELECT r.MESSAGEID,r.STATUS,m.CONTENT,m.ISSDATE,m.TITLE,m.SOURCE FROM MESS_MESSAGE m join MESS_RECIEVER r on m.ID=r.MESSAGEID WHERE m.ID IN (SELECT distinct MESSAGEID FROM MESS_RECIEVER WHERE STATUS != '2' AND USERID=?) AND m.ISSDATE >= ? AND ? >= m.ISSDATE ORDER BY m.ISSDATE DESC ) t WHERE ?>= ROWNUM ) WHERE RN > ?
  83. 17:14:37,468 [getPageList] DEBUG ==> Parameters: 00000000000002358587(String), 2018-05-02 17:14:37.464(Timestamp), 2018-08-02 17:14:37.464(Timestamp), 50(Integer), 0(Integer)
  84. 17:14:37,472 [getPageList] DEBUG <== Total: 6
  85. 17:14:37,473 [getNotReadMsgCnt] DEBUG ==> Preparing: SELECT COUNT(*) FROM MESS_MESSAGE m join MESS_RECIEVER r on m.ID=r.MESSAGEID WHERE r.STATUS ='0' AND r.USERID=? AND m.ISSDATE >= ? AND ? >= m.ISSDATE
  86. 17:14:37,473 [getNotReadMsgCnt] DEBUG ==> Parameters: 00000000000002358587(String), 2018-05-02 17:14:37.464(Timestamp), 2018-08-02 17:14:37.464(Timestamp)
  87. 17:14:37,476 [getNotReadMsgCnt] DEBUG <== Total: 1
  88. 17:14:37,602 [get] DEBUG ==> Preparing: SELECT * FROM ME_MEMBER WHERE MEMBER_ID = ?
  89. 17:14:37,602 [get] DEBUG ==> Parameters: 00000000000002358587(String)
  90. 17:14:37,604 [get] DEBUG <== Total: 1
  91. 17:14:37,604 [getList] DEBUG ==> Preparing: SELECT * FROM FU_FUND_ACCOUNT WHERE MEMBER_ID = ?
  92. 17:14:37,604 [getList] DEBUG ==> Parameters: 00000000000002358587(String)
  93. 17:14:37,605 [getList] DEBUG <== Total: 1
  94. 17:14:37,605 [getList] DEBUG ==> Preparing: SELECT * FROM FU_BANK_BIND WHERE FUND_ACCOUNT_ID = ? AND STATE = ?
  95. 17:14:37,605 [getList] DEBUG ==> Parameters: 00000000000002358593(String), 1(String)
  96. 17:14:37,606 [getList] DEBUG <== Total: 0
  97. 17:14:37,606 [getList] DEBUG ==> Preparing: SELECT * FROM ME_MEMBER_VOUCHER WHERE MEMBER_ID = ? AND VOUCHER_STAT = ?
  98. 17:14:37,607 [getList] DEBUG ==> Parameters: 00000000000002358587(String), 0(String)
  99. 17:14:37,609 [getList] DEBUG <== Total: 10
  100. 17:14:38,880 [getList] DEBUG ==> Preparing: SELECT * FROM FU_FUND_ACCOUNT WHERE MEMBER_ID = ?
  101. 17:14:38,880 [getList] DEBUG ==> Parameters: 00000000000002358587(String)
  102. 17:14:38,881 [getList] DEBUG <== Total: 1
  103. 17:14:38,889 [get] DEBUG ==> Preparing: SELECT * FROM ME_MEMBER WHERE MEMBER_ID = ?
  104. 17:14:38,889 [get] DEBUG ==> Parameters: 00000000000002358587(String)
  105. 17:14:38,890 [get] DEBUG <== Total: 1
  106. 17:14:48,673 [TcpNetConnection] ERROR Read exception 192.168.93.50:9108:55643:033426bd-63a5-4f58-8301-a174cb46f581 SocketException:Connection reset
  107. 17:14:53,778 [getList] DEBUG ==> Preparing: SELECT * FROM FU_FUND_ACCOUNT WHERE MEMBER_ID = ?
  108. 17:14:53,778 [getList] DEBUG ==> Parameters: 00000000000000156195(String)
  109. 17:14:53,780 [getList] DEBUG <== Total: 1
  110. 17:14:53,780 [getList] DEBUG ==> Preparing: SELECT * FROM FU_BANK_BIND WHERE FUND_ACCOUNT_ID = ? AND STATE = ? AND IS_BAND_AGAIN = ?
  111. 17:14:53,780 [getList] DEBUG ==> Parameters: 00000000000000156201(String), 1(String), F(String)
  112. 17:14:53,781 [getList] DEBUG <== Total: 1
  113. 17:14:53,781 [get] DEBUG ==> Preparing: SELECT * FROM ME_MEMBER WHERE MEMBER_ID = ?
  114. 17:14:53,781 [get] DEBUG ==> Parameters: 00000000000000156195(String)
  115. 17:14:53,783 [get] DEBUG <== Total: 1
  116. 17:14:53,783 [get] DEBUG ==> Preparing: SELECT * FROM ME_MEMBER WHERE MEMBER_ID = ?
  117. 17:14:53,783 [get] DEBUG ==> Parameters: 00000000000000156195(String)
  118. 17:14:53,784 [get] DEBUG <== Total: 1
  119. 17:14:53,809 [getList] DEBUG ==> Preparing: SELECT * FROM PM_DEVICE WHERE MEMBER_ID = ?
  120. 17:14:53,809 [getList] DEBUG ==> Parameters: 00000000000000156195(String)
  121. 17:14:53,810 [getList] DEBUG <== Total: 1
  122. 17:14:53,811 [get] DEBUG ==> Preparing: SELECT * FROM PM_DEVICE WHERE ID = ?
  123. 17:14:53,811 [get] DEBUG ==> Parameters: 00000000000000274579(String)
  124. 17:14:53,812 [get] DEBUG <== Total: 1
  125. 17:14:53,812 [update] DEBUG ==> Preparing: UPDATE PM_DEVICE SET ID = ?, MEMBER_ID = ?, DEVICE_NUMBER = ?, DEVICE_TYPE = ?, CREATE_TIME = ?, MODIFY_TIME = ? WHERE ID = ?
  126. 17:14:53,812 [update] DEBUG ==> Parameters: 00000000000000274579(String), 00000000000000156195(String), 49e61b0026e3a32797476f4cb9facbb2(String), 2(String), 2017-03-29 08:42:36.388(Timestamp), 2018-08-02 17:14:53.811(Timestamp), 00000000000000274579(String)
  127. 17:14:53,820 [update] DEBUG <== Updates: 1
  128. 17:14:56,997 [count] DEBUG ==> Preparing: SELECT COUNT(*) FROM MESS_MESSAGE m join MESS_RECIEVER r on m.ID=r.MESSAGEID WHERE r.STATUS != '2' AND r.USERID=? AND m.ISSDATE >= ? AND ? >= m.ISSDATE
  129. 17:14:56,998 [count] DEBUG ==> Parameters: 00000000000000156195(String), 2018-05-02 17:14:56.997(Timestamp), 2018-08-02 17:14:56.997(Timestamp)
  130. 17:14:57,003 [count] DEBUG <== Total: 1
  131. 17:14:57,003 [getPageList] DEBUG ==> Preparing: SELECT * FROM (SELECT t.*, ROWNUM RN FROM (SELECT r.MESSAGEID,r.STATUS,m.CONTENT,m.ISSDATE,m.TITLE,m.SOURCE FROM MESS_MESSAGE m join MESS_RECIEVER r on m.ID=r.MESSAGEID WHERE m.ID IN (SELECT distinct MESSAGEID FROM MESS_RECIEVER WHERE STATUS != '2' AND USERID=?) AND m.ISSDATE >= ? AND ? >= m.ISSDATE ORDER BY m.ISSDATE DESC ) t WHERE ?>= ROWNUM ) WHERE RN > ?
  132. 17:14:57,003 [getPageList] DEBUG ==> Parameters: 00000000000000156195(String), 2018-05-02 17:14:56.997(Timestamp), 2018-08-02 17:14:56.997(Timestamp), 50(Integer), 0(Integer)
  133. 17:14:57,010 [getPageList] DEBUG <== Total: 6
  134. 17:14:57,010 [getNotReadMsgCnt] DEBUG ==> Preparing: SELECT COUNT(*) FROM MESS_MESSAGE m join MESS_RECIEVER r on m.ID=r.MESSAGEID WHERE r.STATUS ='0' AND r.USERID=? AND m.ISSDATE >= ? AND ? >= m.ISSDATE
  135. 17:14:57,010 [getNotReadMsgCnt] DEBUG ==> Parameters: 00000000000000156195(String), 2018-05-02 17:14:56.997(Timestamp), 2018-08-02 17:14:56.997(Timestamp)
  136. 17:14:57,014 [getNotReadMsgCnt] DEBUG <== Total: 1
  137. 17:14:57,204 [get] DEBUG ==> Preparing: SELECT * FROM ME_MEMBER WHERE MEMBER_ID = ?
  138. 17:14:57,204 [get] DEBUG ==> Parameters: 00000000000000156195(String)
  139. 17:14:57,205 [get] DEBUG <== Total: 1
  140. 17:14:57,206 [getList] DEBUG ==> Preparing: SELECT * FROM FU_FUND_ACCOUNT WHERE MEMBER_ID = ?
  141. 17:14:57,206 [getList] DEBUG ==> Parameters: 00000000000000156195(String)
  142. 17:14:57,208 [getList] DEBUG <== Total: 1
  143. 17:14:57,208 [getList] DEBUG ==> Preparing: SELECT * FROM FU_BANK_BIND WHERE FUND_ACCOUNT_ID = ? AND STATE = ?
  144. 17:14:57,208 [getList] DEBUG ==> Parameters: 00000000000000156201(String), 1(String)
  145. 17:14:57,209 [getList] DEBUG <== Total: 1
  146. 17:14:57,209 [getList] DEBUG ==> Preparing: SELECT * FROM ME_MEMBER_VOUCHER WHERE MEMBER_ID = ? AND VOUCHER_STAT = ?
  147. 17:14:57,209 [getList] DEBUG ==> Parameters: 00000000000000156195(String), 0(String)
  148. 17:14:57,211 [getList] DEBUG <== Total: 4
  149. 17:14:57,211 [getList] DEBUG ==> Preparing: SELECT * FROM FU_MEMBER_BANK WHERE BANK_CODE = ?
  150. 17:14:57,211 [getList] DEBUG ==> Parameters: CBC(String)
  151. 17:14:57,212 [getList] DEBUG <== Total: 0
  152. 17:14:58,652 [get] DEBUG ==> Preparing: SELECT * FROM ME_MEMBER WHERE MEMBER_ID = ?
  153. 17:14:58,652 [get] DEBUG ==> Parameters: 00000000000000156195(String)
  154. 17:14:58,653 [get] DEBUG <== Total: 1
  155. 17:14:58,654 [getList] DEBUG ==> Preparing: SELECT * FROM FU_FUND_ACCOUNT WHERE MEMBER_ID = ?
  156. 17:14:58,654 [getList] DEBUG ==> Parameters: 00000000000000156195(String)
  157. 17:14:58,655 [getList] DEBUG <== Total: 1
  158. 17:14:58,655 [getList] DEBUG ==> Preparing: SELECT * FROM FU_BANK_BIND WHERE FUND_ACCOUNT_ID = ? AND STATE = ?
  159. 17:14:58,655 [getList] DEBUG ==> Parameters: 00000000000000156201(String), 1(String)
  160. 17:14:58,656 [getList] DEBUG <== Total: 1
  161. 17:14:58,657 [getList] DEBUG ==> Preparing: SELECT * FROM ME_MEMBER_VOUCHER WHERE MEMBER_ID = ? AND VOUCHER_STAT = ?
  162. 17:14:58,657 [getList] DEBUG ==> Parameters: 00000000000000156195(String), 0(String)
  163. 17:14:58,658 [getList] DEBUG <== Total: 4
  164. 17:14:58,658 [getList] DEBUG ==> Preparing: SELECT * FROM FU_MEMBER_BANK WHERE BANK_CODE = ?
  165. 17:14:58,658 [getList] DEBUG ==> Parameters: CBC(String)
  166. 17:14:58,659 [getList] DEBUG <== Total: 0
  167. 17:15:03,212 [findRunningWithDrawInfo] DEBUG ==> Preparing: SELECT COUNT(*) FROM PM_DATA_RECORD R WHERE R.BUSINESS_ID IN (SELECT F.FUND_TRANS_FLOW_ID FROM FU_FUND_TRANS_FLOW F WHERE F.FUND_ACCOUNT_ID = (SELECT A.FUND_ACCOUNT_ID FROM FU_FUND_ACCOUNT A WHERE A.MEMBER_ID = ?) AND F.TRADE_CODE = '02') AND R.DATA_TYPE = '0007' AND R.DATA_STATE != '3'
  168. 17:15:03,212 [findRunningWithDrawInfo] DEBUG ==> Parameters: 00000000000000156195(String)
  169. 17:15:03,216 [findRunningWithDrawInfo] DEBUG <== Total: 1
  170.  
  171.  
  172.  
  173.  
  174.  
  175.  
  176.  
  177.  
  178. 17:15:18,672 [TcpNetConnection] ERROR Read exception 192.168.93.50:9108:55681:a6e4d052-3540-45d9-8ae2-58493f6bf50f SocketException:Connection reset
  179.  
  180.  
  181.  
  182.  
  183.  
  184.  
  185.  
  186.  
  187.  
  188.  
  189.  
  190.  
  191.  
  192.  
  193.  
  194.  
  195.  
  196.  
  197.  
  198.  
  199.  
  200.  
  201.  
  202. ^C
  203. [root@orderer logs]# pwd
  204. /lvdata/tomcat/ts/apache-tomcat-7.0.69/logs
  205. [root@orderer logs]# tail -f catalina.out
  206. 17:14:58,657 [getList] DEBUG ==> Preparing: SELECT * FROM ME_MEMBER_VOUCHER WHERE MEMBER_ID = ? AND VOUCHER_STAT = ?
  207. 17:14:58,657 [getList] DEBUG ==> Parameters: 00000000000000156195(String), 0(String)
  208. 17:14:58,658 [getList] DEBUG <== Total: 4
  209. 17:14:58,658 [getList] DEBUG ==> Preparing: SELECT * FROM FU_MEMBER_BANK WHERE BANK_CODE = ?
  210. 17:14:58,658 [getList] DEBUG ==> Parameters: CBC(String)
  211. 17:14:58,659 [getList] DEBUG <== Total: 0
  212. 17:15:03,212 [findRunningWithDrawInfo] DEBUG ==> Preparing: SELECT COUNT(*) FROM PM_DATA_RECORD R WHERE R.BUSINESS_ID IN (SELECT F.FUND_TRANS_FLOW_ID FROM FU_FUND_TRANS_FLOW F WHERE F.FUND_ACCOUNT_ID = (SELECT A.FUND_ACCOUNT_ID FROM FU_FUND_ACCOUNT A WHERE A.MEMBER_ID = ?) AND F.TRADE_CODE = '02') AND R.DATA_TYPE = '0007' AND R.DATA_STATE != '3'
  213. 17:15:03,212 [findRunningWithDrawInfo] DEBUG ==> Parameters: 00000000000000156195(String)
  214. 17:15:03,216 [findRunningWithDrawInfo] DEBUG <== Total: 1
  215. 17:15:18,672 [TcpNetConnection] ERROR Read exception 192.168.93.50:9108:55681:a6e4d052-3540-45d9-8ae2-58493f6bf50f SocketException:Connection reset
  216.  
  217.  
  218.  
  219.  
  220.  
  221.  
  222.  
  223.  
  224.  
  225.  
  226.  
  227.  
  228.  
  229.  
  230.  
  231. 17:15:29,340 [findRunningWithDrawInfo] DEBUG ==> Preparing: SELECT COUNT(*) FROM PM_DATA_RECORD R WHERE R.BUSINESS_ID IN (SELECT F.FUND_TRANS_FLOW_ID FROM FU_FUND_TRANS_FLOW F WHERE F.FUND_ACCOUNT_ID = (SELECT A.FUND_ACCOUNT_ID FROM FU_FUND_ACCOUNT A WHERE A.MEMBER_ID = ?) AND F.TRADE_CODE = '02') AND R.DATA_TYPE = '0007' AND R.DATA_STATE != '3'
  232. 17:15:29,340 [findRunningWithDrawInfo] DEBUG ==> Parameters: 00000000000000156195(String)
  233. 17:15:29,343 [findRunningWithDrawInfo] DEBUG <== Total: 1
  234. 17:15:35,401 [findRunningWithDrawInfo] DEBUG ==> Preparing: SELECT COUNT(*) FROM PM_DATA_RECORD R WHERE R.BUSINESS_ID IN (SELECT F.FUND_TRANS_FLOW_ID FROM FU_FUND_TRANS_FLOW F WHERE F.FUND_ACCOUNT_ID = (SELECT A.FUND_ACCOUNT_ID FROM FU_FUND_ACCOUNT A WHERE A.MEMBER_ID = ?) AND F.TRADE_CODE = '02') AND R.DATA_TYPE = '0007' AND R.DATA_STATE != '3'
  235. 17:15:35,401 [findRunningWithDrawInfo] DEBUG ==> Parameters: 00000000000000156195(String)
  236. 17:15:35,405 [findRunningWithDrawInfo] DEBUG <== Total: 1
  237. 17:15:49,672 [TcpNetConnection] ERROR Read exception 192.168.93.50:9108:55719:205161fa-6469-4f03-819c-6a678adcbbc7 SocketException:Connection reset
  238. 17:16:00,305 [count] DEBUG ==> Preparing: SELECT COUNT(*) FROM MESS_MESSAGE m join MESS_RECIEVER r on m.ID=r.MESSAGEID WHERE r.STATUS != '2' AND r.USERID=? AND m.ISSDATE >= ? AND ? >= m.ISSDATE
  239. 17:16:00,305 [count] DEBUG ==> Parameters: 00000000000000156195(String), 2018-05-02 17:16:00.305(Timestamp), 2018-08-02 17:16:00.305(Timestamp)
  240. 17:16:00,310 [count] DEBUG <== Total: 1
  241. 17:16:00,310 [getPageList] DEBUG ==> Preparing: SELECT * FROM (SELECT t.*, ROWNUM RN FROM (SELECT r.MESSAGEID,r.STATUS,m.CONTENT,m.ISSDATE,m.TITLE,m.SOURCE FROM MESS_MESSAGE m join MESS_RECIEVER r on m.ID=r.MESSAGEID WHERE m.ID IN (SELECT distinct MESSAGEID FROM MESS_RECIEVER WHERE STATUS != '2' AND USERID=?) AND m.ISSDATE >= ? AND ? >= m.ISSDATE ORDER BY m.ISSDATE DESC ) t WHERE ?>= ROWNUM ) WHERE RN > ?
  242. 17:16:00,310 [getPageList] DEBUG ==> Parameters: 00000000000000156195(String), 2018-05-02 17:16:00.305(Timestamp), 2018-08-02 17:16:00.305(Timestamp), 50(Integer), 0(Integer)
  243. 17:16:00,316 [getPageList] DEBUG <== Total: 6
  244. 17:16:00,316 [getNotReadMsgCnt] DEBUG ==> Preparing: SELECT COUNT(*) FROM MESS_MESSAGE m join MESS_RECIEVER r on m.ID=r.MESSAGEID WHERE r.STATUS ='0' AND r.USERID=? AND m.ISSDATE >= ? AND ? >= m.ISSDATE
  245. 17:16:00,316 [getNotReadMsgCnt] DEBUG ==> Parameters: 00000000000000156195(String), 2018-05-02 17:16:00.305(Timestamp), 2018-08-02 17:16:00.305(Timestamp)
  246. 17:16:00,320 [getNotReadMsgCnt] DEBUG <== Total: 1
  247. 17:16:00,378 [get] DEBUG ==> Preparing: SELECT * FROM ME_MEMBER WHERE MEMBER_ID = ?
  248. 17:16:00,378 [get] DEBUG ==> Parameters: 00000000000000156195(String)
  249. 17:16:00,380 [get] DEBUG <== Total: 1
  250. 17:16:00,380 [getList] DEBUG ==> Preparing: SELECT * FROM FU_FUND_ACCOUNT WHERE MEMBER_ID = ?
  251. 17:16:00,380 [getList] DEBUG ==> Parameters: 00000000000000156195(String)
  252. 17:16:00,381 [getList] DEBUG <== Total: 1
  253. 17:16:00,382 [getList] DEBUG ==> Preparing: SELECT * FROM FU_BANK_BIND WHERE FUND_ACCOUNT_ID = ? AND STATE = ?
  254. 17:16:00,382 [getList] DEBUG ==> Parameters: 00000000000000156201(String), 1(String)
  255. 17:16:00,383 [getList] DEBUG <== Total: 1
  256. 17:16:00,383 [getList] DEBUG ==> Preparing: SELECT * FROM ME_MEMBER_VOUCHER WHERE MEMBER_ID = ? AND VOUCHER_STAT = ?
  257. 17:16:00,383 [getList] DEBUG ==> Parameters: 00000000000000156195(String), 0(String)
  258. 17:16:00,384 [getList] DEBUG <== Total: 4
  259. 17:16:00,385 [getList] DEBUG ==> Preparing: SELECT * FROM FU_MEMBER_BANK WHERE BANK_CODE = ?
  260. 17:16:00,385 [getList] DEBUG ==> Parameters: CBC(String)
  261. 17:16:00,386 [getList] DEBUG <== Total: 0
  262. 17:16:03,552 [get] DEBUG ==> Preparing: SELECT * FROM ME_MEMBER WHERE MEMBER_ID = ?
  263. 17:16:03,552 [get] DEBUG ==> Parameters: 00000000000000156195(String)
  264. 17:16:03,554 [get] DEBUG <== Total: 1
  265. 17:16:03,554 [getList] DEBUG ==> Preparing: SELECT * FROM FU_FUND_ACCOUNT WHERE MEMBER_ID = ?
  266. 17:16:03,554 [getList] DEBUG ==> Parameters: 00000000000000156195(String)
  267. 17:16:03,556 [getList] DEBUG <== Total: 1
  268. 17:16:03,556 [getList] DEBUG ==> Preparing: SELECT * FROM FU_BANK_BIND WHERE FUND_ACCOUNT_ID = ? AND STATE = ?
  269. 17:16:03,556 [getList] DEBUG ==> Parameters: 00000000000000156201(String), 1(String)
  270. 17:16:03,557 [getList] DEBUG <== Total: 1
  271. 17:16:03,557 [getList] DEBUG ==> Preparing: SELECT * FROM ME_MEMBER_VOUCHER WHERE MEMBER_ID = ? AND VOUCHER_STAT = ?
  272. 17:16:03,557 [getList] DEBUG ==> Parameters: 00000000000000156195(String), 0(String)
  273. 17:16:03,559 [getList] DEBUG <== Total: 4
  274. 17:16:03,559 [getList] DEBUG ==> Preparing: SELECT * FROM FU_MEMBER_BANK WHERE BANK_CODE = ?
  275. 17:16:03,559 [getList] DEBUG ==> Parameters: CBC(String)
  276. 17:16:03,560 [getList] DEBUG <== Total: 0
  277. 17:16:07,804 [findRunningWithDrawInfo] DEBUG ==> Preparing: SELECT COUNT(*) FROM PM_DATA_RECORD R WHERE R.BUSINESS_ID IN (SELECT F.FUND_TRANS_FLOW_ID FROM FU_FUND_TRANS_FLOW F WHERE F.FUND_ACCOUNT_ID = (SELECT A.FUND_ACCOUNT_ID FROM FU_FUND_ACCOUNT A WHERE A.MEMBER_ID = ?) AND F.TRADE_CODE = '02') AND R.DATA_TYPE = '0007' AND R.DATA_STATE != '3'
  278. 17:16:07,805 [findRunningWithDrawInfo] DEBUG ==> Parameters: 00000000000000156195(String)
  279. 17:16:07,807 [findRunningWithDrawInfo] DEBUG <== Total: 1
  280. 17:16:18,673 [TcpNetConnection] ERROR Read exception 192.168.93.50:9108:55737:887be785-ed99-4413-9d5e-80f92e07105f SocketException:Connection reset
  281. 17:16:48,672 [TcpNetConnection] ERROR Read exception 192.168.93.50:9108:55759:7af1db07-7d01-4142-b27b-1adb0a01cec1 SocketException:Connection reset
  282. 17:17:05,094 [count] DEBUG ==> Preparing: SELECT COUNT(*) FROM MESS_MESSAGE m join MESS_RECIEVER r on m.ID=r.MESSAGEID WHERE r.STATUS != '2' AND r.USERID=? AND m.ISSDATE >= ? AND ? >= m.ISSDATE
  283. 17:17:05,094 [count] DEBUG ==> Parameters: 00000000000000156195(String), 2018-05-02 17:17:05.094(Timestamp), 2018-08-02 17:17:05.094(Timestamp)
  284. 17:17:05,099 [count] DEBUG <== Total: 1
  285. 17:17:05,100 [getPageList] DEBUG ==> Preparing: SELECT * FROM (SELECT t.*, ROWNUM RN FROM (SELECT r.MESSAGEID,r.STATUS,m.CONTENT,m.ISSDATE,m.TITLE,m.SOURCE FROM MESS_MESSAGE m join MESS_RECIEVER r on m.ID=r.MESSAGEID WHERE m.ID IN (SELECT distinct MESSAGEID FROM MESS_RECIEVER WHERE STATUS != '2' AND USERID=?) AND m.ISSDATE >= ? AND ? >= m.ISSDATE ORDER BY m.ISSDATE DESC ) t WHERE ?>= ROWNUM ) WHERE RN > ?
  286. 17:17:05,100 [getPageList] DEBUG ==> Parameters: 00000000000000156195(String), 2018-05-02 17:17:05.094(Timestamp), 2018-08-02 17:17:05.094(Timestamp), 50(Integer), 0(Integer)
  287. 17:17:05,105 [getPageList] DEBUG <== Total: 6
  288. 17:17:05,106 [getNotReadMsgCnt] DEBUG ==> Preparing: SELECT COUNT(*) FROM MESS_MESSAGE m join MESS_RECIEVER r on m.ID=r.MESSAGEID WHERE r.STATUS ='0' AND r.USERID=? AND m.ISSDATE >= ? AND ? >= m.ISSDATE
  289. 17:17:05,106 [getNotReadMsgCnt] DEBUG ==> Parameters: 00000000000000156195(String), 2018-05-02 17:17:05.094(Timestamp), 2018-08-02 17:17:05.094(Timestamp)
  290. 17:17:05,110 [getNotReadMsgCnt] DEBUG <== Total: 1
  291. 17:17:05,170 [get] DEBUG ==> Preparing: SELECT * FROM ME_MEMBER WHERE MEMBER_ID = ?
  292. 17:17:05,170 [get] DEBUG ==> Parameters: 00000000000000156195(String)
  293. 17:17:05,171 [get] DEBUG <== Total: 1
  294. 17:17:05,171 [getList] DEBUG ==> Preparing: SELECT * FROM FU_FUND_ACCOUNT WHERE MEMBER_ID = ?
  295. 17:17:05,171 [getList] DEBUG ==> Parameters: 00000000000000156195(String)
  296. 17:17:05,172 [getList] DEBUG <== Total: 1
  297. 17:17:05,173 [getList] DEBUG ==> Preparing: SELECT * FROM FU_BANK_BIND WHERE FUND_ACCOUNT_ID = ? AND STATE = ?
  298. 17:17:05,173 [getList] DEBUG ==> Parameters: 00000000000000156201(String), 1(String)
  299. 17:17:05,174 [getList] DEBUG <== Total: 1
  300. 17:17:05,174 [getList] DEBUG ==> Preparing: SELECT * FROM ME_MEMBER_VOUCHER WHERE MEMBER_ID = ? AND VOUCHER_STAT = ?
  301. 17:17:05,174 [getList] DEBUG ==> Parameters: 00000000000000156195(String), 0(String)
  302. 17:17:05,175 [getList] DEBUG <== Total: 4
  303. 17:17:05,176 [getList] DEBUG ==> Preparing: SELECT * FROM FU_MEMBER_BANK WHERE BANK_CODE = ?
  304. 17:17:05,176 [getList] DEBUG ==> Parameters: CBC(String)
  305. 17:17:05,177 [getList] DEBUG <== Total: 0
  306. 17:17:08,342 [get] DEBUG ==> Preparing: SELECT * FROM ME_MEMBER WHERE MEMBER_ID = ?
  307. 17:17:08,342 [get] DEBUG ==> Parameters: 00000000000000156195(String)
  308. 17:17:08,343 [get] DEBUG <== Total: 1
  309. 17:17:08,344 [getList] DEBUG ==> Preparing: SELECT * FROM FU_FUND_ACCOUNT WHERE MEMBER_ID = ?
  310. 17:17:08,344 [getList] DEBUG ==> Parameters: 00000000000000156195(String)
  311. 17:17:08,345 [getList] DEBUG <== Total: 1
  312. 17:17:08,345 [getList] DEBUG ==> Preparing: SELECT * FROM FU_BANK_BIND WHERE FUND_ACCOUNT_ID = ? AND STATE = ?
  313. 17:17:08,345 [getList] DEBUG ==> Parameters: 00000000000000156201(String), 1(String)
  314. 17:17:08,346 [getList] DEBUG <== Total: 1
  315. 17:17:08,346 [getList] DEBUG ==> Preparing: SELECT * FROM ME_MEMBER_VOUCHER WHERE MEMBER_ID = ? AND VOUCHER_STAT = ?
  316. 17:17:08,346 [getList] DEBUG ==> Parameters: 00000000000000156195(String), 0(String)
  317. 17:17:08,348 [getList] DEBUG <== Total: 4
  318. 17:17:08,348 [getList] DEBUG ==> Preparing: SELECT * FROM FU_MEMBER_BANK WHERE BANK_CODE = ?
  319. 17:17:08,348 [getList] DEBUG ==> Parameters: CBC(String)
  320. 17:17:08,349 [getList] DEBUG <== Total: 0
  321. 17:17:10,578 [count] DEBUG ==> Preparing: SELECT COUNT(*) FROM MESS_MESSAGE m join MESS_RECIEVER r on m.ID=r.MESSAGEID WHERE r.STATUS != '2' AND r.USERID=? AND m.ISSDATE >= ? AND ? >= m.ISSDATE
  322. 17:17:10,578 [count] DEBUG ==> Parameters: 00000000000000156195(String), 2018-05-02 17:17:10.577(Timestamp), 2018-08-02 17:17:10.577(Timestamp)
  323. 17:17:10,582 [count] DEBUG <== Total: 1
  324. 17:17:10,583 [getPageList] DEBUG ==> Preparing: SELECT * FROM (SELECT t.*, ROWNUM RN FROM (SELECT r.MESSAGEID,r.STATUS,m.CONTENT,m.ISSDATE,m.TITLE,m.SOURCE FROM MESS_MESSAGE m join MESS_RECIEVER r on m.ID=r.MESSAGEID WHERE m.ID IN (SELECT distinct MESSAGEID FROM MESS_RECIEVER WHERE STATUS != '2' AND USERID=?) AND m.ISSDATE >= ? AND ? >= m.ISSDATE ORDER BY m.ISSDATE DESC ) t WHERE ?>= ROWNUM ) WHERE RN > ?
  325. 17:17:10,583 [getPageList] DEBUG ==> Parameters: 00000000000000156195(String), 2018-05-02 17:17:10.577(Timestamp), 2018-08-02 17:17:10.577(Timestamp), 50(Integer), 0(Integer)
  326. 17:17:10,588 [getPageList] DEBUG <== Total: 6
  327. 17:17:10,588 [getNotReadMsgCnt] DEBUG ==> Preparing: SELECT COUNT(*) FROM MESS_MESSAGE m join MESS_RECIEVER r on m.ID=r.MESSAGEID WHERE r.STATUS ='0' AND r.USERID=? AND m.ISSDATE >= ? AND ? >= m.ISSDATE
  328. 17:17:10,588 [getNotReadMsgCnt] DEBUG ==> Parameters: 00000000000000156195(String), 2018-05-02 17:17:10.577(Timestamp), 2018-08-02 17:17:10.577(Timestamp)
  329. 17:17:10,592 [getNotReadMsgCnt] DEBUG <== Total: 1
  330. 17:17:10,685 [get] DEBUG ==> Preparing: SELECT * FROM ME_MEMBER WHERE MEMBER_ID = ?
  331. 17:17:10,685 [get] DEBUG ==> Parameters: 00000000000000156195(String)
  332. 17:17:10,686 [get] DEBUG <== Total: 1
  333. 17:17:10,687 [getList] DEBUG ==> Preparing: SELECT * FROM FU_FUND_ACCOUNT WHERE MEMBER_ID = ?
  334. 17:17:10,687 [getList] DEBUG ==> Parameters: 00000000000000156195(String)
  335. 17:17:10,687 [getList] DEBUG <== Total: 1
  336. 17:17:10,688 [getList] DEBUG ==> Preparing: SELECT * FROM FU_BANK_BIND WHERE FUND_ACCOUNT_ID = ? AND STATE = ?
  337. 17:17:10,688 [getList] DEBUG ==> Parameters: 00000000000000156201(String), 1(String)
  338. 17:17:10,689 [getList] DEBUG <== Total: 1
  339. 17:17:10,689 [getList] DEBUG ==> Preparing: SELECT * FROM ME_MEMBER_VOUCHER WHERE MEMBER_ID = ? AND VOUCHER_STAT = ?
  340. 17:17:10,689 [getList] DEBUG ==> Parameters: 00000000000000156195(String), 0(String)
  341. 17:17:10,690 [getList] DEBUG <== Total: 4
  342. 17:17:10,690 [getList] DEBUG ==> Preparing: SELECT * FROM FU_MEMBER_BANK WHERE BANK_CODE = ?
  343. 17:17:10,690 [getList] DEBUG ==> Parameters: CBC(String)
  344. 17:17:10,691 [getList] DEBUG <== Total: 0
  345. 17:17:13,159 [get] DEBUG ==> Preparing: SELECT * FROM ME_MEMBER WHERE MEMBER_ID = ?
  346. 17:17:13,159 [get] DEBUG ==> Parameters: 00000000000000156195(String)
  347. 17:17:13,161 [get] DEBUG <== Total: 1
  348. 17:17:13,161 [getList] DEBUG ==> Preparing: SELECT * FROM FU_FUND_ACCOUNT WHERE MEMBER_ID = ?
  349. 17:17:13,161 [getList] DEBUG ==> Parameters: 00000000000000156195(String)
  350. 17:17:13,162 [getList] DEBUG <== Total: 1
  351. 17:17:13,163 [getList] DEBUG ==> Preparing: SELECT * FROM FU_BANK_BIND WHERE FUND_ACCOUNT_ID = ? AND STATE = ?
  352. 17:17:13,163 [getList] DEBUG ==> Parameters: 00000000000000156201(String), 1(String)
  353. 17:17:13,165 [getList] DEBUG <== Total: 1
  354. 17:17:13,165 [getList] DEBUG ==> Preparing: SELECT * FROM ME_MEMBER_VOUCHER WHERE MEMBER_ID = ? AND VOUCHER_STAT = ?
  355. 17:17:13,165 [getList] DEBUG ==> Parameters: 00000000000000156195(String), 0(String)
  356. 17:17:13,166 [getList] DEBUG <== Total: 4
  357. 17:17:13,167 [getList] DEBUG ==> Preparing: SELECT * FROM FU_MEMBER_BANK WHERE BANK_CODE = ?
  358. 17:17:13,167 [getList] DEBUG ==> Parameters: CBC(String)
  359. 17:17:13,168 [getList] DEBUG <== Total: 0
  360. 17:17:16,421 [findRunningWithDrawInfo] DEBUG ==> Preparing: SELECT COUNT(*) FROM PM_DATA_RECORD R WHERE R.BUSINESS_ID IN (SELECT F.FUND_TRANS_FLOW_ID FROM FU_FUND_TRANS_FLOW F WHERE F.FUND_ACCOUNT_ID = (SELECT A.FUND_ACCOUNT_ID FROM FU_FUND_ACCOUNT A WHERE A.MEMBER_ID = ?) AND F.TRADE_CODE = '02') AND R.DATA_TYPE = '0007' AND R.DATA_STATE != '3'
  361. 17:17:16,421 [findRunningWithDrawInfo] DEBUG ==> Parameters: 00000000000000156195(String)
  362. 17:17:16,424 [findRunningWithDrawInfo] DEBUG <== Total: 1
  363. 17:17:18,681 [TcpNetConnection] ERROR Read exception 192.168.93.50:9108:55763:70175157-a4c9-4dca-88bc-5811335dac55 SocketException:Connection reset
  364. 17:17:31,802 [findRunningWithDrawInfo] DEBUG ==> Preparing: SELECT COUNT(*) FROM PM_DATA_RECORD R WHERE R.BUSINESS_ID IN (SELECT F.FUND_TRANS_FLOW_ID FROM FU_FUND_TRANS_FLOW F WHERE F.FUND_ACCOUNT_ID = (SELECT A.FUND_ACCOUNT_ID FROM FU_FUND_ACCOUNT A WHERE A.MEMBER_ID = ?) AND F.TRADE_CODE = '02') AND R.DATA_TYPE = '0007' AND R.DATA_STATE != '3'
  365. 17:17:31,802 [findRunningWithDrawInfo] DEBUG ==> Parameters: 00000000000000156195(String)
  366. 17:17:31,805 [findRunningWithDrawInfo] DEBUG <== Total: 1
  367.  
  368.  
  369.  
  370.  
  371.  
  372.  
  373.  
  374.  
  375.  
  376.  
  377.  
  378.  
  379.  
  380.  
  381.  
  382.  
  383. 17:17:37,394 [findRunningWithDrawInfo] DEBUG ==> Preparing: SELECT COUNT(*) FROM PM_DATA_RECORD R WHERE R.BUSINESS_ID IN (SELECT F.FUND_TRANS_FLOW_ID FROM FU_FUND_TRANS_FLOW F WHERE F.FUND_ACCOUNT_ID = (SELECT A.FUND_ACCOUNT_ID FROM FU_FUND_ACCOUNT A WHERE A.MEMBER_ID = ?) AND F.TRADE_CODE = '02') AND R.DATA_TYPE = '0007' AND R.DATA_STATE != '3'
  384. 17:17:37,394 [findRunningWithDrawInfo] DEBUG ==> Parameters: 00000000000000156195(String)
  385. 17:17:37,397 [findRunningWithDrawInfo] DEBUG <== Total: 1
  386. 17:17:48,672 [TcpNetConnection] ERROR Read exception 192.168.93.50:9108:55797:3d96979e-af63-493b-9c77-886238f5afaa SocketException:Connection reset
  387. 17:17:49,376 [findRunningWithDrawInfo] DEBUG ==> Preparing: SELECT COUNT(*) FROM PM_DATA_RECORD R WHERE R.BUSINESS_ID IN (SELECT F.FUND_TRANS_FLOW_ID FROM FU_FUND_TRANS_FLOW F WHERE F.FUND_ACCOUNT_ID = (SELECT A.FUND_ACCOUNT_ID FROM FU_FUND_ACCOUNT A WHERE A.MEMBER_ID = ?) AND F.TRADE_CODE = '02') AND R.DATA_TYPE = '0007' AND R.DATA_STATE != '3'
  388. 17:17:49,376 [findRunningWithDrawInfo] DEBUG ==> Parameters: 00000000000000156195(String)
  389. 17:17:49,379 [findRunningWithDrawInfo] DEBUG <== Total: 1
  390. 17:18:18,672 [TcpNetConnection] ERROR Read exception 192.168.93.50:9108:55837:59340dba-cfe2-4976-8046-4260f533edf6 SocketException:Connection reset
  391. 17:18:44,837 [count] DEBUG ==> Preparing: SELECT COUNT(*) FROM MESS_MESSAGE m join MESS_RECIEVER r on m.ID=r.MESSAGEID WHERE r.STATUS != '2' AND r.USERID=? AND m.ISSDATE >= ? AND ? >= m.ISSDATE
  392. 17:18:44,837 [count] DEBUG ==> Parameters: 00000000000000156195(String), 2018-05-02 17:18:44.837(Timestamp), 2018-08-02 17:18:44.837(Timestamp)
  393. 17:18:44,842 [count] DEBUG <== Total: 1
  394. 17:18:44,842 [getPageList] DEBUG ==> Preparing: SELECT * FROM (SELECT t.*, ROWNUM RN FROM (SELECT r.MESSAGEID,r.STATUS,m.CONTENT,m.ISSDATE,m.TITLE,m.SOURCE FROM MESS_MESSAGE m join MESS_RECIEVER r on m.ID=r.MESSAGEID WHERE m.ID IN (SELECT distinct MESSAGEID FROM MESS_RECIEVER WHERE STATUS != '2' AND USERID=?) AND m.ISSDATE >= ? AND ? >= m.ISSDATE ORDER BY m.ISSDATE DESC ) t WHERE ?>= ROWNUM ) WHERE RN > ?
  395. 17:18:44,842 [getPageList] DEBUG ==> Parameters: 00000000000000156195(String), 2018-05-02 17:18:44.837(Timestamp), 2018-08-02 17:18:44.837(Timestamp), 50(Integer), 0(Integer)
  396. 17:18:44,848 [getPageList] DEBUG <== Total: 6
  397. 17:18:44,848 [getNotReadMsgCnt] DEBUG ==> Preparing: SELECT COUNT(*) FROM MESS_MESSAGE m join MESS_RECIEVER r on m.ID=r.MESSAGEID WHERE r.STATUS ='0' AND r.USERID=? AND m.ISSDATE >= ? AND ? >= m.ISSDATE
  398. 17:18:44,848 [getNotReadMsgCnt] DEBUG ==> Parameters: 00000000000000156195(String), 2018-05-02 17:18:44.837(Timestamp), 2018-08-02 17:18:44.837(Timestamp)
  399. 17:18:44,852 [getNotReadMsgCnt] DEBUG <== Total: 1
  400. 17:18:45,028 [get] DEBUG ==> Preparing: SELECT * FROM ME_MEMBER WHERE MEMBER_ID = ?
  401. 17:18:45,028 [get] DEBUG ==> Parameters: 00000000000000156195(String)
  402. 17:18:45,030 [get] DEBUG <== Total: 1
  403. 17:18:45,030 [getList] DEBUG ==> Preparing: SELECT * FROM FU_FUND_ACCOUNT WHERE MEMBER_ID = ?
  404. 17:18:45,030 [getList] DEBUG ==> Parameters: 00000000000000156195(String)
  405. 17:18:45,031 [getList] DEBUG <== Total: 1
  406. 17:18:45,032 [getList] DEBUG ==> Preparing: SELECT * FROM FU_BANK_BIND WHERE FUND_ACCOUNT_ID = ? AND STATE = ?
  407. 17:18:45,032 [getList] DEBUG ==> Parameters: 00000000000000156201(String), 1(String)
  408. 17:18:45,033 [getList] DEBUG <== Total: 1
  409. 17:18:45,033 [getList] DEBUG ==> Preparing: SELECT * FROM ME_MEMBER_VOUCHER WHERE MEMBER_ID = ? AND VOUCHER_STAT = ?
  410. 17:18:45,033 [getList] DEBUG ==> Parameters: 00000000000000156195(String), 0(String)
  411. 17:18:45,035 [getList] DEBUG <== Total: 4
  412. 17:18:45,035 [getList] DEBUG ==> Preparing: SELECT * FROM FU_MEMBER_BANK WHERE BANK_CODE = ?
  413. 17:18:45,035 [getList] DEBUG ==> Parameters: CBC(String)
  414. 17:18:45,036 [getList] DEBUG <== Total: 0
  415. 17:18:48,482 [get] DEBUG ==> Preparing: SELECT * FROM ME_MEMBER WHERE MEMBER_ID = ?
  416. 17:18:48,482 [get] DEBUG ==> Parameters: 00000000000000156195(String)
  417. 17:18:48,484 [get] DEBUG <== Total: 1
  418. 17:18:48,484 [getList] DEBUG ==> Preparing: SELECT * FROM FU_FUND_ACCOUNT WHERE MEMBER_ID = ?
  419. 17:18:48,484 [getList] DEBUG ==> Parameters: 00000000000000156195(String)
  420. 17:18:48,485 [getList] DEBUG <== Total: 1
  421. 17:18:48,486 [getList] DEBUG ==> Preparing: SELECT * FROM FU_BANK_BIND WHERE FUND_ACCOUNT_ID = ? AND STATE = ?
  422. 17:18:48,486 [getList] DEBUG ==> Parameters: 00000000000000156201(String), 1(String)
  423. 17:18:48,487 [getList] DEBUG <== Total: 1
  424. 17:18:48,487 [getList] DEBUG ==> Preparing: SELECT * FROM ME_MEMBER_VOUCHER WHERE MEMBER_ID = ? AND VOUCHER_STAT = ?
  425. 17:18:48,487 [getList] DEBUG ==> Parameters: 00000000000000156195(String), 0(String)
  426. 17:18:48,489 [getList] DEBUG <== Total: 4
  427. 17:18:48,489 [getList] DEBUG ==> Preparing: SELECT * FROM FU_MEMBER_BANK WHERE BANK_CODE = ?
  428. 17:18:48,489 [getList] DEBUG ==> Parameters: CBC(String)
  429. 17:18:48,490 [getList] DEBUG <== Total: 0
  430. 17:18:48,672 [TcpNetConnection] ERROR Read exception 192.168.93.50:9108:55843:35d13709-b284-411c-b603-2ecbe18a792f SocketException:Connection reset
  431.  
  432.  
  433.  
  434.  
  435.  
  436.  
  437.  
  438.  
  439.  
  440.  
  441.  
  442.  
  443.  
  444.  
  445.  
  446.  
  447.  
  448.  
  449.  
  450.  
  451. 17:19:18,672 [TcpNetConnection] ERROR Read exception 192.168.93.50:9108:55861:5289f4cc-e5f1-4800-ae6d-95f39fc32826 SocketException:Connection reset
  452.  
  453.  
  454.  
  455.  
  456.  
  457.  
  458.  
  459.  
  460.  
  461.  
  462.  
  463.  
  464.  
  465.  
  466.  
  467.  
  468.  
  469.  
  470.  
  471.  
  472.  
  473.  
  474.  
  475.  
  476.  
  477.  
  478.  
  479.  
  480.  
  481. 17:19:48,672 [TcpNetConnection] ERROR Read exception 192.168.93.50:9108:55865:61ec66bf-ce4a-46dd-a237-0769c1c04a11 SocketException:Connection reset
  482. 17:19:55,277 [get] DEBUG ==> Preparing: SELECT * FROM ME_MEMBER WHERE MEMBER_ID = ?
  483. 17:19:55,277 [get] DEBUG ==> Parameters: 00000000000000156195(String)
  484. 17:19:55,278 [get] DEBUG <== Total: 1
  485. 17:19:55,279 [getList] DEBUG ==> Preparing: SELECT * FROM FU_FUND_ACCOUNT WHERE MEMBER_ID = ?
  486. 17:19:55,279 [getList] DEBUG ==> Parameters: 00000000000000156195(String)
  487. 17:19:55,280 [getList] DEBUG <== Total: 1
  488. 17:19:55,280 [getList] DEBUG ==> Preparing: SELECT * FROM FU_BANK_BIND WHERE FUND_ACCOUNT_ID = ? AND STATE = ?
  489. 17:19:55,280 [getList] DEBUG ==> Parameters: 00000000000000156201(String), 1(String)
  490. 17:19:55,282 [getList] DEBUG <== Total: 1
  491. 17:19:55,282 [getList] DEBUG ==> Preparing: SELECT * FROM ME_MEMBER_VOUCHER WHERE MEMBER_ID = ? AND VOUCHER_STAT = ?
  492. 17:19:55,282 [getList] DEBUG ==> Parameters: 00000000000000156195(String), 0(String)
  493. 17:19:55,283 [getList] DEBUG <== Total: 4
  494. 17:19:55,284 [getList] DEBUG ==> Preparing: SELECT * FROM FU_MEMBER_BANK WHERE BANK_CODE = ?
  495. 17:19:55,284 [getList] DEBUG ==> Parameters: CBC(String)
  496. 17:19:55,285 [getList] DEBUG <== Total: 0
  497. 17:20:08,974 [getList] DEBUG ==> Preparing: SELECT * FROM FU_FUND_ACCOUNT WHERE MEMBER_ID = ?
  498. 17:20:08,974 [getList] DEBUG ==> Parameters: 00000000000001491406(String)
  499. 17:20:08,976 [getList] DEBUG <== Total: 1
  500. 17:20:08,976 [getList] DEBUG ==> Preparing: SELECT * FROM FU_BANK_BIND WHERE FUND_ACCOUNT_ID = ? AND STATE = ? AND IS_BAND_AGAIN = ?
  501. 17:20:08,976 [getList] DEBUG ==> Parameters: 00000000000001491412(String), 1(String), F(String)
  502. 17:20:08,977 [getList] DEBUG <== Total: 1
  503. 17:20:08,977 [get] DEBUG ==> Preparing: SELECT * FROM ME_MEMBER WHERE MEMBER_ID = ?
  504. 17:20:08,978 [get] DEBUG ==> Parameters: 00000000000001491406(String)
  505. 17:20:08,979 [get] DEBUG <== Total: 1
  506. 17:20:08,979 [get] DEBUG ==> Preparing: SELECT * FROM ME_MEMBER WHERE MEMBER_ID = ?
  507. 17:20:08,979 [get] DEBUG ==> Parameters: 00000000000001491406(String)
  508. 17:20:08,980 [get] DEBUG <== Total: 1
  509. 17:20:08,996 [getList] DEBUG ==> Preparing: SELECT * FROM PM_DEVICE WHERE MEMBER_ID = ?
  510. 17:20:08,996 [getList] DEBUG ==> Parameters: 00000000000001491406(String)
  511. 17:20:08,997 [getList] DEBUG <== Total: 1
  512. 17:20:08,997 [get] DEBUG ==> Preparing: SELECT * FROM PM_DEVICE WHERE ID = ?
  513. 17:20:08,997 [get] DEBUG ==> Parameters: 00000000000001498937(String)
  514. 17:20:08,998 [get] DEBUG <== Total: 1
  515. 17:20:08,999 [update] DEBUG ==> Preparing: UPDATE PM_DEVICE SET ID = ?, MEMBER_ID = ?, DEVICE_NUMBER = ?, DEVICE_TYPE = ?, CREATE_TIME = ?, MODIFY_TIME = ? WHERE ID = ?
  516. 17:20:08,999 [update] DEBUG ==> Parameters: 00000000000001498937(String), 00000000000001491406(String), 1111111111111111111(String), 3(String), 2017-12-26 15:57:27.034(Timestamp), 2018-08-02 17:20:08.997(Timestamp), 00000000000001498937(String)
  517. 17:20:09,006 [update] DEBUG <== Updates: 1
  518. 17:20:12,188 [count] DEBUG ==> Preparing: SELECT COUNT(*) FROM MESS_MESSAGE m join MESS_RECIEVER r on m.ID=r.MESSAGEID WHERE r.STATUS != '2' AND r.USERID=? AND m.ISSDATE >= ? AND ? >= m.ISSDATE
  519. 17:20:12,188 [count] DEBUG ==> Parameters: 00000000000001491406(String), 2018-05-02 17:20:12.188(Timestamp), 2018-08-02 17:20:12.188(Timestamp)
  520. 17:20:12,193 [count] DEBUG <== Total: 1
  521. 17:20:12,193 [getPageList] DEBUG ==> Preparing: SELECT * FROM (SELECT t.*, ROWNUM RN FROM (SELECT r.MESSAGEID,r.STATUS,m.CONTENT,m.ISSDATE,m.TITLE,m.SOURCE FROM MESS_MESSAGE m join MESS_RECIEVER r on m.ID=r.MESSAGEID WHERE m.ID IN (SELECT distinct MESSAGEID FROM MESS_RECIEVER WHERE STATUS != '2' AND USERID=?) AND m.ISSDATE >= ? AND ? >= m.ISSDATE ORDER BY m.ISSDATE DESC ) t WHERE ?>= ROWNUM ) WHERE RN > ?
  522. 17:20:12,194 [getPageList] DEBUG ==> Parameters: 00000000000001491406(String), 2018-05-02 17:20:12.188(Timestamp), 2018-08-02 17:20:12.188(Timestamp), 50(Integer), 0(Integer)
  523. 17:20:12,204 [getPageList] DEBUG <== Total: 50
  524. 17:20:12,204 [getNotReadMsgCnt] DEBUG ==> Preparing: SELECT COUNT(*) FROM MESS_MESSAGE m join MESS_RECIEVER r on m.ID=r.MESSAGEID WHERE r.STATUS ='0' AND r.USERID=? AND m.ISSDATE >= ? AND ? >= m.ISSDATE
  525. 17:20:12,204 [getNotReadMsgCnt] DEBUG ==> Parameters: 00000000000001491406(String), 2018-05-02 17:20:12.188(Timestamp), 2018-08-02 17:20:12.188(Timestamp)
  526. 17:20:12,208 [getNotReadMsgCnt] DEBUG <== Total: 1
  527. 17:20:12,275 [get] DEBUG ==> Preparing: SELECT * FROM ME_MEMBER WHERE MEMBER_ID = ?
  528. 17:20:12,275 [get] DEBUG ==> Parameters: 00000000000001491406(String)
  529. 17:20:12,277 [get] DEBUG <== Total: 1
  530. 17:20:12,277 [getList] DEBUG ==> Preparing: SELECT * FROM FU_FUND_ACCOUNT WHERE MEMBER_ID = ?
  531. 17:20:12,277 [getList] DEBUG ==> Parameters: 00000000000001491406(String)
  532. 17:20:12,278 [getList] DEBUG <== Total: 1
  533. 17:20:12,278 [getList] DEBUG ==> Preparing: SELECT * FROM FU_BANK_BIND WHERE FUND_ACCOUNT_ID = ? AND STATE = ?
  534. 17:20:12,278 [getList] DEBUG ==> Parameters: 00000000000001491412(String), 1(String)
  535. 17:20:12,279 [getList] DEBUG <== Total: 1
  536. 17:20:12,280 [getList] DEBUG ==> Preparing: SELECT * FROM ME_MEMBER_VOUCHER WHERE MEMBER_ID = ? AND VOUCHER_STAT = ?
  537. 17:20:12,280 [getList] DEBUG ==> Parameters: 00000000000001491406(String), 0(String)
  538. 17:20:12,282 [getList] DEBUG <== Total: 16
  539. 17:20:12,283 [getList] DEBUG ==> Preparing: SELECT * FROM FU_MEMBER_BANK WHERE BANK_CODE = ?
  540. 17:20:12,283 [getList] DEBUG ==> Parameters: CMBC(String)
  541. 17:20:12,284 [getList] DEBUG <== Total: 1
  542. 17:20:18,673 [TcpNetConnection] ERROR Read exception 192.168.93.50:9108:55901:85716c8b-048d-4451-a718-2b0414af4de8 SocketException:Connection reset
  543. 17:20:20,716 [getList] DEBUG ==> Preparing: SELECT * FROM FU_FUND_ACCOUNT WHERE MEMBER_ID = ?
  544. 17:20:20,716 [getList] DEBUG ==> Parameters: 00000000000000156195(String)
  545. 17:20:20,717 [getList] DEBUG <== Total: 1
  546. 17:20:20,718 [getList] DEBUG ==> Preparing: SELECT * FROM FU_BANK_BIND WHERE FUND_ACCOUNT_ID = ? AND STATE = ? AND IS_BAND_AGAIN = ?
  547. 17:20:20,718 [getList] DEBUG ==> Parameters: 00000000000000156201(String), 1(String), F(String)
  548. 17:20:20,719 [getList] DEBUG <== Total: 1
  549. 17:20:20,719 [get] DEBUG ==> Preparing: SELECT * FROM ME_MEMBER WHERE MEMBER_ID = ?
  550. 17:20:20,719 [get] DEBUG ==> Parameters: 00000000000000156195(String)
  551. 17:20:20,720 [get] DEBUG <== Total: 1
  552. 17:20:20,721 [get] DEBUG ==> Preparing: SELECT * FROM ME_MEMBER WHERE MEMBER_ID = ?
  553. 17:20:20,721 [get] DEBUG ==> Parameters: 00000000000000156195(String)
  554. 17:20:20,722 [get] DEBUG <== Total: 1
  555. 17:20:20,739 [getList] DEBUG ==> Preparing: SELECT * FROM PM_DEVICE WHERE MEMBER_ID = ?
  556. 17:20:20,739 [getList] DEBUG ==> Parameters: 00000000000000156195(String)
  557. 17:20:20,740 [getList] DEBUG <== Total: 1
  558. 17:20:20,740 [get] DEBUG ==> Preparing: SELECT * FROM PM_DEVICE WHERE ID = ?
  559. 17:20:20,740 [get] DEBUG ==> Parameters: 00000000000000274579(String)
  560. 17:20:20,741 [get] DEBUG <== Total: 1
  561. 17:20:20,741 [update] DEBUG ==> Preparing: UPDATE PM_DEVICE SET ID = ?, MEMBER_ID = ?, DEVICE_NUMBER = ?, DEVICE_TYPE = ?, CREATE_TIME = ?, MODIFY_TIME = ? WHERE ID = ?
  562. 17:20:20,742 [update] DEBUG ==> Parameters: 00000000000000274579(String), 00000000000000156195(String), 49e61b0026e3a32797476f4cb9facbb2(String), 2(String), 2017-03-29 08:42:36.388(Timestamp), 2018-08-02 17:20:20.74(Timestamp), 00000000000000274579(String)
  563. 17:20:20,747 [update] DEBUG <== Updates: 1
  564.  
  565.  
  566.  
  567.  
  568.  
  569.  
  570.  
  571.  
  572.  
  573.  
  574. 17:20:23,987 [count] DEBUG ==> Preparing: SELECT COUNT(*) FROM MESS_MESSAGE m join MESS_RECIEVER r on m.ID=r.MESSAGEID WHERE r.STATUS != '2' AND r.USERID=? AND m.ISSDATE >= ? AND ? >= m.ISSDATE
  575. 17:20:23,987 [count] DEBUG ==> Parameters: 00000000000000156195(String), 2018-05-02 17:20:23.987(Timestamp), 2018-08-02 17:20:23.987(Timestamp)
  576. 17:20:23,992 [count] DEBUG <== Total: 1
  577. 17:20:23,992 [getPageList] DEBUG ==> Preparing: SELECT * FROM (SELECT t.*, ROWNUM RN FROM (SELECT r.MESSAGEID,r.STATUS,m.CONTENT,m.ISSDATE,m.TITLE,m.SOURCE FROM MESS_MESSAGE m join MESS_RECIEVER r on m.ID=r.MESSAGEID WHERE m.ID IN (SELECT distinct MESSAGEID FROM MESS_RECIEVER WHERE STATUS != '2' AND USERID=?) AND m.ISSDATE >= ? AND ? >= m.ISSDATE ORDER BY m.ISSDATE DESC ) t WHERE ?>= ROWNUM ) WHERE RN > ?
  578. 17:20:23,992 [getPageList] DEBUG ==> Parameters: 00000000000000156195(String), 2018-05-02 17:20:23.987(Timestamp), 2018-08-02 17:20:23.987(Timestamp), 50(Integer), 0(Integer)
  579. 17:20:23,998 [getPageList] DEBUG <== Total: 6
  580. 17:20:23,998 [getNotReadMsgCnt] DEBUG ==> Preparing: SELECT COUNT(*) FROM MESS_MESSAGE m join MESS_RECIEVER r on m.ID=r.MESSAGEID WHERE r.STATUS ='0' AND r.USERID=? AND m.ISSDATE >= ? AND ? >= m.ISSDATE
  581. 17:20:23,998 [getNotReadMsgCnt] DEBUG ==> Parameters: 00000000000000156195(String), 2018-05-02 17:20:23.987(Timestamp), 2018-08-02 17:20:23.987(Timestamp)
  582. 17:20:24,002 [getNotReadMsgCnt] DEBUG <== Total: 1
  583.  
  584.  
  585.  
  586.  
  587.  
  588. 17:20:24,139 [get] DEBUG ==> Preparing: SELECT * FROM ME_MEMBER WHERE MEMBER_ID = ?
  589. 17:20:24,139 [get] DEBUG ==> Parameters: 00000000000000156195(String)
  590. 17:20:24,141 [get] DEBUG <== Total: 1
  591. 17:20:24,141 [getList] DEBUG ==> Preparing: SELECT * FROM FU_FUND_ACCOUNT WHERE MEMBER_ID = ?
  592. 17:20:24,141 [getList] DEBUG ==> Parameters: 00000000000000156195(String)
  593. 17:20:24,143 [getList] DEBUG <== Total: 1
  594. 17:20:24,143 [getList] DEBUG ==> Preparing: SELECT * FROM FU_BANK_BIND WHERE FUND_ACCOUNT_ID = ? AND STATE = ?
  595. 17:20:24,143 [getList] DEBUG ==> Parameters: 00000000000000156201(String), 1(String)
  596. 17:20:24,144 [getList] DEBUG <== Total: 1
  597. 17:20:24,144 [getList] DEBUG ==> Preparing: SELECT * FROM ME_MEMBER_VOUCHER WHERE MEMBER_ID = ? AND VOUCHER_STAT = ?
  598. 17:20:24,144 [getList] DEBUG ==> Parameters: 00000000000000156195(String), 0(String)
  599. 17:20:24,146 [getList] DEBUG <== Total: 4
  600. 17:20:24,146 [getList] DEBUG ==> Preparing: SELECT * FROM FU_MEMBER_BANK WHERE BANK_CODE = ?
  601. 17:20:24,146 [getList] DEBUG ==> Parameters: CBC(String)
  602. 17:20:24,147 [getList] DEBUG <== Total: 0
  603.  
  604.  
  605.  
  606.  
  607.  
  608.  
  609.  
  610.  
  611.  
  612.  
  613.  
  614.  
  615.  
  616.  
  617.  
  618.  
  619.  
  620.  
  621.  
  622.  
  623.  
  624.  
  625.  
  626.  
  627.  
  628.  
  629.  
  630.  
  631.  
  632.  
  633. 17:20:26,356 [get] DEBUG ==> Preparing: SELECT * FROM ME_MEMBER WHERE MEMBER_ID = ?
  634. 17:20:26,356 [get] DEBUG ==> Parameters: 00000000000000156195(String)
  635. 17:20:26,357 [get] DEBUG <== Total: 1
  636. 17:20:26,358 [getList] DEBUG ==> Preparing: SELECT * FROM FU_FUND_ACCOUNT WHERE MEMBER_ID = ?
  637. 17:20:26,358 [getList] DEBUG ==> Parameters: 00000000000000156195(String)
  638. 17:20:26,359 [getList] DEBUG <== Total: 1
  639. 17:20:26,359 [getList] DEBUG ==> Preparing: SELECT * FROM FU_BANK_BIND WHERE FUND_ACCOUNT_ID = ? AND STATE = ?
  640. 17:20:26,359 [getList] DEBUG ==> Parameters: 00000000000000156201(String), 1(String)
  641. 17:20:26,360 [getList] DEBUG <== Total: 1
  642. 17:20:26,360 [getList] DEBUG ==> Preparing: SELECT * FROM ME_MEMBER_VOUCHER WHERE MEMBER_ID = ? AND VOUCHER_STAT = ?
  643. 17:20:26,361 [getList] DEBUG ==> Parameters: 00000000000000156195(String), 0(String)
  644. 17:20:26,362 [getList] DEBUG <== Total: 4
  645. 17:20:26,362 [getList] DEBUG ==> Preparing: SELECT * FROM FU_MEMBER_BANK WHERE BANK_CODE = ?
  646. 17:20:26,362 [getList] DEBUG ==> Parameters: CBC(String)
  647. 17:20:26,363 [getList] DEBUG <== Total: 0
  648.  
  649.  
  650.  
  651.  
  652.  
  653.  
  654.  
  655.  
  656.  
  657.  
  658.  
  659.  
  660.  
  661.  
  662.  
  663.  
  664.  
  665.  
  666.  
  667.  
  668.  
  669.  
  670.  
  671.  
  672.  
  673.  
  674.  
  675.  
  676. 17:20:32,068 [findRunningWithDrawInfo] DEBUG ==> Preparing: SELECT COUNT(*) FROM PM_DATA_RECORD R WHERE R.BUSINESS_ID IN (SELECT F.FUND_TRANS_FLOW_ID FROM FU_FUND_TRANS_FLOW F WHERE F.FUND_ACCOUNT_ID = (SELECT A.FUND_ACCOUNT_ID FROM FU_FUND_ACCOUNT A WHERE A.MEMBER_ID = ?) AND F.TRADE_CODE = '02') AND R.DATA_TYPE = '0007' AND R.DATA_STATE != '3'
  677. 17:20:32,068 [findRunningWithDrawInfo] DEBUG ==> Parameters: 00000000000000156195(String)
  678. 17:20:32,071 [findRunningWithDrawInfo] DEBUG <== Total: 1
  679. 17:20:39,205 [get] DEBUG ==> Preparing: SELECT * FROM ME_MEMBER WHERE MEMBER_ID = ?
  680. 17:20:39,205 [get] DEBUG ==> Parameters: 00000000000001491406(String)
  681. 17:20:39,206 [get] DEBUG <== Total: 1
  682. 17:20:39,207 [getList] DEBUG ==> Preparing: SELECT * FROM FU_FUND_ACCOUNT WHERE MEMBER_ID = ?
  683. 17:20:39,207 [getList] DEBUG ==> Parameters: 00000000000001491406(String)
  684. 17:20:39,208 [getList] DEBUG <== Total: 1
  685. 17:20:39,208 [getList] DEBUG ==> Preparing: SELECT * FROM FU_BANK_BIND WHERE FUND_ACCOUNT_ID = ? AND STATE = ?
  686. 17:20:39,208 [getList] DEBUG ==> Parameters: 00000000000001491412(String), 1(String)
  687. 17:20:39,209 [getList] DEBUG <== Total: 1
  688. 17:20:39,210 [getList] DEBUG ==> Preparing: SELECT * FROM ME_MEMBER_VOUCHER WHERE MEMBER_ID = ? AND VOUCHER_STAT = ?
  689. 17:20:39,210 [getList] DEBUG ==> Parameters: 00000000000001491406(String), 0(String)
  690. 17:20:39,213 [getList] DEBUG <== Total: 16
  691. 17:20:39,213 [getList] DEBUG ==> Preparing: SELECT * FROM FU_MEMBER_BANK WHERE BANK_CODE = ?
  692. 17:20:39,213 [getList] DEBUG ==> Parameters: CMBC(String)
  693. 17:20:39,214 [getList] DEBUG <== Total: 1
  694.  
  695.  
  696. 17:20:45,936 [count] DEBUG ==> Preparing: SELECT COUNT(*) FROM MESS_MESSAGE m join MESS_RECIEVER r on m.ID=r.MESSAGEID WHERE r.STATUS != '2' AND r.USERID=? AND m.ISSDATE >= ? AND ? >= m.ISSDATE
  697. 17:20:45,936 [count] DEBUG ==> Parameters: 00000000000001491406(String), 2018-05-02 17:20:45.936(Timestamp), 2018-08-02 17:20:45.936(Timestamp)
  698. 17:20:45,941 [count] DEBUG <== Total: 1
  699. 17:20:45,941 [getPageList] DEBUG ==> Preparing: SELECT * FROM (SELECT t.*, ROWNUM RN FROM (SELECT r.MESSAGEID,r.STATUS,m.CONTENT,m.ISSDATE,m.TITLE,m.SOURCE FROM MESS_MESSAGE m join MESS_RECIEVER r on m.ID=r.MESSAGEID WHERE m.ID IN (SELECT distinct MESSAGEID FROM MESS_RECIEVER WHERE STATUS != '2' AND USERID=?) AND m.ISSDATE >= ? AND ? >= m.ISSDATE ORDER BY m.ISSDATE DESC ) t WHERE ?>= ROWNUM ) WHERE RN > ?
  700. 17:20:45,941 [getPageList] DEBUG ==> Parameters: 00000000000001491406(String), 2018-05-02 17:20:45.936(Timestamp), 2018-08-02 17:20:45.936(Timestamp), 50(Integer), 0(Integer)
  701. 17:20:45,951 [getPageList] DEBUG <== Total: 50
  702. 17:20:45,951 [getNotReadMsgCnt] DEBUG ==> Preparing: SELECT COUNT(*) FROM MESS_MESSAGE m join MESS_RECIEVER r on m.ID=r.MESSAGEID WHERE r.STATUS ='0' AND r.USERID=? AND m.ISSDATE >= ? AND ? >= m.ISSDATE
  703. 17:20:45,952 [getNotReadMsgCnt] DEBUG ==> Parameters: 00000000000001491406(String), 2018-05-02 17:20:45.936(Timestamp), 2018-08-02 17:20:45.936(Timestamp)
  704. 17:20:45,955 [getNotReadMsgCnt] DEBUG <== Total: 1
  705. 17:20:46,010 [get] DEBUG ==> Preparing: SELECT * FROM ME_MEMBER WHERE MEMBER_ID = ?
  706. 17:20:46,010 [get] DEBUG ==> Parameters: 00000000000001491406(String)
  707. 17:20:46,011 [get] DEBUG <== Total: 1
  708. 17:20:46,012 [getList] DEBUG ==> Preparing: SELECT * FROM FU_FUND_ACCOUNT WHERE MEMBER_ID = ?
  709. 17:20:46,012 [getList] DEBUG ==> Parameters: 00000000000001491406(String)
  710. 17:20:46,013 [getList] DEBUG <== Total: 1
  711. 17:20:46,013 [getList] DEBUG ==> Preparing: SELECT * FROM FU_BANK_BIND WHERE FUND_ACCOUNT_ID = ? AND STATE = ?
  712. 17:20:46,013 [getList] DEBUG ==> Parameters: 00000000000001491412(String), 1(String)
  713. 17:20:46,014 [getList] DEBUG <== Total: 1
  714. 17:20:46,014 [getList] DEBUG ==> Preparing: SELECT * FROM ME_MEMBER_VOUCHER WHERE MEMBER_ID = ? AND VOUCHER_STAT = ?
  715. 17:20:46,014 [getList] DEBUG ==> Parameters: 00000000000001491406(String), 0(String)
  716. 17:20:46,017 [getList] DEBUG <== Total: 16
  717. 17:20:46,017 [getList] DEBUG ==> Preparing: SELECT * FROM FU_MEMBER_BANK WHERE BANK_CODE = ?
  718. 17:20:46,017 [getList] DEBUG ==> Parameters: CMBC(String)
  719. 17:20:46,018 [getList] DEBUG <== Total: 1
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!