1       10:16:15  SQL Execute: ORACLE - select ZT0000 from BM_CKBM00 WHERE CKBH00=192

2       10:16:15  SQL Execute: ORACLE - Select SYSDATE from Dual

3       10:16:15  SQL Execute: ORACLE - select Value0 from XT_XTCS00 where NAME00 = 'IC_BBH'

4       10:16:15  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')

5       10:16:15  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-MMRK'
and KLDH00 not in ('CK','JMCK')

6       10:16:15  SQL Execute: ORACLE - select ICKH00,YGBH00,BRID00,KMH000,ZT0000 from IC_YHXX00
where ICKH00 = 'PTYBPT00200581366'
and ICKNBH = 'PTYBPT00200581366'

7       10:16:15  SQL Execute: ORACLE - select * from vw_ys_brxxb0 where BRID00=12453724

8       10:16:15  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1052.000000
9       10:16:15  SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2078.000000
10      10:16:15  SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 12453724.000000
11      10:16:15  SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1052.000000
12      10:16:15  SQL Data In: ORACLE - Param = 5, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2078.000000
13      10:16:15  SQL Data In: ORACLE - Param = 6, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 12453724.000000
14      10:16:15  SQL Execute: ORACLE - SELECT HZXHMC FROM vw_ys_hzbr00 WHERE jzks00=? and jzys00=? and BRID00=?  Union all 
select HZXHMC FROM vw_ys_yzbr00 WHERE jzks00=? and jzys00=? and BRID00=? 

15      10:16:15  SQL Execute: ORACLE - select GHYXM0 from vw_ys_hzbr00
 where brid00=12453724
 and jzks00=1052 and jzys00=2078
 and dlxh00>0
 union all
 select GHYXM0 from vw_ys_yzbr00
 where brid00=12453724
 and jzks00=1052 and jzys00=2078
 and dlxh00>0

16      10:16:15  SQL Execute: ORACLE - select TZBZ00 from SF_YSGHHB where GHKSBH=1052 and GHYSBH=2078 and GHMZSJ=TO_CHAR(sysdate,'YYYYMMDD')
 AND GHJSSJ>=to_char((sysdate-2/48),'HH24:mi:ss')
 AND GHQSSJ<=to_char((sysdate+2/48),'HH24:mi:ss')

17      10:16:15  SQL Execute: ORACLE - select TZBZ00 from SF_YSGHHB where GHKSBH=1052 and GHYSBH=2078 and GHMZSJ=TO_CHAR(sysdate,'YYYYMMDD')
 AND GHJSSJ>=to_char((sysdate-2/48),'HH24:mi:ss')
 AND GHQSSJ<=to_char((sysdate+2/48),'HH24:mi:ss')

18      10:16:15  SQL Execute: ORACLE - select GHLBBH,GHLBMC,GHXHS0,GHYGHS from SF_YSGHHB where GHKSBH=1052 and GHYSBH=2078 and GHMZSJ=TO_CHAR(sysdate,'YYYYMMDD') and GHQSSJ<=TO_CHAR(sysdate,'HH24:MI:SS') and GHJSSJ>=TO_CHAR(sysdate,'HH24:MI:SS')

19      10:16:15  SQL Execute: ORACLE - select SF_MZHS_YBZXXZYSCFQX(12453724,2078) MSG000 from dual 

20      10:16:15  SQL Execute: ORACLE -  select MKDM00,MKNBMC from XT_XTMK00 where XTDM00='D' and MKNBMC='MZHS_QZJCZHQX' and ( 
 (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 
 where XTDM00='D' and ZBDM00 in ( select ZBDM00 from 
 VW_XT_YHZB00 where YGBH00=2))))

21      10:16:15  SQL Execute: ORACLE - select LBMC00,LBBH00 from VW_YS_GHLBB0
 where  LBBH00=-99999

22      10:16:15  SQL Execute: ORACLE - select HZLBMC,HZLB00 from BM_HZLB00
 where  HZLB00<>3

23      10:16:15  SQL Execute: ORACLE - select b.SFJE00 from sf_ghf000 a,bm_yysfxm b where a.SFXMID=b.SFXMID and a.GFLB00='-99999'
union all
select FJFFJE   from vw_ys_fjghf0 where FJBRLB='0' and FJGHKS='713' and FJGHLB='-99999'

24      10:16:15  SQL Execute: ORACLE - SELECT NVL(MAX(HZXH00),0) HZXH00 FROM YS_HBHZXH WHERE GHHBID=181316 AND BRID00 IS NOT NULL 
 and YYBZ00<>'2' 

25      10:16:15  SQL Execute: ORACLE - SELECT NVL(MAX(HZXH00),0) HZXH00 FROM YS_HBHZXH WHERE GHHBID=181316 
 and YYBZ00<>'2' 

26      10:16:15  SQL Execute: ORACLE - SELECT NVL(Min(HZXH00),0) HZXH00 FROM YS_HBHZXH WHERE GHHBID=181316 and HZXH00 between 93 and 150
 and YYBZ00<>'2' 

27      10:16:15  SQL Execute: ORACLE - SELECT GHHBID,BRID00,BRXM00,HZXH00,YYBZ00,YYID00,HZQSSJ FROM YS_HBHZXH WHERE GHHBID=181316
 ORDER BY HZXH00

28      10:16:16  SQL Execute: ORACLE - SELECT COUNT(1) COUNT0 FROM YS_XXJL00 WHERE HSFZT0=77 AND FSRQ00=TO_CHAR(SYSDATE,'YYYYMMDD') AND SFLL00='0' AND BZ0000='0'

29      10:29:52  Log started for: SQL Navigator for Oracle
30      10:30:16  Log started for: 门诊护士工作站