1       09:16:46  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2689.000000
2       09:16:46  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 516576      
3       09:16:46  SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20240913
4       09:16:46  SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20240914
5       09:16:46  SQL Execute: ORACLE -  select z.zyh000,z.xm0000,a.rycwh0,z.djh000,z.hjje00,z.zfje00,z.gfje00,z.jzje00,z.czrq00,z.czsj00,z.zyid00,a.MRN000,z.yexm00 from zy_brxxb0  a,zy_brfy00 z  where  z.hjje00>=0  and nvl(a.BRSZXT,'0')='0' and  
z.brid00=a.brid00(+) and z.zyid00=a.zyid00(+) and a.brzt00 like '2%' 
 and exists(select 'Y' from zy_fymx00 where DJH000=Z.DJH000 and  KDBQ00=? and XMBH00<9999999990) and (not exists (select 1 from yj_yw0000 where zyghid=z.zyid00 and mzzybz='1' and sfdjh0=z.djh000 and zlxmid>0) or exists (select 1 from zy_fymx00 k,xt_zlsfgx b where k.djh000=z.djh000 and k.xmbh00=b.sfxmid and k.zxks00=a.dqks00 and b.gdbz00='N' and b.fjfybz='Y' and b.bqsfbz='Y'))
 and  Z.ZYH000    = ? and  Z.CZRQ00 >= ? and  Z.CZRQ00 <  ?
 order by z.CZRQ00,z.CZSJ00

6       09:16:46  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 28359687.000000
7       09:16:46  SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 28359687.000000
8       09:16:46  SQL Execute: ORACLE - SELECT XMZT00,DECODE(Z.CXBZ00,'+','已退',DECODE(XMZT00,NULL,'正常','1','申请退费','5','疑退','6','作废','已退')) SFSQ00,Z.*
FROM   ZY_FYMX00 Z,(SELECT J.MXID00,W.XMZT00 FROM YJ_YWJJ00 J,YJ_YW0000 W,YJ_YW0000 M
                    WHERE  J.YJDJH0=W.YJDJH0 AND J.CXBZ00='-' AND
                    W.CXDJH0=M.YJDJH0 AND M.SFDJH0=? )X,ZY_BRFY00 F
WHERE  Z.DJH000=? AND Z.MXID00=X.MXID00(+)
AND Z.DJH000=F.DJH000
AND Z.CXBZ00 IN ('+','Z')
and not exists(select 1 from YJ_YWJJ00 where MXID00=Z.MXID00 and SL0000<0  and nvl(CXLB00,'0')='0')  
and SF_BQ_CHECKSFKT(F.ZYID00,F.DJH000,Z.MXID00,Z.XMBH00)=0