1 15:43:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 1913 2 15:43:19 SQL Execute: ORACLE - select a.YSLB00,nvl(b.YSLBMC,'未设置') YSLBMC,nvl(b.SCJKDJ,'A') SCJKDJ from BM_YGBM00 a,BM_YSLB00 b where a.YGBH00=? and a.YSLB00=b.YSLB00(+) 3 15:43:19 SQL Execute: ORACLE - Select * from VW_BM_YPZJYF where zjyfmc like '煎%' and rownum=1 4 15:43:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 1913 5 15:43:19 SQL Execute: ORACLE - select CFJB00,GZDJ00,MZDJ00,DPDJ00,SJDJ00,KSSJB0 from BM_YGBM00 where YGBH00=? 6 15:43:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 3 7 15:43:19 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 8 15:43:19 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 9 15:43:19 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 10 15:43:19 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 11 15:43:19 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 12 15:43:19 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 13 15:43:19 SQL Execute: ORACLE - select count(1) from VW_YS_DMYPSR where CFJB00 <=? and GZDJ00 <=? and MZDJ00 <=? and DPDJ00 <=? and KSSDJ0<=? and ((SJDJ00 >=? and ? >'0') or SJDJ00='0') and Rownum=1 14 15:43:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 1913 15 15:43:19 SQL Execute: ORACLE - select BMBH00 from bm_ygbm00 where YGBH00=? 16 15:43:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 474 17 15:43:19 SQL Execute: ORACLE - select jkbh01 from bm_bmbm00 where bmbh00=? 18 15:43:19 SQL Execute: ORACLE - Select * from (select distinct YJBH00,YJBHMC,BZ0000 from VW_YS_ZLXMSTRUCTURE where SFXS00='Y' ) order by BZ0000 19 15:43:19 SQL Execute: ORACLE - Select * from (select distinct YJBH00,YJBHMC,BZ0000 from VW_YS_ZLXMSTRUCTURE where SFXS00='Y' ) order by BZ0000 20 15:43:19 SQL Execute: ORACLE - Select * from (select distinct YJBH00,YJBHMC,BZ0000 from VW_YS_ZLXMSTRUCTURE where SFXS00='Y' ) order by BZ0000 21 15:43:19 SQL Execute: ORACLE - Select * from (select distinct YJBH00,YJBHMC,BZ0000 from VW_YS_ZLXMSTRUCTURE where SFXS00='Y' ) order by BZ0000 22 15:43:19 SQL Execute: ORACLE - select count(*) CD0000 from BM_ZDMS00 23 15:43:19 SQL Execute: ORACLE - select ZDMSMC,ZDMSH0 from BM_ZDMS00 where 1=1 order by ZDMSH0 24 15:43:19 SQL Execute: ORACLE - select MKDM00,MKNBMC from XT_XTMK00 where XTDM00='8' and MKDM00='8Z01' and ( (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='8' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=1913)))) 25 15:43:19 SQL Execute: ORACLE - select NBBH00,MC0000,BZ0000 from BM_TYZD00 where ZDMC00='医生预约' and YXBZ00='1' and BZ0000 is not null order by XSXH00 26 15:43:19 SQL Execute: ORACLE - select 1 from IC_KLDM00 where KLDH00 not in ('CK','JMCK','ALL','YY-ALL','YB-ALL') 27 15:43:19 SQL Execute: ORACLE - select KLDH00 from IC_KLDM00 where KLDH00 in ('CK','JMCK') and rownum=1 28 15:43:19 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 where NAME00='XT_SGLRKH' and rownum=1 29 15:43:19 SQL Execute: ORACLE - select zyzbmc,zyzbid from bm_jyzyzb 30 15:43:19 SQL Execute: ORACLE - select BMMC00,YFBMBH from VW_XT_XYFWFX where SLBMBH=474 and sign(instrb('0',YFBMBH))=0 order by mrbz00 desc 31 15:43:19 SQL Execute: ORACLE - select BMMC00,YFBMBH from vw_XT_CYFWFX where SLBMBH=474 and sign(instrb('0',YFBMBH))=0 order by mrbz00 desc 32 15:43:19 SQL Execute: ORACLE - select BMMC00,YFBMBH from (select * from VW_XT_XYFWFX union select * from VW_XT_cYFWFX) where SLBMBH=474 and sign(instrb('0',YFBMBH))=0 order by mrbz00 desc,PX0000 33 15:43:19 SQL Execute: ORACLE - select Value0,DM0000 from xt_zd0000 where zdbm00='SZ0000' 34 15:43:19 SQL Execute: ORACLE - select Value0,DM0000 from xt_zd0000 where zdbm00='ST0000' 35 15:43:19 SQL Execute: ORACLE - select Value0,DM0000 from xt_zd0000 where zdbm00='MX0000' 36 15:43:19 SQL Execute: ORACLE - select Value0,DM0000 from xt_zd0000 where zdbm00='SZ0000' 37 15:43:19 SQL Execute: ORACLE - select Value0,DM0000 from xt_zd0000 where zdbm00='ST0000' 38 15:43:19 SQL Execute: ORACLE - select Value0,DM0000 from xt_zd0000 where zdbm00='MX0000' 39 15:43:19 SQL Execute: ORACLE - select SQDMC0,SQDID0 from YS_SQDGS0 40 15:43:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 1913 41 15:43:19 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 474 42 15:43:19 SQL Execute: ORACLE - Select sum(GHXHS0),sum(GHYGHS) from sf_ysghhb where ghmzsj=to_char(sysdate,'yyyymmdd') and ghysbh=? and ghksbh=? 43 15:43:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 1913 44 15:43:19 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 474 45 15:43:19 SQL Execute: ORACLE - select count(*) from sf_brxxb0 where thbz00='2' and to_char(sysdate,'yyyymmdd')=jzrq00 and ghlb00<>-99999 and jzys00=? and jzks00=? 46 15:43:19 SQL Execute: ORACLE - select 1 from XT_YHCS00 where NAME00 = 'YS_zdjz00' and value0 = '0' and YGBH00 = 1913 47 15:43:19 SQL Execute: ORACLE - SELECT BMBH00 FROM BM_BMBM00 WHERE BMMC00 = '检验科' 48 15:43:19 SQL Execute: ORACLE - select MC0000,XXZDID from BM_BRXXZD where ZDLB00='1' AND SFMRZ0='0' 49 15:43:19 SQL Execute: ORACLE - select MC0000,XXZDID from BM_BRXXZD where ZDLB00='2' AND SFMRZ0='0' 50 15:43:19 SQL Execute: ORACLE - select MC0000,XXZDID from BM_BRXXZD where ZDLB00='3' AND SFMRZ0='0' 51 15:43:19 SQL Execute: ORACLE - select MC0000,XXZDID from BM_BRXXZD where ZDLB00='4' AND SFMRZ0='0' 52 15:43:19 SQL Execute: ORACLE - select MZCFLB from BM_YGBM00 where YGBH00=1913