1       11:10:08  SQL Prepare: ORACLE -  SELECT S.XMMC00,S.DW0000,S.SFJE00,SUM(M.XMSL00)SL0000,SUM(M.HJJE00)HJJE00,SUBSTR(F.CZRQ00,1,6)CZRQ00,P.XMMC00 FPXMMC FROM   ZY_FYMX00 M,ZY_BRFY00  F,BM_YYSFXM S,BM_YGBM00 Y,ZY_BRXXB0 B,BM_YPLB00 L,BM_FPXM00 P WHERE  M.DJH000=F.DJH000 AND M.XMBH00=S.SFXMID AND S.SFXMID=L.SFDM00(+) AND S.ZYFPID=P.FPXMID AND F.ZYID00=B.ZYID00 AND F.CZY000=Y.YGBH00  AND F.CZRQ00 BETWEEN :1 AND :2
 AND M.ZXKS00 IN (SELECT KSH000 FROM BM_BQKS00 WHERE BQH000=:3)
 AND M.KDBQ00>=0
GROUP BY S.XMMC00,S.DW0000,SUBSTR(F.CZRQ00,1,6),S.SFJE00,P.XMMC00

2       11:10:08  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20100626
3       11:10:08  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20100726
4       11:10:08  SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 362.000000
5       11:10:08  SQL Execute: ORACLE -  SELECT S.XMMC00,S.DW0000,S.SFJE00,SUM(M.XMSL00)SL0000,SUM(M.HJJE00)HJJE00,SUBSTR(F.CZRQ00,1,6)CZRQ00,P.XMMC00 FPXMMC FROM   ZY_FYMX00 M,ZY_BRFY00  F,BM_YYSFXM S,BM_YGBM00 Y,ZY_BRXXB0 B,BM_YPLB00 L,BM_FPXM00 P WHERE  M.DJH000=F.DJH000 AND M.XMBH00=S.SFXMID AND S.SFXMID=L.SFDM00(+) AND S.ZYFPID=P.FPXMID AND F.ZYID00=B.ZYID00 AND F.CZY000=Y.YGBH00  AND F.CZRQ00 BETWEEN ? AND ?
 AND M.ZXKS00 IN (SELECT KSH000 FROM BM_BQKS00 WHERE BQH000=?)
 AND M.KDBQ00>=0
GROUP BY S.XMMC00,S.DW0000,SUBSTR(F.CZRQ00,1,6),S.SFJE00,P.XMMC00

6       11:10:10  SQL Prepare: ORACLE - select * from zs_xxjlb0 where (JSFBH0=2 or (JSKSBH=362 and JSFBH0=0))
 and XXCSFX=0 and SFLL00=0 

7       11:10:10  SQL Execute: ORACLE - select * from zs_xxjlb0 where (JSFBH0=2 or (JSKSBH=362 and JSFBH0=0))
 and XXCSFX=0 and SFLL00=0 

8       11:10:15  SQL Prepare: ORACLE - select * from zs_xxjlb0 where (JSFBH0=2 or (JSKSBH=362 and JSFBH0=0))
 and XXCSFX=0 and SFLL00=0 

9       11:10:15  SQL Execute: ORACLE - select * from zs_xxjlb0 where (JSFBH0=2 or (JSKSBH=362 and JSFBH0=0))
 and XXCSFX=0 and SFLL00=0