1       10:07:14  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20200108
2       10:07:14  SQL Execute: ORACLE - select a.*,(select BMMC00 from bm_bmbm00 where bmbh00=a.ksh000) ksmc00,(BWBRS0+BZBRS0) WZRS00 from zh_zyrbb0 a where A.zyrq00=? 
 and (RYRS00<>0 or ZRRS00<>0 or CYRS00<>0 or ZCRS00<>0)
 order by a.bqh000,a.ksh000 

3       10:07:14  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20200108
4       10:07:14  SQL Execute: ORACLE - Select a.ZYRQ00,(select BMMC00 from bm_bmbm00 where bmbh00=a.ksh000) ksmc00,a.BQH000,a.KSH000,a.flag00,b.zyh000,b.xm0000,b.xb0000,decode(a.cyflag,'0','治愈','1','好转','2','未愈','3','死亡','4','其他','其他') CYZT00
 from zy_zybrmx a,zy_brxxb0 b where a.zyid00=b.zyid00 and a.zyrq00=? and flag00='1' 
 order by a.bqh000,a.ksh000,b.zyh000 

5       10:07:15  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20200108
6       10:07:15  SQL Execute: ORACLE - Select a.ZYRQ00,(select BMMC00 from bm_bmbm00 where bmbh00=a.ksh000) ksmc00,a.BQH000,a.KSH000,a.flag00,b.zyh000,b.xm0000,b.xb0000,(b.cydjrq-b.sjryrq) zyts00,b.rcyfh0
 from zy_zybrmx a,zy_brxxb0 b where a.zyid00=b.zyid00 and a.zyrq00=? and flag00='2' 
 order by a.bqh000,a.ksh000,b.zyh000 

7       10:07:15  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20200108
8       10:07:15  SQL Execute: ORACLE - Select a.ZYRQ00,(select BMMC00 from bm_bmbm00 where bmbh00=a.ksh000) ksmc00,a.BQH000,a.KSH000,a.flag00,b.zyh000,b.xm0000,b.xb0000,decode(a.cyflag,'0','治愈','1','好转','2','未愈','3','死亡','4','其他','其他') CYZT00
 from zy_zybrmx a,zy_brxxb0 b where a.zyid00=b.zyid00 and a.zyrq00=? and flag00='3' 
 order by a.bqh000,a.ksh000,b.zyh000 

9       10:07:16  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20200108
10      10:07:16  SQL Execute: ORACLE - Select a.ZYRQ00,(select BMMC00 from bm_bmbm00 where bmbh00=a.ksh000) ksmc00,a.BQH000,a.KSH000,a.flag00,b.zyh000,b.xm0000,b.xb0000,decode(a.cyflag,'0','治愈','1','好转','2','未愈','3','死亡','4','其他','其他') CYZT00
 from zy_zybrmx a,zy_brxxb0 b where a.zyid00=b.zyid00 and a.zyrq00=? and flag00='4' 
 order by a.bqh000,a.ksh000,b.zyh000