1 16:23:57 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20151126 2 16:23:57 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20151126 3 16:23:57 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 1197 4 16:23:57 SQL Execute: ORACLE - select a.xmmc00,a.xmgg00,a.xmdw00,a.xmdj00,sum(a.xmsl00)xmsl00,sum(a.hjje00) hjje00,null CZRQ00, a.KDKS00 ks0000,b.BMMC00 from VW_YS_FYMX00 a,BM_BMBM00 b where a.KDKS00=b.BMBH00 and a.CZRQ00>= ? and a.CZRQ00<= ? and KDYS00=? group by a.xmmc00,a.xmgg00,a.xmdw00,a.xmdj00,b.BMMC00,a.KDKS00 5 16:23:57 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20151126 6 16:23:57 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20151126 7 16:23:57 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 1197 8 16:23:57 SQL Execute: ORACLE - select sum(decode(sign(xmbh00-9999999996),1,0,b.hjje00)) zlfy00, sum(decode(sign(xmbh00-9999999996),1,b.hjje00,0)) ypfy00, count(distinct MZH000) ghs000 from SF_BRFY00 a,SF_FYMX00 b where a.DJH000=b.DJH000 and a.CZRQ00>=? and a.CZRQ00<=? and KDYS00=? 9 16:23:57 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20151126 10 16:23:57 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20151126 11 16:23:57 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 1197 12 16:23:57 SQL Execute: ORACLE - select count(1) from SF_BRXXB0 a where THBZ00<>'0' and GHRQ00 between ? and ? AND JZYS00=? and (a.GHLB00>=0 or exists(select 1 from SF_GHF000 where GFLB00=a.GHLB00 and GFLB00<0))