1       15:31:21  SQL Prepare: ORACLE - select * from (SELECT DISTINCT c.ghh000 zyhghh, c.xm0000 brxm00,mzzybz,'' ch0000,DECODE(WCJ000,0,'',WCJ000) WCJ000,DECODE(YCJ000,0,'',YCJ000) YCJ000,DECODE(BTH000,0,'',BTH000) BTH000,DECODE(JZ0000,0,'',JZ0000) JZ0000,B.ZYGHID from (SELECT DISTINCT ZYGHID,MZZYBZ,(SELECT COUNT(1) FROM JY_YW0000 WHERE ZYGHID = A.ZYGHID AND MZZYBZ=A.MZZYBZ AND SQRQ00 between '20140621' AND '20140623'  AND JGZT00='0') WCJ000,(SELECT COUNT(1) FROM JY_YW0000 WHERE ZYGHID = A.ZYGHID AND MZZYBZ=A.MZZYBZ AND SQRQ00 between '20140621' AND '20140623'  AND JGZT00 NOT IN('0','3','7')) YCJ000,(SELECT COUNT(1) FROM JY_YW0000 WHERE ZYGHID = A.ZYGHID AND MZZYBZ=A.MZZYBZ AND SQRQ00 between '20140621' AND '20140623'  AND JGZT00='3') BTH000,(SELECT COUNT(1) FROM JY_YW0000 WHERE ZYGHID = A.ZYGHID AND MZZYBZ=A.MZZYBZ AND SQRQ00 between '20140621' AND '20140623'  AND YXBZ00='Y') JZ0000 FROM VW_JY_YW0000 A WHERE BRZT00='2' AND SQRQ00 between '20140621' AND '20140623'  and MZZYBZ||'T'='0T' and ZYHGHH='5530194' ) B,SF_BRXXB0 c WHERE b.zyghid=c.GHID00  )order by lpad(trim(CH0000),12,'0') 

2       15:31:22  SQL Execute: ORACLE - select * from (SELECT DISTINCT c.ghh000 zyhghh, c.xm0000 brxm00,mzzybz,'' ch0000,DECODE(WCJ000,0,'',WCJ000) WCJ000,DECODE(YCJ000,0,'',YCJ000) YCJ000,DECODE(BTH000,0,'',BTH000) BTH000,DECODE(JZ0000,0,'',JZ0000) JZ0000,B.ZYGHID from (SELECT DISTINCT ZYGHID,MZZYBZ,(SELECT COUNT(1) FROM JY_YW0000 WHERE ZYGHID = A.ZYGHID AND MZZYBZ=A.MZZYBZ AND SQRQ00 between '20140621' AND '20140623'  AND JGZT00='0') WCJ000,(SELECT COUNT(1) FROM JY_YW0000 WHERE ZYGHID = A.ZYGHID AND MZZYBZ=A.MZZYBZ AND SQRQ00 between '20140621' AND '20140623'  AND JGZT00 NOT IN('0','3','7')) YCJ000,(SELECT COUNT(1) FROM JY_YW0000 WHERE ZYGHID = A.ZYGHID AND MZZYBZ=A.MZZYBZ AND SQRQ00 between '20140621' AND '20140623'  AND JGZT00='3') BTH000,(SELECT COUNT(1) FROM JY_YW0000 WHERE ZYGHID = A.ZYGHID AND MZZYBZ=A.MZZYBZ AND SQRQ00 between '20140621' AND '20140623'  AND YXBZ00='Y') JZ0000 FROM VW_JY_YW0000 A WHERE BRZT00='2' AND SQRQ00 between '20140621' AND '20140623'  and MZZYBZ||'T'='0T' and ZYHGHH='5530194' ) B,SF_BRXXB0 c WHERE b.zyghid=c.GHID00  )order by lpad(trim(CH0000),12,'0') 

3       15:31:22  SQL Prepare: ORACLE - select brid00 from sf_brxxb0 where GHH000='5530194' and rownum=1 order by ghid00 desc

4       15:31:22  SQL Execute: ORACLE - select brid00 from sf_brxxb0 where GHH000='5530194' and rownum=1 order by ghid00 desc

5       15:31:22  SQL Prepare: ORACLE - SELECT FBBH00 FROM BM_BRXXB0 WHERE BRID00 = '2087869'

6       15:31:22  SQL Execute: ORACLE - SELECT FBBH00 FROM BM_BRXXB0 WHERE BRID00 = '2087869'

7       15:31:22  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;
8       15:31:22  SQL Prepare: ORACLE - select ZDMC00 from vw_jy_yw0000 where MZZYBZ='0' and ZYGHID='10358963' and ZDID00 is not null and ROWNUM=1

9       15:31:22  SQL Execute: ORACLE - select ZDMC00 from vw_jy_yw0000 where MZZYBZ='0' and ZYGHID='10358963' and ZDID00 is not null and ROWNUM=1

10      15:31:22  SQL Prepare: ORACLE - select SF_SF_HQQFXX('2087869',' ',' ','',0,0,0) from dual

11      15:31:22  SQL Execute: ORACLE - select SF_SF_HQQFXX('2087869',' ',' ','',0,0,0) from dual

12      15:31:22  SQL Prepare: ORACLE - select JYYWID,ZLXMID,ZLXMJC,TXMQZ0,TXMYSZ,TXM000,BBMC00,BBCJL0,BBSM00,SFBZ00,ZJE000,BBID00,0 KDYS00,SQRQ00 KDRQ00,SQSJ00 KDSJ00,SQYSXM,YJFZH0,YJDJH0,JGZT00,THYY00,SQYS00,SFTMWK,CJBZ00,YXBZ00,QDXH00, TDJTTM, TMSFSF,SFYTM0,SFTJ00 from VW_JY_BBCJXX b where zyhghh<>'0' AND ZLXMID NOT IN (19180,19179) AND SQRQ00 between '20140621' and '20140623' AND JGZT00='0'  and BRID00= 2087869  order by SQRQ00 desc

13      15:31:22  SQL Execute: ORACLE - select JYYWID,ZLXMID,ZLXMJC,TXMQZ0,TXMYSZ,TXM000,BBMC00,BBCJL0,BBSM00,SFBZ00,ZJE000,BBID00,0 KDYS00,SQRQ00 KDRQ00,SQSJ00 KDSJ00,SQYSXM,YJFZH0,YJDJH0,JGZT00,THYY00,SQYS00,SFTMWK,CJBZ00,YXBZ00,QDXH00, TDJTTM, TMSFSF,SFYTM0,SFTJ00 from VW_JY_BBCJXX b where zyhghh<>'0' AND ZLXMID NOT IN (19180,19179) AND SQRQ00 between '20140621' and '20140623' AND JGZT00='0'  and BRID00= 2087869  order by SQRQ00 desc

14      15:31:45  SQL Prepare: ORACLE - SELECT QZMC00 FROM JY_QDXHQZ WHERE CJXQ00 = (SELECT to_char(sysdate,'day') FROM DUAL)

15      15:31:45  SQL Execute: ORACLE - SELECT QZMC00 FROM JY_QDXHQZ WHERE CJXQ00 = (SELECT to_char(sysdate,'day') FROM DUAL)

16      15:32:15  SQL Prepare: ORACLE - SELECT QZMC00 FROM JY_QDXHQZ WHERE CJXQ00 = (SELECT to_char(sysdate,'day') FROM DUAL)

17      15:32:15  SQL Execute: ORACLE - SELECT QZMC00 FROM JY_QDXHQZ WHERE CJXQ00 = (SELECT to_char(sysdate,'day') FROM DUAL)

18      15:32:45  SQL Prepare: ORACLE - SELECT QZMC00 FROM JY_QDXHQZ WHERE CJXQ00 = (SELECT to_char(sysdate,'day') FROM DUAL)

19      15:32:45  SQL Execute: ORACLE - SELECT QZMC00 FROM JY_QDXHQZ WHERE CJXQ00 = (SELECT to_char(sysdate,'day') FROM DUAL)

20      15:33:15  SQL Prepare: ORACLE - SELECT QZMC00 FROM JY_QDXHQZ WHERE CJXQ00 = (SELECT to_char(sysdate,'day') FROM DUAL)

21      15:33:15  SQL Execute: ORACLE - SELECT QZMC00 FROM JY_QDXHQZ WHERE CJXQ00 = (SELECT to_char(sysdate,'day') FROM DUAL)