1 17:31:42 SQL Execute: ORACLE - Select SYSDATE from Dual 2 17:31:42 SQL Execute: ORACLE - select Value0 from XT_XTCS00 where NAME00 = 'IC_BBH' 3 17:31:42 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL') and KLDH00 = 'SLE4442' and KLDH00 not in ('CK','JMCK') 4 17:31:42 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL') and KLDH00 = 'YB-FZYB' and KLDH00 not in ('CK','JMCK') 5 17:31:42 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL') and KLDH00 = 'YB-SBK' and KLDH00 not in ('CK','JMCK') 6 17:31:43 SQL Execute: ORACLE - select ICKH00,YGBH00,BRID00,KMH000,ZT0000 from IC_YHXX00 where ICKH00 = 'FZYBA99166977' and ICKNBH = 'FZYBA99166977' 7 17:31:43 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 14, Scale = 0, Data = 一卡通平台参数 8 17:31:43 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = SF_SFQYYKTPT 9 17:31:43 SQL Execute: ORACLE - select SF_SF_TYZD00(?,?)FHJG00 from dual 10 17:31:43 SQL Execute: ORACLE - Commit 11 17:31:43 SQL Data In: ORACLE - Rows affected = 0 12 17:31:43 SQL Execute: ORACLE - select count(*) from YS_QTJHXX where brid00='601750' 13 17:31:43 SQL Execute: ORACLE - select distinct MZZYBZ,ZYHGHH,ICKH00,BRBLH0,BRXM00,XB0000,XBMC00,NL0000||NLDWMC NL0000,FBMC00,BRID00,YXBZ00,SQKSMC,SQYSXM,ZYGHID,ZDID00,ZDMC00 from VW_JY_YW0000 where BRID00='601750' and SQRQ00 between '20200306' and '20200310' order by ZYHGHH DESC 14 17:31:43 SQL Data In: ORACLE - Param = 1, Name = PBRID00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = 601750 15 17:31:43 SQL Data In: ORACLE - Param = 2, Name = PZYHGHH, Type = fldZSTRING, Precision = 255, Scale = 0, Data = 4799170 16 17:31:43 SQL Data In: ORACLE - Param = 3, Name = PMZZYBZ, Type = fldZSTRING, Precision = 255, Scale = 0, Data = 0 17 17:31:43 SQL Data In: ORACLE - Param = 4, Name = PZYGHID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 18 17:31:43 SQL Data In: ORACLE - Param = 5, Name = PBLH000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 19 17:31:43 SQL Data In: ORACLE - Param = 6, Name = PXM0000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 20 17:31:43 SQL Data In: ORACLE - Param = 7, Name = PXB0000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 21 17:31:43 SQL Data In: ORACLE - Param = 8, Name = PCH0000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 22 17:31:43 SQL Data In: ORACLE - Param = 9, Name = PYBLB00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 23 17:31:43 SQL Data In: ORACLE - Param = 10, Name = PKSMC00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 24 17:31:43 SQL Data In: ORACLE - Param = 11, Name = PKSBH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 25 17:31:43 SQL Data In: ORACLE - Param = 12, Name = PCSRQ00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 26 17:31:43 SQL Data In: ORACLE - Param = 13, Name = PNL0000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 27 17:31:43 SQL Data In: ORACLE - Param = 14, Name = PMZYE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 28 17:31:43 SQL Data In: ORACLE - Param = 15, Name = PZYYE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 29 17:31:43 SQL Data In: ORACLE - Param = 16, Name = PFBMC00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 30 17:31:43 SQL Data In: ORACLE - Param = 17, Name = PYBBRLB, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 31 17:31:43 SQL Data In: ORACLE - Param = 18, Name = PYBMC00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 32 17:31:43 SQL Data In: ORACLE - Param = 19, Name = PFBBH00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 33 17:31:43 SQL Execute: ORACLE - BEGIN "SP_JY_GETBRXX" (PBRID00 => :PBRID00,PZYHGHH => :PZYHGHH,PMZZYBZ => :PMZZYBZ,PZYGHID => :PZYGHID,PBLH000 => :PBLH000,PXM0000 => :PXM0000,PXB0000 => :PXB0000,PCH0000 => :PCH0000,PYBLB00 => :PYBLB00,PKSMC00 => :PKSMC00,PKSBH00 => :PKSBH00,PCSRQ00 => :PCSRQ00,PNL0000 => :PNL0000,PMZYE00 => :PMZYE00,PZYYE00 => :PZYYE00,PFBMC00 => :PFBMC00,PYBBRLB => :PYBBRLB,PYBMC00 => :PYBMC00,PFBBH00 => :PFBBH00); END; 34 17:31:43 SQL Execute: ORACLE - SELECT SQYSXM FROM VW_JY_YW0000 WHERE MZZYBZ = '0' AND ZYHGHH = '4799170' AND ROWNUM = 1 35 17:31:43 SQL Execute: ORACLE - select SF_SF_HQQFXX('601750',' ',' ','',0,0,0) from dual 36 17:31:43 SQL Execute: ORACLE - select YXBZ00,ZLXMID,ZLXMJC,TXMQZ0,TXMYSZ,TXM000,BBMC00,BBCJL0,BBSM00,ZJE000,BBID00,0 KDYS00,SQRQ00 KDRQ00,SQSJ00 KDSJ00,SQYSXM,YJFZH0,YJDJH0,JGZT00,THYY00,SQYS00,YJKSBH,JYYWID,SFXWFS,SQKS00 from VW_JY_BBCJXX b where BRID00= '601750' and MZZYBZ='0' and SQRQ00 between '20200306' and '20200310' AND ZYHGHH = '4799170' and JGZT00='0' order by SQRQ00 DESC,TXM000