1       13:21:30  SQL Execute: ORACLE - select JHLB00,count(DLXH00) DDRS00 from VW_ZY_PDJHXX_WJH   where YJKSBH= 224 and instrb('ABCDE',JHLB00)>0 group by JHLB00

2       13:21:30  SQL Execute: ORACLE - select JHLB00,DLXH00,NWDLXH,BRXM00 from VW_ZY_PDJHXX_YJH   where YJKSBH=224 and JHCKBH = 12 and instrb('ABCDE',JHLB00)>0 order by DLXH00 

3       13:21:33  SQL Execute: ORACLE - select * from VW_ZY_YJJPJ0_JZY where JKDID0 = 44188.00   order by PXH000,PJXH00

4       13:21:35  SQL Execute: ORACLE - select NVL(max(YYID00),'0') YYID00  from  BM_JKB000  where  JKDH00 in (44188) 

5       13:21:35  SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 where NAME00 = 'XT_SFQYBRAFYFKCZMS' 

6       13:21:35  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 44188
7       13:21:35  SQL Execute: ORACLE - select * from VW_ZY_JKB001 where JKDH00 = ? and PJBH00 = 3 

8       13:21:35  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 44188
9       13:21:35  SQL Execute: ORACLE - select * from VW_ZY_JKB001 where JKDH00 = ? and PJBH00 = 8 

10      13:21:35  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 44188
11      13:21:35  SQL Execute: ORACLE - select * from VW_ZY_JKB001 where JKDH00 = ? and PJBH00 = 20 

12      13:21:35  SQL Execute: ORACLE - select XMMC00, sum(XMJE00) XMJE00, sum(QZFJE0) QZFJE0 from VW_ZY_PJSYMX_JZY where JKDID0 = 44188 group by XMMC00

13      13:21:35  SQL Execute: ORACLE - select * from VW_ZY_SKHZ00 where JKDH00 in (44188)

14      13:21:35  SQL Execute: ORACLE - select '0' as ICKH00 from dual

15      13:21:35  SQL Execute: ORACLE - select '0' as ICKH00 from dual

16      13:21:35  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 44188
17      13:21:35  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = '0'
18      13:21:35  SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = '228445'
19      13:21:35  SQL Execute: ORACLE - select YBMC00,sum(ZFJE00) ZFJE00, sum(GRZHZF) GRZHZF, sum(TCJJZF) TCJJZF,sum(YBQTZF) YBQTZF,sum(YBYL05) YBYL05,sum(HJJE00) HJJE00, sum(DLSBJE) DLSBJE, sum(MZBZJE) MZBZJE from VW_ZY_JKJSSR_FB where JKDH00 = ? and (? <> '1' or YYID00 = ?) group by YBMC00 

20      13:22:19  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 17, Scale = 0, Data = ZY_SFQYHTJSPJKPJK
21      13:22:19  SQL Execute: ORACLE - select trim(VALUE0) from XT_XTCS00 where NAME00 = ? 

22      13:22:19  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 44188
23      13:22:19  SQL Execute: ORACLE - select * from VW_ZY_ZFFPXH where JKDH00 = ? 

24      13:22:19  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 44188
25      13:22:19  SQL Execute: ORACLE - select * from VW_ZY_CXFPXH where JKDH00 = ? 

26      13:22:19  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 44188
27      13:22:19  SQL Execute: ORACLE - select a.* from VW_ZY_ZFYJXH a where JKDH00 = ? 

28      13:22:19  SQL Execute: ORACLE - select '2020-04-01 00:00:00至2020-05-26 23:59:59' as JZSJD0 from dual

29      13:22:19  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = ZY_IS_JZ_COUNT_YJJJE
30      13:22:19  SQL Execute: ORACLE - select trim(VALUE0) from XT_XTCS00 where NAME00 = ? 

31      13:22:19  SQL Execute: ORACLE - select 822 as UserId,'9999' as UserCode,'管理员' as UserName,224 as UserLogDepId,'收费室' as UserLogDepName, '5' as UserLogSysCode,'住院收费管理系统' as UserLogSysName,'228445' as HospitalCode,'宁德市康复医院' as HospitalName, '228445' as UserLogDepYYID,'宁德市康复医院' as UserLogDepYYMC  from dual 

32      13:22:20  SQL Execute: ORACLE - select JHLB00,count(DLXH00) DDRS00 from VW_ZY_PDJHXX_WJH   where YJKSBH= 224 and instrb('ABCDE',JHLB00)>0 group by JHLB00

33      13:22:20  SQL Execute: ORACLE - select JHLB00,DLXH00,NWDLXH,BRXM00 from VW_ZY_PDJHXX_YJH   where YJKSBH=224 and JHCKBH = 12 and instrb('ABCDE',JHLB00)>0 order by DLXH00