1 08:44:01 SQL Prepare: ORACLE - select YPLBBH,YFBMBH from XT_YPFWFX where SLBMBH = 68 and MRBZ00 = 'Y' 2 08:44:01 SQL Execute: ORACLE - select YPLBBH,YFBMBH from XT_YPFWFX where SLBMBH = 68 and MRBZ00 = 'Y' 3 08:44:01 SQL Prepare: ORACLE - select YEXM00 from BQ_JSXX00 where ZYID00 = 235371 4 08:44:01 SQL Execute: ORACLE - select YEXM00 from BQ_JSXX00 where ZYID00 = 235371 5 08:44:01 SQL Prepare: ORACLE - select NAME00,to_char(sysdate,'YYYY.MM.DD')TODAY,to_char(sysdate,'HH24:MI') NOWTIME,VALUE0 from XT_XTCS00 where NAME00 in ('BQ_FYYZMRQYSJ','BQ_PTYZMRQYSJ','ZS_YZ_DQSJWYZQYSJ') order by NAME00 6 08:44:01 SQL Execute: ORACLE - select NAME00,to_char(sysdate,'YYYY.MM.DD')TODAY,to_char(sysdate,'HH24:MI') NOWTIME,VALUE0 from XT_XTCS00 where NAME00 in ('BQ_FYYZMRQYSJ','BQ_PTYZMRQYSJ','ZS_YZ_DQSJWYZQYSJ') order by NAME00 7 08:44:01 SQL Prepare: ORACLE - select a.KZYS00,c.ZWXM00,a.QYRQ00,a.PXSJ00,c.CFJB00,c.MZDJ00,c.DPDJ00,c.SJDJ00 from BQ_YPYZ00 a,VW_BQ_YSBM00 c where c.YGBH00 = a.KZYS00 and a.ZYID00 = '235371' and a.KSH000 = '43' Union All select b.KZYS00,c.ZWXM00,b.QYRQ00,b.PXSJ00,c.CFJB00,c.MZDJ00,c.DPDJ00,c.SJDJ00 from BQ_YJYZ00 b,VW_BQ_YSBM00 c where c.YGBH00 = b.KZYS00 and b.ZYID00 = '235371' and b.KSH000 = '43' Union All select a.ZZYS00,a.ZZYSXM,RYRQ00 QYRQ00,RYSJ00 PXSJ00,c.CFJB00,c.MZDJ00,c.DPDJ00,c.SJDJ00 from zy_brxxb0 a,VW_BQ_YSBM00 c where a.ZZYS00 = c.YGBH00 and a.ZYID00 = '235371' order by QYRQ00 desc,PXSJ00 desc 8 08:44:01 SQL Execute: ORACLE - select a.KZYS00,c.ZWXM00,a.QYRQ00,a.PXSJ00,c.CFJB00,c.MZDJ00,c.DPDJ00,c.SJDJ00 from BQ_YPYZ00 a,VW_BQ_YSBM00 c where c.YGBH00 = a.KZYS00 and a.ZYID00 = '235371' and a.KSH000 = '43' Union All select b.KZYS00,c.ZWXM00,b.QYRQ00,b.PXSJ00,c.CFJB00,c.MZDJ00,c.DPDJ00,c.SJDJ00 from BQ_YJYZ00 b,VW_BQ_YSBM00 c where c.YGBH00 = b.KZYS00 and b.ZYID00 = '235371' and b.KSH000 = '43' Union All select a.ZZYS00,a.ZZYSXM,RYRQ00 QYRQ00,RYSJ00 PXSJ00,c.CFJB00,c.MZDJ00,c.DPDJ00,c.SJDJ00 from zy_brxxb0 a,VW_BQ_YSBM00 c where a.ZZYS00 = c.YGBH00 and a.ZYID00 = '235371' order by QYRQ00 desc,PXSJ00 desc 9 08:44:03 SQL Prepare: ORACLE - Select * from (select YPMC00,YPGG00,YPBM00,PYSM00,WBSM00,YPNM00,LSJXX0,SJKCXX,YBLBMC,bz0000,ZFBL00,YDYPMC,colour from VW_BQ_YBYP00 where (PYSM00 Like :1 or YPBM00 Like :2) and( (cfjb00<='0' and dpdj00<='1' and mzdj00<='1' and (sjdj00='0' or (SJDJ00 >='1' and '1'>'0'))) and YBZXLB = '2' and FBBH00 = '3' and YBBRLB = 'D' and ((YFBMBH = '55' and LBBH00 = '0') or (YFBMBH = '120'and LBBH00 = '1') Or (YFBMBH = '0' and LBBH00 = '3') Or (BQKDYF='Y' and LBBH00 in ('0','1','3'))) ) Order By YPBM00,PYSM00) where Rownum<=500 10 08:44:03 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = %% 11 08:44:03 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = %% 12 08:44:03 SQL Execute: ORACLE - Select * from (select YPMC00,YPGG00,YPBM00,PYSM00,WBSM00,YPNM00,LSJXX0,SJKCXX,YBLBMC,bz0000,ZFBL00,YDYPMC,colour from VW_BQ_YBYP00 where (PYSM00 Like ? or YPBM00 Like ?) and( (cfjb00<='0' and dpdj00<='1' and mzdj00<='1' and (sjdj00='0' or (SJDJ00 >='1' and '1'>'0'))) and YBZXLB = '2' and FBBH00 = '3' and YBBRLB = 'D' and ((YFBMBH = '55' and LBBH00 = '0') or (YFBMBH = '120'and LBBH00 = '1') Or (YFBMBH = '0' and LBBH00 = '3') Or (BQKDYF='Y' and LBBH00 in ('0','1','3'))) ) Order By YPBM00,PYSM00) where Rownum<=500 13 08:44:03 SQL Prepare: ORACLE - Select * from (select YPMC00,YPGG00,YPBM00,PYSM00,WBSM00,YPNM00,LSJXX0,SJKCXX,YBLBMC,bz0000,ZFBL00,YDYPMC,colour from VW_BQ_YBYP00 where (PYSM00 Like :1) and( (cfjb00<='0' and dpdj00<='1' and mzdj00<='1' and (sjdj00='0' or (SJDJ00 >='1' and '1'>'0'))) and YBZXLB = '2' and FBBH00 = '3' and YBBRLB = 'D' and ((YFBMBH = '55' and LBBH00 = '0') or (YFBMBH = '120'and LBBH00 = '1') Or (YFBMBH = '0' and LBBH00 = '3') Or (BQKDYF='Y' and LBBH00 in ('0','1','3'))) ) Order By PYSM00) where Rownum<=500 14 08:44:03 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = %m% 15 08:44:03 SQL Execute: ORACLE - Select * from (select YPMC00,YPGG00,YPBM00,PYSM00,WBSM00,YPNM00,LSJXX0,SJKCXX,YBLBMC,bz0000,ZFBL00,YDYPMC,colour from VW_BQ_YBYP00 where (PYSM00 Like ?) and( (cfjb00<='0' and dpdj00<='1' and mzdj00<='1' and (sjdj00='0' or (SJDJ00 >='1' and '1'>'0'))) and YBZXLB = '2' and FBBH00 = '3' and YBBRLB = 'D' and ((YFBMBH = '55' and LBBH00 = '0') or (YFBMBH = '120'and LBBH00 = '1') Or (YFBMBH = '0' and LBBH00 = '3') Or (BQKDYF='Y' and LBBH00 in ('0','1','3'))) ) Order By PYSM00) where Rownum<=500 16 08:44:04 SQL Prepare: ORACLE - Select * from (select YPMC00,YPGG00,YPBM00,PYSM00,WBSM00,YPNM00,LSJXX0,SJKCXX,YBLBMC,bz0000,ZFBL00,YDYPMC,colour from VW_BQ_YBYP00 where (PYSM00 Like :1) and( (cfjb00<='0' and dpdj00<='1' and mzdj00<='1' and (sjdj00='0' or (SJDJ00 >='1' and '1'>'0'))) and YBZXLB = '2' and FBBH00 = '3' and YBBRLB = 'D' and ((YFBMBH = '55' and LBBH00 = '0') or (YFBMBH = '120'and LBBH00 = '1') Or (YFBMBH = '0' and LBBH00 = '3') Or (BQKDYF='Y' and LBBH00 in ('0','1','3'))) ) Order By PYSM00) where Rownum<=500 17 08:44:04 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = %md% 18 08:44:04 SQL Execute: ORACLE - Select * from (select YPMC00,YPGG00,YPBM00,PYSM00,WBSM00,YPNM00,LSJXX0,SJKCXX,YBLBMC,bz0000,ZFBL00,YDYPMC,colour from VW_BQ_YBYP00 where (PYSM00 Like ?) and( (cfjb00<='0' and dpdj00<='1' and mzdj00<='1' and (sjdj00='0' or (SJDJ00 >='1' and '1'>'0'))) and YBZXLB = '2' and FBBH00 = '3' and YBBRLB = 'D' and ((YFBMBH = '55' and LBBH00 = '0') or (YFBMBH = '120'and LBBH00 = '1') Or (YFBMBH = '0' and LBBH00 = '3') Or (BQKDYF='Y' and LBBH00 in ('0','1','3'))) ) Order By PYSM00) where Rownum<=500 19 08:44:04 SQL Prepare: ORACLE - Select * from (select YPMC00,YPGG00,YPBM00,PYSM00,WBSM00,YPNM00,LSJXX0,SJKCXX,YBLBMC,bz0000,ZFBL00,YDYPMC,colour from VW_BQ_YBYP00 where (PYSM00 Like :1) and( (cfjb00<='0' and dpdj00<='1' and mzdj00<='1' and (sjdj00='0' or (SJDJ00 >='1' and '1'>'0'))) and YBZXLB = '2' and FBBH00 = '3' and YBBRLB = 'D' and ((YFBMBH = '55' and LBBH00 = '0') or (YFBMBH = '120'and LBBH00 = '1') Or (YFBMBH = '0' and LBBH00 = '3') Or (BQKDYF='Y' and LBBH00 in ('0','1','3'))) ) Order By PYSM00) where Rownum<=500 20 08:44:04 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = %mdy% 21 08:44:04 SQL Execute: ORACLE - Select * from (select YPMC00,YPGG00,YPBM00,PYSM00,WBSM00,YPNM00,LSJXX0,SJKCXX,YBLBMC,bz0000,ZFBL00,YDYPMC,colour from VW_BQ_YBYP00 where (PYSM00 Like ?) and( (cfjb00<='0' and dpdj00<='1' and mzdj00<='1' and (sjdj00='0' or (SJDJ00 >='1' and '1'>'0'))) and YBZXLB = '2' and FBBH00 = '3' and YBBRLB = 'D' and ((YFBMBH = '55' and LBBH00 = '0') or (YFBMBH = '120'and LBBH00 = '1') Or (YFBMBH = '0' and LBBH00 = '3') Or (BQKDYF='Y' and LBBH00 in ('0','1','3'))) ) Order By PYSM00) where Rownum<=500 22 08:44:07 SQL Prepare: ORACLE - select * from VW_BQ_YFYPSC where YPNM00 = '4759' and ((YFBMBH = '55' and LBBH00 = '0') or (YFBMBH = '120' and LBBH00 = '1') or (YFBMBH = '0' and LBBH00 = '3') Or (BQKDYF='Y' and LBBH00 in ('0','1','3')) ) 23 08:44:07 SQL Execute: ORACLE - select * from VW_BQ_YFYPSC where YPNM00 = '4759' and ((YFBMBH = '55' and LBBH00 = '0') or (YFBMBH = '120' and LBBH00 = '1') or (YFBMBH = '0' and LBBH00 = '3') Or (BQKDYF='Y' and LBBH00 in ('0','1','3')) )