1       09:12:42  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 474.000000
2       09:12:42  SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1197.000000
3       09:12:42  SQL Execute: ORACLE - select * from vw_ys_hzbr00
where jzks00=? and jzys00=?
and PBLX00='0'
and dlxh00>=0
order by decode(HZZT00,'4',-1,0),YYSJC0,dlxh00

4       09:12:42  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1197.000000
5       09:12:42  SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 474.000000
6       09:12:42  SQL Execute: ORACLE - select total,a.hzlb00,hzlbmc from bm_hzlb00 a,
 (select count(*) total,hzlb00 from VW_YS_HZBR00
  where hzlb00>1 and jzys00=? and jzks00=?
    and PBLX00='0'
  group by hzlb00 ) b 

where  a.hzlb00=b.hzlb00

7       09:12:42  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3.000000
8       09:12:42  SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1197.000000
9       09:12:42  SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 474.000000
10      09:12:42  SQL Execute: ORACLE - select * from vw_ys_hzbr00
where hzlb00=? and jzys00=?
and jzks00=? and nvl(dlxh00,0)=0
and PBLX00='0'
order by ghrq00,ghsj00

11      09:12:42  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 474.000000
12      09:12:42  SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1197.000000
13      09:12:42  SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 3
14      09:12:42  SQL Execute: ORACLE - select * from vw_ys_yzbr00
where jzks00=? and jzys00=?
and PBLX00='0' and HZZT00=?
 order by dlxh00





15      09:12:42  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 474.000000
16      09:12:42  SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1197.000000
17      09:12:42  SQL Execute: ORACLE - select a.YYH000,a.YYJSSJ,a.YYZT00,a.BRXM00,a.BRXB00 ,KMH000,YYYGXM from vw_yy_bryyxxcx  a where a.YYRQ00=to_char(sysdate,'YYYYMMDD')
and a.YYKSBH=? and a.YYYSBH=?  and a.YYZT00<>'2' order by a.GHHBID,a.YYH000

18      09:12:44  SQL Execute: ORACLE - SELECT COUNT(1) COUNT0 FROM YS_XXJL00 WHERE YSYGBH=1197 AND FSRQ00=TO_CHAR(SYSDATE,'YYYYMMDD') AND SFLL00='0' AND BZ0000='1'