1       19:25:33  SQL Execute: ORACLE - select TO_CHAR(SYSDATE,'YYYYMMDDHH24:MI:SS') time00 from dual

2       19:25:33  SQL Execute: ORACLE - select value0 from XT_XTCS00 where name00 in ('JY_ZYTMDYYLSFGXJGZT')

3       19:25:33  SQL Execute: ORACLE - select DISTINCT ZYGHID ZYID00,BRXM00,XB0000,NL0000,TXMMC0,'²¹´ò' JBXX01,TO_CHAR(SYSDATE,'YYYY-MM-DD HH24:MI:SS') CYRQSJ,BBMC00, CH0000,txm000,XMMC00,YBTJ00,YBSM00,BRLB00,BMMC00,JZBZ00,ZYHGHH,'1' rownum1, nvl((select d.ZWXM00 from JY_YW0000 c,BM_YGBM00 d  where c.sqys00=d.YGBH00 and c.txm000=a.txm000 and rownum=1),a.sqysxm) sqysxm,a.XMMSMC  from VW_JY_TXMCJD a  where MZZYBZ='1' AND ((KDBQ00=481) or (0=0)) AND KDRQ00 Between '20170716' And '20170719' and ZYGHID in (362807) AND NVL(CJKSBH,KDBQ00)=481  AND NVL(TMDYRQ,'0')<>'0' AND YJDJH0 IN ('-1','7817821','7817822','7817823','7817824','7808661','7808660') 

4       19:25:33  SQL Execute: ORACLE - select count(*) from JY_YW0000 where (SQKS00+0=481 or SQBQ00+0=481) and JGZT00 in ('6','8') and YXBZ00='Y' and BGCKR0 is null and pyrq00>=to_char(sysdate-30,'yyyymmdd')

5       19:25:39  SQL Execute: ORACLE - select count(*) from JY_YW0000 where (SQKS00+0=481 or SQBQ00+0=481) and JGZT00 in ('6','8') and YXBZ00='Y' and BGCKR0 is null and pyrq00>=to_char(sysdate-30,'yyyymmdd')

6       19:25:45  SQL Execute: ORACLE - select count(*) from JY_YW0000 where (SQKS00+0=481 or SQBQ00+0=481) and JGZT00 in ('6','8') and YXBZ00='Y' and BGCKR0 is null and pyrq00>=to_char(sysdate-30,'yyyymmdd')

7       19:25:51  SQL Execute: ORACLE - select count(*) from JY_YW0000 where (SQKS00+0=481 or SQBQ00+0=481) and JGZT00 in ('6','8') and YXBZ00='Y' and BGCKR0 is null and pyrq00>=to_char(sysdate-30,'yyyymmdd')