1 14:02:39 SQL Prepare: ORACLE - select count(1) ss,C.LBMC00 from YF_MZCF00 B,BM_YPLB00 C where 1=1 and B.CFZT00 in( '0','5') and b.brid00=477247 and B.YPDLBH=C.LBBH00 group by C.LBMC00 2 14:02:39 SQL Execute: ORACLE - select count(1) ss,C.LBMC00 from YF_MZCF00 B,BM_YPLB00 C where 1=1 and B.CFZT00 in( '0','5') and b.brid00=477247 and B.YPDLBH=C.LBBH00 group by C.LBMC00 3 14:02:39 SQL Stmt: ORACLE - Fetch 4 14:02:39 SQL Stmt: ORACLE - EOF 5 14:02:39 SQL Stmt: ORACLE - Reset 6 14:02:39 SQL Stmt: ORACLE - Close 7 14:02:39 SQL Prepare: ORACLE - select count(1) ss,C.LBMC00,B.SRRQ00 from YF_MZCF00 B,BM_YPLB00 C where 1=1 and B.CFZT00 = '1' and b.brid00=477247 and B.YPDLBH=C.LBBH00 and b.bccfh0 is null group by C.LBMC00,B.SRRQ00 8 14:02:39 SQL Execute: ORACLE - select count(1) ss,C.LBMC00,B.SRRQ00 from YF_MZCF00 B,BM_YPLB00 C where 1=1 and B.CFZT00 = '1' and b.brid00=477247 and B.YPDLBH=C.LBBH00 and b.bccfh0 is null group by C.LBMC00,B.SRRQ00 9 14:02:39 SQL Stmt: ORACLE - Fetch 10 14:02:39 SQL Stmt: ORACLE - EOF 11 14:02:39 SQL Stmt: ORACLE - Reset 12 14:02:39 SQL Stmt: ORACLE - Close 13 14:02:39 SQL Prepare: ORACLE - select * from YF_MZCF00 A,sf_brfy00 B,yf_mzcf00 C,BM_YPLB00 d where 1 = 1 and B.BRID00=477247 and A.CFZT00 IN('0','5') and A.BCCFH0 = C.CFLSH0 and B.DJH000 = C.DJH000 and B.JZDH00+0 <> 0 and A.YPDLBH=D.LBBH00 14 14:02:39 SQL Execute: ORACLE - select * from YF_MZCF00 A,sf_brfy00 B,yf_mzcf00 C,BM_YPLB00 d where 1 = 1 and B.BRID00=477247 and A.CFZT00 IN('0','5') and A.BCCFH0 = C.CFLSH0 and B.DJH000 = C.DJH000 and B.JZDH00+0 <> 0 and A.YPDLBH=D.LBBH00 15 14:02:39 SQL Blob IO: ORACLE - Return blob data 16 14:02:39 SQL Stmt: ORACLE - Fetch 17 14:02:39 SQL Stmt: ORACLE - EOF 18 14:02:39 SQL Stmt: ORACLE - Reset 19 14:02:39 SQL Stmt: ORACLE - Close 20 14:02:39 SQL Prepare: ORACLE - select A.*,g.LBMC00 zlxmjc_1 from VW_SF_YJYW00 A,BM_ZLZD00 H,BM_ZLXMLB G where 1=1 and EXISTS (SELECT 1 FROM YJ_YW0000 C,SF_BRFY00 B WHERE A.GHID00=C.ZYGHID AND A.CXDJH0 = C.YJDJH0 AND C.SFDJH0 = B.DJH000 AND B.JZDH00>0 ) AND A.ZLXMID=H.ZLXMID and G.LBBH00=H.lbbh00 and A.SFDJH0+0 = 0 and a.BRID00=477247 21 14:02:39 SQL Execute: ORACLE - select A.*,g.LBMC00 zlxmjc_1 from VW_SF_YJYW00 A,BM_ZLZD00 H,BM_ZLXMLB G where 1=1 and EXISTS (SELECT 1 FROM YJ_YW0000 C,SF_BRFY00 B WHERE A.GHID00=C.ZYGHID AND A.CXDJH0 = C.YJDJH0 AND C.SFDJH0 = B.DJH000 AND B.JZDH00>0 ) AND A.ZLXMID=H.ZLXMID and G.LBBH00=H.lbbh00 and A.SFDJH0+0 = 0 and a.BRID00=477247 22 14:02:39 SQL Blob IO: ORACLE - Return blob data 23 14:02:39 SQL Stmt: ORACLE - Fetch 24 14:02:39 SQL Stmt: ORACLE - EOF 25 14:02:39 SQL Stmt: ORACLE - Reset 26 14:02:39 SQL Stmt: ORACLE - Close 27 14:02:39 SQL Prepare: ORACLE - select count(1) ss,e.bmmc00,d.kdysxm,d.zlxmjc ZLXMJC,G.zlxmjc ZLXMJC_1,D.KDRQ00 from YJ_YW0000 D,bm_bmbm00 e,XT_KSZXXM f,BM_ZLZD00 G,BM_ZLZD00 H where 1=1 and d.MZZYBZ='0' and D.yjksbh=F.zxksbh and D.XMZT00 in( '1','2') and (0=0 or d.KDRQ00>=to_char(sysdate-0,'YYYYMMDD')) and D.brid00=477247 and G.lbbz00=0 and H.lbbz00=1 and G.zlxmid=H.lbbh00 and d.zlxmid=h.zlxmid and f.ZXKSBH=e.bmbh00 and d.zlxmid=f.ZLXMID group by e.bmmc00,d.kdysxm,d.zlxmjc,G.zlxmjc,D.KDRQ00 28 14:02:39 SQL Execute: ORACLE - select count(1) ss,e.bmmc00,d.kdysxm,d.zlxmjc ZLXMJC,G.zlxmjc ZLXMJC_1,D.KDRQ00 from YJ_YW0000 D,bm_bmbm00 e,XT_KSZXXM f,BM_ZLZD00 G,BM_ZLZD00 H where 1=1 and d.MZZYBZ='0' and D.yjksbh=F.zxksbh and D.XMZT00 in( '1','2') and (0=0 or d.KDRQ00>=to_char(sysdate-0,'YYYYMMDD')) and D.brid00=477247 and G.lbbz00=0 and H.lbbz00=1 and G.zlxmid=H.lbbh00 and d.zlxmid=h.zlxmid and f.ZXKSBH=e.bmbh00 and d.zlxmid=f.ZLXMID group by e.bmmc00,d.kdysxm,d.zlxmjc,G.zlxmjc,D.KDRQ00 29 14:02:39 SQL Stmt: ORACLE - Fetch 30 14:02:39 SQL Data Out: ORACLE - Column = 1, Name = SS, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.000000 31 14:02:39 SQL Data Out: ORACLE - Column = 2, Name = BMMC00, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 病理科 32 14:02:39 SQL Data Out: ORACLE - Column = 3, Name = KDYSXM, Type = fldZSTRING, Precision = 40, Scale = 0, Data = 测试人员9 33 14:02:39 SQL Data Out: ORACLE - Column = 4, Name = ZLXMJC, Type = fldZSTRING, Precision = 106, Scale = 0, Data = 电子胃镜 34 14:02:39 SQL Data Out: ORACLE - Column = 5, Name = ZLXMJC_1, Type = fldZSTRING, Precision = 200, Scale = 0, Data = 检查 35 14:02:39 SQL Data Out: ORACLE - Column = 6, Name = KDRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20240716 36 14:02:39 SQL Stmt: ORACLE - Fetch 37 14:02:39 SQL Stmt: ORACLE - EOF 38 14:02:39 SQL Stmt: ORACLE - Reset