1       16:42:42  SQL Prepare: ORACLE - select * from vw_ss_zybrxx where ZYH000='110001'

2       16:42:42  SQL Execute: ORACLE - select * from vw_ss_zybrxx where ZYH000='110001'

3       16:42:42  SQL Prepare: ORACLE - select a.*,b.ssmc00,c.bz0000 from ss_ywmx00 a,vw_bm_sszd00 b,ss_yw0000 c
where a.ssdh00=:1 and a.ssbh00=b.ssbh00 and a.ssdh00=c.ssdh00
order by SFZSS0

4       16:42:42  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 27482
5       16:42:42  SQL Execute: ORACLE - select a.*,b.ssmc00,c.bz0000 from ss_ywmx00 a,vw_bm_sszd00 b,ss_yw0000 c
where a.ssdh00=? and a.ssbh00=b.ssbh00 and a.ssdh00=c.ssdh00
order by SFZSS0

6       16:42:42  SQL Prepare: ORACLE - select (rownum-1) XH0000,b.* from (select a.*,
a.XX0000 XKXX00, 
 decode(a.jzbz00,'Y','¼±Õï','ÔñÆÚ') JZBZZW from vw_ss_yw0000 a 
where (SSZT00='0' or SSZT00='2') and (ssfybz='0' or ssfybz='1') 
and (mzzybz='0' or (mzzybz='1' and exists (select 1 from zy_brxxb0 where zyid00=a.zyghid and brzt00 like '2%'))) 
and sqrq00 between'20110123' and '20110126'
order by SSDH00) b

7       16:42:42  SQL Execute: ORACLE - select (rownum-1) XH0000,b.* from (select a.*,
a.XX0000 XKXX00, 
 decode(a.jzbz00,'Y','¼±Õï','ÔñÆÚ') JZBZZW from vw_ss_yw0000 a 
where (SSZT00='0' or SSZT00='2') and (ssfybz='0' or ssfybz='1') 
and (mzzybz='0' or (mzzybz='1' and exists (select 1 from zy_brxxb0 where zyid00=a.zyghid and brzt00 like '2%'))) 
and sqrq00 between'20110123' and '20110126'
order by SSDH00) b

8       16:42:42  SQL Prepare: ORACLE - select * from vw_ss_zybrxx where ZYH000='110001'

9       16:42:42  SQL Execute: ORACLE - select * from vw_ss_zybrxx where ZYH000='110001'

10      16:42:42  SQL Prepare: ORACLE - select a.*,b.ssmc00,c.bz0000 from ss_ywmx00 a,vw_bm_sszd00 b,ss_yw0000 c
where a.ssdh00=:1 and a.ssbh00=b.ssbh00 and a.ssdh00=c.ssdh00
order by SFZSS0

11      16:42:42  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 27482
12      16:42:42  SQL Execute: ORACLE - select a.*,b.ssmc00,c.bz0000 from ss_ywmx00 a,vw_bm_sszd00 b,ss_yw0000 c
where a.ssdh00=? and a.ssbh00=b.ssbh00 and a.ssdh00=c.ssdh00
order by SFZSS0

13      16:42:42  SQL Prepare: ORACLE - select * from vw_ss_zybrxx where ZYH000='110001'

14      16:42:42  SQL Execute: ORACLE - select * from vw_ss_zybrxx where ZYH000='110001'

15      16:42:42  SQL Prepare: ORACLE - select a.*,b.ssmc00,c.bz0000 from ss_ywmx00 a,vw_bm_sszd00 b,ss_yw0000 c
where a.ssdh00=:1 and a.ssbh00=b.ssbh00 and a.ssdh00=c.ssdh00
order by SFZSS0

16      16:42:42  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 27482
17      16:42:42  SQL Execute: ORACLE - select a.*,b.ssmc00,c.bz0000 from ss_ywmx00 a,vw_bm_sszd00 b,ss_yw0000 c
where a.ssdh00=? and a.ssbh00=b.ssbh00 and a.ssdh00=c.ssdh00
order by SFZSS0