1       10:43:49  SQL Execute: ORACLE - select  *  from  BM_PJLYQK  where PJLXBM = 3  and  PJSYR0 =523
 and  SYBZ00 = 'Y'

2       10:43:49  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = ³Â²Êϼ
3       10:43:49  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160509
4       10:43:49  SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160509
5       10:43:49  SQL Execute: ORACLE -  select  A.*,B.PJXH00,B.PJZT00,B.PJH000 PJH001,b.BDBZ00,
 (select sum(xmje00) from zy_pjsymx where zy_pjsymx.pjh000=b.pjh000) BRZJE1,
 b.plbh00  from  VW_ZY_FP0000 A, ZY_PJSYQK B  where  A.PJH000 = B.FZPJH0 
  and  A.JZYXM0 = ?

  and A.JZRQ00 >= ?
  and A.JZRQ00 <= ? 
  order  by  A.jzdh00  desc  

6       10:43:50  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1744641.000000
7       10:43:50  SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2109966.000000
8       10:43:50  SQL Execute: ORACLE -  select  * from  VW_ZY_FP0000  where  JZDH00 =?  and zyid00=?

9       10:43:50  SQL Execute: ORACLE -  select SF_ZY_YBFPJE(1744641,1) XSNR00 from dual

10      10:43:50  SQL Execute: ORACLE -  select SF_ZY_YBFPJE(1744641,2) XSNR00 from dual

11      10:43:50  SQL Execute: ORACLE -  select SF_ZY_YBFPJE(1744641,7) XSNR00 from dual

12      10:43:50  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2588330.000000
13      10:43:50  SQL Execute: ORACLE - select sum(xmje00) hjje00 from  ZY_PJSYMX where PJH000= ?

14      10:43:50  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1744641.000000
15      10:43:50  SQL Execute: ORACLE -  select * from zy_jzmx00  where sfylxm='Y' and jzdh00 = ?

16      10:43:50  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1744641.000000
17      10:43:50  SQL Execute: ORACLE -  select * from zy_jzmx00 where  jzdh00 = ?

18      10:43:50  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2109966.000000
19      10:43:50  SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2588330.000000
20      10:43:50  SQL Execute: ORACLE - Select *  from  ZY_PJSYQK_DBZ000 where zyid00=? and ZCPJH0=? and pjzt00='0'