日期 时间 异常信息 执行时间（ms） SQL 20200921 17:45:51 26 select count(*) from VW_ZY_LJ_MBXX_ZYDZBL a,VW_ZY_LJZRZC_ZYDZBL b where a.LJID00=b.LJID00 and ZYID00=:ZYID00 and nvl(JSRQ00,' ')=' ' and a.LJID00=:LJID00 20200921 17:45:51 26 parameters :ZYID00=2414615 :LJID00=82 20200921 17:46:16 7 SP_ZY_LJ_BRRJ_DZBL 20200921 17:46:16 7 parameters ad_zyid00=2414615 ad_brid00=12764797 ad_ljid00=82 ad_rcid00=320 ad_cjrbh0=537 ad_xgrbh0=537 ad_czlx00=1 ad_jsyy00= ad_ksts00=1 as_ksrq00=20200921 as_yhmsg0= as_sysmsg= 20200921 17:46:19 27 select BH0000 from BM_BMBM00 where BMBH00=:DeptId 20200921 17:46:19 27 parameters DeptId=26 20200921 17:46:19 35 select a.YSZID0,a.YSZMC0,a.SSKSBH,a.SSKSMC,a.YSZZT0 from ZS_YSZ000 a,BM_BMBM00 b where a.SSKSBH=b.BMBH00 and b.BH0000 like '0011%' and b.bmxz00='0' and a.YSZZT0 in ('1','2') order by a.XSXH00,a.yszid0 20200921 17:46:19 27 select YSZID0,YSBH00,YSXM00,YSLB00,YSLB01,YSLB02,YSLB03,YSLB04,YSLB05 from ZS_YSZMX0 where YSZID0=2 and YSBH00=537 20200921 17:46:19 63 select b.YSDJ00,a.YSLB00 from bm_ygbm00 a, BM_YSLB00 b where a.yslb00=b.yslb00 and a.ygbh00=537 20200921 17:46:26 14 select (select c.zwxm00 from bm_ygbm00 c where c.ygbh00=a.szys00)szysxm,a.*,b.bmmc00 DQKSMC from VW_ZS_WGDBL0 a,bm_bmbm00 b where a.DQKSBH = b.bmbh00 and YSZBH0=2 and ( CYDJRQ is null) order by RYCWH0,CYDJRQ 20200921 17:46:27 826 select * from VW_ZS_WCJBL0 where yszid0=2 and ( CYDJRQ is null) order by CYDJRQ,RYCWH0 20200921 17:46:27 11 select * from zy_Brxxb0 where zyid00='2395302' 20200921 17:46:27 41 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='')a 20200921 17:46:27 4 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='' 20200921 17:46:27 13 select * from zy_Brxxb0 where zyid00='2414703' 20200921 17:46:27 4 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='')a 20200921 17:46:27 2 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='' 20200921 17:46:27 12 select * from zy_Brxxb0 where zyid00='2414509' 20200921 17:46:27 6 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350500195807052013')a 20200921 17:46:27 4 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350500195807052013' 20200921 17:46:27 14 select * from zy_Brxxb0 where zyid00='2414657' 20200921 17:46:27 6 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350500194706203535')a 20200921 17:46:27 4 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350500194706203535' 20200921 17:46:27 12 select * from zy_Brxxb0 where zyid00='2415325' 20200921 17:46:27 6 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350322196211244825')a 20200921 17:46:27 5 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350322196211244825' 20200921 17:46:27 12 select * from zy_Brxxb0 where zyid00='2414650' 20200921 17:46:27 6 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='35050019761203202X')a 20200921 17:46:27 4 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='35050019761203202X' 20200921 17:46:27 12 select * from zy_Brxxb0 where zyid00='2412577' 20200921 17:46:27 6 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350524194510240044')a 20200921 17:46:27 5 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350524194510240044' 20200921 17:46:27 13 select * from zy_Brxxb0 where zyid00='2414387' 20200921 17:46:27 6 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='35052119600919251X')a 20200921 17:46:27 5 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='35052119600919251X' 20200921 17:46:27 14 select * from zy_Brxxb0 where zyid00='2414425' 20200921 17:46:27 6 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350500195112152018')a 20200921 17:46:27 4 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350500195112152018' 20200921 17:46:27 11 select * from zy_Brxxb0 where zyid00='2414615' 20200921 17:46:27 5 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350102720809001')a 20200921 17:46:27 5 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350102720809001' 20200921 17:46:27 12 select * from zy_Brxxb0 where zyid00='2414701' 20200921 17:46:27 6 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350500511017251')a 20200921 17:46:27 5 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350500511017251' 20200921 17:46:27 13 select * from zy_Brxxb0 where zyid00='2406154' 20200921 17:46:27 2 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='')a 20200921 17:46:27 3 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='' 20200921 17:46:27 12 select * from zy_Brxxb0 where zyid00='2415831' 20200921 17:46:27 5 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350582193712278525')a 20200921 17:46:27 5 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350582193712278525' 20200921 17:46:27 13 select * from zy_Brxxb0 where zyid00='2413317' 20200921 17:46:27 3 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='')a 20200921 17:46:27 3 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='' 20200921 17:46:27 12 select * from zy_Brxxb0 where zyid00='2411511' 20200921 17:46:27 4 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='')a 20200921 17:46:27 4 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='' 20200921 17:46:27 50 select * from zy_Brxxb0 where zyid00='2406203' 20200921 17:46:27 11 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350582196003216042')a 20200921 17:46:27 6 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350582196003216042' 20200921 17:46:27 13 select * from zy_Brxxb0 where zyid00='2414223' 20200921 17:46:27 8 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350500197306242010')a 20200921 17:46:27 7 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350500197306242010' 20200921 17:46:27 15 select * from zy_Brxxb0 where zyid00='2414057' 20200921 17:46:27 6 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='359002311029051')a 20200921 17:46:27 5 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='359002311029051' 20200921 17:46:27 14 select * from zy_Brxxb0 where zyid00='2414619' 20200921 17:46:27 7 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350500196006300026')a 20200921 17:46:27 6 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350500196006300026' 20200921 17:46:27 12 select * from zy_Brxxb0 where zyid00='2414314' 20200921 17:46:27 5 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350521194510051041')a 20200921 17:46:27 6 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350521194510051041' 20200921 17:46:27 13 select * from zy_Brxxb0 where zyid00='2415506' 20200921 17:46:27 8 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350524193205034020')a 20200921 17:46:27 6 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350524193205034020' 20200921 17:46:27 13 select * from zy_Brxxb0 where zyid00='2414600' 20200921 17:46:27 6 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350500194003020011')a 20200921 17:46:28 6 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350500194003020011' 20200921 17:46:28 13 select * from zy_Brxxb0 where zyid00='2413618' 20200921 17:46:28 2 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='')a 20200921 17:46:28 2 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='' 20200921 17:46:28 13 select * from zy_Brxxb0 where zyid00='2415504' 20200921 17:46:28 4 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='')a 20200921 17:46:28 3 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='' 20200921 17:46:28 13 select * from zy_Brxxb0 where zyid00='2414160' 20200921 17:46:28 6 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350582197211054513')a 20200921 17:46:28 6 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350582197211054513' 20200921 17:46:28 13 select * from zy_Brxxb0 where zyid00='2414437' 20200921 17:46:28 7 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350582194606270567')a 20200921 17:46:28 5 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350582194606270567' 20200921 17:46:28 14 select * from zy_Brxxb0 where zyid00='2415484' 20200921 17:46:28 6 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='35058219430920204X')a 20200921 17:46:28 5 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='35058219430920204X' 20200921 17:46:28 14 select * from zy_Brxxb0 where zyid00='2414406' 20200921 17:46:28 6 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350525193704201010')a 20200921 17:46:28 5 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350525193704201010' 20200921 17:46:28 12 select * from zy_Brxxb0 where zyid00='2414068' 20200921 17:46:28 7 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350500193801271013')a 20200921 17:46:28 6 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350500193801271013' 20200921 17:46:28 15 select * from zy_Brxxb0 where zyid00='2414277' 20200921 17:46:28 6 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350582194909082037')a 20200921 17:46:28 5 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350582194909082037' 20200921 17:46:28 13 select * from zy_Brxxb0 where zyid00='2415701' 20200921 17:46:28 7 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350523320916372')a 20200921 17:46:28 5 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350523320916372' 20200921 17:46:28 18 select * from zy_Brxxb0 where zyid00='2411660' 20200921 17:46:28 6 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350522500814105')a 20200921 17:46:28 6 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350522500814105' 20200921 17:46:28 14 select * from zy_Brxxb0 where zyid00='2415843' 20200921 17:46:28 6 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350583195206123147')a 20200921 17:46:28 5 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350583195206123147' 20200921 17:46:28 14 select * from zy_Brxxb0 where zyid00='2414375' 20200921 17:46:28 7 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='35050019520423204X')a 20200921 17:46:28 6 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='35050019520423204X' 20200921 17:46:28 14 select * from zy_Brxxb0 where zyid00='2414428' 20200921 17:46:28 6 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350500194912262034')a 20200921 17:46:28 4 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350500194912262034' 20200921 17:46:28 12 select * from zy_Brxxb0 where zyid00='2409514' 20200921 17:46:28 3 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='')a 20200921 17:46:28 3 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='' 20200921 17:46:28 13 select * from zy_Brxxb0 where zyid00='2415339' 20200921 17:46:28 5 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350582196111250547')a 20200921 17:46:28 6 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350582196111250547' 20200921 17:46:28 16 select YSZID0,YSBH00,YSXM00,YSLB00,YSLB01,YSLB02,YSLB03,YSLB04,YSLB05 from ZS_YSZMX0 where YSZID0=1 and YSBH00=537 20200921 17:46:28 11 select b.YSDJ00,a.YSLB00 from bm_ygbm00 a, BM_YSLB00 b where a.yslb00=b.yslb00 and a.ygbh00=537 20200921 17:46:32 715 select (select c.zwxm00 from bm_ygbm00 c where c.ygbh00=a.szys00)szysxm,a.*,b.bmmc00 DQKSMC from VW_ZS_WGDBL0 a,bm_bmbm00 b where a.DQKSBH = b.bmbh00 and YSZBH0=1 and ( CYDJRQ is null) order by RYCWH0,CYDJRQ 20200921 17:46:33 838 select * from VW_ZS_WCJBL0 where yszid0=1 and ( CYDJRQ is null) order by CYDJRQ,RYCWH0 20200921 17:46:33 10 select * from zy_Brxxb0 where zyid00='2412386' 20200921 17:46:33 6 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350582194101096022')a 20200921 17:46:33 5 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350582194101096022' 20200921 17:46:33 13 select * from zy_Brxxb0 where zyid00='2415070' 20200921 17:46:33 7 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350102330817045')a 20200921 17:46:33 5 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350102330817045' 20200921 17:46:33 13 select * from zy_Brxxb0 where zyid00='2415530' 20200921 17:46:33 6 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350582196704082016')a 20200921 17:46:33 4 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350582196704082016' 20200921 17:46:33 12 select * from zy_Brxxb0 where zyid00='2415328' 20200921 17:46:33 5 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350582194601131517')a 20200921 17:46:33 5 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350582194601131517' 20200921 17:46:33 15 select * from zy_Brxxb0 where zyid00='2415535' 20200921 17:46:33 6 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350583194012123128')a 20200921 17:46:33 5 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350583194012123128' 20200921 17:46:33 12 select * from zy_Brxxb0 where zyid00='2412556' 20200921 17:46:33 4 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='')a 20200921 17:46:33 3 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='' 20200921 17:46:33 14 select * from zy_Brxxb0 where zyid00='2414433' 20200921 17:46:33 5 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='')a 20200921 17:46:33 3 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='' 20200921 17:46:33 14 select * from zy_Brxxb0 where zyid00='2415537' 20200921 17:46:33 6 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350500196507183534')a 20200921 17:46:33 6 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350500196507183534' 20200921 17:46:33 12 select * from zy_Brxxb0 where zyid00='2415822' 20200921 17:46:33 6 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350500390215152')a 20200921 17:46:33 6 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350500390215152' 20200921 17:46:33 14 select * from zy_Brxxb0 where zyid00='2415630' 20200921 17:46:33 6 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='35052119451017253X')a 20200921 17:46:33 5 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='35052119451017253X' 20200921 17:46:33 12 select * from zy_Brxxb0 where zyid00='2414758' 20200921 17:46:33 7 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350582193108300511')a 20200921 17:46:33 5 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350582193108300511' 20200921 17:46:33 13 select * from zy_Brxxb0 where zyid00='2413252' 20200921 17:46:33 5 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350583421026002')a 20200921 17:46:33 7 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350583421026002' 20200921 17:46:33 14 select * from zy_Brxxb0 where zyid00='2412245' 20200921 17:46:33 6 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350582194306060517')a 20200921 17:46:33 5 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350582194306060517' 20200921 17:46:33 12 select * from zy_Brxxb0 where zyid00='2415951' 20200921 17:46:33 7 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350500196210200524')a 20200921 17:46:33 6 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350500196210200524' 20200921 17:46:33 12 select * from zy_Brxxb0 where zyid00='2415252' 20200921 17:46:33 80 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350582195404031036')a 20200921 17:46:33 7 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350582195404031036' 20200921 17:46:33 12 select * from zy_Brxxb0 where zyid00='2414952' 20200921 17:46:33 6 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350583193510240058')a 20200921 17:46:33 5 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350583193510240058' 20200921 17:46:33 11 select * from zy_Brxxb0 where zyid00='2415403' 20200921 17:46:33 6 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350522195711213538')a 20200921 17:46:33 6 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350522195711213538' 20200921 17:46:33 14 select * from zy_Brxxb0 where zyid00='2415700' 20200921 17:46:33 2 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='')a 20200921 17:46:33 3 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='' 20200921 17:46:33 13 select * from zy_Brxxb0 where zyid00='2413403' 20200921 17:46:33 5 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350525401204051')a 20200921 17:46:33 5 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350525401204051' 20200921 17:46:33 12 select * from zy_Brxxb0 where zyid00='2415402' 20200921 17:46:33 6 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350500197304283521')a 20200921 17:46:33 4 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350500197304283521' 20200921 17:46:33 6 select YSZID0,YSBH00,YSXM00,YSLB00,YSLB01,YSLB02,YSLB03,YSLB04,YSLB05 from ZS_YSZMX0 where YSZID0=7 and YSBH00=537 20200921 17:46:33 3 select b.YSDJ00,a.YSLB00 from bm_ygbm00 a, BM_YSLB00 b where a.yslb00=b.yslb00 and a.ygbh00=537 20200921 17:46:36 624 select (select c.zwxm00 from bm_ygbm00 c where c.ygbh00=a.szys00)szysxm,a.*,b.bmmc00 DQKSMC from VW_ZS_WGDBL0 a,bm_bmbm00 b where a.DQKSBH = b.bmbh00 and YSZBH0=7 and ( CYDJRQ is null) order by RYCWH0,CYDJRQ 20200921 17:46:37 915 select * from VW_ZS_WCJBL0 where yszid0=7 and ( CYDJRQ is null) order by CYDJRQ,RYCWH0 20200921 17:46:37 11 select * from zy_Brxxb0 where zyid00='2415301' 20200921 17:46:37 6 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350521580820751')a 20200921 17:46:37 6 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350521580820751' 20200921 17:46:37 14 select * from zy_Brxxb0 where zyid00='2414227' 20200921 17:46:37 6 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350583195509144922')a 20200921 17:46:37 5 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350583195509144922' 20200921 17:46:37 13 select * from zy_Brxxb0 where zyid00='2413228' 20200921 17:46:37 6 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350500195304196525')a 20200921 17:46:37 5 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350500195304196525' 20200921 17:46:37 12 select * from zy_Brxxb0 where zyid00='2415671' 20200921 17:46:37 6 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350582195001216036')a 20200921 17:46:37 5 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350582195001216036' 20200921 17:46:37 12 select * from zy_Brxxb0 where zyid00='2415334' 20200921 17:46:37 5 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='35058219470218102X')a 20200921 17:46:37 6 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='35058219470218102X' 20200921 17:46:37 12 select * from zy_Brxxb0 where zyid00='2414670' 20200921 17:46:37 74 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350525195303272220')a 20200921 17:46:37 7 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350525195303272220' 20200921 17:46:37 13 select * from zy_Brxxb0 where zyid00='2414864' 20200921 17:46:37 8 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350500195507202040')a 20200921 17:46:37 5 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350500195507202040' 20200921 17:46:37 13 select * from zy_Brxxb0 where zyid00='2414954' 20200921 17:46:37 6 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350500192801230540')a 20200921 17:46:37 6 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350500192801230540' 20200921 17:46:37 13 select * from zy_Brxxb0 where zyid00='2413458' 20200921 17:46:37 7 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='352601421215701')a 20200921 17:46:37 4 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='352601421215701' 20200921 17:46:37 12 select * from zy_Brxxb0 where zyid00='2415803' 20200921 17:46:37 7 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350583740616004')a 20200921 17:46:37 6 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350583740616004' 20200921 17:46:37 12 select * from zy_Brxxb0 where zyid00='2413557' 20200921 17:46:37 7 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350583451211375')a 20200921 17:46:38 6 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350583451211375' 20200921 17:46:38 13 select * from zy_Brxxb0 where zyid00='2414065' 20200921 17:46:38 7 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350582196410011095')a 20200921 17:46:38 5 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350582196410011095' 20200921 17:46:38 13 select * from zy_Brxxb0 where zyid00='2415955' 20200921 17:46:38 7 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350500193611213541')a 20200921 17:46:38 5 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350500193611213541' 20200921 17:46:38 5 select YSZID0,YSBH00,YSXM00,YSLB00,YSLB01,YSLB02,YSLB03,YSLB04,YSLB05 from ZS_YSZMX0 where YSZID0=21 and YSBH00=537 20200921 17:46:38 4 select b.YSDJ00,a.YSLB00 from bm_ygbm00 a, BM_YSLB00 b where a.yslb00=b.yslb00 and a.ygbh00=537 20200921 17:46:39 856 select (select c.zwxm00 from bm_ygbm00 c where c.ygbh00=a.szys00)szysxm,a.*,b.bmmc00 DQKSMC from VW_ZS_WGDBL0 a,bm_bmbm00 b where a.DQKSBH = b.bmbh00 and YSZBH0=21 and ( CYDJRQ is null) order by RYCWH0,CYDJRQ 20200921 17:46:40 772 select * from VW_ZS_WCJBL0 where yszid0=21 and ( CYDJRQ is null) order by CYDJRQ,RYCWH0 20200921 17:46:40 10 select * from zy_Brxxb0 where zyid00='2415054' 20200921 17:46:40 7 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350321197308143041')a 20200921 17:46:40 8 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350321197308143041' 20200921 17:46:40 7 select YSZID0,YSBH00,YSXM00,YSLB00,YSLB01,YSLB02,YSLB03,YSLB04,YSLB05 from ZS_YSZMX0 where YSZID0=25 and YSBH00=537 20200921 17:46:40 2 select b.YSDJ00,a.YSLB00 from bm_ygbm00 a, BM_YSLB00 b where a.yslb00=b.yslb00 and a.ygbh00=537 20200921 17:46:42 602 select (select c.zwxm00 from bm_ygbm00 c where c.ygbh00=a.szys00)szysxm,a.*,b.bmmc00 DQKSMC from VW_ZS_WGDBL0 a,bm_bmbm00 b where a.DQKSBH = b.bmbh00 and YSZBH0=25 and ( CYDJRQ is null) order by RYCWH0,CYDJRQ 20200921 17:46:42 502 select * from VW_ZS_WCJBL0 where yszid0=25 and ( CYDJRQ is null) order by CYDJRQ,RYCWH0 20200921 17:46:44 933 select a.*,null as ispath FROM VW_ZS_HZBR00_DZBL a WHERE (INSTR(HZKS00,';26;')>0 or INSTR(HZYS00,';537;')>0) and a.HZJSBZ<>'2' and a.BRZT00 like '2%' order by a.SSKSMC,a.YSZID0, a.RYCWH0 20200921 17:46:47 71 SELECT a.*,b.*, NULL AS ispath FROM vw_zs_wgdbl0 a,zs_ysz000 b WHERE a.yszbh0=b.yszid0 and a.blzt00 in('2','5') AND exists(SELECT zyid00 FROM bq_brldxx WHERE zyid00=a.zyid00 and dqksbh <> ksh000 AND ksh000 =26) AND (cydjrq IS NULL) order by B.SSKSMC,B.YSZID0, a.RYCWH0 20200921 17:46:47 69 select count(1) from ZS_YSZ000 where (yszid0 in (select yszid0 from zs_yszmx0 where ysbh00 = '537') or ssksbh not in (select bmbh00 from xt_yhbmqx where ygbh00 = '537' and xtdm00 = 'V')) and yszid0 in (select distinct(yszid0) from zy_brxxb0 where zyid00 in (SELECT DISTINCT(ZYID00) FROM ZS_BLWS00 D WHERE D.CJYSBH = '537' and wszt00 <>'3' and (SJCYRQ is null))) 20200921 17:46:47 71 SELECT DISTINCT ZYID00,SQYSZ0,SFYX00,SQYSBH,SQCZY0,B.YSZZT0 FROM ZS_BLWSSQ A INNER JOIN ZS_YSZ000 B ON A.SQYSZ0=B.YSZID0 WHERE SFYX00<>'0' AND SQYSBH=537 20200921 17:46:47 4 select BH0000 from BM_BMBM00 where BMBH00=:DeptId 20200921 17:46:47 4 parameters DeptId=26 20200921 17:46:47 7 select YSZID0,YSZMC0,SSKSBH,SSKSMC,YSZZT0 from ZS_YSZ000,BM_BMBM00 where BH0000 like '0011%' and (YSZZT0='1' or YSZZT0='2') and ZS_YSZ000.SSKSBH=BM_BMBM00.BMBH00 order by YSZZT0,XSXH00,yszid0 20200921 17:46:47 89 select * from bq_brldxx where zyid00='2395302' order by ldlsh0 desc 20200921 17:46:47 17 select * from yj_brgmjl where zcbz00='N' and brid00=0 20200921 17:46:47 129 select JKID00,a.ZYID00,JKMC00,JKZT00,YLSJ00,SJJSRQ,SJJSSJ,SJ0000,YBTXSJ,YZTXSJ,WCRQ00,WCSJ00,ZDYSDJ,ZGYSDJ,a.BLXMBH,f.WSID00,JKLX00, ZRKSBH,ZRKSMC,ZRYSZB,ZRYSZM,JKZT00,c.XM0000,c.MRN000,c.RYCWH0,b.DQKSBH BMBH00,d.BMMC00,b.YSZBH0,b.YSZMC0,b.RYRQ00,b.RYSJ00, c.CYDJRQ,c.CYDJSJ,a.CGSJBZ,f.WSMC00,f.CJRQ00,f.CJSJ00,f.TJRQ00,f.TJSJ00,f.WSZT00,c.zyh000 from ZS_BLJK00 a inner join ZS_BLXX01 b on a.ZYID00=b.ZYID00 inner join ZY_BRXXB0 c on a.ZYID00=c.ZYID00 inner join BM_BMBM00 d on b.DQKSBH=d.BMBH00 left join ZS_BLWS00 f on a.WSID00=f.WSID00 where JKZT00='0' and a.ZYID00 in(2414615) and ZDYSDJ<=1 and (ZGYSDJ=-1 or ZGYSDJ>=1) 20200921 17:46:47 13 select a.ZXKSRQ,a.ZXJSRQ from LJ_JDZXQK a inner join LJ_ZRZC00 b on a.ZRZCID=b.ZRZCID where b.ZYID00=2414615 and b.JSRQ00 is null and a.JDLX00='2' and a.JDZT00='0' 20200921 17:46:47 26 select ID0000,ZT0000 from ZS_DPFKD0 where ZT0000<>'5' and ZYID00 in(2414615) 20200921 17:46:47 21 select * from bq_brldxx where zyid00='2414615' order by ldlsh0 desc 20200921 17:46:47 6 select * from yj_brgmjl where zcbz00='N' and brid00=12764797 20200921 17:46:47 184 select A.BRID00,decode((select count(1) from LJ_ZRZC00 where nvl(jsfs00,' ')=' ' and zyid00=b.zyid00),0,'0','1') sfljbr, nvl((select max(decode(JSFS00,'',LJID00,-1)) from LJ_ZRZC00 where ZYID00=b.ZYID00 and (nvl(JSRQ00,' ')=' ' or JSFS00 in('完成','强制退出'))),0) as DQLJID,a.tssxmc,B.MRN000,A.YBLB00,BRXM00,BRXB00,BRXX00,RH0000,BRCSRQ,BRHYZK,BRZY00,BRMZ00,BRGJ00,BRZJLX,BRZJBH,A.FBBH00,FBMC00,BRJTDZ,BRYB00,BRDH00,BRLXGX,BRLXXM,BRLXDZ,BRLXDH,BRZTQK,BRJKQK,BRLX00,CZY000,a.CZRQ00,a.CZSJ00,ZYZT00,A.SFYX00,A.BZ0000,BRSZSF,BRSZS0,SWRQ00,SWSJ00,B.ZYID00,b.ZYH000, nvl(F.RYRQ00,b.RYRQ00) RYRQ00,nvl(F.RYSJ00,b.RYSJ00) RYSJ00,RYCZY0,CZYXM0,RYZD00,RYSQK0,RYBQ00,RZKS00,YSZID0,RYCWH0,DQBQ00,DQKS00,b.CYRQ00,b.CYSJ00,CYDJRQ,CYDJSJ,CYCZY0,CYYGXM,B.BRZT00 as BRZYZT,SZYS00,RYZDMC,BRRYCS,A.TYDWID,A.TYDWMC,A.TYDWYB,B.YBKH00,A.YBID00,ZWXM00,E.YBMC00,B.YBZYH0,B.ZZYS00,B.ZZYSXM,B.ZRYS00,B.ZRYSXM,B.SXYS00,B.SXYSXM, (select ZDMC00 from(select * from BQ_BRZDXX where ZYID00=:ZYID00 and zdlb00='2' ORDER BY ZDRQ00,ZDSJ00 ASC ) WHERE rownum=1 ) ZDMC00, F.BLZT00,A.Brszsf,A.brszs0,A.brszc0,A.brszz0,A.brxzsf,A.brxzs0,A.brxzz0,A.brxzc0,A.BRBLH0,A.BRTZ00,SF_ZS_CSRQSJTONL(BRCSRQ,BRCSSJ,SJRYRQ) BRNL00,SJCYRQ,SJCYSJ,b.DBZBM0,b.DBZMC0,b.ZRZYBZ from BM_BRXXB0 A inner join ZY_BRXXB0 B on A.BRID00=B.BRID00 left join BM_BRFBB0 C on A.FBBH00=C.FBBH00 left join Bm_Ygbm00 D on D.Ygbh00=B.SZYS00 and CZBZ00<>'2' AND (INSTR(YGXZ00,'0')>0 OR INSTR(YGXZ00,'1')>0) left join ZS_BLXX01 F on F.ZYID00=B.ZYID00 left join IC_YBBRLB E on E.FBBH00=B.FBBH00 and E.yblb00=B.yblb00 where B.ZYID00=2414615 20200921 17:46:47 184 parameters :ZYID00=2414615 20200921 17:46:47 7 select bmmc00 from bm_bmbm00 where bmbh00=:bmbh00 20200921 17:46:47 7 parameters :bmbh00=26 20200921 17:46:47 36 SELECT brid00,zyid00,jsxh00,yexm00,yecsrq,yecssj,yc0000,cc0000,fmfs00,ts0000,hypl00,hyzs00,syts00,yeqk00,apgar0,yexb00,yetz00,yesg00,jsr000 FROM BQ_JSXX00 WHERE zyid00= :ZYID00 20200921 17:46:47 36 parameters :ZYID00=2414615 20200921 17:46:48 752 SELECT qyyshs ,a.* FROM VW_ZS_YZLL00_ZYDZBL a where 1=1 and zyid00=:zyid00 and clbz00=:clbz00 and (yzzt00 in ('0','1','2','5','9','7') or (yzzt00 in ('3','4') and tzrq00 = to_char(sysdate,'YYYYMMDD'))) and lb0000=:lb0000 order by Clbz00 desc, CZPC00,QYRQ00,QYSJ00 ,PXSJ00,YZID00,YZMXID 20200921 17:46:48 752 parameters :zyid00=2414615 :clbz00=0 :lb0000=0 20200921 17:46:48 10 select b.ryzd00,b.ryzdmc,a.bz0000 from BM_TYZD00 a,ZY_BRXXB0 b where b.brid00='12764797' and a.bzdybh=trim(b.ryzd00) and a.zdmc00 = '疾病抗生素使用天数限制' 20200921 17:46:48 11 select t.bz0000,b.ypmc00,b.yzmxid from bm_tyzd00 t,BQ_YPYZMX b where B.YZID00 in('34333602','34333604','34333606','34333606','34333606','34333617','34333617','34333672','34333672','34356316') and TO_NUMBER(t.bzdybh)=b.ypnm00 and t.bzdybh>='0' and t.bzdybh<='999999' and t.zdmc00='抗生素药物使用天数限制' 20200921 17:46:48 168 select nvl(sum(HJJE00),0) ZJE000 from ZY_BRFY00 where ZYID00=2414615 20200921 17:46:49 325 select nvl(sum(a.HJJE00),0) hjje00 from zy_fymx00 a , ZY_BRFY00 b where a.djh000=b.djh000 and a.xmbh00>=9999999997 and b.ZYID00=2414615 20200921 17:46:49 8 select nvl(sum(a.HJJE00),0) hjje00 from zy_fymx00 a , ZY_BRFY00 b where a.djh000=b.djh000 and a.xmbh00+0=9999999999 and b.ZYID00=2414615 20200921 17:46:49 8 select nvl(sum(a.HJJE00),0) hjje00 from zy_fymx00 a , ZY_BRFY00 b where a.djh000=b.djh000 and a.xmbh00<9999999997 and b.ZYID00=2414615 20200921 17:46:49 20 select YXQFJE from ZY_BRZHXX where BRID00=12764797 20200921 17:46:49 43 select nvl(sum(jfje00),0) jfje00 from ZY_BRJFB0 where JFLBID = 2 and jzdh00 = 0 and ZYID00=2414615 20200921 17:46:49 14 select * from zy_Brxxb0 where zyid00='2414615' 20200921 17:46:49 7 select * from zy_Brxxb0 where zyid00='2414615' 20200921 17:46:49 340 select * from ZY_BRZHXX where zyid00='2414615' 20200921 17:46:49 237 SELECT zyid00,brid00,mrn000,zyh000,ybzyh0,xm0000,xb0000,csrq00,fbbh00,lbbh00,ryrq00,rysj00,ryczy0,czyxm0,ryzd00,rysqk0,rylb00,rybq00,rzks00,rycwh0,dqbq00,dqks00,rcyfh0,cyrq00,cysj00,cyczy0,cyygxm,zzys00,zzysxm,zrys00,zrysxm,sxys00,sxysxm,hljbid,brrycs,brzt00,brhyzk,brzy00,brmz00,brjtdz,bryb00,tydwmc,brnl00,brgj00,ybzxlb,ybbrlb,brlbjc,kyje00,fbmc00,bjje00,ykzye0,sjye00 FROM VW_ZS_WTJBR0_ZYDZBL WHERE zyid00=:ZYID00 20200921 17:46:49 237 parameters :ZYID00=2414615 20200921 17:46:49 7 SELECT zyid00,brid00,mrn000,zyh000,ybzyh0,xm0000,xb0000,csrq00,fbbh00,lbbh00,ryrq00,rysj00,ryczy0,czyxm0,ryzd00,rysqk0,rylb00,rybq00,rzks00,rycwh0,dqbq00,dqks00,rcyfh0,cyrq00,cysj00,cyczy0,cyygxm,zzys00,zzysxm,zrys00,zrysxm,sxys00,sxysxm,hljbid,brrycs,brzt00,brhyzk,brzy00,brmz00,brjtdz,bryb00,tydwmc,brnl00,brgj00,ybzxlb,ybbrlb,brlbjc,kyje00,fbmc00,bjje00,ykzye0,sjye00 FROM VW_ZS_WTJBR0_ZYDZBL WHERE zyid00=:ZYID00 20200921 17:46:49 7 parameters :ZYID00=2414615 20200921 17:46:49 12 SELECT t.ypmc00,t.ypnm00 FROM YJ_BRGMJL T WHERE t.jgms00 like '%+%' and t.brid00='12764797' 20200921 17:46:50 42 select BJYZBL　 from ZS_BJYZBL where YBZXLB='1' 20200921 17:46:50 16 select count(1) from (select a.zxrq00 from BQ_YPYZ00 a where a.yfid00 = '005' and a.zyid00 = '2414615' and To_Date(a.zxrq00, 'yyyymmdd') <=(SELECT To_Date(max(t.zxrq00), 'yyyymmdd') FROM BQ_YPYZ00 t where t.yfid00 = '005' and t.zyid00 ='2414615' group by t.zyid00) and To_Date(a.zxrq00, 'yyyymmdd') >= (SELECT To_Date(max(t.zxrq00), 'yyyymmdd') - 100 FROM BQ_YPYZ00 t where t.yfid00 = '005' and t.zyid00 = '2414615' group by t.zyid00) group by a.zxrq00 order by a.zxrq00) 20200921 17:46:50 20 SELECT nvl(dzblh0,zyid00) DZBLH0 FROM ZS_BLXX01 WHERE ZYID00=:ZYID00 Order by CJRQ00 20200921 17:46:50 20 parameters :ZYID00=2414615 20200921 17:46:50 37 select BLXMID,BLXMMC,ZXZDDJ,ZXZGDJ,SHZDDJ,SHZGDJ,SFWY00,BLXZ00,BLGS00,XNJD00,XGSJ00,DYXS00,YBTXSJ,YZTXSJ,ZXSJ00,XGSJ00,SHSJ00,WSBGMC,WSRQH0,WSRQL0,WSSJH0,WSSJL0,XMFL00,MBXYSH,BCPDF0,WSXGQX from ZS_BLZCXM where XMZT00='1' order by PLXH00,BLXZ00 20200921 17:46:50 98 SELECT A.WSID00 WSID00,A.ZYID00 ZYID00,A.BLXMBH BLXMBH,A.WSMC00 WSMC00,A.MBBH00 MBBH00,E.MBMC00,A.CJYSBH CJYSBH,A.CJYSXM CJYSXM,A.CJRQ00 CJRQ00,A.CJSJ00 CJSJ00,A.SFXYSH SFXYSH,A.YGBZ00 YGBZ00,A.WSZT00 WSZT00,A.TJRQ00 TJRQ00,A.TJSJ00 TJSJ00,A.ZXRDJ0 ZXRDJ0,A.SHRDJ0 SHRDJ0,A.XGZBH0 XGZBH0,A.XGZXM0 XGZXM0,A.XGZDJ0 XGZDJ0,A.XGRQ00 XGRQ00,A.XGSJ00 XGSJ00,A.XGZBH1 XGZBH1,A.XGZXM1 XGZXM1,A.XGZDJ1 XGZDJ1,A.XGRQ01 XGRQ01,A.XGSJ01 XGSJ01,A.DYRBH0 DYRBH0,A.DYRXM0 DYRXM0,A.DYRQ00 DYRQ00,A.DYSJ00 DYSJ00,A.ZHZBH0 ZHZBH0,A.ZHZXM0 ZHZXM0,A.ZHZDJ0 ZHZDJ0,A.ZHRQ00 ZHRQ00,A.ZHSJ00 ZHSJ00,null XMLNR0,null CDA000,A.DQDKYS DQDKYS, A.WJMC00 WJMC00,A.PXRQ00 PXRQ00,A.PXSJ00 PXSJ00,A.JMHSJ0 JMHSJ0,A.GZRQ00 GZRQ00,A.GZSJ00 GZSJ00,C.RYRQ00 RYRQ00,A.WSHBID WSHBID,A.WSQYMC WSQYMC,A.SFHBWS SFHBWS,D.HBWJMC HBWJMC,D.HBWSMC HBWSMC FROM ZS_BLWS00 A,ZS_BLXX01 B,ZY_BRXXB0 C, ZS_WSHBXX D,ZS_BLMB01 E where A.ZYID00 = B.ZYID00 and a.wszt00<>'3' and A.zyid00 = C.zyid00 and A.WSHBID = D.WSHBID(+) and A.MBBH00=E.MBID00(+) and B.ZYID00 = 2414615 ORDER BY SUBSTRB(A.BLXMBH, 1, 1), A.PXRQ00, substr(A.PXSJ00, 1, 5), A.CJSJ00 20200921 17:46:50 7 select BLXMID,BLXMMC,ZXZDDJ,ZXZGDJ,SHZDDJ,SHZGDJ,SFWY00,BLXZ00,BLGS00,XNJD00,XGSJ00,DYXS00,YBTXSJ,YZTXSJ,ZXSJ00,XGSJ00,SHSJ00,WSBGMC,WSRQH0,WSRQL0,WSSJH0,WSSJL0,XMFL00,MBXYSH,BCPDF0,WSXGQX from ZS_BLZCXM where XMZT00='1' order by PLXH00,BLXZ00 20200921 17:46:50 6 select BLXMID,BLXMMC,ZXZDDJ,ZXZGDJ,SHZDDJ,SHZGDJ,SFWY00,BLXZ00,BLGS00,XNJD00,XGSJ00,DYXS00,YBTXSJ,YZTXSJ,ZXSJ00,XGSJ00,SHSJ00,WSBGMC,WSRQH0,WSRQL0,WSSJH0,WSSJL0,XMFL00,MBXYSH,BCPDF0,WSXGQX from ZS_BLZCXM where XMZT00='1' order by PLXH00,BLXZ00 20200921 17:46:50 7 select BLXMID,BLXMMC,ZXZDDJ,ZXZGDJ,SHZDDJ,SHZGDJ,SFWY00,BLXZ00,BLGS00,XNJD00,XGSJ00,DYXS00,YBTXSJ,YZTXSJ,ZXSJ00,XGSJ00,SHSJ00,WSBGMC,WSRQH0,WSRQL0,WSSJH0,WSSJL0,XMFL00,MBXYSH,BCPDF0,WSXGQX from ZS_BLZCXM where XMZT00='1' order by PLXH00,BLXZ00 20200921 17:46:50 51 select WSID00,ZYID00,BLXMBH,WSMC00,MBBH00,CJYSBH,CJYSXM,CJRQ00,CJSJ00,SFXYSH,YGBZ00,WSZT00,TJRQ00,TJSJ00,ZXRDJ0,SHRDJ0,XGZBH0,XGZXM0,XGZDJ0,c.XGRQ00,c.XGSJ00,XGZBH1,XGZXM1,XGZDJ1,c.XGRQ01,c.XGSJ01,DYRBH0,DYRXM0,DYRQ00,DYSJ00,ZHZBH0,ZHZXM0,ZHZDJ0,ZHRQ00,ZHSJ00,PXRQ00,PXSJ00, DQDKYS,WJMC00,JMHSJ0,GZRQ00,GZSJ00 from zs_blws00 c where wszt00<>'3' and exists (select 1 from BM_TYZD00 b where b.ZDMC00='医生护士文书合并列表' and c.BLXMBH =b.BH0000 ) and zyid00=2414615 20200921 17:46:50 60 select distinct HLDLB0 displayname,to_char(HLDLB0) cmbvalue from BQ_BRTZXX A,BQ_TZLB00 B where A.TZLBID = B.TZLBID and ZYID00 =2414615 20200921 17:46:50 248 SELECT WSID00,ZYID00,BLXMBH,WSMC00,MBBH00,CJYSBH,CJYSXM,CJRQ00,CJSJ00,SFXYSH,YGBZ00,WSZT00,TJRQ00,TJSJ00,ZXRDJ0,SHRDJ0,XGZBH0,XGZXM0,XGZDJ0,XGRQ00,XGSJ00,XGZBH1,XGZXM1,XGZDJ1,XGRQ01,XGSJ01,DYRBH0,DYRXM0,DYRQ00,DYSJ00,ZHZBH0,ZHZXM0,ZHZDJ0,ZHRQ00,ZHSJ00,SYS.XMLTYPE.GETCLOBVAL(XMLNR0) XMLNR0,SYS.XMLTYPE.GETCLOBVAL(CDA000) CDA000,DQDKYS, WJMC00,PXRQ00,PXSJ00,JMHSJ0,GZRQ00,GZSJ00 FROM ZS_BLWS00 WHERE WSZT00<>'3' AND ZYID00=2414615 and BLXMBH in (select BLXZ00 from zs_blzcxm where wslb00='1' ) ORDER BY SUBSTRB(BLXMBH,1,1),BLXMBH,PXRQ00,PXSJ00 20200921 17:46:50 7 select count(*) from bq_brtzxx where tzlbid in (select TZLBID from BQ_TZLB00 where HLDLB0='15') and ZYID00='2414615' 20200921 17:46:50 6 select count(*) from bq_brtzxx where tzlbid in (select TZLBID from BQ_TZLB00 where HLDLB0='8') and ZYID00='2414615' 20200921 17:46:50 6 select count(*) from bq_brtzxx where tzlbid in (select TZLBID from BQ_TZLB00 where HLDLB0='23') and ZYID00='2414615' 20200921 17:46:50 6 select count(*) from bq_brtzxx where tzlbid in (select TZLBID from BQ_TZLB00 where HLDLB0='6') and ZYID00='2414615' 20200921 17:46:50 6 select count(*) from bq_brtzxx where tzlbid in (select TZLBID from BQ_TZLB00 where HLDLB0='4') and ZYID00='2414615' 20200921 17:46:50 83 select count(*) from bq_brtzxx where tzlbid in (select TZLBID from BQ_TZLB00 where HLDLB0='19') and ZYID00='2414615' 20200921 17:46:50 9 select count(*) from bq_brtzxx where tzlbid in (select TZLBID from BQ_TZLB00 where HLDLB0='18') and ZYID00='2414615' 20200921 17:46:50 6 select count(*) from bq_brtzxx where tzlbid in (select TZLBID from BQ_TZLB00 where HLDLB0='25') and ZYID00='2414615' 20200921 17:46:50 5 select count(*) from bq_brtzxx where tzlbid in (select TZLBID from BQ_TZLB00 where HLDLB0='7') and ZYID00='2414615' 20200921 17:46:50 7 select count(*) from bq_brtzxx where tzlbid in (select TZLBID from BQ_TZLB00 where HLDLB0='0') and ZYID00='2414615' 20200921 17:46:50 6 select count(*) from bq_brtzxx where tzlbid in (select TZLBID from BQ_TZLB00 where HLDLB0='12') and ZYID00='2414615' 20200921 17:46:50 6 select count(*) from bq_brtzxx where tzlbid in (select TZLBID from BQ_TZLB00 where HLDLB0='5') and ZYID00='2414615' 20200921 17:46:50 6 select count(*) from bq_brtzxx where tzlbid in (select TZLBID from BQ_TZLB00 where HLDLB0='24') and ZYID00='2414615' 20200921 17:46:50 7 select count(*) from bq_brtzxx where tzlbid in (select TZLBID from BQ_TZLB00 where HLDLB0='17') and ZYID00='2414615' 20200921 17:46:50 7 select count(*) from bq_brtzxx where tzlbid in (select TZLBID from BQ_TZLB00 where HLDLB0='22') and ZYID00='2414615' 20200921 17:46:50 7 select count(*) from bq_brtzxx where tzlbid in (select TZLBID from BQ_TZLB00 where HLDLB0='3') and ZYID00='2414615' 20200921 17:46:50 6 select count(*) from bq_brtzxx where tzlbid in (select TZLBID from BQ_TZLB00 where HLDLB0='2') and ZYID00='2414615' 20200921 17:46:50 5 select count(*) from bq_brtzxx where tzlbid in (select TZLBID from BQ_TZLB00 where HLDLB0='9') and ZYID00='2414615' 20200921 17:46:50 6 select to_char(ZDMC00||'|'||MC0000) displayname,to_char(to_char(BZ0000)) cmbvalue from BM_TYZD00 where ZDMC00='外部链接调用地址' and YXBZ00='1' order by XSXH00 20200921 17:46:50 8 select * from bm_tyzd00 where ZDMC00='处方点评查阅'