日期 时间 异常信息 执行时间（ms） SQL 20200921 17:43:59 2 select BH0000 from BM_BMBM00 where BMBH00=:DeptId 20200921 17:43:59 2 parameters DeptId=26 20200921 17:43:59 10 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:43:59 6 select YSZID0,YSBH00,YSXM00,YSLB00,YSLB01,YSLB02,YSLB03,YSLB04,YSLB05 from ZS_YSZMX0 where YSZID0=2 and YSBH00=537 20200921 17:43:59 11 select b.YSDJ00,a.YSLB00 from bm_ygbm00 a, BM_YSLB00 b where a.yslb00=b.yslb00 and a.ygbh00=537 20200921 17:44:04 729 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:44:05 3 select * from VW_ZS_WCJBL0 where yszid0=2 and ( CYDJRQ is null) order by CYDJRQ,RYCWH0 20200921 17:44:05 13 select * from zy_Brxxb0 where zyid00='2395302' 20200921 17:44:05 25 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='')a 20200921 17:44:05 6 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='' 20200921 17:44:05 12 select * from zy_Brxxb0 where zyid00='2414703' 20200921 17:44:05 4 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='')a 20200921 17:44:05 3 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='' 20200921 17:44:05 15 select * from zy_Brxxb0 where zyid00='2414509' 20200921 17:44:05 5 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350500195807052013')a 20200921 17:44:05 5 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350500195807052013' 20200921 17:44:05 12 select * from zy_Brxxb0 where zyid00='2414657' 20200921 17:44:05 5 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350500194706203535')a 20200921 17:44:05 5 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350500194706203535' 20200921 17:44:05 13 select * from zy_Brxxb0 where zyid00='2415325' 20200921 17:44:05 6 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350322196211244825')a 20200921 17:44:05 5 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350322196211244825' 20200921 17:44:05 13 select * from zy_Brxxb0 where zyid00='2414650' 20200921 17:44:05 5 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='35050019761203202X')a 20200921 17:44:05 5 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='35050019761203202X' 20200921 17:44:05 12 select * from zy_Brxxb0 where zyid00='2412577' 20200921 17:44:05 7 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350524194510240044')a 20200921 17:44:05 5 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350524194510240044' 20200921 17:44:05 12 select * from zy_Brxxb0 where zyid00='2414387' 20200921 17:44:05 5 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='35052119600919251X')a 20200921 17:44:05 5 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='35052119600919251X' 20200921 17:44:05 13 select * from zy_Brxxb0 where zyid00='2414425' 20200921 17:44:05 5 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350500195112152018')a 20200921 17:44:05 4 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350500195112152018' 20200921 17:44:05 13 select * from zy_Brxxb0 where zyid00='2414615' 20200921 17:44:05 6 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350102720809001')a 20200921 17:44:05 5 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350102720809001' 20200921 17:44:05 13 select * from zy_Brxxb0 where zyid00='2414701' 20200921 17:44:05 6 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350500511017251')a 20200921 17:44:05 4 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350500511017251' 20200921 17:44:05 12 select * from zy_Brxxb0 where zyid00='2406154' 20200921 17:44:05 3 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='')a 20200921 17:44:05 2 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='' 20200921 17:44:05 13 select * from zy_Brxxb0 where zyid00='2415831' 20200921 17:44:05 7 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350582193712278525')a 20200921 17:44:05 5 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350582193712278525' 20200921 17:44:05 12 select * from zy_Brxxb0 where zyid00='2413317' 20200921 17:44:05 3 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='')a 20200921 17:44:05 3 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='' 20200921 17:44:05 14 select * from zy_Brxxb0 where zyid00='2411511' 20200921 17:44:05 3 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='')a 20200921 17:44:05 3 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='' 20200921 17:44:05 12 select * from zy_Brxxb0 where zyid00='2406203' 20200921 17:44:05 5 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350582196003216042')a 20200921 17:44:05 4 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350582196003216042' 20200921 17:44:05 13 select * from zy_Brxxb0 where zyid00='2414223' 20200921 17:44:05 7 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350500197306242010')a 20200921 17:44:05 5 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350500197306242010' 20200921 17:44:05 13 select * from zy_Brxxb0 where zyid00='2414057' 20200921 17:44:05 6 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='359002311029051')a 20200921 17:44:05 5 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='359002311029051' 20200921 17:44:05 15 select * from zy_Brxxb0 where zyid00='2414619' 20200921 17:44:05 5 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350500196006300026')a 20200921 17:44:05 4 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350500196006300026' 20200921 17:44:05 12 select * from zy_Brxxb0 where zyid00='2414314' 20200921 17:44:05 6 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350521194510051041')a 20200921 17:44:05 5 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350521194510051041' 20200921 17:44:05 88 select * from zy_Brxxb0 where zyid00='2415506' 20200921 17:44:05 7 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350524193205034020')a 20200921 17:44:05 4 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350524193205034020' 20200921 17:44:05 13 select * from zy_Brxxb0 where zyid00='2414600' 20200921 17:44:05 6 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350500194003020011')a 20200921 17:44:05 6 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350500194003020011' 20200921 17:44:05 13 select * from zy_Brxxb0 where zyid00='2413618' 20200921 17:44:05 2 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='')a 20200921 17:44:05 3 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='' 20200921 17:44:05 13 select * from zy_Brxxb0 where zyid00='2415504' 20200921 17:44:06 2 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='')a 20200921 17:44:06 3 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='' 20200921 17:44:06 13 select * from zy_Brxxb0 where zyid00='2414160' 20200921 17:44:06 6 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350582197211054513')a 20200921 17:44:06 5 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350582197211054513' 20200921 17:44:06 12 select * from zy_Brxxb0 where zyid00='2414437' 20200921 17:44:06 6 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350582194606270567')a 20200921 17:44:06 5 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350582194606270567' 20200921 17:44:06 13 select * from zy_Brxxb0 where zyid00='2415484' 20200921 17:44:06 5 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='35058219430920204X')a 20200921 17:44:06 6 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='35058219430920204X' 20200921 17:44:06 12 select * from zy_Brxxb0 where zyid00='2414406' 20200921 17:44:06 5 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350525193704201010')a 20200921 17:44:06 6 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350525193704201010' 20200921 17:44:06 14 select * from zy_Brxxb0 where zyid00='2414068' 20200921 17:44:06 6 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350500193801271013')a 20200921 17:44:06 5 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350500193801271013' 20200921 17:44:06 14 select * from zy_Brxxb0 where zyid00='2414277' 20200921 17:44:06 7 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350582194909082037')a 20200921 17:44:06 6 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350582194909082037' 20200921 17:44:06 11 select * from zy_Brxxb0 where zyid00='2415701' 20200921 17:44:06 6 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350523320916372')a 20200921 17:44:06 5 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350523320916372' 20200921 17:44:06 13 select * from zy_Brxxb0 where zyid00='2411660' 20200921 17:44:06 6 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350522500814105')a 20200921 17:44:06 5 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350522500814105' 20200921 17:44:06 13 select * from zy_Brxxb0 where zyid00='2415843' 20200921 17:44:06 6 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350583195206123147')a 20200921 17:44:06 5 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350583195206123147' 20200921 17:44:06 13 select * from zy_Brxxb0 where zyid00='2414375' 20200921 17:44:06 5 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='35050019520423204X')a 20200921 17:44:06 5 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='35050019520423204X' 20200921 17:44:06 12 select * from zy_Brxxb0 where zyid00='2414428' 20200921 17:44:06 7 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350500194912262034')a 20200921 17:44:06 5 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350500194912262034' 20200921 17:44:06 13 select * from zy_Brxxb0 where zyid00='2409514' 20200921 17:44:06 3 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='')a 20200921 17:44:06 3 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='' 20200921 17:44:06 12 select * from zy_Brxxb0 where zyid00='2415339' 20200921 17:44:06 5 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350582196111250547')a 20200921 17:44:06 6 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350582196111250547' 20200921 17:44:06 7 select YSZID0,YSBH00,YSXM00,YSLB00,YSLB01,YSLB02,YSLB03,YSLB04,YSLB05 from ZS_YSZMX0 where YSZID0=1 and YSBH00=537 20200921 17:44:06 3 select b.YSDJ00,a.YSLB00 from bm_ygbm00 a, BM_YSLB00 b where a.yslb00=b.yslb00 and a.ygbh00=537 20200921 17:44:09 135 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:44:10 692 select * from VW_ZS_WCJBL0 where yszid0=1 and ( CYDJRQ is null) order by CYDJRQ,RYCWH0 20200921 17:44:10 12 select * from zy_Brxxb0 where zyid00='2412386' 20200921 17:44:10 6 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350582194101096022')a 20200921 17:44:10 5 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350582194101096022' 20200921 17:44:10 12 select * from zy_Brxxb0 where zyid00='2415070' 20200921 17:44:10 6 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350102330817045')a 20200921 17:44:10 5 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350102330817045' 20200921 17:44:10 12 select * from zy_Brxxb0 where zyid00='2415530' 20200921 17:44:10 6 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350582196704082016')a 20200921 17:44:10 4 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350582196704082016' 20200921 17:44:10 11 select * from zy_Brxxb0 where zyid00='2415328' 20200921 17:44:10 7 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350582194601131517')a 20200921 17:44:10 5 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350582194601131517' 20200921 17:44:10 12 select * from zy_Brxxb0 where zyid00='2415535' 20200921 17:44:10 6 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350583194012123128')a 20200921 17:44:10 6 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350583194012123128' 20200921 17:44:10 12 select * from zy_Brxxb0 where zyid00='2412556' 20200921 17:44:10 3 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='')a 20200921 17:44:10 2 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='' 20200921 17:44:10 15 select * from zy_Brxxb0 where zyid00='2414433' 20200921 17:44:10 3 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='')a 20200921 17:44:10 4 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='' 20200921 17:44:10 13 select * from zy_Brxxb0 where zyid00='2415537' 20200921 17:44:10 6 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350500196507183534')a 20200921 17:44:10 4 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350500196507183534' 20200921 17:44:10 14 select * from zy_Brxxb0 where zyid00='2415822' 20200921 17:44:10 6 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350500390215152')a 20200921 17:44:10 4 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350500390215152' 20200921 17:44:10 13 select * from zy_Brxxb0 where zyid00='2415630' 20200921 17:44:10 6 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='35052119451017253X')a 20200921 17:44:10 5 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='35052119451017253X' 20200921 17:44:10 12 select * from zy_Brxxb0 where zyid00='2414758' 20200921 17:44:10 5 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350582193108300511')a 20200921 17:44:10 5 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350582193108300511' 20200921 17:44:10 13 select * from zy_Brxxb0 where zyid00='2413252' 20200921 17:44:10 5 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350583421026002')a 20200921 17:44:10 7 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350583421026002' 20200921 17:44:10 12 select * from zy_Brxxb0 where zyid00='2412245' 20200921 17:44:10 6 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350582194306060517')a 20200921 17:44:10 5 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350582194306060517' 20200921 17:44:10 14 select * from zy_Brxxb0 where zyid00='2415951' 20200921 17:44:10 7 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350500196210200524')a 20200921 17:44:10 13 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350500196210200524' 20200921 17:44:10 13 select * from zy_Brxxb0 where zyid00='2415252' 20200921 17:44:10 5 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350582195404031036')a 20200921 17:44:10 6 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350582195404031036' 20200921 17:44:10 14 select * from zy_Brxxb0 where zyid00='2414952' 20200921 17:44:10 7 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350583193510240058')a 20200921 17:44:10 5 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350583193510240058' 20200921 17:44:10 33 select * from zy_Brxxb0 where zyid00='2415403' 20200921 17:44:11 7 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350522195711213538')a 20200921 17:44:11 5 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350522195711213538' 20200921 17:44:11 13 select * from zy_Brxxb0 where zyid00='2415700' 20200921 17:44:11 2 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='')a 20200921 17:44:11 2 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='' 20200921 17:44:11 13 select * from zy_Brxxb0 where zyid00='2413403' 20200921 17:44:11 6 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350525401204051')a 20200921 17:44:11 5 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350525401204051' 20200921 17:44:11 12 select * from zy_Brxxb0 where zyid00='2415402' 20200921 17:44:11 6 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350500197304283521')a 20200921 17:44:11 5 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350500197304283521' 20200921 17:44:11 7 select YSZID0,YSBH00,YSXM00,YSLB00,YSLB01,YSLB02,YSLB03,YSLB04,YSLB05 from ZS_YSZMX0 where YSZID0=7 and YSBH00=537 20200921 17:44:11 2 select b.YSDJ00,a.YSLB00 from bm_ygbm00 a, BM_YSLB00 b where a.yslb00=b.yslb00 and a.ygbh00=537 20200921 17:44:13 557 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:44:14 658 select * from VW_ZS_WCJBL0 where yszid0=7 and ( CYDJRQ is null) order by CYDJRQ,RYCWH0 20200921 17:44:14 9 select * from zy_Brxxb0 where zyid00='2415301' 20200921 17:44:14 4 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350521580820751')a 20200921 17:44:14 5 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350521580820751' 20200921 17:44:14 11 select * from zy_Brxxb0 where zyid00='2414227' 20200921 17:44:14 6 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350583195509144922')a 20200921 17:44:14 4 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350583195509144922' 20200921 17:44:14 11 select * from zy_Brxxb0 where zyid00='2413228' 20200921 17:44:14 6 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350500195304196525')a 20200921 17:44:14 6 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350500195304196525' 20200921 17:44:14 12 select * from zy_Brxxb0 where zyid00='2415671' 20200921 17:44:14 5 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350582195001216036')a 20200921 17:44:14 5 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350582195001216036' 20200921 17:44:14 12 select * from zy_Brxxb0 where zyid00='2415334' 20200921 17:44:14 8 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='35058219470218102X')a 20200921 17:44:14 5 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='35058219470218102X' 20200921 17:44:14 12 select * from zy_Brxxb0 where zyid00='2414670' 20200921 17:44:14 6 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350525195303272220')a 20200921 17:44:14 5 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350525195303272220' 20200921 17:44:14 12 select * from zy_Brxxb0 where zyid00='2414864' 20200921 17:44:14 6 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350500195507202040')a 20200921 17:44:14 5 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350500195507202040' 20200921 17:44:14 13 select * from zy_Brxxb0 where zyid00='2414954' 20200921 17:44:14 6 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350500192801230540')a 20200921 17:44:14 5 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350500192801230540' 20200921 17:44:14 12 select * from zy_Brxxb0 where zyid00='2413458' 20200921 17:44:14 6 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='352601421215701')a 20200921 17:44:14 5 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='352601421215701' 20200921 17:44:14 12 select * from zy_Brxxb0 where zyid00='2415803' 20200921 17:44:14 6 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350583740616004')a 20200921 17:44:14 4 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350583740616004' 20200921 17:44:14 14 select * from zy_Brxxb0 where zyid00='2413557' 20200921 17:44:14 6 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350583451211375')a 20200921 17:44:14 5 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350583451211375' 20200921 17:44:14 11 select * from zy_Brxxb0 where zyid00='2414065' 20200921 17:44:14 6 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350582196410011095')a 20200921 17:44:14 3 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350582196410011095' 20200921 17:44:14 14 select * from zy_Brxxb0 where zyid00='2415955' 20200921 17:44:14 5 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350500193611213541')a 20200921 17:44:14 5 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350500193611213541' 20200921 17:44:14 6 select YSZID0,YSBH00,YSXM00,YSLB00,YSLB01,YSLB02,YSLB03,YSLB04,YSLB05 from ZS_YSZMX0 where YSZID0=21 and YSBH00=537 20200921 17:44:14 4 select b.YSDJ00,a.YSLB00 from bm_ygbm00 a, BM_YSLB00 b where a.yslb00=b.yslb00 and a.ygbh00=537 20200921 17:44:16 71 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:44:17 728 select * from VW_ZS_WCJBL0 where yszid0=21 and ( CYDJRQ is null) order by CYDJRQ,RYCWH0 20200921 17:44:17 14 select * from zy_Brxxb0 where zyid00='2415054' 20200921 17:44:17 5 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350321197308143041')a 20200921 17:44:17 5 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350321197308143041' 20200921 17:44:17 6 select YSZID0,YSBH00,YSXM00,YSLB00,YSLB01,YSLB02,YSLB03,YSLB04,YSLB05 from ZS_YSZMX0 where YSZID0=25 and YSBH00=537 20200921 17:44:17 2 select b.YSDJ00,a.YSLB00 from bm_ygbm00 a, BM_YSLB00 b where a.yslb00=b.yslb00 and a.ygbh00=537 20200921 17:44:19 417 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:44:19 696 select * from VW_ZS_WCJBL0 where yszid0=25 and ( CYDJRQ is null) order by CYDJRQ,RYCWH0 20200921 17:44:22 260 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:44:24 876 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:44:24 52 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:44:24 13 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:44:24 2 select BH0000 from BM_BMBM00 where BMBH00=:DeptId 20200921 17:44:24 2 parameters DeptId=26 20200921 17:44:24 9 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:44:24 38 select * from bq_brldxx where zyid00='2395302' order by ldlsh0 desc 20200921 17:44:24 15 select * from yj_brgmjl where zcbz00='N' and brid00=0 20200921 17:44:25 855 select a.ZYID00 from ZS_BLXX01 a inner join ZY_BRXXB0 b on a.ZYID00=b.ZYID00 where a.YSZBH0=2 and BRZT00='4' and (sysdate - 1) < (to_date(CYDJRQ || CYDJSJ, 'yyyymmddhh24:mi:ss')) 20200921 17:44:25 35 select JKID00,ZS_BLJK00.ZYID00,JKMC00,YLSJ00,SJJSRQ,SJJSSJ,SJ0000,YBTXSJ,YZTXSJ,ZDYSDJ,ZGYSDJ,BLXMBH,WSID00,JKLX00,ZY_BRXXB0.XM0000,ZRKSBH,ZRKSMC,ZRYSZB,ZRYSZM,ZY_BRXXB0.RYCWH0,JKZT00,WCRQ00,WCSJ00 from ZS_BLJK00 inner join ZY_BRXXB0 on ZS_BLJK00.ZYID00=ZY_BRXXB0.ZYID00 inner join ZS_BLXX01 on ZS_BLJK00.ZYID00=ZS_BLXX01.ZYID00 where JKZT00='0' and (ZS_BLXX01.BLZT00='1' or ZS_BLXX01.BLZT00='2') and SJJSRQ > to_char((sysdate - 15),'YYYYMMDD') and ZS_BLXX01.YSZBH0=2 and ZDYSDJ<=1 and (ZGYSDJ=-1 or ZGYSDJ>=1) 20200921 17:44:25 42 select ID0000,ZT0000 from ZS_DPFKD0 where ZT0000<>'5' and ZYID00 in(2395302,2414703,2414509,2414657,2415325,2414650,2412577,2414387,2414425,2414615,2414701,2406154,2415831,2413317,2411511,2406203,2414223,2414057,2414619,2414314,2415506,2414600,2413618,2415504,2414160,2414437,2415484,2414406,2414068,2414277,2415701,2411660,2415843,2414375,2414428,2409514,2415339)