1       09:37:36  SQL Prepare: ORACLE - select * from t_ctltemp    where f_sysid=:1 and f_tempid=:2

2       09:37:36  SQL Execute: ORACLE - select * from t_ctltemp    where f_sysid=? and f_tempid=?

3       09:37:36  SQL Prepare: ORACLE - select * from t_CtlTemp1   where f_sysid=:1 and f_tempid=:2 order by F_Sequence

4       09:37:36  SQL Execute: ORACLE - select * from t_CtlTemp1   where f_sysid=? and f_tempid=? order by F_Sequence

5       09:37:36  SQL Prepare: ORACLE - select * from t_CtlLabel   where f_sysid=:1 and f_tempid=:2 order by F_Sequence

6       09:37:36  SQL Execute: ORACLE - select * from t_CtlLabel   where f_sysid=? and f_tempid=? order by F_Sequence

7       09:37:36  SQL Prepare: ORACLE - select * from t_CtlEdit    where f_sysid=:1 and f_tempid=:2 order by F_Sequence

8       09:37:36  SQL Execute: ORACLE - select * from t_CtlEdit    where f_sysid=? and f_tempid=? order by F_Sequence

9       09:37:36  SQL Prepare: ORACLE - select * from t_CtlDate    where f_sysid=:1 and f_tempid=:2 order by F_Sequence

10      09:37:36  SQL Execute: ORACLE - select * from t_CtlDate    where f_sysid=? and f_tempid=? order by F_Sequence

11      09:37:36  SQL Prepare: ORACLE - select * from t_CtlLine    where f_sysid=:1 and f_tempid=:2 order by F_Sequence

12      09:37:36  SQL Execute: ORACLE - select * from t_CtlLine    where f_sysid=? and f_tempid=? order by F_Sequence

13      09:37:36  SQL Prepare: ORACLE - select * from t_CtlGridCol where f_sysid=:1 and f_tempid=:2 order by F_Sequence

14      09:37:36  SQL Execute: ORACLE - select * from t_CtlGridCol where f_sysid=? and f_tempid=? order by F_Sequence

15      09:37:36  SQL Prepare: ORACLE - select * from t_CtlGrid    where f_sysid=:1 and f_tempid=:2 order by F_Sequence

16      09:37:36  SQL Execute: ORACLE - select * from t_CtlGrid    where f_sysid=? and f_tempid=? order by F_Sequence

17      09:37:36  SQL Prepare: ORACLE - select a.* from t_sqlparams a ,(select f_paramname,min(f_sequence) f_sequence,min(f_paramid) f_paramid from t_sqlparams where f_sysid=:1 and f_tempid=:2 group by f_paramname) b where a.f_sysid=:3 and a.f_tempid=:4 and a.f_sequence=b.f_sequence and a.f_paramid=b.f_paramid order by a.F_Sequence,a.F_ParamID

18      09:37:36  SQL Execute: ORACLE - select a.* from t_sqlparams a ,(select f_paramname,min(f_sequence) f_sequence,min(f_paramid) f_paramid from t_sqlparams where f_sysid=? and f_tempid=? group by f_paramname) b where a.f_sysid=? and a.f_tempid=? and a.f_sequence=b.f_sequence and a.f_paramid=b.f_paramid order by a.F_Sequence,a.F_ParamID

19      09:37:36  SQL Prepare: ORACLE - select * from t_SQLlist    where f_sysid=:1 and f_tempid=:2 order by F_Sequence

20      09:37:36  SQL Execute: ORACLE - select * from t_SQLlist    where f_sysid=? and f_tempid=? order by F_Sequence

21      09:37:36  SQL Prepare: ORACLE - select ZZXKH0,A.ZZYS00,a.ZZYSXM,ZZYSLB,BRTZ00,a.BRID00,A.ZYID00,a.RYCWH0,a.XM0000,a.XB0000,a.ZYH000,a.RYRQ00,ZYE000, a.DQKS00,a.YBZXLB,a.YBBRLB,BRLBJC,YKZYE0,BJJE00,FBMC00,YBMC00,a.FBBH00,a.CSRQ00,a.RYLB00,DQKSMC,a.YKSH00,a.DQLJID,YJJZE0,YBZFJE,a.DBZBM0,a.DBZMC0,A.COLOR0, (SELECT SIGN(COUNT(1)) XZYZ00 FROM VW_BQ_XZYZLL WHERE ZYID00=A.ZYID00 and 'N' = 'Y') XZYZ00,a.BRZJBH,a.BRNL00,a.BRDH00  , (select SF_BQ_GETBRXMXSYS(A.ZYID00) from dual) BRXMYS,XJYE00 ,d.sjryrq ,decode(d.hljbid,'102','特级护理','103','一级护理' ,'104','二级护理','105','三级护理')hljb00 ,a.ryzdmc  from VW_BQ_BRZYXX A,bm_cwk000 b,zy_brxxb0 d  where  d.dqBQ00=60  and a.rycwh0=b.ch0000(+)  and a.zyid00=d.zyid00   order by a.rycwh0

22      09:37:36  SQL Execute: ORACLE - select ZZXKH0,A.ZZYS00,a.ZZYSXM,ZZYSLB,BRTZ00,a.BRID00,A.ZYID00,a.RYCWH0,a.XM0000,a.XB0000,a.ZYH000,a.RYRQ00,ZYE000, a.DQKS00,a.YBZXLB,a.YBBRLB,BRLBJC,YKZYE0,BJJE00,FBMC00,YBMC00,a.FBBH00,a.CSRQ00,a.RYLB00,DQKSMC,a.YKSH00,a.DQLJID,YJJZE0,YBZFJE,a.DBZBM0,a.DBZMC0,A.COLOR0, (SELECT SIGN(COUNT(1)) XZYZ00 FROM VW_BQ_XZYZLL WHERE ZYID00=A.ZYID00 and 'N' = 'Y') XZYZ00,a.BRZJBH,a.BRNL00,a.BRDH00  , (select SF_BQ_GETBRXMXSYS(A.ZYID00) from dual) BRXMYS,XJYE00 ,d.sjryrq ,decode(d.hljbid,'102','特级护理','103','一级护理' ,'104','二级护理','105','三级护理')hljb00 ,a.ryzdmc  from VW_BQ_BRZYXX A,bm_cwk000 b,zy_brxxb0 d  where  d.dqBQ00=60  and a.rycwh0=b.ch0000(+)  and a.zyid00=d.zyid00   order by a.rycwh0

23      09:37:40  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=60 or DQKS00=60)
 order by XXID00 

24      09:37:40  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=60 or DQKS00=60)
 order by XXID00 

25      09:37:50  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=60 or DQKS00=60)
 order by XXID00 

26      09:37:50  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=60 or DQKS00=60)
 order by XXID00 

27      09:38:00  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=60 or DQKS00=60)
 order by XXID00 

28      09:38:00  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=60 or DQKS00=60)
 order by XXID00 

29      09:38:10  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=60 or DQKS00=60)
 order by XXID00 

30      09:38:10  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=60 or DQKS00=60)
 order by XXID00 

31      09:38:20  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=60 or DQKS00=60)
 order by XXID00 

32      09:38:20  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=60 or DQKS00=60)
 order by XXID00 

33      09:38:30  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=60 or DQKS00=60)
 order by XXID00 

34      09:38:30  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=60 or DQKS00=60)
 order by XXID00 

35      09:38:40  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=60 or DQKS00=60)
 order by XXID00 

36      09:38:40  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=60 or DQKS00=60)
 order by XXID00