1 11:16:49 SQL Execute: ORACLE - select substrb(value0,1,1) from xt_xtcs00 where name00='XT_SRFSLXSCT' 2 11:16:49 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = %% 3 11:16:49 SQL Execute: ORACLE - Select * from (select YPMC00,YPNM00,YPBM00,LBBH00,ypmc02,YPGG00,PYSM00,WBSM00,JLDW00,MZFYDW,LSJ000,KCDW00,K2J000,M2J000,FYDJ00,XYKC00,YBLBMC,ZFBL00,YBLB00,YFID00,PCID00,ZQCD00,YYSJDW,CYL000,ZQS000,SFPSYY,YPSPMC,bz0000,JXMC00,ypmclb,F2J000,YPBZ00,MRYYZF,NBLBMC,NBZFBL,YPSYSM,Colour from VW_YS_YBFDMYPSR A where (PYSM00 Like ?) and( LBBH00 in ('1','0','3') AND YFBMBH=495 AND CFJB00 <= 5 AND GZDJ00 <= '1' and KSSDJ0<='5' and YBBRLB='I' and YBZXLB='2' and FBBH00=3 and (exists (select 1 from BM_TSBZB0 C WHERE C.YBZXLB='2' AND C.BH0000='000002000001' AND C.MLXZBZ IN ('0','2')) or exists (select 1 from BM_TSBZXM b, BM_TSBZB0 c where A.YBXMBH=B.XMBH00 AND B.BH0000=C.BH0000 AND B.YBZXLB=C.YBZXLB AND B.YBZXLB='2' AND ( B.BH0000='000002000001' or ( exists (select 1 from VW_YS_TSBZB_GXYTNB L where L.BH0000='000002000001' ) and B.BH0000 in (select BH0000 from VW_YS_TSBZB_GXYTNB)) ) AND C.MLXZBZ IN ('1','3'))) ) Order By PYSM00) where Rownum<=9999 4 11:17:45 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 1057 5 11:17:45 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 474 6 11:17:45 SQL Execute: ORACLE - Select sum(GHXHS0),sum(GHYGHS) from sf_ysghhb where ghmzsj=to_char(sysdate,'yyyymmdd') and ghysbh=? and ghksbh=? 7 11:17:45 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 1057 8 11:17:45 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 474 9 11:17:45 SQL Execute: ORACLE - select count(*) from sf_brxxb0 where thbz00='2' and to_char(sysdate,'yyyymmdd')=jzrq00 and ghlb00<>-99999 and jzys00=? and jzks00=?