1 15:38:46 SQL Prepare: ORACLE - select (select nvl(sum(bqjc00),0) JE0000 from sf_yjjye0 where (brid00,czrq00) in (select brid00,max(czrq00) czrq00 from sf_yjjye0 where brid00 = 0 and (YYID00='0' OR '0'='0' ) and CZRQ00 <= :1 and CZRQ00||nvl(CZSJ00,'23:59:59') < :2 GROUP BY BRID00)) SQJC00, (select NVL(sum(DECODE(Trim(D.YBLB00),'Z',DECODE(C.ZFFS00,10,0,11,0,C.JFJE00),C.JFJE00)),0) JE0000 from sf_brjfb0 C,BM_BRXXB0 D,BM_BMBM00 E where C.BRID00=D.BRID00 AND C.ZFFS00 not in (14,15) and C.JFRQ00 >=:3 and C.JFRQ00 <=:4 and C.JFRQ00||C.JFSJ00 >=:5 and C.JFRQ00||C.JFSJ00 <=:6 and C.CZYKS0=E.BMBH00 and (E.YYID00='0' OR '0'='0' ) and jflbid = 1 ) BQZJ00, (select NVL(sum(A.ZFJE00),0) JE0000 from sf_brfy00 A,BM_BMBM00 E where A.CZRQ00 >=:7 and A.CZRQ00 <=:8 and A.CZRQ00||A.CZSJ00 >=:9 and A.CZRQ00||A.CZSJ00 <=:10 and A.CZYKS0=E.BMBH00 and (E.YYID00='0' OR '0'='0' ) and A.JFLBID = 1 ) BQJS00 from dual 2 15:38:46 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160201 3 15:38:46 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 2016020100:00:00 4 15:38:46 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160201 5 15:38:46 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160221 6 15:38:46 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 2016020100:00:00 7 15:38:46 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 2016022123:59:59 8 15:38:46 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160201 9 15:38:46 SQL Data In: ORACLE - Param = 8, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160221 10 15:38:46 SQL Data In: ORACLE - Param = 9, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 2016020100:00:00 11 15:38:46 SQL Data In: ORACLE - Param = 10, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 2016022123:59:59 12 15:38:46 SQL Execute: ORACLE - select (select nvl(sum(bqjc00),0) JE0000 from sf_yjjye0 where (brid00,czrq00) in (select brid00,max(czrq00) czrq00 from sf_yjjye0 where brid00 = 0 and (YYID00='0' OR '0'='0' ) and CZRQ00 <= ? and CZRQ00||nvl(CZSJ00,'23:59:59') < ? GROUP BY BRID00)) SQJC00, (select NVL(sum(DECODE(Trim(D.YBLB00),'Z',DECODE(C.ZFFS00,10,0,11,0,C.JFJE00),C.JFJE00)),0) JE0000 from sf_brjfb0 C,BM_BRXXB0 D,BM_BMBM00 E where C.BRID00=D.BRID00 AND C.ZFFS00 not in (14,15) and C.JFRQ00 >=? and C.JFRQ00 <=? and C.JFRQ00||C.JFSJ00 >=? and C.JFRQ00||C.JFSJ00 <=? and C.CZYKS0=E.BMBH00 and (E.YYID00='0' OR '0'='0' ) and jflbid = 1 ) BQZJ00, (select NVL(sum(A.ZFJE00),0) JE0000 from sf_brfy00 A,BM_BMBM00 E where A.CZRQ00 >=? and A.CZRQ00 <=? and A.CZRQ00||A.CZSJ00 >=? and A.CZRQ00||A.CZSJ00 <=? and A.CZYKS0=E.BMBH00 and (E.YYID00='0' OR '0'='0' ) and A.JFLBID = 1 ) BQJS00 from dual 13 15:38:50 SQL Stmt: ORACLE - Fetch 14 15:38:50 SQL Data Out: ORACLE - Column = 1, Name = SQJC00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 29936847.020000 15 15:38:50 SQL Data Out: ORACLE - Column = 2, Name = BQZJ00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 9287619.760000 16 15:38:50 SQL Data Out: ORACLE - Column = 3, Name = BQJS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 8889296.350000 17 15:38:50 SQL Stmt: ORACLE - Reset 18 15:38:50 SQL Stmt: ORACLE - Close 19 15:38:50 SQL Stmt: ORACLE - Close 20 15:38:50 SQL Prepare: ORACLE - select ' 现 金 ' XMMC00,29936847.02 QQJC00,9287619.76 BQZJ00,8889296.35 BQJS00,30335170.43 BQJC00,398323.41 BQYE00 from dual 21 15:38:50 SQL Execute: ORACLE - select ' 现 金 ' XMMC00,29936847.02 QQJC00,9287619.76 BQZJ00,8889296.35 BQJS00,30335170.43 BQJC00,398323.41 BQYE00 from dual 22 15:38:50 SQL Stmt: ORACLE - Fetch 23 15:38:50 SQL Data Out: ORACLE - Column = 1, Name = XMMC00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 现 金 24 15:38:50 SQL Data Out: ORACLE - Column = 2, Name = QQJC00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 29936847.020000 25 15:38:50 SQL Data Out: ORACLE - Column = 3, Name = BQZJ00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 9287619.760000 26 15:38:50 SQL Data Out: ORACLE - Column = 4, Name = BQJS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 8889296.350000 27 15:38:50 SQL Data Out: ORACLE - Column = 5, Name = BQJC00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 30335170.430000 28 15:38:50 SQL Data Out: ORACLE - Column = 6, Name = BQYE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 398323.410000 29 15:38:50 SQL Stmt: ORACLE - Fetch 30 15:38:50 SQL Stmt: ORACLE - EOF 31 15:38:50 SQL Stmt: ORACLE - Reset