1       08:45:23  SQL Prepare: ORACLE - select * from BM_TYZD00 where ZDMC00='智方危机值配置' 

2       08:45:23  SQL Execute: ORACLE - select * from BM_TYZD00 where ZDMC00='智方危机值配置' 

3       08:45:23  SQL Prepare: ORACLE - select * from VW_ZFLIS_JYWJZXX where  ZT0000='0' 
 and (KDKS00=939 or KDBQ00=939)
 order by RECEIVEDATE,CNAME 

4       08:45:23  SQL Execute: ORACLE - select * from VW_ZFLIS_JYWJZXX where  ZT0000='0' 
 and (KDKS00=939 or KDBQ00=939)
 order by RECEIVEDATE,CNAME 

5       08:45:23  SQL Prepare: ORACLE -  SELECT XXID00 XH0000,XXNR00,to_char(to_date(FSRQ00,'YYYY.MM.DD'),'YYYY.MM.DD') FSRQ00,YJKSMC FROM VW_BQ_YJYZCZXX a 
 where XXLB00='1'
  and SFLL00='0' 
  and (DQBQ00=939 or DQKS00=939)
 order by XXID00 

6       08:45:23  SQL Execute: ORACLE -  SELECT XXID00 XH0000,XXNR00,to_char(to_date(FSRQ00,'YYYY.MM.DD'),'YYYY.MM.DD') FSRQ00,YJKSMC FROM VW_BQ_YJYZCZXX a 
 where XXLB00='1'
  and SFLL00='0' 
  and (DQBQ00=939 or DQKS00=939)
 order by XXID00 

7       08:45:29  SQL Prepare: ORACLE - Select b.bmmc00,f.yfbmbh from xt_ypfwfx f,bm_bmbm00 b where f.yfbmbh=b.bmbh00 and mrbz00='N' and Slbmbh=939

8       08:45:29  SQL Execute: ORACLE - Select b.bmmc00,f.yfbmbh from xt_ypfwfx f,bm_bmbm00 b where f.yfbmbh=b.bmbh00 and mrbz00='N' and Slbmbh=939

9       08:45:29  SQL Prepare: ORACLE - select *  from BM_TYZD00 where ZDMC00='急诊时间段' and to_char(sysdate,'HH24:MI:SS')>=substr(MC0000,1,8) 
 and to_char(sysdate,'HH24:MI:SS')<=substr(MC0000,10,8) and YXBZ00='1' and BH0000<>'1' 

10      08:45:29  SQL Execute: ORACLE - select *  from BM_TYZD00 where ZDMC00='急诊时间段' and to_char(sysdate,'HH24:MI:SS')>=substr(MC0000,1,8) 
 and to_char(sysdate,'HH24:MI:SS')<=substr(MC0000,10,8) and YXBZ00='1' and BH0000<>'1' 

11      08:45:29  SQL Prepare: ORACLE - Select b.bmmc00,f.yfbmbh,f.yplbbh from xt_ypfwfx f,bm_bmbm00 b where f.yfbmbh=b.bmbh00 and mrbz00='N' and Slbmbh=939

12      08:45:29  SQL Execute: ORACLE - Select b.bmmc00,f.yfbmbh,f.yplbbh from xt_ypfwfx f,bm_bmbm00 b where f.yfbmbh=b.bmbh00 and mrbz00='N' and Slbmbh=939

13      08:45:33  SQL Prepare: ORACLE -  SELECT XXID00 XH0000,XXNR00,to_char(to_date(FSRQ00,'YYYY.MM.DD'),'YYYY.MM.DD') FSRQ00,YJKSMC FROM VW_BQ_YJYZCZXX a 
 where XXLB00='1'
  and SFLL00='0' 
  and (DQBQ00=939 or DQKS00=939)
 order by XXID00 

14      08:45:33  SQL Execute: ORACLE -  SELECT XXID00 XH0000,XXNR00,to_char(to_date(FSRQ00,'YYYY.MM.DD'),'YYYY.MM.DD') FSRQ00,YJKSMC FROM VW_BQ_YJYZCZXX a 
 where XXLB00='1'
  and SFLL00='0' 
  and (DQBQ00=939 or DQKS00=939)
 order by XXID00 

15      08:46:20  Log started for: Yjsystem